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

Line 207: hr_utility.trace('Insert definition for ' || l_report_format);

203:
204:
205: /* Delete existing block and record definitions for the MWS Report */
206:
207: hr_utility.trace('Insert definition for ' || l_report_format);
208: hr_utility.trace(l_desc);
209:
210: hr_utility.trace('Deleting magnetic records...');
211:

Line 208: hr_utility.trace(l_desc);

204:
205: /* Delete existing block and record definitions for the MWS Report */
206:
207: hr_utility.trace('Insert definition for ' || l_report_format);
208: hr_utility.trace(l_desc);
209:
210: hr_utility.trace('Deleting magnetic records...');
211:
212: delete from PAY_MAGNETIC_RECORDS

Line 210: hr_utility.trace('Deleting magnetic records...');

206:
207: hr_utility.trace('Insert definition for ' || l_report_format);
208: hr_utility.trace(l_desc);
209:
210: hr_utility.trace('Deleting magnetic records...');
211:
212: delete from PAY_MAGNETIC_RECORDS
213: where MAGNETIC_BLOCK_ID in
214: (select mgb.MAGNETIC_BLOCK_ID

Line 218: hr_utility.trace('Deleting magnetic blocks');

214: (select mgb.MAGNETIC_BLOCK_ID
215: from PAY_MAGNETIC_BLOCKS mgb
216: where mgb.REPORT_FORMAT = l_report_format);
217:
218: hr_utility.trace('Deleting magnetic blocks');
219:
220: delete from PAY_MAGNETIC_BLOCKS mgb
221: where mgb.REPORT_FORMAT = l_report_format;
222:

Line 223: hr_utility.trace('Deleting report format mappings...');

219:
220: delete from PAY_MAGNETIC_BLOCKS mgb
221: where mgb.REPORT_FORMAT = l_report_format;
222:
223: hr_utility.trace('Deleting report format mappings...');
224:
225: delete from PAY_REPORT_FORMAT_MAPPINGS_F rfm
226: where rfm.REPORT_FORMAT = l_report_format;
227:

Line 230: hr_utility.trace('Inserting the report qualifier : '||

226: where rfm.REPORT_FORMAT = l_report_format;
227:
228: /* Insert into pay_report_format_mappings_f */
229:
230: hr_utility.trace('Inserting the report qualifier : '||
231: l_report_qualifier);
232:
233: insert into PAY_REPORT_FORMAT_MAPPINGS_F
234: ( REPORT_TYPE,

Line 252: hr_utility.trace('Inserting block ' || lt_B_block_name(l_block_count));

248: for each of the block in lt_B_mag_block_id */
249:
250: for l_block_count IN 1..l_block_total loop
251:
252: hr_utility.trace('Inserting block ' || lt_B_block_name(l_block_count));
253: l_message := 'Error inserting block ' || lt_B_block_name(l_block_count);
254:
255: /* Only the first block can be the main block */
256: if l_block_count = 1 then

Line 275: hr_utility.trace('Inserting record def. for formula '

271: /* Insert Formulas into PAY_MAGNETIC_RECORDS */
272:
273: for l_formula_count in 1..l_record_total loop
274:
275: hr_utility.trace('Inserting record def. for formula '
276: || lt_F_formula_name(l_formula_count));
277:
278: l_message:='Error inserting record def. for formula '
279: || lt_F_formula_name(l_formula_count);

Line 288: hr_utility.trace('Could not find formula id');

284: p_legislation_code =>'US',
285: p_formula_name => lt_F_formula_name(l_formula_count));
286:
287: if l_f_id is NULL then
288: hr_utility.trace('Could not find formula id');
289: else hr_utility.trace('Successfully found formula id');
290: end if;
291:
292: /* Since lt_F_mag_block_id is used to index into lt_B_mag_block_id,

Line 289: else hr_utility.trace('Successfully found formula id');

285: p_formula_name => lt_F_formula_name(l_formula_count));
286:
287: if l_f_id is NULL then
288: hr_utility.trace('Could not find formula id');
289: else hr_utility.trace('Successfully found formula id');
290: end if;
291:
292: /* Since lt_F_mag_block_id is used to index into lt_B_mag_block_id,
293: take care of NULL values */

Line 296: hr_utility.trace( 'Error :NULL block id not allowed');

292: /* Since lt_F_mag_block_id is used to index into lt_B_mag_block_id,
293: take care of NULL values */
294:
295: if lt_F_mag_block_id(l_formula_count) is NULL then
296: hr_utility.trace( 'Error :NULL block id not allowed');
297: else l_mag_block_id := lt_B_mag_block_id(lt_F_mag_block_id(l_formula_count));
298: end if;
299:
300: if lt_F_next_block_id(l_formula_count) is NULL then

Line 305: hr_utility.trace( 'Formula_id = '|| l_f_id);

301: l_next_block_id := NULL;
302: else l_next_block_id := lt_B_mag_block_id(lt_F_next_block_id(l_formula_count));
303: end if;
304:
305: hr_utility.trace( 'Formula_id = '|| l_f_id);
306: hr_utility.trace( 'magnetic_block_id = '|| l_mag_block_id);
307: hr_utility.trace( 'next_block_id = '|| l_next_block_id);
308: hr_utility.trace( 'last_run_exec_mode = '|| lt_F_last_run_exec_mode(l_formula_count));
309: hr_utility.trace( 'overflow_mode = '|| lt_F_overflow_mode(l_formula_count));

Line 306: hr_utility.trace( 'magnetic_block_id = '|| l_mag_block_id);

302: else l_next_block_id := lt_B_mag_block_id(lt_F_next_block_id(l_formula_count));
303: end if;
304:
305: hr_utility.trace( 'Formula_id = '|| l_f_id);
306: hr_utility.trace( 'magnetic_block_id = '|| l_mag_block_id);
307: hr_utility.trace( 'next_block_id = '|| l_next_block_id);
308: hr_utility.trace( 'last_run_exec_mode = '|| lt_F_last_run_exec_mode(l_formula_count));
309: hr_utility.trace( 'overflow_mode = '|| lt_F_overflow_mode(l_formula_count));
310: hr_utility.trace( 'sequence = '|| lt_F_sequence(l_formula_count));

Line 307: hr_utility.trace( 'next_block_id = '|| l_next_block_id);

303: end if;
304:
305: hr_utility.trace( 'Formula_id = '|| l_f_id);
306: hr_utility.trace( 'magnetic_block_id = '|| l_mag_block_id);
307: hr_utility.trace( 'next_block_id = '|| l_next_block_id);
308: hr_utility.trace( 'last_run_exec_mode = '|| lt_F_last_run_exec_mode(l_formula_count));
309: hr_utility.trace( 'overflow_mode = '|| lt_F_overflow_mode(l_formula_count));
310: hr_utility.trace( 'sequence = '|| lt_F_sequence(l_formula_count));
311: hr_utility.trace( 'frequency = '|| lt_F_frequency(l_formula_count));

Line 308: hr_utility.trace( 'last_run_exec_mode = '|| lt_F_last_run_exec_mode(l_formula_count));

304:
305: hr_utility.trace( 'Formula_id = '|| l_f_id);
306: hr_utility.trace( 'magnetic_block_id = '|| l_mag_block_id);
307: hr_utility.trace( 'next_block_id = '|| l_next_block_id);
308: hr_utility.trace( 'last_run_exec_mode = '|| lt_F_last_run_exec_mode(l_formula_count));
309: hr_utility.trace( 'overflow_mode = '|| lt_F_overflow_mode(l_formula_count));
310: hr_utility.trace( 'sequence = '|| lt_F_sequence(l_formula_count));
311: hr_utility.trace( 'frequency = '|| lt_F_frequency(l_formula_count));
312:

Line 309: hr_utility.trace( 'overflow_mode = '|| lt_F_overflow_mode(l_formula_count));

305: hr_utility.trace( 'Formula_id = '|| l_f_id);
306: hr_utility.trace( 'magnetic_block_id = '|| l_mag_block_id);
307: hr_utility.trace( 'next_block_id = '|| l_next_block_id);
308: hr_utility.trace( 'last_run_exec_mode = '|| lt_F_last_run_exec_mode(l_formula_count));
309: hr_utility.trace( 'overflow_mode = '|| lt_F_overflow_mode(l_formula_count));
310: hr_utility.trace( 'sequence = '|| lt_F_sequence(l_formula_count));
311: hr_utility.trace( 'frequency = '|| lt_F_frequency(l_formula_count));
312:
313: Pay_Mgr_Ins.Ins

Line 310: hr_utility.trace( 'sequence = '|| lt_F_sequence(l_formula_count));

306: hr_utility.trace( 'magnetic_block_id = '|| l_mag_block_id);
307: hr_utility.trace( 'next_block_id = '|| l_next_block_id);
308: hr_utility.trace( 'last_run_exec_mode = '|| lt_F_last_run_exec_mode(l_formula_count));
309: hr_utility.trace( 'overflow_mode = '|| lt_F_overflow_mode(l_formula_count));
310: hr_utility.trace( 'sequence = '|| lt_F_sequence(l_formula_count));
311: hr_utility.trace( 'frequency = '|| lt_F_frequency(l_formula_count));
312:
313: Pay_Mgr_Ins.Ins
314: ( p_formula_id => l_f_id,

Line 311: hr_utility.trace( 'frequency = '|| lt_F_frequency(l_formula_count));

307: hr_utility.trace( 'next_block_id = '|| l_next_block_id);
308: hr_utility.trace( 'last_run_exec_mode = '|| lt_F_last_run_exec_mode(l_formula_count));
309: hr_utility.trace( 'overflow_mode = '|| lt_F_overflow_mode(l_formula_count));
310: hr_utility.trace( 'sequence = '|| lt_F_sequence(l_formula_count));
311: hr_utility.trace( 'frequency = '|| lt_F_frequency(l_formula_count));
312:
313: Pay_Mgr_Ins.Ins
314: ( p_formula_id => l_f_id,
315: p_magnetic_block_id => l_mag_block_id,

Line 325: hr_utility.trace('Successfully created '|| l_report_format

321: p_validate => lt_F_validate(l_formula_count));
322:
323: end loop;
324:
325: hr_utility.trace('Successfully created '|| l_report_format
326: || ' format mapping..');
327:
328: hr_utility.trace('Issuing commit ...');
329: commit;

Line 328: hr_utility.trace('Issuing commit ...');

324:
325: hr_utility.trace('Successfully created '|| l_report_format
326: || ' format mapping..');
327:
328: hr_utility.trace('Issuing commit ...');
329: commit;
330:
331: exception
332: when others then

Line 333: hr_utility.trace( l_message||' - ORA '||to_char(SQLCODE));

329: commit;
330:
331: exception
332: when others then
333: hr_utility.trace( l_message||' - ORA '||to_char(SQLCODE));
334: hr_utility.trace(l_message || ' - Ora: '|| to_char(sqlcode));
335:
336: hr_utility.trace('END REPORT DEFINITION PROCESS ');
337: end setup;

Line 334: hr_utility.trace(l_message || ' - Ora: '|| to_char(sqlcode));

330:
331: exception
332: when others then
333: hr_utility.trace( l_message||' - ORA '||to_char(SQLCODE));
334: hr_utility.trace(l_message || ' - Ora: '|| to_char(sqlcode));
335:
336: hr_utility.trace('END REPORT DEFINITION PROCESS ');
337: end setup;
338:

Line 336: hr_utility.trace('END REPORT DEFINITION PROCESS ');

332: when others then
333: hr_utility.trace( l_message||' - ORA '||to_char(SQLCODE));
334: hr_utility.trace(l_message || ' - Ora: '|| to_char(sqlcode));
335:
336: hr_utility.trace('END REPORT DEFINITION PROCESS ');
337: end setup;
338:
339: end pay_mws_rpdef;