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

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

60:
61:
62: PROCEDURE Create_prof_module_groups(
63: P_Api_Version_Number IN NUMBER,
64: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
65: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
66: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
67: PX_MODULE_GROUP_ID IN OUT NOCOPY NUMBER,
68: p_FORM_FUNCTION_ID NUMBER,

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

61:
62: PROCEDURE Create_prof_module_groups(
63: P_Api_Version_Number IN NUMBER,
64: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
65: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
66: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
67: PX_MODULE_GROUP_ID IN OUT NOCOPY NUMBER,
68: p_FORM_FUNCTION_ID NUMBER,
69: p_FORM_FUNCTION_NAME VARCHAR2,

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

62: PROCEDURE Create_prof_module_groups(
63: P_Api_Version_Number IN NUMBER,
64: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
65: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
66: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
67: PX_MODULE_GROUP_ID IN OUT NOCOPY NUMBER,
68: p_FORM_FUNCTION_ID NUMBER,
69: p_FORM_FUNCTION_NAME VARCHAR2,
70: p_RESPONSIBILITY_ID NUMBER,

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

125: END Create_prof_module_groups;
126:
127: PROCEDURE Create_prof_module_groups(
128: P_Api_Version_Number IN NUMBER,
129: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
130: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
131: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
132: P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type := G_MISS_PROF_MODULE_GRP_REC,
133: PX_MODULE_GROUP_ID IN OUT NOCOPY NUMBER,

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

126:
127: PROCEDURE Create_prof_module_groups(
128: P_Api_Version_Number IN NUMBER,
129: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
130: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
131: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
132: P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type := G_MISS_PROF_MODULE_GRP_REC,
133: PX_MODULE_GROUP_ID IN OUT NOCOPY NUMBER,
134: X_Return_Status OUT NOCOPY VARCHAR2,

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

127: PROCEDURE Create_prof_module_groups(
128: P_Api_Version_Number IN NUMBER,
129: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
130: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
131: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
132: P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type := G_MISS_PROF_MODULE_GRP_REC,
133: PX_MODULE_GROUP_ID IN OUT NOCOPY NUMBER,
134: X_Return_Status OUT NOCOPY VARCHAR2,
135: X_Msg_Count OUT NOCOPY NUMBER,

Line 177: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

173: THEN
174:
175: -- Invoke validation procedures
176: Validate_prof_module_groups(
177: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
178: p_validation_level => p_validation_level,
179: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
180: P_PROF_MODULE_GRP_Rec => P_PROF_MODULE_GRP_Rec,
181: x_return_status => x_return_status,

Line 179: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,

175: -- Invoke validation procedures
176: Validate_prof_module_groups(
177: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
178: p_validation_level => p_validation_level,
179: p_validation_mode => CSC_CORE_UTILS_PVT.G_CREATE,
180: P_PROF_MODULE_GRP_Rec => P_PROF_MODULE_GRP_Rec,
181: x_return_status => x_return_status,
182: x_msg_count => x_msg_count,
183: x_msg_data => x_msg_data);

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

250:
251:
252: PROCEDURE Update_prof_module_groups(
253: P_Api_Version_Number IN NUMBER,
254: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
255: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
256: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
257: P_MODULE_GROUP_ID NUMBER,
258: p_FORM_FUNCTION_ID NUMBER,

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

251:
252: PROCEDURE Update_prof_module_groups(
253: P_Api_Version_Number IN NUMBER,
254: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
255: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
256: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
257: P_MODULE_GROUP_ID NUMBER,
258: p_FORM_FUNCTION_ID NUMBER,
259: p_FORM_FUNCTION_NAME VARCHAR2,

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

252: PROCEDURE Update_prof_module_groups(
253: P_Api_Version_Number IN NUMBER,
254: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
255: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
256: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
257: P_MODULE_GROUP_ID NUMBER,
258: p_FORM_FUNCTION_ID NUMBER,
259: p_FORM_FUNCTION_NAME VARCHAR2,
260: p_RESPONSIBILITY_ID NUMBER,

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

316:
317:
318: PROCEDURE Update_prof_module_groups(
319: P_Api_Version_Number IN NUMBER,
320: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
321: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
322: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
323: P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type,
324: X_Return_Status OUT NOCOPY VARCHAR2,

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

317:
318: PROCEDURE Update_prof_module_groups(
319: P_Api_Version_Number IN NUMBER,
320: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
321: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
322: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
323: P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type,
324: X_Return_Status OUT NOCOPY VARCHAR2,
325: X_Msg_Count OUT NOCOPY NUMBER,

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

318: PROCEDURE Update_prof_module_groups(
319: P_Api_Version_Number IN NUMBER,
320: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
321: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
322: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
323: P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type,
324: X_Return_Status OUT NOCOPY VARCHAR2,
325: X_Msg_Count OUT NOCOPY NUMBER,
326: X_Msg_Data OUT NOCOPY VARCHAR2

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

406: If ( C_Get_prof_module_groups%NOTFOUND) Then
407:
408: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
409: THEN
410: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_Api_Name => l_api_name);
411: END IF;
412: raise FND_API.G_EXC_ERROR;
413:
414: END IF;

Line 420: IF p_prof_module_grp_rec.group_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN

416:
417: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
418: THEN
419: /*
420: IF p_prof_module_grp_rec.group_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
421: l_prof_module_grp_rec.group_id := l_old_prof_module_grp_rec.group_id;
422: END IF;
423: IF p_prof_module_grp_rec.dashboard_group_flag = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
424: l_prof_module_grp_rec.dashboard_group_Flag := l_old_prof_module_grp_rec.dashboard_group_flag;

Line 423: IF p_prof_module_grp_rec.dashboard_group_flag = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN

419: /*
420: IF p_prof_module_grp_rec.group_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
421: l_prof_module_grp_rec.group_id := l_old_prof_module_grp_rec.group_id;
422: END IF;
423: IF p_prof_module_grp_rec.dashboard_group_flag = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
424: l_prof_module_grp_rec.dashboard_group_Flag := l_old_prof_module_grp_rec.dashboard_group_flag;
425: END IF;
426: IF p_prof_module_grp_rec.form_function_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
427: l_prof_module_grp_Rec.form_function_id := l_old_prof_module_grp_rec.form_function_id;

Line 426: IF p_prof_module_grp_rec.form_function_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN

422: END IF;
423: IF p_prof_module_grp_rec.dashboard_group_flag = CSC_CORE_UTILS_PVT.G_MISS_CHAR THEN
424: l_prof_module_grp_rec.dashboard_group_Flag := l_old_prof_module_grp_rec.dashboard_group_flag;
425: END IF;
426: IF p_prof_module_grp_rec.form_function_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
427: l_prof_module_grp_Rec.form_function_id := l_old_prof_module_grp_rec.form_function_id;
428: END IF;
429: IF p_prof_module_grp_rec.responsibility_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
430: l_prof_module_grp_rec.responsibility_id := l_old_prof_module_grp_rec.responsibility_id;

Line 429: IF p_prof_module_grp_rec.responsibility_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN

425: END IF;
426: IF p_prof_module_grp_rec.form_function_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
427: l_prof_module_grp_Rec.form_function_id := l_old_prof_module_grp_rec.form_function_id;
428: END IF;
429: IF p_prof_module_grp_rec.responsibility_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
430: l_prof_module_grp_rec.responsibility_id := l_old_prof_module_grp_rec.responsibility_id;
431: END IF;
432: IF p_prof_module_grp_rec.resp_appl_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
433: l_prof_module_grp_rec.resp_appl_id := l_old_prof_module_grp_rec.resp_appl_id;

Line 432: IF p_prof_module_grp_rec.resp_appl_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN

428: END IF;
429: IF p_prof_module_grp_rec.responsibility_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
430: l_prof_module_grp_rec.responsibility_id := l_old_prof_module_grp_rec.responsibility_id;
431: END IF;
432: IF p_prof_module_grp_rec.resp_appl_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
433: l_prof_module_grp_rec.resp_appl_id := l_old_prof_module_grp_rec.resp_appl_id;
434: END IF;
435: */
436: l_prof_module_grp_rec.group_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.group_id,l_old_prof_module_grp_rec.group_id);

Line 436: l_prof_module_grp_rec.group_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.group_id,l_old_prof_module_grp_rec.group_id);

432: IF p_prof_module_grp_rec.resp_appl_id = CSC_CORE_UTILS_PVT.G_MISS_NUM THEN
433: l_prof_module_grp_rec.resp_appl_id := l_old_prof_module_grp_rec.resp_appl_id;
434: END IF;
435: */
436: l_prof_module_grp_rec.group_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.group_id,l_old_prof_module_grp_rec.group_id);
437: l_prof_module_grp_rec.dashboard_group_Flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_prof_module_grp_rec.dashboard_group_flag,l_old_prof_module_grp_rec.dashboard_group_flag);
438: l_prof_module_grp_Rec.form_function_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.form_function_id,l_old_prof_module_grp_rec.form_function_id);
439: l_prof_module_grp_rec.responsibility_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.responsibility_id,l_old_prof_module_grp_rec.responsibility_id);
440:

Line 437: l_prof_module_grp_rec.dashboard_group_Flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_prof_module_grp_rec.dashboard_group_flag,l_old_prof_module_grp_rec.dashboard_group_flag);

433: l_prof_module_grp_rec.resp_appl_id := l_old_prof_module_grp_rec.resp_appl_id;
434: END IF;
435: */
436: l_prof_module_grp_rec.group_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.group_id,l_old_prof_module_grp_rec.group_id);
437: l_prof_module_grp_rec.dashboard_group_Flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_prof_module_grp_rec.dashboard_group_flag,l_old_prof_module_grp_rec.dashboard_group_flag);
438: l_prof_module_grp_Rec.form_function_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.form_function_id,l_old_prof_module_grp_rec.form_function_id);
439: l_prof_module_grp_rec.responsibility_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.responsibility_id,l_old_prof_module_grp_rec.responsibility_id);
440:
441: l_prof_module_grp_rec.resp_appl_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.resp_appl_id,l_old_prof_module_grp_rec.resp_appl_id);

Line 438: l_prof_module_grp_Rec.form_function_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.form_function_id,l_old_prof_module_grp_rec.form_function_id);

434: END IF;
435: */
436: l_prof_module_grp_rec.group_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.group_id,l_old_prof_module_grp_rec.group_id);
437: l_prof_module_grp_rec.dashboard_group_Flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_prof_module_grp_rec.dashboard_group_flag,l_old_prof_module_grp_rec.dashboard_group_flag);
438: l_prof_module_grp_Rec.form_function_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.form_function_id,l_old_prof_module_grp_rec.form_function_id);
439: l_prof_module_grp_rec.responsibility_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.responsibility_id,l_old_prof_module_grp_rec.responsibility_id);
440:
441: l_prof_module_grp_rec.resp_appl_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.resp_appl_id,l_old_prof_module_grp_rec.resp_appl_id);
442:

Line 439: l_prof_module_grp_rec.responsibility_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.responsibility_id,l_old_prof_module_grp_rec.responsibility_id);

435: */
436: l_prof_module_grp_rec.group_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.group_id,l_old_prof_module_grp_rec.group_id);
437: l_prof_module_grp_rec.dashboard_group_Flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_prof_module_grp_rec.dashboard_group_flag,l_old_prof_module_grp_rec.dashboard_group_flag);
438: l_prof_module_grp_Rec.form_function_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.form_function_id,l_old_prof_module_grp_rec.form_function_id);
439: l_prof_module_grp_rec.responsibility_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.responsibility_id,l_old_prof_module_grp_rec.responsibility_id);
440:
441: l_prof_module_grp_rec.resp_appl_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.resp_appl_id,l_old_prof_module_grp_rec.resp_appl_id);
442:
443: -- Invoke validation procedures

Line 441: l_prof_module_grp_rec.resp_appl_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.resp_appl_id,l_old_prof_module_grp_rec.resp_appl_id);

437: l_prof_module_grp_rec.dashboard_group_Flag := CSC_CORE_UTILS_PVT.Get_G_Miss_Char(p_prof_module_grp_rec.dashboard_group_flag,l_old_prof_module_grp_rec.dashboard_group_flag);
438: l_prof_module_grp_Rec.form_function_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.form_function_id,l_old_prof_module_grp_rec.form_function_id);
439: l_prof_module_grp_rec.responsibility_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.responsibility_id,l_old_prof_module_grp_rec.responsibility_id);
440:
441: l_prof_module_grp_rec.resp_appl_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.resp_appl_id,l_old_prof_module_grp_rec.resp_appl_id);
442:
443: -- Invoke validation procedures
444: Validate_prof_module_groups(
445: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

Line 445: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

441: l_prof_module_grp_rec.resp_appl_id := CSC_CORE_UTILS_PVT.Get_G_Miss_Num(p_prof_module_grp_rec.resp_appl_id,l_old_prof_module_grp_rec.resp_appl_id);
442:
443: -- Invoke validation procedures
444: Validate_prof_module_groups(
445: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
446: p_validation_level => p_validation_level,
447: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
448: P_PROF_MODULE_GRP_Rec => l_PROF_MODULE_GRP_Rec,
449: x_return_status => x_return_status,

Line 447: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,

443: -- Invoke validation procedures
444: Validate_prof_module_groups(
445: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
446: p_validation_level => p_validation_level,
447: p_validation_mode => CSC_CORE_UTILS_PVT.G_UPDATE,
448: P_PROF_MODULE_GRP_Rec => l_PROF_MODULE_GRP_Rec,
449: x_return_status => x_return_status,
450: x_msg_count => x_msg_count,
451: x_msg_data => x_msg_data);

Line 461: p_MODULE_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.MODULE_GROUP_ID,l_old_PROF_MODULE_GRP_rec.MODULE_GROUP_ID),

457:
458:
459: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Update_Row)
460: CSC_PROF_MODULE_GROUPS_PKG.Update_Row(
461: p_MODULE_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.MODULE_GROUP_ID,l_old_PROF_MODULE_GRP_rec.MODULE_GROUP_ID),
462: p_FORM_FUNCTION_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID),
463: p_FORM_FUNCTION_NAME =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME),
464: p_RESPONSIBILITY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID,l_old_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID),
465: p_RESP_APPL_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESP_APPL_ID,l_old_PROF_MODULE_GRP_rec.RESP_APPL_ID),

Line 462: p_FORM_FUNCTION_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID),

458:
459: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Update_Row)
460: CSC_PROF_MODULE_GROUPS_PKG.Update_Row(
461: p_MODULE_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.MODULE_GROUP_ID,l_old_PROF_MODULE_GRP_rec.MODULE_GROUP_ID),
462: p_FORM_FUNCTION_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID),
463: p_FORM_FUNCTION_NAME =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME),
464: p_RESPONSIBILITY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID,l_old_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID),
465: p_RESP_APPL_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESP_APPL_ID,l_old_PROF_MODULE_GRP_rec.RESP_APPL_ID),
466: p_PARTY_TYPE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.PARTY_TYPE,l_old_PROF_MODULE_GRP_rec.PARTY_TYPE),

Line 463: p_FORM_FUNCTION_NAME =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME),

459: -- Invoke table handler(CSC_PROF_MODULE_GROUPS_PKG.Update_Row)
460: CSC_PROF_MODULE_GROUPS_PKG.Update_Row(
461: p_MODULE_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.MODULE_GROUP_ID,l_old_PROF_MODULE_GRP_rec.MODULE_GROUP_ID),
462: p_FORM_FUNCTION_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID),
463: p_FORM_FUNCTION_NAME =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME),
464: p_RESPONSIBILITY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID,l_old_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID),
465: p_RESP_APPL_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESP_APPL_ID,l_old_PROF_MODULE_GRP_rec.RESP_APPL_ID),
466: p_PARTY_TYPE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.PARTY_TYPE,l_old_PROF_MODULE_GRP_rec.PARTY_TYPE),
467: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.GROUP_ID,l_old_PROF_MODULE_GRP_rec.GROUP_ID),

Line 464: p_RESPONSIBILITY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID,l_old_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID),

460: CSC_PROF_MODULE_GROUPS_PKG.Update_Row(
461: p_MODULE_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.MODULE_GROUP_ID,l_old_PROF_MODULE_GRP_rec.MODULE_GROUP_ID),
462: p_FORM_FUNCTION_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID),
463: p_FORM_FUNCTION_NAME =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME),
464: p_RESPONSIBILITY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID,l_old_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID),
465: p_RESP_APPL_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESP_APPL_ID,l_old_PROF_MODULE_GRP_rec.RESP_APPL_ID),
466: p_PARTY_TYPE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.PARTY_TYPE,l_old_PROF_MODULE_GRP_rec.PARTY_TYPE),
467: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.GROUP_ID,l_old_PROF_MODULE_GRP_rec.GROUP_ID),
468: p_DASHBOARD_GROUP_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG,l_old_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG),

Line 465: p_RESP_APPL_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESP_APPL_ID,l_old_PROF_MODULE_GRP_rec.RESP_APPL_ID),

461: p_MODULE_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.MODULE_GROUP_ID,l_old_PROF_MODULE_GRP_rec.MODULE_GROUP_ID),
462: p_FORM_FUNCTION_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID),
463: p_FORM_FUNCTION_NAME =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME),
464: p_RESPONSIBILITY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID,l_old_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID),
465: p_RESP_APPL_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESP_APPL_ID,l_old_PROF_MODULE_GRP_rec.RESP_APPL_ID),
466: p_PARTY_TYPE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.PARTY_TYPE,l_old_PROF_MODULE_GRP_rec.PARTY_TYPE),
467: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.GROUP_ID,l_old_PROF_MODULE_GRP_rec.GROUP_ID),
468: p_DASHBOARD_GROUP_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG,l_old_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG),
469: p_CURRENCY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.CURRENCY_CODE,l_old_PROF_MODULE_GRP_rec.CURRENCY_CODE),

Line 466: p_PARTY_TYPE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.PARTY_TYPE,l_old_PROF_MODULE_GRP_rec.PARTY_TYPE),

462: p_FORM_FUNCTION_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_ID),
463: p_FORM_FUNCTION_NAME =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME),
464: p_RESPONSIBILITY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID,l_old_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID),
465: p_RESP_APPL_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESP_APPL_ID,l_old_PROF_MODULE_GRP_rec.RESP_APPL_ID),
466: p_PARTY_TYPE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.PARTY_TYPE,l_old_PROF_MODULE_GRP_rec.PARTY_TYPE),
467: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.GROUP_ID,l_old_PROF_MODULE_GRP_rec.GROUP_ID),
468: p_DASHBOARD_GROUP_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG,l_old_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG),
469: p_CURRENCY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.CURRENCY_CODE,l_old_PROF_MODULE_GRP_rec.CURRENCY_CODE),
470: p_LAST_UPDATE_DATE => SYSDATE,

Line 467: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.GROUP_ID,l_old_PROF_MODULE_GRP_rec.GROUP_ID),

463: p_FORM_FUNCTION_NAME =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME,l_old_PROF_MODULE_GRP_rec.FORM_FUNCTION_NAME),
464: p_RESPONSIBILITY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID,l_old_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID),
465: p_RESP_APPL_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESP_APPL_ID,l_old_PROF_MODULE_GRP_rec.RESP_APPL_ID),
466: p_PARTY_TYPE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.PARTY_TYPE,l_old_PROF_MODULE_GRP_rec.PARTY_TYPE),
467: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.GROUP_ID,l_old_PROF_MODULE_GRP_rec.GROUP_ID),
468: p_DASHBOARD_GROUP_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG,l_old_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG),
469: p_CURRENCY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.CURRENCY_CODE,l_old_PROF_MODULE_GRP_rec.CURRENCY_CODE),
470: p_LAST_UPDATE_DATE => SYSDATE,
471: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

Line 468: p_DASHBOARD_GROUP_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG,l_old_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG),

464: p_RESPONSIBILITY_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID,l_old_PROF_MODULE_GRP_rec.RESPONSIBILITY_ID),
465: p_RESP_APPL_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESP_APPL_ID,l_old_PROF_MODULE_GRP_rec.RESP_APPL_ID),
466: p_PARTY_TYPE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.PARTY_TYPE,l_old_PROF_MODULE_GRP_rec.PARTY_TYPE),
467: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.GROUP_ID,l_old_PROF_MODULE_GRP_rec.GROUP_ID),
468: p_DASHBOARD_GROUP_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG,l_old_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG),
469: p_CURRENCY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.CURRENCY_CODE,l_old_PROF_MODULE_GRP_rec.CURRENCY_CODE),
470: p_LAST_UPDATE_DATE => SYSDATE,
471: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
472: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN,l_old_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN),

Line 469: p_CURRENCY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.CURRENCY_CODE,l_old_PROF_MODULE_GRP_rec.CURRENCY_CODE),

465: p_RESP_APPL_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.RESP_APPL_ID,l_old_PROF_MODULE_GRP_rec.RESP_APPL_ID),
466: p_PARTY_TYPE =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.PARTY_TYPE,l_old_PROF_MODULE_GRP_rec.PARTY_TYPE),
467: p_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.GROUP_ID,l_old_PROF_MODULE_GRP_rec.GROUP_ID),
468: p_DASHBOARD_GROUP_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG,l_old_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG),
469: p_CURRENCY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.CURRENCY_CODE,l_old_PROF_MODULE_GRP_rec.CURRENCY_CODE),
470: p_LAST_UPDATE_DATE => SYSDATE,
471: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
472: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN,l_old_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN),
473: p_SEEDED_FLAG => csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.SEEDED_FLAG,l_old_PROF_MODULE_GRP_rec.SEEDED_FLAG),

Line 472: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN,l_old_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN),

468: p_DASHBOARD_GROUP_FLAG =>csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG,l_old_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_FLAG),
469: p_CURRENCY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.CURRENCY_CODE,l_old_PROF_MODULE_GRP_rec.CURRENCY_CODE),
470: p_LAST_UPDATE_DATE => SYSDATE,
471: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
472: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN,l_old_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN),
473: p_SEEDED_FLAG => csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.SEEDED_FLAG,l_old_PROF_MODULE_GRP_rec.SEEDED_FLAG),
474: p_APPLICATION_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.APPLICATION_ID,l_old_PROF_MODULE_GRP_rec.APPLICATION_ID),
475: p_DASHBOARD_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_ID,l_old_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_ID));
476: --

Line 473: p_SEEDED_FLAG => csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.SEEDED_FLAG,l_old_PROF_MODULE_GRP_rec.SEEDED_FLAG),

469: p_CURRENCY_CODE => csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.CURRENCY_CODE,l_old_PROF_MODULE_GRP_rec.CURRENCY_CODE),
470: p_LAST_UPDATE_DATE => SYSDATE,
471: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
472: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN,l_old_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN),
473: p_SEEDED_FLAG => csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.SEEDED_FLAG,l_old_PROF_MODULE_GRP_rec.SEEDED_FLAG),
474: p_APPLICATION_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.APPLICATION_ID,l_old_PROF_MODULE_GRP_rec.APPLICATION_ID),
475: p_DASHBOARD_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_ID,l_old_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_ID));
476: --
477: -- End of API body.

Line 474: p_APPLICATION_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.APPLICATION_ID,l_old_PROF_MODULE_GRP_rec.APPLICATION_ID),

470: p_LAST_UPDATE_DATE => SYSDATE,
471: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
472: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN,l_old_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN),
473: p_SEEDED_FLAG => csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.SEEDED_FLAG,l_old_PROF_MODULE_GRP_rec.SEEDED_FLAG),
474: p_APPLICATION_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.APPLICATION_ID,l_old_PROF_MODULE_GRP_rec.APPLICATION_ID),
475: p_DASHBOARD_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_ID,l_old_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_ID));
476: --
477: -- End of API body.
478: --

Line 475: p_DASHBOARD_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_ID,l_old_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_ID));

471: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
472: p_LAST_UPDATE_LOGIN =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN,l_old_PROF_MODULE_GRP_rec.LAST_UPDATE_LOGIN),
473: p_SEEDED_FLAG => csc_core_utils_pvt.Get_G_Miss_Char(p_PROF_MODULE_GRP_rec.SEEDED_FLAG,l_old_PROF_MODULE_GRP_rec.SEEDED_FLAG),
474: p_APPLICATION_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.APPLICATION_ID,l_old_PROF_MODULE_GRP_rec.APPLICATION_ID),
475: p_DASHBOARD_GROUP_ID =>csc_core_utils_pvt.Get_G_Miss_Num(p_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_ID,l_old_PROF_MODULE_GRP_rec.DASHBOARD_GROUP_ID));
476: --
477: -- End of API body.
478: --
479:

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

513:
514:
515: PROCEDURE Delete_prof_module_groups(
516: P_Api_Version_Number IN NUMBER,
517: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
518: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
519: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
520: P_PROF_MODULE_GRP_Id IN NUMBER,
521: X_Return_Status OUT NOCOPY VARCHAR2,

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

514:
515: PROCEDURE Delete_prof_module_groups(
516: P_Api_Version_Number IN NUMBER,
517: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
518: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
519: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
520: P_PROF_MODULE_GRP_Id IN NUMBER,
521: X_Return_Status OUT NOCOPY VARCHAR2,
522: X_Msg_Count OUT NOCOPY NUMBER,

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

515: PROCEDURE Delete_prof_module_groups(
516: P_Api_Version_Number IN NUMBER,
517: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
518: P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
519: p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
520: P_PROF_MODULE_GRP_Id IN NUMBER,
521: X_Return_Status OUT NOCOPY VARCHAR2,
522: X_Msg_Count OUT NOCOPY NUMBER,
523: X_Msg_Data OUT NOCOPY VARCHAR2

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

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

Line 622: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

618: x_return_status := FND_API.G_RET_STS_SUCCESS;
619:
620: -- validate NOT NULL column
621:
622: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
623: THEN
624: -- Hint: Validate data
625: -- IF p_MODULE_GROUP_ID is not NULL and p_MODULE_GROUP_ID <> G_MISS_CHAR
626: -- verify if data is valid

Line 629: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

625: -- IF p_MODULE_GROUP_ID is not NULL and p_MODULE_GROUP_ID <> G_MISS_CHAR
626: -- verify if data is valid
627: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
628: NULL;
629: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
630: THEN
631: -- Hint: Validate data
632: -- IF p_MODULE_GROUP_ID <> G_MISS_CHAR
633: -- verify if data is valid

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

648: END Validate_MODULE_GROUP_ID;
649:
650:
651: PROCEDURE Validate_RESPONSIBILITY_ID (
652: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
653: P_Validation_mode IN VARCHAR2,
654: P_RESPONSIBILITY_ID IN NUMBER,
655: P_RESP_APPL_ID IN NUMBER,
656: X_Return_Status OUT NOCOPY VARCHAR2,

Line 681: IF p_RESPONSIBILITY_ID is not NULL and p_RESPONSIBILITY_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

677:
678: -- Initialize API return status to SUCCESS
679: x_return_status := FND_API.G_RET_STS_SUCCESS;
680:
681: IF p_RESPONSIBILITY_ID is not NULL and p_RESPONSIBILITY_ID <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
682: THEN
683: Open C1;
684: Fetch C1 INTO l_dummy;
685: IF C1%NOTFOUND THEN

Line 687: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

683: Open C1;
684: Fetch C1 INTO l_dummy;
685: IF C1%NOTFOUND THEN
686: x_return_status := FND_API.G_RET_STS_ERROR;
687: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
688: p_api_name => p_api_name,
689: p_argument_value => p_Responsibility_id,
690: p_argument => 'P_RESPONSIBILITY_ID');
691: END IF;

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

702: END Validate_Responsibility_id;
703:
704:
705: PROCEDURE Validate_FORM_FUNCTION_NAME (
706: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
707: P_Validation_mode IN VARCHAR2,
708: P_FORM_FUNCTION_NAME IN VARCHAR2,
709: X_Return_Status OUT NOCOPY VARCHAR2,
710: X_Msg_Count OUT NOCOPY NUMBER,

Line 732: IF p_FORM_FUNCTION_NAME is not NULL and p_FORM_FUNCTION_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

728:
729: -- Initialize API return status to SUCCESS
730: x_return_status := FND_API.G_RET_STS_SUCCESS;
731:
732: IF p_FORM_FUNCTION_NAME is not NULL and p_FORM_FUNCTION_NAME <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
733: THEN
734: Open C1;
735: Fetch C1 INTO l_dummy;
736: IF C1%NOTFOUND THEN

Line 738: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

734: Open C1;
735: Fetch C1 INTO l_dummy;
736: IF C1%NOTFOUND THEN
737: x_return_status := FND_API.G_RET_STS_ERROR;
738: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
739: p_api_name => p_api_name,
740: p_argument_value => p_form_function_name,
741: p_argument => 'P_FORM_FUNCTION_NAME');
742: END IF;

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

751:
752: END Validate_Form_Function_Name;
753:
754: PROCEDURE Validate_FORM_FUNCTION_ID (
755: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
756: P_Validation_mode IN VARCHAR2,
757: P_FORM_FUNCTION_ID IN NUMBER,
758: X_Return_Status OUT NOCOPY VARCHAR2,
759: X_Msg_Count OUT NOCOPY NUMBER,

Line 782: IF p_FORM_FUNCTION_ID is not NULL and p_FORM_FUNCTION_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM

778: -- Initialize API return status to SUCCESS
779: x_return_status := FND_API.G_RET_STS_SUCCESS;
780:
781:
782: IF p_FORM_FUNCTION_ID is not NULL and p_FORM_FUNCTION_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
783: THEN
784: open C1;
785: fetch C1 INTO l_dummy;
786: if C1%NOTFOUND then

Line 789: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

785: fetch C1 INTO l_dummy;
786: if C1%NOTFOUND then
787: -- if the form_function_id is not valid its an invalid argument
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
790: p_api_name => p_api_name,
791: p_argument_value => p_form_function_id,
792: p_argument => 'P_FORM_FUNCTION_ID');
793: end if;

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

803: END Validate_FORM_FUNCTION_ID;
804:
805:
806: PROCEDURE Validate_PARTY_TYPE (
807: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
808: P_Validation_mode IN VARCHAR2,
809: P_PARTY_TYPE IN VARCHAR2,
810: X_Return_Status OUT NOCOPY VARCHAR2,
811: X_Msg_Count OUT NOCOPY NUMBER,

Line 828: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

824:
825: -- Initialize API return status to SUCCESS
826: x_return_status := FND_API.G_RET_STS_SUCCESS;
827:
828: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
829: THEN
830: -- Hint: Validate data
831: -- IF p_PARTY_TYPE is not NULL and p_PARTY_TYPE <> G_MISS_CHAR
832: -- verify if data is valid

Line 834: IF p_PARTY_TYPE is not NULL and p_PARTY_TYPE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

830: -- Hint: Validate data
831: -- IF p_PARTY_TYPE is not NULL and p_PARTY_TYPE <> G_MISS_CHAR
832: -- verify if data is valid
833: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
834: IF p_PARTY_TYPE is not NULL and p_PARTY_TYPE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
835: THEN
836: IF p_PARTY_TYPE NOT IN ('ALL','GROUP','PERSON','ORGANIZATION') THEN
837: x_return_status := FND_API.G_RET_STS_ERROR;
838: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

Line 838: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

834: IF p_PARTY_TYPE is not NULL and p_PARTY_TYPE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
835: THEN
836: IF p_PARTY_TYPE NOT IN ('ALL','GROUP','PERSON','ORGANIZATION') THEN
837: x_return_status := FND_API.G_RET_STS_ERROR;
838: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
839: p_api_name => p_api_name,
840: p_argument_value => p_PARTY_TYPE,
841: p_argument => 'P_PARTY_TYPE');
842: END IF;

Line 844: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

840: p_argument_value => p_PARTY_TYPE,
841: p_argument => 'P_PARTY_TYPE');
842: END IF;
843: END IF;
844: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
845: THEN
846: -- Hint: Validate data
847: -- IF p_PARTY_TYPE <> G_MISS_CHAR
848: -- verify if data is valid

Line 850: IF p_PARTY_TYPE is not NULL and p_PARTY_TYPE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

846: -- Hint: Validate data
847: -- IF p_PARTY_TYPE <> G_MISS_CHAR
848: -- verify if data is valid
849: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
850: IF p_PARTY_TYPE is not NULL and p_PARTY_TYPE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
851: THEN
852: IF p_PARTY_TYPE NOT IN ('ALL','GROUP','PERSON','ORGANIZATION') THEN
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

Line 854: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

850: IF p_PARTY_TYPE is not NULL and p_PARTY_TYPE <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
851: THEN
852: IF p_PARTY_TYPE NOT IN ('ALL','GROUP','PERSON','ORGANIZATION') THEN
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
855: p_api_name => p_api_name,
856: p_argument_value => p_PARTY_TYPE,
857: p_argument => 'P_PARTY_TYPE');
858: END IF;

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

868: END Validate_PARTY_TYPE;
869:
870:
871: PROCEDURE Validate_GROUP_ID (
872: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
873: P_Validation_mode IN VARCHAR2,
874: P_GROUP_ID IN NUMBER,
875: P_PARTY_TYPE IN VARCHAR2,
876: X_Return_Status OUT NOCOPY VARCHAR2,

Line 907: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

903:
904: -- Initialize API return status to SUCCESS
905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906:
907: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
908: THEN
909: -- Hint: Validate data
910: -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> G_MISS_CHAR
911: -- verify if data is valid

Line 913: /* IF p_GROUP_ID = CSC_CORE_UTILS_PVT.G_MISS_NUM

909: -- Hint: Validate data
910: -- IF p_GROUP_ID is not NULL and p_GROUP_ID <> G_MISS_CHAR
911: -- verify if data is valid
912: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
913: /* IF p_GROUP_ID = CSC_CORE_UTILS_PVT.G_MISS_NUM
914: THEN
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: CSC_CORE_UTILS_PVT.mandatory_arg_error(
917: p_api_name => p_api_name,

Line 916: CSC_CORE_UTILS_PVT.mandatory_arg_error(

912: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
913: /* IF p_GROUP_ID = CSC_CORE_UTILS_PVT.G_MISS_NUM
914: THEN
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: CSC_CORE_UTILS_PVT.mandatory_arg_error(
917: p_api_name => p_api_name,
918: p_argument => 'p_GROUP_ID',
919: p_argument_value => p_GROUP_ID);
920: */

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

917: p_api_name => p_api_name,
918: p_argument => 'p_GROUP_ID',
919: p_argument_value => p_GROUP_ID);
920: */
921: IF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
922: THEN
923: Open C1;
924: Fetch C1 into l_dummy;
925: IF C1%NOTFOUND THEN

Line 927: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

923: Open C1;
924: Fetch C1 into l_dummy;
925: IF C1%NOTFOUND THEN
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
928: p_api_name => p_api_name,
929: p_argument_value => p_GROUP_ID,
930: p_argument => 'P_GROUP_ID' );
931: END IF;

Line 934: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

930: p_argument => 'P_GROUP_ID' );
931: END IF;
932: CLOSE C1;
933: END IF;
934: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
935: THEN
936: -- Hint: Validate data
937: -- IF p_GROUP_ID <> G_MISS_CHAR
938: -- verify if data is valid

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

936: -- Hint: Validate data
937: -- IF p_GROUP_ID <> G_MISS_CHAR
938: -- verify if data is valid
939: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
940: IF p_GROUP_ID is not NULL and p_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
941: THEN
942: Open C1;
943: Fetch C1 into l_dummy;
944: IF C1%NOTFOUND THEN

Line 946: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

942: Open C1;
943: Fetch C1 into l_dummy;
944: IF C1%NOTFOUND THEN
945: x_return_status := FND_API.G_RET_STS_ERROR;
946: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
947: p_api_name => p_api_name,
948: p_argument_value => p_GROUP_ID,
949: p_argument => 'P_GROUP_ID' );
950: END IF;

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

961: END Validate_GROUP_ID;
962:
963:
964: PROCEDURE Validate_DASHBOARD_GROUP_FLAG (
965: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
966: P_Validation_mode IN VARCHAR2,
967: P_DASHBOARD_GROUP_FLAG IN VARCHAR2,
968: X_Return_Status OUT NOCOPY VARCHAR2,
969: X_Msg_Count OUT NOCOPY NUMBER,

Line 992: CSC_CORE_UTILS_PVT.mandatory_arg_error(

988: -- validate NOT NULL column
989: IF(p_DASHBOARD_GROUP_FLAG is NULL)
990: THEN
991: x_return_status := FND_API.G_RET_STS_ERROR;
992: CSC_CORE_UTILS_PVT.mandatory_arg_error(
993: p_api_name => p_api_name,
994: p_argument => 'P_DASHBOARD_GROUP_FLAG',
995: p_argument_value => p_dashboard_group_flag);
996: END IF;

Line 998: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

994: p_argument => 'P_DASHBOARD_GROUP_FLAG',
995: p_argument_value => p_dashboard_group_flag);
996: END IF;
997:
998: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
999: THEN
1000: -- Hint: Validate data
1001: -- IF p_DASHBOARD_GROUP_FLAG is not NULL and p_DASHBOARD_GROUP_FLAG <> G_MISS_CHAR
1002: -- verify if data is valid

Line 1005: p_DASHBOARD_GROUP_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

1001: -- IF p_DASHBOARD_GROUP_FLAG is not NULL and p_DASHBOARD_GROUP_FLAG <> G_MISS_CHAR
1002: -- verify if data is valid
1003: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1004: IF p_DASHBOARD_GROUP_FLAG is not NULL AND
1005: p_DASHBOARD_GROUP_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
1006: THEN
1007: IF p_DASHBOARD_GROUP_FLAG NOT IN ('Y','N')
1008: THEN
1009: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1010: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

1006: THEN
1007: IF p_DASHBOARD_GROUP_FLAG NOT IN ('Y','N')
1008: THEN
1009: x_return_status := FND_API.G_RET_STS_ERROR;
1010: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1011: p_api_name => p_api_name,
1012: p_argument_value => p_dashboard_group_flag,
1013: p_argument => 'P_DASHBOARD_GROUP_FLAG');
1014: END IF;

Line 1016: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

1012: p_argument_value => p_dashboard_group_flag,
1013: p_argument => 'P_DASHBOARD_GROUP_FLAG');
1014: END IF;
1015: END IF;
1016: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
1017: THEN
1018: IF p_DASHBOARD_GROUP_FLAG IS NOT NULL AND
1019: p_DASHBOARD_GROUP_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
1020: THEN

Line 1019: p_DASHBOARD_GROUP_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR

1015: END IF;
1016: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
1017: THEN
1018: IF p_DASHBOARD_GROUP_FLAG IS NOT NULL AND
1019: p_DASHBOARD_GROUP_FLAG <> CSC_CORE_UTILS_PVT.G_MISS_CHAR
1020: THEN
1021: IF p_DASHBOARD_GROUP_FLAG NOT IN ('Y','N')
1022: THEN
1023: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1024: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

1020: THEN
1021: IF p_DASHBOARD_GROUP_FLAG NOT IN ('Y','N')
1022: THEN
1023: x_return_status := FND_API.G_RET_STS_ERROR;
1024: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1025: p_api_name => p_api_name,
1026: p_argument_value => p_dashboard_group_flag,
1027: p_argument => 'P_Dashboard_Group_Flag');
1028: END IF;

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

1040: END Validate_DASHBOARD_GROUP_FLAG;
1041:
1042:
1043: PROCEDURE Validate_CURRENCY_CODE (
1044: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1045: P_Validation_mode IN VARCHAR2,
1046: P_CURRENCY_CODE IN VARCHAR2,
1047: X_Return_Status OUT NOCOPY VARCHAR2,
1048: X_Msg_Count OUT NOCOPY NUMBER,

Line 1065: IF (p_currency_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND

1061:
1062: -- Initialize API return status to SUCCESS
1063: x_return_status := FND_API.G_RET_STS_SUCCESS;
1064:
1065: IF (p_currency_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
1066: p_currency_code IS NOT NULL
1067: THEN
1068: IF CSC_CORE_UTILS_PVT.Currency_code_not_exists(
1069: p_effective_date => sysdate,

Line 1068: IF CSC_CORE_UTILS_PVT.Currency_code_not_exists(

1064:
1065: IF (p_currency_Code <> CSC_CORE_UTILS_PVT.G_MISS_CHAR ) AND
1066: p_currency_code IS NOT NULL
1067: THEN
1068: IF CSC_CORE_UTILS_PVT.Currency_code_not_exists(
1069: p_effective_date => sysdate,
1070: p_currency_code => p_currency_code ) <> FND_API.G_RET_STS_SUCCESS
1071: THEN
1072:

Line 1074: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

1070: p_currency_code => p_currency_code ) <> FND_API.G_RET_STS_SUCCESS
1071: THEN
1072:
1073: x_return_status := FND_API.G_RET_STS_ERROR;
1074: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1075: p_api_name => p_api_name,
1076: p_argument_value => p_currency_code,
1077: p_argument => 'P_CURRENCY_CODE');
1078:

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

1087: END Validate_CURRENCY_CODE;
1088:
1089:
1090: PROCEDURE Validate_PROF_MODULE_GRP_Rec(
1091: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1092: P_Validation_mode IN VARCHAR2,
1093: P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type,
1094: X_Return_Status OUT NOCOPY VARCHAR2,
1095: X_Msg_Count OUT NOCOPY NUMBER,

Line 1156: or p_prof_module_grp_rec.group_id = CSC_CORE_UTILS_PVT.G_MISS_NUM )

1152: l_function_name := p_prof_module_grp_rec.form_function_name;
1153: END IF;
1154:
1155: If ( p_prof_module_grp_rec.group_id is null
1156: or p_prof_module_grp_rec.group_id = CSC_CORE_UTILS_PVT.G_MISS_NUM )
1157: and ( p_prof_module_grp_rec.dashboard_group_id is null
1158: or p_prof_module_grp_rec.dashboard_group_id = CSC_CORE_UTILS_PVT.G_MISS_NUM ) then
1159:
1160: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1158: or p_prof_module_grp_rec.dashboard_group_id = CSC_CORE_UTILS_PVT.G_MISS_NUM ) then

1154:
1155: If ( p_prof_module_grp_rec.group_id is null
1156: or p_prof_module_grp_rec.group_id = CSC_CORE_UTILS_PVT.G_MISS_NUM )
1157: and ( p_prof_module_grp_rec.dashboard_group_id is null
1158: or p_prof_module_grp_rec.dashboard_group_id = CSC_CORE_UTILS_PVT.G_MISS_NUM ) then
1159:
1160: x_return_status := FND_API.G_RET_STS_ERROR;
1161: FND_MESSAGE.Set_Name('CSC', 'CSC_PROFILE_GROUP_UNDEFINED');
1162:

Line 1167: if p_Validation_mode = CSC_CORE_UTILS_PVT.G_CREATE then

1163: End If;
1164:
1165:
1166:
1167: if p_Validation_mode = CSC_CORE_UTILS_PVT.G_CREATE then
1168: Open C3(p_prof_module_grp_rec.form_function_name,p_prof_module_grp_rec.party_type,
1169: p_prof_module_grp_rec.responsibility_id, p_prof_module_grp_rec.resp_appl_id);
1170: Fetch C3 into x;
1171: Close C3;

Line 1173: If x<>0 then -- and P_Validation_mode=CSC_CORE_UTILS_PVT.G_CREATE then

1169: p_prof_module_grp_rec.responsibility_id, p_prof_module_grp_rec.resp_appl_id);
1170: Fetch C3 into x;
1171: Close C3;
1172:
1173: If x<>0 then -- and P_Validation_mode=CSC_CORE_UTILS_PVT.G_CREATE then
1174: x_return_status := FND_API.G_RET_STS_ERROR;
1175: FND_MESSAGE.Set_Name('CSC', 'CSC_PROFILE_DUPLICATE_RECORD');
1176: End If;
1177:

Line 1178: elsif p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE then

1174: x_return_status := FND_API.G_RET_STS_ERROR;
1175: FND_MESSAGE.Set_Name('CSC', 'CSC_PROFILE_DUPLICATE_RECORD');
1176: End If;
1177:
1178: elsif p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE then
1179:
1180: Open C4(p_prof_module_grp_rec.form_function_name,p_prof_module_grp_rec.party_type,
1181: p_prof_module_grp_rec.responsibility_id, p_prof_module_grp_rec.resp_appl_id,
1182: p_prof_module_grp_rec.module_group_id);

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

1199: END Validate_PROF_MODULE_GRP_Rec;
1200:
1201:
1202: PROCEDURE Validate_DASHBOARD_GROUP_ID (
1203: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1204: P_Validation_mode IN VARCHAR2,
1205: P_DASHBOARD_GROUP_ID IN NUMBER,
1206: P_PARTY_TYPE IN VARCHAR2,
1207: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1238: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)

1234:
1235: -- Initialize API return status to SUCCESS
1236: x_return_status := FND_API.G_RET_STS_SUCCESS;
1237:
1238: IF(p_validation_mode = CSC_CORE_UTILS_PVT.G_CREATE)
1239: THEN
1240: -- Hint: Validate data
1241: -- IF p_DASHBOARD_GROUP_ID is not NULL and p_DASHBOARD_GROUP_ID <> G_MISS_CHAR
1242: -- verify if data is valid

Line 1245: IF p_DASHBOARD_GROUP_ID is not NULL and p_DASHBOARD_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM

1241: -- IF p_DASHBOARD_GROUP_ID is not NULL and p_DASHBOARD_GROUP_ID <> G_MISS_CHAR
1242: -- verify if data is valid
1243: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1244:
1245: IF p_DASHBOARD_GROUP_ID is not NULL and p_DASHBOARD_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
1246: THEN
1247: Open C1;
1248: Fetch C1 into l_dummy;
1249: IF C1%NOTFOUND THEN

Line 1251: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

1247: Open C1;
1248: Fetch C1 into l_dummy;
1249: IF C1%NOTFOUND THEN
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1252: p_api_name => p_api_name,
1253: p_argument_value => p_DASHBOARD_GROUP_ID,
1254: p_argument => 'P_DASHBOARD_GROUP_ID' );
1255: END IF;

Line 1258: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)

1254: p_argument => 'P_DASHBOARD_GROUP_ID' );
1255: END IF;
1256: CLOSE C1;
1257: END IF;
1258: ELSIF(p_validation_mode = CSC_CORE_UTILS_PVT.G_UPDATE)
1259: THEN
1260: -- Hint: Validate data
1261: -- IF p_DASHBOARD_GROUP_ID <> G_MISS_CHAR
1262: -- verify if data is valid

Line 1264: IF p_DASHBOARD_GROUP_ID is not NULL and p_DASHBOARD_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM

1260: -- Hint: Validate data
1261: -- IF p_DASHBOARD_GROUP_ID <> G_MISS_CHAR
1262: -- verify if data is valid
1263: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1264: IF p_DASHBOARD_GROUP_ID is not NULL and p_DASHBOARD_GROUP_ID <> CSC_CORE_UTILS_PVT.G_MISS_NUM
1265: THEN
1266: Open C1;
1267: Fetch C1 into l_dummy;
1268: IF C1%NOTFOUND THEN

Line 1270: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(

1266: Open C1;
1267: Fetch C1 into l_dummy;
1268: IF C1%NOTFOUND THEN
1269: x_return_status := FND_API.G_RET_STS_ERROR;
1270: CSC_CORE_UTILS_PVT.Add_Invalid_Argument_Msg(
1271: p_api_name => p_api_name,
1272: p_argument_value => p_DASHBOARD_GROUP_ID,
1273: p_argument => 'P_DASHBOARD_GROUP_ID' );
1274: END IF;

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

1286:
1287:
1288:
1289: PROCEDURE Validate_prof_module_groups(
1290: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1291: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1292: P_Validation_mode IN VARCHAR2,
1293: P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type,
1294: X_Return_Status OUT NOCOPY VARCHAR2,

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

1287:
1288:
1289: PROCEDURE Validate_prof_module_groups(
1290: P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
1291: P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
1292: P_Validation_mode IN VARCHAR2,
1293: P_PROF_MODULE_GRP_Rec IN PROF_MODULE_GRP_Rec_Type,
1294: X_Return_Status OUT NOCOPY VARCHAR2,
1295: X_Msg_Count OUT NOCOPY NUMBER,

Line 1306: IF (p_validation_level > CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN

1302:
1303: -- Initialize API return status to SUCCESS
1304: x_return_status := FND_API.G_RET_STS_SUCCESS;
1305:
1306: IF (p_validation_level > CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN
1307:
1308: Validate_MODULE_GROUP_ID(
1309: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1310: p_validation_mode => p_validation_mode,

Line 1309: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1305:
1306: IF (p_validation_level > CSC_CORE_UTILS_PVT.G_VALID_LEVEL_NONE) THEN
1307:
1308: Validate_MODULE_GROUP_ID(
1309: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1310: p_validation_mode => p_validation_mode,
1311: p_MODULE_GROUP_ID => P_PROF_MODULE_GRP_Rec.MODULE_GROUP_ID,
1312: x_return_status => x_return_status,
1313: x_msg_count => x_msg_count,

Line 1320: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1316: raise FND_API.G_EXC_ERROR;
1317: END IF;
1318:
1319: /* Validate_FORM_FUNCTION_ID(
1320: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1321: p_validation_mode => p_validation_mode,
1322: p_FORM_FUNCTION_ID => P_PROF_MODULE_GRP_Rec.FORM_FUNCTION_ID,
1323: x_return_status => x_return_status,
1324: x_msg_count => x_msg_count,

Line 1332: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1328: END IF;
1329: */
1330:
1331: Validate_FORM_FUNCTION_NAME(
1332: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1333: p_validation_mode => p_validation_mode,
1334: p_FORM_FUNCTION_NAME => P_PROF_MODULE_GRP_Rec.FORM_FUNCTION_NAME,
1335: x_return_status => x_return_status,
1336: x_msg_count => x_msg_count,

Line 1343: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1339: raise FND_API.G_EXC_ERROR;
1340: END IF;
1341:
1342: Validate_FORM_FUNCTION_NAME(
1343: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1344: p_validation_mode => p_validation_mode,
1345: p_FORM_FUNCTION_NAME => P_PROF_MODULE_GRP_Rec.FORM_FUNCTION_NAME,
1346: x_return_status => x_return_status,
1347: x_msg_count => x_msg_count,

Line 1354: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1350: raise FND_API.G_EXC_ERROR;
1351: END IF;
1352:
1353: Validate_PARTY_TYPE(
1354: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1355: p_validation_mode => p_validation_mode,
1356: p_PARTY_TYPE => P_PROF_MODULE_GRP_Rec.PARTY_TYPE,
1357: x_return_status => x_return_status,
1358: x_msg_count => x_msg_count,

Line 1365: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1361: raise FND_API.G_EXC_ERROR;
1362: END IF;
1363:
1364: Validate_GROUP_ID(
1365: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1366: p_validation_mode => p_validation_mode,
1367: p_GROUP_ID => P_PROF_MODULE_GRP_Rec.GROUP_ID,
1368: P_PARTY_TYPE => P_PROF_MODULE_GRP_Rec.PARTY_TYPE,
1369: x_return_status => x_return_status,

Line 1377: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1373: raise FND_API.G_EXC_ERROR;
1374: END IF;
1375:
1376: /* Validate_DASHBOARD_GROUP_FLAG(
1377: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1378: p_validation_mode => p_validation_mode,
1379: p_DASHBOARD_GROUP_FLAG => P_PROF_MODULE_GRP_Rec.DASHBOARD_GROUP_FLAG,
1380: x_return_status => x_return_status,
1381: x_msg_count => x_msg_count,

Line 1389: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1385: END IF;
1386: */
1387:
1388: Validate_CURRENCY_CODE(
1389: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1390: p_validation_mode => p_validation_mode,
1391: p_CURRENCY_CODE => P_PROF_MODULE_GRP_Rec.CURRENCY_CODE,
1392: x_return_status => x_return_status,
1393: x_msg_count => x_msg_count,

Line 1401: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(

1397: END IF;
1398:
1399: --Validate seeded flag
1400:
1401: CSC_CORE_UTILS_PVT.Validate_Seeded_Flag(
1402: p_api_name =>'CSC_PROF_MODULE_GROUPS_PVT.VALIDATE_SEEDED_FLAG',
1403: p_seeded_flag => p_PROF_MODULE_GRP_rec.seeded_flag,
1404: x_return_status => x_return_status );
1405:

Line 1412: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (

1408: END IF;
1409:
1410: /* This Call added for Enhancement 1781726 for Validating Application_id*/
1411:
1412: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (
1413: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
1414: P_Application_ID => p_PROF_MODULE_GRP_rec.application_id,
1415: X_Return_Status => x_return_status,
1416: X_Msg_Count => x_msg_count,

Line 1413: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,

1409:
1410: /* This Call added for Enhancement 1781726 for Validating Application_id*/
1411:
1412: CSC_CORE_UTILS_PVT.Validate_APPLICATION_ID (
1413: P_Init_Msg_List => CSC_CORE_UTILS_PVT.G_FALSE,
1414: P_Application_ID => p_PROF_MODULE_GRP_rec.application_id,
1415: X_Return_Status => x_return_status,
1416: X_Msg_Count => x_msg_count,
1417: X_Msg_Data => x_msg_data,

Line 1425: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1421: RAISE FND_API.G_EXC_ERROR;
1422: END IF;
1423:
1424: Validate_DASHBOARD_GROUP_ID(
1425: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1426: p_validation_mode => p_validation_mode,
1427: p_DASHBOARD_GROUP_ID => P_PROF_MODULE_GRP_Rec.DASHBOARD_GROUP_ID,
1428:
1429: P_PARTY_TYPE => P_PROF_MODULE_GRP_Rec.PARTY_TYPE,

Line 1438: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,

1434: raise FND_API.G_EXC_ERROR;
1435: END IF;
1436:
1437: Validate_PROF_MODULE_GRP_Rec(
1438: p_init_msg_list => CSC_CORE_UTILS_PVT.G_FALSE,
1439: p_validation_mode => p_validation_mode,
1440: p_PROF_MODULE_GRP_Rec => P_PROF_MODULE_GRP_Rec,
1441: x_return_status => x_return_status,
1442: x_msg_count => x_msg_count,