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_ITEM_PEOPLE_IMPORT_PKG dependencies on ERROR_HANDLER

Line 79: -- Debug Profile option used to write Error_Handler.Write_Debug --

75: --He can make grants to the items etc.,
76: G_FULL_ACCESS_ITEMS BOOLEAN := FALSE;
77:
78: -----------------------------------------------------------------------
79: -- Debug Profile option used to write Error_Handler.Write_Debug --
80: -- Profile option name = INV_DEBUG_TRACE ; --
81: -- User Profile Option Name = INV: Debug Trace --
82: -- Values: 1 (True) ; 0 (False) --
83: -- NOTE: This better than MRP_DEBUG which is used at many places. --

Line 117: Generic Error Handler API that can be used for the same.

113: /*----------------------------------------------------------------------
114: -- TODO
115:
116: 1. Didnot do a bulk call for Error writing, as Rahul said he has the
117: Generic Error Handler API that can be used for the same.
118: So referred Item Category Assignment API for coding call to Generic
119: Error API.
120:
121: ----------------------------------------------------------------------*/

Line 278: -- Writing given string to Error Handler Log File --

274:
275: -- Bug 13599076 DBG End
276:
277: ----------------------------------------------------------
278: -- Writing given string to Error Handler Log File --
279: ----------------------------------------------------------
280:
281: PROCEDURE Write_Debug (p_message VARCHAR2) IS
282: -- Start OF comments

Line 311: -- If Error Handler Profile set to TRUE --

307: Conc_log ('['||To_Char(SYSDATE,'DD-MON-RRRR HH24:MI:SS')|| ' => '||p_message);
308: END IF;
309: -- sri_debug(p_message);
310: -------------------------------------------------
311: -- If Error Handler Profile set to TRUE --
312: -------------------------------------------------
313: IF (G_ERR_HANDLER_DEBUG = 1) THEN
314: Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_message);
315: END IF;

Line 314: Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_message);

310: -------------------------------------------------
311: -- If Error Handler Profile set to TRUE --
312: -------------------------------------------------
313: IF (G_ERR_HANDLER_DEBUG = 1) THEN
314: Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_message);
315: END IF;
316: EXCEPTION
317: WHEN OTHERS THEN
318: ROLLBACK;

Line 375: -- To flush the errors recorded in Error Handler into --

371: NULL;
372: END purge_login_items_table;
373:
374: ----------------------------------------------------------
375: -- To flush the errors recorded in Error Handler into --
376: -- appropriate destination --
377: ----------------------------------------------------------
378: PROCEDURE write_log_now IS
379: -- Start OF comments

Line 392: ERROR_HANDLER.Log_Error(p_write_err_to_inttable => 'Y'

388:
389: BEGIN
390: G_HAS_ERRORS := TRUE;
391: IF G_TABLE_LOG THEN
392: ERROR_HANDLER.Log_Error(p_write_err_to_inttable => 'Y'
393: ,p_write_err_to_conclog => 'Y'
394: ,p_write_err_to_debugfile => 'N');
395: ELSE
396: ERROR_HANDLER.Log_Error(p_write_err_to_inttable => 'N'

Line 396: ERROR_HANDLER.Log_Error(p_write_err_to_inttable => 'N'

392: ERROR_HANDLER.Log_Error(p_write_err_to_inttable => 'Y'
393: ,p_write_err_to_conclog => 'Y'
394: ,p_write_err_to_debugfile => 'N');
395: ELSE
396: ERROR_HANDLER.Log_Error(p_write_err_to_inttable => 'N'
397: ,p_write_err_to_conclog => 'Y'
398: ,p_write_err_to_debugfile => 'N');
399: END IF;
400: EXCEPTION

Line 428: IF Error_Handler.Get_Message_Count() > p_msg_size THEN

424: -- return status of the program
425: --
426:
427: BEGIN
428: IF Error_Handler.Get_Message_Count() > p_msg_size THEN
429: write_log_now();
430: error_Handler.Initialize();
431: END IF;
432: x_retcode := RETCODE_SUCCESS;

Line 430: error_Handler.Initialize();

426:
427: BEGIN
428: IF Error_Handler.Get_Message_Count() > p_msg_size THEN
429: write_log_now();
430: error_Handler.Initialize();
431: END IF;
432: x_retcode := RETCODE_SUCCESS;
433: EXCEPTION
434: WHEN OTHERS THEN

Line 953: l_token_tbl_two Error_Handler.Token_Tbl_Type;

949: )
950: AND start_date <= NVL(cp_end_date, start_date)
951: AND NVL(end_date,cp_start_date) >= cp_start_date;
952:
953: l_token_tbl_two Error_Handler.Token_Tbl_Type;
954: l_token_tbl_one Error_Handler.Token_Tbl_Type;
955: l_grant_guid fnd_grants.grant_guid%TYPE;
956: l_temp_grant_guid fnd_grants.grant_guid%TYPE;
957:

Line 954: l_token_tbl_one Error_Handler.Token_Tbl_Type;

950: AND start_date <= NVL(cp_end_date, start_date)
951: AND NVL(end_date,cp_start_date) >= cp_start_date;
952:
953: l_token_tbl_two Error_Handler.Token_Tbl_Type;
954: l_token_tbl_one Error_Handler.Token_Tbl_Type;
955: l_grant_guid fnd_grants.grant_guid%TYPE;
956: l_temp_grant_guid fnd_grants.grant_guid%TYPE;
957:
958: l_success VARCHAR2(999);

Line 1004: error_handler.Add_Error_Message

1000: l_token_tbl_two(1).token_name := 'START_DATE';
1001: l_token_tbl_two(1).token_value := p_start_date;
1002: l_token_tbl_two(2).token_name := 'END_DATE';
1003: l_token_tbl_two(2).token_value := p_end_date;
1004: error_handler.Add_Error_Message
1005: ( p_message_name => 'EGO_IPI_OVERLAP_GRANT'
1006: , p_application_id => 'EGO'
1007: , p_message_text => NULL
1008: , p_token_tbl => l_token_tbl_two

Line 1042: error_handler.Add_Error_Message

1038: FROM MTL_SYSTEM_ITEMS_KFV
1039: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1040: AND ORGANIZATION_ID = p_organization_id;
1041: l_token_tbl_one(1).token_value := l_item_number;
1042: error_handler.Add_Error_Message
1043: ( p_message_name => 'EGO_IPI_GRANT_NOT_FOUND'
1044: , p_application_id => 'EGO'
1045: , p_message_text => NULL
1046: , p_token_tbl => l_token_tbl_one

Line 1138: l_token_tbl_two Error_Handler.Token_Tbl_Type;

1134: AND start_date <= NVL(cp_end_date, start_date)
1135: AND NVL(end_date,cp_start_date) >= cp_start_date;
1136:
1137:
1138: l_token_tbl_two Error_Handler.Token_Tbl_Type;
1139: l_grant_guid fnd_grants.grant_guid%TYPE;
1140: l_temp_grant_guid fnd_grants.grant_guid%TYPE;
1141:
1142: l_success VARCHAR2(999);

Line 1167: error_handler.Add_Error_Message

1163: l_token_tbl_two(1).token_name := 'START_DATE';
1164: l_token_tbl_two(1).token_value := p_start_date;
1165: l_token_tbl_two(2).token_name := 'END_DATE';
1166: l_token_tbl_two(2).token_value := p_end_date;
1167: error_handler.Add_Error_Message
1168: ( p_message_name => 'EGO_IPI_OVERLAP_GRANT'
1169: , p_application_id => 'EGO'
1170: , p_message_text => NULL
1171: , p_token_tbl => l_token_tbl_two

Line 1305: l_token_tbl_none Error_Handler.Token_Tbl_Type;

1301: FROM ego_item_people_intf
1302: WHERE data_set_id = cp_data_set_id
1303: AND process_status = G_PS_IN_PROCESS;
1304:
1305: l_token_tbl_none Error_Handler.Token_Tbl_Type;
1306: l_token_tbl_one Error_Handler.Token_Tbl_Type;
1307:
1308: l_user_party_id_char VARCHAR2(100);
1309: l_group_party_id_char VARCHAR2(100);

Line 1306: l_token_tbl_one Error_Handler.Token_Tbl_Type;

1302: WHERE data_set_id = cp_data_set_id
1303: AND process_status = G_PS_IN_PROCESS;
1304:
1305: l_token_tbl_none Error_Handler.Token_Tbl_Type;
1306: l_token_tbl_one Error_Handler.Token_Tbl_Type;
1307:
1308: l_user_party_id_char VARCHAR2(100);
1309: l_group_party_id_char VARCHAR2(100);
1310: l_company_party_id_char VARCHAR2(100);

Line 1398: error_handler.Add_Error_Message

1394: ELSE
1395: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
1396: l_token_tbl_one(1).token_name := 'ITEM';
1397: l_token_tbl_one(1).token_value := cr.item_number;
1398: error_handler.Add_Error_Message
1399: ( p_message_name => 'EGO_IPI_GRANT_NOT_FOUND'
1400: , p_application_id => 'EGO'
1401: , p_message_text => NULL
1402: , p_token_tbl => l_token_tbl_one

Line 1622: Error_Handler.Open_Debug_Session(

1618:
1619: G_ERROR_FILE_NAME := G_ERROR_TABLE_NAME||'_'||to_char(sysdate, 'DDMONYYYY_HH24MISS')||'.err';
1620: --Conc_Log('Trying to open the Error File => '||G_ERROR_FILE_NAME);
1621:
1622: Error_Handler.Open_Debug_Session(
1623: p_debug_filename => G_ERROR_FILE_NAME
1624: ,p_output_dir => l_log_output_dir
1625: ,x_return_status => l_log_return_status
1626: ,x_error_mesg => l_errbuff

Line 1904: l_token_tbl_none Error_Handler.Token_Tbl_Type;

1900: SELECT VALUE
1901: FROM V$PARAMETER
1902: WHERE NAME = 'utl_file_dir';
1903:
1904: l_token_tbl_none Error_Handler.Token_Tbl_Type;
1905: l_token_tbl_one Error_Handler.Token_Tbl_Type;
1906: l_token_tbl_two Error_Handler.Token_Tbl_Type;
1907: l_token_tbl_three Error_Handler.Token_Tbl_Type;
1908:

Line 1905: l_token_tbl_one Error_Handler.Token_Tbl_Type;

1901: FROM V$PARAMETER
1902: WHERE NAME = 'utl_file_dir';
1903:
1904: l_token_tbl_none Error_Handler.Token_Tbl_Type;
1905: l_token_tbl_one Error_Handler.Token_Tbl_Type;
1906: l_token_tbl_two Error_Handler.Token_Tbl_Type;
1907: l_token_tbl_three Error_Handler.Token_Tbl_Type;
1908:
1909: l_login_party_id hz_parties.party_id%TYPE;

Line 1906: l_token_tbl_two Error_Handler.Token_Tbl_Type;

1902: WHERE NAME = 'utl_file_dir';
1903:
1904: l_token_tbl_none Error_Handler.Token_Tbl_Type;
1905: l_token_tbl_one Error_Handler.Token_Tbl_Type;
1906: l_token_tbl_two Error_Handler.Token_Tbl_Type;
1907: l_token_tbl_three Error_Handler.Token_Tbl_Type;
1908:
1909: l_login_party_id hz_parties.party_id%TYPE;
1910: l_login_party_name VARCHAR2(240);

Line 1907: l_token_tbl_three Error_Handler.Token_Tbl_Type;

1903:
1904: l_token_tbl_none Error_Handler.Token_Tbl_Type;
1905: l_token_tbl_one Error_Handler.Token_Tbl_Type;
1906: l_token_tbl_two Error_Handler.Token_Tbl_Type;
1907: l_token_tbl_three Error_Handler.Token_Tbl_Type;
1908:
1909: l_login_party_id hz_parties.party_id%TYPE;
1910: l_login_party_name VARCHAR2(240);
1911: l_ipi_lines_count NUMBER;

Line 1927: l_log_mesg_token_tbl ERROR_HANDLER.Mesg_Token_Tbl_Type;

1923: l_inventory_item_id NUMBER;
1924:
1925: l_log_output_dir VARCHAR2(200);
1926: l_log_return_status VARCHAR2(99);
1927: l_log_mesg_token_tbl ERROR_HANDLER.Mesg_Token_Tbl_Type;
1928:
1929: -- Bug 13637215 Start
1930: -- Note: No more ego_login_items_temp
1931: l_user_name VARCHAR2(80);

Line 1973: ERROR_HANDLER.initialize();

1969: ------------------------------------------------------------
1970: G_DEBUG_MODE := DEBUG_MODE_ERROR;
1971: END IF; -- IF p_debug_mode
1972:
1973: ERROR_HANDLER.initialize();
1974: ERROR_HANDLER.set_bo_identifier(G_BO_IDENTIFIER);
1975:
1976: --Opens Error_Handler debug session, only if Debug session is not already open.
1977: IF (Error_Handler.Get_Debug <> 'Y') THEN

Line 1974: ERROR_HANDLER.set_bo_identifier(G_BO_IDENTIFIER);

1970: G_DEBUG_MODE := DEBUG_MODE_ERROR;
1971: END IF; -- IF p_debug_mode
1972:
1973: ERROR_HANDLER.initialize();
1974: ERROR_HANDLER.set_bo_identifier(G_BO_IDENTIFIER);
1975:
1976: --Opens Error_Handler debug session, only if Debug session is not already open.
1977: IF (Error_Handler.Get_Debug <> 'Y') THEN
1978: Open_Debug_Session;

Line 1976: --Opens Error_Handler debug session, only if Debug session is not already open.

1972:
1973: ERROR_HANDLER.initialize();
1974: ERROR_HANDLER.set_bo_identifier(G_BO_IDENTIFIER);
1975:
1976: --Opens Error_Handler debug session, only if Debug session is not already open.
1977: IF (Error_Handler.Get_Debug <> 'Y') THEN
1978: Open_Debug_Session;
1979: END IF;
1980:

Line 1977: IF (Error_Handler.Get_Debug <> 'Y') THEN

1973: ERROR_HANDLER.initialize();
1974: ERROR_HANDLER.set_bo_identifier(G_BO_IDENTIFIER);
1975:
1976: --Opens Error_Handler debug session, only if Debug session is not already open.
1977: IF (Error_Handler.Get_Debug <> 'Y') THEN
1978: Open_Debug_Session;
1979: END IF;
1980:
1981: Write_Debug('Start of the Process');

Line 2028: error_handler.Add_Error_Message

2024: FETCH c_count_ipi_lines INTO l_ipi_lines_count;
2025: CLOSE c_count_ipi_lines;
2026: IF l_ipi_lines_count = 0 THEN
2027: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
2028: error_handler.Add_Error_Message
2029: ( p_message_name => 'EGO_IPI_NO_LINES'
2030: , p_application_id => 'EGO'
2031: , p_message_text => NULL
2032: , p_token_tbl => l_token_tbl_none

Line 2139: error_handler.Add_Error_Message

2135: SET process_status = G_PS_ERROR
2136: WHERE CURRENT OF c_err_mand_params;
2137: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
2138: l_msg_name := 'EGO_INTF_MAND_PARAM_MISSING';
2139: error_handler.Add_Error_Message
2140: ( p_message_name => l_msg_name
2141: , p_application_id => 'EGO'
2142: , p_message_text => NULL
2143: , p_token_tbl => l_token_tbl_none

Line 2169: error_handler.Add_Error_Message

2165: SET process_status = G_PS_ERROR
2166: WHERE CURRENT OF c_err_dates;
2167: IF G_DEBUG_MODE >= DEBUG_MODE_ERROR THEN
2168: l_msg_name := 'EGO_IPI_INVALID_DATES';
2169: error_handler.Add_Error_Message
2170: ( p_message_name => l_msg_name
2171: , p_application_id => 'EGO'
2172: , p_message_text => NULL
2173: , p_token_tbl => l_token_tbl_none

Line 2204: error_handler.Add_Error_Message

2200: l_msg_name := 'EGO_IPI_MISSING_VALUE';
2201: l_token_tbl_one(1).token_name := 'VALUE';
2202: l_token_tbl_one(1).token_value := 'TRANSACTION TYPE';
2203:
2204: error_handler.Add_Error_Message
2205: ( p_message_name => l_msg_name
2206: , p_application_id => 'EGO'
2207: , p_message_text => NULL
2208: , p_token_tbl => l_token_tbl_one

Line 2223: error_handler.Add_Error_Message

2219: l_token_tbl_two(1).token_name := 'NAME';
2220: l_token_tbl_two(1).token_value := 'TRANSACTION TYPE';
2221: l_token_tbl_two(2).token_name := 'VALUE';
2222: l_token_tbl_two(2).token_value := cr.transaction_type;
2223: error_handler.Add_Error_Message
2224: ( p_message_name => l_msg_name
2225: , p_application_id => 'EGO'
2226: , p_message_text => NULL
2227: , p_token_tbl => l_token_tbl_two

Line 2261: error_handler.Add_Error_Message

2257: Write_Debug (to_char(cr.transaction_id)||' Missing Grantee Type');
2258: l_msg_name := 'EGO_IPI_MISSING_VALUE';
2259: l_token_tbl_one(1).token_name := 'VALUE';
2260: l_token_tbl_one(1).token_value := 'GRANTEE TYPE';
2261: error_handler.Add_Error_Message
2262: ( p_message_name => l_msg_name
2263: , p_application_id => 'EGO'
2264: , p_message_text => NULL
2265: , p_token_tbl => l_token_tbl_one

Line 2282: error_handler.Add_Error_Message

2278: l_token_tbl_two(1).token_name := 'NAME';
2279: l_token_tbl_two(1).token_value := 'GRANTEE TYPE';
2280: l_token_tbl_two(2).token_name := 'VALUE';
2281: l_token_tbl_two(2).token_value := cr.grantee_type;
2282: error_handler.Add_Error_Message
2283: ( p_message_name => l_msg_name
2284: , p_application_id => 'EGO'
2285: , p_message_text => NULL
2286: , p_token_tbl => l_token_tbl_two

Line 2398: error_handler.Add_Error_Message

2394: Write_Debug (to_char(cr.transaction_id) || ' Missing Grantee Name ');
2395: l_msg_name := 'EGO_IPI_MISSING_VALUE';
2396: l_token_tbl_one(1).token_name := 'VALUE';
2397: l_token_tbl_one(1).token_value := 'GRANTEE NAME';
2398: error_handler.Add_Error_Message
2399: ( p_message_name => l_msg_name
2400: , p_application_id => 'EGO'
2401: , p_message_text => NULL
2402: , p_token_tbl => l_token_tbl_one

Line 2417: error_handler.Add_Error_Message

2413: l_token_tbl_two(1).token_name := 'NAME';
2414: l_token_tbl_two(1).token_value := 'GRANTEE NAME';
2415: l_token_tbl_two(2).token_name := 'VALUE';
2416: l_token_tbl_two(2).token_value := cr.grantee_name;
2417: error_handler.Add_Error_Message
2418: ( p_message_name => l_msg_name
2419: , p_application_id => 'EGO'
2420: , p_message_text => NULL
2421: , p_token_tbl => l_token_tbl_two

Line 2492: error_handler.Add_Error_Message

2488: IF ( cr.display_role_name IS NULL ) THEN
2489: l_msg_name := 'EGO_IPI_MISSING_VALUE';
2490: l_token_tbl_one(1).token_name := 'VALUE';
2491: l_token_tbl_one(1).token_value := 'DISPLAY ROLE NAME';
2492: error_handler.Add_Error_Message
2493: ( p_message_name => l_msg_name
2494: , p_application_id => 'EGO'
2495: , p_message_text => NULL
2496: , p_token_tbl => l_token_tbl_one

Line 2510: error_handler.Add_Error_Message

2506: l_token_tbl_two(1).token_name := 'NAME';
2507: l_token_tbl_two(1).token_value := 'DISPLAY ROLE NAME';
2508: l_token_tbl_two(2).token_name := 'VALUE';
2509: l_token_tbl_two(2).token_value := cr.display_role_name;
2510: error_handler.Add_Error_Message
2511: ( p_message_name => l_msg_name
2512: , p_application_id => 'EGO'
2513: , p_message_text => NULL
2514: , p_token_tbl => l_token_tbl_two

Line 2650: -- error_handler.Add_Error_Message

2646: -- l_token_tbl_three(2).token_name := 'ITEM';
2647: -- l_token_tbl_three(2).token_value := cr.item_number;
2648: -- l_token_tbl_three(3).token_name := 'ORGANIZATION';
2649: -- l_token_tbl_three(3).token_value := cr.organization_code;
2650: -- error_handler.Add_Error_Message
2651: -- ( p_message_name => l_msg_name
2652: -- , p_application_id => 'EGO'
2653: -- , p_message_text => NULL
2654: -- , p_token_tbl => l_token_tbl_three

Line 2681: -- error_handler.Add_Error_Message

2677: -- IF ( cr.item_number IS NULL ) THEN
2678: -- l_msg_name := 'EGO_IPI_MISSING_VALUE';
2679: -- l_token_tbl_one(1).token_name := 'VALUE';
2680: -- l_token_tbl_one(1).token_value := 'ITEM NUMBER';
2681: -- error_handler.Add_Error_Message
2682: -- ( p_message_name => l_msg_name
2683: -- , p_application_id => 'EGO'
2684: -- , p_message_text => NULL
2685: -- , p_token_tbl => l_token_tbl_one

Line 2699: -- error_handler.Add_Error_Message

2695: -- l_token_tbl_two(1).token_name := 'ITEM';
2696: -- l_token_tbl_two(1).token_value := cr.item_number;
2697: -- l_token_tbl_two(2).token_name := 'ORGANIZATION';
2698: -- l_token_tbl_two(2).token_value := cr.organization_code;
2699: -- error_handler.Add_Error_Message
2700: -- ( p_message_name => l_msg_name
2701: -- , p_application_id => 'EGO'
2702: -- , p_message_text => NULL
2703: -- , p_token_tbl => l_token_tbl_two

Line 2803: error_handler.Add_Error_Message

2799: l_token_tbl_two(1).token_value := cr.item_number;
2800: l_token_tbl_two(2).token_name := 'ORGANIZATION';
2801: l_token_tbl_two(2).token_value := cr.organization_code;
2802: END IF;
2803: error_handler.Add_Error_Message
2804: ( p_message_name => l_msg_name
2805: , p_application_id => 'EGO'
2806: , p_message_text => NULL
2807: , p_token_tbl => l_token_tbl_two

Line 2956: error_handler.Add_Error_Message

2952: l_token_tbl_three(2).token_name := 'ITEM';
2953: l_token_tbl_three(2).token_value := cr.item_number;
2954: l_token_tbl_three(3).token_name := 'ORGANIZATION';
2955: l_token_tbl_three(3).token_value := cr.organization_code;
2956: error_handler.Add_Error_Message
2957: ( p_message_name => l_msg_name
2958: , p_application_id => 'EGO'
2959: , p_message_text => NULL
2960: , p_token_tbl => l_token_tbl_three

Line 3071: --Close Error_Handler debug session, only if Debug session is already open.

3067:
3068: Conc_Log('Loading of Item People Import Interface lines complete.');
3069:
3070: -----------------------------------------------------------------------------
3071: --Close Error_Handler debug session, only if Debug session is already open.
3072: -----------------------------------------------------------------------------
3073: IF (Error_Handler.Get_Debug = 'Y') THEN
3074: Error_Handler.Close_Debug_Session;
3075: END IF;

Line 3073: IF (Error_Handler.Get_Debug = 'Y') THEN

3069:
3070: -----------------------------------------------------------------------------
3071: --Close Error_Handler debug session, only if Debug session is already open.
3072: -----------------------------------------------------------------------------
3073: IF (Error_Handler.Get_Debug = 'Y') THEN
3074: Error_Handler.Close_Debug_Session;
3075: END IF;
3076:
3077: EXCEPTION

Line 3074: Error_Handler.Close_Debug_Session;

3070: -----------------------------------------------------------------------------
3071: --Close Error_Handler debug session, only if Debug session is already open.
3072: -----------------------------------------------------------------------------
3073: IF (Error_Handler.Get_Debug = 'Y') THEN
3074: Error_Handler.Close_Debug_Session;
3075: END IF;
3076:
3077: EXCEPTION
3078: WHEN OTHERS THEN

Line 3149: Error_Handler.Close_Debug_Session;

3145: END IF;
3146: -----------------------------------------------------
3147: -- Close Debug Session, as we cant proceed further.
3148: -----------------------------------------------------
3149: Error_Handler.Close_Debug_Session;
3150:
3151: -------------------------------------------------------------
3152: -- Rollback incomplete processing, and raise the exception
3153: -- to trace all the way up.