[Home] [Help]
196: p_module||'.get_put_messages';
197:
198: BEGIN
199:
200: FEM_ENGINES_PKG.TECH_MESSAGE
201: (p_severity => pc_log_level_procedure,
202: p_module => v_block,
203: p_msg_text => 'MSG_COUNT: '||p_msg_count);
204:
209: FND_MESSAGE.Set_Encoded(v_msg_data);
210: v_message := FND_MESSAGE.Get;
211:
212: IF p_user_msg = 'Y' THEN
213: FEM_ENGINES_PKG.User_Message(
214: p_msg_text => v_message);
215: END IF;
216:
217: FEM_ENGINES_PKG.TECH_MESSAGE
213: FEM_ENGINES_PKG.User_Message(
214: p_msg_text => v_message);
215: END IF;
216:
217: FEM_ENGINES_PKG.TECH_MESSAGE
218: (p_severity => pc_log_level_event,
219: p_module => v_block,
220: p_msg_text => v_message);
221:
229: p_data => v_message,
230: p_msg_index_out => v_msg_out);
231:
232: IF p_user_msg = 'Y' THEN
233: FEM_ENGINES_PKG.User_Message(
234: p_msg_text => v_message);
235: END IF;
236:
237: FEM_ENGINES_PKG.TECH_MESSAGE
233: FEM_ENGINES_PKG.User_Message(
234: p_msg_text => v_message);
235: END IF;
236:
237: FEM_ENGINES_PKG.TECH_MESSAGE
238: (p_severity => pc_log_level_event,
239: p_module => v_block,
240: p_msg_text => v_message);
241:
286:
287: BEGIN
288:
289: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
290: FEM_ENGINES_PKG.TECH_MESSAGE(
291: p_severity => FND_LOG.level_procedure,
292: p_module => C_MODULE,
293: p_msg_text => 'Begin Procedure');
294: END IF;
293: p_msg_text => 'Begin Procedure');
294: END IF;
295:
296: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
297: FEM_ENGINES_PKG.TECH_MESSAGE(
298: p_severity => FND_LOG.level_statement,
299: p_module => C_MODULE,
300: p_msg_text => 'p_event_name = '||p_event_name);
301: FEM_ENGINES_PKG.TECH_MESSAGE(
297: FEM_ENGINES_PKG.TECH_MESSAGE(
298: p_severity => FND_LOG.level_statement,
299: p_module => C_MODULE,
300: p_msg_text => 'p_event_name = '||p_event_name);
301: FEM_ENGINES_PKG.TECH_MESSAGE(
302: p_severity => FND_LOG.level_statement,
303: p_module => C_MODULE,
304: p_msg_text => 'p_request_id = '||to_char(p_request_id));
305: FEM_ENGINES_PKG.TECH_MESSAGE(
301: FEM_ENGINES_PKG.TECH_MESSAGE(
302: p_severity => FND_LOG.level_statement,
303: p_module => C_MODULE,
304: p_msg_text => 'p_request_id = '||to_char(p_request_id));
305: FEM_ENGINES_PKG.TECH_MESSAGE(
306: p_severity => FND_LOG.level_statement,
307: p_module => C_MODULE,
308: p_msg_text => 'p_object_id = '||to_char(p_object_id));
309: FEM_ENGINES_PKG.TECH_MESSAGE(
305: FEM_ENGINES_PKG.TECH_MESSAGE(
306: p_severity => FND_LOG.level_statement,
307: p_module => C_MODULE,
308: p_msg_text => 'p_object_id = '||to_char(p_object_id));
309: FEM_ENGINES_PKG.TECH_MESSAGE(
310: p_severity => FND_LOG.level_statement,
311: p_module => C_MODULE,
312: p_msg_text => 'p_status = '||p_status);
313: END IF;
549:
550: COMMIT;
551:
552: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
553: FEM_ENGINES_PKG.TECH_MESSAGE(
554: p_severity => FND_LOG.level_procedure,
555: p_module => C_MODULE,
556: p_msg_text => 'End Procedure');
557: END IF;
557: END IF;
558: --
559: EXCEPTION WHEN OTHERS THEN
560:
561: FEM_ENGINES_PKG.Tech_Message
562: (p_severity => pc_log_level_unexpected,
563: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
564: p_msg_text => SQLERRM);
565:
562: (p_severity => pc_log_level_unexpected,
563: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
564: p_msg_text => SQLERRM);
565:
566: FEM_ENGINES_PKG.Tech_Message
567: (p_severity => pc_log_level_unexpected,
568: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
569: p_msg_text => dbms_utility.format_call_stack);
570:
602:
603:
604: BEGIN
605:
606: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
607: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
608: p_msg_text => 'Begin. P_REQUEST_ID:'||p_request_id||
609: ' P_OBJECT_ID: '||p_object_id);
610:
633: -- Drop objects listed in FEM_PL_TEMP_OBJECTS
634: -- If an object is not found, a message is posted and the loop continues
635: -- to drop the remaining objects.
636: -- ============================================================================
637: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
638: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
639: p_msg_text => 'STEP 1: Drop objects listed in FEM_PL_TEMP_OBJECTS.');
640:
641: FOR tmpobj IN c3 LOOP
665: p_object_id => p_object_id,
666: p_pb_object_id => v_pb_object_id);
667:
668: IF x_return_status <> pc_ret_sts_success THEN
669: FEM_ENGINES_PKG.tech_message(p_severity => pc_log_level_statement,
670: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
671: p_msg_text => 'FEM_DATABASE_UTIL_PKG.Drop_Temp_DB_Objects '
672: ||'failed with return status of: '||x_return_status);
673:
675: END IF;
676:
677: END LOOP;
678:
679: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
680: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
681: p_msg_text => 'Number of temporary objects found in FEM_TEMP_OBJECTS: '||v_count_tmpobjs);
682:
683: -- ============================================================================
683: -- ============================================================================
684: -- STEP 2:
685: -- Delete object execution from process lock tables (FEM_PL_xxxx).
686: -- ============================================================================
687: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
688: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
689: p_msg_text => 'STEP 2: Delete object execution from process lock tables (FEM_PL_xxxx).');
690:
691: DELETE fem_pl_temp_objects
695: -- Bug 4382068: Only remove data edit locks if object is of type
696: -- 'OGL_INTG_CAL_RULE','OGL_INTG_DIM_RULE','OGL_INTG_HIER_RULE'
697: IF v_object_type_code IN ('OGL_INTG_CAL_RULE','OGL_INTG_DIM_RULE',
698: 'OGL_INTG_HIER_RULE') THEN
699: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
700: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
701: p_msg_text => 'Object type is: '||v_object_type_code||'. Only remove edit locks.');
702:
703: -- Remove all defs for the object, regardless of the request
748: IF FND_API.To_Boolean( p_commit ) THEN
749: COMMIT WORK;
750: END IF;
751:
752: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
753: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
754: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
755:
756: FND_MSG_PUB.Count_And_Get
761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
762: ROLLBACK TO delete_execution_log_pub;
763: x_return_status := pc_ret_sts_unexp_error;
764:
765: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,
766: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
767: p_app_name =>'FEM',
768: p_msg_name => 'FEM_BAD_P_API_VER_ERR',p_token1 => 'VALUE',
769: p_value1 => p_api_version, p_trans1 => 'N');
767: p_app_name =>'FEM',
768: p_msg_name => 'FEM_BAD_P_API_VER_ERR',p_token1 => 'VALUE',
769: p_value1 => p_api_version, p_trans1 => 'N');
770:
771: fem_engines_pkg.put_message(
772: p_app_name =>'FEM',
773: p_msg_name => 'FEM_BAD_P_API_VER_ERR',p_token1 => 'VALUE',
774: p_value1 => p_api_version, p_trans1 => 'N');
775:
783:
784: -- Log the call stack and the Oracle error message to
785: -- FND_LOG with the "unexpected exception" severity level.
786:
787: FEM_ENGINES_PKG.Tech_Message
788: (p_severity => pc_log_level_unexpected,
789: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
790: p_msg_text => SQLERRM);
791:
788: (p_severity => pc_log_level_unexpected,
789: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
790: p_msg_text => SQLERRM);
791:
792: FEM_ENGINES_PKG.Tech_Message
793: (p_severity => pc_log_level_unexpected,
794: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
795: p_msg_text => dbms_utility.format_call_stack);
796:
794: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
795: p_msg_text => dbms_utility.format_call_stack);
796:
797: -- Log the Oracle error message to the stack.
798: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
799: p_msg_name => 'FEM_UNEXPECTED_ERROR',
800: P_TOKEN1 => 'ERR_MSG',
801: P_VALUE1 => SQLERRM);
802:
834: c_api_version CONSTANT NUMBER := 1.0;
835:
836: BEGIN
837:
838: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
839: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
840: p_msg_text => 'Begin. P_COMMIT:'||p_commit||
841: ' P_UNDO_LIST_NAME: '||p_undo_list_name||
842: ' P_FOLDER_ID: '||p_folder_id||
917: IF FND_API.To_Boolean( p_commit ) THEN
918: COMMIT WORK;
919: END IF;
920:
921: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
922: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
923: p_msg_text => 'End. x_return_status: '||x_return_status||
924: ' x_undo_list_obj_id:'||x_undo_list_obj_id||
925: ' x_undo_list_obj_def_id'||x_undo_list_obj_def_id);
927: EXCEPTION
928: WHEN e_null_undo_list_name THEN
929: x_return_status := pc_ret_sts_error;
930:
931: fem_engines_pkg.put_message(p_app_name =>'FEM',
932: p_msg_name => 'FEM_UD_NULL_LIST_NAME_ERR');
933:
934: FND_MSG_PUB.Count_And_Get
935: (p_count => x_msg_count,
936: p_data => x_msg_data);
937: WHEN e_invalid_dependencies_flag THEN
938: x_return_status := pc_ret_sts_error;
939:
940: fem_engines_pkg.put_message(p_app_name =>'FEM',
941: p_msg_name => 'FEM_UD_BAD_DEPENDENCIES_ERR');
942:
943: FND_MSG_PUB.Count_And_Get
944: (p_count => x_msg_count,
945: p_data => x_msg_data);
946: WHEN e_invalid_dependency_errs_flag THEN
947: x_return_status := pc_ret_sts_error;
948:
949: fem_engines_pkg.put_message(p_app_name =>'FEM',
950: p_msg_name => 'FEM_UD_BAD_DEP_ERRS_ERR');
951:
952: FND_MSG_PUB.Count_And_Get
953: (p_count => x_msg_count,
954: p_data => x_msg_data);
955: WHEN e_invalid_p_commit THEN
956: x_return_status := pc_ret_sts_error;
957:
958: fem_engines_pkg.put_message(p_app_name =>'FEM',
959: p_msg_name => 'FEM_BAD_P_COMMIT_ERR');
960:
961: FND_MSG_PUB.Count_And_Get
962: (p_count => x_msg_count,
964: WHEN e_cannot_create_object THEN
965: ROLLBACK TO create_undo_list_pub;
966: x_return_status := pc_ret_sts_error;
967:
968: fem_engines_pkg.put_message(p_app_name =>'FEM',
969: p_msg_name => 'FEM_CANNOT_CREATE_OBJ_ERR');
970:
971: FND_MSG_PUB.Count_And_Get
972: (p_count => x_msg_count,
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
976: ROLLBACK TO create_undo_list_pub;
977: x_return_status := pc_ret_sts_unexp_error;
978:
979: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,
980: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
981: p_app_name =>'FEM',
982: p_msg_name => 'FEM_BAD_P_API_VER_ERR',p_token1 => 'VALUE',
983: p_value1 => p_api_version, p_trans1 => 'N');
988:
989: -- Log the call stack and the Oracle error message to
990: -- FND_LOG with the "unexpected exception" severity level.
991:
992: FEM_ENGINES_PKG.Tech_Message
993: (p_severity => pc_log_level_unexpected,
994: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
995: p_msg_text => SQLERRM);
996:
993: (p_severity => pc_log_level_unexpected,
994: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
995: p_msg_text => SQLERRM);
996:
997: FEM_ENGINES_PKG.Tech_Message
998: (p_severity => pc_log_level_unexpected,
999: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1000: p_msg_text => dbms_utility.format_call_stack);
1001:
999: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1000: p_msg_text => dbms_utility.format_call_stack);
1001:
1002: -- Log the Oracle error message to the stack.
1003: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
1004: p_msg_name => 'FEM_UNEXPECTED_ERROR',
1005: P_TOKEN1 => 'ERR_MSG',
1006: P_VALUE1 => SQLERRM);
1007: ROLLBACK TO create_undo_list_pub;
1026: v_count NUMBER;
1027:
1028: BEGIN
1029:
1030: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
1031: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1032: p_msg_text => 'Begin. P_COMMIT:'||p_commit||
1033: ' P_UNDO_LIST_OBJ_ID: '||p_undo_list_obj_id);
1034:
1049:
1050: -- ============================================================================
1051: -- V01: Check to see if p_undo_list_obj_id is for a valid undo list.
1052: -- ============================================================================
1053: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
1054: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1055: p_msg_text => 'V01: Check to see if p_undo_list_obj_id is for a valid undo list.');
1056:
1057: BEGIN
1071: -- ============================================================================
1072: -- V02: Check to see if user list may be deleted (ie. check to make sure all
1073: -- candidates and dependents in the list have been processed successfully).
1074: -- ============================================================================
1075: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
1076: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1077: p_msg_text => 'V02: Check to see if user list may be deleted.');
1078:
1079: SELECT DECODE(count(*),0,'Y','N') INTO v_undo_list_exec_successfully
1140: IF FND_API.To_Boolean( p_commit ) THEN
1141: COMMIT WORK;
1142: END IF;
1143:
1144: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
1145: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1146: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
1147:
1148: FND_MSG_PUB.Count_And_Get
1152: EXCEPTION
1153: WHEN e_invalid_undo_list THEN
1154: x_return_status := pc_ret_sts_error;
1155: ROLLBACK;
1156: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
1157: p_msg_name => 'FEM_UD_INVALID_UNDO_LIST_ERR',
1158: p_token1 => 'OBJECT_ID',
1159: p_value1 => p_undo_list_obj_id,
1160: p_trans1 => 'N');
1166: WHEN e_undo_list_exec_not_success THEN
1167: ROLLBACK TO delete_undo_list_pub;
1168: x_return_status := pc_ret_sts_error;
1169:
1170: fem_engines_pkg.put_message(p_app_name =>'FEM',
1171: p_msg_name => 'FEM_UD_LIST_EXEC_INCOMPLT_ERR');
1172:
1173: FND_MSG_PUB.Count_And_Get
1174: (p_count => x_msg_count,
1177: WHEN e_cannot_delete_object THEN
1178: ROLLBACK TO delete_undo_list_pub;
1179: x_return_status := pc_ret_sts_error;
1180:
1181: fem_engines_pkg.put_message(p_app_name =>'FEM',
1182: p_msg_name => 'FEM_CANNOT_DELETE_OBJ_ERR',p_token1 => 'OBJECT',
1183: p_value1 => p_undo_list_obj_id, p_trans1 => 'N');
1184:
1185: FND_MSG_PUB.Count_And_Get
1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1190: ROLLBACK TO delete_undo_list_pub;
1191: x_return_status := pc_ret_sts_unexp_error;
1192:
1193: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,
1194: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1195: p_app_name =>'FEM',
1196: p_msg_name => 'FEM_BAD_P_API_VER_ERR',p_token1 => 'VALUE',
1197: p_value1 => p_api_version, p_trans1 => 'N');
1202:
1203: -- Log the call stack and the Oracle error message to
1204: -- FND_LOG with the "unexpected exception" severity level.
1205:
1206: FEM_ENGINES_PKG.Tech_Message
1207: (p_severity => pc_log_level_unexpected,
1208: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1209: p_msg_text => SQLERRM);
1210:
1207: (p_severity => pc_log_level_unexpected,
1208: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1209: p_msg_text => SQLERRM);
1210:
1211: FEM_ENGINES_PKG.Tech_Message
1212: (p_severity => pc_log_level_unexpected,
1213: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1214: p_msg_text => dbms_utility.format_call_stack);
1215:
1213: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1214: p_msg_text => dbms_utility.format_call_stack);
1215:
1216: -- Log the Oracle error message to the stack.
1217: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
1218: p_msg_name => 'FEM_UNEXPECTED_ERROR',
1219: P_TOKEN1 => 'ERR_MSG',
1220: P_VALUE1 => SQLERRM);
1221:
1277: 'RCM_PROCESS_RULE','TP_PROCESS_RULE'));
1278:
1279: BEGIN
1280:
1281: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
1282: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1283: p_msg_text => 'Begin. P_COMMIT:'||p_commit||
1284: ' P_UNDO_LIST_OBJ_DEF_ID: '||p_undo_list_obj_def_id||
1285: ' P_REQUEST_ID: '||p_request_id||
1491: IF FND_API.To_Boolean( p_commit ) THEN
1492: COMMIT WORK;
1493: END IF;
1494:
1495: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
1496: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1497: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
1498:
1499: FND_MSG_PUB.Count_And_Get
1505: ROLLBACK TO add_candidate_pub;
1506: x_return_status := pc_ret_sts_error;
1507:
1508: IF v_data_edit_lock_exists = 'T' THEN
1509: fem_engines_pkg.put_message(p_app_name =>'FEM',
1510: p_msg_name =>'FEM_UD_LOCKED_OBJ_DEF_ERR',
1511: p_token1 => 'OBJECT_DEFINITION_ID',
1512: p_value1 => p_undo_list_obj_def_id,
1513: p_trans1 => 'N');
1511: p_token1 => 'OBJECT_DEFINITION_ID',
1512: p_value1 => p_undo_list_obj_def_id,
1513: p_trans1 => 'N');
1514: ELSIF v_undo_list_ever_executed = 'T' THEN
1515: fem_engines_pkg.put_message(p_app_name =>'FEM',
1516: p_msg_name =>'FEM_UD_EXECUTED_OBJ_DEF_ERR',
1517: p_token1 => 'OBJECT_DEFINITION_ID',
1518: p_value1 => p_undo_list_obj_def_id,
1519: p_trans1 => 'N');
1522: INTO v_obj_def_name
1523: FROM fem_object_definition_vl
1524: WHERE object_definition_id = p_undo_list_obj_def_id;
1525:
1526: fem_engines_pkg.put_message(p_app_name =>'FEM',
1527: p_msg_name =>'FEM_PL_SUBMITTED_DEF_ERR',
1528: p_token1 => 'OBJ_DEF_NAME',
1529: p_value1 => v_obj_def_name);
1530: END IF;
1545: WHEN others THEN
1546: v_object_name := to_char(p_object_id);
1547: END;
1548:
1549: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
1550: p_msg_name => 'FEM_UD_CAND_DEP_FOUND_ERR',
1551: p_token1 => 'REQUEST_ID',
1552: p_value1 => p_request_id,
1553: p_token2 => 'OBJECT_NAME',
1560: WHEN e_cannot_read_object THEN
1561: ROLLBACK TO add_candidate_pub;
1562: x_return_status := pc_ret_sts_error;
1563:
1564: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
1565: p_msg_name => 'FEM_UD_CANNOT_READ_OBJECT_ERR');
1566:
1567: FND_MSG_PUB.Count_And_Get
1568: (p_count => x_msg_count,
1571: WHEN e_cannot_generate_dependents THEN
1572: ROLLBACK TO add_candidate_pub;
1573: x_return_status := pc_ret_sts_error;
1574:
1575: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
1576: p_msg_name => 'FEM_UD_CANNOT_GEN_DEPENDENTS');
1577:
1578: FND_MSG_PUB.Count_And_Get
1579: (p_count => x_msg_count,
1582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1583: ROLLBACK TO add_candidate_pub;
1584: x_return_status := pc_ret_sts_unexp_error;
1585:
1586: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,
1587: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1588: p_app_name =>'FEM',
1589: p_msg_name => 'FEM_BAD_P_API_VER_ERR',p_token1 => 'VALUE',
1590: p_value1 => p_api_version, p_trans1 => 'N');
1595:
1596: -- Log the call stack and the Oracle error message to
1597: -- FND_LOG with the "unexpected exception" severity level.
1598:
1599: FEM_ENGINES_PKG.Tech_Message
1600: (p_severity => pc_log_level_unexpected,
1601: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1602: p_msg_text => SQLERRM);
1603:
1600: (p_severity => pc_log_level_unexpected,
1601: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1602: p_msg_text => SQLERRM);
1603:
1604: FEM_ENGINES_PKG.Tech_Message
1605: (p_severity => pc_log_level_unexpected,
1606: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1607: p_msg_text => dbms_utility.format_call_stack);
1608:
1606: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1607: p_msg_text => dbms_utility.format_call_stack);
1608:
1609: -- Log the Oracle error message to the stack.
1610: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
1611: p_msg_name => 'FEM_UNEXPECTED_ERROR',
1612: P_TOKEN1 => 'ERR_MSG',
1613: P_VALUE1 => SQLERRM);
1614:
1667: 'RCM_PROCESS_RULE','TP_PROCESS_RULE'));
1668:
1669: BEGIN
1670:
1671: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
1672: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1673: p_msg_text => 'Begin. P_COMMIT:'||p_commit||
1674: ' P_UNDO_LIST_OBJ_DEF_ID: '||p_undo_list_obj_def_id||
1675: ' P_REQUEST_ID: '||p_request_id||
1766: IF FND_API.To_Boolean( p_commit ) THEN
1767: COMMIT WORK;
1768: END IF;
1769:
1770: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
1771: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1772: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
1773:
1774: FND_MSG_PUB.Count_And_Get
1780: ROLLBACK TO remove_candidate_pub;
1781: x_return_status := pc_ret_sts_error;
1782:
1783: IF v_data_edit_lock_exists = 'T' THEN
1784: fem_engines_pkg.put_message(p_app_name =>'FEM',
1785: p_msg_name =>'FEM_UD_LOCKED_OBJ_DEF_ERR',
1786: p_token1 => 'OBJECT_DEFINITION_ID',
1787: p_value1 => p_undo_list_obj_def_id,
1788: p_trans1 => 'N');
1786: p_token1 => 'OBJECT_DEFINITION_ID',
1787: p_value1 => p_undo_list_obj_def_id,
1788: p_trans1 => 'N');
1789: ELSIF v_undo_list_ever_executed = 'T' THEN
1790: fem_engines_pkg.put_message(p_app_name =>'FEM',
1791: p_msg_name =>'FEM_UD_EXECUTED_OBJ_DEF_ERR',
1792: p_token1 => 'OBJECT_DEFINITION_ID',
1793: p_value1 => p_undo_list_obj_def_id,
1794: p_trans1 => 'N');
1797: INTO v_obj_def_name
1798: FROM fem_object_definition_vl
1799: WHERE object_definition_id = p_undo_list_obj_def_id;
1800:
1801: fem_engines_pkg.put_message(p_app_name =>'FEM',
1802: p_msg_name =>'FEM_PL_SUBMITTED_DEF_ERR',
1803: p_token1 => 'OBJ_DEF_NAME',
1804: p_value1 => v_obj_def_name);
1805: END IF;
1811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1812: ROLLBACK TO remove_candidate_pub;
1813: x_return_status := pc_ret_sts_unexp_error;
1814:
1815: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,
1816: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1817: p_app_name =>'FEM',
1818: p_msg_name => 'FEM_BAD_P_API_VER_ERR',p_token1 => 'VALUE',
1819: p_value1 => p_api_version, p_trans1 => 'N');
1824:
1825: -- Log the call stack and the Oracle error message to
1826: -- FND_LOG with the "unexpected exception" severity level.
1827:
1828: FEM_ENGINES_PKG.Tech_Message
1829: (p_severity => pc_log_level_unexpected,
1830: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1831: p_msg_text => SQLERRM);
1832:
1829: (p_severity => pc_log_level_unexpected,
1830: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1831: p_msg_text => SQLERRM);
1832:
1833: FEM_ENGINES_PKG.Tech_Message
1834: (p_severity => pc_log_level_unexpected,
1835: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1836: p_msg_text => dbms_utility.format_call_stack);
1837:
1835: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1836: p_msg_text => dbms_utility.format_call_stack);
1837:
1838: -- Log the Oracle error message to the stack.
1839: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
1840: p_msg_name => 'FEM_UNEXPECTED_ERROR',
1841: P_TOKEN1 => 'ERR_MSG',
1842: P_VALUE1 => SQLERRM);
1843:
1882: v_num_dep_rows NUMBER;
1883:
1884: BEGIN
1885:
1886: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
1887: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1888: p_msg_text => 'Begin. P_REQUEST_ID: '||p_request_id||
1889: ' P_OBJECT_ID: '||p_object_id);
1890:
1930:
1931: v_new_dependents := (SQL%ROWCOUNT > 0);
1932: v_num_dep_rows := SQL%ROWCOUNT;
1933:
1934: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
1935: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1936: p_msg_text => 'Init Type2 dependents found: '||SQL%ROWCOUNT);
1937:
1938: -- Retrieve initial list of updated account table columns. The query
1950: 'FTP_NON_CASH_FLOW','FTP_OPTION_COST') );
1951:
1952: v_new_columns := (SQL%ROWCOUNT > 0);
1953:
1954: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
1955: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
1956: p_msg_text => 'Init Type1 dependents found: '||SQL%ROWCOUNT);
1957:
1958: LOOP
2054: v_new_columns := FALSE;
2055: END IF; -- v_num_new_dep
2056: END LOOP;
2057:
2058: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
2059: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2060: p_msg_text => 'Number of dependents found: '||v_num_dep_rows);
2061:
2062: -- Update API return status to success
2061:
2062: -- Update API return status to success
2063: x_return_status := pc_ret_sts_success;
2064:
2065: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
2066: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2067: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status||' x_upd_dep_calc_id:'||x_upd_dep_calc_id);
2068:
2069: EXCEPTION
2069: EXCEPTION
2070: WHEN NO_DATA_FOUND THEN
2071: ROLLBACK TO calc_accttbl_upd_dep_pub;
2072: x_return_status := pc_ret_sts_error;
2073: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
2074: p_msg_name => 'FEM_UD_REQUEST_NOT_FOUND_WRN',
2075: p_token1 => 'REQUEST_ID',
2076: p_value1 => p_request_id,
2077: p_trans1 => 'N');
2086:
2087: -- Log the call stack and the Oracle error message to
2088: -- FND_LOG with the "unexpected exception" severity level.
2089:
2090: FEM_ENGINES_PKG.Tech_Message
2091: (p_severity => pc_log_level_unexpected,
2092: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2093: p_msg_text => SQLERRM);
2094:
2091: (p_severity => pc_log_level_unexpected,
2092: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2093: p_msg_text => SQLERRM);
2094:
2095: FEM_ENGINES_PKG.Tech_Message
2096: (p_severity => pc_log_level_unexpected,
2097: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2098: p_msg_text => dbms_utility.format_call_stack);
2099:
2097: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2098: p_msg_text => dbms_utility.format_call_stack);
2099:
2100: -- Log the Oracle error message to the stack.
2101: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
2102: p_msg_name => 'FEM_UNEXPECTED_ERROR',
2103: P_TOKEN1 => 'ERR_MSG',
2104: P_VALUE1 => SQLERRM);
2105:
2155: PRIOR request_id=source_created_by_request_id;
2156:
2157: BEGIN
2158:
2159: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
2160: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2161: p_msg_text => 'Begin. '||
2162: ' P_REQUEST_ID: '||p_request_id||
2163: ' P_OBJECT_ID: '||p_object_id||
2162: ' P_REQUEST_ID: '||p_request_id||
2163: ' P_OBJECT_ID: '||p_object_id||
2164: ' P_DEPENDENCY_TYPE: '||p_dependency_type);
2165:
2166: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
2167: p_msg_name => 'FEM_UD_CAND_DEPENDENTS_TXT',
2168: p_token1 => 'REQUEST_ID',
2169: p_value1 => p_request_id,
2170: p_trans1 => 'N',
2177: -- to ACCOUNT tables.
2178: -- ============================================================================
2179:
2180: IF p_dependency_type IN ('ALL','UPDATE') THEN
2181: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
2182: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2183: p_msg_text => 'STEP 1: Report UPDATE dependents.');
2184:
2185: BEGIN
2197: v_count := 0;
2198: FOR an_update_dependent IN c1(v_upd_dep_calc_id) LOOP
2199: v_count := c1%ROWCOUNT;
2200:
2201: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
2202: p_msg_name => 'FEM_UD_DEPENDENT_OBJEXEC_TXT',
2203: p_token1 => 'REQUEST_ID',
2204: p_value1 => an_update_dependent.dependent_request_id,
2205: p_trans1 => 'N',
2212:
2213: END LOOP;
2214:
2215: IF v_count = 0 THEN -- If no dependents found, post message
2216: fem_engines_pkg.put_message(p_app_name =>'FEM',
2217: p_msg_name => 'FEM_UD_NO_UPDATE_DEP_FOUND_TXT');
2218: END IF;
2219:
2220: -- Delete update dependent list from temporary tables as no longer needed.
2233: WHEN others THEN
2234: v_object_name := to_char(p_object_id);
2235: END;
2236:
2237: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
2238: p_msg_name => 'FEM_UD_CANNOT_GEN_CAND_DEP_ERR',
2239: p_token1 => 'REQUEST_ID',
2240: p_value1 => p_request_id,
2241: p_token2 => 'OBJECT_NAME',
2247: -- STEP 2: Report CHAIN dependents.
2248: -- ============================================================================
2249: IF p_dependency_type IN ('ALL','CHAIN') THEN
2250:
2251: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
2252: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2253: p_msg_text => 'STEP 2: Report CHAIN dependents.');
2254:
2255: v_count := 0;
2255: v_count := 0;
2256: FOR a_chain_dependent IN c2 LOOP
2257: v_count := c2%ROWCOUNT;
2258:
2259: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
2260: p_msg_name => 'FEM_UD_DEPENDENT_OBJEXEC_TXT',
2261: p_token1 => 'REQUEST_ID',
2262: p_value1 => a_chain_dependent.request_id,
2263: p_trans1 => 'N',
2270:
2271: END LOOP;
2272:
2273: IF v_count = 0 THEN -- If no dependents found, post message
2274: fem_engines_pkg.put_message(p_app_name =>'FEM',
2275: p_msg_name => 'FEM_UD_NO_CHAIN_DEP_FOUND_TXT');
2276: END IF;
2277:
2278: END IF;
2276: END IF;
2277:
2278: END IF;
2279:
2280: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
2281: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2282: p_msg_text => 'End.');
2283:
2284: FND_MSG_PUB.Count_And_Get
2290: -- Unexpected exceptions
2291: -- Log the call stack and the Oracle error message to
2292: -- FND_LOG with the "unexpected exception" severity level.
2293:
2294: FEM_ENGINES_PKG.Tech_Message
2295: (p_severity => pc_log_level_unexpected,
2296: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2297: p_msg_text => SQLERRM);
2298:
2295: (p_severity => pc_log_level_unexpected,
2296: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2297: p_msg_text => SQLERRM);
2298:
2299: FEM_ENGINES_PKG.Tech_Message
2300: (p_severity => pc_log_level_unexpected,
2301: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2302: p_msg_text => dbms_utility.format_call_stack);
2303:
2301: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2302: p_msg_text => dbms_utility.format_call_stack);
2303:
2304: -- Log the Oracle error message to the stack.
2305: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
2306: p_msg_name => 'FEM_UNEXPECTED_ERROR',
2307: P_TOKEN1 => 'ERR_MSG',
2308: P_VALUE1 => SQLERRM);
2309:
2418:
2419:
2420: BEGIN
2421:
2422: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
2423: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2424: p_msg_text => 'Begin. P_COMMIT:'||p_commit||
2425: ' P_PREVIEW_FLAG: '||p_preview_flag||
2426: ' P_UD_SESSION_ID: '||p_ud_session_id||
2480: -- ============================================================================
2481: -- STEP 1: DELETE existing dependents for the candidate if the undo list has
2482: -- never been run.
2483: -- ============================================================================
2484: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
2485: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2486: p_msg_text => 'STEP 1: DELETE existing dependents for the candidate.');
2487:
2488: IF p_preview_flag = 'N' THEN
2521: -- ============================================================================
2522: -- STEP 2: Generate UPDATE dependents.
2523: -- Update dependents are only applicable to ACCOUNT tables.
2524: -- ============================================================================
2525: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
2526: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2527: p_msg_text => 'STEP 2: Generate UPDATE dependents.');
2528:
2529: BEGIN
2570: END LOOP;
2571:
2572: IF v_count = 0 THEN
2573: -- If no UPDATE dependents found, post message
2574: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
2575: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2576: p_app_name =>'FEM',
2577: p_msg_name => 'FEM_UD_NO_UPDATE_DEP_FOUND_TXT');
2578: END IF;
2594: WHEN others THEN
2595: v_object_name := to_char(p_object_id);
2596: END;
2597:
2598: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
2599: p_msg_name => 'FEM_UD_CANNOT_GEN_CAND_DEP_ERR',
2600: p_token1 => 'REQUEST_ID',
2601: p_value1 => p_request_id,
2602: p_token2 => 'OBJECT_NAME',
2613: -- Original logic: If p_ignore_dependency_errs_flag = 'Y', and p_dependency_type='ALL'
2614: -- but chain dependents are found, THEN post an error message.
2615: -- ============================================================================
2616: IF p_dependency_type = 'ALL' THEN
2617: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
2618: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2619: p_msg_text => 'STEP 3: Generate CHAIN dependents.');
2620:
2621: v_count := 0;
2647:
2648: END LOOP;
2649:
2650: IF v_count = 0 THEN -- If no CHAIN dependents found, post message
2651: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
2652: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2653: p_msg_name => 'FEM_UD_NO_CHAIN_DEP_FOUND_TXT');
2654: END IF;
2655:
2662: -- (Added to satisfy bug 5103063)
2663: -- ============================================================================
2664: IF p_preview_flag = 'Y' THEN
2665: IF (pc_log_level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2666: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
2667: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2668: p_msg_text => 'STEP 3.5: Generate "REPEAT" dependents.');
2669: END IF;
2670:
2685: END;
2686: END LOOP;
2687:
2688: IF (pc_log_level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2689: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
2690: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2691: p_msg_text => 'STEP 3.5: Number of REPEAT dependencies found: '||v_count);
2692: END IF;
2693: END IF;
2839: IF FND_API.To_Boolean( p_commit ) THEN
2840: COMMIT WORK;
2841: END IF;
2842:
2843: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
2844: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2845: p_msg_text => 'End. x_return_status: '||x_return_status);
2846:
2847: FND_MSG_PUB.Count_And_Get
2852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2853: ROLLBACK TO generate_cand_dependents_pub;
2854: x_return_status := pc_ret_sts_unexp_error;
2855:
2856: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,
2857: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2858: p_app_name =>'FEM',
2859: p_msg_name => 'FEM_BAD_P_API_VER_ERR',p_token1 => 'VALUE',
2860: p_value1 => p_api_version, p_trans1 => 'N');
2858: p_app_name =>'FEM',
2859: p_msg_name => 'FEM_BAD_P_API_VER_ERR',p_token1 => 'VALUE',
2860: p_value1 => p_api_version, p_trans1 => 'N');
2861:
2862: fem_engines_pkg.put_message(
2863: p_app_name =>'FEM',
2864: p_msg_name => 'FEM_BAD_P_API_VER_ERR',p_token1 => 'VALUE',
2865: p_value1 => p_api_version, p_trans1 => 'N');
2866:
2870:
2871: WHEN e_invalid_preview_flag THEN
2872: x_return_status := pc_ret_sts_error;
2873:
2874: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
2875: p_msg_name => 'FEM_UD_INVALID_PREVIEW_FLAG');
2876:
2877: FND_MSG_PUB.Count_And_Get
2878: (p_count => x_msg_count,
2880:
2881: WHEN e_invalid_undolist_objdefid THEN
2882: x_return_status := pc_ret_sts_error;
2883:
2884: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
2885: p_msg_name => 'FEM_UD_INVALID_UDLISTOBJDEFID');
2886:
2887: FND_MSG_PUB.Count_And_Get
2888: (p_count => x_msg_count,
2890:
2891: WHEN e_invalid_dependency_type THEN
2892: x_return_status := pc_ret_sts_error;
2893:
2894: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
2895: p_msg_name => 'FEM_UD_INVALID_DEPENDENCY_TYPE');
2896:
2897: FND_MSG_PUB.Count_And_Get
2898: (p_count => x_msg_count,
2900:
2901: WHEN e_invalid_session_id THEN
2902: x_return_status := pc_ret_sts_error;
2903:
2904: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
2905: p_msg_name => 'FEM_UD_INVALID_SESSIONID');
2906:
2907: FND_MSG_PUB.Count_And_Get
2908: (p_count => x_msg_count,
2910:
2911: WHEN e_objexec_is_running THEN
2912: x_return_status := pc_ret_sts_error;
2913:
2914: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
2915: p_msg_name => 'FEM_UD_OBJEXEC_IS_RUNNING_ERR');
2916:
2917: FND_MSG_PUB.Count_And_Get
2918: (p_count => x_msg_count,
2920:
2921: WHEN e_cannot_read_object THEN
2922: x_return_status := pc_ret_sts_error;
2923:
2924: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
2925: p_msg_name => 'FEM_UD_CANNOT_READ_OBJECT_ERR');
2926:
2927: FND_MSG_PUB.Count_And_Get
2928: (p_count => x_msg_count,
2934:
2935: -- Log the call stack and the Oracle error message to
2936: -- FND_LOG with the "unexpected exception" severity level.
2937:
2938: FEM_ENGINES_PKG.Tech_Message
2939: (p_severity => pc_log_level_unexpected,
2940: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2941: p_msg_text => SQLERRM);
2942:
2939: (p_severity => pc_log_level_unexpected,
2940: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2941: p_msg_text => SQLERRM);
2942:
2943: FEM_ENGINES_PKG.Tech_Message
2944: (p_severity => pc_log_level_unexpected,
2945: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2946: p_msg_text => dbms_utility.format_call_stack);
2947:
2945: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
2946: p_msg_text => dbms_utility.format_call_stack);
2947:
2948: -- Log the Oracle error message to the stack.
2949: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
2950: p_msg_name => 'FEM_UNEXPECTED_ERROR',
2951: P_TOKEN1 => 'ERR_MSG',
2952: P_VALUE1 => SQLERRM);
2953:
2994: WHERE ud_session_id = p_ud_session_id;
2995:
2996: BEGIN
2997:
2998: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
2999: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3000: p_msg_text => 'Begin. P_COMMIT:'||p_commit||
3001: ' P_PREVIEW_FLAG: '||p_preview_flag||
3002: ' P_UD_SESSION_ID: '||p_ud_session_id||
3046: -- Validate candidates.
3047: -- ============================================================================
3048: v_count_candidates := 0;
3049: IF p_preview_flag = 'N' THEN
3050: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3051: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3052: p_msg_text => 'I am in the section where p_preview_flag = ''N''.');
3053:
3054: FOR a_candidate IN c1 LOOP
3053:
3054: FOR a_candidate IN c1 LOOP
3055: v_count_candidates := c1%ROWCOUNT;
3056:
3057: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3058: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3059: p_msg_text => 'Candidate number:'||v_count_candidates||' REQUEST_ID:'||a_candidate.request_id||
3060: ' OBJECT_ID:'||a_candidate.object_id);
3061: -- ============================================================================
3060: ' OBJECT_ID:'||a_candidate.object_id);
3061: -- ============================================================================
3062: -- V1: Check to make sure user can execute/read the object.
3063: -- ============================================================================
3064: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3065: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3066: p_msg_text => 'Checking to make sure user can read/execute the object');
3067:
3068: SELECT count(*) INTO v_count
3077:
3078: -- ============================================================================
3079: -- V2: Check to make sure object execution is not RUNNING.
3080: -- ============================================================================
3081: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3082: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3083: p_msg_text => 'Checking to make sure object is not ''RUNNING''');
3084:
3085: -- Bug 6443224. See earlier comment for this bug.
3125:
3126: -- ============================================================================
3127: -- V3: Check to make sure user can undo all the candidate's dependents.
3128: -- ============================================================================
3129: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3130: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3131: p_msg_text => 'Checking to make sure can undo all candidate''s dependents');
3132:
3133: generate_cand_dependents (
3146: RAISE e_cannot_validate_dependents;
3147: END IF;
3148: END LOOP;
3149: ELSE -- p_preview_flag = 'Y'
3150: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3151: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3152: p_msg_text => 'I am in the section where p_preview_flag = ''Y''.');
3153:
3154: FOR a_candidate IN c2 LOOP
3153:
3154: FOR a_candidate IN c2 LOOP
3155: v_count_candidates := c2%ROWCOUNT;
3156:
3157: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3158: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3159: p_msg_text => 'Candidate number:'||v_count_candidates||' REQUEST_ID:'||a_candidate.request_id||
3160: ' OBJECT_ID:'||a_candidate.object_id);
3161: BEGIN
3161: BEGIN
3162: -- ============================================================================
3163: -- V1: Check to make sure user can execute/read the object.
3164: -- ============================================================================
3165: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3166: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3167: p_msg_text => 'Checking to make sure user can read/execute the object');
3168:
3169: SELECT count(*) INTO v_count
3178:
3179: -- ============================================================================
3180: -- V2: Check to make sure object execution is not RUNNING.
3181: -- ============================================================================
3182: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3183: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3184: p_msg_text => 'Checking to make sure object is not ''RUNNING''');
3185:
3186: -- Bug 6443224. See earlier comment for this bug.
3226:
3227: -- ============================================================================
3228: -- V3: Check to make sure user can undo all the candidate's dependents.
3229: -- ============================================================================
3230: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3231: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3232: p_msg_text => 'Checking to make sure can undo all candidate''s dependents');
3233:
3234: generate_cand_dependents (
3250: -- ============================================================================
3251: -- Since the candidate has passed all validations, set its validation
3252: -- status code = 'FEM_UD_VALID_TXT'.
3253: -- ============================================================================
3254: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3255: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3256: p_msg_text => 'Set candidate''s status to ''FEM_UD_VALID_TXT''');
3257:
3258: UPDATE fem_ud_prview_candidates
3300: IF FND_API.To_Boolean( p_commit ) THEN
3301: COMMIT WORK;
3302: END IF;
3303:
3304: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
3305: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3306: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
3307:
3308: EXCEPTION
3308: EXCEPTION
3309: WHEN e_invalid_preview_flag THEN
3310: x_return_status := pc_ret_sts_error;
3311:
3312: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
3313: p_msg_name => 'FEM_UD_INVALID_PREVIEW_FLAG');
3314:
3315: FND_MSG_PUB.Count_And_Get
3316: (p_count => x_msg_count,
3317: p_data => x_msg_data);
3318: WHEN e_invalid_undolist_objdefid THEN
3319: x_return_status := pc_ret_sts_error;
3320:
3321: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
3322: p_msg_name => 'FEM_UD_INVALID_UDLISTOBJDEFID');
3323:
3324: FND_MSG_PUB.Count_And_Get
3325: (p_count => x_msg_count,
3326: p_data => x_msg_data);
3327: WHEN e_invalid_session_id THEN
3328: x_return_status := pc_ret_sts_error;
3329:
3330: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
3331: p_msg_name => 'FEM_UD_INVALID_SESSIONID');
3332:
3333: FND_MSG_PUB.Count_And_Get
3334: (p_count => x_msg_count,
3335: p_data => x_msg_data);
3336: WHEN e_cannot_validate_dependents THEN
3337: x_return_status := pc_ret_sts_error;
3338:
3339: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
3340: p_msg_name => 'FEM_UD_CANNOT_UNDO_DEPENDENTS');
3341:
3342: FND_MSG_PUB.Count_And_Get
3343: (p_count => x_msg_count,
3344: p_data => x_msg_data);
3345: WHEN e_cannot_read_object THEN
3346: x_return_status := pc_ret_sts_error;
3347:
3348: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
3349: p_msg_name => 'FEM_UD_CANNOT_READ_OBJECT_ERR');
3350:
3351: FND_MSG_PUB.Count_And_Get
3352: (p_count => x_msg_count,
3353: p_data => x_msg_data);
3354: WHEN e_objexec_is_running THEN
3355: x_return_status := pc_ret_sts_error;
3356:
3357: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
3358: p_msg_name => 'FEM_UD_OBJEXEC_IS_RUNNING_ERR');
3359:
3360: FND_MSG_PUB.Count_And_Get
3361: (p_count => x_msg_count,
3363: WHEN e_list_has_no_candidates THEN
3364: ROLLBACK TO validate_candidates_pub;
3365: x_return_status := pc_ret_sts_error;
3366:
3367: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
3368: p_msg_name => 'FEM_UD_NO_CANDIDATES_ERR');
3369:
3370: fem_engines_pkg.tech_message(p_severity => pc_log_level_error,
3371: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3366:
3367: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
3368: p_msg_name => 'FEM_UD_NO_CANDIDATES_ERR');
3369:
3370: fem_engines_pkg.tech_message(p_severity => pc_log_level_error,
3371: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3372: p_app_name =>'FEM',
3373: p_msg_name => 'FEM_UD_NO_CANDIDATES_ERR');
3374:
3379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3380: ROLLBACK TO validate_candidates_pub;
3381: x_return_status := pc_ret_sts_unexp_error;
3382:
3383: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,
3384: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3385: p_app_name =>'FEM',
3386: p_msg_name => 'FEM_BAD_P_API_VER_ERR',p_token1 => 'VALUE',
3387: p_value1 => p_api_version, p_trans1 => 'N');
3392:
3393: -- Log the call stack and the Oracle error message to
3394: -- FND_LOG with the "unexpected exception" severity level.
3395:
3396: FEM_ENGINES_PKG.Tech_Message
3397: (p_severity => pc_log_level_unexpected,
3398: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3399: p_msg_text => SQLERRM);
3400:
3397: (p_severity => pc_log_level_unexpected,
3398: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3399: p_msg_text => SQLERRM);
3400:
3401: FEM_ENGINES_PKG.Tech_Message
3402: (p_severity => pc_log_level_unexpected,
3403: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3404: p_msg_text => dbms_utility.format_call_stack);
3405:
3403: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3404: p_msg_text => dbms_utility.format_call_stack);
3405:
3406: -- Log the Oracle error message to the stack.
3407: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
3408: p_msg_name => 'FEM_UNEXPECTED_ERROR',
3409: P_TOKEN1 => 'ERR_MSG',
3410: P_VALUE1 => SQLERRM);
3411:
3482: ORDER BY column_name;
3483:
3484: BEGIN
3485:
3486: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
3487: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3488: p_msg_text => 'Begin. P_UNDO_LIST_OBJ_DEF_ID: '||p_undo_list_obj_def_id||
3489: ' P_REQUEST_ID: '||p_request_id||
3490: ' P_OBJECT_ID: '||p_object_id||
3503:
3504: EXCEPTION
3505: WHEN NO_DATA_FOUND THEN
3506:
3507: fem_engines_pkg.tech_message(p_severity => pc_log_level_event,
3508: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3509: p_msg_text => 'Could not retrieve OBJECT_TYPE_CODE for OBJECT_ID: '||p_object_id);
3510:
3511: END;
3518: -- ============================================================================
3519: -- STEP 1:
3520: -- Set status of object execution in undo list to 'RUNNING'.
3521: -- ============================================================================
3522: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3523: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3524: p_msg_text => 'STEP 1: Set status of object execution in undo list to ''RUNNING''');
3525:
3526: -- Get rule name
3533: WHEN others THEN
3534: v_object_name := to_char(p_object_id);
3535: END;
3536:
3537: fem_engines_pkg.user_message(p_app_name =>'FEM',
3538: p_msg_name => 'FEM_UD_PROCESSING_OBJEXEC_TXT',
3539: p_token1 => 'RULE_NAME',
3540: p_value1 => v_object_name,
3541: p_token2 => 'REQUEST_ID',
3540: p_value1 => v_object_name,
3541: p_token2 => 'REQUEST_ID',
3542: p_value2 => p_request_id);
3543:
3544: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3545: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3546: p_app_name =>'FEM',
3547: p_msg_name => 'FEM_UD_PROCESSING_OBJEXEC_TXT',
3548: p_token1 => 'RULE_NAME',
3569: COMMIT;
3570:
3571: IF v_undo_flag = 'N' THEN
3572:
3573: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3574: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3575: p_msg_text => 'v_undo_flag:'||v_undo_flag||' IGNORE Step 2:Process statements in FEM_PL_TABLES');
3576:
3577: ELSE
3579: -- ============================================================================
3580: -- STEP 2:
3581: -- Process statements in FEM_PL_TABLES.
3582: -- ============================================================================
3583: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3584: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3585: p_msg_text => 'STEP 2: Process statements in FEM_PL_TABLES');
3586:
3587: FOR atbl IN C1 LOOP
3584: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3585: p_msg_text => 'STEP 2: Process statements in FEM_PL_TABLES');
3586:
3587: FOR atbl IN C1 LOOP
3588: fem_engines_pkg.tech_message(p_severity => pc_log_level_event,
3589: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3590: p_app_name => 'FEM',
3591: p_msg_name => 'FEM_UD_TABLE_STATEMENT_TXT',
3592: p_token1 => 'TABLE_NAME',
3647: INTO v_rows_processed
3648: FROM fem_mp_process_ctl_t
3649: WHERE req_id = pv_request_id;
3650:
3651: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3652: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3653: p_msg_text => 'Number of rows processed:'||v_rows_processed||' ');
3654:
3655: ELSIF v_mp_exception_code = 'FEM_MP_NO_DATA_SLICES_ERR' THEN
3654:
3655: ELSIF v_mp_exception_code = 'FEM_MP_NO_DATA_SLICES_ERR' THEN
3656: v_rows_processed := 0;
3657:
3658: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3659: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3660: p_msg_text => 'Number of rows processed: 0');
3661:
3662: ELSE
3659: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3660: p_msg_text => 'Number of rows processed: 0');
3661:
3662: ELSE
3663: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3664: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3665: p_msg_text => 'MP framework return status:'||v_mp_prg_stat||
3666: ' MP exception code:'||v_mp_exception_code||' SQL statement: '||v_sql_stmt);
3667:
3668: RAISE e_mp_error;
3669:
3670: END IF;
3671:
3672: fem_engines_pkg.user_message(p_app_name =>'FEM',
3673: p_msg_name => 'FEM_UD_DELETE_SUMMARY_TXT',
3674: p_token1 => 'NUM_ROWS',
3675: p_value1 => v_rows_processed,
3676: p_token2 => 'TABLE_NAME',
3707:
3708: IF v_count_cols = 0 THEN
3709: -- No column found
3710:
3711: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
3712: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3713: p_app_name =>'FEM',
3714: p_msg_name => 'FEM_UD_NO_UPD_COL_FOUND_WRN');
3715:
3748: INTO v_rows_processed
3749: FROM fem_mp_process_ctl_t
3750: WHERE req_id = pv_request_id;
3751:
3752: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3753: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3754: p_msg_text => 'Number of rows processed:'||v_rows_processed||' ');
3755: ELSIF v_mp_exception_code = 'FEM_MP_NO_DATA_SLICES_ERR' THEN
3756: v_rows_processed := 0;
3754: p_msg_text => 'Number of rows processed:'||v_rows_processed||' ');
3755: ELSIF v_mp_exception_code = 'FEM_MP_NO_DATA_SLICES_ERR' THEN
3756: v_rows_processed := 0;
3757:
3758: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3759: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3760: p_msg_text => 'Number of rows processed: 0');
3761: ELSE
3762: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3758: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3759: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3760: p_msg_text => 'Number of rows processed: 0');
3761: ELSE
3762: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3763: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3764: p_msg_text => 'MP framework return status:'||v_mp_prg_stat||
3765: ' MP exception code:'||v_mp_exception_code||' SQL statement: '||v_sql_stmt);
3766:
3766:
3767: RAISE e_mp_error;
3768: END IF;
3769:
3770: fem_engines_pkg.user_message(p_app_name =>'FEM',
3771: p_msg_name => 'FEM_UD_UPDATE_SUMMARY_TXT',
3772: p_token1 => 'NUM_ROWS',
3773: p_value1 => v_rows_processed,
3774: p_token2 => 'TABLE_NAME',
3834: INTO v_rows_processed
3835: FROM fem_mp_process_ctl_t
3836: WHERE req_id = pv_request_id;
3837:
3838: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3839: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3840: p_msg_text => 'Number of rows processed:'||v_rows_processed||' ');
3841: ELSIF v_mp_exception_code = 'FEM_MP_NO_DATA_SLICES_ERR' THEN
3842: v_rows_processed := 0;
3840: p_msg_text => 'Number of rows processed:'||v_rows_processed||' ');
3841: ELSIF v_mp_exception_code = 'FEM_MP_NO_DATA_SLICES_ERR' THEN
3842: v_rows_processed := 0;
3843:
3844: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3845: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3846: p_msg_text => 'Number of rows processed: 0');
3847: ELSE
3848: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3844: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3845: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3846: p_msg_text => 'Number of rows processed: 0');
3847: ELSE
3848: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3849: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3850: p_msg_text => 'MP framework return status:'||v_mp_prg_stat||
3851: ' MP exception code:'||v_mp_exception_code||' SQL statement: '||v_sql_stmt);
3852:
3852:
3853: RAISE e_mp_error;
3854: END IF;
3855:
3856: fem_engines_pkg.user_message(p_app_name =>'FEM',
3857: p_msg_name => 'FEM_UD_DELETE_SUMMARY_TXT',
3858: p_token1 => 'NUM_ROWS',
3859: p_value1 => v_rows_processed,
3860: p_token2 => 'TABLE_NAME',
3888:
3889: IF v_count_cols = 0 THEN
3890: -- No column found
3891:
3892: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
3893: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3894: p_app_name =>'FEM',
3895: p_msg_name => 'FEM_UD_NO_UPD_COL_FOUND_WRN');
3896:
3931: INTO v_rows_processed
3932: FROM fem_mp_process_ctl_t
3933: WHERE req_id = pv_request_id;
3934:
3935: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3936: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3937: p_msg_text => 'Number of rows processed:'||v_rows_processed||' ');
3938:
3939: ELSIF v_mp_exception_code = 'FEM_MP_NO_DATA_SLICES_ERR' THEN
3938:
3939: ELSIF v_mp_exception_code = 'FEM_MP_NO_DATA_SLICES_ERR' THEN
3940: v_rows_processed := 0;
3941:
3942: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3943: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3944: p_msg_text => 'Number of rows processed: 0');
3945:
3946: ELSE
3944: p_msg_text => 'Number of rows processed: 0');
3945:
3946: ELSE
3947:
3948: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
3949: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3950: p_msg_text => 'MP framework return status:'||v_mp_prg_stat||
3951: ' MP exception code:'||v_mp_exception_code||' SQL statement: '||v_sql_stmt);
3952:
3952:
3953: RAISE e_mp_error;
3954: END IF;
3955:
3956: fem_engines_pkg.user_message(p_app_name =>'FEM',
3957: p_msg_name => 'FEM_UD_UPDATE_SUMMARY_TXT',
3958: p_token1 => 'NUM_ROWS',
3959: p_value1 => v_rows_processed,
3960: p_token2 => 'TABLE_NAME',
3977: END LOOP;
3978:
3979: IF v_count_tbls = 0 THEN
3980: -- If no table found then
3981: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
3982: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3983: p_app_name =>'FEM',
3984: p_msg_name => 'FEM_UD_NO_TABLE_FOUND_WRN');
3985:
3982: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3983: p_app_name =>'FEM',
3984: p_msg_name => 'FEM_UD_NO_TABLE_FOUND_WRN');
3985:
3986: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
3987: p_msg_name => 'FEM_UD_NO_TABLE_FOUND_WRN');
3988: END IF;
3989:
3990: Get_Put_Messages(
3998: -- STEP 3:
3999: -- Delete data from the data location tables (FEM_DL_xxxx).
4000: -- This is only required in cases where fem_object_Types.undo_flag='Y'.
4001: -- ============================================================================
4002: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4003: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4004: p_msg_text => 'STEP 3: Delete data from the data location tables (FEM_DL_xxxx).');
4005:
4006: fem_dimension_util_pkg.unregister_data_location(
4012: -- ============================================================================
4013: -- STEP 4:
4014: -- Execute all engine specific procedures.
4015: -- ============================================================================
4016: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4017: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4018: p_msg_text => 'STEP 4: Execute all engine specific procedures.');
4019:
4020: IF v_object_type_code IN ('OGL_INTG_BAL_RULE','XGL_INTEGRATION') THEN
4050: -- STEP 5:
4051: -- Remove object execution log.
4052: -- ============================================================================
4053:
4054: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4055: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4056: p_msg_text => 'STEP 5: Remove object execution log.');
4057:
4058: delete_execution_log (
4077: -- ============================================================================
4078: -- STEP 6:
4079: -- Update status of object execution in undo list.
4080: -- ============================================================================
4081: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4082: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4083: p_msg_text => 'STEP 6: Update status of object execution in undo list to SUCCESS.');
4084:
4085: IF p_obj_exec_type = 'DEPENDENT' THEN
4099: AND object_id = p_object_id;
4100: END IF;
4101: COMMIT;
4102:
4103: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
4104: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4105: p_msg_text => 'End. x_return_status: '||x_return_status);
4106:
4107: EXCEPTION
4119: AND table_name = v_tab_name;
4120: EXCEPTION WHEN others THEN null;
4121: END;
4122:
4123: FEM_ENGINES_PKG.tech_message(
4124: p_severity => pc_log_level_statement,
4125: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4126: p_msg_text => 'Cannot undo table '||v_tab_name
4127: ||' if it belongs to '||v_tab_class||' table class.');
4125: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4126: p_msg_text => 'Cannot undo table '||v_tab_name
4127: ||' if it belongs to '||v_tab_class||' table class.');
4128:
4129: FEM_ENGINES_PKG.tech_message(
4130: p_severity => pc_log_level_statement,
4131: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4132: p_msg_text => 'Statement type = '||v_stmt_type);
4133:
4130: p_severity => pc_log_level_statement,
4131: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4132: p_msg_text => 'Statement type = '||v_stmt_type);
4133:
4134: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
4135: p_msg_name => 'FEM_UD_ACTION_NOT_SUPPORTED',
4136: p_token1 => 'TAB_NAME',
4137: p_value1 => v_tab_name);
4138:
4136: p_token1 => 'TAB_NAME',
4137: p_value1 => v_tab_name);
4138:
4139: -- Update status of object execution in undo list.
4140: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4141: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4142: p_msg_text => 'Update status of object execution in undo list to ERROR_RERUN');
4143:
4144: IF p_obj_exec_type = 'DEPENDENT' THEN
4168: COMMIT;
4169:
4170: WHEN e_mp_error THEN
4171: x_return_status := pc_ret_sts_error;
4172: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
4173: p_msg_name => 'FEM_MP_ERR');
4174:
4175: -- Update status of object execution in undo list.
4176: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4172: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
4173: p_msg_name => 'FEM_MP_ERR');
4174:
4175: -- Update status of object execution in undo list.
4176: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4177: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4178: p_msg_text => 'Update status of object execution in undo list to ERROR_RERUN');
4179:
4180: IF p_obj_exec_type = 'DEPENDENT' THEN
4206: WHEN e_engine_specific_proc_err THEN
4207: x_return_status := pc_ret_sts_error;
4208:
4209: -- Update status of object execution in undo list.
4210: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4211: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4212: p_msg_text => 'Update status of object execution in undo list to ERROR_RERUN');
4213:
4214: IF p_obj_exec_type = 'DEPENDENT' THEN
4237: COMMIT;
4238: WHEN e_cannot_delete_execution_log THEN
4239: x_return_status := pc_ret_sts_error;
4240:
4241: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
4242: p_msg_name => 'FEM_UD_CANNOT_DELETE_EXEC_LOG');
4243:
4244: -- Update status of object execution in undo list.
4245: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4241: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
4242: p_msg_name => 'FEM_UD_CANNOT_DELETE_EXEC_LOG');
4243:
4244: -- Update status of object execution in undo list.
4245: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4246: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4247: p_msg_text => 'Update status of object execution in undo list to ERROR_RERUN');
4248:
4249: IF p_obj_exec_type = 'DEPENDENT' THEN
4276:
4277: -- Log the call stack and the Oracle error message to
4278: -- FND_LOG with the "unexpected exception" severity level.
4279:
4280: FEM_ENGINES_PKG.Tech_Message
4281: (p_severity => pc_log_level_unexpected,
4282: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4283: p_msg_text => SQLERRM);
4284:
4281: (p_severity => pc_log_level_unexpected,
4282: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4283: p_msg_text => SQLERRM);
4284:
4285: FEM_ENGINES_PKG.Tech_Message
4286: (p_severity => pc_log_level_unexpected,
4287: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4288: p_msg_text => dbms_utility.format_call_stack);
4289:
4287: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4288: p_msg_text => dbms_utility.format_call_stack);
4289:
4290: -- Log the Oracle error message to the stack.
4291: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
4292: p_msg_name => 'FEM_UNEXPECTED_ERROR',
4293: P_TOKEN1 => 'ERR_MSG',
4294: P_VALUE1 => SQLERRM);
4295:
4293: P_TOKEN1 => 'ERR_MSG',
4294: P_VALUE1 => SQLERRM);
4295:
4296: -- Update status of object execution in undo list.
4297: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4298: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4299: p_msg_text => 'Update status of object execution in undo list to ERROR_RERUN.');
4300:
4301: IF p_obj_exec_type = 'DEPENDENT' THEN
4340: e_post_process EXCEPTION;
4341: v_exec_status VARCHAR2(150);
4342:
4343: BEGIN
4344: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
4345: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4346: p_msg_text => 'Begin. P_OBJECT_ID: '||p_undo_list_obj_id||
4347: ' P_EXECUTION_STATUS: '||p_execution_status);
4348:
4366: X_RETURN_STATUS => v_API_return_status);
4367:
4368: IF v_api_return_status <> pc_ret_sts_success THEN
4369:
4370: FEM_ENGINES_PKG.USER_MESSAGE
4371: (P_APP_NAME => 'FEM'
4372: ,P_MSG_NAME => 'FEM_PL_UPD_OBJEXEC_STATUS_ERR'
4373: ,P_TOKEN1 => 'REQUEST_ID'
4374: ,P_VALUE1 => pv_request_id
4379: ,P_TOKEN3 => 'EXEC_STATUS'
4380: ,P_VALUE3 => p_execution_status
4381: ,P_TRANS3 => 'N');
4382:
4383: FEM_ENGINES_PKG.USER_MESSAGE
4384: (P_APP_NAME => 'FEM'
4385: ,P_MSG_NAME => 'FEM_POST_PROC_ERR');
4386:
4387: Get_Put_Messages(
4405: X_RETURN_STATUS => v_API_return_status);
4406:
4407: IF v_api_return_status <> pc_ret_sts_success THEN
4408:
4409: FEM_ENGINES_PKG.USER_MESSAGE
4410: (P_APP_NAME => 'FEM'
4411: ,P_MSG_NAME => 'FEM_PL_UPD_REQUEST_STATUS_ERR'
4412: ,P_TOKEN1 => 'REQUEST_ID'
4413: ,P_VALUE1 => pv_request_id
4415: ,P_TOKEN2 => 'EXEC_STATUS'
4416: ,P_VALUE2 => p_execution_status
4417: ,P_TRANS2 => 'N');
4418:
4419: FEM_ENGINES_PKG.USER_MESSAGE
4420: (P_APP_NAME => 'FEM'
4421: ,P_MSG_NAME => 'FEM_POST_PROC_ERR');
4422:
4423: Get_Put_Messages(
4440: END;
4441:
4442: -- Set status of request
4443: IF p_execution_status = 'SUCCESS' THEN
4444: FEM_ENGINES_PKG.USER_MESSAGE
4445: (P_APP_NAME => 'FEM'
4446: ,P_MSG_NAME => 'FEM_EXEC_SUCCESS');
4447:
4448: pv_concurrent_status := fnd_concurrent.set_completion_status('NORMAL',null);
4446: ,P_MSG_NAME => 'FEM_EXEC_SUCCESS');
4447:
4448: pv_concurrent_status := fnd_concurrent.set_completion_status('NORMAL',null);
4449:
4450: FEM_ENGINES_PKG.Tech_Message
4451: (p_severity => pc_log_level_unexpected,
4452: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4453: P_MSG_NAME => 'FEM_EXEC_SUCCESS');
4454: ELSIF p_execution_status IN ('ERROR_RERUN') THEN
4451: (p_severity => pc_log_level_unexpected,
4452: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4453: P_MSG_NAME => 'FEM_EXEC_SUCCESS');
4454: ELSIF p_execution_status IN ('ERROR_RERUN') THEN
4455: FEM_ENGINES_PKG.USER_MESSAGE
4456: (P_APP_NAME => 'FEM'
4457: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
4458:
4459: pv_concurrent_status := fnd_concurrent.set_completion_status('ERROR',null);
4457: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
4458:
4459: pv_concurrent_status := fnd_concurrent.set_completion_status('ERROR',null);
4460:
4461: FEM_ENGINES_PKG.Tech_Message
4462: (p_severity => pc_log_level_unexpected,
4463: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4464: P_MSG_NAME => 'FEM_EXEC_RERUN');
4465: END IF;
4463: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4464: P_MSG_NAME => 'FEM_EXEC_RERUN');
4465: END IF;
4466:
4467: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
4468: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4469: p_msg_text => 'End');
4470:
4471: EXCEPTION
4474:
4475: -- Log the call stack and the Oracle error message to
4476: -- FND_LOG with the "unexpected exception" severity level.
4477:
4478: FEM_ENGINES_PKG.Tech_Message
4479: (p_severity => pc_log_level_unexpected,
4480: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4481: p_msg_text => SQLERRM);
4482:
4479: (p_severity => pc_log_level_unexpected,
4480: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4481: p_msg_text => SQLERRM);
4482:
4483: FEM_ENGINES_PKG.Tech_Message
4484: (p_severity => pc_log_level_unexpected,
4485: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4486: p_msg_text => dbms_utility.format_call_stack);
4487:
4485: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4486: p_msg_text => dbms_utility.format_call_stack);
4487:
4488: -- Log the Oracle error message to the stack.
4489: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
4490: p_msg_name => 'FEM_UNEXPECTED_ERROR',
4491: P_TOKEN1 => 'ERR_MSG',
4492: P_VALUE1 => SQLERRM);
4493:
4542: FROM fem_pl_object_executions
4543: WHERE object_id = p_undo_list_obj_id;
4544:
4545: BEGIN
4546: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
4547: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4548: p_msg_text => 'Begin. P_UNDO_LIST_OBJ_ID: '||p_undo_list_obj_id);
4549:
4550: -- ============================================================================
4549:
4550: -- ============================================================================
4551: -- VALIDATIONS
4552: -- ============================================================================
4553: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4554: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4555: p_msg_text => 'Begin VALIDATIONS: '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
4556:
4557: -- ============================================================================
4556:
4557: -- ============================================================================
4558: -- V01: Check to see if p_undo_list_obj_id is for a valid undo list.
4559: -- ============================================================================
4560: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4561: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4562: p_msg_text => 'V01: Check to see if p_undo_list_obj_id is for a valid undo list.');
4563:
4564: BEGIN
4579: -- Bug 4309949: Ignore folder security for Undo rules
4580: -- ============================================================================
4581: -- V02: Check to see if user has privileges to execute the list.
4582: -- ============================================================================
4583: -- fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4584: -- p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4585: -- p_msg_text => 'V02: Check to see if user can read p_undo_list_obj_id.');
4586:
4587: -- BEGIN
4636:
4637: -- ============================================================================
4638: -- REGISTRATION
4639: -- ============================================================================
4640: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4641: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4642: p_msg_text => 'Begin REGISTRATION: '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
4643:
4644: -- ============================================================================
4726: -- ============================================================================
4727: -- R04: COMMIT registration steps
4728: -- ============================================================================
4729: COMMIT;
4730: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4731: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4732: p_msg_text => 'End REGISTRATION: '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
4733:
4734: -- ============================================================================
4733:
4734: -- ============================================================================
4735: -- PROCESSING
4736: -- ============================================================================
4737: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4738: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4739: p_msg_text => 'Begin PROCESSING: '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
4740:
4741:
4788: END IF;
4789:
4790: -- Post following message to output log before undoing executions:
4791: -- "Removing the following rule executions:"
4792: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
4793: p_msg_name => 'FEM_UD_PROCESSING_LIST_TXT');
4794:
4795: -- Process all candidates in the list.
4796: FOR a_candidate IN c10 LOOP
4850:
4851: END LOOP;
4852:
4853: IF v_count = 0 THEN
4854: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
4855: p_msg_name => 'FEM_UD_NO_CANDIDATES_ERR');
4856: ELSE
4857: -- If at least one candidate was processed, print a new line in the
4858: -- concurrent output log to separate out the messages printed out
4857: -- If at least one candidate was processed, print a new line in the
4858: -- concurrent output log to separate out the messages printed out
4859: -- in the call to perform_undo_action from any more messages to be
4860: -- printed out later in this execution.
4861: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
4862: p_msg_name => 'FEM_NEW_LINE');
4863: END IF;
4864:
4865: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4861: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
4862: p_msg_name => 'FEM_NEW_LINE');
4863: END IF;
4864:
4865: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4866: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4867: p_msg_text => 'End PROCESSING: '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
4868:
4869:
4871: -- Since the undo run was successful, delete the registration information for
4872: -- this execution, and all executions of this undo list, then also delete
4873: -- the undo list.
4874: -- ============================================================================
4875: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4876: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4877: p_msg_text => 'Since the undo run was successful, delete the undo list and its registration information.');
4878:
4879: -- Delete object execution from process lock tables (FEM_PL_xxxx).
4876: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4877: p_msg_text => 'Since the undo run was successful, delete the undo list and its registration information.');
4878:
4879: -- Delete object execution from process lock tables (FEM_PL_xxxx).
4880: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4881: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4882: p_msg_text => 'Delete undo run from process lock tables (FEM_PL_xxxx).');
4883:
4884: FOR undo_objexec IN c3 LOOP
4898: p_msg_data => v_msg_data,
4899: p_user_msg => 'Y',
4900: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name||'.delete_execution_log');
4901:
4902: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
4903: p_msg_name => 'FEM_UD_CANNOT_DELETE_UNDOEXEC');
4904:
4905: END IF;
4906:
4929: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name);
4930:
4931: IF v_return_status <> pc_ret_sts_success THEN
4932:
4933: fem_engines_pkg.user_message(p_app_name =>'FEM',
4934: p_msg_name => 'FEM_UD_CANNOT_DELETE_LIST_ERR');
4935:
4936: END IF;
4937:
4940: -- ============================================================================
4941: set_process_status (p_undo_list_obj_id => p_undo_list_obj_id,
4942: p_undo_list_obj_def_id => v_undo_list_obj_def_id,
4943: p_execution_status => 'SUCCESS');
4944: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
4945: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4946: p_msg_text => 'End. '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
4947: -- ============================================================================
4948: -- EXCEPTIONS
4949: -- ============================================================================
4950: EXCEPTION
4951: WHEN e_invalid_undo_list THEN
4952: ROLLBACK;
4953: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
4954: p_msg_name => 'FEM_UD_INVALID_UNDO_LIST_ERR',
4955: p_token1 => 'OBJECT_ID',
4956: p_value1 => p_undo_list_obj_id,
4957: p_trans1 => 'N');
4955: p_token1 => 'OBJECT_ID',
4956: p_value1 => p_undo_list_obj_id,
4957: p_trans1 => 'N');
4958:
4959: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
4960: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4961: p_msg_name => 'FEM_UD_INVALID_UNDO_LIST_ERR',
4962: p_token1 => 'OBJECT_ID',
4963: p_value1 => p_undo_list_obj_id,
4968: p_execution_status => 'ERROR_RERUN');
4969:
4970: WHEN e_cannot_read_object THEN
4971: ROLLBACK;
4972: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
4973: p_msg_name => 'FEM_UD_CANNOT_READ_OBJECT_ERR');
4974:
4975: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
4976: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4971: ROLLBACK;
4972: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
4973: p_msg_name => 'FEM_UD_CANNOT_READ_OBJECT_ERR');
4974:
4975: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
4976: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
4977: p_msg_name => 'FEM_UD_CANNOT_READ_OBJECT_ERR');
4978:
4979: set_process_status (p_undo_list_obj_id => p_undo_list_obj_id,
4981: p_execution_status => 'ERROR_RERUN');
4982:
4983: WHEN e_dependencies_found THEN
4984: ROLLBACK;
4985: FEM_ENGINES_PKG.user_message (p_app_name =>'FEM',
4986: p_msg_name => 'FEM_UD_DEPENDENTS_FOUND_ERR',
4987: p_token1 => 'OBJECT_ID',
4988: p_value1 => p_undo_list_obj_id,
4989: p_trans1 => 'N');
5009: p_execution_status => 'ERROR_RERUN');
5010:
5011: WHEN e_pl_reg_request_failed THEN
5012: ROLLBACK;
5013: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5014: p_msg_name => 'FEM_PL_REG_REQUEST_ERR');
5015:
5016: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5017: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5012: ROLLBACK;
5013: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5014: p_msg_name => 'FEM_PL_REG_REQUEST_ERR');
5015:
5016: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5017: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5018: p_msg_name =>'FEM_PL_REG_REQUEST_ERR');
5019:
5020: set_process_status (p_undo_list_obj_id => p_undo_list_obj_id,
5022: p_execution_status => 'ERROR_RERUN');
5023:
5024: WHEN e_pl_reg_obj_exec_failed THEN
5025: ROLLBACK;
5026: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5027: p_msg_name => 'FEM_PL_REG_OBJ_EXEC_ERR');
5028:
5029: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5030: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5025: ROLLBACK;
5026: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5027: p_msg_name => 'FEM_PL_REG_OBJ_EXEC_ERR');
5028:
5029: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5030: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5031: p_msg_name =>'FEM_PL_REG_OBJ_EXEC_ERR');
5032:
5033: set_process_status (p_undo_list_obj_id => p_undo_list_obj_id,
5035: p_execution_status => 'ERROR_RERUN');
5036:
5037: WHEN e_pl_reg_obj_def_failed THEN
5038: ROLLBACK;
5039: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5040: p_msg_name => 'FEM_PL_REG_OBJ_DEF_ERR');
5041:
5042: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5043: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5038: ROLLBACK;
5039: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5040: p_msg_name => 'FEM_PL_REG_OBJ_DEF_ERR');
5041:
5042: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5043: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5044: p_msg_name =>'FEM_PL_REG_OBJ_DEF_ERR');
5045:
5046: set_process_status (p_undo_list_obj_id => p_undo_list_obj_id,
5048: p_execution_status => 'ERROR_RERUN');
5049:
5050: WHEN e_cannot_validate_candidates THEN
5051:
5052: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5053: p_msg_name => 'FEM_UD_CANNOT_VAL_CANDIDATES');
5054:
5055: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5056: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5051:
5052: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5053: p_msg_name => 'FEM_UD_CANNOT_VAL_CANDIDATES');
5054:
5055: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5056: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5057: p_msg_name =>'FEM_UD_CANNOT_VAL_CANDIDATES');
5058:
5059: set_process_status (p_undo_list_obj_id => p_undo_list_obj_id,
5061: p_execution_status => 'ERROR_RERUN');
5062:
5063: WHEN e_cannot_undo_obj_exec_err THEN
5064:
5065: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5066: p_msg_name => 'FEM_UD_CANNOT_UNDO_OBJ_EXEC');
5067:
5068: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5069: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5064:
5065: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5066: p_msg_name => 'FEM_UD_CANNOT_UNDO_OBJ_EXEC');
5067:
5068: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5069: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5070: p_msg_name =>'FEM_UD_CANNOT_UNDO_OBJ_EXEC');
5071:
5072: set_process_status (p_undo_list_obj_id => p_undo_list_obj_id,
5074: p_execution_status => 'ERROR_RERUN');
5075:
5076: WHEN e_could_not_process_undo_list THEN
5077: ROLLBACK;
5078: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5079: p_msg_name => 'FEM_UD_INVALID_UNDO_LIST_ERR',
5080: p_token1 => 'OBJECT_ID',
5081: p_value1 => p_undo_list_obj_id,
5082: p_trans1 => 'N');
5080: p_token1 => 'OBJECT_ID',
5081: p_value1 => p_undo_list_obj_id,
5082: p_trans1 => 'N');
5083:
5084: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5085: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5086: p_msg_name => 'FEM_UD_INVALID_UNDO_LIST_ERR',
5087: p_token1 => 'OBJECT_ID',
5088: p_value1 => p_undo_list_obj_id,
5096: -- Unexpected exceptions
5097: -- Log the call stack and the Oracle error message to
5098: -- FND_LOG with the "unexpected exception" severity level.
5099:
5100: FEM_ENGINES_PKG.Tech_Message
5101: (p_severity => pc_log_level_unexpected,
5102: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5103: p_msg_text => SQLERRM);
5104:
5101: (p_severity => pc_log_level_unexpected,
5102: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5103: p_msg_text => SQLERRM);
5104:
5105: FEM_ENGINES_PKG.Tech_Message
5106: (p_severity => pc_log_level_unexpected,
5107: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5108: p_msg_text => dbms_utility.format_call_stack);
5109:
5107: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5108: p_msg_text => dbms_utility.format_call_stack);
5109:
5110: -- Log the Oracle error message to the stack.
5111: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5112: p_msg_name => 'FEM_UNEXPECTED_ERROR',
5113: P_TOKEN1 => 'ERR_MSG',
5114: P_VALUE1 => SQLERRM);
5115:
5158: WHERE c.parent_request_id = pv_request_id
5159: ORDER BY c.request_id;
5160:
5161: BEGIN
5162: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
5163: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5164: p_msg_text => 'Begin.');
5165:
5166:
5178: argument1 => undolist.object_id);
5179:
5180: IF (v_subrequest_id = 0) THEN
5181: v_failed_subrequests := v_failed_subrequests + 1;
5182: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5183: p_msg_name => 'FEM_UD_SUBMIT_LIST_ERR',
5184: P_TOKEN1 => 'OBJECT_ID',
5185: P_VALUE1 => undolist.object_id,
5186: P_TRANS1 => 'N');
5184: P_TOKEN1 => 'OBJECT_ID',
5185: P_VALUE1 => undolist.object_id,
5186: P_TRANS1 => 'N');
5187: ELSE
5188: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5189: p_msg_name => 'FEM_UD_SUBMIT_LIST_TXT',
5190: P_TOKEN1 => 'OBJECT_ID',
5191: P_VALUE1 => undolist.object_id,
5192: P_TRANS1 => 'N',
5197: COMMIT;
5198:
5199: END LOOP;
5200:
5201: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
5202: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5203: p_msg_text => 'Total number of undo lists whose execution date is less than or equal to '||
5204: TO_CHAR(sysdate,'DD-MON-YYYY')||':'||v_total_requests);
5205:
5202: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5203: p_msg_text => 'Total number of undo lists whose execution date is less than or equal to '||
5204: TO_CHAR(sysdate,'DD-MON-YYYY')||':'||v_total_requests);
5205:
5206: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
5207: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5208: p_msg_text => 'Total number of undo lists which were not submitted for processing:'||v_failed_subrequests);
5209:
5210: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
5206: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
5207: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5208: p_msg_text => 'Total number of undo lists which were not submitted for processing:'||v_failed_subrequests);
5209:
5210: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
5211: p_msg_name => 'FEM_UD_SUBMIT_LIST_COMPLTD_TXT');
5212:
5213: -- ============================================================================
5214: -- SET STATUS
5215: -- ============================================================================
5216: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5217: (status => v_prg_stat, message => NULL);
5218:
5219: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
5220: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5221: p_msg_text => 'End. '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
5222: -- ============================================================================
5223: -- EXCEPTIONS
5227: -- Unexpected exceptions
5228: -- Log the call stack and the Oracle error message to
5229: -- FND_LOG with the "unexpected exception" severity level.
5230:
5231: FEM_ENGINES_PKG.Tech_Message
5232: (p_severity => pc_log_level_unexpected,
5233: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5234: p_msg_text => SQLERRM);
5235:
5232: (p_severity => pc_log_level_unexpected,
5233: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5234: p_msg_text => SQLERRM);
5235:
5236: FEM_ENGINES_PKG.Tech_Message
5237: (p_severity => pc_log_level_unexpected,
5238: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5239: p_msg_text => dbms_utility.format_call_stack);
5240:
5238: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5239: p_msg_text => dbms_utility.format_call_stack);
5240:
5241: -- Log the Oracle error message to the stack.
5242: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5243: p_msg_name => 'FEM_UNEXPECTED_ERROR',
5244: P_TOKEN1 => 'ERR_MSG',
5245: P_VALUE1 => SQLERRM,
5246: P_TRANS1 => 'N');
5244: P_TOKEN1 => 'ERR_MSG',
5245: P_VALUE1 => SQLERRM,
5246: P_TRANS1 => 'N');
5247:
5248: fem_engines_pkg.user_message
5249: (p_app_name => 'FEM'
5250: ,p_msg_name => 'FEM_EXEC_RERUN');
5251:
5252: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5287: v_undo_list_exists VARCHAR2(1);
5288:
5289:
5290: BEGIN
5291: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
5292: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5293: p_msg_text => 'Begin. P_REQUEST_ID: '||p_request_id||
5294: ' P_FOLDER_ID: '||p_folder_id||
5295: ' P_OBJECT_ID: '||p_object_id||
5298:
5299: -- ============================================================================
5300: -- VALIDATIONS
5301: -- ============================================================================
5302: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
5303: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5304: p_msg_text => 'Begin VALIDATIONS: '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
5305:
5306: -- ============================================================================
5477: END IF;
5478: -- ============================================================================
5479: -- SET STATUS
5480: -- ============================================================================
5481: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
5482: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5483: p_msg_text => 'End. '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
5484: -- ============================================================================
5485: -- EXCEPTIONS
5485: -- EXCEPTIONS
5486: -- ============================================================================
5487: EXCEPTION
5488: WHEN e_object_execution_not_found THEN
5489: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5490: p_msg_name => 'FEM_UD_OBJ_EXEC_NOT_FOUND_WRN',
5491: p_token1 => 'REQUEST_ID',
5492: p_value1 => p_request_id,
5493: p_trans1 => 'N',
5494: p_token2 => 'OBJECT_ID',
5495: p_value2 => p_object_id,
5496: p_trans2 => 'N');
5497:
5498: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5499: p_msg_name => 'FEM_UD_CANNOT_CREATE_LIST_ERR');
5500:
5501: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5502: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5497:
5498: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5499: p_msg_name => 'FEM_UD_CANNOT_CREATE_LIST_ERR');
5500:
5501: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5502: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5503: p_msg_name => 'FEM_UD_OBJ_EXEC_NOT_FOUND_WRN',
5504: p_token1 => 'REQUEST_ID',
5505: p_value1 => p_request_id,
5507: p_token2 => 'OBJECT_ID',
5508: p_value2 => p_object_id,
5509: p_trans2 => 'N');
5510:
5511: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5512: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5513: p_msg_name =>'FEM_UD_CANNOT_CREATE_LIST_ERR');
5514:
5515: FEM_ENGINES_PKG.USER_MESSAGE
5511: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5512: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5513: p_msg_name =>'FEM_UD_CANNOT_CREATE_LIST_ERR');
5514:
5515: FEM_ENGINES_PKG.USER_MESSAGE
5516: (P_APP_NAME => 'FEM'
5517: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5518:
5519: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5520: (status => 'ERROR', message => NULL);
5521:
5522: WHEN e_cannot_read_object THEN
5523: ROLLBACK;
5524: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5525: p_msg_name => 'FEM_UD_CANNOT_READ_OBJECT_ERR');
5526:
5527: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5528: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5523: ROLLBACK;
5524: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5525: p_msg_name => 'FEM_UD_CANNOT_READ_OBJECT_ERR');
5526:
5527: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5528: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5529: p_msg_name => 'FEM_UD_CANNOT_READ_OBJECT_ERR');
5530:
5531: FEM_ENGINES_PKG.USER_MESSAGE
5527: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5528: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5529: p_msg_name => 'FEM_UD_CANNOT_READ_OBJECT_ERR');
5530:
5531: FEM_ENGINES_PKG.USER_MESSAGE
5532: (P_APP_NAME => 'FEM'
5533: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5534:
5535: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5535: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5536: (status => 'ERROR', message => NULL);
5537:
5538: WHEN e_invalid_folder THEN
5539: fem_engines_pkg.user_message(p_app_name =>'FEM',
5540: p_msg_name =>'FEM_IMPEXP_INVALID_FOLDER_ERR',
5541: p_token1 => 'FOLDER',
5542: p_value1 => p_folder_id,
5543: p_trans1 => 'N');
5541: p_token1 => 'FOLDER',
5542: p_value1 => p_folder_id,
5543: p_trans1 => 'N');
5544:
5545: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5546: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5547: p_msg_name =>'FEM_IMPEXP_INVALID_FOLDER_ERR',
5548: p_token1 => 'FOLDER',
5549: p_value1 => p_folder_id,
5548: p_token1 => 'FOLDER',
5549: p_value1 => p_folder_id,
5550: p_trans1 => 'N');
5551:
5552: FEM_ENGINES_PKG.USER_MESSAGE
5553: (P_APP_NAME => 'FEM'
5554: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5555:
5556: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5556: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5557: (status => 'ERROR', message => NULL);
5558:
5559: WHEN e_objexec_is_running THEN
5560: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5561: p_msg_name => 'FEM_UD_OBJEXEC_IS_RUNNING_ERR');
5562:
5563: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5564: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5559: WHEN e_objexec_is_running THEN
5560: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5561: p_msg_name => 'FEM_UD_OBJEXEC_IS_RUNNING_ERR');
5562:
5563: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5564: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5565: p_msg_name =>'FEM_UD_OBJEXEC_IS_RUNNING_ERR');
5566:
5567: FEM_ENGINES_PKG.USER_MESSAGE
5563: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5564: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5565: p_msg_name =>'FEM_UD_OBJEXEC_IS_RUNNING_ERR');
5566:
5567: FEM_ENGINES_PKG.USER_MESSAGE
5568: (P_APP_NAME => 'FEM'
5569: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5570:
5571: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5571: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5572: (status => 'ERROR', message => NULL);
5573:
5574: WHEN e_cannot_create_undo_list THEN
5575: fem_engines_pkg.user_message(p_app_name =>'FEM',
5576: p_msg_name =>'FEM_UD_CANNOT_CREATE_LIST_ERR');
5577:
5578: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5579: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5574: WHEN e_cannot_create_undo_list THEN
5575: fem_engines_pkg.user_message(p_app_name =>'FEM',
5576: p_msg_name =>'FEM_UD_CANNOT_CREATE_LIST_ERR');
5577:
5578: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5579: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5580: p_msg_name =>'FEM_UD_CANNOT_CREATE_LIST_ERR');
5581:
5582: FEM_ENGINES_PKG.USER_MESSAGE
5578: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5579: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5580: p_msg_name =>'FEM_UD_CANNOT_CREATE_LIST_ERR');
5581:
5582: FEM_ENGINES_PKG.USER_MESSAGE
5583: (P_APP_NAME => 'FEM'
5584: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5585:
5586: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5586: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5587: (status => 'ERROR', message => NULL);
5588:
5589: WHEN e_cannot_add_candidate THEN
5590: fem_engines_pkg.user_message(p_app_name =>'FEM',
5591: p_msg_name =>'FEM_UD_CANNOT_ADD_CANDIDT_ERR');
5592:
5593: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5594: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5589: WHEN e_cannot_add_candidate THEN
5590: fem_engines_pkg.user_message(p_app_name =>'FEM',
5591: p_msg_name =>'FEM_UD_CANNOT_ADD_CANDIDT_ERR');
5592:
5593: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5594: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5595: p_msg_name =>'FEM_UD_CANNOT_ADD_CANDIDT_ERR');
5596:
5597: FEM_ENGINES_PKG.USER_MESSAGE
5593: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5594: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5595: p_msg_name =>'FEM_UD_CANNOT_ADD_CANDIDT_ERR');
5596:
5597: FEM_ENGINES_PKG.USER_MESSAGE
5598: (P_APP_NAME => 'FEM'
5599: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5600:
5601: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5605: -- Unexpected exceptions
5606: -- Log the call stack and the Oracle error message to
5607: -- FND_LOG with the "unexpected exception" severity level.
5608:
5609: FEM_ENGINES_PKG.Tech_Message
5610: (p_severity => pc_log_level_unexpected,
5611: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5612: p_msg_text => SQLERRM);
5613:
5610: (p_severity => pc_log_level_unexpected,
5611: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5612: p_msg_text => SQLERRM);
5613:
5614: FEM_ENGINES_PKG.Tech_Message
5615: (p_severity => pc_log_level_unexpected,
5616: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5617: p_msg_text => dbms_utility.format_call_stack);
5618:
5616: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5617: p_msg_text => dbms_utility.format_call_stack);
5618:
5619: -- Log the Oracle error message to the stack.
5620: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5621: p_msg_name => 'FEM_UNEXPECTED_ERROR',
5622: P_TOKEN1 => 'ERR_MSG',
5623: P_VALUE1 => SQLERRM);
5624:
5621: p_msg_name => 'FEM_UNEXPECTED_ERROR',
5622: P_TOKEN1 => 'ERR_MSG',
5623: P_VALUE1 => SQLERRM);
5624:
5625: FEM_ENGINES_PKG.USER_MESSAGE
5626: (P_APP_NAME => 'FEM'
5627: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5628:
5629: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5671: WHERE request_id = p_request_id
5672: ORDER BY event_order;
5673:
5674: BEGIN
5675: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
5676: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5677: p_msg_text => 'Begin. P_REQUEST_ID: '||p_request_id||
5678: ' P_FOLDER_ID: '||p_folder_id||
5679: ' P_INCLUDE_DEPENDENCIES_FLAG: '||p_include_dependencies_flag||
5681:
5682: -- ============================================================================
5683: -- VALIDATIONS
5684: -- ============================================================================
5685: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
5686: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5687: p_msg_text => 'Begin VALIDATIONS: '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
5688:
5689: -- Bug 4309949: Ignore folder security for Undo rules
5767: WHERE request_id = p_request_id;
5768:
5769: COMMIT;
5770:
5771: FEM_ENGINES_PKG.USER_MESSAGE
5772: (P_APP_NAME => 'FEM'
5773: ,P_MSG_NAME => 'FEM_EXEC_SUCCESS');
5774:
5775: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5775: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5776: (status => 'NORMAL', message => NULL);
5777:
5778: ELSE
5779: FEM_ENGINES_PKG.USER_MESSAGE
5780: (P_APP_NAME => 'FEM'
5781: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5782:
5783: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5819: AND o.object_id = d.object_id
5820: AND o.object_name = 'UNDO - REQUEST_ID: '||p_request_id;
5821: v_undo_list_exists := 'T';
5822:
5823: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
5824: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5825: p_msg_text => 'Undo list already exists. OBJECT_ID:'||v_undo_list_obj_id||
5826: ' OBJECT_DEFINITION_ID:'||v_undo_list_obj_def_id);
5827:
5918: END IF;
5919: -- ============================================================================
5920: -- SET STATUS
5921: -- ============================================================================
5922: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
5923: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5924: p_msg_text => 'End. '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
5925: -- ============================================================================
5926: -- EXCEPTIONS
5926: -- EXCEPTIONS
5927: -- ============================================================================
5928: EXCEPTION
5929: WHEN e_request_not_found THEN
5930: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5931: p_msg_name => 'FEM_UD_REQUEST_NOT_FOUND_WRN',
5932: p_token1 => 'REQUEST_ID',
5933: p_value1 => p_request_id,
5934: p_trans1 => 'N');
5932: p_token1 => 'REQUEST_ID',
5933: p_value1 => p_request_id,
5934: p_trans1 => 'N');
5935:
5936: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5937: p_msg_name => 'FEM_UD_CANNOT_CREATE_LIST_ERR');
5938:
5939: FEM_ENGINES_PKG.USER_MESSAGE
5940: (P_APP_NAME => 'FEM'
5935:
5936: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5937: p_msg_name => 'FEM_UD_CANNOT_CREATE_LIST_ERR');
5938:
5939: FEM_ENGINES_PKG.USER_MESSAGE
5940: (P_APP_NAME => 'FEM'
5941: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5942:
5943: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5939: FEM_ENGINES_PKG.USER_MESSAGE
5940: (P_APP_NAME => 'FEM'
5941: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5942:
5943: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5944: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5945: p_msg_name => 'FEM_UD_REQUEST_NOT_FOUND_WRN',
5946: p_token1 => 'REQUEST_ID',
5947: p_value1 => p_request_id,
5946: p_token1 => 'REQUEST_ID',
5947: p_value1 => p_request_id,
5948: p_trans1 => 'N');
5949:
5950: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5951: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5952: p_msg_name =>'FEM_UD_CANNOT_CREATE_LIST_ERR');
5953:
5954: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5954: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5955: (status => 'ERROR', message => NULL);
5956:
5957: WHEN e_invalid_folder THEN
5958: fem_engines_pkg.user_message(p_app_name =>'FEM',
5959: p_msg_name =>'FEM_IMPEXP_INVALID_FOLDER_ERR',
5960: p_token1 => 'FOLDER',
5961: p_value1 => p_folder_id,
5962: p_trans1 => 'N');
5960: p_token1 => 'FOLDER',
5961: p_value1 => p_folder_id,
5962: p_trans1 => 'N');
5963:
5964: FEM_ENGINES_PKG.USER_MESSAGE
5965: (P_APP_NAME => 'FEM'
5966: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5967:
5968: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5964: FEM_ENGINES_PKG.USER_MESSAGE
5965: (P_APP_NAME => 'FEM'
5966: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5967:
5968: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5969: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5970: p_msg_name =>'FEM_IMPEXP_INVALID_FOLDER_ERR');
5971:
5972: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5972: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5973: (status => 'ERROR', message => NULL);
5974:
5975: WHEN e_request_is_running THEN
5976: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5977: p_msg_name => 'FEM_UD_REQUEST_IS_RUNNING_ERR');
5978:
5979: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5980: p_msg_name => 'FEM_UD_CANNOT_UNDO_REQUEST_ERR');
5975: WHEN e_request_is_running THEN
5976: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5977: p_msg_name => 'FEM_UD_REQUEST_IS_RUNNING_ERR');
5978:
5979: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5980: p_msg_name => 'FEM_UD_CANNOT_UNDO_REQUEST_ERR');
5981:
5982: FEM_ENGINES_PKG.USER_MESSAGE
5983: (P_APP_NAME => 'FEM'
5978:
5979: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5980: p_msg_name => 'FEM_UD_CANNOT_UNDO_REQUEST_ERR');
5981:
5982: FEM_ENGINES_PKG.USER_MESSAGE
5983: (P_APP_NAME => 'FEM'
5984: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5985:
5986: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5982: FEM_ENGINES_PKG.USER_MESSAGE
5983: (P_APP_NAME => 'FEM'
5984: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
5985:
5986: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
5987: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5988: p_msg_name =>'FEM_UD_REQUEST_IS_RUNNING_ERR');
5989:
5990: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
5991: (status => 'ERROR', message => NULL);
5992:
5993: WHEN e_cannot_read_object THEN
5994:
5995: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5996: p_msg_name => 'FEM_UD_CANNOT_READ_OBJECT_ERR');
5997:
5998: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5999: p_msg_name => 'FEM_UD_CANNOT_UNDO_REQUEST_ERR');
5994:
5995: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5996: p_msg_name => 'FEM_UD_CANNOT_READ_OBJECT_ERR');
5997:
5998: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5999: p_msg_name => 'FEM_UD_CANNOT_UNDO_REQUEST_ERR');
6000:
6001: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6002: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
5997:
5998: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
5999: p_msg_name => 'FEM_UD_CANNOT_UNDO_REQUEST_ERR');
6000:
6001: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6002: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6003: p_msg_name => 'FEM_UD_CANNOT_READ_OBJECT_ERR');
6004:
6005:
6002: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6003: p_msg_name => 'FEM_UD_CANNOT_READ_OBJECT_ERR');
6004:
6005:
6006: FEM_ENGINES_PKG.USER_MESSAGE
6007: (P_APP_NAME => 'FEM'
6008: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
6009:
6010: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
6010: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
6011: (status => 'ERROR', message => NULL);
6012:
6013: WHEN e_cannot_create_undo_list THEN
6014: fem_engines_pkg.user_message(p_app_name =>'FEM',
6015: p_msg_name =>'FEM_UD_CANNOT_CREATE_LIST_ERR');
6016:
6017: FEM_ENGINES_PKG.USER_MESSAGE
6018: (P_APP_NAME => 'FEM'
6013: WHEN e_cannot_create_undo_list THEN
6014: fem_engines_pkg.user_message(p_app_name =>'FEM',
6015: p_msg_name =>'FEM_UD_CANNOT_CREATE_LIST_ERR');
6016:
6017: FEM_ENGINES_PKG.USER_MESSAGE
6018: (P_APP_NAME => 'FEM'
6019: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
6020:
6021: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6017: FEM_ENGINES_PKG.USER_MESSAGE
6018: (P_APP_NAME => 'FEM'
6019: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
6020:
6021: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6022: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6023: p_msg_name =>'FEM_UD_CANNOT_CREATE_LIST_ERR');
6024:
6025: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
6025: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
6026: (status => 'ERROR', message => NULL);
6027:
6028: WHEN e_cannot_add_candidate THEN
6029: fem_engines_pkg.user_message(p_app_name =>'FEM',
6030: p_msg_name =>'FEM_UD_CANNOT_ADD_CANDIDT_ERR');
6031:
6032: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
6033: p_msg_name => 'FEM_UD_CANNOT_UNDO_REQUEST_ERR');
6028: WHEN e_cannot_add_candidate THEN
6029: fem_engines_pkg.user_message(p_app_name =>'FEM',
6030: p_msg_name =>'FEM_UD_CANNOT_ADD_CANDIDT_ERR');
6031:
6032: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
6033: p_msg_name => 'FEM_UD_CANNOT_UNDO_REQUEST_ERR');
6034:
6035: FEM_ENGINES_PKG.USER_MESSAGE
6036: (P_APP_NAME => 'FEM'
6031:
6032: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
6033: p_msg_name => 'FEM_UD_CANNOT_UNDO_REQUEST_ERR');
6034:
6035: FEM_ENGINES_PKG.USER_MESSAGE
6036: (P_APP_NAME => 'FEM'
6037: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
6038:
6039: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6035: FEM_ENGINES_PKG.USER_MESSAGE
6036: (P_APP_NAME => 'FEM'
6037: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
6038:
6039: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6040: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6041: p_msg_name =>'FEM_UD_CANNOT_ADD_CANDIDT_ERR');
6042:
6043: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
6045:
6046: WHEN e_list_has_no_candidates THEN
6047: retcode := pc_ret_sts_error;
6048:
6049: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
6050: p_msg_name => 'FEM_UD_NO_CANDIDATES_ERR');
6051:
6052: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6053: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6048:
6049: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
6050: p_msg_name => 'FEM_UD_NO_CANDIDATES_ERR');
6051:
6052: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6053: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6054: p_msg_name =>'FEM_UD_NO_CANDIDATES_ERR');
6055:
6056: FEM_ENGINES_PKG.USER_MESSAGE
6052: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6053: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6054: p_msg_name =>'FEM_UD_NO_CANDIDATES_ERR');
6055:
6056: FEM_ENGINES_PKG.USER_MESSAGE
6057: (P_APP_NAME => 'FEM'
6058: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
6059:
6060: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
6064: -- Unexpected exceptions
6065: -- Log the call stack and the Oracle error message to
6066: -- FND_LOG with the "unexpected exception" severity level.
6067:
6068: FEM_ENGINES_PKG.Tech_Message
6069: (p_severity => pc_log_level_unexpected,
6070: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6071: p_msg_text => SQLERRM);
6072:
6069: (p_severity => pc_log_level_unexpected,
6070: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6071: p_msg_text => SQLERRM);
6072:
6073: FEM_ENGINES_PKG.Tech_Message
6074: (p_severity => pc_log_level_unexpected,
6075: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6076: p_msg_text => dbms_utility.format_call_stack);
6077:
6075: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6076: p_msg_text => dbms_utility.format_call_stack);
6077:
6078: -- Log the Oracle error message to the stack.
6079: FEM_ENGINES_PKG.user_message(p_app_name =>'FEM',
6080: p_msg_name => 'FEM_UNEXPECTED_ERROR',
6081: P_TOKEN1 => 'ERR_MSG',
6082: P_VALUE1 => SQLERRM,
6083: P_TRANS1 => 'N');
6081: P_TOKEN1 => 'ERR_MSG',
6082: P_VALUE1 => SQLERRM,
6083: P_TRANS1 => 'N');
6084:
6085: FEM_ENGINES_PKG.USER_MESSAGE
6086: (P_APP_NAME => 'FEM'
6087: ,P_MSG_NAME => 'FEM_EXEC_RERUN');
6088:
6089: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status
6136: AND c.object_id = pl.object_id (+)
6137: ORDER BY c.request_id, c.object_id;
6138:
6139: BEGIN
6140: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
6141: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6142: p_msg_text => 'Begin. P_UNDO_LIST_NAME: '||p_undo_list_name||
6143: ' P_FOLDER_ID: '||p_folder_id||
6144: ' P_UD_SESSION_ID: '||p_ud_session_id);
6147:
6148: -- ============================================================================
6149: -- VALIDATIONS
6150: -- ============================================================================
6151: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
6152: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6153: p_msg_text => 'Begin VALIDATIONS: '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
6154:
6155: -- Bug 4309949: Ignore folder security for Undo rules
6171:
6172: -- ============================================================================
6173: -- V03: Check to make sure object executions are not RUNNING.
6174: -- ============================================================================
6175: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
6176: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6177: p_msg_text => 'V03: Check to make sure object executions are not RUNNING: '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
6178:
6179: FOR cand_num IN c1 LOOP
6177: p_msg_text => 'V03: Check to make sure object executions are not RUNNING: '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
6178:
6179: FOR cand_num IN c1 LOOP
6180:
6181: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
6182: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6183: p_msg_text => 'Candidate Number:'||c1%ROWCOUNT||' REQUEST_ID:'||cand_num.request_id||
6184: ' OBJECT_ID:'||cand_num.object_id||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
6185:
6324: WHERE ud_session_id = p_ud_session_id;
6325:
6326: COMMIT;
6327:
6328: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
6329: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6330: p_msg_text => 'Undo list processed using REQUEST_ID:'||x_request_id);
6331: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
6332: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6327:
6328: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
6329: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6330: p_msg_text => 'Undo list processed using REQUEST_ID:'||x_request_id);
6331: fem_engines_pkg.tech_message(p_severity => pc_log_level_statement,
6332: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6333: p_msg_text => 'End. '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
6334: -- ============================================================================
6335: -- EXCEPTIONS
6336: -- ============================================================================
6337: EXCEPTION
6338: WHEN e_invalid_folder THEN
6339: x_return_status := pc_ret_sts_error;
6340: fem_engines_pkg.put_message(p_app_name =>'FEM',
6341: p_msg_name =>'FEM_IMPEXP_INVALID_FOLDER_ERR',
6342: p_token1 => 'FOLDER',
6343: p_value1 => p_folder_id,
6344: p_trans1 => 'N');
6342: p_token1 => 'FOLDER',
6343: p_value1 => p_folder_id,
6344: p_trans1 => 'N');
6345:
6346: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6347: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6348: p_msg_name =>'FEM_IMPEXP_INVALID_FOLDER_ERR',
6349: p_token1 => 'FOLDER',
6350: p_value1 => p_folder_id,
6356: p_data => x_msg_data);
6357:
6358: WHEN e_objexec_is_running THEN
6359: x_return_status := pc_ret_sts_error;
6360: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
6361: p_msg_name => 'FEM_UD_OBJEXEC_IS_RUNNING_ERR');
6362:
6363: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6364: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6359: x_return_status := pc_ret_sts_error;
6360: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
6361: p_msg_name => 'FEM_UD_OBJEXEC_IS_RUNNING_ERR');
6362:
6363: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6364: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6365: p_msg_name =>'FEM_UD_OBJEXEC_IS_RUNNING_ERR');
6366:
6367: -- Standard call to get message count and if count is 1, get message info.
6370: p_data => x_msg_data);
6371:
6372: WHEN e_cannot_create_undo_list THEN
6373: x_return_status := pc_ret_sts_error;
6374: fem_engines_pkg.put_message(p_app_name =>'FEM',
6375: p_msg_name =>'FEM_UD_CANNOT_CREATE_LIST_ERR');
6376:
6377: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6378: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6373: x_return_status := pc_ret_sts_error;
6374: fem_engines_pkg.put_message(p_app_name =>'FEM',
6375: p_msg_name =>'FEM_UD_CANNOT_CREATE_LIST_ERR');
6376:
6377: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6378: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6379: p_msg_name =>'FEM_UD_CANNOT_CREATE_LIST_ERR');
6380:
6381: -- Standard call to get message count and if count is 1, get message info.
6384: p_data => x_msg_data);
6385:
6386: WHEN e_cannot_add_candidate THEN
6387: x_return_status := pc_ret_sts_error;
6388: fem_engines_pkg.put_message(p_app_name =>'FEM',
6389: p_msg_name =>'FEM_UD_CANNOT_ADD_CANDIDT_ERR');
6390:
6391: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6392: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6387: x_return_status := pc_ret_sts_error;
6388: fem_engines_pkg.put_message(p_app_name =>'FEM',
6389: p_msg_name =>'FEM_UD_CANNOT_ADD_CANDIDT_ERR');
6390:
6391: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6392: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6393: p_msg_name =>'FEM_UD_CANNOT_ADD_CANDIDT_ERR');
6394:
6395: -- Standard call to get message count and if count is 1, get message info.
6399:
6400:
6401: WHEN e_cannot_submit_request THEN
6402:
6403: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
6404: p_msg_name => 'FEM_UD_SUBMIT_LIST_ERR',
6405: P_TOKEN1 => 'OBJECT_ID',
6406: P_VALUE1 => v_undo_list_obj_id,
6407: P_TRANS1 => 'N');
6405: P_TOKEN1 => 'OBJECT_ID',
6406: P_VALUE1 => v_undo_list_obj_id,
6407: P_TRANS1 => 'N');
6408:
6409: fem_engines_pkg.tech_message(p_severity => pc_log_level_exception,
6410: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6411: p_msg_name => 'FEM_UD_SUBMIT_LIST_ERR',
6412: P_TOKEN1 => 'OBJECT_ID',
6413: P_VALUE1 => v_undo_list_obj_id,
6440: -- Log the call stack and the Oracle error message to
6441: -- FND_LOG with the "unexpected exception" severity level.
6442: x_return_status := pc_ret_sts_unexp_error;
6443:
6444: FEM_ENGINES_PKG.Tech_Message
6445: (p_severity => pc_log_level_unexpected,
6446: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6447: p_msg_text => SQLERRM);
6448:
6445: (p_severity => pc_log_level_unexpected,
6446: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6447: p_msg_text => SQLERRM);
6448:
6449: FEM_ENGINES_PKG.Tech_Message
6450: (p_severity => pc_log_level_unexpected,
6451: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6452: p_msg_text => dbms_utility.format_call_stack);
6453:
6451: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6452: p_msg_text => dbms_utility.format_call_stack);
6453:
6454: -- Log the Oracle error message to the stack.
6455: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
6456: p_msg_name => 'FEM_UNEXPECTED_ERROR',
6457: P_TOKEN1 => 'ERR_MSG',
6458: P_VALUE1 => SQLERRM);
6459:
6482: v_count NUMBER := 0;
6483:
6484: BEGIN
6485:
6486: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
6487: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6488: p_msg_text => 'Begin. P_COMMIT:'||p_commit||
6489: ' P_UD_SESSION_ID: '||p_ud_session_id);
6490:
6533: IF FND_API.To_Boolean( p_commit ) THEN
6534: COMMIT WORK;
6535: END IF;
6536:
6537: fem_engines_pkg.tech_message(p_severity => pc_log_level_procedure,
6538: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6539: p_msg_text => 'End. X_RETURN_STATUS: '||x_return_status);
6540:
6541: EXCEPTION
6541: EXCEPTION
6542: WHEN e_invalid_session_id THEN
6543: x_return_status := pc_ret_sts_error;
6544:
6545: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
6546: p_msg_name => 'FEM_UD_INVALID_SESSIONID');
6547:
6548: FND_MSG_PUB.Count_And_Get
6549: (p_count => x_msg_count,
6552: WHEN e_list_has_no_candidates THEN
6553: ROLLBACK TO insert_preview_candidates_pub;
6554: x_return_status := pc_ret_sts_error;
6555:
6556: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
6557: p_msg_name => 'FEM_UD_NO_CANDIDATES_ERR');
6558:
6559: fem_engines_pkg.tech_message(p_severity => pc_log_level_error,
6560: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6555:
6556: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
6557: p_msg_name => 'FEM_UD_NO_CANDIDATES_ERR');
6558:
6559: fem_engines_pkg.tech_message(p_severity => pc_log_level_error,
6560: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6561: p_app_name =>'FEM',
6562: p_msg_name => 'FEM_UD_NO_CANDIDATES_ERR');
6563:
6568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6569: ROLLBACK TO insert_preview_candidates_pub;
6570: x_return_status := pc_ret_sts_unexp_error;
6571:
6572: fem_engines_pkg.tech_message(p_severity => pc_log_level_unexpected,
6573: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6574: p_app_name =>'FEM',
6575: p_msg_name => 'FEM_BAD_P_API_VER_ERR',p_token1 => 'VALUE',
6576: p_value1 => p_api_version, p_trans1 => 'N');
6581:
6582: -- Log the call stack and the Oracle error message to
6583: -- FND_LOG with the "unexpected exception" severity level.
6584:
6585: FEM_ENGINES_PKG.Tech_Message
6586: (p_severity => pc_log_level_unexpected,
6587: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6588: p_msg_text => SQLERRM);
6589:
6586: (p_severity => pc_log_level_unexpected,
6587: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6588: p_msg_text => SQLERRM);
6589:
6590: FEM_ENGINES_PKG.Tech_Message
6591: (p_severity => pc_log_level_unexpected,
6592: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6593: p_msg_text => dbms_utility.format_call_stack);
6594:
6592: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
6593: p_msg_text => dbms_utility.format_call_stack);
6594:
6595: -- Log the Oracle error message to the stack.
6596: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
6597: p_msg_name => 'FEM_UNEXPECTED_ERROR',
6598: P_TOKEN1 => 'ERR_MSG',
6599: P_VALUE1 => SQLERRM);
6600:
6690: -- Standard Start of API savepoint
6691: SAVEPOINT delete_balances_pub;
6692:
6693: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6694: FEM_ENGINES_PKG.TECH_MESSAGE(
6695: p_severity => FND_LOG.level_procedure,
6696: p_module => C_MODULE,
6697: p_msg_text => 'Begin Procedure');
6698: END IF;
6706: C_API_NAME,
6707: pc_pkg_name)
6708: THEN
6709: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6710: FEM_ENGINES_PKG.TECH_MESSAGE(
6711: p_severity => FND_LOG.level_unexpected,
6712: p_module => C_MODULE,
6713: p_msg_text => 'INTERNAL ERROR: API Version ('||C_API_VERSION||') not compatible with '
6714: ||'passed in version ('||p_api_version||')');
6724: WHERE object_id = p_object_id;
6725:
6726: IF nvl(v_object_type,'BADTYPE') <> 'TP_PROCESS_RULE' THEN
6727: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6728: FEM_ENGINES_PKG.TECH_MESSAGE(
6729: p_severity => FND_LOG.level_unexpected,
6730: p_module => C_MODULE,
6731: p_msg_text => 'INTERNAL ERROR: p_object_id ('||to_char(p_object_id)
6732: ||') belongs to '||v_object_type||'. This API only '
6736: END IF;
6737:
6738: -- Log procedure param values
6739: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6740: FEM_ENGINES_PKG.TECH_MESSAGE(
6741: p_severity => FND_LOG.level_statement,
6742: p_module => C_MODULE,
6743: p_msg_text => 'p_current_request_id = '||to_char(p_current_request_id));
6744: FEM_ENGINES_PKG.TECH_MESSAGE(
6740: FEM_ENGINES_PKG.TECH_MESSAGE(
6741: p_severity => FND_LOG.level_statement,
6742: p_module => C_MODULE,
6743: p_msg_text => 'p_current_request_id = '||to_char(p_current_request_id));
6744: FEM_ENGINES_PKG.TECH_MESSAGE(
6745: p_severity => FND_LOG.level_statement,
6746: p_module => C_MODULE,
6747: p_msg_text => 'p_object_id = '||to_char(p_object_id));
6748: FEM_ENGINES_PKG.TECH_MESSAGE(
6744: FEM_ENGINES_PKG.TECH_MESSAGE(
6745: p_severity => FND_LOG.level_statement,
6746: p_module => C_MODULE,
6747: p_msg_text => 'p_object_id = '||to_char(p_object_id));
6748: FEM_ENGINES_PKG.TECH_MESSAGE(
6749: p_severity => FND_LOG.level_statement,
6750: p_module => C_MODULE,
6751: p_msg_text => 'p_cal_period_id = '||to_char(p_cal_period_id));
6752: FEM_ENGINES_PKG.TECH_MESSAGE(
6748: FEM_ENGINES_PKG.TECH_MESSAGE(
6749: p_severity => FND_LOG.level_statement,
6750: p_module => C_MODULE,
6751: p_msg_text => 'p_cal_period_id = '||to_char(p_cal_period_id));
6752: FEM_ENGINES_PKG.TECH_MESSAGE(
6753: p_severity => FND_LOG.level_statement,
6754: p_module => C_MODULE,
6755: p_msg_text => 'p_ledger_id = '||to_char(p_ledger_id));
6756: FEM_ENGINES_PKG.TECH_MESSAGE(
6752: FEM_ENGINES_PKG.TECH_MESSAGE(
6753: p_severity => FND_LOG.level_statement,
6754: p_module => C_MODULE,
6755: p_msg_text => 'p_ledger_id = '||to_char(p_ledger_id));
6756: FEM_ENGINES_PKG.TECH_MESSAGE(
6757: p_severity => FND_LOG.level_statement,
6758: p_module => C_MODULE,
6759: p_msg_text => 'p_dataset_code = '||to_char(p_dataset_code));
6760: END IF;
6817: EXECUTE IMMEDIATE v_sql;
6818: EXCEPTION
6819: WHEN others THEN
6820: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6821: FEM_ENGINES_PKG.TECH_MESSAGE(
6822: p_severity => FND_LOG.level_unexpected,
6823: p_module => C_MODULE,
6824: p_msg_text => 'The following SQL failed unexpected: '||v_sql);
6825: END IF;
6867: COMMIT;
6868: END IF;
6869:
6870: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6871: FEM_ENGINES_PKG.TECH_MESSAGE(
6872: p_severity => FND_LOG.level_procedure,
6873: p_module => C_MODULE,
6874: p_msg_text => 'End Procedure');
6875: END IF;
6881: OPEN c_object_name(p_object_id);
6882: FETCH c_object_name INTO v_object_name;
6883: CLOSE c_object_name;
6884:
6885: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
6886: p_msg_name => 'FEM_UD_NO_DEL_RUNNING_OBJEXEC',
6887: p_token1 => 'RULE_NAME',
6888: p_value1 => v_object_name,
6889: p_token2 => 'REQ_ID',
6900: OPEN c_object_name(p_object_id);
6901: FETCH c_object_name INTO v_object_name;
6902: CLOSE c_object_name;
6903:
6904: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
6905: p_msg_name => 'FEM_UD_NO_DEL_CHAINED_OBJEXEC',
6906: p_token1 => 'DEP_RULE_NAME',
6907: p_value1 => v_dep_obj_id,
6908: p_token2 => 'DEP_REQ_ID',
6925: WHEN others THEN
6926: ROLLBACK TO delete_balances_pub;
6927:
6928: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6929: FEM_ENGINES_PKG.TECH_MESSAGE(
6930: p_severity => FND_LOG.level_unexpected,
6931: p_module => C_MODULE,
6932: p_msg_text => 'Unexpected error: '||SQLERRM);
6933: END IF;
6931: p_module => C_MODULE,
6932: p_msg_text => 'Unexpected error: '||SQLERRM);
6933: END IF;
6934: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6935: FEM_ENGINES_PKG.TECH_MESSAGE(
6936: p_severity => FND_LOG.level_procedure,
6937: p_module => C_MODULE,
6938: p_msg_text => 'End Procedure');
6939: END IF;
6997: -- Standard Start of API savepoint
6998: SAVEPOINT remove_process_locks_pub;
6999:
7000: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7001: FEM_ENGINES_PKG.TECH_MESSAGE(
7002: p_severity => FND_LOG.level_procedure,
7003: p_module => C_MODULE,
7004: p_msg_text => 'Begin Procedure');
7005: END IF;
7013: C_API_NAME,
7014: pc_pkg_name)
7015: THEN
7016: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7017: FEM_ENGINES_PKG.TECH_MESSAGE(
7018: p_severity => FND_LOG.level_unexpected,
7019: p_module => C_MODULE,
7020: p_msg_text => 'INTERNAL ERROR: API Version ('||C_API_VERSION
7021: ||') not compatible with '
7030: END IF;
7031:
7032: -- Log procedure param values
7033: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7034: FEM_ENGINES_PKG.TECH_MESSAGE(
7035: p_severity => FND_LOG.level_statement,
7036: p_module => C_MODULE,
7037: p_msg_text => 'p_request_id = '||to_char(p_request_id));
7038: FEM_ENGINES_PKG.TECH_MESSAGE(
7034: FEM_ENGINES_PKG.TECH_MESSAGE(
7035: p_severity => FND_LOG.level_statement,
7036: p_module => C_MODULE,
7037: p_msg_text => 'p_request_id = '||to_char(p_request_id));
7038: FEM_ENGINES_PKG.TECH_MESSAGE(
7039: p_severity => FND_LOG.level_statement,
7040: p_module => C_MODULE,
7041: p_msg_text => 'p_object_id = '||to_char(p_object_id));
7042: END IF;
7050: AND oc.object_type_code = ot.object_type_code;
7051:
7052: IF nvl(v_undo_flag,'XX') <> 'N' THEN
7053: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7054: FEM_ENGINES_PKG.TECH_MESSAGE(
7055: p_severity => FND_LOG.level_unexpected,
7056: p_module => C_MODULE,
7057: p_msg_text => 'INTERNAL ERROR: p_object_id ('||to_char(p_object_id)
7058: ||') belongs to a rule type where its Undo Flag'
7072: AND request_id = p_request_id;
7073:
7074: IF v_count > 0 THEN
7075: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7076: FEM_ENGINES_PKG.TECH_MESSAGE(
7077: p_severity => FND_LOG.level_unexpected,
7078: p_module => C_MODULE,
7079: p_msg_text => 'INTERNAL ERROR: p_object_id ('||to_char(p_object_id)
7080: ||') registered this many tables: '||v_count
7096: x_exec_status_code => v_exec_status_code);
7097:
7098: IF x_return_status <> pc_ret_sts_success THEN
7099: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7100: FEM_ENGINES_PKG.TECH_MESSAGE(
7101: p_severity => FND_LOG.level_unexpected,
7102: p_module => C_MODULE,
7103: p_msg_text => 'INTERNAL ERROR: Call to FEM_PL_PKG.Get_Exec_Status'
7104: ||' failed with return status: '||x_return_status);
7121: p_object_id => p_object_id);
7122:
7123: IF x_return_status <> pc_ret_sts_success THEN
7124: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7125: FEM_ENGINES_PKG.TECH_MESSAGE(
7126: p_severity => FND_LOG.level_unexpected,
7127: p_module => C_MODULE,
7128: p_msg_text => 'INTERNAL ERROR: Call to FEM_PL_PKG.Get_Exec_Status'
7129: ||' failed with return status: '||x_return_status);
7138: COMMIT;
7139: END IF;
7140:
7141: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7142: FEM_ENGINES_PKG.TECH_MESSAGE(
7143: p_severity => FND_LOG.level_procedure,
7144: p_module => C_MODULE,
7145: p_msg_text => 'End Procedure');
7146: END IF;
7152: OPEN c_object_name(p_object_id);
7153: FETCH c_object_name INTO v_object_name;
7154: CLOSE c_object_name;
7155:
7156: FEM_ENGINES_PKG.put_message(p_app_name =>'FEM',
7157: p_msg_name => 'FEM_UD_NO_DEL_RUNNING_OBJEXEC',
7158: p_token1 => 'RULE_NAME',
7159: p_value1 => v_object_name,
7160: p_token2 => 'REQ_ID',
7172: WHEN others THEN
7173: ROLLBACK TO remove_process_locks_pub;
7174:
7175: IF FND_LOG.level_unexpected >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7176: FEM_ENGINES_PKG.TECH_MESSAGE(
7177: p_severity => FND_LOG.level_unexpected,
7178: p_module => C_MODULE,
7179: p_msg_text => 'Unexpected error: '||SQLERRM);
7180: END IF;
7178: p_module => C_MODULE,
7179: p_msg_text => 'Unexpected error: '||SQLERRM);
7180: END IF;
7181: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
7182: FEM_ENGINES_PKG.TECH_MESSAGE(
7183: p_severity => FND_LOG.level_procedure,
7184: p_module => C_MODULE,
7185: p_msg_text => 'End Procedure');
7186: END IF;
7290: );
7291: /****
7292: write_debug (' Repair_PL_Request 1');
7293:
7294: FEM_ENGINES_PKG.Tech_Message (
7295: p_severity => pc_log_level_procedure
7296: ,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7297: ,p_msg_text => 'BEGIN'
7298: );
7360: p_msg_data => ' Repair_PL_Request 4A, fails to call Prepare_PL_Register_Record ',
7361: p_user_msg => 'N',
7362: p_module => 'fem.plsql.'||pc_pkg_name||'.'||l_api_name
7363: );
7364: FEM_ENGINES_PKG.User_Message (
7365: p_app_name => G_FEM
7366: ,p_msg_name => 'FEM_UD_CANT_REPAIR_EXEC'
7367: ,p_token1 => 'object_name'
7368: ,p_value1 => missing_entry.object_name
7407: );
7408:
7409:
7410: if (l_return_status <> pc_ret_sts_success) then
7411: FEM_ENGINES_PKG.User_Message (
7412: p_app_name => G_FEM
7413: ,p_msg_name => 'FEM_UD_CANT_REPAIR_EXEC'
7414: ,p_token1 => 'object_name'
7415: ,p_value1 => missing_entry.object_name
7488: ,x_return_status => l_return_status
7489: );
7490:
7491: IF (l_return_status <> pc_ret_sts_success) THEN
7492: FEM_ENGINES_PKG.User_Message (
7493: p_app_name => G_FEM
7494: ,p_msg_name => 'FEM_UD_CANT_REPAIR_EXEC'
7495: ,p_token1 => 'object_name'
7496: ,p_value1 => missing_entry.object_name
7519: X_MSG_COUNT => l_msg_count,
7520: X_MSG_DATA => l_msg_data,
7521: X_RETURN_STATUS => l_return_status);
7522: IF (l_return_status <> pc_ret_sts_success) THEN
7523: FEM_ENGINES_PKG.User_Message (
7524: p_app_name => G_FEM
7525: ,p_msg_name => 'FEM_UD_CANT_REPAIR_EXEC'
7526: ,p_token1 => 'object_name'
7527: ,p_value1 => missing_entry.object_name
7560: ,x_msg_data => l_msg_data
7561: ,x_return_status => l_return_status
7562: );
7563: IF (l_return_status <> pc_ret_sts_success) THEN
7564: FEM_ENGINES_PKG.User_Message (
7565: p_app_name => G_FEM
7566: ,p_msg_name => 'FEM_UD_CANT_REPAIR_EXEC'
7567: ,p_token1 => 'object_name'
7568: ,p_value1 => missing_entry.object_name
7609: ,x_msg_data => l_msg_data
7610: ,x_return_status => l_return_status
7611: );
7612: IF (l_return_status <> pc_ret_sts_success) THEN
7613: FEM_ENGINES_PKG.User_Message (
7614: p_app_name => G_FEM
7615: ,p_msg_name => 'FEM_UD_CANT_REPAIR_EXEC'
7616: ,p_token1 => 'object_name'
7617: ,p_value1 => missing_entry.object_name
7638: p_user_msg => 'N',
7639: p_module => 'fem.plsql.'||pc_pkg_name||'.'||l_api_name
7640: );
7641:
7642: FEM_ENGINES_PKG.User_Message (
7643: p_app_name => G_FEM
7644: ,p_msg_name => 'FEM_UD_REPAIR_SUCCESS'
7645: ,p_token1 => 'object_name'
7646: ,p_value1 => missing_entry.object_name
7666: END LOOP;
7667:
7668: IF (l_not_found_exe) THEN
7669:
7670: FEM_ENGINES_PKG.User_Message (
7671: p_app_name => G_FEM
7672: ,p_msg_name => 'FEM_UD_NO_NEED_REPAIR_EXEC'
7673: );
7674:
7702:
7703: pv_concurrent_status := FND_CONCURRENT.Set_Completion_Status('ERROR',null);
7704:
7705:
7706: FEM_ENGINES_PKG.Tech_Message (
7707: p_severity => pc_log_level_unexpected
7708: ,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7709: ,p_msg_text => l_prg_msg
7710: );
7708: ,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7709: ,p_msg_text => l_prg_msg
7710: );
7711:
7712: FEM_ENGINES_PKG.Tech_Message (
7713: p_severity => pc_log_level_unexpected
7714: ,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7715: ,p_msg_text => l_callstack
7716: );
7714: ,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7715: ,p_msg_text => l_callstack
7716: );
7717:
7718: FEM_ENGINES_PKG.User_Message (
7719: p_app_name => G_FEM
7720: ,p_msg_name => 'FEM_UNEXPECTED_ERROR'
7721: ,p_token1 => 'ERR_MSG'
7722: ,p_value1 => l_prg_msg
7776: x_return_status := pc_ret_sts_success;
7777: OPEN c_fnd_concurrent (x_pl_register_record.request_id);
7778: FETCH c_fnd_concurrent INTO l_fnd_concurrent_rec;
7779:
7780: --FEM_ENGINES_PKG.Tech_Message (
7781: -- p_severity => pc_log_level_procedure
7782: -- ,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7783: -- ,p_msg_text => 'request_id:' || x_pl_register_record.request_id
7784: -- || ' and object_id:' || x_pl_register_record.object_id
7793:
7794: -- the request is wiped out from the FND_CONCURRENT_REQUESTS
7795: IF (c_fnd_concurrent%notfound) THEN
7796:
7797: --FEM_ENGINES_PKG.Tech_Message (
7798: -- p_severity => pc_log_level_procedure
7799: -- ,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7800: -- ,p_msg_text => 'request_id:' || x_pl_register_record.request_id
7801: -- || ' wiped out from the FND_CONCURRENT_REQUESTS'
7816: ,x_date_assign_value => x_pl_register_record.effective_date
7817: ,x_return_status => x_return_status
7818: );
7819: IF (x_return_status <> pc_ret_sts_success) THEN
7820: --FEM_ENGINES_PKG.Tech_Message (
7821: --p_severity => pc_log_level_procedure
7822: --,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7823: --,p_msg_text => 'Can not retrieve the ending date for cal period:'
7824: -- || x_pl_register_record.cal_period_id);
7847: CLOSE c_get_output_ds_obj_def_id;
7848:
7849: IF (x_pl_register_record.dataset_io_obj_def_id IS NULL) THEN
7850:
7851: --FEM_ENGINES_PKG.Tech_Message (
7852: --p_severity => pc_log_level_procedure
7853: --,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7854: --,p_msg_text => 'Can not retrieve data set object definition id for the data set code:'
7855: -- || x_pl_register_record.output_dataset_code);
7880: x_pl_register_record.program_application_id := l_fnd_concurrent_rec.PROGRAM_APPLICATION_ID;
7881: x_pl_register_record.accurate_eff_dt_flg := G_YES;
7882: END IF;
7883:
7884: --FEM_ENGINES_PKG.Tech_Message (
7885: -- p_severity => pc_log_level_procedure
7886: -- ,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7887: -- ,p_msg_text => 'cal_period_id:' || x_pl_register_record.cal_period_id
7888: -- || ' and effective_date:' || x_pl_register_record.effective_date
7920: p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7921: );
7922:
7923:
7924: FEM_ENGINES_PKG.Tech_Message (
7925: p_severity => pc_log_level_unexpected
7926: ,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7927: ,p_msg_text => l_prg_msg
7928: );
7926: ,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7927: ,p_msg_text => l_prg_msg
7928: );
7929:
7930: FEM_ENGINES_PKG.Tech_Message (
7931: p_severity => pc_log_level_unexpected
7932: ,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7933: ,p_msg_text => l_callstack
7934: );
7932: ,p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
7933: ,p_msg_text => l_callstack
7934: );
7935:
7936: FEM_ENGINES_PKG.User_Message (
7937: p_app_name => G_FEM
7938: ,p_msg_name => 'FEM_UNEXPECTED_ERROR'
7939: ,p_token1 => 'ERR_MSG'
7940: ,p_value1 => l_prg_msg
7977:
7978: BEGIN
7979: x_return_status := pc_ret_sts_success;
7980:
7981: FEM_ENGINES_PKG.Tech_Message (
7982: p_severity => pc_log_level_procedure
7983: ,p_module => 'fem.plsql.'||pc_pkg_name||'.' ||l_api_name
7984: ,p_msg_text => 'BEGIN'
7985: );
8026: p_user_msg => 'N',
8027: p_module => 'fem.plsql.'||pc_pkg_name||'.'|| l_api_name
8028: );
8029:
8030: FEM_ENGINES_PKG.User_Message (
8031: p_app_name => 'FEM'
8032: ,p_msg_name => 'FEM_ENG_NO_DIM_ATTR_VAL_ERR'
8033: ,p_token1 => 'DIMENSION_VARCHAR_LABEL'
8034: ,p_value1 => p_dimension_varchar_label
8037: );
8038: raise l_get_dim_attr_val_error;
8039: end;
8040:
8041: FEM_ENGINES_PKG.Tech_Message (
8042: p_severity => pc_log_level_procedure
8043: ,p_module => 'fem.plsql.'||pc_pkg_name||'.' ||l_api_name
8044: ,p_msg_text => 'END'
8045: );
8047: EXCEPTION
8048:
8049: when l_get_dim_attr_val_error then
8050:
8051: FEM_ENGINES_PKG.Tech_Message (
8052: p_severity => pc_log_level_unexpected
8053: ,p_module => 'fem.plsql.'||pc_pkg_name||'.' ||l_api_name
8054: ,p_msg_text => 'Get Dimension Attribute Value Exception'
8055: );
8086: l_get_dim_attr_error exception;
8087:
8088: BEGIN
8089:
8090: FEM_ENGINES_PKG.Tech_Message (
8091: p_severity => pc_log_level_procedure
8092: ,p_module => 'fem.plsql.'||pc_pkg_name||'.' ||l_api_name
8093: ,p_msg_text => 'BEGIN'
8094: );
8112: and att.attribute_id = ver.attribute_id
8113: and ver.default_version_flag = 'Y';
8114: exception
8115: when others then
8116: FEM_ENGINES_PKG.User_Message (
8117: p_app_name => G_FEM
8118: ,p_msg_name => 'FEM_ENG_NO_DIM_ATTR_VER_ERR'
8119: ,p_token1 => 'DIMENSION_VARCHAR_LABEL'
8120: ,p_value1 => p_dimension_varchar_label
8123: );
8124: raise l_get_dim_attr_error;
8125: end;
8126:
8127: FEM_ENGINES_PKG.Tech_Message (
8128: p_severity => pc_log_level_procedure
8129: ,p_module => 'fem.plsql.'||'.'||l_api_name
8130: ,p_msg_text => 'END'
8131: );
8133: EXCEPTION
8134:
8135: when l_get_dim_attr_error then
8136:
8137: FEM_ENGINES_PKG.Tech_Message (
8138: p_severity => pc_log_level_unexpected
8139: ,p_module => 'fem.plsql.'||pc_pkg_name||'.' ||l_api_name
8140: ,p_msg_text => 'Get Dimension Attribute Exception'
8141: );
8170: l_object_type_code varchar2(30);
8171:
8172: BEGIN
8173:
8174: FEM_ENGINES_PKG.Tech_Message (
8175: p_severity => pc_log_level_procedure
8176: ,p_module => 'fem.plsql.'||pc_pkg_name||'.' ||l_api_name
8177: ,p_msg_text => 'BEGIN'
8178: );
8183: where d.object_id = p_object_id
8184: and p_effective_date between d.effective_start_date and d.effective_end_date
8185: and d.old_approved_copy_flag = 'N';
8186:
8187: FEM_ENGINES_PKG.Tech_Message (
8188: p_severity => pc_log_level_procedure
8189: ,p_module => 'fem.plsql.'||pc_pkg_name||'.' ||l_api_name
8190: ,p_msg_text => 'BEGIN'
8191: );
8199: from fem_object_definition_b d
8200: where d.object_id = p_object_id
8201: AND ROWNUM = 1;
8202:
8203: FEM_ENGINES_PKG.Tech_Message (
8204: p_severity => pc_log_level_unexpected
8205: ,p_module => 'fem.plsql.'||pc_pkg_name||'.' ||l_api_name
8206: ,p_msg_text => 'No Object Definition was found for Object:' || p_object_id
8207: || ' and effective date:' || p_effective_date
8214: p_user_msg IN VARCHAR2,
8215: p_module IN VARCHAR2)
8216: IS
8217: BEGIN
8218: FEM_ENGINES_PKG.Tech_Message (
8219: p_severity => pc_log_level_event
8220: ,p_module => p_module
8221: ,p_msg_text => p_msg_data
8222: );