[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
563:
564: CLOSE c_get_item_ids;
565:
566: IF l_item_lifecycle_id IS NOT NULL AND l_item_phase_id IS NOT NULL THEN
567: INV_EGO_REVISION_VALIDATE.phase_change_policy
568: (P_ORGANIZATION_ID => cr.organization_id
569: ,P_INVENTORY_ITEM_ID => cr.inventory_item_id
570: ,P_CURR_PHASE_ID => l_item_phase_id
571: ,P_FUTURE_PHASE_ID => NULL
919: -- Bug 4538382 - NOT chk when control is from PLM:UI for perf
920: -- Bug 5218491 - Modified the IF clause : Changed <> to = in the below check
921: IF (INSTR(NVL(l_process_control,'PLM_UI:N'),'PLM_UI:Y') = 0 )
922: THEN
923: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle_Phase
924: ( p_lifecycle_id => nvl(cr.lifecycle_id, l_item_lifecycle_id),
925: p_lifecycle_phase_id => cr.current_phase_id)
926: THEN
927: update mtl_item_revisions_interface
950: --Start: 3809876 :Unapproved item rev can have first phase ONLY.
951: IF (l_item_trans_type = 'EXISTS' AND l_item_approved <> 'A')
952: OR (l_item_trans_type = 'CREATE' AND INVIDIT3.CHECK_NPR_CATALOG(l_item_catalog))
953: THEN
954: IF cr.current_phase_id <> INV_EGO_REVISION_VALIDATE.Get_Initial_Lifecycle_Phase(nvl(cr.lifecycle_id, l_item_lifecycle_id))
955: THEN
956: update mtl_item_revisions_interface
957: set process_flag = l_process_flag_3
958: where rowid = cr.rowid;
1015: IF (cr.transaction_type = 'UPDATE')
1016: AND (cr.current_phase_id <> l_Old_Phase_Id) THEN
1017:
1018: --EGO Phase change policy called through INV wrapper.
1019: INV_EGO_REVISION_VALIDATE.phase_change_policy
1020: (P_ORGANIZATION_ID => cr.organization_id
1021: ,P_INVENTORY_ITEM_ID => cr.inventory_item_id
1022: ,P_CURR_PHASE_ID => l_item_phase_id
1023: ,P_FUTURE_PHASE_ID => cr.current_phase_id
1127: l_process_control VARCHAR2(2000) := NULL; --Used by EGO API only for internal flow control
1128:
1129: BEGIN
1130:
1131: l_process_control := INV_EGO_REVISION_VALIDATE.Get_Process_Control;
1132:
1133: IF l_inv_debug_level IN(101, 102) THEN
1134: INVPUTLI.info('INVPVALI: first sta..set_id'||to_char(xset_id)||'org'||to_char(org_id)||'all'||to_char(all_org));
1135: END IF;
1191: -- Bug 5218491 - Modified the IF clause : Changed <> to = in the below check
1192: IF (INSTR(NVL(l_process_control,'PLM_UI:N'),'PLM_UI:Y') = 0 )
1193: THEN
1194: IF l_inv_debug_level IN(101, 102) THEN
1195: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');
1196: END IF;
1197:
1198: status := INV_EGO_REVISION_VALIDATE.validate_item_user_privileges(
1199: P_Org_Id => org_id
1194: IF l_inv_debug_level IN(101, 102) THEN
1195: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');
1196: END IF;
1197:
1198: status := INV_EGO_REVISION_VALIDATE.validate_item_user_privileges(
1199: P_Org_Id => org_id
1200: ,P_All_Org => all_org
1201: ,P_Prog_AppId => prog_appid
1202: ,P_Prog_Id => prog_id
1206: ,P_Set_Id => xset_id
1207: ,X_Err_Text => err_text);
1208:
1209: IF l_inv_debug_level IN(101, 102) THEN
1210: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');
1211: END IF;
1212: END IF;
1213: end if;
1214: --End : Check for data security and user privileges
1352:
1353: -- Start 2777118 : Lifecycle and Phase validations for IOI
1354: IF (status = 0) THEN
1355: IF l_inv_debug_level IN(101, 102) THEN
1356: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');
1357: END IF;
1358: status := INV_EGO_REVISION_VALIDATE.validate_items_lifecycle(
1359: P_Org_Id => org_id
1360: ,P_All_Org => all_org
1354: IF (status = 0) THEN
1355: IF l_inv_debug_level IN(101, 102) THEN
1356: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');
1357: END IF;
1358: status := INV_EGO_REVISION_VALIDATE.validate_items_lifecycle(
1359: P_Org_Id => org_id
1360: ,P_All_Org => all_org
1361: ,P_Prog_AppId => prog_appid
1362: ,P_Prog_Id => prog_id
1366: ,P_Set_Id => xset_id
1367: ,X_Err_Text => err_text);
1368:
1369: IF l_inv_debug_level IN(101, 102) THEN
1370: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');
1371: END IF;
1372: END IF;
1373: -- End 2777118 : Lifecycle and Phase validations for IOI
1374:
1403: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before validate_items_catalog_group');
1404: END IF;
1405:
1406: --5208102
1407: INV_EGO_REVISION_VALIDATE.Insert_Revision_UserAttr(P_Set_id=>xset_id);
1408:
1409: RETURN (status);
1410:
1411: EXCEPTION