APPS.PAY_US_CTGY_FEEDS_PKG dependencies on HR_UTILITY

Line 227: hr_utility.set_location('pyusctgf.create_category_feeds',10);

223: FOR i IN 1..l_num_entries LOOP
224: --
225: -- Check if match, if so then create feed.
226: --
227: hr_utility.set_location('pyusctgf.create_category_feeds',10);
228: IF (l_ele_classn = l_classn(i)) and (l_ele_catgry = l_catgry(i)) THEN
229: --
230: -- Get pay value input value for the element
231: --

Line 232: hr_utility.set_location('pyusctgf.create_category_feeds',100);

228: IF (l_ele_classn = l_classn(i)) and (l_ele_catgry = l_catgry(i)) THEN
229: --
230: -- Get pay value input value for the element
231: --
232: hr_utility.set_location('pyusctgf.create_category_feeds',100);
233: SELECT inp.input_value_id
234: INTO l_payval_id
235: FROM pay_input_values_f inp,
236: hr_lookups hl

Line 248: hr_utility.set_location('pyusctgf.create_category_feeds',200);

244: -- If balance not found, then continue.
245: --
246: BEGIN
247:
248: hr_utility.set_location('pyusctgf.create_category_feeds',200);
249: SELECT BT.balance_type_id
250: INTO l_bal_type_id
251: FROM pay_balance_types BT
252: WHERE UPPER(BT.balance_name) = l_balance(i)

Line 267: hr_utility.set_location('pyusctgf.create_category_feeds',300);

263: --
264: IF l_feed_exists = 0 THEN -- skip if feed already exists
265: --
266: -- dbms_output.put_line('insert balance feed..'||to_char(p_element_type_id));
267: hr_utility.set_location('pyusctgf.create_category_feeds',300);
268: hr_balances.ins_balance_feed(
269: p_option => 'INS_MANUAL_FEED',
270: p_input_value_id => l_payval_id,
271: p_element_type_id => NULL,

Line 285: hr_utility.trace('pyusctgf: Failed to find balance type: ' || l_balance(i) || ' --> Skipped.');

281: END IF;
282: -- dbms_output.put_line('balance feed already exists ' || to_char(p_element_type_id));
283: --
284: EXCEPTION WHEN NO_DATA_FOUND THEN
285: hr_utility.trace('pyusctgf: Failed to find balance type: ' || l_balance(i) || ' --> Skipped.');
286: --
287: END;
288: --
289: END IF;