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

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

72:
73:
74: PROCEDURE Create_Profile_Check(
75: P_Api_Version_Number IN NUMBER,
76: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
77: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
78: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
79: p_CHECK_NAME IN VARCHAR2 DEFAULT NULL,
80: p_CHECK_NAME_CODE IN VARCHAR2 DEFAULT NULL,

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

73:
74: PROCEDURE Create_Profile_Check(
75: P_Api_Version_Number IN NUMBER,
76: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
77: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
78: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
79: p_CHECK_NAME IN VARCHAR2 DEFAULT NULL,
80: p_CHECK_NAME_CODE IN VARCHAR2 DEFAULT NULL,
81: p_DESCRIPTION IN VARCHAR2 DEFAULT NULL,

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

74: PROCEDURE Create_Profile_Check(
75: P_Api_Version_Number IN NUMBER,
76: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
77: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
78: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
79: p_CHECK_NAME IN VARCHAR2 DEFAULT NULL,
80: p_CHECK_NAME_CODE IN VARCHAR2 DEFAULT NULL,
81: p_DESCRIPTION IN VARCHAR2 DEFAULT NULL,
82: p_START_DATE_ACTIVE IN DATE DEFAULT NULL,

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

149: END Create_Profile_Check;
150:
151: PROCEDURE Create_Profile_Check(
152: P_Api_Version_Number IN NUMBER,
153: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
154: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
155: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
156: P_Check_Rec IN Check_Rec_Type := G_MISS_CHECK_REC,
157: X_CHECK_ID OUT NOCOPY NUMBER,

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

150:
151: PROCEDURE Create_Profile_Check(
152: P_Api_Version_Number IN NUMBER,
153: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
154: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
155: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
156: P_Check_Rec IN Check_Rec_Type := G_MISS_CHECK_REC,
157: X_CHECK_ID OUT NOCOPY NUMBER,
158: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,

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

151: PROCEDURE Create_Profile_Check(
152: P_Api_Version_Number IN NUMBER,
153: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
154: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
155: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
156: P_Check_Rec IN Check_Rec_Type := G_MISS_CHECK_REC,
157: X_CHECK_ID OUT NOCOPY NUMBER,
158: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
159: X_Return_Status OUT NOCOPY VARCHAR2,

Line 201: p_Validation_Mode => CSC_CORE_UTILS_PVT.G_CREATE,

197: -- Invoke validation procedures
198: Validate_check(
199: p_init_msg_list => FND_API.G_FALSE,
200: p_Validation_Level => p_Validation_Level,
201: p_Validation_Mode => CSC_CORE_UTILS_PVT.G_CREATE,
202: p_CHECK_REC => p_CHECK_REC,
203: x_return_status => x_return_status,
204: x_msg_count => x_msg_count,
205: x_msg_data => x_msg_data);

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

283:
284:
285: PROCEDURE Update_Profile_Check(
286: P_Api_Version_Number IN NUMBER,
287: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
288: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
289: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
290: p_CHECK_ID IN NUMBER DEFAULT NULL,
291: p_CHECK_NAME IN VARCHAR2 DEFAULT NULL,

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

284:
285: PROCEDURE Update_Profile_Check(
286: P_Api_Version_Number IN NUMBER,
287: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
288: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
289: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
290: p_CHECK_ID IN NUMBER DEFAULT NULL,
291: p_CHECK_NAME IN VARCHAR2 DEFAULT NULL,
292: p_CHECK_NAME_CODE IN VARCHAR2 DEFAULT NULL,

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

285: PROCEDURE Update_Profile_Check(
286: P_Api_Version_Number IN NUMBER,
287: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
288: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
289: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
290: p_CHECK_ID IN NUMBER DEFAULT NULL,
291: p_CHECK_NAME IN VARCHAR2 DEFAULT NULL,
292: p_CHECK_NAME_CODE IN VARCHAR2 DEFAULT NULL,
293: p_DESCRIPTION IN VARCHAR2 DEFAULT NULL,

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

361:
362:
363: PROCEDURE Update_Profile_check(
364: P_Api_Version_Number IN NUMBER,
365: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
366: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
367: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
368: P_Check_Rec IN Check_Rec_Type,
369: PX_Object_Version_Number IN OUT NOCOPY NUMBER,

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

362:
363: PROCEDURE Update_Profile_check(
364: P_Api_Version_Number IN NUMBER,
365: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
366: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
367: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
368: P_Check_Rec IN Check_Rec_Type,
369: PX_Object_Version_Number IN OUT NOCOPY NUMBER,
370: X_Return_Status OUT NOCOPY VARCHAR2,

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

363: PROCEDURE Update_Profile_check(
364: P_Api_Version_Number IN NUMBER,
365: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
366: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
367: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
368: P_Check_Rec IN Check_Rec_Type,
369: PX_Object_Version_Number IN OUT NOCOPY NUMBER,
370: X_Return_Status OUT NOCOPY VARCHAR2,
371: X_Msg_Count OUT NOCOPY NUMBER,

Line 468: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_Api_Name => l_api_name);

464: If ( C_Get_check%NOTFOUND) Then
465: close C_Get_Check;
466: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
467: THEN
468: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_Api_Name => l_api_name);
469: --FND_MESSAGE.Set_Name('CSC', 'API_MISSING_UPDATE_TARGET');
470: --FND_MESSAGE.Set_Token ('INFO', 'CHECK', FALSE);
471: --FND_MSG_PUB.Add;
472: END IF;

Line 486: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,

482: -- Invoke validation procedures
483: Validate_check(
484: p_init_msg_list => FND_API.G_FALSE,
485: p_validation_level => p_validation_level,
486: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
487: P_Check_Rec => P_Check_Rec,
488: x_return_status => x_return_status,
489: x_msg_count => x_msg_count,
490: x_msg_data => x_msg_data);

Line 500: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.CHECK_ID,l_ref_Check_rec.CHECK_ID),

496:
497:
498: -- Invoke table handler(CS_PROF_CHECKS_PKG.Update_Row)
499: CSC_PROF_CHECKS_PKG.Update_Row(
500: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.CHECK_ID,l_ref_Check_rec.CHECK_ID),
501: p_CHECK_NAME => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_NAME,l_ref_Check_rec.CHECK_NAME),
502: p_CHECK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_NAME_CODE,l_ref_Check_rec.CHECK_NAME_CODE),
503: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DESCRIPTION,l_ref_Check_rec.DESCRIPTION),
504: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.START_DATE_ACTIVE,l_ref_Check_rec.START_DATE_ACTIVE),

Line 501: p_CHECK_NAME => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_NAME,l_ref_Check_rec.CHECK_NAME),

497:
498: -- Invoke table handler(CS_PROF_CHECKS_PKG.Update_Row)
499: CSC_PROF_CHECKS_PKG.Update_Row(
500: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.CHECK_ID,l_ref_Check_rec.CHECK_ID),
501: p_CHECK_NAME => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_NAME,l_ref_Check_rec.CHECK_NAME),
502: p_CHECK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_NAME_CODE,l_ref_Check_rec.CHECK_NAME_CODE),
503: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DESCRIPTION,l_ref_Check_rec.DESCRIPTION),
504: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.START_DATE_ACTIVE,l_ref_Check_rec.START_DATE_ACTIVE),
505: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.END_DATE_ACTIVE,l_ref_Check_rec.END_DATE_ACTIVE),

Line 502: p_CHECK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_NAME_CODE,l_ref_Check_rec.CHECK_NAME_CODE),

498: -- Invoke table handler(CS_PROF_CHECKS_PKG.Update_Row)
499: CSC_PROF_CHECKS_PKG.Update_Row(
500: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.CHECK_ID,l_ref_Check_rec.CHECK_ID),
501: p_CHECK_NAME => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_NAME,l_ref_Check_rec.CHECK_NAME),
502: p_CHECK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_NAME_CODE,l_ref_Check_rec.CHECK_NAME_CODE),
503: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DESCRIPTION,l_ref_Check_rec.DESCRIPTION),
504: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.START_DATE_ACTIVE,l_ref_Check_rec.START_DATE_ACTIVE),
505: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.END_DATE_ACTIVE,l_ref_Check_rec.END_DATE_ACTIVE),
506: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SEEDED_FLAG,l_ref_Check_rec.SEEDED_FLAG),

Line 503: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DESCRIPTION,l_ref_Check_rec.DESCRIPTION),

499: CSC_PROF_CHECKS_PKG.Update_Row(
500: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.CHECK_ID,l_ref_Check_rec.CHECK_ID),
501: p_CHECK_NAME => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_NAME,l_ref_Check_rec.CHECK_NAME),
502: p_CHECK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_NAME_CODE,l_ref_Check_rec.CHECK_NAME_CODE),
503: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DESCRIPTION,l_ref_Check_rec.DESCRIPTION),
504: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.START_DATE_ACTIVE,l_ref_Check_rec.START_DATE_ACTIVE),
505: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.END_DATE_ACTIVE,l_ref_Check_rec.END_DATE_ACTIVE),
506: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SEEDED_FLAG,l_ref_Check_rec.SEEDED_FLAG),
507: p_SELECT_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SELECT_TYPE,l_ref_Check_rec.SELECT_TYPE),

Line 504: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.START_DATE_ACTIVE,l_ref_Check_rec.START_DATE_ACTIVE),

500: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.CHECK_ID,l_ref_Check_rec.CHECK_ID),
501: p_CHECK_NAME => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_NAME,l_ref_Check_rec.CHECK_NAME),
502: p_CHECK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_NAME_CODE,l_ref_Check_rec.CHECK_NAME_CODE),
503: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DESCRIPTION,l_ref_Check_rec.DESCRIPTION),
504: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.START_DATE_ACTIVE,l_ref_Check_rec.START_DATE_ACTIVE),
505: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.END_DATE_ACTIVE,l_ref_Check_rec.END_DATE_ACTIVE),
506: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SEEDED_FLAG,l_ref_Check_rec.SEEDED_FLAG),
507: p_SELECT_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SELECT_TYPE,l_ref_Check_rec.SELECT_TYPE),
508: p_SELECT_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.SELECT_BLOCK_ID,l_ref_Check_rec.SELECT_BLOCK_ID),

Line 505: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.END_DATE_ACTIVE,l_ref_Check_rec.END_DATE_ACTIVE),

501: p_CHECK_NAME => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_NAME,l_ref_Check_rec.CHECK_NAME),
502: p_CHECK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_NAME_CODE,l_ref_Check_rec.CHECK_NAME_CODE),
503: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DESCRIPTION,l_ref_Check_rec.DESCRIPTION),
504: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.START_DATE_ACTIVE,l_ref_Check_rec.START_DATE_ACTIVE),
505: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.END_DATE_ACTIVE,l_ref_Check_rec.END_DATE_ACTIVE),
506: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SEEDED_FLAG,l_ref_Check_rec.SEEDED_FLAG),
507: p_SELECT_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SELECT_TYPE,l_ref_Check_rec.SELECT_TYPE),
508: p_SELECT_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.SELECT_BLOCK_ID,l_ref_Check_rec.SELECT_BLOCK_ID),
509: p_DATA_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DATA_TYPE,l_ref_Check_rec.DATA_TYPE),

Line 506: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SEEDED_FLAG,l_ref_Check_rec.SEEDED_FLAG),

502: p_CHECK_NAME_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_NAME_CODE,l_ref_Check_rec.CHECK_NAME_CODE),
503: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DESCRIPTION,l_ref_Check_rec.DESCRIPTION),
504: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.START_DATE_ACTIVE,l_ref_Check_rec.START_DATE_ACTIVE),
505: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.END_DATE_ACTIVE,l_ref_Check_rec.END_DATE_ACTIVE),
506: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SEEDED_FLAG,l_ref_Check_rec.SEEDED_FLAG),
507: p_SELECT_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SELECT_TYPE,l_ref_Check_rec.SELECT_TYPE),
508: p_SELECT_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.SELECT_BLOCK_ID,l_ref_Check_rec.SELECT_BLOCK_ID),
509: p_DATA_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DATA_TYPE,l_ref_Check_rec.DATA_TYPE),
510: p_FORMAT_MASK => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.FORMAT_MASK,l_ref_Check_rec.FORMAT_MASK),

Line 507: p_SELECT_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SELECT_TYPE,l_ref_Check_rec.SELECT_TYPE),

503: p_DESCRIPTION => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DESCRIPTION,l_ref_Check_rec.DESCRIPTION),
504: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.START_DATE_ACTIVE,l_ref_Check_rec.START_DATE_ACTIVE),
505: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.END_DATE_ACTIVE,l_ref_Check_rec.END_DATE_ACTIVE),
506: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SEEDED_FLAG,l_ref_Check_rec.SEEDED_FLAG),
507: p_SELECT_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SELECT_TYPE,l_ref_Check_rec.SELECT_TYPE),
508: p_SELECT_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.SELECT_BLOCK_ID,l_ref_Check_rec.SELECT_BLOCK_ID),
509: p_DATA_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DATA_TYPE,l_ref_Check_rec.DATA_TYPE),
510: p_FORMAT_MASK => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.FORMAT_MASK,l_ref_Check_rec.FORMAT_MASK),
511: p_THRESHOLD_GRADE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_GRADE,l_ref_Check_rec.THRESHOLD_GRADE),

Line 508: p_SELECT_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.SELECT_BLOCK_ID,l_ref_Check_rec.SELECT_BLOCK_ID),

504: p_START_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.START_DATE_ACTIVE,l_ref_Check_rec.START_DATE_ACTIVE),
505: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.END_DATE_ACTIVE,l_ref_Check_rec.END_DATE_ACTIVE),
506: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SEEDED_FLAG,l_ref_Check_rec.SEEDED_FLAG),
507: p_SELECT_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SELECT_TYPE,l_ref_Check_rec.SELECT_TYPE),
508: p_SELECT_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.SELECT_BLOCK_ID,l_ref_Check_rec.SELECT_BLOCK_ID),
509: p_DATA_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DATA_TYPE,l_ref_Check_rec.DATA_TYPE),
510: p_FORMAT_MASK => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.FORMAT_MASK,l_ref_Check_rec.FORMAT_MASK),
511: p_THRESHOLD_GRADE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_GRADE,l_ref_Check_rec.THRESHOLD_GRADE),
512: p_THRESHOLD_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_RATING_CODE,l_ref_Check_rec.THRESHOLD_RATING_CODE),

Line 509: p_DATA_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DATA_TYPE,l_ref_Check_rec.DATA_TYPE),

505: p_END_DATE_ACTIVE => csc_core_utils_pvt.get_g_miss_date(p_Check_rec.END_DATE_ACTIVE,l_ref_Check_rec.END_DATE_ACTIVE),
506: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SEEDED_FLAG,l_ref_Check_rec.SEEDED_FLAG),
507: p_SELECT_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SELECT_TYPE,l_ref_Check_rec.SELECT_TYPE),
508: p_SELECT_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.SELECT_BLOCK_ID,l_ref_Check_rec.SELECT_BLOCK_ID),
509: p_DATA_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DATA_TYPE,l_ref_Check_rec.DATA_TYPE),
510: p_FORMAT_MASK => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.FORMAT_MASK,l_ref_Check_rec.FORMAT_MASK),
511: p_THRESHOLD_GRADE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_GRADE,l_ref_Check_rec.THRESHOLD_GRADE),
512: p_THRESHOLD_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_RATING_CODE,l_ref_Check_rec.THRESHOLD_RATING_CODE),
513: p_CHECK_UPPER_LOWER_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_UPPER_LOWER_FLAG,l_ref_Check_rec.CHECK_UPPER_LOWER_FLAG),

Line 510: p_FORMAT_MASK => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.FORMAT_MASK,l_ref_Check_rec.FORMAT_MASK),

506: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SEEDED_FLAG,l_ref_Check_rec.SEEDED_FLAG),
507: p_SELECT_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SELECT_TYPE,l_ref_Check_rec.SELECT_TYPE),
508: p_SELECT_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.SELECT_BLOCK_ID,l_ref_Check_rec.SELECT_BLOCK_ID),
509: p_DATA_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DATA_TYPE,l_ref_Check_rec.DATA_TYPE),
510: p_FORMAT_MASK => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.FORMAT_MASK,l_ref_Check_rec.FORMAT_MASK),
511: p_THRESHOLD_GRADE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_GRADE,l_ref_Check_rec.THRESHOLD_GRADE),
512: p_THRESHOLD_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_RATING_CODE,l_ref_Check_rec.THRESHOLD_RATING_CODE),
513: p_CHECK_UPPER_LOWER_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_UPPER_LOWER_FLAG,l_ref_Check_rec.CHECK_UPPER_LOWER_FLAG),
514: p_THRESHOLD_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_COLOR_CODE,l_ref_Check_rec.THRESHOLD_COLOR_CODE),

Line 511: p_THRESHOLD_GRADE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_GRADE,l_ref_Check_rec.THRESHOLD_GRADE),

507: p_SELECT_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.SELECT_TYPE,l_ref_Check_rec.SELECT_TYPE),
508: p_SELECT_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.SELECT_BLOCK_ID,l_ref_Check_rec.SELECT_BLOCK_ID),
509: p_DATA_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DATA_TYPE,l_ref_Check_rec.DATA_TYPE),
510: p_FORMAT_MASK => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.FORMAT_MASK,l_ref_Check_rec.FORMAT_MASK),
511: p_THRESHOLD_GRADE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_GRADE,l_ref_Check_rec.THRESHOLD_GRADE),
512: p_THRESHOLD_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_RATING_CODE,l_ref_Check_rec.THRESHOLD_RATING_CODE),
513: p_CHECK_UPPER_LOWER_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_UPPER_LOWER_FLAG,l_ref_Check_rec.CHECK_UPPER_LOWER_FLAG),
514: p_THRESHOLD_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_COLOR_CODE,l_ref_Check_rec.THRESHOLD_COLOR_CODE),
515: p_CHECK_LEVEL => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_LEVEL,l_ref_Check_rec.CHECK_LEVEL),

Line 512: p_THRESHOLD_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_RATING_CODE,l_ref_Check_rec.THRESHOLD_RATING_CODE),

508: p_SELECT_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.SELECT_BLOCK_ID,l_ref_Check_rec.SELECT_BLOCK_ID),
509: p_DATA_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DATA_TYPE,l_ref_Check_rec.DATA_TYPE),
510: p_FORMAT_MASK => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.FORMAT_MASK,l_ref_Check_rec.FORMAT_MASK),
511: p_THRESHOLD_GRADE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_GRADE,l_ref_Check_rec.THRESHOLD_GRADE),
512: p_THRESHOLD_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_RATING_CODE,l_ref_Check_rec.THRESHOLD_RATING_CODE),
513: p_CHECK_UPPER_LOWER_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_UPPER_LOWER_FLAG,l_ref_Check_rec.CHECK_UPPER_LOWER_FLAG),
514: p_THRESHOLD_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_COLOR_CODE,l_ref_Check_rec.THRESHOLD_COLOR_CODE),
515: p_CHECK_LEVEL => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_LEVEL,l_ref_Check_rec.CHECK_LEVEL),
516: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

Line 513: p_CHECK_UPPER_LOWER_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_UPPER_LOWER_FLAG,l_ref_Check_rec.CHECK_UPPER_LOWER_FLAG),

509: p_DATA_TYPE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.DATA_TYPE,l_ref_Check_rec.DATA_TYPE),
510: p_FORMAT_MASK => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.FORMAT_MASK,l_ref_Check_rec.FORMAT_MASK),
511: p_THRESHOLD_GRADE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_GRADE,l_ref_Check_rec.THRESHOLD_GRADE),
512: p_THRESHOLD_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_RATING_CODE,l_ref_Check_rec.THRESHOLD_RATING_CODE),
513: p_CHECK_UPPER_LOWER_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_UPPER_LOWER_FLAG,l_ref_Check_rec.CHECK_UPPER_LOWER_FLAG),
514: p_THRESHOLD_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_COLOR_CODE,l_ref_Check_rec.THRESHOLD_COLOR_CODE),
515: p_CHECK_LEVEL => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_LEVEL,l_ref_Check_rec.CHECK_LEVEL),
516: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
517: p_LAST_UPDATE_DATE => SYSDATE,

Line 514: p_THRESHOLD_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_COLOR_CODE,l_ref_Check_rec.THRESHOLD_COLOR_CODE),

510: p_FORMAT_MASK => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.FORMAT_MASK,l_ref_Check_rec.FORMAT_MASK),
511: p_THRESHOLD_GRADE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_GRADE,l_ref_Check_rec.THRESHOLD_GRADE),
512: p_THRESHOLD_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_RATING_CODE,l_ref_Check_rec.THRESHOLD_RATING_CODE),
513: p_CHECK_UPPER_LOWER_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_UPPER_LOWER_FLAG,l_ref_Check_rec.CHECK_UPPER_LOWER_FLAG),
514: p_THRESHOLD_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_COLOR_CODE,l_ref_Check_rec.THRESHOLD_COLOR_CODE),
515: p_CHECK_LEVEL => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_LEVEL,l_ref_Check_rec.CHECK_LEVEL),
516: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
517: p_LAST_UPDATE_DATE => SYSDATE,
518: p_LAST_UPDATE_LOGIN => p_Check_rec.LAST_UPDATE_LOGIN,

Line 515: p_CHECK_LEVEL => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_LEVEL,l_ref_Check_rec.CHECK_LEVEL),

511: p_THRESHOLD_GRADE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_GRADE,l_ref_Check_rec.THRESHOLD_GRADE),
512: p_THRESHOLD_RATING_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_RATING_CODE,l_ref_Check_rec.THRESHOLD_RATING_CODE),
513: p_CHECK_UPPER_LOWER_FLAG => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_UPPER_LOWER_FLAG,l_ref_Check_rec.CHECK_UPPER_LOWER_FLAG),
514: p_THRESHOLD_COLOR_CODE => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.THRESHOLD_COLOR_CODE,l_ref_Check_rec.THRESHOLD_COLOR_CODE),
515: p_CHECK_LEVEL => csc_core_utils_pvt.get_g_miss_char(p_Check_rec.CHECK_LEVEL,l_ref_Check_rec.CHECK_LEVEL),
516: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
517: p_LAST_UPDATE_DATE => SYSDATE,
518: p_LAST_UPDATE_LOGIN => p_Check_rec.LAST_UPDATE_LOGIN,
519: px_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER,

Line 520: p_APPLICATION_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.APPLICATION_ID,l_ref_Check_rec.APPLICATION_ID));

516: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
517: p_LAST_UPDATE_DATE => SYSDATE,
518: p_LAST_UPDATE_LOGIN => p_Check_rec.LAST_UPDATE_LOGIN,
519: px_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER,
520: p_APPLICATION_ID => csc_core_utils_pvt.get_g_miss_num(p_Check_rec.APPLICATION_ID,l_ref_Check_rec.APPLICATION_ID));
521:
522: --
523: -- End of API body.
524: --

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

656:
657:
658: PROCEDURE Validate_CHECK_NAME (
659: p_Api_Name IN VARCHAR2,
660: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
661: P_Validation_mode IN VARCHAR2,
662: P_CHECK_NAME IN VARCHAR2,
663: P_check_id IN NUMBER,
664: X_Return_Status OUT NOCOPY VARCHAR2

Line 690: CSC_CORE_UTILS_PVT.mandatory_arg_error(

686: IF (p_CHECK_NAME is NULL)
687: THEN
688: --Mandatory argument error..
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: CSC_CORE_UTILS_PVT.mandatory_arg_error(
691: p_api_name => p_api_name,
692: p_argument => 'p_check_name',
693: p_argument_value => p_check_name);
694: END IF;

Line 701: IF (p_check_name is not NULL and p_CHECK_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)

697: THEN
698: -- IF p_CHECK_NAME is not NULL and p_CHECK_NAME <> G_MISS_CHAR
699: -- verify if data is valid
700: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
701: IF (p_check_name is not NULL and p_CHECK_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
702: THEN
703: Open C2;
704: Fetch C2 into l_dummy;
705: IF C2%FOUND THEN

Line 707: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(

703: Open C2;
704: Fetch C2 into l_dummy;
705: IF C2%FOUND THEN
706: x_return_status := FND_API.G_RET_STS_ERROR;
707: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
708: p_api_name => p_api_name,
709: p_argument => 'p_check_name' ,
710: p_argument_value => p_check_name);
711: END IF;

Line 715: CSC_CORE_UTILS_PVT.mandatory_arg_error(

711: END IF;
712: Close C2;
713: ELSE
714: x_return_status := FND_API.G_RET_STS_ERROR;
715: CSC_CORE_UTILS_PVT.mandatory_arg_error(
716: p_api_name => p_api_name,
717: p_argument => 'p_check_name',
718: p_argument_value => p_check_name);
719:

Line 727: CSC_CORE_UTILS_PVT.mandatory_arg_error(

723: -- if the check name is passed in and as NULL then
724: -- its a mandatory argument error.
725: if ( p_check_name IS NULL ) then
726: x_return_status := FND_API.G_RET_STS_ERROR;
727: CSC_CORE_UTILS_PVT.mandatory_arg_error(
728: p_api_name => p_api_name,
729: p_argument => 'p_check_name',
730: p_argument_value => p_check_name);
731: -- IF p_CHECK_NAME <> G_MISS_CHAR

Line 734: ELSIF p_CHECK_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

730: p_argument_value => p_check_name);
731: -- IF p_CHECK_NAME <> G_MISS_CHAR
732: -- verify if data is valid
733: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
734: ELSIF p_CHECK_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
735: THEN
736: Open C2;
737: Loop
738: Fetch C2 into l_dummy;

Line 741: CSC_CORE_UTILS_PVT.mandatory_arg_error(

737: Loop
738: Fetch C2 into l_dummy;
739: IF (l_dummy <> p_Check_id) THEN
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: CSC_CORE_UTILS_PVT.mandatory_arg_error(
742: p_api_name => p_api_name,
743: p_argument => 'p_check_name',
744: p_argument_value => p_check_name);
745: exit;

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

755:
756:
757: PROCEDURE Validate_CHECK_NAME_CODE (
758: P_Api_Name IN VARCHAR2,
759: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
760: P_Validation_mode IN VARCHAR2,
761: P_CHECK_NAME_CODE IN VARCHAR2,
762: P_check_id IN NUMBER,
763: X_Return_Status OUT NOCOPY VARCHAR2,

Line 792: CSC_CORE_UTILS_PVT.mandatory_arg_error(

788: IF (p_CHECK_NAME_CODE is NULL)
789: THEN
790: --Mandatory argument error..
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: CSC_CORE_UTILS_PVT.mandatory_arg_error(
793: p_api_name => p_api_name,
794: p_argument => 'p_check_name_code',
795: p_argument_value => p_check_name_code);
796: END IF;

Line 804: IF (p_CHECK_NAME_CODE is not NULL and p_CHECK_NAME_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)

800: -- Hint: Validate data
801: -- IF p_CHECK_NAME_CODE is not NULL and p_CHECK_NAME_CODE <> G_MISS_CHAR
802: -- verify if data is valid
803: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
804: IF (p_CHECK_NAME_CODE is not NULL and p_CHECK_NAME_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
805: THEN
806: Open C2;
807: Fetch C2 into l_dummy;
808: IF C2%FOUND THEN

Line 810: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(

806: Open C2;
807: Fetch C2 into l_dummy;
808: IF C2%FOUND THEN
809: x_return_status := FND_API.G_RET_STS_ERROR;
810: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
811: p_api_name => p_api_name,
812: p_argument => 'p_check_name_code' ,
813: p_argument_value => p_check_name_code);
814: END IF;

Line 818: CSC_CORE_UTILS_PVT.mandatory_arg_error(

814: END IF;
815: Close C2;
816: ELSE
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: CSC_CORE_UTILS_PVT.mandatory_arg_error(
819: p_api_name => p_api_name,
820: p_argument => 'p_check_name_code',
821: p_argument_value => p_check_name_code);
822:

Line 830: CSC_CORE_UTILS_PVT.mandatory_arg_error(

826: -- if the check name code is passed in and as NULL then
827: -- its a mandatory argument error.
828: if ( p_check_name_code IS NULL ) then
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: CSC_CORE_UTILS_PVT.mandatory_arg_error(
831: p_api_name => p_api_name,
832: p_argument => 'p_check_name_code',
833: p_argument_value => p_check_name_code);
834: -- Hint: Validate data

Line 838: ELSIF p_CHECK_NAME_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

834: -- Hint: Validate data
835: -- IF p_CHECK_NAME_CODE <> G_MISS_CHAR
836: -- verify if data is valid
837: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
838: ELSIF p_CHECK_NAME_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
839: THEN
840: Open C2;
841: Loop
842: Fetch C2 into l_dummy;

Line 845: CSC_CORE_UTILS_PVT.mandatory_arg_error(

841: Loop
842: Fetch C2 into l_dummy;
843: IF (l_dummy <> p_Check_id) THEN
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: CSC_CORE_UTILS_PVT.mandatory_arg_error(
846: p_api_name => p_api_name,
847: p_argument => 'p_check_name_code',
848: p_argument_value => p_check_name_code);
849: exit;

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

859:
860:
861: PROCEDURE Validate_START_END_DATE(
862: P_Api_Name IN VARCHAR2,
863: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
864: P_Validation_mode IN VARCHAR2,
865: P_START_DATE_ACTIVE IN DATE,
866: P_END_DATE IN DATE,
867: X_Return_Status OUT NOCOPY VARCHAR2,

Line 884: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt

880:
881: -- Initialize API return status to SUCCESS
882: x_return_status := FND_API.G_RET_STS_SUCCESS;
883:
884: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt
885: ( p_api_name => p_Api_name,
886: p_start_date => p_start_date_active,
887: p_end_date => p_end_date,
888: x_return_status => x_return_status );

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

900:
901:
902: PROCEDURE Validate_SEEDED_FLAG (
903: P_Api_Name IN VARCHAR2,
904: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
905: P_Validation_mode IN VARCHAR2,
906: P_SEEDED_FLAG IN VARCHAR2,
907: X_Return_Status OUT NOCOPY VARCHAR2,
908: X_Msg_Count OUT NOCOPY NUMBER,

Line 929: IF (( p_seeded_flag <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND ( p_seeded_flag IS NOT NULL ))

925:
926: -- Check if the seeded flag is passed in and is not null, if passed in
927: -- check if the lookup code exists in fnd lookups for this date, if not
928: -- its an invalid argument.
929: IF (( p_seeded_flag <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND ( p_seeded_flag IS NOT NULL ))
930: THEN
931: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
932: p_effective_date => trunc(sysdate),
933: p_lookup_type => 'YES_NO',

Line 931: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(

927: -- check if the lookup code exists in fnd lookups for this date, if not
928: -- its an invalid argument.
929: IF (( p_seeded_flag <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND ( p_seeded_flag IS NOT NULL ))
930: THEN
931: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
932: p_effective_date => trunc(sysdate),
933: p_lookup_type => 'YES_NO',
934: p_lookup_code => p_seeded_flag ) <> FND_API.G_RET_STS_SUCCESS
935: THEN

Line 937: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

Line 966: IF (( p_check_level <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND

962:
963: -- check if the check_level is passed in and is not
964: -- null
965:
966: IF (( p_check_level <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
967: ( p_check_level IS NOT NULL )) THEN
968: IF (p_check_level <> 'PARTY' AND p_check_level <> 'ACCOUNT'AND p_check_level <> 'CONTACT' AND p_check_level <> 'EMPLOYEE')
969: THEN
970: x_return_status := FND_API.G_RET_STS_ERROR;

Line 971: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,

967: ( p_check_level IS NOT NULL )) THEN
968: IF (p_check_level <> 'PARTY' AND p_check_level <> 'ACCOUNT'AND p_check_level <> 'CONTACT' AND p_check_level <> 'EMPLOYEE')
969: THEN
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,
972: p_argument_value => p_check_level,
973: p_argument => p_parameter_name);
974: END IF;
975: END IF;

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

978:
979:
980: PROCEDURE Validate_SELECT_TYPE (
981: p_Api_Name IN VARCHAR2,
982: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
983: P_Validation_mode IN VARCHAR2,
984: P_SELECT_TYPE IN VARCHAR2,
985: X_Return_Status OUT NOCOPY VARCHAR2,
986: X_Msg_Count OUT NOCOPY NUMBER,

Line 1005: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

1001:
1002:
1003: IF NOT p_select_type in ('B','T') THEN
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1006: p_api_name => p_api_name,
1007: p_argument => 'P_SELECT_TYPE',
1008: p_argument_value => p_select_type);
1009: END IF;

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

1019:
1020:
1021: PROCEDURE Validate_SELECT_BLOCK_ID (
1022: P_Api_Name IN VARCHAR2,
1023: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1024: P_Validation_mode IN VARCHAR2,
1025: P_SELECT_BLOCK_ID IN NUMBER,
1026: P_SELECT_TYPE IN VARCHAR2,
1027: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1056: CSC_CORE_UTILS_PVT.mandatory_arg_error(

1052: IF(p_SELECT_BLOCK_ID is NULL)
1053: THEN
1054: -- Mandatory argument error..
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056: CSC_CORE_UTILS_PVT.mandatory_arg_error(
1057: p_api_name => p_api_name,
1058: p_argument => 'p_select_block_id',
1059: p_argument_value => p_select_block_id);
1060: END IF;

Line 1062: IF (p_SELECT_BLOCK_ID IS NOT NULL) AND (p_SELECT_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM)

1058: p_argument => 'p_select_block_id',
1059: p_argument_value => p_select_block_id);
1060: END IF;
1061: ELSE
1062: IF (p_SELECT_BLOCK_ID IS NOT NULL) AND (p_SELECT_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM)
1063: THEN
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1066: p_api_name => p_api_name,

Line 1065: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

1061: ELSE
1062: IF (p_SELECT_BLOCK_ID IS NOT NULL) AND (p_SELECT_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM)
1063: THEN
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1066: p_api_name => p_api_name,
1067: p_argument_value => p_select_block_id,
1068: p_argument => 'p_select_block_id');
1069: END IF;

Line 1079: IF (p_SELECT_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM)

1075: -- IF p_SELECT_BLOCK_ID is not NULL and p_SELECT_BLOCK_ID <> G_MISS_CHAR
1076: -- verify if data is valid
1077: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1078: IF p_SELECT_TYPE = 'B' THEN
1079: IF (p_SELECT_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM)
1080: THEN
1081: Open C2;
1082: Fetch C2 into l_dummy;
1083: IF C2%NOTFOUND THEN

Line 1086: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

1082: Fetch C2 into l_dummy;
1083: IF C2%NOTFOUND THEN
1084: x_return_status := FND_API.G_RET_STS_ERROR;
1085:
1086: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1087: p_api_name => p_api_name,
1088: p_argument_value => p_select_block_id,
1089: p_argument => 'p_select_block_id');
1090:

Line 1095: CSC_CORE_UTILS_PVT.mandatory_arg_error(

1091: END IF;
1092: Close C2;
1093: ELSE
1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095: CSC_CORE_UTILS_PVT.mandatory_arg_error(
1096: p_api_name => p_api_name,
1097: p_argument => 'p_select_block_id',
1098: p_argument_value => p_select_block_id);
1099:

Line 1110: CSC_CORE_UTILS_PVT.mandatory_arg_error(

1106: -- added the outer if condition to fix the bug 1563264
1107: IF(p_SELECT_TYPE = 'B') THEN
1108: if ( p_select_block_id IS NULL ) then
1109: x_return_status := FND_API.G_RET_STS_ERROR;
1110: CSC_CORE_UTILS_PVT.mandatory_arg_error(
1111: p_api_name => p_api_name,
1112: p_argument => 'p_select_block_id',
1113: p_argument_value => p_select_block_id);
1114: -- Hint: Validate data

Line 1118: ELSIF p_SELECT_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM

1114: -- Hint: Validate data
1115: -- IF p_SELECT_BLOCK_ID <> G_MISS_NUM
1116: -- verify if data is valid
1117: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1118: ELSIF p_SELECT_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
1119: THEN
1120: Open C2;
1121: Loop
1122: Fetch C2 into l_dummy;

Line 1125: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

1121: Loop
1122: Fetch C2 into l_dummy;
1123: IF C2%NOTFOUND THEN
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1126: p_api_name => p_api_name,
1127: p_argument_value => p_select_block_id,
1128: p_argument => 'p_select_block_id');
1129: exit;

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

1146:
1147:
1148: PROCEDURE Validate_DATA_TYPE (
1149: p_Api_Name IN VARCHAR2,
1150: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1151: P_Validation_mode IN VARCHAR2,
1152: P_DATA_TYPE IN VARCHAR2,
1153: X_Return_Status OUT NOCOPY VARCHAR2,
1154: X_Msg_Count OUT NOCOPY NUMBER,

Line 1171: IF p_DATA_TYPE is not NULL and p_DATA_TYPE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

1167: -- Initialize API return status to SUCCESS
1168: x_return_status := FND_API.G_RET_STS_SUCCESS;
1169:
1170:
1171: IF p_DATA_TYPE is not NULL and p_DATA_TYPE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
1172: THEN
1173: -- Added 'BOOLEAN' in the IN CLAUSE . Bug #1231208
1174: IF NOT p_DATA_TYPE IN ('NUMBER','VARCHAR2','DATE', 'BOOLEAN') THEN
1175: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1176: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

1172: THEN
1173: -- Added 'BOOLEAN' in the IN CLAUSE . Bug #1231208
1174: IF NOT p_DATA_TYPE IN ('NUMBER','VARCHAR2','DATE', 'BOOLEAN') THEN
1175: x_return_status := FND_API.G_RET_STS_ERROR;
1176: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1177: p_api_name => p_api_name,
1178: p_argument_value => p_data_type,
1179: p_argument => 'P_DATA_TYPE');
1180:

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

1191: END Validate_DATA_TYPE;
1192:
1193: PROCEDURE Validate_THRESHOLD_GRADE (
1194: p_Api_Name IN VARCHAR2,
1195: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1196: P_Validation_mode IN VARCHAR2,
1197: P_THRESHOLD_GRADE IN VARCHAR2,
1198: X_Return_Status OUT NOCOPY VARCHAR2,
1199: X_Msg_Count OUT NOCOPY NUMBER,

Line 1220: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

1216: -- verify if data is valid
1217: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1218:
1219:
1220: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
1221: THEN
1222: -- Hint: Validate data
1223: -- IF p_THRESHOLD_GRADE is not NULL and p_THRESHOLD_GRADE <> G_MISS_CHAR
1224: -- verify if data is valid

Line 1227: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

1223: -- IF p_THRESHOLD_GRADE is not NULL and p_THRESHOLD_GRADE <> G_MISS_CHAR
1224: -- verify if data is valid
1225: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1226: NULL;
1227: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
1228: THEN
1229: -- Hint: Validate data
1230: -- IF p_THRESHOLD_GRADE <> G_MISS_CHAR
1231: -- verify if data is valid

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

1243:
1244:
1245: PROCEDURE Validate_THRESHOLD_RATING_CODE (
1246: p_Api_Name IN VARCHAR2,
1247: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1248: P_Validation_mode IN VARCHAR2,
1249: P_THRESHOLD_RATING_CODE IN VARCHAR2,
1250: X_Return_Status OUT NOCOPY VARCHAR2,
1251: X_Msg_Count OUT NOCOPY NUMBER,

Line 1270: IF (p_THRESHOLD_RATING_CODE is NOT NULL) AND (p_THRESHOLD_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)

1266: -- Hint: Validate data
1267: -- IF p_THRESHOLD_RATING_CODE is not NULL and p_THRESHOLD_RATING_CODE <> G_MISS_CHAR
1268: -- verify if data is valid
1269: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1270: IF (p_THRESHOLD_RATING_CODE is NOT NULL) AND (p_THRESHOLD_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
1271: THEN
1272: IF CSC_CORE_UTILS_PVT.csc_lookup_code_not_exists(
1273: p_effective_date => trunc(sysdate),
1274: p_lookup_type => 'CSC_PROF_RATINGS',

Line 1272: IF CSC_CORE_UTILS_PVT.csc_lookup_code_not_exists(

1268: -- verify if data is valid
1269: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1270: IF (p_THRESHOLD_RATING_CODE is NOT NULL) AND (p_THRESHOLD_RATING_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR)
1271: THEN
1272: IF CSC_CORE_UTILS_PVT.csc_lookup_code_not_exists(
1273: p_effective_date => trunc(sysdate),
1274: p_lookup_type => 'CSC_PROF_RATINGS',
1275: p_lookup_Code => p_threshold_rating_code ) <> FND_API.G_RET_STS_SUCCESS
1276: THEN

Line 1278: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

1274: p_lookup_type => 'CSC_PROF_RATINGS',
1275: p_lookup_Code => p_threshold_rating_code ) <> FND_API.G_RET_STS_SUCCESS
1276: THEN
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1279: p_api_name=> p_api_name,
1280: p_argument_value => p_threshold_rating_code,
1281: p_argument=>'P_RATING_CODE' );
1282: END IF;

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

1292:
1293:
1294: PROCEDURE Validate_UPPER_LOWER_FLAG (
1295: p_Api_Name IN VARCHAR2,
1296: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1297: P_Validation_mode IN VARCHAR2,
1298: P_CHECK_UPPER_LOWER_FLAG IN VARCHAR2,
1299: X_Return_Status OUT NOCOPY VARCHAR2,
1300: X_Msg_Count OUT NOCOPY NUMBER,

Line 1318: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

1314: x_return_status := FND_API.G_RET_STS_SUCCESS;
1315:
1316: IF p_CHECK_UPPER_LOWER_FLAG NOT IN ('U','L') THEN
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1319: p_api_name => p_api_name,
1320: p_argument_value => p_check_upper_lower_flag,
1321: p_argument => 'P_CHECK_UPPER_LOWER_FLAG');
1322: END IF;

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

1330:
1331:
1332: PROCEDURE Validate_THRESHOLD_COLOR_CODE (
1333: p_Api_Name IN VARCHAR2,
1334: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1335: P_Validation_mode IN VARCHAR2,
1336: P_THRESHOLD_COLOR_CODE IN VARCHAR2,
1337: X_Return_Status OUT NOCOPY VARCHAR2,
1338: X_Msg_Count OUT NOCOPY NUMBER,

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

1363:
1364: /*
1365: PROCEDURE Validate_CATEGORY_CODE (
1366: p_Api_Name IN VARCHAR2,
1367: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1368: P_Validation_mode IN VARCHAR2,
1369: P_CATEGORY_CODE IN VARCHAR2,
1370: X_Return_Status OUT VARCHAR2,
1371: X_Msg_Count OUT NUMBER,

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

1396: */
1397:
1398:
1399: PROCEDURE Validate_check(
1400: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1401: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1402: P_Validation_mode IN VARCHAR2,
1403: P_Check_Rec IN Check_Rec_Type,
1404: X_Return_Status OUT NOCOPY VARCHAR2,

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

1397:
1398:
1399: PROCEDURE Validate_check(
1400: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1401: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1402: P_Validation_mode IN VARCHAR2,
1403: P_Check_Rec IN Check_Rec_Type,
1404: X_Return_Status OUT NOCOPY VARCHAR2,
1405: X_Msg_Count OUT NOCOPY NUMBER,

Line 1430: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1426: END IF;
1427:
1428: Validate_CHECK_NAME_CODE(
1429: p_Api_Name => p_Api_Name,
1430: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1431: p_validation_mode => p_validation_mode,
1432: p_CHECK_NAME_CODE => P_Check_Rec.CHECK_NAME_CODE,
1433: p_CHECK_ID => p_CHECK_Rec.CHECK_ID,
1434: x_return_status => x_return_status,

Line 1441: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(

1437: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1438: raise FND_API.G_EXC_ERROR;
1439: END IF;
1440: -- validate start and end date
1441: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(
1442: p_api_name => p_Api_name,
1443: p_start_date => p_check_rec.start_date_active,
1444: p_end_date => p_check_rec.end_date_active,
1445: x_return_status => x_return_status );

Line 1453: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1449: END IF;
1450:
1451: Validate_SEEDED_FLAG(
1452: p_APi_Name => p_Api_Name,
1453: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1454: p_validation_mode => p_validation_mode,
1455: p_SEEDED_FLAG => P_Check_Rec.SEEDED_FLAG,
1456: x_return_status => x_return_status,
1457: x_msg_count => x_msg_count,

Line 1465: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1461: END IF;
1462:
1463: Validate_SELECT_TYPE(
1464: p_Api_Name => p_Api_Name,
1465: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1466: p_validation_mode => p_validation_mode,
1467: p_SELECT_TYPE => P_Check_Rec.SELECT_TYPE,
1468: x_return_status => x_return_status,
1469: x_msg_count => x_msg_count,

Line 1478: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1474:
1475:
1476: Validate_SELECT_BLOCK_ID(
1477: p_Api_Name => p_Api_Name,
1478: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1479: p_validation_mode => p_validation_mode,
1480: p_SELECT_BLOCK_ID => P_Check_Rec.SELECT_BLOCK_ID,
1481: p_SELECT_TYPE => P_Check_Rec.SELECT_TYPE,
1482: x_return_status => x_return_status,

Line 1492: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1488:
1489:
1490: Validate_DATA_TYPE(
1491: p_Api_Name => p_Api_Name,
1492: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1493: p_validation_mode => p_validation_mode,
1494: p_DATA_TYPE => P_Check_Rec.DATA_TYPE,
1495: x_return_status => x_return_status,
1496: x_msg_count => x_msg_count,

Line 1505: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1501:
1502:
1503: Validate_THRESHOLD_GRADE(
1504: p_Api_Name => p_Api_Name,
1505: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1506: p_validation_mode => p_validation_mode,
1507: p_THRESHOLD_GRADE => P_Check_Rec.THRESHOLD_GRADE,
1508: x_return_status => x_return_status,
1509: x_msg_count => x_msg_count,

Line 1517: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1513: END IF;
1514:
1515: Validate_THRESHOLD_RATING_CODE(
1516: p_Api_Name => p_Api_Name,
1517: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1518: p_validation_mode => p_validation_mode,
1519: p_THRESHOLD_RATING_CODE => P_Check_Rec.THRESHOLD_RATING_CODE,
1520: x_return_status => x_return_status,
1521: x_msg_count => x_msg_count,

Line 1529: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1525: END IF;
1526:
1527: Validate_UPPER_LOWER_FLAG(
1528: p_Api_Name => p_Api_Name,
1529: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1530: p_validation_mode => p_validation_mode,
1531: p_CHECK_UPPER_LOWER_FLAG => P_Check_Rec.CHECK_UPPER_LOWER_FLAG,
1532: x_return_status => x_return_status,
1533: x_msg_count => x_msg_count,

Line 1541: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1537: END IF;
1538:
1539: Validate_THRESHOLD_COLOR_CODE(
1540: p_Api_Name => p_Api_Name,
1541: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1542: p_validation_mode => p_validation_mode,
1543: p_THRESHOLD_COLOR_CODE => P_Check_Rec.THRESHOLD_COLOR_CODE,
1544: x_return_status => x_return_status,
1545: x_msg_count => x_msg_count,

Line 1551: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (

1547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1548: raise FND_API.G_EXC_ERROR;
1549: END IF;
1550:
1551: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (
1552: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
1553: P_Application_ID => P_Check_Rec.application_id,
1554: p_effective_date => SYSDATE,
1555: X_Return_Status => x_return_status,

Line 1552: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,

1548: raise FND_API.G_EXC_ERROR;
1549: END IF;
1550:
1551: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (
1552: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
1553: P_Application_ID => P_Check_Rec.application_id,
1554: p_effective_date => SYSDATE,
1555: X_Return_Status => x_return_status,
1556: X_Msg_Count => x_msg_count,

Line 1577: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1573:
1574: /*
1575: Validate_CATEGORY_CODE(
1576: p_Api_Name => p_Api_Name,
1577: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1578: p_validation_mode => p_validation_mode,
1579: p_CATEGORY_CODE => P_Check_Rec.CATEGORY_CODE,
1580: x_return_status => x_return_status,
1581: x_msg_count => x_msg_count,