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 INV_EGO_REVISION_VALIDATE

Line 1: PACKAGE BODY INV_EGO_REVISION_VALIDATE AS

1: PACKAGE BODY INV_EGO_REVISION_VALIDATE AS
2: /* $Header: INVEGRVB.pls 120.75.12020000.6 2013/04/24 10:14:25 zewhuang ship $ */
3:
4: LOGGING_ERR EXCEPTION;
5: G_PROCESS_CONTROL VARCHAR2(2000) := NULL;--Used by EGO API only for internal flow occntrol

Line 289: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle

285: Raise LOGGING_ERR;
286: END IF;
287:
288: -- Lifecycle validation
289: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle
290: (p_catalog_group_id => P_Catalog_Group_Id,
291: p_lifecycle_id => P_Lifecycle_Id)
292: THEN
293: X_Error_Code := 'INV_IOI_INVALID_LC_CATALOG';

Line 298: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle_Phase

294: X_Error_Column := 'LIFECYCLE_ID';
295: Raise LOGGING_ERR;
296: ELSE
297: -- Lifecycle Phase Validation
298: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle_Phase
299: ( p_lifecycle_id => P_Lifecycle_Id,
300: p_lifecycle_phase_id => P_Phase_Id)
301: THEN
302: X_Error_Code := 'INV_IOI_INVALID_PHASE';

Line 436: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle

432: END IF;
433:
434: -- Lifecycle validation
435: IF P_Lifecycle_Id <> l_Old_Lifecycle_Id THEN
436: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle
437: (p_catalog_group_id => P_Catalog_Group_Id,
438: p_lifecycle_id => P_Lifecycle_Id)
439: THEN
440: X_Error_Code := 'INV_IOI_INVALID_LC_CATALOG';

Line 451: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle_Phase

447: -- Lifecycle Phase Validation
448: --Check phase change is allowed or not
449: IF P_Phase_Id <> l_Old_Phase_Id THEN
450:
451: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle_Phase
452: ( p_lifecycle_id => P_Lifecycle_Id,
453: p_lifecycle_phase_id => P_Phase_Id)
454: THEN
455: X_Error_Code := 'INV_IOI_INVALID_PHASE';

Line 1083: l_return_status := INV_EGO_REVISION_VALIDATE.mtl_catalog_group_update (

1079: END IF;
1080: l_error_status := 1;
1081: ELSE
1082: --Bug: 5258295
1083: l_return_status := INV_EGO_REVISION_VALIDATE.mtl_catalog_group_update (
1084: p_rowid => cur.rowid
1085: ,p_process_flag => p_process_flag --Added for R12 C
1086: ,p_inventory_item_id => cur.inventory_item_id
1087: ,p_organization_id => cur.organization_id

Line 1506: l_return_status := INV_EGO_REVISION_VALIDATE.mtl_catalog_group_update (

1502: END IF;
1503: l_error_status := 1;
1504: ELSE
1505: --Bug: 5258295
1506: l_return_status := INV_EGO_REVISION_VALIDATE.mtl_catalog_group_update (
1507: p_rowid => cur.rowid
1508: ,p_process_flag => p_process_flag --Added for R12 C
1509: ,p_inventory_item_id => cur.inventory_item_id
1510: ,p_organization_id => cur.organization_id

Line 1707: INV_EGO_REVISION_VALIDATE.Insert_Grants_And_UserAttr(P_Set_id);

1703: END LOOP; -- End of c_get_child_items
1704:
1705: END IF;
1706: --Support of user attributes through template
1707: INV_EGO_REVISION_VALIDATE.Insert_Grants_And_UserAttr(P_Set_id);
1708:
1709: END IF; --Ego exists
1710:
1711: RETURN (0);

Line 1717: X_Err_Text := SUBSTR('INV_EGO_REVISION_VALIDATE.validate_revision_lifecycle' || SQLERRM , 1,240);

1713: EXCEPTION
1714: WHEN LOGGING_ERR then
1715: RETURN(l_error_logged);
1716: WHEN OTHERS THEN
1717: X_Err_Text := SUBSTR('INV_EGO_REVISION_VALIDATE.validate_revision_lifecycle' || SQLERRM , 1,240);
1718: RETURN (SQLCODE);
1719: END validate_items_lifecycle;
1720: --End 2777118:Item Lifecycle and Phase validations
1721:

Line 1746: IF INV_EGO_REVISION_VALIDATE.Get_Process_Control ='EGO_ITEM_BULKLOAD' THEN

1742: l_user_id fnd_user.user_id%TYPE := P_User_Id;
1743:
1744: BEGIN
1745:
1746: IF INV_EGO_REVISION_VALIDATE.Get_Process_Control ='EGO_ITEM_BULKLOAD' THEN
1747:
1748: IF l_user_id IS NULL OR l_user_id = -1 THEN
1749: l_user_id := FND_GLOBAL.user_id;
1750: END IF;

Line 1851: IF INV_EGO_REVISION_VALIDATE.Get_Process_Control ='EGO_ITEM_BULKLOAD' THEN

1847: l_current_phase_id mtl_system_items.current_phase_id%TYPE;
1848: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level;
1849: BEGIN
1850:
1851: IF INV_EGO_REVISION_VALIDATE.Get_Process_Control ='EGO_ITEM_BULKLOAD' THEN
1852:
1853: FOR cur in c_get_items LOOP
1854:
1855: l_has_privilege := 'F';

Line 2056: X_Err_Text := SUBSTR('INV_EGO_REVISION_VALIDATE.validate_revision_lifecycle' || SQLERRM , 1,240);

2052: EXCEPTION
2053: WHEN LOGGING_ERR then
2054: RETURN(l_error_logged);
2055: WHEN OTHERS THEN
2056: X_Err_Text := SUBSTR('INV_EGO_REVISION_VALIDATE.validate_revision_lifecycle' || SQLERRM , 1,240);
2057: RETURN (SQLCODE);
2058: END validate_item_user_privileges;
2059: --End : Check for data security and user priv.
2060:

Line 2883: x_message_text := SUBSTR('INV_EGO_REVISION_VALIDATE.Check_No_MFG_Associations ' || SQLERRM , 1,240);

2879: END IF;
2880: EXCEPTION
2881: WHEN OTHERS THEN
2882: x_return_status := 'N';
2883: x_message_text := SUBSTR('INV_EGO_REVISION_VALIDATE.Check_No_MFG_Associations ' || SQLERRM , 1,240);
2884: END CHECK_NO_MFG_ASSOCIATIONS;
2885:
2886: ------------------------------------------------------------------------------------------
2887: --API Name : Check_Template_Cat_Associations

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

3150: WHERE set_process_id = p_set_process_id
3151: AND process_flag = 5;
3152: ELSE
3153: IF l_inv_debug_level IN(101, 102) THEN
3154: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Following exception from CM during NIR creation');
3155: INVPUTLI.info(l_msg_data);
3156: END IF;
3157:
3158: UPDATE mtl_system_items_interface

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

3167: END IF; -- Not called for UI create
3168: EXCEPTION
3169: WHEN OTHERS THEN
3170: IF l_inv_debug_level IN(101, 102) THEN
3171: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));
3172: END IF;
3173:
3174: UPDATE mtl_system_items_interface
3175: SET process_flag = 3,

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

3324: WHERE set_process_id= p_set_process_id;
3325:
3326:
3327: IF l_inv_debug_level IN(101, 102) THEN
3328: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));
3329: END IF;
3330:
3331: dumm_status := INVPUOPI.mtl_log_interface_err(
3332: null,--i.organization_id,

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

3788: OUT l_nir_cancel_status; */
3789: EXCEPTION
3790: WHEN others THEN
3791: x_return_status := FND_API.G_RET_STS_ERROR;
3792: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Cancel_NIR: Exception'||substr(SQLERRM,1,200));
3793: END Cancel_New_Item_Request;
3794:
3795: /* Obsoleting this procedure and recreating it below with new NIR create signature for R12 FPC
3796: PROCEDURE Create_New_Item_Req_Upd ( p_item_catalog_group_id IN NUMBER,

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

3865: x_return_status := FND_API.G_RET_STS_ERROR;
3866: IF l_cursor_id IS NOT NULL THEN
3867: dbms_sql.close_cursor(l_cursor_id);
3868: END IF;
3869: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));
3870: END Create_New_Item_Req_Upd; */
3871: -- End : 5258295
3872:
3873: PROCEDURE Create_New_Item_Req_Upd ( p_row_id IN ROWID,

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

3909: SET process_flag = p_process_flag
3910: WHERE rowid = p_row_id;
3911: ELSE
3912: IF l_inv_debug_level IN(101, 102) THEN
3913: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Following exception from CM during NIR creation');
3914: INVPUTLI.info(l_err_text);
3915: END IF;
3916:
3917: UPDATE mtl_system_items_interface

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

3923:
3924: EXCEPTION
3925: WHEN OTHERS THEN
3926: IF l_inv_debug_level IN(101, 102) THEN
3927: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.Create_New_Item_Request: Exception'||substr(SQLERRM,1,200));
3928: END IF;
3929:
3930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3931:

Line 3956: INVPUTLI.info('Start : INV_EGO_REVISION_VALIDATE.apply_default_uda_values');

3952:
3953: return;
3954: END IF;
3955:
3956: INVPUTLI.info('Start : INV_EGO_REVISION_VALIDATE.apply_default_uda_values');
3957: IF SUBSTR(NVL(G_PROCESS_CONTROL,'SSSSSS'),1,6) <> 'NO_NIR'
3958: AND NVL(G_PROCESS_CONTROL,'SSSSSS') NOT IN ('EGO_XL_IMPORT_ITEM1','EGO_XL_IMPORT_ITEM2','EGO_XL_IMPORT_ITEM3')
3959: THEN
3960: -- commit; /* Commented to fix Bug#7422423*/

Line 3978: INVPUTLI.info('End : INV_EGO_REVISION_VALIDATE.apply_default_uda_values');

3974:
3975: NULL; -- Bug 9336604
3976:
3977: END IF;
3978: INVPUTLI.info('End : INV_EGO_REVISION_VALIDATE.apply_default_uda_values');
3979: EXCEPTION
3980: WHEN OTHERS THEN
3981: NULL; -- Donot propogate any error message.
3982: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.apply_default_uda_values: Exception'||substr(SQLERRM,1,200));

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

3978: INVPUTLI.info('End : INV_EGO_REVISION_VALIDATE.apply_default_uda_values');
3979: EXCEPTION
3980: WHEN OTHERS THEN
3981: NULL; -- Donot propogate any error message.
3982: INVPUTLI.info('INV_EGO_REVISION_VALIDATE.apply_default_uda_values: Exception'||substr(SQLERRM,1,200));
3983:
3984: END apply_default_uda_values;
3985:
3986: -- ============================================================================

Line 4379: END INV_EGO_REVISION_VALIDATE;

4375: RETURN(SQLCODE);
4376:
4377: END Check_Org_Access;
4378:
4379: END INV_EGO_REVISION_VALIDATE;