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

Line 74: hr_utility.set_location(l_proc, 10);

70:
71: begin
72:
73: l_proc := g_package||'range_cursor';
74: hr_utility.set_location(l_proc, 10);
75: hr_utility.trace('PACTID = '||to_char(pactid));
76:
77: select ppa.legislative_parameters,
78: ppa.business_group_id

Line 75: hr_utility.trace('PACTID = '||to_char(pactid));

71: begin
72:
73: l_proc := g_package||'range_cursor';
74: hr_utility.set_location(l_proc, 10);
75: hr_utility.trace('PACTID = '||to_char(pactid));
76:
77: select ppa.legislative_parameters,
78: ppa.business_group_id
79: into lv_legislative_param, ln_business_group_id

Line 83: hr_utility.set_location(l_proc, 20);

79: into lv_legislative_param, ln_business_group_id
80: from pay_payroll_actions ppa
81: where payroll_action_id = pactid;
82:
83: hr_utility.set_location(l_proc, 20);
84:
85: open c_get_leg_code(ln_business_group_id);
86: fetch c_get_leg_code into lv_legislation_code;
87: close c_get_leg_code;

Line 89: hr_utility.set_location(l_proc, 30);

85: open c_get_leg_code(ln_business_group_id);
86: fetch c_get_leg_code into lv_legislation_code;
87: close c_get_leg_code;
88:
89: hr_utility.set_location(l_proc, 30);
90:
91: BEGIN
92: EXECUTE IMMEDIATE 'BEGIN PAY_'||lv_legislation_code||
93: '_ARCHIVE_RULES.RANGE_CURSOR(:a, :b); END;'

Line 96: hr_utility.set_location(l_proc, 40);

92: EXECUTE IMMEDIATE 'BEGIN PAY_'||lv_legislation_code||
93: '_ARCHIVE_RULES.RANGE_CURSOR(:a, :b); END;'
94: USING IN pactid, OUT lv_rc_where;
95:
96: hr_utility.set_location(l_proc, 40);
97:
98: EXCEPTION WHEN others THEN
99: hr_utility.set_location(l_proc, 50);
100: NULL;

Line 99: hr_utility.set_location(l_proc, 50);

95:
96: hr_utility.set_location(l_proc, 40);
97:
98: EXCEPTION WHEN others THEN
99: hr_utility.set_location(l_proc, 50);
100: NULL;
101: END;
102:
103: hr_utility.set_location(l_proc, 60);

Line 103: hr_utility.set_location(l_proc, 60);

99: hr_utility.set_location(l_proc, 50);
100: NULL;
101: END;
102:
103: hr_utility.set_location(l_proc, 60);
104:
105: sqlstr := 'SELECT distinct ASG.person_id
106: FROM per_all_assignments_f ASG,
107: pay_payroll_actions PPA

Line 123: hr_utility.trace(sqlstr);

119: ||lv_rc_where||
120: ')
121: ORDER BY ASG.person_id';
122:
123: hr_utility.trace(sqlstr);
124:
125: exception when others then
126: hr_utility.trace('Error in range_cursor - '||to_char(sqlcode) || '-' || sqlerrm);
127:

Line 126: hr_utility.trace('Error in range_cursor - '||to_char(sqlcode) || '-' || sqlerrm);

122:
123: hr_utility.trace(sqlstr);
124:
125: exception when others then
126: hr_utility.trace('Error in range_cursor - '||to_char(sqlcode) || '-' || sqlerrm);
127:
128: end range_cursor;
129:
130: ---------------------------------- action_creation ----------------------------------

Line 187: hr_utility.set_location(l_proc, 10);

183:
184: BEGIN
185:
186: l_proc := g_package||'action_creation';
187: hr_utility.set_location(l_proc, 10);
188:
189: l_step := 1;
190: SELECT effective_date
191: ,pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters)

Line 206: hr_utility.trace('g_effective_date:'|| to_char(g_effective_date,'dd-mm-yyyy'));

202: FROM pay_payroll_actions
203: WHERE payroll_action_id = pactid;
204:
205:
206: hr_utility.trace('g_effective_date:'|| to_char(g_effective_date,'dd-mm-yyyy'));
207: hr_utility.trace('g_tax_unit_id:'|| to_char(g_tax_unit_id));
208: hr_utility.trace('business_group_id:'|| to_char(ln_business_group_id));
209: hr_utility.trace('report_type:'|| lv_report_type);
210: hr_utility.trace('report_qualifier:'|| lv_report_qualifier);

Line 207: hr_utility.trace('g_tax_unit_id:'|| to_char(g_tax_unit_id));

203: WHERE payroll_action_id = pactid;
204:
205:
206: hr_utility.trace('g_effective_date:'|| to_char(g_effective_date,'dd-mm-yyyy'));
207: hr_utility.trace('g_tax_unit_id:'|| to_char(g_tax_unit_id));
208: hr_utility.trace('business_group_id:'|| to_char(ln_business_group_id));
209: hr_utility.trace('report_type:'|| lv_report_type);
210: hr_utility.trace('report_qualifier:'|| lv_report_qualifier);
211: hr_utility.trace('report_category:'|| lv_report_category);

Line 208: hr_utility.trace('business_group_id:'|| to_char(ln_business_group_id));

204:
205:
206: hr_utility.trace('g_effective_date:'|| to_char(g_effective_date,'dd-mm-yyyy'));
207: hr_utility.trace('g_tax_unit_id:'|| to_char(g_tax_unit_id));
208: hr_utility.trace('business_group_id:'|| to_char(ln_business_group_id));
209: hr_utility.trace('report_type:'|| lv_report_type);
210: hr_utility.trace('report_qualifier:'|| lv_report_qualifier);
211: hr_utility.trace('report_category:'|| lv_report_category);
212:

Line 209: hr_utility.trace('report_type:'|| lv_report_type);

205:
206: hr_utility.trace('g_effective_date:'|| to_char(g_effective_date,'dd-mm-yyyy'));
207: hr_utility.trace('g_tax_unit_id:'|| to_char(g_tax_unit_id));
208: hr_utility.trace('business_group_id:'|| to_char(ln_business_group_id));
209: hr_utility.trace('report_type:'|| lv_report_type);
210: hr_utility.trace('report_qualifier:'|| lv_report_qualifier);
211: hr_utility.trace('report_category:'|| lv_report_category);
212:
213: open c_get_leg_code(ln_business_group_id);

Line 210: hr_utility.trace('report_qualifier:'|| lv_report_qualifier);

206: hr_utility.trace('g_effective_date:'|| to_char(g_effective_date,'dd-mm-yyyy'));
207: hr_utility.trace('g_tax_unit_id:'|| to_char(g_tax_unit_id));
208: hr_utility.trace('business_group_id:'|| to_char(ln_business_group_id));
209: hr_utility.trace('report_type:'|| lv_report_type);
210: hr_utility.trace('report_qualifier:'|| lv_report_qualifier);
211: hr_utility.trace('report_category:'|| lv_report_category);
212:
213: open c_get_leg_code(ln_business_group_id);
214: fetch c_get_leg_code into lv_legislation_code;

Line 211: hr_utility.trace('report_category:'|| lv_report_category);

207: hr_utility.trace('g_tax_unit_id:'|| to_char(g_tax_unit_id));
208: hr_utility.trace('business_group_id:'|| to_char(ln_business_group_id));
209: hr_utility.trace('report_type:'|| lv_report_type);
210: hr_utility.trace('report_qualifier:'|| lv_report_qualifier);
211: hr_utility.trace('report_category:'|| lv_report_category);
212:
213: open c_get_leg_code(ln_business_group_id);
214: fetch c_get_leg_code into lv_legislation_code;
215: close c_get_leg_code;

Line 219: hr_utility.trace('year start '|| to_char(l_year_start,'dd-mm-yyyy'));

215: close c_get_leg_code;
216:
217: l_year_start := trunc(g_effective_date, 'Y');
218: l_year_end := add_months(trunc(g_effective_date, 'Y'),12) -1;
219: hr_utility.trace('year start '|| to_char(l_year_start,'dd-mm-yyyy'));
220: hr_utility.trace('year end '|| to_char(l_year_end,'dd-mm-yyyy'));
221:
222: open c_get_report_format(lv_report_type, lv_report_qualifier,
223: lv_report_category, l_year_start, l_year_end);

Line 220: hr_utility.trace('year end '|| to_char(l_year_end,'dd-mm-yyyy'));

216:
217: l_year_start := trunc(g_effective_date, 'Y');
218: l_year_end := add_months(trunc(g_effective_date, 'Y'),12) -1;
219: hr_utility.trace('year start '|| to_char(l_year_start,'dd-mm-yyyy'));
220: hr_utility.trace('year end '|| to_char(l_year_end,'dd-mm-yyyy'));
221:
222: open c_get_report_format(lv_report_type, lv_report_qualifier,
223: lv_report_category, l_year_start, l_year_end);
224: fetch c_get_report_format into lv_report_format;

Line 226: hr_utility.trace('report_format:'|| lv_report_format);

222: open c_get_report_format(lv_report_type, lv_report_qualifier,
223: lv_report_category, l_year_start, l_year_end);
224: fetch c_get_report_format into lv_report_format;
225: close c_get_report_format;
226: hr_utility.trace('report_format:'|| lv_report_format);
227:
228:
229: lv_range_person_on := pay_ac_utility.range_person_on(
230: p_report_type => lv_report_type

Line 237: hr_utility.set_location(l_proc, 20);

233: ,p_report_category => lv_report_category
234: );
235:
236: l_step := 2;
237: hr_utility.set_location(l_proc, 20);
238:
239: BEGIN
240: EXECUTE IMMEDIATE 'BEGIN PAY_'|| lv_legislation_code ||
241: '_ARCHIVE_RULES.ACTION_CREATION(:a, :b, :c, :d, :e); END;'

Line 244: hr_utility.set_location(l_proc, 30);

240: EXECUTE IMMEDIATE 'BEGIN PAY_'|| lv_legislation_code ||
241: '_ARCHIVE_RULES.ACTION_CREATION(:a, :b, :c, :d, :e); END;'
242: USING IN pactid, IN stperson, IN endperson, IN chunk, OUT lv_ac_where;
243:
244: hr_utility.set_location(l_proc, 30);
245:
246: EXCEPTION WHEN others THEN
247: hr_utility.set_location(l_proc, 40);
248: NULL;

Line 247: hr_utility.set_location(l_proc, 40);

243:
244: hr_utility.set_location(l_proc, 30);
245:
246: EXCEPTION WHEN others THEN
247: hr_utility.set_location(l_proc, 40);
248: NULL;
249: END;
250: l_step := 3;
251:

Line 253: hr_utility.trace ('Person ranges are ON');

249: END;
250: l_step := 3;
251:
252: IF lv_range_person_on THEN
253: hr_utility.trace ('Person ranges are ON');
254: hr_utility.trace('chunk ='|| chunk);
255: hr_utility.trace('l_year_start ='|| l_year_start);
256: hr_utility.trace('l_year_end ='|| l_year_end);
257: hr_utility.trace('stperson ='|| stperson);

Line 254: hr_utility.trace('chunk ='|| chunk);

250: l_step := 3;
251:
252: IF lv_range_person_on THEN
253: hr_utility.trace ('Person ranges are ON');
254: hr_utility.trace('chunk ='|| chunk);
255: hr_utility.trace('l_year_start ='|| l_year_start);
256: hr_utility.trace('l_year_end ='|| l_year_end);
257: hr_utility.trace('stperson ='|| stperson);
258: hr_utility.trace('endperson ='|| endperson);

Line 255: hr_utility.trace('l_year_start ='|| l_year_start);

251:
252: IF lv_range_person_on THEN
253: hr_utility.trace ('Person ranges are ON');
254: hr_utility.trace('chunk ='|| chunk);
255: hr_utility.trace('l_year_start ='|| l_year_start);
256: hr_utility.trace('l_year_end ='|| l_year_end);
257: hr_utility.trace('stperson ='|| stperson);
258: hr_utility.trace('endperson ='|| endperson);
259: c_actions_sql :=

Line 256: hr_utility.trace('l_year_end ='|| l_year_end);

252: IF lv_range_person_on THEN
253: hr_utility.trace ('Person ranges are ON');
254: hr_utility.trace('chunk ='|| chunk);
255: hr_utility.trace('l_year_start ='|| l_year_start);
256: hr_utility.trace('l_year_end ='|| l_year_end);
257: hr_utility.trace('stperson ='|| stperson);
258: hr_utility.trace('endperson ='|| endperson);
259: c_actions_sql :=
260: 'SELECT distinct paf.assignment_id asg_id,

Line 257: hr_utility.trace('stperson ='|| stperson);

253: hr_utility.trace ('Person ranges are ON');
254: hr_utility.trace('chunk ='|| chunk);
255: hr_utility.trace('l_year_start ='|| l_year_start);
256: hr_utility.trace('l_year_end ='|| l_year_end);
257: hr_utility.trace('stperson ='|| stperson);
258: hr_utility.trace('endperson ='|| endperson);
259: c_actions_sql :=
260: 'SELECT distinct paf.assignment_id asg_id,
261: paa.assignment_action_id assact

Line 258: hr_utility.trace('endperson ='|| endperson);

254: hr_utility.trace('chunk ='|| chunk);
255: hr_utility.trace('l_year_start ='|| l_year_start);
256: hr_utility.trace('l_year_end ='|| l_year_end);
257: hr_utility.trace('stperson ='|| stperson);
258: hr_utility.trace('endperson ='|| endperson);
259: c_actions_sql :=
260: 'SELECT distinct paf.assignment_id asg_id,
261: paa.assignment_action_id assact
262: FROM per_all_assignments_f paf,

Line 285: hr_utility.trace ('Person ranges are OFF');

281: AND paf.person_id between '|| stperson ||' and '|| endperson ||'
282: '|| lv_ac_where ||'
283: ORDER BY paf.assignment_id';
284: ELSE
285: hr_utility.trace ('Person ranges are OFF');
286: c_actions_sql :=
287: 'SELECT distinct paf.assignment_id asg_id,
288: paa.assignment_action_id assact
289: FROM per_all_assignments_f paf,

Line 309: --hr_utility.trace(c_actions_sql);

305: AND paf.person_id between '|| stperson ||' and '|| endperson ||'
306: '|| lv_ac_where ||'
307: ORDER BY paf.assignment_id';
308: END IF;
309: --hr_utility.trace(c_actions_sql);
310: hr_utility.trace('after execution');
311: OPEN c_actions FOR c_actions_sql;
312: l_step := 4;
313: LOOP

Line 310: hr_utility.trace('after execution');

306: '|| lv_ac_where ||'
307: ORDER BY paf.assignment_id';
308: END IF;
309: --hr_utility.trace(c_actions_sql);
310: hr_utility.trace('after execution');
311: OPEN c_actions FOR c_actions_sql;
312: l_step := 4;
313: LOOP
314: FETCH c_actions INTO assignid,lockedactid;

Line 316: hr_utility.trace('assignid = ' || assignid);

312: l_step := 4;
313: LOOP
314: FETCH c_actions INTO assignid,lockedactid;
315: EXIT WHEN c_actions%NOTFOUND;
316: hr_utility.trace('assignid = ' || assignid);
317: hr_utility.trace('lockedactid = ' || lockedactid);
318:
319:
320: SELECT pay_assignment_actions_s.nextval

Line 317: hr_utility.trace('lockedactid = ' || lockedactid);

313: LOOP
314: FETCH c_actions INTO assignid,lockedactid;
315: EXIT WHEN c_actions%NOTFOUND;
316: hr_utility.trace('assignid = ' || assignid);
317: hr_utility.trace('lockedactid = ' || lockedactid);
318:
319:
320: SELECT pay_assignment_actions_s.nextval
321: INTO lockingactid

Line 334: hr_utility.trace('inserted into temp object actions - ' || lockingactid);

330: pactid =>pactid,
331: chunk =>chunk,
332: greid =>g_tax_unit_id ---it should be passed as null for RL1 and RL2
333: );
334: hr_utility.trace('inserted into temp object actions - ' || lockingactid);
335: END LOOP;
336: CLOSE c_actions;
337:
338: hr_utility.trace('leaving action_creation');

Line 338: hr_utility.trace('leaving action_creation');

334: hr_utility.trace('inserted into temp object actions - ' || lockingactid);
335: END LOOP;
336: CLOSE c_actions;
337:
338: hr_utility.trace('leaving action_creation');
339:
340: EXCEPTION
341: WHEN OTHERS THEN
342: raise_application_error(-20001,'Error in action_creation in Step ' || l_step);

Line 393: hr_utility.set_location(l_proc, 10);

389:
390: BEGIN
391:
392: l_proc := g_package||'archive_init';
393: hr_utility.set_location(l_proc, 10);
394: --
395: g_payroll_action_id := p_payroll_action_id;
396: --
397: l_count := 0;

Line 435: hr_utility.trace('Checking Attribute = '|| l_bal_attribute_name);

431: l_business_group_id,
432: l_bal_attribute_name,
433: l_leg_code);
434:
435: hr_utility.trace('Checking Attribute = '|| l_bal_attribute_name);
436: hr_utility.trace('g_run_balance_status = '|| g_run_balance_status);
437:
438: l_count := l_count + 1;
439:

Line 436: hr_utility.trace('g_run_balance_status = '|| g_run_balance_status);

432: l_bal_attribute_name,
433: l_leg_code);
434:
435: hr_utility.trace('Checking Attribute = '|| l_bal_attribute_name);
436: hr_utility.trace('g_run_balance_status = '|| g_run_balance_status);
437:
438: l_count := l_count + 1;
439:
440: IF (g_run_balance_status = 'N') THEN

Line 448: hr_utility.trace('Outside g_run_balance_status = '|| g_run_balance_status);

444: END LOOP;
445: CLOSE c_get_bal_attributes;
446: l_step := 5;
447:
448: hr_utility.trace('Outside g_run_balance_status = '|| g_run_balance_status);
449: hr_utility.trace('leaving archive_init');
450:
451: EXCEPTION WHEN NO_DATA_FOUND THEN
452: raise_application_error(-20001,'In Archive_Init No Data Found In Step '|| l_step);

Line 449: hr_utility.trace('leaving archive_init');

445: CLOSE c_get_bal_attributes;
446: l_step := 5;
447:
448: hr_utility.trace('Outside g_run_balance_status = '|| g_run_balance_status);
449: hr_utility.trace('leaving archive_init');
450:
451: EXCEPTION WHEN NO_DATA_FOUND THEN
452: raise_application_error(-20001,'In Archive_Init No Data Found In Step '|| l_step);
453:

Line 495: hr_utility.set_location(l_proc, 10);

491:
492: begin
493:
494: l_proc := g_package||'archive_code';
495: hr_utility.set_location(l_proc, 10);
496:
497: l_step := 1;
498:
499: SELECT aa.object_id,

Line 508: hr_utility.trace('l_asgid = ' || l_asgid);

504: l_payroll_action_id
505: FROM pay_temp_object_actions aa
506: WHERE aa.object_action_id = p_assignment_action_id;
507:
508: hr_utility.trace('l_asgid = ' || l_asgid);
509: hr_utility.trace('l_chunk = ' || l_chunk);
510: hr_utility.trace('l_payroll_action_id = ' || l_payroll_action_id);
511: hr_utility.trace('g_run_balance_status = ' || g_run_balance_status);
512:

Line 509: hr_utility.trace('l_chunk = ' || l_chunk);

505: FROM pay_temp_object_actions aa
506: WHERE aa.object_action_id = p_assignment_action_id;
507:
508: hr_utility.trace('l_asgid = ' || l_asgid);
509: hr_utility.trace('l_chunk = ' || l_chunk);
510: hr_utility.trace('l_payroll_action_id = ' || l_payroll_action_id);
511: hr_utility.trace('g_run_balance_status = ' || g_run_balance_status);
512:
513: open c_get_session_id;

Line 510: hr_utility.trace('l_payroll_action_id = ' || l_payroll_action_id);

506: WHERE aa.object_action_id = p_assignment_action_id;
507:
508: hr_utility.trace('l_asgid = ' || l_asgid);
509: hr_utility.trace('l_chunk = ' || l_chunk);
510: hr_utility.trace('l_payroll_action_id = ' || l_payroll_action_id);
511: hr_utility.trace('g_run_balance_status = ' || g_run_balance_status);
512:
513: open c_get_session_id;
514: fetch c_get_session_id into g_session_id;

Line 511: hr_utility.trace('g_run_balance_status = ' || g_run_balance_status);

507:
508: hr_utility.trace('l_asgid = ' || l_asgid);
509: hr_utility.trace('l_chunk = ' || l_chunk);
510: hr_utility.trace('l_payroll_action_id = ' || l_payroll_action_id);
511: hr_utility.trace('g_run_balance_status = ' || g_run_balance_status);
512:
513: open c_get_session_id;
514: fetch c_get_session_id into g_session_id;
515: hr_utility.trace('g_session_id = '|| g_session_id);

Line 515: hr_utility.trace('g_session_id = '|| g_session_id);

511: hr_utility.trace('g_run_balance_status = ' || g_run_balance_status);
512:
513: open c_get_session_id;
514: fetch c_get_session_id into g_session_id;
515: hr_utility.trace('g_session_id = '|| g_session_id);
516: close c_get_session_id;
517:
518: select ppa.business_group_id
519: into ln_business_group_id

Line 523: hr_utility.set_location(l_proc, 20);

519: into ln_business_group_id
520: from pay_payroll_actions ppa
521: where payroll_action_id = l_payroll_action_id;
522:
523: hr_utility.set_location(l_proc, 20);
524:
525: open c_get_leg_code(ln_business_group_id);
526: fetch c_get_leg_code into lv_legislation_code;
527: close c_get_leg_code;

Line 529: hr_utility.set_location(l_proc, 30);

525: open c_get_leg_code(ln_business_group_id);
526: fetch c_get_leg_code into lv_legislation_code;
527: close c_get_leg_code;
528:
529: hr_utility.set_location(l_proc, 30);
530:
531: BEGIN
532: EXECUTE IMMEDIATE 'BEGIN PAY_'|| lv_legislation_code ||
533: '_ARCHIVE_RULES.archive_code(:a, :b); END;'

Line 536: hr_utility.set_location(l_proc, 30);

532: EXECUTE IMMEDIATE 'BEGIN PAY_'|| lv_legislation_code ||
533: '_ARCHIVE_RULES.archive_code(:a, :b); END;'
534: USING IN l_payroll_action_id, OUT lv_ac_where;
535:
536: hr_utility.set_location(l_proc, 30);
537:
538: EXCEPTION WHEN others THEN
539: hr_utility.set_location(l_proc, 40);
540: NULL;

Line 539: hr_utility.set_location(l_proc, 40);

535:
536: hr_utility.set_location(l_proc, 30);
537:
538: EXCEPTION WHEN others THEN
539: hr_utility.set_location(l_proc, 40);
540: NULL;
541: END;
542:
543: hr_utility.trace('l_asgid = '|| l_asgid);

Line 543: hr_utility.trace('l_asgid = '|| l_asgid);

539: hr_utility.set_location(l_proc, 40);
540: NULL;
541: END;
542:
543: hr_utility.trace('l_asgid = '|| l_asgid);
544: hr_utility.trace('g_effective_date = '||g_effective_date);
545: hr_utility.trace('g_tax_unit_id = '||g_tax_unit_id);
546: if g_run_balance_status = 'Y' then --As of this version all balances should be valid
547: for lv_count in ltr_def_bal_status.first..ltr_def_bal_status.last loop

Line 544: hr_utility.trace('g_effective_date = '||g_effective_date);

540: NULL;
541: END;
542:
543: hr_utility.trace('l_asgid = '|| l_asgid);
544: hr_utility.trace('g_effective_date = '||g_effective_date);
545: hr_utility.trace('g_tax_unit_id = '||g_tax_unit_id);
546: if g_run_balance_status = 'Y' then --As of this version all balances should be valid
547: for lv_count in ltr_def_bal_status.first..ltr_def_bal_status.last loop
548: hr_utility.trace('lv_result_value_1:'||to_char(lv_result_value));

Line 545: hr_utility.trace('g_tax_unit_id = '||g_tax_unit_id);

541: END;
542:
543: hr_utility.trace('l_asgid = '|| l_asgid);
544: hr_utility.trace('g_effective_date = '||g_effective_date);
545: hr_utility.trace('g_tax_unit_id = '||g_tax_unit_id);
546: if g_run_balance_status = 'Y' then --As of this version all balances should be valid
547: for lv_count in ltr_def_bal_status.first..ltr_def_bal_status.last loop
548: hr_utility.trace('lv_result_value_1:'||to_char(lv_result_value));
549: hr_utility.trace('attribute_id = '||ltr_def_bal_status(lv_count).attribute_id);

Line 548: hr_utility.trace('lv_result_value_1:'||to_char(lv_result_value));

544: hr_utility.trace('g_effective_date = '||g_effective_date);
545: hr_utility.trace('g_tax_unit_id = '||g_tax_unit_id);
546: if g_run_balance_status = 'Y' then --As of this version all balances should be valid
547: for lv_count in ltr_def_bal_status.first..ltr_def_bal_status.last loop
548: hr_utility.trace('lv_result_value_1:'||to_char(lv_result_value));
549: hr_utility.trace('attribute_id = '||ltr_def_bal_status(lv_count).attribute_id);
550: if lv_result_value = 0 then
551: l_step := 2;
552: hr_utility.trace('opened c_non_zero_run_balance');

Line 549: hr_utility.trace('attribute_id = '||ltr_def_bal_status(lv_count).attribute_id);

545: hr_utility.trace('g_tax_unit_id = '||g_tax_unit_id);
546: if g_run_balance_status = 'Y' then --As of this version all balances should be valid
547: for lv_count in ltr_def_bal_status.first..ltr_def_bal_status.last loop
548: hr_utility.trace('lv_result_value_1:'||to_char(lv_result_value));
549: hr_utility.trace('attribute_id = '||ltr_def_bal_status(lv_count).attribute_id);
550: if lv_result_value = 0 then
551: l_step := 2;
552: hr_utility.trace('opened c_non_zero_run_balance');
553: --hr_utility.trace(ltr_def_bal_status(lv_count).attribute_id);

Line 552: hr_utility.trace('opened c_non_zero_run_balance');

548: hr_utility.trace('lv_result_value_1:'||to_char(lv_result_value));
549: hr_utility.trace('attribute_id = '||ltr_def_bal_status(lv_count).attribute_id);
550: if lv_result_value = 0 then
551: l_step := 2;
552: hr_utility.trace('opened c_non_zero_run_balance');
553: --hr_utility.trace(ltr_def_bal_status(lv_count).attribute_id);
554: c_non_zero_run_balance := 'SELECT 1
555: FROM DUAL
556: WHERE EXISTS(

Line 553: --hr_utility.trace(ltr_def_bal_status(lv_count).attribute_id);

549: hr_utility.trace('attribute_id = '||ltr_def_bal_status(lv_count).attribute_id);
550: if lv_result_value = 0 then
551: l_step := 2;
552: hr_utility.trace('opened c_non_zero_run_balance');
553: --hr_utility.trace(ltr_def_bal_status(lv_count).attribute_id);
554: c_non_zero_run_balance := 'SELECT 1
555: FROM DUAL
556: WHERE EXISTS(
557: select 1

Line 568: hr_utility.trace('c_non_zero_run_balance='||c_non_zero_run_balance);

564: ''' and '''||to_char(g_effective_date)||'''
565: and prb.defined_balance_id = pba.defined_balance_id
566: and pba.attribute_id = '||to_char(ltr_def_bal_status(lv_count).attribute_id) ||
567: lv_ac_where||')';
568: hr_utility.trace('c_non_zero_run_balance='||c_non_zero_run_balance);
569: hr_utility.trace('hmmm');
570: open c_run_bal_or_result for c_non_zero_run_balance;
571: hr_utility.trace('hmmm');
572: fetch c_run_bal_or_result into lv_result_value;

Line 569: hr_utility.trace('hmmm');

565: and prb.defined_balance_id = pba.defined_balance_id
566: and pba.attribute_id = '||to_char(ltr_def_bal_status(lv_count).attribute_id) ||
567: lv_ac_where||')';
568: hr_utility.trace('c_non_zero_run_balance='||c_non_zero_run_balance);
569: hr_utility.trace('hmmm');
570: open c_run_bal_or_result for c_non_zero_run_balance;
571: hr_utility.trace('hmmm');
572: fetch c_run_bal_or_result into lv_result_value;
573: hr_utility.trace('lv_result_value_2:'||to_char(lv_result_value));

Line 571: hr_utility.trace('hmmm');

567: lv_ac_where||')';
568: hr_utility.trace('c_non_zero_run_balance='||c_non_zero_run_balance);
569: hr_utility.trace('hmmm');
570: open c_run_bal_or_result for c_non_zero_run_balance;
571: hr_utility.trace('hmmm');
572: fetch c_run_bal_or_result into lv_result_value;
573: hr_utility.trace('lv_result_value_2:'||to_char(lv_result_value));
574: if c_run_bal_or_result%NOTFOUND then
575: l_step := 3;

Line 573: hr_utility.trace('lv_result_value_2:'||to_char(lv_result_value));

569: hr_utility.trace('hmmm');
570: open c_run_bal_or_result for c_non_zero_run_balance;
571: hr_utility.trace('hmmm');
572: fetch c_run_bal_or_result into lv_result_value;
573: hr_utility.trace('lv_result_value_2:'||to_char(lv_result_value));
574: if c_run_bal_or_result%NOTFOUND then
575: l_step := 3;
576: lv_result_value := 0;
577: hr_utility.trace('lv_result_value_3:'||to_char(lv_result_value));

Line 577: hr_utility.trace('lv_result_value_3:'||to_char(lv_result_value));

573: hr_utility.trace('lv_result_value_2:'||to_char(lv_result_value));
574: if c_run_bal_or_result%NOTFOUND then
575: l_step := 3;
576: lv_result_value := 0;
577: hr_utility.trace('lv_result_value_3:'||to_char(lv_result_value));
578: end if;
579: close c_run_bal_or_result;
580: end if;
581: end loop;

Line 583: hr_utility.trace('opened c_non_zero_run_result');

579: close c_run_bal_or_result;
580: end if;
581: end loop;
582: else -- Run Balance Status is 'N'
583: hr_utility.trace('opened c_non_zero_run_result');
584:
585: l_step := 4;
586: c_non_zero_run_result := 'SELECT 1 FROM dual
587: WHERE EXISTS (SELECT 1

Line 620: hr_utility.trace('lv_result_value_4 = '||lv_result_value);

616: )';
617:
618: open c_run_bal_or_result for c_non_zero_run_result;
619: FETCH c_run_bal_or_result into lv_result_value;
620: hr_utility.trace('lv_result_value_4 = '||lv_result_value);
621: CLOSE c_run_bal_or_result;
622:
623: end if;
624:

Line 625: hr_utility.trace('lv_result_value_5:'||to_char(lv_result_value));

621: CLOSE c_run_bal_or_result;
622:
623: end if;
624:
625: hr_utility.trace('lv_result_value_5:'||to_char(lv_result_value));
626:
627: l_step := 5;
628: if lv_result_value = 1 then
629: --

Line 630: hr_utility.trace('lv_result_value_6:'||to_char(lv_result_value));

626:
627: l_step := 5;
628: if lv_result_value = 1 then
629: --
630: hr_utility.trace('lv_result_value_6:'||to_char(lv_result_value));
631: insert
632: into pay_us_rpt_totals(
633: session_id,
634: tax_unit_id,

Line 651: hr_utility.trace('assignment_id = ' || l_asgid);

647:
648:
649:
650:
651: hr_utility.trace('assignment_id = ' || l_asgid);
652: end if;
653:
654: hr_utility.trace('leaving archive_code');
655:

Line 654: hr_utility.trace('leaving archive_code');

650:
651: hr_utility.trace('assignment_id = ' || l_asgid);
652: end if;
653:
654: hr_utility.trace('leaving archive_code');
655:
656: exception
657: when others then
658: hr_utility.trace(sqlcode||':'||sqlerrm);

Line 658: hr_utility.trace(sqlcode||':'||sqlerrm);

654: hr_utility.trace('leaving archive_code');
655:
656: exception
657: when others then
658: hr_utility.trace(sqlcode||':'||sqlerrm);
659: raise_application_error(-20001,'Error in archive_code in Step ' || l_step);
660:
661: end ARCHIVE_CODE;
662:

Line 673: hr_utility.set_location(l_proc, 10);

669:
670: begin
671:
672: l_proc := g_package||'archive_deinit';
673: hr_utility.set_location(l_proc, 10);
674:
675: --
676: select effective_date,
677: pay_core_utils.get_parameter('TRANSFER_GRE',

Line 684: hr_utility.trace('g_effective_date ='||g_effective_date);

680: g_tax_unit_id
681: from pay_payroll_actions
682: where payroll_action_id = p_payroll_action_id;
683: --
684: hr_utility.trace('g_effective_date ='||g_effective_date);
685: hr_utility.trace('g_tax_unit_id ='||g_tax_unit_id);
686: pay_yepp_miss_assign_pkg.select_employee(p_payroll_action_id,
687: g_effective_date,
688: g_tax_unit_id,

Line 685: hr_utility.trace('g_tax_unit_id ='||g_tax_unit_id);

681: from pay_payroll_actions
682: where payroll_action_id = p_payroll_action_id;
683: --
684: hr_utility.trace('g_effective_date ='||g_effective_date);
685: hr_utility.trace('g_tax_unit_id ='||g_tax_unit_id);
686: pay_yepp_miss_assign_pkg.select_employee(p_payroll_action_id,
687: g_effective_date,
688: g_tax_unit_id,
689: g_session_id);

Line 697: hr_utility.trace('leaving archive_deinit');

693: DELETE FROM pay_us_rpt_totals
694: WHERE attribute1='YEAR END MISSING ASSIGNMENTS'
695: AND location_id = p_payroll_action_id;
696: --
697: hr_utility.trace('leaving archive_deinit');
698:
699: end ARCHIVE_DEINIT;
700:
701: --begin

Line 702: --hr_utility.trace_on(null,'MIS');

698:
699: end ARCHIVE_DEINIT;
700:
701: --begin
702: --hr_utility.trace_on(null,'MIS');
703: END pay_arch_missing_asg_pkg;
704: