DBA Data[Home] [Help]

APPS.HZ_CONTACT_PREFERENCE_V2PUB dependencies on HZ_UTILITY_V2PUB

Line 43: * HZ_UTILITY_V2PUB.enable_debug

39: * DESCRIPTION
40: * Turn on debug mode.
41: *
42: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
43: * HZ_UTILITY_V2PUB.enable_debug
44: *
45: * MODIFICATION HISTORY
46: *
47: * 07-23-2001 Kate Shan o Created.

Line 61: HZ_UTILITY_V2PUB.enable_debug;

57: IF G_DEBUG_COUNT = 1 THEN
58: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
59: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
60: THEN
61: HZ_UTILITY_V2PUB.enable_debug;
62: G_DEBUG := TRUE;
63: END IF;
64: END IF;
65:

Line 76: * HZ_UTILITY_V2PUB.disable_debug

72: * DESCRIPTION
73: * Turn off debug mode.
74: *
75: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
76: * HZ_UTILITY_V2PUB.disable_debug
77: *
78: * MODIFICATION HISTORY
79: *
80: * 07-23-2001 Kate Shan o Created.

Line 92: HZ_UTILITY_V2PUB.disable_debug;

88: IF G_DEBUG THEN
89: G_DEBUG_COUNT := G_DEBUG_COUNT - 1;
90:
91: IF G_DEBUG_COUNT = 0 THEN
92: HZ_UTILITY_V2PUB.disable_debug;
93: G_DEBUG := FALSE;
94: END IF;
95: END IF;
96:

Line 143: hz_utility_v2pub.debug(p_message=>'do_create_contact_preference (+)',

139:
140: BEGIN
141: -- Debug info.
142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
143: hz_utility_v2pub.debug(p_message=>'do_create_contact_preference (+)',
144: p_prefix=>l_debug_prefix,
145: p_msg_level=>fnd_log.level_procedure);
146: END IF;
147:

Line 170: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Insert_Row (+) ',

166: END IF;
167:
168: -- Debug info.
169: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
170: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Insert_Row (+) ',
171: p_prefix=>l_debug_prefix,
172: p_msg_level=>fnd_log.level_procedure);
173: END IF;
174:

Line 204: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Insert_Row (-) ' ||

200: );
201:
202: -- Debug info.
203: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
204: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Insert_Row (-) ' ||
205: 'x_contact_preference_id = ' || p_contact_preference_rec.contact_preference_id,
206: p_prefix=>l_debug_prefix,
207: p_msg_level=>fnd_log.level_procedure);
208: END IF;

Line 215: hz_utility_v2pub.debug(p_message=>'do_create_contact_preference (-)',

211: x_contact_preference_id := p_contact_preference_rec.contact_preference_id;
212:
213: -- Debug info.
214: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
215: hz_utility_v2pub.debug(p_message=>'do_create_contact_preference (-)',
216: p_prefix=>l_debug_prefix,
217: p_msg_level=>fnd_log.level_procedure);
218: END IF;
219:

Line 274: hz_utility_v2pub.debug(p_message=>'do_update_contact_preference (+)',

270: BEGIN
271:
272: -- Debug info.
273: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
274: hz_utility_v2pub.debug(p_message=>'do_update_contact_preference (+)',
275: p_prefix=>l_debug_prefix,
276: p_msg_level=>fnd_log.level_procedure);
277: END IF;
278:

Line 331: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Update_Row (+)',

327: END IF;
328:
329: -- Debug info.
330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
331: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Update_Row (+)',
332: p_prefix=>l_debug_prefix,
333: p_msg_level=>fnd_log.level_procedure);
334: END IF;
335:

Line 365: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Update_Row (-)',

361: );
362:
363: -- Debug info.
364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
365: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Update_Row (-)',
366: p_prefix=>l_debug_prefix,
367: p_msg_level=>fnd_log.level_procedure);
368: END IF;
369:

Line 372: hz_utility_v2pub.debug(p_message=>'do_update_contact_preference (-)',

368: END IF;
369:
370: -- Debug info.
371: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
372: hz_utility_v2pub.debug(p_message=>'do_update_contact_preference (-)',
373: p_prefix=>l_debug_prefix,
374: p_msg_level=>fnd_log.level_procedure);
375: END IF;
376:

Line 436: hz_utility_v2pub.debug(p_message=>'create_contact_preference (+) ',

432: --enable_debug;
433:
434: -- Debug info.
435: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
436: hz_utility_v2pub.debug(p_message=>'create_contact_preference (+) ',
437: p_prefix=>l_debug_prefix,
438: p_msg_level=>fnd_log.level_procedure);
439: END IF;
440:

Line 456: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

452: x_contact_preference_id,
453: x_return_status);
454:
455: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
456: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
457: -- Invoke business event system.
458: HZ_BUSINESS_EVENT_V2PVT.create_contact_prefer_event (
459: l_contact_preference_rec );
460: END IF;

Line 462: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

458: HZ_BUSINESS_EVENT_V2PVT.create_contact_prefer_event (
459: l_contact_preference_rec );
460: END IF;
461:
462: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
463: HZ_POPULATE_BOT_PKG.pop_hz_contact_preferences(
464: p_operation => 'I',
465: p_contact_preference_id => x_contact_preference_id);
466: END IF;

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

473: p_data => x_msg_data);
474:
475: -- Debug info.
476: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
477: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
478: p_msg_data=>x_msg_data,
479: p_msg_type=>'WARNING',
480: p_msg_level=>fnd_log.level_exception);
481: END IF;

Line 483: hz_utility_v2pub.debug(p_message=> 'create_contact_preference (-) ',

479: p_msg_type=>'WARNING',
480: p_msg_level=>fnd_log.level_exception);
481: END IF;
482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
483: hz_utility_v2pub.debug(p_message=> 'create_contact_preference (-) ',
484: p_prefix=>l_debug_prefix,
485: p_msg_level=>fnd_log.level_procedure);
486: END IF;
487:

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

498: p_data => x_msg_data);
499:
500: -- Debug info.
501: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
502: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
503: p_msg_data=>x_msg_data,
504: p_msg_type=>'ERROR',
505: p_msg_level=>fnd_log.level_error);
506: END IF;

Line 508: hz_utility_v2pub.debug(p_message=>'create_contact_preference (-) ' ,

504: p_msg_type=>'ERROR',
505: p_msg_level=>fnd_log.level_error);
506: END IF;
507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
508: hz_utility_v2pub.debug(p_message=>'create_contact_preference (-) ' ,
509: p_prefix=>l_debug_prefix,
510: p_msg_level=>fnd_log.level_procedure);
511: END IF;
512:

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

523: p_data => x_msg_data);
524:
525: -- Debug info.
526: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
527: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
528: p_msg_data=>x_msg_data,
529: p_msg_type=>'UNEXPECTED ERROR',
530: p_msg_level=>fnd_log.level_error);
531: END IF;

Line 533: hz_utility_v2pub.debug(p_message=>'create_contact_preference (-)',

529: p_msg_type=>'UNEXPECTED ERROR',
530: p_msg_level=>fnd_log.level_error);
531: END IF;
532: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
533: hz_utility_v2pub.debug(p_message=>'create_contact_preference (-)',
534: p_prefix=>l_debug_prefix,
535: p_msg_level=>fnd_log.level_procedure);
536: END IF;
537:

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

550: p_data => x_msg_data);
551:
552: -- Debug info.
553: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
554: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
555: p_msg_data=>x_msg_data,
556: p_msg_type=>'SQL ERROR',
557: p_msg_level=>fnd_log.level_error);
558: END IF;

Line 560: hz_utility_v2pub.debug(p_message=>'create_contact_preference (-) ',

556: p_msg_type=>'SQL ERROR',
557: p_msg_level=>fnd_log.level_error);
558: END IF;
559: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
560: hz_utility_v2pub.debug(p_message=>'create_contact_preference (-) ',
561: p_prefix=>l_debug_prefix,
562: p_msg_level=>fnd_log.level_procedure);
563: END IF;
564:

Line 625: hz_utility_v2pub.debug(p_message=>'update_contact_preference (+)',

621: --enable_debug;
622:
623: -- Debug info.
624: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
625: hz_utility_v2pub.debug(p_message=>'update_contact_preference (+)',
626: p_prefix=>l_debug_prefix,
627: p_msg_level=>fnd_log.level_procedure);
628: END IF;
629:

Line 659: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

655: p_object_version_number,
656: x_return_status);
657:
658: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
659: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
660: -- Invoke business event system.
661: HZ_BUSINESS_EVENT_V2PVT.update_contact_prefer_event (
662: l_contact_preference_rec , l_old_contact_preference_rec );
663: END IF;

Line 665: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

661: HZ_BUSINESS_EVENT_V2PVT.update_contact_prefer_event (
662: l_contact_preference_rec , l_old_contact_preference_rec );
663: END IF;
664:
665: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
666: HZ_POPULATE_BOT_PKG.pop_hz_contact_preferences(
667: p_operation => 'U',
668: p_contact_preference_id => l_contact_preference_rec.contact_preference_id);
669: END IF;

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

676: p_data => x_msg_data);
677:
678: -- Debug info.
679: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
680: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
681: p_msg_data=>x_msg_data,
682: p_msg_type=>'WARNING',
683: p_msg_level=>fnd_log.level_exception);
684: END IF;

Line 686: hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',

682: p_msg_type=>'WARNING',
683: p_msg_level=>fnd_log.level_exception);
684: END IF;
685: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
686: hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',
687: p_prefix=>l_debug_prefix,
688: p_msg_level=>fnd_log.level_procedure);
689: END IF;
690:

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

701: p_data => x_msg_data);
702:
703: -- Debug info.
704: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
705: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
706: p_msg_data=>x_msg_data,
707: p_msg_type=>'ERROR',
708: p_msg_level=>fnd_log.level_error);
709: END IF;

Line 711: hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',

707: p_msg_type=>'ERROR',
708: p_msg_level=>fnd_log.level_error);
709: END IF;
710: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
711: hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',
712: p_prefix=>l_debug_prefix,
713: p_msg_level=>fnd_log.level_procedure);
714: END IF;
715:

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

725: p_data => x_msg_data);
726:
727: -- Debug info.
728: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
729: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
730: p_msg_data=>x_msg_data,
731: p_msg_type=>'UNEXPECTED ERROR',
732: p_msg_level=>fnd_log.level_error);
733: END IF;

Line 735: hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',

731: p_msg_type=>'UNEXPECTED ERROR',
732: p_msg_level=>fnd_log.level_error);
733: END IF;
734: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
735: hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',
736: p_prefix=>l_debug_prefix,
737: p_msg_level=>fnd_log.level_procedure);
738: END IF;
739:

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

752: p_data => x_msg_data);
753:
754: -- Debug info.
755: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
756: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
757: p_msg_data=>x_msg_data,
758: p_msg_type=>'SQL ERROR',
759: p_msg_level=>fnd_log.level_error);
760: END IF;

Line 762: hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',

758: p_msg_type=>'SQL ERROR',
759: p_msg_level=>fnd_log.level_error);
760: END IF;
761: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
762: hz_utility_v2pub.debug(p_message=>'update_contact_preference (-)',
763: p_prefix=>l_debug_prefix,
764: p_msg_level=>fnd_log.level_procedure);
765: END IF;
766:

Line 819: hz_utility_v2pub.debug(p_message=>'get_contact_preference_rec (+)',

815: --enable_debug;
816:
817: -- Debug info.
818: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
819: hz_utility_v2pub.debug(p_message=>'get_contact_preference_rec (+)',
820: p_prefix=>l_debug_prefix,
821: p_msg_level=>fnd_log.level_procedure);
822: END IF;
823:

Line 844: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Select_Row (+)',

840:
841: x_contact_preference_rec.contact_preference_id := p_contact_preference_id;
842:
843: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
844: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Select_Row (+)',
845: p_prefix=>l_debug_prefix,
846: p_msg_level=>fnd_log.level_procedure);
847: END IF;
848:

Line 874: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Select_Row (-)',

870: X_APPLICATION_ID => x_contact_preference_rec.application_id
871: );
872:
873: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
874: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Select_Row (-)',
875: p_prefix=>l_debug_prefix,
876: p_msg_level=>fnd_log.level_procedure);
877: END IF;
878:

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

883: p_data => x_msg_data );
884:
885: -- Debug info.
886: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
887: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
888: p_msg_data=>x_msg_data,
889: p_msg_type=>'WARNING',
890: p_msg_level=>fnd_log.level_exception);
891: END IF;

Line 893: hz_utility_v2pub.debug(p_message=>'get_contact_preference_rec (-)',

889: p_msg_type=>'WARNING',
890: p_msg_level=>fnd_log.level_exception);
891: END IF;
892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
893: hz_utility_v2pub.debug(p_message=>'get_contact_preference_rec (-)',
894: p_prefix=>l_debug_prefix,
895: p_msg_level=>fnd_log.level_procedure);
896: END IF;
897:

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

909: p_data => x_msg_data );
910:
911: -- Debug info.
912: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
913: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
914: p_msg_data=>x_msg_data,
915: p_msg_type=>'ERROR',
916: p_msg_level=>fnd_log.level_error);
917: END IF;

Line 919: hz_utility_v2pub.debug(p_message=>'get_contact_preference_rec (-)',

915: p_msg_type=>'ERROR',
916: p_msg_level=>fnd_log.level_error);
917: END IF;
918: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
919: hz_utility_v2pub.debug(p_message=>'get_contact_preference_rec (-)',
920: p_prefix=>l_debug_prefix,
921: p_msg_level=>fnd_log.level_procedure);
922: END IF;
923:

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

933: p_data => x_msg_data );
934:
935: -- Debug info.
936: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
937: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
938: p_msg_data=>x_msg_data,
939: p_msg_type=>'UNEXPECTED ERROR',
940: p_msg_level=>fnd_log.level_error);
941: END IF;

Line 943: hz_utility_v2pub.debug(p_message=>'get_contact_preference_rec (-)',

939: p_msg_type=>'UNEXPECTED ERROR',
940: p_msg_level=>fnd_log.level_error);
941: END IF;
942: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
943: hz_utility_v2pub.debug(p_message=>'get_contact_preference_rec (-)',
944: p_prefix=>l_debug_prefix,
945: p_msg_level=>fnd_log.level_procedure);
946: END IF;
947:

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

961: p_data => x_msg_data );
962:
963: -- Debug info.
964: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
965: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
966: p_msg_data=>x_msg_data,
967: p_msg_type=>'SQL ERROR',
968: p_msg_level=>fnd_log.level_error);
969: END IF;

Line 971: hz_utility_v2pub.debug(p_message=>'get_contact_preference_rec (-)',

967: p_msg_type=>'SQL ERROR',
968: p_msg_level=>fnd_log.level_error);
969: END IF;
970: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
971: hz_utility_v2pub.debug(p_message=>'get_contact_preference_rec (-)',
972: p_prefix=>l_debug_prefix,
973: p_msg_level=>fnd_log.level_procedure);
974: END IF;
975: