APPS.PAY_GB_RTI_FPS_ADHOC dependencies on HR_UTILITY

Line 91: hr_utility.set_location ('Inside Create Assignment ID Processed: '|| i.assignment_id,12);

87: ,p_object_version_number => p_ovn
88: ,p_aei_information_category => 'GB_PAY_RTI'
89: ,p_aei_information3 => p_irregular_payments);
90: ELSE
91: hr_utility.set_location ('Inside Create Assignment ID Processed: '|| i.assignment_id,12);
92:
93: hr_assignment_extra_info_api.create_assignment_extra_info
94: (p_validate => FALSE
95: ,p_assignment_id => i.assignment_id

Line 110: hr_utility.trace (' Error : Assignment set id entered '

106:
107: COMMIT;
108: EXCEPTION
109: WHEN invalid_assg_set_id THEN
110: hr_utility.trace (' Error : Assignment set id entered '
111: || p_assignment_set_id
112: || ' is not valid');
113:
114: raise_application_error (- 20001

Line 188: hr_utility.set_location ('Entering: '

184: proc_element_type_id number;
185: duplicate_sub_clas EXCEPTION;
186: both_no_null EXCEPTION;
187: BEGIN
188: hr_utility.set_location ('Entering: '
189: || l_proc_name
190: ,10);
191:
192: IF p_element_type_id IS NULL

Line 204: hr_utility.set_location ('Element Type id: '

200: LOOP
201: FETCH csr_elements
202: INTO proc_element_type_id;
203:
204: hr_utility.set_location ('Element Type id: '
205: || proc_element_type_id
206: ,10);
207:
208: EXIT WHEN csr_elements%NOTFOUND;

Line 236: hr_utility.set_location (l_proc_name

232: END IF;
233:
234: CLOSE csr_get_class_id;
235:
236: hr_utility.set_location (l_proc_name
237: ,20);
238:
239: OPEN csr_sub_class_present (l_sub_classification_id
240: ,proc_element_type_id);

Line 246: hr_utility.set_location ('Sub Classification: '

242: FETCH csr_sub_class_present
243: INTO l_sub_class_rule_id;
244:
245: IF csr_sub_class_present%NOTFOUND THEN
246: hr_utility.set_location ('Sub Classification: '
247: || l_sub_classification_id
248: ,10);
249: select PAY_SUB_CLASSIFICATION_RULES_S.nextval
250: into l_sub_class_rule_id

Line 277: hr_utility.set_location ('Leaving: '

273: END LOOP;
274:
275: CLOSE csr_elements;
276:
277: hr_utility.set_location ('Leaving: '
278: || l_proc_name
279: ,30);
280:
281: COMMIT;

Line 284: hr_utility.set_location ('Duplicate Sub classification '

280:
281: COMMIT;
282: EXCEPTION
283: WHEN duplicate_sub_clas THEN
284: hr_utility.set_location ('Duplicate Sub classification '
285: || sqlerrm
286: ,30);
287:
288: raise_application_error (- 20001

Line 293: hr_utility.set_location ('Both cannot be null '

289: ,' Duplicate Sub classification ');
290:
291: ROLLBACK;
292: WHEN both_no_null THEN
293: hr_utility.set_location ('Both cannot be null '
294: || sqlerrm
295: ,30);
296:
297: raise_application_error (- 20001

Line 302: hr_utility.set_location ('Error: '

298: ,' Both Element set id and Element type id cannot be null ');
299:
300: ROLLBACK;
301: WHEN others THEN
302: hr_utility.set_location ('Error: '
303: || sqlerrm
304: ,30);
305:
306: raise_application_error (- 20001