DBA Data[Home] [Help]

APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on FND_LOG

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

128: FND_MSG_PUB.initialize;
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_account_merge_event_data(+)',
134: p_prefix=>l_debug_prefix,
135: p_msg_level=>fnd_log.level_procedure);
136: END IF;

Line 135: p_msg_level=>fnd_log.level_procedure);

131: -- Debug info.
132: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
133: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(+)',
134: p_prefix=>l_debug_prefix,
135: p_msg_level=>fnd_log.level_procedure);
136: END IF;
137:
138: open account_merge_details;
139: fetch account_merge_details into x_account_merge_obj;

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

200: END IF;
201: END LOOP;
202:
203: -- Debug info.
204: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
205: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
206: p_msg_data=>x_msg_data,
207: p_msg_type=>'WARNING',
208: p_msg_level=>fnd_log.level_exception);

Line 208: p_msg_level=>fnd_log.level_exception);

204: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
205: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
206: p_msg_data=>x_msg_data,
207: p_msg_type=>'WARNING',
208: p_msg_level=>fnd_log.level_exception);
209: END IF;
210:
211: -- Debug info.
212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

208: p_msg_level=>fnd_log.level_exception);
209: END IF;
210:
211: -- Debug info.
212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
213: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
214: p_prefix=>l_debug_prefix,
215: p_msg_level=>fnd_log.level_procedure);
216: END IF;

Line 215: p_msg_level=>fnd_log.level_procedure);

211: -- Debug info.
212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
213: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
214: p_prefix=>l_debug_prefix,
215: p_msg_level=>fnd_log.level_procedure);
216: END IF;
217: EXCEPTION
218:
219: WHEN fnd_api.g_exc_error THEN

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

223: p_count => x_msg_count,
224: p_data => x_msg_data);
225:
226: -- Debug info.
227: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
228: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
229: p_msg_data=>x_msg_data,
230: p_msg_type=>'ERROR',
231: p_msg_level=>fnd_log.level_error);

Line 231: p_msg_level=>fnd_log.level_error);

227: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
228: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
229: p_msg_data=>x_msg_data,
230: p_msg_type=>'ERROR',
231: p_msg_level=>fnd_log.level_error);
232: END IF;
233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
234: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
235: p_prefix=>l_debug_prefix,

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

229: p_msg_data=>x_msg_data,
230: p_msg_type=>'ERROR',
231: p_msg_level=>fnd_log.level_error);
232: END IF;
233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
234: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
235: p_prefix=>l_debug_prefix,
236: p_msg_level=>fnd_log.level_procedure);
237: END IF;

Line 236: p_msg_level=>fnd_log.level_procedure);

232: END IF;
233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
234: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
235: p_prefix=>l_debug_prefix,
236: p_msg_level=>fnd_log.level_procedure);
237: END IF;
238: WHEN fnd_api.g_exc_unexpected_error THEN
239: x_return_status := fnd_api.g_ret_sts_unexp_error;
240:

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

242: p_count => x_msg_count,
243: p_data => x_msg_data);
244:
245: -- Debug info.
246: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
247: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
248: p_msg_data=>x_msg_data,
249: p_msg_type=>'UNEXPECTED ERROR',
250: p_msg_level=>fnd_log.level_error);

Line 250: p_msg_level=>fnd_log.level_error);

246: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
247: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
248: p_msg_data=>x_msg_data,
249: p_msg_type=>'UNEXPECTED ERROR',
250: p_msg_level=>fnd_log.level_error);
251: END IF;
252: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
253: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
254: p_prefix=>l_debug_prefix,

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

248: p_msg_data=>x_msg_data,
249: p_msg_type=>'UNEXPECTED ERROR',
250: p_msg_level=>fnd_log.level_error);
251: END IF;
252: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
253: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
254: p_prefix=>l_debug_prefix,
255: p_msg_level=>fnd_log.level_procedure);
256: END IF;

Line 255: p_msg_level=>fnd_log.level_procedure);

251: END IF;
252: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
253: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
254: p_prefix=>l_debug_prefix,
255: p_msg_level=>fnd_log.level_procedure);
256: END IF;
257: WHEN OTHERS THEN
258: x_return_status := fnd_api.g_ret_sts_unexp_error;
259:

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

265: p_count => x_msg_count,
266: p_data => x_msg_data);
267:
268: -- Debug info.
269: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
270: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
271: p_msg_data=>x_msg_data,
272: p_msg_type=>'SQL ERROR',
273: p_msg_level=>fnd_log.level_error);

Line 273: p_msg_level=>fnd_log.level_error);

269: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
270: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
271: p_msg_data=>x_msg_data,
272: p_msg_type=>'SQL ERROR',
273: p_msg_level=>fnd_log.level_error);
274: END IF;
275: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
276: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
277: p_prefix=>l_debug_prefix,

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

271: p_msg_data=>x_msg_data,
272: p_msg_type=>'SQL ERROR',
273: p_msg_level=>fnd_log.level_error);
274: END IF;
275: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
276: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
277: p_prefix=>l_debug_prefix,
278: p_msg_level=>fnd_log.level_procedure);
279: END IF;

Line 278: p_msg_level=>fnd_log.level_procedure);

274: END IF;
275: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
276: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
277: p_prefix=>l_debug_prefix,
278: p_msg_level=>fnd_log.level_procedure);
279: END IF;
280: END get_account_merge_event_data;
281:
282: --------------------------------------

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

576: IF FND_API.to_Boolean(p_init_msg_list) THEN
577: FND_MSG_PUB.initialize;
578: END IF;
579:
580: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
581: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(+)',
582: p_prefix=>l_debug_prefix,
583: p_msg_level=>fnd_log.level_procedure);
584: END IF;

Line 583: p_msg_level=>fnd_log.level_procedure);

579:
580: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
581: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(+)',
582: p_prefix=>l_debug_prefix,
583: p_msg_level=>fnd_log.level_procedure);
584: END IF;
585:
586: open party_merge_details;
587: fetch party_merge_details into x_party_merge_obj;

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

626: END LOOP;
627:
628:
629: -- Debug info.
630: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
631: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
632: p_prefix=>l_debug_prefix,
633: p_msg_level=>fnd_log.level_procedure);
634: END IF;

Line 633: p_msg_level=>fnd_log.level_procedure);

629: -- Debug info.
630: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
631: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
632: p_prefix=>l_debug_prefix,
633: p_msg_level=>fnd_log.level_procedure);
634: END IF;
635: EXCEPTION
636:
637: WHEN fnd_api.g_exc_error THEN

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

641: p_count => x_msg_count,
642: p_data => x_msg_data);
643:
644: -- Debug info.
645: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
646: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
647: p_msg_data=>x_msg_data,
648: p_msg_type=>'ERROR',
649: p_msg_level=>fnd_log.level_error);

Line 649: p_msg_level=>fnd_log.level_error);

645: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
646: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
647: p_msg_data=>x_msg_data,
648: p_msg_type=>'ERROR',
649: p_msg_level=>fnd_log.level_error);
650: END IF;
651: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
652: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
653: p_prefix=>l_debug_prefix,

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

647: p_msg_data=>x_msg_data,
648: p_msg_type=>'ERROR',
649: p_msg_level=>fnd_log.level_error);
650: END IF;
651: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
652: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
653: p_prefix=>l_debug_prefix,
654: p_msg_level=>fnd_log.level_procedure);
655: END IF;

Line 654: p_msg_level=>fnd_log.level_procedure);

650: END IF;
651: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
652: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
653: p_prefix=>l_debug_prefix,
654: p_msg_level=>fnd_log.level_procedure);
655: END IF;
656: WHEN fnd_api.g_exc_unexpected_error THEN
657: x_return_status := fnd_api.g_ret_sts_unexp_error;
658:

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

660: p_count => x_msg_count,
661: p_data => x_msg_data);
662:
663: -- Debug info.
664: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
665: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
666: p_msg_data=>x_msg_data,
667: p_msg_type=>'UNEXPECTED ERROR',
668: p_msg_level=>fnd_log.level_error);

Line 668: p_msg_level=>fnd_log.level_error);

664: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
665: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
666: p_msg_data=>x_msg_data,
667: p_msg_type=>'UNEXPECTED ERROR',
668: p_msg_level=>fnd_log.level_error);
669: END IF;
670: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
671: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
672: p_prefix=>l_debug_prefix,

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

666: p_msg_data=>x_msg_data,
667: p_msg_type=>'UNEXPECTED ERROR',
668: p_msg_level=>fnd_log.level_error);
669: END IF;
670: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
671: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
672: p_prefix=>l_debug_prefix,
673: p_msg_level=>fnd_log.level_procedure);
674: END IF;

Line 673: p_msg_level=>fnd_log.level_procedure);

669: END IF;
670: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
671: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
672: p_prefix=>l_debug_prefix,
673: p_msg_level=>fnd_log.level_procedure);
674: END IF;
675: WHEN OTHERS THEN
676: x_return_status := fnd_api.g_ret_sts_unexp_error;
677:

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

683: p_count => x_msg_count,
684: p_data => x_msg_data);
685:
686: -- Debug info.
687: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
688: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
689: p_msg_data=>x_msg_data,
690: p_msg_type=>'SQL ERROR',
691: p_msg_level=>fnd_log.level_error);

Line 691: p_msg_level=>fnd_log.level_error);

687: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
688: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
689: p_msg_data=>x_msg_data,
690: p_msg_type=>'SQL ERROR',
691: p_msg_level=>fnd_log.level_error);
692: END IF;
693: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
694: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
695: p_prefix=>l_debug_prefix,

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

689: p_msg_data=>x_msg_data,
690: p_msg_type=>'SQL ERROR',
691: p_msg_level=>fnd_log.level_error);
692: END IF;
693: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
694: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
695: p_prefix=>l_debug_prefix,
696: p_msg_level=>fnd_log.level_procedure);
697: END IF;

Line 696: p_msg_level=>fnd_log.level_procedure);

692: END IF;
693: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
694: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
695: p_prefix=>l_debug_prefix,
696: p_msg_level=>fnd_log.level_procedure);
697: END IF;
698: END get_party_merge_event_data;
699:
700: END HZ_EXTRACT_MERGE_EVENT_PKG;