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: -- Commented the Following condition for ER#8473903
969: -- IF (p_check_level <> 'PARTY' AND p_check_level <> 'ACCOUNT'AND p_check_level <> 'CONTACT' AND p_check_level <> 'EMPLOYEE')
970: IF (p_check_level <> 'PARTY' AND p_check_level <> 'ACCOUNT'AND p_check_level <> 'CONTACT' AND p_check_level <> 'EMPLOYEE' AND p_check_level<> 'SITE') -- Included the 'SITE' for NCR ER#8473903

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

969: -- IF (p_check_level <> 'PARTY' AND p_check_level <> 'ACCOUNT'AND p_check_level <> 'CONTACT' AND p_check_level <> 'EMPLOYEE')
970: IF (p_check_level <> 'PARTY' AND p_check_level <> 'ACCOUNT'AND p_check_level <> 'CONTACT' AND p_check_level <> 'EMPLOYEE' AND p_check_level<> 'SITE') -- Included the 'SITE' for NCR ER#8473903
971: THEN
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(p_api_name => p_api_name,
974: p_argument_value => p_check_level,
975: p_argument => p_parameter_name);
976: END IF;
977: END IF;

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

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

Line 1007: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

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

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

Line 1058: CSC_CORE_UTILS_PVT.mandatory_arg_error(

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

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

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

Line 1067: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

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

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

Line 1088: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

Line 1097: CSC_CORE_UTILS_PVT.mandatory_arg_error(

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

Line 1112: CSC_CORE_UTILS_PVT.mandatory_arg_error(

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

Line 1120: ELSIF p_SELECT_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM

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

Line 1127: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

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

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

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

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

Line 1178: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

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

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

Line 1222: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

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

Line 1229: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

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

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

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

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

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

Line 1274: IF CSC_CORE_UTILS_PVT.csc_lookup_code_not_exists(

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

Line 1280: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

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

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

Line 1320: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

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

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

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

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

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

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

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

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

Line 1432: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

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

Line 1443: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(

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

Line 1455: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

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

Line 1467: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

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

Line 1480: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

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

Line 1494: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

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

Line 1507: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

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

Line 1519: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

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

Line 1531: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

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

Line 1543: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

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

Line 1553: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (

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

Line 1554: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,

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

Line 1579: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

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