1: PACKAGE BODY pay_ca_dd_magtape_pkg AS
2: /* $Header: pycaddmg.pkb 120.8 2006/10/23 19:20:02 pganguly noship $ */
3:
4:
5: procedure run_formula_or_jcp_xml is
50: where payroll_action_id = g_payroll_action_id;
51:
52: if SQL%NOTFOUND then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54: hr_utility.set_message_token('PROCEDURE','pay_ca_dd_magtape_pkg');
55: hr_utility.set_message_token('STEP','1');
56: hr_utility.raise_error;
57: end if;
58:
62: if g_legislative_parameters is not null then
63:
64: -- Get the MAGTAPE_REPORT_ID
65:
66: g_magtape_report_id := pay_ca_dd_magtape_pkg.get_parameter('MAGTAPE_REPORT_ID',g_legislative_parameters);
67:
68: hr_utility.trace('g_magtape_report_id = '||g_magtape_report_id);
69:
70: -- Get the File Creation Number Override
68: hr_utility.trace('g_magtape_report_id = '||g_magtape_report_id);
69:
70: -- Get the File Creation Number Override
71:
72: g_fcn_override := pay_ca_dd_magtape_pkg.get_parameter('FILE_CREATION_NUMBER_OVERRIDE',g_legislative_parameters);
73:
74: hr_utility.trace('g_fcn_override = '||g_fcn_override);
75:
76: -- Get the File Creation Date
74: hr_utility.trace('g_fcn_override = '||g_fcn_override);
75:
76: -- Get the File Creation Date
77:
78: g_file_creation_date := pay_ca_dd_magtape_pkg.get_parameter('FILE_CREATION_DATE',g_legislative_parameters);
79:
80: hr_utility.trace('g_file_creation_date = '||g_file_creation_date);
81:
82: end if;
151:
152:
153: if SQL%NOTFOUND then
154: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
155: hr_utility.set_message_token('PROCEDURE','pay_ca_dd_magtape_pkg');
156: hr_utility.set_message_token('STEP','1');
157: hr_utility.raise_error;
158: end if;
159:
198: hr_utility.trace('l_fcn:'||l_fcn);
199:
200: if l_fcn = '1.1' then
201: pay_core_utils.push_message(801,'PAY_74121_FILE_ALREADY_EXISTS','A');
202: pay_core_utils.push_token('package','pay_ca_dd_magtape_pkg.run_formula_or_jcp_xml');
203:
204: raise hr_utility.hr_error;
205:
206: elsif l_fcn = '1.2' then
216: hr_utility.trace('l_xslfile = '||l_xslfile);
217: hr_utility.trace('l_doctag = '||l_doctag);
218: hr_utility.trace('l_fcn = '||l_fcn);
219: hr_utility.trace('In newdd 6');
220: pay_ca_dd_magtape_pkg.submit_xml_mag_jcp(errbuff,
221: retcode,
222: g_payroll_action_id,
223: g_org_payment_method_id,
224: l_outdir,
483: return par_value;
484:
485: END get_parameter;
486:
487: end pay_ca_dd_magtape_pkg;