DBA Data[Home] [Help]

APPS.HZ_ORIG_SYSTEM_REF_BO_PUB dependencies on FND_LOG

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

148: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
149: END IF;
150:
151: -- Debug info.
152: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
153: hz_utility_v2pub.debug(p_message=>'create_orig_sys_ref_bo(+)',
154: p_prefix=>l_debug_prefix,
155: p_msg_level=>fnd_log.level_procedure);
156: END IF;

Line 155: p_msg_level=>fnd_log.level_procedure);

151: -- Debug info.
152: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
153: hz_utility_v2pub.debug(p_message=>'create_orig_sys_ref_bo(+)',
154: p_prefix=>l_debug_prefix,
155: p_msg_level=>fnd_log.level_procedure);
156: END IF;
157:
158: FOR i IN 1..p_orig_sys_refs.COUNT LOOP
159: IF(p_orig_sys_refs(i).object_id IS NULL) THEN

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

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

Line 207: p_msg_level=>fnd_log.level_exception);

203: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
204: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
205: p_msg_data=>x_msg_data,
206: p_msg_type=>'WARNING',
207: p_msg_level=>fnd_log.level_exception);
208: END IF;
209: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
210: hz_utility_v2pub.debug(p_message=>'create_orig_sys_ref_bo(-)',
211: p_prefix=>l_debug_prefix,

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

205: p_msg_data=>x_msg_data,
206: p_msg_type=>'WARNING',
207: p_msg_level=>fnd_log.level_exception);
208: END IF;
209: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
210: hz_utility_v2pub.debug(p_message=>'create_orig_sys_ref_bo(-)',
211: p_prefix=>l_debug_prefix,
212: p_msg_level=>fnd_log.level_procedure);
213: END IF;

Line 212: p_msg_level=>fnd_log.level_procedure);

208: END IF;
209: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
210: hz_utility_v2pub.debug(p_message=>'create_orig_sys_ref_bo(-)',
211: p_prefix=>l_debug_prefix,
212: p_msg_level=>fnd_log.level_procedure);
213: END IF;
214: EXCEPTION
215: WHEN fnd_api.g_exc_error THEN
216: ROLLBACK TO create_osr_bo_pub;

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=>'create_orig_sys_refs_bo(-)',
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=>'create_orig_sys_refs_bo(-)',
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=>'create_orig_sys_refs_bo(-)',
235: p_prefix=>l_debug_prefix,
236: p_msg_level=>fnd_log.level_procedure);
237: END IF;
238:
239: WHEN fnd_api.g_exc_unexpected_error THEN
240: ROLLBACK TO create_osr_bo_pub;

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

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

Line 252: p_msg_level=>fnd_log.level_error);

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

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

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

Line 257: p_msg_level=>fnd_log.level_procedure);

253: END IF;
254: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
255: hz_utility_v2pub.debug(p_message=>'create_orig_sys_refs_bo(-)',
256: p_prefix=>l_debug_prefix,
257: p_msg_level=>fnd_log.level_procedure);
258: END IF;
259: WHEN OTHERS THEN
260: ROLLBACK TO create_osr_bo_pub;
261: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 276: p_msg_level=>fnd_log.level_error);

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

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

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

Line 281: p_msg_level=>fnd_log.level_procedure);

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

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

355: FND_MSG_PUB.initialize;
356: END IF;
357:
358: -- Debug info.
359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
360: hz_utility_v2pub.debug(p_message=>'update_orig_sys_ref_bo(+)',
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: -- Debug info.
359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
360: hz_utility_v2pub.debug(p_message=>'update_orig_sys_ref_bo(+)',
361: p_prefix=>l_debug_prefix,
362: p_msg_level=>fnd_log.level_procedure);
363: END IF;
364:
365: FOR i IN 1..p_orig_sys_refs.COUNT LOOP
366: IF(p_orig_sys_refs(i).object_id IS NULL) THEN

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

409: END IF;
410: END LOOP;
411:
412: -- Debug info.
413: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
414: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
415: p_msg_data=>x_msg_data,
416: p_msg_type=>'WARNING',
417: p_msg_level=>fnd_log.level_exception);

Line 417: p_msg_level=>fnd_log.level_exception);

413: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
414: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
415: p_msg_data=>x_msg_data,
416: p_msg_type=>'WARNING',
417: p_msg_level=>fnd_log.level_exception);
418: END IF;
419: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
420: hz_utility_v2pub.debug(p_message=>'update_orig_sys_ref_bo(-)',
421: p_prefix=>l_debug_prefix,

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

415: p_msg_data=>x_msg_data,
416: p_msg_type=>'WARNING',
417: p_msg_level=>fnd_log.level_exception);
418: END IF;
419: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
420: hz_utility_v2pub.debug(p_message=>'update_orig_sys_ref_bo(-)',
421: p_prefix=>l_debug_prefix,
422: p_msg_level=>fnd_log.level_procedure);
423: END IF;

Line 422: p_msg_level=>fnd_log.level_procedure);

418: END IF;
419: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
420: hz_utility_v2pub.debug(p_message=>'update_orig_sys_ref_bo(-)',
421: p_prefix=>l_debug_prefix,
422: p_msg_level=>fnd_log.level_procedure);
423: END IF;
424: EXCEPTION
425: WHEN fnd_api.g_exc_error THEN
426: ROLLBACK TO update_osr_bo_pub;

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

433: p_count => x_msg_count,
434: p_data => x_msg_data);
435:
436: -- Debug info.
437: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
438: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
439: p_msg_data=>x_msg_data,
440: p_msg_type=>'ERROR',
441: p_msg_level=>fnd_log.level_error);

Line 441: p_msg_level=>fnd_log.level_error);

437: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
438: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
439: p_msg_data=>x_msg_data,
440: p_msg_type=>'ERROR',
441: p_msg_level=>fnd_log.level_error);
442: END IF;
443: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
444: hz_utility_v2pub.debug(p_message=>'update_orig_sys_refs_bo(-)',
445: p_prefix=>l_debug_prefix,

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

439: p_msg_data=>x_msg_data,
440: p_msg_type=>'ERROR',
441: p_msg_level=>fnd_log.level_error);
442: END IF;
443: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
444: hz_utility_v2pub.debug(p_message=>'update_orig_sys_refs_bo(-)',
445: p_prefix=>l_debug_prefix,
446: p_msg_level=>fnd_log.level_procedure);
447: END IF;

Line 446: p_msg_level=>fnd_log.level_procedure);

442: END IF;
443: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
444: hz_utility_v2pub.debug(p_message=>'update_orig_sys_refs_bo(-)',
445: p_prefix=>l_debug_prefix,
446: p_msg_level=>fnd_log.level_procedure);
447: END IF;
448:
449: WHEN fnd_api.g_exc_unexpected_error THEN
450: ROLLBACK TO update_osr_bo_pub;

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

454: p_count => x_msg_count,
455: p_data => x_msg_data);
456:
457: -- Debug info.
458: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
459: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
460: p_msg_data=>x_msg_data,
461: p_msg_type=>'UNEXPECTED ERROR',
462: p_msg_level=>fnd_log.level_error);

Line 462: p_msg_level=>fnd_log.level_error);

458: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
459: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
460: p_msg_data=>x_msg_data,
461: p_msg_type=>'UNEXPECTED ERROR',
462: p_msg_level=>fnd_log.level_error);
463: END IF;
464: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
465: hz_utility_v2pub.debug(p_message=>'update_orig_sys_refs_bo(-)',
466: p_prefix=>l_debug_prefix,

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

460: p_msg_data=>x_msg_data,
461: p_msg_type=>'UNEXPECTED ERROR',
462: p_msg_level=>fnd_log.level_error);
463: END IF;
464: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
465: hz_utility_v2pub.debug(p_message=>'update_orig_sys_refs_bo(-)',
466: p_prefix=>l_debug_prefix,
467: p_msg_level=>fnd_log.level_procedure);
468: END IF;

Line 467: p_msg_level=>fnd_log.level_procedure);

463: END IF;
464: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
465: hz_utility_v2pub.debug(p_message=>'update_orig_sys_refs_bo(-)',
466: p_prefix=>l_debug_prefix,
467: p_msg_level=>fnd_log.level_procedure);
468: END IF;
469: WHEN OTHERS THEN
470: ROLLBACK TO update_osr_bo_pub;
471: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

478: p_count => x_msg_count,
479: p_data => x_msg_data);
480:
481: -- Debug info.
482: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
483: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
484: p_msg_data=>x_msg_data,
485: p_msg_type=>'SQL ERROR',
486: p_msg_level=>fnd_log.level_error);

Line 486: p_msg_level=>fnd_log.level_error);

482: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
483: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
484: p_msg_data=>x_msg_data,
485: p_msg_type=>'SQL ERROR',
486: p_msg_level=>fnd_log.level_error);
487: END IF;
488: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
489: hz_utility_v2pub.debug(p_message=>'update_orig_sys_refs_bo(-)',
490: p_prefix=>l_debug_prefix,

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

484: p_msg_data=>x_msg_data,
485: p_msg_type=>'SQL ERROR',
486: p_msg_level=>fnd_log.level_error);
487: END IF;
488: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
489: hz_utility_v2pub.debug(p_message=>'update_orig_sys_refs_bo(-)',
490: p_prefix=>l_debug_prefix,
491: p_msg_level=>fnd_log.level_procedure);
492: END IF;

Line 491: p_msg_level=>fnd_log.level_procedure);

487: END IF;
488: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
489: hz_utility_v2pub.debug(p_message=>'update_orig_sys_refs_bo(-)',
490: p_prefix=>l_debug_prefix,
491: p_msg_level=>fnd_log.level_procedure);
492: END IF;
493: END update_orig_sys_refs_bo;
494:
495: PROCEDURE update_orig_sys_refs_bo(

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

560: FND_MSG_PUB.initialize;
561: END IF;
562:
563: -- Debug info.
564: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
565: hz_utility_v2pub.debug(p_message=>'update_orig_sys_ref_bo(+)',
566: p_prefix=>l_debug_prefix,
567: p_msg_level=>fnd_log.level_procedure);
568: END IF;

Line 567: p_msg_level=>fnd_log.level_procedure);

563: -- Debug info.
564: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
565: hz_utility_v2pub.debug(p_message=>'update_orig_sys_ref_bo(+)',
566: p_prefix=>l_debug_prefix,
567: p_msg_level=>fnd_log.level_procedure);
568: END IF;
569:
570: FOR i IN 1..p_orig_sys_refs.object_type.COUNT LOOP
571: l_otn := HZ_REGISTRY_VALIDATE_BO_PVT.get_owner_table_name(p_orig_sys_refs.object_type(i));

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

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

Line 593: p_msg_level=>fnd_log.level_exception);

589: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
590: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
591: p_msg_data=>x_msg_data,
592: p_msg_type=>'WARNING',
593: p_msg_level=>fnd_log.level_exception);
594: END IF;
595: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
596: hz_utility_v2pub.debug(p_message=>'remap_internal_identifiers_bo(-)',
597: p_prefix=>l_debug_prefix,

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

591: p_msg_data=>x_msg_data,
592: p_msg_type=>'WARNING',
593: p_msg_level=>fnd_log.level_exception);
594: END IF;
595: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
596: hz_utility_v2pub.debug(p_message=>'remap_internal_identifiers_bo(-)',
597: p_prefix=>l_debug_prefix,
598: p_msg_level=>fnd_log.level_procedure);
599: END IF;

Line 598: p_msg_level=>fnd_log.level_procedure);

594: END IF;
595: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
596: hz_utility_v2pub.debug(p_message=>'remap_internal_identifiers_bo(-)',
597: p_prefix=>l_debug_prefix,
598: p_msg_level=>fnd_log.level_procedure);
599: END IF;
600: EXCEPTION
601: WHEN fnd_api.g_exc_error THEN
602: ROLLBACK TO remap_osr_bo_pub;

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

609: p_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);

Line 617: p_msg_level=>fnd_log.level_error);

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;
619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
620: hz_utility_v2pub.debug(p_message=>'remap_internal_identifiers_bo(-)',
621: p_prefix=>l_debug_prefix,

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

615: p_msg_data=>x_msg_data,
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=>'remap_internal_identifiers_bo(-)',
621: p_prefix=>l_debug_prefix,
622: p_msg_level=>fnd_log.level_procedure);
623: END IF;

Line 622: p_msg_level=>fnd_log.level_procedure);

618: END IF;
619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
620: hz_utility_v2pub.debug(p_message=>'remap_internal_identifiers_bo(-)',
621: p_prefix=>l_debug_prefix,
622: p_msg_level=>fnd_log.level_procedure);
623: END IF;
624:
625: WHEN fnd_api.g_exc_unexpected_error THEN
626: ROLLBACK TO remap_osr_bo_pub;

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

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

Line 638: p_msg_level=>fnd_log.level_error);

634: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
635: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
636: p_msg_data=>x_msg_data,
637: p_msg_type=>'UNEXPECTED ERROR',
638: p_msg_level=>fnd_log.level_error);
639: END IF;
640: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
641: hz_utility_v2pub.debug(p_message=>'remap_internal_identifiers_bo(-)',
642: p_prefix=>l_debug_prefix,

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

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

Line 643: p_msg_level=>fnd_log.level_procedure);

639: END IF;
640: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
641: hz_utility_v2pub.debug(p_message=>'remap_internal_identifiers_bo(-)',
642: p_prefix=>l_debug_prefix,
643: p_msg_level=>fnd_log.level_procedure);
644: END IF;
645: WHEN OTHERS THEN
646: ROLLBACK TO remap_osr_bo_pub;
647: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 662: p_msg_level=>fnd_log.level_error);

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

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

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

Line 667: p_msg_level=>fnd_log.level_procedure);

663: END IF;
664: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
665: hz_utility_v2pub.debug(p_message=>'remap_internal_identifiers_bo(-)',
666: p_prefix=>l_debug_prefix,
667: p_msg_level=>fnd_log.level_procedure);
668: END IF;
669: END remap_internal_identifiers_bo;
670:
671: PROCEDURE remap_internal_identifiers_bo(