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

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

43:
44:
45: PROCEDURE Create_csc_prof_group_cat(
46: P_Api_Version_Number IN NUMBER,
47: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
48: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
49: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
50: px_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
51: p_GROUP_ID IN NUMBER,

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

44:
45: PROCEDURE Create_csc_prof_group_cat(
46: P_Api_Version_Number IN NUMBER,
47: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
48: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
49: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
50: px_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
51: p_GROUP_ID IN NUMBER,
52: p_CATEGORY_CODE IN VARCHAR2,

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

45: PROCEDURE Create_csc_prof_group_cat(
46: P_Api_Version_Number IN NUMBER,
47: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
48: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
49: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
50: px_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
51: p_GROUP_ID IN NUMBER,
52: p_CATEGORY_CODE IN VARCHAR2,
53: p_CATEGORY_SEQUENCE IN NUMBER,

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

95: END Create_csc_prof_group_cat;
96:
97: PROCEDURE Create_csc_prof_group_cat(
98: P_Api_Version_Number IN NUMBER,
99: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
100: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
101: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
102: PX_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
103: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type := G_MISS_PROF_GRP_CAT_REC,

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

96:
97: PROCEDURE Create_csc_prof_group_cat(
98: P_Api_Version_Number IN NUMBER,
99: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
100: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
101: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
102: PX_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
103: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type := G_MISS_PROF_GRP_CAT_REC,
104: X_Return_Status OUT NOCOPY VARCHAR2,

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

97: PROCEDURE Create_csc_prof_group_cat(
98: P_Api_Version_Number IN NUMBER,
99: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
100: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
101: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
102: PX_GROUP_CATEGORY_ID IN OUT NOCOPY NUMBER,
103: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type := G_MISS_PROF_GRP_CAT_REC,
104: X_Return_Status OUT NOCOPY VARCHAR2,
105: X_Msg_Count OUT NOCOPY NUMBER,

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

139: --
140:
141:
142:
143: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
144: THEN
145: -- Invoke validation procedures
146: Validate_csc_prof_group_cat(
147: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 147: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

143: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
144: THEN
145: -- Invoke validation procedures
146: Validate_csc_prof_group_cat(
147: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
148: p_validation_level => p_validation_level,
149: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
150: P_PROF_GRP_CAT_Rec => P_PROF_GRP_CAT_Rec,
151: x_return_status => x_return_status,

Line 149: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,

145: -- Invoke validation procedures
146: Validate_csc_prof_group_cat(
147: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
148: p_validation_level => p_validation_level,
149: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
150: P_PROF_GRP_CAT_Rec => P_PROF_GRP_CAT_Rec,
151: x_return_status => x_return_status,
152: x_msg_count => x_msg_count,
153: x_msg_data => x_msg_data);

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

214: End Create_csc_prof_group_cat;
215:
216: PROCEDURE Update_csc_prof_group_cat(
217: P_Api_Version_Number IN NUMBER,
218: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
219: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
220: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
221: p_GROUP_CATEGORY_ID IN NUMBER,
222: p_GROUP_ID IN NUMBER,

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

215:
216: PROCEDURE Update_csc_prof_group_cat(
217: P_Api_Version_Number IN NUMBER,
218: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
219: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
220: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
221: p_GROUP_CATEGORY_ID IN NUMBER,
222: p_GROUP_ID IN NUMBER,
223: p_CATEGORY_CODE IN VARCHAR2,

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

216: PROCEDURE Update_csc_prof_group_cat(
217: P_Api_Version_Number IN NUMBER,
218: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
219: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
220: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
221: p_GROUP_CATEGORY_ID IN NUMBER,
222: p_GROUP_ID IN NUMBER,
223: p_CATEGORY_CODE IN VARCHAR2,
224: p_CATEGORY_SEQUENCE IN NUMBER,

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

267:
268:
269: PROCEDURE Update_csc_prof_group_cat(
270: P_Api_Version_Number IN NUMBER,
271: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
272: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
273: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
274: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
275: X_Return_Status OUT NOCOPY VARCHAR2,

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

268:
269: PROCEDURE Update_csc_prof_group_cat(
270: P_Api_Version_Number IN NUMBER,
271: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
272: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
273: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
274: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
275: X_Return_Status OUT NOCOPY VARCHAR2,
276: X_Msg_Count OUT NOCOPY NUMBER,

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

269: PROCEDURE Update_csc_prof_group_cat(
270: P_Api_Version_Number IN NUMBER,
271: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
272: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
273: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
274: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
275: X_Return_Status OUT NOCOPY VARCHAR2,
276: X_Msg_Count OUT NOCOPY NUMBER,
277: X_Msg_Data OUT NOCOPY VARCHAR2

Line 350: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(l_Api_Name);

346:
347: If ( C_Get_csc_prof_group_cat%NOTFOUND) Then
348: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
349: THEN
350: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(l_Api_Name);
351: END IF;
352: raise FND_API.G_EXC_ERROR;
353: END IF;
354:

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

352: raise FND_API.G_EXC_ERROR;
353: END IF;
354:
355:
356: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
357: THEN
358: -- Debug message
359: Validate_csc_prof_group_cat(
360: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 360: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

356: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
357: THEN
358: -- Debug message
359: Validate_csc_prof_group_cat(
360: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
361: p_validation_level => p_validation_level,
362: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
363: P_PROF_GRP_CAT_Rec => P_PROF_GRP_CAT_Rec,
364: x_return_status => x_return_status,

Line 362: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,

358: -- Debug message
359: Validate_csc_prof_group_cat(
360: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
361: p_validation_level => p_validation_level,
362: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
363: P_PROF_GRP_CAT_Rec => P_PROF_GRP_CAT_Rec,
364: x_return_status => x_return_status,
365: x_msg_count => x_msg_count,
366: x_msg_data => x_msg_data);

Line 376: p_GROUP_CATEGORY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID,l_old_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID),

372:
373:
374: -- Invoke table handler(CSC_PROF_GROUP_CATEGORIES_PKG.Update_Row)
375: CSC_PROF_GROUP_CATEGORIES_PKG.Update_Row(
376: p_GROUP_CATEGORY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID,l_old_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID),
377: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_ID,l_old_PROF_GRP_CAT_rec.GROUP_ID),
378: p_CATEGORY_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.CATEGORY_CODE,l_old_PROF_GRP_CAT_rec.CATEGORY_CODE),
379: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE,l_old_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE),
380: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

Line 377: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_ID,l_old_PROF_GRP_CAT_rec.GROUP_ID),

373:
374: -- Invoke table handler(CSC_PROF_GROUP_CATEGORIES_PKG.Update_Row)
375: CSC_PROF_GROUP_CATEGORIES_PKG.Update_Row(
376: p_GROUP_CATEGORY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID,l_old_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID),
377: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_ID,l_old_PROF_GRP_CAT_rec.GROUP_ID),
378: p_CATEGORY_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.CATEGORY_CODE,l_old_PROF_GRP_CAT_rec.CATEGORY_CODE),
379: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE,l_old_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE),
380: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
381: p_LAST_UPDATE_DATE => SYSDATE,

Line 378: p_CATEGORY_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.CATEGORY_CODE,l_old_PROF_GRP_CAT_rec.CATEGORY_CODE),

374: -- Invoke table handler(CSC_PROF_GROUP_CATEGORIES_PKG.Update_Row)
375: CSC_PROF_GROUP_CATEGORIES_PKG.Update_Row(
376: p_GROUP_CATEGORY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID,l_old_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID),
377: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_ID,l_old_PROF_GRP_CAT_rec.GROUP_ID),
378: p_CATEGORY_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.CATEGORY_CODE,l_old_PROF_GRP_CAT_rec.CATEGORY_CODE),
379: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE,l_old_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE),
380: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
381: p_LAST_UPDATE_DATE => SYSDATE,
382: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN,l_old_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN),

Line 379: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE,l_old_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE),

375: CSC_PROF_GROUP_CATEGORIES_PKG.Update_Row(
376: p_GROUP_CATEGORY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID,l_old_PROF_GRP_CAT_rec.GROUP_CATEGORY_ID),
377: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.GROUP_ID,l_old_PROF_GRP_CAT_rec.GROUP_ID),
378: p_CATEGORY_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.CATEGORY_CODE,l_old_PROF_GRP_CAT_rec.CATEGORY_CODE),
379: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE,l_old_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE),
380: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
381: p_LAST_UPDATE_DATE => SYSDATE,
382: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN,l_old_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN),
383: p_SEEDED_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.SEEDED_FLAG,l_old_PROF_GRP_CAT_rec.SEEDED_FLAG));

Line 382: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN,l_old_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN),

378: p_CATEGORY_CODE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.CATEGORY_CODE,l_old_PROF_GRP_CAT_rec.CATEGORY_CODE),
379: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE,l_old_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE),
380: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
381: p_LAST_UPDATE_DATE => SYSDATE,
382: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN,l_old_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN),
383: p_SEEDED_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.SEEDED_FLAG,l_old_PROF_GRP_CAT_rec.SEEDED_FLAG));
384: --
385: -- End of API body.
386: --

Line 383: p_SEEDED_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.SEEDED_FLAG,l_old_PROF_GRP_CAT_rec.SEEDED_FLAG));

379: p_CATEGORY_SEQUENCE =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE,l_old_PROF_GRP_CAT_rec.CATEGORY_SEQUENCE),
380: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
381: p_LAST_UPDATE_DATE => SYSDATE,
382: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN,l_old_PROF_GRP_CAT_rec.LAST_UPDATE_LOGIN),
383: p_SEEDED_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_GRP_CAT_rec.SEEDED_FLAG,l_old_PROF_GRP_CAT_rec.SEEDED_FLAG));
384: --
385: -- End of API body.
386: --
387:

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

423:
424:
425: PROCEDURE Delete_csc_prof_group_cat(
426: P_Api_Version_Number IN NUMBER,
427: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
428: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
429: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
430: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
431: X_Return_Status OUT NOCOPY VARCHAR2,

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

424:
425: PROCEDURE Delete_csc_prof_group_cat(
426: P_Api_Version_Number IN NUMBER,
427: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
428: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
429: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
430: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
431: X_Return_Status OUT NOCOPY VARCHAR2,
432: X_Msg_Count OUT NOCOPY NUMBER,

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

425: PROCEDURE Delete_csc_prof_group_cat(
426: P_Api_Version_Number IN NUMBER,
427: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
428: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
429: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
430: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
431: X_Return_Status OUT NOCOPY VARCHAR2,
432: X_Msg_Count OUT NOCOPY NUMBER,
433: X_Msg_Data OUT NOCOPY VARCHAR2

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

514: End Delete_csc_prof_group_cat;
515:
516: -- Item-level validation procedures
517: PROCEDURE Validate_GROUP_CATEGORY_ID (
518: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
519: P_Validation_mode IN VARCHAR2,
520: P_GROUP_CATEGORY_ID IN NUMBER,
521: X_Return_Status OUT NOCOPY VARCHAR2,
522: X_Msg_Count OUT NOCOPY NUMBER,

Line 544: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

540: THEN
541: x_return_status := FND_API.G_RET_STS_ERROR;
542: END IF;
543:
544: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
545: THEN
546: -- Hint: Validate data
547: -- IF p_GROUP_CATEGORY_ID is not NULL and p_GROUP_CATEGORY_ID <> G_MISS_CHAR
548: -- verify if data is valid

Line 551: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

547: -- IF p_GROUP_CATEGORY_ID is not NULL and p_GROUP_CATEGORY_ID <> G_MISS_CHAR
548: -- verify if data is valid
549: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
550: NULL;
551: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
552: THEN
553: -- Hint: Validate data
554: -- IF p_GROUP_CATEGORY_ID <> G_MISS_CHAR
555: -- verify if data is valid

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

566: END Validate_GROUP_CATEGORY_ID;
567:
568:
569: PROCEDURE Validate_GROUP_ID (
570: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
571: P_Validation_mode IN VARCHAR2,
572: P_GROUP_ID IN NUMBER,
573: X_Return_Status OUT NOCOPY VARCHAR2,
574: X_Msg_Count OUT NOCOPY NUMBER,

Line 599: CSC_CORE_UTILS_PVT.mandatory_arg_error(

595: -- validate NOT NULL column
596: IF(p_GROUP_ID is NULL)
597: THEN
598: x_return_status := FND_API.G_RET_STS_ERROR;
599: CSC_CORE_UTILS_PVT.mandatory_arg_error(
600: p_api_name => p_api_name,
601: p_argument => 'p_GROUP_ID',
602: p_argument_value => p_GROUP_ID);
603: END IF;

Line 604: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

600: p_api_name => p_api_name,
601: p_argument => 'p_GROUP_ID',
602: p_argument_value => p_GROUP_ID);
603: END IF;
604: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
605: THEN
606: -- Hint: Validate data
607: -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> G_MISS_CHAR
608: -- verify if data is valid

Line 610: IF p_GROUP_ID = CSC_CORE_UTILS_PVT.G_MISS_NUM

606: -- Hint: Validate data
607: -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> G_MISS_CHAR
608: -- verify if data is valid
609: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
610: IF p_GROUP_ID = CSC_CORE_UTILS_PVT.G_MISS_NUM
611: THEN
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: CSC_CORE_UTILS_PVT.mandatory_arg_error(
614: p_api_name => p_api_name,

Line 613: CSC_CORE_UTILS_PVT.mandatory_arg_error(

609: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
610: IF p_GROUP_ID = CSC_CORE_UTILS_PVT.G_MISS_NUM
611: THEN
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: CSC_CORE_UTILS_PVT.mandatory_arg_error(
614: p_api_name => p_api_name,
615: p_argument => 'p_GROUP_ID',
616: p_argument_value => p_GROUP_ID);
617: ELSIF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM

Line 617: ELSIF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM

613: CSC_CORE_UTILS_PVT.mandatory_arg_error(
614: p_api_name => p_api_name,
615: p_argument => 'p_GROUP_ID',
616: p_argument_value => p_GROUP_ID);
617: ELSIF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
618: THEN
619: Open C1;
620: Fetch C1 into l_dummy;
621: IF C1%NOTFOUND THEN

Line 623: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

619: Open C1;
620: Fetch C1 into l_dummy;
621: IF C1%NOTFOUND THEN
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
624: p_api_name => p_api_name,
625: p_argument_value => p_GROUP_ID,
626: p_argument => 'P_GROUP_ID' );
627: END IF;

Line 630: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

626: p_argument => 'P_GROUP_ID' );
627: END IF;
628: CLOSE C1;
629: END IF;
630: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
631: THEN
632: -- Hint: Validate data
633: -- IF p_GROUP_ID <> G_MISS_CHAR
634: -- verify if data is valid

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

632: -- Hint: Validate data
633: -- IF p_GROUP_ID <> G_MISS_CHAR
634: -- verify if data is valid
635: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
636: IF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
637: THEN
638: Open C1;
639: Fetch C1 into l_dummy;
640: IF C1%NOTFOUND THEN

Line 642: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

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

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

657: END Validate_GROUP_ID;
658:
659:
660: PROCEDURE Validate_CATEGORY_CODE (
661: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
662: P_Validation_mode IN VARCHAR2,
663: P_CATEGORY_CODE IN VARCHAR2,
664: P_GROUP_ID IN NUMBER,
665: X_Return_Status OUT NOCOPY VARCHAR2,

Line 688: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

684:
685: -- Initialize API return status to SUCCESS
686: x_return_status := FND_API.G_RET_STS_SUCCESS;
687:
688: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
689: THEN
690: -- Hint: Validate data
691: -- IF p_CATEGORY_CODE is not NULL and p_CATEGORY_CODE <> G_MISS_CHAR
692: -- verify if data is valid

Line 694: IF p_CATEGORY_CODE is not NULL and p_CATEGORY_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

690: -- Hint: Validate data
691: -- IF p_CATEGORY_CODE is not NULL and p_CATEGORY_CODE <> G_MISS_CHAR
692: -- verify if data is valid
693: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
694: IF p_CATEGORY_CODE is not NULL and p_CATEGORY_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
695: THEN
696: Open C1;
697: Fetch C1 into l_dummy;
698: IF C1%FOUND THEN

Line 700: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(

696: Open C1;
697: Fetch C1 into l_dummy;
698: IF C1%FOUND THEN
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
701: p_api_name => p_api_name,
702: p_argument => 'P_CATEGORY_CODE' ,
703: p_argument_value => p_CATEGORY_CODE);
704: END IF;

Line 707: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

703: p_argument_value => p_CATEGORY_CODE);
704: END IF;
705: CLOSE C1;
706: END IF;
707: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
708: THEN
709: -- Hint: Validate data
710: -- IF p_CATEGORY_CODE <> G_MISS_CHAR
711: -- verify if data is valid

Line 719: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(

715: Open C1;
716: Fetch C1 into l_dummy;
717: IF C1%NOTFOUND THEN
718: x_return_status := FND_API.G_RET_STS_ERROR;
719: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
720: p_api_name => p_api_name,
721: p_argument => 'P_CATEGORY_CODE' ,
722: p_argument_value => p_CATEGORY_CODE);
723: END IF;

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

734: END Validate_CATEGORY_CODE;
735:
736:
737: PROCEDURE Validate_CATEGORY_SEQUENCE (
738: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
739: P_Validation_mode IN VARCHAR2,
740: P_CATEGORY_SEQUENCE IN NUMBER,
741: X_Return_Status OUT NOCOPY VARCHAR2,
742: X_Msg_Count OUT NOCOPY NUMBER,

Line 758: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

754:
755: -- Initialize API return status to SUCCESS
756: x_return_status := FND_API.G_RET_STS_SUCCESS;
757:
758: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
759: THEN
760: -- Hint: Validate data
761: -- IF p_CATEGORY_SEQUENCE is not NULL and p_CATEGORY_SEQUENCE <> G_MISS_CHAR
762: -- verify if data is valid

Line 765: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

761: -- IF p_CATEGORY_SEQUENCE is not NULL and p_CATEGORY_SEQUENCE <> G_MISS_CHAR
762: -- verify if data is valid
763: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
764: NULL;
765: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
766: THEN
767: -- Hint: Validate data
768: -- IF p_CATEGORY_SEQUENCE <> G_MISS_CHAR
769: -- verify if data is valid

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

780: END Validate_CATEGORY_SEQUENCE;
781:
782:
783: PROCEDURE Validate_csc_prof_group_cat(
784: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
785: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
786: P_Validation_mode IN VARCHAR2,
787: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
788: X_Return_Status OUT NOCOPY VARCHAR2,

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

781:
782:
783: PROCEDURE Validate_csc_prof_group_cat(
784: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
785: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
786: P_Validation_mode IN VARCHAR2,
787: P_PROF_GRP_CAT_Rec IN PROF_GRP_CAT_Rec_Type,
788: X_Return_Status OUT NOCOPY VARCHAR2,
789: X_Msg_Count OUT NOCOPY NUMBER,

Line 801: IF (p_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN

797:
798: -- Initialize API return status to SUCCESS
799: x_return_status := FND_API.G_RET_STS_SUCCESS;
800:
801: IF (p_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN
802: -- Hint: We provide validation procedure for every column. Developer should delete
803: -- unnecessary validation procedures.
804: /*
805: Validate_GROUP_CATEGORY_ID(

Line 806: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

802: -- Hint: We provide validation procedure for every column. Developer should delete
803: -- unnecessary validation procedures.
804: /*
805: Validate_GROUP_CATEGORY_ID(
806: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
807: p_validation_mode => p_validation_mode,
808: p_GROUP_CATEGORY_ID => P_PROF_GRP_CAT_Rec.GROUP_CATEGORY_ID,
809: x_return_status => x_return_status,
810: x_msg_count => x_msg_count,

Line 817: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

813: raise FND_API.G_EXC_ERROR;
814: END IF;
815: */
816: Validate_GROUP_ID(
817: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
818: p_validation_mode => p_validation_mode,
819: p_GROUP_ID => P_PROF_GRP_CAT_Rec.GROUP_ID,
820: x_return_status => x_return_status,
821: x_msg_count => x_msg_count,

Line 828: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

824: raise FND_API.G_EXC_ERROR;
825: END IF;
826:
827: Validate_CATEGORY_CODE(
828: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
829: p_validation_mode => p_validation_mode,
830: p_CATEGORY_CODE => P_PROF_GRP_CAT_Rec.CATEGORY_CODE,
831: P_GROUP_ID => P_PROF_GRP_CAT_Rec.GROUP_ID,
832: x_return_status => x_return_status,

Line 840: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

836: raise FND_API.G_EXC_ERROR;
837: END IF;
838:
839: Validate_CATEGORY_SEQUENCE(
840: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
841: p_validation_mode => p_validation_mode,
842: p_CATEGORY_SEQUENCE => P_PROF_GRP_CAT_Rec.CATEGORY_SEQUENCE,
843: x_return_status => x_return_status,
844: x_msg_count => x_msg_count,

Line 852: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(

848: END IF;
849:
850: --Validate seeded flag
851:
852: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(
853: p_api_name =>'CSC_PROF_GROUP_CAT_PVT.VALIDATE_SEEDED_FLAG',
854: p_seeded_flag => p_PROF_GRP_CAT_rec.seeded_flag,
855: x_return_status => x_return_status );
856: