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 FND_FILE

Line 784: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');

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));
787: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
788: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));

Line 785: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));

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));
787: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
788: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
789:

Line 786: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));

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));
787: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
788: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
789:
790: ELSIF v_ex_rate = -2

Line 787: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);

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));
787: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
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

Line 788: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));

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));
787: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
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');

Line 798: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: INVALID_CURRENCY');

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));
801: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
802: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));

Line 799: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));

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));
801: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
802: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
803:

Line 800: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));

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));
801: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
802: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
803:
804: END IF;

Line 801: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);

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));
801: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
802: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
803:
804: END IF;
805: END IF;

Line 802: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));

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));
801: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
802: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
803:
804: END IF;
805: END IF;
806: ELSE

Line 1054: fnd_file.put_line( FND_FILE.LOG, 'submit_subrequest()+' );

1050: PROCEDURE submit_subrequest (p_worker_number IN NUMBER,
1051: p_org_id IN NUMBER,
1052: p_master_request_id IN NUMBER) IS
1053: BEGIN
1054: fnd_file.put_line( FND_FILE.LOG, 'submit_subrequest()+' );
1055:
1056: FND_REQUEST.SET_ORG_ID(p_org_id);
1057:
1058: l_request_id := FND_REQUEST.submit_request( 'AR', 'AUTOCLEAR',

Line 1081: fnd_file.put_line( FND_FILE.LOG, 'submit_subrequest()-');

1077: END IF;
1078:
1079: l_req_status_tab(p_worker_number).request_id := l_request_id;
1080:
1081: fnd_file.put_line( FND_FILE.LOG, 'submit_subrequest()-');
1082:
1083: END submit_subrequest;
1084:
1085: BEGIN

Line 1086: fnd_file.put_line( FND_FILE.LOG, 'ar_automatic_clearing_in_parallel()+');

1082:
1083: END submit_subrequest;
1084:
1085: BEGIN
1086: fnd_file.put_line( FND_FILE.LOG, 'ar_automatic_clearing_in_parallel()+');
1087:
1088: --fetch org id,need to set it for child requests
1089: SELECT org_id
1090: INTO l_org_id

Line 1161: fnd_file.put_line( FND_FILE.LOG, SQLERRM);

1157: from ar_autoclear_interim
1158: where request_id = l_master_request_id;
1159: EXCEPTION
1160: WHEN OTHERS THEN
1161: fnd_file.put_line( FND_FILE.LOG, SQLERRM);
1162: l_count := 0;
1163: END;
1164: fnd_file.put_line( FND_FILE.LOG, 'No of Receipts Selected :'||l_count);
1165: IF l_count > 0 THEN

Line 1164: fnd_file.put_line( FND_FILE.LOG, 'No of Receipts Selected :'||l_count);

1160: WHEN OTHERS THEN
1161: fnd_file.put_line( FND_FILE.LOG, SQLERRM);
1162: l_count := 0;
1163: END;
1164: fnd_file.put_line( FND_FILE.LOG, 'No of Receipts Selected :'||l_count);
1165: IF l_count > 0 THEN
1166: --Invoke the child programs
1167: FOR l_worker_number IN 1..p_total_workers LOOP
1168: fnd_file.put_line(FND_FILE.LOG,'worker # : ' || l_worker_number );

Line 1168: fnd_file.put_line(FND_FILE.LOG,'worker # : ' || l_worker_number );

1164: fnd_file.put_line( FND_FILE.LOG, 'No of Receipts Selected :'||l_count);
1165: IF l_count > 0 THEN
1166: --Invoke the child programs
1167: FOR l_worker_number IN 1..p_total_workers LOOP
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');

Line 1208: fnd_file.put_line( FND_FILE.LOG, 'Master Program completed in Error.');

1204: commit;
1205: END IF;
1206:
1207: IF P_RETCODE = 2 THEN
1208: fnd_file.put_line( FND_FILE.LOG, 'Master Program completed in Error.');
1209: fnd_file.put_line( FND_FILE.LOG, 'Possibly Child process(es) might have errored out.');
1210: arp_util.debug('Exception: ar_automatic_clearing_pkg '|| SQLERRM);
1211: RAISE error_in_child;
1212: END IF;

Line 1209: fnd_file.put_line( FND_FILE.LOG, 'Possibly Child process(es) might have errored out.');

1205: END IF;
1206:
1207: IF P_RETCODE = 2 THEN
1208: fnd_file.put_line( FND_FILE.LOG, 'Master Program completed in Error.');
1209: fnd_file.put_line( FND_FILE.LOG, 'Possibly Child process(es) might have errored out.');
1210: arp_util.debug('Exception: ar_automatic_clearing_pkg '|| SQLERRM);
1211: RAISE error_in_child;
1212: END IF;
1213: fnd_file.put_line( FND_FILE.LOG, 'ar_automatic_clearing_in_parallel()-');

Line 1213: fnd_file.put_line( FND_FILE.LOG, 'ar_automatic_clearing_in_parallel()-');

1209: fnd_file.put_line( FND_FILE.LOG, 'Possibly Child process(es) might have errored out.');
1210: arp_util.debug('Exception: ar_automatic_clearing_pkg '|| SQLERRM);
1211: RAISE error_in_child;
1212: END IF;
1213: fnd_file.put_line( FND_FILE.LOG, 'ar_automatic_clearing_in_parallel()-');
1214: return TRUE;
1215: EXCEPTION
1216: WHEN OTHERS THEN
1217: arp_util.debug('Exception: ar_automatic_clearing_pkg '|| SQLERRM);

Line 1270: fnd_file.put_line( FND_FILE.LOG, 'populate_interim_table()+');

1266:
1267: --
1268: BEGIN
1269: --
1270: fnd_file.put_line( FND_FILE.LOG, 'populate_interim_table()+');
1271: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;
1272: --
1273: IF ( remitted_or_factored_or_risk = 1) THEN
1274: statement := 'INSERT INTO ar_autoclear_interim

Line 1396: fnd_file.put_line(fnd_file.LOG, 'No of Records Selected : '|| ignore);

1392: c );
1393: --
1394: ignore := dbms_sql.execute(c);
1395: IF PG_DEBUG IN ('Y','C') THEN
1396: fnd_file.put_line(fnd_file.LOG, 'No of Records Selected : '|| ignore);
1397: END IF;
1398: --
1399: commit; -- Commit the values inserted into the interim table.
1400: --

Line 1402: fnd_file.put_line( FND_FILE.LOG, 'populate_interim_table()-');

1398: --
1399: commit; -- Commit the values inserted into the interim table.
1400: --
1401: dbms_sql.close_cursor(c);
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 ');

Line 1421: fnd_file.put_line(fnd_file.log, 'main_select_risk_parallel()+');

1417: /* 07-JUL-2000 J Rautiainen BR Implementation
1418: * Receipts created by the Bills Receivable transaction remittance process
1419: * having BR_REMIT receipt class cannot be risk eliminated */
1420: /*5444413 Index hint added*/
1421: fnd_file.put_line(fnd_file.log, 'main_select_risk_parallel()+');
1422: statement := 'select ' ||
1423: 'cash_receipt_id, ' ||
1424: 'trx_date, ' ||
1425: 'gl_date , ' ||

Line 1438: fnd_file.put_line(fnd_file.log, 'main_select_risk_parallel()-');

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
1441: WHEN OTHERS THEN
1442: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

Line 1459: fnd_file.put_line(fnd_file.log, 'main_select_factored_parallel()+');

1455: than an NVL for the function call itself . */
1456:
1457: /* Bug 3820774 Replaced the get_rate with get_rate_sql. */
1458: /*Bug5444413 Added hint */
1459: fnd_file.put_line(fnd_file.log, 'main_select_factored_parallel()+');
1460: statement := 'select ' ||
1461: 'cash_receipt_id, '||
1462: 'trx_date, ' ||
1463: 'gl_date, ' ||

Line 1486: fnd_file.put_line(fnd_file.log, 'main_select_factored_parallel()-');

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
1489: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
1490: RAISE;

Line 1505: fnd_file.put_line(fnd_file.log, 'main_select_remitted_parallel()+');

1501: there is an NVL for the exchange_rate_type parameter rather
1502: than an NVL for the function call itself . */
1503: /* Bug 3820774 Replaced the get_rate with get_rate_sql. */
1504: /*5444413 hint added here*/
1505: fnd_file.put_line(fnd_file.log, 'main_select_remitted_parallel()+');
1506: statement := 'select ' ||
1507: 'cash_receipt_id, '||
1508: 'trx_date, ' ||
1509: 'gl_date, ' ||

Line 1532: fnd_file.put_line(fnd_file.log, 'main_select_remitted_parallel()-');

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
1535: WHEN OTHERS THEN
1536: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

Line 1600: fnd_file.put_line(fnd_file.log, 'clr_remit_disc_risk_rcpts_pa()+');

1596:
1597: --
1598: BEGIN
1599: --
1600: fnd_file.put_line(fnd_file.log, 'clr_remit_disc_risk_rcpts_pa()+');
1601: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;
1602: --
1603: IF ( remitted_or_factored_or_risk = 1) THEN
1604: main_select_remitted_parallel(

Line 1624: fnd_file.put_line(fnd_file.log, 'Worker No ' ||p_worker_number);

1620: dbms_sql.parse(c, statement, dbms_sql.native);
1621: --
1622: -- Bind variables
1623: --
1624: fnd_file.put_line(fnd_file.log, 'Worker No ' ||p_worker_number);
1625: fnd_file.put_line(fnd_file.log, 'Request_id '||p_request_id);
1626: ar_bind_variables_parallel(
1627: p_worker_number,
1628: p_request_id,

Line 1625: fnd_file.put_line(fnd_file.log, 'Request_id '||p_request_id);

1621: --
1622: -- Bind variables
1623: --
1624: fnd_file.put_line(fnd_file.log, 'Worker No ' ||p_worker_number);
1625: fnd_file.put_line(fnd_file.log, 'Request_id '||p_request_id);
1626: ar_bind_variables_parallel(
1627: p_worker_number,
1628: p_request_id,
1629: c );

Line 1802: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');

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));
1805: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1806: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));

Line 1803: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));

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));
1805: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1806: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
1807:

Line 1804: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));

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));
1805: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1806: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
1807:
1808: ELSIF v_ex_rate = -2

Line 1805: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);

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));
1805: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
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

Line 1806: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));

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));
1805: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
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');

Line 1816: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: INVALID_CURRENCY');

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));
1819: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1820: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));

Line 1817: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));

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));
1819: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1820: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
1821:

Line 1818: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));

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));
1819: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1820: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
1821:
1822: END IF;

Line 1819: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);

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));
1819: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1820: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
1821:
1822: END IF;
1823: END IF;

Line 1820: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));

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));
1819: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1820: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
1821:
1822: END IF;
1823: END IF;
1824: ELSE

Line 1846: fnd_file.put_line(fnd_file.log, 'clr_remit_disc_risk_rcpts_pa()-');

1842:
1843: END IF;
1844: --
1845: dbms_sql.close_cursor(c);
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 ');