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 FND_LOG

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

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

Line 235: p_msg_level=>fnd_log.level_procedure);

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:
238: -- select columns needed to be checked from table during update
239:

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

261: p_column => 'style_code',
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);

Line 269: p_msg_level=>fnd_log.level_statement);

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;
271: END IF;
272:
273: -- style_code is non-updateable field

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

279: p_column_value => p_style_rec.style_code,
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);

Line 287: p_msg_level=>fnd_log.level_statement);

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;
289: END IF;
290:
291: -- style_code is unique

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

306: WHEN NO_DATA_FOUND THEN
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);

Line 314: p_msg_level=>fnd_log.level_statement);

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;
316: END IF;
317:
318: --------------------------------------

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

326: p_column => 'database_object_name',
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);

Line 334: p_msg_level=>fnd_log.level_statement);

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;
336: END IF;
337:
338: -- database_object_name is non-updateable field

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

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

Line 352: p_msg_level=>fnd_log.level_statement);

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;
354: END IF;
355:
356: -- database_object_name has foreign key fnd_tables.table_name

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

374: fnd_msg_pub.add;
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);

Line 382: p_msg_level=>fnd_log.level_statement);

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;
384: END IF;
385:
386: -----------------------------

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

394: p_column => 'style_name',
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);

Line 402: p_msg_level=>fnd_log.level_statement);

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;
404: END IF;
405:
406: -- style_name cannot be set to null during update

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

409: p_column => 'style_name',
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);

Line 417: p_msg_level=>fnd_log.level_statement);

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;
419:
420: END IF;
421:

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

438: EXCEPTION
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);

Line 446: p_msg_level=>fnd_log.level_statement);

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;
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 (-)',

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

445: p_prefix =>l_debug_prefix,
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;

Line 452: p_msg_level=>fnd_log.level_procedure);

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:
455: --disable_debug;
456:

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

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

Line 513: p_msg_level=>fnd_log.level_procedure);

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:
516: -- select columns needed to be checked from table during update
517:

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

542: p_column => 'style_format_code',
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);

Line 550: p_msg_level=>fnd_log.level_statement);

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;
552: END IF;
553:
554: -- style_format_code is non-updateable field

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

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

Line 569: p_msg_level=>fnd_log.level_statement);

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;
571: END IF;
572:
573: -- l_style_format_code is unique

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

588: WHEN NO_DATA_FOUND THEN
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);

Line 596: p_msg_level=>fnd_log.level_statement);

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;
598: END IF;
599:
600: -----------------------------

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

608: p_column => 'style_code',
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);

Line 616: p_msg_level=>fnd_log.level_statement);

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;
618: END IF;
619:
620: -- style_code is non-updateable field

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

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

Line 634: p_msg_level=>fnd_log.level_statement);

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;
636: END IF;
637:
638: -- style_code is foreign key of hz_styles_b

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

658: fnd_msg_pub.add;
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);

Line 666: p_msg_level=>fnd_log.level_statement);

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;
668: END IF;
669:
670: -----------------------------

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

679: p_column_value => p_style_format_rec.default_flag,
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);

Line 687: p_msg_level=>fnd_log.level_statement);

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;
689: END IF;
690:
691: -- default_flag is lookup code in lookup type YES/NO

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

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

Line 702: p_msg_level=>fnd_log.level_statement);

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;
704:
705: -- default_flag cannot be set to null during update
706: IF p_create_update_flag = 'U' THEN

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

708: p_column => 'default_flag',
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);

Line 716: p_msg_level=>fnd_log.level_statement);

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;
718:
719: END IF;
720:

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

726: fnd_message.set_name('AR', 'HZ_STL_FMT_FLAG_NOT_Y_TO_N');
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);

Line 734: p_msg_level=>fnd_log.level_statement);

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;
736:
737: END IF;
738: -----------------------------

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

746: p_column => 'style_format_name',
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);

Line 754: p_msg_level=>fnd_log.level_statement);

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;
756: END IF;
757:
758: -- style_format_name cannot be set to null during update

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

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

Line 769: p_msg_level=>fnd_log.level_statement);

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;
771:
772: END IF;
773:

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

791: WHEN NO_DATA_FOUND THEN
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);

Line 799: p_msg_level=>fnd_log.level_statement);

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;
801: END IF;
802:
803: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

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

Line 806: p_msg_level=>fnd_log.level_procedure);

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:
809: --disable_debug;
810: END validate_style_format;

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

869: BEGIN
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;

Line 876: p_msg_level=>fnd_log.level_procedure);

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:
879: -- select columns needed to be checked from table during update
880:

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

917: fnd_msg_pub.add;
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);

Line 925: p_msg_level=>fnd_log.level_statement);

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;
927: END IF;
928: END IF;
929:

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

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

Line 934: p_msg_level=>fnd_log.level_statement);

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;
936:
937: -----------------------------
938: -- validate style_format_code

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

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

Line 954: p_msg_level=>fnd_log.level_statement);

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;
956: END IF;
957:
958: -- style_format_code is non-updateable field

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

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

Line 972: p_msg_level=>fnd_log.level_statement);

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;
974: END IF;
975:
976: -- style_format_code is foreign key of hz_style_formats_b

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

996: fnd_message.set_token('TABLE', '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);

Line 1004: p_msg_level=>fnd_log.level_statement);

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;
1006: END IF;
1007:
1008: -----------------------------

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

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

Line 1027: p_msg_level=>fnd_log.level_statement);

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;
1029: END IF;
1030:
1031: -- language_code is foreign key of fnd_languages

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

1050: fnd_message.set_token('TABLE', '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);

Line 1058: p_msg_level=>fnd_log.level_statement);

1054: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1055: hz_utility_v2pub.debug(p_message=>'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;
1060: END IF;
1061:
1062: -----------------------------

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

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

Line 1081: p_msg_level=>fnd_log.level_statement);

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;
1083: END IF;
1084:
1085: -- territory_code is foreign key of fnd_territories

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

1104: fnd_message.set_token('TABLE', '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);

Line 1112: p_msg_level=>fnd_log.level_statement);

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;
1114: END IF;
1115:
1116: -------------------------------------------------------------

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

1127: FND_MESSAGE.SET_NAME('AR', 'HZ_STL_FMT_LOC_MISSING_COLUMN');
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);

Line 1135: p_msg_level=>fnd_log.level_statement);

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;
1137:
1138: END IF;
1139:

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

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

Line 1157: p_msg_level=>fnd_log.level_statement);

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;
1159: END IF;
1160:
1161: -- start_date_active cannot be set to null during update

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

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

Line 1172: p_msg_level=>fnd_log.level_statement);

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;
1174:
1175: END IF;
1176:

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

1212: fnd_msg_pub.add;
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);

Line 1220: p_msg_level=>fnd_log.level_statement);

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;
1222:
1223: --------------------------------------------------------------------------------------------------
1224: -- style_format_code, language_code, territory_code validation, start_date_active, end_date_active

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

1253: WHEN NO_DATA_FOUND THEN
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);

Line 1261: p_msg_level=>fnd_log.level_statement);

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;
1263:
1264: ELSIF p_create_update_flag = 'U' AND
1265: (p_style_fmt_locale_rec.start_date_active is not null OR

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

1296: WHEN NO_DATA_FOUND THEN
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);

Line 1304: p_msg_level=>fnd_log.level_statement);

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;
1306:
1307:
1308: END IF;

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

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

Line 1313: p_msg_level=>fnd_log.level_procedure);

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:
1316: --disable_debug;
1317: END validate_style_fmt_locale;

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

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

Line 1373: p_msg_level=>fnd_log.level_procedure);

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:
1376: -- select columns needed to be checked from table during update
1377:

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

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

Line 1411: p_msg_level=>fnd_log.level_statement);

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;
1413: END IF;
1414:
1415: -- style_format_code is non-updateable field

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

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

Line 1430: p_msg_level=>fnd_log.level_statement);

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;
1432: END IF;
1433:
1434: -- style_format_code is foreign key of hz_style_formats_b

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

1453: fnd_message.set_token('TABLE', '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);

Line 1461: p_msg_level=>fnd_log.level_statement);

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;
1463: END IF;
1464:
1465: -----------------------------

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

1473: p_column => 'variation_number',
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);

Line 1481: p_msg_level=>fnd_log.level_statement);

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;
1483: END IF;
1484:
1485: -- variation_number is non-updateable field

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

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

Line 1500: p_msg_level=>fnd_log.level_statement);

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;
1502: END IF;
1503:
1504: -- The combanition of variation_number style_format_code is unique

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

1518: WHEN NO_DATA_FOUND THEN
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);

Line 1526: p_msg_level=>fnd_log.level_statement);

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;
1528: END IF;
1529:
1530: -- variation_number should be > 0

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

1535: p_column => 'variation_number',
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);

Line 1543: p_msg_level=>fnd_log.level_statement);

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;
1545: END IF;
1546:
1547:

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

1556: p_column => 'variation_rank',
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);

Line 1564: p_msg_level=>fnd_log.level_statement);

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;
1566: END IF;
1567:
1568: -- variation_rank is unique within style_format_code

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

1585: WHEN NO_DATA_FOUND THEN
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);

Line 1593: p_msg_level=>fnd_log.level_statement);

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;
1595: END IF;
1596:
1597: -- variation_rank cannot be set to null during update

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

1600: p_column => 'variation_rank',
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);

Line 1608: p_msg_level=>fnd_log.level_statement);

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;
1610:
1611: END IF;
1612:

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

1621: check_greater_than_zero (
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);

Line 1629: p_msg_level=>fnd_log.level_statement);

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;
1631: END IF;
1632:
1633: -----------------------------

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

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

Line 1649: p_msg_level=>fnd_log.level_statement);

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;
1651: END IF;
1652:
1653: -- start_date_active cannot be set to null during update

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

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

Line 1664: p_msg_level=>fnd_log.level_statement);

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;
1666:
1667: END IF;
1668:

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

1705: x_return_status := fnd_api.g_ret_sts_error;
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);

Line 1713: p_msg_level=>fnd_log.level_statement);

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;
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 (+)',

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

1712: p_prefix =>l_debug_prefix,
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;

Line 1719: p_msg_level=>fnd_log.level_procedure);

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:
1722: --disable_debug;
1723:

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

1792: BEGIN
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;

Line 1799: p_msg_level=>fnd_log.level_procedure);

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:
1802: -- select columns needed to be checked from table during update
1803:

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

1863: fnd_msg_pub.add;
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);

Line 1871: p_msg_level=>fnd_log.level_statement);

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;
1873: END IF;
1874: END IF;
1875:

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

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

Line 1880: p_msg_level=>fnd_log.level_statement);

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;
1882:
1883: -----------------------------
1884: -- validate style_format_code

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

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

Line 1899: p_msg_level=>fnd_log.level_statement);

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;
1901: END IF;
1902:
1903: -- style_format_code is non-updateable field

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

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

Line 1918: p_msg_level=>fnd_log.level_statement);

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;
1920: END IF;
1921:
1922: -----------------------------

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

1930: p_column => 'variation_number',
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);

Line 1938: p_msg_level=>fnd_log.level_statement);

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;
1940: END IF;
1941:
1942: -- variation_number is non-updateable field

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

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

Line 1957: p_msg_level=>fnd_log.level_statement);

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;
1959: END IF;
1960:
1961: -- variation_number should be > 0

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

1966: p_column => 'variation_number',
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);

Line 1974: p_msg_level=>fnd_log.level_statement);

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;
1976: END IF;
1977:
1978: ---------------------------------------------------------------------

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

2014: fnd_message.set_name('AR', 'HZ_LYT_INVALID_START_END_DATE');
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);

Line 2022: p_msg_level=>fnd_log.level_statement);

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;
2024:
2025: EXCEPTION
2026: WHEN NO_DATA_FOUND THEN

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

2028: fnd_message.set_token('VARNUM', p_style_fmt_layout_rec.variation_number);
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);

Line 2036: p_msg_level=>fnd_log.level_statement);

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;
2038:
2039: ELSIF p_create_update_flag = 'U' AND
2040: x_return_status = fnd_api.g_ret_sts_success

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

2057: fnd_message.set_name('AR', 'HZ_LYT_INVALID_START_END_DATE');
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);

Line 2065: p_msg_level=>fnd_log.level_statement);

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;
2067:
2068: END IF;
2069:

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

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

Line 2086: p_msg_level=>fnd_log.level_statement);

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;
2088: END IF;
2089:
2090: -- attribute_code is non-updateable field

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

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

Line 2105: p_msg_level=>fnd_log.level_statement);

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;
2107: END IF;
2108:
2109: ------------------------------------

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

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

Line 2125: p_msg_level=>fnd_log.level_statement);

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;
2127: END IF;
2128:
2129: -- attribute_application_id is non-updateable field

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

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

Line 2143: p_msg_level=>fnd_log.level_statement);

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;
2145: END IF;
2146:
2147: -----------------------------------------------------

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

2179: fnd_message.SET_TOKEN('TABLE',l_database_object_name);
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,

Line 2188: p_msg_level=>fnd_log.level_statement);

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);
2189: END IF;
2190: END IF;
2191:
2192: -------------------------------------------------------------------------------------------

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

2225: WHEN NO_DATA_FOUND THEN
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);

Line 2233: p_msg_level=>fnd_log.level_statement);

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;
2235:
2236: ELSIF p_create_update_flag = 'U' AND
2237: (p_style_fmt_layout_rec.start_date_active is not null OR

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

2259: EXCEPTION
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);

Line 2267: p_msg_level=>fnd_log.level_statement);

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;
2269:
2270: END IF;
2271:

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

2280: p_column => 'line_number ',
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);

Line 2288: p_msg_level=>fnd_log.level_statement);

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;
2290: END IF;
2291:
2292: -- line_number should be > 0

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

2296: check_greater_than_zero (
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);

Line 2304: p_msg_level=>fnd_log.level_statement);

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;
2306: END IF;
2307:
2308: -- line_number cannot be set to null during update

Line 2314: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level 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
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);

Line 2318: p_msg_level=>fnd_log.level_statement);

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;
2320:
2321: END IF;
2322:

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

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

Line 2338: p_msg_level=>fnd_log.level_statement);

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;
2340: END IF;
2341:
2342: -- position should be > 0

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

2346: check_greater_than_zero (
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);

Line 2354: p_msg_level=>fnd_log.level_statement);

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;
2356: END IF;
2357:
2358: -- position cannot be set to null during update

Line 2364: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level 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
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);

Line 2368: p_msg_level=>fnd_log.level_statement);

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;
2370:
2371: END IF;
2372:

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

2406: WHEN NO_DATA_FOUND THEN
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);

Line 2414: p_msg_level=>fnd_log.level_statement);

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;
2416:
2417: ELSIF p_create_update_flag = 'U' AND
2418: (p_style_fmt_layout_rec.start_date_active is not null OR

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

2440: EXCEPTION
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);

Line 2448: p_msg_level=>fnd_log.level_statement);

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;
2450:
2451: END IF;
2452:

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

2461: p_column => 'mandatory_flag',
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);

Line 2469: p_msg_level=>fnd_log.level_statement);

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;
2471: END IF;
2472:
2473: -- mandatory_flag cannot be set to null during update

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

2476: p_column => 'mandatory_flag',
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);

Line 2484: p_msg_level=>fnd_log.level_statement);

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;
2486:
2487: END IF;
2488:

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

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

Line 2501: p_msg_level=>fnd_log.level_statement);

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;
2503:
2504: ------------------------------------
2505: -- validate use_initial_flag

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

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

Line 2519: p_msg_level=>fnd_log.level_statement);

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;
2521: END IF;
2522:
2523: -- use_initial_flag cannot be set to null during update

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

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

Line 2534: p_msg_level=>fnd_log.level_statement);

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;
2536:
2537: END IF;
2538:

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

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

Line 2551: p_msg_level=>fnd_log.level_statement);

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;
2553:
2554: ------------------------------------
2555: -- validate uppercase_flag

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

2562: p_column => 'uppercase_flag',
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);

Line 2570: p_msg_level=>fnd_log.level_statement);

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;
2572: END IF;
2573:
2574: -- uppercase_flag cannot be set to null during update

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

2577: p_column => 'uppercase_flag',
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);

Line 2585: p_msg_level=>fnd_log.level_statement);

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;
2587:
2588: END IF;
2589:

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

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

Line 2602: p_msg_level=>fnd_log.level_statement);

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;
2604:
2605: ------------------------------------
2606: -- validate blank_lines_before

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

2612: check_greater_than_zero (
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);

Line 2620: p_msg_level=>fnd_log.level_statement);

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;
2622: END IF;
2623:
2624: ------------------------------------

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

2631: p_column => 'blank_lines_before',
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);

Line 2639: p_msg_level=>fnd_log.level_statement);

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;
2641: END IF;
2642:
2643: -----------------------------

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

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

Line 2659: p_msg_level=>fnd_log.level_statement);

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;
2661: END IF;
2662:
2663: -- start_date_active cannot be set to null during update

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

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

Line 2674: p_msg_level=>fnd_log.level_statement);

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;
2676:
2677: END IF;
2678:

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

2714: fnd_msg_pub.add;
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);

Line 2722: p_msg_level=>fnd_log.level_statement);

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;
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 (+)',

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

2721: p_prefix =>l_debug_prefix,
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;

Line 2728: p_msg_level=>fnd_log.level_procedure);

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:
2731:
2732: --disable_debug;