DBA Data[Home] [Help]

APPS.HZ_AIA_CUSTOM_PKG dependencies on FND_LOG

Line 263: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

259: END LOOP;
260: END IF;
261: EXCEPTION
262: WHEN fnd_api.g_exc_error THEN
263: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
264: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',
265: p_prefix=>l_debug_prefix,
266: p_msg_level=>fnd_log.level_procedure);
267: END IF;

Line 266: p_msg_level=>fnd_log.level_procedure);

262: WHEN fnd_api.g_exc_error THEN
263: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
264: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',
265: p_prefix=>l_debug_prefix,
266: p_msg_level=>fnd_log.level_procedure);
267: END IF;
268: WHEN fnd_api.g_exc_unexpected_error THEN
269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
270: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',

Line 269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

Line 272: p_msg_level=>fnd_log.level_procedure);

268: WHEN fnd_api.g_exc_unexpected_error THEN
269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
270: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',
271: p_prefix=>l_debug_prefix,
272: p_msg_level=>fnd_log.level_procedure);
273: END IF;
274: WHEN OTHERS THEN
275: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
276: fnd_message.set_token('ERROR' ,SQLERRM);

Line 279: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

275: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
276: fnd_message.set_token('ERROR' ,SQLERRM);
277: fnd_msg_pub.add;
278:
279: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
280: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',
281: p_prefix=>l_debug_prefix,
282: p_msg_level=>fnd_log.level_procedure);
283: END IF;

Line 282: p_msg_level=>fnd_log.level_procedure);

278:
279: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
280: hz_utility_v2pub.debug(p_message=>'get_acct_merge_obj(-)',
281: p_prefix=>l_debug_prefix,
282: p_msg_level=>fnd_log.level_procedure);
283: END IF;
284: END get_acct_merge_obj;
285:
286: PROCEDURE get_related_org_cust_objs(

Line 359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

355: END LOOP;
356: CLOSE get_related_org_cust;
357: EXCEPTION
358: WHEN fnd_api.g_exc_error THEN
359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
360: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
361: p_prefix=>l_debug_prefix,
362: p_msg_level=>fnd_log.level_procedure);
363: END IF;

Line 362: p_msg_level=>fnd_log.level_procedure);

358: WHEN fnd_api.g_exc_error THEN
359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
360: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
361: p_prefix=>l_debug_prefix,
362: p_msg_level=>fnd_log.level_procedure);
363: END IF;
364: WHEN fnd_api.g_exc_unexpected_error THEN
365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
366: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',

Line 365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

361: p_prefix=>l_debug_prefix,
362: p_msg_level=>fnd_log.level_procedure);
363: END IF;
364: WHEN fnd_api.g_exc_unexpected_error THEN
365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
366: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
367: p_prefix=>l_debug_prefix,
368: p_msg_level=>fnd_log.level_procedure);
369: END IF;

Line 368: p_msg_level=>fnd_log.level_procedure);

364: WHEN fnd_api.g_exc_unexpected_error THEN
365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
366: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
367: p_prefix=>l_debug_prefix,
368: p_msg_level=>fnd_log.level_procedure);
369: END IF;
370: WHEN OTHERS THEN
371: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
372: fnd_message.set_token('ERROR' ,SQLERRM);

Line 375: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

371: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
372: fnd_message.set_token('ERROR' ,SQLERRM);
373: fnd_msg_pub.add;
374:
375: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
376: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
377: p_prefix=>l_debug_prefix,
378: p_msg_level=>fnd_log.level_procedure);
379: END IF;

Line 378: p_msg_level=>fnd_log.level_procedure);

374:
375: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
376: hz_utility_v2pub.debug(p_message=>'get_related_org_cust_objs(-)',
377: p_prefix=>l_debug_prefix,
378: p_msg_level=>fnd_log.level_procedure);
379: END IF;
380: END get_related_org_cust_objs;
381:
382: PROCEDURE get_party_merge_objs(

Line 536: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

532: CLOSE get_merge_parties;
533: END IF;
534: EXCEPTION
535: WHEN fnd_api.g_exc_error THEN
536: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
537: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
538: p_prefix=>l_debug_prefix,
539: p_msg_level=>fnd_log.level_procedure);
540: END IF;

Line 539: p_msg_level=>fnd_log.level_procedure);

535: WHEN fnd_api.g_exc_error THEN
536: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
537: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
538: p_prefix=>l_debug_prefix,
539: p_msg_level=>fnd_log.level_procedure);
540: END IF;
541: WHEN fnd_api.g_exc_unexpected_error THEN
542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
543: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',

Line 542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

538: p_prefix=>l_debug_prefix,
539: p_msg_level=>fnd_log.level_procedure);
540: END IF;
541: WHEN fnd_api.g_exc_unexpected_error THEN
542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
543: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
544: p_prefix=>l_debug_prefix,
545: p_msg_level=>fnd_log.level_procedure);
546: END IF;

Line 545: p_msg_level=>fnd_log.level_procedure);

541: WHEN fnd_api.g_exc_unexpected_error THEN
542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
543: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
544: p_prefix=>l_debug_prefix,
545: p_msg_level=>fnd_log.level_procedure);
546: END IF;
547: WHEN OTHERS THEN
548: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
549: fnd_message.set_token('ERROR' ,SQLERRM);

Line 552: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

548: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
549: fnd_message.set_token('ERROR' ,SQLERRM);
550: fnd_msg_pub.add;
551:
552: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
553: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
554: p_prefix=>l_debug_prefix,
555: p_msg_level=>fnd_log.level_procedure);
556: END IF;

Line 555: p_msg_level=>fnd_log.level_procedure);

551:
552: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
553: hz_utility_v2pub.debug(p_message=>'get_party_merge_objs(-)',
554: p_prefix=>l_debug_prefix,
555: p_msg_level=>fnd_log.level_procedure);
556: END IF;
557: END get_party_merge_objs;
558:
559: PROCEDURE sync_acct_update(

Line 620: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

616: -- initialize API return status to success.
617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618:
619: -- Debug info.
620: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
621: hz_utility_v2pub.debug(p_message=>'sync_acct_update(+)',
622: p_prefix=>l_debug_prefix,
623: p_msg_level=>fnd_log.level_procedure);
624: END IF;

Line 623: p_msg_level=>fnd_log.level_procedure);

619: -- Debug info.
620: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
621: hz_utility_v2pub.debug(p_message=>'sync_acct_update(+)',
622: p_prefix=>l_debug_prefix,
623: p_msg_level=>fnd_log.level_procedure);
624: END IF;
625:
626: x_return_obj := HZ_ORG_CUST_BO(null, null, HZ_CUST_ACCT_BO_TBL());
627: l_org_obj := p_org_cust_obj.organization_obj;

Line 700: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

696: x_return_obj.organization_obj := l_return_org_obj;
697: remove_gmiss(
698: px_org_cust => x_return_obj);
699:
700: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
701: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
702: p_prefix=>l_debug_prefix,
703: p_msg_level=>fnd_log.level_procedure);
704: END IF;

Line 703: p_msg_level=>fnd_log.level_procedure);

699:
700: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
701: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
702: p_prefix=>l_debug_prefix,
703: p_msg_level=>fnd_log.level_procedure);
704: END IF;
705: EXCEPTION
706: WHEN fnd_api.g_exc_error THEN
707: ROLLBACK TO do_sync_acct_update;

Line 711: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

707: ROLLBACK TO do_sync_acct_update;
708:
709: x_return_status := fnd_api.g_ret_sts_error;
710:
711: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
712: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
713: p_prefix=>l_debug_prefix,
714: p_msg_level=>fnd_log.level_procedure);
715: END IF;

Line 714: p_msg_level=>fnd_log.level_procedure);

710:
711: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
712: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
713: p_prefix=>l_debug_prefix,
714: p_msg_level=>fnd_log.level_procedure);
715: END IF;
716: WHEN fnd_api.g_exc_unexpected_error THEN
717: ROLLBACK TO do_sync_acct_update;
718:

Line 721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

717: ROLLBACK TO do_sync_acct_update;
718:
719: x_return_status := fnd_api.g_ret_sts_error;
720:
721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
722: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
723: p_prefix=>l_debug_prefix,
724: p_msg_level=>fnd_log.level_procedure);
725: END IF;

Line 724: p_msg_level=>fnd_log.level_procedure);

720:
721: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
722: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
723: p_prefix=>l_debug_prefix,
724: p_msg_level=>fnd_log.level_procedure);
725: END IF;
726: WHEN OTHERS THEN
727: ROLLBACK TO do_sync_acct_update;
728:

Line 735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

731: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
732: fnd_message.set_token('ERROR' ,SQLERRM);
733: fnd_msg_pub.add;
734:
735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
736: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
737: p_prefix=>l_debug_prefix,
738: p_msg_level=>fnd_log.level_procedure);
739: END IF;

Line 738: p_msg_level=>fnd_log.level_procedure);

734:
735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
736: hz_utility_v2pub.debug(p_message=>'sync_acct_update(-)',
737: p_prefix=>l_debug_prefix,
738: p_msg_level=>fnd_log.level_procedure);
739: END IF;
740: END sync_acct_update;
741:
742: PROCEDURE sync_acct_order(

Line 823: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

819: -- initialize API return status to success.
820: x_return_status := FND_API.G_RET_STS_SUCCESS;
821:
822: -- Debug info.
823: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
824: hz_utility_v2pub.debug(p_message=>'sync_acct_order(+)',
825: p_prefix=>l_debug_prefix,
826: p_msg_level=>fnd_log.level_procedure);
827: END IF;

Line 826: p_msg_level=>fnd_log.level_procedure);

822: -- Debug info.
823: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
824: hz_utility_v2pub.debug(p_message=>'sync_acct_order(+)',
825: p_prefix=>l_debug_prefix,
826: p_msg_level=>fnd_log.level_procedure);
827: END IF;
828:
829: x_return_obj := HZ_ORG_CUST_BO(null, null, HZ_CUST_ACCT_BO_TBL());
830: l_org_obj := p_org_cust_obj.organization_obj;

Line 996: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

992: remove_gmiss(
993: px_org_cust => x_return_obj);
994: */
995:
996: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
997: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
998: p_prefix=>l_debug_prefix,
999: p_msg_level=>fnd_log.level_procedure);
1000: END IF;

Line 999: p_msg_level=>fnd_log.level_procedure);

995:
996: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
997: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
998: p_prefix=>l_debug_prefix,
999: p_msg_level=>fnd_log.level_procedure);
1000: END IF;
1001: EXCEPTION
1002: WHEN fnd_api.g_exc_error THEN
1003: ROLLBACK TO do_sync_acct_order;

Line 1007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1003: ROLLBACK TO do_sync_acct_order;
1004:
1005: x_return_status := fnd_api.g_ret_sts_error;
1006:
1007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1008: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
1009: p_prefix=>l_debug_prefix,
1010: p_msg_level=>fnd_log.level_procedure);
1011: END IF;

Line 1010: p_msg_level=>fnd_log.level_procedure);

1006:
1007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1008: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
1009: p_prefix=>l_debug_prefix,
1010: p_msg_level=>fnd_log.level_procedure);
1011: END IF;
1012: WHEN fnd_api.g_exc_unexpected_error THEN
1013: ROLLBACK TO do_sync_acct_order;
1014:

Line 1017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1013: ROLLBACK TO do_sync_acct_order;
1014:
1015: x_return_status := fnd_api.g_ret_sts_error;
1016:
1017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1018: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
1019: p_prefix=>l_debug_prefix,
1020: p_msg_level=>fnd_log.level_procedure);
1021: END IF;

Line 1020: p_msg_level=>fnd_log.level_procedure);

1016:
1017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1018: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
1019: p_prefix=>l_debug_prefix,
1020: p_msg_level=>fnd_log.level_procedure);
1021: END IF;
1022: WHEN OTHERS THEN
1023: ROLLBACK TO do_sync_acct_order;
1024:

Line 1031: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1027: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1028: fnd_message.set_token('ERROR' ,SQLERRM);
1029: fnd_msg_pub.add;
1030:
1031: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1032: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
1033: p_prefix=>l_debug_prefix,
1034: p_msg_level=>fnd_log.level_procedure);
1035: END IF;

Line 1034: p_msg_level=>fnd_log.level_procedure);

1030:
1031: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1032: hz_utility_v2pub.debug(p_message=>'sync_acct_order(-)',
1033: p_prefix=>l_debug_prefix,
1034: p_msg_level=>fnd_log.level_procedure);
1035: END IF;
1036: END sync_acct_order;
1037:
1038:

Line 1064: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1060: FND_MSG_PUB.initialize;
1061: END IF;
1062:
1063: -- Debug info.
1064: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1065: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(+)',
1066: p_prefix=>l_debug_prefix,
1067: p_msg_level=>fnd_log.level_procedure);
1068: END IF;

Line 1067: p_msg_level=>fnd_log.level_procedure);

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

Line 1136: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1132: RAISE FND_API.G_EXC_ERROR;
1133: END IF;
1134: */
1135: -- Debug info.
1136: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1138: p_msg_data=>l_msg_data,
1139: p_msg_type=>'WARNING',
1140: p_msg_level=>fnd_log.level_exception);

Line 1140: p_msg_level=>fnd_log.level_exception);

1136: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1138: p_msg_data=>l_msg_data,
1139: p_msg_type=>'WARNING',
1140: p_msg_level=>fnd_log.level_exception);
1141: END IF;
1142:
1143: -- Debug info.
1144: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1144: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1140: p_msg_level=>fnd_log.level_exception);
1141: END IF;
1142:
1143: -- Debug info.
1144: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1145: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1146: p_prefix=>l_debug_prefix,
1147: p_msg_level=>fnd_log.level_procedure);
1148: END IF;

Line 1147: p_msg_level=>fnd_log.level_procedure);

1143: -- Debug info.
1144: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1145: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1146: p_prefix=>l_debug_prefix,
1147: p_msg_level=>fnd_log.level_procedure);
1148: END IF;
1149: EXCEPTION
1150: WHEN fnd_api.g_exc_error THEN
1151: x_return_status := fnd_api.g_ret_sts_error;

Line 1158: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1154: x_msg_count => l_msg_count,
1155: x_msg_data => l_msg_data);
1156:
1157: -- Debug info.
1158: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1159: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1160: p_msg_data=>l_msg_data,
1161: p_msg_type=>'ERROR',
1162: p_msg_level=>fnd_log.level_error);

Line 1162: p_msg_level=>fnd_log.level_error);

1158: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1159: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1160: p_msg_data=>l_msg_data,
1161: p_msg_type=>'ERROR',
1162: p_msg_level=>fnd_log.level_error);
1163: END IF;
1164: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1165: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1166: p_prefix=>l_debug_prefix,

Line 1164: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1160: p_msg_data=>l_msg_data,
1161: p_msg_type=>'ERROR',
1162: p_msg_level=>fnd_log.level_error);
1163: END IF;
1164: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1165: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1166: p_prefix=>l_debug_prefix,
1167: p_msg_level=>fnd_log.level_procedure);
1168: END IF;

Line 1167: p_msg_level=>fnd_log.level_procedure);

1163: END IF;
1164: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1165: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1166: p_prefix=>l_debug_prefix,
1167: p_msg_level=>fnd_log.level_procedure);
1168: END IF;
1169: WHEN fnd_api.g_exc_unexpected_error THEN
1170: x_return_status := fnd_api.g_ret_sts_unexp_error;
1171: x_messages := HZ_PARTY_BO_PVT.return_all_messages(

Line 1177: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1173: x_msg_count => l_msg_count,
1174: x_msg_data => l_msg_data);
1175:
1176: -- Debug info.
1177: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1178: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1179: p_msg_data=>l_msg_data,
1180: p_msg_type=>'UNEXPECTED ERROR',
1181: p_msg_level=>fnd_log.level_error);

Line 1181: p_msg_level=>fnd_log.level_error);

1177: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1178: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1179: p_msg_data=>l_msg_data,
1180: p_msg_type=>'UNEXPECTED ERROR',
1181: p_msg_level=>fnd_log.level_error);
1182: END IF;
1183: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1184: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1185: p_prefix=>l_debug_prefix,

Line 1183: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1179: p_msg_data=>l_msg_data,
1180: p_msg_type=>'UNEXPECTED ERROR',
1181: p_msg_level=>fnd_log.level_error);
1182: END IF;
1183: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1184: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1185: p_prefix=>l_debug_prefix,
1186: p_msg_level=>fnd_log.level_procedure);
1187: END IF;

Line 1186: p_msg_level=>fnd_log.level_procedure);

1182: END IF;
1183: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1184: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1185: p_prefix=>l_debug_prefix,
1186: p_msg_level=>fnd_log.level_procedure);
1187: END IF;
1188: WHEN OTHERS THEN
1189: x_return_status := fnd_api.g_ret_sts_unexp_error;
1190: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 1202: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1198: x_msg_count => l_msg_count,
1199: x_msg_data => l_msg_data);
1200:
1201: -- Debug info.
1202: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1203: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1204: p_msg_data=>l_msg_data,
1205: p_msg_type=>'SQL ERROR',
1206: p_msg_level=>fnd_log.level_error);

Line 1206: p_msg_level=>fnd_log.level_error);

1202: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1203: hz_utility_v2pub.debug_return_messages(p_msg_count=>l_msg_count,
1204: p_msg_data=>l_msg_data,
1205: p_msg_type=>'SQL ERROR',
1206: p_msg_level=>fnd_log.level_error);
1207: END IF;
1208: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1209: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1210: p_prefix=>l_debug_prefix,

Line 1208: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1204: p_msg_data=>l_msg_data,
1205: p_msg_type=>'SQL ERROR',
1206: p_msg_level=>fnd_log.level_error);
1207: END IF;
1208: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1209: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1210: p_prefix=>l_debug_prefix,
1211: p_msg_level=>fnd_log.level_procedure);
1212: END IF;

Line 1211: p_msg_level=>fnd_log.level_procedure);

1207: END IF;
1208: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1209: hz_utility_v2pub.debug(p_message=>'get_merge_org_custs(-)',
1210: p_prefix=>l_debug_prefix,
1211: p_msg_level=>fnd_log.level_procedure);
1212: END IF;
1213: END get_merge_org_custs;
1214:
1215: END HZ_AIA_CUSTOM_PKG;