APPS.INV_EGO_REVISION_VALIDATE dependencies on MTL_SYSTEM_ITEMS

Line 340: FROM mtl_system_items_b

336: SELECT lifecycle_id,
337: current_phase_id,
338: item_catalog_group_id,
339: approval_status -- Added for 4046435
340: FROM mtl_system_items_b
341: WHERE inventory_item_id = P_Item_Id
342: /*Changed for FP bug 8213894 with base bug 7492587*/
343: /* AND organization_id IN
344: (SELECT organization_id

Line 356: FROM mtl_system_items_b

352: ,cp_status_code VARCHAR2)IS
353: SELECT 'Y'
354: FROM DUAL
355: WHERE EXISTS ( SELECT NULL
356: FROM mtl_system_items_b
357: WHERE inventory_item_id = P_Item_Id
358: AND organization_id = P_Org_Id
359: AND NVL(approval_status,'A') <> 'A'
360: )

Line 376: l_Old_Phase_Id mtl_system_items_b.current_phase_id%TYPE;

372: SELECT display_sequence
373: FROM pa_ego_phases_v
374: WHERE proj_element_id = cp_phase_id ;
375:
376: l_Old_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
377: l_Old_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;
378: l_Old_catalog_group_Id mtl_system_items_b.item_catalog_group_id%TYPE;
379: l_valid_status VARCHAR2(1) := 'N';
380: l_Policy_Code VARCHAR2(20);

Line 377: l_Old_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;

373: FROM pa_ego_phases_v
374: WHERE proj_element_id = cp_phase_id ;
375:
376: l_Old_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
377: l_Old_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;
378: l_Old_catalog_group_Id mtl_system_items_b.item_catalog_group_id%TYPE;
379: l_valid_status VARCHAR2(1) := 'N';
380: l_Policy_Code VARCHAR2(20);
381: l_Return_Status VARCHAR2(1);

Line 378: l_Old_catalog_group_Id mtl_system_items_b.item_catalog_group_id%TYPE;

374: WHERE proj_element_id = cp_phase_id ;
375:
376: l_Old_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
377: l_Old_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;
378: l_Old_catalog_group_Id mtl_system_items_b.item_catalog_group_id%TYPE;
379: l_valid_status VARCHAR2(1) := 'N';
380: l_Policy_Code VARCHAR2(20);
381: l_Return_Status VARCHAR2(1);
382: l_Error_Code NUMBER;

Line 385: l_approval_status mtl_system_items_b.approval_status%TYPE; --Bug 4046435

381: l_Return_Status VARCHAR2(1);
382: l_Error_Code NUMBER;
383: l_Msg_Count NUMBER;
384: l_Msg_Data VARCHAR2(2000);
385: l_approval_status mtl_system_items_b.approval_status%TYPE; --Bug 4046435
386: -- Bug 5375723
387: l_old_disp_seq NUMBER;
388: l_new_disp_seq NUMBER;
389:

Line 537: FROM mtl_system_items_b

533: ,X_Error_Code OUT NOCOPY VARCHAR2) IS
534:
535: CURSOR c_get_master_details(cp_item_id NUMBER) IS
536: SELECT Lifecycle_id, Current_Phase_Id
537: FROM mtl_system_items_b
538: WHERE inventory_item_id = cp_item_id
539: AND organization_id IN
540: (SELECT organization_id
541: FROM mtl_parameters

Line 545: FROM mtl_system_items_interface

541: FROM mtl_parameters
542: WHERE organization_id = master_organization_id)
543: UNION
544: SELECT Lifecycle_id, Current_Phase_Id
545: FROM mtl_system_items_interface
546: WHERE inventory_item_id = cp_item_id
547: AND process_flag = 4
548: AND organization_id IN
549: (SELECT organization_id

Line 556: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';

552:
553: CURSOR c_get_control_level IS
554: SELECT control_level
555: FROM mtl_item_attributes
556: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
557:
558:
559: l_Master_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
560: l_Master_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;

Line 559: l_Master_Phase_Id mtl_system_items_b.current_phase_id%TYPE;

555: FROM mtl_item_attributes
556: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
557:
558:
559: l_Master_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
560: l_Master_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;
561: l_status_control NUMBER(2) := 1; --Master controlled
562: BEGIN
563: X_Error_Code := NULL;

Line 560: l_Master_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;

556: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE';
557:
558:
559: l_Master_Phase_Id mtl_system_items_b.current_phase_id%TYPE;
560: l_Master_Lifecycle_Id mtl_system_items_b.lifecycle_id%TYPE;
561: l_status_control NUMBER(2) := 1; --Master controlled
562: BEGIN
563: X_Error_Code := NULL;
564: X_Error_Column := NULL;

Line 685: FROM mtl_system_items_interface int

681: style_item_flag,
682: trade_item_descriptor,
683: gdsn_outbound_enabled_flag,
684: primary_uom_code
685: FROM mtl_system_items_interface int
686: WHERE (int.organization_id = P_Org_Id OR P_All_Org = 1)
687: AND int.set_process_id = P_Set_id
688: AND int.process_flag = P_Process_Flag
689: AND EXISTS -- organization_id IN

Line 713: FROM mtl_system_items_interface int

709: style_item_flag,
710: trade_item_descriptor,
711: gdsn_outbound_enabled_flag,
712: primary_uom_code
713: FROM mtl_system_items_interface int
714: WHERE (int.organization_id = P_Org_Id OR P_All_Org = 1)
715: AND int.set_process_id = P_Set_id
716: AND int.process_flag = P_Process_Flag
717: AND NOT EXISTS -- organization_id NOT IN

Line 736: FROM mtl_system_items

732: SELECT item_catalog_group_Id,approval_status
733: ,unit_weight, weight_uom_code,trade_item_descriptor
734: ,gdsn_outbound_enabled_flag
735: ,lifecycle_id, current_phase_id -- Bug 11768298
736: FROM mtl_system_items
737: WHERE inventory_item_id = cp_inventory_item_id
738: AND organization_id = cp_organization_id;
739:
740: CURSOR c_pack_item_type (cp_pack_item_type IN VARCHAR2)

Line 766: FROM mtl_system_items_interface

762: WHERE NVL(NEW_ITEM_REQUEST_REQD,'N') = 'Y'
763: AND item_Catalog_group_id = cp_catalog_group_id
764: )
765: AND EXISTS ( SELECT NULL
766: FROM mtl_system_items_interface
767: WHERE NVL(eng_item_flag,'N')='N'
768: AND rowid = cp_row_id);
769:
770: l_valid_status VARCHAR2(1) := 'N';

Line 771: l_old_pack_item_type MTL_SYSTEM_ITEMS_B.trade_item_descriptor%TYPE;

767: WHERE NVL(eng_item_flag,'N')='N'
768: AND rowid = cp_row_id);
769:
770: l_valid_status VARCHAR2(1) := 'N';
771: l_old_pack_item_type MTL_SYSTEM_ITEMS_B.trade_item_descriptor%TYPE;
772: l_ret_status VARCHAR2(100);
773: l_valid_pack_type NUMBER := 0;
774: l_item_in_pack VARCHAR2(1) := FND_API.G_FALSE;
775: l_old_gdsn_flag VARCHAR2(1);

Line 791: l_old_unit_weight MTL_SYSTEM_ITEMS_B.UNIT_WEIGHT%TYPE;

787: X_MSG_COUNT NUMBER;
788: X_MSG_DATA VARCHAR2(240);
789: l_old_catalog_group_id NUMBER;
790: l_approval_status VARCHAR2(1);
791: l_old_unit_weight MTL_SYSTEM_ITEMS_B.UNIT_WEIGHT%TYPE;
792: l_old_weight_uom_code MTL_SYSTEM_ITEMS_B.WEIGHT_UOM_CODE%TYPE;
793: l_valid VARCHAR2(100) := FND_API.G_TRUE;
794: l_is_gdsn NUMBER;
795: l_unit_wt_disp_name VARCHAR2(1000);

Line 792: l_old_weight_uom_code MTL_SYSTEM_ITEMS_B.WEIGHT_UOM_CODE%TYPE;

788: X_MSG_DATA VARCHAR2(240);
789: l_old_catalog_group_id NUMBER;
790: l_approval_status VARCHAR2(1);
791: l_old_unit_weight MTL_SYSTEM_ITEMS_B.UNIT_WEIGHT%TYPE;
792: l_old_weight_uom_code MTL_SYSTEM_ITEMS_B.WEIGHT_UOM_CODE%TYPE;
793: l_valid VARCHAR2(100) := FND_API.G_TRUE;
794: l_is_gdsn NUMBER;
795: l_unit_wt_disp_name VARCHAR2(1000);
796: l_unit_wt_uom_disp_name VARCHAR2(1000);

Line 800: l_old_lifecycle_id MTL_SYSTEM_ITEMS_B.lifecycle_id%TYPE;

796: l_unit_wt_uom_disp_name VARCHAR2(1000);
797: l_gtid_disp_name VARCHAR2(1000);
798:
799: -- Bug 11768298 : Start
800: l_old_lifecycle_id MTL_SYSTEM_ITEMS_B.lifecycle_id%TYPE;
801: l_old_current_phase_id MTL_SYSTEM_ITEMS_B.current_phase_id%TYPE;
802: -- Bug 11768298 : End
803:
804: BEGIN

Line 801: l_old_current_phase_id MTL_SYSTEM_ITEMS_B.current_phase_id%TYPE;

797: l_gtid_disp_name VARCHAR2(1000);
798:
799: -- Bug 11768298 : Start
800: l_old_lifecycle_id MTL_SYSTEM_ITEMS_B.lifecycle_id%TYPE;
801: l_old_current_phase_id MTL_SYSTEM_ITEMS_B.current_phase_id%TYPE;
802: -- Bug 11768298 : End
803:
804: BEGIN
805:

Line 849: 'MTL_SYSTEM_ITEMS_INTERFACE',

845: P_Request_id,
846: cur.transaction_id,
847: l_error_msg,
848: 'ENG_ITEM_FLAG',
849: 'MTL_SYSTEM_ITEMS_INTERFACE',
850: 'INV_IOI_NIR_NO_MFG_ITEM',
851: X_Err_Text);
852: IF l_error_logged < 0 THEN
853: Raise LOGGING_ERR;

Line 885: 'MTL_SYSTEM_ITEMS_INTERFACE',

881: P_Request_id,
882: cur.transaction_id,
883: l_error_msg,
884: X_Error_Column,
885: 'MTL_SYSTEM_ITEMS_INTERFACE',
886: X_Error_Code,
887: X_Err_Text);
888: IF l_error_logged < 0 THEN
889: Raise LOGGING_ERR;

Line 922: 'MTL_SYSTEM_ITEMS_INTERFACE',

918: P_Request_id,
919: cur.transaction_id,
920: l_error_msg,
921: X_Error_Column,
922: 'MTL_SYSTEM_ITEMS_INTERFACE',
923: X_Error_Code,
924: X_Err_Text);
925:
926: IF l_error_logged < 0 THEN

Line 946: 'MTL_SYSTEM_ITEMS_INTERFACE',

942: P_Request_id,
943: cur.transaction_id,
944: l_error_msg,
945: 'CURRENT_PHASE_ID',
946: 'MTL_SYSTEM_ITEMS_INTERFACE',
947: 'INV_IOI_LIFECYCLE_MANDATORY',
948: X_Err_Text);
949:
950: IF l_error_logged < 0 THEN

Line 1001: 'MTL_SYSTEM_ITEMS_INTERFACE',

997: P_Request_id,
998: cur.transaction_id,
999: l_error_msg,
1000: 'UNIT_WEIGHT',
1001: 'MTL_SYSTEM_ITEMS_INTERFACE',
1002: 'INV_IOI_ERR_2ATTRS_UNEDITABLE',--added by bug 11894684, replace INV_IOI_ERR with specific message name so we can identify error easily
1003: X_Err_Text);
1004:
1005: IF l_error_logged < 0 THEN

Line 1019: UPDATE mtl_system_items_interface

1015: p_xset_id => P_Set_id,
1016: x_err_text => x_err_text);
1017: IF l_ret_status <> 0 THEN
1018:
1019: UPDATE mtl_system_items_interface
1020: SET process_flag = 3
1021: WHERE rowid = cur.rowid;
1022:
1023: l_error_logged := INVPUOPI.mtl_log_interface_err(

Line 1033: 'MTL_SYSTEM_ITEMS_INTERFACE',

1029: P_Request_id,
1030: cur.transaction_id,
1031: SQLERRM,
1032: 'STYLE_ITEM_FLAG',
1033: 'MTL_SYSTEM_ITEMS_INTERFACE',
1034: 'INV_IOI_ERR_VLDATE_STYL_SKU01',--added by bug 11894684, replace INV_IOI_ERR with specific message name so we can identify error easily
1035: x_err_text);
1036: IF l_error_logged < 0 THEN
1037: Raise LOGGING_ERR;

Line 1073: 'MTL_SYSTEM_ITEMS_INTERFACE',

1069: P_Request_id,
1070: cur.transaction_id,
1071: X_MSG_DATA,
1072: 'ITEM_CATALOG_GROUP_ID',
1073: 'MTL_SYSTEM_ITEMS_INTERFACE',
1074: 'INV_IOI_ERR_CHANGE_IC_01',--bug 11894684, replace INV_IOI_ERR
1075: X_ERR_TEXT);
1076:
1077: IF l_error_logged < 0 THEN

Line 1112: 'MTL_SYSTEM_ITEMS_INTERFACE',

1108: P_Request_id,
1109: cur.transaction_id,
1110: l_error_msg,
1111: 'ITEM_CATALOG_GROUP_ID',
1112: 'MTL_SYSTEM_ITEMS_INTERFACE',
1113: x_err_text,
1114: x_err_text);
1115:
1116: IF l_error_logged < 0 THEN

Line 1151: 'MTL_SYSTEM_ITEMS_INTERFACE',

1147: P_Request_id,
1148: cur.transaction_id,
1149: x_msg_data,
1150: 'lifecycle_id',
1151: 'MTL_SYSTEM_ITEMS_INTERFACE',
1152: 'INV_IOI_ERR_CHANGE_ITEM_LC',--bug 11894684, replace INV_IOI_ERR
1153: x_err_text);
1154: IF l_error_logged < 0 THEN
1155: Raise LOGGING_ERR;

Line 1178: 'MTL_SYSTEM_ITEMS_INTERFACE',

1174: P_Request_id,
1175: cur.transaction_id,
1176: l_error_msg,
1177: 'GDSN_OUTBOUND_ENABLED_FLAG',
1178: 'MTL_SYSTEM_ITEMS_INTERFACE',
1179: 'INV_GDSN_UPD_NO_INVALID',
1180: X_Err_Text);
1181: l_error_status := 1;
1182: END IF;

Line 1205: 'MTL_SYSTEM_ITEMS_INTERFACE',

1201: P_Request_id,
1202: cur.transaction_id,
1203: l_error_msg,
1204: 'TRADE_ITEM_DESCRIPTOR',
1205: 'MTL_SYSTEM_ITEMS_INTERFACE',
1206: 'INV_INVALID_PACK_TYPE',
1207: X_Err_Text);
1208: l_error_status := 1;
1209: END IF;

Line 1229: 'MTL_SYSTEM_ITEMS_INTERFACE',

1225: P_Request_id,
1226: cur.transaction_id,
1227: l_err_text,
1228: 'TRADE_ITEM_DESCRIPTOR',
1229: 'MTL_SYSTEM_ITEMS_INTERFACE',
1230: 'INV_IOI_ERR_GTID_NOT_BE_BS_01',--bug 11894684, replace INV_IOI_ERR
1231: X_Err_Text);
1232: l_error_status := 1;
1233: END IF;

Line 1277: 'MTL_SYSTEM_ITEMS_INTERFACE',

1273: P_Request_id,
1274: cur.transaction_id,
1275: l_error_msg,
1276: 'TRADE_ITEM_DESCRIPTOR',
1277: 'MTL_SYSTEM_ITEMS_INTERFACE',
1278: 'INV_ITEM_IN_PACK',
1279: X_Err_Text);
1280: l_error_status := 1;
1281: END IF;

Line 1303: 'MTL_SYSTEM_ITEMS_INTERFACE',

1299: P_Request_id,
1300: cur.transaction_id,
1301: x_msg_data,
1302: 'TRADE_ITEM_DESCRIPTOR',
1303: 'MTL_SYSTEM_ITEMS_INTERFACE',
1304: 'INV_IOI_ERR_GTID_UPDATE_01',--bug 11894684, replace INV_IOI_ERR
1305: X_Err_Text);
1306: l_error_status := 1;
1307: END IF;

Line 1315: UPDATE mtl_system_items_interface

1311: END IF; --R12 C validations ONLY at the end
1312:
1313: IF l_error_status = 1 THEN
1314: --Set process flag since failed in LC validation
1315: UPDATE mtl_system_items_interface
1316: SET process_flag = 3
1317: WHERE rowid = cur.rowid;
1318: END IF;
1319:

Line 1353: 'MTL_SYSTEM_ITEMS_INTERFACE',

1349: P_Request_id,
1350: cur.transaction_id,
1351: l_error_msg,
1352: X_Error_Column,
1353: 'MTL_SYSTEM_ITEMS_INTERFACE',
1354: X_Error_Code,
1355: X_Err_Text);
1356:
1357: IF l_error_logged < 0 THEN

Line 1376: 'MTL_SYSTEM_ITEMS_INTERFACE',

1372: P_Request_id,
1373: cur.transaction_id,
1374: l_error_msg,
1375: 'CURRENT_PHASE_ID',
1376: 'MTL_SYSTEM_ITEMS_INTERFACE',
1377: 'INV_IOI_LIFECYCLE_MANDATORY',
1378: X_Err_Text);
1379:
1380: IF l_error_logged < 0 THEN

Line 1423: 'MTL_SYSTEM_ITEMS_INTERFACE',

1419: P_Request_id,
1420: cur.transaction_id,
1421: l_error_msg,
1422: 'UNIT_WEIGHT',
1423: 'MTL_SYSTEM_ITEMS_INTERFACE',
1424: 'INV_IOI_ERR_E_ATTR_UNEDITABLE',--bug 11894684, replace INV_IOI_ERR
1425: X_Err_Text);
1426:
1427: IF l_error_logged < 0 THEN

Line 1443: UPDATE mtl_system_items_interface

1439: p_xset_id => P_Set_id,
1440: x_err_text => x_err_text);
1441: IF l_error_status <> 0 THEN
1442:
1443: UPDATE mtl_system_items_interface
1444: SET process_flag = 3
1445: WHERE rowid = cur.rowid;
1446:
1447: l_error_logged := INVPUOPI.mtl_log_interface_err(

Line 1457: 'MTL_SYSTEM_ITEMS_INTERFACE',

1453: P_Request_id,
1454: cur.transaction_id,
1455: SQLERRM,
1456: 'STYLE_ITEM_FLAG',
1457: 'MTL_SYSTEM_ITEMS_INTERFACE',
1458: 'INV_IOI_ERR_VLDATE_STYL_SKU02',--bug 11894684, replace INV_IOI_ERR
1459: x_err_text);
1460: IF l_error_logged < 0 THEN
1461: Raise LOGGING_ERR;

Line 1496: 'MTL_SYSTEM_ITEMS_INTERFACE',

1492: P_Request_id,
1493: cur.transaction_id,
1494: X_MSG_DATA,
1495: 'ITEM_CATALOG_GROUP_ID',
1496: 'MTL_SYSTEM_ITEMS_INTERFACE',
1497: 'INV_IOI_ERR_CHANGE_IC_02', --bug 11894684, replace INV_IOI_ERR
1498: X_ERR_TEXT);
1499:
1500: IF l_error_logged < 0 THEN

Line 1535: 'MTL_SYSTEM_ITEMS_INTERFACE',

1531: P_Request_id,
1532: cur.transaction_id,
1533: l_error_msg,
1534: 'ITEM_CATALOG_GROUP_ID',
1535: 'MTL_SYSTEM_ITEMS_INTERFACE',
1536: x_err_text,
1537: x_err_text);
1538:
1539: IF l_error_logged < 0 THEN

Line 1561: 'MTL_SYSTEM_ITEMS_INTERFACE',

1557: P_Request_id,
1558: cur.transaction_id,
1559: l_error_msg,
1560: 'GDSN_OUTBOUND_ENABLED_FLAG',
1561: 'MTL_SYSTEM_ITEMS_INTERFACE',
1562: 'INV_GDSN_UPD_NO_INVALID',
1563: X_Err_Text);
1564: l_error_status := 1;
1565: END IF;

Line 1588: 'MTL_SYSTEM_ITEMS_INTERFACE',

1584: P_Request_id,
1585: cur.transaction_id,
1586: l_error_msg,
1587: 'TRADE_ITEM_DESCRIPTOR',
1588: 'MTL_SYSTEM_ITEMS_INTERFACE',
1589: 'INV_INVALID_PACK_TYPE',
1590: X_Err_Text);
1591: l_error_status := 1;
1592: END IF;

Line 1613: 'MTL_SYSTEM_ITEMS_INTERFACE',

1609: P_Request_id,
1610: cur.transaction_id,
1611: l_err_text,
1612: 'TRADE_ITEM_DESCRIPTOR',
1613: 'MTL_SYSTEM_ITEMS_INTERFACE',
1614: 'INV_IOI_ERR_GTID_NOT_BE_BS_02',--bug 11894684, replace INV_IOI_ERR
1615: X_Err_Text);
1616: l_error_status := 1;
1617: END IF;

Line 1660: 'MTL_SYSTEM_ITEMS_INTERFACE',

1656: P_Request_id,
1657: cur.transaction_id,
1658: l_error_msg,
1659: 'TRADE_ITEM_DESCRIPTOR',
1660: 'MTL_SYSTEM_ITEMS_INTERFACE',
1661: 'INV_ITEM_IN_PACK',
1662: X_Err_Text);
1663: l_error_status := 1;
1664: END IF;

Line 1686: 'MTL_SYSTEM_ITEMS_INTERFACE',

1682: P_Request_id,
1683: cur.transaction_id,
1684: x_msg_data,
1685: 'TRADE_ITEM_DESCRIPTOR',
1686: 'MTL_SYSTEM_ITEMS_INTERFACE',
1687: 'INV_IOI_ERR_GTID_UPDATE_02',--bug 11894684, replace INV_IOI_ERR
1688: X_Err_Text);
1689: l_error_status := 1;
1690: END IF;

Line 1698: UPDATE mtl_system_items_interface

1694: END IF; --process flag 4
1695:
1696: IF l_error_status = 1 THEN
1697: --Set process flag since failed in LC validation
1698: UPDATE mtl_system_items_interface
1699: SET process_flag = 3
1700: WHERE rowid = cur.rowid;
1701: END IF;
1702:

Line 1816: FROM mtl_system_items_interface msii,

1812: msii.transaction_type,
1813: msii.item_number, --5522789
1814: mp.master_organization_id,
1815: msii.created_by
1816: FROM mtl_system_items_interface msii,
1817: mtl_parameters mp
1818: WHERE (msii.organization_id = P_Org_Id OR P_All_Org = 1)
1819: AND msii.set_process_id = P_Set_id
1820: AND msii.process_flag = P_Process_flag

Line 1830: FROM mtl_system_items_b

1826: IS
1827: SELECT item_catalog_group_id, approval_status,
1828: inventory_item_status_code,lifecycle_id,
1829: current_phase_id
1830: FROM mtl_system_items_b
1831: WHERE organization_id = cp_org_id
1832: AND inventory_item_id = cp_item_id;
1833:
1834: l_has_privilege VARCHAR2(1) := 'F';

Line 1844: l_approval_status mtl_system_items_b.approval_status%TYPE;

1840: l_error_code VARCHAR2(70);
1841: l_err_text VARCHAR2(240);
1842: l_item_catalog NUMBER := 0;
1843: l_has_access VARCHAR2(1):= 'F';
1844: l_approval_status mtl_system_items_b.approval_status%TYPE;
1845: l_inventory_item_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
1846: l_lifecycle_id mtl_system_items.lifecycle_id%TYPE;
1847: l_current_phase_id mtl_system_items.current_phase_id%TYPE;
1848: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;

Line 1845: l_inventory_item_status_code mtl_system_items_b.inventory_item_status_code%TYPE;

1841: l_err_text VARCHAR2(240);
1842: l_item_catalog NUMBER := 0;
1843: l_has_access VARCHAR2(1):= 'F';
1844: l_approval_status mtl_system_items_b.approval_status%TYPE;
1845: l_inventory_item_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
1846: l_lifecycle_id mtl_system_items.lifecycle_id%TYPE;
1847: l_current_phase_id mtl_system_items.current_phase_id%TYPE;
1848: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;
1849: BEGIN

Line 1846: l_lifecycle_id mtl_system_items.lifecycle_id%TYPE;

1842: l_item_catalog NUMBER := 0;
1843: l_has_access VARCHAR2(1):= 'F';
1844: l_approval_status mtl_system_items_b.approval_status%TYPE;
1845: l_inventory_item_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
1846: l_lifecycle_id mtl_system_items.lifecycle_id%TYPE;
1847: l_current_phase_id mtl_system_items.current_phase_id%TYPE;
1848: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;
1849: BEGIN
1850:

Line 1847: l_current_phase_id mtl_system_items.current_phase_id%TYPE;

1843: l_has_access VARCHAR2(1):= 'F';
1844: l_approval_status mtl_system_items_b.approval_status%TYPE;
1845: l_inventory_item_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
1846: l_lifecycle_id mtl_system_items.lifecycle_id%TYPE;
1847: l_current_phase_id mtl_system_items.current_phase_id%TYPE;
1848: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;
1849: BEGIN
1850:
1851: IF INV_EGO_REVISION_VALIDATE.Get_Process_Control ='EGO_ITEM_BULKLOAD' THEN

Line 2033: 'MTL_SYSTEM_ITEMS_INTERFACE',

2029: P_Request_id,
2030: cur.transaction_id,
2031: l_error_msg,
2032: l_error_column,
2033: 'MTL_SYSTEM_ITEMS_INTERFACE',
2034: l_error_code,
2035: l_err_text);
2036: IF l_error_logged < 0 THEN
2037: Raise LOGGING_ERR;

Line 2040: UPDATE mtl_system_items_interface

2036: IF l_error_logged < 0 THEN
2037: Raise LOGGING_ERR;
2038: END IF;
2039:
2040: UPDATE mtl_system_items_interface
2041: SET process_flag = 3
2042: WHERE rowid = cur.rowid;
2043:
2044: END IF;

Line 2077: FROM mtl_system_items_interface interface

2073: interface.template_id,
2074: interface.transaction_id,
2075: interface.transaction_type,
2076: interface.rowid
2077: FROM mtl_system_items_interface interface
2078: WHERE interface.set_process_id = cp_set_process_id
2079: AND interface.process_flag = 4
2080: AND interface.transaction_type = 'CREATE'
2081: --4676088AND interface.transaction_type IN ('CREATE','UPDATE')

Line 2263: UPDATE mtl_system_items_interface

2259: ,x_msg_data => l_msg_data);
2260:
2261: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2262:
2263: UPDATE mtl_system_items_interface
2264: SET process_flag = 3
2265: WHERE rowid = cur.rowid;
2266: l_error_logged := INVPUOPI.mtl_log_interface_err(
2267: cur.organization_id,

Line 2276: 'MTL_SYSTEM_ITEMS_INTERFACE',

2272: FND_GLOBAL.CONC_REQUEST_ID,
2273: cur.transaction_id,
2274: l_msg_data,
2275: 'TEMPLATE_ID',
2276: 'MTL_SYSTEM_ITEMS_INTERFACE',
2277: 'INV_IOI_ERR_APLTMPLUDA2ITMS',--bug 11894684, replace INV_IOI_ERR
2278: l_err_text);
2279: IF l_error_logged < 0 THEN
2280: Raise LOGGING_ERR;

Line 2302: UPDATE mtl_system_items_interface

2298: FND_MESSAGE.SET_TOKEN ('USER_ID', FND_GLOBAL.User_Id);
2299: l_msg_data := FND_MESSAGE.GET;
2300: For exc IN c_get_processed_records (P_Set_Id)
2301: LOOP
2302: UPDATE mtl_system_items_interface
2303: SET process_flag = 3
2304: WHERE rowid = exc.rowid;
2305: l_error_logged := INVPUOPI.mtl_log_interface_err(
2306: exc.organization_id,

Line 2315: 'MTL_SYSTEM_ITEMS_INTERFACE',

2311: FND_GLOBAL.CONC_REQUEST_ID,
2312: exc.transaction_id,
2313: l_msg_data,
2314: 'LOGIN_USER_ID',
2315: 'MTL_SYSTEM_ITEMS_INTERFACE',
2316: 'INV_IOI_ERR_INVALID_USER',--bug 11894684, replace INV_IOI_ERR
2317: l_err_text);
2318: IF l_error_logged < 0 THEN
2319: Raise LOGGING_ERR;

Line 2497: FROM MTL_SYSTEM_ITEMS_INTERFACE

2493: ,current_phase_id
2494: ,transaction_id
2495: ,inventory_item_status_code
2496: ,rowid
2497: FROM MTL_SYSTEM_ITEMS_INTERFACE
2498: WHERE (set_process_id = p_set_id OR set_process_id = p_set_id + 1000000000000)
2499: AND transaction_type IN ('UPDATE', 'AUTO_CHILD')
2500: AND process_flag = 4;
2501:

Line 2506: FROM MTL_SYSTEM_ITEMS_B

2502: CURSOR c_get_existing_item_record(cp_item_id NUMBER, cp_org_id NUMBER) IS
2503: SELECT item_catalog_group_id
2504: ,lifecycle_id
2505: ,current_phase_id
2506: FROM MTL_SYSTEM_ITEMS_B
2507: WHERE inventory_item_id = cp_item_id
2508: AND organization_id = cp_org_id;
2509:
2510:

Line 2658: UPDATE mtl_system_items_interface

2654: END IF;
2655:
2656: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2657:
2658: UPDATE mtl_system_items_interface
2659: SET process_flag = 3
2660: WHERE rowid = cur.rowid;
2661:
2662: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 2672: ,'MTL_SYSTEM_ITEMS_INTERFACE'

2668: ,P_Request_Id
2669: ,cur.transaction_id
2670: ,l_msg_text
2671: ,l_column_name
2672: ,'MTL_SYSTEM_ITEMS_INTERFACE'
2673: ,'INV_IOI_ERR_C_ITM_LC_DEPND_01'--bug 11894684, replace INV_IOI_ERR
2674: ,err_text);
2675: END IF;
2676: END LOOP;

Line 2994: FROM mtl_system_items_interface interface,

2990: CURSOR c_nir_rec (cp_batch_id IN NUMBER)
2991: IS
2992: SELECT interface.inventory_item_id, interface.organization_id,
2993: interface.item_catalog_group_id
2994: FROM mtl_system_items_interface interface,
2995: mtl_parameters mp
2996: WHERE interface.SET_PROCESS_ID = p_set_process_id
2997: AND interface.PROCESS_FLAG = 4
2998: AND interface.TRANSACTION_TYPE = 'CREATE'

Line 3049: UPDATE MTL_SYSTEM_ITEMS_B

3045: FETCH c_nir_reqd INTO l_nir_reqd;
3046: CLOSE c_nir_reqd;
3047:
3048: IF l_nir_reqd = 'Y' THEN
3049: UPDATE MTL_SYSTEM_ITEMS_B
3050: SET INVENTORY_ITEM_STATUS_CODE='Pending'
3051: ,APPROVAL_STATUS = 'N'
3052: ,CURRENT_PHASE_ID = DECODE(LIFECYCLE_ID,NULL,NULL,Get_Initial_Lifecycle_Phase(LIFECYCLE_ID))
3053: WHERE INVENTORY_ITEM_ID = nir_item.inventory_item_id

Line 3064: UPDATE mtl_system_items_b

3060:
3061: --EMTAPIA: added for bug 7036113
3062: /* Bug 8799957. Replacing LEVEL = 1 condition with ROWNUM = 1 to check if New Item Request is
3063: required or not, in case child ICC is inheriting NIR from parent ICC */
3064: UPDATE mtl_system_items_b
3065: SET inventory_item_status_code = 'Pending',
3066: approval_status = 'N',
3067: current_phase_id = DECODE(lifecycle_id, NULL, NULL,
3068: Get_Initial_Lifecycle_Phase(lifecycle_id))

Line 3071: FROM mtl_system_items_interface interface,

3067: current_phase_id = DECODE(lifecycle_id, NULL, NULL,
3068: Get_Initial_Lifecycle_Phase(lifecycle_id))
3069: WHERE (inventory_item_id, organization_id) IN
3070: (SELECT interface.inventory_item_id, interface.organization_id
3071: FROM mtl_system_items_interface interface,
3072: mtl_parameters mp
3073: WHERE interface.set_process_id = p_set_process_id
3074: AND interface.process_flag = 4
3075: AND interface.transaction_type = 'CREATE'

Line 3117: UPDATE mtl_system_items_interface msii

3113:
3114: IF l_nir_import_option <> 'N' THEN
3115:
3116: /* R12C Modifying stmt to support hierarchy enabled catalogs for NIR reqd */
3117: UPDATE mtl_system_items_interface msii
3118: SET msii.process_flag = 5
3119: WHERE msii.ROWID IN
3120: ( SELECT interface.ROWID
3121: FROM mtl_system_items_interface interface,

Line 3121: FROM mtl_system_items_interface interface,

3117: UPDATE mtl_system_items_interface msii
3118: SET msii.process_flag = 5
3119: WHERE msii.ROWID IN
3120: ( SELECT interface.ROWID
3121: FROM mtl_system_items_interface interface,
3122: -- MTL_ITEM_CATALOG_GROUPS_B micb,
3123: MTL_PARAMETERS mp
3124: WHERE interface.SET_PROCESS_ID = p_set_process_id
3125: AND interface.PROCESS_FLAG = 4

Line 3148: UPDATE mtl_system_items_interface

3144: x_msg_data => l_msg_data,
3145: x_msg_count => l_msg_count );
3146:
3147: IF (l_ret_status = FND_API.G_RET_STS_SUCCESS )THEN
3148: UPDATE mtl_system_items_interface
3149: SET process_flag = 4
3150: WHERE set_process_id = p_set_process_id
3151: AND process_flag = 5;
3152: ELSE

Line 3158: UPDATE mtl_system_items_interface

3154: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Following exception from CM during NIR creation');
3155: INVPUTLI.info(l_msg_data);
3156: END IF;
3157:
3158: UPDATE mtl_system_items_interface
3159: SET process_flag = 3,
3160: change_id = NULL,
3161: change_line_id = NULL
3162: WHERE set_process_id = p_set_process_id

Line 3174: UPDATE mtl_system_items_interface

3170: IF l_inv_debug_level IN(101, 102) THEN
3171: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));
3172: END IF;
3173:
3174: UPDATE mtl_system_items_interface
3175: SET process_flag = 3,
3176: change_id = NULL,
3177: change_line_id = NULL
3178: WHERE set_process_id = p_set_process_id

Line 3197: FROM MTL_SYSTEM_ITEMS_INTERFACE interface,

3193: interface.ITEM_NUMBER,
3194: interface.rowid,
3195: micb.NEW_ITEM_REQ_CHANGE_TYPE_ID,
3196: mp.ORGANIZATION_CODE
3197: FROM MTL_SYSTEM_ITEMS_INTERFACE interface,
3198: MTL_ITEM_CATALOG_GROUPS_B micb,
3199: MTL_PARAMETERS mp
3200: WHERE interface.SET_PROCESS_ID = cp_set_process_id
3201: AND interface.PROCESS_FLAG = 4

Line 3229: UPDATE MTL_SYSTEM_ITEMS_B

3225: FOR i in c_get_processed_records(p_set_process_id) LOOP
3226: --Ideally this update should be done only after NIR created succesfully
3227: -- but for technical reasons we are not stoping item creation even though
3228: -- NIR is not created.
3229: UPDATE MTL_SYSTEM_ITEMS_B
3230: SET INVENTORY_ITEM_STATUS_CODE='Pending'
3231: ,APPROVAL_STATUS = 'N'
3232: ,CURRENT_PHASE_ID = DECODE(LIFECYCLE_ID,NULL,NULL,Get_Initial_Lifecycle_Phase(LIFECYCLE_ID))
3233: WHERE INVENTORY_ITEM_ID = i.inventory_item_id

Line 3273: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

3269: ELSE
3270: l_error := true;
3271: END IF;
3272: IF (l_error OR l_return_status ='G' )THEN
3273: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3274: SET process_flag = 3
3275: WHERE rowid = i.rowid;
3276:
3277: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 3287: ,'MTL_SYSTEM_ITEMS_INTERFACE'

3283: FND_GLOBAL.CONC_REQUEST_ID
3284: ,i.transaction_id
3285: ,err_text
3286: ,'ITEM_NUMBER'
3287: ,'MTL_SYSTEM_ITEMS_INTERFACE'
3288: ,'INV_IOI_NO_AUTO_NIR'
3289: ,err_text);
3290: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS )THEN
3291: Error_Handler.Get_Message_List( x_message_list => l_error_table);

Line 3292: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

3288: ,'INV_IOI_NO_AUTO_NIR'
3289: ,err_text);
3290: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS )THEN
3291: Error_Handler.Get_Message_List( x_message_list => l_error_table);
3292: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3293: SET process_flag = 3
3294: WHERE rowid = i.rowid;
3295:
3296: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 3306: ,'MTL_SYSTEM_ITEMS_INTERFACE'

3302: FND_GLOBAL.CONC_REQUEST_ID
3303: ,i.transaction_id
3304: ,l_error_table(1).message_text
3305: ,'ITEM_CATALOG_GORUP_ID'
3306: ,'MTL_SYSTEM_ITEMS_INTERFACE'
3307: ,'INV_IOI_ERR_CREATE_NIR'--bug 11894684, replace INV_IOI_ERR
3308: ,err_text);
3309: ELSE
3310: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

Line 3310: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

3306: ,'MTL_SYSTEM_ITEMS_INTERFACE'
3307: ,'INV_IOI_ERR_CREATE_NIR'--bug 11894684, replace INV_IOI_ERR
3308: ,err_text);
3309: ELSE
3310: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3311: SET CHANGE_ID = l_change_id
3312: WHERE rowid = i.rowid;
3313: END IF;
3314: END LOOP;

Line 3322: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

3318: END IF;
3319:
3320: EXCEPTION
3321: WHEN OTHERS THEN
3322: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3323: SET process_flag = 3
3324: WHERE set_process_id= p_set_process_id;
3325:
3326:

Line 3341: ,'MTL_SYSTEM_ITEMS_INTERFACE'

3337: FND_GLOBAL.CONC_REQUEST_ID,
3338: p_set_process_id--i.transaction_id
3339: ,'CO NIR is having problem for this set proecess id'||p_set_process_id
3340: ,'ITEM_CATALOG_GORUP_ID'
3341: ,'MTL_SYSTEM_ITEMS_INTERFACE'
3342: ,'INV_IOI_ERR_E_CREATE_NIR'--bug 11894684, replace INV_IOI_ERR
3343: ,err_text);
3344: END Create_New_Item_Request; */
3345: ------------------------------------------------------------------------------------------

Line 3620: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

3616:
3617: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3618: l_error_occured := TRUE;
3619:
3620: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3621: SET process_flag = 3
3622: WHERE rowid = p_rowid;
3623:
3624: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 3634: 'MTL_SYSTEM_ITEMS_INTERFACE',

3630: p_request_id,
3631: p_transaction_id,
3632: l_error_msg,
3633: 'ITEM_CATALOG_GORUP_ID',
3634: 'MTL_SYSTEM_ITEMS_INTERFACE',
3635: 'INV_IOI_CANCEL_NIR_FAILED',
3636: x_err_text);
3637: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS )THEN
3638: l_error_occured := TRUE;

Line 3641: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

3637: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS )THEN
3638: l_error_occured := TRUE;
3639: Error_Handler.Get_Message_List( x_message_list => l_error_table);
3640:
3641: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3642: SET process_flag = 3
3643: WHERE rowid = p_rowid;
3644:
3645: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 3655: 'MTL_SYSTEM_ITEMS_INTERFACE',

3651: p_request_id,
3652: p_transaction_id,
3653: l_error_table(1).message_text,
3654: 'ITEM_CATALOG_GORUP_ID',
3655: 'MTL_SYSTEM_ITEMS_INTERFACE',
3656: 'INV_IOI_ERR_CANCEL_NIR',--bug 11894684, replace INV_IOI_ERR
3657: x_err_text);
3658: END IF;
3659: END IF; --IF l_raise_cancel_nir THEN

Line 3674: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

3670:
3671: IF (l_return_status ='G' )THEN
3672: l_error_occured := TRUE;
3673:
3674: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3675: SET process_flag = 3
3676: WHERE rowid = p_rowid;
3677:
3678: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 3688: ,'MTL_SYSTEM_ITEMS_INTERFACE'

3684: ,p_request_id
3685: ,p_transaction_id
3686: ,l_error_msg
3687: ,'ITEM_NUMBER'
3688: ,'MTL_SYSTEM_ITEMS_INTERFACE'
3689: ,'INV_IOI_NO_AUTO_NIR'
3690: ,x_err_text);
3691: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS )THEN
3692: l_error_occured := TRUE;

Line 3694: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

3690: ,x_err_text);
3691: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS )THEN
3692: l_error_occured := TRUE;
3693: Error_Handler.Get_Message_List( x_message_list => l_error_table);
3694: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
3695: SET process_flag = 3
3696: WHERE rowid = p_rowid;
3697:
3698: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 3708: ,'MTL_SYSTEM_ITEMS_INTERFACE'

3704: ,p_request_id
3705: ,p_transaction_id
3706: ,l_error_table(1).message_text
3707: ,'ITEM_CATALOG_GORUP_ID'
3708: ,'MTL_SYSTEM_ITEMS_INTERFACE'
3709: ,'INV_IOI_ERR_E_C_NIR_UPD'--bug 11894684, replace INV_IOI_ERR
3710: ,x_err_text);
3711: END IF;
3712: END IF; --IF l_raise_create_nir AND NOT l_error_occured THEN

Line 3715: UPDATE mtl_system_items_b

3711: END IF;
3712: END IF; --IF l_raise_create_nir AND NOT l_error_occured THEN
3713:
3714: IF l_update_msb AND NOT l_error_occured THEN
3715: UPDATE mtl_system_items_b
3716: SET approval_status = 'A'
3717: WHERE inventory_item_id = p_inventory_item_id
3718: AND organization_id = p_organization_id;
3719: END IF;

Line 3820: UPDATE MTL_SYSTEM_ITEMS_B

3816: SELECT new_item_req_change_type_id INTO l_type_id
3817: FROM mtl_item_catalog_groups_b
3818: WHERE item_catalog_group_id = p_item_catalog_group_id;
3819:
3820: UPDATE MTL_SYSTEM_ITEMS_B
3821: SET INVENTORY_ITEM_STATUS_CODE='Pending'
3822: ,APPROVAL_STATUS = 'N'
3823: ,CURRENT_PHASE_ID = DECODE(LIFECYCLE_ID,NULL,NULL,Get_Initial_Lifecycle_Phase(LIFECYCLE_ID))
3824: WHERE INVENTORY_ITEM_ID = p_inventory_item_id

Line 3888: UPDATE MTL_SYSTEM_ITEMS_B

3884: l_msg_count NUMBER;
3885: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
3886: l_proc_flag NUMBER;
3887: BEGIN
3888: UPDATE MTL_SYSTEM_ITEMS_B
3889: SET INVENTORY_ITEM_STATUS_CODE='Pending'
3890: ,APPROVAL_STATUS = 'N'
3891: ,CURRENT_PHASE_ID = DECODE(LIFECYCLE_ID,NULL,NULL,Get_Initial_Lifecycle_Phase(LIFECYCLE_ID))
3892: WHERE INVENTORY_ITEM_ID = p_inventory_item_id

Line 3895: UPDATE mtl_system_items_interface

3891: ,CURRENT_PHASE_ID = DECODE(LIFECYCLE_ID,NULL,NULL,Get_Initial_Lifecycle_Phase(LIFECYCLE_ID))
3892: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
3893: AND ORGANIZATION_ID = p_organization_id;
3894:
3895: UPDATE mtl_system_items_interface
3896: SET process_flag = 5
3897: WHERE rowid = p_row_id;
3898:
3899: ENG_NEW_ITEM_REQ_UTIL.Create_New_Item_Requests( p_batch_id => p_xset_id

Line 3908: UPDATE mtl_system_items_interface

3904:
3905: x_return_status := l_return_status;
3906:
3907: IF (l_return_status = FND_API.G_RET_STS_SUCCESS )THEN
3908: UPDATE mtl_system_items_interface
3909: SET process_flag = p_process_flag
3910: WHERE rowid = p_row_id;
3911: ELSE
3912: IF l_inv_debug_level IN(101, 102) THEN

Line 3917: UPDATE mtl_system_items_interface

3913: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Following exception from CM during NIR creation');
3914: INVPUTLI.info(l_err_text);
3915: END IF;
3916:
3917: UPDATE mtl_system_items_interface
3918: SET process_flag = 3,
3919: change_id = NULL,
3920: change_line_id = NULL
3921: WHERE rowid = p_row_id;

Line 3932: UPDATE mtl_system_items_interface

3928: END IF;
3929:
3930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3931:
3932: UPDATE mtl_system_items_interface
3933: SET process_flag = 3,
3934: change_id = NULL,
3935: change_line_id = NULL
3936: WHERE rowid = p_row_id;

Line 4009: FROM mtl_system_items_interface

4005: organization_id,
4006: transaction_type,
4007: request_id,
4008: transaction_id
4009: FROM mtl_system_items_interface
4010: WHERE rowid = cp_row_id;
4011:
4012: CURSOR c_master_org (cp_organization_id IN NUMBER)
4013: IS

Line 4023: FROM mtl_system_items_b

4019: Cp_organization_id IN NUMBER)
4020: IS
4021: SELECT style_item_flag,style_item_id,
4022: item_catalog_group_id
4023: FROM mtl_system_items_b
4024: WHERE inventory_item_id = cp_inventory_item_id
4025: AND organization_id = cp_organization_id;
4026:
4027: l_user_id NUMBER := FND_GLOBAL.User_Id;

Line 4089: 'MTL_SYSTEM_ITEMS_INTERFACE',

4085: l_request_id,
4086: l_transaction_id,
4087: l_err_text,
4088: 'ITEM_CATALOG_GROUP_ID',
4089: 'MTL_SYSTEM_ITEMS_INTERFACE',
4090: 'INV_STYLE_SKU_REQUIRED_ICC',
4091: X_Err_Text);
4092: l_error_exists := 1;
4093: END IF;

Line 4110: 'MTL_SYSTEM_ITEMS_INTERFACE',

4106: l_request_id,
4107: l_transaction_id,
4108: l_err_text,
4109: 'STYLE_ITEM_FLAG',
4110: 'MTL_SYSTEM_ITEMS_INTERFACE',
4111: 'INV_STYLE_SKU_NOT_UPD',
4112: X_Err_Text);
4113: l_error_exists := 1;
4114: END IF;

Line 4131: 'MTL_SYSTEM_ITEMS_INTERFACE',

4127: l_request_id,
4128: l_transaction_id,
4129: l_err_text,
4130: 'STYLE_ITEM_FLAG',
4131: 'MTL_SYSTEM_ITEMS_INTERFACE',
4132: 'INV_STYLE_ID_NOT_UPD',
4133: X_Err_Text);
4134: l_error_exists := 1;
4135: END IF;

Line 4151: 'MTL_SYSTEM_ITEMS_INTERFACE',

4147: l_request_id,
4148: l_transaction_id,
4149: l_err_text,
4150: 'STYLE_ITEM_FLAG',
4151: 'MTL_SYSTEM_ITEMS_INTERFACE',
4152: 'INV_STYLE_NOT_GDSN',
4153: X_Err_Text);
4154: l_error_exists := 1;
4155: END IF;

Line 4162: FROM mtl_system_items_b

4158: (l_transaction_type = 'UPDATE' AND NVL(l_msi_icc_id,l_null_icc_id) <> NVL(l_msii_icc_id,l_null_icc_id)) )THEN
4159: /* Styles to be created in only those ICCs that contain Variant AGs - Sec 2.5.1 -Condition 2 */
4160: IF l_msii_style_item_flag = 'Y' THEN
4161: SELECT COUNT(*) INTO l_sku_exists
4162: FROM mtl_system_items_b
4163: WHERE style_item_id = l_msii_inv_item_id
4164: AND organization_id = l_msii_org_id;
4165:
4166: IF l_sku_exists <> 0 THEN

Line 4176: 'MTL_SYSTEM_ITEMS_INTERFACE',

4172: l_request_id,
4173: l_transaction_id,
4174: l_err_text,
4175: 'ITEM_CATALOG_GROUP_ID',
4176: 'MTL_SYSTEM_ITEMS_INTERFACE',
4177: 'INV_STYLE_ICC_SKU_EXISTS',
4178: X_Err_Text);
4179: l_error_exists := 1;
4180: ELSE

Line 4203: 'MTL_SYSTEM_ITEMS_INTERFACE',

4199: l_request_id,
4200: l_transaction_id,
4201: l_err_text,
4202: 'ITEM_CATALOG_GROUP_ID',
4203: 'MTL_SYSTEM_ITEMS_INTERFACE',
4204: 'INV_STYLE_INVALID_ICC',
4205: X_Err_Text);
4206: l_error_exists := 1;
4207: ELSE

Line 4227: 'MTL_SYSTEM_ITEMS_INTERFACE',

4223: l_request_id,
4224: l_transaction_id,
4225: l_err_text,
4226: 'ITEM_CATALOG_GROUP_ID',
4227: 'MTL_SYSTEM_ITEMS_INTERFACE',
4228: 'INV_IOI_ERR_DFT_STYLE_ATTRS',--bug 11894684, replace INV_IOI_ERR
4229: X_Err_Text);
4230: l_error_exists := 1;
4231: END IF; --Create

Line 4238: FROM mtl_system_items_b

4234: END IF; --Style Item
4235: ELSE
4236: BEGIN
4237: SELECT item_catalog_group_id INTO l_style_icc_id
4238: FROM mtl_system_items_b
4239: WHERE inventory_item_id = l_msii_style_item_id
4240: AND organization_id = l_msii_org_id;
4241: EXCEPTION
4242: WHEN no_data_found THEN

Line 4259: 'MTL_SYSTEM_ITEMS_INTERFACE',

4255: l_request_id,
4256: l_transaction_id,
4257: l_err_text,
4258: 'ITEM_CATALOG_GROUP_ID',
4259: 'MTL_SYSTEM_ITEMS_INTERFACE',
4260: 'INV_SKU_INVALID_ICC',
4261: X_Err_Text);
4262: l_error_exists := 1;
4263: END IF;

Line 4290: 'MTL_SYSTEM_ITEMS_INTERFACE',

4286: l_request_id,
4287: l_transaction_id,
4288: l_err_text,
4289: 'VARIANT_ATTRIBUTE_COMB',
4290: 'MTL_SYSTEM_ITEMS_INTERFACE',
4291: 'INV_SKU_VAR_NO_UNIQUE',
4292: X_Err_Text);
4293: l_error_exists := 1;
4294: ELSIF l_error_logged <> 0 THEN

Line 4304: 'MTL_SYSTEM_ITEMS_INTERFACE',

4300: l_request_id,
4301: l_transaction_id,
4302: l_err_text,
4303: 'VARIANT_ATTRIBUTE_COMB',
4304: 'MTL_SYSTEM_ITEMS_INTERFACE',
4305: 'INV_IOI_ERR_VLD_SKU_USAGE',--bug 11894684, replace INV_IOI_ERR
4306: X_Err_Text);
4307: l_error_exists := 1;
4308: ELSIF l_var_attrs_missing = TRUE THEN

Line 4318: 'MTL_SYSTEM_ITEMS_INTERFACE',

4314: l_request_id,
4315: l_transaction_id,
4316: l_err_text,
4317: 'VARIANT_ATTRIBUTE_COMB',
4318: 'MTL_SYSTEM_ITEMS_INTERFACE',
4319: 'INV_SKU_VAR_ATTR_MISSING',
4320: X_Err_Text);
4321: l_error_exists := 1;
4322: END IF;

Line 4327: UPDATE mtl_system_items_interface

4323: END IF;
4324: END IF;
4325:
4326: IF l_error_exists = 1 THEN
4327: UPDATE mtl_system_items_interface
4328: SET process_flag = 3
4329: WHERE rowid = p_row_id;
4330: END IF;
4331: