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

Line 905: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : '||FND_MESSAGE.get);

901:
902: IF p_resale_batch_id is null THEN
903: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_ID_NULL');
904: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_BATCH_ID_NULL');
905: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : '||FND_MESSAGE.get);
906: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
907: GOTO PROC_RESALE_END;
908: END IF;
909:

Line 914: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Number : '||l_batch_number);

910: OPEN csr_batch_number(p_resale_batch_id);
911: FETCH csr_batch_number INTO l_batch_number;
912: CLOSE csr_batch_number;
913:
914: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Number : '||l_batch_number);
915: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
916:
917: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);
918: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr into l_batch_type;

Line 915: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');

911: FETCH csr_batch_number INTO l_batch_number;
912: CLOSE csr_batch_number;
913:
914: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Number : '||l_batch_number);
915: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
916:
917: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);
918: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr into l_batch_type;
919: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;

Line 924: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : '||FND_MESSAGE.get);

920:
921: IF l_batch_type is null THEN
922: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_TYPE_NULL');
923: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_BATCH_TYPE_NULL');
924: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : '||FND_MESSAGE.get);
925: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: GOTO PROC_RESALE_END;
927: END IF;
928:

Line 1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : '||FND_MESSAGE.get);

1104: l_end_date IS NOT NULL AND
1105: l_start_date > l_end_date THEN
1106: ozf_utility_pvt.error_message('OZF_RESALE_WNG_DATE_RANGE');
1107: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_WNG_DATE_RANGE');
1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : '||FND_MESSAGE.get);
1109: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1110: GOTO PROC_RESALE_2_END;
1111: END IF;
1112: -- Bug 4518607 (-)

Line 1178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No batches found to be process.');

1174: ELSE
1175: IF OZF_DEBUG_LOW_ON THEN
1176: OZF_UTILITY_PVT.debug_message('No batch is specified.');
1177: END IF;
1178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No batches found to be process.');
1179: END IF;
1180:
1181:
1182: <>

Line 1270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '======================================================================================================');

1266: RETCODE := 0;
1267:
1268: l_run_mode := NVL(p_run_mode, 'FINAL'); -- Bug 14194884 - TPA In Draft Mode ER
1269:
1270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');

Line 1271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

1267:
1268: l_run_mode := NVL(p_run_mode, 'FINAL'); -- Bug 14194884 - TPA In Draft Mode ER
1269:
1270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));

Line 1272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------------------------------------------------------------------------------');

1268: l_run_mode := NVL(p_run_mode, 'FINAL'); -- Bug 14194884 - TPA In Draft Mode ER
1269:
1270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);

Line 1273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

1269:
1270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);

Line 1274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');

1270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);
1278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));

Line 1275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));

1271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);
1278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));
1279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Run Mode : '||l_run_mode);

Line 1276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);

1272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);
1278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));
1279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Run Mode : '||l_run_mode);
1280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');

Line 1277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);

1273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);
1278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));
1279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Run Mode : '||l_run_mode);
1280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');

Line 1278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));

1274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);
1278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));
1279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Run Mode : '||l_run_mode);
1280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1282: -- Debug Message

Line 1279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Run Mode : '||l_run_mode);

1275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);
1278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));
1279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Run Mode : '||l_run_mode);
1280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1282: -- Debug Message
1283: IF OZF_DEBUG_LOW_ON THEN

Line 1280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------------------------------------------------------------------------------');

1276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);
1278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));
1279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Run Mode : '||l_run_mode);
1280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1282: -- Debug Message
1283: IF OZF_DEBUG_LOW_ON THEN
1284: ozf_utility_PVT.debug_message(l_full_name||': start');

Line 1281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');

1277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);
1278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));
1279: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Run Mode : '||l_run_mode);
1280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1282: -- Debug Message
1283: IF OZF_DEBUG_LOW_ON THEN
1284: ozf_utility_PVT.debug_message(l_full_name||': start');
1285: END IF;

Line 1412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------------------------------------------------------------------------------');

1408: IF OZF_DEBUG_HIGH_ON THEN
1409: OZF_UTILITY_PVT.debug_message(l_full_name||': end');
1410: END IF;
1411:
1412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1414: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1415:
1416: -- Write all messages to a log

Line 1413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

1409: OZF_UTILITY_PVT.debug_message(l_full_name||': end');
1410: END IF;
1411:
1412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1414: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1415:
1416: -- Write all messages to a log
1417: OZF_UTILITY_PVT.Write_Conc_Log;

Line 1414: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '======================================================================================================');

1410: END IF;
1411:
1412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1414: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1415:
1416: -- Write all messages to a log
1417: OZF_UTILITY_PVT.Write_Conc_Log;
1418: EXCEPTION

Line 1656: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- Start to purge processed order ---/');

1652: IF OZF_DEBUG_HIGH_ON THEN
1653: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
1654: END IF;
1655:
1656: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Start to purge processed order ---*/');
1657:
1658: Purge (
1659: p_api_version => 1.0
1660: ,p_init_msg_list => FND_API.G_FALSE

Line 1677: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- End of purge processed order ---/');

1673: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1674: RAISE FND_API.g_exc_unexpected_error;
1675: END IF;
1676:
1677: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End of purge processed order ---*/');
1678:
1679: -- Debug Message
1680: IF OZF_DEBUG_HIGH_ON THEN
1681: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

Line 1689: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- Error happened during purge ---/');

1685: OZF_UTILITY_PVT.Write_Conc_Log;
1686: EXCEPTION
1687: WHEN FND_API.g_exc_error THEN
1688: ROLLBACK TO Start_RESALE_Purge;
1689: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');
1690: OZF_UTILITY_PVT.Write_Conc_Log;
1691: ERRBUF := l_msg_data;
1692: RETCODE := 1;
1693:

Line 1696: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- Error happened during purge ---/');

1692: RETCODE := 1;
1693:
1694: WHEN FND_API.g_exc_unexpected_error THEN
1695: ROLLBACK TO Start_RESALE_Purge;
1696: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');
1697: OZF_UTILITY_PVT.Write_Conc_Log;
1698: ERRBUF := l_msg_data;
1699: RETCODE := 2;
1700:

Line 1703: FND_FILE.PUT_LINE(FND_FILE.LOG, '/--- Error happened during purge ---/');

1699: RETCODE := 2;
1700:
1701: WHEN OTHERS THEN
1702: ROLLBACK TO Start_RESALE_Purge;
1703: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');
1704: OZF_UTILITY_PVT.Write_Conc_Log;
1705: ERRBUF := l_msg_data;
1706: RETCODE := 2;
1707: