eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INVPVDR7 dependencies on INVPUOPI

Line 157: dumm_status := INVPUOPI.mtl_log_interface_err(

153: END IF;
154:
155: IF ( cr.LOT_DIVISIBLE_FLAG IS NOT NULL
156: AND cr.LOT_DIVISIBLE_FLAG NOT IN ( 'Y','N') )THEN
157: dumm_status := INVPUOPI.mtl_log_interface_err(
158: cr.organization_id,
159: user_id,
160: login_id,
161: prog_appid,

Line 178: dumm_status := INVPUOPI.mtl_log_interface_err(

174: END IF;-- LOT_DIVISIBLE_FLAG is not null AND <> 'N','Y'
175:
176: if (cr.LOT_CONTROL_CODE <> 2 and NVL(cr.LOT_DIVISIBLE_FLAG,'N') = 'Y') then
177:
178: dumm_status := INVPUOPI.mtl_log_interface_err(
179: cr.organization_id,
180: user_id,
181: login_id,
182: prog_appid,

Line 203: dumm_status := INVPUOPI.mtl_log_interface_err(

199: INVPUTLI.info('INVPVDR7: verifying grade control flag GRADE_CONTROL_FLAG....');
200: END IF;
201: IF ( cr.GRADE_CONTROL_FLAG IS NOT NULL
202: AND cr.GRADE_CONTROL_FLAG NOT IN ( 'Y','N') )THEN
203: dumm_status := INVPUOPI.mtl_log_interface_err(
204: cr.organization_id,
205: user_id,
206: login_id,
207: prog_appid,

Line 225: dumm_status := INVPUOPI.mtl_log_interface_err(

221: END IF;-- GRADE_CONTROL_FLAG is not null AND <> 'N','Y'
222:
223: if (cr.LOT_CONTROL_CODE <> 2 and NVL(cr.GRADE_CONTROL_FLAG,'N') = 'Y') then
224:
225: dumm_status := INVPUOPI.mtl_log_interface_err(
226: cr.organization_id,
227: user_id,
228: login_id,
229: prog_appid,

Line 253: dumm_status := INVPUOPI.mtl_log_interface_err(

249: END IF;
250: if (cr.DEFAULT_GRADE IS NOT NULL) then
251: if (cr.LOT_CONTROL_CODE <> 2 or NVL(cr.GRADE_CONTROL_FLAG,'N') <> 'Y') then
252:
253: dumm_status := INVPUOPI.mtl_log_interface_err(
254: cr.organization_id,
255: user_id,
256: login_id,
257: prog_appid,

Line 281: dumm_status := INVPUOPI.mtl_log_interface_err(

277: and nvl(DISABLE_FLAG,'N') <> 'Y';
278:
279: exception
280: when NO_DATA_FOUND then
281: dumm_status := INVPUOPI.mtl_log_interface_err(
282: cr.organization_id,
283: user_id,
284: login_id,
285: prog_appid,

Line 305: dumm_status := INVPUOPI.mtl_log_interface_err(

301: end if;
302: else /*if cr.DEFAULT_GRADE IS NULL) then*/
303: --if item is grade controlled and has no default grade then log error.
304: if (cr.LOT_CONTROL_CODE = 2 and NVL(cr.GRADE_CONTROL_FLAG,'N') = 'Y') then
305: dumm_status := INVPUOPI.mtl_log_interface_err(
306: cr.organization_id,
307: user_id,
308: login_id,
309: prog_appid,

Line 335: dumm_status := INVPUOPI.mtl_log_interface_err(

331: INVPUTLI.info('INVPVDR7: verifying child lot flag....');
332: END IF;
333: IF ( cr.CHILD_LOT_FLAG IS NOT NULL
334: AND cr.CHILD_LOT_FLAG NOT IN ( 'Y','N') )THEN
335: dumm_status := INVPUOPI.mtl_log_interface_err(
336: cr.organization_id,
337: user_id,
338: login_id,
339: prog_appid,

Line 357: dumm_status := INVPUOPI.mtl_log_interface_err(

353: END IF;-- CHILD_LOT_FLAG is not null AND <> 'N','Y'
354:
355: if (cr.LOT_CONTROL_CODE <> 2 and NVL(cr.CHILD_LOT_FLAG,'N') = 'Y') then
356:
357: dumm_status := INVPUOPI.mtl_log_interface_err(
358: cr.organization_id,
359: user_id,
360: login_id,
361: prog_appid,

Line 404: dumm_status := INVPUOPI.mtl_log_interface_err(

400: and ENABLED_FLAG = 'Y';
401:
402: exception
403: when NO_DATA_FOUND then
404: dumm_status := INVPUOPI.mtl_log_interface_err(
405: cr.organization_id,
406: user_id,
407: login_id,
408: prog_appid,

Line 426: dumm_status := INVPUOPI.mtl_log_interface_err(

422: end;
423: else
424: if (cr.LOT_CONTROL_CODE = 2 and NVL(cr.CHILD_LOT_FLAG,'N') = 'Y' and lot_num_generation_val = 2) then
425:
426: dumm_status := INVPUOPI.mtl_log_interface_err(
427: cr.organization_id,
428: user_id,
429: login_id,
430: prog_appid,

Line 457: dumm_status := INVPUOPI.mtl_log_interface_err(

453: END IF;
454:
455: if (cr.CHILD_LOT_STARTING_NUMBER IS NOT NULL) then
456: if (cr.CHILD_LOT_STARTING_NUMBER < 0) THEN
457: dumm_status := INVPUOPI.mtl_log_interface_err(
458: cr.organization_id,
459: user_id,
460: login_id,
461: prog_appid,

Line 482: dumm_status := INVPUOPI.mtl_log_interface_err(

478: INTO l_child_lot_starting_number
479: FROM DUAL;
480:
481: if l_child_lot_starting_number <> cr.CHILD_LOT_STARTING_NUMBER then
482: dumm_status := INVPUOPI.mtl_log_interface_err(
483: cr.organization_id,
484: user_id,
485: login_id,
486: prog_appid,

Line 504: dumm_status := INVPUOPI.mtl_log_interface_err(

500:
501: exception
502: when others then
503: --check to see that the child lot start number is an integer.
504: dumm_status := INVPUOPI.mtl_log_interface_err(
505: cr.organization_id,
506: user_id,
507: login_id,
508: prog_appid,

Line 526: dumm_status := INVPUOPI.mtl_log_interface_err(

522: elsif cr.CHILD_LOT_STARTING_NUMBER IS NULL then
523: if cr.lot_control_code = 2 and
524: lot_num_generation_val = 2 and
525: nvl(cr.child_lot_flag,'N') = 'Y' then
526: dumm_status := INVPUOPI.mtl_log_interface_err(
527: cr.organization_id,
528: user_id,
529: login_id,
530: prog_appid,

Line 553: dumm_status := INVPUOPI.mtl_log_interface_err(

549: INVPUTLI.info('INVPVDR7: verifying child lot validate flag....');
550: END IF;
551: IF ( cr.CHILD_LOT_VALIDATION_FLAG IS NOT NULL
552: AND cr.CHILD_LOT_VALIDATION_FLAG NOT IN ( 'Y','N') )THEN
553: dumm_status := INVPUOPI.mtl_log_interface_err(
554: cr.organization_id,
555: user_id,
556: login_id,
557: prog_appid,

Line 581: dumm_status := INVPUOPI.mtl_log_interface_err(

577: END IF;
578:
579: IF ( cr.COPY_LOT_ATTRIBUTE_FLAG IS NOT NULL
580: AND cr.COPY_LOT_ATTRIBUTE_FLAG NOT IN ( 'Y','N') )THEN
581: dumm_status := INVPUOPI.mtl_log_interface_err(
582: cr.organization_id,
583: user_id,
584: login_id,
585: prog_appid,

Line 604: dumm_status := INVPUOPI.mtl_log_interface_err(

600:
601: --validate RECIPE_ENABLED_FLAG
602: IF ( cr.RECIPE_ENABLED_FLAG IS NOT NULL
603: AND cr.RECIPE_ENABLED_FLAG NOT IN ( 'Y','N') )THEN
604: dumm_status := INVPUOPI.mtl_log_interface_err(
605: cr.organization_id,
606: user_id,
607: login_id,
608: prog_appid,

Line 627: dumm_status := INVPUOPI.mtl_log_interface_err(

623:
624: --validate PROCESS_EXECUTION_ENABLED_FLAG
625: IF ( cr.PROCESS_EXECUTION_ENABLED_FLAG IS NOT NULL
626: AND cr.PROCESS_EXECUTION_ENABLED_FLAG NOT IN ( 'Y','N') )THEN
627: dumm_status := INVPUOPI.mtl_log_interface_err(
628: cr.organization_id,
629: user_id,
630: login_id,
631: prog_appid,

Line 651: dumm_status := INVPUOPI.mtl_log_interface_err(

647: --Added for bug 5300040
648: --Process execution must be No if either of inventory item or reciped enabled flags are No
649: IF ( cr.PROCESS_EXECUTION_ENABLED_FLAG = 'Y' AND
650: (cr.INVENTORY_ITEM_FLAG ='N' OR cr.RECIPE_ENABLED_FLAG ='N' ))THEN
651: dumm_status := INVPUOPI.mtl_log_interface_err(
652: cr.organization_id,
653: user_id,
654: login_id,
655: prog_appid,

Line 675: dumm_status := INVPUOPI.mtl_log_interface_err(

671:
672: --validate PROCESS_COSTING_ENABLED_FLAG
673: IF ( cr.PROCESS_COSTING_ENABLED_FLAG IS NOT NULL
674: AND cr.PROCESS_COSTING_ENABLED_FLAG NOT IN ( 'Y','N') )THEN
675: dumm_status := INVPUOPI.mtl_log_interface_err(
676: cr.organization_id,
677: user_id,
678: login_id,
679: prog_appid,

Line 698: dumm_status := INVPUOPI.mtl_log_interface_err(

694:
695: --validate PROCESS_QUALITY_ENABLED_FLAG
696: IF ( cr.PROCESS_QUALITY_ENABLED_FLAG IS NOT NULL
697: AND cr.PROCESS_QUALITY_ENABLED_FLAG NOT IN ( 'Y','N') )THEN
698: dumm_status := INVPUOPI.mtl_log_interface_err(
699: cr.organization_id,
700: user_id,
701: login_id,
702: prog_appid,

Line 760: dumm_status := INVPUOPI.mtl_log_interface_err(

756: end;
757: end if;
758:
759: if l_process_subinv_error then
760: dumm_status := INVPUOPI.mtl_log_interface_err(
761: cr.organization_id,
762: user_id,
763: login_id,
764: prog_appid,

Line 812: dumm_status := INVPUOPI.mtl_log_interface_err(

808: end if;
809: --{
810: if l_loc_mandatory
811: AND cr.PROCESS_SUPPLY_LOCATOR_ID IS NULL then
812: dumm_status := INVPUOPI.mtl_log_interface_err(
813: cr.organization_id,
814: user_id,
815: login_id,
816: prog_appid,

Line 876: dumm_status := INVPUOPI.mtl_log_interface_err(

872: end;
873: end if;
874:
875: if l_process_locator_error then
876: dumm_status := INVPUOPI.mtl_log_interface_err(
877: cr.organization_id,
878: user_id,
879: login_id,
880: prog_appid,

Line 944: dumm_status := INVPUOPI.mtl_log_interface_err(

940: end;
941: end if;
942:
943: if l_process_subinv_error then
944: dumm_status := INVPUOPI.mtl_log_interface_err(
945: cr.organization_id,
946: user_id,
947: login_id,
948: prog_appid,

Line 995: dumm_status := INVPUOPI.mtl_log_interface_err(

991: end if;
992:
993: if l_loc_mandatory
994: AND cr.PROCESS_YIELD_LOCATOR_ID IS NULL then
995: dumm_status := INVPUOPI.mtl_log_interface_err(
996: cr.organization_id,
997: user_id,
998: login_id,
999: prog_appid,

Line 1053: dumm_status := INVPUOPI.mtl_log_interface_err(

1049: end;
1050: end if;
1051:
1052: if l_process_locator_error then
1053: dumm_status := INVPUOPI.mtl_log_interface_err(
1054: cr.organization_id,
1055: user_id,
1056: login_id,
1057: prog_appid,

Line 1086: dumm_status := INVPUOPI.mtl_log_interface_err(

1082: and disable_flag= 'N';
1083:
1084: exception
1085: when NO_DATA_FOUND then
1086: dumm_status := INVPUOPI.mtl_log_interface_err(
1087: cr.organization_id,
1088: user_id,
1089: login_id,
1090: prog_appid,

Line 1115: dumm_status := INVPUOPI.mtl_log_interface_err(

1111: END IF;
1112: if (cr.RETEST_INTERVAL is NOT NULL) then
1113: if (cr.RETEST_INTERVAL < 0 OR cr.RETEST_INTERVAL > 999999) then
1114:
1115: dumm_status := INVPUOPI.mtl_log_interface_err(
1116: cr.organization_id,
1117: user_id,
1118: login_id,
1119: prog_appid,

Line 1143: dumm_status := INVPUOPI.mtl_log_interface_err(

1139: END IF;
1140: if (cr.EXPIRATION_ACTION_INTERVAL is NOT NULL) then
1141: if (cr.EXPIRATION_ACTION_INTERVAL < -999999 OR cr.EXPIRATION_ACTION_INTERVAL > 999999) then
1142:
1143: dumm_status := INVPUOPI.mtl_log_interface_err(
1144: cr.organization_id,
1145: user_id,
1146: login_id,
1147: prog_appid,

Line 1172: dumm_status := INVPUOPI.mtl_log_interface_err(

1168: END IF;
1169: if (cr.MATURITY_DAYS is NOT NULL) then
1170: if (cr.MATURITY_DAYS < 0 OR cr.MATURITY_DAYS > 999999) then
1171:
1172: dumm_status := INVPUOPI.mtl_log_interface_err(
1173: cr.organization_id,
1174: user_id,
1175: login_id,
1176: prog_appid,

Line 1201: dumm_status := INVPUOPI.mtl_log_interface_err(

1197:
1198: if (cr.HOLD_DAYS is NOT NULL) then
1199: if (cr.HOLD_DAYS < 0 OR cr.HOLD_DAYS > 999999) then
1200:
1201: dumm_status := INVPUOPI.mtl_log_interface_err(
1202: cr.organization_id,
1203: user_id,
1204: login_id,
1205: prog_appid,

Line 1227: dumm_status := INVPUOPI.mtl_log_interface_err(

1223: END IF;
1224:
1225: IF ( cr.HAZARDOUS_MATERIAL_FLAG IS NOT NULL
1226: AND cr.HAZARDOUS_MATERIAL_FLAG NOT IN ( 'Y','N') )THEN
1227: dumm_status := INVPUOPI.mtl_log_interface_err(
1228: cr.organization_id,
1229: user_id,
1230: login_id,
1231: prog_appid,

Line 1261: dumm_status := INVPUOPI.mtl_log_interface_err(

1257: AND UOM_CODE = cr.CHARGE_PERIODICITY_CODE;
1258:
1259: EXCEPTION
1260: WHEN NO_DATA_FOUND THEN
1261: dumm_status := INVPUOPI.mtl_log_interface_err(
1262: cr.organization_id,
1263: user_id,
1264: login_id,
1265: prog_appid,

Line 1286: dumm_status := INVPUOPI.mtl_log_interface_err(

1282: INVPUTLI.info('INVPVDR7: verifying repair leadtime....');
1283: END IF;
1284: IF cr.REPAIR_LEADTIME IS NOT NULL
1285: AND cr.REPAIR_LEADTIME < 0 THEN
1286: dumm_status := INVPUOPI.mtl_log_interface_err(
1287: cr.organization_id,
1288: user_id,
1289: login_id,
1290: prog_appid,

Line 1318: dumm_status := INVPUOPI.mtl_log_interface_err(

1314: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', error_msg);
1315: error_msg := FND_MESSAGE.GET;
1316: --Bug 5216657 end
1317:
1318: dumm_status := INVPUOPI.mtl_log_interface_err(
1319: cr.organization_id,
1320: user_id,
1321: login_id,
1322: prog_appid,

Line 1341: dumm_status := INVPUOPI.mtl_log_interface_err(

1337: INVPUTLI.info('INVPVDR7: verifying preposition point....');
1338: END IF;
1339:
1340: IF cr.PREPOSITION_POINT NOT IN ('Y','N') THEN
1341: dumm_status := INVPUOPI.mtl_log_interface_err(
1342: cr.organization_id,
1343: user_id,
1344: login_id,
1345: prog_appid,

Line 1364: dumm_status := INVPUOPI.mtl_log_interface_err(

1360: INVPUTLI.info('INVPVDR7: verifying repair program....');
1361: END IF;
1362:
1363: IF cr.REPAIR_PROGRAM NOT IN (1,2,3) THEN
1364: dumm_status := INVPUOPI.mtl_log_interface_err(
1365: cr.organization_id,
1366: user_id,
1367: login_id,
1368: prog_appid,

Line 1389: dumm_status := INVPUOPI.mtl_log_interface_err(

1385: END IF;
1386:
1387: IF cr.SUBCONTRACTING_COMPONENT IS NOT NULL AND
1388: cr.SUBCONTRACTING_COMPONENT NOT IN (1,2) THEN
1389: dumm_status := INVPUOPI.mtl_log_interface_err(
1390: cr.organization_id,
1391: user_id,
1392: login_id,
1393: prog_appid,

Line 1412: dumm_status := INVPUOPI.mtl_log_interface_err(

1408: INVPUTLI.info('INVPVDR7: verifying outsourced assembly....');
1409: END IF;
1410:
1411: IF cr.OUTSOURCED_ASSEMBLY NOT IN (1,2) THEN
1412: dumm_status := INVPUOPI.mtl_log_interface_err(
1413: cr.organization_id,
1414: user_id,
1415: login_id,
1416: prog_appid,

Line 1435: dumm_status := INVPUOPI.mtl_log_interface_err(

1431: INVPUTLI.info('INVPVDR7: verifying outsourced assembly,SHIKYU enabled....');
1432: END IF;
1433: IF ((NVL(l_SHIKYU_profile,'N') = 'N') AND
1434: cr.OUTSOURCED_ASSEMBLY = 1) THEN
1435: dumm_status := INVPUOPI.mtl_log_interface_err(
1436: cr.organization_id,
1437: user_id,
1438: login_id,
1439: prog_appid,

Line 1459: dumm_status := INVPUOPI.mtl_log_interface_err(

1455: END IF;
1456:
1457: IF (NVL(cr.RELEASE_TIME_FENCE_CODE,6) <> 7 AND l_trading_partner_org = 'Y'
1458: AND cr.OUTSOURCED_ASSEMBLY = 1) THEN
1459: dumm_status := INVPUOPI.mtl_log_interface_err(
1460: cr.organization_id,
1461: user_id,
1462: login_id,
1463: prog_appid,

Line 1484: dumm_status := INVPUOPI.mtl_log_interface_err(

1480: END IF;
1481:
1482: IF( NOT(l_wms_enabled = 'N' AND l_process_enabled = 'N' AND l_eam_enabled = 'N')AND
1483: cr.OUTSOURCED_ASSEMBLY = 1) THEN
1484: dumm_status := INVPUOPI.mtl_log_interface_err(
1485: cr.organization_id,
1486: user_id,
1487: login_id,
1488: prog_appid,

Line 1511: -- dumm_status := INVPUOPI.mtl_log_interface_err(

1507: -- Fix for bug#6447581
1508: -- Outsourced Assembly and Costing Method validation is commented.
1509: --
1510: -- IF(l_cost_method <> 1 AND cr.OUTSOURCED_ASSEMBLY = 1) THEN
1511: -- dumm_status := INVPUOPI.mtl_log_interface_err(
1512: -- cr.organization_id,
1513: -- user_id,
1514: -- login_id,
1515: -- prog_appid,

Line 1535: dumm_status := INVPUOPI.mtl_log_interface_err(

1531: INVPUTLI.info('INVPVDR7: verifying outsourced assembly,bom item type....');
1532: END IF;
1533: IF( NOT(cr.BOM_ITEM_TYPE = 4 AND cr.EFFECTIVITY_CONTROL = 1)AND
1534: (cr.OUTSOURCED_ASSEMBLY = 1)) THEN
1535: dumm_status := INVPUOPI.mtl_log_interface_err(
1536: cr.organization_id,
1537: user_id,
1538: login_id,
1539: prog_appid,

Line 1558: dumm_status := INVPUOPI.mtl_log_interface_err(

1554: --Bug: 5139950
1555: --Bom item type can be 5 (product family) only if inventory flag is Y
1556: --and planning_make_buy_code is 1 (Make)
1557: IF( cr.BOM_ITEM_TYPE = 5 and cr.INVENTORY_ITEM_FLAG <> 'Y') THEN
1558: dumm_status := INVPUOPI.mtl_log_interface_err(
1559: cr.organization_id,
1560: user_id,
1561: login_id,
1562: prog_appid,

Line 1580: dumm_status := INVPUOPI.mtl_log_interface_err(

1576: --Bug: 5139950
1577: --Bom item type can be 5 (product family) only if inventory flag is Y
1578: --and planning_make_buy_code is 1 (Make)
1579: IF (cr.BOM_ITEM_TYPE = 5 AND cr.INVENTORY_ITEM_FLAG = 'Y' AND cr.PLANNING_MAKE_BUY_CODE <> 1)THEN
1580: dumm_status := INVPUOPI.mtl_log_interface_err(
1581: cr.organization_id,
1582: user_id,
1583: login_id,
1584: prog_appid,

Line 1605: dumm_status := INVPUOPI.mtl_log_interface_err(

1601: END IF;
1602:
1603: IF(cr.OUTSIDE_OPERATION_FLAG = 'Y' AND cr.OUTSOURCED_ASSEMBLY = 1)
1604: THEN
1605: dumm_status := INVPUOPI.mtl_log_interface_err(
1606: cr.organization_id,
1607: user_id,
1608: login_id,
1609: prog_appid,

Line 1627: dumm_status := INVPUOPI.mtl_log_interface_err(

1623:
1624: IF((cr.INTERNAL_ORDER_FLAG = 'Y' OR cr.INTERNAL_ORDER_ENABLED_FLAG = 'Y' OR
1625: cr.PICK_COMPONENTS_FLAG ='Y' OR cr.REPLENISH_TO_ORDER_FLAG = 'Y')AND
1626: cr.OUTSOURCED_ASSEMBLY = 1) THEN
1627: dumm_status := INVPUOPI.mtl_log_interface_err(
1628: cr.organization_id,
1629: user_id,
1630: login_id,
1631: prog_appid,

Line 1652: dumm_status := INVPUOPI.mtl_log_interface_err(

1648:
1649: IF((NVL(l_SHIKYU_profile,'N') = 'N') AND
1650: cr.SUBCONTRACTING_COMPONENT IS NOT NULL)
1651: THEN
1652: dumm_status := INVPUOPI.mtl_log_interface_err(
1653: cr.organization_id,
1654: user_id,
1655: login_id,
1656: prog_appid,

Line 1676: dumm_status := INVPUOPI.mtl_log_interface_err(

1672: INVPUTLI.info('INVPVDR7: verifying subcontracting component organizations....');
1673: END IF;
1674: IF(NOT(l_wms_enabled = 'N' AND l_process_enabled = 'N' AND l_eam_enabled = 'N')AND
1675: cr.SUBCONTRACTING_COMPONENT IS NOT NULL) THEN
1676: dumm_status := INVPUOPI.mtl_log_interface_err(
1677: cr.organization_id,
1678: user_id,
1679: login_id,
1680: prog_appid,

Line 1696: dumm_status := INVPUOPI.mtl_log_interface_err(

1692: STATUS := 1;
1693: END IF;
1694:
1695: IF(l_cost_method <> 1 AND cr.SUBCONTRACTING_COMPONENT IS NOT NULL) THEN
1696: dumm_status := INVPUOPI.mtl_log_interface_err(
1697: cr.organization_id,
1698: user_id,
1699: login_id,
1700: prog_appid,

Line 1832: dumm_status := INVPUOPI.mtl_log_interface_err(

1828: when LOGGING_ERR then
1829: return(dumm_status);
1830:
1831: when VALIDATE_ERR then
1832: dumm_status := INVPUOPI.mtl_log_interface_err(
1833: l_org_id,
1834: user_id,
1835: login_id,
1836: prog_appid,