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

Line 37: hr_utility.set_location(l_proc_name, 10);

33: IS
34: l_proc_name VARCHAR2(100) ;
35: BEGIN
36: l_proc_name := l_package || 'range_code';
37: hr_utility.set_location(l_proc_name, 10);
38: p_sqlstr := 'SELECT DISTINCT person_id
39: FROM per_all_people_f ppf,
40: pay_payroll_actions ppa
41: WHERE ppa.payroll_action_id = :payroll_action_id

Line 44: hr_utility.set_location(l_proc_name, 20);

40: pay_payroll_actions ppa
41: WHERE ppa.payroll_action_id = :payroll_action_id
42: AND ppa.business_group_id = ppf.business_group_id
43: ORDER BY ppf.person_id';
44: hr_utility.set_location(l_proc_name, 20);
45: END range_cursor;
46: --
47:
48: ----------------------------------------------------------------------------------------------

Line 162: hr_utility.set_location(l_proc_name, 10);

158:
159: BEGIN
160:
161: l_proc_name := l_package || 'assignment_action_code';
162: hr_utility.set_location(l_proc_name, 10);
163:
164: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
165: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
166: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));

Line 168: hr_utility.set_location('assignment_action_code l_payroll_id '||l_payroll_id,100);

164: l_payroll_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'PAYROLL_ID'));
165: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
166: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
167: l_le_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'LEGAL_EMPLOYER'));
168: hr_utility.set_location('assignment_action_code l_payroll_id '||l_payroll_id,100);
169: hr_utility.set_location('assignment_action_code l_le_id '||l_le_id,100);
170: hr_utility.set_location('assignment_action_code p_start_person_id '||p_start_person_id,100);
171: hr_utility.set_location('assignment_action_code p_end_person_id '||p_end_person_id,100);
172: hr_utility.set_location('assignment_action_code l_consolidation_set '||l_consolidation_set,100);

Line 169: hr_utility.set_location('assignment_action_code l_le_id '||l_le_id,100);

165: l_consolidation_set := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'CONSOLIDATION_SET_ID'));
166: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
167: l_le_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'LEGAL_EMPLOYER'));
168: hr_utility.set_location('assignment_action_code l_payroll_id '||l_payroll_id,100);
169: hr_utility.set_location('assignment_action_code l_le_id '||l_le_id,100);
170: hr_utility.set_location('assignment_action_code p_start_person_id '||p_start_person_id,100);
171: hr_utility.set_location('assignment_action_code p_end_person_id '||p_end_person_id,100);
172: hr_utility.set_location('assignment_action_code l_consolidation_set '||l_consolidation_set,100);
173: hr_utility.set_location(l_proc_name, 20);

Line 170: hr_utility.set_location('assignment_action_code p_start_person_id '||p_start_person_id,100);

166: l_assignment_set_id :=to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'ASSIGNMENT_SET_ID'));
167: l_le_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'LEGAL_EMPLOYER'));
168: hr_utility.set_location('assignment_action_code l_payroll_id '||l_payroll_id,100);
169: hr_utility.set_location('assignment_action_code l_le_id '||l_le_id,100);
170: hr_utility.set_location('assignment_action_code p_start_person_id '||p_start_person_id,100);
171: hr_utility.set_location('assignment_action_code p_end_person_id '||p_end_person_id,100);
172: hr_utility.set_location('assignment_action_code l_consolidation_set '||l_consolidation_set,100);
173: hr_utility.set_location(l_proc_name, 20);
174:

Line 171: hr_utility.set_location('assignment_action_code p_end_person_id '||p_end_person_id,100);

167: l_le_id := to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(p_payroll_action_id,'LEGAL_EMPLOYER'));
168: hr_utility.set_location('assignment_action_code l_payroll_id '||l_payroll_id,100);
169: hr_utility.set_location('assignment_action_code l_le_id '||l_le_id,100);
170: hr_utility.set_location('assignment_action_code p_start_person_id '||p_start_person_id,100);
171: hr_utility.set_location('assignment_action_code p_end_person_id '||p_end_person_id,100);
172: hr_utility.set_location('assignment_action_code l_consolidation_set '||l_consolidation_set,100);
173: hr_utility.set_location(l_proc_name, 20);
174:
175: FOR rec_asg IN csr_asg(p_payroll_action_id

Line 172: hr_utility.set_location('assignment_action_code l_consolidation_set '||l_consolidation_set,100);

168: hr_utility.set_location('assignment_action_code l_payroll_id '||l_payroll_id,100);
169: hr_utility.set_location('assignment_action_code l_le_id '||l_le_id,100);
170: hr_utility.set_location('assignment_action_code p_start_person_id '||p_start_person_id,100);
171: hr_utility.set_location('assignment_action_code p_end_person_id '||p_end_person_id,100);
172: hr_utility.set_location('assignment_action_code l_consolidation_set '||l_consolidation_set,100);
173: hr_utility.set_location(l_proc_name, 20);
174:
175: FOR rec_asg IN csr_asg(p_payroll_action_id
176: ,p_start_person_id

Line 173: hr_utility.set_location(l_proc_name, 20);

169: hr_utility.set_location('assignment_action_code l_le_id '||l_le_id,100);
170: hr_utility.set_location('assignment_action_code p_start_person_id '||p_start_person_id,100);
171: hr_utility.set_location('assignment_action_code p_end_person_id '||p_end_person_id,100);
172: hr_utility.set_location('assignment_action_code l_consolidation_set '||l_consolidation_set,100);
173: hr_utility.set_location(l_proc_name, 20);
174:
175: FOR rec_asg IN csr_asg(p_payroll_action_id
176: ,p_start_person_id
177: ,p_end_person_id

Line 205: hr_utility.set_location(l_proc_name, 40);

201: , rec_asg.assignment_action_id);
202: --
203:
204: END LOOP;
205: hr_utility.set_location(l_proc_name, 40);
206:
207: EXCEPTION
208: WHEN OTHERS THEN
209: hr_utility.set_location('Error in assignment action code ',100);

Line 209: hr_utility.set_location('Error in assignment action code ',100);

205: hr_utility.set_location(l_proc_name, 40);
206:
207: EXCEPTION
208: WHEN OTHERS THEN
209: hr_utility.set_location('Error in assignment action code ',100);
210: RAISE;
211: END assignment_action_code;
212:
213: -----------------------------------------------------------------------------------------------------------------

Line 448: hr_utility.set_message (801, 'PAY_376830_NO_SERIAL_NUM_OVER');

444:
445: l_number := to_number(p_sequence);
446:
447: if l_number = 9999 and p_type = 'SERIAL_NUM' then
448: hr_utility.set_message (801, 'PAY_376830_NO_SERIAL_NUM_OVER');
449: hr_utility.raise_error;
450: return '-1';
451: end if;
452:

Line 449: hr_utility.raise_error;

445: l_number := to_number(p_sequence);
446:
447: if l_number = 9999 and p_type = 'SERIAL_NUM' then
448: hr_utility.set_message (801, 'PAY_376830_NO_SERIAL_NUM_OVER');
449: hr_utility.raise_error;
450: return '-1';
451: end if;
452:
453: if l_number = 9999 and p_type = 'SEQ_CONTROL' then

Line 1240: hr_utility.set_message (801, 'PAY_376826_NO_DATA_EXC_DIR_MIS');

1236: -- Set retcode to 2, indicating an ERROR to the ConcMgr
1237: retcode := c_error;
1238:
1239: -- Set the application error
1240: hr_utility.set_message (801, 'PAY_376826_NO_DATA_EXC_DIR_MIS');
1241:
1242: -- Return the message to the ConcMgr (This msg will appear in the log file)
1243:
1244: errbuf := hr_utility.get_message;

Line 1244: errbuf := hr_utility.get_message;

1240: hr_utility.set_message (801, 'PAY_376826_NO_DATA_EXC_DIR_MIS');
1241:
1242: -- Return the message to the ConcMgr (This msg will appear in the log file)
1243:
1244: errbuf := hr_utility.get_message;
1245:
1246: WHEN UTL_FILE.invalid_operation
1247: -- File could not be opened as requested, perhaps because of operating system permissions
1248: -- Also raised when attempting a write operation on a file opened for read, or a read operation