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

Line 93: -- Write Debug statements to Log using Error Handler procedure --

89: RETURN l_rows_exists;
90: end;
91:
92: -----------------------------------------------------------------
93: -- Write Debug statements to Log using Error Handler procedure --
94: -----------------------------------------------------------------
95: PROCEDURE Write_Debug (p_msg IN VARCHAR2) IS
96: l_debug VARCHAR2(10);
97: BEGIN

Line 100: -- NOTE: No need to check for profile now, as Error_Handler checks

96: l_debug VARCHAR2(10);
97: BEGIN
98: l_debug := fnd_profile.value('MRP_DEBUG');
99:
100: -- NOTE: No need to check for profile now, as Error_Handler checks
101: -- for Error_Handler.Get_Debug = 'Y' before writing to Debug Log.
102: IF l_debug = 'Y' THEN
103: FND_FILE.PUT_LINE( FND_FILE.LOG, '['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);
104: END IF;

Line 101: -- for Error_Handler.Get_Debug = 'Y' before writing to Debug Log.

97: BEGIN
98: l_debug := fnd_profile.value('MRP_DEBUG');
99:
100: -- NOTE: No need to check for profile now, as Error_Handler checks
101: -- for Error_Handler.Get_Debug = 'Y' before writing to Debug Log.
102: IF l_debug = 'Y' THEN
103: FND_FILE.PUT_LINE( FND_FILE.LOG, '['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);
104: END IF;
105: END;

Line 145: Error_Handler.Open_Debug_Session(

141: IF G_HAS_UTL_FILE_DIR = 'Y'
142: THEN
143: G_ERROR_FILE_NAME := G_ERROR_TABLE_NAME||'_'||TO_CHAR(SYSDATE, 'DDMONYYYY_HH24MISS')||'.err';
144:
145: Error_Handler.Open_Debug_Session(
146: p_debug_filename => G_ERROR_FILE_NAME
147: ,p_output_dir => l_log_output_dir
148: ,x_return_status => l_log_return_status
149: ,x_error_mesg => l_errbuff

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

292:
293: -- Commiting after the process flag is updated.
294: COMMIT;
295:
296: --Error_Handler.Write_Debug('EBI: Updated the Process_Status to Indicate Succssful/Unsucessful completion.');
297: x_retcode := G_STATUS_SUCCESS;
298:
299: EXCEPTION
300: WHEN OTHERS THEN

Line 650: -- Error Handler variables

646: l_is_preferred VARCHAR2(240);
647: l_assemblytype NUMBER;
648: l_str_type_id NUMBER;
649:
650: -- Error Handler variables
651: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
652: l_Token_Tbl Error_Handler.Token_Tbl_Type;
653:
654: -- Constant Values

Line 651: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

647: l_assemblytype NUMBER;
648: l_str_type_id NUMBER;
649:
650: -- Error Handler variables
651: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
652: l_Token_Tbl Error_Handler.Token_Tbl_Type;
653:
654: -- Constant Values
655: G_DEL_GROUP_NAME VARCHAR2(10) := 'B_BLK_INTF';

Line 652: l_Token_Tbl Error_Handler.Token_Tbl_Type;

648: l_str_type_id NUMBER;
649:
650: -- Error Handler variables
651: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
652: l_Token_Tbl Error_Handler.Token_Tbl_Type;
653:
654: -- Constant Values
655: G_DEL_GROUP_NAME VARCHAR2(10) := 'B_BLK_INTF';
656: G_DEL_GROUP_DESC VARCHAR2(240) := 'Delete Group for EGO BOM Bulkload Structures';

Line 770: Error_Handler.initialize();

766: l_dis_date_col_name := null;
767: l_item_seq_col_name := null;
768: l_imp_date_col_name := null;
769:
770: Error_Handler.initialize();
771: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);
772: -- Delete all the earlier uploads from the same spreadsheet.
773: /*
774: DELETE FROM EGO_BULKLOAD_INTF

Line 771: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);

767: l_item_seq_col_name := null;
768: l_imp_date_col_name := null;
769:
770: Error_Handler.initialize();
771: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);
772: -- Delete all the earlier uploads from the same spreadsheet.
773: /*
774: DELETE FROM EGO_BULKLOAD_INTF
775: WHERE RESULTFMT_USAGE_ID = p_resultfmt_usage_id

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

1845: IF l_debug = 'Y' THEN
1846: FND_FILE.PUT_LINE( FND_FILE.LOG,'Done Processing');
1847: END IF;
1848:
1849: --Error_Handler.Write_Debug('Structure Import : UPDATE : l_err_text = ' || l_err_text);
1850:
1851: -- Call completion procedure
1852: /* Structure_Intf_Proc_Complete
1853: (

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

1859: IF l_debug = 'Y' THEN
1860: FND_FILE.PUT_LINE( FND_FILE.LOG,'Completed Processing');
1861: END IF;
1862:
1863: --Error_Handler.Write_Debug('Updated the Process Status to Indicate Successful/Unsucessful component/structure Import Completion');
1864:
1865: EXCEPTION
1866: WHEN OTHERS THEN
1867: l_err_text := SQLERRM;

Line 1869: x_retcode := Error_Handler.G_STATUS_ERROR;

1865: EXCEPTION
1866: WHEN OTHERS THEN
1867: l_err_text := SQLERRM;
1868: x_errbuff := 'Error : '||TO_CHAR(SQLCODE)||'---'||SQLERRM;
1869: x_retcode := Error_Handler.G_STATUS_ERROR;
1870: IF l_debug = 'Y' THEN
1871: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Message ' || x_errbuff);
1872: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Code' || x_retcode);
1873: END IF;

Line 1874: Error_Handler.Close_Debug_Session;

1870: IF l_debug = 'Y' THEN
1871: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Message ' || x_errbuff);
1872: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Code' || x_retcode);
1873: END IF;
1874: Error_Handler.Close_Debug_Session;
1875:
1876: END PROCESS_BOM_INTERFACE_LINES;
1877:
1878: FUNCTION displayDT_to_date(charDT VARCHAR2,

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

1980: AND NVL(alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR);
1981: END IF;
1982: END IF;
1983:
1984: --Error_Handler.Write_Debug('EBI: Updated the Process_Status to Indicate Succssful/Unsucessful completion.');
1985: x_retcode := G_STATUS_SUCCESS;
1986:
1987: EXCEPTION
1988: WHEN NO_DATA_FOUND THEN

Line 2154: -- Token tables to log errors, through Error_Handler

2150: ---------------------------------------------------------
2151: L_ATTR_GRP_ROW_IDENT NUMBER(5);
2152:
2153: ---------------------------------------------------------
2154: -- Token tables to log errors, through Error_Handler
2155: ---------------------------------------------------------
2156: l_token_tbl_two Error_Handler.Token_Tbl_Type;
2157: l_token_tbl_one Error_Handler.Token_Tbl_Type;
2158:

Line 2156: l_token_tbl_two Error_Handler.Token_Tbl_Type;

2152:
2153: ---------------------------------------------------------
2154: -- Token tables to log errors, through Error_Handler
2155: ---------------------------------------------------------
2156: l_token_tbl_two Error_Handler.Token_Tbl_Type;
2157: l_token_tbl_one Error_Handler.Token_Tbl_Type;
2158:
2159: l_comp_usr_attr_flag NUMBER(10) := 0;
2160:

Line 2157: l_token_tbl_one Error_Handler.Token_Tbl_Type;

2153: ---------------------------------------------------------
2154: -- Token tables to log errors, through Error_Handler
2155: ---------------------------------------------------------
2156: l_token_tbl_two Error_Handler.Token_Tbl_Type;
2157: l_token_tbl_one Error_Handler.Token_Tbl_Type;
2158:
2159: l_comp_usr_attr_flag NUMBER(10) := 0;
2160:
2161: BEGIN

Line 2504: Error_Handler.Add_Error_Message

2500: IF ( LENGTH(l_usr_attr_data_tbl(i).ATTR_VALUE_STR) > 1000 ) THEN
2501: l_token_tbl_one(1).token_name := 'VALUE';
2502: l_token_tbl_one(1).token_value := l_usr_attr_data_tbl(i).ATTR_VALUE_STR;
2503:
2504: Error_Handler.Add_Error_Message
2505: ( p_message_name => 'EGO_STR_ATTR_LEN_GT1000_ERR'
2506: , p_application_id => 'EGO'
2507: , p_message_text => NULL
2508: , p_token_tbl => l_token_tbl_one