APPS.HZ_EXTRACT_CONT_POINT_BO_PVT dependencies on HZ_UTILITY_V2PUB

Line 227: hz_utility_v2pub.debug(p_message=>'get_phone_bos(+)',

223:
224:
225: -- Debug info.
226: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
227: hz_utility_v2pub.debug(p_message=>'get_phone_bos(+)',
228: p_prefix=>l_debug_prefix,
229: p_msg_level=>fnd_log.level_procedure);
230: END IF;
231:

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

235: close c1;
236:
237: -- Debug info.
238: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
239: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
240: p_msg_data=>x_msg_data,
241: p_msg_type=>'WARNING',
242: p_msg_level=>fnd_log.level_exception);
243: END IF;

Line 247: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',

243: END IF;
244:
245: -- Debug info.
246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
247: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',
248: p_prefix=>l_debug_prefix,
249: p_msg_level=>fnd_log.level_procedure);
250: END IF;
251:

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

260: p_data => x_msg_data);
261:
262: -- Debug info.
263: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
264: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
265: p_msg_data=>x_msg_data,
266: p_msg_type=>'ERROR',
267: p_msg_level=>fnd_log.level_error);
268: END IF;

Line 270: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',

266: p_msg_type=>'ERROR',
267: p_msg_level=>fnd_log.level_error);
268: END IF;
269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
270: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',
271: p_prefix=>l_debug_prefix,
272: p_msg_level=>fnd_log.level_procedure);
273: END IF;
274: WHEN fnd_api.g_exc_unexpected_error THEN

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

279: p_data => x_msg_data);
280:
281: -- Debug info.
282: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
283: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
284: p_msg_data=>x_msg_data,
285: p_msg_type=>'UNEXPECTED ERROR',
286: p_msg_level=>fnd_log.level_error);
287: END IF;

Line 289: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',

285: p_msg_type=>'UNEXPECTED ERROR',
286: p_msg_level=>fnd_log.level_error);
287: END IF;
288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
289: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',
290: p_prefix=>l_debug_prefix,
291: p_msg_level=>fnd_log.level_procedure);
292: END IF;
293: WHEN OTHERS THEN

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

302: p_data => x_msg_data);
303:
304: -- Debug info.
305: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
306: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
307: p_msg_data=>x_msg_data,
308: p_msg_type=>'SQL ERROR',
309: p_msg_level=>fnd_log.level_error);
310: END IF;

Line 312: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',

308: p_msg_type=>'SQL ERROR',
309: p_msg_level=>fnd_log.level_error);
310: END IF;
311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
312: hz_utility_v2pub.debug(p_message=>'get_phone_bos (-)',
313: p_prefix=>l_debug_prefix,
314: p_msg_level=>fnd_log.level_procedure);
315: END IF;
316:

Line 508: hz_utility_v2pub.debug(p_message=>'get_telex_bos(+)',

504: END IF;
505:
506: -- Debug info.
507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
508: hz_utility_v2pub.debug(p_message=>'get_telex_bos(+)',
509: p_prefix=>l_debug_prefix,
510: p_msg_level=>fnd_log.level_procedure);
511: END IF;
512:

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

519:
520:
521: -- Debug info.
522: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
523: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
524: p_msg_data=>x_msg_data,
525: p_msg_type=>'WARNING',
526: p_msg_level=>fnd_log.level_exception);
527: END IF;

Line 531: hz_utility_v2pub.debug(p_message=>'get_telex_bos (-)',

527: END IF;
528:
529: -- Debug info.
530: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
531: hz_utility_v2pub.debug(p_message=>'get_telex_bos (-)',
532: p_prefix=>l_debug_prefix,
533: p_msg_level=>fnd_log.level_procedure);
534: END IF;
535:

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

543: p_data => x_msg_data);
544:
545: -- Debug info.
546: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
547: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
548: p_msg_data=>x_msg_data,
549: p_msg_type=>'ERROR',
550: p_msg_level=>fnd_log.level_error);
551: END IF;

Line 553: hz_utility_v2pub.debug(p_message=>'get_telex_bos(-)',

549: p_msg_type=>'ERROR',
550: p_msg_level=>fnd_log.level_error);
551: END IF;
552: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
553: hz_utility_v2pub.debug(p_message=>'get_telex_bos(-)',
554: p_prefix=>l_debug_prefix,
555: p_msg_level=>fnd_log.level_procedure);
556: END IF;
557: WHEN fnd_api.g_exc_unexpected_error THEN

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

562: p_data => x_msg_data);
563:
564: -- Debug info.
565: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
566: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
567: p_msg_data=>x_msg_data,
568: p_msg_type=>'UNEXPECTED ERROR',
569: p_msg_level=>fnd_log.level_error);
570: END IF;

Line 572: hz_utility_v2pub.debug(p_message=>'get_telex_bos (-)',

568: p_msg_type=>'UNEXPECTED ERROR',
569: p_msg_level=>fnd_log.level_error);
570: END IF;
571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
572: hz_utility_v2pub.debug(p_message=>'get_telex_bos (-)',
573: p_prefix=>l_debug_prefix,
574: p_msg_level=>fnd_log.level_procedure);
575: END IF;
576: WHEN OTHERS THEN

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

585: p_data => x_msg_data);
586:
587: -- Debug info.
588: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
589: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
590: p_msg_data=>x_msg_data,
591: p_msg_type=>'SQL ERROR',
592: p_msg_level=>fnd_log.level_error);
593: END IF;

Line 595: hz_utility_v2pub.debug(p_message=>'get_telex_bos(-)',

591: p_msg_type=>'SQL ERROR',
592: p_msg_level=>fnd_log.level_error);
593: END IF;
594: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
595: hz_utility_v2pub.debug(p_message=>'get_telex_bos(-)',
596: p_prefix=>l_debug_prefix,
597: p_msg_level=>fnd_log.level_procedure);
598: END IF;
599:

Line 789: hz_utility_v2pub.debug(p_message=>'get_email_bos(+)',

785: END IF;
786:
787: -- Debug info.
788: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
789: hz_utility_v2pub.debug(p_message=>'get_email_bos(+)',
790: p_prefix=>l_debug_prefix,
791: p_msg_level=>fnd_log.level_procedure);
792: END IF;
793:

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

799: close c1;
800:
801: -- Debug info.
802: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
803: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
804: p_msg_data=>x_msg_data,
805: p_msg_type=>'WARNING',
806: p_msg_level=>fnd_log.level_exception);
807: END IF;

Line 811: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',

807: END IF;
808:
809: -- Debug info.
810: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
811: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
812: p_prefix=>l_debug_prefix,
813: p_msg_level=>fnd_log.level_procedure);
814: END IF;
815:

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

823: p_data => x_msg_data);
824:
825: -- Debug info.
826: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
827: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
828: p_msg_data=>x_msg_data,
829: p_msg_type=>'ERROR',
830: p_msg_level=>fnd_log.level_error);
831: END IF;

Line 833: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',

829: p_msg_type=>'ERROR',
830: p_msg_level=>fnd_log.level_error);
831: END IF;
832: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
833: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
834: p_prefix=>l_debug_prefix,
835: p_msg_level=>fnd_log.level_procedure);
836: END IF;
837: WHEN fnd_api.g_exc_unexpected_error THEN

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

842: p_data => x_msg_data);
843:
844: -- Debug info.
845: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
846: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
847: p_msg_data=>x_msg_data,
848: p_msg_type=>'UNEXPECTED ERROR',
849: p_msg_level=>fnd_log.level_error);
850: END IF;

Line 852: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',

848: p_msg_type=>'UNEXPECTED ERROR',
849: p_msg_level=>fnd_log.level_error);
850: END IF;
851: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
852: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
853: p_prefix=>l_debug_prefix,
854: p_msg_level=>fnd_log.level_procedure);
855: END IF;
856: WHEN OTHERS THEN

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

865: p_data => x_msg_data);
866:
867: -- Debug info.
868: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
869: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
870: p_msg_data=>x_msg_data,
871: p_msg_type=>'SQL ERROR',
872: p_msg_level=>fnd_log.level_error);
873: END IF;

Line 875: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',

871: p_msg_type=>'SQL ERROR',
872: p_msg_level=>fnd_log.level_error);
873: END IF;
874: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
875: hz_utility_v2pub.debug(p_message=>'get_email_bos (-)',
876: p_prefix=>l_debug_prefix,
877: p_msg_level=>fnd_log.level_procedure);
878: END IF;
879:

Line 1073: hz_utility_v2pub.debug(p_message=>'get_web_bos(+)',

1069: END IF;
1070:
1071: -- Debug info.
1072: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1073: hz_utility_v2pub.debug(p_message=>'get_web_bos(+)',
1074: p_prefix=>l_debug_prefix,
1075: p_msg_level=>fnd_log.level_procedure);
1076: END IF;
1077:

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

1084: close c1;
1085:
1086: -- Debug info.
1087: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1088: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1089: p_msg_data=>x_msg_data,
1090: p_msg_type=>'WARNING',
1091: p_msg_level=>fnd_log.level_exception);
1092: END IF;

Line 1096: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',

1092: END IF;
1093:
1094: -- Debug info.
1095: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1096: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1097: p_prefix=>l_debug_prefix,
1098: p_msg_level=>fnd_log.level_procedure);
1099: END IF;
1100:

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

1108: p_data => x_msg_data);
1109:
1110: -- Debug info.
1111: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1112: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1113: p_msg_data=>x_msg_data,
1114: p_msg_type=>'ERROR',
1115: p_msg_level=>fnd_log.level_error);
1116: END IF;

Line 1118: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',

1114: p_msg_type=>'ERROR',
1115: p_msg_level=>fnd_log.level_error);
1116: END IF;
1117: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1118: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1119: p_prefix=>l_debug_prefix,
1120: p_msg_level=>fnd_log.level_procedure);
1121: END IF;
1122: WHEN fnd_api.g_exc_unexpected_error THEN

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

1127: p_data => x_msg_data);
1128:
1129: -- Debug info.
1130: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1131: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1132: p_msg_data=>x_msg_data,
1133: p_msg_type=>'UNEXPECTED ERROR',
1134: p_msg_level=>fnd_log.level_error);
1135: END IF;

Line 1137: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',

1133: p_msg_type=>'UNEXPECTED ERROR',
1134: p_msg_level=>fnd_log.level_error);
1135: END IF;
1136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1138: p_prefix=>l_debug_prefix,
1139: p_msg_level=>fnd_log.level_procedure);
1140: END IF;
1141: WHEN OTHERS THEN

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

1150: p_data => x_msg_data);
1151:
1152: -- Debug info.
1153: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1154: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1155: p_msg_data=>x_msg_data,
1156: p_msg_type=>'SQL ERROR',
1157: p_msg_level=>fnd_log.level_error);
1158: END IF;

Line 1160: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',

1156: p_msg_type=>'SQL ERROR',
1157: p_msg_level=>fnd_log.level_error);
1158: END IF;
1159: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1160: hz_utility_v2pub.debug(p_message=>'get_web_bos (-)',
1161: p_prefix=>l_debug_prefix,
1162: p_msg_level=>fnd_log.level_procedure);
1163: END IF;
1164:

Line 1364: hz_utility_v2pub.debug(p_message=>'get_edi_bos(+)',

1360: END IF;
1361:
1362: -- Debug info.
1363: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1364: hz_utility_v2pub.debug(p_message=>'get_edi_bos(+)',
1365: p_prefix=>l_debug_prefix,
1366: p_msg_level=>fnd_log.level_procedure);
1367: END IF;
1368:

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

1373:
1374:
1375: -- Debug info.
1376: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1377: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1378: p_msg_data=>x_msg_data,
1379: p_msg_type=>'WARNING',
1380: p_msg_level=>fnd_log.level_exception);
1381: END IF;

Line 1385: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',

1381: END IF;
1382:
1383: -- Debug info.
1384: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1385: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',
1386: p_prefix=>l_debug_prefix,
1387: p_msg_level=>fnd_log.level_procedure);
1388: END IF;
1389:

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

1397: p_data => x_msg_data);
1398:
1399: -- Debug info.
1400: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1401: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1402: p_msg_data=>x_msg_data,
1403: p_msg_type=>'ERROR',
1404: p_msg_level=>fnd_log.level_error);
1405: END IF;

Line 1407: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',

1403: p_msg_type=>'ERROR',
1404: p_msg_level=>fnd_log.level_error);
1405: END IF;
1406: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1407: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',
1408: p_prefix=>l_debug_prefix,
1409: p_msg_level=>fnd_log.level_procedure);
1410: END IF;
1411: WHEN fnd_api.g_exc_unexpected_error THEN

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

1416: p_data => x_msg_data);
1417:
1418: -- Debug info.
1419: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1420: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1421: p_msg_data=>x_msg_data,
1422: p_msg_type=>'UNEXPECTED ERROR',
1423: p_msg_level=>fnd_log.level_error);
1424: END IF;

Line 1426: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',

1422: p_msg_type=>'UNEXPECTED ERROR',
1423: p_msg_level=>fnd_log.level_error);
1424: END IF;
1425: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1426: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',
1427: p_prefix=>l_debug_prefix,
1428: p_msg_level=>fnd_log.level_procedure);
1429: END IF;
1430: WHEN OTHERS THEN

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

1439: p_data => x_msg_data);
1440:
1441: -- Debug info.
1442: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1443: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1444: p_msg_data=>x_msg_data,
1445: p_msg_type=>'SQL ERROR',
1446: p_msg_level=>fnd_log.level_error);
1447: END IF;

Line 1449: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',

1445: p_msg_type=>'SQL ERROR',
1446: p_msg_level=>fnd_log.level_error);
1447: END IF;
1448: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1449: hz_utility_v2pub.debug(p_message=>'get_edi_bos (-)',
1450: p_prefix=>l_debug_prefix,
1451: p_msg_level=>fnd_log.level_procedure);
1452: END IF;
1453:

Line 1648: hz_utility_v2pub.debug(p_message=>'get_eft_bos(+)',

1644: END IF;
1645:
1646: -- Debug info.
1647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1648: hz_utility_v2pub.debug(p_message=>'get_eft_bos(+)',
1649: p_prefix=>l_debug_prefix,
1650: p_msg_level=>fnd_log.level_procedure);
1651: END IF;
1652:

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

1657: close c1;
1658:
1659: -- Debug info.
1660: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1661: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1662: p_msg_data=>x_msg_data,
1663: p_msg_type=>'WARNING',
1664: p_msg_level=>fnd_log.level_exception);
1665: END IF;

Line 1669: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',

1665: END IF;
1666:
1667: -- Debug info.
1668: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1669: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1670: p_prefix=>l_debug_prefix,
1671: p_msg_level=>fnd_log.level_procedure);
1672: END IF;
1673:

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

1681: p_data => x_msg_data);
1682:
1683: -- Debug info.
1684: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1685: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1686: p_msg_data=>x_msg_data,
1687: p_msg_type=>'ERROR',
1688: p_msg_level=>fnd_log.level_error);
1689: END IF;

Line 1691: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',

1687: p_msg_type=>'ERROR',
1688: p_msg_level=>fnd_log.level_error);
1689: END IF;
1690: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1691: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1692: p_prefix=>l_debug_prefix,
1693: p_msg_level=>fnd_log.level_procedure);
1694: END IF;
1695: WHEN fnd_api.g_exc_unexpected_error THEN

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

1700: p_data => x_msg_data);
1701:
1702: -- Debug info.
1703: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1704: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1705: p_msg_data=>x_msg_data,
1706: p_msg_type=>'UNEXPECTED ERROR',
1707: p_msg_level=>fnd_log.level_error);
1708: END IF;

Line 1710: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',

1706: p_msg_type=>'UNEXPECTED ERROR',
1707: p_msg_level=>fnd_log.level_error);
1708: END IF;
1709: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1710: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1711: p_prefix=>l_debug_prefix,
1712: p_msg_level=>fnd_log.level_procedure);
1713: END IF;
1714: WHEN OTHERS THEN

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

1723: p_data => x_msg_data);
1724:
1725: -- Debug info.
1726: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1727: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1728: p_msg_data=>x_msg_data,
1729: p_msg_type=>'SQL ERROR',
1730: p_msg_level=>fnd_log.level_error);
1731: END IF;

Line 1733: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',

1729: p_msg_type=>'SQL ERROR',
1730: p_msg_level=>fnd_log.level_error);
1731: END IF;
1732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1733: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1734: p_prefix=>l_debug_prefix,
1735: p_msg_level=>fnd_log.level_procedure);
1736: END IF;
1737:

Line 1936: hz_utility_v2pub.debug(p_message=>'get_sms_bos(+)',

1932: END IF;
1933:
1934: -- Debug info.
1935: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1936: hz_utility_v2pub.debug(p_message=>'get_sms_bos(+)',
1937: p_prefix=>l_debug_prefix,
1938: p_msg_level=>fnd_log.level_procedure);
1939: END IF;
1940:

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

1946: close c1;
1947:
1948: -- Debug info.
1949: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1950: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1951: p_msg_data=>x_msg_data,
1952: p_msg_type=>'WARNING',
1953: p_msg_level=>fnd_log.level_exception);
1954: END IF;

Line 1958: hz_utility_v2pub.debug(p_message=>'get_sms_bos (-)',

1954: END IF;
1955:
1956: -- Debug info.
1957: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1958: hz_utility_v2pub.debug(p_message=>'get_sms_bos (-)',
1959: p_prefix=>l_debug_prefix,
1960: p_msg_level=>fnd_log.level_procedure);
1961: END IF;
1962:

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

1970: p_data => x_msg_data);
1971:
1972: -- Debug info.
1973: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1974: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1975: p_msg_data=>x_msg_data,
1976: p_msg_type=>'ERROR',
1977: p_msg_level=>fnd_log.level_error);
1978: END IF;

Line 1980: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',

1976: p_msg_type=>'ERROR',
1977: p_msg_level=>fnd_log.level_error);
1978: END IF;
1979: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1980: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
1981: p_prefix=>l_debug_prefix,
1982: p_msg_level=>fnd_log.level_procedure);
1983: END IF;
1984: WHEN fnd_api.g_exc_unexpected_error THEN

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

1989: p_data => x_msg_data);
1990:
1991: -- Debug info.
1992: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1993: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1994: p_msg_data=>x_msg_data,
1995: p_msg_type=>'UNEXPECTED ERROR',
1996: p_msg_level=>fnd_log.level_error);
1997: END IF;

Line 1999: hz_utility_v2pub.debug(p_message=>'get_sms_bos (-)',

1995: p_msg_type=>'UNEXPECTED ERROR',
1996: p_msg_level=>fnd_log.level_error);
1997: END IF;
1998: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1999: hz_utility_v2pub.debug(p_message=>'get_sms_bos (-)',
2000: p_prefix=>l_debug_prefix,
2001: p_msg_level=>fnd_log.level_procedure);
2002: END IF;
2003: WHEN OTHERS THEN

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

2012: p_data => x_msg_data);
2013:
2014: -- Debug info.
2015: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2016: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2017: p_msg_data=>x_msg_data,
2018: p_msg_type=>'SQL ERROR',
2019: p_msg_level=>fnd_log.level_error);
2020: END IF;

Line 2022: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',

2018: p_msg_type=>'SQL ERROR',
2019: p_msg_level=>fnd_log.level_error);
2020: END IF;
2021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2022: hz_utility_v2pub.debug(p_message=>'get_eft_bos (-)',
2023: p_prefix=>l_debug_prefix,
2024: p_msg_level=>fnd_log.level_procedure);
2025: END IF;
2026:

Line 2090: hz_utility_v2pub.debug(p_message=>'get_cont_pref_objs(-)',

2086: END IF;
2087:
2088: -- Debug info.
2089: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2090: hz_utility_v2pub.debug(p_message=>'get_cont_pref_objs(-)',
2091: p_prefix=>l_debug_prefix,
2092: p_msg_level=>fnd_log.level_procedure);
2093: END IF;
2094:

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

2099: close c1;
2100:
2101: -- Debug info.
2102: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2103: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2104: p_msg_data=>x_msg_data,
2105: p_msg_type=>'WARNING',
2106: p_msg_level=>fnd_log.level_exception);
2107: END IF;

Line 2111: hz_utility_v2pub.debug(p_message=>'get_cont_pref_objs(-)',

2107: END IF;
2108:
2109: -- Debug info.
2110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2111: hz_utility_v2pub.debug(p_message=>'get_cont_pref_objs(-)',
2112: p_prefix=>l_debug_prefix,
2113: p_msg_level=>fnd_log.level_procedure);
2114: END IF;
2115:

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

2127: p_data => x_msg_data);
2128:
2129: -- Debug info.
2130: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2131: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2132: p_msg_data=>x_msg_data,
2133: p_msg_type=>'SQL ERROR',
2134: p_msg_level=>fnd_log.level_error);
2135: END IF;

Line 2137: hz_utility_v2pub.debug(p_message=>'get_cont_pref_objs(-)',

2133: p_msg_type=>'SQL ERROR',
2134: p_msg_level=>fnd_log.level_error);
2135: END IF;
2136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2137: hz_utility_v2pub.debug(p_message=>'get_cont_pref_objs(-)',
2138: p_prefix=>l_debug_prefix,
2139: p_msg_level=>fnd_log.level_procedure);
2140: END IF;
2141: