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

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

54:
55:
56: PROCEDURE Create_check_ratings(
57: P_Api_Version_Number IN NUMBER,
58: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
59: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
60: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
61: px_CHECK_RATING_ID IN OUT NOCOPY NUMBER,
62: p_CHECK_ID IN NUMBER ,

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

55:
56: PROCEDURE Create_check_ratings(
57: P_Api_Version_Number IN NUMBER,
58: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
59: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
60: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
61: px_CHECK_RATING_ID IN OUT NOCOPY NUMBER,
62: p_CHECK_ID IN NUMBER ,
63: p_CHECK_RATING_GRADE IN VARCHAR2,

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

56: PROCEDURE Create_check_ratings(
57: P_Api_Version_Number IN NUMBER,
58: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
59: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
60: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
61: px_CHECK_RATING_ID IN OUT NOCOPY NUMBER,
62: p_CHECK_ID IN NUMBER ,
63: p_CHECK_RATING_GRADE IN VARCHAR2,
64: p_RATING_COLOR_ID IN NUMBER DEFAULT NULL,

Line 103: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,

99: );
100:
101: Create_check_ratings(
102: P_Api_Version_Number => 1.0,
103: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
104: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,
105: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
106: px_Check_Rating_id => px_check_rating_id,
107: P_CHK_RATING_Rec => l_CHK_RATING_Rec ,

Line 104: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,

100:
101: Create_check_ratings(
102: P_Api_Version_Number => 1.0,
103: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
104: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,
105: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
106: px_Check_Rating_id => px_check_rating_id,
107: P_CHK_RATING_Rec => l_CHK_RATING_Rec ,
108: X_Return_Status => x_return_status,

Line 105: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

101: Create_check_ratings(
102: P_Api_Version_Number => 1.0,
103: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
104: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,
105: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
106: px_Check_Rating_id => px_check_rating_id,
107: P_CHK_RATING_Rec => l_CHK_RATING_Rec ,
108: X_Return_Status => x_return_status,
109: X_Msg_Count => x_msg_count,

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

114: END Create_check_ratings;
115:
116: PROCEDURE Create_check_ratings(
117: P_Api_Version_Number IN NUMBER,
118: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
119: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
120: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
121: px_Check_Rating_ID IN OUT NOCOPY NUMBER,
122: P_CHK_RATING_Rec IN CHK_RATING_Rec_Type := G_MISS_CHK_RATING_Rec,

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

115:
116: PROCEDURE Create_check_ratings(
117: P_Api_Version_Number IN NUMBER,
118: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
119: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
120: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
121: px_Check_Rating_ID IN OUT NOCOPY NUMBER,
122: P_CHK_RATING_Rec IN CHK_RATING_Rec_Type := G_MISS_CHK_RATING_Rec,
123: X_Return_Status OUT NOCOPY VARCHAR2,

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

116: PROCEDURE Create_check_ratings(
117: P_Api_Version_Number IN NUMBER,
118: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
119: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
120: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
121: px_Check_Rating_ID IN OUT NOCOPY NUMBER,
122: P_CHK_RATING_Rec IN CHK_RATING_Rec_Type := G_MISS_CHK_RATING_Rec,
123: X_Return_Status OUT NOCOPY VARCHAR2,
124: X_Msg_Count OUT NOCOPY NUMBER,

Line 159: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)

155: --
156: -- API body
157: --
158:
159: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
160: THEN
161:
162: -- Invoke validation procedures
163: Validate_check_ratings(

Line 164: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

160: THEN
161:
162: -- Invoke validation procedures
163: Validate_check_ratings(
164: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
165: p_validation_level => p_validation_level,
166: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
167: p_CHK_RATING_rec => p_chk_rating_Rec,
168: x_return_status => x_return_status,

Line 166: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,

162: -- Invoke validation procedures
163: Validate_check_ratings(
164: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
165: p_validation_level => p_validation_level,
166: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
167: p_CHK_RATING_rec => p_chk_rating_Rec,
168: x_return_status => x_return_status,
169: x_msg_count => x_msg_count,
170: x_msg_data => x_msg_data);

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

243:
244:
245: PROCEDURE Update_check_ratings(
246: P_Api_Version_Number IN NUMBER,
247: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
248: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
249: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
250: p_CHECK_RATING_ID IN NUMBER,
251: p_CHECK_ID IN NUMBER,

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

244:
245: PROCEDURE Update_check_ratings(
246: P_Api_Version_Number IN NUMBER,
247: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
248: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
249: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
250: p_CHECK_RATING_ID IN NUMBER,
251: p_CHECK_ID IN NUMBER,
252: p_CHECK_RATING_GRADE IN VARCHAR2,

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

245: PROCEDURE Update_check_ratings(
246: P_Api_Version_Number IN NUMBER,
247: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
248: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
249: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
250: p_CHECK_RATING_ID IN NUMBER,
251: p_CHECK_ID IN NUMBER,
252: p_CHECK_RATING_GRADE IN VARCHAR2,
253: p_RATING_COLOR_ID IN NUMBER DEFAULT NULL,

Line 292: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,

288: );
289:
290: Update_check_ratings(
291: P_Api_Version_Number => 1.0,
292: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
293: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,
294: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
295: P_CHK_RATING_Rec => l_CHK_RATING_Rec ,
296: X_Return_Status => x_return_status,

Line 293: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,

289:
290: Update_check_ratings(
291: P_Api_Version_Number => 1.0,
292: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
293: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,
294: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
295: P_CHK_RATING_Rec => l_CHK_RATING_Rec ,
296: X_Return_Status => x_return_status,
297: X_Msg_Count => x_msg_count,

Line 294: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

290: Update_check_ratings(
291: P_Api_Version_Number => 1.0,
292: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
293: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,
294: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
295: P_CHK_RATING_Rec => l_CHK_RATING_Rec ,
296: X_Return_Status => x_return_status,
297: X_Msg_Count => x_msg_count,
298: X_Msg_Data => x_msg_data

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

301: END Update_check_ratings;
302:
303: PROCEDURE Update_check_ratings(
304: P_Api_Version_Number IN NUMBER,
305: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
306: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
307: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
308: P_CHK_RATING_Rec IN CHK_RATING_Rec_Type := G_MISS_CHK_RATING_Rec,
309: X_Return_Status OUT NOCOPY VARCHAR2,

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

302:
303: PROCEDURE Update_check_ratings(
304: P_Api_Version_Number IN NUMBER,
305: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
306: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
307: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
308: P_CHK_RATING_Rec IN CHK_RATING_Rec_Type := G_MISS_CHK_RATING_Rec,
309: X_Return_Status OUT NOCOPY VARCHAR2,
310: X_Msg_Count OUT NOCOPY NUMBER,

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

303: PROCEDURE Update_check_ratings(
304: P_Api_Version_Number IN NUMBER,
305: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
306: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
307: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
308: P_CHK_RATING_Rec IN CHK_RATING_Rec_Type := G_MISS_CHK_RATING_Rec,
309: X_Return_Status OUT NOCOPY VARCHAR2,
310: X_Msg_Count OUT NOCOPY NUMBER,
311: X_Msg_Data OUT NOCOPY VARCHAR2

Line 387: CSC_CORE_UTILS_PVT.Record_Is_Locked_msg(p_Api_Name=> l_api_name);

383: l_old_CHK_RATING_rec.SEEDED_FLAG;
384: If ( C_Get_check_ratings%NOTFOUND) Then
385: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
386: THEN
387: CSC_CORE_UTILS_PVT.Record_Is_Locked_msg(p_Api_Name=> l_api_name);
388: END IF;
389: raise FND_API.G_EXC_ERROR;
390: END IF;
391:

Line 392: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)

388: END IF;
389: raise FND_API.G_EXC_ERROR;
390: END IF;
391:
392: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
393: THEN
394:
395: -- Invoke validation procedures
396: Validate_check_ratings(

Line 397: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

393: THEN
394:
395: -- Invoke validation procedures
396: Validate_check_ratings(
397: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
398: p_validation_level => p_validation_level,
399: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
400: P_CHK_RATING_Rec => P_CHK_RATING_REC ,
401: x_return_status => x_return_status,

Line 399: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,

395: -- Invoke validation procedures
396: Validate_check_ratings(
397: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
398: p_validation_level => p_validation_level,
399: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
400: P_CHK_RATING_Rec => P_CHK_RATING_REC ,
401: x_return_status => x_return_status,
402: x_msg_count => x_msg_count,
403: x_msg_data => x_msg_data);

Line 412: p_CHECK_RATING_ID => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_ID,l_old_CHK_RATING_rec.CHECK_RATING_ID),

408: END IF;
409:
410: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Update_Row)
411: CSC_PROF_CHECK_RATINGS_PKG.Update_Row(
412: p_CHECK_RATING_ID => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_ID,l_old_CHK_RATING_rec.CHECK_RATING_ID),
413: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_char(p_CHK_RATING_REC.CHECK_ID,l_old_CHK_RATING_rec.CHECK_ID),
414: p_CHECK_RATING_GRADE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_GRADE,l_old_CHK_RATING_rec.CHECK_RATING_GRADE),
415: p_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RATING_CODE,l_old_CHK_RATING_rec.RATING_CODE),
416: p_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.COLOR_CODE,l_old_CHK_RATING_rec.COLOR_CODE),

Line 413: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_char(p_CHK_RATING_REC.CHECK_ID,l_old_CHK_RATING_rec.CHECK_ID),

409:
410: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Update_Row)
411: CSC_PROF_CHECK_RATINGS_PKG.Update_Row(
412: p_CHECK_RATING_ID => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_ID,l_old_CHK_RATING_rec.CHECK_RATING_ID),
413: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_char(p_CHK_RATING_REC.CHECK_ID,l_old_CHK_RATING_rec.CHECK_ID),
414: p_CHECK_RATING_GRADE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_GRADE,l_old_CHK_RATING_rec.CHECK_RATING_GRADE),
415: p_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RATING_CODE,l_old_CHK_RATING_rec.RATING_CODE),
416: p_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.COLOR_CODE,l_old_CHK_RATING_rec.COLOR_CODE),
417: p_RANGE_LOW_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_LOW_VALUE,l_old_CHK_RATING_rec.RANGE_LOW_VALUE),

Line 414: p_CHECK_RATING_GRADE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_GRADE,l_old_CHK_RATING_rec.CHECK_RATING_GRADE),

410: -- Invoke table handler(CSC_PROF_CHECK_RATINGS_PKG.Update_Row)
411: CSC_PROF_CHECK_RATINGS_PKG.Update_Row(
412: p_CHECK_RATING_ID => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_ID,l_old_CHK_RATING_rec.CHECK_RATING_ID),
413: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_char(p_CHK_RATING_REC.CHECK_ID,l_old_CHK_RATING_rec.CHECK_ID),
414: p_CHECK_RATING_GRADE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_GRADE,l_old_CHK_RATING_rec.CHECK_RATING_GRADE),
415: p_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RATING_CODE,l_old_CHK_RATING_rec.RATING_CODE),
416: p_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.COLOR_CODE,l_old_CHK_RATING_rec.COLOR_CODE),
417: p_RANGE_LOW_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_LOW_VALUE,l_old_CHK_RATING_rec.RANGE_LOW_VALUE),
418: p_RANGE_HIGH_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_HIGH_VALUE,l_old_CHK_RATING_rec.RANGE_HIGH_VALUE),

Line 415: p_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RATING_CODE,l_old_CHK_RATING_rec.RATING_CODE),

411: CSC_PROF_CHECK_RATINGS_PKG.Update_Row(
412: p_CHECK_RATING_ID => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_ID,l_old_CHK_RATING_rec.CHECK_RATING_ID),
413: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_char(p_CHK_RATING_REC.CHECK_ID,l_old_CHK_RATING_rec.CHECK_ID),
414: p_CHECK_RATING_GRADE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_GRADE,l_old_CHK_RATING_rec.CHECK_RATING_GRADE),
415: p_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RATING_CODE,l_old_CHK_RATING_rec.RATING_CODE),
416: p_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.COLOR_CODE,l_old_CHK_RATING_rec.COLOR_CODE),
417: p_RANGE_LOW_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_LOW_VALUE,l_old_CHK_RATING_rec.RANGE_LOW_VALUE),
418: p_RANGE_HIGH_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_HIGH_VALUE,l_old_CHK_RATING_rec.RANGE_HIGH_VALUE),
419: p_LAST_UPDATE_DATE => SYSDATE,

Line 416: p_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.COLOR_CODE,l_old_CHK_RATING_rec.COLOR_CODE),

412: p_CHECK_RATING_ID => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_ID,l_old_CHK_RATING_rec.CHECK_RATING_ID),
413: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_char(p_CHK_RATING_REC.CHECK_ID,l_old_CHK_RATING_rec.CHECK_ID),
414: p_CHECK_RATING_GRADE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_GRADE,l_old_CHK_RATING_rec.CHECK_RATING_GRADE),
415: p_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RATING_CODE,l_old_CHK_RATING_rec.RATING_CODE),
416: p_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.COLOR_CODE,l_old_CHK_RATING_rec.COLOR_CODE),
417: p_RANGE_LOW_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_LOW_VALUE,l_old_CHK_RATING_rec.RANGE_LOW_VALUE),
418: p_RANGE_HIGH_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_HIGH_VALUE,l_old_CHK_RATING_rec.RANGE_HIGH_VALUE),
419: p_LAST_UPDATE_DATE => SYSDATE,
420: p_LAST_UPDATED_BY => csc_core_utils_pvt.get_g_miss_num(P_CHK_RATING_rec.LAST_UPDATED_BY,l_old_CHK_RATING_rec.LAST_UPDATED_BY),

Line 417: p_RANGE_LOW_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_LOW_VALUE,l_old_CHK_RATING_rec.RANGE_LOW_VALUE),

413: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_char(p_CHK_RATING_REC.CHECK_ID,l_old_CHK_RATING_rec.CHECK_ID),
414: p_CHECK_RATING_GRADE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_GRADE,l_old_CHK_RATING_rec.CHECK_RATING_GRADE),
415: p_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RATING_CODE,l_old_CHK_RATING_rec.RATING_CODE),
416: p_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.COLOR_CODE,l_old_CHK_RATING_rec.COLOR_CODE),
417: p_RANGE_LOW_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_LOW_VALUE,l_old_CHK_RATING_rec.RANGE_LOW_VALUE),
418: p_RANGE_HIGH_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_HIGH_VALUE,l_old_CHK_RATING_rec.RANGE_HIGH_VALUE),
419: p_LAST_UPDATE_DATE => SYSDATE,
420: p_LAST_UPDATED_BY => csc_core_utils_pvt.get_g_miss_num(P_CHK_RATING_rec.LAST_UPDATED_BY,l_old_CHK_RATING_rec.LAST_UPDATED_BY),
421: p_LAST_UPDATE_LOGIN => csc_core_utils_pvt.get_g_miss_num(P_CHK_RATING_rec.LAST_UPDATE_LOGIN,l_old_CHK_RATING_rec.LAST_UPDATE_LOGIN),

Line 418: p_RANGE_HIGH_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_HIGH_VALUE,l_old_CHK_RATING_rec.RANGE_HIGH_VALUE),

414: p_CHECK_RATING_GRADE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.CHECK_RATING_GRADE,l_old_CHK_RATING_rec.CHECK_RATING_GRADE),
415: p_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RATING_CODE,l_old_CHK_RATING_rec.RATING_CODE),
416: p_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.COLOR_CODE,l_old_CHK_RATING_rec.COLOR_CODE),
417: p_RANGE_LOW_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_LOW_VALUE,l_old_CHK_RATING_rec.RANGE_LOW_VALUE),
418: p_RANGE_HIGH_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_HIGH_VALUE,l_old_CHK_RATING_rec.RANGE_HIGH_VALUE),
419: p_LAST_UPDATE_DATE => SYSDATE,
420: p_LAST_UPDATED_BY => csc_core_utils_pvt.get_g_miss_num(P_CHK_RATING_rec.LAST_UPDATED_BY,l_old_CHK_RATING_rec.LAST_UPDATED_BY),
421: p_LAST_UPDATE_LOGIN => csc_core_utils_pvt.get_g_miss_num(P_CHK_RATING_rec.LAST_UPDATE_LOGIN,l_old_CHK_RATING_rec.LAST_UPDATE_LOGIN),
422: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.SEEDED_FLAG,l_old_CHK_RATING_rec.SEEDED_FLAG) );

Line 420: p_LAST_UPDATED_BY => csc_core_utils_pvt.get_g_miss_num(P_CHK_RATING_rec.LAST_UPDATED_BY,l_old_CHK_RATING_rec.LAST_UPDATED_BY),

416: p_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.COLOR_CODE,l_old_CHK_RATING_rec.COLOR_CODE),
417: p_RANGE_LOW_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_LOW_VALUE,l_old_CHK_RATING_rec.RANGE_LOW_VALUE),
418: p_RANGE_HIGH_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_HIGH_VALUE,l_old_CHK_RATING_rec.RANGE_HIGH_VALUE),
419: p_LAST_UPDATE_DATE => SYSDATE,
420: p_LAST_UPDATED_BY => csc_core_utils_pvt.get_g_miss_num(P_CHK_RATING_rec.LAST_UPDATED_BY,l_old_CHK_RATING_rec.LAST_UPDATED_BY),
421: p_LAST_UPDATE_LOGIN => csc_core_utils_pvt.get_g_miss_num(P_CHK_RATING_rec.LAST_UPDATE_LOGIN,l_old_CHK_RATING_rec.LAST_UPDATE_LOGIN),
422: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.SEEDED_FLAG,l_old_CHK_RATING_rec.SEEDED_FLAG) );
423:
424:

Line 421: p_LAST_UPDATE_LOGIN => csc_core_utils_pvt.get_g_miss_num(P_CHK_RATING_rec.LAST_UPDATE_LOGIN,l_old_CHK_RATING_rec.LAST_UPDATE_LOGIN),

417: p_RANGE_LOW_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_LOW_VALUE,l_old_CHK_RATING_rec.RANGE_LOW_VALUE),
418: p_RANGE_HIGH_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_HIGH_VALUE,l_old_CHK_RATING_rec.RANGE_HIGH_VALUE),
419: p_LAST_UPDATE_DATE => SYSDATE,
420: p_LAST_UPDATED_BY => csc_core_utils_pvt.get_g_miss_num(P_CHK_RATING_rec.LAST_UPDATED_BY,l_old_CHK_RATING_rec.LAST_UPDATED_BY),
421: p_LAST_UPDATE_LOGIN => csc_core_utils_pvt.get_g_miss_num(P_CHK_RATING_rec.LAST_UPDATE_LOGIN,l_old_CHK_RATING_rec.LAST_UPDATE_LOGIN),
422: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.SEEDED_FLAG,l_old_CHK_RATING_rec.SEEDED_FLAG) );
423:
424:
425: --

Line 422: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.SEEDED_FLAG,l_old_CHK_RATING_rec.SEEDED_FLAG) );

418: p_RANGE_HIGH_VALUE => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.RANGE_HIGH_VALUE,l_old_CHK_RATING_rec.RANGE_HIGH_VALUE),
419: p_LAST_UPDATE_DATE => SYSDATE,
420: p_LAST_UPDATED_BY => csc_core_utils_pvt.get_g_miss_num(P_CHK_RATING_rec.LAST_UPDATED_BY,l_old_CHK_RATING_rec.LAST_UPDATED_BY),
421: p_LAST_UPDATE_LOGIN => csc_core_utils_pvt.get_g_miss_num(P_CHK_RATING_rec.LAST_UPDATE_LOGIN,l_old_CHK_RATING_rec.LAST_UPDATE_LOGIN),
422: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(P_CHK_RATING_rec.SEEDED_FLAG,l_old_CHK_RATING_rec.SEEDED_FLAG) );
423:
424:
425: --
426: -- End of API body.

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

469:
470:
471: PROCEDURE Delete_check_ratings(
472: P_Api_Version_Number IN NUMBER,
473: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
474: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
475: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
476: P_CHECK_RATING_ID IN NUMBER,
477: X_Return_Status OUT NOCOPY VARCHAR2,

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

470:
471: PROCEDURE Delete_check_ratings(
472: P_Api_Version_Number IN NUMBER,
473: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
474: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
475: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
476: P_CHECK_RATING_ID IN NUMBER,
477: X_Return_Status OUT NOCOPY VARCHAR2,
478: X_Msg_Count OUT NOCOPY NUMBER,

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

471: PROCEDURE Delete_check_ratings(
472: P_Api_Version_Number IN NUMBER,
473: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
474: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
475: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
476: P_CHECK_RATING_ID IN NUMBER,
477: X_Return_Status OUT NOCOPY VARCHAR2,
478: X_Msg_Count OUT NOCOPY NUMBER,
479: X_Msg_Data OUT NOCOPY VARCHAR2

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

559: End Delete_check_ratings;
560:
561: -- Item-level validation procedures
562: PROCEDURE Validate_CHECK_ID (
563: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
564: P_Validation_mode IN VARCHAR2,
565: P_CHECK_ID IN NUMBER,
566: X_Return_Status OUT NOCOPY VARCHAR2,
567: X_Msg_Count OUT NOCOPY NUMBER,

Line 589: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

585: -- Initialize API return status to SUCCESS
586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587:
588:
589: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
590: THEN
591: -- Hint: Validate data
592: -- IF p_CHECK_ID is not NULL and p_CHECK_ID <> G_MISS_NUM
593: -- verify if data is valid

Line 595: IF p_CHECK_ID is not NULL and p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM

591: -- Hint: Validate data
592: -- IF p_CHECK_ID is not NULL and p_CHECK_ID <> G_MISS_NUM
593: -- verify if data is valid
594: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
595: IF p_CHECK_ID is not NULL and p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
596: THEN
597: Open C1;
598: Fetch C1 into l_dummy;
599: IF C1%NOTFOUND THEN

Line 601: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

597: Open C1;
598: Fetch C1 into l_dummy;
599: IF C1%NOTFOUND THEN
600: x_return_status := FND_API.G_RET_STS_ERROR;
601: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
602: p_api_name=> p_api_name,
603: p_argument_value => p_check_id,
604: p_argument=>'P_CHECK_ID' );
605: END IF;

Line 609: CSC_CORE_UTILS_PVT.mandatory_arg_error(

605: END IF;
606: Close C1;
607: ELSE
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: CSC_CORE_UTILS_PVT.mandatory_arg_error(
610: p_api_name => p_api_name,
611: p_argument => 'P_CHECK_ID',
612: p_argument_Value => p_check_id );
613: END IF;

Line 614: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

610: p_api_name => p_api_name,
611: p_argument => 'P_CHECK_ID',
612: p_argument_Value => p_check_id );
613: END IF;
614: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
615: THEN
616: -- Hint: Validate data
617: -- IF p_CHECK_ID <> FND_API.G_MISS_NUM
618: -- verify if data is valid

Line 620: IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM

616: -- Hint: Validate data
617: -- IF p_CHECK_ID <> FND_API.G_MISS_NUM
618: -- verify if data is valid
619: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
620: IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
621: THEN
622: Open C1;
623: Fetch C1 into l_dummy;
624: IF C1%NOTFOUND THEN

Line 626: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

622: Open C1;
623: Fetch C1 into l_dummy;
624: IF C1%NOTFOUND THEN
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
627: p_api_name=> p_api_name,
628: p_argument_value => p_check_id,
629: p_argument=>'P_CHECK_ID' );
630: END IF;

Line 635: CSC_CORE_UTILS_PVT.mandatory_arg_error(

631: Close C1;
632: ELSIF p_CHECK_ID IS NULL
633: THEN
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: CSC_CORE_UTILS_PVT.mandatory_arg_error(
636: p_api_name => p_api_name,
637: p_argument => 'P_CHECK_ID',
638: p_argument_Value => p_check_id );
639: END IF;

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

648: END Validate_CHECK_ID;
649:
650:
651: PROCEDURE Validate_CHECK_RATING_GRADE (
652: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
653: P_Validation_mode IN VARCHAR2,
654: P_CHECK_RATING_GRADE IN VARCHAR2,
655: X_Return_Status OUT NOCOPY VARCHAR2,
656: X_Msg_Count OUT NOCOPY NUMBER,

Line 674: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

670: IF(p_CHECK_RATING_GRADE is NULL)
671: THEN
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: END IF;
674: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
675: THEN
676: -- Hint: Validate data
677: -- IF p_CHECK_RATING_GRADE is not NULL and p_CHECK_RATING_GRADE <> G_MISS_CHAR
678: -- verify if data is valid

Line 681: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

677: -- IF p_CHECK_RATING_GRADE is not NULL and p_CHECK_RATING_GRADE <> G_MISS_CHAR
678: -- verify if data is valid
679: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
680: NULL;
681: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
682: THEN
683: -- Hint: Validate data
684: -- IF p_CHECK_RATING_GRADE <> G_MISS_CHAR
685: -- verify if data is valid

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

695:
696:
697:
698: PROCEDURE Validate_RATING_CODE (
699: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
700: P_Validation_mode IN VARCHAR2,
701: P_RATING_CODE IN VARCHAR2,
702: X_Return_Status OUT NOCOPY VARCHAR2,
703: X_Msg_Count OUT NOCOPY NUMBER,

Line 723: CSC_CORE_UTILS_PVT.mandatory_arg_error(

719: -- validate NOT NULL column
720: IF(p_RATING_CODE is NULL)
721: THEN
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: CSC_CORE_UTILS_PVT.mandatory_arg_error(
724: p_api_name => p_api_name,
725: p_argument => 'P_RATING_CODE',
726: p_argument_Value => p_rating_code );
727: END IF;

Line 729: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

725: p_argument => 'P_RATING_CODE',
726: p_argument_Value => p_rating_code );
727: END IF;
728:
729: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
730: THEN
731: -- validate NOT NULL column
732: IF (p_RATING_CODE is NOT NULL) AND (p_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
733: THEN

Line 732: IF (p_RATING_CODE is NOT NULL) AND (p_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)

728:
729: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
730: THEN
731: -- validate NOT NULL column
732: IF (p_RATING_CODE is NOT NULL) AND (p_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
733: THEN
734: IF CSC_CORE_UTILS_PVT.csc_lookup_code_not_exists(
735: p_effective_date => trunc(sysdate),
736: p_lookup_type => 'CSC_PROF_RATINGS',

Line 734: IF CSC_CORE_UTILS_PVT.csc_lookup_code_not_exists(

730: THEN
731: -- validate NOT NULL column
732: IF (p_RATING_CODE is NOT NULL) AND (p_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
733: THEN
734: IF CSC_CORE_UTILS_PVT.csc_lookup_code_not_exists(
735: p_effective_date => trunc(sysdate),
736: p_lookup_type => 'CSC_PROF_RATINGS',
737: p_lookup_Code => p_rating_code ) <> FND_API.G_RET_STS_SUCCESS
738: THEN

Line 741: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

737: p_lookup_Code => p_rating_code ) <> FND_API.G_RET_STS_SUCCESS
738: THEN
739:
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
742: p_api_name=> p_api_name,
743: p_argument_value => p_rating_code,
744: p_argument=>'P_RATING_CODE' );
745: END IF;

Line 748: CSC_CORE_UTILS_PVT.mandatory_arg_error(

744: p_argument=>'P_RATING_CODE' );
745: END IF;
746: ELSE
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: CSC_CORE_UTILS_PVT.mandatory_arg_error(
749: p_api_name => p_api_name,
750: p_argument => 'P_RATING_CODE',
751: p_argument_Value => p_rating_code );
752: END IF;

Line 753: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

749: p_api_name => p_api_name,
750: p_argument => 'P_RATING_CODE',
751: p_argument_Value => p_rating_code );
752: END IF;
753: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
754: THEN
755:
756: IF (p_RATING_CODE is NOT NULL) AND (p_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
757: THEN

Line 756: IF (p_RATING_CODE is NOT NULL) AND (p_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)

752: END IF;
753: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
754: THEN
755:
756: IF (p_RATING_CODE is NOT NULL) AND (p_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
757: THEN
758: IF CSC_CORE_UTILS_PVT.csc_lookup_code_not_exists(
759: p_effective_date => trunc(sysdate),
760: p_lookup_type => 'CSC_PROF_RATINGS',

Line 758: IF CSC_CORE_UTILS_PVT.csc_lookup_code_not_exists(

754: THEN
755:
756: IF (p_RATING_CODE is NOT NULL) AND (p_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
757: THEN
758: IF CSC_CORE_UTILS_PVT.csc_lookup_code_not_exists(
759: p_effective_date => trunc(sysdate),
760: p_lookup_type => 'CSC_PROF_RATINGS',
761: p_lookup_Code => p_rating_code ) <> FND_API.G_RET_STS_SUCCESS
762: THEN

Line 765: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

761: p_lookup_Code => p_rating_code ) <> FND_API.G_RET_STS_SUCCESS
762: THEN
763:
764: x_return_status := FND_API.G_RET_STS_ERROR;
765: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
766: p_api_name=> p_api_name,
767: p_argument_value => p_rating_code,
768: p_argument=>'P_RATING_CODE' );
769: END IF;

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

777: );
778: END Validate_RATING_CODE;
779:
780: PROCEDURE Validate_check_ratings(
781: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
782: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
783: P_Validation_mode IN VARCHAR2,
784: p_CHK_RATING_Rec IN CHK_RATING_Rec_Type,
785: X_Return_Status OUT NOCOPY VARCHAR2,

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

778: END Validate_RATING_CODE;
779:
780: PROCEDURE Validate_check_ratings(
781: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
782: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
783: P_Validation_mode IN VARCHAR2,
784: p_CHK_RATING_Rec IN CHK_RATING_Rec_Type,
785: X_Return_Status OUT NOCOPY VARCHAR2,
786: X_Msg_Count OUT NOCOPY NUMBER,

Line 799: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

795: -- Initialize API return status to SUCCESS
796: x_return_status := FND_API.G_RET_STS_SUCCESS;
797: /*
798: Validate_CHECK_RATING_ID(
799: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
800: p_validation_mode => p_validation_mode,
801: p_CHECK_RATING_ID => l_CHECK_RATING_ID,
802: x_return_status => x_return_status,
803: x_msg_count => x_msg_count,

Line 810: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

806: raise FND_API.G_EXC_ERROR;
807: END IF;
808: */
809: Validate_CHECK_ID(
810: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
811: p_validation_mode => p_validation_mode,
812: p_CHECK_ID => P_CHK_RATING_REC.CHECK_ID,
813: x_return_status => x_return_status,
814: x_msg_count => x_msg_count,

Line 822: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

818: END IF;
819:
820: /*
821: Validate_CHECK_RATING_GRADE(
822: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
823: p_validation_mode => p_validation_mode,
824: p_CHECK_RATING_GRADE => p_CHK_RATING_REC.CHECK_RATING_GRADE,
825: x_return_status => x_return_status,
826: x_msg_count => x_msg_count,

Line 836: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

832:
833:
834:
835: Validate_RATING_CODE(
836: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
837: p_validation_mode => p_validation_mode,
838: p_RATING_CODE => p_CHK_RATING_REC.RATING_CODE,
839: x_return_status => x_return_status,
840: x_msg_count => x_msg_count,

Line 846: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(

842: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
843: raise FND_API.G_EXC_ERROR;
844: END IF;
845:
846: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(
847: p_api_name =>'CSC_CHECK_RATINGS_PVT.VALIDATE_SEEDED_FLAG',
848: p_seeded_flag => p_CHK_RATING_rec.seeded_flag,
849: x_return_status => x_return_status );
850: