DBA Data[Home] [Help]

APPS.PAY_IE_P35_MAGTAPE dependencies on HR_UTILITY

Line 39: hr_utility.set_location ( 'p_token_name = '

35:
36: l_business_group_id NUMBER;
37: l_token_value VARCHAR2 (50);
38: BEGIN
39: hr_utility.set_location ( 'p_token_name = '
40: || p_token_name, 20);
41: OPEN csr_parameter_info (p_payroll_action_id, p_token_name);
42: FETCH csr_parameter_info INTO l_token_value, l_business_group_id;
43: CLOSE csr_parameter_info;

Line 87: --hr_utility.trace_on(null,'MAGTRC');

83: ) BETWEEN l_start_date AND l_end_date
84: AND ppa.business_group_id = l_bg_id;
85:
86: BEGIN
87: --hr_utility.trace_on(null,'MAGTRC');
88: l_out_var :=
89: pay_ie_p35.get_parameter (
90: p_payroll_action_id=> p_payroll_action_id,
91: p_token_name=> 'END_DATE'

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

129: AND pos.business_group_id = ppa.business_group_id
130: AND asg.business_group_id = ppa.business_group_id
131: ORDER BY asg.person_id';
132: /* Added code for BUG 2987230 */
133: hr_utility.set_location (l_proc_name, 20);
134:
135: EXCEPTION
136: WHEN OTHERS
137: THEN

Line 291: hr_utility.set_location ('pactid passed to action creation::'|| pactid ||'::' ,910);

287:
288:
289: BEGIN
290:
291: hr_utility.set_location ('pactid passed to action creation::'|| pactid ||'::' ,910);
292: hr_utility.set_location ('stperson passed to action creation::'||stperson , 920);
293: hr_utility.set_location ('endperson passed to action creation::'||endperson,930);
294: hr_utility.set_location ('CHUNK passed to action creation::'||CHUNK ,940);
295: hr_utility.set_location (l_proc_name, 10);

Line 292: hr_utility.set_location ('stperson passed to action creation::'||stperson , 920);

288:
289: BEGIN
290:
291: hr_utility.set_location ('pactid passed to action creation::'|| pactid ||'::' ,910);
292: hr_utility.set_location ('stperson passed to action creation::'||stperson , 920);
293: hr_utility.set_location ('endperson passed to action creation::'||endperson,930);
294: hr_utility.set_location ('CHUNK passed to action creation::'||CHUNK ,940);
295: hr_utility.set_location (l_proc_name, 10);
296:

Line 293: hr_utility.set_location ('endperson passed to action creation::'||endperson,930);

289: BEGIN
290:
291: hr_utility.set_location ('pactid passed to action creation::'|| pactid ||'::' ,910);
292: hr_utility.set_location ('stperson passed to action creation::'||stperson , 920);
293: hr_utility.set_location ('endperson passed to action creation::'||endperson,930);
294: hr_utility.set_location ('CHUNK passed to action creation::'||CHUNK ,940);
295: hr_utility.set_location (l_proc_name, 10);
296:
297: -- l_end_date := pay_ie_p35.get_end_date;

Line 294: hr_utility.set_location ('CHUNK passed to action creation::'||CHUNK ,940);

290:
291: hr_utility.set_location ('pactid passed to action creation::'|| pactid ||'::' ,910);
292: hr_utility.set_location ('stperson passed to action creation::'||stperson , 920);
293: hr_utility.set_location ('endperson passed to action creation::'||endperson,930);
294: hr_utility.set_location ('CHUNK passed to action creation::'||CHUNK ,940);
295: hr_utility.set_location (l_proc_name, 10);
296:
297: -- l_end_date := pay_ie_p35.get_end_date;
298:

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

291: hr_utility.set_location ('pactid passed to action creation::'|| pactid ||'::' ,910);
292: hr_utility.set_location ('stperson passed to action creation::'||stperson , 920);
293: hr_utility.set_location ('endperson passed to action creation::'||endperson,930);
294: hr_utility.set_location ('CHUNK passed to action creation::'||CHUNK ,940);
295: hr_utility.set_location (l_proc_name, 10);
296:
297: -- l_end_date := pay_ie_p35.get_end_date;
298:
299:

Line 316: hr_utility.set_location ( 'Start date -'

312: );
313:
314: l_bg_id := TO_NUMBER (l_out_var);
315:
316: hr_utility.set_location ( 'Start date -'
317: || TO_CHAR (l_start_date), 11);
318: hr_utility.set_location ( 'End date -'
319: || TO_CHAR (l_end_date), 12);
320: hr_utility.set_location ( 'Bus Group id -'

Line 318: hr_utility.set_location ( 'End date -'

314: l_bg_id := TO_NUMBER (l_out_var);
315:
316: hr_utility.set_location ( 'Start date -'
317: || TO_CHAR (l_start_date), 11);
318: hr_utility.set_location ( 'End date -'
319: || TO_CHAR (l_end_date), 12);
320: hr_utility.set_location ( 'Bus Group id -'
321: || TO_CHAR (l_bg_id), 13);
322:

Line 320: hr_utility.set_location ( 'Bus Group id -'

316: hr_utility.set_location ( 'Start date -'
317: || TO_CHAR (l_start_date), 11);
318: hr_utility.set_location ( 'End date -'
319: || TO_CHAR (l_end_date), 12);
320: hr_utility.set_location ( 'Bus Group id -'
321: || TO_CHAR (l_bg_id), 13);
322:
323:
324: --

Line 345: hr_utility.set_location ('Selected assignment ::'|| c_rec.assignment_id || ' ::and action ::passed to action creation::'||

341: CLOSE csr_get_flag_from_set;
342:
343: FOR c_rec in csr_locked_asgs
344: LOOP
345: hr_utility.set_location ('Selected assignment ::'|| c_rec.assignment_id || ' ::and action ::passed to action creation::'||
346: c_rec.assignment_action_id||'::',960);
347: hr_utility.set_location ('Selected payroll_action::'||c_rec.payroll_action_id ,960);
348:
349: SELECT pay_assignment_actions_s.NEXTVAL

Line 347: hr_utility.set_location ('Selected payroll_action::'||c_rec.payroll_action_id ,960);

343: FOR c_rec in csr_locked_asgs
344: LOOP
345: hr_utility.set_location ('Selected assignment ::'|| c_rec.assignment_id || ' ::and action ::passed to action creation::'||
346: c_rec.assignment_action_id||'::',960);
347: hr_utility.set_location ('Selected payroll_action::'||c_rec.payroll_action_id ,960);
348:
349: SELECT pay_assignment_actions_s.NEXTVAL
350: INTO l_actid
351: FROM DUAL;

Line 362: hr_utility.set_location ('Created aact::'||l_actid ||' for assignment::'|| c_rec.assignment_id ||':: and aact::'||

358: CHUNK,
359: NULL
360: );
361:
362: hr_utility.set_location ('Created aact::'||l_actid ||' for assignment::'|| c_rec.assignment_id ||':: and aact::'||
363: c_rec.assignment_action_id||'::',970);
364:
365: hr_nonrun_asact.insint ( l_actid,c_rec.assignment_action_id);
366: --Fnd_file.put_line(FND_FILE.LOG,'Locked Assignment Action ID'||c_rec.assignment_action_id );

Line 367: hr_utility.set_location ('Locked Assignment Action ID::'||c_rec.assignment_action_id ||' :: using aact::'||l_actid,980);

363: c_rec.assignment_action_id||'::',970);
364:
365: hr_nonrun_asact.insint ( l_actid,c_rec.assignment_action_id);
366: --Fnd_file.put_line(FND_FILE.LOG,'Locked Assignment Action ID'||c_rec.assignment_action_id );
367: hr_utility.set_location ('Locked Assignment Action ID::'||c_rec.assignment_action_id ||' :: using aact::'||l_actid,980);
368: l_arc_payroll_action_id := c_rec.payroll_action_id;
369:
370: END LOOP;
371: --Fnd_file.put_line(FND_FILE.LOG,l_arc_payroll_action_id );

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

372:
373: EXCEPTION
374: WHEN OTHERS
375: THEN
376: hr_utility.set_location ('Error in assignment action code ', 100);
377: RAISE;
378: END action_creation;
379:
380: --