[Home] [Help]
74:
75: --
76: -- validate database item names.
77: --
78: ffdict.validate_dbitem
79: (p_dbi_name => l_user_name
80: ,p_user_entity_id => x_user_entity_id
81: );
82:
81: );
82:
83: l_translated_user_name := upper(x_translated_user_name);
84: if l_translated_user_name <> l_user_name then
85: ffdict.validate_tl_dbi
86: (p_user_name => l_user_name
87: ,p_user_entity_id => x_user_entity_id
88: ,p_tl_user_name => l_translated_user_name
89: );
226: --
227: -- All instances of this name will be overwritten. Check whether or
228: -- not the name is referenced in any formulas.
229: --
230: if ffdict.dbitl_used_in_formula
231: (p_tl_user_name => crec.translated_user_name
232: ,p_user_name => x_user_name
233: ,p_user_entity_id => x_user_entity_id
234: ,p_language => null
295: --
296: -- Pass compared name to FETCH_REFERENCING_FORMULAS. Note: X_OLD_TL_NAME
297: -- is used if NOT NULL.
298: --
299: ffdict.fetch_referencing_formulas
300: (p_tl_user_name => nvl(x_old_tl_name, x_tl_user_name)
301: ,p_user_name => x_user_name
302: ,p_user_entity_id => x_user_entity_id
303: ,p_language => x_language
494: begin
495: l_debug := hr_utility.debug_enabled;
496:
497: if l_debug then
498: hr_utility.set_location('ffdict.core_update_tl_rows',10);
499: end if;
500:
501: --
502: -- Always raise errors for non-seeded update.
517: -- Validate the proposed translated database item name. --
518: ----------------------------------------------------------
519: if l_raise_errors then
520: if l_debug then
521: hr_utility.set_location('ffdict.core_update_tl_rows',20);
522: end if;
523:
524: ffdict.validate_tl_dbi
525: (p_user_name => l_user_name
520: if l_debug then
521: hr_utility.set_location('ffdict.core_update_tl_rows',20);
522: end if;
523:
524: ffdict.validate_tl_dbi
525: (p_user_name => l_user_name
526: ,p_user_entity_id => x_user_entity_id
527: ,p_tl_user_name => l_tl_user_name
528: );
527: ,p_tl_user_name => l_tl_user_name
528: );
529: else
530: if l_debug then
531: hr_utility.set_location('ffdict.core_update_tl_rows',30);
532: end if;
533:
534: ffdict.core_validate_tl_dbitem
535: (p_user_name => l_user_name
530: if l_debug then
531: hr_utility.set_location('ffdict.core_update_tl_rows',30);
532: end if;
533:
534: ffdict.core_validate_tl_dbitem
535: (p_user_name => l_user_name
536: ,p_user_entity_id => x_user_entity_id
537: ,p_tl_user_name => l_tl_user_name
538: ,p_outcome => l_outcome
555: ,p_message_text => l_encoded_message
556: );
557:
558: if l_debug then
559: hr_utility.set_location('ffdict.core_update_tl_rows',35);
560: end if;
561:
562: x_got_error := true;
563: return;
563: return;
564: end if;
565:
566: if l_debug then
567: hr_utility.set_location('ffdict.core_update_tl_rows',40);
568: end if;
569:
570: --
571: -- New DB item name cannot be same as existing context name.
583: ,p_message_text => l_encoded_message
584: );
585:
586: if l_debug then
587: hr_utility.set_location('ffdict.core_update_tl_rows',45);
588: end if;
589:
590: x_got_error := true;
591: return;
591: return;
592: end if;
593:
594: if l_debug then
595: hr_utility.set_location('ffdict.core_update_tl_rows',50);
596: end if;
597:
598: --
599: -- New DB item name cannot be same as existing item in any verified
622: (p_rowids => l_message_rowids
623: );
624:
625: if l_debug then
626: hr_utility.set_location('ffdict.core_update_tl_rows',55);
627: end if;
628:
629: x_got_error := true;
630: return;
631: end if;
632: end if;
633:
634: if l_debug then
635: hr_utility.set_location('ffdict.core_update_tl_rows',60);
636: end if;
637: end if;
638:
639: -----------------------------------------------------------------------
644: --
645: -- This test always needs to be performed.
646: --
647: if l_debug then
648: hr_utility.set_location('ffdict.core_update_tl_rows',70);
649: end if;
650:
651: --
652: -- Verify that the existing names aren't used in any formulas.
661:
662: if l_replaced_names.count <> 0 then
663: if l_raise_errors then
664: if l_debug then
665: hr_utility.set_location('ffdict.core_update_tl_rows',75);
666: end if;
667:
668: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
669: hr_utility.set_message_token('1', l_replaced_names(1));
696: (p_rowids => l_message_rowids
697: );
698:
699: if l_debug then
700: hr_utility.set_location('ffdict.core_update_tl_rows',85);
701: end if;
702:
703: x_got_error := true;
704: return;
706: end if;
707: end if;
708:
709: if l_debug then
710: hr_utility.set_location('ffdict.core_update_tl_rows',90);
711: end if;
712:
713: ----------------------------------
714: -- Update the translated value. --
738: --
739: ff_database_items_pkg.g_disable_triggers := l_disable_triggers;
740:
741: if l_debug then
742: hr_utility.set_location('ffdict.core_update_tl_rows',200);
743: end if;
744:
745: exception
746: when others then
745: exception
746: when others then
747:
748: if l_debug then
749: hr_utility.set_location('ffdict.core_update_tl_rows',500);
750: end if;
751:
752: --
753: -- Reset the trigger code.
877: --
878: -- Verify that the new name isn't going to clash with anything.
879: --
880: l_tl_name := x_translated_user_name;
881: ffdict.validate_tl_dbi
882: (p_user_name => l_user_name
883: ,p_user_entity_id => x_user_entity_id
884: ,p_tl_user_name => l_tl_name
885: );
911: l_found := csr_name_remains%found;
912: close csr_name_remains;
913:
914: if not l_found and
915: ffdict.dbitl_used_in_formula
916: (p_tl_user_name => l_old_tl_name
917: ,p_user_name => l_user_name
918: ,p_user_entity_id => x_user_entity_id
919: ,p_language => x_language
1006: fetch csr_update_base into l_update;
1007: close csr_update_base;
1008:
1009: if l_update = 'Y' then
1010: if ffdict.dbi_used_in_formula(l_user_name, x_user_entity_id) then
1011: hr_utility.set_message(802,'FF75_ITEM_USED_IN_FORMULA');
1012: hr_utility.set_message_token('1',x_user_name);
1013: hr_utility.raise_error;
1014: end if;
1103: l_user_name varchar2(2000);
1104: begin
1105: l_user_name := upper(x_user_name);
1106:
1107: ffdict.delete_dbitem_check
1108: (p_item_name => l_user_name
1109: ,p_user_entity_id => x_user_entity_id
1110: );
1111: