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

Line 29: /* hr_utility.trace_on('Y','TESTCADD'); */

25: from pay_org_payment_methods_f
26: where org_payment_method_id = cp_payment_method_id;
27:
28: Begin
29: /* hr_utility.trace_on('Y','TESTCADD'); */
30: p_formula_name := 'DUMMY_DD_FORMULA';
31: g_payroll_action_id := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3));
32: --g_payroll_action_id := 7193;
33: hr_utility.trace('g_payroll_action_id = '||to_char(g_payroll_action_id));

Line 33: hr_utility.trace('g_payroll_action_id = '||to_char(g_payroll_action_id));

29: /* hr_utility.trace_on('Y','TESTCADD'); */
30: p_formula_name := 'DUMMY_DD_FORMULA';
31: g_payroll_action_id := fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3));
32: --g_payroll_action_id := 7193;
33: hr_utility.trace('g_payroll_action_id = '||to_char(g_payroll_action_id));
34: --
35: -- Select all the relevent information using payroll action id
36: --
37: select business_group_id,

Line 53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

49: from pay_payroll_actions
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;

Line 54: hr_utility.set_message_token('PROCEDURE','pay_ca_dd_magtape_pkg');

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:

Line 55: hr_utility.set_message_token('STEP','1');

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:
59: hr_utility.trace('g_payroll_action_id = '||to_char(g_payroll_action_id));

Line 56: hr_utility.raise_error;

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:
59: hr_utility.trace('g_payroll_action_id = '||to_char(g_payroll_action_id));
60: hr_utility.trace('g_org_payment_method_id = '||to_char(g_org_payment_method_id));

Line 59: hr_utility.trace('g_payroll_action_id = '||to_char(g_payroll_action_id));

55: hr_utility.set_message_token('STEP','1');
56: hr_utility.raise_error;
57: end if;
58:
59: hr_utility.trace('g_payroll_action_id = '||to_char(g_payroll_action_id));
60: hr_utility.trace('g_org_payment_method_id = '||to_char(g_org_payment_method_id));
61: hr_utility.trace('g_request_id = '||g_request_id);
62: if g_legislative_parameters is not null then
63:

Line 60: hr_utility.trace('g_org_payment_method_id = '||to_char(g_org_payment_method_id));

56: hr_utility.raise_error;
57: end if;
58:
59: hr_utility.trace('g_payroll_action_id = '||to_char(g_payroll_action_id));
60: hr_utility.trace('g_org_payment_method_id = '||to_char(g_org_payment_method_id));
61: hr_utility.trace('g_request_id = '||g_request_id);
62: if g_legislative_parameters is not null then
63:
64: -- Get the MAGTAPE_REPORT_ID

Line 61: hr_utility.trace('g_request_id = '||g_request_id);

57: end if;
58:
59: hr_utility.trace('g_payroll_action_id = '||to_char(g_payroll_action_id));
60: hr_utility.trace('g_org_payment_method_id = '||to_char(g_org_payment_method_id));
61: hr_utility.trace('g_request_id = '||g_request_id);
62: if g_legislative_parameters is not null then
63:
64: -- Get the MAGTAPE_REPORT_ID
65:

Line 68: hr_utility.trace('g_magtape_report_id = '||g_magtape_report_id);

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
71:
72: g_fcn_override := pay_ca_dd_magtape_pkg.get_parameter('FILE_CREATION_NUMBER_OVERRIDE',g_legislative_parameters);

Line 74: hr_utility.trace('g_fcn_override = '||g_fcn_override);

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
77:
78: g_file_creation_date := pay_ca_dd_magtape_pkg.get_parameter('FILE_CREATION_DATE',g_legislative_parameters);

Line 80: hr_utility.trace('g_file_creation_date = '||g_file_creation_date);

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;
83:
84: /* Added for FCN Validation */

Line 94: /* hr_utility.trace_on('Y','MITA'); */

90: end if;
91:
92: /* End for FCN Validation */
93: /* Testing ---if g_magtape_report_id <> 'BMO' then --'RBC' then --'CIBC' then */
94: /* hr_utility.trace_on('Y','MITA'); */
95: if g_magtape_report_id not in ('CIBC','NOVA_SCOT','TD','CPA') then
96: begin
97: hr_utility.trace('In not CIBC');
98: pay_magtape_generic.new_formula;

Line 97: hr_utility.trace('In not CIBC');

93: /* Testing ---if g_magtape_report_id <> 'BMO' then --'RBC' then --'CIBC' then */
94: /* hr_utility.trace_on('Y','MITA'); */
95: if g_magtape_report_id not in ('CIBC','NOVA_SCOT','TD','CPA') then
96: begin
97: hr_utility.trace('In not CIBC');
98: pay_magtape_generic.new_formula;
99:
100: l_ff_formula_id := pay_mag_tape.internal_prm_values(2);
101:

Line 102: hr_utility.trace('Formula id is '||l_ff_formula_id);

98: pay_magtape_generic.new_formula;
99:
100: l_ff_formula_id := pay_mag_tape.internal_prm_values(2);
101:
102: hr_utility.trace('Formula id is '||l_ff_formula_id);
103: if l_ff_formula_id <> '0'
104: then
105: begin
106: select formula_name

Line 127: hr_utility.trace('In raise no_data_found 1');

123: 'RBC_MULTI_PAYMENTS','RBC_PAYMENT',
124: 'RBC_REPORT_TITLES', 'RBC_TRAILER' )
125: */
126: then
127: hr_utility.trace('In raise no_data_found 1');
128: raise no_data_found;
129: end if;
130: exception when no_data_found then
131: hr_utility.trace('In raise no_data_found 2');

Line 131: hr_utility.trace('In raise no_data_found 2');

127: hr_utility.trace('In raise no_data_found 1');
128: raise no_data_found;
129: end if;
130: exception when no_data_found then
131: hr_utility.trace('In raise no_data_found 2');
132: raise no_data_found;
133: end;
134: end if;
135: exception when others then

Line 154: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

150: and FORMULA_NAME = p_formula_name;
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;

Line 155: hr_utility.set_message_token('PROCEDURE','pay_ca_dd_magtape_pkg');

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:

Line 156: hr_utility.set_message_token('STEP','1');

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:
160:

Line 157: hr_utility.raise_error;

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:
160:
161: if g_magtape_report_id = 'CIBC' then

Line 198: hr_utility.trace('l_fcn:'||l_fcn);

194: l_fcn := pay_ca_direct_deposit_pkg.get_dd_file_creation_number
195: (g_org_payment_method_id,g_magtape_report_id,
196: null,g_payroll_action_id,g_business_group_id);
197: end if;
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');

Line 204: raise hr_utility.hr_error;

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
207: pay_core_utils.push_message(801,'PAY_74122_INVALID_FILE_NUMBER','A');
208: raise hr_utility.hr_error;

Line 208: raise hr_utility.hr_error;

204: raise hr_utility.hr_error;
205:
206: elsif l_fcn = '1.2' then
207: pay_core_utils.push_message(801,'PAY_74122_INVALID_FILE_NUMBER','A');
208: raise hr_utility.hr_error;
209:
210: end if;
211: /* New FCN validation for XML formats ends here */
212:

Line 213: hr_utility.trace('l_outdir = '||l_outdir);

209:
210: end if;
211: /* New FCN validation for XML formats ends here */
212:
213: hr_utility.trace('l_outdir = '||l_outdir);
214: hr_utility.trace('l_outfile = '||l_outfile);
215: hr_utility.trace('l_logfile = '||l_logfile);
216: hr_utility.trace('l_xslfile = '||l_xslfile);
217: hr_utility.trace('l_doctag = '||l_doctag);

Line 214: hr_utility.trace('l_outfile = '||l_outfile);

210: end if;
211: /* New FCN validation for XML formats ends here */
212:
213: hr_utility.trace('l_outdir = '||l_outdir);
214: hr_utility.trace('l_outfile = '||l_outfile);
215: hr_utility.trace('l_logfile = '||l_logfile);
216: hr_utility.trace('l_xslfile = '||l_xslfile);
217: hr_utility.trace('l_doctag = '||l_doctag);
218: hr_utility.trace('l_fcn = '||l_fcn);

Line 215: hr_utility.trace('l_logfile = '||l_logfile);

211: /* New FCN validation for XML formats ends here */
212:
213: hr_utility.trace('l_outdir = '||l_outdir);
214: hr_utility.trace('l_outfile = '||l_outfile);
215: hr_utility.trace('l_logfile = '||l_logfile);
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');

Line 216: hr_utility.trace('l_xslfile = '||l_xslfile);

212:
213: hr_utility.trace('l_outdir = '||l_outdir);
214: hr_utility.trace('l_outfile = '||l_outfile);
215: hr_utility.trace('l_logfile = '||l_logfile);
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,

Line 217: hr_utility.trace('l_doctag = '||l_doctag);

213: hr_utility.trace('l_outdir = '||l_outdir);
214: hr_utility.trace('l_outfile = '||l_outfile);
215: hr_utility.trace('l_logfile = '||l_logfile);
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,

Line 218: hr_utility.trace('l_fcn = '||l_fcn);

214: hr_utility.trace('l_outfile = '||l_outfile);
215: hr_utility.trace('l_logfile = '||l_logfile);
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,

Line 219: hr_utility.trace('In newdd 6');

215: hr_utility.trace('l_logfile = '||l_logfile);
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,

Line 238: hr_utility.trace('TRUE ' );

234: pay_mag_tape.internal_prm_values(1) := '2';
235: pay_mag_tape.internal_prm_values(2) := p_ff_formula_id;
236:
237: if l_success then
238: hr_utility.trace('TRUE ' );
239: else
240: hr_utility.trace('FALSE ' );
241: end if;
242: hr_utility.trace('retcode = '||to_char(retcode));

Line 240: hr_utility.trace('FALSE ' );

236:
237: if l_success then
238: hr_utility.trace('TRUE ' );
239: else
240: hr_utility.trace('FALSE ' );
241: end if;
242: hr_utility.trace('retcode = '||to_char(retcode));
243: hr_utility.trace('errbuff = '||errbuff );
244: hr_utility.trace('In newdd 7');

Line 242: hr_utility.trace('retcode = '||to_char(retcode));

238: hr_utility.trace('TRUE ' );
239: else
240: hr_utility.trace('FALSE ' );
241: end if;
242: hr_utility.trace('retcode = '||to_char(retcode));
243: hr_utility.trace('errbuff = '||errbuff );
244: hr_utility.trace('In newdd 7');
245: if retcode = 2 then
246: raise java_conc_error;

Line 243: hr_utility.trace('errbuff = '||errbuff );

239: else
240: hr_utility.trace('FALSE ' );
241: end if;
242: hr_utility.trace('retcode = '||to_char(retcode));
243: hr_utility.trace('errbuff = '||errbuff );
244: hr_utility.trace('In newdd 7');
245: if retcode = 2 then
246: raise java_conc_error;
247: end if;

Line 244: hr_utility.trace('In newdd 7');

240: hr_utility.trace('FALSE ' );
241: end if;
242: hr_utility.trace('retcode = '||to_char(retcode));
243: hr_utility.trace('errbuff = '||errbuff );
244: hr_utility.trace('In newdd 7');
245: if retcode = 2 then
246: raise java_conc_error;
247: end if;
248: exception

Line 260: hr_utility.trace('Formula id is '||l_ff_formula_id);

256: raise no_data_found;
257: else
258: l_ff_formula_id := pay_mag_tape.internal_prm_values(2);
259:
260: hr_utility.trace('Formula id is '||l_ff_formula_id);
261: begin
262: select formula_name
263: INTO l_ff_formula_name
264: from FF_FORMULAS_F

Line 280: hr_utility.trace('In raise no_data_found 1');

276: 'BMO_TRAILER', 'RBC_HEADER' ,
277: 'RBC_MULTI_PAYMENTS','RBC_PAYMENT',
278: 'RBC_REPORT_TITLES', 'RBC_TRAILER' )
279: then
280: hr_utility.trace('In raise no_data_found 1');
281: select TO_CHAR(FORMULA_ID)
282: INTO p_ff_formula_id
283: from FF_FORMULAS_F
284: where g_effective_date between EFFECTIVE_START_DATE and

Line 292: -- hr_utility.trace_off;

288: raise no_data_found;
289: end if;
290: end;
291: end if;
292: -- hr_utility.trace_off;
293:
294: End run_formula_or_jcp_xml;
295:
296: procedure submit_xml_mag_jcp(

Line 338: hr_utility.trace('Before Concurrent Request');

334:
335: -- initialise variables - 0 is SRS Success, 1 is SRS Warning, 2 is SRS Error
336: retcode := 0;
337:
338: hr_utility.trace('Before Concurrent Request');
339:
340: -- req_id:=fnd_profile.value('CONC_REQUEST_ID');
341:
342: /*

Line 347: hr_utility.trace('payroll_action_id = '||to_char(P_PACTID));

343: l_req_id := fnd_request.submit_request(application => 'PAY',
344: program => 'JATINJCP',
345: argument1 => 'PER');
346: */
347: hr_utility.trace('payroll_action_id = '||to_char(P_PACTID));
348: hr_utility.trace('org_payment_method_id = '||to_char(P_PMETHID));
349: hr_utility.trace('P_OUTDIR = '||P_OUTDIR);
350: hr_utility.trace('P_OUTFILE = '||P_OUTFILE);
351: hr_utility.trace('P_LOGFILE = '||P_LOGFILE);

Line 348: hr_utility.trace('org_payment_method_id = '||to_char(P_PMETHID));

344: program => 'JATINJCP',
345: argument1 => 'PER');
346: */
347: hr_utility.trace('payroll_action_id = '||to_char(P_PACTID));
348: hr_utility.trace('org_payment_method_id = '||to_char(P_PMETHID));
349: hr_utility.trace('P_OUTDIR = '||P_OUTDIR);
350: hr_utility.trace('P_OUTFILE = '||P_OUTFILE);
351: hr_utility.trace('P_LOGFILE = '||P_LOGFILE);
352: hr_utility.trace('P_REQUEST_ID = '||P_REQUEST_ID);

Line 349: hr_utility.trace('P_OUTDIR = '||P_OUTDIR);

345: argument1 => 'PER');
346: */
347: hr_utility.trace('payroll_action_id = '||to_char(P_PACTID));
348: hr_utility.trace('org_payment_method_id = '||to_char(P_PMETHID));
349: hr_utility.trace('P_OUTDIR = '||P_OUTDIR);
350: hr_utility.trace('P_OUTFILE = '||P_OUTFILE);
351: hr_utility.trace('P_LOGFILE = '||P_LOGFILE);
352: hr_utility.trace('P_REQUEST_ID = '||P_REQUEST_ID);
353: hr_utility.trace('P_XSLFILE = '||P_XSLFILE);

Line 350: hr_utility.trace('P_OUTFILE = '||P_OUTFILE);

346: */
347: hr_utility.trace('payroll_action_id = '||to_char(P_PACTID));
348: hr_utility.trace('org_payment_method_id = '||to_char(P_PMETHID));
349: hr_utility.trace('P_OUTDIR = '||P_OUTDIR);
350: hr_utility.trace('P_OUTFILE = '||P_OUTFILE);
351: hr_utility.trace('P_LOGFILE = '||P_LOGFILE);
352: hr_utility.trace('P_REQUEST_ID = '||P_REQUEST_ID);
353: hr_utility.trace('P_XSLFILE = '||P_XSLFILE);
354: hr_utility.trace('P_DOCTAG = '||P_DOCTAG);

Line 351: hr_utility.trace('P_LOGFILE = '||P_LOGFILE);

347: hr_utility.trace('payroll_action_id = '||to_char(P_PACTID));
348: hr_utility.trace('org_payment_method_id = '||to_char(P_PMETHID));
349: hr_utility.trace('P_OUTDIR = '||P_OUTDIR);
350: hr_utility.trace('P_OUTFILE = '||P_OUTFILE);
351: hr_utility.trace('P_LOGFILE = '||P_LOGFILE);
352: hr_utility.trace('P_REQUEST_ID = '||P_REQUEST_ID);
353: hr_utility.trace('P_XSLFILE = '||P_XSLFILE);
354: hr_utility.trace('P_DOCTAG = '||P_DOCTAG);
355: hr_utility.trace('P_FCN = '||P_FCN);

Line 352: hr_utility.trace('P_REQUEST_ID = '||P_REQUEST_ID);

348: hr_utility.trace('org_payment_method_id = '||to_char(P_PMETHID));
349: hr_utility.trace('P_OUTDIR = '||P_OUTDIR);
350: hr_utility.trace('P_OUTFILE = '||P_OUTFILE);
351: hr_utility.trace('P_LOGFILE = '||P_LOGFILE);
352: hr_utility.trace('P_REQUEST_ID = '||P_REQUEST_ID);
353: hr_utility.trace('P_XSLFILE = '||P_XSLFILE);
354: hr_utility.trace('P_DOCTAG = '||P_DOCTAG);
355: hr_utility.trace('P_FCN = '||P_FCN);
356:

Line 353: hr_utility.trace('P_XSLFILE = '||P_XSLFILE);

349: hr_utility.trace('P_OUTDIR = '||P_OUTDIR);
350: hr_utility.trace('P_OUTFILE = '||P_OUTFILE);
351: hr_utility.trace('P_LOGFILE = '||P_LOGFILE);
352: hr_utility.trace('P_REQUEST_ID = '||P_REQUEST_ID);
353: hr_utility.trace('P_XSLFILE = '||P_XSLFILE);
354: hr_utility.trace('P_DOCTAG = '||P_DOCTAG);
355: hr_utility.trace('P_FCN = '||P_FCN);
356:
357: l_req_id := fnd_request.submit_request(application => 'PAY',

Line 354: hr_utility.trace('P_DOCTAG = '||P_DOCTAG);

350: hr_utility.trace('P_OUTFILE = '||P_OUTFILE);
351: hr_utility.trace('P_LOGFILE = '||P_LOGFILE);
352: hr_utility.trace('P_REQUEST_ID = '||P_REQUEST_ID);
353: hr_utility.trace('P_XSLFILE = '||P_XSLFILE);
354: hr_utility.trace('P_DOCTAG = '||P_DOCTAG);
355: hr_utility.trace('P_FCN = '||P_FCN);
356:
357: l_req_id := fnd_request.submit_request(application => 'PAY',
358: program => 'PYCADDMG',

Line 355: hr_utility.trace('P_FCN = '||P_FCN);

351: hr_utility.trace('P_LOGFILE = '||P_LOGFILE);
352: hr_utility.trace('P_REQUEST_ID = '||P_REQUEST_ID);
353: hr_utility.trace('P_XSLFILE = '||P_XSLFILE);
354: hr_utility.trace('P_DOCTAG = '||P_DOCTAG);
355: hr_utility.trace('P_FCN = '||P_FCN);
356:
357: l_req_id := fnd_request.submit_request(application => 'PAY',
358: program => 'PYCADDMG',
359: argument1 => 'PAY',

Line 374: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);

370:
371: IF(l_req_id = 0) THEN
372: p_success := FALSE;
373: fnd_message.retrieve(l_errbuf);
374: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
375: -- hr_utility.raise_error;
376: raise zero_req_id;
377: ELSE
378: hr_utility.trace(' Concurrent Request Id : ' ||to_char(l_req_id));

Line 375: -- hr_utility.raise_error;

371: IF(l_req_id = 0) THEN
372: p_success := FALSE;
373: fnd_message.retrieve(l_errbuf);
374: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
375: -- hr_utility.raise_error;
376: raise zero_req_id;
377: ELSE
378: hr_utility.trace(' Concurrent Request Id : ' ||to_char(l_req_id));
379:

Line 378: hr_utility.trace(' Concurrent Request Id : ' ||to_char(l_req_id));

374: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
375: -- hr_utility.raise_error;
376: raise zero_req_id;
377: ELSE
378: hr_utility.trace(' Concurrent Request Id : ' ||to_char(l_req_id));
379:
380: COMMIT;
381:
382: /* Wait for report request completion */

Line 383: hr_utility.trace('Waiting for the application to get completed ');

379:
380: COMMIT;
381:
382: /* Wait for report request completion */
383: hr_utility.trace('Waiting for the application to get completed ');
384:
385: /* Check for Report Request Status */
386:
387: l6_wait := fnd_concurrent.wait_for_request

Line 397: hr_utility.trace('Wait completed');

393: ,dev_status => l6_dev_status
394: ,message => l6_message);
395:
396: p_success := TRUE;
397: hr_utility.trace('Wait completed');
398:
399: hr_utility.trace('phase :'||l6_phase);
400: hr_utility.trace('status :'||l6_status);
401: hr_utility.trace('dev_phase :'||l6_dev_phase);

Line 399: hr_utility.trace('phase :'||l6_phase);

395:
396: p_success := TRUE;
397: hr_utility.trace('Wait completed');
398:
399: hr_utility.trace('phase :'||l6_phase);
400: hr_utility.trace('status :'||l6_status);
401: hr_utility.trace('dev_phase :'||l6_dev_phase);
402: hr_utility.trace('dev_status :'||l6_dev_status);
403: hr_utility.trace('message :'||l6_message);

Line 400: hr_utility.trace('status :'||l6_status);

396: p_success := TRUE;
397: hr_utility.trace('Wait completed');
398:
399: hr_utility.trace('phase :'||l6_phase);
400: hr_utility.trace('status :'||l6_status);
401: hr_utility.trace('dev_phase :'||l6_dev_phase);
402: hr_utility.trace('dev_status :'||l6_dev_status);
403: hr_utility.trace('message :'||l6_message);
404:

Line 401: hr_utility.trace('dev_phase :'||l6_dev_phase);

397: hr_utility.trace('Wait completed');
398:
399: hr_utility.trace('phase :'||l6_phase);
400: hr_utility.trace('status :'||l6_status);
401: hr_utility.trace('dev_phase :'||l6_dev_phase);
402: hr_utility.trace('dev_status :'||l6_dev_status);
403: hr_utility.trace('message :'||l6_message);
404:
405: END IF; /* if l_req_id */

Line 402: hr_utility.trace('dev_status :'||l6_dev_status);

398:
399: hr_utility.trace('phase :'||l6_phase);
400: hr_utility.trace('status :'||l6_status);
401: hr_utility.trace('dev_phase :'||l6_dev_phase);
402: hr_utility.trace('dev_status :'||l6_dev_status);
403: hr_utility.trace('message :'||l6_message);
404:
405: END IF; /* if l_req_id */
406:

Line 403: hr_utility.trace('message :'||l6_message);

399: hr_utility.trace('phase :'||l6_phase);
400: hr_utility.trace('status :'||l6_status);
401: hr_utility.trace('dev_phase :'||l6_dev_phase);
402: hr_utility.trace('dev_status :'||l6_dev_status);
403: hr_utility.trace('message :'||l6_message);
404:
405: END IF; /* if l_req_id */
406:
407: IF NOT (l6_dev_phase = 'COMPLETE' and l6_dev_status = 'NORMAL') THEN

Line 408: hr_utility.trace(' Exited with error ');

404:
405: END IF; /* if l_req_id */
406:
407: IF NOT (l6_dev_phase = 'COMPLETE' and l6_dev_status = 'NORMAL') THEN
408: hr_utility.trace(' Exited with error ');
409: if l6_dev_status = 'WARNING' then
410: retcode := 1;
411: else
412: retcode := 2;

Line 416: hr_utility.trace(' Request completed successfully') ;

412: retcode := 2;
413: end if;
414:
415: ELSE
416: hr_utility.trace(' Request completed successfully') ;
417: hr_utility.trace('Successful');
418: END IF; /* l6_dev_phase */
419:
420: -- Set up error message and error return code.

Line 417: hr_utility.trace('Successful');

413: end if;
414:
415: ELSE
416: hr_utility.trace(' Request completed successfully') ;
417: hr_utility.trace('Successful');
418: END IF; /* l6_dev_phase */
419:
420: -- Set up error message and error return code.
421: --

Line 422: errbuf := hr_utility.get_message;

418: END IF; /* l6_dev_phase */
419:
420: -- Set up error message and error return code.
421: --
422: errbuf := hr_utility.get_message;
423:
424:
425: EXCEPTION
426: when zero_req_id then

Line 430: hr_utility.trace('Exception : No data Found');

426: when zero_req_id then
427: raise;
428:
429: WHEN NO_DATA_FOUND THEN
430: hr_utility.trace('Exception : No data Found');
431: p_success := FALSE;
432: l_errbuf := SQLERRM;
433: errbuf := l_errbuf;
434: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);

Line 434: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);

430: hr_utility.trace('Exception : No data Found');
431: p_success := FALSE;
432: l_errbuf := SQLERRM;
433: errbuf := l_errbuf;
434: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
435: --
436: -- Set up error message and error return code.
437: --
438:

Line 439: errbuf := hr_utility.get_message;

435: --
436: -- Set up error message and error return code.
437: --
438:
439: errbuf := hr_utility.get_message;
440: WHEN OTHERS THEN
441: hr_utility.trace('Exception : When Others');
442: p_success := FALSE;
443: l_errbuf := SQLERRM;

Line 441: hr_utility.trace('Exception : When Others');

437: --
438:
439: errbuf := hr_utility.get_message;
440: WHEN OTHERS THEN
441: hr_utility.trace('Exception : When Others');
442: p_success := FALSE;
443: l_errbuf := SQLERRM;
444: errbuf := l_errbuf;
445: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);

Line 445: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);

441: hr_utility.trace('Exception : When Others');
442: p_success := FALSE;
443: l_errbuf := SQLERRM;
444: errbuf := l_errbuf;
445: hr_utility.trace('Error when submitting request: ' || SQLERRM || ' ' || SQLCODE);
446:
447: --
448: END;
449:

Line 450: hr_utility.trace('RETCODE : '|| to_char(retcode) ||'ERRBUF: '||errbuf);

446:
447: --
448: END;
449:
450: hr_utility.trace('RETCODE : '|| to_char(retcode) ||'ERRBUF: '||errbuf);
451: --
452: --
453:
454: END submit_xml_mag_jcp;