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.HR_TEMPLATE_EXISTENCE dependencies on HR_UTILITY

Line 96: hr_utility.set_location('hr_template_existence.bal_feed_exists',10);

92: already_exists number := 0;
93:
94: begin
95:
96: hr_utility.set_location('hr_template_existence.bal_feed_exists',10);
97:
98: select bf.balance_feed_id
99: into already_exists
100: from pay_balance_feeds_f bf

Line 107: hr_utility.set_location('hr_template_existence.bal_feed_exists',20);

103: and bf.business_group_id = p_bg_id
104: and p_eff_date between bf.effective_start_date
105: and bf.effective_end_date;
106:
107: hr_utility.set_location('hr_template_existence.bal_feed_exists',20);
108:
109: return already_exists;
110:
111: exception when NO_DATA_FOUND then

Line 113: hr_utility.set_location('hr_template_existence.bal_feed_DOES_NOT_exist',999);

109: return already_exists;
110:
111: exception when NO_DATA_FOUND then
112:
113: hr_utility.set_location('hr_template_existence.bal_feed_DOES_NOT_exist',999);
114:
115: return already_exists; -- ie. zero.
116:
117: end bal_feed_exists;

Line 132: hr_utility.set_location('hr_template_existence.result_rule_exists',10);

128: already_exists number := 0;
129:
130: begin
131:
132: hr_utility.set_location('hr_template_existence.result_rule_exists',10);
133:
134: select frr.formula_result_rule_id
135: into already_exists
136: from pay_formula_result_rules_f frr

Line 147: hr_utility.set_location('hr_template_existence.result_rule_exists',20);

143:
144: -- Note, the above sql checks for result rules which have been
145: -- created without providing an element type id...just an input value id...
146:
147: hr_utility.set_location('hr_template_existence.result_rule_exists',20);
148:
149: return already_exists;
150:
151: exception when NO_DATA_FOUND then

Line 153: hr_utility.set_location('hr_template_existence.result_rule_DOES_NOT_exist',999);

149: return already_exists;
150:
151: exception when NO_DATA_FOUND then
152:
153: hr_utility.set_location('hr_template_existence.result_rule_DOES_NOT_exist',999);
154:
155: return already_exists; -- ie. zero.
156:
157: end result_rule_exists;

Line 175: hr_utility.set_location('hr_template_existence.spr_exists',10);

171: already_exists number := 0;
172:
173: begin
174:
175: hr_utility.set_location('hr_template_existence.spr_exists',10);
176:
177: select spr.status_processing_rule_id,
178: spr.formula_id
179: into already_exists,

Line 188: hr_utility.set_location('hr_template_existence.spr_exists',20);

184: and spr.business_group_id = p_bg_id
185: and p_val_date between spr.effective_start_date
186: and spr.effective_end_date;
187:
188: hr_utility.set_location('hr_template_existence.spr_exists',20);
189:
190: return already_exists;
191:
192: exception when NO_DATA_FOUND then

Line 194: hr_utility.set_location('hr_template_existence.spr_DOES_NOT_exist',999);

190: return already_exists;
191:
192: exception when NO_DATA_FOUND then
193:
194: hr_utility.set_location('hr_template_existence.spr_DOES_NOT_exist',999);
195:
196: p_ff_id := NULL;
197: return already_exists; -- ie. zero.
198:

Line 213: hr_utility.set_location('hr_template_existence.ele_ff_exists',10);

209: already_exists number := 0;
210:
211: begin
212:
213: hr_utility.set_location('hr_template_existence.ele_ff_exists',10);
214:
215: select ff.formula_id,
216: ff.formula_name,
217: ff.formula_text

Line 238: hr_utility.set_location('hr_template_existence.ele_ff_exists',20);

234: and ff.business_group_id = p_bg_id
235: and p_eff_date between ff.effective_start_date
236: and ff.effective_end_date;
237:
238: hr_utility.set_location('hr_template_existence.ele_ff_exists',20);
239:
240: return already_exists;
241:
242: exception when NO_DATA_FOUND then

Line 244: hr_utility.set_location('hr_template_existence.ele_ff_DOES_NOT_exist',999);

240: return already_exists;
241:
242: exception when NO_DATA_FOUND then
243:
244: hr_utility.set_location('hr_template_existence.ele_ff_DOES_NOT_exist',999);
245: return already_exists; -- ie. zero.
246:
247: end ele_ff_exists;
248:

Line 260: hr_utility.set_location('hr_template_existence.defined_bal_exists',10);

256: already_exists number := 0;
257:
258: begin
259:
260: hr_utility.set_location('hr_template_existence.defined_bal_exists',10);
261:
262: SELECT pdb.defined_balance_id
263: INTO already_exists
264: FROM pay_defined_balances pdb

Line 269: hr_utility.set_location('hr_template_existence.defined_bal_exists',20);

265: WHERE pdb.balance_type_id = p_bal_id
266: AND pdb.balance_dimension_id = p_dim_id
267: AND pdb.business_group_id = p_bg_id;
268:
269: hr_utility.set_location('hr_template_existence.defined_bal_exists',20);
270:
271: return already_exists;
272:
273: exception when NO_DATA_FOUND then

Line 275: hr_utility.set_location('hr_template_existence.defined_bal_DOES_NOT_exist',999);

271: return already_exists;
272:
273: exception when NO_DATA_FOUND then
274:
275: hr_utility.set_location('hr_template_existence.defined_bal_DOES_NOT_exist',999);
276:
277: return already_exists; -- ie. zero.
278:
279: end defined_bal_exists;

Line 292: hr_utility.set_location('hr_template_existence.iv_name_exists',10);

288: already_exists number := 0;
289:
290: begin
291:
292: hr_utility.set_location('hr_template_existence.iv_name_exists',10);
293:
294: SELECT piv.input_value_id
295: INTO already_exists
296: FROM pay_input_values_f piv

Line 302: hr_utility.set_location('hr_template_existence.iv_name_exists',20);

298: AND piv.element_type_id = p_ele_id
299: AND piv.business_group_id = p_bg_id
300: AND p_eff_date between piv.effective_start_date and piv.effective_end_date;
301:
302: hr_utility.set_location('hr_template_existence.iv_name_exists',20);
303:
304: return already_exists;
305:
306: exception when NO_DATA_FOUND then

Line 308: hr_utility.set_location('hr_template_existence.iv_name_DOES_NOT_exist',999);

304: return already_exists;
305:
306: exception when NO_DATA_FOUND then
307:
308: hr_utility.set_location('hr_template_existence.iv_name_DOES_NOT_exist',999);
309:
310: return already_exists; -- ie. zero.
311:
312: end iv_name_exists;

Line 326: hr_utility.set_location('hr_template_existence.ele_exists',10);

322: already_exists number := 0;
323:
324: begin
325:
326: hr_utility.set_location('hr_template_existence.ele_exists',10);
327:
328: SELECT pet.element_type_id
329: INTO already_exists
330: FROM pay_element_types_f pet

Line 335: hr_utility.set_location('hr_template_existence.ele_exists',20);

331: WHERE pet.element_name = p_ele_name
332: AND pet.business_group_id = p_bg_id
333: AND p_eff_date between pet.effective_start_date and pet.effective_end_date;
334:
335: hr_utility.set_location('hr_template_existence.ele_exists',20);
336:
337: return already_exists;
338:
339: exception when NO_DATA_FOUND then

Line 341: hr_utility.set_location('hr_template_existence.ele_name_DOES_NOT_exist',999);

337: return already_exists;
338:
339: exception when NO_DATA_FOUND then
340:
341: hr_utility.set_location('hr_template_existence.ele_name_DOES_NOT_exist',999);
342:
343: return already_exists; -- ie. zero.
344:
345: end ele_exists;

Line 359: hr_utility.set_location('hr_template_existence.bal_exists',10);

355: already_exists number := 0;
356:
357: begin
358:
359: hr_utility.set_location('hr_template_existence.bal_exists',10);
360:
361: SELECT pbt.balance_type_id
362: INTO already_exists
363: FROM pay_balance_types pbt

Line 367: hr_utility.set_location('hr_template_existence.bal_exists',20);

363: FROM pay_balance_types pbt
364: WHERE pbt.balance_name = p_bal_name
365: AND pbt.business_group_id = p_bg_id;
366:
367: hr_utility.set_location('hr_template_existence.bal_exists',20);
368:
369: return already_exists;
370:
371: exception when NO_DATA_FOUND then

Line 373: hr_utility.set_location('hr_template_existence.bal_DOES_NOT_exist',999);

369: return already_exists;
370:
371: exception when NO_DATA_FOUND then
372:
373: hr_utility.set_location('hr_template_existence.bal_DOES_NOT_exist',999);
374:
375: return already_exists; -- ie. zero.
376:
377: end bal_exists;