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_VALIDATE dependencies on FND_LOG

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

194: -- Check if API is called in debug mode. If yes, enable debug.
195: --enable_debug;
196:
197: -- Debug info.
198: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
199: hz_utility_v2pub.debug(p_message=> 'validate_contact_preference (+)',
200: p_prefix=>l_debug_prefix,
201: p_msg_level=>fnd_log.level_procedure);
202: END IF;

Line 201: p_msg_level=>fnd_log.level_procedure);

197: -- Debug info.
198: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
199: hz_utility_v2pub.debug(p_message=> 'validate_contact_preference (+)',
200: p_prefix=>l_debug_prefix,
201: p_msg_level=>fnd_log.level_procedure);
202: END IF;
203:
204: IF p_create_update_flag = 'C' THEN
205: --If primary key value is passed, check for uniqueness.

Line 225: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

221: END;
222: END IF;
223: END IF;
224:
225: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
226: hz_utility_v2pub.debug(p_message=>'contact_preference_id is unique during creation if passed in. ' ||
227: 'x_return_status = ' || x_return_status,
228: p_prefix =>l_debug_prefix,
229: p_msg_level=>fnd_log.level_statement);

Line 229: p_msg_level=>fnd_log.level_statement);

225: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
226: hz_utility_v2pub.debug(p_message=>'contact_preference_id is unique during creation if passed in. ' ||
227: 'x_return_status = ' || x_return_status,
228: p_prefix =>l_debug_prefix,
229: p_msg_level=>fnd_log.level_statement);
230: END IF;
231:
232: -- Select fields for later use during update.
233: IF p_create_update_flag = 'U' THEN

Line 270: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

266: p_column => 'contact_level_table',
267: p_column_value => p_contact_preference_rec.contact_level_table,
268: x_return_status => x_return_status );
269: END IF;
270: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
271: hz_utility_v2pub.debug(p_message=>'contact_level_table is mandatory field' ||
272: 'x_return_status = ' || x_return_status,
273: p_prefix =>l_debug_prefix,
274: p_msg_level=>fnd_log.level_statement);

Line 274: p_msg_level=>fnd_log.level_statement);

270: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
271: hz_utility_v2pub.debug(p_message=>'contact_level_table is mandatory field' ||
272: 'x_return_status = ' || x_return_status,
273: p_prefix =>l_debug_prefix,
274: p_msg_level=>fnd_log.level_statement);
275: END IF;
276:
277: -- contact_level_table is non-updateable field
278: IF p_create_update_flag = 'U' THEN

Line 286: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

282: p_old_column_value => l_contact_level_table,
283: x_return_status => x_return_status );
284: END IF;
285:
286: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
287: hz_utility_v2pub.debug(p_message=>'contact_level_table is non-updateable.' ||
288: 'x_return_status = ' || x_return_status,
289: p_prefix =>l_debug_prefix,
290: p_msg_level=>fnd_log.level_statement);

Line 290: p_msg_level=>fnd_log.level_statement);

286: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
287: hz_utility_v2pub.debug(p_message=>'contact_level_table is non-updateable.' ||
288: 'x_return_status = ' || x_return_status,
289: p_prefix =>l_debug_prefix,
290: p_msg_level=>fnd_log.level_statement);
291: END IF;
292:
293: -- contact_level_table is lookup code in lookup type SUBJECT_TABLE
294: -- Since contact_level_table is non-updateable, we only need to check lookup

Line 304: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

300: p_column_value => p_contact_preference_rec.contact_level_table,
301: x_return_status => x_return_status );
302: END IF;
303:
304: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
305: hz_utility_v2pub.debug(p_message=>'contact_level_table is lookup code in lookup type SUBJECT_TABLE .' ||
306: 'x_return_status = ' || x_return_status,
307: p_prefix =>l_debug_prefix,
308: p_msg_level=>fnd_log.level_statement);

Line 308: p_msg_level=>fnd_log.level_statement);

304: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
305: hz_utility_v2pub.debug(p_message=>'contact_level_table is lookup code in lookup type SUBJECT_TABLE .' ||
306: 'x_return_status = ' || x_return_status,
307: p_prefix =>l_debug_prefix,
308: p_msg_level=>fnd_log.level_statement);
309: END IF;
310: END IF;
311:
312: ----------------------------------------------

Line 329: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

325: p_column_value => p_contact_preference_rec.contact_level_table_id,
326: x_return_status => x_return_status );
327: END IF;
328:
329: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
330: hz_utility_v2pub.debug(p_message=>'contact_level_table_id is mandatory field' ||
331: 'x_return_status = ' || x_return_status,
332: p_prefix =>l_debug_prefix,
333: p_msg_level=>fnd_log.level_statement);

Line 333: p_msg_level=>fnd_log.level_statement);

329: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
330: hz_utility_v2pub.debug(p_message=>'contact_level_table_id is mandatory field' ||
331: 'x_return_status = ' || x_return_status,
332: p_prefix =>l_debug_prefix,
333: p_msg_level=>fnd_log.level_statement);
334: END IF;
335:
336: -- contact_level_table_id is non-updateable field
337: IF p_create_update_flag = 'U' THEN

Line 345: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

341: p_old_column_value => l_contact_level_table_id,
342: x_return_status => x_return_status );
343: END IF;
344:
345: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
346: hz_utility_v2pub.debug(p_message=>'contact_level_table_id is non-updateable.' ||
347: 'x_return_status = ' || x_return_status,
348: p_prefix =>l_debug_prefix,
349: p_msg_level=>fnd_log.level_statement);

Line 349: p_msg_level=>fnd_log.level_statement);

345: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
346: hz_utility_v2pub.debug(p_message=>'contact_level_table_id is non-updateable.' ||
347: 'x_return_status = ' || x_return_status,
348: p_prefix =>l_debug_prefix,
349: p_msg_level=>fnd_log.level_statement);
350: END IF;
351:
352: -- contact_level_table_id is foreign key of hz_parties, hz_parties, hz_contact_points
353: -- Do not need to check during update because contact_level_table_id is

Line 402: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

398: END;
399: END IF;
400: END IF;
401:
402: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
403: hz_utility_v2pub.debug(p_message=>'contact_level_table_id ' || p_contact_preference_rec.contact_level_table_id ||
404: ' is foreign key of ' || p_contact_preference_rec.contact_level_table || ', ' ||
405: 'x_return_status = ' || x_return_status,
406: p_prefix =>l_debug_prefix,

Line 407: p_msg_level=>fnd_log.level_statement);

403: hz_utility_v2pub.debug(p_message=>'contact_level_table_id ' || p_contact_preference_rec.contact_level_table_id ||
404: ' is foreign key of ' || p_contact_preference_rec.contact_level_table || ', ' ||
405: 'x_return_status = ' || x_return_status,
406: p_prefix =>l_debug_prefix,
407: p_msg_level=>fnd_log.level_statement);
408: END IF;
409: END IF;
410:
411: ----------------------------------------------

Line 427: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

423: p_column_value => p_contact_preference_rec.contact_type,
424: x_return_status => x_return_status );
425: END IF;
426:
427: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
428: hz_utility_v2pub.debug(p_message=>'contact_type is mandatory field' ||
429: 'x_return_status = ' || x_return_status,
430: p_prefix =>l_debug_prefix,
431: p_msg_level=>fnd_log.level_statement);

Line 431: p_msg_level=>fnd_log.level_statement);

427: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
428: hz_utility_v2pub.debug(p_message=>'contact_type is mandatory field' ||
429: 'x_return_status = ' || x_return_status,
430: p_prefix =>l_debug_prefix,
431: p_msg_level=>fnd_log.level_statement);
432: END IF;
433:
434: -- contact_type is non-updateable field
435: IF p_create_update_flag = 'U' THEN

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

439: p_old_column_value => l_contact_type,
440: x_return_status => x_return_status );
441: END IF;
442:
443: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
444: hz_utility_v2pub.debug(p_message=>'contact_type is non-updateable.' ||
445: 'x_return_status = ' || x_return_status,
446: p_prefix =>l_debug_prefix,
447: p_msg_level=>fnd_log.level_statement);

Line 447: p_msg_level=>fnd_log.level_statement);

443: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
444: hz_utility_v2pub.debug(p_message=>'contact_type is non-updateable.' ||
445: 'x_return_status = ' || x_return_status,
446: p_prefix =>l_debug_prefix,
447: p_msg_level=>fnd_log.level_statement);
448: END IF;
449:
450: -- contact_type is lookup code in lookup type CONTACT_TYPE
451: -- Since contact_type is non-updateable, we only need to check lookup

Line 461: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

457: p_column_value => p_contact_preference_rec.contact_type,
458: x_return_status => x_return_status );
459: END IF;
460:
461: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
462: hz_utility_v2pub.debug(p_message=>'contact_type is lookup code in lookup type CONTACT_TYPE.' ||
463: 'x_return_status = ' || x_return_status,
464: p_prefix =>l_debug_prefix,
465: p_msg_level=>fnd_log.level_statement);

Line 465: p_msg_level=>fnd_log.level_statement);

461: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
462: hz_utility_v2pub.debug(p_message=>'contact_type is lookup code in lookup type CONTACT_TYPE.' ||
463: 'x_return_status = ' || x_return_status,
464: p_prefix =>l_debug_prefix,
465: p_msg_level=>fnd_log.level_statement);
466: END IF;
467:
468: -- check CONTACT_POINT_TYPE
469:

Line 503: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

499: END IF;
500: END IF;
501: END IF;
502:
503: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
504: hz_utility_v2pub.debug(p_message=>'if contact_level_table is HZ_CONTACT_POINTS ' ||
505: 'p_contact_preference_rec.contact_type should match with contact_point_type' ||
506: 'x_return_status = ' || x_return_status,
507: p_prefix =>l_debug_prefix,

Line 508: p_msg_level=>fnd_log.level_statement);

504: hz_utility_v2pub.debug(p_message=>'if contact_level_table is HZ_CONTACT_POINTS ' ||
505: 'p_contact_preference_rec.contact_type should match with contact_point_type' ||
506: 'x_return_status = ' || x_return_status,
507: p_prefix =>l_debug_prefix,
508: p_msg_level=>fnd_log.level_statement);
509: END IF;
510:
511: ----------------------------------------------
512: -- validate preference_code

Line 522: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

518: p_column => 'preference_code',
519: p_column_value => p_contact_preference_rec.preference_code,
520: x_return_status => x_return_status );
521:
522: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
523: hz_utility_v2pub.debug(p_message=>'preference_code is mandatory field' ||
524: 'x_return_status = ' || x_return_status,
525: p_prefix =>l_debug_prefix,
526: p_msg_level=>fnd_log.level_statement);

Line 526: p_msg_level=>fnd_log.level_statement);

522: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
523: hz_utility_v2pub.debug(p_message=>'preference_code is mandatory field' ||
524: 'x_return_status = ' || x_return_status,
525: p_prefix =>l_debug_prefix,
526: p_msg_level=>fnd_log.level_statement);
527: END IF;
528:
529: -- preference_code is lookup code in lookup type PREFERENCE_CODE
530: IF p_contact_preference_rec.preference_code IS NOT NULL AND

Line 543: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

539: p_column_value => p_contact_preference_rec.preference_code,
540: x_return_status => x_return_status );
541: END IF;
542:
543: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
544: hz_utility_v2pub.debug(p_message=>'preference_code is lookup code in lookup type PREFERENCE_CODE.' ||
545: 'x_return_status = ' || x_return_status,
546: p_prefix =>l_debug_prefix,
547: p_msg_level=>fnd_log.level_statement);

Line 547: p_msg_level=>fnd_log.level_statement);

543: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
544: hz_utility_v2pub.debug(p_message=>'preference_code is lookup code in lookup type PREFERENCE_CODE.' ||
545: 'x_return_status = ' || x_return_status,
546: p_prefix =>l_debug_prefix,
547: p_msg_level=>fnd_log.level_statement);
548: END IF;
549:
550:
551: ----------------------------------------------

Line 568: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

564: p_lookup_type => 'PREFERENCE_TOPIC_TYPE',
565: p_column_value => p_contact_preference_rec.preference_topic_type,
566: x_return_status => x_return_status );
567:
568: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
569: hz_utility_v2pub.debug(p_message=>'preference_topic_type is lookup code in lookup type PREFERENCE_TOPIC_TYPE.' ||
570: 'x_return_status = ' || x_return_status,
571: p_prefix =>l_debug_prefix,
572: p_msg_level=>fnd_log.level_statement);

Line 572: p_msg_level=>fnd_log.level_statement);

568: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
569: hz_utility_v2pub.debug(p_message=>'preference_topic_type is lookup code in lookup type PREFERENCE_TOPIC_TYPE.' ||
570: 'x_return_status = ' || x_return_status,
571: p_prefix =>l_debug_prefix,
572: p_msg_level=>fnd_log.level_statement);
573: END IF;
574:
575: ----------------------------------------------
576: -- validate preference_topic_type_id

Line 603: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

599: p_column => 'preference_topic_type_id',
600: p_column_value => p_contact_preference_rec.preference_topic_type_id,
601: x_return_status => x_return_status );
602:
603: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
604: hz_utility_v2pub.debug(p_message=>'preference_topic_type_code is mandatory if preference_topic_type is table name, ' ||
605: 'x_return_status = ' || x_return_status,
606: p_prefix =>l_debug_prefix,
607: p_msg_level=>fnd_log.level_statement);

Line 607: p_msg_level=>fnd_log.level_statement);

603: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
604: hz_utility_v2pub.debug(p_message=>'preference_topic_type_code is mandatory if preference_topic_type is table name, ' ||
605: 'x_return_status = ' || x_return_status,
606: p_prefix =>l_debug_prefix,
607: p_msg_level=>fnd_log.level_statement);
608: END IF;
609:
610: IF p_contact_preference_rec.preference_topic_type = 'AMS_SOURCE_CODES' THEN
611: BEGIN

Line 655: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

651: END;
652: /* Bug 3301160, data privacy support */
653: /* Removed the above as the design will change */
654: END IF;
655: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
656: hz_utility_v2pub.debug(p_message=>'preference_topic_type_id is the foreign key of table ' ||
657: p_contact_preference_rec.preference_topic_type || ', ' ||
658: 'x_return_status = ' || x_return_status,
659: p_prefix =>l_debug_prefix,

Line 660: p_msg_level=>fnd_log.level_statement);

656: hz_utility_v2pub.debug(p_message=>'preference_topic_type_id is the foreign key of table ' ||
657: p_contact_preference_rec.preference_topic_type || ', ' ||
658: 'x_return_status = ' || x_return_status,
659: p_prefix =>l_debug_prefix,
660: p_msg_level=>fnd_log.level_statement);
661: END IF;
662:
663: ----------------------------------------------
664: -- validate preference_topic_type_code

Line 678: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

674: p_column => 'preference_topic_type_code',
675: p_column_value => p_contact_preference_rec.preference_topic_type_code,
676: x_return_status => x_return_status );
677:
678: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
679: hz_utility_v2pub.debug(p_message=>'preference_topic_type_code is mandatory field if preference_topic_type is lookup name' ||
680: 'x_return_status = ' || x_return_status,
681: p_prefix =>l_debug_prefix,
682: p_msg_level=>fnd_log.level_statement);

Line 682: p_msg_level=>fnd_log.level_statement);

678: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
679: hz_utility_v2pub.debug(p_message=>'preference_topic_type_code is mandatory field if preference_topic_type is lookup name' ||
680: 'x_return_status = ' || x_return_status,
681: p_prefix =>l_debug_prefix,
682: p_msg_level=>fnd_log.level_statement);
683: END IF;
684:
685:
686: -- preference_topic_type_code is lookup code in lookup type

Line 700: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

696: p_column_value => p_contact_preference_rec.preference_topic_type_code,
697: x_return_status => x_return_status );
698: END IF;
699:
700: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
701: hz_utility_v2pub.debug(p_message=>'preference_topic_type_code is lookup code in lookup type' ||
702: p_contact_preference_rec.preference_topic_type || ', ' ||
703: 'x_return_status = ' || x_return_status,
704: p_prefix =>l_debug_prefix,

Line 705: p_msg_level=>fnd_log.level_statement);

701: hz_utility_v2pub.debug(p_message=>'preference_topic_type_code is lookup code in lookup type' ||
702: p_contact_preference_rec.preference_topic_type || ', ' ||
703: 'x_return_status = ' || x_return_status,
704: p_prefix =>l_debug_prefix,
705: p_msg_level=>fnd_log.level_statement);
706: END IF;
707:
708: END;
709: /** Code added for Bug 3534003 to support table/varchar2 id combination for

Line 722: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

718: p_column => 'preference_topic_type_code',
719: p_column_value => p_contact_preference_rec.preference_topic_type_code,
720: x_return_status => x_return_status );
721:
722: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
723: hz_utility_v2pub.debug(p_message=>'preference_topic_type_code is mandatory field if preference_topic_type is lookup name' ||
724: 'x_return_status = ' || x_return_status,
725: p_prefix =>l_debug_prefix,
726: p_msg_level=>fnd_log.level_statement);

Line 726: p_msg_level=>fnd_log.level_statement);

722: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
723: hz_utility_v2pub.debug(p_message=>'preference_topic_type_code is mandatory field if preference_topic_type is lookup name' ||
724: 'x_return_status = ' || x_return_status,
725: p_prefix =>l_debug_prefix,
726: p_msg_level=>fnd_log.level_statement);
727: END IF;
728: END;
729: END IF; -- END OF tag if
730:

Line 745: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

741: p_column => 'preference_start_date',
742: p_column_value => p_contact_preference_rec.preference_start_date,
743: x_return_status => x_return_status );
744:
745: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
746: hz_utility_v2pub.debug(p_message=>'preference_start_date is mandatory field' ||
747: 'x_return_status = ' || x_return_status,
748: p_prefix =>l_debug_prefix,
749: p_msg_level=>fnd_log.level_statement);

Line 749: p_msg_level=>fnd_log.level_statement);

745: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
746: hz_utility_v2pub.debug(p_message=>'preference_start_date is mandatory field' ||
747: 'x_return_status = ' || x_return_status,
748: p_prefix =>l_debug_prefix,
749: p_msg_level=>fnd_log.level_statement);
750: END IF;
751:
752: /* Requirement change, to allow preference_end_date less than sysdate
753: -- preference_end_date should not be less than sysdate when creating a new record

Line 764: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

760: FND_MSG_PUB.ADD;
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: END IF;
763:
764: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
765: hz_utility_v2pub.debug(p_message=>'preference_end_date should not be less than sysdate when creating a new record' ||
766: 'x_return_status = ' || x_return_status,
767: p_prefix =>l_debug_prefix,
768: p_msg_level=>fnd_log.level_statement);

Line 768: p_msg_level=>fnd_log.level_statement);

764: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
765: hz_utility_v2pub.debug(p_message=>'preference_end_date should not be less than sysdate when creating a new record' ||
766: 'x_return_status = ' || x_return_status,
767: p_prefix =>l_debug_prefix,
768: p_msg_level=>fnd_log.level_statement);
769: END IF;
770:
771:
772: -- preference_start_date is non-updateable if it's less than sysdate

Line 781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

777: p_old_column_value => l_preference_start_date,
778: x_return_status => x_return_status );
779: END IF;
780:
781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
782: hz_utility_v2pub.debug(p_message=>'preference_start_date is non-updateable when the new date is less than sysdate.' ||
783: 'x_return_status = ' || x_return_status,
784: p_prefix =>l_debug_prefix,
785: p_msg_level=>fnd_log.level_statement);

Line 785: p_msg_level=>fnd_log.level_statement);

781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
782: hz_utility_v2pub.debug(p_message=>'preference_start_date is non-updateable when the new date is less than sysdate.' ||
783: 'x_return_status = ' || x_return_status,
784: p_prefix =>l_debug_prefix,
785: p_msg_level=>fnd_log.level_statement);
786: END IF;
787:
788: -- preference_end_date is non-updateable if it's less then sysdate
789: IF p_create_update_flag = 'U' AND trunc(p_contact_preference_rec.preference_end_date) < trunc(sysdate) THEN

Line 797: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

793: p_old_column_value => l_preference_end_date,
794: x_return_status => x_return_status );
795: END IF;
796:
797: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
798: hz_utility_v2pub.debug(p_message=>'preference_end_date is non-updateable when the new date is less than sysdate.' ||
799: 'x_return_status = ' || x_return_status,
800: p_prefix =>l_debug_prefix,
801: p_msg_level=>fnd_log.level_statement);

Line 801: p_msg_level=>fnd_log.level_statement);

797: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
798: hz_utility_v2pub.debug(p_message=>'preference_end_date is non-updateable when the new date is less than sysdate.' ||
799: 'x_return_status = ' || x_return_status,
800: p_prefix =>l_debug_prefix,
801: p_msg_level=>fnd_log.level_statement);
802: END IF;
803: */
804:
805: -- preference_end_date should be greater than preference_start_date

Line 816: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

812: p_end_date => p_contact_preference_rec.preference_end_date,
813: p_old_end_date => l_preference_end_date,
814: x_return_status => x_return_status );
815:
816: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
817: hz_utility_v2pub.debug(p_message=>'preference_end_date should be greater than preference_start_date, ' ||
818: 'x_return_status = ' || x_return_status,
819: p_prefix =>l_debug_prefix,
820: p_msg_level=>fnd_log.level_statement);

Line 820: p_msg_level=>fnd_log.level_statement);

816: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
817: hz_utility_v2pub.debug(p_message=>'preference_end_date should be greater than preference_start_date, ' ||
818: 'x_return_status = ' || x_return_status,
819: p_prefix =>l_debug_prefix,
820: p_msg_level=>fnd_log.level_statement);
821: END IF;
822:
823: ----------------------------------------------
824: -- validate preference_start_time_hr and preference_end_time_hr

Line 905: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

901: l_time_comparison := FND_API.G_FALSE;
902: END IF;
903: END IF;
904:
905: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
906: hz_utility_v2pub.debug(p_message=>'preference_end_time should be greater than preference_start_time, ' ||
907: 'x_return_status = ' || x_return_status,
908: p_prefix =>l_debug_prefix,
909: p_msg_level=>fnd_log.level_statement);

Line 909: p_msg_level=>fnd_log.level_statement);

905: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
906: hz_utility_v2pub.debug(p_message=>'preference_end_time should be greater than preference_start_time, ' ||
907: 'x_return_status = ' || x_return_status,
908: p_prefix =>l_debug_prefix,
909: p_msg_level=>fnd_log.level_statement);
910: END IF;
911:
912: ----------------------------------------------
913: -- validate MAX_NO_OF_INTERACT_UOM_CODE

Line 931: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

927: x_return_status => x_return_status );
928:
929: END IF;
930:
931: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
932: hz_utility_v2pub.debug(p_message=>'max_no_of_interact_uom_code is lookup code in lookup type MAX_NO_OF_INTERACT_UOM_CODE.' ||
933: 'x_return_status = ' || x_return_status,
934: p_prefix =>l_debug_prefix,
935: p_msg_level=>fnd_log.level_statement);

Line 935: p_msg_level=>fnd_log.level_statement);

931: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
932: hz_utility_v2pub.debug(p_message=>'max_no_of_interact_uom_code is lookup code in lookup type MAX_NO_OF_INTERACT_UOM_CODE.' ||
933: 'x_return_status = ' || x_return_status,
934: p_prefix =>l_debug_prefix,
935: p_msg_level=>fnd_log.level_statement);
936: END IF;
937:
938: -- if a value is passed for max_no_of_interact_uom_code then preference_start_date should have a value
939: IF p_contact_preference_rec.max_no_of_interact_uom_code IS NOT NULL AND

Line 949: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

945: p_column_value => p_contact_preference_rec.preference_start_date,
946: x_return_status => x_return_status );
947: END IF;
948:
949: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
950: hz_utility_v2pub.debug(p_message=>'if a value is passed for max_no_of_interact_uom_code then preference_start_date should have a value' ||
951: 'x_return_status = ' || x_return_status,
952: p_prefix =>l_debug_prefix,
953: p_msg_level=>fnd_log.level_statement);

Line 953: p_msg_level=>fnd_log.level_statement);

949: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
950: hz_utility_v2pub.debug(p_message=>'if a value is passed for max_no_of_interact_uom_code then preference_start_date should have a value' ||
951: 'x_return_status = ' || x_return_status,
952: p_prefix =>l_debug_prefix,
953: p_msg_level=>fnd_log.level_statement);
954: END IF;
955:
956:
957: ----------------------------------------------

Line 967: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

963: p_column => 'requested_by',
964: p_column_value => p_contact_preference_rec.requested_by,
965: x_return_status => x_return_status );
966:
967: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
968: hz_utility_v2pub.debug(p_message=>'requested_by is mandatory field' ||
969: 'x_return_status = ' || x_return_status,
970: p_prefix =>l_debug_prefix,
971: p_msg_level=>fnd_log.level_statement);

Line 971: p_msg_level=>fnd_log.level_statement);

967: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
968: hz_utility_v2pub.debug(p_message=>'requested_by is mandatory field' ||
969: 'x_return_status = ' || x_return_status,
970: p_prefix =>l_debug_prefix,
971: p_msg_level=>fnd_log.level_statement);
972: END IF;
973:
974: -- requested_by is lookup code in lookup type REQUESTED_BY
975: IF p_contact_preference_rec.requested_by IS NOT NULL AND

Line 989: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

985: x_return_status => x_return_status );
986:
987: END IF;
988:
989: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
990: hz_utility_v2pub.debug(p_message=>'requested_by is lookup code in lookup type REQUESTED_BY.' ||
991: 'x_return_status = ' || x_return_status,
992: p_prefix =>l_debug_prefix,
993: p_msg_level=>fnd_log.level_statement);

Line 993: p_msg_level=>fnd_log.level_statement);

989: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
990: hz_utility_v2pub.debug(p_message=>'requested_by is lookup code in lookup type REQUESTED_BY.' ||
991: 'x_return_status = ' || x_return_status,
992: p_prefix =>l_debug_prefix,
993: p_msg_level=>fnd_log.level_statement);
994: END IF;
995:
996: ----------------------------------------------
997: -- validate reason_code

Line 1013: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1009: p_column_value => p_contact_preference_rec.reason_code,
1010: x_return_status => x_return_status );
1011: END IF;
1012:
1013: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1014: hz_utility_v2pub.debug(p_message=>'reason_code is lookup code in lookup type REASON_CODE.' ||
1015: 'x_return_status = ' || x_return_status,
1016: p_prefix =>l_debug_prefix,
1017: p_msg_level=>fnd_log.level_statement);

Line 1017: p_msg_level=>fnd_log.level_statement);

1013: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1014: hz_utility_v2pub.debug(p_message=>'reason_code is lookup code in lookup type REASON_CODE.' ||
1015: 'x_return_status = ' || x_return_status,
1016: p_prefix =>l_debug_prefix,
1017: p_msg_level=>fnd_log.level_statement);
1018: END IF;
1019:
1020: ----------------------------------------------
1021: -- validate status

Line 1033: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1029: p_column_value => p_contact_preference_rec.status,
1030: x_return_status => x_return_status );
1031: END IF;
1032:
1033: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1034: hz_utility_v2pub.debug(p_message=>'status cannot be updated to null.' ||
1035: 'x_return_status = ' || x_return_status,
1036: p_prefix =>l_debug_prefix,
1037: p_msg_level=>fnd_log.level_statement);

Line 1037: p_msg_level=>fnd_log.level_statement);

1033: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1034: hz_utility_v2pub.debug(p_message=>'status cannot be updated to null.' ||
1035: 'x_return_status = ' || x_return_status,
1036: p_prefix =>l_debug_prefix,
1037: p_msg_level=>fnd_log.level_statement);
1038: END IF;
1039:
1040: -- status is lookup code in lookup type CODE_STATUS
1041: IF p_contact_preference_rec.status IS NOT NULL AND

Line 1054: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1050: p_column_value => p_contact_preference_rec.status,
1051: x_return_status => x_return_status );
1052: END IF;
1053:
1054: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1055: hz_utility_v2pub.debug(p_message=>'status is lookup code in lookup type CODE_STATUS.' ||
1056: 'x_return_status = ' || x_return_status,
1057: p_prefix =>l_debug_prefix,
1058: p_msg_level=>fnd_log.level_statement);

Line 1058: p_msg_level=>fnd_log.level_statement);

1054: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1055: hz_utility_v2pub.debug(p_message=>'status is lookup code in lookup type CODE_STATUS.' ||
1056: 'x_return_status = ' || x_return_status,
1057: p_prefix =>l_debug_prefix,
1058: p_msg_level=>fnd_log.level_statement);
1059: END IF;
1060: END IF;
1061:
1062: -- if status is not 'A', put sysdate on preference_end_date

Line 1242: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

1238:
1239: END IF;
1240: END IF;
1241:
1242: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1243: hz_utility_v2pub.debug(p_message=>'no duplicate record is allowed ' ||
1244: 'x_return_status = ' || x_return_status,
1245: p_prefix =>l_debug_prefix,
1246: p_msg_level=>fnd_log.level_statement);

Line 1246: p_msg_level=>fnd_log.level_statement);

1242: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1243: hz_utility_v2pub.debug(p_message=>'no duplicate record is allowed ' ||
1244: 'x_return_status = ' || x_return_status,
1245: p_prefix =>l_debug_prefix,
1246: p_msg_level=>fnd_log.level_statement);
1247: END IF;
1248:
1249: END validate_contact_preference;
1250: