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 77: hr_utility.set_location(l_proc, 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 126: hr_utility.trace(sqlstr);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

569: ''' and '''||to_char(g_effective_date)||'''
570: and prb.defined_balance_id = pba.defined_balance_id
571: and pba.attribute_id = '||to_char(ltr_def_bal_status(lv_count).attribute_id) ||
572: lv_ac_where||')';
573: hr_utility.trace('c_non_zero_run_balance='||c_non_zero_run_balance);
574: hr_utility.trace('hmmm');
575: open c_run_bal_or_result for c_non_zero_run_balance;
576: hr_utility.trace('hmmm');
577: fetch c_run_bal_or_result into lv_result_value;

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

570: and prb.defined_balance_id = pba.defined_balance_id
571: and pba.attribute_id = '||to_char(ltr_def_bal_status(lv_count).attribute_id) ||
572: lv_ac_where||')';
573: hr_utility.trace('c_non_zero_run_balance='||c_non_zero_run_balance);
574: hr_utility.trace('hmmm');
575: open c_run_bal_or_result for c_non_zero_run_balance;
576: hr_utility.trace('hmmm');
577: fetch c_run_bal_or_result into lv_result_value;
578: hr_utility.trace('lv_result_value_2:'||to_char(lv_result_value));

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

572: lv_ac_where||')';
573: hr_utility.trace('c_non_zero_run_balance='||c_non_zero_run_balance);
574: hr_utility.trace('hmmm');
575: open c_run_bal_or_result for c_non_zero_run_balance;
576: hr_utility.trace('hmmm');
577: fetch c_run_bal_or_result into lv_result_value;
578: hr_utility.trace('lv_result_value_2:'||to_char(lv_result_value));
579: if c_run_bal_or_result%NOTFOUND then
580: l_step := 3;

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

574: hr_utility.trace('hmmm');
575: open c_run_bal_or_result for c_non_zero_run_balance;
576: hr_utility.trace('hmmm');
577: fetch c_run_bal_or_result into lv_result_value;
578: hr_utility.trace('lv_result_value_2:'||to_char(lv_result_value));
579: if c_run_bal_or_result%NOTFOUND then
580: l_step := 3;
581: lv_result_value := 0;
582: hr_utility.trace('lv_result_value_3:'||to_char(lv_result_value));

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

578: hr_utility.trace('lv_result_value_2:'||to_char(lv_result_value));
579: if c_run_bal_or_result%NOTFOUND then
580: l_step := 3;
581: lv_result_value := 0;
582: hr_utility.trace('lv_result_value_3:'||to_char(lv_result_value));
583: end if;
584: close c_run_bal_or_result;
585: end if;
586: end loop;

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

584: close c_run_bal_or_result;
585: end if;
586: end loop;
587: else -- Run Balance Status is 'N'
588: hr_utility.trace('opened c_non_zero_run_result');
589:
590: l_step := 4;
591: c_non_zero_run_result := 'SELECT 1 FROM dual
592: WHERE EXISTS (SELECT 1

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

621: )';
622:
623: open c_run_bal_or_result for c_non_zero_run_result;
624: FETCH c_run_bal_or_result into lv_result_value;
625: hr_utility.trace('lv_result_value_4 = '||lv_result_value);
626: CLOSE c_run_bal_or_result;
627:
628: end if;
629:

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

626: CLOSE c_run_bal_or_result;
627:
628: end if;
629:
630: hr_utility.trace('lv_result_value_5:'||to_char(lv_result_value));
631:
632: l_step := 5;
633: if lv_result_value = 1 then
634: --

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

631:
632: l_step := 5;
633: if lv_result_value = 1 then
634: --
635: hr_utility.trace('lv_result_value_6:'||to_char(lv_result_value));
636: insert
637: into pay_us_rpt_totals(
638: session_id,
639: tax_unit_id,

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

652:
653:
654:
655:
656: hr_utility.trace('assignment_id = ' || l_asgid);
657: end if;
658:
659: hr_utility.trace('leaving archive_code');
660:

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

655:
656: hr_utility.trace('assignment_id = ' || l_asgid);
657: end if;
658:
659: hr_utility.trace('leaving archive_code');
660:
661: exception
662: when others then
663: hr_utility.trace(sqlcode||':'||sqlerrm);

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

659: hr_utility.trace('leaving archive_code');
660:
661: exception
662: when others then
663: hr_utility.trace(sqlcode||':'||sqlerrm);
664: raise_application_error(-20001,'Error in archive_code in Step ' || l_step);
665:
666: end ARCHIVE_CODE;
667:

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

674:
675: begin
676:
677: l_proc := g_package||'archive_deinit';
678: hr_utility.set_location(l_proc, 10);
679:
680: --
681: select effective_date,
682: pay_core_utils.get_parameter('TRANSFER_GRE',

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

685: g_tax_unit_id
686: from pay_payroll_actions
687: where payroll_action_id = p_payroll_action_id;
688: --
689: hr_utility.trace('g_effective_date ='||g_effective_date);
690: hr_utility.trace('g_tax_unit_id ='||g_tax_unit_id);
691: pay_yepp_miss_assign_pkg.select_employee(p_payroll_action_id,
692: g_effective_date,
693: g_tax_unit_id,

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

686: from pay_payroll_actions
687: where payroll_action_id = p_payroll_action_id;
688: --
689: hr_utility.trace('g_effective_date ='||g_effective_date);
690: hr_utility.trace('g_tax_unit_id ='||g_tax_unit_id);
691: pay_yepp_miss_assign_pkg.select_employee(p_payroll_action_id,
692: g_effective_date,
693: g_tax_unit_id,
694: g_session_id);

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

698: DELETE FROM pay_us_rpt_totals
699: WHERE attribute1='YEAR END MISSING ASSIGNMENTS'
700: AND location_id = p_payroll_action_id;
701: --
702: hr_utility.trace('leaving archive_deinit');
703:
704: end ARCHIVE_DEINIT;
705:
706: --begin

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

703:
704: end ARCHIVE_DEINIT;
705:
706: --begin
707: --hr_utility.trace_on(null,'MIS');
708: END pay_arch_missing_asg_pkg;
709: