DBA Data[Home] [Help]

APPS.FEM_OBJECT_CATALOG_UTIL_PKG dependencies on FEM_ENGINES_PKG

Line 84: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,

80:
81:
82: BEGIN
83:
84: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
85: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
86: p_msg_text => 'Begin. P_OBJECT_TYPE_CODE: '||p_object_type_code||
87: ' P_FOLDER_ID:'||p_folder_id||
88: ' P_LOCAL_VS_COMBO_ID:'||p_local_vs_combo_id||

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

232: IF FND_API.To_Boolean( p_commit ) THEN
233: COMMIT WORK;
234: END IF;
235:
236: fem_engines_pkg.put_message(p_app_name =>'FEM',
237: p_msg_name =>'FEM_CREATED_OBJ_TXT',
238: p_token1 => 'OBJECT_NAME',
239: p_value1 => p_object_name,
240: p_trans1 => 'N');

Line 242: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,

238: p_token1 => 'OBJECT_NAME',
239: p_value1 => p_object_name,
240: p_trans1 => 'N');
241:
242: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
243: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
244: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
245:
246: FND_MSG_PUB.Count_And_Get

Line 255: fem_engines_pkg.put_message(p_app_name =>'FEM'

251: WHEN e_duplicate_obj_name THEN
252: ROLLBACK TO create_object_pub;
253: x_return_status := pc_ret_sts_error;
254:
255: fem_engines_pkg.put_message(p_app_name =>'FEM'
256: ,p_msg_name =>'FEM_BR_OBJ_NAME_ERR'
257: ,p_token1 => 'OBJECT_TYPE_MEANING'
258: ,p_value1 => p_object_type_code
259: ,p_token2 => 'FOLDER_NAME'

Line 273: fem_engines_pkg.put_message(p_app_name =>'FEM'

269:
270: WHEN e_invalid_local_vs_combo_id THEN
271: ROLLBACK TO create_object_pub;
272: x_return_status := pc_ret_sts_error;
273: fem_engines_pkg.put_message(p_app_name =>'FEM'
274: ,p_msg_name =>'FEM_INVALID_LOCAL_VS_COMBO_ID'
275: ,p_token1 => 'LOCAL_VS_COMBO_ID'
276: ,p_value1 => p_local_vs_combo_id);
277:

Line 285: fem_engines_pkg.put_message(p_app_name =>'FEM'

281:
282: WHEN e_invalid_object_type THEN
283: ROLLBACK TO create_object_pub;
284: x_return_status := pc_ret_sts_error;
285: fem_engines_pkg.put_message(p_app_name =>'FEM'
286: ,p_msg_name =>'FEM_INVALID_OBJECT_TYPE'
287: ,p_token1 => 'OBJTYPE'
288: ,p_value1 => p_object_type_code);
289:

Line 297: fem_engines_pkg.put_message(p_app_name =>'FEM'

293:
294: WHEN e_invalid_object_origin THEN
295: ROLLBACK TO create_object_pub;
296: x_return_status := pc_ret_sts_error;
297: fem_engines_pkg.put_message(p_app_name =>'FEM'
298: ,p_msg_name =>'FEM_INVALID_OBJECT_ORIGIN'
299: ,p_token1 => 'OBJORIG'
300: ,p_value1 => p_object_origin_code);
301:

Line 310: fem_engines_pkg.put_message(p_app_name =>'FEM'

306:
307: WHEN e_invalid_object_access_code THEN
308: ROLLBACK TO create_object_pub;
309: x_return_status := pc_ret_sts_error;
310: fem_engines_pkg.put_message(p_app_name =>'FEM'
311: ,p_msg_name =>'FEM_INVALID_OBJ_ACCESS_CODE'
312: ,p_token1 => 'OBJACC'
313: ,p_value1 => p_object_access_code);
314:

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

318:
319: WHEN e_invalid_folder THEN
320: ROLLBACK TO create_object_pub;
321: x_return_status := pc_ret_sts_error;
322: fem_engines_pkg.put_message(p_app_name =>'FEM',
323: p_msg_name =>'FEM_IMPEXP_INVALID_FOLDER_ERR',
324: p_token1 => 'FOLDER',
325: p_value1 => v_folder_name);
326:

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

330:
331: WHEN e_invalid_effective_date_range THEN
332: ROLLBACK TO create_object_pub;
333: x_return_status := pc_ret_sts_error;
334: fem_engines_pkg.put_message(p_app_name =>'FEM',
335: p_msg_name =>'FEM_BR_END_LT_START_DATE_ERR',
336: p_token1 => 'END_DATE',
337: p_value1 => fnd_date.date_to_displaydate(p_effective_end_date),
338: p_trans1 => 'N',

Line 351: fem_engines_pkg.put_message(p_app_name =>'FEM'

347: WHEN e_cannot_create_definition THEN
348: ROLLBACK TO create_object_pub;
349: x_return_status := pc_ret_sts_error;
350: x_object_id := NULL;
351: fem_engines_pkg.put_message(p_app_name =>'FEM'
352: ,p_msg_name =>'FEM_CANNOT_CREATE_DEF_ERR'
353: ,p_token1 => 'DEFNAME'
354: ,p_value1 => p_obj_def_name);
355:

Line 364: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,

360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
361: ROLLBACK TO create_object_pub;
362: x_return_status := pc_ret_sts_unexp_error;
363:
364: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,
365: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
366: p_msg_name => 'FEM_BAD_P_API_VER_ERR'
367: ,p_token1 => 'VALUE'
368: ,p_value1 => p_api_version

Line 384: FEM_ENGINES_PKG.Tech_Message

380:
381: /* Log the call stack and the Oracle error message to
382: ** FND_LOG with the "unexpected exception" severity level. */
383:
384: FEM_ENGINES_PKG.Tech_Message
385: (p_severity => pc_log_level_unexpected,
386: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
387: p_msg_text => gv_prg_msg);
388:

Line 389: FEM_ENGINES_PKG.Tech_Message

385: (p_severity => pc_log_level_unexpected,
386: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
387: p_msg_text => gv_prg_msg);
388:
389: FEM_ENGINES_PKG.Tech_Message
390: (p_severity => pc_log_level_unexpected,
391: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
392: p_msg_text => gv_callstack);
393:

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

391: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
392: p_msg_text => gv_callstack);
393:
394: /* Log the Oracle error message to the stack. */
395: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
396: p_msg_name => 'FEM_UNEXPECTED_ERROR',
397: P_TOKEN1 => 'ERR_MSG',
398: P_VALUE1 => gv_prg_msg);
399: ROLLBACK TO create_object_pub;

Line 438: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,

434: ** the object.
435: ** ==========================================================================*/
436: BEGIN
437:
438: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
439: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
440: p_msg_text => 'Begin. P_OBJECT_ID: '||p_object_id||
441: ' P_DESCRIPTION:'||p_obj_def_name||
442: ' P_EFFECTIVE_START_DATE:'||p_effective_start_date||

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

535: X_LAST_UPDATE_DATE => sysdate,
536: X_LAST_UPDATED_BY => pc_user_id,
537: X_LAST_UPDATE_LOGIN => null);
538:
539: fem_engines_pkg.put_message(p_app_name =>'FEM',
540: p_msg_name =>'FEM_CREATED_DEF_TXT',
541: p_token1 => 'OBJECT_DEFINITION_NAME',
542: p_value1 => p_obj_def_name,
543: p_trans1 => 'N');

Line 555: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,

551: IF FND_API.To_Boolean( p_commit ) THEN
552: COMMIT WORK;
553: END IF;
554:
555: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
556: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
557: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
558:
559: FND_MSG_PUB.Count_And_Get

Line 567: fem_engines_pkg.put_message(p_app_name =>'FEM'

563: EXCEPTION
564: WHEN e_invalid_object_origin THEN
565: ROLLBACK TO create_object_definition_pub;
566: x_return_status := pc_ret_sts_error;
567: fem_engines_pkg.put_message(p_app_name =>'FEM'
568: ,p_msg_name =>'FEM_INVALID_OBJECT_ORIGIN'
569: ,p_token1 => 'OBJORIG'
570: ,p_value1 => p_object_origin_code);
571:

Line 579: fem_engines_pkg.put_message(p_app_name =>'FEM'

575:
576: WHEN e_cannot_write_to_object THEN
577: ROLLBACK TO create_object_definition_pub;
578: x_return_status := pc_ret_sts_error;
579: fem_engines_pkg.put_message(p_app_name =>'FEM'
580: ,p_msg_name =>'FEM_CANNOT_WRITE_TO_OBJECT_ERR');
581:
582: FND_MSG_PUB.Count_And_Get
583: (p_count => x_msg_count,

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

585:
586: WHEN e_invalid_effective_date_range THEN
587: ROLLBACK TO create_object_definition_pub;
588: x_return_status := pc_ret_sts_error;
589: fem_engines_pkg.put_message(p_app_name =>'FEM',
590: p_msg_name =>'FEM_INVALID_DATE_RANGE_ERR');
591:
592: FND_MSG_PUB.Count_And_Get
593: (p_count => x_msg_count,

Line 600: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,

596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
597: ROLLBACK TO create_object_definition_pub;
598: x_return_status := pc_ret_sts_unexp_error;
599:
600: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,
601: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
602: p_msg_name => 'FEM_BAD_P_API_VER_ERR',p_token1 => 'VALUE',
603: p_value1 => p_api_version, p_trans1 => 'N');
604:

Line 614: FEM_ENGINES_PKG.Tech_Message

610:
611: /* Log the call stack and the Oracle error message to
612: ** FND_LOG with the "unexpected exception" severity level. */
613:
614: FEM_ENGINES_PKG.Tech_Message
615: (p_severity => pc_log_level_unexpected,
616: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
617: p_msg_text => gv_prg_msg);
618:

Line 619: FEM_ENGINES_PKG.Tech_Message

615: (p_severity => pc_log_level_unexpected,
616: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
617: p_msg_text => gv_prg_msg);
618:
619: FEM_ENGINES_PKG.Tech_Message
620: (p_severity => pc_log_level_unexpected,
621: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
622: p_msg_text => gv_callstack);
623:

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

621: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
622: p_msg_text => gv_callstack);
623:
624: /* Log the Oracle error message to the stack. */
625: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
626: p_msg_name => 'FEM_UNEXPECTED_ERROR',
627: P_TOKEN1 => 'ERR_MSG',
628: P_VALUE1 => gv_prg_msg);
629: ROLLBACK TO create_object_definition_pub;

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

664:
665:
666: IF p_new_effective_start_date >= p_new_effective_end_date THEN
667: x_date_range_is_valid := 'N';
668: fem_engines_pkg.put_message(p_app_name =>'FEM',
669: p_msg_name =>'FEM_BR_END_LT_START_DATE_ERR',
670: p_token1 => 'END_DATE',
671: p_value1 => fnd_date.date_to_displaydate(p_new_effective_end_date),
672: p_trans1 => 'N',

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

688: (p_new_effective_end_date <= object_def.effective_end_date AND
689: p_new_effective_end_date >= object_def.effective_start_date)) THEN
690: x_date_range_is_valid := 'N';
691:
692: fem_engines_pkg.put_message(p_app_name =>'FEM',
693: p_msg_name =>'FEM_BR_OVRLP_OBJ_DEF_ERR',
694: p_token1 => 'VERSION_NAME',
695: p_value1 => object_def.display_name,
696: p_trans1 => 'Y',

Line 743: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,

739: v_object_name VARCHAR2(150);
740:
741: BEGIN
742:
743: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
744: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
745: p_msg_text => 'Begin. P_OBJECT_ID: '||p_object_id||' P_COMMIT: '||p_commit);
746:
747: /* Standard Start of API savepoint */

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

815:
816: DELETE fem_object_catalog_b
817: WHERE object_id = p_object_id;
818:
819: fem_engines_pkg.put_message(p_app_name =>'FEM',
820: p_msg_name => 'FEM_DELETED_OBJ_TXT',p_token1 => 'OBJECT_NAME',
821: p_value1 => v_object_name, p_trans1 => 'N');
822:
823: ELSE

Line 833: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,

829: IF FND_API.To_Boolean( p_commit ) THEN
830: COMMIT WORK;
831: END IF;
832:
833: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
834: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
835: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
836:
837: /* Standard call to get message count and if count is 1, get message info. */

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

841:
842: EXCEPTION
843: WHEN e_cannot_delete_object THEN
844: x_return_status := pc_ret_sts_error;
845: fem_engines_pkg.put_message(p_app_name =>'FEM',
846: p_msg_name => 'FEM_CANNOT_DELETE_OBJ_ERR'
847: ,p_token1 => 'OBJECT'
848: ,p_value1 => p_object_id
849: ,p_trans1 => 'N');

Line 854: fem_engines_pkg.put_message(p_app_name =>'FEM'

850:
851: WHEN e_cannot_write_to_object THEN
852: ROLLBACK TO delete_object_pub;
853: x_return_status := pc_ret_sts_error;
854: fem_engines_pkg.put_message(p_app_name =>'FEM'
855: ,p_msg_name =>'FEM_CANNOT_WRITE_TO_OBJECT_ERR');
856:
857: FND_MSG_PUB.Count_And_Get
858: (p_count => x_msg_count,

Line 865: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,

861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
862: ROLLBACK TO delete_object_pub;
863: x_return_status := pc_ret_sts_unexp_error;
864:
865: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,
866: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
867: p_msg_name => 'FEM_BAD_P_API_VER_ERR'
868: ,p_token1 => 'VALUE'
869: ,p_value1 => p_api_version

Line 881: FEM_ENGINES_PKG.Tech_Message

877:
878: /* Log the call stack and the Oracle error message to
879: ** FND_LOG with the "unexpected exception" severity level. */
880:
881: FEM_ENGINES_PKG.Tech_Message
882: (p_severity => pc_log_level_unexpected,
883: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
884: p_msg_text => gv_prg_msg);
885:

Line 886: FEM_ENGINES_PKG.Tech_Message

882: (p_severity => pc_log_level_unexpected,
883: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
884: p_msg_text => gv_prg_msg);
885:
886: FEM_ENGINES_PKG.Tech_Message
887: (p_severity => pc_log_level_unexpected,
888: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
889: p_msg_text => gv_callstack);
890:

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

888: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
889: p_msg_text => gv_callstack);
890:
891: /* Log the Oracle error message to the stack. */
892: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
893: p_msg_name => 'FEM_UNEXPECTED_ERROR',
894: P_TOKEN1 => 'ERR_MSG',
895: P_VALUE1 => gv_prg_msg);
896: ROLLBACK TO delete_object_pub;