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.INVPVDR3 dependencies on INVPUTLI

Line 318: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

314: VALIDATE_ERR exception;
315: temp_proc_flag number;
316: l_err_msg varchar2(2000) := NULL;
317:
318: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
319: -- bug10433961
320: l_temp_org_id NUMBER ;
321: begin
322:

Line 324: INVPUTLI.info('Inside INVPVDR3');

320: l_temp_org_id NUMBER ;
321: begin
322:
323: IF l_inv_debug_level IN(101, 102) THEN
324: INVPUTLI.info('Inside INVPVDR3');
325: END IF;
326: error_msg := 'Validation error in validating MTL_SYSTEM_ITEMS_INTERFACE with ';
327:
328: /*

Line 361: /INVPUTLI.info('INVPVDR3: Validating lookups'); /

357: /*
358: ** Validate fields with lookup values @@
359: */
360:
361: /*INVPUTLI.info('INVPVDR3: Validating lookups'); */
362:
363: IF l_inv_debug_level IN(101, 102) THEN
364: INVPUTLI.info('INVPVDR3: L8R values: '|| l_item_id||' '|| l_org_id);
365: INVPUTLI.info('INVPVDR3: L8R revision_qty_control_code: '|| cr.revision_qty_control_code);

Line 364: INVPUTLI.info('INVPVDR3: L8R values: '|| l_item_id||' '|| l_org_id);

360:
361: /*INVPUTLI.info('INVPVDR3: Validating lookups'); */
362:
363: IF l_inv_debug_level IN(101, 102) THEN
364: INVPUTLI.info('INVPVDR3: L8R values: '|| l_item_id||' '|| l_org_id);
365: INVPUTLI.info('INVPVDR3: L8R revision_qty_control_code: '|| cr.revision_qty_control_code);
366: END IF;
367:
368: -- validate lookup

Line 365: INVPUTLI.info('INVPVDR3: L8R revision_qty_control_code: '|| cr.revision_qty_control_code);

361: /*INVPUTLI.info('INVPVDR3: Validating lookups'); */
362:
363: IF l_inv_debug_level IN(101, 102) THEN
364: INVPUTLI.info('INVPVDR3: L8R values: '|| l_item_id||' '|| l_org_id);
365: INVPUTLI.info('INVPVDR3: L8R revision_qty_control_code: '|| cr.revision_qty_control_code);
366: END IF;
367:
368: -- validate lookup
369: if (cr.revision_qty_control_code <> 1 and

Line 373: INVPUTLI.info('INVPVDR3: inside the if..ie validation failed');

369: if (cr.revision_qty_control_code <> 1 and
370: cr.revision_qty_control_code <> 2) then
371:
372: IF l_inv_debug_level IN(101, 102) THEN
373: INVPUTLI.info('INVPVDR3: inside the if..ie validation failed');
374: END IF;
375: dumm_status := INVPUOPI.mtl_log_interface_err(
376: cr.organization_id,
377: user_id,

Line 670: INVPUTLI.info('INVPVDR3: verifying lot status....');

666: status := 1;
667: end if;
668: -- Bug No:3296502 Lot Status can be enabled only if Lot Control is Full Controlled
669: IF l_inv_debug_level IN(101, 102) THEN
670: INVPUTLI.info('INVPVDR3: verifying lot status....');
671: END IF;
672:
673: if (cr.LOT_CONTROL_CODE = 1 and NVL(cr.LOT_STATUS_ENABLED,'N') = 'Y') then
674: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 696: INVPUTLI.info('INVPVDR3: verifying Serial Number Control for serial tagging');

692:
693: -- serial_tagging Enh -- bug 9913552
694:
695: IF l_inv_debug_level IN(101, 102) THEN
696: INVPUTLI.info('INVPVDR3: verifying Serial Number Control for serial tagging');
697: END IF;
698: if (cr.SERIAL_NUMBER_CONTROL_CODE in (2,5)) then
699: -- bug10433961
700: BEGIN

Line 739: INVPUTLI.info('INVPVDR3: verifying serial status....');

735:
736: -- Bug No:3296526 Serial Status can be enabled only if the item is Serial Controlled.
737:
738: IF l_inv_debug_level IN(101, 102) THEN
739: INVPUTLI.info('INVPVDR3: verifying serial status....');
740: END IF;
741: if (cr.SERIAL_NUMBER_CONTROL_CODE = 1 and NVL(cr.SERIAL_STATUS_ENABLED,'N') = 'Y') then
742: --serial_tagging enh -- bug 9913552
743: IF (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_inventory_item_id => cr.inventory_item_id,

Line 840: INVPUTLI.info('INVPVDR3: verifying serial status....');

836: -- End 2958422 : Effectivity Control Validations
837:
838: -- Bug No:3296755 SERIAL_NUMBER_CONTROL_CODE Must be 'At Recept' or 'Predefined' if Effectivity_control is 'Model/Unit Number'.
839: IF l_inv_debug_level IN(101, 102) THEN
840: INVPUTLI.info('INVPVDR3: verifying serial status....');
841: END IF;
842: if (cr.SERIAL_NUMBER_CONTROL_CODE = 1 and cr.EFFECTIVITY_CONTROL = 2) then
843: dumm_status := INVPUOPI.mtl_log_interface_err(
844: cr.organization_id,

Line 864: INVPUTLI.info('INVPVDR3: verifying bom item type for effectivity control....');

860: end if;
861:
862: --Bug 4319349 Effectivity Control can be Model/Unit Number ONLY for BOM Item type Standard items -Anmurali
863: IF l_inv_debug_level IN(101, 102) THEN
864: INVPUTLI.info('INVPVDR3: verifying bom item type for effectivity control....');
865: END IF;
866: if (cr.BOM_ITEM_TYPE <> 4 and cr.EFFECTIVITY_CONTROL = 2) then
867: dumm_status := INVPUOPI.mtl_log_interface_err(
868: cr.organization_id,

Line 887: INVPUTLI.info('INVPVDR3: verifying serial status....');

883: status := 1;
884: end if;
885: -- Bug No:3308701 ORDERABLE_ON_WEB_FLAG Must be 'N' if CUSTOMER_ORDER_ENABLED_FLAG is not set.
886: IF l_inv_debug_level IN(101, 102) THEN
887: INVPUTLI.info('INVPVDR3: verifying serial status....');
888: END IF;
889: if (NVL(cr.CUSTOMER_ORDER_ENABLED_FLAG,'N') = 'N' and NVL(cr.ORDERABLE_ON_WEB_FLAG,'N') = 'Y') then
890: dumm_status := INVPUOPI.mtl_log_interface_err(
891: cr.organization_id,

Line 911: INVPUTLI.info('INVPVDR3: verifying serial status....');

907: end if;
908:
909: -- Bug No:3311672 When BOM Item type is Option Class or Model, then Assemble to order or Pick Components must be Yes
910: IF l_inv_debug_level IN(101, 102) THEN
911: INVPUTLI.info('INVPVDR3: verifying serial status....');
912: END IF;
913: if ((cr.BOM_ITEM_TYPE = 1 OR cr.BOM_ITEM_TYPE = 2 )
914: AND NVL(cr.PICK_COMPONENTS_FLAG,'N') = 'N' AND NVL(cr.REPLENISH_TO_ORDER_FLAG,'N') = 'N') then
915: dumm_status := INVPUOPI.mtl_log_interface_err(