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

Line 196: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

192: END IF;
193:
194:
195: -- Debug info.
196: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
197: hz_utility_v2pub.debug(p_message=>'get_cont_per_profile_bo(+)',
198: p_prefix=>l_debug_prefix,
199: p_msg_level=>fnd_log.level_procedure);
200: END IF;

Line 199: p_msg_level=>fnd_log.level_procedure);

195: -- Debug info.
196: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
197: hz_utility_v2pub.debug(p_message=>'get_cont_per_profile_bo(+)',
198: p_prefix=>l_debug_prefix,
199: p_msg_level=>fnd_log.level_procedure);
200: END IF;
201:
202: open c1;
203: fetch c1 into x_person_profile_obj;

Line 207: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

203: fetch c1 into x_person_profile_obj;
204: close c1;
205:
206: -- Debug info.
207: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
208: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
209: p_msg_data=>x_msg_data,
210: p_msg_type=>'WARNING',
211: p_msg_level=>fnd_log.level_exception);

Line 211: p_msg_level=>fnd_log.level_exception);

207: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
208: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
209: p_msg_data=>x_msg_data,
210: p_msg_type=>'WARNING',
211: p_msg_level=>fnd_log.level_exception);
212: END IF;
213:
214: -- Debug info.
215: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 215: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

211: p_msg_level=>fnd_log.level_exception);
212: END IF;
213:
214: -- Debug info.
215: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
216: hz_utility_v2pub.debug(p_message=>'get_cont_per_profile_bo (-)',
217: p_prefix=>l_debug_prefix,
218: p_msg_level=>fnd_log.level_procedure);
219: END IF;

Line 218: p_msg_level=>fnd_log.level_procedure);

214: -- Debug info.
215: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
216: hz_utility_v2pub.debug(p_message=>'get_cont_per_profile_bo (-)',
217: p_prefix=>l_debug_prefix,
218: p_msg_level=>fnd_log.level_procedure);
219: END IF;
220:
221:
222: EXCEPTION

Line 232: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

228: p_count => x_msg_count,
229: p_data => x_msg_data);
230:
231: -- Debug info.
232: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
233: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
234: p_msg_data=>x_msg_data,
235: p_msg_type=>'ERROR',
236: p_msg_level=>fnd_log.level_error);

Line 236: p_msg_level=>fnd_log.level_error);

232: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
233: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
234: p_msg_data=>x_msg_data,
235: p_msg_type=>'ERROR',
236: p_msg_level=>fnd_log.level_error);
237: END IF;
238: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
239: hz_utility_v2pub.debug(p_message=>'get_cont_per_profile_bo (-)',
240: p_prefix=>l_debug_prefix,

Line 238: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

234: p_msg_data=>x_msg_data,
235: p_msg_type=>'ERROR',
236: p_msg_level=>fnd_log.level_error);
237: END IF;
238: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
239: hz_utility_v2pub.debug(p_message=>'get_cont_per_profile_bo (-)',
240: p_prefix=>l_debug_prefix,
241: p_msg_level=>fnd_log.level_procedure);
242: END IF;

Line 241: p_msg_level=>fnd_log.level_procedure);

237: END IF;
238: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
239: hz_utility_v2pub.debug(p_message=>'get_cont_per_profile_bo (-)',
240: p_prefix=>l_debug_prefix,
241: p_msg_level=>fnd_log.level_procedure);
242: END IF;
243: WHEN fnd_api.g_exc_unexpected_error THEN
244: x_return_status := fnd_api.g_ret_sts_unexp_error;
245:

Line 251: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

247: p_count => x_msg_count,
248: p_data => x_msg_data);
249:
250: -- Debug info.
251: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
252: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
253: p_msg_data=>x_msg_data,
254: p_msg_type=>'UNEXPECTED ERROR',
255: p_msg_level=>fnd_log.level_error);

Line 255: p_msg_level=>fnd_log.level_error);

251: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
252: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
253: p_msg_data=>x_msg_data,
254: p_msg_type=>'UNEXPECTED ERROR',
255: p_msg_level=>fnd_log.level_error);
256: END IF;
257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
258: hz_utility_v2pub.debug(p_message=>'get_cont_per_profile_bo (-)',
259: p_prefix=>l_debug_prefix,

Line 257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

253: p_msg_data=>x_msg_data,
254: p_msg_type=>'UNEXPECTED ERROR',
255: p_msg_level=>fnd_log.level_error);
256: END IF;
257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
258: hz_utility_v2pub.debug(p_message=>'get_cont_per_profile_bo (-)',
259: p_prefix=>l_debug_prefix,
260: p_msg_level=>fnd_log.level_procedure);
261: END IF;

Line 260: p_msg_level=>fnd_log.level_procedure);

256: END IF;
257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
258: hz_utility_v2pub.debug(p_message=>'get_cont_per_profile_bo (-)',
259: p_prefix=>l_debug_prefix,
260: p_msg_level=>fnd_log.level_procedure);
261: END IF;
262: WHEN OTHERS THEN
263: x_return_status := fnd_api.g_ret_sts_unexp_error;
264:

Line 274: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

270: p_count => x_msg_count,
271: p_data => x_msg_data);
272:
273: -- Debug info.
274: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
275: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
276: p_msg_data=>x_msg_data,
277: p_msg_type=>'SQL ERROR',
278: p_msg_level=>fnd_log.level_error);

Line 278: p_msg_level=>fnd_log.level_error);

274: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
275: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
276: p_msg_data=>x_msg_data,
277: p_msg_type=>'SQL ERROR',
278: p_msg_level=>fnd_log.level_error);
279: END IF;
280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
281: hz_utility_v2pub.debug(p_message=>'get_cont_per_profile_bo (-)',
282: p_prefix=>l_debug_prefix,

Line 280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

276: p_msg_data=>x_msg_data,
277: p_msg_type=>'SQL ERROR',
278: p_msg_level=>fnd_log.level_error);
279: END IF;
280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
281: hz_utility_v2pub.debug(p_message=>'get_cont_per_profile_bo (-)',
282: p_prefix=>l_debug_prefix,
283: p_msg_level=>fnd_log.level_procedure);
284: END IF;

Line 283: p_msg_level=>fnd_log.level_procedure);

279: END IF;
280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
281: hz_utility_v2pub.debug(p_message=>'get_cont_per_profile_bo (-)',
282: p_prefix=>l_debug_prefix,
283: p_msg_level=>fnd_log.level_procedure);
284: END IF;
285:
286: end;
287:

Line 380: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

376: END IF;
377:
378:
379: -- Debug info.
380: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
381: hz_utility_v2pub.debug(p_message=>'get_org_contact_role_bos(+)',
382: p_prefix=>l_debug_prefix,
383: p_msg_level=>fnd_log.level_procedure);
384: END IF;

Line 383: p_msg_level=>fnd_log.level_procedure);

379: -- Debug info.
380: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
381: hz_utility_v2pub.debug(p_message=>'get_org_contact_role_bos(+)',
382: p_prefix=>l_debug_prefix,
383: p_msg_level=>fnd_log.level_procedure);
384: END IF;
385:
386: x_org_cont_role_objs := HZ_ORG_CONTACT_ROLE_OBJ_TBL();
387: open c1;

Line 392: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

388: fetch c1 BULK COLLECT into x_org_cont_role_objs;
389: close c1;
390:
391: -- Debug info.
392: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
393: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
394: p_msg_data=>x_msg_data,
395: p_msg_type=>'WARNING',
396: p_msg_level=>fnd_log.level_exception);

Line 396: p_msg_level=>fnd_log.level_exception);

392: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
393: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
394: p_msg_data=>x_msg_data,
395: p_msg_type=>'WARNING',
396: p_msg_level=>fnd_log.level_exception);
397: END IF;
398:
399: -- Debug info.
400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

396: p_msg_level=>fnd_log.level_exception);
397: END IF;
398:
399: -- Debug info.
400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
401: hz_utility_v2pub.debug(p_message=>'get_org_contact_role_bos (-)',
402: p_prefix=>l_debug_prefix,
403: p_msg_level=>fnd_log.level_procedure);
404: END IF;

Line 403: p_msg_level=>fnd_log.level_procedure);

399: -- Debug info.
400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
401: hz_utility_v2pub.debug(p_message=>'get_org_contact_role_bos (-)',
402: p_prefix=>l_debug_prefix,
403: p_msg_level=>fnd_log.level_procedure);
404: END IF;
405:
406:
407: EXCEPTION

Line 417: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

413: p_count => x_msg_count,
414: p_data => x_msg_data);
415:
416: -- Debug info.
417: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
418: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
419: p_msg_data=>x_msg_data,
420: p_msg_type=>'ERROR',
421: p_msg_level=>fnd_log.level_error);

Line 421: p_msg_level=>fnd_log.level_error);

417: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
418: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
419: p_msg_data=>x_msg_data,
420: p_msg_type=>'ERROR',
421: p_msg_level=>fnd_log.level_error);
422: END IF;
423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
424: hz_utility_v2pub.debug(p_message=>'get_org_contact_role_bos (-)',
425: p_prefix=>l_debug_prefix,

Line 423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

419: p_msg_data=>x_msg_data,
420: p_msg_type=>'ERROR',
421: p_msg_level=>fnd_log.level_error);
422: END IF;
423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
424: hz_utility_v2pub.debug(p_message=>'get_org_contact_role_bos (-)',
425: p_prefix=>l_debug_prefix,
426: p_msg_level=>fnd_log.level_procedure);
427: END IF;

Line 426: p_msg_level=>fnd_log.level_procedure);

422: END IF;
423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
424: hz_utility_v2pub.debug(p_message=>'get_org_contact_role_bos (-)',
425: p_prefix=>l_debug_prefix,
426: p_msg_level=>fnd_log.level_procedure);
427: END IF;
428: WHEN fnd_api.g_exc_unexpected_error THEN
429: x_return_status := fnd_api.g_ret_sts_unexp_error;
430:

Line 436: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

432: p_count => x_msg_count,
433: p_data => x_msg_data);
434:
435: -- Debug info.
436: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
437: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
438: p_msg_data=>x_msg_data,
439: p_msg_type=>'UNEXPECTED ERROR',
440: p_msg_level=>fnd_log.level_error);

Line 440: p_msg_level=>fnd_log.level_error);

436: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
437: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
438: p_msg_data=>x_msg_data,
439: p_msg_type=>'UNEXPECTED ERROR',
440: p_msg_level=>fnd_log.level_error);
441: END IF;
442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
443: hz_utility_v2pub.debug(p_message=>'get_org_contact_role_bos (-)',
444: p_prefix=>l_debug_prefix,

Line 442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

438: p_msg_data=>x_msg_data,
439: p_msg_type=>'UNEXPECTED ERROR',
440: p_msg_level=>fnd_log.level_error);
441: END IF;
442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
443: hz_utility_v2pub.debug(p_message=>'get_org_contact_role_bos (-)',
444: p_prefix=>l_debug_prefix,
445: p_msg_level=>fnd_log.level_procedure);
446: END IF;

Line 445: p_msg_level=>fnd_log.level_procedure);

441: END IF;
442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
443: hz_utility_v2pub.debug(p_message=>'get_org_contact_role_bos (-)',
444: p_prefix=>l_debug_prefix,
445: p_msg_level=>fnd_log.level_procedure);
446: END IF;
447: WHEN OTHERS THEN
448: x_return_status := fnd_api.g_ret_sts_unexp_error;
449:

Line 459: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

455: p_count => x_msg_count,
456: p_data => x_msg_data);
457:
458: -- Debug info.
459: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
460: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
461: p_msg_data=>x_msg_data,
462: p_msg_type=>'SQL ERROR',
463: p_msg_level=>fnd_log.level_error);

Line 463: p_msg_level=>fnd_log.level_error);

459: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
460: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
461: p_msg_data=>x_msg_data,
462: p_msg_type=>'SQL ERROR',
463: p_msg_level=>fnd_log.level_error);
464: END IF;
465: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
466: hz_utility_v2pub.debug(p_message=>'get_org_contact_role_bos (-)',
467: p_prefix=>l_debug_prefix,

Line 465: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

461: p_msg_data=>x_msg_data,
462: p_msg_type=>'SQL ERROR',
463: p_msg_level=>fnd_log.level_error);
464: END IF;
465: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
466: hz_utility_v2pub.debug(p_message=>'get_org_contact_role_bos (-)',
467: p_prefix=>l_debug_prefix,
468: p_msg_level=>fnd_log.level_procedure);
469: END IF;

Line 468: p_msg_level=>fnd_log.level_procedure);

464: END IF;
465: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
466: hz_utility_v2pub.debug(p_message=>'get_org_contact_role_bos (-)',
467: p_prefix=>l_debug_prefix,
468: p_msg_level=>fnd_log.level_procedure);
469: END IF;
470:
471: end;
472:

Line 608: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

604: END IF;
605:
606:
607: -- Debug info.
608: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
609: hz_utility_v2pub.debug(p_message=>'get_org_contact_bos(+)',
610: p_prefix=>l_debug_prefix,
611: p_msg_level=>fnd_log.level_procedure);
612: END IF;

Line 611: p_msg_level=>fnd_log.level_procedure);

607: -- Debug info.
608: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
609: hz_utility_v2pub.debug(p_message=>'get_org_contact_bos(+)',
610: p_prefix=>l_debug_prefix,
611: p_msg_level=>fnd_log.level_procedure);
612: END IF;
613:
614: x_org_contact_objs := HZ_ORG_CONTACT_BO_TBL();
615: open c1;

Line 777: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

773:
774: end loop;
775:
776: -- Debug info.
777: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
778: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
779: p_msg_data=>x_msg_data,
780: p_msg_type=>'WARNING',
781: p_msg_level=>fnd_log.level_exception);

Line 781: p_msg_level=>fnd_log.level_exception);

777: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
778: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
779: p_msg_data=>x_msg_data,
780: p_msg_type=>'WARNING',
781: p_msg_level=>fnd_log.level_exception);
782: END IF;
783:
784: -- Debug info.
785: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 785: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

781: p_msg_level=>fnd_log.level_exception);
782: END IF;
783:
784: -- Debug info.
785: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
786: hz_utility_v2pub.debug(p_message=>'get_org_contact_bos (-)',
787: p_prefix=>l_debug_prefix,
788: p_msg_level=>fnd_log.level_procedure);
789: END IF;

Line 788: p_msg_level=>fnd_log.level_procedure);

784: -- Debug info.
785: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
786: hz_utility_v2pub.debug(p_message=>'get_org_contact_bos (-)',
787: p_prefix=>l_debug_prefix,
788: p_msg_level=>fnd_log.level_procedure);
789: END IF;
790:
791:
792: EXCEPTION

Line 802: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

798: p_count => x_msg_count,
799: p_data => x_msg_data);
800:
801: -- Debug info.
802: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
803: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
804: p_msg_data=>x_msg_data,
805: p_msg_type=>'ERROR',
806: p_msg_level=>fnd_log.level_error);

Line 806: p_msg_level=>fnd_log.level_error);

802: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
803: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
804: p_msg_data=>x_msg_data,
805: p_msg_type=>'ERROR',
806: p_msg_level=>fnd_log.level_error);
807: END IF;
808: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
809: hz_utility_v2pub.debug(p_message=>'get_org_contact_bos (-)',
810: p_prefix=>l_debug_prefix,

Line 808: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

804: p_msg_data=>x_msg_data,
805: p_msg_type=>'ERROR',
806: p_msg_level=>fnd_log.level_error);
807: END IF;
808: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
809: hz_utility_v2pub.debug(p_message=>'get_org_contact_bos (-)',
810: p_prefix=>l_debug_prefix,
811: p_msg_level=>fnd_log.level_procedure);
812: END IF;

Line 811: p_msg_level=>fnd_log.level_procedure);

807: END IF;
808: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
809: hz_utility_v2pub.debug(p_message=>'get_org_contact_bos (-)',
810: p_prefix=>l_debug_prefix,
811: p_msg_level=>fnd_log.level_procedure);
812: END IF;
813: WHEN fnd_api.g_exc_unexpected_error THEN
814: x_return_status := fnd_api.g_ret_sts_unexp_error;
815:

Line 821: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

817: p_count => x_msg_count,
818: p_data => x_msg_data);
819:
820: -- Debug info.
821: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
822: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
823: p_msg_data=>x_msg_data,
824: p_msg_type=>'UNEXPECTED ERROR',
825: p_msg_level=>fnd_log.level_error);

Line 825: p_msg_level=>fnd_log.level_error);

821: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
822: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
823: p_msg_data=>x_msg_data,
824: p_msg_type=>'UNEXPECTED ERROR',
825: p_msg_level=>fnd_log.level_error);
826: END IF;
827: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
828: hz_utility_v2pub.debug(p_message=>'get_org_contact_bos (-)',
829: p_prefix=>l_debug_prefix,

Line 827: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

823: p_msg_data=>x_msg_data,
824: p_msg_type=>'UNEXPECTED ERROR',
825: p_msg_level=>fnd_log.level_error);
826: END IF;
827: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
828: hz_utility_v2pub.debug(p_message=>'get_org_contact_bos (-)',
829: p_prefix=>l_debug_prefix,
830: p_msg_level=>fnd_log.level_procedure);
831: END IF;

Line 830: p_msg_level=>fnd_log.level_procedure);

826: END IF;
827: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
828: hz_utility_v2pub.debug(p_message=>'get_org_contact_bos (-)',
829: p_prefix=>l_debug_prefix,
830: p_msg_level=>fnd_log.level_procedure);
831: END IF;
832: WHEN OTHERS THEN
833: x_return_status := fnd_api.g_ret_sts_unexp_error;
834:

Line 844: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

840: p_count => x_msg_count,
841: p_data => x_msg_data);
842:
843: -- Debug info.
844: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
845: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
846: p_msg_data=>x_msg_data,
847: p_msg_type=>'SQL ERROR',
848: p_msg_level=>fnd_log.level_error);

Line 848: p_msg_level=>fnd_log.level_error);

844: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
845: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
846: p_msg_data=>x_msg_data,
847: p_msg_type=>'SQL ERROR',
848: p_msg_level=>fnd_log.level_error);
849: END IF;
850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
851: hz_utility_v2pub.debug(p_message=>'get_org_contact_bos (-)',
852: p_prefix=>l_debug_prefix,

Line 850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

846: p_msg_data=>x_msg_data,
847: p_msg_type=>'SQL ERROR',
848: p_msg_level=>fnd_log.level_error);
849: END IF;
850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
851: hz_utility_v2pub.debug(p_message=>'get_org_contact_bos (-)',
852: p_prefix=>l_debug_prefix,
853: p_msg_level=>fnd_log.level_procedure);
854: END IF;

Line 853: p_msg_level=>fnd_log.level_procedure);

849: END IF;
850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
851: hz_utility_v2pub.debug(p_message=>'get_org_contact_bos (-)',
852: p_prefix=>l_debug_prefix,
853: p_msg_level=>fnd_log.level_procedure);
854: END IF;
855:
856: end;
857: