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

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

32: l_api_updating boolean;
33: l_valid varchar2(1);
34: --
35: Begin
36: hr_utility.set_location('Entering:'||l_proc, 5);
37: open csr_get_template_info;
38: fetch csr_get_template_info
39: into p_business_group_id
40: , p_legislation_code

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

44: if p_business_group_id is not null then
45: p_legislation_code :=
46: hr_api.return_legislation_code(p_business_group_id);
47: end if;
48: hr_utility.set_location(' Leaving:'||l_proc, 15);
49: End get_template_info;
50: -- ----------------------------------------------------------------------------
51: -- |-----------------------< chk_non_updateable_args >------------------------|
52: -- ----------------------------------------------------------------------------

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

70: l_argument varchar2(30);
71: l_disallow varchar2(1);
72: --
73: Begin
74: hr_utility.set_location('Entering:'||l_proc, 5);
75: l_api_updating := pay_set_shd.api_updating
76: (p_element_type_id => p_rec.element_type_id
77: ,p_object_version_number => p_rec.object_version_number
78: );

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

76: (p_element_type_id => p_rec.element_type_id
77: ,p_object_version_number => p_rec.object_version_number
78: );
79: if not l_api_updating then
80: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
81: hr_utility.set_message_token('PROCEDURE', l_proc);
82: hr_utility.set_message_token('STEP', '10');
83: hr_utility.raise_error;
84: end if;

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

77: ,p_object_version_number => p_rec.object_version_number
78: );
79: if not l_api_updating then
80: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
81: hr_utility.set_message_token('PROCEDURE', l_proc);
82: hr_utility.set_message_token('STEP', '10');
83: hr_utility.raise_error;
84: end if;
85: --

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

78: );
79: if not l_api_updating then
80: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
81: hr_utility.set_message_token('PROCEDURE', l_proc);
82: hr_utility.set_message_token('STEP', '10');
83: hr_utility.raise_error;
84: end if;
85: --
86: hr_utility.set_location(l_proc, 20);

Line 83: hr_utility.raise_error;

79: if not l_api_updating then
80: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
81: hr_utility.set_message_token('PROCEDURE', l_proc);
82: hr_utility.set_message_token('STEP', '10');
83: hr_utility.raise_error;
84: end if;
85: --
86: hr_utility.set_location(l_proc, 20);
87: --

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

82: hr_utility.set_message_token('STEP', '10');
83: hr_utility.raise_error;
84: end if;
85: --
86: hr_utility.set_location(l_proc, 20);
87: --
88: -- Check that the update is actually allowed.
89: --
90: open csr_disallow_update;

Line 93: hr_utility.set_location(l_proc, 25);

89: --
90: open csr_disallow_update;
91: fetch csr_disallow_update into l_disallow;
92: if csr_disallow_update%found then
93: hr_utility.set_location(l_proc, 25);
94: close csr_disallow_update;
95: fnd_message.set_name('PAY', 'PAY_50137_SET_CORE_ROW_EXISTS');
96: fnd_message.raise_error;
97: end if;

Line 110: hr_utility.set_location('Leaving:'||l_proc, 35);

106: then
107: l_argument := 'p_template_id';
108: raise l_error;
109: end if;
110: hr_utility.set_location('Leaving:'||l_proc, 35);
111: exception
112: when l_error then
113: hr_utility.set_location('Leaving:'||l_proc, 40);
114: hr_api.argument_changed_error

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

109: end if;
110: hr_utility.set_location('Leaving:'||l_proc, 35);
111: exception
112: when l_error then
113: hr_utility.set_location('Leaving:'||l_proc, 40);
114: hr_api.argument_changed_error
115: (p_api_name => l_proc
116: ,p_argument => l_argument);
117: when others then

Line 118: hr_utility.set_location('Leaving:'||l_proc, 45);

114: hr_api.argument_changed_error
115: (p_api_name => l_proc
116: ,p_argument => l_argument);
117: when others then
118: hr_utility.set_location('Leaving:'||l_proc, 45);
119: raise;
120: End chk_non_updateable_args;
121: -- ----------------------------------------------------------------------------
122: -- |---------------------------< chk_template_id >----------------------------|

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

135: l_proc varchar2(72) := g_package||'chk_template_id';
136: l_valid varchar2(1);
137: --
138: Begin
139: hr_utility.set_location('Entering:'||l_proc, 5);
140: --
141: -- Check that template_id is not null.
142: --
143: hr_api.mandatory_arg_error

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

150: --
151: open csr_template_id_valid;
152: fetch csr_template_id_valid into l_valid;
153: if csr_template_id_valid%notfound then
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: close csr_template_id_valid;
156: fnd_message.set_name('PAY', 'PAY_50114_ETM_INVALID_TEMPLATE');
157: fnd_message.raise_error;
158: end if;

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

156: fnd_message.set_name('PAY', 'PAY_50114_ETM_INVALID_TEMPLATE');
157: fnd_message.raise_error;
158: end if;
159: close csr_template_id_valid;
160: hr_utility.set_location(' Leaving:'||l_proc, 15);
161: End chk_template_id;
162: -- ----------------------------------------------------------------------------
163: -- |------------------------< chk_classification_name >-----------------------|
164: -- ----------------------------------------------------------------------------

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

171: l_proc varchar2(72) := g_package||'chk_classification_name';
172: l_api_updating boolean;
173: --
174: Begin
175: hr_utility.set_location('Entering:'||l_proc, 5);
176: l_api_updating := pay_set_shd.api_updating
177: (p_element_type_id => p_element_type_id
178: ,p_object_version_number => p_object_version_number
179: );

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

189: ,p_argument => 'p_classification_name'
190: ,p_argument_value => p_classification_name
191: );
192: end if;
193: hr_utility.set_location(' Leaving:'||l_proc, 15);
194: End chk_classification_name;
195: -- ----------------------------------------------------------------------------
196: -- |-----------------------------< chk_lookups >------------------------------|
197: -- ----------------------------------------------------------------------------

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

272: end if;
273: end chk_lookup;
274: --
275: Begin
276: hr_utility.set_location('Entering:'||l_proc, 5);
277: l_api_updating := pay_set_shd.api_updating
278: (p_element_type_id => p_element_type_id
279: ,p_object_version_number => p_object_version_number
280: );

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

543: ,p_mandatory => false
544: ,p_updatable => true
545: ,p_api_updating => l_api_updating
546: );
547: hr_utility.set_location(' Leaving:'||l_proc, 15);
548: End chk_lookups;
549: -- ----------------------------------------------------------------------------
550: -- |---------------------------< chk_element_name >---------------------------|
551: -- ----------------------------------------------------------------------------

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

589: l_nullok varchar2(2000);
590: l_api_updating boolean;
591: --
592: Begin
593: hr_utility.set_location('Entering:'||l_proc, 5);
594: l_api_updating := pay_set_shd.api_updating
595: (p_element_type_id => p_element_type_id
596: ,p_object_version_number => p_object_version_number
597: );

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

638: open csr_T_element_name_exists;
639: fetch csr_T_element_name_exists into l_exists;
640: if csr_T_element_name_exists%found then
641: close csr_T_element_name_exists;
642: hr_utility.set_location(' Leaving:'||l_proc, 10);
643: fnd_message.set_name('PAY', 'PAY_50139_SET_ELEMENT_EXISTS');
644: fnd_message.set_token('ELEMENT_NAME', p_element_name);
645: fnd_message.raise_error;
646: end if;

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

652: open csr_U_element_name_exists;
653: fetch csr_U_element_name_exists into l_exists;
654: if csr_U_element_name_exists%found then
655: close csr_U_element_name_exists;
656: hr_utility.set_location(' Leaving:'||l_proc, 15);
657: fnd_message.set_name('PAY', 'PAY_50139_SET_ELEMENT_EXISTS');
658: fnd_message.set_token('ELEMENT_NAME', p_element_name);
659: fnd_message.raise_error;
660: end if;

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

660: end if;
661: close csr_U_element_name_exists;
662: end if;
663: end if;
664: hr_utility.set_location(' Leaving:'||l_proc, 20);
665: End chk_element_name;
666: -- ----------------------------------------------------------------------------
667: -- |---------------------< chk_processing_priority >--------------------------|
668: -- ----------------------------------------------------------------------------

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

679: l_upper constant number := pay_etm_shd.g_max_processing_priority;
680: l_too_large varchar2(1);
681: --
682: Begin
683: hr_utility.set_location('Entering:'||l_proc, 5);
684: l_api_updating := pay_set_shd.api_updating
685: (p_element_type_id => p_element_type_id
686: ,p_object_version_number => p_object_version_number
687: );

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

704: --
705: if (p_relative_processing_priority < l_lower - p_base_processing_priority) or
706: (p_relative_processing_priority > l_upper - p_base_processing_priority)
707: then
708: hr_utility.set_location(' Leaving:'||l_proc, 15);
709: fnd_message.set_name('PAY', 'PAY_50140_SET_PRI_SUM_RANGE');
710: fnd_message.set_token('PRIORITY', p_relative_processing_priority);
711: fnd_message.set_token('LOWER', l_lower);
712: fnd_message.set_token('UPPER', l_upper);

Line 716: hr_utility.set_location(' Leaving:'||l_proc, 25);

712: fnd_message.set_token('UPPER', l_upper);
713: fnd_message.raise_error;
714: end if;
715: end if;
716: hr_utility.set_location(' Leaving:'||l_proc, 25);
717: End chk_processing_priority;
718: -- ----------------------------------------------------------------------------
719: -- |--------------------------< chk_input_currency_code >---------------------|
720: -- ----------------------------------------------------------------------------

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

737: l_api_updating boolean;
738: l_valid varchar2(1);
739: --
740: Begin
741: hr_utility.set_location('Entering:'||l_proc, 5);
742: l_api_updating := pay_set_shd.api_updating
743: (p_element_type_id => p_element_type_id
744: ,p_object_version_number => p_object_version_number
745: );

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

750: if p_input_currency_code is not null then
751: open csr_valid_currency_code;
752: fetch csr_valid_currency_code into l_valid;
753: if csr_valid_currency_code%notfound then
754: hr_utility.set_location(' Leaving:'||l_proc, 10);
755: close csr_valid_currency_code;
756: fnd_message.set_name('PAY', 'HR_51855_QUA_CCY_INV');
757: fnd_message.raise_error;
758: end if;

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

757: fnd_message.raise_error;
758: end if;
759: close csr_valid_currency_code;
760: end if;
761: hr_utility.set_location(' Leaving:'||l_proc, 15);
762: end if;
763: End chk_input_currency_code;
764: -- ----------------------------------------------------------------------------
765: -- |-------------------------< chk_output_currency_code >---------------------|

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

783: l_api_updating boolean;
784: l_valid varchar2(1);
785: --
786: Begin
787: hr_utility.set_location('Entering:'||l_proc, 5);
788: l_api_updating := pay_set_shd.api_updating
789: (p_element_type_id => p_element_type_id
790: ,p_object_version_number => p_object_version_number
791: );

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

796: if p_output_currency_code is not null then
797: open csr_valid_currency_code;
798: fetch csr_valid_currency_code into l_valid;
799: if csr_valid_currency_code%notfound then
800: hr_utility.set_location(' Leaving:'||l_proc, 10);
801: close csr_valid_currency_code;
802: fnd_message.set_name('PAY', 'HR_51855_QUA_CCY_INV');
803: fnd_message.raise_error;
804: end if;

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

803: fnd_message.raise_error;
804: end if;
805: close csr_valid_currency_code;
806: end if;
807: hr_utility.set_location(' Leaving:'||l_proc, 15);
808: end if;
809: End chk_output_currency_code;
810: -- ----------------------------------------------------------------------------
811: -- |---------------------< chk_payroll_formula_id >---------------------------|

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

856: l_api_updating boolean;
857: l_valid varchar2(1);
858: --
859: Begin
860: hr_utility.set_location('Entering:'||l_proc, 5);
861: l_api_updating := pay_set_shd.api_updating
862: (p_element_type_id => p_element_type_id
863: ,p_object_version_number => p_object_version_number
864: );

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

870: if p_template_type = 'T' then
871: open csr_T_formula_valid;
872: fetch csr_T_formula_valid into l_valid;
873: if csr_T_formula_valid%notfound then
874: hr_utility.set_location(' Leaving:'||l_proc, 10);
875: close csr_T_formula_valid;
876: fnd_message.set_name('PAY', 'PAY_50141_SET_BAD_PAY_FORMULA');
877: fnd_message.raise_error;
878: end if;

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

880: elsif p_template_type = 'U' then
881: open csr_U_formula_valid;
882: fetch csr_U_formula_valid into l_valid;
883: if csr_U_formula_valid%notfound then
884: hr_utility.set_location(' Leaving:'||l_proc, 15);
885: close csr_U_formula_valid;
886: fnd_message.set_name('PAY', 'PAY_50141_SET_BAD_PAY_FORMULA');
887: fnd_message.raise_error;
888: end if;

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

889: close csr_U_formula_valid;
890: end if;
891: end if;
892: end if;
893: hr_utility.set_location(' Leaving:'||l_proc, 20);
894: End chk_payroll_formula_id;
895: -- ----------------------------------------------------------------------------
896: -- |-------------------------< chk_exclusion_rule_id >------------------------|
897: -- ----------------------------------------------------------------------------

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

914: l_api_updating boolean;
915: l_valid varchar2(1);
916: --
917: Begin
918: hr_utility.set_location('Entering:'||l_proc, 5);
919: l_api_updating := pay_set_shd.api_updating
920: (p_element_type_id => p_element_type_id
921: ,p_object_version_number => p_object_version_number
922: );

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

927: if p_exclusion_rule_id is not null then
928: open csr_exclusion_rule_id_valid;
929: fetch csr_exclusion_rule_id_valid into l_valid;
930: if csr_exclusion_rule_id_valid%notfound then
931: hr_utility.set_location('Leaving:'||l_proc, 10);
932: close csr_exclusion_rule_id_valid;
933: fnd_message.set_name('PAY', 'PAY_50100_ETM_INVALID_EXC_RULE');
934: fnd_message.raise_error;
935: end if;

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

935: end if;
936: close csr_exclusion_rule_id_valid;
937: end if;
938: end if;
939: hr_utility.set_location(' Leaving:'||l_proc, 15);
940: End chk_exclusion_rule_id;
941: --
942: -- ----------------------------------------------------------------------------
943: -- |----------------------------< chk_iterative_flag >------------------------|

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

949: --
950: l_proc varchar2(72) := g_package||'chk_iterative_flag';
951: --
952: Begin
953: hr_utility.set_location('Entering:'||l_proc, 5);
954: if (p_grossup_flag = 'Y' and p_iterative_flag <> 'Y') then
955: fnd_message.set_name('PAY', 'PAY_34147_ELE_ITR_GROSSUP');
956: fnd_message.raise_error;
957: end if;

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

954: if (p_grossup_flag = 'Y' and p_iterative_flag <> 'Y') then
955: fnd_message.set_name('PAY', 'PAY_34147_ELE_ITR_GROSSUP');
956: fnd_message.raise_error;
957: end if;
958: hr_utility.set_location(' Leaving:'||l_proc, 10);
959: End chk_iterative_flag;
960: --
961: -- ----------------------------------------------------------------------------
962: -- |-----------------------< chk_iterative_priority >-------------------------|

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

968: --
969: l_proc varchar2(72) := g_package||'chk_iterative_priority';
970: --
971: Begin
972: hr_utility.set_location('Entering:'||l_proc, 5);
973: if (p_iterative_flag = 'N' and p_iterative_priority is not null) then
974: fnd_message.set_name('PAY', 'PAY_34144_ELE_ITR_NO_FORML_PRI');
975: fnd_message.raise_error;
976: end if;

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

973: if (p_iterative_flag = 'N' and p_iterative_priority is not null) then
974: fnd_message.set_name('PAY', 'PAY_34144_ELE_ITR_NO_FORML_PRI');
975: fnd_message.raise_error;
976: end if;
977: hr_utility.set_location(' Leaving:'||l_proc, 10);
978: End chk_iterative_priority;
979: --
980: -- ----------------------------------------------------------------------------
981: -- |--------------------< chk_iterative_formula_name >------------------------|

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

987: --
988: l_proc varchar2(72) := g_package||'chk_iterative_formula_name';
989: --
990: Begin
991: hr_utility.set_location('Entering:'||l_proc, 5);
992: if p_iterative_flag is not null then
993: if (p_iterative_flag = 'N' and p_iterative_formula_name is not null) then
994: fnd_message.set_name('PAY', 'PAY_34144_ELE_ITR_NO_FORML_PRI');
995: fnd_message.raise_error;

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

998: fnd_message.set_name('PAY', 'PAY_34146_ELE_ITR_FORML_REQD');
999: fnd_message.raise_error;
1000: end if;
1001: end if;
1002: hr_utility.set_location(' Leaving:'||l_proc, 10);
1003: End chk_iterative_formula_name;
1004: --
1005: -- ----------------------------------------------------------------------------
1006: -- |--------------------------< chk_process_mode >----------------------------|

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

1012: --
1013: l_proc varchar2(72) := g_package||'chk_process_mode';
1014: --
1015: Begin
1016: hr_utility.set_location('Entering:'||l_proc, 5);
1017: if (p_grossup_flag = 'Y' and p_process_mode = 'N') then
1018: fnd_message.set_name('PAY', 'PAY_50093_ELE_GROSSUP_PROC_MOD');
1019: fnd_message.raise_error;
1020: end if;

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

1022: if (p_process_mode not in ('N','S','P')) then
1023: fnd_message.set_name('PAY', 'PAY_34148_ELE_PROC_MODE');
1024: fnd_message.raise_error;
1025: end if;
1026: hr_utility.set_location(' Leaving:'||l_proc, 10);
1027: End chk_process_mode;
1028: --
1029: -- ----------------------------------------------------------------------------
1030: -- |------------------------------< chk_delete >------------------------------|

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

1082: l_error exception;
1083: l_exists varchar2(1);
1084: --
1085: Begin
1086: hr_utility.set_location('Entering:'||l_proc, 5);
1087: --
1088: open csr_input_values;
1089: fetch csr_input_values into l_exists;
1090: if csr_input_values%found then

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

1087: --
1088: open csr_input_values;
1089: fetch csr_input_values into l_exists;
1090: if csr_input_values%found then
1091: hr_utility.set_location(' Leaving:'||l_proc, 10);
1092: close csr_input_values;
1093: raise l_error;
1094: end if;
1095: close csr_input_values;

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

1096: --
1097: open csr_core_objects;
1098: fetch csr_core_objects into l_exists;
1099: if csr_core_objects%found then
1100: hr_utility.set_location(' Leaving:'||l_proc, 15);
1101: close csr_core_objects;
1102: raise l_error;
1103: end if;
1104: close csr_core_objects;

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

1105: --
1106: open csr_formula_rules;
1107: fetch csr_formula_rules into l_exists;
1108: if csr_formula_rules%found then
1109: hr_utility.set_location(' Leaving:'||l_proc, 20);
1110: close csr_formula_rules;
1111: raise l_error;
1112: end if;
1113: close csr_formula_rules;

Line 1118: hr_utility.set_location(' Leaving:'||l_proc, 25);

1114: --
1115: open csr_sub_classi_rules;
1116: fetch csr_sub_classi_rules into l_exists;
1117: if csr_sub_classi_rules%found then
1118: hr_utility.set_location(' Leaving:'||l_proc, 25);
1119: close csr_sub_classi_rules;
1120: raise l_error;
1121: end if;
1122: close csr_sub_classi_rules;

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

1123: --
1124: open csr_iterative_rules;
1125: fetch csr_iterative_rules into l_exists;
1126: if csr_iterative_rules%found then
1127: hr_utility.set_location(' Leaving:'||l_proc, 30);
1128: close csr_iterative_rules;
1129: raise l_error;
1130: end if;
1131: close csr_iterative_rules;

Line 1136: hr_utility.set_location(' Leaving:'||l_proc, 35);

1132: --
1133: open csr_ele_type_usages;
1134: fetch csr_ele_type_usages into l_exists;
1135: if csr_ele_type_usages%found then
1136: hr_utility.set_location(' Leaving:'||l_proc, 35);
1137: close csr_ele_type_usages;
1138: raise l_error;
1139: end if;
1140: close csr_ele_type_usages;

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

1141: --
1142: open csr_gu_bal_exclusions;
1143: fetch csr_gu_bal_exclusions into l_exists;
1144: if csr_gu_bal_exclusions%found then
1145: hr_utility.set_location(' Leaving:'||l_proc, 40);
1146: close csr_gu_bal_exclusions;
1147: raise l_error;
1148: end if;
1149: close csr_gu_bal_exclusions;

Line 1154: hr_utility.set_location(' Leaving:'||l_proc, 45);

1150: --
1151: open csr_template_ff_usages;
1152: fetch csr_template_ff_usages into l_exists;
1153: if csr_template_ff_usages%found then
1154: hr_utility.set_location(' Leaving:'||l_proc, 45);
1155: close csr_template_ff_usages;
1156: raise l_error;
1157: end if;
1158: close csr_template_ff_usages;

Line 1164: hr_utility.set_location(' Leaving:'||l_proc, 200);

1160: when l_error then
1161: fnd_message.set_name('PAY', 'PAY_50138_SET_INVALID_DELETE');
1162: fnd_message.raise_error;
1163: when others then
1164: hr_utility.set_location(' Leaving:'||l_proc, 200);
1165: raise;
1166: hr_utility.set_location(' Leaving:'||l_proc, 205);
1167: End chk_delete;
1168: -- ----------------------------------------------------------------------------

Line 1166: hr_utility.set_location(' Leaving:'||l_proc, 205);

1162: fnd_message.raise_error;
1163: when others then
1164: hr_utility.set_location(' Leaving:'||l_proc, 200);
1165: raise;
1166: hr_utility.set_location(' Leaving:'||l_proc, 205);
1167: End chk_delete;
1168: -- ----------------------------------------------------------------------------
1169: -- |---------------------------< insert_validate >----------------------------|
1170: -- ----------------------------------------------------------------------------

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

1179: l_template_type varchar2(2000);
1180: l_base_processing_priority number;
1181: --
1182: Begin
1183: hr_utility.set_location('Entering:'||l_proc, 5);
1184: --
1185: -- Call all supporting business operations
1186: --
1187: chk_template_id(p_template_id => p_rec.template_id);

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

1288: chk_process_mode
1289: (p_process_mode => p_rec.process_mode
1290: ,p_grossup_flag => p_rec.grossup_flag
1291: );
1292: hr_utility.set_location(' Leaving:'||l_proc, 10);
1293: End insert_validate;
1294: --
1295: -- ----------------------------------------------------------------------------
1296: -- |---------------------------< update_validate >----------------------------|

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

1306: l_template_type varchar2(2000);
1307: l_base_processing_priority number;
1308: --
1309: Begin
1310: hr_utility.set_location('Entering:'||l_proc, 5);
1311: --
1312: -- Call all supporting business operations
1313: --
1314: chk_non_updateable_args(p_rec);

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

1415: chk_process_mode
1416: (p_process_mode => p_rec.process_mode
1417: ,p_grossup_flag => p_rec.grossup_flag
1418: );
1419: hr_utility.set_location(' Leaving:'||l_proc, 10);
1420: End update_validate;
1421: --
1422: -- ----------------------------------------------------------------------------
1423: -- |---------------------------< delete_validate >----------------------------|

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

1426: --
1427: l_proc varchar2(72) := g_package||'delete_validate';
1428: --
1429: Begin
1430: hr_utility.set_location('Entering:'||l_proc, 5);
1431: --
1432: -- Call all supporting business operations
1433: --
1434: chk_delete(p_rec.element_type_id);

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

1431: --
1432: -- Call all supporting business operations
1433: --
1434: chk_delete(p_rec.element_type_id);
1435: hr_utility.set_location(' Leaving:'||l_proc, 10);
1436: End delete_validate;
1437: --
1438: end pay_set_bus;