120:
121:
122: -- Debug info.
123: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
124: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo(+)',
125: p_prefix=>l_debug_prefix,
126: p_msg_level=>fnd_log.level_procedure);
127: END IF;
128:
131: close c1;
132:
133: -- Debug info.
134: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
135: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
136: p_msg_data=>x_msg_data,
137: p_msg_type=>'WARNING',
138: p_msg_level=>fnd_log.level_exception);
139: END IF;
139: END IF;
140:
141: -- Debug info.
142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
143: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
144: p_prefix=>l_debug_prefix,
145: p_msg_level=>fnd_log.level_procedure);
146: END IF;
147:
156: p_data => x_msg_data);
157:
158: -- Debug info.
159: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
160: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
161: p_msg_data=>x_msg_data,
162: p_msg_type=>'ERROR',
163: p_msg_level=>fnd_log.level_error);
164: END IF;
162: p_msg_type=>'ERROR',
163: p_msg_level=>fnd_log.level_error);
164: END IF;
165: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
166: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
167: p_prefix=>l_debug_prefix,
168: p_msg_level=>fnd_log.level_procedure);
169: END IF;
170: WHEN fnd_api.g_exc_unexpected_error THEN
175: p_data => x_msg_data);
176:
177: -- Debug info.
178: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
179: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
180: p_msg_data=>x_msg_data,
181: p_msg_type=>'UNEXPECTED ERROR',
182: p_msg_level=>fnd_log.level_error);
183: END IF;
181: p_msg_type=>'UNEXPECTED ERROR',
182: p_msg_level=>fnd_log.level_error);
183: END IF;
184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
185: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
186: p_prefix=>l_debug_prefix,
187: p_msg_level=>fnd_log.level_procedure);
188: END IF;
189: WHEN OTHERS THEN
198: p_data => x_msg_data);
199:
200: -- Debug info.
201: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
202: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
203: p_msg_data=>x_msg_data,
204: p_msg_type=>'SQL ERROR',
205: p_msg_level=>fnd_log.level_error);
206: END IF;
204: p_msg_type=>'SQL ERROR',
205: p_msg_level=>fnd_log.level_error);
206: END IF;
207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
208: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
209: p_prefix=>l_debug_prefix,
210: p_msg_level=>fnd_log.level_procedure);
211: END IF;
212:
450:
451:
452: -- Debug info.
453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo(+)',
455: p_prefix=>l_debug_prefix,
456: p_msg_level=>fnd_log.level_procedure);
457: END IF;
458:
461: close c1;
462:
463: -- Debug info.
464: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
465: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
466: p_msg_data=>x_msg_data,
467: p_msg_type=>'WARNING',
468: p_msg_level=>fnd_log.level_exception);
469: END IF;
469: END IF;
470:
471: -- Debug info.
472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
473: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
474: p_prefix=>l_debug_prefix,
475: p_msg_level=>fnd_log.level_procedure);
476: END IF;
477:
486: p_data => x_msg_data);
487:
488: -- Debug info.
489: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
490: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
491: p_msg_data=>x_msg_data,
492: p_msg_type=>'ERROR',
493: p_msg_level=>fnd_log.level_error);
494: END IF;
492: p_msg_type=>'ERROR',
493: p_msg_level=>fnd_log.level_error);
494: END IF;
495: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
496: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
497: p_prefix=>l_debug_prefix,
498: p_msg_level=>fnd_log.level_procedure);
499: END IF;
500: WHEN fnd_api.g_exc_unexpected_error THEN
505: p_data => x_msg_data);
506:
507: -- Debug info.
508: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
509: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
510: p_msg_data=>x_msg_data,
511: p_msg_type=>'UNEXPECTED ERROR',
512: p_msg_level=>fnd_log.level_error);
513: END IF;
511: p_msg_type=>'UNEXPECTED ERROR',
512: p_msg_level=>fnd_log.level_error);
513: END IF;
514: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
515: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
516: p_prefix=>l_debug_prefix,
517: p_msg_level=>fnd_log.level_procedure);
518: END IF;
519: WHEN OTHERS THEN
528: p_data => x_msg_data);
529:
530: -- Debug info.
531: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
532: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
533: p_msg_data=>x_msg_data,
534: p_msg_type=>'SQL ERROR',
535: p_msg_level=>fnd_log.level_error);
536: END IF;
534: p_msg_type=>'SQL ERROR',
535: p_msg_level=>fnd_log.level_error);
536: END IF;
537: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
538: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
539: p_prefix=>l_debug_prefix,
540: p_msg_level=>fnd_log.level_procedure);
541: END IF;
542:
853:
854:
855: -- Debug info.
856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
857: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos(+)',
858: p_prefix=>l_debug_prefix,
859: p_msg_level=>fnd_log.level_procedure);
860: END IF;
861:
924: end loop;
925:
926: -- Debug info.
927: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
928: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
929: p_msg_data=>x_msg_data,
930: p_msg_type=>'WARNING',
931: p_msg_level=>fnd_log.level_exception);
932: END IF;
932: END IF;
933:
934: -- Debug info.
935: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
936: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
937: p_prefix=>l_debug_prefix,
938: p_msg_level=>fnd_log.level_procedure);
939: END IF;
940:
949: p_data => x_msg_data);
950:
951: -- Debug info.
952: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
953: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
954: p_msg_data=>x_msg_data,
955: p_msg_type=>'ERROR',
956: p_msg_level=>fnd_log.level_error);
957: END IF;
955: p_msg_type=>'ERROR',
956: p_msg_level=>fnd_log.level_error);
957: END IF;
958: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
959: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
960: p_prefix=>l_debug_prefix,
961: p_msg_level=>fnd_log.level_procedure);
962: END IF;
963: WHEN fnd_api.g_exc_unexpected_error THEN
968: p_data => x_msg_data);
969:
970: -- Debug info.
971: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
972: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
973: p_msg_data=>x_msg_data,
974: p_msg_type=>'UNEXPECTED ERROR',
975: p_msg_level=>fnd_log.level_error);
976: END IF;
974: p_msg_type=>'UNEXPECTED ERROR',
975: p_msg_level=>fnd_log.level_error);
976: END IF;
977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
978: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
979: p_prefix=>l_debug_prefix,
980: p_msg_level=>fnd_log.level_procedure);
981: END IF;
982: WHEN OTHERS THEN
991: p_data => x_msg_data);
992:
993: -- Debug info.
994: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
995: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
996: p_msg_data=>x_msg_data,
997: p_msg_type=>'SQL ERROR',
998: p_msg_level=>fnd_log.level_error);
999: END IF;
997: p_msg_type=>'SQL ERROR',
998: p_msg_level=>fnd_log.level_error);
999: END IF;
1000: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1001: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
1002: p_prefix=>l_debug_prefix,
1003: p_msg_level=>fnd_log.level_procedure);
1004: END IF;
1005:
1312:
1313:
1314: -- Debug info.
1315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos(+)',
1317: p_prefix=>l_debug_prefix,
1318: p_msg_level=>fnd_log.level_procedure);
1319: END IF;
1320:
1383: end loop;
1384:
1385: -- Debug info.
1386: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1387: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1388: p_msg_data=>x_msg_data,
1389: p_msg_type=>'WARNING',
1390: p_msg_level=>fnd_log.level_exception);
1391: END IF;
1391: END IF;
1392:
1393: -- Debug info.
1394: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1395: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1396: p_prefix=>l_debug_prefix,
1397: p_msg_level=>fnd_log.level_procedure);
1398: END IF;
1399:
1408: p_data => x_msg_data);
1409:
1410: -- Debug info.
1411: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1412: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1413: p_msg_data=>x_msg_data,
1414: p_msg_type=>'ERROR',
1415: p_msg_level=>fnd_log.level_error);
1416: END IF;
1414: p_msg_type=>'ERROR',
1415: p_msg_level=>fnd_log.level_error);
1416: END IF;
1417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1418: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1419: p_prefix=>l_debug_prefix,
1420: p_msg_level=>fnd_log.level_procedure);
1421: END IF;
1422: WHEN fnd_api.g_exc_unexpected_error THEN
1427: p_data => x_msg_data);
1428:
1429: -- Debug info.
1430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1431: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1432: p_msg_data=>x_msg_data,
1433: p_msg_type=>'UNEXPECTED ERROR',
1434: p_msg_level=>fnd_log.level_error);
1435: END IF;
1433: p_msg_type=>'UNEXPECTED ERROR',
1434: p_msg_level=>fnd_log.level_error);
1435: END IF;
1436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1437: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1438: p_prefix=>l_debug_prefix,
1439: p_msg_level=>fnd_log.level_procedure);
1440: END IF;
1441: WHEN OTHERS THEN
1450: p_data => x_msg_data);
1451:
1452: -- Debug info.
1453: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1454: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1455: p_msg_data=>x_msg_data,
1456: p_msg_type=>'SQL ERROR',
1457: p_msg_level=>fnd_log.level_error);
1458: END IF;
1456: p_msg_type=>'SQL ERROR',
1457: p_msg_level=>fnd_log.level_error);
1458: END IF;
1459: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1460: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1461: p_prefix=>l_debug_prefix,
1462: p_msg_level=>fnd_log.level_procedure);
1463: END IF;
1464: