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

Line 1750: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;

1746: l_approval_status mtl_system_items_b.approval_status%TYPE;
1747: l_inventory_item_status_code mtl_system_items_b.inventory_item_status_code%TYPE;
1748: l_lifecycle_id mtl_system_items.lifecycle_id%TYPE;
1749: l_current_phase_id mtl_system_items.current_phase_id%TYPE;
1750: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;
1751: BEGIN
1752:
1753: IF INV_EGO_REVISION_VALIDATE.Get_Process_Control ='EGO_ITEM_BULKLOAD' THEN
1754:

Line 1810: INVPUTLI.info('INVEGRVB.Secutiry skip for:' || cur.Inventory_Item_ID || '-' || cur.organization_id);

1806: l_error_code := 'INV_IOI_ITEM_ORGASSIGN_PRIV';
1807: END IF;
1808: ELSE
1809: IF l_inv_debug_level IN(101, 102) THEN
1810: INVPUTLI.info('INVEGRVB.Secutiry skip for:' || cur.Inventory_Item_ID || '-' || cur.organization_id);
1811: END IF;
1812: END IF;
1813:
1814: IF NOT l_log_error AND NVL(l_approval_status,'A') <> 'A' THEN

Line 1844: INVPUTLI.info('INVEGRVB.Secutiry skip for:' || cur.Inventory_Item_ID || '-' || cur.organization_id);

1840: l_error_code := 'INV_IOI_ERR';
1841: END IF;
1842: ELSE
1843: IF l_inv_debug_level IN(101, 102) THEN
1844: INVPUTLI.info('INVEGRVB.Secutiry skip for:' || cur.Inventory_Item_ID || '-' || cur.organization_id);
1845: END IF;
1846: END IF;
1847:
1848: IF NOT l_log_error THEN

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

2003: --4676088
2004: --l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2005: --l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
2006:
2007: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
2008:
2009:
2010:
2011: BEGIN

Line 2032: INVPUTLI.info('INVEGRVB.Insert_Grants_And_UserAttr: inserting i grants for an Item'||cur.Inventory_Item_ID);

2028:
2029: FOR cur in c_get_processed_records(P_Set_id) LOOP
2030: IF cur.transaction_type ='CREATE' THEN
2031: IF l_inv_debug_level IN(101, 102) THEN
2032: INVPUTLI.info('INVEGRVB.Insert_Grants_And_UserAttr: inserting i grants for an Item'||cur.Inventory_Item_ID);
2033: END IF;
2034: FND_GRANTS_PKG.GRANT_FUNCTION(
2035: P_API_VERSION => 1.0
2036: ,P_MENU_NAME => 'EGO_ITEM_OWNER'

Line 2049: INVPUTLI.info('INVEGRVB.Insert_Grants_And_UserAttr: inserting Long description Userdefined Attribute.');

2045: ,X_SUCCESS => l_return_status
2046: ,X_ERRORCODE => l_msg_count);
2047:
2048: IF l_inv_debug_level IN(101, 102) THEN
2049: INVPUTLI.info('INVEGRVB.Insert_Grants_And_UserAttr: inserting Long description Userdefined Attribute.');
2050: END IF;
2051: END IF;
2052:
2053: /* Start:4676088: Template - User defined attributes will done through EGO_ITEM_USER_ATTRS_CP_PUB

Line 2087: INVPUTLI.info('EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template: Attaching user defined attribs through template');

2083: NULL;
2084: END;
2085:
2086: IF l_inv_debug_level IN(101, 102) THEN
2087: INVPUTLI.info('EGO_USER_ATTRS_DATA_PVT.Perform_DML_From_Template: Attaching user defined attribs through template');
2088: END IF;
2089: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
2090: EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID',cur.INVENTORY_ITEM_ID)
2091: ,EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID',cur.ORGANIZATION_ID));

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

2857: l_nir_import_option VARCHAR2(1);
2858: l_ret_status VARCHAR2(1);
2859: l_msg_data VARCHAR2(1000);
2860: l_msg_count NUMBER;
2861: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
2862: l_rec_for_process NUMBER := 0;
2863: l_nir_reqd VARCHAR2(1) := 'N';
2864:
2865: BEGIN

Line 2944: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Following exception from CM during NIR creation');

2940: WHERE set_process_id = p_set_process_id
2941: AND process_flag = 5;
2942: ELSE
2943: IF l_inv_debug_level IN(101, 102) THEN
2944: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Following exception from CM during NIR creation');
2945: INVPUTLI.info(l_msg_data);
2946: END IF;
2947:
2948: UPDATE mtl_system_items_interface

Line 2945: INVPUTLI.info(l_msg_data);

2941: AND process_flag = 5;
2942: ELSE
2943: IF l_inv_debug_level IN(101, 102) THEN
2944: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Following exception from CM during NIR creation');
2945: INVPUTLI.info(l_msg_data);
2946: END IF;
2947:
2948: UPDATE mtl_system_items_interface
2949: SET process_flag = 3,

Line 2961: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));

2957: END IF; -- Not called for UI create
2958: EXCEPTION
2959: WHEN OTHERS THEN
2960: IF l_inv_debug_level IN(101, 102) THEN
2961: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));
2962: END IF;
2963:
2964: UPDATE mtl_system_items_interface
2965: SET process_flag = 3,

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

3006: l_error_table Error_Handler.Error_Tbl_Type;
3007: l_type_name VARCHAR2(1000);
3008: l_error boolean;
3009:
3010: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
3011: BEGIN
3012:
3013: IF (INSTR(NVL(G_PROCESS_CONTROL,'PLM_UI:N'),'PLM_UI:Y') = 0 ) THEN
3014:

Line 3118: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));

3114: WHERE set_process_id= p_set_process_id;
3115:
3116:
3117: IF l_inv_debug_level IN(101, 102) THEN
3118: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));
3119: END IF;
3120:
3121: dumm_status := INVPUOPI.mtl_log_interface_err(
3122: null,--i.organization_id,

Line 3571: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Cancel_NIR: Exception'||substr(SQLERRM,1,200));

3567: OUT l_nir_cancel_status; */
3568: EXCEPTION
3569: WHEN others THEN
3570: x_return_status := FND_API.G_RET_STS_ERROR;
3571: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Cancel_NIR: Exception'||substr(SQLERRM,1,200));
3572: END Cancel_New_Item_Request;
3573:
3574: /* Obsoleting this procedure and recreating it below with new NIR create signature for R12 FPC
3575: PROCEDURE Create_New_Item_Req_Upd ( p_item_catalog_group_id IN NUMBER,

Line 3648: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));

3644: x_return_status := FND_API.G_RET_STS_ERROR;
3645: IF l_cursor_id IS NOT NULL THEN
3646: dbms_sql.close_cursor(l_cursor_id);
3647: END IF;
3648: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));
3649: END Create_New_Item_Req_Upd; */
3650: -- End : 5258295
3651:
3652: PROCEDURE Create_New_Item_Req_Upd ( p_row_id IN ROWID,

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

3660: IS
3661: l_return_status VARCHAR2(1);
3662: l_err_text VARCHAR2(1000);
3663: l_msg_count NUMBER;
3664: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
3665: l_proc_flag NUMBER;
3666: BEGIN
3667: UPDATE MTL_SYSTEM_ITEMS_B
3668: SET INVENTORY_ITEM_STATUS_CODE='Pending'

Line 3692: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Following exception from CM during NIR creation');

3688: SET process_flag = p_process_flag
3689: WHERE rowid = p_row_id;
3690: ELSE
3691: IF l_inv_debug_level IN(101, 102) THEN
3692: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Following exception from CM during NIR creation');
3693: INVPUTLI.info(l_err_text);
3694: END IF;
3695:
3696: UPDATE mtl_system_items_interface

Line 3693: INVPUTLI.info(l_err_text);

3689: WHERE rowid = p_row_id;
3690: ELSE
3691: IF l_inv_debug_level IN(101, 102) THEN
3692: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Following exception from CM during NIR creation');
3693: INVPUTLI.info(l_err_text);
3694: END IF;
3695:
3696: UPDATE mtl_system_items_interface
3697: SET process_flag = 3,

Line 3706: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));

3702:
3703: EXCEPTION
3704: WHEN OTHERS THEN
3705: IF l_inv_debug_level IN(101, 102) THEN
3706: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));
3707: END IF;
3708:
3709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3710:

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

3784: l_err_text VARCHAR2(1000);
3785: l_valid_icc NUMBER;
3786: l_style_icc_id NUMBER;
3787: l_sku_variant BOOLEAN;
3788: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
3789: l_error_exists NUMBER := 0;
3790: l_null_icc_id NUMBER := -1;
3791: l_sku_exists NUMBER;
3792: l_master_org NUMBER;

Line 3813: INVPUTLI.info('MSII ICC ID ' ||l_msii_icc_id ||' MSI ICC ID ' ||l_msi_icc_id);

3809: FETCH c_get_existing_item_details INTO l_msi_style_item_flag,l_msi_style_item_id,l_msi_icc_id;
3810: CLOSE c_get_existing_item_details;
3811:
3812: IF l_inv_debug_level IN(101, 102) THEN
3813: INVPUTLI.info('MSII ICC ID ' ||l_msii_icc_id ||' MSI ICC ID ' ||l_msi_icc_id);
3814: END IF;
3815:
3816: IF l_msii_icc_id IS NULL THEN
3817: IF l_inv_debug_level IN(101, 102) THEN

Line 3818: INVPUTLI.info('INVEGRVB.validate_style_sku: ICC is mandatory');

3814: END IF;
3815:
3816: IF l_msii_icc_id IS NULL THEN
3817: IF l_inv_debug_level IN(101, 102) THEN
3818: INVPUTLI.info('INVEGRVB.validate_style_sku: ICC is mandatory');
3819: END IF;
3820: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
3821: l_User_Id,
3822: l_Login_Id,

Line 3839: INVPUTLI.info('INVEGRVB.validate_style_sku: Cannot update Style Item Flag ');

3835: /* The Style/SKU status of the item cannot be updated - Sec 2.5.1 - Condition 1*/
3836: IF ((l_transaction_type = 'UPDATE') AND (l_msii_style_item_flag <> l_msi_style_item_flag))
3837: THEN
3838: IF l_inv_debug_level IN(101, 102) THEN
3839: INVPUTLI.info('INVEGRVB.validate_style_sku: Cannot update Style Item Flag ');
3840: END IF;
3841: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
3842: l_User_Id,
3843: l_Login_Id,

Line 3860: INVPUTLI.info('INVEGRVB.validate_style_sku: Cannot update Style Item Id ');

3856: /* The Style Item for a given SKU item cannot be updated - Sec 2.5.1 - Condition 1.1*/
3857: IF (l_transaction_type = 'UPDATE') AND (l_msii_style_item_id <> l_msi_style_item_id)
3858: THEN
3859: IF l_inv_debug_level IN(101, 102) THEN
3860: INVPUTLI.info('INVEGRVB.validate_style_sku: Cannot update Style Item Id ');
3861: END IF;
3862: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
3863: l_User_Id,
3864: l_Login_Id,

Line 3880: INVPUTLI.info('INVEGRVB.validate_style_sku: Style Item cannot be GDSN SYndicated ');

3876:
3877: --Bug 6161263: Adding validation to disallow the creation/updation of GDSN Syndicated Style items
3878: IF (l_msii_style_item_flag = 'Y' AND l_msii_gdsn_flag = 'Y') THEN
3879: IF l_inv_debug_level IN(101, 102) THEN
3880: INVPUTLI.info('INVEGRVB.validate_style_sku: Style Item cannot be GDSN SYndicated ');
3881: END IF;
3882: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
3883: l_User_Id,
3884: l_Login_Id,

Line 3932: INVPUTLI.info('INVEGRVB.validate_style_sku: Invalid ICC ');

3928: START WITH item_catalog_group_id = l_msii_icc_id );
3929:
3930: IF l_valid_icc = 0 THEN
3931: IF l_inv_debug_level IN(101, 102) THEN
3932: INVPUTLI.info('INVEGRVB.validate_style_sku: Invalid ICC ');
3933: END IF;
3934: l_error_logged := INVPUOPI.mtl_log_interface_err( l_msii_org_id,
3935: l_User_Id,
3936: l_Login_Id,

Line 3988: INVPUTLI.info('INVEGRVB.validate_style_sku: SKU and Style must belong to same ICC ');

3984: END;
3985: /* SKUs and their corresponding Styles must belong to the same ICC - Sec 2.5.1 -Condition 3 */
3986: IF l_style_icc_id IS NULL OR l_style_icc_id <> l_msii_icc_id THEN
3987: IF l_inv_debug_level IN(101, 102) THEN
3988: INVPUTLI.info('INVEGRVB.validate_style_sku: SKU and Style must belong to same ICC ');
3989: END IF;
3990: l_error_logged := INVPUOPI.mtl_log_interface_err (l_msii_org_id,
3991: l_User_Id,
3992: l_Login_Id,

Line 4076: INVPUTLI.info('INVEGRVB.validate_style_sku: Exception '||SQLERRM);

4072: RETURN(0);
4073:
4074: EXCEPTION
4075: WHEN others THEN
4076: INVPUTLI.info('INVEGRVB.validate_style_sku: Exception '||SQLERRM);
4077: RETURN(SQLCODE);
4078:
4079: END validate_style_sku;
4080:

Line 4114: INVPUTLI.info('INVEGRVB.Check_Org_Access '||SQLERRM);

4110: EXCEPTION WHEN OTHERS THEN
4111: IF c_check_org_access%ISOPEN THEN
4112: CLOSE c_check_org_access;
4113: END IF;
4114: INVPUTLI.info('INVEGRVB.Check_Org_Access '||SQLERRM);
4115: RETURN(SQLCODE);
4116:
4117: END Check_Org_Access;
4118: