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

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

51:
52:
53: PROCEDURE Create_group_checks(
54: P_Api_Version_Number IN NUMBER,
55: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
56: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
57: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
58: P_GROUP_ID IN NUMBER ,
59: P_CHECK_ID IN NUMBER ,

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

52:
53: PROCEDURE Create_group_checks(
54: P_Api_Version_Number IN NUMBER,
55: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
56: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
57: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
58: P_GROUP_ID IN NUMBER ,
59: P_CHECK_ID IN NUMBER ,
60: P_END_DATE_ACTIVE IN DATE ,

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

53: PROCEDURE Create_group_checks(
54: P_Api_Version_Number IN NUMBER,
55: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
56: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
57: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
58: P_GROUP_ID IN NUMBER ,
59: P_CHECK_ID IN NUMBER ,
60: P_END_DATE_ACTIVE IN DATE ,
61: P_START_DATE_ACTIVE IN DATE ,

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

111:
112:
113: PROCEDURE Create_group_checks(
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
116: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
117: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
118: P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
119: -- X_Check_Sequence OUT NOCOPY NUMBER,

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

112:
113: PROCEDURE Create_group_checks(
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
116: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
117: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
118: P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
119: -- X_Check_Sequence OUT NOCOPY NUMBER,
120: X_Return_Status OUT NOCOPY VARCHAR2,

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

113: PROCEDURE Create_group_checks(
114: P_Api_Version_Number IN NUMBER,
115: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
116: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
117: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
118: P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
119: -- X_Check_Sequence OUT NOCOPY NUMBER,
120: X_Return_Status OUT NOCOPY VARCHAR2,
121: X_Msg_Count OUT NOCOPY NUMBER,

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

152: --
153: -- API body
154: --
155:
156: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
157: THEN
158:
159: -- Invoke validation procedures
160: Validate_group_checks(

Line 161: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

157: THEN
158:
159: -- Invoke validation procedures
160: Validate_group_checks(
161: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
162: p_validation_level => p_validation_level,
163: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
164: P_GROUP_CHK_Rec => P_GROUP_CHK_Rec,
165: x_return_status => x_return_status,

Line 163: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,

159: -- Invoke validation procedures
160: Validate_group_checks(
161: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
162: p_validation_level => p_validation_level,
163: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
164: P_GROUP_CHK_Rec => P_GROUP_CHK_Rec,
165: x_return_status => x_return_status,
166: x_msg_count => x_msg_count,
167: x_msg_data => x_msg_data);

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

240:
241:
242: PROCEDURE Update_group_checks(
243: P_Api_Version_Number IN NUMBER,
244: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
245: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
246: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
247: P_GROUP_ID IN NUMBER ,
248: P_CHECK_ID IN NUMBER ,

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

241:
242: PROCEDURE Update_group_checks(
243: P_Api_Version_Number IN NUMBER,
244: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
245: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
246: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
247: P_GROUP_ID IN NUMBER ,
248: P_CHECK_ID IN NUMBER ,
249: P_CHECK_SEQUENCE IN NUMBER ,

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

242: PROCEDURE Update_group_checks(
243: P_Api_Version_Number IN NUMBER,
244: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
245: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
246: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
247: P_GROUP_ID IN NUMBER ,
248: P_CHECK_ID IN NUMBER ,
249: P_CHECK_SEQUENCE IN NUMBER ,
250: P_END_DATE_ACTIVE IN DATE ,

Line 290: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,

286: X_GROUP_CHK_Rec => l_GROUP_CHK_Rec
287: );
288: Update_group_checks(
289: P_Api_Version_Number => P_Api_Version_Number,
290: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
291: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,
292: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
293: P_GROUP_CHK_Rec => l_Group_Chk_Rec,
294: X_Return_Status => x_return_status,

Line 291: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,

287: );
288: Update_group_checks(
289: P_Api_Version_Number => P_Api_Version_Number,
290: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
291: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,
292: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
293: P_GROUP_CHK_Rec => l_Group_Chk_Rec,
294: X_Return_Status => x_return_status,
295: X_Msg_Count => x_msg_count,

Line 292: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

288: Update_group_checks(
289: P_Api_Version_Number => P_Api_Version_Number,
290: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
291: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,
292: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
293: P_GROUP_CHK_Rec => l_Group_Chk_Rec,
294: X_Return_Status => x_return_status,
295: X_Msg_Count => x_msg_count,
296: X_Msg_Data => x_msg_data);

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

302:
303:
304: PROCEDURE Update_group_checks(
305: P_Api_Version_Number IN NUMBER,
306: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
307: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
308: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
309: P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
310: X_Return_Status OUT NOCOPY VARCHAR2,

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

303:
304: PROCEDURE Update_group_checks(
305: P_Api_Version_Number IN NUMBER,
306: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
307: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
308: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
309: P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
310: X_Return_Status OUT NOCOPY VARCHAR2,
311: X_Msg_Count OUT NOCOPY NUMBER,

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

304: PROCEDURE Update_group_checks(
305: P_Api_Version_Number IN NUMBER,
306: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
307: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
308: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
309: P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
310: X_Return_Status OUT NOCOPY VARCHAR2,
311: X_Msg_Count OUT NOCOPY NUMBER,
312: X_Msg_Data OUT NOCOPY VARCHAR2

Line 396: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_api_name=>l_api_name);

392:
393: If ( C_Get_group_checks%NOTFOUND) Then
394: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
395: THEN
396: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_api_name=>l_api_name);
397: --FND_MESSAGE.Set_Name('CSC', 'API_MISSING_UPDATE_TARGET');
398: --FND_MESSAGE.Set_Token ('INFO', 'CSC_PROF_GROUP_CHECKS', FALSE);
399: --FND_MSG_PUB.Add;
400: END IF;

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

400: END IF;
401: raise FND_API.G_EXC_ERROR;
402: END IF;
403:
404: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
405: THEN
406:
407: -- Invoke validation procedures
408: Validate_group_checks(

Line 409: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

405: THEN
406:
407: -- Invoke validation procedures
408: Validate_group_checks(
409: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
410: p_validation_level => p_validation_level,
411: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
412: P_GROUP_CHK_Rec => P_GROUP_CHK_rec,
413: x_return_status => x_return_status,

Line 411: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,

407: -- Invoke validation procedures
408: Validate_group_checks(
409: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
410: p_validation_level => p_validation_level,
411: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
412: P_GROUP_CHK_Rec => P_GROUP_CHK_rec,
413: x_return_status => x_return_status,
414: x_msg_count => x_msg_count,
415: x_msg_data => x_msg_data);

Line 423: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.GROUP_ID,l_old_GROUP_CHK_rec.GROUP_ID),

419: RAISE FND_API.G_EXC_ERROR;
420: END IF;
421: -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Update_Row)
422: CSC_PROF_GROUP_CHECKS_PKG.Update_Row(
423: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.GROUP_ID,l_old_GROUP_CHK_rec.GROUP_ID),
424: p_CHECK_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_ID,l_old_GROUP_CHK_rec.CHECK_ID),
425: p_CHECK_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_SEQUENCE,l_old_GROUP_CHK_rec.CHECK_SEQUENCE),
426: p_END_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.END_DATE_ACTIVE,l_old_GROUP_CHK_rec.END_DATE_ACTIVE),
427: p_START_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.START_DATE_ACTIVE,l_old_GROUP_CHK_rec.START_DATE_ACTIVE),

Line 424: p_CHECK_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_ID,l_old_GROUP_CHK_rec.CHECK_ID),

420: END IF;
421: -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Update_Row)
422: CSC_PROF_GROUP_CHECKS_PKG.Update_Row(
423: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.GROUP_ID,l_old_GROUP_CHK_rec.GROUP_ID),
424: p_CHECK_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_ID,l_old_GROUP_CHK_rec.CHECK_ID),
425: p_CHECK_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_SEQUENCE,l_old_GROUP_CHK_rec.CHECK_SEQUENCE),
426: p_END_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.END_DATE_ACTIVE,l_old_GROUP_CHK_rec.END_DATE_ACTIVE),
427: p_START_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.START_DATE_ACTIVE,l_old_GROUP_CHK_rec.START_DATE_ACTIVE),
428: p_CATEGORY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CATEGORY_CODE,l_old_GROUP_CHK_rec.CATEGORY_CODE),

Line 425: p_CHECK_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_SEQUENCE,l_old_GROUP_CHK_rec.CHECK_SEQUENCE),

421: -- Invoke table handler(CSC_PROF_GROUP_CHECKS_PKG.Update_Row)
422: CSC_PROF_GROUP_CHECKS_PKG.Update_Row(
423: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.GROUP_ID,l_old_GROUP_CHK_rec.GROUP_ID),
424: p_CHECK_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_ID,l_old_GROUP_CHK_rec.CHECK_ID),
425: p_CHECK_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_SEQUENCE,l_old_GROUP_CHK_rec.CHECK_SEQUENCE),
426: p_END_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.END_DATE_ACTIVE,l_old_GROUP_CHK_rec.END_DATE_ACTIVE),
427: p_START_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.START_DATE_ACTIVE,l_old_GROUP_CHK_rec.START_DATE_ACTIVE),
428: p_CATEGORY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CATEGORY_CODE,l_old_GROUP_CHK_rec.CATEGORY_CODE),
429: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CATEGORY_SEQUENCE,l_old_GROUP_CHK_rec.CATEGORY_SEQUENCE),

Line 426: p_END_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.END_DATE_ACTIVE,l_old_GROUP_CHK_rec.END_DATE_ACTIVE),

422: CSC_PROF_GROUP_CHECKS_PKG.Update_Row(
423: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.GROUP_ID,l_old_GROUP_CHK_rec.GROUP_ID),
424: p_CHECK_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_ID,l_old_GROUP_CHK_rec.CHECK_ID),
425: p_CHECK_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_SEQUENCE,l_old_GROUP_CHK_rec.CHECK_SEQUENCE),
426: p_END_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.END_DATE_ACTIVE,l_old_GROUP_CHK_rec.END_DATE_ACTIVE),
427: p_START_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.START_DATE_ACTIVE,l_old_GROUP_CHK_rec.START_DATE_ACTIVE),
428: p_CATEGORY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CATEGORY_CODE,l_old_GROUP_CHK_rec.CATEGORY_CODE),
429: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CATEGORY_SEQUENCE,l_old_GROUP_CHK_rec.CATEGORY_SEQUENCE),
430: p_THRESHOLD_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.THRESHOLD_FLAG,l_old_GROUP_CHK_rec.THRESHOLD_FLAG),

Line 427: p_START_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.START_DATE_ACTIVE,l_old_GROUP_CHK_rec.START_DATE_ACTIVE),

423: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.GROUP_ID,l_old_GROUP_CHK_rec.GROUP_ID),
424: p_CHECK_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_ID,l_old_GROUP_CHK_rec.CHECK_ID),
425: p_CHECK_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_SEQUENCE,l_old_GROUP_CHK_rec.CHECK_SEQUENCE),
426: p_END_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.END_DATE_ACTIVE,l_old_GROUP_CHK_rec.END_DATE_ACTIVE),
427: p_START_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.START_DATE_ACTIVE,l_old_GROUP_CHK_rec.START_DATE_ACTIVE),
428: p_CATEGORY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CATEGORY_CODE,l_old_GROUP_CHK_rec.CATEGORY_CODE),
429: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CATEGORY_SEQUENCE,l_old_GROUP_CHK_rec.CATEGORY_SEQUENCE),
430: p_THRESHOLD_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.THRESHOLD_FLAG,l_old_GROUP_CHK_rec.THRESHOLD_FLAG),
431: p_CRITICAL_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CRITICAL_FLAG,l_old_GROUP_CHK_rec.CRITICAL_FLAG),

Line 428: p_CATEGORY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CATEGORY_CODE,l_old_GROUP_CHK_rec.CATEGORY_CODE),

424: p_CHECK_ID =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_ID,l_old_GROUP_CHK_rec.CHECK_ID),
425: p_CHECK_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_SEQUENCE,l_old_GROUP_CHK_rec.CHECK_SEQUENCE),
426: p_END_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.END_DATE_ACTIVE,l_old_GROUP_CHK_rec.END_DATE_ACTIVE),
427: p_START_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.START_DATE_ACTIVE,l_old_GROUP_CHK_rec.START_DATE_ACTIVE),
428: p_CATEGORY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CATEGORY_CODE,l_old_GROUP_CHK_rec.CATEGORY_CODE),
429: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CATEGORY_SEQUENCE,l_old_GROUP_CHK_rec.CATEGORY_SEQUENCE),
430: p_THRESHOLD_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.THRESHOLD_FLAG,l_old_GROUP_CHK_rec.THRESHOLD_FLAG),
431: p_CRITICAL_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CRITICAL_FLAG,l_old_GROUP_CHK_rec.CRITICAL_FLAG),
432: p_SEEDED_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.SEEDED_FLAG,l_old_GROUP_CHK_rec.SEEDED_FLAG),

Line 429: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CATEGORY_SEQUENCE,l_old_GROUP_CHK_rec.CATEGORY_SEQUENCE),

425: p_CHECK_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CHECK_SEQUENCE,l_old_GROUP_CHK_rec.CHECK_SEQUENCE),
426: p_END_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.END_DATE_ACTIVE,l_old_GROUP_CHK_rec.END_DATE_ACTIVE),
427: p_START_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.START_DATE_ACTIVE,l_old_GROUP_CHK_rec.START_DATE_ACTIVE),
428: p_CATEGORY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CATEGORY_CODE,l_old_GROUP_CHK_rec.CATEGORY_CODE),
429: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CATEGORY_SEQUENCE,l_old_GROUP_CHK_rec.CATEGORY_SEQUENCE),
430: p_THRESHOLD_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.THRESHOLD_FLAG,l_old_GROUP_CHK_rec.THRESHOLD_FLAG),
431: p_CRITICAL_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CRITICAL_FLAG,l_old_GROUP_CHK_rec.CRITICAL_FLAG),
432: p_SEEDED_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.SEEDED_FLAG,l_old_GROUP_CHK_rec.SEEDED_FLAG),
433: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

Line 430: p_THRESHOLD_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.THRESHOLD_FLAG,l_old_GROUP_CHK_rec.THRESHOLD_FLAG),

426: p_END_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.END_DATE_ACTIVE,l_old_GROUP_CHK_rec.END_DATE_ACTIVE),
427: p_START_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.START_DATE_ACTIVE,l_old_GROUP_CHK_rec.START_DATE_ACTIVE),
428: p_CATEGORY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CATEGORY_CODE,l_old_GROUP_CHK_rec.CATEGORY_CODE),
429: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CATEGORY_SEQUENCE,l_old_GROUP_CHK_rec.CATEGORY_SEQUENCE),
430: p_THRESHOLD_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.THRESHOLD_FLAG,l_old_GROUP_CHK_rec.THRESHOLD_FLAG),
431: p_CRITICAL_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CRITICAL_FLAG,l_old_GROUP_CHK_rec.CRITICAL_FLAG),
432: p_SEEDED_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.SEEDED_FLAG,l_old_GROUP_CHK_rec.SEEDED_FLAG),
433: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
434: p_LAST_UPDATE_DATE => SYSDATE,

Line 431: p_CRITICAL_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CRITICAL_FLAG,l_old_GROUP_CHK_rec.CRITICAL_FLAG),

427: p_START_DATE_ACTIVE =>csc_core_utils_pvt.Get_G_Miss_Date(p_GROUP_CHK_rec.START_DATE_ACTIVE,l_old_GROUP_CHK_rec.START_DATE_ACTIVE),
428: p_CATEGORY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CATEGORY_CODE,l_old_GROUP_CHK_rec.CATEGORY_CODE),
429: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CATEGORY_SEQUENCE,l_old_GROUP_CHK_rec.CATEGORY_SEQUENCE),
430: p_THRESHOLD_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.THRESHOLD_FLAG,l_old_GROUP_CHK_rec.THRESHOLD_FLAG),
431: p_CRITICAL_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CRITICAL_FLAG,l_old_GROUP_CHK_rec.CRITICAL_FLAG),
432: p_SEEDED_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.SEEDED_FLAG,l_old_GROUP_CHK_rec.SEEDED_FLAG),
433: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
434: p_LAST_UPDATE_DATE => SYSDATE,
435: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);

Line 432: p_SEEDED_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.SEEDED_FLAG,l_old_GROUP_CHK_rec.SEEDED_FLAG),

428: p_CATEGORY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CATEGORY_CODE,l_old_GROUP_CHK_rec.CATEGORY_CODE),
429: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_num(p_GROUP_CHK_rec.CATEGORY_SEQUENCE,l_old_GROUP_CHK_rec.CATEGORY_SEQUENCE),
430: p_THRESHOLD_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.THRESHOLD_FLAG,l_old_GROUP_CHK_rec.THRESHOLD_FLAG),
431: p_CRITICAL_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.CRITICAL_FLAG,l_old_GROUP_CHK_rec.CRITICAL_FLAG),
432: p_SEEDED_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_GROUP_CHK_rec.SEEDED_FLAG,l_old_GROUP_CHK_rec.SEEDED_FLAG),
433: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
434: p_LAST_UPDATE_DATE => SYSDATE,
435: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID);
436:

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

481:
482:
483: PROCEDURE Delete_group_checks(
484: P_Api_Version_Number IN NUMBER,
485: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
486: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
487: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
488: P_GROUP_ID IN NUMBER,
489: P_CHECK_ID IN NUMBER,

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

482:
483: PROCEDURE Delete_group_checks(
484: P_Api_Version_Number IN NUMBER,
485: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
486: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
487: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
488: P_GROUP_ID IN NUMBER,
489: P_CHECK_ID IN NUMBER,
490: P_CHECK_SEQUENCE IN NUMBER,

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

483: PROCEDURE Delete_group_checks(
484: P_Api_Version_Number IN NUMBER,
485: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
486: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
487: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
488: P_GROUP_ID IN NUMBER,
489: P_CHECK_ID IN NUMBER,
490: P_CHECK_SEQUENCE IN NUMBER,
491: X_Return_Status OUT NOCOPY VARCHAR2,

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

578:
579: -- Item-level validation procedures
580: PROCEDURE Validate_GROUP_ID (
581: P_Api_Name IN VARCHAR2,
582: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
583: P_Validation_mode IN VARCHAR2,
584: P_GROUP_ID IN NUMBER,
585: X_Return_Status OUT NOCOPY VARCHAR2,
586: X_Msg_Count OUT NOCOPY NUMBER,

Line 610: CSC_CORE_UTILS_PVT.mandatory_arg_error(

606: -- validate NOT NULL column
607: IF(p_GROUP_ID is NULL)
608: THEN
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: CSC_CORE_UTILS_PVT.mandatory_arg_error(
611: p_api_name => p_api_name,
612: p_argument => 'p_GROUP_ID',
613: p_argument_value => p_GROUP_ID);
614: END IF;

Line 615: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

611: p_api_name => p_api_name,
612: p_argument => 'p_GROUP_ID',
613: p_argument_value => p_GROUP_ID);
614: END IF;
615: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
616: THEN
617: -- Hint: Validate data
618: -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
619: -- verify if data is valid

Line 618: -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

614: END IF;
615: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
616: THEN
617: -- Hint: Validate data
618: -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
619: -- verify if data is valid
620: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
621: IF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
622: THEN

Line 621: IF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM

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

Line 627: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

Line 634: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

630: p_argument => p_GROUP_ID);
631: END IF;
632: Close C1;
633: END IF;
634: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
635: THEN
636: -- Hint: Validate data
637: -- IF p_GROUP_ID <> G_MISS_CHAR
638: -- verify if data is valid

Line 640: IF p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM THEN

636: -- Hint: Validate data
637: -- IF p_GROUP_ID <> G_MISS_CHAR
638: -- verify if data is valid
639: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
640: IF p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
641: Open C1;
642: Fetch C1 into l_dummy;
643: IF C1%NOTFOUND THEN
644: x_return_status := FND_API.G_RET_STS_ERROR;

Line 645: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

641: Open C1;
642: Fetch C1 into l_dummy;
643: IF C1%NOTFOUND THEN
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
646: p_api_name => p_api_name,
647: p_argument_value => p_GROUP_ID,
648: p_argument => p_GROUP_ID);
649: END IF;

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

661:
662:
663: PROCEDURE Validate_CHECK_ID (
664: P_Api_Name IN VARCHAR2,
665: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
666: P_Validation_mode IN VARCHAR2,
667: P_CHECK_ID IN NUMBER,
668: X_Return_Status OUT NOCOPY VARCHAR2,
669: X_Msg_Count OUT NOCOPY NUMBER,

Line 693: CSC_CORE_UTILS_PVT.mandatory_arg_error(

689: -- validate NOT NULL column
690: IF(p_CHECK_ID is NULL)
691: THEN
692: x_return_status := FND_API.G_RET_STS_ERROR;
693: CSC_CORE_UTILS_PVT.mandatory_arg_error(
694: p_api_name => p_api_name,
695: p_argument => 'p_CHECK_ID',
696: p_argument_value => p_CHECK_ID);
697: END IF;

Line 699: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

695: p_argument => 'p_CHECK_ID',
696: p_argument_value => p_CHECK_ID);
697: END IF;
698:
699: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
700: THEN
701: -- Hint: Validate data
702: -- IF p_CHECK_ID is not NULL and p_CHECK_ID <> G_MISS_CHAR
703: -- verify if data is valid

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

701: -- Hint: Validate data
702: -- IF p_CHECK_ID is not NULL and p_CHECK_ID <> G_MISS_CHAR
703: -- verify if data is valid
704: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
705: IF p_CHECK_ID is not NULL and p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
706: THEN
707: Open C1;
708: Fetch C1 into l_dummy;
709: IF C1%NOTFOUND THEN

Line 711: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

707: Open C1;
708: Fetch C1 into l_dummy;
709: IF C1%NOTFOUND THEN
710: x_return_status := FND_API.G_RET_STS_ERROR;
711: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
712: p_api_name => p_api_name,
713: p_argument_value => p_CHECK_ID,
714: p_argument => p_CHECK_ID);
715: END IF;

Line 718: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

714: p_argument => p_CHECK_ID);
715: END IF;
716: Close C1;
717: END IF;
718: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
719: THEN
720: -- Hint: Validate data
721: -- IF p_CHECK_ID <> G_MISS_CHAR
722: -- verify if data is valid

Line 724: IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM

720: -- Hint: Validate data
721: -- IF p_CHECK_ID <> G_MISS_CHAR
722: -- verify if data is valid
723: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
724: IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
725: THEN
726: Open C1;
727: Fetch C1 into l_dummy;
728: IF C1%NOTFOUND THEN

Line 730: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

726: Open C1;
727: Fetch C1 into l_dummy;
728: IF C1%NOTFOUND THEN
729: x_return_status := FND_API.G_RET_STS_ERROR;
730: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
731: p_api_name => p_api_name,
732: p_argument_value => p_CHECK_ID,
733: p_argument => p_CHECK_ID);
734: END IF;

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

746:
747:
748: PROCEDURE Validate_CHECK_SEQUENCE (
749: P_Api_Name IN VARCHAR2,
750: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
751: P_Validation_mode IN VARCHAR2,
752: P_CHECK_SEQUENCE IN NUMBER,
753: X_Return_Status OUT NOCOPY VARCHAR2,
754: X_Msg_Count OUT NOCOPY NUMBER,

Line 774: CSC_CORE_UTILS_PVT.mandatory_arg_error(

770: -- validate NOT NULL column
771: IF(p_CHECK_SEQUENCE is NULL)
772: THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: CSC_CORE_UTILS_PVT.mandatory_arg_error(
775: p_api_name => p_api_name,
776: p_argument => 'p_CHECK_SEQUENCE',
777: p_argument_value => p_CHECK_SEQUENCE);
778: END IF;

Line 780: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

776: p_argument => 'p_CHECK_SEQUENCE',
777: p_argument_value => p_CHECK_SEQUENCE);
778: END IF;
779:
780: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
781: THEN
782: -- Hint: Validate data
783: -- IF p_CHECK_SEQUENCE is not NULL and p_CHECK_SEQUENCE <> G_MISS_CHAR
784: -- verify if data is valid

Line 787: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

783: -- IF p_CHECK_SEQUENCE is not NULL and p_CHECK_SEQUENCE <> G_MISS_CHAR
784: -- verify if data is valid
785: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
786: NULL;
787: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
788: THEN
789: -- Hint: Validate data
790: -- IF p_CHECK_SEQUENCE <> G_MISS_CHAR
791: -- verify if data is valid

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

804:
805:
806: PROCEDURE Validate_CATEGORY_CODE (
807: P_Api_Name IN VARCHAR2,
808: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
809: P_Validation_mode IN VARCHAR2,
810: P_CATEGORY_CODE IN VARCHAR2,
811: X_Return_Status OUT NOCOPY VARCHAR2,
812: X_Msg_Count OUT NOCOPY NUMBER,

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

837:
838:
839: PROCEDURE Validate_CATEGORY_SEQUENCE (
840: P_Api_Name IN VARCHAR2,
841: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
842: P_Validation_mode IN VARCHAR2,
843: P_CHECK_ID IN NUMBER,
844: P_CATEGORY_SEQUENCE IN NUMBER,
845: X_Return_Status OUT NOCOPY VARCHAR2,

Line 867: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

863:
864: -- Initialize API return status to SUCCESS
865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
868: THEN
869: -- Hint: Validate data
870: -- IF p_CATEGORY_SEQUENCE is not NULL and p_CATEGORY_SEQUENCE <> G_MISS_CHAR
871: -- verify if data is valid

Line 874: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

870: -- IF p_CATEGORY_SEQUENCE is not NULL and p_CATEGORY_SEQUENCE <> G_MISS_CHAR
871: -- verify if data is valid
872: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
873: NULL;
874: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
875: THEN
876: -- Hint: Validate data
877: -- IF p_CATEGORY_SEQUENCE <> G_MISS_CHAR
878: -- verify if data is valid

Line 880: IF p_CATEGORY_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN

876: -- Hint: Validate data
877: -- IF p_CATEGORY_SEQUENCE <> G_MISS_CHAR
878: -- verify if data is valid
879: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
880: IF p_CATEGORY_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
881: Open C1;
882: Fetch C1 into l_dummy;
883: IF C1%FOUND THEN
884: x_return_status := FND_API.G_RET_STS_ERROR;

Line 885: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(

881: Open C1;
882: Fetch C1 into l_dummy;
883: IF C1%FOUND THEN
884: x_return_status := FND_API.G_RET_STS_ERROR;
885: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
886: p_api_name => p_api_name,
887: p_argument => 'p_CATEGORY_SEQUENCE' ,
888: p_argument_value => p_CATEGORY_SEQUENCE);
889:

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

902:
903:
904: PROCEDURE Validate_THRESHOLD_FLAG (
905: P_Api_Name IN VARCHAR2,
906: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
907: P_Validation_mode IN VARCHAR2,
908: P_THRESHOLD_FLAG IN VARCHAR2,
909: X_Return_Status OUT NOCOPY VARCHAR2,
910: X_Msg_Count OUT NOCOPY NUMBER,

Line 927: (p_THRESHOLD_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)

923: -- Initialize API return status to SUCCESS
924: x_return_status := FND_API.G_RET_STS_SUCCESS;
925:
926: IF (p_THRESHOLD_FLAG IS NOT NULL) AND
927: (p_THRESHOLD_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
928: THEN
929: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
930: p_effective_date => trunc(sysdate),
931: p_lookup_type => 'YES_NO',

Line 929: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(

925:
926: IF (p_THRESHOLD_FLAG IS NOT NULL) AND
927: (p_THRESHOLD_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
928: THEN
929: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
930: p_effective_date => trunc(sysdate),
931: p_lookup_type => 'YES_NO',
932: p_lookup_code => p_THRESHOLD_FLAG ) <> FND_API.G_RET_STS_SUCCESS
933: THEN

Line 935: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

931: p_lookup_type => 'YES_NO',
932: p_lookup_code => p_THRESHOLD_FLAG ) <> FND_API.G_RET_STS_SUCCESS
933: THEN
934: x_return_status := FND_API.G_RET_STS_ERROR;
935: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
936: p_api_name => p_api_name,
937: p_argument_value => p_THRESHOLD_FLAG,
938: p_argument => 'p_THRESHOLD_FLAG');
939: END IF;

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

948: END Validate_THRESHOLD_FLAG;
949:
950:
951: PROCEDURE Validate_group_checks(
952: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
953: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
954: P_Validation_mode IN VARCHAR2,
955: P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
956: X_Return_Status OUT NOCOPY VARCHAR2,

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

949:
950:
951: PROCEDURE Validate_group_checks(
952: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
953: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
954: P_Validation_mode IN VARCHAR2,
955: P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
956: X_Return_Status OUT NOCOPY VARCHAR2,
957: X_Msg_Count OUT NOCOPY NUMBER,

Line 969: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

965: -- Initialize API return status to SUCCESS
966: x_return_status := FND_API.G_RET_STS_SUCCESS;
967: Validate_GROUP_ID(
968: p_api_name => p_api_name,
969: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
970: p_validation_mode => p_validation_mode,
971: p_GROUP_ID => P_GROUP_CHK_REC.GROUP_ID,
972: x_return_status => x_return_status,
973: x_msg_count => x_msg_count,

Line 981: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

977: END IF;
978: /*
979: Validate_CHECK_ID(
980: p_api_name => p_api_name,
981: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
982: p_validation_mode => p_validation_mode,
983: p_CHECK_ID => P_GROUP_CHK_Rec.CHECK_ID,
984: x_return_status => x_return_status,
985: x_msg_count => x_msg_count,

Line 994: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

990: */
991:
992: Validate_CHECK_SEQUENCE(
993: p_api_name => p_api_name,
994: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
995: p_validation_mode => p_validation_mode,
996: -- p_CHECK_ID => P_GROUP_CHK_Rec.CHECK_ID,
997: p_CHECK_SEQUENCE => P_GROUP_CHK_Rec.CHECK_SEQUENCE,
998: x_return_status => x_return_status,

Line 1005: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(

1001: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1002: raise FND_API.G_EXC_ERROR;
1003: END IF;
1004:
1005: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(
1006: p_api_name =>'CSC_PROF_GROUP_CHECKS_PVT.VALIDATE_SEEDED_FLAG',
1007: p_seeded_flag => P_GROUP_CHK_Rec.seeded_flag,
1008: x_return_status => x_return_status );
1009:

Line 1016: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1012: END IF;
1013: /*
1014: Validate_CATEGORY_CODE(
1015: p_api_name => p_api_name,
1016: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1017: p_validation_mode => p_validation_mode,
1018: p_CATEGORY_CODE => P_GROUP_CHK_Rec.CATEGORY_CODE,
1019: x_return_status => x_return_status,
1020: x_msg_count => x_msg_count,

Line 1026: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(

1022: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1023: raise FND_API.G_EXC_ERROR;
1024: END IF;
1025:
1026: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(
1027: p_api_name => p_Api_name,
1028: p_start_date => P_GROUP_CHK_Rec.start_date_active,
1029: p_end_date => P_GROUP_CHK_Rec.end_date_active,
1030: x_return_status => x_return_status );

Line 1037: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1033: END IF;
1034:
1035: Validate_CATEGORY_SEQUENCE(
1036: p_api_name => p_api_name,
1037: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1038: p_validation_mode => p_validation_mode,
1039: p_CATEGORY_SEQUENCE => P_GROUP_CHK_Rec.CATEGORY_SEQUENCE,
1040: x_return_status => x_return_status,
1041: x_msg_count => x_msg_count,

Line 1049: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1045: END IF;
1046:
1047: Validate_THRESHOLD_FLAG(
1048: p_api_name => p_api_name,
1049: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1050: p_validation_mode => p_validation_mode,
1051: p_THRESHOLD_FLAG => P_GROUP_CHK_Rec.THRESHOLD_FLAG,
1052: x_return_status => x_return_status,
1053: x_msg_count => x_msg_count,