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 17: g_debug boolean := hr_utility.debug_enabled;

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

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

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

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

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

Line 190: hr_utility.set_message_token('ELEMENT_NAME',

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

Line 192: hr_utility.raise_error;

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

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

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

Line 370: hr_utility.set_message_token('DATE',

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

Line 372: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 580: hr_utility.raise_error;

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

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

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

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

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

Line 597: hr_utility.raise_error;

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

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

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

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

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

Line 605: hr_utility.raise_error;

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

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

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

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

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

Line 645: hr_utility.raise_error;

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

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

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

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

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

Line 677: hr_utility.raise_error;

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

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

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

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

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

Line 682: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 687: hr_utility.raise_error;

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

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

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

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

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

Line 711: hr_utility.raise_error;

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

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

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

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

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

Line 726: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 798: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

Line 889: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

Line 1060: hr_utility.raise_error;

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

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

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

Line 1070: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 1102: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 1125: hr_utility.raise_error;

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

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

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

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

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

Line 1132: hr_utility.raise_error;

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

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

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

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

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

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

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

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

1417: l_proc varchar2(72) := g_package||'upd_contact_extra_info';
1418: begin
1419:
1420: if g_debug then
1421: hr_utility.set_location('Entering:'|| l_proc, 25);
1422: hr_utility.set_location(l_proc, 6);
1423: end if;
1424:
1425: hr_contact_extra_info_api.update_contact_extra_info

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

1418: begin
1419:
1420: if g_debug then
1421: hr_utility.set_location('Entering:'|| l_proc, 25);
1422: hr_utility.set_location(l_proc, 6);
1423: end if;
1424:
1425: hr_contact_extra_info_api.update_contact_extra_info
1426: ( p_effective_date => p_effective_date,

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

1457: p_effective_end_date => p_cei_effective_end_date
1458: );
1459: --
1460: if g_debug then
1461: hr_utility.set_location(' Leaving:'||l_proc, 40);
1462: end if;
1463: --
1464: end upd_contact_extra_info;
1465:

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

1505: l_proc varchar2(72) := g_package||'create_contact_extra_info';
1506: begin
1507: --
1508: if g_debug then
1509: hr_utility.set_location('Entering:'|| l_proc, 25);
1510: hr_utility.set_location(l_proc, 6);
1511: end if;
1512:
1513: hr_contact_extra_info_api.create_contact_extra_info

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

1506: begin
1507: --
1508: if g_debug then
1509: hr_utility.set_location('Entering:'|| l_proc, 25);
1510: hr_utility.set_location(l_proc, 6);
1511: end if;
1512:
1513: hr_contact_extra_info_api.create_contact_extra_info
1514: ( p_effective_date => p_effective_date,

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

1545: p_effective_end_date => p_cei_effective_end_date
1546: );
1547: --
1548: if g_debug then
1549: hr_utility.set_location(' Leaving:'||l_proc, 40);
1550: end if;
1551: --
1552: end create_contact_extra_info;
1553: --