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.PAY_KR_ENTRIES_PKG dependencies on HR_UTILITY

Line 16: g_debug boolean := hr_utility.debug_enabled;

12: g_old_rec pay_element_entries_f%ROWTYPE;
13:
14: -- Global package name
15: g_package varchar2(33) := ' pay_kr_entries_pkg.';
16: g_debug boolean := hr_utility.debug_enabled;
17:
18:
19: -- ---------------------------------------------------------------------
20: -- |------------------------< calc_age >-------------------------------|

Line 185: hr_utility.set_message(801,'HR_7478_PLK_INCONSISTENT_ELE');

181: --
182: -- When not found, raise error.
183: --
184: if l_elm_rec.element_type_id is NULL then
185: hr_utility.set_message(801,'HR_7478_PLK_INCONSISTENT_ELE');
186: hr_utility.set_message_token('ELEMENT_TYPE_ID',NULL);
187: hr_utility.set_message_token('ELEMENT_NAME',
188: p_elm_code_tbl(l_index));
189: hr_utility.raise_error;

Line 186: hr_utility.set_message_token('ELEMENT_TYPE_ID',NULL);

182: -- When not found, raise error.
183: --
184: if l_elm_rec.element_type_id is NULL then
185: hr_utility.set_message(801,'HR_7478_PLK_INCONSISTENT_ELE');
186: hr_utility.set_message_token('ELEMENT_TYPE_ID',NULL);
187: hr_utility.set_message_token('ELEMENT_NAME',
188: p_elm_code_tbl(l_index));
189: hr_utility.raise_error;
190: else

Line 187: hr_utility.set_message_token('ELEMENT_NAME',

183: --
184: if l_elm_rec.element_type_id is NULL then
185: hr_utility.set_message(801,'HR_7478_PLK_INCONSISTENT_ELE');
186: hr_utility.set_message_token('ELEMENT_TYPE_ID',NULL);
187: hr_utility.set_message_token('ELEMENT_NAME',
188: p_elm_code_tbl(l_index));
189: hr_utility.raise_error;
190: else
191: p_elm_rec_tbl(l_elm_rec.element_type_id).element_code

Line 189: hr_utility.raise_error;

185: hr_utility.set_message(801,'HR_7478_PLK_INCONSISTENT_ELE');
186: hr_utility.set_message_token('ELEMENT_TYPE_ID',NULL);
187: hr_utility.set_message_token('ELEMENT_NAME',
188: p_elm_code_tbl(l_index));
189: hr_utility.raise_error;
190: else
191: p_elm_rec_tbl(l_elm_rec.element_type_id).element_code
192: := p_elm_code_tbl(l_index);
193: p_elm_rec_tbl(l_elm_rec.element_type_id).input_currency_code

Line 366: hr_utility.set_message(801,'HR_7027_ELE_ENTRY_EL_NOT_EXST');

362: p_assignment_id => p_assignment_id,
363: p_element_type_id => l_element_type_id,
364: p_session_date => p_effective_date);
365: if p_element_link_id is NULL then
366: hr_utility.set_message(801,'HR_7027_ELE_ENTRY_EL_NOT_EXST');
367: hr_utility.set_message_token('DATE',
368: fnd_date.date_to_displaydate(p_effective_date));
369: hr_utility.raise_error;
370: end if;

Line 367: hr_utility.set_message_token('DATE',

363: p_element_type_id => l_element_type_id,
364: p_session_date => p_effective_date);
365: if p_element_link_id is NULL then
366: hr_utility.set_message(801,'HR_7027_ELE_ENTRY_EL_NOT_EXST');
367: hr_utility.set_message_token('DATE',
368: fnd_date.date_to_displaydate(p_effective_date));
369: hr_utility.raise_error;
370: end if;
371: --

Line 369: hr_utility.raise_error;

365: if p_element_link_id is NULL then
366: hr_utility.set_message(801,'HR_7027_ELE_ENTRY_EL_NOT_EXST');
367: hr_utility.set_message_token('DATE',
368: fnd_date.date_to_displaydate(p_effective_date));
369: hr_utility.raise_error;
370: end if;
371: --
372: -- At first, checks whether the entry is available.
373: --

Line 574: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

570: open csr_iv;
571: fetch csr_iv into l_rec;
572: if csr_iv%NOTFOUND then
573: close csr_iv;
574: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
575: hr_utility.set_message_token('PROCEDURE','hr_entry.check_format');
576: hr_utility.set_message_token('STEP','1');
577: hr_utility.raise_error;
578: end If;

Line 575: hr_utility.set_message_token('PROCEDURE','hr_entry.check_format');

571: fetch csr_iv into l_rec;
572: if csr_iv%NOTFOUND then
573: close csr_iv;
574: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
575: hr_utility.set_message_token('PROCEDURE','hr_entry.check_format');
576: hr_utility.set_message_token('STEP','1');
577: hr_utility.raise_error;
578: end If;
579: close csr_iv;

Line 576: hr_utility.set_message_token('STEP','1');

572: if csr_iv%NOTFOUND then
573: close csr_iv;
574: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
575: hr_utility.set_message_token('PROCEDURE','hr_entry.check_format');
576: hr_utility.set_message_token('STEP','1');
577: hr_utility.raise_error;
578: end If;
579: close csr_iv;
580: --

Line 577: hr_utility.raise_error;

573: close csr_iv;
574: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
575: hr_utility.set_message_token('PROCEDURE','hr_entry.check_format');
576: hr_utility.set_message_token('STEP','1');
577: hr_utility.raise_error;
578: end If;
579: close csr_iv;
580: --
581: -- When user entered value is NULL.

Line 592: hr_utility.set_message(801,'HR_6127_ELE_ENTRY_VALUE_MAND');

588: --
589: -- When not hot defaulted.
590: --
591: if l_rec.hot_default_flag = 'N' then
592: hr_utility.set_message(801,'HR_6127_ELE_ENTRY_VALUE_MAND');
593: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);
594: hr_utility.raise_error;
595: end if;
596: --

Line 593: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);

589: -- When not hot defaulted.
590: --
591: if l_rec.hot_default_flag = 'N' then
592: hr_utility.set_message(801,'HR_6127_ELE_ENTRY_VALUE_MAND');
593: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);
594: hr_utility.raise_error;
595: end if;
596: --
597: -- When hot defaulted.

Line 594: hr_utility.raise_error;

590: --
591: if l_rec.hot_default_flag = 'N' then
592: hr_utility.set_message(801,'HR_6127_ELE_ENTRY_VALUE_MAND');
593: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);
594: hr_utility.raise_error;
595: end if;
596: --
597: -- When hot defaulted.
598: --

Line 600: hr_utility.set_message(801,'HR_6128_ELE_ENTRY_MAND_HOT');

596: --
597: -- When hot defaulted.
598: --
599: if l_rec.default_value is NULL then
600: hr_utility.set_message(801,'HR_6128_ELE_ENTRY_MAND_HOT');
601: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);
602: hr_utility.raise_error;
603: end if;
604:

Line 601: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);

597: -- When hot defaulted.
598: --
599: if l_rec.default_value is NULL then
600: hr_utility.set_message(801,'HR_6128_ELE_ENTRY_MAND_HOT');
601: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);
602: hr_utility.raise_error;
603: end if;
604:
605: p_canonical_value := l_rec.default_value;

Line 602: hr_utility.raise_error;

598: --
599: if l_rec.default_value is NULL then
600: hr_utility.set_message(801,'HR_6128_ELE_ENTRY_MAND_HOT');
601: hr_utility.set_message_token('INPUT_VALUE_NAME',l_rec.name);
602: hr_utility.raise_error;
603: end if;
604:
605: p_canonical_value := l_rec.default_value;
606: hr_chkfmt.changeformat(

Line 640: hr_utility.set_message(801,'PAY_6306_INPUT_VALUE_FORMAT');

636: -- In case the value input is incorrect format.
637: --
638: when others then
639: l_d_uom := hr_general.decode_lookup('UNITS',l_rec.uom);
640: hr_utility.set_message(801,'PAY_6306_INPUT_VALUE_FORMAT');
641: hr_utility.set_message_token('UNIT_OF_MEASURE',l_d_uom);
642: hr_utility.raise_error;
643: end;
644: --

Line 641: hr_utility.set_message_token('UNIT_OF_MEASURE',l_d_uom);

637: --
638: when others then
639: l_d_uom := hr_general.decode_lookup('UNITS',l_rec.uom);
640: hr_utility.set_message(801,'PAY_6306_INPUT_VALUE_FORMAT');
641: hr_utility.set_message_token('UNIT_OF_MEASURE',l_d_uom);
642: hr_utility.raise_error;
643: end;
644: --
645: -- Format min_value and max_value for output parameters.

Line 642: hr_utility.raise_error;

638: when others then
639: l_d_uom := hr_general.decode_lookup('UNITS',l_rec.uom);
640: hr_utility.set_message(801,'PAY_6306_INPUT_VALUE_FORMAT');
641: hr_utility.set_message_token('UNIT_OF_MEASURE',l_d_uom);
642: hr_utility.raise_error;
643: end;
644: --
645: -- Format min_value and max_value for output parameters.
646: -- These parameters should be used for message only.

Line 672: hr_utility.set_message(801,'PAY_KR_INPUTV_MIN_WARN');

668: -- to user with fnd_message.warn procedure.
669: --
670: if l_min_max_status = 'F' and l_rec.warning_or_error = 'E' then
671: if l_rec.max_value is NULL then
672: hr_utility.set_message(801,'PAY_KR_INPUTV_MIN_WARN');
673: hr_utility.set_message_token('MIN_VALUE',p_user_min_value);
674: hr_utility.raise_error;
675: end if;
676: if l_rec.min_value is NULL then

Line 673: hr_utility.set_message_token('MIN_VALUE',p_user_min_value);

669: --
670: if l_min_max_status = 'F' and l_rec.warning_or_error = 'E' then
671: if l_rec.max_value is NULL then
672: hr_utility.set_message(801,'PAY_KR_INPUTV_MIN_WARN');
673: hr_utility.set_message_token('MIN_VALUE',p_user_min_value);
674: hr_utility.raise_error;
675: end if;
676: if l_rec.min_value is NULL then
677: hr_utility.set_message(801,'PAY_KR_INPUTV_MAX_WARN');

Line 674: hr_utility.raise_error;

670: if l_min_max_status = 'F' and l_rec.warning_or_error = 'E' then
671: if l_rec.max_value is NULL then
672: hr_utility.set_message(801,'PAY_KR_INPUTV_MIN_WARN');
673: hr_utility.set_message_token('MIN_VALUE',p_user_min_value);
674: hr_utility.raise_error;
675: end if;
676: if l_rec.min_value is NULL then
677: hr_utility.set_message(801,'PAY_KR_INPUTV_MAX_WARN');
678: hr_utility.set_message_token('MAX_VALUE',p_user_max_value);

Line 677: hr_utility.set_message(801,'PAY_KR_INPUTV_MAX_WARN');

673: hr_utility.set_message_token('MIN_VALUE',p_user_min_value);
674: hr_utility.raise_error;
675: end if;
676: if l_rec.min_value is NULL then
677: hr_utility.set_message(801,'PAY_KR_INPUTV_MAX_WARN');
678: hr_utility.set_message_token('MAX_VALUE',p_user_max_value);
679: hr_utility.raise_error;
680: end if;
681: hr_utility.set_message(801,'HR_ELE_ENTRY_MIN_MAX_WARN');

Line 678: hr_utility.set_message_token('MAX_VALUE',p_user_max_value);

674: hr_utility.raise_error;
675: end if;
676: if l_rec.min_value is NULL then
677: hr_utility.set_message(801,'PAY_KR_INPUTV_MAX_WARN');
678: hr_utility.set_message_token('MAX_VALUE',p_user_max_value);
679: hr_utility.raise_error;
680: end if;
681: hr_utility.set_message(801,'HR_ELE_ENTRY_MIN_MAX_WARN');
682: hr_utility.set_message_token('MIN_VALUE',p_user_min_value);

Line 679: hr_utility.raise_error;

675: end if;
676: if l_rec.min_value is NULL then
677: hr_utility.set_message(801,'PAY_KR_INPUTV_MAX_WARN');
678: hr_utility.set_message_token('MAX_VALUE',p_user_max_value);
679: hr_utility.raise_error;
680: end if;
681: hr_utility.set_message(801,'HR_ELE_ENTRY_MIN_MAX_WARN');
682: hr_utility.set_message_token('MIN_VALUE',p_user_min_value);
683: hr_utility.set_message_token('MAX_VALUE',p_user_max_value);

Line 681: hr_utility.set_message(801,'HR_ELE_ENTRY_MIN_MAX_WARN');

677: hr_utility.set_message(801,'PAY_KR_INPUTV_MAX_WARN');
678: hr_utility.set_message_token('MAX_VALUE',p_user_max_value);
679: hr_utility.raise_error;
680: end if;
681: hr_utility.set_message(801,'HR_ELE_ENTRY_MIN_MAX_WARN');
682: hr_utility.set_message_token('MIN_VALUE',p_user_min_value);
683: hr_utility.set_message_token('MAX_VALUE',p_user_max_value);
684: hr_utility.raise_error;
685: end if;

Line 682: hr_utility.set_message_token('MIN_VALUE',p_user_min_value);

678: hr_utility.set_message_token('MAX_VALUE',p_user_max_value);
679: hr_utility.raise_error;
680: end if;
681: hr_utility.set_message(801,'HR_ELE_ENTRY_MIN_MAX_WARN');
682: hr_utility.set_message_token('MIN_VALUE',p_user_min_value);
683: hr_utility.set_message_token('MAX_VALUE',p_user_max_value);
684: hr_utility.raise_error;
685: end if;
686: --

Line 683: hr_utility.set_message_token('MAX_VALUE',p_user_max_value);

679: hr_utility.raise_error;
680: end if;
681: hr_utility.set_message(801,'HR_ELE_ENTRY_MIN_MAX_WARN');
682: hr_utility.set_message_token('MIN_VALUE',p_user_min_value);
683: hr_utility.set_message_token('MAX_VALUE',p_user_max_value);
684: hr_utility.raise_error;
685: end if;
686: --
687: -- Execute formula validation.

Line 684: hr_utility.raise_error;

680: end if;
681: hr_utility.set_message(801,'HR_ELE_ENTRY_MIN_MAX_WARN');
682: hr_utility.set_message_token('MIN_VALUE',p_user_min_value);
683: hr_utility.set_message_token('MAX_VALUE',p_user_max_value);
684: hr_utility.raise_error;
685: end if;
686: --
687: -- Execute formula validation.
688: --

Line 706: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

702: -- then raise error. In case of 'W'(Warning), Forms should warn
703: -- to user with fnd_message.warn procedure.
704: --
705: if l_formula_status = 'E' and l_rec.warning_or_error = 'E' then
706: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
707: hr_utility.set_message_token('FORMULA_TEXT',p_formula_message);
708: hr_utility.raise_error;
709: end if;
710: --

Line 707: hr_utility.set_message_token('FORMULA_TEXT',p_formula_message);

703: -- to user with fnd_message.warn procedure.
704: --
705: if l_formula_status = 'E' and l_rec.warning_or_error = 'E' then
706: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
707: hr_utility.set_message_token('FORMULA_TEXT',p_formula_message);
708: hr_utility.raise_error;
709: end if;
710: --
711: -- In case lookup_type validation is applied.

Line 708: hr_utility.raise_error;

704: --
705: if l_formula_status = 'E' and l_rec.warning_or_error = 'E' then
706: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
707: hr_utility.set_message_token('FORMULA_TEXT',p_formula_message);
708: hr_utility.raise_error;
709: end if;
710: --
711: -- In case lookup_type validation is applied.
712: --

Line 721: hr_utility.set_message(801,'HR_7033_ELE_ENTRY_LKUP_INVLD');

717: if hr_api.not_exists_in_hr_lookups(
718: p_effective_date => p_effective_date,
719: p_lookup_type => l_rec.lookup_type,
720: p_lookup_code => p_canonical_value) then
721: hr_utility.set_message(801,'HR_7033_ELE_ENTRY_LKUP_INVLD');
722: hr_utility.set_message_token('LOOKUP_TYPE',l_rec.lookup_type);
723: hr_utility.raise_error;
724: end if;
725: end if;

Line 722: hr_utility.set_message_token('LOOKUP_TYPE',l_rec.lookup_type);

718: p_effective_date => p_effective_date,
719: p_lookup_type => l_rec.lookup_type,
720: p_lookup_code => p_canonical_value) then
721: hr_utility.set_message(801,'HR_7033_ELE_ENTRY_LKUP_INVLD');
722: hr_utility.set_message_token('LOOKUP_TYPE',l_rec.lookup_type);
723: hr_utility.raise_error;
724: end if;
725: end if;
726: end if;

Line 723: hr_utility.raise_error;

719: p_lookup_type => l_rec.lookup_type,
720: p_lookup_code => p_canonical_value) then
721: hr_utility.set_message(801,'HR_7033_ELE_ENTRY_LKUP_INVLD');
722: hr_utility.set_message_token('LOOKUP_TYPE',l_rec.lookup_type);
723: hr_utility.raise_error;
724: end if;
725: end if;
726: end if;
727: --

Line 784: hr_utility.set_location('Entering:'||l_proc, 5);

780: and pet.effective_end_date;
781: --
782: begin
783: if g_debug then
784: hr_utility.set_location('Entering:'||l_proc, 5);
785: end if;
786:
787: open c_sel1;
788: fetch c_sel1 into l_entry_type, l_processing_type;

Line 792: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

788: fetch c_sel1 into l_entry_type, l_processing_type;
789:
790: if c_sel1%notfound then
791: close c_sel1;
792: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
793: hr_utility.set_message_token('PROCEDURE', l_proc);
794: hr_utility.set_message_token('STEP','10');
795: hr_utility.raise_error;
796: end if;

Line 793: hr_utility.set_message_token('PROCEDURE', l_proc);

789:
790: if c_sel1%notfound then
791: close c_sel1;
792: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
793: hr_utility.set_message_token('PROCEDURE', l_proc);
794: hr_utility.set_message_token('STEP','10');
795: hr_utility.raise_error;
796: end if;
797:

Line 794: hr_utility.set_message_token('STEP','10');

790: if c_sel1%notfound then
791: close c_sel1;
792: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
793: hr_utility.set_message_token('PROCEDURE', l_proc);
794: hr_utility.set_message_token('STEP','10');
795: hr_utility.raise_error;
796: end if;
797:
798: close c_sel1;

Line 795: hr_utility.raise_error;

791: close c_sel1;
792: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
793: hr_utility.set_message_token('PROCEDURE', l_proc);
794: hr_utility.set_message_token('STEP','10');
795: hr_utility.raise_error;
796: end if;
797:
798: close c_sel1;
799: --

Line 822: hr_utility.set_location(' Leaving:'||l_proc, 10);

818: );
819: end if;
820: --
821: if g_debug then
822: hr_utility.set_location(' Leaving:'||l_proc, 10);
823: end if;
824:
825: end find_dt_upd_modes;
826:

Line 872: hr_utility.set_location('Entering:'||l_proc, 5);

868: and pet.effective_end_date;
869: --
870: begin
871: if g_debug then
872: hr_utility.set_location('Entering:'||l_proc, 5);
873: end if;
874:
875: open c_sel1;
876: fetch c_sel1 into l_parent_key_value1,

Line 883: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

879: l_processing_type;
880:
881: if c_sel1%notfound then
882: close c_sel1;
883: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
884: hr_utility.set_message_token('PROCEDURE', l_proc);
885: hr_utility.set_message_token('STEP','10');
886: hr_utility.raise_error;
887: end if;

Line 884: hr_utility.set_message_token('PROCEDURE', l_proc);

880:
881: if c_sel1%notfound then
882: close c_sel1;
883: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
884: hr_utility.set_message_token('PROCEDURE', l_proc);
885: hr_utility.set_message_token('STEP','10');
886: hr_utility.raise_error;
887: end if;
888: close c_sel1;

Line 885: hr_utility.set_message_token('STEP','10');

881: if c_sel1%notfound then
882: close c_sel1;
883: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
884: hr_utility.set_message_token('PROCEDURE', l_proc);
885: hr_utility.set_message_token('STEP','10');
886: hr_utility.raise_error;
887: end if;
888: close c_sel1;
889: --

Line 886: hr_utility.raise_error;

882: close c_sel1;
883: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
884: hr_utility.set_message_token('PROCEDURE', l_proc);
885: hr_utility.set_message_token('STEP','10');
886: hr_utility.raise_error;
887: end if;
888: close c_sel1;
889: --
890:

Line 919: hr_utility.set_location(' Leaving:' || l_proc, 10 );

915: );
916: end if;
917:
918: if g_debug then
919: hr_utility.set_location(' Leaving:' || l_proc, 10 );
920: end if;
921:
922: end find_dt_del_modes;
923:

Line 948: hr_utility.set_location( 'Entering:' || l_proc, 5 );

944: l_validation_end_date date;
945:
946: begin
947: if g_debug then
948: hr_utility.set_location( 'Entering:' || l_proc, 5 );
949: end if;
950: --
951: -- Validate the datetrack mode getting the validation start
952: -- and end dates for the specified datetrack operation.

Line 977: hr_utility.set_location(' Leaving:'||l_proc, 15);

973: p_validation_start_date := l_validation_start_date;
974: p_validation_end_date := l_validation_end_date;
975: --
976: if g_debug then
977: hr_utility.set_location(' Leaving:'||l_proc, 15);
978: end if;
979: end ins_lck;
980:
981: -- ---------------------------------------------------------------------

Line 1021: hr_utility.set_location('Entering:'||l_proc, 5);

1017: for update nowait;
1018:
1019: begin
1020: if g_debug then
1021: hr_utility.set_location('Entering:'||l_proc, 5);
1022: end if;
1023: --
1024: -- Ensure that all the mandatory arguments are not null
1025: --

Line 1056: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

1052: close c_sel1;
1053: --
1054: -- The primary key is invalid therefore we must error
1055: --
1056: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1057: hr_utility.raise_error;
1058: end if;
1059:
1060: close c_sel1;

Line 1057: hr_utility.raise_error;

1053: --
1054: -- The primary key is invalid therefore we must error
1055: --
1056: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1057: hr_utility.raise_error;
1058: end if;
1059:
1060: close c_sel1;
1061: --

Line 1066: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

1062: -- Check if the set object version number is the same
1063: -- as the existing object version number
1064: --
1065: if (p_object_version_number <> g_old_rec.object_version_number) then
1066: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1067: hr_utility.raise_error;
1068: end if;
1069:
1070: if g_debug then

Line 1067: hr_utility.raise_error;

1063: -- as the existing object version number
1064: --
1065: if (p_object_version_number <> g_old_rec.object_version_number) then
1066: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1067: hr_utility.raise_error;
1068: end if;
1069:
1070: if g_debug then
1071: hr_utility.set_location('Entering validation_dt_mode', 15);

Line 1071: hr_utility.set_location('Entering validation_dt_mode', 15);

1067: hr_utility.raise_error;
1068: end if;
1069:
1070: if g_debug then
1071: hr_utility.set_location('Entering validation_dt_mode', 15);
1072: end if;
1073:
1074: dt_api.validate_dt_mode(
1075: p_effective_date => p_effective_date,

Line 1096: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1092: -- We are doing a datetrack 'INSERT' which is illegal within this
1093: -- procedure therefore we must error (note: to lck on insert the
1094: -- private procedure ins_lck should be called).
1095: --
1096: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1097: hr_utility.set_message_token('PROCEDURE', l_proc);
1098: hr_utility.set_message_token('STEP','20');
1099: hr_utility.raise_error;
1100:

Line 1097: hr_utility.set_message_token('PROCEDURE', l_proc);

1093: -- procedure therefore we must error (note: to lck on insert the
1094: -- private procedure ins_lck should be called).
1095: --
1096: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1097: hr_utility.set_message_token('PROCEDURE', l_proc);
1098: hr_utility.set_message_token('STEP','20');
1099: hr_utility.raise_error;
1100:
1101: end if;

Line 1098: hr_utility.set_message_token('STEP','20');

1094: -- private procedure ins_lck should be called).
1095: --
1096: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1097: hr_utility.set_message_token('PROCEDURE', l_proc);
1098: hr_utility.set_message_token('STEP','20');
1099: hr_utility.raise_error;
1100:
1101: end if;
1102: --

Line 1099: hr_utility.raise_error;

1095: --
1096: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1097: hr_utility.set_message_token('PROCEDURE', l_proc);
1098: hr_utility.set_message_token('STEP','20');
1099: hr_utility.raise_error;
1100:
1101: end if;
1102: --
1103: -- Set the validation start and end date OUT arguments

Line 1109: hr_utility.set_location(' Leaving:'||l_proc, 30);

1105: p_validation_start_date := l_validation_start_date;
1106: p_validation_end_date := l_validation_end_date;
1107:
1108: if g_debug then
1109: hr_utility.set_location(' Leaving:'||l_proc, 30);
1110: end if;
1111: --
1112: -- We need to trap the ORA LOCK exception
1113: --

Line 1120: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

1116: --
1117: -- The object is locked therefore we need to supply a meaningful
1118: -- error message.
1119: --
1120: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1121: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
1122: hr_utility.raise_error;
1123: when l_object_invalid then
1124: --

Line 1121: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');

1117: -- The object is locked therefore we need to supply a meaningful
1118: -- error message.
1119: --
1120: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1121: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
1122: hr_utility.raise_error;
1123: when l_object_invalid then
1124: --
1125: -- The object doesn't exist or is invalid

Line 1122: hr_utility.raise_error;

1118: -- error message.
1119: --
1120: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1121: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
1122: hr_utility.raise_error;
1123: when l_object_invalid then
1124: --
1125: -- The object doesn't exist or is invalid
1126: --

Line 1127: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

1123: when l_object_invalid then
1124: --
1125: -- The object doesn't exist or is invalid
1126: --
1127: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1128: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
1129: hr_utility.raise_error;
1130:
1131: end lck;

Line 1128: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');

1124: --
1125: -- The object doesn't exist or is invalid
1126: --
1127: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1128: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
1129: hr_utility.raise_error;
1130:
1131: end lck;
1132:

Line 1129: hr_utility.raise_error;

1125: -- The object doesn't exist or is invalid
1126: --
1127: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
1128: hr_utility.set_message_token('TABLE_NAME', 'pay_element_entries_f');
1129: hr_utility.raise_error;
1130:
1131: end lck;
1132:
1133: -- ---------------------------------------------------------------------

Line 1347: hr_utility.set_location('Entering:'|| l_proc, 10);

1343: ) is
1344: l_proc varchar2(72) := g_package||'upd_contact_info';
1345: begin
1346: if g_debug then
1347: hr_utility.set_location('Entering:'|| l_proc, 10);
1348: hr_utility.set_location(l_proc, 6);
1349: end if;
1350: --
1351: -- Call the contact relationships API

Line 1348: hr_utility.set_location(l_proc, 6);

1344: l_proc varchar2(72) := g_package||'upd_contact_info';
1345: begin
1346: if g_debug then
1347: hr_utility.set_location('Entering:'|| l_proc, 10);
1348: hr_utility.set_location(l_proc, 6);
1349: end if;
1350: --
1351: -- Call the contact relationships API
1352: --

Line 1371: hr_utility.set_location(' Leaving:'||l_proc, 40);

1367: ,p_cont_information14 => p_cont_information14
1368: );
1369:
1370: if g_debug then
1371: hr_utility.set_location(' Leaving:'||l_proc, 40);
1372: end if;
1373:
1374: end upd_contact_info;
1375:

Line 1407: hr_utility.set_location('Entering:'|| l_proc, 25);

1403: l_proc varchar2(72) := g_package||'upd_contact_extra_info';
1404: begin
1405:
1406: if g_debug then
1407: hr_utility.set_location('Entering:'|| l_proc, 25);
1408: hr_utility.set_location(l_proc, 6);
1409: end if;
1410:
1411: hr_contact_extra_info_api.update_contact_extra_info

Line 1408: hr_utility.set_location(l_proc, 6);

1404: begin
1405:
1406: if g_debug then
1407: hr_utility.set_location('Entering:'|| l_proc, 25);
1408: hr_utility.set_location(l_proc, 6);
1409: end if;
1410:
1411: hr_contact_extra_info_api.update_contact_extra_info
1412: ( p_effective_date => p_effective_date,

Line 1436: hr_utility.set_location(' Leaving:'||l_proc, 40);

1432: p_effective_end_date => p_cei_effective_end_date
1433: );
1434: --
1435: if g_debug then
1436: hr_utility.set_location(' Leaving:'||l_proc, 40);
1437: end if;
1438: --
1439: end upd_contact_extra_info;
1440:

Line 1473: hr_utility.set_location('Entering:'|| l_proc, 25);

1469: l_proc varchar2(72) := g_package||'create_contact_extra_info';
1470: begin
1471: --
1472: if g_debug then
1473: hr_utility.set_location('Entering:'|| l_proc, 25);
1474: hr_utility.set_location(l_proc, 6);
1475: end if;
1476:
1477: hr_contact_extra_info_api.create_contact_extra_info

Line 1474: hr_utility.set_location(l_proc, 6);

1470: begin
1471: --
1472: if g_debug then
1473: hr_utility.set_location('Entering:'|| l_proc, 25);
1474: hr_utility.set_location(l_proc, 6);
1475: end if;
1476:
1477: hr_contact_extra_info_api.create_contact_extra_info
1478: ( p_effective_date => p_effective_date,

Line 1502: hr_utility.set_location(' Leaving:'||l_proc, 40);

1498: p_effective_end_date => p_cei_effective_end_date
1499: );
1500: --
1501: if g_debug then
1502: hr_utility.set_location(' Leaving:'||l_proc, 40);
1503: end if;
1504: --
1505: end create_contact_extra_info;
1506: --