eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_CUST_PLANS_PVT dependencies on CSC_CORE_UTILS_PVT

Line 282: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'UT_CANNOT_GET_PROFILE_VALUE');

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');
283: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
284: -- FND_MSG_PUB.ADD;
285: END IF;
286: RAISE FND_API.G_EXC_ERROR;

Line 295: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,

291: -- Invoke validation procedures
292: Validate_csc_cust_plans(
293: p_init_msg_list => FND_API.G_FALSE,
294: p_validation_level => p_validation_level,
295: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
296: P_CSC_CUST_PLANS_Rec => P_CSC_CUST_PLANS_Rec,
297: x_return_status => x_return_status,
298: x_msg_count => x_msg_count,
299: x_msg_data => x_msg_data);

Line 316: --FND_MESSAGE.SET_NAME(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, '

312: p_csc_cust_plans_rec.END_DATE_ACTIVE = FND_API.G_MISS_DATE )) THEN
313: OPEN c1 (p_csc_cust_plans_rec.plan_id);
314: FETCH c1 INTO l_start_date_active, l_end_date_active;
315: IF C1%NOTFOUND THEN
316: --FND_MESSAGE.SET_NAME(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, '
317: CLOSE c1;
318: RAISE NO_DATA_FOUND;
319: END IF;
320: CLOSE c1;

Line 335: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,

331: -- p_CUST_ACCOUNT_ORG => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG,
332: p_START_DATE_ACTIVE => l_start_date_active,
333: p_END_DATE_ACTIVE => l_end_date_active,
334: p_MANUAL_FLAG => p_CSC_CUST_PLANS_rec.MANUAL_FLAG,
335: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
336: p_REQUEST_ID => p_CSC_CUST_PLANS_rec.REQUEST_ID,
337: p_PROGRAM_APPLICATION_ID => p_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID,
338: p_PROGRAM_ID => p_CSC_CUST_PLANS_rec.PROGRAM_ID,
339: p_PROGRAM_UPDATE_DATE => p_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE,

Line 372: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,

368: p_PLAN_ID => p_CSC_CUST_PLANS_rec.PLAN_ID ,
369: p_PARTY_ID => p_CSC_CUST_PLANS_rec.PARTY_ID ,
370: p_CUST_ACCOUNT_ID => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID ,
371: -- p_CUST_ACCOUNT_ORG => p_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ORG ,
372: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.APPLY_PLAN,
373: p_REQUEST_ID => p_CSC_CUST_PLANS_rec.REQUEST_ID ,
374: p_PROGRAM_APPLICATION_ID => p_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID ,
375: p_PROGRAM_ID => p_CSC_CUST_PLANS_rec.PROGRAM_ID ,
376: p_PROGRAM_UPDATE_DATE => p_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE ,

Line 413: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

409: p_data => x_msg_data );
410:
411: EXCEPTION
412: WHEN FND_API.G_EXC_ERROR THEN
413: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
414: P_API_NAME => L_API_NAME,
415: P_PKG_NAME => G_PKG_NAME,
416: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
417: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 417: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

413: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
414: P_API_NAME => L_API_NAME,
415: P_PKG_NAME => G_PKG_NAME,
416: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
417: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
418: X_MSG_COUNT => X_MSG_COUNT,
419: X_MSG_DATA => X_MSG_DATA,
420: X_RETURN_STATUS => X_RETURN_STATUS);
421: APP_EXCEPTION.RAISE_EXCEPTION;

Line 424: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

420: X_RETURN_STATUS => X_RETURN_STATUS);
421: APP_EXCEPTION.RAISE_EXCEPTION;
422:
423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
424: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
425: P_API_NAME => L_API_NAME,
426: P_PKG_NAME => G_PKG_NAME,
427: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
428: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 428: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

424: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
425: P_API_NAME => L_API_NAME,
426: P_PKG_NAME => G_PKG_NAME,
427: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
428: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
429: X_MSG_COUNT => X_MSG_COUNT,
430: X_MSG_DATA => X_MSG_DATA,
431: X_RETURN_STATUS => X_RETURN_STATUS);
432: APP_EXCEPTION.RAISE_EXCEPTION;

Line 435: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

431: X_RETURN_STATUS => X_RETURN_STATUS);
432: APP_EXCEPTION.RAISE_EXCEPTION;
433:
434: WHEN OTHERS THEN
435: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
436: P_API_NAME => L_API_NAME,
437: P_PKG_NAME => G_PKG_NAME,
438: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
439: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 438: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,

434: WHEN OTHERS THEN
435: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
436: P_API_NAME => L_API_NAME,
437: P_PKG_NAME => G_PKG_NAME,
438: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
439: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
440: X_MSG_COUNT => X_MSG_COUNT,
441: X_MSG_DATA => X_MSG_DATA,
442: X_RETURN_STATUS => X_RETURN_STATUS);

Line 439: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

435: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
436: P_API_NAME => L_API_NAME,
437: P_PKG_NAME => G_PKG_NAME,
438: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
439: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
440: X_MSG_COUNT => X_MSG_COUNT,
441: X_MSG_DATA => X_MSG_DATA,
442: X_RETURN_STATUS => X_RETURN_STATUS);
443: APP_EXCEPTION.RAISE_EXCEPTION;

Line 667: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');

663: If ( C_Get_cust_plans%NOTFOUND) Then
664: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
665: THEN
666: Close C_Get_cust_plans;
667: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
668: FND_MESSAGE.Set_Token ('INFO', 'cust_plans', FALSE);
669: -- FND_MSG_PUB.Add;
670: END IF;
671: raise FND_API.G_EXC_ERROR;

Line 675: l_upd_csc_cust_plans_rec.cust_account_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.cust_account_id, l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID);

671: raise FND_API.G_EXC_ERROR;
672: END IF;
673: Close C_Get_cust_plans;
674:
675: l_upd_csc_cust_plans_rec.cust_account_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.cust_account_id, l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID);
676:
677: l_upd_csc_cust_plans_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.start_date_active, l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE);
678:
679: l_upd_csc_cust_plans_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.end_date_active, l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE);

Line 677: l_upd_csc_cust_plans_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.start_date_active, l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE);

673: Close C_Get_cust_plans;
674:
675: l_upd_csc_cust_plans_rec.cust_account_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.cust_account_id, l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID);
676:
677: l_upd_csc_cust_plans_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.start_date_active, l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE);
678:
679: l_upd_csc_cust_plans_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.end_date_active, l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE);
680:
681: l_upd_csc_cust_plans_rec.manual_flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.manual_flag, l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG);

Line 679: l_upd_csc_cust_plans_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.end_date_active, l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE);

675: l_upd_csc_cust_plans_rec.cust_account_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.cust_account_id, l_ref_CSC_CUST_PLANS_rec.CUST_ACCOUNT_ID);
676:
677: l_upd_csc_cust_plans_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.start_date_active, l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE);
678:
679: l_upd_csc_cust_plans_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.end_date_active, l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE);
680:
681: l_upd_csc_cust_plans_rec.manual_flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.manual_flag, l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG);
682:
683: l_upd_csc_cust_plans_rec.plan_status_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.plan_status_code, l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE);

Line 681: l_upd_csc_cust_plans_rec.manual_flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.manual_flag, l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG);

677: l_upd_csc_cust_plans_rec.start_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.start_date_active, l_ref_CSC_CUST_PLANS_rec.START_DATE_ACTIVE);
678:
679: l_upd_csc_cust_plans_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.end_date_active, l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE);
680:
681: l_upd_csc_cust_plans_rec.manual_flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.manual_flag, l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG);
682:
683: l_upd_csc_cust_plans_rec.plan_status_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.plan_status_code, l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE);
684:
685: l_upd_csc_cust_plans_rec.request_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.request_id, l_ref_CSC_CUST_PLANS_rec.REQUEST_ID);

Line 683: l_upd_csc_cust_plans_rec.plan_status_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.plan_status_code, l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE);

679: l_upd_csc_cust_plans_rec.end_date_active := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.end_date_active, l_ref_CSC_CUST_PLANS_rec.END_DATE_ACTIVE);
680:
681: l_upd_csc_cust_plans_rec.manual_flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.manual_flag, l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG);
682:
683: l_upd_csc_cust_plans_rec.plan_status_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.plan_status_code, l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE);
684:
685: l_upd_csc_cust_plans_rec.request_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.request_id, l_ref_CSC_CUST_PLANS_rec.REQUEST_ID);
686:
687: l_upd_csc_cust_plans_rec.program_application_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_application_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID);

Line 685: l_upd_csc_cust_plans_rec.request_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.request_id, l_ref_CSC_CUST_PLANS_rec.REQUEST_ID);

681: l_upd_csc_cust_plans_rec.manual_flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.manual_flag, l_ref_CSC_CUST_PLANS_rec.MANUAL_FLAG);
682:
683: l_upd_csc_cust_plans_rec.plan_status_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.plan_status_code, l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE);
684:
685: l_upd_csc_cust_plans_rec.request_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.request_id, l_ref_CSC_CUST_PLANS_rec.REQUEST_ID);
686:
687: l_upd_csc_cust_plans_rec.program_application_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_application_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID);
688:
689: l_upd_csc_cust_plans_rec.program_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID);

Line 687: l_upd_csc_cust_plans_rec.program_application_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_application_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID);

683: l_upd_csc_cust_plans_rec.plan_status_code := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.plan_status_code, l_ref_CSC_CUST_PLANS_rec.PLAN_STATUS_CODE);
684:
685: l_upd_csc_cust_plans_rec.request_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.request_id, l_ref_CSC_CUST_PLANS_rec.REQUEST_ID);
686:
687: l_upd_csc_cust_plans_rec.program_application_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_application_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID);
688:
689: l_upd_csc_cust_plans_rec.program_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID);
690:
691: l_upd_csc_cust_plans_rec.program_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.program_update_date, l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE);

Line 689: l_upd_csc_cust_plans_rec.program_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID);

685: l_upd_csc_cust_plans_rec.request_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.request_id, l_ref_CSC_CUST_PLANS_rec.REQUEST_ID);
686:
687: l_upd_csc_cust_plans_rec.program_application_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_application_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID);
688:
689: l_upd_csc_cust_plans_rec.program_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID);
690:
691: l_upd_csc_cust_plans_rec.program_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.program_update_date, l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE);
692:
693: l_upd_csc_cust_plans_rec.last_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.last_update_date, l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE);

Line 691: l_upd_csc_cust_plans_rec.program_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.program_update_date, l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE);

687: l_upd_csc_cust_plans_rec.program_application_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_application_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_APPLICATION_ID);
688:
689: l_upd_csc_cust_plans_rec.program_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID);
690:
691: l_upd_csc_cust_plans_rec.program_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.program_update_date, l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE);
692:
693: l_upd_csc_cust_plans_rec.last_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.last_update_date, l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE);
694:
695: l_upd_csc_cust_plans_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute1, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1);

Line 693: l_upd_csc_cust_plans_rec.last_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.last_update_date, l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE);

689: l_upd_csc_cust_plans_rec.program_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_csc_cust_plans_rec.program_id, l_ref_CSC_CUST_PLANS_rec.PROGRAM_ID);
690:
691: l_upd_csc_cust_plans_rec.program_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.program_update_date, l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE);
692:
693: l_upd_csc_cust_plans_rec.last_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.last_update_date, l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE);
694:
695: l_upd_csc_cust_plans_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute1, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1);
696:
697: l_upd_csc_cust_plans_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute2, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2);

Line 695: l_upd_csc_cust_plans_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute1, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1);

691: l_upd_csc_cust_plans_rec.program_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.program_update_date, l_ref_CSC_CUST_PLANS_rec.PROGRAM_UPDATE_DATE);
692:
693: l_upd_csc_cust_plans_rec.last_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.last_update_date, l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE);
694:
695: l_upd_csc_cust_plans_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute1, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1);
696:
697: l_upd_csc_cust_plans_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute2, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2);
698:
699: l_upd_csc_cust_plans_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute3, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3);

Line 697: l_upd_csc_cust_plans_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute2, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2);

693: l_upd_csc_cust_plans_rec.last_update_date := CSC_CORE_UTILS_PVT.Get_G_Miss_date(p_csc_cust_plans_rec.last_update_date, l_ref_CSC_CUST_PLANS_rec.LAST_UPDATE_DATE);
694:
695: l_upd_csc_cust_plans_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute1, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1);
696:
697: l_upd_csc_cust_plans_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute2, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2);
698:
699: l_upd_csc_cust_plans_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute3, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3);
700:
701: l_upd_csc_cust_plans_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute4, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4);

Line 699: l_upd_csc_cust_plans_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute3, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3);

695: l_upd_csc_cust_plans_rec.attribute1 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute1, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE1);
696:
697: l_upd_csc_cust_plans_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute2, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2);
698:
699: l_upd_csc_cust_plans_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute3, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3);
700:
701: l_upd_csc_cust_plans_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute4, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4);
702:
703: l_upd_csc_cust_plans_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute5, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5);

Line 701: l_upd_csc_cust_plans_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute4, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4);

697: l_upd_csc_cust_plans_rec.attribute2 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute2, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE2);
698:
699: l_upd_csc_cust_plans_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute3, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3);
700:
701: l_upd_csc_cust_plans_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute4, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4);
702:
703: l_upd_csc_cust_plans_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute5, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5);
704:
705: l_upd_csc_cust_plans_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute6, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6);

Line 703: l_upd_csc_cust_plans_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute5, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5);

699: l_upd_csc_cust_plans_rec.attribute3 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute3, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE3);
700:
701: l_upd_csc_cust_plans_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute4, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4);
702:
703: l_upd_csc_cust_plans_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute5, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5);
704:
705: l_upd_csc_cust_plans_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute6, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6);
706:
707: l_upd_csc_cust_plans_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute7, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7);

Line 705: l_upd_csc_cust_plans_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute6, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6);

701: l_upd_csc_cust_plans_rec.attribute4 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute4, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE4);
702:
703: l_upd_csc_cust_plans_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute5, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5);
704:
705: l_upd_csc_cust_plans_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute6, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6);
706:
707: l_upd_csc_cust_plans_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute7, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7);
708:
709: l_upd_csc_cust_plans_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute8, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8);

Line 707: l_upd_csc_cust_plans_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute7, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7);

703: l_upd_csc_cust_plans_rec.attribute5 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute5, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE5);
704:
705: l_upd_csc_cust_plans_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute6, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6);
706:
707: l_upd_csc_cust_plans_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute7, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7);
708:
709: l_upd_csc_cust_plans_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute8, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8);
710:
711: l_upd_csc_cust_plans_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute9, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9);

Line 709: l_upd_csc_cust_plans_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute8, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8);

705: l_upd_csc_cust_plans_rec.attribute6 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute6, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE6);
706:
707: l_upd_csc_cust_plans_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute7, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7);
708:
709: l_upd_csc_cust_plans_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute8, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8);
710:
711: l_upd_csc_cust_plans_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute9, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9);
712:
713: l_upd_csc_cust_plans_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute10, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10);

Line 711: l_upd_csc_cust_plans_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute9, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9);

707: l_upd_csc_cust_plans_rec.attribute7 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute7, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE7);
708:
709: l_upd_csc_cust_plans_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute8, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8);
710:
711: l_upd_csc_cust_plans_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute9, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9);
712:
713: l_upd_csc_cust_plans_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute10, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10);
714:
715: l_upd_csc_cust_plans_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute11, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11);

Line 713: l_upd_csc_cust_plans_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute10, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10);

709: l_upd_csc_cust_plans_rec.attribute8 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute8, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE8);
710:
711: l_upd_csc_cust_plans_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute9, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9);
712:
713: l_upd_csc_cust_plans_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute10, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10);
714:
715: l_upd_csc_cust_plans_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute11, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11);
716:
717: l_upd_csc_cust_plans_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute12, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12);

Line 715: l_upd_csc_cust_plans_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute11, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11);

711: l_upd_csc_cust_plans_rec.attribute9 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute9, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE9);
712:
713: l_upd_csc_cust_plans_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute10, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10);
714:
715: l_upd_csc_cust_plans_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute11, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11);
716:
717: l_upd_csc_cust_plans_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute12, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12);
718:
719: l_upd_csc_cust_plans_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute13, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13);

Line 717: l_upd_csc_cust_plans_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute12, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12);

713: l_upd_csc_cust_plans_rec.attribute10 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute10, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE10);
714:
715: l_upd_csc_cust_plans_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute11, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11);
716:
717: l_upd_csc_cust_plans_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute12, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12);
718:
719: l_upd_csc_cust_plans_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute13, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13);
720:
721: l_upd_csc_cust_plans_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute14, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14);

Line 719: l_upd_csc_cust_plans_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute13, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13);

715: l_upd_csc_cust_plans_rec.attribute11 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute11, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE11);
716:
717: l_upd_csc_cust_plans_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute12, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12);
718:
719: l_upd_csc_cust_plans_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute13, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13);
720:
721: l_upd_csc_cust_plans_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute14, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14);
722:
723: l_upd_csc_cust_plans_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute15, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15);

Line 721: l_upd_csc_cust_plans_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute14, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14);

717: l_upd_csc_cust_plans_rec.attribute12 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute12, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE12);
718:
719: l_upd_csc_cust_plans_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute13, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13);
720:
721: l_upd_csc_cust_plans_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute14, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14);
722:
723: l_upd_csc_cust_plans_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute15, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15);
724:
725: l_upd_csc_cust_plans_rec.attribute_category := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute_category, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY);

Line 723: l_upd_csc_cust_plans_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute15, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15);

719: l_upd_csc_cust_plans_rec.attribute13 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute13, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE13);
720:
721: l_upd_csc_cust_plans_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute14, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14);
722:
723: l_upd_csc_cust_plans_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute15, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15);
724:
725: l_upd_csc_cust_plans_rec.attribute_category := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute_category, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY);
726:
727: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL )

Line 725: l_upd_csc_cust_plans_rec.attribute_category := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute_category, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY);

721: l_upd_csc_cust_plans_rec.attribute14 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute14, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE14);
722:
723: l_upd_csc_cust_plans_rec.attribute15 := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute15, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE15);
724:
725: l_upd_csc_cust_plans_rec.attribute_category := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_csc_cust_plans_rec.attribute_category, l_ref_CSC_CUST_PLANS_rec.ATTRIBUTE_CATEGORY);
726:
727: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL )
728: THEN
729: -- Invoke validation procedures

Line 733: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,

729: -- Invoke validation procedures
730: Validate_csc_cust_plans(
731: p_init_msg_list => FND_API.G_FALSE,
732: p_validation_level => p_validation_level,
733: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
734: P_CSC_CUST_PLANS_Rec => L_UPD_CSC_CUST_PLANS_REC,
735: x_return_status => x_return_status,
736: x_msg_count => x_msg_count,
737: x_msg_data => x_msg_data);

Line 828: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

824: p_data => x_msg_data );
825:
826: EXCEPTION
827: WHEN FND_API.G_EXC_ERROR THEN
828: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
829: P_API_NAME => L_API_NAME,
830: P_PKG_NAME => G_PKG_NAME,
831: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
832: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 832: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

828: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
829: P_API_NAME => L_API_NAME,
830: P_PKG_NAME => G_PKG_NAME,
831: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
832: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
833: X_MSG_COUNT => X_MSG_COUNT,
834: X_MSG_DATA => X_MSG_DATA,
835: X_RETURN_STATUS => X_RETURN_STATUS);
836: APP_EXCEPTION.RAISE_EXCEPTION;

Line 839: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

835: X_RETURN_STATUS => X_RETURN_STATUS);
836: APP_EXCEPTION.RAISE_EXCEPTION;
837:
838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
839: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
840: P_API_NAME => L_API_NAME,
841: P_PKG_NAME => G_PKG_NAME,
842: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
843: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 843: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

839: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
840: P_API_NAME => L_API_NAME,
841: P_PKG_NAME => G_PKG_NAME,
842: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
843: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
844: X_MSG_COUNT => X_MSG_COUNT,
845: X_MSG_DATA => X_MSG_DATA,
846: X_RETURN_STATUS => X_RETURN_STATUS);
847: APP_EXCEPTION.RAISE_EXCEPTION;

Line 850: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

846: X_RETURN_STATUS => X_RETURN_STATUS);
847: APP_EXCEPTION.RAISE_EXCEPTION;
848:
849: WHEN OTHERS THEN
850: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
851: P_API_NAME => L_API_NAME,
852: P_PKG_NAME => G_PKG_NAME,
853: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
854: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 853: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,

849: WHEN OTHERS THEN
850: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
851: P_API_NAME => L_API_NAME,
852: P_PKG_NAME => G_PKG_NAME,
853: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
854: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
855: X_MSG_COUNT => X_MSG_COUNT,
856: X_MSG_DATA => X_MSG_DATA,
857: X_RETURN_STATUS => X_RETURN_STATUS);

Line 854: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

850: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
851: P_API_NAME => L_API_NAME,
852: P_PKG_NAME => G_PKG_NAME,
853: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
854: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
855: X_MSG_COUNT => X_MSG_COUNT,
856: X_MSG_DATA => X_MSG_DATA,
857: X_RETURN_STATUS => X_RETURN_STATUS);
858: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1116: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');

1112: fetch c1 into c1rec;
1113:
1114: if ( c1%NOTFOUND ) then
1115: close c1;
1116: FND_MESSAGE.Set_Name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'API_MISSING_UPDATE_TARGET');
1117: FND_MESSAGE.Set_Token ('INFO', 'CSC_CUST_PLANS', FALSE);
1118: x_return_status := FND_API.G_RET_STS_ERROR;
1119: raise FND_API.G_EXC_ERROR;
1120: END IF;

Line 1262: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.REMOVE_PLAN,

1258: p_PLAN_ID => c1rec.PLAN_ID ,
1259: p_PARTY_ID => c1rec.PARTY_ID ,
1260: p_CUST_ACCOUNT_ID => c1rec.CUST_ACCOUNT_ID ,
1261: -- p_CUST_ACCOUNT_ORG => c1rec.CUST_ACCOUNT_ORG ,
1262: p_PLAN_STATUS_CODE => CSC_CORE_UTILS_PVT.REMOVE_PLAN,
1263: p_REQUEST_ID => c1rec.REQUEST_ID ,
1264: p_PROGRAM_APPLICATION_ID => c1rec.PROGRAM_APPLICATION_ID ,
1265: p_PROGRAM_ID => c1rec.PROGRAM_ID ,
1266: p_PROGRAM_UPDATE_DATE => c1rec.PROGRAM_UPDATE_DATE ,

Line 1303: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

1299: p_data => x_msg_data );
1300:
1301: EXCEPTION
1302: WHEN FND_API.G_EXC_ERROR THEN
1303: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1304: P_API_NAME => L_API_NAME,
1305: P_PKG_NAME => G_PKG_NAME,
1306: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1307: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 1307: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

1303: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1304: P_API_NAME => L_API_NAME,
1305: P_PKG_NAME => G_PKG_NAME,
1306: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1307: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1308: X_MSG_COUNT => X_MSG_COUNT,
1309: X_MSG_DATA => X_MSG_DATA,
1310: X_RETURN_STATUS => X_RETURN_STATUS);
1311: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1314: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

1310: X_RETURN_STATUS => X_RETURN_STATUS);
1311: APP_EXCEPTION.RAISE_EXCEPTION;
1312:
1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1314: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1315: P_API_NAME => L_API_NAME,
1316: P_PKG_NAME => G_PKG_NAME,
1317: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1318: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 1318: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

1314: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1315: P_API_NAME => L_API_NAME,
1316: P_PKG_NAME => G_PKG_NAME,
1317: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1318: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1319: X_MSG_COUNT => X_MSG_COUNT,
1320: X_MSG_DATA => X_MSG_DATA,
1321: X_RETURN_STATUS => X_RETURN_STATUS);
1322: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1325: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(

1321: X_RETURN_STATUS => X_RETURN_STATUS);
1322: APP_EXCEPTION.RAISE_EXCEPTION;
1323:
1324: WHEN OTHERS THEN
1325: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1326: P_API_NAME => L_API_NAME,
1327: P_PKG_NAME => G_PKG_NAME,
1328: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
1329: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

Line 1328: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,

1324: WHEN OTHERS THEN
1325: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1326: P_API_NAME => L_API_NAME,
1327: P_PKG_NAME => G_PKG_NAME,
1328: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
1329: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1330: X_MSG_COUNT => X_MSG_COUNT,
1331: X_MSG_DATA => X_MSG_DATA,
1332: X_RETURN_STATUS => X_RETURN_STATUS);

Line 1329: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,

1325: CSC_CORE_UTILS_PVT.HANDLE_EXCEPTIONS(
1326: P_API_NAME => L_API_NAME,
1327: P_PKG_NAME => G_PKG_NAME,
1328: P_EXCEPTION_LEVEL => CSC_CORE_UTILS_PVT.G_MSG_LVL_OTHERS,
1329: P_PACKAGE_TYPE => CSC_CORE_UTILS_PVT.G_PVT,
1330: X_MSG_COUNT => X_MSG_COUNT,
1331: X_MSG_DATA => X_MSG_DATA,
1332: X_RETURN_STATUS => X_RETURN_STATUS);
1333: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1432: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE) then

1428: -- Initialize API return status to SUCCESS
1429: x_return_status := FND_API.G_RET_STS_SUCCESS;
1430:
1431: -- validate NOT NULL column.
1432: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE) then
1433: IF(p_CUST_PLAN_ID is NULL or p_CUST_PLAN_ID = FND_API.G_MISS_NUM) then
1434: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1435: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1436: fnd_message.set_token('NULL_PARAM', 'CUST_PLAN_ID');

Line 1434: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

1430:
1431: -- validate NOT NULL column.
1432: if (p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE) then
1433: IF(p_CUST_PLAN_ID is NULL or p_CUST_PLAN_ID = FND_API.G_MISS_NUM) then
1434: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1435: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1436: fnd_message.set_token('NULL_PARAM', 'CUST_PLAN_ID');
1437: -- fnd_msg_pub.add;
1438: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1443: IF (p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

1439: END IF;
1440: end if;
1441:
1442: -- validate for duplicate plan_ids.
1443: IF (p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
1444: THEN
1445: open check_dup_id;
1446: fetch check_dup_id into l_cust_plan_id;
1447: if check_dup_id%FOUND then

Line 1448: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');

1444: THEN
1445: open check_dup_id;
1446: fetch check_dup_id into l_cust_plan_id;
1447: if check_dup_id%FOUND then
1448: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_DUPLICATE_VALUE');
1449: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1450: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'CUST_PLAN_ID');
1451: -- fnd_msg_pub.add;
1452: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1493: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

1489: x_return_status := FND_API.G_RET_STS_SUCCESS;
1490:
1491: -- validate NOT NULL column
1492: IF(p_PLAN_ID is NULL or p_plan_id = FND_API.G_MISS_NUM) then
1493: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1494: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1495: fnd_message.set_token('NULL_PARAM', 'PLAN_ID');
1496: -- fnd_msg_pub.add;
1497: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1505: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

1501: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1502: open c1;
1503: fetch c1 into l_plan_id;
1504: if c1%NOTFOUND then
1505: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1506: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1507: fnd_message.set_token('VALUE', p_plan_id);
1508: fnd_message.set_token('PARAMETER', 'PLAN_ID');
1509: -- fnd_msg_pub.add;

Line 1550: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

1546: x_return_status := FND_API.G_RET_STS_SUCCESS;
1547:
1548: -- validate NOT NULL column
1549: IF( p_PARTY_ID is NULL or p_party_id = FND_API.G_MISS_NUM ) then
1550: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1551: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1552: fnd_message.set_token('NULL_PARAM', 'PARTY_ID');
1553: -- fnd_msg_pub.add;
1554: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1562: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

1558: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1559: open c1;
1560: fetch c1 into l_party_id;
1561: if c1%NOTFOUND then
1562: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1563: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1564: fnd_message.set_token('VALUE', p_party_id);
1565: fnd_message.set_token('PARAMETER', 'PARTY_ID');
1566: -- fnd_msg_pub.add;

Line 1615: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

1611: -- Initialize API return status to SUCCESS
1612: x_return_status := FND_API.G_RET_STS_SUCCESS;
1613:
1614: if (p_cust_account_id is NULL or p_cust_account_org is NULL ) THEN
1615: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1616: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1617: if ( p_cust_account_id is NULL and p_cust_account_org is NULL ) then
1618: fnd_message.set_token('NULL_PARAM', 'P_CUST_ACCOUNT_ID'||' and '||'P_CUST_ACCOUNT_ORG' );
1619: elsif ( p_cust_account_id is NULL and p_cust_account_org is not NULL ) then

Line 1632: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

1628: if ( p_cust_account_id is not null and p_cust_account_org is not null ) then
1629: open c1;
1630: fetch c1 into l_cust_account_id, l_org_id;
1631: if c1%NOTFOUND then
1632: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1633: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1634: fnd_message.set_token('VALUE', p_cust_account_id ||', '|| p_cust_account_org);
1635: fnd_message.set_token('PARAMETER', 'CUST_ACCOUNT_ID, CUST_ACCOUNT_ORG');
1636: -- fnd_msg_pub.add;

Line 1672: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

1668: x_return_status := FND_API.G_RET_STS_SUCCESS;
1669:
1670: -- validate NOT NULL column
1671: IF( p_MANUAL_FLAG is NULL or p_MANUAL_FLAG = FND_API.G_MISS_CHAR ) then
1672: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1673: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1674: fnd_message.set_token('NULL_PARAM', 'MANUAL_FLAG');
1675: -- fnd_msg_pub.add;
1676: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1681: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

1677: END IF;
1678:
1679: if ( x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1680: if ( p_manual_flag <> 'Y' and p_manual_flag <> 'N' ) then
1681: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1682: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1683: fnd_message.set_token('VALUE', p_manual_flag);
1684: fnd_message.set_token('PARAMETER', 'P_MANUAL_FLAG');
1685: -- fnd_msg_pub.add;

Line 1728: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');

1724: x_return_status := FND_API.G_RET_STS_SUCCESS;
1725:
1726: -- validate NOT NULL column
1727: IF (p_PLAN_STATUS_CODE is NULL or p_PLAN_STATUS_CODE = FND_API.G_MISS_CHAR) then
1728: fnd_message.set_name (CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_NULL_PARAMETER');
1729: fnd_message.set_token ('API_NAME', G_PKG_NAME||'.'||l_api_name);
1730: fnd_message.set_token('NULL_PARAM', 'PLAN_STATUS_CODE');
1731: -- fnd_msg_pub.add;
1732: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1742: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');

1738: fetch group_in_lookup into l_count;
1739: close group_in_lookup;
1740:
1741: if ( l_count = 0 or l_count > 1 ) then
1742: fnd_message.set_name(CSC_CORE_UTILS_PVT.G_APP_SHORTNAME, 'CS_API_ALL_INVALID_ARGUMENT');
1743: fnd_message.set_token('API_NAME', G_PKG_NAME||'.'|| l_api_name);
1744: fnd_message.set_token('VALUE', p_plan_status_code);
1745: fnd_message.set_token('PARAMETER', 'P_STATUS_CODE');
1746: -- fnd_msg_pub.add;

Line 1849: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(

1845: raise FND_API.G_EXC_ERROR;
1846: END IF;
1847:
1848: /*
1849: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1850: p_init_msg_list => FND_API.G_TRUE,
1851: p_validation_mode => p_validation_mode,
1852: P_COLUMN_NAME => 'CREATION_DATE',
1853: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.CREATION_DATE,

Line 1861: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(

1857: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1858: raise FND_API.G_EXC_ERROR;
1859: END IF;
1860:
1861: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1862: p_init_msg_list => FND_API.G_TRUE,
1863: p_validation_mode => p_validation_mode,
1864: P_COLUMN_NAME => 'LAST_UPDATE_DATE',
1865: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.LAST_UPDATE_DATE,

Line 1873: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(

1869: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1870: raise FND_API.G_EXC_ERROR;
1871: END IF;
1872:
1873: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1874: p_init_msg_list => FND_API.G_TRUE,
1875: p_validation_mode => p_validation_mode,
1876: P_COLUMN_NAME => 'CREATED_BY',
1877: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.CREATED_BY,

Line 1885: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(

1881: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1882: raise FND_API.G_EXC_ERROR;
1883: END IF;
1884:
1885: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1886: p_init_msg_list => FND_API.G_TRUE,
1887: p_validation_mode => p_validation_mode,
1888: P_COLUMN_NAME => 'LAST_UPDATED_BY',
1889: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.LAST_UPDATED_BY,

Line 1897: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(

1893: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1894: raise FND_API.G_EXC_ERROR;
1895: END IF;
1896:
1897: CSC_CORE_UTILS_PVT.VALIDATE_NOT_NULLS(
1898: p_init_msg_list => FND_API.G_TRUE,
1899: p_validation_mode => p_validation_mode,
1900: P_COLUMN_NAME => 'OBJECT_VERSION_NUMBER',
1901: P_COLUMN_VALUE => P_CSC_CUST_PLANS_REC.OBJECT_VERSION_NUMBER,