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.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.41 2008/07/16 14:17:05 vggarg 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 215: Error_Handler.initialize();

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

Line 216: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);

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

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

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

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

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

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

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

Line 257: Error_Handler.Open_Debug_Session(

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

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

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

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

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

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

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

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

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

Line 325: Error_Handler.Close_Debug_Session;

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

Line 1359: -- Close Error Handler Debug Session.

1355: Write_Debug('End of impl_item_changes . . . ' );
1356:
1357:
1358: -----------------------------------------------------
1359: -- Close Error Handler Debug Session.
1360: -----------------------------------------------------
1361: Close_Debug_Session;
1362:
1363:

Line 1393: -- Close Error Handler Debug Session.

1389: END LOOP;
1390:
1391:
1392: -----------------------------------------------------
1393: -- Close Error Handler Debug Session.
1394: -----------------------------------------------------
1395: Close_Debug_Session;
1396:
1397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1421: -- Close Error Handler Debug Session.

1417:
1418: END LOOP;
1419:
1420: -----------------------------------------------------
1421: -- Close Error Handler Debug Session.
1422: -----------------------------------------------------
1423: Close_Debug_Session;
1424:
1425: WHEN OTHERS THEN

Line 1465: -- Close Error Handler Debug Session.

1461: END LOOP;
1462:
1463:
1464: -----------------------------------------------------
1465: -- Close Error Handler Debug Session.
1466: -----------------------------------------------------
1467: Close_Debug_Session;
1468:
1469: END impl_item_changes;

Line 1538: l_message_list Error_Handler.Error_Tbl_Type ;

1534:
1535: l_msg_data VARCHAR2(4000);
1536: l_msg_count NUMBER;
1537: l_return_status VARCHAR2(1);
1538: l_message_list Error_Handler.Error_Tbl_Type ;
1539: l_msg_index NUMBER ;
1540:
1541: l_found BOOLEAN ;
1542:

Line 1609: -- l_token_table ERROR_HANDLER.Token_Tbl_Type;

1605: -- l_current_dl_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1606: -- l_ext_table_metadata_obj EGO_EXT_TABLE_METADATA_OBJ;
1607: -- l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
1608: -- l_dummy_err_msg_name VARCHAR2(30);
1609: -- l_token_table ERROR_HANDLER.Token_Tbl_Type;
1610: -- l_current_uom_col_nv_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
1611: -- l_attr_col_name_for_uom_col VARCHAR2(30);
1612:
1613: BEGIN

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

2409: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
2410: THEN
2411:
2412: -- Get message list from Error_Hanlder
2413: Error_Handler.Get_Message_List(x_Message_List => l_message_list ) ;
2414: l_msg_index := l_message_list.FIRST ;
2415:
2416: WHILE l_msg_index IS NOT NULL
2417: LOOP

Line 2503: -- Close Error Handler Debug Session.

2499: );
2500:
2501:
2502: -----------------------------------------------------
2503: -- Close Error Handler Debug Session.
2504: -----------------------------------------------------
2505: -- Close debug session only explicitly open the debug session for
2506: -- this API.
2507: IF FND_API.to_Boolean(p_debug)

Line 2535: -- Close Error Handler Debug Session.

2531: p_data => x_msg_data
2532: );
2533:
2534: -----------------------------------------------------
2535: -- Close Error Handler Debug Session.
2536: -----------------------------------------------------
2537: -- Close debug session only explicitly open the debug session for
2538: -- this API.
2539: IF FND_API.to_Boolean(p_debug)

Line 2565: -- Close Error Handler Debug Session.

2561: p_data => x_msg_data
2562: );
2563:
2564: -----------------------------------------------------
2565: -- Close Error Handler Debug Session.
2566: -----------------------------------------------------
2567: -- Close debug session only explicitly open the debug session for
2568: -- this API.
2569: IF FND_API.to_Boolean(p_debug)

Line 2610: -- Close Error Handler Debug Session.

2606: p_data => x_msg_data
2607: );
2608:
2609: -----------------------------------------------------
2610: -- Close Error Handler Debug Session.
2611: -----------------------------------------------------
2612: -- Close debug session only explicitly open the debug session for
2613: -- this API.
2614: IF FND_API.to_Boolean(p_debug)

Line 2829: -- Close Error Handler Debug Session.

2825: );
2826:
2827:
2828: -----------------------------------------------------
2829: -- Close Error Handler Debug Session.
2830: -----------------------------------------------------
2831: -- Close debug session only explicitly open the debug session for
2832: -- this API.
2833: IF FND_API.to_Boolean(p_debug)

Line 2861: -- Close Error Handler Debug Session.

2857: p_data => x_msg_data
2858: );
2859:
2860: -----------------------------------------------------
2861: -- Close Error Handler Debug Session.
2862: -----------------------------------------------------
2863: -- Close debug session only explicitly open the debug session for
2864: -- this API.
2865: IF FND_API.to_Boolean(p_debug)

Line 2891: -- Close Error Handler Debug Session.

2887: p_data => x_msg_data
2888: );
2889:
2890: -----------------------------------------------------
2891: -- Close Error Handler Debug Session.
2892: -----------------------------------------------------
2893: -- Close debug session only explicitly open the debug session for
2894: -- this API.
2895: IF FND_API.to_Boolean(p_debug)

Line 2933: -- Close Error Handler Debug Session.

2929: p_data => x_msg_data
2930: );
2931:
2932: -----------------------------------------------------
2933: -- Close Error Handler Debug Session.
2934: -----------------------------------------------------
2935: -- Close debug session only explicitly open the debug session for
2936: -- this API.
2937: IF FND_API.to_Boolean(p_debug)

Line 4264: ,p_init_error_handler => FND_API.G_FALSE

4260: ,p_multi_row_attrs_table => l_multi_row_attrs_tbl
4261: ,p_entity_id => null
4262: ,p_entity_index => null
4263: ,p_entity_code => G_BO_IDENTIFIER
4264: ,p_init_error_handler => FND_API.G_FALSE
4265: ,p_commit => FND_API.G_FALSE
4266: ,x_return_status => l_return_status
4267: ,x_errorcode => l_errorcode
4268: ,x_msg_count => l_msg_count

Line 4380: -- Close Error Handler Debug Session.

4376: );
4377:
4378:
4379: -----------------------------------------------------
4380: -- Close Error Handler Debug Session.
4381: -----------------------------------------------------
4382: -- Close debug session only explicitly open the debug session for
4383: -- this API.
4384: IF FND_API.to_Boolean(p_debug)

Line 4412: -- Close Error Handler Debug Session.

4408: p_data => x_msg_data
4409: );
4410:
4411: -----------------------------------------------------
4412: -- Close Error Handler Debug Session.
4413: -----------------------------------------------------
4414: -- Close debug session only explicitly open the debug session for
4415: -- this API.
4416: IF FND_API.to_Boolean(p_debug)

Line 4442: -- Close Error Handler Debug Session.

4438: p_data => x_msg_data
4439: );
4440:
4441: -----------------------------------------------------
4442: -- Close Error Handler Debug Session.
4443: -----------------------------------------------------
4444: -- Close debug session only explicitly open the debug session for
4445: -- this API.
4446: IF FND_API.to_Boolean(p_debug)

Line 4485: -- Close Error Handler Debug Session.

4481: p_data => x_msg_data
4482: );
4483:
4484: -----------------------------------------------------
4485: -- Close Error Handler Debug Session.
4486: -----------------------------------------------------
4487: -- Close debug session only explicitly open the debug session for
4488: -- this API.
4489: IF FND_API.to_Boolean(p_debug)

Line 4553: l_token_table ERROR_HANDLER.Token_Tbl_Type;

4549: l_current_pending_ext_id NUMBER;
4550: l_current_column_name VARCHAR2(30);
4551: l_attr_metadata_obj EGO_ATTR_METADATA_OBJ;
4552: l_dummy_err_msg_name VARCHAR2(30);
4553: l_token_table ERROR_HANDLER.Token_Tbl_Type;
4554: l_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
4555: l_impl_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE := EGO_USER_ATTR_DATA_TABLE();
4556: l_uom_column_nv_pairs LOCAL_COL_NV_PAIR_TABLE;
4557: l_uom_nv_pairs_index NUMBER := 0;

Line 4581: -- Initialize FND_MSG_PUB and ERROR_HANDLER if necessary

4577: -- Standard start of API savepoint
4578: SAVEPOINT Implement_Change_Line_PUB;
4579: END IF;
4580:
4581: -- Initialize FND_MSG_PUB and ERROR_HANDLER if necessary
4582: IF (FND_API.To_Boolean(p_init_msg_list)) THEN
4583: FND_MSG_PUB.Initialize;
4584: ERROR_HANDLER.Initialize;
4585: END IF;

Line 4584: ERROR_HANDLER.Initialize;

4580:
4581: -- Initialize FND_MSG_PUB and ERROR_HANDLER if necessary
4582: IF (FND_API.To_Boolean(p_init_msg_list)) THEN
4583: FND_MSG_PUB.Initialize;
4584: ERROR_HANDLER.Initialize;
4585: END IF;
4586:
4587: -- Check for call compatibility
4588: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

Line 5743: ERROR_HANDLER.Add_Error_Message(

5739: -----------------------------------------------------------------
5740: -- If Process_Row didn't return any errors, make one ourselves --
5741: -----------------------------------------------------------------
5742: IF (x_msg_data IS NULL AND x_msg_count = 0) THEN
5743: ERROR_HANDLER.Add_Error_Message(
5744: p_message_name => 'EGO_EF_IMPLEMENT_ERR'
5745: ,p_application_id => 'EGO'
5746: ,p_message_type => FND_API.G_RET_STS_ERROR
5747: ,p_addto_fnd_stack => 'Y'

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

5749: END IF;
5750:
5751: -------------------------------------------------------------------
5752: -- If Process_Row had more than one error, return the first one --
5753: -- (or else return the one we just added to ERROR_HANDLER above) --
5754: -------------------------------------------------------------------
5755: IF (x_msg_data IS NULL AND x_msg_count > 0) THEN
5756: DECLARE
5757: message_list ERROR_HANDLER.Error_Tbl_Type;

Line 5757: message_list ERROR_HANDLER.Error_Tbl_Type;

5753: -- (or else return the one we just added to ERROR_HANDLER above) --
5754: -------------------------------------------------------------------
5755: IF (x_msg_data IS NULL AND x_msg_count > 0) THEN
5756: DECLARE
5757: message_list ERROR_HANDLER.Error_Tbl_Type;
5758: BEGIN
5759: ERROR_HANDLER.Get_Message_List(message_list);
5760: x_msg_data := message_list(message_list.FIRST).message_text;
5761: END;

Line 5759: ERROR_HANDLER.Get_Message_List(message_list);

5755: IF (x_msg_data IS NULL AND x_msg_count > 0) THEN
5756: DECLARE
5757: message_list ERROR_HANDLER.Error_Tbl_Type;
5758: BEGIN
5759: ERROR_HANDLER.Get_Message_List(message_list);
5760: x_msg_data := message_list(message_list.FIRST).message_text;
5761: END;
5762: END IF;
5763:

Line 5789: ERROR_HANDLER.Add_Error_Message(

5785: l_token_table(2).TOKEN_VALUE := l_api_name;
5786: l_token_table(3).TOKEN_NAME := 'SQL_ERR_MSG';
5787: l_token_table(3).TOKEN_VALUE := SQLERRM;
5788:
5789: ERROR_HANDLER.Add_Error_Message(
5790: p_message_name => 'EGO_PLSQL_ERR'
5791: ,p_application_id => 'EGO'
5792: ,p_token_tbl => l_token_table
5793: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 5797: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data

5793: ,p_message_type => FND_API.G_RET_STS_ERROR
5794: ,p_addto_fnd_stack => 'Y'
5795: );
5796:
5797: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
5798: ,x_entity_index => l_dummy_entity_index
5799: ,x_entity_id => l_dummy_entity_id
5800: ,x_message_type => l_dummy_message_type);
5801: END;

Line 6054: -- Close Error Handler Debug Session.

6050: );
6051:
6052:
6053: -----------------------------------------------------
6054: -- Close Error Handler Debug Session.
6055: -----------------------------------------------------
6056: -- Close debug session only explicitly open the debug session for
6057: -- this API.
6058: IF FND_API.to_Boolean(p_debug)

Line 6085: -- Close Error Handler Debug Session.

6081: p_data => x_msg_data
6082: );
6083:
6084: -----------------------------------------------------
6085: -- Close Error Handler Debug Session.
6086: -----------------------------------------------------
6087: -- Close debug session only explicitly open the debug session for
6088: -- this API.
6089: IF FND_API.to_Boolean(p_debug)

Line 6116: -- Close Error Handler Debug Session.

6112: p_data => x_msg_data
6113: );
6114:
6115: -----------------------------------------------------
6116: -- Close Error Handler Debug Session.
6117: -----------------------------------------------------
6118: -- Close debug session only explicitly open the debug session for
6119: -- this API.
6120: IF FND_API.to_Boolean(p_debug)

Line 6159: -- Close Error Handler Debug Session.

6155: p_data => x_msg_data
6156: );
6157:
6158: -----------------------------------------------------
6159: -- Close Error Handler Debug Session.
6160: -----------------------------------------------------
6161: -- Close debug session only explicitly open the debug session for
6162: -- this API.
6163: IF FND_API.to_Boolean(p_debug)