DBA Data[Home] [Help]

APPS.HZ_CUST_ACCT_BO_PVT dependencies on HZ_UTILITY_V2PUB

Line 325: px_cust_profile_amt_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

321: px_cust_profile_amt_rec.global_attribute17 := p_cust_profile_amt_obj.global_attribute17;
322: px_cust_profile_amt_rec.global_attribute18 := p_cust_profile_amt_obj.global_attribute18;
323: px_cust_profile_amt_rec.global_attribute19 := p_cust_profile_amt_obj.global_attribute19;
324: px_cust_profile_amt_rec.global_attribute20 := p_cust_profile_amt_obj.global_attribute20;
325: px_cust_profile_amt_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
326: px_cust_profile_amt_rec.exchange_rate_type := p_cust_profile_amt_obj.exchange_rate_type;
327: px_cust_profile_amt_rec.min_fc_invoice_overdue_type := p_cust_profile_amt_obj.min_fc_invoice_overdue_type;
328: px_cust_profile_amt_rec.min_fc_invoice_percent := p_cust_profile_amt_obj.min_fc_invoice_percent;
329: px_cust_profile_amt_rec.min_fc_balance_overdue_type := p_cust_profile_amt_obj.min_fc_balance_overdue_type;

Line 475: px_cust_profile_rec.created_by_module :=HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

471: END IF;
472: px_cust_profile_rec.cons_inv_type :=p_cust_profile_obj.cons_inv_type;
473: px_cust_profile_rec.autocash_hierarchy_id_for_adr :=p_cust_profile_obj.autocash_hier_id_for_adr;
474: px_cust_profile_rec.lockbox_matching_option :=p_cust_profile_obj.lockbox_matching_option;
475: px_cust_profile_rec.created_by_module :=HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
476: px_cust_profile_rec.review_cycle :=p_cust_profile_obj.review_cycle;
477: px_cust_profile_rec.last_credit_review_date :=p_cust_profile_obj.last_credit_review_date;
478: --px_cust_profile_rec.party_id :=p_cust_profile_obj.party_id;
479: px_cust_profile_rec.credit_classification :=p_cust_profile_obj.credit_classification;

Line 549: px_cust_acct_relate_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

545: px_cust_acct_relate_rec.status := p_cust_acct_relate_obj.status;
546: END IF;
547: px_cust_acct_relate_rec.bill_to_flag := p_cust_acct_relate_obj.bill_to_flag;
548: px_cust_acct_relate_rec.ship_to_flag := p_cust_acct_relate_obj.ship_to_flag;
549: px_cust_acct_relate_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
550: px_cust_acct_relate_rec.org_id := p_cust_acct_relate_obj.org_id;
551: END assign_cust_acct_relate_rec;
552:
553: -- PROCEDURE create_cust_profile

Line 600: hz_utility_v2pub.debug(p_message=>'create_cust_profile(+)',

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;
604:

Line 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,

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;
628: RAISE fnd_api.g_exc_error;

Line 636: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
640: END IF;

Line 642: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',

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;
646: EXCEPTION

Line 661: hz_utility_v2pub.debug_return_messages(p_msg_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);
665: END IF;

Line 667: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',

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;
671:

Line 686: hz_utility_v2pub.debug_return_messages(p_msg_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);
690: END IF;

Line 692: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',

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;
696:

Line 715: hz_utility_v2pub.debug_return_messages(p_msg_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);
719: END IF;

Line 721: hz_utility_v2pub.debug(p_message=>'create_cust_profile(-)',

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;
725: END create_cust_profile;

Line 788: hz_utility_v2pub.debug(p_message=>'update_cust_profile(+)',

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;
792:

Line 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,

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;
842: RAISE fnd_api.g_exc_error;

Line 850: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
854: END IF;

Line 856: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',

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;
860: EXCEPTION

Line 875: hz_utility_v2pub.debug_return_messages(p_msg_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);
879: END IF;

Line 881: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',

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;
885:

Line 900: hz_utility_v2pub.debug_return_messages(p_msg_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);
904: END IF;

Line 906: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',

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;
910:

Line 929: hz_utility_v2pub.debug_return_messages(p_msg_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);
933: END IF;

Line 935: hz_utility_v2pub.debug(p_message=>'update_cust_profile(-)',

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;
939: END update_cust_profile;

Line 989: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(+)',

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;
993:

Line 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,

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;
1018: RAISE FND_API.G_EXC_ERROR;

Line 1027: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
1031: END IF;

Line 1033: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',

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;
1037:

Line 1053: hz_utility_v2pub.debug_return_messages(p_msg_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);
1057: END IF;

Line 1059: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',

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;
1063:

Line 1078: hz_utility_v2pub.debug_return_messages(p_msg_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);
1082: END IF;

Line 1084: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',

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;
1088:

Line 1107: hz_utility_v2pub.debug_return_messages(p_msg_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);
1111: END IF;

Line 1113: hz_utility_v2pub.debug(p_message=>'create_cust_profile_amts(-)',

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;
1117: END create_cust_profile_amts;

Line 1168: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(+)',

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;
1172:

Line 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,

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;
1197: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 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,

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;
1238: RAISE FND_API.G_EXC_ERROR;

Line 1244: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
1248: END IF;

Line 1250: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',

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;
1254: EXCEPTION

Line 1269: hz_utility_v2pub.debug_return_messages(p_msg_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);
1273: END IF;

Line 1275: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',

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;
1279:

Line 1294: hz_utility_v2pub.debug_return_messages(p_msg_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);
1298: END IF;

Line 1300: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',

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;
1304:

Line 1323: hz_utility_v2pub.debug_return_messages(p_msg_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);
1327: END IF;

Line 1329: hz_utility_v2pub.debug(p_message=>'save_cust_profile_amts(-)',

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;
1333: END save_cust_profile_amts;

Line 1381: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(+)',

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;
1385:

Line 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,

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;
1427: RAISE FND_API.G_EXC_ERROR;

Line 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,

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;
1435: RAISE FND_API.G_EXC_ERROR;

Line 1441: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
1445: END IF;

Line 1447: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',

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;
1451: EXCEPTION

Line 1466: hz_utility_v2pub.debug_return_messages(p_msg_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);
1470: END IF;

Line 1472: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',

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;
1476:

Line 1491: hz_utility_v2pub.debug_return_messages(p_msg_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);
1495: END IF;

Line 1497: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',

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;
1501:

Line 1520: hz_utility_v2pub.debug_return_messages(p_msg_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);
1524: END IF;

Line 1526: hz_utility_v2pub.debug(p_message=>'create_cust_acct_relates(-)',

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;
1530: END create_cust_acct_relates;

Line 1579: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(+)',

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;
1583:

Line 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,

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;
1645: RAISE FND_API.G_EXC_ERROR;

Line 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,

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;
1653: RAISE FND_API.G_EXC_ERROR;

Line 1659: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
1663: END IF;

Line 1665: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',

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;
1669: EXCEPTION

Line 1684: hz_utility_v2pub.debug_return_messages(p_msg_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);
1688: END IF;

Line 1690: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',

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;
1694:

Line 1709: hz_utility_v2pub.debug_return_messages(p_msg_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);
1713: END IF;

Line 1715: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',

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;
1719:

Line 1738: hz_utility_v2pub.debug_return_messages(p_msg_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);
1742: END IF;

Line 1744: hz_utility_v2pub.debug(p_message=>'save_cust_acct_relates(-)',

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;
1748: END save_cust_acct_relates;

Line 1800: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(+)',

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;
1804:

Line 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,

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;
1836: RAISE FND_API.G_EXC_ERROR;

Line 1842: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
1846: END IF;

Line 1848: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',

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;
1852: EXCEPTION

Line 1867: hz_utility_v2pub.debug_return_messages(p_msg_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);
1871: END IF;

Line 1873: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',

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;
1877:

Line 1892: hz_utility_v2pub.debug_return_messages(p_msg_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);
1896: END IF;

Line 1898: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',

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;
1902:

Line 1921: hz_utility_v2pub.debug_return_messages(p_msg_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);
1925: END IF;

Line 1927: hz_utility_v2pub.debug(p_message=>'save_bank_acct_uses(-)',

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;
1931: END save_bank_acct_uses;

Line 1979: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',

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;
1983:

Line 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,

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;
2005: RAISE FND_API.G_EXC_ERROR;

Line 2013: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
2017: END IF;

Line 2019: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',

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;
2023: EXCEPTION

Line 2038: hz_utility_v2pub.debug_return_messages(p_msg_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);
2042: END IF;

Line 2044: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',

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;
2048:

Line 2063: hz_utility_v2pub.debug_return_messages(p_msg_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);
2067: END IF;

Line 2069: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',

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;
2073:

Line 2092: hz_utility_v2pub.debug_return_messages(p_msg_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);
2096: END IF;

Line 2098: hz_utility_v2pub.debug(p_message=>'create_payment_method(-)',

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;
2102: END create_payment_method;

Line 2151: hz_utility_v2pub.debug(p_message=>'save_payment_method(+)',

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;
2155:

Line 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,

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;
2198: RAISE FND_API.G_EXC_ERROR;

Line 2203: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
2207: END IF;

Line 2209: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',

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;
2213: EXCEPTION

Line 2228: hz_utility_v2pub.debug_return_messages(p_msg_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);
2232: END IF;

Line 2234: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',

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;
2238:

Line 2253: hz_utility_v2pub.debug_return_messages(p_msg_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);
2257: END IF;

Line 2259: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',

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;
2263:

Line 2282: hz_utility_v2pub.debug_return_messages(p_msg_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);
2286: END IF;

Line 2288: hz_utility_v2pub.debug(p_message=>'save_payment_method(-)',

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;
2292: END save_payment_method;

Line 2350: hz_utility_v2pub.debug(p_message=>'save_cust_accts(+)',

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;
2354:

Line 2360: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

2356: l_parent_os := p_parent_os;
2357: l_parent_osr := p_parent_osr;
2358: l_parent_obj_type := p_parent_obj_type;
2359:
2360: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
2361:
2362: IF(p_create_update_flag = 'C') THEN
2363: -- Create cust accounts
2364: FOR i IN 1..p_ca_objs.COUNT LOOP

Line 2368: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

2364: FOR i IN 1..p_ca_objs.COUNT LOOP
2365: HZ_CUST_ACCT_BO_PUB.do_create_cust_acct_bo(
2366: p_validate_bo_flag => fnd_api.g_false,
2367: p_cust_acct_obj => p_ca_objs(i),
2368: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
2369: p_obj_source => p_obj_source,
2370: x_return_status => x_return_status,
2371: x_msg_count => x_msg_count,
2372: x_msg_data => x_msg_data,

Line 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,

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;
2388: RAISE FND_API.G_EXC_ERROR;

Line 2391: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2387: END IF;
2388: RAISE FND_API.G_EXC_ERROR;
2389: END IF;
2390:
2391: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2392: END LOOP;
2393: ELSE
2394: -- Create/update cust accounts
2395: FOR i IN 1..p_ca_objs.COUNT LOOP

Line 2399: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

2395: FOR i IN 1..p_ca_objs.COUNT LOOP
2396: HZ_CUST_ACCT_BO_PUB.do_save_cust_acct_bo(
2397: p_validate_bo_flag => fnd_api.g_false,
2398: p_cust_acct_obj => p_ca_objs(i),
2399: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
2400: p_obj_source => p_obj_source,
2401: x_return_status => x_return_status,
2402: x_msg_count => x_msg_count,
2403: x_msg_data => x_msg_data,

Line 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,

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;
2419: RAISE FND_API.G_EXC_ERROR;

Line 2422: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2418: END IF;
2419: RAISE FND_API.G_EXC_ERROR;
2420: END IF;
2421:
2422: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2423: END LOOP;
2424: END IF;
2425:
2426: -- Debug info.

Line 2428: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
2432: END IF;

Line 2434: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',

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;
2438: EXCEPTION

Line 2448: hz_utility_v2pub.debug_return_messages(p_msg_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);
2452: END IF;

Line 2454: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',

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;
2458: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2467: hz_utility_v2pub.debug_return_messages(p_msg_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);
2471: END IF;

Line 2473: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',

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;
2477: WHEN OTHERS THEN

Line 2490: hz_utility_v2pub.debug_return_messages(p_msg_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);
2494: END IF;

Line 2496: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',

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;
2500: END save_cust_accts;

Line 2546: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',

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;
2550:

Line 2580: hz_utility_v2pub.debug_return_messages(p_msg_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);
2584: END IF;

Line 2586: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',

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;
2590:

Line 2602: hz_utility_v2pub.debug_return_messages(p_msg_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);
2606: END IF;

Line 2608: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',

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;
2612:

Line 2628: hz_utility_v2pub.debug_return_messages(p_msg_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);
2632: END IF;

Line 2634: hz_utility_v2pub.debug(p_message=>'create_payment_methods(-)',

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;
2638: END create_payment_methods;

Line 2684: hz_utility_v2pub.debug(p_message=>'create_payment_method(+)',

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;
2688:

Line 2721: hz_utility_v2pub.debug_return_messages(p_msg_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);
2725: END IF;

Line 2727: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',

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;
2731:

Line 2746: hz_utility_v2pub.debug_return_messages(p_msg_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);
2750: END IF;

Line 2752: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',

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;
2756:

Line 2775: hz_utility_v2pub.debug_return_messages(p_msg_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);
2779: END IF;

Line 2781: hz_utility_v2pub.debug(p_message=>'save_payment_methods(-)',

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;
2785: END save_payment_methods;

Line 2843: hz_utility_v2pub.debug(p_message=>'save_cust_accts(+)',

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;
2847:

Line 2853: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

2849: l_parent_os := p_parent_os;
2850: l_parent_osr := p_parent_osr;
2851: l_parent_obj_type := p_parent_obj_type;
2852:
2853: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
2854:
2855: IF(p_create_update_flag = 'C') THEN
2856: -- Create cust accounts
2857: FOR i IN 1..p_ca_v2_objs.COUNT LOOP

Line 2861: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

2857: FOR i IN 1..p_ca_v2_objs.COUNT LOOP
2858: HZ_CUST_ACCT_BO_PUB.do_create_cust_acct_v2_bo(
2859: p_validate_bo_flag => fnd_api.g_false,
2860: p_cust_acct_v2_obj => p_ca_v2_objs(i),
2861: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
2862: p_obj_source => p_obj_source,
2863: x_return_status => x_return_status,
2864: x_msg_count => x_msg_count,
2865: x_msg_data => x_msg_data,

Line 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,

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;
2881: RAISE FND_API.G_EXC_ERROR;

Line 2884: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2880: END IF;
2881: RAISE FND_API.G_EXC_ERROR;
2882: END IF;
2883:
2884: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2885: END LOOP;
2886: ELSE
2887: -- Create/update cust accounts
2888: FOR i IN 1..p_ca_v2_objs.COUNT LOOP

Line 2892: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

2888: FOR i IN 1..p_ca_v2_objs.COUNT LOOP
2889: HZ_CUST_ACCT_BO_PUB.do_save_cust_acct_v2_bo(
2890: p_validate_bo_flag => fnd_api.g_false,
2891: p_cust_acct_v2_obj => p_ca_v2_objs(i),
2892: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
2893: p_obj_source => p_obj_source,
2894: x_return_status => x_return_status,
2895: x_msg_count => x_msg_count,
2896: x_msg_data => x_msg_data,

Line 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,

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;
2912: RAISE FND_API.G_EXC_ERROR;

Line 2915: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2911: END IF;
2912: RAISE FND_API.G_EXC_ERROR;
2913: END IF;
2914:
2915: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2916: END LOOP;
2917: END IF;
2918:
2919: -- Debug info.

Line 2921: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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);
2925: END IF;

Line 2927: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',

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;
2931: EXCEPTION

Line 2941: hz_utility_v2pub.debug_return_messages(p_msg_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);
2945: END IF;

Line 2947: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',

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;
2951: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2960: hz_utility_v2pub.debug_return_messages(p_msg_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);
2964: END IF;

Line 2966: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',

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;
2970: WHEN OTHERS THEN

Line 2983: hz_utility_v2pub.debug_return_messages(p_msg_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);
2987: END IF;

Line 2989: hz_utility_v2pub.debug(p_message=>'save_cust_accts(-)',

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;
2993: END save_cust_accts;