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.60 2007/10/03 13:34:02 lparihar ship $ */
3:
4: LOGGING_ERR EXCEPTION;
5: G_PROCESS_CONTROL VARCHAR2(2000) := NULL;--Used by EGO API only for internal flow occntrol

Line 296: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle

292: Raise LOGGING_ERR;
293: END IF;
294:
295: -- Lifecycle validation
296: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle
297: (p_catalog_group_id => P_Catalog_Group_Id,
298: p_lifecycle_id => P_Lifecycle_Id)
299: THEN
300: X_Error_Code := 'INV_IOI_INVALID_LC_CATALOG';

Line 305: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle_Phase

301: X_Error_Column := 'LIFECYCLE_ID';
302: Raise LOGGING_ERR;
303: ELSE
304: -- Lifecycle Phase Validation
305: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle_Phase
306: ( p_lifecycle_id => P_Lifecycle_Id,
307: p_lifecycle_phase_id => P_Phase_Id)
308: THEN
309: X_Error_Code := 'INV_IOI_INVALID_PHASE';

Line 452: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle

448: END IF;
449:
450: -- Lifecycle validation
451: IF P_Lifecycle_Id <> l_Old_Lifecycle_Id THEN
452: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle
453: (p_catalog_group_id => P_Catalog_Group_Id,
454: p_lifecycle_id => P_Lifecycle_Id)
455: THEN
456: X_Error_Code := 'INV_IOI_INVALID_LC_CATALOG';

Line 467: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle_Phase

463: -- Lifecycle Phase Validation
464: --Check phase change is allowed or not
465: IF P_Phase_Id <> l_Old_Phase_Id THEN
466:
467: IF NOT INV_EGO_REVISION_VALIDATE.Check_LifeCycle_Phase
468: ( p_lifecycle_id => P_Lifecycle_Id,
469: p_lifecycle_phase_id => P_Phase_Id)
470: THEN
471: X_Error_Code := 'INV_IOI_INVALID_PHASE';

Line 1026: l_return_status := INV_EGO_REVISION_VALIDATE.mtl_catalog_group_update (

1022: END IF;
1023: l_error_status := 1;
1024: ELSE
1025: --Bug: 5258295
1026: l_return_status := INV_EGO_REVISION_VALIDATE.mtl_catalog_group_update (
1027: p_rowid => cur.rowid
1028: ,p_process_flag => p_process_flag --Added for R12 C
1029: ,p_inventory_item_id => cur.inventory_item_id
1030: ,p_organization_id => cur.organization_id

Line 1408: l_return_status := INV_EGO_REVISION_VALIDATE.mtl_catalog_group_update (

1404: END IF;
1405: l_error_status := 1;
1406: ELSE
1407: --Bug: 5258295
1408: l_return_status := INV_EGO_REVISION_VALIDATE.mtl_catalog_group_update (
1409: p_rowid => cur.rowid
1410: ,p_process_flag => p_process_flag --Added for R12 C
1411: ,p_inventory_item_id => cur.inventory_item_id
1412: ,p_organization_id => cur.organization_id

Line 1609: INV_EGO_REVISION_VALIDATE.Insert_Grants_And_UserAttr(P_Set_id);

1605: END LOOP; -- End of c_get_child_items
1606:
1607: END IF;
1608: --Support of user attributes through template
1609: INV_EGO_REVISION_VALIDATE.Insert_Grants_And_UserAttr(P_Set_id);
1610:
1611: END IF; --Ego exists
1612:
1613: RETURN (0);

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

1615: EXCEPTION
1616: WHEN LOGGING_ERR then
1617: RETURN(l_error_logged);
1618: WHEN OTHERS THEN
1619: X_Err_Text := SUBSTR('INV_EGO_REVISION_VALIDATE.validate_revision_lifecycle' || SQLERRM , 1,240);
1620: RETURN (SQLCODE);
1621: END validate_items_lifecycle;
1622: --End 2777118:Item Lifecycle and Phase validations
1623:

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

1644: l_user_id fnd_user.user_id%TYPE := P_User_Id;
1645:
1646: BEGIN
1647:
1648: IF INV_EGO_REVISION_VALIDATE.Get_Process_Control ='EGO_ITEM_BULKLOAD' THEN
1649:
1650: IF l_user_id IS NULL OR l_user_id = -1 THEN
1651: l_user_id := FND_GLOBAL.user_id;
1652: END IF;

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

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:
1755: FOR cur in c_get_items LOOP
1756:
1757: l_has_privilege := 'F';

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

1952: EXCEPTION
1953: WHEN LOGGING_ERR then
1954: RETURN(l_error_logged);
1955: WHEN OTHERS THEN
1956: X_Err_Text := SUBSTR('INV_EGO_REVISION_VALIDATE.validate_revision_lifecycle' || SQLERRM , 1,240);
1957: RETURN (SQLCODE);
1958: END validate_item_user_privileges;
1959: --End : Check for data security and user priv.
1960:

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

2708: END IF;
2709: EXCEPTION
2710: WHEN OTHERS THEN
2711: x_return_status := 'N';
2712: x_message_text := SUBSTR('INV_EGO_REVISION_VALIDATE.Check_No_MFG_Associations ' || SQLERRM , 1,240);
2713: END CHECK_NO_MFG_ASSOCIATIONS;
2714:
2715: ------------------------------------------------------------------------------------------
2716: --API Name : Check_Template_Cat_Associations

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 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 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 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 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 4119: END INV_EGO_REVISION_VALIDATE;

4115: RETURN(SQLCODE);
4116:
4117: END Check_Org_Access;
4118:
4119: END INV_EGO_REVISION_VALIDATE;