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_NAME_ADDRESS_FMT_VALIDATE dependencies on HZ_UTILITY_V2PUB

Line 33: * HZ_UTILITY_V2PUB.enable_debug

29: * DESCRIPTION
30: * Turn on debug mode.
31: *
32: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
33: * HZ_UTILITY_V2PUB.enable_debug
34: *
35: * MODIFICATION HISTORY
36: *
37: * 18-Jul-2001 Kate Shan o Created.

Line 49: hz_utility_v2pub.enable_debug;

45: IF g_debug_count = 1 THEN
46: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
47: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
48: THEN
49: hz_utility_v2pub.enable_debug;
50: g_debug := TRUE;
51: END IF;
52: END IF;
53: END enable_debug;

Line 63: * HZ_UTILITY_V2PUB.disable_debug

59: * DESCRIPTION
60: * Turn off debug mode.
61: *
62: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
63: * HZ_UTILITY_V2PUB.disable_debug
64: *
65: * MODIFICATION HISTORY
66: *
67: * 18-Jul-2001 Kate Shan o Created.

Line 76: hz_utility_v2pub.disable_debug;

72: BEGIN
73: IF g_debug THEN
74: g_debug_count := g_debug_count - 1;
75: IF g_debug_count = 0 THEN
76: hz_utility_v2pub.disable_debug;
77: g_debug := FALSE;
78: END IF;
79: END IF;
80: END disable_debug;

Line 233: hz_utility_v2pub.debug(p_message=>'validate_style (+)',

229: --enable_debug;
230:
231: -- Debug info.
232: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
233: hz_utility_v2pub.debug(p_message=>'validate_style (+)',
234: p_prefix=>l_debug_prefix,
235: p_msg_level=>fnd_log.level_procedure);
236: END IF;
237:

Line 259: HZ_UTILITY_V2PUB.validate_mandatory (

255: -----------------------------
256:
257: -- style_code is mandatory
258: IF (p_create_update_flag = 'C') THEN
259: HZ_UTILITY_V2PUB.validate_mandatory (
260: p_create_update_flag => p_create_update_flag,
261: p_column => 'style_code',
262: p_column_value => p_style_rec.style_code,
263: x_return_status => x_return_status);

Line 266: hz_utility_v2pub.debug(p_message=>'style_code is mandatory. ' ||

262: p_column_value => p_style_rec.style_code,
263: x_return_status => x_return_status);
264:
265: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
266: hz_utility_v2pub.debug(p_message=>'style_code is mandatory. ' ||
267: 'x_return_status = ' || x_return_status,
268: p_prefix =>l_debug_prefix,
269: p_msg_level=>fnd_log.level_statement);
270: END IF;

Line 277: HZ_UTILITY_V2PUB.validate_nonupdateable (

273: -- style_code is non-updateable field
274: IF p_create_update_flag = 'U' AND
275: p_style_rec.style_code IS NOT NULL
276: THEN
277: HZ_UTILITY_V2PUB.validate_nonupdateable (
278: p_column => 'style_code',
279: p_column_value => p_style_rec.style_code,
280: p_old_column_value => l_style_code,
281: x_return_status => x_return_status);

Line 284: hz_utility_v2pub.debug(p_message=>'style_code is non-updateable. ' ||

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

Line 311: hz_utility_v2pub.debug(p_message=>'style_code is unique during creation. ' ||

307: NULL;
308: END;
309:
310: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
311: hz_utility_v2pub.debug(p_message=>'style_code is unique during creation. ' ||
312: 'x_return_status = ' || x_return_status,
313: p_prefix =>l_debug_prefix,
314: p_msg_level=>fnd_log.level_statement);
315: END IF;

Line 324: HZ_UTILITY_V2PUB.validate_mandatory (

320: --------------------------------------
321:
322: -- database_object_name is mandatory
323: IF (p_create_update_flag = 'C') THEN
324: HZ_UTILITY_V2PUB.validate_mandatory (
325: p_create_update_flag => p_create_update_flag,
326: p_column => 'database_object_name',
327: p_column_value => p_style_rec.database_object_name,
328: x_return_status => x_return_status);

Line 331: hz_utility_v2pub.debug(p_message=>'database_object_name is mandatory. ' ||

327: p_column_value => p_style_rec.database_object_name,
328: x_return_status => x_return_status);
329:
330: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
331: hz_utility_v2pub.debug(p_message=>'database_object_name is mandatory. ' ||
332: 'x_return_status = ' || x_return_status,
333: p_prefix =>l_debug_prefix,
334: p_msg_level=>fnd_log.level_statement);
335: END IF;

Line 342: HZ_UTILITY_V2PUB.validate_nonupdateable (

338: -- database_object_name is non-updateable field
339: IF p_create_update_flag = 'U' AND
340: p_style_rec.database_object_name IS NOT NULL
341: THEN
342: HZ_UTILITY_V2PUB.validate_nonupdateable (
343: p_column => 'database_object_name',
344: p_column_value => p_style_rec.database_object_name,
345: p_old_column_value => l_database_object_name,
346: x_return_status => x_return_status);

Line 349: hz_utility_v2pub.debug(p_message=>'database_object_name is non-updateable. ' ||

345: p_old_column_value => l_database_object_name,
346: x_return_status => x_return_status);
347:
348: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
349: hz_utility_v2pub.debug(p_message=>'database_object_name is non-updateable. ' ||
350: 'x_return_status = ' || x_return_status,
351: p_prefix =>l_debug_prefix,
352: p_msg_level=>fnd_log.level_statement);
353: END IF;

Line 379: hz_utility_v2pub.debug(p_message=>'database_object_name has foreign key fnd_tables.table_name. ' ||

375: x_return_status := fnd_api.g_ret_sts_error;
376: END;
377:
378: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
379: hz_utility_v2pub.debug(p_message=>'database_object_name has foreign key fnd_tables.table_name. ' ||
380: 'x_return_status = ' || x_return_status,
381: p_prefix =>l_debug_prefix,
382: p_msg_level=>fnd_log.level_statement);
383: END IF;

Line 392: HZ_UTILITY_V2PUB.validate_mandatory (

388: -----------------------------
389:
390: -- style_name is mandatory
391: IF (p_create_update_flag = 'C') THEN
392: HZ_UTILITY_V2PUB.validate_mandatory (
393: p_create_update_flag => p_create_update_flag,
394: p_column => 'style_name',
395: p_column_value => p_style_rec.style_name,
396: x_return_status => x_return_status);

Line 399: hz_utility_v2pub.debug(p_message=>'style_name is mandatory. ' ||

395: p_column_value => p_style_rec.style_name,
396: x_return_status => x_return_status);
397:
398: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
399: hz_utility_v2pub.debug(p_message=>'style_name is mandatory. ' ||
400: 'x_return_status = ' || x_return_status,
401: p_prefix =>l_debug_prefix,
402: p_msg_level=>fnd_log.level_statement);
403: END IF;

Line 408: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (

404: END IF;
405:
406: -- style_name cannot be set to null during update
407: IF p_create_update_flag = 'U' THEN
408: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (
409: p_column => 'style_name',
410: p_column_value => p_style_rec.style_name,
411: x_return_status => x_return_status);
412:

Line 414: hz_utility_v2pub.debug(p_message=>'style_name cannot be set to null during update. ' ||

410: p_column_value => p_style_rec.style_name,
411: x_return_status => x_return_status);
412:
413: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
414: hz_utility_v2pub.debug(p_message=>'style_name cannot be set to null during update. ' ||
415: 'x_return_status = ' || x_return_status,
416: p_prefix =>l_debug_prefix,
417: p_msg_level=>fnd_log.level_statement);
418: END IF;

Line 443: hz_utility_v2pub.debug(p_message=>'style_name is unique within language. ' ||

439: WHEN NO_DATA_FOUND THEN
440: NULL;
441: END;
442: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
443: hz_utility_v2pub.debug(p_message=>'style_name is unique within language. ' ||
444: 'x_return_status = ' || x_return_status,
445: p_prefix =>l_debug_prefix,
446: p_msg_level=>fnd_log.level_statement);
447: END IF;

Line 450: hz_utility_v2pub.debug(p_message=>'validate_style (-)',

446: p_msg_level=>fnd_log.level_statement);
447: END IF;
448: END IF;
449: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
450: hz_utility_v2pub.debug(p_message=>'validate_style (-)',
451: p_prefix=>l_debug_prefix,
452: p_msg_level=>fnd_log.level_procedure);
453: END IF;
454:

Line 511: hz_utility_v2pub.debug(p_message=>'validate_style_format (+)',

507: --enable_debug;
508:
509: -- Debug info.
510: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
511: hz_utility_v2pub.debug(p_message=>'validate_style_format (+)',
512: p_prefix=>l_debug_prefix,
513: p_msg_level=>fnd_log.level_procedure);
514: END IF;
515:

Line 540: HZ_UTILITY_V2PUB.validate_mandatory (

536: -----------------------------
537:
538: -- style_format_code is mandatory
539: IF (p_create_update_flag = 'C') THEN
540: HZ_UTILITY_V2PUB.validate_mandatory (
541: p_create_update_flag => p_create_update_flag,
542: p_column => 'style_format_code',
543: p_column_value => p_style_format_rec.style_format_code,
544: x_return_status => x_return_status);

Line 547: hz_utility_v2pub.debug(p_message=>'style_format_code is mandatory. ' ||

543: p_column_value => p_style_format_rec.style_format_code,
544: x_return_status => x_return_status);
545:
546: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
547: hz_utility_v2pub.debug(p_message=>'style_format_code is mandatory. ' ||
548: 'x_return_status = ' || x_return_status,
549: p_prefix =>l_debug_prefix,
550: p_msg_level=>fnd_log.level_statement);
551: END IF;

Line 559: HZ_UTILITY_V2PUB.validate_nonupdateable (

555:
556: IF p_create_update_flag = 'U' AND
557: p_style_format_rec.style_format_code IS NOT NULL
558: THEN
559: HZ_UTILITY_V2PUB.validate_nonupdateable (
560: p_column => 'style_format_code',
561: p_column_value => p_style_format_rec.style_format_code,
562: p_old_column_value => l_style_format_code,
563: x_return_status => x_return_status);

Line 566: hz_utility_v2pub.debug(p_message=>'l_style_format_code is non-updateable. ' ||

562: p_old_column_value => l_style_format_code,
563: x_return_status => x_return_status);
564:
565: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
566: hz_utility_v2pub.debug(p_message=>'l_style_format_code is non-updateable. ' ||
567: 'x_return_status = ' || x_return_status,
568: p_prefix =>l_debug_prefix,
569: p_msg_level=>fnd_log.level_statement);
570: END IF;

Line 593: hz_utility_v2pub.debug(p_message=>'style_format_code is unique during creation. ' ||

589: NULL;
590: END;
591:
592: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
593: hz_utility_v2pub.debug(p_message=>'style_format_code is unique during creation. ' ||
594: 'x_return_status = ' || x_return_status,
595: p_prefix =>l_debug_prefix,
596: p_msg_level=>fnd_log.level_statement);
597: END IF;

Line 606: HZ_UTILITY_V2PUB.validate_mandatory (

602: -----------------------------
603:
604: -- style_code is mandatory
605: IF (p_create_update_flag = 'C') THEN
606: HZ_UTILITY_V2PUB.validate_mandatory (
607: p_create_update_flag => p_create_update_flag,
608: p_column => 'style_code',
609: p_column_value => p_style_format_rec.style_code,
610: x_return_status => x_return_status);

Line 613: hz_utility_v2pub.debug(p_message=>'style_code is mandatory. ' ||

609: p_column_value => p_style_format_rec.style_code,
610: x_return_status => x_return_status);
611:
612: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
613: hz_utility_v2pub.debug(p_message=>'style_code is mandatory. ' ||
614: 'x_return_status = ' || x_return_status,
615: p_prefix =>l_debug_prefix,
616: p_msg_level=>fnd_log.level_statement);
617: END IF;

Line 624: HZ_UTILITY_V2PUB.validate_nonupdateable (

620: -- style_code is non-updateable field
621: IF p_create_update_flag = 'U' AND
622: p_style_format_rec.style_code IS NOT NULL
623: THEN
624: HZ_UTILITY_V2PUB.validate_nonupdateable (
625: p_column => 'style_code',
626: p_column_value => p_style_format_rec.style_code,
627: p_old_column_value => l_style_code,
628: x_return_status => x_return_status);

Line 631: hz_utility_v2pub.debug(p_message=>'style_code is non-updateable. ' ||

627: p_old_column_value => l_style_code,
628: x_return_status => x_return_status);
629:
630: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
631: hz_utility_v2pub.debug(p_message=>'style_code is non-updateable. ' ||
632: 'x_return_status = ' || x_return_status,
633: p_prefix =>l_debug_prefix,
634: p_msg_level=>fnd_log.level_statement);
635: END IF;

Line 663: hz_utility_v2pub.debug(p_message=>'style_code is foreign key of hz_styles_b. ' ||

659: x_return_status := fnd_api.g_ret_sts_error;
660: END;
661:
662: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
663: hz_utility_v2pub.debug(p_message=>'style_code is foreign key of hz_styles_b. ' ||
664: 'x_return_status = ' || x_return_status,
665: p_prefix =>l_debug_prefix,
666: p_msg_level=>fnd_log.level_statement);
667: END IF;

Line 676: HZ_UTILITY_V2PUB.validate_mandatory (

672: -----------------------------
673:
674: -- default_flag is mandatory
675: IF (p_create_update_flag = 'C') THEN
676: HZ_UTILITY_V2PUB.validate_mandatory (
677: p_create_update_flag => p_create_update_flag,
678: p_column => 'default_flag',
679: p_column_value => p_style_format_rec.default_flag,
680: x_return_status => x_return_status);

Line 684: hz_utility_v2pub.debug(p_message=>'default_flag is mandatory. ' ||

680: x_return_status => x_return_status);
681:
682:
683: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
684: hz_utility_v2pub.debug(p_message=>'default_flag is mandatory. ' ||
685: 'x_return_status = ' || x_return_status,
686: p_prefix =>l_debug_prefix,
687: p_msg_level=>fnd_log.level_statement);
688: END IF;

Line 692: hz_utility_v2pub.validate_lookup (

688: END IF;
689: END IF;
690:
691: -- default_flag is lookup code in lookup type YES/NO
692: hz_utility_v2pub.validate_lookup (
693: p_column => 'default_flag',
694: p_lookup_type => 'YES/NO',
695: p_column_value => p_style_format_rec.default_flag,
696: x_return_status => x_return_status);

Line 699: hz_utility_v2pub.debug(p_message=>'default_flag is lookup code in lookup type YES/NO. ' ||

695: p_column_value => p_style_format_rec.default_flag,
696: x_return_status => x_return_status);
697:
698: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
699: hz_utility_v2pub.debug(p_message=>'default_flag is lookup code in lookup type YES/NO. ' ||
700: 'x_return_status = ' || x_return_status,
701: p_prefix =>l_debug_prefix,
702: p_msg_level=>fnd_log.level_statement);
703: END IF;

Line 707: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (

703: END IF;
704:
705: -- default_flag cannot be set to null during update
706: IF p_create_update_flag = 'U' THEN
707: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (
708: p_column => 'default_flag',
709: p_column_value => p_style_format_rec.default_flag,
710: x_return_status => x_return_status);
711:

Line 713: hz_utility_v2pub.debug(p_message=>'default_flag cannot be set to null during update. ' ||

709: p_column_value => p_style_format_rec.default_flag,
710: x_return_status => x_return_status);
711:
712: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
713: hz_utility_v2pub.debug(p_message=>'default_flag cannot be set to null during update. ' ||
714: 'x_return_status = ' || x_return_status,
715: p_prefix =>l_debug_prefix,
716: p_msg_level=>fnd_log.level_statement);
717: END IF;

Line 731: hz_utility_v2pub.debug(p_message=>'default_flag cannot be set from Yes to No. ' ||

727: fnd_msg_pub.add;
728: x_return_status := fnd_api.g_ret_sts_error;
729:
730: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
731: hz_utility_v2pub.debug(p_message=>'default_flag cannot be set from Yes to No. ' ||
732: 'x_return_status = ' || x_return_status,
733: p_prefix =>l_debug_prefix,
734: p_msg_level=>fnd_log.level_statement);
735: END IF;

Line 744: HZ_UTILITY_V2PUB.validate_mandatory (

740: -----------------------------
741:
742: -- style_format_name is mandatory
743: IF (p_create_update_flag = 'C') THEN
744: HZ_UTILITY_V2PUB.validate_mandatory (
745: p_create_update_flag => p_create_update_flag,
746: p_column => 'style_format_name',
747: p_column_value => p_style_format_rec.style_format_name,
748: x_return_status => x_return_status);

Line 751: hz_utility_v2pub.debug(p_message=>'style_format_name is mandatory. ' ||

747: p_column_value => p_style_format_rec.style_format_name,
748: x_return_status => x_return_status);
749:
750: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
751: hz_utility_v2pub.debug(p_message=>'style_format_name is mandatory. ' ||
752: 'x_return_status = ' || x_return_status,
753: p_prefix =>l_debug_prefix,
754: p_msg_level=>fnd_log.level_statement);
755: END IF;

Line 760: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (

756: END IF;
757:
758: -- style_format_name cannot be set to null during update
759: IF p_create_update_flag = 'U' THEN
760: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (
761: p_column => 'style_format_name',
762: p_column_value => p_style_format_rec.style_format_name,
763: x_return_status => x_return_status);
764:

Line 766: hz_utility_v2pub.debug(p_message=>'style_format_name cannot be set to null during update. ' ||

762: p_column_value => p_style_format_rec.style_format_name,
763: x_return_status => x_return_status);
764:
765: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
766: hz_utility_v2pub.debug(p_message=>'style_format_name cannot be set to null during update. ' ||
767: 'x_return_status = ' || x_return_status,
768: p_prefix =>l_debug_prefix,
769: p_msg_level=>fnd_log.level_statement);
770: END IF;

Line 796: hz_utility_v2pub.debug(p_message=>'style_format_name is unique within language. ' ||

792: NULL;
793: END;
794:
795: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
796: hz_utility_v2pub.debug(p_message=>'style_format_name is unique within language. ' ||
797: 'x_return_status = ' || x_return_status,
798: p_prefix =>l_debug_prefix,
799: p_msg_level=>fnd_log.level_statement);
800: END IF;

Line 804: hz_utility_v2pub.debug(p_message=>'validate_style_format (-)',

800: END IF;
801: END IF;
802:
803: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
804: hz_utility_v2pub.debug(p_message=>'validate_style_format (-)',
805: p_prefix=>l_debug_prefix,
806: p_msg_level=>fnd_log.level_procedure);
807: END IF;
808:

Line 874: hz_utility_v2pub.debug(p_message=>'validate_style_fmt_locale (+)',

870: --enable_debug;
871:
872: -- Debug info.
873: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
874: hz_utility_v2pub.debug(p_message=>'validate_style_fmt_locale (+)',
875: p_prefix=>l_debug_prefix,
876: p_msg_level=>fnd_log.level_procedure);
877: END IF;
878:

Line 922: hz_utility_v2pub.debug(p_message=>'check that style_fmt_locale_id is unique during creation. ' ||

918: x_return_status := fnd_api.g_ret_sts_error;
919: END IF;
920: CLOSE c_dup;
921: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
922: hz_utility_v2pub.debug(p_message=>'check that style_fmt_locale_id is unique during creation. ' ||
923: ' x_return_status = ' || x_return_status,
924: p_prefix =>l_debug_prefix,
925: p_msg_level=>fnd_log.level_statement);
926: END IF;

Line 931: hz_utility_v2pub.debug(p_message=>'(+) after validate style_fmt_locale_id ... ' ||

927: END IF;
928: END IF;
929:
930: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
931: hz_utility_v2pub.debug(p_message=>'(+) after validate style_fmt_locale_id ... ' ||
932: 'x_return_status = ' || x_return_status,
933: p_prefix =>l_debug_prefix,
934: p_msg_level=>fnd_log.level_statement);
935: END IF;

Line 944: HZ_UTILITY_V2PUB.validate_mandatory (

940:
941: -- style_format_code is mandatory
942:
943: IF (p_create_update_flag = 'C') THEN
944: HZ_UTILITY_V2PUB.validate_mandatory (
945: p_create_update_flag => p_create_update_flag,
946: p_column => 'style_format_code',
947: p_column_value => p_style_fmt_locale_rec.style_format_code,
948: x_return_status => x_return_status);

Line 951: hz_utility_v2pub.debug(p_message=>'style_format_code is mandatory. ' ||

947: p_column_value => p_style_fmt_locale_rec.style_format_code,
948: x_return_status => x_return_status);
949:
950: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
951: hz_utility_v2pub.debug(p_message=>'style_format_code is mandatory. ' ||
952: 'x_return_status = ' || x_return_status,
953: p_prefix =>l_debug_prefix,
954: p_msg_level=>fnd_log.level_statement);
955: END IF;

Line 962: HZ_UTILITY_V2PUB.validate_nonupdateable (

958: -- style_format_code is non-updateable field
959: IF p_create_update_flag = 'U' AND
960: p_style_fmt_locale_rec.style_format_code IS NOT NULL
961: THEN
962: HZ_UTILITY_V2PUB.validate_nonupdateable (
963: p_column => 'style_format_code',
964: p_column_value => p_style_fmt_locale_rec.style_format_code,
965: p_old_column_value => l_style_format_code,
966: x_return_status => x_return_status);

Line 969: hz_utility_v2pub.debug(p_message=>'style_format_code is non-updateable. ' ||

965: p_old_column_value => l_style_format_code,
966: x_return_status => x_return_status);
967:
968: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
969: hz_utility_v2pub.debug(p_message=>'style_format_code is non-updateable. ' ||
970: 'x_return_status = ' || x_return_status,
971: p_prefix =>l_debug_prefix,
972: p_msg_level=>fnd_log.level_statement);
973: END IF;

Line 1001: hz_utility_v2pub.debug(p_message=>'style_format_code is foreign key of hz_style_formats_b. ' ||

997: fnd_msg_pub.add;
998: x_return_status := fnd_api.g_ret_sts_error;
999: END;
1000: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1001: hz_utility_v2pub.debug(p_message=>'style_format_code is foreign key of hz_style_formats_b. ' ||
1002: 'x_return_status = ' || x_return_status,
1003: p_prefix =>l_debug_prefix,
1004: p_msg_level=>fnd_log.level_statement);
1005: END IF;

Line 1017: HZ_UTILITY_V2PUB.validate_nonupdateable (

1013:
1014: IF p_create_update_flag = 'U' AND
1015: p_style_fmt_locale_rec.language_code IS NOT NULL
1016: THEN
1017: HZ_UTILITY_V2PUB.validate_nonupdateable (
1018: p_column => 'language_code',
1019: p_column_value => p_style_fmt_locale_rec.language_code,
1020: p_old_column_value => l_language_code,
1021: x_return_status => x_return_status);

Line 1024: hz_utility_v2pub.debug(p_message=>'language_code is non-updateable. ' ||

1020: p_old_column_value => l_language_code,
1021: x_return_status => x_return_status);
1022:
1023: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1024: hz_utility_v2pub.debug(p_message=>'language_code is non-updateable. ' ||
1025: 'x_return_status = ' || x_return_status,
1026: p_prefix =>l_debug_prefix,
1027: p_msg_level=>fnd_log.level_statement);
1028: END IF;

Line 1055: hz_utility_v2pub.debug(p_message=>'language_code is foreign key of fnd_languages. ' ||

1051: fnd_msg_pub.add;
1052: x_return_status := fnd_api.g_ret_sts_error;
1053: END;
1054: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1055: hz_utility_v2pub.debug(p_message=>'language_code is foreign key of fnd_languages. ' ||
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 1071: HZ_UTILITY_V2PUB.validate_nonupdateable (

1067:
1068: IF p_create_update_flag = 'U' AND
1069: p_style_fmt_locale_rec.territory_code IS NOT NULL
1070: THEN
1071: HZ_UTILITY_V2PUB.validate_nonupdateable (
1072: p_column => 'territory_code',
1073: p_column_value => p_style_fmt_locale_rec.territory_code,
1074: p_old_column_value => l_territory_code,
1075: x_return_status => x_return_status);

Line 1078: hz_utility_v2pub.debug(p_message=>'territory_code is non-updateable. ' ||

1074: p_old_column_value => l_territory_code,
1075: x_return_status => x_return_status);
1076:
1077: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1078: hz_utility_v2pub.debug(p_message=>'territory_code is non-updateable. ' ||
1079: 'x_return_status = ' || x_return_status,
1080: p_prefix =>l_debug_prefix,
1081: p_msg_level=>fnd_log.level_statement);
1082: END IF;

Line 1109: hz_utility_v2pub.debug(p_message=>'territory_code is foreign key of fnd_territories. ' ||

1105: fnd_msg_pub.add;
1106: x_return_status := fnd_api.g_ret_sts_error;
1107: END;
1108: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1109: hz_utility_v2pub.debug(p_message=>'territory_code is foreign key of fnd_territories. ' ||
1110: 'x_return_status = ' || x_return_status,
1111: p_prefix =>l_debug_prefix,
1112: p_msg_level=>fnd_log.level_statement);
1113: END IF;

Line 1132: hz_utility_v2pub.debug(p_message=>'Either language_code or territory_code must have a value. ' ||

1128: FND_MSG_PUB.ADD;
1129: x_return_status := FND_API.G_RET_STS_ERROR;
1130:
1131: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1132: hz_utility_v2pub.debug(p_message=>'Either language_code or territory_code must have a value. ' ||
1133: 'x_return_status = ' || x_return_status,
1134: p_prefix =>l_debug_prefix,
1135: p_msg_level=>fnd_log.level_statement);
1136: END IF;

Line 1147: HZ_UTILITY_V2PUB.validate_mandatory (

1143: -----------------------------
1144:
1145: -- start_date_active is mandatory
1146: IF (p_create_update_flag = 'C') THEN
1147: HZ_UTILITY_V2PUB.validate_mandatory (
1148: p_create_update_flag => p_create_update_flag,
1149: p_column => 'start_date_active',
1150: p_column_value => p_style_fmt_locale_rec.start_date_active,
1151: x_return_status => x_return_status);

Line 1154: hz_utility_v2pub.debug(p_message=>'start_date_active is mandatory. ' ||

1150: p_column_value => p_style_fmt_locale_rec.start_date_active,
1151: x_return_status => x_return_status);
1152:
1153: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1154: hz_utility_v2pub.debug(p_message=>'start_date_active is mandatory. ' ||
1155: 'x_return_status = ' || x_return_status,
1156: p_prefix =>l_debug_prefix,
1157: p_msg_level=>fnd_log.level_statement);
1158: END IF;

Line 1163: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (

1159: END IF;
1160:
1161: -- start_date_active cannot be set to null during update
1162: IF p_create_update_flag = 'U' THEN
1163: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (
1164: p_column => 'start_date_active',
1165: p_column_value => p_style_fmt_locale_rec.start_date_active,
1166: x_return_status => x_return_status);
1167:

Line 1169: hz_utility_v2pub.debug(p_message=>'start_date_active cannot be set to null during update. ' ||

1165: p_column_value => p_style_fmt_locale_rec.start_date_active,
1166: x_return_status => x_return_status);
1167:
1168: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1169: hz_utility_v2pub.debug(p_message=>'start_date_active cannot be set to null during update. ' ||
1170: 'x_return_status = ' || x_return_status,
1171: p_prefix =>l_debug_prefix,
1172: p_msg_level=>fnd_log.level_statement);
1173: END IF;

Line 1217: hz_utility_v2pub.debug(p_message=>'end_date_active must be null or greater than start date. ' ||

1213: x_return_status := fnd_api.g_ret_sts_error;
1214: END IF;
1215: END IF;
1216: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1217: hz_utility_v2pub.debug(p_message=>'end_date_active must be null or greater than start date. ' ||
1218: 'x_return_status = ' || x_return_status,
1219: p_prefix =>l_debug_prefix,
1220: p_msg_level=>fnd_log.level_statement);
1221: END IF;

Line 1258: hz_utility_v2pub.debug(p_message=>'Another record exist for this style format layout with an overlapping date ranger. Please input a unique combination of style_format_code, language_code, territory_code validation' ||

1254: NULL;
1255: END;
1256:
1257: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1258: hz_utility_v2pub.debug(p_message=>'Another record exist for this style format layout with an overlapping date ranger. Please input a unique combination of style_format_code, language_code, territory_code validation' ||
1259: 'x_return_status = ' || x_return_status,
1260: p_prefix =>l_debug_prefix,
1261: p_msg_level=>fnd_log.level_statement);
1262: END IF;

Line 1301: hz_utility_v2pub.debug(p_message=>'Another record exist for this style format layout with an overlapping date ranger. Please input a unique combination of style_format_code, language_code, territory_code validation' ||

1297: NULL;
1298: END;
1299:
1300: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1301: hz_utility_v2pub.debug(p_message=>'Another record exist for this style format layout with an overlapping date ranger. Please input a unique combination of style_format_code, language_code, territory_code validation' ||
1302: 'x_return_status = ' || x_return_status,
1303: p_prefix =>l_debug_prefix,
1304: p_msg_level=>fnd_log.level_statement);
1305: END IF;

Line 1311: hz_utility_v2pub.debug(p_message=>'validate_style_fmt_locale (-)',

1307:
1308: END IF;
1309:
1310: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1311: hz_utility_v2pub.debug(p_message=>'validate_style_fmt_locale (-)',
1312: p_prefix=>l_debug_prefix,
1313: p_msg_level=>fnd_log.level_procedure);
1314: END IF;
1315:

Line 1371: hz_utility_v2pub.debug(p_message=>'validate_style_fmt_variation (+)',

1367: --enable_debug;
1368:
1369: -- Debug info.
1370: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1371: hz_utility_v2pub.debug(p_message=>'validate_style_fmt_variation (+)',
1372: p_prefix=>l_debug_prefix,
1373: p_msg_level=>fnd_log.level_procedure);
1374: END IF;
1375:

Line 1401: HZ_UTILITY_V2PUB.validate_mandatory (

1397: -----------------------------
1398:
1399: -- style_format_code is mandatory
1400: IF (p_create_update_flag = 'C') THEN
1401: HZ_UTILITY_V2PUB.validate_mandatory (
1402: p_create_update_flag => p_create_update_flag,
1403: p_column => 'style_format_code',
1404: p_column_value => p_style_fmt_variation_rec.style_format_code,
1405: x_return_status => x_return_status);

Line 1408: hz_utility_v2pub.debug(p_message=>'style_format_code is mandatory. ' ||

1404: p_column_value => p_style_fmt_variation_rec.style_format_code,
1405: x_return_status => x_return_status);
1406:
1407: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1408: hz_utility_v2pub.debug(p_message=>'style_format_code is mandatory. ' ||
1409: 'x_return_status = ' || x_return_status,
1410: p_prefix =>l_debug_prefix,
1411: p_msg_level=>fnd_log.level_statement);
1412: END IF;

Line 1420: HZ_UTILITY_V2PUB.validate_nonupdateable (

1416:
1417: IF p_create_update_flag = 'U' AND
1418: p_style_fmt_variation_rec.style_format_code IS NOT NULL
1419: THEN
1420: HZ_UTILITY_V2PUB.validate_nonupdateable (
1421: p_column => 'style_format_code',
1422: p_column_value => p_style_fmt_variation_rec.style_format_code,
1423: p_old_column_value => l_style_format_code,
1424: x_return_status => x_return_status);

Line 1427: hz_utility_v2pub.debug(p_message=>'l_style_format_code is non-updateable. ' ||

1423: p_old_column_value => l_style_format_code,
1424: x_return_status => x_return_status);
1425:
1426: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1427: hz_utility_v2pub.debug(p_message=>'l_style_format_code is non-updateable. ' ||
1428: 'x_return_status = ' || x_return_status,
1429: p_prefix =>l_debug_prefix,
1430: p_msg_level=>fnd_log.level_statement);
1431: END IF;

Line 1458: hz_utility_v2pub.debug(p_message=>'style_format_code is foreign key of hz_style_formats_b. ' ||

1454: fnd_msg_pub.add;
1455: x_return_status := fnd_api.g_ret_sts_error;
1456: END;
1457: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1458: hz_utility_v2pub.debug(p_message=>'style_format_code is foreign key of hz_style_formats_b. ' ||
1459: 'x_return_status = ' || x_return_status,
1460: p_prefix =>l_debug_prefix,
1461: p_msg_level=>fnd_log.level_statement);
1462: END IF;

Line 1471: HZ_UTILITY_V2PUB.validate_mandatory (

1467: -----------------------------
1468:
1469: -- variation_number is mandatory
1470: IF (p_create_update_flag = 'C') THEN
1471: HZ_UTILITY_V2PUB.validate_mandatory (
1472: p_create_update_flag => p_create_update_flag,
1473: p_column => 'variation_number',
1474: p_column_value => p_style_fmt_variation_rec.variation_number,
1475: x_return_status => x_return_status);

Line 1478: hz_utility_v2pub.debug(p_message=>'variation_number is mandatory. ' ||

1474: p_column_value => p_style_fmt_variation_rec.variation_number,
1475: x_return_status => x_return_status);
1476:
1477: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1478: hz_utility_v2pub.debug(p_message=>'variation_number is mandatory. ' ||
1479: 'x_return_status = ' || x_return_status,
1480: p_prefix =>l_debug_prefix,
1481: p_msg_level=>fnd_log.level_statement);
1482: END IF;

Line 1490: HZ_UTILITY_V2PUB.validate_nonupdateable (

1486:
1487: IF p_create_update_flag = 'U' AND
1488: p_style_fmt_variation_rec.variation_number IS NOT NULL
1489: THEN
1490: HZ_UTILITY_V2PUB.validate_nonupdateable (
1491: p_column => 'variation_number',
1492: p_column_value => p_style_fmt_variation_rec.variation_number,
1493: p_old_column_value => l_variation_number,
1494: x_return_status => x_return_status);

Line 1497: hz_utility_v2pub.debug(p_message=>'l_variation_number is non-updateable. ' ||

1493: p_old_column_value => l_variation_number,
1494: x_return_status => x_return_status);
1495:
1496: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1497: hz_utility_v2pub.debug(p_message=>'l_variation_number is non-updateable. ' ||
1498: 'x_return_status = ' || x_return_status,
1499: p_prefix =>l_debug_prefix,
1500: p_msg_level=>fnd_log.level_statement);
1501: END IF;

Line 1523: hz_utility_v2pub.debug(p_message=>'The combanition of variation_number, style_format_code is unique. ' ||

1519: NULL;
1520: END;
1521:
1522: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1523: hz_utility_v2pub.debug(p_message=>'The combanition of variation_number, style_format_code is unique. ' ||
1524: 'x_return_status = ' || x_return_status,
1525: p_prefix =>l_debug_prefix,
1526: p_msg_level=>fnd_log.level_statement);
1527: END IF;

Line 1540: hz_utility_v2pub.debug(p_message=>'variation_number should be > 0.' ||'x_return_status = ' ||

1536: p_column_value => p_style_fmt_variation_rec.variation_number,
1537: x_return_status => x_return_status );
1538:
1539: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1540: hz_utility_v2pub.debug(p_message=>'variation_number should be > 0.' ||'x_return_status = ' ||
1541: x_return_status,
1542: p_prefix =>l_debug_prefix,
1543: p_msg_level=>fnd_log.level_statement);
1544: END IF;

Line 1554: HZ_UTILITY_V2PUB.validate_mandatory (

1550: ------------------------------
1551:
1552: -- variation_rank is mandatory
1553: IF (p_create_update_flag = 'C') THEN
1554: HZ_UTILITY_V2PUB.validate_mandatory (
1555: p_create_update_flag => p_create_update_flag,
1556: p_column => 'variation_rank',
1557: p_column_value => p_style_fmt_variation_rec.variation_rank,
1558: x_return_status => x_return_status);

Line 1561: hz_utility_v2pub.debug(p_message=>'variation_rank is mandatory. ' ||

1557: p_column_value => p_style_fmt_variation_rec.variation_rank,
1558: x_return_status => x_return_status);
1559:
1560: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1561: hz_utility_v2pub.debug(p_message=>'variation_rank is mandatory. ' ||
1562: 'x_return_status = ' || x_return_status,
1563: p_prefix =>l_debug_prefix,
1564: p_msg_level=>fnd_log.level_statement);
1565: END IF;

Line 1590: hz_utility_v2pub.debug(p_message=>'variation_rank is unique within style_format_code. ' ||

1586: NULL;
1587: END;
1588:
1589: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1590: hz_utility_v2pub.debug(p_message=>'variation_rank is unique within style_format_code. ' ||
1591: 'x_return_status = ' || x_return_status,
1592: p_prefix =>l_debug_prefix,
1593: p_msg_level=>fnd_log.level_statement);
1594: END IF;

Line 1599: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (

1595: END IF;
1596:
1597: -- variation_rank cannot be set to null during update
1598: IF p_create_update_flag = 'U' THEN
1599: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (
1600: p_column => 'variation_rank',
1601: p_column_value => p_style_fmt_variation_rec.variation_rank,
1602: x_return_status => x_return_status);
1603:

Line 1605: hz_utility_v2pub.debug(p_message=>'variation_rank cannot be set to null during update. ' ||

1601: p_column_value => p_style_fmt_variation_rec.variation_rank,
1602: x_return_status => x_return_status);
1603:
1604: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1605: hz_utility_v2pub.debug(p_message=>'variation_rank cannot be set to null during update. ' ||
1606: 'x_return_status = ' || x_return_status,
1607: p_prefix =>l_debug_prefix,
1608: p_msg_level=>fnd_log.level_statement);
1609: END IF;

Line 1626: hz_utility_v2pub.debug(p_message=>'variation_rank should be > 0.' ||'x_return_status = ' ||

1622: p_column => 'variation_rank',
1623: p_column_value => p_style_fmt_variation_rec.variation_rank,
1624: x_return_status => x_return_status );
1625: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1626: hz_utility_v2pub.debug(p_message=>'variation_rank should be > 0.' ||'x_return_status = ' ||
1627: x_return_status,
1628: p_prefix =>l_debug_prefix,
1629: p_msg_level=>fnd_log.level_statement);
1630: END IF;

Line 1639: HZ_UTILITY_V2PUB.validate_mandatory (

1635: -----------------------------
1636:
1637: -- start_date_active is mandatory
1638: IF (p_create_update_flag = 'C') THEN
1639: HZ_UTILITY_V2PUB.validate_mandatory (
1640: p_create_update_flag => p_create_update_flag,
1641: p_column => 'start_date_active',
1642: p_column_value => p_style_fmt_variation_rec.start_date_active,
1643: x_return_status => x_return_status);

Line 1646: hz_utility_v2pub.debug(p_message=>'start_date_active is mandatory. ' ||

1642: p_column_value => p_style_fmt_variation_rec.start_date_active,
1643: x_return_status => x_return_status);
1644:
1645: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1646: hz_utility_v2pub.debug(p_message=>'start_date_active is mandatory. ' ||
1647: 'x_return_status = ' || x_return_status,
1648: p_prefix =>l_debug_prefix,
1649: p_msg_level=>fnd_log.level_statement);
1650: END IF;

Line 1655: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (

1651: END IF;
1652:
1653: -- start_date_active cannot be set to null during update
1654: IF p_create_update_flag = 'U' THEN
1655: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (
1656: p_column => 'start_date_active',
1657: p_column_value => p_style_fmt_variation_rec.start_date_active,
1658: x_return_status => x_return_status);
1659:

Line 1661: hz_utility_v2pub.debug(p_message=>'start_date_active cannot be set to null during update. ' ||

1657: p_column_value => p_style_fmt_variation_rec.start_date_active,
1658: x_return_status => x_return_status);
1659:
1660: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1661: hz_utility_v2pub.debug(p_message=>'start_date_active cannot be set to null during update. ' ||
1662: 'x_return_status = ' || x_return_status,
1663: p_prefix =>l_debug_prefix,
1664: p_msg_level=>fnd_log.level_statement);
1665: END IF;

Line 1710: hz_utility_v2pub.debug(p_message=>'end_date_active must be null or greater than start date. ' ||

1706: END IF;
1707: END IF;
1708:
1709: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1710: hz_utility_v2pub.debug(p_message=>'end_date_active must be null or greater than start date. ' ||
1711: 'x_return_status = ' || x_return_status,
1712: p_prefix =>l_debug_prefix,
1713: p_msg_level=>fnd_log.level_statement);
1714: END IF;

Line 1717: hz_utility_v2pub.debug(p_message=>'validate_style_fmt_variation (+)',

1713: p_msg_level=>fnd_log.level_statement);
1714: END IF;
1715:
1716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1717: hz_utility_v2pub.debug(p_message=>'validate_style_fmt_variation (+)',
1718: p_prefix=>l_debug_prefix,
1719: p_msg_level=>fnd_log.level_procedure);
1720: END IF;
1721:

Line 1797: hz_utility_v2pub.debug(p_message=>'validate_style_fmt_layout (+)',

1793: --enable_debug;
1794:
1795: -- Debug info.
1796: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1797: hz_utility_v2pub.debug(p_message=>'validate_style_fmt_layout (+)',
1798: p_prefix=>l_debug_prefix,
1799: p_msg_level=>fnd_log.level_procedure);
1800: END IF;
1801:

Line 1868: hz_utility_v2pub.debug(p_message=>'check that style_fmt_layout_id is unique during creation. ' ||

1864: x_return_status := fnd_api.g_ret_sts_error;
1865: END IF;
1866: CLOSE c_dup;
1867: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1868: hz_utility_v2pub.debug(p_message=>'check that style_fmt_layout_id is unique during creation. ' ||
1869: ' x_return_status = ' || x_return_status,
1870: p_prefix =>l_debug_prefix,
1871: p_msg_level=>fnd_log.level_statement);
1872: END IF;

Line 1877: hz_utility_v2pub.debug(p_message=>'(+) after validate style_fmt_layout_id ... ' ||

1873: END IF;
1874: END IF;
1875:
1876: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1877: hz_utility_v2pub.debug(p_message=>'(+) after validate style_fmt_layout_id ... ' ||
1878: 'x_return_status = ' || x_return_status,
1879: p_prefix =>l_debug_prefix,
1880: p_msg_level=>fnd_log.level_statement);
1881: END IF;

Line 1889: HZ_UTILITY_V2PUB.validate_mandatory (

1885: -----------------------------
1886:
1887: -- style_format_code is mandatory
1888: IF (p_create_update_flag = 'C') THEN
1889: HZ_UTILITY_V2PUB.validate_mandatory (
1890: p_create_update_flag => p_create_update_flag,
1891: p_column => 'style_format_code',
1892: p_column_value => p_style_fmt_layout_rec.style_format_code,
1893: x_return_status => x_return_status);

Line 1896: hz_utility_v2pub.debug(p_message=>'style_format_code is mandatory. ' ||

1892: p_column_value => p_style_fmt_layout_rec.style_format_code,
1893: x_return_status => x_return_status);
1894:
1895: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1896: hz_utility_v2pub.debug(p_message=>'style_format_code is mandatory. ' ||
1897: 'x_return_status = ' || x_return_status,
1898: p_prefix =>l_debug_prefix,
1899: p_msg_level=>fnd_log.level_statement);
1900: END IF;

Line 1908: HZ_UTILITY_V2PUB.validate_nonupdateable (

1904:
1905: IF p_create_update_flag = 'U' AND
1906: p_style_fmt_layout_rec.style_format_code IS NOT NULL
1907: THEN
1908: HZ_UTILITY_V2PUB.validate_nonupdateable (
1909: p_column => 'style_format_code',
1910: p_column_value => p_style_fmt_layout_rec.style_format_code,
1911: p_old_column_value => l_style_format_code,
1912: x_return_status => x_return_status);

Line 1915: hz_utility_v2pub.debug(p_message=>'l_style_format_code is non-updateable. ' ||

1911: p_old_column_value => l_style_format_code,
1912: x_return_status => x_return_status);
1913:
1914: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1915: hz_utility_v2pub.debug(p_message=>'l_style_format_code is non-updateable. ' ||
1916: 'x_return_status = ' || x_return_status,
1917: p_prefix =>l_debug_prefix,
1918: p_msg_level=>fnd_log.level_statement);
1919: END IF;

Line 1928: HZ_UTILITY_V2PUB.validate_mandatory (

1924: -----------------------------
1925:
1926: -- variation_number is mandatory
1927: IF (p_create_update_flag = 'C') THEN
1928: HZ_UTILITY_V2PUB.validate_mandatory (
1929: p_create_update_flag => p_create_update_flag,
1930: p_column => 'variation_number',
1931: p_column_value => p_style_fmt_layout_rec.variation_number,
1932: x_return_status => x_return_status);

Line 1935: hz_utility_v2pub.debug(p_message=>'variation_number is mandatory. ' ||

1931: p_column_value => p_style_fmt_layout_rec.variation_number,
1932: x_return_status => x_return_status);
1933:
1934: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1935: hz_utility_v2pub.debug(p_message=>'variation_number is mandatory. ' ||
1936: 'x_return_status = ' || x_return_status,
1937: p_prefix =>l_debug_prefix,
1938: p_msg_level=>fnd_log.level_statement);
1939: END IF;

Line 1947: HZ_UTILITY_V2PUB.validate_nonupdateable (

1943:
1944: IF p_create_update_flag = 'U' AND
1945: p_style_fmt_layout_rec.variation_number IS NOT NULL
1946: THEN
1947: HZ_UTILITY_V2PUB.validate_nonupdateable (
1948: p_column => 'variation_number',
1949: p_column_value => p_style_fmt_layout_rec.variation_number,
1950: p_old_column_value => l_variation_number,
1951: x_return_status => x_return_status);

Line 1954: hz_utility_v2pub.debug(p_message=>'l_variation_number is non-updateable. ' ||

1950: p_old_column_value => l_variation_number,
1951: x_return_status => x_return_status);
1952:
1953: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1954: hz_utility_v2pub.debug(p_message=>'l_variation_number is non-updateable. ' ||
1955: 'x_return_status = ' || x_return_status,
1956: p_prefix =>l_debug_prefix,
1957: p_msg_level=>fnd_log.level_statement);
1958: END IF;

Line 1971: hz_utility_v2pub.debug(p_message=>'variation_number should be > 0.' ||'x_return_status = ' ||

1967: p_column_value => p_style_fmt_layout_rec.variation_number,
1968: x_return_status => x_return_status );
1969:
1970: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1971: hz_utility_v2pub.debug(p_message=>'variation_number should be > 0.' ||'x_return_status = ' ||
1972: x_return_status,
1973: p_prefix =>l_debug_prefix,
1974: p_msg_level=>fnd_log.level_statement);
1975: END IF;

Line 2019: hz_utility_v2pub.debug(p_message=>'Start date and end date should be within the time range of the corresponding style format variation.' ||

2015: fnd_msg_pub.add;
2016: x_return_status := fnd_api.g_ret_sts_error;
2017: END;
2018: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2019: hz_utility_v2pub.debug(p_message=>'Start date and end date should be within the time range of the corresponding style format variation.' ||
2020: 'x_return_status = ' || x_return_status,
2021: p_prefix =>l_debug_prefix,
2022: p_msg_level=>fnd_log.level_statement);
2023: END IF;

Line 2033: hz_utility_v2pub.debug(p_message=>'style_format_code and variation_number are foreign key of table hz_style_fmt_variations .' ||

2029: fnd_msg_pub.add;
2030: x_return_status := fnd_api.g_ret_sts_error;
2031: END;
2032: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2033: hz_utility_v2pub.debug(p_message=>'style_format_code and variation_number are foreign key of table hz_style_fmt_variations .' ||
2034: 'x_return_status = ' || x_return_status,
2035: p_prefix =>l_debug_prefix,
2036: p_msg_level=>fnd_log.level_statement);
2037: END IF;

Line 2062: hz_utility_v2pub.debug(p_message=>'Start date and end date should be within the time range of the corresponding style format variation.' ||

2058: fnd_msg_pub.add;
2059: x_return_status := fnd_api.g_ret_sts_error;
2060: END;
2061: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2062: hz_utility_v2pub.debug(p_message=>'Start date and end date should be within the time range of the corresponding style format variation.' ||
2063: 'x_return_status = ' || x_return_status,
2064: p_prefix =>l_debug_prefix,
2065: p_msg_level=>fnd_log.level_statement);
2066: END IF;

Line 2077: HZ_UTILITY_V2PUB.validate_mandatory (

2073: -----------------------------
2074:
2075: -- attribute_code is mandatory
2076: IF (p_create_update_flag = 'C') THEN
2077: HZ_UTILITY_V2PUB.validate_mandatory (
2078: p_create_update_flag => p_create_update_flag,
2079: p_column => 'attribute_code',
2080: p_column_value => p_style_fmt_layout_rec.attribute_code,
2081: x_return_status => x_return_status);

Line 2083: hz_utility_v2pub.debug(p_message=>'attribute_code is mandatory. ' ||

2079: p_column => 'attribute_code',
2080: p_column_value => p_style_fmt_layout_rec.attribute_code,
2081: x_return_status => x_return_status);
2082: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2083: hz_utility_v2pub.debug(p_message=>'attribute_code is mandatory. ' ||
2084: 'x_return_status = ' || x_return_status,
2085: p_prefix =>l_debug_prefix,
2086: p_msg_level=>fnd_log.level_statement);
2087: END IF;

Line 2095: HZ_UTILITY_V2PUB.validate_nonupdateable (

2091:
2092: IF p_create_update_flag = 'U' AND
2093: p_style_fmt_layout_rec.attribute_code IS NOT NULL
2094: THEN
2095: HZ_UTILITY_V2PUB.validate_nonupdateable (
2096: p_column => 'attribute_code',
2097: p_column_value => p_style_fmt_layout_rec.attribute_code,
2098: p_old_column_value => l_attribute_code,
2099: x_return_status => x_return_status);

Line 2102: hz_utility_v2pub.debug(p_message=>'attribute_code is non-updateable. ' ||

2098: p_old_column_value => l_attribute_code,
2099: x_return_status => x_return_status);
2100:
2101: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2102: hz_utility_v2pub.debug(p_message=>'attribute_code is non-updateable. ' ||
2103: 'x_return_status = ' || x_return_status,
2104: p_prefix =>l_debug_prefix,
2105: p_msg_level=>fnd_log.level_statement);
2106: END IF;

Line 2115: HZ_UTILITY_V2PUB.validate_mandatory (

2111: ------------------------------------
2112:
2113: -- attribute_application_id is mandatory
2114: IF (p_create_update_flag = 'C') THEN
2115: HZ_UTILITY_V2PUB.validate_mandatory (
2116: p_create_update_flag => p_create_update_flag,
2117: p_column => 'attribute_application_id',
2118: p_column_value => p_style_fmt_layout_rec.attribute_application_id,
2119: x_return_status => x_return_status);

Line 2122: hz_utility_v2pub.debug(p_message=>'attribute_application_id is mandatory. ' ||

2118: p_column_value => p_style_fmt_layout_rec.attribute_application_id,
2119: x_return_status => x_return_status);
2120:
2121: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2122: hz_utility_v2pub.debug(p_message=>'attribute_application_id is mandatory. ' ||
2123: 'x_return_status = ' || x_return_status,
2124: p_prefix =>l_debug_prefix,
2125: p_msg_level=>fnd_log.level_statement);
2126: END IF;

Line 2134: HZ_UTILITY_V2PUB.validate_nonupdateable (

2130:
2131: IF p_create_update_flag = 'U' AND
2132: p_style_fmt_layout_rec.attribute_application_id IS NOT NULL
2133: THEN
2134: HZ_UTILITY_V2PUB.validate_nonupdateable (
2135: p_column => 'attribute_application_id',
2136: p_column_value => p_style_fmt_layout_rec.attribute_application_id,
2137: p_old_column_value => l_attribute_application_id,
2138: x_return_status => x_return_status);

Line 2140: hz_utility_v2pub.debug(p_message=>'attribute_application_id is non-updateable. ' ||

2136: p_column_value => p_style_fmt_layout_rec.attribute_application_id,
2137: p_old_column_value => l_attribute_application_id,
2138: x_return_status => x_return_status);
2139: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2140: hz_utility_v2pub.debug(p_message=>'attribute_application_id is non-updateable. ' ||
2141: 'x_return_status = ' || x_return_status,
2142: p_prefix =>l_debug_prefix,
2143: p_msg_level=>fnd_log.level_statement);
2144: END IF;

Line 2184: hz_utility_v2pub.debug(p_message=>'the ATTRIBUTE_CODE' || p_style_fmt_layout_rec.attribute_code ||

2180: fnd_msg_pub.add;
2181: x_return_status := fnd_api.g_ret_sts_error;
2182: END;
2183: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2184: hz_utility_v2pub.debug(p_message=>'the ATTRIBUTE_CODE' || p_style_fmt_layout_rec.attribute_code ||
2185: 'does not exist in table specified in ' || l_database_object_name ||
2186: ' x_return_status = ' || x_return_status,
2187: p_prefix =>l_debug_prefix,
2188: p_msg_level=>fnd_log.level_statement);

Line 2230: hz_utility_v2pub.debug(p_message=>'Another record exist for this style format layout with an overlapping date ranger. Please input a unique combination of style_format_code, variation_number, attribute_code, attribute_application_id.' ||

2226: NULL;
2227: END;
2228:
2229: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2230: hz_utility_v2pub.debug(p_message=>'Another record exist for this style format layout with an overlapping date ranger. Please input a unique combination of style_format_code, variation_number, attribute_code, attribute_application_id.' ||
2231: 'x_return_status = ' || x_return_status,
2232: p_prefix =>l_debug_prefix,
2233: p_msg_level=>fnd_log.level_statement);
2234: END IF;

Line 2264: hz_utility_v2pub.debug(p_message=>'Another record exist for this style format layout with an overlapping date ranger. Please input a unique combination of style_format_code, variation_number, attribute_code, attribute_application_id.' ||

2260: WHEN NO_DATA_FOUND THEN
2261: NULL;
2262: END;
2263: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2264: hz_utility_v2pub.debug(p_message=>'Another record exist for this style format layout with an overlapping date ranger. Please input a unique combination of style_format_code, variation_number, attribute_code, attribute_application_id.' ||
2265: 'x_return_status = ' || x_return_status,
2266: p_prefix =>l_debug_prefix,
2267: p_msg_level=>fnd_log.level_statement);
2268: END IF;

Line 2278: HZ_UTILITY_V2PUB.validate_mandatory (

2274: ------------------------------------
2275:
2276: -- line_number is mandatory
2277: IF (p_create_update_flag = 'C') THEN
2278: HZ_UTILITY_V2PUB.validate_mandatory (
2279: p_create_update_flag => p_create_update_flag,
2280: p_column => 'line_number ',
2281: p_column_value => p_style_fmt_layout_rec.line_number ,
2282: x_return_status => x_return_status);

Line 2285: hz_utility_v2pub.debug(p_message=>'line_number is mandatory. ' ||

2281: p_column_value => p_style_fmt_layout_rec.line_number ,
2282: x_return_status => x_return_status);
2283:
2284: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2285: hz_utility_v2pub.debug(p_message=>'line_number is mandatory. ' ||
2286: 'x_return_status = ' || x_return_status,
2287: p_prefix =>l_debug_prefix,
2288: p_msg_level=>fnd_log.level_statement);
2289: END IF;

Line 2301: hz_utility_v2pub.debug(p_message=>'line_number should be > 0.' ||'x_return_status = ' ||

2297: p_column => 'line_number',
2298: p_column_value => p_style_fmt_layout_rec.line_number,
2299: x_return_status => x_return_status );
2300: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2301: hz_utility_v2pub.debug(p_message=>'line_number should be > 0.' ||'x_return_status = ' ||
2302: x_return_status,
2303: p_prefix =>l_debug_prefix,
2304: p_msg_level=>fnd_log.level_statement);
2305: END IF;

Line 2310: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (

2306: END IF;
2307:
2308: -- line_number cannot be set to null during update
2309: IF p_create_update_flag = 'U' THEN
2310: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (
2311: p_column => 'line_number',
2312: p_column_value => p_style_fmt_layout_rec.line_number,
2313: x_return_status => x_return_status);
2314: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2315: hz_utility_v2pub.debug(p_message=>'line_number cannot be set to null during update. ' ||

2311: p_column => 'line_number',
2312: p_column_value => p_style_fmt_layout_rec.line_number,
2313: x_return_status => x_return_status);
2314: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2315: hz_utility_v2pub.debug(p_message=>'line_number cannot be set to null during update. ' ||
2316: 'x_return_status = ' || x_return_status,
2317: p_prefix =>l_debug_prefix,
2318: p_msg_level=>fnd_log.level_statement);
2319: END IF;

Line 2329: HZ_UTILITY_V2PUB.validate_mandatory (

2325: ------------------------------------
2326:
2327: -- position is mandatory
2328: IF (p_create_update_flag = 'C') THEN
2329: HZ_UTILITY_V2PUB.validate_mandatory (
2330: p_create_update_flag => p_create_update_flag,
2331: p_column => 'position ',
2332: p_column_value => p_style_fmt_layout_rec.position ,
2333: x_return_status => x_return_status);

Line 2335: hz_utility_v2pub.debug(p_message=>'position is mandatory. ' ||

2331: p_column => 'position ',
2332: p_column_value => p_style_fmt_layout_rec.position ,
2333: x_return_status => x_return_status);
2334: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2335: hz_utility_v2pub.debug(p_message=>'position is mandatory. ' ||
2336: 'x_return_status = ' || x_return_status,
2337: p_prefix =>l_debug_prefix,
2338: p_msg_level=>fnd_log.level_statement);
2339: END IF;

Line 2351: hz_utility_v2pub.debug(p_message=>'position should be > 0.' ||'x_return_status = ' ||

2347: p_column => 'position',
2348: p_column_value => p_style_fmt_layout_rec.position,
2349: x_return_status => x_return_status );
2350: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2351: hz_utility_v2pub.debug(p_message=>'position should be > 0.' ||'x_return_status = ' ||
2352: x_return_status,
2353: p_prefix =>l_debug_prefix,
2354: p_msg_level=>fnd_log.level_statement);
2355: END IF;

Line 2360: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (

2356: END IF;
2357:
2358: -- position cannot be set to null during update
2359: IF p_create_update_flag = 'U' THEN
2360: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (
2361: p_column => 'position',
2362: p_column_value => p_style_fmt_layout_rec.position,
2363: x_return_status => x_return_status);
2364: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2365: hz_utility_v2pub.debug(p_message=>'position cannot be set to null during update. ' ||

2361: p_column => 'position',
2362: p_column_value => p_style_fmt_layout_rec.position,
2363: x_return_status => x_return_status);
2364: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2365: hz_utility_v2pub.debug(p_message=>'position cannot be set to null during update. ' ||
2366: 'x_return_status = ' || x_return_status,
2367: p_prefix =>l_debug_prefix,
2368: p_msg_level=>fnd_log.level_statement);
2369: END IF;

Line 2411: hz_utility_v2pub.debug(p_message=>'Another record exist for this style format layout with an overlapping date ranger. Please input a unique combination of style_format_code, variation_number, line_number, position.' ||

2407: NULL;
2408: END;
2409:
2410: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2411: hz_utility_v2pub.debug(p_message=>'Another record exist for this style format layout with an overlapping date ranger. Please input a unique combination of style_format_code, variation_number, line_number, position.' ||
2412: 'x_return_status = ' || x_return_status,
2413: p_prefix =>l_debug_prefix,
2414: p_msg_level=>fnd_log.level_statement);
2415: END IF;

Line 2445: hz_utility_v2pub.debug(p_message=>'Another record exist for this style format layout with an overlapping date ranger. Please input a unique combination of style_format_code, variation_number, line_number, position.' ||

2441: WHEN NO_DATA_FOUND THEN
2442: NULL;
2443: END;
2444: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2445: hz_utility_v2pub.debug(p_message=>'Another record exist for this style format layout with an overlapping date ranger. Please input a unique combination of style_format_code, variation_number, line_number, position.' ||
2446: 'x_return_status = ' || x_return_status,
2447: p_prefix =>l_debug_prefix,
2448: p_msg_level=>fnd_log.level_statement);
2449: END IF;

Line 2459: HZ_UTILITY_V2PUB.validate_mandatory (

2455: ------------------------------------
2456:
2457: -- mandatory_flag is mandatory
2458: IF (p_create_update_flag = 'C') THEN
2459: HZ_UTILITY_V2PUB.validate_mandatory (
2460: p_create_update_flag => p_create_update_flag,
2461: p_column => 'mandatory_flag',
2462: p_column_value => p_style_fmt_layout_rec.mandatory_flag ,
2463: x_return_status => x_return_status);

Line 2466: hz_utility_v2pub.debug(p_message=>'mandatory_flag is mandatory. ' ||

2462: p_column_value => p_style_fmt_layout_rec.mandatory_flag ,
2463: x_return_status => x_return_status);
2464:
2465: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2466: hz_utility_v2pub.debug(p_message=>'mandatory_flag is mandatory. ' ||
2467: 'x_return_status = ' || x_return_status,
2468: p_prefix =>l_debug_prefix,
2469: p_msg_level=>fnd_log.level_statement);
2470: END IF;

Line 2475: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (

2471: END IF;
2472:
2473: -- mandatory_flag cannot be set to null during update
2474: IF p_create_update_flag = 'U' THEN
2475: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (
2476: p_column => 'mandatory_flag',
2477: p_column_value => p_style_fmt_layout_rec.mandatory_flag,
2478: x_return_status => x_return_status);
2479:

Line 2481: hz_utility_v2pub.debug(p_message=>'mandatory_flag cannot be set to null during update. ' ||

2477: p_column_value => p_style_fmt_layout_rec.mandatory_flag,
2478: x_return_status => x_return_status);
2479:
2480: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2481: hz_utility_v2pub.debug(p_message=>'mandatory_flag cannot be set to null during update. ' ||
2482: 'x_return_status = ' || x_return_status,
2483: p_prefix =>l_debug_prefix,
2484: p_msg_level=>fnd_log.level_statement);
2485: END IF;

Line 2491: hz_utility_v2pub.validate_lookup (

2487: END IF;
2488:
2489:
2490: -- mandatory_flag is lookup code in lookup type YES/NO
2491: hz_utility_v2pub.validate_lookup (
2492: p_column => 'mandatory_flag',
2493: p_lookup_type => 'YES/NO',
2494: p_column_value => p_style_fmt_layout_rec.mandatory_flag,
2495: x_return_status => x_return_status);

Line 2498: hz_utility_v2pub.debug(p_message=>'mandatory_flag is lookup code in lookup type YES/NO. ' ||

2494: p_column_value => p_style_fmt_layout_rec.mandatory_flag,
2495: x_return_status => x_return_status);
2496:
2497: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2498: hz_utility_v2pub.debug(p_message=>'mandatory_flag is lookup code in lookup type YES/NO. ' ||
2499: 'x_return_status = ' || x_return_status,
2500: p_prefix =>l_debug_prefix,
2501: p_msg_level=>fnd_log.level_statement);
2502: END IF;

Line 2510: HZ_UTILITY_V2PUB.validate_mandatory (

2506: ------------------------------------
2507:
2508: -- use_initial_flag is mandatory
2509: IF (p_create_update_flag = 'C') THEN
2510: HZ_UTILITY_V2PUB.validate_mandatory (
2511: p_create_update_flag => p_create_update_flag,
2512: p_column => 'use_initial_flag',
2513: p_column_value => p_style_fmt_layout_rec.use_initial_flag ,
2514: x_return_status => x_return_status);

Line 2516: hz_utility_v2pub.debug(p_message=>'use_initial_flag is mandatory. ' ||

2512: p_column => 'use_initial_flag',
2513: p_column_value => p_style_fmt_layout_rec.use_initial_flag ,
2514: x_return_status => x_return_status);
2515: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2516: hz_utility_v2pub.debug(p_message=>'use_initial_flag is mandatory. ' ||
2517: 'x_return_status = ' || x_return_status,
2518: p_prefix =>l_debug_prefix,
2519: p_msg_level=>fnd_log.level_statement);
2520: END IF;

Line 2525: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (

2521: END IF;
2522:
2523: -- use_initial_flag cannot be set to null during update
2524: IF p_create_update_flag = 'U' THEN
2525: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (
2526: p_column => 'use_initial_flag',
2527: p_column_value => p_style_fmt_layout_rec.use_initial_flag,
2528: x_return_status => x_return_status);
2529:

Line 2531: hz_utility_v2pub.debug(p_message=>'use_initial_flag cannot be set to null during update. ' ||

2527: p_column_value => p_style_fmt_layout_rec.use_initial_flag,
2528: x_return_status => x_return_status);
2529:
2530: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2531: hz_utility_v2pub.debug(p_message=>'use_initial_flag cannot be set to null during update. ' ||
2532: 'x_return_status = ' || x_return_status,
2533: p_prefix =>l_debug_prefix,
2534: p_msg_level=>fnd_log.level_statement);
2535: END IF;

Line 2541: hz_utility_v2pub.validate_lookup (

2537: END IF;
2538:
2539:
2540: -- use_initial_flag is lookup code in lookup type YES/NO
2541: hz_utility_v2pub.validate_lookup (
2542: p_column => 'use_initial_flag',
2543: p_lookup_type => 'YES/NO',
2544: p_column_value => p_style_fmt_layout_rec.use_initial_flag,
2545: x_return_status => x_return_status);

Line 2548: hz_utility_v2pub.debug(p_message=>'use_initial_flag is lookup code in lookup type YES/NO. ' ||

2544: p_column_value => p_style_fmt_layout_rec.use_initial_flag,
2545: x_return_status => x_return_status);
2546:
2547: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2548: hz_utility_v2pub.debug(p_message=>'use_initial_flag is lookup code in lookup type YES/NO. ' ||
2549: 'x_return_status = ' || x_return_status,
2550: p_prefix =>l_debug_prefix,
2551: p_msg_level=>fnd_log.level_statement);
2552: END IF;

Line 2560: HZ_UTILITY_V2PUB.validate_mandatory (

2556: ------------------------------------
2557:
2558: -- uppercase_flag is mandatory
2559: IF (p_create_update_flag = 'C') THEN
2560: HZ_UTILITY_V2PUB.validate_mandatory (
2561: p_create_update_flag => p_create_update_flag,
2562: p_column => 'uppercase_flag',
2563: p_column_value => p_style_fmt_layout_rec.uppercase_flag ,
2564: x_return_status => x_return_status);

Line 2567: hz_utility_v2pub.debug(p_message=>'uppercase_flag is mandatory. ' ||

2563: p_column_value => p_style_fmt_layout_rec.uppercase_flag ,
2564: x_return_status => x_return_status);
2565:
2566: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2567: hz_utility_v2pub.debug(p_message=>'uppercase_flag is mandatory. ' ||
2568: 'x_return_status = ' || x_return_status,
2569: p_prefix =>l_debug_prefix,
2570: p_msg_level=>fnd_log.level_statement);
2571: END IF;

Line 2576: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (

2572: END IF;
2573:
2574: -- uppercase_flag cannot be set to null during update
2575: IF p_create_update_flag = 'U' THEN
2576: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (
2577: p_column => 'uppercase_flag',
2578: p_column_value => p_style_fmt_layout_rec.uppercase_flag,
2579: x_return_status => x_return_status);
2580:

Line 2582: hz_utility_v2pub.debug(p_message=>'uppercase_flag cannot be set to null during update. ' ||

2578: p_column_value => p_style_fmt_layout_rec.uppercase_flag,
2579: x_return_status => x_return_status);
2580:
2581: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2582: hz_utility_v2pub.debug(p_message=>'uppercase_flag cannot be set to null during update. ' ||
2583: 'x_return_status = ' || x_return_status,
2584: p_prefix =>l_debug_prefix,
2585: p_msg_level=>fnd_log.level_statement);
2586: END IF;

Line 2592: hz_utility_v2pub.validate_lookup (

2588: END IF;
2589:
2590:
2591: -- uppercase_flag is lookup code in lookup type YES/NO
2592: hz_utility_v2pub.validate_lookup (
2593: p_column => 'uppercase_flag',
2594: p_lookup_type => 'YES/NO',
2595: p_column_value => p_style_fmt_layout_rec.uppercase_flag,
2596: x_return_status => x_return_status);

Line 2599: hz_utility_v2pub.debug(p_message=>'uppercase_flag is lookup code in lookup type YES/NO. ' ||

2595: p_column_value => p_style_fmt_layout_rec.uppercase_flag,
2596: x_return_status => x_return_status);
2597:
2598: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2599: hz_utility_v2pub.debug(p_message=>'uppercase_flag is lookup code in lookup type YES/NO. ' ||
2600: 'x_return_status = ' || x_return_status,
2601: p_prefix =>l_debug_prefix,
2602: p_msg_level=>fnd_log.level_statement);
2603: END IF;

Line 2617: hz_utility_v2pub.debug(p_message=>'blank_lines_after should be > 0.' ||'x_return_status = ' ||

2613: p_column => 'blank_lines_after',
2614: p_column_value => p_style_fmt_layout_rec.blank_lines_after,
2615: x_return_status => x_return_status );
2616: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2617: hz_utility_v2pub.debug(p_message=>'blank_lines_after should be > 0.' ||'x_return_status = ' ||
2618: x_return_status,
2619: p_prefix =>l_debug_prefix,
2620: p_msg_level=>fnd_log.level_statement);
2621: END IF;

Line 2636: hz_utility_v2pub.debug(p_message=>'blank_lines_before should be > 0.' ||'x_return_status = ' ||

2632: p_column_value => p_style_fmt_layout_rec.blank_lines_before,
2633: x_return_status => x_return_status );
2634:
2635: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2636: hz_utility_v2pub.debug(p_message=>'blank_lines_before should be > 0.' ||'x_return_status = ' ||
2637: x_return_status,
2638: p_prefix =>l_debug_prefix,
2639: p_msg_level=>fnd_log.level_statement);
2640: END IF;

Line 2649: HZ_UTILITY_V2PUB.validate_mandatory (

2645: -----------------------------
2646:
2647: -- start_date_active is mandatory
2648: IF (p_create_update_flag = 'C') THEN
2649: HZ_UTILITY_V2PUB.validate_mandatory (
2650: p_create_update_flag => p_create_update_flag,
2651: p_column => 'start_date_active',
2652: p_column_value => p_style_fmt_layout_rec.start_date_active,
2653: x_return_status => x_return_status);

Line 2656: hz_utility_v2pub.debug(p_message=>'start_date_active is mandatory. ' ||

2652: p_column_value => p_style_fmt_layout_rec.start_date_active,
2653: x_return_status => x_return_status);
2654:
2655: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2656: hz_utility_v2pub.debug(p_message=>'start_date_active is mandatory. ' ||
2657: 'x_return_status = ' || x_return_status,
2658: p_prefix =>l_debug_prefix,
2659: p_msg_level=>fnd_log.level_statement);
2660: END IF;

Line 2665: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (

2661: END IF;
2662:
2663: -- start_date_active cannot be set to null during update
2664: IF p_create_update_flag = 'U' THEN
2665: HZ_UTILITY_V2PUB.validate_cannot_update_to_null (
2666: p_column => 'start_date_active',
2667: p_column_value => p_style_fmt_layout_rec.start_date_active,
2668: x_return_status => x_return_status);
2669:

Line 2671: hz_utility_v2pub.debug(p_message=>'start_date_active cannot be set to null during update. ' ||

2667: p_column_value => p_style_fmt_layout_rec.start_date_active,
2668: x_return_status => x_return_status);
2669:
2670: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2671: hz_utility_v2pub.debug(p_message=>'start_date_active cannot be set to null during update. ' ||
2672: 'x_return_status = ' || x_return_status,
2673: p_prefix =>l_debug_prefix,
2674: p_msg_level=>fnd_log.level_statement);
2675: END IF;

Line 2719: hz_utility_v2pub.debug(p_message=>'end_date_active must be null or greater than start date. ' ||

2715: x_return_status := fnd_api.g_ret_sts_error;
2716: END IF;
2717: END IF;
2718: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2719: hz_utility_v2pub.debug(p_message=>'end_date_active must be null or greater than start date. ' ||
2720: 'x_return_status = ' || x_return_status,
2721: p_prefix =>l_debug_prefix,
2722: p_msg_level=>fnd_log.level_statement);
2723: END IF;

Line 2726: hz_utility_v2pub.debug(p_message=>'validate_style_fmt_layout (+)',

2722: p_msg_level=>fnd_log.level_statement);
2723: END IF;
2724:
2725: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2726: hz_utility_v2pub.debug(p_message=>'validate_style_fmt_layout (+)',
2727: p_prefix=>l_debug_prefix,
2728: p_msg_level=>fnd_log.level_procedure);
2729: END IF;
2730: