eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CONTACT_PREFERENCE_V2PUB dependencies on FND_LOG

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

138: l_rowid ROWID;
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;

Line 145: p_msg_level=>fnd_log.level_procedure);

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:
148: ----------------------------------------------
149: -- if preference_start_date is null, give sysdate

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

165: RAISE FND_API.G_EXC_ERROR;
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;

Line 172: p_msg_level=>fnd_log.level_procedure);

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:
175: -- call table handler to insert a row
176: HZ_CONTACT_PREFERENCES_PKG.Insert_Row (

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

199: X_APPLICATION_ID => p_contact_preference_rec.application_id
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);

Line 207: p_msg_level=>fnd_log.level_procedure);

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;
209:
210: -- assign the primary key back
211: x_contact_preference_id := p_contact_preference_rec.contact_preference_id;

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

210: -- assign the primary key back
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;

Line 217: p_msg_level=>fnd_log.level_procedure);

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:
220: END do_create_contact_preference;
221:

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

269:
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;

Line 276: p_msg_level=>fnd_log.level_procedure);

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:
279: -- check whether record has been updated by another user
280: BEGIN

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

326: RAISE FND_API.G_EXC_ERROR;
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;

Line 333: p_msg_level=>fnd_log.level_procedure);

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:
336: -- call table handler to update a row
337: HZ_CONTACT_PREFERENCES_PKG.Update_Row (

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

360: X_APPLICATION_ID => p_contact_preference_rec.application_id
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;

Line 367: p_msg_level=>fnd_log.level_procedure);

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:
370: -- Debug info.
371: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

367: p_msg_level=>fnd_log.level_procedure);
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;

Line 374: p_msg_level=>fnd_log.level_procedure);

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:
377: END do_update_contact_preference;
378:

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

431: -- Check if API is called in debug mode. If yes, enable debug.
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;

Line 438: p_msg_level=>fnd_log.level_procedure);

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:
441: --Initialize message list if p_init_msg_list is set to TRUE.
442: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

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

Line 480: p_msg_level=>fnd_log.level_exception);

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;
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,

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

478: p_msg_data=>x_msg_data,
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;

Line 485: p_msg_level=>fnd_log.level_procedure);

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:
488: -- Check if API is called in debug mode. If yes, disable debug.
489: --disable_debug;

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

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

Line 505: p_msg_level=>fnd_log.level_error);

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;
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,

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

503: p_msg_data=>x_msg_data,
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;

Line 510: p_msg_level=>fnd_log.level_procedure);

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:
513: -- Check if API is called in debug mode. If yes, disable debug.
514: --disable_debug;

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

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

Line 530: p_msg_level=>fnd_log.level_error);

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;
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,

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

528: p_msg_data=>x_msg_data,
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;

Line 535: p_msg_level=>fnd_log.level_procedure);

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:
538: -- Check if API is called in debug mode. If yes, disable debug.
539: --disable_debug;

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

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

Line 557: p_msg_level=>fnd_log.level_error);

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;
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,

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

555: p_msg_data=>x_msg_data,
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;

Line 562: p_msg_level=>fnd_log.level_procedure);

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:
565: -- Check if API is called in debug mode. If yes, disable debug.
566: --disable_debug;

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

620: -- Check if API is called in debug mode. If yes, enable debug.
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;

Line 627: p_msg_level=>fnd_log.level_procedure);

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:
630: --Initialize message list if p_init_msg_list is set to TRUE.
631: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

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

Line 683: p_msg_level=>fnd_log.level_exception);

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;
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,

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

681: p_msg_data=>x_msg_data,
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;

Line 688: p_msg_level=>fnd_log.level_procedure);

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:
691: -- Check if API is called in debug mode. If yes, disable debug.
692: --disable_debug;

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

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

Line 708: p_msg_level=>fnd_log.level_error);

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;
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,

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

706: p_msg_data=>x_msg_data,
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;

Line 713: p_msg_level=>fnd_log.level_procedure);

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:
716: -- Check if API is called in debug mode. If yes, disable debug.
717: --disable_debug;

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

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

Line 732: p_msg_level=>fnd_log.level_error);

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;
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,

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

730: p_msg_data=>x_msg_data,
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;

Line 737: p_msg_level=>fnd_log.level_procedure);

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:
740: -- Check if API is called in debug mode. If yes, disable debug.
741: --disable_debug;

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

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

Line 759: p_msg_level=>fnd_log.level_error);

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;
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,

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

757: p_msg_data=>x_msg_data,
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;

Line 764: p_msg_level=>fnd_log.level_procedure);

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:
767: -- Check if API is called in debug mode. If yes, disable debug.
768: --disable_debug;

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

814: -- Check if API is called in debug mode. If yes, enable debug.
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;

Line 821: p_msg_level=>fnd_log.level_procedure);

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:
824: --Initialize message list if p_init_msg_list is set to TRUE.
825: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

839: END IF;
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;

Line 846: p_msg_level=>fnd_log.level_procedure);

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:
849: HZ_CONTACT_PREFERENCES_PKG.Select_Row (
850: X_CONTACT_PREFERENCE_ID => x_contact_preference_rec.contact_preference_id,

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

869: X_CREATED_BY_MODULE => x_contact_preference_rec.created_by_module,
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;

Line 876: p_msg_level=>fnd_log.level_procedure);

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:
879: --Standard call to get message count and if count is 1, get message info.
880: FND_MSG_PUB.Count_And_Get(

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

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

Line 890: p_msg_level=>fnd_log.level_exception);

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;
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,

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

888: p_msg_data=>x_msg_data,
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;

Line 895: p_msg_level=>fnd_log.level_procedure);

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:
898: -- Check if API is called in debug mode. If yes, disable debug.
899: --disable_debug;

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

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

Line 916: p_msg_level=>fnd_log.level_error);

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;
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,

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

914: p_msg_data=>x_msg_data,
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;

Line 921: p_msg_level=>fnd_log.level_procedure);

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:
924: -- Check if API is called in debug mode. If yes, disable debug.
925: --disable_debug;

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

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

Line 940: p_msg_level=>fnd_log.level_error);

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;
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,

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

938: p_msg_data=>x_msg_data,
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;

Line 945: p_msg_level=>fnd_log.level_procedure);

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:
948: -- Check if API is called in debug mode. If yes, disable debug.
949: --disable_debug;

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

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

Line 968: p_msg_level=>fnd_log.level_error);

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;
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,

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

966: p_msg_data=>x_msg_data,
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;

Line 973: p_msg_level=>fnd_log.level_procedure);

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:
976: -- Check if API is called in debug mode. If yes, disable debug.
977: --disable_debug;