[Home] [Help]
595: -- initialize API return status to success.
596: x_return_status := FND_API.G_RET_STS_SUCCESS;
597:
598: -- Debug info.
599: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
600: hz_utility_v2pub.debug(p_message=>'create_cust_profile(+)',
601: p_prefix=>l_debug_prefix,
602: p_msg_level=>fnd_log.level_procedure);
603: END IF;
598: -- Debug info.
599: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
600: hz_utility_v2pub.debug(p_message=>'create_cust_profile(+)',
601: p_prefix=>l_debug_prefix,
602: p_msg_level=>fnd_log.level_procedure);
603: END IF;
604:
605: -- Create cust profile
606: assign_cust_profile_rec(
619: x_msg_data => x_msg_data
620: );
621:
622: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
623: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
624: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_profile, cust account id: '||p_ca_id||' cust site use id: '||p_casu_id,
625: p_prefix=>l_debug_prefix,
626: p_msg_level=>fnd_log.level_procedure);
627: END IF;
622: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
623: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
624: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_profile, cust account id: '||p_ca_id||' cust site use id: '||p_casu_id,
625: p_prefix=>l_debug_prefix,
626: p_msg_level=>fnd_log.level_procedure);
627: END IF;
628: RAISE fnd_api.g_exc_error;
629: END IF;
630:
631: -- assign profile_id
632: p_cp_obj.cust_acct_profile_id := x_cp_id;
633:
634: -- Debug info.
635: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
636: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
637: p_msg_data=>x_msg_data,
638: p_msg_type=>'WARNING',
639: p_msg_level=>fnd_log.level_exception);
635: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
636: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
637: p_msg_data=>x_msg_data,
638: p_msg_type=>'WARNING',
639: p_msg_level=>fnd_log.level_exception);
640: END IF;
641: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',
643: p_prefix=>l_debug_prefix,
637: p_msg_data=>x_msg_data,
638: p_msg_type=>'WARNING',
639: p_msg_level=>fnd_log.level_exception);
640: END IF;
641: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',
643: p_prefix=>l_debug_prefix,
644: p_msg_level=>fnd_log.level_procedure);
645: END IF;
640: END IF;
641: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',
643: p_prefix=>l_debug_prefix,
644: p_msg_level=>fnd_log.level_procedure);
645: END IF;
646: EXCEPTION
647: WHEN fnd_api.g_exc_error THEN
648: ROLLBACK TO create_cp_pvt;
656: p_count => x_msg_count,
657: p_data => x_msg_data);
658:
659: -- Debug info.
660: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
661: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
662: p_msg_data=>x_msg_data,
663: p_msg_type=>'ERROR',
664: p_msg_level=>fnd_log.level_error);
660: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
661: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
662: p_msg_data=>x_msg_data,
663: p_msg_type=>'ERROR',
664: p_msg_level=>fnd_log.level_error);
665: END IF;
666: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
667: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',
668: p_prefix=>l_debug_prefix,
662: p_msg_data=>x_msg_data,
663: p_msg_type=>'ERROR',
664: p_msg_level=>fnd_log.level_error);
665: END IF;
666: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
667: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',
668: p_prefix=>l_debug_prefix,
669: p_msg_level=>fnd_log.level_procedure);
670: END IF;
665: END IF;
666: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
667: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',
668: p_prefix=>l_debug_prefix,
669: p_msg_level=>fnd_log.level_procedure);
670: END IF;
671:
672: WHEN fnd_api.g_exc_unexpected_error THEN
673: ROLLBACK TO create_cp_pvt;
681: p_count => x_msg_count,
682: p_data => x_msg_data);
683:
684: -- Debug info.
685: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
686: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
687: p_msg_data=>x_msg_data,
688: p_msg_type=>'UNEXPECTED ERROR',
689: p_msg_level=>fnd_log.level_error);
685: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
686: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
687: p_msg_data=>x_msg_data,
688: p_msg_type=>'UNEXPECTED ERROR',
689: p_msg_level=>fnd_log.level_error);
690: END IF;
691: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
692: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',
693: p_prefix=>l_debug_prefix,
687: p_msg_data=>x_msg_data,
688: p_msg_type=>'UNEXPECTED ERROR',
689: p_msg_level=>fnd_log.level_error);
690: END IF;
691: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
692: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',
693: p_prefix=>l_debug_prefix,
694: p_msg_level=>fnd_log.level_procedure);
695: END IF;
690: END IF;
691: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
692: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',
693: p_prefix=>l_debug_prefix,
694: p_msg_level=>fnd_log.level_procedure);
695: END IF;
696:
697: WHEN OTHERS THEN
698: ROLLBACK TO create_cp_pvt;
710: p_count => x_msg_count,
711: p_data => x_msg_data);
712:
713: -- Debug info.
714: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
715: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
716: p_msg_data=>x_msg_data,
717: p_msg_type=>'SQL ERROR',
718: p_msg_level=>fnd_log.level_error);
714: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
715: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
716: p_msg_data=>x_msg_data,
717: p_msg_type=>'SQL ERROR',
718: p_msg_level=>fnd_log.level_error);
719: END IF;
720: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
721: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',
722: p_prefix=>l_debug_prefix,
716: p_msg_data=>x_msg_data,
717: p_msg_type=>'SQL ERROR',
718: p_msg_level=>fnd_log.level_error);
719: END IF;
720: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
721: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',
722: p_prefix=>l_debug_prefix,
723: p_msg_level=>fnd_log.level_procedure);
724: END IF;
719: END IF;
720: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
721: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',
722: p_prefix=>l_debug_prefix,
723: p_msg_level=>fnd_log.level_procedure);
724: END IF;
725: END create_cust_profile;
726:
727: -- PROCEDURE update_cust_profile
783: -- initialize API return status to success.
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785:
786: -- Debug info.
787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
788: hz_utility_v2pub.debug(p_message=>'update_cust_profile(+)',
789: p_prefix=>l_debug_prefix,
790: p_msg_level=>fnd_log.level_procedure);
791: END IF;
786: -- Debug info.
787: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
788: hz_utility_v2pub.debug(p_message=>'update_cust_profile(+)',
789: p_prefix=>l_debug_prefix,
790: p_msg_level=>fnd_log.level_procedure);
791: END IF;
792:
793: -- check if user pass in cust profile id but with different cust account id
794: -- and/or site use id
833: x_msg_data => x_msg_data
834: );
835:
836: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
837: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
838: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.update_cust_profile, cust account id: '||p_ca_id||' cust site use id: '||p_casu_id,
839: p_prefix=>l_debug_prefix,
840: p_msg_level=>fnd_log.level_procedure);
841: END IF;
836: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
837: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
838: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.update_cust_profile, cust account id: '||p_ca_id||' cust site use id: '||p_casu_id,
839: p_prefix=>l_debug_prefix,
840: p_msg_level=>fnd_log.level_procedure);
841: END IF;
842: RAISE fnd_api.g_exc_error;
843: END IF;
844:
845: -- assign profile_id
846: p_cp_obj.cust_acct_profile_id := x_cp_id;
847:
848: -- Debug info.
849: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
850: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
851: p_msg_data=>x_msg_data,
852: p_msg_type=>'WARNING',
853: p_msg_level=>fnd_log.level_exception);
849: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
850: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
851: p_msg_data=>x_msg_data,
852: p_msg_type=>'WARNING',
853: p_msg_level=>fnd_log.level_exception);
854: END IF;
855: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
856: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',
857: p_prefix=>l_debug_prefix,
851: p_msg_data=>x_msg_data,
852: p_msg_type=>'WARNING',
853: p_msg_level=>fnd_log.level_exception);
854: END IF;
855: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
856: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',
857: p_prefix=>l_debug_prefix,
858: p_msg_level=>fnd_log.level_procedure);
859: END IF;
854: END IF;
855: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
856: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',
857: p_prefix=>l_debug_prefix,
858: p_msg_level=>fnd_log.level_procedure);
859: END IF;
860: EXCEPTION
861: WHEN fnd_api.g_exc_error THEN
862: ROLLBACK TO update_cp_pvt;
870: p_count => x_msg_count,
871: p_data => x_msg_data);
872:
873: -- Debug info.
874: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
875: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
876: p_msg_data=>x_msg_data,
877: p_msg_type=>'ERROR',
878: p_msg_level=>fnd_log.level_error);
874: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
875: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
876: p_msg_data=>x_msg_data,
877: p_msg_type=>'ERROR',
878: p_msg_level=>fnd_log.level_error);
879: END IF;
880: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
881: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',
882: p_prefix=>l_debug_prefix,
876: p_msg_data=>x_msg_data,
877: p_msg_type=>'ERROR',
878: p_msg_level=>fnd_log.level_error);
879: END IF;
880: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
881: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',
882: p_prefix=>l_debug_prefix,
883: p_msg_level=>fnd_log.level_procedure);
884: END IF;
879: END IF;
880: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
881: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',
882: p_prefix=>l_debug_prefix,
883: p_msg_level=>fnd_log.level_procedure);
884: END IF;
885:
886: WHEN fnd_api.g_exc_unexpected_error THEN
887: ROLLBACK TO update_cp_pvt;
895: p_count => x_msg_count,
896: p_data => x_msg_data);
897:
898: -- Debug info.
899: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
900: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
901: p_msg_data=>x_msg_data,
902: p_msg_type=>'UNEXPECTED ERROR',
903: p_msg_level=>fnd_log.level_error);
899: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
900: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
901: p_msg_data=>x_msg_data,
902: p_msg_type=>'UNEXPECTED ERROR',
903: p_msg_level=>fnd_log.level_error);
904: END IF;
905: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
906: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',
907: p_prefix=>l_debug_prefix,
901: p_msg_data=>x_msg_data,
902: p_msg_type=>'UNEXPECTED ERROR',
903: p_msg_level=>fnd_log.level_error);
904: END IF;
905: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
906: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',
907: p_prefix=>l_debug_prefix,
908: p_msg_level=>fnd_log.level_procedure);
909: END IF;
904: END IF;
905: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
906: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',
907: p_prefix=>l_debug_prefix,
908: p_msg_level=>fnd_log.level_procedure);
909: END IF;
910:
911: WHEN OTHERS THEN
912: ROLLBACK TO update_cp_pvt;
924: p_count => x_msg_count,
925: p_data => x_msg_data);
926:
927: -- Debug info.
928: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
929: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
930: p_msg_data=>x_msg_data,
931: p_msg_type=>'SQL ERROR',
932: p_msg_level=>fnd_log.level_error);
928: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
929: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
930: p_msg_data=>x_msg_data,
931: p_msg_type=>'SQL ERROR',
932: p_msg_level=>fnd_log.level_error);
933: END IF;
934: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
935: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',
936: p_prefix=>l_debug_prefix,
930: p_msg_data=>x_msg_data,
931: p_msg_type=>'SQL ERROR',
932: p_msg_level=>fnd_log.level_error);
933: END IF;
934: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
935: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',
936: p_prefix=>l_debug_prefix,
937: p_msg_level=>fnd_log.level_procedure);
938: END IF;
933: END IF;
934: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
935: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',
936: p_prefix=>l_debug_prefix,
937: p_msg_level=>fnd_log.level_procedure);
938: END IF;
939: END update_cust_profile;
940:
941: -- PROCEDURE create_cust_profile_amts
984: -- initialize API return status to success.
985: x_return_status := FND_API.G_RET_STS_SUCCESS;
986:
987: -- Debug info.
988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
989: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(+)',
990: p_prefix=>l_debug_prefix,
991: p_msg_level=>fnd_log.level_procedure);
992: END IF;
987: -- Debug info.
988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
989: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(+)',
990: p_prefix=>l_debug_prefix,
991: p_msg_level=>fnd_log.level_procedure);
992: END IF;
993:
994: FOR i IN 1..p_cpa_objs.COUNT LOOP
995: assign_cust_profile_amt_rec(
1009: x_msg_data => x_msg_data
1010: );
1011:
1012: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1013: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1014: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_profile_amts, cust acct profile id: '||p_cp_id||' cust acct id: '||p_ca_id,
1015: p_prefix=>l_debug_prefix,
1016: p_msg_level=>fnd_log.level_procedure);
1017: END IF;
1012: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1013: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1014: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_profile_amts, cust acct profile id: '||p_cp_id||' cust acct id: '||p_ca_id,
1015: p_prefix=>l_debug_prefix,
1016: p_msg_level=>fnd_log.level_procedure);
1017: END IF;
1018: RAISE FND_API.G_EXC_ERROR;
1019: END IF;
1020:
1022: p_cpa_objs(i).cust_acct_profile_amt_id := l_cpa_id;
1023: END LOOP;
1024:
1025: -- Debug info.
1026: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1027: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1028: p_msg_data=>x_msg_data,
1029: p_msg_type=>'WARNING',
1030: p_msg_level=>fnd_log.level_exception);
1026: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1027: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1028: p_msg_data=>x_msg_data,
1029: p_msg_type=>'WARNING',
1030: p_msg_level=>fnd_log.level_exception);
1031: END IF;
1032: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1033: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',
1034: p_prefix=>l_debug_prefix,
1028: p_msg_data=>x_msg_data,
1029: p_msg_type=>'WARNING',
1030: p_msg_level=>fnd_log.level_exception);
1031: END IF;
1032: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1033: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',
1034: p_prefix=>l_debug_prefix,
1035: p_msg_level=>fnd_log.level_procedure);
1036: END IF;
1031: END IF;
1032: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1033: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',
1034: p_prefix=>l_debug_prefix,
1035: p_msg_level=>fnd_log.level_procedure);
1036: END IF;
1037:
1038: EXCEPTION
1039: WHEN fnd_api.g_exc_error THEN
1048: p_count => x_msg_count,
1049: p_data => x_msg_data);
1050:
1051: -- Debug info.
1052: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1053: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1054: p_msg_data=>x_msg_data,
1055: p_msg_type=>'ERROR',
1056: p_msg_level=>fnd_log.level_error);
1052: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1053: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1054: p_msg_data=>x_msg_data,
1055: p_msg_type=>'ERROR',
1056: p_msg_level=>fnd_log.level_error);
1057: END IF;
1058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1059: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',
1060: p_prefix=>l_debug_prefix,
1054: p_msg_data=>x_msg_data,
1055: p_msg_type=>'ERROR',
1056: p_msg_level=>fnd_log.level_error);
1057: END IF;
1058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1059: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',
1060: p_prefix=>l_debug_prefix,
1061: p_msg_level=>fnd_log.level_procedure);
1062: END IF;
1057: END IF;
1058: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1059: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',
1060: p_prefix=>l_debug_prefix,
1061: p_msg_level=>fnd_log.level_procedure);
1062: END IF;
1063:
1064: WHEN fnd_api.g_exc_unexpected_error THEN
1065: ROLLBACK TO create_cpa_pvt;
1073: p_count => x_msg_count,
1074: p_data => x_msg_data);
1075:
1076: -- Debug info.
1077: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1078: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1079: p_msg_data=>x_msg_data,
1080: p_msg_type=>'UNEXPECTED ERROR',
1081: p_msg_level=>fnd_log.level_error);
1077: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1078: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1079: p_msg_data=>x_msg_data,
1080: p_msg_type=>'UNEXPECTED ERROR',
1081: p_msg_level=>fnd_log.level_error);
1082: END IF;
1083: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1084: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',
1085: p_prefix=>l_debug_prefix,
1079: p_msg_data=>x_msg_data,
1080: p_msg_type=>'UNEXPECTED ERROR',
1081: p_msg_level=>fnd_log.level_error);
1082: END IF;
1083: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1084: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',
1085: p_prefix=>l_debug_prefix,
1086: p_msg_level=>fnd_log.level_procedure);
1087: END IF;
1082: END IF;
1083: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1084: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',
1085: p_prefix=>l_debug_prefix,
1086: p_msg_level=>fnd_log.level_procedure);
1087: END IF;
1088:
1089: WHEN OTHERS THEN
1090: ROLLBACK TO create_cpa_pvt;
1102: p_count => x_msg_count,
1103: p_data => x_msg_data);
1104:
1105: -- Debug info.
1106: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1107: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1108: p_msg_data=>x_msg_data,
1109: p_msg_type=>'SQL ERROR',
1110: p_msg_level=>fnd_log.level_error);
1106: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1107: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1108: p_msg_data=>x_msg_data,
1109: p_msg_type=>'SQL ERROR',
1110: p_msg_level=>fnd_log.level_error);
1111: END IF;
1112: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1113: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',
1114: p_prefix=>l_debug_prefix,
1108: p_msg_data=>x_msg_data,
1109: p_msg_type=>'SQL ERROR',
1110: p_msg_level=>fnd_log.level_error);
1111: END IF;
1112: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1113: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',
1114: p_prefix=>l_debug_prefix,
1115: p_msg_level=>fnd_log.level_procedure);
1116: END IF;
1111: END IF;
1112: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1113: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',
1114: p_prefix=>l_debug_prefix,
1115: p_msg_level=>fnd_log.level_procedure);
1116: END IF;
1117: END create_cust_profile_amts;
1118:
1119: -- PROCEDURE save_cust_profile_amts
1163: -- initialize API return status to success.
1164: x_return_status := FND_API.G_RET_STS_SUCCESS;
1165:
1166: -- Debug info.
1167: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1168: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(+)',
1169: p_prefix=>l_debug_prefix,
1170: p_msg_level=>fnd_log.level_procedure);
1171: END IF;
1166: -- Debug info.
1167: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1168: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(+)',
1169: p_prefix=>l_debug_prefix,
1170: p_msg_level=>fnd_log.level_procedure);
1171: END IF;
1172:
1173: FOR i IN 1..p_cpa_objs.COUNT LOOP
1174: -- Update cust profile amount
1188: x_object_version_number => l_cpa_ovn
1189: );
1190:
1191: IF(l_cpa_ovn = -1) THEN
1192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1193: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.check_cust_profile_amt_op, cust acct profile id: '||p_cp_id||' cust acct id: '||p_ca_id,
1194: p_prefix=>l_debug_prefix,
1195: p_msg_level=>fnd_log.level_procedure);
1196: END IF;
1191: IF(l_cpa_ovn = -1) THEN
1192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1193: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.check_cust_profile_amt_op, cust acct profile id: '||p_cp_id||' cust acct id: '||p_ca_id,
1194: p_prefix=>l_debug_prefix,
1195: p_msg_level=>fnd_log.level_procedure);
1196: END IF;
1197: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
1198: FND_MSG_PUB.ADD;
1199: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1229: p_cpa_objs(i).cust_acct_profile_amt_id := l_cpa_rec.cust_acct_profile_amt_id;
1230: END IF;
1231:
1232: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1234: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_cust_profile_amts, cust acct profile id: '||p_cp_id||' cust acct id: '||p_ca_id,
1235: p_prefix=>l_debug_prefix,
1236: p_msg_level=>fnd_log.level_procedure);
1237: END IF;
1232: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1234: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_cust_profile_amts, cust acct profile id: '||p_cp_id||' cust acct id: '||p_ca_id,
1235: p_prefix=>l_debug_prefix,
1236: p_msg_level=>fnd_log.level_procedure);
1237: END IF;
1238: RAISE FND_API.G_EXC_ERROR;
1239: END IF;
1240: END LOOP;
1239: END IF;
1240: END LOOP;
1241:
1242: -- Debug info.
1243: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1244: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1245: p_msg_data=>x_msg_data,
1246: p_msg_type=>'WARNING',
1247: p_msg_level=>fnd_log.level_exception);
1243: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1244: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1245: p_msg_data=>x_msg_data,
1246: p_msg_type=>'WARNING',
1247: p_msg_level=>fnd_log.level_exception);
1248: END IF;
1249: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1250: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',
1251: p_prefix=>l_debug_prefix,
1245: p_msg_data=>x_msg_data,
1246: p_msg_type=>'WARNING',
1247: p_msg_level=>fnd_log.level_exception);
1248: END IF;
1249: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1250: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',
1251: p_prefix=>l_debug_prefix,
1252: p_msg_level=>fnd_log.level_procedure);
1253: END IF;
1248: END IF;
1249: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1250: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',
1251: p_prefix=>l_debug_prefix,
1252: p_msg_level=>fnd_log.level_procedure);
1253: END IF;
1254: EXCEPTION
1255: WHEN fnd_api.g_exc_error THEN
1256: ROLLBACK TO save_cpa_pvt;
1264: p_count => x_msg_count,
1265: p_data => x_msg_data);
1266:
1267: -- Debug info.
1268: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1269: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1270: p_msg_data=>x_msg_data,
1271: p_msg_type=>'ERROR',
1272: p_msg_level=>fnd_log.level_error);
1268: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1269: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1270: p_msg_data=>x_msg_data,
1271: p_msg_type=>'ERROR',
1272: p_msg_level=>fnd_log.level_error);
1273: END IF;
1274: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1275: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',
1276: p_prefix=>l_debug_prefix,
1270: p_msg_data=>x_msg_data,
1271: p_msg_type=>'ERROR',
1272: p_msg_level=>fnd_log.level_error);
1273: END IF;
1274: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1275: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',
1276: p_prefix=>l_debug_prefix,
1277: p_msg_level=>fnd_log.level_procedure);
1278: END IF;
1273: END IF;
1274: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1275: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',
1276: p_prefix=>l_debug_prefix,
1277: p_msg_level=>fnd_log.level_procedure);
1278: END IF;
1279:
1280: WHEN fnd_api.g_exc_unexpected_error THEN
1281: ROLLBACK TO save_cpa_pvt;
1289: p_count => x_msg_count,
1290: p_data => x_msg_data);
1291:
1292: -- Debug info.
1293: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1294: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1295: p_msg_data=>x_msg_data,
1296: p_msg_type=>'UNEXPECTED ERROR',
1297: p_msg_level=>fnd_log.level_error);
1293: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1294: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1295: p_msg_data=>x_msg_data,
1296: p_msg_type=>'UNEXPECTED ERROR',
1297: p_msg_level=>fnd_log.level_error);
1298: END IF;
1299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1300: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',
1301: p_prefix=>l_debug_prefix,
1295: p_msg_data=>x_msg_data,
1296: p_msg_type=>'UNEXPECTED ERROR',
1297: p_msg_level=>fnd_log.level_error);
1298: END IF;
1299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1300: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',
1301: p_prefix=>l_debug_prefix,
1302: p_msg_level=>fnd_log.level_procedure);
1303: END IF;
1298: END IF;
1299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1300: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',
1301: p_prefix=>l_debug_prefix,
1302: p_msg_level=>fnd_log.level_procedure);
1303: END IF;
1304:
1305: WHEN OTHERS THEN
1306: ROLLBACK TO save_cpa_pvt;
1318: p_count => x_msg_count,
1319: p_data => x_msg_data);
1320:
1321: -- Debug info.
1322: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1323: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1324: p_msg_data=>x_msg_data,
1325: p_msg_type=>'SQL ERROR',
1326: p_msg_level=>fnd_log.level_error);
1322: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1323: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1324: p_msg_data=>x_msg_data,
1325: p_msg_type=>'SQL ERROR',
1326: p_msg_level=>fnd_log.level_error);
1327: END IF;
1328: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1329: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',
1330: p_prefix=>l_debug_prefix,
1324: p_msg_data=>x_msg_data,
1325: p_msg_type=>'SQL ERROR',
1326: p_msg_level=>fnd_log.level_error);
1327: END IF;
1328: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1329: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',
1330: p_prefix=>l_debug_prefix,
1331: p_msg_level=>fnd_log.level_procedure);
1332: END IF;
1327: END IF;
1328: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1329: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',
1330: p_prefix=>l_debug_prefix,
1331: p_msg_level=>fnd_log.level_procedure);
1332: END IF;
1333: END save_cust_profile_amts;
1334:
1335: -- PROCEDURE create_cust_acct_relates
1376: -- initialize API return status to success.
1377: x_return_status := FND_API.G_RET_STS_SUCCESS;
1378:
1379: -- Debug info.
1380: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1381: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(+)',
1382: p_prefix=>l_debug_prefix,
1383: p_msg_level=>fnd_log.level_procedure);
1384: END IF;
1379: -- Debug info.
1380: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1381: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(+)',
1382: p_prefix=>l_debug_prefix,
1383: p_msg_level=>fnd_log.level_procedure);
1384: END IF;
1385:
1386: -- Create cust account relates
1387: FOR i IN 1..p_car_objs.COUNT LOOP
1418: x_msg_data => x_msg_data
1419: );
1420:
1421: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1422: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1423: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,
1424: p_prefix=>l_debug_prefix,
1425: p_msg_level=>fnd_log.level_procedure);
1426: END IF;
1421: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1422: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1423: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,
1424: p_prefix=>l_debug_prefix,
1425: p_msg_level=>fnd_log.level_procedure);
1426: END IF;
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF;
1429: ELSE
1426: END IF;
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF;
1429: ELSE
1430: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1431: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,
1432: p_prefix=>l_debug_prefix,
1433: p_msg_level=>fnd_log.level_procedure);
1434: END IF;
1429: ELSE
1430: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1431: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,
1432: p_prefix=>l_debug_prefix,
1433: p_msg_level=>fnd_log.level_procedure);
1434: END IF;
1435: RAISE FND_API.G_EXC_ERROR;
1436: END IF;
1437: END LOOP;
1436: END IF;
1437: END LOOP;
1438:
1439: -- Debug info.
1440: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1441: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1442: p_msg_data=>x_msg_data,
1443: p_msg_type=>'WARNING',
1444: p_msg_level=>fnd_log.level_exception);
1440: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1441: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1442: p_msg_data=>x_msg_data,
1443: p_msg_type=>'WARNING',
1444: p_msg_level=>fnd_log.level_exception);
1445: END IF;
1446: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1447: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',
1448: p_prefix=>l_debug_prefix,
1442: p_msg_data=>x_msg_data,
1443: p_msg_type=>'WARNING',
1444: p_msg_level=>fnd_log.level_exception);
1445: END IF;
1446: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1447: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',
1448: p_prefix=>l_debug_prefix,
1449: p_msg_level=>fnd_log.level_procedure);
1450: END IF;
1445: END IF;
1446: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1447: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',
1448: p_prefix=>l_debug_prefix,
1449: p_msg_level=>fnd_log.level_procedure);
1450: END IF;
1451: EXCEPTION
1452: WHEN fnd_api.g_exc_error THEN
1453: ROLLBACK TO create_car_pvt;
1461: p_count => x_msg_count,
1462: p_data => x_msg_data);
1463:
1464: -- Debug info.
1465: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1466: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1467: p_msg_data=>x_msg_data,
1468: p_msg_type=>'ERROR',
1469: p_msg_level=>fnd_log.level_error);
1465: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1466: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1467: p_msg_data=>x_msg_data,
1468: p_msg_type=>'ERROR',
1469: p_msg_level=>fnd_log.level_error);
1470: END IF;
1471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1472: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',
1473: p_prefix=>l_debug_prefix,
1467: p_msg_data=>x_msg_data,
1468: p_msg_type=>'ERROR',
1469: p_msg_level=>fnd_log.level_error);
1470: END IF;
1471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1472: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',
1473: p_prefix=>l_debug_prefix,
1474: p_msg_level=>fnd_log.level_procedure);
1475: END IF;
1470: END IF;
1471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1472: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',
1473: p_prefix=>l_debug_prefix,
1474: p_msg_level=>fnd_log.level_procedure);
1475: END IF;
1476:
1477: WHEN fnd_api.g_exc_unexpected_error THEN
1478: ROLLBACK TO create_car_pvt;
1486: p_count => x_msg_count,
1487: p_data => x_msg_data);
1488:
1489: -- Debug info.
1490: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1491: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1492: p_msg_data=>x_msg_data,
1493: p_msg_type=>'UNEXPECTED ERROR',
1494: p_msg_level=>fnd_log.level_error);
1490: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1491: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1492: p_msg_data=>x_msg_data,
1493: p_msg_type=>'UNEXPECTED ERROR',
1494: p_msg_level=>fnd_log.level_error);
1495: END IF;
1496: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1497: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',
1498: p_prefix=>l_debug_prefix,
1492: p_msg_data=>x_msg_data,
1493: p_msg_type=>'UNEXPECTED ERROR',
1494: p_msg_level=>fnd_log.level_error);
1495: END IF;
1496: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1497: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',
1498: p_prefix=>l_debug_prefix,
1499: p_msg_level=>fnd_log.level_procedure);
1500: END IF;
1495: END IF;
1496: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1497: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',
1498: p_prefix=>l_debug_prefix,
1499: p_msg_level=>fnd_log.level_procedure);
1500: END IF;
1501:
1502: WHEN OTHERS THEN
1503: ROLLBACK TO create_car_pvt;
1515: p_count => x_msg_count,
1516: p_data => x_msg_data);
1517:
1518: -- Debug info.
1519: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1520: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1521: p_msg_data=>x_msg_data,
1522: p_msg_type=>'SQL ERROR',
1523: p_msg_level=>fnd_log.level_error);
1519: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1520: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1521: p_msg_data=>x_msg_data,
1522: p_msg_type=>'SQL ERROR',
1523: p_msg_level=>fnd_log.level_error);
1524: END IF;
1525: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1526: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',
1527: p_prefix=>l_debug_prefix,
1521: p_msg_data=>x_msg_data,
1522: p_msg_type=>'SQL ERROR',
1523: p_msg_level=>fnd_log.level_error);
1524: END IF;
1525: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1526: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',
1527: p_prefix=>l_debug_prefix,
1528: p_msg_level=>fnd_log.level_procedure);
1529: END IF;
1524: END IF;
1525: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1526: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',
1527: p_prefix=>l_debug_prefix,
1528: p_msg_level=>fnd_log.level_procedure);
1529: END IF;
1530: END create_cust_acct_relates;
1531:
1532: -- PROCEDURE save_cust_acct_relates
1574: -- initialize API return status to success.
1575: x_return_status := FND_API.G_RET_STS_SUCCESS;
1576:
1577: -- Debug info.
1578: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1579: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(+)',
1580: p_prefix=>l_debug_prefix,
1581: p_msg_level=>fnd_log.level_procedure);
1582: END IF;
1577: -- Debug info.
1578: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1579: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(+)',
1580: p_prefix=>l_debug_prefix,
1581: p_msg_level=>fnd_log.level_procedure);
1582: END IF;
1583:
1584: -- Create/Update cust account relate
1585: FOR i IN 1..p_car_objs.COUNT LOOP
1635: );
1636: END IF;
1637:
1638: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1640: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,
1641: p_prefix=>l_debug_prefix,
1642: p_msg_level=>fnd_log.level_procedure);
1643: END IF;
1638: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1639: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1640: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,
1641: p_prefix=>l_debug_prefix,
1642: p_msg_level=>fnd_log.level_procedure);
1643: END IF;
1644: RAISE FND_API.G_EXC_ERROR;
1645: END IF;
1646: ELSE
1643: END IF;
1644: RAISE FND_API.G_EXC_ERROR;
1645: END IF;
1646: ELSE
1647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,
1649: p_prefix=>l_debug_prefix,
1650: p_msg_level=>fnd_log.level_procedure);
1651: END IF;
1646: ELSE
1647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_cust_acct_relates, cust acct id: '||p_ca_id||' related cust acct id: '||l_rca_id,
1649: p_prefix=>l_debug_prefix,
1650: p_msg_level=>fnd_log.level_procedure);
1651: END IF;
1652: RAISE FND_API.G_EXC_ERROR;
1653: END IF;
1654: END LOOP;
1653: END IF;
1654: END LOOP;
1655:
1656: -- Debug info.
1657: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1658: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1659: p_msg_data=>x_msg_data,
1660: p_msg_type=>'WARNING',
1661: p_msg_level=>fnd_log.level_exception);
1657: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1658: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1659: p_msg_data=>x_msg_data,
1660: p_msg_type=>'WARNING',
1661: p_msg_level=>fnd_log.level_exception);
1662: END IF;
1663: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1664: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1665: p_prefix=>l_debug_prefix,
1659: p_msg_data=>x_msg_data,
1660: p_msg_type=>'WARNING',
1661: p_msg_level=>fnd_log.level_exception);
1662: END IF;
1663: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1664: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1665: p_prefix=>l_debug_prefix,
1666: p_msg_level=>fnd_log.level_procedure);
1667: END IF;
1662: END IF;
1663: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1664: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1665: p_prefix=>l_debug_prefix,
1666: p_msg_level=>fnd_log.level_procedure);
1667: END IF;
1668: EXCEPTION
1669: WHEN fnd_api.g_exc_error THEN
1670: ROLLBACK TO save_car_pvt;
1678: p_count => x_msg_count,
1679: p_data => x_msg_data);
1680:
1681: -- Debug info.
1682: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1683: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1684: p_msg_data=>x_msg_data,
1685: p_msg_type=>'ERROR',
1686: p_msg_level=>fnd_log.level_error);
1682: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1683: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1684: p_msg_data=>x_msg_data,
1685: p_msg_type=>'ERROR',
1686: p_msg_level=>fnd_log.level_error);
1687: END IF;
1688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1689: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1690: p_prefix=>l_debug_prefix,
1684: p_msg_data=>x_msg_data,
1685: p_msg_type=>'ERROR',
1686: p_msg_level=>fnd_log.level_error);
1687: END IF;
1688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1689: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1690: p_prefix=>l_debug_prefix,
1691: p_msg_level=>fnd_log.level_procedure);
1692: END IF;
1687: END IF;
1688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1689: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1690: p_prefix=>l_debug_prefix,
1691: p_msg_level=>fnd_log.level_procedure);
1692: END IF;
1693:
1694: WHEN fnd_api.g_exc_unexpected_error THEN
1695: ROLLBACK TO save_car_pvt;
1703: p_count => x_msg_count,
1704: p_data => x_msg_data);
1705:
1706: -- Debug info.
1707: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1708: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1709: p_msg_data=>x_msg_data,
1710: p_msg_type=>'UNEXPECTED ERROR',
1711: p_msg_level=>fnd_log.level_error);
1707: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1708: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1709: p_msg_data=>x_msg_data,
1710: p_msg_type=>'UNEXPECTED ERROR',
1711: p_msg_level=>fnd_log.level_error);
1712: END IF;
1713: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1714: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1715: p_prefix=>l_debug_prefix,
1709: p_msg_data=>x_msg_data,
1710: p_msg_type=>'UNEXPECTED ERROR',
1711: p_msg_level=>fnd_log.level_error);
1712: END IF;
1713: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1714: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1715: p_prefix=>l_debug_prefix,
1716: p_msg_level=>fnd_log.level_procedure);
1717: END IF;
1712: END IF;
1713: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1714: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1715: p_prefix=>l_debug_prefix,
1716: p_msg_level=>fnd_log.level_procedure);
1717: END IF;
1718:
1719: WHEN OTHERS THEN
1720: ROLLBACK TO save_car_pvt;
1732: p_count => x_msg_count,
1733: p_data => x_msg_data);
1734:
1735: -- Debug info.
1736: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1737: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1738: p_msg_data=>x_msg_data,
1739: p_msg_type=>'SQL ERROR',
1740: p_msg_level=>fnd_log.level_error);
1736: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1737: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1738: p_msg_data=>x_msg_data,
1739: p_msg_type=>'SQL ERROR',
1740: p_msg_level=>fnd_log.level_error);
1741: END IF;
1742: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1743: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1744: p_prefix=>l_debug_prefix,
1738: p_msg_data=>x_msg_data,
1739: p_msg_type=>'SQL ERROR',
1740: p_msg_level=>fnd_log.level_error);
1741: END IF;
1742: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1743: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1744: p_prefix=>l_debug_prefix,
1745: p_msg_level=>fnd_log.level_procedure);
1746: END IF;
1741: END IF;
1742: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1743: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1744: p_prefix=>l_debug_prefix,
1745: p_msg_level=>fnd_log.level_procedure);
1746: END IF;
1747: END save_cust_acct_relates;
1748:
1749: -- PROCEDURE save_bank_acct_uses
1794: -- initialize API return status to success.
1795: x_return_status := FND_API.G_RET_STS_SUCCESS;
1796:
1797: -- Debug info.
1798: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1799: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(+)',
1800: p_prefix=>l_debug_prefix,
1801: p_msg_level=>fnd_log.level_procedure);
1802: END IF;
1797: -- Debug info.
1798: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1799: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(+)',
1800: p_prefix=>l_debug_prefix,
1801: p_msg_level=>fnd_log.level_procedure);
1802: END IF;
1803:
1804: FOR i IN 1..p_bank_acct_use_objs.COUNT LOOP
1805: assign_bank_acct_use_rec(
1826: -- assign bank_acct_use_id
1827: p_bank_acct_use_objs(i).bank_acct_use_id := l_assign_id;
1828:
1829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1830: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1831: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_bank_acct_uses, cust acct id: '||p_ca_id||' cust site use id: '||p_casu_id,
1832: p_prefix=>l_debug_prefix,
1833: p_msg_level=>fnd_log.level_procedure);
1834: END IF;
1829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1830: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1831: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_bank_acct_uses, cust acct id: '||p_ca_id||' cust site use id: '||p_casu_id,
1832: p_prefix=>l_debug_prefix,
1833: p_msg_level=>fnd_log.level_procedure);
1834: END IF;
1835: RAISE FND_API.G_EXC_ERROR;
1836: END IF;
1837: END LOOP;
1836: END IF;
1837: END LOOP;
1838:
1839: -- Debug info.
1840: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1841: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1842: p_msg_data=>x_msg_data,
1843: p_msg_type=>'WARNING',
1844: p_msg_level=>fnd_log.level_exception);
1840: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1841: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1842: p_msg_data=>x_msg_data,
1843: p_msg_type=>'WARNING',
1844: p_msg_level=>fnd_log.level_exception);
1845: END IF;
1846: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1847: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1848: p_prefix=>l_debug_prefix,
1842: p_msg_data=>x_msg_data,
1843: p_msg_type=>'WARNING',
1844: p_msg_level=>fnd_log.level_exception);
1845: END IF;
1846: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1847: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1848: p_prefix=>l_debug_prefix,
1849: p_msg_level=>fnd_log.level_procedure);
1850: END IF;
1845: END IF;
1846: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1847: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1848: p_prefix=>l_debug_prefix,
1849: p_msg_level=>fnd_log.level_procedure);
1850: END IF;
1851: EXCEPTION
1852: WHEN fnd_api.g_exc_error THEN
1853: ROLLBACK TO save_bau_pvt;
1861: p_count => x_msg_count,
1862: p_data => x_msg_data);
1863:
1864: -- Debug info.
1865: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1866: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1867: p_msg_data=>x_msg_data,
1868: p_msg_type=>'ERROR',
1869: p_msg_level=>fnd_log.level_error);
1865: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1866: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1867: p_msg_data=>x_msg_data,
1868: p_msg_type=>'ERROR',
1869: p_msg_level=>fnd_log.level_error);
1870: END IF;
1871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1872: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1873: p_prefix=>l_debug_prefix,
1867: p_msg_data=>x_msg_data,
1868: p_msg_type=>'ERROR',
1869: p_msg_level=>fnd_log.level_error);
1870: END IF;
1871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1872: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1873: p_prefix=>l_debug_prefix,
1874: p_msg_level=>fnd_log.level_procedure);
1875: END IF;
1870: END IF;
1871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1872: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1873: p_prefix=>l_debug_prefix,
1874: p_msg_level=>fnd_log.level_procedure);
1875: END IF;
1876:
1877: WHEN fnd_api.g_exc_unexpected_error THEN
1878: ROLLBACK TO save_bau_pvt;
1886: p_count => x_msg_count,
1887: p_data => x_msg_data);
1888:
1889: -- Debug info.
1890: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1891: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1892: p_msg_data=>x_msg_data,
1893: p_msg_type=>'UNEXPECTED ERROR',
1894: p_msg_level=>fnd_log.level_error);
1890: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1891: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1892: p_msg_data=>x_msg_data,
1893: p_msg_type=>'UNEXPECTED ERROR',
1894: p_msg_level=>fnd_log.level_error);
1895: END IF;
1896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1897: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1898: p_prefix=>l_debug_prefix,
1892: p_msg_data=>x_msg_data,
1893: p_msg_type=>'UNEXPECTED ERROR',
1894: p_msg_level=>fnd_log.level_error);
1895: END IF;
1896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1897: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1898: p_prefix=>l_debug_prefix,
1899: p_msg_level=>fnd_log.level_procedure);
1900: END IF;
1895: END IF;
1896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1897: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1898: p_prefix=>l_debug_prefix,
1899: p_msg_level=>fnd_log.level_procedure);
1900: END IF;
1901:
1902: WHEN OTHERS THEN
1903: ROLLBACK TO save_bau_pvt;
1915: p_count => x_msg_count,
1916: p_data => x_msg_data);
1917:
1918: -- Debug info.
1919: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1920: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1921: p_msg_data=>x_msg_data,
1922: p_msg_type=>'SQL ERROR',
1923: p_msg_level=>fnd_log.level_error);
1919: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1920: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1921: p_msg_data=>x_msg_data,
1922: p_msg_type=>'SQL ERROR',
1923: p_msg_level=>fnd_log.level_error);
1924: END IF;
1925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1926: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1927: p_prefix=>l_debug_prefix,
1921: p_msg_data=>x_msg_data,
1922: p_msg_type=>'SQL ERROR',
1923: p_msg_level=>fnd_log.level_error);
1924: END IF;
1925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1926: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1927: p_prefix=>l_debug_prefix,
1928: p_msg_level=>fnd_log.level_procedure);
1929: END IF;
1924: END IF;
1925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1926: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1927: p_prefix=>l_debug_prefix,
1928: p_msg_level=>fnd_log.level_procedure);
1929: END IF;
1930: END save_bank_acct_uses;
1931:
1932: -- PROCEDURE create_payment_method
1973: -- initialize API return status to success.
1974: x_return_status := FND_API.G_RET_STS_SUCCESS;
1975:
1976: -- Debug info.
1977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1978: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',
1979: p_prefix=>l_debug_prefix,
1980: p_msg_level=>fnd_log.level_procedure);
1981: END IF;
1976: -- Debug info.
1977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1978: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',
1979: p_prefix=>l_debug_prefix,
1980: p_msg_level=>fnd_log.level_procedure);
1981: END IF;
1982:
1983: assign_payment_method_rec(
1984: p_payment_method_obj => p_payment_method_obj,
1995: x_msg_data => x_msg_data
1996: );
1997:
1998: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1999: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2000: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_payment_method, cust acct id: '||p_ca_id||' cust site use id: '||p_casu_id,
2001: p_prefix=>l_debug_prefix,
2002: p_msg_level=>fnd_log.level_procedure);
2003: END IF;
1998: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1999: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2000: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.create_payment_method, cust acct id: '||p_ca_id||' cust site use id: '||p_casu_id,
2001: p_prefix=>l_debug_prefix,
2002: p_msg_level=>fnd_log.level_procedure);
2003: END IF;
2004: RAISE FND_API.G_EXC_ERROR;
2005: END IF;
2006:
2007: -- assign payment_method_id
2008: p_payment_method_obj.payment_method_id := l_pm_id;
2009:
2010: -- Debug info.
2011: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2012: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2013: p_msg_data=>x_msg_data,
2014: p_msg_type=>'WARNING',
2015: p_msg_level=>fnd_log.level_exception);
2011: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2012: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2013: p_msg_data=>x_msg_data,
2014: p_msg_type=>'WARNING',
2015: p_msg_level=>fnd_log.level_exception);
2016: END IF;
2017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2018: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2019: p_prefix=>l_debug_prefix,
2013: p_msg_data=>x_msg_data,
2014: p_msg_type=>'WARNING',
2015: p_msg_level=>fnd_log.level_exception);
2016: END IF;
2017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2018: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2019: p_prefix=>l_debug_prefix,
2020: p_msg_level=>fnd_log.level_procedure);
2021: END IF;
2016: END IF;
2017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2018: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2019: p_prefix=>l_debug_prefix,
2020: p_msg_level=>fnd_log.level_procedure);
2021: END IF;
2022: EXCEPTION
2023: WHEN fnd_api.g_exc_error THEN
2024: ROLLBACK TO create_pm_pvt;
2032: p_count => x_msg_count,
2033: p_data => x_msg_data);
2034:
2035: -- Debug info.
2036: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2037: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2038: p_msg_data=>x_msg_data,
2039: p_msg_type=>'ERROR',
2040: p_msg_level=>fnd_log.level_error);
2036: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2037: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2038: p_msg_data=>x_msg_data,
2039: p_msg_type=>'ERROR',
2040: p_msg_level=>fnd_log.level_error);
2041: END IF;
2042: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2043: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2044: p_prefix=>l_debug_prefix,
2038: p_msg_data=>x_msg_data,
2039: p_msg_type=>'ERROR',
2040: p_msg_level=>fnd_log.level_error);
2041: END IF;
2042: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2043: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2044: p_prefix=>l_debug_prefix,
2045: p_msg_level=>fnd_log.level_procedure);
2046: END IF;
2041: END IF;
2042: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2043: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2044: p_prefix=>l_debug_prefix,
2045: p_msg_level=>fnd_log.level_procedure);
2046: END IF;
2047:
2048: WHEN fnd_api.g_exc_unexpected_error THEN
2049: ROLLBACK TO create_pm_pvt;
2057: p_count => x_msg_count,
2058: p_data => x_msg_data);
2059:
2060: -- Debug info.
2061: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2062: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2063: p_msg_data=>x_msg_data,
2064: p_msg_type=>'UNEXPECTED ERROR',
2065: p_msg_level=>fnd_log.level_error);
2061: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2062: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2063: p_msg_data=>x_msg_data,
2064: p_msg_type=>'UNEXPECTED ERROR',
2065: p_msg_level=>fnd_log.level_error);
2066: END IF;
2067: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2068: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2069: p_prefix=>l_debug_prefix,
2063: p_msg_data=>x_msg_data,
2064: p_msg_type=>'UNEXPECTED ERROR',
2065: p_msg_level=>fnd_log.level_error);
2066: END IF;
2067: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2068: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2069: p_prefix=>l_debug_prefix,
2070: p_msg_level=>fnd_log.level_procedure);
2071: END IF;
2066: END IF;
2067: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2068: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2069: p_prefix=>l_debug_prefix,
2070: p_msg_level=>fnd_log.level_procedure);
2071: END IF;
2072:
2073: WHEN OTHERS THEN
2074: ROLLBACK TO create_pm_pvt;
2086: p_count => x_msg_count,
2087: p_data => x_msg_data);
2088:
2089: -- Debug info.
2090: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2091: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2092: p_msg_data=>x_msg_data,
2093: p_msg_type=>'SQL ERROR',
2094: p_msg_level=>fnd_log.level_error);
2090: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2091: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2092: p_msg_data=>x_msg_data,
2093: p_msg_type=>'SQL ERROR',
2094: p_msg_level=>fnd_log.level_error);
2095: END IF;
2096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2097: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2098: p_prefix=>l_debug_prefix,
2092: p_msg_data=>x_msg_data,
2093: p_msg_type=>'SQL ERROR',
2094: p_msg_level=>fnd_log.level_error);
2095: END IF;
2096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2097: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2098: p_prefix=>l_debug_prefix,
2099: p_msg_level=>fnd_log.level_procedure);
2100: END IF;
2095: END IF;
2096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2097: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2098: p_prefix=>l_debug_prefix,
2099: p_msg_level=>fnd_log.level_procedure);
2100: END IF;
2101: END create_payment_method;
2102:
2103: -- PROCEDURE save_payment_method
2145: -- initialize API return status to success.
2146: x_return_status := FND_API.G_RET_STS_SUCCESS;
2147:
2148: -- Debug info.
2149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2150: hz_utility_v2pub.debug(p_message=>'save_payment_method(+)',
2151: p_prefix=>l_debug_prefix,
2152: p_msg_level=>fnd_log.level_procedure);
2153: END IF;
2148: -- Debug info.
2149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2150: hz_utility_v2pub.debug(p_message=>'save_payment_method(+)',
2151: p_prefix=>l_debug_prefix,
2152: p_msg_level=>fnd_log.level_procedure);
2153: END IF;
2154:
2155: assign_payment_method_rec(
2156: p_payment_method_obj => p_payment_method_obj,
2188: p_payment_method_obj.payment_method_id := l_payment_method_rec.cust_receipt_method_id;
2189: END IF;
2190:
2191: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2193: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_payment_method, cust acct id: '||p_ca_id||' cust site use id: '||p_casu_id,
2194: p_prefix=>l_debug_prefix,
2195: p_msg_level=>fnd_log.level_procedure);
2196: END IF;
2191: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2193: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_bo_pvt.save_payment_method, cust acct id: '||p_ca_id||' cust site use id: '||p_casu_id,
2194: p_prefix=>l_debug_prefix,
2195: p_msg_level=>fnd_log.level_procedure);
2196: END IF;
2197: RAISE FND_API.G_EXC_ERROR;
2198: END IF;
2199:
2197: RAISE FND_API.G_EXC_ERROR;
2198: END IF;
2199:
2200: -- Debug info.
2201: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2202: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2203: p_msg_data=>x_msg_data,
2204: p_msg_type=>'WARNING',
2205: p_msg_level=>fnd_log.level_exception);
2201: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2202: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2203: p_msg_data=>x_msg_data,
2204: p_msg_type=>'WARNING',
2205: p_msg_level=>fnd_log.level_exception);
2206: END IF;
2207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2209: p_prefix=>l_debug_prefix,
2203: p_msg_data=>x_msg_data,
2204: p_msg_type=>'WARNING',
2205: p_msg_level=>fnd_log.level_exception);
2206: END IF;
2207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2209: p_prefix=>l_debug_prefix,
2210: p_msg_level=>fnd_log.level_procedure);
2211: END IF;
2206: END IF;
2207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2208: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2209: p_prefix=>l_debug_prefix,
2210: p_msg_level=>fnd_log.level_procedure);
2211: END IF;
2212: EXCEPTION
2213: WHEN fnd_api.g_exc_error THEN
2214: ROLLBACK TO save_pm_pvt;
2222: p_count => x_msg_count,
2223: p_data => x_msg_data);
2224:
2225: -- Debug info.
2226: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2227: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2228: p_msg_data=>x_msg_data,
2229: p_msg_type=>'ERROR',
2230: p_msg_level=>fnd_log.level_error);
2226: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2227: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2228: p_msg_data=>x_msg_data,
2229: p_msg_type=>'ERROR',
2230: p_msg_level=>fnd_log.level_error);
2231: END IF;
2232: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2233: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2234: p_prefix=>l_debug_prefix,
2228: p_msg_data=>x_msg_data,
2229: p_msg_type=>'ERROR',
2230: p_msg_level=>fnd_log.level_error);
2231: END IF;
2232: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2233: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2234: p_prefix=>l_debug_prefix,
2235: p_msg_level=>fnd_log.level_procedure);
2236: END IF;
2231: END IF;
2232: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2233: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2234: p_prefix=>l_debug_prefix,
2235: p_msg_level=>fnd_log.level_procedure);
2236: END IF;
2237:
2238: WHEN fnd_api.g_exc_unexpected_error THEN
2239: ROLLBACK TO save_pm_pvt;
2247: p_count => x_msg_count,
2248: p_data => x_msg_data);
2249:
2250: -- Debug info.
2251: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2252: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2253: p_msg_data=>x_msg_data,
2254: p_msg_type=>'UNEXPECTED ERROR',
2255: p_msg_level=>fnd_log.level_error);
2251: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2252: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2253: p_msg_data=>x_msg_data,
2254: p_msg_type=>'UNEXPECTED ERROR',
2255: p_msg_level=>fnd_log.level_error);
2256: END IF;
2257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2258: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2259: p_prefix=>l_debug_prefix,
2253: p_msg_data=>x_msg_data,
2254: p_msg_type=>'UNEXPECTED ERROR',
2255: p_msg_level=>fnd_log.level_error);
2256: END IF;
2257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2258: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2259: p_prefix=>l_debug_prefix,
2260: p_msg_level=>fnd_log.level_procedure);
2261: END IF;
2256: END IF;
2257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2258: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2259: p_prefix=>l_debug_prefix,
2260: p_msg_level=>fnd_log.level_procedure);
2261: END IF;
2262:
2263: WHEN OTHERS THEN
2264: ROLLBACK TO save_pm_pvt;
2276: p_count => x_msg_count,
2277: p_data => x_msg_data);
2278:
2279: -- Debug info.
2280: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2281: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2282: p_msg_data=>x_msg_data,
2283: p_msg_type=>'SQL ERROR',
2284: p_msg_level=>fnd_log.level_error);
2280: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2281: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2282: p_msg_data=>x_msg_data,
2283: p_msg_type=>'SQL ERROR',
2284: p_msg_level=>fnd_log.level_error);
2285: END IF;
2286: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2287: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2288: p_prefix=>l_debug_prefix,
2282: p_msg_data=>x_msg_data,
2283: p_msg_type=>'SQL ERROR',
2284: p_msg_level=>fnd_log.level_error);
2285: END IF;
2286: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2287: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2288: p_prefix=>l_debug_prefix,
2289: p_msg_level=>fnd_log.level_procedure);
2290: END IF;
2285: END IF;
2286: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2287: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2288: p_prefix=>l_debug_prefix,
2289: p_msg_level=>fnd_log.level_procedure);
2290: END IF;
2291: END save_payment_method;
2292:
2293: -- PROCEDURE save_cust_accts
2344: -- initialize API return status to success
2345: x_return_status := FND_API.G_RET_STS_SUCCESS;
2346:
2347: -- Debug info.
2348: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2349: hz_utility_v2pub.debug(p_message=>'save_cust_accts(+)',
2350: p_prefix=>l_debug_prefix,
2351: p_msg_level=>fnd_log.level_procedure);
2352: END IF;
2347: -- Debug info.
2348: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2349: hz_utility_v2pub.debug(p_message=>'save_cust_accts(+)',
2350: p_prefix=>l_debug_prefix,
2351: p_msg_level=>fnd_log.level_procedure);
2352: END IF;
2353:
2354: l_parent_id := p_parent_id;
2355: l_parent_os := p_parent_os;
2378: px_parent_obj_type => l_parent_obj_type
2379: );
2380:
2381: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2382: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2383: hz_utility_v2pub.debug(p_message=>'Create error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2384: p_prefix=>l_debug_prefix,
2385: p_msg_level=>fnd_log.level_procedure);
2386: END IF;
2381: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2382: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2383: hz_utility_v2pub.debug(p_message=>'Create error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2384: p_prefix=>l_debug_prefix,
2385: p_msg_level=>fnd_log.level_procedure);
2386: END IF;
2387: RAISE FND_API.G_EXC_ERROR;
2388: END IF;
2389:
2409: px_parent_obj_type => l_parent_obj_type
2410: );
2411:
2412: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2413: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2414: hz_utility_v2pub.debug(p_message=>'Save error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2415: p_prefix=>l_debug_prefix,
2416: p_msg_level=>fnd_log.level_procedure);
2417: END IF;
2412: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2413: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2414: hz_utility_v2pub.debug(p_message=>'Save error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2415: p_prefix=>l_debug_prefix,
2416: p_msg_level=>fnd_log.level_procedure);
2417: END IF;
2418: RAISE FND_API.G_EXC_ERROR;
2419: END IF;
2420:
2422: END LOOP;
2423: END IF;
2424:
2425: -- Debug info.
2426: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2427: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2428: p_msg_data=>x_msg_data,
2429: p_msg_type=>'WARNING',
2430: p_msg_level=>fnd_log.level_exception);
2426: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2427: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2428: p_msg_data=>x_msg_data,
2429: p_msg_type=>'WARNING',
2430: p_msg_level=>fnd_log.level_exception);
2431: END IF;
2432: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2433: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2434: p_prefix=>l_debug_prefix,
2428: p_msg_data=>x_msg_data,
2429: p_msg_type=>'WARNING',
2430: p_msg_level=>fnd_log.level_exception);
2431: END IF;
2432: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2433: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2434: p_prefix=>l_debug_prefix,
2435: p_msg_level=>fnd_log.level_procedure);
2436: END IF;
2431: END IF;
2432: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2433: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2434: p_prefix=>l_debug_prefix,
2435: p_msg_level=>fnd_log.level_procedure);
2436: END IF;
2437: EXCEPTION
2438: WHEN fnd_api.g_exc_error THEN
2439: x_return_status := fnd_api.g_ret_sts_error;
2442: p_count => x_msg_count,
2443: p_data => x_msg_data);
2444:
2445: -- Debug info.
2446: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2447: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2448: p_msg_data=>x_msg_data,
2449: p_msg_type=>'ERROR',
2450: p_msg_level=>fnd_log.level_error);
2446: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2447: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2448: p_msg_data=>x_msg_data,
2449: p_msg_type=>'ERROR',
2450: p_msg_level=>fnd_log.level_error);
2451: END IF;
2452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2453: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2454: p_prefix=>l_debug_prefix,
2448: p_msg_data=>x_msg_data,
2449: p_msg_type=>'ERROR',
2450: p_msg_level=>fnd_log.level_error);
2451: END IF;
2452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2453: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2454: p_prefix=>l_debug_prefix,
2455: p_msg_level=>fnd_log.level_procedure);
2456: END IF;
2451: END IF;
2452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2453: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2454: p_prefix=>l_debug_prefix,
2455: p_msg_level=>fnd_log.level_procedure);
2456: END IF;
2457: WHEN fnd_api.g_exc_unexpected_error THEN
2458: x_return_status := fnd_api.g_ret_sts_unexp_error;
2459:
2461: p_count => x_msg_count,
2462: p_data => x_msg_data);
2463:
2464: -- Debug info.
2465: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2466: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2467: p_msg_data=>x_msg_data,
2468: p_msg_type=>'UNEXPECTED ERROR',
2469: p_msg_level=>fnd_log.level_error);
2465: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2466: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2467: p_msg_data=>x_msg_data,
2468: p_msg_type=>'UNEXPECTED ERROR',
2469: p_msg_level=>fnd_log.level_error);
2470: END IF;
2471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2472: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2473: p_prefix=>l_debug_prefix,
2467: p_msg_data=>x_msg_data,
2468: p_msg_type=>'UNEXPECTED ERROR',
2469: p_msg_level=>fnd_log.level_error);
2470: END IF;
2471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2472: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2473: p_prefix=>l_debug_prefix,
2474: p_msg_level=>fnd_log.level_procedure);
2475: END IF;
2470: END IF;
2471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2472: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2473: p_prefix=>l_debug_prefix,
2474: p_msg_level=>fnd_log.level_procedure);
2475: END IF;
2476: WHEN OTHERS THEN
2477: x_return_status := fnd_api.g_ret_sts_unexp_error;
2478:
2484: p_count => x_msg_count,
2485: p_data => x_msg_data);
2486:
2487: -- Debug info.
2488: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2489: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2490: p_msg_data=>x_msg_data,
2491: p_msg_type=>'SQL ERROR',
2492: p_msg_level=>fnd_log.level_error);
2488: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2489: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2490: p_msg_data=>x_msg_data,
2491: p_msg_type=>'SQL ERROR',
2492: p_msg_level=>fnd_log.level_error);
2493: END IF;
2494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2495: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2496: p_prefix=>l_debug_prefix,
2490: p_msg_data=>x_msg_data,
2491: p_msg_type=>'SQL ERROR',
2492: p_msg_level=>fnd_log.level_error);
2493: END IF;
2494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2495: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2496: p_prefix=>l_debug_prefix,
2497: p_msg_level=>fnd_log.level_procedure);
2498: END IF;
2493: END IF;
2494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2495: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2496: p_prefix=>l_debug_prefix,
2497: p_msg_level=>fnd_log.level_procedure);
2498: END IF;
2499: END save_cust_accts;
2500:
2501: -- PROCEDURE create_payment_methods
2540: -- initialize API return status to success.
2541: x_return_status := FND_API.G_RET_STS_SUCCESS;
2542:
2543: -- Debug info.
2544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2545: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',
2546: p_prefix=>l_debug_prefix,
2547: p_msg_level=>fnd_log.level_procedure);
2548: END IF;
2543: -- Debug info.
2544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2545: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',
2546: p_prefix=>l_debug_prefix,
2547: p_msg_level=>fnd_log.level_procedure);
2548: END IF;
2549:
2550: FOR i IN 1..p_payment_method_objs.COUNT LOOP
2551:
2574: p_count => x_msg_count,
2575: p_data => x_msg_data);
2576:
2577: -- Debug info.
2578: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2579: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2580: p_msg_data=>x_msg_data,
2581: p_msg_type=>'ERROR',
2582: p_msg_level=>fnd_log.level_error);
2578: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2579: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2580: p_msg_data=>x_msg_data,
2581: p_msg_type=>'ERROR',
2582: p_msg_level=>fnd_log.level_error);
2583: END IF;
2584: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2585: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2586: p_prefix=>l_debug_prefix,
2580: p_msg_data=>x_msg_data,
2581: p_msg_type=>'ERROR',
2582: p_msg_level=>fnd_log.level_error);
2583: END IF;
2584: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2585: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2586: p_prefix=>l_debug_prefix,
2587: p_msg_level=>fnd_log.level_procedure);
2588: END IF;
2583: END IF;
2584: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2585: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2586: p_prefix=>l_debug_prefix,
2587: p_msg_level=>fnd_log.level_procedure);
2588: END IF;
2589:
2590: WHEN fnd_api.g_exc_unexpected_error THEN
2591: ROLLBACK TO create_pms_v2_pvt;
2596: p_count => x_msg_count,
2597: p_data => x_msg_data);
2598:
2599: -- Debug info.
2600: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2601: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2602: p_msg_data=>x_msg_data,
2603: p_msg_type=>'UNEXPECTED ERROR',
2604: p_msg_level=>fnd_log.level_error);
2600: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2601: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2602: p_msg_data=>x_msg_data,
2603: p_msg_type=>'UNEXPECTED ERROR',
2604: p_msg_level=>fnd_log.level_error);
2605: END IF;
2606: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2607: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2608: p_prefix=>l_debug_prefix,
2602: p_msg_data=>x_msg_data,
2603: p_msg_type=>'UNEXPECTED ERROR',
2604: p_msg_level=>fnd_log.level_error);
2605: END IF;
2606: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2607: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2608: p_prefix=>l_debug_prefix,
2609: p_msg_level=>fnd_log.level_procedure);
2610: END IF;
2605: END IF;
2606: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2607: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2608: p_prefix=>l_debug_prefix,
2609: p_msg_level=>fnd_log.level_procedure);
2610: END IF;
2611:
2612: WHEN OTHERS THEN
2613: ROLLBACK TO create_pms_v2_pvt;
2622: p_count => x_msg_count,
2623: p_data => x_msg_data);
2624:
2625: -- Debug info.
2626: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2627: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2628: p_msg_data=>x_msg_data,
2629: p_msg_type=>'SQL ERROR',
2630: p_msg_level=>fnd_log.level_error);
2626: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2627: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2628: p_msg_data=>x_msg_data,
2629: p_msg_type=>'SQL ERROR',
2630: p_msg_level=>fnd_log.level_error);
2631: END IF;
2632: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2633: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2634: p_prefix=>l_debug_prefix,
2628: p_msg_data=>x_msg_data,
2629: p_msg_type=>'SQL ERROR',
2630: p_msg_level=>fnd_log.level_error);
2631: END IF;
2632: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2633: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2634: p_prefix=>l_debug_prefix,
2635: p_msg_level=>fnd_log.level_procedure);
2636: END IF;
2631: END IF;
2632: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2633: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2634: p_prefix=>l_debug_prefix,
2635: p_msg_level=>fnd_log.level_procedure);
2636: END IF;
2637: END create_payment_methods;
2638:
2639: -- PROCEDURE save_payment_methods
2678: -- initialize API return status to success.
2679: x_return_status := FND_API.G_RET_STS_SUCCESS;
2680:
2681: -- Debug info.
2682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2683: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',
2684: p_prefix=>l_debug_prefix,
2685: p_msg_level=>fnd_log.level_procedure);
2686: END IF;
2681: -- Debug info.
2682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2683: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',
2684: p_prefix=>l_debug_prefix,
2685: p_msg_level=>fnd_log.level_procedure);
2686: END IF;
2687:
2688: FOR i IN 1..p_payment_method_objs.COUNT LOOP
2689:
2715: p_count => x_msg_count,
2716: p_data => x_msg_data);
2717:
2718: -- Debug info.
2719: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2720: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2721: p_msg_data=>x_msg_data,
2722: p_msg_type=>'ERROR',
2723: p_msg_level=>fnd_log.level_error);
2719: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2720: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2721: p_msg_data=>x_msg_data,
2722: p_msg_type=>'ERROR',
2723: p_msg_level=>fnd_log.level_error);
2724: END IF;
2725: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2726: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2727: p_prefix=>l_debug_prefix,
2721: p_msg_data=>x_msg_data,
2722: p_msg_type=>'ERROR',
2723: p_msg_level=>fnd_log.level_error);
2724: END IF;
2725: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2726: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2727: p_prefix=>l_debug_prefix,
2728: p_msg_level=>fnd_log.level_procedure);
2729: END IF;
2724: END IF;
2725: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2726: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2727: p_prefix=>l_debug_prefix,
2728: p_msg_level=>fnd_log.level_procedure);
2729: END IF;
2730:
2731: WHEN fnd_api.g_exc_unexpected_error THEN
2732: ROLLBACK TO save_pm_v2_pvt;
2740: p_count => x_msg_count,
2741: p_data => x_msg_data);
2742:
2743: -- Debug info.
2744: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2745: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2746: p_msg_data=>x_msg_data,
2747: p_msg_type=>'UNEXPECTED ERROR',
2748: p_msg_level=>fnd_log.level_error);
2744: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2745: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2746: p_msg_data=>x_msg_data,
2747: p_msg_type=>'UNEXPECTED ERROR',
2748: p_msg_level=>fnd_log.level_error);
2749: END IF;
2750: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2751: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2752: p_prefix=>l_debug_prefix,
2746: p_msg_data=>x_msg_data,
2747: p_msg_type=>'UNEXPECTED ERROR',
2748: p_msg_level=>fnd_log.level_error);
2749: END IF;
2750: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2751: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2752: p_prefix=>l_debug_prefix,
2753: p_msg_level=>fnd_log.level_procedure);
2754: END IF;
2749: END IF;
2750: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2751: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2752: p_prefix=>l_debug_prefix,
2753: p_msg_level=>fnd_log.level_procedure);
2754: END IF;
2755:
2756: WHEN OTHERS THEN
2757: ROLLBACK TO save_pm_v2_pvt;
2769: p_count => x_msg_count,
2770: p_data => x_msg_data);
2771:
2772: -- Debug info.
2773: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2774: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2775: p_msg_data=>x_msg_data,
2776: p_msg_type=>'SQL ERROR',
2777: p_msg_level=>fnd_log.level_error);
2773: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2774: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2775: p_msg_data=>x_msg_data,
2776: p_msg_type=>'SQL ERROR',
2777: p_msg_level=>fnd_log.level_error);
2778: END IF;
2779: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2780: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2781: p_prefix=>l_debug_prefix,
2775: p_msg_data=>x_msg_data,
2776: p_msg_type=>'SQL ERROR',
2777: p_msg_level=>fnd_log.level_error);
2778: END IF;
2779: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2780: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2781: p_prefix=>l_debug_prefix,
2782: p_msg_level=>fnd_log.level_procedure);
2783: END IF;
2778: END IF;
2779: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2780: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2781: p_prefix=>l_debug_prefix,
2782: p_msg_level=>fnd_log.level_procedure);
2783: END IF;
2784: END save_payment_methods;
2785:
2786: -- PROCEDURE save_cust_accts
2837: -- initialize API return status to success
2838: x_return_status := FND_API.G_RET_STS_SUCCESS;
2839:
2840: -- Debug info.
2841: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2842: hz_utility_v2pub.debug(p_message=>'save_cust_accts(+)',
2843: p_prefix=>l_debug_prefix,
2844: p_msg_level=>fnd_log.level_procedure);
2845: END IF;
2840: -- Debug info.
2841: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2842: hz_utility_v2pub.debug(p_message=>'save_cust_accts(+)',
2843: p_prefix=>l_debug_prefix,
2844: p_msg_level=>fnd_log.level_procedure);
2845: END IF;
2846:
2847: l_parent_id := p_parent_id;
2848: l_parent_os := p_parent_os;
2871: px_parent_obj_type => l_parent_obj_type
2872: );
2873:
2874: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2875: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2876: hz_utility_v2pub.debug(p_message=>'Create error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2877: p_prefix=>l_debug_prefix,
2878: p_msg_level=>fnd_log.level_procedure);
2879: END IF;
2874: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2875: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2876: hz_utility_v2pub.debug(p_message=>'Create error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2877: p_prefix=>l_debug_prefix,
2878: p_msg_level=>fnd_log.level_procedure);
2879: END IF;
2880: RAISE FND_API.G_EXC_ERROR;
2881: END IF;
2882:
2902: px_parent_obj_type => l_parent_obj_type
2903: );
2904:
2905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2907: hz_utility_v2pub.debug(p_message=>'Save error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2908: p_prefix=>l_debug_prefix,
2909: p_msg_level=>fnd_log.level_procedure);
2910: END IF;
2905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2907: hz_utility_v2pub.debug(p_message=>'Save error occurred at hz_cust_acct_bo_pvt.save_cust_accts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
2908: p_prefix=>l_debug_prefix,
2909: p_msg_level=>fnd_log.level_procedure);
2910: END IF;
2911: RAISE FND_API.G_EXC_ERROR;
2912: END IF;
2913:
2915: END LOOP;
2916: END IF;
2917:
2918: -- Debug info.
2919: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2920: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2921: p_msg_data=>x_msg_data,
2922: p_msg_type=>'WARNING',
2923: p_msg_level=>fnd_log.level_exception);
2919: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2920: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2921: p_msg_data=>x_msg_data,
2922: p_msg_type=>'WARNING',
2923: p_msg_level=>fnd_log.level_exception);
2924: END IF;
2925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2926: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2927: p_prefix=>l_debug_prefix,
2921: p_msg_data=>x_msg_data,
2922: p_msg_type=>'WARNING',
2923: p_msg_level=>fnd_log.level_exception);
2924: END IF;
2925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2926: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2927: p_prefix=>l_debug_prefix,
2928: p_msg_level=>fnd_log.level_procedure);
2929: END IF;
2924: END IF;
2925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2926: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2927: p_prefix=>l_debug_prefix,
2928: p_msg_level=>fnd_log.level_procedure);
2929: END IF;
2930: EXCEPTION
2931: WHEN fnd_api.g_exc_error THEN
2932: x_return_status := fnd_api.g_ret_sts_error;
2935: p_count => x_msg_count,
2936: p_data => x_msg_data);
2937:
2938: -- Debug info.
2939: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2940: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2941: p_msg_data=>x_msg_data,
2942: p_msg_type=>'ERROR',
2943: p_msg_level=>fnd_log.level_error);
2939: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2940: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2941: p_msg_data=>x_msg_data,
2942: p_msg_type=>'ERROR',
2943: p_msg_level=>fnd_log.level_error);
2944: END IF;
2945: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2946: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2947: p_prefix=>l_debug_prefix,
2941: p_msg_data=>x_msg_data,
2942: p_msg_type=>'ERROR',
2943: p_msg_level=>fnd_log.level_error);
2944: END IF;
2945: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2946: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2947: p_prefix=>l_debug_prefix,
2948: p_msg_level=>fnd_log.level_procedure);
2949: END IF;
2944: END IF;
2945: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2946: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2947: p_prefix=>l_debug_prefix,
2948: p_msg_level=>fnd_log.level_procedure);
2949: END IF;
2950: WHEN fnd_api.g_exc_unexpected_error THEN
2951: x_return_status := fnd_api.g_ret_sts_unexp_error;
2952:
2954: p_count => x_msg_count,
2955: p_data => x_msg_data);
2956:
2957: -- Debug info.
2958: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2959: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2960: p_msg_data=>x_msg_data,
2961: p_msg_type=>'UNEXPECTED ERROR',
2962: p_msg_level=>fnd_log.level_error);
2958: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2959: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2960: p_msg_data=>x_msg_data,
2961: p_msg_type=>'UNEXPECTED ERROR',
2962: p_msg_level=>fnd_log.level_error);
2963: END IF;
2964: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2965: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2966: p_prefix=>l_debug_prefix,
2960: p_msg_data=>x_msg_data,
2961: p_msg_type=>'UNEXPECTED ERROR',
2962: p_msg_level=>fnd_log.level_error);
2963: END IF;
2964: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2965: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2966: p_prefix=>l_debug_prefix,
2967: p_msg_level=>fnd_log.level_procedure);
2968: END IF;
2963: END IF;
2964: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2965: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2966: p_prefix=>l_debug_prefix,
2967: p_msg_level=>fnd_log.level_procedure);
2968: END IF;
2969: WHEN OTHERS THEN
2970: x_return_status := fnd_api.g_ret_sts_unexp_error;
2971:
2977: p_count => x_msg_count,
2978: p_data => x_msg_data);
2979:
2980: -- Debug info.
2981: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2982: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2983: p_msg_data=>x_msg_data,
2984: p_msg_type=>'SQL ERROR',
2985: p_msg_level=>fnd_log.level_error);
2981: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2982: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2983: p_msg_data=>x_msg_data,
2984: p_msg_type=>'SQL ERROR',
2985: p_msg_level=>fnd_log.level_error);
2986: END IF;
2987: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2988: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2989: p_prefix=>l_debug_prefix,
2983: p_msg_data=>x_msg_data,
2984: p_msg_type=>'SQL ERROR',
2985: p_msg_level=>fnd_log.level_error);
2986: END IF;
2987: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2988: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2989: p_prefix=>l_debug_prefix,
2990: p_msg_level=>fnd_log.level_procedure);
2991: END IF;
2986: END IF;
2987: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2988: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2989: p_prefix=>l_debug_prefix,
2990: p_msg_level=>fnd_log.level_procedure);
2991: END IF;
2992: END save_cust_accts;
2993:
2994: