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_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_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_bus.g_element_type_extra_info_id := p_element_type_extra_info_id;
147: pay_eei_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_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_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 635: hr_utility.set_location('Entering:'||l_proc, 5);

631: or ( put.legislation_code is null and put.business_group_id is null )) ;
632:
633: Begin
634: --
635: hr_utility.set_location('Entering:'||l_proc, 5);
636:
637: --
638: open c_get_bus_grp_id ;
639: fetch c_get_bus_grp_id into l_business_group_id;

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

655: close c_input_value;
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 = 'GV' then

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

668: close c_global;
669:
670: if l_exists is null then
671: --
672: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
673: hr_utility.raise_error;
674: --
675: end if;
676: --

Line 673: hr_utility.raise_error;

669:
670: if l_exists is null then
671: --
672: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
673: hr_utility.raise_error;
674: --
675: end if;
676: --
677: elsif p_pay_source_value = 'GR' then

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

690: close c_grade_rate;
691:
692: if l_exists is null then
693: --
694: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
695: hr_utility.raise_error;
696: --
697: end if;
698: --

Line 695: hr_utility.raise_error;

691:
692: if l_exists is null then
693: --
694: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
695: hr_utility.raise_error;
696: --
697: end if;
698: --
699: elsif p_pay_source_value = 'SP' then

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

712: close c_spinal_point;
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 = 'RT' then

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

725: close c_rate_type ;
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: elsif p_pay_source_value = 'EN' then

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

738: close c_element_name ;
739:
740: if l_exists is null then
741: --
742: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
743: hr_utility.raise_error;
744: --
745: end if;
746: --

Line 743: hr_utility.raise_error;

739:
740: if l_exists is null then
741: --
742: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
743: hr_utility.raise_error;
744: --
745: end if;
746: --
747: -- Added for bug 4555325

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

750: FETCH c_user_table_name into l_exists;
751: CLOSE c_user_table_name;
752:
753: if l_exists is null then
754: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
755: hr_utility.raise_error;
756: end if;
757: -- end for bug 4555325
758: end if;

Line 755: hr_utility.raise_error;

751: CLOSE c_user_table_name;
752:
753: if l_exists is null then
754: hr_utility.set_message(8303, 'PQP_230515_INVALID_QUALIFIER');
755: hr_utility.raise_error;
756: end if;
757: -- end for bug 4555325
758: end if;
759:

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

756: end if;
757: -- end for bug 4555325
758: end if;
759:
760: hr_utility.set_location('Entering:'||l_proc, 10);
761: --
762: end chk_qualifier;
763: --
764: --

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

783: close c_input_value ;
784:
785: if l_exists is null then
786: --
787: hr_utility.set_message(8303, 'PQP_230021_INVALID_INPUT_VALUE');
788: hr_utility.raise_error;
789: --
790: end if;
791:

Line 788: hr_utility.raise_error;

784:
785: if l_exists is null then
786: --
787: hr_utility.set_message(8303, 'PQP_230021_INVALID_INPUT_VALUE');
788: hr_utility.raise_error;
789: --
790: end if;
791:
792: end chk_input_value ;

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

850: -- end bug 4555325
851:
852: begin
853:
854: hr_utility.set_location('Entering:'||l_proc,10);
855:
856: if p_eei_information2 not in ('RT','EN') then
857:
858: -- % or Factor Value OR % or Factor Input Value

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

860: -- is Element Name or Rate Type
861:
862: if p_eei_information8 is not null or
863: p_eei_information9 is not null then
864: hr_utility.set_message(8303, 'PQP_230017_CALC_TYPE');
865: hr_utility.raise_error;
866: end if;
867:
868: else

Line 865: hr_utility.raise_error;

861:
862: if p_eei_information8 is not null or
863: p_eei_information9 is not null then
864: hr_utility.set_message(8303, 'PQP_230017_CALC_TYPE');
865: hr_utility.raise_error;
866: end if;
867:
868: else
869:

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

870: -- If Pay Source Value is in Element Name or Rate Type
871:
872: -- % or Factor Type is Mandatory
873: if p_eei_information7 is null then
874: hr_utility.set_message(8303, 'PQP_230018_CALC_TYPE_MAND');
875: hr_utility.raise_error;
876: end if;
877:
878: -- When the Pay Source Value is either Rate Type or Element Name

Line 875: hr_utility.raise_error;

871:
872: -- % or Factor Type is Mandatory
873: if p_eei_information7 is null then
874: hr_utility.set_message(8303, 'PQP_230018_CALC_TYPE_MAND');
875: hr_utility.raise_error;
876: end if;
877:
878: -- When the Pay Source Value is either Rate Type or Element Name
879: -- then either Calculation Value or Input Value Name should be entered.

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

879: -- then either Calculation Value or Input Value Name should be entered.
880: -- ( please note that only one should be entered )
881: if p_eei_information8 is null and
882: p_eei_information9 is null then
883: hr_utility.set_message(8303, 'PQP_230019_CALC_VAL_OR_INPUT');
884: hr_utility.raise_error;
885: end if;
886: if p_eei_information8 is not null and
887: p_eei_information9 is not null then

Line 884: hr_utility.raise_error;

880: -- ( please note that only one should be entered )
881: if p_eei_information8 is null and
882: p_eei_information9 is null then
883: hr_utility.set_message(8303, 'PQP_230019_CALC_VAL_OR_INPUT');
884: hr_utility.raise_error;
885: end if;
886: if p_eei_information8 is not null and
887: p_eei_information9 is not null then
888: hr_utility.set_message(8303, 'PQP_230019_CALC_VAL_OR_INPUT');

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

884: hr_utility.raise_error;
885: end if;
886: if p_eei_information8 is not null and
887: p_eei_information9 is not null then
888: hr_utility.set_message(8303, 'PQP_230019_CALC_VAL_OR_INPUT');
889: hr_utility.raise_error;
890: end if;
891: end if;
892:

Line 889: hr_utility.raise_error;

885: end if;
886: if p_eei_information8 is not null and
887: p_eei_information9 is not null then
888: hr_utility.set_message(8303, 'PQP_230019_CALC_VAL_OR_INPUT');
889: hr_utility.raise_error;
890: end if;
891: end if;
892:
893: -- Validate that Input Value Name entered is correct

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

899: -- If Pay Source Value is other than Input Value then
900: -- Link to Assignment is Mandatory.
901: if p_eei_information2 <> 'IV' then
902: if p_eei_information10 is null then
903: hr_utility.set_message(8303, 'PQP_230020_ASSIGN_MAND');
904: hr_utility.raise_error;
905: end if;
906: end if;
907: -- Added validation for bug 4555325

Line 904: hr_utility.raise_error;

900: -- Link to Assignment is Mandatory.
901: if p_eei_information2 <> 'IV' then
902: if p_eei_information10 is null then
903: hr_utility.set_message(8303, 'PQP_230020_ASSIGN_MAND');
904: hr_utility.raise_error;
905: end if;
906: end if;
907: -- Added validation for bug 4555325
908: IF p_eei_information2 = 'TV' then

Line 911: hr_utility.set_message(8303, 'PQP_230399_USER_COLUMN_ROW_VAL');

907: -- Added validation for bug 4555325
908: IF p_eei_information2 = 'TV' then
909: if p_eei_information16 is null or p_eei_information17 is null or
910: p_eei_information18 is null or p_eei_information19 is null then
911: hr_utility.set_message(8303, 'PQP_230399_USER_COLUMN_ROW_VAL');
912: hr_utility.raise_error;
913: end if;
914: -- validate column values
915: IF p_eei_information16 = 'DN' then

Line 912: hr_utility.raise_error;

908: IF p_eei_information2 = 'TV' then
909: if p_eei_information16 is null or p_eei_information17 is null or
910: p_eei_information18 is null or p_eei_information19 is null then
911: hr_utility.set_message(8303, 'PQP_230399_USER_COLUMN_ROW_VAL');
912: hr_utility.raise_error;
913: end if;
914: -- validate column values
915: IF p_eei_information16 = 'DN' then
916: open c_get_column_name;

Line 920: hr_utility.set_message(8303, 'PQP_230445_INVAL_USER_COL_NAME');

916: open c_get_column_name;
917: FETCH c_get_column_name into l_exists;
918: CLOSE c_get_column_name;
919: IF l_exists is null THEN
920: hr_utility.set_message(8303, 'PQP_230445_INVAL_USER_COL_NAME');
921: hr_utility.set_message_token('COLUMN_NAME',p_eei_information17);
922: hr_utility.set_message_token('TABLE_NAME',p_eei_information3);
923: fnd_message.raise_error;
924: END IF;

Line 921: hr_utility.set_message_token('COLUMN_NAME',p_eei_information17);

917: FETCH c_get_column_name into l_exists;
918: CLOSE c_get_column_name;
919: IF l_exists is null THEN
920: hr_utility.set_message(8303, 'PQP_230445_INVAL_USER_COL_NAME');
921: hr_utility.set_message_token('COLUMN_NAME',p_eei_information17);
922: hr_utility.set_message_token('TABLE_NAME',p_eei_information3);
923: fnd_message.raise_error;
924: END IF;
925: else

Line 922: hr_utility.set_message_token('TABLE_NAME',p_eei_information3);

918: CLOSE c_get_column_name;
919: IF l_exists is null THEN
920: hr_utility.set_message(8303, 'PQP_230445_INVAL_USER_COL_NAME');
921: hr_utility.set_message_token('COLUMN_NAME',p_eei_information17);
922: hr_utility.set_message_token('TABLE_NAME',p_eei_information3);
923: fnd_message.raise_error;
924: END IF;
925: else
926: -- note cant use the this procedure as message displayed is incorrect.

Line 931: hr_utility.set_message(8303, 'PQP_230256_INVAL_USER_COL_INP');

927: open c_input_value(p_eei_information17) ;
928: fetch c_input_value into l_exists ;
929: close c_input_value ;
930: if l_exists is null then
931: hr_utility.set_message(8303, 'PQP_230256_INVAL_USER_COL_INP');
932: hr_utility.raise_error;
933: end if;
934:
935: end if;

Line 932: hr_utility.raise_error;

928: fetch c_input_value into l_exists ;
929: close c_input_value ;
930: if l_exists is null then
931: hr_utility.set_message(8303, 'PQP_230256_INVAL_USER_COL_INP');
932: hr_utility.raise_error;
933: end if;
934:
935: end if;
936: -- validate row values.

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

939: OPEN c_get_row_name;
940: FETCH c_get_row_name into l_exists;
941: CLOSE c_get_row_name;
942: IF l_exists is null then
943: hr_utility.set_message(8303, 'PQP_230296_INVAL_USER_ROW_NAME');
944: hr_utility.set_message_token('ROW_NAME',p_eei_information19);
945: hr_utility.set_message_token('TABLE_NAME',p_eei_information3);
946: hr_utility.raise_error;
947: END IF;

Line 944: hr_utility.set_message_token('ROW_NAME',p_eei_information19);

940: FETCH c_get_row_name into l_exists;
941: CLOSE c_get_row_name;
942: IF l_exists is null then
943: hr_utility.set_message(8303, 'PQP_230296_INVAL_USER_ROW_NAME');
944: hr_utility.set_message_token('ROW_NAME',p_eei_information19);
945: hr_utility.set_message_token('TABLE_NAME',p_eei_information3);
946: hr_utility.raise_error;
947: END IF;
948: else

Line 945: hr_utility.set_message_token('TABLE_NAME',p_eei_information3);

941: CLOSE c_get_row_name;
942: IF l_exists is null then
943: hr_utility.set_message(8303, 'PQP_230296_INVAL_USER_ROW_NAME');
944: hr_utility.set_message_token('ROW_NAME',p_eei_information19);
945: hr_utility.set_message_token('TABLE_NAME',p_eei_information3);
946: hr_utility.raise_error;
947: END IF;
948: else
949: open c_input_value(p_eei_information19) ;

Line 946: hr_utility.raise_error;

942: IF l_exists is null then
943: hr_utility.set_message(8303, 'PQP_230296_INVAL_USER_ROW_NAME');
944: hr_utility.set_message_token('ROW_NAME',p_eei_information19);
945: hr_utility.set_message_token('TABLE_NAME',p_eei_information3);
946: hr_utility.raise_error;
947: END IF;
948: else
949: open c_input_value(p_eei_information19) ;
950: fetch c_input_value into l_exists ;

Line 953: hr_utility.set_message(8303, 'PQP_230443_INVAL_USER_ROW_INP');

949: open c_input_value(p_eei_information19) ;
950: fetch c_input_value into l_exists ;
951: close c_input_value ;
952: if l_exists is null then
953: hr_utility.set_message(8303, 'PQP_230443_INVAL_USER_ROW_INP');
954: hr_utility.raise_error;
955: end if;
956: end if;
957:

Line 954: hr_utility.raise_error;

950: fetch c_input_value into l_exists ;
951: close c_input_value ;
952: if l_exists is null then
953: hr_utility.set_message(8303, 'PQP_230443_INVAL_USER_ROW_INP');
954: hr_utility.raise_error;
955: end if;
956: end if;
957:
958: END IF;

Line 966: hr_utility.set_message(8303, 'PQP_230453_TV_VALUE');

962: -- Pay source is User Table
963:
964: if p_eei_information17 is not null or
965: p_eei_information19 is not null then
966: hr_utility.set_message(8303, 'PQP_230453_TV_VALUE');
967: hr_utility.raise_error;
968: end if;
969: END IF;
970: -- End bug 4555325

Line 967: hr_utility.raise_error;

963:
964: if p_eei_information17 is not null or
965: p_eei_information19 is not null then
966: hr_utility.set_message(8303, 'PQP_230453_TV_VALUE');
967: hr_utility.raise_error;
968: end if;
969: END IF;
970: -- End bug 4555325
971:

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

968: end if;
969: END IF;
970: -- End bug 4555325
971:
972: hr_utility.set_location('Leaving:'||l_proc,20);
973:
974: end chk_mandatory_params;
975: -- ----------------------------------------------------------------------------
976: -- |---------------------------< chk_duplicate_rate_type >--------------------|

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

993: and eei_information1 = p_rate_type;
994:
995: begin
996: --
997: hr_utility.set_location('Entering:'||l_proc, 5);
998:
999: open c_duplicate;
1000: fetch c_duplicate into l_result;
1001: close c_duplicate;

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

1001: close c_duplicate;
1002:
1003: if l_result = 1 then
1004: --
1005: hr_utility.set_message(8303, 'PQP_230516_DUPLICATE_RATE_TYPE');
1006: hr_utility.raise_error;
1007: --
1008: end if;
1009:

Line 1006: hr_utility.raise_error;

1002:
1003: if l_result = 1 then
1004: --
1005: hr_utility.set_message(8303, 'PQP_230516_DUPLICATE_RATE_TYPE');
1006: hr_utility.raise_error;
1007: --
1008: end if;
1009:
1010: hr_utility.set_location('Leaving:'||l_proc, 10);

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

1006: hr_utility.raise_error;
1007: --
1008: end if;
1009:
1010: hr_utility.set_location('Leaving:'||l_proc, 10);
1011: --
1012: end chk_duplicate_rate_type;
1013: --
1014: -- ----------------------------------------------------------------------------

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

1097: where element_type_id = p_element_type_id
1098: and information_type = p_info_type;
1099: begin
1100: --
1101: hr_utility.set_location('Entering:'||l_proc, 5);
1102:
1103:
1104: open c_is_advanced_retro_enabled;
1105: fetch c_is_advanced_retro_enabled into l_is_advanced_retro_enabled;

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

1118:
1119: if l_result = 1 then
1120: --
1121: if p_information_type = 'PQP_GB_PENSERV_ALLOWANCE_INFO' then
1122: hr_utility.set_message(8303, 'PQP_230501_DUP_ALLOWANCE_CODE');
1123: elsif p_information_type = 'PQP_GB_PENSERV_BONUS_INFO' then
1124: hr_utility.set_message(8303, 'PQP_230502_DUP_BONUS_CODE');
1125: end if;
1126:

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

1120: --
1121: if p_information_type = 'PQP_GB_PENSERV_ALLOWANCE_INFO' then
1122: hr_utility.set_message(8303, 'PQP_230501_DUP_ALLOWANCE_CODE');
1123: elsif p_information_type = 'PQP_GB_PENSERV_BONUS_INFO' then
1124: hr_utility.set_message(8303, 'PQP_230502_DUP_BONUS_CODE');
1125: end if;
1126:
1127: hr_utility.raise_error;
1128: --

Line 1127: hr_utility.raise_error;

1123: elsif p_information_type = 'PQP_GB_PENSERV_BONUS_INFO' then
1124: hr_utility.set_message(8303, 'PQP_230502_DUP_BONUS_CODE');
1125: end if;
1126:
1127: hr_utility.raise_error;
1128: --
1129: end if;
1130: ELSE
1131:

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

1135:
1136: if l_result = 1 then
1137: --
1138: if p_information_type = 'PQP_GB_PENSERV_ALLOWANCE_INFO' then
1139: hr_utility.set_message(8303, 'PQP_230501_DUP_ALLOWANCE_CODE');
1140: elsif p_information_type = 'PQP_GB_PENSERV_BONUS_INFO' then
1141: hr_utility.set_message(8303, 'PQP_230502_DUP_BONUS_CODE');
1142: end if;
1143:

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

1137: --
1138: if p_information_type = 'PQP_GB_PENSERV_ALLOWANCE_INFO' then
1139: hr_utility.set_message(8303, 'PQP_230501_DUP_ALLOWANCE_CODE');
1140: elsif p_information_type = 'PQP_GB_PENSERV_BONUS_INFO' then
1141: hr_utility.set_message(8303, 'PQP_230502_DUP_BONUS_CODE');
1142: end if;
1143:
1144: hr_utility.raise_error;
1145: --

Line 1144: hr_utility.raise_error;

1140: elsif p_information_type = 'PQP_GB_PENSERV_BONUS_INFO' then
1141: hr_utility.set_message(8303, 'PQP_230502_DUP_BONUS_CODE');
1142: end if;
1143:
1144: hr_utility.raise_error;
1145: --
1146: end if;
1147:
1148: END IF;

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

1158: FETCH c_element_code_exists INTO l_result;
1159: CLOSE c_element_code_exists;
1160:
1161: IF l_result = 1 THEN
1162: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
1163: hr_utility.set_message_token('TOKEN1','Bonus');
1164: hr_utility.set_message_token('TOKEN2','Allowance');
1165: hr_utility.raise_error;
1166: END IF;

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

1159: CLOSE c_element_code_exists;
1160:
1161: IF l_result = 1 THEN
1162: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
1163: hr_utility.set_message_token('TOKEN1','Bonus');
1164: hr_utility.set_message_token('TOKEN2','Allowance');
1165: hr_utility.raise_error;
1166: END IF;
1167:

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

1160:
1161: IF l_result = 1 THEN
1162: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
1163: hr_utility.set_message_token('TOKEN1','Bonus');
1164: hr_utility.set_message_token('TOKEN2','Allowance');
1165: hr_utility.raise_error;
1166: END IF;
1167:
1168: elsif p_information_type = 'PQP_GB_PENSERV_BONUS_INFO' then

Line 1165: hr_utility.raise_error;

1161: IF l_result = 1 THEN
1162: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
1163: hr_utility.set_message_token('TOKEN1','Bonus');
1164: hr_utility.set_message_token('TOKEN2','Allowance');
1165: hr_utility.raise_error;
1166: END IF;
1167:
1168: elsif p_information_type = 'PQP_GB_PENSERV_BONUS_INFO' then
1169: -- check if the element has Bonus info

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

1174: FETCH c_element_code_exists INTO l_result;
1175: CLOSE c_element_code_exists;
1176:
1177: IF l_result = 1 THEN
1178: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
1179: hr_utility.set_message_token('TOKEN1','Allowance');
1180: hr_utility.set_message_token('TOKEN2','Bonus');
1181: hr_utility.raise_error;
1182: END IF;

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

1175: CLOSE c_element_code_exists;
1176:
1177: IF l_result = 1 THEN
1178: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
1179: hr_utility.set_message_token('TOKEN1','Allowance');
1180: hr_utility.set_message_token('TOKEN2','Bonus');
1181: hr_utility.raise_error;
1182: END IF;
1183:

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

1176:
1177: IF l_result = 1 THEN
1178: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
1179: hr_utility.set_message_token('TOKEN1','Allowance');
1180: hr_utility.set_message_token('TOKEN2','Bonus');
1181: hr_utility.raise_error;
1182: END IF;
1183:
1184: end if;

Line 1181: hr_utility.raise_error;

1177: IF l_result = 1 THEN
1178: hr_utility.set_message(8303, 'PQP_230227_ELEMENT_CODE_EXIST');
1179: hr_utility.set_message_token('TOKEN1','Allowance');
1180: hr_utility.set_message_token('TOKEN2','Bonus');
1181: hr_utility.raise_error;
1182: END IF;
1183:
1184: end if;
1185:

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

1182: END IF;
1183:
1184: end if;
1185:
1186: hr_utility.set_location('Leaving:'||l_proc, 10);
1187: --
1188: end chk_duplicate_element_code;
1189: --
1190:

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

1214:
1215:
1216: begin
1217: --
1218: hr_utility.set_location('Entering:'||l_proc, 5);
1219:
1220: IF p_spread_bonus_flag = 'Y'
1221: THEN
1222:

Line 1229: hr_utility.set_message(8303, 'PQP_230591_INV_SPREAD_BONUS');

1225: close is_ele_spread_bonus;
1226:
1227: IF l_result IS NULL
1228: THEN
1229: hr_utility.set_message(8303, 'PQP_230591_INV_SPREAD_BONUS');
1230: hr_utility.raise_error;
1231: END IF;
1232: END IF;
1233:

Line 1230: hr_utility.raise_error;

1226:
1227: IF l_result IS NULL
1228: THEN
1229: hr_utility.set_message(8303, 'PQP_230591_INV_SPREAD_BONUS');
1230: hr_utility.raise_error;
1231: END IF;
1232: END IF;
1233:
1234: hr_utility.set_location('Leaving:'||l_proc, 10);

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

1230: hr_utility.raise_error;
1231: END IF;
1232: END IF;
1233:
1234: hr_utility.set_location('Leaving:'||l_proc, 10);
1235: --
1236: end chk_allow_spread_bonus_chk;
1237: --
1238: -- ----------------------------------------------------------------------------

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

1263:
1264:
1265: BEGIN
1266: --
1267: hr_utility.set_location('Entering:'||l_proc, 5);
1268:
1269: OPEN csr_get_element_info;
1270: FETCH csr_get_element_info INTO l_element_name,l_processing_type,l_uom;
1271: CLOSE csr_get_element_info;

Line 1274: hr_utility.set_message(8303, 'PQP_230495_REC_BON_ELEMENT');

1270: FETCH csr_get_element_info INTO l_element_name,l_processing_type,l_uom;
1271: CLOSE csr_get_element_info;
1272:
1273: IF upper(l_processing_type) = 'R' THEN
1274: hr_utility.set_message(8303, 'PQP_230495_REC_BON_ELEMENT');
1275: hr_utility.raise_error;
1276: ELSIF l_uom IS NULL THEN
1277: -- no claim date
1278: hr_utility.set_message(8303, 'PQP_230496_BON_NO_CLAIM_DATE');

Line 1275: hr_utility.raise_error;

1271: CLOSE csr_get_element_info;
1272:
1273: IF upper(l_processing_type) = 'R' THEN
1274: hr_utility.set_message(8303, 'PQP_230495_REC_BON_ELEMENT');
1275: hr_utility.raise_error;
1276: ELSIF l_uom IS NULL THEN
1277: -- no claim date
1278: hr_utility.set_message(8303, 'PQP_230496_BON_NO_CLAIM_DATE');
1279: hr_utility.raise_error;

Line 1278: hr_utility.set_message(8303, 'PQP_230496_BON_NO_CLAIM_DATE');

1274: hr_utility.set_message(8303, 'PQP_230495_REC_BON_ELEMENT');
1275: hr_utility.raise_error;
1276: ELSIF l_uom IS NULL THEN
1277: -- no claim date
1278: hr_utility.set_message(8303, 'PQP_230496_BON_NO_CLAIM_DATE');
1279: hr_utility.raise_error;
1280: ELSIF l_uom <> 'D' THEN
1281: -- unit of measure is not date
1282: hr_utility.set_message(8303, 'PQP_230497_BON_INV_CLAIM_DATE');

Line 1279: hr_utility.raise_error;

1275: hr_utility.raise_error;
1276: ELSIF l_uom IS NULL THEN
1277: -- no claim date
1278: hr_utility.set_message(8303, 'PQP_230496_BON_NO_CLAIM_DATE');
1279: hr_utility.raise_error;
1280: ELSIF l_uom <> 'D' THEN
1281: -- unit of measure is not date
1282: hr_utility.set_message(8303, 'PQP_230497_BON_INV_CLAIM_DATE');
1283: hr_utility.raise_error;

Line 1282: hr_utility.set_message(8303, 'PQP_230497_BON_INV_CLAIM_DATE');

1278: hr_utility.set_message(8303, 'PQP_230496_BON_NO_CLAIM_DATE');
1279: hr_utility.raise_error;
1280: ELSIF l_uom <> 'D' THEN
1281: -- unit of measure is not date
1282: hr_utility.set_message(8303, 'PQP_230497_BON_INV_CLAIM_DATE');
1283: hr_utility.raise_error;
1284: END IF;
1285:
1286: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 1283: hr_utility.raise_error;

1279: hr_utility.raise_error;
1280: ELSIF l_uom <> 'D' THEN
1281: -- unit of measure is not date
1282: hr_utility.set_message(8303, 'PQP_230497_BON_INV_CLAIM_DATE');
1283: hr_utility.raise_error;
1284: END IF;
1285:
1286: hr_utility.set_location('Leaving:'||l_proc, 10);
1287: --

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

1282: hr_utility.set_message(8303, 'PQP_230497_BON_INV_CLAIM_DATE');
1283: hr_utility.raise_error;
1284: END IF;
1285:
1286: hr_utility.set_location('Leaving:'||l_proc, 10);
1287: --
1288: END chk_valid_bonus_elements;
1289:
1290: -- ----------------------------------------------------------------------------

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

1305: l_bg pay_element_types_f.business_group_id%type;
1306: l_proc varchar2(72) := g_package||'insert_validate';
1307: --
1308: Begin
1309: hr_utility.set_location('Entering:'||l_proc, 5);
1310: --
1311: -- Set the profile value for 'PAY_ELEMENT_TYPE_ID' for the purpose of valuesets used for payroll simulation
1312: fnd_profile.put('PAY_ELEMENT_TYPE_ID',p_rec.element_type_id);
1313: --

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

1412:
1413:
1414:
1415: --
1416: hr_utility.set_location(' Leaving:'||l_proc, 10);
1417: End insert_validate;
1418: --
1419: -- ----------------------------------------------------------------------------
1420: -- |---------------------------< update_validate >----------------------------|

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

1434: l_bg pay_element_types_f.business_group_id%type;
1435: l_proc varchar2(72) := g_package||'update_validate';
1436: --
1437: Begin
1438: hr_utility.set_location('Entering:'||l_proc, 5);
1439: --
1440: -- Set the profile value for 'PAY_ELEMENT_TYPE_ID' for the purpose of valuesets used for payroll simulation
1441: fnd_profile.put('PAY_ELEMENT_TYPE_ID',p_rec.element_type_id);
1442: --

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

1541: --
1542: end if;
1543:
1544: --
1545: hr_utility.set_location(' Leaving:'||l_proc, 10);
1546: End update_validate;
1547: --
1548: -- ----------------------------------------------------------------------------
1549: -- |---------------------------< delete_validate >----------------------------|

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

1554: --
1555: l_proc varchar2(72) := g_package||'delete_validate';
1556: --
1557: Begin
1558: hr_utility.set_location('Entering:'||l_proc, 5);
1559: --
1560: -- Call all supporting business operations
1561: --
1562: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1558: hr_utility.set_location('Entering:'||l_proc, 5);
1559: --
1560: -- Call all supporting business operations
1561: --
1562: hr_utility.set_location(' Leaving:'||l_proc, 10);
1563: End delete_validate;
1564: ---
1565: end pay_eei_bus;