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

Line 17: hr_utility.set_location('Entering ' || l_proc, 20);

13: l_start_pos NUMBER;
14: l_delimiter varchar2(1):=' ';
15: l_proc VARCHAR2(160):= g_package||'.get parameter ';
16: BEGIN
17: hr_utility.set_location('Entering ' || l_proc, 20);
18: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
19: IF l_start_pos = 0 THEN
20: l_delimiter := '|';
21: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');

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

34: instr(l_parameter,':',1,p_segment_number+1) -1
35: - instr(l_parameter,':',1,p_segment_number));
36: END IF;
37: END IF;
38: hr_utility.set_location('Leaving ' || l_proc, 100);
39: RETURN l_parameter;
40:
41: END get_parameter;
42:

Line 58: hr_utility.set_location('Entering ' || l_proc, 20);

54: l_proc VARCHAR2(160):= g_package||'.get_all_parameters ';
55:
56: BEGIN
57:
58: hr_utility.set_location('Entering ' || l_proc, 20);
59:
60: OPEN csr_parameter_info (p_payroll_action_id);
61: FETCH csr_parameter_info INTO p_token_value,
62: p_business_group_id;

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

61: FETCH csr_parameter_info INTO p_token_value,
62: p_business_group_id;
63: CLOSE csr_parameter_info;
64:
65: hr_utility.set_location('Leaving ' || l_proc, 100);
66:
67: END get_all_parameters;
68:
69:

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

84: l_end_date VARCHAR2(20);
85:
86: BEGIN
87:
88: hr_utility.set_location('Entering ' || l_proc,10);
89:
90: pay_ie_p30lock.get_all_parameters
91: (p_payroll_action_id => pactid,
92: p_token => 'END_DATE',

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

93: p_business_group_id => l_business_group_id,
94: p_token_value => l_end_date);
95:
96:
97: hr_utility.set_location('Step ' || l_proc,20);
98: hr_utility.set_location('l_end_date = ' || l_end_date,20);
99:
100: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
101: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);

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

94: p_token_value => l_end_date);
95:
96:
97: hr_utility.set_location('Step ' || l_proc,20);
98: hr_utility.set_location('l_end_date = ' || l_end_date,20);
99:
100: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
101: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
102:

Line 101: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);

97: hr_utility.set_location('Step ' || l_proc,20);
98: hr_utility.set_location('l_end_date = ' || l_end_date,20);
99:
100: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
101: hr_utility.set_location('l_canonical_end_date = ' || l_canonical_end_date,20);
102:
103: -- Used per_people_f 4555600
104: -- Changed the cursor to reduce the cost (5042843)
105: sqlstr := 'SELECT distinct asg.person_id

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

112: AND pos.business_group_id = ppa.business_group_id
113: AND asg.business_group_id = ppa.business_group_id
114: ORDER BY asg.person_id';
115:
116: hr_utility.set_location('Leaving ' || l_proc,40);
117:
118: EXCEPTION
119: WHEN OTHERS THEN
120: hr_utility.set_location(' Leaving with EXCEPTION: '||l_proc,100);

Line 120: hr_utility.set_location(' Leaving with EXCEPTION: '||l_proc,100);

116: hr_utility.set_location('Leaving ' || l_proc,40);
117:
118: EXCEPTION
119: WHEN OTHERS THEN
120: hr_utility.set_location(' Leaving with EXCEPTION: '||l_proc,100);
121: -- Return cursor that selects no rows
122: sqlstr := sqlerrm;
123: END range_code;
124:

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

192: paa.assignment_action_id;
193:
194:
195: BEGIN
196: hr_utility.set_location('Entering ' || l_proc,10);
197: pay_ie_p30lock.get_all_parameters
198: (p_payroll_action_id => pactid,
199: p_token => 'END_DATE',
200: p_business_group_id => l_business_group_id,

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

206: , p_token => 'CONSOLIDATION'
207: , p_business_group_id => l_business_group_id
208: , p_token_value => l_consolidation_set);
209:
210: hr_utility.set_location('Step ' || l_proc,20);
211: hr_utility.set_location('l_end_date = ' || l_end_date,20);
212: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
213: FOR csr_rec IN csr_assact
214: LOOP

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

207: , p_business_group_id => l_business_group_id
208: , p_token_value => l_consolidation_set);
209:
210: hr_utility.set_location('Step ' || l_proc,20);
211: hr_utility.set_location('l_end_date = ' || l_end_date,20);
212: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
213: FOR csr_rec IN csr_assact
214: LOOP
215: IF l_arch_action_id <> csr_rec.assignment_action_id THEN

Line 216: hr_utility.set_location('inside loop ' || l_proc,12);

212: l_canonical_end_date := TO_DATE(l_end_date,'yyyy/mm/dd');
213: FOR csr_rec IN csr_assact
214: LOOP
215: IF l_arch_action_id <> csr_rec.assignment_action_id THEN
216: hr_utility.set_location('inside loop ' || l_proc,12);
217: hr_utility.set_location('-----------------------------------------',13);
218: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
219: hr_utility.set_location('pactid_id ' || pactid,15);
220: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);

Line 217: hr_utility.set_location('-----------------------------------------',13);

213: FOR csr_rec IN csr_assact
214: LOOP
215: IF l_arch_action_id <> csr_rec.assignment_action_id THEN
216: hr_utility.set_location('inside loop ' || l_proc,12);
217: hr_utility.set_location('-----------------------------------------',13);
218: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
219: hr_utility.set_location('pactid_id ' || pactid,15);
220: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
221: hr_utility.set_location('-----------------------------------------',17);

Line 218: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);

214: LOOP
215: IF l_arch_action_id <> csr_rec.assignment_action_id THEN
216: hr_utility.set_location('inside loop ' || l_proc,12);
217: hr_utility.set_location('-----------------------------------------',13);
218: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
219: hr_utility.set_location('pactid_id ' || pactid,15);
220: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
221: hr_utility.set_location('-----------------------------------------',17);
222: SELECT pay_assignment_actions_s.NEXTVAL

Line 219: hr_utility.set_location('pactid_id ' || pactid,15);

215: IF l_arch_action_id <> csr_rec.assignment_action_id THEN
216: hr_utility.set_location('inside loop ' || l_proc,12);
217: hr_utility.set_location('-----------------------------------------',13);
218: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
219: hr_utility.set_location('pactid_id ' || pactid,15);
220: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
221: hr_utility.set_location('-----------------------------------------',17);
222: SELECT pay_assignment_actions_s.NEXTVAL
223: INTO l_actid

Line 220: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);

216: hr_utility.set_location('inside loop ' || l_proc,12);
217: hr_utility.set_location('-----------------------------------------',13);
218: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
219: hr_utility.set_location('pactid_id ' || pactid,15);
220: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
221: hr_utility.set_location('-----------------------------------------',17);
222: SELECT pay_assignment_actions_s.NEXTVAL
223: INTO l_actid
224: FROM dual;

Line 221: hr_utility.set_location('-----------------------------------------',17);

217: hr_utility.set_location('-----------------------------------------',13);
218: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
219: hr_utility.set_location('pactid_id ' || pactid,15);
220: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
221: hr_utility.set_location('-----------------------------------------',17);
222: SELECT pay_assignment_actions_s.NEXTVAL
223: INTO l_actid
224: FROM dual;
225: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);

Line 226: hr_utility.set_location('created pay_ass_act ' || l_actid || ' to ' || pactid,20);

222: SELECT pay_assignment_actions_s.NEXTVAL
223: INTO l_actid
224: FROM dual;
225: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
226: hr_utility.set_location('created pay_ass_act ' || l_actid || ' to ' || pactid,20);
227: hr_nonrun_asact.insint(l_actid, csr_rec.assignment_action_id);
228: hr_utility.set_location('created interlocks ' || l_actid || ' to ' || csr_rec.assignment_action_id,20);
229: l_arch_action_id := csr_rec.assignment_action_id;
230: END IF;

Line 228: hr_utility.set_location('created interlocks ' || l_actid || ' to ' || csr_rec.assignment_action_id,20);

224: FROM dual;
225: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
226: hr_utility.set_location('created pay_ass_act ' || l_actid || ' to ' || pactid,20);
227: hr_nonrun_asact.insint(l_actid, csr_rec.assignment_action_id);
228: hr_utility.set_location('created interlocks ' || l_actid || ' to ' || csr_rec.assignment_action_id,20);
229: l_arch_action_id := csr_rec.assignment_action_id;
230: END IF;
231: END LOOP;
232:

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

229: l_arch_action_id := csr_rec.assignment_action_id;
230: END IF;
231: END LOOP;
232:
233: hr_utility.set_location('Leaving ' || l_proc,20);
234:
235: END prg_assignment_action_code;
236:
237:

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

288:
289:
290: BEGIN
291:
292: hr_utility.set_location('Entering ' || l_proc,10);
293:
294: pay_ie_p30lock.get_all_parameters
295: (p_payroll_action_id => pactid,
296: p_token => 'PAYROLL_ACTION_ID',

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

297: p_business_group_id => l_business_group_id,
298: p_token_value => l_pay_action_id);
299:
300:
301: hr_utility.set_location('Step ' || l_proc,20);
302: hr_utility.set_location('l_pay_action_id = ' || l_pay_action_id,20);
303:
304: FOR csr_rec IN csr_assact
305: LOOP

Line 302: hr_utility.set_location('l_pay_action_id = ' || l_pay_action_id,20);

298: p_token_value => l_pay_action_id);
299:
300:
301: hr_utility.set_location('Step ' || l_proc,20);
302: hr_utility.set_location('l_pay_action_id = ' || l_pay_action_id,20);
303:
304: FOR csr_rec IN csr_assact
305: LOOP
306: hr_utility.set_location('inside loop ' || l_proc,12);

Line 306: hr_utility.set_location('inside loop ' || l_proc,12);

302: hr_utility.set_location('l_pay_action_id = ' || l_pay_action_id,20);
303:
304: FOR csr_rec IN csr_assact
305: LOOP
306: hr_utility.set_location('inside loop ' || l_proc,12);
307: hr_utility.set_location('-----------------------------------------',13);
308: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
309: hr_utility.set_location('Pact_id ' || pactid,15);
310: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);

Line 307: hr_utility.set_location('-----------------------------------------',13);

303:
304: FOR csr_rec IN csr_assact
305: LOOP
306: hr_utility.set_location('inside loop ' || l_proc,12);
307: hr_utility.set_location('-----------------------------------------',13);
308: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
309: hr_utility.set_location('Pact_id ' || pactid,15);
310: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
311: hr_utility.set_location('-----------------------------------------',17);

Line 308: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);

304: FOR csr_rec IN csr_assact
305: LOOP
306: hr_utility.set_location('inside loop ' || l_proc,12);
307: hr_utility.set_location('-----------------------------------------',13);
308: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
309: hr_utility.set_location('Pact_id ' || pactid,15);
310: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
311: hr_utility.set_location('-----------------------------------------',17);
312: SELECT pay_assignment_actions_s.NEXTVAL

Line 309: hr_utility.set_location('Pact_id ' || pactid,15);

305: LOOP
306: hr_utility.set_location('inside loop ' || l_proc,12);
307: hr_utility.set_location('-----------------------------------------',13);
308: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
309: hr_utility.set_location('Pact_id ' || pactid,15);
310: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
311: hr_utility.set_location('-----------------------------------------',17);
312: SELECT pay_assignment_actions_s.NEXTVAL
313: INTO l_actid

Line 310: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);

306: hr_utility.set_location('inside loop ' || l_proc,12);
307: hr_utility.set_location('-----------------------------------------',13);
308: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
309: hr_utility.set_location('Pact_id ' || pactid,15);
310: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
311: hr_utility.set_location('-----------------------------------------',17);
312: SELECT pay_assignment_actions_s.NEXTVAL
313: INTO l_actid
314: FROM dual;

Line 311: hr_utility.set_location('-----------------------------------------',17);

307: hr_utility.set_location('-----------------------------------------',13);
308: hr_utility.set_location('Assignment_action_id ' || csr_rec.assignment_action_id,14);
309: hr_utility.set_location('Pact_id ' || pactid,15);
310: hr_utility.set_location('Payroll_action_id ' || csr_rec.payroll_action_id,15);
311: hr_utility.set_location('-----------------------------------------',17);
312: SELECT pay_assignment_actions_s.NEXTVAL
313: INTO l_actid
314: FROM dual;
315: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);

Line 316: hr_utility.set_location('created pay_ass_act ' || l_actid || ' to ' || pactid,20);

312: SELECT pay_assignment_actions_s.NEXTVAL
313: INTO l_actid
314: FROM dual;
315: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
316: hr_utility.set_location('created pay_ass_act ' || l_actid || ' to ' || pactid,20);
317: hr_nonrun_asact.insint(l_actid, csr_rec.assignment_action_id);
318: hr_utility.set_location('created interlocks ' || l_actid || ' to ' || csr_rec.assignment_action_id,20);
319:
320: END LOOP;

Line 318: hr_utility.set_location('created interlocks ' || l_actid || ' to ' || csr_rec.assignment_action_id,20);

314: FROM dual;
315: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,csr_rec.tax_unit_id);
316: hr_utility.set_location('created pay_ass_act ' || l_actid || ' to ' || pactid,20);
317: hr_nonrun_asact.insint(l_actid, csr_rec.assignment_action_id);
318: hr_utility.set_location('created interlocks ' || l_actid || ' to ' || csr_rec.assignment_action_id,20);
319:
320: END LOOP;
321:
322: hr_utility.set_location('Leaving ' || l_proc,20);

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

318: hr_utility.set_location('created interlocks ' || l_actid || ' to ' || csr_rec.assignment_action_id,20);
319:
320: END LOOP;
321:
322: hr_utility.set_location('Leaving ' || l_proc,20);
323:
324: END rep_assignment_action_code;
325:
326: ---------------------------------------------------------------------