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 253: hr_utility.set_location('Start of assignment_action_code',3);

249: FROM dual;
250:
251: BEGIN
252:
253: hr_utility.set_location('Start of assignment_action_code',3);
254:
255: OPEN c_get_parameters(p_payroll_action_id);
256: FETCH c_get_parameters INTO l_business_group_id,
257: l_legal_employer_id,

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

273:
274: IF (process_rec.tax_file_number= '111 111 111' AND
275: nvl(process_rec.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY')) NOT BETWEEN (l_report_end_date - 13)
276: AND l_report_end_date) THEN
277: hr_utility.trace('Employee not eligible for magtape');
278: ELSE
279: hr_utility.trace(' In the assignment action insertion ');
280:
281: OPEN next_action_id;

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

275: nvl(process_rec.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY')) NOT BETWEEN (l_report_end_date - 13)
276: AND l_report_end_date) THEN
277: hr_utility.trace('Employee not eligible for magtape');
278: ELSE
279: hr_utility.trace(' In the assignment action insertion ');
280:
281: OPEN next_action_id;
282: FETCH next_action_id INTO v_next_action_id;
283: CLOSE next_action_id;

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

291:
292:
293: END LOOP;
294:
295: hr_utility.set_location('End of assignment_action_code',5);
296:
297: EXCEPTION
298: WHEN OTHERS THEN
299: hr_utility.trace('Error in assignment_action_code');

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

295: hr_utility.set_location('End of assignment_action_code',5);
296:
297: EXCEPTION
298: WHEN OTHERS THEN
299: hr_utility.trace('Error in assignment_action_code');
300: RAISE;
301:
302: END assignment_action_code;
303:

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

334:
335:
336: BEGIN
337:
338: hr_utility.set_location('Start of initialization_code',6);
339:
340: OPEN c_get_parameters(p_payroll_action_id);
341: FETCH c_get_parameters INTO l_business_group_id,
342: l_legal_employer_id,

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

355: l_legal_employer_id,
356: l_report_end_date);
357:
358:
359: hr_utility.set_location('End of initialization_code',7);
360:
361: EXCEPTION
362: WHEN OTHERS THEN
363: hr_utility.trace('Error in initialization_code');

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

359: hr_utility.set_location('End of initialization_code',7);
360:
361: EXCEPTION
362: WHEN OTHERS THEN
363: hr_utility.trace('Error in initialization_code');
364: RAISE;
365:
366: END initialization_code;
367:

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

375: (p_payroll_action_id in pay_assignment_actions.payroll_action_id%TYPE,
376: p_effective_date in date) IS
377:
378: BEGIN
379: hr_utility.set_location('Start of archive_code',8);
380: null;
381: hr_utility.set_location('End of archive_code',9);
382: END archive_code;
383:

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

377:
378: BEGIN
379: hr_utility.set_location('Start of archive_code',8);
380: null;
381: hr_utility.set_location('End of archive_code',9);
382: END archive_code;
383:
384:
385: END pay_au_tfn_magtape;