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

Line 49: --ERROR_HANDLER.Initialize();

45: BEGIN
46: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Entered into the procedure');
47: x_return_status := fnd_api.G_RET_STS_SUCCESS;
48: --Following commented statement is to initialize global message list, while testing/debugging this package standalone.
49: --ERROR_HANDLER.Initialize();
50: process_functions_conc_flow(p_set_process_id);
51: process_func_params_conc_flow(p_set_process_id);
52: --Following commented procedure call is to write errors to mtl_interfce_errors table,
53: --while testing/debugging this package standalone.

Line 54: --ERROR_HANDLER.Log_Error(

50: process_functions_conc_flow(p_set_process_id);
51: process_func_params_conc_flow(p_set_process_id);
52: --Following commented procedure call is to write errors to mtl_interfce_errors table,
53: --while testing/debugging this package standalone.
54: --ERROR_HANDLER.Log_Error(
55: -- p_write_err_to_inttable => 'Y'
56: -- ,p_write_err_to_conclog => 'Y');
57: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Exiting from the procedure');
58: EXCEPTION

Line 118: ERROR_HANDLER.Add_Error_Message(

114: AND func_header_rec.transaction_type <> G_SYNC_TRANSACTION)) THEN
115: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_header_rec.transaction_id ||
116: ': (FID, FNAME) = (' || func_header_rec.function_id ||
117: ', '|| func_header_rec.internal_name || '): Invalid Transaction Type.');
118: ERROR_HANDLER.Add_Error_Message(
119: p_message_name => 'EGO_TRANS_TYPE'
120: ,p_application_id => 'EGO'
121: ,p_message_type => FND_API.G_RET_STS_ERROR
122: ,p_row_identifier => func_header_rec.transaction_id

Line 153: ERROR_HANDLER.Add_Error_Message(

149: --Log_error('Invalid Function ID.');
150: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_header_rec.transaction_id ||
151: ': (FID, FNAME) = (' || func_header_rec.function_id ||
152: ', '|| func_header_rec.internal_name || '): Invalid Function ID.');
153: ERROR_HANDLER.Add_Error_Message(
154: p_message_name => 'EGO_EF_FUNC_ID_ERR'
155: ,p_application_id => 'EGO'
156: ,p_message_type => FND_API.G_RET_STS_ERROR
157: ,p_row_identifier => func_header_rec.transaction_id

Line 188: ERROR_HANDLER.Add_Error_Message(

184: --Log_error('Invalid Function Internal Name.');
185: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_header_rec.transaction_id ||
186: ': (FID, FNAME) = (' || func_header_rec.function_id ||
187: ', '|| func_header_rec.internal_name || '): Invalid Function Internal Name.');
188: ERROR_HANDLER.Add_Error_Message(
189: p_message_name => 'EGO_EF_FUNC_INT_NAME_INVL'
190: ,p_application_id => 'EGO'
191: ,p_message_type => FND_API.G_RET_STS_ERROR
192: ,p_row_identifier => func_header_rec.transaction_id

Line 208: ERROR_HANDLER.Add_Error_Message(

204: --Log_error('Either Function ID or Internal Name must be provided.');
205: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_header_rec.transaction_id ||
206: ': (FID, FNAME) = (' || func_header_rec.function_id ||
207: ', '|| func_header_rec.internal_name || '): Either Function ID or Internal Name must be provided.');
208: ERROR_HANDLER.Add_Error_Message(
209: p_message_name => 'EGO_EF_FUNC_ID_INT_NAME_ERR'
210: ,p_application_id => 'EGO'
211: ,p_message_type => FND_API.G_RET_STS_ERROR
212: ,p_row_identifier => func_header_rec.transaction_id

Line 239: l_token_table ERROR_HANDLER.Token_Tbl_Type;

235: function_is_used NUMBER(1);
236: error_count NUMBER;
237: l_proc_name VARCHAR2(30) := 'validate_function';
238:
239: l_token_table ERROR_HANDLER.Token_Tbl_Type;
240: BEGIN
241: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Entered into the procedure');
242: /* Validations for CREATE transaction type. */
243: IF ( func_header_rec.transaction_type = G_CREATE_TRANSACTION

Line 263: ERROR_HANDLER.Add_Error_Message(

259: --Log_error('Invalid Function Type.');
260: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_header_rec.transaction_id ||
261: ': (FID, FNAME) = (' || func_header_rec.function_id ||
262: ', '|| func_header_rec.internal_name || '): Invalid Function Type.');
263: ERROR_HANDLER.Add_Error_Message(
264: p_message_name => 'EGO_EF_FUNC_TYPE_ERR'
265: ,p_application_id => 'EGO'
266: ,p_message_type => FND_API.G_RET_STS_ERROR
267: ,p_row_identifier => func_header_rec.transaction_id

Line 287: ERROR_HANDLER.Add_Error_Message(

283: --Log_error('One of the mandatory columns is missed.');
284: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_header_rec.transaction_id ||
285: ': (FID, FNAME) = (' || func_header_rec.function_id ||
286: ', '|| func_header_rec.internal_name || '): One of the mandatory columns is missed.');
287: ERROR_HANDLER.Add_Error_Message(
288: p_message_name => 'EGO_EF_FUNC_REQ_COLS_ERR'
289: ,p_application_id => 'EGO'
290: ,p_message_type => FND_API.G_RET_STS_ERROR
291: ,p_row_identifier => func_header_rec.transaction_id

Line 314: ERROR_HANDLER.Add_Error_Message(

310: --Log_error('Duplicate Function Internal Name.');
311: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_header_rec.transaction_id ||
312: ': (FID, FNAME) = (' || func_header_rec.function_id ||
313: ', '|| func_header_rec.internal_name || '): Duplicate Function Internal Name.');
314: ERROR_HANDLER.Add_Error_Message(
315: p_message_name => 'EGO_EF_FUNC_INT_NAME_ERR'
316: ,p_application_id => 'EGO'
317: ,p_message_type => FND_API.G_RET_STS_ERROR
318: ,p_row_identifier => func_header_rec.transaction_id

Line 351: ERROR_HANDLER.Add_Error_Message(

347: --Log_error('Function Type can not be modified.');
348: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_header_rec.transaction_id ||
349: ': (FID, FNAME) = (' || func_header_rec.function_id ||
350: ', '|| func_header_rec.internal_name || '): Function Type can not be modified.');
351: ERROR_HANDLER.Add_Error_Message(
352: p_message_name => 'EGO_EF_FUNC_TYPE_UPD'
353: ,p_application_id => 'EGO'
354: ,p_message_type => FND_API.G_RET_STS_ERROR
355: ,p_row_identifier => func_header_rec.transaction_id

Line 398: ERROR_HANDLER.Add_Error_Message(

394: --Log_error('One of the mandatory columns is missed.');
395: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_header_rec.transaction_id ||
396: ': (FID, FNAME) = (' || func_header_rec.function_id ||
397: ', '|| func_header_rec.internal_name || '): One of the mandatory columns is missed.');
398: ERROR_HANDLER.Add_Error_Message(
399: p_message_name => 'EGO_EF_FUNC_REQ_COLS_ERR'
400: ,p_application_id => 'EGO'
401: ,p_message_type => FND_API.G_RET_STS_ERROR
402: ,p_row_identifier => func_header_rec.transaction_id

Line 444: ERROR_HANDLER.Add_Error_Message(

440: l_token_table(1).token_value := func_header_rec.internal_name;
441: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_header_rec.transaction_id ||
442: ': (FID, FNAME) = (' || func_header_rec.function_id ||
443: ', '|| func_header_rec.internal_name || '): Function is in use.');
444: ERROR_HANDLER.Add_Error_Message(
445: p_message_name => 'EGO_EF_FUNC_IN_USE'
446: ,p_application_id => 'EGO'
447: ,p_token_tbl => l_token_table
448: ,p_message_type => FND_API.G_RET_STS_ERROR

Line 610: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_ICC);

606: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Processing '
607: || ego_func_tbl_values.COUNT
608: || ' records');
609:
610: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_ICC);
611:
612: FOR i IN 1 .. ego_func_tbl_values.COUNT LOOP
613: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Processing (TID, TTYPE) = (' ||
614: Ego_func_tbl_values(i).transaction_id || ', ' || Ego_func_tbl_values(i).transaction_type ||

Line 996: ERROR_HANDLER.Add_Error_Message(

992: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
993: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
994: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
995: ', '||func_param_rec.internal_name||'): Invalid Transaction Type.');
996: ERROR_HANDLER.Add_Error_Message(
997: p_message_name => 'EGO_TRANS_TYPE'
998: ,p_application_id => 'EGO'
999: ,p_message_type => FND_API.G_RET_STS_ERROR
1000: ,p_row_identifier => func_param_rec.transaction_id

Line 1026: ERROR_HANDLER.Add_Error_Message(

1022: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
1023: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
1024: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
1025: ', '||func_param_rec.internal_name||'): Invalid Function ID.');
1026: ERROR_HANDLER.Add_Error_Message(
1027: p_message_name => 'EGO_EF_FUNC_ID_ERR'
1028: ,p_application_id => 'EGO'
1029: ,p_message_type => FND_API.G_RET_STS_ERROR
1030: ,p_row_identifier => func_param_rec.transaction_id

Line 1054: ERROR_HANDLER.Add_Error_Message(

1050: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
1051: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
1052: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
1053: ', '||func_param_rec.internal_name||'): Invalid Function Internal Name.');
1054: ERROR_HANDLER.Add_Error_Message(
1055: p_message_name => 'EGO_EF_FUNC_INT_NAME_INVL'
1056: ,p_application_id => 'EGO'
1057: ,p_message_type => FND_API.G_RET_STS_ERROR
1058: ,p_row_identifier => func_param_rec.transaction_id

Line 1070: ERROR_HANDLER.Add_Error_Message(

1066: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
1067: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
1068: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
1069: ', '||func_param_rec.internal_name||'): Either Function ID or Function Internal Name must be provided.');
1070: ERROR_HANDLER.Add_Error_Message(
1071: p_message_name => 'EGO_EF_FUNC_ID_INT_NAME_ERR'
1072: ,p_application_id => 'EGO'
1073: ,p_message_type => FND_API.G_RET_STS_ERROR
1074: ,p_row_identifier => func_param_rec.transaction_id

Line 1109: ERROR_HANDLER.Add_Error_Message(

1105: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
1106: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
1107: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
1108: ', '||func_param_rec.internal_name||'): Invalid Parameter ID for the given Function ID or Function Internal Name.');
1109: ERROR_HANDLER.Add_Error_Message(
1110: p_message_name => 'EGO_EF_FP_ID_ERR'
1111: ,p_application_id => 'EGO'
1112: ,p_message_type => FND_API.G_RET_STS_ERROR
1113: ,p_row_identifier => func_param_rec.transaction_id

Line 1146: ERROR_HANDLER.Add_Error_Message(

1142: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
1143: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
1144: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
1145: ', '||func_param_rec.internal_name||'): Invalid Parameter Internal Name for the given Function ID or Function Internal Name.');
1146: ERROR_HANDLER.Add_Error_Message(
1147: p_message_name => 'EGO_EF_FP_INT_NAME_INVL'
1148: ,p_application_id => 'EGO'
1149: ,p_message_type => FND_API.G_RET_STS_ERROR
1150: ,p_row_identifier => func_param_rec.transaction_id

Line 1167: ERROR_HANDLER.Add_Error_Message(

1163: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
1164: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
1165: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
1166: ', '||func_param_rec.internal_name||'): Either Parameter ID or Parameter Internal Name must be provided.');
1167: ERROR_HANDLER.Add_Error_Message(
1168: p_message_name => 'EGO_EF_FP_ID_INT_NAME_ERR'
1169: ,p_application_id => 'EGO'
1170: ,p_message_type => FND_API.G_RET_STS_ERROR
1171: ,p_row_identifier => func_param_rec.transaction_id

Line 1238: ERROR_HANDLER.Add_Error_Message(

1234: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
1235: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
1236: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
1237: ', '||func_param_rec.internal_name||'): Invalid Data Type.');
1238: ERROR_HANDLER.Add_Error_Message(
1239: p_message_name => 'EGO_PUB_INVALID_DATATYPE'
1240: ,p_application_id => 'EGO'
1241: ,p_message_type => FND_API.G_RET_STS_ERROR
1242: ,p_row_identifier => func_param_rec.transaction_id

Line 1280: ERROR_HANDLER.Add_Error_Message(

1276: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
1277: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
1278: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
1279: ', '||func_param_rec.internal_name||'): Invalid Parameter Type.');
1280: ERROR_HANDLER.Add_Error_Message(
1281: p_message_name => 'EGO_EF_PARAM_TYPE_ERR'
1282: ,p_application_id => 'EGO'
1283: ,p_message_type => FND_API.G_RET_STS_ERROR
1284: ,p_row_identifier => func_param_rec.transaction_id

Line 1310: ERROR_HANDLER.Add_Error_Message(

1306: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
1307: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
1308: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
1309: ', '||func_param_rec.internal_name||'): Duplicate Parameter Internal Name.');
1310: ERROR_HANDLER.Add_Error_Message(
1311: p_message_name => 'EGO_EF_FP_INT_NAME_ERR'
1312: ,p_application_id => 'EGO'
1313: ,p_message_type => FND_API.G_RET_STS_ERROR
1314: ,p_row_identifier => func_param_rec.transaction_id

Line 1339: ERROR_HANDLER.Add_Error_Message(

1335: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
1336: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
1337: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
1338: ', '||func_param_rec.internal_name||'): Duplicate Sequence.');
1339: ERROR_HANDLER.Add_Error_Message(
1340: p_message_name => 'EGO_EF_FP_DUPLICATE_SEQ_ERR'
1341: ,p_application_id => 'EGO'
1342: ,p_message_type => FND_API.G_RET_STS_ERROR
1343: ,p_row_identifier => func_param_rec.transaction_id

Line 1361: ERROR_HANDLER.Add_Error_Message(

1357: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
1358: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
1359: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
1360: ', '||func_param_rec.internal_name||'): Mandatory columns must be provided.');
1361: ERROR_HANDLER.Add_Error_Message(
1362: p_message_name => 'EGO_EF_FP_REQ_COLS_ERR'
1363: ,p_application_id => 'EGO'
1364: ,p_message_type => FND_API.G_RET_STS_ERROR
1365: ,p_row_identifier => func_param_rec.transaction_id

Line 1396: ERROR_HANDLER.Add_Error_Message(

1392: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
1393: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
1394: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
1395: ', '||func_param_rec.internal_name||'): Data Type can not be modified.');
1396: ERROR_HANDLER.Add_Error_Message(
1397: p_message_name => 'EGO_EF_DATA_TYPE_UPD'
1398: ,p_application_id => 'EGO'
1399: ,p_message_type => FND_API.G_RET_STS_ERROR
1400: ,p_row_identifier => func_param_rec.transaction_id

Line 1418: ERROR_HANDLER.Add_Error_Message(

1414: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
1415: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
1416: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
1417: ', '||func_param_rec.internal_name||'): Parameter Type can not be modified.');
1418: ERROR_HANDLER.Add_Error_Message(
1419: p_message_name => 'EGO_EF_PARAM_TYPE_UPD'
1420: ,p_application_id => 'EGO'
1421: ,p_message_type => FND_API.G_RET_STS_ERROR
1422: ,p_row_identifier => func_param_rec.transaction_id

Line 1457: ERROR_HANDLER.Add_Error_Message(

1453: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
1454: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
1455: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
1456: ', '||func_param_rec.internal_name||'): Duplicate Sequence.');
1457: ERROR_HANDLER.Add_Error_Message(
1458: p_message_name => 'EGO_EF_FP_DUPLICATE_SEQ_ERR'
1459: ,p_application_id => 'EGO'
1460: ,p_message_type => FND_API.G_RET_STS_ERROR
1461: ,p_row_identifier => func_param_rec.transaction_id

Line 1480: ERROR_HANDLER.Add_Error_Message(

1476: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'|| ' err_msg: TID = ' || func_param_rec.transaction_id ||
1477: ': (FID, FNAME, FPID, FPNAME) = (' || func_param_rec.function_id ||
1478: ', '|| func_param_rec.function_internal_name || ', '|| func_param_rec.func_param_id ||
1479: ', '||func_param_rec.internal_name||'): Mandatory columns must be provided.');
1480: ERROR_HANDLER.Add_Error_Message(
1481: p_message_name => 'EGO_EF_FP_REQ_COLS_ERR'
1482: ,p_application_id => 'EGO'
1483: ,p_message_type => FND_API.G_RET_STS_ERROR
1484: ,p_row_identifier => func_param_rec.transaction_id

Line 1642: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_ICC);

1638: IS
1639: l_proc_name VARCHAR2(30) := 'process_func_params';
1640: BEGIN
1641: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Entered into the procedure');
1642: ERROR_HANDLER.Set_Bo_Identifier(G_BO_IDENTIFIER_ICC);
1643:
1644: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Processing '
1645: || ego_func_param_tbl_values.COUNT
1646: || ' records');