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.EGO_IMPORT_PVT dependencies on EGO_IMPORT_PVT

Line 1: PACKAGE BODY EGO_IMPORT_PVT AS

1: PACKAGE BODY EGO_IMPORT_PVT AS
2: /* $Header: EGOVIMPB.pls 120.173 2007/11/09 03:04:37 mantyaku ship $ */
3:
4: G_DEFAULT_ATTR_GROUP_TYPE CONSTANT VARCHAR2(30) := 'EGO_ITEMMGMT_GROUP';
5: -- G_IOI_STAMP_REQUEST_ID_FLAG CONSTANT NUMBER := -1;

Line 5020: ERRBUF := 'Error in method EGO_IMPORT_PVT.Demerge_Batch_After_Import - '||SQLERRM;

5016: ERRBUF := NULL;
5017: EXCEPTION WHEN OTHERS THEN
5018: Debug_Conc_Log(l_proc_log_prefix || 'Error - ' || SQLERRM);
5019: RETCODE := '2';
5020: ERRBUF := 'Error in method EGO_IMPORT_PVT.Demerge_Batch_After_Import - '||SQLERRM;
5021: END Demerge_Batch_After_Import;
5022:
5023: /*
5024: * This method does a bulkload of GTINs

Line 5444: ERRBUF := 'Error in method EGO_IMPORT_PVT.Process_Gtin_Intf_Rows - '||SQLERRM;

5440: Debug_Conc_Log('Done Process_Gtin_Intf_Rows with success');
5441: EXCEPTION WHEN OTHERS THEN
5442: Debug_Conc_Log('Done Process_Gtin_Intf_Rows with error - '||SQLERRM);
5443: RETCODE := '2';
5444: ERRBUF := 'Error in method EGO_IMPORT_PVT.Process_Gtin_Intf_Rows - '||SQLERRM;
5445: END Process_Gtin_Intf_Rows;
5446:
5447: /*
5448: * Private method to process Source System item cross reference

Line 5907: ERRBUF := 'Error in method EGO_IMPORT_PVT.Process_SSXref_Intf_Rows - '||SQLERRM;

5903: ERRBUF := NULL;
5904: Debug_Conc_Log('Done Process_SSXref_Intf_Rows with success');
5905: EXCEPTION WHEN OTHERS THEN
5906: RETCODE := '2';
5907: ERRBUF := 'Error in method EGO_IMPORT_PVT.Process_SSXref_Intf_Rows - '||SQLERRM;
5908: Debug_Conc_Log('Done Process_SSXref_Intf_Rows with error - '||SQLERRM);
5909: END Process_SSXref_Intf_Rows;
5910:
5911: /*

Line 8282: SET ITEM_NUMBER = EGO_IMPORT_PVT.GET_NEXT_ITEM_NUMBER(MSII.ITEM_CATALOG_GROUP_ID)

8278: -- so the overwriting of item number must happen only from IOI
8279: /*
8280: UPDATE
8281: MTL_SYSTEM_ITEMS_INTERFACE MSII
8282: SET ITEM_NUMBER = EGO_IMPORT_PVT.GET_NEXT_ITEM_NUMBER(MSII.ITEM_CATALOG_GROUP_ID)
8283: WHERE MSII.ITEM_CATALOG_GROUP_ID IS NOT NULL
8284: AND MSII.ITEM_NUMBER IS NULL
8285: AND MSII.SET_PROCESS_ID = p_data_set_id
8286: AND MSII.PROCESS_FLAG = 0

Line 10908: || ' , EGO_IMPORT_PVT.wrapped_to_date( EIUAI.ATTR_DISP_VALUE ) '

10904: IF p_get_value_column THEN
10905: l_select_sql := ' EIUAI.ATTR_VALUE_DATE ';
10906: ELSE
10907: l_select_sql := ' NVL2( EIUAI.ATTR_DISP_VALUE '
10908: || ' , EGO_IMPORT_PVT.wrapped_to_date( EIUAI.ATTR_DISP_VALUE ) '
10909: || ' , CASE WHEN EIUAI.ATTR_VALUE_DATE IS NULL '
10910: || 'OR EIUAI.ATTR_VALUE_DATE = TO_DATE(''1'',''J'') THEN ' || G_EXCEL_MISS_DATE_STR
10911: || ' ELSE EIUAI.ATTR_VALUE_DATE END'
10912: || ' ) '

Line 12001: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id

11997: BEGIN
11998:
11999: IF (p_match_count < 1) THEN
12000:
12001: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12002: ,p_src_system_id
12003: ,p_src_system_ref
12004: ,EGO_IMPORT_PVT.G_UNCONF_NONE_MATCH);
12005:

Line 12004: ,EGO_IMPORT_PVT.G_UNCONF_NONE_MATCH);

12000:
12001: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12002: ,p_src_system_id
12003: ,p_src_system_ref
12004: ,EGO_IMPORT_PVT.G_UNCONF_NONE_MATCH);
12005:
12006: ELSIF (p_match_count > 1) THEN
12007:
12008: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id

Line 12008: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id

12004: ,EGO_IMPORT_PVT.G_UNCONF_NONE_MATCH);
12005:
12006: ELSIF (p_match_count > 1) THEN
12007:
12008: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12009: ,p_src_system_id
12010: ,p_src_system_ref
12011: ,EGO_IMPORT_PVT.G_UNCONF_MULT_MATCH);
12012:

Line 12011: ,EGO_IMPORT_PVT.G_UNCONF_MULT_MATCH);

12007:
12008: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12009: ,p_src_system_id
12010: ,p_src_system_ref
12011: ,EGO_IMPORT_PVT.G_UNCONF_MULT_MATCH);
12012:
12013: ELSE
12014:
12015: SELECT CONFIRM_SINGLE_MATCH

Line 12022: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id

12018: WHERE BATCH_ID = p_batch_id;
12019:
12020: IF (l_confirm_single_match = 'Y') THEN
12021:
12022: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12023: ,p_src_system_id
12024: ,p_src_system_ref
12025: ,EGO_IMPORT_PVT.G_CONF_MATCH
12026: ,p_inventory_item_id

Line 12025: ,EGO_IMPORT_PVT.G_CONF_MATCH

12021:
12022: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12023: ,p_src_system_id
12024: ,p_src_system_ref
12025: ,EGO_IMPORT_PVT.G_CONF_MATCH
12026: ,p_inventory_item_id
12027: ,p_organization_id);
12028:
12029: ELSE

Line 12031: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id

12027: ,p_organization_id);
12028:
12029: ELSE
12030:
12031: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12032: ,p_src_system_id
12033: ,p_src_system_ref
12034: ,EGO_IMPORT_PVT.G_UNCONF_SIGL_MATCH
12035: ,p_inventory_item_id

Line 12034: ,EGO_IMPORT_PVT.G_UNCONF_SIGL_MATCH

12030:
12031: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12032: ,p_src_system_id
12033: ,p_src_system_ref
12034: ,EGO_IMPORT_PVT.G_UNCONF_SIGL_MATCH
12035: ,p_inventory_item_id
12036: ,p_organization_id);
12037:
12038: END IF;

Line 13026: END EGO_IMPORT_PVT;

13022: WHERE BATCH_ID = p_batch_id;
13023: END IF; -- IF ( NVL(p_import_request_id, 0) > 0 ) OR ( NVL(p_match_request_id, 0) > 0 ) THEN
13024: END Update_Request_Id_To_Batch;
13025:
13026: END EGO_IMPORT_PVT;