DBA Data[Home] [Help]

APPS.HZ_STYLE_FMT_VARIATION_V2PUB dependencies on HZ_UTILITY_V2PUB

Line 41: * HZ_UTILITY_V2PUB.enable_debug

37: * DESCRIPTION
38: * Turn on debug mode.
39: *
40: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
41: * HZ_UTILITY_V2PUB.enable_debug
42: *
43: * MODIFICATION HISTORY
44: *
45: * 18-Jul-2001 Kate Shan o Created.

Line 57: hz_utility_v2pub.enable_debug;

53: IF g_debug_count = 1 THEN
54: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
55: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
56: THEN
57: hz_utility_v2pub.enable_debug;
58: g_debug := TRUE;
59: END IF;
60: END IF;
61: END enable_debug;

Line 71: * HZ_UTILITY_V2PUB.disable_debug

67: * DESCRIPTION
68: * Turn off debug mode.
69: *
70: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
71: * HZ_UTILITY_V2PUB.disable_debug
72: *
73: * MODIFICATION HISTORY
74: *
75: * 18-Jul-2001 Kate Shan o Created.

Line 84: hz_utility_v2pub.disable_debug;

80: BEGIN
81: IF g_debug THEN
82: g_debug_count := g_debug_count - 1;
83: IF g_debug_count = 0 THEN
84: hz_utility_v2pub.disable_debug;
85: g_debug := FALSE;
86: END IF;
87: END IF;
88: END disable_debug;

Line 111: hz_utility_v2pub.debug(p_message=>'do_create_style_fmt_variation (+)',

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_variation (+)',
112: p_prefix=>l_debug_prefix,
113: p_msg_level=>fnd_log.level_procedure);
114: END IF;
115:

Line 137: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.insert_row (+)',

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_variations_pkg.insert_row (+)',
138: p_prefix=>l_debug_prefix,
139: p_msg_level=>fnd_log.level_procedure);
140: END IF;
141:

Line 155: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.insert_row (-) ' ||

151: );
152:
153: -- Debug info.
154: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
155: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.insert_row (-) ' ||
156: 'p_style_fmt_variation_rec.style_format_code = ' || p_style_fmt_variation_rec.style_format_code ||
157: 'p_style_fmt_variation_rec.variation_number = ' || p_style_fmt_variation_rec.variation_number,
158: p_prefix=>l_debug_prefix,
159: p_msg_level=>fnd_log.level_procedure);

Line 160: hz_utility_v2pub.debug(p_message=>'do_create_style_fmt_variation (-)',

156: 'p_style_fmt_variation_rec.style_format_code = ' || p_style_fmt_variation_rec.style_format_code ||
157: 'p_style_fmt_variation_rec.variation_number = ' || p_style_fmt_variation_rec.variation_number,
158: p_prefix=>l_debug_prefix,
159: p_msg_level=>fnd_log.level_procedure);
160: hz_utility_v2pub.debug(p_message=>'do_create_style_fmt_variation (-)',
161: p_prefix=>l_debug_prefix,
162: p_msg_level=>fnd_log.level_procedure);
163: END IF;
164:

Line 194: hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_variation (+)',

190: BEGIN
191:
192: -- Debug info.
193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
194: hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_variation (+)',
195: p_prefix=>l_debug_prefix,
196: p_msg_level=>fnd_log.level_procedure);
197: END IF;
198:

Line 247: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (+)',

243: END IF;
244:
245: -- Debug info.
246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
247: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (+)',
248: p_prefix=>l_debug_prefix,
249: p_msg_level=>fnd_log.level_procedure);
250: END IF;
251:

Line 265: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (-)',

261: );
262:
263: -- Debug info.
264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
265: hz_utility_v2pub.debug(p_message=>'HZ_STYLE_FMT_VARIATIONS_PKG.Update_Row (-)',
266: p_prefix=>l_debug_prefix,
267: p_msg_level=>fnd_log.level_procedure);
268: END IF;
269:

Line 282: hz_utility_v2pub.debug(p_message=>'do_update_style_fmt_variation (-)',

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

Line 344: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (+)',

340: --enable_debug;
341:
342: -- Debug info.
343: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
344: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (+)',
345: p_prefix=>l_debug_prefix,
346: p_msg_level=>fnd_log.level_procedure);
347: END IF;
348:

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

365: p_count => x_msg_count,
366: p_data => x_msg_data);
367: -- Debug info.
368: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
370: p_msg_data=>x_msg_data,
371: p_msg_type=>'WARNING',
372: p_msg_level=>fnd_log.level_exception);
373: END IF;

Line 375: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',

371: p_msg_type=>'WARNING',
372: p_msg_level=>fnd_log.level_exception);
373: END IF;
374: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
375: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',
376: p_prefix=>l_debug_prefix,
377: p_msg_level=>fnd_log.level_procedure);
378: END IF;
379:

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

390: p_data => x_msg_data);
391:
392: -- Debug info.
393: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
394: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
395: p_msg_data=>x_msg_data,
396: p_msg_type=>'ERROR',
397: p_msg_level=>fnd_log.level_error);
398: END IF;

Line 400: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',

396: p_msg_type=>'ERROR',
397: p_msg_level=>fnd_log.level_error);
398: END IF;
399: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
400: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',
401: p_prefix=>l_debug_prefix,
402: p_msg_level=>fnd_log.level_procedure);
403: END IF;
404:

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

414: p_data => x_msg_data);
415:
416: -- Debug info.
417: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
418: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
419: p_msg_data=>x_msg_data,
420: p_msg_type=>'UNEXPECTED ERROR',
421: p_msg_level=>fnd_log.level_error);
422: END IF;

Line 424: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',

420: p_msg_type=>'UNEXPECTED ERROR',
421: p_msg_level=>fnd_log.level_error);
422: END IF;
423: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
424: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',
425: p_prefix=>l_debug_prefix,
426: p_msg_level=>fnd_log.level_procedure);
427: END IF;
428:

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

443: p_data => x_msg_data);
444:
445: -- Debug info.
446: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
447: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
448: p_msg_data=>x_msg_data,
449: p_msg_type=>'SQL ERROR',
450: p_msg_level=>fnd_log.level_error);
451: END IF;

Line 453: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',

449: p_msg_type=>'SQL ERROR',
450: p_msg_level=>fnd_log.level_error);
451: END IF;
452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
453: hz_utility_v2pub.debug(p_message=>'create_style_fmt_variation (-)',
454: p_prefix=>l_debug_prefix,
455: p_msg_level=>fnd_log.level_procedure);
456: END IF;
457:

Line 519: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (+)',

515: --enable_debug;
516:
517: -- Debug info.
518: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
519: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (+)',
520: p_prefix=>l_debug_prefix,
521: p_msg_level=>fnd_log.level_procedure);
522: END IF;
523:

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

542: p_data => x_msg_data);
543:
544: -- Debug info.
545: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
546: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
547: p_msg_data=>x_msg_data,
548: p_msg_type=>'WARNING',
549: p_msg_level=>fnd_log.level_exception);
550: END IF;

Line 552: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',

548: p_msg_type=>'WARNING',
549: p_msg_level=>fnd_log.level_exception);
550: END IF;
551: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
552: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
553: p_prefix=>l_debug_prefix,
554: p_msg_level=>fnd_log.level_procedure);
555: END IF;
556:

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

567: p_data => x_msg_data);
568:
569: -- Debug info.
570: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
571: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
572: p_msg_data=>x_msg_data,
573: p_msg_type=>'ERROR',
574: p_msg_level=>fnd_log.level_error);
575: END IF;

Line 577: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',

573: p_msg_type=>'ERROR',
574: p_msg_level=>fnd_log.level_error);
575: END IF;
576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
577: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
578: p_prefix=>l_debug_prefix,
579: p_msg_level=>fnd_log.level_procedure);
580: END IF;
581:

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

591: p_data => x_msg_data);
592:
593: -- Debug info.
594: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
595: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
596: p_msg_data=>x_msg_data,
597: p_msg_type=>'UNEXPECTED ERROR',
598: p_msg_level=>fnd_log.level_error);
599: END IF;

Line 601: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',

597: p_msg_type=>'UNEXPECTED ERROR',
598: p_msg_level=>fnd_log.level_error);
599: END IF;
600: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
601: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
602: p_prefix=>l_debug_prefix,
603: p_msg_level=>fnd_log.level_procedure);
604: END IF;
605:

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

620: p_data => x_msg_data);
621:
622: -- Debug info.
623: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
624: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
625: p_msg_data=>x_msg_data,
626: p_msg_type=>'SQL ERROR',
627: p_msg_level=>fnd_log.level_error);
628: END IF;

Line 630: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',

626: p_msg_type=>'SQL ERROR',
627: p_msg_level=>fnd_log.level_error);
628: END IF;
629: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
630: hz_utility_v2pub.debug(p_message=>'update_style_fmt_variation (-)',
631: p_prefix=>l_debug_prefix,
632: p_msg_level=>fnd_log.level_procedure);
633: END IF;
634:

Line 689: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (+)',

685: --enable_debug;
686:
687: -- Debug info.
688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
689: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (+)',
690: p_prefix=>l_debug_prefix,
691: p_msg_level=>fnd_log.level_procedure);
692: END IF;
693:

Line 718: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.Select_Row (+)',

714: x_style_fmt_variation_rec.variation_number := p_variation_number;
715:
716: -- Debug info.
717: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
718: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.Select_Row (+)',
719: p_prefix=>l_debug_prefix,
720: p_msg_level=>fnd_log.level_procedure);
721: END IF;
722:

Line 734: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.select_row (-)',

730: );
731:
732: -- Debug info.
733: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
734: hz_utility_v2pub.debug(p_message=>'hz_style_fmt_variations_pkg.select_row (-)',
735: p_prefix=>l_debug_prefix,
736: p_msg_level=>fnd_log.level_procedure);
737: END IF;
738:

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

744: );
745:
746: -- Debug info.
747: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
748: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
749: p_msg_data=>x_msg_data,
750: p_msg_type=>'WARNING',
751: p_msg_level=>fnd_log.level_exception);
752: END IF;

Line 754: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (-)',

750: p_msg_type=>'WARNING',
751: p_msg_level=>fnd_log.level_exception);
752: END IF;
753: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
754: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (-)',
755: p_prefix=>l_debug_prefix,
756: p_msg_level=>fnd_log.level_procedure);
757: END IF;
758:

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

768: );
769:
770: -- Debug info.
771: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
772: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
773: p_msg_data=>x_msg_data,
774: p_msg_type=>'ERROR',
775: p_msg_level=>fnd_log.level_error);
776: END IF;

Line 778: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (-)',

774: p_msg_type=>'ERROR',
775: p_msg_level=>fnd_log.level_error);
776: END IF;
777: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
778: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (-)',
779: p_prefix=>l_debug_prefix,
780: p_msg_level=>fnd_log.level_procedure);
781: END IF;
782:

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

793: );
794:
795: -- Debug info.
796: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
797: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
798: p_msg_data=>x_msg_data,
799: p_msg_type=>'UNEXPECTED ERROR',
800: p_msg_level=>fnd_log.level_error);
801: END IF;

Line 803: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (-)',

799: p_msg_type=>'UNEXPECTED ERROR',
800: p_msg_level=>fnd_log.level_error);
801: END IF;
802: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
803: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (-)',
804: p_prefix=>l_debug_prefix,
805: p_msg_level=>fnd_log.level_procedure);
806: END IF;
807:

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

822: );
823:
824: -- Debug info.
825: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
826: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
827: p_msg_data=>x_msg_data,
828: p_msg_type=>'SQL ERROR',
829: p_msg_level=>fnd_log.level_error);
830: END IF;

Line 832: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (-)',

828: p_msg_type=>'SQL ERROR',
829: p_msg_level=>fnd_log.level_error);
830: END IF;
831: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
832: hz_utility_v2pub.debug(p_message=>'get_style_fmt_variation_rec (-)',
833: p_prefix=>l_debug_prefix,
834: p_msg_level=>fnd_log.level_procedure);
835: END IF;
836: