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.CSF_RES_GROUP_ROLE_PVT dependencies on FND_LOG

Line 13: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);

9:
10: g_pkg_name CONSTANT VARCHAR2(30) := 'CSF_RES_GROUP_ROLE_PVT';
11: g_file_name CONSTANT VARCHAR2(12) := 'csfvrsgb.pls';
12: g_debug VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
13: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
14:
15: PROCEDURE INSERT_GROUP_ROLES(P_API_VERSION IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 56: Debug_Message('Entering INSERT_GROUP_ROLES', 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);

52: and nvl(delete_flag, 'N') <> 'Y';
53:
54: BEGIN
55:
56: Debug_Message('Entering INSERT_GROUP_ROLES', 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
57:
58: --Check for and existing group member exists for the concerned group and resource
59: OPEN c_group_member_id_exists(l_group_id,l_resource_id);
60: FETCH c_group_member_id_exists INTO l_group_member_id_exists;

Line 63: Debug_Message('group member does not exist calling jtf_rs_group_members_pub.create_resource_group_members', 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);

59: OPEN c_group_member_id_exists(l_group_id,l_resource_id);
60: FETCH c_group_member_id_exists INTO l_group_member_id_exists;
61:
62: IF c_group_member_id_exists%NOTFOUND THEN
63: Debug_Message('group member does not exist calling jtf_rs_group_members_pub.create_resource_group_members', 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
64: jtf_rs_group_members_pub.create_resource_group_members
65: (P_API_VERSION => l_api_version,
66: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
67: P_COMMIT => P_COMMIT,

Line 78: Debug_Message('jtf_rs_group_members_pub.create_resource_group_members Successful,X_GROUP_MEMBER_ID'||X_GROUP_MEMBER_ID, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);

74: X_MSG_DATA => X_MSG_DATA,
75: X_GROUP_MEMBER_ID => X_GROUP_MEMBER_ID
76: );
77: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN
78: Debug_Message('jtf_rs_group_members_pub.create_resource_group_members Successful,X_GROUP_MEMBER_ID'||X_GROUP_MEMBER_ID, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
79: l_role_resource_id := X_GROUP_MEMBER_ID;
80: END IF;
81: ELSE
82: Debug_Message('Group Member Id Exists,value='||l_group_member_id_exists, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);

Line 82: Debug_Message('Group Member Id Exists,value='||l_group_member_id_exists, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);

78: Debug_Message('jtf_rs_group_members_pub.create_resource_group_members Successful,X_GROUP_MEMBER_ID'||X_GROUP_MEMBER_ID, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
79: l_role_resource_id := X_GROUP_MEMBER_ID;
80: END IF;
81: ELSE
82: Debug_Message('Group Member Id Exists,value='||l_group_member_id_exists, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
83: l_role_resource_id := l_group_member_id_exists;
84: END IF;
85:
86: IF (l_role_resource_id IS NOT NULL and l_role_id IS NOT NULL) THEN

Line 87: Debug_Message('l_role_resource_id='||l_role_resource_id, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);

83: l_role_resource_id := l_group_member_id_exists;
84: END IF;
85:
86: IF (l_role_resource_id IS NOT NULL and l_role_id IS NOT NULL) THEN
87: Debug_Message('l_role_resource_id='||l_role_resource_id, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
88: Debug_Message('l_role_id = '||l_role_id, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
89: Debug_Message('Calling jtf_rs_role_relate_pub.create_resource_role_relate', 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
90: jtf_rs_role_relate_pub.create_resource_role_relate
91: (P_API_VERSION => l_api_version,

Line 88: Debug_Message('l_role_id = '||l_role_id, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);

84: END IF;
85:
86: IF (l_role_resource_id IS NOT NULL and l_role_id IS NOT NULL) THEN
87: Debug_Message('l_role_resource_id='||l_role_resource_id, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
88: Debug_Message('l_role_id = '||l_role_id, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
89: Debug_Message('Calling jtf_rs_role_relate_pub.create_resource_role_relate', 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
90: jtf_rs_role_relate_pub.create_resource_role_relate
91: (P_API_VERSION => l_api_version,
92: P_INIT_MSG_LIST => P_INIT_MSG_LIST,

Line 89: Debug_Message('Calling jtf_rs_role_relate_pub.create_resource_role_relate', 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);

85:
86: IF (l_role_resource_id IS NOT NULL and l_role_id IS NOT NULL) THEN
87: Debug_Message('l_role_resource_id='||l_role_resource_id, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
88: Debug_Message('l_role_id = '||l_role_id, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
89: Debug_Message('Calling jtf_rs_role_relate_pub.create_resource_role_relate', 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
90: jtf_rs_role_relate_pub.create_resource_role_relate
91: (P_API_VERSION => l_api_version,
92: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
93: P_COMMIT => P_COMMIT,

Line 106: Debug_Message('jtf_rs_role_relate_pub.create_resource_role_relate Successful,X_ROLE_RELATE_ID='||X_ROLE_RELATE_ID, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);

102: X_MSG_DATA => X_MSG_DATA,
103: X_ROLE_RELATE_ID => X_ROLE_RELATE_ID
104: );
105: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN
106: Debug_Message('jtf_rs_role_relate_pub.create_resource_role_relate Successful,X_ROLE_RELATE_ID='||X_ROLE_RELATE_ID, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
107: END IF;
108: END IF;
109:
110: IF c_group_member_id_exists%ISOPEN THEN

Line 120: Debug_Message('In Exception Block of INSERT_GROUP_ROLES'||l_msg_data, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);

116: WHEN OTHERS THEN
117: l_error_code := SQLCODE;
118: l_error_msg := SQLERRM;
119: l_msg_data := 'Unexpected Error -'||l_error_code||' : '||l_error_msg;
120: Debug_Message('In Exception Block of INSERT_GROUP_ROLES'||l_msg_data, 'CSF_RES_GROUP_ROLE_PVT.INSERT_GROUP_ROLES', fnd_log.level_procedure);
121: END INSERT_GROUP_ROLES;
122:
123: PROCEDURE DELETE_GROUP_ROLES(P_API_VERSION IN NUMBER,
124: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 160: Debug_Message('Calling jtf_rs_role_relate_pub.delete_resource_role_relate,l_role_relate_id'||l_role_relate_id, 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);

156:
157: BEGIN
158: --Call Role Delete API First
159: IF l_role_relate_id IS NOT NULL THEN
160: Debug_Message('Calling jtf_rs_role_relate_pub.delete_resource_role_relate,l_role_relate_id'||l_role_relate_id, 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);
161: jtf_rs_role_relate_pub.delete_resource_role_relate
162: (P_API_VERSION => l_api_version,
163: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
164: P_COMMIT => P_COMMIT,

Line 172: Debug_Message('Call to jtf_rs_role_relate_pub.delete_resource_role_relate Successful', 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);

168: X_MSG_COUNT => X_MSG_COUNT,
169: X_MSG_DATA => X_MSG_DATA
170: );
171: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN
172: Debug_Message('Call to jtf_rs_role_relate_pub.delete_resource_role_relate Successful', 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);
173: l_role_deleted := TRUE;
174: END IF;
175: ELSE
176: Debug_Message('No Roles Associated setting l_role_deleted to true', 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);

Line 176: Debug_Message('No Roles Associated setting l_role_deleted to true', 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);

172: Debug_Message('Call to jtf_rs_role_relate_pub.delete_resource_role_relate Successful', 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);
173: l_role_deleted := TRUE;
174: END IF;
175: ELSE
176: Debug_Message('No Roles Associated setting l_role_deleted to true', 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);
177: --No Role Present set l_role_deleted to true for group deletion to occur
178: l_role_deleted := TRUE;
179: END IF;
180:

Line 186: Debug_Message('No more Roles left in the Group, calling jtf_rs_group_members_pub.delete_resource_group_members', 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);

182: OPEN c_csf_res_role_relation_id(l_group_member_id);
183: FETCH c_csf_res_role_relation_id INTO l_check_res_role_relate_id;
184:
185: IF c_csf_res_role_relation_id%NOTFOUND THEN
186: Debug_Message('No more Roles left in the Group, calling jtf_rs_group_members_pub.delete_resource_group_members', 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);
187: jtf_rs_group_members_pub.delete_resource_group_members
188: (P_API_VERSION => l_api_version,
189: P_INIT_MSG_LIST => P_INIT_MSG_LIST,
190: P_COMMIT => P_COMMIT,

Line 201: Debug_Message('Call to jtf_rs_group_members_pub.delete_resource_group_members Successful', 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);

197: X_MSG_COUNT => X_MSG_COUNT,
198: X_MSG_DATA => X_MSG_DATA
199: );
200: IF (X_RETURN_STATUS = fnd_api.g_ret_sts_success) THEN
201: Debug_Message('Call to jtf_rs_group_members_pub.delete_resource_group_members Successful', 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);
202: END IF;
203: END IF;
204: END IF;
205:

Line 216: Debug_Message('In Exception Block of DELETE_GROUP_ROLES'||l_msg_data, 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);

212: WHEN OTHERS THEN
213: l_error_code := SQLCODE;
214: l_error_msg := SQLERRM;
215: l_msg_data := 'Unexpected Error -'||l_error_code||' : '||l_error_msg;
216: Debug_Message('In Exception Block of DELETE_GROUP_ROLES'||l_msg_data, 'CSF_RES_GROUP_ROLE_PVT.DELETE_GROUP_ROLES', fnd_log.level_procedure);
217: END DELETE_GROUP_ROLES;
218:
219: PROCEDURE Debug_Message(p_message VARCHAR2, p_module VARCHAR2, p_level NUMBER)
220: IS

Line 223: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

219: PROCEDURE Debug_Message(p_message VARCHAR2, p_module VARCHAR2, p_level NUMBER)
220: IS
221: BEGIN
222: IF g_debug = 'Y' AND p_level >= g_debug_level THEN
223: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
224: THEN
225: fnd_log.string(p_level, 'csf.plsql.csfvrsgb.' || p_module, p_message);
226: END IF;
227: END IF;

Line 225: fnd_log.string(p_level, 'csf.plsql.csfvrsgb.' || p_module, p_message);

221: BEGIN
222: IF g_debug = 'Y' AND p_level >= g_debug_level THEN
223: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
224: THEN
225: fnd_log.string(p_level, 'csf.plsql.csfvrsgb.' || p_module, p_message);
226: END IF;
227: END IF;
228: END Debug_Message;
229: