36: * DESCRIPTION
37: * Turn on debug mode.
38: *
39: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
40: * HZ_UTILITY_V2PUB.enable_debug
41: *
42: * MODIFICATION HISTORY
43: *
44: * 18-Jul-2001 Kate Shan o Created.
52: IF g_debug_count = 1 THEN
53: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
54: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
55: THEN
56: hz_utility_v2pub.enable_debug;
57: g_debug := TRUE;
58: END IF;
59: END IF;
60: END enable_debug;
66: * DESCRIPTION
67: * Turn off debug mode.
68: *
69: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
70: * HZ_UTILITY_V2PUB.disable_debug
71: *
72: * MODIFICATION HISTORY
73: *
74: * 18-Jul-2001 Kate Shan o Created.
79: BEGIN
80: IF g_debug THEN
81: g_debug_count := g_debug_count - 1;
82: IF g_debug_count = 0 THEN
83: hz_utility_v2pub.disable_debug;
84: g_debug := FALSE;
85: END IF;
86: END IF;
87: END disable_debug;
107: BEGIN
108:
109: -- Debug info.
110: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
111: hz_utility_v2pub.debug(p_message=>'do_create_style_fmt_layout (+)',
112: p_prefix=>l_debug_prefix,
113: p_msg_level=>fnd_log.level_procedure);
114: END IF;
115:
133: END IF;
134:
135: -- Debug info.
136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
137: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_layouts_pkg.insert_row (+)',
138: p_prefix=>l_debug_prefix,
139: p_msg_level=>fnd_log.level_procedure);
140: END IF;
141:
163: );
164:
165: -- Debug info.
166: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
167: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_layouts_pkg.insert_row (-) ' ||
168: 'p_style_fmt_layout_rec.style_fmt_layout_id = ' || p_style_fmt_layout_rec.style_fmt_layout_id,
169: p_prefix=>l_debug_prefix,
170: p_msg_level=>fnd_log.level_procedure);
171: hz_utility_v2pub.debug(p_message=>'do_create_style_fmt_layout (-)',
167: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_layouts_pkg.insert_row (-) ' ||
168: 'p_style_fmt_layout_rec.style_fmt_layout_id = ' || p_style_fmt_layout_rec.style_fmt_layout_id,
169: p_prefix=>l_debug_prefix,
170: p_msg_level=>fnd_log.level_procedure);
171: hz_utility_v2pub.debug(p_message=>'do_create_style_fmt_layout (-)',
172: p_prefix=>l_debug_prefix,
173: p_msg_level=>fnd_log.level_procedure);
174: END IF;
175:
198: BEGIN
199:
200: -- Debug info.
201: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
202: hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_layout (+)',
203: p_prefix=>l_debug_prefix,
204: p_msg_level=>fnd_log.level_procedure);
205: END IF;
206:
247: END IF;
248:
249: -- Debug info.
250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
251: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_LAYOUTS_PKG.Update_Row (+)',
252: p_prefix=>l_debug_prefix,
253: p_msg_level=>fnd_log.level_procedure);
254: END IF;
255:
277: );
278:
279: -- Debug info.
280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
281: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_LAYOUTS_PKG.Update_Row (-)',
282: p_prefix=>l_debug_prefix,
283: p_msg_level=>fnd_log.level_procedure);
284: END IF;
285:
284: END IF;
285:
286: -- Debug info.
287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
288: hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_layout (-)',
289: p_prefix=>l_debug_prefix,
290: p_msg_level=>fnd_log.level_procedure);
291: END IF;
292:
348: --enable_debug;
349:
350: -- Debug info.
351: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
352: hz_utility_v2pub.debug(p_message=>'create_style_fmt_layout (+)',
353: p_prefix=>l_debug_prefix,
354: p_msg_level=>fnd_log.level_procedure);
355: END IF;
356:
375: p_count => x_msg_count,
376: p_data => x_msg_data);
377: -- Debug info.
378: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
379: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
380: p_msg_data=>x_msg_data,
381: p_msg_type=>'WARNING',
382: p_msg_level=>fnd_log.level_exception);
383: END IF;
381: p_msg_type=>'WARNING',
382: p_msg_level=>fnd_log.level_exception);
383: END IF;
384: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
385: hz_utility_v2pub.debug(p_message=>'create_style_fmt_layout (-)',
386: p_prefix=>l_debug_prefix,
387: p_msg_level=>fnd_log.level_procedure);
388: END IF;
389:
400: p_data => x_msg_data);
401:
402: -- Debug info.
403: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
404: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
405: p_msg_data=>x_msg_data,
406: p_msg_type=>'ERROR',
407: p_msg_level=>fnd_log.level_error);
408: END IF;
406: p_msg_type=>'ERROR',
407: p_msg_level=>fnd_log.level_error);
408: END IF;
409: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
410: hz_utility_v2pub.debug(p_message=>'create_style_fmt_layout (-)',
411: p_prefix=>l_debug_prefix,
412: p_msg_level=>fnd_log.level_procedure);
413: END IF;
414:
424: p_data => x_msg_data);
425:
426: -- Debug info.
427: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
428: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
429: p_msg_data=>x_msg_data,
430: p_msg_type=>'UNEXPECTED ERROR',
431: p_msg_level=>fnd_log.level_error);
432: END IF;
430: p_msg_type=>'UNEXPECTED ERROR',
431: p_msg_level=>fnd_log.level_error);
432: END IF;
433: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
434: hz_utility_v2pub.debug(p_message=>'create_style_fmt_layout (-)',
435: p_prefix=>l_debug_prefix,
436: p_msg_level=>fnd_log.level_procedure);
437: END IF;
438:
453: p_data => x_msg_data);
454:
455: -- Debug info.
456: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
457: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
458: p_msg_data=>x_msg_data,
459: p_msg_type=>'SQL ERROR',
460: p_msg_level=>fnd_log.level_error);
461: END IF;
459: p_msg_type=>'SQL ERROR',
460: p_msg_level=>fnd_log.level_error);
461: END IF;
462: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
463: hz_utility_v2pub.debug(p_message=>'create_style_fmt_layout (-)',
464: p_prefix=>l_debug_prefix,
465: p_msg_level=>fnd_log.level_procedure);
466: END IF;
467:
524: --enable_debug;
525:
526: -- Debug info.
527: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
528: hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (+)',
529: p_prefix=>l_debug_prefix,
530: p_msg_level=>fnd_log.level_procedure);
531: END IF;
532:
551: p_data => x_msg_data);
552:
553: -- Debug info.
554: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
555: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
556: p_msg_data=>x_msg_data,
557: p_msg_type=>'WARNING',
558: p_msg_level=>fnd_log.level_exception);
559: END IF;
557: p_msg_type=>'WARNING',
558: p_msg_level=>fnd_log.level_exception);
559: END IF;
560: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
561: hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
562: p_prefix=>l_debug_prefix,
563: p_msg_level=>fnd_log.level_procedure);
564: END IF;
565:
576: p_data => x_msg_data);
577:
578: -- Debug info.
579: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
580: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
581: p_msg_data=>x_msg_data,
582: p_msg_type=>'ERROR',
583: p_msg_level=>fnd_log.level_error);
584: END IF;
582: p_msg_type=>'ERROR',
583: p_msg_level=>fnd_log.level_error);
584: END IF;
585: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
586: hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
587: p_prefix=>l_debug_prefix,
588: p_msg_level=>fnd_log.level_procedure);
589: END IF;
590:
600: p_data => x_msg_data);
601:
602: -- Debug info.
603: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
604: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
605: p_msg_data=>x_msg_data,
606: p_msg_type=>'UNEXPECTED ERROR',
607: p_msg_level=>fnd_log.level_error);
608: END IF;
606: p_msg_type=>'UNEXPECTED ERROR',
607: p_msg_level=>fnd_log.level_error);
608: END IF;
609: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
610: hz_utility_v2pub.debug(p_message=>'update_style_fmt_layout (-)',
611: p_prefix=>l_debug_prefix,
612: p_msg_level=>fnd_log.level_procedure);
613: END IF;
614:
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=>'SQL ERROR',
636: p_msg_level=>fnd_log.level_error);
637: END IF;
635: p_msg_type=>'SQL 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=>'update_style_fmt_layout (-)',
640: p_prefix=>l_debug_prefix,
641: p_msg_level=>fnd_log.level_procedure);
642: END IF;
643:
694: --enable_debug;
695:
696: -- Debug info.
697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
698: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (+)',
699: p_prefix=>l_debug_prefix,
700: p_msg_level=>fnd_log.level_procedure);
701: END IF;
702:
720: x_style_fmt_layout_rec.style_fmt_layout_id := p_style_fmt_layout_id;
721:
722: -- Debug info.
723: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
724: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_layouts_pkg.Select_Row (+)',
725: p_prefix=>l_debug_prefix,
726: p_msg_level=>fnd_log.level_procedure);
727: END IF;
728:
748: );
749:
750: -- Debug info.
751: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
752: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_layouts_pkg.select_row (-)',
753: p_prefix=>l_debug_prefix,
754: p_msg_level=>fnd_log.level_procedure);
755: END IF;
756:
762: );
763:
764: -- Debug info.
765: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
766: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
767: p_msg_data=>x_msg_data,
768: p_msg_type=>'WARNING',
769: p_msg_level=>fnd_log.level_exception);
770: END IF;
768: p_msg_type=>'WARNING',
769: p_msg_level=>fnd_log.level_exception);
770: END IF;
771: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
772: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
773: p_prefix=>l_debug_prefix,
774: p_msg_level=>fnd_log.level_procedure);
775: END IF;
776:
786: );
787:
788: -- Debug info.
789: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
790: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
791: p_msg_data=>x_msg_data,
792: p_msg_type=>'ERROR',
793: p_msg_level=>fnd_log.level_error);
794: END IF;
792: p_msg_type=>'ERROR',
793: p_msg_level=>fnd_log.level_error);
794: END IF;
795: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
796: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
797: p_prefix=>l_debug_prefix,
798: p_msg_level=>fnd_log.level_procedure);
799: END IF;
800:
812: );
813:
814: -- Debug info.
815: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
816: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
817: p_msg_data=>x_msg_data,
818: p_msg_type=>'UNEXPECTED ERROR',
819: p_msg_level=>fnd_log.level_error);
820: END IF;
818: p_msg_type=>'UNEXPECTED ERROR',
819: p_msg_level=>fnd_log.level_error);
820: END IF;
821: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
822: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
823: p_prefix=>l_debug_prefix,
824: p_msg_level=>fnd_log.level_procedure);
825: END IF;
826:
841: );
842:
843: -- Debug info.
844: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
845: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
846: p_msg_data=>x_msg_data,
847: p_msg_type=>'SQL ERROR',
848: p_msg_level=>fnd_log.level_error);
849: END IF;
847: p_msg_type=>'SQL ERROR',
848: p_msg_level=>fnd_log.level_error);
849: END IF;
850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
851: hz_utility_v2pub.debug(p_message=>'get_style_fmt_layout_rec (-)',
852: p_prefix=>l_debug_prefix,
853: p_msg_level=>fnd_log.level_procedure);
854: END IF;
855: