APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_TRADING_PARTNERS_S

Line 2413: ( MSC_Trading_Partners_S.NEXTVAL,

2409: LAST_UPDATED_BY,
2410: CREATION_DATE,
2411: CREATED_BY)
2412: VALUES
2413: ( MSC_Trading_Partners_S.NEXTVAL,
2414: /* SCE change starts */
2415: c_rec.company_id,
2416: /* SCE change ends */
2417: c_rec.ORGANIZATION_CODE,

Line 2680: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS_SITES');

2676:
2677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2678: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2679: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2680: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS_SITES');
2681: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2682:
2683: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2684: RAISE;

Line 2692: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS_SITES');

2688:
2689: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2690: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2691: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRADING_PARTNER');
2692: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNERS_SITES');
2693: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2694:
2695: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2696: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TP_SITE_ID');

Line 4267: MSC_Trading_Partners_S.NEXTVAL,

4263: ( /* SCE Change starts */
4264: c_rec.COMPANY_ID1,
4265: /* SCE Change ends */
4266: c_rec.Partner_Name,
4267: MSC_Trading_Partners_S.NEXTVAL,
4268: MSC_Trading_Partners_S.NEXTVAL, -- dummy value to satisfy the unique constraint
4269: c_rec.Partner_Type,
4270: -1,
4271: -1,

Line 4268: MSC_Trading_Partners_S.NEXTVAL, -- dummy value to satisfy the unique constraint

4264: c_rec.COMPANY_ID1,
4265: /* SCE Change ends */
4266: c_rec.Partner_Name,
4267: MSC_Trading_Partners_S.NEXTVAL,
4268: MSC_Trading_Partners_S.NEXTVAL, -- dummy value to satisfy the unique constraint
4269: c_rec.Partner_Type,
4270: -1,
4271: -1,
4272: -1,