APPS.HZ_EXTRACT_ORG_CUST_BO_PVT dependencies on HZ_UTILITY_V2PUB

Line 87: hz_utility_v2pub.debug(p_message=>'get_org_cust_bo(+)',

83:
84:
85: -- Debug info.
86: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
87: hz_utility_v2pub.debug(p_message=>'get_org_cust_bo(+)',
88: p_prefix=>l_debug_prefix,
89: p_msg_level=>fnd_log.level_procedure);
90: END IF;
91:

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

121:
122:
123: -- Debug info.
124: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
125: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
126: p_msg_data=>x_msg_data,
127: p_msg_type=>'WARNING',
128: p_msg_level=>fnd_log.level_exception);
129: END IF;

Line 133: hz_utility_v2pub.debug(p_message=>'get_org_cust_bo (-)',

129: END IF;
130:
131: -- Debug info.
132: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
133: hz_utility_v2pub.debug(p_message=>'get_org_cust_bo (-)',
134: p_prefix=>l_debug_prefix,
135: p_msg_level=>fnd_log.level_procedure);
136: END IF;
137:

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

146: p_data => x_msg_data);
147:
148: -- Debug info.
149: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
150: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
151: p_msg_data=>x_msg_data,
152: p_msg_type=>'ERROR',
153: p_msg_level=>fnd_log.level_error);
154: END IF;

Line 156: hz_utility_v2pub.debug(p_message=>'get_org_cust_bo (-)',

152: p_msg_type=>'ERROR',
153: p_msg_level=>fnd_log.level_error);
154: END IF;
155: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
156: hz_utility_v2pub.debug(p_message=>'get_org_cust_bo (-)',
157: p_prefix=>l_debug_prefix,
158: p_msg_level=>fnd_log.level_procedure);
159: END IF;
160: WHEN fnd_api.g_exc_unexpected_error THEN

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

165: p_data => x_msg_data);
166:
167: -- Debug info.
168: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
169: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
170: p_msg_data=>x_msg_data,
171: p_msg_type=>'UNEXPECTED ERROR',
172: p_msg_level=>fnd_log.level_error);
173: END IF;

Line 175: hz_utility_v2pub.debug(p_message=>'get_org_cust_bo (-)',

171: p_msg_type=>'UNEXPECTED ERROR',
172: p_msg_level=>fnd_log.level_error);
173: END IF;
174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
175: hz_utility_v2pub.debug(p_message=>'get_org_cust_bo (-)',
176: p_prefix=>l_debug_prefix,
177: p_msg_level=>fnd_log.level_procedure);
178: END IF;
179: WHEN OTHERS THEN

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

188: p_data => x_msg_data);
189:
190: -- Debug info.
191: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
192: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
193: p_msg_data=>x_msg_data,
194: p_msg_type=>'SQL ERROR',
195: p_msg_level=>fnd_log.level_error);
196: END IF;

Line 198: hz_utility_v2pub.debug(p_message=>'get_org_cust_bo (-)',

194: p_msg_type=>'SQL ERROR',
195: p_msg_level=>fnd_log.level_error);
196: END IF;
197: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
198: hz_utility_v2pub.debug(p_message=>'get_org_cust_bo (-)',
199: p_prefix=>l_debug_prefix,
200: p_msg_level=>fnd_log.level_procedure);
201: END IF;
202:

Line 301: hz_utility_v2pub.debug(p_message=>'get_org_cust_created(+)',

297:
298:
299: -- Debug info.
300: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
301: hz_utility_v2pub.debug(p_message=>'get_org_cust_created(+)',
302: p_prefix=>l_debug_prefix,
303: p_msg_level=>fnd_log.level_procedure);
304: END IF;
305:

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

395: end loop;
396:
397: -- Debug info.
398: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
399: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
400: p_msg_data=>x_msg_data,
401: p_msg_type=>'WARNING',
402: p_msg_level=>fnd_log.level_exception);
403: END IF;

Line 407: hz_utility_v2pub.debug(p_message=>'get_org_cust_created (-)',

403: END IF;
404:
405: -- Debug info.
406: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
407: hz_utility_v2pub.debug(p_message=>'get_org_cust_created (-)',
408: p_prefix=>l_debug_prefix,
409: p_msg_level=>fnd_log.level_procedure);
410: END IF;
411:

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

420: p_data => x_msg_data);
421:
422: -- Debug info.
423: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
424: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
425: p_msg_data=>x_msg_data,
426: p_msg_type=>'ERROR',
427: p_msg_level=>fnd_log.level_error);
428: END IF;

Line 430: hz_utility_v2pub.debug(p_message=>'get_org_cust_created(-)',

426: p_msg_type=>'ERROR',
427: p_msg_level=>fnd_log.level_error);
428: END IF;
429: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
430: hz_utility_v2pub.debug(p_message=>'get_org_cust_created(-)',
431: p_prefix=>l_debug_prefix,
432: p_msg_level=>fnd_log.level_procedure);
433: END IF;
434: WHEN fnd_api.g_exc_unexpected_error THEN

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

439: p_data => x_msg_data);
440:
441: -- Debug info.
442: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
443: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
444: p_msg_data=>x_msg_data,
445: p_msg_type=>'UNEXPECTED ERROR',
446: p_msg_level=>fnd_log.level_error);
447: END IF;

Line 449: hz_utility_v2pub.debug(p_message=>'get_org_cust_created(-)',

445: p_msg_type=>'UNEXPECTED ERROR',
446: p_msg_level=>fnd_log.level_error);
447: END IF;
448: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
449: hz_utility_v2pub.debug(p_message=>'get_org_cust_created(-)',
450: p_prefix=>l_debug_prefix,
451: p_msg_level=>fnd_log.level_procedure);
452: END IF;
453: WHEN OTHERS THEN

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

462: p_data => x_msg_data);
463:
464: -- Debug info.
465: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
466: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
467: p_msg_data=>x_msg_data,
468: p_msg_type=>'SQL ERROR',
469: p_msg_level=>fnd_log.level_error);
470: END IF;

Line 472: hz_utility_v2pub.debug(p_message=>'get_org_cust_created(-)',

468: p_msg_type=>'SQL ERROR',
469: p_msg_level=>fnd_log.level_error);
470: END IF;
471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
472: hz_utility_v2pub.debug(p_message=>'get_org_cust_created(-)',
473: p_prefix=>l_debug_prefix,
474: p_msg_level=>fnd_log.level_procedure);
475: END IF;
476:

Line 551: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(+)',

547:
548:
549: -- Debug info.
550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
551: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(+)',
552: p_prefix=>l_debug_prefix,
553: p_msg_level=>fnd_log.level_procedure);
554: END IF;
555:

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

585:
586:
587: -- Debug info.
588: IF fnd_log.level_exception>=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=>'WARNING',
592: p_msg_level=>fnd_log.level_exception);
593: END IF;

Line 597: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated (-)',

593: END IF;
594:
595: -- Debug info.
596: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
597: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated (-)',
598: p_prefix=>l_debug_prefix,
599: p_msg_level=>fnd_log.level_procedure);
600: END IF;
601:

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

610: p_data => x_msg_data);
611:
612: -- Debug info.
613: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
614: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
615: p_msg_data=>x_msg_data,
616: p_msg_type=>'ERROR',
617: p_msg_level=>fnd_log.level_error);
618: END IF;

Line 620: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(-)',

616: p_msg_type=>'ERROR',
617: p_msg_level=>fnd_log.level_error);
618: END IF;
619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
620: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(-)',
621: p_prefix=>l_debug_prefix,
622: p_msg_level=>fnd_log.level_procedure);
623: END IF;
624: WHEN fnd_api.g_exc_unexpected_error THEN

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

629: p_data => x_msg_data);
630:
631: -- Debug info.
632: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
633: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
634: p_msg_data=>x_msg_data,
635: p_msg_type=>'UNEXPECTED ERROR',
636: p_msg_level=>fnd_log.level_error);
637: END IF;

Line 639: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(-)',

635: p_msg_type=>'UNEXPECTED ERROR',
636: p_msg_level=>fnd_log.level_error);
637: END IF;
638: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
639: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(-)',
640: p_prefix=>l_debug_prefix,
641: p_msg_level=>fnd_log.level_procedure);
642: END IF;
643: WHEN OTHERS THEN

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

652: p_data => x_msg_data);
653:
654: -- Debug info.
655: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
656: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
657: p_msg_data=>x_msg_data,
658: p_msg_type=>'SQL ERROR',
659: p_msg_level=>fnd_log.level_error);
660: END IF;

Line 662: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(-)',

658: p_msg_type=>'SQL ERROR',
659: p_msg_level=>fnd_log.level_error);
660: END IF;
661: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
662: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(-)',
663: p_prefix=>l_debug_prefix,
664: p_msg_level=>fnd_log.level_procedure);
665: END IF;
666:

Line 1068: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(+)',

1064:
1065:
1066: -- Debug info.
1067: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1068: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(+)',
1069: p_prefix=>l_debug_prefix,
1070: p_msg_level=>fnd_log.level_procedure);
1071: END IF;
1072:

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

1104:
1105:
1106: -- Debug info.
1107: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1108: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1109: p_msg_data=>x_msg_data,
1110: p_msg_type=>'WARNING',
1111: p_msg_level=>fnd_log.level_exception);
1112: END IF;

Line 1116: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated (-)',

1112: END IF;
1113:
1114: -- Debug info.
1115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1116: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated (-)',
1117: p_prefix=>l_debug_prefix,
1118: p_msg_level=>fnd_log.level_procedure);
1119: END IF;
1120:

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

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

Line 1139: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',

1135: p_msg_type=>'ERROR',
1136: p_msg_level=>fnd_log.level_error);
1137: END IF;
1138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1140: p_prefix=>l_debug_prefix,
1141: p_msg_level=>fnd_log.level_procedure);
1142: END IF;
1143: WHEN fnd_api.g_exc_unexpected_error THEN

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

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

Line 1158: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',

1154: p_msg_type=>'UNEXPECTED ERROR',
1155: p_msg_level=>fnd_log.level_error);
1156: END IF;
1157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1158: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1159: p_prefix=>l_debug_prefix,
1160: p_msg_level=>fnd_log.level_procedure);
1161: END IF;
1162: WHEN OTHERS THEN

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

1171: p_data => x_msg_data);
1172:
1173: -- Debug info.
1174: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1175: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1176: p_msg_data=>x_msg_data,
1177: p_msg_type=>'SQL ERROR',
1178: p_msg_level=>fnd_log.level_error);
1179: END IF;

Line 1181: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',

1177: p_msg_type=>'SQL ERROR',
1178: p_msg_level=>fnd_log.level_error);
1179: END IF;
1180: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1181: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1182: p_prefix=>l_debug_prefix,
1183: p_msg_level=>fnd_log.level_procedure);
1184: END IF;
1185:

Line 1262: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo(+)',

1258:
1259:
1260: -- Debug info.
1261: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1262: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo(+)',
1263: p_prefix=>l_debug_prefix,
1264: p_msg_level=>fnd_log.level_procedure);
1265: END IF;
1266:

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

1296:
1297:
1298: -- Debug info.
1299: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1300: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1301: p_msg_data=>x_msg_data,
1302: p_msg_type=>'WARNING',
1303: p_msg_level=>fnd_log.level_exception);
1304: END IF;

Line 1308: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',

1304: END IF;
1305:
1306: -- Debug info.
1307: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1308: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1309: p_prefix=>l_debug_prefix,
1310: p_msg_level=>fnd_log.level_procedure);
1311: END IF;
1312:

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

1321: p_data => x_msg_data);
1322:
1323: -- Debug info.
1324: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1325: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1326: p_msg_data=>x_msg_data,
1327: p_msg_type=>'ERROR',
1328: p_msg_level=>fnd_log.level_error);
1329: END IF;

Line 1331: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',

1327: p_msg_type=>'ERROR',
1328: p_msg_level=>fnd_log.level_error);
1329: END IF;
1330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1331: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1332: p_prefix=>l_debug_prefix,
1333: p_msg_level=>fnd_log.level_procedure);
1334: END IF;
1335: WHEN fnd_api.g_exc_unexpected_error THEN

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

1340: p_data => x_msg_data);
1341:
1342: -- Debug info.
1343: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1344: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1345: p_msg_data=>x_msg_data,
1346: p_msg_type=>'UNEXPECTED ERROR',
1347: p_msg_level=>fnd_log.level_error);
1348: END IF;

Line 1350: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',

1346: p_msg_type=>'UNEXPECTED ERROR',
1347: p_msg_level=>fnd_log.level_error);
1348: END IF;
1349: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1350: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1351: p_prefix=>l_debug_prefix,
1352: p_msg_level=>fnd_log.level_procedure);
1353: END IF;
1354: WHEN OTHERS THEN

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

1363: p_data => x_msg_data);
1364:
1365: -- Debug info.
1366: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1367: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1368: p_msg_data=>x_msg_data,
1369: p_msg_type=>'SQL ERROR',
1370: p_msg_level=>fnd_log.level_error);
1371: END IF;

Line 1373: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',

1369: p_msg_type=>'SQL ERROR',
1370: p_msg_level=>fnd_log.level_error);
1371: END IF;
1372: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1373: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1374: p_prefix=>l_debug_prefix,
1375: p_msg_level=>fnd_log.level_procedure);
1376: END IF;
1377:

Line 1456: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(+)',

1452:
1453:
1454: -- Debug info.
1455: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1456: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(+)',
1457: p_prefix=>l_debug_prefix,
1458: p_msg_level=>fnd_log.level_procedure);
1459: END IF;
1460:

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

1537: end loop;
1538:
1539: -- Debug info.
1540: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1541: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1542: p_msg_data=>x_msg_data,
1543: p_msg_type=>'WARNING',
1544: p_msg_level=>fnd_log.level_exception);
1545: END IF;

Line 1549: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created (-)',

1545: END IF;
1546:
1547: -- Debug info.
1548: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1549: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created (-)',
1550: p_prefix=>l_debug_prefix,
1551: p_msg_level=>fnd_log.level_procedure);
1552: END IF;
1553:

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

1562: p_data => x_msg_data);
1563:
1564: -- Debug info.
1565: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1566: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1567: p_msg_data=>x_msg_data,
1568: p_msg_type=>'ERROR',
1569: p_msg_level=>fnd_log.level_error);
1570: END IF;

Line 1572: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',

1568: p_msg_type=>'ERROR',
1569: p_msg_level=>fnd_log.level_error);
1570: END IF;
1571: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1572: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1573: p_prefix=>l_debug_prefix,
1574: p_msg_level=>fnd_log.level_procedure);
1575: END IF;
1576: WHEN fnd_api.g_exc_unexpected_error THEN

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

1581: p_data => x_msg_data);
1582:
1583: -- Debug info.
1584: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1585: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1586: p_msg_data=>x_msg_data,
1587: p_msg_type=>'UNEXPECTED ERROR',
1588: p_msg_level=>fnd_log.level_error);
1589: END IF;

Line 1591: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',

1587: p_msg_type=>'UNEXPECTED ERROR',
1588: p_msg_level=>fnd_log.level_error);
1589: END IF;
1590: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1591: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1592: p_prefix=>l_debug_prefix,
1593: p_msg_level=>fnd_log.level_procedure);
1594: END IF;
1595: WHEN OTHERS THEN

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

1604: p_data => x_msg_data);
1605:
1606: -- Debug info.
1607: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1608: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1609: p_msg_data=>x_msg_data,
1610: p_msg_type=>'SQL ERROR',
1611: p_msg_level=>fnd_log.level_error);
1612: END IF;

Line 1614: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',

1610: p_msg_type=>'SQL ERROR',
1611: p_msg_level=>fnd_log.level_error);
1612: END IF;
1613: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1614: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1615: p_prefix=>l_debug_prefix,
1616: p_msg_level=>fnd_log.level_procedure);
1617: END IF;
1618:

Line 1693: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(+)',

1689:
1690:
1691: -- Debug info.
1692: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1693: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(+)',
1694: p_prefix=>l_debug_prefix,
1695: p_msg_level=>fnd_log.level_procedure);
1696: END IF;
1697:

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

1727:
1728:
1729: -- Debug info.
1730: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1731: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1732: p_msg_data=>x_msg_data,
1733: p_msg_type=>'WARNING',
1734: p_msg_level=>fnd_log.level_exception);
1735: END IF;

Line 1739: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated (-)',

1735: END IF;
1736:
1737: -- Debug info.
1738: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1739: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated (-)',
1740: p_prefix=>l_debug_prefix,
1741: p_msg_level=>fnd_log.level_procedure);
1742: END IF;
1743:

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

1752: p_data => x_msg_data);
1753:
1754: -- Debug info.
1755: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1756: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1757: p_msg_data=>x_msg_data,
1758: p_msg_type=>'ERROR',
1759: p_msg_level=>fnd_log.level_error);
1760: END IF;

Line 1762: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',

1758: p_msg_type=>'ERROR',
1759: p_msg_level=>fnd_log.level_error);
1760: END IF;
1761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1762: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1763: p_prefix=>l_debug_prefix,
1764: p_msg_level=>fnd_log.level_procedure);
1765: END IF;
1766: WHEN fnd_api.g_exc_unexpected_error THEN

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

1771: p_data => x_msg_data);
1772:
1773: -- Debug info.
1774: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1775: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1776: p_msg_data=>x_msg_data,
1777: p_msg_type=>'UNEXPECTED ERROR',
1778: p_msg_level=>fnd_log.level_error);
1779: END IF;

Line 1781: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',

1777: p_msg_type=>'UNEXPECTED ERROR',
1778: p_msg_level=>fnd_log.level_error);
1779: END IF;
1780: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1781: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1782: p_prefix=>l_debug_prefix,
1783: p_msg_level=>fnd_log.level_procedure);
1784: END IF;
1785: WHEN OTHERS THEN

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

1794: p_data => x_msg_data);
1795:
1796: -- Debug info.
1797: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1798: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1799: p_msg_data=>x_msg_data,
1800: p_msg_type=>'SQL ERROR',
1801: p_msg_level=>fnd_log.level_error);
1802: END IF;

Line 1804: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',

1800: p_msg_type=>'SQL ERROR',
1801: p_msg_level=>fnd_log.level_error);
1802: END IF;
1803: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1804: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1805: p_prefix=>l_debug_prefix,
1806: p_msg_level=>fnd_log.level_procedure);
1807: END IF;
1808:

Line 2214: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(+)',

2210:
2211:
2212: -- Debug info.
2213: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2214: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(+)',
2215: p_prefix=>l_debug_prefix,
2216: p_msg_level=>fnd_log.level_procedure);
2217: END IF;
2218:

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

2241:
2242:
2243: -- Debug info.
2244: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2245: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2246: p_msg_data=>x_msg_data,
2247: p_msg_type=>'WARNING',
2248: p_msg_level=>fnd_log.level_exception);
2249: END IF;

Line 2253: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated (-)',

2249: END IF;
2250:
2251: -- Debug info.
2252: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2253: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated (-)',
2254: p_prefix=>l_debug_prefix,
2255: p_msg_level=>fnd_log.level_procedure);
2256: END IF;
2257:

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

2266: p_data => x_msg_data);
2267:
2268: -- Debug info.
2269: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2270: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2271: p_msg_data=>x_msg_data,
2272: p_msg_type=>'ERROR',
2273: p_msg_level=>fnd_log.level_error);
2274: END IF;

Line 2276: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',

2272: p_msg_type=>'ERROR',
2273: p_msg_level=>fnd_log.level_error);
2274: END IF;
2275: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2276: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2277: p_prefix=>l_debug_prefix,
2278: p_msg_level=>fnd_log.level_procedure);
2279: END IF;
2280: WHEN fnd_api.g_exc_unexpected_error THEN

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

2285: p_data => x_msg_data);
2286:
2287: -- Debug info.
2288: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2289: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2290: p_msg_data=>x_msg_data,
2291: p_msg_type=>'UNEXPECTED ERROR',
2292: p_msg_level=>fnd_log.level_error);
2293: END IF;

Line 2295: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',

2291: p_msg_type=>'UNEXPECTED ERROR',
2292: p_msg_level=>fnd_log.level_error);
2293: END IF;
2294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2295: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2296: p_prefix=>l_debug_prefix,
2297: p_msg_level=>fnd_log.level_procedure);
2298: END IF;
2299: WHEN OTHERS THEN

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

2308: p_data => x_msg_data);
2309:
2310: -- Debug info.
2311: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2312: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2313: p_msg_data=>x_msg_data,
2314: p_msg_type=>'SQL ERROR',
2315: p_msg_level=>fnd_log.level_error);
2316: END IF;

Line 2318: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',

2314: p_msg_type=>'SQL ERROR',
2315: p_msg_level=>fnd_log.level_error);
2316: END IF;
2317: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2318: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2319: p_prefix=>l_debug_prefix,
2320: p_msg_level=>fnd_log.level_procedure);
2321: END IF;
2322: