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

Line 150: -- hr_utility.trace(p_element_name ||' element does not exist');

146:
147: CLOSE get_input_value_id;
148: --
149: ELSE
150: -- hr_utility.trace(p_element_name ||' element does not exist');
151: NULL;
152: END IF;
153:
154: CLOSE get_element_type_id;

Line 176: hr_utility.set_location('No Element Found',99);

172: AND legislation_code = 'US';
173:
174: exception
175: when no_data_found then
176: hr_utility.set_location('No Element Found',99);
177:
178: end;
179:
180: update pay_element_types_f

Line 189: hr_utility.set_location('Assoc Primary Bal - NO DATA FOUND',99);

185:
186: EXCEPTION
187: --
188: WHEN NO_DATA_FOUND THEN
189: hr_utility.set_location('Assoc Primary Bal - NO DATA FOUND',99);
190: --
191: WHEN TOO_MANY_ROWS THEN
192: hr_utility.set_location('Assoc Primary Bal - TOO MANY ROWS',99);
193: --

Line 192: hr_utility.set_location('Assoc Primary Bal - TOO MANY ROWS',99);

188: WHEN NO_DATA_FOUND THEN
189: hr_utility.set_location('Assoc Primary Bal - NO DATA FOUND',99);
190: --
191: WHEN TOO_MANY_ROWS THEN
192: hr_utility.set_location('Assoc Primary Bal - TOO MANY ROWS',99);
193: --
194:
195: end;
196: --

Line 209: hr_utility.set_location('pay_assoc_bal.assoc_bal',1);

205: v_ddf_column VARCHAR2(20);
206:
207: BEGIN
208:
209: hr_utility.set_location('pay_assoc_bal.assoc_bal',1);
210: hr_utility.set_location('Element : '||p_element_name,3);
211: hr_utility.set_location('Primary Balance : '||p_balance_name,5);
212: begin
213: SELECT element_type_id

Line 210: hr_utility.set_location('Element : '||p_element_name,3);

206:
207: BEGIN
208:
209: hr_utility.set_location('pay_assoc_bal.assoc_bal',1);
210: hr_utility.set_location('Element : '||p_element_name,3);
211: hr_utility.set_location('Primary Balance : '||p_balance_name,5);
212: begin
213: SELECT element_type_id
214: INTO v_eletype_id

Line 211: hr_utility.set_location('Primary Balance : '||p_balance_name,5);

207: BEGIN
208:
209: hr_utility.set_location('pay_assoc_bal.assoc_bal',1);
210: hr_utility.set_location('Element : '||p_element_name,3);
211: hr_utility.set_location('Primary Balance : '||p_balance_name,5);
212: begin
213: SELECT element_type_id
214: INTO v_eletype_id
215: FROM pay_element_types_f

Line 220: hr_utility.set_location('pay_assoc_bal.assoc_bal',7);

216: WHERE UPPER(element_name) = UPPER(p_element_name)
217: AND business_group_id IS NULL
218: AND legislation_code = 'US';
219:
220: hr_utility.set_location('pay_assoc_bal.assoc_bal',7);
221: SELECT balance_type_id
222: INTO v_baltype_id
223: FROM pay_balance_types
224: WHERE UPPER(balance_name) = UPPER(p_balance_name)

Line 236: hr_utility.set_location('pay_assoc_bal.assoc_bal',9);

232: end;
233:
234: IF UPPER(p_association) = 'PRIMARY BALANCE' THEN
235:
236: hr_utility.set_location('pay_assoc_bal.assoc_bal',9);
237: update pay_element_types_f
238: set ELEMENT_INFORMATION10 = v_baltype_id
239: where element_type_id = v_eletype_id
240: and business_group_id is null

Line 245: hr_utility.set_location('pay_assoc_bal.assoc_bal',11);

241: and legislation_code = 'US';
242:
243: ELSIF UPPER(p_association) IN ('ACCRUED BALANCE', 'GROSS BALANCE') THEN
244:
245: hr_utility.set_location('pay_assoc_bal.assoc_bal',11);
246: update pay_element_types_f
247: set ELEMENT_INFORMATION11 = v_baltype_id
248: where element_type_id = v_eletype_id
249: and business_group_id is null

Line 254: hr_utility.set_location('pay_assoc_bal.assoc_bal',13);

250: and legislation_code = 'US';
251:
252: ELSIF UPPER(p_association) IN ('ARREARS BALANCE', 'SUBJECT BALANCE', 'HOURS BALANCE') THEN
253:
254: hr_utility.set_location('pay_assoc_bal.assoc_bal',13);
255: update pay_element_types_f
256: set ELEMENT_INFORMATION12 = v_baltype_id
257: where element_type_id = v_eletype_id
258: and business_group_id is null

Line 263: hr_utility.set_location('pay_assoc_bal.assoc_bal',15);

259: and legislation_code = 'US';
260: --
261: ELSIF UPPER(p_association) IN ('NOT TAKEN BALANCE', 'PRETAX BALANCE') THEN
262: --
263: hr_utility.set_location('pay_assoc_bal.assoc_bal',15);
264: update pay_element_types_f
265: set ELEMENT_INFORMATION13 = v_baltype_id
266: where element_type_id = v_eletype_id
267: and business_group_id is null

Line 272: hr_utility.set_location('pay_assoc_bal.assoc_bal',17);

268: and legislation_code = 'US';
269: --
270: ELSIF UPPER(p_association) IN ('TOWARD BOND PURCHASE', 'SUBJECT WHABLE') THEN
271: --
272: hr_utility.set_location('pay_assoc_bal.assoc_bal',17);
273: update pay_element_types_f
274: set ELEMENT_INFORMATION14 = v_baltype_id
275: where element_type_id = v_eletype_id
276: and business_group_id is null

Line 281: hr_utility.set_location('pay_assoc_bal.assoc_bal',19);

277: and legislation_code = 'US';
278: --
279: ELSIF UPPER(p_association) IN ('ABLE BALANCE', 'SUBJECT NOT WHABLE') THEN
280: --
281: hr_utility.set_location('pay_assoc_bal.assoc_bal',19);
282: update pay_element_types_f
283: set ELEMENT_INFORMATION15 = v_baltype_id
284: where element_type_id = v_eletype_id
285: and business_group_id is null

Line 290: hr_utility.set_location('pay_assoc_bal.assoc_bal',21);

286: and legislation_code = 'US';
287: --
288: ELSIF UPPER(p_association) = 'EXCESS BALANCE' THEN
289: --
290: hr_utility.set_location('pay_assoc_bal.assoc_bal',21);
291: update pay_element_types_f
292: set ELEMENT_INFORMATION16 = v_baltype_id
293: where element_type_id = v_eletype_id
294: and business_group_id is null

Line 299: hr_utility.set_location('pay_assoc_bal.assoc_bal',23);

295: and legislation_code = 'US';
296: --
297: ELSIF UPPER(p_association) = 'TAXABLE BALANCE' THEN
298: --
299: hr_utility.set_location('pay_assoc_bal.assoc_bal',23);
300: update pay_element_types_f
301: set ELEMENT_INFORMATION17 = v_baltype_id
302: where element_type_id = v_eletype_id
303: and business_group_id is null

Line 308: hr_utility.set_location('pay_assoc_bal.assoc_bal',25);

304: and legislation_code = 'US';
305: --
306: ELSIF UPPER(p_association) = 'EXEMPT BALANCE' THEN
307: --
308: hr_utility.set_location('pay_assoc_bal.assoc_bal',25);
309: update pay_element_types_f
310: set ELEMENT_INFORMATION18 = v_baltype_id
311: where element_type_id = v_eletype_id
312: and business_group_id is null

Line 317: hr_utility.set_location('pay_assoc_bal.assoc_bal',27);

313: and legislation_code = 'US';
314: --
315: ELSIF UPPER(p_association) = 'EE OR ER CONTR BALANCE' THEN
316: --
317: hr_utility.set_location('pay_assoc_bal.assoc_bal',27);
318: update pay_element_types_f
319: set ELEMENT_INFORMATION19 = v_baltype_id
320: where element_type_id = v_eletype_id
321: and business_group_id is null

Line 326: hr_utility.set_location('pay_assoc_bal.assoc_bal',29);

322: and legislation_code = 'US';
323: --
324: ELSIF UPPER(p_association) = 'WITHHELD BALANCE' THEN
325: --
326: hr_utility.set_location('pay_assoc_bal.assoc_bal',29);
327: update pay_element_types_f
328: set ELEMENT_INFORMATION20 = v_baltype_id
329: where element_type_id = v_eletype_id
330: and business_group_id is null

Line 338: hr_utility.set_location('Assoc Primary Bal - NO DATA FOUND',99);

334: --
335: EXCEPTION
336: --
337: WHEN NO_DATA_FOUND THEN
338: hr_utility.set_location('Assoc Primary Bal - NO DATA FOUND',99);
339: --
340: WHEN TOO_MANY_ROWS THEN
341: hr_utility.set_location('Assoc Primary Bal - TOO MANY ROWS',99);
342: --

Line 341: hr_utility.set_location('Assoc Primary Bal - TOO MANY ROWS',99);

337: WHEN NO_DATA_FOUND THEN
338: hr_utility.set_location('Assoc Primary Bal - NO DATA FOUND',99);
339: --
340: WHEN TOO_MANY_ROWS THEN
341: hr_utility.set_location('Assoc Primary Bal - TOO MANY ROWS',99);
342: --
343: END assoc_bal;
344:
345: --

Line 1045: hr_utility.set_location('No Event Group found.',99);

1041:
1042:
1043: exception
1044: when no_data_found then
1045: hr_utility.set_location('No Event Group found.',99);
1046:
1047: end;
1048:
1049: retro_element( p_element_name => 'Company Car',