Update customer configuration file

Declare invalid values; l_rec_profile values; l_profile_amt_id number; l_profile_id number; 1_varchar2 (30); l_msg_count1 number; l_msg_data1 varchar2 (2000); 1_varchar2 (30); l_msg_count2 number; rochelle msg_data2 varchar2 (2000); Rochelle object_version_number number; begin/* alter Sessi On set nls_language = 'American '; */mo_global.init ('ar'); fnd_global.apps_initialize (user_id => 1250, resp_id => 50719, resp_appl_id => 20005); usage: = 1040; rows: = 1042; -- CXY-TEST0028660/* l_rec_profile_t.status: = 'a'; l_rec_profile_t.collector_id: = NULL; l_rec_profile_t.credit_analyst_id: = NULL; l_rec_profile_t.credit_checking: = NULL; condition: = NULL; l_rec_profile_t.tolerance: = NULL; condition: = NULL; l_rec_profile_t.interest_charges: = NULL; l_rec_profile_t.send_statements: = NULL; condition: = NULL; */l_rec_profile_t.credit_hold: = 'n';/* l_rec_profile_t.profile_class_id: = NULL; l_rec_prof Ile_t.site_use_id: = 420072; -- bill_to empty: = NULL; l_rec_profile_t.risk_code: = NULL; l_rec_profile_t.standard_terms: = NULL; condition: = NULL; l_rec_profile_t.discount_grace_days: = NULL; l_rec_profile_t.statement _ Cycle_id: = NULL; l_rec_profile_t.account_status: = NULL; condition: = NULL; l_rec_profile_t.tax_printing_option: = NULL; condition: = NULL; l_rec_profile_t.clearing_days: = NULL; l_rec_profile_t. Cons_inv_flag: = NULL; l_rec_profile_t.cons_inv_type: = NULL; Response: = 'blc'; l_rec_profile_t.application_id: = NULL; Response: = NULL; response: = NULL; l_rec_profile_t.party_id: = NULL; l_rec_profile_t.credit_class Ification: = NULL; l_rec_profile_t.cons_bill_level: = NULL; condition: = NULL; l_rec_profile_t.late_charge_type: = NULL; condition: = NULL; rochelle rec_profile_t.hold_charged_invoices_flag: = NULL; L_rec_profile_t.message_text_id: = NULL; delimiter: = NULL; l_rec_profile_t.automatch_set_id: = NULL; */l_object_version_number: = 5; -- This value must be the value of the current configuration file, the API verifies the following/* if not (p_object_version_number is null and l_object_version_number is null) or (p_object_version_number is not null and l_object_version_number is not null and P_object_version_number = l_object_version_number) Then fnd_message.set_name ('ar ', 'hz _ api_record_changed'); values ('table', 'hz _ customer_profiles '); values; Raise files; this record cannot be locked because another user has updated the record in the hz_customer_profiles table. End if; */else (rows => rows, rows => rows, p_object_version_number => l_object_version_number, x_return_status => rows, x_msg_count => l_msg_count1, x_msg_data => l_msg_data1 ); for I in 1 .. l_msg_count1 loop l_msg_data1: = fnd_msg_pub.get (p_msg_index => I, p_encoded => 'F'); End loop; -- for I in 1 .. x_msg_count loop values ('x _ return_status1: '| l_return_status1); dbms_output.put_line ('L _ msg_count1:' | l_msg_count1); values ('L _ msg_data1: '| l_msg_data1); dbms_output.put_line ('L _ profile_amt_id:' | l_profile_amt_id); Exception when others then equals ('x _ return_status: '| sqlerrm); end;

Update customer configuration file