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 HZ_UTILITY_V2PUB

Line 36: HZ_UTILITY_V2PUB.enable_debug;

32:
33: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
34: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
35: THEN
36: HZ_UTILITY_V2PUB.enable_debug;
37: G_DEBUG := TRUE;
38: END IF;
39:
40: END enable_debug;

Line 48: HZ_UTILITY_V2PUB.disable_debug;

44:
45: BEGIN
46:
47: IF G_DEBUG THEN
48: HZ_UTILITY_V2PUB.disable_debug;
49: G_DEBUG := FALSE;
50: END IF;
51:
52: END disable_debug;

Line 199: hz_utility_v2pub.debug(p_message=> 'validate_contact_preference (+)',

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

Line 226: hz_utility_v2pub.debug(p_message=>'contact_preference_id is unique during creation if passed in. ' ||

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

Line 258: IF(HZ_UTILITY_V2PUB.G_CALLING_API IS NULL) THEN

254: ----------------------------------------------
255: -- validate contact_level_table
256: ----------------------------------------------
257: /****Logical APIs - validation not required if called from logical api****/
258: IF(HZ_UTILITY_V2PUB.G_CALLING_API IS NULL) THEN
259: -- contact_level_table is mandatory field
260: -- Since contact_level_table is non-updateable, we only need to check mandatory
261: -- during creation.
262:

Line 264: HZ_UTILITY_V2PUB.validate_mandatory (

260: -- Since contact_level_table is non-updateable, we only need to check mandatory
261: -- during creation.
262:
263: IF p_create_update_flag = 'C' THEN
264: HZ_UTILITY_V2PUB.validate_mandatory (
265: p_create_update_flag => p_create_update_flag,
266: p_column => 'contact_level_table',
267: p_column_value => p_contact_preference_rec.contact_level_table,
268: x_return_status => x_return_status );

Line 271: hz_utility_v2pub.debug(p_message=>'contact_level_table is mandatory field' ||

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

Line 279: HZ_UTILITY_V2PUB.validate_nonupdateable (

275: END IF;
276:
277: -- contact_level_table is non-updateable field
278: IF p_create_update_flag = 'U' THEN
279: HZ_UTILITY_V2PUB.validate_nonupdateable (
280: p_column => 'contact_level_table',
281: p_column_value => p_contact_preference_rec.contact_level_table,
282: p_old_column_value => l_contact_level_table,
283: x_return_status => x_return_status );

Line 287: hz_utility_v2pub.debug(p_message=>'contact_level_table is non-updateable.' ||

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

Line 297: HZ_UTILITY_V2PUB.validate_lookup (

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
295: -- during creation.
296: IF p_create_update_flag = 'C' THEN
297: HZ_UTILITY_V2PUB.validate_lookup (
298: p_column => 'contact_level_table',
299: p_lookup_type => 'SUBJECT_TABLE',
300: p_column_value => p_contact_preference_rec.contact_level_table,
301: x_return_status => x_return_status );

Line 305: hz_utility_v2pub.debug(p_message=>'contact_level_table is lookup code in lookup type SUBJECT_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);
309: END IF;

Line 316: IF(HZ_UTILITY_V2PUB.G_CALLING_API IS NULL) THEN

312: ----------------------------------------------
313: -- validate contact_level_table_id
314: ----------------------------------------------
315: /****Logical APIs - validation not required if called from logical api****/
316: IF(HZ_UTILITY_V2PUB.G_CALLING_API IS NULL) THEN
317: -- contact_level_table_id is mandatory field
318: -- Since contact_level_table_id is non-updateable, we only need to check mandatory
319: -- during creation.
320:

Line 322: HZ_UTILITY_V2PUB.validate_mandatory (

318: -- Since contact_level_table_id is non-updateable, we only need to check mandatory
319: -- during creation.
320:
321: IF p_create_update_flag = 'C' THEN
322: HZ_UTILITY_V2PUB.validate_mandatory (
323: p_create_update_flag => p_create_update_flag,
324: p_column => 'contact_level_table_id',
325: p_column_value => p_contact_preference_rec.contact_level_table_id,
326: x_return_status => x_return_status );

Line 330: hz_utility_v2pub.debug(p_message=>'contact_level_table_id is mandatory field' ||

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

Line 338: HZ_UTILITY_V2PUB.validate_nonupdateable (

334: END IF;
335:
336: -- contact_level_table_id is non-updateable field
337: IF p_create_update_flag = 'U' THEN
338: HZ_UTILITY_V2PUB.validate_nonupdateable (
339: p_column => 'contact_level_table_id',
340: p_column_value => p_contact_preference_rec.contact_level_table_id,
341: p_old_column_value => l_contact_level_table_id,
342: x_return_status => x_return_status );

Line 346: hz_utility_v2pub.debug(p_message=>'contact_level_table_id is non-updateable.' ||

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

Line 403: hz_utility_v2pub.debug(p_message=>'contact_level_table_id ' || p_contact_preference_rec.contact_level_table_id ||

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,
407: p_msg_level=>fnd_log.level_statement);

Line 420: HZ_UTILITY_V2PUB.validate_mandatory (

416: -- Since contact_type is non-updateable, we only need to check mandatory
417: -- during creation.
418:
419: IF p_create_update_flag = 'C' THEN
420: HZ_UTILITY_V2PUB.validate_mandatory (
421: p_create_update_flag => p_create_update_flag,
422: p_column => 'contact_type',
423: p_column_value => p_contact_preference_rec.contact_type,
424: x_return_status => x_return_status );

Line 428: hz_utility_v2pub.debug(p_message=>'contact_type is mandatory field' ||

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

Line 436: HZ_UTILITY_V2PUB.validate_nonupdateable (

432: END IF;
433:
434: -- contact_type is non-updateable field
435: IF p_create_update_flag = 'U' THEN
436: HZ_UTILITY_V2PUB.validate_nonupdateable (
437: p_column => 'contact_type',
438: p_column_value => p_contact_preference_rec.contact_type,
439: p_old_column_value => l_contact_type,
440: x_return_status => x_return_status );

Line 444: hz_utility_v2pub.debug(p_message=>'contact_type is non-updateable.' ||

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

Line 454: HZ_UTILITY_V2PUB.validate_lookup (

450: -- contact_type is lookup code in lookup type CONTACT_TYPE
451: -- Since contact_type is non-updateable, we only need to check lookup
452: -- during creation.
453: IF p_create_update_flag = 'C' THEN
454: HZ_UTILITY_V2PUB.validate_lookup (
455: p_column => 'contact_type',
456: p_lookup_type => 'CONTACT_TYPE',
457: p_column_value => p_contact_preference_rec.contact_type,
458: x_return_status => x_return_status );

Line 462: hz_utility_v2pub.debug(p_message=>'contact_type is lookup code in lookup type 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);
466: END IF;

Line 504: hz_utility_v2pub.debug(p_message=>'if contact_level_table is HZ_CONTACT_POINTS ' ||

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,
508: p_msg_level=>fnd_log.level_statement);

Line 516: HZ_UTILITY_V2PUB.validate_mandatory (

512: -- validate preference_code
513: ----------------------------------------------
514:
515: -- preference_code is mandatory field
516: HZ_UTILITY_V2PUB.validate_mandatory (
517: p_create_update_flag => p_create_update_flag,
518: p_column => 'preference_code',
519: p_column_value => p_contact_preference_rec.preference_code,
520: x_return_status => x_return_status );

Line 523: hz_utility_v2pub.debug(p_message=>'preference_code is mandatory field' ||

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

Line 536: HZ_UTILITY_V2PUB.validate_lookup (

532: ( p_create_update_flag = 'C' OR
533: ( p_create_update_flag = 'U' AND
534: p_contact_preference_rec.preference_code <> NVL (l_preference_code, FND_API.G_MISS_CHAR))) THEN
535:
536: HZ_UTILITY_V2PUB.validate_lookup (
537: p_column => 'preference_code',
538: p_lookup_type => 'PREFERENCE_CODE',
539: p_column_value => p_contact_preference_rec.preference_code,
540: x_return_status => x_return_status );

Line 544: hz_utility_v2pub.debug(p_message=>'preference_code is lookup code in lookup type 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);
548: END IF;

Line 562: HZ_UTILITY_V2PUB.validate_lookup (

558: ( p_create_update_flag = 'C' OR
559: ( p_create_update_flag = 'U' AND
560: p_contact_preference_rec.preference_topic_type <> NVL (l_preference_topic_type, FND_API.G_MISS_CHAR))) THEN
561:
562: HZ_UTILITY_V2PUB.validate_lookup (
563: p_column => 'preference_topic_type',
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 );

Line 569: hz_utility_v2pub.debug(p_message=>'preference_topic_type is lookup code in 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);
573: END IF;

Line 597: HZ_UTILITY_V2PUB.validate_mandatory (

593:
594: IF UPPER(l_tag) = 'T' THEN
595:
596: -- preference_topic_type_code is mandatory if preference_topic_type is table name
597: HZ_UTILITY_V2PUB.validate_mandatory (
598: p_create_update_flag => p_create_update_flag,
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 );

Line 604: hz_utility_v2pub.debug(p_message=>'preference_topic_type_code is mandatory if preference_topic_type is table name, ' ||

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

Line 656: hz_utility_v2pub.debug(p_message=>'preference_topic_type_id is the foreign key of table ' ||

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,
660: p_msg_level=>fnd_log.level_statement);

Line 672: HZ_UTILITY_V2PUB.validate_mandatory (

668: ELSIF UPPER(l_tag)='L'
669: THEN
670: BEGIN
671: -- preference_topic_type_code is mandatory if preference_topic_type is lookup name
672: HZ_UTILITY_V2PUB.validate_mandatory (
673: p_create_update_flag => p_create_update_flag,
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 );

Line 679: hz_utility_v2pub.debug(p_message=>'preference_topic_type_code is mandatory field if preference_topic_type is lookup name' ||

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

Line 693: HZ_UTILITY_V2PUB.validate_lookup (

689: ( p_create_update_flag = 'C' OR
690: ( p_create_update_flag = 'U' AND
691: p_contact_preference_rec.preference_topic_type_code <> NVL (l_preference_topic_type_code, FND_API.G_MISS_CHAR))) THEN
692:
693: HZ_UTILITY_V2PUB.validate_lookup (
694: p_column => 'preference_topic_type_code',
695: p_lookup_type => p_contact_preference_rec.preference_topic_type,
696: p_column_value => p_contact_preference_rec.preference_topic_type_code,
697: x_return_status => x_return_status );

Line 701: hz_utility_v2pub.debug(p_message=>'preference_topic_type_code is lookup code in lookup type' ||

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,
705: p_msg_level=>fnd_log.level_statement);

Line 716: HZ_UTILITY_V2PUB.validate_mandatory (

712: ELSIF UPPER(l_tag)='TV'
713: THEN
714: BEGIN
715: -- preference_topic_type_code is mandatory if preference_topic_type is lookup name
716: HZ_UTILITY_V2PUB.validate_mandatory (
717: p_create_update_flag => p_create_update_flag,
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 );

Line 723: hz_utility_v2pub.debug(p_message=>'preference_topic_type_code is mandatory field if preference_topic_type is lookup name' ||

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

Line 739: HZ_UTILITY_V2PUB.validate_mandatory (

735: -- validate preference_start_date and preference_end_date
736: ----------------------------------------------
737:
738: -- preference_start_date is mandatory field
739: HZ_UTILITY_V2PUB.validate_mandatory (
740: p_create_update_flag => p_create_update_flag,
741: p_column => 'preference_start_date',
742: p_column_value => p_contact_preference_rec.preference_start_date,
743: x_return_status => x_return_status );

Line 746: hz_utility_v2pub.debug(p_message=>'preference_start_date is mandatory field' ||

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

Line 765: hz_utility_v2pub.debug(p_message=>'preference_end_date should not be less than sysdate when creating a new record' ||

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

Line 782: hz_utility_v2pub.debug(p_message=>'preference_start_date is non-updateable when the new date is less than sysdate.' ||

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

Line 798: hz_utility_v2pub.debug(p_message=>'preference_end_date is non-updateable when the new date is less than sysdate.' ||

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

Line 806: HZ_UTILITY_V2PUB.validate_start_end_date (

802: END IF;
803: */
804:
805: -- preference_end_date should be greater than preference_start_date
806: HZ_UTILITY_V2PUB.validate_start_end_date (
807: p_create_update_flag => p_create_update_flag,
808: p_start_date_column_name => 'preference start date',
809: p_start_date => p_contact_preference_rec.preference_start_date,
810: p_old_start_date => l_preference_start_date,

Line 817: hz_utility_v2pub.debug(p_message=>'preference_end_date should be greater than preference_start_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);
821: END IF;

Line 906: hz_utility_v2pub.debug(p_message=>'preference_end_time should be greater than preference_start_time, ' ||

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

Line 923: HZ_UTILITY_V2PUB.validate_lookup (

919: ( p_create_update_flag = 'C' OR
920: ( p_create_update_flag = 'U' AND
921: p_contact_preference_rec.max_no_of_interact_uom_code <> NVL (l_max_no_of_interact_uom_code, FND_API.G_MISS_CHAR))) THEN
922:
923: HZ_UTILITY_V2PUB.validate_lookup (
924: p_column => 'max_no_of_interact_uom_code',
925: p_lookup_type => 'MAX_NO_OF_INTERACT_UOM_CODE',
926: p_column_value => p_contact_preference_rec.max_no_of_interact_uom_code,
927: x_return_status => x_return_status );

Line 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.' ||

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

Line 942: HZ_UTILITY_V2PUB.validate_mandatory (

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
940: p_contact_preference_rec.max_no_of_interact_uom_code <> FND_API.G_MISS_CHAR
941: THEN
942: HZ_UTILITY_V2PUB.validate_mandatory (
943: p_create_update_flag => p_create_update_flag,
944: p_column => 'preference_start_date',
945: p_column_value => p_contact_preference_rec.preference_start_date,
946: x_return_status => x_return_status );

Line 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' ||

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

Line 961: HZ_UTILITY_V2PUB.validate_mandatory (

957: ----------------------------------------------
958: -- validate REQUESTED_BY
959: ----------------------------------------------
960: -- requested_by is mandatory field
961: HZ_UTILITY_V2PUB.validate_mandatory (
962: p_create_update_flag => p_create_update_flag,
963: p_column => 'requested_by',
964: p_column_value => p_contact_preference_rec.requested_by,
965: x_return_status => x_return_status );

Line 968: hz_utility_v2pub.debug(p_message=>'requested_by is mandatory field' ||

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

Line 981: HZ_UTILITY_V2PUB.validate_lookup (

977: ( p_create_update_flag = 'C' OR
978: ( p_create_update_flag = 'U' AND
979: p_contact_preference_rec.requested_by <> NVL (l_requested_by, FND_API.G_MISS_CHAR))) THEN
980:
981: HZ_UTILITY_V2PUB.validate_lookup (
982: p_column => 'requested_by',
983: p_lookup_type => 'REQUESTED_BY',
984: p_column_value => p_contact_preference_rec.requested_by,
985: x_return_status => x_return_status );

Line 990: hz_utility_v2pub.debug(p_message=>'requested_by is lookup code in lookup type REQUESTED_BY.' ||

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

Line 1006: HZ_UTILITY_V2PUB.validate_lookup (

1002: ( p_create_update_flag = 'C' OR
1003: ( p_create_update_flag = 'U' AND
1004: p_contact_preference_rec.reason_code <> NVL (l_reason_code, FND_API.G_MISS_CHAR))) THEN
1005:
1006: HZ_UTILITY_V2PUB.validate_lookup (
1007: p_column => 'reason_code',
1008: p_lookup_type => 'REASON_CODE',
1009: p_column_value => p_contact_preference_rec.reason_code,
1010: x_return_status => x_return_status );

Line 1014: hz_utility_v2pub.debug(p_message=>'reason_code is lookup code in lookup type 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);
1018: END IF;

Line 1024: IF(HZ_UTILITY_V2PUB.G_CALLING_API IS NULL) THEN

1020: ----------------------------------------------
1021: -- validate status
1022: ----------------------------------------------
1023: /****Logical APIs - validation not required if called from logical api****/
1024: IF(HZ_UTILITY_V2PUB.G_CALLING_API IS NULL) THEN
1025: -- status cannot be set to null during update
1026: IF p_create_update_flag = 'U' THEN
1027: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (
1028: p_column => 'status',

Line 1027: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (

1023: /****Logical APIs - validation not required if called from logical api****/
1024: IF(HZ_UTILITY_V2PUB.G_CALLING_API IS NULL) THEN
1025: -- status cannot be set to null during update
1026: IF p_create_update_flag = 'U' THEN
1027: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (
1028: p_column => 'status',
1029: p_column_value => p_contact_preference_rec.status,
1030: x_return_status => x_return_status );
1031: END IF;

Line 1034: hz_utility_v2pub.debug(p_message=>'status cannot be updated to null.' ||

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

Line 1047: HZ_UTILITY_V2PUB.validate_lookup (

1043: ( p_create_update_flag = 'C' OR
1044: ( p_create_update_flag = 'U' AND
1045: p_contact_preference_rec.status <> NVL (l_status, FND_API.G_MISS_CHAR))) THEN
1046:
1047: HZ_UTILITY_V2PUB.validate_lookup (
1048: p_column => 'status',
1049: p_lookup_type => 'CODE_STATUS',
1050: p_column_value => p_contact_preference_rec.status,
1051: x_return_status => x_return_status );

Line 1055: hz_utility_v2pub.debug(p_message=>'status is lookup code in lookup type CODE_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);
1059: END IF;

Line 1077: hz_utility_v2pub.validate_created_by_module(

1073: --------------------------------------
1074: -- validate created_by_module
1075: --------------------------------------
1076:
1077: hz_utility_v2pub.validate_created_by_module(
1078: p_create_update_flag => p_create_update_flag,
1079: p_created_by_module => p_contact_preference_rec.created_by_module,
1080: p_old_created_by_module => l_created_by_module,
1081: x_return_status => x_return_status);

Line 1087: hz_utility_v2pub.validate_application_id(

1083: --------------------------------------
1084: -- validate application_id
1085: --------------------------------------
1086:
1087: hz_utility_v2pub.validate_application_id(
1088: p_create_update_flag => p_create_update_flag,
1089: p_application_id => p_contact_preference_rec.application_id,
1090: p_old_application_id => l_application_id,
1091: x_return_status => x_return_status);

Line 1243: hz_utility_v2pub.debug(p_message=>'no duplicate record is allowed ' ||

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