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.PV_USER_MGMT_PVT dependencies on PVX_UTILITY_PVT

Line 138: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');

134: END IF;
135:
136: -- Debug Message
137: IF (PV_DEBUG_HIGH_ON) THEN
138: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');
139: END IF;
140:
141:
142: -- Initialize API return status to SUCCESS

Line 164: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_person_rel_party_id =' || to_char(l_person_rel_party_id));

160: close c_get_user_details;
161:
162: l_person_rel_party_id := p_partner_user_rec.person_rel_party_id;
163: IF (PV_DEBUG_HIGH_ON) THEN
164: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_person_rel_party_id =' || to_char(l_person_rel_party_id));
165: END IF;
166:
167:
168: --get resource id into l_resource_id number

Line 174: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_resource_exists := true');

170: fetch c_get_resource_id into l_resource_id, l_resource_number, l_user_id, l_object_version_number;
171: if (c_get_resource_id%FOUND) then
172: l_resource_exists := true;
173: IF (PV_DEBUG_HIGH_ON) THEN
174: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_resource_exists := true');
175: END IF;
176:
177: end if;
178: close c_get_resource_id;

Line 202: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_resource_exists := false');

198:
199:
200: if (l_resource_exists = false) then
201: IF (PV_DEBUG_HIGH_ON) THEN
202: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_resource_exists := false');
203: END IF;
204: resourceRec.source_last_name := l_person_last_name;
205: resourceRec.source_first_name := l_person_first_name;
206: resourceRec.user_name := upper(p_partner_user_rec.user_Name);

Line 215: --PVX_UTILITY_PVT.debug_message('admin resource');

211: resourceRec.source_name := l_person_first_name || ' ' || l_person_last_name;
212: resourceRec.resource_name := resourceRec.source_name;
213: resourceRec.source_org_id := l_partner_id;
214: resourceRec.source_org_name := l_org_party_name;
215: --PVX_UTILITY_PVT.debug_message('admin resource');
216: PVX_Misc_PVT.Admin_Resource
217: (
218: p_api_version => p_api_version_number
219: ,p_init_msg_list => FND_API.g_false

Line 244: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_role_exists := true');

240: fetch c_get_role_relate_id into l_role_relate_id;
241: if (c_get_role_relate_id%FOUND) then
242: l_role_exists := true;
243: IF (PV_DEBUG_HIGH_ON) THEN
244: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_role_exists := true');
245: END IF;
246: end if;
247: close c_get_role_relate_id;
248: end if;

Line 254: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_role_exists := false');

250:
251:
252: if (l_role_exists = false) then
253: IF (PV_DEBUG_HIGH_ON) THEN
254: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_role_exists := false');
255: END IF;
256: resourceRec.role_resource_id := l_resource_id;
257: resourceRec.role_resource_type := 'RS_INDIVIDUAL';
258: resourceRec.role_code := 'PARTNER_CONTACT_MEMBER';

Line 259: --PVX_UTILITY_PVT.debug_message('admin role for individual');

255: END IF;
256: resourceRec.role_resource_id := l_resource_id;
257: resourceRec.role_resource_type := 'RS_INDIVIDUAL';
258: resourceRec.role_code := 'PARTNER_CONTACT_MEMBER';
259: --PVX_UTILITY_PVT.debug_message('admin role for individual');
260: PVX_Misc_PVT.Admin_Role
261: (
262: p_api_version => p_api_version_number
263: ,p_init_msg_list => FND_API.g_false

Line 288: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_group_assigned := true');

284: fetch c_get_group_member_id into l_group_member_id;
285: if (c_get_group_member_id%FOUND) then
286: l_group_assigned := true;
287: IF (PV_DEBUG_HIGH_ON) THEN
288: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_group_assigned := true');
289: END IF;
290: end if;
291: close c_get_group_member_id;
292: end if;

Line 298: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_group_assigned := false');

294:
295:
296: if (l_group_assigned = false) then
297: IF (PV_DEBUG_HIGH_ON) THEN
298: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_group_assigned := false');
299: END IF;
300: resourceRec.role_resource_id := l_resource_id;
301: resourceRec.resource_number := l_resource_number;
302: resourceRec.group_id := l_partner_group_id;

Line 304: --PVX_UTILITY_PVT.debug_message('admin group member');

300: resourceRec.role_resource_id := l_resource_id;
301: resourceRec.resource_number := l_resource_number;
302: resourceRec.group_id := l_partner_group_id;
303:
304: --PVX_UTILITY_PVT.debug_message('admin group member');
305: PVX_Misc_PVT.Admin_Group_Member
306: (
307: p_api_version => p_api_version_number
308: ,p_init_msg_list => FND_API.g_false

Line 325: --PVX_UTILITY_PVT.debug_message('l_group_member_id =' || to_char(l_group_member_id));

321: RAISE FND_API.G_EXC_ERROR;
322: END IF;
323: end if;
324:
325: --PVX_UTILITY_PVT.debug_message('l_group_member_id =' || to_char(l_group_member_id));
326:
327:
328: if (l_resource_exists = true and l_group_assigned = true) then
329: open c_get_group_role_assigned (l_group_member_id) ;

Line 334: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_group_role_assigned := true');

330: fetch c_get_group_role_assigned into l_role_relate_id;
331: if (c_get_group_role_assigned%FOUND) then
332: l_group_role_assigned := true;
333: IF (PV_DEBUG_HIGH_ON) THEN
334: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_group_role_assigned := true');
335: END IF;
336: end if;
337: close c_get_group_role_assigned;
338: end if;

Line 344: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_group_role_assigned := false');

340:
341:
342: if (l_group_role_assigned = false) then
343: IF (PV_DEBUG_HIGH_ON) THEN
344: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - l_group_role_assigned := false');
345: END IF;
346: resourceRec.role_resource_id := l_group_member_id;
347: resourceRec.role_resource_type := 'RS_GROUP_MEMBER';
348: resourceRec.role_code := 'PARTNER_CONTACT_MEMBER';

Line 350: --PVX_UTILITY_PVT.debug_message('admin role for group');

346: resourceRec.role_resource_id := l_group_member_id;
347: resourceRec.role_resource_type := 'RS_GROUP_MEMBER';
348: resourceRec.role_code := 'PARTNER_CONTACT_MEMBER';
349:
350: --PVX_UTILITY_PVT.debug_message('admin role for group');
351: PVX_Misc_PVT.Admin_Role
352: (
353: p_api_version => p_api_version_number
354: ,p_init_msg_list => FND_API.g_false

Line 510: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');

506: END IF;
507:
508: -- Debug Message
509: IF (PV_DEBUG_HIGH_ON) THEN
510: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');
511: END IF;
512:
513:
514: -- Initialize API return status to SUCCESS

Line 731: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');

727:
728: -- Debug Message
729: IF (PV_DEBUG_HIGH_ON) THEN
730:
731: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');
732: END IF;
733:
734:
735: -- Initialize API return status to SUCCESS

Line 947: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');

943:
944: -- Debug Message
945: IF (PV_DEBUG_HIGH_ON) THEN
946:
947: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');
948: END IF;
949:
950:
951: -- Initialize API return status to SUCCESS

Line 1198: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');

1194:
1195: -- Debug Message
1196: IF (PV_DEBUG_HIGH_ON) THEN
1197:
1198: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');
1199: END IF;
1200:
1201:
1202: -- Initialize API return status to SUCCESS

Line 1465: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');

1461:
1462: -- Debug Message
1463: IF (PV_DEBUG_HIGH_ON) THEN
1464:
1465: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');
1466: END IF;
1467:
1468:
1469: -- Initialize API return status to SUCCESS

Line 1722: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');

1718:
1719: -- Debug Message
1720: IF (PV_DEBUG_HIGH_ON) THEN
1721:
1722: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');
1723: END IF;
1724:
1725:
1726: -- Initialize API return status to SUCCESS

Line 2315: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');

2311: l_nextval NUMBER;
2312:
2313: BEGIN
2314: IF (PV_DEBUG_HIGH_ON) THEN
2315: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
2316: END IF;
2317:
2318: x_return_status := FND_API.G_RET_STS_SUCCESS;
2319:

Line 2324: PVX_UTILITY_PVT.debug_message('x.program_id = ' || x.program_id);

2320: FOR x IN c_get_program_info LOOP
2321: l_prereq_exist := false;
2322: l_no_membership := false;
2323: IF (PV_DEBUG_HIGH_ON) THEN
2324: PVX_UTILITY_PVT.debug_message('x.program_id = ' || x.program_id);
2325: PVX_UTILITY_PVT.debug_message('p_partner_id = ' || p_partner_id);
2326: END IF;
2327: FOR y IN c_get_prereq(x.program_id) LOOP
2328: l_prereq_exist := true;

Line 2325: PVX_UTILITY_PVT.debug_message('p_partner_id = ' || p_partner_id);

2321: l_prereq_exist := false;
2322: l_no_membership := false;
2323: IF (PV_DEBUG_HIGH_ON) THEN
2324: PVX_UTILITY_PVT.debug_message('x.program_id = ' || x.program_id);
2325: PVX_UTILITY_PVT.debug_message('p_partner_id = ' || p_partner_id);
2326: END IF;
2327: FOR y IN c_get_prereq(x.program_id) LOOP
2328: l_prereq_exist := true;
2329: IF (PV_DEBUG_HIGH_ON) THEN

Line 2330: PVX_UTILITY_PVT.debug_message('y.change_from_program_id = ' || y.change_from_program_id);

2326: END IF;
2327: FOR y IN c_get_prereq(x.program_id) LOOP
2328: l_prereq_exist := true;
2329: IF (PV_DEBUG_HIGH_ON) THEN
2330: PVX_UTILITY_PVT.debug_message('y.change_from_program_id = ' || y.change_from_program_id);
2331: END IF;
2332: FOR z IN c_is_no_prereq_membership(y.change_from_program_id, p_partner_id) LOOP
2333: l_no_membership := true;
2334: IF (PV_DEBUG_HIGH_ON) THEN

Line 2335: PVX_UTILITY_PVT.debug_message('prereq exists but no active membership.');

2331: END IF;
2332: FOR z IN c_is_no_prereq_membership(y.change_from_program_id, p_partner_id) LOOP
2333: l_no_membership := true;
2334: IF (PV_DEBUG_HIGH_ON) THEN
2335: PVX_UTILITY_PVT.debug_message('prereq exists but no active membership.');
2336: END IF;
2337: END LOOP;
2338: EXIT WHEN l_no_membership;
2339: END LOOP;

Line 2390: PVX_UTILITY_PVT.debug_message('l_rule_id_tbl(1) = ' || l_rule_id_tbl(1));

2386: ELSE
2387: l_rule_id_tbl.extend;
2388: l_rule_id_tbl(1) := x.prereq_process_rule_id;
2389: IF (PV_DEBUG_HIGH_ON) THEN
2390: PVX_UTILITY_PVT.debug_message('l_rule_id_tbl(1) = ' || l_rule_id_tbl(1));
2391: END IF;
2392:
2393: PV_RULE_EVALUATION_PUB.quick_partner_eval_outcome(
2394: p_api_version => p_api_version_number

Line 2408: PVX_UTILITY_PVT.debug_message('x_return_status = ' || x_return_status);

2404: );
2405:
2406: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2407: IF (PV_DEBUG_HIGH_ON) THEN
2408: PVX_UTILITY_PVT.debug_message('x_return_status = ' || x_return_status);
2409: END IF;
2410: RAISE FND_API.G_EXC_ERROR;
2411: END IF;
2412:

Line 2414: PVX_UTILITY_PVT.debug_message('l_rule_pass_flag = '||l_rule_pass_flag);

2410: RAISE FND_API.G_EXC_ERROR;
2411: END IF;
2412:
2413: IF (PV_DEBUG_HIGH_ON) THEN
2414: PVX_UTILITY_PVT.debug_message('l_rule_pass_flag = '||l_rule_pass_flag);
2415: END IF;
2416:
2417: IF (l_rule_pass_flag = 'PASS') THEN
2418: IF (PV_DEBUG_HIGH_ON) THEN

Line 2419: PVX_UTILITY_PVT.debug_message('PASS: x.program_id = '|| x.program_id);

2415: END IF;
2416:
2417: IF (l_rule_pass_flag = 'PASS') THEN
2418: IF (PV_DEBUG_HIGH_ON) THEN
2419: PVX_UTILITY_PVT.debug_message('PASS: x.program_id = '|| x.program_id);
2420: PVX_UTILITY_PVT.debug_message('PASS: p_partner_id = '|| p_partner_id);
2421: END IF;
2422: OPEN c_elig_program_id_seq;
2423: FETCH c_elig_program_id_seq INTO l_nextval;

Line 2420: PVX_UTILITY_PVT.debug_message('PASS: p_partner_id = '|| p_partner_id);

2416:
2417: IF (l_rule_pass_flag = 'PASS') THEN
2418: IF (PV_DEBUG_HIGH_ON) THEN
2419: PVX_UTILITY_PVT.debug_message('PASS: x.program_id = '|| x.program_id);
2420: PVX_UTILITY_PVT.debug_message('PASS: p_partner_id = '|| p_partner_id);
2421: END IF;
2422: OPEN c_elig_program_id_seq;
2423: FETCH c_elig_program_id_seq INTO l_nextval;
2424: CLOSE c_elig_program_id_seq;

Line 2472: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');

2468: END LOOP;
2469:
2470: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2471: IF (PV_DEBUG_HIGH_ON) THEN
2472: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
2473: END IF;
2474: END IF;
2475:
2476: FND_MSG_PUB.Count_And_Get (

Line 2488: WHEN PVX_Utility_PVT.resource_locked THEN

2484: COMMIT WORK;
2485: END IF;
2486:
2487: EXCEPTION
2488: WHEN PVX_Utility_PVT.resource_locked THEN
2489: x_return_status := FND_API.g_ret_sts_error;
2490: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2491:
2492: WHEN FND_API.G_EXC_ERROR THEN

Line 2490: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

2486:
2487: EXCEPTION
2488: WHEN PVX_Utility_PVT.resource_locked THEN
2489: x_return_status := FND_API.g_ret_sts_error;
2490: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
2491:
2492: WHEN FND_API.G_EXC_ERROR THEN
2493: x_return_status := FND_API.G_RET_STS_ERROR;
2494: -- Standard call to get message count and if count=1, get the message