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

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

53:
54:
55: PROCEDURE Create_profile_check_rules(
56: P_Api_Version_Number IN NUMBER,
57: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
58: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
59: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
60: P_CHECK_ID IN NUMBER,
61: P_BLOCK_ID IN NUMBER,

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

54:
55: PROCEDURE Create_profile_check_rules(
56: P_Api_Version_Number IN NUMBER,
57: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
58: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
59: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
60: P_CHECK_ID IN NUMBER,
61: P_BLOCK_ID IN NUMBER,
62: P_SEQUENCE IN NUMBER,

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

55: PROCEDURE Create_profile_check_rules(
56: P_Api_Version_Number IN NUMBER,
57: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
58: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
59: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
60: P_CHECK_ID IN NUMBER,
61: P_BLOCK_ID IN NUMBER,
62: P_SEQUENCE IN NUMBER,
63: P_CREATED_BY IN NUMBER,

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

116: END Create_profile_check_rules;
117:
118: PROCEDURE Create_profile_check_rules(
119: P_Api_Version_Number IN NUMBER,
120: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
121: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
122: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
123: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type := G_MISS_CHK_RULES_REC,
124: X_Object_Version_Number OUT NOCOPY NUMBER,

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

117:
118: PROCEDURE Create_profile_check_rules(
119: P_Api_Version_Number IN NUMBER,
120: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
121: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
122: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
123: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type := G_MISS_CHK_RULES_REC,
124: X_Object_Version_Number OUT NOCOPY NUMBER,
125: X_Return_Status OUT NOCOPY VARCHAR2,

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

118: PROCEDURE Create_profile_check_rules(
119: P_Api_Version_Number IN NUMBER,
120: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
121: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
122: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
123: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type := G_MISS_CHK_RULES_REC,
124: X_Object_Version_Number OUT NOCOPY NUMBER,
125: X_Return_Status OUT NOCOPY VARCHAR2,
126: X_Msg_Count OUT NOCOPY NUMBER,

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

164: --
165: -- API body
166: --
167:
168: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
169: THEN
170: -- Invoke validation procedures
171: Validate_profile_check_rules(
172: p_api_name => l_api_name,

Line 173: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

169: THEN
170: -- Invoke validation procedures
171: Validate_profile_check_rules(
172: p_api_name => l_api_name,
173: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
174: p_validation_level => p_validation_level,
175: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
176: P_CHK_RULES_Rec => p_CHK_RULES_Rec,
177: x_return_status => x_return_status,

Line 175: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,

171: Validate_profile_check_rules(
172: p_api_name => l_api_name,
173: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
174: p_validation_level => p_validation_level,
175: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
176: P_CHK_RULES_Rec => p_CHK_RULES_Rec,
177: x_return_status => x_return_status,
178: x_msg_count => x_msg_count,
179: x_msg_data => x_msg_data);

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

254:
255:
256: PROCEDURE Update_profile_check_rules(
257: P_Api_Version_Number IN NUMBER,
258: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
259: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
260: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
261: P_CHECK_ID IN NUMBER,
262: P_BLOCK_ID IN NUMBER,

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

255:
256: PROCEDURE Update_profile_check_rules(
257: P_Api_Version_Number IN NUMBER,
258: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
259: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
260: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
261: P_CHECK_ID IN NUMBER,
262: P_BLOCK_ID IN NUMBER,
263: P_SEQUENCE IN NUMBER,

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

256: PROCEDURE Update_profile_check_rules(
257: P_Api_Version_Number IN NUMBER,
258: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
259: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
260: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
261: P_CHECK_ID IN NUMBER,
262: P_BLOCK_ID IN NUMBER,
263: P_SEQUENCE IN NUMBER,
264: P_CREATED_BY IN NUMBER,

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

318:
319:
320: PROCEDURE Update_profile_check_rules(
321: P_Api_Version_Number IN NUMBER,
322: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
323: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
324: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
325: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type := G_MISS_CHK_RULES_REC,
326: PX_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,

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

319:
320: PROCEDURE Update_profile_check_rules(
321: P_Api_Version_Number IN NUMBER,
322: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
323: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
324: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
325: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type := G_MISS_CHK_RULES_REC,
326: PX_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
327: X_Return_Status OUT NOCOPY VARCHAR2,

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

320: PROCEDURE Update_profile_check_rules(
321: P_Api_Version_Number IN NUMBER,
322: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
323: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
324: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
325: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type := G_MISS_CHK_RULES_REC,
326: PX_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
327: X_Return_Status OUT NOCOPY VARCHAR2,
328: X_Msg_Count OUT NOCOPY NUMBER,

Line 417: CSC_CORE_UTILS_PVT.Record_Is_Locked_Msg(p_api_name => l_api_name);

413:
414: If ( C_Get_profile_check_rules%NOTFOUND) Then
415: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
416: THEN
417: CSC_CORE_UTILS_PVT.Record_Is_Locked_Msg(p_api_name => l_api_name);
418: END IF;
419: raise FND_API.G_EXC_ERROR;
420: END IF;
421:

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

419: raise FND_API.G_EXC_ERROR;
420: END IF;
421:
422:
423: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
424: THEN
425: -- bug 1231208 -- > Validation mode should be UPDATE here
426: -- Invoke validation procedures
427: Validate_profile_check_rules(

Line 429: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

425: -- bug 1231208 -- > Validation mode should be UPDATE here
426: -- Invoke validation procedures
427: Validate_profile_check_rules(
428: p_api_name => l_api_name,
429: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
430: p_validation_level => p_validation_level,
431: --p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
432: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
433: P_CHK_RULES_Rec => p_CHK_RULES_Rec,

Line 431: --p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,

427: Validate_profile_check_rules(
428: p_api_name => l_api_name,
429: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
430: p_validation_level => p_validation_level,
431: --p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
432: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
433: P_CHK_RULES_Rec => p_CHK_RULES_Rec,
434: x_return_status => x_return_status,
435: x_msg_count => x_msg_count,

Line 432: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,

428: p_api_name => l_api_name,
429: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
430: p_validation_level => p_validation_level,
431: --p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
432: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
433: P_CHK_RULES_Rec => p_CHK_RULES_Rec,
434: x_return_status => x_return_status,
435: x_msg_count => x_msg_count,
436: x_msg_data => x_msg_data);

Line 447: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.CHECK_ID,l_old_CHK_RULES_rec.CHECK_ID),

443: END IF;
444:
445: -- Invoke table handler(CSC_PROF_CHECK_RULES_PKG.Update_Row)
446: CSC_PROFILE_CHECK_RULES_PKG.Update_Row(
447: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.CHECK_ID,l_old_CHK_RULES_rec.CHECK_ID),
448: p_SEQUENCE => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.SEQUENCE,l_old_CHK_RULES_rec.SEQUENCE),
449: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
450: p_LAST_UPDATE_DATE => SYSDATE,
451: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

Line 448: p_SEQUENCE => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.SEQUENCE,l_old_CHK_RULES_rec.SEQUENCE),

444:
445: -- Invoke table handler(CSC_PROF_CHECK_RULES_PKG.Update_Row)
446: CSC_PROFILE_CHECK_RULES_PKG.Update_Row(
447: p_CHECK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.CHECK_ID,l_old_CHK_RULES_rec.CHECK_ID),
448: p_SEQUENCE => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.SEQUENCE,l_old_CHK_RULES_rec.SEQUENCE),
449: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
450: p_LAST_UPDATE_DATE => SYSDATE,
451: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
452: p_LOGICAL_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.LOGICAL_OPERATOR,l_old_CHK_RULES_rec.LOGICAL_OPERATOR),

Line 452: p_LOGICAL_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.LOGICAL_OPERATOR,l_old_CHK_RULES_rec.LOGICAL_OPERATOR),

448: p_SEQUENCE => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.SEQUENCE,l_old_CHK_RULES_rec.SEQUENCE),
449: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
450: p_LAST_UPDATE_DATE => SYSDATE,
451: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
452: p_LOGICAL_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.LOGICAL_OPERATOR,l_old_CHK_RULES_rec.LOGICAL_OPERATOR),
453: p_LEFT_PAREN => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.LEFT_PAREN,l_old_CHK_RULES_rec.LEFT_PAREN),
454: p_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.BLOCK_ID,l_old_CHK_RULES_rec.BLOCK_ID),
455: p_COMPARISON_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.COMPARISON_OPERATOR,l_old_CHK_RULES_rec.COMPARISON_OPERATOR),
456: p_EXPRESSION => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.EXPRESSION,l_old_CHK_RULES_rec.EXPRESSION),

Line 453: p_LEFT_PAREN => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.LEFT_PAREN,l_old_CHK_RULES_rec.LEFT_PAREN),

449: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
450: p_LAST_UPDATE_DATE => SYSDATE,
451: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
452: p_LOGICAL_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.LOGICAL_OPERATOR,l_old_CHK_RULES_rec.LOGICAL_OPERATOR),
453: p_LEFT_PAREN => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.LEFT_PAREN,l_old_CHK_RULES_rec.LEFT_PAREN),
454: p_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.BLOCK_ID,l_old_CHK_RULES_rec.BLOCK_ID),
455: p_COMPARISON_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.COMPARISON_OPERATOR,l_old_CHK_RULES_rec.COMPARISON_OPERATOR),
456: p_EXPRESSION => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.EXPRESSION,l_old_CHK_RULES_rec.EXPRESSION),
457: p_EXPR_TO_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.EXPR_TO_BLOCK_ID,l_old_CHK_RULES_rec.EXPR_TO_BLOCK_ID),

Line 454: p_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.BLOCK_ID,l_old_CHK_RULES_rec.BLOCK_ID),

450: p_LAST_UPDATE_DATE => SYSDATE,
451: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
452: p_LOGICAL_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.LOGICAL_OPERATOR,l_old_CHK_RULES_rec.LOGICAL_OPERATOR),
453: p_LEFT_PAREN => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.LEFT_PAREN,l_old_CHK_RULES_rec.LEFT_PAREN),
454: p_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.BLOCK_ID,l_old_CHK_RULES_rec.BLOCK_ID),
455: p_COMPARISON_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.COMPARISON_OPERATOR,l_old_CHK_RULES_rec.COMPARISON_OPERATOR),
456: p_EXPRESSION => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.EXPRESSION,l_old_CHK_RULES_rec.EXPRESSION),
457: p_EXPR_TO_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.EXPR_TO_BLOCK_ID,l_old_CHK_RULES_rec.EXPR_TO_BLOCK_ID),
458: p_RIGHT_PAREN => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.RIGHT_PAREN,l_old_CHK_RULES_rec.RIGHT_PAREN),

Line 455: p_COMPARISON_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.COMPARISON_OPERATOR,l_old_CHK_RULES_rec.COMPARISON_OPERATOR),

451: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
452: p_LOGICAL_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.LOGICAL_OPERATOR,l_old_CHK_RULES_rec.LOGICAL_OPERATOR),
453: p_LEFT_PAREN => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.LEFT_PAREN,l_old_CHK_RULES_rec.LEFT_PAREN),
454: p_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.BLOCK_ID,l_old_CHK_RULES_rec.BLOCK_ID),
455: p_COMPARISON_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.COMPARISON_OPERATOR,l_old_CHK_RULES_rec.COMPARISON_OPERATOR),
456: p_EXPRESSION => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.EXPRESSION,l_old_CHK_RULES_rec.EXPRESSION),
457: p_EXPR_TO_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.EXPR_TO_BLOCK_ID,l_old_CHK_RULES_rec.EXPR_TO_BLOCK_ID),
458: p_RIGHT_PAREN => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.RIGHT_PAREN,l_old_CHK_RULES_rec.RIGHT_PAREN),
459: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.SEEDED_FLAG,l_old_CHK_RULES_rec.SEEDED_FLAG),

Line 456: p_EXPRESSION => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.EXPRESSION,l_old_CHK_RULES_rec.EXPRESSION),

452: p_LOGICAL_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.LOGICAL_OPERATOR,l_old_CHK_RULES_rec.LOGICAL_OPERATOR),
453: p_LEFT_PAREN => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.LEFT_PAREN,l_old_CHK_RULES_rec.LEFT_PAREN),
454: p_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.BLOCK_ID,l_old_CHK_RULES_rec.BLOCK_ID),
455: p_COMPARISON_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.COMPARISON_OPERATOR,l_old_CHK_RULES_rec.COMPARISON_OPERATOR),
456: p_EXPRESSION => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.EXPRESSION,l_old_CHK_RULES_rec.EXPRESSION),
457: p_EXPR_TO_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.EXPR_TO_BLOCK_ID,l_old_CHK_RULES_rec.EXPR_TO_BLOCK_ID),
458: p_RIGHT_PAREN => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.RIGHT_PAREN,l_old_CHK_RULES_rec.RIGHT_PAREN),
459: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.SEEDED_FLAG,l_old_CHK_RULES_rec.SEEDED_FLAG),
460: px_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER );

Line 457: p_EXPR_TO_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.EXPR_TO_BLOCK_ID,l_old_CHK_RULES_rec.EXPR_TO_BLOCK_ID),

453: p_LEFT_PAREN => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.LEFT_PAREN,l_old_CHK_RULES_rec.LEFT_PAREN),
454: p_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.BLOCK_ID,l_old_CHK_RULES_rec.BLOCK_ID),
455: p_COMPARISON_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.COMPARISON_OPERATOR,l_old_CHK_RULES_rec.COMPARISON_OPERATOR),
456: p_EXPRESSION => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.EXPRESSION,l_old_CHK_RULES_rec.EXPRESSION),
457: p_EXPR_TO_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.EXPR_TO_BLOCK_ID,l_old_CHK_RULES_rec.EXPR_TO_BLOCK_ID),
458: p_RIGHT_PAREN => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.RIGHT_PAREN,l_old_CHK_RULES_rec.RIGHT_PAREN),
459: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.SEEDED_FLAG,l_old_CHK_RULES_rec.SEEDED_FLAG),
460: px_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER );
461:

Line 458: p_RIGHT_PAREN => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.RIGHT_PAREN,l_old_CHK_RULES_rec.RIGHT_PAREN),

454: p_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.BLOCK_ID,l_old_CHK_RULES_rec.BLOCK_ID),
455: p_COMPARISON_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.COMPARISON_OPERATOR,l_old_CHK_RULES_rec.COMPARISON_OPERATOR),
456: p_EXPRESSION => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.EXPRESSION,l_old_CHK_RULES_rec.EXPRESSION),
457: p_EXPR_TO_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.EXPR_TO_BLOCK_ID,l_old_CHK_RULES_rec.EXPR_TO_BLOCK_ID),
458: p_RIGHT_PAREN => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.RIGHT_PAREN,l_old_CHK_RULES_rec.RIGHT_PAREN),
459: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.SEEDED_FLAG,l_old_CHK_RULES_rec.SEEDED_FLAG),
460: px_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER );
461:
462: --

Line 459: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.SEEDED_FLAG,l_old_CHK_RULES_rec.SEEDED_FLAG),

455: p_COMPARISON_OPERATOR =>csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.COMPARISON_OPERATOR,l_old_CHK_RULES_rec.COMPARISON_OPERATOR),
456: p_EXPRESSION => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.EXPRESSION,l_old_CHK_RULES_rec.EXPRESSION),
457: p_EXPR_TO_BLOCK_ID => csc_core_utils_pvt.get_g_miss_num(l_CHK_RULES_rec.EXPR_TO_BLOCK_ID,l_old_CHK_RULES_rec.EXPR_TO_BLOCK_ID),
458: p_RIGHT_PAREN => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.RIGHT_PAREN,l_old_CHK_RULES_rec.RIGHT_PAREN),
459: p_SEEDED_FLAG => csc_core_utils_pvt.get_g_miss_char(l_CHK_RULES_rec.SEEDED_FLAG,l_old_CHK_RULES_rec.SEEDED_FLAG),
460: px_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER );
461:
462: --
463: -- End of API body.

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

503:
504:
505: PROCEDURE Delete_profile_check_rules(
506: P_Api_Version_Number IN NUMBER,
507: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
508: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
509: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
510: P_CHECK_ID IN NUMBER,
511: p_SEQUENCE IN NUMBER,

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

504:
505: PROCEDURE Delete_profile_check_rules(
506: P_Api_Version_Number IN NUMBER,
507: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
508: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
509: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
510: P_CHECK_ID IN NUMBER,
511: p_SEQUENCE IN NUMBER,
512: p_OBJECT_VERSION_NUMBER IN NUMBER,

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

505: PROCEDURE Delete_profile_check_rules(
506: P_Api_Version_Number IN NUMBER,
507: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
508: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
509: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
510: P_CHECK_ID IN NUMBER,
511: p_SEQUENCE IN NUMBER,
512: p_OBJECT_VERSION_NUMBER IN NUMBER,
513: X_Return_Status OUT NOCOPY VARCHAR2,

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

596:
597: -- Item-level validation procedures
598: PROCEDURE Validate_CHECK_ID (
599: P_Api_Name IN VARCHAR2,
600: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
601: P_Validation_mode IN VARCHAR2,
602: P_CHECK_ID IN NUMBER,
603: X_Return_Status OUT NOCOPY VARCHAR2,
604: X_Msg_Count OUT NOCOPY NUMBER,

Line 629: CSC_CORE_UTILS_PVT.mandatory_arg_error(

625: -- validate NOT NULL column
626: IF(p_CHECK_ID is NULL)
627: THEN
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: CSC_CORE_UTILS_PVT.mandatory_arg_error(
630: p_Api_name => p_Api_Name,
631: p_Argument => 'p_CHECK_ID',
632: p_Argument_Value => p_CHECK_ID);
633:

Line 639: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

635:
636: -- Correction for 1231208 --> The check id should be a valid
637: -- check id in csc_prof_checks_b - so %FOUND shoudl not raise
638: -- any error
639: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
640: THEN
641: -- Hint: Validate data
642: -- IF p_CHECK_ID is not NULL and p_CHECK_ID <> G_MISS_CHAR
643: -- verify if data is valid

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

641: -- Hint: Validate data
642: -- IF p_CHECK_ID is not NULL and p_CHECK_ID <> G_MISS_CHAR
643: -- verify if data is valid
644: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
645: IF p_CHECK_ID is not NULL and p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
646: THEN
647: Open C1;
648: Fetch C1 INTO l_dummy;
649: --IF C1%FOUND THEN

Line 654: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (

650: IF C1%NOTFOUND THEN
651: --Changed as % found is valid and %notfound
652: -- is error in this case
653: x_return_status := FND_API.G_RET_STS_ERROR;
654: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (
655: p_Api_Name => p_Api_Name,
656: p_Argument => 'p_CHECK_ID',
657: p_Argument_Value => to_char(p_CHECK_ID));
658: END IF;

Line 661: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

657: p_Argument_Value => to_char(p_CHECK_ID));
658: END IF;
659: Close C1;
660: END IF;
661: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
662: THEN
663: -- Hint: Validate data
664: -- IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
665: -- verify if data is valid

Line 664: -- IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

660: END IF;
661: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
662: THEN
663: -- Hint: Validate data
664: -- IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
665: -- verify if data is valid
666: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
667: IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
668: THEN

Line 667: IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM

663: -- Hint: Validate data
664: -- IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
665: -- verify if data is valid
666: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
667: IF p_CHECK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
668: THEN
669: --** update not allowed
670: NULL;
671: END IF;

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

681:
682:
683: PROCEDURE Validate_SEQUENCE (
684: P_Api_Name IN VARCHAR2,
685: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
686: P_Validation_mode IN VARCHAR2,
687: P_SEQUENCE IN NUMBER,
688: p_check_id IN NUMBER,
689: X_Return_Status OUT NOCOPY VARCHAR2,

Line 716: CSC_CORE_UTILS_PVT.mandatory_arg_error(

712: -- validate NOT NULL column
713: IF(p_SEQUENCE is NULL)
714: THEN
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: CSC_CORE_UTILS_PVT.mandatory_arg_error(
717: p_Api_name => p_Api_Name,
718: p_Argument => 'p_SEQUENCE',
719: p_Argument_Value => p_SEQUENCE);
720:

Line 723: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

719: p_Argument_Value => p_SEQUENCE);
720:
721: END IF;
722:
723: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
724: THEN
725: -- Hint: Validate data
726: -- IF p_SEQUENCE is not NULL and p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
727: -- verify if data is valid

Line 726: -- IF p_SEQUENCE is not NULL and p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

722:
723: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
724: THEN
725: -- Hint: Validate data
726: -- IF p_SEQUENCE is not NULL and p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
727: -- verify if data is valid
728: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
729:
730: IF p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_NUM

Line 730: IF p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_NUM

726: -- IF p_SEQUENCE is not NULL and p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
727: -- verify if data is valid
728: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
729:
730: IF p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_NUM
731: THEN
732: Open C1;
733: Fetch C1 into l_dummy;
734: IF C1%FOUND THEN

Line 736: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (

732: Open C1;
733: Fetch C1 into l_dummy;
734: IF C1%FOUND THEN
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (
737: p_Api_Name => p_Api_Name,
738: p_Argument => 'p_CHECK_ID',
739: p_Argument_Value => to_char(p_CHECK_ID));
740: END IF;

Line 743: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

739: p_Argument_Value => to_char(p_CHECK_ID));
740: END IF;
741: Close C1;
742: END IF;
743: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
744: THEN
745: -- Hint: Validate data
746: -- IF p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
747: -- verify if data is valid

Line 746: -- IF p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

742: END IF;
743: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
744: THEN
745: -- Hint: Validate data
746: -- IF p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
747: -- verify if data is valid
748: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
749: IF p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_NUM
750: THEN

Line 749: IF p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_NUM

745: -- Hint: Validate data
746: -- IF p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
747: -- verify if data is valid
748: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
749: IF p_SEQUENCE <> CSC_CORE_UTILS_PVT.G_MISS_NUM
750: THEN
751: --**cannot update sequence as part of pk
752: NULL;
753: END IF;

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

757:
758:
759: PROCEDURE Validate_EXPR_TO_BLOCK_ID (
760: P_Api_Name IN VARCHAR2,
761: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
762: P_Validation_mode IN VARCHAR2,
763: P_EXPR_TO_BLOCK_ID IN NUMBER,
764: X_Return_Status OUT NOCOPY VARCHAR2,
765: X_Msg_Count OUT NOCOPY NUMBER,

Line 787: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

783:
784: -- Initialize API return status to SUCCESS
785: x_return_status := FND_API.G_RET_STS_SUCCESS;
786:
787: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
788: THEN
789: IF p_EXPR_TO_BLOCK_ID is not NULL and p_EXPR_TO_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
790: THEN
791: Open C1;

Line 789: IF p_EXPR_TO_BLOCK_ID is not NULL and p_EXPR_TO_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM

785: x_return_status := FND_API.G_RET_STS_SUCCESS;
786:
787: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
788: THEN
789: IF p_EXPR_TO_BLOCK_ID is not NULL and p_EXPR_TO_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
790: THEN
791: Open C1;
792: Fetch C1 into l_dummy;
793: IF C1%NOTFOUND THEN

Line 795: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (

791: Open C1;
792: Fetch C1 into l_dummy;
793: IF C1%NOTFOUND THEN
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (
796: p_Api_Name => p_Api_Name,
797: p_Argument => 'p_Expr_to_BLOCK_ID',
798: p_Argument_Value => to_char(p_Expr_to_BLOCK_ID));
799: END IF;

Line 803: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

799: END IF;
800: Close C1;
801: END IF;
802:
803: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
804: THEN
805: -- Hint: Validate data
806: -- IF p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
807: -- verify if data is valid

Line 806: -- IF p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

802:
803: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
804: THEN
805: -- Hint: Validate data
806: -- IF p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
807: -- verify if data is valid
808: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
809: IF p_EXPR_TO_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
810: Open C1;

Line 809: IF p_EXPR_TO_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM THEN

805: -- Hint: Validate data
806: -- IF p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
807: -- verify if data is valid
808: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
809: IF p_EXPR_TO_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
810: Open C1;
811: Fetch C1 into l_dummy;
812: IF C1%NOTFOUND THEN
813: x_return_status := FND_API.G_RET_STS_ERROR;

Line 814: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (

810: Open C1;
811: Fetch C1 into l_dummy;
812: IF C1%NOTFOUND THEN
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (
815: p_Api_Name => p_Api_Name,
816: p_Argument => 'p_EXPR_To_BLOCK_ID',
817: p_Argument_Value => to_char(p_EXPR_TO_BLOCK_ID));
818: END IF;

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

826:
827:
828: PROCEDURE Validate_BLOCK_ID (
829: P_Api_Name IN VARCHAR2,
830: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
831: P_Validation_mode IN VARCHAR2,
832: P_BLOCK_ID IN NUMBER,
833: X_Return_Status OUT NOCOPY VARCHAR2,
834: X_Msg_Count OUT NOCOPY NUMBER,

Line 860: CSC_CORE_UTILS_PVT.mandatory_arg_error(

856: IF(p_BLOCK_ID is NULL)
857: THEN
858: --mandatory arg error
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: CSC_CORE_UTILS_PVT.mandatory_arg_error(
861: p_Api_name => p_Api_Name,
862: p_Argument => 'p_BLOCK_ID',
863: p_Argument_Value => p_BLOCK_ID);
864:

Line 867: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

863: p_Argument_Value => p_BLOCK_ID);
864:
865: END IF;
866:
867: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
868: THEN
869: -- Hint: Validate data
870: -- IF p_BLOCK_ID is not NULL and p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
871: -- verify if data is valid

Line 870: -- IF p_BLOCK_ID is not NULL and p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

866:
867: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
868: THEN
869: -- Hint: Validate data
870: -- IF p_BLOCK_ID is not NULL and p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
871: -- verify if data is valid
872: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
873: IF p_BLOCK_ID is not NULL and p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
874: THEN

Line 873: IF p_BLOCK_ID is not NULL and p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM

869: -- Hint: Validate data
870: -- IF p_BLOCK_ID is not NULL and p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
871: -- verify if data is valid
872: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
873: IF p_BLOCK_ID is not NULL and p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
874: THEN
875: Open C1;
876: Fetch C1 into l_dummy;
877: IF C1%NOTFOUND THEN

Line 879: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (

875: Open C1;
876: Fetch C1 into l_dummy;
877: IF C1%NOTFOUND THEN
878: x_return_status := FND_API.G_RET_STS_ERROR;
879: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (
880: p_Api_Name => p_Api_Name,
881: p_Argument => 'p_BLOCK_ID',
882: p_Argument_Value => to_char(p_BLOCK_ID));
883: END IF;

Line 887: CSC_CORE_UTILS_PVT.mandatory_arg_error(

883: END IF;
884: Close C1;
885: ELSE
886: x_return_status := FND_API.G_RET_STS_ERROR;
887: CSC_CORE_UTILS_PVT.mandatory_arg_error(
888: p_Api_name => p_Api_Name,
889: p_Argument => 'p_BLOCK_ID',
890: p_Argument_Value => p_BLOCK_ID);
891: END IF;

Line 893: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

889: p_Argument => 'p_BLOCK_ID',
890: p_Argument_Value => p_BLOCK_ID);
891: END IF;
892:
893: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
894: THEN
895: -- Hint: Validate data
896: -- IF p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
897: -- verify if data is valid

Line 896: -- IF p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

892:
893: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
894: THEN
895: -- Hint: Validate data
896: -- IF p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
897: -- verify if data is valid
898: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
899: IF p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
900: Open C1;

Line 899: IF p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM THEN

895: -- Hint: Validate data
896: -- IF p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
897: -- verify if data is valid
898: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
899: IF p_BLOCK_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
900: Open C1;
901: Fetch C1 into l_dummy;
902: IF C1%NOTFOUND THEN
903: x_return_status := FND_API.G_RET_STS_ERROR;

Line 904: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (

900: Open C1;
901: Fetch C1 into l_dummy;
902: IF C1%NOTFOUND THEN
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg (
905: p_Api_Name => p_Api_Name,
906: p_Argument => 'p_BLOCK_ID',
907: p_Argument_Value => to_char(p_BLOCK_ID));
908: END IF;

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

971:
972: /*
973: PROCEDURE Validate_CONDITION(
974: P_Api_Name IN VARCHAR2,
975: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
976: P_Validation_mode IN VARCHAR2,
977: p_Chk_Rules_Tbl IN CHK_RULES_Tbl_Type,
978: X_Return_Status OUT NOCOPY VARCHAR2,
979: X_Msg_Count OUT NOCOPY NUMBER,

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

1012: */
1013:
1014: PROCEDURE Validate_profile_check_rules(
1015: P_Api_Name IN VARCHAR2,
1016: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1017: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1018: P_Validation_mode IN VARCHAR2,
1019: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type,
1020: X_Return_Status OUT NOCOPY VARCHAR2,

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

1013:
1014: PROCEDURE Validate_profile_check_rules(
1015: P_Api_Name IN VARCHAR2,
1016: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1017: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1018: P_Validation_mode IN VARCHAR2,
1019: P_CHK_RULES_Rec IN CHK_RULES_Rec_Type,
1020: X_Return_Status OUT NOCOPY VARCHAR2,
1021: X_Msg_Count OUT NOCOPY NUMBER,

Line 1036: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1032:
1033:
1034: Validate_CHECK_ID(
1035: p_api_name => p_api_name,
1036: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1037: p_validation_mode => p_validation_mode,
1038: p_CHECK_ID => p_chk_rules_rec.CHECK_ID,
1039: x_return_status => x_return_status,
1040: x_msg_count => x_msg_count,

Line 1048: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1044: END IF;
1045:
1046: Validate_SEQUENCE(
1047: p_api_name => p_api_name,
1048: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1049: p_validation_mode => p_validation_mode,
1050: p_SEQUENCE => P_CHK_RULES_Rec.SEQUENCE,
1051: p_CHECK_ID => p_CHK_RULES_Rec.Check_Id,
1052: x_return_status => x_return_status,

Line 1062: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1058:
1059:
1060: Validate_BLOCK_ID(
1061: p_api_name => p_api_name,
1062: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1063: p_validation_mode => p_validation_mode,
1064: p_BLOCK_ID => p_Chk_rules_rec.BLOCK_ID,
1065: x_return_status => x_return_status,
1066: x_msg_count => x_msg_count,

Line 1076: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1072:
1073:
1074: Validate_EXPR_TO_BLOCK_ID(
1075: p_api_name => p_api_name,
1076: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1077: p_validation_mode => p_validation_mode,
1078: p_EXPR_TO_BLOCK_ID => p_Chk_rules_rec.Expr_TO_BLOCK_ID,
1079: x_return_status => x_return_status,
1080: x_msg_count => x_msg_count,

Line 1088: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(

1084: END IF;
1085:
1086: --Validate seeded flag
1087:
1088: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(
1089: p_api_name =>'CSC_PROF_CHECK_RULES_PVT.VALIDATE_SEEDED_FLAG',
1090: p_seeded_flag => p_Chk_rules_rec.seeded_flag,
1091: x_return_status => x_return_status );
1092:

Line 1100: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1096:
1097: /*
1098: Validate_CONDITION(
1099: p_api_name => p_api_name,
1100: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1101: p_validation_mode => p_validation_mode,
1102: p_CHK_RULES_Tbl => P_CHK_RULES_Tbl,
1103: x_return_status => x_return_status,
1104: x_msg_count => x_msg_count,