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.EGO_BOM_BULKLOAD_PVT_PKG dependencies on ERROR_HANDLER

Line 54: Error_Handler.Open_Debug_Session(

50: END IF;
51:
52: G_ERROR_FILE_NAME := G_ERROR_TABLE_NAME||'_'||TO_CHAR(SYSDATE, 'DDMONYYYY_HH24MISS')||'.err';
53:
54: Error_Handler.Open_Debug_Session(
55: p_debug_filename => G_ERROR_FILE_NAME
56: ,p_output_dir => l_log_output_dir
57: ,x_return_status => l_log_return_status
58: ,x_error_mesg => l_errbuff

Line 205: --Error_Handler.Write_Debug('EBI: Updated the Process_Status to Indicate Succssful/Unsucessful completion.');

201:
202: -- Commiting after the process flag is updated.
203: COMMIT;
204:
205: --Error_Handler.Write_Debug('EBI: Updated the Process_Status to Indicate Succssful/Unsucessful completion.');
206: x_retcode := G_STATUS_SUCCESS;
207:
208: EXCEPTION
209: WHEN OTHERS THEN

Line 407: Error_Handler.initialize();

403: G_LANGUAGE_CODE := p_Language_Code;
404:
405:
406:
407: Error_Handler.initialize();
408: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);
409: --Log errors into file
410: --Error_Handler.Set_Debug('Y');
411: --Opens Error_Handler debug session

Line 408: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);

404:
405:
406:
407: Error_Handler.initialize();
408: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);
409: --Log errors into file
410: --Error_Handler.Set_Debug('Y');
411: --Opens Error_Handler debug session
412: --Open_Debug_Session;

Line 410: --Error_Handler.Set_Debug('Y');

406:
407: Error_Handler.initialize();
408: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);
409: --Log errors into file
410: --Error_Handler.Set_Debug('Y');
411: --Opens Error_Handler debug session
412: --Open_Debug_Session;
413:
414: --After Open_Debug_Session, can log using Error_Handler.Write_Debug()

Line 411: --Opens Error_Handler debug session

407: Error_Handler.initialize();
408: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);
409: --Log errors into file
410: --Error_Handler.Set_Debug('Y');
411: --Opens Error_Handler debug session
412: --Open_Debug_Session;
413:
414: --After Open_Debug_Session, can log using Error_Handler.Write_Debug()
415: --Replace this with FND_FILE.put_line() if needed.

Line 414: --After Open_Debug_Session, can log using Error_Handler.Write_Debug()

410: --Error_Handler.Set_Debug('Y');
411: --Opens Error_Handler debug session
412: --Open_Debug_Session;
413:
414: --After Open_Debug_Session, can log using Error_Handler.Write_Debug()
415: --Replace this with FND_FILE.put_line() if needed.
416: --Error_Handler.Write_Debug('G_USER_ID : '||TO_CHAR(G_USER_ID));
417: --Error_Handler.Write_Debug('G_PROG_ID : '||TO_CHAR(G_PROG_ID));
418: --Error_Handler.Write_Debug('G_REQUEST_ID : '||TO_CHAR(G_REQUEST_ID));

Line 416: --Error_Handler.Write_Debug('G_USER_ID : '||TO_CHAR(G_USER_ID));

412: --Open_Debug_Session;
413:
414: --After Open_Debug_Session, can log using Error_Handler.Write_Debug()
415: --Replace this with FND_FILE.put_line() if needed.
416: --Error_Handler.Write_Debug('G_USER_ID : '||TO_CHAR(G_USER_ID));
417: --Error_Handler.Write_Debug('G_PROG_ID : '||TO_CHAR(G_PROG_ID));
418: --Error_Handler.Write_Debug('G_REQUEST_ID : '||TO_CHAR(G_REQUEST_ID));
419: --Error_Handler.Write_Debug('P_RESULT_FMT_USAGE_ID : '||TO_CHAR(p_Resultfmt_Usage_Id));
420:

Line 417: --Error_Handler.Write_Debug('G_PROG_ID : '||TO_CHAR(G_PROG_ID));

413:
414: --After Open_Debug_Session, can log using Error_Handler.Write_Debug()
415: --Replace this with FND_FILE.put_line() if needed.
416: --Error_Handler.Write_Debug('G_USER_ID : '||TO_CHAR(G_USER_ID));
417: --Error_Handler.Write_Debug('G_PROG_ID : '||TO_CHAR(G_PROG_ID));
418: --Error_Handler.Write_Debug('G_REQUEST_ID : '||TO_CHAR(G_REQUEST_ID));
419: --Error_Handler.Write_Debug('P_RESULT_FMT_USAGE_ID : '||TO_CHAR(p_Resultfmt_Usage_Id));
420:
421:

Line 418: --Error_Handler.Write_Debug('G_REQUEST_ID : '||TO_CHAR(G_REQUEST_ID));

414: --After Open_Debug_Session, can log using Error_Handler.Write_Debug()
415: --Replace this with FND_FILE.put_line() if needed.
416: --Error_Handler.Write_Debug('G_USER_ID : '||TO_CHAR(G_USER_ID));
417: --Error_Handler.Write_Debug('G_PROG_ID : '||TO_CHAR(G_PROG_ID));
418: --Error_Handler.Write_Debug('G_REQUEST_ID : '||TO_CHAR(G_REQUEST_ID));
419: --Error_Handler.Write_Debug('P_RESULT_FMT_USAGE_ID : '||TO_CHAR(p_Resultfmt_Usage_Id));
420:
421:
422: -- Delete all the earlier uploads from the same spreadsheet.

Line 419: --Error_Handler.Write_Debug('P_RESULT_FMT_USAGE_ID : '||TO_CHAR(p_Resultfmt_Usage_Id));

415: --Replace this with FND_FILE.put_line() if needed.
416: --Error_Handler.Write_Debug('G_USER_ID : '||TO_CHAR(G_USER_ID));
417: --Error_Handler.Write_Debug('G_PROG_ID : '||TO_CHAR(G_PROG_ID));
418: --Error_Handler.Write_Debug('G_REQUEST_ID : '||TO_CHAR(G_REQUEST_ID));
419: --Error_Handler.Write_Debug('P_RESULT_FMT_USAGE_ID : '||TO_CHAR(p_Resultfmt_Usage_Id));
420:
421:
422: -- Delete all the earlier uploads from the same spreadsheet.
423: /*

Line 429: --Error_Handler.Write_Debug('About to populate the EBI with Trans IDs');

425: WHERE RESULTFMT_USAGE_ID = p_resultfmt_usage_id
426: AND PROCESS_STATUS <> 1;
427: */
428:
429: --Error_Handler.Write_Debug('About to populate the EBI with Trans IDs');
430: --Populate the Transaction IDs for current result fmt usage ID
431: --New Transaction ID. It will be replaced by old Transaction ID Seq.
432: --SET transaction_id = MSII_TRANSACTION_ID_S.NEXTVAL
433: UPDATE EGO_BULKLOAD_INTF

Line 790: --Error_Handler.Write_Debug('Structure Import : UPDATE : l_err_text = ' || l_err_text);

786: IF l_debug = 'Y' THEN
787: FND_FILE.PUT_LINE( FND_FILE.LOG,'Done Processing');
788: END IF;
789:
790: --Error_Handler.Write_Debug('Structure Import : UPDATE : l_err_text = ' || l_err_text);
791:
792: -- Call completion procedure
793: Structure_Intf_Proc_Complete
794: (

Line 804: --Error_Handler.Write_Debug('Updated the Process Status to Indicate Successful/Unsucessful component/structure Import Completion');

800: IF l_debug = 'Y' THEN
801: FND_FILE.PUT_LINE( FND_FILE.LOG,'Completed Processing');
802: END IF;
803:
804: --Error_Handler.Write_Debug('Updated the Process Status to Indicate Successful/Unsucessful component/structure Import Completion');
805:
806: EXCEPTION
807: WHEN OTHERS THEN
808: l_err_text := SQLERRM;

Line 809: --Error_Handler.Write_Debug('WHEN OTHERS Exception.');

805:
806: EXCEPTION
807: WHEN OTHERS THEN
808: l_err_text := SQLERRM;
809: --Error_Handler.Write_Debug('WHEN OTHERS Exception.');
810: --Error_Handler.Write_Debug('error code : '|| TO_CHAR(SQLCODE));
811: --Error_Handler.Write_Debug('error text : '|| SQLERRM);
812: x_errbuff := 'Error : '||TO_CHAR(SQLCODE)||'---'||SQLERRM;
813: x_retcode := Error_Handler.G_STATUS_ERROR;

Line 810: --Error_Handler.Write_Debug('error code : '|| TO_CHAR(SQLCODE));

806: EXCEPTION
807: WHEN OTHERS THEN
808: l_err_text := SQLERRM;
809: --Error_Handler.Write_Debug('WHEN OTHERS Exception.');
810: --Error_Handler.Write_Debug('error code : '|| TO_CHAR(SQLCODE));
811: --Error_Handler.Write_Debug('error text : '|| SQLERRM);
812: x_errbuff := 'Error : '||TO_CHAR(SQLCODE)||'---'||SQLERRM;
813: x_retcode := Error_Handler.G_STATUS_ERROR;
814: IF l_debug = 'Y' THEN

Line 811: --Error_Handler.Write_Debug('error text : '|| SQLERRM);

807: WHEN OTHERS THEN
808: l_err_text := SQLERRM;
809: --Error_Handler.Write_Debug('WHEN OTHERS Exception.');
810: --Error_Handler.Write_Debug('error code : '|| TO_CHAR(SQLCODE));
811: --Error_Handler.Write_Debug('error text : '|| SQLERRM);
812: x_errbuff := 'Error : '||TO_CHAR(SQLCODE)||'---'||SQLERRM;
813: x_retcode := Error_Handler.G_STATUS_ERROR;
814: IF l_debug = 'Y' THEN
815: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Message ' || x_errbuff);

Line 813: x_retcode := Error_Handler.G_STATUS_ERROR;

809: --Error_Handler.Write_Debug('WHEN OTHERS Exception.');
810: --Error_Handler.Write_Debug('error code : '|| TO_CHAR(SQLCODE));
811: --Error_Handler.Write_Debug('error text : '|| SQLERRM);
812: x_errbuff := 'Error : '||TO_CHAR(SQLCODE)||'---'||SQLERRM;
813: x_retcode := Error_Handler.G_STATUS_ERROR;
814: IF l_debug = 'Y' THEN
815: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Message ' || x_errbuff);
816: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Code' || x_retcode);
817: END IF;

Line 818: Error_Handler.Close_Debug_Session;

814: IF l_debug = 'Y' THEN
815: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Message ' || x_errbuff);
816: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Code' || x_retcode);
817: END IF;
818: Error_Handler.Close_Debug_Session;
819:
820: END PROCESS_BOM_INTERFACE_LINES;
821:
822: END EGO_BOM_BULKLOAD_PVT_PKG;