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.AR_AUTOREC_API dependencies on ARP_DEBUG

Line 66: arp_debug.debug('process_events()+');

62:
63: BEGIN
64:
65: IF PG_DEBUG in ('Y', 'C') THEN
66: arp_debug.debug('process_events()+');
67: END IF;
68:
69: update ar_cash_receipts
70: SET creation_date = sysdate,

Line 85: arp_debug.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));

81: from AR_RECEIPTS_GT
82: where gt_id = p_gt_id );
83:
84: IF PG_DEBUG in ('Y','C') THEN
85: arp_debug.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));
86: END IF;
87:
88: update ar_cash_receipt_history SET
89: batch_id = p_batch_id,

Line 104: arp_debug.debug ( 'NO of Receipts updated CRH = '|| to_char(SQL%ROWCOUNT));

100: from AR_RECEIPTS_GT
101: where gt_id = p_gt_id );
102:
103: IF PG_DEBUG in ('Y','C') THEN
104: arp_debug.debug ( 'NO of Receipts updated CRH = '|| to_char(SQL%ROWCOUNT));
105: END IF;
106:
107: update AR_payment_schedules SET
108: created_by = pg_created_by,

Line 122: arp_debug.debug ( 'NO of Receipts updated PS = '|| to_char(SQL%ROWCOUNT));

118: from AR_RECEIPTS_GT
119: where gt_id = p_gt_id );
120:
121: IF PG_DEBUG in ('Y','C') THEN
122: arp_debug.debug ( 'NO of Receipts updated PS = '|| to_char(SQL%ROWCOUNT));
123: END IF;
124:
125: update ar_receivable_applications SET
126: created_by = pg_created_by,

Line 169: arp_debug.debug ( 'NO of RA updated = '|| to_char(SQL%ROWCOUNT));

165: and ct.cc_error_flag = 'Y'
166: );
167:
168: IF PG_DEBUG in ('Y','C') THEN
169: arp_debug.debug ( 'NO of RA updated = '|| to_char(SQL%ROWCOUNT));
170: END IF;
171:
172: select min(gt.cash_receipt_id),
173: max(gt.cash_receipt_id),

Line 186: arp_debug.debug ( 'Calling XLA event creation procedures for');

182: where gt.cash_receipt_id = ra.cash_receipt_id
183: and gt_id = p_gt_id;
184:
185: IF PG_DEBUG in ('Y','C') THEN
186: arp_debug.debug ( 'Calling XLA event creation procedures for');
187: arp_debug.debug ( 'xla_req_id '||pg_request_id);
188: arp_debug.debug ( 'xla_from_doc_id '||l_from_doc_id);
189: arp_debug.debug ( 'xla_to_doc_id '||l_to_doc_id);
190: END IF;

Line 187: arp_debug.debug ( 'xla_req_id '||pg_request_id);

183: and gt_id = p_gt_id;
184:
185: IF PG_DEBUG in ('Y','C') THEN
186: arp_debug.debug ( 'Calling XLA event creation procedures for');
187: arp_debug.debug ( 'xla_req_id '||pg_request_id);
188: arp_debug.debug ( 'xla_from_doc_id '||l_from_doc_id);
189: arp_debug.debug ( 'xla_to_doc_id '||l_to_doc_id);
190: END IF;
191:

Line 188: arp_debug.debug ( 'xla_from_doc_id '||l_from_doc_id);

184:
185: IF PG_DEBUG in ('Y','C') THEN
186: arp_debug.debug ( 'Calling XLA event creation procedures for');
187: arp_debug.debug ( 'xla_req_id '||pg_request_id);
188: arp_debug.debug ( 'xla_from_doc_id '||l_from_doc_id);
189: arp_debug.debug ( 'xla_to_doc_id '||l_to_doc_id);
190: END IF;
191:
192: /* Create events for the receipts associated to this request id and given range*/

Line 189: arp_debug.debug ( 'xla_to_doc_id '||l_to_doc_id);

185: IF PG_DEBUG in ('Y','C') THEN
186: arp_debug.debug ( 'Calling XLA event creation procedures for');
187: arp_debug.debug ( 'xla_req_id '||pg_request_id);
188: arp_debug.debug ( 'xla_from_doc_id '||l_from_doc_id);
189: arp_debug.debug ( 'xla_to_doc_id '||l_to_doc_id);
190: END IF;
191:
192: /* Create events for the receipts associated to this request id and given range*/
193: l_xla_ev_rec.xla_doc_table := 'CRHAPP';

Line 233: arp_debug.debug ( 'Calling XLA event creation procedure again in O mode');

229:
230: IF l_from_ra_doc_id IS NOT NULL THEN
231:
232: IF PG_DEBUG in ('Y','C') THEN
233: arp_debug.debug ( 'Calling XLA event creation procedure again in O mode');
234: arp_debug.debug ( 'xla_req_id '||pg_request_id);
235: arp_debug.debug ( 'xla_from_doc_id '||l_from_doc_id);
236: arp_debug.debug ( 'xla_to_doc_id '||l_to_doc_id);
237: END IF;

Line 234: arp_debug.debug ( 'xla_req_id '||pg_request_id);

230: IF l_from_ra_doc_id IS NOT NULL THEN
231:
232: IF PG_DEBUG in ('Y','C') THEN
233: arp_debug.debug ( 'Calling XLA event creation procedure again in O mode');
234: arp_debug.debug ( 'xla_req_id '||pg_request_id);
235: arp_debug.debug ( 'xla_from_doc_id '||l_from_doc_id);
236: arp_debug.debug ( 'xla_to_doc_id '||l_to_doc_id);
237: END IF;
238:

Line 235: arp_debug.debug ( 'xla_from_doc_id '||l_from_doc_id);

231:
232: IF PG_DEBUG in ('Y','C') THEN
233: arp_debug.debug ( 'Calling XLA event creation procedure again in O mode');
234: arp_debug.debug ( 'xla_req_id '||pg_request_id);
235: arp_debug.debug ( 'xla_from_doc_id '||l_from_doc_id);
236: arp_debug.debug ( 'xla_to_doc_id '||l_to_doc_id);
237: END IF;
238:
239: l_xla_ev_rec.xla_doc_table := 'APP';

Line 236: arp_debug.debug ( 'xla_to_doc_id '||l_to_doc_id);

232: IF PG_DEBUG in ('Y','C') THEN
233: arp_debug.debug ( 'Calling XLA event creation procedure again in O mode');
234: arp_debug.debug ( 'xla_req_id '||pg_request_id);
235: arp_debug.debug ( 'xla_from_doc_id '||l_from_doc_id);
236: arp_debug.debug ( 'xla_to_doc_id '||l_to_doc_id);
237: END IF;
238:
239: l_xla_ev_rec.xla_doc_table := 'APP';
240: l_xla_ev_rec.xla_req_id := pg_request_id;

Line 251: arp_debug.debug('process_events()-');

247:
248: END IF;
249:
250: IF PG_DEBUG in ('Y', 'C') THEN
251: arp_debug.debug('process_events()-');
252: END IF;
253:
254: EXCEPTION
255: WHEN others THEN

Line 256: arp_debug.debug('Exception : process_events() '|| SQLERRM);

252: END IF;
253:
254: EXCEPTION
255: WHEN others THEN
256: arp_debug.debug('Exception : process_events() '|| SQLERRM);
257:
258: insert_exceptions( p_batch_id => p_batch_id,
259: p_request_id => pg_request_id,
260: p_exception_code => 'AUTORECERR',

Line 269: arp_debug.debug( '------------------------------------------------------');

265:
266: PROCEDURE dump_ar_receipts_gt IS
267: BEGIN
268: FOR rec IN (select * from ar_receipts_gt) LOOP
269: arp_debug.debug( '------------------------------------------------------');
270: arp_debug.debug( 'PAYMENT_SCHEDULE_ID :'|| rec.payment_schedule_id );
271: arp_debug.debug( 'CUSTOMER_TRX_ID :'|| rec.customer_trx_id );
272: arp_debug.debug( 'CASH_RECEIPT_ID :'|| rec.cash_receipt_id);
273: arp_debug.debug( 'PAYING_CUSTOMER_ID :'|| rec.paying_customer_id);

Line 270: arp_debug.debug( 'PAYMENT_SCHEDULE_ID :'|| rec.payment_schedule_id );

266: PROCEDURE dump_ar_receipts_gt IS
267: BEGIN
268: FOR rec IN (select * from ar_receipts_gt) LOOP
269: arp_debug.debug( '------------------------------------------------------');
270: arp_debug.debug( 'PAYMENT_SCHEDULE_ID :'|| rec.payment_schedule_id );
271: arp_debug.debug( 'CUSTOMER_TRX_ID :'|| rec.customer_trx_id );
272: arp_debug.debug( 'CASH_RECEIPT_ID :'|| rec.cash_receipt_id);
273: arp_debug.debug( 'PAYING_CUSTOMER_ID :'|| rec.paying_customer_id);
274: arp_debug.debug( 'PAYING_SITE_USE_ID :'|| rec.paying_site_use_id);

Line 271: arp_debug.debug( 'CUSTOMER_TRX_ID :'|| rec.customer_trx_id );

267: BEGIN
268: FOR rec IN (select * from ar_receipts_gt) LOOP
269: arp_debug.debug( '------------------------------------------------------');
270: arp_debug.debug( 'PAYMENT_SCHEDULE_ID :'|| rec.payment_schedule_id );
271: arp_debug.debug( 'CUSTOMER_TRX_ID :'|| rec.customer_trx_id );
272: arp_debug.debug( 'CASH_RECEIPT_ID :'|| rec.cash_receipt_id);
273: arp_debug.debug( 'PAYING_CUSTOMER_ID :'|| rec.paying_customer_id);
274: arp_debug.debug( 'PAYING_SITE_USE_ID :'|| rec.paying_site_use_id);
275: arp_debug.debug( 'PAYMENT_TRXN_EXTENSION_ID :'|| rec.payment_trxn_extension_id);

Line 272: arp_debug.debug( 'CASH_RECEIPT_ID :'|| rec.cash_receipt_id);

268: FOR rec IN (select * from ar_receipts_gt) LOOP
269: arp_debug.debug( '------------------------------------------------------');
270: arp_debug.debug( 'PAYMENT_SCHEDULE_ID :'|| rec.payment_schedule_id );
271: arp_debug.debug( 'CUSTOMER_TRX_ID :'|| rec.customer_trx_id );
272: arp_debug.debug( 'CASH_RECEIPT_ID :'|| rec.cash_receipt_id);
273: arp_debug.debug( 'PAYING_CUSTOMER_ID :'|| rec.paying_customer_id);
274: arp_debug.debug( 'PAYING_SITE_USE_ID :'|| rec.paying_site_use_id);
275: arp_debug.debug( 'PAYMENT_TRXN_EXTENSION_ID :'|| rec.payment_trxn_extension_id);
276: arp_debug.debug( 'DUE_DATE :'|| rec.due_date);

Line 273: arp_debug.debug( 'PAYING_CUSTOMER_ID :'|| rec.paying_customer_id);

269: arp_debug.debug( '------------------------------------------------------');
270: arp_debug.debug( 'PAYMENT_SCHEDULE_ID :'|| rec.payment_schedule_id );
271: arp_debug.debug( 'CUSTOMER_TRX_ID :'|| rec.customer_trx_id );
272: arp_debug.debug( 'CASH_RECEIPT_ID :'|| rec.cash_receipt_id);
273: arp_debug.debug( 'PAYING_CUSTOMER_ID :'|| rec.paying_customer_id);
274: arp_debug.debug( 'PAYING_SITE_USE_ID :'|| rec.paying_site_use_id);
275: arp_debug.debug( 'PAYMENT_TRXN_EXTENSION_ID :'|| rec.payment_trxn_extension_id);
276: arp_debug.debug( 'DUE_DATE :'|| rec.due_date);
277: arp_debug.debug( 'AMOUNT_DUE_REMAINING :'|| rec.amount_due_remaining);

Line 274: arp_debug.debug( 'PAYING_SITE_USE_ID :'|| rec.paying_site_use_id);

270: arp_debug.debug( 'PAYMENT_SCHEDULE_ID :'|| rec.payment_schedule_id );
271: arp_debug.debug( 'CUSTOMER_TRX_ID :'|| rec.customer_trx_id );
272: arp_debug.debug( 'CASH_RECEIPT_ID :'|| rec.cash_receipt_id);
273: arp_debug.debug( 'PAYING_CUSTOMER_ID :'|| rec.paying_customer_id);
274: arp_debug.debug( 'PAYING_SITE_USE_ID :'|| rec.paying_site_use_id);
275: arp_debug.debug( 'PAYMENT_TRXN_EXTENSION_ID :'|| rec.payment_trxn_extension_id);
276: arp_debug.debug( 'DUE_DATE :'|| rec.due_date);
277: arp_debug.debug( 'AMOUNT_DUE_REMAINING :'|| rec.amount_due_remaining);
278: arp_debug.debug( 'CUSTOMER_BANK_ACCOUNT_ID :'|| rec.customer_bank_account_id);

Line 275: arp_debug.debug( 'PAYMENT_TRXN_EXTENSION_ID :'|| rec.payment_trxn_extension_id);

271: arp_debug.debug( 'CUSTOMER_TRX_ID :'|| rec.customer_trx_id );
272: arp_debug.debug( 'CASH_RECEIPT_ID :'|| rec.cash_receipt_id);
273: arp_debug.debug( 'PAYING_CUSTOMER_ID :'|| rec.paying_customer_id);
274: arp_debug.debug( 'PAYING_SITE_USE_ID :'|| rec.paying_site_use_id);
275: arp_debug.debug( 'PAYMENT_TRXN_EXTENSION_ID :'|| rec.payment_trxn_extension_id);
276: arp_debug.debug( 'DUE_DATE :'|| rec.due_date);
277: arp_debug.debug( 'AMOUNT_DUE_REMAINING :'|| rec.amount_due_remaining);
278: arp_debug.debug( 'CUSTOMER_BANK_ACCOUNT_ID :'|| rec.customer_bank_account_id);
279: arp_debug.debug( 'CUST_MIN_AMOUNT :'|| rec.cust_min_amount);

Line 276: arp_debug.debug( 'DUE_DATE :'|| rec.due_date);

272: arp_debug.debug( 'CASH_RECEIPT_ID :'|| rec.cash_receipt_id);
273: arp_debug.debug( 'PAYING_CUSTOMER_ID :'|| rec.paying_customer_id);
274: arp_debug.debug( 'PAYING_SITE_USE_ID :'|| rec.paying_site_use_id);
275: arp_debug.debug( 'PAYMENT_TRXN_EXTENSION_ID :'|| rec.payment_trxn_extension_id);
276: arp_debug.debug( 'DUE_DATE :'|| rec.due_date);
277: arp_debug.debug( 'AMOUNT_DUE_REMAINING :'|| rec.amount_due_remaining);
278: arp_debug.debug( 'CUSTOMER_BANK_ACCOUNT_ID :'|| rec.customer_bank_account_id);
279: arp_debug.debug( 'CUST_MIN_AMOUNT :'|| rec.cust_min_amount);
280: arp_debug.debug( 'RECEIPT_NUMBER :'|| rec.receipt_number);

Line 277: arp_debug.debug( 'AMOUNT_DUE_REMAINING :'|| rec.amount_due_remaining);

273: arp_debug.debug( 'PAYING_CUSTOMER_ID :'|| rec.paying_customer_id);
274: arp_debug.debug( 'PAYING_SITE_USE_ID :'|| rec.paying_site_use_id);
275: arp_debug.debug( 'PAYMENT_TRXN_EXTENSION_ID :'|| rec.payment_trxn_extension_id);
276: arp_debug.debug( 'DUE_DATE :'|| rec.due_date);
277: arp_debug.debug( 'AMOUNT_DUE_REMAINING :'|| rec.amount_due_remaining);
278: arp_debug.debug( 'CUSTOMER_BANK_ACCOUNT_ID :'|| rec.customer_bank_account_id);
279: arp_debug.debug( 'CUST_MIN_AMOUNT :'|| rec.cust_min_amount);
280: arp_debug.debug( 'RECEIPT_NUMBER :'|| rec.receipt_number);
281: arp_debug.debug( 'PAYMENT_CHANNEL_CODE :'|| rec.payment_channel_code);

Line 278: arp_debug.debug( 'CUSTOMER_BANK_ACCOUNT_ID :'|| rec.customer_bank_account_id);

274: arp_debug.debug( 'PAYING_SITE_USE_ID :'|| rec.paying_site_use_id);
275: arp_debug.debug( 'PAYMENT_TRXN_EXTENSION_ID :'|| rec.payment_trxn_extension_id);
276: arp_debug.debug( 'DUE_DATE :'|| rec.due_date);
277: arp_debug.debug( 'AMOUNT_DUE_REMAINING :'|| rec.amount_due_remaining);
278: arp_debug.debug( 'CUSTOMER_BANK_ACCOUNT_ID :'|| rec.customer_bank_account_id);
279: arp_debug.debug( 'CUST_MIN_AMOUNT :'|| rec.cust_min_amount);
280: arp_debug.debug( 'RECEIPT_NUMBER :'|| rec.receipt_number);
281: arp_debug.debug( 'PAYMENT_CHANNEL_CODE :'|| rec.payment_channel_code);
282: arp_debug.debug( 'PAYMENT_INSTRUMENT :'|| rec.payment_instrument);

Line 279: arp_debug.debug( 'CUST_MIN_AMOUNT :'|| rec.cust_min_amount);

275: arp_debug.debug( 'PAYMENT_TRXN_EXTENSION_ID :'|| rec.payment_trxn_extension_id);
276: arp_debug.debug( 'DUE_DATE :'|| rec.due_date);
277: arp_debug.debug( 'AMOUNT_DUE_REMAINING :'|| rec.amount_due_remaining);
278: arp_debug.debug( 'CUSTOMER_BANK_ACCOUNT_ID :'|| rec.customer_bank_account_id);
279: arp_debug.debug( 'CUST_MIN_AMOUNT :'|| rec.cust_min_amount);
280: arp_debug.debug( 'RECEIPT_NUMBER :'|| rec.receipt_number);
281: arp_debug.debug( 'PAYMENT_CHANNEL_CODE :'|| rec.payment_channel_code);
282: arp_debug.debug( 'PAYMENT_INSTRUMENT :'|| rec.payment_instrument);
283: arp_debug.debug( 'AUTHORIZATION_ID :'|| rec.authorization_id);

Line 280: arp_debug.debug( 'RECEIPT_NUMBER :'|| rec.receipt_number);

276: arp_debug.debug( 'DUE_DATE :'|| rec.due_date);
277: arp_debug.debug( 'AMOUNT_DUE_REMAINING :'|| rec.amount_due_remaining);
278: arp_debug.debug( 'CUSTOMER_BANK_ACCOUNT_ID :'|| rec.customer_bank_account_id);
279: arp_debug.debug( 'CUST_MIN_AMOUNT :'|| rec.cust_min_amount);
280: arp_debug.debug( 'RECEIPT_NUMBER :'|| rec.receipt_number);
281: arp_debug.debug( 'PAYMENT_CHANNEL_CODE :'|| rec.payment_channel_code);
282: arp_debug.debug( 'PAYMENT_INSTRUMENT :'|| rec.payment_instrument);
283: arp_debug.debug( 'AUTHORIZATION_ID :'|| rec.authorization_id);
284: arp_debug.debug( 'GT_ID :'|| rec.gt_id);

Line 281: arp_debug.debug( 'PAYMENT_CHANNEL_CODE :'|| rec.payment_channel_code);

277: arp_debug.debug( 'AMOUNT_DUE_REMAINING :'|| rec.amount_due_remaining);
278: arp_debug.debug( 'CUSTOMER_BANK_ACCOUNT_ID :'|| rec.customer_bank_account_id);
279: arp_debug.debug( 'CUST_MIN_AMOUNT :'|| rec.cust_min_amount);
280: arp_debug.debug( 'RECEIPT_NUMBER :'|| rec.receipt_number);
281: arp_debug.debug( 'PAYMENT_CHANNEL_CODE :'|| rec.payment_channel_code);
282: arp_debug.debug( 'PAYMENT_INSTRUMENT :'|| rec.payment_instrument);
283: arp_debug.debug( 'AUTHORIZATION_ID :'|| rec.authorization_id);
284: arp_debug.debug( 'GT_ID :'|| rec.gt_id);
285: END LOOP;

Line 282: arp_debug.debug( 'PAYMENT_INSTRUMENT :'|| rec.payment_instrument);

278: arp_debug.debug( 'CUSTOMER_BANK_ACCOUNT_ID :'|| rec.customer_bank_account_id);
279: arp_debug.debug( 'CUST_MIN_AMOUNT :'|| rec.cust_min_amount);
280: arp_debug.debug( 'RECEIPT_NUMBER :'|| rec.receipt_number);
281: arp_debug.debug( 'PAYMENT_CHANNEL_CODE :'|| rec.payment_channel_code);
282: arp_debug.debug( 'PAYMENT_INSTRUMENT :'|| rec.payment_instrument);
283: arp_debug.debug( 'AUTHORIZATION_ID :'|| rec.authorization_id);
284: arp_debug.debug( 'GT_ID :'|| rec.gt_id);
285: END LOOP;
286:

Line 283: arp_debug.debug( 'AUTHORIZATION_ID :'|| rec.authorization_id);

279: arp_debug.debug( 'CUST_MIN_AMOUNT :'|| rec.cust_min_amount);
280: arp_debug.debug( 'RECEIPT_NUMBER :'|| rec.receipt_number);
281: arp_debug.debug( 'PAYMENT_CHANNEL_CODE :'|| rec.payment_channel_code);
282: arp_debug.debug( 'PAYMENT_INSTRUMENT :'|| rec.payment_instrument);
283: arp_debug.debug( 'AUTHORIZATION_ID :'|| rec.authorization_id);
284: arp_debug.debug( 'GT_ID :'|| rec.gt_id);
285: END LOOP;
286:
287: END dump_ar_receipts_gt;

Line 284: arp_debug.debug( 'GT_ID :'|| rec.gt_id);

280: arp_debug.debug( 'RECEIPT_NUMBER :'|| rec.receipt_number);
281: arp_debug.debug( 'PAYMENT_CHANNEL_CODE :'|| rec.payment_channel_code);
282: arp_debug.debug( 'PAYMENT_INSTRUMENT :'|| rec.payment_instrument);
283: arp_debug.debug( 'AUTHORIZATION_ID :'|| rec.authorization_id);
284: arp_debug.debug( 'GT_ID :'|| rec.gt_id);
285: END LOOP;
286:
287: END dump_ar_receipts_gt;
288:

Line 295: arp_debug.debug('process_incomplete_receipts()+');

291: l_receipt_method_id ar_batches.receipt_method_id%type;
292:
293: BEGIN
294: IF PG_DEBUG in ('Y', 'C') THEN
295: arp_debug.debug('process_incomplete_receipts()+');
296: arp_debug.debug('p_batch_id '|| p_batch_id );
297: END IF;
298:
299: select receipt_method_id

Line 296: arp_debug.debug('p_batch_id '|| p_batch_id );

292:
293: BEGIN
294: IF PG_DEBUG in ('Y', 'C') THEN
295: arp_debug.debug('process_incomplete_receipts()+');
296: arp_debug.debug('p_batch_id '|| p_batch_id );
297: END IF;
298:
299: select receipt_method_id
300: into l_receipt_method_id

Line 321: arp_debug.debug('process_incomplete_receipts()-');

317: delete
318: from ar_receipts_gt;
319:
320: IF PG_DEBUG in ('Y', 'C') THEN
321: arp_debug.debug('process_incomplete_receipts()-');
322: END IF;
323: END process_incomplete_receipts;
324:
325:

Line 469: arp_debug.debug('autorecapi start ()+ ');

465: l_apply_fail := 'N';
466: l_pay_process_fail := 'N';
467:
468: IF PG_DEBUG in ('Y', 'C') THEN
469: arp_debug.debug('autorecapi start ()+ ');
470: arp_debug.debug('get_parameters()+ ');
471: arp_debug.debug('p_errbuf ' || P_ERRBUF);
472: arp_debug.debug('p_retcode ' || (P_RETCODE));
473: arp_debug.debug('p_process_type ' || p_process_type);

Line 470: arp_debug.debug('get_parameters()+ ');

466: l_pay_process_fail := 'N';
467:
468: IF PG_DEBUG in ('Y', 'C') THEN
469: arp_debug.debug('autorecapi start ()+ ');
470: arp_debug.debug('get_parameters()+ ');
471: arp_debug.debug('p_errbuf ' || P_ERRBUF);
472: arp_debug.debug('p_retcode ' || (P_RETCODE));
473: arp_debug.debug('p_process_type ' || p_process_type);
474: arp_debug.debug('p_create_flag ' || p_create_flag);

Line 471: arp_debug.debug('p_errbuf ' || P_ERRBUF);

467:
468: IF PG_DEBUG in ('Y', 'C') THEN
469: arp_debug.debug('autorecapi start ()+ ');
470: arp_debug.debug('get_parameters()+ ');
471: arp_debug.debug('p_errbuf ' || P_ERRBUF);
472: arp_debug.debug('p_retcode ' || (P_RETCODE));
473: arp_debug.debug('p_process_type ' || p_process_type);
474: arp_debug.debug('p_create_flag ' || p_create_flag);
475: arp_debug.debug('p_approve_flag ' || p_approve_flag);

Line 472: arp_debug.debug('p_retcode ' || (P_RETCODE));

468: IF PG_DEBUG in ('Y', 'C') THEN
469: arp_debug.debug('autorecapi start ()+ ');
470: arp_debug.debug('get_parameters()+ ');
471: arp_debug.debug('p_errbuf ' || P_ERRBUF);
472: arp_debug.debug('p_retcode ' || (P_RETCODE));
473: arp_debug.debug('p_process_type ' || p_process_type);
474: arp_debug.debug('p_create_flag ' || p_create_flag);
475: arp_debug.debug('p_approve_flag ' || p_approve_flag);
476: arp_debug.debug('p_format_flag ' || p_format_flag);

Line 473: arp_debug.debug('p_process_type ' || p_process_type);

469: arp_debug.debug('autorecapi start ()+ ');
470: arp_debug.debug('get_parameters()+ ');
471: arp_debug.debug('p_errbuf ' || P_ERRBUF);
472: arp_debug.debug('p_retcode ' || (P_RETCODE));
473: arp_debug.debug('p_process_type ' || p_process_type);
474: arp_debug.debug('p_create_flag ' || p_create_flag);
475: arp_debug.debug('p_approve_flag ' || p_approve_flag);
476: arp_debug.debug('p_format_flag ' || p_format_flag);
477: arp_debug.debug('p_batch_id ' || (p_batch_id));

Line 474: arp_debug.debug('p_create_flag ' || p_create_flag);

470: arp_debug.debug('get_parameters()+ ');
471: arp_debug.debug('p_errbuf ' || P_ERRBUF);
472: arp_debug.debug('p_retcode ' || (P_RETCODE));
473: arp_debug.debug('p_process_type ' || p_process_type);
474: arp_debug.debug('p_create_flag ' || p_create_flag);
475: arp_debug.debug('p_approve_flag ' || p_approve_flag);
476: arp_debug.debug('p_format_flag ' || p_format_flag);
477: arp_debug.debug('p_batch_id ' || (p_batch_id));
478: arp_debug.debug('p_debug_mode_on ' || p_debug_mode_on);

Line 475: arp_debug.debug('p_approve_flag ' || p_approve_flag);

471: arp_debug.debug('p_errbuf ' || P_ERRBUF);
472: arp_debug.debug('p_retcode ' || (P_RETCODE));
473: arp_debug.debug('p_process_type ' || p_process_type);
474: arp_debug.debug('p_create_flag ' || p_create_flag);
475: arp_debug.debug('p_approve_flag ' || p_approve_flag);
476: arp_debug.debug('p_format_flag ' || p_format_flag);
477: arp_debug.debug('p_batch_id ' || (p_batch_id));
478: arp_debug.debug('p_debug_mode_on ' || p_debug_mode_on);
479: arp_debug.debug('p_receipt_class_id ' || p_receipt_class_id);

Line 476: arp_debug.debug('p_format_flag ' || p_format_flag);

472: arp_debug.debug('p_retcode ' || (P_RETCODE));
473: arp_debug.debug('p_process_type ' || p_process_type);
474: arp_debug.debug('p_create_flag ' || p_create_flag);
475: arp_debug.debug('p_approve_flag ' || p_approve_flag);
476: arp_debug.debug('p_format_flag ' || p_format_flag);
477: arp_debug.debug('p_batch_id ' || (p_batch_id));
478: arp_debug.debug('p_debug_mode_on ' || p_debug_mode_on);
479: arp_debug.debug('p_receipt_class_id ' || p_receipt_class_id);
480: arp_debug.debug('p_payment_method_id ' || p_payment_method_id);

Line 477: arp_debug.debug('p_batch_id ' || (p_batch_id));

473: arp_debug.debug('p_process_type ' || p_process_type);
474: arp_debug.debug('p_create_flag ' || p_create_flag);
475: arp_debug.debug('p_approve_flag ' || p_approve_flag);
476: arp_debug.debug('p_format_flag ' || p_format_flag);
477: arp_debug.debug('p_batch_id ' || (p_batch_id));
478: arp_debug.debug('p_debug_mode_on ' || p_debug_mode_on);
479: arp_debug.debug('p_receipt_class_id ' || p_receipt_class_id);
480: arp_debug.debug('p_payment_method_id ' || p_payment_method_id);
481: arp_debug.debug('p_batch_currency ' || p_batch_currency);

Line 478: arp_debug.debug('p_debug_mode_on ' || p_debug_mode_on);

474: arp_debug.debug('p_create_flag ' || p_create_flag);
475: arp_debug.debug('p_approve_flag ' || p_approve_flag);
476: arp_debug.debug('p_format_flag ' || p_format_flag);
477: arp_debug.debug('p_batch_id ' || (p_batch_id));
478: arp_debug.debug('p_debug_mode_on ' || p_debug_mode_on);
479: arp_debug.debug('p_receipt_class_id ' || p_receipt_class_id);
480: arp_debug.debug('p_payment_method_id ' || p_payment_method_id);
481: arp_debug.debug('p_batch_currency ' || p_batch_currency);
482: arp_debug.debug('p_batch_date ' || p_batch_date);

Line 479: arp_debug.debug('p_receipt_class_id ' || p_receipt_class_id);

475: arp_debug.debug('p_approve_flag ' || p_approve_flag);
476: arp_debug.debug('p_format_flag ' || p_format_flag);
477: arp_debug.debug('p_batch_id ' || (p_batch_id));
478: arp_debug.debug('p_debug_mode_on ' || p_debug_mode_on);
479: arp_debug.debug('p_receipt_class_id ' || p_receipt_class_id);
480: arp_debug.debug('p_payment_method_id ' || p_payment_method_id);
481: arp_debug.debug('p_batch_currency ' || p_batch_currency);
482: arp_debug.debug('p_batch_date ' || p_batch_date);
483: arp_debug.debug('p_batch_gl_date ' || p_batch_gl_date);

Line 480: arp_debug.debug('p_payment_method_id ' || p_payment_method_id);

476: arp_debug.debug('p_format_flag ' || p_format_flag);
477: arp_debug.debug('p_batch_id ' || (p_batch_id));
478: arp_debug.debug('p_debug_mode_on ' || p_debug_mode_on);
479: arp_debug.debug('p_receipt_class_id ' || p_receipt_class_id);
480: arp_debug.debug('p_payment_method_id ' || p_payment_method_id);
481: arp_debug.debug('p_batch_currency ' || p_batch_currency);
482: arp_debug.debug('p_batch_date ' || p_batch_date);
483: arp_debug.debug('p_batch_gl_date ' || p_batch_gl_date);
484: arp_debug.debug('p_comments ' || p_comments);

Line 481: arp_debug.debug('p_batch_currency ' || p_batch_currency);

477: arp_debug.debug('p_batch_id ' || (p_batch_id));
478: arp_debug.debug('p_debug_mode_on ' || p_debug_mode_on);
479: arp_debug.debug('p_receipt_class_id ' || p_receipt_class_id);
480: arp_debug.debug('p_payment_method_id ' || p_payment_method_id);
481: arp_debug.debug('p_batch_currency ' || p_batch_currency);
482: arp_debug.debug('p_batch_date ' || p_batch_date);
483: arp_debug.debug('p_batch_gl_date ' || p_batch_gl_date);
484: arp_debug.debug('p_comments ' || p_comments);
485: arp_debug.debug('p_exchnage_date ' || p_exchange_date);

Line 482: arp_debug.debug('p_batch_date ' || p_batch_date);

478: arp_debug.debug('p_debug_mode_on ' || p_debug_mode_on);
479: arp_debug.debug('p_receipt_class_id ' || p_receipt_class_id);
480: arp_debug.debug('p_payment_method_id ' || p_payment_method_id);
481: arp_debug.debug('p_batch_currency ' || p_batch_currency);
482: arp_debug.debug('p_batch_date ' || p_batch_date);
483: arp_debug.debug('p_batch_gl_date ' || p_batch_gl_date);
484: arp_debug.debug('p_comments ' || p_comments);
485: arp_debug.debug('p_exchnage_date ' || p_exchange_date);
486: arp_debug.debug('p_exchnage_rate ' || p_exchange_rate);

Line 483: arp_debug.debug('p_batch_gl_date ' || p_batch_gl_date);

479: arp_debug.debug('p_receipt_class_id ' || p_receipt_class_id);
480: arp_debug.debug('p_payment_method_id ' || p_payment_method_id);
481: arp_debug.debug('p_batch_currency ' || p_batch_currency);
482: arp_debug.debug('p_batch_date ' || p_batch_date);
483: arp_debug.debug('p_batch_gl_date ' || p_batch_gl_date);
484: arp_debug.debug('p_comments ' || p_comments);
485: arp_debug.debug('p_exchnage_date ' || p_exchange_date);
486: arp_debug.debug('p_exchnage_rate ' || p_exchange_rate);
487: arp_debug.debug('p_exchnage_rate_type ' || p_exchange_rate_type);

Line 484: arp_debug.debug('p_comments ' || p_comments);

480: arp_debug.debug('p_payment_method_id ' || p_payment_method_id);
481: arp_debug.debug('p_batch_currency ' || p_batch_currency);
482: arp_debug.debug('p_batch_date ' || p_batch_date);
483: arp_debug.debug('p_batch_gl_date ' || p_batch_gl_date);
484: arp_debug.debug('p_comments ' || p_comments);
485: arp_debug.debug('p_exchnage_date ' || p_exchange_date);
486: arp_debug.debug('p_exchnage_rate ' || p_exchange_rate);
487: arp_debug.debug('p_exchnage_rate_type ' || p_exchange_rate_type);
488: arp_debug.debug('p_media_reference ' || p_media_reference);

Line 485: arp_debug.debug('p_exchnage_date ' || p_exchange_date);

481: arp_debug.debug('p_batch_currency ' || p_batch_currency);
482: arp_debug.debug('p_batch_date ' || p_batch_date);
483: arp_debug.debug('p_batch_gl_date ' || p_batch_gl_date);
484: arp_debug.debug('p_comments ' || p_comments);
485: arp_debug.debug('p_exchnage_date ' || p_exchange_date);
486: arp_debug.debug('p_exchnage_rate ' || p_exchange_rate);
487: arp_debug.debug('p_exchnage_rate_type ' || p_exchange_rate_type);
488: arp_debug.debug('p_media_reference ' || p_media_reference);
489: arp_debug.debug('p_remit_method_code ' || p_remit_method_code);

Line 486: arp_debug.debug('p_exchnage_rate ' || p_exchange_rate);

482: arp_debug.debug('p_batch_date ' || p_batch_date);
483: arp_debug.debug('p_batch_gl_date ' || p_batch_gl_date);
484: arp_debug.debug('p_comments ' || p_comments);
485: arp_debug.debug('p_exchnage_date ' || p_exchange_date);
486: arp_debug.debug('p_exchnage_rate ' || p_exchange_rate);
487: arp_debug.debug('p_exchnage_rate_type ' || p_exchange_rate_type);
488: arp_debug.debug('p_media_reference ' || p_media_reference);
489: arp_debug.debug('p_remit_method_code ' || p_remit_method_code);
490: arp_debug.debug('p_remit_bank_branch_id ' || p_remit_bank_branch_id);

Line 487: arp_debug.debug('p_exchnage_rate_type ' || p_exchange_rate_type);

483: arp_debug.debug('p_batch_gl_date ' || p_batch_gl_date);
484: arp_debug.debug('p_comments ' || p_comments);
485: arp_debug.debug('p_exchnage_date ' || p_exchange_date);
486: arp_debug.debug('p_exchnage_rate ' || p_exchange_rate);
487: arp_debug.debug('p_exchnage_rate_type ' || p_exchange_rate_type);
488: arp_debug.debug('p_media_reference ' || p_media_reference);
489: arp_debug.debug('p_remit_method_code ' || p_remit_method_code);
490: arp_debug.debug('p_remit_bank_branch_id ' || p_remit_bank_branch_id);
491: arp_debug.debug('p_remit_bank_account_id ' || p_remit_bank_account_id);

Line 488: arp_debug.debug('p_media_reference ' || p_media_reference);

484: arp_debug.debug('p_comments ' || p_comments);
485: arp_debug.debug('p_exchnage_date ' || p_exchange_date);
486: arp_debug.debug('p_exchnage_rate ' || p_exchange_rate);
487: arp_debug.debug('p_exchnage_rate_type ' || p_exchange_rate_type);
488: arp_debug.debug('p_media_reference ' || p_media_reference);
489: arp_debug.debug('p_remit_method_code ' || p_remit_method_code);
490: arp_debug.debug('p_remit_bank_branch_id ' || p_remit_bank_branch_id);
491: arp_debug.debug('p_remit_bank_account_id ' || p_remit_bank_account_id);
492: arp_debug.debug('p_remit_bank_deposit_number' || p_remit_bank_deposit_number);

Line 489: arp_debug.debug('p_remit_method_code ' || p_remit_method_code);

485: arp_debug.debug('p_exchnage_date ' || p_exchange_date);
486: arp_debug.debug('p_exchnage_rate ' || p_exchange_rate);
487: arp_debug.debug('p_exchnage_rate_type ' || p_exchange_rate_type);
488: arp_debug.debug('p_media_reference ' || p_media_reference);
489: arp_debug.debug('p_remit_method_code ' || p_remit_method_code);
490: arp_debug.debug('p_remit_bank_branch_id ' || p_remit_bank_branch_id);
491: arp_debug.debug('p_remit_bank_account_id ' || p_remit_bank_account_id);
492: arp_debug.debug('p_remit_bank_deposit_number' || p_remit_bank_deposit_number);
493: arp_debug.debug('p_trx_date_l ' || p_trx_date_l);

Line 490: arp_debug.debug('p_remit_bank_branch_id ' || p_remit_bank_branch_id);

486: arp_debug.debug('p_exchnage_rate ' || p_exchange_rate);
487: arp_debug.debug('p_exchnage_rate_type ' || p_exchange_rate_type);
488: arp_debug.debug('p_media_reference ' || p_media_reference);
489: arp_debug.debug('p_remit_method_code ' || p_remit_method_code);
490: arp_debug.debug('p_remit_bank_branch_id ' || p_remit_bank_branch_id);
491: arp_debug.debug('p_remit_bank_account_id ' || p_remit_bank_account_id);
492: arp_debug.debug('p_remit_bank_deposit_number' || p_remit_bank_deposit_number);
493: arp_debug.debug('p_trx_date_l ' || p_trx_date_l);
494: arp_debug.debug('p_trx_date_h ' || p_trx_date_h);

Line 491: arp_debug.debug('p_remit_bank_account_id ' || p_remit_bank_account_id);

487: arp_debug.debug('p_exchnage_rate_type ' || p_exchange_rate_type);
488: arp_debug.debug('p_media_reference ' || p_media_reference);
489: arp_debug.debug('p_remit_method_code ' || p_remit_method_code);
490: arp_debug.debug('p_remit_bank_branch_id ' || p_remit_bank_branch_id);
491: arp_debug.debug('p_remit_bank_account_id ' || p_remit_bank_account_id);
492: arp_debug.debug('p_remit_bank_deposit_number' || p_remit_bank_deposit_number);
493: arp_debug.debug('p_trx_date_l ' || p_trx_date_l);
494: arp_debug.debug('p_trx_date_h ' || p_trx_date_h);
495: arp_debug.debug('p_due_date_l ' || p_due_date_l);

Line 492: arp_debug.debug('p_remit_bank_deposit_number' || p_remit_bank_deposit_number);

488: arp_debug.debug('p_media_reference ' || p_media_reference);
489: arp_debug.debug('p_remit_method_code ' || p_remit_method_code);
490: arp_debug.debug('p_remit_bank_branch_id ' || p_remit_bank_branch_id);
491: arp_debug.debug('p_remit_bank_account_id ' || p_remit_bank_account_id);
492: arp_debug.debug('p_remit_bank_deposit_number' || p_remit_bank_deposit_number);
493: arp_debug.debug('p_trx_date_l ' || p_trx_date_l);
494: arp_debug.debug('p_trx_date_h ' || p_trx_date_h);
495: arp_debug.debug('p_due_date_l ' || p_due_date_l);
496: arp_debug.debug('p_due_date_h ' || p_due_date_h);

Line 493: arp_debug.debug('p_trx_date_l ' || p_trx_date_l);

489: arp_debug.debug('p_remit_method_code ' || p_remit_method_code);
490: arp_debug.debug('p_remit_bank_branch_id ' || p_remit_bank_branch_id);
491: arp_debug.debug('p_remit_bank_account_id ' || p_remit_bank_account_id);
492: arp_debug.debug('p_remit_bank_deposit_number' || p_remit_bank_deposit_number);
493: arp_debug.debug('p_trx_date_l ' || p_trx_date_l);
494: arp_debug.debug('p_trx_date_h ' || p_trx_date_h);
495: arp_debug.debug('p_due_date_l ' || p_due_date_l);
496: arp_debug.debug('p_due_date_h ' || p_due_date_h);
497: arp_debug.debug('p_trx_num_l ' || p_trx_num_l);

Line 494: arp_debug.debug('p_trx_date_h ' || p_trx_date_h);

490: arp_debug.debug('p_remit_bank_branch_id ' || p_remit_bank_branch_id);
491: arp_debug.debug('p_remit_bank_account_id ' || p_remit_bank_account_id);
492: arp_debug.debug('p_remit_bank_deposit_number' || p_remit_bank_deposit_number);
493: arp_debug.debug('p_trx_date_l ' || p_trx_date_l);
494: arp_debug.debug('p_trx_date_h ' || p_trx_date_h);
495: arp_debug.debug('p_due_date_l ' || p_due_date_l);
496: arp_debug.debug('p_due_date_h ' || p_due_date_h);
497: arp_debug.debug('p_trx_num_l ' || p_trx_num_l);
498: arp_debug.debug('p_trx_num_h ' || p_trx_num_h);

Line 495: arp_debug.debug('p_due_date_l ' || p_due_date_l);

491: arp_debug.debug('p_remit_bank_account_id ' || p_remit_bank_account_id);
492: arp_debug.debug('p_remit_bank_deposit_number' || p_remit_bank_deposit_number);
493: arp_debug.debug('p_trx_date_l ' || p_trx_date_l);
494: arp_debug.debug('p_trx_date_h ' || p_trx_date_h);
495: arp_debug.debug('p_due_date_l ' || p_due_date_l);
496: arp_debug.debug('p_due_date_h ' || p_due_date_h);
497: arp_debug.debug('p_trx_num_l ' || p_trx_num_l);
498: arp_debug.debug('p_trx_num_h ' || p_trx_num_h);
499: arp_debug.debug('p_doc_num_l ' || p_doc_num_l);

Line 496: arp_debug.debug('p_due_date_h ' || p_due_date_h);

492: arp_debug.debug('p_remit_bank_deposit_number' || p_remit_bank_deposit_number);
493: arp_debug.debug('p_trx_date_l ' || p_trx_date_l);
494: arp_debug.debug('p_trx_date_h ' || p_trx_date_h);
495: arp_debug.debug('p_due_date_l ' || p_due_date_l);
496: arp_debug.debug('p_due_date_h ' || p_due_date_h);
497: arp_debug.debug('p_trx_num_l ' || p_trx_num_l);
498: arp_debug.debug('p_trx_num_h ' || p_trx_num_h);
499: arp_debug.debug('p_doc_num_l ' || p_doc_num_l);
500: arp_debug.debug('p_doc_num_h ' || p_doc_num_h);

Line 497: arp_debug.debug('p_trx_num_l ' || p_trx_num_l);

493: arp_debug.debug('p_trx_date_l ' || p_trx_date_l);
494: arp_debug.debug('p_trx_date_h ' || p_trx_date_h);
495: arp_debug.debug('p_due_date_l ' || p_due_date_l);
496: arp_debug.debug('p_due_date_h ' || p_due_date_h);
497: arp_debug.debug('p_trx_num_l ' || p_trx_num_l);
498: arp_debug.debug('p_trx_num_h ' || p_trx_num_h);
499: arp_debug.debug('p_doc_num_l ' || p_doc_num_l);
500: arp_debug.debug('p_doc_num_h ' || p_doc_num_h);
501: arp_debug.debug('p_customer_number_l ' || p_customer_number_l);

Line 498: arp_debug.debug('p_trx_num_h ' || p_trx_num_h);

494: arp_debug.debug('p_trx_date_h ' || p_trx_date_h);
495: arp_debug.debug('p_due_date_l ' || p_due_date_l);
496: arp_debug.debug('p_due_date_h ' || p_due_date_h);
497: arp_debug.debug('p_trx_num_l ' || p_trx_num_l);
498: arp_debug.debug('p_trx_num_h ' || p_trx_num_h);
499: arp_debug.debug('p_doc_num_l ' || p_doc_num_l);
500: arp_debug.debug('p_doc_num_h ' || p_doc_num_h);
501: arp_debug.debug('p_customer_number_l ' || p_customer_number_l);
502: arp_debug.debug('p_customer_number_h ' || p_customer_number_h);

Line 499: arp_debug.debug('p_doc_num_l ' || p_doc_num_l);

495: arp_debug.debug('p_due_date_l ' || p_due_date_l);
496: arp_debug.debug('p_due_date_h ' || p_due_date_h);
497: arp_debug.debug('p_trx_num_l ' || p_trx_num_l);
498: arp_debug.debug('p_trx_num_h ' || p_trx_num_h);
499: arp_debug.debug('p_doc_num_l ' || p_doc_num_l);
500: arp_debug.debug('p_doc_num_h ' || p_doc_num_h);
501: arp_debug.debug('p_customer_number_l ' || p_customer_number_l);
502: arp_debug.debug('p_customer_number_h ' || p_customer_number_h);
503: arp_debug.debug('p_customer_name_l ' || p_customer_name_l);

Line 500: arp_debug.debug('p_doc_num_h ' || p_doc_num_h);

496: arp_debug.debug('p_due_date_h ' || p_due_date_h);
497: arp_debug.debug('p_trx_num_l ' || p_trx_num_l);
498: arp_debug.debug('p_trx_num_h ' || p_trx_num_h);
499: arp_debug.debug('p_doc_num_l ' || p_doc_num_l);
500: arp_debug.debug('p_doc_num_h ' || p_doc_num_h);
501: arp_debug.debug('p_customer_number_l ' || p_customer_number_l);
502: arp_debug.debug('p_customer_number_h ' || p_customer_number_h);
503: arp_debug.debug('p_customer_name_l ' || p_customer_name_l);
504: arp_debug.debug('p_customer_name_h ' || p_customer_name_h);

Line 501: arp_debug.debug('p_customer_number_l ' || p_customer_number_l);

497: arp_debug.debug('p_trx_num_l ' || p_trx_num_l);
498: arp_debug.debug('p_trx_num_h ' || p_trx_num_h);
499: arp_debug.debug('p_doc_num_l ' || p_doc_num_l);
500: arp_debug.debug('p_doc_num_h ' || p_doc_num_h);
501: arp_debug.debug('p_customer_number_l ' || p_customer_number_l);
502: arp_debug.debug('p_customer_number_h ' || p_customer_number_h);
503: arp_debug.debug('p_customer_name_l ' || p_customer_name_l);
504: arp_debug.debug('p_customer_name_h ' || p_customer_name_h);
505: arp_debug.debug('p_customer_id ' || (p_customer_id));

Line 502: arp_debug.debug('p_customer_number_h ' || p_customer_number_h);

498: arp_debug.debug('p_trx_num_h ' || p_trx_num_h);
499: arp_debug.debug('p_doc_num_l ' || p_doc_num_l);
500: arp_debug.debug('p_doc_num_h ' || p_doc_num_h);
501: arp_debug.debug('p_customer_number_l ' || p_customer_number_l);
502: arp_debug.debug('p_customer_number_h ' || p_customer_number_h);
503: arp_debug.debug('p_customer_name_l ' || p_customer_name_l);
504: arp_debug.debug('p_customer_name_h ' || p_customer_name_h);
505: arp_debug.debug('p_customer_id ' || (p_customer_id));
506: arp_debug.debug('p_site_l ' || p_site_l);

Line 503: arp_debug.debug('p_customer_name_l ' || p_customer_name_l);

499: arp_debug.debug('p_doc_num_l ' || p_doc_num_l);
500: arp_debug.debug('p_doc_num_h ' || p_doc_num_h);
501: arp_debug.debug('p_customer_number_l ' || p_customer_number_l);
502: arp_debug.debug('p_customer_number_h ' || p_customer_number_h);
503: arp_debug.debug('p_customer_name_l ' || p_customer_name_l);
504: arp_debug.debug('p_customer_name_h ' || p_customer_name_h);
505: arp_debug.debug('p_customer_id ' || (p_customer_id));
506: arp_debug.debug('p_site_l ' || p_site_l);
507: arp_debug.debug('p_site_h ' || p_site_h);

Line 504: arp_debug.debug('p_customer_name_h ' || p_customer_name_h);

500: arp_debug.debug('p_doc_num_h ' || p_doc_num_h);
501: arp_debug.debug('p_customer_number_l ' || p_customer_number_l);
502: arp_debug.debug('p_customer_number_h ' || p_customer_number_h);
503: arp_debug.debug('p_customer_name_l ' || p_customer_name_l);
504: arp_debug.debug('p_customer_name_h ' || p_customer_name_h);
505: arp_debug.debug('p_customer_id ' || (p_customer_id));
506: arp_debug.debug('p_site_l ' || p_site_l);
507: arp_debug.debug('p_site_h ' || p_site_h);
508: arp_debug.debug('p_site_id ' || (p_site_id));

Line 505: arp_debug.debug('p_customer_id ' || (p_customer_id));

501: arp_debug.debug('p_customer_number_l ' || p_customer_number_l);
502: arp_debug.debug('p_customer_number_h ' || p_customer_number_h);
503: arp_debug.debug('p_customer_name_l ' || p_customer_name_l);
504: arp_debug.debug('p_customer_name_h ' || p_customer_name_h);
505: arp_debug.debug('p_customer_id ' || (p_customer_id));
506: arp_debug.debug('p_site_l ' || p_site_l);
507: arp_debug.debug('p_site_h ' || p_site_h);
508: arp_debug.debug('p_site_id ' || (p_site_id));
509: arp_debug.debug('p_remittance_total_from ' || p_remittance_total_from);

Line 506: arp_debug.debug('p_site_l ' || p_site_l);

502: arp_debug.debug('p_customer_number_h ' || p_customer_number_h);
503: arp_debug.debug('p_customer_name_l ' || p_customer_name_l);
504: arp_debug.debug('p_customer_name_h ' || p_customer_name_h);
505: arp_debug.debug('p_customer_id ' || (p_customer_id));
506: arp_debug.debug('p_site_l ' || p_site_l);
507: arp_debug.debug('p_site_h ' || p_site_h);
508: arp_debug.debug('p_site_id ' || (p_site_id));
509: arp_debug.debug('p_remittance_total_from ' || p_remittance_total_from);
510: arp_debug.debug('p_Remittance_total_to ' || p_Remittance_total_to);

Line 507: arp_debug.debug('p_site_h ' || p_site_h);

503: arp_debug.debug('p_customer_name_l ' || p_customer_name_l);
504: arp_debug.debug('p_customer_name_h ' || p_customer_name_h);
505: arp_debug.debug('p_customer_id ' || (p_customer_id));
506: arp_debug.debug('p_site_l ' || p_site_l);
507: arp_debug.debug('p_site_h ' || p_site_h);
508: arp_debug.debug('p_site_id ' || (p_site_id));
509: arp_debug.debug('p_remittance_total_from ' || p_remittance_total_from);
510: arp_debug.debug('p_Remittance_total_to ' || p_Remittance_total_to);
511: arp_debug.debug('p_billing_number_l ' || p_billing_number_l);

Line 508: arp_debug.debug('p_site_id ' || (p_site_id));

504: arp_debug.debug('p_customer_name_h ' || p_customer_name_h);
505: arp_debug.debug('p_customer_id ' || (p_customer_id));
506: arp_debug.debug('p_site_l ' || p_site_l);
507: arp_debug.debug('p_site_h ' || p_site_h);
508: arp_debug.debug('p_site_id ' || (p_site_id));
509: arp_debug.debug('p_remittance_total_from ' || p_remittance_total_from);
510: arp_debug.debug('p_Remittance_total_to ' || p_Remittance_total_to);
511: arp_debug.debug('p_billing_number_l ' || p_billing_number_l);
512: arp_debug.debug('p_billing_number_h ' || p_billing_number_h);

Line 509: arp_debug.debug('p_remittance_total_from ' || p_remittance_total_from);

505: arp_debug.debug('p_customer_id ' || (p_customer_id));
506: arp_debug.debug('p_site_l ' || p_site_l);
507: arp_debug.debug('p_site_h ' || p_site_h);
508: arp_debug.debug('p_site_id ' || (p_site_id));
509: arp_debug.debug('p_remittance_total_from ' || p_remittance_total_from);
510: arp_debug.debug('p_Remittance_total_to ' || p_Remittance_total_to);
511: arp_debug.debug('p_billing_number_l ' || p_billing_number_l);
512: arp_debug.debug('p_billing_number_h ' || p_billing_number_h);
513: arp_debug.debug('p_customer_bank_acc_num_l ' || p_customer_bank_acc_num_l);

Line 510: arp_debug.debug('p_Remittance_total_to ' || p_Remittance_total_to);

506: arp_debug.debug('p_site_l ' || p_site_l);
507: arp_debug.debug('p_site_h ' || p_site_h);
508: arp_debug.debug('p_site_id ' || (p_site_id));
509: arp_debug.debug('p_remittance_total_from ' || p_remittance_total_from);
510: arp_debug.debug('p_Remittance_total_to ' || p_Remittance_total_to);
511: arp_debug.debug('p_billing_number_l ' || p_billing_number_l);
512: arp_debug.debug('p_billing_number_h ' || p_billing_number_h);
513: arp_debug.debug('p_customer_bank_acc_num_l ' || p_customer_bank_acc_num_l);
514: arp_debug.debug('p_customer_bank_acc_num_h ' || p_customer_bank_acc_num_h);

Line 511: arp_debug.debug('p_billing_number_l ' || p_billing_number_l);

507: arp_debug.debug('p_site_h ' || p_site_h);
508: arp_debug.debug('p_site_id ' || (p_site_id));
509: arp_debug.debug('p_remittance_total_from ' || p_remittance_total_from);
510: arp_debug.debug('p_Remittance_total_to ' || p_Remittance_total_to);
511: arp_debug.debug('p_billing_number_l ' || p_billing_number_l);
512: arp_debug.debug('p_billing_number_h ' || p_billing_number_h);
513: arp_debug.debug('p_customer_bank_acc_num_l ' || p_customer_bank_acc_num_l);
514: arp_debug.debug('p_customer_bank_acc_num_h ' || p_customer_bank_acc_num_h);
515: END IF;

Line 512: arp_debug.debug('p_billing_number_h ' || p_billing_number_h);

508: arp_debug.debug('p_site_id ' || (p_site_id));
509: arp_debug.debug('p_remittance_total_from ' || p_remittance_total_from);
510: arp_debug.debug('p_Remittance_total_to ' || p_Remittance_total_to);
511: arp_debug.debug('p_billing_number_l ' || p_billing_number_l);
512: arp_debug.debug('p_billing_number_h ' || p_billing_number_h);
513: arp_debug.debug('p_customer_bank_acc_num_l ' || p_customer_bank_acc_num_l);
514: arp_debug.debug('p_customer_bank_acc_num_h ' || p_customer_bank_acc_num_h);
515: END IF;
516:

Line 513: arp_debug.debug('p_customer_bank_acc_num_l ' || p_customer_bank_acc_num_l);

509: arp_debug.debug('p_remittance_total_from ' || p_remittance_total_from);
510: arp_debug.debug('p_Remittance_total_to ' || p_Remittance_total_to);
511: arp_debug.debug('p_billing_number_l ' || p_billing_number_l);
512: arp_debug.debug('p_billing_number_h ' || p_billing_number_h);
513: arp_debug.debug('p_customer_bank_acc_num_l ' || p_customer_bank_acc_num_l);
514: arp_debug.debug('p_customer_bank_acc_num_h ' || p_customer_bank_acc_num_h);
515: END IF;
516:
517: IF PG_DEBUG in ('Y','C') THEN

Line 514: arp_debug.debug('p_customer_bank_acc_num_h ' || p_customer_bank_acc_num_h);

510: arp_debug.debug('p_Remittance_total_to ' || p_Remittance_total_to);
511: arp_debug.debug('p_billing_number_l ' || p_billing_number_l);
512: arp_debug.debug('p_billing_number_h ' || p_billing_number_h);
513: arp_debug.debug('p_customer_bank_acc_num_l ' || p_customer_bank_acc_num_l);
514: arp_debug.debug('p_customer_bank_acc_num_h ' || p_customer_bank_acc_num_h);
515: END IF;
516:
517: IF PG_DEBUG in ('Y','C') THEN
518: arp_debug.debug( 'converting the parameters');

Line 518: arp_debug.debug( 'converting the parameters');

514: arp_debug.debug('p_customer_bank_acc_num_h ' || p_customer_bank_acc_num_h);
515: END IF;
516:
517: IF PG_DEBUG in ('Y','C') THEN
518: arp_debug.debug( 'converting the parameters');
519: END IF;
520:
521: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
522: l_batch_date := fnd_date.canonical_to_date(p_batch_date);

Line 553: arp_debug.debug('pg_request_id ' || pg_request_id);

549: pg_program_application_id := arp_standard.application_id ;
550: pg_program_id := arp_standard.profile.program_id;
551:
552: IF PG_DEBUG in ('Y', 'C') THEN
553: arp_debug.debug('pg_request_id ' || pg_request_id);
554: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);
555: arp_debug.debug('pg_created_by ' || pg_created_by);
556: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);
557: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);

Line 554: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);

550: pg_program_id := arp_standard.profile.program_id;
551:
552: IF PG_DEBUG in ('Y', 'C') THEN
553: arp_debug.debug('pg_request_id ' || pg_request_id);
554: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);
555: arp_debug.debug('pg_created_by ' || pg_created_by);
556: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);
557: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);
558: arp_debug.debug('pg_program_id ' || pg_program_id);

Line 555: arp_debug.debug('pg_created_by ' || pg_created_by);

551:
552: IF PG_DEBUG in ('Y', 'C') THEN
553: arp_debug.debug('pg_request_id ' || pg_request_id);
554: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);
555: arp_debug.debug('pg_created_by ' || pg_created_by);
556: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);
557: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);
558: arp_debug.debug('pg_program_id ' || pg_program_id);
559: END IF;

Line 556: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);

552: IF PG_DEBUG in ('Y', 'C') THEN
553: arp_debug.debug('pg_request_id ' || pg_request_id);
554: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);
555: arp_debug.debug('pg_created_by ' || pg_created_by);
556: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);
557: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);
558: arp_debug.debug('pg_program_id ' || pg_program_id);
559: END IF;
560:

Line 557: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);

553: arp_debug.debug('pg_request_id ' || pg_request_id);
554: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);
555: arp_debug.debug('pg_created_by ' || pg_created_by);
556: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);
557: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);
558: arp_debug.debug('pg_program_id ' || pg_program_id);
559: END IF;
560:
561: --fetch the max commit size set for receipts

Line 558: arp_debug.debug('pg_program_id ' || pg_program_id);

554: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);
555: arp_debug.debug('pg_created_by ' || pg_created_by);
556: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);
557: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);
558: arp_debug.debug('pg_program_id ' || pg_program_id);
559: END IF;
560:
561: --fetch the max commit size set for receipts
562: SELECT CASE WHEN (NVL(auto_rec_receipts_per_commit,0) <= 0) THEN 1000

Line 569: arp_debug.debug('p_batch_id is null,Calling insert_batch..');

565: FROM ar_system_parameters;
566:
567: IF p_batch_id is NULL THEN
568: IF PG_DEBUG in ('Y','C') THEN
569: arp_debug.debug('p_batch_id is null,Calling insert_batch..');
570: END IF;
571:
572: /* CALL TO INSERT BATCH FROM MAIN */
573: insert_batch(

Line 589: arp_debug.debug('Batch got created batch_id:'||o_batch_id);

585: o_batch_id
586: );
587:
588: IF PG_DEBUG in ('Y','C') THEN
589: arp_debug.debug('Batch got created batch_id:'||o_batch_id);
590: END IF;
591:
592: ELSE
593: o_batch_id := p_batch_id;

Line 596: arp_debug.debug('Batch id passed,fetching details of batch_id:'|| p_batch_id);

592: ELSE
593: o_batch_id := p_batch_id;
594:
595: IF PG_DEBUG in ('Y','C') THEN
596: arp_debug.debug('Batch id passed,fetching details of batch_id:'|| p_batch_id);
597: END IF;
598:
599: select batch_date ,
600: gl_date ,

Line 613: arp_debug.debug('batch_date '|| l_batch_date);

609: from AR_BATCHES
610: where batch_id = p_batch_id;
611:
612: IF PG_DEBUG in ('Y','C') THEN
613: arp_debug.debug('batch_date '|| l_batch_date);
614: arp_debug.debug('gl_date '|| l_gl_date);
615: arp_debug.debug('currency_code '|| l_currency_code);
616: arp_debug.debug('receipt_method_id '|| l_receipt_method_id);
617: arp_debug.debug('l_batch_app_status '|| l_batch_app_status);

Line 614: arp_debug.debug('gl_date '|| l_gl_date);

610: where batch_id = p_batch_id;
611:
612: IF PG_DEBUG in ('Y','C') THEN
613: arp_debug.debug('batch_date '|| l_batch_date);
614: arp_debug.debug('gl_date '|| l_gl_date);
615: arp_debug.debug('currency_code '|| l_currency_code);
616: arp_debug.debug('receipt_method_id '|| l_receipt_method_id);
617: arp_debug.debug('l_batch_app_status '|| l_batch_app_status);
618: END IF;

Line 615: arp_debug.debug('currency_code '|| l_currency_code);

611:
612: IF PG_DEBUG in ('Y','C') THEN
613: arp_debug.debug('batch_date '|| l_batch_date);
614: arp_debug.debug('gl_date '|| l_gl_date);
615: arp_debug.debug('currency_code '|| l_currency_code);
616: arp_debug.debug('receipt_method_id '|| l_receipt_method_id);
617: arp_debug.debug('l_batch_app_status '|| l_batch_app_status);
618: END IF;
619: END IF;

Line 616: arp_debug.debug('receipt_method_id '|| l_receipt_method_id);

612: IF PG_DEBUG in ('Y','C') THEN
613: arp_debug.debug('batch_date '|| l_batch_date);
614: arp_debug.debug('gl_date '|| l_gl_date);
615: arp_debug.debug('currency_code '|| l_currency_code);
616: arp_debug.debug('receipt_method_id '|| l_receipt_method_id);
617: arp_debug.debug('l_batch_app_status '|| l_batch_app_status);
618: END IF;
619: END IF;
620:

Line 617: arp_debug.debug('l_batch_app_status '|| l_batch_app_status);

613: arp_debug.debug('batch_date '|| l_batch_date);
614: arp_debug.debug('gl_date '|| l_gl_date);
615: arp_debug.debug('currency_code '|| l_currency_code);
616: arp_debug.debug('receipt_method_id '|| l_receipt_method_id);
617: arp_debug.debug('l_batch_app_status '|| l_batch_app_status);
618: END IF;
619: END IF;
620:
621: g_batch_id := o_batch_id;

Line 624: arp_debug.debug( 'o_batch_id is null This is an error condition');

620:
621: g_batch_id := o_batch_id;
622:
623: IF o_batch_id is null THEN
624: arp_debug.debug( 'o_batch_id is null This is an error condition');
625:
626: insert_exceptions(
627: p_batch_id =>-333,
628: p_request_id =>pg_request_id,

Line 633: arp_debug.debug ( 'calling the report- batch_id ' || -333 );

629: p_exception_code => 'NO_BATCH',
630: p_additional_message => 'error during insert batch' );
631:
632: IF PG_DEBUG in ('Y','C') THEN
633: arp_debug.debug ( 'calling the report- batch_id ' || -333 );
634: arp_debug.debug ( 'calling the report ' || pg_request_id);
635: END IF;
636:
637: submit_report ( p_batch_id => o_batch_id,

Line 634: arp_debug.debug ( 'calling the report ' || pg_request_id);

630: p_additional_message => 'error during insert batch' );
631:
632: IF PG_DEBUG in ('Y','C') THEN
633: arp_debug.debug ( 'calling the report- batch_id ' || -333 );
634: arp_debug.debug ( 'calling the report ' || pg_request_id);
635: END IF;
636:
637: submit_report ( p_batch_id => o_batch_id,
638: p_request_id => pg_request_id);

Line 676: arp_debug.debug('l_approve_only_flag :' || l_approve_only_flag);

672: p_approve_flag = 'Y' ) AND
673: G_ERROR = 'N' THEN
674:
675: IF PG_DEBUG in ('Y','C') THEN
676: arp_debug.debug('l_approve_only_flag :' || l_approve_only_flag);
677: arp_debug.debug('selecting the data for batch_id :' || to_char(o_batch_id));
678: END IF;
679:
680: /** If the worker count is other than zero,master program populates the interim

Line 677: arp_debug.debug('selecting the data for batch_id :' || to_char(o_batch_id));

673: G_ERROR = 'N' THEN
674:
675: IF PG_DEBUG in ('Y','C') THEN
676: arp_debug.debug('l_approve_only_flag :' || l_approve_only_flag);
677: arp_debug.debug('selecting the data for batch_id :' || to_char(o_batch_id));
678: END IF;
679:
680: /** If the worker count is other than zero,master program populates the interim
681: * table with the selected data.*/

Line 684: arp_debug.debug ( ' l_total_workers :'||l_total_workers);

680: /** If the worker count is other than zero,master program populates the interim
681: * table with the selected data.*/
682: IF l_total_workers = 0 THEN
683: IF PG_DEBUG in ('Y', 'C') THEN
684: arp_debug.debug ( ' l_total_workers :'||l_total_workers);
685: arp_debug.debug ( ' Calling select_valid_invoices..');
686: END IF;
687:
688: select_valid_invoices

Line 685: arp_debug.debug ( ' Calling select_valid_invoices..');

681: * table with the selected data.*/
682: IF l_total_workers = 0 THEN
683: IF PG_DEBUG in ('Y', 'C') THEN
684: arp_debug.debug ( ' l_total_workers :'||l_total_workers);
685: arp_debug.debug ( ' Calling select_valid_invoices..');
686: END IF;
687:
688: select_valid_invoices
689: ( p_trx_date_l =>fnd_date.canonical_to_date(p_trx_date_l),

Line 707: arp_debug.debug ( ' Returned from select_valid_invoices..');

703: p_receipt_method_id => l_receipt_method_id,
704: p_total_workers => 1 );
705:
706: IF PG_DEBUG in ('Y', 'C') THEN
707: arp_debug.debug ( ' Returned from select_valid_invoices..');
708: END IF;
709: END IF;
710:
711: --Populating the data allocated to current worker from interim table to GT

Line 749: arp_debug.debug ( 'NO of rows inserted into ar_receipts_gt :'|| to_char(SQL%ROWCOUNT));

745: l_current_worker_number)
746: and a.batch_id = o_batch_id;
747:
748: IF PG_DEBUG in ('Y', 'C') THEN
749: arp_debug.debug ( 'NO of rows inserted into ar_receipts_gt :'|| to_char(SQL%ROWCOUNT));
750: END IF;
751:
752: IF l_total_workers = 0 THEN
753: IF p_approve_flag = 'Y' THEN

Line 767: arp_debug.debug('Batch status set to COMPLETED_CREATION');

763: --Commit the creation process
764: COMMIT;
765:
766: IF PG_DEBUG in ('Y', 'C') THEN
767: arp_debug.debug('Batch status set to COMPLETED_CREATION');
768: arp_debug.debug('Batches updated '||SQL%ROWCOUNT);
769: END IF;
770: END IF;
771:

Line 768: arp_debug.debug('Batches updated '||SQL%ROWCOUNT);

764: COMMIT;
765:
766: IF PG_DEBUG in ('Y', 'C') THEN
767: arp_debug.debug('Batch status set to COMPLETED_CREATION');
768: arp_debug.debug('Batches updated '||SQL%ROWCOUNT);
769: END IF;
770: END IF;
771:
772: END IF;

Line 777: arp_debug.debug('Inside approve section ');

773:
774: --Approval process
775: IF p_approve_flag = 'Y' AND G_ERROR = 'N' THEN
776: IF PG_DEBUG in ('Y','C') THEN
777: arp_debug.debug('Inside approve section ');
778: END IF;
779:
780: IF PG_DEBUG in ('Y', 'C') THEN
781: arp_debug.debug('CALLING process_selected_receipts()');

Line 781: arp_debug.debug('CALLING process_selected_receipts()');

777: arp_debug.debug('Inside approve section ');
778: END IF;
779:
780: IF PG_DEBUG in ('Y', 'C') THEN
781: arp_debug.debug('CALLING process_selected_receipts()');
782: END IF;
783:
784: process_selected_receipts( p_receipt_method_id => l_receipt_method_id,
785: p_batch_id => o_batch_id,

Line 796: arp_debug.debug('Batch status set to COMPLETED_APPROVAL ');

792: set batch_applied_status = 'COMPLETED_APPROVAL'
793: where batch_id = o_batch_id;
794:
795: IF PG_DEBUG in ('Y', 'C') THEN
796: arp_debug.debug('Batch status set to COMPLETED_APPROVAL ');
797: arp_debug.debug('Batches updated '||SQL%ROWCOUNT);
798: END IF;
799: END IF;
800: END IF;

Line 797: arp_debug.debug('Batches updated '||SQL%ROWCOUNT);

793: where batch_id = o_batch_id;
794:
795: IF PG_DEBUG in ('Y', 'C') THEN
796: arp_debug.debug('Batch status set to COMPLETED_APPROVAL ');
797: arp_debug.debug('Batches updated '||SQL%ROWCOUNT);
798: END IF;
799: END IF;
800: END IF;
801:

Line 816: arp_debug.debug('Releasing lock - ' || l_batch_lock_msg);

812: ARP_RW_BATCHES_PKG.release_lock(o_batch_id ,l_batch_lock_msg);
813:
814: IF PG_DEBUG in ('Y','C')
815: THEN
816: arp_debug.debug('Releasing lock - ' || l_batch_lock_msg);
817: END IF;
818:
819: IF l_format_flag = 'Y' THEN
820: arp_debug.debug('Submitting format report- batch_id :' || o_batch_id);

Line 820: arp_debug.debug('Submitting format report- batch_id :' || o_batch_id);

816: arp_debug.debug('Releasing lock - ' || l_batch_lock_msg);
817: END IF;
818:
819: IF l_format_flag = 'Y' THEN
820: arp_debug.debug('Submitting format report- batch_id :' || o_batch_id);
821: submit_format ( p_batch_id =>o_batch_id);
822: END IF;
823:
824: /* SUBMIT THE FINAL REPORT FULL WITH ERRORS AND EXECUTION */

Line 826: arp_debug.debug ( 'Submitting report- batch_id :' || o_batch_id);

822: END IF;
823:
824: /* SUBMIT THE FINAL REPORT FULL WITH ERRORS AND EXECUTION */
825: IF PG_DEBUG in ('Y', 'C') THEN
826: arp_debug.debug ( 'Submitting report- batch_id :' || o_batch_id);
827: arp_debug.debug ( 'request id : ' || pg_request_id);
828: END IF;
829:
830: submit_report ( p_batch_id => o_batch_id,

Line 827: arp_debug.debug ( 'request id : ' || pg_request_id);

823:
824: /* SUBMIT THE FINAL REPORT FULL WITH ERRORS AND EXECUTION */
825: IF PG_DEBUG in ('Y', 'C') THEN
826: arp_debug.debug ( 'Submitting report- batch_id :' || o_batch_id);
827: arp_debug.debug ( 'request id : ' || pg_request_id);
828: END IF;
829:
830: submit_report ( p_batch_id => o_batch_id,
831: p_request_id => pg_request_id);

Line 849: arp_debug.debug('Calling ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover');

845: END;
846:
847: IF nvl(l_instrument_type,'XXXXXX') = 'CREDITCARD' AND
848: nvl(p_approve_flag,'N') = 'Y' THEN
849: arp_debug.debug('Calling ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover');
850: ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover(pg_request_id,'CREATION');
851: END IF;
852: /* Bug 7639165 - Changes End. */
853:

Line 855: arp_debug.debug ( 'Cleaning interim table Rows deleted:'|| SQL%ROWCOUNT);

851: END IF;
852: /* Bug 7639165 - Changes End. */
853:
854: IF PG_DEBUG in ('Y', 'C') THEN
855: arp_debug.debug ( 'Cleaning interim table Rows deleted:'|| SQL%ROWCOUNT);
856: END IF;
857: END IF;
858:
859: arp_debug.debug (' FINALLY COMMITING WORK ');

Line 859: arp_debug.debug (' FINALLY COMMITING WORK ');

855: arp_debug.debug ( 'Cleaning interim table Rows deleted:'|| SQL%ROWCOUNT);
856: END IF;
857: END IF;
858:
859: arp_debug.debug (' FINALLY COMMITING WORK ');
860: COMMIT;
861:
862: arp_debug.debug('get_parameters()-');
863:

Line 862: arp_debug.debug('get_parameters()-');

858:
859: arp_debug.debug (' FINALLY COMMITING WORK ');
860: COMMIT;
861:
862: arp_debug.debug('get_parameters()-');
863:
864: IF G_ERROR = 'Y' THEN
865: P_RETCODE := 1;
866: END IF;

Line 875: arp_debug.debug('Unable to set WARNING return status');

871: l_error_message := FND_MESSAGE.GET_STRING('AR','AR_UNABLE_LOCK_BATCH');
872:
873: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', l_error_message) = FALSE)
874: THEN
875: arp_debug.debug('Unable to set WARNING return status');
876: END IF;
877:
878: fnd_file.put_line( FND_FILE.LOG,
879: 'Not able to lock the batch record, '||

Line 882: arp_debug.debug('Exception : Not able to lock the batch record,seems record is '||

878: fnd_file.put_line( FND_FILE.LOG,
879: 'Not able to lock the batch record, '||
880: 'Please try submitting the request again..');
881:
882: arp_debug.debug('Exception : Not able to lock the batch record,seems record is '||
883: 'already locked by other session ');
884: arp_debug.debug(' batch_id = ' || o_batch_id );
885: arp_debug.debug(' message: ' || l_batch_lock_msg);
886:

Line 884: arp_debug.debug(' batch_id = ' || o_batch_id );

880: 'Please try submitting the request again..');
881:
882: arp_debug.debug('Exception : Not able to lock the batch record,seems record is '||
883: 'already locked by other session ');
884: arp_debug.debug(' batch_id = ' || o_batch_id );
885: arp_debug.debug(' message: ' || l_batch_lock_msg);
886:
887: WHEN others THEN
888: --incase of any exception thrown,cleanup the interim table as the next run will

Line 885: arp_debug.debug(' message: ' || l_batch_lock_msg);

881:
882: arp_debug.debug('Exception : Not able to lock the batch record,seems record is '||
883: 'already locked by other session ');
884: arp_debug.debug(' batch_id = ' || o_batch_id );
885: arp_debug.debug(' message: ' || l_batch_lock_msg);
886:
887: WHEN others THEN
888: --incase of any exception thrown,cleanup the interim table as the next run will
889: --anyway repopulate the needed data

Line 903: arp_debug.debug('Releasing lock - ' || l_batch_lock_msg);

899: l_batch_lock_flag := ARP_RW_BATCHES_PKG.release_lock(o_batch_id ,l_batch_lock_msg);
900:
901: IF PG_DEBUG in ('Y','C')
902: THEN
903: arp_debug.debug('Releasing lock - ' || l_batch_lock_msg);
904: END IF;
905: END IF;
906: END IF;
907:

Line 909: arp_debug.debug('Exception : get_parameters() '|| SQLERRM);

905: END IF;
906: END IF;
907:
908: IF PG_DEBUG in ('Y', 'C') THEN
909: arp_debug.debug('Exception : get_parameters() '|| SQLERRM);
910: END IF;
911: IF G_ERROR = 'Y' THEN
912: P_RETCODE := 1;
913: END IF;

Line 1026: arp_debug.debug('submit_subrequest()+');

1022: PROCEDURE submit_subrequest (p_worker_number IN NUMBER,
1023: p_org_id IN NUMBER) IS
1024: l_request_id NUMBER;
1025: BEGIN
1026: arp_debug.debug('submit_subrequest()+');
1027:
1028: FND_REQUEST.SET_ORG_ID(p_org_id);
1029:
1030: l_request_id := FND_REQUEST.submit_request( 'AR', 'AR_AUTORECAPI',

Line 1080: arp_debug.debug('can not start for worker_id: ' ||p_worker_number );

1076: p_worker_number,
1077: p_total_workers );
1078:
1079: IF (pg_request_id = 0) THEN
1080: arp_debug.debug('can not start for worker_id: ' ||p_worker_number );
1081: P_ERRBUF := fnd_Message.get;
1082: P_RETCODE := 2;
1083: return;
1084: ELSE

Line 1086: arp_debug.debug('child request id: ' ||l_request_id || ' started for worker_id: ' ||p_worker_number );

1082: P_RETCODE := 2;
1083: return;
1084: ELSE
1085: commit;
1086: arp_debug.debug('child request id: ' ||l_request_id || ' started for worker_id: ' ||p_worker_number );
1087: END IF;
1088:
1089: l_req_status_tab(p_worker_number).request_id := l_request_id;
1090: arp_debug.debug('submit_subrequest()-');

Line 1090: arp_debug.debug('submit_subrequest()-');

1086: arp_debug.debug('child request id: ' ||l_request_id || ' started for worker_id: ' ||p_worker_number );
1087: END IF;
1088:
1089: l_req_status_tab(p_worker_number).request_id := l_request_id;
1090: arp_debug.debug('submit_subrequest()-');
1091:
1092: END submit_subrequest;
1093:
1094: BEGIN

Line 1097: arp_debug.debug('ar_autorec_api.submit_autorec_parallel()+');

1093:
1094: BEGIN
1095: fnd_file.put_line( FND_FILE.LOG, 'submit_autorec_parallel()+');
1096: IF PG_DEBUG in ('Y', 'C') THEN
1097: arp_debug.debug('ar_autorec_api.submit_autorec_parallel()+');
1098: END IF;
1099:
1100: l_gl_date := fnd_date.canonical_to_date(p_batch_gl_date);
1101: l_batch_date := fnd_date.canonical_to_date(p_batch_date);

Line 1118: arp_debug.debug('pg_request_id ' || pg_request_id);

1114: pg_program_application_id := arp_standard.application_id ;
1115: pg_program_id := arp_standard.profile.program_id;
1116:
1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_debug.debug('pg_request_id ' || pg_request_id);
1119: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);
1120: arp_debug.debug('pg_created_by ' || pg_created_by);
1121: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);
1122: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);

Line 1119: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);

1115: pg_program_id := arp_standard.profile.program_id;
1116:
1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_debug.debug('pg_request_id ' || pg_request_id);
1119: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);
1120: arp_debug.debug('pg_created_by ' || pg_created_by);
1121: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);
1122: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);
1123: arp_debug.debug('pg_program_id ' || pg_program_id);

Line 1120: arp_debug.debug('pg_created_by ' || pg_created_by);

1116:
1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_debug.debug('pg_request_id ' || pg_request_id);
1119: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);
1120: arp_debug.debug('pg_created_by ' || pg_created_by);
1121: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);
1122: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);
1123: arp_debug.debug('pg_program_id ' || pg_program_id);
1124: arp_debug.debug('l_gl_date ' ||l_gl_date);

Line 1121: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);

1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_debug.debug('pg_request_id ' || pg_request_id);
1119: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);
1120: arp_debug.debug('pg_created_by ' || pg_created_by);
1121: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);
1122: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);
1123: arp_debug.debug('pg_program_id ' || pg_program_id);
1124: arp_debug.debug('l_gl_date ' ||l_gl_date);
1125: arp_debug.debug('l_batch_date ' ||l_batch_date);

Line 1122: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);

1118: arp_debug.debug('pg_request_id ' || pg_request_id);
1119: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);
1120: arp_debug.debug('pg_created_by ' || pg_created_by);
1121: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);
1122: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);
1123: arp_debug.debug('pg_program_id ' || pg_program_id);
1124: arp_debug.debug('l_gl_date ' ||l_gl_date);
1125: arp_debug.debug('l_batch_date ' ||l_batch_date);
1126: arp_debug.debug('l_receipt_class_id ' ||l_receipt_class_id);

Line 1123: arp_debug.debug('pg_program_id ' || pg_program_id);

1119: arp_debug.debug('pg_last_updated_by ' || pg_last_updated_by);
1120: arp_debug.debug('pg_created_by ' || pg_created_by);
1121: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);
1122: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);
1123: arp_debug.debug('pg_program_id ' || pg_program_id);
1124: arp_debug.debug('l_gl_date ' ||l_gl_date);
1125: arp_debug.debug('l_batch_date ' ||l_batch_date);
1126: arp_debug.debug('l_receipt_class_id ' ||l_receipt_class_id);
1127: arp_debug.debug('l_receipt_method_id ' ||l_receipt_method_id);

Line 1124: arp_debug.debug('l_gl_date ' ||l_gl_date);

1120: arp_debug.debug('pg_created_by ' || pg_created_by);
1121: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);
1122: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);
1123: arp_debug.debug('pg_program_id ' || pg_program_id);
1124: arp_debug.debug('l_gl_date ' ||l_gl_date);
1125: arp_debug.debug('l_batch_date ' ||l_batch_date);
1126: arp_debug.debug('l_receipt_class_id ' ||l_receipt_class_id);
1127: arp_debug.debug('l_receipt_method_id ' ||l_receipt_method_id);
1128: arp_debug.debug('l_currency_code ' ||l_currency_code);

Line 1125: arp_debug.debug('l_batch_date ' ||l_batch_date);

1121: arp_debug.debug('pg_last_update_login ' || pg_last_update_login);
1122: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);
1123: arp_debug.debug('pg_program_id ' || pg_program_id);
1124: arp_debug.debug('l_gl_date ' ||l_gl_date);
1125: arp_debug.debug('l_batch_date ' ||l_batch_date);
1126: arp_debug.debug('l_receipt_class_id ' ||l_receipt_class_id);
1127: arp_debug.debug('l_receipt_method_id ' ||l_receipt_method_id);
1128: arp_debug.debug('l_currency_code ' ||l_currency_code);
1129: arp_debug.debug('l_create_flag ' ||l_create_flag);

Line 1126: arp_debug.debug('l_receipt_class_id ' ||l_receipt_class_id);

1122: arp_debug.debug('pg_program_application_id ' || pg_program_application_id);
1123: arp_debug.debug('pg_program_id ' || pg_program_id);
1124: arp_debug.debug('l_gl_date ' ||l_gl_date);
1125: arp_debug.debug('l_batch_date ' ||l_batch_date);
1126: arp_debug.debug('l_receipt_class_id ' ||l_receipt_class_id);
1127: arp_debug.debug('l_receipt_method_id ' ||l_receipt_method_id);
1128: arp_debug.debug('l_currency_code ' ||l_currency_code);
1129: arp_debug.debug('l_create_flag ' ||l_create_flag);
1130: arp_debug.debug('l_approve_flag ' ||l_approve_flag);

Line 1127: arp_debug.debug('l_receipt_method_id ' ||l_receipt_method_id);

1123: arp_debug.debug('pg_program_id ' || pg_program_id);
1124: arp_debug.debug('l_gl_date ' ||l_gl_date);
1125: arp_debug.debug('l_batch_date ' ||l_batch_date);
1126: arp_debug.debug('l_receipt_class_id ' ||l_receipt_class_id);
1127: arp_debug.debug('l_receipt_method_id ' ||l_receipt_method_id);
1128: arp_debug.debug('l_currency_code ' ||l_currency_code);
1129: arp_debug.debug('l_create_flag ' ||l_create_flag);
1130: arp_debug.debug('l_approve_flag ' ||l_approve_flag);
1131: arp_debug.debug('l_format_flag ' ||l_format_flag);

Line 1128: arp_debug.debug('l_currency_code ' ||l_currency_code);

1124: arp_debug.debug('l_gl_date ' ||l_gl_date);
1125: arp_debug.debug('l_batch_date ' ||l_batch_date);
1126: arp_debug.debug('l_receipt_class_id ' ||l_receipt_class_id);
1127: arp_debug.debug('l_receipt_method_id ' ||l_receipt_method_id);
1128: arp_debug.debug('l_currency_code ' ||l_currency_code);
1129: arp_debug.debug('l_create_flag ' ||l_create_flag);
1130: arp_debug.debug('l_approve_flag ' ||l_approve_flag);
1131: arp_debug.debug('l_format_flag ' ||l_format_flag);
1132: arp_debug.debug('p_batch_id ' ||p_batch_id);

Line 1129: arp_debug.debug('l_create_flag ' ||l_create_flag);

1125: arp_debug.debug('l_batch_date ' ||l_batch_date);
1126: arp_debug.debug('l_receipt_class_id ' ||l_receipt_class_id);
1127: arp_debug.debug('l_receipt_method_id ' ||l_receipt_method_id);
1128: arp_debug.debug('l_currency_code ' ||l_currency_code);
1129: arp_debug.debug('l_create_flag ' ||l_create_flag);
1130: arp_debug.debug('l_approve_flag ' ||l_approve_flag);
1131: arp_debug.debug('l_format_flag ' ||l_format_flag);
1132: arp_debug.debug('p_batch_id ' ||p_batch_id);
1133: END IF;

Line 1130: arp_debug.debug('l_approve_flag ' ||l_approve_flag);

1126: arp_debug.debug('l_receipt_class_id ' ||l_receipt_class_id);
1127: arp_debug.debug('l_receipt_method_id ' ||l_receipt_method_id);
1128: arp_debug.debug('l_currency_code ' ||l_currency_code);
1129: arp_debug.debug('l_create_flag ' ||l_create_flag);
1130: arp_debug.debug('l_approve_flag ' ||l_approve_flag);
1131: arp_debug.debug('l_format_flag ' ||l_format_flag);
1132: arp_debug.debug('p_batch_id ' ||p_batch_id);
1133: END IF;
1134:

Line 1131: arp_debug.debug('l_format_flag ' ||l_format_flag);

1127: arp_debug.debug('l_receipt_method_id ' ||l_receipt_method_id);
1128: arp_debug.debug('l_currency_code ' ||l_currency_code);
1129: arp_debug.debug('l_create_flag ' ||l_create_flag);
1130: arp_debug.debug('l_approve_flag ' ||l_approve_flag);
1131: arp_debug.debug('l_format_flag ' ||l_format_flag);
1132: arp_debug.debug('p_batch_id ' ||p_batch_id);
1133: END IF;
1134:
1135: IF p_batch_id IS NOT NULL THEN

Line 1132: arp_debug.debug('p_batch_id ' ||p_batch_id);

1128: arp_debug.debug('l_currency_code ' ||l_currency_code);
1129: arp_debug.debug('l_create_flag ' ||l_create_flag);
1130: arp_debug.debug('l_approve_flag ' ||l_approve_flag);
1131: arp_debug.debug('l_format_flag ' ||l_format_flag);
1132: arp_debug.debug('p_batch_id ' ||p_batch_id);
1133: END IF;
1134:
1135: IF p_batch_id IS NOT NULL THEN
1136: l_approve_only_flag := 'A';

Line 1164: arp_debug.debug( 'This is an error condition');

1160: END IF;
1161:
1162: --Error condition
1163: IF o_batch_id IS NULL THEN
1164: arp_debug.debug( 'This is an error condition');
1165: insert_exceptions( p_batch_id => -333,
1166: p_request_id =>pg_request_id,
1167: p_exception_code => 'NO_BATCH',
1168: p_additional_message => 'error during insert batch' );

Line 1170: arp_debug.debug ( 'calling the report- batch_id ' || -333 );

1166: p_request_id =>pg_request_id,
1167: p_exception_code => 'NO_BATCH',
1168: p_additional_message => 'error during insert batch' );
1169:
1170: arp_debug.debug ( 'calling the report- batch_id ' || -333 );
1171: arp_debug.debug ( 'calling the report ' || pg_request_id);
1172:
1173: submit_report ( p_batch_id => o_batch_id,
1174: p_request_id => pg_request_id);

Line 1171: arp_debug.debug ( 'calling the report ' || pg_request_id);

1167: p_exception_code => 'NO_BATCH',
1168: p_additional_message => 'error during insert batch' );
1169:
1170: arp_debug.debug ( 'calling the report- batch_id ' || -333 );
1171: arp_debug.debug ( 'calling the report ' || pg_request_id);
1172:
1173: submit_report ( p_batch_id => o_batch_id,
1174: p_request_id => pg_request_id);
1175: RETURN;

Line 1203: arp_debug.debug('l_batch_app_status :'||l_batch_app_status);

1199: NULL;
1200: END;
1201:
1202: IF PG_DEBUG in ('Y', 'C') THEN
1203: arp_debug.debug('l_batch_app_status :'||l_batch_app_status);
1204: END IF;
1205:
1206: IF l_batch_app_status = 'STARTED_APPROVAL' THEN
1207: process_incomplete_receipts( o_batch_id );

Line 1251: arp_debug.debug ( 'The Master program waits for child processes');

1247: fnd_file.put_line(FND_FILE.LOG,'worker # : ' || l_worker_number );
1248: submit_subrequest (l_worker_number,l_org_id);
1249: END LOOP;
1250:
1251: arp_debug.debug ( 'The Master program waits for child processes');
1252:
1253: P_RETCODE := 0;
1254:
1255: -- Wait for the completion of the submitted requests

Line 1269: arp_debug.debug('Worker # '|| i||' has a phase '||l_req_status_tab(i).dev_phase);

1265: message =>l_req_status_tab(i).message);
1266:
1267: IF l_req_status_tab(i).dev_phase <> 'COMPLETE' THEN
1268: P_RETCODE := 1;
1269: arp_debug.debug('Worker # '|| i||' has a phase '||l_req_status_tab(i).dev_phase);
1270:
1271: ELSIF l_req_status_tab(i).dev_phase = 'COMPLETE'
1272: AND l_req_status_tab(i).dev_status <> 'NORMAL' THEN
1273: P_RETCODE := 1;

Line 1274: arp_debug.debug('Worker # '|| i||' completed with status '||l_req_status_tab(i).dev_status);

1270:
1271: ELSIF l_req_status_tab(i).dev_phase = 'COMPLETE'
1272: AND l_req_status_tab(i).dev_status <> 'NORMAL' THEN
1273: P_RETCODE := 1;
1274: arp_debug.debug('Worker # '|| i||' completed with status '||l_req_status_tab(i).dev_status);
1275: ELSE
1276: arp_debug.debug('Worker # '|| i||' completed successfully');
1277: END IF;
1278: END LOOP;

Line 1276: arp_debug.debug('Worker # '|| i||' completed successfully');

1272: AND l_req_status_tab(i).dev_status <> 'NORMAL' THEN
1273: P_RETCODE := 1;
1274: arp_debug.debug('Worker # '|| i||' completed with status '||l_req_status_tab(i).dev_status);
1275: ELSE
1276: arp_debug.debug('Worker # '|| i||' completed successfully');
1277: END IF;
1278: END LOOP;
1279:
1280: IF P_RETCODE = 0 THEN

Line 1288: arp_debug.debug('calling the report- batch_id format ' || o_batch_id);

1284: END IF;
1285: END IF;
1286:
1287: IF l_format_flag = 'Y' THEN
1288: arp_debug.debug('calling the report- batch_id format ' || o_batch_id);
1289: submit_format ( p_batch_id =>o_batch_id);
1290: END IF;
1291:
1292: submit_report ( p_batch_id =>o_batch_id,

Line 1311: arp_debug.debug('Calling ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover');

1307: END;
1308:
1309: IF nvl(l_instrument_type,'XXXXXX') = 'CREDITCARD' AND
1310: nvl(p_approve_flag,'N') = 'Y' THEN
1311: arp_debug.debug('Calling ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover');
1312: ARP_CORRECT_CC_ERRORS.cc_auto_correct_cover(pg_request_id,'CREATION');
1313: END IF;
1314: /* Bug 7639165 - Changes End. */
1315:

Line 1341: arp_debug.debug('Releasing lock - ' || l_batch_lock_msg);

1337: ARP_RW_BATCHES_PKG.release_lock(o_batch_id ,l_batch_lock_msg);
1338:
1339: IF PG_DEBUG in ('Y','C')
1340: THEN
1341: arp_debug.debug('Releasing lock - ' || l_batch_lock_msg);
1342: END IF;
1343:
1344: RAISE ;
1345: END submit_autorec_parallel;

Line 1403: arp_debug.debug('insert_batch()+');

1399: pacc_method VARCHAR2(20);
1400:
1401: BEGIN
1402: IF PG_DEBUG in ('Y', 'C') THEN
1403: arp_debug.debug('insert_batch()+');
1404: arp_debug.debug('p_gl_date '||p_gl_date);
1405: arp_debug.debug('batch_date '||p_batch_date);
1406: arp_debug.debug('p_receipt_method_id '|| to_char(p_receipt_method_id));
1407: arp_debug.debug('p_receipt_class_id '|| to_char(p_receipt_class_id));

Line 1404: arp_debug.debug('p_gl_date '||p_gl_date);

1400:
1401: BEGIN
1402: IF PG_DEBUG in ('Y', 'C') THEN
1403: arp_debug.debug('insert_batch()+');
1404: arp_debug.debug('p_gl_date '||p_gl_date);
1405: arp_debug.debug('batch_date '||p_batch_date);
1406: arp_debug.debug('p_receipt_method_id '|| to_char(p_receipt_method_id));
1407: arp_debug.debug('p_receipt_class_id '|| to_char(p_receipt_class_id));
1408: arp_debug.debug('p_currency_code '||p_currency_code);

Line 1405: arp_debug.debug('batch_date '||p_batch_date);

1401: BEGIN
1402: IF PG_DEBUG in ('Y', 'C') THEN
1403: arp_debug.debug('insert_batch()+');
1404: arp_debug.debug('p_gl_date '||p_gl_date);
1405: arp_debug.debug('batch_date '||p_batch_date);
1406: arp_debug.debug('p_receipt_method_id '|| to_char(p_receipt_method_id));
1407: arp_debug.debug('p_receipt_class_id '|| to_char(p_receipt_class_id));
1408: arp_debug.debug('p_currency_code '||p_currency_code);
1409: arp_debug.debug('p_approve_flag '||p_approve_flag);

Line 1406: arp_debug.debug('p_receipt_method_id '|| to_char(p_receipt_method_id));

1402: IF PG_DEBUG in ('Y', 'C') THEN
1403: arp_debug.debug('insert_batch()+');
1404: arp_debug.debug('p_gl_date '||p_gl_date);
1405: arp_debug.debug('batch_date '||p_batch_date);
1406: arp_debug.debug('p_receipt_method_id '|| to_char(p_receipt_method_id));
1407: arp_debug.debug('p_receipt_class_id '|| to_char(p_receipt_class_id));
1408: arp_debug.debug('p_currency_code '||p_currency_code);
1409: arp_debug.debug('p_approve_flag '||p_approve_flag);
1410: arp_debug.debug('p_format_flag '||p_format_flag);

Line 1407: arp_debug.debug('p_receipt_class_id '|| to_char(p_receipt_class_id));

1403: arp_debug.debug('insert_batch()+');
1404: arp_debug.debug('p_gl_date '||p_gl_date);
1405: arp_debug.debug('batch_date '||p_batch_date);
1406: arp_debug.debug('p_receipt_method_id '|| to_char(p_receipt_method_id));
1407: arp_debug.debug('p_receipt_class_id '|| to_char(p_receipt_class_id));
1408: arp_debug.debug('p_currency_code '||p_currency_code);
1409: arp_debug.debug('p_approve_flag '||p_approve_flag);
1410: arp_debug.debug('p_format_flag '||p_format_flag);
1411: arp_debug.debug('p_create_flag '||p_create_flag);

Line 1408: arp_debug.debug('p_currency_code '||p_currency_code);

1404: arp_debug.debug('p_gl_date '||p_gl_date);
1405: arp_debug.debug('batch_date '||p_batch_date);
1406: arp_debug.debug('p_receipt_method_id '|| to_char(p_receipt_method_id));
1407: arp_debug.debug('p_receipt_class_id '|| to_char(p_receipt_class_id));
1408: arp_debug.debug('p_currency_code '||p_currency_code);
1409: arp_debug.debug('p_approve_flag '||p_approve_flag);
1410: arp_debug.debug('p_format_flag '||p_format_flag);
1411: arp_debug.debug('p_create_flag '||p_create_flag);
1412: arp_debug.debug('p_exchange_date '||p_exchange_date);

Line 1409: arp_debug.debug('p_approve_flag '||p_approve_flag);

1405: arp_debug.debug('batch_date '||p_batch_date);
1406: arp_debug.debug('p_receipt_method_id '|| to_char(p_receipt_method_id));
1407: arp_debug.debug('p_receipt_class_id '|| to_char(p_receipt_class_id));
1408: arp_debug.debug('p_currency_code '||p_currency_code);
1409: arp_debug.debug('p_approve_flag '||p_approve_flag);
1410: arp_debug.debug('p_format_flag '||p_format_flag);
1411: arp_debug.debug('p_create_flag '||p_create_flag);
1412: arp_debug.debug('p_exchange_date '||p_exchange_date);
1413: arp_debug.debug('p_exchange_rate '||p_exchange_rate);

Line 1410: arp_debug.debug('p_format_flag '||p_format_flag);

1406: arp_debug.debug('p_receipt_method_id '|| to_char(p_receipt_method_id));
1407: arp_debug.debug('p_receipt_class_id '|| to_char(p_receipt_class_id));
1408: arp_debug.debug('p_currency_code '||p_currency_code);
1409: arp_debug.debug('p_approve_flag '||p_approve_flag);
1410: arp_debug.debug('p_format_flag '||p_format_flag);
1411: arp_debug.debug('p_create_flag '||p_create_flag);
1412: arp_debug.debug('p_exchange_date '||p_exchange_date);
1413: arp_debug.debug('p_exchange_rate '||p_exchange_rate);
1414: arp_debug.debug('p_exchange_rate_type'||p_exchange_rate_type);

Line 1411: arp_debug.debug('p_create_flag '||p_create_flag);

1407: arp_debug.debug('p_receipt_class_id '|| to_char(p_receipt_class_id));
1408: arp_debug.debug('p_currency_code '||p_currency_code);
1409: arp_debug.debug('p_approve_flag '||p_approve_flag);
1410: arp_debug.debug('p_format_flag '||p_format_flag);
1411: arp_debug.debug('p_create_flag '||p_create_flag);
1412: arp_debug.debug('p_exchange_date '||p_exchange_date);
1413: arp_debug.debug('p_exchange_rate '||p_exchange_rate);
1414: arp_debug.debug('p_exchange_rate_type'||p_exchange_rate_type);
1415: END IF;

Line 1412: arp_debug.debug('p_exchange_date '||p_exchange_date);

1408: arp_debug.debug('p_currency_code '||p_currency_code);
1409: arp_debug.debug('p_approve_flag '||p_approve_flag);
1410: arp_debug.debug('p_format_flag '||p_format_flag);
1411: arp_debug.debug('p_create_flag '||p_create_flag);
1412: arp_debug.debug('p_exchange_date '||p_exchange_date);
1413: arp_debug.debug('p_exchange_rate '||p_exchange_rate);
1414: arp_debug.debug('p_exchange_rate_type'||p_exchange_rate_type);
1415: END IF;
1416:

Line 1413: arp_debug.debug('p_exchange_rate '||p_exchange_rate);

1409: arp_debug.debug('p_approve_flag '||p_approve_flag);
1410: arp_debug.debug('p_format_flag '||p_format_flag);
1411: arp_debug.debug('p_create_flag '||p_create_flag);
1412: arp_debug.debug('p_exchange_date '||p_exchange_date);
1413: arp_debug.debug('p_exchange_rate '||p_exchange_rate);
1414: arp_debug.debug('p_exchange_rate_type'||p_exchange_rate_type);
1415: END IF;
1416:
1417: /* insert the batch record here */

Line 1414: arp_debug.debug('p_exchange_rate_type'||p_exchange_rate_type);

1410: arp_debug.debug('p_format_flag '||p_format_flag);
1411: arp_debug.debug('p_create_flag '||p_create_flag);
1412: arp_debug.debug('p_exchange_date '||p_exchange_date);
1413: arp_debug.debug('p_exchange_rate '||p_exchange_rate);
1414: arp_debug.debug('p_exchange_rate_type'||p_exchange_rate_type);
1415: END IF;
1416:
1417: /* insert the batch record here */
1418: IF PG_DEBUG in ('Y', 'C') THEN

Line 1419: arp_debug.debug('autorecapi calling auto_batch ()+');

1415: END IF;
1416:
1417: /* insert the batch record here */
1418: IF PG_DEBUG in ('Y', 'C') THEN
1419: arp_debug.debug('autorecapi calling auto_batch ()+');
1420: END IF;
1421:
1422: l_batch_rec.receipt_class_id := to_number(p_receipt_class_id);
1423: l_batch_rec.receipt_method_id := to_number(p_receipt_method_id);

Line 1474: arp_debug.debug ('WAIT HERE THE VALUE OF BATCH_ID IS NULL ERROR');

1470:
1471: p_batch_id := to_char(l_batch_id);
1472:
1473: IF p_batch_id IS NULL THEN
1474: arp_debug.debug ('WAIT HERE THE VALUE OF BATCH_ID IS NULL ERROR');
1475: G_ERROR := 'Y';
1476: END IF;
1477:
1478: IF PG_DEBUG in ('Y', 'C') THEN

Line 1479: arp_debug.debug('value of batch_id '||p_batch_id);

1475: G_ERROR := 'Y';
1476: END IF;
1477:
1478: IF PG_DEBUG in ('Y', 'C') THEN
1479: arp_debug.debug('value of batch_id '||p_batch_id);
1480: arp_debug.debug('value of l_request_id '||l_request_id);
1481: arp_debug.debug('value of pg_request_id '||pg_request_id);
1482: END IF;
1483:

Line 1480: arp_debug.debug('value of l_request_id '||l_request_id);

1476: END IF;
1477:
1478: IF PG_DEBUG in ('Y', 'C') THEN
1479: arp_debug.debug('value of batch_id '||p_batch_id);
1480: arp_debug.debug('value of l_request_id '||l_request_id);
1481: arp_debug.debug('value of pg_request_id '||pg_request_id);
1482: END IF;
1483:
1484: IF PG_DEBUG in ('Y', 'C') THEN

Line 1481: arp_debug.debug('value of pg_request_id '||pg_request_id);

1477:
1478: IF PG_DEBUG in ('Y', 'C') THEN
1479: arp_debug.debug('value of batch_id '||p_batch_id);
1480: arp_debug.debug('value of l_request_id '||l_request_id);
1481: arp_debug.debug('value of pg_request_id '||pg_request_id);
1482: END IF;
1483:
1484: IF PG_DEBUG in ('Y', 'C') THEN
1485: arp_debug.debug('autorecapi calling auto_batch end ()-');

Line 1485: arp_debug.debug('autorecapi calling auto_batch end ()-');

1481: arp_debug.debug('value of pg_request_id '||pg_request_id);
1482: END IF;
1483:
1484: IF PG_DEBUG in ('Y', 'C') THEN
1485: arp_debug.debug('autorecapi calling auto_batch end ()-');
1486: END IF;
1487: /* inserted the batch record end */
1488:
1489: /* GET THE VALUES from SYSTEM PARAMETERS */

Line 1491: arp_debug.debug( 'get info from system parameters');

1487: /* inserted the batch record end */
1488:
1489: /* GET THE VALUES from SYSTEM PARAMETERS */
1490: IF PG_DEBUG in ('Y','C') THEN
1491: arp_debug.debug( 'get info from system parameters');
1492: END IF;
1493:
1494: BEGIN
1495: SELECT asp.site_required_flag,

Line 1514: arp_debug.debug( 'ERROR NO DATA FOUND IN SYSTEM OPTION');

1510: AND gsob.set_of_books_id = asp.set_of_books_id;
1511:
1512: EXCEPTION
1513: WHEN no_data_found THEN
1514: arp_debug.debug( 'ERROR NO DATA FOUND IN SYSTEM OPTION');
1515: G_ERROR := 'Y';
1516: END;
1517:
1518: IF PG_DEBUG in ('Y', 'C') THEN

Line 1519: arp_debug.debug ( 'site_req_flag ' || psite_required);

1515: G_ERROR := 'Y';
1516: END;
1517:
1518: IF PG_DEBUG in ('Y', 'C') THEN
1519: arp_debug.debug ( 'site_req_flag ' || psite_required);
1520: arp_debug.debug ( 'the invoices per commit ' || pinvoices_per_commit);
1521: arp_debug.debug ( 'receipts per_commit ' || preceipts_per_commit);
1522: arp_debug.debug ( 'currency code ' || pfunctional_currency);
1523: arp_debug.debug ( 'acc_method ' || pacc_method );

Line 1520: arp_debug.debug ( 'the invoices per commit ' || pinvoices_per_commit);

1516: END;
1517:
1518: IF PG_DEBUG in ('Y', 'C') THEN
1519: arp_debug.debug ( 'site_req_flag ' || psite_required);
1520: arp_debug.debug ( 'the invoices per commit ' || pinvoices_per_commit);
1521: arp_debug.debug ( 'receipts per_commit ' || preceipts_per_commit);
1522: arp_debug.debug ( 'currency code ' || pfunctional_currency);
1523: arp_debug.debug ( 'acc_method ' || pacc_method );
1524: END IF;

Line 1521: arp_debug.debug ( 'receipts per_commit ' || preceipts_per_commit);

1517:
1518: IF PG_DEBUG in ('Y', 'C') THEN
1519: arp_debug.debug ( 'site_req_flag ' || psite_required);
1520: arp_debug.debug ( 'the invoices per commit ' || pinvoices_per_commit);
1521: arp_debug.debug ( 'receipts per_commit ' || preceipts_per_commit);
1522: arp_debug.debug ( 'currency code ' || pfunctional_currency);
1523: arp_debug.debug ( 'acc_method ' || pacc_method );
1524: END IF;
1525:

Line 1522: arp_debug.debug ( 'currency code ' || pfunctional_currency);

1518: IF PG_DEBUG in ('Y', 'C') THEN
1519: arp_debug.debug ( 'site_req_flag ' || psite_required);
1520: arp_debug.debug ( 'the invoices per commit ' || pinvoices_per_commit);
1521: arp_debug.debug ( 'receipts per_commit ' || preceipts_per_commit);
1522: arp_debug.debug ( 'currency code ' || pfunctional_currency);
1523: arp_debug.debug ( 'acc_method ' || pacc_method );
1524: END IF;
1525:
1526: /* END FROM SYSTEM PARAMETERS*/

Line 1523: arp_debug.debug ( 'acc_method ' || pacc_method );

1519: arp_debug.debug ( 'site_req_flag ' || psite_required);
1520: arp_debug.debug ( 'the invoices per commit ' || pinvoices_per_commit);
1521: arp_debug.debug ( 'receipts per_commit ' || preceipts_per_commit);
1522: arp_debug.debug ( 'currency code ' || pfunctional_currency);
1523: arp_debug.debug ( 'acc_method ' || pacc_method );
1524: END IF;
1525:
1526: /* END FROM SYSTEM PARAMETERS*/
1527: IF PG_DEBUG in ('Y', 'C') THEN

Line 1528: arp_debug.debug('insert_batch()-');

1524: END IF;
1525:
1526: /* END FROM SYSTEM PARAMETERS*/
1527: IF PG_DEBUG in ('Y', 'C') THEN
1528: arp_debug.debug('insert_batch()-');
1529: END IF;
1530:
1531: EXCEPTION
1532: WHEN others THEN

Line 1534: arp_debug.debug('Exception : insert_batch() ');

1530:
1531: EXCEPTION
1532: WHEN others THEN
1533: IF PG_DEBUG in ('Y', 'C') THEN
1534: arp_debug.debug('Exception : insert_batch() ');
1535: END IF;
1536: G_ERROR := 'Y';
1537: END insert_batch;
1538:

Line 1613: arp_debug.debug('select_valid_invoices start ()+');

1609: BEGIN
1610:
1611: --- Print the parameters in the debug file
1612: IF PG_DEBUG in ('Y', 'C') THEN
1613: arp_debug.debug('select_valid_invoices start ()+');
1614: arp_debug.debug( 'p_batch_id '||p_batch_id);
1615: arp_debug.debug( 'p_trx_date_l '||p_trx_date_l);
1616: arp_debug.debug( 'p_trx_date_h '||p_trx_date_h);
1617: arp_debug.debug( 'p_due_date_l '||p_due_date_l);

Line 1614: arp_debug.debug( 'p_batch_id '||p_batch_id);

1610:
1611: --- Print the parameters in the debug file
1612: IF PG_DEBUG in ('Y', 'C') THEN
1613: arp_debug.debug('select_valid_invoices start ()+');
1614: arp_debug.debug( 'p_batch_id '||p_batch_id);
1615: arp_debug.debug( 'p_trx_date_l '||p_trx_date_l);
1616: arp_debug.debug( 'p_trx_date_h '||p_trx_date_h);
1617: arp_debug.debug( 'p_due_date_l '||p_due_date_l);
1618: arp_debug.debug( 'p_due_date_h '||p_due_date_h);

Line 1615: arp_debug.debug( 'p_trx_date_l '||p_trx_date_l);

1611: --- Print the parameters in the debug file
1612: IF PG_DEBUG in ('Y', 'C') THEN
1613: arp_debug.debug('select_valid_invoices start ()+');
1614: arp_debug.debug( 'p_batch_id '||p_batch_id);
1615: arp_debug.debug( 'p_trx_date_l '||p_trx_date_l);
1616: arp_debug.debug( 'p_trx_date_h '||p_trx_date_h);
1617: arp_debug.debug( 'p_due_date_l '||p_due_date_l);
1618: arp_debug.debug( 'p_due_date_h '||p_due_date_h);
1619: arp_debug.debug( 'p_trx_num_l '||p_trx_num_l);

Line 1616: arp_debug.debug( 'p_trx_date_h '||p_trx_date_h);

1612: IF PG_DEBUG in ('Y', 'C') THEN
1613: arp_debug.debug('select_valid_invoices start ()+');
1614: arp_debug.debug( 'p_batch_id '||p_batch_id);
1615: arp_debug.debug( 'p_trx_date_l '||p_trx_date_l);
1616: arp_debug.debug( 'p_trx_date_h '||p_trx_date_h);
1617: arp_debug.debug( 'p_due_date_l '||p_due_date_l);
1618: arp_debug.debug( 'p_due_date_h '||p_due_date_h);
1619: arp_debug.debug( 'p_trx_num_l '||p_trx_num_l);
1620: arp_debug.debug( 'p_trx_num_h '||p_trx_num_h);

Line 1617: arp_debug.debug( 'p_due_date_l '||p_due_date_l);

1613: arp_debug.debug('select_valid_invoices start ()+');
1614: arp_debug.debug( 'p_batch_id '||p_batch_id);
1615: arp_debug.debug( 'p_trx_date_l '||p_trx_date_l);
1616: arp_debug.debug( 'p_trx_date_h '||p_trx_date_h);
1617: arp_debug.debug( 'p_due_date_l '||p_due_date_l);
1618: arp_debug.debug( 'p_due_date_h '||p_due_date_h);
1619: arp_debug.debug( 'p_trx_num_l '||p_trx_num_l);
1620: arp_debug.debug( 'p_trx_num_h '||p_trx_num_h);
1621: arp_debug.debug( 'p_doc_num_l '||p_doc_num_l);

Line 1618: arp_debug.debug( 'p_due_date_h '||p_due_date_h);

1614: arp_debug.debug( 'p_batch_id '||p_batch_id);
1615: arp_debug.debug( 'p_trx_date_l '||p_trx_date_l);
1616: arp_debug.debug( 'p_trx_date_h '||p_trx_date_h);
1617: arp_debug.debug( 'p_due_date_l '||p_due_date_l);
1618: arp_debug.debug( 'p_due_date_h '||p_due_date_h);
1619: arp_debug.debug( 'p_trx_num_l '||p_trx_num_l);
1620: arp_debug.debug( 'p_trx_num_h '||p_trx_num_h);
1621: arp_debug.debug( 'p_doc_num_l '||p_doc_num_l);
1622: arp_debug.debug( 'p_doc_num_h '||p_doc_num_h);

Line 1619: arp_debug.debug( 'p_trx_num_l '||p_trx_num_l);

1615: arp_debug.debug( 'p_trx_date_l '||p_trx_date_l);
1616: arp_debug.debug( 'p_trx_date_h '||p_trx_date_h);
1617: arp_debug.debug( 'p_due_date_l '||p_due_date_l);
1618: arp_debug.debug( 'p_due_date_h '||p_due_date_h);
1619: arp_debug.debug( 'p_trx_num_l '||p_trx_num_l);
1620: arp_debug.debug( 'p_trx_num_h '||p_trx_num_h);
1621: arp_debug.debug( 'p_doc_num_l '||p_doc_num_l);
1622: arp_debug.debug( 'p_doc_num_h '||p_doc_num_h);
1623: arp_debug.debug( 'p_customer_number_l '||p_customer_number_l);

Line 1620: arp_debug.debug( 'p_trx_num_h '||p_trx_num_h);

1616: arp_debug.debug( 'p_trx_date_h '||p_trx_date_h);
1617: arp_debug.debug( 'p_due_date_l '||p_due_date_l);
1618: arp_debug.debug( 'p_due_date_h '||p_due_date_h);
1619: arp_debug.debug( 'p_trx_num_l '||p_trx_num_l);
1620: arp_debug.debug( 'p_trx_num_h '||p_trx_num_h);
1621: arp_debug.debug( 'p_doc_num_l '||p_doc_num_l);
1622: arp_debug.debug( 'p_doc_num_h '||p_doc_num_h);
1623: arp_debug.debug( 'p_customer_number_l '||p_customer_number_l);
1624: arp_debug.debug( 'p_customer_number_h '||p_customer_number_h);

Line 1621: arp_debug.debug( 'p_doc_num_l '||p_doc_num_l);

1617: arp_debug.debug( 'p_due_date_l '||p_due_date_l);
1618: arp_debug.debug( 'p_due_date_h '||p_due_date_h);
1619: arp_debug.debug( 'p_trx_num_l '||p_trx_num_l);
1620: arp_debug.debug( 'p_trx_num_h '||p_trx_num_h);
1621: arp_debug.debug( 'p_doc_num_l '||p_doc_num_l);
1622: arp_debug.debug( 'p_doc_num_h '||p_doc_num_h);
1623: arp_debug.debug( 'p_customer_number_l '||p_customer_number_l);
1624: arp_debug.debug( 'p_customer_number_h '||p_customer_number_h);
1625: arp_debug.debug( 'p_customer_name_l '||p_customer_name_l);

Line 1622: arp_debug.debug( 'p_doc_num_h '||p_doc_num_h);

1618: arp_debug.debug( 'p_due_date_h '||p_due_date_h);
1619: arp_debug.debug( 'p_trx_num_l '||p_trx_num_l);
1620: arp_debug.debug( 'p_trx_num_h '||p_trx_num_h);
1621: arp_debug.debug( 'p_doc_num_l '||p_doc_num_l);
1622: arp_debug.debug( 'p_doc_num_h '||p_doc_num_h);
1623: arp_debug.debug( 'p_customer_number_l '||p_customer_number_l);
1624: arp_debug.debug( 'p_customer_number_h '||p_customer_number_h);
1625: arp_debug.debug( 'p_customer_name_l '||p_customer_name_l);
1626: arp_debug.debug( 'p_customer_name_h '||p_customer_name_h);

Line 1623: arp_debug.debug( 'p_customer_number_l '||p_customer_number_l);

1619: arp_debug.debug( 'p_trx_num_l '||p_trx_num_l);
1620: arp_debug.debug( 'p_trx_num_h '||p_trx_num_h);
1621: arp_debug.debug( 'p_doc_num_l '||p_doc_num_l);
1622: arp_debug.debug( 'p_doc_num_h '||p_doc_num_h);
1623: arp_debug.debug( 'p_customer_number_l '||p_customer_number_l);
1624: arp_debug.debug( 'p_customer_number_h '||p_customer_number_h);
1625: arp_debug.debug( 'p_customer_name_l '||p_customer_name_l);
1626: arp_debug.debug( 'p_customer_name_h '||p_customer_name_h);
1627: arp_debug.debug( 'p_approve_only_flag '||p_approve_only_flag);

Line 1624: arp_debug.debug( 'p_customer_number_h '||p_customer_number_h);

1620: arp_debug.debug( 'p_trx_num_h '||p_trx_num_h);
1621: arp_debug.debug( 'p_doc_num_l '||p_doc_num_l);
1622: arp_debug.debug( 'p_doc_num_h '||p_doc_num_h);
1623: arp_debug.debug( 'p_customer_number_l '||p_customer_number_l);
1624: arp_debug.debug( 'p_customer_number_h '||p_customer_number_h);
1625: arp_debug.debug( 'p_customer_name_l '||p_customer_name_l);
1626: arp_debug.debug( 'p_customer_name_h '||p_customer_name_h);
1627: arp_debug.debug( 'p_approve_only_flag '||p_approve_only_flag);
1628: arp_debug.debug( 'p_receipt_method_id '||p_receipt_method_id);

Line 1625: arp_debug.debug( 'p_customer_name_l '||p_customer_name_l);

1621: arp_debug.debug( 'p_doc_num_l '||p_doc_num_l);
1622: arp_debug.debug( 'p_doc_num_h '||p_doc_num_h);
1623: arp_debug.debug( 'p_customer_number_l '||p_customer_number_l);
1624: arp_debug.debug( 'p_customer_number_h '||p_customer_number_h);
1625: arp_debug.debug( 'p_customer_name_l '||p_customer_name_l);
1626: arp_debug.debug( 'p_customer_name_h '||p_customer_name_h);
1627: arp_debug.debug( 'p_approve_only_flag '||p_approve_only_flag);
1628: arp_debug.debug( 'p_receipt_method_id '||p_receipt_method_id);
1629: arp_debug.debug( 'p_total_workers '||p_total_workers);

Line 1626: arp_debug.debug( 'p_customer_name_h '||p_customer_name_h);

1622: arp_debug.debug( 'p_doc_num_h '||p_doc_num_h);
1623: arp_debug.debug( 'p_customer_number_l '||p_customer_number_l);
1624: arp_debug.debug( 'p_customer_number_h '||p_customer_number_h);
1625: arp_debug.debug( 'p_customer_name_l '||p_customer_name_l);
1626: arp_debug.debug( 'p_customer_name_h '||p_customer_name_h);
1627: arp_debug.debug( 'p_approve_only_flag '||p_approve_only_flag);
1628: arp_debug.debug( 'p_receipt_method_id '||p_receipt_method_id);
1629: arp_debug.debug( 'p_total_workers '||p_total_workers);
1630: END IF;

Line 1627: arp_debug.debug( 'p_approve_only_flag '||p_approve_only_flag);

1623: arp_debug.debug( 'p_customer_number_l '||p_customer_number_l);
1624: arp_debug.debug( 'p_customer_number_h '||p_customer_number_h);
1625: arp_debug.debug( 'p_customer_name_l '||p_customer_name_l);
1626: arp_debug.debug( 'p_customer_name_h '||p_customer_name_h);
1627: arp_debug.debug( 'p_approve_only_flag '||p_approve_only_flag);
1628: arp_debug.debug( 'p_receipt_method_id '||p_receipt_method_id);
1629: arp_debug.debug( 'p_total_workers '||p_total_workers);
1630: END IF;
1631:

Line 1628: arp_debug.debug( 'p_receipt_method_id '||p_receipt_method_id);

1624: arp_debug.debug( 'p_customer_number_h '||p_customer_number_h);
1625: arp_debug.debug( 'p_customer_name_l '||p_customer_name_l);
1626: arp_debug.debug( 'p_customer_name_h '||p_customer_name_h);
1627: arp_debug.debug( 'p_approve_only_flag '||p_approve_only_flag);
1628: arp_debug.debug( 'p_receipt_method_id '||p_receipt_method_id);
1629: arp_debug.debug( 'p_total_workers '||p_total_workers);
1630: END IF;
1631:
1632: l_total_workers := nvl(p_total_workers,1);

Line 1629: arp_debug.debug( 'p_total_workers '||p_total_workers);

1625: arp_debug.debug( 'p_customer_name_l '||p_customer_name_l);
1626: arp_debug.debug( 'p_customer_name_h '||p_customer_name_h);
1627: arp_debug.debug( 'p_approve_only_flag '||p_approve_only_flag);
1628: arp_debug.debug( 'p_receipt_method_id '||p_receipt_method_id);
1629: arp_debug.debug( 'p_total_workers '||p_total_workers);
1630: END IF;
1631:
1632: l_total_workers := nvl(p_total_workers,1);
1633:

Line 1650: arp_debug.debug( 'p_currency_code '||p_currency_code);

1646: AND r.receipt_method_id = p_receipt_method_id;
1647:
1648: --- Print the parameters in the debug file
1649: IF PG_DEBUG in ('Y', 'C') THEN
1650: arp_debug.debug( 'p_currency_code '||p_currency_code);
1651: arp_debug.debug( 'p_batch_date '||p_batch_date);
1652: arp_debug.debug( 'p_lead_days '||p_lead_days);
1653: arp_debug.debug( 'p_receipt_method_id '||p_receipt_method_id);
1654: arp_debug.debug( 'p_batch_id '||p_batch_id);

Line 1651: arp_debug.debug( 'p_batch_date '||p_batch_date);

1647:
1648: --- Print the parameters in the debug file
1649: IF PG_DEBUG in ('Y', 'C') THEN
1650: arp_debug.debug( 'p_currency_code '||p_currency_code);
1651: arp_debug.debug( 'p_batch_date '||p_batch_date);
1652: arp_debug.debug( 'p_lead_days '||p_lead_days);
1653: arp_debug.debug( 'p_receipt_method_id '||p_receipt_method_id);
1654: arp_debug.debug( 'p_batch_id '||p_batch_id);
1655: arp_debug.debug( 'p_creation_rule '||p_creation_rule);

Line 1652: arp_debug.debug( 'p_lead_days '||p_lead_days);

1648: --- Print the parameters in the debug file
1649: IF PG_DEBUG in ('Y', 'C') THEN
1650: arp_debug.debug( 'p_currency_code '||p_currency_code);
1651: arp_debug.debug( 'p_batch_date '||p_batch_date);
1652: arp_debug.debug( 'p_lead_days '||p_lead_days);
1653: arp_debug.debug( 'p_receipt_method_id '||p_receipt_method_id);
1654: arp_debug.debug( 'p_batch_id '||p_batch_id);
1655: arp_debug.debug( 'p_creation_rule '||p_creation_rule);
1656: arp_debug.debug( 'l_total_workers '||l_total_workers);

Line 1653: arp_debug.debug( 'p_receipt_method_id '||p_receipt_method_id);

1649: IF PG_DEBUG in ('Y', 'C') THEN
1650: arp_debug.debug( 'p_currency_code '||p_currency_code);
1651: arp_debug.debug( 'p_batch_date '||p_batch_date);
1652: arp_debug.debug( 'p_lead_days '||p_lead_days);
1653: arp_debug.debug( 'p_receipt_method_id '||p_receipt_method_id);
1654: arp_debug.debug( 'p_batch_id '||p_batch_id);
1655: arp_debug.debug( 'p_creation_rule '||p_creation_rule);
1656: arp_debug.debug( 'l_total_workers '||l_total_workers);
1657: END IF;

Line 1654: arp_debug.debug( 'p_batch_id '||p_batch_id);

1650: arp_debug.debug( 'p_currency_code '||p_currency_code);
1651: arp_debug.debug( 'p_batch_date '||p_batch_date);
1652: arp_debug.debug( 'p_lead_days '||p_lead_days);
1653: arp_debug.debug( 'p_receipt_method_id '||p_receipt_method_id);
1654: arp_debug.debug( 'p_batch_id '||p_batch_id);
1655: arp_debug.debug( 'p_creation_rule '||p_creation_rule);
1656: arp_debug.debug( 'l_total_workers '||l_total_workers);
1657: END IF;
1658:

Line 1655: arp_debug.debug( 'p_creation_rule '||p_creation_rule);

1651: arp_debug.debug( 'p_batch_date '||p_batch_date);
1652: arp_debug.debug( 'p_lead_days '||p_lead_days);
1653: arp_debug.debug( 'p_receipt_method_id '||p_receipt_method_id);
1654: arp_debug.debug( 'p_batch_id '||p_batch_id);
1655: arp_debug.debug( 'p_creation_rule '||p_creation_rule);
1656: arp_debug.debug( 'l_total_workers '||l_total_workers);
1657: END IF;
1658:
1659: -- Build the query dynamically based on the input parameters

Line 1656: arp_debug.debug( 'l_total_workers '||l_total_workers);

1652: arp_debug.debug( 'p_lead_days '||p_lead_days);
1653: arp_debug.debug( 'p_receipt_method_id '||p_receipt_method_id);
1654: arp_debug.debug( 'p_batch_id '||p_batch_id);
1655: arp_debug.debug( 'p_creation_rule '||p_creation_rule);
1656: arp_debug.debug( 'l_total_workers '||l_total_workers);
1657: END IF;
1658:
1659: -- Build the query dynamically based on the input parameters
1660: IF PG_PARALLEL IN ('Y', 'C') THEN

Line 1873: arp_debug.debug( 'the select statement ' || l_sel_stmt);

1869:
1870: dbms_sql.bind_variable (trx_invoices,':l_total_workers',l_total_workers);
1871:
1872: IF PG_DEBUG in ('Y', 'C') THEN
1873: arp_debug.debug( 'the select statement ' || l_sel_stmt);
1874: END IF;
1875:
1876: BEGIN
1877: IF PG_DEBUG in ('Y', 'C') THEN

Line 1878: arp_debug.debug( 'PG_PARALLEL ' || PG_PARALLEL);

1874: END IF;
1875:
1876: BEGIN
1877: IF PG_DEBUG in ('Y', 'C') THEN
1878: arp_debug.debug( 'PG_PARALLEL ' || PG_PARALLEL);
1879: END IF;
1880:
1881: --Enable parallel DML at the session level if the profile is set
1882: IF PG_PARALLEL IN ('Y', 'C') THEN

Line 1894: arp_debug.debug('Number of invoices selected : '||l_rows_processed);

1890: COMMIT; /* Bug 8249909 */
1891: END IF;
1892:
1893: IF PG_DEBUG in ('Y', 'C') THEN
1894: arp_debug.debug('Number of invoices selected : '||l_rows_processed);
1895: END IF;
1896:
1897: dbms_sql.close_cursor( trx_invoices);
1898:

Line 1901: arp_debug.debug('Stamping batch_id to PS : '||l_rows_processed);

1897: dbms_sql.close_cursor( trx_invoices);
1898:
1899: IF p_approve_only_flag = 'N' THEN
1900: IF PG_DEBUG in ('Y', 'C') THEN
1901: arp_debug.debug('Stamping batch_id to PS : '||l_rows_processed);
1902: END IF;
1903: update ar_payment_schedules
1904: set selected_for_receipt_batch_id = p_batch_id
1905: where payment_schedule_id in

Line 1912: arp_debug.debug('Number of PS records stamped : '||SQL%ROWCOUNT);

1908: from ar_autorec_interim a
1909: where batch_id = p_batch_id);
1910:
1911: IF PG_DEBUG in ('Y', 'C') THEN
1912: arp_debug.debug('Number of PS records stamped : '||SQL%ROWCOUNT);
1913: END IF;
1914: END IF;
1915:
1916:

Line 1922: arp_debug.debug('Exception : select_valid_invoices() '|| SQLERRM);

1918: WHEN OTHERS THEN
1919: G_ERROR := 'Y';
1920: dbms_sql.close_cursor( trx_invoices);
1921: IF PG_DEBUG in ('Y', 'C') THEN
1922: arp_debug.debug('Exception : select_valid_invoices() '|| SQLERRM);
1923: arp_debug.debug('Error while executing>' || l_sel_stmt);
1924: END IF;
1925: RAISE; /* Bug 8249909 */
1926: END;

Line 1923: arp_debug.debug('Error while executing>' || l_sel_stmt);

1919: G_ERROR := 'Y';
1920: dbms_sql.close_cursor( trx_invoices);
1921: IF PG_DEBUG in ('Y', 'C') THEN
1922: arp_debug.debug('Exception : select_valid_invoices() '|| SQLERRM);
1923: arp_debug.debug('Error while executing>' || l_sel_stmt);
1924: END IF;
1925: RAISE; /* Bug 8249909 */
1926: END;
1927:

Line 1932: arp_debug.debug(' Exception : select_valid_invoices '|| SQLERRM);

1928: EXCEPTION
1929: WHEN others THEN
1930: G_ERROR := 'Y';
1931: IF PG_DEBUG in ('Y', 'C') THEN
1932: arp_debug.debug(' Exception : select_valid_invoices '|| SQLERRM);
1933: arp_debug.debug( 'the select statement ' || l_sel_stmt);
1934: END IF;
1935: RAISE; -- Changed as per Bug:5331158 for returning the error to environment
1936:

Line 1933: arp_debug.debug( 'the select statement ' || l_sel_stmt);

1929: WHEN others THEN
1930: G_ERROR := 'Y';
1931: IF PG_DEBUG in ('Y', 'C') THEN
1932: arp_debug.debug(' Exception : select_valid_invoices '|| SQLERRM);
1933: arp_debug.debug( 'the select statement ' || l_sel_stmt);
1934: END IF;
1935: RAISE; -- Changed as per Bug:5331158 for returning the error to environment
1936:
1937: END select_valid_invoices;

Line 1973: arp_debug.debug( 'Get_Invoice_Bal_After_Disc()+' );

1969:
1970: BEGIN
1971:
1972: IF PG_DEBUG in ('Y', 'C') THEN
1973: arp_debug.debug( 'Get_Invoice_Bal_After_Disc()+' );
1974: arp_debug.debug( 'p_applied_payment_schedule_id :-' || p_applied_payment_schedule_id );
1975: arp_debug.debug( 'p_apply_date :-' || p_apply_date );
1976: END IF;
1977:

Line 1974: arp_debug.debug( 'p_applied_payment_schedule_id :-' || p_applied_payment_schedule_id );

1970: BEGIN
1971:
1972: IF PG_DEBUG in ('Y', 'C') THEN
1973: arp_debug.debug( 'Get_Invoice_Bal_After_Disc()+' );
1974: arp_debug.debug( 'p_applied_payment_schedule_id :-' || p_applied_payment_schedule_id );
1975: arp_debug.debug( 'p_apply_date :-' || p_apply_date );
1976: END IF;
1977:
1978: l_applied_payment_schedule_id := p_applied_payment_schedule_id;

Line 1975: arp_debug.debug( 'p_apply_date :-' || p_apply_date );

1971:
1972: IF PG_DEBUG in ('Y', 'C') THEN
1973: arp_debug.debug( 'Get_Invoice_Bal_After_Disc()+' );
1974: arp_debug.debug( 'p_applied_payment_schedule_id :-' || p_applied_payment_schedule_id );
1975: arp_debug.debug( 'p_apply_date :-' || p_apply_date );
1976: END IF;
1977:
1978: l_applied_payment_schedule_id := p_applied_payment_schedule_id;
1979: l_apply_date := p_apply_date;

Line 2057: arp_debug.debug( 'l_amount_to_be_applied :- '|| l_amount_to_be_applied );

2053: p_return_status => l_return_status
2054: );
2055:
2056: IF PG_DEBUG in ('Y', 'C') THEN
2057: arp_debug.debug( 'l_amount_to_be_applied :- '|| l_amount_to_be_applied );
2058: arp_debug.debug( 'l_discount :- '|| l_discount );
2059: arp_debug.debug( 'l_discount_max_allowed :- '|| l_discount_max_allowed );
2060: arp_debug.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
2061: arp_debug.debug( 'l_discount_earned :- '|| l_discount_earned );

Line 2058: arp_debug.debug( 'l_discount :- '|| l_discount );

2054: );
2055:
2056: IF PG_DEBUG in ('Y', 'C') THEN
2057: arp_debug.debug( 'l_amount_to_be_applied :- '|| l_amount_to_be_applied );
2058: arp_debug.debug( 'l_discount :- '|| l_discount );
2059: arp_debug.debug( 'l_discount_max_allowed :- '|| l_discount_max_allowed );
2060: arp_debug.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
2061: arp_debug.debug( 'l_discount_earned :- '|| l_discount_earned );
2062: arp_debug.debug( 'l_discount_unearned :- '|| l_discount_unearned );

Line 2059: arp_debug.debug( 'l_discount_max_allowed :- '|| l_discount_max_allowed );

2055:
2056: IF PG_DEBUG in ('Y', 'C') THEN
2057: arp_debug.debug( 'l_amount_to_be_applied :- '|| l_amount_to_be_applied );
2058: arp_debug.debug( 'l_discount :- '|| l_discount );
2059: arp_debug.debug( 'l_discount_max_allowed :- '|| l_discount_max_allowed );
2060: arp_debug.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
2061: arp_debug.debug( 'l_discount_earned :- '|| l_discount_earned );
2062: arp_debug.debug( 'l_discount_unearned :- '|| l_discount_unearned );
2063: arp_debug.debug( 'l_new_amount_due_remaining :- '|| l_new_amount_due_remaining );

Line 2060: arp_debug.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );

2056: IF PG_DEBUG in ('Y', 'C') THEN
2057: arp_debug.debug( 'l_amount_to_be_applied :- '|| l_amount_to_be_applied );
2058: arp_debug.debug( 'l_discount :- '|| l_discount );
2059: arp_debug.debug( 'l_discount_max_allowed :- '|| l_discount_max_allowed );
2060: arp_debug.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
2061: arp_debug.debug( 'l_discount_earned :- '|| l_discount_earned );
2062: arp_debug.debug( 'l_discount_unearned :- '|| l_discount_unearned );
2063: arp_debug.debug( 'l_new_amount_due_remaining :- '|| l_new_amount_due_remaining );
2064: arp_debug.debug( 'l_return_status :- '|| l_return_status );

Line 2061: arp_debug.debug( 'l_discount_earned :- '|| l_discount_earned );

2057: arp_debug.debug( 'l_amount_to_be_applied :- '|| l_amount_to_be_applied );
2058: arp_debug.debug( 'l_discount :- '|| l_discount );
2059: arp_debug.debug( 'l_discount_max_allowed :- '|| l_discount_max_allowed );
2060: arp_debug.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
2061: arp_debug.debug( 'l_discount_earned :- '|| l_discount_earned );
2062: arp_debug.debug( 'l_discount_unearned :- '|| l_discount_unearned );
2063: arp_debug.debug( 'l_new_amount_due_remaining :- '|| l_new_amount_due_remaining );
2064: arp_debug.debug( 'l_return_status :- '|| l_return_status );
2065: END IF;

Line 2062: arp_debug.debug( 'l_discount_unearned :- '|| l_discount_unearned );

2058: arp_debug.debug( 'l_discount :- '|| l_discount );
2059: arp_debug.debug( 'l_discount_max_allowed :- '|| l_discount_max_allowed );
2060: arp_debug.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
2061: arp_debug.debug( 'l_discount_earned :- '|| l_discount_earned );
2062: arp_debug.debug( 'l_discount_unearned :- '|| l_discount_unearned );
2063: arp_debug.debug( 'l_new_amount_due_remaining :- '|| l_new_amount_due_remaining );
2064: arp_debug.debug( 'l_return_status :- '|| l_return_status );
2065: END IF;
2066:

Line 2063: arp_debug.debug( 'l_new_amount_due_remaining :- '|| l_new_amount_due_remaining );

2059: arp_debug.debug( 'l_discount_max_allowed :- '|| l_discount_max_allowed );
2060: arp_debug.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
2061: arp_debug.debug( 'l_discount_earned :- '|| l_discount_earned );
2062: arp_debug.debug( 'l_discount_unearned :- '|| l_discount_unearned );
2063: arp_debug.debug( 'l_new_amount_due_remaining :- '|| l_new_amount_due_remaining );
2064: arp_debug.debug( 'l_return_status :- '|| l_return_status );
2065: END IF;
2066:
2067: IF PG_DEBUG in ('Y', 'C') THEN

Line 2064: arp_debug.debug( 'l_return_status :- '|| l_return_status );

2060: arp_debug.debug( 'l_discount_earned_allowed :- '|| l_discount_earned_allowed );
2061: arp_debug.debug( 'l_discount_earned :- '|| l_discount_earned );
2062: arp_debug.debug( 'l_discount_unearned :- '|| l_discount_unearned );
2063: arp_debug.debug( 'l_new_amount_due_remaining :- '|| l_new_amount_due_remaining );
2064: arp_debug.debug( 'l_return_status :- '|| l_return_status );
2065: END IF;
2066:
2067: IF PG_DEBUG in ('Y', 'C') THEN
2068: arp_debug.debug( 'Get_Invoice_Bal_After_Disc()-' );

Line 2068: arp_debug.debug( 'Get_Invoice_Bal_After_Disc()-' );

2064: arp_debug.debug( 'l_return_status :- '|| l_return_status );
2065: END IF;
2066:
2067: IF PG_DEBUG in ('Y', 'C') THEN
2068: arp_debug.debug( 'Get_Invoice_Bal_After_Disc()-' );
2069: END IF;
2070:
2071: RETURN l_amount_to_be_applied;
2072:

Line 2077: arp_debug.debug( 'l_return_status :- '|| l_return_status );

2073: EXCEPTION
2074: WHEN OTHERS THEN
2075: l_return_status := 'E';
2076: IF PG_DEBUG in ('Y', 'C') THEN
2077: arp_debug.debug( 'l_return_status :- '|| l_return_status );
2078: arp_debug.debug( 'Exception in Get_Invoice_Bal_After_Disc()!!!' );
2079: END IF;
2080: RAISE;
2081: END Get_Invoice_Bal_After_Disc;

Line 2078: arp_debug.debug( 'Exception in Get_Invoice_Bal_After_Disc()!!!' );

2074: WHEN OTHERS THEN
2075: l_return_status := 'E';
2076: IF PG_DEBUG in ('Y', 'C') THEN
2077: arp_debug.debug( 'l_return_status :- '|| l_return_status );
2078: arp_debug.debug( 'Exception in Get_Invoice_Bal_After_Disc()!!!' );
2079: END IF;
2080: RAISE;
2081: END Get_Invoice_Bal_After_Disc;
2082:

Line 2125: arp_debug.debug('insert_exceptions()+');

2121:
2122: BEGIN
2123:
2124: IF PG_DEBUG in ('Y','C') THEN
2125: arp_debug.debug('insert_exceptions()+');
2126: arp_debug.debug('p_batch_id '|| p_batch_id);
2127: arp_debug.debug('p_request_id '|| p_request_id);
2128: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);
2129: arp_debug.debug('p_payment_schedule_id '|| p_payment_schedule_id);

Line 2126: arp_debug.debug('p_batch_id '|| p_batch_id);

2122: BEGIN
2123:
2124: IF PG_DEBUG in ('Y','C') THEN
2125: arp_debug.debug('insert_exceptions()+');
2126: arp_debug.debug('p_batch_id '|| p_batch_id);
2127: arp_debug.debug('p_request_id '|| p_request_id);
2128: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);
2129: arp_debug.debug('p_payment_schedule_id '|| p_payment_schedule_id);
2130: arp_debug.debug('p_paying_customer_id '|| p_paying_customer_id);

Line 2127: arp_debug.debug('p_request_id '|| p_request_id);

2123:
2124: IF PG_DEBUG in ('Y','C') THEN
2125: arp_debug.debug('insert_exceptions()+');
2126: arp_debug.debug('p_batch_id '|| p_batch_id);
2127: arp_debug.debug('p_request_id '|| p_request_id);
2128: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);
2129: arp_debug.debug('p_payment_schedule_id '|| p_payment_schedule_id);
2130: arp_debug.debug('p_paying_customer_id '|| p_paying_customer_id);
2131: arp_debug.debug('p_paying_site_use_id '|| p_paying_site_use_id);

Line 2128: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);

2124: IF PG_DEBUG in ('Y','C') THEN
2125: arp_debug.debug('insert_exceptions()+');
2126: arp_debug.debug('p_batch_id '|| p_batch_id);
2127: arp_debug.debug('p_request_id '|| p_request_id);
2128: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);
2129: arp_debug.debug('p_payment_schedule_id '|| p_payment_schedule_id);
2130: arp_debug.debug('p_paying_customer_id '|| p_paying_customer_id);
2131: arp_debug.debug('p_paying_site_use_id '|| p_paying_site_use_id);
2132: arp_debug.debug('p_due_date '|| p_due_date);

Line 2129: arp_debug.debug('p_payment_schedule_id '|| p_payment_schedule_id);

2125: arp_debug.debug('insert_exceptions()+');
2126: arp_debug.debug('p_batch_id '|| p_batch_id);
2127: arp_debug.debug('p_request_id '|| p_request_id);
2128: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);
2129: arp_debug.debug('p_payment_schedule_id '|| p_payment_schedule_id);
2130: arp_debug.debug('p_paying_customer_id '|| p_paying_customer_id);
2131: arp_debug.debug('p_paying_site_use_id '|| p_paying_site_use_id);
2132: arp_debug.debug('p_due_date '|| p_due_date);
2133: arp_debug.debug('p_cust_min_rec_amount '|| p_cust_min_rec_amount);

Line 2130: arp_debug.debug('p_paying_customer_id '|| p_paying_customer_id);

2126: arp_debug.debug('p_batch_id '|| p_batch_id);
2127: arp_debug.debug('p_request_id '|| p_request_id);
2128: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);
2129: arp_debug.debug('p_payment_schedule_id '|| p_payment_schedule_id);
2130: arp_debug.debug('p_paying_customer_id '|| p_paying_customer_id);
2131: arp_debug.debug('p_paying_site_use_id '|| p_paying_site_use_id);
2132: arp_debug.debug('p_due_date '|| p_due_date);
2133: arp_debug.debug('p_cust_min_rec_amount '|| p_cust_min_rec_amount);
2134: arp_debug.debug('p_bank_min_rec_amount '|| p_bank_min_rec_amount);

Line 2131: arp_debug.debug('p_paying_site_use_id '|| p_paying_site_use_id);

2127: arp_debug.debug('p_request_id '|| p_request_id);
2128: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);
2129: arp_debug.debug('p_payment_schedule_id '|| p_payment_schedule_id);
2130: arp_debug.debug('p_paying_customer_id '|| p_paying_customer_id);
2131: arp_debug.debug('p_paying_site_use_id '|| p_paying_site_use_id);
2132: arp_debug.debug('p_due_date '|| p_due_date);
2133: arp_debug.debug('p_cust_min_rec_amount '|| p_cust_min_rec_amount);
2134: arp_debug.debug('p_bank_min_rec_amount '|| p_bank_min_rec_amount);
2135: arp_debug.debug('p_exception_code '||p_exception_code);

Line 2132: arp_debug.debug('p_due_date '|| p_due_date);

2128: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);
2129: arp_debug.debug('p_payment_schedule_id '|| p_payment_schedule_id);
2130: arp_debug.debug('p_paying_customer_id '|| p_paying_customer_id);
2131: arp_debug.debug('p_paying_site_use_id '|| p_paying_site_use_id);
2132: arp_debug.debug('p_due_date '|| p_due_date);
2133: arp_debug.debug('p_cust_min_rec_amount '|| p_cust_min_rec_amount);
2134: arp_debug.debug('p_bank_min_rec_amount '|| p_bank_min_rec_amount);
2135: arp_debug.debug('p_exception_code '||p_exception_code);
2136: arp_debug.debug('p_additional_message '||p_additional_message);

Line 2133: arp_debug.debug('p_cust_min_rec_amount '|| p_cust_min_rec_amount);

2129: arp_debug.debug('p_payment_schedule_id '|| p_payment_schedule_id);
2130: arp_debug.debug('p_paying_customer_id '|| p_paying_customer_id);
2131: arp_debug.debug('p_paying_site_use_id '|| p_paying_site_use_id);
2132: arp_debug.debug('p_due_date '|| p_due_date);
2133: arp_debug.debug('p_cust_min_rec_amount '|| p_cust_min_rec_amount);
2134: arp_debug.debug('p_bank_min_rec_amount '|| p_bank_min_rec_amount);
2135: arp_debug.debug('p_exception_code '||p_exception_code);
2136: arp_debug.debug('p_additional_message '||p_additional_message);
2137: END IF;

Line 2134: arp_debug.debug('p_bank_min_rec_amount '|| p_bank_min_rec_amount);

2130: arp_debug.debug('p_paying_customer_id '|| p_paying_customer_id);
2131: arp_debug.debug('p_paying_site_use_id '|| p_paying_site_use_id);
2132: arp_debug.debug('p_due_date '|| p_due_date);
2133: arp_debug.debug('p_cust_min_rec_amount '|| p_cust_min_rec_amount);
2134: arp_debug.debug('p_bank_min_rec_amount '|| p_bank_min_rec_amount);
2135: arp_debug.debug('p_exception_code '||p_exception_code);
2136: arp_debug.debug('p_additional_message '||p_additional_message);
2137: END IF;
2138:

Line 2135: arp_debug.debug('p_exception_code '||p_exception_code);

2131: arp_debug.debug('p_paying_site_use_id '|| p_paying_site_use_id);
2132: arp_debug.debug('p_due_date '|| p_due_date);
2133: arp_debug.debug('p_cust_min_rec_amount '|| p_cust_min_rec_amount);
2134: arp_debug.debug('p_bank_min_rec_amount '|| p_bank_min_rec_amount);
2135: arp_debug.debug('p_exception_code '||p_exception_code);
2136: arp_debug.debug('p_additional_message '||p_additional_message);
2137: END IF;
2138:
2139: l_paying_customer_id := p_paying_customer_id;

Line 2136: arp_debug.debug('p_additional_message '||p_additional_message);

2132: arp_debug.debug('p_due_date '|| p_due_date);
2133: arp_debug.debug('p_cust_min_rec_amount '|| p_cust_min_rec_amount);
2134: arp_debug.debug('p_bank_min_rec_amount '|| p_bank_min_rec_amount);
2135: arp_debug.debug('p_exception_code '||p_exception_code);
2136: arp_debug.debug('p_additional_message '||p_additional_message);
2137: END IF;
2138:
2139: l_paying_customer_id := p_paying_customer_id;
2140:

Line 2150: arp_debug.debug('l_request_id '|| pg_request_id );

2146: where cash_receipt_id = p_cash_receipt_id;
2147: END IF;
2148:
2149: IF PG_DEBUG in ('Y','C') THEN
2150: arp_debug.debug('l_request_id '|| pg_request_id );
2151: arp_debug.debug('l_last_updated_by '|| pg_last_updated_by );
2152: arp_debug.debug('l_created_by '|| pg_created_by );
2153: arp_debug.debug('l_last_update_login '|| pg_last_update_login );
2154: arp_debug.debug('l_program_application_id '|| to_char(pg_program_application_id) );

Line 2151: arp_debug.debug('l_last_updated_by '|| pg_last_updated_by );

2147: END IF;
2148:
2149: IF PG_DEBUG in ('Y','C') THEN
2150: arp_debug.debug('l_request_id '|| pg_request_id );
2151: arp_debug.debug('l_last_updated_by '|| pg_last_updated_by );
2152: arp_debug.debug('l_created_by '|| pg_created_by );
2153: arp_debug.debug('l_last_update_login '|| pg_last_update_login );
2154: arp_debug.debug('l_program_application_id '|| to_char(pg_program_application_id) );
2155: arp_debug.debug('l_program_id '|| to_char(pg_program_id) );

Line 2152: arp_debug.debug('l_created_by '|| pg_created_by );

2148:
2149: IF PG_DEBUG in ('Y','C') THEN
2150: arp_debug.debug('l_request_id '|| pg_request_id );
2151: arp_debug.debug('l_last_updated_by '|| pg_last_updated_by );
2152: arp_debug.debug('l_created_by '|| pg_created_by );
2153: arp_debug.debug('l_last_update_login '|| pg_last_update_login );
2154: arp_debug.debug('l_program_application_id '|| to_char(pg_program_application_id) );
2155: arp_debug.debug('l_program_id '|| to_char(pg_program_id) );
2156: END IF;

Line 2153: arp_debug.debug('l_last_update_login '|| pg_last_update_login );

2149: IF PG_DEBUG in ('Y','C') THEN
2150: arp_debug.debug('l_request_id '|| pg_request_id );
2151: arp_debug.debug('l_last_updated_by '|| pg_last_updated_by );
2152: arp_debug.debug('l_created_by '|| pg_created_by );
2153: arp_debug.debug('l_last_update_login '|| pg_last_update_login );
2154: arp_debug.debug('l_program_application_id '|| to_char(pg_program_application_id) );
2155: arp_debug.debug('l_program_id '|| to_char(pg_program_id) );
2156: END IF;
2157:

Line 2154: arp_debug.debug('l_program_application_id '|| to_char(pg_program_application_id) );

2150: arp_debug.debug('l_request_id '|| pg_request_id );
2151: arp_debug.debug('l_last_updated_by '|| pg_last_updated_by );
2152: arp_debug.debug('l_created_by '|| pg_created_by );
2153: arp_debug.debug('l_last_update_login '|| pg_last_update_login );
2154: arp_debug.debug('l_program_application_id '|| to_char(pg_program_application_id) );
2155: arp_debug.debug('l_program_id '|| to_char(pg_program_id) );
2156: END IF;
2157:
2158: INSERT INTO ar_autorec_exceptions

Line 2155: arp_debug.debug('l_program_id '|| to_char(pg_program_id) );

2151: arp_debug.debug('l_last_updated_by '|| pg_last_updated_by );
2152: arp_debug.debug('l_created_by '|| pg_created_by );
2153: arp_debug.debug('l_last_update_login '|| pg_last_update_login );
2154: arp_debug.debug('l_program_application_id '|| to_char(pg_program_application_id) );
2155: arp_debug.debug('l_program_id '|| to_char(pg_program_id) );
2156: END IF;
2157:
2158: INSERT INTO ar_autorec_exceptions
2159: (batch_id,

Line 2201: arp_debug.debug ( 'the rows in exceptions = ' || SQL%ROWCOUNT );

2197: sysdate
2198: FROM DUAL;
2199:
2200: IF PG_DEBUG in ('Y','C') THEN
2201: arp_debug.debug ( 'the rows in exceptions = ' || SQL%ROWCOUNT );
2202: arp_debug.debug ( 'insert_exceptions()-');
2203: END IF;
2204:
2205: EXCEPTION

Line 2202: arp_debug.debug ( 'insert_exceptions()-');

2198: FROM DUAL;
2199:
2200: IF PG_DEBUG in ('Y','C') THEN
2201: arp_debug.debug ( 'the rows in exceptions = ' || SQL%ROWCOUNT );
2202: arp_debug.debug ( 'insert_exceptions()-');
2203: END IF;
2204:
2205: EXCEPTION
2206: WHEN OTHERS THEN

Line 2209: arp_debug.debug ( 'ERROR IN insert_exceptions '||SQLERRM );

2205: EXCEPTION
2206: WHEN OTHERS THEN
2207:
2208: IF PG_DEBUG in ('Y','C') THEN
2209: arp_debug.debug ( 'ERROR IN insert_exceptions '||SQLERRM );
2210: END IF;
2211: END insert_exceptions;
2212:
2213:

Line 2252: arp_debug.debug('SUBMIT_REPORT()+');

2248:
2249:
2250: BEGIN
2251: IF PG_DEBUG in ('Y', 'C') THEN
2252: arp_debug.debug('SUBMIT_REPORT()+');
2253: END IF;
2254:
2255: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
2256: --setting the Org context before calling the conc prg Bug 5519913

Line 2266: arp_debug.debug('Submit Report ...OTHERS');

2262: from ar_batches_all
2263: where batch_id = p_batch_id;
2264: EXCEPTION
2265: when others then
2266: arp_debug.debug('Submit Report ...OTHERS');
2267: l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
2268: END;
2269: end if;
2270:

Line 2286: arp_debug.debug('Request Id :' || l_reqid);

2282: argument6=>'P_REQUEST_ID_MAIN=' || p_request_id
2283: ) ;
2284:
2285: IF PG_DEBUG in ('Y', 'C') THEN
2286: arp_debug.debug('Request Id :' || l_reqid);
2287: END IF;
2288:
2289: arp_debug.debug (' COMMITING WORK ');
2290: commit; -- This is there to commit the conc request.

Line 2289: arp_debug.debug (' COMMITING WORK ');

2285: IF PG_DEBUG in ('Y', 'C') THEN
2286: arp_debug.debug('Request Id :' || l_reqid);
2287: END IF;
2288:
2289: arp_debug.debug (' COMMITING WORK ');
2290: commit; -- This is there to commit the conc request.
2291:
2292: l_complete := FND_CONCURRENT.WAIT_FOR_REQUEST(
2293: request_id => l_reqid,

Line 2304: arp_debug.debug('SUBMIT_REPORT()-');

2300: message => l_message);
2301:
2302:
2303: IF PG_DEBUG in ('Y', 'C') THEN
2304: arp_debug.debug('SUBMIT_REPORT()-');
2305: END IF;
2306:
2307: EXCEPTION
2308: WHEN OTHERS THEN

Line 2310: arp_debug.debug('Submitting the report.iN ERROR.'||SQLERRM);

2306:
2307: EXCEPTION
2308: WHEN OTHERS THEN
2309: IF PG_DEBUG in ('Y', 'C') THEN
2310: arp_debug.debug('Submitting the report.iN ERROR.'||SQLERRM);
2311: END IF;
2312: RAISE;
2313: END SUBMIT_REPORT;
2314:

Line 2324: arp_debug.debug('rec_reset()+');

2320:
2321:
2322: BEGIN
2323: IF PG_DEBUG in ('Y', 'C') THEN
2324: arp_debug.debug('rec_reset()+');
2325: END IF;
2326:
2327:
2328: IF p_pay_process_fail = 'Y' THEN

Line 2429: arp_debug.debug('l_called_from'|| l_called_from);

2425:
2426: BEGIN
2427:
2428: IF PG_DEBUG in ('Y', 'C') THEN
2429: arp_debug.debug('l_called_from'|| l_called_from);
2430: arp_debug.debug('Calling UNAPP ()+');
2431: END IF;
2432:
2433: FOR PS in UNAPP LOOP

Line 2430: arp_debug.debug('Calling UNAPP ()+');

2426: BEGIN
2427:
2428: IF PG_DEBUG in ('Y', 'C') THEN
2429: arp_debug.debug('l_called_from'|| l_called_from);
2430: arp_debug.debug('Calling UNAPP ()+');
2431: END IF;
2432:
2433: FOR PS in UNAPP LOOP
2434: /* INITILIAZE the OUT variables */

Line 2457: arp_debug.debug('x_return_status: '||ul_return_status);

2453: p_called_from => l_called_from,
2454: p_org_id => ps.org_id
2455: );
2456:
2457: arp_debug.debug('x_return_status: '||ul_return_status);
2458:
2459: IF ul_return_status <> 'S' THEN
2460:
2461: IF ul_msg_count = 1 Then

Line 2462: arp_debug.debug('ul_msg_data '||ul_msg_data);

2458:
2459: IF ul_return_status <> 'S' THEN
2460:
2461: IF ul_msg_count = 1 Then
2462: arp_debug.debug('ul_msg_data '||ul_msg_data);
2463: ELSIF ul_msg_count > 1 Then
2464: LOOP
2465: IF nvl(ul_count,0) < ul_msg_count THEN
2466: ul_count := nvl(ul_count,0) +1 ;

Line 2469: arp_debug.debug ( 'the number is ' || ul_count );

2465: IF nvl(ul_count,0) < ul_msg_count THEN
2466: ul_count := nvl(ul_count,0) +1 ;
2467: ul_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2468:
2469: arp_debug.debug ( 'the number is ' || ul_count );
2470: arp_debug.debug ( 'the message data is ' || ul_msg_data );
2471: ELSE
2472: EXIT;
2473: END IF;

Line 2470: arp_debug.debug ( 'the message data is ' || ul_msg_data );

2466: ul_count := nvl(ul_count,0) +1 ;
2467: ul_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2468:
2469: arp_debug.debug ( 'the number is ' || ul_count );
2470: arp_debug.debug ( 'the message data is ' || ul_msg_data );
2471: ELSE
2472: EXIT;
2473: END IF;
2474: END LOOP;

Line 2482: arp_debug.debug('Exception :In the UNAPPLY routine '|| SQLERRM);

2478:
2479: EXCEPTION
2480: WHEN others THEN
2481: IF PG_DEBUG in ('Y', 'C') THEN
2482: arp_debug.debug('Exception :In the UNAPPLY routine '|| SQLERRM);
2483: END IF;
2484:
2485: END ;
2486:

Line 2488: arp_debug.debug('delete the bad receipts');

2484:
2485: END ;
2486:
2487: /* end unapply */
2488: arp_debug.debug('delete the bad receipts');
2489:
2490: /* Start of delete XLA events code. Doing this is bulk */
2491: Begin
2492: IF PG_DEBUG in ('Y','C') THEN

Line 2493: arp_debug.debug ( 'Start calling xla delete_bulk_events');

2489:
2490: /* Start of delete XLA events code. Doing this is bulk */
2491: Begin
2492: IF PG_DEBUG in ('Y','C') THEN
2493: arp_debug.debug ( 'Start calling xla delete_bulk_events');
2494: arp_debug.debug ( 'Inserting into xla_events_int_gt...');
2495: END IF;
2496:
2497: INSERT INTO xla_events_int_gt

Line 2494: arp_debug.debug ( 'Inserting into xla_events_int_gt...');

2490: /* Start of delete XLA events code. Doing this is bulk */
2491: Begin
2492: IF PG_DEBUG in ('Y','C') THEN
2493: arp_debug.debug ( 'Start calling xla delete_bulk_events');
2494: arp_debug.debug ( 'Inserting into xla_events_int_gt...');
2495: END IF;
2496:
2497: INSERT INTO xla_events_int_gt
2498: (event_id

Line 2562: arp_debug.debug ( 'rows inserted into xla gt table = '|| sql%rowcount);

2558: from ar_autorec_exceptions
2559: where request_id = pg_request_id));
2560:
2561: IF PG_DEBUG in ('Y','C') THEN
2562: arp_debug.debug ( 'rows inserted into xla gt table = '|| sql%rowcount);
2563: arp_debug.debug ( 'Calling xla_events_pub_pkg.delete_bulk_events()');
2564: END IF;
2565:
2566: xla_events_pub_pkg.delete_bulk_events(222);

Line 2563: arp_debug.debug ( 'Calling xla_events_pub_pkg.delete_bulk_events()');

2559: where request_id = pg_request_id));
2560:
2561: IF PG_DEBUG in ('Y','C') THEN
2562: arp_debug.debug ( 'rows inserted into xla gt table = '|| sql%rowcount);
2563: arp_debug.debug ( 'Calling xla_events_pub_pkg.delete_bulk_events()');
2564: END IF;
2565:
2566: xla_events_pub_pkg.delete_bulk_events(222);
2567:

Line 2569: arp_debug.debug ( 'End calling xla delete_bulk_events');

2565:
2566: xla_events_pub_pkg.delete_bulk_events(222);
2567:
2568: IF PG_DEBUG in ('Y','C') THEN
2569: arp_debug.debug ( 'End calling xla delete_bulk_events');
2570: END IF;
2571:
2572: EXCEPTION
2573: WHEN OTHERS THEN

Line 2575: arp_debug.debug('Error in call to xla_events_pub_pkg.delete_bulk_events ' || sqlerrm);

2571:
2572: EXCEPTION
2573: WHEN OTHERS THEN
2574: IF PG_DEBUG in ('Y', 'C') THEN
2575: arp_debug.debug('Error in call to xla_events_pub_pkg.delete_bulk_events ' || sqlerrm);
2576: END IF;
2577: END;
2578: /* End of delete XLA events code */
2579:

Line 2596: arp_debug.debug ( ' rows updated PS = ' || SQL%ROWCOUNT );

2592: AND trx.customer_trx_id = ps.customer_trx_id
2593: and trx.cc_error_flag = 'Y');
2594:
2595: IF PG_DEBUG in ('Y','C') THEN
2596: arp_debug.debug ( ' rows updated PS = ' || SQL%ROWCOUNT );
2597: END IF;
2598:
2599: delete
2600: from ar_payment_schedules

Line 2609: arp_debug.debug ( ' rows DELETED PS = ' || SQL%ROWCOUNT );

2605: where r.gt_id = p_gt_id
2606: AND r.cash_receipt_id = ex.cash_receipt_id);
2607:
2608: IF PG_DEBUG in ('Y','C') THEN
2609: arp_debug.debug ( ' rows DELETED PS = ' || SQL%ROWCOUNT );
2610: END IF;
2611:
2612: delete
2613: from ar_distributions

Line 2628: arp_debug.debug ( ' rows DELETED AR_DIST = ' || SQL%ROWCOUNT );

2624: )
2625: );
2626:
2627: IF PG_DEBUG in ('Y','C') THEN
2628: arp_debug.debug ( ' rows DELETED AR_DIST = ' || SQL%ROWCOUNT );
2629: END IF;
2630:
2631: delete
2632: from ar_distributions

Line 2647: arp_debug.debug ( ' rows DELETED AR_DIST2 = ' || SQL%ROWCOUNT );

2643: )
2644: );
2645:
2646: IF PG_DEBUG in ('Y','C') THEN
2647: arp_debug.debug ( ' rows DELETED AR_DIST2 = ' || SQL%ROWCOUNT );
2648: END IF;
2649:
2650: delete
2651: from ar_receivable_applications

Line 2660: arp_debug.debug ( ' rows DELETED REC_APPS = ' || SQL%ROWCOUNT );

2656: where r.gt_id = p_gt_id
2657: AND r.cash_receipt_id = ex.cash_receipt_id);
2658:
2659: IF PG_DEBUG in ('Y','C') THEN
2660: arp_debug.debug ( ' rows DELETED REC_APPS = ' || SQL%ROWCOUNT );
2661: END IF;
2662:
2663: delete
2664: from ar_cash_receipt_history

Line 2673: arp_debug.debug ( ' rows DELETED CRH = ' || SQL%ROWCOUNT );

2669: where r.gt_id = p_gt_id
2670: AND r.cash_receipt_id = ex.cash_receipt_id);
2671:
2672: IF PG_DEBUG in ('Y','C') THEN
2673: arp_debug.debug ( ' rows DELETED CRH = ' || SQL%ROWCOUNT );
2674: END IF;
2675:
2676: delete from ar_cash_receipts
2677: where cash_receipt_id in

Line 2685: arp_debug.debug ( ' rows DELETED CR = ' || SQL%ROWCOUNT );

2681: where r.gt_id = p_gt_id
2682: AND r.cash_receipt_id = ex.cash_receipt_id);
2683:
2684: IF PG_DEBUG in ('Y','C') THEN
2685: arp_debug.debug ( ' rows DELETED CR = ' || SQL%ROWCOUNT );
2686: END IF;
2687:
2688: END IF;
2689:

Line 2691: arp_debug.debug('rec_reset()-');

2687:
2688: END IF;
2689:
2690: IF PG_DEBUG in ('Y', 'C') THEN
2691: arp_debug.debug('rec_reset()-');
2692: END IF;
2693:
2694: EXCEPTION
2695: WHEN OTHERS THEN

Line 2697: arp_debug.debug('rec_reset .iN ERROR.'||SQLERRM);

2693:
2694: EXCEPTION
2695: WHEN OTHERS THEN
2696: IF PG_DEBUG in ('Y', 'C') THEN
2697: arp_debug.debug('rec_reset .iN ERROR.'||SQLERRM);
2698: END IF;
2699:
2700: insert_exceptions( p_batch_id => nvl(g_batch_id, -333),
2701: p_request_id => pg_request_id,

Line 2726: arp_debug.debug(FND_FILE.LOG,'Submitting the report..');

2722:
2723: BEGIN
2724:
2725: IF PG_DEBUG in ('Y', 'C') THEN
2726: arp_debug.debug(FND_FILE.LOG,'Submitting the report..');
2727: END IF;
2728:
2729: --setting the Org context before calling the conc prg Bug 5519913
2730: l_org_id := mo_global.get_current_org_id;

Line 2740: arp_debug.debug('Submit Format ...OTHERS');

2736: from ar_batches_all
2737: where batch_id = p_batch_id;
2738: EXCEPTION
2739: WHEN OTHERS THEN
2740: arp_debug.debug('Submit Format ...OTHERS');
2741: l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
2742: END;
2743: END IF;
2744:

Line 2818: arp_debug.debug('Format Program has a phase '||dev_phase);

2814: dev_status =>dev_status,
2815: message =>message);
2816:
2817: IF dev_phase <> 'COMPLETE' THEN
2818: arp_debug.debug('Format Program has a phase '||dev_phase);
2819: update ar_batches
2820: SET batch_applied_status = 'COMPLETED_APPROVAL'
2821: where batch_id = p_batch_id;
2822: ELSIF dev_phase = 'COMPLETE' AND

Line 2824: arp_debug.debug('Format Program completed with status '||dev_status);

2820: SET batch_applied_status = 'COMPLETED_APPROVAL'
2821: where batch_id = p_batch_id;
2822: ELSIF dev_phase = 'COMPLETE' AND
2823: dev_status <> 'NORMAL' THEN
2824: arp_debug.debug('Format Program completed with status '||dev_status);
2825: update ar_batches
2826: SET batch_applied_status = 'COMPLETED_APPROVAL'
2827: where batch_id = p_batch_id;
2828: ELSE

Line 2829: arp_debug.debug('Format Program completed successfully');

2825: update ar_batches
2826: SET batch_applied_status = 'COMPLETED_APPROVAL'
2827: where batch_id = p_batch_id;
2828: ELSE
2829: arp_debug.debug('Format Program completed successfully');
2830: update ar_batches
2831: SET batch_applied_status = 'COMPLETED_FORMAT'
2832: where batch_id = p_batch_id;
2833: END IF;

Line 2838: arp_debug.debug('Request Id :' || l_reqid);

2834:
2835: commit; -- This is there to commit the Format status.
2836:
2837: IF PG_DEBUG in ('Y', 'C') THEN
2838: arp_debug.debug('Request Id :' || l_reqid);
2839: END IF;
2840:
2841: EXCEPTION
2842: WHEN OTHERS THEN

Line 2844: arp_debug.debug('Exception in SUBMIT_FORMAT '||SQLERRM);

2840:
2841: EXCEPTION
2842: WHEN OTHERS THEN
2843: IF PG_DEBUG in ('Y', 'C') THEN
2844: arp_debug.debug('Exception in SUBMIT_FORMAT '||SQLERRM);
2845: END IF;
2846: RAISE;
2847: END SUBMIT_FORMAT;
2848:

Line 2879: arp_debug.debug('create_receipt()+');

2875:
2876: BEGIN
2877:
2878: IF PG_DEBUG in ('Y', 'C') THEN
2879: arp_debug.debug('create_receipt()+');
2880: arp_debug.debug('l_called_from'|| p_called_from);
2881: arp_debug.debug('Calling create_cash API ()+');
2882: END IF;
2883:

Line 2880: arp_debug.debug('l_called_from'|| p_called_from);

2876: BEGIN
2877:
2878: IF PG_DEBUG in ('Y', 'C') THEN
2879: arp_debug.debug('create_receipt()+');
2880: arp_debug.debug('l_called_from'|| p_called_from);
2881: arp_debug.debug('Calling create_cash API ()+');
2882: END IF;
2883:
2884: AR_RECEIPT_API_PUB.create_cash (p_api_version => 1.0,

Line 2881: arp_debug.debug('Calling create_cash API ()+');

2877:
2878: IF PG_DEBUG in ('Y', 'C') THEN
2879: arp_debug.debug('create_receipt()+');
2880: arp_debug.debug('l_called_from'|| p_called_from);
2881: arp_debug.debug('Calling create_cash API ()+');
2882: END IF;
2883:
2884: AR_RECEIPT_API_PUB.create_cash (p_api_version => 1.0,
2885: p_init_msg_list => FND_API.G_TRUE,

Line 2909: arp_debug.debug('x_return_status: '||p_return_status);

2905: p_cr_id => p_cash_receipt_id,
2906: p_called_from => p_called_from );
2907:
2908: IF PG_DEBUG in ('Y', 'C') THEN
2909: arp_debug.debug('x_return_status: '||p_return_status);
2910: END IF;
2911:
2912: --check for the exceptions raised
2913: IF p_return_status <> 'S' THEN

Line 2916: arp_debug.debug('p_msg_count: '||p_msg_count);

2912: --check for the exceptions raised
2913: IF p_return_status <> 'S' THEN
2914:
2915: IF p_msg_count = 1 THEN
2916: arp_debug.debug('p_msg_count: '||p_msg_count);
2917: arp_debug.debug('p_msg_data: '||p_msg_data);
2918:
2919: IF p_msg_data IS NULL THEN
2920: p_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);

Line 2917: arp_debug.debug('p_msg_data: '||p_msg_data);

2913: IF p_return_status <> 'S' THEN
2914:
2915: IF p_msg_count = 1 THEN
2916: arp_debug.debug('p_msg_count: '||p_msg_count);
2917: arp_debug.debug('p_msg_data: '||p_msg_data);
2918:
2919: IF p_msg_data IS NULL THEN
2920: p_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2921: END IF;

Line 2930: arp_debug.debug('p_msg_count: '||p_msg_count);

2926: p_exception_code => 'AUTORECERR',
2927: p_additional_message => p_msg_count||'.'||p_msg_data );
2928:
2929: ELSIF p_msg_count > 1 THEN
2930: arp_debug.debug('p_msg_count: '||p_msg_count);
2931: arp_debug.debug('p_msg_data: '||p_msg_data);
2932: p_msg_data := NULL;
2933: LOOP
2934: IF nvl(l_count, 0) < p_msg_count THEN

Line 2931: arp_debug.debug('p_msg_data: '||p_msg_data);

2927: p_additional_message => p_msg_count||'.'||p_msg_data );
2928:
2929: ELSIF p_msg_count > 1 THEN
2930: arp_debug.debug('p_msg_count: '||p_msg_count);
2931: arp_debug.debug('p_msg_data: '||p_msg_data);
2932: p_msg_data := NULL;
2933: LOOP
2934: IF nvl(l_count, 0) < p_msg_count THEN
2935: l_count := nvl(l_count,0) +1 ;

Line 2938: arp_debug.debug ( 'the number is ' || l_count );

2934: IF nvl(l_count, 0) < p_msg_count THEN
2935: l_count := nvl(l_count,0) +1 ;
2936: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2937:
2938: arp_debug.debug ( 'the number is ' || l_count );
2939: arp_debug.debug ( 'the message data is ' || l_msg_data );
2940: IF length(p_msg_data||l_count||'.'||l_msg_data||' ') < 2000 THEN
2941: p_msg_data := p_msg_data||l_count||'.'||l_msg_data||' ';
2942: END IF;

Line 2939: arp_debug.debug ( 'the message data is ' || l_msg_data );

2935: l_count := nvl(l_count,0) +1 ;
2936: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2937:
2938: arp_debug.debug ( 'the number is ' || l_count );
2939: arp_debug.debug ( 'the message data is ' || l_msg_data );
2940: IF length(p_msg_data||l_count||'.'||l_msg_data||' ') < 2000 THEN
2941: p_msg_data := p_msg_data||l_count||'.'||l_msg_data||' ';
2942: END IF;
2943:

Line 2957: arp_debug.debug('create_receipt()-');

2953: END IF;
2954: END IF; /* end of return status */
2955:
2956: IF PG_DEBUG in ('Y', 'C') THEN
2957: arp_debug.debug('create_receipt()-');
2958: END IF;
2959:
2960: EXCEPTION
2961: WHEN OTHERS THEN

Line 2962: arp_debug.debug('create_receipt : error code() '|| to_char(SQLCODE));

2958: END IF;
2959:
2960: EXCEPTION
2961: WHEN OTHERS THEN
2962: arp_debug.debug('create_receipt : error code() '|| to_char(SQLCODE));
2963:
2964: insert_exceptions( p_batch_id => p_batch_id,
2965: p_request_id => p_request_id,
2966: p_paying_customer_id => p_customer_id,

Line 2986: arp_debug.debug('AR_AUTOREC_API.receipt_application()+');

2982: l_count NUMBER;
2983: BEGIN
2984:
2985: IF PG_DEBUG in ('Y', 'C') THEN
2986: arp_debug.debug('AR_AUTOREC_API.receipt_application()+');
2987: arp_debug.debug('l_called_from '|| p_called_from);
2988: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);
2989: arp_debug.debug('p_applied_ps_id '|| p_applied_ps_id);
2990: arp_debug.debug('p_amount_applied '|| p_amount_applied);

Line 2987: arp_debug.debug('l_called_from '|| p_called_from);

2983: BEGIN
2984:
2985: IF PG_DEBUG in ('Y', 'C') THEN
2986: arp_debug.debug('AR_AUTOREC_API.receipt_application()+');
2987: arp_debug.debug('l_called_from '|| p_called_from);
2988: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);
2989: arp_debug.debug('p_applied_ps_id '|| p_applied_ps_id);
2990: arp_debug.debug('p_amount_applied '|| p_amount_applied);
2991: arp_debug.debug('p_batch_id '|| p_batch_id);

Line 2988: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);

2984:
2985: IF PG_DEBUG in ('Y', 'C') THEN
2986: arp_debug.debug('AR_AUTOREC_API.receipt_application()+');
2987: arp_debug.debug('l_called_from '|| p_called_from);
2988: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);
2989: arp_debug.debug('p_applied_ps_id '|| p_applied_ps_id);
2990: arp_debug.debug('p_amount_applied '|| p_amount_applied);
2991: arp_debug.debug('p_batch_id '|| p_batch_id);
2992: END IF;

Line 2989: arp_debug.debug('p_applied_ps_id '|| p_applied_ps_id);

2985: IF PG_DEBUG in ('Y', 'C') THEN
2986: arp_debug.debug('AR_AUTOREC_API.receipt_application()+');
2987: arp_debug.debug('l_called_from '|| p_called_from);
2988: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);
2989: arp_debug.debug('p_applied_ps_id '|| p_applied_ps_id);
2990: arp_debug.debug('p_amount_applied '|| p_amount_applied);
2991: arp_debug.debug('p_batch_id '|| p_batch_id);
2992: END IF;
2993:

Line 2990: arp_debug.debug('p_amount_applied '|| p_amount_applied);

2986: arp_debug.debug('AR_AUTOREC_API.receipt_application()+');
2987: arp_debug.debug('l_called_from '|| p_called_from);
2988: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);
2989: arp_debug.debug('p_applied_ps_id '|| p_applied_ps_id);
2990: arp_debug.debug('p_amount_applied '|| p_amount_applied);
2991: arp_debug.debug('p_batch_id '|| p_batch_id);
2992: END IF;
2993:
2994: AR_RECEIPT_API_PUB.apply ( p_api_version => 1.0,

Line 2991: arp_debug.debug('p_batch_id '|| p_batch_id);

2987: arp_debug.debug('l_called_from '|| p_called_from);
2988: arp_debug.debug('p_cash_receipt_id '|| p_cash_receipt_id);
2989: arp_debug.debug('p_applied_ps_id '|| p_applied_ps_id);
2990: arp_debug.debug('p_amount_applied '|| p_amount_applied);
2991: arp_debug.debug('p_batch_id '|| p_batch_id);
2992: END IF;
2993:
2994: AR_RECEIPT_API_PUB.apply ( p_api_version => 1.0,
2995: p_init_msg_list => FND_API.G_TRUE,

Line 3008: arp_debug.debug('x_return_status: '||p_return_status);

3004: p_apply_date => p_apply_date,
3005: p_called_from => p_called_from );
3006:
3007: IF PG_DEBUG in ('Y', 'C') THEN
3008: arp_debug.debug('x_return_status: '||p_return_status);
3009: END IF;
3010:
3011: IF p_return_status <> 'S' THEN
3012:

Line 3014: arp_debug.debug('al_msg_data '||l_msg_data);

3010:
3011: IF p_return_status <> 'S' THEN
3012:
3013: IF l_msg_count = 1 Then
3014: arp_debug.debug('al_msg_data '||l_msg_data);
3015: l_msg_data := 'Application failure. You need to nullify the SELECTED FOR RECEIPT BATCH ID on the invoice'||
3016: ' when the invoice is fixed. Then apply the invoice manually to the receipt'||
3017: ' with receipt id: '||p_cash_receipt_id||', created by automatic receipts for that invoice';
3018:

Line 3037: arp_debug.debug ( 'the number is ' || l_count );

3033: ' with receipt id: '||p_cash_receipt_id||', created by automatic receipts for that invoice';
3034: ELSE
3035: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
3036: END IF;
3037: arp_debug.debug ( 'the number is ' || l_count );
3038: arp_debug.debug ( 'the message data is ' || l_msg_data );
3039:
3040: insert_exceptions( p_batch_id => p_batch_id,
3041: p_request_id => p_request_id,

Line 3038: arp_debug.debug ( 'the message data is ' || l_msg_data );

3034: ELSE
3035: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
3036: END IF;
3037: arp_debug.debug ( 'the number is ' || l_count );
3038: arp_debug.debug ( 'the message data is ' || l_msg_data );
3039:
3040: insert_exceptions( p_batch_id => p_batch_id,
3041: p_request_id => p_request_id,
3042: p_payment_schedule_id => p_applied_ps_id,

Line 3053: arp_debug.debug('p_return_status :'|| p_return_status);

3049: END IF;
3050: END IF; /* end of return status */
3051:
3052: IF PG_DEBUG in ('Y', 'C') THEN
3053: arp_debug.debug('p_return_status :'|| p_return_status);
3054: arp_debug.debug('AR_AUTOREC_API.receipt_application()-');
3055: END IF;
3056:
3057: EXCEPTION

Line 3054: arp_debug.debug('AR_AUTOREC_API.receipt_application()-');

3050: END IF; /* end of return status */
3051:
3052: IF PG_DEBUG in ('Y', 'C') THEN
3053: arp_debug.debug('p_return_status :'|| p_return_status);
3054: arp_debug.debug('AR_AUTOREC_API.receipt_application()-');
3055: END IF;
3056:
3057: EXCEPTION
3058: WHEN OTHERS THEN

Line 3059: arp_debug.debug('Exception OTHERS : AR_AUTOREC_API.receipt_application : error code() '|| to_char(SQLCODE));

3055: END IF;
3056:
3057: EXCEPTION
3058: WHEN OTHERS THEN
3059: arp_debug.debug('Exception OTHERS : AR_AUTOREC_API.receipt_application : error code() '|| to_char(SQLCODE));
3060:
3061: insert_exceptions( p_batch_id => p_batch_id,
3062: p_request_id => p_request_id,
3063: p_payment_schedule_id => p_applied_ps_id,

Line 3089: arp_debug.debug('AR_AUTOREC_API.process_payments()+');

3085: l_first_msg VARCHAR2(240);
3086: /* Bug 7639165 - Declaration End. */
3087: BEGIN
3088: IF PG_DEBUG in ('Y', 'C') THEN
3089: arp_debug.debug('AR_AUTOREC_API.process_payments()+');
3090: arp_debug.debug('p_cash_receipt_id :'||p_cash_receipt_id);
3091: END IF;
3092:
3093: select payment_trxn_extension_id

Line 3090: arp_debug.debug('p_cash_receipt_id :'||p_cash_receipt_id);

3086: /* Bug 7639165 - Declaration End. */
3087: BEGIN
3088: IF PG_DEBUG in ('Y', 'C') THEN
3089: arp_debug.debug('AR_AUTOREC_API.process_payments()+');
3090: arp_debug.debug('p_cash_receipt_id :'||p_cash_receipt_id);
3091: END IF;
3092:
3093: select payment_trxn_extension_id
3094: into l_pmt_trxn_id

Line 3099: arp_debug.debug('l_pmt_trxn_id :'||l_pmt_trxn_id);

3095: from ar_cash_receipts
3096: where cash_receipt_id = p_cash_receipt_id;
3097:
3098: IF PG_DEBUG in ('Y', 'C') THEN
3099: arp_debug.debug('l_pmt_trxn_id :'||l_pmt_trxn_id);
3100: END IF;
3101:
3102: AR_RECEIPT_API_PUB.Process_Payment_1(
3103: p_cash_receipt_id => p_cash_receipt_id,

Line 3112: arp_debug.debug('Process_payment return status: ' || p_return_status);

3108: x_return_status => p_return_status,
3109: p_payment_trxn_extension_id => l_pmt_trxn_id);
3110:
3111: IF PG_DEBUG in ('Y', 'C') THEN
3112: arp_debug.debug('Process_payment return status: ' || p_return_status);
3113: END IF;
3114:
3115: /*------------------------------------------------------+
3116: | Check the return status from Process_Payment |

Line 3121: arp_debug.debug('l_msg_data '||l_msg_data);

3117: +------------------------------------------------------*/
3118: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3119:
3120: IF l_msg_count = 1 Then
3121: arp_debug.debug('l_msg_data '||l_msg_data);
3122:
3123: insert_exceptions( p_batch_id => p_batch_id,
3124: p_request_id => p_request_id,
3125: p_cash_receipt_id => p_cash_receipt_id,

Line 3139: arp_debug.debug ( 'the number is ' || l_count );

3135: IF nvl(l_count,0) < l_msg_count THEN
3136: l_count := nvl(l_count,0) +1 ;
3137: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
3138:
3139: arp_debug.debug ( 'the number is ' || l_count );
3140: arp_debug.debug ( 'the message data is ' || l_msg_data );
3141:
3142: /* Bug 7639165 - Changes Begin. */
3143: IF l_count = 2 THEN

Line 3140: arp_debug.debug ( 'the message data is ' || l_msg_data );

3136: l_count := nvl(l_count,0) +1 ;
3137: l_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
3138:
3139: arp_debug.debug ( 'the number is ' || l_count );
3140: arp_debug.debug ( 'the message data is ' || l_msg_data );
3141:
3142: /* Bug 7639165 - Changes Begin. */
3143: IF l_count = 2 THEN
3144: l_first_msg := l_msg_data;

Line 3164: arp_debug.debug('AR_AUTOREC_API.process_payments()-');

3160: END IF;
3161: END IF;
3162:
3163: IF PG_DEBUG in ('Y', 'C') THEN
3164: arp_debug.debug('AR_AUTOREC_API.process_payments()-');
3165: END IF;
3166:
3167: EXCEPTION
3168: WHEN OTHERS THEN

Line 3169: arp_debug.debug('AR_AUTOREC_API.process_payments : error code() '|| to_char(SQLCODE));

3165: END IF;
3166:
3167: EXCEPTION
3168: WHEN OTHERS THEN
3169: arp_debug.debug('AR_AUTOREC_API.process_payments : error code() '|| to_char(SQLCODE));
3170: insert_exceptions( p_batch_id => p_batch_id,
3171: p_request_id => p_request_id,
3172: p_cash_receipt_id => p_cash_receipt_id,
3173: p_exception_code => 'AR_CC_AUTH_FAILED',

Line 3199: arp_debug.debug('update_ar_receipts_gt()+');

3195: l_dummy NUMBER;
3196:
3197: BEGIN
3198: IF PG_DEBUG in ('Y', 'C') THEN
3199: arp_debug.debug('update_ar_receipts_gt()+');
3200: arp_debug.debug('p_creation_rule '||p_creation_rule);
3201: arp_debug.debug('p_update_stmt '||p_update_stmt);
3202: END IF;
3203:

Line 3200: arp_debug.debug('p_creation_rule '||p_creation_rule);

3196:
3197: BEGIN
3198: IF PG_DEBUG in ('Y', 'C') THEN
3199: arp_debug.debug('update_ar_receipts_gt()+');
3200: arp_debug.debug('p_creation_rule '||p_creation_rule);
3201: arp_debug.debug('p_update_stmt '||p_update_stmt);
3202: END IF;
3203:
3204: l_update_cursor := dbms_sql.open_cursor;

Line 3201: arp_debug.debug('p_update_stmt '||p_update_stmt);

3197: BEGIN
3198: IF PG_DEBUG in ('Y', 'C') THEN
3199: arp_debug.debug('update_ar_receipts_gt()+');
3200: arp_debug.debug('p_creation_rule '||p_creation_rule);
3201: arp_debug.debug('p_update_stmt '||p_update_stmt);
3202: END IF;
3203:
3204: l_update_cursor := dbms_sql.open_cursor;
3205:

Line 3257: arp_debug.debug('Rows updated :'||SQL%ROWCOUNT);

3253:
3254: dbms_sql.close_cursor(l_update_cursor);
3255:
3256: IF PG_DEBUG in ('Y', 'C') THEN
3257: arp_debug.debug('Rows updated :'||SQL%ROWCOUNT);
3258: arp_debug.debug('update_ar_receipts_gt()-');
3259: END IF;
3260:
3261: EXCEPTION

Line 3258: arp_debug.debug('update_ar_receipts_gt()-');

3254: dbms_sql.close_cursor(l_update_cursor);
3255:
3256: IF PG_DEBUG in ('Y', 'C') THEN
3257: arp_debug.debug('Rows updated :'||SQL%ROWCOUNT);
3258: arp_debug.debug('update_ar_receipts_gt()-');
3259: END IF;
3260:
3261: EXCEPTION
3262: WHEN OTHERS THEN

Line 3266: arp_debug.debug('update_ar_receipts_gt : error code() '|| to_char(SQLCODE));

3262: WHEN OTHERS THEN
3263: if dbms_sql.is_open(l_update_cursor) then
3264: dbms_sql.close_cursor(l_update_cursor);
3265: end if;
3266: arp_debug.debug('update_ar_receipts_gt : error code() '|| to_char(SQLCODE));
3267:
3268: insert_exceptions( p_batch_id => NVL(g_batch_id, -333),
3269: p_request_id => arp_standard.profile.request_id,
3270: p_exception_code => 'AUTORECERR',

Line 3286: arp_debug.debug('build_queries()+');

3282: l_update_where_clause VARCHAR2(2000);
3283:
3284: BEGIN
3285: IF PG_DEBUG in ('Y', 'C') THEN
3286: arp_debug.debug('build_queries()+');
3287: arp_debug.debug('p_creation_rule '||p_creation_rule);
3288: arp_debug.debug('p_approval_mode '||p_approval_mode);
3289: END IF;
3290:

Line 3287: arp_debug.debug('p_creation_rule '||p_creation_rule);

3283:
3284: BEGIN
3285: IF PG_DEBUG in ('Y', 'C') THEN
3286: arp_debug.debug('build_queries()+');
3287: arp_debug.debug('p_creation_rule '||p_creation_rule);
3288: arp_debug.debug('p_approval_mode '||p_approval_mode);
3289: END IF;
3290:
3291: p_update_stmt := 'UPDATE /*+INDEX(ar_receipts_gt AR_RECEIPTS_GT_N2)*/ '||

Line 3288: arp_debug.debug('p_approval_mode '||p_approval_mode);

3284: BEGIN
3285: IF PG_DEBUG in ('Y', 'C') THEN
3286: arp_debug.debug('build_queries()+');
3287: arp_debug.debug('p_creation_rule '||p_creation_rule);
3288: arp_debug.debug('p_approval_mode '||p_approval_mode);
3289: END IF;
3290:
3291: p_update_stmt := 'UPDATE /*+INDEX(ar_receipts_gt AR_RECEIPTS_GT_N2)*/ '||
3292: ' ar_receipts_gt '||

Line 3771: arp_debug.debug('p_create_query '||p_create_query);

3767:
3768: p_update_stmt := p_update_stmt || l_update_where_clause;
3769:
3770: IF PG_DEBUG in ('Y', 'C') THEN
3771: arp_debug.debug('p_create_query '||p_create_query);
3772: arp_debug.debug('p_update_stmt '||p_update_stmt);
3773: arp_debug.debug('p_inv_rct_mp_qry '||p_inv_rct_mp_qry);
3774: arp_debug.debug('build_queries()-');
3775: END IF;

Line 3772: arp_debug.debug('p_update_stmt '||p_update_stmt);

3768: p_update_stmt := p_update_stmt || l_update_where_clause;
3769:
3770: IF PG_DEBUG in ('Y', 'C') THEN
3771: arp_debug.debug('p_create_query '||p_create_query);
3772: arp_debug.debug('p_update_stmt '||p_update_stmt);
3773: arp_debug.debug('p_inv_rct_mp_qry '||p_inv_rct_mp_qry);
3774: arp_debug.debug('build_queries()-');
3775: END IF;
3776:

Line 3773: arp_debug.debug('p_inv_rct_mp_qry '||p_inv_rct_mp_qry);

3769:
3770: IF PG_DEBUG in ('Y', 'C') THEN
3771: arp_debug.debug('p_create_query '||p_create_query);
3772: arp_debug.debug('p_update_stmt '||p_update_stmt);
3773: arp_debug.debug('p_inv_rct_mp_qry '||p_inv_rct_mp_qry);
3774: arp_debug.debug('build_queries()-');
3775: END IF;
3776:
3777: EXCEPTION

Line 3774: arp_debug.debug('build_queries()-');

3770: IF PG_DEBUG in ('Y', 'C') THEN
3771: arp_debug.debug('p_create_query '||p_create_query);
3772: arp_debug.debug('p_update_stmt '||p_update_stmt);
3773: arp_debug.debug('p_inv_rct_mp_qry '||p_inv_rct_mp_qry);
3774: arp_debug.debug('build_queries()-');
3775: END IF;
3776:
3777: EXCEPTION
3778: WHEN OTHERS THEN

Line 3779: arp_debug.debug('build_queries : error code() '|| to_char(SQLCODE));

3775: END IF;
3776:
3777: EXCEPTION
3778: WHEN OTHERS THEN
3779: arp_debug.debug('build_queries : error code() '|| to_char(SQLCODE));
3780: raise;
3781: END build_queries;
3782:
3783:

Line 3798: arp_debug.debug('populate_receipt_numbers()+');

3794: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE;
3795: l_doc_sequence_id ra_customer_trx.doc_sequence_id%TYPE;
3796: BEGIN
3797: IF PG_DEBUG in ('Y', 'C') THEN
3798: arp_debug.debug('populate_receipt_numbers()+');
3799: arp_debug.debug('p_rcpt_method_name :'||p_rcpt_method_name);
3800: arp_debug.debug('p_receipt_method_id :'||p_receipt_method_id);
3801: arp_debug.debug('p_sob_id :'||p_sob_id);
3802: arp_debug.debug('p_batch_date :'||p_batch_date);

Line 3799: arp_debug.debug('p_rcpt_method_name :'||p_rcpt_method_name);

3795: l_doc_sequence_id ra_customer_trx.doc_sequence_id%TYPE;
3796: BEGIN
3797: IF PG_DEBUG in ('Y', 'C') THEN
3798: arp_debug.debug('populate_receipt_numbers()+');
3799: arp_debug.debug('p_rcpt_method_name :'||p_rcpt_method_name);
3800: arp_debug.debug('p_receipt_method_id :'||p_receipt_method_id);
3801: arp_debug.debug('p_sob_id :'||p_sob_id);
3802: arp_debug.debug('p_batch_date :'||p_batch_date);
3803: END IF;

Line 3800: arp_debug.debug('p_receipt_method_id :'||p_receipt_method_id);

3796: BEGIN
3797: IF PG_DEBUG in ('Y', 'C') THEN
3798: arp_debug.debug('populate_receipt_numbers()+');
3799: arp_debug.debug('p_rcpt_method_name :'||p_rcpt_method_name);
3800: arp_debug.debug('p_receipt_method_id :'||p_receipt_method_id);
3801: arp_debug.debug('p_sob_id :'||p_sob_id);
3802: arp_debug.debug('p_batch_date :'||p_batch_date);
3803: END IF;
3804:

Line 3801: arp_debug.debug('p_sob_id :'||p_sob_id);

3797: IF PG_DEBUG in ('Y', 'C') THEN
3798: arp_debug.debug('populate_receipt_numbers()+');
3799: arp_debug.debug('p_rcpt_method_name :'||p_rcpt_method_name);
3800: arp_debug.debug('p_receipt_method_id :'||p_receipt_method_id);
3801: arp_debug.debug('p_sob_id :'||p_sob_id);
3802: arp_debug.debug('p_batch_date :'||p_batch_date);
3803: END IF;
3804:
3805: FOR i IN 1..p_count LOOP

Line 3802: arp_debug.debug('p_batch_date :'||p_batch_date);

3798: arp_debug.debug('populate_receipt_numbers()+');
3799: arp_debug.debug('p_rcpt_method_name :'||p_rcpt_method_name);
3800: arp_debug.debug('p_receipt_method_id :'||p_receipt_method_id);
3801: arp_debug.debug('p_sob_id :'||p_sob_id);
3802: arp_debug.debug('p_batch_date :'||p_batch_date);
3803: END IF;
3804:
3805: FOR i IN 1..p_count LOOP
3806: l_status := FND_SEQNUM.GET_SEQ_VAL(

Line 3820: arp_debug.debug(' l_status '||l_status);

3816:
3817: l_error_flag := 'N';
3818:
3819: IF PG_DEBUG in ('Y', 'C') THEN
3820: arp_debug.debug(' l_status '||l_status);
3821: END IF;
3822:
3823: IF l_status = FND_SEQNUM.SEQSUCC AND
3824: l_doc_sequence_value is NULL THEN

Line 3825: arp_debug.debug ( 'ERROR!!!! l_doc_sequence_value is not generated');

3821: END IF;
3822:
3823: IF l_status = FND_SEQNUM.SEQSUCC AND
3824: l_doc_sequence_value is NULL THEN
3825: arp_debug.debug ( 'ERROR!!!! l_doc_sequence_value is not generated');
3826: l_error_flag := 'Y';
3827:
3828: ELSIF l_status = FND_SEQNUM.NOASSIGN THEN
3829: arp_debug.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');

Line 3829: arp_debug.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');

3825: arp_debug.debug ( 'ERROR!!!! l_doc_sequence_value is not generated');
3826: l_error_flag := 'Y';
3827:
3828: ELSIF l_status = FND_SEQNUM.NOASSIGN THEN
3829: arp_debug.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
3830: l_error_flag := 'Y';
3831: ELSIF l_status <> FND_SEQNUM.SEQSUCC THEN
3832: arp_debug.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
3833: l_error_flag := 'Y';

Line 3832: arp_debug.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');

3828: ELSIF l_status = FND_SEQNUM.NOASSIGN THEN
3829: arp_debug.debug ( 'ERROR THERE ARE NO DOC SEQ ASSIGNMENT!!!!');
3830: l_error_flag := 'Y';
3831: ELSIF l_status <> FND_SEQNUM.SEQSUCC THEN
3832: arp_debug.debug ( 'ERROR ERROR IN FND ROUTINE !!!!');
3833: l_error_flag := 'Y';
3834: END IF;
3835:
3836: IF l_error_flag = 'Y' THEN

Line 3845: arp_debug.debug('populate_receipt_numbers()-');

3841: p_receipt_num_array(i) := l_doc_sequence_value;
3842: END LOOP;
3843:
3844: IF PG_DEBUG in ('Y', 'C') THEN
3845: arp_debug.debug('populate_receipt_numbers()-');
3846: END IF;
3847:
3848: EXCEPTION
3849: WHEN OTHERS THEN

Line 3850: arp_debug.debug('Exception : populate_receipt_numbers() '|| SQLERRM);

3846: END IF;
3847:
3848: EXCEPTION
3849: WHEN OTHERS THEN
3850: arp_debug.debug('Exception : populate_receipt_numbers() '|| SQLERRM);
3851: G_ERROR := 'Y';
3852: END populate_receipt_numbers;
3853:
3854:

Line 4079: arp_debug.debug('process_selected_receipts()+');

4075: AND receipt_number = l_rec_num;
4076:
4077: BEGIN
4078: IF PG_DEBUG in ('Y', 'C') THEN
4079: arp_debug.debug('process_selected_receipts()+');
4080: arp_debug.debug('batch_id '||p_batch_id);
4081: arp_debug.debug('p_receipt_method_id '||p_receipt_method_id);
4082: END IF;
4083:

Line 4080: arp_debug.debug('batch_id '||p_batch_id);

4076:
4077: BEGIN
4078: IF PG_DEBUG in ('Y', 'C') THEN
4079: arp_debug.debug('process_selected_receipts()+');
4080: arp_debug.debug('batch_id '||p_batch_id);
4081: arp_debug.debug('p_receipt_method_id '||p_receipt_method_id);
4082: END IF;
4083:
4084: pg_request_id := arp_standard.profile.request_id;

Line 4081: arp_debug.debug('p_receipt_method_id '||p_receipt_method_id);

4077: BEGIN
4078: IF PG_DEBUG in ('Y', 'C') THEN
4079: arp_debug.debug('process_selected_receipts()+');
4080: arp_debug.debug('batch_id '||p_batch_id);
4081: arp_debug.debug('p_receipt_method_id '||p_receipt_method_id);
4082: END IF;
4083:
4084: pg_request_id := arp_standard.profile.request_id;
4085:

Line 4087: arp_debug.debug('request_id :'||pg_request_id);

4083:
4084: pg_request_id := arp_standard.profile.request_id;
4085:
4086: IF PG_DEBUG in ('Y', 'C') THEN
4087: arp_debug.debug('request_id :'||pg_request_id);
4088: END IF;
4089:
4090: /** set the called_from value based on receipt method properties.If confirm_flag
4091: value associated to current receipt method is N then l_called_from value is

Line 4133: arp_debug.debug('p_creation_rule '|| l_rec_creation_rule_code);

4129: l_process_payment_flag := 1;
4130: END IF;
4131:
4132: IF PG_DEBUG in ('Y', 'C') THEN
4133: arp_debug.debug('p_creation_rule '|| l_rec_creation_rule_code);
4134: arp_debug.debug('l_called_from '|| l_called_from);
4135: arp_debug.debug('l_process_payment_flag '|| l_process_payment_flag);
4136: arp_debug.debug('l_rec_inher_inv_num_flag '|| l_rec_inher_inv_num_flag);
4137: arp_debug.debug('l_set_of_books_id '|| l_set_of_books_id);

Line 4134: arp_debug.debug('l_called_from '|| l_called_from);

4130: END IF;
4131:
4132: IF PG_DEBUG in ('Y', 'C') THEN
4133: arp_debug.debug('p_creation_rule '|| l_rec_creation_rule_code);
4134: arp_debug.debug('l_called_from '|| l_called_from);
4135: arp_debug.debug('l_process_payment_flag '|| l_process_payment_flag);
4136: arp_debug.debug('l_rec_inher_inv_num_flag '|| l_rec_inher_inv_num_flag);
4137: arp_debug.debug('l_set_of_books_id '|| l_set_of_books_id);
4138: arp_debug.debug('l_name '|| l_name);

Line 4135: arp_debug.debug('l_process_payment_flag '|| l_process_payment_flag);

4131:
4132: IF PG_DEBUG in ('Y', 'C') THEN
4133: arp_debug.debug('p_creation_rule '|| l_rec_creation_rule_code);
4134: arp_debug.debug('l_called_from '|| l_called_from);
4135: arp_debug.debug('l_process_payment_flag '|| l_process_payment_flag);
4136: arp_debug.debug('l_rec_inher_inv_num_flag '|| l_rec_inher_inv_num_flag);
4137: arp_debug.debug('l_set_of_books_id '|| l_set_of_books_id);
4138: arp_debug.debug('l_name '|| l_name);
4139: arp_debug.debug('l_batch_date '|| l_batch_date);

Line 4136: arp_debug.debug('l_rec_inher_inv_num_flag '|| l_rec_inher_inv_num_flag);

4132: IF PG_DEBUG in ('Y', 'C') THEN
4133: arp_debug.debug('p_creation_rule '|| l_rec_creation_rule_code);
4134: arp_debug.debug('l_called_from '|| l_called_from);
4135: arp_debug.debug('l_process_payment_flag '|| l_process_payment_flag);
4136: arp_debug.debug('l_rec_inher_inv_num_flag '|| l_rec_inher_inv_num_flag);
4137: arp_debug.debug('l_set_of_books_id '|| l_set_of_books_id);
4138: arp_debug.debug('l_name '|| l_name);
4139: arp_debug.debug('l_batch_date '|| l_batch_date);
4140: arp_debug.debug('l_gl_date '|| l_gl_date);

Line 4137: arp_debug.debug('l_set_of_books_id '|| l_set_of_books_id);

4133: arp_debug.debug('p_creation_rule '|| l_rec_creation_rule_code);
4134: arp_debug.debug('l_called_from '|| l_called_from);
4135: arp_debug.debug('l_process_payment_flag '|| l_process_payment_flag);
4136: arp_debug.debug('l_rec_inher_inv_num_flag '|| l_rec_inher_inv_num_flag);
4137: arp_debug.debug('l_set_of_books_id '|| l_set_of_books_id);
4138: arp_debug.debug('l_name '|| l_name);
4139: arp_debug.debug('l_batch_date '|| l_batch_date);
4140: arp_debug.debug('l_gl_date '|| l_gl_date);
4141: arp_debug.debug('l_currency_code '|| l_currency_code);

Line 4138: arp_debug.debug('l_name '|| l_name);

4134: arp_debug.debug('l_called_from '|| l_called_from);
4135: arp_debug.debug('l_process_payment_flag '|| l_process_payment_flag);
4136: arp_debug.debug('l_rec_inher_inv_num_flag '|| l_rec_inher_inv_num_flag);
4137: arp_debug.debug('l_set_of_books_id '|| l_set_of_books_id);
4138: arp_debug.debug('l_name '|| l_name);
4139: arp_debug.debug('l_batch_date '|| l_batch_date);
4140: arp_debug.debug('l_gl_date '|| l_gl_date);
4141: arp_debug.debug('l_currency_code '|| l_currency_code);
4142: arp_debug.debug('l_exchange_rate '|| l_exchange_rate);

Line 4139: arp_debug.debug('l_batch_date '|| l_batch_date);

4135: arp_debug.debug('l_process_payment_flag '|| l_process_payment_flag);
4136: arp_debug.debug('l_rec_inher_inv_num_flag '|| l_rec_inher_inv_num_flag);
4137: arp_debug.debug('l_set_of_books_id '|| l_set_of_books_id);
4138: arp_debug.debug('l_name '|| l_name);
4139: arp_debug.debug('l_batch_date '|| l_batch_date);
4140: arp_debug.debug('l_gl_date '|| l_gl_date);
4141: arp_debug.debug('l_currency_code '|| l_currency_code);
4142: arp_debug.debug('l_exchange_rate '|| l_exchange_rate);
4143: arp_debug.debug('l_exchange_date '|| l_exchange_date);

Line 4140: arp_debug.debug('l_gl_date '|| l_gl_date);

4136: arp_debug.debug('l_rec_inher_inv_num_flag '|| l_rec_inher_inv_num_flag);
4137: arp_debug.debug('l_set_of_books_id '|| l_set_of_books_id);
4138: arp_debug.debug('l_name '|| l_name);
4139: arp_debug.debug('l_batch_date '|| l_batch_date);
4140: arp_debug.debug('l_gl_date '|| l_gl_date);
4141: arp_debug.debug('l_currency_code '|| l_currency_code);
4142: arp_debug.debug('l_exchange_rate '|| l_exchange_rate);
4143: arp_debug.debug('l_exchange_date '|| l_exchange_date);
4144: arp_debug.debug('l_exchange_rate_type '|| l_exchange_rate_type);

Line 4141: arp_debug.debug('l_currency_code '|| l_currency_code);

4137: arp_debug.debug('l_set_of_books_id '|| l_set_of_books_id);
4138: arp_debug.debug('l_name '|| l_name);
4139: arp_debug.debug('l_batch_date '|| l_batch_date);
4140: arp_debug.debug('l_gl_date '|| l_gl_date);
4141: arp_debug.debug('l_currency_code '|| l_currency_code);
4142: arp_debug.debug('l_exchange_rate '|| l_exchange_rate);
4143: arp_debug.debug('l_exchange_date '|| l_exchange_date);
4144: arp_debug.debug('l_exchange_rate_type '|| l_exchange_rate_type);
4145: END IF;

Line 4142: arp_debug.debug('l_exchange_rate '|| l_exchange_rate);

4138: arp_debug.debug('l_name '|| l_name);
4139: arp_debug.debug('l_batch_date '|| l_batch_date);
4140: arp_debug.debug('l_gl_date '|| l_gl_date);
4141: arp_debug.debug('l_currency_code '|| l_currency_code);
4142: arp_debug.debug('l_exchange_rate '|| l_exchange_rate);
4143: arp_debug.debug('l_exchange_date '|| l_exchange_date);
4144: arp_debug.debug('l_exchange_rate_type '|| l_exchange_rate_type);
4145: END IF;
4146:

Line 4143: arp_debug.debug('l_exchange_date '|| l_exchange_date);

4139: arp_debug.debug('l_batch_date '|| l_batch_date);
4140: arp_debug.debug('l_gl_date '|| l_gl_date);
4141: arp_debug.debug('l_currency_code '|| l_currency_code);
4142: arp_debug.debug('l_exchange_rate '|| l_exchange_rate);
4143: arp_debug.debug('l_exchange_date '|| l_exchange_date);
4144: arp_debug.debug('l_exchange_rate_type '|| l_exchange_rate_type);
4145: END IF;
4146:
4147: --populate the query string based on creation_rule_code

Line 4144: arp_debug.debug('l_exchange_rate_type '|| l_exchange_rate_type);

4140: arp_debug.debug('l_gl_date '|| l_gl_date);
4141: arp_debug.debug('l_currency_code '|| l_currency_code);
4142: arp_debug.debug('l_exchange_rate '|| l_exchange_rate);
4143: arp_debug.debug('l_exchange_date '|| l_exchange_date);
4144: arp_debug.debug('l_exchange_rate_type '|| l_exchange_rate_type);
4145: END IF;
4146:
4147: --populate the query string based on creation_rule_code
4148: build_queries( l_rec_creation_rule_code,

Line 4156: arp_debug.debug('Executing invoice receipt mapping query for batch '||p_batch_id);

4152: l_inv_rct_mp_qry );
4153:
4154: IF p_approval_mode = 'RE-APPROVAL' THEN
4155: IF PG_DEBUG in ('Y', 'C') THEN
4156: arp_debug.debug('Executing invoice receipt mapping query for batch '||p_batch_id);
4157: END IF;
4158:
4159: EXECUTE IMMEDIATE l_inv_rct_mp_qry USING p_batch_id;
4160: IF PG_DEBUG in ('Y', 'C') THEN

Line 4161: arp_debug.debug('Number of rows inserted '||SQL%ROWCOUNT);

4157: END IF;
4158:
4159: EXECUTE IMMEDIATE l_inv_rct_mp_qry USING p_batch_id;
4160: IF PG_DEBUG in ('Y', 'C') THEN
4161: arp_debug.debug('Number of rows inserted '||SQL%ROWCOUNT);
4162: END IF;
4163: END IF;
4164:
4165: IF PG_DEBUG in ('Y', 'C') THEN

Line 4166: arp_debug.debug('ar_receipts_gt dump 1');

4162: END IF;
4163: END IF;
4164:
4165: IF PG_DEBUG in ('Y', 'C') THEN
4166: arp_debug.debug('ar_receipts_gt dump 1');
4167: dump_ar_receipts_gt;
4168: END IF;
4169:
4170: OPEN rcpt_info_cursor FOR l_create_stmt;

Line 4178: arp_debug.debug('current fetch count '|| l_rcpt_info_tab.count);

4174: LOOP
4175: FETCH rcpt_info_cursor BULK COLLECT INTO l_rcpt_info_tab LIMIT MAX_ARRAY_SIZE;
4176:
4177: IF PG_DEBUG in ('Y', 'C') THEN
4178: arp_debug.debug('current fetch count '|| l_rcpt_info_tab.count);
4179: END IF;
4180:
4181: IF l_rcpt_info_tab.count = 0 THEN
4182: EXIT;

Line 4194: arp_debug.debug('Value of l_gt_id '|| l_gt_id );

4190: The field gt_id is used for logically seperating the data among different batches.*/
4191: l_gt_id := nvl(l_gt_id,1) + 1;
4192:
4193: IF PG_DEBUG in ('Y', 'C') THEN
4194: arp_debug.debug('Value of l_gt_id '|| l_gt_id );
4195: END IF;
4196:
4197: IF p_approval_mode <> 'RE-APPROVAL' THEN
4198: /* IF l_rec_creation_rule_code <> 'PER_INVOICE' OR

Line 4210: arp_debug.debug('Receipt numbers populated are '|| l_receipt_num_array.count);

4206: l_rcpt_info_tab.count );
4207: END IF;
4208:
4209: IF PG_DEBUG in ('Y', 'C') THEN
4210: arp_debug.debug('Receipt numbers populated are '|| l_receipt_num_array.count);
4211: arp_debug.debug('l_rcpt_info_tab.FIRST '|| l_rcpt_info_tab.FIRST);
4212: arp_debug.debug('l_rcpt_info_tab.LAST '|| l_rcpt_info_tab.LAST);
4213: END IF;
4214: */

Line 4211: arp_debug.debug('l_rcpt_info_tab.FIRST '|| l_rcpt_info_tab.FIRST);

4207: END IF;
4208:
4209: IF PG_DEBUG in ('Y', 'C') THEN
4210: arp_debug.debug('Receipt numbers populated are '|| l_receipt_num_array.count);
4211: arp_debug.debug('l_rcpt_info_tab.FIRST '|| l_rcpt_info_tab.FIRST);
4212: arp_debug.debug('l_rcpt_info_tab.LAST '|| l_rcpt_info_tab.LAST);
4213: END IF;
4214: */
4215: --reset the MIN AMOUNT CHECK array

Line 4212: arp_debug.debug('l_rcpt_info_tab.LAST '|| l_rcpt_info_tab.LAST);

4208:
4209: IF PG_DEBUG in ('Y', 'C') THEN
4210: arp_debug.debug('Receipt numbers populated are '|| l_receipt_num_array.count);
4211: arp_debug.debug('l_rcpt_info_tab.FIRST '|| l_rcpt_info_tab.FIRST);
4212: arp_debug.debug('l_rcpt_info_tab.LAST '|| l_rcpt_info_tab.LAST);
4213: END IF;
4214: */
4215: --reset the MIN AMOUNT CHECK array
4216: l_err_rcpt_index := 0;

Line 4239: arp_debug.debug('Checking minimum receipt amount setup at customer level');

4235: l_receipt_num_array(i) := l_index;
4236: END IF;
4237:
4238: IF PG_DEBUG in ('Y', 'C') THEN
4239: arp_debug.debug('Checking minimum receipt amount setup at customer level');
4240: END IF;
4241:
4242: /* Set the minimum receipt amount got from main select query */
4243: l_cust_site_min_rec_amt := l_rcpt_info_tab(i).cust_min_amount;

Line 4255: arp_debug.debug('Default paying_site_use_id');

4251: /* Defaulting paying site for per_customer and per_customer_due_date as it is always NULL*/
4252: IF l_rcpt_info_tab(i).paying_site_use_id IS NULL then
4253:
4254: IF PG_DEBUG in ('Y', 'C') THEN
4255: arp_debug.debug('Default paying_site_use_id');
4256: END IF;
4257:
4258: SELECT site_use.site_use_id
4259: INTO l_rcpt_info_tab(i).paying_site_use_id

Line 4272: arp_debug.debug('Get Minimum Receipt Amount for the paying_site_use_id');

4268:
4269: END IF;
4270: /* Get the minimum receipt amount for per_customer / due_date defined at site level */
4271: IF PG_DEBUG in ('Y', 'C') THEN
4272: arp_debug.debug('Get Minimum Receipt Amount for the paying_site_use_id');
4273: END IF;
4274:
4275: Select cpa.auto_rec_min_receipt_amount
4276: into l_cust_site_min_rec_amt

Line 4286: arp_debug.debug('Min Receipt Amount allowed at site is NULL');

4282:
4283: IF l_cust_site_min_rec_amt IS NULL THEN
4284:
4285: IF PG_DEBUG in ('Y', 'C') THEN
4286: arp_debug.debug('Min Receipt Amount allowed at site is NULL');
4287: arp_debug.debug('Defaulting Min Receipt Amount allowed from Cust Account Level');
4288: END IF;
4289:
4290: l_cust_site_min_rec_amt := l_rcpt_info_tab(i).cust_min_amount;

Line 4287: arp_debug.debug('Defaulting Min Receipt Amount allowed from Cust Account Level');

4283: IF l_cust_site_min_rec_amt IS NULL THEN
4284:
4285: IF PG_DEBUG in ('Y', 'C') THEN
4286: arp_debug.debug('Min Receipt Amount allowed at site is NULL');
4287: arp_debug.debug('Defaulting Min Receipt Amount allowed from Cust Account Level');
4288: END IF;
4289:
4290: l_cust_site_min_rec_amt := l_rcpt_info_tab(i).cust_min_amount;
4291: END IF;

Line 4305: arp_debug.debug('Checking minimum receipt amount setup at receipt method bank level');

4301:
4302: BEGIN
4303:
4304: IF PG_DEBUG in ('Y', 'C') THEN
4305: arp_debug.debug('Checking minimum receipt amount setup at receipt method bank level');
4306: arp_debug.debug('Calling Default_Receipt_Method_Info');
4307: END IF;
4308:
4309: ar_receipt_lib_pvt.Default_Receipt_Method_Info(

Line 4306: arp_debug.debug('Calling Default_Receipt_Method_Info');

4302: BEGIN
4303:
4304: IF PG_DEBUG in ('Y', 'C') THEN
4305: arp_debug.debug('Checking minimum receipt amount setup at receipt method bank level');
4306: arp_debug.debug('Calling Default_Receipt_Method_Info');
4307: END IF;
4308:
4309: ar_receipt_lib_pvt.Default_Receipt_Method_Info(
4310: p_receipt_method_id => p_receipt_method_id,

Line 4335: arp_debug.debug('l_cust_site_min_rec_amt '|| l_cust_site_min_rec_amt);

4331:
4332: /* Error if the receipt amount is less than greater of the minimum receipt amount
4333: defined at customer site/account level or receipt method bank level.*/
4334: IF PG_DEBUG in ('Y', 'C') THEN
4335: arp_debug.debug('l_cust_site_min_rec_amt '|| l_cust_site_min_rec_amt);
4336: arp_debug.debug('l_rec_method_min_rec_amt '|| l_rec_method_min_rec_amt);
4337: END IF;
4338:
4339: IF nvl(l_cust_site_min_rec_amt,0) > nvl(l_rec_method_min_rec_amt,0) THEN

Line 4336: arp_debug.debug('l_rec_method_min_rec_amt '|| l_rec_method_min_rec_amt);

4332: /* Error if the receipt amount is less than greater of the minimum receipt amount
4333: defined at customer site/account level or receipt method bank level.*/
4334: IF PG_DEBUG in ('Y', 'C') THEN
4335: arp_debug.debug('l_cust_site_min_rec_amt '|| l_cust_site_min_rec_amt);
4336: arp_debug.debug('l_rec_method_min_rec_amt '|| l_rec_method_min_rec_amt);
4337: END IF;
4338:
4339: IF nvl(l_cust_site_min_rec_amt,0) > nvl(l_rec_method_min_rec_amt,0) THEN
4340: l_min_rec_amount_allowed := l_cust_site_min_rec_amt;

Line 4358: arp_debug.debug('l_err_code '|| l_err_code );

4354: END IF;
4355:
4356:
4357: IF PG_DEBUG in ('Y', 'C') THEN
4358: arp_debug.debug('l_err_code '|| l_err_code );
4359: arp_debug.debug('l_rcpt_info_tab(i).amount ' || l_rcpt_info_tab(i).amount);
4360: END IF;
4361:
4362: l_ps_id_array(i) := l_rcpt_info_tab(i).payment_schedule_id;

Line 4359: arp_debug.debug('l_rcpt_info_tab(i).amount ' || l_rcpt_info_tab(i).amount);

4355:
4356:
4357: IF PG_DEBUG in ('Y', 'C') THEN
4358: arp_debug.debug('l_err_code '|| l_err_code );
4359: arp_debug.debug('l_rcpt_info_tab(i).amount ' || l_rcpt_info_tab(i).amount);
4360: END IF;
4361:
4362: l_ps_id_array(i) := l_rcpt_info_tab(i).payment_schedule_id;
4363: l_gt_id_array(i) := l_gt_id;

Line 4387: arp_debug.debug( 'l_installment = '|| l_installment);

4383: where payment_schedule_id = l_rcpt_info_tab(i).payment_schedule_id;
4384: END IF;
4385:
4386: IF PG_DEBUG in ('Y', 'C') THEN
4387: arp_debug.debug( 'l_installment = '|| l_installment);
4388: END IF;
4389:
4390: --set the variables to cache
4391: g_rcpt_creation_rec.party_id := l_rcpt_info_tab(i).party_id;

Line 4396: arp_debug.debug('Calling create receipt ');

4392: g_rcpt_creation_rec.pmt_channel_code := l_rcpt_info_tab(i).payment_channel_code;
4393: g_rcpt_creation_rec.assignment_id := l_rcpt_info_tab(i).instr_assignment_id;
4394:
4395: IF PG_DEBUG in ('Y', 'C') THEN
4396: arp_debug.debug('Calling create receipt ');
4397: END IF;
4398:
4399: -- Stamp receipt_number as null, so that receipt API copies
4400: -- doc seq to receipt_number when inher_inv_num_flag is not set

Line 4436: arp_debug.debug( 'Returning from create_receipt ');

4432: l_receipt_num_array(i) := l_index;
4433: END IF;
4434:
4435: IF PG_DEBUG in ('Y', 'C') THEN
4436: arp_debug.debug( 'Returning from create_receipt ');
4437: arp_debug.debug( 'l_cash_receipt_id = '|| l_cash_receipt_id);
4438: arp_debug.debug( 'l_return_status = '|| l_return_status);
4439: END IF;
4440:

Line 4437: arp_debug.debug( 'l_cash_receipt_id = '|| l_cash_receipt_id);

4433: END IF;
4434:
4435: IF PG_DEBUG in ('Y', 'C') THEN
4436: arp_debug.debug( 'Returning from create_receipt ');
4437: arp_debug.debug( 'l_cash_receipt_id = '|| l_cash_receipt_id);
4438: arp_debug.debug( 'l_return_status = '|| l_return_status);
4439: END IF;
4440:
4441: IF nvl(l_return_status,'N') = 'S' THEN

Line 4438: arp_debug.debug( 'l_return_status = '|| l_return_status);

4434:
4435: IF PG_DEBUG in ('Y', 'C') THEN
4436: arp_debug.debug( 'Returning from create_receipt ');
4437: arp_debug.debug( 'l_cash_receipt_id = '|| l_cash_receipt_id);
4438: arp_debug.debug( 'l_return_status = '|| l_return_status);
4439: END IF;
4440:
4441: IF nvl(l_return_status,'N') = 'S' THEN
4442: l_receipt_id_array(i) := l_cash_receipt_id;

Line 4598: arp_debug.debug( 'Calling process_payments ');

4594: --payment processing
4595: IF l_process_payment_flag = 1 AND l_receipt_id_array(i) is not null THEN
4596:
4597: IF PG_DEBUG in ('Y', 'C') THEN
4598: arp_debug.debug( 'Calling process_payments ');
4599: arp_standard.debug( 'l_receipt_id_array(i)= '|| l_receipt_id_array(i));
4600: END IF;
4601:
4602: l_cc_error_code := null;

Line 4615: arp_debug.debug( 'Returning from process_payments ');

4611: l_cc_error_text,
4612: l_return_status);
4613:
4614: IF PG_DEBUG in ('Y', 'C') THEN
4615: arp_debug.debug( 'Returning from process_payments ');
4616: arp_debug.debug( 'l_return_status = '|| l_return_status);
4617: END IF;
4618:
4619: /*------------------------------------------------------+

Line 4616: arp_debug.debug( 'l_return_status = '|| l_return_status);

4612: l_return_status);
4613:
4614: IF PG_DEBUG in ('Y', 'C') THEN
4615: arp_debug.debug( 'Returning from process_payments ');
4616: arp_debug.debug( 'l_return_status = '|| l_return_status);
4617: END IF;
4618:
4619: /*------------------------------------------------------+
4620: | Check the return status from Process_Payment |

Line 4636: arp_debug.debug( 'Updating ar_receipts_gt with receipt number');

4632:
4633: END LOOP; -- end of process receipts loop
4634:
4635: IF PG_DEBUG in ('Y', 'C') THEN
4636: arp_debug.debug( 'Updating ar_receipts_gt with receipt number');
4637: END IF;
4638:
4639: /**Stamp receipt_id and receipt number to the gt table*/
4640: update_ar_receipts_gt ( p_creation_rule => l_rec_creation_rule_code,

Line 4659: arp_debug.debug( 'loop through errored receipts '||l_err_rcpt_index);

4655: --loop through all the receipts which failed the min amount condition and insert
4656: --them into exceptions table
4657: FOR k IN 1..l_err_rcpt_index LOOP
4658: IF PG_DEBUG in ('Y', 'C') THEN
4659: arp_debug.debug( 'loop through errored receipts '||l_err_rcpt_index);
4660: END IF;
4661:
4662: FOR rec IN rec_ps_cur( l_err_rcpt_num_array(k) ) LOOP
4663: IF PG_DEBUG in ('Y', 'C') THEN

Line 4664: arp_debug.debug( 'l_err_rcpt_num_array '||l_err_rcpt_num_array(k));

4660: END IF;
4661:
4662: FOR rec IN rec_ps_cur( l_err_rcpt_num_array(k) ) LOOP
4663: IF PG_DEBUG in ('Y', 'C') THEN
4664: arp_debug.debug( 'l_err_rcpt_num_array '||l_err_rcpt_num_array(k));
4665: arp_debug.debug( 'l_err_code_array '||l_err_code_array(k));
4666: END IF;
4667:
4668: IF l_err_code_array(k) in( 'ARZCAR_CUST_MIN_AMT', 'ARZCAR_BANK_MIN_AMT',

Line 4665: arp_debug.debug( 'l_err_code_array '||l_err_code_array(k));

4661:
4662: FOR rec IN rec_ps_cur( l_err_rcpt_num_array(k) ) LOOP
4663: IF PG_DEBUG in ('Y', 'C') THEN
4664: arp_debug.debug( 'l_err_rcpt_num_array '||l_err_rcpt_num_array(k));
4665: arp_debug.debug( 'l_err_code_array '||l_err_code_array(k));
4666: END IF;
4667:
4668: IF l_err_code_array(k) in( 'ARZCAR_CUST_MIN_AMT', 'ARZCAR_BANK_MIN_AMT',
4669: 'RCPT_CREATION_FAILED')

Line 4701: arp_debug.debug( 'Invoice stamped with cc error '||rec.customer_trx_id);

4697: program_update_date = sysdate
4698: WHERE customer_trx_id = rec.customer_trx_id;
4699:
4700: IF PG_DEBUG in ('Y', 'C') THEN
4701: arp_debug.debug( 'Invoice stamped with cc error '||rec.customer_trx_id);
4702: arp_debug.debug( 'l_cc_err_code_array '||l_cc_err_code_array(k));
4703: arp_debug.debug( 'l_cc_err_text_array '||l_cc_err_text_array(k));
4704: END IF;
4705: END IF;

Line 4702: arp_debug.debug( 'l_cc_err_code_array '||l_cc_err_code_array(k));

4698: WHERE customer_trx_id = rec.customer_trx_id;
4699:
4700: IF PG_DEBUG in ('Y', 'C') THEN
4701: arp_debug.debug( 'Invoice stamped with cc error '||rec.customer_trx_id);
4702: arp_debug.debug( 'l_cc_err_code_array '||l_cc_err_code_array(k));
4703: arp_debug.debug( 'l_cc_err_text_array '||l_cc_err_text_array(k));
4704: END IF;
4705: END IF;
4706:

Line 4703: arp_debug.debug( 'l_cc_err_text_array '||l_cc_err_text_array(k));

4699:
4700: IF PG_DEBUG in ('Y', 'C') THEN
4701: arp_debug.debug( 'Invoice stamped with cc error '||rec.customer_trx_id);
4702: arp_debug.debug( 'l_cc_err_code_array '||l_cc_err_code_array(k));
4703: arp_debug.debug( 'l_cc_err_text_array '||l_cc_err_text_array(k));
4704: END IF;
4705: END IF;
4706:
4707: END LOOP;

Line 4729: arp_debug.debug( 'Returning from process_payments ');

4725: l_cc_error_text,
4726: l_return_status);
4727:
4728: IF PG_DEBUG in ('Y', 'C') THEN
4729: arp_debug.debug( 'Returning from process_payments ');
4730: arp_debug.debug( 'l_return_status = '|| l_return_status);
4731: END IF;
4732:
4733: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 4730: arp_debug.debug( 'l_return_status = '|| l_return_status);

4726: l_return_status);
4727:
4728: IF PG_DEBUG in ('Y', 'C') THEN
4729: arp_debug.debug( 'Returning from process_payments ');
4730: arp_debug.debug( 'l_return_status = '|| l_return_status);
4731: END IF;
4732:
4733: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4734: l_pay_process_fail := 'Y';

Line 4759: arp_debug.debug('ar_receipts_gt dump 2');

4755:
4756: END IF;
4757:
4758: IF PG_DEBUG in ('Y', 'C') THEN
4759: arp_debug.debug('ar_receipts_gt dump 2');
4760: dump_ar_receipts_gt;
4761: END IF;
4762:
4763: /*--------------------------------------------------

Line 4770: arp_debug.debug( 'Opening receipt application cursor');

4766: ---------------------------------------------------*/
4767: arp_view_constants.set_ps_selected_in_batch('Y');
4768:
4769: IF PG_DEBUG in ('Y', 'C') THEN
4770: arp_debug.debug( 'Opening receipt application cursor');
4771: END IF;
4772:
4773: --cursor to fetch the application data
4774: OPEN appl_rec_cur( l_gt_id );

Line 4780: arp_debug.debug('applications fetch count '|| l_rcpt_appl_tab.count);

4776:
4777: FETCH appl_rec_cur BULK COLLECT INTO l_rcpt_appl_tab;
4778:
4779: IF PG_DEBUG in ('Y', 'C') THEN
4780: arp_debug.debug('applications fetch count '|| l_rcpt_appl_tab.count);
4781: END IF;
4782:
4783: l_amt_applied := 0;
4784: l_old_cash_receipt_id := -99;

Line 4812: arp_debug.debug( 'Returing from receipt_application ');

4808: l_amt_applied := l_rcpt_appl_tab(i).amount_apply;
4809: l_old_cash_receipt_id := l_rcpt_appl_tab(i).cash_receipt_id;
4810:
4811: IF PG_DEBUG in ('Y', 'C') THEN
4812: arp_debug.debug( 'Returing from receipt_application ');
4813: arp_debug.debug( 'l_return_status = '|| l_return_status);
4814: END IF;
4815:
4816: IF l_return_status <> 'S' THEN

Line 4813: arp_debug.debug( 'l_return_status = '|| l_return_status);

4809: l_old_cash_receipt_id := l_rcpt_appl_tab(i).cash_receipt_id;
4810:
4811: IF PG_DEBUG in ('Y', 'C') THEN
4812: arp_debug.debug( 'Returing from receipt_application ');
4813: arp_debug.debug( 'l_return_status = '|| l_return_status);
4814: END IF;
4815:
4816: IF l_return_status <> 'S' THEN
4817: l_apply_fail := 'Y' ;

Line 5078: arp_debug.debug('calling rec reset.'|| l_apply_fail || l_pay_process_fail);

5074: /* CALL To reset in the case there were failures */
5075: IF l_apply_fail = 'Y' OR l_pay_process_fail = 'Y' THEN
5076:
5077: IF PG_DEBUG in ('Y', 'C') THEN
5078: arp_debug.debug('calling rec reset.'|| l_apply_fail || l_pay_process_fail);
5079: END IF;
5080:
5081: rec_reset( p_apply_fail => l_apply_fail,
5082: p_pay_process_fail => l_pay_process_fail,

Line 5090: arp_debug.debug( 'End of loop ');

5086: l_pay_process_fail := 'N';
5087: END IF;
5088:
5089: IF PG_DEBUG in ('Y', 'C') THEN
5090: arp_debug.debug( 'End of loop ');
5091: arp_debug.debug( 'Commiting the batch...');
5092: END IF;
5093:
5094: /*Update the receipt_number with the value of trx_number,this update is needed

Line 5091: arp_debug.debug( 'Commiting the batch...');

5087: END IF;
5088:
5089: IF PG_DEBUG in ('Y', 'C') THEN
5090: arp_debug.debug( 'End of loop ');
5091: arp_debug.debug( 'Commiting the batch...');
5092: END IF;
5093:
5094: /*Update the receipt_number with the value of trx_number,this update is needed
5095: sine we considered concatenated string of trx_number and term_sequence as

Line 5109: arp_debug.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));

5105: ar_receipts_gt arg
5106: where arg.gt_id = l_gt_id
5107: AND cr.cash_receipt_id = arg.cash_receipt_id
5108: );
5109: arp_debug.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));
5110:
5111: update ar_payment_schedules
5112: SET TRX_NUMBER =
5113: NVL(SUBSTR(TRX_NUMBER, 1, INSTR(TRX_NUMBER,'-', -1) -1), TRX_NUMBER)

Line 5121: arp_debug.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));

5117: ar_receipts_gt arg
5118: where arg.gt_id = l_gt_id
5119: AND ps.cash_receipt_id = arg.cash_receipt_id
5120: );
5121: arp_debug.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));
5122:
5123: END IF;
5124:
5125: --initiate the event processing

Line 5138: arp_debug.debug('l_rows_fetched < MAX_ARRAY_SIZE Cursor closed');

5134: dbms_sql.close_cursor( l_create_stmt_c );
5135: END IF;
5136:
5137: IF PG_DEBUG in ('Y', 'C') THEN
5138: arp_debug.debug('l_rows_fetched < MAX_ARRAY_SIZE Cursor closed');
5139: END IF;
5140: EXIT;
5141: END IF; --no more rows to fetch
5142:

Line 5152: arp_debug.debug('process_selected_receipts()-');

5148:
5149: END LOOP;--main select cursor loop
5150:
5151: IF PG_DEBUG in ('Y', 'C') THEN
5152: arp_debug.debug('process_selected_receipts()-');
5153: END IF;
5154:
5155: EXCEPTION
5156: WHEN others THEN

Line 5166: arp_debug.debug('Exception : process_selected_receipts() '|| SQLERRM);

5162: p_exception_code => 'AUTORECERR',
5163: p_additional_message => SQLERRM
5164: );
5165: IF PG_DEBUG in ('Y', 'C') THEN
5166: arp_debug.debug('Exception : process_selected_receipts() '|| SQLERRM);
5167: END IF;
5168: END process_selected_receipts;
5169:
5170: