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_ACCOUNT_MERGE_PUB dependencies on FND_LOG

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

51:
52:
53: BEGIN
54:
55: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
56: hz_utility_v2pub.debug(p_message=>'validate_account(+)',
57: p_prefix=>l_debug_prefix,
58: p_msg_level=>fnd_log.level_procedure);
59: END IF;

Line 58: p_msg_level=>fnd_log.level_procedure);

54:
55: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
56: hz_utility_v2pub.debug(p_message=>'validate_account(+)',
57: p_prefix=>l_debug_prefix,
58: p_msg_level=>fnd_log.level_procedure);
59: END IF;
60:
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:

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

191: p_account_osr := l_account_osr;
192:
193: END IF;
194:
195: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
196: hz_utility_v2pub.debug(p_message=>'validate_account(-)',
197: p_prefix=>l_debug_prefix,
198: p_msg_level=>fnd_log.level_procedure);
199: END IF;

Line 198: p_msg_level=>fnd_log.level_procedure);

194:
195: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
196: hz_utility_v2pub.debug(p_message=>'validate_account(-)',
197: p_prefix=>l_debug_prefix,
198: p_msg_level=>fnd_log.level_procedure);
199: END IF;
200:
201: EXCEPTION
202: WHEN fnd_api.g_exc_error THEN

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

206: p_count => x_msg_count,
207: p_data => x_msg_data);
208:
209: -- Debug info.
210: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
211: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
212: p_msg_data=>x_msg_data,
213: p_msg_type=>'ERROR',
214: p_msg_level=>fnd_log.level_error);

Line 214: p_msg_level=>fnd_log.level_error);

210: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
211: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
212: p_msg_data=>x_msg_data,
213: p_msg_type=>'ERROR',
214: p_msg_level=>fnd_log.level_error);
215: END IF;
216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
217: hz_utility_v2pub.debug(p_message=>'validate_account(-)',
218: p_prefix=>l_debug_prefix,

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

212: p_msg_data=>x_msg_data,
213: p_msg_type=>'ERROR',
214: p_msg_level=>fnd_log.level_error);
215: END IF;
216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
217: hz_utility_v2pub.debug(p_message=>'validate_account(-)',
218: p_prefix=>l_debug_prefix,
219: p_msg_level=>fnd_log.level_procedure);
220: END IF;

Line 219: p_msg_level=>fnd_log.level_procedure);

215: END IF;
216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
217: hz_utility_v2pub.debug(p_message=>'validate_account(-)',
218: p_prefix=>l_debug_prefix,
219: p_msg_level=>fnd_log.level_procedure);
220: END IF;
221: WHEN fnd_api.g_exc_unexpected_error THEN
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223:

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

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

Line 233: p_msg_level=>fnd_log.level_error);

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

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

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

Line 238: p_msg_level=>fnd_log.level_procedure);

234: END IF;
235: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
236: hz_utility_v2pub.debug(p_message=>'validate_account(-)',
237: p_prefix=>l_debug_prefix,
238: p_msg_level=>fnd_log.level_procedure);
239: END IF;
240: WHEN OTHERS THEN
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242:

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

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

Line 256: p_msg_level=>fnd_log.level_error);

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

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

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

Line 261: p_msg_level=>fnd_log.level_procedure);

257: END IF;
258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
259: hz_utility_v2pub.debug(p_message=>'validate_account(-)',
260: p_prefix=>l_debug_prefix,
261: p_msg_level=>fnd_log.level_procedure);
262: END IF;
263: END validate_account;
264:
265: PROCEDURE validate_account_site(

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

292: l_osr VARCHAR2(240);
293:
294: BEGIN
295:
296: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
297: hz_utility_v2pub.debug(p_message=>'validate_account_site(+)',
298: p_prefix=>l_debug_prefix,
299: p_msg_level=>fnd_log.level_procedure);
300: END IF;

Line 299: p_msg_level=>fnd_log.level_procedure);

295:
296: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
297: hz_utility_v2pub.debug(p_message=>'validate_account_site(+)',
298: p_prefix=>l_debug_prefix,
299: p_msg_level=>fnd_log.level_procedure);
300: END IF;
301:
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303:

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

440: END IF;
441:
442: p_site_osr := l_osr;
443:
444: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
445: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',
446: p_prefix=>l_debug_prefix,
447: p_msg_level=>fnd_log.level_procedure);
448: END IF;

Line 447: p_msg_level=>fnd_log.level_procedure);

443:
444: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
445: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',
446: p_prefix=>l_debug_prefix,
447: p_msg_level=>fnd_log.level_procedure);
448: END IF;
449:
450: EXCEPTION
451: WHEN fnd_api.g_exc_error THEN

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=>'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=>'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=>'validate_account_site(-)',
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=>'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=>'validate_account_site(-)',
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=>'validate_account_site(-)',
467: p_prefix=>l_debug_prefix,
468: p_msg_level=>fnd_log.level_procedure);
469: END IF;
470: WHEN fnd_api.g_exc_unexpected_error THEN
471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472:

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

474: p_count => x_msg_count,
475: p_data => x_msg_data);
476:
477: -- Debug info.
478: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
479: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
480: p_msg_data=>x_msg_data,
481: p_msg_type=>'UNEXPECTED ERROR',
482: p_msg_level=>fnd_log.level_error);

Line 482: p_msg_level=>fnd_log.level_error);

478: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
479: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
480: p_msg_data=>x_msg_data,
481: p_msg_type=>'UNEXPECTED ERROR',
482: p_msg_level=>fnd_log.level_error);
483: END IF;
484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
485: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',
486: p_prefix=>l_debug_prefix,

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

480: p_msg_data=>x_msg_data,
481: p_msg_type=>'UNEXPECTED ERROR',
482: p_msg_level=>fnd_log.level_error);
483: END IF;
484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
485: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',
486: p_prefix=>l_debug_prefix,
487: p_msg_level=>fnd_log.level_procedure);
488: END IF;

Line 487: p_msg_level=>fnd_log.level_procedure);

483: END IF;
484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
485: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',
486: p_prefix=>l_debug_prefix,
487: p_msg_level=>fnd_log.level_procedure);
488: END IF;
489: WHEN OTHERS THEN
490: x_return_status := fnd_api.g_ret_sts_unexp_error;
491:

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

497: p_count => x_msg_count,
498: p_data => x_msg_data);
499:
500: -- Debug info.
501: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
502: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
503: p_msg_data=>x_msg_data,
504: p_msg_type=>'SQL ERROR',
505: p_msg_level=>fnd_log.level_error);

Line 505: p_msg_level=>fnd_log.level_error);

501: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
502: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
503: p_msg_data=>x_msg_data,
504: p_msg_type=>'SQL ERROR',
505: p_msg_level=>fnd_log.level_error);
506: END IF;
507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
508: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',
509: p_prefix=>l_debug_prefix,

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

503: p_msg_data=>x_msg_data,
504: p_msg_type=>'SQL ERROR',
505: p_msg_level=>fnd_log.level_error);
506: END IF;
507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
508: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',
509: p_prefix=>l_debug_prefix,
510: p_msg_level=>fnd_log.level_procedure);
511: END IF;

Line 510: p_msg_level=>fnd_log.level_procedure);

506: END IF;
507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
508: hz_utility_v2pub.debug(p_message=>'validate_account_site(-)',
509: p_prefix=>l_debug_prefix,
510: p_msg_level=>fnd_log.level_procedure);
511: END IF;
512:
513: END validate_account_site;
514:

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

539: l_owner_table_id NUMBER;
540:
541: BEGIN
542:
543: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
544: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(+)',
545: p_prefix=>l_debug_prefix,
546: p_msg_level=>fnd_log.level_procedure);
547: END IF;

Line 546: p_msg_level=>fnd_log.level_procedure);

542:
543: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
544: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(+)',
545: p_prefix=>l_debug_prefix,
546: p_msg_level=>fnd_log.level_procedure);
547: END IF;
548:
549: x_return_status := FND_API.G_RET_STS_SUCCESS;
550:

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

668:
669: g_site_use_location(p_site_use_id) := l_location;
670: g_primary_flag(p_site_use_id) := l_primary_flag;
671:
672: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
673: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',
674: p_prefix=>l_debug_prefix,
675: p_msg_level=>fnd_log.level_procedure);
676: END IF;

Line 675: p_msg_level=>fnd_log.level_procedure);

671:
672: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
673: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',
674: p_prefix=>l_debug_prefix,
675: p_msg_level=>fnd_log.level_procedure);
676: END IF;
677:
678: EXCEPTION
679: WHEN fnd_api.g_exc_error THEN

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

683: p_count => x_msg_count,
684: p_data => x_msg_data);
685:
686: -- Debug info.
687: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
688: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
689: p_msg_data=>x_msg_data,
690: p_msg_type=>'ERROR',
691: p_msg_level=>fnd_log.level_error);

Line 691: p_msg_level=>fnd_log.level_error);

687: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
688: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
689: p_msg_data=>x_msg_data,
690: p_msg_type=>'ERROR',
691: p_msg_level=>fnd_log.level_error);
692: END IF;
693: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
694: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',
695: p_prefix=>l_debug_prefix,

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

689: p_msg_data=>x_msg_data,
690: p_msg_type=>'ERROR',
691: p_msg_level=>fnd_log.level_error);
692: END IF;
693: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
694: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',
695: p_prefix=>l_debug_prefix,
696: p_msg_level=>fnd_log.level_procedure);
697: END IF;

Line 696: p_msg_level=>fnd_log.level_procedure);

692: END IF;
693: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
694: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',
695: p_prefix=>l_debug_prefix,
696: p_msg_level=>fnd_log.level_procedure);
697: END IF;
698: WHEN fnd_api.g_exc_unexpected_error THEN
699: x_return_status := fnd_api.g_ret_sts_unexp_error;
700:

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

702: p_count => x_msg_count,
703: p_data => x_msg_data);
704:
705: -- Debug info.
706: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
707: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
708: p_msg_data=>x_msg_data,
709: p_msg_type=>'UNEXPECTED ERROR',
710: p_msg_level=>fnd_log.level_error);

Line 710: p_msg_level=>fnd_log.level_error);

706: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
707: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
708: p_msg_data=>x_msg_data,
709: p_msg_type=>'UNEXPECTED ERROR',
710: p_msg_level=>fnd_log.level_error);
711: END IF;
712: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
713: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',
714: p_prefix=>l_debug_prefix,

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

708: p_msg_data=>x_msg_data,
709: p_msg_type=>'UNEXPECTED ERROR',
710: p_msg_level=>fnd_log.level_error);
711: END IF;
712: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
713: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',
714: p_prefix=>l_debug_prefix,
715: p_msg_level=>fnd_log.level_procedure);
716: END IF;

Line 715: p_msg_level=>fnd_log.level_procedure);

711: END IF;
712: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
713: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',
714: p_prefix=>l_debug_prefix,
715: p_msg_level=>fnd_log.level_procedure);
716: END IF;
717: WHEN OTHERS THEN
718: x_return_status := fnd_api.g_ret_sts_unexp_error;
719:

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

725: p_count => x_msg_count,
726: p_data => x_msg_data);
727:
728: -- Debug info.
729: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
730: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
731: p_msg_data=>x_msg_data,
732: p_msg_type=>'SQL ERROR',
733: p_msg_level=>fnd_log.level_error);

Line 733: p_msg_level=>fnd_log.level_error);

729: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
730: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
731: p_msg_data=>x_msg_data,
732: p_msg_type=>'SQL ERROR',
733: p_msg_level=>fnd_log.level_error);
734: END IF;
735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
736: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',
737: p_prefix=>l_debug_prefix,

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

731: p_msg_data=>x_msg_data,
732: p_msg_type=>'SQL ERROR',
733: p_msg_level=>fnd_log.level_error);
734: END IF;
735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
736: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',
737: p_prefix=>l_debug_prefix,
738: p_msg_level=>fnd_log.level_procedure);
739: END IF;

Line 738: p_msg_level=>fnd_log.level_procedure);

734: END IF;
735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
736: hz_utility_v2pub.debug(p_message=>'validate_account_site_use(-)',
737: p_prefix=>l_debug_prefix,
738: p_msg_level=>fnd_log.level_procedure);
739: END IF;
740:
741: END validate_account_site_use;
742:

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

825:
826:
827: BEGIN
828:
829: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
830: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(+)',
831: p_prefix=>l_debug_prefix,
832: p_msg_level=>fnd_log.level_procedure);
833: END IF;

Line 832: p_msg_level=>fnd_log.level_procedure);

828:
829: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
830: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(+)',
831: p_prefix=>l_debug_prefix,
832: p_msg_level=>fnd_log.level_procedure);
833: END IF;
834:
835: x_return_status := FND_API.G_RET_STS_SUCCESS;
836:

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

1878: x_account_merge_request_id := NULL;
1879:
1880: END IF; --p_submit_request
1881:
1882: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1883: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',
1884: p_prefix=>l_debug_prefix,
1885: p_msg_level=>fnd_log.level_procedure);
1886: END IF;

Line 1885: p_msg_level=>fnd_log.level_procedure);

1881:
1882: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1883: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',
1884: p_prefix=>l_debug_prefix,
1885: p_msg_level=>fnd_log.level_procedure);
1886: END IF;
1887:
1888:
1889: EXCEPTION

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

1894: p_count => x_msg_count,
1895: p_data => x_msg_data);
1896:
1897: -- Debug info.
1898: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1899: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1900: p_msg_data=>x_msg_data,
1901: p_msg_type=>'ERROR',
1902: p_msg_level=>fnd_log.level_error);

Line 1902: p_msg_level=>fnd_log.level_error);

1898: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1899: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1900: p_msg_data=>x_msg_data,
1901: p_msg_type=>'ERROR',
1902: p_msg_level=>fnd_log.level_error);
1903: END IF;
1904: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1905: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',
1906: p_prefix=>l_debug_prefix,

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

1900: p_msg_data=>x_msg_data,
1901: p_msg_type=>'ERROR',
1902: p_msg_level=>fnd_log.level_error);
1903: END IF;
1904: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1905: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',
1906: p_prefix=>l_debug_prefix,
1907: p_msg_level=>fnd_log.level_procedure);
1908: END IF;

Line 1907: p_msg_level=>fnd_log.level_procedure);

1903: END IF;
1904: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1905: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',
1906: p_prefix=>l_debug_prefix,
1907: p_msg_level=>fnd_log.level_procedure);
1908: END IF;
1909: WHEN fnd_api.g_exc_unexpected_error THEN
1910: x_return_status := fnd_api.g_ret_sts_unexp_error;
1911:

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

1913: p_count => x_msg_count,
1914: p_data => x_msg_data);
1915:
1916: -- Debug info.
1917: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1918: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1919: p_msg_data=>x_msg_data,
1920: p_msg_type=>'UNEXPECTED ERROR',
1921: p_msg_level=>fnd_log.level_error);

Line 1921: p_msg_level=>fnd_log.level_error);

1917: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1918: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1919: p_msg_data=>x_msg_data,
1920: p_msg_type=>'UNEXPECTED ERROR',
1921: p_msg_level=>fnd_log.level_error);
1922: END IF;
1923: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1924: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',
1925: p_prefix=>l_debug_prefix,

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

1919: p_msg_data=>x_msg_data,
1920: p_msg_type=>'UNEXPECTED ERROR',
1921: p_msg_level=>fnd_log.level_error);
1922: END IF;
1923: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1924: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',
1925: p_prefix=>l_debug_prefix,
1926: p_msg_level=>fnd_log.level_procedure);
1927: END IF;

Line 1926: p_msg_level=>fnd_log.level_procedure);

1922: END IF;
1923: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1924: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',
1925: p_prefix=>l_debug_prefix,
1926: p_msg_level=>fnd_log.level_procedure);
1927: END IF;
1928: WHEN OTHERS THEN
1929: x_return_status := fnd_api.g_ret_sts_unexp_error;
1930:

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

1936: p_count => x_msg_count,
1937: p_data => x_msg_data);
1938:
1939: -- Debug info.
1940: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1941: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1942: p_msg_data=>x_msg_data,
1943: p_msg_type=>'SQL ERROR',
1944: p_msg_level=>fnd_log.level_error);

Line 1944: p_msg_level=>fnd_log.level_error);

1940: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1941: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1942: p_msg_data=>x_msg_data,
1943: p_msg_type=>'SQL ERROR',
1944: p_msg_level=>fnd_log.level_error);
1945: END IF;
1946: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1947: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',
1948: p_prefix=>l_debug_prefix,

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

1942: p_msg_data=>x_msg_data,
1943: p_msg_type=>'SQL ERROR',
1944: p_msg_level=>fnd_log.level_error);
1945: END IF;
1946: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1947: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',
1948: p_prefix=>l_debug_prefix,
1949: p_msg_level=>fnd_log.level_procedure);
1950: END IF;

Line 1949: p_msg_level=>fnd_log.level_procedure);

1945: END IF;
1946: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1947: hz_utility_v2pub.debug(p_message=>'create_account_merge_request(-)',
1948: p_prefix=>l_debug_prefix,
1949: p_msg_level=>fnd_log.level_procedure);
1950: END IF;
1951:
1952: END create_account_merge_request;
1953: