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 316: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

312: VALIDATE_ERR exception;
313: temp_proc_flag number;
314: l_err_msg varchar2(2000) := NULL;
315:
316: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
317:
318: begin
319:
320: IF l_inv_debug_level IN(101, 102) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

688: end if;
689: -- Bug No:3296526 Serial Status can be enabled only if the item is Serial Controlled.
690:
691: IF l_inv_debug_level IN(101, 102) THEN
692: INVPUTLI.info('INVPVDR3: verifying serial status....');
693: END IF;
694: if (cr.SERIAL_NUMBER_CONTROL_CODE = 1 and NVL(cr.SERIAL_STATUS_ENABLED,'N') = 'Y') then
695: dumm_status := INVPUOPI.mtl_log_interface_err(
696: cr.organization_id,

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

781: -- End 2958422 : Effectivity Control Validations
782:
783: -- Bug No:3296755 SERIAL_NUMBER_CONTROL_CODE Must be 'At Recept' or 'Predefined' if Effectivity_control is 'Model/Unit Number'.
784: IF l_inv_debug_level IN(101, 102) THEN
785: INVPUTLI.info('INVPVDR3: verifying serial status....');
786: END IF;
787: if (cr.SERIAL_NUMBER_CONTROL_CODE = 1 and cr.EFFECTIVITY_CONTROL = 2) then
788: dumm_status := INVPUOPI.mtl_log_interface_err(
789: cr.organization_id,

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

805: end if;
806:
807: --Bug 4319349 Effectivity Control can be Model/Unit Number ONLY for BOM Item type Standard items -Anmurali
808: IF l_inv_debug_level IN(101, 102) THEN
809: INVPUTLI.info('INVPVDR3: verifying bom item type for effectivity control....');
810: END IF;
811: if (cr.BOM_ITEM_TYPE <> 4 and cr.EFFECTIVITY_CONTROL = 2) then
812: dumm_status := INVPUOPI.mtl_log_interface_err(
813: cr.organization_id,

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

828: status := 1;
829: end if;
830: -- Bug No:3308701 ORDERABLE_ON_WEB_FLAG Must be 'N' if CUSTOMER_ORDER_ENABLED_FLAG is not set.
831: IF l_inv_debug_level IN(101, 102) THEN
832: INVPUTLI.info('INVPVDR3: verifying serial status....');
833: END IF;
834: if (NVL(cr.CUSTOMER_ORDER_ENABLED_FLAG,'N') = 'N' and NVL(cr.ORDERABLE_ON_WEB_FLAG,'N') = 'Y') then
835: dumm_status := INVPUOPI.mtl_log_interface_err(
836: cr.organization_id,

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

852: end if;
853:
854: -- Bug No:3311672 When BOM Item type is Option Class or Model, then Assemble to order or Pick Components must be Yes
855: IF l_inv_debug_level IN(101, 102) THEN
856: INVPUTLI.info('INVPVDR3: verifying serial status....');
857: END IF;
858: if ((cr.BOM_ITEM_TYPE = 1 OR cr.BOM_ITEM_TYPE = 2 )
859: AND NVL(cr.PICK_COMPONENTS_FLAG,'N') = 'N' AND NVL(cr.REPLENISH_TO_ORDER_FLAG,'N') = 'N') then
860: dumm_status := INVPUOPI.mtl_log_interface_err(