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 202: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

Line 205: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 302: p_msg_level=>fnd_log.level_statement);

298: -- Debug info.
299: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
300: hz_utility_v2pub.debug(p_message=>'l_parent_id = '||l_parent_id,
301: p_prefix=>l_debug_prefix,
302: p_msg_level=>fnd_log.level_statement);
303: END IF;
304:
305: --
306: -- The combination of Bank Number (from the Bank to which the Branch

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

334: END IF;
335: CLOSE c_uniquenameck;
336:
337: -- Debug info.
338: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
339: hz_utility_v2pub.debug(p_message=>'validate_parent_bank (-)',
340: p_prefix=>l_debug_prefix,
341: p_msg_level=>fnd_log.level_procedure);
342: END IF;

Line 341: p_msg_level=>fnd_log.level_procedure);

337: -- Debug info.
338: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
339: hz_utility_v2pub.debug(p_message=>'validate_parent_bank (-)',
340: p_prefix=>l_debug_prefix,
341: p_msg_level=>fnd_log.level_procedure);
342: END IF;
343: END validate_parent_bank;
344:
345: /*=======================================================================+

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

380: -- Bug 3814832
381: l_country VARCHAR2(2);
382: BEGIN
383: -- Debug info.
384: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
385: hz_utility_v2pub.debug(p_message=>'validate_bank_org (+)',
386: p_prefix=>l_debug_prefix,
387: p_msg_level=>fnd_log.level_procedure);
388: END IF;

Line 387: p_msg_level=>fnd_log.level_procedure);

383: -- Debug info.
384: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
385: hz_utility_v2pub.debug(p_message=>'validate_bank_org (+)',
386: p_prefix=>l_debug_prefix,
387: p_msg_level=>fnd_log.level_procedure);
388: END IF;
389:
390: --
391: -- static validations

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

519: EXCEPTION
520: WHEN hz_dyn_validation.null_profile_value THEN
521: -- this error indicates that the profile value has not been set.
522: -- ignore this error
523: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
524: hz_utility_v2pub.debug(p_message=>'undefined profile:'||l_validation_procedure,
525: p_prefix=>'WARNING',
526: p_msg_level=>fnd_log.level_exception);
527: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 526: p_msg_level=>fnd_log.level_exception);

522: -- ignore this error
523: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
524: hz_utility_v2pub.debug(p_message=>'undefined profile:'||l_validation_procedure,
525: p_prefix=>'WARNING',
526: p_msg_level=>fnd_log.level_exception);
527: hz_utility_v2pub.debug(p_message=>'error ignored',
528: p_prefix=>'WARNING',
529: p_msg_level=>fnd_log.level_exception);
530: END IF;

Line 529: p_msg_level=>fnd_log.level_exception);

525: p_prefix=>'WARNING',
526: p_msg_level=>fnd_log.level_exception);
527: hz_utility_v2pub.debug(p_message=>'error ignored',
528: p_prefix=>'WARNING',
529: p_msg_level=>fnd_log.level_exception);
530: END IF;
531:
532: WHEN OTHERS THEN
533: -- set the error status, don't need to set the error stack because

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

535: x_return_status := fnd_api.g_ret_sts_error;
536: END;
537:
538: -- Debug info.
539: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
540: hz_utility_v2pub.debug(p_message=>'validate_bank_org (-)',
541: p_prefix=>l_debug_prefix,
542: p_msg_level=>fnd_log.level_procedure);
543: END IF;

Line 542: p_msg_level=>fnd_log.level_procedure);

538: -- Debug info.
539: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
540: hz_utility_v2pub.debug(p_message=>'validate_bank_org (-)',
541: p_prefix=>l_debug_prefix,
542: p_msg_level=>fnd_log.level_procedure);
543: END IF;
544: END validate_bank_org;
545:
546: /*=======================================================================+

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

601: l_dummy NUMBER;
602: l_debug_prefix VARCHAR2(30) := '';
603: BEGIN
604: -- Debug info.
605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
606: hz_utility_v2pub.debug(p_message=>'validate_edi_contact_point (+)',
607: p_prefix=>l_debug_prefix,
608: p_msg_level=>fnd_log.level_procedure);
609: END IF;

Line 608: p_msg_level=>fnd_log.level_procedure);

604: -- Debug info.
605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
606: hz_utility_v2pub.debug(p_message=>'validate_edi_contact_point (+)',
607: p_prefix=>l_debug_prefix,
608: p_msg_level=>fnd_log.level_procedure);
609: END IF;
610:
611: -- Validate uniqueness of EDI record.
612: -- first check across party contacts.

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

643: EXCEPTION
644: WHEN hz_dyn_validation.null_profile_value THEN
645: -- this error indicates that the profile value has not been set.
646: -- ignore this error
647: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
648: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
649: p_prefix=>'WARNING',
650: p_msg_level=>fnd_log.level_exception);
651: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 650: p_msg_level=>fnd_log.level_exception);

646: -- ignore this error
647: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
648: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
649: p_prefix=>'WARNING',
650: p_msg_level=>fnd_log.level_exception);
651: hz_utility_v2pub.debug(p_message=>'error ignored',
652: p_prefix=>'WARNING',
653: p_msg_level=>fnd_log.level_exception);
654: END IF;

Line 653: p_msg_level=>fnd_log.level_exception);

649: p_prefix=>'WARNING',
650: p_msg_level=>fnd_log.level_exception);
651: hz_utility_v2pub.debug(p_message=>'error ignored',
652: p_prefix=>'WARNING',
653: p_msg_level=>fnd_log.level_exception);
654: END IF;
655: WHEN OTHERS THEN
656: -- set the error status, don't need to set the error stack because
657: -- the dynamic validation procedure already does so.

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

658: x_return_status := fnd_api.g_ret_sts_error;
659: END;
660:
661: -- Debug info.
662: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
663: hz_utility_v2pub.debug(p_message=>'validate_edi_contact_point (+)',
664: p_prefix=>l_debug_prefix,
665: p_msg_level=>fnd_log.level_procedure);
666: END IF;

Line 665: p_msg_level=>fnd_log.level_procedure);

661: -- Debug info.
662: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
663: hz_utility_v2pub.debug(p_message=>'validate_edi_contact_point (+)',
664: p_prefix=>l_debug_prefix,
665: p_msg_level=>fnd_log.level_procedure);
666: END IF;
667: END validate_edi_contact_point;
668:
669: /*=======================================================================+

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

685: ) IS
686: l_debug_prefix VARCHAR2(30) := '';
687: BEGIN
688: -- Debug info.
689: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
690: hz_utility_v2pub.debug(p_message=>'validate_eft_contact_point (+)',
691: p_prefix=>l_debug_prefix,
692: p_msg_level=>fnd_log.level_procedure);
693: END IF;

Line 692: p_msg_level=>fnd_log.level_procedure);

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

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

706: EXCEPTION
707: WHEN hz_dyn_validation.null_profile_value THEN
708: -- this error indicates that the profile value has not been set.
709: -- ignore this error
710: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
711: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
712: p_prefix=>'WARNING',
713: p_msg_level=>fnd_log.level_exception);
714: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 713: p_msg_level=>fnd_log.level_exception);

709: -- ignore this error
710: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
711: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
712: p_prefix=>'WARNING',
713: p_msg_level=>fnd_log.level_exception);
714: hz_utility_v2pub.debug(p_message=>'error ignored',
715: p_prefix=>'WARNING',
716: p_msg_level=>fnd_log.level_exception);
717: END IF;

Line 716: p_msg_level=>fnd_log.level_exception);

712: p_prefix=>'WARNING',
713: p_msg_level=>fnd_log.level_exception);
714: hz_utility_v2pub.debug(p_message=>'error ignored',
715: p_prefix=>'WARNING',
716: p_msg_level=>fnd_log.level_exception);
717: END IF;
718: WHEN OTHERS THEN
719: -- set the error status, don't need to set the error stack because
720: -- the dynamic validation procedure already does so.

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

721: x_return_status := fnd_api.g_ret_sts_error;
722: END;
723:
724: -- Debug info.
725: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
726: hz_utility_v2pub.debug(p_message=>'validate_eft_contact_point (+)',
727: p_prefix=>l_debug_prefix,
728: p_msg_level=>fnd_log.level_procedure);
729: END IF;

Line 728: p_msg_level=>fnd_log.level_procedure);

724: -- Debug info.
725: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
726: hz_utility_v2pub.debug(p_message=>'validate_eft_contact_point (+)',
727: p_prefix=>l_debug_prefix,
728: p_msg_level=>fnd_log.level_procedure);
729: END IF;
730: END validate_eft_contact_point;
731:
732: /*=======================================================================+

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

748: ) IS
749: l_debug_prefix VARCHAR2(30) := '';
750: BEGIN
751: -- Debug info.
752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
753: hz_utility_v2pub.debug(p_message=>'validate_web_contact_point (+)',
754: p_prefix=>l_debug_prefix,
755: p_msg_level=>fnd_log.level_procedure);
756: END IF;

Line 755: p_msg_level=>fnd_log.level_procedure);

751: -- Debug info.
752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
753: hz_utility_v2pub.debug(p_message=>'validate_web_contact_point (+)',
754: p_prefix=>l_debug_prefix,
755: p_msg_level=>fnd_log.level_procedure);
756: END IF;
757:
758: BEGIN
759: hz_dyn_validation.validate_contact_point(

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

769: EXCEPTION
770: WHEN hz_dyn_validation.null_profile_value THEN
771: -- this error indicates that the profile value has not been set.
772: -- ignore this error
773: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
774: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
775: p_prefix=>'WARNING',
776: p_msg_level=>fnd_log.level_exception);
777: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 776: p_msg_level=>fnd_log.level_exception);

772: -- ignore this error
773: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
774: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
775: p_prefix=>'WARNING',
776: p_msg_level=>fnd_log.level_exception);
777: hz_utility_v2pub.debug(p_message=>'error ignored',
778: p_prefix=>'WARNING',
779: p_msg_level=>fnd_log.level_exception);
780: END IF;

Line 779: p_msg_level=>fnd_log.level_exception);

775: p_prefix=>'WARNING',
776: p_msg_level=>fnd_log.level_exception);
777: hz_utility_v2pub.debug(p_message=>'error ignored',
778: p_prefix=>'WARNING',
779: p_msg_level=>fnd_log.level_exception);
780: END IF;
781:
782: WHEN OTHERS THEN
783: -- set the error status, don't need to set the error stack because

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

785: x_return_status := fnd_api.g_ret_sts_error;
786: END;
787:
788: -- Debug info.
789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
790: hz_utility_v2pub.debug(p_message=>'validate_web_contact_point (+)',
791: p_prefix=>l_debug_prefix,
792: p_msg_level=>fnd_log.level_procedure);
793: END IF;

Line 792: p_msg_level=>fnd_log.level_procedure);

788: -- Debug info.
789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
790: hz_utility_v2pub.debug(p_message=>'validate_web_contact_point (+)',
791: p_prefix=>l_debug_prefix,
792: p_msg_level=>fnd_log.level_procedure);
793: END IF;
794: END validate_web_contact_point;
795:
796: /*=======================================================================+

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

812: ) IS
813: l_debug_prefix VARCHAR2(30) := '';
814: BEGIN
815: -- Debug info.
816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
817: hz_utility_v2pub.debug(p_message=>'validate_phone_contact_point (+)',
818: p_prefix=>l_debug_prefix,
819: p_msg_level=>fnd_log.level_procedure);
820: END IF;

Line 819: p_msg_level=>fnd_log.level_procedure);

815: -- Debug info.
816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
817: hz_utility_v2pub.debug(p_message=>'validate_phone_contact_point (+)',
818: p_prefix=>l_debug_prefix,
819: p_msg_level=>fnd_log.level_procedure);
820: END IF;
821:
822: BEGIN
823: hz_dyn_validation.validate_contact_point(

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

833: EXCEPTION
834: WHEN hz_dyn_validation.null_profile_value THEN
835: -- this error indicates that the profile value has not been set.
836: -- ignore this error
837: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
838: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
839: p_prefix=>'WARNING',
840: p_msg_level=>fnd_log.level_exception);
841: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 840: p_msg_level=>fnd_log.level_exception);

836: -- ignore this error
837: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
838: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
839: p_prefix=>'WARNING',
840: p_msg_level=>fnd_log.level_exception);
841: hz_utility_v2pub.debug(p_message=>'error ignored',
842: p_prefix=>'WARNING',
843: p_msg_level=>fnd_log.level_exception);
844: END IF;

Line 843: p_msg_level=>fnd_log.level_exception);

839: p_prefix=>'WARNING',
840: p_msg_level=>fnd_log.level_exception);
841: hz_utility_v2pub.debug(p_message=>'error ignored',
842: p_prefix=>'WARNING',
843: p_msg_level=>fnd_log.level_exception);
844: END IF;
845:
846: WHEN OTHERS THEN
847: -- set the error status, don't need to set the error stack because

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

849: x_return_status := fnd_api.g_ret_sts_error;
850: END;
851:
852: -- Debug info.
853: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
854: hz_utility_v2pub.debug(p_message=>'validate_phone_contact_point (+)',
855: p_prefix=>l_debug_prefix,
856: p_msg_level=>fnd_log.level_procedure);
857: END IF;

Line 856: p_msg_level=>fnd_log.level_procedure);

852: -- Debug info.
853: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
854: hz_utility_v2pub.debug(p_message=>'validate_phone_contact_point (+)',
855: p_prefix=>l_debug_prefix,
856: p_msg_level=>fnd_log.level_procedure);
857: END IF;
858: END validate_phone_contact_point;
859:
860: /*=======================================================================+

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

876: ) IS
877: l_debug_prefix VARCHAR2(30) := '';
878: BEGIN
879: -- Debug info.
880: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
881: hz_utility_v2pub.debug(p_message=>'validate_email_contact_point (+)',
882: p_prefix=>l_debug_prefix,
883: p_msg_level=>fnd_log.level_procedure);
884: END IF;

Line 883: p_msg_level=>fnd_log.level_procedure);

879: -- Debug info.
880: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
881: hz_utility_v2pub.debug(p_message=>'validate_email_contact_point (+)',
882: p_prefix=>l_debug_prefix,
883: p_msg_level=>fnd_log.level_procedure);
884: END IF;
885:
886: BEGIN
887: hz_dyn_validation.validate_contact_point(

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

897: EXCEPTION
898: WHEN hz_dyn_validation.null_profile_value THEN
899: -- this error indicates that the profile value has not been set.
900: -- ignore this error
901: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
902: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
903: p_prefix=>'WARNING',
904: p_msg_level=>fnd_log.level_exception);
905: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 904: p_msg_level=>fnd_log.level_exception);

900: -- ignore this error
901: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
902: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
903: p_prefix=>'WARNING',
904: p_msg_level=>fnd_log.level_exception);
905: hz_utility_v2pub.debug(p_message=>'error ignored',
906: p_prefix=>'WARNING',
907: p_msg_level=>fnd_log.level_exception);
908: END IF;

Line 907: p_msg_level=>fnd_log.level_exception);

903: p_prefix=>'WARNING',
904: p_msg_level=>fnd_log.level_exception);
905: hz_utility_v2pub.debug(p_message=>'error ignored',
906: p_prefix=>'WARNING',
907: p_msg_level=>fnd_log.level_exception);
908: END IF;
909: WHEN OTHERS THEN
910: -- set the error status, don't need to set the error stack because
911: -- the dynamic validation procedure already does so.

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

912: x_return_status := fnd_api.g_ret_sts_error;
913: END;
914:
915: -- Debug info.
916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
917: hz_utility_v2pub.debug(p_message=>'validate_email_contact_point (+)',
918: p_prefix=>l_debug_prefix,
919: p_msg_level=>fnd_log.level_procedure);
920: END IF;

Line 919: p_msg_level=>fnd_log.level_procedure);

915: -- Debug info.
916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
917: hz_utility_v2pub.debug(p_message=>'validate_email_contact_point (+)',
918: p_prefix=>l_debug_prefix,
919: p_msg_level=>fnd_log.level_procedure);
920: END IF;
921: END validate_email_contact_point;
922:
923: /*=======================================================================+

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

939: ) IS
940: l_debug_prefix VARCHAR2(30) := '';
941: BEGIN
942: -- Debug info.
943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
944: hz_utility_v2pub.debug(p_message=>'validate_telex_contact_point (+)',
945: p_prefix=>l_debug_prefix,
946: p_msg_level=>fnd_log.level_procedure);
947: END IF;

Line 946: p_msg_level=>fnd_log.level_procedure);

942: -- Debug info.
943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
944: hz_utility_v2pub.debug(p_message=>'validate_telex_contact_point (+)',
945: p_prefix=>l_debug_prefix,
946: p_msg_level=>fnd_log.level_procedure);
947: END IF;
948:
949: BEGIN
950: hz_dyn_validation.validate_contact_point(

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

960: EXCEPTION
961: WHEN hz_dyn_validation.null_profile_value THEN
962: -- this error indicates that the profile value has not been set.
963: -- ignore this error
964: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
965: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
966: p_prefix=>'WARNING',
967: p_msg_level=>fnd_log.level_exception);
968: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 967: p_msg_level=>fnd_log.level_exception);

963: -- ignore this error
964: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
965: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANK_CONTACT_POINT_VALIDATION_PROCEDURE',
966: p_prefix=>'WARNING',
967: p_msg_level=>fnd_log.level_exception);
968: hz_utility_v2pub.debug(p_message=>'error ignored',
969: p_prefix=>'WARNING',
970: p_msg_level=>fnd_log.level_exception);
971: END IF;

Line 970: p_msg_level=>fnd_log.level_exception);

966: p_prefix=>'WARNING',
967: p_msg_level=>fnd_log.level_exception);
968: hz_utility_v2pub.debug(p_message=>'error ignored',
969: p_prefix=>'WARNING',
970: p_msg_level=>fnd_log.level_exception);
971: END IF;
972: WHEN OTHERS THEN
973: -- set the error status, don't need to set the error stack because
974: -- the dynamic validation procedure already does so.

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

975: x_return_status := fnd_api.g_ret_sts_error;
976: END;
977:
978: -- Debug info.
979: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
980: hz_utility_v2pub.debug(p_message=>'validate_telex_contact_point (+)',
981: p_prefix=>l_debug_prefix,
982: p_msg_level=>fnd_log.level_procedure);
983: END IF;

Line 982: p_msg_level=>fnd_log.level_procedure);

978: -- Debug info.
979: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
980: hz_utility_v2pub.debug(p_message=>'validate_telex_contact_point (+)',
981: p_prefix=>l_debug_prefix,
982: p_msg_level=>fnd_log.level_procedure);
983: END IF;
984: END validate_telex_contact_point;
985:
986: /*=======================================================================+

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

1001: ) IS
1002: l_debug_prefix VARCHAR2(30) := '';
1003: BEGIN
1004: -- Debug info.
1005: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1006: hz_utility_v2pub.debug(p_message=>'validate_banking_group (+)',
1007: p_prefix=>l_debug_prefix,
1008: p_msg_level=>fnd_log.level_procedure);
1009: END IF;

Line 1008: p_msg_level=>fnd_log.level_procedure);

1004: -- Debug info.
1005: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1006: hz_utility_v2pub.debug(p_message=>'validate_banking_group (+)',
1007: p_prefix=>l_debug_prefix,
1008: p_msg_level=>fnd_log.level_procedure);
1009: END IF;
1010:
1011: -- Only one group type is currently supported.
1012: IF p_group_rec.group_type <> 'BANKING_GROUP' THEN

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

1025: EXCEPTION
1026: WHEN hz_dyn_validation.null_profile_value THEN
1027: -- this error indicates that the profile value has not been set.
1028: -- ignore this error
1029: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1030: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANKING_GROUP_VALIDATION_PROCEDURE',
1031: p_prefix=>'WARNING',
1032: p_msg_level=>fnd_log.level_exception);
1033: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 1032: p_msg_level=>fnd_log.level_exception);

1028: -- ignore this error
1029: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1030: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANKING_GROUP_VALIDATION_PROCEDURE',
1031: p_prefix=>'WARNING',
1032: p_msg_level=>fnd_log.level_exception);
1033: hz_utility_v2pub.debug(p_message=>'error ignored',
1034: p_prefix=>'WARNING',
1035: p_msg_level=>fnd_log.level_exception);
1036: END IF;

Line 1035: p_msg_level=>fnd_log.level_exception);

1031: p_prefix=>'WARNING',
1032: p_msg_level=>fnd_log.level_exception);
1033: hz_utility_v2pub.debug(p_message=>'error ignored',
1034: p_prefix=>'WARNING',
1035: p_msg_level=>fnd_log.level_exception);
1036: END IF;
1037: WHEN OTHERS THEN
1038: -- set the error status, don't need to set the error stack because
1039: -- the dynamic validation procedure already does so.

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

1040: x_return_status := fnd_api.g_ret_sts_error;
1041: END;
1042:
1043: -- Debug info.
1044: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1045: hz_utility_v2pub.debug(p_message=>'validate_banking_group (+)',
1046: p_prefix=>l_debug_prefix,
1047: p_msg_level=>fnd_log.level_procedure);
1048: END IF;

Line 1047: p_msg_level=>fnd_log.level_procedure);

1043: -- Debug info.
1044: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1045: hz_utility_v2pub.debug(p_message=>'validate_banking_group (+)',
1046: p_prefix=>l_debug_prefix,
1047: p_msg_level=>fnd_log.level_procedure);
1048: END IF;
1049: END validate_banking_group;
1050:
1051: /*=======================================================================+

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

1109: l_bank_id NUMBER;
1110: l_debug_prefix VARCHAR2(30) := '';
1111: BEGIN
1112: -- Debug info.
1113: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1114: hz_utility_v2pub.debug(p_message=>'validate_bank_group_member (+)',
1115: p_prefix=>l_debug_prefix,
1116: p_msg_level=>fnd_log.level_procedure);
1117: END IF;

Line 1116: p_msg_level=>fnd_log.level_procedure);

1112: -- Debug info.
1113: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1114: hz_utility_v2pub.debug(p_message=>'validate_bank_group_member (+)',
1115: p_prefix=>l_debug_prefix,
1116: p_msg_level=>fnd_log.level_procedure);
1117: END IF;
1118:
1119: -- Only one group membership relationship type is currently supported.
1120: -- Only check if we are in insert mode or the relationship_type was

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

1250: EXCEPTION
1251: WHEN hz_dyn_validation.null_profile_value THEN
1252: -- this error indicates that the profile value has not been set.
1253: -- ignore this error
1254: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1255: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANKING_GROUP_MEMBER_VALIDATION_PROCEDURE',
1256: p_prefix=>'WARNING',
1257: p_msg_level=>fnd_log.level_exception);
1258: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 1257: p_msg_level=>fnd_log.level_exception);

1253: -- ignore this error
1254: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1255: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_BANKING_GROUP_MEMBER_VALIDATION_PROCEDURE',
1256: p_prefix=>'WARNING',
1257: p_msg_level=>fnd_log.level_exception);
1258: hz_utility_v2pub.debug(p_message=>'error ignored',
1259: p_prefix=>'WARNING',
1260: p_msg_level=>fnd_log.level_exception);
1261: END IF;

Line 1260: p_msg_level=>fnd_log.level_exception);

1256: p_prefix=>'WARNING',
1257: p_msg_level=>fnd_log.level_exception);
1258: hz_utility_v2pub.debug(p_message=>'error ignored',
1259: p_prefix=>'WARNING',
1260: p_msg_level=>fnd_log.level_exception);
1261: END IF;
1262: WHEN OTHERS THEN
1263: -- set the error status, don't need to set the error stack because
1264: -- the dynamic validation procedure already does so.

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

1265: x_return_status := fnd_api.g_ret_sts_error;
1266: END;
1267:
1268: -- Debug info.
1269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1270: hz_utility_v2pub.debug(p_message=>'validate_bank_group_member (+)',
1271: p_prefix=>l_debug_prefix,
1272: p_msg_level=>fnd_log.level_procedure);
1273: END IF;

Line 1272: p_msg_level=>fnd_log.level_procedure);

1268: -- Debug info.
1269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1270: hz_utility_v2pub.debug(p_message=>'validate_bank_group_member (+)',
1271: p_prefix=>l_debug_prefix,
1272: p_msg_level=>fnd_log.level_procedure);
1273: END IF;
1274: END validate_bank_group_member;
1275:
1276: /*=======================================================================+

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

1295: l_direction VARCHAR2(30);
1296: l_debug_prefix VARCHAR2(30) := '';
1297: BEGIN
1298: -- Debug info.
1299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1300: hz_utility_v2pub.debug(p_message=>'validate_clearinghouse_assign (+)',
1301: p_prefix=>l_debug_prefix,
1302: p_msg_level=>fnd_log.level_procedure);
1303: END IF;

Line 1302: p_msg_level=>fnd_log.level_procedure);

1298: -- Debug info.
1299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1300: hz_utility_v2pub.debug(p_message=>'validate_clearinghouse_assign (+)',
1301: p_prefix=>l_debug_prefix,
1302: p_msg_level=>fnd_log.level_procedure);
1303: END IF;
1304:
1305: -- Only one group membership relationship type is currently supported.
1306: IF (p_mode = g_insert OR p_relationship_rec.relationship_type IS NOT NULL)

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

1417: EXCEPTION
1418: WHEN hz_dyn_validation.null_profile_value THEN
1419: -- this error indicates that the profile value has not been set.
1420: -- ignore this error
1421: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1422: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_CLEARINGHOUSE_ASSIGNMENT_VALIDATION_PROCEDURE',
1423: p_prefix=>'WARNING',
1424: p_msg_level=>fnd_log.level_exception);
1425: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 1424: p_msg_level=>fnd_log.level_exception);

1420: -- ignore this error
1421: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1422: hz_utility_v2pub.debug(p_message=>'undefined profile: HZ_CLEARINGHOUSE_ASSIGNMENT_VALIDATION_PROCEDURE',
1423: p_prefix=>'WARNING',
1424: p_msg_level=>fnd_log.level_exception);
1425: hz_utility_v2pub.debug(p_message=>'error ignored',
1426: p_prefix=>'WARNING',
1427: p_msg_level=>fnd_log.level_exception);
1428: END IF;

Line 1427: p_msg_level=>fnd_log.level_exception);

1423: p_prefix=>'WARNING',
1424: p_msg_level=>fnd_log.level_exception);
1425: hz_utility_v2pub.debug(p_message=>'error ignored',
1426: p_prefix=>'WARNING',
1427: p_msg_level=>fnd_log.level_exception);
1428: END IF;
1429: WHEN OTHERS THEN
1430: -- set the error status, don't need to set the error stack because
1431: -- the dynamic validation procedure already does so.

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

1432: x_return_status := fnd_api.g_ret_sts_error;
1433: END;
1434:
1435: -- Debug info.
1436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1437: hz_utility_v2pub.debug(p_message=>'validate_clearinghouse_assign (-)',
1438: p_prefix=>l_debug_prefix,
1439: p_msg_level=>fnd_log.level_procedure);
1440: END IF;

Line 1439: p_msg_level=>fnd_log.level_procedure);

1435: -- Debug info.
1436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1437: hz_utility_v2pub.debug(p_message=>'validate_clearinghouse_assign (-)',
1438: p_prefix=>l_debug_prefix,
1439: p_msg_level=>fnd_log.level_procedure);
1440: END IF;
1441: END validate_clearinghouse_assign;
1442:
1443: /*=======================================================================+

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

1487: l_temp_location_id NUMBER;
1488: l_debug_prefix VARCHAR2(30) := '';
1489: BEGIN
1490: -- Debug info.
1491: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1492: hz_utility_v2pub.debug(p_message=>'validate_bank_site (+)',
1493: p_prefix=>l_debug_prefix,
1494: p_msg_level=>fnd_log.level_procedure);
1495: END IF;

Line 1494: p_msg_level=>fnd_log.level_procedure);

1490: -- Debug info.
1491: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1492: hz_utility_v2pub.debug(p_message=>'validate_bank_site (+)',
1493: p_prefix=>l_debug_prefix,
1494: p_msg_level=>fnd_log.level_procedure);
1495: END IF;
1496:
1497: --
1498: -- Validate the country. The location's country must be the same as the

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

1616: EXCEPTION
1617: WHEN hz_dyn_validation.null_profile_value THEN
1618: -- this error indicates that the profile value has not been set.
1619: -- ignore this error
1620: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1621: hz_utility_v2pub.debug(p_message=>'undefined profile: '|| l_validation_procedure,
1622: p_prefix=>'WARNING',
1623: p_msg_level=>fnd_log.level_exception);
1624: hz_utility_v2pub.debug(p_message=>'error ignored',

Line 1623: p_msg_level=>fnd_log.level_exception);

1619: -- ignore this error
1620: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1621: hz_utility_v2pub.debug(p_message=>'undefined profile: '|| l_validation_procedure,
1622: p_prefix=>'WARNING',
1623: p_msg_level=>fnd_log.level_exception);
1624: hz_utility_v2pub.debug(p_message=>'error ignored',
1625: p_prefix=>'WARNING',
1626: p_msg_level=>fnd_log.level_exception);
1627: END IF;

Line 1626: p_msg_level=>fnd_log.level_exception);

1622: p_prefix=>'WARNING',
1623: p_msg_level=>fnd_log.level_exception);
1624: hz_utility_v2pub.debug(p_message=>'error ignored',
1625: p_prefix=>'WARNING',
1626: p_msg_level=>fnd_log.level_exception);
1627: END IF;
1628: WHEN OTHERS THEN
1629: -- set the error status, don't need to set the error stack because
1630: -- the dynamic validation procedure already does so.

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

1631: x_return_status := fnd_api.g_ret_sts_error;
1632: END;
1633:
1634: -- Debug info.
1635: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1636: hz_utility_v2pub.debug(p_message=>'validate_bank_site (-)',
1637: p_prefix=>l_debug_prefix,
1638: p_msg_level=>fnd_log.level_procedure);
1639: END IF;

Line 1638: p_msg_level=>fnd_log.level_procedure);

1634: -- Debug info.
1635: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1636: hz_utility_v2pub.debug(p_message=>'validate_bank_site (-)',
1637: p_prefix=>l_debug_prefix,
1638: p_msg_level=>fnd_log.level_procedure);
1639: END IF;
1640: END validate_bank_site;
1641:
1642: /*=======================================================================+

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

1669: l_orowid VARCHAR2(60);
1670: l_debug_prefix VARCHAR2(30);
1671: BEGIN
1672: -- Debug info.
1673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1674: hz_utility_v2pub.debug(p_message=>'update_bank_organization (+)',
1675: p_prefix=>l_debug_prefix,
1676: p_msg_level=>fnd_log.level_procedure);
1677: END IF;

Line 1676: p_msg_level=>fnd_log.level_procedure);

1672: -- Debug info.
1673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1674: hz_utility_v2pub.debug(p_message=>'update_bank_organization (+)',
1675: p_prefix=>l_debug_prefix,
1676: p_msg_level=>fnd_log.level_procedure);
1677: END IF;
1678: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1679: hz_utility_v2pub.debug(p_message=>'bank/branch number='||p_bank_or_branch_number,
1680: p_prefix =>l_debug_prefix,

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

1674: hz_utility_v2pub.debug(p_message=>'update_bank_organization (+)',
1675: p_prefix=>l_debug_prefix,
1676: p_msg_level=>fnd_log.level_procedure);
1677: END IF;
1678: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1679: hz_utility_v2pub.debug(p_message=>'bank/branch number='||p_bank_or_branch_number,
1680: p_prefix =>l_debug_prefix,
1681: p_msg_level=>fnd_log.level_statement);
1682: hz_utility_v2pub.debug(p_message=>'bank code='||p_bank_code,

Line 1681: p_msg_level=>fnd_log.level_statement);

1677: END IF;
1678: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1679: hz_utility_v2pub.debug(p_message=>'bank/branch number='||p_bank_or_branch_number,
1680: p_prefix =>l_debug_prefix,
1681: p_msg_level=>fnd_log.level_statement);
1682: hz_utility_v2pub.debug(p_message=>'bank code='||p_bank_code,
1683: p_prefix =>l_debug_prefix,
1684: p_msg_level=>fnd_log.level_statement);
1685: hz_utility_v2pub.debug(p_message=>'branch code='||p_branch_code,

Line 1684: p_msg_level=>fnd_log.level_statement);

1680: p_prefix =>l_debug_prefix,
1681: p_msg_level=>fnd_log.level_statement);
1682: hz_utility_v2pub.debug(p_message=>'bank code='||p_bank_code,
1683: p_prefix =>l_debug_prefix,
1684: p_msg_level=>fnd_log.level_statement);
1685: hz_utility_v2pub.debug(p_message=>'branch code='||p_branch_code,
1686: p_prefix =>l_debug_prefix,
1687: p_msg_level=>fnd_log.level_statement);
1688: END IF;

Line 1687: p_msg_level=>fnd_log.level_statement);

1683: p_prefix =>l_debug_prefix,
1684: p_msg_level=>fnd_log.level_statement);
1685: hz_utility_v2pub.debug(p_message=>'branch code='||p_branch_code,
1686: p_prefix =>l_debug_prefix,
1687: p_msg_level=>fnd_log.level_statement);
1688: END IF;
1689:
1690: OPEN c_orgprof;
1691: FETCH c_orgprof INTO l_orowid;

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

1695: END IF;
1696: CLOSE c_orgprof;
1697:
1698: -- Debug info.
1699: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1700: hz_utility_v2pub.debug(p_message=>'org rowid='||l_orowid,
1701: p_prefix =>l_debug_prefix,
1702: p_msg_level=>fnd_log.level_statement);
1703: END IF;

Line 1702: p_msg_level=>fnd_log.level_statement);

1698: -- Debug info.
1699: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1700: hz_utility_v2pub.debug(p_message=>'org rowid='||l_orowid,
1701: p_prefix =>l_debug_prefix,
1702: p_msg_level=>fnd_log.level_statement);
1703: END IF;
1704:
1705: hz_organization_profiles_pkg.update_row(
1706: x_rowid => l_orowid,

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

1852: x_home_country => NULL
1853: );
1854:
1855: -- Debug info.
1856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1857: hz_utility_v2pub.debug(p_message=>'update_bank_organization (-)',
1858: p_prefix=>l_debug_prefix,
1859: p_msg_level=>fnd_log.level_procedure);
1860: END IF;

Line 1859: p_msg_level=>fnd_log.level_procedure);

1855: -- Debug info.
1856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1857: hz_utility_v2pub.debug(p_message=>'update_bank_organization (-)',
1858: p_prefix=>l_debug_prefix,
1859: p_msg_level=>fnd_log.level_procedure);
1860: END IF;
1861: END update_bank_organization;
1862:
1863: /*=======================================================================+

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

1993: l_rel_party_version_number NUMBER;
1994: l_debug_prefix VARCHAR2(30) := '';
1995: BEGIN
1996: -- Debug info.
1997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1998: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (+)',
1999: p_prefix=>l_debug_prefix,
2000: p_msg_level=>fnd_log.level_procedure);
2001: END IF;

Line 2000: p_msg_level=>fnd_log.level_procedure);

1996: -- Debug info.
1997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1998: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (+)',
1999: p_prefix=>l_debug_prefix,
2000: p_msg_level=>fnd_log.level_procedure);
2001: END IF;
2002:
2003: -- If either the subject or object is null, then this record is being
2004: -- deactivated. Get the appropriate subject and/or object and set the

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

2016: fnd_msg_pub.add;
2017: x_return_status := fnd_api.g_ret_sts_error;
2018:
2019: -- Debug info.
2020: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2021: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (-)',
2022: p_prefix=>l_debug_prefix,
2023: p_msg_level=>fnd_log.level_procedure);
2024: END IF;

Line 2023: p_msg_level=>fnd_log.level_procedure);

2019: -- Debug info.
2020: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2021: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (-)',
2022: p_prefix=>l_debug_prefix,
2023: p_msg_level=>fnd_log.level_procedure);
2024: END IF;
2025:
2026: -- no point going any further, this is an invalid record
2027: RETURN;

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

2086:
2087: -- finish execution if the relationship creation routine is unsuccessful
2088: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2089: -- Debug info.
2090: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2091: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (-)',
2092: p_prefix=>l_debug_prefix,
2093: p_msg_level=>fnd_log.level_procedure);
2094: END IF;

Line 2093: p_msg_level=>fnd_log.level_procedure);

2089: -- Debug info.
2090: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2091: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (-)',
2092: p_prefix=>l_debug_prefix,
2093: p_msg_level=>fnd_log.level_procedure);
2094: END IF;
2095: RETURN;
2096: END IF;
2097:

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

2121: x_msg_data => x_msg_data
2122: );
2123:
2124: -- Debug info.
2125: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2126: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (-)',
2127: p_prefix=>l_debug_prefix,
2128: p_msg_level=>fnd_log.level_procedure);
2129: END IF;

Line 2128: p_msg_level=>fnd_log.level_procedure);

2124: -- Debug info.
2125: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2126: hz_utility_v2pub.debug(p_message=>'update_bank_relationship (-)',
2127: p_prefix=>l_debug_prefix,
2128: p_msg_level=>fnd_log.level_procedure);
2129: END IF;
2130: END update_relationship;
2131:
2132: /*=======================================================================+

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

2159: l_code_assignment_id NUMBER(15);
2160: l_debug_prefix VARCHAR2(30) := '';
2161: BEGIN
2162: -- Debug info.
2163: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2164: hz_utility_v2pub.debug(p_message=>'create_code_assignment (+)',
2165: p_prefix=>l_debug_prefix,
2166: p_msg_level=>fnd_log.level_procedure);
2167: END IF;

Line 2166: p_msg_level=>fnd_log.level_procedure);

2162: -- Debug info.
2163: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2164: hz_utility_v2pub.debug(p_message=>'create_code_assignment (+)',
2165: p_prefix=>l_debug_prefix,
2166: p_msg_level=>fnd_log.level_procedure);
2167: END IF;
2168:
2169: -- set up the code assignment record.
2170: l_code_assignment_rec.code_assignment_id := NULL;

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

2188: x_code_assignment_id => x_code_assignment_id
2189: );
2190:
2191: -- Debug info.
2192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2193: hz_utility_v2pub.debug(p_message=>'create_code_assignment (-)',
2194: p_prefix=>l_debug_prefix,
2195: p_msg_level=>fnd_log.level_procedure);
2196: END IF;

Line 2195: p_msg_level=>fnd_log.level_procedure);

2191: -- Debug info.
2192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2193: hz_utility_v2pub.debug(p_message=>'create_code_assignment (-)',
2194: p_prefix=>l_debug_prefix,
2195: p_msg_level=>fnd_log.level_procedure);
2196: END IF;
2197: END create_code_assignment;
2198:
2199: /*=======================================================================+

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

2265: p_bank_organization_type = hca.class_code);
2266:
2267: BEGIN
2268:
2269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2270: hz_utility_v2pub.debug(p_message=>'update_code_assignment (+)',
2271: p_prefix=>l_debug_prefix,
2272: p_msg_level=>fnd_log.level_procedure);
2273: END IF;

Line 2272: p_msg_level=>fnd_log.level_procedure);

2268:
2269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2270: hz_utility_v2pub.debug(p_message=>'update_code_assignment (+)',
2271: p_prefix=>l_debug_prefix,
2272: p_msg_level=>fnd_log.level_procedure);
2273: END IF;
2274:
2275: -- update existing assignment
2276: OPEN c_assignid2;

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

2365: END IF;
2366: END IF;
2367: CLOSE c_assignid2;
2368:
2369: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2370: hz_utility_v2pub.debug(p_message=>'update_code_assignment (-)',
2371: p_prefix=>l_debug_prefix,
2372: p_msg_level=>fnd_log.level_procedure);
2373: END IF;

Line 2372: p_msg_level=>fnd_log.level_procedure);

2368:
2369: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2370: hz_utility_v2pub.debug(p_message=>'update_code_assignment (-)',
2371: p_prefix=>l_debug_prefix,
2372: p_msg_level=>fnd_log.level_procedure);
2373: END IF;
2374: END update_code_assignment;
2375:
2376:

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

2554: -- Check if API is called in debug mode. If yes, enable debug.
2555: --enable_debug;
2556:
2557: -- Debug info.
2558: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2559: hz_utility_v2pub.debug(p_message=>'create_bank (+)',
2560: p_prefix=>l_debug_prefix,
2561: p_msg_level=>fnd_log.level_procedure);
2562: END IF;

Line 2561: p_msg_level=>fnd_log.level_procedure);

2557: -- Debug info.
2558: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2559: hz_utility_v2pub.debug(p_message=>'create_bank (+)',
2560: p_prefix=>l_debug_prefix,
2561: p_msg_level=>fnd_log.level_procedure);
2562: END IF;
2563:
2564: -- initialize message list if p_init_msg_list is set to TRUE.
2565: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

2648: p_count => x_msg_count,
2649: p_data => x_msg_data);
2650:
2651: -- Debug info.
2652: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2653: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2654: p_msg_data=>x_msg_data,
2655: p_msg_type=>'WARNING',
2656: p_msg_level=>fnd_log.level_exception);

Line 2656: p_msg_level=>fnd_log.level_exception);

2652: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2653: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2654: p_msg_data=>x_msg_data,
2655: p_msg_type=>'WARNING',
2656: p_msg_level=>fnd_log.level_exception);
2657: END IF;
2658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2659: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2660: p_prefix=>l_debug_prefix,

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

2654: p_msg_data=>x_msg_data,
2655: p_msg_type=>'WARNING',
2656: p_msg_level=>fnd_log.level_exception);
2657: END IF;
2658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2659: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2660: p_prefix=>l_debug_prefix,
2661: p_msg_level=>fnd_log.level_procedure);
2662: END IF;

Line 2661: p_msg_level=>fnd_log.level_procedure);

2657: END IF;
2658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2659: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2660: p_prefix=>l_debug_prefix,
2661: p_msg_level=>fnd_log.level_procedure);
2662: END IF;
2663:
2664: -- Check if API is called in debug mode. If yes, disable debug.
2665: --disable_debug;

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

2672: p_count => x_msg_count,
2673: p_data => x_msg_data);
2674:
2675: -- Debug info.
2676: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2677: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2678: p_msg_data=>x_msg_data,
2679: p_msg_type=>'ERROR',
2680: p_msg_level=>fnd_log.level_error);

Line 2680: p_msg_level=>fnd_log.level_error);

2676: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2677: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2678: p_msg_data=>x_msg_data,
2679: p_msg_type=>'ERROR',
2680: p_msg_level=>fnd_log.level_error);
2681: END IF;
2682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2683: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2684: p_prefix=>l_debug_prefix,

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

2678: p_msg_data=>x_msg_data,
2679: p_msg_type=>'ERROR',
2680: p_msg_level=>fnd_log.level_error);
2681: END IF;
2682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2683: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2684: p_prefix=>l_debug_prefix,
2685: p_msg_level=>fnd_log.level_procedure);
2686: END IF;

Line 2685: p_msg_level=>fnd_log.level_procedure);

2681: END IF;
2682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2683: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2684: p_prefix=>l_debug_prefix,
2685: p_msg_level=>fnd_log.level_procedure);
2686: END IF;
2687:
2688: -- Check if API is called in debug mode. If yes, disable debug.
2689: --disable_debug;

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

2695: p_count => x_msg_count,
2696: p_data => x_msg_data);
2697:
2698: -- Debug info.
2699: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2700: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2701: p_msg_data=>x_msg_data,
2702: p_msg_type=>'UNEXPECTED ERROR',
2703: p_msg_level=>fnd_log.level_error);

Line 2703: p_msg_level=>fnd_log.level_error);

2699: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2700: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2701: p_msg_data=>x_msg_data,
2702: p_msg_type=>'UNEXPECTED ERROR',
2703: p_msg_level=>fnd_log.level_error);
2704: END IF;
2705: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2706: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2707: p_prefix=>l_debug_prefix,

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

2701: p_msg_data=>x_msg_data,
2702: p_msg_type=>'UNEXPECTED ERROR',
2703: p_msg_level=>fnd_log.level_error);
2704: END IF;
2705: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2706: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2707: p_prefix=>l_debug_prefix,
2708: p_msg_level=>fnd_log.level_procedure);
2709: END IF;

Line 2708: p_msg_level=>fnd_log.level_procedure);

2704: END IF;
2705: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2706: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2707: p_prefix=>l_debug_prefix,
2708: p_msg_level=>fnd_log.level_procedure);
2709: END IF;
2710:
2711:
2712: -- Check if API is called in debug mode. If yes, disable debug.

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

2722: p_count => x_msg_count,
2723: p_data => x_msg_data);
2724:
2725: -- Debug info.
2726: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2727: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2728: p_msg_data=>x_msg_data,
2729: p_msg_type=>'SQL ERROR',
2730: p_msg_level=>fnd_log.level_error);

Line 2730: p_msg_level=>fnd_log.level_error);

2726: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2727: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2728: p_msg_data=>x_msg_data,
2729: p_msg_type=>'SQL ERROR',
2730: p_msg_level=>fnd_log.level_error);
2731: END IF;
2732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2733: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2734: p_prefix=>l_debug_prefix,

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

2728: p_msg_data=>x_msg_data,
2729: p_msg_type=>'SQL ERROR',
2730: p_msg_level=>fnd_log.level_error);
2731: END IF;
2732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2733: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2734: p_prefix=>l_debug_prefix,
2735: p_msg_level=>fnd_log.level_procedure);
2736: END IF;

Line 2735: p_msg_level=>fnd_log.level_procedure);

2731: END IF;
2732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2733: hz_utility_v2pub.debug(p_message=>'create_bank (-)',
2734: p_prefix=>l_debug_prefix,
2735: p_msg_level=>fnd_log.level_procedure);
2736: END IF;
2737:
2738: -- Check if API is called in debug mode. If yes, disable debug.
2739: --disable_debug;

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

2804: -- Check if API is called in debug mode. If yes, enable debug.
2805: --enable_debug;
2806:
2807: -- Debug info.
2808: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2809: hz_utility_v2pub.debug(p_message=>'update_bank (+)',
2810: p_prefix=>l_debug_prefix,
2811: p_msg_level=>fnd_log.level_procedure);
2812: END IF;

Line 2811: p_msg_level=>fnd_log.level_procedure);

2807: -- Debug info.
2808: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2809: hz_utility_v2pub.debug(p_message=>'update_bank (+)',
2810: p_prefix=>l_debug_prefix,
2811: p_msg_level=>fnd_log.level_procedure);
2812: END IF;
2813:
2814: -- initialize message list if p_init_msg_list is set to TRUE.
2815: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

2894: p_count => x_msg_count,
2895: p_data => x_msg_data);
2896:
2897: -- Debug info.
2898: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2899: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2900: p_msg_data=>x_msg_data,
2901: p_msg_type=>'WARNING',
2902: p_msg_level=>fnd_log.level_exception);

Line 2902: p_msg_level=>fnd_log.level_exception);

2898: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2899: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2900: p_msg_data=>x_msg_data,
2901: p_msg_type=>'WARNING',
2902: p_msg_level=>fnd_log.level_exception);
2903: END IF;
2904: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2905: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2906: p_prefix=>l_debug_prefix,

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

2900: p_msg_data=>x_msg_data,
2901: p_msg_type=>'WARNING',
2902: p_msg_level=>fnd_log.level_exception);
2903: END IF;
2904: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2905: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2906: p_prefix=>l_debug_prefix,
2907: p_msg_level=>fnd_log.level_procedure);
2908: END IF;

Line 2907: p_msg_level=>fnd_log.level_procedure);

2903: END IF;
2904: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2905: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2906: p_prefix=>l_debug_prefix,
2907: p_msg_level=>fnd_log.level_procedure);
2908: END IF;
2909:
2910: -- Check if API is called in debug mode. If yes, disable debug.
2911: --disable_debug;

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

2918: p_count => x_msg_count,
2919: p_data => x_msg_data);
2920:
2921: -- Debug info.
2922: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2923: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2924: p_msg_data=>x_msg_data,
2925: p_msg_type=>'ERROR',
2926: p_msg_level=>fnd_log.level_error);

Line 2926: p_msg_level=>fnd_log.level_error);

2922: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2923: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2924: p_msg_data=>x_msg_data,
2925: p_msg_type=>'ERROR',
2926: p_msg_level=>fnd_log.level_error);
2927: END IF;
2928: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2929: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2930: p_prefix=>l_debug_prefix,

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

2924: p_msg_data=>x_msg_data,
2925: p_msg_type=>'ERROR',
2926: p_msg_level=>fnd_log.level_error);
2927: END IF;
2928: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2929: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2930: p_prefix=>l_debug_prefix,
2931: p_msg_level=>fnd_log.level_procedure);
2932: END IF;

Line 2931: p_msg_level=>fnd_log.level_procedure);

2927: END IF;
2928: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2929: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2930: p_prefix=>l_debug_prefix,
2931: p_msg_level=>fnd_log.level_procedure);
2932: END IF;
2933:
2934: -- Check if API is called in debug mode. If yes, disable debug.
2935: --disable_debug;

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

2941: p_count => x_msg_count,
2942: p_data => x_msg_data);
2943:
2944: -- Debug info.
2945: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2946: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2947: p_msg_data=>x_msg_data,
2948: p_msg_type=>'UNEXPECTED ERROR',
2949: p_msg_level=>fnd_log.level_error);

Line 2949: p_msg_level=>fnd_log.level_error);

2945: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2946: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2947: p_msg_data=>x_msg_data,
2948: p_msg_type=>'UNEXPECTED ERROR',
2949: p_msg_level=>fnd_log.level_error);
2950: END IF;
2951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2952: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2953: p_prefix=>l_debug_prefix,

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

2947: p_msg_data=>x_msg_data,
2948: p_msg_type=>'UNEXPECTED ERROR',
2949: p_msg_level=>fnd_log.level_error);
2950: END IF;
2951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2952: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2953: p_prefix=>l_debug_prefix,
2954: p_msg_level=>fnd_log.level_procedure);
2955: END IF;

Line 2954: p_msg_level=>fnd_log.level_procedure);

2950: END IF;
2951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2952: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2953: p_prefix=>l_debug_prefix,
2954: p_msg_level=>fnd_log.level_procedure);
2955: END IF;
2956:
2957: -- Check if API is called in debug mode. If yes, disable debug.
2958: --disable_debug;

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

2967: p_count => x_msg_count,
2968: p_data => x_msg_data);
2969:
2970: -- Debug info.
2971: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2972: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2973: p_msg_data=>x_msg_data,
2974: p_msg_type=>'SQL ERROR',
2975: p_msg_level=>fnd_log.level_error);

Line 2975: p_msg_level=>fnd_log.level_error);

2971: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2972: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2973: p_msg_data=>x_msg_data,
2974: p_msg_type=>'SQL ERROR',
2975: p_msg_level=>fnd_log.level_error);
2976: END IF;
2977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2978: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2979: p_prefix=>l_debug_prefix,

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

2973: p_msg_data=>x_msg_data,
2974: p_msg_type=>'SQL ERROR',
2975: p_msg_level=>fnd_log.level_error);
2976: END IF;
2977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2978: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2979: p_prefix=>l_debug_prefix,
2980: p_msg_level=>fnd_log.level_procedure);
2981: END IF;

Line 2980: p_msg_level=>fnd_log.level_procedure);

2976: END IF;
2977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2978: hz_utility_v2pub.debug(p_message=>'update_bank (-)',
2979: p_prefix=>l_debug_prefix,
2980: p_msg_level=>fnd_log.level_procedure);
2981: END IF;
2982:
2983: -- Check if API is called in debug mode. If yes, disable debug.
2984: --disable_debug;

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

3054: -- Check if API is called in debug mode. If yes, enable debug.
3055: --enable_debug;
3056:
3057: -- Debug info.
3058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3059: hz_utility_v2pub.debug(p_message=>'create_bank_branch (+)',
3060: p_prefix=>l_debug_prefix,
3061: p_msg_level=>fnd_log.level_procedure);
3062: END IF;

Line 3061: p_msg_level=>fnd_log.level_procedure);

3057: -- Debug info.
3058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3059: hz_utility_v2pub.debug(p_message=>'create_bank_branch (+)',
3060: p_prefix=>l_debug_prefix,
3061: p_msg_level=>fnd_log.level_procedure);
3062: END IF;
3063:
3064: -- initialize message list if p_init_msg_list is set to TRUE.
3065: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

3211: p_count => x_msg_count,
3212: p_data => x_msg_data);
3213:
3214: -- Debug info.
3215: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3216: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3217: p_msg_data=>x_msg_data,
3218: p_msg_type=>'WARNING',
3219: p_msg_level=>fnd_log.level_exception);

Line 3219: p_msg_level=>fnd_log.level_exception);

3215: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3216: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3217: p_msg_data=>x_msg_data,
3218: p_msg_type=>'WARNING',
3219: p_msg_level=>fnd_log.level_exception);
3220: END IF;
3221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3222: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3223: p_prefix=>l_debug_prefix,

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

3217: p_msg_data=>x_msg_data,
3218: p_msg_type=>'WARNING',
3219: p_msg_level=>fnd_log.level_exception);
3220: END IF;
3221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3222: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3223: p_prefix=>l_debug_prefix,
3224: p_msg_level=>fnd_log.level_procedure);
3225: END IF;

Line 3224: p_msg_level=>fnd_log.level_procedure);

3220: END IF;
3221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3222: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3223: p_prefix=>l_debug_prefix,
3224: p_msg_level=>fnd_log.level_procedure);
3225: END IF;
3226:
3227: -- Check if API is called in debug mode. If yes, disable debug.
3228: --disable_debug;

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

3235: p_count => x_msg_count,
3236: p_data => x_msg_data);
3237:
3238: -- Debug info.
3239: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3240: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3241: p_msg_data=>x_msg_data,
3242: p_msg_type=>'ERROR',
3243: p_msg_level=>fnd_log.level_error);

Line 3243: p_msg_level=>fnd_log.level_error);

3239: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3240: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3241: p_msg_data=>x_msg_data,
3242: p_msg_type=>'ERROR',
3243: p_msg_level=>fnd_log.level_error);
3244: END IF;
3245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3246: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3247: p_prefix=>l_debug_prefix,

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

3241: p_msg_data=>x_msg_data,
3242: p_msg_type=>'ERROR',
3243: p_msg_level=>fnd_log.level_error);
3244: END IF;
3245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3246: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3247: p_prefix=>l_debug_prefix,
3248: p_msg_level=>fnd_log.level_procedure);
3249: END IF;

Line 3248: p_msg_level=>fnd_log.level_procedure);

3244: END IF;
3245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3246: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3247: p_prefix=>l_debug_prefix,
3248: p_msg_level=>fnd_log.level_procedure);
3249: END IF;
3250:
3251: -- Check if API is called in debug mode. If yes, disable debug.
3252: --disable_debug;

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

3258: p_count => x_msg_count,
3259: p_data => x_msg_data);
3260:
3261: -- Debug info.
3262: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3263: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3264: p_msg_data=>x_msg_data,
3265: p_msg_type=>'UNEXPECTED ERROR',
3266: p_msg_level=>fnd_log.level_error);

Line 3266: p_msg_level=>fnd_log.level_error);

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

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

3264: p_msg_data=>x_msg_data,
3265: p_msg_type=>'UNEXPECTED ERROR',
3266: p_msg_level=>fnd_log.level_error);
3267: END IF;
3268: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3269: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3270: p_prefix=>l_debug_prefix,
3271: p_msg_level=>fnd_log.level_procedure);
3272: END IF;

Line 3271: p_msg_level=>fnd_log.level_procedure);

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

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

3284: p_count => x_msg_count,
3285: p_data => x_msg_data);
3286:
3287: -- Debug info.
3288: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3289: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3290: p_msg_data=>x_msg_data,
3291: p_msg_type=>'SQL ERROR',
3292: p_msg_level=>fnd_log.level_error);

Line 3292: p_msg_level=>fnd_log.level_error);

3288: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3289: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3290: p_msg_data=>x_msg_data,
3291: p_msg_type=>'SQL ERROR',
3292: p_msg_level=>fnd_log.level_error);
3293: END IF;
3294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3295: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3296: p_prefix=>l_debug_prefix,

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

3290: p_msg_data=>x_msg_data,
3291: p_msg_type=>'SQL ERROR',
3292: p_msg_level=>fnd_log.level_error);
3293: END IF;
3294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3295: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3296: p_prefix=>l_debug_prefix,
3297: p_msg_level=>fnd_log.level_procedure);
3298: END IF;

Line 3297: p_msg_level=>fnd_log.level_procedure);

3293: END IF;
3294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3295: hz_utility_v2pub.debug(p_message=>'create_bank_branch (-)',
3296: p_prefix=>l_debug_prefix,
3297: p_msg_level=>fnd_log.level_procedure);
3298: END IF;
3299:
3300: -- Check if API is called in debug mode. If yes, disable debug.
3301: --disable_debug;

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

3373: -- Check if API is called in debug mode. If yes, enable debug.
3374: --enable_debug;
3375:
3376: -- Debug info.
3377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3378: hz_utility_v2pub.debug(p_message=>'update_bank_branch (+)',
3379: p_prefix=>l_debug_prefix,
3380: p_msg_level=>fnd_log.level_procedure);
3381: END IF;

Line 3380: p_msg_level=>fnd_log.level_procedure);

3376: -- Debug info.
3377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3378: hz_utility_v2pub.debug(p_message=>'update_bank_branch (+)',
3379: p_prefix=>l_debug_prefix,
3380: p_msg_level=>fnd_log.level_procedure);
3381: END IF;
3382:
3383: -- initialize message list if p_init_msg_list is set to TRUE.
3384: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

3541: p_count => x_msg_count,
3542: p_data => x_msg_data);
3543:
3544: -- Debug info.
3545: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3546: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3547: p_msg_data=>x_msg_data,
3548: p_msg_type=>'WARNING',
3549: p_msg_level=>fnd_log.level_exception);

Line 3549: p_msg_level=>fnd_log.level_exception);

3545: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3546: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3547: p_msg_data=>x_msg_data,
3548: p_msg_type=>'WARNING',
3549: p_msg_level=>fnd_log.level_exception);
3550: END IF;
3551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3552: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3553: p_prefix=>l_debug_prefix,

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

3547: p_msg_data=>x_msg_data,
3548: p_msg_type=>'WARNING',
3549: p_msg_level=>fnd_log.level_exception);
3550: END IF;
3551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3552: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3553: p_prefix=>l_debug_prefix,
3554: p_msg_level=>fnd_log.level_procedure);
3555: END IF;

Line 3554: p_msg_level=>fnd_log.level_procedure);

3550: END IF;
3551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3552: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3553: p_prefix=>l_debug_prefix,
3554: p_msg_level=>fnd_log.level_procedure);
3555: END IF;
3556:
3557: -- Check if API is called in debug mode. If yes, disable debug.
3558: --disable_debug;

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

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

Line 3573: p_msg_level=>fnd_log.level_error);

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

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

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

Line 3578: p_msg_level=>fnd_log.level_procedure);

3574: END IF;
3575: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3576: hz_utility_v2pub.debug(p_message=>'update_bank_branch (-)',
3577: p_prefix=>l_debug_prefix,
3578: p_msg_level=>fnd_log.level_procedure);
3579: END IF;
3580:
3581: -- Check if API is called in debug mode. If yes, disable debug.
3582: --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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 3618: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 3622: p_msg_level=>fnd_log.level_error);

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

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

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

Line 3627: p_msg_level=>fnd_log.level_procedure);

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

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

3677: -- Check if API is called in debug mode. If yes, enable debug.
3678: --enable_debug;
3679:
3680: -- Debug info.
3681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3682: hz_utility_v2pub.debug(p_message=>'create_banking_group (+)',
3683: p_prefix=>l_debug_prefix,
3684: p_msg_level=>fnd_log.level_procedure);
3685: END IF;

Line 3684: p_msg_level=>fnd_log.level_procedure);

3680: -- Debug info.
3681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3682: hz_utility_v2pub.debug(p_message=>'create_banking_group (+)',
3683: p_prefix=>l_debug_prefix,
3684: p_msg_level=>fnd_log.level_procedure);
3685: END IF;
3686:
3687: -- initialize API return status to success.
3688: x_return_status := fnd_api.g_ret_sts_success;

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

3714: RAISE fnd_api.g_exc_error;
3715: END IF;
3716:
3717: -- Debug info.
3718: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3719: hz_utility_v2pub.debug(p_message=>'create_banking_group (-)',
3720: p_prefix=>l_debug_prefix,
3721: p_msg_level=>fnd_log.level_procedure);
3722: END IF;

Line 3721: p_msg_level=>fnd_log.level_procedure);

3717: -- Debug info.
3718: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3719: hz_utility_v2pub.debug(p_message=>'create_banking_group (-)',
3720: p_prefix=>l_debug_prefix,
3721: p_msg_level=>fnd_log.level_procedure);
3722: END IF;
3723:
3724: -- disable the debug procedure before exiting.
3725: --disable_debug;

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

3731: p_count => x_msg_count,
3732: p_data => x_msg_data);
3733:
3734: -- Debug info.
3735: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3736: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3737: p_msg_data=>x_msg_data,
3738: p_msg_type=>'ERROR',
3739: p_msg_level=>fnd_log.level_error);

Line 3739: p_msg_level=>fnd_log.level_error);

3735: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3736: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3737: p_msg_data=>x_msg_data,
3738: p_msg_type=>'ERROR',
3739: p_msg_level=>fnd_log.level_error);
3740: END IF;
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,

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

3737: p_msg_data=>x_msg_data,
3738: p_msg_type=>'ERROR',
3739: p_msg_level=>fnd_log.level_error);
3740: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 3784: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 3788: p_msg_level=>fnd_log.level_error);

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

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

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

Line 3793: p_msg_level=>fnd_log.level_procedure);

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

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

3842: -- Check if API is called in debug mode. If yes, enable debug.
3843: --enable_debug;
3844:
3845: -- Debug info.
3846: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3847: hz_utility_v2pub.debug(p_message=>'update_banking_group (+)',
3848: p_prefix=>l_debug_prefix,
3849: p_msg_level=>fnd_log.level_procedure);
3850: END IF;

Line 3849: p_msg_level=>fnd_log.level_procedure);

3845: -- Debug info.
3846: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3847: hz_utility_v2pub.debug(p_message=>'update_banking_group (+)',
3848: p_prefix=>l_debug_prefix,
3849: p_msg_level=>fnd_log.level_procedure);
3850: END IF;
3851:
3852: -- initialize API return status to success.
3853: x_return_status := fnd_api.g_ret_sts_success;

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

3878: RAISE fnd_api.g_exc_error;
3879: END IF;
3880:
3881: -- Debug info.
3882: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3883: hz_utility_v2pub.debug(p_message=>'update_banking_group (-)',
3884: p_prefix=>l_debug_prefix,
3885: p_msg_level=>fnd_log.level_procedure);
3886: END IF;

Line 3885: p_msg_level=>fnd_log.level_procedure);

3881: -- Debug info.
3882: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3883: hz_utility_v2pub.debug(p_message=>'update_banking_group (-)',
3884: p_prefix=>l_debug_prefix,
3885: p_msg_level=>fnd_log.level_procedure);
3886: END IF;
3887:
3888: -- disable the debug procedure before exiting.
3889: --disable_debug;

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

3895: p_count => x_msg_count,
3896: p_data => x_msg_data);
3897:
3898: -- Debug info.
3899: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3900: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3901: p_msg_data=>x_msg_data,
3902: p_msg_type=>'ERROR',
3903: p_msg_level=>fnd_log.level_error);

Line 3903: p_msg_level=>fnd_log.level_error);

3899: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3900: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3901: p_msg_data=>x_msg_data,
3902: p_msg_type=>'ERROR',
3903: p_msg_level=>fnd_log.level_error);
3904: END IF;
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,

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

3901: p_msg_data=>x_msg_data,
3902: p_msg_type=>'ERROR',
3903: p_msg_level=>fnd_log.level_error);
3904: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 3948: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 3952: p_msg_level=>fnd_log.level_error);

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

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

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

Line 3957: p_msg_level=>fnd_log.level_procedure);

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

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

4013: -- Check if API is called in debug mode. If yes, enable debug.
4014: --enable_debug;
4015:
4016: -- Debug info.
4017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4018: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (+)',
4019: p_prefix=>l_debug_prefix,
4020: p_msg_level=>fnd_log.level_procedure);
4021: END IF;

Line 4020: p_msg_level=>fnd_log.level_procedure);

4016: -- Debug info.
4017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4018: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (+)',
4019: p_prefix=>l_debug_prefix,
4020: p_msg_level=>fnd_log.level_procedure);
4021: END IF;
4022:
4023: -- initialize API return status to success.
4024: x_return_status := fnd_api.g_ret_sts_success;

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

4051: RAISE fnd_api.g_exc_error;
4052: END IF;
4053:
4054: -- Debug info.
4055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4056: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (-)',
4057: p_prefix=>l_debug_prefix,
4058: p_msg_level=>fnd_log.level_procedure);
4059: END IF;

Line 4058: p_msg_level=>fnd_log.level_procedure);

4054: -- Debug info.
4055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4056: hz_utility_v2pub.debug(p_message=>'create_bank_group_member (-)',
4057: p_prefix=>l_debug_prefix,
4058: p_msg_level=>fnd_log.level_procedure);
4059: END IF;
4060:
4061: -- disable the debug procedure before exiting.
4062: --disable_debug;

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

4068: p_count => x_msg_count,
4069: p_data => x_msg_data);
4070:
4071: -- Debug info.
4072: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4073: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4074: p_msg_data=>x_msg_data,
4075: p_msg_type=>'ERROR',
4076: p_msg_level=>fnd_log.level_error);

Line 4076: p_msg_level=>fnd_log.level_error);

4072: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4073: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4074: p_msg_data=>x_msg_data,
4075: p_msg_type=>'ERROR',
4076: p_msg_level=>fnd_log.level_error);
4077: END IF;
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,

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

4074: p_msg_data=>x_msg_data,
4075: p_msg_type=>'ERROR',
4076: p_msg_level=>fnd_log.level_error);
4077: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 4121: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 4125: p_msg_level=>fnd_log.level_error);

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

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

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

Line 4130: p_msg_level=>fnd_log.level_procedure);

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

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

4184: -- Check if API is called in debug mode. If yes, enable debug.
4185: --enable_debug;
4186:
4187: -- Debug info.
4188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4189: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (+)',
4190: p_prefix=>l_debug_prefix,
4191: p_msg_level=>fnd_log.level_procedure);
4192: END IF;

Line 4191: p_msg_level=>fnd_log.level_procedure);

4187: -- Debug info.
4188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4189: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (+)',
4190: p_prefix=>l_debug_prefix,
4191: p_msg_level=>fnd_log.level_procedure);
4192: END IF;
4193:
4194: -- initialize API return status to success.
4195: x_return_status := fnd_api.g_ret_sts_success;

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

4221: RAISE fnd_api.g_exc_error;
4222: END IF;
4223:
4224: -- Debug info.
4225: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4226: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (-)',
4227: p_prefix=>l_debug_prefix,
4228: p_msg_level=>fnd_log.level_procedure);
4229: END IF;

Line 4228: p_msg_level=>fnd_log.level_procedure);

4224: -- Debug info.
4225: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4226: hz_utility_v2pub.debug(p_message=>'update_bank_group_member (-)',
4227: p_prefix=>l_debug_prefix,
4228: p_msg_level=>fnd_log.level_procedure);
4229: END IF;
4230:
4231: -- disable the debug procedure before exiting.
4232: --disable_debug;

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

4238: p_count => x_msg_count,
4239: p_data => x_msg_data);
4240:
4241: -- Debug info.
4242: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4243: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4244: p_msg_data=>x_msg_data,
4245: p_msg_type=>'ERROR',
4246: p_msg_level=>fnd_log.level_error);

Line 4246: p_msg_level=>fnd_log.level_error);

4242: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4243: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4244: p_msg_data=>x_msg_data,
4245: p_msg_type=>'ERROR',
4246: p_msg_level=>fnd_log.level_error);
4247: END IF;
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,

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

4244: p_msg_data=>x_msg_data,
4245: p_msg_type=>'ERROR',
4246: p_msg_level=>fnd_log.level_error);
4247: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 4291: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 4295: p_msg_level=>fnd_log.level_error);

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

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

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

Line 4300: p_msg_level=>fnd_log.level_procedure);

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

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

4355: -- Check if API is called in debug mode. If yes, enable debug.
4356: --enable_debug;
4357:
4358: -- Debug info.
4359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4360: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (+)',
4361: p_prefix=>l_debug_prefix,
4362: p_msg_level=>fnd_log.level_procedure);
4363: END IF;

Line 4362: p_msg_level=>fnd_log.level_procedure);

4358: -- Debug info.
4359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4360: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (+)',
4361: p_prefix=>l_debug_prefix,
4362: p_msg_level=>fnd_log.level_procedure);
4363: END IF;
4364:
4365: -- initialize API return status to success.
4366: x_return_status := fnd_api.g_ret_sts_success;

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

4395: RAISE fnd_api.g_exc_error;
4396: END IF;
4397:
4398: -- Debug info.
4399: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4400: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (-)',
4401: p_prefix=>l_debug_prefix,
4402: p_msg_level=>fnd_log.level_procedure);
4403: END IF;

Line 4402: p_msg_level=>fnd_log.level_procedure);

4398: -- Debug info.
4399: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4400: hz_utility_v2pub.debug(p_message=>'create_clearinghouse_assign (-)',
4401: p_prefix=>l_debug_prefix,
4402: p_msg_level=>fnd_log.level_procedure);
4403: END IF;
4404:
4405: -- disable the debug procedure before exiting.
4406: --disable_debug;

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

4412: p_count => x_msg_count,
4413: p_data => x_msg_data);
4414:
4415: -- Debug info.
4416: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4417: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4418: p_msg_data=>x_msg_data,
4419: p_msg_type=>'ERROR',
4420: p_msg_level=>fnd_log.level_error);

Line 4420: p_msg_level=>fnd_log.level_error);

4416: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4417: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4418: p_msg_data=>x_msg_data,
4419: p_msg_type=>'ERROR',
4420: p_msg_level=>fnd_log.level_error);
4421: END IF;
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,

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

4418: p_msg_data=>x_msg_data,
4419: p_msg_type=>'ERROR',
4420: p_msg_level=>fnd_log.level_error);
4421: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 4465: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 4469: p_msg_level=>fnd_log.level_error);

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

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

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

Line 4474: p_msg_level=>fnd_log.level_procedure);

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

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

4527: -- Check if API is called in debug mode. If yes, enable debug.
4528: --enable_debug;
4529:
4530: -- Debug info.
4531: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4532: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (+)',
4533: p_prefix=>l_debug_prefix,
4534: p_msg_level=>fnd_log.level_procedure);
4535: END IF;

Line 4534: p_msg_level=>fnd_log.level_procedure);

4530: -- Debug info.
4531: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4532: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (+)',
4533: p_prefix=>l_debug_prefix,
4534: p_msg_level=>fnd_log.level_procedure);
4535: END IF;
4536:
4537: -- initialize API return status to success.
4538: x_return_status := fnd_api.g_ret_sts_success;

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

4566: RAISE fnd_api.g_exc_error;
4567: END IF;
4568:
4569: -- Debug info.
4570: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4571: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (-)',
4572: p_prefix=>l_debug_prefix,
4573: p_msg_level=>fnd_log.level_procedure);
4574: END IF;

Line 4573: p_msg_level=>fnd_log.level_procedure);

4569: -- Debug info.
4570: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4571: hz_utility_v2pub.debug(p_message=>'update_clearinghouse_assign (-)',
4572: p_prefix=>l_debug_prefix,
4573: p_msg_level=>fnd_log.level_procedure);
4574: END IF;
4575:
4576: -- disable the debug procedure before exiting.
4577: --disable_debug;

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

4583: p_count => x_msg_count,
4584: p_data => x_msg_data);
4585:
4586: -- Debug info.
4587: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4588: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4589: p_msg_data=>x_msg_data,
4590: p_msg_type=>'ERROR',
4591: p_msg_level=>fnd_log.level_error);

Line 4591: p_msg_level=>fnd_log.level_error);

4587: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4588: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4589: p_msg_data=>x_msg_data,
4590: p_msg_type=>'ERROR',
4591: p_msg_level=>fnd_log.level_error);
4592: END IF;
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,

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

4589: p_msg_data=>x_msg_data,
4590: p_msg_type=>'ERROR',
4591: p_msg_level=>fnd_log.level_error);
4592: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 4636: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 4640: p_msg_level=>fnd_log.level_error);

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

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

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

Line 4645: p_msg_level=>fnd_log.level_procedure);

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

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

4696: -- Check if API is called in debug mode. If yes, enable debug.
4697: --enable_debug;
4698:
4699: -- Debug info.
4700: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4701: hz_utility_v2pub.debug(p_message=>'create_bank_site (+)',
4702: p_prefix=>l_debug_prefix,
4703: p_msg_level=>fnd_log.level_procedure);
4704: END IF;

Line 4703: p_msg_level=>fnd_log.level_procedure);

4699: -- Debug info.
4700: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4701: hz_utility_v2pub.debug(p_message=>'create_bank_site (+)',
4702: p_prefix=>l_debug_prefix,
4703: p_msg_level=>fnd_log.level_procedure);
4704: END IF;
4705:
4706: -- initialize API return status to success.
4707: x_return_status := fnd_api.g_ret_sts_success;

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

4733: RAISE fnd_api.g_exc_error;
4734: END IF;
4735:
4736: -- Debug info.
4737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4738: hz_utility_v2pub.debug(p_message=>'create_bank_site (-)',
4739: p_prefix=>l_debug_prefix,
4740: p_msg_level=>fnd_log.level_procedure);
4741: END IF;

Line 4740: p_msg_level=>fnd_log.level_procedure);

4736: -- Debug info.
4737: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4738: hz_utility_v2pub.debug(p_message=>'create_bank_site (-)',
4739: p_prefix=>l_debug_prefix,
4740: p_msg_level=>fnd_log.level_procedure);
4741: END IF;
4742:
4743: -- disable the debug procedure before exiting.
4744: --disable_debug;

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

4750: p_count => x_msg_count,
4751: p_data => x_msg_data);
4752:
4753: -- Debug info.
4754: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4755: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4756: p_msg_data=>x_msg_data,
4757: p_msg_type=>'ERROR',
4758: p_msg_level=>fnd_log.level_error);

Line 4758: p_msg_level=>fnd_log.level_error);

4754: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4755: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4756: p_msg_data=>x_msg_data,
4757: p_msg_type=>'ERROR',
4758: p_msg_level=>fnd_log.level_error);
4759: END IF;
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,

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

4756: p_msg_data=>x_msg_data,
4757: p_msg_type=>'ERROR',
4758: p_msg_level=>fnd_log.level_error);
4759: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 4803: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 4807: p_msg_level=>fnd_log.level_error);

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

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

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

Line 4812: p_msg_level=>fnd_log.level_procedure);

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

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

4861: -- Check if API is called in debug mode. If yes, enable debug.
4862: --enable_debug;
4863:
4864: -- Debug info.
4865: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4866: hz_utility_v2pub.debug(p_message=>'update_bank_site (+)',
4867: p_prefix=>l_debug_prefix,
4868: p_msg_level=>fnd_log.level_procedure);
4869: END IF;

Line 4868: p_msg_level=>fnd_log.level_procedure);

4864: -- Debug info.
4865: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4866: hz_utility_v2pub.debug(p_message=>'update_bank_site (+)',
4867: p_prefix=>l_debug_prefix,
4868: p_msg_level=>fnd_log.level_procedure);
4869: END IF;
4870:
4871: -- initialize API return status to success.
4872: x_return_status := fnd_api.g_ret_sts_success;

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

4897: RAISE fnd_api.g_exc_error;
4898: END IF;
4899:
4900: -- Debug info.
4901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4902: hz_utility_v2pub.debug(p_message=>'update_bank_site (-)',
4903: p_prefix=>l_debug_prefix,
4904: p_msg_level=>fnd_log.level_procedure);
4905: END IF;

Line 4904: p_msg_level=>fnd_log.level_procedure);

4900: -- Debug info.
4901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4902: hz_utility_v2pub.debug(p_message=>'update_bank_site (-)',
4903: p_prefix=>l_debug_prefix,
4904: p_msg_level=>fnd_log.level_procedure);
4905: END IF;
4906:
4907: -- disable the debug procedure before exiting.
4908: --disable_debug;

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

4914: p_count => x_msg_count,
4915: p_data => x_msg_data);
4916:
4917: -- Debug info.
4918: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4919: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4920: p_msg_data=>x_msg_data,
4921: p_msg_type=>'ERROR',
4922: p_msg_level=>fnd_log.level_error);

Line 4922: p_msg_level=>fnd_log.level_error);

4918: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4919: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4920: p_msg_data=>x_msg_data,
4921: p_msg_type=>'ERROR',
4922: p_msg_level=>fnd_log.level_error);
4923: END IF;
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,

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

4920: p_msg_data=>x_msg_data,
4921: p_msg_type=>'ERROR',
4922: p_msg_level=>fnd_log.level_error);
4923: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 4967: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 4971: p_msg_level=>fnd_log.level_error);

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

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

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

Line 4976: p_msg_level=>fnd_log.level_procedure);

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

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

5029: -- Check if API is called in debug mode. If yes, enable debug.
5030: --enable_debug;
5031:
5032: -- Debug info.
5033: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5034: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (+)',
5035: p_prefix=>l_debug_prefix,
5036: p_msg_level=>fnd_log.level_procedure);
5037: END IF;

Line 5036: p_msg_level=>fnd_log.level_procedure);

5032: -- Debug info.
5033: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5034: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (+)',
5035: p_prefix=>l_debug_prefix,
5036: p_msg_level=>fnd_log.level_procedure);
5037: END IF;
5038:
5039: -- initialize API return status to success.
5040: x_return_status := fnd_api.g_ret_sts_success;

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

5069: RAISE fnd_api.g_exc_error;
5070: END IF;
5071:
5072: -- Debug info.
5073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5074: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
5075: p_prefix=>l_debug_prefix,
5076: p_msg_level=>fnd_log.level_procedure);
5077: END IF;

Line 5076: p_msg_level=>fnd_log.level_procedure);

5072: -- Debug info.
5073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5074: hz_utility_v2pub.debug(p_message=>'create_edi_contact_point (-)',
5075: p_prefix=>l_debug_prefix,
5076: p_msg_level=>fnd_log.level_procedure);
5077: END IF;
5078:
5079: -- disable the debug procedure before exiting.
5080: --disable_debug;

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

5086: p_count => x_msg_count,
5087: p_data => x_msg_data);
5088:
5089: -- Debug info.
5090: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5091: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5092: p_msg_data=>x_msg_data,
5093: p_msg_type=>'ERROR',
5094: p_msg_level=>fnd_log.level_error);

Line 5094: p_msg_level=>fnd_log.level_error);

5090: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5091: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5092: p_msg_data=>x_msg_data,
5093: p_msg_type=>'ERROR',
5094: p_msg_level=>fnd_log.level_error);
5095: END IF;
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,

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

5092: p_msg_data=>x_msg_data,
5093: p_msg_type=>'ERROR',
5094: p_msg_level=>fnd_log.level_error);
5095: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 5139: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 5143: p_msg_level=>fnd_log.level_error);

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

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

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

Line 5148: p_msg_level=>fnd_log.level_procedure);

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

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

5201: -- Check if API is called in debug mode. If yes, enable debug.
5202: --enable_debug;
5203:
5204: -- Debug info.
5205: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5206: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (+)',
5207: p_prefix=>l_debug_prefix,
5208: p_msg_level=>fnd_log.level_procedure);
5209: END IF;

Line 5208: p_msg_level=>fnd_log.level_procedure);

5204: -- Debug info.
5205: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5206: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (+)',
5207: p_prefix=>l_debug_prefix,
5208: p_msg_level=>fnd_log.level_procedure);
5209: END IF;
5210:
5211: -- initialize API return status to success.
5212: x_return_status := fnd_api.g_ret_sts_success;

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

5241: RAISE fnd_api.g_exc_error;
5242: END IF;
5243:
5244: -- Debug info.
5245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5246: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
5247: p_prefix=>l_debug_prefix,
5248: p_msg_level=>fnd_log.level_procedure);
5249: END IF;

Line 5248: p_msg_level=>fnd_log.level_procedure);

5244: -- Debug info.
5245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5246: hz_utility_v2pub.debug(p_message=>'update_edi_contact_point (-)',
5247: p_prefix=>l_debug_prefix,
5248: p_msg_level=>fnd_log.level_procedure);
5249: END IF;
5250:
5251: -- disable the debug procedure before exiting.
5252: --disable_debug;

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

5258: p_count => x_msg_count,
5259: p_data => x_msg_data);
5260:
5261: -- Debug info.
5262: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5263: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5264: p_msg_data=>x_msg_data,
5265: p_msg_type=>'ERROR',
5266: p_msg_level=>fnd_log.level_error);

Line 5266: p_msg_level=>fnd_log.level_error);

5262: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5263: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5264: p_msg_data=>x_msg_data,
5265: p_msg_type=>'ERROR',
5266: p_msg_level=>fnd_log.level_error);
5267: END IF;
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,

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

5264: p_msg_data=>x_msg_data,
5265: p_msg_type=>'ERROR',
5266: p_msg_level=>fnd_log.level_error);
5267: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 5311: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 5315: p_msg_level=>fnd_log.level_error);

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

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

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

Line 5320: p_msg_level=>fnd_log.level_procedure);

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

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

5373: -- Check if API is called in debug mode. If yes, enable debug.
5374: --enable_debug;
5375:
5376: -- Debug info.
5377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5378: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (+)',
5379: p_prefix=>l_debug_prefix,
5380: p_msg_level=>fnd_log.level_procedure);
5381: END IF;

Line 5380: p_msg_level=>fnd_log.level_procedure);

5376: -- Debug info.
5377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5378: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (+)',
5379: p_prefix=>l_debug_prefix,
5380: p_msg_level=>fnd_log.level_procedure);
5381: END IF;
5382:
5383: -- initialize API return status to success.
5384: x_return_status := fnd_api.g_ret_sts_success;

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

5413: RAISE fnd_api.g_exc_error;
5414: END IF;
5415:
5416: -- Debug info.
5417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5418: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
5419: p_prefix=>l_debug_prefix,
5420: p_msg_level=>fnd_log.level_procedure);
5421: END IF;

Line 5420: p_msg_level=>fnd_log.level_procedure);

5416: -- Debug info.
5417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5418: hz_utility_v2pub.debug(p_message=>'create_eft_contact_point (-)',
5419: p_prefix=>l_debug_prefix,
5420: p_msg_level=>fnd_log.level_procedure);
5421: END IF;
5422:
5423: -- disable the debug procedure before exiting.
5424: --disable_debug;

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

5430: p_count => x_msg_count,
5431: p_data => x_msg_data);
5432:
5433: -- Debug info.
5434: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5435: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5436: p_msg_data=>x_msg_data,
5437: p_msg_type=>'ERROR',
5438: p_msg_level=>fnd_log.level_error);

Line 5438: p_msg_level=>fnd_log.level_error);

5434: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5435: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5436: p_msg_data=>x_msg_data,
5437: p_msg_type=>'ERROR',
5438: p_msg_level=>fnd_log.level_error);
5439: END IF;
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,

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

5436: p_msg_data=>x_msg_data,
5437: p_msg_type=>'ERROR',
5438: p_msg_level=>fnd_log.level_error);
5439: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 5483: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 5487: p_msg_level=>fnd_log.level_error);

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

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

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

Line 5492: p_msg_level=>fnd_log.level_procedure);

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

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

5545: -- Check if API is called in debug mode. If yes, enable debug.
5546: --enable_debug;
5547:
5548: -- Debug info.
5549: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5550: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (+)',
5551: p_prefix=>l_debug_prefix,
5552: p_msg_level=>fnd_log.level_procedure);
5553: END IF;

Line 5552: p_msg_level=>fnd_log.level_procedure);

5548: -- Debug info.
5549: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5550: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (+)',
5551: p_prefix=>l_debug_prefix,
5552: p_msg_level=>fnd_log.level_procedure);
5553: END IF;
5554:
5555: -- initialize API return status to success.
5556: x_return_status := fnd_api.g_ret_sts_success;

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

5585: RAISE fnd_api.g_exc_error;
5586: END IF;
5587:
5588: -- Debug info.
5589: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5590: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5591: p_prefix=>l_debug_prefix,
5592: p_msg_level=>fnd_log.level_procedure);
5593: END IF;

Line 5592: p_msg_level=>fnd_log.level_procedure);

5588: -- Debug info.
5589: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5590: hz_utility_v2pub.debug(p_message=>'update_eft_contact_point (-)',
5591: p_prefix=>l_debug_prefix,
5592: p_msg_level=>fnd_log.level_procedure);
5593: END IF;
5594:
5595: -- disable the debug procedure before exiting.
5596: --disable_debug;

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

5602: p_count => x_msg_count,
5603: p_data => x_msg_data);
5604:
5605: -- Debug info.
5606: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5607: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5608: p_msg_data=>x_msg_data,
5609: p_msg_type=>'ERROR',
5610: p_msg_level=>fnd_log.level_error);

Line 5610: p_msg_level=>fnd_log.level_error);

5606: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5607: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5608: p_msg_data=>x_msg_data,
5609: p_msg_type=>'ERROR',
5610: p_msg_level=>fnd_log.level_error);
5611: END IF;
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,

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

5608: p_msg_data=>x_msg_data,
5609: p_msg_type=>'ERROR',
5610: p_msg_level=>fnd_log.level_error);
5611: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 5655: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 5659: p_msg_level=>fnd_log.level_error);

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

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

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

Line 5664: p_msg_level=>fnd_log.level_procedure);

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

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

5717: -- Check if API is called in debug mode. If yes, enable debug.
5718: --enable_debug;
5719:
5720: -- Debug info.
5721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5722: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (+)',
5723: p_prefix=>l_debug_prefix,
5724: p_msg_level=>fnd_log.level_procedure);
5725: END IF;

Line 5724: p_msg_level=>fnd_log.level_procedure);

5720: -- Debug info.
5721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5722: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (+)',
5723: p_prefix=>l_debug_prefix,
5724: p_msg_level=>fnd_log.level_procedure);
5725: END IF;
5726:
5727: -- initialize API return status to success.
5728: x_return_status := fnd_api.g_ret_sts_success;

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

5757: RAISE fnd_api.g_exc_error;
5758: END IF;
5759:
5760: -- Debug info.
5761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5762: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
5763: p_prefix=>l_debug_prefix,
5764: p_msg_level=>fnd_log.level_procedure);
5765: END IF;

Line 5764: p_msg_level=>fnd_log.level_procedure);

5760: -- Debug info.
5761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5762: hz_utility_v2pub.debug(p_message=>'create_web_contact_point (-)',
5763: p_prefix=>l_debug_prefix,
5764: p_msg_level=>fnd_log.level_procedure);
5765: END IF;
5766:
5767: -- disable the debug procedure before exiting.
5768: --disable_debug;

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

5774: p_count => x_msg_count,
5775: p_data => x_msg_data);
5776:
5777: -- Debug info.
5778: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5779: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5780: p_msg_data=>x_msg_data,
5781: p_msg_type=>'ERROR',
5782: p_msg_level=>fnd_log.level_error);

Line 5782: p_msg_level=>fnd_log.level_error);

5778: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5779: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5780: p_msg_data=>x_msg_data,
5781: p_msg_type=>'ERROR',
5782: p_msg_level=>fnd_log.level_error);
5783: END IF;
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,

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

5780: p_msg_data=>x_msg_data,
5781: p_msg_type=>'ERROR',
5782: p_msg_level=>fnd_log.level_error);
5783: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 5827: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 5831: p_msg_level=>fnd_log.level_error);

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

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

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

Line 5836: p_msg_level=>fnd_log.level_procedure);

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

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

5889: -- Check if API is called in debug mode. If yes, enable debug.
5890: --enable_debug;
5891:
5892: -- Debug info.
5893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5894: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (+)',
5895: p_prefix=>l_debug_prefix,
5896: p_msg_level=>fnd_log.level_procedure);
5897: END IF;

Line 5896: p_msg_level=>fnd_log.level_procedure);

5892: -- Debug info.
5893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5894: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (+)',
5895: p_prefix=>l_debug_prefix,
5896: p_msg_level=>fnd_log.level_procedure);
5897: END IF;
5898:
5899: -- initialize API return status to success.
5900: x_return_status := fnd_api.g_ret_sts_success;

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

5929: RAISE fnd_api.g_exc_error;
5930: END IF;
5931:
5932: -- Debug info.
5933: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5934: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
5935: p_prefix=>l_debug_prefix,
5936: p_msg_level=>fnd_log.level_procedure);
5937: END IF;

Line 5936: p_msg_level=>fnd_log.level_procedure);

5932: -- Debug info.
5933: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5934: hz_utility_v2pub.debug(p_message=>'update_web_contact_point (-)',
5935: p_prefix=>l_debug_prefix,
5936: p_msg_level=>fnd_log.level_procedure);
5937: END IF;
5938:
5939: -- disable the debug procedure before exiting.
5940: --disable_debug;

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

5946: p_count => x_msg_count,
5947: p_data => x_msg_data);
5948:
5949: -- Debug info.
5950: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5951: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5952: p_msg_data=>x_msg_data,
5953: p_msg_type=>'ERROR',
5954: p_msg_level=>fnd_log.level_error);

Line 5954: p_msg_level=>fnd_log.level_error);

5950: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5951: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5952: p_msg_data=>x_msg_data,
5953: p_msg_type=>'ERROR',
5954: p_msg_level=>fnd_log.level_error);
5955: END IF;
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,

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

5952: p_msg_data=>x_msg_data,
5953: p_msg_type=>'ERROR',
5954: p_msg_level=>fnd_log.level_error);
5955: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 5999: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 6003: p_msg_level=>fnd_log.level_error);

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

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

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

Line 6008: p_msg_level=>fnd_log.level_procedure);

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

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

6061: -- Check if API is called in debug mode. If yes, enable debug.
6062: --enable_debug;
6063:
6064: -- Debug info.
6065: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6066: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (+)',
6067: p_prefix=>l_debug_prefix,
6068: p_msg_level=>fnd_log.level_procedure);
6069: END IF;

Line 6068: p_msg_level=>fnd_log.level_procedure);

6064: -- Debug info.
6065: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6066: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (+)',
6067: p_prefix=>l_debug_prefix,
6068: p_msg_level=>fnd_log.level_procedure);
6069: END IF;
6070:
6071: -- initialize API return status to success.
6072: x_return_status := fnd_api.g_ret_sts_success;

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

6101: RAISE fnd_api.g_exc_error;
6102: END IF;
6103:
6104: -- Debug info.
6105: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6106: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
6107: p_prefix=>l_debug_prefix,
6108: p_msg_level=>fnd_log.level_procedure);
6109: END IF;

Line 6108: p_msg_level=>fnd_log.level_procedure);

6104: -- Debug info.
6105: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6106: hz_utility_v2pub.debug(p_message=>'create_phone_contact_point (-)',
6107: p_prefix=>l_debug_prefix,
6108: p_msg_level=>fnd_log.level_procedure);
6109: END IF;
6110:
6111: -- disable the debug procedure before exiting.
6112: --disable_debug;

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

6118: p_count => x_msg_count,
6119: p_data => x_msg_data);
6120:
6121: -- Debug info.
6122: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6123: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6124: p_msg_data=>x_msg_data,
6125: p_msg_type=>'ERROR',
6126: p_msg_level=>fnd_log.level_error);

Line 6126: p_msg_level=>fnd_log.level_error);

6122: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6123: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6124: p_msg_data=>x_msg_data,
6125: p_msg_type=>'ERROR',
6126: p_msg_level=>fnd_log.level_error);
6127: END IF;
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,

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

6124: p_msg_data=>x_msg_data,
6125: p_msg_type=>'ERROR',
6126: p_msg_level=>fnd_log.level_error);
6127: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 6171: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 6175: p_msg_level=>fnd_log.level_error);

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

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

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

Line 6180: p_msg_level=>fnd_log.level_procedure);

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

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

6233: -- Check if API is called in debug mode. If yes, enable debug.
6234: --enable_debug;
6235:
6236: -- Debug info.
6237: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6238: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (+)',
6239: p_prefix=>l_debug_prefix,
6240: p_msg_level=>fnd_log.level_procedure);
6241: END IF;

Line 6240: p_msg_level=>fnd_log.level_procedure);

6236: -- Debug info.
6237: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6238: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (+)',
6239: p_prefix=>l_debug_prefix,
6240: p_msg_level=>fnd_log.level_procedure);
6241: END IF;
6242:
6243: -- initialize API return status to success.
6244: x_return_status := fnd_api.g_ret_sts_success;

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

6273: RAISE fnd_api.g_exc_error;
6274: END IF;
6275:
6276: -- Debug info.
6277: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6278: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
6279: p_prefix=>l_debug_prefix,
6280: p_msg_level=>fnd_log.level_procedure);
6281: END IF;

Line 6280: p_msg_level=>fnd_log.level_procedure);

6276: -- Debug info.
6277: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6278: hz_utility_v2pub.debug(p_message=>'update_phone_contact_point (-)',
6279: p_prefix=>l_debug_prefix,
6280: p_msg_level=>fnd_log.level_procedure);
6281: END IF;
6282:
6283: -- disable the debug procedure before exiting.
6284: --disable_debug;

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

6290: p_count => x_msg_count,
6291: p_data => x_msg_data);
6292:
6293: -- Debug info.
6294: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6295: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6296: p_msg_data=>x_msg_data,
6297: p_msg_type=>'ERROR',
6298: p_msg_level=>fnd_log.level_error);

Line 6298: p_msg_level=>fnd_log.level_error);

6294: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6295: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6296: p_msg_data=>x_msg_data,
6297: p_msg_type=>'ERROR',
6298: p_msg_level=>fnd_log.level_error);
6299: END IF;
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,

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

6296: p_msg_data=>x_msg_data,
6297: p_msg_type=>'ERROR',
6298: p_msg_level=>fnd_log.level_error);
6299: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 6343: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 6347: p_msg_level=>fnd_log.level_error);

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

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

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

Line 6352: p_msg_level=>fnd_log.level_procedure);

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

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

6405: -- Check if API is called in debug mode. If yes, enable debug.
6406: --enable_debug;
6407:
6408: -- Debug info.
6409: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6410: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (+)',
6411: p_prefix=>l_debug_prefix,
6412: p_msg_level=>fnd_log.level_procedure);
6413: END IF;

Line 6412: p_msg_level=>fnd_log.level_procedure);

6408: -- Debug info.
6409: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6410: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (+)',
6411: p_prefix=>l_debug_prefix,
6412: p_msg_level=>fnd_log.level_procedure);
6413: END IF;
6414:
6415: -- initialize API return status to success.
6416: x_return_status := fnd_api.g_ret_sts_success;

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

6445: RAISE fnd_api.g_exc_error;
6446: END IF;
6447:
6448: -- Debug info.
6449: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6450: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
6451: p_prefix=>l_debug_prefix,
6452: p_msg_level=>fnd_log.level_procedure);
6453: END IF;

Line 6452: p_msg_level=>fnd_log.level_procedure);

6448: -- Debug info.
6449: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6450: hz_utility_v2pub.debug(p_message=>'create_email_contact_point (-)',
6451: p_prefix=>l_debug_prefix,
6452: p_msg_level=>fnd_log.level_procedure);
6453: END IF;
6454:
6455: -- disable the debug procedure before exiting.
6456: --disable_debug;

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

6462: p_count => x_msg_count,
6463: p_data => x_msg_data);
6464:
6465: -- Debug info.
6466: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6467: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6468: p_msg_data=>x_msg_data,
6469: p_msg_type=>'ERROR',
6470: p_msg_level=>fnd_log.level_error);

Line 6470: p_msg_level=>fnd_log.level_error);

6466: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6467: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6468: p_msg_data=>x_msg_data,
6469: p_msg_type=>'ERROR',
6470: p_msg_level=>fnd_log.level_error);
6471: END IF;
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,

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

6468: p_msg_data=>x_msg_data,
6469: p_msg_type=>'ERROR',
6470: p_msg_level=>fnd_log.level_error);
6471: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 6515: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 6519: p_msg_level=>fnd_log.level_error);

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

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

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

Line 6524: p_msg_level=>fnd_log.level_procedure);

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

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

6577: -- Check if API is called in debug mode. If yes, enable debug.
6578: --enable_debug;
6579:
6580: -- Debug info.
6581: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6582: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (+)',
6583: p_prefix=>l_debug_prefix,
6584: p_msg_level=>fnd_log.level_procedure);
6585: END IF;

Line 6584: p_msg_level=>fnd_log.level_procedure);

6580: -- Debug info.
6581: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6582: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (+)',
6583: p_prefix=>l_debug_prefix,
6584: p_msg_level=>fnd_log.level_procedure);
6585: END IF;
6586:
6587: -- initialize API return status to success.
6588: x_return_status := fnd_api.g_ret_sts_success;

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

6617: RAISE fnd_api.g_exc_error;
6618: END IF;
6619:
6620: -- Debug info.
6621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6622: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
6623: p_prefix=>l_debug_prefix,
6624: p_msg_level=>fnd_log.level_procedure);
6625: END IF;

Line 6624: p_msg_level=>fnd_log.level_procedure);

6620: -- Debug info.
6621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6622: hz_utility_v2pub.debug(p_message=>'update_email_contact_point (-)',
6623: p_prefix=>l_debug_prefix,
6624: p_msg_level=>fnd_log.level_procedure);
6625: END IF;
6626:
6627: -- disable the debug procedure before exiting.
6628: --disable_debug;

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

6634: p_count => x_msg_count,
6635: p_data => x_msg_data);
6636:
6637: -- Debug info.
6638: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6639: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6640: p_msg_data=>x_msg_data,
6641: p_msg_type=>'ERROR',
6642: p_msg_level=>fnd_log.level_error);

Line 6642: p_msg_level=>fnd_log.level_error);

6638: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6639: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6640: p_msg_data=>x_msg_data,
6641: p_msg_type=>'ERROR',
6642: p_msg_level=>fnd_log.level_error);
6643: END IF;
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,

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

6640: p_msg_data=>x_msg_data,
6641: p_msg_type=>'ERROR',
6642: p_msg_level=>fnd_log.level_error);
6643: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 6687: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 6691: p_msg_level=>fnd_log.level_error);

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

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

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

Line 6696: p_msg_level=>fnd_log.level_procedure);

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

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

6749: -- Check if API is called in debug mode. If yes, enable debug.
6750: --enable_debug;
6751:
6752: -- Debug info.
6753: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6754: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (+)',
6755: p_prefix=>l_debug_prefix,
6756: p_msg_level=>fnd_log.level_procedure);
6757: END IF;

Line 6756: p_msg_level=>fnd_log.level_procedure);

6752: -- Debug info.
6753: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6754: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (+)',
6755: p_prefix=>l_debug_prefix,
6756: p_msg_level=>fnd_log.level_procedure);
6757: END IF;
6758:
6759: -- initialize API return status to success.
6760: x_return_status := fnd_api.g_ret_sts_success;

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

6789: RAISE fnd_api.g_exc_error;
6790: END IF;
6791:
6792: -- Debug info.
6793: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6794: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
6795: p_prefix=>l_debug_prefix,
6796: p_msg_level=>fnd_log.level_procedure);
6797: END IF;

Line 6796: p_msg_level=>fnd_log.level_procedure);

6792: -- Debug info.
6793: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6794: hz_utility_v2pub.debug(p_message=>'create_telex_contact_point (-)',
6795: p_prefix=>l_debug_prefix,
6796: p_msg_level=>fnd_log.level_procedure);
6797: END IF;
6798:
6799: -- disable the debug procedure before exiting.
6800: --disable_debug;

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

6806: p_count => x_msg_count,
6807: p_data => x_msg_data);
6808:
6809: -- Debug info.
6810: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6811: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6812: p_msg_data=>x_msg_data,
6813: p_msg_type=>'ERROR',
6814: p_msg_level=>fnd_log.level_error);

Line 6814: p_msg_level=>fnd_log.level_error);

6810: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6811: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6812: p_msg_data=>x_msg_data,
6813: p_msg_type=>'ERROR',
6814: p_msg_level=>fnd_log.level_error);
6815: END IF;
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,

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

6812: p_msg_data=>x_msg_data,
6813: p_msg_type=>'ERROR',
6814: p_msg_level=>fnd_log.level_error);
6815: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 6859: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 6863: p_msg_level=>fnd_log.level_error);

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

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

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

Line 6868: p_msg_level=>fnd_log.level_procedure);

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

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

6921: -- Check if API is called in debug mode. If yes, enable debug.
6922: --enable_debug;
6923:
6924: -- Debug info.
6925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6926: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (+)',
6927: p_prefix=>l_debug_prefix,
6928: p_msg_level=>fnd_log.level_procedure);
6929: END IF;

Line 6928: p_msg_level=>fnd_log.level_procedure);

6924: -- Debug info.
6925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6926: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (+)',
6927: p_prefix=>l_debug_prefix,
6928: p_msg_level=>fnd_log.level_procedure);
6929: END IF;
6930:
6931:
6932: -- initialize API return status to success.

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

6962: RAISE fnd_api.g_exc_error;
6963: END IF;
6964:
6965: -- Debug info.
6966: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6967: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
6968: p_prefix=>l_debug_prefix,
6969: p_msg_level=>fnd_log.level_procedure);
6970: END IF;

Line 6969: p_msg_level=>fnd_log.level_procedure);

6965: -- Debug info.
6966: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6967: hz_utility_v2pub.debug(p_message=>'update_telex_contact_point (-)',
6968: p_prefix=>l_debug_prefix,
6969: p_msg_level=>fnd_log.level_procedure);
6970: END IF;
6971:
6972: -- disable the debug procedure before exiting.
6973: --disable_debug;

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

6979: p_count => x_msg_count,
6980: p_data => x_msg_data);
6981:
6982: -- Debug info.
6983: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6984: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6985: p_msg_data=>x_msg_data,
6986: p_msg_type=>'ERROR',
6987: p_msg_level=>fnd_log.level_error);

Line 6987: p_msg_level=>fnd_log.level_error);

6983: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6984: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6985: p_msg_data=>x_msg_data,
6986: p_msg_type=>'ERROR',
6987: p_msg_level=>fnd_log.level_error);
6988: END IF;
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,

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

6985: p_msg_data=>x_msg_data,
6986: p_msg_type=>'ERROR',
6987: p_msg_level=>fnd_log.level_error);
6988: END IF;
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: END IF;
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: -- Check if API is called in debug mode. If yes, disable debug.
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=>'UNEXPECTED 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=>'UNEXPECTED 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=>'UNEXPECTED 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 7032: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 7036: p_msg_level=>fnd_log.level_error);

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

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

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

Line 7041: p_msg_level=>fnd_log.level_procedure);

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

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

7091:
7092: l_debug_prefix := '';
7093:
7094: -- Debug info.
7095: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7096: hz_utility_v2pub.debug (
7097: p_message => c_api_name||' (+)',
7098: p_prefix => l_debug_prefix,
7099: p_msg_level => fnd_log.level_procedure

Line 7099: p_msg_level => fnd_log.level_procedure

7095: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7096: hz_utility_v2pub.debug (
7097: p_message => c_api_name||' (+)',
7098: p_prefix => l_debug_prefix,
7099: p_msg_level => fnd_log.level_procedure
7100: );
7101: END IF;
7102:
7103: -- initialize message list if p_init_msg_list is set to TRUE.

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

7142: p_count => x_msg_count,
7143: p_data => x_msg_data);
7144:
7145: -- Debug info.
7146: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7147: hz_utility_v2pub.debug_return_messages (
7148: p_msg_count => x_msg_count,
7149: p_msg_data => x_msg_data,
7150: p_msg_type => 'WARNING',

Line 7151: p_msg_level => fnd_log.level_exception

7147: hz_utility_v2pub.debug_return_messages (
7148: p_msg_count => x_msg_count,
7149: p_msg_data => x_msg_data,
7150: p_msg_type => 'WARNING',
7151: p_msg_level => fnd_log.level_exception
7152: );
7153: END IF;
7154:
7155: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

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

7151: p_msg_level => fnd_log.level_exception
7152: );
7153: END IF;
7154:
7155: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7156: hz_utility_v2pub.debug (
7157: p_message => c_api_name||' (-)',
7158: p_prefix => l_debug_prefix,
7159: p_msg_level => fnd_log.level_procedure

Line 7159: p_msg_level => fnd_log.level_procedure

7155: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7156: hz_utility_v2pub.debug (
7157: p_message => c_api_name||' (-)',
7158: p_prefix => l_debug_prefix,
7159: p_msg_level => fnd_log.level_procedure
7160: );
7161: END IF;
7162:
7163: EXCEPTION

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

7170: p_data => x_msg_data
7171: );
7172:
7173: -- Debug info.
7174: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7175: hz_utility_v2pub.debug_return_messages (
7176: p_msg_count => x_msg_count,
7177: p_msg_data => x_msg_data,
7178: p_msg_type => 'ERROR',

Line 7179: p_msg_level => fnd_log.level_error

7175: hz_utility_v2pub.debug_return_messages (
7176: p_msg_count => x_msg_count,
7177: p_msg_data => x_msg_data,
7178: p_msg_type => 'ERROR',
7179: p_msg_level => fnd_log.level_error
7180: );
7181: END IF;
7182:
7183: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

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

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

Line 7187: p_msg_level => fnd_log.level_procedure

7183: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7184: hz_utility_v2pub.debug (
7185: p_message => c_api_name||' (-)',
7186: p_prefix => l_debug_prefix,
7187: p_msg_level => fnd_log.level_procedure
7188: );
7189: END IF;
7190:
7191: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

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

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

Line 7205: p_msg_level => fnd_log.level_error

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

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

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

Line 7213: p_msg_level => fnd_log.level_procedure

7209: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7210: hz_utility_v2pub.debug (
7211: p_message => c_api_name||' (-)',
7212: p_prefix => l_debug_prefix,
7213: p_msg_level => fnd_log.level_procedure
7214: );
7215: END IF;
7216:
7217: WHEN OTHERS THEN

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

7227: p_data => x_msg_data
7228: );
7229:
7230: -- Debug info.
7231: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7232: hz_utility_v2pub.debug_return_messages (
7233: p_msg_count => x_msg_count,
7234: p_msg_data => x_msg_data,
7235: p_msg_type => 'SQL ERROR',

Line 7236: p_msg_level => fnd_log.level_error

7232: hz_utility_v2pub.debug_return_messages (
7233: p_msg_count => x_msg_count,
7234: p_msg_data => x_msg_data,
7235: p_msg_type => 'SQL ERROR',
7236: p_msg_level => fnd_log.level_error
7237: );
7238: END IF;
7239:
7240: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

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

7236: p_msg_level => fnd_log.level_error
7237: );
7238: END IF;
7239:
7240: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7241: hz_utility_v2pub.debug (
7242: p_message => c_api_name||' (-)',
7243: p_prefix => l_debug_prefix,
7244: p_msg_level => fnd_log.level_procedure

Line 7244: p_msg_level => fnd_log.level_procedure

7240: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7241: hz_utility_v2pub.debug (
7242: p_message => c_api_name||' (-)',
7243: p_prefix => l_debug_prefix,
7244: p_msg_level => fnd_log.level_procedure
7245: );
7246: END IF;
7247:
7248: END validate_bank;

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

7294:
7295: l_debug_prefix := '';
7296:
7297: -- Debug info.
7298: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7299: hz_utility_v2pub.debug (
7300: p_message => c_api_name||' (+)',
7301: p_prefix => l_debug_prefix,
7302: p_msg_level => fnd_log.level_procedure

Line 7302: p_msg_level => fnd_log.level_procedure

7298: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7299: hz_utility_v2pub.debug (
7300: p_message => c_api_name||' (+)',
7301: p_prefix => l_debug_prefix,
7302: p_msg_level => fnd_log.level_procedure
7303: );
7304: END IF;
7305:
7306: -- initialize message list if p_init_msg_list is set to TRUE.

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

7357: p_count => x_msg_count,
7358: p_data => x_msg_data);
7359:
7360: -- Debug info.
7361: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7362: hz_utility_v2pub.debug_return_messages (
7363: p_msg_count => x_msg_count,
7364: p_msg_data => x_msg_data,
7365: p_msg_type => 'WARNING',

Line 7366: p_msg_level => fnd_log.level_exception

7362: hz_utility_v2pub.debug_return_messages (
7363: p_msg_count => x_msg_count,
7364: p_msg_data => x_msg_data,
7365: p_msg_type => 'WARNING',
7366: p_msg_level => fnd_log.level_exception
7367: );
7368: END IF;
7369:
7370: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

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

7366: p_msg_level => fnd_log.level_exception
7367: );
7368: END IF;
7369:
7370: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7371: hz_utility_v2pub.debug (
7372: p_message => c_api_name||' (-)',
7373: p_prefix => l_debug_prefix,
7374: p_msg_level => fnd_log.level_procedure

Line 7374: p_msg_level => fnd_log.level_procedure

7370: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7371: hz_utility_v2pub.debug (
7372: p_message => c_api_name||' (-)',
7373: p_prefix => l_debug_prefix,
7374: p_msg_level => fnd_log.level_procedure
7375: );
7376: END IF;
7377:
7378: EXCEPTION

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

7385: p_data => x_msg_data
7386: );
7387:
7388: -- Debug info.
7389: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7390: hz_utility_v2pub.debug_return_messages (
7391: p_msg_count => x_msg_count,
7392: p_msg_data => x_msg_data,
7393: p_msg_type => 'ERROR',

Line 7394: p_msg_level => fnd_log.level_error

7390: hz_utility_v2pub.debug_return_messages (
7391: p_msg_count => x_msg_count,
7392: p_msg_data => x_msg_data,
7393: p_msg_type => 'ERROR',
7394: p_msg_level => fnd_log.level_error
7395: );
7396: END IF;
7397:
7398: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

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

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

Line 7402: p_msg_level => fnd_log.level_procedure

7398: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7399: hz_utility_v2pub.debug (
7400: p_message => c_api_name||' (-)',
7401: p_prefix => l_debug_prefix,
7402: p_msg_level => fnd_log.level_procedure
7403: );
7404: END IF;
7405:
7406: WHEN fnd_api.G_EXC_UNEXPECTED_ERROR THEN

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

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

Line 7420: p_msg_level => fnd_log.level_error

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

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

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

Line 7428: p_msg_level => fnd_log.level_procedure

7424: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7425: hz_utility_v2pub.debug (
7426: p_message => c_api_name||' (-)',
7427: p_prefix => l_debug_prefix,
7428: p_msg_level => fnd_log.level_procedure
7429: );
7430: END IF;
7431:
7432: WHEN OTHERS THEN

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

7442: p_data => x_msg_data
7443: );
7444:
7445: -- Debug info.
7446: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7447: hz_utility_v2pub.debug_return_messages (
7448: p_msg_count => x_msg_count,
7449: p_msg_data => x_msg_data,
7450: p_msg_type => 'SQL ERROR',

Line 7451: p_msg_level => fnd_log.level_error

7447: hz_utility_v2pub.debug_return_messages (
7448: p_msg_count => x_msg_count,
7449: p_msg_data => x_msg_data,
7450: p_msg_type => 'SQL ERROR',
7451: p_msg_level => fnd_log.level_error
7452: );
7453: END IF;
7454:
7455: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

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

7451: p_msg_level => fnd_log.level_error
7452: );
7453: END IF;
7454:
7455: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7456: hz_utility_v2pub.debug (
7457: p_message => c_api_name||' (-)',
7458: p_prefix => l_debug_prefix,
7459: p_msg_level => fnd_log.level_procedure

Line 7459: p_msg_level => fnd_log.level_procedure

7455: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
7456: hz_utility_v2pub.debug (
7457: p_message => c_api_name||' (-)',
7458: p_prefix => l_debug_prefix,
7459: p_msg_level => fnd_log.level_procedure
7460: );
7461: END IF;
7462:
7463: END validate_bank_branch;