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_EEI_MIG_BUS dependencies on HR_UTILITY

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

39: l_proc varchar2(72) := g_package||'set_security_group_id';
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

Line 74: hr_utility.set_location(' Leaving:'|| l_proc, 20);

70: hr_api.set_security_group_id
71: (p_security_group_id => l_security_group_id
72: );
73: --
74: hr_utility.set_location(' Leaving:'|| l_proc, 20);
75: --
76: end set_security_group_id;
77: --
78: -- ---------------------------------------------------------------------------

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

101: l_proc varchar2(72) := g_package||'return_legislation_code';
102: --
103: Begin
104: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error

Line 123: hr_utility.set_location(l_proc, 20);

119: -- call to this function. Just return the value in the global
120: -- variable.
121: --
122: l_legislation_code := pay_eei_mig_bus.g_legislation_code;
123: hr_utility.set_location(l_proc, 20);
124: else
125: --
126: -- The ID is different to the last call to this function
127: -- or this is the first call to this function.

Line 140: hr_utility.set_location(l_proc,30);

136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are
143: -- available for the next call to this function.
144: --

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

145: close csr_leg_code;
146: pay_eei_mig_bus.g_element_type_extra_info_id := p_element_type_extra_info_id;
147: pay_eei_mig_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
152: --
153: -- ----------------------------------------------------------------------------

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

184: --
185: l_proc varchar2(72) := g_package || 'chk_ddf';
186: --
187: begin
188: hr_utility.set_location('Entering:'||l_proc,10);
189: --
190: if ((p_rec.element_type_extra_info_id is not null) and (
191: nvl(pay_eei_mig_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
192: nvl(p_rec.information_type, hr_api.g_varchar2) or

Line 330: hr_utility.set_location(' Leaving:'||l_proc,20);

326: ,p_attribute30_value => p_rec.eei_information30
327: );
328: end if;
329: --
330: hr_utility.set_location(' Leaving:'||l_proc,20);
331: end chk_ddf;
332: --
333: -- ----------------------------------------------------------------------------
334: -- |------------------------------< chk_df >----------------------------------|

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

364: --
365: l_proc varchar2(72) := g_package || 'chk_df';
366: --
367: begin
368: hr_utility.set_location('Entering:'||l_proc,10);
369: --
370: if ((p_rec.element_type_extra_info_id is not null) and (
371: nvl(pay_eei_mig_shd.g_old_rec.eei_attribute_category, hr_api.g_varchar2) <>
372: nvl(p_rec.eei_attribute_category, hr_api.g_varchar2) or

Line 467: hr_utility.set_location(' Leaving:'||l_proc,20);

463: ,p_attribute20_value => p_rec.eei_attribute20
464: );
465: end if;
466: --
467: hr_utility.set_location(' Leaving:'||l_proc,20);
468: end chk_df;
469: --
470: -- ----------------------------------------------------------------------------
471: -- |-----------------------< chk_non_updateable_args >------------------------|

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

618: and hrl.enabled_flag = 'Y' ;
619: --
620: Begin
621: --
622: hr_utility.set_location('Entering:'||l_proc, 5);
623:
624: --
625: open c_get_bus_grp_id ;
626: fetch c_get_bus_grp_id into l_business_group_id;

Line 646: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');

642: close c_input_value;
643:
644: if l_exists is null then
645: --
646: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
647: hr_utility.raise_error;
648: --
649: end if;
650: --

Line 647: hr_utility.raise_error;

643:
644: if l_exists is null then
645: --
646: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
647: hr_utility.raise_error;
648: --
649: end if;
650: --
651: elsif p_pay_source_value = 'GV' then

Line 659: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');

655: close c_global;
656:
657: if l_exists is null then
658: --
659: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
660: hr_utility.raise_error;
661: --
662: end if;
663: --

Line 660: hr_utility.raise_error;

656:
657: if l_exists is null then
658: --
659: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
660: hr_utility.raise_error;
661: --
662: end if;
663: --
664: elsif p_pay_source_value = 'GR' then

Line 681: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');

677: close c_grade_rate;
678:
679: if l_exists is null then
680: --
681: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
682: hr_utility.raise_error;
683: --
684: end if;
685: --

Line 682: hr_utility.raise_error;

678:
679: if l_exists is null then
680: --
681: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
682: hr_utility.raise_error;
683: --
684: end if;
685: --
686: elsif p_pay_source_value = 'SP' then

Line 703: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');

699: close c_spinal_point;
700:
701: if l_exists is null then
702: --
703: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
704: hr_utility.raise_error;
705: --
706: end if;
707: --

Line 704: hr_utility.raise_error;

700:
701: if l_exists is null then
702: --
703: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
704: hr_utility.raise_error;
705: --
706: end if;
707: --
708: elsif p_pay_source_value = 'RT' then

Line 716: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');

712: close c_rate_type ;
713:
714: if l_exists is null then
715: --
716: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
717: hr_utility.raise_error;
718: --
719: end if;
720: --

Line 717: hr_utility.raise_error;

713:
714: if l_exists is null then
715: --
716: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
717: hr_utility.raise_error;
718: --
719: end if;
720: --
721: elsif p_pay_source_value = 'EN' then

Line 729: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');

725: close c_element_name ;
726:
727: if l_exists is null then
728: --
729: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
730: hr_utility.raise_error;
731: --
732: end if;
733: --

Line 730: hr_utility.raise_error;

726:
727: if l_exists is null then
728: --
729: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
730: hr_utility.raise_error;
731: --
732: end if;
733: --
734: end if;

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

732: end if;
733: --
734: end if;
735:
736: hr_utility.set_location('Entering:'||l_proc, 10);
737: --
738: end chk_qualifier;
739: --
740: --

Line 763: hr_utility.set_message(8303, 'PQP_230021_INVALID_INPUT_VALUE');

759: close c_input_value ;
760:
761: if l_exists is null then
762: --
763: hr_utility.set_message(8303, 'PQP_230021_INVALID_INPUT_VALUE');
764: hr_utility.raise_error;
765: --
766: end if;
767:

Line 764: hr_utility.raise_error;

760:
761: if l_exists is null then
762: --
763: hr_utility.set_message(8303, 'PQP_230021_INVALID_INPUT_VALUE');
764: hr_utility.raise_error;
765: --
766: end if;
767:
768: end chk_input_value ;

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

785: ) is
786: l_proc varchar2(72) := g_package||'chk_input_value';
787: begin
788:
789: hr_utility.set_location('Entering:'||l_proc,10);
790:
791: if p_eei_information2 not in ('RT','EN') then
792:
793: -- % or Factor Value OR % or Factor Input Value

Line 799: hr_utility.set_message(8303, 'PQP_230017_CALC_TYPE');

795: -- is Element Name or Rate Type
796:
797: if p_eei_information8 is not null or
798: p_eei_information9 is not null then
799: hr_utility.set_message(8303, 'PQP_230017_CALC_TYPE');
800: hr_utility.raise_error;
801: end if;
802:
803: else

Line 800: hr_utility.raise_error;

796:
797: if p_eei_information8 is not null or
798: p_eei_information9 is not null then
799: hr_utility.set_message(8303, 'PQP_230017_CALC_TYPE');
800: hr_utility.raise_error;
801: end if;
802:
803: else
804:

Line 809: hr_utility.set_message(8303, 'PQP_230018_CALC_TYPE_MAND');

805: -- If Pay Source Value is in Element Name or Rate Type
806:
807: -- % or Factor Type is Mandatory
808: if p_eei_information7 is null then
809: hr_utility.set_message(8303, 'PQP_230018_CALC_TYPE_MAND');
810: hr_utility.raise_error;
811: end if;
812:
813: -- When the Pay Source Value is either Rate Type or Element Name

Line 810: hr_utility.raise_error;

806:
807: -- % or Factor Type is Mandatory
808: if p_eei_information7 is null then
809: hr_utility.set_message(8303, 'PQP_230018_CALC_TYPE_MAND');
810: hr_utility.raise_error;
811: end if;
812:
813: -- When the Pay Source Value is either Rate Type or Element Name
814: -- then either Calculation Value or Input Value Name should be entered.

Line 818: hr_utility.set_message(8303, 'PQP_230019_CALC_VAL_OR_INPUT');

814: -- then either Calculation Value or Input Value Name should be entered.
815: -- ( please note that only one should be entered )
816: if p_eei_information8 is null and
817: p_eei_information9 is null then
818: hr_utility.set_message(8303, 'PQP_230019_CALC_VAL_OR_INPUT');
819: hr_utility.raise_error;
820: end if;
821: if p_eei_information8 is not null and
822: p_eei_information9 is not null then

Line 819: hr_utility.raise_error;

815: -- ( please note that only one should be entered )
816: if p_eei_information8 is null and
817: p_eei_information9 is null then
818: hr_utility.set_message(8303, 'PQP_230019_CALC_VAL_OR_INPUT');
819: hr_utility.raise_error;
820: end if;
821: if p_eei_information8 is not null and
822: p_eei_information9 is not null then
823: hr_utility.set_message(8303, 'PQP_230019_CALC_VAL_OR_INPUT');

Line 823: hr_utility.set_message(8303, 'PQP_230019_CALC_VAL_OR_INPUT');

819: hr_utility.raise_error;
820: end if;
821: if p_eei_information8 is not null and
822: p_eei_information9 is not null then
823: hr_utility.set_message(8303, 'PQP_230019_CALC_VAL_OR_INPUT');
824: hr_utility.raise_error;
825: end if;
826: end if;
827:

Line 824: hr_utility.raise_error;

820: end if;
821: if p_eei_information8 is not null and
822: p_eei_information9 is not null then
823: hr_utility.set_message(8303, 'PQP_230019_CALC_VAL_OR_INPUT');
824: hr_utility.raise_error;
825: end if;
826: end if;
827:
828: -- Validate that Input Value Name entered is correct

Line 838: hr_utility.set_message(8303, 'PQP_230020_ASSIGN_MAND');

834: -- If Pay Source Value is other than Input Value then
835: -- Link to Assignment is Mandatory.
836: if p_eei_information2 <> 'IV' then
837: if p_eei_information10 is null then
838: hr_utility.set_message(8303, 'PQP_230020_ASSIGN_MAND');
839: hr_utility.raise_error;
840: end if;
841: end if;
842: hr_utility.set_location('Leaving:'||l_proc,20);

Line 839: hr_utility.raise_error;

835: -- Link to Assignment is Mandatory.
836: if p_eei_information2 <> 'IV' then
837: if p_eei_information10 is null then
838: hr_utility.set_message(8303, 'PQP_230020_ASSIGN_MAND');
839: hr_utility.raise_error;
840: end if;
841: end if;
842: hr_utility.set_location('Leaving:'||l_proc,20);
843:

Line 842: hr_utility.set_location('Leaving:'||l_proc,20);

838: hr_utility.set_message(8303, 'PQP_230020_ASSIGN_MAND');
839: hr_utility.raise_error;
840: end if;
841: end if;
842: hr_utility.set_location('Leaving:'||l_proc,20);
843:
844: end chk_mandatory_params;
845: -- ----------------------------------------------------------------------------
846: -- |---------------------------< chk_duplicate_rate_type >--------------------|

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

863: and eei_information1 = p_rate_type;
864:
865: begin
866: --
867: hr_utility.set_location('Entering:'||l_proc, 5);
868:
869: open c_duplicate;
870: fetch c_duplicate into l_result;
871: close c_duplicate;

Line 875: hr_utility.set_message(8303, 'PQP_230516_DUPLICATE_RATE_TYPE');

871: close c_duplicate;
872:
873: if l_result = 1 then
874: --
875: hr_utility.set_message(8303, 'PQP_230516_DUPLICATE_RATE_TYPE');
876: hr_utility.raise_error;
877: --
878: end if;
879:

Line 876: hr_utility.raise_error;

872:
873: if l_result = 1 then
874: --
875: hr_utility.set_message(8303, 'PQP_230516_DUPLICATE_RATE_TYPE');
876: hr_utility.raise_error;
877: --
878: end if;
879:
880: hr_utility.set_location('Leaving:'||l_proc, 10);

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

876: hr_utility.raise_error;
877: --
878: end if;
879:
880: hr_utility.set_location('Leaving:'||l_proc, 10);
881: --
882: end chk_duplicate_rate_type;
883: --
884: -- ----------------------------------------------------------------------------

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

910: where element_type_id = p_element_type_id
911: and information_type = p_info_type;
912: begin
913: --
914: hr_utility.set_location('Entering:'||l_proc, 5);
915:
916: open c_duplicate;
917: fetch c_duplicate into l_result;
918: close c_duplicate;

Line 923: hr_utility.set_message(8303, 'PQP_230501_DUP_ALLOWANCE_CODE');

919:
920: if l_result = 1 then
921: --
922: if p_information_type = 'PQP_GB_PENSERV_ALLOWANCE_INFO' then
923: hr_utility.set_message(8303, 'PQP_230501_DUP_ALLOWANCE_CODE');
924: elsif p_information_type = 'PQP_GB_PENSERV_BONUS_INFO' then
925: hr_utility.set_message(8303, 'PQP_230502_DUP_BONUS_CODE');
926: end if;
927:

Line 925: hr_utility.set_message(8303, 'PQP_230502_DUP_BONUS_CODE');

921: --
922: if p_information_type = 'PQP_GB_PENSERV_ALLOWANCE_INFO' then
923: hr_utility.set_message(8303, 'PQP_230501_DUP_ALLOWANCE_CODE');
924: elsif p_information_type = 'PQP_GB_PENSERV_BONUS_INFO' then
925: hr_utility.set_message(8303, 'PQP_230502_DUP_BONUS_CODE');
926: end if;
927:
928: hr_utility.raise_error;
929: --

Line 928: hr_utility.raise_error;

924: elsif p_information_type = 'PQP_GB_PENSERV_BONUS_INFO' then
925: hr_utility.set_message(8303, 'PQP_230502_DUP_BONUS_CODE');
926: end if;
927:
928: hr_utility.raise_error;
929: --
930: end if;
931:
932: -- check if other information type exist.

Line 943: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');

939: FETCH c_element_code_exists INTO l_result;
940: CLOSE c_element_code_exists;
941:
942: IF l_result = 1 THEN
943: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
944: hr_utility.set_message_token('TOKEN1','Bonus');
945: hr_utility.set_message_token('TOKEN2','Allowance');
946: hr_utility.raise_error;
947: END IF;

Line 944: hr_utility.set_message_token('TOKEN1','Bonus');

940: CLOSE c_element_code_exists;
941:
942: IF l_result = 1 THEN
943: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
944: hr_utility.set_message_token('TOKEN1','Bonus');
945: hr_utility.set_message_token('TOKEN2','Allowance');
946: hr_utility.raise_error;
947: END IF;
948:

Line 945: hr_utility.set_message_token('TOKEN2','Allowance');

941:
942: IF l_result = 1 THEN
943: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
944: hr_utility.set_message_token('TOKEN1','Bonus');
945: hr_utility.set_message_token('TOKEN2','Allowance');
946: hr_utility.raise_error;
947: END IF;
948:
949: elsif p_information_type = 'PQP_GB_PENSERV_BONUS_INFO' then

Line 946: hr_utility.raise_error;

942: IF l_result = 1 THEN
943: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
944: hr_utility.set_message_token('TOKEN1','Bonus');
945: hr_utility.set_message_token('TOKEN2','Allowance');
946: hr_utility.raise_error;
947: END IF;
948:
949: elsif p_information_type = 'PQP_GB_PENSERV_BONUS_INFO' then
950: -- check if the element has Bonus info

Line 959: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');

955: FETCH c_element_code_exists INTO l_result;
956: CLOSE c_element_code_exists;
957:
958: IF l_result = 1 THEN
959: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
960: hr_utility.set_message_token('TOKEN1','Allowance');
961: hr_utility.set_message_token('TOKEN2','Bonus');
962: hr_utility.raise_error;
963: END IF;

Line 960: hr_utility.set_message_token('TOKEN1','Allowance');

956: CLOSE c_element_code_exists;
957:
958: IF l_result = 1 THEN
959: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
960: hr_utility.set_message_token('TOKEN1','Allowance');
961: hr_utility.set_message_token('TOKEN2','Bonus');
962: hr_utility.raise_error;
963: END IF;
964:

Line 961: hr_utility.set_message_token('TOKEN2','Bonus');

957:
958: IF l_result = 1 THEN
959: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
960: hr_utility.set_message_token('TOKEN1','Allowance');
961: hr_utility.set_message_token('TOKEN2','Bonus');
962: hr_utility.raise_error;
963: END IF;
964:
965: end if;

Line 962: hr_utility.raise_error;

958: IF l_result = 1 THEN
959: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
960: hr_utility.set_message_token('TOKEN1','Allowance');
961: hr_utility.set_message_token('TOKEN2','Bonus');
962: hr_utility.raise_error;
963: END IF;
964:
965: end if;
966:

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

963: END IF;
964:
965: end if;
966:
967: hr_utility.set_location('Leaving:'||l_proc, 10);
968: --
969: end chk_duplicate_element_code;
970: --
971: -- ----------------------------------------------------------------------------

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

986: l_bg pay_element_types_f.business_group_id%type;
987: l_proc varchar2(72) := g_package||'insert_validate';
988: --
989: Begin
990: hr_utility.set_location('Entering:'||l_proc, 5);
991: --
992: -- Call all supporting business operations
993: -- Bug 3041843
994: --

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

1057: --
1058: end if;
1059:
1060: --
1061: hr_utility.set_location(' Leaving:'||l_proc, 10);
1062: End insert_validate;
1063: --
1064: -- ----------------------------------------------------------------------------
1065: -- |---------------------------< update_validate >----------------------------|

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

1079: l_bg pay_element_types_f.business_group_id%type;
1080: l_proc varchar2(72) := g_package||'update_validate';
1081: --
1082: Begin
1083: hr_utility.set_location('Entering:'||l_proc, 5);
1084: --
1085: -- Call all supporting business operations
1086: --
1087: open row_type(p_rec.element_type_id);

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

1151: --
1152: end if;
1153:
1154: --
1155: hr_utility.set_location(' Leaving:'||l_proc, 10);
1156: End update_validate;
1157: --
1158: -- ----------------------------------------------------------------------------
1159: -- |---------------------------< delete_validate >----------------------------|

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

1164: --
1165: l_proc varchar2(72) := g_package||'delete_validate';
1166: --
1167: Begin
1168: hr_utility.set_location('Entering:'||l_proc, 5);
1169: --
1170: -- Call all supporting business operations
1171: --
1172: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1168: hr_utility.set_location('Entering:'||l_proc, 5);
1169: --
1170: -- Call all supporting business operations
1171: --
1172: hr_utility.set_location(' Leaving:'||l_proc, 10);
1173: End delete_validate;
1174: ---
1175: end pay_eei_mig_bus;