[Home] [Help]
1198: LOG_MESSAGE(SQLERRM);
1199: return FALSE;
1200: END;
1201: END IF;
1202: LOG_MESSAGE('Validation of msc_item_customers finished');
1203:
1204: /* Data validation ends */
1205:
1206:
1387: set company_id = a_company_id(i),
1388: company_site_id = decode(a_company_site_id(i), -99, null, a_company_site_id(i))
1389: where msic.rowid = CHARTOROWID(a_rowid(i));
1390: EXCEPTION WHEN OTHERS THEN
1391: LOG_MESSAGE('Error while updating msc_item_customers with company_id and company_site_id');
1392: LOG_MESSAGE('========================================');
1393: FND_MESSAGE.SET_NAME('MSC', 'MSC_CLEAN_TP_ITEM_ERR');
1394: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_TP_ITEMS');
1395: LOG_MESSAGE(FND_MESSAGE.GET);
1925:
1926: END POPULATE_TP_MAP_TABLE;
1927:
1928:
1929: --==== ODS Load for msc_item_customers ====
1930: PROCEDURE LOAD_ITEM_CUSTOMERS(p_instance_id NUMBER) IS
1931:
1932: CURSOR itemCustomers IS
1933: select t1.inventory_item_id,
2005: /* Update the record if it already exists */
2006: BEGIN
2007:
2008: FORALL i IN 1..a_inventory_item_id.COUNT
2009: UPDATE MSC_ITEM_CUSTOMERS mic
2010: set lead_time = a_lead_time(i),
2011: uom_code = a_uom_code(i),
2012: list_price = a_list_price(i),
2013: refresh_number = a_refresh_number(i),
2018: and customer_id = a_tp_id(i)
2019: and nvl(customer_site_id, -99) = nvl(a_tp_site_id(i), -99);
2020:
2021: EXCEPTION WHEN OTHERS THEN
2022: LOG_MESSAGE('ERROR while updating msc_item_customers');
2023: LOG_MESSAGE(SQLERRM);
2024: END;
2025:
2026: /* Build the collection objects for insertion */
2061:
2062: IF a_ins_count.COUNT > 0 THEN
2063:
2064: FORALL i IN 1..a_ins_count.COUNT
2065: INSERT INTO MSC_ITEM_CUSTOMERS
2066: (PLAN_ID ,
2067: CUSTOMER_ID ,
2068: CUSTOMER_SITE_ID,
2069: INVENTORY_ITEM_ID,
2100:
2101: END IF; -- a_ins_count.COUNT > 0
2102:
2103: EXCEPTION WHEN OTHERS THEN
2104: LOG_MESSAGE('Error while inserting into msc_item_customers');
2105: LOG_MESSAGE(SQLERRM);
2106:
2107: END;
2108: END IF; -- a_inventory_item_id.COUNT > 0