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

APPS.ARP_AUTOMATIC_CLEARING_PKG dependencies on ARP_STANDARD

Line 168: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

164: END IF;
165: --
166: EXCEPTION
167: WHEN OTHERS THEN
168: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
169: RAISE;
170: --
171: END;
172: --

Line 240: arp_standard.debug('Inside main_select_risk');

236: 'and cpc.site_use_id(+) is null ' ||
237: 'and cr.pay_from_customer = cps.cust_account_id(+) ' ||
238: 'and cr.customer_site_use_id = cps.site_use_id(+) ';
239: IF PG_DEBUG in ('Y', 'C') THEN
240: arp_standard.debug('Inside main_select_risk');
241: arp_standard.debug( 'Statement ' || statement);
242: END IF;
243: --
244: EXCEPTION

Line 241: arp_standard.debug( 'Statement ' || statement);

237: 'and cr.pay_from_customer = cps.cust_account_id(+) ' ||
238: 'and cr.customer_site_use_id = cps.site_use_id(+) ';
239: IF PG_DEBUG in ('Y', 'C') THEN
240: arp_standard.debug('Inside main_select_risk');
241: arp_standard.debug( 'Statement ' || statement);
242: END IF;
243: --
244: EXCEPTION
245: WHEN OTHERS THEN

Line 246: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

242: END IF;
243: --
244: EXCEPTION
245: WHEN OTHERS THEN
246: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
247: RAISE;
248: --
249: END;
250: --

Line 330: arp_standard.debug('Inside main_select_factored');

326: 'from ar_payment_schedules ps1 ' ||
327: 'where ps1.reversed_cash_receipt_id = cr.cash_receipt_id ' ||
328: 'and ps1.class = ''DM'') ';
329: IF PG_DEBUG in ('Y', 'C') THEN
330: arp_standard.debug('Inside main_select_factored');
331: arp_standard.debug( 'Statement ' || statement);
332: END IF;
333: EXCEPTION
334: WHEN OTHERS THEN

Line 331: arp_standard.debug( 'Statement ' || statement);

327: 'where ps1.reversed_cash_receipt_id = cr.cash_receipt_id ' ||
328: 'and ps1.class = ''DM'') ';
329: IF PG_DEBUG in ('Y', 'C') THEN
330: arp_standard.debug('Inside main_select_factored');
331: arp_standard.debug( 'Statement ' || statement);
332: END IF;
333: EXCEPTION
334: WHEN OTHERS THEN
335: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

Line 335: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

331: arp_standard.debug( 'Statement ' || statement);
332: END IF;
333: EXCEPTION
334: WHEN OTHERS THEN
335: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
336: RAISE;
337: --
338: END;
339: --

Line 428: arp_standard.debug('Inside main_select_remitted');

424: 'from ar_payment_schedules ps1 ' ||
425: 'where ps1.reversed_cash_receipt_id = cr.cash_receipt_id ' ||
426: 'and ps1.class = ''DM'') ';
427: IF PG_DEBUG in ('Y', 'C') THEN
428: arp_standard.debug('Inside main_select_remitted');
429: arp_standard.debug( 'Statement ' || statement);
430: END IF;
431: --
432: EXCEPTION

Line 429: arp_standard.debug( 'Statement ' || statement);

425: 'where ps1.reversed_cash_receipt_id = cr.cash_receipt_id ' ||
426: 'and ps1.class = ''DM'') ';
427: IF PG_DEBUG in ('Y', 'C') THEN
428: arp_standard.debug('Inside main_select_remitted');
429: arp_standard.debug( 'Statement ' || statement);
430: END IF;
431: --
432: EXCEPTION
433: WHEN OTHERS THEN

Line 434: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

430: END IF;
431: --
432: EXCEPTION
433: WHEN OTHERS THEN
434: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
435: RAISE;
436: --
437: END;
438: --

Line 495: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

491: END IF;
492: --
493: EXCEPTION
494: WHEN OTHERS THEN
495: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
496: RAISE;
497: --
498: END;
499: --

Line 748: arp_standard.debug('Before calling arp_cashbook.clear');

744: nvl(v_ex_rate,1),
745: NULL,NULL );
746: END IF;
747:
748: arp_standard.debug('Before calling arp_cashbook.clear');
749: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));
750: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
751: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
752: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));

Line 749: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));

745: NULL,NULL );
746: END IF;
747:
748: arp_standard.debug('Before calling arp_cashbook.clear');
749: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));
750: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
751: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
752: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
753: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));

Line 750: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));

746: END IF;
747:
748: arp_standard.debug('Before calling arp_cashbook.clear');
749: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));
750: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
751: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
752: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
753: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
754: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);

Line 751: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));

747:
748: arp_standard.debug('Before calling arp_cashbook.clear');
749: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));
750: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
751: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
752: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
753: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
754: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
755: arp_standard.debug('v_currency :' || v_currency);

Line 752: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));

748: arp_standard.debug('Before calling arp_cashbook.clear');
749: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));
750: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
751: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
752: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
753: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
754: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
755: arp_standard.debug('v_currency :' || v_currency);
756: arp_standard.debug('New v_amount :' || to_char(v_amount));

Line 753: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));

749: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));
750: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
751: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
752: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
753: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
754: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
755: arp_standard.debug('v_currency :' || v_currency);
756: arp_standard.debug('New v_amount :' || to_char(v_amount));
757: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));

Line 754: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);

750: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
751: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
752: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
753: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
754: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
755: arp_standard.debug('v_currency :' || v_currency);
756: arp_standard.debug('New v_amount :' || to_char(v_amount));
757: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));
758: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));

Line 755: arp_standard.debug('v_currency :' || v_currency);

751: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
752: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
753: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
754: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
755: arp_standard.debug('v_currency :' || v_currency);
756: arp_standard.debug('New v_amount :' || to_char(v_amount));
757: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));
758: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));
759: arp_standard.debug('v_cr_currency :' || v_cr_currency);

Line 756: arp_standard.debug('New v_amount :' || to_char(v_amount));

752: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
753: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
754: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
755: arp_standard.debug('v_currency :' || v_currency);
756: arp_standard.debug('New v_amount :' || to_char(v_amount));
757: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));
758: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));
759: arp_standard.debug('v_cr_currency :' || v_cr_currency);
760:

Line 757: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));

753: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
754: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
755: arp_standard.debug('v_currency :' || v_currency);
756: arp_standard.debug('New v_amount :' || to_char(v_amount));
757: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));
758: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));
759: arp_standard.debug('v_cr_currency :' || v_cr_currency);
760:
761: arp_cashbook.clear( v_cr_id,

Line 758: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));

754: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
755: arp_standard.debug('v_currency :' || v_currency);
756: arp_standard.debug('New v_amount :' || to_char(v_amount));
757: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));
758: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));
759: arp_standard.debug('v_cr_currency :' || v_cr_currency);
760:
761: arp_cashbook.clear( v_cr_id,
762: v_trx_date,

Line 759: arp_standard.debug('v_cr_currency :' || v_cr_currency);

755: arp_standard.debug('v_currency :' || v_currency);
756: arp_standard.debug('New v_amount :' || to_char(v_amount));
757: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));
758: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));
759: arp_standard.debug('v_cr_currency :' || v_cr_currency);
760:
761: arp_cashbook.clear( v_cr_id,
762: v_trx_date,
763: v_gl_date,

Line 778: arp_standard.debug('ar_automatic_clearing_pkg: NO_RATE');

774: /* bug: 3820774 Added the handling of exception rate. */
775: ELSE
776: IF v_ex_rate = -1
777: THEN
778: arp_standard.debug('ar_automatic_clearing_pkg: NO_RATE');
779: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
780: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
781: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
782: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));

Line 779: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));

775: ELSE
776: IF v_ex_rate = -1
777: THEN
778: arp_standard.debug('ar_automatic_clearing_pkg: NO_RATE');
779: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
780: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
781: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
782: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
783:

Line 780: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));

776: IF v_ex_rate = -1
777: THEN
778: arp_standard.debug('ar_automatic_clearing_pkg: NO_RATE');
779: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
780: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
781: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
782: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
783:
784: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');

Line 781: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);

777: THEN
778: arp_standard.debug('ar_automatic_clearing_pkg: NO_RATE');
779: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
780: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
781: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
782: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
783:
784: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');
785: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));

Line 782: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));

778: arp_standard.debug('ar_automatic_clearing_pkg: NO_RATE');
779: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
780: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
781: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
782: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
783:
784: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');
785: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
786: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));

Line 792: arp_standard.debug('ar_automatic_clearing_pkg: INVALID_CURRENCY');

788: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
789:
790: ELSIF v_ex_rate = -2
791: THEN
792: arp_standard.debug('ar_automatic_clearing_pkg: INVALID_CURRENCY');
793: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
794: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
795: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
796: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));

Line 793: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));

789:
790: ELSIF v_ex_rate = -2
791: THEN
792: arp_standard.debug('ar_automatic_clearing_pkg: INVALID_CURRENCY');
793: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
794: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
795: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
796: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
797:

Line 794: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));

790: ELSIF v_ex_rate = -2
791: THEN
792: arp_standard.debug('ar_automatic_clearing_pkg: INVALID_CURRENCY');
793: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
794: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
795: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
796: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
797:
798: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: INVALID_CURRENCY');

Line 795: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);

791: THEN
792: arp_standard.debug('ar_automatic_clearing_pkg: INVALID_CURRENCY');
793: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
794: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
795: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
796: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
797:
798: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: INVALID_CURRENCY');
799: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));

Line 796: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));

792: arp_standard.debug('ar_automatic_clearing_pkg: INVALID_CURRENCY');
793: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
794: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
795: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
796: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
797:
798: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: INVALID_CURRENCY');
799: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
800: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));

Line 831: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

827: dbms_sql.close_cursor(c);
828: --
829: EXCEPTION
830: WHEN OTHERS THEN
831: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
832: RAISE;
833: --
834: END;
835: --

Line 918: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

914: return(TRUE);
915: --
916: EXCEPTION
917: WHEN OTHERS THEN
918: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
919: RAISE;
920: END;
921: --
922: /*========================================================================+

Line 983: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

979: END IF;
980: --
981: EXCEPTION
982: WHEN OTHERS THEN
983: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
984: RAISE;
985: END;
986:
987: --

Line 1093: l_master_request_id := arp_standard.profile.request_id;

1089: SELECT org_id
1090: INTO l_org_id
1091: FROM ar_system_parameters;
1092:
1093: l_master_request_id := arp_standard.profile.request_id;
1094:
1095: IF (p_clr_remitted_receipts = 'Y') THEN
1096: remitted_or_factored_or_risk := 1;
1097: populate_interim_table (

Line 1172: arp_standard.debug ( 'The Master program waits for child processes');

1168: fnd_file.put_line(FND_FILE.LOG,'worker # : ' || l_worker_number );
1169: submit_subrequest (l_worker_number,l_org_id,l_master_request_id);
1170: END LOOP;
1171:
1172: arp_standard.debug ( 'The Master program waits for child processes');
1173:
1174: -- Wait for the completion of the submitted requests
1175: FOR i in 1..p_total_workers LOOP
1176:

Line 1365: arp_standard.debug('Inside populate_interim_table()');

1361: --
1362: dbms_sql.parse(c, statement, dbms_sql.native);
1363: --
1364: IF PG_DEBUG in ('Y', 'C') THEN
1365: arp_standard.debug('Inside populate_interim_table()');
1366: arp_standard.debug( 'Statement ' || statement);
1367: END IF;
1368: -- Bind variables
1369: --

Line 1366: arp_standard.debug( 'Statement ' || statement);

1362: dbms_sql.parse(c, statement, dbms_sql.native);
1363: --
1364: IF PG_DEBUG in ('Y', 'C') THEN
1365: arp_standard.debug('Inside populate_interim_table()');
1366: arp_standard.debug( 'Statement ' || statement);
1367: END IF;
1368: -- Bind variables
1369: --
1370: dbms_sql.bind_variable(c, ':b_clear_date' ,p_clear_date);

Line 1406: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

1402: fnd_file.put_line( FND_FILE.LOG, 'populate_interim_table()-');
1403: --
1404: EXCEPTION
1405: WHEN OTHERS THEN
1406: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
1407: RAISE;
1408: --
1409: END;
1410: --

Line 1436: arp_standard.debug( 'Statement ' || statement);

1432: 'request_id = :b_request_id ' ||
1433: 'and current_worker = :b_worker_number '||
1434: 'and type = ''RISK'' ';
1435: IF PG_DEBUG in ('Y', 'C') THEN
1436: arp_standard.debug( 'Statement ' || statement);
1437: END IF;
1438: fnd_file.put_line(fnd_file.log, 'main_select_risk_parallel()-');
1439: --
1440: EXCEPTION

Line 1442: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

1438: fnd_file.put_line(fnd_file.log, 'main_select_risk_parallel()-');
1439: --
1440: EXCEPTION
1441: WHEN OTHERS THEN
1442: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
1443: RAISE;
1444: --
1445: END;
1446: --

Line 1484: arp_standard.debug( 'Statement ' || statement);

1480: 'request_id = :b_request_id ' ||
1481: 'and current_worker = :b_worker_number '||
1482: 'and type = ''FACTOR'' ';
1483: IF PG_DEBUG in ('Y', 'C') THEN
1484: arp_standard.debug( 'Statement ' || statement);
1485: END IF;
1486: fnd_file.put_line(fnd_file.log, 'main_select_factored_parallel()-');
1487: EXCEPTION
1488: WHEN OTHERS THEN

Line 1489: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

1485: END IF;
1486: fnd_file.put_line(fnd_file.log, 'main_select_factored_parallel()-');
1487: EXCEPTION
1488: WHEN OTHERS THEN
1489: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
1490: RAISE;
1491: --
1492: END;
1493: --

Line 1530: arp_standard.debug( 'Statement ' || statement);

1526: 'request_id = :b_request_id ' ||
1527: 'and current_worker = :b_worker_number '||
1528: 'and type = ''REMIT'' ';
1529: IF PG_DEBUG in ('Y', 'C') THEN
1530: arp_standard.debug( 'Statement ' || statement);
1531: END IF;
1532: fnd_file.put_line(fnd_file.log, 'main_select_remitted_parallel()-');
1533: --
1534: EXCEPTION

Line 1536: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

1532: fnd_file.put_line(fnd_file.log, 'main_select_remitted_parallel()-');
1533: --
1534: EXCEPTION
1535: WHEN OTHERS THEN
1536: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
1537: RAISE;
1538: --
1539: END;
1540: --

Line 1560: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

1556: END IF;
1557: --
1558: EXCEPTION
1559: WHEN OTHERS THEN
1560: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
1561: RAISE;
1562: --
1563: END;
1564: --

Line 1765: arp_standard.debug('Before calling arp_cashbook.clear');

1761: ARP_GLOBAL.functional_currency,
1762: nvl(v_ex_rate,1),
1763: NULL,NULL );
1764: END IF;
1765: arp_standard.debug('Before calling arp_cashbook.clear');
1766: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));
1767: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1768: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
1769: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));

Line 1766: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));

1762: nvl(v_ex_rate,1),
1763: NULL,NULL );
1764: END IF;
1765: arp_standard.debug('Before calling arp_cashbook.clear');
1766: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));
1767: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1768: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
1769: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1770: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));

Line 1767: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));

1763: NULL,NULL );
1764: END IF;
1765: arp_standard.debug('Before calling arp_cashbook.clear');
1766: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));
1767: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1768: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
1769: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1770: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1771: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);

Line 1768: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));

1764: END IF;
1765: arp_standard.debug('Before calling arp_cashbook.clear');
1766: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));
1767: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1768: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
1769: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1770: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1771: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1772: arp_standard.debug('v_currency :' || v_currency);

Line 1769: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));

1765: arp_standard.debug('Before calling arp_cashbook.clear');
1766: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));
1767: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1768: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
1769: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1770: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1771: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1772: arp_standard.debug('v_currency :' || v_currency);
1773: arp_standard.debug('New v_amount :' || to_char(v_amount));

Line 1770: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));

1766: arp_standard.debug('remitted_or_factored_or_risk :' || to_char(remitted_or_factored_or_risk));
1767: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1768: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
1769: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1770: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1771: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1772: arp_standard.debug('v_currency :' || v_currency);
1773: arp_standard.debug('New v_amount :' || to_char(v_amount));
1774: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));

Line 1771: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);

1767: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1768: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
1769: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1770: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1771: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1772: arp_standard.debug('v_currency :' || v_currency);
1773: arp_standard.debug('New v_amount :' || to_char(v_amount));
1774: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));
1775: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));

Line 1772: arp_standard.debug('v_currency :' || v_currency);

1768: arp_standard.debug('v_trx_date[clear_date] :' || to_char(v_trx_date));
1769: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1770: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1771: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1772: arp_standard.debug('v_currency :' || v_currency);
1773: arp_standard.debug('New v_amount :' || to_char(v_amount));
1774: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));
1775: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));
1776: arp_standard.debug('v_cr_currency :' || v_cr_currency);

Line 1773: arp_standard.debug('New v_amount :' || to_char(v_amount));

1769: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1770: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1771: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1772: arp_standard.debug('v_currency :' || v_currency);
1773: arp_standard.debug('New v_amount :' || to_char(v_amount));
1774: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));
1775: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));
1776: arp_standard.debug('v_cr_currency :' || v_cr_currency);
1777:

Line 1774: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));

1770: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1771: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1772: arp_standard.debug('v_currency :' || v_currency);
1773: arp_standard.debug('New v_amount :' || to_char(v_amount));
1774: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));
1775: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));
1776: arp_standard.debug('v_cr_currency :' || v_cr_currency);
1777:
1778: arp_cashbook.clear( v_cr_id,

Line 1775: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));

1771: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1772: arp_standard.debug('v_currency :' || v_currency);
1773: arp_standard.debug('New v_amount :' || to_char(v_amount));
1774: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));
1775: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));
1776: arp_standard.debug('v_cr_currency :' || v_cr_currency);
1777:
1778: arp_cashbook.clear( v_cr_id,
1779: v_trx_date,

Line 1776: arp_standard.debug('v_cr_currency :' || v_cr_currency);

1772: arp_standard.debug('v_currency :' || v_currency);
1773: arp_standard.debug('New v_amount :' || to_char(v_amount));
1774: arp_standard.debug('v_fac_disc_amount :' || to_char(v_fac_disc_amount));
1775: arp_standard.debug('v_ex_rate_old :' || to_char(v_ex_rate_old));
1776: arp_standard.debug('v_cr_currency :' || v_cr_currency);
1777:
1778: arp_cashbook.clear( v_cr_id,
1779: v_trx_date,
1780: v_gl_date,

Line 1796: arp_standard.debug('ar_automatic_clearing_pkg: NO_RATE');

1792: /* bug: 3820774 Added the handling of exception rate. */
1793: ELSE
1794: IF v_ex_rate = -1
1795: THEN
1796: arp_standard.debug('ar_automatic_clearing_pkg: NO_RATE');
1797: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1798: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1799: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1800: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));

Line 1797: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));

1793: ELSE
1794: IF v_ex_rate = -1
1795: THEN
1796: arp_standard.debug('ar_automatic_clearing_pkg: NO_RATE');
1797: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1798: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1799: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1800: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1801:

Line 1798: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));

1794: IF v_ex_rate = -1
1795: THEN
1796: arp_standard.debug('ar_automatic_clearing_pkg: NO_RATE');
1797: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1798: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1799: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1800: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1801:
1802: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');

Line 1799: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);

1795: THEN
1796: arp_standard.debug('ar_automatic_clearing_pkg: NO_RATE');
1797: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1798: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1799: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1800: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1801:
1802: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');
1803: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));

Line 1800: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));

1796: arp_standard.debug('ar_automatic_clearing_pkg: NO_RATE');
1797: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1798: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1799: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1800: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1801:
1802: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');
1803: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
1804: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));

Line 1810: arp_standard.debug('ar_automatic_clearing_pkg: INVALID_CURRENCY');

1806: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
1807:
1808: ELSIF v_ex_rate = -2
1809: THEN
1810: arp_standard.debug('ar_automatic_clearing_pkg: INVALID_CURRENCY');
1811: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1812: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1813: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1814: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));

Line 1811: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));

1807:
1808: ELSIF v_ex_rate = -2
1809: THEN
1810: arp_standard.debug('ar_automatic_clearing_pkg: INVALID_CURRENCY');
1811: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1812: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1813: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1814: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1815:

Line 1812: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));

1808: ELSIF v_ex_rate = -2
1809: THEN
1810: arp_standard.debug('ar_automatic_clearing_pkg: INVALID_CURRENCY');
1811: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1812: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1813: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1814: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1815:
1816: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: INVALID_CURRENCY');

Line 1813: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);

1809: THEN
1810: arp_standard.debug('ar_automatic_clearing_pkg: INVALID_CURRENCY');
1811: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1812: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1813: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1814: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1815:
1816: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: INVALID_CURRENCY');
1817: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));

Line 1814: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));

1810: arp_standard.debug('ar_automatic_clearing_pkg: INVALID_CURRENCY');
1811: arp_standard.debug('v_cr_id :' || to_char(v_cr_id));
1812: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1813: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1814: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1815:
1816: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: INVALID_CURRENCY');
1817: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
1818: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));

Line 1850: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

1846: fnd_file.put_line(fnd_file.log, 'clr_remit_disc_risk_rcpts_pa()-');
1847: --
1848: EXCEPTION
1849: WHEN OTHERS THEN
1850: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
1851: RAISE;
1852: --
1853: END;
1854: --