APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_LOCATION_ASSOCIATIONS

Line 2706: DELETE MSC_LOCATION_ASSOCIATIONS

2702: COMMIT;
2703:
2704: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.v_is_cont_refresh) THEN
2705:
2706: DELETE MSC_LOCATION_ASSOCIATIONS
2707: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
2708:
2709: -- MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_LOCATION_ASSOCIATIONS', MSC_CL_COLLECTION.v_instance_id, NULL);
2710:

Line 2709: -- MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_LOCATION_ASSOCIATIONS', MSC_CL_COLLECTION.v_instance_id, NULL);

2705:
2706: DELETE MSC_LOCATION_ASSOCIATIONS
2707: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
2708:
2709: -- MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_LOCATION_ASSOCIATIONS', MSC_CL_COLLECTION.v_instance_id, NULL);
2710:
2711: END IF;
2712:
2713: FOR c_rec IN c3 LOOP

Line 2719: INSERT INTO MSC_LOCATION_ASSOCIATIONS

2715: BEGIN
2716:
2717: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.v_is_legacy_refresh OR MSC_CL_COLLECTION.v_is_cont_refresh) THEN
2718:
2719: INSERT INTO MSC_LOCATION_ASSOCIATIONS
2720: ( LOCATION_ID,
2721: LOCATION_CODE,
2722: PARTNER_ID,
2723: PARTNER_SITE_ID,

Line 2752: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LOCATION_ASSOCIATIONS');

2748:
2749: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2750: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2751: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2752: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LOCATION_ASSOCIATIONS');
2753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2754:
2755: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2756: RAISE;

Line 2765: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LOCATION_ASSOCIATIONS');

2761:
2762: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2763: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2764: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2765: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LOCATION_ASSOCIATIONS');
2766: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2767:
2768: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2769: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOCATION_ID');

Line 2795: INSERT INTO MSC_LOCATION_ASSOCIATIONS

2791: BEGIN
2792:
2793: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.v_is_legacy_refresh OR MSC_CL_COLLECTION.v_is_cont_refresh) THEN
2794:
2795: INSERT INTO MSC_LOCATION_ASSOCIATIONS
2796: ( LOCATION_ID,
2797: LOCATION_CODE,
2798: PARTNER_ID,
2799: PARTNER_SITE_ID,

Line 2827: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LOCATION_ASSOCIATIONS');

2823:
2824: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2825: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2826: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2827: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LOCATION_ASSOCIATIONS');
2828: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2829:
2830: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2831: RAISE;

Line 2839: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LOCATION_ASSOCIATIONS');

2835:
2836: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2837: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2838: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2839: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LOCATION_ASSOCIATIONS');
2840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2841:
2842: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2843: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOCATION_ID');