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 770: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');

766: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
767: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
768: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
769:
770: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');
771: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
772: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));
773: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
774: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));

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

767: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
768: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
769:
770: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');
771: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
772: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));
773: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
774: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
775:

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

768: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
769:
770: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');
771: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
772: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));
773: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
774: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
775:
776: ELSIF v_ex_rate = -2

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

769:
770: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');
771: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
772: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));
773: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
774: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
775:
776: ELSIF v_ex_rate = -2
777: THEN

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

770: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');
771: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
772: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));
773: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
774: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
775:
776: ELSIF v_ex_rate = -2
777: THEN
778: arp_standard.debug('ar_automatic_clearing_pkg: INVALID_CURRENCY');

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

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: INVALID_CURRENCY');
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: INVALID_CURRENCY');
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: INVALID_CURRENCY');
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: END IF;

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: INVALID_CURRENCY');
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: END IF;
791: END IF;

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: INVALID_CURRENCY');
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: END IF;
791: END IF;
792: ELSE

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

1022: PROCEDURE submit_subrequest (p_worker_number IN NUMBER,
1023: p_org_id IN NUMBER,
1024: p_master_request_id IN NUMBER) IS
1025: BEGIN
1026: fnd_file.put_line( FND_FILE.LOG, 'submit_subrequest()+' );
1027:
1028: FND_REQUEST.SET_ORG_ID(p_org_id);
1029:
1030: l_request_id := FND_REQUEST.submit_request( 'AR', 'AUTOCLEAR',

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

1049: END IF;
1050:
1051: l_req_status_tab(p_worker_number).request_id := l_request_id;
1052:
1053: fnd_file.put_line( FND_FILE.LOG, 'submit_subrequest()-');
1054:
1055: END submit_subrequest;
1056:
1057: BEGIN

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

1054:
1055: END submit_subrequest;
1056:
1057: BEGIN
1058: fnd_file.put_line( FND_FILE.LOG, 'ar_automatic_clearing_in_parallel()+');
1059:
1060: --fetch org id,need to set it for child requests
1061: SELECT org_id
1062: INTO l_org_id

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

1129: from ar_autoclear_interim
1130: where request_id = l_master_request_id;
1131: EXCEPTION
1132: WHEN OTHERS THEN
1133: fnd_file.put_line( FND_FILE.LOG, SQLERRM);
1134: l_count := 0;
1135: END;
1136: fnd_file.put_line( FND_FILE.LOG, 'No of Receipts Selected :'||l_count);
1137: IF l_count > 0 THEN

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

1132: WHEN OTHERS THEN
1133: fnd_file.put_line( FND_FILE.LOG, SQLERRM);
1134: l_count := 0;
1135: END;
1136: fnd_file.put_line( FND_FILE.LOG, 'No of Receipts Selected :'||l_count);
1137: IF l_count > 0 THEN
1138: --Invoke the child programs
1139: FOR l_worker_number IN 1..p_total_workers LOOP
1140: fnd_file.put_line(FND_FILE.LOG,'worker # : ' || l_worker_number );

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

1136: fnd_file.put_line( FND_FILE.LOG, 'No of Receipts Selected :'||l_count);
1137: IF l_count > 0 THEN
1138: --Invoke the child programs
1139: FOR l_worker_number IN 1..p_total_workers LOOP
1140: fnd_file.put_line(FND_FILE.LOG,'worker # : ' || l_worker_number );
1141: submit_subrequest (l_worker_number,l_org_id,l_master_request_id);
1142: END LOOP;
1143:
1144: arp_standard.debug ( 'The Master program waits for child processes');

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

1176: commit;
1177: END IF;
1178:
1179: IF P_RETCODE = 2 THEN
1180: fnd_file.put_line( FND_FILE.LOG, 'Master Program completed in Error.');
1181: fnd_file.put_line( FND_FILE.LOG, 'Possibly Child process(es) might have errored out.');
1182: arp_util.debug('Exception: ar_automatic_clearing_pkg '|| SQLERRM);
1183: RAISE error_in_child;
1184: END IF;

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

1177: END IF;
1178:
1179: IF P_RETCODE = 2 THEN
1180: fnd_file.put_line( FND_FILE.LOG, 'Master Program completed in Error.');
1181: fnd_file.put_line( FND_FILE.LOG, 'Possibly Child process(es) might have errored out.');
1182: arp_util.debug('Exception: ar_automatic_clearing_pkg '|| SQLERRM);
1183: RAISE error_in_child;
1184: END IF;
1185: fnd_file.put_line( FND_FILE.LOG, 'ar_automatic_clearing_in_parallel()-');

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

1181: fnd_file.put_line( FND_FILE.LOG, 'Possibly Child process(es) might have errored out.');
1182: arp_util.debug('Exception: ar_automatic_clearing_pkg '|| SQLERRM);
1183: RAISE error_in_child;
1184: END IF;
1185: fnd_file.put_line( FND_FILE.LOG, 'ar_automatic_clearing_in_parallel()-');
1186: return TRUE;
1187: EXCEPTION
1188: WHEN OTHERS THEN
1189: arp_util.debug('Exception: ar_automatic_clearing_pkg '|| SQLERRM);

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

1238:
1239: --
1240: BEGIN
1241: --
1242: fnd_file.put_line( FND_FILE.LOG, 'populate_interim_table()+');
1243: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;
1244: --
1245: IF ( remitted_or_factored_or_risk = 1) THEN
1246: statement := 'INSERT INTO ar_autoclear_interim

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

1364: c );
1365: --
1366: ignore := dbms_sql.execute(c);
1367: IF PG_DEBUG IN ('Y','C') THEN
1368: fnd_file.put_line(fnd_file.LOG, 'No of Records Selected : '|| ignore);
1369: END IF;
1370: --
1371: commit; -- Commit the values inserted into the interim table.
1372: --

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

1370: --
1371: commit; -- Commit the values inserted into the interim table.
1372: --
1373: dbms_sql.close_cursor(c);
1374: fnd_file.put_line( FND_FILE.LOG, 'populate_interim_table()-');
1375: --
1376: EXCEPTION
1377: WHEN OTHERS THEN
1378: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

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

1389: /* 07-JUL-2000 J Rautiainen BR Implementation
1390: * Receipts created by the Bills Receivable transaction remittance process
1391: * having BR_REMIT receipt class cannot be risk eliminated */
1392: /*5444413 Index hint added*/
1393: fnd_file.put_line(fnd_file.log, 'main_select_risk_parallel()+');
1394: statement := 'select ' ||
1395: 'cash_receipt_id, ' ||
1396: 'trx_date, ' ||
1397: 'gl_date , ' ||

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

1406: 'and type = ''RISK'' ';
1407: IF PG_DEBUG in ('Y', 'C') THEN
1408: arp_standard.debug( 'Statement ' || statement);
1409: END IF;
1410: fnd_file.put_line(fnd_file.log, 'main_select_risk_parallel()-');
1411: --
1412: EXCEPTION
1413: WHEN OTHERS THEN
1414: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

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

1427: than an NVL for the function call itself . */
1428:
1429: /* Bug 3820774 Replaced the get_rate with get_rate_sql. */
1430: /*Bug5444413 Added hint */
1431: fnd_file.put_line(fnd_file.log, 'main_select_factored_parallel()+');
1432: statement := 'select ' ||
1433: 'cash_receipt_id, '||
1434: 'trx_date, ' ||
1435: 'gl_date, ' ||

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

1454: 'and type = ''FACTOR'' ';
1455: IF PG_DEBUG in ('Y', 'C') THEN
1456: arp_standard.debug( 'Statement ' || statement);
1457: END IF;
1458: fnd_file.put_line(fnd_file.log, 'main_select_factored_parallel()-');
1459: EXCEPTION
1460: WHEN OTHERS THEN
1461: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');
1462: RAISE;

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

1473: there is an NVL for the exchange_rate_type parameter rather
1474: than an NVL for the function call itself . */
1475: /* Bug 3820774 Replaced the get_rate with get_rate_sql. */
1476: /*5444413 hint added here*/
1477: fnd_file.put_line(fnd_file.log, 'main_select_remitted_parallel()+');
1478: statement := 'select ' ||
1479: 'cash_receipt_id, '||
1480: 'trx_date, ' ||
1481: 'gl_date, ' ||

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

1500: 'and type = ''REMIT'' ';
1501: IF PG_DEBUG in ('Y', 'C') THEN
1502: arp_standard.debug( 'Statement ' || statement);
1503: END IF;
1504: fnd_file.put_line(fnd_file.log, 'main_select_remitted_parallel()-');
1505: --
1506: EXCEPTION
1507: WHEN OTHERS THEN
1508: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');

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

1568:
1569: --
1570: BEGIN
1571: --
1572: fnd_file.put_line(fnd_file.log, 'clr_remit_disc_risk_rcpts_pa()+');
1573: select set_of_books_id INTO v_set_of_bks_id from ar_system_parameters;
1574: --
1575: IF ( remitted_or_factored_or_risk = 1) THEN
1576: main_select_remitted_parallel(

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

1592: dbms_sql.parse(c, statement, dbms_sql.native);
1593: --
1594: -- Bind variables
1595: --
1596: fnd_file.put_line(fnd_file.log, 'Worker No ' ||p_worker_number);
1597: fnd_file.put_line(fnd_file.log, 'Request_id '||p_request_id);
1598: ar_bind_variables_parallel(
1599: p_worker_number,
1600: p_request_id,

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

1593: --
1594: -- Bind variables
1595: --
1596: fnd_file.put_line(fnd_file.log, 'Worker No ' ||p_worker_number);
1597: fnd_file.put_line(fnd_file.log, 'Request_id '||p_request_id);
1598: ar_bind_variables_parallel(
1599: p_worker_number,
1600: p_request_id,
1601: c );

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

1756: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1757: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1758: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1759:
1760: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');
1761: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
1762: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));
1763: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1764: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));

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

1757: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1758: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1759:
1760: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');
1761: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
1762: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));
1763: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1764: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
1765:

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

1758: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1759:
1760: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');
1761: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
1762: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));
1763: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1764: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
1765:
1766: ELSIF v_ex_rate = -2

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

1759:
1760: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');
1761: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
1762: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));
1763: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1764: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
1765:
1766: ELSIF v_ex_rate = -2
1767: THEN

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

1760: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: NO_RATE');
1761: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
1762: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));
1763: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1764: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
1765:
1766: ELSIF v_ex_rate = -2
1767: THEN
1768: arp_standard.debug('ar_automatic_clearing_pkg: INVALID_CURRENCY');

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

1770: arp_standard.debug('v_ex_date :' || to_char(v_ex_date));
1771: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1772: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1773:
1774: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: INVALID_CURRENCY');
1775: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
1776: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));
1777: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1778: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));

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

1771: arp_standard.debug('v_ex_rate_type :' || v_ex_rate_type);
1772: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1773:
1774: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: INVALID_CURRENCY');
1775: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
1776: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));
1777: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1778: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
1779:

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

1772: arp_standard.debug('v_ex_rate :' || to_char(v_ex_rate));
1773:
1774: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: INVALID_CURRENCY');
1775: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
1776: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));
1777: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1778: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
1779:
1780: END IF;

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

1773:
1774: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: INVALID_CURRENCY');
1775: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
1776: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));
1777: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1778: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
1779:
1780: END IF;
1781: END IF;

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

1774: fnd_file.put_line(fnd_file.log,'ar_automatic_clearing_pkg: INVALID_CURRENCY');
1775: fnd_file.put_line(fnd_file.log,'v_cr_id :' || to_char(v_cr_id));
1776: fnd_file.put_line(fnd_file.log,'v_ex_date :' || to_char(v_ex_date));
1777: fnd_file.put_line(fnd_file.log,'v_ex_rate_type :' || v_ex_rate_type);
1778: fnd_file.put_line(fnd_file.log,'v_ex_rate :' || to_char(v_ex_rate));
1779:
1780: END IF;
1781: END IF;
1782: ELSE

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

1786: END LOOP;
1787: END IF;
1788: --
1789: dbms_sql.close_cursor(c);
1790: fnd_file.put_line(fnd_file.log, 'clr_remit_disc_risk_rcpts_pa()-');
1791: --
1792: EXCEPTION
1793: WHEN OTHERS THEN
1794: arp_standard.debug('Exception: ar_automatic_clearing_pkg ');