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 861: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : '||FND_MESSAGE.get);

857:
858: IF p_resale_batch_id is null THEN
859: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_ID_NULL');
860: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_BATCH_ID_NULL');
861: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : '||FND_MESSAGE.get);
862: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: GOTO PROC_RESALE_END;
864: END IF;
865:

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

866: OPEN csr_batch_number(p_resale_batch_id);
867: FETCH csr_batch_number INTO l_batch_number;
868: CLOSE csr_batch_number;
869:
870: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Number : '||l_batch_number);
871: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
872:
873: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);
874: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr into l_batch_type;

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

867: FETCH csr_batch_number INTO l_batch_number;
868: CLOSE csr_batch_number;
869:
870: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Number : '||l_batch_number);
871: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
872:
873: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);
874: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr into l_batch_type;
875: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;

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

876:
877: IF l_batch_type is null THEN
878: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_TYPE_NULL');
879: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_BATCH_TYPE_NULL');
880: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : '||FND_MESSAGE.get);
881: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
882: GOTO PROC_RESALE_END;
883: END IF;
884:

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

1059: l_end_date IS NOT NULL AND
1060: l_start_date > l_end_date THEN
1061: ozf_utility_pvt.error_message('OZF_RESALE_WNG_DATE_RANGE');
1062: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_WNG_DATE_RANGE');
1063: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : '||FND_MESSAGE.get);
1064: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1065: GOTO PROC_RESALE_2_END;
1066: END IF;
1067: -- Bug 4518607 (-)

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

1115: ELSE
1116: IF OZF_DEBUG_LOW_ON THEN
1117: OZF_UTILITY_PVT.debug_message('No batch is specified.');
1118: END IF;
1119: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No batches found to be process.');
1120: END IF;
1121:
1122:
1123: <>

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

1195:
1196: SAVEPOINT Start_PROC_RESALE;
1197: RETCODE := 0;
1198:
1199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');

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

1196: SAVEPOINT Start_PROC_RESALE;
1197: RETCODE := 0;
1198:
1199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1204: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));

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

1197: RETCODE := 0;
1198:
1199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1204: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);

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

1198:
1199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1204: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);

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

1199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1204: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);
1207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));

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

1200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1204: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);
1207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));
1208: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');

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

1201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1204: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);
1207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));
1208: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');

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

1202: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1204: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);
1207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));
1208: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1210: -- Debug Message

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

1203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1204: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);
1207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));
1208: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1210: -- Debug Message
1211: IF OZF_DEBUG_LOW_ON THEN

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

1204: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);
1207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));
1208: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1210: -- Debug Message
1211: IF OZF_DEBUG_LOW_ON THEN
1212: ozf_utility_PVT.debug_message(l_full_name||': start');

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

1205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);
1207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Cust Account Id : '||TO_CHAR(p_partner_cust_account_id));
1208: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1210: -- Debug Message
1211: IF OZF_DEBUG_LOW_ON THEN
1212: ozf_utility_PVT.debug_message(l_full_name||': start');
1213: END IF;

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

1256: IF OZF_DEBUG_HIGH_ON THEN
1257: OZF_UTILITY_PVT.debug_message(l_full_name||': end');
1258: END IF;
1259:
1260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1263:
1264: -- Write all messages to a log

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

1257: OZF_UTILITY_PVT.debug_message(l_full_name||': end');
1258: END IF;
1259:
1260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1263:
1264: -- Write all messages to a log
1265: OZF_UTILITY_PVT.Write_Conc_Log;

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

1258: END IF;
1259:
1260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1263:
1264: -- Write all messages to a log
1265: OZF_UTILITY_PVT.Write_Conc_Log;
1266: EXCEPTION

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

1500: IF OZF_DEBUG_HIGH_ON THEN
1501: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
1502: END IF;
1503:
1504: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Start to purge processed order ---*/');
1505:
1506: Purge (
1507: p_api_version => 1.0
1508: ,p_init_msg_list => FND_API.G_FALSE

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

1521: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1522: RAISE FND_API.g_exc_unexpected_error;
1523: END IF;
1524:
1525: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End of purge processed order ---*/');
1526:
1527: -- Debug Message
1528: IF OZF_DEBUG_HIGH_ON THEN
1529: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

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

1533: OZF_UTILITY_PVT.Write_Conc_Log;
1534: EXCEPTION
1535: WHEN FND_API.g_exc_error THEN
1536: ROLLBACK TO Start_RESALE_Purge;
1537: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');
1538: OZF_UTILITY_PVT.Write_Conc_Log;
1539: ERRBUF := l_msg_data;
1540: RETCODE := 1;
1541:

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

1540: RETCODE := 1;
1541:
1542: WHEN FND_API.g_exc_unexpected_error THEN
1543: ROLLBACK TO Start_RESALE_Purge;
1544: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');
1545: OZF_UTILITY_PVT.Write_Conc_Log;
1546: ERRBUF := l_msg_data;
1547: RETCODE := 2;
1548:

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

1547: RETCODE := 2;
1548:
1549: WHEN OTHERS THEN
1550: ROLLBACK TO Start_RESALE_Purge;
1551: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');
1552: OZF_UTILITY_PVT.Write_Conc_Log;
1553: ERRBUF := l_msg_data;
1554: RETCODE := 2;
1555: