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

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

205: FND_MSG_PUB.initialize;
206: END IF;
207:
208: -- Debug info.
209: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
210: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(+)',
211: p_prefix=>l_debug_prefix,
212: p_msg_level=>fnd_log.level_procedure);
213: END IF;

Line 212: p_msg_level=>fnd_log.level_procedure);

208: -- Debug info.
209: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
210: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(+)',
211: p_prefix=>l_debug_prefix,
212: p_msg_level=>fnd_log.level_procedure);
213: END IF;
214:
215: -- initialize Global variable
216: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

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

379: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
380: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
381:
382: -- Debug info.
383: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
384: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
385: p_msg_data=>x_msg_data,
386: p_msg_type=>'WARNING',
387: p_msg_level=>fnd_log.level_exception);

Line 387: p_msg_level=>fnd_log.level_exception);

383: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
384: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
385: p_msg_data=>x_msg_data,
386: p_msg_type=>'WARNING',
387: p_msg_level=>fnd_log.level_exception);
388: END IF;
389: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
390: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(-)',
391: p_prefix=>l_debug_prefix,

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

385: p_msg_data=>x_msg_data,
386: p_msg_type=>'WARNING',
387: p_msg_level=>fnd_log.level_exception);
388: END IF;
389: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
390: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(-)',
391: p_prefix=>l_debug_prefix,
392: p_msg_level=>fnd_log.level_procedure);
393: END IF;

Line 392: p_msg_level=>fnd_log.level_procedure);

388: END IF;
389: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
390: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(-)',
391: p_prefix=>l_debug_prefix,
392: p_msg_level=>fnd_log.level_procedure);
393: END IF;
394:
395: EXCEPTION
396: WHEN fnd_api.g_exc_error THEN

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

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

Line 418: p_msg_level=>fnd_log.level_error);

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

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

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

Line 423: p_msg_level=>fnd_log.level_procedure);

419: END IF;
420: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
421: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(-)',
422: p_prefix=>l_debug_prefix,
423: p_msg_level=>fnd_log.level_procedure);
424: END IF;
425:
426: WHEN fnd_api.g_exc_unexpected_error THEN
427: ROLLBACK TO do_create_cas_bo_pub;

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

440: p_count => x_msg_count,
441: p_data => x_msg_data);
442:
443: -- Debug info.
444: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
445: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
446: p_msg_data=>x_msg_data,
447: p_msg_type=>'UNEXPECTED ERROR',
448: p_msg_level=>fnd_log.level_error);

Line 448: p_msg_level=>fnd_log.level_error);

444: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
445: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
446: p_msg_data=>x_msg_data,
447: p_msg_type=>'UNEXPECTED ERROR',
448: p_msg_level=>fnd_log.level_error);
449: END IF;
450: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
451: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(-)',
452: p_prefix=>l_debug_prefix,

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

446: p_msg_data=>x_msg_data,
447: p_msg_type=>'UNEXPECTED ERROR',
448: p_msg_level=>fnd_log.level_error);
449: END IF;
450: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
451: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(-)',
452: p_prefix=>l_debug_prefix,
453: p_msg_level=>fnd_log.level_procedure);
454: END IF;

Line 453: p_msg_level=>fnd_log.level_procedure);

449: END IF;
450: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
451: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_bo(-)',
452: p_prefix=>l_debug_prefix,
453: p_msg_level=>fnd_log.level_procedure);
454: END IF;
455:
456: WHEN OTHERS THEN
457: ROLLBACK TO do_create_cas_bo_pub;

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=>'SQL 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=>'SQL 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=>'do_create_cust_acct_site_bo(-)',
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=>'SQL 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=>'do_create_cust_acct_site_bo(-)',
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=>'do_create_cust_acct_site_bo(-)',
486: p_prefix=>l_debug_prefix,
487: p_msg_level=>fnd_log.level_procedure);
488: END IF;
489: END do_create_cust_acct_site_bo;
490:
491: PROCEDURE create_cust_acct_site_bo(

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

688: FND_MSG_PUB.initialize;
689: END IF;
690:
691: -- Debug info.
692: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
693: hz_utility_v2pub.debug(p_message=>'do_update_cas_bo(+)',
694: p_prefix=>l_debug_prefix,
695: p_msg_level=>fnd_log.level_procedure);
696: END IF;

Line 695: p_msg_level=>fnd_log.level_procedure);

691: -- Debug info.
692: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
693: hz_utility_v2pub.debug(p_message=>'do_update_cas_bo(+)',
694: p_prefix=>l_debug_prefix,
695: p_msg_level=>fnd_log.level_procedure);
696: END IF;
697:
698: -- initialize Global variable
699: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

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

807: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
808: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
809:
810: -- Debug info.
811: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
812: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
813: p_msg_data=>x_msg_data,
814: p_msg_type=>'WARNING',
815: p_msg_level=>fnd_log.level_exception);

Line 815: p_msg_level=>fnd_log.level_exception);

811: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
812: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
813: p_msg_data=>x_msg_data,
814: p_msg_type=>'WARNING',
815: p_msg_level=>fnd_log.level_exception);
816: END IF;
817: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
818: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',
819: p_prefix=>l_debug_prefix,

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

813: p_msg_data=>x_msg_data,
814: p_msg_type=>'WARNING',
815: p_msg_level=>fnd_log.level_exception);
816: END IF;
817: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
818: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',
819: p_prefix=>l_debug_prefix,
820: p_msg_level=>fnd_log.level_procedure);
821: END IF;

Line 820: p_msg_level=>fnd_log.level_procedure);

816: END IF;
817: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
818: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',
819: p_prefix=>l_debug_prefix,
820: p_msg_level=>fnd_log.level_procedure);
821: END IF;
822: EXCEPTION
823: WHEN fnd_api.g_exc_error THEN
824: ROLLBACK TO do_update_cas_bo_pub;

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

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

Line 845: p_msg_level=>fnd_log.level_error);

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

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

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

Line 850: p_msg_level=>fnd_log.level_procedure);

846: END IF;
847: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
848: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',
849: p_prefix=>l_debug_prefix,
850: p_msg_level=>fnd_log.level_procedure);
851: END IF;
852:
853: WHEN fnd_api.g_exc_unexpected_error THEN
854: ROLLBACK TO do_update_cas_bo_pub;

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

867: p_count => x_msg_count,
868: p_data => x_msg_data);
869:
870: -- Debug info.
871: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
872: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
873: p_msg_data=>x_msg_data,
874: p_msg_type=>'UNEXPECTED ERROR',
875: p_msg_level=>fnd_log.level_error);

Line 875: p_msg_level=>fnd_log.level_error);

871: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
872: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
873: p_msg_data=>x_msg_data,
874: p_msg_type=>'UNEXPECTED ERROR',
875: p_msg_level=>fnd_log.level_error);
876: END IF;
877: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
878: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',
879: p_prefix=>l_debug_prefix,

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

873: p_msg_data=>x_msg_data,
874: p_msg_type=>'UNEXPECTED ERROR',
875: p_msg_level=>fnd_log.level_error);
876: END IF;
877: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
878: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',
879: p_prefix=>l_debug_prefix,
880: p_msg_level=>fnd_log.level_procedure);
881: END IF;

Line 880: p_msg_level=>fnd_log.level_procedure);

876: END IF;
877: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
878: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',
879: p_prefix=>l_debug_prefix,
880: p_msg_level=>fnd_log.level_procedure);
881: END IF;
882:
883: WHEN OTHERS THEN
884: ROLLBACK TO do_update_cas_bo_pub;

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

901: p_count => x_msg_count,
902: p_data => x_msg_data);
903:
904: -- Debug info.
905: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
906: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
907: p_msg_data=>x_msg_data,
908: p_msg_type=>'SQL ERROR',
909: p_msg_level=>fnd_log.level_error);

Line 909: p_msg_level=>fnd_log.level_error);

905: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
906: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
907: p_msg_data=>x_msg_data,
908: p_msg_type=>'SQL ERROR',
909: p_msg_level=>fnd_log.level_error);
910: END IF;
911: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
912: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',
913: p_prefix=>l_debug_prefix,

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

907: p_msg_data=>x_msg_data,
908: p_msg_type=>'SQL ERROR',
909: p_msg_level=>fnd_log.level_error);
910: END IF;
911: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
912: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',
913: p_prefix=>l_debug_prefix,
914: p_msg_level=>fnd_log.level_procedure);
915: END IF;

Line 914: p_msg_level=>fnd_log.level_procedure);

910: END IF;
911: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
912: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_bo(-)',
913: p_prefix=>l_debug_prefix,
914: p_msg_level=>fnd_log.level_procedure);
915: END IF;
916: END do_update_cust_acct_site_bo;
917:
918: -- PROCEDURE do_save_cust_acct_site_bo

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

958: FND_MSG_PUB.initialize;
959: END IF;
960:
961: -- Debug info.
962: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
963: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(+)',
964: p_prefix=>l_debug_prefix,
965: p_msg_level=>fnd_log.level_procedure);
966: END IF;

Line 965: p_msg_level=>fnd_log.level_procedure);

961: -- Debug info.
962: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
963: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(+)',
964: p_prefix=>l_debug_prefix,
965: p_msg_level=>fnd_log.level_procedure);
966: END IF;
967:
968: x_cust_acct_site_id := p_cust_acct_site_obj.cust_acct_site_id;
969: x_cust_acct_site_os := p_cust_acct_site_obj.orig_system;

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

1037: RAISE FND_API.G_EXC_ERROR;
1038: END IF;
1039:
1040: -- Debug info.
1041: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1042: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1043: p_msg_data=>x_msg_data,
1044: p_msg_type=>'WARNING',
1045: p_msg_level=>fnd_log.level_exception);

Line 1045: p_msg_level=>fnd_log.level_exception);

1041: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1042: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1043: p_msg_data=>x_msg_data,
1044: p_msg_type=>'WARNING',
1045: p_msg_level=>fnd_log.level_exception);
1046: END IF;
1047: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1048: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1049: p_prefix=>l_debug_prefix,

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

1043: p_msg_data=>x_msg_data,
1044: p_msg_type=>'WARNING',
1045: p_msg_level=>fnd_log.level_exception);
1046: END IF;
1047: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1048: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1049: p_prefix=>l_debug_prefix,
1050: p_msg_level=>fnd_log.level_procedure);
1051: END IF;

Line 1050: p_msg_level=>fnd_log.level_procedure);

1046: END IF;
1047: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1048: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1049: p_prefix=>l_debug_prefix,
1050: p_msg_level=>fnd_log.level_procedure);
1051: END IF;
1052:
1053: EXCEPTION
1054: WHEN fnd_api.g_exc_error THEN

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

1058: p_count => x_msg_count,
1059: p_data => x_msg_data);
1060:
1061: -- Debug info.
1062: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1063: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1064: p_msg_data=>x_msg_data,
1065: p_msg_type=>'ERROR',
1066: p_msg_level=>fnd_log.level_error);

Line 1066: p_msg_level=>fnd_log.level_error);

1062: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1063: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1064: p_msg_data=>x_msg_data,
1065: p_msg_type=>'ERROR',
1066: p_msg_level=>fnd_log.level_error);
1067: END IF;
1068: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1069: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1070: p_prefix=>l_debug_prefix,

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

1064: p_msg_data=>x_msg_data,
1065: p_msg_type=>'ERROR',
1066: p_msg_level=>fnd_log.level_error);
1067: END IF;
1068: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1069: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1070: p_prefix=>l_debug_prefix,
1071: p_msg_level=>fnd_log.level_procedure);
1072: END IF;

Line 1071: p_msg_level=>fnd_log.level_procedure);

1067: END IF;
1068: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1069: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1070: p_prefix=>l_debug_prefix,
1071: p_msg_level=>fnd_log.level_procedure);
1072: END IF;
1073: WHEN fnd_api.g_exc_unexpected_error THEN
1074: x_return_status := fnd_api.g_ret_sts_unexp_error;
1075:

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

1077: p_count => x_msg_count,
1078: p_data => x_msg_data);
1079:
1080: -- Debug info.
1081: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1082: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1083: p_msg_data=>x_msg_data,
1084: p_msg_type=>'UNEXPECTED ERROR',
1085: p_msg_level=>fnd_log.level_error);

Line 1085: p_msg_level=>fnd_log.level_error);

1081: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1082: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1083: p_msg_data=>x_msg_data,
1084: p_msg_type=>'UNEXPECTED ERROR',
1085: p_msg_level=>fnd_log.level_error);
1086: END IF;
1087: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1088: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1089: p_prefix=>l_debug_prefix,

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

1083: p_msg_data=>x_msg_data,
1084: p_msg_type=>'UNEXPECTED ERROR',
1085: p_msg_level=>fnd_log.level_error);
1086: END IF;
1087: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1088: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1089: p_prefix=>l_debug_prefix,
1090: p_msg_level=>fnd_log.level_procedure);
1091: END IF;

Line 1090: p_msg_level=>fnd_log.level_procedure);

1086: END IF;
1087: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1088: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1089: p_prefix=>l_debug_prefix,
1090: p_msg_level=>fnd_log.level_procedure);
1091: END IF;
1092: WHEN OTHERS THEN
1093: x_return_status := fnd_api.g_ret_sts_unexp_error;
1094:

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

1100: p_count => x_msg_count,
1101: p_data => x_msg_data);
1102:
1103: -- Debug info.
1104: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1105: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1106: p_msg_data=>x_msg_data,
1107: p_msg_type=>'SQL ERROR',
1108: p_msg_level=>fnd_log.level_error);

Line 1108: p_msg_level=>fnd_log.level_error);

1104: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1105: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1106: p_msg_data=>x_msg_data,
1107: p_msg_type=>'SQL ERROR',
1108: p_msg_level=>fnd_log.level_error);
1109: END IF;
1110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1111: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1112: p_prefix=>l_debug_prefix,

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

1106: p_msg_data=>x_msg_data,
1107: p_msg_type=>'SQL ERROR',
1108: p_msg_level=>fnd_log.level_error);
1109: END IF;
1110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1111: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1112: p_prefix=>l_debug_prefix,
1113: p_msg_level=>fnd_log.level_procedure);
1114: END IF;

Line 1113: p_msg_level=>fnd_log.level_procedure);

1109: END IF;
1110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1111: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_bo(-)',
1112: p_prefix=>l_debug_prefix,
1113: p_msg_level=>fnd_log.level_procedure);
1114: END IF;
1115: END do_save_cust_acct_site_bo;
1116:
1117: PROCEDURE save_cust_acct_site_bo(

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

1285: END IF;
1286:
1287:
1288: -- Debug info.
1289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1290: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo(+)',
1291: p_prefix=>l_debug_prefix,
1292: p_msg_level=>fnd_log.level_procedure);
1293: END IF;

Line 1292: p_msg_level=>fnd_log.level_procedure);

1288: -- Debug info.
1289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1290: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo(+)',
1291: p_prefix=>l_debug_prefix,
1292: p_msg_level=>fnd_log.level_procedure);
1293: END IF;
1294:
1295: -- check if pass in contact_point_id and/or os+osr
1296: -- extraction validation logic is same as update

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

1329: END IF;
1330:
1331:
1332: -- Debug info.
1333: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1334: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1335: p_msg_data=>x_msg_data,
1336: p_msg_type=>'WARNING',
1337: p_msg_level=>fnd_log.level_exception);

Line 1337: p_msg_level=>fnd_log.level_exception);

1333: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1334: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1335: p_msg_data=>x_msg_data,
1336: p_msg_type=>'WARNING',
1337: p_msg_level=>fnd_log.level_exception);
1338: END IF;
1339:
1340: -- Debug info.
1341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1337: p_msg_level=>fnd_log.level_exception);
1338: END IF;
1339:
1340: -- Debug info.
1341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1342: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1343: p_prefix=>l_debug_prefix,
1344: p_msg_level=>fnd_log.level_procedure);
1345: END IF;

Line 1344: p_msg_level=>fnd_log.level_procedure);

1340: -- Debug info.
1341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1342: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1343: p_prefix=>l_debug_prefix,
1344: p_msg_level=>fnd_log.level_procedure);
1345: END IF;
1346:
1347:
1348: EXCEPTION

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

1354: p_count => x_msg_count,
1355: p_data => x_msg_data);
1356:
1357: -- Debug info.
1358: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1359: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1360: p_msg_data=>x_msg_data,
1361: p_msg_type=>'ERROR',
1362: p_msg_level=>fnd_log.level_error);

Line 1362: p_msg_level=>fnd_log.level_error);

1358: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1359: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1360: p_msg_data=>x_msg_data,
1361: p_msg_type=>'ERROR',
1362: p_msg_level=>fnd_log.level_error);
1363: END IF;
1364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1365: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1366: p_prefix=>l_debug_prefix,

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

1360: p_msg_data=>x_msg_data,
1361: p_msg_type=>'ERROR',
1362: p_msg_level=>fnd_log.level_error);
1363: END IF;
1364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1365: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1366: p_prefix=>l_debug_prefix,
1367: p_msg_level=>fnd_log.level_procedure);
1368: END IF;

Line 1367: p_msg_level=>fnd_log.level_procedure);

1363: END IF;
1364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1365: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1366: p_prefix=>l_debug_prefix,
1367: p_msg_level=>fnd_log.level_procedure);
1368: END IF;
1369: WHEN fnd_api.g_exc_unexpected_error THEN
1370: x_return_status := fnd_api.g_ret_sts_unexp_error;
1371:

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

1373: p_count => x_msg_count,
1374: p_data => x_msg_data);
1375:
1376: -- Debug info.
1377: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1378: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1379: p_msg_data=>x_msg_data,
1380: p_msg_type=>'UNEXPECTED ERROR',
1381: p_msg_level=>fnd_log.level_error);

Line 1381: p_msg_level=>fnd_log.level_error);

1377: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1378: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1379: p_msg_data=>x_msg_data,
1380: p_msg_type=>'UNEXPECTED ERROR',
1381: p_msg_level=>fnd_log.level_error);
1382: END IF;
1383: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1384: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1385: p_prefix=>l_debug_prefix,

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

1379: p_msg_data=>x_msg_data,
1380: p_msg_type=>'UNEXPECTED ERROR',
1381: p_msg_level=>fnd_log.level_error);
1382: END IF;
1383: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1384: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1385: p_prefix=>l_debug_prefix,
1386: p_msg_level=>fnd_log.level_procedure);
1387: END IF;

Line 1386: p_msg_level=>fnd_log.level_procedure);

1382: END IF;
1383: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1384: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1385: p_prefix=>l_debug_prefix,
1386: p_msg_level=>fnd_log.level_procedure);
1387: END IF;
1388: WHEN OTHERS THEN
1389: x_return_status := fnd_api.g_ret_sts_unexp_error;
1390:

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

1396: p_count => x_msg_count,
1397: p_data => x_msg_data);
1398:
1399: -- Debug info.
1400: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1401: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1402: p_msg_data=>x_msg_data,
1403: p_msg_type=>'SQL ERROR',
1404: p_msg_level=>fnd_log.level_error);

Line 1404: p_msg_level=>fnd_log.level_error);

1400: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1401: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1402: p_msg_data=>x_msg_data,
1403: p_msg_type=>'SQL ERROR',
1404: p_msg_level=>fnd_log.level_error);
1405: END IF;
1406: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1407: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1408: p_prefix=>l_debug_prefix,

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

1402: p_msg_data=>x_msg_data,
1403: p_msg_type=>'SQL ERROR',
1404: p_msg_level=>fnd_log.level_error);
1405: END IF;
1406: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1407: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1408: p_prefix=>l_debug_prefix,
1409: p_msg_level=>fnd_log.level_procedure);
1410: END IF;

Line 1409: p_msg_level=>fnd_log.level_procedure);

1405: END IF;
1406: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1407: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo (-)',
1408: p_prefix=>l_debug_prefix,
1409: p_msg_level=>fnd_log.level_procedure);
1410: END IF;
1411:
1412: end;
1413:

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

1642: FND_MSG_PUB.initialize;
1643: END IF;
1644:
1645: -- Debug info.
1646: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1647: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(+)',
1648: p_prefix=>l_debug_prefix,
1649: p_msg_level=>fnd_log.level_procedure);
1650: END IF;

Line 1649: p_msg_level=>fnd_log.level_procedure);

1645: -- Debug info.
1646: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1647: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(+)',
1648: p_prefix=>l_debug_prefix,
1649: p_msg_level=>fnd_log.level_procedure);
1650: END IF;
1651:
1652: -- initialize Global variable
1653: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

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

1816: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1817: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1818:
1819: -- Debug info.
1820: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1821: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1822: p_msg_data=>x_msg_data,
1823: p_msg_type=>'WARNING',
1824: p_msg_level=>fnd_log.level_exception);

Line 1824: p_msg_level=>fnd_log.level_exception);

1820: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1821: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1822: p_msg_data=>x_msg_data,
1823: p_msg_type=>'WARNING',
1824: p_msg_level=>fnd_log.level_exception);
1825: END IF;
1826: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1827: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',
1828: p_prefix=>l_debug_prefix,

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

1822: p_msg_data=>x_msg_data,
1823: p_msg_type=>'WARNING',
1824: p_msg_level=>fnd_log.level_exception);
1825: END IF;
1826: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1827: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',
1828: p_prefix=>l_debug_prefix,
1829: p_msg_level=>fnd_log.level_procedure);
1830: END IF;

Line 1829: p_msg_level=>fnd_log.level_procedure);

1825: END IF;
1826: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1827: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',
1828: p_prefix=>l_debug_prefix,
1829: p_msg_level=>fnd_log.level_procedure);
1830: END IF;
1831:
1832: EXCEPTION
1833: WHEN fnd_api.g_exc_error THEN

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

1847: p_count => x_msg_count,
1848: p_data => x_msg_data);
1849:
1850: -- Debug info.
1851: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1852: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1853: p_msg_data=>x_msg_data,
1854: p_msg_type=>'ERROR',
1855: p_msg_level=>fnd_log.level_error);

Line 1855: p_msg_level=>fnd_log.level_error);

1851: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1852: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1853: p_msg_data=>x_msg_data,
1854: p_msg_type=>'ERROR',
1855: p_msg_level=>fnd_log.level_error);
1856: END IF;
1857: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1858: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',
1859: p_prefix=>l_debug_prefix,

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

1853: p_msg_data=>x_msg_data,
1854: p_msg_type=>'ERROR',
1855: p_msg_level=>fnd_log.level_error);
1856: END IF;
1857: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1858: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',
1859: p_prefix=>l_debug_prefix,
1860: p_msg_level=>fnd_log.level_procedure);
1861: END IF;

Line 1860: p_msg_level=>fnd_log.level_procedure);

1856: END IF;
1857: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1858: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',
1859: p_prefix=>l_debug_prefix,
1860: p_msg_level=>fnd_log.level_procedure);
1861: END IF;
1862:
1863: WHEN fnd_api.g_exc_unexpected_error THEN
1864: ROLLBACK TO do_create_cas_v2_bo_pub;

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

1877: p_count => x_msg_count,
1878: p_data => x_msg_data);
1879:
1880: -- Debug info.
1881: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1882: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1883: p_msg_data=>x_msg_data,
1884: p_msg_type=>'UNEXPECTED ERROR',
1885: p_msg_level=>fnd_log.level_error);

Line 1885: p_msg_level=>fnd_log.level_error);

1881: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1882: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1883: p_msg_data=>x_msg_data,
1884: p_msg_type=>'UNEXPECTED ERROR',
1885: p_msg_level=>fnd_log.level_error);
1886: END IF;
1887: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1888: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',
1889: p_prefix=>l_debug_prefix,

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

1883: p_msg_data=>x_msg_data,
1884: p_msg_type=>'UNEXPECTED ERROR',
1885: p_msg_level=>fnd_log.level_error);
1886: END IF;
1887: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1888: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',
1889: p_prefix=>l_debug_prefix,
1890: p_msg_level=>fnd_log.level_procedure);
1891: END IF;

Line 1890: p_msg_level=>fnd_log.level_procedure);

1886: END IF;
1887: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1888: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',
1889: p_prefix=>l_debug_prefix,
1890: p_msg_level=>fnd_log.level_procedure);
1891: END IF;
1892:
1893: WHEN OTHERS THEN
1894: ROLLBACK TO do_create_cas_v2_bo_pub;

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

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

Line 1919: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1924: p_msg_level=>fnd_log.level_procedure);

1920: END IF;
1921: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1922: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_site_v2_bo(-)',
1923: p_prefix=>l_debug_prefix,
1924: p_msg_level=>fnd_log.level_procedure);
1925: END IF;
1926: END do_create_cust_acct_site_v2_bo;
1927:
1928:

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

2018: FND_MSG_PUB.initialize;
2019: END IF;
2020:
2021: -- Debug info.
2022: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2023: hz_utility_v2pub.debug(p_message=>'do_update_cas_bo(+)',
2024: p_prefix=>l_debug_prefix,
2025: p_msg_level=>fnd_log.level_procedure);
2026: END IF;

Line 2025: p_msg_level=>fnd_log.level_procedure);

2021: -- Debug info.
2022: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2023: hz_utility_v2pub.debug(p_message=>'do_update_cas_bo(+)',
2024: p_prefix=>l_debug_prefix,
2025: p_msg_level=>fnd_log.level_procedure);
2026: END IF;
2027:
2028: -- initialize Global variable
2029: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

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

2137: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2138: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2139:
2140: -- Debug info.
2141: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2142: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2143: p_msg_data=>x_msg_data,
2144: p_msg_type=>'WARNING',
2145: p_msg_level=>fnd_log.level_exception);

Line 2145: p_msg_level=>fnd_log.level_exception);

2141: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2142: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2143: p_msg_data=>x_msg_data,
2144: p_msg_type=>'WARNING',
2145: p_msg_level=>fnd_log.level_exception);
2146: END IF;
2147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2148: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2149: p_prefix=>l_debug_prefix,

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

2143: p_msg_data=>x_msg_data,
2144: p_msg_type=>'WARNING',
2145: p_msg_level=>fnd_log.level_exception);
2146: END IF;
2147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2148: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2149: p_prefix=>l_debug_prefix,
2150: p_msg_level=>fnd_log.level_procedure);
2151: END IF;

Line 2150: p_msg_level=>fnd_log.level_procedure);

2146: END IF;
2147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2148: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2149: p_prefix=>l_debug_prefix,
2150: p_msg_level=>fnd_log.level_procedure);
2151: END IF;
2152: EXCEPTION
2153: WHEN fnd_api.g_exc_error THEN
2154: ROLLBACK TO do_update_cas_v2_bo_pub;

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

2167: p_count => x_msg_count,
2168: p_data => x_msg_data);
2169:
2170: -- Debug info.
2171: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2172: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2173: p_msg_data=>x_msg_data,
2174: p_msg_type=>'ERROR',
2175: p_msg_level=>fnd_log.level_error);

Line 2175: p_msg_level=>fnd_log.level_error);

2171: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2172: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2173: p_msg_data=>x_msg_data,
2174: p_msg_type=>'ERROR',
2175: p_msg_level=>fnd_log.level_error);
2176: END IF;
2177: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2178: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2179: p_prefix=>l_debug_prefix,

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

2173: p_msg_data=>x_msg_data,
2174: p_msg_type=>'ERROR',
2175: p_msg_level=>fnd_log.level_error);
2176: END IF;
2177: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2178: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2179: p_prefix=>l_debug_prefix,
2180: p_msg_level=>fnd_log.level_procedure);
2181: END IF;

Line 2180: p_msg_level=>fnd_log.level_procedure);

2176: END IF;
2177: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2178: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2179: p_prefix=>l_debug_prefix,
2180: p_msg_level=>fnd_log.level_procedure);
2181: END IF;
2182:
2183: WHEN fnd_api.g_exc_unexpected_error THEN
2184: ROLLBACK TO do_update_cas_v2_bo_pub;

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

2197: p_count => x_msg_count,
2198: p_data => x_msg_data);
2199:
2200: -- Debug info.
2201: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2202: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2203: p_msg_data=>x_msg_data,
2204: p_msg_type=>'UNEXPECTED ERROR',
2205: p_msg_level=>fnd_log.level_error);

Line 2205: p_msg_level=>fnd_log.level_error);

2201: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2202: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2203: p_msg_data=>x_msg_data,
2204: p_msg_type=>'UNEXPECTED ERROR',
2205: p_msg_level=>fnd_log.level_error);
2206: END IF;
2207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2209: p_prefix=>l_debug_prefix,

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

2203: p_msg_data=>x_msg_data,
2204: p_msg_type=>'UNEXPECTED ERROR',
2205: p_msg_level=>fnd_log.level_error);
2206: END IF;
2207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2209: p_prefix=>l_debug_prefix,
2210: p_msg_level=>fnd_log.level_procedure);
2211: END IF;

Line 2210: p_msg_level=>fnd_log.level_procedure);

2206: END IF;
2207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2209: p_prefix=>l_debug_prefix,
2210: p_msg_level=>fnd_log.level_procedure);
2211: END IF;
2212:
2213: WHEN OTHERS THEN
2214: ROLLBACK TO do_update_cas_v2_bo_pub;

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

2231: p_count => x_msg_count,
2232: p_data => x_msg_data);
2233:
2234: -- Debug info.
2235: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2236: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2237: p_msg_data=>x_msg_data,
2238: p_msg_type=>'SQL ERROR',
2239: p_msg_level=>fnd_log.level_error);

Line 2239: p_msg_level=>fnd_log.level_error);

2235: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2236: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2237: p_msg_data=>x_msg_data,
2238: p_msg_type=>'SQL ERROR',
2239: p_msg_level=>fnd_log.level_error);
2240: END IF;
2241: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2242: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2243: p_prefix=>l_debug_prefix,

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

2237: p_msg_data=>x_msg_data,
2238: p_msg_type=>'SQL ERROR',
2239: p_msg_level=>fnd_log.level_error);
2240: END IF;
2241: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2242: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2243: p_prefix=>l_debug_prefix,
2244: p_msg_level=>fnd_log.level_procedure);
2245: END IF;

Line 2244: p_msg_level=>fnd_log.level_procedure);

2240: END IF;
2241: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2242: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_site_v2_bo(-)',
2243: p_prefix=>l_debug_prefix,
2244: p_msg_level=>fnd_log.level_procedure);
2245: END IF;
2246: END do_update_cust_acct_site_v2_bo;
2247:
2248: PROCEDURE update_cust_acct_site_v2_bo(

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

2318: FND_MSG_PUB.initialize;
2319: END IF;
2320:
2321: -- Debug info.
2322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2323: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(+)',
2324: p_prefix=>l_debug_prefix,
2325: p_msg_level=>fnd_log.level_procedure);
2326: END IF;

Line 2325: p_msg_level=>fnd_log.level_procedure);

2321: -- Debug info.
2322: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2323: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(+)',
2324: p_prefix=>l_debug_prefix,
2325: p_msg_level=>fnd_log.level_procedure);
2326: END IF;
2327:
2328: x_cust_acct_site_id := p_cust_acct_site_v2_obj.cust_acct_site_id;
2329: x_cust_acct_site_os := p_cust_acct_site_v2_obj.orig_system;

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

2381: RAISE FND_API.G_EXC_ERROR;
2382: END IF;
2383:
2384: -- Debug info.
2385: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2386: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2387: p_msg_data=>x_msg_data,
2388: p_msg_type=>'WARNING',
2389: p_msg_level=>fnd_log.level_exception);

Line 2389: p_msg_level=>fnd_log.level_exception);

2385: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2386: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2387: p_msg_data=>x_msg_data,
2388: p_msg_type=>'WARNING',
2389: p_msg_level=>fnd_log.level_exception);
2390: END IF;
2391: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2392: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2393: p_prefix=>l_debug_prefix,

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

2387: p_msg_data=>x_msg_data,
2388: p_msg_type=>'WARNING',
2389: p_msg_level=>fnd_log.level_exception);
2390: END IF;
2391: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2392: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2393: p_prefix=>l_debug_prefix,
2394: p_msg_level=>fnd_log.level_procedure);
2395: END IF;

Line 2394: p_msg_level=>fnd_log.level_procedure);

2390: END IF;
2391: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2392: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2393: p_prefix=>l_debug_prefix,
2394: p_msg_level=>fnd_log.level_procedure);
2395: END IF;
2396:
2397: EXCEPTION
2398: WHEN fnd_api.g_exc_error THEN

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

2402: p_count => x_msg_count,
2403: p_data => x_msg_data);
2404:
2405: -- Debug info.
2406: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2407: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2408: p_msg_data=>x_msg_data,
2409: p_msg_type=>'ERROR',
2410: p_msg_level=>fnd_log.level_error);

Line 2410: p_msg_level=>fnd_log.level_error);

2406: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2407: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2408: p_msg_data=>x_msg_data,
2409: p_msg_type=>'ERROR',
2410: p_msg_level=>fnd_log.level_error);
2411: END IF;
2412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2413: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2414: p_prefix=>l_debug_prefix,

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

2408: p_msg_data=>x_msg_data,
2409: p_msg_type=>'ERROR',
2410: p_msg_level=>fnd_log.level_error);
2411: END IF;
2412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2413: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2414: p_prefix=>l_debug_prefix,
2415: p_msg_level=>fnd_log.level_procedure);
2416: END IF;

Line 2415: p_msg_level=>fnd_log.level_procedure);

2411: END IF;
2412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2413: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2414: p_prefix=>l_debug_prefix,
2415: p_msg_level=>fnd_log.level_procedure);
2416: END IF;
2417: WHEN fnd_api.g_exc_unexpected_error THEN
2418: x_return_status := fnd_api.g_ret_sts_unexp_error;
2419:

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

2421: p_count => x_msg_count,
2422: p_data => x_msg_data);
2423:
2424: -- Debug info.
2425: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2426: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2427: p_msg_data=>x_msg_data,
2428: p_msg_type=>'UNEXPECTED ERROR',
2429: p_msg_level=>fnd_log.level_error);

Line 2429: p_msg_level=>fnd_log.level_error);

2425: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2426: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2427: p_msg_data=>x_msg_data,
2428: p_msg_type=>'UNEXPECTED ERROR',
2429: p_msg_level=>fnd_log.level_error);
2430: END IF;
2431: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2432: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2433: p_prefix=>l_debug_prefix,

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

2427: p_msg_data=>x_msg_data,
2428: p_msg_type=>'UNEXPECTED ERROR',
2429: p_msg_level=>fnd_log.level_error);
2430: END IF;
2431: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2432: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2433: p_prefix=>l_debug_prefix,
2434: p_msg_level=>fnd_log.level_procedure);
2435: END IF;

Line 2434: p_msg_level=>fnd_log.level_procedure);

2430: END IF;
2431: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2432: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2433: p_prefix=>l_debug_prefix,
2434: p_msg_level=>fnd_log.level_procedure);
2435: END IF;
2436: WHEN OTHERS THEN
2437: x_return_status := fnd_api.g_ret_sts_unexp_error;
2438:

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

2444: p_count => x_msg_count,
2445: p_data => x_msg_data);
2446:
2447: -- Debug info.
2448: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2449: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2450: p_msg_data=>x_msg_data,
2451: p_msg_type=>'SQL ERROR',
2452: p_msg_level=>fnd_log.level_error);

Line 2452: p_msg_level=>fnd_log.level_error);

2448: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2449: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2450: p_msg_data=>x_msg_data,
2451: p_msg_type=>'SQL ERROR',
2452: p_msg_level=>fnd_log.level_error);
2453: END IF;
2454: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2455: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2456: p_prefix=>l_debug_prefix,

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

2450: p_msg_data=>x_msg_data,
2451: p_msg_type=>'SQL ERROR',
2452: p_msg_level=>fnd_log.level_error);
2453: END IF;
2454: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2455: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2456: p_prefix=>l_debug_prefix,
2457: p_msg_level=>fnd_log.level_procedure);
2458: END IF;

Line 2457: p_msg_level=>fnd_log.level_procedure);

2453: END IF;
2454: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2455: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_site_v2_bo(-)',
2456: p_prefix=>l_debug_prefix,
2457: p_msg_level=>fnd_log.level_procedure);
2458: END IF;
2459: END do_save_cust_acct_site_v2_bo;
2460:
2461: PROCEDURE save_cust_acct_site_v2_bo(

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

2593: END IF;
2594:
2595:
2596: -- Debug info.
2597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2598: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo(+)',
2599: p_prefix=>l_debug_prefix,
2600: p_msg_level=>fnd_log.level_procedure);
2601: END IF;

Line 2600: p_msg_level=>fnd_log.level_procedure);

2596: -- Debug info.
2597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2598: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_bo(+)',
2599: p_prefix=>l_debug_prefix,
2600: p_msg_level=>fnd_log.level_procedure);
2601: END IF;
2602:
2603: -- check if pass in contact_point_id and/or os+osr
2604: -- extraction validation logic is same as update

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

2637: END IF;
2638:
2639:
2640: -- Debug info.
2641: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2642: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2643: p_msg_data=>x_msg_data,
2644: p_msg_type=>'WARNING',
2645: p_msg_level=>fnd_log.level_exception);

Line 2645: p_msg_level=>fnd_log.level_exception);

2641: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2642: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2643: p_msg_data=>x_msg_data,
2644: p_msg_type=>'WARNING',
2645: p_msg_level=>fnd_log.level_exception);
2646: END IF;
2647:
2648: -- Debug info.
2649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

2645: p_msg_level=>fnd_log.level_exception);
2646: END IF;
2647:
2648: -- Debug info.
2649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2650: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2651: p_prefix=>l_debug_prefix,
2652: p_msg_level=>fnd_log.level_procedure);
2653: END IF;

Line 2652: p_msg_level=>fnd_log.level_procedure);

2648: -- Debug info.
2649: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2650: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2651: p_prefix=>l_debug_prefix,
2652: p_msg_level=>fnd_log.level_procedure);
2653: END IF;
2654:
2655:
2656: EXCEPTION

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

2662: p_count => x_msg_count,
2663: p_data => x_msg_data);
2664:
2665: -- Debug info.
2666: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2667: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2668: p_msg_data=>x_msg_data,
2669: p_msg_type=>'ERROR',
2670: p_msg_level=>fnd_log.level_error);

Line 2670: p_msg_level=>fnd_log.level_error);

2666: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2667: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2668: p_msg_data=>x_msg_data,
2669: p_msg_type=>'ERROR',
2670: p_msg_level=>fnd_log.level_error);
2671: END IF;
2672: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2673: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2674: p_prefix=>l_debug_prefix,

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

2668: p_msg_data=>x_msg_data,
2669: p_msg_type=>'ERROR',
2670: p_msg_level=>fnd_log.level_error);
2671: END IF;
2672: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2673: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2674: p_prefix=>l_debug_prefix,
2675: p_msg_level=>fnd_log.level_procedure);
2676: END IF;

Line 2675: p_msg_level=>fnd_log.level_procedure);

2671: END IF;
2672: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2673: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2674: p_prefix=>l_debug_prefix,
2675: p_msg_level=>fnd_log.level_procedure);
2676: END IF;
2677: WHEN fnd_api.g_exc_unexpected_error THEN
2678: x_return_status := fnd_api.g_ret_sts_unexp_error;
2679:

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

2681: p_count => x_msg_count,
2682: p_data => x_msg_data);
2683:
2684: -- Debug info.
2685: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2686: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2687: p_msg_data=>x_msg_data,
2688: p_msg_type=>'UNEXPECTED ERROR',
2689: p_msg_level=>fnd_log.level_error);

Line 2689: p_msg_level=>fnd_log.level_error);

2685: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2686: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2687: p_msg_data=>x_msg_data,
2688: p_msg_type=>'UNEXPECTED ERROR',
2689: p_msg_level=>fnd_log.level_error);
2690: END IF;
2691: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2692: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2693: p_prefix=>l_debug_prefix,

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

2687: p_msg_data=>x_msg_data,
2688: p_msg_type=>'UNEXPECTED ERROR',
2689: p_msg_level=>fnd_log.level_error);
2690: END IF;
2691: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2692: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2693: p_prefix=>l_debug_prefix,
2694: p_msg_level=>fnd_log.level_procedure);
2695: END IF;

Line 2694: p_msg_level=>fnd_log.level_procedure);

2690: END IF;
2691: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2692: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2693: p_prefix=>l_debug_prefix,
2694: p_msg_level=>fnd_log.level_procedure);
2695: END IF;
2696: WHEN OTHERS THEN
2697: x_return_status := fnd_api.g_ret_sts_unexp_error;
2698:

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

2704: p_count => x_msg_count,
2705: p_data => x_msg_data);
2706:
2707: -- Debug info.
2708: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2709: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2710: p_msg_data=>x_msg_data,
2711: p_msg_type=>'SQL ERROR',
2712: p_msg_level=>fnd_log.level_error);

Line 2712: p_msg_level=>fnd_log.level_error);

2708: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2709: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2710: p_msg_data=>x_msg_data,
2711: p_msg_type=>'SQL ERROR',
2712: p_msg_level=>fnd_log.level_error);
2713: END IF;
2714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2715: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2716: p_prefix=>l_debug_prefix,

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

2710: p_msg_data=>x_msg_data,
2711: p_msg_type=>'SQL ERROR',
2712: p_msg_level=>fnd_log.level_error);
2713: END IF;
2714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2715: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2716: p_prefix=>l_debug_prefix,
2717: p_msg_level=>fnd_log.level_procedure);
2718: END IF;

Line 2717: p_msg_level=>fnd_log.level_procedure);

2713: END IF;
2714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2715: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_site_bo_pub.get_cust_acct_site_v2_bo (-)',
2716: p_prefix=>l_debug_prefix,
2717: p_msg_level=>fnd_log.level_procedure);
2718: END IF;
2719:
2720: end;
2721: