DBA Data[Home] [Help]

APPS.FEM_DIM_SNAPSHOT_ENG_PKG dependencies on FEM_ENGINES_PKG

Line 93: FEM_ENGINES_PKG.Put_Message(

89:
90:
91: EXCEPTION
92: WHEN e_bad_p_init_msg_list THEN
93: FEM_ENGINES_PKG.Put_Message(
94: p_app_name => 'FEM',
95: p_msg_name => 'FEM_BAD_P_INIT_MSG_LIST_ERR');
96: x_return_status := c_error;
97:

Line 99: FEM_ENGINES_PKG.Put_Message(

95: p_msg_name => 'FEM_BAD_P_INIT_MSG_LIST_ERR');
96: x_return_status := c_error;
97:
98: WHEN e_bad_p_encoded THEN
99: FEM_ENGINES_PKG.Put_Message(
100: p_app_name => 'FEM',
101: p_msg_name => 'FEM_BAD_P_ENCODED_ERR');
102: x_return_status := c_error;
103:

Line 240: FEM_ENGINES_PKG.Tech_Message

236: v_sql_vers_delete_stmt :=
237: 'DELETE FROM fem_dsnp_dim_attr_vrs_tl '||
238: ' WHERE created_by_object_id = '||v_object_id;
239:
240: FEM_ENGINES_PKG.Tech_Message
241: (p_severity => pc_log_level_1,
242: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name||'.v_sql_vers_delete_stmt',
243: p_msg_text => v_sql_vers_delete_stmt);
244:

Line 280: FEM_ENGINES_PKG.Tech_Message

276: ' AND VB.attribute_id = A.attribute_id'||
277: ' AND A.dimension_id = R.dimension_id'||
278: ' AND R.dim_snapshot_obj_def_id = '||p_dim_snapshot_obj_def_id;
279:
280: FEM_ENGINES_PKG.Tech_Message
281: (p_severity => pc_log_level_1,
282: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name||'.v_sql_vers_insert_stmt',
283: p_msg_text => v_sql_vers_insert_stmt);
284:

Line 289: FEM_ENGINES_PKG.Tech_Message

285: -- Delete/Insert the version data for FEM_DSNP_DIM_ATTR_VERS_TL
286: EXECUTE IMMEDIATE v_sql_vers_delete_stmt;
287: COMMIT;
288:
289: FEM_ENGINES_PKG.Tech_Message
290: (p_severity => pc_log_level_1,
291: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
292: p_msg_text => 'after version delete');
293:

Line 299: FEM_ENGINES_PKG.Tech_Message

295: USING v_sysdate
296: ,v_sysdate;
297: COMMIT;
298:
299: FEM_ENGINES_PKG.Tech_Message
300: (p_severity => pc_log_level_1,
301: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
302: p_msg_text => 'after version insert');
303:

Line 399: FEM_ENGINES_PKG.Tech_Message

395: ' AND A.'||dim.member_col||' = B.'||dim.member_col||
396: ' AND B.personal_flag = ''N''';
397: END IF;
398:
399: FEM_ENGINES_PKG.Tech_Message
400: (p_severity => pc_log_level_1,
401: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name||'.v_sql_insert_stmt',
402: p_msg_text => v_sql_insert_stmt);
403:

Line 409: FEM_ENGINES_PKG.Tech_Message

405: -- delete from the target table for the object_id
406: EXECUTE IMMEDIATE v_sql_delete_stmt;
407: COMMIT;
408:
409: FEM_ENGINES_PKG.Tech_Message
410: (p_severity => pc_log_level_1,
411: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
412: p_msg_text => 'after attribute delete');
413:

Line 429: FEM_ENGINES_PKG.Put_Message(

425:
426: WHEN e_invalid_obj_def_id THEN
427:
428: x_return_status := c_error;
429: FEM_ENGINES_PKG.Put_Message(
430: p_app_name => 'FEM',
431: p_msg_name => 'FEM_DSNP_INVALID_OBJ_DEF',
432: p_token1 => 'OBJDEF_ID',
433: p_value1 => p_dim_snapshot_obj_def_id);

Line 449: FEM_ENGINES_PKG.Tech_Message

445:
446: /* Log the call stack and the Oracle error message to
447: ** FND_LOG with the "unexpected exception" severity level. */
448:
449: FEM_ENGINES_PKG.Tech_Message
450: (p_severity => pc_log_level_unexpected,
451: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
452: p_msg_text => gv_prg_msg);
453:

Line 454: FEM_ENGINES_PKG.Tech_Message

450: (p_severity => pc_log_level_unexpected,
451: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
452: p_msg_text => gv_prg_msg);
453:
454: FEM_ENGINES_PKG.Tech_Message
455: (p_severity => pc_log_level_unexpected,
456: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
457: p_msg_text => gv_callstack);
458:

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

456: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
457: p_msg_text => gv_callstack);
458:
459: /* Log the Oracle error message to the stack. */
460: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
461: p_msg_name => 'FEM_UNEXPECTED_ERROR',
462: P_TOKEN1 => 'ERR_MSG',
463: P_VALUE1 => gv_prg_msg);
464: