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_PROF_COLOR_CODE_PVT dependencies on CSC_CORE_UTILS_PVT

Line 44: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

40: END Convert_Columns_to_Rec;
41:
42: PROCEDURE Create_prof_color_code(
43: P_Api_Version_Number IN NUMBER,
44: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
45: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
46: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
47: px_COLOR_CODE IN OUT NOCOPY VARCHAR2 ,
48: p_RATING_CODE IN VARCHAR2,

Line 45: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

41:
42: PROCEDURE Create_prof_color_code(
43: P_Api_Version_Number IN NUMBER,
44: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
45: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
46: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
47: px_COLOR_CODE IN OUT NOCOPY VARCHAR2 ,
48: p_RATING_CODE IN VARCHAR2,
49: p_LAST_UPDATE_DATE IN DATE,

Line 46: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

42: PROCEDURE Create_prof_color_code(
43: P_Api_Version_Number IN NUMBER,
44: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
45: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
46: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
47: px_COLOR_CODE IN OUT NOCOPY VARCHAR2 ,
48: p_RATING_CODE IN VARCHAR2,
49: p_LAST_UPDATE_DATE IN DATE,
50: p_LAST_UPDATED_BY IN NUMBER,

Line 89: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

85:
86:
87: PROCEDURE Create_prof_color_code(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
91: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
92: P_prof_color_rec IN prof_color_Rec_Type := G_MISS_prof_color_rec_type_REC,
93: px_COLOR_CODE IN OUT NOCOPY VARCHAR2,

Line 90: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

86:
87: PROCEDURE Create_prof_color_code(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
91: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
92: P_prof_color_rec IN prof_color_Rec_Type := G_MISS_prof_color_rec_type_REC,
93: px_COLOR_CODE IN OUT NOCOPY VARCHAR2,
94: X_Return_Status OUT NOCOPY VARCHAR2,

Line 91: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

87: PROCEDURE Create_prof_color_code(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
90: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
91: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
92: P_prof_color_rec IN prof_color_Rec_Type := G_MISS_prof_color_rec_type_REC,
93: px_COLOR_CODE IN OUT NOCOPY VARCHAR2,
94: X_Return_Status OUT NOCOPY VARCHAR2,
95: X_Msg_Count OUT NOCOPY NUMBER,

Line 136: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

132: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
133: THEN
134: -- Invoke validation procedures
135: Validate_prof_color_code(
136: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
137: p_validation_level => p_validation_level,
138: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
139: P_prof_color_rec_type_Rec => P_prof_color_rec,
140: x_return_status => x_return_status,

Line 138: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,

134: -- Invoke validation procedures
135: Validate_prof_color_code(
136: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
137: p_validation_level => p_validation_level,
138: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
139: P_prof_color_rec_type_Rec => P_prof_color_rec,
140: x_return_status => x_return_status,
141: x_msg_count => x_msg_count,
142: x_msg_data => x_msg_data);

Line 210: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

206:
207:
208: PROCEDURE Update_prof_color_code(
209: P_Api_Version_Number IN NUMBER,
210: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
211: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
212: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
213: p_COLOR_CODE IN VARCHAR2,
214: p_RATING_CODE IN VARCHAR2,

Line 211: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

207:
208: PROCEDURE Update_prof_color_code(
209: P_Api_Version_Number IN NUMBER,
210: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
211: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
212: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
213: p_COLOR_CODE IN VARCHAR2,
214: p_RATING_CODE IN VARCHAR2,
215: p_LAST_UPDATE_DATE IN DATE,

Line 212: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

208: PROCEDURE Update_prof_color_code(
209: P_Api_Version_Number IN NUMBER,
210: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
211: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
212: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
213: p_COLOR_CODE IN VARCHAR2,
214: p_RATING_CODE IN VARCHAR2,
215: p_LAST_UPDATE_DATE IN DATE,
216: p_LAST_UPDATED_BY IN NUMBER,

Line 254: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

250: END Update_prof_color_code;
251:
252: PROCEDURE Update_prof_color_code(
253: P_Api_Version_Number IN NUMBER,
254: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
255: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
256: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
257: P_prof_color_rec IN prof_color_Rec_Type,
258: X_Return_Status OUT NOCOPY VARCHAR2,

Line 255: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

251:
252: PROCEDURE Update_prof_color_code(
253: P_Api_Version_Number IN NUMBER,
254: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
255: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
256: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
257: P_prof_color_rec IN prof_color_Rec_Type,
258: X_Return_Status OUT NOCOPY VARCHAR2,
259: X_Msg_Count OUT NOCOPY NUMBER,

Line 256: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

252: PROCEDURE Update_prof_color_code(
253: P_Api_Version_Number IN NUMBER,
254: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
255: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
256: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
257: P_prof_color_rec IN prof_color_Rec_Type,
258: X_Return_Status OUT NOCOPY VARCHAR2,
259: X_Msg_Count OUT NOCOPY NUMBER,
260: X_Msg_Data OUT NOCOPY VARCHAR2

Line 327: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(l_api_name);

323:
324: If ( C_Get_prof_color_code%NOTFOUND) Then
325: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
326: THEN
327: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(l_api_name);
328: END IF;
329: raise FND_API.G_EXC_ERROR;
330:
331: END IF;

Line 342: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,

338: -- Invoke validation procedures
339: Validate_prof_color_code(
340: p_init_msg_list => FND_API.G_FALSE,
341: p_validation_level => p_validation_level,
342: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
343: P_prof_color_rec_type_Rec => P_prof_color_rec,
344: x_return_status => x_return_status,
345: x_msg_count => x_msg_count,
346: x_msg_data => x_msg_data);

Line 355: p_COLOR_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_prof_color_rec.COLOR_CODE,l_old_prof_color_rec.COLOR_CODE),

351: END IF;
352:
353: -- Invoke table handler(CSC_COLOR_CODES_PKG.Update_Row)
354: CSC_COLOR_CODES_PKG.Update_Row(
355: p_COLOR_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_prof_color_rec.COLOR_CODE,l_old_prof_color_rec.COLOR_CODE),
356: p_RATING_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_prof_color_rec.RATING_CODE,l_old_prof_color_rec.RATING_CODE),
357: p_LAST_UPDATE_DATE => SYSDATE,
358: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
359: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Char(p_prof_color_rec.LAST_UPDATE_LOGIN,l_old_prof_color_rec.LAST_UPDATE_LOGIN));

Line 356: p_RATING_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_prof_color_rec.RATING_CODE,l_old_prof_color_rec.RATING_CODE),

352:
353: -- Invoke table handler(CSC_COLOR_CODES_PKG.Update_Row)
354: CSC_COLOR_CODES_PKG.Update_Row(
355: p_COLOR_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_prof_color_rec.COLOR_CODE,l_old_prof_color_rec.COLOR_CODE),
356: p_RATING_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_prof_color_rec.RATING_CODE,l_old_prof_color_rec.RATING_CODE),
357: p_LAST_UPDATE_DATE => SYSDATE,
358: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
359: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Char(p_prof_color_rec.LAST_UPDATE_LOGIN,l_old_prof_color_rec.LAST_UPDATE_LOGIN));
360: --

Line 359: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Char(p_prof_color_rec.LAST_UPDATE_LOGIN,l_old_prof_color_rec.LAST_UPDATE_LOGIN));

355: p_COLOR_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_prof_color_rec.COLOR_CODE,l_old_prof_color_rec.COLOR_CODE),
356: p_RATING_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_prof_color_rec.RATING_CODE,l_old_prof_color_rec.RATING_CODE),
357: p_LAST_UPDATE_DATE => SYSDATE,
358: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
359: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Char(p_prof_color_rec.LAST_UPDATE_LOGIN,l_old_prof_color_rec.LAST_UPDATE_LOGIN));
360: --
361: -- End of API body.
362: --
363:

Line 406: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

402:
403:
404: PROCEDURE Delete_prof_color_code(
405: P_Api_Version_Number IN NUMBER,
406: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
407: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
408: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
409: P_COLOR_CODE IN VARCHAR2,
410: X_Return_Status OUT NOCOPY VARCHAR2,

Line 407: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

403:
404: PROCEDURE Delete_prof_color_code(
405: P_Api_Version_Number IN NUMBER,
406: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
407: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
408: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
409: P_COLOR_CODE IN VARCHAR2,
410: X_Return_Status OUT NOCOPY VARCHAR2,
411: X_Msg_Count OUT NOCOPY NUMBER,

Line 408: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

404: PROCEDURE Delete_prof_color_code(
405: P_Api_Version_Number IN NUMBER,
406: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
407: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
408: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
409: P_COLOR_CODE IN VARCHAR2,
410: X_Return_Status OUT NOCOPY VARCHAR2,
411: X_Msg_Count OUT NOCOPY NUMBER,
412: X_Msg_Data OUT NOCOPY VARCHAR2

Line 499: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

495:
496:
497: -- Item-level validation procedures
498: PROCEDURE Validate_COLOR_CODE (
499: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
500: P_Validation_mode IN VARCHAR2,
501: P_COLOR_CODE IN VARCHAR2,
502: X_Return_Status OUT NOCOPY VARCHAR2,
503: X_Msg_Count OUT NOCOPY NUMBER,

Line 527: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

523: THEN
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: END IF;
526:
527: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
528: THEN
529: -- Hint: Validate data
530: IF p_COLOR_CODE is not NULL and p_COLOR_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
531: -- **********************

Line 530: IF p_COLOR_CODE is not NULL and p_COLOR_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN

526:
527: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
528: THEN
529: -- Hint: Validate data
530: IF p_COLOR_CODE is not NULL and p_COLOR_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
531: -- **********************
532: -- No Validation for Color codes for now...
533: -- *********************
534: NULL;

Line 536: CSC_CORE_UTILS_PVT.mandatory_arg_error(

532: -- No Validation for Color codes for now...
533: -- *********************
534: NULL;
535: else
536: CSC_CORE_UTILS_PVT.mandatory_arg_error(
537: p_api_name => p_api_name,
538: p_argument => 'p_color_code',
539: p_argument_value => p_color_code);
540: end if;

Line 541: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

537: p_api_name => p_api_name,
538: p_argument => 'p_color_code',
539: p_argument_value => p_color_code);
540: end if;
541: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
542: THEN
543: -- Hint: Validate data
544: IF p_COLOR_CODE is not NULL and p_COLOR_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
545: -- **********************

Line 544: IF p_COLOR_CODE is not NULL and p_COLOR_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN

540: end if;
541: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
542: THEN
543: -- Hint: Validate data
544: IF p_COLOR_CODE is not NULL and p_COLOR_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
545: -- **********************
546: -- No Validation for Color codes for now...
547: -- *********************
548: NULL;

Line 550: CSC_CORE_UTILS_PVT.mandatory_arg_error(

546: -- No Validation for Color codes for now...
547: -- *********************
548: NULL;
549: else
550: CSC_CORE_UTILS_PVT.mandatory_arg_error(
551: p_api_name => p_api_name,
552: p_argument => 'p_color_code',
553: p_argument_value => p_color_code);
554: end if;

Line 568: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

564: END Validate_COLOR_CODE;
565:
566:
567: PROCEDURE Validate_RATING_CODE (
568: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
569: P_Validation_mode IN VARCHAR2,
570: P_RATING_CODE IN VARCHAR2,
571: X_Return_Status OUT NOCOPY VARCHAR2,
572: X_Msg_Count OUT NOCOPY NUMBER,

Line 603: IF(p_RATING_CODE is NULL and p_RATING_CODE = CSC_CORE_UTILS_PVT.G_MISS_CHAR)

599: -- Initialize API return status to SUCCESS
600: x_return_status := FND_API.G_RET_STS_SUCCESS;
601:
602: -- validate NOT NULL column
603: IF(p_RATING_CODE is NULL and p_RATING_CODE = CSC_CORE_UTILS_PVT.G_MISS_CHAR)
604: THEN
605: x_return_status := FND_API.G_RET_STS_ERROR;
606: CSC_CORE_UTILS_PVT.mandatory_arg_error(
607: p_api_name => p_api_name,

Line 606: CSC_CORE_UTILS_PVT.mandatory_arg_error(

602: -- validate NOT NULL column
603: IF(p_RATING_CODE is NULL and p_RATING_CODE = CSC_CORE_UTILS_PVT.G_MISS_CHAR)
604: THEN
605: x_return_status := FND_API.G_RET_STS_ERROR;
606: CSC_CORE_UTILS_PVT.mandatory_arg_error(
607: p_api_name => p_api_name,
608: p_argument => 'P_RATING_CODE',
609: p_argument_value => p_rating_code);
610: END IF;

Line 612: -- IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

608: p_argument => 'P_RATING_CODE',
609: p_argument_value => p_rating_code);
610: END IF;
611:
612: -- IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
613: --THEN
614: -- Hint: Validate data
615: IF p_RATING_CODE is not NULL and p_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
616: -- Check whethere code is defined in CSC_LOOKUPS

Line 615: IF p_RATING_CODE is not NULL and p_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN

611:
612: -- IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
613: --THEN
614: -- Hint: Validate data
615: IF p_RATING_CODE is not NULL and p_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
616: -- Check whethere code is defined in CSC_LOOKUPS
617: -- for CSC_PROF_RATINGS
618: l_lookup_code := p_rating_code;
619: open c;

Line 623: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

619: open c;
620: fetch c into l_dummy;
621: if c%notfound then
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
624: p_api_name => p_api_name,
625: p_argument_value => p_rating_code,
626: p_argument => 'p_rating_code');
627: else

Line 628: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

624: p_api_name => p_api_name,
625: p_argument_value => p_rating_code,
626: p_argument => 'p_rating_code');
627: else
628: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
629: THEN
630: open c1;
631: fetch c1 into l_dummy;
632: if c1%found then

Line 634: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(

630: open c1;
631: fetch c1 into l_dummy;
632: if c1%found then
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
635: p_api_name => p_api_name,
636: p_argument => 'p_rating_code' ,
637: p_argument_value => p_rating_code );
638: end if;

Line 656: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,

652:
653: END Validate_RATING_CODE;
654:
655: PROCEDURE Validate_prof_color_code(
656: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
657: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
658: P_Validation_mode IN VARCHAR2,
659: P_prof_color_rec_type_Rec IN prof_color_Rec_Type,
660: X_Return_Status OUT NOCOPY VARCHAR2,

Line 657: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

653: END Validate_RATING_CODE;
654:
655: PROCEDURE Validate_prof_color_code(
656: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
657: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
658: P_Validation_mode IN VARCHAR2,
659: P_prof_color_rec_type_Rec IN prof_color_Rec_Type,
660: X_Return_Status OUT NOCOPY VARCHAR2,
661: X_Msg_Count OUT NOCOPY NUMBER,

Line 673: IF (p_validation_level > CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN

669:
670: -- Initialize API return status to SUCCESS
671: x_return_status := FND_API.G_RET_STS_SUCCESS;
672:
673: IF (p_validation_level > CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN
674:
675: Validate_COLOR_CODE(
676: p_init_msg_list => FND_API.G_FALSE,
677: p_validation_mode => p_validation_mode,

Line 687: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

683: raise FND_API.G_EXC_ERROR;
684: END IF;
685:
686: Validate_RATING_CODE(
687: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
688: p_validation_mode => p_validation_mode,
689: p_RATING_CODE => P_prof_color_rec_type_Rec.RATING_CODE,
690: x_return_status => x_return_status,
691: x_msg_count => x_msg_count,