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

Line 53: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

49: lv_procedure_name VARCHAR2(100);
50:
51: BEGIN
52: lv_procedure_name := '.insert_retro_comp_usages';
53: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
54:
55: select pay_retro_component_usages_s.nextval
56: into ln_retro_component_usage_id
57: from dual;

Line 74: hr_utility.trace('p_retro_comp_usage_id= ' || p_retro_comp_usage_id);

70: AND creator_id = p_creator_id
71: AND creator_type = 'ET');
72:
73: p_retro_comp_usage_id := ln_retro_component_usage_id;
74: hr_utility.trace('p_retro_comp_usage_id= ' || p_retro_comp_usage_id);
75: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
76:
77: exception
78: when others then

Line 75: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

71: AND creator_type = 'ET');
72:
73: p_retro_comp_usage_id := ln_retro_component_usage_id;
74: hr_utility.trace('p_retro_comp_usage_id= ' || p_retro_comp_usage_id);
75: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
76:
77: exception
78: when others then
79: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

Line 79: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

75: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
76:
77: exception
78: when others then
79: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
80: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
81: raise;
82: END insert_retro_comp_usages;
83:

Line 80: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

76:
77: exception
78: when others then
79: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
80: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
81: raise;
82: END insert_retro_comp_usages;
83:
84:

Line 97: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

93: lv_procedure_name VARCHAR2(100);
94:
95: BEGIN
96: lv_procedure_name := '.insert_element_span_usages';
97: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
98:
99: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
100: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
101: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);

Line 99: hr_utility.trace('p_business_group_id ='|| p_business_group_id);

95: BEGIN
96: lv_procedure_name := '.insert_element_span_usages';
97: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
98:
99: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
100: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
101: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
102: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
103:

Line 100: hr_utility.trace('p_time_span_id ='|| p_time_span_id);

96: lv_procedure_name := '.insert_element_span_usages';
97: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
98:
99: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
100: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
101: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
102: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
103:
104: insert into pay_element_span_usages

Line 101: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);

97: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
98:
99: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
100: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
101: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
102: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
103:
104: insert into pay_element_span_usages
105: (element_span_usage_id, business_group_id, time_span_id,

Line 102: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);

98:
99: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
100: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
101: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
102: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
103:
104: insert into pay_element_span_usages
105: (element_span_usage_id, business_group_id, time_span_id,
106: retro_component_usage_id, retro_element_type_id,

Line 119: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

115: AND pesu.legislation_code IS NULL
116: AND pesu.time_span_id = p_time_span_id
117: AND retro_component_usage_id = p_retro_comp_usage_id);
118:
119: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
120:
121: exception
122: when others then
123: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

Line 123: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

119: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
120:
121: exception
122: when others then
123: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
124: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
125: raise;
126: END insert_element_span_usages;
127:

Line 124: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

120:
121: exception
122: when others then
123: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
124: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
125: raise;
126: END insert_element_span_usages;
127:
128:

Line 199: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

195:
196: BEGIN
197:
198: lv_procedure_name := '.qualify_element';
199: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
200: lv_qualified := 'N';
201: lv_legislation_code := null;
202: ln_business_group_id := null;
203: ln_classification_id := null;

Line 229: hr_utility.trace('Element Set ID ' || ln_element_set_id);

225: if c_element_set%notfound then
226: exit;
227: end if;
228:
229: hr_utility.trace('Element Set ID ' || ln_element_set_id);
230: open c_element_check(ln_element_set_id);
231: fetch c_element_check into ln_element_used;
232: if c_element_check%found then
233: lv_qualified := 'Y';

Line 234: hr_utility.trace('UPGRADE Element ' || lv_element_name ||

230: open c_element_check(ln_element_set_id);
231: fetch c_element_check into ln_element_used;
232: if c_element_check%found then
233: lv_qualified := 'Y';
234: hr_utility.trace('UPGRADE Element ' || lv_element_name ||
235: '(' || p_object_id || ')');
236: exit;
237: else
238: lv_qualified := 'N';

Line 239: hr_utility.trace('Element ' || lv_element_name ||

235: '(' || p_object_id || ')');
236: exit;
237: else
238: lv_qualified := 'N';
239: hr_utility.trace('Element ' || lv_element_name ||
240: '(' || p_object_id || ') does not need to be upgraded');
241: end if;
242: close c_element_check;
243: end loop;

Line 247: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

243: end loop;
244: close c_element_set;
245:
246: p_qualified := lv_qualified;
247: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
248:
249: exception
250: when others then
251: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

Line 251: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

247: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
248:
249: exception
250: when others then
251: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
252: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
253: raise;
254: END qualify_element;
255:

Line 252: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

248:
249: exception
250: when others then
251: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
252: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
253: raise;
254: END qualify_element;
255:
256:

Line 338: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

334:
335: ltt_business_group numeric_data_table;
336: BEGIN
337: lv_procedure_name := '.upgrade_element';
338: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
339:
340: hr_utility.set_location(gv_package_name || lv_procedure_name, 30);
341: open c_element_dtl(p_element_type_id);
342: fetch c_element_dtl into ln_ele_business_group_id, ln_legislation_code,

Line 340: hr_utility.set_location(gv_package_name || lv_procedure_name, 30);

336: BEGIN
337: lv_procedure_name := '.upgrade_element';
338: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
339:
340: hr_utility.set_location(gv_package_name || lv_procedure_name, 30);
341: open c_element_dtl(p_element_type_id);
342: fetch c_element_dtl into ln_ele_business_group_id, ln_legislation_code,
343: ln_classification_id, ln_retro_element_type_id,
344: lv_element_name;

Line 346: hr_utility.trace('p_element_type_id ='|| p_element_type_id);

342: fetch c_element_dtl into ln_ele_business_group_id, ln_legislation_code,
343: ln_classification_id, ln_retro_element_type_id,
344: lv_element_name;
345: close c_element_dtl;
346: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
347: hr_utility.trace('lv_element_name ='|| lv_element_name);
348: hr_utility.trace('ln_legislation_code ='|| ln_legislation_code);
349: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
350: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);

Line 347: hr_utility.trace('lv_element_name ='|| lv_element_name);

343: ln_classification_id, ln_retro_element_type_id,
344: lv_element_name;
345: close c_element_dtl;
346: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
347: hr_utility.trace('lv_element_name ='|| lv_element_name);
348: hr_utility.trace('ln_legislation_code ='|| ln_legislation_code);
349: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
350: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
351:

Line 348: hr_utility.trace('ln_legislation_code ='|| ln_legislation_code);

344: lv_element_name;
345: close c_element_dtl;
346: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
347: hr_utility.trace('lv_element_name ='|| lv_element_name);
348: hr_utility.trace('ln_legislation_code ='|| ln_legislation_code);
349: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
350: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
351:
352: if ln_legislation_code is null and

Line 349: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);

345: close c_element_dtl;
346: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
347: hr_utility.trace('lv_element_name ='|| lv_element_name);
348: hr_utility.trace('ln_legislation_code ='|| ln_legislation_code);
349: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
350: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
351:
352: if ln_legislation_code is null and
353: ln_ele_business_group_id is not null then

Line 350: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);

346: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
347: hr_utility.trace('lv_element_name ='|| lv_element_name);
348: hr_utility.trace('ln_legislation_code ='|| ln_legislation_code);
349: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
350: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
351:
352: if ln_legislation_code is null and
353: ln_ele_business_group_id is not null then
354: open c_legislation_code(ln_ele_business_group_id);

Line 360: hr_utility.trace('lv_legislation_code ='|| lv_legislation_code);

356: close c_legislation_code;
357: else
358: lv_legislation_code := ln_legislation_code;
359: end if;
360: hr_utility.trace('lv_legislation_code ='|| lv_legislation_code);
361:
362: if gn_retro_component_id is null then
363: hr_utility.trace('getting gn_retro_component_id ='|| gn_retro_component_id);
364: hr_utility.set_location(gv_package_name || lv_procedure_name, 20);

Line 363: hr_utility.trace('getting gn_retro_component_id ='|| gn_retro_component_id);

359: end if;
360: hr_utility.trace('lv_legislation_code ='|| lv_legislation_code);
361:
362: if gn_retro_component_id is null then
363: hr_utility.trace('getting gn_retro_component_id ='|| gn_retro_component_id);
364: hr_utility.set_location(gv_package_name || lv_procedure_name, 20);
365: open c_retro_info(lv_legislation_code);
366: fetch c_retro_info into gn_retro_component_id
367: ,gn_time_span_id;

Line 364: hr_utility.set_location(gv_package_name || lv_procedure_name, 20);

360: hr_utility.trace('lv_legislation_code ='|| lv_legislation_code);
361:
362: if gn_retro_component_id is null then
363: hr_utility.trace('getting gn_retro_component_id ='|| gn_retro_component_id);
364: hr_utility.set_location(gv_package_name || lv_procedure_name, 20);
365: open c_retro_info(lv_legislation_code);
366: fetch c_retro_info into gn_retro_component_id
367: ,gn_time_span_id;
368: close c_retro_info;

Line 370: hr_utility.trace('gn_retro_component_id ='|| gn_retro_component_id);

366: fetch c_retro_info into gn_retro_component_id
367: ,gn_time_span_id;
368: close c_retro_info;
369: end if;
370: hr_utility.trace('gn_retro_component_id ='|| gn_retro_component_id);
371: hr_utility.trace('gn_time_span_id ='|| gn_time_span_id);
372:
373: hr_utility.set_location(gv_package_name || lv_procedure_name, 40);
374:

Line 371: hr_utility.trace('gn_time_span_id ='|| gn_time_span_id);

367: ,gn_time_span_id;
368: close c_retro_info;
369: end if;
370: hr_utility.trace('gn_retro_component_id ='|| gn_retro_component_id);
371: hr_utility.trace('gn_time_span_id ='|| gn_time_span_id);
372:
373: hr_utility.set_location(gv_package_name || lv_procedure_name, 40);
374:
375: if ln_legislation_code is not null and

Line 373: hr_utility.set_location(gv_package_name || lv_procedure_name, 40);

369: end if;
370: hr_utility.trace('gn_retro_component_id ='|| gn_retro_component_id);
371: hr_utility.trace('gn_time_span_id ='|| gn_time_span_id);
372:
373: hr_utility.set_location(gv_package_name || lv_procedure_name, 40);
374:
375: if ln_legislation_code is not null and
376: ln_ele_business_group_id is null then
377:

Line 378: hr_utility.trace('Seeded Element');

374:
375: if ln_legislation_code is not null and
376: ln_ele_business_group_id is null then
377:
378: hr_utility.trace('Seeded Element');
379: hr_utility.set_location(gv_package_name || lv_procedure_name, 60);
380: insert_retro_comp_usages
381: (p_business_group_id => null
382: ,p_legislation_code => ln_legislation_code

Line 379: hr_utility.set_location(gv_package_name || lv_procedure_name, 60);

375: if ln_legislation_code is not null and
376: ln_ele_business_group_id is null then
377:
378: hr_utility.trace('Seeded Element');
379: hr_utility.set_location(gv_package_name || lv_procedure_name, 60);
380: insert_retro_comp_usages
381: (p_business_group_id => null
382: ,p_legislation_code => ln_legislation_code
383: ,p_retro_component_id => gn_retro_component_id

Line 387: hr_utility.set_location(gv_package_name || lv_procedure_name, 70);

383: ,p_retro_component_id => gn_retro_component_id
384: ,p_creator_id => p_element_type_id
385: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
386:
387: hr_utility.set_location(gv_package_name || lv_procedure_name, 70);
388: open c_element_set(p_element_type_id, ln_classification_id,ln_legislation_code);
389: loop
390: fetch c_element_set into ln_element_set_id;
391: if c_element_set%notfound then

Line 392: hr_utility.set_location(gv_package_name || lv_procedure_name, 99999);

388: open c_element_set(p_element_type_id, ln_classification_id,ln_legislation_code);
389: loop
390: fetch c_element_set into ln_element_set_id;
391: if c_element_set%notfound then
392: hr_utility.set_location(gv_package_name || lv_procedure_name, 99999);
393: exit;
394: end if;
395:
396: open c_get_business_group(ln_element_set_id,ln_legislation_code);

Line 400: hr_utility.set_location(gv_package_name || lv_procedure_name, 8888);

396: open c_get_business_group(ln_element_set_id,ln_legislation_code);
397: loop
398: fetch c_get_business_group into ln_business_group_id;
399: if c_get_business_group%notfound then
400: hr_utility.set_location(gv_package_name || lv_procedure_name, 8888);
401: exit;
402: end if;
403:
404: hr_utility.trace('ln_business_group_id ='|| ln_business_group_id);

Line 404: hr_utility.trace('ln_business_group_id ='|| ln_business_group_id);

400: hr_utility.set_location(gv_package_name || lv_procedure_name, 8888);
401: exit;
402: end if;
403:
404: hr_utility.trace('ln_business_group_id ='|| ln_business_group_id);
405: hr_utility.set_location(gv_package_name || lv_procedure_name, 80);
406:
407: insert_element_span_usages
408: (p_business_group_id => ln_business_group_id

Line 405: hr_utility.set_location(gv_package_name || lv_procedure_name, 80);

401: exit;
402: end if;
403:
404: hr_utility.trace('ln_business_group_id ='|| ln_business_group_id);
405: hr_utility.set_location(gv_package_name || lv_procedure_name, 80);
406:
407: insert_element_span_usages
408: (p_business_group_id => ln_business_group_id
409: ,p_retro_element_type_id => ln_retro_element_type_id

Line 414: hr_utility.set_location(gv_package_name || lv_procedure_name, 90);

410: ,p_legislation_code => ln_legislation_code
411: ,p_time_span_id => gn_time_span_id
412: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
413:
414: hr_utility.set_location(gv_package_name || lv_procedure_name, 90);
415: end loop;
416: close c_get_business_group;
417: end loop;
418: close c_element_set;

Line 420: hr_utility.set_location(gv_package_name || lv_procedure_name, 100);

416: close c_get_business_group;
417: end loop;
418: close c_element_set;
419: end if;
420: hr_utility.set_location(gv_package_name || lv_procedure_name, 100);
421:
422: if ln_legislation_code is null and
423: ln_ele_business_group_id is not null then
424:

Line 425: hr_utility.trace('Custom Element');

421:
422: if ln_legislation_code is null and
423: ln_ele_business_group_id is not null then
424:
425: hr_utility.trace('Custom Element');
426: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);
427: insert_retro_comp_usages
428: (p_business_group_id => ln_ele_business_group_id
429: ,p_legislation_code => null

Line 426: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);

422: if ln_legislation_code is null and
423: ln_ele_business_group_id is not null then
424:
425: hr_utility.trace('Custom Element');
426: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);
427: insert_retro_comp_usages
428: (p_business_group_id => ln_ele_business_group_id
429: ,p_legislation_code => null
430: ,p_retro_component_id => gn_retro_component_id

Line 433: hr_utility.set_location(gv_package_name || lv_procedure_name, 120);

429: ,p_legislation_code => null
430: ,p_retro_component_id => gn_retro_component_id
431: ,p_creator_id => p_element_type_id
432: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
433: hr_utility.set_location(gv_package_name || lv_procedure_name, 120);
434: insert_element_span_usages
435: (p_business_group_id => ln_ele_business_group_id
436: ,p_retro_element_type_id => ln_retro_element_type_id
437: ,p_legislation_code => null

Line 442: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

438: ,p_time_span_id => gn_time_span_id
439: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
440: end if;
441:
442: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
443: exception
444: when others then
445: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
446: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

Line 445: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

441:
442: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
443: exception
444: when others then
445: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
446: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
447: raise;
448: END upgrade_element;
449:

Line 446: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

442: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
443: exception
444: when others then
445: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
446: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
447: raise;
448: END upgrade_element;
449:
450: BEGIN