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

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

57:
58: PROCEDURE Create_profile_groups(
59: PX_Group_Id IN OUT NOCOPY NUMBER,
60: P_Api_Version_Number IN NUMBER,
61: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
62: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
63: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
64: P_GROUP_ID IN NUMBER DEFAULT NULL,
65: P_CREATED_BY IN NUMBER,

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

58: PROCEDURE Create_profile_groups(
59: PX_Group_Id IN OUT NOCOPY NUMBER,
60: P_Api_Version_Number IN NUMBER,
61: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
62: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
63: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
64: P_GROUP_ID IN NUMBER DEFAULT NULL,
65: P_CREATED_BY IN NUMBER,
66: P_CREATION_DATE IN DATE,

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

59: PX_Group_Id IN OUT NOCOPY NUMBER,
60: P_Api_Version_Number IN NUMBER,
61: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
62: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
63: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
64: P_GROUP_ID IN NUMBER DEFAULT NULL,
65: P_CREATED_BY IN NUMBER,
66: P_CREATION_DATE IN DATE,
67: P_LAST_UPDATED_BY IN NUMBER,

Line 109: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,

105: );
106: Create_profile_groups(
107: PX_Group_ID => PX_Group_Id,
108: P_Api_Version_Number => 1.0,
109: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
110: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,
111: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
112: P_PROF_GROUP_Rec => l_prof_group_rec,
113: X_Object_Version_Number => x_Object_Version_Number,

Line 110: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,

106: Create_profile_groups(
107: PX_Group_ID => PX_Group_Id,
108: P_Api_Version_Number => 1.0,
109: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
110: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,
111: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
112: P_PROF_GROUP_Rec => l_prof_group_rec,
113: X_Object_Version_Number => x_Object_Version_Number,
114: X_Return_Status => x_return_status,

Line 111: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,

107: PX_Group_ID => PX_Group_Id,
108: P_Api_Version_Number => 1.0,
109: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
110: P_Commit => CSC_CORE_UTILS_PVT.G_FALSE,
111: P_Validation_Level => CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
112: P_PROF_GROUP_Rec => l_prof_group_rec,
113: X_Object_Version_Number => x_Object_Version_Number,
114: X_Return_Status => x_return_status,
115: X_Msg_Count => x_msg_count,

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

121:
122: PROCEDURE Create_profile_groups(
123: PX_Group_Id IN OUT NOCOPY NUMBER,
124: P_Api_Version_Number IN NUMBER,
125: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
126: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
127: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
128: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type := G_MISS_PROF_GROUP_REC,
129: X_Object_Version_Number OUT NOCOPY NUMBER,

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

122: PROCEDURE Create_profile_groups(
123: PX_Group_Id IN OUT NOCOPY NUMBER,
124: P_Api_Version_Number IN NUMBER,
125: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
126: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
127: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
128: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type := G_MISS_PROF_GROUP_REC,
129: X_Object_Version_Number OUT NOCOPY NUMBER,
130: X_Return_Status OUT NOCOPY VARCHAR2,

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

123: PX_Group_Id IN OUT NOCOPY NUMBER,
124: P_Api_Version_Number IN NUMBER,
125: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
126: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
127: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
128: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type := G_MISS_PROF_GROUP_REC,
129: X_Object_Version_Number OUT NOCOPY NUMBER,
130: X_Return_Status OUT NOCOPY VARCHAR2,
131: X_Msg_Count OUT NOCOPY NUMBER,

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

163: --
164: -- API body
165: --
166:
167: IF ( P_validation_level >= CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL)
168: THEN
169:
170: -- Invoke validation procedures
171: Validate_profile_groups(

Line 172: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

168: THEN
169:
170: -- Invoke validation procedures
171: Validate_profile_groups(
172: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
173: p_validation_level => p_validation_level,
174: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
175: P_PROF_GROUP_Rec => P_PROF_GROUP_Rec,
176: x_return_status => x_return_status,

Line 174: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,

170: -- Invoke validation procedures
171: Validate_profile_groups(
172: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
173: p_validation_level => p_validation_level,
174: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
175: P_PROF_GROUP_Rec => P_PROF_GROUP_Rec,
176: x_return_status => x_return_status,
177: x_msg_count => x_msg_count,
178: x_msg_data => x_msg_data);

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

254: End Create_profile_groups;
255:
256: PROCEDURE Update_profile_groups(
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_GROUP_ID IN NUMBER,
262: P_CREATED_BY IN NUMBER,

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

255:
256: PROCEDURE Update_profile_groups(
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_GROUP_ID IN NUMBER,
262: P_CREATED_BY IN NUMBER,
263: P_CREATION_DATE IN DATE ,

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

256: PROCEDURE Update_profile_groups(
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_GROUP_ID IN NUMBER,
262: P_CREATED_BY IN NUMBER,
263: P_CREATION_DATE IN DATE ,
264: P_LAST_UPDATED_BY IN NUMBER,

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

314: END;
315:
316: PROCEDURE Update_profile_groups(
317: P_Api_Version_Number IN NUMBER,
318: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
319: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
320: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
321: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type,
322: PX_Object_Version_Number IN OUT NOCOPY NUMBER,

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

315:
316: PROCEDURE Update_profile_groups(
317: P_Api_Version_Number IN NUMBER,
318: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
319: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
320: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
321: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type,
322: PX_Object_Version_Number IN OUT NOCOPY NUMBER,
323: X_Return_Status OUT NOCOPY VARCHAR2,

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

316: PROCEDURE Update_profile_groups(
317: P_Api_Version_Number IN NUMBER,
318: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
319: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
320: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
321: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type,
322: PX_Object_Version_Number IN OUT NOCOPY NUMBER,
323: X_Return_Status OUT NOCOPY VARCHAR2,
324: X_Msg_Count OUT NOCOPY NUMBER,

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

404: If ( C_Get_profile_groups%NOTFOUND) Then
405: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
406: THEN
407: CLOSE C_Get_profile_Groups;
408: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_Api_Name=>l_api_name);
409: --FND_MESSAGE.Set_Name('CSC', 'API_MISSING_UPDATE_TARGET');
410: --FND_MESSAGE.Set_Token ('INFO', 'CSC_PROF_GROUPS', FALSE);
411: --FND_MSG_PUB.Add;
412: END IF;

Line 425: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

421: THEN
422:
423: -- Invoke validation procedures
424: Validate_profile_groups(
425: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
426: p_validation_level => p_validation_level,
427: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
428: P_PROF_GROUP_Rec => P_PROF_GROUP_Rec,
429: x_return_status => x_return_status,

Line 427: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,

423: -- Invoke validation procedures
424: Validate_profile_groups(
425: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
426: p_validation_level => p_validation_level,
427: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
428: P_PROF_GROUP_Rec => P_PROF_GROUP_Rec,
429: x_return_status => x_return_status,
430: x_msg_count => x_msg_count,
431: x_msg_data => x_msg_data);

Line 441: p_GROUP_ID => csc_core_utils_pvt.Get_G_Miss_num(p_PROF_GROUP_rec.GROUP_ID,l_old_PROF_GROUP_rec.GROUP_ID),

437:
438:
439: -- Invoke table handler(CSC_PROF_GROUPS_PKG.Update_Row)
440: CSC_PROF_GROUPS_PKG.Update_Row(
441: p_GROUP_ID => csc_core_utils_pvt.Get_G_Miss_num(p_PROF_GROUP_rec.GROUP_ID,l_old_PROF_GROUP_rec.GROUP_ID),
442: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
443: p_LAST_UPDATE_DATE => SYSDATE,
444: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
445: p_GROUP_NAME =>csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.GROUP_NAME,l_old_PROF_GROUP_rec.GROUP_NAME),

Line 445: p_GROUP_NAME =>csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.GROUP_NAME,l_old_PROF_GROUP_rec.GROUP_NAME),

441: p_GROUP_ID => csc_core_utils_pvt.Get_G_Miss_num(p_PROF_GROUP_rec.GROUP_ID,l_old_PROF_GROUP_rec.GROUP_ID),
442: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
443: p_LAST_UPDATE_DATE => SYSDATE,
444: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
445: p_GROUP_NAME =>csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.GROUP_NAME,l_old_PROF_GROUP_rec.GROUP_NAME),
446: p_GROUP_NAME_CODE =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.GROUP_NAME_CODE,l_old_PROF_GROUP_rec.GROUP_NAME_CODE),
447: p_DESCRIPTION =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.DESCRIPTION,l_old_PROF_GROUP_rec.DESCRIPTION),
448: p_START_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.START_DATE_ACTIVE,l_old_PROF_GROUP_rec.START_DATE_ACTIVE),
449: p_END_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.END_DATE_ACTIVE,l_old_PROF_GROUP_rec.END_DATE_ACTIVE),

Line 446: p_GROUP_NAME_CODE =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.GROUP_NAME_CODE,l_old_PROF_GROUP_rec.GROUP_NAME_CODE),

442: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
443: p_LAST_UPDATE_DATE => SYSDATE,
444: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
445: p_GROUP_NAME =>csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.GROUP_NAME,l_old_PROF_GROUP_rec.GROUP_NAME),
446: p_GROUP_NAME_CODE =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.GROUP_NAME_CODE,l_old_PROF_GROUP_rec.GROUP_NAME_CODE),
447: p_DESCRIPTION =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.DESCRIPTION,l_old_PROF_GROUP_rec.DESCRIPTION),
448: p_START_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.START_DATE_ACTIVE,l_old_PROF_GROUP_rec.START_DATE_ACTIVE),
449: p_END_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.END_DATE_ACTIVE,l_old_PROF_GROUP_rec.END_DATE_ACTIVE),
450: p_USE_IN_CUSTOMER_DASHBOARD => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD,l_old_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD),

Line 447: p_DESCRIPTION =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.DESCRIPTION,l_old_PROF_GROUP_rec.DESCRIPTION),

443: p_LAST_UPDATE_DATE => SYSDATE,
444: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
445: p_GROUP_NAME =>csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.GROUP_NAME,l_old_PROF_GROUP_rec.GROUP_NAME),
446: p_GROUP_NAME_CODE =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.GROUP_NAME_CODE,l_old_PROF_GROUP_rec.GROUP_NAME_CODE),
447: p_DESCRIPTION =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.DESCRIPTION,l_old_PROF_GROUP_rec.DESCRIPTION),
448: p_START_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.START_DATE_ACTIVE,l_old_PROF_GROUP_rec.START_DATE_ACTIVE),
449: p_END_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.END_DATE_ACTIVE,l_old_PROF_GROUP_rec.END_DATE_ACTIVE),
450: p_USE_IN_CUSTOMER_DASHBOARD => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD,l_old_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD),
451: p_PARTY_TYPE => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.PARTY_TYPE,l_old_PROF_GROUP_rec.PARTY_TYPE),

Line 448: p_START_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.START_DATE_ACTIVE,l_old_PROF_GROUP_rec.START_DATE_ACTIVE),

444: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
445: p_GROUP_NAME =>csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.GROUP_NAME,l_old_PROF_GROUP_rec.GROUP_NAME),
446: p_GROUP_NAME_CODE =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.GROUP_NAME_CODE,l_old_PROF_GROUP_rec.GROUP_NAME_CODE),
447: p_DESCRIPTION =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.DESCRIPTION,l_old_PROF_GROUP_rec.DESCRIPTION),
448: p_START_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.START_DATE_ACTIVE,l_old_PROF_GROUP_rec.START_DATE_ACTIVE),
449: p_END_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.END_DATE_ACTIVE,l_old_PROF_GROUP_rec.END_DATE_ACTIVE),
450: p_USE_IN_CUSTOMER_DASHBOARD => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD,l_old_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD),
451: p_PARTY_TYPE => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.PARTY_TYPE,l_old_PROF_GROUP_rec.PARTY_TYPE),
452: p_SEEDED_FLAG => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.SEEDED_FLAG,l_old_PROF_GROUP_rec.SEEDED_FLAG),

Line 449: p_END_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.END_DATE_ACTIVE,l_old_PROF_GROUP_rec.END_DATE_ACTIVE),

445: p_GROUP_NAME =>csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.GROUP_NAME,l_old_PROF_GROUP_rec.GROUP_NAME),
446: p_GROUP_NAME_CODE =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.GROUP_NAME_CODE,l_old_PROF_GROUP_rec.GROUP_NAME_CODE),
447: p_DESCRIPTION =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.DESCRIPTION,l_old_PROF_GROUP_rec.DESCRIPTION),
448: p_START_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.START_DATE_ACTIVE,l_old_PROF_GROUP_rec.START_DATE_ACTIVE),
449: p_END_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.END_DATE_ACTIVE,l_old_PROF_GROUP_rec.END_DATE_ACTIVE),
450: p_USE_IN_CUSTOMER_DASHBOARD => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD,l_old_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD),
451: p_PARTY_TYPE => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.PARTY_TYPE,l_old_PROF_GROUP_rec.PARTY_TYPE),
452: p_SEEDED_FLAG => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.SEEDED_FLAG,l_old_PROF_GROUP_rec.SEEDED_FLAG),
453: PX_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER,

Line 450: p_USE_IN_CUSTOMER_DASHBOARD => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD,l_old_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD),

446: p_GROUP_NAME_CODE =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.GROUP_NAME_CODE,l_old_PROF_GROUP_rec.GROUP_NAME_CODE),
447: p_DESCRIPTION =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.DESCRIPTION,l_old_PROF_GROUP_rec.DESCRIPTION),
448: p_START_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.START_DATE_ACTIVE,l_old_PROF_GROUP_rec.START_DATE_ACTIVE),
449: p_END_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.END_DATE_ACTIVE,l_old_PROF_GROUP_rec.END_DATE_ACTIVE),
450: p_USE_IN_CUSTOMER_DASHBOARD => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD,l_old_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD),
451: p_PARTY_TYPE => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.PARTY_TYPE,l_old_PROF_GROUP_rec.PARTY_TYPE),
452: p_SEEDED_FLAG => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.SEEDED_FLAG,l_old_PROF_GROUP_rec.SEEDED_FLAG),
453: PX_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER,
454: p_APPLICATION_ID => csc_core_utils_pvt.Get_G_Miss_num(p_PROF_GROUP_rec.APPLICATION_ID,l_old_PROF_GROUP_rec.APPLICATION_ID) );

Line 451: p_PARTY_TYPE => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.PARTY_TYPE,l_old_PROF_GROUP_rec.PARTY_TYPE),

447: p_DESCRIPTION =>csc_core_utils_pvt.Get_G_Miss_char( p_PROF_GROUP_rec.DESCRIPTION,l_old_PROF_GROUP_rec.DESCRIPTION),
448: p_START_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.START_DATE_ACTIVE,l_old_PROF_GROUP_rec.START_DATE_ACTIVE),
449: p_END_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.END_DATE_ACTIVE,l_old_PROF_GROUP_rec.END_DATE_ACTIVE),
450: p_USE_IN_CUSTOMER_DASHBOARD => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD,l_old_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD),
451: p_PARTY_TYPE => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.PARTY_TYPE,l_old_PROF_GROUP_rec.PARTY_TYPE),
452: p_SEEDED_FLAG => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.SEEDED_FLAG,l_old_PROF_GROUP_rec.SEEDED_FLAG),
453: PX_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER,
454: p_APPLICATION_ID => csc_core_utils_pvt.Get_G_Miss_num(p_PROF_GROUP_rec.APPLICATION_ID,l_old_PROF_GROUP_rec.APPLICATION_ID) );
455: --

Line 452: p_SEEDED_FLAG => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.SEEDED_FLAG,l_old_PROF_GROUP_rec.SEEDED_FLAG),

448: p_START_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.START_DATE_ACTIVE,l_old_PROF_GROUP_rec.START_DATE_ACTIVE),
449: p_END_DATE_ACTIVE => csc_core_utils_pvt.Get_G_Miss_Date(p_PROF_GROUP_rec.END_DATE_ACTIVE,l_old_PROF_GROUP_rec.END_DATE_ACTIVE),
450: p_USE_IN_CUSTOMER_DASHBOARD => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD,l_old_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD),
451: p_PARTY_TYPE => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.PARTY_TYPE,l_old_PROF_GROUP_rec.PARTY_TYPE),
452: p_SEEDED_FLAG => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.SEEDED_FLAG,l_old_PROF_GROUP_rec.SEEDED_FLAG),
453: PX_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER,
454: p_APPLICATION_ID => csc_core_utils_pvt.Get_G_Miss_num(p_PROF_GROUP_rec.APPLICATION_ID,l_old_PROF_GROUP_rec.APPLICATION_ID) );
455: --
456: -- End of API body.

Line 454: p_APPLICATION_ID => csc_core_utils_pvt.Get_G_Miss_num(p_PROF_GROUP_rec.APPLICATION_ID,l_old_PROF_GROUP_rec.APPLICATION_ID) );

450: p_USE_IN_CUSTOMER_DASHBOARD => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD,l_old_PROF_GROUP_rec.USE_IN_CUSTOMER_DASHBOARD),
451: p_PARTY_TYPE => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.PARTY_TYPE,l_old_PROF_GROUP_rec.PARTY_TYPE),
452: p_SEEDED_FLAG => csc_core_utils_pvt.Get_G_Miss_char(p_PROF_GROUP_rec.SEEDED_FLAG,l_old_PROF_GROUP_rec.SEEDED_FLAG),
453: PX_OBJECT_VERSION_NUMBER => px_OBJECT_VERSION_NUMBER,
454: p_APPLICATION_ID => csc_core_utils_pvt.Get_G_Miss_num(p_PROF_GROUP_rec.APPLICATION_ID,l_old_PROF_GROUP_rec.APPLICATION_ID) );
455: --
456: -- End of API body.
457: --
458:

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

496:
497:
498: PROCEDURE Delete_profile_groups(
499: P_Api_Version_Number IN NUMBER,
500: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
501: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
502: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
503: P_Group_ID IN NUMBER,
504: P_Object_Version_Number IN NUMBER,

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

497:
498: PROCEDURE Delete_profile_groups(
499: P_Api_Version_Number IN NUMBER,
500: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
501: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
502: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
503: P_Group_ID IN NUMBER,
504: P_Object_Version_Number IN NUMBER,
505: X_Return_Status OUT NOCOPY VARCHAR2,

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

498: PROCEDURE Delete_profile_groups(
499: P_Api_Version_Number IN NUMBER,
500: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
501: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
502: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
503: P_Group_ID IN NUMBER,
504: P_Object_Version_Number IN NUMBER,
505: X_Return_Status OUT NOCOPY VARCHAR2,
506: X_Msg_Count OUT NOCOPY NUMBER,

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

589:
590:
591: PROCEDURE Validate_GROUP_NAME (
592: P_Api_Name IN VARCHAR2,
593: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
594: P_Validation_mode IN VARCHAR2,
595: P_GROUP_NAME IN VARCHAR2,
596: P_GROUP_ID IN NUMBER,
597: X_Return_Status OUT NOCOPY VARCHAR2,

Line 622: CSC_CORE_UTILS_PVT.mandatory_arg_error(

618: -- validate NOT NULL column
619: IF(p_GROUP_NAME is NULL)
620: THEN
621: x_return_status := FND_API.G_RET_STS_ERROR;
622: CSC_CORE_UTILS_PVT.mandatory_arg_error(
623: p_api_name => p_api_name,
624: p_argument => 'p_GROUP_NAME',
625: p_argument_value => p_GROUP_NAME);
626: END IF;

Line 628: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

624: p_argument => 'p_GROUP_NAME',
625: p_argument_value => p_GROUP_NAME);
626: END IF;
627:
628: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
629: THEN
630: -- Hint: Validate data
631: -- IF p_GROUP_NAME is not NULL and p_GROUP_NAME <> G_MISS_CHAR
632: -- verify if data is valid

Line 634: IF p_GROUP_NAME is not NULL and p_GROUP_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

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

Line 640: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(

636: Open C1;
637: Fetch C1 into l_dummy;
638: IF C1%FOUND THEN
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
641: p_api_name => p_api_name,
642: p_argument => 'p_GROUP_NAME' ,
643: p_argument_value => p_GROUP_NAME);
644: END IF;

Line 648: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

644: END IF;
645: close C1;
646: END IF;
647: NULL;
648: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
649: THEN
650: -- Hint: Validate data
651: -- IF p_GROUP_NAME <> G_MISS_CHAR
652: -- verify if data is valid

Line 654: IF p_GROUP_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

650: -- Hint: Validate data
651: -- IF p_GROUP_NAME <> G_MISS_CHAR
652: -- verify if data is valid
653: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
654: IF p_GROUP_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
655: THEN
656: FOR C1_REC IN C1 LOOP
657: IF c1_rec.group_id <> p_GROUP_ID THEN
658: x_return_status := FND_API.G_RET_STS_ERROR;

Line 659: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(

655: THEN
656: FOR C1_REC IN C1 LOOP
657: IF c1_rec.group_id <> p_GROUP_ID THEN
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
660: p_api_name => p_api_name,
661: p_argument => 'p_GROUP_NAME' ,
662: p_argument_value => p_GROUP_NAME);
663: END IF;

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

675:
676:
677: PROCEDURE Validate_GROUP_NAME_CODE (
678: P_Api_Name IN VARCHAR2,
679: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
680: P_Validation_mode IN VARCHAR2,
681: P_GROUP_NAME_CODE IN VARCHAR2,
682: X_Return_Status OUT NOCOPY VARCHAR2,
683: X_Msg_Count OUT NOCOPY NUMBER,

Line 704: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

700:
701: -- Initialize API return status to SUCCESS
702: x_return_status := FND_API.G_RET_STS_SUCCESS;
703:
704: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
705: THEN
706: -- Hint: Validate data
707: -- IF p_GROUP_NAME_CODE is not NULL and p_GROUP_NAME_CODE <> G_MISS_CHAR
708: -- verify if data is valid

Line 710: IF p_GROUP_NAME_CODE is not NULL and p_GROUP_NAME_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

706: -- Hint: Validate data
707: -- IF p_GROUP_NAME_CODE is not NULL and p_GROUP_NAME_CODE <> G_MISS_CHAR
708: -- verify if data is valid
709: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
710: IF p_GROUP_NAME_CODE is not NULL and p_GROUP_NAME_CODE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
711: THEN
712: Open C1;
713: Fetch C1 into l_dummy;
714: IF C1%FOUND THEN

Line 716: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(

712: Open C1;
713: Fetch C1 into l_dummy;
714: IF C1%FOUND THEN
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: CSC_CORE_UTILS_PVT.Add_Duplicate_Value_Msg(
717: p_api_name => p_api_name,
718: p_argument => 'p_GROUP_NAME_CODE' ,
719: p_argument_value => p_GROUP_NAME_CODE);
720: END IF;

Line 724: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

720: END IF;
721: Close C1;
722: END IF;
723: NULL;
724: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
725: THEN
726: -- Hint: Validate data
727: -- IF p_GROUP_NAME_CODE <> G_MISS_CHAR
728: -- verify if data is valid

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

742:
743:
744: PROCEDURE Validate_IN_CUST_DASHBOARD (
745: P_Api_Name IN VARCHAR2,
746: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
747: P_Validation_mode IN VARCHAR2,
748: P_USE_IN_CUSTOMER_DASHBOARD IN VARCHAR2,
749: X_Return_Status OUT NOCOPY VARCHAR2,
750: X_Msg_Count OUT NOCOPY NUMBER,

Line 765: IF ( P_USE_IN_CUSTOMER_DASHBOARD <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND

761:
762: -- Initialize API return status to SUCCESS
763: x_return_status := FND_API.G_RET_STS_SUCCESS;
764:
765: IF ( P_USE_IN_CUSTOMER_DASHBOARD <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
766: ( P_USE_IN_CUSTOMER_DASHBOARD IS NOT NULL )
767: THEN
768: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
769: p_effective_date => trunc(sysdate),

Line 768: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(

764:
765: IF ( P_USE_IN_CUSTOMER_DASHBOARD <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
766: ( P_USE_IN_CUSTOMER_DASHBOARD IS NOT NULL )
767: THEN
768: IF CSC_CORE_UTILS_PVT.lookup_code_not_exists(
769: p_effective_date => trunc(sysdate),
770: p_lookup_type => 'YES_NO',
771: p_lookup_code => P_USE_IN_CUSTOMER_DASHBOARD ) <> FND_API.G_RET_STS_SUCCESS
772: THEN

Line 774: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

770: p_lookup_type => 'YES_NO',
771: p_lookup_code => P_USE_IN_CUSTOMER_DASHBOARD ) <> FND_API.G_RET_STS_SUCCESS
772: THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
775: p_api_name => p_api_name,
776: p_argument_value => P_USE_IN_CUSTOMER_DASHBOARD,
777: p_argument => 'P_USE_IN_CUSTOMER_DASHBOARD');
778: END IF;

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

788:
789:
790: PROCEDURE Validate_SEEDED_FLAG (
791: P_Api_Name IN VARCHAR2,
792: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
793: P_Validation_mode IN VARCHAR2,
794: P_SEEDED_FLAG IN VARCHAR2,
795: X_Return_Status OUT NOCOPY VARCHAR2,
796: X_Msg_Count OUT NOCOPY NUMBER,

Line 814: P_SEEDED_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) THEN

810: x_return_status := FND_API.G_RET_STS_SUCCESS;
811:
812: --Its a hardcode right now but should change i guess.***
813: IF ( P_SEEDED_FLAG IS NOT NULL AND
814: P_SEEDED_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) THEN
815: IF P_SEEDED_FLAG NOT IN ('Y','N')
816: THEN
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

Line 818: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

814: P_SEEDED_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) THEN
815: IF P_SEEDED_FLAG NOT IN ('Y','N')
816: THEN
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
819: p_api_name => p_api_name,
820: p_argument_value => P_SEEDED_FLAG,
821: p_argument => 'P_SEEDED_FLAG');
822: END IF;

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

831: END Validate_SEEDED_FLAG;
832:
833:
834: PROCEDURE Validate_profile_groups(
835: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
836: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
837: P_Validation_mode IN VARCHAR2,
838: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type,
839: X_Return_Status OUT NOCOPY VARCHAR2,

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

832:
833:
834: PROCEDURE Validate_profile_groups(
835: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
836: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
837: P_Validation_mode IN VARCHAR2,
838: P_PROF_GROUP_Rec IN PROF_GROUP_Rec_Type,
839: X_Return_Status OUT NOCOPY VARCHAR2,
840: X_Msg_Count OUT NOCOPY NUMBER,

Line 865: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

861: raise FND_API.G_EXC_ERROR;
862: END IF;
863: Validate_GROUP_NAME_CODE(
864: p_Api_Name => l_api_name,
865: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
866: p_validation_mode => p_validation_mode,
867: p_GROUP_NAME_CODE => P_PROF_GROUP_Rec.GROUP_NAME_CODE,
868: x_return_status => x_return_status,
869: x_msg_count => x_msg_count,

Line 876: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(

872: raise FND_API.G_EXC_ERROR;
873: END IF;
874:
875: -- validate start and end date
876: CSC_CORE_UTILS_PVT.Validate_Start_End_Dt(
877: p_Api_name => l_Api_name,
878: p_START_DATE => P_PROF_GROUP_Rec.START_DATE_ACTIVE,
879: p_END_DATE => P_PROF_GROUP_Rec.END_DATE_ACTIVE,
880: x_return_status => x_return_status );

Line 887: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

883: END IF;
884:
885: Validate_IN_CUST_DASHBOARD(
886: p_Api_Name => l_api_name,
887: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
888: p_validation_mode => p_validation_mode,
889: p_USE_IN_CUSTOMER_DASHBOARD => P_PROF_GROUP_Rec.USE_IN_CUSTOMER_DASHBOARD,
890: x_return_status => x_return_status,
891: x_msg_count => x_msg_count,

Line 898: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

894: raise FND_API.G_EXC_ERROR;
895: END IF;
896: Validate_SEEDED_FLAG(
897: p_Api_Name => l_api_name,
898: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
899: p_validation_mode => p_validation_mode,
900: p_SEEDED_FLAG => P_PROF_GROUP_Rec.SEEDED_FLAG,
901: x_return_status => x_return_status,
902: x_msg_count => x_msg_count,

Line 908: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (

904: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
905: raise FND_API.G_EXC_ERROR;
906: END IF;
907:
908: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (
909: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
910: P_Application_ID => P_PROF_GROUP_Rec.application_id,
911: p_effective_date => SYSDATE,
912: X_Return_Status => x_return_status,

Line 909: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,

905: raise FND_API.G_EXC_ERROR;
906: END IF;
907:
908: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (
909: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
910: P_Application_ID => P_PROF_GROUP_Rec.application_id,
911: p_effective_date => SYSDATE,
912: X_Return_Status => x_return_status,
913: X_Msg_Count => x_msg_count,