[Home] [Help]
1: PACKAGE BODY EGO_IMPORT_PVT AS
2: /* $Header: EGOVIMPB.pls 120.184.12020000.5 2013/02/26 18:02:20 gnookala ship $ */
3:
4: G_DEFAULT_ATTR_GROUP_TYPE CONSTANT VARCHAR2(30) := 'EGO_ITEMMGMT_GROUP';
5: -- G_IOI_STAMP_REQUEST_ID_FLAG CONSTANT NUMBER := -1;
5082: ERRBUF := NULL;
5083: EXCEPTION WHEN OTHERS THEN
5084: Debug_Conc_Log(l_proc_log_prefix || 'Error - ' || SQLERRM);
5085: RETCODE := '2';
5086: ERRBUF := 'Error in method EGO_IMPORT_PVT.Demerge_Batch_After_Import - '||SQLERRM;
5087: END Demerge_Batch_After_Import;
5088:
5089: /*
5090: * This method does a bulkload of GTINs
5506: Debug_Conc_Log('Done Process_Gtin_Intf_Rows with success');
5507: EXCEPTION WHEN OTHERS THEN
5508: Debug_Conc_Log('Done Process_Gtin_Intf_Rows with error - '||SQLERRM);
5509: RETCODE := '2';
5510: ERRBUF := 'Error in method EGO_IMPORT_PVT.Process_Gtin_Intf_Rows - '||SQLERRM;
5511: END Process_Gtin_Intf_Rows;
5512:
5513: /*
5514: * Private method to process Source System item cross reference
5969: ERRBUF := NULL;
5970: Debug_Conc_Log('Done Process_SSXref_Intf_Rows with success');
5971: EXCEPTION WHEN OTHERS THEN
5972: RETCODE := '2';
5973: ERRBUF := 'Error in method EGO_IMPORT_PVT.Process_SSXref_Intf_Rows - '||SQLERRM;
5974: Debug_Conc_Log('Done Process_SSXref_Intf_Rows with error - '||SQLERRM);
5975: END Process_SSXref_Intf_Rows;
5976:
5977: /*
8381: -- so the overwriting of item number must happen only from IOI
8382: /*
8383: UPDATE
8384: MTL_SYSTEM_ITEMS_INTERFACE MSII
8385: SET ITEM_NUMBER = EGO_IMPORT_PVT.GET_NEXT_ITEM_NUMBER(MSII.ITEM_CATALOG_GROUP_ID)
8386: WHERE MSII.ITEM_CATALOG_GROUP_ID IS NOT NULL
8387: AND MSII.ITEM_NUMBER IS NULL
8388: AND MSII.SET_PROCESS_ID = p_data_set_id
8389: AND MSII.PROCESS_FLAG = 0
11007: IF p_get_value_column THEN
11008: l_select_sql := ' EIUAI.ATTR_VALUE_DATE ';
11009: ELSE
11010: l_select_sql := ' NVL2( EIUAI.ATTR_DISP_VALUE '
11011: || ' , EGO_IMPORT_PVT.wrapped_to_date( EIUAI.ATTR_DISP_VALUE ) '
11012: || ' , CASE WHEN EIUAI.ATTR_VALUE_DATE IS NULL '
11013: || 'OR EIUAI.ATTR_VALUE_DATE = TO_DATE(''1'',''J'') THEN ' || G_EXCEL_MISS_DATE_STR
11014: || ' ELSE EIUAI.ATTR_VALUE_DATE END'
11015: || ' ) '
12111: /* Bug 8621347. Set the CONFIRM_STATUS to G_CONF_NEW (Confirm New), if CONFIRM_NO_MATCH i.e., 'Automatically Confirm New Item on No Match'
12112: is enabled. Otherwise, set CONFIRM_STATUS to G_UNCONF_NONE_MATCH (Unconfirm No Match).
12113: */
12114: IF (l_confirm_no_match = 'Y') THEN
12115: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12116: ,p_src_system_id
12117: ,p_src_system_ref
12118: ,EGO_IMPORT_PVT.G_CONF_NEW);
12119: ELSE
12114: IF (l_confirm_no_match = 'Y') THEN
12115: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12116: ,p_src_system_id
12117: ,p_src_system_ref
12118: ,EGO_IMPORT_PVT.G_CONF_NEW);
12119: ELSE
12120: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12121: ,p_src_system_id
12122: ,p_src_system_ref
12116: ,p_src_system_id
12117: ,p_src_system_ref
12118: ,EGO_IMPORT_PVT.G_CONF_NEW);
12119: ELSE
12120: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12121: ,p_src_system_id
12122: ,p_src_system_ref
12123: ,EGO_IMPORT_PVT.G_UNCONF_NONE_MATCH);
12124: END IF;
12119: ELSE
12120: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12121: ,p_src_system_id
12122: ,p_src_system_ref
12123: ,EGO_IMPORT_PVT.G_UNCONF_NONE_MATCH);
12124: END IF;
12125:
12126: ELSIF (p_match_count > 1) THEN
12127:
12124: END IF;
12125:
12126: ELSIF (p_match_count > 1) THEN
12127:
12128: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12129: ,p_src_system_id
12130: ,p_src_system_ref
12131: ,EGO_IMPORT_PVT.G_UNCONF_MULT_MATCH);
12132:
12127:
12128: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12129: ,p_src_system_id
12130: ,p_src_system_ref
12131: ,EGO_IMPORT_PVT.G_UNCONF_MULT_MATCH);
12132:
12133: ELSE
12134:
12135: SELECT CONFIRM_SINGLE_MATCH
12138: WHERE BATCH_ID = p_batch_id;
12139:
12140: IF (l_confirm_single_match = 'Y') THEN
12141:
12142: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12143: ,p_src_system_id
12144: ,p_src_system_ref
12145: ,EGO_IMPORT_PVT.G_CONF_MATCH
12146: ,p_inventory_item_id
12141:
12142: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12143: ,p_src_system_id
12144: ,p_src_system_ref
12145: ,EGO_IMPORT_PVT.G_CONF_MATCH
12146: ,p_inventory_item_id
12147: ,p_organization_id);
12148:
12149: ELSE
12147: ,p_organization_id);
12148:
12149: ELSE
12150:
12151: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12152: ,p_src_system_id
12153: ,p_src_system_ref
12154: ,EGO_IMPORT_PVT.G_UNCONF_SIGL_MATCH
12155: ,p_inventory_item_id
12150:
12151: EGO_IMPORT_PVT.Set_Confirm_Status(p_batch_id
12152: ,p_src_system_id
12153: ,p_src_system_ref
12154: ,EGO_IMPORT_PVT.G_UNCONF_SIGL_MATCH
12155: ,p_inventory_item_id
12156: ,p_organization_id);
12157:
12158: END IF;
13142: WHERE BATCH_ID = p_batch_id;
13143: END IF; -- IF ( NVL(p_import_request_id, 0) > 0 ) OR ( NVL(p_match_request_id, 0) > 0 ) THEN
13144: END Update_Request_Id_To_Batch;
13145:
13146: END EGO_IMPORT_PVT;