DBA Data[Home] [Help]

APPS.PAY_AU_TFN_MAGTAPE dependencies on HR_UTILITY

Line 21: hr_utility.trace('Start of procedure set_value');

17:
18: PROCEDURE set_value(p_value in varchar2) IS
19:
20: BEGIN
21: hr_utility.trace('Start of procedure set_value');
22: tax_api_called_from := p_value;
23: hr_utility.trace('p value : ' || p_value);
24: hr_utility.trace('End of procedure set_value');
25:

Line 23: hr_utility.trace('p value : ' || p_value);

19:
20: BEGIN
21: hr_utility.trace('Start of procedure set_value');
22: tax_api_called_from := p_value;
23: hr_utility.trace('p value : ' || p_value);
24: hr_utility.trace('End of procedure set_value');
25:
26:
27:

Line 24: hr_utility.trace('End of procedure set_value');

20: BEGIN
21: hr_utility.trace('Start of procedure set_value');
22: tax_api_called_from := p_value;
23: hr_utility.trace('p value : ' || p_value);
24: hr_utility.trace('End of procedure set_value');
25:
26:
27:
28: EXCEPTION

Line 30: hr_utility.trace('Error in set_value');

26:
27:
28: EXCEPTION
29: WHEN OTHERS THEN
30: hr_utility.trace('Error in set_value');
31: RAISE;
32:
33: END set_value;
34:

Line 68: hr_utility.set_location('Start of range_code',1);

64: p_sql out nocopy varchar2) IS
65:
66: BEGIN
67:
68: hr_utility.set_location('Start of range_code',1);
69:
70: /*Bug2920725 Corrected base tables to support security model*/
71:
72: p_sql := ' SELECT distinct p.person_id' ||

Line 79: hr_utility.set_location('End of range_code',2);

75: ' WHERE pa.payroll_action_id = :payroll_action_id' ||
76: ' AND p.business_group_id = pa.business_group_id' ||
77: ' ORDER BY p.person_id';
78:
79: hr_utility.set_location('End of range_code',2);
80:
81: EXCEPTION
82: WHEN OTHERS THEN
83: hr_utility.trace('Error in range_code');

Line 83: hr_utility.trace('Error in range_code');

79: hr_utility.set_location('End of range_code',2);
80:
81: EXCEPTION
82: WHEN OTHERS THEN
83: hr_utility.trace('Error in range_code');
84: RAISE;
85: END range_code;
86:
87:

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

259: FROM dual;
260:
261: BEGIN
262:
263: hr_utility.set_location('Start of assignment_action_code',3);
264:
265: OPEN c_get_parameters(p_payroll_action_id);
266: FETCH c_get_parameters INTO l_business_group_id,
267: l_legal_employer_id,

Line 287: hr_utility.trace('Employee not eligible for magtape');

283:
284: IF (process_rec.tax_file_number= '111 111 111' AND
285: nvl(process_rec.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY')) NOT BETWEEN (l_report_end_date - 13)
286: AND l_report_end_date) THEN
287: hr_utility.trace('Employee not eligible for magtape');
288: ELSE
289: hr_utility.trace(' In the assignment action insertion ');
290:
291: OPEN next_action_id;

Line 289: hr_utility.trace(' In the assignment action insertion ');

285: nvl(process_rec.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY')) NOT BETWEEN (l_report_end_date - 13)
286: AND l_report_end_date) THEN
287: hr_utility.trace('Employee not eligible for magtape');
288: ELSE
289: hr_utility.trace(' In the assignment action insertion ');
290:
291: OPEN next_action_id;
292: FETCH next_action_id INTO v_next_action_id;
293: CLOSE next_action_id;

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

301:
302:
303: END LOOP;
304:
305: hr_utility.set_location('End of assignment_action_code',5);
306:
307: EXCEPTION
308: WHEN OTHERS THEN
309: hr_utility.trace('Error in assignment_action_code');

Line 309: hr_utility.trace('Error in assignment_action_code');

305: hr_utility.set_location('End of assignment_action_code',5);
306:
307: EXCEPTION
308: WHEN OTHERS THEN
309: hr_utility.trace('Error in assignment_action_code');
310: RAISE;
311:
312: END assignment_action_code;
313:

Line 348: hr_utility.set_location('Start of initialization_code',6);

344:
345:
346: BEGIN
347:
348: hr_utility.set_location('Start of initialization_code',6);
349:
350: OPEN c_get_parameters(p_payroll_action_id);
351: FETCH c_get_parameters INTO l_business_group_id,
352: l_legal_employer_id,

Line 369: hr_utility.set_location('End of initialization_code',7);

365: l_legal_employer_id,
366: l_report_end_date);
367:
368:
369: hr_utility.set_location('End of initialization_code',7);
370:
371: EXCEPTION
372: WHEN OTHERS THEN
373: hr_utility.trace('Error in initialization_code');

Line 373: hr_utility.trace('Error in initialization_code');

369: hr_utility.set_location('End of initialization_code',7);
370:
371: EXCEPTION
372: WHEN OTHERS THEN
373: hr_utility.trace('Error in initialization_code');
374: RAISE;
375:
376: END initialization_code;
377:

Line 389: hr_utility.set_location('Start of archive_code',8);

385: (p_payroll_action_id in pay_assignment_actions.payroll_action_id%TYPE,
386: p_effective_date in date) IS
387:
388: BEGIN
389: hr_utility.set_location('Start of archive_code',8);
390: null;
391: hr_utility.set_location('End of archive_code',9);
392: END archive_code;
393:

Line 391: hr_utility.set_location('End of archive_code',9);

387:
388: BEGIN
389: hr_utility.set_location('Start of archive_code',8);
390: null;
391: hr_utility.set_location('End of archive_code',9);
392: END archive_code;
393:
394:
395: END pay_au_tfn_magtape;