DBA Data[Home] [Help]

APPS.PAY_AU_REC_DET_ARCHIVE dependencies on HR_UTILITY

Line 119: g_debug :=hr_utility.debug_enabled ;

115: l_procedure varchar2(200) ;
116:
117: begin
118:
119: g_debug :=hr_utility.debug_enabled ;
120:
121: if g_debug then
122: l_procedure := g_package||'range_code';
123: hr_utility.set_location('Entering '||l_procedure,1);

Line 123: hr_utility.set_location('Entering '||l_procedure,1);

119: g_debug :=hr_utility.debug_enabled ;
120:
121: if g_debug then
122: l_procedure := g_package||'range_code';
123: hr_utility.set_location('Entering '||l_procedure,1);
124: end if ;
125:
126: -- Archive the payroll action level data and EIT defintions.
127: -- sql string to SELECT a range of assignments eligible for archival.

Line 136: hr_utility.set_location('Leaving '||l_procedure,1000);

132: ' and p.business_group_id = pa.business_group_id' ||
133: ' order by p.person_id';
134:
135: if g_debug then
136: hr_utility.set_location('Leaving '||l_procedure,1000);
137: end if;
138:
139: end range_code;
140:

Line 177: g_debug := hr_utility.debug_enabled;

173: l_report_param_val varchar2(30);
174:
175: BEGIN
176:
177: g_debug := hr_utility.debug_enabled;
178:
179: BEGIN
180:
181: open csr_action_parameter;

Line 196: hr_utility.set_location('Range Person = True',1);

192: --
193: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
194: l_return := TRUE;
195: IF g_debug THEN
196: hr_utility.set_location('Range Person = True',1);
197: END IF;
198: ELSE
199: l_return := FALSE;
200: END IF;

Line 291: g_debug :=hr_utility.debug_enabled ;

287: /*Bug 4132149 - Modification ends here*/
288:
289: begin
290:
291: g_debug :=hr_utility.debug_enabled ;
292: if g_debug then
293: l_procedure := g_package||'initialization_code';
294: hr_utility.set_location('Entering '||l_procedure,1);
295: end if;

Line 294: hr_utility.set_location('Entering '||l_procedure,1);

290:
291: g_debug :=hr_utility.debug_enabled ;
292: if g_debug then
293: l_procedure := g_package||'initialization_code';
294: hr_utility.set_location('Entering '||l_procedure,1);
295: end if;
296:
297:
298: /*Bug 4132149 - Modification begins here*/

Line 313: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);

309: CLOSE csr_params;
310:
311:
312: if g_debug then
313: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
314: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
315: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
316: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
317: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);

Line 314: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);

310:
311:
312: if g_debug then
313: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
314: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
315: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
316: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
317: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
318: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);

Line 315: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);

311:
312: if g_debug then
313: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
314: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
315: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
316: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
317: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
318: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
319: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);

Line 316: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);

312: if g_debug then
313: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
314: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
315: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
316: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
317: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
318: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
319: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
320: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);

Line 317: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);

313: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
314: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
315: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
316: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
317: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
318: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
319: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
320: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
321: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);

Line 318: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);

314: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
315: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
316: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
317: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
318: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
319: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
320: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
321: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
322: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);

Line 319: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);

315: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
316: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
317: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
318: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
319: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
320: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
321: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
322: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
323: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);

Line 320: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);

316: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
317: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
318: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
319: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
320: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
321: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
322: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
323: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
324: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);

Line 321: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);

317: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
318: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
319: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
320: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
321: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
322: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
323: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
324: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
325: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);

Line 322: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);

318: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
319: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
320: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
321: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
322: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
323: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
324: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
325: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
326: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);

Line 323: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);

319: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
320: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
321: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
322: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
323: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
324: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
325: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
326: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
327: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/

Line 324: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);

320: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
321: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
322: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
323: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
324: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
325: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
326: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
327: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
328: end if;

Line 325: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);

321: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
322: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
323: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
324: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
325: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
326: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
327: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
328: end if;
329:

Line 326: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);

322: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
323: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
324: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
325: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
326: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
327: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
328: end if;
329:
330:

Line 327: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/

323: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
324: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
325: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
326: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
327: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
328: end if;
329:
330:
331: g_business_group_id := g_parameters.business_group_id ;

Line 359: hr_utility.set_location('Leaving '||l_procedure,1000);

355:
356: pay_au_reconciliation_pkg.populate_defined_balance_ids('Y',g_parameters.legal_employer);
357:
358: if g_debug then
359: hr_utility.set_location('Leaving '||l_procedure,1000);
360: end if;
361:
362: exception
363: when others then

Line 364: hr_utility.set_location('Error in '||l_procedure,999999);

360: end if;
361:
362: exception
363: when others then
364: hr_utility.set_location('Error in '||l_procedure,999999);
365: raise;
366: end initialization_code;
367:
368: --------------------------------------------------------------------+

Line 1420: g_debug :=hr_utility.debug_enabled ;

1416:
1417:
1418: begin
1419: i := 1;
1420: g_debug :=hr_utility.debug_enabled ;
1421:
1422: if g_debug then
1423: l_procedure := g_package||'assignment_action_code';
1424: hr_utility.set_location('Entering ' || l_procedure,1);

Line 1424: hr_utility.set_location('Entering ' || l_procedure,1);

1420: g_debug :=hr_utility.debug_enabled ;
1421:
1422: if g_debug then
1423: l_procedure := g_package||'assignment_action_code';
1424: hr_utility.set_location('Entering ' || l_procedure,1);
1425: hr_utility.set_location('Entering assignment_Action_code',302);
1426: end if;
1427:
1428: -- initialization_code to to set the global tables for EIT

Line 1425: hr_utility.set_location('Entering assignment_Action_code',302);

1421:
1422: if g_debug then
1423: l_procedure := g_package||'assignment_action_code';
1424: hr_utility.set_location('Entering ' || l_procedure,1);
1425: hr_utility.set_location('Entering assignment_Action_code',302);
1426: end if;
1427:
1428: -- initialization_code to to set the global tables for EIT
1429: -- that will be used by each thread in multi-threading.

Line 1441: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);

1437: CLOSE csr_params;
1438:
1439:
1440: if g_debug then
1441: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1442: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1443: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1444: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1445: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);

Line 1442: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);

1438:
1439:
1440: if g_debug then
1441: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1442: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1443: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1444: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1445: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1446: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);

Line 1443: hr_utility.set_location('p_end_person................= ' || p_end_person,30);

1439:
1440: if g_debug then
1441: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1442: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1443: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1444: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1445: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1446: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1447: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);

Line 1444: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);

1440: if g_debug then
1441: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1442: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1443: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1444: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1445: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1446: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1447: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1448: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);

Line 1445: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);

1441: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1442: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1443: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1444: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1445: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1446: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1447: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1448: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1449: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);

Line 1446: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);

1442: hr_utility.set_location('p_start_person..............= ' || p_start_person,30);
1443: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1444: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1445: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1446: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1447: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1448: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1449: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1450: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);

Line 1447: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);

1443: hr_utility.set_location('p_end_person................= ' || p_end_person,30);
1444: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1445: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1446: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1447: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1448: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1449: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1450: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1451: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);

Line 1448: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);

1444: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
1445: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1446: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1447: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1448: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1449: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1450: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1451: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1452: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);

Line 1449: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);

1445: hr_utility.set_location('g_parameters.payroll_id..............= ' || g_parameters.payroll_id,30);
1446: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1447: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1448: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1449: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1450: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1451: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1452: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1453: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);

Line 1450: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);

1446: hr_utility.set_location('g_parameters.org_id................= ' || g_parameters.org_id,30);
1447: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1448: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1449: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1450: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1451: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1452: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1453: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1454: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);

Line 1451: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);

1447: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
1448: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1449: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1450: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1451: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1452: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1453: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1454: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1455: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);

Line 1452: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);

1448: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
1449: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1450: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1451: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1452: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1453: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1454: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1455: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1456: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);

Line 1453: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);

1449: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
1450: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1451: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1452: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1453: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1454: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1455: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1456: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1457: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/

Line 1454: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);

1450: hr_utility.set_location('g_parameters.period_end_date.........= ' || g_parameters.period_end_date,30);
1451: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1452: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1453: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1454: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1455: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1456: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1457: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
1458: end if;

Line 1455: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);

1451: hr_utility.set_location('g_parameters.pact_id..............= ' || g_parameters.pact_id,30);
1452: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1453: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1454: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1455: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1456: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1457: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
1458: end if;
1459:

Line 1456: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);

1452: hr_utility.set_location('g_parameters.employee_type..........= '||g_parameters.employee_type,30);
1453: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1454: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1455: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1456: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1457: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
1458: end if;
1459:
1460:

Line 1457: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/

1453: hr_utility.set_location('g_parameters.sort_order1..........= '||g_parameters.sort_order_1,30);
1454: hr_utility.set_location('g_parameters.sort_order2..........= '||g_parameters.sort_order_2,30);
1455: hr_utility.set_location('g_parameters.sort_order3..........= '||g_parameters.sort_order_3,30);
1456: hr_utility.set_location('g_parameters.sort_order4..........= '||g_parameters.sort_order_4,30);
1457: hr_utility.set_location('g_parameters.delete_actions..........= '||g_parameters.delete_actions,30);/*Bug# 4142159*/
1458: end if;
1459:
1460:
1461: g_business_group_id := g_parameters.business_group_id ;

Line 1492: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);

1488: then
1489: if g_parameters.start_date is not null and g_parameters.end_date is not null
1490: then
1491: IF g_debug THEN
1492: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
1493: END IF;
1494: FOR csr_rec in rg_csr_assignment_org_period(p_payroll_action_id,
1495: p_chunk,
1496: g_parameters.employee_type,

Line 1508: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

1504: close csr_next_action_id;
1505:
1506: if g_debug then
1507:
1508: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1509: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1510: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1511: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1512:

Line 1509: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

1505:
1506: if g_debug then
1507:
1508: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1509: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1510: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1511: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1512:
1513: end if;

Line 1510: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

1506: if g_debug then
1507:
1508: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1509: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1510: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1511: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1512:
1513: end if;
1514:

Line 1511: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

1507:
1508: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1509: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1510: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1511: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1512:
1513: end if;
1514:
1515: -- Create the archive assignment actions

Line 1549: hr_utility.set_location('Leaving............Loop1 Org+Period....' || l_procedure,1000);

1545:
1546:
1547: END LOOP;/* Loop 1 */
1548: if g_debug then
1549: hr_utility.set_location('Leaving............Loop1 Org+Period....' || l_procedure,1000);
1550: end if;
1551:
1552: else
1553: IF g_debug THEN

Line 1554: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);

1550: end if;
1551:
1552: else
1553: IF g_debug THEN
1554: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
1555: END IF;
1556: FOR csr_rec in rg_csr_assignment_org_run(p_payroll_action_id,
1557: p_chunk,
1558: g_parameters.employee_type,

Line 1569: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

1565: fetch csr_next_action_id into l_next_assignment_action_id;
1566: close csr_next_action_id;
1567:
1568: if g_debug then
1569: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1570: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1571: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1572: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1573: end if;

Line 1570: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

1566: close csr_next_action_id;
1567:
1568: if g_debug then
1569: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1570: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1571: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1572: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1573: end if;
1574:

Line 1571: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

1567:
1568: if g_debug then
1569: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1570: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1571: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1572: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1573: end if;
1574:
1575: -- Create the archive assignment actions

Line 1572: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

1568: if g_debug then
1569: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1570: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1571: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1572: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1573: end if;
1574:
1575: -- Create the archive assignment actions
1576: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 1608: hr_utility.set_location('Leaving............Loop2 ,Org + Run....' || l_procedure,1000);

1604:
1605:
1606: END LOOP; /* Loop 2 */
1607: if g_debug then
1608: hr_utility.set_location('Leaving............Loop2 ,Org + Run....' || l_procedure,1000);
1609: end if;
1610: end if; /* End of Inner Organization */
1611: else /* Not Org,check for others */
1612:

Line 1618: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);

1614: then
1615: if g_parameters.start_date is not null and g_parameters.end_date is not null
1616: then
1617: IF g_debug THEN
1618: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
1619: END IF;
1620: FOR csr_rec in rg_csr_assignment_legal_period(p_payroll_action_id,
1621: p_chunk,
1622: g_parameters.employee_type,

Line 1632: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

1628: open csr_next_action_id;
1629: fetch csr_next_action_id into l_next_assignment_action_id;
1630: close csr_next_action_id;
1631: if g_debug then
1632: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1633: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1634: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1635: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1636: end if;

Line 1633: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

1629: fetch csr_next_action_id into l_next_assignment_action_id;
1630: close csr_next_action_id;
1631: if g_debug then
1632: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1633: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1634: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1635: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1636: end if;
1637:

Line 1634: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

1630: close csr_next_action_id;
1631: if g_debug then
1632: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1633: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1634: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1635: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1636: end if;
1637:
1638: -- Create the archive assignment actions

Line 1635: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

1631: if g_debug then
1632: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1633: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1634: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1635: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1636: end if;
1637:
1638: -- Create the archive assignment actions
1639: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 1671: hr_utility.set_location('Leaving............Loop3.Legal Emp + period...' || l_procedure,1000);

1667:
1668:
1669: END LOOP;/* Loop 3 */
1670: if g_debug then
1671: hr_utility.set_location('Leaving............Loop3.Legal Emp + period...' || l_procedure,1000);
1672: end if;
1673:
1674: else
1675: IF g_debug THEN

Line 1676: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);

1672: end if;
1673:
1674: else
1675: IF g_debug THEN
1676: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
1677: END IF;
1678: FOR csr_rec in rg_csr_assignment_legal_run(p_payroll_action_id,
1679: p_chunk,
1680: g_parameters.employee_type,

Line 1691: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

1687: fetch csr_next_action_id into l_next_assignment_action_id;
1688: close csr_next_action_id;
1689:
1690: if g_debug then
1691: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1692: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1693: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1694: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1695: end if;

Line 1692: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

1688: close csr_next_action_id;
1689:
1690: if g_debug then
1691: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1692: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1693: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1694: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1695: end if;
1696:

Line 1693: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

1689:
1690: if g_debug then
1691: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1692: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1693: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1694: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1695: end if;
1696:
1697: -- Create the archive assignment actions

Line 1694: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

1690: if g_debug then
1691: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1692: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1693: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1694: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1695: end if;
1696:
1697: -- Create the archive assignment actions
1698: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 1730: hr_utility.set_location('Leaving............Loop4.Legal Emp + Run...' || l_procedure,1000);

1726:
1727:
1728: END LOOP; /* Loop 4 */
1729: if g_debug then
1730: hr_utility.set_location('Leaving............Loop4.Legal Emp + Run...' || l_procedure,1000);
1731: end if;
1732: end if; /* End of Inner Legal Employer */
1733: else /* Not Org,Legal Emp Check others */
1734:

Line 1740: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);

1736: then
1737: if g_parameters.start_date is not null and g_parameters.end_date is not null
1738: then
1739: IF g_debug THEN
1740: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
1741: END IF;
1742: FOR csr_rec in rg_assignment_payroll_period(p_payroll_action_id,
1743: p_chunk,
1744: g_parameters.employee_type,

Line 1755: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

1751: fetch csr_next_action_id into l_next_assignment_action_id;
1752: close csr_next_action_id;
1753:
1754: if g_debug then
1755: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1756: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1757: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1758: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1759: end if;

Line 1756: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

1752: close csr_next_action_id;
1753:
1754: if g_debug then
1755: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1756: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1757: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1758: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1759: end if;
1760:

Line 1757: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

1753:
1754: if g_debug then
1755: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1756: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1757: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1758: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1759: end if;
1760:
1761: -- Create the archive assignment actions

Line 1758: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

1754: if g_debug then
1755: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1756: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1757: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1758: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1759: end if;
1760:
1761: -- Create the archive assignment actions
1762: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 1795: hr_utility.set_location('Leaving............Loop5 Payroll + Period....' || l_procedure,1000);

1791:
1792: END LOOP;/* Loop 5 */
1793:
1794: if g_debug then
1795: hr_utility.set_location('Leaving............Loop5 Payroll + Period....' || l_procedure,1000);
1796: end if;
1797:
1798: else
1799: IF g_debug THEN

Line 1800: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);

1796: end if;
1797:
1798: else
1799: IF g_debug THEN
1800: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
1801: END IF;
1802: FOR csr_rec in rg_csr_assignment_payroll_run(p_payroll_action_id,
1803: p_chunk,
1804: g_parameters.employee_type,

Line 1815: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

1811: fetch csr_next_action_id into l_next_assignment_action_id;
1812: close csr_next_action_id;
1813:
1814: if g_debug then
1815: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1816: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1817: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1818: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1819: end if;

Line 1816: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

1812: close csr_next_action_id;
1813:
1814: if g_debug then
1815: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1816: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1817: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1818: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1819: end if;
1820:

Line 1817: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

1813:
1814: if g_debug then
1815: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1816: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1817: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1818: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1819: end if;
1820:
1821: -- Create the archive assignment actions

Line 1818: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

1814: if g_debug then
1815: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1816: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1817: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1818: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1819: end if;
1820:
1821: -- Create the archive assignment actions
1822: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 1854: hr_utility.set_location('Leaving............Loop6 Payroll+ Run....' || l_procedure,1000);

1850:
1851:
1852: END LOOP; /* Loop 6 */
1853: if g_debug then
1854: hr_utility.set_location('Leaving............Loop6 Payroll+ Run....' || l_procedure,1000);
1855: end if;
1856: end if; /* End of Inner Payroll */
1857: else /* Not Org,Legal,Payroll check others */
1858:

Line 1864: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);

1860: then
1861: if g_parameters.start_date is not null and g_parameters.end_date is not null
1862: then
1863: IF g_debug THEN
1864: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
1865: END IF;
1866: FOR csr_rec in rg_csr_assignment_period(p_payroll_action_id,
1867: p_chunk,
1868: g_parameters.employee_type,

Line 1879: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

1875: fetch csr_next_action_id into l_next_assignment_action_id;
1876: close csr_next_action_id;
1877:
1878: if g_debug then
1879: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1880: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1881: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1882: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1883: end if;

Line 1880: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

1876: close csr_next_action_id;
1877:
1878: if g_debug then
1879: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1880: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1881: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1882: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1883: end if;
1884:

Line 1881: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

1877:
1878: if g_debug then
1879: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1880: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1881: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1882: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1883: end if;
1884:
1885: -- Create the archive assignment actions

Line 1882: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

1878: if g_debug then
1879: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1880: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1881: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1882: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1883: end if;
1884:
1885: -- Create the archive assignment actions
1886: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 1918: hr_utility.set_location('Leaving............Loop7. Asg + Period...' || l_procedure,1000);

1914:
1915:
1916: END LOOP;/* Loop 7 */
1917: if g_debug then
1918: hr_utility.set_location('Leaving............Loop7. Asg + Period...' || l_procedure,1000);
1919: end if;
1920:
1921: else
1922: IF g_debug THEN

Line 1923: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);

1919: end if;
1920:
1921: else
1922: IF g_debug THEN
1923: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
1924: END IF;
1925: FOR csr_rec in rg_csr_assignment_run(p_payroll_action_id,
1926: p_chunk,
1927: g_parameters.employee_type,

Line 1938: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

1934: fetch csr_next_action_id into l_next_assignment_action_id;
1935: close csr_next_action_id;
1936:
1937: if g_debug then
1938: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1939: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1940: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1941: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1942: end if;

Line 1939: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

1935: close csr_next_action_id;
1936:
1937: if g_debug then
1938: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1939: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1940: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1941: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1942: end if;
1943:

Line 1940: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

1936:
1937: if g_debug then
1938: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1939: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1940: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1941: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1942: end if;
1943:
1944: -- Create the archive assignment actions

Line 1941: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

1937: if g_debug then
1938: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
1939: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
1940: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
1941: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
1942: end if;
1943:
1944: -- Create the archive assignment actions
1945: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 1977: hr_utility.set_location('Leaving............Loop8.Asg + Run...' || l_procedure,1000);

1973:
1974:
1975: END LOOP; /* Loop 8 */
1976: if g_debug then
1977: hr_utility.set_location('Leaving............Loop8.Asg + Run...' || l_procedure,1000);
1978: end if;
1979: end if; /* End of Inner Assignment */
1980:
1981: else

Line 1988: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);

1984:
1985: if g_parameters.start_date is not null and g_parameters.end_date is not null
1986: then
1987: IF g_debug THEN
1988: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
1989: END IF;
1990: FOR csr_rec in rg_assignment_default_period(p_payroll_action_id,
1991: p_chunk,
1992: g_parameters.employee_type,

Line 2002: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

1998: fetch csr_next_action_id into l_next_assignment_action_id;
1999: close csr_next_action_id;
2000:
2001: if g_debug then
2002: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2003: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2004: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2005: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2006: end if;

Line 2003: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

1999: close csr_next_action_id;
2000:
2001: if g_debug then
2002: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2003: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2004: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2005: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2006: end if;
2007:

Line 2004: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

2000:
2001: if g_debug then
2002: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2003: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2004: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2005: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2006: end if;
2007:
2008: -- Create the archive assignment actions

Line 2005: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

2001: if g_debug then
2002: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2003: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2004: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2005: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2006: end if;
2007:
2008: -- Create the archive assignment actions
2009: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 2041: hr_utility.set_location('Leaving............Loop9..Default + Period..' || l_procedure,1000);

2037:
2038:
2039: END LOOP;/* Loop 9 */
2040: if g_debug then
2041: hr_utility.set_location('Leaving............Loop9..Default + Period..' || l_procedure,1000);
2042: end if;
2043:
2044: else
2045: IF g_debug THEN

Line 2046: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);

2042: end if;
2043:
2044: else
2045: IF g_debug THEN
2046: hr_utility.set_location('Using Range Person Cursor for fetching assignments',30);
2047: END IF;
2048: FOR csr_rec in rg_csr_assignment_default_run(p_payroll_action_id,
2049: p_chunk,
2050: g_parameters.employee_type,

Line 2060: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

2056: fetch csr_next_action_id into l_next_assignment_action_id;
2057: close csr_next_action_id;
2058:
2059: if g_debug then
2060: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2061: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2062: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2063: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2064: end if;

Line 2061: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

2057: close csr_next_action_id;
2058:
2059: if g_debug then
2060: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2061: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2062: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2063: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2064: end if;
2065:

Line 2062: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

2058:
2059: if g_debug then
2060: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2061: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2062: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2063: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2064: end if;
2065:
2066: -- Create the archive assignment actions

Line 2063: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

2059: if g_debug then
2060: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2061: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2062: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2063: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2064: end if;
2065:
2066: -- Create the archive assignment actions
2067: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 2099: hr_utility.set_location('Leaving............Loop10 Default + Run....' || l_procedure,1000);

2095:
2096:
2097: END LOOP; /* Loop 10 */
2098: if g_debug then
2099: hr_utility.set_location('Leaving............Loop10 Default + Run....' || l_procedure,1000);
2100: end if;
2101: end if; /* End of Inner Default */
2102:
2103:

Line 2130: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

2126: close csr_next_action_id;
2127:
2128: if g_debug then
2129:
2130: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2131: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2132: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2133: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2134:

Line 2131: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

2127:
2128: if g_debug then
2129:
2130: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2131: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2132: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2133: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2134:
2135: end if;

Line 2132: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

2128: if g_debug then
2129:
2130: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2131: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2132: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2133: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2134:
2135: end if;
2136:

Line 2133: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

2129:
2130: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2131: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2132: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2133: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2134:
2135: end if;
2136:
2137:

Line 2173: hr_utility.set_location('Leaving............Loop1 Org+Period....' || l_procedure,1000);

2169:
2170:
2171: END LOOP;/* Loop 1 */
2172: if g_debug then
2173: hr_utility.set_location('Leaving............Loop1 Org+Period....' || l_procedure,1000);
2174: end if;
2175:
2176: else
2177: FOR csr_rec in csr_assignment_org_run(p_payroll_action_id,

Line 2191: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

2187: fetch csr_next_action_id into l_next_assignment_action_id;
2188: close csr_next_action_id;
2189:
2190: if g_debug then
2191: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2192: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2193: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2194: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2195: end if;

Line 2192: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

2188: close csr_next_action_id;
2189:
2190: if g_debug then
2191: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2192: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2193: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2194: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2195: end if;
2196:

Line 2193: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

2189:
2190: if g_debug then
2191: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2192: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2193: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2194: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2195: end if;
2196:
2197: -- Create the archive assignment actions

Line 2194: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

2190: if g_debug then
2191: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2192: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2193: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2194: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2195: end if;
2196:
2197: -- Create the archive assignment actions
2198: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 2230: hr_utility.set_location('Leaving............Loop2 ,Org + Run....' || l_procedure,1000);

2226:
2227:
2228: END LOOP; /* Loop 2 */
2229: if g_debug then
2230: hr_utility.set_location('Leaving............Loop2 ,Org + Run....' || l_procedure,1000);
2231: end if;
2232: end if; /* End of Inner Organization */
2233: else /* Not Org,check for others */
2234:

Line 2252: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

2248: open csr_next_action_id;
2249: fetch csr_next_action_id into l_next_assignment_action_id;
2250: close csr_next_action_id;
2251: if g_debug then
2252: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2253: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2254: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2255: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2256: end if;

Line 2253: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

2249: fetch csr_next_action_id into l_next_assignment_action_id;
2250: close csr_next_action_id;
2251: if g_debug then
2252: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2253: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2254: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2255: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2256: end if;
2257:

Line 2254: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

2250: close csr_next_action_id;
2251: if g_debug then
2252: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2253: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2254: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2255: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2256: end if;
2257:
2258: -- Create the archive assignment actions

Line 2255: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

2251: if g_debug then
2252: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2253: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2254: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2255: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2256: end if;
2257:
2258: -- Create the archive assignment actions
2259: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 2291: hr_utility.set_location('Leaving............Loop3.Legal Emp + period...' || l_procedure,1000);

2287:
2288:
2289: END LOOP;/* Loop 3 */
2290: if g_debug then
2291: hr_utility.set_location('Leaving............Loop3.Legal Emp + period...' || l_procedure,1000);
2292: end if;
2293:
2294: else
2295: FOR csr_rec in csr_assignment_legal_run(p_payroll_action_id,

Line 2309: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

2305: fetch csr_next_action_id into l_next_assignment_action_id;
2306: close csr_next_action_id;
2307:
2308: if g_debug then
2309: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2310: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2311: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2312: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2313: end if;

Line 2310: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

2306: close csr_next_action_id;
2307:
2308: if g_debug then
2309: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2310: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2311: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2312: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2313: end if;
2314:

Line 2311: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

2307:
2308: if g_debug then
2309: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2310: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2311: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2312: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2313: end if;
2314:
2315: -- Create the archive assignment actions

Line 2312: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

2308: if g_debug then
2309: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2310: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2311: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2312: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2313: end if;
2314:
2315: -- Create the archive assignment actions
2316: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 2348: hr_utility.set_location('Leaving............Loop4.Legal Emp + Run...' || l_procedure,1000);

2344:
2345:
2346: END LOOP; /* Loop 4 */
2347: if g_debug then
2348: hr_utility.set_location('Leaving............Loop4.Legal Emp + Run...' || l_procedure,1000);
2349: end if;
2350: end if; /* End of Inner Legal Employer */
2351: else /* Not Org,Legal Emp Check others */
2352:

Line 2371: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

2367: fetch csr_next_action_id into l_next_assignment_action_id;
2368: close csr_next_action_id;
2369:
2370: if g_debug then
2371: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2372: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2373: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2374: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2375: end if;

Line 2372: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

2368: close csr_next_action_id;
2369:
2370: if g_debug then
2371: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2372: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2373: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2374: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2375: end if;
2376:

Line 2373: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

2369:
2370: if g_debug then
2371: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2372: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2373: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2374: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2375: end if;
2376:
2377: -- Create the archive assignment actions

Line 2374: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

2370: if g_debug then
2371: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2372: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2373: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2374: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2375: end if;
2376:
2377: -- Create the archive assignment actions
2378: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 2411: hr_utility.set_location('Leaving............Loop5 Payroll + Period....' || l_procedure,1000);

2407:
2408: END LOOP;/* Loop 5 */
2409:
2410: if g_debug then
2411: hr_utility.set_location('Leaving............Loop5 Payroll + Period....' || l_procedure,1000);
2412: end if;
2413:
2414: else
2415: FOR csr_rec in csr_assignment_payroll_run(p_payroll_action_id,

Line 2429: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

2425: fetch csr_next_action_id into l_next_assignment_action_id;
2426: close csr_next_action_id;
2427:
2428: if g_debug then
2429: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2430: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2431: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2432: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2433: end if;

Line 2430: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

2426: close csr_next_action_id;
2427:
2428: if g_debug then
2429: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2430: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2431: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2432: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2433: end if;
2434:

Line 2431: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

2427:
2428: if g_debug then
2429: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2430: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2431: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2432: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2433: end if;
2434:
2435: -- Create the archive assignment actions

Line 2432: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

2428: if g_debug then
2429: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2430: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2431: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2432: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2433: end if;
2434:
2435: -- Create the archive assignment actions
2436: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 2468: hr_utility.set_location('Leaving............Loop6 Payroll+ Run....' || l_procedure,1000);

2464:
2465:
2466: END LOOP; /* Loop 6 */
2467: if g_debug then
2468: hr_utility.set_location('Leaving............Loop6 Payroll+ Run....' || l_procedure,1000);
2469: end if;
2470: end if; /* End of Inner Payroll */
2471: else /* Not Org,Legal,Payroll check others */
2472:

Line 2491: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

2487: fetch csr_next_action_id into l_next_assignment_action_id;
2488: close csr_next_action_id;
2489:
2490: if g_debug then
2491: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2492: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2493: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2494: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2495: end if;

Line 2492: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

2488: close csr_next_action_id;
2489:
2490: if g_debug then
2491: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2492: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2493: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2494: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2495: end if;
2496:

Line 2493: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

2489:
2490: if g_debug then
2491: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2492: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2493: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2494: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2495: end if;
2496:
2497: -- Create the archive assignment actions

Line 2494: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

2490: if g_debug then
2491: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2492: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2493: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2494: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2495: end if;
2496:
2497: -- Create the archive assignment actions
2498: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 2530: hr_utility.set_location('Leaving............Loop7. Asg + Period...' || l_procedure,1000);

2526:
2527:
2528: END LOOP;/* Loop 7 */
2529: if g_debug then
2530: hr_utility.set_location('Leaving............Loop7. Asg + Period...' || l_procedure,1000);
2531: end if;
2532:
2533: else
2534: FOR csr_rec in csr_assignment_run(p_payroll_action_id,

Line 2548: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

2544: fetch csr_next_action_id into l_next_assignment_action_id;
2545: close csr_next_action_id;
2546:
2547: if g_debug then
2548: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2549: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2550: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2551: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2552: end if;

Line 2549: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

2545: close csr_next_action_id;
2546:
2547: if g_debug then
2548: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2549: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2550: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2551: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2552: end if;
2553:

Line 2550: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

2546:
2547: if g_debug then
2548: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2549: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2550: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2551: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2552: end if;
2553:
2554: -- Create the archive assignment actions

Line 2551: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

2547: if g_debug then
2548: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2549: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2550: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2551: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2552: end if;
2553:
2554: -- Create the archive assignment actions
2555: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 2587: hr_utility.set_location('Leaving............Loop8.Asg + Run...' || l_procedure,1000);

2583:
2584:
2585: END LOOP; /* Loop 8 */
2586: if g_debug then
2587: hr_utility.set_location('Leaving............Loop8.Asg + Run...' || l_procedure,1000);
2588: end if;
2589: end if; /* End of Inner Assignment */
2590:
2591: else

Line 2610: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

2606: fetch csr_next_action_id into l_next_assignment_action_id;
2607: close csr_next_action_id;
2608:
2609: if g_debug then
2610: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2611: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2612: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2613: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2614: end if;

Line 2611: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

2607: close csr_next_action_id;
2608:
2609: if g_debug then
2610: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2611: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2612: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2613: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2614: end if;
2615:

Line 2612: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

2608:
2609: if g_debug then
2610: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2611: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2612: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2613: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2614: end if;
2615:
2616: -- Create the archive assignment actions

Line 2613: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

2609: if g_debug then
2610: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2611: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2612: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2613: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2614: end if;
2615:
2616: -- Create the archive assignment actions
2617: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 2649: hr_utility.set_location('Leaving............Loop9..Default + Period..' || l_procedure,1000);

2645:
2646:
2647: END LOOP;/* Loop 9 */
2648: if g_debug then
2649: hr_utility.set_location('Leaving............Loop9..Default + Period..' || l_procedure,1000);
2650: end if;
2651:
2652: else
2653: FOR csr_rec in csr_assignment_default_run(p_payroll_action_id,

Line 2666: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);

2662: fetch csr_next_action_id into l_next_assignment_action_id;
2663: close csr_next_action_id;
2664:
2665: if g_debug then
2666: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2667: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2668: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2669: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2670: end if;

Line 2667: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);

2663: close csr_next_action_id;
2664:
2665: if g_debug then
2666: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2667: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2668: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2669: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2670: end if;
2671:

Line 2668: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);

2664:
2665: if g_debug then
2666: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2667: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2668: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2669: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2670: end if;
2671:
2672: -- Create the archive assignment actions

Line 2669: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);

2665: if g_debug then
2666: hr_utility.set_location('p_payroll_action_id.........= '||p_payroll_action_id,20);
2667: hr_utility.set_location('l_next_assignment_action_id.= '||l_next_assignment_action_id,20);
2668: hr_utility.set_location('csr_rec.assignment_id.......= '||csr_rec.assignment_id,20);
2669: hr_utility.set_location('csr_rec.tax_unit_id.........= '||csr_rec.tax_unit_id,20);
2670: end if;
2671:
2672: -- Create the archive assignment actions
2673: hr_nonrun_asact.insact(l_next_assignment_action_id, csr_rec.assignment_id, p_payroll_action_id, p_chunk, csr_rec.tax_unit_id);

Line 2705: hr_utility.set_location('Leaving............Loop10 Default + Run....' || l_procedure,1000);

2701:
2702:
2703: END LOOP; /* Loop 10 */
2704: if g_debug then
2705: hr_utility.set_location('Leaving............Loop10 Default + Run....' || l_procedure,1000);
2706: end if;
2707: end if; /* End of Inner Default */
2708:
2709:

Line 2719: hr_utility.set_location('Error in '||l_procedure,999999);

2715: END IF;
2716:
2717: exception
2718: when others then
2719: hr_utility.set_location('Error in '||l_procedure,999999);
2720: raise;
2721: end assignment_action_code;
2722:
2723: --------------------------------------------------------------------+

Line 3040: g_debug :=hr_utility.debug_enabled ;

3036: END get_fin_year_code;
3037:
3038: begin
3039:
3040: g_debug :=hr_utility.debug_enabled ;
3041: l_balance_flag := 'Y' ; /* Bug 3627293 - Balances have to be stored */
3042: l_YTD_GROSS_EARNINGS :=0 ;
3043: l_YTD_NON_TAXABLE_EARNINGS :=0 ;
3044: l_YTD_PRE_TAX_DEDUCTIONS :=0 ;

Line 3054: hr_utility.set_location('Entering '||l_procedure,1);

3050: l_YTD_EMPLOYER_CHARGES :=0 ;
3051:
3052: if g_debug then
3053: l_procedure := g_package||'archive_code';
3054: hr_utility.set_location('Entering '||l_procedure,1);
3055: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
3056: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
3057: end if;
3058:

Line 3055: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);

3051:
3052: if g_debug then
3053: l_procedure := g_package||'archive_code';
3054: hr_utility.set_location('Entering '||l_procedure,1);
3055: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
3056: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
3057: end if;
3058:
3059: OPEN csr_get_data(p_assignment_action_id);

Line 3056: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);

3052: if g_debug then
3053: l_procedure := g_package||'archive_code';
3054: hr_utility.set_location('Entering '||l_procedure,1);
3055: hr_utility.set_location('p_assignment_action_id......= '|| p_assignment_action_id,10);
3056: hr_utility.set_location('p_effective_date............= '|| to_char(p_effective_date,'DD-MON-YYYY'),10);
3057: end if;
3058:
3059: OPEN csr_get_data(p_assignment_action_id);
3060: FETCH csr_get_data into l_ass_act_id, l_tax_unit_id, l_assignment_id,l_action_sequence;

Line 3064: hr_utility.set_location('l_ass_act_id......= '|| l_ass_act_id,10);

3060: FETCH csr_get_data into l_ass_act_id, l_tax_unit_id, l_assignment_id,l_action_sequence;
3061: CLOSE csr_get_data;
3062:
3063: if g_debug then
3064: hr_utility.set_location('l_ass_act_id......= '|| l_ass_act_id,10);
3065: hr_utility.set_location('l_tax_unit_id............= '|| l_tax_unit_id,10);
3066: hr_utility.set_location('l_assignment_id......= '|| l_assignment_id,10);
3067: end if;
3068:

Line 3065: hr_utility.set_location('l_tax_unit_id............= '|| l_tax_unit_id,10);

3061: CLOSE csr_get_data;
3062:
3063: if g_debug then
3064: hr_utility.set_location('l_ass_act_id......= '|| l_ass_act_id,10);
3065: hr_utility.set_location('l_tax_unit_id............= '|| l_tax_unit_id,10);
3066: hr_utility.set_location('l_assignment_id......= '|| l_assignment_id,10);
3067: end if;
3068:
3069: FOR csr_rec in c_employee_details(g_business_group_id, l_assignment_id,g_end_date,g_start_date) --Bug#3662449

Line 3066: hr_utility.set_location('l_assignment_id......= '|| l_assignment_id,10);

3062:
3063: if g_debug then
3064: hr_utility.set_location('l_ass_act_id......= '|| l_ass_act_id,10);
3065: hr_utility.set_location('l_tax_unit_id............= '|| l_tax_unit_id,10);
3066: hr_utility.set_location('l_assignment_id......= '|| l_assignment_id,10);
3067: end if;
3068:
3069: FOR csr_rec in c_employee_details(g_business_group_id, l_assignment_id,g_end_date,g_start_date) --Bug#3662449
3070: LOOP

Line 3073: hr_utility.set_location('csr_rec.full_name............= '|| csr_rec.full_name,10);

3069: FOR csr_rec in c_employee_details(g_business_group_id, l_assignment_id,g_end_date,g_start_date) --Bug#3662449
3070: LOOP
3071:
3072: if g_debug then
3073: hr_utility.set_location('csr_rec.full_name............= '|| csr_rec.full_name,10);
3074: end if;
3075:
3076: IF (NVL(g_prev_assignment_id,0) <> csr_rec.assignment_id) THEN
3077:

Line 3158: hr_utility.set_location('g_prev_assignment_id......= '|| g_prev_assignment_id,10);

3154:
3155: /*Bug 4040688 - end of modification*/
3156:
3157: if g_debug then
3158: hr_utility.set_location('g_prev_assignment_id......= '|| g_prev_assignment_id,10);
3159: hr_utility.set_location('g_arc_payroll_action_id......= '|| g_arc_payroll_action_id,20);
3160: hr_utility.set_location('l_max_asg_action_id......= '|| l_max_asg_action_id,20);
3161: end if;
3162:

Line 3159: hr_utility.set_location('g_arc_payroll_action_id......= '|| g_arc_payroll_action_id,20);

3155: /*Bug 4040688 - end of modification*/
3156:
3157: if g_debug then
3158: hr_utility.set_location('g_prev_assignment_id......= '|| g_prev_assignment_id,10);
3159: hr_utility.set_location('g_arc_payroll_action_id......= '|| g_arc_payroll_action_id,20);
3160: hr_utility.set_location('l_max_asg_action_id......= '|| l_max_asg_action_id,20);
3161: end if;
3162:
3163: -- Archive employee details

Line 3160: hr_utility.set_location('l_max_asg_action_id......= '|| l_max_asg_action_id,20);

3156:
3157: if g_debug then
3158: hr_utility.set_location('g_prev_assignment_id......= '|| g_prev_assignment_id,10);
3159: hr_utility.set_location('g_arc_payroll_action_id......= '|| g_arc_payroll_action_id,20);
3160: hr_utility.set_location('l_max_asg_action_id......= '|| l_max_asg_action_id,20);
3161: end if;
3162:
3163: -- Archive employee details
3164: /* Bug 3953702 - Archived the Grade Name details into pay_action_information */

Line 3424: g_debug :=hr_utility.debug_enabled ;

3420:
3421: Begin
3422: l_count :=0;
3423: ps_request_id :=-1;
3424: g_debug :=hr_utility.debug_enabled ;
3425:
3426: if g_debug then
3427: l_procedure := g_package||' spawn_archive_reports';
3428: hr_utility.set_location('Entering '||l_procedure,999);

Line 3428: hr_utility.set_location('Entering '||l_procedure,999);

3424: g_debug :=hr_utility.debug_enabled ;
3425:
3426: if g_debug then
3427: l_procedure := g_package||' spawn_archive_reports';
3428: hr_utility.set_location('Entering '||l_procedure,999);
3429: end if;
3430:
3431: -- Set User Parameters for Report.
3432:

Line 3463: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);

3459:
3460:
3461:
3462: if g_debug then
3463: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
3464: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
3465: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
3466: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3467: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);

Line 3464: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);

3460:
3461:
3462: if g_debug then
3463: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
3464: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
3465: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
3466: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3467: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3468: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);

Line 3465: hr_utility.set_location('in org_id '||l_parameters.org_id,2);

3461:
3462: if g_debug then
3463: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
3464: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
3465: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
3466: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3467: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3468: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3469: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);

Line 3466: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);

3462: if g_debug then
3463: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
3464: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
3465: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
3466: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3467: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3468: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3469: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3470: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);

Line 3467: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);

3463: hr_utility.set_location('payroll_parameters.action '||p_payroll_action_id,0);
3464: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
3465: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
3466: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3467: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3468: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3469: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3470: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3471: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);

Line 3468: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);

3464: hr_utility.set_location('in BG_ID '||l_parameters.business_group_id,1);
3465: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
3466: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3467: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3468: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3469: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3470: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3471: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3472: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);

Line 3469: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);

3465: hr_utility.set_location('in org_id '||l_parameters.org_id,2);
3466: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3467: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3468: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3469: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3470: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3471: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3472: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3473: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);

Line 3470: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);

3466: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3467: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3468: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3469: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3470: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3471: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3472: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3473: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3474: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);

Line 3471: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);

3467: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3468: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3469: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3470: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3471: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3472: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3473: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3474: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3475: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);

Line 3472: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);

3468: hr_utility.set_location('in archive start date '||to_char(l_parameters.start_date,'YYYY/MM/DD'),5);
3469: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3470: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3471: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3472: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3473: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3474: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3475: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3476: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);

Line 3473: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);

3469: hr_utility.set_location('in archive end date '||to_char(l_parameters.end_date,'YYYY/MM/DD'),6);
3470: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3471: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3472: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3473: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3474: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3475: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3476: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3477: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);

Line 3474: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);

3470: hr_utility.set_location('in pact_id '||l_parameters.pact_id,7);
3471: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3472: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3473: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3474: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3475: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3476: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3477: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3478: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);

Line 3475: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);

3471: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3472: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3473: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3474: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3475: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3476: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3477: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3478: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3479: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);

Line 3476: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);

3472: hr_utility.set_location('in PERIOD END DATE '||to_char(l_parameters.period_end_date,'YYYY/MM/DD'),9);
3473: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3474: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3475: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3476: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3477: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3478: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3479: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
3480: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);

Line 3477: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);

3473: hr_utility.set_location('in YTD totals '||l_parameters.ytd_totals,10);
3474: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3475: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3476: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3477: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3478: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3479: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
3480: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
3481: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/

Line 3478: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);

3474: hr_utility.set_location('in zero records'||l_parameters.zero_records,11);
3475: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3476: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3477: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3478: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3479: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
3480: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
3481: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
3482: hr_utility.set_location('in Output Type '||l_parameters.p_output_type,20); /*Bug# 6939263 */

Line 3479: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);

3475: hr_utility.set_location('in Negative records'||l_parameters.negative_records,12);
3476: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3477: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3478: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3479: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
3480: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
3481: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
3482: hr_utility.set_location('in Output Type '||l_parameters.p_output_type,20); /*Bug# 6939263 */
3483: end if;

Line 3480: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);

3476: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3477: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3478: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3479: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
3480: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
3481: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
3482: hr_utility.set_location('in Output Type '||l_parameters.p_output_type,20); /*Bug# 6939263 */
3483: end if;
3484:

Line 3481: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/

3477: hr_utility.set_location('in sort order 1'||l_parameters.sort_order_1,15);
3478: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3479: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
3480: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
3481: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
3482: hr_utility.set_location('in Output Type '||l_parameters.p_output_type,20); /*Bug# 6939263 */
3483: end if;
3484:
3485: if g_debug then

Line 3482: hr_utility.set_location('in Output Type '||l_parameters.p_output_type,20); /*Bug# 6939263 */

3478: hr_utility.set_location('in sort order 2'||l_parameters.sort_order_2,16);
3479: hr_utility.set_location('in sort order 3'||l_parameters.sort_order_3,17);
3480: hr_utility.set_location('in sort order 4'||l_parameters.sort_order_4,18);
3481: hr_utility.set_location('in delete action'||l_parameters.delete_actions,19); /*Bug# 4142159*/
3482: hr_utility.set_location('in Output Type '||l_parameters.p_output_type,20); /*Bug# 6939263 */
3483: end if;
3484:
3485: if g_debug then
3486: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);

Line 3486: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);

3482: hr_utility.set_location('in Output Type '||l_parameters.p_output_type,20); /*Bug# 6939263 */
3483: end if;
3484:
3485: if g_debug then
3486: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);
3487:
3488: hr_utility.set_location('Before calling report',24);
3489: end if;
3490:

Line 3488: hr_utility.set_location('Before calling report',24);

3484:
3485: if g_debug then
3486: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);
3487:
3488: hr_utility.set_location('Before calling report',24);
3489: end if;
3490:
3491: OPEN csr_get_print_options(p_payroll_action_id);
3492: FETCH csr_get_print_options INTO rec_print_options;

Line 3506: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,25);

3502: save_output => hr_general.char_to_bool(rec_print_options.save_output),
3503: print_together => l_print_together);
3504: -- Submit report
3505: if g_debug then
3506: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,25);
3507: end if;
3508:
3509: ps_request_id := fnd_request.submit_request
3510: ('PAY',

Line 3550: hr_utility.set_location('After calling report',24);

3546: NULL, NULL, NULL, NULL, NULL, NULL,
3547: NULL, NULL, NULL, NULL
3548: );
3549: if g_debug then
3550: hr_utility.set_location('After calling report',24);
3551: end if;
3552:
3553:
3554:

Line 3612: g_debug := hr_utility.debug_enabled;

3608: AND prrv.input_value_id = c_input_value_id;
3609:
3610: BEGIN
3611:
3612: g_debug := hr_utility.debug_enabled;
3613:
3614: /* Bug 5987877 - Added Check for Multiple Hours Input
3615: If Input Name = "Hours", return run result for it
3616: else sum the run results for all "H_" UOM type.

Line 3690: g_debug := hr_utility.debug_enabled;

3686: AND prrv.input_value_id = c_input_value_id;
3687:
3688: BEGIN
3689:
3690: g_debug := hr_utility.debug_enabled;
3691:
3692: if g_debug then
3693: hr_utility.trace('Entering get_element_payment_rate');
3694: end if;

Line 3693: hr_utility.trace('Entering get_element_payment_rate');

3689:
3690: g_debug := hr_utility.debug_enabled;
3691:
3692: if g_debug then
3693: hr_utility.trace('Entering get_element_payment_rate');
3694: end if;
3695:
3696: OPEN get_rate_input_value(p_element_type_id,p_effective_date);
3697: FETCH get_rate_input_value INTO l_input_value_id;

Line 3710: hr_utility.trace('l_result is ' || l_result);

3706:
3707: /* Avoid Divide by Zero Errors when used for computing Rate, Report Hours and Rate as Null */
3708:
3709: if g_debug then
3710: hr_utility.trace('l_result is ' || l_result);
3711: end if;
3712:
3713: IF l_result = 0
3714: THEN

Line 3720: hr_utility.trace('Leaving get_element_payment_rate');

3716: END IF;
3717:
3718:
3719: if g_debug then
3720: hr_utility.trace('Leaving get_element_payment_rate');
3721: end if;
3722:
3723: RETURN l_result;
3724: END get_element_payment_rate;