DBA Data[Home] [Help]

APPS.HZ_EXTRACT_CUST_ACCT_BO_PVT dependencies on HZ_UTILITY_V2PUB

Line 124: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo(+)',

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:

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

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;

Line 143: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',

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:

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

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;

Line 166: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',

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

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

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;

Line 185: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',

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

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

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;

Line 208: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',

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:

Line 454: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo(+)',

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:

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

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;

Line 473: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',

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:

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

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;

Line 496: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',

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

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

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;

Line 515: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',

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

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

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;

Line 538: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',

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:

Line 857: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos(+)',

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:

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

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;

Line 936: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',

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:

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

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;

Line 959: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',

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

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

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;

Line 978: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',

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

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

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;

Line 1001: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',

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:

Line 1316: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos(+)',

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:

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

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;

Line 1395: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',

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:

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

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;

Line 1418: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',

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

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

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;

Line 1437: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',

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

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

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;

Line 1460: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',

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: