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.IEX_OPI_PVT dependencies on FND_FILE

Line 129: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS REPORTED = ' || l_cust_reported);

125: --dbms_output.PUT_LINE('CUSTOMERS NOT REPORTED = ' || l_cust_not_reported);
126: --dbms_output.PUT_LINE('CUSTOMERS TO BE REPORTED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
127: --dbms_output.PUT_LINE('CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);
128:
129: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS REPORTED = ' || l_cust_reported);
130: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOT REPORTED = ' || l_cust_not_reported);
131: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
132: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);
133:

Line 130: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOT REPORTED = ' || l_cust_not_reported);

126: --dbms_output.PUT_LINE('CUSTOMERS TO BE REPORTED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
127: --dbms_output.PUT_LINE('CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);
128:
129: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS REPORTED = ' || l_cust_reported);
130: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOT REPORTED = ' || l_cust_not_reported);
131: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
132: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);
133:
134: COMMIT;

Line 131: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED PROCESSED SUCCESSFULLY = ' || l_rows_processed);

127: --dbms_output.PUT_LINE('CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);
128:
129: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS REPORTED = ' || l_cust_reported);
130: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOT REPORTED = ' || l_cust_not_reported);
131: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
132: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);
133:
134: COMMIT;
135: EXCEPTION

Line 132: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);

128:
129: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS REPORTED = ' || l_cust_reported);
130: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOT REPORTED = ' || l_cust_not_reported);
131: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
132: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);
133:
134: COMMIT;
135: EXCEPTION
136: WHEN OTHERS THEN

Line 142: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);

138: CLOSE l_report_all_csr;
139: END IF;
140: errbuf := substr(SQLERRM, 1, 200);
141: retcode := 1;
142: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);
143: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);
144: ROLLBACK;
145: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
146: END report_all_credit_bureau;

Line 143: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);

139: END IF;
140: errbuf := substr(SQLERRM, 1, 200);
141: retcode := 1;
142: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);
143: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);
144: ROLLBACK;
145: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
146: END report_all_credit_bureau;
147:

Line 347: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, FND_MESSAGE.GET);

343:
344: IF(l_iohv_rec.ext_agncy_id IS NULL) THEN
345: FND_MESSAGE.SET_NAME('IEX', 'IEX_EXTERNAL_AGENCY_UNASSIGNED');
346: FND_MESSAGE.SET_TOKEN('CASE_ID', TO_CHAR(l_oinv_rec.cas_id));
347: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, FND_MESSAGE.GET);
348: END IF;
349: END IF;
350:
351: IF(l_iohv_rec.ext_agncy_id IS NOT NULL) THEN

Line 699: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'ROWS PROCESSED SUCCESSFULLY = ' || l_rows_processed);

695: END IF;
696: END LOOP;
697: CLOSE l_oin_pend_csr;
698:
699: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'ROWS PROCESSED SUCCESSFULLY = ' || l_rows_processed);
700: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'ROWS NOT PROCESSED = ' || l_rows_failed);
701:
702: COMMIT;
703: EXCEPTION

Line 700: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'ROWS NOT PROCESSED = ' || l_rows_failed);

696: END LOOP;
697: CLOSE l_oin_pend_csr;
698:
699: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'ROWS PROCESSED SUCCESSFULLY = ' || l_rows_processed);
700: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'ROWS NOT PROCESSED = ' || l_rows_failed);
701:
702: COMMIT;
703: EXCEPTION
704: WHEN OTHERS THEN

Line 710: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);

706: CLOSE l_oin_pend_csr;
707: END IF;
708: errbuf := substr(SQLERRM, 1, 200);
709: retcode := 1;
710: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);
711: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);
712: ROLLBACK;
713: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
714: END process_pending;

Line 711: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);

707: END IF;
708: errbuf := substr(SQLERRM, 1, 200);
709: retcode := 1;
710: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);
711: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);
712: ROLLBACK;
713: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
714: END process_pending;
715:

Line 1900: fnd_file.put_line(FND_FILE.LOG, ' Task creation failed due to invalid owner for contract '||l_contract_number);

1896: --Begin bug#5246309 schekuri 29-Jun-2006
1897: --Added log message when failed.
1898: IF x_return_status<>fnd_api.g_ret_sts_success THEN
1899: IF l_owner_id IS NULL THEN
1900: fnd_file.put_line(FND_FILE.LOG, ' Task creation failed due to invalid owner for contract '||l_contract_number);
1901: ELSE
1902: fnd_file.put_line(FND_FILE.LOG, ' Task creation failed for contract '||l_contract_number);
1903: END IF;
1904: END IF;

Line 1902: fnd_file.put_line(FND_FILE.LOG, ' Task creation failed for contract '||l_contract_number);

1898: IF x_return_status<>fnd_api.g_ret_sts_success THEN
1899: IF l_owner_id IS NULL THEN
1900: fnd_file.put_line(FND_FILE.LOG, ' Task creation failed due to invalid owner for contract '||l_contract_number);
1901: ELSE
1902: fnd_file.put_line(FND_FILE.LOG, ' Task creation failed for contract '||l_contract_number);
1903: END IF;
1904: END IF;
1905: --End bug#5246309 schekuri 29-Jun-2006
1906:

Line 2208: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, FND_MESSAGE.GET );

2204: x_msg_count => lx_msg_count,
2205: x_msg_data => lx_msg_data);
2206: ELSE
2207: FND_MESSAGE.SET_NAME('IEX', 'IEX_INVALID_FULFILLMENT_SETUP');
2208: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, FND_MESSAGE.GET );
2209: l_rows_failed := l_rows_failed + 1;
2210: END IF;
2211: ELSE
2212: l_cust_not_notified := l_cust_not_notified + 1;

Line 2221: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOTIFIED = ' || l_cust_notified);

2217: --dbms_output.PUT_LINE('CUSTOMERS NOTIFIED = ' || l_cust_notified);
2218: --dbms_output.PUT_LINE('CUSTOMERS NOT NOTIFIED = ' || l_cust_not_notified);
2219: --dbms_output.PUT_LINE('CUSTOMERS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
2220: --dbms_output.PUT_LINE('CUSTOMERS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2221: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOTIFIED = ' || l_cust_notified);
2222: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOT NOTIFIED = ' || l_cust_not_notified);
2223: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
2224: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2225:

Line 2222: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOT NOTIFIED = ' || l_cust_not_notified);

2218: --dbms_output.PUT_LINE('CUSTOMERS NOT NOTIFIED = ' || l_cust_not_notified);
2219: --dbms_output.PUT_LINE('CUSTOMERS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
2220: --dbms_output.PUT_LINE('CUSTOMERS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2221: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOTIFIED = ' || l_cust_notified);
2222: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOT NOTIFIED = ' || l_cust_not_notified);
2223: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
2224: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2225:
2226: COMMIT;

Line 2223: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);

2219: --dbms_output.PUT_LINE('CUSTOMERS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
2220: --dbms_output.PUT_LINE('CUSTOMERS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2221: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOTIFIED = ' || l_cust_notified);
2222: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOT NOTIFIED = ' || l_cust_not_notified);
2223: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
2224: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2225:
2226: COMMIT;
2227: EXCEPTION

Line 2224: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);

2220: --dbms_output.PUT_LINE('CUSTOMERS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2221: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOTIFIED = ' || l_cust_notified);
2222: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOT NOTIFIED = ' || l_cust_not_notified);
2223: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
2224: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2225:
2226: COMMIT;
2227: EXCEPTION
2228: WHEN G_INVALID_PARAMETERS THEN

Line 2233: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, FND_MESSAGE.GET );

2229: errbuf := 'G_INVALID_PARAMETERS';
2230: retcode := 1;
2231: FND_MESSAGE.SET_NAME('IEX', 'IEX_MISSING_EMAIL_CASE');
2232: --dbms_output.put_line(FND_MESSAGE.GET);
2233: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, FND_MESSAGE.GET );
2234: ROLLBACK;
2235: l_return_status := OKC_API.G_RET_STS_ERROR;
2236: WHEN OTHERS THEN
2237: IF l_notify_csr%ISOPEN THEN

Line 2242: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);

2238: CLOSE l_notify_csr;
2239: END IF;
2240: errbuf := substr(SQLERRM, 1, 200);
2241: retcode := 1;
2242: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);
2243: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);
2244: ROLLBACK;
2245: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2246: END notify_customer;

Line 2243: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);

2239: END IF;
2240: errbuf := substr(SQLERRM, 1, 200);
2241: retcode := 1;
2242: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);
2243: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);
2244: ROLLBACK;
2245: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2246: END notify_customer;
2247:

Line 2535: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CONTRACTS NOTIFIED ABOUT RECALL = ' || l_ext_agncy_contracts_notified);

2531: */
2532: END LOOP;
2533:
2534: --dbms_output.PUT_LINE('CONTRACTS NOTIFIED ABOUT RECALL = ' || l_ext_agncy_contracts_notified);
2535: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CONTRACTS NOTIFIED ABOUT RECALL = ' || l_ext_agncy_contracts_notified);
2536:
2537: COMMIT;
2538: EXCEPTION
2539: WHEN OTHERS THEN

Line 2545: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);

2541: CLOSE l_recall_csr;
2542: END IF;
2543: errbuf := substr(SQLERRM, 1, 200);
2544: retcode := 1;
2545: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);
2546: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);
2547: ROLLBACK;
2548: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2549: END notify_recall_external_agency;

Line 2546: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);

2542: END IF;
2543: errbuf := substr(SQLERRM, 1, 200);
2544: retcode := 1;
2545: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);
2546: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);
2547: ROLLBACK;
2548: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2549: END notify_recall_external_agency;
2550:

Line 2763: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, FND_MESSAGE.GET );

2759:
2760: l_rows_processed := l_rows_processed + 1;
2761: ELSE
2762: FND_MESSAGE.SET_NAME('IEX', 'IEX_INVALID_FULFILLMENT_SETUP');
2763: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, FND_MESSAGE.GET );
2764: l_rows_failed := l_rows_failed + 1;
2765: END IF;
2766: ELSE
2767: l_ext_agncy_not_notified := l_ext_agncy_not_notified + 1;

Line 2776: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS NOTIFIED = ' || l_ext_agncy_notified);

2772: --dbms_output.PUT_LINE('EXT AGNCYS NOTIFIED = ' || l_ext_agncy_notified);
2773: --dbms_output.PUT_LINE('EXT AGNCYS NOT NOTIFIED = ' || l_ext_agncy_not_notified);
2774: --dbms_output.PUT_LINE('EXT AGNCYS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
2775: --dbms_output.PUT_LINE('EXT AGNCYS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2776: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS NOTIFIED = ' || l_ext_agncy_notified);
2777: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS NOT NOTIFIED = ' || l_ext_agncy_not_notified);
2778: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
2779: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2780:

Line 2777: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS NOT NOTIFIED = ' || l_ext_agncy_not_notified);

2773: --dbms_output.PUT_LINE('EXT AGNCYS NOT NOTIFIED = ' || l_ext_agncy_not_notified);
2774: --dbms_output.PUT_LINE('EXT AGNCYS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
2775: --dbms_output.PUT_LINE('EXT AGNCYS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2776: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS NOTIFIED = ' || l_ext_agncy_notified);
2777: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS NOT NOTIFIED = ' || l_ext_agncy_not_notified);
2778: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
2779: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2780:
2781: COMMIT;

Line 2778: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);

2774: --dbms_output.PUT_LINE('EXT AGNCYS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
2775: --dbms_output.PUT_LINE('EXT AGNCYS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2776: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS NOTIFIED = ' || l_ext_agncy_notified);
2777: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS NOT NOTIFIED = ' || l_ext_agncy_not_notified);
2778: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
2779: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2780:
2781: COMMIT;
2782: EXCEPTION

Line 2779: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);

2775: --dbms_output.PUT_LINE('EXT AGNCYS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2776: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS NOTIFIED = ' || l_ext_agncy_notified);
2777: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS NOT NOTIFIED = ' || l_ext_agncy_not_notified);
2778: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS TO BE NOTIFIED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
2779: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'EXT AGNCYS TO BE NOTIFIED NOT PROCESSED = ' || l_rows_failed);
2780:
2781: COMMIT;
2782: EXCEPTION
2783: WHEN OTHERS THEN

Line 2789: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);

2785: CLOSE l_notify_csr;
2786: END IF;
2787: errbuf := substr(SQLERRM, 1, 200);
2788: retcode := 1;
2789: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);
2790: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);
2791: ROLLBACK;
2792: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2793: END notify_external_agency;

Line 2790: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);

2786: END IF;
2787: errbuf := substr(SQLERRM, 1, 200);
2788: retcode := 1;
2789: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);
2790: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);
2791: ROLLBACK;
2792: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2793: END notify_external_agency;
2794:

Line 2903: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CONTRACTS RECALLED SUCCESSFULLY = ' || l_contracts_recalled);

2899: l_contracts_recalled := l_contracts_recalled + 1;
2900: END IF;
2901: END LOOP;
2902:
2903: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CONTRACTS RECALLED SUCCESSFULLY = ' || l_contracts_recalled);
2904: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CONTRACTS FAILED RECALL = ' || l_rows_failed);
2905: COMMIT;
2906: EXCEPTION
2907: WHEN OTHERS THEN

Line 2904: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CONTRACTS FAILED RECALL = ' || l_rows_failed);

2900: END IF;
2901: END LOOP;
2902:
2903: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CONTRACTS RECALLED SUCCESSFULLY = ' || l_contracts_recalled);
2904: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CONTRACTS FAILED RECALL = ' || l_rows_failed);
2905: COMMIT;
2906: EXCEPTION
2907: WHEN OTHERS THEN
2908: IF l_recall_csr%ISOPEN THEN

Line 2913: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);

2909: CLOSE l_recall_csr;
2910: END IF;
2911: errbuf := substr(SQLERRM, 1, 200);
2912: retcode := 1;
2913: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);
2914: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);
2915: ROLLBACK;
2916: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2917: END recall_from_external_agency;

Line 2914: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);

2910: END IF;
2911: errbuf := substr(SQLERRM, 1, 200);
2912: retcode := 1;
2913: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);
2914: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);
2915: ROLLBACK;
2916: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2917: END recall_from_external_agency;
2918: ---------------------------------------------------------------------------