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

Line 83: -- hr_utility.trace_on(null,'oracle');

79:
80: --
81: --
82: begin
83: -- hr_utility.trace_on(null,'oracle');
84: hr_utility.set_location('IN range_cursor',200);
85:
86: begin
87: select ppa.legislative_parameters,

Line 84: hr_utility.set_location('IN range_cursor',200);

80: --
81: --
82: begin
83: -- hr_utility.trace_on(null,'oracle');
84: hr_utility.set_location('IN range_cursor',200);
85:
86: begin
87: select ppa.legislative_parameters,
88: ppa.business_group_id,

Line 103: hr_utility.trace('Legislative parameters not found for pactid '||to_char(pactid));

99: from pay_payroll_actions ppa
100: where ppa.payroll_action_id = pactid;
101: exception
102: when others then
103: hr_utility.trace('Legislative parameters not found for pactid '||to_char(pactid));
104: --raise;
105: end;
106:
107: where_condition := '';

Line 118: hr_utility.trace('Range where condition='||where_condition);

114: if l_loc_id is not null then
115: where_condition :=where_condition||' and paf.location_id ='||l_loc_id;
116: end if;
117:
118: hr_utility.trace('Range where condition='||where_condition);
119: hr_utility.trace('l_as_of_date='||l_as_of_date);
120: hr_utility.trace('l_bg_id='||l_bg_id);
121:
122: sqlstr := 'select /*+ ORDERED

Line 119: hr_utility.trace('l_as_of_date='||l_as_of_date);

115: where_condition :=where_condition||' and paf.location_id ='||l_loc_id;
116: end if;
117:
118: hr_utility.trace('Range where condition='||where_condition);
119: hr_utility.trace('l_as_of_date='||l_as_of_date);
120: hr_utility.trace('l_bg_id='||l_bg_id);
121:
122: sqlstr := 'select /*+ ORDERED
123: index(ppa PAY_PAYROLL_ACTIONS_N5)

Line 120: hr_utility.trace('l_bg_id='||l_bg_id);

116: end if;
117:
118: hr_utility.trace('Range where condition='||where_condition);
119: hr_utility.trace('l_as_of_date='||l_as_of_date);
120: hr_utility.trace('l_bg_id='||l_bg_id);
121:
122: sqlstr := 'select /*+ ORDERED
123: index(ppa PAY_PAYROLL_ACTIONS_N5)
124: index(paa PAY_ASSIGNMENT_ACTIONS_N50)

Line 144: hr_utility.set_location('OUT range_cursor',250);

140: and paf.business_group_id + 0 = '''||l_bg_id||'''
141: '|| where_condition ||'
142: order by paf.person_id';
143:
144: hr_utility.set_location('OUT range_cursor',250);
145: end range_cursor;
146: --
147: --------------------------- action_creation ---------------------------------
148: --

Line 296: hr_utility.trace(' Actions found = '||to_char(num));

292: p_greid
293: );
294: end if;
295: end if;
296: hr_utility.trace(' Actions found = '||to_char(num));
297: end insert_action;
298: --
299: --
300: --------------- Main Action Creation --------------------------------

Line 302: --hr_utility.trace_on(null,'oracle');

298: --
299: --
300: --------------- Main Action Creation --------------------------------
301: begin
302: --hr_utility.trace_on(null,'oracle');
303:
304: hr_utility.set_location('IN action_creation',300);
305: --
306: open c_parameters(pactid);

Line 304: hr_utility.set_location('IN action_creation',300);

300: --------------- Main Action Creation --------------------------------
301: begin
302: --hr_utility.trace_on(null,'oracle');
303:
304: hr_utility.set_location('IN action_creation',300);
305: --
306: open c_parameters(pactid);
307: fetch c_parameters into leg_param,
308: l_bg_id,

Line 316: hr_utility.trace('Legislative parameters not found for pactid '||pactid);

312: l_as_of_date,
313: l_tax_type;
314:
315: if c_parameters%notfound then
316: hr_utility.trace('Legislative parameters not found for pactid '||pactid);
317: close c_parameters;
318: --raise;
319: end if;
320: close c_parameters;

Line 322: hr_utility.set_location('action creation after prm',301);

318: --raise;
319: end if;
320: close c_parameters;
321:
322: hr_utility.set_location('action creation after prm',301);
323: hr_utility.trace('Parmeters: ');
324: hr_utility.trace(' gre_id : '||to_char(l_gre_id));
325: hr_utility.trace(' bg_id : '||to_char(l_bg_id));
326: hr_utility.trace(' as of date: '||l_as_of_date);

Line 323: hr_utility.trace('Parmeters: ');

319: end if;
320: close c_parameters;
321:
322: hr_utility.set_location('action creation after prm',301);
323: hr_utility.trace('Parmeters: ');
324: hr_utility.trace(' gre_id : '||to_char(l_gre_id));
325: hr_utility.trace(' bg_id : '||to_char(l_bg_id));
326: hr_utility.trace(' as of date: '||l_as_of_date);
327: hr_utility.trace(' pactid : '||to_char(pactid));

Line 324: hr_utility.trace(' gre_id : '||to_char(l_gre_id));

320: close c_parameters;
321:
322: hr_utility.set_location('action creation after prm',301);
323: hr_utility.trace('Parmeters: ');
324: hr_utility.trace(' gre_id : '||to_char(l_gre_id));
325: hr_utility.trace(' bg_id : '||to_char(l_bg_id));
326: hr_utility.trace(' as of date: '||l_as_of_date);
327: hr_utility.trace(' pactid : '||to_char(pactid));
328: hr_utility.trace(' chunk : '||to_char(chunk));

Line 325: hr_utility.trace(' bg_id : '||to_char(l_bg_id));

321:
322: hr_utility.set_location('action creation after prm',301);
323: hr_utility.trace('Parmeters: ');
324: hr_utility.trace(' gre_id : '||to_char(l_gre_id));
325: hr_utility.trace(' bg_id : '||to_char(l_bg_id));
326: hr_utility.trace(' as of date: '||l_as_of_date);
327: hr_utility.trace(' pactid : '||to_char(pactid));
328: hr_utility.trace(' chunk : '||to_char(chunk));
329: hr_utility.trace(' loc_id : '||to_char(l_loc_id)); -- l_loc_id

Line 326: hr_utility.trace(' as of date: '||l_as_of_date);

322: hr_utility.set_location('action creation after prm',301);
323: hr_utility.trace('Parmeters: ');
324: hr_utility.trace(' gre_id : '||to_char(l_gre_id));
325: hr_utility.trace(' bg_id : '||to_char(l_bg_id));
326: hr_utility.trace(' as of date: '||l_as_of_date);
327: hr_utility.trace(' pactid : '||to_char(pactid));
328: hr_utility.trace(' chunk : '||to_char(chunk));
329: hr_utility.trace(' loc_id : '||to_char(l_loc_id)); -- l_loc_id
330: hr_utility.trace(' org_id : '||to_char(l_org_id)); -- l_org_id

Line 327: hr_utility.trace(' pactid : '||to_char(pactid));

323: hr_utility.trace('Parmeters: ');
324: hr_utility.trace(' gre_id : '||to_char(l_gre_id));
325: hr_utility.trace(' bg_id : '||to_char(l_bg_id));
326: hr_utility.trace(' as of date: '||l_as_of_date);
327: hr_utility.trace(' pactid : '||to_char(pactid));
328: hr_utility.trace(' chunk : '||to_char(chunk));
329: hr_utility.trace(' loc_id : '||to_char(l_loc_id)); -- l_loc_id
330: hr_utility.trace(' org_id : '||to_char(l_org_id)); -- l_org_id
331: hr_utility.trace(' stperson : '|| to_char(stperson));

Line 328: hr_utility.trace(' chunk : '||to_char(chunk));

324: hr_utility.trace(' gre_id : '||to_char(l_gre_id));
325: hr_utility.trace(' bg_id : '||to_char(l_bg_id));
326: hr_utility.trace(' as of date: '||l_as_of_date);
327: hr_utility.trace(' pactid : '||to_char(pactid));
328: hr_utility.trace(' chunk : '||to_char(chunk));
329: hr_utility.trace(' loc_id : '||to_char(l_loc_id)); -- l_loc_id
330: hr_utility.trace(' org_id : '||to_char(l_org_id)); -- l_org_id
331: hr_utility.trace(' stperson : '|| to_char(stperson));
332: hr_utility.trace(' endperson : '|| to_char(endperson));

Line 329: hr_utility.trace(' loc_id : '||to_char(l_loc_id)); -- l_loc_id

325: hr_utility.trace(' bg_id : '||to_char(l_bg_id));
326: hr_utility.trace(' as of date: '||l_as_of_date);
327: hr_utility.trace(' pactid : '||to_char(pactid));
328: hr_utility.trace(' chunk : '||to_char(chunk));
329: hr_utility.trace(' loc_id : '||to_char(l_loc_id)); -- l_loc_id
330: hr_utility.trace(' org_id : '||to_char(l_org_id)); -- l_org_id
331: hr_utility.trace(' stperson : '|| to_char(stperson));
332: hr_utility.trace(' endperson : '|| to_char(endperson));
333:

Line 330: hr_utility.trace(' org_id : '||to_char(l_org_id)); -- l_org_id

326: hr_utility.trace(' as of date: '||l_as_of_date);
327: hr_utility.trace(' pactid : '||to_char(pactid));
328: hr_utility.trace(' chunk : '||to_char(chunk));
329: hr_utility.trace(' loc_id : '||to_char(l_loc_id)); -- l_loc_id
330: hr_utility.trace(' org_id : '||to_char(l_org_id)); -- l_org_id
331: hr_utility.trace(' stperson : '|| to_char(stperson));
332: hr_utility.trace(' endperson : '|| to_char(endperson));
333:
334: hr_utility.set_location('action creation before ref cursor',302);

Line 331: hr_utility.trace(' stperson : '|| to_char(stperson));

327: hr_utility.trace(' pactid : '||to_char(pactid));
328: hr_utility.trace(' chunk : '||to_char(chunk));
329: hr_utility.trace(' loc_id : '||to_char(l_loc_id)); -- l_loc_id
330: hr_utility.trace(' org_id : '||to_char(l_org_id)); -- l_org_id
331: hr_utility.trace(' stperson : '|| to_char(stperson));
332: hr_utility.trace(' endperson : '|| to_char(endperson));
333:
334: hr_utility.set_location('action creation before ref cursor',302);
335: --

Line 332: hr_utility.trace(' endperson : '|| to_char(endperson));

328: hr_utility.trace(' chunk : '||to_char(chunk));
329: hr_utility.trace(' loc_id : '||to_char(l_loc_id)); -- l_loc_id
330: hr_utility.trace(' org_id : '||to_char(l_org_id)); -- l_org_id
331: hr_utility.trace(' stperson : '|| to_char(stperson));
332: hr_utility.trace(' endperson : '|| to_char(endperson));
333:
334: hr_utility.set_location('action creation before ref cursor',302);
335: --
336: if pay_ac_utility.range_person_on(

Line 334: hr_utility.set_location('action creation before ref cursor',302);

330: hr_utility.trace(' org_id : '||to_char(l_org_id)); -- l_org_id
331: hr_utility.trace(' stperson : '|| to_char(stperson));
332: hr_utility.trace(' endperson : '|| to_char(endperson));
333:
334: hr_utility.set_location('action creation before ref cursor',302);
335: --
336: if pay_ac_utility.range_person_on(
337: P_REPORT_TYPE => 'OLT',
338: P_REPORT_FORMAT => 'DEFAULT',

Line 343: hr_utility.set_location('action creation before opening ref cursor',303);

339: P_REPORT_QUALIFIER => 'DEFAULT',
340: P_REPORT_CATEGORY => 'REPORT'
341: ) then
342:
343: hr_utility.set_location('action creation before opening ref cursor',303);
344: hr_utility.trace('Range Person id is ON');
345:
346:
347: lv_sqlstr := 'select distinct paf.person_id person_id,

Line 344: hr_utility.trace('Range Person id is ON');

340: P_REPORT_CATEGORY => 'REPORT'
341: ) then
342:
343: hr_utility.set_location('action creation before opening ref cursor',303);
344: hr_utility.trace('Range Person id is ON');
345:
346:
347: lv_sqlstr := 'select distinct paf.person_id person_id,
348: paf.assignment_id,

Line 373: hr_utility.set_location('action creation before opening ref cursor',304);

369: and paf.effective_end_date
370: order by 1, 3';
371: else
372:
373: hr_utility.set_location('action creation before opening ref cursor',304);
374: hr_utility.trace('Range Person id is Off');
375:
376: -- 5840569
377: lv_where_condition := '' ;

Line 374: hr_utility.trace('Range Person id is Off');

370: order by 1, 3';
371: else
372:
373: hr_utility.set_location('action creation before opening ref cursor',304);
374: hr_utility.trace('Range Person id is Off');
375:
376: -- 5840569
377: lv_where_condition := '' ;
378: if l_gre_id is not null then

Line 387: hr_utility.trace('lv_where_condition :'||lv_where_condition) ;

383: end if;
384: if l_loc_id is not null then
385: lv_where_condition := lv_where_condition||' and paf.location_id ='||l_loc_id ;
386: end if;
387: hr_utility.trace('lv_where_condition :'||lv_where_condition) ;
388:
389: lv_sqlstr := 'select
390: /*+ ORDERED
391: index(ppa PAY_PAYROLL_ACTIONS_PK)

Line 418: hr_utility.set_location('action creation before opening ref cursor',305);

414: lv_where_condition ||
415: ' order by 1, 3';
416: end if;
417:
418: hr_utility.set_location('action creation before opening ref cursor',305);
419: open c_seq_act for lv_sqlstr;
420: loop
421: hr_utility.set_location('in ref cursor loop',310);
422: fetch c_seq_act into ln_personid,ln_assgid,ln_greid;

Line 421: hr_utility.set_location('in ref cursor loop',310);

417:
418: hr_utility.set_location('action creation before opening ref cursor',305);
419: open c_seq_act for lv_sqlstr;
420: loop
421: hr_utility.set_location('in ref cursor loop',310);
422: fetch c_seq_act into ln_personid,ln_assgid,ln_greid;
423: if c_seq_act%notfound then
424: hr_utility.set_location('exiting from ref cursor loop',320);
425: exit;

Line 424: hr_utility.set_location('exiting from ref cursor loop',320);

420: loop
421: hr_utility.set_location('in ref cursor loop',310);
422: fetch c_seq_act into ln_personid,ln_assgid,ln_greid;
423: if c_seq_act%notfound then
424: hr_utility.set_location('exiting from ref cursor loop',320);
425: exit;
426: end if;
427: hr_utility.set_location('Insert action',320);
428: hr_utility.trace('ln_personid='||ln_personid);

Line 427: hr_utility.set_location('Insert action',320);

423: if c_seq_act%notfound then
424: hr_utility.set_location('exiting from ref cursor loop',320);
425: exit;
426: end if;
427: hr_utility.set_location('Insert action',320);
428: hr_utility.trace('ln_personid='||ln_personid);
429: hr_utility.trace('ln_assgid'||ln_assgid);
430: hr_utility.trace('ln_greid='||ln_greid);
431:

Line 428: hr_utility.trace('ln_personid='||ln_personid);

424: hr_utility.set_location('exiting from ref cursor loop',320);
425: exit;
426: end if;
427: hr_utility.set_location('Insert action',320);
428: hr_utility.trace('ln_personid='||ln_personid);
429: hr_utility.trace('ln_assgid'||ln_assgid);
430: hr_utility.trace('ln_greid='||ln_greid);
431:
432: insert_action(pactid => pactid,

Line 429: hr_utility.trace('ln_assgid'||ln_assgid);

425: exit;
426: end if;
427: hr_utility.set_location('Insert action',320);
428: hr_utility.trace('ln_personid='||ln_personid);
429: hr_utility.trace('ln_assgid'||ln_assgid);
430: hr_utility.trace('ln_greid='||ln_greid);
431:
432: insert_action(pactid => pactid,
433: chunk => chunk,

Line 430: hr_utility.trace('ln_greid='||ln_greid);

426: end if;
427: hr_utility.set_location('Insert action',320);
428: hr_utility.trace('ln_personid='||ln_personid);
429: hr_utility.trace('ln_assgid'||ln_assgid);
430: hr_utility.trace('ln_greid='||ln_greid);
431:
432: insert_action(pactid => pactid,
433: chunk => chunk,
434: p_greid => ln_greid,

Line 441: hr_utility.set_location('OUT action_creation',350);

437: );
438: end loop;
439: close c_seq_act;
440:
441: hr_utility.set_location('OUT action_creation',350);
442: end action_creation;
443: --
444: --
445: ------------------------------ sort_action ------------------------------------

Line 469: hr_utility.set_location('IN sort_action',400);

465: from pay_payroll_actions ppa
466: where ppa.payroll_action_id = pactid;
467: --
468: begin
469: hr_utility.set_location('IN sort_action',400);
470: open c_parameters(pactid);
471: fetch c_parameters into leg_param,
472: l_sort1,
473: l_sort2,

Line 476: hr_utility.trace('Legislative parameters not found for pactid '||pactid);

472: l_sort1,
473: l_sort2,
474: l_sort3;
475: if c_parameters%notfound then
476: hr_utility.trace('Legislative parameters not found for pactid '||pactid);
477: close c_parameters;
478: -- raise;
479: end if;
480: close c_parameters;

Line 520: hr_utility.trace('Sort sql string length = '||to_char(len));

516: ''Location'',rpad(hl.location_code, 63))
517: ';
518: len := length(sqlstr); -- return the length of the string.
519:
520: hr_utility.trace('Sort sql string length = '||to_char(len));
521: hr_utility.set_location('OUT sort_action',450);
522: -- hr_utility.trace_off;
523:
524: end sort_action;

Line 521: hr_utility.set_location('OUT sort_action',450);

517: ';
518: len := length(sqlstr); -- return the length of the string.
519:
520: hr_utility.trace('Sort sql string length = '||to_char(len));
521: hr_utility.set_location('OUT sort_action',450);
522: -- hr_utility.trace_off;
523:
524: end sort_action;
525:

Line 522: -- hr_utility.trace_off;

518: len := length(sqlstr); -- return the length of the string.
519:
520: hr_utility.trace('Sort sql string length = '||to_char(len));
521: hr_utility.set_location('OUT sort_action',450);
522: -- hr_utility.trace_off;
523:
524: end sort_action;
525:
526: --