[Home] [Help]
1115: LOG_MESSAGE(SQLERRM);
1116: return FALSE;
1117: END;
1118: END IF;
1119: LOG_MESSAGE('Validation of msc_item_customers finished');
1120:
1121: /* Data validation ends */
1122:
1123:
1304: set company_id = a_company_id(i),
1305: company_site_id = decode(a_company_site_id(i), -99, null, a_company_site_id(i))
1306: where msic.rowid = CHARTOROWID(a_rowid(i));
1307: EXCEPTION WHEN OTHERS THEN
1308: LOG_MESSAGE('Error while updating msc_item_customers with company_id and company_site_id');
1309: LOG_MESSAGE('========================================');
1310: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');
1311: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');
1312: LOG_MESSAGE(FND_MESSAGE.GET);
1842:
1843: END POPULATE_TP_MAP_TABLE;
1844:
1845:
1846: --==== ODS Load for msc_item_customers ====
1847: PROCEDURE LOAD_ITEM_CUSTOMERS(p_instance_id NUMBER) IS
1848:
1849: CURSOR itemCustomers IS
1850: select t1.inventory_item_id,
1922: /* Update the record if it already exists */
1923: BEGIN
1924:
1925: FORALL i IN 1..a_inventory_item_id.COUNT
1926: UPDATE MSC_ITEM_CUSTOMERS mic
1927: set lead_time = a_lead_time(i),
1928: uom_code = a_uom_code(i),
1929: list_price = a_list_price(i),
1930: refresh_number = a_refresh_number(i),
1935: and customer_id = a_tp_id(i)
1936: and nvl(customer_site_id, -99) = nvl(a_tp_site_id(i), -99);
1937:
1938: EXCEPTION WHEN OTHERS THEN
1939: LOG_MESSAGE('ERROR while updating msc_item_customers');
1940: LOG_MESSAGE(SQLERRM);
1941: END;
1942:
1943: /* Build the collection objects for insertion */
1978:
1979: IF a_ins_count.COUNT > 0 THEN
1980:
1981: FORALL i IN 1..a_ins_count.COUNT
1982: INSERT INTO MSC_ITEM_CUSTOMERS
1983: (PLAN_ID ,
1984: CUSTOMER_ID ,
1985: CUSTOMER_SITE_ID,
1986: INVENTORY_ITEM_ID,
2017:
2018: END IF; -- a_ins_count.COUNT > 0
2019:
2020: EXCEPTION WHEN OTHERS THEN
2021: LOG_MESSAGE('Error while inserting into msc_item_customers');
2022: LOG_MESSAGE(SQLERRM);
2023:
2024: END;
2025: END IF; -- a_inventory_item_id.COUNT > 0