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

Line 45: hr_utility.set_location('In',10);

41: l_counter number := 0;
42: --
43: begin
44: --
45: hr_utility.set_location('In',10);
46: --
47: /* seeded formula promotion template is commented out and always returns 0
48: return 0 here - no need to call formula */
49: if p_event_type = 'PROMOTION_TEMPLATE'

Line 79: hr_utility.set_location('In Loop',10);

75: open csr_get_emp_asgs;
76: --
77: loop
78: --
79: hr_utility.set_location('In Loop',10);
80: --
81: fetch csr_get_emp_asgs into l_csr_get_emp_asgs_rec;
82: hr_utility.set_location('fetching into l_csr_get_emp_asgs_rec',15);
83: if csr_get_emp_asgs%rowcount < 1

Line 82: hr_utility.set_location('fetching into l_csr_get_emp_asgs_rec',15);

78: --
79: hr_utility.set_location('In Loop',10);
80: --
81: fetch csr_get_emp_asgs into l_csr_get_emp_asgs_rec;
82: hr_utility.set_location('fetching into l_csr_get_emp_asgs_rec',15);
83: if csr_get_emp_asgs%rowcount < 1
84: then
85: l_counter := 0;
86: fnd_message.set_name('PER','PER_289770_PERSON_NOT_FOUND');

Line 89: hr_utility.set_location

85: l_counter := 0;
86: fnd_message.set_name('PER','PER_289770_PERSON_NOT_FOUND');
87: fnd_message.set_token
88: ('PROC','per_fastformula_events_utility.per_fastformula_event');
89: hr_utility.set_location
90: ('person not found or no updates to assignment record between '||
91: 'dates ',18);
92: -- fnd_message.raise_error;
93: end if;

Line 101: hr_utility.set_location('l_number '||TO_CHAR(l_number),20);

97: /*
98: dt_fndate.change_ses_date
99: (p_ses_date => l_csr_get_emp_asgs_rec.effective_start_date
100: ,p_commit => l_number);
101: hr_utility.set_location('l_number '||TO_CHAR(l_number),20);
102: */
103: hr_utility.set_location('ses date '
104: ||l_csr_get_emp_asgs_rec.effective_start_date,22);
105: --

Line 103: hr_utility.set_location('ses date '

99: (p_ses_date => l_csr_get_emp_asgs_rec.effective_start_date
100: ,p_commit => l_number);
101: hr_utility.set_location('l_number '||TO_CHAR(l_number),20);
102: */
103: hr_utility.set_location('ses date '
104: ||l_csr_get_emp_asgs_rec.effective_start_date,22);
105: --
106: for l_count in nvl(l_inputs.first,0)..nvl(l_inputs.last,-1)
107: loop

Line 113: hr_utility.set_location('asg_id '||

109: then
110: --
111: l_inputs(l_count).value :=
112: l_csr_get_emp_asgs_rec.assignment_id;
113: hr_utility.set_location('asg_id '||
114: l_csr_get_emp_asgs_rec.assignment_id,25);
115: --
116: elsif l_inputs(l_count).name = 'DATE_EARNED'
117: then

Line 121: hr_utility.set_location('date_earned '

117: then
118: l_inputs(l_count).value :=
119: to_char(trunc(l_csr_get_emp_asgs_rec.effective_start_date),
120: 'YYYY/MM/DD');
121: hr_utility.set_location('date_earned '
122: ||l_csr_get_emp_asgs_rec.effective_start_date,30);
123: end if;
124: --
125: end loop;

Line 133: hr_utility.set_location('promotions returned: '||l_counter,35);

129: --
130: if l_outputs(1).value <> 0
131: then
132: l_counter := l_counter + l_outputs(1).value;
133: hr_utility.set_location('promotions returned: '||l_counter,35);
134: end if;
135: hr_utility.set_location('Out Loop',40);
136: end loop;
137: --

Line 135: hr_utility.set_location('Out Loop',40);

131: then
132: l_counter := l_counter + l_outputs(1).value;
133: hr_utility.set_location('promotions returned: '||l_counter,35);
134: end if;
135: hr_utility.set_location('Out Loop',40);
136: end loop;
137: --
138: close csr_get_emp_asgs;
139: --

Line 184: hr_utility.set_location('In',10);

180: l_counter number := 0;
181: --
182: begin
183: --
184: hr_utility.set_location('In',10);
185: if p_event_type = 'PROMOTION_TEMPLATE'
186: then
187: l_counter := 0;
188: else

Line 215: hr_utility.set_location('In Loop',10);

211: open csr_get_emp_asgs_snapshot;
212: --
213: loop
214: --
215: hr_utility.set_location('In Loop',10);
216: --
217: fetch csr_get_emp_asgs_snapshot into
218: l_csr_get_emp_asgs_snapshot;
219: hr_utility.set_location('fetching into l_csr_get_emp_asgs_rec',15);

Line 219: hr_utility.set_location('fetching into l_csr_get_emp_asgs_rec',15);

215: hr_utility.set_location('In Loop',10);
216: --
217: fetch csr_get_emp_asgs_snapshot into
218: l_csr_get_emp_asgs_snapshot;
219: hr_utility.set_location('fetching into l_csr_get_emp_asgs_rec',15);
220: if csr_get_emp_asgs_snapshot%rowcount < 1
221: then
222: l_counter := 0;
223: fnd_message.set_name('PER','PER_289770_PERSON_NOT_FOUND');

Line 236: hr_utility.set_location('l_number '||TO_CHAR(l_number),20);

232: dt_fndate.change_ses_date
233: (p_ses_date =>
234: l_csr_get_emp_asgs_snapshot.effective_start_date
235: ,p_commit => l_number);
236: hr_utility.set_location('l_number '||TO_CHAR(l_number),20);
237: */
238: hr_utility.set_location('ses date '
239: ||l_csr_get_emp_asgs_snapshot.effective_start_date,20);
240: --

Line 238: hr_utility.set_location('ses date '

234: l_csr_get_emp_asgs_snapshot.effective_start_date
235: ,p_commit => l_number);
236: hr_utility.set_location('l_number '||TO_CHAR(l_number),20);
237: */
238: hr_utility.set_location('ses date '
239: ||l_csr_get_emp_asgs_snapshot.effective_start_date,20);
240: --
241: for l_count in nvl(l_inputs.first,0)..nvl(l_inputs.last,-1)
242: loop

Line 248: hr_utility.set_location('asg_id '||

244: then
245: --
246: l_inputs(l_count).value :=
247: l_csr_get_emp_asgs_snapshot.assignment_id;
248: hr_utility.set_location('asg_id '||
249: l_csr_get_emp_asgs_snapshot.assignment_id,25);
250: --
251: elsif l_inputs(l_count).name = 'DATE_EARNED'
252: then

Line 257: hr_utility.set_location('date_earned '

253: l_inputs(l_count).value :=
254: to_char(trunc
255: (l_csr_get_emp_asgs_snapshot.effective_start_date),
256: 'YYYY/MM/DD');
257: hr_utility.set_location('date_earned '
258: ||l_csr_get_emp_asgs_snapshot.effective_start_date,30);
259: end if;
260: --
261: end loop;

Line 269: hr_utility.set_location('promotions returned: '||l_counter,35);

265: --
266: if l_outputs(1).value <> 0
267: then
268: l_counter := l_counter + l_outputs(1).value;
269: hr_utility.set_location('promotions returned: '||l_counter,35);
270: end if;
271: hr_utility.set_location('Out Loop',40);
272: end loop;
273: --

Line 271: hr_utility.set_location('Out Loop',40);

267: then
268: l_counter := l_counter + l_outputs(1).value;
269: hr_utility.set_location('promotions returned: '||l_counter,35);
270: end if;
271: hr_utility.set_location('Out Loop',40);
272: end loop;
273: --
274: close csr_get_emp_asgs_snapshot;
275: --

Line 334: --hr_utility.trace_on(null,'EQUPIPE');

330: l_start_date := null;
331: l_formula_type_id := 0;
332: l_counter := 0;
333: --
334: --hr_utility.trace_on(null,'EQUPIPE');
335: hr_utility.set_location('In',10);
336: /* Deleting the PL/SQL table contents Added by ssmukher */
337: p_date_tab.delete;
338: --

Line 335: hr_utility.set_location('In',10);

331: l_formula_type_id := 0;
332: l_counter := 0;
333: --
334: --hr_utility.trace_on(null,'EQUPIPE');
335: hr_utility.set_location('In',10);
336: /* Deleting the PL/SQL table contents Added by ssmukher */
337: p_date_tab.delete;
338: --
339: /* seeded formula promotion template is commented out and always returns 0

Line 373: hr_utility.set_location('In Loop',10);

369: open csr_get_emp_asgs;
370: --
371: loop
372: --
373: hr_utility.set_location('In Loop',10);
374: --
375: fetch csr_get_emp_asgs into l_csr_get_emp_asgs_rec;
376: hr_utility.set_location('fetching into l_csr_get_emp_asgs_rec',15);
377: if csr_get_emp_asgs%rowcount < 1

Line 376: hr_utility.set_location('fetching into l_csr_get_emp_asgs_rec',15);

372: --
373: hr_utility.set_location('In Loop',10);
374: --
375: fetch csr_get_emp_asgs into l_csr_get_emp_asgs_rec;
376: hr_utility.set_location('fetching into l_csr_get_emp_asgs_rec',15);
377: if csr_get_emp_asgs%rowcount < 1
378: then
379: l_counter := 0;
380: fnd_message.set_name('PER','PER_289770_PERSON_NOT_FOUND');

Line 383: hr_utility.set_location

379: l_counter := 0;
380: fnd_message.set_name('PER','PER_289770_PERSON_NOT_FOUND');
381: fnd_message.set_token
382: ('PROC','per_fastformula_events_utility.per_fastformula_event');
383: hr_utility.set_location
384: ('person not found or no updates to assignment record between '||
385: 'dates ',18);
386: -- fnd_message.raise_error;
387: end if;

Line 390: hr_utility.set_location('ses date '

386: -- fnd_message.raise_error;
387: end if;
388: exit when csr_get_emp_asgs%notfound;
389: --
390: hr_utility.set_location('ses date '
391: ||l_csr_get_emp_asgs_rec.effective_start_date,22);
392: --
393: for l_count in nvl(l_inputs.first,0)..nvl(l_inputs.last,-1)
394: loop

Line 400: hr_utility.set_location('asg_id '||

396: then
397: --
398: l_inputs(l_count).value :=
399: l_csr_get_emp_asgs_rec.assignment_id;
400: hr_utility.set_location('asg_id '||
401: l_csr_get_emp_asgs_rec.assignment_id,25);
402: --
403: elsif l_inputs(l_count).name = 'DATE_EARNED'
404: then

Line 408: hr_utility.set_location('date_earned '

404: then
405: l_inputs(l_count).value :=
406: to_char(trunc(l_csr_get_emp_asgs_rec.effective_start_date),
407: 'YYYY/MM/DD');
408: hr_utility.set_location('date_earned '
409: ||l_csr_get_emp_asgs_rec.effective_start_date,30);
410: end if;
411: --
412: end loop;

Line 420: hr_utility.set_location('promotions returned: '||l_counter,35);

416: --
417: if l_outputs(1).value <> 0
418: then
419: l_counter := l_counter + l_outputs(1).value;
420: hr_utility.set_location('promotions returned: '||l_counter,35);
421: /* Added by ssmukher for Employment Equity report */
422: l_cnt := l_cnt + 1;
423: p_date_tab(l_cnt) := l_csr_get_emp_asgs_rec.effective_start_date;
424: end if;

Line 425: hr_utility.set_location('Out Loop',40);

421: /* Added by ssmukher for Employment Equity report */
422: l_cnt := l_cnt + 1;
423: p_date_tab(l_cnt) := l_csr_get_emp_asgs_rec.effective_start_date;
424: end if;
425: hr_utility.set_location('Out Loop',40);
426: end loop;
427: --
428: close csr_get_emp_asgs;
429: --

Line 488: hr_utility.set_location('no formula for this business group '

484: fnd_message.set_name('PER','PER_289772_FORMULA_NOT_FOUND');
485: fnd_message.set_token
486: --
487: ('PROC','per_fastformula_events_utility.get_formula_id');
488: hr_utility.set_location('no formula for this business group '
489: ||p_business_group_id,44);
490: --
491: l_csr_formula_id := 0; -- bug 3540677
492: return 0;

Line 509: hr_utility.set_location

505: l_csr_formula_id;
506: if csr_get_global_formula_id%rowcount < 1
507: then
508: return 0;
509: hr_utility.set_location
510: ('you might be stuck here if promo_template has no text '
511: ||l_formula_id,44);
512: fnd_message.set_name('PER','PER_289772_FORMULA_NOT_FOUND');
513: fnd_message.set_token

Line 516: hr_utility.set_location('l_formula_id '||l_formula_id,45);

512: fnd_message.set_name('PER','PER_289772_FORMULA_NOT_FOUND');
513: fnd_message.set_token
514: ('PROC','per_fastformula_events_utility.get_formula_id');
515: fnd_message.raise_error;
516: hr_utility.set_location('l_formula_id '||l_formula_id,45);
517: hr_utility.set_location('p_business_group_id '
518: ||p_business_group_id,46);
519: end if;
520: exit when csr_get_global_formula_id%notfound;

Line 517: hr_utility.set_location('p_business_group_id '

513: fnd_message.set_token
514: ('PROC','per_fastformula_events_utility.get_formula_id');
515: fnd_message.raise_error;
516: hr_utility.set_location('l_formula_id '||l_formula_id,45);
517: hr_utility.set_location('p_business_group_id '
518: ||p_business_group_id,46);
519: end if;
520: exit when csr_get_global_formula_id%notfound;
521: end loop;