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 1106: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(+)',

1102:
1103:
1104: -- Debug info.
1105: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1106: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(+)',
1107: p_prefix=>l_debug_prefix,
1108: p_msg_level=>fnd_log.level_procedure);
1109: END IF;
1110:

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

1142:
1143:
1144: -- Debug info.
1145: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1146: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1147: p_msg_data=>x_msg_data,
1148: p_msg_type=>'WARNING',
1149: p_msg_level=>fnd_log.level_exception);
1150: END IF;

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

1150: END IF;
1151:
1152: -- Debug info.
1153: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1154: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated (-)',
1155: p_prefix=>l_debug_prefix,
1156: p_msg_level=>fnd_log.level_procedure);
1157: END IF;
1158:

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

1167: p_data => x_msg_data);
1168:
1169: -- Debug info.
1170: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1171: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1172: p_msg_data=>x_msg_data,
1173: p_msg_type=>'ERROR',
1174: p_msg_level=>fnd_log.level_error);
1175: END IF;

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

1173: p_msg_type=>'ERROR',
1174: p_msg_level=>fnd_log.level_error);
1175: END IF;
1176: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1177: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1178: p_prefix=>l_debug_prefix,
1179: p_msg_level=>fnd_log.level_procedure);
1180: END IF;
1181: WHEN fnd_api.g_exc_unexpected_error THEN

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

1186: p_data => x_msg_data);
1187:
1188: -- Debug info.
1189: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1190: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1191: p_msg_data=>x_msg_data,
1192: p_msg_type=>'UNEXPECTED ERROR',
1193: p_msg_level=>fnd_log.level_error);
1194: END IF;

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

1192: p_msg_type=>'UNEXPECTED ERROR',
1193: p_msg_level=>fnd_log.level_error);
1194: END IF;
1195: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1196: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1197: p_prefix=>l_debug_prefix,
1198: p_msg_level=>fnd_log.level_procedure);
1199: END IF;
1200: WHEN OTHERS THEN

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

1209: p_data => x_msg_data);
1210:
1211: -- Debug info.
1212: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1213: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1214: p_msg_data=>x_msg_data,
1215: p_msg_type=>'SQL ERROR',
1216: p_msg_level=>fnd_log.level_error);
1217: END IF;

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

1215: p_msg_type=>'SQL ERROR',
1216: p_msg_level=>fnd_log.level_error);
1217: END IF;
1218: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1219: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1220: p_prefix=>l_debug_prefix,
1221: p_msg_level=>fnd_log.level_procedure);
1222: END IF;
1223:

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

1296:
1297:
1298: -- Debug info.
1299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1300: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo(+)',
1301: p_prefix=>l_debug_prefix,
1302: p_msg_level=>fnd_log.level_procedure);
1303: END IF;
1304:

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

1334:
1335:
1336: -- Debug info.
1337: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1338: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1339: p_msg_data=>x_msg_data,
1340: p_msg_type=>'WARNING',
1341: p_msg_level=>fnd_log.level_exception);
1342: END IF;

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

1342: END IF;
1343:
1344: -- Debug info.
1345: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1346: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1347: p_prefix=>l_debug_prefix,
1348: p_msg_level=>fnd_log.level_procedure);
1349: END IF;
1350:

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

1359: p_data => x_msg_data);
1360:
1361: -- Debug info.
1362: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1363: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1364: p_msg_data=>x_msg_data,
1365: p_msg_type=>'ERROR',
1366: p_msg_level=>fnd_log.level_error);
1367: END IF;

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

1365: p_msg_type=>'ERROR',
1366: p_msg_level=>fnd_log.level_error);
1367: END IF;
1368: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1369: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1370: p_prefix=>l_debug_prefix,
1371: p_msg_level=>fnd_log.level_procedure);
1372: END IF;
1373: WHEN fnd_api.g_exc_unexpected_error THEN

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

1378: p_data => x_msg_data);
1379:
1380: -- Debug info.
1381: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1382: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1383: p_msg_data=>x_msg_data,
1384: p_msg_type=>'UNEXPECTED ERROR',
1385: p_msg_level=>fnd_log.level_error);
1386: END IF;

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

1384: p_msg_type=>'UNEXPECTED ERROR',
1385: p_msg_level=>fnd_log.level_error);
1386: END IF;
1387: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1388: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1389: p_prefix=>l_debug_prefix,
1390: p_msg_level=>fnd_log.level_procedure);
1391: END IF;
1392: WHEN OTHERS THEN

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

1401: p_data => x_msg_data);
1402:
1403: -- Debug info.
1404: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1405: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1406: p_msg_data=>x_msg_data,
1407: p_msg_type=>'SQL ERROR',
1408: p_msg_level=>fnd_log.level_error);
1409: END IF;

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

1407: p_msg_type=>'SQL ERROR',
1408: p_msg_level=>fnd_log.level_error);
1409: END IF;
1410: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1411: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1412: p_prefix=>l_debug_prefix,
1413: p_msg_level=>fnd_log.level_procedure);
1414: END IF;
1415:

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

1490:
1491:
1492: -- Debug info.
1493: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1494: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(+)',
1495: p_prefix=>l_debug_prefix,
1496: p_msg_level=>fnd_log.level_procedure);
1497: END IF;
1498:

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

1575: end loop;
1576:
1577: -- Debug info.
1578: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1579: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1580: p_msg_data=>x_msg_data,
1581: p_msg_type=>'WARNING',
1582: p_msg_level=>fnd_log.level_exception);
1583: END IF;

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

1583: END IF;
1584:
1585: -- Debug info.
1586: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1587: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created (-)',
1588: p_prefix=>l_debug_prefix,
1589: p_msg_level=>fnd_log.level_procedure);
1590: END IF;
1591:

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

1600: p_data => x_msg_data);
1601:
1602: -- Debug info.
1603: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1604: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1605: p_msg_data=>x_msg_data,
1606: p_msg_type=>'ERROR',
1607: p_msg_level=>fnd_log.level_error);
1608: END IF;

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

1606: p_msg_type=>'ERROR',
1607: p_msg_level=>fnd_log.level_error);
1608: END IF;
1609: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1610: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1611: p_prefix=>l_debug_prefix,
1612: p_msg_level=>fnd_log.level_procedure);
1613: END IF;
1614: WHEN fnd_api.g_exc_unexpected_error THEN

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

1619: p_data => x_msg_data);
1620:
1621: -- Debug info.
1622: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1623: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1624: p_msg_data=>x_msg_data,
1625: p_msg_type=>'UNEXPECTED ERROR',
1626: p_msg_level=>fnd_log.level_error);
1627: END IF;

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

1625: p_msg_type=>'UNEXPECTED ERROR',
1626: p_msg_level=>fnd_log.level_error);
1627: END IF;
1628: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1629: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1630: p_prefix=>l_debug_prefix,
1631: p_msg_level=>fnd_log.level_procedure);
1632: END IF;
1633: WHEN OTHERS THEN

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

1642: p_data => x_msg_data);
1643:
1644: -- Debug info.
1645: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1646: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1647: p_msg_data=>x_msg_data,
1648: p_msg_type=>'SQL ERROR',
1649: p_msg_level=>fnd_log.level_error);
1650: END IF;

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

1648: p_msg_type=>'SQL ERROR',
1649: p_msg_level=>fnd_log.level_error);
1650: END IF;
1651: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1652: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1653: p_prefix=>l_debug_prefix,
1654: p_msg_level=>fnd_log.level_procedure);
1655: END IF;
1656:

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

1727:
1728:
1729: -- Debug info.
1730: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1731: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(+)',
1732: p_prefix=>l_debug_prefix,
1733: p_msg_level=>fnd_log.level_procedure);
1734: END IF;
1735:

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

1765:
1766:
1767: -- Debug info.
1768: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1769: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1770: p_msg_data=>x_msg_data,
1771: p_msg_type=>'WARNING',
1772: p_msg_level=>fnd_log.level_exception);
1773: END IF;

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

1773: END IF;
1774:
1775: -- Debug info.
1776: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1777: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated (-)',
1778: p_prefix=>l_debug_prefix,
1779: p_msg_level=>fnd_log.level_procedure);
1780: END IF;
1781:

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

1790: p_data => x_msg_data);
1791:
1792: -- Debug info.
1793: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1794: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1795: p_msg_data=>x_msg_data,
1796: p_msg_type=>'ERROR',
1797: p_msg_level=>fnd_log.level_error);
1798: END IF;

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

1796: p_msg_type=>'ERROR',
1797: p_msg_level=>fnd_log.level_error);
1798: END IF;
1799: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1800: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1801: p_prefix=>l_debug_prefix,
1802: p_msg_level=>fnd_log.level_procedure);
1803: END IF;
1804: WHEN fnd_api.g_exc_unexpected_error THEN

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

1809: p_data => x_msg_data);
1810:
1811: -- Debug info.
1812: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1813: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1814: p_msg_data=>x_msg_data,
1815: p_msg_type=>'UNEXPECTED ERROR',
1816: p_msg_level=>fnd_log.level_error);
1817: END IF;

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

1815: p_msg_type=>'UNEXPECTED ERROR',
1816: p_msg_level=>fnd_log.level_error);
1817: END IF;
1818: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1819: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1820: p_prefix=>l_debug_prefix,
1821: p_msg_level=>fnd_log.level_procedure);
1822: END IF;
1823: WHEN OTHERS THEN

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

1832: p_data => x_msg_data);
1833:
1834: -- Debug info.
1835: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1836: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1837: p_msg_data=>x_msg_data,
1838: p_msg_type=>'SQL ERROR',
1839: p_msg_level=>fnd_log.level_error);
1840: END IF;

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

1838: p_msg_type=>'SQL ERROR',
1839: p_msg_level=>fnd_log.level_error);
1840: END IF;
1841: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1842: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1843: p_prefix=>l_debug_prefix,
1844: p_msg_level=>fnd_log.level_procedure);
1845: END IF;
1846:

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

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

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

2279:
2280:
2281: -- Debug info.
2282: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2283: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2284: p_msg_data=>x_msg_data,
2285: p_msg_type=>'WARNING',
2286: p_msg_level=>fnd_log.level_exception);
2287: END IF;

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

2287: END IF;
2288:
2289: -- Debug info.
2290: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2291: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated (-)',
2292: p_prefix=>l_debug_prefix,
2293: p_msg_level=>fnd_log.level_procedure);
2294: END IF;
2295:

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

2304: p_data => x_msg_data);
2305:
2306: -- Debug info.
2307: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2308: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2309: p_msg_data=>x_msg_data,
2310: p_msg_type=>'ERROR',
2311: p_msg_level=>fnd_log.level_error);
2312: END IF;

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

2310: p_msg_type=>'ERROR',
2311: p_msg_level=>fnd_log.level_error);
2312: END IF;
2313: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2314: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2315: p_prefix=>l_debug_prefix,
2316: p_msg_level=>fnd_log.level_procedure);
2317: END IF;
2318: WHEN fnd_api.g_exc_unexpected_error THEN

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

2323: p_data => x_msg_data);
2324:
2325: -- Debug info.
2326: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2327: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2328: p_msg_data=>x_msg_data,
2329: p_msg_type=>'UNEXPECTED ERROR',
2330: p_msg_level=>fnd_log.level_error);
2331: END IF;

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

2329: p_msg_type=>'UNEXPECTED ERROR',
2330: p_msg_level=>fnd_log.level_error);
2331: END IF;
2332: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2333: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2334: p_prefix=>l_debug_prefix,
2335: p_msg_level=>fnd_log.level_procedure);
2336: END IF;
2337: WHEN OTHERS THEN

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

2346: p_data => x_msg_data);
2347:
2348: -- Debug info.
2349: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2350: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2351: p_msg_data=>x_msg_data,
2352: p_msg_type=>'SQL ERROR',
2353: p_msg_level=>fnd_log.level_error);
2354: END IF;

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

2352: p_msg_type=>'SQL ERROR',
2353: p_msg_level=>fnd_log.level_error);
2354: END IF;
2355: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2356: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2357: p_prefix=>l_debug_prefix,
2358: p_msg_level=>fnd_log.level_procedure);
2359: END IF;
2360: