[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
1636: );
1637: END IF;
1638:
1639: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1640: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1641: 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,
1642: p_prefix=>l_debug_prefix,
1643: p_msg_level=>fnd_log.level_procedure);
1644: END IF;
1639: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1640: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1641: 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,
1642: p_prefix=>l_debug_prefix,
1643: p_msg_level=>fnd_log.level_procedure);
1644: END IF;
1645: RAISE FND_API.G_EXC_ERROR;
1646: END IF;
1647: ELSE
1644: END IF;
1645: RAISE FND_API.G_EXC_ERROR;
1646: END IF;
1647: ELSE
1648: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1649: 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,
1650: p_prefix=>l_debug_prefix,
1651: p_msg_level=>fnd_log.level_procedure);
1652: END IF;
1647: ELSE
1648: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1649: 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,
1650: p_prefix=>l_debug_prefix,
1651: p_msg_level=>fnd_log.level_procedure);
1652: END IF;
1653: RAISE FND_API.G_EXC_ERROR;
1654: END IF;
1655: END LOOP;
1654: END IF;
1655: END LOOP;
1656:
1657: -- Debug info.
1658: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1659: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1660: p_msg_data=>x_msg_data,
1661: p_msg_type=>'WARNING',
1662: p_msg_level=>fnd_log.level_exception);
1658: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1659: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1660: p_msg_data=>x_msg_data,
1661: p_msg_type=>'WARNING',
1662: p_msg_level=>fnd_log.level_exception);
1663: END IF;
1664: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1665: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1666: p_prefix=>l_debug_prefix,
1660: p_msg_data=>x_msg_data,
1661: p_msg_type=>'WARNING',
1662: p_msg_level=>fnd_log.level_exception);
1663: END IF;
1664: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1665: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1666: p_prefix=>l_debug_prefix,
1667: p_msg_level=>fnd_log.level_procedure);
1668: END IF;
1663: END IF;
1664: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1665: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1666: p_prefix=>l_debug_prefix,
1667: p_msg_level=>fnd_log.level_procedure);
1668: END IF;
1669: EXCEPTION
1670: WHEN fnd_api.g_exc_error THEN
1671: ROLLBACK TO save_car_pvt;
1679: p_count => x_msg_count,
1680: p_data => x_msg_data);
1681:
1682: -- Debug info.
1683: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1684: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1685: p_msg_data=>x_msg_data,
1686: p_msg_type=>'ERROR',
1687: p_msg_level=>fnd_log.level_error);
1683: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1684: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1685: p_msg_data=>x_msg_data,
1686: p_msg_type=>'ERROR',
1687: p_msg_level=>fnd_log.level_error);
1688: END IF;
1689: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1690: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1691: p_prefix=>l_debug_prefix,
1685: p_msg_data=>x_msg_data,
1686: p_msg_type=>'ERROR',
1687: p_msg_level=>fnd_log.level_error);
1688: END IF;
1689: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1690: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1691: p_prefix=>l_debug_prefix,
1692: p_msg_level=>fnd_log.level_procedure);
1693: END IF;
1688: END IF;
1689: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1690: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1691: p_prefix=>l_debug_prefix,
1692: p_msg_level=>fnd_log.level_procedure);
1693: END IF;
1694:
1695: WHEN fnd_api.g_exc_unexpected_error THEN
1696: ROLLBACK TO save_car_pvt;
1704: p_count => x_msg_count,
1705: p_data => x_msg_data);
1706:
1707: -- Debug info.
1708: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1709: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1710: p_msg_data=>x_msg_data,
1711: p_msg_type=>'UNEXPECTED ERROR',
1712: p_msg_level=>fnd_log.level_error);
1708: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1709: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1710: p_msg_data=>x_msg_data,
1711: p_msg_type=>'UNEXPECTED ERROR',
1712: p_msg_level=>fnd_log.level_error);
1713: END IF;
1714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1715: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1716: p_prefix=>l_debug_prefix,
1710: p_msg_data=>x_msg_data,
1711: p_msg_type=>'UNEXPECTED ERROR',
1712: p_msg_level=>fnd_log.level_error);
1713: END IF;
1714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1715: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1716: p_prefix=>l_debug_prefix,
1717: p_msg_level=>fnd_log.level_procedure);
1718: END IF;
1713: END IF;
1714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1715: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1716: p_prefix=>l_debug_prefix,
1717: p_msg_level=>fnd_log.level_procedure);
1718: END IF;
1719:
1720: WHEN OTHERS THEN
1721: ROLLBACK TO save_car_pvt;
1733: p_count => x_msg_count,
1734: p_data => x_msg_data);
1735:
1736: -- Debug info.
1737: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1738: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1739: p_msg_data=>x_msg_data,
1740: p_msg_type=>'SQL ERROR',
1741: p_msg_level=>fnd_log.level_error);
1737: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1738: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1739: p_msg_data=>x_msg_data,
1740: p_msg_type=>'SQL ERROR',
1741: p_msg_level=>fnd_log.level_error);
1742: END IF;
1743: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1744: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1745: p_prefix=>l_debug_prefix,
1739: p_msg_data=>x_msg_data,
1740: p_msg_type=>'SQL ERROR',
1741: p_msg_level=>fnd_log.level_error);
1742: END IF;
1743: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1744: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1745: p_prefix=>l_debug_prefix,
1746: p_msg_level=>fnd_log.level_procedure);
1747: END IF;
1742: END IF;
1743: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1744: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',
1745: p_prefix=>l_debug_prefix,
1746: p_msg_level=>fnd_log.level_procedure);
1747: END IF;
1748: END save_cust_acct_relates;
1749:
1750: -- PROCEDURE save_bank_acct_uses
1795: -- initialize API return status to success.
1796: x_return_status := FND_API.G_RET_STS_SUCCESS;
1797:
1798: -- Debug info.
1799: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1800: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(+)',
1801: p_prefix=>l_debug_prefix,
1802: p_msg_level=>fnd_log.level_procedure);
1803: END IF;
1798: -- Debug info.
1799: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1800: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(+)',
1801: p_prefix=>l_debug_prefix,
1802: p_msg_level=>fnd_log.level_procedure);
1803: END IF;
1804:
1805: FOR i IN 1..p_bank_acct_use_objs.COUNT LOOP
1806: assign_bank_acct_use_rec(
1827: -- assign bank_acct_use_id
1828: p_bank_acct_use_objs(i).bank_acct_use_id := l_assign_id;
1829:
1830: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1831: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1832: 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,
1833: p_prefix=>l_debug_prefix,
1834: p_msg_level=>fnd_log.level_procedure);
1835: END IF;
1830: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1831: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1832: 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,
1833: p_prefix=>l_debug_prefix,
1834: p_msg_level=>fnd_log.level_procedure);
1835: END IF;
1836: RAISE FND_API.G_EXC_ERROR;
1837: END IF;
1838: END LOOP;
1837: END IF;
1838: END LOOP;
1839:
1840: -- Debug info.
1841: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1842: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1843: p_msg_data=>x_msg_data,
1844: p_msg_type=>'WARNING',
1845: p_msg_level=>fnd_log.level_exception);
1841: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1842: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1843: p_msg_data=>x_msg_data,
1844: p_msg_type=>'WARNING',
1845: p_msg_level=>fnd_log.level_exception);
1846: END IF;
1847: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1848: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1849: p_prefix=>l_debug_prefix,
1843: p_msg_data=>x_msg_data,
1844: p_msg_type=>'WARNING',
1845: p_msg_level=>fnd_log.level_exception);
1846: END IF;
1847: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1848: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1849: p_prefix=>l_debug_prefix,
1850: p_msg_level=>fnd_log.level_procedure);
1851: END IF;
1846: END IF;
1847: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1848: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1849: p_prefix=>l_debug_prefix,
1850: p_msg_level=>fnd_log.level_procedure);
1851: END IF;
1852: EXCEPTION
1853: WHEN fnd_api.g_exc_error THEN
1854: ROLLBACK TO save_bau_pvt;
1862: p_count => x_msg_count,
1863: p_data => x_msg_data);
1864:
1865: -- Debug info.
1866: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1867: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1868: p_msg_data=>x_msg_data,
1869: p_msg_type=>'ERROR',
1870: p_msg_level=>fnd_log.level_error);
1866: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1867: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1868: p_msg_data=>x_msg_data,
1869: p_msg_type=>'ERROR',
1870: p_msg_level=>fnd_log.level_error);
1871: END IF;
1872: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1873: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1874: p_prefix=>l_debug_prefix,
1868: p_msg_data=>x_msg_data,
1869: p_msg_type=>'ERROR',
1870: p_msg_level=>fnd_log.level_error);
1871: END IF;
1872: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1873: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1874: p_prefix=>l_debug_prefix,
1875: p_msg_level=>fnd_log.level_procedure);
1876: END IF;
1871: END IF;
1872: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1873: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1874: p_prefix=>l_debug_prefix,
1875: p_msg_level=>fnd_log.level_procedure);
1876: END IF;
1877:
1878: WHEN fnd_api.g_exc_unexpected_error THEN
1879: ROLLBACK TO save_bau_pvt;
1887: p_count => x_msg_count,
1888: p_data => x_msg_data);
1889:
1890: -- Debug info.
1891: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1892: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1893: p_msg_data=>x_msg_data,
1894: p_msg_type=>'UNEXPECTED ERROR',
1895: p_msg_level=>fnd_log.level_error);
1891: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1892: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1893: p_msg_data=>x_msg_data,
1894: p_msg_type=>'UNEXPECTED ERROR',
1895: p_msg_level=>fnd_log.level_error);
1896: END IF;
1897: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1898: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1899: p_prefix=>l_debug_prefix,
1893: p_msg_data=>x_msg_data,
1894: p_msg_type=>'UNEXPECTED ERROR',
1895: p_msg_level=>fnd_log.level_error);
1896: END IF;
1897: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1898: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1899: p_prefix=>l_debug_prefix,
1900: p_msg_level=>fnd_log.level_procedure);
1901: END IF;
1896: END IF;
1897: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1898: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1899: p_prefix=>l_debug_prefix,
1900: p_msg_level=>fnd_log.level_procedure);
1901: END IF;
1902:
1903: WHEN OTHERS THEN
1904: ROLLBACK TO save_bau_pvt;
1916: p_count => x_msg_count,
1917: p_data => x_msg_data);
1918:
1919: -- Debug info.
1920: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1921: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1922: p_msg_data=>x_msg_data,
1923: p_msg_type=>'SQL ERROR',
1924: p_msg_level=>fnd_log.level_error);
1920: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1921: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1922: p_msg_data=>x_msg_data,
1923: p_msg_type=>'SQL ERROR',
1924: p_msg_level=>fnd_log.level_error);
1925: END IF;
1926: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1927: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1928: p_prefix=>l_debug_prefix,
1922: p_msg_data=>x_msg_data,
1923: p_msg_type=>'SQL ERROR',
1924: p_msg_level=>fnd_log.level_error);
1925: END IF;
1926: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1927: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1928: p_prefix=>l_debug_prefix,
1929: p_msg_level=>fnd_log.level_procedure);
1930: END IF;
1925: END IF;
1926: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1927: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',
1928: p_prefix=>l_debug_prefix,
1929: p_msg_level=>fnd_log.level_procedure);
1930: END IF;
1931: END save_bank_acct_uses;
1932:
1933: -- PROCEDURE create_payment_method
1974: -- initialize API return status to success.
1975: x_return_status := FND_API.G_RET_STS_SUCCESS;
1976:
1977: -- Debug info.
1978: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1979: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',
1980: p_prefix=>l_debug_prefix,
1981: p_msg_level=>fnd_log.level_procedure);
1982: END IF;
1977: -- Debug info.
1978: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1979: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',
1980: p_prefix=>l_debug_prefix,
1981: p_msg_level=>fnd_log.level_procedure);
1982: END IF;
1983:
1984: assign_payment_method_rec(
1985: p_payment_method_obj => p_payment_method_obj,
1996: x_msg_data => x_msg_data
1997: );
1998:
1999: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2000: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2001: 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,
2002: p_prefix=>l_debug_prefix,
2003: p_msg_level=>fnd_log.level_procedure);
2004: END IF;
1999: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2000: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2001: 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,
2002: p_prefix=>l_debug_prefix,
2003: p_msg_level=>fnd_log.level_procedure);
2004: END IF;
2005: RAISE FND_API.G_EXC_ERROR;
2006: END IF;
2007:
2008: -- assign payment_method_id
2009: p_payment_method_obj.payment_method_id := l_pm_id;
2010:
2011: -- Debug info.
2012: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2013: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2014: p_msg_data=>x_msg_data,
2015: p_msg_type=>'WARNING',
2016: p_msg_level=>fnd_log.level_exception);
2012: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2013: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2014: p_msg_data=>x_msg_data,
2015: p_msg_type=>'WARNING',
2016: p_msg_level=>fnd_log.level_exception);
2017: END IF;
2018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2019: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2020: p_prefix=>l_debug_prefix,
2014: p_msg_data=>x_msg_data,
2015: p_msg_type=>'WARNING',
2016: p_msg_level=>fnd_log.level_exception);
2017: END IF;
2018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2019: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2020: p_prefix=>l_debug_prefix,
2021: p_msg_level=>fnd_log.level_procedure);
2022: END IF;
2017: END IF;
2018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2019: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2020: p_prefix=>l_debug_prefix,
2021: p_msg_level=>fnd_log.level_procedure);
2022: END IF;
2023: EXCEPTION
2024: WHEN fnd_api.g_exc_error THEN
2025: ROLLBACK TO create_pm_pvt;
2033: p_count => x_msg_count,
2034: p_data => x_msg_data);
2035:
2036: -- Debug info.
2037: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2038: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2039: p_msg_data=>x_msg_data,
2040: p_msg_type=>'ERROR',
2041: p_msg_level=>fnd_log.level_error);
2037: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2038: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2039: p_msg_data=>x_msg_data,
2040: p_msg_type=>'ERROR',
2041: p_msg_level=>fnd_log.level_error);
2042: END IF;
2043: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2044: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2045: p_prefix=>l_debug_prefix,
2039: p_msg_data=>x_msg_data,
2040: p_msg_type=>'ERROR',
2041: p_msg_level=>fnd_log.level_error);
2042: END IF;
2043: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2044: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2045: p_prefix=>l_debug_prefix,
2046: p_msg_level=>fnd_log.level_procedure);
2047: END IF;
2042: END IF;
2043: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2044: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2045: p_prefix=>l_debug_prefix,
2046: p_msg_level=>fnd_log.level_procedure);
2047: END IF;
2048:
2049: WHEN fnd_api.g_exc_unexpected_error THEN
2050: ROLLBACK TO create_pm_pvt;
2058: p_count => x_msg_count,
2059: p_data => x_msg_data);
2060:
2061: -- Debug info.
2062: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2063: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2064: p_msg_data=>x_msg_data,
2065: p_msg_type=>'UNEXPECTED ERROR',
2066: p_msg_level=>fnd_log.level_error);
2062: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2063: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2064: p_msg_data=>x_msg_data,
2065: p_msg_type=>'UNEXPECTED ERROR',
2066: p_msg_level=>fnd_log.level_error);
2067: END IF;
2068: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2069: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2070: p_prefix=>l_debug_prefix,
2064: p_msg_data=>x_msg_data,
2065: p_msg_type=>'UNEXPECTED ERROR',
2066: p_msg_level=>fnd_log.level_error);
2067: END IF;
2068: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2069: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2070: p_prefix=>l_debug_prefix,
2071: p_msg_level=>fnd_log.level_procedure);
2072: END IF;
2067: END IF;
2068: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2069: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2070: p_prefix=>l_debug_prefix,
2071: p_msg_level=>fnd_log.level_procedure);
2072: END IF;
2073:
2074: WHEN OTHERS THEN
2075: ROLLBACK TO create_pm_pvt;
2087: p_count => x_msg_count,
2088: p_data => x_msg_data);
2089:
2090: -- Debug info.
2091: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2092: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2093: p_msg_data=>x_msg_data,
2094: p_msg_type=>'SQL ERROR',
2095: p_msg_level=>fnd_log.level_error);
2091: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2092: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2093: p_msg_data=>x_msg_data,
2094: p_msg_type=>'SQL ERROR',
2095: p_msg_level=>fnd_log.level_error);
2096: END IF;
2097: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2098: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2099: p_prefix=>l_debug_prefix,
2093: p_msg_data=>x_msg_data,
2094: p_msg_type=>'SQL ERROR',
2095: p_msg_level=>fnd_log.level_error);
2096: END IF;
2097: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2098: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2099: p_prefix=>l_debug_prefix,
2100: p_msg_level=>fnd_log.level_procedure);
2101: END IF;
2096: END IF;
2097: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2098: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',
2099: p_prefix=>l_debug_prefix,
2100: p_msg_level=>fnd_log.level_procedure);
2101: END IF;
2102: END create_payment_method;
2103:
2104: -- PROCEDURE save_payment_method
2146: -- initialize API return status to success.
2147: x_return_status := FND_API.G_RET_STS_SUCCESS;
2148:
2149: -- Debug info.
2150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2151: hz_utility_v2pub.debug(p_message=>'save_payment_method(+)',
2152: p_prefix=>l_debug_prefix,
2153: p_msg_level=>fnd_log.level_procedure);
2154: END IF;
2149: -- Debug info.
2150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2151: hz_utility_v2pub.debug(p_message=>'save_payment_method(+)',
2152: p_prefix=>l_debug_prefix,
2153: p_msg_level=>fnd_log.level_procedure);
2154: END IF;
2155:
2156: assign_payment_method_rec(
2157: p_payment_method_obj => p_payment_method_obj,
2189: p_payment_method_obj.payment_method_id := l_payment_method_rec.cust_receipt_method_id;
2190: END IF;
2191:
2192: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2194: 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,
2195: p_prefix=>l_debug_prefix,
2196: p_msg_level=>fnd_log.level_procedure);
2197: END IF;
2192: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2194: 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,
2195: p_prefix=>l_debug_prefix,
2196: p_msg_level=>fnd_log.level_procedure);
2197: END IF;
2198: RAISE FND_API.G_EXC_ERROR;
2199: END IF;
2200:
2198: RAISE FND_API.G_EXC_ERROR;
2199: END IF;
2200:
2201: -- Debug info.
2202: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2203: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2204: p_msg_data=>x_msg_data,
2205: p_msg_type=>'WARNING',
2206: p_msg_level=>fnd_log.level_exception);
2202: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2203: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2204: p_msg_data=>x_msg_data,
2205: p_msg_type=>'WARNING',
2206: p_msg_level=>fnd_log.level_exception);
2207: END IF;
2208: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2209: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2210: p_prefix=>l_debug_prefix,
2204: p_msg_data=>x_msg_data,
2205: p_msg_type=>'WARNING',
2206: p_msg_level=>fnd_log.level_exception);
2207: END IF;
2208: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2209: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2210: p_prefix=>l_debug_prefix,
2211: p_msg_level=>fnd_log.level_procedure);
2212: END IF;
2207: END IF;
2208: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2209: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2210: p_prefix=>l_debug_prefix,
2211: p_msg_level=>fnd_log.level_procedure);
2212: END IF;
2213: EXCEPTION
2214: WHEN fnd_api.g_exc_error THEN
2215: ROLLBACK TO save_pm_pvt;
2223: p_count => x_msg_count,
2224: p_data => x_msg_data);
2225:
2226: -- Debug info.
2227: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2228: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2229: p_msg_data=>x_msg_data,
2230: p_msg_type=>'ERROR',
2231: p_msg_level=>fnd_log.level_error);
2227: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2228: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2229: p_msg_data=>x_msg_data,
2230: p_msg_type=>'ERROR',
2231: p_msg_level=>fnd_log.level_error);
2232: END IF;
2233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2234: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2235: p_prefix=>l_debug_prefix,
2229: p_msg_data=>x_msg_data,
2230: p_msg_type=>'ERROR',
2231: p_msg_level=>fnd_log.level_error);
2232: END IF;
2233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2234: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2235: p_prefix=>l_debug_prefix,
2236: p_msg_level=>fnd_log.level_procedure);
2237: END IF;
2232: END IF;
2233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2234: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2235: p_prefix=>l_debug_prefix,
2236: p_msg_level=>fnd_log.level_procedure);
2237: END IF;
2238:
2239: WHEN fnd_api.g_exc_unexpected_error THEN
2240: ROLLBACK TO save_pm_pvt;
2248: p_count => x_msg_count,
2249: p_data => x_msg_data);
2250:
2251: -- Debug info.
2252: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2254: p_msg_data=>x_msg_data,
2255: p_msg_type=>'UNEXPECTED ERROR',
2256: p_msg_level=>fnd_log.level_error);
2252: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2254: p_msg_data=>x_msg_data,
2255: p_msg_type=>'UNEXPECTED ERROR',
2256: p_msg_level=>fnd_log.level_error);
2257: END IF;
2258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2259: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2260: p_prefix=>l_debug_prefix,
2254: p_msg_data=>x_msg_data,
2255: p_msg_type=>'UNEXPECTED ERROR',
2256: p_msg_level=>fnd_log.level_error);
2257: END IF;
2258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2259: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2260: p_prefix=>l_debug_prefix,
2261: p_msg_level=>fnd_log.level_procedure);
2262: END IF;
2257: END IF;
2258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2259: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2260: p_prefix=>l_debug_prefix,
2261: p_msg_level=>fnd_log.level_procedure);
2262: END IF;
2263:
2264: WHEN OTHERS THEN
2265: ROLLBACK TO save_pm_pvt;
2277: p_count => x_msg_count,
2278: p_data => x_msg_data);
2279:
2280: -- Debug info.
2281: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2282: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2283: p_msg_data=>x_msg_data,
2284: p_msg_type=>'SQL ERROR',
2285: p_msg_level=>fnd_log.level_error);
2281: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2282: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2283: p_msg_data=>x_msg_data,
2284: p_msg_type=>'SQL ERROR',
2285: p_msg_level=>fnd_log.level_error);
2286: END IF;
2287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2288: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2289: p_prefix=>l_debug_prefix,
2283: p_msg_data=>x_msg_data,
2284: p_msg_type=>'SQL ERROR',
2285: p_msg_level=>fnd_log.level_error);
2286: END IF;
2287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2288: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2289: p_prefix=>l_debug_prefix,
2290: p_msg_level=>fnd_log.level_procedure);
2291: END IF;
2286: END IF;
2287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2288: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',
2289: p_prefix=>l_debug_prefix,
2290: p_msg_level=>fnd_log.level_procedure);
2291: END IF;
2292: END save_payment_method;
2293:
2294: -- PROCEDURE save_cust_accts
2345: -- initialize API return status to success
2346: x_return_status := FND_API.G_RET_STS_SUCCESS;
2347:
2348: -- Debug info.
2349: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2350: hz_utility_v2pub.debug(p_message=>'save_cust_accts(+)',
2351: p_prefix=>l_debug_prefix,
2352: p_msg_level=>fnd_log.level_procedure);
2353: END IF;
2348: -- Debug info.
2349: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2350: hz_utility_v2pub.debug(p_message=>'save_cust_accts(+)',
2351: p_prefix=>l_debug_prefix,
2352: p_msg_level=>fnd_log.level_procedure);
2353: END IF;
2354:
2355: l_parent_id := p_parent_id;
2356: l_parent_os := p_parent_os;
2379: px_parent_obj_type => l_parent_obj_type
2380: );
2381:
2382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2383: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2384: 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,
2385: p_prefix=>l_debug_prefix,
2386: p_msg_level=>fnd_log.level_procedure);
2387: END IF;
2382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2383: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2384: 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,
2385: p_prefix=>l_debug_prefix,
2386: p_msg_level=>fnd_log.level_procedure);
2387: END IF;
2388: RAISE FND_API.G_EXC_ERROR;
2389: END IF;
2390:
2410: px_parent_obj_type => l_parent_obj_type
2411: );
2412:
2413: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2414: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2415: 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,
2416: p_prefix=>l_debug_prefix,
2417: p_msg_level=>fnd_log.level_procedure);
2418: END IF;
2413: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2414: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2415: 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,
2416: p_prefix=>l_debug_prefix,
2417: p_msg_level=>fnd_log.level_procedure);
2418: END IF;
2419: RAISE FND_API.G_EXC_ERROR;
2420: END IF;
2421:
2423: END LOOP;
2424: END IF;
2425:
2426: -- Debug info.
2427: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2428: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2429: p_msg_data=>x_msg_data,
2430: p_msg_type=>'WARNING',
2431: p_msg_level=>fnd_log.level_exception);
2427: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2428: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2429: p_msg_data=>x_msg_data,
2430: p_msg_type=>'WARNING',
2431: p_msg_level=>fnd_log.level_exception);
2432: END IF;
2433: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2434: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2435: p_prefix=>l_debug_prefix,
2429: p_msg_data=>x_msg_data,
2430: p_msg_type=>'WARNING',
2431: p_msg_level=>fnd_log.level_exception);
2432: END IF;
2433: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2434: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2435: p_prefix=>l_debug_prefix,
2436: p_msg_level=>fnd_log.level_procedure);
2437: END IF;
2432: END IF;
2433: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2434: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2435: p_prefix=>l_debug_prefix,
2436: p_msg_level=>fnd_log.level_procedure);
2437: END IF;
2438: EXCEPTION
2439: WHEN fnd_api.g_exc_error THEN
2440: x_return_status := fnd_api.g_ret_sts_error;
2443: p_count => x_msg_count,
2444: p_data => x_msg_data);
2445:
2446: -- Debug info.
2447: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2448: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2449: p_msg_data=>x_msg_data,
2450: p_msg_type=>'ERROR',
2451: p_msg_level=>fnd_log.level_error);
2447: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2448: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2449: p_msg_data=>x_msg_data,
2450: p_msg_type=>'ERROR',
2451: p_msg_level=>fnd_log.level_error);
2452: END IF;
2453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2454: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2455: p_prefix=>l_debug_prefix,
2449: p_msg_data=>x_msg_data,
2450: p_msg_type=>'ERROR',
2451: p_msg_level=>fnd_log.level_error);
2452: END IF;
2453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2454: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2455: p_prefix=>l_debug_prefix,
2456: p_msg_level=>fnd_log.level_procedure);
2457: END IF;
2452: END IF;
2453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2454: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2455: p_prefix=>l_debug_prefix,
2456: p_msg_level=>fnd_log.level_procedure);
2457: END IF;
2458: WHEN fnd_api.g_exc_unexpected_error THEN
2459: x_return_status := fnd_api.g_ret_sts_unexp_error;
2460:
2462: p_count => x_msg_count,
2463: p_data => x_msg_data);
2464:
2465: -- Debug info.
2466: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2467: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2468: p_msg_data=>x_msg_data,
2469: p_msg_type=>'UNEXPECTED ERROR',
2470: p_msg_level=>fnd_log.level_error);
2466: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2467: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2468: p_msg_data=>x_msg_data,
2469: p_msg_type=>'UNEXPECTED ERROR',
2470: p_msg_level=>fnd_log.level_error);
2471: END IF;
2472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2473: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2474: p_prefix=>l_debug_prefix,
2468: p_msg_data=>x_msg_data,
2469: p_msg_type=>'UNEXPECTED ERROR',
2470: p_msg_level=>fnd_log.level_error);
2471: END IF;
2472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2473: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2474: p_prefix=>l_debug_prefix,
2475: p_msg_level=>fnd_log.level_procedure);
2476: END IF;
2471: END IF;
2472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2473: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2474: p_prefix=>l_debug_prefix,
2475: p_msg_level=>fnd_log.level_procedure);
2476: END IF;
2477: WHEN OTHERS THEN
2478: x_return_status := fnd_api.g_ret_sts_unexp_error;
2479:
2485: p_count => x_msg_count,
2486: p_data => x_msg_data);
2487:
2488: -- Debug info.
2489: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2490: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2491: p_msg_data=>x_msg_data,
2492: p_msg_type=>'SQL ERROR',
2493: p_msg_level=>fnd_log.level_error);
2489: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2490: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2491: p_msg_data=>x_msg_data,
2492: p_msg_type=>'SQL ERROR',
2493: p_msg_level=>fnd_log.level_error);
2494: END IF;
2495: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2496: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2497: p_prefix=>l_debug_prefix,
2491: p_msg_data=>x_msg_data,
2492: p_msg_type=>'SQL ERROR',
2493: p_msg_level=>fnd_log.level_error);
2494: END IF;
2495: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2496: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2497: p_prefix=>l_debug_prefix,
2498: p_msg_level=>fnd_log.level_procedure);
2499: END IF;
2494: END IF;
2495: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2496: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2497: p_prefix=>l_debug_prefix,
2498: p_msg_level=>fnd_log.level_procedure);
2499: END IF;
2500: END save_cust_accts;
2501:
2502: -- PROCEDURE create_payment_methods
2541: -- initialize API return status to success.
2542: x_return_status := FND_API.G_RET_STS_SUCCESS;
2543:
2544: -- Debug info.
2545: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2546: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',
2547: p_prefix=>l_debug_prefix,
2548: p_msg_level=>fnd_log.level_procedure);
2549: END IF;
2544: -- Debug info.
2545: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2546: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',
2547: p_prefix=>l_debug_prefix,
2548: p_msg_level=>fnd_log.level_procedure);
2549: END IF;
2550:
2551: FOR i IN 1..p_payment_method_objs.COUNT LOOP
2552:
2575: p_count => x_msg_count,
2576: p_data => x_msg_data);
2577:
2578: -- Debug info.
2579: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2580: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2581: p_msg_data=>x_msg_data,
2582: p_msg_type=>'ERROR',
2583: p_msg_level=>fnd_log.level_error);
2579: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2580: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2581: p_msg_data=>x_msg_data,
2582: p_msg_type=>'ERROR',
2583: p_msg_level=>fnd_log.level_error);
2584: END IF;
2585: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2586: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2587: p_prefix=>l_debug_prefix,
2581: p_msg_data=>x_msg_data,
2582: p_msg_type=>'ERROR',
2583: p_msg_level=>fnd_log.level_error);
2584: END IF;
2585: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2586: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2587: p_prefix=>l_debug_prefix,
2588: p_msg_level=>fnd_log.level_procedure);
2589: END IF;
2584: END IF;
2585: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2586: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2587: p_prefix=>l_debug_prefix,
2588: p_msg_level=>fnd_log.level_procedure);
2589: END IF;
2590:
2591: WHEN fnd_api.g_exc_unexpected_error THEN
2592: ROLLBACK TO create_pms_v2_pvt;
2597: p_count => x_msg_count,
2598: p_data => x_msg_data);
2599:
2600: -- Debug info.
2601: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2602: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2603: p_msg_data=>x_msg_data,
2604: p_msg_type=>'UNEXPECTED ERROR',
2605: p_msg_level=>fnd_log.level_error);
2601: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2602: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2603: p_msg_data=>x_msg_data,
2604: p_msg_type=>'UNEXPECTED ERROR',
2605: p_msg_level=>fnd_log.level_error);
2606: END IF;
2607: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2608: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2609: p_prefix=>l_debug_prefix,
2603: p_msg_data=>x_msg_data,
2604: p_msg_type=>'UNEXPECTED ERROR',
2605: p_msg_level=>fnd_log.level_error);
2606: END IF;
2607: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2608: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2609: p_prefix=>l_debug_prefix,
2610: p_msg_level=>fnd_log.level_procedure);
2611: END IF;
2606: END IF;
2607: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2608: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2609: p_prefix=>l_debug_prefix,
2610: p_msg_level=>fnd_log.level_procedure);
2611: END IF;
2612:
2613: WHEN OTHERS THEN
2614: ROLLBACK TO create_pms_v2_pvt;
2623: p_count => x_msg_count,
2624: p_data => x_msg_data);
2625:
2626: -- Debug info.
2627: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2628: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2629: p_msg_data=>x_msg_data,
2630: p_msg_type=>'SQL ERROR',
2631: p_msg_level=>fnd_log.level_error);
2627: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2628: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2629: p_msg_data=>x_msg_data,
2630: p_msg_type=>'SQL ERROR',
2631: p_msg_level=>fnd_log.level_error);
2632: END IF;
2633: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2634: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2635: p_prefix=>l_debug_prefix,
2629: p_msg_data=>x_msg_data,
2630: p_msg_type=>'SQL ERROR',
2631: p_msg_level=>fnd_log.level_error);
2632: END IF;
2633: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2634: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2635: p_prefix=>l_debug_prefix,
2636: p_msg_level=>fnd_log.level_procedure);
2637: END IF;
2632: END IF;
2633: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2634: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',
2635: p_prefix=>l_debug_prefix,
2636: p_msg_level=>fnd_log.level_procedure);
2637: END IF;
2638: END create_payment_methods;
2639:
2640: -- PROCEDURE save_payment_methods
2679: -- initialize API return status to success.
2680: x_return_status := FND_API.G_RET_STS_SUCCESS;
2681:
2682: -- Debug info.
2683: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2684: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',
2685: p_prefix=>l_debug_prefix,
2686: p_msg_level=>fnd_log.level_procedure);
2687: END IF;
2682: -- Debug info.
2683: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2684: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',
2685: p_prefix=>l_debug_prefix,
2686: p_msg_level=>fnd_log.level_procedure);
2687: END IF;
2688:
2689: FOR i IN 1..p_payment_method_objs.COUNT LOOP
2690:
2716: p_count => x_msg_count,
2717: p_data => x_msg_data);
2718:
2719: -- Debug info.
2720: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2721: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2722: p_msg_data=>x_msg_data,
2723: p_msg_type=>'ERROR',
2724: p_msg_level=>fnd_log.level_error);
2720: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2721: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2722: p_msg_data=>x_msg_data,
2723: p_msg_type=>'ERROR',
2724: p_msg_level=>fnd_log.level_error);
2725: END IF;
2726: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2727: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2728: p_prefix=>l_debug_prefix,
2722: p_msg_data=>x_msg_data,
2723: p_msg_type=>'ERROR',
2724: p_msg_level=>fnd_log.level_error);
2725: END IF;
2726: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2727: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2728: p_prefix=>l_debug_prefix,
2729: p_msg_level=>fnd_log.level_procedure);
2730: END IF;
2725: END IF;
2726: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2727: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2728: p_prefix=>l_debug_prefix,
2729: p_msg_level=>fnd_log.level_procedure);
2730: END IF;
2731:
2732: WHEN fnd_api.g_exc_unexpected_error THEN
2733: ROLLBACK TO save_pm_v2_pvt;
2741: p_count => x_msg_count,
2742: p_data => x_msg_data);
2743:
2744: -- Debug info.
2745: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2746: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2747: p_msg_data=>x_msg_data,
2748: p_msg_type=>'UNEXPECTED ERROR',
2749: p_msg_level=>fnd_log.level_error);
2745: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2746: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2747: p_msg_data=>x_msg_data,
2748: p_msg_type=>'UNEXPECTED ERROR',
2749: p_msg_level=>fnd_log.level_error);
2750: END IF;
2751: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2752: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2753: p_prefix=>l_debug_prefix,
2747: p_msg_data=>x_msg_data,
2748: p_msg_type=>'UNEXPECTED ERROR',
2749: p_msg_level=>fnd_log.level_error);
2750: END IF;
2751: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2752: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2753: p_prefix=>l_debug_prefix,
2754: p_msg_level=>fnd_log.level_procedure);
2755: END IF;
2750: END IF;
2751: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2752: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2753: p_prefix=>l_debug_prefix,
2754: p_msg_level=>fnd_log.level_procedure);
2755: END IF;
2756:
2757: WHEN OTHERS THEN
2758: ROLLBACK TO save_pm_v2_pvt;
2770: p_count => x_msg_count,
2771: p_data => x_msg_data);
2772:
2773: -- Debug info.
2774: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2775: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2776: p_msg_data=>x_msg_data,
2777: p_msg_type=>'SQL ERROR',
2778: p_msg_level=>fnd_log.level_error);
2774: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2775: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2776: p_msg_data=>x_msg_data,
2777: p_msg_type=>'SQL ERROR',
2778: p_msg_level=>fnd_log.level_error);
2779: END IF;
2780: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2781: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2782: p_prefix=>l_debug_prefix,
2776: p_msg_data=>x_msg_data,
2777: p_msg_type=>'SQL ERROR',
2778: p_msg_level=>fnd_log.level_error);
2779: END IF;
2780: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2781: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2782: p_prefix=>l_debug_prefix,
2783: p_msg_level=>fnd_log.level_procedure);
2784: END IF;
2779: END IF;
2780: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2781: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',
2782: p_prefix=>l_debug_prefix,
2783: p_msg_level=>fnd_log.level_procedure);
2784: END IF;
2785: END save_payment_methods;
2786:
2787: -- PROCEDURE save_cust_accts
2838: -- initialize API return status to success
2839: x_return_status := FND_API.G_RET_STS_SUCCESS;
2840:
2841: -- Debug info.
2842: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2843: hz_utility_v2pub.debug(p_message=>'save_cust_accts(+)',
2844: p_prefix=>l_debug_prefix,
2845: p_msg_level=>fnd_log.level_procedure);
2846: END IF;
2841: -- Debug info.
2842: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2843: hz_utility_v2pub.debug(p_message=>'save_cust_accts(+)',
2844: p_prefix=>l_debug_prefix,
2845: p_msg_level=>fnd_log.level_procedure);
2846: END IF;
2847:
2848: l_parent_id := p_parent_id;
2849: l_parent_os := p_parent_os;
2872: px_parent_obj_type => l_parent_obj_type
2873: );
2874:
2875: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2876: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2877: 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,
2878: p_prefix=>l_debug_prefix,
2879: p_msg_level=>fnd_log.level_procedure);
2880: END IF;
2875: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2876: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2877: 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,
2878: p_prefix=>l_debug_prefix,
2879: p_msg_level=>fnd_log.level_procedure);
2880: END IF;
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883:
2903: px_parent_obj_type => l_parent_obj_type
2904: );
2905:
2906: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2907: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2908: 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,
2909: p_prefix=>l_debug_prefix,
2910: p_msg_level=>fnd_log.level_procedure);
2911: END IF;
2906: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2907: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2908: 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,
2909: p_prefix=>l_debug_prefix,
2910: p_msg_level=>fnd_log.level_procedure);
2911: END IF;
2912: RAISE FND_API.G_EXC_ERROR;
2913: END IF;
2914:
2916: END LOOP;
2917: END IF;
2918:
2919: -- Debug info.
2920: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2921: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2922: p_msg_data=>x_msg_data,
2923: p_msg_type=>'WARNING',
2924: p_msg_level=>fnd_log.level_exception);
2920: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2921: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2922: p_msg_data=>x_msg_data,
2923: p_msg_type=>'WARNING',
2924: p_msg_level=>fnd_log.level_exception);
2925: END IF;
2926: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2927: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2928: p_prefix=>l_debug_prefix,
2922: p_msg_data=>x_msg_data,
2923: p_msg_type=>'WARNING',
2924: p_msg_level=>fnd_log.level_exception);
2925: END IF;
2926: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2927: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2928: p_prefix=>l_debug_prefix,
2929: p_msg_level=>fnd_log.level_procedure);
2930: END IF;
2925: END IF;
2926: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2927: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2928: p_prefix=>l_debug_prefix,
2929: p_msg_level=>fnd_log.level_procedure);
2930: END IF;
2931: EXCEPTION
2932: WHEN fnd_api.g_exc_error THEN
2933: x_return_status := fnd_api.g_ret_sts_error;
2936: p_count => x_msg_count,
2937: p_data => x_msg_data);
2938:
2939: -- Debug info.
2940: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2941: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2942: p_msg_data=>x_msg_data,
2943: p_msg_type=>'ERROR',
2944: p_msg_level=>fnd_log.level_error);
2940: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2941: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2942: p_msg_data=>x_msg_data,
2943: p_msg_type=>'ERROR',
2944: p_msg_level=>fnd_log.level_error);
2945: END IF;
2946: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2947: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2948: p_prefix=>l_debug_prefix,
2942: p_msg_data=>x_msg_data,
2943: p_msg_type=>'ERROR',
2944: p_msg_level=>fnd_log.level_error);
2945: END IF;
2946: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2947: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2948: p_prefix=>l_debug_prefix,
2949: p_msg_level=>fnd_log.level_procedure);
2950: END IF;
2945: END IF;
2946: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2947: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2948: p_prefix=>l_debug_prefix,
2949: p_msg_level=>fnd_log.level_procedure);
2950: END IF;
2951: WHEN fnd_api.g_exc_unexpected_error THEN
2952: x_return_status := fnd_api.g_ret_sts_unexp_error;
2953:
2955: p_count => x_msg_count,
2956: p_data => x_msg_data);
2957:
2958: -- Debug info.
2959: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2960: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2961: p_msg_data=>x_msg_data,
2962: p_msg_type=>'UNEXPECTED ERROR',
2963: p_msg_level=>fnd_log.level_error);
2959: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2960: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2961: p_msg_data=>x_msg_data,
2962: p_msg_type=>'UNEXPECTED ERROR',
2963: p_msg_level=>fnd_log.level_error);
2964: END IF;
2965: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2966: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2967: p_prefix=>l_debug_prefix,
2961: p_msg_data=>x_msg_data,
2962: p_msg_type=>'UNEXPECTED ERROR',
2963: p_msg_level=>fnd_log.level_error);
2964: END IF;
2965: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2966: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2967: p_prefix=>l_debug_prefix,
2968: p_msg_level=>fnd_log.level_procedure);
2969: END IF;
2964: END IF;
2965: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2966: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2967: p_prefix=>l_debug_prefix,
2968: p_msg_level=>fnd_log.level_procedure);
2969: END IF;
2970: WHEN OTHERS THEN
2971: x_return_status := fnd_api.g_ret_sts_unexp_error;
2972:
2978: p_count => x_msg_count,
2979: p_data => x_msg_data);
2980:
2981: -- Debug info.
2982: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2983: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2984: p_msg_data=>x_msg_data,
2985: p_msg_type=>'SQL ERROR',
2986: p_msg_level=>fnd_log.level_error);
2982: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2983: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2984: p_msg_data=>x_msg_data,
2985: p_msg_type=>'SQL ERROR',
2986: p_msg_level=>fnd_log.level_error);
2987: END IF;
2988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2989: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2990: p_prefix=>l_debug_prefix,
2984: p_msg_data=>x_msg_data,
2985: p_msg_type=>'SQL ERROR',
2986: p_msg_level=>fnd_log.level_error);
2987: END IF;
2988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2989: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2990: p_prefix=>l_debug_prefix,
2991: p_msg_level=>fnd_log.level_procedure);
2992: END IF;
2987: END IF;
2988: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2989: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',
2990: p_prefix=>l_debug_prefix,
2991: p_msg_level=>fnd_log.level_procedure);
2992: END IF;
2993: END save_cust_accts;
2994:
2995: