DBA Data[Home] [Help]

APPS.ENG_IMPL_ITEM_CHANGES_PKG dependencies on ERROR_HANDLER

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

2: /* $Header: ENGITMIB.pls 120.52 2012/02/24 03:31:58 jawan ship $ */
3:
4:
5: ----------------------------------------------------------------------------
6: -- Debug Profile option used to write Error_Handler.Write_Debug --
7: -- Profile option name = INV_DEBUG_TRACE ; --
8: -- User Profile Option Name = INV: Debug Trace --
9: -- Values: 1 (True) ; 0 (False) --
10: -- NOTE: This better than MRP_DEBUG which is used at many places. --

Line 60: G_ENG_MSG_TYPE_ERROR CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_ERROR ;

56:
57: ---------------------------------------------------------------
58: -- Message Type Text . --
59: ---------------------------------------------------------------
60: G_ENG_MSG_TYPE_ERROR CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_ERROR ;
61: G_ENG_MSG_TYPE_WARNING CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_WARNING ;
62: G_ENG_MSG_TYPE_UNEXPECTED CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_UNEXPECTED ;
63: G_ENG_MSG_TYPE_FATAL CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_FATAL ;
64: G_ENG_MSG_TYPE_CONFIRMATION CONSTANT VARCHAR2(1) := 'C';

Line 61: G_ENG_MSG_TYPE_WARNING CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_WARNING ;

57: ---------------------------------------------------------------
58: -- Message Type Text . --
59: ---------------------------------------------------------------
60: G_ENG_MSG_TYPE_ERROR CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_ERROR ;
61: G_ENG_MSG_TYPE_WARNING CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_WARNING ;
62: G_ENG_MSG_TYPE_UNEXPECTED CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_UNEXPECTED ;
63: G_ENG_MSG_TYPE_FATAL CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_FATAL ;
64: G_ENG_MSG_TYPE_CONFIRMATION CONSTANT VARCHAR2(1) := 'C';
65: G_ENG_MSG_TYPE_INFORMATION CONSTANT VARCHAR2(1) := 'I' ;

Line 62: G_ENG_MSG_TYPE_UNEXPECTED CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_UNEXPECTED ;

58: -- Message Type Text . --
59: ---------------------------------------------------------------
60: G_ENG_MSG_TYPE_ERROR CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_ERROR ;
61: G_ENG_MSG_TYPE_WARNING CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_WARNING ;
62: G_ENG_MSG_TYPE_UNEXPECTED CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_UNEXPECTED ;
63: G_ENG_MSG_TYPE_FATAL CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_FATAL ;
64: G_ENG_MSG_TYPE_CONFIRMATION CONSTANT VARCHAR2(1) := 'C';
65: G_ENG_MSG_TYPE_INFORMATION CONSTANT VARCHAR2(1) := 'I' ;
66:

Line 63: G_ENG_MSG_TYPE_FATAL CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_FATAL ;

59: ---------------------------------------------------------------
60: G_ENG_MSG_TYPE_ERROR CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_ERROR ;
61: G_ENG_MSG_TYPE_WARNING CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_WARNING ;
62: G_ENG_MSG_TYPE_UNEXPECTED CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_UNEXPECTED ;
63: G_ENG_MSG_TYPE_FATAL CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_FATAL ;
64: G_ENG_MSG_TYPE_CONFIRMATION CONSTANT VARCHAR2(1) := 'C';
65: G_ENG_MSG_TYPE_INFORMATION CONSTANT VARCHAR2(1) := 'I' ;
66:
67:

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

144: END;
145:
146:
147: -----------------------------------------------------------------
148: -- Write Debug statements to Log using Error Handler procedure --
149: -----------------------------------------------------------------
150: PROCEDURE Write_Debug (p_msg IN VARCHAR2)
151: IS
152: BEGIN

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

150: PROCEDURE Write_Debug (p_msg IN VARCHAR2)
151: IS
152: BEGIN
153:
154: -- NOTE: No need to check for profile now, as Error_Handler checks
155: -- for Error_Handler.Get_Debug = 'Y' before writing to Debug Log.
156: -- If Profile set to TRUE --
157: -- IF (G_DEBUG = 1) THEN
158: -- Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);

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

151: IS
152: BEGIN
153:
154: -- NOTE: No need to check for profile now, as Error_Handler checks
155: -- for Error_Handler.Get_Debug = 'Y' before writing to Debug Log.
156: -- If Profile set to TRUE --
157: -- IF (G_DEBUG = 1) THEN
158: -- Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);
159: -- END IF;

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

154: -- NOTE: No need to check for profile now, as Error_Handler checks
155: -- for Error_Handler.Get_Debug = 'Y' before writing to Debug Log.
156: -- If Profile set to TRUE --
157: -- IF (G_DEBUG = 1) THEN
158: -- Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);
159: -- END IF;
160:
161: Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);
162:

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

157: -- IF (G_DEBUG = 1) THEN
158: -- Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);
159: -- END IF;
160:
161: Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);
162:
163: -- For Concurrent Request Log
164: Developer_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);
165:

Line 216: Error_Handler.initialize();

212: l_log_return_status VARCHAR2(99);
213: l_errbuff VARCHAR2(999);
214: BEGIN
215:
216: Error_Handler.initialize();
217: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);
218:
219: ---------------------------------------------------------------------------------
220: -- Commented on 12/17/2003 (PPEDDAMA). Open_Debug_Session should set the value

Line 217: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);

213: l_errbuff VARCHAR2(999);
214: BEGIN
215:
216: Error_Handler.initialize();
217: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);
218:
219: ---------------------------------------------------------------------------------
220: -- Commented on 12/17/2003 (PPEDDAMA). Open_Debug_Session should set the value
221: -- appropriately, so that when the Debug Session is successfully opened :

Line 222: -- will return Error_Handler.Get_Debug = 'Y', else Error_Handler.Get_Debug = 'N'

218:
219: ---------------------------------------------------------------------------------
220: -- Commented on 12/17/2003 (PPEDDAMA). Open_Debug_Session should set the value
221: -- appropriately, so that when the Debug Session is successfully opened :
222: -- will return Error_Handler.Get_Debug = 'Y', else Error_Handler.Get_Debug = 'N'
223: ---------------------------------------------------------------------------------
224: -- Error_Handler.Set_Debug('Y');
225:
226: OPEN c_get_utl_file_dir;

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

220: -- Commented on 12/17/2003 (PPEDDAMA). Open_Debug_Session should set the value
221: -- appropriately, so that when the Debug Session is successfully opened :
222: -- will return Error_Handler.Get_Debug = 'Y', else Error_Handler.Get_Debug = 'N'
223: ---------------------------------------------------------------------------------
224: -- Error_Handler.Set_Debug('Y');
225:
226: OPEN c_get_utl_file_dir;
227: FETCH c_get_utl_file_dir INTO l_log_output_dir;
228: --developer_debug('UTL_FILE_DIR : '||l_log_output_dir);

Line 256: -- This sets Debug value so that Error_Handler.Get_Debug returns 'Y' --

252: --developer_debug('Trying to open the Error File => '||G_ERROR_FILE_NAME);
253:
254: -----------------------------------------------------------------------
255: -- To open the Debug Session to write the Debug Log. --
256: -- This sets Debug value so that Error_Handler.Get_Debug returns 'Y' --
257: -----------------------------------------------------------------------
258: Error_Handler.Open_Debug_Session(
259: p_debug_filename => G_ERROR_FILE_NAME
260: ,p_output_dir => l_log_output_dir

Line 258: Error_Handler.Open_Debug_Session(

254: -----------------------------------------------------------------------
255: -- To open the Debug Session to write the Debug Log. --
256: -- This sets Debug value so that Error_Handler.Get_Debug returns 'Y' --
257: -----------------------------------------------------------------------
258: Error_Handler.Open_Debug_Session(
259: p_debug_filename => G_ERROR_FILE_NAME
260: ,p_output_dir => l_log_output_dir
261: ,x_return_status => l_log_return_status
262: ,x_error_mesg => l_errbuff

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

300:
301: G_OUTPUT_DIR := p_output_dir ;
302: G_ERROR_FILE_NAME := p_file_name ;
303: ----------------------------------------------------------------------------------
304: -- Opens Error_Handler debug session, only if Debug session is not already open.
305: -- Suggested by RFAROOK, so that multiple debug sessions are not open PER
306: -- Concurrent Request.
307: ----------------------------------------------------------------------------------
308: IF (Error_Handler.Get_Debug <> 'Y') THEN

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

304: -- Opens Error_Handler debug session, only if Debug session is not already open.
305: -- Suggested by RFAROOK, so that multiple debug sessions are not open PER
306: -- Concurrent Request.
307: ----------------------------------------------------------------------------------
308: IF (Error_Handler.Get_Debug <> 'Y') THEN
309: Open_Debug_Session_Internal;
310: END IF;
311:
312: END IF;

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

319: PROCEDURE Close_Debug_Session IS
320:
321: BEGIN
322: -----------------------------------------------------------------------------
323: -- Close Error_Handler debug session, only if Debug session is already open.
324: -----------------------------------------------------------------------------
325: IF (Error_Handler.Get_Debug = 'Y') THEN
326: Error_Handler.Close_Debug_Session;
327: END IF;

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

321: BEGIN
322: -----------------------------------------------------------------------------
323: -- Close Error_Handler debug session, only if Debug session is already open.
324: -----------------------------------------------------------------------------
325: IF (Error_Handler.Get_Debug = 'Y') THEN
326: Error_Handler.Close_Debug_Session;
327: END IF;
328:
329: END Close_Debug_Session;

Line 326: Error_Handler.Close_Debug_Session;

322: -----------------------------------------------------------------------------
323: -- Close Error_Handler debug session, only if Debug session is already open.
324: -----------------------------------------------------------------------------
325: IF (Error_Handler.Get_Debug = 'Y') THEN
326: Error_Handler.Close_Debug_Session;
327: END IF;
328:
329: END Close_Debug_Session;
330:

Line 1368: -- Close Error Handler Debug Session.

1364: Write_Debug('End of impl_item_changes . . . ' );
1365:
1366:
1367: -----------------------------------------------------
1368: -- Close Error Handler Debug Session.
1369: -----------------------------------------------------
1370: Close_Debug_Session;
1371:
1372:

Line 1402: -- Close Error Handler Debug Session.

1398: END LOOP;
1399:
1400:
1401: -----------------------------------------------------
1402: -- Close Error Handler Debug Session.
1403: -----------------------------------------------------
1404: Close_Debug_Session;
1405:
1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1430: -- Close Error Handler Debug Session.

1426:
1427: END LOOP;
1428:
1429: -----------------------------------------------------
1430: -- Close Error Handler Debug Session.
1431: -----------------------------------------------------
1432: Close_Debug_Session;
1433:
1434: WHEN OTHERS THEN

Line 1474: -- Close Error Handler Debug Session.

1470: END LOOP;
1471:
1472:
1473: -----------------------------------------------------
1474: -- Close Error Handler Debug Session.
1475: -----------------------------------------------------
1476: Close_Debug_Session;
1477:
1478: END impl_item_changes;

Line 1547: l_message_list Error_Handler.Error_Tbl_Type ;

1543:
1544: l_msg_data VARCHAR2(4000);
1545: l_msg_count NUMBER;
1546: l_return_status VARCHAR2(1);
1547: l_message_list Error_Handler.Error_Tbl_Type ;
1548: l_msg_index NUMBER ;
1549:
1550: l_found BOOLEAN ;
1551:

Line 1618: -- l_token_table ERROR_HANDLER.Token_Tbl_Type;

1614: -- l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1615: -- l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1616: -- l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1617: -- l_dummy_err_msg_name VARCHAR2(30);
1618: -- l_token_table ERROR_HANDLER.Token_Tbl_Type;
1619: -- l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
1620: -- l_attr_col_name_for_uom_col VARCHAR2(30);
1621:
1622: BEGIN

Line 2397: Error_Handler.Get_Message_List(x_Message_List => l_message_list ) ;

2393: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2394: THEN
2395:
2396: -- Get message list from Error_Hanlder
2397: Error_Handler.Get_Message_List(x_Message_List => l_message_list ) ;
2398: l_msg_index := l_message_list.FIRST ;
2399:
2400: WHILE l_msg_index IS NOT NULL
2401: LOOP

Line 2487: -- Close Error Handler Debug Session.

2483: );
2484:
2485:
2486: -----------------------------------------------------
2487: -- Close Error Handler Debug Session.
2488: -----------------------------------------------------
2489: -- Close debug session only explicitly open the debug session for
2490: -- this API.
2491: IF FND_API.to_Boolean(p_debug)

Line 2519: -- Close Error Handler Debug Session.

2515: p_data => x_msg_data
2516: );
2517:
2518: -----------------------------------------------------
2519: -- Close Error Handler Debug Session.
2520: -----------------------------------------------------
2521: -- Close debug session only explicitly open the debug session for
2522: -- this API.
2523: IF FND_API.to_Boolean(p_debug)

Line 2549: -- Close Error Handler Debug Session.

2545: p_data => x_msg_data
2546: );
2547:
2548: -----------------------------------------------------
2549: -- Close Error Handler Debug Session.
2550: -----------------------------------------------------
2551: -- Close debug session only explicitly open the debug session for
2552: -- this API.
2553: IF FND_API.to_Boolean(p_debug)

Line 2594: -- Close Error Handler Debug Session.

2590: p_data => x_msg_data
2591: );
2592:
2593: -----------------------------------------------------
2594: -- Close Error Handler Debug Session.
2595: -----------------------------------------------------
2596: -- Close debug session only explicitly open the debug session for
2597: -- this API.
2598: IF FND_API.to_Boolean(p_debug)

Line 2813: -- Close Error Handler Debug Session.

2809: );
2810:
2811:
2812: -----------------------------------------------------
2813: -- Close Error Handler Debug Session.
2814: -----------------------------------------------------
2815: -- Close debug session only explicitly open the debug session for
2816: -- this API.
2817: IF FND_API.to_Boolean(p_debug)

Line 2845: -- Close Error Handler Debug Session.

2841: p_data => x_msg_data
2842: );
2843:
2844: -----------------------------------------------------
2845: -- Close Error Handler Debug Session.
2846: -----------------------------------------------------
2847: -- Close debug session only explicitly open the debug session for
2848: -- this API.
2849: IF FND_API.to_Boolean(p_debug)

Line 2875: -- Close Error Handler Debug Session.

2871: p_data => x_msg_data
2872: );
2873:
2874: -----------------------------------------------------
2875: -- Close Error Handler Debug Session.
2876: -----------------------------------------------------
2877: -- Close debug session only explicitly open the debug session for
2878: -- this API.
2879: IF FND_API.to_Boolean(p_debug)

Line 2917: -- Close Error Handler Debug Session.

2913: p_data => x_msg_data
2914: );
2915:
2916: -----------------------------------------------------
2917: -- Close Error Handler Debug Session.
2918: -----------------------------------------------------
2919: -- Close debug session only explicitly open the debug session for
2920: -- this API.
2921: IF FND_API.to_Boolean(p_debug)

Line 4248: ,p_init_error_handler => FND_API.G_FALSE

4244: ,p_multi_row_attrs_table => l_multi_row_attrs_tbl
4245: ,p_entity_id => null
4246: ,p_entity_index => null
4247: ,p_entity_code => G_BO_IDENTIFIER
4248: ,p_init_error_handler => FND_API.G_FALSE
4249: ,p_commit => FND_API.G_FALSE
4250: ,x_return_status => l_return_status
4251: ,x_errorcode => l_errorcode
4252: ,x_msg_count => l_msg_count

Line 4364: -- Close Error Handler Debug Session.

4360: );
4361:
4362:
4363: -----------------------------------------------------
4364: -- Close Error Handler Debug Session.
4365: -----------------------------------------------------
4366: -- Close debug session only explicitly open the debug session for
4367: -- this API.
4368: IF FND_API.to_Boolean(p_debug)

Line 4396: -- Close Error Handler Debug Session.

4392: p_data => x_msg_data
4393: );
4394:
4395: -----------------------------------------------------
4396: -- Close Error Handler Debug Session.
4397: -----------------------------------------------------
4398: -- Close debug session only explicitly open the debug session for
4399: -- this API.
4400: IF FND_API.to_Boolean(p_debug)

Line 4426: -- Close Error Handler Debug Session.

4422: p_data => x_msg_data
4423: );
4424:
4425: -----------------------------------------------------
4426: -- Close Error Handler Debug Session.
4427: -----------------------------------------------------
4428: -- Close debug session only explicitly open the debug session for
4429: -- this API.
4430: IF FND_API.to_Boolean(p_debug)

Line 4469: -- Close Error Handler Debug Session.

4465: p_data => x_msg_data
4466: );
4467:
4468: -----------------------------------------------------
4469: -- Close Error Handler Debug Session.
4470: -----------------------------------------------------
4471: -- Close debug session only explicitly open the debug session for
4472: -- this API.
4473: IF FND_API.to_Boolean(p_debug)

Line 4537: l_token_table ERROR_HANDLER.Token_Tbl_Type;

4533: l_current_pending_ext_id NUMBER;
4534: l_current_column_name VARCHAR2(30);
4535: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
4536: l_dummy_err_msg_name VARCHAR2(30);
4537: l_token_table ERROR_HANDLER.Token_Tbl_Type;
4538: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
4539: l_impl_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
4540: l_uom_column_nv_pairs LOCAL_COL_NV_PAIR_TABLE;
4541: l_uom_nv_pairs_index NUMBER := 0;

Line 4565: -- Initialize FND_MSG_PUB and ERROR_HANDLER if necessary

4561: -- Standard start of API savepoint
4562: SAVEPOINT Implement_Change_Line_PUB;
4563: --END IF;
4564:
4565: -- Initialize FND_MSG_PUB and ERROR_HANDLER if necessary
4566: IF (FND_API.To_Boolean(p_init_msg_list)) THEN
4567: FND_MSG_PUB.Initialize;
4568: ERROR_HANDLER.Initialize;
4569: END IF;

Line 4568: ERROR_HANDLER.Initialize;

4564:
4565: -- Initialize FND_MSG_PUB and ERROR_HANDLER if necessary
4566: IF (FND_API.To_Boolean(p_init_msg_list)) THEN
4567: FND_MSG_PUB.Initialize;
4568: ERROR_HANDLER.Initialize;
4569: END IF;
4570:
4571: -- Check for call compatibility
4572: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

Line 5781: ERROR_HANDLER.Add_Error_Message(

5777: -----------------------------------------------------------------
5778: -- If Process_Row didn't return any errors, make one ourselves --
5779: -----------------------------------------------------------------
5780: IF (x_msg_data IS NULL AND x_msg_count = 0) THEN
5781: ERROR_HANDLER.Add_Error_Message(
5782: p_message_name => 'EGO_EF_IMPLEMENT_ERR'
5783: ,p_application_id => 'EGO'
5784: ,p_message_type => FND_API.G_RET_STS_ERROR
5785: ,p_addto_fnd_stack => 'Y'

Line 5791: -- (or else return the one we just added to ERROR_HANDLER above) --

5787: END IF;
5788:
5789: -------------------------------------------------------------------
5790: -- If Process_Row had more than one error, return the first one --
5791: -- (or else return the one we just added to ERROR_HANDLER above) --
5792: -------------------------------------------------------------------
5793: IF (x_msg_data IS NULL AND x_msg_count > 0) THEN
5794: DECLARE
5795: message_list ERROR_HANDLER.Error_Tbl_Type;

Line 5795: message_list ERROR_HANDLER.Error_Tbl_Type;

5791: -- (or else return the one we just added to ERROR_HANDLER above) --
5792: -------------------------------------------------------------------
5793: IF (x_msg_data IS NULL AND x_msg_count > 0) THEN
5794: DECLARE
5795: message_list ERROR_HANDLER.Error_Tbl_Type;
5796: BEGIN
5797: ERROR_HANDLER.Get_Message_List(message_list);
5798: x_msg_data := message_list(message_list.FIRST).message_text;
5799: END;

Line 5797: ERROR_HANDLER.Get_Message_List(message_list);

5793: IF (x_msg_data IS NULL AND x_msg_count > 0) THEN
5794: DECLARE
5795: message_list ERROR_HANDLER.Error_Tbl_Type;
5796: BEGIN
5797: ERROR_HANDLER.Get_Message_List(message_list);
5798: x_msg_data := message_list(message_list.FIRST).message_text;
5799: END;
5800: END IF;
5801:

Line 5827: ERROR_HANDLER.Add_Error_Message(

5823: l_token_table(2).TOKEN_VALUE := l_api_name;
5824: l_token_table(3).TOKEN_NAME := 'SQL_ERR_MSG';
5825: l_token_table(3).TOKEN_VALUE := SQLERRM;
5826:
5827: ERROR_HANDLER.Add_Error_Message(
5828: p_message_name => 'EGO_PLSQL_ERR'
5829: ,p_application_id => 'EGO'
5830: ,p_token_tbl => l_token_table
5831: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 5835: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data

5831: ,p_message_type => FND_API.G_RET_STS_ERROR
5832: ,p_addto_fnd_stack => 'Y'
5833: );
5834:
5835: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
5836: ,x_entity_index => l_dummy_entity_index
5837: ,x_entity_id => l_dummy_entity_id
5838: ,x_message_type => l_dummy_message_type);
5839: END;

Line 6092: -- Close Error Handler Debug Session.

6088: );
6089:
6090:
6091: -----------------------------------------------------
6092: -- Close Error Handler Debug Session.
6093: -----------------------------------------------------
6094: -- Close debug session only explicitly open the debug session for
6095: -- this API.
6096: IF FND_API.to_Boolean(p_debug)

Line 6123: -- Close Error Handler Debug Session.

6119: p_data => x_msg_data
6120: );
6121:
6122: -----------------------------------------------------
6123: -- Close Error Handler Debug Session.
6124: -----------------------------------------------------
6125: -- Close debug session only explicitly open the debug session for
6126: -- this API.
6127: IF FND_API.to_Boolean(p_debug)

Line 6154: -- Close Error Handler Debug Session.

6150: p_data => x_msg_data
6151: );
6152:
6153: -----------------------------------------------------
6154: -- Close Error Handler Debug Session.
6155: -----------------------------------------------------
6156: -- Close debug session only explicitly open the debug session for
6157: -- this API.
6158: IF FND_API.to_Boolean(p_debug)

Line 6197: -- Close Error Handler Debug Session.

6193: p_data => x_msg_data
6194: );
6195:
6196: -----------------------------------------------------
6197: -- Close Error Handler Debug Session.
6198: -----------------------------------------------------
6199: -- Close debug session only explicitly open the debug session for
6200: -- this API.
6201: IF FND_API.to_Boolean(p_debug)