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

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

22: l_nir_rec_exists BOOLEAN;
23: l_flag_error NUMBER;
24: l_item_approval_status mtl_system_items_b.approval_status%TYPE; --Bug 4418037
25: l_dumm_status NUMBER;
26: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
27: l_err_text VARCHAR2(1000);
28:
29: /* R12C : Changing the New Item Req Reqd = 'Y' sub-query for hierarchy enabled Catalogs */
30: CURSOR c_get_processed_records(cp_process_flag NUMBER) IS

Line 79: INVPUTLI.info('INVNIRIS: first sta..set_id'||to_char(xset_id)||'org'||to_char(org_id)||'all'||to_char(all_org));

75: l_sysdate := sysdate;
76: l_nir_rec_exists := false;
77:
78: IF l_inv_debug_level IN(101, 102) THEN
79: INVPUTLI.info('INVNIRIS: first sta..set_id'||to_char(xset_id)||'org'||to_char(org_id)||'all'||to_char(all_org));
80: END IF;
81:
82: FOR cur in c_get_processed_records(cp_process_flag=>2) LOOP
83: /* R12C : Retrieving NIR reqd for hierarchy enabled Catalogs */

Line 461: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');

457: END LOOP;
458:
459: --Start : Check for data security and user privileges
460: IF l_inv_debug_level IN(101, 102) THEN
461: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');
462: END IF;
463:
464: IF l_nir_rec_exists THEN
465: status := INV_EGO_REVISION_VALIDATE.validate_item_user_privileges(

Line 477: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');

473: ,P_Set_Id => xset_id + 3000000000000
474: ,X_Err_Text => err_text);
475:
476: IF l_inv_debug_level IN(101, 102) THEN
477: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');
478: END IF;
479:
480: --End : Check for data security and user privileges
481:

Line 484: INVPUTLI.info('INVNIRIS: before INVPVHDR.validate_item_header'||to_char(xset_id)||'org'||to_char(org_id)||'all'||to_char(all_org));

480: --End : Check for data security and user privileges
481:
482: IF (status = 0) then
483: IF l_inv_debug_level IN(101, 102) THEN
484: INVPUTLI.info('INVNIRIS: before INVPVHDR.validate_item_header'||to_char(xset_id)||'org'||to_char(org_id)||'all'||to_char(all_org));
485: END IF;
486:
487: status := INVPVHDR.validate_item_header(
488: org_id,

Line 508: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');

504: WHERE PROCESS_FLAG = 41
505: AND ((SET_PROCESS_ID >= 3000000000000) OR (SET_PROCESS_ID = 3000000000000-999));
506:
507: IF l_inv_debug_level IN(101, 102) THEN
508: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');
509: END IF;
510: /* start addition of code for bug 7255713-ccsingh */
511: status := INVPVDR5.validate_item_header5(
512: org_id,

Line 533: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');

529: WHERE PROCESS_FLAG = 45 --Changed the value from 41 to 45 as we need to validate primary attributes
530: AND ((SET_PROCESS_ID >= 3000000000000) OR (SET_PROCESS_ID = 3000000000000-999));
531:
532: IF l_inv_debug_level IN(101, 102) THEN
533: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');
534: END IF;
535: /* end addition of code for bug 7255713-ccsingh */
536: status := INV_EGO_REVISION_VALIDATE.validate_items_lifecycle(
537: P_Org_Id => org_id

Line 548: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');

544: ,P_Set_Id => xset_id + 3000000000000
545: ,X_Err_Text => err_text);
546:
547: IF l_inv_debug_level IN(101, 102) THEN
548: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');
549: END IF;
550:
551: END IF;
552:

Line 556: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: before validate_item_revs');

552:
553: -- validate item revisions
554: IF (status = 0) THEN
555: IF l_inv_debug_level IN(101, 102) THEN
556: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: before validate_item_revs');
557: END IF;
558: status := INVPVALI.validate_item_revs (
559: org_id,
560: all_org,

Line 570: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: after validate_item_revs');

566: err_text,
567: xset_id + 3000000000000 );
568:
569: IF l_inv_debug_level IN(101, 102) THEN
570: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: after validate_item_revs');
571: END IF;
572: END IF;
573: END IF;
574:

Line 576: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: done with status :'||status);

572: END IF;
573: END IF;
574:
575: IF l_inv_debug_level IN(101, 102) THEN
576: INVPUTLI.info('INVNIRIS.mtl_pr_validate_item: done with status :'||status);
577: END IF;
578:
579: UPDATE mtl_system_items_interface
580: SET SET_PROCESS_ID = xset_id

Line 612: INVPUTLI.info(err_text);

608:
609: WHEN OTHERS THEN
610: err_text := substr('INVNIRIS.mtl_pr_validate_item ' || SQLERRM, 1,240);
611: IF l_inv_debug_level IN(101, 102) THEN
612: INVPUTLI.info(err_text);
613: END IF;
614: RETURN(SQLCODE);
615:
616: END mtl_validate_nir_item;

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

681: l_Err_Text VARCHAR2(500);
682: LOGGING_ERR EXCEPTION;
683: l_return_status VARCHAR2(100);
684: l_import_co_option VARCHAR2(1) := 'N';
685: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
686: --Contains 'Attribute_Group_ID:Attribute_Group_Name'
687: TYPE Item_Attributes_Type IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
688: Attribute_Grp_Table Item_Attributes_Type;
689: l_status NUMBER;

Line 741: INVPUTLI.info('INVNIRIS.change_poilcy_check: before INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');

737:
738: --Start bug: 5238510
739: -- : Check for data security and user privileges
740: IF l_inv_debug_level IN(101, 102) THEN
741: INVPUTLI.info('INVNIRIS.change_poilcy_check: before INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');
742: END IF;
743:
744: l_status := INV_EGO_REVISION_VALIDATE.validate_item_user_privileges(
745: P_Org_Id => org_id

Line 757: INVPUTLI.info('INVNIRIS.change_poilcy_check: done INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');

753: ,X_Err_Text => err_text
754: ,P_Process_flag => 1);
755:
756: IF l_inv_debug_level IN(101, 102) THEN
757: INVPUTLI.info('INVNIRIS.change_poilcy_check: done INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');
758: END IF;
759: --End bug: 5238510
760:
761: l_eng_object := INV_ITEM_UTIL.Object_Exists(p_object_type=>'PACKAGE BODY',p_object_name=>'ENG_CHANGE_POLICY_PKG');

Line 827: INVPUTLI.info('INVNIRIS.change_policy_check: Checking Attr groups');

823: CLOSE c_get_batch_policy;
824:
825: FOR cur IN c_check_attributes_policy LOOP
826: IF l_inv_debug_level IN(101, 102) THEN
827: INVPUTLI.info('INVNIRIS.change_policy_check: Checking Attr groups');
828: END IF;
829:
830: l_attr_grps := NULL;
831: l_policy_value := NULL;

Line 1238: INVPUTLI.info('INVNIRIS.change_policy_check: Attr Grps Changed:' || l_attr_grps);

1234: END IF;
1235:
1236: IF l_attr_grps IS NOT NULL THEN
1237: IF l_inv_debug_level IN(101, 102) THEN
1238: INVPUTLI.info('INVNIRIS.change_policy_check: Attr Grps Changed:' || l_attr_grps);
1239: END IF;
1240:
1241: IF cur.current_phase_id is NOT NULL THEN
1242: --Bug 5367962 Find if any of the AG as ChanhePolicy of 'NOT ALLOWED'

Line 1340: INVPUTLI.info('INVNIRIS.change_policy_check: Moving to 5 for CO');

1336: THEN
1337: --4723028 If called from CO, dont move to 5.
1338: IF INSTR(l_process_control,'ENG_CALL:Y') = 0 THEN
1339: IF l_inv_debug_level IN(101, 102) THEN
1340: INVPUTLI.info('INVNIRIS.change_policy_check: Moving to 5 for CO');
1341: END IF;
1342:
1343: --4696529: Insert row into interface table to propogate changes to production.
1344: IF l_msb_rec.inventory_item_status_code <> NVL(cur.inventory_item_status_code,l_msb_rec.inventory_item_status_code)

Line 1697: INVPUTLI.info('INVNIRIS.change_policy_check: Some Attr is non null');

1693: OR cur.WEB_STATUS IS NOT NULL
1694: OR cur.MINIMUM_LICENSE_QUANTITY IS NOT NULL
1695: THEN
1696: IF l_inv_debug_level IN(101, 102) THEN
1697: INVPUTLI.info('INVNIRIS.change_policy_check: Some Attr is non null');
1698: END IF;
1699:
1700: l_values_provided := TRUE;
1701: ELSE

Line 1765: INVPUTLI.info(l_Err_Text);

1761:
1762: EXCEPTION
1763: WHEN LOGGING_ERR then
1764: IF l_inv_debug_level IN(101, 102) THEN
1765: INVPUTLI.info(l_Err_Text);
1766: END IF;
1767: RETURN(l_error_logged);
1768: WHEN OTHERS THEN
1769: err_text := substr('INVNIRIS.change_policy_check ' || SQLERRM, 1,240);

Line 1771: INVPUTLI.info(err_text);

1767: RETURN(l_error_logged);
1768: WHEN OTHERS THEN
1769: err_text := substr('INVNIRIS.change_policy_check ' || SQLERRM, 1,240);
1770: IF l_inv_debug_level IN(101, 102) THEN
1771: INVPUTLI.info(err_text);
1772: END IF;
1773: RETURN(SQLCODE);
1774: END change_policy_check;
1775: