eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KW_PIFSS dependencies on HR_UTILITY

Line 13: hr_utility.set_location('Entering: '||l_proc,1);

9: BEGIN
10: --
11: l_proc := g_package||'range_cursor';
12:
13: hr_utility.set_location('Entering: '||l_proc,1);
14: --
15: -- Note: There must be one and only one entry of :payroll_action_id in
16: -- the string, and the statement must be, order by person_id
17: --

Line 25: hr_utility.set_location(' Leaving: '||l_proc,100);

21: 'where ppa.payroll_action_id = :payroll_action_id '||
22: 'and ppa.business_group_id = ppf.business_group_id '||
23: 'order by ppf.person_id';
24: --
25: hr_utility.set_location(' Leaving: '||l_proc,100);
26: END range_cursor;
27: --
28: procedure assignment_action_code
29: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

Line 72: hr_utility.set_location('Start of assignment_action_code',3);

68: cursor next_action_id is
69: select pay_assignment_actions_s.nextval
70: from dual;
71: begin
72: hr_utility.set_location('Start of assignment_action_code',3);
73: hr_utility.set_location('The payroll_action_id passed '|| p_payroll_action_id,4);
74: hr_utility.set_location('The p_start_person_id '|| p_start_person_id,5);
75: hr_utility.set_location('The p_end_person_id '|| p_end_person_id,6);
76: hr_utility.set_location('The p_chunk number '|| p_chunk ,7);

Line 73: hr_utility.set_location('The payroll_action_id passed '|| p_payroll_action_id,4);

69: select pay_assignment_actions_s.nextval
70: from dual;
71: begin
72: hr_utility.set_location('Start of assignment_action_code',3);
73: hr_utility.set_location('The payroll_action_id passed '|| p_payroll_action_id,4);
74: hr_utility.set_location('The p_start_person_id '|| p_start_person_id,5);
75: hr_utility.set_location('The p_end_person_id '|| p_end_person_id,6);
76: hr_utility.set_location('The p_chunk number '|| p_chunk ,7);
77: for process_rec in process_assignments (p_payroll_action_id,

Line 74: hr_utility.set_location('The p_start_person_id '|| p_start_person_id,5);

70: from dual;
71: begin
72: hr_utility.set_location('Start of assignment_action_code',3);
73: hr_utility.set_location('The payroll_action_id passed '|| p_payroll_action_id,4);
74: hr_utility.set_location('The p_start_person_id '|| p_start_person_id,5);
75: hr_utility.set_location('The p_end_person_id '|| p_end_person_id,6);
76: hr_utility.set_location('The p_chunk number '|| p_chunk ,7);
77: for process_rec in process_assignments (p_payroll_action_id,
78: p_start_person_id,

Line 75: hr_utility.set_location('The p_end_person_id '|| p_end_person_id,6);

71: begin
72: hr_utility.set_location('Start of assignment_action_code',3);
73: hr_utility.set_location('The payroll_action_id passed '|| p_payroll_action_id,4);
74: hr_utility.set_location('The p_start_person_id '|| p_start_person_id,5);
75: hr_utility.set_location('The p_end_person_id '|| p_end_person_id,6);
76: hr_utility.set_location('The p_chunk number '|| p_chunk ,7);
77: for process_rec in process_assignments (p_payroll_action_id,
78: p_start_person_id,
79: p_end_person_id)

Line 76: hr_utility.set_location('The p_chunk number '|| p_chunk ,7);

72: hr_utility.set_location('Start of assignment_action_code',3);
73: hr_utility.set_location('The payroll_action_id passed '|| p_payroll_action_id,4);
74: hr_utility.set_location('The p_start_person_id '|| p_start_person_id,5);
75: hr_utility.set_location('The p_end_person_id '|| p_end_person_id,6);
76: hr_utility.set_location('The p_chunk number '|| p_chunk ,7);
77: for process_rec in process_assignments (p_payroll_action_id,
78: p_start_person_id,
79: p_end_person_id)
80: loop

Line 81: hr_utility.set_location('LOOP STARTED '|| process_rec.assignment_id ,14);

77: for process_rec in process_assignments (p_payroll_action_id,
78: p_start_person_id,
79: p_end_person_id)
80: loop
81: hr_utility.set_location('LOOP STARTED '|| process_rec.assignment_id ,14);
82: open next_action_id;
83: fetch next_action_id into v_next_action_id;
84: close next_action_id;
85: hr_utility.set_location('before calling insact '|| v_next_action_id ,14);

Line 85: hr_utility.set_location('before calling insact '|| v_next_action_id ,14);

81: hr_utility.set_location('LOOP STARTED '|| process_rec.assignment_id ,14);
82: open next_action_id;
83: fetch next_action_id into v_next_action_id;
84: close next_action_id;
85: hr_utility.set_location('before calling insact '|| v_next_action_id ,14);
86: hr_nonrun_asact.insact(v_next_action_id,
87: process_rec.assignment_id,
88: p_payroll_action_id,
89: p_chunk,

Line 91: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);

87: process_rec.assignment_id,
88: p_payroll_action_id,
89: p_chunk,
90: null);
91: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);
92: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);
93: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
94: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
95: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);

Line 92: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);

88: p_payroll_action_id,
89: p_chunk,
90: null);
91: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);
92: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);
93: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
94: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
95: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
96: end loop;

Line 93: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);

89: p_chunk,
90: null);
91: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);
92: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);
93: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
94: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
95: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
96: end loop;
97: hr_utility.set_location('End of assignment_action_code',5);

Line 95: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);

91: hr_utility.set_location('inserted assigment action assignment '|| process_rec.assignment_id ,15);
92: hr_utility.set_location('Before calling hr_nonrun_asact.insint archive ' || process_rec.archive_action_id,16);
93: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
94: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
95: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
96: end loop;
97: hr_utility.set_location('End of assignment_action_code',5);
98: exception
99: when others then

Line 97: hr_utility.set_location('End of assignment_action_code',5);

93: hr_utility.set_location('v_next_action_id' || v_next_action_id,16);
94: hr_nonrun_asact.insint(v_next_action_id,process_rec.assignment_action_id);
95: hr_utility.set_location('After calling hr_nonrun_asact.insint',14);
96: end loop;
97: hr_utility.set_location('End of assignment_action_code',5);
98: exception
99: when others then
100: hr_utility.set_location('error raised in assignment_action_code procedure ',5);
101: raise;

Line 100: hr_utility.set_location('error raised in assignment_action_code procedure ',5);

96: end loop;
97: hr_utility.set_location('End of assignment_action_code',5);
98: exception
99: when others then
100: hr_utility.set_location('error raised in assignment_action_code procedure ',5);
101: raise;
102: end assignment_action_code;
103: --
104: procedure spawn_archive_reports is