eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROCESS_BOE dependencies on ARP_STANDARD

Line 127: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'arp_process_boe.add_or_rm_remit_rec_to_batch()+');

123: --
124: --
125: BEGIN
126: IF PG_DEBUG in ('Y', 'C') THEN
127: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'arp_process_boe.add_or_rm_remit_rec_to_batch()+');
128: END IF;
129: --
130: IF PG_DEBUG in ('Y', 'C') THEN
131: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'cr_id = '||to_char( p_cr_id ) );

Line 131: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'cr_id = '||to_char( p_cr_id ) );

127: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'arp_process_boe.add_or_rm_remit_rec_to_batch()+');
128: END IF;
129: --
130: IF PG_DEBUG in ('Y', 'C') THEN
131: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'cr_id = '||to_char( p_cr_id ) );
132: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'ps_id = '||to_char( p_ps_id ) );
133: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'crh_id = '||to_char( p_crh_id ) );
134: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'selected_remittance_batch_id = '||
135: to_char( p_selected_remittance_batch_id ) );

Line 132: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'ps_id = '||to_char( p_ps_id ) );

128: END IF;
129: --
130: IF PG_DEBUG in ('Y', 'C') THEN
131: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'cr_id = '||to_char( p_cr_id ) );
132: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'ps_id = '||to_char( p_ps_id ) );
133: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'crh_id = '||to_char( p_crh_id ) );
134: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'selected_remittance_batch_id = '||
135: to_char( p_selected_remittance_batch_id ) );
136: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'remit_bank_acct_use_id = '||

Line 133: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'crh_id = '||to_char( p_crh_id ) );

129: --
130: IF PG_DEBUG in ('Y', 'C') THEN
131: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'cr_id = '||to_char( p_cr_id ) );
132: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'ps_id = '||to_char( p_ps_id ) );
133: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'crh_id = '||to_char( p_crh_id ) );
134: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'selected_remittance_batch_id = '||
135: to_char( p_selected_remittance_batch_id ) );
136: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'remit_bank_acct_use_id = '||
137: to_char( p_remittance_bank_account_id ) );

Line 134: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'selected_remittance_batch_id = '||

130: IF PG_DEBUG in ('Y', 'C') THEN
131: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'cr_id = '||to_char( p_cr_id ) );
132: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'ps_id = '||to_char( p_ps_id ) );
133: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'crh_id = '||to_char( p_crh_id ) );
134: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'selected_remittance_batch_id = '||
135: to_char( p_selected_remittance_batch_id ) );
136: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'remit_bank_acct_use_id = '||
137: to_char( p_remittance_bank_account_id ) );
138: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'override_remit_account_flag = '||

Line 136: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'remit_bank_acct_use_id = '||

132: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'ps_id = '||to_char( p_ps_id ) );
133: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'crh_id = '||to_char( p_crh_id ) );
134: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'selected_remittance_batch_id = '||
135: to_char( p_selected_remittance_batch_id ) );
136: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'remit_bank_acct_use_id = '||
137: to_char( p_remittance_bank_account_id ) );
138: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'override_remit_account_flag = '||
139: p_override_remit_account_flag );
140: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'customer_bank_account_id = '||

Line 138: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'override_remit_account_flag = '||

134: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'selected_remittance_batch_id = '||
135: to_char( p_selected_remittance_batch_id ) );
136: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'remit_bank_acct_use_id = '||
137: to_char( p_remittance_bank_account_id ) );
138: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'override_remit_account_flag = '||
139: p_override_remit_account_flag );
140: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'customer_bank_account_id = '||
141: to_char( p_customer_bank_account_id ) );
142: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'bank_charges = '||

Line 140: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'customer_bank_account_id = '||

136: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'remit_bank_acct_use_id = '||
137: to_char( p_remittance_bank_account_id ) );
138: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'override_remit_account_flag = '||
139: p_override_remit_account_flag );
140: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'customer_bank_account_id = '||
141: to_char( p_customer_bank_account_id ) );
142: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'bank_charges = '||
143: to_char( p_bank_charges ) );
144: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'maturity_date = '||

Line 142: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'bank_charges = '||

138: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'override_remit_account_flag = '||
139: p_override_remit_account_flag );
140: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'customer_bank_account_id = '||
141: to_char( p_customer_bank_account_id ) );
142: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'bank_charges = '||
143: to_char( p_bank_charges ) );
144: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'maturity_date = '||
145: to_char( p_maturity_date ) );
146: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'batch_id = '||

Line 144: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'maturity_date = '||

140: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'customer_bank_account_id = '||
141: to_char( p_customer_bank_account_id ) );
142: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'bank_charges = '||
143: to_char( p_bank_charges ) );
144: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'maturity_date = '||
145: to_char( p_maturity_date ) );
146: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'batch_id = '||
147: to_char( p_batch_id ) );
148: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'control_count = '||

Line 146: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'batch_id = '||

142: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'bank_charges = '||
143: to_char( p_bank_charges ) );
144: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'maturity_date = '||
145: to_char( p_maturity_date ) );
146: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'batch_id = '||
147: to_char( p_batch_id ) );
148: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'control_count = '||
149: to_char( p_control_count ) );
150: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'control_amount = '||

Line 148: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'control_count = '||

144: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'maturity_date = '||
145: to_char( p_maturity_date ) );
146: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'batch_id = '||
147: to_char( p_batch_id ) );
148: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'control_count = '||
149: to_char( p_control_count ) );
150: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'control_amount = '||
151: to_char( p_control_amount ) );
152: END IF;

Line 150: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'control_amount = '||

146: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'batch_id = '||
147: to_char( p_batch_id ) );
148: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'control_count = '||
149: to_char( p_control_count ) );
150: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'control_amount = '||
151: to_char( p_control_amount ) );
152: END IF;
153: --
154: -- Validate input arguments

Line 231: arp_standard.debug('l_actual_count_total = '||to_char(l_actual_count_total));

227: l_actual_count_total := l_actual_count_total + p_control_count;
228: l_actual_amount_total := l_actual_amount_total + p_control_amount;
229:
230: IF PG_DEBUG in ('Y', 'C') THEN
231: arp_standard.debug('l_actual_count_total = '||to_char(l_actual_count_total));
232: arp_standard.debug('l_actual_amount_total = '||to_char(l_actual_amount_total));
233: END IF;
234: /* End Bug fix 3927024 */
235:

Line 232: arp_standard.debug('l_actual_amount_total = '||to_char(l_actual_amount_total));

228: l_actual_amount_total := l_actual_amount_total + p_control_amount;
229:
230: IF PG_DEBUG in ('Y', 'C') THEN
231: arp_standard.debug('l_actual_count_total = '||to_char(l_actual_count_total));
232: arp_standard.debug('l_actual_amount_total = '||to_char(l_actual_amount_total));
233: END IF;
234: /* End Bug fix 3927024 */
235:
236: arp_cr_batches_pkg.set_to_dummy( l_batch_rec );

Line 243: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'arp_process_boe.add_or_rm_remit_rec_to_batch()-');

239: l_batch_rec.control_amount := l_actual_amount_total; /* bug 3927024 */
240: arp_cr_batches_pkg.update_p( l_batch_rec, l_batch_rec.batch_id );
241: --
242: IF PG_DEBUG in ('Y', 'C') THEN
243: arp_standard.debug('val_args_add_or_rm_remit_rec: ' || 'arp_process_boe.add_or_rm_remit_rec_to_batch()-');
244: END IF;
245: --
246: EXCEPTION
247: WHEN OTHERS THEN

Line 249: arp_standard.debug('val_args_add_or_rm_remit_rec: ' ||

245: --
246: EXCEPTION
247: WHEN OTHERS THEN
248: IF PG_DEBUG in ('Y', 'C') THEN
249: arp_standard.debug('val_args_add_or_rm_remit_rec: ' ||
250: 'EXCEPTION: arp_process_boe.add_or_rm_remit_rec_to_batch' );
251: END IF;
252: RAISE;
253: --

Line 293: arp_standard.debug( 'arp_process_boe.val_args_add_or_rm_remit_rec() +');

289: cr_type ar_cash_receipts.type%TYPE;
290:
291: BEGIN
292: IF PG_DEBUG in ('Y', 'C') THEN
293: arp_standard.debug( 'arp_process_boe.val_args_add_or_rm_remit_rec() +');
294: END IF;
295: --
296: /*---------------------------------------------------------------------
297: Modified by Nilesh for MISC receipt remittance 377583

Line 318: arp_standard.debug( 'arp_process_boe.val_args_add_or_rm_remit_rec() -');

314: END IF;
315:
316: --
317: IF PG_DEBUG in ('Y', 'C') THEN
318: arp_standard.debug( 'arp_process_boe.val_args_add_or_rm_remit_rec() -');
319: END IF;
320: EXCEPTION
321: WHEN OTHERS THEN
322: IF PG_DEBUG in ('Y', 'C') THEN

Line 323: arp_standard.debug('val_args_add_or_rm_remit_rec: ' ||

319: END IF;
320: EXCEPTION
321: WHEN OTHERS THEN
322: IF PG_DEBUG in ('Y', 'C') THEN
323: arp_standard.debug('val_args_add_or_rm_remit_rec: ' ||
324: 'EXCEPTION: arp_process_boe.val_args_add_or_rm_remit_rec' );
325: END IF;
326: RAISE;
327: END val_args_add_or_rm_remit_rec;

Line 361: arp_standard.debug( 'arp_process_boe.create_remit_batch_conc_req()+');

357: l_org_id NUMBER;
358: BEGIN
359: --
360: IF PG_DEBUG in ('Y', 'C') THEN
361: arp_standard.debug( 'arp_process_boe.create_remit_batch_conc_req()+');
362: END IF;
363: --
364: IF PG_DEBUG in ('Y', 'C') THEN
365: arp_standard.debug('create_remit_batch_conc_req: ' || 'Batch Id '||p_batch_id );

Line 365: arp_standard.debug('create_remit_batch_conc_req: ' || 'Batch Id '||p_batch_id );

361: arp_standard.debug( 'arp_process_boe.create_remit_batch_conc_req()+');
362: END IF;
363: --
364: IF PG_DEBUG in ('Y', 'C') THEN
365: arp_standard.debug('create_remit_batch_conc_req: ' || 'Batch Id '||p_batch_id );
366: arp_standard.debug('create_remit_batch_conc_req: ' || 'create_flag = '||p_create_flag );
367: arp_standard.debug('create_remit_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
368: arp_standard.debug('create_remit_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
369: arp_standard.debug('create_remit_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );

Line 366: arp_standard.debug('create_remit_batch_conc_req: ' || 'create_flag = '||p_create_flag );

362: END IF;
363: --
364: IF PG_DEBUG in ('Y', 'C') THEN
365: arp_standard.debug('create_remit_batch_conc_req: ' || 'Batch Id '||p_batch_id );
366: arp_standard.debug('create_remit_batch_conc_req: ' || 'create_flag = '||p_create_flag );
367: arp_standard.debug('create_remit_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
368: arp_standard.debug('create_remit_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
369: arp_standard.debug('create_remit_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
370: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_num_low = '||p_receipt_number_low );

Line 367: arp_standard.debug('create_remit_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );

363: --
364: IF PG_DEBUG in ('Y', 'C') THEN
365: arp_standard.debug('create_remit_batch_conc_req: ' || 'Batch Id '||p_batch_id );
366: arp_standard.debug('create_remit_batch_conc_req: ' || 'create_flag = '||p_create_flag );
367: arp_standard.debug('create_remit_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
368: arp_standard.debug('create_remit_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
369: arp_standard.debug('create_remit_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
370: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_num_low = '||p_receipt_number_low );
371: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_nue_hi = '||p_receipt_number_high );

Line 368: arp_standard.debug('create_remit_batch_conc_req: ' || 'Format_flag = '||p_format_flag );

364: IF PG_DEBUG in ('Y', 'C') THEN
365: arp_standard.debug('create_remit_batch_conc_req: ' || 'Batch Id '||p_batch_id );
366: arp_standard.debug('create_remit_batch_conc_req: ' || 'create_flag = '||p_create_flag );
367: arp_standard.debug('create_remit_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
368: arp_standard.debug('create_remit_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
369: arp_standard.debug('create_remit_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
370: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_num_low = '||p_receipt_number_low );
371: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_nue_hi = '||p_receipt_number_high );
372: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_low = '||to_char( p_receipt_date_low ));

Line 369: arp_standard.debug('create_remit_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );

365: arp_standard.debug('create_remit_batch_conc_req: ' || 'Batch Id '||p_batch_id );
366: arp_standard.debug('create_remit_batch_conc_req: ' || 'create_flag = '||p_create_flag );
367: arp_standard.debug('create_remit_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
368: arp_standard.debug('create_remit_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
369: arp_standard.debug('create_remit_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
370: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_num_low = '||p_receipt_number_low );
371: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_nue_hi = '||p_receipt_number_high );
372: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_low = '||to_char( p_receipt_date_low ));
373: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_hi = '||to_char( p_receipt_date_high));

Line 370: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_num_low = '||p_receipt_number_low );

366: arp_standard.debug('create_remit_batch_conc_req: ' || 'create_flag = '||p_create_flag );
367: arp_standard.debug('create_remit_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
368: arp_standard.debug('create_remit_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
369: arp_standard.debug('create_remit_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
370: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_num_low = '||p_receipt_number_low );
371: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_nue_hi = '||p_receipt_number_high );
372: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_low = '||to_char( p_receipt_date_low ));
373: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_hi = '||to_char( p_receipt_date_high));
374: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));

Line 371: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_nue_hi = '||p_receipt_number_high );

367: arp_standard.debug('create_remit_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
368: arp_standard.debug('create_remit_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
369: arp_standard.debug('create_remit_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
370: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_num_low = '||p_receipt_number_low );
371: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_nue_hi = '||p_receipt_number_high );
372: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_low = '||to_char( p_receipt_date_low ));
373: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_hi = '||to_char( p_receipt_date_high));
374: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
375: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));

Line 372: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_low = '||to_char( p_receipt_date_low ));

368: arp_standard.debug('create_remit_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
369: arp_standard.debug('create_remit_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
370: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_num_low = '||p_receipt_number_low );
371: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_nue_hi = '||p_receipt_number_high );
372: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_low = '||to_char( p_receipt_date_low ));
373: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_hi = '||to_char( p_receipt_date_high));
374: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
375: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
376: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));

Line 373: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_hi = '||to_char( p_receipt_date_high));

369: arp_standard.debug('create_remit_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
370: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_num_low = '||p_receipt_number_low );
371: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_nue_hi = '||p_receipt_number_high );
372: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_low = '||to_char( p_receipt_date_low ));
373: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_hi = '||to_char( p_receipt_date_high));
374: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
375: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
376: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
377: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));

Line 374: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));

370: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_num_low = '||p_receipt_number_low );
371: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_nue_hi = '||p_receipt_number_high );
372: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_low = '||to_char( p_receipt_date_low ));
373: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_hi = '||to_char( p_receipt_date_high));
374: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
375: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
376: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
377: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
378: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );

Line 375: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));

371: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_nue_hi = '||p_receipt_number_high );
372: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_low = '||to_char( p_receipt_date_low ));
373: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_hi = '||to_char( p_receipt_date_high));
374: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
375: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
376: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
377: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
378: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
379: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );

Line 376: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));

372: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_low = '||to_char( p_receipt_date_low ));
373: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_hi = '||to_char( p_receipt_date_high));
374: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
375: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
376: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
377: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
378: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
379: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
380: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );

Line 377: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));

373: arp_standard.debug('create_remit_batch_conc_req: ' || 'receipt_date_hi = '||to_char( p_receipt_date_high));
374: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
375: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
376: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
377: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
378: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
379: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
380: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
381: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );

Line 378: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );

374: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
375: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
376: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
377: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
378: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
379: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
380: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
381: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
382: arp_standard.debug('create_remit_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );

Line 379: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );

375: arp_standard.debug('create_remit_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
376: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
377: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
378: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
379: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
380: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
381: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
382: arp_standard.debug('create_remit_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );
383: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_low = '||p_location_low );

Line 380: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );

376: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
377: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
378: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
379: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
380: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
381: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
382: arp_standard.debug('create_remit_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );
383: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_low = '||p_location_low );
384: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_high = '||p_location_high );

Line 381: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );

377: arp_standard.debug('create_remit_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
378: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
379: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
380: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
381: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
382: arp_standard.debug('create_remit_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );
383: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_low = '||p_location_low );
384: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_high = '||p_location_high );
385: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );

Line 382: arp_standard.debug('create_remit_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );

378: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
379: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
380: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
381: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
382: arp_standard.debug('create_remit_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );
383: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_low = '||p_location_low );
384: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_high = '||p_location_high );
385: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );
386: END IF;

Line 383: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_low = '||p_location_low );

379: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
380: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
381: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
382: arp_standard.debug('create_remit_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );
383: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_low = '||p_location_low );
384: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_high = '||p_location_high );
385: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );
386: END IF;
387: --

Line 384: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_high = '||p_location_high );

380: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
381: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
382: arp_standard.debug('create_remit_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );
383: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_low = '||p_location_low );
384: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_high = '||p_location_high );
385: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );
386: END IF;
387: --
388: -- Validate input arguments

Line 385: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );

381: arp_standard.debug('create_remit_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
382: arp_standard.debug('create_remit_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );
383: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_low = '||p_location_low );
384: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_high = '||p_location_high );
385: arp_standard.debug('create_remit_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );
386: END IF;
387: --
388: -- Validate input arguments
389: --

Line 406: arp_standard.debug('Selecting org_id from ar_system_parameters and p_batch_id : '||p_batch_id);

402: --
403: /* Bug 5190715 */
404: /* Bug 5699734 - Changed the logic of getting the org_id - Getting from ar_system_parameters is more reliable */
405: IF PG_DEBUG in ('Y', 'C') THEN
406: arp_standard.debug('Selecting org_id from ar_system_parameters and p_batch_id : '||p_batch_id);
407: END IF;
408: -- l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
409: SELECT org_id
410: INTO l_org_id

Line 461: arp_standard.debug('create_remit_batch_conc_req: ' || 'Out Request ID = '||to_char( l_request_id ) );

457: NULL
458: );
459: --
460: IF PG_DEBUG in ('Y', 'C') THEN
461: arp_standard.debug('create_remit_batch_conc_req: ' || 'Out Request ID = '||to_char( l_request_id ) );
462: END IF;
463: p_request_id := l_request_id;
464: --
465: --

Line 483: arp_standard.debug( 'arp_process_boe.create_remit_batch_conc_req()-');

479: arp_cr_batches_pkg.update_p( l_bat_rec, l_bat_rec.batch_id );
480: p_batch_applied_status := l_bat_rec.batch_applied_status;
481: --
482: IF PG_DEBUG in ('Y', 'C') THEN
483: arp_standard.debug( 'arp_process_boe.create_remit_batch_conc_req()-');
484: END IF;
485: --
486: EXCEPTION
487: WHEN OTHERS THEN

Line 489: arp_standard.debug('create_remit_batch_conc_req: ' ||

485: --
486: EXCEPTION
487: WHEN OTHERS THEN
488: IF PG_DEBUG in ('Y', 'C') THEN
489: arp_standard.debug('create_remit_batch_conc_req: ' ||
490: 'EXCEPTION: arp_process_boe.create_remit_batch_conc_req' );
491: END IF;
492: RAISE;
493: --

Line 511: arp_standard.debug( 'arp_process_boe.app_fmt_remit_batch_conc_req()+');

507: l_org_id NUMBER;
508: BEGIN
509: --
510: IF PG_DEBUG in ('Y', 'C') THEN
511: arp_standard.debug( 'arp_process_boe.app_fmt_remit_batch_conc_req()+');
512: END IF;
513: --
514: IF PG_DEBUG in ('Y', 'C') THEN
515: arp_standard.debug('app_fmt_remit_batch_conc_req: ' || 'Batch Id '||p_batch_id );

Line 515: arp_standard.debug('app_fmt_remit_batch_conc_req: ' || 'Batch Id '||p_batch_id );

511: arp_standard.debug( 'arp_process_boe.app_fmt_remit_batch_conc_req()+');
512: END IF;
513: --
514: IF PG_DEBUG in ('Y', 'C') THEN
515: arp_standard.debug('app_fmt_remit_batch_conc_req: ' || 'Batch Id '||p_batch_id );
516: arp_standard.debug('app_fmt_remit_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
517: arp_standard.debug('app_fmt_remit_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
518: END IF;
519: --

Line 516: arp_standard.debug('app_fmt_remit_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );

512: END IF;
513: --
514: IF PG_DEBUG in ('Y', 'C') THEN
515: arp_standard.debug('app_fmt_remit_batch_conc_req: ' || 'Batch Id '||p_batch_id );
516: arp_standard.debug('app_fmt_remit_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
517: arp_standard.debug('app_fmt_remit_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
518: END IF;
519: --
520: IF ( p_module_name IS NOT NULL and p_module_version IS NOT NULL ) THEN

Line 517: arp_standard.debug('app_fmt_remit_batch_conc_req: ' || 'Format_flag = '||p_format_flag );

513: --
514: IF PG_DEBUG in ('Y', 'C') THEN
515: arp_standard.debug('app_fmt_remit_batch_conc_req: ' || 'Batch Id '||p_batch_id );
516: arp_standard.debug('app_fmt_remit_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
517: arp_standard.debug('app_fmt_remit_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
518: END IF;
519: --
520: IF ( p_module_name IS NOT NULL and p_module_version IS NOT NULL ) THEN
521: IF ( p_batch_id IS NULL ) THEN

Line 533: arp_standard.debug('Selecting org_id from ar_system_parameters and p_batch_id : '||p_batch_id);

529: /* Additional Fix identified as a part of Bug 5699734 */
530: /* Bug 5699734 - Changed logic to get org_id - Getting from ar_system_parameters would be more reliable */
531: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
532: IF PG_DEBUG in ('Y', 'C') THEN
533: arp_standard.debug('Selecting org_id from ar_system_parameters and p_batch_id : '||p_batch_id);
534: END IF;
535: SELECT org_id
536: INTO l_org_id
537: FROM ar_system_parameters;

Line 545: arp_standard.debug('app_fmt_remit_batch_conc_req: Submitting Conc Req for Approve/Format Remittance Receipt Batch with org : ' ||l_org_id);

541: fnd_request.set_org_id(l_org_id);
542:
543: /* Adding additional debug messages - As a part of Bug 5699734 */
544: IF PG_DEBUG in ('Y', 'C') THEN
545: arp_standard.debug('app_fmt_remit_batch_conc_req: Submitting Conc Req for Approve/Format Remittance Receipt Batch with org : ' ||l_org_id);
546: END IF;
547: /* End of additional Debug messages */
548: l_request_id := FND_REQUEST.submit_request( 'AR',
549: 'AUTOREMAPI', --PAYMENT_UPTAKE ARZCAR_REMIT

Line 585: arp_standard.debug('app_fmt_remit_batch_conc_req: ' || 'Out Request ID = '||to_char( l_request_id ) );

581: NULL, NULL
582: );
583: --
584: IF PG_DEBUG in ('Y', 'C') THEN
585: arp_standard.debug('app_fmt_remit_batch_conc_req: ' || 'Out Request ID = '||to_char( l_request_id ) );
586: END IF;
587: p_request_id := l_request_id;
588: --
589: -- Update batch to set batch applied_status

Line 603: arp_standard.debug( 'arp_process_boe.app_fmt_remit_batch_conc_req()-');

599: arp_cr_batches_pkg.update_p( l_bat_rec, l_bat_rec.batch_id );
600: p_batch_applied_status := l_bat_rec.batch_applied_status;
601: --
602: IF PG_DEBUG in ('Y', 'C') THEN
603: arp_standard.debug( 'arp_process_boe.app_fmt_remit_batch_conc_req()-');
604: END IF;
605: --
606: EXCEPTION
607: WHEN OTHERS THEN

Line 609: arp_standard.debug('app_fmt_remit_batch_conc_req: ' ||

605: --
606: EXCEPTION
607: WHEN OTHERS THEN
608: IF PG_DEBUG in ('Y', 'C') THEN
609: arp_standard.debug('app_fmt_remit_batch_conc_req: ' ||
610: 'EXCEPTION: arp_process_boe.app_fmt_remit_batch_conc_req' );
611: END IF;
612: RAISE;
613: --

Line 629: arp_standard.debug( 'arp_process_boe.app_fmt_auto_batch_conc_req()+');

625: l_org_id NUMBER;
626: BEGIN
627: --
628: IF PG_DEBUG in ('Y', 'C') THEN
629: arp_standard.debug( 'arp_process_boe.app_fmt_auto_batch_conc_req()+');
630: END IF;
631: --
632: IF PG_DEBUG in ('Y', 'C') THEN
633: arp_standard.debug('app_fmt_auto_batch_conc_req: ' || 'Batch Id '||p_batch_id );

Line 633: arp_standard.debug('app_fmt_auto_batch_conc_req: ' || 'Batch Id '||p_batch_id );

629: arp_standard.debug( 'arp_process_boe.app_fmt_auto_batch_conc_req()+');
630: END IF;
631: --
632: IF PG_DEBUG in ('Y', 'C') THEN
633: arp_standard.debug('app_fmt_auto_batch_conc_req: ' || 'Batch Id '||p_batch_id );
634: arp_standard.debug('app_fmt_auto_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
635: arp_standard.debug('app_fmt_auto_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
636: END IF;
637: --

Line 634: arp_standard.debug('app_fmt_auto_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );

630: END IF;
631: --
632: IF PG_DEBUG in ('Y', 'C') THEN
633: arp_standard.debug('app_fmt_auto_batch_conc_req: ' || 'Batch Id '||p_batch_id );
634: arp_standard.debug('app_fmt_auto_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
635: arp_standard.debug('app_fmt_auto_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
636: END IF;
637: --
638: IF ( p_module_name IS NOT NULL and p_module_version IS NOT NULL ) THEN

Line 635: arp_standard.debug('app_fmt_auto_batch_conc_req: ' || 'Format_flag = '||p_format_flag );

631: --
632: IF PG_DEBUG in ('Y', 'C') THEN
633: arp_standard.debug('app_fmt_auto_batch_conc_req: ' || 'Batch Id '||p_batch_id );
634: arp_standard.debug('app_fmt_auto_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
635: arp_standard.debug('app_fmt_auto_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
636: END IF;
637: --
638: IF ( p_module_name IS NOT NULL and p_module_version IS NOT NULL ) THEN
639: IF ( p_batch_id IS NULL ) THEN

Line 651: arp_standard.debug('Selecting org_id from ar_system_parameters and p_batch_id : '||p_batch_id);

647: /* Additional Fix identified as a part of Bug 5699734*/
648: /* Bug 5699734 - Changed the logic of getting org_id - Getting from ar_system_parameters would be more reliable */
649: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
650: IF PG_DEBUG in ('Y', 'C') THEN
651: arp_standard.debug('Selecting org_id from ar_system_parameters and p_batch_id : '||p_batch_id);
652: END IF;
653: SELECT org_id
654: INTO l_org_id
655: FROM ar_system_parameters;

Line 663: arp_standard.debug('app_fmt_auto_batch_conc_req: Submitting Conc Req Approve/Format Automatic receipt Batch with org :'||l_org_id);

659: fnd_request.set_org_id(l_org_id);
660:
661: /* Additional Debug Messages as a part of bug 5699734*/
662: IF PG_DEBUG in ('Y', 'C') THEN
663: arp_standard.debug('app_fmt_auto_batch_conc_req: Submitting Conc Req Approve/Format Automatic receipt Batch with org :'||l_org_id);
664: END IF;
665: /* Additional debug messages ends */
666:
667: l_request_id := FND_REQUEST.submit_request( 'AR',

Line 704: arp_standard.debug('app_fmt_auto_batch_conc_req: ' || 'Out Request ID = '||to_char( l_request_id ) );

700: NULL, NULL
701: );
702: --
703: IF PG_DEBUG in ('Y', 'C') THEN
704: arp_standard.debug('app_fmt_auto_batch_conc_req: ' || 'Out Request ID = '||to_char( l_request_id ) );
705: END IF;
706: p_request_id := l_request_id;
707: --
708: --

Line 723: arp_standard.debug( 'arp_process_boe.app_fmt_auto_batch_conc_req()-');

719: arp_cr_batches_pkg.update_p( l_bat_rec, l_bat_rec.batch_id );
720: p_batch_applied_status := l_bat_rec.batch_applied_status;
721: --
722: IF PG_DEBUG in ('Y', 'C') THEN
723: arp_standard.debug( 'arp_process_boe.app_fmt_auto_batch_conc_req()-');
724: END IF;
725: --
726: EXCEPTION
727: WHEN OTHERS THEN

Line 729: arp_standard.debug('app_fmt_auto_batch_conc_req: ' ||

725: --
726: EXCEPTION
727: WHEN OTHERS THEN
728: IF PG_DEBUG in ('Y', 'C') THEN
729: arp_standard.debug('app_fmt_auto_batch_conc_req: ' ||
730: 'EXCEPTION: arp_process_boe.app_fmt_auto_batch_conc_req' );
731: END IF;
732: RAISE;
733: --

Line 773: arp_standard.debug( 'arp_process_boe.create_auto_batch_conc_req()+');

769: l_batch_app_status ar_batches.batch_applied_status%TYPE;
770: BEGIN
771: --
772: IF PG_DEBUG in ('Y', 'C') THEN
773: arp_standard.debug( 'arp_process_boe.create_auto_batch_conc_req()+');
774: END IF;
775: --
776: IF PG_DEBUG in ('Y', 'C') THEN
777: arp_standard.debug('create_auto_batch_conc_req: ' || 'create_flag = '||p_create_flag );

Line 777: arp_standard.debug('create_auto_batch_conc_req: ' || 'create_flag = '||p_create_flag );

773: arp_standard.debug( 'arp_process_boe.create_auto_batch_conc_req()+');
774: END IF;
775: --
776: IF PG_DEBUG in ('Y', 'C') THEN
777: arp_standard.debug('create_auto_batch_conc_req: ' || 'create_flag = '||p_create_flag );
778: arp_standard.debug('create_auto_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
779: arp_standard.debug('create_auto_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
780: arp_standard.debug('create_auto_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
781: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_low = '||p_trx_number_low );

Line 778: arp_standard.debug('create_auto_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );

774: END IF;
775: --
776: IF PG_DEBUG in ('Y', 'C') THEN
777: arp_standard.debug('create_auto_batch_conc_req: ' || 'create_flag = '||p_create_flag );
778: arp_standard.debug('create_auto_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
779: arp_standard.debug('create_auto_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
780: arp_standard.debug('create_auto_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
781: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_low = '||p_trx_number_low );
782: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_hi = '||p_trx_number_high );

Line 779: arp_standard.debug('create_auto_batch_conc_req: ' || 'Format_flag = '||p_format_flag );

775: --
776: IF PG_DEBUG in ('Y', 'C') THEN
777: arp_standard.debug('create_auto_batch_conc_req: ' || 'create_flag = '||p_create_flag );
778: arp_standard.debug('create_auto_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
779: arp_standard.debug('create_auto_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
780: arp_standard.debug('create_auto_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
781: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_low = '||p_trx_number_low );
782: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_hi = '||p_trx_number_high );
783: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_low = '||to_char( p_trx_date_low ));

Line 780: arp_standard.debug('create_auto_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );

776: IF PG_DEBUG in ('Y', 'C') THEN
777: arp_standard.debug('create_auto_batch_conc_req: ' || 'create_flag = '||p_create_flag );
778: arp_standard.debug('create_auto_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
779: arp_standard.debug('create_auto_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
780: arp_standard.debug('create_auto_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
781: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_low = '||p_trx_number_low );
782: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_hi = '||p_trx_number_high );
783: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_low = '||to_char( p_trx_date_low ));
784: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_hi = '||to_char( p_trx_date_high));

Line 781: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_low = '||p_trx_number_low );

777: arp_standard.debug('create_auto_batch_conc_req: ' || 'create_flag = '||p_create_flag );
778: arp_standard.debug('create_auto_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
779: arp_standard.debug('create_auto_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
780: arp_standard.debug('create_auto_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
781: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_low = '||p_trx_number_low );
782: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_hi = '||p_trx_number_high );
783: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_low = '||to_char( p_trx_date_low ));
784: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_hi = '||to_char( p_trx_date_high));
785: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));

Line 782: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_hi = '||p_trx_number_high );

778: arp_standard.debug('create_auto_batch_conc_req: ' || 'Approve_flag = '||p_approve_flag );
779: arp_standard.debug('create_auto_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
780: arp_standard.debug('create_auto_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
781: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_low = '||p_trx_number_low );
782: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_hi = '||p_trx_number_high );
783: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_low = '||to_char( p_trx_date_low ));
784: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_hi = '||to_char( p_trx_date_high));
785: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
786: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));

Line 783: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_low = '||to_char( p_trx_date_low ));

779: arp_standard.debug('create_auto_batch_conc_req: ' || 'Format_flag = '||p_format_flag );
780: arp_standard.debug('create_auto_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
781: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_low = '||p_trx_number_low );
782: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_hi = '||p_trx_number_high );
783: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_low = '||to_char( p_trx_date_low ));
784: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_hi = '||to_char( p_trx_date_high));
785: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
786: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
787: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));

Line 784: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_hi = '||to_char( p_trx_date_high));

780: arp_standard.debug('create_auto_batch_conc_req: ' || 'batch Id = '||to_char( p_batch_id ) );
781: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_low = '||p_trx_number_low );
782: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_hi = '||p_trx_number_high );
783: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_low = '||to_char( p_trx_date_low ));
784: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_hi = '||to_char( p_trx_date_high));
785: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
786: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
787: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
788: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));

Line 785: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));

781: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_low = '||p_trx_number_low );
782: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_hi = '||p_trx_number_high );
783: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_low = '||to_char( p_trx_date_low ));
784: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_hi = '||to_char( p_trx_date_high));
785: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
786: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
787: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
788: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
789: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );

Line 786: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));

782: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_num_hi = '||p_trx_number_high );
783: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_low = '||to_char( p_trx_date_low ));
784: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_hi = '||to_char( p_trx_date_high));
785: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
786: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
787: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
788: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
789: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
790: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );

Line 787: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));

783: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_low = '||to_char( p_trx_date_low ));
784: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_hi = '||to_char( p_trx_date_high));
785: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
786: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
787: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
788: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
789: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
790: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
791: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );

Line 788: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));

784: arp_standard.debug('create_auto_batch_conc_req: ' || 'trx_date_hi = '||to_char( p_trx_date_high));
785: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
786: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
787: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
788: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
789: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
790: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
791: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
792: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );

Line 789: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );

785: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_low = '||to_char( p_due_date_low));
786: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
787: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
788: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
789: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
790: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
791: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
792: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
793: arp_standard.debug('create_auto_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );

Line 790: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );

786: arp_standard.debug('create_auto_batch_conc_req: ' || 'due_date_high = '||to_char( p_due_date_high));
787: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
788: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
789: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
790: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
791: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
792: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
793: arp_standard.debug('create_auto_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );
794: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_low = '||p_location_low );

Line 791: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );

787: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_low = '||to_char( p_document_number_low));
788: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
789: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
790: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
791: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
792: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
793: arp_standard.debug('create_auto_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );
794: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_low = '||p_location_low );
795: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_high = '||p_location_high );

Line 792: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );

788: arp_standard.debug('create_auto_batch_conc_req: ' || 'doc_num_high = '||to_char( p_document_number_high));
789: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
790: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
791: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
792: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
793: arp_standard.debug('create_auto_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );
794: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_low = '||p_location_low );
795: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_high = '||p_location_high );
796: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );

Line 793: arp_standard.debug('create_auto_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );

789: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_low = '||p_document_number_low );
790: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
791: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
792: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
793: arp_standard.debug('create_auto_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );
794: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_low = '||p_location_low );
795: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_high = '||p_location_high );
796: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );
797: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_low = '|| p_billing_number_low );

Line 794: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_low = '||p_location_low );

790: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_num_high = '||p_customer_number_high );
791: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
792: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
793: arp_standard.debug('create_auto_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );
794: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_low = '||p_location_low );
795: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_high = '||p_location_high );
796: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );
797: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_low = '|| p_billing_number_low );
798: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_high = '|| p_billing_number_high );

Line 795: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_high = '||p_location_high );

791: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_low = '||p_customer_name_low );
792: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
793: arp_standard.debug('create_auto_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );
794: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_low = '||p_location_low );
795: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_high = '||p_location_high );
796: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );
797: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_low = '|| p_billing_number_low );
798: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_high = '|| p_billing_number_high );
799: arp_standard.debug('create_auto_batch_conc_req: ' || 'bank_account_low = '|| p_bank_account_low );

Line 796: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );

792: arp_standard.debug('create_auto_batch_conc_req: ' || 'cust_name_high = '||p_customer_name_high );
793: arp_standard.debug('create_auto_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );
794: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_low = '||p_location_low );
795: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_high = '||p_location_high );
796: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );
797: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_low = '|| p_billing_number_low );
798: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_high = '|| p_billing_number_high );
799: arp_standard.debug('create_auto_batch_conc_req: ' || 'bank_account_low = '|| p_bank_account_low );
800: arp_standard.debug('create_auto_batch_conc_req: ' || 'bank_account_high = '|| p_bank_account_high );

Line 797: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_low = '|| p_billing_number_low );

793: arp_standard.debug('create_auto_batch_conc_req: ' || 'customer_id = '||to_char( p_customer_id ) );
794: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_low = '||p_location_low );
795: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_high = '||p_location_high );
796: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );
797: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_low = '|| p_billing_number_low );
798: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_high = '|| p_billing_number_high );
799: arp_standard.debug('create_auto_batch_conc_req: ' || 'bank_account_low = '|| p_bank_account_low );
800: arp_standard.debug('create_auto_batch_conc_req: ' || 'bank_account_high = '|| p_bank_account_high );
801: END IF;

Line 798: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_high = '|| p_billing_number_high );

794: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_low = '||p_location_low );
795: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_high = '||p_location_high );
796: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );
797: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_low = '|| p_billing_number_low );
798: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_high = '|| p_billing_number_high );
799: arp_standard.debug('create_auto_batch_conc_req: ' || 'bank_account_low = '|| p_bank_account_low );
800: arp_standard.debug('create_auto_batch_conc_req: ' || 'bank_account_high = '|| p_bank_account_high );
801: END IF;
802: --

Line 799: arp_standard.debug('create_auto_batch_conc_req: ' || 'bank_account_low = '|| p_bank_account_low );

795: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_high = '||p_location_high );
796: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );
797: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_low = '|| p_billing_number_low );
798: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_high = '|| p_billing_number_high );
799: arp_standard.debug('create_auto_batch_conc_req: ' || 'bank_account_low = '|| p_bank_account_low );
800: arp_standard.debug('create_auto_batch_conc_req: ' || 'bank_account_high = '|| p_bank_account_high );
801: END IF;
802: --
803: -- Validate input arguments

Line 800: arp_standard.debug('create_auto_batch_conc_req: ' || 'bank_account_high = '|| p_bank_account_high );

796: arp_standard.debug('create_auto_batch_conc_req: ' || 'site_use_id = '||to_char( p_site_use_id ) );
797: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_low = '|| p_billing_number_low );
798: arp_standard.debug('create_auto_batch_conc_req: ' || 'billing_number_high = '|| p_billing_number_high );
799: arp_standard.debug('create_auto_batch_conc_req: ' || 'bank_account_low = '|| p_bank_account_low );
800: arp_standard.debug('create_auto_batch_conc_req: ' || 'bank_account_high = '|| p_bank_account_high );
801: END IF;
802: --
803: -- Validate input arguments
804: --

Line 825: arp_standard.debug('Selecting org_id from ar_system_parameters and p_batch_id : '||p_batch_id);

821: /* Fix for Bug 5699734 - Wrong org being set because of FND_PROFILE.value('ORG_ID') */
822: /* Bug 5699734 - Changed logic for getting the org_id - Getting from ar_system_parameters would be more reliable */
823: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
824: IF PG_DEBUG in ('Y', 'C') THEN
825: arp_standard.debug('Selecting org_id from ar_system_parameters and p_batch_id : '||p_batch_id);
826: END IF;
827: SELECT org_id
828: INTO l_org_id
829: FROM ar_system_parameters;

Line 837: arp_standard.debug('create_auto_batch_conc_req: Submitting Conc Req Create Automatic Receipts with org :'||l_org_id);

833: fnd_request.set_org_id(l_org_id);
834:
835: /* Additional Debug Messages as a part of Bug 5699734 */
836: IF PG_DEBUG in ('Y', 'C') THEN
837: arp_standard.debug('create_auto_batch_conc_req: Submitting Conc Req Create Automatic Receipts with org :'||l_org_id);
838: END IF;
839: /* Additional Debug Messages ends */
840:
841: l_request_id := FND_REQUEST.submit_request( 'AR',

Line 881: arp_standard.debug('create_auto_batch_conc_req: ' || 'Out Request ID = '||to_char( l_request_id ) );

877: p_bank_account_low, p_bank_account_high
878: );
879: --
880: IF PG_DEBUG in ('Y', 'C') THEN
881: arp_standard.debug('create_auto_batch_conc_req: ' || 'Out Request ID = '||to_char( l_request_id ) );
882: END IF;
883: p_request_id := l_request_id;
884: --
885: -- Update batch record to set batch applied status

Line 935: arp_standard.debug( 'arp_process_boe.create_auto_batch_conc_req()-');

931: arp_cr_batches_pkg.update_p( l_bat_rec, l_bat_rec.batch_id );
932: p_batch_applied_status := l_bat_rec.batch_applied_status;
933: --
934: IF PG_DEBUG in ('Y', 'C') THEN
935: arp_standard.debug( 'arp_process_boe.create_auto_batch_conc_req()-');
936: END IF;
937: --
938: EXCEPTION
939: WHEN OTHERS THEN

Line 941: arp_standard.debug('create_auto_batch_conc_req: ' ||

937: --
938: EXCEPTION
939: WHEN OTHERS THEN
940: IF PG_DEBUG in ('Y', 'C') THEN
941: arp_standard.debug('create_auto_batch_conc_req: ' ||
942: 'EXCEPTION: arp_process_boe.create_auto_batch_conc_req' );
943: END IF;
944: RAISE;
945: --

Line 1013: arp_standard.debug( 'arp_process_boe.add_or_rm_txn_from_auto_batch()+');

1009: --
1010: --
1011: BEGIN
1012: IF PG_DEBUG in ('Y', 'C') THEN
1013: arp_standard.debug( 'arp_process_boe.add_or_rm_txn_from_auto_batch()+');
1014: END IF;
1015: --
1016: IF PG_DEBUG in ('Y', 'C') THEN
1017: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ct_id = '||to_char( p_ct_id ) );

Line 1017: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ct_id = '||to_char( p_ct_id ) );

1013: arp_standard.debug( 'arp_process_boe.add_or_rm_txn_from_auto_batch()+');
1014: END IF;
1015: --
1016: IF PG_DEBUG in ('Y', 'C') THEN
1017: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ct_id = '||to_char( p_ct_id ) );
1018: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ps_id = '||to_char( p_ps_id ) );
1019: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'p_selected_for_rec_batch_id = '||
1020: to_char( p_selected_for_rec_batch_id ) );
1021: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'customer_bank_account_id = '||

Line 1018: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ps_id = '||to_char( p_ps_id ) );

1014: END IF;
1015: --
1016: IF PG_DEBUG in ('Y', 'C') THEN
1017: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ct_id = '||to_char( p_ct_id ) );
1018: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ps_id = '||to_char( p_ps_id ) );
1019: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'p_selected_for_rec_batch_id = '||
1020: to_char( p_selected_for_rec_batch_id ) );
1021: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'customer_bank_account_id = '||
1022: to_char( p_customer_bank_account_id ) );

Line 1019: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'p_selected_for_rec_batch_id = '||

1015: --
1016: IF PG_DEBUG in ('Y', 'C') THEN
1017: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ct_id = '||to_char( p_ct_id ) );
1018: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ps_id = '||to_char( p_ps_id ) );
1019: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'p_selected_for_rec_batch_id = '||
1020: to_char( p_selected_for_rec_batch_id ) );
1021: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'customer_bank_account_id = '||
1022: to_char( p_customer_bank_account_id ) );
1023: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'paying_customer_id = '||

Line 1021: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'customer_bank_account_id = '||

1017: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ct_id = '||to_char( p_ct_id ) );
1018: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ps_id = '||to_char( p_ps_id ) );
1019: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'p_selected_for_rec_batch_id = '||
1020: to_char( p_selected_for_rec_batch_id ) );
1021: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'customer_bank_account_id = '||
1022: to_char( p_customer_bank_account_id ) );
1023: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'paying_customer_id = '||
1024: to_char( p_paying_customer_id ) );
1025: END IF;

Line 1023: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'paying_customer_id = '||

1019: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'p_selected_for_rec_batch_id = '||
1020: to_char( p_selected_for_rec_batch_id ) );
1021: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'customer_bank_account_id = '||
1022: to_char( p_customer_bank_account_id ) );
1023: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'paying_customer_id = '||
1024: to_char( p_paying_customer_id ) );
1025: END IF;
1026: --
1027: -- Validate input arguments

Line 1051: arp_standard.debug( 'arp_process_boe.add_or_rm_txn_from_auto_batch()-');

1047: l_ps_rec.selected_for_receipt_batch_id := p_selected_for_rec_batch_id;
1048: arp_ps_pkg.update_p( l_ps_rec, l_ps_rec.payment_schedule_id );
1049: --
1050: IF PG_DEBUG in ('Y', 'C') THEN
1051: arp_standard.debug( 'arp_process_boe.add_or_rm_txn_from_auto_batch()-');
1052: END IF;
1053: --
1054: EXCEPTION
1055: WHEN OTHERS THEN

Line 1057: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' ||

1053: --
1054: EXCEPTION
1055: WHEN OTHERS THEN
1056: IF PG_DEBUG in ('Y', 'C') THEN
1057: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' ||
1058: 'EXCEPTION: arp_process_boe.add_or_rm_txn_from_auto_batch');
1059: END IF;
1060: RAISE;
1061: --

Line 1099: arp_standard.debug( 'arp_process_boe.val_args_add_or_rm_txn_rec() +');

1095: p_customer_bank_account_id IN
1096: ra_customer_trx.customer_bank_account_id%TYPE ) IS
1097: BEGIN
1098: IF PG_DEBUG in ('Y', 'C') THEN
1099: arp_standard.debug( 'arp_process_boe.val_args_add_or_rm_txn_rec() +');
1100: END IF;
1101: --
1102: IF ( p_ct_id is NULL OR p_ps_id is NULL OR
1103: p_paying_customer_id is NULL) THEN

Line 1109: arp_standard.debug( 'arp_process_boe.val_args_add_or_rm_txn_rec() -');

1105: APP_EXCEPTION.raise_exception;
1106: END IF;
1107: --
1108: IF PG_DEBUG in ('Y', 'C') THEN
1109: arp_standard.debug( 'arp_process_boe.val_args_add_or_rm_txn_rec() -');
1110: END IF;
1111: EXCEPTION
1112: WHEN OTHERS THEN
1113: IF PG_DEBUG in ('Y', 'C') THEN

Line 1114: arp_standard.debug('val_args_add_or_rm_txn_rec: ' ||

1110: END IF;
1111: EXCEPTION
1112: WHEN OTHERS THEN
1113: IF PG_DEBUG in ('Y', 'C') THEN
1114: arp_standard.debug('val_args_add_or_rm_txn_rec: ' ||
1115: 'EXCEPTION: arp_process_boe.val_args_add_or_rm_txn_rec' );
1116: END IF;
1117: RAISE;
1118: END val_args_add_or_rm_txn_rec;