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.

[Home] [Help]

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 133: Error_Handler.Open_Debug_Session(

129: END IF;
130:
131: G_ERROR_FILE_NAME := G_ERROR_TABLE_NAME||'_'||TO_CHAR(SYSDATE, 'DDMONYYYY_HH24MISS')||'.err';
132:
133: Error_Handler.Open_Debug_Session(
134: p_debug_filename => G_ERROR_FILE_NAME
135: ,p_output_dir => l_log_output_dir
136: ,x_return_status => l_log_return_status
137: ,x_error_mesg => l_errbuff

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

280:
281: -- Commiting after the process flag is updated.
282: COMMIT;
283:
284: --Error_Handler.Write_Debug('EBI: Updated the Process_Status to Indicate Succssful/Unsucessful completion.');
285: x_retcode := G_STATUS_SUCCESS;
286:
287: EXCEPTION
288: WHEN OTHERS THEN

Line 636: -- Error Handler variables

632: l_is_preferred VARCHAR2(240);
633: l_assemblytype NUMBER;
634: l_str_type_id NUMBER;
635:
636: -- Error Handler variables
637: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
638: l_Token_Tbl Error_Handler.Token_Tbl_Type;
639:
640: -- Constant Values

Line 637: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

633: l_assemblytype NUMBER;
634: l_str_type_id NUMBER;
635:
636: -- Error Handler variables
637: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
638: l_Token_Tbl Error_Handler.Token_Tbl_Type;
639:
640: -- Constant Values
641: G_DEL_GROUP_NAME VARCHAR2(10) := 'B_BLK_INTF';

Line 638: l_Token_Tbl Error_Handler.Token_Tbl_Type;

634: l_str_type_id NUMBER;
635:
636: -- Error Handler variables
637: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
638: l_Token_Tbl Error_Handler.Token_Tbl_Type;
639:
640: -- Constant Values
641: G_DEL_GROUP_NAME VARCHAR2(10) := 'B_BLK_INTF';
642: G_DEL_GROUP_DESC VARCHAR2(240) := 'Delete Group for EGO BOM Bulkload Structures';

Line 756: Error_Handler.initialize();

752: l_dis_date_col_name := null;
753: l_item_seq_col_name := null;
754:
755:
756: Error_Handler.initialize();
757: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);
758: -- Delete all the earlier uploads from the same spreadsheet.
759: /*
760: DELETE FROM EGO_BULKLOAD_INTF

Line 757: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);

753: l_item_seq_col_name := null;
754:
755:
756: Error_Handler.initialize();
757: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);
758: -- Delete all the earlier uploads from the same spreadsheet.
759: /*
760: DELETE FROM EGO_BULKLOAD_INTF
761: WHERE RESULTFMT_USAGE_ID = p_resultfmt_usage_id

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

1788: IF l_debug = 'Y' THEN
1789: FND_FILE.PUT_LINE( FND_FILE.LOG,'Done Processing');
1790: END IF;
1791:
1792: --Error_Handler.Write_Debug('Structure Import : UPDATE : l_err_text = ' || l_err_text);
1793:
1794: -- Call completion procedure
1795: /* Structure_Intf_Proc_Complete
1796: (

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

1802: IF l_debug = 'Y' THEN
1803: FND_FILE.PUT_LINE( FND_FILE.LOG,'Completed Processing');
1804: END IF;
1805:
1806: --Error_Handler.Write_Debug('Updated the Process Status to Indicate Successful/Unsucessful component/structure Import Completion');
1807:
1808: EXCEPTION
1809: WHEN OTHERS THEN
1810: l_err_text := SQLERRM;

Line 1812: x_retcode := Error_Handler.G_STATUS_ERROR;

1808: EXCEPTION
1809: WHEN OTHERS THEN
1810: l_err_text := SQLERRM;
1811: x_errbuff := 'Error : '||TO_CHAR(SQLCODE)||'---'||SQLERRM;
1812: x_retcode := Error_Handler.G_STATUS_ERROR;
1813: IF l_debug = 'Y' THEN
1814: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Message ' || x_errbuff);
1815: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Code' || x_retcode);
1816: END IF;

Line 1817: Error_Handler.Close_Debug_Session;

1813: IF l_debug = 'Y' THEN
1814: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Message ' || x_errbuff);
1815: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering Exception Code' || x_retcode);
1816: END IF;
1817: Error_Handler.Close_Debug_Session;
1818:
1819: END PROCESS_BOM_INTERFACE_LINES;
1820:
1821:

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

1890: AND NVL(alternate_bom_designator , Fnd_Api.G_MISS_CHAR) = NVL(p_alternate_bom_designator, Fnd_Api.G_MISS_CHAR);
1891: END IF;
1892: END IF;
1893:
1894: --Error_Handler.Write_Debug('EBI: Updated the Process_Status to Indicate Succssful/Unsucessful completion.');
1895: x_retcode := G_STATUS_SUCCESS;
1896:
1897: EXCEPTION
1898: WHEN NO_DATA_FOUND THEN

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

2060: ---------------------------------------------------------
2061: L_ATTR_GRP_ROW_IDENT NUMBER(5);
2062:
2063: ---------------------------------------------------------
2064: -- Token tables to log errors, through Error_Handler
2065: ---------------------------------------------------------
2066: l_token_tbl_two Error_Handler.Token_Tbl_Type;
2067: l_token_tbl_one Error_Handler.Token_Tbl_Type;
2068:

Line 2066: l_token_tbl_two Error_Handler.Token_Tbl_Type;

2062:
2063: ---------------------------------------------------------
2064: -- Token tables to log errors, through Error_Handler
2065: ---------------------------------------------------------
2066: l_token_tbl_two Error_Handler.Token_Tbl_Type;
2067: l_token_tbl_one Error_Handler.Token_Tbl_Type;
2068:
2069: BEGIN
2070: write_debug(' SRIDHAR');

Line 2067: l_token_tbl_one Error_Handler.Token_Tbl_Type;

2063: ---------------------------------------------------------
2064: -- Token tables to log errors, through Error_Handler
2065: ---------------------------------------------------------
2066: l_token_tbl_two Error_Handler.Token_Tbl_Type;
2067: l_token_tbl_one Error_Handler.Token_Tbl_Type;
2068:
2069: BEGIN
2070: write_debug(' SRIDHAR');
2071: ---------------------------------------------------------

Line 2406: Error_Handler.Add_Error_Message

2402: IF ( LENGTH(l_usr_attr_data_tbl(i).ATTR_VALUE_STR) > 1000 ) THEN
2403: l_token_tbl_one(1).token_name := 'VALUE';
2404: l_token_tbl_one(1).token_value := l_usr_attr_data_tbl(i).ATTR_VALUE_STR;
2405:
2406: Error_Handler.Add_Error_Message
2407: ( p_message_name => 'EGO_STR_ATTR_LEN_GT1000_ERR'
2408: , p_application_id => 'EGO'
2409: , p_message_text => NULL
2410: , p_token_tbl => l_token_tbl_one