APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_LOCATION_ASSOCIATIONS

Line 2716: DELETE MSC_LOCATION_ASSOCIATIONS

2712: COMMIT;
2713:
2714: 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
2715:
2716: DELETE MSC_LOCATION_ASSOCIATIONS
2717: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
2718:
2719: -- MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_LOCATION_ASSOCIATIONS', MSC_CL_COLLECTION.v_instance_id, NULL);
2720:

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

2715:
2716: DELETE MSC_LOCATION_ASSOCIATIONS
2717: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
2718:
2719: -- MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_LOCATION_ASSOCIATIONS', MSC_CL_COLLECTION.v_instance_id, NULL);
2720:
2721: END IF;
2722:
2723: FOR c_rec IN c3 LOOP

Line 2729: INSERT INTO MSC_LOCATION_ASSOCIATIONS

2725: BEGIN
2726:
2727: 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
2728:
2729: INSERT INTO MSC_LOCATION_ASSOCIATIONS
2730: ( LOCATION_ID,
2731: LOCATION_CODE,
2732: PARTNER_ID,
2733: PARTNER_SITE_ID,

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

2758:
2759: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2760: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2761: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2762: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LOCATION_ASSOCIATIONS');
2763: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2764:
2765: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2766: RAISE;

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

2771:
2772: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2773: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2774: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2775: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LOCATION_ASSOCIATIONS');
2776: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2777:
2778: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2779: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOCATION_ID');

Line 2805: INSERT INTO MSC_LOCATION_ASSOCIATIONS

2801: BEGIN
2802:
2803: 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
2804:
2805: INSERT INTO MSC_LOCATION_ASSOCIATIONS
2806: ( LOCATION_ID,
2807: LOCATION_CODE,
2808: PARTNER_ID,
2809: PARTNER_SITE_ID,

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

2833:
2834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2835: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2836: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2837: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LOCATION_ASSOCIATIONS');
2838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2839:
2840: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2841: RAISE;

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

2845:
2846: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2847: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2848: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2849: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_LOCATION_ASSOCIATIONS');
2850: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2851:
2852: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2853: FND_MESSAGE.SET_TOKEN('COLUMN', 'LOCATION_ID');