[Home] [Help]
143:
144:
145: --mo_global.init('AR');
146: --mo_global.set_policy_context('S',204);
147: --arp_standard.enable_debug;
148: --arp_standard.enable_file_debug('/appslog/fin_top/utl/finixud/out','ATREC54a.log');
149:
150:
151:
144:
145: --mo_global.init('AR');
146: --mo_global.set_policy_context('S',204);
147: --arp_standard.enable_debug;
148: --arp_standard.enable_file_debug('/appslog/fin_top/utl/finixud/out','ATREC54a.log');
149:
150:
151:
152:
149:
150:
151:
152:
153: l_request_id := arp_standard.profile.request_id;
154: l_apply_fail := 'N';
155: l_pay_process_fail := 'N';
156:
157:
155: l_pay_process_fail := 'N';
156:
157:
158: IF PG_DEBUG in ('Y', 'C') THEN
159: arp_standard.debug('autorecapi start ()+');
160: arp_standard.debug( 'value of p_errbuf ' || P_ERRBUF);
161: arp_standard.debug( 'value of p_retcode ' || (P_RETCODE));
162: arp_standard.debug( 'value of p_process_type ' || p_process_type);
163: arp_standard.debug( 'value of p_create_flag ' || p_create_flag);
156:
157:
158: IF PG_DEBUG in ('Y', 'C') THEN
159: arp_standard.debug('autorecapi start ()+');
160: arp_standard.debug( 'value of p_errbuf ' || P_ERRBUF);
161: arp_standard.debug( 'value of p_retcode ' || (P_RETCODE));
162: arp_standard.debug( 'value of p_process_type ' || p_process_type);
163: arp_standard.debug( 'value of p_create_flag ' || p_create_flag);
164: arp_standard.debug( 'value of p_approve_flag ' || p_approve_flag);
157:
158: IF PG_DEBUG in ('Y', 'C') THEN
159: arp_standard.debug('autorecapi start ()+');
160: arp_standard.debug( 'value of p_errbuf ' || P_ERRBUF);
161: arp_standard.debug( 'value of p_retcode ' || (P_RETCODE));
162: arp_standard.debug( 'value of p_process_type ' || p_process_type);
163: arp_standard.debug( 'value of p_create_flag ' || p_create_flag);
164: arp_standard.debug( 'value of p_approve_flag ' || p_approve_flag);
165: arp_standard.debug( 'value of p_format_flag ' || p_format_flag);
158: IF PG_DEBUG in ('Y', 'C') THEN
159: arp_standard.debug('autorecapi start ()+');
160: arp_standard.debug( 'value of p_errbuf ' || P_ERRBUF);
161: arp_standard.debug( 'value of p_retcode ' || (P_RETCODE));
162: arp_standard.debug( 'value of p_process_type ' || p_process_type);
163: arp_standard.debug( 'value of p_create_flag ' || p_create_flag);
164: arp_standard.debug( 'value of p_approve_flag ' || p_approve_flag);
165: arp_standard.debug( 'value of p_format_flag ' || p_format_flag);
166: arp_standard.debug( 'value of p_batch_id ' || (p_batch_id));
159: arp_standard.debug('autorecapi start ()+');
160: arp_standard.debug( 'value of p_errbuf ' || P_ERRBUF);
161: arp_standard.debug( 'value of p_retcode ' || (P_RETCODE));
162: arp_standard.debug( 'value of p_process_type ' || p_process_type);
163: arp_standard.debug( 'value of p_create_flag ' || p_create_flag);
164: arp_standard.debug( 'value of p_approve_flag ' || p_approve_flag);
165: arp_standard.debug( 'value of p_format_flag ' || p_format_flag);
166: arp_standard.debug( 'value of p_batch_id ' || (p_batch_id));
167: arp_standard.debug( 'value of p_debug_mode_on ' || p_debug_mode_on);
160: arp_standard.debug( 'value of p_errbuf ' || P_ERRBUF);
161: arp_standard.debug( 'value of p_retcode ' || (P_RETCODE));
162: arp_standard.debug( 'value of p_process_type ' || p_process_type);
163: arp_standard.debug( 'value of p_create_flag ' || p_create_flag);
164: arp_standard.debug( 'value of p_approve_flag ' || p_approve_flag);
165: arp_standard.debug( 'value of p_format_flag ' || p_format_flag);
166: arp_standard.debug( 'value of p_batch_id ' || (p_batch_id));
167: arp_standard.debug( 'value of p_debug_mode_on ' || p_debug_mode_on);
168: arp_standard.debug( 'value of p_receipt_class_id ' || p_receipt_class_id);
161: arp_standard.debug( 'value of p_retcode ' || (P_RETCODE));
162: arp_standard.debug( 'value of p_process_type ' || p_process_type);
163: arp_standard.debug( 'value of p_create_flag ' || p_create_flag);
164: arp_standard.debug( 'value of p_approve_flag ' || p_approve_flag);
165: arp_standard.debug( 'value of p_format_flag ' || p_format_flag);
166: arp_standard.debug( 'value of p_batch_id ' || (p_batch_id));
167: arp_standard.debug( 'value of p_debug_mode_on ' || p_debug_mode_on);
168: arp_standard.debug( 'value of p_receipt_class_id ' || p_receipt_class_id);
169: arp_standard.debug( 'value of p_payment_method_id ' || p_payment_method_id);
162: arp_standard.debug( 'value of p_process_type ' || p_process_type);
163: arp_standard.debug( 'value of p_create_flag ' || p_create_flag);
164: arp_standard.debug( 'value of p_approve_flag ' || p_approve_flag);
165: arp_standard.debug( 'value of p_format_flag ' || p_format_flag);
166: arp_standard.debug( 'value of p_batch_id ' || (p_batch_id));
167: arp_standard.debug( 'value of p_debug_mode_on ' || p_debug_mode_on);
168: arp_standard.debug( 'value of p_receipt_class_id ' || p_receipt_class_id);
169: arp_standard.debug( 'value of p_payment_method_id ' || p_payment_method_id);
170: arp_standard.debug( 'value of p_batch_currency ' || p_batch_currency);
163: arp_standard.debug( 'value of p_create_flag ' || p_create_flag);
164: arp_standard.debug( 'value of p_approve_flag ' || p_approve_flag);
165: arp_standard.debug( 'value of p_format_flag ' || p_format_flag);
166: arp_standard.debug( 'value of p_batch_id ' || (p_batch_id));
167: arp_standard.debug( 'value of p_debug_mode_on ' || p_debug_mode_on);
168: arp_standard.debug( 'value of p_receipt_class_id ' || p_receipt_class_id);
169: arp_standard.debug( 'value of p_payment_method_id ' || p_payment_method_id);
170: arp_standard.debug( 'value of p_batch_currency ' || p_batch_currency);
171: arp_standard.debug( 'value of p_batch_date ' || p_batch_date);
164: arp_standard.debug( 'value of p_approve_flag ' || p_approve_flag);
165: arp_standard.debug( 'value of p_format_flag ' || p_format_flag);
166: arp_standard.debug( 'value of p_batch_id ' || (p_batch_id));
167: arp_standard.debug( 'value of p_debug_mode_on ' || p_debug_mode_on);
168: arp_standard.debug( 'value of p_receipt_class_id ' || p_receipt_class_id);
169: arp_standard.debug( 'value of p_payment_method_id ' || p_payment_method_id);
170: arp_standard.debug( 'value of p_batch_currency ' || p_batch_currency);
171: arp_standard.debug( 'value of p_batch_date ' || p_batch_date);
172: arp_standard.debug( 'value of p_batch_gl_date ' || p_batch_gl_date);
165: arp_standard.debug( 'value of p_format_flag ' || p_format_flag);
166: arp_standard.debug( 'value of p_batch_id ' || (p_batch_id));
167: arp_standard.debug( 'value of p_debug_mode_on ' || p_debug_mode_on);
168: arp_standard.debug( 'value of p_receipt_class_id ' || p_receipt_class_id);
169: arp_standard.debug( 'value of p_payment_method_id ' || p_payment_method_id);
170: arp_standard.debug( 'value of p_batch_currency ' || p_batch_currency);
171: arp_standard.debug( 'value of p_batch_date ' || p_batch_date);
172: arp_standard.debug( 'value of p_batch_gl_date ' || p_batch_gl_date);
173: arp_standard.debug( 'value of p_comments ' || p_comments);
166: arp_standard.debug( 'value of p_batch_id ' || (p_batch_id));
167: arp_standard.debug( 'value of p_debug_mode_on ' || p_debug_mode_on);
168: arp_standard.debug( 'value of p_receipt_class_id ' || p_receipt_class_id);
169: arp_standard.debug( 'value of p_payment_method_id ' || p_payment_method_id);
170: arp_standard.debug( 'value of p_batch_currency ' || p_batch_currency);
171: arp_standard.debug( 'value of p_batch_date ' || p_batch_date);
172: arp_standard.debug( 'value of p_batch_gl_date ' || p_batch_gl_date);
173: arp_standard.debug( 'value of p_comments ' || p_comments);
174: arp_standard.debug( 'value of p_exchnage_date ' || p_exchange_date);
167: arp_standard.debug( 'value of p_debug_mode_on ' || p_debug_mode_on);
168: arp_standard.debug( 'value of p_receipt_class_id ' || p_receipt_class_id);
169: arp_standard.debug( 'value of p_payment_method_id ' || p_payment_method_id);
170: arp_standard.debug( 'value of p_batch_currency ' || p_batch_currency);
171: arp_standard.debug( 'value of p_batch_date ' || p_batch_date);
172: arp_standard.debug( 'value of p_batch_gl_date ' || p_batch_gl_date);
173: arp_standard.debug( 'value of p_comments ' || p_comments);
174: arp_standard.debug( 'value of p_exchnage_date ' || p_exchange_date);
175: arp_standard.debug( 'value of p_exchnage_rate ' || p_exchange_rate);
168: arp_standard.debug( 'value of p_receipt_class_id ' || p_receipt_class_id);
169: arp_standard.debug( 'value of p_payment_method_id ' || p_payment_method_id);
170: arp_standard.debug( 'value of p_batch_currency ' || p_batch_currency);
171: arp_standard.debug( 'value of p_batch_date ' || p_batch_date);
172: arp_standard.debug( 'value of p_batch_gl_date ' || p_batch_gl_date);
173: arp_standard.debug( 'value of p_comments ' || p_comments);
174: arp_standard.debug( 'value of p_exchnage_date ' || p_exchange_date);
175: arp_standard.debug( 'value of p_exchnage_rate ' || p_exchange_rate);
176: arp_standard.debug( 'value of p_exchnage_rate_type ' || p_exchange_rate_type);
169: arp_standard.debug( 'value of p_payment_method_id ' || p_payment_method_id);
170: arp_standard.debug( 'value of p_batch_currency ' || p_batch_currency);
171: arp_standard.debug( 'value of p_batch_date ' || p_batch_date);
172: arp_standard.debug( 'value of p_batch_gl_date ' || p_batch_gl_date);
173: arp_standard.debug( 'value of p_comments ' || p_comments);
174: arp_standard.debug( 'value of p_exchnage_date ' || p_exchange_date);
175: arp_standard.debug( 'value of p_exchnage_rate ' || p_exchange_rate);
176: arp_standard.debug( 'value of p_exchnage_rate_type ' || p_exchange_rate_type);
177: arp_standard.debug( 'value of p_media_reference ' || p_media_reference);
170: arp_standard.debug( 'value of p_batch_currency ' || p_batch_currency);
171: arp_standard.debug( 'value of p_batch_date ' || p_batch_date);
172: arp_standard.debug( 'value of p_batch_gl_date ' || p_batch_gl_date);
173: arp_standard.debug( 'value of p_comments ' || p_comments);
174: arp_standard.debug( 'value of p_exchnage_date ' || p_exchange_date);
175: arp_standard.debug( 'value of p_exchnage_rate ' || p_exchange_rate);
176: arp_standard.debug( 'value of p_exchnage_rate_type ' || p_exchange_rate_type);
177: arp_standard.debug( 'value of p_media_reference ' || p_media_reference);
178: arp_standard.debug( 'value of p_remit_method_code ' || p_remit_method_code);
171: arp_standard.debug( 'value of p_batch_date ' || p_batch_date);
172: arp_standard.debug( 'value of p_batch_gl_date ' || p_batch_gl_date);
173: arp_standard.debug( 'value of p_comments ' || p_comments);
174: arp_standard.debug( 'value of p_exchnage_date ' || p_exchange_date);
175: arp_standard.debug( 'value of p_exchnage_rate ' || p_exchange_rate);
176: arp_standard.debug( 'value of p_exchnage_rate_type ' || p_exchange_rate_type);
177: arp_standard.debug( 'value of p_media_reference ' || p_media_reference);
178: arp_standard.debug( 'value of p_remit_method_code ' || p_remit_method_code);
179: arp_standard.debug( 'value of p_remit_bank_branch_id ' || p_remit_bank_branch_id);
172: arp_standard.debug( 'value of p_batch_gl_date ' || p_batch_gl_date);
173: arp_standard.debug( 'value of p_comments ' || p_comments);
174: arp_standard.debug( 'value of p_exchnage_date ' || p_exchange_date);
175: arp_standard.debug( 'value of p_exchnage_rate ' || p_exchange_rate);
176: arp_standard.debug( 'value of p_exchnage_rate_type ' || p_exchange_rate_type);
177: arp_standard.debug( 'value of p_media_reference ' || p_media_reference);
178: arp_standard.debug( 'value of p_remit_method_code ' || p_remit_method_code);
179: arp_standard.debug( 'value of p_remit_bank_branch_id ' || p_remit_bank_branch_id);
180: arp_standard.debug( 'value of p_remit_bank_account_id ' || p_remit_bank_account_id);
173: arp_standard.debug( 'value of p_comments ' || p_comments);
174: arp_standard.debug( 'value of p_exchnage_date ' || p_exchange_date);
175: arp_standard.debug( 'value of p_exchnage_rate ' || p_exchange_rate);
176: arp_standard.debug( 'value of p_exchnage_rate_type ' || p_exchange_rate_type);
177: arp_standard.debug( 'value of p_media_reference ' || p_media_reference);
178: arp_standard.debug( 'value of p_remit_method_code ' || p_remit_method_code);
179: arp_standard.debug( 'value of p_remit_bank_branch_id ' || p_remit_bank_branch_id);
180: arp_standard.debug( 'value of p_remit_bank_account_id ' || p_remit_bank_account_id);
181: arp_standard.debug( 'value of p_remit_bank_deposit_number ' || p_remit_bank_deposit_number);
174: arp_standard.debug( 'value of p_exchnage_date ' || p_exchange_date);
175: arp_standard.debug( 'value of p_exchnage_rate ' || p_exchange_rate);
176: arp_standard.debug( 'value of p_exchnage_rate_type ' || p_exchange_rate_type);
177: arp_standard.debug( 'value of p_media_reference ' || p_media_reference);
178: arp_standard.debug( 'value of p_remit_method_code ' || p_remit_method_code);
179: arp_standard.debug( 'value of p_remit_bank_branch_id ' || p_remit_bank_branch_id);
180: arp_standard.debug( 'value of p_remit_bank_account_id ' || p_remit_bank_account_id);
181: arp_standard.debug( 'value of p_remit_bank_deposit_number ' || p_remit_bank_deposit_number);
182: arp_standard.debug( 'value of p_trx_date_l ' || p_trx_date_l);
175: arp_standard.debug( 'value of p_exchnage_rate ' || p_exchange_rate);
176: arp_standard.debug( 'value of p_exchnage_rate_type ' || p_exchange_rate_type);
177: arp_standard.debug( 'value of p_media_reference ' || p_media_reference);
178: arp_standard.debug( 'value of p_remit_method_code ' || p_remit_method_code);
179: arp_standard.debug( 'value of p_remit_bank_branch_id ' || p_remit_bank_branch_id);
180: arp_standard.debug( 'value of p_remit_bank_account_id ' || p_remit_bank_account_id);
181: arp_standard.debug( 'value of p_remit_bank_deposit_number ' || p_remit_bank_deposit_number);
182: arp_standard.debug( 'value of p_trx_date_l ' || p_trx_date_l);
183: arp_standard.debug( 'value of p_trx_date_h ' || p_trx_date_h);
176: arp_standard.debug( 'value of p_exchnage_rate_type ' || p_exchange_rate_type);
177: arp_standard.debug( 'value of p_media_reference ' || p_media_reference);
178: arp_standard.debug( 'value of p_remit_method_code ' || p_remit_method_code);
179: arp_standard.debug( 'value of p_remit_bank_branch_id ' || p_remit_bank_branch_id);
180: arp_standard.debug( 'value of p_remit_bank_account_id ' || p_remit_bank_account_id);
181: arp_standard.debug( 'value of p_remit_bank_deposit_number ' || p_remit_bank_deposit_number);
182: arp_standard.debug( 'value of p_trx_date_l ' || p_trx_date_l);
183: arp_standard.debug( 'value of p_trx_date_h ' || p_trx_date_h);
184: arp_standard.debug( 'value of p_due_date_l ' || p_due_date_l);
177: arp_standard.debug( 'value of p_media_reference ' || p_media_reference);
178: arp_standard.debug( 'value of p_remit_method_code ' || p_remit_method_code);
179: arp_standard.debug( 'value of p_remit_bank_branch_id ' || p_remit_bank_branch_id);
180: arp_standard.debug( 'value of p_remit_bank_account_id ' || p_remit_bank_account_id);
181: arp_standard.debug( 'value of p_remit_bank_deposit_number ' || p_remit_bank_deposit_number);
182: arp_standard.debug( 'value of p_trx_date_l ' || p_trx_date_l);
183: arp_standard.debug( 'value of p_trx_date_h ' || p_trx_date_h);
184: arp_standard.debug( 'value of p_due_date_l ' || p_due_date_l);
185: arp_standard.debug( 'value of p_due_date_h ' || p_due_date_h);
178: arp_standard.debug( 'value of p_remit_method_code ' || p_remit_method_code);
179: arp_standard.debug( 'value of p_remit_bank_branch_id ' || p_remit_bank_branch_id);
180: arp_standard.debug( 'value of p_remit_bank_account_id ' || p_remit_bank_account_id);
181: arp_standard.debug( 'value of p_remit_bank_deposit_number ' || p_remit_bank_deposit_number);
182: arp_standard.debug( 'value of p_trx_date_l ' || p_trx_date_l);
183: arp_standard.debug( 'value of p_trx_date_h ' || p_trx_date_h);
184: arp_standard.debug( 'value of p_due_date_l ' || p_due_date_l);
185: arp_standard.debug( 'value of p_due_date_h ' || p_due_date_h);
186: arp_standard.debug( 'value of p_trx_num_l ' || p_trx_num_l);
179: arp_standard.debug( 'value of p_remit_bank_branch_id ' || p_remit_bank_branch_id);
180: arp_standard.debug( 'value of p_remit_bank_account_id ' || p_remit_bank_account_id);
181: arp_standard.debug( 'value of p_remit_bank_deposit_number ' || p_remit_bank_deposit_number);
182: arp_standard.debug( 'value of p_trx_date_l ' || p_trx_date_l);
183: arp_standard.debug( 'value of p_trx_date_h ' || p_trx_date_h);
184: arp_standard.debug( 'value of p_due_date_l ' || p_due_date_l);
185: arp_standard.debug( 'value of p_due_date_h ' || p_due_date_h);
186: arp_standard.debug( 'value of p_trx_num_l ' || p_trx_num_l);
187: arp_standard.debug( 'value of p_trx_num_h ' || p_trx_num_h);
180: arp_standard.debug( 'value of p_remit_bank_account_id ' || p_remit_bank_account_id);
181: arp_standard.debug( 'value of p_remit_bank_deposit_number ' || p_remit_bank_deposit_number);
182: arp_standard.debug( 'value of p_trx_date_l ' || p_trx_date_l);
183: arp_standard.debug( 'value of p_trx_date_h ' || p_trx_date_h);
184: arp_standard.debug( 'value of p_due_date_l ' || p_due_date_l);
185: arp_standard.debug( 'value of p_due_date_h ' || p_due_date_h);
186: arp_standard.debug( 'value of p_trx_num_l ' || p_trx_num_l);
187: arp_standard.debug( 'value of p_trx_num_h ' || p_trx_num_h);
188: arp_standard.debug( 'value of p_doc_num_l ' || p_doc_num_l);
181: arp_standard.debug( 'value of p_remit_bank_deposit_number ' || p_remit_bank_deposit_number);
182: arp_standard.debug( 'value of p_trx_date_l ' || p_trx_date_l);
183: arp_standard.debug( 'value of p_trx_date_h ' || p_trx_date_h);
184: arp_standard.debug( 'value of p_due_date_l ' || p_due_date_l);
185: arp_standard.debug( 'value of p_due_date_h ' || p_due_date_h);
186: arp_standard.debug( 'value of p_trx_num_l ' || p_trx_num_l);
187: arp_standard.debug( 'value of p_trx_num_h ' || p_trx_num_h);
188: arp_standard.debug( 'value of p_doc_num_l ' || p_doc_num_l);
189: arp_standard.debug( 'value of p_doc_num_h ' || p_doc_num_h);
182: arp_standard.debug( 'value of p_trx_date_l ' || p_trx_date_l);
183: arp_standard.debug( 'value of p_trx_date_h ' || p_trx_date_h);
184: arp_standard.debug( 'value of p_due_date_l ' || p_due_date_l);
185: arp_standard.debug( 'value of p_due_date_h ' || p_due_date_h);
186: arp_standard.debug( 'value of p_trx_num_l ' || p_trx_num_l);
187: arp_standard.debug( 'value of p_trx_num_h ' || p_trx_num_h);
188: arp_standard.debug( 'value of p_doc_num_l ' || p_doc_num_l);
189: arp_standard.debug( 'value of p_doc_num_h ' || p_doc_num_h);
190: arp_standard.debug( 'value of p_customer_number_l ' || p_customer_number_l);
183: arp_standard.debug( 'value of p_trx_date_h ' || p_trx_date_h);
184: arp_standard.debug( 'value of p_due_date_l ' || p_due_date_l);
185: arp_standard.debug( 'value of p_due_date_h ' || p_due_date_h);
186: arp_standard.debug( 'value of p_trx_num_l ' || p_trx_num_l);
187: arp_standard.debug( 'value of p_trx_num_h ' || p_trx_num_h);
188: arp_standard.debug( 'value of p_doc_num_l ' || p_doc_num_l);
189: arp_standard.debug( 'value of p_doc_num_h ' || p_doc_num_h);
190: arp_standard.debug( 'value of p_customer_number_l ' || p_customer_number_l);
191: arp_standard.debug( 'value of p_customer_number_h ' || p_customer_number_h);
184: arp_standard.debug( 'value of p_due_date_l ' || p_due_date_l);
185: arp_standard.debug( 'value of p_due_date_h ' || p_due_date_h);
186: arp_standard.debug( 'value of p_trx_num_l ' || p_trx_num_l);
187: arp_standard.debug( 'value of p_trx_num_h ' || p_trx_num_h);
188: arp_standard.debug( 'value of p_doc_num_l ' || p_doc_num_l);
189: arp_standard.debug( 'value of p_doc_num_h ' || p_doc_num_h);
190: arp_standard.debug( 'value of p_customer_number_l ' || p_customer_number_l);
191: arp_standard.debug( 'value of p_customer_number_h ' || p_customer_number_h);
192: arp_standard.debug( 'value of p_customer_name_l ' || p_customer_name_l);
185: arp_standard.debug( 'value of p_due_date_h ' || p_due_date_h);
186: arp_standard.debug( 'value of p_trx_num_l ' || p_trx_num_l);
187: arp_standard.debug( 'value of p_trx_num_h ' || p_trx_num_h);
188: arp_standard.debug( 'value of p_doc_num_l ' || p_doc_num_l);
189: arp_standard.debug( 'value of p_doc_num_h ' || p_doc_num_h);
190: arp_standard.debug( 'value of p_customer_number_l ' || p_customer_number_l);
191: arp_standard.debug( 'value of p_customer_number_h ' || p_customer_number_h);
192: arp_standard.debug( 'value of p_customer_name_l ' || p_customer_name_l);
193: arp_standard.debug( 'value of p_customer_name_h ' || p_customer_name_h);
186: arp_standard.debug( 'value of p_trx_num_l ' || p_trx_num_l);
187: arp_standard.debug( 'value of p_trx_num_h ' || p_trx_num_h);
188: arp_standard.debug( 'value of p_doc_num_l ' || p_doc_num_l);
189: arp_standard.debug( 'value of p_doc_num_h ' || p_doc_num_h);
190: arp_standard.debug( 'value of p_customer_number_l ' || p_customer_number_l);
191: arp_standard.debug( 'value of p_customer_number_h ' || p_customer_number_h);
192: arp_standard.debug( 'value of p_customer_name_l ' || p_customer_name_l);
193: arp_standard.debug( 'value of p_customer_name_h ' || p_customer_name_h);
194: arp_standard.debug( 'value of p_customer_id ' || (p_customer_id));
187: arp_standard.debug( 'value of p_trx_num_h ' || p_trx_num_h);
188: arp_standard.debug( 'value of p_doc_num_l ' || p_doc_num_l);
189: arp_standard.debug( 'value of p_doc_num_h ' || p_doc_num_h);
190: arp_standard.debug( 'value of p_customer_number_l ' || p_customer_number_l);
191: arp_standard.debug( 'value of p_customer_number_h ' || p_customer_number_h);
192: arp_standard.debug( 'value of p_customer_name_l ' || p_customer_name_l);
193: arp_standard.debug( 'value of p_customer_name_h ' || p_customer_name_h);
194: arp_standard.debug( 'value of p_customer_id ' || (p_customer_id));
195: arp_standard.debug( 'value of p_site_l ' || p_site_l);
188: arp_standard.debug( 'value of p_doc_num_l ' || p_doc_num_l);
189: arp_standard.debug( 'value of p_doc_num_h ' || p_doc_num_h);
190: arp_standard.debug( 'value of p_customer_number_l ' || p_customer_number_l);
191: arp_standard.debug( 'value of p_customer_number_h ' || p_customer_number_h);
192: arp_standard.debug( 'value of p_customer_name_l ' || p_customer_name_l);
193: arp_standard.debug( 'value of p_customer_name_h ' || p_customer_name_h);
194: arp_standard.debug( 'value of p_customer_id ' || (p_customer_id));
195: arp_standard.debug( 'value of p_site_l ' || p_site_l);
196: arp_standard.debug( 'value of p_site_h ' || p_site_h);
189: arp_standard.debug( 'value of p_doc_num_h ' || p_doc_num_h);
190: arp_standard.debug( 'value of p_customer_number_l ' || p_customer_number_l);
191: arp_standard.debug( 'value of p_customer_number_h ' || p_customer_number_h);
192: arp_standard.debug( 'value of p_customer_name_l ' || p_customer_name_l);
193: arp_standard.debug( 'value of p_customer_name_h ' || p_customer_name_h);
194: arp_standard.debug( 'value of p_customer_id ' || (p_customer_id));
195: arp_standard.debug( 'value of p_site_l ' || p_site_l);
196: arp_standard.debug( 'value of p_site_h ' || p_site_h);
197: arp_standard.debug( 'value of p_site_id ' || (p_site_id));
190: arp_standard.debug( 'value of p_customer_number_l ' || p_customer_number_l);
191: arp_standard.debug( 'value of p_customer_number_h ' || p_customer_number_h);
192: arp_standard.debug( 'value of p_customer_name_l ' || p_customer_name_l);
193: arp_standard.debug( 'value of p_customer_name_h ' || p_customer_name_h);
194: arp_standard.debug( 'value of p_customer_id ' || (p_customer_id));
195: arp_standard.debug( 'value of p_site_l ' || p_site_l);
196: arp_standard.debug( 'value of p_site_h ' || p_site_h);
197: arp_standard.debug( 'value of p_site_id ' || (p_site_id));
198: arp_standard.debug( 'value of p_remittance_total_from ' || p_remittance_total_from);
191: arp_standard.debug( 'value of p_customer_number_h ' || p_customer_number_h);
192: arp_standard.debug( 'value of p_customer_name_l ' || p_customer_name_l);
193: arp_standard.debug( 'value of p_customer_name_h ' || p_customer_name_h);
194: arp_standard.debug( 'value of p_customer_id ' || (p_customer_id));
195: arp_standard.debug( 'value of p_site_l ' || p_site_l);
196: arp_standard.debug( 'value of p_site_h ' || p_site_h);
197: arp_standard.debug( 'value of p_site_id ' || (p_site_id));
198: arp_standard.debug( 'value of p_remittance_total_from ' || p_remittance_total_from);
199: arp_standard.debug( 'value of p_Remittance_total_to ' || p_Remittance_total_to);
192: arp_standard.debug( 'value of p_customer_name_l ' || p_customer_name_l);
193: arp_standard.debug( 'value of p_customer_name_h ' || p_customer_name_h);
194: arp_standard.debug( 'value of p_customer_id ' || (p_customer_id));
195: arp_standard.debug( 'value of p_site_l ' || p_site_l);
196: arp_standard.debug( 'value of p_site_h ' || p_site_h);
197: arp_standard.debug( 'value of p_site_id ' || (p_site_id));
198: arp_standard.debug( 'value of p_remittance_total_from ' || p_remittance_total_from);
199: arp_standard.debug( 'value of p_Remittance_total_to ' || p_Remittance_total_to);
200: arp_standard.debug( 'value of p_billing_number_l ' || p_billing_number_l);
193: arp_standard.debug( 'value of p_customer_name_h ' || p_customer_name_h);
194: arp_standard.debug( 'value of p_customer_id ' || (p_customer_id));
195: arp_standard.debug( 'value of p_site_l ' || p_site_l);
196: arp_standard.debug( 'value of p_site_h ' || p_site_h);
197: arp_standard.debug( 'value of p_site_id ' || (p_site_id));
198: arp_standard.debug( 'value of p_remittance_total_from ' || p_remittance_total_from);
199: arp_standard.debug( 'value of p_Remittance_total_to ' || p_Remittance_total_to);
200: arp_standard.debug( 'value of p_billing_number_l ' || p_billing_number_l);
201: arp_standard.debug( 'value of p_billing_number_h ' || p_billing_number_h);
194: arp_standard.debug( 'value of p_customer_id ' || (p_customer_id));
195: arp_standard.debug( 'value of p_site_l ' || p_site_l);
196: arp_standard.debug( 'value of p_site_h ' || p_site_h);
197: arp_standard.debug( 'value of p_site_id ' || (p_site_id));
198: arp_standard.debug( 'value of p_remittance_total_from ' || p_remittance_total_from);
199: arp_standard.debug( 'value of p_Remittance_total_to ' || p_Remittance_total_to);
200: arp_standard.debug( 'value of p_billing_number_l ' || p_billing_number_l);
201: arp_standard.debug( 'value of p_billing_number_h ' || p_billing_number_h);
202: arp_standard.debug( 'value of p_customer_bank_acc_num_l ' || p_customer_bank_acc_num_l);
195: arp_standard.debug( 'value of p_site_l ' || p_site_l);
196: arp_standard.debug( 'value of p_site_h ' || p_site_h);
197: arp_standard.debug( 'value of p_site_id ' || (p_site_id));
198: arp_standard.debug( 'value of p_remittance_total_from ' || p_remittance_total_from);
199: arp_standard.debug( 'value of p_Remittance_total_to ' || p_Remittance_total_to);
200: arp_standard.debug( 'value of p_billing_number_l ' || p_billing_number_l);
201: arp_standard.debug( 'value of p_billing_number_h ' || p_billing_number_h);
202: arp_standard.debug( 'value of p_customer_bank_acc_num_l ' || p_customer_bank_acc_num_l);
203: arp_standard.debug( 'value of p_customer_bank_acc_num_h ' || p_customer_bank_acc_num_h);
196: arp_standard.debug( 'value of p_site_h ' || p_site_h);
197: arp_standard.debug( 'value of p_site_id ' || (p_site_id));
198: arp_standard.debug( 'value of p_remittance_total_from ' || p_remittance_total_from);
199: arp_standard.debug( 'value of p_Remittance_total_to ' || p_Remittance_total_to);
200: arp_standard.debug( 'value of p_billing_number_l ' || p_billing_number_l);
201: arp_standard.debug( 'value of p_billing_number_h ' || p_billing_number_h);
202: arp_standard.debug( 'value of p_customer_bank_acc_num_l ' || p_customer_bank_acc_num_l);
203: arp_standard.debug( 'value of p_customer_bank_acc_num_h ' || p_customer_bank_acc_num_h);
204:
197: arp_standard.debug( 'value of p_site_id ' || (p_site_id));
198: arp_standard.debug( 'value of p_remittance_total_from ' || p_remittance_total_from);
199: arp_standard.debug( 'value of p_Remittance_total_to ' || p_Remittance_total_to);
200: arp_standard.debug( 'value of p_billing_number_l ' || p_billing_number_l);
201: arp_standard.debug( 'value of p_billing_number_h ' || p_billing_number_h);
202: arp_standard.debug( 'value of p_customer_bank_acc_num_l ' || p_customer_bank_acc_num_l);
203: arp_standard.debug( 'value of p_customer_bank_acc_num_h ' || p_customer_bank_acc_num_h);
204:
205: END IF;
198: arp_standard.debug( 'value of p_remittance_total_from ' || p_remittance_total_from);
199: arp_standard.debug( 'value of p_Remittance_total_to ' || p_Remittance_total_to);
200: arp_standard.debug( 'value of p_billing_number_l ' || p_billing_number_l);
201: arp_standard.debug( 'value of p_billing_number_h ' || p_billing_number_h);
202: arp_standard.debug( 'value of p_customer_bank_acc_num_l ' || p_customer_bank_acc_num_l);
203: arp_standard.debug( 'value of p_customer_bank_acc_num_h ' || p_customer_bank_acc_num_h);
204:
205: END IF;
206:
199: arp_standard.debug( 'value of p_Remittance_total_to ' || p_Remittance_total_to);
200: arp_standard.debug( 'value of p_billing_number_l ' || p_billing_number_l);
201: arp_standard.debug( 'value of p_billing_number_h ' || p_billing_number_h);
202: arp_standard.debug( 'value of p_customer_bank_acc_num_l ' || p_customer_bank_acc_num_l);
203: arp_standard.debug( 'value of p_customer_bank_acc_num_h ' || p_customer_bank_acc_num_h);
204:
205: END IF;
206:
207: IF PG_DEBUG in ('Y','C') THEN
204:
205: END IF;
206:
207: IF PG_DEBUG in ('Y','C') THEN
208: arp_standard.debug( 'converting the parameters');
209: END IF;
210:
211: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
212: l_batch_date := fnd_date.canonical_to_date(p_batch_date);
245: from AR_BATCHES
246: where batch_id = p_batch_id;
247:
248: IF PG_DEBUG in ('Y','C') THEN
249: arp_standard.debug( 'value batch_date' || l_batch_date);
250: arp_standard.debug( 'value gl_date ' || l_gl_date);
251: arp_standard.debug('value currency_code' || l_currency_code);
252: arp_standard.debug('value receipt_method_id'|| l_receipt_method_id);
253:
246: where batch_id = p_batch_id;
247:
248: IF PG_DEBUG in ('Y','C') THEN
249: arp_standard.debug( 'value batch_date' || l_batch_date);
250: arp_standard.debug( 'value gl_date ' || l_gl_date);
251: arp_standard.debug('value currency_code' || l_currency_code);
252: arp_standard.debug('value receipt_method_id'|| l_receipt_method_id);
253:
254: END IF;
247:
248: IF PG_DEBUG in ('Y','C') THEN
249: arp_standard.debug( 'value batch_date' || l_batch_date);
250: arp_standard.debug( 'value gl_date ' || l_gl_date);
251: arp_standard.debug('value currency_code' || l_currency_code);
252: arp_standard.debug('value receipt_method_id'|| l_receipt_method_id);
253:
254: END IF;
255:
248: IF PG_DEBUG in ('Y','C') THEN
249: arp_standard.debug( 'value batch_date' || l_batch_date);
250: arp_standard.debug( 'value gl_date ' || l_gl_date);
251: arp_standard.debug('value currency_code' || l_currency_code);
252: arp_standard.debug('value receipt_method_id'|| l_receipt_method_id);
253:
254: END IF;
255:
256:
262:
263:
264:
265: IF o_batch_id is null THEN
266: arp_standard.debug( 'This is an error condition');
267:
268: insert_exceptions(
269: p_batch_id =>-333,
270: p_request_id =>l_request_id,
270: p_request_id =>l_request_id,
271: p_exception_code => 'NO_BATCH',
272: p_additional_message => 'error during insert batch' );
273:
274: arp_standard.debug ( 'calling the report- batch_id ' || -333 );
275: arp_standard.debug ( 'calling the report ' || l_request_id);
276:
277: submit_report ( p_batch_id => -333,
278: p_request_id => l_request_id);
271: p_exception_code => 'NO_BATCH',
272: p_additional_message => 'error during insert batch' );
273:
274: arp_standard.debug ( 'calling the report- batch_id ' || -333 );
275: arp_standard.debug ( 'calling the report ' || l_request_id);
276:
277: submit_report ( p_batch_id => -333,
278: p_request_id => l_request_id);
279:
286:
287: IF ( p_create_flag = 'Y' AND p_approve_flag = 'N' AND p_format_flag = 'N') THEN
288:
289:
290: arp_standard.debug ( 'This is a Create Only RUN ');
291:
292: IF G_ERROR = 'N' THEN
293:
294: IF PG_DEBUG in ('Y','C') THEN
291:
292: IF G_ERROR = 'N' THEN
293:
294: IF PG_DEBUG in ('Y','C') THEN
295: arp_standard.debug( 'value of o_batch_id bef call to selin ' || to_char(o_batch_id));
296: arp_standard.debug( ' the error here is ' || SQLERRM );
297: END IF;
298:
299: select_valid_invoices
292: IF G_ERROR = 'N' THEN
293:
294: IF PG_DEBUG in ('Y','C') THEN
295: arp_standard.debug( 'value of o_batch_id bef call to selin ' || to_char(o_batch_id));
296: arp_standard.debug( ' the error here is ' || SQLERRM );
297: END IF;
298:
299: select_valid_invoices
300: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
334: update ar_payment_schedules
335: set selected_for_receipt_batch_id = o_batch_id
336: where payment_schedule_id in (select PAYMENT_SCHEDULE_ID from AR_RECEIPTS_GT);
337:
338: arp_standard.debug ( 'NO of PS rows updated = '|| to_char(SQL%ROWCOUNT));
339:
340: IF PG_DEBUG in ('Y', 'C') THEN
341: arp_standard.debug (' COMMITING WORK ');
342: arp_standard.debug ( 'NO of PS rows updated = '|| to_char(SQL%ROWCOUNT));
337:
338: arp_standard.debug ( 'NO of PS rows updated = '|| to_char(SQL%ROWCOUNT));
339:
340: IF PG_DEBUG in ('Y', 'C') THEN
341: arp_standard.debug (' COMMITING WORK ');
342: arp_standard.debug ( 'NO of PS rows updated = '|| to_char(SQL%ROWCOUNT));
343: END IF;
344:
345: update ar_batches SET
338: arp_standard.debug ( 'NO of PS rows updated = '|| to_char(SQL%ROWCOUNT));
339:
340: IF PG_DEBUG in ('Y', 'C') THEN
341: arp_standard.debug (' COMMITING WORK ');
342: arp_standard.debug ( 'NO of PS rows updated = '|| to_char(SQL%ROWCOUNT));
343: END IF;
344:
345: update ar_batches SET
346: batch_applied_status = 'COMPLETED_CREATION'
346: batch_applied_status = 'COMPLETED_CREATION'
347: where batch_id = o_batch_id;
348:
349: COMMIT;
350: arp_standard.debug ( 'calling the report- batch_id ' || o_batch_id );
351: arp_standard.debug ( 'calling the report ' || l_request_id);
352:
353: submit_report ( p_batch_id =>o_batch_id,
354: p_request_id => l_request_id);
347: where batch_id = o_batch_id;
348:
349: COMMIT;
350: arp_standard.debug ( 'calling the report- batch_id ' || o_batch_id );
351: arp_standard.debug ( 'calling the report ' || l_request_id);
352:
353: submit_report ( p_batch_id =>o_batch_id,
354: p_request_id => l_request_id);
355:
361:
362: IF G_ERROR = 'N' THEN
363:
364: IF PG_DEBUG in ('Y','C') THEN
365: arp_standard.debug( 'value of o_batch_id bef call to selin ' || to_char(o_batch_id));
366: arp_standard.debug( ' the error here is ' || SQLERRM );
367: END IF;
368:
369: select_valid_invoices
362: IF G_ERROR = 'N' THEN
363:
364: IF PG_DEBUG in ('Y','C') THEN
365: arp_standard.debug( 'value of o_batch_id bef call to selin ' || to_char(o_batch_id));
366: arp_standard.debug( ' the error here is ' || SQLERRM );
367: END IF;
368:
369: select_valid_invoices
370: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
404: update ar_payment_schedules
405: set selected_for_receipt_batch_id = o_batch_id
406: where payment_schedule_id in (select PAYMENT_SCHEDULE_ID from AR_RECEIPTS_GT);
407:
408: arp_standard.debug ( 'NO of PS rows updated = '|| to_char(SQL%ROWCOUNT));
409:
410: update ar_batches SET
411: batch_applied_status = 'COMPLETED_CREATION'
412: where batch_id = o_batch_id;
416:
417: IF G_ERROR = 'N' THEN
418:
419: IF PG_DEBUG in ('Y','C') THEN
420: arp_standard.debug( 'value of o_batch_id bef call to selin ' || to_char(o_batch_id));
421: arp_standard.debug('Selecting invoices for approval');
422: arp_standard.debug( ' the error here is ' || SQLERRM );
423: END IF;
424:
417: IF G_ERROR = 'N' THEN
418:
419: IF PG_DEBUG in ('Y','C') THEN
420: arp_standard.debug( 'value of o_batch_id bef call to selin ' || to_char(o_batch_id));
421: arp_standard.debug('Selecting invoices for approval');
422: arp_standard.debug( ' the error here is ' || SQLERRM );
423: END IF;
424:
425: select_valid_invoices
418:
419: IF PG_DEBUG in ('Y','C') THEN
420: arp_standard.debug( 'value of o_batch_id bef call to selin ' || to_char(o_batch_id));
421: arp_standard.debug('Selecting invoices for approval');
422: arp_standard.debug( ' the error here is ' || SQLERRM );
423: END IF;
424:
425: select_valid_invoices
426: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),
466:
467: IF G_ERROR = 'N' THEN
468: IF PG_DEBUG in ('Y', 'C') THEN
469: arp_util.debug('CALLING group_and_validate_receipts ()+');
470: arp_standard.debug( 'value of o_batch_id bef call to selin ' || to_char(o_batch_id));
471: END IF;
472:
473:
474: group_val_create_receipts
510:
511: BEGIN
512:
513: IF PG_DEBUG in ('Y', 'C') THEN
514: arp_standard.debug('l_called_from'|| l_called_from);
515: arp_util.debug('Calling APPLY API ()+');
516: END IF;
517:
518: FOR PS IN c2 LOOP
573: IF nvl(al_count,0) < al_msg_count THEN
574: al_count := nvl(al_count,0) +1 ;
575: al_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
576:
577: arp_standard.debug ( 'the number is ' || al_count );
578: arp_standard.debug ( 'the message data is ' || al_msg_data );
579:
580:
581: insert_exceptions(
574: al_count := nvl(al_count,0) +1 ;
575: al_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
576:
577: arp_standard.debug ( 'the number is ' || al_count );
578: arp_standard.debug ( 'the message data is ' || al_msg_data );
579:
580:
581: insert_exceptions(
582: p_batch_id =>o_batch_id,
612:
613:
614: IF PG_DEBUG in ('Y','C') THEN
615:
616: arp_standard.debug('l_called_from'|| l_called_from);
617: arp_standard.debug('l_rec_creation_rule_code'|| l_rec_creation_rule_code);
618: arp_standard.debug('G_ERROR'|| G_ERROR);
619:
620: END IF;
613:
614: IF PG_DEBUG in ('Y','C') THEN
615:
616: arp_standard.debug('l_called_from'|| l_called_from);
617: arp_standard.debug('l_rec_creation_rule_code'|| l_rec_creation_rule_code);
618: arp_standard.debug('G_ERROR'|| G_ERROR);
619:
620: END IF;
621:
614: IF PG_DEBUG in ('Y','C') THEN
615:
616: arp_standard.debug('l_called_from'|| l_called_from);
617: arp_standard.debug('l_rec_creation_rule_code'|| l_rec_creation_rule_code);
618: arp_standard.debug('G_ERROR'|| G_ERROR);
619:
620: END IF;
621:
622: /* CALL to PROCESS PAYMENT 1 FOR AUTH START */
654:
655: BEGIN
656:
657: IF PG_DEBUG in ('Y', 'C') THEN
658: arp_standard.debug('l_called_from'|| l_called_from);
659: arp_util.debug('Calling process payment ()+');
660: END IF;
661:
662:
659: arp_util.debug('Calling process payment ()+');
660: END IF;
661:
662:
663: l_last_updated_by := arp_standard.profile.last_update_login ;
664: l_created_by := arp_standard.profile.user_id ;
665: l_last_update_login := arp_standard.profile.last_update_login ;
666: l_program_application_id := arp_standard.application_id ;
667: l_program_id := arp_standard.profile.program_id;
660: END IF;
661:
662:
663: l_last_updated_by := arp_standard.profile.last_update_login ;
664: l_created_by := arp_standard.profile.user_id ;
665: l_last_update_login := arp_standard.profile.last_update_login ;
666: l_program_application_id := arp_standard.application_id ;
667: l_program_id := arp_standard.profile.program_id;
668:
661:
662:
663: l_last_updated_by := arp_standard.profile.last_update_login ;
664: l_created_by := arp_standard.profile.user_id ;
665: l_last_update_login := arp_standard.profile.last_update_login ;
666: l_program_application_id := arp_standard.application_id ;
667: l_program_id := arp_standard.profile.program_id;
668:
669:
662:
663: l_last_updated_by := arp_standard.profile.last_update_login ;
664: l_created_by := arp_standard.profile.user_id ;
665: l_last_update_login := arp_standard.profile.last_update_login ;
666: l_program_application_id := arp_standard.application_id ;
667: l_program_id := arp_standard.profile.program_id;
668:
669:
670:
663: l_last_updated_by := arp_standard.profile.last_update_login ;
664: l_created_by := arp_standard.profile.user_id ;
665: l_last_update_login := arp_standard.profile.last_update_login ;
666: l_program_application_id := arp_standard.application_id ;
667: l_program_id := arp_standard.profile.program_id;
668:
669:
670:
671: FOR CREC in C3 LOOP
730: ar_cash_receipts rec
731: WHERE r.receipt_number = rec.receipt_number
732: AND rec.cash_receipt_id = CREC.cr_id);
733:
734: arp_standard.debug ( ' rows updated TRX = ' || SQL%ROWCOUNT );
735:
736:
737: ELSIF pl_msg_count > 1 Then
738:
740: IF nvl(pl_count,0) < pl_msg_count THEN
741: pl_count := nvl(pl_count,0) +1 ;
742: pl_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
743:
744: arp_standard.debug ( 'the number is ' || pl_count );
745: arp_standard.debug ( 'the message data is ' || pl_msg_data );
746:
747:
748: insert_exceptions(
741: pl_count := nvl(pl_count,0) +1 ;
742: pl_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
743:
744: arp_standard.debug ( 'the number is ' || pl_count );
745: arp_standard.debug ( 'the message data is ' || pl_msg_data );
746:
747:
748: insert_exceptions(
749: p_batch_id =>o_batch_id,
805: arp_util.debug('updating the receipts created ()+');
806: END IF;
807:
808:
809: l_created_by := arp_standard.profile.user_id ;
810: l_last_update_login := arp_standard.profile.last_update_login ;
811: l_program_application_id := arp_standard.application_id ;
812: l_program_id := arp_standard.profile.program_id;
813:
806: END IF;
807:
808:
809: l_created_by := arp_standard.profile.user_id ;
810: l_last_update_login := arp_standard.profile.last_update_login ;
811: l_program_application_id := arp_standard.application_id ;
812: l_program_id := arp_standard.profile.program_id;
813:
814:
807:
808:
809: l_created_by := arp_standard.profile.user_id ;
810: l_last_update_login := arp_standard.profile.last_update_login ;
811: l_program_application_id := arp_standard.application_id ;
812: l_program_id := arp_standard.profile.program_id;
813:
814:
815: update ar_batches SET
808:
809: l_created_by := arp_standard.profile.user_id ;
810: l_last_update_login := arp_standard.profile.last_update_login ;
811: l_program_application_id := arp_standard.application_id ;
812: l_program_id := arp_standard.profile.program_id;
813:
814:
815: update ar_batches SET
816: batch_applied_status = 'COMPLETED_APPROVAL'
830: WHERE cash_receipt_id in (
831: select cash_receipt_id from
832: AR_RECEIPTS_GT);
833:
834: arp_standard.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));
835:
836: /* CALL TO CONTROL_CHECK to detect bad receipts */
837: control_check ( p_batch_id =>o_batch_id);
838: fnd_file.put_line(FND_FILE.LOG,'g_auth_fail : '|| g_auth_fail);
840: /* CALL To reset in the case there were failures */
841: IF l_pay_process_fail = 'Y' OR g_auth_fail = 'Y' THEN
842:
843: IF PG_DEBUG in ('Y', 'C') THEN
844: arp_standard.debug('calling rec reset.'|| l_apply_fail || l_pay_process_fail);
845: END IF;
846:
847: rec_reset( p_apply_fail => l_apply_fail,
848: p_pay_process_fail => 'Y' );
861: WHERE cash_receipt_id in (
862: select cash_receipt_id from
863: AR_RECEIPTS_GT);
864:
865: arp_standard.debug ( 'NO of Receipts updated CRH = '|| to_char(SQL%ROWCOUNT));
866:
867:
868: update AR_payment_schedules SET
869: created_by = l_created_by,
877: WHERE cash_receipt_id in (
878: select cash_receipt_id from
879: AR_RECEIPTS_GT);
880:
881: arp_standard.debug ( 'NO of Receipts updated PS = '|| to_char(SQL%ROWCOUNT));
882:
883:
884: update ar_receivable_applications SET
885: created_by = l_created_by,
915: WHERE cash_receipt_id in (
916: select cash_receipt_id from ar_receipts_gt)
917: AND request_id = l_request_id;
918:
919: arp_standard.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));
920: END IF;
921:
922: /* START FORMATTING */
923: IF l_format_flag = 'Y' THEN
926: END IF;
927:
928: /* END FORMATTING */
929:
930: arp_standard.debug (' FINALLY COMMITING WORK ');
931: COMMIT;
932:
933:
934: IF PG_DEBUG in ('Y', 'C') THEN
947:
948:
949:
950: /* SUBMIT THE FINAL REPORT FULL WITH ERRORS AND EXECUTION */
951: arp_standard.debug ( 'calling the report- batch_id for create only ' || o_batch_id);
952: arp_standard.debug ( 'calling the report ' || l_request_id);
953:
954: submit_report ( p_batch_id =>o_batch_id,
955: p_request_id => l_request_id);
948:
949:
950: /* SUBMIT THE FINAL REPORT FULL WITH ERRORS AND EXECUTION */
951: arp_standard.debug ( 'calling the report- batch_id for create only ' || o_batch_id);
952: arp_standard.debug ( 'calling the report ' || l_request_id);
953:
954: submit_report ( p_batch_id =>o_batch_id,
955: p_request_id => l_request_id);
956:
1020:
1021:
1022: BEGIN
1023: IF PG_DEBUG in ('Y', 'C') THEN
1024: arp_standard.debug('autorecapi start ()+');
1025: arp_standard.debug( 'value of p_gl_date ' ||p_gl_date);
1026: arp_standard.debug( 'value of batch_date ' ||p_batch_date);
1027: arp_standard.debug( 'value of p_receipt_method_id '|| to_char(p_receipt_method_id));
1028: arp_standard.debug( 'value of p_receipt_class_id ' || to_char(p_receipt_class_id));
1021:
1022: BEGIN
1023: IF PG_DEBUG in ('Y', 'C') THEN
1024: arp_standard.debug('autorecapi start ()+');
1025: arp_standard.debug( 'value of p_gl_date ' ||p_gl_date);
1026: arp_standard.debug( 'value of batch_date ' ||p_batch_date);
1027: arp_standard.debug( 'value of p_receipt_method_id '|| to_char(p_receipt_method_id));
1028: arp_standard.debug( 'value of p_receipt_class_id ' || to_char(p_receipt_class_id));
1029: arp_standard.debug( 'value of p_currency_code ' ||p_currency_code);
1022: BEGIN
1023: IF PG_DEBUG in ('Y', 'C') THEN
1024: arp_standard.debug('autorecapi start ()+');
1025: arp_standard.debug( 'value of p_gl_date ' ||p_gl_date);
1026: arp_standard.debug( 'value of batch_date ' ||p_batch_date);
1027: arp_standard.debug( 'value of p_receipt_method_id '|| to_char(p_receipt_method_id));
1028: arp_standard.debug( 'value of p_receipt_class_id ' || to_char(p_receipt_class_id));
1029: arp_standard.debug( 'value of p_currency_code ' ||p_currency_code);
1030: arp_standard.debug( 'value of p_approve_flag ' ||p_approve_flag);
1023: IF PG_DEBUG in ('Y', 'C') THEN
1024: arp_standard.debug('autorecapi start ()+');
1025: arp_standard.debug( 'value of p_gl_date ' ||p_gl_date);
1026: arp_standard.debug( 'value of batch_date ' ||p_batch_date);
1027: arp_standard.debug( 'value of p_receipt_method_id '|| to_char(p_receipt_method_id));
1028: arp_standard.debug( 'value of p_receipt_class_id ' || to_char(p_receipt_class_id));
1029: arp_standard.debug( 'value of p_currency_code ' ||p_currency_code);
1030: arp_standard.debug( 'value of p_approve_flag ' ||p_approve_flag);
1031: arp_standard.debug( 'value of p_format_flag '||p_format_flag);
1024: arp_standard.debug('autorecapi start ()+');
1025: arp_standard.debug( 'value of p_gl_date ' ||p_gl_date);
1026: arp_standard.debug( 'value of batch_date ' ||p_batch_date);
1027: arp_standard.debug( 'value of p_receipt_method_id '|| to_char(p_receipt_method_id));
1028: arp_standard.debug( 'value of p_receipt_class_id ' || to_char(p_receipt_class_id));
1029: arp_standard.debug( 'value of p_currency_code ' ||p_currency_code);
1030: arp_standard.debug( 'value of p_approve_flag ' ||p_approve_flag);
1031: arp_standard.debug( 'value of p_format_flag '||p_format_flag);
1032: arp_standard.debug( 'value of p_create_flag '||p_create_flag);
1025: arp_standard.debug( 'value of p_gl_date ' ||p_gl_date);
1026: arp_standard.debug( 'value of batch_date ' ||p_batch_date);
1027: arp_standard.debug( 'value of p_receipt_method_id '|| to_char(p_receipt_method_id));
1028: arp_standard.debug( 'value of p_receipt_class_id ' || to_char(p_receipt_class_id));
1029: arp_standard.debug( 'value of p_currency_code ' ||p_currency_code);
1030: arp_standard.debug( 'value of p_approve_flag ' ||p_approve_flag);
1031: arp_standard.debug( 'value of p_format_flag '||p_format_flag);
1032: arp_standard.debug( 'value of p_create_flag '||p_create_flag);
1033: END IF;
1026: arp_standard.debug( 'value of batch_date ' ||p_batch_date);
1027: arp_standard.debug( 'value of p_receipt_method_id '|| to_char(p_receipt_method_id));
1028: arp_standard.debug( 'value of p_receipt_class_id ' || to_char(p_receipt_class_id));
1029: arp_standard.debug( 'value of p_currency_code ' ||p_currency_code);
1030: arp_standard.debug( 'value of p_approve_flag ' ||p_approve_flag);
1031: arp_standard.debug( 'value of p_format_flag '||p_format_flag);
1032: arp_standard.debug( 'value of p_create_flag '||p_create_flag);
1033: END IF;
1034:
1027: arp_standard.debug( 'value of p_receipt_method_id '|| to_char(p_receipt_method_id));
1028: arp_standard.debug( 'value of p_receipt_class_id ' || to_char(p_receipt_class_id));
1029: arp_standard.debug( 'value of p_currency_code ' ||p_currency_code);
1030: arp_standard.debug( 'value of p_approve_flag ' ||p_approve_flag);
1031: arp_standard.debug( 'value of p_format_flag '||p_format_flag);
1032: arp_standard.debug( 'value of p_create_flag '||p_create_flag);
1033: END IF;
1034:
1035:
1028: arp_standard.debug( 'value of p_receipt_class_id ' || to_char(p_receipt_class_id));
1029: arp_standard.debug( 'value of p_currency_code ' ||p_currency_code);
1030: arp_standard.debug( 'value of p_approve_flag ' ||p_approve_flag);
1031: arp_standard.debug( 'value of p_format_flag '||p_format_flag);
1032: arp_standard.debug( 'value of p_create_flag '||p_create_flag);
1033: END IF;
1034:
1035:
1036: /* insert the batch record here */
1035:
1036: /* insert the batch record here */
1037:
1038: IF PG_DEBUG in ('Y', 'C') THEN
1039: arp_standard.debug('autorecapi calling auto_batch ()+');
1040: END IF;
1041:
1042:
1043: l_batch_rec.receipt_class_id := to_number(p_receipt_class_id);
1092: p_batch_id := to_char(l_batch_id);
1093:
1094:
1095: IF p_batch_id IS NULL THEN
1096: arp_standard.debug ('WAIT HERE THE VALUE OF BATCH_ID IS NULL ERROR');
1097: G_ERROR := 'Y';
1098: END IF;
1099:
1100: IF PG_DEBUG in ('Y', 'C') THEN
1097: G_ERROR := 'Y';
1098: END IF;
1099:
1100: IF PG_DEBUG in ('Y', 'C') THEN
1101: arp_standard.debug( 'value of batch_id '||p_batch_id);
1102: END IF;
1103:
1104: IF PG_DEBUG in ('Y', 'C') THEN
1105: arp_standard.debug('autorecapi calling auto_batch end ()-');
1101: arp_standard.debug( 'value of batch_id '||p_batch_id);
1102: END IF;
1103:
1104: IF PG_DEBUG in ('Y', 'C') THEN
1105: arp_standard.debug('autorecapi calling auto_batch end ()-');
1106: END IF;
1107:
1108: /* inserted the batch record end */
1109:
1111:
1112: /* GET THE VALUES from SYSTEM PARAMETERS */
1113:
1114: IF PG_DEBUG in ('Y','C') THEN
1115: arp_standard.debug( 'get info from system parameters');
1116: END IF;
1117:
1118: BEGIN
1119: SELECT asp.site_required_flag,
1133: AND ab.set_of_books_id = gsob.set_of_books_id
1134: AND gsob.set_of_books_id = asp.set_of_books_id;
1135: EXCEPTION
1136: WHEN no_data_found THEN
1137: arp_standard.debug( 'ERROR NO DATA FOUND IN SYSTEM OPTION');
1138: G_ERROR := 'Y';
1139: END;
1140:
1141:
1139: END;
1140:
1141:
1142: IF PG_DEBUG in ('Y', 'C') THEN
1143: arp_standard.debug ( 'value of site_req_flag ' || psite_required);
1144: arp_standard.debug ( 'value of the invoices per commit' || pinvoices_per_commit);
1145: arp_standard.debug ( 'value of receipts per_commit ' || preceipts_per_commit);
1146: arp_standard.debug ( 'value of currency code' || pfunctional_currency);
1147: arp_standard.debug ( 'value of acc_method ' || pacc_method );
1140:
1141:
1142: IF PG_DEBUG in ('Y', 'C') THEN
1143: arp_standard.debug ( 'value of site_req_flag ' || psite_required);
1144: arp_standard.debug ( 'value of the invoices per commit' || pinvoices_per_commit);
1145: arp_standard.debug ( 'value of receipts per_commit ' || preceipts_per_commit);
1146: arp_standard.debug ( 'value of currency code' || pfunctional_currency);
1147: arp_standard.debug ( 'value of acc_method ' || pacc_method );
1148: END IF;
1141:
1142: IF PG_DEBUG in ('Y', 'C') THEN
1143: arp_standard.debug ( 'value of site_req_flag ' || psite_required);
1144: arp_standard.debug ( 'value of the invoices per commit' || pinvoices_per_commit);
1145: arp_standard.debug ( 'value of receipts per_commit ' || preceipts_per_commit);
1146: arp_standard.debug ( 'value of currency code' || pfunctional_currency);
1147: arp_standard.debug ( 'value of acc_method ' || pacc_method );
1148: END IF;
1149:
1142: IF PG_DEBUG in ('Y', 'C') THEN
1143: arp_standard.debug ( 'value of site_req_flag ' || psite_required);
1144: arp_standard.debug ( 'value of the invoices per commit' || pinvoices_per_commit);
1145: arp_standard.debug ( 'value of receipts per_commit ' || preceipts_per_commit);
1146: arp_standard.debug ( 'value of currency code' || pfunctional_currency);
1147: arp_standard.debug ( 'value of acc_method ' || pacc_method );
1148: END IF;
1149:
1150: /* END FROM SYSTEM PARAMETERS*/
1143: arp_standard.debug ( 'value of site_req_flag ' || psite_required);
1144: arp_standard.debug ( 'value of the invoices per commit' || pinvoices_per_commit);
1145: arp_standard.debug ( 'value of receipts per_commit ' || preceipts_per_commit);
1146: arp_standard.debug ( 'value of currency code' || pfunctional_currency);
1147: arp_standard.debug ( 'value of acc_method ' || pacc_method );
1148: END IF;
1149:
1150: /* END FROM SYSTEM PARAMETERS*/
1151:
1149:
1150: /* END FROM SYSTEM PARAMETERS*/
1151:
1152: IF PG_DEBUG in ('Y', 'C') THEN
1153: arp_standard.debug(' end geting values from sys param ()-');
1154: END IF;
1155:
1156: EXCEPTION
1157: WHEN others THEN
1155:
1156: EXCEPTION
1157: WHEN others THEN
1158: IF PG_DEBUG in ('Y', 'C') THEN
1159: arp_standard.debug('Exception : insert_batch() ');
1160: G_ERROR := 'Y';
1161: END IF;
1162: END insert_batch;
1163:
1244: BEGIN
1245:
1246:
1247: IF PG_DEBUG in ('Y', 'C') THEN
1248: arp_standard.debug('selinv start ()+');
1249: arp_standard.debug ( 'the value of batch_id' || to_char(p_batch_id));
1250: arp_standard.debug( ' the error here is ' || SQLERRM );
1251: END IF;
1252:
1245:
1246:
1247: IF PG_DEBUG in ('Y', 'C') THEN
1248: arp_standard.debug('selinv start ()+');
1249: arp_standard.debug ( 'the value of batch_id' || to_char(p_batch_id));
1250: arp_standard.debug( ' the error here is ' || SQLERRM );
1251: END IF;
1252:
1253:
1246:
1247: IF PG_DEBUG in ('Y', 'C') THEN
1248: arp_standard.debug('selinv start ()+');
1249: arp_standard.debug ( 'the value of batch_id' || to_char(p_batch_id));
1250: arp_standard.debug( ' the error here is ' || SQLERRM );
1251: END IF;
1252:
1253:
1254: SELECT b.currency_code,
1266: AND r.receipt_method_id = p_receipt_method_id;
1267:
1268: --- Print the parameters in the debug file
1269: IF PG_DEBUG in ('Y', 'C') THEN
1270: arp_standard.debug('selinv start ()+');
1271: arp_standard.debug( 'value of p_currency_code '||p_currency_code);
1272: arp_standard.debug( 'value of p_batch_date '||p_batch_date);
1273: arp_standard.debug( 'value of p_lead_days '||p_lead_days);
1274: arp_standard.debug( 'value of p_receipt_method_id '||p_receipt_method_id);
1267:
1268: --- Print the parameters in the debug file
1269: IF PG_DEBUG in ('Y', 'C') THEN
1270: arp_standard.debug('selinv start ()+');
1271: arp_standard.debug( 'value of p_currency_code '||p_currency_code);
1272: arp_standard.debug( 'value of p_batch_date '||p_batch_date);
1273: arp_standard.debug( 'value of p_lead_days '||p_lead_days);
1274: arp_standard.debug( 'value of p_receipt_method_id '||p_receipt_method_id);
1275: arp_standard.debug( 'value of p_batch_id'||p_batch_id);
1268: --- Print the parameters in the debug file
1269: IF PG_DEBUG in ('Y', 'C') THEN
1270: arp_standard.debug('selinv start ()+');
1271: arp_standard.debug( 'value of p_currency_code '||p_currency_code);
1272: arp_standard.debug( 'value of p_batch_date '||p_batch_date);
1273: arp_standard.debug( 'value of p_lead_days '||p_lead_days);
1274: arp_standard.debug( 'value of p_receipt_method_id '||p_receipt_method_id);
1275: arp_standard.debug( 'value of p_batch_id'||p_batch_id);
1276: arp_standard.debug( 'value of p_creation_rule'||p_creation_rule);
1269: IF PG_DEBUG in ('Y', 'C') THEN
1270: arp_standard.debug('selinv start ()+');
1271: arp_standard.debug( 'value of p_currency_code '||p_currency_code);
1272: arp_standard.debug( 'value of p_batch_date '||p_batch_date);
1273: arp_standard.debug( 'value of p_lead_days '||p_lead_days);
1274: arp_standard.debug( 'value of p_receipt_method_id '||p_receipt_method_id);
1275: arp_standard.debug( 'value of p_batch_id'||p_batch_id);
1276: arp_standard.debug( 'value of p_creation_rule'||p_creation_rule);
1277: END IF;
1270: arp_standard.debug('selinv start ()+');
1271: arp_standard.debug( 'value of p_currency_code '||p_currency_code);
1272: arp_standard.debug( 'value of p_batch_date '||p_batch_date);
1273: arp_standard.debug( 'value of p_lead_days '||p_lead_days);
1274: arp_standard.debug( 'value of p_receipt_method_id '||p_receipt_method_id);
1275: arp_standard.debug( 'value of p_batch_id'||p_batch_id);
1276: arp_standard.debug( 'value of p_creation_rule'||p_creation_rule);
1277: END IF;
1278:
1271: arp_standard.debug( 'value of p_currency_code '||p_currency_code);
1272: arp_standard.debug( 'value of p_batch_date '||p_batch_date);
1273: arp_standard.debug( 'value of p_lead_days '||p_lead_days);
1274: arp_standard.debug( 'value of p_receipt_method_id '||p_receipt_method_id);
1275: arp_standard.debug( 'value of p_batch_id'||p_batch_id);
1276: arp_standard.debug( 'value of p_creation_rule'||p_creation_rule);
1277: END IF;
1278:
1279: -- Build the query dynamically based on the input parameters
1272: arp_standard.debug( 'value of p_batch_date '||p_batch_date);
1273: arp_standard.debug( 'value of p_lead_days '||p_lead_days);
1274: arp_standard.debug( 'value of p_receipt_method_id '||p_receipt_method_id);
1275: arp_standard.debug( 'value of p_batch_id'||p_batch_id);
1276: arp_standard.debug( 'value of p_creation_rule'||p_creation_rule);
1277: END IF;
1278:
1279: -- Build the query dynamically based on the input parameters
1280: l_sel_stmt := '
1489:
1490:
1491:
1492: IF PG_DEBUG in ('Y', 'C') THEN
1493: arp_standard.debug( 'the select statemnt' || l_sel_stmt);
1494: END IF;
1495:
1496: l_rows_processed := dbms_sql.execute( trx_invoices);
1497:
1497:
1498: i:= 0;
1499:
1500: WHILE dbms_sql.fetch_rows( trx_invoices) > 0 LOOP
1501: arp_standard.debug ('the value of i- ent ' || to_char(i));
1502: dbms_sql.column_value (trx_invoices, 1, p_payment_schedule_id);
1503: dbms_sql.column_value (trx_invoices, 2, p_customer_trx_id);
1504: dbms_sql.column_value (trx_invoices, 3, p_cash_receipt_id);
1505: dbms_sql.column_value (trx_invoices, 4, p_paying_customer_id);
1512: dbms_sql.column_value (trx_invoices, 11, p_payment_channel_code);
1513: dbms_sql.column_value (trx_invoices, 12, p_instrument_type);
1514:
1515: IF PG_DEBUG in ( 'Y','C') THEN
1516: arp_standard.debug ('the value of ps_id ' || p_payment_schedule_id);
1517: arp_standard.debug ('the value of payment_trxn_id ' || p_payment_trxn_extension_id);
1518: arp_standard.debug ('the value of i ' || to_char(i));
1519: END IF;
1520:
1513: dbms_sql.column_value (trx_invoices, 12, p_instrument_type);
1514:
1515: IF PG_DEBUG in ( 'Y','C') THEN
1516: arp_standard.debug ('the value of ps_id ' || p_payment_schedule_id);
1517: arp_standard.debug ('the value of payment_trxn_id ' || p_payment_trxn_extension_id);
1518: arp_standard.debug ('the value of i ' || to_char(i));
1519: END IF;
1520:
1521: -- copying values to array elements
1514:
1515: IF PG_DEBUG in ( 'Y','C') THEN
1516: arp_standard.debug ('the value of ps_id ' || p_payment_schedule_id);
1517: arp_standard.debug ('the value of payment_trxn_id ' || p_payment_trxn_extension_id);
1518: arp_standard.debug ('the value of i ' || to_char(i));
1519: END IF;
1520:
1521: -- copying values to array elements
1522: ps_id_array(i) := p_payment_schedule_id;
1534:
1535: i := i + 1;
1536:
1537: IF PG_DEBUG in ('Y', 'C') THEN
1538: arp_standard.debug ('the value of i- lea ' || to_char(i));
1539: END IF;
1540:
1541: END LOOP;
1542:
1542:
1543: l_rows_fetched := dbms_sql.last_row_count ;
1544:
1545: IF PG_DEBUG in ('Y', 'C') THEN
1546: arp_standard.debug ('the no of rows fetched ' || l_rows_fetched);
1547: END IF;
1548:
1549: dbms_sql.close_cursor( trx_invoices);
1550:
1594: EXCEPTION
1595: WHEN others THEN
1596: G_ERROR := 'Y';
1597: IF PG_DEBUG in ('Y', 'C') THEN
1598: arp_standard.debug('Exception : selinv() '|| SQLERRM);
1599: arp_standard.debug( 'the select statemnt' || l_sel_stmt);
1600:
1601: END IF;
1602: RAISE; -- Changed as per Bug:5331158 for returning the error to environment
1595: WHEN others THEN
1596: G_ERROR := 'Y';
1597: IF PG_DEBUG in ('Y', 'C') THEN
1598: arp_standard.debug('Exception : selinv() '|| SQLERRM);
1599: arp_standard.debug( 'the select statemnt' || l_sel_stmt);
1600:
1601: END IF;
1602: RAISE; -- Changed as per Bug:5331158 for returning the error to environment
1603:
1633:
1634: BEGIN
1635:
1636: IF PG_DEBUG in ('Y', 'C') THEN
1637: arp_standard.debug( 'Get_Invoice_Bal_After_Disc()+' );
1638: arp_standard.debug( 'p_applied_payment_schedule_id :-' || p_applied_payment_schedule_id );
1639: arp_standard.debug( 'p_apply_date :-' || p_apply_date );
1640: END IF;
1641:
1634: BEGIN
1635:
1636: IF PG_DEBUG in ('Y', 'C') THEN
1637: arp_standard.debug( 'Get_Invoice_Bal_After_Disc()+' );
1638: arp_standard.debug( 'p_applied_payment_schedule_id :-' || p_applied_payment_schedule_id );
1639: arp_standard.debug( 'p_apply_date :-' || p_apply_date );
1640: END IF;
1641:
1642: l_applied_payment_schedule_id := p_applied_payment_schedule_id;
1635:
1636: IF PG_DEBUG in ('Y', 'C') THEN
1637: arp_standard.debug( 'Get_Invoice_Bal_After_Disc()+' );
1638: arp_standard.debug( 'p_applied_payment_schedule_id :-' || p_applied_payment_schedule_id );
1639: arp_standard.debug( 'p_apply_date :-' || p_apply_date );
1640: END IF;
1641:
1642: l_applied_payment_schedule_id := p_applied_payment_schedule_id;
1643: l_apply_date := p_apply_date;
1707: p_return_status => l_return_status
1708: );
1709:
1710: IF PG_DEBUG in ('Y', 'C') THEN
1711: arp_standard.debug( 'l_amount_to_be_applied :- '|| l_amount_to_be_applied );
1712: arp_standard.debug( 'l_discount :- '|| l_discount );
1713: arp_standard.debug( 'l_discount_max_allowed :- '|| l_discount_max_allowed );
1714: arp_standard.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
1715: arp_standard.debug( 'l_discount_earned :- '|| l_discount_earned );
1708: );
1709:
1710: IF PG_DEBUG in ('Y', 'C') THEN
1711: arp_standard.debug( 'l_amount_to_be_applied :- '|| l_amount_to_be_applied );
1712: arp_standard.debug( 'l_discount :- '|| l_discount );
1713: arp_standard.debug( 'l_discount_max_allowed :- '|| l_discount_max_allowed );
1714: arp_standard.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
1715: arp_standard.debug( 'l_discount_earned :- '|| l_discount_earned );
1716: arp_standard.debug( 'l_discount_unearned :- '|| l_discount_unearned );
1709:
1710: IF PG_DEBUG in ('Y', 'C') THEN
1711: arp_standard.debug( 'l_amount_to_be_applied :- '|| l_amount_to_be_applied );
1712: arp_standard.debug( 'l_discount :- '|| l_discount );
1713: arp_standard.debug( 'l_discount_max_allowed :- '|| l_discount_max_allowed );
1714: arp_standard.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
1715: arp_standard.debug( 'l_discount_earned :- '|| l_discount_earned );
1716: arp_standard.debug( 'l_discount_unearned :- '|| l_discount_unearned );
1717: arp_standard.debug( 'l_new_amount_due_remaining :- '|| l_new_amount_due_remaining );
1710: IF PG_DEBUG in ('Y', 'C') THEN
1711: arp_standard.debug( 'l_amount_to_be_applied :- '|| l_amount_to_be_applied );
1712: arp_standard.debug( 'l_discount :- '|| l_discount );
1713: arp_standard.debug( 'l_discount_max_allowed :- '|| l_discount_max_allowed );
1714: arp_standard.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
1715: arp_standard.debug( 'l_discount_earned :- '|| l_discount_earned );
1716: arp_standard.debug( 'l_discount_unearned :- '|| l_discount_unearned );
1717: arp_standard.debug( 'l_new_amount_due_remaining :- '|| l_new_amount_due_remaining );
1718: arp_standard.debug( 'l_return_status :- '|| l_return_status );
1711: arp_standard.debug( 'l_amount_to_be_applied :- '|| l_amount_to_be_applied );
1712: arp_standard.debug( 'l_discount :- '|| l_discount );
1713: arp_standard.debug( 'l_discount_max_allowed :- '|| l_discount_max_allowed );
1714: arp_standard.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
1715: arp_standard.debug( 'l_discount_earned :- '|| l_discount_earned );
1716: arp_standard.debug( 'l_discount_unearned :- '|| l_discount_unearned );
1717: arp_standard.debug( 'l_new_amount_due_remaining :- '|| l_new_amount_due_remaining );
1718: arp_standard.debug( 'l_return_status :- '|| l_return_status );
1719: END IF;
1712: arp_standard.debug( 'l_discount :- '|| l_discount );
1713: arp_standard.debug( 'l_discount_max_allowed :- '|| l_discount_max_allowed );
1714: arp_standard.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
1715: arp_standard.debug( 'l_discount_earned :- '|| l_discount_earned );
1716: arp_standard.debug( 'l_discount_unearned :- '|| l_discount_unearned );
1717: arp_standard.debug( 'l_new_amount_due_remaining :- '|| l_new_amount_due_remaining );
1718: arp_standard.debug( 'l_return_status :- '|| l_return_status );
1719: END IF;
1720:
1713: arp_standard.debug( 'l_discount_max_allowed :- '|| l_discount_max_allowed );
1714: arp_standard.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
1715: arp_standard.debug( 'l_discount_earned :- '|| l_discount_earned );
1716: arp_standard.debug( 'l_discount_unearned :- '|| l_discount_unearned );
1717: arp_standard.debug( 'l_new_amount_due_remaining :- '|| l_new_amount_due_remaining );
1718: arp_standard.debug( 'l_return_status :- '|| l_return_status );
1719: END IF;
1720:
1721: IF PG_DEBUG in ('Y', 'C') THEN
1714: arp_standard.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
1715: arp_standard.debug( 'l_discount_earned :- '|| l_discount_earned );
1716: arp_standard.debug( 'l_discount_unearned :- '|| l_discount_unearned );
1717: arp_standard.debug( 'l_new_amount_due_remaining :- '|| l_new_amount_due_remaining );
1718: arp_standard.debug( 'l_return_status :- '|| l_return_status );
1719: END IF;
1720:
1721: IF PG_DEBUG in ('Y', 'C') THEN
1722: arp_standard.debug( 'Get_Invoice_Bal_After_Disc()-' );
1718: arp_standard.debug( 'l_return_status :- '|| l_return_status );
1719: END IF;
1720:
1721: IF PG_DEBUG in ('Y', 'C') THEN
1722: arp_standard.debug( 'Get_Invoice_Bal_After_Disc()-' );
1723: END IF;
1724:
1725: RETURN l_amount_to_be_applied;
1726:
1727: EXCEPTION
1728: WHEN OTHERS THEN
1729: l_return_status := 'E';
1730: IF PG_DEBUG in ('Y', 'C') THEN
1731: arp_standard.debug( 'l_return_status :- '|| l_return_status );
1732: arp_standard.debug( 'Exception in Get_Invoice_Bal_After_Disc()!!!' );
1733: END IF;
1734: RAISE;
1735: END Get_Invoice_Bal_After_Disc;
1728: WHEN OTHERS THEN
1729: l_return_status := 'E';
1730: IF PG_DEBUG in ('Y', 'C') THEN
1731: arp_standard.debug( 'l_return_status :- '|| l_return_status );
1732: arp_standard.debug( 'Exception in Get_Invoice_Bal_After_Disc()!!!' );
1733: END IF;
1734: RAISE;
1735: END Get_Invoice_Bal_After_Disc;
1736:
1782: l_request_id NUMBER(15);
1783:
1784: BEGIN
1785:
1786: l_request_id := arp_standard.profile.request_id;
1787:
1788: IF PG_DEBUG in ('Y', 'C') THEN
1789: arp_standard.debug('GVCR start ()+');
1790: arp_standard.debug( 'value of batch_id '||p_batch_id);
1785:
1786: l_request_id := arp_standard.profile.request_id;
1787:
1788: IF PG_DEBUG in ('Y', 'C') THEN
1789: arp_standard.debug('GVCR start ()+');
1790: arp_standard.debug( 'value of batch_id '||p_batch_id);
1791: arp_standard.debug( 'value of request_id '||l_request_id);
1792: arp_standard.debug( 'value of p_receipt_method_id '||p_receipt_method_id);
1793: END IF;
1786: l_request_id := arp_standard.profile.request_id;
1787:
1788: IF PG_DEBUG in ('Y', 'C') THEN
1789: arp_standard.debug('GVCR start ()+');
1790: arp_standard.debug( 'value of batch_id '||p_batch_id);
1791: arp_standard.debug( 'value of request_id '||l_request_id);
1792: arp_standard.debug( 'value of p_receipt_method_id '||p_receipt_method_id);
1793: END IF;
1794:
1787:
1788: IF PG_DEBUG in ('Y', 'C') THEN
1789: arp_standard.debug('GVCR start ()+');
1790: arp_standard.debug( 'value of batch_id '||p_batch_id);
1791: arp_standard.debug( 'value of request_id '||l_request_id);
1792: arp_standard.debug( 'value of p_receipt_method_id '||p_receipt_method_id);
1793: END IF;
1794:
1795:
1788: IF PG_DEBUG in ('Y', 'C') THEN
1789: arp_standard.debug('GVCR start ()+');
1790: arp_standard.debug( 'value of batch_id '||p_batch_id);
1791: arp_standard.debug( 'value of request_id '||l_request_id);
1792: arp_standard.debug( 'value of p_receipt_method_id '||p_receipt_method_id);
1793: END IF;
1794:
1795:
1796: SELECT receipt_creation_rule_code,receipt_class_id
1808:
1809:
1810:
1811: IF PG_DEBUG in ('Y', 'C') THEN
1812: arp_standard.debug('p_creation_rule'|| p_creation_rule);
1813: arp_standard.debug('l_called_from'|| l_called_from);
1814: END IF;
1815:
1816: /* NOTE HERE WE WILL NEED SEPERATE LOOPS FOR
1809:
1810:
1811: IF PG_DEBUG in ('Y', 'C') THEN
1812: arp_standard.debug('p_creation_rule'|| p_creation_rule);
1813: arp_standard.debug('l_called_from'|| l_called_from);
1814: END IF;
1815:
1816: /* NOTE HERE WE WILL NEED SEPERATE LOOPS FOR
1817:
1891: THEN
1892:
1893: IF (l_doc_sequence_value is not NULL)
1894: THEN
1895: arp_standard.debug ('SUCCESS ' || l_doc_sequence_value);
1896:
1897: UPDATE AR_RECEIPTS_GT
1898: SET RECEIPT_NUMBER = p_receipt_method_id||'-'||l_doc_sequence_value
1899: WHERE payment_schedule_id = cust1.payment_schedule_id;
1897: UPDATE AR_RECEIPTS_GT
1898: SET RECEIPT_NUMBER = p_receipt_method_id||'-'||l_doc_sequence_value
1899: WHERE payment_schedule_id = cust1.payment_schedule_id;
1900:
1901: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
1902:
1903: ELSE
1904:
1905: arp_standard.debug ( 'ERROR!!!!');
1901: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
1902:
1903: ELSE
1904:
1905: arp_standard.debug ( 'ERROR!!!!');
1906: G_ERROR := 'Y';
1907:
1908: END IF;
1909:
1908: END IF;
1909:
1910: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
1911:
1912: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
1913: G_ERROR := 'Y';
1914:
1915:
1916: ELSE
1913: G_ERROR := 'Y';
1914:
1915:
1916: ELSE
1917: arp_standard.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
1918: G_ERROR := 'Y';
1919:
1920: END IF;
1921:
1920: END IF;
1921:
1922: END LOOP;
1923: ELSE
1924: arp_standard.debug ('receipt_inherit_inv_num_flag : Y');
1925:
1926: update ar_receipts_gt arg
1927: set receipt_number = (select trx_number||decode(terms_sequence_number,1,'','-'||terms_sequence_number)
1928: from ar_payment_schedules ps
1929: where ps.payment_schedule_id = arg.payment_schedule_id
1930: and rownum = 1)
1931: where payment_schedule_id > 0;
1932:
1933: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated to set receipt_number.');
1934: END IF;
1935:
1936: EXCEPTION WHEN OTHERS THEN
1937: arp_standard.debug ( 'error in doc seq');
1933: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated to set receipt_number.');
1934: END IF;
1935:
1936: EXCEPTION WHEN OTHERS THEN
1937: arp_standard.debug ( 'error in doc seq');
1938: G_ERROR := 'Y';
1939:
1940: END;
1941:
1968: /* calling create cash */
1969:
1970: BEGIN
1971:
1972: arp_standard.debug('Start calling receipts api');
1973:
1974: FOR R2 IN c2 LOOP
1975:
1976: /* INITILIAZE the OUT variables */
1994: AND currency_code = p_currency_code); -- Currency_Code Condition Added for Bug:5488085
1995:
1996: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN
1997:
1998: arp_standard.debug('l_err_code '||l_err_code);
1999:
2000: insert_exceptions(
2001: p_batch_id =>p_batch_id,
2002: p_request_id =>l_request_id,
2026: from ar_payment_schedules
2027: where payment_schedule_id = R2.payment_schedule_id;
2028:
2029:
2030: arp_standard.debug( 'l_installment = '|| l_installment);
2031:
2032: /* Bug 6843312: Added p_customer_site_use_id => R2.pay_site_use_id in call to create_cash API */
2033:
2034: AR_RECEIPT_API_PUB.create_cash
2055: p_payment_trxn_extension_id => R2.pmt_trxn_ext_id,
2056: p_cr_id => l_cr_id,
2057: p_called_from =>l_called_from
2058: );
2059: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
2060: arp_standard.debug('x_return_status: '||l_return_status);
2061: IF l_return_status = 'S' THEN
2062: Update ar_receipts_gt set cash_receipt_id = l_cr_id
2063: where receipt_number = R2.rec_num
2056: p_cr_id => l_cr_id,
2057: p_called_from =>l_called_from
2058: );
2059: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
2060: arp_standard.debug('x_return_status: '||l_return_status);
2061: IF l_return_status = 'S' THEN
2062: Update ar_receipts_gt set cash_receipt_id = l_cr_id
2063: where receipt_number = R2.rec_num
2064: and customer_trx_id = R2.customer_trx_id
2076: and payment_schedule_id = R2.payment_schedule_id;
2077: /*bug7117223 end*/
2078: IF l_msg_count = 1 Then
2079:
2080: arp_standard.debug('l_msg_data '||l_msg_data);
2081:
2082: arp_standard.debug ( 'the message data is ' || l_msg_data );
2083:
2084:
2078: IF l_msg_count = 1 Then
2079:
2080: arp_standard.debug('l_msg_data '||l_msg_data);
2081:
2082: arp_standard.debug ( 'the message data is ' || l_msg_data );
2083:
2084:
2085: insert_exceptions(
2086: p_batch_id =>p_batch_id,
2096: IF nvl(l_count,0) < l_msg_count THEN
2097: l_count := nvl(l_count,0) +1 ;
2098: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2099:
2100: arp_standard.debug ( 'the number is ' || l_count );
2101: arp_standard.debug ( 'the message data is ' || l_msg_data );
2102:
2103:
2104: insert_exceptions(
2097: l_count := nvl(l_count,0) +1 ;
2098: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2099:
2100: arp_standard.debug ( 'the number is ' || l_count );
2101: arp_standard.debug ( 'the message data is ' || l_msg_data );
2102:
2103:
2104: insert_exceptions(
2105: p_batch_id =>p_batch_id,
2194: THEN
2195:
2196: IF (l_doc_sequence_value is not NULL)
2197: THEN
2198: arp_standard.debug ('SUCCESS ' || l_doc_sequence_value);
2199:
2200:
2201: UPDATE AR_RECEIPTS_GT
2202: SET RECEIPT_NUMBER = p_receipt_method_id||'-'||l_doc_sequence_value
2202: SET RECEIPT_NUMBER = p_receipt_method_id||'-'||l_doc_sequence_value
2203: WHERE paying_customer_id = cust2.paying_customer_id
2204: AND payment_instrument = cust2.payment_instrument;
2205:
2206: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
2207:
2208: ELSE
2209:
2210: arp_standard.debug ( 'ERROR!!!!');
2206: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
2207:
2208: ELSE
2209:
2210: arp_standard.debug ( 'ERROR!!!!');
2211: G_ERROR := 'Y';
2212:
2213: END IF;
2214:
2213: END IF;
2214:
2215: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
2216:
2217: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
2218: G_ERROR := 'Y';
2219:
2220:
2221: ELSE
2218: G_ERROR := 'Y';
2219:
2220:
2221: ELSE
2222: arp_standard.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
2223: G_ERROR := 'Y';
2224:
2225:
2226: END IF;
2227:
2228: END LOOP;
2229:
2230: EXCEPTION WHEN OTHERS THEN
2231: arp_standard.debug ( 'error in doc seq');
2232: G_ERROR := 'Y';
2233:
2234: END;
2235:
2257: /* calling create cash */
2258:
2259: BEGIN
2260:
2261: arp_standard.debug('Start calling receipts api');
2262:
2263:
2264: FOR R1 IN c1 LOOP
2265:
2283: AND currency_code = p_currency_code); -- For Bug:5488085
2284:
2285: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN
2286:
2287: arp_standard.debug('l_err_code '||l_err_code);
2288:
2289: DECLARE
2290: cursor c1_inv is
2291: select payment_schedule_id
2325: where receipt_number = R1.rec_num
2326: and paying_customer_id = R1.pay_cust_id
2327: and rownum = 1;
2328:
2329: arp_standard.debug('l_payment_trxn_extension_id '||l_payment_trxn_extension_id );
2330:
2331:
2332:
2333:
2354: p_payment_trxn_extension_id =>l_payment_trxn_extension_id,
2355: p_cr_id => l_cr_id,
2356: p_called_from =>l_called_from
2357: );
2358: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
2359: arp_standard.debug('x_return_status: '||l_return_status);
2360:
2361: IF l_return_status = 'S' THEN
2362: Update ar_receipts_gt set cash_receipt_id = l_cr_id
2355: p_cr_id => l_cr_id,
2356: p_called_from =>l_called_from
2357: );
2358: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
2359: arp_standard.debug('x_return_status: '||l_return_status);
2360:
2361: IF l_return_status = 'S' THEN
2362: Update ar_receipts_gt set cash_receipt_id = l_cr_id
2363: where receipt_number = R1.rec_num;
2370: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R1.rec_num;
2371: /*bug7117223 end*/
2372: IF l_msg_count = 1 Then
2373:
2374: arp_standard.debug('l_msg_data '||l_msg_data);
2375:
2376: insert_exceptions(
2377: p_batch_id =>p_batch_id,
2378: p_request_id =>l_request_id,
2387: IF nvl(l_count,0) < l_msg_count THEN
2388: l_count := nvl(l_count,0) +1 ;
2389: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2390:
2391: arp_standard.debug ( 'the number is ' || l_count );
2392: arp_standard.debug ( 'the message data is ' || l_msg_data );
2393:
2394:
2395: insert_exceptions(
2388: l_count := nvl(l_count,0) +1 ;
2389: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2390:
2391: arp_standard.debug ( 'the number is ' || l_count );
2392: arp_standard.debug ( 'the message data is ' || l_msg_data );
2393:
2394:
2395: insert_exceptions(
2396: p_batch_id =>p_batch_id,
2483: THEN
2484:
2485: IF (l_doc_sequence_value is not NULL)
2486: THEN
2487: arp_standard.debug ('SUCCESS ' || l_doc_sequence_value);
2488:
2489:
2490: UPDATE AR_RECEIPTS_GT
2491: SET RECEIPT_NUMBER = p_receipt_method_id||'-'||l_doc_sequence_value
2491: SET RECEIPT_NUMBER = p_receipt_method_id||'-'||l_doc_sequence_value
2492: WHERE paying_site_use_id = cust3.paying_site_use_id
2493: AND payment_instrument = cust3.payment_instrument;
2494:
2495: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
2496:
2497: ELSE
2498:
2499: arp_standard.debug ( 'ERROR!!!!');
2495: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
2496:
2497: ELSE
2498:
2499: arp_standard.debug ( 'ERROR!!!!');
2500: G_ERROR := 'Y';
2501:
2502: END IF;
2503:
2502: END IF;
2503:
2504: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
2505:
2506: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
2507: G_ERROR := 'Y';
2508:
2509: ELSE
2510: arp_standard.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
2506: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
2507: G_ERROR := 'Y';
2508:
2509: ELSE
2510: arp_standard.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
2511: G_ERROR := 'Y';
2512:
2513: END IF;
2514:
2514:
2515: END LOOP;
2516:
2517: EXCEPTION WHEN OTHERS THEN
2518: arp_standard.debug ( 'error in doc seq');
2519: G_ERROR := 'Y';
2520:
2521: END;
2522:
2544: /* calling create cash */
2545:
2546: BEGIN
2547:
2548: arp_standard.debug('Start calling receipts api');
2549:
2550:
2551: FOR R3 IN c3 LOOP
2552:
2571: AND currency_code = p_currency_code); --For Bug:5488085
2572:
2573: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN
2574:
2575: arp_standard.debug('l_err_code '||l_err_code);
2576:
2577: DECLARE
2578: cursor c3_inv is
2579: select payment_schedule_id
2614: and paying_customer_id = R3.pay_cust_id
2615: and paying_site_use_id = R3.pay_site_id
2616: and rownum = 1;
2617:
2618: arp_standard.debug('l_payment_trxn_extension_id '||l_payment_trxn_extension_id );
2619:
2620:
2621:
2622:
2644: p_cr_id => l_cr_id,
2645: p_called_from =>l_called_from
2646: );
2647:
2648: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
2649: arp_standard.debug('x_return_status: '||l_return_status);
2650:
2651: IF l_return_status = 'S' THEN
2652: Update ar_receipts_gt set cash_receipt_id = l_cr_id
2645: p_called_from =>l_called_from
2646: );
2647:
2648: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
2649: arp_standard.debug('x_return_status: '||l_return_status);
2650:
2651: IF l_return_status = 'S' THEN
2652: Update ar_receipts_gt set cash_receipt_id = l_cr_id
2653: where receipt_number = R3.rec_num;
2660: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R3.rec_num;
2661: /*bug7117223 end*/
2662: IF l_msg_count = 1 Then
2663:
2664: arp_standard.debug('l_msg_data '||l_msg_data);
2665:
2666: insert_exceptions(
2667: p_batch_id =>p_batch_id,
2668: p_request_id =>l_request_id,
2678: IF nvl(l_count,0) < l_msg_count THEN
2679: l_count := nvl(l_count,0) +1 ;
2680: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2681:
2682: arp_standard.debug ( 'the number is ' || l_count );
2683: arp_standard.debug ( 'the message data is ' || l_msg_data );
2684:
2685:
2686: insert_exceptions(
2679: l_count := nvl(l_count,0) +1 ;
2680: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2681:
2682: arp_standard.debug ( 'the number is ' || l_count );
2683: arp_standard.debug ( 'the message data is ' || l_msg_data );
2684:
2685:
2686: insert_exceptions(
2687: p_batch_id =>p_batch_id,
2772: THEN
2773:
2774: IF (l_doc_sequence_value is not NULL)
2775: THEN
2776: arp_standard.debug ('SUCCESS ' || l_doc_sequence_value);
2777:
2778:
2779: UPDATE AR_RECEIPTS_GT
2780: SET RECEIPT_NUMBER = p_receipt_method_id||'-'||l_doc_sequence_value
2781: WHERE due_date = cust4.due_date
2782: AND payment_instrument = cust4.payment_instrument
2783: AND paying_site_use_id = cust4.paying_site_use_id;
2784:
2785: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
2786:
2787: ELSE
2788:
2789: arp_standard.debug ( 'ERROR!!!!');
2785: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
2786:
2787: ELSE
2788:
2789: arp_standard.debug ( 'ERROR!!!!');
2790:
2791: END IF;
2792:
2793: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
2791: END IF;
2792:
2793: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
2794:
2795: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
2796:
2797: ELSE
2798: arp_standard.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
2799: END IF;
2794:
2795: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
2796:
2797: ELSE
2798: arp_standard.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
2799: END IF;
2800:
2801: END LOOP;
2802:
2800:
2801: END LOOP;
2802:
2803: EXCEPTION WHEN OTHERS THEN
2804: arp_standard.debug ( 'error in doc seq');
2805:
2806: END;
2807:
2808:
2831: /* calling create cash */
2832:
2833: BEGIN
2834:
2835: arp_standard.debug('Start calling receipts api');
2836:
2837:
2838: FOR R4 IN c4 LOOP
2839:
2858: AND currency_code = p_currency_code);--For Bug:5488085
2859:
2860: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN
2861:
2862: arp_standard.debug('l_err_code '||l_err_code);
2863:
2864: DECLARE
2865: cursor c4_inv is
2866: select payment_schedule_id
2903: and paying_site_use_id = R4.pay_site_id
2904: and due_date = R4.due_date
2905: and rownum = 1;
2906:
2907: arp_standard.debug('l_payment_trxn_extension_id '||l_payment_trxn_extension_id );
2908:
2909:
2910:
2911:
2934: p_payment_trxn_extension_id => l_payment_trxn_extension_id,
2935: p_cr_id => l_cr_id,
2936: p_called_from =>l_called_from
2937: );
2938: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
2939: arp_standard.debug('x_return_status: '||l_return_status);
2940:
2941: IF l_return_status = 'S' THEN
2942: Update ar_receipts_gt set cash_receipt_id = l_cr_id
2935: p_cr_id => l_cr_id,
2936: p_called_from =>l_called_from
2937: );
2938: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
2939: arp_standard.debug('x_return_status: '||l_return_status);
2940:
2941: IF l_return_status = 'S' THEN
2942: Update ar_receipts_gt set cash_receipt_id = l_cr_id
2943: where receipt_number = R4.rec_num;
2950: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R4.rec_num;
2951: /*bug7117223 end*/
2952: IF l_msg_count = 1 Then
2953:
2954: arp_standard.debug('l_msg_data '||l_msg_data);
2955:
2956: insert_exceptions(
2957: p_batch_id =>p_batch_id,
2958: p_request_id =>l_request_id,
2971: IF nvl(l_count,0) < l_msg_count THEN
2972: l_count := nvl(l_count,0) +1 ;
2973: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2974:
2975: arp_standard.debug ( 'the number is ' || l_count );
2976: arp_standard.debug ( 'the message data is ' || l_msg_data );
2977:
2978:
2979: insert_exceptions(
2972: l_count := nvl(l_count,0) +1 ;
2973: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2974:
2975: arp_standard.debug ( 'the number is ' || l_count );
2976: arp_standard.debug ( 'the message data is ' || l_msg_data );
2977:
2978:
2979: insert_exceptions(
2980: p_batch_id =>p_batch_id,
3066: THEN
3067:
3068: IF (l_doc_sequence_value is not NULL)
3069: THEN
3070: arp_standard.debug ('SUCCESS ' || l_doc_sequence_value);
3071:
3072:
3073: UPDATE AR_RECEIPTS_GT
3074: SET RECEIPT_NUMBER = p_receipt_method_id||'-'||l_doc_sequence_value
3074: SET RECEIPT_NUMBER = p_receipt_method_id||'-'||l_doc_sequence_value
3075: WHERE due_date = cust5.due_date
3076: AND payment_instrument = cust5.payment_instrument;
3077:
3078: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
3079:
3080: ELSE
3081:
3082: arp_standard.debug ( 'ERROR!!!!');
3078: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
3079:
3080: ELSE
3081:
3082: arp_standard.debug ( 'ERROR!!!!');
3083:
3084: END IF;
3085:
3086: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
3084: END IF;
3085:
3086: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
3087:
3088: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
3089: ELSE
3090: arp_standard.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
3091: END IF;
3092:
3086: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
3087:
3088: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
3089: ELSE
3090: arp_standard.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
3091: END IF;
3092:
3093: END LOOP;
3094:
3092:
3093: END LOOP;
3094:
3095: EXCEPTION WHEN OTHERS THEN
3096: arp_standard.debug ( 'error in doc seq');
3097:
3098: END;
3099:
3100: /* doc number updation end PER_customer_due_date */
3121: /* calling create cash */
3122:
3123: BEGIN
3124:
3125: arp_standard.debug('Start calling receipts api');
3126:
3127:
3128: FOR R5 IN c5 LOOP
3129:
3148: AND currency_code = p_currency_code); --For Bug:5488085
3149:
3150: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN
3151:
3152: arp_standard.debug('l_err_code '||l_err_code);
3153:
3154: DECLARE
3155: cursor c5_inv is
3156: select payment_schedule_id
3191: and paying_customer_id = R5.pay_cust_id
3192: and due_date = R5.due_date
3193: and rownum = 1;
3194:
3195: arp_standard.debug('l_payment_trxn_extension_id '||l_payment_trxn_extension_id );
3196:
3197:
3198:
3199:
3221: p_payment_trxn_extension_id => l_payment_trxn_extension_id,
3222: p_cr_id => l_cr_id,
3223: p_called_from =>l_called_from
3224: );
3225: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
3226: arp_standard.debug('x_return_status: '||l_return_status);
3227:
3228: IF l_return_status = 'S' THEN
3229: Update ar_receipts_gt set cash_receipt_id = l_cr_id
3222: p_cr_id => l_cr_id,
3223: p_called_from =>l_called_from
3224: );
3225: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
3226: arp_standard.debug('x_return_status: '||l_return_status);
3227:
3228: IF l_return_status = 'S' THEN
3229: Update ar_receipts_gt set cash_receipt_id = l_cr_id
3230: where receipt_number = R5.rec_num;
3237: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R5.rec_num;
3238: /*bug7117223 end*/
3239: IF l_msg_count = 1 Then
3240:
3241: arp_standard.debug('l_msg_data '||l_msg_data);
3242:
3243: insert_exceptions(
3244: p_batch_id =>p_batch_id,
3245: p_request_id =>l_request_id,
3258: IF nvl(l_count,0) < l_msg_count THEN
3259: l_count := nvl(l_count,0) +1 ;
3260: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
3261:
3262: arp_standard.debug ( 'the number is ' || l_count );
3263: arp_standard.debug ( 'the message data is ' || l_msg_data );
3264:
3265: insert_exceptions(
3266: p_batch_id =>p_batch_id,
3259: l_count := nvl(l_count,0) +1 ;
3260: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
3261:
3262: arp_standard.debug ( 'the number is ' || l_count );
3263: arp_standard.debug ( 'the message data is ' || l_msg_data );
3264:
3265: insert_exceptions(
3266: p_batch_id =>p_batch_id,
3267: p_request_id =>l_request_id,
3354: THEN
3355:
3356: IF (l_doc_sequence_value is not NULL)
3357: THEN
3358: arp_standard.debug ('SUCCESS ' || l_doc_sequence_value);
3359:
3360: UPDATE ar_receipts_gt
3361: SET RECEIPT_NUMBER = p_receipt_method_id||'-'||l_doc_sequence_value
3362: WHERE payment_channel_code = cust6.payment_channel_code
3361: SET RECEIPT_NUMBER = p_receipt_method_id||'-'||l_doc_sequence_value
3362: WHERE payment_channel_code = cust6.payment_channel_code
3363: and payment_trxn_extension_id = cust6.payment_trxn_extension_id;
3364:
3365: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
3366:
3367: ELSE
3368:
3369: arp_standard.debug ( 'ERROR!!!!');
3365: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
3366:
3367: ELSE
3368:
3369: arp_standard.debug ( 'ERROR!!!!');
3370:
3371: END IF;
3372:
3373: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
3371: END IF;
3372:
3373: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
3374:
3375: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
3376:
3377:
3378: ELSE
3379: arp_standard.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
3375: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
3376:
3377:
3378: ELSE
3379: arp_standard.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
3380:
3381: END IF;
3382:
3383: END LOOP;
3382:
3383: END LOOP;
3384:
3385: EXCEPTION WHEN OTHERS THEN
3386: arp_standard.debug ( 'error in doc seq');
3387:
3388: END;
3389:
3390:
3409: /* calling create cash */
3410:
3411: BEGIN
3412:
3413: arp_standard.debug('Start calling receipts api');
3414:
3415: FOR R6 IN c6 LOOP
3416:
3417: /* INITILIAZE the OUT variables */
3433: AND currency_code = p_currency_code);--For Bug:5488085
3434:
3435: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN
3436:
3437: arp_standard.debug('l_err_code '||l_err_code);
3438:
3439: DECLARE
3440: cursor c6_inv is
3441: select payment_schedule_id
3493: p_cr_id => l_cr_id,
3494: p_called_from =>l_called_from
3495: );
3496:
3497: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
3498: arp_standard.debug('x_return_status: '||l_return_status);
3499:
3500: IF l_return_status = 'S' THEN
3501: Update ar_receipts_gt set cash_receipt_id = l_cr_id
3494: p_called_from =>l_called_from
3495: );
3496:
3497: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
3498: arp_standard.debug('x_return_status: '||l_return_status);
3499:
3500: IF l_return_status = 'S' THEN
3501: Update ar_receipts_gt set cash_receipt_id = l_cr_id
3502: where receipt_number = R6.rec_num;
3509: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R6.rec_num;
3510: /*bug7117223 end*/
3511: IF l_msg_count = 1 Then
3512:
3513: arp_standard.debug('l_msg_data '||l_msg_data);
3514: insert_exceptions(
3515: p_batch_id =>p_batch_id,
3516: p_request_id =>l_request_id,
3517: p_paying_customer_id =>R6.pay_cust_id,
3524: IF nvl(l_count,0) < l_msg_count THEN
3525: l_count := nvl(l_count,0) +1 ;
3526: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
3527:
3528: arp_standard.debug ( 'the number is ' || l_count );
3529: arp_standard.debug ( 'the message data is ' || l_msg_data );
3530:
3531:
3532: insert_exceptions(
3525: l_count := nvl(l_count,0) +1 ;
3526: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
3527:
3528: arp_standard.debug ( 'the number is ' || l_count );
3529: arp_standard.debug ( 'the message data is ' || l_msg_data );
3530:
3531:
3532: insert_exceptions(
3533: p_batch_id =>p_batch_id,
3620: THEN
3621:
3622: IF (l_doc_sequence_value is not NULL)
3623: THEN
3624: arp_standard.debug ('SUCCESS ' || l_doc_sequence_value);
3625:
3626: UPDATE ar_receipts_gt
3627: SET RECEIPT_NUMBER = p_receipt_method_id||'-'||l_doc_sequence_value
3628: WHERE payment_instrument = cust7.payment_instrument
3627: SET RECEIPT_NUMBER = p_receipt_method_id||'-'||l_doc_sequence_value
3628: WHERE payment_instrument = cust7.payment_instrument
3629: and payment_trxn_extension_id = cust7.payment_trxn_extension_id;
3630:
3631: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
3632:
3633: ELSE
3634:
3635: arp_standard.debug ( 'ERROR!!!!');
3631: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
3632:
3633: ELSE
3634:
3635: arp_standard.debug ( 'ERROR!!!!');
3636:
3637: END IF;
3638:
3639: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
3637: END IF;
3638:
3639: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
3640:
3641: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
3642:
3643:
3644: ELSE
3645: arp_standard.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
3641: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
3642:
3643:
3644: ELSE
3645: arp_standard.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
3646:
3647: END IF;
3648:
3649: END LOOP;
3648:
3649: END LOOP;
3650:
3651: EXCEPTION WHEN OTHERS THEN
3652: arp_standard.debug ( 'error in doc seq');
3653:
3654: END;
3655:
3656:
3675: /* calling create cash */
3676:
3677: BEGIN
3678:
3679: arp_standard.debug('Start calling receipts api');
3680:
3681: FOR R7 IN c7 LOOP
3682:
3683: /* INITILIAZE the OUT variables */
3698: AND currency_code = p_currency_code); --For Bug:5488085
3699:
3700: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN
3701:
3702: arp_standard.debug('l_err_code '||l_err_code);
3703:
3704: DECLARE
3705: cursor c7_inv is
3706: select payment_schedule_id
3758: p_cr_id => l_cr_id,
3759: p_called_from =>l_called_from
3760: );
3761:
3762: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
3763: arp_standard.debug('x_return_status: '||l_return_status);
3764:
3765: IF l_return_status = 'S' THEN
3766: Update ar_receipts_gt set cash_receipt_id = l_cr_id
3759: p_called_from =>l_called_from
3760: );
3761:
3762: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
3763: arp_standard.debug('x_return_status: '||l_return_status);
3764:
3765: IF l_return_status = 'S' THEN
3766: Update ar_receipts_gt set cash_receipt_id = l_cr_id
3767: where receipt_number = R7.rec_num;
3774: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R7.rec_num;
3775: /*bug7117223 end*/
3776: IF l_msg_count = 1 Then
3777:
3778: arp_standard.debug('l_msg_data '||l_msg_data);
3779:
3780: insert_exceptions(
3781: p_batch_id =>p_batch_id,
3782: p_request_id =>l_request_id,
3789: IF nvl(l_count,0) < l_msg_count THEN
3790: l_count := nvl(l_count,0) +1 ;
3791: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
3792:
3793: arp_standard.debug ( 'the number is ' || l_count );
3794: arp_standard.debug ( 'the message data is ' || l_msg_data );
3795:
3796:
3797: insert_exceptions(
3790: l_count := nvl(l_count,0) +1 ;
3791: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
3792:
3793: arp_standard.debug ( 'the number is ' || l_count );
3794: arp_standard.debug ( 'the message data is ' || l_msg_data );
3795:
3796:
3797: insert_exceptions(
3798: p_batch_id =>p_batch_id,
3885: THEN
3886:
3887: IF (l_doc_sequence_value is not NULL)
3888: THEN
3889: arp_standard.debug ('SUCCESS ' || l_doc_sequence_value);
3890:
3891: UPDATE ar_receipts_gt
3892: SET RECEIPT_NUMBER = p_receipt_method_id||'-'||l_doc_sequence_value
3893: WHERE authorization_id = cust8.authorization_id
3892: SET RECEIPT_NUMBER = p_receipt_method_id||'-'||l_doc_sequence_value
3893: WHERE authorization_id = cust8.authorization_id
3894: and payment_trxn_extension_id = cust8.payment_trxn_extension_id;
3895:
3896: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
3897:
3898: ELSE
3899:
3900: arp_standard.debug ( 'ERROR!!!!');
3896: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
3897:
3898: ELSE
3899:
3900: arp_standard.debug ( 'ERROR!!!!');
3901:
3902: END IF;
3903:
3904: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
3902: END IF;
3903:
3904: ELSIF (l_status = FND_SEQNUM.NOASSIGN) THEN
3905:
3906: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
3907:
3908:
3909: ELSE
3910: arp_standard.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
3906: arp_standard.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
3907:
3908:
3909: ELSE
3910: arp_standard.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
3911:
3912: END IF;
3913:
3914: END LOOP;
3913:
3914: END LOOP;
3915:
3916: EXCEPTION WHEN OTHERS THEN
3917: arp_standard.debug ( 'error in doc seq');
3918:
3919: END;
3920:
3921:
3940: /* calling create cash */
3941:
3942: BEGIN
3943:
3944: arp_standard.debug('Start calling receipts api');
3945:
3946: FOR R8 IN c8 LOOP
3947:
3948: /* INITILIAZE the OUT variables */
3964: AND currency_code = p_currency_code); --For Bug:5488085
3965:
3966: IF l_err_code = 'ARZCAR_CUST_MIN_AMT' THEN
3967:
3968: arp_standard.debug('l_err_code '||l_err_code);
3969:
3970: DECLARE
3971: cursor c8_inv is
3972: select payment_schedule_id
4023: p_cr_id => l_cr_id,
4024: p_called_from =>l_called_from
4025: );
4026:
4027: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
4028: arp_standard.debug('x_return_status: '||l_return_status);
4029:
4030: IF l_return_status = 'S' THEN
4031: Update ar_receipts_gt set cash_receipt_id = l_cr_id
4024: p_called_from =>l_called_from
4025: );
4026:
4027: arp_standard.debug('x_cash_receipt_id: '||l_cr_id);
4028: arp_standard.debug('x_return_status: '||l_return_status);
4029:
4030: IF l_return_status = 'S' THEN
4031: Update ar_receipts_gt set cash_receipt_id = l_cr_id
4032: where receipt_number = R8.rec_num;
4039: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R8.rec_num;
4040: /*bug7117223 end*/
4041: IF l_msg_count = 1 Then
4042:
4043: arp_standard.debug('l_msg_data '||l_msg_data);
4044:
4045: insert_exceptions(
4046: p_batch_id =>p_batch_id,
4047: p_request_id =>l_request_id,
4054: IF nvl(l_count,0) < l_msg_count THEN
4055: l_count := nvl(l_count,0) +1 ;
4056: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
4057:
4058: arp_standard.debug ( 'the number is ' || l_count );
4059: arp_standard.debug ( 'the message data is ' || l_msg_data );
4060:
4061:
4062: insert_exceptions(
4055: l_count := nvl(l_count,0) +1 ;
4056: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
4057:
4058: arp_standard.debug ( 'the number is ' || l_count );
4059: arp_standard.debug ( 'the message data is ' || l_msg_data );
4060:
4061:
4062: insert_exceptions(
4063: p_batch_id =>p_batch_id,
4084: /* end calling create cash */
4085: END IF;
4086:
4087: IF PG_DEBUG in ('Y', 'C') THEN
4088: arp_standard.debug('GVCR end ()-');
4089: END IF;
4090:
4091:
4092: EXCEPTION
4102:
4103:
4104:
4105: IF PG_DEBUG in ('Y', 'C') THEN
4106: arp_standard.debug('Exception : GVCR() '|| SQLERRM);
4107: G_ERROR := 'Y';
4108: END IF;
4109:
4110:
4160: BEGIN
4161:
4162: IF PG_DEBUG in ('Y','C') THEN
4163:
4164: arp_standard.debug( 'enter insert exceptions');
4165: arp_standard.debug( 'value of p_batch_id' || p_batch_id);
4166: arp_standard.debug( 'value of p_request_id' || p_request_id);
4167: arp_standard.debug( 'value of p_cash_receipt_id' || p_cash_receipt_id);
4168: arp_standard.debug( 'value of p_payment_schedule_id' || p_payment_schedule_id);
4161:
4162: IF PG_DEBUG in ('Y','C') THEN
4163:
4164: arp_standard.debug( 'enter insert exceptions');
4165: arp_standard.debug( 'value of p_batch_id' || p_batch_id);
4166: arp_standard.debug( 'value of p_request_id' || p_request_id);
4167: arp_standard.debug( 'value of p_cash_receipt_id' || p_cash_receipt_id);
4168: arp_standard.debug( 'value of p_payment_schedule_id' || p_payment_schedule_id);
4169: arp_standard.debug( 'value of p_paying_customer_id' || p_paying_customer_id);
4162: IF PG_DEBUG in ('Y','C') THEN
4163:
4164: arp_standard.debug( 'enter insert exceptions');
4165: arp_standard.debug( 'value of p_batch_id' || p_batch_id);
4166: arp_standard.debug( 'value of p_request_id' || p_request_id);
4167: arp_standard.debug( 'value of p_cash_receipt_id' || p_cash_receipt_id);
4168: arp_standard.debug( 'value of p_payment_schedule_id' || p_payment_schedule_id);
4169: arp_standard.debug( 'value of p_paying_customer_id' || p_paying_customer_id);
4170: arp_standard.debug( 'value of p_paying_site_use_id' || p_paying_site_use_id);
4163:
4164: arp_standard.debug( 'enter insert exceptions');
4165: arp_standard.debug( 'value of p_batch_id' || p_batch_id);
4166: arp_standard.debug( 'value of p_request_id' || p_request_id);
4167: arp_standard.debug( 'value of p_cash_receipt_id' || p_cash_receipt_id);
4168: arp_standard.debug( 'value of p_payment_schedule_id' || p_payment_schedule_id);
4169: arp_standard.debug( 'value of p_paying_customer_id' || p_paying_customer_id);
4170: arp_standard.debug( 'value of p_paying_site_use_id' || p_paying_site_use_id);
4171: arp_standard.debug( 'value of p_due_date' || p_due_date);
4164: arp_standard.debug( 'enter insert exceptions');
4165: arp_standard.debug( 'value of p_batch_id' || p_batch_id);
4166: arp_standard.debug( 'value of p_request_id' || p_request_id);
4167: arp_standard.debug( 'value of p_cash_receipt_id' || p_cash_receipt_id);
4168: arp_standard.debug( 'value of p_payment_schedule_id' || p_payment_schedule_id);
4169: arp_standard.debug( 'value of p_paying_customer_id' || p_paying_customer_id);
4170: arp_standard.debug( 'value of p_paying_site_use_id' || p_paying_site_use_id);
4171: arp_standard.debug( 'value of p_due_date' || p_due_date);
4172: arp_standard.debug( 'value of p_cust_min_rec_amount' || p_cust_min_rec_amount);
4165: arp_standard.debug( 'value of p_batch_id' || p_batch_id);
4166: arp_standard.debug( 'value of p_request_id' || p_request_id);
4167: arp_standard.debug( 'value of p_cash_receipt_id' || p_cash_receipt_id);
4168: arp_standard.debug( 'value of p_payment_schedule_id' || p_payment_schedule_id);
4169: arp_standard.debug( 'value of p_paying_customer_id' || p_paying_customer_id);
4170: arp_standard.debug( 'value of p_paying_site_use_id' || p_paying_site_use_id);
4171: arp_standard.debug( 'value of p_due_date' || p_due_date);
4172: arp_standard.debug( 'value of p_cust_min_rec_amount' || p_cust_min_rec_amount);
4173: arp_standard.debug( 'value of p_bank_min_rec_amount' || p_bank_min_rec_amount);
4166: arp_standard.debug( 'value of p_request_id' || p_request_id);
4167: arp_standard.debug( 'value of p_cash_receipt_id' || p_cash_receipt_id);
4168: arp_standard.debug( 'value of p_payment_schedule_id' || p_payment_schedule_id);
4169: arp_standard.debug( 'value of p_paying_customer_id' || p_paying_customer_id);
4170: arp_standard.debug( 'value of p_paying_site_use_id' || p_paying_site_use_id);
4171: arp_standard.debug( 'value of p_due_date' || p_due_date);
4172: arp_standard.debug( 'value of p_cust_min_rec_amount' || p_cust_min_rec_amount);
4173: arp_standard.debug( 'value of p_bank_min_rec_amount' || p_bank_min_rec_amount);
4174: arp_standard.debug( 'value of p_exception_code' ||p_exception_code);
4167: arp_standard.debug( 'value of p_cash_receipt_id' || p_cash_receipt_id);
4168: arp_standard.debug( 'value of p_payment_schedule_id' || p_payment_schedule_id);
4169: arp_standard.debug( 'value of p_paying_customer_id' || p_paying_customer_id);
4170: arp_standard.debug( 'value of p_paying_site_use_id' || p_paying_site_use_id);
4171: arp_standard.debug( 'value of p_due_date' || p_due_date);
4172: arp_standard.debug( 'value of p_cust_min_rec_amount' || p_cust_min_rec_amount);
4173: arp_standard.debug( 'value of p_bank_min_rec_amount' || p_bank_min_rec_amount);
4174: arp_standard.debug( 'value of p_exception_code' ||p_exception_code);
4175: arp_standard.debug( 'value of p_additional_message' ||p_additional_message);
4168: arp_standard.debug( 'value of p_payment_schedule_id' || p_payment_schedule_id);
4169: arp_standard.debug( 'value of p_paying_customer_id' || p_paying_customer_id);
4170: arp_standard.debug( 'value of p_paying_site_use_id' || p_paying_site_use_id);
4171: arp_standard.debug( 'value of p_due_date' || p_due_date);
4172: arp_standard.debug( 'value of p_cust_min_rec_amount' || p_cust_min_rec_amount);
4173: arp_standard.debug( 'value of p_bank_min_rec_amount' || p_bank_min_rec_amount);
4174: arp_standard.debug( 'value of p_exception_code' ||p_exception_code);
4175: arp_standard.debug( 'value of p_additional_message' ||p_additional_message);
4176:
4169: arp_standard.debug( 'value of p_paying_customer_id' || p_paying_customer_id);
4170: arp_standard.debug( 'value of p_paying_site_use_id' || p_paying_site_use_id);
4171: arp_standard.debug( 'value of p_due_date' || p_due_date);
4172: arp_standard.debug( 'value of p_cust_min_rec_amount' || p_cust_min_rec_amount);
4173: arp_standard.debug( 'value of p_bank_min_rec_amount' || p_bank_min_rec_amount);
4174: arp_standard.debug( 'value of p_exception_code' ||p_exception_code);
4175: arp_standard.debug( 'value of p_additional_message' ||p_additional_message);
4176:
4177: END IF;
4170: arp_standard.debug( 'value of p_paying_site_use_id' || p_paying_site_use_id);
4171: arp_standard.debug( 'value of p_due_date' || p_due_date);
4172: arp_standard.debug( 'value of p_cust_min_rec_amount' || p_cust_min_rec_amount);
4173: arp_standard.debug( 'value of p_bank_min_rec_amount' || p_bank_min_rec_amount);
4174: arp_standard.debug( 'value of p_exception_code' ||p_exception_code);
4175: arp_standard.debug( 'value of p_additional_message' ||p_additional_message);
4176:
4177: END IF;
4178:
4171: arp_standard.debug( 'value of p_due_date' || p_due_date);
4172: arp_standard.debug( 'value of p_cust_min_rec_amount' || p_cust_min_rec_amount);
4173: arp_standard.debug( 'value of p_bank_min_rec_amount' || p_bank_min_rec_amount);
4174: arp_standard.debug( 'value of p_exception_code' ||p_exception_code);
4175: arp_standard.debug( 'value of p_additional_message' ||p_additional_message);
4176:
4177: END IF;
4178:
4179:
4178:
4179:
4180:
4181:
4182: l_request_id := arp_standard.profile.request_id;
4183: l_last_updated_by := arp_standard.profile.last_update_login ;
4184: l_created_by := arp_standard.profile.user_id ;
4185: l_last_update_login := arp_standard.profile.last_update_login ;
4186: l_program_application_id := arp_standard.application_id ;
4179:
4180:
4181:
4182: l_request_id := arp_standard.profile.request_id;
4183: l_last_updated_by := arp_standard.profile.last_update_login ;
4184: l_created_by := arp_standard.profile.user_id ;
4185: l_last_update_login := arp_standard.profile.last_update_login ;
4186: l_program_application_id := arp_standard.application_id ;
4187: l_program_id := arp_standard.profile.program_id;
4180:
4181:
4182: l_request_id := arp_standard.profile.request_id;
4183: l_last_updated_by := arp_standard.profile.last_update_login ;
4184: l_created_by := arp_standard.profile.user_id ;
4185: l_last_update_login := arp_standard.profile.last_update_login ;
4186: l_program_application_id := arp_standard.application_id ;
4187: l_program_id := arp_standard.profile.program_id;
4188: l_paying_customer_id := p_paying_customer_id;
4181:
4182: l_request_id := arp_standard.profile.request_id;
4183: l_last_updated_by := arp_standard.profile.last_update_login ;
4184: l_created_by := arp_standard.profile.user_id ;
4185: l_last_update_login := arp_standard.profile.last_update_login ;
4186: l_program_application_id := arp_standard.application_id ;
4187: l_program_id := arp_standard.profile.program_id;
4188: l_paying_customer_id := p_paying_customer_id;
4189:
4182: l_request_id := arp_standard.profile.request_id;
4183: l_last_updated_by := arp_standard.profile.last_update_login ;
4184: l_created_by := arp_standard.profile.user_id ;
4185: l_last_update_login := arp_standard.profile.last_update_login ;
4186: l_program_application_id := arp_standard.application_id ;
4187: l_program_id := arp_standard.profile.program_id;
4188: l_paying_customer_id := p_paying_customer_id;
4189:
4190: IF l_paying_customer_id is null and p_cash_receipt_id is not null THEN
4183: l_last_updated_by := arp_standard.profile.last_update_login ;
4184: l_created_by := arp_standard.profile.user_id ;
4185: l_last_update_login := arp_standard.profile.last_update_login ;
4186: l_program_application_id := arp_standard.application_id ;
4187: l_program_id := arp_standard.profile.program_id;
4188: l_paying_customer_id := p_paying_customer_id;
4189:
4190: IF l_paying_customer_id is null and p_cash_receipt_id is not null THEN
4191:
4197: END IF;
4198:
4199: IF PG_DEBUG in ('Y','C') THEN
4200:
4201: arp_standard.debug( 'value of l_request_id ' || l_request_id );
4202: arp_standard.debug( 'value of l_last_updated_by ' || l_last_updated_by );
4203: arp_standard.debug( 'value of l_created_by ' || l_created_by );
4204: arp_standard.debug( 'value of l_last_update_login ' || l_last_update_login );
4205: arp_standard.debug( 'value of l_program_application_id '|| to_char(l_program_application_id) );
4198:
4199: IF PG_DEBUG in ('Y','C') THEN
4200:
4201: arp_standard.debug( 'value of l_request_id ' || l_request_id );
4202: arp_standard.debug( 'value of l_last_updated_by ' || l_last_updated_by );
4203: arp_standard.debug( 'value of l_created_by ' || l_created_by );
4204: arp_standard.debug( 'value of l_last_update_login ' || l_last_update_login );
4205: arp_standard.debug( 'value of l_program_application_id '|| to_char(l_program_application_id) );
4206: arp_standard.debug( 'value of l_program_id ' || to_char(l_program_id) );
4199: IF PG_DEBUG in ('Y','C') THEN
4200:
4201: arp_standard.debug( 'value of l_request_id ' || l_request_id );
4202: arp_standard.debug( 'value of l_last_updated_by ' || l_last_updated_by );
4203: arp_standard.debug( 'value of l_created_by ' || l_created_by );
4204: arp_standard.debug( 'value of l_last_update_login ' || l_last_update_login );
4205: arp_standard.debug( 'value of l_program_application_id '|| to_char(l_program_application_id) );
4206: arp_standard.debug( 'value of l_program_id ' || to_char(l_program_id) );
4207:
4200:
4201: arp_standard.debug( 'value of l_request_id ' || l_request_id );
4202: arp_standard.debug( 'value of l_last_updated_by ' || l_last_updated_by );
4203: arp_standard.debug( 'value of l_created_by ' || l_created_by );
4204: arp_standard.debug( 'value of l_last_update_login ' || l_last_update_login );
4205: arp_standard.debug( 'value of l_program_application_id '|| to_char(l_program_application_id) );
4206: arp_standard.debug( 'value of l_program_id ' || to_char(l_program_id) );
4207:
4208: END IF;
4201: arp_standard.debug( 'value of l_request_id ' || l_request_id );
4202: arp_standard.debug( 'value of l_last_updated_by ' || l_last_updated_by );
4203: arp_standard.debug( 'value of l_created_by ' || l_created_by );
4204: arp_standard.debug( 'value of l_last_update_login ' || l_last_update_login );
4205: arp_standard.debug( 'value of l_program_application_id '|| to_char(l_program_application_id) );
4206: arp_standard.debug( 'value of l_program_id ' || to_char(l_program_id) );
4207:
4208: END IF;
4209:
4202: arp_standard.debug( 'value of l_last_updated_by ' || l_last_updated_by );
4203: arp_standard.debug( 'value of l_created_by ' || l_created_by );
4204: arp_standard.debug( 'value of l_last_update_login ' || l_last_update_login );
4205: arp_standard.debug( 'value of l_program_application_id '|| to_char(l_program_application_id) );
4206: arp_standard.debug( 'value of l_program_id ' || to_char(l_program_id) );
4207:
4208: END IF;
4209:
4210:
4250: l_program_id,
4251: sysdate FROM DUAL;
4252:
4253: IF PG_DEBUG in ('Y','C') THEN
4254: arp_standard.debug ( 'the rows in exceptions = ' || SQL%ROWCOUNT );
4255: END IF;
4256:
4257: EXCEPTION
4258: WHEN OTHERS THEN
4257: EXCEPTION
4258: WHEN OTHERS THEN
4259:
4260: IF PG_DEBUG in ('Y','C') THEN
4261: arp_standard.debug ( 'ERROR IN INSERT_AUTOREC_EXCEPTIONS' );
4262: END IF;
4263:
4264:
4265: END insert_exceptions;
4296: l_org_id NUMBER;
4297:
4298: BEGIN
4299: IF PG_DEBUG in ('Y', 'C') THEN
4300: arp_standard.debug('Submitting the report..');
4301: END IF;
4302:
4303:
4304: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
4332: argument6=>'P_REQUEST_ID_MAIN=' || p_request_id
4333: ) ;
4334:
4335: IF PG_DEBUG in ('Y', 'C') THEN
4336: arp_standard.debug('Request Id :' || l_reqid);
4337: END IF;
4338:
4339:
4340: arp_standard.debug (' COMMITING WORK ');
4336: arp_standard.debug('Request Id :' || l_reqid);
4337: END IF;
4338:
4339:
4340: arp_standard.debug (' COMMITING WORK ');
4341: commit; -- This is there to commit the conc request.
4342:
4343: EXCEPTION
4344: WHEN OTHERS THEN
4342:
4343: EXCEPTION
4344: WHEN OTHERS THEN
4345: IF PG_DEBUG in ('Y', 'C') THEN
4346: arp_standard.debug('Submitting the report.iN ERROR.');
4347: END IF;
4348:
4349: END SUBMIT_REPORT;
4350:
4362: IF PG_DEBUG in ('Y', 'C') THEN
4363: fnd_file.put_line(FND_FILE.LOG,'control_check()+');
4364: END IF;
4365:
4366: l_request_id := arp_standard.profile.request_id;
4367: l_last_updated_by := arp_standard.profile.last_update_login ;
4368: l_created_by := arp_standard.profile.user_id ;
4369: l_last_update_login := arp_standard.profile.last_update_login ;
4370: l_program_application_id := arp_standard.application_id ;
4363: fnd_file.put_line(FND_FILE.LOG,'control_check()+');
4364: END IF;
4365:
4366: l_request_id := arp_standard.profile.request_id;
4367: l_last_updated_by := arp_standard.profile.last_update_login ;
4368: l_created_by := arp_standard.profile.user_id ;
4369: l_last_update_login := arp_standard.profile.last_update_login ;
4370: l_program_application_id := arp_standard.application_id ;
4371: l_program_id := arp_standard.profile.program_id;
4364: END IF;
4365:
4366: l_request_id := arp_standard.profile.request_id;
4367: l_last_updated_by := arp_standard.profile.last_update_login ;
4368: l_created_by := arp_standard.profile.user_id ;
4369: l_last_update_login := arp_standard.profile.last_update_login ;
4370: l_program_application_id := arp_standard.application_id ;
4371: l_program_id := arp_standard.profile.program_id;
4372:
4365:
4366: l_request_id := arp_standard.profile.request_id;
4367: l_last_updated_by := arp_standard.profile.last_update_login ;
4368: l_created_by := arp_standard.profile.user_id ;
4369: l_last_update_login := arp_standard.profile.last_update_login ;
4370: l_program_application_id := arp_standard.application_id ;
4371: l_program_id := arp_standard.profile.program_id;
4372:
4373: fnd_file.put_line(FND_FILE.LOG,'Detect receipts with Auth failure');
4366: l_request_id := arp_standard.profile.request_id;
4367: l_last_updated_by := arp_standard.profile.last_update_login ;
4368: l_created_by := arp_standard.profile.user_id ;
4369: l_last_update_login := arp_standard.profile.last_update_login ;
4370: l_program_application_id := arp_standard.application_id ;
4371: l_program_id := arp_standard.profile.program_id;
4372:
4373: fnd_file.put_line(FND_FILE.LOG,'Detect receipts with Auth failure');
4374:
4367: l_last_updated_by := arp_standard.profile.last_update_login ;
4368: l_created_by := arp_standard.profile.user_id ;
4369: l_last_update_login := arp_standard.profile.last_update_login ;
4370: l_program_application_id := arp_standard.application_id ;
4371: l_program_id := arp_standard.profile.program_id;
4372:
4373: fnd_file.put_line(FND_FILE.LOG,'Detect receipts with Auth failure');
4374:
4375: UPDATE /*+ index(ct ra_customer_trx_u1) */ ra_customer_trx_all ct
4474: l_request_id ar_cash_receipts.request_id%TYPE;
4475:
4476: BEGIN
4477: IF PG_DEBUG in ('Y', 'C') THEN
4478: arp_standard.debug('inside rec reset.');
4479: END IF;
4480:
4481:
4482: l_request_id := arp_standard.profile.request_id;
4478: arp_standard.debug('inside rec reset.');
4479: END IF;
4480:
4481:
4482: l_request_id := arp_standard.profile.request_id;
4483:
4484: IF p_pay_process_fail = 'Y' THEN
4485:
4486: /* Note here - the apply process was succesful but auth failed so here we have to unapply the
4567:
4568: BEGIN
4569:
4570: IF PG_DEBUG in ('Y', 'C') THEN
4571: arp_standard.debug('l_called_from'|| l_called_from);
4572: arp_util.debug('Calling UNAPP ()+');
4573: END IF;
4574:
4575:
4619:
4620: ul_count := nvl(ul_count,0) +1 ;
4621: ul_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
4622:
4623: arp_standard.debug ( 'the number is ' || ul_count );
4624: arp_standard.debug ( 'the message data is ' || ul_msg_data );
4625:
4626: ELSE
4627:
4620: ul_count := nvl(ul_count,0) +1 ;
4621: ul_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
4622:
4623: arp_standard.debug ( 'the number is ' || ul_count );
4624: arp_standard.debug ( 'the message data is ' || ul_msg_data );
4625:
4626: ELSE
4627:
4628: EXIT;
4650:
4651:
4652: /* end unapply */
4653:
4654: arp_standard.debug('delete the bad receipts');
4655:
4656: /* Start of delete XLA events code. Doing this is bulk */
4657: Begin
4658: IF PG_DEBUG in ('Y','C') THEN
4655:
4656: /* Start of delete XLA events code. Doing this is bulk */
4657: Begin
4658: IF PG_DEBUG in ('Y','C') THEN
4659: arp_standard.debug ( 'Start calling xla delete_bulk_events');
4660: arp_standard.debug ( 'Inserting into xla_events_int_gt...');
4661: END IF;
4662:
4663: INSERT INTO xla_events_int_gt
4656: /* Start of delete XLA events code. Doing this is bulk */
4657: Begin
4658: IF PG_DEBUG in ('Y','C') THEN
4659: arp_standard.debug ( 'Start calling xla delete_bulk_events');
4660: arp_standard.debug ( 'Inserting into xla_events_int_gt...');
4661: END IF;
4662:
4663: INSERT INTO xla_events_int_gt
4664: (event_id
4717: and xte.entity_code = 'RECEIPTS'
4718: and xe.application_id = 222
4719: and xe.event_number > 0
4720: and xe.entity_id = xte.entity_id
4721: and xte.ledger_id = ARP_STANDARD.sysparm.set_of_books_id
4722: and NVL(xte.source_id_int_1, -99) IN
4723: (select distinct cash_receipt_id
4724: from ar_autorec_exceptions
4725: where request_id = l_request_id));
4724: from ar_autorec_exceptions
4725: where request_id = l_request_id));
4726:
4727: IF PG_DEBUG in ('Y','C') THEN
4728: arp_standard.debug ( 'rows inserted into xla gt table = '|| sql%rowcount);
4729: arp_standard.debug ( 'Calling xla_events_pub_pkg.delete_bulk_events()');
4730: END IF;
4731:
4732: xla_events_pub_pkg.delete_bulk_events(222);
4725: where request_id = l_request_id));
4726:
4727: IF PG_DEBUG in ('Y','C') THEN
4728: arp_standard.debug ( 'rows inserted into xla gt table = '|| sql%rowcount);
4729: arp_standard.debug ( 'Calling xla_events_pub_pkg.delete_bulk_events()');
4730: END IF;
4731:
4732: xla_events_pub_pkg.delete_bulk_events(222);
4733:
4731:
4732: xla_events_pub_pkg.delete_bulk_events(222);
4733:
4734: IF PG_DEBUG in ('Y','C') THEN
4735: arp_standard.debug ( 'End calling xla delete_bulk_events');
4736: END IF;
4737:
4738: EXCEPTION
4739: WHEN OTHERS THEN
4737:
4738: EXCEPTION
4739: WHEN OTHERS THEN
4740: IF PG_DEBUG in ('Y', 'C') THEN
4741: arp_standard.debug('Error in call to xla_events_pub_pkg.delete_bulk_events ' || sqlerrm);
4742: END IF;
4743: END;
4744: /* End of delete XLA events code */
4745:
4756: and trx.cc_error_flag = 'Y'
4757: and trx.request_id = l_request_id);
4758:
4759: IF PG_DEBUG in ('Y','C') THEN
4760: arp_standard.debug ( ' rows updated PS = ' || SQL%ROWCOUNT );
4761: END IF;
4762:
4763: delete from ar_payment_schedules
4764: where cash_receipt_id in (select distinct cash_receipt_id
4765: from ar_autorec_exceptions
4766: where request_id = l_request_id);
4767:
4768: IF PG_DEBUG in ('Y','C') THEN
4769: arp_standard.debug ( ' rows DELETED PS = ' || SQL%ROWCOUNT );
4770: END IF;
4771:
4772: delete from ar_distributions
4773: where source_table = 'CRH'
4777: from ar_autorec_exceptions
4778: where request_id = l_request_id));
4779:
4780: IF PG_DEBUG in ('Y','C') THEN
4781: arp_standard.debug ( ' rows DELETED AR_DIST = ' || SQL%ROWCOUNT );
4782: END IF;
4783:
4784: delete from ar_distributions
4785: where source_table = 'RA'
4789: from ar_autorec_exceptions
4790: where request_id = l_request_id));
4791:
4792: IF PG_DEBUG in ('Y','C') THEN
4793: arp_standard.debug ( ' rows DELETED AR_DIST2 = ' || SQL%ROWCOUNT );
4794: END IF;
4795:
4796: delete from ar_receivable_applications
4797: where cash_receipt_id in ( select distinct cash_receipt_id
4798: from ar_autorec_exceptions
4799: where request_id = l_request_id);
4800:
4801: IF PG_DEBUG in ('Y','C') THEN
4802: arp_standard.debug ( ' rows DELETED REC_APPS = ' || SQL%ROWCOUNT );
4803: END IF;
4804: delete from ar_cash_receipt_history
4805: where cash_receipt_id in ( select distinct cash_receipt_id
4806: from ar_autorec_exceptions
4806: from ar_autorec_exceptions
4807: where request_id = l_request_id);
4808:
4809: IF PG_DEBUG in ('Y','C') THEN
4810: arp_standard.debug ( ' rows DELETED CRH = ' || SQL%ROWCOUNT );
4811: END IF;
4812:
4813: delete from ar_cash_receipts
4814: where cash_receipt_id in ( select distinct cash_receipt_id
4815: from ar_autorec_exceptions
4816: where request_id = l_request_id);
4817:
4818: IF PG_DEBUG in ('Y','C') THEN
4819: arp_standard.debug ( ' rows DELETED CR = ' || SQL%ROWCOUNT );
4820: END IF;
4821:
4822:
4823: END IF;
4827:
4828: EXCEPTION
4829: WHEN OTHERS THEN
4830: IF PG_DEBUG in ('Y', 'C') THEN
4831: arp_standard.debug('rec_reset .iN ERROR.');
4832: END IF;
4833:
4834: END rec_reset;
4835: