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.FEM_PL_PKG dependencies on FEM_ENGINES_PKG

Line 81: FEM_ENGINES_PKG.TECH_MESSAGE(

77: p_caller_version_number => p_caller_api_version,
78: p_api_name => p_api_name,
79: p_pkg_name => p_api_name) THEN
80: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
81: FEM_ENGINES_PKG.TECH_MESSAGE(
82: p_severity => FND_LOG.level_unexpected,
83: p_module => C_MODULE,
84: p_msg_text => 'INTERNAL ERROR: API Version ('||p_current_api_version||') not compatible with '
85: ||'passed in version ('||p_caller_api_version||')');

Line 118: fem_engines_pkg.tech_message (

114:
115: v_sql := 'SELECT '||p_trans_col_name
116: ||' FROM '||p_vl_view_name
117: ||' WHERE '||p_id_col_name||' = :id';
118: fem_engines_pkg.tech_message (
119: p_severity => c_log_level_1,
120: p_module => 'fem.plsql.'||g_pkg_name||'.get_translated_name',
121: p_msg_text => 'v_sql: '||v_sql);
122:

Line 160: fem_engines_pkg.tech_message (

156: l_api_name CONSTANT VARCHAR2(30) := 'obj_def_data_edit_lock_exists';
157:
158: BEGIN
159:
160: fem_engines_pkg.tech_message (
161: p_severity => c_log_level_1,
162: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
163: p_msg_text => 'Begin. P_OBJECT_DEFINITION_ID:'||
164: p_object_definition_id);

Line 193: fem_engines_pkg.tech_message (

189: ELSE
190: x_data_edit_lock_exists := 'F';
191: END IF;
192:
193: fem_engines_pkg.tech_message (
194: p_severity => c_log_level_1,
195: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
196: p_msg_text => 'End. X_DATA_EDIT_LOCK_EXISTS:'||
197: x_data_edit_lock_exists);

Line 239: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

235:
236: BEGIN
237:
238: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
239: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
240: p_module => C_MODULE,
241: p_msg_text => 'Begin. P_OBJECT_DEFINITION_ID:'
242: ||p_object_definition_id||' P_NEW_EFFECTIVE_START_DATE:'
243: ||fnd_date.date_to_displaydate(p_new_effective_start_date)

Line 270: fem_engines_pkg.put_message(

266: p_trans_col_name => 'DISPLAY_NAME',
267: p_id_col_name => 'OBJECT_DEFINITION_ID',
268: p_id_value => p_object_definition_id,
269: x_trans_name => v_obj_def_name);
270: fem_engines_pkg.put_message(
271: p_app_name => 'FEM',
272: p_msg_name =>'FEM_PL_EFFDT_OUTSIDE_RSLTS_ERR',
273: p_token1 => 'OBJ_DEF_NAME',
274: p_value1 => v_obj_def_name,

Line 289: fem_engines_pkg.tech_message(

285: x_date_incl_rslt_data := 'T';
286: END IF;
287:
288: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
289: fem_engines_pkg.tech_message(
290: p_severity => c_log_level_1,
291: p_module => C_MODULE,
292: p_msg_text => 'End. X_DATE_INCL_RSLT_DATA:'||
293: x_date_incl_rslt_data);

Line 312: FEM_ENGINES_PKG.TECH_MESSAGE(

308:
309: EXCEPTION
310: WHEN others THEN
311: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
312: FEM_ENGINES_PKG.TECH_MESSAGE(
313: p_severity => FND_LOG.level_statement,
314: p_module => C_MODULE,
315: p_msg_text => 'Unexpected error.');
316: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 316: FEM_ENGINES_PKG.TECH_MESSAGE(

312: FEM_ENGINES_PKG.TECH_MESSAGE(
313: p_severity => FND_LOG.level_statement,
314: p_module => C_MODULE,
315: p_msg_text => 'Unexpected error.');
316: FEM_ENGINES_PKG.TECH_MESSAGE(
317: p_severity => FND_LOG.level_statement,
318: p_module => C_MODULE,
319: p_msg_text => SQLERRM);
320: END IF;

Line 365: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

361: l_api_name CONSTANT VARCHAR2(30) := 'obj_def_approval_lock_exists';
362:
363: BEGIN
364:
365: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
366: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
367: p_msg_text => 'Begin. P_OBJECT_DEFINITION_ID:'||p_object_definition_id);
368:
369: SELECT COUNT(*) INTO v_count

Line 380: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

376: ELSE
377: x_approval_edit_lock_exists := 'F';
378: END IF;
379:
380: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
381: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
382: p_msg_text => 'End. X_APPROVAL_EDIT_LOCK_EXISTS:'||
383: x_approval_edit_lock_exists);
384:

Line 401: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

397: l_api_name CONSTANT VARCHAR2(30) := 'get_object_def_edit_locks';
398:
399: BEGIN
400:
401: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
402: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
403: p_msg_text => 'Begin. P_OBJECT_DEFINITION_ID:'||p_object_definition_id);
404:
405: obj_def_approval_lock_exists(p_object_definition_id, x_approval_edit_lock_exists);

Line 408: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

404:
405: obj_def_approval_lock_exists(p_object_definition_id, x_approval_edit_lock_exists);
406: obj_def_data_edit_lock_exists(p_object_definition_id, x_data_edit_lock_exists);
407:
408: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
409: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
410: p_msg_text => 'End. X_APPROVAL_EDIT_LOCK_EXISTS:'||
411: x_approval_edit_lock_exists||' X_DATA_EDIT_LOCK_EXISTS:'||x_data_edit_lock_exists);
412:

Line 476: fem_engines_pkg.tech_message (

472:
473: BEGIN
474:
475: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
476: fem_engines_pkg.tech_message (
477: p_severity => c_log_level_1,
478: p_module => C_MODULE,
479: p_msg_text => 'Begin. P_OBJECT_DEFINITION_ID:'||
480: p_object_definition_id||' P_PROCESS_TYPE:'||p_process_type);

Line 500: fem_engines_pkg.tech_message(

496: -- If no_data_found, then the version does not exist
497: -- and is safe to delete. Skip all other checks and exit procedure.
498: WHEN no_data_found THEN
499: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
500: fem_engines_pkg.tech_message(
501: p_severity => c_log_level_2,
502: p_module => C_MODULE,
503: p_msg_text => 'No data found for object definition. '||
504: 'OBJECT_DEFINITION_ID:'||p_object_definition_id);

Line 563: fem_engines_pkg.tech_message(

559: p_count => x_msg_count,
560: p_data => x_msg_data);
561:
562: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
563: fem_engines_pkg.tech_message(
564: p_severity => c_log_level_1,
565: p_module => C_MODULE,
566: p_msg_text => 'End. X_CAN_DELETE_OBJ_DEF:'||x_can_delete_obj_def);
567: END IF;

Line 579: fem_engines_pkg.put_message(

575: p_trans_col_name => 'DISPLAY_NAME',
576: p_id_col_name => 'OBJECT_DEFINITION_ID',
577: p_id_value => p_object_definition_id,
578: x_trans_name => v_obj_def_name);
579: fem_engines_pkg.put_message(
580: p_app_name => 'FEM',
581: p_msg_name => 'FEM_PL_CANNOT_DEL_SEEDED_DEF',
582: p_token1 => 'OBJECT_DEF_NAME',
583: p_value1 => v_obj_def_name);

Line 599: fem_engines_pkg.put_message(

595: p_trans_col_name => 'DISPLAY_NAME',
596: p_id_col_name => 'OBJECT_DEFINITION_ID',
597: p_id_value => p_object_definition_id,
598: x_trans_name => v_obj_def_name);
599: fem_engines_pkg.put_message(
600: p_app_name => 'FEM',
601: p_msg_name =>'FEM_PL_DATA_LOCKED_DEF_ERR',
602: p_token1 => 'OBJECT_DEF_NAME',
603: p_value1 => v_obj_def_name);

Line 623: fem_engines_pkg.put_message(

619: p_trans_col_name => 'DISPLAY_NAME',
620: p_id_col_name => 'OBJECT_DEFINITION_ID',
621: p_id_value => p_object_definition_id,
622: x_trans_name => v_obj_def_name);
623: fem_engines_pkg.put_message(
624: p_app_name => 'FEM',
625: p_msg_name => 'FEM_PL_CANNOT_DEL_LAST_DEF',
626: p_token1 => 'OBJECT_DEF_NAME',
627: p_value1 => v_obj_def_name,

Line 643: fem_engines_pkg.put_message(

639: p_trans_col_name => 'DISPLAY_NAME',
640: p_id_col_name => 'OBJECT_DEFINITION_ID',
641: p_id_value => p_object_definition_id,
642: x_trans_name => v_obj_def_name);
643: fem_engines_pkg.put_message(
644: p_app_name => 'FEM',
645: p_msg_name =>'FEM_PL_SUBMITTED_DEF_ERR',
646: p_token1 => 'OBJECT_DEF_NAME',
647: p_value1 => v_obj_def_name);

Line 656: FEM_ENGINES_PKG.TECH_MESSAGE(

652: x_return_status := g_ret_sts_error;
653:
654: WHEN others THEN
655: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
656: FEM_ENGINES_PKG.TECH_MESSAGE(
657: p_severity => FND_LOG.level_statement,
658: p_module => C_MODULE,
659: p_msg_text => 'Unexpected error.');
660: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 660: FEM_ENGINES_PKG.TECH_MESSAGE(

656: FEM_ENGINES_PKG.TECH_MESSAGE(
657: p_severity => FND_LOG.level_statement,
658: p_module => C_MODULE,
659: p_msg_text => 'Unexpected error.');
660: FEM_ENGINES_PKG.TECH_MESSAGE(
661: p_severity => FND_LOG.level_statement,
662: p_module => C_MODULE,
663: p_msg_text => SQLERRM);
664: END IF;

Line 758: fem_engines_pkg.tech_message(

754:
755: BEGIN
756:
757: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
758: fem_engines_pkg.tech_message(
759: p_severity => c_log_level_1,
760: p_module => C_MODULE,
761: p_msg_text => 'Begin. P_OBJECT_ID:'||
762: p_object_id||' P_PROCESS_TYPE:'||p_process_type);

Line 824: fem_engines_pkg.tech_message(

820: x_can_delete_obj := 'T';
821: x_return_status := g_ret_sts_success;
822:
823: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
824: fem_engines_pkg.tech_message(
825: p_severity => c_log_level_1,
826: p_module => C_MODULE,
827: p_msg_text => 'End. X_CAN_DELETE_OBJ:'||x_can_delete_obj);
828: END IF;

Line 844: fem_engines_pkg.put_message(

840: p_trans_col_name => 'DISPLAY_NAME',
841: p_id_col_name => 'OBJECT_DEFINITION_ID',
842: p_id_value => v_obj_def_id,
843: x_trans_name => v_obj_def_name);
844: fem_engines_pkg.put_message(
845: p_app_name => 'FEM',
846: p_msg_name => 'FEM_PL_CANNOT_DELETE_DEF_ERR',
847: p_token1 => 'OBJECT_NAME',
848: p_value1 => v_obj_name,

Line 866: fem_engines_pkg.put_message(

862: p_trans_col_name => 'OBJECT_NAME',
863: p_id_col_name => 'OBJECT_ID',
864: p_id_value => p_object_id,
865: x_trans_name => v_obj_name);
866: fem_engines_pkg.put_message(
867: p_app_name => 'FEM',
868: p_msg_name => 'FEM_PL_CANNOT_DEL_SEEDED_OBJ',
869: p_token1 => 'OBJECT_NAME',
870: p_value1 => v_obj_name,

Line 898: fem_engines_pkg.put_message(

894: FROM fem_object_catalog_vl c, fem_object_definition_b d
895: WHERE c.object_id = d.object_id
896: AND d.object_definition_id = v_obj_def_id;
897:
898: fem_engines_pkg.put_message(
899: p_app_name => 'FEM',
900: p_msg_name => 'FEM_PL_REFERENCED_OBJ_ERR',
901: p_token1 => 'OBJECT_NAME',
902: p_value1 => v_obj_name,

Line 915: FEM_ENGINES_PKG.TECH_MESSAGE(

911: x_return_status := g_ret_sts_error;
912:
913: WHEN others THEN
914: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
915: FEM_ENGINES_PKG.TECH_MESSAGE(
916: p_severity => FND_LOG.level_statement,
917: p_module => C_MODULE,
918: p_msg_text => 'Unexpected error.');
919: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 919: FEM_ENGINES_PKG.TECH_MESSAGE(

915: FEM_ENGINES_PKG.TECH_MESSAGE(
916: p_severity => FND_LOG.level_statement,
917: p_module => C_MODULE,
918: p_msg_text => 'Unexpected error.');
919: FEM_ENGINES_PKG.TECH_MESSAGE(
920: p_severity => FND_LOG.level_statement,
921: p_module => C_MODULE,
922: p_msg_text => SQLERRM);
923: END IF;

Line 983: -- Fem_engines_pkg.put_message (FEM_PL_SUBMITTED_DEF_ERR).

979: -- ==========================================================================
980: -- BEGIN obj_execution_lock_exists
981: -- IF an approval edit lock exists for the object definition to be executed THEN
982: -- Return T;
983: -- Fem_engines_pkg.put_message (FEM_PL_SUBMITTED_DEF_ERR).
984: -- ELSIF object_type IN ('XGL_INTEGRATION', 'OGL_INTG_BAL_RULE',
985: -- 'SOURCE_DATA_LOADER', EGL_INTG_BAL_RULE') THEN
986: -- Call specialized procedure (FEM_PL_INCR_PKG.Obj_Exec_Lock_Exists)
987: -- ELSIF object_type IN ('DIM_MEMBER_LOADER',

Line 1031: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1027: l_api_name CONSTANT VARCHAR2(30) := 'obj_execution_lock_exists';
1028:
1029: BEGIN
1030:
1031: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1032: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1033: p_msg_text => 'Begin. P_OBJECT_ID:'||p_object_id||
1034: ' P_LEDGER_ID:'||p_ledger_id||' P_CAL_PERIOD_ID:'||p_cal_period_id||
1035: ' P_OUTPUT_DATASET_CODE:'||p_output_dataset_code||

Line 1057: fem_engines_pkg.put_message(p_app_name =>'FEM',p_msg_name =>'FEM_PL_SUBMITTED_DEF_ERR',

1053: AND o.object_type_code = t.object_type_code;
1054:
1055: IF v_approval_edit_lock_exists = 'T' THEN
1056: x_exec_lock_exists := 'T';
1057: fem_engines_pkg.put_message(p_app_name =>'FEM',p_msg_name =>'FEM_PL_SUBMITTED_DEF_ERR',
1058: p_token1 => 'OBJECT_DEFINITION_ID', p_value1 => p_exec_object_definition_id, p_trans1 => 'N');
1059:
1060: ELSIF v_object_type_code IN ('OGL_INTG_BAL_RULE','XGL_INTEGRATION',
1061: 'SOURCE_DATA_LOADER','EGL_INTG_BAL_RULE') THEN

Line 1198: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1194: x_exec_lock_exists := 'F';
1195:
1196: END IF;
1197:
1198: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1199: p_module => 'fem.plsql.'||g_pkg_name||'.obj_execution_lock_exists',
1200: p_msg_text => 'End. Object execution lock exists:'||x_exec_lock_exists||
1201: '; Execution state:'||x_exec_state||' X_PREV_REQUEST_ID:'||x_prev_request_id);
1202:

Line 1284: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1280: AND r.hierarchy_name = v_hierarchy_name;
1281:
1282: BEGIN
1283:
1284: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1285: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1286: p_msg_text => 'Begin. P_USER_ID:'||p_user_id||
1287: ' P_REQUEST_ID:'||p_request_id||' P_OBJECT_ID:'||p_object_id||
1288: ' P_EXEC_OBJECT_DEFINITION_ID:'||p_exec_object_definition_id);

Line 1323: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1319:
1320: -- Acquire table lock
1321: LOCK TABLE fem_pl_object_executions IN EXCLUSIVE MODE;
1322:
1323: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1324: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1325: p_msg_text => 'Table FEM_PL_OBJECT_EXECUTIONS locked in exclusive mode.');
1326:
1327: obj_execution_lock_exists (

Line 1348: fem_engines_pkg.put_message(p_app_name =>'FEM',

1344: IF v_obj_execution_lock_exists = 'T' THEN
1345:
1346: ROLLBACK TO register_object_execution_pub;
1347:
1348: fem_engines_pkg.put_message(p_app_name =>'FEM',
1349: p_msg_name =>'FEM_PL_OBJ_EXECLOCK_EXISTS_ERR');
1350:
1351: fem_engines_pkg.tech_message(p_severity => c_log_level_4,
1352: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,

Line 1351: fem_engines_pkg.tech_message(p_severity => c_log_level_4,

1347:
1348: fem_engines_pkg.put_message(p_app_name =>'FEM',
1349: p_msg_name =>'FEM_PL_OBJ_EXECLOCK_EXISTS_ERR');
1350:
1351: fem_engines_pkg.tech_message(p_severity => c_log_level_4,
1352: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1353: p_msg_name =>'FEM_PL_OBJ_EXECLOCK_EXISTS_ERR');
1354:
1355: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

Line 1355: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1351: fem_engines_pkg.tech_message(p_severity => c_log_level_4,
1352: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1353: p_msg_name =>'FEM_PL_OBJ_EXECLOCK_EXISTS_ERR');
1354:
1355: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1356: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1357: p_msg_text => 'Released exclusive lock on FEM_PL_OBJECT_EXECUTIONS .');
1358:
1359: x_return_status := g_ret_sts_error;

Line 1433: fem_engines_pkg.tech_message(p_severity => c_log_level_3,

1429: x_return_status => x_return_status);
1430:
1431: IF x_return_status = g_ret_sts_success THEN
1432: COMMIT WORK;
1433: fem_engines_pkg.tech_message(p_severity => c_log_level_3,
1434: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1435: p_msg_text => 'Registered object execution. REQUEST_ID:'||p_request_id||' OBJECT_ID:'||p_object_id);
1436:
1437: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

Line 1437: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1433: fem_engines_pkg.tech_message(p_severity => c_log_level_3,
1434: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1435: p_msg_text => 'Registered object execution. REQUEST_ID:'||p_request_id||' OBJECT_ID:'||p_object_id);
1436:
1437: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1438: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1439: p_msg_text => 'Released exclusive lock on FEM_PL_OBJECT_EXECUTIONS.');
1440:
1441: ELSE

Line 1445: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',

1441: ELSE
1442: -- If cannot acquire an edit lock for the object, then rollback and return a failure status.
1443:
1444: ROLLBACK TO register_object_execution_pub;
1445: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
1446: p_msg_name => 'FEM_PL_REG_OBJ_DEF_ERR');
1447:
1448: fem_engines_pkg.tech_message(p_severity => c_log_level_5,
1449: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,

Line 1448: fem_engines_pkg.tech_message(p_severity => c_log_level_5,

1444: ROLLBACK TO register_object_execution_pub;
1445: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
1446: p_msg_name => 'FEM_PL_REG_OBJ_DEF_ERR');
1447:
1448: fem_engines_pkg.tech_message(p_severity => c_log_level_5,
1449: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1450: p_msg_name =>'FEM_PL_REG_OBJ_DEF_ERR');
1451:
1452: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

Line 1452: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1448: fem_engines_pkg.tech_message(p_severity => c_log_level_5,
1449: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1450: p_msg_name =>'FEM_PL_REG_OBJ_DEF_ERR');
1451:
1452: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1453: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1454: p_msg_text => 'Released exclusive lock on FEM_PL_OBJECT_EXECUTIONS.');
1455:
1456: x_return_status := g_ret_sts_error;

Line 1467: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1463: FND_MSG_PUB.Count_And_Get
1464: (p_count => x_msg_count,
1465: p_data => x_msg_data);
1466:
1467: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1468: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1469: p_msg_text => 'End. X_RETURN_STATUS:'||x_return_status);
1470:
1471: EXCEPTION

Line 1474: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1470:
1471: EXCEPTION
1472: WHEN DUP_VAL_ON_INDEX THEN
1473: ROLLBACK TO register_object_execution_pub;
1474: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1475: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1476: p_msg_text => 'Released exclusive lock on FEM_PL_OBJECT_EXECUTIONS .');
1477:
1478: fem_engines_pkg.tech_message(p_severity => c_log_level_3,

Line 1478: fem_engines_pkg.tech_message(p_severity => c_log_level_3,

1474: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1475: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1476: p_msg_text => 'Released exclusive lock on FEM_PL_OBJECT_EXECUTIONS .');
1477:
1478: fem_engines_pkg.tech_message(p_severity => c_log_level_3,
1479: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1480: p_msg_text => 'End. Object execution already registered. X_RETURN_STATUS:'||x_return_status);
1481:
1482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1486: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1483: ROLLBACK TO register_object_execution_pub;
1484: x_return_status := g_ret_sts_unexp_error;
1485:
1486: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1487: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1488: p_msg_text => 'Released exclusive lock on FEM_PL_OBJECT_EXECUTIONS.');
1489:
1490: fem_engines_pkg.tech_message(p_severity => c_log_level_6,

Line 1490: fem_engines_pkg.tech_message(p_severity => c_log_level_6,

1486: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1487: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1488: p_msg_text => 'Released exclusive lock on FEM_PL_OBJECT_EXECUTIONS.');
1489:
1490: fem_engines_pkg.tech_message(p_severity => c_log_level_6,
1491: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1492: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
1493: l_api_name||' version: '||l_api_version);
1494:

Line 1504: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1500: -- Unexpected exceptions
1501: ROLLBACK TO register_object_execution_pub;
1502: x_return_status := g_ret_sts_unexp_error;
1503:
1504: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1505: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1506: p_msg_text => 'Released exclusive lock on FEM_PL_OBJECT_EXECUTIONS.');
1507:
1508: -- Log the call stack and the Oracle error message to

Line 1511: FEM_ENGINES_PKG.Tech_Message

1507:
1508: -- Log the call stack and the Oracle error message to
1509: -- FND_LOG with the "unexpected exception" severity level.
1510:
1511: FEM_ENGINES_PKG.Tech_Message
1512: (p_severity => c_log_level_6,
1513: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1514: p_msg_text => SQLERRM);
1515:

Line 1516: FEM_ENGINES_PKG.Tech_Message

1512: (p_severity => c_log_level_6,
1513: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1514: p_msg_text => SQLERRM);
1515:
1516: FEM_ENGINES_PKG.Tech_Message
1517: (p_severity => c_log_level_6,
1518: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1519: p_msg_text => dbms_utility.format_call_stack);
1520:

Line 1522: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',

1518: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1519: p_msg_text => dbms_utility.format_call_stack);
1520:
1521: -- Log the Oracle error message to the stack.
1522: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
1523: p_msg_name => 'FEM_UNEXPECTED_ERROR',
1524: P_TOKEN1 => 'ERR_MSG',
1525: P_VALUE1 => SQLERRM);
1526:

Line 1572: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1568: l_api_version CONSTANT NUMBER := 1.0;
1569:
1570: BEGIN
1571:
1572: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1573: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1574: p_msg_text => 'Begin. REQUEST_ID:'||p_request_id||
1575: ' P_RULE_SET_OBJ_DEF_ID:'||p_rule_set_obj_def_id||
1576: ' P_RULE_SET_NAME:'||p_rule_set_name||

Line 1619: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1615: IF FND_API.To_Boolean( p_commit ) THEN
1616: COMMIT WORK;
1617: END IF;
1618:
1619: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1620: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1621: p_msg_text => 'End. Registered request. X_RETURN_STATUS:'||x_return_status);
1622:
1623: -- Standard call to get message count and if count is 1, get message info.

Line 1638: fem_engines_pkg.tech_message(p_severity => c_log_level_3,

1634: ELSE
1635: ROLLBACK TO register_request_pub;
1636: END IF;
1637:
1638: fem_engines_pkg.tech_message(p_severity => c_log_level_3,
1639: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1640: p_msg_text => 'End. Request already registered. X_RETURN_STATUS:'||x_return_status);
1641:
1642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1646: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

1642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1643: ROLLBACK TO register_request_pub;
1644: x_return_status := g_ret_sts_unexp_error;
1645:
1646: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
1647: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1648: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
1649: l_api_name||' version: '||l_api_version);
1650:

Line 1680: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1676: l_api_version CONSTANT NUMBER := 1.0;
1677:
1678: BEGIN
1679:
1680: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1681: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1682: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
1683: ' P_COMMIT:'||p_commit);
1684:

Line 1707: fem_engines_pkg.tech_message(p_severity => c_log_level_3,

1703:
1704: IF v_count = 0 THEN
1705: DELETE fem_pl_requests WHERE request_id = p_request_id;
1706: ELSE
1707: fem_engines_pkg.tech_message(p_severity => c_log_level_3,
1708: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1709: p_msg_text => 'Cannot unregister REQUEST_ID: '||p_request_id||
1710: ' Data exists for request in FEM_PL_OBJECT_EXECUTIONS');
1711:

Line 1720: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1716: IF FND_API.To_Boolean( p_commit ) THEN
1717: COMMIT WORK;
1718: END IF;
1719:
1720: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1721: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1722: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
1723:
1724: EXCEPTION

Line 1729: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

1725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1726: ROLLBACK TO unregister_request_pub;
1727: x_return_status := g_ret_sts_unexp_error;
1728:
1729: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
1730: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1731: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
1732: l_api_name||' version: '||l_api_version);
1733:

Line 1751: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1747: l_api_version CONSTANT NUMBER := 1.0;
1748:
1749: BEGIN
1750:
1751: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1752: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1753: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
1754: ' P_COMMIT:'||p_commit||' P_EXEC_STATUS_CODE:'||p_exec_status_code);
1755:

Line 1780: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1776: IF FND_API.To_Boolean( p_commit ) THEN
1777: COMMIT WORK;
1778: END IF;
1779:
1780: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1781: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1782: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
1783:
1784: EXCEPTION

Line 1789: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

1785: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1786: ROLLBACK TO update_request_status_pub;
1787: x_return_status := g_ret_sts_unexp_error;
1788:
1789: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
1790: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1791: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
1792: l_api_name||' version: '||l_api_version);
1793:

Line 1812: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1808: l_api_version CONSTANT NUMBER := 1.0;
1809:
1810: BEGIN
1811:
1812: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1813: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1814: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
1815: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
1816: ' P_EXEC_STATUS_CODE:'||p_exec_status_code);

Line 1843: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1839: IF FND_API.To_Boolean( p_commit ) THEN
1840: COMMIT WORK;
1841: END IF;
1842:
1843: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1844: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1845: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
1846:
1847: EXCEPTION

Line 1852: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

1848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1849: ROLLBACK TO update_obj_exec_status_pub;
1850: x_return_status := g_ret_sts_unexp_error;
1851:
1852: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
1853: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1854: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
1855: l_api_name||' version: '||l_api_version);
1856:

Line 1876: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1872: l_api_version CONSTANT NUMBER := 1.0;
1873:
1874: BEGIN
1875:
1876: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1877: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1878: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
1879: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
1880: ' P_ERRORS_REPORTED:'||p_errors_reported||

Line 1910: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1906: IF FND_API.To_Boolean( p_commit ) THEN
1907: COMMIT WORK;
1908: END IF;
1909:
1910: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1911: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1912: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
1913:
1914: EXCEPTION

Line 1919: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

1915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1916: ROLLBACK TO update_obj_exec_errors_pub;
1917: x_return_status := g_ret_sts_unexp_error;
1918:
1919: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
1920: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1921: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
1922: l_api_name||' version: '||l_api_version);
1923:

Line 1942: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1938: l_api_version CONSTANT NUMBER := 1.0;
1939:
1940: BEGIN
1941:
1942: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1943: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1944: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
1945: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
1946: ' P_OBJECT_DEFINITION_ID:'||p_object_definition_id);

Line 1977: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

1973: IF FND_API.To_Boolean( p_commit ) THEN
1974: COMMIT WORK;
1975: END IF;
1976:
1977: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
1978: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1979: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
1980:
1981: EXCEPTION

Line 1989: fem_engines_pkg.tech_message(p_severity => c_log_level_3,

1985: COMMIT WORK;
1986: ELSE
1987: ROLLBACK TO register_object_def_pub;
1988: END IF;
1989: fem_engines_pkg.tech_message(p_severity => c_log_level_3,
1990: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1991: p_msg_text => 'End. Object definition already registered. X_RETURN_STATUS: '||x_return_status);
1992:
1993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1997: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

1993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1994: ROLLBACK TO register_object_def_pub;
1995: x_return_status := g_ret_sts_unexp_error;
1996:
1997: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
1998: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
1999: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
2000: l_api_name||' version: '||l_api_version);
2001:

Line 2042: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2038: CONNECT BY PRIOR B.object_definition_id = D.object_definition_id;
2039:
2040: BEGIN
2041:
2042: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2043: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2044: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
2045: ' P_OBJECT_ID:'||p_object_id||
2046: ' P_EFFECTIVE_DATE:'||fnd_date.date_to_displaydate(p_effective_date)||

Line 2095: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2091: IF FND_API.To_Boolean( p_commit ) THEN
2092: COMMIT WORK;
2093: END IF;
2094:
2095: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2096: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2097: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
2098:
2099: EXCEPTION

Line 2103: fem_engines_pkg.tech_message(p_severity => c_log_level_5,

2099: EXCEPTION
2100: WHEN NO_DATA_FOUND THEN
2101: ROLLBACK TO register_dependent_objdefs_pub;
2102: x_return_status := g_ret_sts_error;
2103: fem_engines_pkg.tech_message(p_severity => c_log_level_5,
2104: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2105: p_msg_name => 'FEM_PL_NO_DEP_OBJ_DEF_ERR',
2106: p_token1 => 'OBJECT_ID',
2107: p_value1 => p_object_id,

Line 2110: fem_engines_pkg.put_message(

2106: p_token1 => 'OBJECT_ID',
2107: p_value1 => p_object_id,
2108: p_trans1 => 'N');
2109:
2110: fem_engines_pkg.put_message(
2111: p_app_name => 'FEM',
2112: p_msg_name => 'FEM_PL_NO_DEP_OBJ_DEF_ERR',
2113: p_token1 => 'OBJECT_ID',
2114: p_value1 => p_object_id,

Line 2125: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2122: ROLLBACK TO register_dependent_objdefs_pub;
2123: x_return_status := g_ret_sts_unexp_error;
2124:
2125: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2126: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2127: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
2128: l_api_name||' version: '||l_api_version);
2129:

Line 2150: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2146: l_api_version CONSTANT NUMBER := 1.0;
2147:
2148: BEGIN
2149:
2150: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2151: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2152: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
2153: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
2154: ' P_TABLE_NAME:'||p_table_name||

Line 2188: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2184: IF FND_API.To_Boolean( p_commit ) THEN
2185: COMMIT WORK;
2186: END IF;
2187:
2188: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2189: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2190: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
2191:
2192: EXCEPTION

Line 2200: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2196: COMMIT WORK;
2197: ELSE
2198: ROLLBACK TO register_table_pub;
2199: END IF;
2200: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2201: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2202: p_msg_text => 'End. Table already registered. X_RETURN_STATUS: '||x_return_status);
2203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2204: ROLLBACK TO register_table_pub;

Line 2207: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2204: ROLLBACK TO register_table_pub;
2205: x_return_status := g_ret_sts_unexp_error;
2206:
2207: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2208: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2209: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
2210: l_api_name||' version: '||l_api_version);
2211:

Line 2234: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2230: v_object_type_code FEM_OBJECT_TYPES.object_type_code%TYPE;
2231:
2232: BEGIN
2233:
2234: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2235: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2236: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
2237: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
2238: ' P_TABLE_NAME:'||p_table_name||

Line 2331: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2327:
2328: -- Update API return status to success
2329: x_return_status := G_RET_STS_SUCCESS;
2330:
2331: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2332: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2333: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
2334:
2335: EXCEPTION

Line 2340: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2337: ROLLBACK TO update_num_of_output_rows_pub;
2338: x_return_status := g_ret_sts_unexp_error;
2339:
2340: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2341: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2342: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
2343: l_api_name||' version: '||l_api_version);
2344:

Line 2365: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2361: l_api_version CONSTANT NUMBER := 1.0;
2362:
2363: BEGIN
2364:
2365: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2366: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2367: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
2368: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
2369: ' P_TABLE_NAME:'||p_table_name||

Line 2406: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2402: IF FND_API.To_Boolean( p_commit ) THEN
2403: COMMIT WORK;
2404: END IF;
2405:
2406: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2407: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2408: p_msg_text => 'End. X_RETURN_STATUS:'||x_return_status);
2409:
2410: EXCEPTION

Line 2418: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2414: COMMIT WORK;
2415: ELSE
2416: ROLLBACK TO register_updated_column_pub;
2417: END IF;
2418: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2419: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2420: p_msg_text => 'End. Updated column already registered. X_RETURN_STATUS:'||x_return_status);
2421:
2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2426: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2423: ROLLBACK TO register_updated_column_pub;
2424: x_return_status := g_ret_sts_unexp_error;
2425:
2426: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2427: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2428: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
2429: l_api_name||' version: '||l_api_version);
2430:

Line 2450: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2446: l_api_version CONSTANT NUMBER := 1.0;
2447:
2448: BEGIN
2449:
2450: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2451: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2452: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
2453: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
2454: ' P_SOURCE_CREATED_BY_REQUEST_ID:'||p_source_created_by_request_id||

Line 2488: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2484: IF FND_API.To_Boolean( p_commit ) THEN
2485: COMMIT WORK;
2486: END IF;
2487:
2488: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2489: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2490: p_msg_text => 'End. X_RETURN_STATUS:'||x_return_status);
2491:
2492: EXCEPTION

Line 2501: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2497: COMMIT WORK;
2498: ELSE
2499: ROLLBACK TO register_chain_pub;
2500: END IF;
2501: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2502: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2503: p_msg_text => 'End. Processing chain already registered. X_RETURN_STATUS:'||x_return_status);
2504:
2505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2509: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2506: ROLLBACK TO register_chain_pub;
2507: x_return_status := g_ret_sts_unexp_error;
2508:
2509: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2510: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2511: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
2512: l_api_name||' version: '||l_api_version);
2513:

Line 2533: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2529: l_api_version CONSTANT NUMBER := 1.0;
2530:
2531: BEGIN
2532:
2533: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2534: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2535: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
2536: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
2537: ' P_OBJECT_TYPE:'||p_object_type||

Line 2570: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2566: IF FND_API.To_Boolean( p_commit ) THEN
2567: COMMIT WORK;
2568: END IF;
2569:
2570: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2571: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2572: p_msg_text => 'End. X_RETURN_STATUS:'||x_return_status);
2573:
2574: EXCEPTION

Line 2583: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2579: ELSE
2580: ROLLBACK TO register_temp_object_pub;
2581: END IF;
2582:
2583: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2584: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2585: p_msg_text => 'End. Temporary object already registered. X_RETURN_STATUS:'||x_return_status);
2586:
2587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2591: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2588: ROLLBACK TO register_temp_object_pub;
2589: x_return_status := g_ret_sts_unexp_error;
2590:
2591: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2592: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2593: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
2594: l_api_name||' version: '||l_api_version);
2595:

Line 2614: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2610: l_api_version CONSTANT NUMBER := 1.0;
2611:
2612: BEGIN
2613:
2614: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2615: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2616: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
2617: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
2618: ' P_NUM_OF_INPUT_ROWS:'||p_num_of_input_rows);

Line 2645: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2641: IF FND_API.To_Boolean( p_commit ) THEN
2642: COMMIT WORK;
2643: END IF;
2644:
2645: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2646: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2647: p_msg_text => 'End. X_RETURN_STATUS:'||x_return_status);
2648:
2649: EXCEPTION

Line 2654: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2651: ROLLBACK TO update_num_of_input_rows_pub;
2652: x_return_status := g_ret_sts_unexp_error;
2653:
2654: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2655: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2656: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
2657: l_api_name||' version: '||l_api_version);
2658:

Line 2678: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2674: l_api_version CONSTANT NUMBER := 1.0;
2675:
2676: BEGIN
2677:
2678: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2679: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2680: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
2681: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
2682: ' P_EXEC_STEP:'||p_exec_step||

Line 2713: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2709: IF FND_API.To_Boolean( p_commit ) THEN
2710: COMMIT WORK;
2711: END IF;
2712:
2713: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2714: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2715: p_msg_text => 'End. X_RETURN_STATUS:'||x_return_status);
2716:
2717: EXCEPTION

Line 2726: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2722: COMMIT WORK;
2723: ELSE
2724: ROLLBACK TO register_obj_exec_step_pub;
2725: END IF;
2726: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2727: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2728: p_msg_text => 'End. Object execution step already registered. X_RETURN_STATUS:'||x_return_status);
2729:
2730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2734: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2731: ROLLBACK TO register_obj_exec_step_pub;
2732: x_return_status := g_ret_sts_unexp_error;
2733:
2734: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2735: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2736: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
2737: l_api_name||' version: '||l_api_version);
2738:

Line 2755: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2751: l_api_version CONSTANT NUMBER := 1.0;
2752:
2753: BEGIN
2754:
2755: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2756: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2757: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
2758: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
2759: ' P_EXEC_STEP:'||p_exec_step);

Line 2785: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2781: IF FND_API.To_Boolean( p_commit ) THEN
2782: COMMIT WORK;
2783: END IF;
2784:
2785: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2786: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2787: p_msg_text => 'End. X_RETURN_STATUS:'||x_return_status);
2788:
2789: EXCEPTION

Line 2794: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2791: ROLLBACK TO unregister_obj_exec_step_pub;
2792: x_return_status := g_ret_sts_unexp_error;
2793:
2794: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2795: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2796: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
2797: l_api_name||' version: '||l_api_version);
2798:

Line 2814: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2810: l_api_version CONSTANT NUMBER := 1.0;
2811:
2812: BEGIN
2813:
2814: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2815: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2816: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
2817: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit);
2818:

Line 2842: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2838: IF FND_API.To_Boolean( p_commit ) THEN
2839: COMMIT WORK;
2840: END IF;
2841:
2842: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2843: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2844: p_msg_text => 'End. X_RETURN_STATUS:'||x_return_status);
2845:
2846: EXCEPTION

Line 2851: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2848: ROLLBACK TO unregister_obj_exec_steps_pub;
2849: x_return_status := g_ret_sts_unexp_error;
2850:
2851: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2852: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2853: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
2854: l_api_name||' version: '||l_api_version);
2855:

Line 2875: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2871: l_api_version CONSTANT NUMBER := 1.0;
2872:
2873: BEGIN
2874:
2875: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2876: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2877: p_msg_text => 'Begin. REQUEST_ID: '||p_request_id||
2878: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit||
2879: ' P_EXEC_STEP:'||p_exec_step||

Line 2908: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2904: IF FND_API.To_Boolean( p_commit ) THEN
2905: COMMIT WORK;
2906: END IF;
2907:
2908: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2909: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2910: p_msg_text => 'End. X_RETURN_STATUS:'||x_return_status);
2911:
2912: EXCEPTION

Line 2917: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

2913: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2914: ROLLBACK TO update_obj_exec_step_statu_pub;
2915: x_return_status := g_ret_sts_unexp_error;
2916:
2917: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
2918: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2919: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
2920: l_api_name||' version: '||l_api_version);
2921:

Line 2950: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2946: v_error_status VARCHAR2(30);
2947:
2948: BEGIN
2949:
2950: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2951: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2952: p_msg_text => 'Begin. P_REQUEST_ID: '||p_request_id||
2953: ' P_OBJECT_ID:'||p_object_id||' P_COMMIT:'||p_commit);
2954:

Line 2997: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

2993:
2994: -- If call returned false and request is in 'RUNNING' state,
2995: -- set request to an error status
2996: IF (NOT v_call_status) THEN
2997: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
2998: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
2999: p_msg_text => 'Call to fnd_concurrent.get_request_status failed');
3000:
3001: UPDATE fem_pl_requests SET exec_status_code = v_error_status,

Line 3047: fem_engines_pkg.tech_message(p_severity => c_log_level_2

3043: IF FND_API.To_Boolean( p_commit ) THEN
3044: COMMIT WORK;
3045: END IF;
3046:
3047: fem_engines_pkg.tech_message(p_severity => c_log_level_2
3048: ,p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
3049: p_msg_text => 'End. Request Phase:'||v_drphase||
3050: ' Request Status:'||v_dstatus||' Always Rerunnable Flag: '||
3051: v_always_rerunnable_flag||' X_RETURN_STATUS:'||x_return_status);

Line 3058: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

3054: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3055: ROLLBACK TO set_exec_state_pub;
3056: x_return_status := g_ret_sts_unexp_error;
3057:
3058: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
3059: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
3060: p_msg_text => 'Incompatible API call made to '||g_pkg_name||'.'||
3061: l_api_name||' version: '||l_api_version);
3062:

Line 3125: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

3121:
3122:
3123: BEGIN
3124:
3125: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
3126: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
3127: p_msg_text => 'Begin. P_CALLING_CONTEXT: '||p_calling_context||
3128: ' P_OBJECT_ID:'||p_object_id||
3129: ' P_LEDGER_ID:'||p_ledger_id||' P_CAL_PERIOD_ID:'||p_cal_period_id||

Line 3218: fem_engines_pkg.put_message(p_app_name =>'FEM',

3214:
3215: ELSE
3216:
3217: x_exec_lock_exists := 'T';
3218: fem_engines_pkg.put_message(p_app_name =>'FEM',
3219: p_msg_name =>'FEM_PL_RESULTS_EXIST_ERR');
3220:
3221: END IF;
3222:

Line 3223: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

3219: p_msg_name =>'FEM_PL_RESULTS_EXIST_ERR');
3220:
3221: END IF;
3222:
3223: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
3224: p_module => 'fem.plsql.'||g_pkg_name||'.mapping_exec_lock_exists',
3225: p_msg_text => 'End. Object execution lock exists:'||x_exec_lock_exists||
3226: 'Execution state:'||x_exec_state||
3227: ' V_NORMAL_RUN:'||v_normal_run||' V_RESTART:'||v_restart||

Line 3291: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

3287: AND o.exec_status_code = 'RUNNING';
3288:
3289: BEGIN
3290:
3291: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
3292: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
3293: p_msg_text => 'Begin. P_CALLING_CONTEXT: '||p_calling_context||
3294: ' P_OBJECT_ID:'||p_object_id);
3295:

Line 3372: fem_engines_pkg.put_message(p_app_name =>'FEM',p_msg_name =>'FEM_PL_OBJ_RUNNING');

3368:
3369: ELSE
3370:
3371: x_exec_lock_exists := 'T';
3372: fem_engines_pkg.put_message(p_app_name =>'FEM',p_msg_name =>'FEM_PL_OBJ_RUNNING');
3373:
3374: END IF;
3375:
3376: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

Line 3376: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

3372: fem_engines_pkg.put_message(p_app_name =>'FEM',p_msg_name =>'FEM_PL_OBJ_RUNNING');
3373:
3374: END IF;
3375:
3376: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
3377: p_module => 'fem.plsql.'||g_pkg_name||'.dim_mbr_ldr_exec_lock_exists',
3378: p_msg_text => 'End. Object execution lock exists:'||x_exec_lock_exists||
3379: 'Execution state:'||x_exec_state||
3380: ' V_NORMAL_RUN:'||v_normal_run||' V_RESTART:'||v_restart||

Line 3454: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

3450:
3451:
3452: BEGIN
3453:
3454: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
3455: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
3456: p_msg_text => 'Begin. P_CALLING_CONTEXT: '||p_calling_context||
3457: ' P_OBJECT_ID:'||p_object_id||
3458: ' P_LEDGER_ID:'||p_ledger_id||' P_CAL_PERIOD_ID:'||p_cal_period_id||

Line 3556: fem_engines_pkg.put_message(p_app_name =>'FEM',

3552:
3553: ELSE
3554:
3555: x_exec_lock_exists := 'T';
3556: fem_engines_pkg.put_message(p_app_name =>'FEM',
3557: p_msg_name =>'FEM_PL_RESULTS_EXIST_ERR');
3558:
3559: END IF;
3560:

Line 3561: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

3557: p_msg_name =>'FEM_PL_RESULTS_EXIST_ERR');
3558:
3559: END IF;
3560:
3561: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
3562: p_module => 'fem.plsql.'||g_pkg_name||'.datax_ldr_exec_lock_exists',
3563: p_msg_text => 'End. Object execution lock exists:'||x_exec_lock_exists||
3564: 'Execution state:'||x_exec_state||
3565: ' V_NORMAL_RUN:'||v_normal_run||' V_RESTART:'||v_restart||

Line 3629: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

3625: AND o.exec_status_code = 'RUNNING';
3626:
3627: BEGIN
3628:
3629: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
3630: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
3631: p_msg_text => 'Begin. P_CALLING_CONTEXT: '||p_calling_context||
3632: ' P_OBJECT_ID:'||p_object_id||' P_hierarchy_name:'||p_hierarchy_name);
3633:

Line 3715: fem_engines_pkg.put_message(p_app_name =>'FEM',

3711:
3712: ELSE
3713:
3714: x_exec_lock_exists := 'T';
3715: fem_engines_pkg.put_message(p_app_name =>'FEM',
3716: p_msg_name =>'FEM_PL_OBJ_RUNNING');
3717:
3718: END IF;
3719:

Line 3720: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

3716: p_msg_name =>'FEM_PL_OBJ_RUNNING');
3717:
3718: END IF;
3719:
3720: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
3721: p_module => 'fem.plsql.'||g_pkg_name||'.hier_ldr_exec_lock_exists',
3722: p_msg_text => 'End. Object execution lock exists:'||x_exec_lock_exists||
3723: 'Execution state:'||x_exec_state||
3724: ' V_NORMAL_RUN:'||v_normal_run||' V_RESTART:'||v_restart||

Line 3795: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

3791:
3792:
3793: BEGIN
3794:
3795: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
3796: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
3797: p_msg_text => 'Begin. P_CALLING_CONTEXT: '||p_calling_context||
3798: ' P_OBJECT_ID:'||p_object_id||
3799: ' P_LEDGER_ID:'||p_ledger_id||' P_CAL_PERIOD_ID:'||p_cal_period_id||

Line 3889: fem_engines_pkg.put_message(p_app_name =>'FEM',

3885:
3886: ELSE
3887:
3888: x_exec_lock_exists := 'T';
3889: fem_engines_pkg.put_message(p_app_name =>'FEM',
3890: p_msg_name =>'FEM_PL_OBJ_RUNNING');
3891:
3892: END IF;
3893:

Line 3894: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

3890: p_msg_name =>'FEM_PL_OBJ_RUNNING');
3891:
3892: END IF;
3893:
3894: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
3895: p_module => 'fem.plsql.'||g_pkg_name||'.mapping_exec_lock_exists',
3896: p_msg_text => 'End. Object execution lock exists:'||x_exec_lock_exists||
3897: 'Execution state:'||x_exec_state||
3898: ' V_NORMAL_RUN:'||v_normal_run||' V_RESTART:'||v_restart||

Line 3952: fem_engines_pkg.tech_message(p_severity => c_log_level_1,

3948: AND o.exec_status_code = 'RUNNING';
3949:
3950: BEGIN
3951:
3952: fem_engines_pkg.tech_message(p_severity => c_log_level_1,
3953: p_module => 'fem.plsql.'||g_pkg_name||'.'||l_api_name,
3954: p_msg_text => 'Begin. P_CALLING_CONTEXT: '||p_calling_context
3955: ||'; P_OBJECT_ID:'||p_object_id
3956: ||'; P_EXEC_OBJECT_DEFINITION_ID:'||p_exec_object_definition_id);

Line 4002: fem_engines_pkg.put_message(p_app_name =>'FEM',

3998:
3999: ELSE
4000:
4001: x_exec_lock_exists := 'T';
4002: fem_engines_pkg.put_message(p_app_name =>'FEM',
4003: p_msg_name =>'FEM_PL_RESULTS_EXIST_ERR');
4004:
4005: END IF;
4006:

Line 4007: fem_engines_pkg.tech_message(p_severity => c_log_level_2,

4003: p_msg_name =>'FEM_PL_RESULTS_EXIST_ERR');
4004:
4005: END IF;
4006:
4007: fem_engines_pkg.tech_message(p_severity => c_log_level_2,
4008: p_module => 'fem.plsql.'||g_pkg_name||'.preview_exec_lock_exists',
4009: p_msg_text => 'End. Object execution lock exists:'||x_exec_lock_exists
4010: ||'; Execution state:'||x_exec_state
4011: ||'; V_NORMAL_RUN:'||v_normal_run

Line 4077: FEM_ENGINES_PKG.TECH_MESSAGE(

4073: --
4074: BEGIN
4075: --
4076: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4077: FEM_ENGINES_PKG.TECH_MESSAGE(
4078: p_severity => FND_LOG.level_procedure,
4079: p_module => C_MODULE,
4080: p_msg_text => 'Begin Procedure');
4081: END IF;

Line 4093: FEM_ENGINES_PKG.TECH_MESSAGE(

4089: C_API_NAME,
4090: G_PKG_NAME)
4091: THEN
4092: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4093: FEM_ENGINES_PKG.TECH_MESSAGE(
4094: p_severity => FND_LOG.level_unexpected,
4095: p_module => C_MODULE,
4096: p_msg_text => 'INTERNAL ERROR: API Version ('||C_API_VERSION||') not compatible with '
4097: ||'passed in version ('||p_api_version||')');

Line 4124: FEM_ENGINES_PKG.TECH_MESSAGE(

4120: COMMIT;
4121: END IF;
4122:
4123: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4124: FEM_ENGINES_PKG.TECH_MESSAGE(
4125: p_severity => FND_LOG.level_procedure,
4126: p_module => C_MODULE,
4127: p_msg_text => 'End Procedure');
4128: END IF;

Line 4133: FEM_ENGINES_PKG.TECH_MESSAGE(

4129: --
4130: EXCEPTION
4131: WHEN others THEN
4132: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4133: FEM_ENGINES_PKG.TECH_MESSAGE(
4134: p_severity => FND_LOG.level_unexpected,
4135: p_module => C_MODULE,
4136: p_msg_text => 'Unexpected error: '||SQLERRM);
4137: END IF;

Line 4139: FEM_ENGINES_PKG.TECH_MESSAGE(

4135: p_module => C_MODULE,
4136: p_msg_text => 'Unexpected error: '||SQLERRM);
4137: END IF;
4138: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4139: FEM_ENGINES_PKG.TECH_MESSAGE(
4140: p_severity => FND_LOG.level_procedure,
4141: p_module => C_MODULE,
4142: p_msg_text => 'End Procedure');
4143: END IF;

Line 4199: FEM_ENGINES_PKG.TECH_MESSAGE(

4195: --
4196: BEGIN
4197: --
4198: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4199: FEM_ENGINES_PKG.TECH_MESSAGE(
4200: p_severity => FND_LOG.level_procedure,
4201: p_module => C_MODULE,
4202: p_msg_text => 'Begin Procedure: p_request_id = '||to_char(p_request_id)
4203: ||'; p_object_id = '||to_char(p_object_id));

Line 4216: FEM_ENGINES_PKG.TECH_MESSAGE(

4212: C_API_NAME,
4213: G_PKG_NAME)
4214: THEN
4215: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4216: FEM_ENGINES_PKG.TECH_MESSAGE(
4217: p_severity => FND_LOG.level_unexpected,
4218: p_module => C_MODULE,
4219: p_msg_text => 'INTERNAL ERROR: API Version ('||C_API_VERSION||') not compatible with '
4220: ||'passed in version ('||p_api_version||')');

Line 4297: FEM_ENGINES_PKG.TECH_MESSAGE(

4293: IF v_req_dev_phase <> 'COMPLETE' THEN
4294: v_exec_status_code := 'RUNNING';
4295: ELSE
4296: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4297: FEM_ENGINES_PKG.TECH_MESSAGE(
4298: p_severity => FND_LOG.level_statement,
4299: p_module => C_MODULE,
4300: p_msg_text => 'Call to FND_CONCURRENT.get_request_status '
4301: ||'returned with dev phase of: '||v_req_dev_phase);

Line 4324: FEM_ENGINES_PKG.TECH_MESSAGE(

4320: COMMIT;
4321: END IF;
4322:
4323: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4324: FEM_ENGINES_PKG.TECH_MESSAGE(
4325: p_severity => FND_LOG.level_procedure,
4326: p_module => C_MODULE,
4327: p_msg_text => 'End Procedure: x_return_status = '||x_return_status
4328: ||'; x_exec_status_code = '||x_exec_status_code);

Line 4336: FEM_ENGINES_PKG.TECH_MESSAGE(

4332: WHEN e_api_error THEN
4333: ROLLBACK TO get_exec_status_pub;
4334: WHEN others THEN
4335: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4336: FEM_ENGINES_PKG.TECH_MESSAGE(
4337: p_severity => FND_LOG.level_unexpected,
4338: p_module => C_MODULE,
4339: p_msg_text => 'Unexpected error: '||SQLERRM);
4340: END IF;

Line 4342: FEM_ENGINES_PKG.TECH_MESSAGE(

4338: p_module => C_MODULE,
4339: p_msg_text => 'Unexpected error: '||SQLERRM);
4340: END IF;
4341: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4342: FEM_ENGINES_PKG.TECH_MESSAGE(
4343: p_severity => FND_LOG.level_procedure,
4344: p_module => C_MODULE,
4345: p_msg_text => 'End Procedure');
4346: END IF;