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 509: PVX_UTILITY_PVT.debug_message('API: ' || l_api_name || ' - start');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2485: WHEN PVX_Utility_PVT.resource_locked THEN

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

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

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