[Home] [Help]
269: pragma exception_init(currval_not_def, -8002);
270:
271: begin
272:
273: l_process_control := INV_EGO_REVISION_VALIDATE.Get_Process_Control;
274:
275: for cr in cc loop
276: update mtl_item_revisions_interface
277: set process_flag = l_process_flag_3
433: for cr in c_get_rev_item loop
434: --Fix for bug# 3032994. Changed the privilege to check from
435: --EGO_EDIT_ITEM to EGO_ADD_ITEM_REVISION
436: IF ( cr.created_by <> -99 ) THEN
437: l_has_privilege := INV_EGO_REVISION_VALIDATE.check_data_security(
438: p_function => 'EGO_ADD_ITEM_REVISION'
439: ,p_object_name => 'EGO_ITEM'
440: ,p_instance_pk1_value => cr.inventory_item_id
441: ,p_instance_pk2_value => cr.organization_id
562:
563: CLOSE c_get_item_ids;
564:
565: IF l_item_lifecycle_id IS NOT NULL AND l_item_phase_id IS NOT NULL THEN
566: INV_EGO_REVISION_VALIDATE.phase_change_policy
567: (P_ORGANIZATION_ID => cr.organization_id
568: ,P_INVENTORY_ITEM_ID => cr.inventory_item_id
569: ,P_CURR_PHASE_ID => l_item_phase_id
570: ,P_FUTURE_PHASE_ID => NULL
914: -- Bug 4538382 - NOT chk when control is from PLM:UI for perf
915: -- Bug 5218491 - Modified the IF clause : Changed <> to = in the below check
916: IF (INSTR(NVL(l_process_control,'PLM_UI:N'),'PLM_UI:Y') = 0 )
917: THEN
918: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle_Phase
919: ( p_lifecycle_id => nvl(cr.lifecycle_id, l_item_lifecycle_id),
920: p_lifecycle_phase_id => cr.current_phase_id)
921: THEN
922: update mtl_item_revisions_interface
945: --Start: 3809876 :Unapproved item rev can have first phase ONLY.
946: IF (l_item_trans_type = 'EXISTS' AND l_item_approved <> 'A')
947: OR (l_item_trans_type = 'CREATE' AND INVIDIT3.CHECK_NPR_CATALOG(l_item_catalog))
948: THEN
949: IF cr.current_phase_id <> INV_EGO_REVISION_VALIDATE.Get_Initial_Lifecycle_Phase(nvl(cr.lifecycle_id, l_item_lifecycle_id))
950: THEN
951: update mtl_item_revisions_interface
952: set process_flag = l_process_flag_3
953: where rowid = cr.rowid;
1010: IF (cr.transaction_type = 'UPDATE')
1011: AND (cr.current_phase_id <> l_Old_Phase_Id) THEN
1012:
1013: --EGO Phase change policy called through INV wrapper.
1014: INV_EGO_REVISION_VALIDATE.phase_change_policy
1015: (P_ORGANIZATION_ID => cr.organization_id
1016: ,P_INVENTORY_ITEM_ID => cr.inventory_item_id
1017: ,P_CURR_PHASE_ID => l_item_phase_id
1018: ,P_FUTURE_PHASE_ID => cr.current_phase_id
1122: l_process_control VARCHAR2(2000) := NULL; --Used by EGO API only for internal flow control
1123:
1124: BEGIN
1125:
1126: l_process_control := INV_EGO_REVISION_VALIDATE.Get_Process_Control;
1127:
1128: IF l_inv_debug_level IN(101, 102) THEN
1129: INVPUTLI.info('INVPVALI: first sta..set_id'||to_char(xset_id)||'org'||to_char(org_id)||'all'||to_char(all_org));
1130: END IF;
1186: -- Bug 5218491 - Modified the IF clause : Changed <> to = in the below check
1187: IF (INSTR(NVL(l_process_control,'PLM_UI:N'),'PLM_UI:Y') = 0 )
1188: THEN
1189: IF l_inv_debug_level IN(101, 102) THEN
1190: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');
1191: END IF;
1192:
1193: status := INV_EGO_REVISION_VALIDATE.validate_item_user_privileges(
1194: P_Org_Id => org_id
1189: IF l_inv_debug_level IN(101, 102) THEN
1190: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');
1191: END IF;
1192:
1193: status := INV_EGO_REVISION_VALIDATE.validate_item_user_privileges(
1194: P_Org_Id => org_id
1195: ,P_All_Org => all_org
1196: ,P_Prog_AppId => prog_appid
1197: ,P_Prog_Id => prog_id
1201: ,P_Set_Id => xset_id
1202: ,X_Err_Text => err_text);
1203:
1204: IF l_inv_debug_level IN(101, 102) THEN
1205: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');
1206: END IF;
1207: END IF;
1208: end if;
1209: --End : Check for data security and user privileges
1347:
1348: -- Start 2777118 : Lifecycle and Phase validations for IOI
1349: IF (status = 0) THEN
1350: IF l_inv_debug_level IN(101, 102) THEN
1351: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');
1352: END IF;
1353: status := INV_EGO_REVISION_VALIDATE.validate_items_lifecycle(
1354: P_Org_Id => org_id
1355: ,P_All_Org => all_org
1349: IF (status = 0) THEN
1350: IF l_inv_debug_level IN(101, 102) THEN
1351: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');
1352: END IF;
1353: status := INV_EGO_REVISION_VALIDATE.validate_items_lifecycle(
1354: P_Org_Id => org_id
1355: ,P_All_Org => all_org
1356: ,P_Prog_AppId => prog_appid
1357: ,P_Prog_Id => prog_id
1361: ,P_Set_Id => xset_id
1362: ,X_Err_Text => err_text);
1363:
1364: IF l_inv_debug_level IN(101, 102) THEN
1365: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');
1366: END IF;
1367: END IF;
1368: -- End 2777118 : Lifecycle and Phase validations for IOI
1369:
1398: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before validate_items_catalog_group');
1399: END IF;
1400:
1401: --5208102
1402: INV_EGO_REVISION_VALIDATE.Insert_Revision_UserAttr(P_Set_id=>xset_id);
1403:
1404: RETURN (status);
1405:
1406: EXCEPTION