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.

[Home] [Help]

APPS.INV_EGO_REVISION_VALIDATE dependencies on INV_ITEM_UTIL

Line 810: IF (l_ego_exists ='Y' AND INV_Item_Util.g_Appl_Inst.EGO <> 0) THEN -- Bug 4175124 THEN

806: OPEN c_ego_exists;
807: FETCH c_ego_exists INTO l_ego_exists;
808: CLOSE c_ego_exists;
809:
810: IF (l_ego_exists ='Y' AND INV_Item_Util.g_Appl_Inst.EGO <> 0) THEN -- Bug 4175124 THEN
811:
812:
813: -- Bug 11787276: Bug fix 6670893 introduced G_PROCESS_CONTROL_HTML_API.
814: -- Similar to bug fix 6670893, other cases than HTML UI, the code flow needs to go through

Line 2541: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND

2537: err_text VARCHAR2(2000);
2538:
2539: BEGIN
2540:
2541: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2542: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2543: ,p_object_name => 'EGO_INV_ITEM_CATALOG_PVT') ='Y')
2544: THEN
2545:

Line 2542: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'

2538:
2539: BEGIN
2540:
2541: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2542: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2543: ,p_object_name => 'EGO_INV_ITEM_CATALOG_PVT') ='Y')
2544: THEN
2545:
2546: FOR cur IN c_get_valid_item_records LOOP

Line 2783: END IF; --INV_Item_Util.g_Appl_Inst.EGO <> 0

2779: ,err_text);
2780: END IF;
2781: END LOOP;
2782:
2783: END IF; --INV_Item_Util.g_Appl_Inst.EGO <> 0
2784:
2785: EXCEPTION
2786: WHEN OTHERS THEN
2787: NULL;

Line 2805: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND

2801: l_message_count NUMBER;
2802: l_msg_data VARCHAR2(2000);
2803: l_errorcode NUMBER;
2804: BEGIN
2805: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2806: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2807: ,p_object_name => 'EGO_UPGRADE_USER_ATTR_VAL_PUB') ='Y')
2808: THEN
2809: EXECUTE IMMEDIATE

Line 2806: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'

2802: l_msg_data VARCHAR2(2000);
2803: l_errorcode NUMBER;
2804: BEGIN
2805: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2806: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2807: ,p_object_name => 'EGO_UPGRADE_USER_ATTR_VAL_PUB') ='Y')
2808: THEN
2809: EXECUTE IMMEDIATE
2810: 'BEGIN

Line 2854: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND

2850: ,x_message_text OUT NOCOPY VARCHAR2
2851: ) IS
2852:
2853: BEGIN
2854: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2855: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2856: ,p_object_name => 'EGO_ITEM_AML_PUB') ='Y')
2857: THEN
2858: EXECUTE IMMEDIATE

Line 2855: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'

2851: ) IS
2852:
2853: BEGIN
2854: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2855: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2856: ,p_object_name => 'EGO_ITEM_AML_PUB') ='Y')
2857: THEN
2858: EXECUTE IMMEDIATE
2859: ' BEGIN '

Line 2905: IF (INV_ITEM_UTIL.APPL_INST_EGO <> 0) THEN

2901: ) IS
2902: l_template_exists NUMBER := 0;
2903: BEGIN
2904:
2905: IF (INV_ITEM_UTIL.APPL_INST_EGO <> 0) THEN
2906: EXECUTE IMMEDIATE
2907: 'SELECT count(*)
2908: FROM dual
2909: WHERE EXISTS(SELECT 1 FROM ego_cat_grp_templates

Line 2944: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND

2940: IS
2941: l_sql VARCHAR2(15000);
2942: l_suppress_flag VARCHAR2(10);
2943: BEGIN
2944: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2945: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2946: ,p_object_name => 'EGO_GTIN_PVT') ='Y') THEN
2947: --Bug:4174218 BOM rollup code is calling ego-pvt with supress_rollup
2948: IF NVL(G_PROCESS_CONTROL,'N') <> 'SUPPRESS_ROLLUP' THEN

Line 2945: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'

2941: l_sql VARCHAR2(15000);
2942: l_suppress_flag VARCHAR2(10);
2943: BEGIN
2944: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2945: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2946: ,p_object_name => 'EGO_GTIN_PVT') ='Y') THEN
2947: --Bug:4174218 BOM rollup code is calling ego-pvt with supress_rollup
2948: IF NVL(G_PROCESS_CONTROL,'N') <> 'SUPPRESS_ROLLUP' THEN
2949: l_suppress_flag := 'N';

Line 3386: IF NOT (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND

3382: BEGIN
3383: x_return_status := FND_API.G_RET_STS_SUCCESS;
3384: x_msg_count := 0;
3385: x_msg_data := NULL;
3386: IF NOT (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
3387: INV_ITEM_UTIL.Object_Exists
3388: (p_object_type => 'PACKAGE'
3389: ,p_object_name => 'EGO_ITEM_BULKLOAD_PKG') ='Y') THEN
3390: -- EGO not installed here no need to do further processing

Line 3387: INV_ITEM_UTIL.Object_Exists

3383: x_return_status := FND_API.G_RET_STS_SUCCESS;
3384: x_msg_count := 0;
3385: x_msg_data := NULL;
3386: IF NOT (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
3387: INV_ITEM_UTIL.Object_Exists
3388: (p_object_type => 'PACKAGE'
3389: ,p_object_name => 'EGO_ITEM_BULKLOAD_PKG') ='Y') THEN
3390: -- EGO not installed here no need to do further processing
3391: RETURN;