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

Line 33: hr_utility.trace.

29: 30/07/96 J.Alloun Added error handling.
30: 05/08/96 aswong Added exit at the end.
31: 07/10/99 P Davies Changed each occurrence of
32: DBMS_Output.Put_Line with
33: hr_utility.trace.
34: */
35:
36:
37: PROCEDURE eoy_control( ERRBUF OUT VARCHAR2

Line 83: hr_utility.trace('Start EOY_CONTROL in PAYEYCTL.pkb');

79: PROG_SUCCESS CONSTANT NUMBER := 0 ;
80: --
81: BEGIN
82:
83: hr_utility.trace('Start EOY_CONTROL in PAYEYCTL.pkb');
84: l_session_date := TRUNC(SYSDATE);
85: l_session_char := TO_CHAR(TRUNC(SYSDATE),'DD-MON-YYYY');
86: l_request_id := fnd_profile.value('CONC_REQUEST_ID');
87: ------------------------------

Line 90: hr_utility.trace('Start EXTRACT PROCESS');

86: l_request_id := fnd_profile.value('CONC_REQUEST_ID');
87: ------------------------------
88: -- Call EOY EXTRACT PROCESS --
89: ------------------------------
90: hr_utility.trace('Start EXTRACT PROCESS');
91: pay_year_end_extract.extract(
92: p_permit_no,
93: p_business_group_id,
94: p_tax_dist_ref,

Line 101: hr_utility.trace('Finished EXTRACT PROCESS');

97: p_ni_y_flag,
98: l_retcode,
99: l_errbuf);
100: --
101: hr_utility.trace('Finished EXTRACT PROCESS');
102: hr_utility.trace('');
103: --
104: IF l_retcode = 0 THEN
105: errbuf := l_errbuf;

Line 102: hr_utility.trace('');

98: l_retcode,
99: l_errbuf);
100: --
101: hr_utility.trace('Finished EXTRACT PROCESS');
102: hr_utility.trace('');
103: --
104: IF l_retcode = 0 THEN
105: errbuf := l_errbuf;
106: hr_utility.trace('EXTRACT returned failure message: see '||l_errbuf);

Line 106: hr_utility.trace('EXTRACT returned failure message: see '||l_errbuf);

102: hr_utility.trace('');
103: --
104: IF l_retcode = 0 THEN
105: errbuf := l_errbuf;
106: hr_utility.trace('EXTRACT returned failure message: see '||l_errbuf);
107: retcode := PROG_FAILURE ;
108: hr_utility.raise_error;
109: return;
110: END IF;

Line 108: hr_utility.raise_error;

104: IF l_retcode = 0 THEN
105: errbuf := l_errbuf;
106: hr_utility.trace('EXTRACT returned failure message: see '||l_errbuf);
107: retcode := PROG_FAILURE ;
108: hr_utility.raise_error;
109: return;
110: END IF;
111: -------------------------------------
112: -- Call MULTIPLE ASSIGNMENT REPORT --

Line 114: hr_utility.trace('');

110: END IF;
111: -------------------------------------
112: -- Call MULTIPLE ASSIGNMENT REPORT --
113: -------------------------------------
114: hr_utility.trace('');
115: hr_utility.trace('Start MULTIPLE ASSIGNMENT REPORT');
116: l_ass_id := fnd_request.submit_request(
117: application => 'PAY',
118: program => 'PAYYEMAR',

Line 115: hr_utility.trace('Start MULTIPLE ASSIGNMENT REPORT');

111: -------------------------------------
112: -- Call MULTIPLE ASSIGNMENT REPORT --
113: -------------------------------------
114: hr_utility.trace('');
115: hr_utility.trace('Start MULTIPLE ASSIGNMENT REPORT');
116: l_ass_id := fnd_request.submit_request(
117: application => 'PAY',
118: program => 'PAYYEMAR',
119: argument1 => l_request_id);

Line 123: hr_utility.trace('MULTIPLE ASSIGNMENT REPORT returned failure message: see ' || l_file_name);

119: argument1 => l_request_id);
120: l_file_name := 'l' || TO_CHAR(l_ass_id) || '.req';
121: IF l_ass_id = 0 THEN
122: errbuf := 'Error calling the multiple assignments report ';
123: hr_utility.trace('MULTIPLE ASSIGNMENT REPORT returned failure message: see ' || l_file_name);
124: retcode := PROG_FAILURE ;
125: hr_utility.raise_error;
126: return ;
127: END IF;

Line 125: hr_utility.raise_error;

121: IF l_ass_id = 0 THEN
122: errbuf := 'Error calling the multiple assignments report ';
123: hr_utility.trace('MULTIPLE ASSIGNMENT REPORT returned failure message: see ' || l_file_name);
124: retcode := PROG_FAILURE ;
125: hr_utility.raise_error;
126: return ;
127: END IF;
128: -- Now commit request
129: COMMIT;

Line 130: hr_utility.trace(' Submitted Req id: ' || TO_CHAR(l_ass_id) );

126: return ;
127: END IF;
128: -- Now commit request
129: COMMIT;
130: hr_utility.trace(' Submitted Req id: ' || TO_CHAR(l_ass_id) );
131: l_wait_outcome := fnd_concurrent.wait_for_request(
132: request_id => l_ass_id,
133: interval => 5,
134: phase => l_phase,

Line 140: hr_utility.trace(' Status : '||l_dev_status);

136: dev_phase => l_dev_phase,
137: dev_status => l_dev_status,
138: message => l_message);
139:
140: hr_utility.trace(' Status : '||l_dev_status);
141: hr_utility.trace(' Phase : '||l_dev_phase);
142: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
143: errbuf := 'Error in the multiple assignments report ';
144: hr_utility.trace('MULTIPLE ASSIGNMENT REPORT returned failure message: see ' || l_file_name);

Line 141: hr_utility.trace(' Phase : '||l_dev_phase);

137: dev_status => l_dev_status,
138: message => l_message);
139:
140: hr_utility.trace(' Status : '||l_dev_status);
141: hr_utility.trace(' Phase : '||l_dev_phase);
142: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
143: errbuf := 'Error in the multiple assignments report ';
144: hr_utility.trace('MULTIPLE ASSIGNMENT REPORT returned failure message: see ' || l_file_name);
145: retcode := PROG_FAILURE ;

Line 144: hr_utility.trace('MULTIPLE ASSIGNMENT REPORT returned failure message: see ' || l_file_name);

140: hr_utility.trace(' Status : '||l_dev_status);
141: hr_utility.trace(' Phase : '||l_dev_phase);
142: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
143: errbuf := 'Error in the multiple assignments report ';
144: hr_utility.trace('MULTIPLE ASSIGNMENT REPORT returned failure message: see ' || l_file_name);
145: retcode := PROG_FAILURE ;
146: hr_utility.raise_error;
147: return;
148: END IF;

Line 146: hr_utility.raise_error;

142: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
143: errbuf := 'Error in the multiple assignments report ';
144: hr_utility.trace('MULTIPLE ASSIGNMENT REPORT returned failure message: see ' || l_file_name);
145: retcode := PROG_FAILURE ;
146: hr_utility.raise_error;
147: return;
148: END IF;
149: hr_utility.trace('Finished MULTIPLE ASSIGNMENT REPORT');
150: ---------------------------

Line 149: hr_utility.trace('Finished MULTIPLE ASSIGNMENT REPORT');

145: retcode := PROG_FAILURE ;
146: hr_utility.raise_error;
147: return;
148: END IF;
149: hr_utility.trace('Finished MULTIPLE ASSIGNMENT REPORT');
150: ---------------------------
151: -- Call MAG TAPE PROCESS --
152: ---------------------------
153: hr_utility.trace('');

Line 153: hr_utility.trace('');

149: hr_utility.trace('Finished MULTIPLE ASSIGNMENT REPORT');
150: ---------------------------
151: -- Call MAG TAPE PROCESS --
152: ---------------------------
153: hr_utility.trace('');
154: hr_utility.trace('Start MAG TAPE PROCESS');
155: l_mag_id := fnd_request.submit_request(
156: application => 'PAY',
157: program => 'PYUMAG',

Line 154: hr_utility.trace('Start MAG TAPE PROCESS');

150: ---------------------------
151: -- Call MAG TAPE PROCESS --
152: ---------------------------
153: hr_utility.trace('');
154: hr_utility.trace('Start MAG TAPE PROCESS');
155: l_mag_id := fnd_request.submit_request(
156: application => 'PAY',
157: program => 'PYUMAG',
158: argument1 => 'pay_gb_eoy.eoy',

Line 172: hr_utility.trace('MAG TAPE PROCESS returned failure message: see ' || l_file_name);

168:
169: l_file_name := 'l' || TO_CHAR(l_mag_id) || '.req';
170: IF l_mag_id = 0 THEN
171: errbuf := 'Error calling the mag tape process';
172: hr_utility.trace('MAG TAPE PROCESS returned failure message: see ' || l_file_name);
173: retcode := PROG_FAILURE ;
174: hr_utility.raise_error;
175: return ;
176: END IF;

Line 174: hr_utility.raise_error;

170: IF l_mag_id = 0 THEN
171: errbuf := 'Error calling the mag tape process';
172: hr_utility.trace('MAG TAPE PROCESS returned failure message: see ' || l_file_name);
173: retcode := PROG_FAILURE ;
174: hr_utility.raise_error;
175: return ;
176: END IF;
177: COMMIT;
178: hr_utility.trace(' Submitted Req id: ' || TO_CHAR(l_mag_id) );

Line 178: hr_utility.trace(' Submitted Req id: ' || TO_CHAR(l_mag_id) );

174: hr_utility.raise_error;
175: return ;
176: END IF;
177: COMMIT;
178: hr_utility.trace(' Submitted Req id: ' || TO_CHAR(l_mag_id) );
179: l_wait_outcome := fnd_concurrent.wait_for_request(
180: request_id => l_mag_id,
181: interval => 5,
182: phase => l_phase,

Line 188: hr_utility.trace(' Status : '||l_dev_status);

184: dev_phase => l_dev_phase,
185: dev_status => l_dev_status,
186: message => l_message);
187:
188: hr_utility.trace(' Status : '||l_dev_status);
189: hr_utility.trace(' Phase : '||l_dev_phase);
190: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
191: errbuf := 'Error in the mag tape process';
192: hr_utility.trace('MAG TAPE PROCESS returned failure message: see ' || l_file_name);

Line 189: hr_utility.trace(' Phase : '||l_dev_phase);

185: dev_status => l_dev_status,
186: message => l_message);
187:
188: hr_utility.trace(' Status : '||l_dev_status);
189: hr_utility.trace(' Phase : '||l_dev_phase);
190: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
191: errbuf := 'Error in the mag tape process';
192: hr_utility.trace('MAG TAPE PROCESS returned failure message: see ' || l_file_name);
193: retcode := PROG_FAILURE ;

Line 192: hr_utility.trace('MAG TAPE PROCESS returned failure message: see ' || l_file_name);

188: hr_utility.trace(' Status : '||l_dev_status);
189: hr_utility.trace(' Phase : '||l_dev_phase);
190: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
191: errbuf := 'Error in the mag tape process';
192: hr_utility.trace('MAG TAPE PROCESS returned failure message: see ' || l_file_name);
193: retcode := PROG_FAILURE ;
194: hr_utility.raise_error;
195: return;
196: END IF;

Line 194: hr_utility.raise_error;

190: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
191: errbuf := 'Error in the mag tape process';
192: hr_utility.trace('MAG TAPE PROCESS returned failure message: see ' || l_file_name);
193: retcode := PROG_FAILURE ;
194: hr_utility.raise_error;
195: return;
196: END IF;
197: hr_utility.trace('Finished MAG TAPE PROCESS');
198: ----------------------

Line 197: hr_utility.trace('Finished MAG TAPE PROCESS');

193: retcode := PROG_FAILURE ;
194: hr_utility.raise_error;
195: return;
196: END IF;
197: hr_utility.trace('Finished MAG TAPE PROCESS');
198: ----------------------
199: -- Call P35 PROCESS --
200: ----------------------
201: hr_utility.trace('');

Line 201: hr_utility.trace('');

197: hr_utility.trace('Finished MAG TAPE PROCESS');
198: ----------------------
199: -- Call P35 PROCESS --
200: ----------------------
201: hr_utility.trace('');
202: hr_utility.trace('Start P35 REPORT');
203: l_p35_id := fnd_request.submit_request(
204: application => 'PAY',
205: program => 'PAYRPP35',

Line 202: hr_utility.trace('Start P35 REPORT');

198: ----------------------
199: -- Call P35 PROCESS --
200: ----------------------
201: hr_utility.trace('');
202: hr_utility.trace('Start P35 REPORT');
203: l_p35_id := fnd_request.submit_request(
204: application => 'PAY',
205: program => 'PAYRPP35',
206: argument1 => l_mag_id,

Line 214: hr_utility.trace('P35 REPORT returned failure message: see ' || l_file_name);

210: -- Check the result of the p35 call
211: l_file_name := 'l' || TO_CHAR(l_p35_id) || '.req';
212: IF l_p35_id = 0 THEN
213: errbuf := 'Error calling the P35 report';
214: hr_utility.trace('P35 REPORT returned failure message: see ' || l_file_name);
215: retcode := PROG_FAILURE ;
216: hr_utility.raise_error;
217: return ;
218: END IF;

Line 216: hr_utility.raise_error;

212: IF l_p35_id = 0 THEN
213: errbuf := 'Error calling the P35 report';
214: hr_utility.trace('P35 REPORT returned failure message: see ' || l_file_name);
215: retcode := PROG_FAILURE ;
216: hr_utility.raise_error;
217: return ;
218: END IF;
219: COMMIT;
220: hr_utility.trace(' Submitted Req id: ' || TO_CHAR(l_p35_id) );

Line 220: hr_utility.trace(' Submitted Req id: ' || TO_CHAR(l_p35_id) );

216: hr_utility.raise_error;
217: return ;
218: END IF;
219: COMMIT;
220: hr_utility.trace(' Submitted Req id: ' || TO_CHAR(l_p35_id) );
221: l_wait_outcome := fnd_concurrent.wait_for_request(
222: request_id => l_p35_id,
223: phase => l_phase,
224: status => l_status,

Line 228: hr_utility.trace(' Status : '||l_dev_status);

224: status => l_status,
225: dev_phase => l_dev_phase,
226: dev_status => l_dev_status,
227: message => l_message);
228: hr_utility.trace(' Status : '||l_dev_status);
229: hr_utility.trace(' Phase : '||l_dev_phase);
230: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
231: errbuf := 'Error in the P35 report';
232: hr_utility.trace('P35 REPORT returned failure message: see ' || l_file_name);

Line 229: hr_utility.trace(' Phase : '||l_dev_phase);

225: dev_phase => l_dev_phase,
226: dev_status => l_dev_status,
227: message => l_message);
228: hr_utility.trace(' Status : '||l_dev_status);
229: hr_utility.trace(' Phase : '||l_dev_phase);
230: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
231: errbuf := 'Error in the P35 report';
232: hr_utility.trace('P35 REPORT returned failure message: see ' || l_file_name);
233: retcode := PROG_FAILURE ;

Line 232: hr_utility.trace('P35 REPORT returned failure message: see ' || l_file_name);

228: hr_utility.trace(' Status : '||l_dev_status);
229: hr_utility.trace(' Phase : '||l_dev_phase);
230: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
231: errbuf := 'Error in the P35 report';
232: hr_utility.trace('P35 REPORT returned failure message: see ' || l_file_name);
233: retcode := PROG_FAILURE ;
234: hr_utility.raise_error;
235: return;
236: END IF;

Line 234: hr_utility.raise_error;

230: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
231: errbuf := 'Error in the P35 report';
232: hr_utility.trace('P35 REPORT returned failure message: see ' || l_file_name);
233: retcode := PROG_FAILURE ;
234: hr_utility.raise_error;
235: return;
236: END IF;
237: hr_utility.trace('Finished P35 REPORT');
238: ----------------------

Line 237: hr_utility.trace('Finished P35 REPORT');

233: retcode := PROG_FAILURE ;
234: hr_utility.raise_error;
235: return;
236: END IF;
237: hr_utility.trace('Finished P35 REPORT');
238: ----------------------
239: -- Call P60 PROCESS --
240: ----------------------
241: IF p_eoy_mode = 'F' THEN

Line 242: hr_utility.trace('');

238: ----------------------
239: -- Call P60 PROCESS --
240: ----------------------
241: IF p_eoy_mode = 'F' THEN
242: hr_utility.trace('');
243: hr_utility.trace('Start P60 REPORT');
244: IF UPPER(NVL(p_align,'N')) = 'Y' THEN
245: l_p60_id := fnd_request.submit_request(
246: application => 'PAY',

Line 243: hr_utility.trace('Start P60 REPORT');

239: -- Call P60 PROCESS --
240: ----------------------
241: IF p_eoy_mode = 'F' THEN
242: hr_utility.trace('');
243: hr_utility.trace('Start P60 REPORT');
244: IF UPPER(NVL(p_align,'N')) = 'Y' THEN
245: l_p60_id := fnd_request.submit_request(
246: application => 'PAY',
247: program => 'PAYRPP60',

Line 263: hr_utility.trace('P60 REPORT returned failure message: see ' || l_file_name);

259: argument12 => p_tax_dist_ref);
260: l_file_name := 'l' || TO_CHAR(l_p60_id) || '.req';
261: IF l_p60_id = 0 THEN
262: errbuf := 'Error calling the P60 report';
263: hr_utility.trace('P60 REPORT returned failure message: see ' || l_file_name);
264: retcode := PROG_FAILURE ;
265: hr_utility.raise_error;
266: return ;
267: END IF;

Line 265: hr_utility.raise_error;

261: IF l_p60_id = 0 THEN
262: errbuf := 'Error calling the P60 report';
263: hr_utility.trace('P60 REPORT returned failure message: see ' || l_file_name);
264: retcode := PROG_FAILURE ;
265: hr_utility.raise_error;
266: return ;
267: END IF;
268: COMMIT;
269: hr_utility.trace(' Submitted Req id: ' || TO_CHAR(l_p60_id) );

Line 269: hr_utility.trace(' Submitted Req id: ' || TO_CHAR(l_p60_id) );

265: hr_utility.raise_error;
266: return ;
267: END IF;
268: COMMIT;
269: hr_utility.trace(' Submitted Req id: ' || TO_CHAR(l_p60_id) );
270: l_wait_outcome := fnd_concurrent.wait_for_request(
271: request_id => l_p60_id,
272: phase => l_phase,
273: status => l_status,

Line 277: hr_utility.trace(' Status : '||l_dev_status);

273: status => l_status,
274: dev_phase => l_dev_phase,
275: dev_status => l_dev_status,
276: message => l_message);
277: hr_utility.trace(' Status : '||l_dev_status);
278: hr_utility.trace(' Phase : '||l_dev_phase);
279: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
280: errbuf := 'Error in the P60 report';
281: hr_utility.trace('P60 REPORT returned failure message: see ' || l_file_name);

Line 278: hr_utility.trace(' Phase : '||l_dev_phase);

274: dev_phase => l_dev_phase,
275: dev_status => l_dev_status,
276: message => l_message);
277: hr_utility.trace(' Status : '||l_dev_status);
278: hr_utility.trace(' Phase : '||l_dev_phase);
279: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
280: errbuf := 'Error in the P60 report';
281: hr_utility.trace('P60 REPORT returned failure message: see ' || l_file_name);
282: retcode := PROG_FAILURE ;

Line 281: hr_utility.trace('P60 REPORT returned failure message: see ' || l_file_name);

277: hr_utility.trace(' Status : '||l_dev_status);
278: hr_utility.trace(' Phase : '||l_dev_phase);
279: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
280: errbuf := 'Error in the P60 report';
281: hr_utility.trace('P60 REPORT returned failure message: see ' || l_file_name);
282: retcode := PROG_FAILURE ;
283: hr_utility.raise_error;
284: return;
285: END IF;

Line 283: hr_utility.raise_error;

279: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
280: errbuf := 'Error in the P60 report';
281: hr_utility.trace('P60 REPORT returned failure message: see ' || l_file_name);
282: retcode := PROG_FAILURE ;
283: hr_utility.raise_error;
284: return;
285: END IF;
286: hr_utility.trace('Finished P60 REPORT');
287: END IF;

Line 286: hr_utility.trace('Finished P60 REPORT');

282: retcode := PROG_FAILURE ;
283: hr_utility.raise_error;
284: return;
285: END IF;
286: hr_utility.trace('Finished P60 REPORT');
287: END IF;
288: ----------------------
289: -- Call P60 PROCESS --
290: ----------------------

Line 291: hr_utility.trace('');

287: END IF;
288: ----------------------
289: -- Call P60 PROCESS --
290: ----------------------
291: hr_utility.trace('');
292: hr_utility.trace('Start P60 REPORT');
293: l_p60_id := fnd_request.submit_request(
294: application => 'PAY',
295: program => 'PAYRPP60',

Line 292: hr_utility.trace('Start P60 REPORT');

288: ----------------------
289: -- Call P60 PROCESS --
290: ----------------------
291: hr_utility.trace('');
292: hr_utility.trace('Start P60 REPORT');
293: l_p60_id := fnd_request.submit_request(
294: application => 'PAY',
295: program => 'PAYRPP60',
296: argument1 => p_permit_no,

Line 312: hr_utility.trace('P60 REPORT returned failure message: see '|| l_file_name);

308: -- Check the result of the extract call
309: l_file_name := 'l' || TO_CHAR(l_p60_id) || '.req';
310: IF l_p60_id = 0 THEN
311: errbuf := 'Error calling the P60 report';
312: hr_utility.trace('P60 REPORT returned failure message: see '|| l_file_name);
313: retcode := PROG_FAILURE ;
314: hr_utility.raise_error;
315: return ;
316: END IF;

Line 314: hr_utility.raise_error;

310: IF l_p60_id = 0 THEN
311: errbuf := 'Error calling the P60 report';
312: hr_utility.trace('P60 REPORT returned failure message: see '|| l_file_name);
313: retcode := PROG_FAILURE ;
314: hr_utility.raise_error;
315: return ;
316: END IF;
317: COMMIT;
318: hr_utility.trace(' Submitted Req id: ' || TO_CHAR(l_p60_id) );

Line 318: hr_utility.trace(' Submitted Req id: ' || TO_CHAR(l_p60_id) );

314: hr_utility.raise_error;
315: return ;
316: END IF;
317: COMMIT;
318: hr_utility.trace(' Submitted Req id: ' || TO_CHAR(l_p60_id) );
319: l_wait_outcome := fnd_concurrent.wait_for_request(
320: request_id => l_p60_id,
321: phase => l_phase,
322: status => l_status,

Line 326: hr_utility.trace(' Status : '||l_dev_status);

322: status => l_status,
323: dev_phase => l_dev_phase,
324: dev_status => l_dev_status,
325: message => l_message);
326: hr_utility.trace(' Status : '||l_dev_status);
327: hr_utility.trace(' Phase : '||l_dev_phase);
328: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
329: errbuf := 'Error in the P60 report';
330: hr_utility.trace('P60 REPORT returned failure message: see ' || l_file_name);

Line 327: hr_utility.trace(' Phase : '||l_dev_phase);

323: dev_phase => l_dev_phase,
324: dev_status => l_dev_status,
325: message => l_message);
326: hr_utility.trace(' Status : '||l_dev_status);
327: hr_utility.trace(' Phase : '||l_dev_phase);
328: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
329: errbuf := 'Error in the P60 report';
330: hr_utility.trace('P60 REPORT returned failure message: see ' || l_file_name);
331: retcode := PROG_FAILURE ;

Line 330: hr_utility.trace('P60 REPORT returned failure message: see ' || l_file_name);

326: hr_utility.trace(' Status : '||l_dev_status);
327: hr_utility.trace(' Phase : '||l_dev_phase);
328: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
329: errbuf := 'Error in the P60 report';
330: hr_utility.trace('P60 REPORT returned failure message: see ' || l_file_name);
331: retcode := PROG_FAILURE ;
332: hr_utility.raise_error;
333: return;
334: END IF;

Line 332: hr_utility.raise_error;

328: IF l_dev_phase = 'COMPLETE' AND l_dev_status <> 'NORMAL' THEN
329: errbuf := 'Error in the P60 report';
330: hr_utility.trace('P60 REPORT returned failure message: see ' || l_file_name);
331: retcode := PROG_FAILURE ;
332: hr_utility.raise_error;
333: return;
334: END IF;
335: hr_utility.trace('Finished P60 REPORT');
336: END IF;

Line 335: hr_utility.trace('Finished P60 REPORT');

331: retcode := PROG_FAILURE ;
332: hr_utility.raise_error;
333: return;
334: END IF;
335: hr_utility.trace('Finished P60 REPORT');
336: END IF;
337: hr_utility.trace('Finished EOY_CONTROL');
338: END;
339: END;/* End of package */

Line 337: hr_utility.trace('Finished EOY_CONTROL');

333: return;
334: END IF;
335: hr_utility.trace('Finished P60 REPORT');
336: END IF;
337: hr_utility.trace('Finished EOY_CONTROL');
338: END;
339: END;/* End of package */