APPS.PAY_CORE_PAYSLIP_UTILS dependencies on HR_UTILITY

Line 29: hr_utility.set_location('Entering ' || l_proc,10);

25: l_proc VARCHAR2(50) := g_package || 'get_parameters';
26:
27: BEGIN
28:
29: hr_utility.set_location('Entering ' || l_proc,10);
30:
31: hr_utility.set_location('Step ' || l_proc,20);
32: hr_utility.set_location('p_token_name = ' || p_token_name,20);
33:

Line 31: hr_utility.set_location('Step ' || l_proc,20);

27: BEGIN
28:
29: hr_utility.set_location('Entering ' || l_proc,10);
30:
31: hr_utility.set_location('Step ' || l_proc,20);
32: hr_utility.set_location('p_token_name = ' || p_token_name,20);
33:
34: OPEN csr_parameter_info(p_payroll_action_id,
35: p_token_name);

Line 32: hr_utility.set_location('p_token_name = ' || p_token_name,20);

28:
29: hr_utility.set_location('Entering ' || l_proc,10);
30:
31: hr_utility.set_location('Step ' || l_proc,20);
32: hr_utility.set_location('p_token_name = ' || p_token_name,20);
33:
34: OPEN csr_parameter_info(p_payroll_action_id,
35: p_token_name);
36:

Line 54: hr_utility.set_location('l_token_value = ' || l_token_value,20);

50: p_token_value := l_token_value;
51:
52: END IF;
53:
54: hr_utility.set_location('l_token_value = ' || l_token_value,20);
55: hr_utility.set_location('Leaving ' || l_proc,30);
56:
57: END get_parameters;
58:

Line 55: hr_utility.set_location('Leaving ' || l_proc,30);

51:
52: END IF;
53:
54: hr_utility.set_location('l_token_value = ' || l_token_value,20);
55: hr_utility.set_location('Leaving ' || l_proc,30);
56:
57: END get_parameters;
58:
59: /*

Line 78: hr_utility.set_location('Entering ' || l_proc,10);

74: l_proc CONSTANT VARCHAR2(50):= g_package||'range_cursor';
75: -- vars for constructing the sqlstr
76: BEGIN
77:
78: hr_utility.set_location('Entering ' || l_proc,10);
79:
80: sqlstr := 'SELECT DISTINCT person_id
81: FROM per_people_f ppf,
82: pay_payroll_actions ppa

Line 87: hr_utility.set_location('Leaving ' || l_proc,40);

83: WHERE ppa.payroll_action_id = :payroll_action_id
84: AND ppa.business_group_id +0 = ppf.business_group_id
85: ORDER BY ppf.person_id';
86:
87: hr_utility.set_location('Leaving ' || l_proc,40);
88:
89: END range_cursor;
90:
91: /*

Line 167: hr_utility.set_location('Entering ' || l_proc,10);

163: l_proc VARCHAR2(50) := g_package||'action_creation';
164:
165: BEGIN
166:
167: hr_utility.set_location('Entering ' || l_proc,10);
168:
169: get_parameters (
170: p_payroll_action_id => pactid
171: , p_token_name => 'PAYROLL'

Line 189: hr_utility.set_location('Step ' || l_proc,20);

185: p_payroll_action_id => pactid
186: , p_token_name => 'END_DATE'
187: , p_token_value => l_end_date);
188:
189: hr_utility.set_location('Step ' || l_proc,20);
190: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
191: hr_utility.set_location('l_start_date = ' || l_start_date,20);
192: hr_utility.set_location('l_end_date = ' || l_end_date,20);
193:

Line 190: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);

186: , p_token_name => 'END_DATE'
187: , p_token_value => l_end_date);
188:
189: hr_utility.set_location('Step ' || l_proc,20);
190: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
191: hr_utility.set_location('l_start_date = ' || l_start_date,20);
192: hr_utility.set_location('l_end_date = ' || l_end_date,20);
193:
194: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');

Line 191: hr_utility.set_location('l_start_date = ' || l_start_date,20);

187: , p_token_value => l_end_date);
188:
189: hr_utility.set_location('Step ' || l_proc,20);
190: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
191: hr_utility.set_location('l_start_date = ' || l_start_date,20);
192: hr_utility.set_location('l_end_date = ' || l_end_date,20);
193:
194: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
195: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');

Line 192: hr_utility.set_location('l_end_date = ' || l_end_date,20);

188:
189: hr_utility.set_location('Step ' || l_proc,20);
190: hr_utility.set_location('l_payroll_id = ' || l_payroll_id,20);
191: hr_utility.set_location('l_start_date = ' || l_start_date,20);
192: hr_utility.set_location('l_end_date = ' || l_end_date,20);
193:
194: l_canonical_start_date := TO_DATE(l_start_date,'yyyy/mm/dd');
195: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
196:

Line 224: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);

220:
221: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
222: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
223:
224: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
225: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
226:
227: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
228:

Line 225: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);

221: -- CREATE THE ARCHIVE TO PAYROLL MASTER ASSIGNMENT ACTION INTERLOCK AND
222: -- THE ARCHIVE TO PREPAYMENT ASSIGNMENT ACTION INTERLOCK
223:
224: hr_utility.set_location('creating lock1 ' || l_actid || ' to ' || csr_rec.run_action_id,20);
225: hr_utility.set_location('creating lock2 ' || l_actid || ' to ' || csr_rec.prepaid_action_id,20);
226:
227: hr_nonrun_asact.insint(l_actid,csr_rec.prepaid_action_id);
228:
229: END IF;

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

233: l_prepay_action_id := csr_rec.prepaid_action_id;
234:
235: END LOOP;
236:
237: hr_utility.set_location('Leaving ' || l_proc,20);
238:
239: END action_creation;
240:
241: function get_max_nor_act_seq(p_payroll_action_id in number,

Line 391: hr_utility.set_location('Entering '|| l_proc,10);

387: l_pactid pay_assignment_actions.payroll_action_id%type;
388:
389: BEGIN
390:
391: hr_utility.set_location('Entering '|| l_proc,10);
392:
393: hr_utility.set_location('Step '|| l_proc,20);
394: hr_utility.set_location('p_assactid = ' || p_assactid,20);
395:

Line 393: hr_utility.set_location('Step '|| l_proc,20);

389: BEGIN
390:
391: hr_utility.set_location('Entering '|| l_proc,10);
392:
393: hr_utility.set_location('Step '|| l_proc,20);
394: hr_utility.set_location('p_assactid = ' || p_assactid,20);
395:
396: -- retrieve the chunk number for the current assignment action
397:

Line 394: hr_utility.set_location('p_assactid = ' || p_assactid,20);

390:
391: hr_utility.set_location('Entering '|| l_proc,10);
392:
393: hr_utility.set_location('Step '|| l_proc,20);
394: hr_utility.set_location('p_assactid = ' || p_assactid,20);
395:
396: -- retrieve the chunk number for the current assignment action
397:
398: SELECT paa.chunk_number,

Line 412: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||

408: FOR csr_rec IN csr_assignment_actions(p_assactid)
409:
410: LOOP
411:
412: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||
413: csr_rec.master_assignment_action_id,20);
414: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' ||
415: csr_rec.pre_assignment_action_id,20);
416: hr_utility.set_location('csr_rec.assignment_id = ' ||

Line 414: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' ||

410: LOOP
411:
412: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||
413: csr_rec.master_assignment_action_id,20);
414: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' ||
415: csr_rec.pre_assignment_action_id,20);
416: hr_utility.set_location('csr_rec.assignment_id = ' ||
417: csr_rec.assignment_id,20);
418: hr_utility.set_location('csr_rec.date_earned = ' ||

Line 416: hr_utility.set_location('csr_rec.assignment_id = ' ||

412: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||
413: csr_rec.master_assignment_action_id,20);
414: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' ||
415: csr_rec.pre_assignment_action_id,20);
416: hr_utility.set_location('csr_rec.assignment_id = ' ||
417: csr_rec.assignment_id,20);
418: hr_utility.set_location('csr_rec.date_earned = ' ||
419: to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
420: hr_utility.set_location('csr_rec.pre_effective_date = '

Line 418: hr_utility.set_location('csr_rec.date_earned = ' ||

414: hr_utility.set_location('csr_rec.pre_assignment_action_id = ' ||
415: csr_rec.pre_assignment_action_id,20);
416: hr_utility.set_location('csr_rec.assignment_id = ' ||
417: csr_rec.assignment_id,20);
418: hr_utility.set_location('csr_rec.date_earned = ' ||
419: to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
420: hr_utility.set_location('csr_rec.pre_effective_date = '
421: ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
422: hr_utility.set_location('csr_rec.time_period_id = ' ||

Line 420: hr_utility.set_location('csr_rec.pre_effective_date = '

416: hr_utility.set_location('csr_rec.assignment_id = ' ||
417: csr_rec.assignment_id,20);
418: hr_utility.set_location('csr_rec.date_earned = ' ||
419: to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
420: hr_utility.set_location('csr_rec.pre_effective_date = '
421: ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
422: hr_utility.set_location('csr_rec.time_period_id = ' ||
423: csr_rec.time_period_id,20);
424:

Line 422: hr_utility.set_location('csr_rec.time_period_id = ' ||

418: hr_utility.set_location('csr_rec.date_earned = ' ||
419: to_char( csr_rec.date_earned,'dd-mon-yyyy'),20);
420: hr_utility.set_location('csr_rec.pre_effective_date = '
421: ||to_char( csr_rec.pre_effective_date,'dd-mon-yyyy'),20);
422: hr_utility.set_location('csr_rec.time_period_id = ' ||
423: csr_rec.time_period_id,20);
424:
425: -- Select all the child actions
426: FOR csr_child_rec IN csr_child_actions(csr_rec.master_assignment_action_id,

Line 443: hr_utility.set_location('csr_child_rec.run_type = ' ||

439: SELECT pay_assignment_actions_s.NEXTVAL
440: INTO l_actid
441: FROM dual;
442:
443: hr_utility.set_location('csr_child_rec.run_type = ' ||
444: csr_child_rec.run_type,30);
445: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||
446: csr_rec.master_assignment_action_id,30);
447:

Line 445: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||

441: FROM dual;
442:
443: hr_utility.set_location('csr_child_rec.run_type = ' ||
444: csr_child_rec.run_type,30);
445: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||
446: csr_rec.master_assignment_action_id,30);
447:
448: hr_nonrun_asact.insact(
449: lockingactid => l_actid

Line 458: hr_utility.set_location('creating lock3 ' ||

454: , prepayid => NULL
455: , status => 'C'
456: , source_act => p_assactid);
457:
458: hr_utility.set_location('creating lock3 ' ||
459: l_actid || ' to ' ||
460: csr_child_rec.child_assignment_action_id,30);
461:
462: hr_nonrun_asact.insint(

Line 480: hr_utility.set_location('csr_child_rec.run_type = ' ||

476: SELECT pay_assignment_actions_s.NEXTVAL
477: INTO l_actid
478: FROM dual;
479:
480: hr_utility.set_location('csr_child_rec.run_type = ' ||
481: csr_child_rec.run_type,30);
482: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||
483: csr_rec.master_assignment_action_id,30);
484:

Line 482: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||

478: FROM dual;
479:
480: hr_utility.set_location('csr_child_rec.run_type = ' ||
481: csr_child_rec.run_type,30);
482: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||
483: csr_rec.master_assignment_action_id,30);
484:
485: hr_nonrun_asact.insact(
486: lockingactid => l_actid

Line 510: hr_utility.set_location('creating lock4 ' ||

506: csr_rec.effective_date)
507:
508: LOOP
509:
510: hr_utility.set_location('creating lock4 ' ||
511: l_actid || ' to ' || csr_np_rec.np_assignment_action_id,30);
512:
513: hr_nonrun_asact.insint(
514: lockingactid => l_actid

Line 525: hr_utility.set_location('Leaving '|| l_proc,80);

521: END LOOP; -- child assignment actions
522:
523:
524: END LOOP;
525: hr_utility.set_location('Leaving '|| l_proc,80);
526:
527: END generate_child_actions;
528:
529: END pay_core_payslip_utils;