274:
275: -- ******************************************************************
276: -- Validate Environment
277: -- ******************************************************************
278: IF FND_GLOBAL.User_Id IS NULL
279: THEN
280: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
281: THEN
282: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'UT_CANNOT_GET_PROFILE_VALUE');
338: p_PROGRAM_ID => p_CSC_CUST_PLANS_rec.PROGRAM_ID,
339: p_PROGRAM_UPDATE_DATE => p_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,
340: p_CREATION_DATE => SYSDATE,
341: p_LAST_UPDATE_DATE => SYSDATE,
342: p_CREATED_BY => FND_GLOBAL.USER_ID,
343: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
344: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
345: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1,
346: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2,
339: p_PROGRAM_UPDATE_DATE => p_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,
340: p_CREATION_DATE => SYSDATE,
341: p_LAST_UPDATE_DATE => SYSDATE,
342: p_CREATED_BY => FND_GLOBAL.USER_ID,
343: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
344: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
345: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1,
346: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2,
347: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3,
340: p_CREATION_DATE => SYSDATE,
341: p_LAST_UPDATE_DATE => SYSDATE,
342: p_CREATED_BY => FND_GLOBAL.USER_ID,
343: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
344: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
345: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1,
346: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2,
347: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3,
348: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4,
375: p_PROGRAM_ID => p_CSC_CUST_PLANS_rec.PROGRAM_ID ,
376: p_PROGRAM_UPDATE_DATE => p_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE ,
377: p_CREATION_DATE => SYSDATE,
378: p_LAST_UPDATE_DATE => SYSDATE,
379: p_CREATED_BY => FND_GLOBAL.USER_ID,
380: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
381: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
382: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1 ,
383: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2 ,
376: p_PROGRAM_UPDATE_DATE => p_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE ,
377: p_CREATION_DATE => SYSDATE,
378: p_LAST_UPDATE_DATE => SYSDATE,
379: p_CREATED_BY => FND_GLOBAL.USER_ID,
380: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
381: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
382: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1 ,
383: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2 ,
384: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3 ,
377: p_CREATION_DATE => SYSDATE,
378: p_LAST_UPDATE_DATE => SYSDATE,
379: p_CREATED_BY => FND_GLOBAL.USER_ID,
380: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
381: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
382: p_ATTRIBUTE1 => p_CSC_CUST_PLANS_rec.ATTRIBUTE1 ,
383: p_ATTRIBUTE2 => p_CSC_CUST_PLANS_rec.ATTRIBUTE2 ,
384: p_ATTRIBUTE3 => p_CSC_CUST_PLANS_rec.ATTRIBUTE3 ,
385: p_ATTRIBUTE4 => p_CSC_CUST_PLANS_rec.ATTRIBUTE4 ,
756: p_PROGRAM_APPLICATION_ID => l_upd_csc_cust_plans_rec.PROGRAM_APPLICATION_ID,
757: p_PROGRAM_ID => l_upd_csc_cust_plans_rec.PROGRAM_ID,
758: p_PROGRAM_UPDATE_DATE => l_upd_csc_cust_plans_rec.PROGRAM_UPDATE_DATE,
759: p_LAST_UPDATE_DATE => SYSDATE,
760: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
761: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
762: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1,
763: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2,
764: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3,
757: p_PROGRAM_ID => l_upd_csc_cust_plans_rec.PROGRAM_ID,
758: p_PROGRAM_UPDATE_DATE => l_upd_csc_cust_plans_rec.PROGRAM_UPDATE_DATE,
759: p_LAST_UPDATE_DATE => SYSDATE,
760: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
761: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
762: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1,
763: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2,
764: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3,
765: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4,
789: p_PROGRAM_ID => l_upd_csc_cust_plans_rec.PROGRAM_ID ,
790: p_PROGRAM_UPDATE_DATE => l_upd_csc_cust_plans_rec.PROGRAM_UPDATE_DATE ,
791: p_CREATION_DATE => SYSDATE,
792: p_LAST_UPDATE_DATE => SYSDATE,
793: p_CREATED_BY => FND_GLOBAL.USER_ID,
794: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
795: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
796: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1 ,
797: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2 ,
790: p_PROGRAM_UPDATE_DATE => l_upd_csc_cust_plans_rec.PROGRAM_UPDATE_DATE ,
791: p_CREATION_DATE => SYSDATE,
792: p_LAST_UPDATE_DATE => SYSDATE,
793: p_CREATED_BY => FND_GLOBAL.USER_ID,
794: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
795: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
796: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1 ,
797: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2 ,
798: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3 ,
791: p_CREATION_DATE => SYSDATE,
792: p_LAST_UPDATE_DATE => SYSDATE,
793: p_CREATED_BY => FND_GLOBAL.USER_ID,
794: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
795: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
796: p_ATTRIBUTE1 => l_upd_csc_cust_plans_rec.ATTRIBUTE1 ,
797: p_ATTRIBUTE2 => l_upd_csc_cust_plans_rec.ATTRIBUTE2 ,
798: p_ATTRIBUTE3 => l_upd_csc_cust_plans_rec.ATTRIBUTE3 ,
799: p_ATTRIBUTE4 => l_upd_csc_cust_plans_rec.ATTRIBUTE4 ,
1148: p_PROGRAM_ID => c1rec.PROGRAM_ID ,
1149: p_PROGRAM_UPDATE_DATE => c1rec.PROGRAM_UPDATE_DATE ,
1150: p_CREATION_DATE => SYSDATE,
1151: p_LAST_UPDATE_DATE => SYSDATE,
1152: p_CREATED_BY => FND_GLOBAL.USER_ID,
1153: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1154: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1155: p_ATTRIBUTE1 => c1rec.ATTRIBUTE1 ,
1156: p_ATTRIBUTE2 => c1rec.ATTRIBUTE2 ,
1149: p_PROGRAM_UPDATE_DATE => c1rec.PROGRAM_UPDATE_DATE ,
1150: p_CREATION_DATE => SYSDATE,
1151: p_LAST_UPDATE_DATE => SYSDATE,
1152: p_CREATED_BY => FND_GLOBAL.USER_ID,
1153: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1154: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1155: p_ATTRIBUTE1 => c1rec.ATTRIBUTE1 ,
1156: p_ATTRIBUTE2 => c1rec.ATTRIBUTE2 ,
1157: p_ATTRIBUTE3 => c1rec.ATTRIBUTE3 ,
1150: p_CREATION_DATE => SYSDATE,
1151: p_LAST_UPDATE_DATE => SYSDATE,
1152: p_CREATED_BY => FND_GLOBAL.USER_ID,
1153: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1154: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1155: p_ATTRIBUTE1 => c1rec.ATTRIBUTE1 ,
1156: p_ATTRIBUTE2 => c1rec.ATTRIBUTE2 ,
1157: p_ATTRIBUTE3 => c1rec.ATTRIBUTE3 ,
1158: p_ATTRIBUTE4 => c1rec.ATTRIBUTE4 ,
1265: p_PROGRAM_ID => c1rec.PROGRAM_ID ,
1266: p_PROGRAM_UPDATE_DATE => c1rec.PROGRAM_UPDATE_DATE ,
1267: p_CREATION_DATE => SYSDATE,
1268: p_LAST_UPDATE_DATE => SYSDATE,
1269: p_CREATED_BY => FND_GLOBAL.USER_ID,
1270: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1271: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1272: p_ATTRIBUTE1 => c1rec.ATTRIBUTE1 ,
1273: p_ATTRIBUTE2 => c1rec.ATTRIBUTE2 ,
1266: p_PROGRAM_UPDATE_DATE => c1rec.PROGRAM_UPDATE_DATE ,
1267: p_CREATION_DATE => SYSDATE,
1268: p_LAST_UPDATE_DATE => SYSDATE,
1269: p_CREATED_BY => FND_GLOBAL.USER_ID,
1270: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1271: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1272: p_ATTRIBUTE1 => c1rec.ATTRIBUTE1 ,
1273: p_ATTRIBUTE2 => c1rec.ATTRIBUTE2 ,
1274: p_ATTRIBUTE3 => c1rec.ATTRIBUTE3 ,
1267: p_CREATION_DATE => SYSDATE,
1268: p_LAST_UPDATE_DATE => SYSDATE,
1269: p_CREATED_BY => FND_GLOBAL.USER_ID,
1270: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1271: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1272: p_ATTRIBUTE1 => c1rec.ATTRIBUTE1 ,
1273: p_ATTRIBUTE2 => c1rec.ATTRIBUTE2 ,
1274: p_ATTRIBUTE3 => c1rec.ATTRIBUTE3 ,
1275: p_ATTRIBUTE4 => c1rec.ATTRIBUTE4 ,