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

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

200: l_debug_prefix VARCHAR2(30) := '';
201:
202: BEGIN
203: -- Debug info.
204: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
205: hz_utility_v2pub.debug(p_message=>'validate_parent_bank (+)',
206: p_prefix=>l_debug_prefix,
207: p_msg_level=>fnd_log.level_procedure);
208: END IF;

Line 207: p_msg_level=>fnd_log.level_procedure);

203: -- Debug info.
204: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
205: hz_utility_v2pub.debug(p_message=>'validate_parent_bank (+)',
206: p_prefix=>l_debug_prefix,
207: p_msg_level=>fnd_log.level_procedure);
208: END IF;
209:
210: --
211: -- The parent bank checks should only be performed if a parent bank was

Line 301: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

297: x_return_status := fnd_api.g_ret_sts_error;
298: END IF;
299:
300: -- Debug info.
301: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
302: hz_utility_v2pub.debug(p_message=>'l_parent_id = '||l_parent_id,
303: p_prefix=>l_debug_prefix,
304: p_msg_level=>fnd_log.level_statement);
305: END IF;

Line 304: p_msg_level=>fnd_log.level_statement);

300: -- Debug info.
301: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
302: hz_utility_v2pub.debug(p_message=>'l_parent_id = '||l_parent_id,
303: p_prefix=>l_debug_prefix,
304: p_msg_level=>fnd_log.level_statement);
305: END IF;
306:
307: /*
308: --Bug14353281

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

346: END IF;
347: CLOSE c_uniquenameck;
348: */ -- End of Bug14353281
349: -- Debug info.
350: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
351: hz_utility_v2pub.debug(p_message=>'validate_parent_bank (-)',
352: p_prefix=>l_debug_prefix,
353: p_msg_level=>fnd_log.level_procedure);
354: END IF;

Line 353: p_msg_level=>fnd_log.level_procedure);

349: -- Debug info.
350: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
351: hz_utility_v2pub.debug(p_message=>'validate_parent_bank (-)',
352: p_prefix=>l_debug_prefix,
353: p_msg_level=>fnd_log.level_procedure);
354: END IF;
355: END validate_parent_bank;
356:
357: /*=======================================================================+

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

392: -- Bug 3814832
393: l_country VARCHAR2(2);
394: BEGIN
395: -- Debug info.
396: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
397: hz_utility_v2pub.debug(p_message=>'validate_bank_org (+)',
398: p_prefix=>l_debug_prefix,
399: p_msg_level=>fnd_log.level_procedure);
400: END IF;

Line 399: p_msg_level=>fnd_log.level_procedure);

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

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

531: EXCEPTION
532: WHEN hz_dyn_validation.null_profile_value THEN
533: -- this error indicates that the profile value has not been set.
534: -- ignore this error
535: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
536: hz_utility_v2pub.debug(p_message=>'undefined profile:'||l_validation_procedure,
537: p_prefix=>'WARNING',
538: p_msg_level=>fnd_log.level_exception);
539: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 538: p_msg_level=>fnd_log.level_exception);

534: -- ignore this error
535: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
536: hz_utility_v2pub.debug(p_message=>'undefined profile:'||l_validation_procedure,
537: p_prefix=>'WARNING',
538: p_msg_level=>fnd_log.level_exception);
539: hz_utility_v2pub.debug(p_message=>'error ignored',
540: p_prefix=>'WARNING',
541: p_msg_level=>fnd_log.level_exception);
542: END IF;

Line 541: p_msg_level=>fnd_log.level_exception);

537: p_prefix=>'WARNING',
538: p_msg_level=>fnd_log.level_exception);
539: hz_utility_v2pub.debug(p_message=>'error ignored',
540: p_prefix=>'WARNING',
541: p_msg_level=>fnd_log.level_exception);
542: END IF;
543:
544: WHEN OTHERS THEN
545: -- set the error status, don't need to set the error stack because

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

547: x_return_status := fnd_api.g_ret_sts_error;
548: END;
549:
550: -- Debug info.
551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
552: hz_utility_v2pub.debug(p_message=>'validate_bank_org (-)',
553: p_prefix=>l_debug_prefix,
554: p_msg_level=>fnd_log.level_procedure);
555: END IF;

Line 554: p_msg_level=>fnd_log.level_procedure);

550: -- Debug info.
551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
552: hz_utility_v2pub.debug(p_message=>'validate_bank_org (-)',
553: p_prefix=>l_debug_prefix,
554: p_msg_level=>fnd_log.level_procedure);
555: END IF;
556: END validate_bank_org;
557:
558: /*=======================================================================+

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

613: l_dummy NUMBER;
614: l_debug_prefix VARCHAR2(30) := '';
615: BEGIN
616: -- Debug info.
617: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
618: hz_utility_v2pub.debug(p_message=>'validate_edi_contact_point (+)',
619: p_prefix=>l_debug_prefix,
620: p_msg_level=>fnd_log.level_procedure);
621: END IF;

Line 620: p_msg_level=>fnd_log.level_procedure);

616: -- Debug info.
617: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
618: hz_utility_v2pub.debug(p_message=>'validate_edi_contact_point (+)',
619: p_prefix=>l_debug_prefix,
620: p_msg_level=>fnd_log.level_procedure);
621: END IF;
622:
623: -- Validate uniqueness of EDI record.
624: -- first check across party contacts.

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

655: EXCEPTION
656: WHEN hz_dyn_validation.null_profile_value THEN
657: -- this error indicates that the profile value has not been set.
658: -- ignore this error
659: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
660: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
661: p_prefix=>'WARNING',
662: p_msg_level=>fnd_log.level_exception);
663: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 662: p_msg_level=>fnd_log.level_exception);

658: -- ignore this error
659: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
660: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
661: p_prefix=>'WARNING',
662: p_msg_level=>fnd_log.level_exception);
663: hz_utility_v2pub.debug(p_message=>'error ignored',
664: p_prefix=>'WARNING',
665: p_msg_level=>fnd_log.level_exception);
666: END IF;

Line 665: p_msg_level=>fnd_log.level_exception);

661: p_prefix=>'WARNING',
662: p_msg_level=>fnd_log.level_exception);
663: hz_utility_v2pub.debug(p_message=>'error ignored',
664: p_prefix=>'WARNING',
665: p_msg_level=>fnd_log.level_exception);
666: END IF;
667: WHEN OTHERS THEN
668: -- set the error status, don't need to set the error stack because
669: -- the dynamic validation procedure already does so.

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

670: x_return_status := fnd_api.g_ret_sts_error;
671: END;
672:
673: -- Debug info.
674: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
675: hz_utility_v2pub.debug(p_message=>'validate_edi_contact_point (+)',
676: p_prefix=>l_debug_prefix,
677: p_msg_level=>fnd_log.level_procedure);
678: END IF;

Line 677: p_msg_level=>fnd_log.level_procedure);

673: -- Debug info.
674: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
675: hz_utility_v2pub.debug(p_message=>'validate_edi_contact_point (+)',
676: p_prefix=>l_debug_prefix,
677: p_msg_level=>fnd_log.level_procedure);
678: END IF;
679: END validate_edi_contact_point;
680:
681: /*=======================================================================+

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

697: ) IS
698: l_debug_prefix VARCHAR2(30) := '';
699: BEGIN
700: -- Debug info.
701: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
702: hz_utility_v2pub.debug(p_message=>'validate_eft_contact_point (+)',
703: p_prefix=>l_debug_prefix,
704: p_msg_level=>fnd_log.level_procedure);
705: END IF;

Line 704: p_msg_level=>fnd_log.level_procedure);

700: -- Debug info.
701: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
702: hz_utility_v2pub.debug(p_message=>'validate_eft_contact_point (+)',
703: p_prefix=>l_debug_prefix,
704: p_msg_level=>fnd_log.level_procedure);
705: END IF;
706:
707: BEGIN
708: hz_dyn_validation.validate_contact_point(

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

718: EXCEPTION
719: WHEN hz_dyn_validation.null_profile_value THEN
720: -- this error indicates that the profile value has not been set.
721: -- ignore this error
722: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
723: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
724: p_prefix=>'WARNING',
725: p_msg_level=>fnd_log.level_exception);
726: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 725: p_msg_level=>fnd_log.level_exception);

721: -- ignore this error
722: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
723: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
724: p_prefix=>'WARNING',
725: p_msg_level=>fnd_log.level_exception);
726: hz_utility_v2pub.debug(p_message=>'error ignored',
727: p_prefix=>'WARNING',
728: p_msg_level=>fnd_log.level_exception);
729: END IF;

Line 728: p_msg_level=>fnd_log.level_exception);

724: p_prefix=>'WARNING',
725: p_msg_level=>fnd_log.level_exception);
726: hz_utility_v2pub.debug(p_message=>'error ignored',
727: p_prefix=>'WARNING',
728: p_msg_level=>fnd_log.level_exception);
729: END IF;
730: WHEN OTHERS THEN
731: -- set the error status, don't need to set the error stack because
732: -- the dynamic validation procedure already does so.

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

733: x_return_status := fnd_api.g_ret_sts_error;
734: END;
735:
736: -- Debug info.
737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
738: hz_utility_v2pub.debug(p_message=>'validate_eft_contact_point (+)',
739: p_prefix=>l_debug_prefix,
740: p_msg_level=>fnd_log.level_procedure);
741: END IF;

Line 740: p_msg_level=>fnd_log.level_procedure);

736: -- Debug info.
737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
738: hz_utility_v2pub.debug(p_message=>'validate_eft_contact_point (+)',
739: p_prefix=>l_debug_prefix,
740: p_msg_level=>fnd_log.level_procedure);
741: END IF;
742: END validate_eft_contact_point;
743:
744: /*=======================================================================+

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

760: ) IS
761: l_debug_prefix VARCHAR2(30) := '';
762: BEGIN
763: -- Debug info.
764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
765: hz_utility_v2pub.debug(p_message=>'validate_web_contact_point (+)',
766: p_prefix=>l_debug_prefix,
767: p_msg_level=>fnd_log.level_procedure);
768: END IF;

Line 767: p_msg_level=>fnd_log.level_procedure);

763: -- Debug info.
764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
765: hz_utility_v2pub.debug(p_message=>'validate_web_contact_point (+)',
766: p_prefix=>l_debug_prefix,
767: p_msg_level=>fnd_log.level_procedure);
768: END IF;
769:
770: BEGIN
771: hz_dyn_validation.validate_contact_point(

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

781: EXCEPTION
782: WHEN hz_dyn_validation.null_profile_value THEN
783: -- this error indicates that the profile value has not been set.
784: -- ignore this error
785: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
786: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
787: p_prefix=>'WARNING',
788: p_msg_level=>fnd_log.level_exception);
789: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 788: p_msg_level=>fnd_log.level_exception);

784: -- ignore this error
785: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
786: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
787: p_prefix=>'WARNING',
788: p_msg_level=>fnd_log.level_exception);
789: hz_utility_v2pub.debug(p_message=>'error ignored',
790: p_prefix=>'WARNING',
791: p_msg_level=>fnd_log.level_exception);
792: END IF;

Line 791: p_msg_level=>fnd_log.level_exception);

787: p_prefix=>'WARNING',
788: p_msg_level=>fnd_log.level_exception);
789: hz_utility_v2pub.debug(p_message=>'error ignored',
790: p_prefix=>'WARNING',
791: p_msg_level=>fnd_log.level_exception);
792: END IF;
793:
794: WHEN OTHERS THEN
795: -- set the error status, don't need to set the error stack because

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

797: x_return_status := fnd_api.g_ret_sts_error;
798: END;
799:
800: -- Debug info.
801: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
802: hz_utility_v2pub.debug(p_message=>'validate_web_contact_point (+)',
803: p_prefix=>l_debug_prefix,
804: p_msg_level=>fnd_log.level_procedure);
805: END IF;

Line 804: p_msg_level=>fnd_log.level_procedure);

800: -- Debug info.
801: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
802: hz_utility_v2pub.debug(p_message=>'validate_web_contact_point (+)',
803: p_prefix=>l_debug_prefix,
804: p_msg_level=>fnd_log.level_procedure);
805: END IF;
806: END validate_web_contact_point;
807:
808: /*=======================================================================+

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

824: ) IS
825: l_debug_prefix VARCHAR2(30) := '';
826: BEGIN
827: -- Debug info.
828: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
829: hz_utility_v2pub.debug(p_message=>'validate_phone_contact_point (+)',
830: p_prefix=>l_debug_prefix,
831: p_msg_level=>fnd_log.level_procedure);
832: END IF;

Line 831: p_msg_level=>fnd_log.level_procedure);

827: -- Debug info.
828: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
829: hz_utility_v2pub.debug(p_message=>'validate_phone_contact_point (+)',
830: p_prefix=>l_debug_prefix,
831: p_msg_level=>fnd_log.level_procedure);
832: END IF;
833:
834: BEGIN
835: hz_dyn_validation.validate_contact_point(

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

845: EXCEPTION
846: WHEN hz_dyn_validation.null_profile_value THEN
847: -- this error indicates that the profile value has not been set.
848: -- ignore this error
849: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
850: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
851: p_prefix=>'WARNING',
852: p_msg_level=>fnd_log.level_exception);
853: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 852: p_msg_level=>fnd_log.level_exception);

848: -- ignore this error
849: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
850: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
851: p_prefix=>'WARNING',
852: p_msg_level=>fnd_log.level_exception);
853: hz_utility_v2pub.debug(p_message=>'error ignored',
854: p_prefix=>'WARNING',
855: p_msg_level=>fnd_log.level_exception);
856: END IF;

Line 855: p_msg_level=>fnd_log.level_exception);

851: p_prefix=>'WARNING',
852: p_msg_level=>fnd_log.level_exception);
853: hz_utility_v2pub.debug(p_message=>'error ignored',
854: p_prefix=>'WARNING',
855: p_msg_level=>fnd_log.level_exception);
856: END IF;
857:
858: WHEN OTHERS THEN
859: -- set the error status, don't need to set the error stack because

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

861: x_return_status := fnd_api.g_ret_sts_error;
862: END;
863:
864: -- Debug info.
865: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
866: hz_utility_v2pub.debug(p_message=>'validate_phone_contact_point (+)',
867: p_prefix=>l_debug_prefix,
868: p_msg_level=>fnd_log.level_procedure);
869: END IF;

Line 868: p_msg_level=>fnd_log.level_procedure);

864: -- Debug info.
865: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
866: hz_utility_v2pub.debug(p_message=>'validate_phone_contact_point (+)',
867: p_prefix=>l_debug_prefix,
868: p_msg_level=>fnd_log.level_procedure);
869: END IF;
870: END validate_phone_contact_point;
871:
872: /*=======================================================================+

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

888: ) IS
889: l_debug_prefix VARCHAR2(30) := '';
890: BEGIN
891: -- Debug info.
892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
893: hz_utility_v2pub.debug(p_message=>'validate_email_contact_point (+)',
894: p_prefix=>l_debug_prefix,
895: p_msg_level=>fnd_log.level_procedure);
896: END IF;

Line 895: p_msg_level=>fnd_log.level_procedure);

891: -- Debug info.
892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
893: hz_utility_v2pub.debug(p_message=>'validate_email_contact_point (+)',
894: p_prefix=>l_debug_prefix,
895: p_msg_level=>fnd_log.level_procedure);
896: END IF;
897:
898: BEGIN
899: hz_dyn_validation.validate_contact_point(

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

909: EXCEPTION
910: WHEN hz_dyn_validation.null_profile_value THEN
911: -- this error indicates that the profile value has not been set.
912: -- ignore this error
913: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
914: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
915: p_prefix=>'WARNING',
916: p_msg_level=>fnd_log.level_exception);
917: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 916: p_msg_level=>fnd_log.level_exception);

912: -- ignore this error
913: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
914: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
915: p_prefix=>'WARNING',
916: p_msg_level=>fnd_log.level_exception);
917: hz_utility_v2pub.debug(p_message=>'error ignored',
918: p_prefix=>'WARNING',
919: p_msg_level=>fnd_log.level_exception);
920: END IF;

Line 919: p_msg_level=>fnd_log.level_exception);

915: p_prefix=>'WARNING',
916: p_msg_level=>fnd_log.level_exception);
917: hz_utility_v2pub.debug(p_message=>'error ignored',
918: p_prefix=>'WARNING',
919: p_msg_level=>fnd_log.level_exception);
920: END IF;
921: WHEN OTHERS THEN
922: -- set the error status, don't need to set the error stack because
923: -- the dynamic validation procedure already does so.

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

924: x_return_status := fnd_api.g_ret_sts_error;
925: END;
926:
927: -- Debug info.
928: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
929: hz_utility_v2pub.debug(p_message=>'validate_email_contact_point (+)',
930: p_prefix=>l_debug_prefix,
931: p_msg_level=>fnd_log.level_procedure);
932: END IF;

Line 931: p_msg_level=>fnd_log.level_procedure);

927: -- Debug info.
928: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
929: hz_utility_v2pub.debug(p_message=>'validate_email_contact_point (+)',
930: p_prefix=>l_debug_prefix,
931: p_msg_level=>fnd_log.level_procedure);
932: END IF;
933: END validate_email_contact_point;
934:
935: /*=======================================================================+

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

951: ) IS
952: l_debug_prefix VARCHAR2(30) := '';
953: BEGIN
954: -- Debug info.
955: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
956: hz_utility_v2pub.debug(p_message=>'validate_telex_contact_point (+)',
957: p_prefix=>l_debug_prefix,
958: p_msg_level=>fnd_log.level_procedure);
959: END IF;

Line 958: p_msg_level=>fnd_log.level_procedure);

954: -- Debug info.
955: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
956: hz_utility_v2pub.debug(p_message=>'validate_telex_contact_point (+)',
957: p_prefix=>l_debug_prefix,
958: p_msg_level=>fnd_log.level_procedure);
959: END IF;
960:
961: BEGIN
962: hz_dyn_validation.validate_contact_point(

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

972: EXCEPTION
973: WHEN hz_dyn_validation.null_profile_value THEN
974: -- this error indicates that the profile value has not been set.
975: -- ignore this error
976: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
977: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
978: p_prefix=>'WARNING',
979: p_msg_level=>fnd_log.level_exception);
980: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 979: p_msg_level=>fnd_log.level_exception);

975: -- ignore this error
976: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
977: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
978: p_prefix=>'WARNING',
979: p_msg_level=>fnd_log.level_exception);
980: hz_utility_v2pub.debug(p_message=>'error ignored',
981: p_prefix=>'WARNING',
982: p_msg_level=>fnd_log.level_exception);
983: END IF;

Line 982: p_msg_level=>fnd_log.level_exception);

978: p_prefix=>'WARNING',
979: p_msg_level=>fnd_log.level_exception);
980: hz_utility_v2pub.debug(p_message=>'error ignored',
981: p_prefix=>'WARNING',
982: p_msg_level=>fnd_log.level_exception);
983: END IF;
984: WHEN OTHERS THEN
985: -- set the error status, don't need to set the error stack because
986: -- the dynamic validation procedure already does so.

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

987: x_return_status := fnd_api.g_ret_sts_error;
988: END;
989:
990: -- Debug info.
991: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
992: hz_utility_v2pub.debug(p_message=>'validate_telex_contact_point (+)',
993: p_prefix=>l_debug_prefix,
994: p_msg_level=>fnd_log.level_procedure);
995: END IF;

Line 994: p_msg_level=>fnd_log.level_procedure);

990: -- Debug info.
991: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
992: hz_utility_v2pub.debug(p_message=>'validate_telex_contact_point (+)',
993: p_prefix=>l_debug_prefix,
994: p_msg_level=>fnd_log.level_procedure);
995: END IF;
996: END validate_telex_contact_point;
997:
998: /*=======================================================================+

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

1013: ) IS
1014: l_debug_prefix VARCHAR2(30) := '';
1015: BEGIN
1016: -- Debug info.
1017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1018: hz_utility_v2pub.debug(p_message=>'validate_banking_group (+)',
1019: p_prefix=>l_debug_prefix,
1020: p_msg_level=>fnd_log.level_procedure);
1021: END IF;

Line 1020: p_msg_level=>fnd_log.level_procedure);

1016: -- Debug info.
1017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1018: hz_utility_v2pub.debug(p_message=>'validate_banking_group (+)',
1019: p_prefix=>l_debug_prefix,
1020: p_msg_level=>fnd_log.level_procedure);
1021: END IF;
1022:
1023: -- Only one group type is currently supported.
1024: IF p_group_rec.group_type <> 'BANKING_GROUP' THEN

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

1037: EXCEPTION
1038: WHEN hz_dyn_validation.null_profile_value THEN
1039: -- this error indicates that the profile value has not been set.
1040: -- ignore this error
1041: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1042: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANKING_GROUP_VALIDATION_PROCEDURE',
1043: p_prefix=>'WARNING',
1044: p_msg_level=>fnd_log.level_exception);
1045: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 1044: p_msg_level=>fnd_log.level_exception);

1040: -- ignore this error
1041: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1042: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANKING_GROUP_VALIDATION_PROCEDURE',
1043: p_prefix=>'WARNING',
1044: p_msg_level=>fnd_log.level_exception);
1045: hz_utility_v2pub.debug(p_message=>'error ignored',
1046: p_prefix=>'WARNING',
1047: p_msg_level=>fnd_log.level_exception);
1048: END IF;

Line 1047: p_msg_level=>fnd_log.level_exception);

1043: p_prefix=>'WARNING',
1044: p_msg_level=>fnd_log.level_exception);
1045: hz_utility_v2pub.debug(p_message=>'error ignored',
1046: p_prefix=>'WARNING',
1047: p_msg_level=>fnd_log.level_exception);
1048: END IF;
1049: WHEN OTHERS THEN
1050: -- set the error status, don't need to set the error stack because
1051: -- the dynamic validation procedure already does so.

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

1052: x_return_status := fnd_api.g_ret_sts_error;
1053: END;
1054:
1055: -- Debug info.
1056: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1057: hz_utility_v2pub.debug(p_message=>'validate_banking_group (+)',
1058: p_prefix=>l_debug_prefix,
1059: p_msg_level=>fnd_log.level_procedure);
1060: END IF;

Line 1059: p_msg_level=>fnd_log.level_procedure);

1055: -- Debug info.
1056: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1057: hz_utility_v2pub.debug(p_message=>'validate_banking_group (+)',
1058: p_prefix=>l_debug_prefix,
1059: p_msg_level=>fnd_log.level_procedure);
1060: END IF;
1061: END validate_banking_group;
1062:
1063: /*=======================================================================+

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

1121: l_bank_id NUMBER;
1122: l_debug_prefix VARCHAR2(30) := '';
1123: BEGIN
1124: -- Debug info.
1125: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1126: hz_utility_v2pub.debug(p_message=>'validate_bank_group_member (+)',
1127: p_prefix=>l_debug_prefix,
1128: p_msg_level=>fnd_log.level_procedure);
1129: END IF;

Line 1128: p_msg_level=>fnd_log.level_procedure);

1124: -- Debug info.
1125: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1126: hz_utility_v2pub.debug(p_message=>'validate_bank_group_member (+)',
1127: p_prefix=>l_debug_prefix,
1128: p_msg_level=>fnd_log.level_procedure);
1129: END IF;
1130:
1131: -- Only one group membership relationship type is currently supported.
1132: -- Only check if we are in insert mode or the relationship_type was

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

1262: EXCEPTION
1263: WHEN hz_dyn_validation.null_profile_value THEN
1264: -- this error indicates that the profile value has not been set.
1265: -- ignore this error
1266: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1267: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANKING_GROUP_MEMBER_VALIDATION_PROCEDURE',
1268: p_prefix=>'WARNING',
1269: p_msg_level=>fnd_log.level_exception);
1270: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 1269: p_msg_level=>fnd_log.level_exception);

1265: -- ignore this error
1266: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1267: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANKING_GROUP_MEMBER_VALIDATION_PROCEDURE',
1268: p_prefix=>'WARNING',
1269: p_msg_level=>fnd_log.level_exception);
1270: hz_utility_v2pub.debug(p_message=>'error ignored',
1271: p_prefix=>'WARNING',
1272: p_msg_level=>fnd_log.level_exception);
1273: END IF;

Line 1272: p_msg_level=>fnd_log.level_exception);

1268: p_prefix=>'WARNING',
1269: p_msg_level=>fnd_log.level_exception);
1270: hz_utility_v2pub.debug(p_message=>'error ignored',
1271: p_prefix=>'WARNING',
1272: p_msg_level=>fnd_log.level_exception);
1273: END IF;
1274: WHEN OTHERS THEN
1275: -- set the error status, don't need to set the error stack because
1276: -- the dynamic validation procedure already does so.

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

1277: x_return_status := fnd_api.g_ret_sts_error;
1278: END;
1279:
1280: -- Debug info.
1281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1282: hz_utility_v2pub.debug(p_message=>'validate_bank_group_member (+)',
1283: p_prefix=>l_debug_prefix,
1284: p_msg_level=>fnd_log.level_procedure);
1285: END IF;

Line 1284: p_msg_level=>fnd_log.level_procedure);

1280: -- Debug info.
1281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1282: hz_utility_v2pub.debug(p_message=>'validate_bank_group_member (+)',
1283: p_prefix=>l_debug_prefix,
1284: p_msg_level=>fnd_log.level_procedure);
1285: END IF;
1286: END validate_bank_group_member;
1287:
1288: /*=======================================================================+

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

1307: l_direction VARCHAR2(30);
1308: l_debug_prefix VARCHAR2(30) := '';
1309: BEGIN
1310: -- Debug info.
1311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1312: hz_utility_v2pub.debug(p_message=>'validate_clearinghouse_assign (+)',
1313: p_prefix=>l_debug_prefix,
1314: p_msg_level=>fnd_log.level_procedure);
1315: END IF;

Line 1314: p_msg_level=>fnd_log.level_procedure);

1310: -- Debug info.
1311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1312: hz_utility_v2pub.debug(p_message=>'validate_clearinghouse_assign (+)',
1313: p_prefix=>l_debug_prefix,
1314: p_msg_level=>fnd_log.level_procedure);
1315: END IF;
1316:
1317: -- Only one group membership relationship type is currently supported.
1318: IF (p_mode = g_insert OR p_relationship_rec.relationship_type IS NOT NULL)

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

1429: EXCEPTION
1430: WHEN hz_dyn_validation.null_profile_value THEN
1431: -- this error indicates that the profile value has not been set.
1432: -- ignore this error
1433: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1434: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_CLEARINGHOUSE_ASSIGNMENT_VALIDATION_PROCEDURE',
1435: p_prefix=>'WARNING',
1436: p_msg_level=>fnd_log.level_exception);
1437: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 1436: p_msg_level=>fnd_log.level_exception);

1432: -- ignore this error
1433: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1434: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_CLEARINGHOUSE_ASSIGNMENT_VALIDATION_PROCEDURE',
1435: p_prefix=>'WARNING',
1436: p_msg_level=>fnd_log.level_exception);
1437: hz_utility_v2pub.debug(p_message=>'error ignored',
1438: p_prefix=>'WARNING',
1439: p_msg_level=>fnd_log.level_exception);
1440: END IF;

Line 1439: p_msg_level=>fnd_log.level_exception);

1435: p_prefix=>'WARNING',
1436: p_msg_level=>fnd_log.level_exception);
1437: hz_utility_v2pub.debug(p_message=>'error ignored',
1438: p_prefix=>'WARNING',
1439: p_msg_level=>fnd_log.level_exception);
1440: END IF;
1441: WHEN OTHERS THEN
1442: -- set the error status, don't need to set the error stack because
1443: -- the dynamic validation procedure already does so.

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

1444: x_return_status := fnd_api.g_ret_sts_error;
1445: END;
1446:
1447: -- Debug info.
1448: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1449: hz_utility_v2pub.debug(p_message=>'validate_clearinghouse_assign (-)',
1450: p_prefix=>l_debug_prefix,
1451: p_msg_level=>fnd_log.level_procedure);
1452: END IF;

Line 1451: p_msg_level=>fnd_log.level_procedure);

1447: -- Debug info.
1448: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1449: hz_utility_v2pub.debug(p_message=>'validate_clearinghouse_assign (-)',
1450: p_prefix=>l_debug_prefix,
1451: p_msg_level=>fnd_log.level_procedure);
1452: END IF;
1453: END validate_clearinghouse_assign;
1454:
1455: /*=======================================================================+

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

1499: l_temp_location_id NUMBER;
1500: l_debug_prefix VARCHAR2(30) := '';
1501: BEGIN
1502: -- Debug info.
1503: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1504: hz_utility_v2pub.debug(p_message=>'validate_bank_site (+)',
1505: p_prefix=>l_debug_prefix,
1506: p_msg_level=>fnd_log.level_procedure);
1507: END IF;

Line 1506: p_msg_level=>fnd_log.level_procedure);

1502: -- Debug info.
1503: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1504: hz_utility_v2pub.debug(p_message=>'validate_bank_site (+)',
1505: p_prefix=>l_debug_prefix,
1506: p_msg_level=>fnd_log.level_procedure);
1507: END IF;
1508:
1509: --
1510: -- Validate the country. The location's country must be the same as the

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

1628: EXCEPTION
1629: WHEN hz_dyn_validation.null_profile_value THEN
1630: -- this error indicates that the profile value has not been set.
1631: -- ignore this error
1632: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1633: hz_utility_v2pub.debug(p_message=>'undefined profile: '|| l_validation_procedure,
1634: p_prefix=>'WARNING',
1635: p_msg_level=>fnd_log.level_exception);
1636: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 1635: p_msg_level=>fnd_log.level_exception);

1631: -- ignore this error
1632: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1633: hz_utility_v2pub.debug(p_message=>'undefined profile: '|| l_validation_procedure,
1634: p_prefix=>'WARNING',
1635: p_msg_level=>fnd_log.level_exception);
1636: hz_utility_v2pub.debug(p_message=>'error ignored',
1637: p_prefix=>'WARNING',
1638: p_msg_level=>fnd_log.level_exception);
1639: END IF;

Line 1638: p_msg_level=>fnd_log.level_exception);

1634: p_prefix=>'WARNING',
1635: p_msg_level=>fnd_log.level_exception);
1636: hz_utility_v2pub.debug(p_message=>'error ignored',
1637: p_prefix=>'WARNING',
1638: p_msg_level=>fnd_log.level_exception);
1639: END IF;
1640: WHEN OTHERS THEN
1641: -- set the error status, don't need to set the error stack because
1642: -- the dynamic validation procedure already does so.

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

1643: x_return_status := fnd_api.g_ret_sts_error;
1644: END;
1645:
1646: -- Debug info.
1647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug(p_message=>'validate_bank_site (-)',
1649: p_prefix=>l_debug_prefix,
1650: p_msg_level=>fnd_log.level_procedure);
1651: END IF;

Line 1650: p_msg_level=>fnd_log.level_procedure);

1646: -- Debug info.
1647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug(p_message=>'validate_bank_site (-)',
1649: p_prefix=>l_debug_prefix,
1650: p_msg_level=>fnd_log.level_procedure);
1651: END IF;
1652: END validate_bank_site;
1653:
1654: /*=======================================================================+

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

1681: l_orowid VARCHAR2(60);
1682: l_debug_prefix VARCHAR2(30);
1683: BEGIN
1684: -- Debug info.
1685: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1686: hz_utility_v2pub.debug(p_message=>'update_bank_organization (+)',
1687: p_prefix=>l_debug_prefix,
1688: p_msg_level=>fnd_log.level_procedure);
1689: END IF;

Line 1688: p_msg_level=>fnd_log.level_procedure);

1684: -- Debug info.
1685: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1686: hz_utility_v2pub.debug(p_message=>'update_bank_organization (+)',
1687: p_prefix=>l_debug_prefix,
1688: p_msg_level=>fnd_log.level_procedure);
1689: END IF;
1690: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1691: hz_utility_v2pub.debug(p_message=>'bank/branch number='||p_bank_or_branch_number,
1692: p_prefix =>l_debug_prefix,

Line 1690: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1686: hz_utility_v2pub.debug(p_message=>'update_bank_organization (+)',
1687: p_prefix=>l_debug_prefix,
1688: p_msg_level=>fnd_log.level_procedure);
1689: END IF;
1690: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1691: hz_utility_v2pub.debug(p_message=>'bank/branch number='||p_bank_or_branch_number,
1692: p_prefix =>l_debug_prefix,
1693: p_msg_level=>fnd_log.level_statement);
1694: hz_utility_v2pub.debug(p_message=>'bank code='||p_bank_code,

Line 1693: p_msg_level=>fnd_log.level_statement);

1689: END IF;
1690: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1691: hz_utility_v2pub.debug(p_message=>'bank/branch number='||p_bank_or_branch_number,
1692: p_prefix =>l_debug_prefix,
1693: p_msg_level=>fnd_log.level_statement);
1694: hz_utility_v2pub.debug(p_message=>'bank code='||p_bank_code,
1695: p_prefix =>l_debug_prefix,
1696: p_msg_level=>fnd_log.level_statement);
1697: hz_utility_v2pub.debug(p_message=>'branch code='||p_branch_code,

Line 1696: p_msg_level=>fnd_log.level_statement);

1692: p_prefix =>l_debug_prefix,
1693: p_msg_level=>fnd_log.level_statement);
1694: hz_utility_v2pub.debug(p_message=>'bank code='||p_bank_code,
1695: p_prefix =>l_debug_prefix,
1696: p_msg_level=>fnd_log.level_statement);
1697: hz_utility_v2pub.debug(p_message=>'branch code='||p_branch_code,
1698: p_prefix =>l_debug_prefix,
1699: p_msg_level=>fnd_log.level_statement);
1700: END IF;

Line 1699: p_msg_level=>fnd_log.level_statement);

1695: p_prefix =>l_debug_prefix,
1696: p_msg_level=>fnd_log.level_statement);
1697: hz_utility_v2pub.debug(p_message=>'branch code='||p_branch_code,
1698: p_prefix =>l_debug_prefix,
1699: p_msg_level=>fnd_log.level_statement);
1700: END IF;
1701:
1702: OPEN c_orgprof;
1703: FETCH c_orgprof INTO l_orowid;

Line 1711: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1707: END IF;
1708: CLOSE c_orgprof;
1709:
1710: -- Debug info.
1711: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1712: hz_utility_v2pub.debug(p_message=>'org rowid='||l_orowid,
1713: p_prefix =>l_debug_prefix,
1714: p_msg_level=>fnd_log.level_statement);
1715: END IF;

Line 1714: p_msg_level=>fnd_log.level_statement);

1710: -- Debug info.
1711: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1712: hz_utility_v2pub.debug(p_message=>'org rowid='||l_orowid,
1713: p_prefix =>l_debug_prefix,
1714: p_msg_level=>fnd_log.level_statement);
1715: END IF;
1716:
1717: hz_organization_profiles_pkg.update_row(
1718: x_rowid => l_orowid,

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

1864: x_home_country => NULL
1865: );
1866:
1867: -- Debug info.
1868: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1869: hz_utility_v2pub.debug(p_message=>'update_bank_organization (-)',
1870: p_prefix=>l_debug_prefix,
1871: p_msg_level=>fnd_log.level_procedure);
1872: END IF;

Line 1871: p_msg_level=>fnd_log.level_procedure);

1867: -- Debug info.
1868: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1869: hz_utility_v2pub.debug(p_message=>'update_bank_organization (-)',
1870: p_prefix=>l_debug_prefix,
1871: p_msg_level=>fnd_log.level_procedure);
1872: END IF;
1873: END update_bank_organization;
1874:
1875: /*=======================================================================+

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

2005: l_rel_party_version_number NUMBER;
2006: l_debug_prefix VARCHAR2(30) := '';
2007: BEGIN
2008: -- Debug info.
2009: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2010: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (+)',
2011: p_prefix=>l_debug_prefix,
2012: p_msg_level=>fnd_log.level_procedure);
2013: END IF;

Line 2012: p_msg_level=>fnd_log.level_procedure);

2008: -- Debug info.
2009: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2010: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (+)',
2011: p_prefix=>l_debug_prefix,
2012: p_msg_level=>fnd_log.level_procedure);
2013: END IF;
2014:
2015: -- If either the subject or object is null, then this record is being
2016: -- deactivated. Get the appropriate subject and/or object and set the

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

2028: fnd_msg_pub.add;
2029: x_return_status := fnd_api.g_ret_sts_error;
2030:
2031: -- Debug info.
2032: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2033: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (-)',
2034: p_prefix=>l_debug_prefix,
2035: p_msg_level=>fnd_log.level_procedure);
2036: END IF;

Line 2035: p_msg_level=>fnd_log.level_procedure);

2031: -- Debug info.
2032: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2033: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (-)',
2034: p_prefix=>l_debug_prefix,
2035: p_msg_level=>fnd_log.level_procedure);
2036: END IF;
2037:
2038: -- no point going any further, this is an invalid record
2039: RETURN;

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

2098:
2099: -- finish execution if the relationship creation routine is unsuccessful
2100: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2101: -- Debug info.
2102: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2103: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (-)',
2104: p_prefix=>l_debug_prefix,
2105: p_msg_level=>fnd_log.level_procedure);
2106: END IF;

Line 2105: p_msg_level=>fnd_log.level_procedure);

2101: -- Debug info.
2102: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2103: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (-)',
2104: p_prefix=>l_debug_prefix,
2105: p_msg_level=>fnd_log.level_procedure);
2106: END IF;
2107: RETURN;
2108: END IF;
2109:

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

2133: x_msg_data => x_msg_data
2134: );
2135:
2136: -- Debug info.
2137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2138: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (-)',
2139: p_prefix=>l_debug_prefix,
2140: p_msg_level=>fnd_log.level_procedure);
2141: END IF;

Line 2140: p_msg_level=>fnd_log.level_procedure);

2136: -- Debug info.
2137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2138: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (-)',
2139: p_prefix=>l_debug_prefix,
2140: p_msg_level=>fnd_log.level_procedure);
2141: END IF;
2142: END update_relationship;
2143:
2144: /*=======================================================================+

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

2171: l_code_assignment_id NUMBER(15);
2172: l_debug_prefix VARCHAR2(30) := '';
2173: BEGIN
2174: -- Debug info.
2175: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2176: hz_utility_v2pub.debug(p_message=>'create_code_assignment (+)',
2177: p_prefix=>l_debug_prefix,
2178: p_msg_level=>fnd_log.level_procedure);
2179: END IF;

Line 2178: p_msg_level=>fnd_log.level_procedure);

2174: -- Debug info.
2175: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2176: hz_utility_v2pub.debug(p_message=>'create_code_assignment (+)',
2177: p_prefix=>l_debug_prefix,
2178: p_msg_level=>fnd_log.level_procedure);
2179: END IF;
2180:
2181: -- set up the code assignment record.
2182: l_code_assignment_rec.code_assignment_id := NULL;

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

2203: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2204: RAISE fnd_api.g_exc_error;
2205: END IF;
2206: -- Debug info.
2207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug(p_message=>'create_code_assignment (-)',
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: -- Debug info.
2207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug(p_message=>'create_code_assignment (-)',
2209: p_prefix=>l_debug_prefix,
2210: p_msg_level=>fnd_log.level_procedure);
2211: END IF;
2212: END create_code_assignment;
2213:
2214: /*=======================================================================+

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

2280: p_bank_organization_type = hca.class_code);
2281:
2282: BEGIN
2283:
2284: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2285: hz_utility_v2pub.debug(p_message=>'update_code_assignment (+)',
2286: p_prefix=>l_debug_prefix,
2287: p_msg_level=>fnd_log.level_procedure);
2288: END IF;

Line 2287: p_msg_level=>fnd_log.level_procedure);

2283:
2284: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2285: hz_utility_v2pub.debug(p_message=>'update_code_assignment (+)',
2286: p_prefix=>l_debug_prefix,
2287: p_msg_level=>fnd_log.level_procedure);
2288: END IF;
2289:
2290: -- update existing assignment
2291: OPEN c_assignid2;

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

2380: END IF;
2381: END IF;
2382: CLOSE c_assignid2;
2383:
2384: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2385: hz_utility_v2pub.debug(p_message=>'update_code_assignment (-)',
2386: p_prefix=>l_debug_prefix,
2387: p_msg_level=>fnd_log.level_procedure);
2388: END IF;

Line 2387: p_msg_level=>fnd_log.level_procedure);

2383:
2384: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2385: hz_utility_v2pub.debug(p_message=>'update_code_assignment (-)',
2386: p_prefix=>l_debug_prefix,
2387: p_msg_level=>fnd_log.level_procedure);
2388: END IF;
2389: END update_code_assignment;
2390:
2391:

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

2569: -- Check if API is called in debug mode. If yes, enable debug.
2570: --enable_debug;
2571:
2572: -- Debug info.
2573: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2574: hz_utility_v2pub.debug(p_message=>'create_bank (+)',
2575: p_prefix=>l_debug_prefix,
2576: p_msg_level=>fnd_log.level_procedure);
2577: END IF;

Line 2576: p_msg_level=>fnd_log.level_procedure);

2572: -- Debug info.
2573: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2574: hz_utility_v2pub.debug(p_message=>'create_bank (+)',
2575: p_prefix=>l_debug_prefix,
2576: p_msg_level=>fnd_log.level_procedure);
2577: END IF;
2578:
2579: -- initialize message list if p_init_msg_list is set to TRUE.
2580: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

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

Line 2671: p_msg_level=>fnd_log.level_exception);

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

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

2669: p_msg_data=>x_msg_data,
2670: p_msg_type=>'WARNING',
2671: p_msg_level=>fnd_log.level_exception);
2672: END IF;
2673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2674: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2675: p_prefix=>l_debug_prefix,
2676: p_msg_level=>fnd_log.level_procedure);
2677: END IF;

Line 2676: p_msg_level=>fnd_log.level_procedure);

2672: END IF;
2673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2674: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2675: p_prefix=>l_debug_prefix,
2676: p_msg_level=>fnd_log.level_procedure);
2677: END IF;
2678:
2679: -- Check if API is called in debug mode. If yes, disable debug.
2680: --disable_debug;

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

2687: p_count => x_msg_count,
2688: p_data => x_msg_data);
2689:
2690: -- Debug info.
2691: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2692: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2693: p_msg_data=>x_msg_data,
2694: p_msg_type=>'ERROR',
2695: p_msg_level=>fnd_log.level_error);

Line 2695: p_msg_level=>fnd_log.level_error);

2691: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2692: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2693: p_msg_data=>x_msg_data,
2694: p_msg_type=>'ERROR',
2695: p_msg_level=>fnd_log.level_error);
2696: END IF;
2697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2698: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2699: p_prefix=>l_debug_prefix,

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

2693: p_msg_data=>x_msg_data,
2694: p_msg_type=>'ERROR',
2695: p_msg_level=>fnd_log.level_error);
2696: END IF;
2697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2698: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2699: p_prefix=>l_debug_prefix,
2700: p_msg_level=>fnd_log.level_procedure);
2701: END IF;

Line 2700: p_msg_level=>fnd_log.level_procedure);

2696: END IF;
2697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2698: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2699: p_prefix=>l_debug_prefix,
2700: p_msg_level=>fnd_log.level_procedure);
2701: END IF;
2702:
2703: -- Check if API is called in debug mode. If yes, disable debug.
2704: --disable_debug;

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

2710: p_count => x_msg_count,
2711: p_data => x_msg_data);
2712:
2713: -- Debug info.
2714: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2715: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2716: p_msg_data=>x_msg_data,
2717: p_msg_type=>'UNEXPECTED ERROR',
2718: p_msg_level=>fnd_log.level_error);

Line 2718: p_msg_level=>fnd_log.level_error);

2714: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2715: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2716: p_msg_data=>x_msg_data,
2717: p_msg_type=>'UNEXPECTED ERROR',
2718: p_msg_level=>fnd_log.level_error);
2719: END IF;
2720: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2721: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2722: p_prefix=>l_debug_prefix,

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

2716: p_msg_data=>x_msg_data,
2717: p_msg_type=>'UNEXPECTED ERROR',
2718: p_msg_level=>fnd_log.level_error);
2719: END IF;
2720: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2721: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2722: p_prefix=>l_debug_prefix,
2723: p_msg_level=>fnd_log.level_procedure);
2724: END IF;

Line 2723: p_msg_level=>fnd_log.level_procedure);

2719: END IF;
2720: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2721: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2722: p_prefix=>l_debug_prefix,
2723: p_msg_level=>fnd_log.level_procedure);
2724: END IF;
2725:
2726:
2727: -- Check if API is called in debug mode. If yes, disable debug.

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

2737: p_count => x_msg_count,
2738: p_data => x_msg_data);
2739:
2740: -- Debug info.
2741: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2742: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2743: p_msg_data=>x_msg_data,
2744: p_msg_type=>'SQL ERROR',
2745: p_msg_level=>fnd_log.level_error);

Line 2745: p_msg_level=>fnd_log.level_error);

2741: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2742: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2743: p_msg_data=>x_msg_data,
2744: p_msg_type=>'SQL ERROR',
2745: p_msg_level=>fnd_log.level_error);
2746: END IF;
2747: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2748: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2749: p_prefix=>l_debug_prefix,

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

2743: p_msg_data=>x_msg_data,
2744: p_msg_type=>'SQL ERROR',
2745: p_msg_level=>fnd_log.level_error);
2746: END IF;
2747: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2748: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2749: p_prefix=>l_debug_prefix,
2750: p_msg_level=>fnd_log.level_procedure);
2751: END IF;

Line 2750: p_msg_level=>fnd_log.level_procedure);

2746: END IF;
2747: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2748: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2749: p_prefix=>l_debug_prefix,
2750: p_msg_level=>fnd_log.level_procedure);
2751: END IF;
2752:
2753: -- Check if API is called in debug mode. If yes, disable debug.
2754: --disable_debug;

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

2819: -- Check if API is called in debug mode. If yes, enable debug.
2820: --enable_debug;
2821:
2822: -- Debug info.
2823: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2824: hz_utility_v2pub.debug(p_message=>'update_bank (+)',
2825: p_prefix=>l_debug_prefix,
2826: p_msg_level=>fnd_log.level_procedure);
2827: END IF;

Line 2826: p_msg_level=>fnd_log.level_procedure);

2822: -- Debug info.
2823: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2824: hz_utility_v2pub.debug(p_message=>'update_bank (+)',
2825: p_prefix=>l_debug_prefix,
2826: p_msg_level=>fnd_log.level_procedure);
2827: END IF;
2828:
2829: -- initialize message list if p_init_msg_list is set to TRUE.
2830: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

2909: p_count => x_msg_count,
2910: p_data => x_msg_data);
2911:
2912: -- Debug info.
2913: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2914: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2915: p_msg_data=>x_msg_data,
2916: p_msg_type=>'WARNING',
2917: p_msg_level=>fnd_log.level_exception);

Line 2917: p_msg_level=>fnd_log.level_exception);

2913: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2914: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2915: p_msg_data=>x_msg_data,
2916: p_msg_type=>'WARNING',
2917: p_msg_level=>fnd_log.level_exception);
2918: END IF;
2919: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2920: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2921: p_prefix=>l_debug_prefix,

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

2915: p_msg_data=>x_msg_data,
2916: p_msg_type=>'WARNING',
2917: p_msg_level=>fnd_log.level_exception);
2918: END IF;
2919: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2920: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2921: p_prefix=>l_debug_prefix,
2922: p_msg_level=>fnd_log.level_procedure);
2923: END IF;

Line 2922: p_msg_level=>fnd_log.level_procedure);

2918: END IF;
2919: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2920: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2921: p_prefix=>l_debug_prefix,
2922: p_msg_level=>fnd_log.level_procedure);
2923: END IF;
2924:
2925: -- Check if API is called in debug mode. If yes, disable debug.
2926: --disable_debug;

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

2933: p_count => x_msg_count,
2934: p_data => x_msg_data);
2935:
2936: -- Debug info.
2937: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2938: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2939: p_msg_data=>x_msg_data,
2940: p_msg_type=>'ERROR',
2941: p_msg_level=>fnd_log.level_error);

Line 2941: p_msg_level=>fnd_log.level_error);

2937: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2938: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2939: p_msg_data=>x_msg_data,
2940: p_msg_type=>'ERROR',
2941: p_msg_level=>fnd_log.level_error);
2942: END IF;
2943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2944: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2945: p_prefix=>l_debug_prefix,

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

2939: p_msg_data=>x_msg_data,
2940: p_msg_type=>'ERROR',
2941: p_msg_level=>fnd_log.level_error);
2942: END IF;
2943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2944: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2945: p_prefix=>l_debug_prefix,
2946: p_msg_level=>fnd_log.level_procedure);
2947: END IF;

Line 2946: p_msg_level=>fnd_log.level_procedure);

2942: END IF;
2943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2944: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2945: p_prefix=>l_debug_prefix,
2946: p_msg_level=>fnd_log.level_procedure);
2947: END IF;
2948:
2949: -- Check if API is called in debug mode. If yes, disable debug.
2950: --disable_debug;

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

2956: p_count => x_msg_count,
2957: p_data => x_msg_data);
2958:
2959: -- Debug info.
2960: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2961: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2962: p_msg_data=>x_msg_data,
2963: p_msg_type=>'UNEXPECTED ERROR',
2964: p_msg_level=>fnd_log.level_error);

Line 2964: p_msg_level=>fnd_log.level_error);

2960: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2961: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2962: p_msg_data=>x_msg_data,
2963: p_msg_type=>'UNEXPECTED ERROR',
2964: p_msg_level=>fnd_log.level_error);
2965: END IF;
2966: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2967: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2968: p_prefix=>l_debug_prefix,

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

2962: p_msg_data=>x_msg_data,
2963: p_msg_type=>'UNEXPECTED ERROR',
2964: p_msg_level=>fnd_log.level_error);
2965: END IF;
2966: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2967: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2968: p_prefix=>l_debug_prefix,
2969: p_msg_level=>fnd_log.level_procedure);
2970: END IF;

Line 2969: p_msg_level=>fnd_log.level_procedure);

2965: END IF;
2966: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2967: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2968: p_prefix=>l_debug_prefix,
2969: p_msg_level=>fnd_log.level_procedure);
2970: END IF;
2971:
2972: -- Check if API is called in debug mode. If yes, disable debug.
2973: --disable_debug;

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

2982: p_count => x_msg_count,
2983: p_data => x_msg_data);
2984:
2985: -- Debug info.
2986: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2987: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2988: p_msg_data=>x_msg_data,
2989: p_msg_type=>'SQL ERROR',
2990: p_msg_level=>fnd_log.level_error);

Line 2990: p_msg_level=>fnd_log.level_error);

2986: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2987: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2988: p_msg_data=>x_msg_data,
2989: p_msg_type=>'SQL ERROR',
2990: p_msg_level=>fnd_log.level_error);
2991: END IF;
2992: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2993: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2994: p_prefix=>l_debug_prefix,

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

2988: p_msg_data=>x_msg_data,
2989: p_msg_type=>'SQL ERROR',
2990: p_msg_level=>fnd_log.level_error);
2991: END IF;
2992: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2993: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2994: p_prefix=>l_debug_prefix,
2995: p_msg_level=>fnd_log.level_procedure);
2996: END IF;

Line 2995: p_msg_level=>fnd_log.level_procedure);

2991: END IF;
2992: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2993: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2994: p_prefix=>l_debug_prefix,
2995: p_msg_level=>fnd_log.level_procedure);
2996: END IF;
2997:
2998: -- Check if API is called in debug mode. If yes, disable debug.
2999: --disable_debug;

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

3069: -- Check if API is called in debug mode. If yes, enable debug.
3070: --enable_debug;
3071:
3072: -- Debug info.
3073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3074: hz_utility_v2pub.debug(p_message=>'create_bank_branch (+)',
3075: p_prefix=>l_debug_prefix,
3076: p_msg_level=>fnd_log.level_procedure);
3077: END IF;

Line 3076: p_msg_level=>fnd_log.level_procedure);

3072: -- Debug info.
3073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3074: hz_utility_v2pub.debug(p_message=>'create_bank_branch (+)',
3075: p_prefix=>l_debug_prefix,
3076: p_msg_level=>fnd_log.level_procedure);
3077: END IF;
3078:
3079: -- initialize message list if p_init_msg_list is set to TRUE.
3080: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

3230: p_count => x_msg_count,
3231: p_data => x_msg_data);
3232:
3233: -- Debug info.
3234: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3235: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3236: p_msg_data=>x_msg_data,
3237: p_msg_type=>'WARNING',
3238: p_msg_level=>fnd_log.level_exception);

Line 3238: p_msg_level=>fnd_log.level_exception);

3234: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3235: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3236: p_msg_data=>x_msg_data,
3237: p_msg_type=>'WARNING',
3238: p_msg_level=>fnd_log.level_exception);
3239: END IF;
3240: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3241: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3242: p_prefix=>l_debug_prefix,

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

3236: p_msg_data=>x_msg_data,
3237: p_msg_type=>'WARNING',
3238: p_msg_level=>fnd_log.level_exception);
3239: END IF;
3240: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3241: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3242: p_prefix=>l_debug_prefix,
3243: p_msg_level=>fnd_log.level_procedure);
3244: END IF;

Line 3243: p_msg_level=>fnd_log.level_procedure);

3239: END IF;
3240: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3241: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3242: p_prefix=>l_debug_prefix,
3243: p_msg_level=>fnd_log.level_procedure);
3244: END IF;
3245:
3246: -- Check if API is called in debug mode. If yes, disable debug.
3247: --disable_debug;

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

3254: p_count => x_msg_count,
3255: p_data => x_msg_data);
3256:
3257: -- Debug info.
3258: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3259: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3260: p_msg_data=>x_msg_data,
3261: p_msg_type=>'ERROR',
3262: p_msg_level=>fnd_log.level_error);

Line 3262: p_msg_level=>fnd_log.level_error);

3258: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3259: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3260: p_msg_data=>x_msg_data,
3261: p_msg_type=>'ERROR',
3262: p_msg_level=>fnd_log.level_error);
3263: END IF;
3264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3265: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3266: p_prefix=>l_debug_prefix,

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

3260: p_msg_data=>x_msg_data,
3261: p_msg_type=>'ERROR',
3262: p_msg_level=>fnd_log.level_error);
3263: END IF;
3264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3265: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3266: p_prefix=>l_debug_prefix,
3267: p_msg_level=>fnd_log.level_procedure);
3268: END IF;

Line 3267: p_msg_level=>fnd_log.level_procedure);

3263: END IF;
3264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3265: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3266: p_prefix=>l_debug_prefix,
3267: p_msg_level=>fnd_log.level_procedure);
3268: END IF;
3269:
3270: -- Check if API is called in debug mode. If yes, disable debug.
3271: --disable_debug;

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

3277: p_count => x_msg_count,
3278: p_data => x_msg_data);
3279:
3280: -- Debug info.
3281: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3282: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3283: p_msg_data=>x_msg_data,
3284: p_msg_type=>'UNEXPECTED ERROR',
3285: p_msg_level=>fnd_log.level_error);

Line 3285: p_msg_level=>fnd_log.level_error);

3281: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3282: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3283: p_msg_data=>x_msg_data,
3284: p_msg_type=>'UNEXPECTED ERROR',
3285: p_msg_level=>fnd_log.level_error);
3286: END IF;
3287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3288: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3289: p_prefix=>l_debug_prefix,

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

3283: p_msg_data=>x_msg_data,
3284: p_msg_type=>'UNEXPECTED ERROR',
3285: p_msg_level=>fnd_log.level_error);
3286: END IF;
3287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3288: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3289: p_prefix=>l_debug_prefix,
3290: p_msg_level=>fnd_log.level_procedure);
3291: END IF;

Line 3290: p_msg_level=>fnd_log.level_procedure);

3286: END IF;
3287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3288: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3289: p_prefix=>l_debug_prefix,
3290: p_msg_level=>fnd_log.level_procedure);
3291: END IF;
3292:
3293: -- Check if API is called in debug mode. If yes, disable debug.
3294: --disable_debug;

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

3303: p_count => x_msg_count,
3304: p_data => x_msg_data);
3305:
3306: -- Debug info.
3307: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3308: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3309: p_msg_data=>x_msg_data,
3310: p_msg_type=>'SQL ERROR',
3311: p_msg_level=>fnd_log.level_error);

Line 3311: p_msg_level=>fnd_log.level_error);

3307: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3308: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3309: p_msg_data=>x_msg_data,
3310: p_msg_type=>'SQL ERROR',
3311: p_msg_level=>fnd_log.level_error);
3312: END IF;
3313: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3314: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3315: p_prefix=>l_debug_prefix,

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

3309: p_msg_data=>x_msg_data,
3310: p_msg_type=>'SQL ERROR',
3311: p_msg_level=>fnd_log.level_error);
3312: END IF;
3313: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3314: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3315: p_prefix=>l_debug_prefix,
3316: p_msg_level=>fnd_log.level_procedure);
3317: END IF;

Line 3316: p_msg_level=>fnd_log.level_procedure);

3312: END IF;
3313: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3314: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3315: p_prefix=>l_debug_prefix,
3316: p_msg_level=>fnd_log.level_procedure);
3317: END IF;
3318:
3319: -- Check if API is called in debug mode. If yes, disable debug.
3320: --disable_debug;

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

3392: -- Check if API is called in debug mode. If yes, enable debug.
3393: --enable_debug;
3394:
3395: -- Debug info.
3396: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3397: hz_utility_v2pub.debug(p_message=>'update_bank_branch (+)',
3398: p_prefix=>l_debug_prefix,
3399: p_msg_level=>fnd_log.level_procedure);
3400: END IF;

Line 3399: p_msg_level=>fnd_log.level_procedure);

3395: -- Debug info.
3396: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3397: hz_utility_v2pub.debug(p_message=>'update_bank_branch (+)',
3398: p_prefix=>l_debug_prefix,
3399: p_msg_level=>fnd_log.level_procedure);
3400: END IF;
3401:
3402: -- initialize message list if p_init_msg_list is set to TRUE.
3403: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

3564: p_count => x_msg_count,
3565: p_data => x_msg_data);
3566:
3567: -- Debug info.
3568: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3569: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3570: p_msg_data=>x_msg_data,
3571: p_msg_type=>'WARNING',
3572: p_msg_level=>fnd_log.level_exception);

Line 3572: p_msg_level=>fnd_log.level_exception);

3568: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3569: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3570: p_msg_data=>x_msg_data,
3571: p_msg_type=>'WARNING',
3572: p_msg_level=>fnd_log.level_exception);
3573: END IF;
3574: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3575: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3576: p_prefix=>l_debug_prefix,

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

3570: p_msg_data=>x_msg_data,
3571: p_msg_type=>'WARNING',
3572: p_msg_level=>fnd_log.level_exception);
3573: END IF;
3574: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3575: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3576: p_prefix=>l_debug_prefix,
3577: p_msg_level=>fnd_log.level_procedure);
3578: END IF;

Line 3577: p_msg_level=>fnd_log.level_procedure);

3573: END IF;
3574: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3575: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3576: p_prefix=>l_debug_prefix,
3577: p_msg_level=>fnd_log.level_procedure);
3578: END IF;
3579:
3580: -- Check if API is called in debug mode. If yes, disable debug.
3581: --disable_debug;

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

3588: p_count => x_msg_count,
3589: p_data => x_msg_data);
3590:
3591: -- Debug info.
3592: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3593: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3594: p_msg_data=>x_msg_data,
3595: p_msg_type=>'ERROR',
3596: p_msg_level=>fnd_log.level_error);

Line 3596: p_msg_level=>fnd_log.level_error);

3592: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3593: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3594: p_msg_data=>x_msg_data,
3595: p_msg_type=>'ERROR',
3596: p_msg_level=>fnd_log.level_error);
3597: END IF;
3598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3599: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3600: p_prefix=>l_debug_prefix,

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

3594: p_msg_data=>x_msg_data,
3595: p_msg_type=>'ERROR',
3596: p_msg_level=>fnd_log.level_error);
3597: END IF;
3598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3599: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3600: p_prefix=>l_debug_prefix,
3601: p_msg_level=>fnd_log.level_procedure);
3602: END IF;

Line 3601: p_msg_level=>fnd_log.level_procedure);

3597: END IF;
3598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3599: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3600: p_prefix=>l_debug_prefix,
3601: p_msg_level=>fnd_log.level_procedure);
3602: END IF;
3603:
3604: -- Check if API is called in debug mode. If yes, disable debug.
3605: --disable_debug;

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

3611: p_count => x_msg_count,
3612: p_data => x_msg_data);
3613:
3614: -- Debug info.
3615: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3616: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3617: p_msg_data=>x_msg_data,
3618: p_msg_type=>'UNEXPECTED ERROR',
3619: p_msg_level=>fnd_log.level_error);

Line 3619: p_msg_level=>fnd_log.level_error);

3615: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3616: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3617: p_msg_data=>x_msg_data,
3618: p_msg_type=>'UNEXPECTED ERROR',
3619: p_msg_level=>fnd_log.level_error);
3620: END IF;
3621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3622: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3623: p_prefix=>l_debug_prefix,

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

3617: p_msg_data=>x_msg_data,
3618: p_msg_type=>'UNEXPECTED ERROR',
3619: p_msg_level=>fnd_log.level_error);
3620: END IF;
3621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3622: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3623: p_prefix=>l_debug_prefix,
3624: p_msg_level=>fnd_log.level_procedure);
3625: END IF;

Line 3624: p_msg_level=>fnd_log.level_procedure);

3620: END IF;
3621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3622: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3623: p_prefix=>l_debug_prefix,
3624: p_msg_level=>fnd_log.level_procedure);
3625: END IF;
3626:
3627: -- Check if API is called in debug mode. If yes, disable debug.
3628: --disable_debug;

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

3637: p_count => x_msg_count,
3638: p_data => x_msg_data);
3639:
3640: -- Debug info.
3641: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3642: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3643: p_msg_data=>x_msg_data,
3644: p_msg_type=>'SQL ERROR',
3645: p_msg_level=>fnd_log.level_error);

Line 3645: p_msg_level=>fnd_log.level_error);

3641: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3642: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3643: p_msg_data=>x_msg_data,
3644: p_msg_type=>'SQL ERROR',
3645: p_msg_level=>fnd_log.level_error);
3646: END IF;
3647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3648: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3649: p_prefix=>l_debug_prefix,

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

3643: p_msg_data=>x_msg_data,
3644: p_msg_type=>'SQL ERROR',
3645: p_msg_level=>fnd_log.level_error);
3646: END IF;
3647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3648: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3649: p_prefix=>l_debug_prefix,
3650: p_msg_level=>fnd_log.level_procedure);
3651: END IF;

Line 3650: p_msg_level=>fnd_log.level_procedure);

3646: END IF;
3647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3648: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3649: p_prefix=>l_debug_prefix,
3650: p_msg_level=>fnd_log.level_procedure);
3651: END IF;
3652:
3653: -- Check if API is called in debug mode. If yes, disable debug.
3654: --disable_debug;

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

3700: -- Check if API is called in debug mode. If yes, enable debug.
3701: --enable_debug;
3702:
3703: -- Debug info.
3704: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3705: hz_utility_v2pub.debug(p_message=>'create_banking_group (+)',
3706: p_prefix=>l_debug_prefix,
3707: p_msg_level=>fnd_log.level_procedure);
3708: END IF;

Line 3707: p_msg_level=>fnd_log.level_procedure);

3703: -- Debug info.
3704: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3705: hz_utility_v2pub.debug(p_message=>'create_banking_group (+)',
3706: p_prefix=>l_debug_prefix,
3707: p_msg_level=>fnd_log.level_procedure);
3708: END IF;
3709:
3710: -- initialize API return status to success.
3711: x_return_status := fnd_api.g_ret_sts_success;

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

3737: RAISE fnd_api.g_exc_error;
3738: END IF;
3739:
3740: -- Debug info.
3741: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3742: hz_utility_v2pub.debug(p_message=>'create_banking_group (-)',
3743: p_prefix=>l_debug_prefix,
3744: p_msg_level=>fnd_log.level_procedure);
3745: END IF;

Line 3744: p_msg_level=>fnd_log.level_procedure);

3740: -- Debug info.
3741: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3742: hz_utility_v2pub.debug(p_message=>'create_banking_group (-)',
3743: p_prefix=>l_debug_prefix,
3744: p_msg_level=>fnd_log.level_procedure);
3745: END IF;
3746:
3747: -- disable the debug procedure before exiting.
3748: --disable_debug;

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

3754: p_count => x_msg_count,
3755: p_data => x_msg_data);
3756:
3757: -- Debug info.
3758: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3759: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3760: p_msg_data=>x_msg_data,
3761: p_msg_type=>'ERROR',
3762: p_msg_level=>fnd_log.level_error);

Line 3762: p_msg_level=>fnd_log.level_error);

3758: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3759: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3760: p_msg_data=>x_msg_data,
3761: p_msg_type=>'ERROR',
3762: p_msg_level=>fnd_log.level_error);
3763: END IF;
3764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3765: hz_utility_v2pub.debug(p_message=>'create_banking_group (-)',
3766: p_prefix=>l_debug_prefix,

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

3760: p_msg_data=>x_msg_data,
3761: p_msg_type=>'ERROR',
3762: p_msg_level=>fnd_log.level_error);
3763: END IF;
3764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3765: hz_utility_v2pub.debug(p_message=>'create_banking_group (-)',
3766: p_prefix=>l_debug_prefix,
3767: p_msg_level=>fnd_log.level_procedure);
3768: END IF;

Line 3767: p_msg_level=>fnd_log.level_procedure);

3763: END IF;
3764: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3765: hz_utility_v2pub.debug(p_message=>'create_banking_group (-)',
3766: p_prefix=>l_debug_prefix,
3767: p_msg_level=>fnd_log.level_procedure);
3768: END IF;
3769:
3770: -- Check if API is called in debug mode. If yes, disable debug.
3771: --disable_debug;

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

3777: p_count => x_msg_count,
3778: p_data => x_msg_data);
3779:
3780: -- Debug info.
3781: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3782: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3783: p_msg_data=>x_msg_data,
3784: p_msg_type=>'UNEXPECTED ERROR',
3785: p_msg_level=>fnd_log.level_error);

Line 3785: p_msg_level=>fnd_log.level_error);

3781: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3782: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3783: p_msg_data=>x_msg_data,
3784: p_msg_type=>'UNEXPECTED ERROR',
3785: p_msg_level=>fnd_log.level_error);
3786: END IF;
3787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3788: hz_utility_v2pub.debug(p_message=>'create_banking_group (-)',
3789: p_prefix=>l_debug_prefix,

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

3783: p_msg_data=>x_msg_data,
3784: p_msg_type=>'UNEXPECTED ERROR',
3785: p_msg_level=>fnd_log.level_error);
3786: END IF;
3787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3788: hz_utility_v2pub.debug(p_message=>'create_banking_group (-)',
3789: p_prefix=>l_debug_prefix,
3790: p_msg_level=>fnd_log.level_procedure);
3791: END IF;

Line 3790: p_msg_level=>fnd_log.level_procedure);

3786: END IF;
3787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3788: hz_utility_v2pub.debug(p_message=>'create_banking_group (-)',
3789: p_prefix=>l_debug_prefix,
3790: p_msg_level=>fnd_log.level_procedure);
3791: END IF;
3792:
3793: -- Check if API is called in debug mode. If yes, disable debug.
3794: --disable_debug;

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

3803: p_count => x_msg_count,
3804: p_data => x_msg_data);
3805:
3806: -- Debug info.
3807: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3808: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3809: p_msg_data=>x_msg_data,
3810: p_msg_type=>'SQL ERROR',
3811: p_msg_level=>fnd_log.level_error);

Line 3811: p_msg_level=>fnd_log.level_error);

3807: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3808: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3809: p_msg_data=>x_msg_data,
3810: p_msg_type=>'SQL ERROR',
3811: p_msg_level=>fnd_log.level_error);
3812: END IF;
3813: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3814: hz_utility_v2pub.debug(p_message=>'create_banking_group (-)',
3815: p_prefix=>l_debug_prefix,

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

3809: p_msg_data=>x_msg_data,
3810: p_msg_type=>'SQL ERROR',
3811: p_msg_level=>fnd_log.level_error);
3812: END IF;
3813: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3814: hz_utility_v2pub.debug(p_message=>'create_banking_group (-)',
3815: p_prefix=>l_debug_prefix,
3816: p_msg_level=>fnd_log.level_procedure);
3817: END IF;

Line 3816: p_msg_level=>fnd_log.level_procedure);

3812: END IF;
3813: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3814: hz_utility_v2pub.debug(p_message=>'create_banking_group (-)',
3815: p_prefix=>l_debug_prefix,
3816: p_msg_level=>fnd_log.level_procedure);
3817: END IF;
3818:
3819: -- Check if API is called in debug mode. If yes, disable debug.
3820: --disable_debug;

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

3865: -- Check if API is called in debug mode. If yes, enable debug.
3866: --enable_debug;
3867:
3868: -- Debug info.
3869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3870: hz_utility_v2pub.debug(p_message=>'update_banking_group (+)',
3871: p_prefix=>l_debug_prefix,
3872: p_msg_level=>fnd_log.level_procedure);
3873: END IF;

Line 3872: p_msg_level=>fnd_log.level_procedure);

3868: -- Debug info.
3869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3870: hz_utility_v2pub.debug(p_message=>'update_banking_group (+)',
3871: p_prefix=>l_debug_prefix,
3872: p_msg_level=>fnd_log.level_procedure);
3873: END IF;
3874:
3875: -- initialize API return status to success.
3876: x_return_status := fnd_api.g_ret_sts_success;

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

3901: RAISE fnd_api.g_exc_error;
3902: END IF;
3903:
3904: -- Debug info.
3905: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3906: hz_utility_v2pub.debug(p_message=>'update_banking_group (-)',
3907: p_prefix=>l_debug_prefix,
3908: p_msg_level=>fnd_log.level_procedure);
3909: END IF;

Line 3908: p_msg_level=>fnd_log.level_procedure);

3904: -- Debug info.
3905: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3906: hz_utility_v2pub.debug(p_message=>'update_banking_group (-)',
3907: p_prefix=>l_debug_prefix,
3908: p_msg_level=>fnd_log.level_procedure);
3909: END IF;
3910:
3911: -- disable the debug procedure before exiting.
3912: --disable_debug;

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

3918: p_count => x_msg_count,
3919: p_data => x_msg_data);
3920:
3921: -- Debug info.
3922: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3923: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3924: p_msg_data=>x_msg_data,
3925: p_msg_type=>'ERROR',
3926: p_msg_level=>fnd_log.level_error);

Line 3926: p_msg_level=>fnd_log.level_error);

3922: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3923: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3924: p_msg_data=>x_msg_data,
3925: p_msg_type=>'ERROR',
3926: p_msg_level=>fnd_log.level_error);
3927: END IF;
3928: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3929: hz_utility_v2pub.debug(p_message=>'update_banking_group (-)',
3930: p_prefix=>l_debug_prefix,

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

3924: p_msg_data=>x_msg_data,
3925: p_msg_type=>'ERROR',
3926: p_msg_level=>fnd_log.level_error);
3927: END IF;
3928: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3929: hz_utility_v2pub.debug(p_message=>'update_banking_group (-)',
3930: p_prefix=>l_debug_prefix,
3931: p_msg_level=>fnd_log.level_procedure);
3932: END IF;

Line 3931: p_msg_level=>fnd_log.level_procedure);

3927: END IF;
3928: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3929: hz_utility_v2pub.debug(p_message=>'update_banking_group (-)',
3930: p_prefix=>l_debug_prefix,
3931: p_msg_level=>fnd_log.level_procedure);
3932: END IF;
3933:
3934: -- Check if API is called in debug mode. If yes, disable debug.
3935: --disable_debug;

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

3941: p_count => x_msg_count,
3942: p_data => x_msg_data);
3943:
3944: -- Debug info.
3945: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3946: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3947: p_msg_data=>x_msg_data,
3948: p_msg_type=>'UNEXPECTED ERROR',
3949: p_msg_level=>fnd_log.level_error);

Line 3949: p_msg_level=>fnd_log.level_error);

3945: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3946: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3947: p_msg_data=>x_msg_data,
3948: p_msg_type=>'UNEXPECTED ERROR',
3949: p_msg_level=>fnd_log.level_error);
3950: END IF;
3951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3952: hz_utility_v2pub.debug(p_message=>'update_banking_group (-)',
3953: p_prefix=>l_debug_prefix,

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

3947: p_msg_data=>x_msg_data,
3948: p_msg_type=>'UNEXPECTED ERROR',
3949: p_msg_level=>fnd_log.level_error);
3950: END IF;
3951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3952: hz_utility_v2pub.debug(p_message=>'update_banking_group (-)',
3953: p_prefix=>l_debug_prefix,
3954: p_msg_level=>fnd_log.level_procedure);
3955: END IF;

Line 3954: p_msg_level=>fnd_log.level_procedure);

3950: END IF;
3951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3952: hz_utility_v2pub.debug(p_message=>'update_banking_group (-)',
3953: p_prefix=>l_debug_prefix,
3954: p_msg_level=>fnd_log.level_procedure);
3955: END IF;
3956:
3957: -- Check if API is called in debug mode. If yes, disable debug.
3958: --disable_debug;

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

3967: p_count => x_msg_count,
3968: p_data => x_msg_data);
3969:
3970: -- Debug info.
3971: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3972: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3973: p_msg_data=>x_msg_data,
3974: p_msg_type=>'SQL ERROR',
3975: p_msg_level=>fnd_log.level_error);

Line 3975: p_msg_level=>fnd_log.level_error);

3971: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3972: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3973: p_msg_data=>x_msg_data,
3974: p_msg_type=>'SQL ERROR',
3975: p_msg_level=>fnd_log.level_error);
3976: END IF;
3977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3978: hz_utility_v2pub.debug(p_message=>'update_banking_group (-)',
3979: p_prefix=>l_debug_prefix,

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

3973: p_msg_data=>x_msg_data,
3974: p_msg_type=>'SQL ERROR',
3975: p_msg_level=>fnd_log.level_error);
3976: END IF;
3977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3978: hz_utility_v2pub.debug(p_message=>'update_banking_group (-)',
3979: p_prefix=>l_debug_prefix,
3980: p_msg_level=>fnd_log.level_procedure);
3981: END IF;

Line 3980: p_msg_level=>fnd_log.level_procedure);

3976: END IF;
3977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3978: hz_utility_v2pub.debug(p_message=>'update_banking_group (-)',
3979: p_prefix=>l_debug_prefix,
3980: p_msg_level=>fnd_log.level_procedure);
3981: END IF;
3982:
3983: -- Check if API is called in debug mode. If yes, disable debug.
3984: --disable_debug;

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

4036: -- Check if API is called in debug mode. If yes, enable debug.
4037: --enable_debug;
4038:
4039: -- Debug info.
4040: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4041: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (+)',
4042: p_prefix=>l_debug_prefix,
4043: p_msg_level=>fnd_log.level_procedure);
4044: END IF;

Line 4043: p_msg_level=>fnd_log.level_procedure);

4039: -- Debug info.
4040: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4041: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (+)',
4042: p_prefix=>l_debug_prefix,
4043: p_msg_level=>fnd_log.level_procedure);
4044: END IF;
4045:
4046: -- initialize API return status to success.
4047: x_return_status := fnd_api.g_ret_sts_success;

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

4074: RAISE fnd_api.g_exc_error;
4075: END IF;
4076:
4077: -- Debug info.
4078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4079: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (-)',
4080: p_prefix=>l_debug_prefix,
4081: p_msg_level=>fnd_log.level_procedure);
4082: END IF;

Line 4081: p_msg_level=>fnd_log.level_procedure);

4077: -- Debug info.
4078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4079: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (-)',
4080: p_prefix=>l_debug_prefix,
4081: p_msg_level=>fnd_log.level_procedure);
4082: END IF;
4083:
4084: -- disable the debug procedure before exiting.
4085: --disable_debug;

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

4091: p_count => x_msg_count,
4092: p_data => x_msg_data);
4093:
4094: -- Debug info.
4095: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4096: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4097: p_msg_data=>x_msg_data,
4098: p_msg_type=>'ERROR',
4099: p_msg_level=>fnd_log.level_error);

Line 4099: p_msg_level=>fnd_log.level_error);

4095: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4096: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4097: p_msg_data=>x_msg_data,
4098: p_msg_type=>'ERROR',
4099: p_msg_level=>fnd_log.level_error);
4100: END IF;
4101: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4102: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (-)',
4103: p_prefix=>l_debug_prefix,

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

4097: p_msg_data=>x_msg_data,
4098: p_msg_type=>'ERROR',
4099: p_msg_level=>fnd_log.level_error);
4100: END IF;
4101: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4102: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (-)',
4103: p_prefix=>l_debug_prefix,
4104: p_msg_level=>fnd_log.level_procedure);
4105: END IF;

Line 4104: p_msg_level=>fnd_log.level_procedure);

4100: END IF;
4101: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4102: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (-)',
4103: p_prefix=>l_debug_prefix,
4104: p_msg_level=>fnd_log.level_procedure);
4105: END IF;
4106:
4107: -- Check if API is called in debug mode. If yes, disable debug.
4108: --disable_debug;

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

4114: p_count => x_msg_count,
4115: p_data => x_msg_data);
4116:
4117: -- Debug info.
4118: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4119: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4120: p_msg_data=>x_msg_data,
4121: p_msg_type=>'UNEXPECTED ERROR',
4122: p_msg_level=>fnd_log.level_error);

Line 4122: p_msg_level=>fnd_log.level_error);

4118: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4119: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4120: p_msg_data=>x_msg_data,
4121: p_msg_type=>'UNEXPECTED ERROR',
4122: p_msg_level=>fnd_log.level_error);
4123: END IF;
4124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4125: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (-)',
4126: p_prefix=>l_debug_prefix,

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

4120: p_msg_data=>x_msg_data,
4121: p_msg_type=>'UNEXPECTED ERROR',
4122: p_msg_level=>fnd_log.level_error);
4123: END IF;
4124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4125: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (-)',
4126: p_prefix=>l_debug_prefix,
4127: p_msg_level=>fnd_log.level_procedure);
4128: END IF;

Line 4127: p_msg_level=>fnd_log.level_procedure);

4123: END IF;
4124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4125: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (-)',
4126: p_prefix=>l_debug_prefix,
4127: p_msg_level=>fnd_log.level_procedure);
4128: END IF;
4129:
4130: -- Check if API is called in debug mode. If yes, disable debug.
4131: --disable_debug;

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

4140: p_count => x_msg_count,
4141: p_data => x_msg_data);
4142:
4143: -- Debug info.
4144: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4145: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4146: p_msg_data=>x_msg_data,
4147: p_msg_type=>'SQL ERROR',
4148: p_msg_level=>fnd_log.level_error);

Line 4148: p_msg_level=>fnd_log.level_error);

4144: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4145: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4146: p_msg_data=>x_msg_data,
4147: p_msg_type=>'SQL ERROR',
4148: p_msg_level=>fnd_log.level_error);
4149: END IF;
4150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4151: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (-)',
4152: p_prefix=>l_debug_prefix,

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

4146: p_msg_data=>x_msg_data,
4147: p_msg_type=>'SQL ERROR',
4148: p_msg_level=>fnd_log.level_error);
4149: END IF;
4150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4151: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (-)',
4152: p_prefix=>l_debug_prefix,
4153: p_msg_level=>fnd_log.level_procedure);
4154: END IF;

Line 4153: p_msg_level=>fnd_log.level_procedure);

4149: END IF;
4150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4151: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (-)',
4152: p_prefix=>l_debug_prefix,
4153: p_msg_level=>fnd_log.level_procedure);
4154: END IF;
4155:
4156: -- Check if API is called in debug mode. If yes, disable debug.
4157: --disable_debug;

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

4207: -- Check if API is called in debug mode. If yes, enable debug.
4208: --enable_debug;
4209:
4210: -- Debug info.
4211: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4212: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (+)',
4213: p_prefix=>l_debug_prefix,
4214: p_msg_level=>fnd_log.level_procedure);
4215: END IF;

Line 4214: p_msg_level=>fnd_log.level_procedure);

4210: -- Debug info.
4211: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4212: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (+)',
4213: p_prefix=>l_debug_prefix,
4214: p_msg_level=>fnd_log.level_procedure);
4215: END IF;
4216:
4217: -- initialize API return status to success.
4218: x_return_status := fnd_api.g_ret_sts_success;

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

4244: RAISE fnd_api.g_exc_error;
4245: END IF;
4246:
4247: -- Debug info.
4248: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4249: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (-)',
4250: p_prefix=>l_debug_prefix,
4251: p_msg_level=>fnd_log.level_procedure);
4252: END IF;

Line 4251: p_msg_level=>fnd_log.level_procedure);

4247: -- Debug info.
4248: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4249: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (-)',
4250: p_prefix=>l_debug_prefix,
4251: p_msg_level=>fnd_log.level_procedure);
4252: END IF;
4253:
4254: -- disable the debug procedure before exiting.
4255: --disable_debug;

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

4261: p_count => x_msg_count,
4262: p_data => x_msg_data);
4263:
4264: -- Debug info.
4265: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4266: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4267: p_msg_data=>x_msg_data,
4268: p_msg_type=>'ERROR',
4269: p_msg_level=>fnd_log.level_error);

Line 4269: p_msg_level=>fnd_log.level_error);

4265: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4266: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4267: p_msg_data=>x_msg_data,
4268: p_msg_type=>'ERROR',
4269: p_msg_level=>fnd_log.level_error);
4270: END IF;
4271: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4272: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (-)',
4273: p_prefix=>l_debug_prefix,

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

4267: p_msg_data=>x_msg_data,
4268: p_msg_type=>'ERROR',
4269: p_msg_level=>fnd_log.level_error);
4270: END IF;
4271: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4272: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (-)',
4273: p_prefix=>l_debug_prefix,
4274: p_msg_level=>fnd_log.level_procedure);
4275: END IF;

Line 4274: p_msg_level=>fnd_log.level_procedure);

4270: END IF;
4271: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4272: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (-)',
4273: p_prefix=>l_debug_prefix,
4274: p_msg_level=>fnd_log.level_procedure);
4275: END IF;
4276:
4277: -- Check if API is called in debug mode. If yes, disable debug.
4278: --disable_debug;

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

4284: p_count => x_msg_count,
4285: p_data => x_msg_data);
4286:
4287: -- Debug info.
4288: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4289: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4290: p_msg_data=>x_msg_data,
4291: p_msg_type=>'UNEXPECTED ERROR',
4292: p_msg_level=>fnd_log.level_error);

Line 4292: p_msg_level=>fnd_log.level_error);

4288: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4289: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4290: p_msg_data=>x_msg_data,
4291: p_msg_type=>'UNEXPECTED ERROR',
4292: p_msg_level=>fnd_log.level_error);
4293: END IF;
4294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4295: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (-)',
4296: p_prefix=>l_debug_prefix,

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

4290: p_msg_data=>x_msg_data,
4291: p_msg_type=>'UNEXPECTED ERROR',
4292: p_msg_level=>fnd_log.level_error);
4293: END IF;
4294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4295: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (-)',
4296: p_prefix=>l_debug_prefix,
4297: p_msg_level=>fnd_log.level_procedure);
4298: END IF;

Line 4297: p_msg_level=>fnd_log.level_procedure);

4293: END IF;
4294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4295: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (-)',
4296: p_prefix=>l_debug_prefix,
4297: p_msg_level=>fnd_log.level_procedure);
4298: END IF;
4299:
4300: -- Check if API is called in debug mode. If yes, disable debug.
4301: --disable_debug;

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

4310: p_count => x_msg_count,
4311: p_data => x_msg_data);
4312:
4313: -- Debug info.
4314: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4315: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4316: p_msg_data=>x_msg_data,
4317: p_msg_type=>'SQL ERROR',
4318: p_msg_level=>fnd_log.level_error);

Line 4318: p_msg_level=>fnd_log.level_error);

4314: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4315: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4316: p_msg_data=>x_msg_data,
4317: p_msg_type=>'SQL ERROR',
4318: p_msg_level=>fnd_log.level_error);
4319: END IF;
4320: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4321: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (-)',
4322: p_prefix=>l_debug_prefix,

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

4316: p_msg_data=>x_msg_data,
4317: p_msg_type=>'SQL ERROR',
4318: p_msg_level=>fnd_log.level_error);
4319: END IF;
4320: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4321: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (-)',
4322: p_prefix=>l_debug_prefix,
4323: p_msg_level=>fnd_log.level_procedure);
4324: END IF;

Line 4323: p_msg_level=>fnd_log.level_procedure);

4319: END IF;
4320: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4321: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (-)',
4322: p_prefix=>l_debug_prefix,
4323: p_msg_level=>fnd_log.level_procedure);
4324: END IF;
4325:
4326: -- Check if API is called in debug mode. If yes, disable debug.
4327: --disable_debug;

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

4378: -- Check if API is called in debug mode. If yes, enable debug.
4379: --enable_debug;
4380:
4381: -- Debug info.
4382: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4383: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (+)',
4384: p_prefix=>l_debug_prefix,
4385: p_msg_level=>fnd_log.level_procedure);
4386: END IF;

Line 4385: p_msg_level=>fnd_log.level_procedure);

4381: -- Debug info.
4382: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4383: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (+)',
4384: p_prefix=>l_debug_prefix,
4385: p_msg_level=>fnd_log.level_procedure);
4386: END IF;
4387:
4388: -- initialize API return status to success.
4389: x_return_status := fnd_api.g_ret_sts_success;

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

4418: RAISE fnd_api.g_exc_error;
4419: END IF;
4420:
4421: -- Debug info.
4422: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4423: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (-)',
4424: p_prefix=>l_debug_prefix,
4425: p_msg_level=>fnd_log.level_procedure);
4426: END IF;

Line 4425: p_msg_level=>fnd_log.level_procedure);

4421: -- Debug info.
4422: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4423: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (-)',
4424: p_prefix=>l_debug_prefix,
4425: p_msg_level=>fnd_log.level_procedure);
4426: END IF;
4427:
4428: -- disable the debug procedure before exiting.
4429: --disable_debug;

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

4435: p_count => x_msg_count,
4436: p_data => x_msg_data);
4437:
4438: -- Debug info.
4439: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4440: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4441: p_msg_data=>x_msg_data,
4442: p_msg_type=>'ERROR',
4443: p_msg_level=>fnd_log.level_error);

Line 4443: p_msg_level=>fnd_log.level_error);

4439: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4440: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4441: p_msg_data=>x_msg_data,
4442: p_msg_type=>'ERROR',
4443: p_msg_level=>fnd_log.level_error);
4444: END IF;
4445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4446: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (-)',
4447: p_prefix=>l_debug_prefix,

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

4441: p_msg_data=>x_msg_data,
4442: p_msg_type=>'ERROR',
4443: p_msg_level=>fnd_log.level_error);
4444: END IF;
4445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4446: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (-)',
4447: p_prefix=>l_debug_prefix,
4448: p_msg_level=>fnd_log.level_procedure);
4449: END IF;

Line 4448: p_msg_level=>fnd_log.level_procedure);

4444: END IF;
4445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4446: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (-)',
4447: p_prefix=>l_debug_prefix,
4448: p_msg_level=>fnd_log.level_procedure);
4449: END IF;
4450:
4451: -- Check if API is called in debug mode. If yes, disable debug.
4452: --disable_debug;

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

4458: p_count => x_msg_count,
4459: p_data => x_msg_data);
4460:
4461: -- Debug info.
4462: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4463: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4464: p_msg_data=>x_msg_data,
4465: p_msg_type=>'UNEXPECTED ERROR',
4466: p_msg_level=>fnd_log.level_error);

Line 4466: p_msg_level=>fnd_log.level_error);

4462: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4463: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4464: p_msg_data=>x_msg_data,
4465: p_msg_type=>'UNEXPECTED ERROR',
4466: p_msg_level=>fnd_log.level_error);
4467: END IF;
4468: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4469: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (-)',
4470: p_prefix=>l_debug_prefix,

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

4464: p_msg_data=>x_msg_data,
4465: p_msg_type=>'UNEXPECTED ERROR',
4466: p_msg_level=>fnd_log.level_error);
4467: END IF;
4468: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4469: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (-)',
4470: p_prefix=>l_debug_prefix,
4471: p_msg_level=>fnd_log.level_procedure);
4472: END IF;

Line 4471: p_msg_level=>fnd_log.level_procedure);

4467: END IF;
4468: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4469: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (-)',
4470: p_prefix=>l_debug_prefix,
4471: p_msg_level=>fnd_log.level_procedure);
4472: END IF;
4473:
4474: -- Check if API is called in debug mode. If yes, disable debug.
4475: --disable_debug;

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

4484: p_count => x_msg_count,
4485: p_data => x_msg_data);
4486:
4487: -- Debug info.
4488: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4489: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4490: p_msg_data=>x_msg_data,
4491: p_msg_type=>'SQL ERROR',
4492: p_msg_level=>fnd_log.level_error);

Line 4492: p_msg_level=>fnd_log.level_error);

4488: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4489: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4490: p_msg_data=>x_msg_data,
4491: p_msg_type=>'SQL ERROR',
4492: p_msg_level=>fnd_log.level_error);
4493: END IF;
4494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4495: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (-)',
4496: p_prefix=>l_debug_prefix,

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

4490: p_msg_data=>x_msg_data,
4491: p_msg_type=>'SQL ERROR',
4492: p_msg_level=>fnd_log.level_error);
4493: END IF;
4494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4495: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (-)',
4496: p_prefix=>l_debug_prefix,
4497: p_msg_level=>fnd_log.level_procedure);
4498: END IF;

Line 4497: p_msg_level=>fnd_log.level_procedure);

4493: END IF;
4494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4495: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (-)',
4496: p_prefix=>l_debug_prefix,
4497: p_msg_level=>fnd_log.level_procedure);
4498: END IF;
4499:
4500: -- Check if API is called in debug mode. If yes, disable debug.
4501: --disable_debug;

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

4550: -- Check if API is called in debug mode. If yes, enable debug.
4551: --enable_debug;
4552:
4553: -- Debug info.
4554: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4555: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (+)',
4556: p_prefix=>l_debug_prefix,
4557: p_msg_level=>fnd_log.level_procedure);
4558: END IF;

Line 4557: p_msg_level=>fnd_log.level_procedure);

4553: -- Debug info.
4554: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4555: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (+)',
4556: p_prefix=>l_debug_prefix,
4557: p_msg_level=>fnd_log.level_procedure);
4558: END IF;
4559:
4560: -- initialize API return status to success.
4561: x_return_status := fnd_api.g_ret_sts_success;

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

4589: RAISE fnd_api.g_exc_error;
4590: END IF;
4591:
4592: -- Debug info.
4593: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4594: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (-)',
4595: p_prefix=>l_debug_prefix,
4596: p_msg_level=>fnd_log.level_procedure);
4597: END IF;

Line 4596: p_msg_level=>fnd_log.level_procedure);

4592: -- Debug info.
4593: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4594: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (-)',
4595: p_prefix=>l_debug_prefix,
4596: p_msg_level=>fnd_log.level_procedure);
4597: END IF;
4598:
4599: -- disable the debug procedure before exiting.
4600: --disable_debug;

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

4606: p_count => x_msg_count,
4607: p_data => x_msg_data);
4608:
4609: -- Debug info.
4610: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4611: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4612: p_msg_data=>x_msg_data,
4613: p_msg_type=>'ERROR',
4614: p_msg_level=>fnd_log.level_error);

Line 4614: p_msg_level=>fnd_log.level_error);

4610: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4611: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4612: p_msg_data=>x_msg_data,
4613: p_msg_type=>'ERROR',
4614: p_msg_level=>fnd_log.level_error);
4615: END IF;
4616: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4617: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (-)',
4618: p_prefix=>l_debug_prefix,

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

4612: p_msg_data=>x_msg_data,
4613: p_msg_type=>'ERROR',
4614: p_msg_level=>fnd_log.level_error);
4615: END IF;
4616: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4617: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (-)',
4618: p_prefix=>l_debug_prefix,
4619: p_msg_level=>fnd_log.level_procedure);
4620: END IF;

Line 4619: p_msg_level=>fnd_log.level_procedure);

4615: END IF;
4616: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4617: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (-)',
4618: p_prefix=>l_debug_prefix,
4619: p_msg_level=>fnd_log.level_procedure);
4620: END IF;
4621:
4622: -- Check if API is called in debug mode. If yes, disable debug.
4623: --disable_debug;

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

4629: p_count => x_msg_count,
4630: p_data => x_msg_data);
4631:
4632: -- Debug info.
4633: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4634: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4635: p_msg_data=>x_msg_data,
4636: p_msg_type=>'UNEXPECTED ERROR',
4637: p_msg_level=>fnd_log.level_error);

Line 4637: p_msg_level=>fnd_log.level_error);

4633: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4634: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4635: p_msg_data=>x_msg_data,
4636: p_msg_type=>'UNEXPECTED ERROR',
4637: p_msg_level=>fnd_log.level_error);
4638: END IF;
4639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4640: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (-)',
4641: p_prefix=>l_debug_prefix,

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

4635: p_msg_data=>x_msg_data,
4636: p_msg_type=>'UNEXPECTED ERROR',
4637: p_msg_level=>fnd_log.level_error);
4638: END IF;
4639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4640: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (-)',
4641: p_prefix=>l_debug_prefix,
4642: p_msg_level=>fnd_log.level_procedure);
4643: END IF;

Line 4642: p_msg_level=>fnd_log.level_procedure);

4638: END IF;
4639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4640: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (-)',
4641: p_prefix=>l_debug_prefix,
4642: p_msg_level=>fnd_log.level_procedure);
4643: END IF;
4644:
4645: -- Check if API is called in debug mode. If yes, disable debug.
4646: --disable_debug;

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

4655: p_count => x_msg_count,
4656: p_data => x_msg_data);
4657:
4658: -- Debug info.
4659: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4660: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4661: p_msg_data=>x_msg_data,
4662: p_msg_type=>'SQL ERROR',
4663: p_msg_level=>fnd_log.level_error);

Line 4663: p_msg_level=>fnd_log.level_error);

4659: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4660: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4661: p_msg_data=>x_msg_data,
4662: p_msg_type=>'SQL ERROR',
4663: p_msg_level=>fnd_log.level_error);
4664: END IF;
4665: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4666: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (-)',
4667: p_prefix=>l_debug_prefix,

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

4661: p_msg_data=>x_msg_data,
4662: p_msg_type=>'SQL ERROR',
4663: p_msg_level=>fnd_log.level_error);
4664: END IF;
4665: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4666: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (-)',
4667: p_prefix=>l_debug_prefix,
4668: p_msg_level=>fnd_log.level_procedure);
4669: END IF;

Line 4668: p_msg_level=>fnd_log.level_procedure);

4664: END IF;
4665: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4666: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (-)',
4667: p_prefix=>l_debug_prefix,
4668: p_msg_level=>fnd_log.level_procedure);
4669: END IF;
4670:
4671: -- Check if API is called in debug mode. If yes, disable debug.
4672: --disable_debug;

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

4719: -- Check if API is called in debug mode. If yes, enable debug.
4720: --enable_debug;
4721:
4722: -- Debug info.
4723: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4724: hz_utility_v2pub.debug(p_message=>'create_bank_site (+)',
4725: p_prefix=>l_debug_prefix,
4726: p_msg_level=>fnd_log.level_procedure);
4727: END IF;

Line 4726: p_msg_level=>fnd_log.level_procedure);

4722: -- Debug info.
4723: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4724: hz_utility_v2pub.debug(p_message=>'create_bank_site (+)',
4725: p_prefix=>l_debug_prefix,
4726: p_msg_level=>fnd_log.level_procedure);
4727: END IF;
4728:
4729: -- initialize API return status to success.
4730: x_return_status := fnd_api.g_ret_sts_success;

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

4756: RAISE fnd_api.g_exc_error;
4757: END IF;
4758:
4759: -- Debug info.
4760: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4761: hz_utility_v2pub.debug(p_message=>'create_bank_site (-)',
4762: p_prefix=>l_debug_prefix,
4763: p_msg_level=>fnd_log.level_procedure);
4764: END IF;

Line 4763: p_msg_level=>fnd_log.level_procedure);

4759: -- Debug info.
4760: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4761: hz_utility_v2pub.debug(p_message=>'create_bank_site (-)',
4762: p_prefix=>l_debug_prefix,
4763: p_msg_level=>fnd_log.level_procedure);
4764: END IF;
4765:
4766: -- disable the debug procedure before exiting.
4767: --disable_debug;

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

4773: p_count => x_msg_count,
4774: p_data => x_msg_data);
4775:
4776: -- Debug info.
4777: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4778: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4779: p_msg_data=>x_msg_data,
4780: p_msg_type=>'ERROR',
4781: p_msg_level=>fnd_log.level_error);

Line 4781: p_msg_level=>fnd_log.level_error);

4777: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4778: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4779: p_msg_data=>x_msg_data,
4780: p_msg_type=>'ERROR',
4781: p_msg_level=>fnd_log.level_error);
4782: END IF;
4783: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4784: hz_utility_v2pub.debug(p_message=>'create_bank_site (-)',
4785: p_prefix=>l_debug_prefix,

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

4779: p_msg_data=>x_msg_data,
4780: p_msg_type=>'ERROR',
4781: p_msg_level=>fnd_log.level_error);
4782: END IF;
4783: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4784: hz_utility_v2pub.debug(p_message=>'create_bank_site (-)',
4785: p_prefix=>l_debug_prefix,
4786: p_msg_level=>fnd_log.level_procedure);
4787: END IF;

Line 4786: p_msg_level=>fnd_log.level_procedure);

4782: END IF;
4783: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4784: hz_utility_v2pub.debug(p_message=>'create_bank_site (-)',
4785: p_prefix=>l_debug_prefix,
4786: p_msg_level=>fnd_log.level_procedure);
4787: END IF;
4788:
4789: -- Check if API is called in debug mode. If yes, disable debug.
4790: --disable_debug;

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

4796: p_count => x_msg_count,
4797: p_data => x_msg_data);
4798:
4799: -- Debug info.
4800: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4801: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4802: p_msg_data=>x_msg_data,
4803: p_msg_type=>'UNEXPECTED ERROR',
4804: p_msg_level=>fnd_log.level_error);

Line 4804: p_msg_level=>fnd_log.level_error);

4800: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4801: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4802: p_msg_data=>x_msg_data,
4803: p_msg_type=>'UNEXPECTED ERROR',
4804: p_msg_level=>fnd_log.level_error);
4805: END IF;
4806: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4807: hz_utility_v2pub.debug(p_message=>'create_bank_site (-)',
4808: p_prefix=>l_debug_prefix,

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

4802: p_msg_data=>x_msg_data,
4803: p_msg_type=>'UNEXPECTED ERROR',
4804: p_msg_level=>fnd_log.level_error);
4805: END IF;
4806: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4807: hz_utility_v2pub.debug(p_message=>'create_bank_site (-)',
4808: p_prefix=>l_debug_prefix,
4809: p_msg_level=>fnd_log.level_procedure);
4810: END IF;

Line 4809: p_msg_level=>fnd_log.level_procedure);

4805: END IF;
4806: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4807: hz_utility_v2pub.debug(p_message=>'create_bank_site (-)',
4808: p_prefix=>l_debug_prefix,
4809: p_msg_level=>fnd_log.level_procedure);
4810: END IF;
4811:
4812: -- Check if API is called in debug mode. If yes, disable debug.
4813: --disable_debug;

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

4822: p_count => x_msg_count,
4823: p_data => x_msg_data);
4824:
4825: -- Debug info.
4826: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4827: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4828: p_msg_data=>x_msg_data,
4829: p_msg_type=>'SQL ERROR',
4830: p_msg_level=>fnd_log.level_error);

Line 4830: p_msg_level=>fnd_log.level_error);

4826: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4827: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4828: p_msg_data=>x_msg_data,
4829: p_msg_type=>'SQL ERROR',
4830: p_msg_level=>fnd_log.level_error);
4831: END IF;
4832: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4833: hz_utility_v2pub.debug(p_message=>'create_bank_site (-)',
4834: p_prefix=>l_debug_prefix,

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

4828: p_msg_data=>x_msg_data,
4829: p_msg_type=>'SQL ERROR',
4830: p_msg_level=>fnd_log.level_error);
4831: END IF;
4832: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4833: hz_utility_v2pub.debug(p_message=>'create_bank_site (-)',
4834: p_prefix=>l_debug_prefix,
4835: p_msg_level=>fnd_log.level_procedure);
4836: END IF;

Line 4835: p_msg_level=>fnd_log.level_procedure);

4831: END IF;
4832: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4833: hz_utility_v2pub.debug(p_message=>'create_bank_site (-)',
4834: p_prefix=>l_debug_prefix,
4835: p_msg_level=>fnd_log.level_procedure);
4836: END IF;
4837:
4838: -- Check if API is called in debug mode. If yes, disable debug.
4839: --disable_debug;

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

4884: -- Check if API is called in debug mode. If yes, enable debug.
4885: --enable_debug;
4886:
4887: -- Debug info.
4888: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4889: hz_utility_v2pub.debug(p_message=>'update_bank_site (+)',
4890: p_prefix=>l_debug_prefix,
4891: p_msg_level=>fnd_log.level_procedure);
4892: END IF;

Line 4891: p_msg_level=>fnd_log.level_procedure);

4887: -- Debug info.
4888: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4889: hz_utility_v2pub.debug(p_message=>'update_bank_site (+)',
4890: p_prefix=>l_debug_prefix,
4891: p_msg_level=>fnd_log.level_procedure);
4892: END IF;
4893:
4894: -- initialize API return status to success.
4895: x_return_status := fnd_api.g_ret_sts_success;

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

4920: RAISE fnd_api.g_exc_error;
4921: END IF;
4922:
4923: -- Debug info.
4924: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4925: hz_utility_v2pub.debug(p_message=>'update_bank_site (-)',
4926: p_prefix=>l_debug_prefix,
4927: p_msg_level=>fnd_log.level_procedure);
4928: END IF;

Line 4927: p_msg_level=>fnd_log.level_procedure);

4923: -- Debug info.
4924: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4925: hz_utility_v2pub.debug(p_message=>'update_bank_site (-)',
4926: p_prefix=>l_debug_prefix,
4927: p_msg_level=>fnd_log.level_procedure);
4928: END IF;
4929:
4930: -- disable the debug procedure before exiting.
4931: --disable_debug;

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

4937: p_count => x_msg_count,
4938: p_data => x_msg_data);
4939:
4940: -- Debug info.
4941: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4942: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4943: p_msg_data=>x_msg_data,
4944: p_msg_type=>'ERROR',
4945: p_msg_level=>fnd_log.level_error);

Line 4945: p_msg_level=>fnd_log.level_error);

4941: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4942: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4943: p_msg_data=>x_msg_data,
4944: p_msg_type=>'ERROR',
4945: p_msg_level=>fnd_log.level_error);
4946: END IF;
4947: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4948: hz_utility_v2pub.debug(p_message=>'update_bank_site (-)',
4949: p_prefix=>l_debug_prefix,

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

4943: p_msg_data=>x_msg_data,
4944: p_msg_type=>'ERROR',
4945: p_msg_level=>fnd_log.level_error);
4946: END IF;
4947: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4948: hz_utility_v2pub.debug(p_message=>'update_bank_site (-)',
4949: p_prefix=>l_debug_prefix,
4950: p_msg_level=>fnd_log.level_procedure);
4951: END IF;

Line 4950: p_msg_level=>fnd_log.level_procedure);

4946: END IF;
4947: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4948: hz_utility_v2pub.debug(p_message=>'update_bank_site (-)',
4949: p_prefix=>l_debug_prefix,
4950: p_msg_level=>fnd_log.level_procedure);
4951: END IF;
4952:
4953: -- Check if API is called in debug mode. If yes, disable debug.
4954: --disable_debug;

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

4960: p_count => x_msg_count,
4961: p_data => x_msg_data);
4962:
4963: -- Debug info.
4964: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4965: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4966: p_msg_data=>x_msg_data,
4967: p_msg_type=>'UNEXPECTED ERROR',
4968: p_msg_level=>fnd_log.level_error);

Line 4968: p_msg_level=>fnd_log.level_error);

4964: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4965: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4966: p_msg_data=>x_msg_data,
4967: p_msg_type=>'UNEXPECTED ERROR',
4968: p_msg_level=>fnd_log.level_error);
4969: END IF;
4970: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4971: hz_utility_v2pub.debug(p_message=>'update_bank_site (-)',
4972: p_prefix=>l_debug_prefix,

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

4966: p_msg_data=>x_msg_data,
4967: p_msg_type=>'UNEXPECTED ERROR',
4968: p_msg_level=>fnd_log.level_error);
4969: END IF;
4970: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4971: hz_utility_v2pub.debug(p_message=>'update_bank_site (-)',
4972: p_prefix=>l_debug_prefix,
4973: p_msg_level=>fnd_log.level_procedure);
4974: END IF;

Line 4973: p_msg_level=>fnd_log.level_procedure);

4969: END IF;
4970: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4971: hz_utility_v2pub.debug(p_message=>'update_bank_site (-)',
4972: p_prefix=>l_debug_prefix,
4973: p_msg_level=>fnd_log.level_procedure);
4974: END IF;
4975:
4976: -- Check if API is called in debug mode. If yes, disable debug.
4977: --disable_debug;

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

4986: p_count => x_msg_count,
4987: p_data => x_msg_data);
4988:
4989: -- Debug info.
4990: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4991: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4992: p_msg_data=>x_msg_data,
4993: p_msg_type=>'SQL ERROR',
4994: p_msg_level=>fnd_log.level_error);

Line 4994: p_msg_level=>fnd_log.level_error);

4990: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4991: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4992: p_msg_data=>x_msg_data,
4993: p_msg_type=>'SQL ERROR',
4994: p_msg_level=>fnd_log.level_error);
4995: END IF;
4996: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4997: hz_utility_v2pub.debug(p_message=>'update_bank_site (-)',
4998: p_prefix=>l_debug_prefix,

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

4992: p_msg_data=>x_msg_data,
4993: p_msg_type=>'SQL ERROR',
4994: p_msg_level=>fnd_log.level_error);
4995: END IF;
4996: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4997: hz_utility_v2pub.debug(p_message=>'update_bank_site (-)',
4998: p_prefix=>l_debug_prefix,
4999: p_msg_level=>fnd_log.level_procedure);
5000: END IF;

Line 4999: p_msg_level=>fnd_log.level_procedure);

4995: END IF;
4996: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4997: hz_utility_v2pub.debug(p_message=>'update_bank_site (-)',
4998: p_prefix=>l_debug_prefix,
4999: p_msg_level=>fnd_log.level_procedure);
5000: END IF;
5001:
5002: -- Check if API is called in debug mode. If yes, disable debug.
5003: --disable_debug;

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

5052: -- Check if API is called in debug mode. If yes, enable debug.
5053: --enable_debug;
5054:
5055: -- Debug info.
5056: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5057: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (+)',
5058: p_prefix=>l_debug_prefix,
5059: p_msg_level=>fnd_log.level_procedure);
5060: END IF;

Line 5059: p_msg_level=>fnd_log.level_procedure);

5055: -- Debug info.
5056: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5057: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (+)',
5058: p_prefix=>l_debug_prefix,
5059: p_msg_level=>fnd_log.level_procedure);
5060: END IF;
5061:
5062: -- initialize API return status to success.
5063: x_return_status := fnd_api.g_ret_sts_success;

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

5092: RAISE fnd_api.g_exc_error;
5093: END IF;
5094:
5095: -- Debug info.
5096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5097: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
5098: p_prefix=>l_debug_prefix,
5099: p_msg_level=>fnd_log.level_procedure);
5100: END IF;

Line 5099: p_msg_level=>fnd_log.level_procedure);

5095: -- Debug info.
5096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5097: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
5098: p_prefix=>l_debug_prefix,
5099: p_msg_level=>fnd_log.level_procedure);
5100: END IF;
5101:
5102: -- disable the debug procedure before exiting.
5103: --disable_debug;

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

5109: p_count => x_msg_count,
5110: p_data => x_msg_data);
5111:
5112: -- Debug info.
5113: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5114: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5115: p_msg_data=>x_msg_data,
5116: p_msg_type=>'ERROR',
5117: p_msg_level=>fnd_log.level_error);

Line 5117: p_msg_level=>fnd_log.level_error);

5113: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5114: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5115: p_msg_data=>x_msg_data,
5116: p_msg_type=>'ERROR',
5117: p_msg_level=>fnd_log.level_error);
5118: END IF;
5119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5120: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
5121: p_prefix=>l_debug_prefix,

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

5115: p_msg_data=>x_msg_data,
5116: p_msg_type=>'ERROR',
5117: p_msg_level=>fnd_log.level_error);
5118: END IF;
5119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5120: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
5121: p_prefix=>l_debug_prefix,
5122: p_msg_level=>fnd_log.level_procedure);
5123: END IF;

Line 5122: p_msg_level=>fnd_log.level_procedure);

5118: END IF;
5119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5120: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
5121: p_prefix=>l_debug_prefix,
5122: p_msg_level=>fnd_log.level_procedure);
5123: END IF;
5124:
5125: -- Check if API is called in debug mode. If yes, disable debug.
5126: --disable_debug;

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

5132: p_count => x_msg_count,
5133: p_data => x_msg_data);
5134:
5135: -- Debug info.
5136: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5137: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5138: p_msg_data=>x_msg_data,
5139: p_msg_type=>'UNEXPECTED ERROR',
5140: p_msg_level=>fnd_log.level_error);

Line 5140: p_msg_level=>fnd_log.level_error);

5136: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5137: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5138: p_msg_data=>x_msg_data,
5139: p_msg_type=>'UNEXPECTED ERROR',
5140: p_msg_level=>fnd_log.level_error);
5141: END IF;
5142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5143: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
5144: p_prefix=>l_debug_prefix,

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

5138: p_msg_data=>x_msg_data,
5139: p_msg_type=>'UNEXPECTED ERROR',
5140: p_msg_level=>fnd_log.level_error);
5141: END IF;
5142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5143: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
5144: p_prefix=>l_debug_prefix,
5145: p_msg_level=>fnd_log.level_procedure);
5146: END IF;

Line 5145: p_msg_level=>fnd_log.level_procedure);

5141: END IF;
5142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5143: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
5144: p_prefix=>l_debug_prefix,
5145: p_msg_level=>fnd_log.level_procedure);
5146: END IF;
5147:
5148: -- Check if API is called in debug mode. If yes, disable debug.
5149: --disable_debug;

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

5158: p_count => x_msg_count,
5159: p_data => x_msg_data);
5160:
5161: -- Debug info.
5162: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5163: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5164: p_msg_data=>x_msg_data,
5165: p_msg_type=>'SQL ERROR',
5166: p_msg_level=>fnd_log.level_error);

Line 5166: p_msg_level=>fnd_log.level_error);

5162: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5163: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5164: p_msg_data=>x_msg_data,
5165: p_msg_type=>'SQL ERROR',
5166: p_msg_level=>fnd_log.level_error);
5167: END IF;
5168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5169: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
5170: p_prefix=>l_debug_prefix,

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

5164: p_msg_data=>x_msg_data,
5165: p_msg_type=>'SQL ERROR',
5166: p_msg_level=>fnd_log.level_error);
5167: END IF;
5168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5169: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
5170: p_prefix=>l_debug_prefix,
5171: p_msg_level=>fnd_log.level_procedure);
5172: END IF;

Line 5171: p_msg_level=>fnd_log.level_procedure);

5167: END IF;
5168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5169: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
5170: p_prefix=>l_debug_prefix,
5171: p_msg_level=>fnd_log.level_procedure);
5172: END IF;
5173:
5174: -- Check if API is called in debug mode. If yes, disable debug.
5175: --disable_debug;

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

5224: -- Check if API is called in debug mode. If yes, enable debug.
5225: --enable_debug;
5226:
5227: -- Debug info.
5228: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5229: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (+)',
5230: p_prefix=>l_debug_prefix,
5231: p_msg_level=>fnd_log.level_procedure);
5232: END IF;

Line 5231: p_msg_level=>fnd_log.level_procedure);

5227: -- Debug info.
5228: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5229: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (+)',
5230: p_prefix=>l_debug_prefix,
5231: p_msg_level=>fnd_log.level_procedure);
5232: END IF;
5233:
5234: -- initialize API return status to success.
5235: x_return_status := fnd_api.g_ret_sts_success;

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

5264: RAISE fnd_api.g_exc_error;
5265: END IF;
5266:
5267: -- Debug info.
5268: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5269: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
5270: p_prefix=>l_debug_prefix,
5271: p_msg_level=>fnd_log.level_procedure);
5272: END IF;

Line 5271: p_msg_level=>fnd_log.level_procedure);

5267: -- Debug info.
5268: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5269: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
5270: p_prefix=>l_debug_prefix,
5271: p_msg_level=>fnd_log.level_procedure);
5272: END IF;
5273:
5274: -- disable the debug procedure before exiting.
5275: --disable_debug;

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

5281: p_count => x_msg_count,
5282: p_data => x_msg_data);
5283:
5284: -- Debug info.
5285: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5286: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5287: p_msg_data=>x_msg_data,
5288: p_msg_type=>'ERROR',
5289: p_msg_level=>fnd_log.level_error);

Line 5289: p_msg_level=>fnd_log.level_error);

5285: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5286: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5287: p_msg_data=>x_msg_data,
5288: p_msg_type=>'ERROR',
5289: p_msg_level=>fnd_log.level_error);
5290: END IF;
5291: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5292: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
5293: p_prefix=>l_debug_prefix,

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

5287: p_msg_data=>x_msg_data,
5288: p_msg_type=>'ERROR',
5289: p_msg_level=>fnd_log.level_error);
5290: END IF;
5291: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5292: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
5293: p_prefix=>l_debug_prefix,
5294: p_msg_level=>fnd_log.level_procedure);
5295: END IF;

Line 5294: p_msg_level=>fnd_log.level_procedure);

5290: END IF;
5291: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5292: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
5293: p_prefix=>l_debug_prefix,
5294: p_msg_level=>fnd_log.level_procedure);
5295: END IF;
5296:
5297: -- Check if API is called in debug mode. If yes, disable debug.
5298: --disable_debug;

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

5304: p_count => x_msg_count,
5305: p_data => x_msg_data);
5306:
5307: -- Debug info.
5308: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5309: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5310: p_msg_data=>x_msg_data,
5311: p_msg_type=>'UNEXPECTED ERROR',
5312: p_msg_level=>fnd_log.level_error);

Line 5312: p_msg_level=>fnd_log.level_error);

5308: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5309: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5310: p_msg_data=>x_msg_data,
5311: p_msg_type=>'UNEXPECTED ERROR',
5312: p_msg_level=>fnd_log.level_error);
5313: END IF;
5314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5315: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
5316: p_prefix=>l_debug_prefix,

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

5310: p_msg_data=>x_msg_data,
5311: p_msg_type=>'UNEXPECTED ERROR',
5312: p_msg_level=>fnd_log.level_error);
5313: END IF;
5314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5315: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
5316: p_prefix=>l_debug_prefix,
5317: p_msg_level=>fnd_log.level_procedure);
5318: END IF;

Line 5317: p_msg_level=>fnd_log.level_procedure);

5313: END IF;
5314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5315: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
5316: p_prefix=>l_debug_prefix,
5317: p_msg_level=>fnd_log.level_procedure);
5318: END IF;
5319:
5320: -- Check if API is called in debug mode. If yes, disable debug.
5321: --disable_debug;

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

5330: p_count => x_msg_count,
5331: p_data => x_msg_data);
5332:
5333: -- Debug info.
5334: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5335: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5336: p_msg_data=>x_msg_data,
5337: p_msg_type=>'SQL ERROR',
5338: p_msg_level=>fnd_log.level_error);

Line 5338: p_msg_level=>fnd_log.level_error);

5334: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5335: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5336: p_msg_data=>x_msg_data,
5337: p_msg_type=>'SQL ERROR',
5338: p_msg_level=>fnd_log.level_error);
5339: END IF;
5340: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5341: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
5342: p_prefix=>l_debug_prefix,

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

5336: p_msg_data=>x_msg_data,
5337: p_msg_type=>'SQL ERROR',
5338: p_msg_level=>fnd_log.level_error);
5339: END IF;
5340: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5341: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
5342: p_prefix=>l_debug_prefix,
5343: p_msg_level=>fnd_log.level_procedure);
5344: END IF;

Line 5343: p_msg_level=>fnd_log.level_procedure);

5339: END IF;
5340: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5341: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
5342: p_prefix=>l_debug_prefix,
5343: p_msg_level=>fnd_log.level_procedure);
5344: END IF;
5345:
5346: -- Check if API is called in debug mode. If yes, disable debug.
5347: --disable_debug;

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

5396: -- Check if API is called in debug mode. If yes, enable debug.
5397: --enable_debug;
5398:
5399: -- Debug info.
5400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5401: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (+)',
5402: p_prefix=>l_debug_prefix,
5403: p_msg_level=>fnd_log.level_procedure);
5404: END IF;

Line 5403: p_msg_level=>fnd_log.level_procedure);

5399: -- Debug info.
5400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5401: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (+)',
5402: p_prefix=>l_debug_prefix,
5403: p_msg_level=>fnd_log.level_procedure);
5404: END IF;
5405:
5406: -- initialize API return status to success.
5407: x_return_status := fnd_api.g_ret_sts_success;

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

5436: RAISE fnd_api.g_exc_error;
5437: END IF;
5438:
5439: -- Debug info.
5440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5441: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
5442: p_prefix=>l_debug_prefix,
5443: p_msg_level=>fnd_log.level_procedure);
5444: END IF;

Line 5443: p_msg_level=>fnd_log.level_procedure);

5439: -- Debug info.
5440: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5441: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
5442: p_prefix=>l_debug_prefix,
5443: p_msg_level=>fnd_log.level_procedure);
5444: END IF;
5445:
5446: -- disable the debug procedure before exiting.
5447: --disable_debug;

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

5453: p_count => x_msg_count,
5454: p_data => x_msg_data);
5455:
5456: -- Debug info.
5457: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5458: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5459: p_msg_data=>x_msg_data,
5460: p_msg_type=>'ERROR',
5461: p_msg_level=>fnd_log.level_error);

Line 5461: p_msg_level=>fnd_log.level_error);

5457: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5458: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5459: p_msg_data=>x_msg_data,
5460: p_msg_type=>'ERROR',
5461: p_msg_level=>fnd_log.level_error);
5462: END IF;
5463: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5464: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
5465: p_prefix=>l_debug_prefix,

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

5459: p_msg_data=>x_msg_data,
5460: p_msg_type=>'ERROR',
5461: p_msg_level=>fnd_log.level_error);
5462: END IF;
5463: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5464: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
5465: p_prefix=>l_debug_prefix,
5466: p_msg_level=>fnd_log.level_procedure);
5467: END IF;

Line 5466: p_msg_level=>fnd_log.level_procedure);

5462: END IF;
5463: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5464: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
5465: p_prefix=>l_debug_prefix,
5466: p_msg_level=>fnd_log.level_procedure);
5467: END IF;
5468:
5469: -- Check if API is called in debug mode. If yes, disable debug.
5470: --disable_debug;

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

5476: p_count => x_msg_count,
5477: p_data => x_msg_data);
5478:
5479: -- Debug info.
5480: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5481: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5482: p_msg_data=>x_msg_data,
5483: p_msg_type=>'UNEXPECTED ERROR',
5484: p_msg_level=>fnd_log.level_error);

Line 5484: p_msg_level=>fnd_log.level_error);

5480: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5481: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5482: p_msg_data=>x_msg_data,
5483: p_msg_type=>'UNEXPECTED ERROR',
5484: p_msg_level=>fnd_log.level_error);
5485: END IF;
5486: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5487: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
5488: p_prefix=>l_debug_prefix,

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

5482: p_msg_data=>x_msg_data,
5483: p_msg_type=>'UNEXPECTED ERROR',
5484: p_msg_level=>fnd_log.level_error);
5485: END IF;
5486: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5487: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
5488: p_prefix=>l_debug_prefix,
5489: p_msg_level=>fnd_log.level_procedure);
5490: END IF;

Line 5489: p_msg_level=>fnd_log.level_procedure);

5485: END IF;
5486: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5487: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
5488: p_prefix=>l_debug_prefix,
5489: p_msg_level=>fnd_log.level_procedure);
5490: END IF;
5491:
5492: -- Check if API is called in debug mode. If yes, disable debug.
5493: --disable_debug;

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

5502: p_count => x_msg_count,
5503: p_data => x_msg_data);
5504:
5505: -- Debug info.
5506: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5507: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5508: p_msg_data=>x_msg_data,
5509: p_msg_type=>'SQL ERROR',
5510: p_msg_level=>fnd_log.level_error);

Line 5510: p_msg_level=>fnd_log.level_error);

5506: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5507: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5508: p_msg_data=>x_msg_data,
5509: p_msg_type=>'SQL ERROR',
5510: p_msg_level=>fnd_log.level_error);
5511: END IF;
5512: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5513: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
5514: p_prefix=>l_debug_prefix,

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

5508: p_msg_data=>x_msg_data,
5509: p_msg_type=>'SQL ERROR',
5510: p_msg_level=>fnd_log.level_error);
5511: END IF;
5512: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5513: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
5514: p_prefix=>l_debug_prefix,
5515: p_msg_level=>fnd_log.level_procedure);
5516: END IF;

Line 5515: p_msg_level=>fnd_log.level_procedure);

5511: END IF;
5512: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5513: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
5514: p_prefix=>l_debug_prefix,
5515: p_msg_level=>fnd_log.level_procedure);
5516: END IF;
5517:
5518: -- Check if API is called in debug mode. If yes, disable debug.
5519: --disable_debug;

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

5568: -- Check if API is called in debug mode. If yes, enable debug.
5569: --enable_debug;
5570:
5571: -- Debug info.
5572: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5573: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (+)',
5574: p_prefix=>l_debug_prefix,
5575: p_msg_level=>fnd_log.level_procedure);
5576: END IF;

Line 5575: p_msg_level=>fnd_log.level_procedure);

5571: -- Debug info.
5572: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5573: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (+)',
5574: p_prefix=>l_debug_prefix,
5575: p_msg_level=>fnd_log.level_procedure);
5576: END IF;
5577:
5578: -- initialize API return status to success.
5579: x_return_status := fnd_api.g_ret_sts_success;

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

5608: RAISE fnd_api.g_exc_error;
5609: END IF;
5610:
5611: -- Debug info.
5612: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5613: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5614: p_prefix=>l_debug_prefix,
5615: p_msg_level=>fnd_log.level_procedure);
5616: END IF;

Line 5615: p_msg_level=>fnd_log.level_procedure);

5611: -- Debug info.
5612: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5613: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5614: p_prefix=>l_debug_prefix,
5615: p_msg_level=>fnd_log.level_procedure);
5616: END IF;
5617:
5618: -- disable the debug procedure before exiting.
5619: --disable_debug;

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

5625: p_count => x_msg_count,
5626: p_data => x_msg_data);
5627:
5628: -- Debug info.
5629: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5630: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5631: p_msg_data=>x_msg_data,
5632: p_msg_type=>'ERROR',
5633: p_msg_level=>fnd_log.level_error);

Line 5633: p_msg_level=>fnd_log.level_error);

5629: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5630: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5631: p_msg_data=>x_msg_data,
5632: p_msg_type=>'ERROR',
5633: p_msg_level=>fnd_log.level_error);
5634: END IF;
5635: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5636: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5637: p_prefix=>l_debug_prefix,

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

5631: p_msg_data=>x_msg_data,
5632: p_msg_type=>'ERROR',
5633: p_msg_level=>fnd_log.level_error);
5634: END IF;
5635: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5636: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5637: p_prefix=>l_debug_prefix,
5638: p_msg_level=>fnd_log.level_procedure);
5639: END IF;

Line 5638: p_msg_level=>fnd_log.level_procedure);

5634: END IF;
5635: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5636: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5637: p_prefix=>l_debug_prefix,
5638: p_msg_level=>fnd_log.level_procedure);
5639: END IF;
5640:
5641: -- Check if API is called in debug mode. If yes, disable debug.
5642: --disable_debug;

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

5648: p_count => x_msg_count,
5649: p_data => x_msg_data);
5650:
5651: -- Debug info.
5652: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5653: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5654: p_msg_data=>x_msg_data,
5655: p_msg_type=>'UNEXPECTED ERROR',
5656: p_msg_level=>fnd_log.level_error);

Line 5656: p_msg_level=>fnd_log.level_error);

5652: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5653: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5654: p_msg_data=>x_msg_data,
5655: p_msg_type=>'UNEXPECTED ERROR',
5656: p_msg_level=>fnd_log.level_error);
5657: END IF;
5658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5659: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5660: p_prefix=>l_debug_prefix,

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

5654: p_msg_data=>x_msg_data,
5655: p_msg_type=>'UNEXPECTED ERROR',
5656: p_msg_level=>fnd_log.level_error);
5657: END IF;
5658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5659: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5660: p_prefix=>l_debug_prefix,
5661: p_msg_level=>fnd_log.level_procedure);
5662: END IF;

Line 5661: p_msg_level=>fnd_log.level_procedure);

5657: END IF;
5658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5659: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5660: p_prefix=>l_debug_prefix,
5661: p_msg_level=>fnd_log.level_procedure);
5662: END IF;
5663:
5664: -- Check if API is called in debug mode. If yes, disable debug.
5665: --disable_debug;

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

5674: p_count => x_msg_count,
5675: p_data => x_msg_data);
5676:
5677: -- Debug info.
5678: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5679: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5680: p_msg_data=>x_msg_data,
5681: p_msg_type=>'SQL ERROR',
5682: p_msg_level=>fnd_log.level_error);

Line 5682: p_msg_level=>fnd_log.level_error);

5678: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5679: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5680: p_msg_data=>x_msg_data,
5681: p_msg_type=>'SQL ERROR',
5682: p_msg_level=>fnd_log.level_error);
5683: END IF;
5684: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5685: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5686: p_prefix=>l_debug_prefix,

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

5680: p_msg_data=>x_msg_data,
5681: p_msg_type=>'SQL ERROR',
5682: p_msg_level=>fnd_log.level_error);
5683: END IF;
5684: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5685: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5686: p_prefix=>l_debug_prefix,
5687: p_msg_level=>fnd_log.level_procedure);
5688: END IF;

Line 5687: p_msg_level=>fnd_log.level_procedure);

5683: END IF;
5684: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5685: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5686: p_prefix=>l_debug_prefix,
5687: p_msg_level=>fnd_log.level_procedure);
5688: END IF;
5689:
5690: -- Check if API is called in debug mode. If yes, disable debug.
5691: --disable_debug;

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

5740: -- Check if API is called in debug mode. If yes, enable debug.
5741: --enable_debug;
5742:
5743: -- Debug info.
5744: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5745: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (+)',
5746: p_prefix=>l_debug_prefix,
5747: p_msg_level=>fnd_log.level_procedure);
5748: END IF;

Line 5747: p_msg_level=>fnd_log.level_procedure);

5743: -- Debug info.
5744: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5745: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (+)',
5746: p_prefix=>l_debug_prefix,
5747: p_msg_level=>fnd_log.level_procedure);
5748: END IF;
5749:
5750: -- initialize API return status to success.
5751: x_return_status := fnd_api.g_ret_sts_success;

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

5780: RAISE fnd_api.g_exc_error;
5781: END IF;
5782:
5783: -- Debug info.
5784: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5785: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
5786: p_prefix=>l_debug_prefix,
5787: p_msg_level=>fnd_log.level_procedure);
5788: END IF;

Line 5787: p_msg_level=>fnd_log.level_procedure);

5783: -- Debug info.
5784: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5785: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
5786: p_prefix=>l_debug_prefix,
5787: p_msg_level=>fnd_log.level_procedure);
5788: END IF;
5789:
5790: -- disable the debug procedure before exiting.
5791: --disable_debug;

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

5797: p_count => x_msg_count,
5798: p_data => x_msg_data);
5799:
5800: -- Debug info.
5801: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5802: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5803: p_msg_data=>x_msg_data,
5804: p_msg_type=>'ERROR',
5805: p_msg_level=>fnd_log.level_error);

Line 5805: p_msg_level=>fnd_log.level_error);

5801: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5802: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5803: p_msg_data=>x_msg_data,
5804: p_msg_type=>'ERROR',
5805: p_msg_level=>fnd_log.level_error);
5806: END IF;
5807: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5808: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
5809: p_prefix=>l_debug_prefix,

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

5803: p_msg_data=>x_msg_data,
5804: p_msg_type=>'ERROR',
5805: p_msg_level=>fnd_log.level_error);
5806: END IF;
5807: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5808: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
5809: p_prefix=>l_debug_prefix,
5810: p_msg_level=>fnd_log.level_procedure);
5811: END IF;

Line 5810: p_msg_level=>fnd_log.level_procedure);

5806: END IF;
5807: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5808: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
5809: p_prefix=>l_debug_prefix,
5810: p_msg_level=>fnd_log.level_procedure);
5811: END IF;
5812:
5813: -- Check if API is called in debug mode. If yes, disable debug.
5814: --disable_debug;

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

5820: p_count => x_msg_count,
5821: p_data => x_msg_data);
5822:
5823: -- Debug info.
5824: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5825: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5826: p_msg_data=>x_msg_data,
5827: p_msg_type=>'UNEXPECTED ERROR',
5828: p_msg_level=>fnd_log.level_error);

Line 5828: p_msg_level=>fnd_log.level_error);

5824: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5825: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5826: p_msg_data=>x_msg_data,
5827: p_msg_type=>'UNEXPECTED ERROR',
5828: p_msg_level=>fnd_log.level_error);
5829: END IF;
5830: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5831: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
5832: p_prefix=>l_debug_prefix,

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

5826: p_msg_data=>x_msg_data,
5827: p_msg_type=>'UNEXPECTED ERROR',
5828: p_msg_level=>fnd_log.level_error);
5829: END IF;
5830: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5831: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
5832: p_prefix=>l_debug_prefix,
5833: p_msg_level=>fnd_log.level_procedure);
5834: END IF;

Line 5833: p_msg_level=>fnd_log.level_procedure);

5829: END IF;
5830: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5831: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
5832: p_prefix=>l_debug_prefix,
5833: p_msg_level=>fnd_log.level_procedure);
5834: END IF;
5835:
5836: -- Check if API is called in debug mode. If yes, disable debug.
5837: --disable_debug;

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

5846: p_count => x_msg_count,
5847: p_data => x_msg_data);
5848:
5849: -- Debug info.
5850: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5851: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5852: p_msg_data=>x_msg_data,
5853: p_msg_type=>'SQL ERROR',
5854: p_msg_level=>fnd_log.level_error);

Line 5854: p_msg_level=>fnd_log.level_error);

5850: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5851: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5852: p_msg_data=>x_msg_data,
5853: p_msg_type=>'SQL ERROR',
5854: p_msg_level=>fnd_log.level_error);
5855: END IF;
5856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5857: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
5858: p_prefix=>l_debug_prefix,

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

5852: p_msg_data=>x_msg_data,
5853: p_msg_type=>'SQL ERROR',
5854: p_msg_level=>fnd_log.level_error);
5855: END IF;
5856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5857: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
5858: p_prefix=>l_debug_prefix,
5859: p_msg_level=>fnd_log.level_procedure);
5860: END IF;

Line 5859: p_msg_level=>fnd_log.level_procedure);

5855: END IF;
5856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5857: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
5858: p_prefix=>l_debug_prefix,
5859: p_msg_level=>fnd_log.level_procedure);
5860: END IF;
5861:
5862: -- Check if API is called in debug mode. If yes, disable debug.
5863: --disable_debug;

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

5912: -- Check if API is called in debug mode. If yes, enable debug.
5913: --enable_debug;
5914:
5915: -- Debug info.
5916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5917: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (+)',
5918: p_prefix=>l_debug_prefix,
5919: p_msg_level=>fnd_log.level_procedure);
5920: END IF;

Line 5919: p_msg_level=>fnd_log.level_procedure);

5915: -- Debug info.
5916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5917: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (+)',
5918: p_prefix=>l_debug_prefix,
5919: p_msg_level=>fnd_log.level_procedure);
5920: END IF;
5921:
5922: -- initialize API return status to success.
5923: x_return_status := fnd_api.g_ret_sts_success;

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

5952: RAISE fnd_api.g_exc_error;
5953: END IF;
5954:
5955: -- Debug info.
5956: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5957: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
5958: p_prefix=>l_debug_prefix,
5959: p_msg_level=>fnd_log.level_procedure);
5960: END IF;

Line 5959: p_msg_level=>fnd_log.level_procedure);

5955: -- Debug info.
5956: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5957: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
5958: p_prefix=>l_debug_prefix,
5959: p_msg_level=>fnd_log.level_procedure);
5960: END IF;
5961:
5962: -- disable the debug procedure before exiting.
5963: --disable_debug;

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

5969: p_count => x_msg_count,
5970: p_data => x_msg_data);
5971:
5972: -- Debug info.
5973: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5974: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5975: p_msg_data=>x_msg_data,
5976: p_msg_type=>'ERROR',
5977: p_msg_level=>fnd_log.level_error);

Line 5977: p_msg_level=>fnd_log.level_error);

5973: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5974: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5975: p_msg_data=>x_msg_data,
5976: p_msg_type=>'ERROR',
5977: p_msg_level=>fnd_log.level_error);
5978: END IF;
5979: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5980: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
5981: p_prefix=>l_debug_prefix,

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

5975: p_msg_data=>x_msg_data,
5976: p_msg_type=>'ERROR',
5977: p_msg_level=>fnd_log.level_error);
5978: END IF;
5979: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5980: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
5981: p_prefix=>l_debug_prefix,
5982: p_msg_level=>fnd_log.level_procedure);
5983: END IF;

Line 5982: p_msg_level=>fnd_log.level_procedure);

5978: END IF;
5979: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5980: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
5981: p_prefix=>l_debug_prefix,
5982: p_msg_level=>fnd_log.level_procedure);
5983: END IF;
5984:
5985: -- Check if API is called in debug mode. If yes, disable debug.
5986: --disable_debug;

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

5992: p_count => x_msg_count,
5993: p_data => x_msg_data);
5994:
5995: -- Debug info.
5996: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5997: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5998: p_msg_data=>x_msg_data,
5999: p_msg_type=>'UNEXPECTED ERROR',
6000: p_msg_level=>fnd_log.level_error);

Line 6000: p_msg_level=>fnd_log.level_error);

5996: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5997: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5998: p_msg_data=>x_msg_data,
5999: p_msg_type=>'UNEXPECTED ERROR',
6000: p_msg_level=>fnd_log.level_error);
6001: END IF;
6002: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6003: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
6004: p_prefix=>l_debug_prefix,

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

5998: p_msg_data=>x_msg_data,
5999: p_msg_type=>'UNEXPECTED ERROR',
6000: p_msg_level=>fnd_log.level_error);
6001: END IF;
6002: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6003: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
6004: p_prefix=>l_debug_prefix,
6005: p_msg_level=>fnd_log.level_procedure);
6006: END IF;

Line 6005: p_msg_level=>fnd_log.level_procedure);

6001: END IF;
6002: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6003: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
6004: p_prefix=>l_debug_prefix,
6005: p_msg_level=>fnd_log.level_procedure);
6006: END IF;
6007:
6008: -- Check if API is called in debug mode. If yes, disable debug.
6009: --disable_debug;

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

6018: p_count => x_msg_count,
6019: p_data => x_msg_data);
6020:
6021: -- Debug info.
6022: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6023: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6024: p_msg_data=>x_msg_data,
6025: p_msg_type=>'SQL ERROR',
6026: p_msg_level=>fnd_log.level_error);

Line 6026: p_msg_level=>fnd_log.level_error);

6022: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6023: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6024: p_msg_data=>x_msg_data,
6025: p_msg_type=>'SQL ERROR',
6026: p_msg_level=>fnd_log.level_error);
6027: END IF;
6028: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6029: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
6030: p_prefix=>l_debug_prefix,

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

6024: p_msg_data=>x_msg_data,
6025: p_msg_type=>'SQL ERROR',
6026: p_msg_level=>fnd_log.level_error);
6027: END IF;
6028: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6029: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
6030: p_prefix=>l_debug_prefix,
6031: p_msg_level=>fnd_log.level_procedure);
6032: END IF;

Line 6031: p_msg_level=>fnd_log.level_procedure);

6027: END IF;
6028: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6029: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
6030: p_prefix=>l_debug_prefix,
6031: p_msg_level=>fnd_log.level_procedure);
6032: END IF;
6033:
6034: -- Check if API is called in debug mode. If yes, disable debug.
6035: --disable_debug;

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

6084: -- Check if API is called in debug mode. If yes, enable debug.
6085: --enable_debug;
6086:
6087: -- Debug info.
6088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6089: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (+)',
6090: p_prefix=>l_debug_prefix,
6091: p_msg_level=>fnd_log.level_procedure);
6092: END IF;

Line 6091: p_msg_level=>fnd_log.level_procedure);

6087: -- Debug info.
6088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6089: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (+)',
6090: p_prefix=>l_debug_prefix,
6091: p_msg_level=>fnd_log.level_procedure);
6092: END IF;
6093:
6094: -- initialize API return status to success.
6095: x_return_status := fnd_api.g_ret_sts_success;

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

6124: RAISE fnd_api.g_exc_error;
6125: END IF;
6126:
6127: -- Debug info.
6128: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6129: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
6130: p_prefix=>l_debug_prefix,
6131: p_msg_level=>fnd_log.level_procedure);
6132: END IF;

Line 6131: p_msg_level=>fnd_log.level_procedure);

6127: -- Debug info.
6128: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6129: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
6130: p_prefix=>l_debug_prefix,
6131: p_msg_level=>fnd_log.level_procedure);
6132: END IF;
6133:
6134: -- disable the debug procedure before exiting.
6135: --disable_debug;

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

6141: p_count => x_msg_count,
6142: p_data => x_msg_data);
6143:
6144: -- Debug info.
6145: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6146: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6147: p_msg_data=>x_msg_data,
6148: p_msg_type=>'ERROR',
6149: p_msg_level=>fnd_log.level_error);

Line 6149: p_msg_level=>fnd_log.level_error);

6145: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6146: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6147: p_msg_data=>x_msg_data,
6148: p_msg_type=>'ERROR',
6149: p_msg_level=>fnd_log.level_error);
6150: END IF;
6151: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6152: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
6153: p_prefix=>l_debug_prefix,

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

6147: p_msg_data=>x_msg_data,
6148: p_msg_type=>'ERROR',
6149: p_msg_level=>fnd_log.level_error);
6150: END IF;
6151: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6152: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
6153: p_prefix=>l_debug_prefix,
6154: p_msg_level=>fnd_log.level_procedure);
6155: END IF;

Line 6154: p_msg_level=>fnd_log.level_procedure);

6150: END IF;
6151: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6152: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
6153: p_prefix=>l_debug_prefix,
6154: p_msg_level=>fnd_log.level_procedure);
6155: END IF;
6156:
6157: -- Check if API is called in debug mode. If yes, disable debug.
6158: --disable_debug;

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

6164: p_count => x_msg_count,
6165: p_data => x_msg_data);
6166:
6167: -- Debug info.
6168: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6169: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6170: p_msg_data=>x_msg_data,
6171: p_msg_type=>'UNEXPECTED ERROR',
6172: p_msg_level=>fnd_log.level_error);

Line 6172: p_msg_level=>fnd_log.level_error);

6168: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6169: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6170: p_msg_data=>x_msg_data,
6171: p_msg_type=>'UNEXPECTED ERROR',
6172: p_msg_level=>fnd_log.level_error);
6173: END IF;
6174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6175: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
6176: p_prefix=>l_debug_prefix,

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

6170: p_msg_data=>x_msg_data,
6171: p_msg_type=>'UNEXPECTED ERROR',
6172: p_msg_level=>fnd_log.level_error);
6173: END IF;
6174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6175: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
6176: p_prefix=>l_debug_prefix,
6177: p_msg_level=>fnd_log.level_procedure);
6178: END IF;

Line 6177: p_msg_level=>fnd_log.level_procedure);

6173: END IF;
6174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6175: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
6176: p_prefix=>l_debug_prefix,
6177: p_msg_level=>fnd_log.level_procedure);
6178: END IF;
6179:
6180: -- Check if API is called in debug mode. If yes, disable debug.
6181: --disable_debug;

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

6190: p_count => x_msg_count,
6191: p_data => x_msg_data);
6192:
6193: -- Debug info.
6194: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6195: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6196: p_msg_data=>x_msg_data,
6197: p_msg_type=>'SQL ERROR',
6198: p_msg_level=>fnd_log.level_error);

Line 6198: p_msg_level=>fnd_log.level_error);

6194: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6195: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6196: p_msg_data=>x_msg_data,
6197: p_msg_type=>'SQL ERROR',
6198: p_msg_level=>fnd_log.level_error);
6199: END IF;
6200: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6201: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
6202: p_prefix=>l_debug_prefix,

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

6196: p_msg_data=>x_msg_data,
6197: p_msg_type=>'SQL ERROR',
6198: p_msg_level=>fnd_log.level_error);
6199: END IF;
6200: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6201: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
6202: p_prefix=>l_debug_prefix,
6203: p_msg_level=>fnd_log.level_procedure);
6204: END IF;

Line 6203: p_msg_level=>fnd_log.level_procedure);

6199: END IF;
6200: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6201: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
6202: p_prefix=>l_debug_prefix,
6203: p_msg_level=>fnd_log.level_procedure);
6204: END IF;
6205:
6206: -- Check if API is called in debug mode. If yes, disable debug.
6207: --disable_debug;

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

6256: -- Check if API is called in debug mode. If yes, enable debug.
6257: --enable_debug;
6258:
6259: -- Debug info.
6260: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6261: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (+)',
6262: p_prefix=>l_debug_prefix,
6263: p_msg_level=>fnd_log.level_procedure);
6264: END IF;

Line 6263: p_msg_level=>fnd_log.level_procedure);

6259: -- Debug info.
6260: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6261: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (+)',
6262: p_prefix=>l_debug_prefix,
6263: p_msg_level=>fnd_log.level_procedure);
6264: END IF;
6265:
6266: -- initialize API return status to success.
6267: x_return_status := fnd_api.g_ret_sts_success;

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

6296: RAISE fnd_api.g_exc_error;
6297: END IF;
6298:
6299: -- Debug info.
6300: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6301: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
6302: p_prefix=>l_debug_prefix,
6303: p_msg_level=>fnd_log.level_procedure);
6304: END IF;

Line 6303: p_msg_level=>fnd_log.level_procedure);

6299: -- Debug info.
6300: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6301: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
6302: p_prefix=>l_debug_prefix,
6303: p_msg_level=>fnd_log.level_procedure);
6304: END IF;
6305:
6306: -- disable the debug procedure before exiting.
6307: --disable_debug;

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

6313: p_count => x_msg_count,
6314: p_data => x_msg_data);
6315:
6316: -- Debug info.
6317: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6318: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6319: p_msg_data=>x_msg_data,
6320: p_msg_type=>'ERROR',
6321: p_msg_level=>fnd_log.level_error);

Line 6321: p_msg_level=>fnd_log.level_error);

6317: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6318: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6319: p_msg_data=>x_msg_data,
6320: p_msg_type=>'ERROR',
6321: p_msg_level=>fnd_log.level_error);
6322: END IF;
6323: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6324: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
6325: p_prefix=>l_debug_prefix,

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

6319: p_msg_data=>x_msg_data,
6320: p_msg_type=>'ERROR',
6321: p_msg_level=>fnd_log.level_error);
6322: END IF;
6323: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6324: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
6325: p_prefix=>l_debug_prefix,
6326: p_msg_level=>fnd_log.level_procedure);
6327: END IF;

Line 6326: p_msg_level=>fnd_log.level_procedure);

6322: END IF;
6323: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6324: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
6325: p_prefix=>l_debug_prefix,
6326: p_msg_level=>fnd_log.level_procedure);
6327: END IF;
6328:
6329: -- Check if API is called in debug mode. If yes, disable debug.
6330: --disable_debug;

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

6336: p_count => x_msg_count,
6337: p_data => x_msg_data);
6338:
6339: -- Debug info.
6340: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6341: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6342: p_msg_data=>x_msg_data,
6343: p_msg_type=>'UNEXPECTED ERROR',
6344: p_msg_level=>fnd_log.level_error);

Line 6344: p_msg_level=>fnd_log.level_error);

6340: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6341: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6342: p_msg_data=>x_msg_data,
6343: p_msg_type=>'UNEXPECTED ERROR',
6344: p_msg_level=>fnd_log.level_error);
6345: END IF;
6346: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6347: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
6348: p_prefix=>l_debug_prefix,

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

6342: p_msg_data=>x_msg_data,
6343: p_msg_type=>'UNEXPECTED ERROR',
6344: p_msg_level=>fnd_log.level_error);
6345: END IF;
6346: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6347: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
6348: p_prefix=>l_debug_prefix,
6349: p_msg_level=>fnd_log.level_procedure);
6350: END IF;

Line 6349: p_msg_level=>fnd_log.level_procedure);

6345: END IF;
6346: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6347: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
6348: p_prefix=>l_debug_prefix,
6349: p_msg_level=>fnd_log.level_procedure);
6350: END IF;
6351:
6352: -- Check if API is called in debug mode. If yes, disable debug.
6353: --disable_debug;

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

6362: p_count => x_msg_count,
6363: p_data => x_msg_data);
6364:
6365: -- Debug info.
6366: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6367: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6368: p_msg_data=>x_msg_data,
6369: p_msg_type=>'SQL ERROR',
6370: p_msg_level=>fnd_log.level_error);

Line 6370: p_msg_level=>fnd_log.level_error);

6366: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6367: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6368: p_msg_data=>x_msg_data,
6369: p_msg_type=>'SQL ERROR',
6370: p_msg_level=>fnd_log.level_error);
6371: END IF;
6372: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6373: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
6374: p_prefix=>l_debug_prefix,

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

6368: p_msg_data=>x_msg_data,
6369: p_msg_type=>'SQL ERROR',
6370: p_msg_level=>fnd_log.level_error);
6371: END IF;
6372: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6373: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
6374: p_prefix=>l_debug_prefix,
6375: p_msg_level=>fnd_log.level_procedure);
6376: END IF;

Line 6375: p_msg_level=>fnd_log.level_procedure);

6371: END IF;
6372: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6373: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
6374: p_prefix=>l_debug_prefix,
6375: p_msg_level=>fnd_log.level_procedure);
6376: END IF;
6377:
6378: -- Check if API is called in debug mode. If yes, disable debug.
6379: --disable_debug;

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

6428: -- Check if API is called in debug mode. If yes, enable debug.
6429: --enable_debug;
6430:
6431: -- Debug info.
6432: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6433: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (+)',
6434: p_prefix=>l_debug_prefix,
6435: p_msg_level=>fnd_log.level_procedure);
6436: END IF;

Line 6435: p_msg_level=>fnd_log.level_procedure);

6431: -- Debug info.
6432: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6433: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (+)',
6434: p_prefix=>l_debug_prefix,
6435: p_msg_level=>fnd_log.level_procedure);
6436: END IF;
6437:
6438: -- initialize API return status to success.
6439: x_return_status := fnd_api.g_ret_sts_success;

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

6468: RAISE fnd_api.g_exc_error;
6469: END IF;
6470:
6471: -- Debug info.
6472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6473: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
6474: p_prefix=>l_debug_prefix,
6475: p_msg_level=>fnd_log.level_procedure);
6476: END IF;

Line 6475: p_msg_level=>fnd_log.level_procedure);

6471: -- Debug info.
6472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6473: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
6474: p_prefix=>l_debug_prefix,
6475: p_msg_level=>fnd_log.level_procedure);
6476: END IF;
6477:
6478: -- disable the debug procedure before exiting.
6479: --disable_debug;

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

6485: p_count => x_msg_count,
6486: p_data => x_msg_data);
6487:
6488: -- Debug info.
6489: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6490: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6491: p_msg_data=>x_msg_data,
6492: p_msg_type=>'ERROR',
6493: p_msg_level=>fnd_log.level_error);

Line 6493: p_msg_level=>fnd_log.level_error);

6489: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6490: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6491: p_msg_data=>x_msg_data,
6492: p_msg_type=>'ERROR',
6493: p_msg_level=>fnd_log.level_error);
6494: END IF;
6495: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6496: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
6497: p_prefix=>l_debug_prefix,

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

6491: p_msg_data=>x_msg_data,
6492: p_msg_type=>'ERROR',
6493: p_msg_level=>fnd_log.level_error);
6494: END IF;
6495: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6496: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
6497: p_prefix=>l_debug_prefix,
6498: p_msg_level=>fnd_log.level_procedure);
6499: END IF;

Line 6498: p_msg_level=>fnd_log.level_procedure);

6494: END IF;
6495: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6496: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
6497: p_prefix=>l_debug_prefix,
6498: p_msg_level=>fnd_log.level_procedure);
6499: END IF;
6500:
6501: -- Check if API is called in debug mode. If yes, disable debug.
6502: --disable_debug;

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

6508: p_count => x_msg_count,
6509: p_data => x_msg_data);
6510:
6511: -- Debug info.
6512: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6513: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6514: p_msg_data=>x_msg_data,
6515: p_msg_type=>'UNEXPECTED ERROR',
6516: p_msg_level=>fnd_log.level_error);

Line 6516: p_msg_level=>fnd_log.level_error);

6512: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6513: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6514: p_msg_data=>x_msg_data,
6515: p_msg_type=>'UNEXPECTED ERROR',
6516: p_msg_level=>fnd_log.level_error);
6517: END IF;
6518: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6519: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
6520: p_prefix=>l_debug_prefix,

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

6514: p_msg_data=>x_msg_data,
6515: p_msg_type=>'UNEXPECTED ERROR',
6516: p_msg_level=>fnd_log.level_error);
6517: END IF;
6518: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6519: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
6520: p_prefix=>l_debug_prefix,
6521: p_msg_level=>fnd_log.level_procedure);
6522: END IF;

Line 6521: p_msg_level=>fnd_log.level_procedure);

6517: END IF;
6518: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6519: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
6520: p_prefix=>l_debug_prefix,
6521: p_msg_level=>fnd_log.level_procedure);
6522: END IF;
6523:
6524: -- Check if API is called in debug mode. If yes, disable debug.
6525: --disable_debug;

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

6534: p_count => x_msg_count,
6535: p_data => x_msg_data);
6536:
6537: -- Debug info.
6538: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6539: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6540: p_msg_data=>x_msg_data,
6541: p_msg_type=>'SQL ERROR',
6542: p_msg_level=>fnd_log.level_error);

Line 6542: p_msg_level=>fnd_log.level_error);

6538: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6539: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6540: p_msg_data=>x_msg_data,
6541: p_msg_type=>'SQL ERROR',
6542: p_msg_level=>fnd_log.level_error);
6543: END IF;
6544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6545: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
6546: p_prefix=>l_debug_prefix,

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

6540: p_msg_data=>x_msg_data,
6541: p_msg_type=>'SQL ERROR',
6542: p_msg_level=>fnd_log.level_error);
6543: END IF;
6544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6545: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
6546: p_prefix=>l_debug_prefix,
6547: p_msg_level=>fnd_log.level_procedure);
6548: END IF;

Line 6547: p_msg_level=>fnd_log.level_procedure);

6543: END IF;
6544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6545: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
6546: p_prefix=>l_debug_prefix,
6547: p_msg_level=>fnd_log.level_procedure);
6548: END IF;
6549:
6550: -- Check if API is called in debug mode. If yes, disable debug.
6551: --disable_debug;

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

6600: -- Check if API is called in debug mode. If yes, enable debug.
6601: --enable_debug;
6602:
6603: -- Debug info.
6604: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6605: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (+)',
6606: p_prefix=>l_debug_prefix,
6607: p_msg_level=>fnd_log.level_procedure);
6608: END IF;

Line 6607: p_msg_level=>fnd_log.level_procedure);

6603: -- Debug info.
6604: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6605: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (+)',
6606: p_prefix=>l_debug_prefix,
6607: p_msg_level=>fnd_log.level_procedure);
6608: END IF;
6609:
6610: -- initialize API return status to success.
6611: x_return_status := fnd_api.g_ret_sts_success;

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

6640: RAISE fnd_api.g_exc_error;
6641: END IF;
6642:
6643: -- Debug info.
6644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6645: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
6646: p_prefix=>l_debug_prefix,
6647: p_msg_level=>fnd_log.level_procedure);
6648: END IF;

Line 6647: p_msg_level=>fnd_log.level_procedure);

6643: -- Debug info.
6644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6645: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
6646: p_prefix=>l_debug_prefix,
6647: p_msg_level=>fnd_log.level_procedure);
6648: END IF;
6649:
6650: -- disable the debug procedure before exiting.
6651: --disable_debug;

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

6657: p_count => x_msg_count,
6658: p_data => x_msg_data);
6659:
6660: -- Debug info.
6661: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6662: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6663: p_msg_data=>x_msg_data,
6664: p_msg_type=>'ERROR',
6665: p_msg_level=>fnd_log.level_error);

Line 6665: p_msg_level=>fnd_log.level_error);

6661: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6662: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6663: p_msg_data=>x_msg_data,
6664: p_msg_type=>'ERROR',
6665: p_msg_level=>fnd_log.level_error);
6666: END IF;
6667: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6668: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
6669: p_prefix=>l_debug_prefix,

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

6663: p_msg_data=>x_msg_data,
6664: p_msg_type=>'ERROR',
6665: p_msg_level=>fnd_log.level_error);
6666: END IF;
6667: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6668: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
6669: p_prefix=>l_debug_prefix,
6670: p_msg_level=>fnd_log.level_procedure);
6671: END IF;

Line 6670: p_msg_level=>fnd_log.level_procedure);

6666: END IF;
6667: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6668: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
6669: p_prefix=>l_debug_prefix,
6670: p_msg_level=>fnd_log.level_procedure);
6671: END IF;
6672:
6673: -- Check if API is called in debug mode. If yes, disable debug.
6674: --disable_debug;

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

6680: p_count => x_msg_count,
6681: p_data => x_msg_data);
6682:
6683: -- Debug info.
6684: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6685: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6686: p_msg_data=>x_msg_data,
6687: p_msg_type=>'UNEXPECTED ERROR',
6688: p_msg_level=>fnd_log.level_error);

Line 6688: p_msg_level=>fnd_log.level_error);

6684: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6685: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6686: p_msg_data=>x_msg_data,
6687: p_msg_type=>'UNEXPECTED ERROR',
6688: p_msg_level=>fnd_log.level_error);
6689: END IF;
6690: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6691: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
6692: p_prefix=>l_debug_prefix,

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

6686: p_msg_data=>x_msg_data,
6687: p_msg_type=>'UNEXPECTED ERROR',
6688: p_msg_level=>fnd_log.level_error);
6689: END IF;
6690: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6691: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
6692: p_prefix=>l_debug_prefix,
6693: p_msg_level=>fnd_log.level_procedure);
6694: END IF;

Line 6693: p_msg_level=>fnd_log.level_procedure);

6689: END IF;
6690: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6691: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
6692: p_prefix=>l_debug_prefix,
6693: p_msg_level=>fnd_log.level_procedure);
6694: END IF;
6695:
6696: -- Check if API is called in debug mode. If yes, disable debug.
6697: --disable_debug;

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

6706: p_count => x_msg_count,
6707: p_data => x_msg_data);
6708:
6709: -- Debug info.
6710: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6711: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6712: p_msg_data=>x_msg_data,
6713: p_msg_type=>'SQL ERROR',
6714: p_msg_level=>fnd_log.level_error);

Line 6714: p_msg_level=>fnd_log.level_error);

6710: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6711: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6712: p_msg_data=>x_msg_data,
6713: p_msg_type=>'SQL ERROR',
6714: p_msg_level=>fnd_log.level_error);
6715: END IF;
6716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6717: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
6718: p_prefix=>l_debug_prefix,

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

6712: p_msg_data=>x_msg_data,
6713: p_msg_type=>'SQL ERROR',
6714: p_msg_level=>fnd_log.level_error);
6715: END IF;
6716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6717: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
6718: p_prefix=>l_debug_prefix,
6719: p_msg_level=>fnd_log.level_procedure);
6720: END IF;

Line 6719: p_msg_level=>fnd_log.level_procedure);

6715: END IF;
6716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6717: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
6718: p_prefix=>l_debug_prefix,
6719: p_msg_level=>fnd_log.level_procedure);
6720: END IF;
6721:
6722: -- Check if API is called in debug mode. If yes, disable debug.
6723: --disable_debug;

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

6772: -- Check if API is called in debug mode. If yes, enable debug.
6773: --enable_debug;
6774:
6775: -- Debug info.
6776: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6777: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (+)',
6778: p_prefix=>l_debug_prefix,
6779: p_msg_level=>fnd_log.level_procedure);
6780: END IF;

Line 6779: p_msg_level=>fnd_log.level_procedure);

6775: -- Debug info.
6776: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6777: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (+)',
6778: p_prefix=>l_debug_prefix,
6779: p_msg_level=>fnd_log.level_procedure);
6780: END IF;
6781:
6782: -- initialize API return status to success.
6783: x_return_status := fnd_api.g_ret_sts_success;

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

6812: RAISE fnd_api.g_exc_error;
6813: END IF;
6814:
6815: -- Debug info.
6816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6817: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
6818: p_prefix=>l_debug_prefix,
6819: p_msg_level=>fnd_log.level_procedure);
6820: END IF;

Line 6819: p_msg_level=>fnd_log.level_procedure);

6815: -- Debug info.
6816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6817: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
6818: p_prefix=>l_debug_prefix,
6819: p_msg_level=>fnd_log.level_procedure);
6820: END IF;
6821:
6822: -- disable the debug procedure before exiting.
6823: --disable_debug;

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

6829: p_count => x_msg_count,
6830: p_data => x_msg_data);
6831:
6832: -- Debug info.
6833: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6834: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6835: p_msg_data=>x_msg_data,
6836: p_msg_type=>'ERROR',
6837: p_msg_level=>fnd_log.level_error);

Line 6837: p_msg_level=>fnd_log.level_error);

6833: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6834: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6835: p_msg_data=>x_msg_data,
6836: p_msg_type=>'ERROR',
6837: p_msg_level=>fnd_log.level_error);
6838: END IF;
6839: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6840: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
6841: p_prefix=>l_debug_prefix,

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

6835: p_msg_data=>x_msg_data,
6836: p_msg_type=>'ERROR',
6837: p_msg_level=>fnd_log.level_error);
6838: END IF;
6839: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6840: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
6841: p_prefix=>l_debug_prefix,
6842: p_msg_level=>fnd_log.level_procedure);
6843: END IF;

Line 6842: p_msg_level=>fnd_log.level_procedure);

6838: END IF;
6839: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6840: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
6841: p_prefix=>l_debug_prefix,
6842: p_msg_level=>fnd_log.level_procedure);
6843: END IF;
6844:
6845: -- Check if API is called in debug mode. If yes, disable debug.
6846: --disable_debug;

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

6852: p_count => x_msg_count,
6853: p_data => x_msg_data);
6854:
6855: -- Debug info.
6856: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6857: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6858: p_msg_data=>x_msg_data,
6859: p_msg_type=>'UNEXPECTED ERROR',
6860: p_msg_level=>fnd_log.level_error);

Line 6860: p_msg_level=>fnd_log.level_error);

6856: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6857: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6858: p_msg_data=>x_msg_data,
6859: p_msg_type=>'UNEXPECTED ERROR',
6860: p_msg_level=>fnd_log.level_error);
6861: END IF;
6862: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6863: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
6864: p_prefix=>l_debug_prefix,

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

6858: p_msg_data=>x_msg_data,
6859: p_msg_type=>'UNEXPECTED ERROR',
6860: p_msg_level=>fnd_log.level_error);
6861: END IF;
6862: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6863: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
6864: p_prefix=>l_debug_prefix,
6865: p_msg_level=>fnd_log.level_procedure);
6866: END IF;

Line 6865: p_msg_level=>fnd_log.level_procedure);

6861: END IF;
6862: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6863: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
6864: p_prefix=>l_debug_prefix,
6865: p_msg_level=>fnd_log.level_procedure);
6866: END IF;
6867:
6868: -- Check if API is called in debug mode. If yes, disable debug.
6869: --disable_debug;

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

6878: p_count => x_msg_count,
6879: p_data => x_msg_data);
6880:
6881: -- Debug info.
6882: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6883: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6884: p_msg_data=>x_msg_data,
6885: p_msg_type=>'SQL ERROR',
6886: p_msg_level=>fnd_log.level_error);

Line 6886: p_msg_level=>fnd_log.level_error);

6882: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6883: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6884: p_msg_data=>x_msg_data,
6885: p_msg_type=>'SQL ERROR',
6886: p_msg_level=>fnd_log.level_error);
6887: END IF;
6888: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6889: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
6890: p_prefix=>l_debug_prefix,

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

6884: p_msg_data=>x_msg_data,
6885: p_msg_type=>'SQL ERROR',
6886: p_msg_level=>fnd_log.level_error);
6887: END IF;
6888: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6889: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
6890: p_prefix=>l_debug_prefix,
6891: p_msg_level=>fnd_log.level_procedure);
6892: END IF;

Line 6891: p_msg_level=>fnd_log.level_procedure);

6887: END IF;
6888: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6889: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
6890: p_prefix=>l_debug_prefix,
6891: p_msg_level=>fnd_log.level_procedure);
6892: END IF;
6893:
6894: -- Check if API is called in debug mode. If yes, disable debug.
6895: --disable_debug;

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

6944: -- Check if API is called in debug mode. If yes, enable debug.
6945: --enable_debug;
6946:
6947: -- Debug info.
6948: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6949: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (+)',
6950: p_prefix=>l_debug_prefix,
6951: p_msg_level=>fnd_log.level_procedure);
6952: END IF;

Line 6951: p_msg_level=>fnd_log.level_procedure);

6947: -- Debug info.
6948: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6949: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (+)',
6950: p_prefix=>l_debug_prefix,
6951: p_msg_level=>fnd_log.level_procedure);
6952: END IF;
6953:
6954:
6955: -- initialize API return status to success.

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

6985: RAISE fnd_api.g_exc_error;
6986: END IF;
6987:
6988: -- Debug info.
6989: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6990: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
6991: p_prefix=>l_debug_prefix,
6992: p_msg_level=>fnd_log.level_procedure);
6993: END IF;

Line 6992: p_msg_level=>fnd_log.level_procedure);

6988: -- Debug info.
6989: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6990: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
6991: p_prefix=>l_debug_prefix,
6992: p_msg_level=>fnd_log.level_procedure);
6993: END IF;
6994:
6995: -- disable the debug procedure before exiting.
6996: --disable_debug;

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

7002: p_count => x_msg_count,
7003: p_data => x_msg_data);
7004:
7005: -- Debug info.
7006: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
7007: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
7008: p_msg_data=>x_msg_data,
7009: p_msg_type=>'ERROR',
7010: p_msg_level=>fnd_log.level_error);

Line 7010: p_msg_level=>fnd_log.level_error);

7006: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
7007: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
7008: p_msg_data=>x_msg_data,
7009: p_msg_type=>'ERROR',
7010: p_msg_level=>fnd_log.level_error);
7011: END IF;
7012: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7013: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
7014: p_prefix=>l_debug_prefix,

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

7008: p_msg_data=>x_msg_data,
7009: p_msg_type=>'ERROR',
7010: p_msg_level=>fnd_log.level_error);
7011: END IF;
7012: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7013: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
7014: p_prefix=>l_debug_prefix,
7015: p_msg_level=>fnd_log.level_procedure);
7016: END IF;

Line 7015: p_msg_level=>fnd_log.level_procedure);

7011: END IF;
7012: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7013: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
7014: p_prefix=>l_debug_prefix,
7015: p_msg_level=>fnd_log.level_procedure);
7016: END IF;
7017:
7018: -- Check if API is called in debug mode. If yes, disable debug.
7019: --disable_debug;

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

7025: p_count => x_msg_count,
7026: p_data => x_msg_data);
7027:
7028: -- Debug info.
7029: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
7030: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
7031: p_msg_data=>x_msg_data,
7032: p_msg_type=>'UNEXPECTED ERROR',
7033: p_msg_level=>fnd_log.level_error);

Line 7033: p_msg_level=>fnd_log.level_error);

7029: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
7030: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
7031: p_msg_data=>x_msg_data,
7032: p_msg_type=>'UNEXPECTED ERROR',
7033: p_msg_level=>fnd_log.level_error);
7034: END IF;
7035: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7036: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
7037: p_prefix=>l_debug_prefix,

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

7031: p_msg_data=>x_msg_data,
7032: p_msg_type=>'UNEXPECTED ERROR',
7033: p_msg_level=>fnd_log.level_error);
7034: END IF;
7035: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7036: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
7037: p_prefix=>l_debug_prefix,
7038: p_msg_level=>fnd_log.level_procedure);
7039: END IF;

Line 7038: p_msg_level=>fnd_log.level_procedure);

7034: END IF;
7035: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7036: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
7037: p_prefix=>l_debug_prefix,
7038: p_msg_level=>fnd_log.level_procedure);
7039: END IF;
7040:
7041: -- Check if API is called in debug mode. If yes, disable debug.
7042: --disable_debug;

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

7051: p_count => x_msg_count,
7052: p_data => x_msg_data);
7053:
7054: -- Debug info.
7055: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
7056: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
7057: p_msg_data=>x_msg_data,
7058: p_msg_type=>'SQL ERROR',
7059: p_msg_level=>fnd_log.level_error);

Line 7059: p_msg_level=>fnd_log.level_error);

7055: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
7056: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
7057: p_msg_data=>x_msg_data,
7058: p_msg_type=>'SQL ERROR',
7059: p_msg_level=>fnd_log.level_error);
7060: END IF;
7061: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7062: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
7063: p_prefix=>l_debug_prefix,

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

7057: p_msg_data=>x_msg_data,
7058: p_msg_type=>'SQL ERROR',
7059: p_msg_level=>fnd_log.level_error);
7060: END IF;
7061: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7062: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
7063: p_prefix=>l_debug_prefix,
7064: p_msg_level=>fnd_log.level_procedure);
7065: END IF;

Line 7064: p_msg_level=>fnd_log.level_procedure);

7060: END IF;
7061: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7062: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
7063: p_prefix=>l_debug_prefix,
7064: p_msg_level=>fnd_log.level_procedure);
7065: END IF;
7066:
7067: -- Check if API is called in debug mode. If yes, disable debug.
7068: --disable_debug;

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

7114:
7115: l_debug_prefix := '';
7116:
7117: -- Debug info.
7118: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7119: hz_utility_v2pub.debug (
7120: p_message => c_api_name||' (+)',
7121: p_prefix => l_debug_prefix,
7122: p_msg_level => fnd_log.level_procedure

Line 7122: p_msg_level => fnd_log.level_procedure

7118: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7119: hz_utility_v2pub.debug (
7120: p_message => c_api_name||' (+)',
7121: p_prefix => l_debug_prefix,
7122: p_msg_level => fnd_log.level_procedure
7123: );
7124: END IF;
7125:
7126: -- initialize message list if p_init_msg_list is set to TRUE.

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

7165: p_count => x_msg_count,
7166: p_data => x_msg_data);
7167:
7168: -- Debug info.
7169: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7170: hz_utility_v2pub.debug_return_messages (
7171: p_msg_count => x_msg_count,
7172: p_msg_data => x_msg_data,
7173: p_msg_type => 'WARNING',

Line 7174: p_msg_level => fnd_log.level_exception

7170: hz_utility_v2pub.debug_return_messages (
7171: p_msg_count => x_msg_count,
7172: p_msg_data => x_msg_data,
7173: p_msg_type => 'WARNING',
7174: p_msg_level => fnd_log.level_exception
7175: );
7176: END IF;
7177:
7178: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

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

7174: p_msg_level => fnd_log.level_exception
7175: );
7176: END IF;
7177:
7178: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7179: hz_utility_v2pub.debug (
7180: p_message => c_api_name||' (-)',
7181: p_prefix => l_debug_prefix,
7182: p_msg_level => fnd_log.level_procedure

Line 7182: p_msg_level => fnd_log.level_procedure

7178: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7179: hz_utility_v2pub.debug (
7180: p_message => c_api_name||' (-)',
7181: p_prefix => l_debug_prefix,
7182: p_msg_level => fnd_log.level_procedure
7183: );
7184: END IF;
7185:
7186: EXCEPTION

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

7193: p_data => x_msg_data
7194: );
7195:
7196: -- Debug info.
7197: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7198: hz_utility_v2pub.debug_return_messages (
7199: p_msg_count => x_msg_count,
7200: p_msg_data => x_msg_data,
7201: p_msg_type => 'ERROR',

Line 7202: p_msg_level => fnd_log.level_error

7198: hz_utility_v2pub.debug_return_messages (
7199: p_msg_count => x_msg_count,
7200: p_msg_data => x_msg_data,
7201: p_msg_type => 'ERROR',
7202: p_msg_level => fnd_log.level_error
7203: );
7204: END IF;
7205:
7206: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

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

7202: p_msg_level => fnd_log.level_error
7203: );
7204: END IF;
7205:
7206: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7207: hz_utility_v2pub.debug (
7208: p_message => c_api_name||' (-)',
7209: p_prefix => l_debug_prefix,
7210: p_msg_level => fnd_log.level_procedure

Line 7210: p_msg_level => fnd_log.level_procedure

7206: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7207: hz_utility_v2pub.debug (
7208: p_message => c_api_name||' (-)',
7209: p_prefix => l_debug_prefix,
7210: p_msg_level => fnd_log.level_procedure
7211: );
7212: END IF;
7213:
7214: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

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

7219: p_data => x_msg_data
7220: );
7221:
7222: -- Debug info.
7223: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7224: hz_utility_v2pub.debug_return_messages (
7225: p_msg_count => x_msg_count,
7226: p_msg_data => x_msg_data,
7227: p_msg_type => 'UNEXPECTED ERROR',

Line 7228: p_msg_level => fnd_log.level_error

7224: hz_utility_v2pub.debug_return_messages (
7225: p_msg_count => x_msg_count,
7226: p_msg_data => x_msg_data,
7227: p_msg_type => 'UNEXPECTED ERROR',
7228: p_msg_level => fnd_log.level_error
7229: );
7230: END IF;
7231:
7232: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

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

7228: p_msg_level => fnd_log.level_error
7229: );
7230: END IF;
7231:
7232: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7233: hz_utility_v2pub.debug (
7234: p_message => c_api_name||' (-)',
7235: p_prefix => l_debug_prefix,
7236: p_msg_level => fnd_log.level_procedure

Line 7236: p_msg_level => fnd_log.level_procedure

7232: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7233: hz_utility_v2pub.debug (
7234: p_message => c_api_name||' (-)',
7235: p_prefix => l_debug_prefix,
7236: p_msg_level => fnd_log.level_procedure
7237: );
7238: END IF;
7239:
7240: WHEN OTHERS THEN

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

7250: p_data => x_msg_data
7251: );
7252:
7253: -- Debug info.
7254: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7255: hz_utility_v2pub.debug_return_messages (
7256: p_msg_count => x_msg_count,
7257: p_msg_data => x_msg_data,
7258: p_msg_type => 'SQL ERROR',

Line 7259: p_msg_level => fnd_log.level_error

7255: hz_utility_v2pub.debug_return_messages (
7256: p_msg_count => x_msg_count,
7257: p_msg_data => x_msg_data,
7258: p_msg_type => 'SQL ERROR',
7259: p_msg_level => fnd_log.level_error
7260: );
7261: END IF;
7262:
7263: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

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

7259: p_msg_level => fnd_log.level_error
7260: );
7261: END IF;
7262:
7263: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7264: hz_utility_v2pub.debug (
7265: p_message => c_api_name||' (-)',
7266: p_prefix => l_debug_prefix,
7267: p_msg_level => fnd_log.level_procedure

Line 7267: p_msg_level => fnd_log.level_procedure

7263: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7264: hz_utility_v2pub.debug (
7265: p_message => c_api_name||' (-)',
7266: p_prefix => l_debug_prefix,
7267: p_msg_level => fnd_log.level_procedure
7268: );
7269: END IF;
7270:
7271: END validate_bank;

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

7317:
7318: l_debug_prefix := '';
7319:
7320: -- Debug info.
7321: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7322: hz_utility_v2pub.debug (
7323: p_message => c_api_name||' (+)',
7324: p_prefix => l_debug_prefix,
7325: p_msg_level => fnd_log.level_procedure

Line 7325: p_msg_level => fnd_log.level_procedure

7321: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7322: hz_utility_v2pub.debug (
7323: p_message => c_api_name||' (+)',
7324: p_prefix => l_debug_prefix,
7325: p_msg_level => fnd_log.level_procedure
7326: );
7327: END IF;
7328:
7329: -- initialize message list if p_init_msg_list is set to TRUE.

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

7380: p_count => x_msg_count,
7381: p_data => x_msg_data);
7382:
7383: -- Debug info.
7384: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7385: hz_utility_v2pub.debug_return_messages (
7386: p_msg_count => x_msg_count,
7387: p_msg_data => x_msg_data,
7388: p_msg_type => 'WARNING',

Line 7389: p_msg_level => fnd_log.level_exception

7385: hz_utility_v2pub.debug_return_messages (
7386: p_msg_count => x_msg_count,
7387: p_msg_data => x_msg_data,
7388: p_msg_type => 'WARNING',
7389: p_msg_level => fnd_log.level_exception
7390: );
7391: END IF;
7392:
7393: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

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

7389: p_msg_level => fnd_log.level_exception
7390: );
7391: END IF;
7392:
7393: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7394: hz_utility_v2pub.debug (
7395: p_message => c_api_name||' (-)',
7396: p_prefix => l_debug_prefix,
7397: p_msg_level => fnd_log.level_procedure

Line 7397: p_msg_level => fnd_log.level_procedure

7393: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7394: hz_utility_v2pub.debug (
7395: p_message => c_api_name||' (-)',
7396: p_prefix => l_debug_prefix,
7397: p_msg_level => fnd_log.level_procedure
7398: );
7399: END IF;
7400:
7401: EXCEPTION

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

7408: p_data => x_msg_data
7409: );
7410:
7411: -- Debug info.
7412: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7413: hz_utility_v2pub.debug_return_messages (
7414: p_msg_count => x_msg_count,
7415: p_msg_data => x_msg_data,
7416: p_msg_type => 'ERROR',

Line 7417: p_msg_level => fnd_log.level_error

7413: hz_utility_v2pub.debug_return_messages (
7414: p_msg_count => x_msg_count,
7415: p_msg_data => x_msg_data,
7416: p_msg_type => 'ERROR',
7417: p_msg_level => fnd_log.level_error
7418: );
7419: END IF;
7420:
7421: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

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

7417: p_msg_level => fnd_log.level_error
7418: );
7419: END IF;
7420:
7421: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7422: hz_utility_v2pub.debug (
7423: p_message => c_api_name||' (-)',
7424: p_prefix => l_debug_prefix,
7425: p_msg_level => fnd_log.level_procedure

Line 7425: p_msg_level => fnd_log.level_procedure

7421: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7422: hz_utility_v2pub.debug (
7423: p_message => c_api_name||' (-)',
7424: p_prefix => l_debug_prefix,
7425: p_msg_level => fnd_log.level_procedure
7426: );
7427: END IF;
7428:
7429: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

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

7434: p_data => x_msg_data
7435: );
7436:
7437: -- Debug info.
7438: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7439: hz_utility_v2pub.debug_return_messages (
7440: p_msg_count => x_msg_count,
7441: p_msg_data => x_msg_data,
7442: p_msg_type => 'UNEXPECTED ERROR',

Line 7443: p_msg_level => fnd_log.level_error

7439: hz_utility_v2pub.debug_return_messages (
7440: p_msg_count => x_msg_count,
7441: p_msg_data => x_msg_data,
7442: p_msg_type => 'UNEXPECTED ERROR',
7443: p_msg_level => fnd_log.level_error
7444: );
7445: END IF;
7446:
7447: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

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

7443: p_msg_level => fnd_log.level_error
7444: );
7445: END IF;
7446:
7447: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7448: hz_utility_v2pub.debug (
7449: p_message => c_api_name||' (-)',
7450: p_prefix => l_debug_prefix,
7451: p_msg_level => fnd_log.level_procedure

Line 7451: p_msg_level => fnd_log.level_procedure

7447: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7448: hz_utility_v2pub.debug (
7449: p_message => c_api_name||' (-)',
7450: p_prefix => l_debug_prefix,
7451: p_msg_level => fnd_log.level_procedure
7452: );
7453: END IF;
7454:
7455: WHEN OTHERS THEN

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

7465: p_data => x_msg_data
7466: );
7467:
7468: -- Debug info.
7469: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7470: hz_utility_v2pub.debug_return_messages (
7471: p_msg_count => x_msg_count,
7472: p_msg_data => x_msg_data,
7473: p_msg_type => 'SQL ERROR',

Line 7474: p_msg_level => fnd_log.level_error

7470: hz_utility_v2pub.debug_return_messages (
7471: p_msg_count => x_msg_count,
7472: p_msg_data => x_msg_data,
7473: p_msg_type => 'SQL ERROR',
7474: p_msg_level => fnd_log.level_error
7475: );
7476: END IF;
7477:
7478: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

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

7474: p_msg_level => fnd_log.level_error
7475: );
7476: END IF;
7477:
7478: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7479: hz_utility_v2pub.debug (
7480: p_message => c_api_name||' (-)',
7481: p_prefix => l_debug_prefix,
7482: p_msg_level => fnd_log.level_procedure

Line 7482: p_msg_level => fnd_log.level_procedure

7478: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7479: hz_utility_v2pub.debug (
7480: p_message => c_api_name||' (-)',
7481: p_prefix => l_debug_prefix,
7482: p_msg_level => fnd_log.level_procedure
7483: );
7484: END IF;
7485:
7486: END validate_bank_branch;