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 772: arp_standard.debug( 'arp_process_boe.create_auto_batch_conc_req()+');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

898: arp_cr_batches_pkg.update_p( l_bat_rec, l_bat_rec.batch_id );
899: p_batch_applied_status := l_bat_rec.batch_applied_status;
900: --
901: IF PG_DEBUG in ('Y', 'C') THEN
902: arp_standard.debug( 'arp_process_boe.create_auto_batch_conc_req()-');
903: END IF;
904: --
905: EXCEPTION
906: WHEN OTHERS THEN

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

904: --
905: EXCEPTION
906: WHEN OTHERS THEN
907: IF PG_DEBUG in ('Y', 'C') THEN
908: arp_standard.debug('create_auto_batch_conc_req: ' ||
909: 'EXCEPTION: arp_process_boe.create_auto_batch_conc_req' );
910: END IF;
911: RAISE;
912: --

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

976: --
977: --
978: BEGIN
979: IF PG_DEBUG in ('Y', 'C') THEN
980: arp_standard.debug( 'arp_process_boe.add_or_rm_txn_from_auto_batch()+');
981: END IF;
982: --
983: IF PG_DEBUG in ('Y', 'C') THEN
984: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ct_id = '||to_char( p_ct_id ) );

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

980: arp_standard.debug( 'arp_process_boe.add_or_rm_txn_from_auto_batch()+');
981: END IF;
982: --
983: IF PG_DEBUG in ('Y', 'C') THEN
984: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ct_id = '||to_char( p_ct_id ) );
985: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ps_id = '||to_char( p_ps_id ) );
986: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'p_selected_for_rec_batch_id = '||
987: to_char( p_selected_for_rec_batch_id ) );
988: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'customer_bank_account_id = '||

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

981: END IF;
982: --
983: IF PG_DEBUG in ('Y', 'C') THEN
984: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ct_id = '||to_char( p_ct_id ) );
985: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ps_id = '||to_char( p_ps_id ) );
986: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'p_selected_for_rec_batch_id = '||
987: to_char( p_selected_for_rec_batch_id ) );
988: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'customer_bank_account_id = '||
989: to_char( p_customer_bank_account_id ) );

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

982: --
983: IF PG_DEBUG in ('Y', 'C') THEN
984: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ct_id = '||to_char( p_ct_id ) );
985: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ps_id = '||to_char( p_ps_id ) );
986: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'p_selected_for_rec_batch_id = '||
987: to_char( p_selected_for_rec_batch_id ) );
988: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'customer_bank_account_id = '||
989: to_char( p_customer_bank_account_id ) );
990: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'paying_customer_id = '||

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

984: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ct_id = '||to_char( p_ct_id ) );
985: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'ps_id = '||to_char( p_ps_id ) );
986: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'p_selected_for_rec_batch_id = '||
987: to_char( p_selected_for_rec_batch_id ) );
988: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'customer_bank_account_id = '||
989: to_char( p_customer_bank_account_id ) );
990: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'paying_customer_id = '||
991: to_char( p_paying_customer_id ) );
992: END IF;

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

986: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'p_selected_for_rec_batch_id = '||
987: to_char( p_selected_for_rec_batch_id ) );
988: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'customer_bank_account_id = '||
989: to_char( p_customer_bank_account_id ) );
990: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' || 'paying_customer_id = '||
991: to_char( p_paying_customer_id ) );
992: END IF;
993: --
994: -- Validate input arguments

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

1014: l_ps_rec.selected_for_receipt_batch_id := p_selected_for_rec_batch_id;
1015: arp_ps_pkg.update_p( l_ps_rec, l_ps_rec.payment_schedule_id );
1016: --
1017: IF PG_DEBUG in ('Y', 'C') THEN
1018: arp_standard.debug( 'arp_process_boe.add_or_rm_txn_from_auto_batch()-');
1019: END IF;
1020: --
1021: EXCEPTION
1022: WHEN OTHERS THEN

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

1020: --
1021: EXCEPTION
1022: WHEN OTHERS THEN
1023: IF PG_DEBUG in ('Y', 'C') THEN
1024: arp_standard.debug('add_or_rm_txn_from_auto_batch: ' ||
1025: 'EXCEPTION: arp_process_boe.add_or_rm_txn_from_auto_batch');
1026: END IF;
1027: RAISE;
1028: --

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

1062: p_customer_bank_account_id IN
1063: ra_customer_trx.customer_bank_account_id%TYPE ) IS
1064: BEGIN
1065: IF PG_DEBUG in ('Y', 'C') THEN
1066: arp_standard.debug( 'arp_process_boe.val_args_add_or_rm_txn_rec() +');
1067: END IF;
1068: --
1069: IF ( p_ct_id is NULL OR p_ps_id is NULL OR
1070: p_paying_customer_id is NULL) THEN

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

1072: APP_EXCEPTION.raise_exception;
1073: END IF;
1074: --
1075: IF PG_DEBUG in ('Y', 'C') THEN
1076: arp_standard.debug( 'arp_process_boe.val_args_add_or_rm_txn_rec() -');
1077: END IF;
1078: EXCEPTION
1079: WHEN OTHERS THEN
1080: IF PG_DEBUG in ('Y', 'C') THEN

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

1077: END IF;
1078: EXCEPTION
1079: WHEN OTHERS THEN
1080: IF PG_DEBUG in ('Y', 'C') THEN
1081: arp_standard.debug('val_args_add_or_rm_txn_rec: ' ||
1082: 'EXCEPTION: arp_process_boe.val_args_add_or_rm_txn_rec' );
1083: END IF;
1084: RAISE;
1085: END val_args_add_or_rm_txn_rec;