169: savepoint asset_maint;
170:
171: -- print out arguments
172:
173: fnd_message.set_name('OFA','FA_ASSET_MAINT_SCHARG_LIST');
174: fnd_message.set_token('SCHID', argument1, FALSE);
175: h_mesg_str := fnd_message.get;
176: fa_rx_conc_mesg_pkg.log(h_mesg_str);
177: fa_rx_conc_mesg_pkg.log('');
170:
171: -- print out arguments
172:
173: fnd_message.set_name('OFA','FA_ASSET_MAINT_SCHARG_LIST');
174: fnd_message.set_token('SCHID', argument1, FALSE);
175: h_mesg_str := fnd_message.get;
176: fa_rx_conc_mesg_pkg.log(h_mesg_str);
177: fa_rx_conc_mesg_pkg.log('');
178: fa_rx_conc_mesg_pkg.out(h_mesg_str);
171: -- print out arguments
172:
173: fnd_message.set_name('OFA','FA_ASSET_MAINT_SCHARG_LIST');
174: fnd_message.set_token('SCHID', argument1, FALSE);
175: h_mesg_str := fnd_message.get;
176: fa_rx_conc_mesg_pkg.log(h_mesg_str);
177: fa_rx_conc_mesg_pkg.log('');
178: fa_rx_conc_mesg_pkg.out(h_mesg_str);
179: fa_rx_conc_mesg_pkg.out('');
280: commit;
281:
282: fa_rx_conc_mesg_pkg.log('');
283: fa_rx_conc_mesg_pkg.log('');
284: fnd_message.set_name('OFA','FA_MASSRCL_NUM_PROC');
285: fnd_message.set_token('NUM', to_char(h_num_assets), FALSE);
286: h_mesg_str := fnd_message.get;
287: fa_rx_conc_mesg_pkg.out(h_mesg_str);
288: fa_rx_conc_mesg_pkg.out('');
281:
282: fa_rx_conc_mesg_pkg.log('');
283: fa_rx_conc_mesg_pkg.log('');
284: fnd_message.set_name('OFA','FA_MASSRCL_NUM_PROC');
285: fnd_message.set_token('NUM', to_char(h_num_assets), FALSE);
286: h_mesg_str := fnd_message.get;
287: fa_rx_conc_mesg_pkg.out(h_mesg_str);
288: fa_rx_conc_mesg_pkg.out('');
289: fa_rx_conc_mesg_pkg.out('');
282: fa_rx_conc_mesg_pkg.log('');
283: fa_rx_conc_mesg_pkg.log('');
284: fnd_message.set_name('OFA','FA_MASSRCL_NUM_PROC');
285: fnd_message.set_token('NUM', to_char(h_num_assets), FALSE);
286: h_mesg_str := fnd_message.get;
287: fa_rx_conc_mesg_pkg.out(h_mesg_str);
288: fa_rx_conc_mesg_pkg.out('');
289: fa_rx_conc_mesg_pkg.out('');
290:
287: fa_rx_conc_mesg_pkg.out(h_mesg_str);
288: fa_rx_conc_mesg_pkg.out('');
289: fa_rx_conc_mesg_pkg.out('');
290:
291: fnd_message.set_name('OFA', 'FA_SHARED_END_SUCCESS');
292: fnd_message.set_token('PROGRAM',h_progname,FALSE);
293: h_mesg_str := fnd_message.get;
294: fa_rx_conc_mesg_pkg.log(h_mesg_str);
295: fa_rx_conc_mesg_pkg.log('');
288: fa_rx_conc_mesg_pkg.out('');
289: fa_rx_conc_mesg_pkg.out('');
290:
291: fnd_message.set_name('OFA', 'FA_SHARED_END_SUCCESS');
292: fnd_message.set_token('PROGRAM',h_progname,FALSE);
293: h_mesg_str := fnd_message.get;
294: fa_rx_conc_mesg_pkg.log(h_mesg_str);
295: fa_rx_conc_mesg_pkg.log('');
296: fa_rx_conc_mesg_pkg.out(h_mesg_str);
289: fa_rx_conc_mesg_pkg.out('');
290:
291: fnd_message.set_name('OFA', 'FA_SHARED_END_SUCCESS');
292: fnd_message.set_token('PROGRAM',h_progname,FALSE);
293: h_mesg_str := fnd_message.get;
294: fa_rx_conc_mesg_pkg.log(h_mesg_str);
295: fa_rx_conc_mesg_pkg.log('');
296: fa_rx_conc_mesg_pkg.out(h_mesg_str);
297:
307: when others then
308: if (assets_to_schedule%ISOPEN) then
309: close assets_to_schedule;
310: end if;
311: fnd_message.set_name('OFA',h_mesg_name);
312: h_mesg_str := fnd_message.get;
313: fa_rx_conc_mesg_pkg.log(h_mesg_str);
314: fa_rx_conc_mesg_pkg.log('');
315:
308: if (assets_to_schedule%ISOPEN) then
309: close assets_to_schedule;
310: end if;
311: fnd_message.set_name('OFA',h_mesg_name);
312: h_mesg_str := fnd_message.get;
313: fa_rx_conc_mesg_pkg.log(h_mesg_str);
314: fa_rx_conc_mesg_pkg.log('');
315:
316: fnd_message.set_name('OFA', 'FA_SHARED_END_WITH_ERROR');
312: h_mesg_str := fnd_message.get;
313: fa_rx_conc_mesg_pkg.log(h_mesg_str);
314: fa_rx_conc_mesg_pkg.log('');
315:
316: fnd_message.set_name('OFA', 'FA_SHARED_END_WITH_ERROR');
317: fnd_message.set_token('PROGRAM',h_progname,FALSE);
318: h_mesg_str := fnd_message.get;
319: fa_rx_conc_mesg_pkg.log(h_mesg_str);
320: fa_rx_conc_mesg_pkg.out(h_mesg_str);
313: fa_rx_conc_mesg_pkg.log(h_mesg_str);
314: fa_rx_conc_mesg_pkg.log('');
315:
316: fnd_message.set_name('OFA', 'FA_SHARED_END_WITH_ERROR');
317: fnd_message.set_token('PROGRAM',h_progname,FALSE);
318: h_mesg_str := fnd_message.get;
319: fa_rx_conc_mesg_pkg.log(h_mesg_str);
320: fa_rx_conc_mesg_pkg.out(h_mesg_str);
321: retcode := 2;
314: fa_rx_conc_mesg_pkg.log('');
315:
316: fnd_message.set_name('OFA', 'FA_SHARED_END_WITH_ERROR');
317: fnd_message.set_token('PROGRAM',h_progname,FALSE);
318: h_mesg_str := fnd_message.get;
319: fa_rx_conc_mesg_pkg.log(h_mesg_str);
320: fa_rx_conc_mesg_pkg.out(h_mesg_str);
321: retcode := 2;
322:
329:
330: h_mesg_str varchar2(2000);
331:
332: begin
333: fnd_message.set_name('OFA', p_msg_name);
334: if (p_msg_name = 'FA_SHARED_INSERT_FAILED') then
335: fnd_message.set_token('TABLE','FA_MAINT_EVENTS',FALSE);
336: end if;
337: h_mesg_str := fnd_message.get;
331:
332: begin
333: fnd_message.set_name('OFA', p_msg_name);
334: if (p_msg_name = 'FA_SHARED_INSERT_FAILED') then
335: fnd_message.set_token('TABLE','FA_MAINT_EVENTS',FALSE);
336: end if;
337: h_mesg_str := fnd_message.get;
338: fa_rx_conc_mesg_pkg.log(h_mesg_str);
339: fa_rx_conc_mesg_pkg.log('');
333: fnd_message.set_name('OFA', p_msg_name);
334: if (p_msg_name = 'FA_SHARED_INSERT_FAILED') then
335: fnd_message.set_token('TABLE','FA_MAINT_EVENTS',FALSE);
336: end if;
337: h_mesg_str := fnd_message.get;
338: fa_rx_conc_mesg_pkg.log(h_mesg_str);
339: fa_rx_conc_mesg_pkg.log('');
340:
341: fnd_message.set_name('OFA', 'FA_SHARED_END_WITH_ERROR');
337: h_mesg_str := fnd_message.get;
338: fa_rx_conc_mesg_pkg.log(h_mesg_str);
339: fa_rx_conc_mesg_pkg.log('');
340:
341: fnd_message.set_name('OFA', 'FA_SHARED_END_WITH_ERROR');
342: fnd_message.set_token('PROGRAM',h_progname,FALSE);
343: h_mesg_str := fnd_message.get;
344: fa_rx_conc_mesg_pkg.log(h_mesg_str);
345: fa_rx_conc_mesg_pkg.out(h_mesg_str);
338: fa_rx_conc_mesg_pkg.log(h_mesg_str);
339: fa_rx_conc_mesg_pkg.log('');
340:
341: fnd_message.set_name('OFA', 'FA_SHARED_END_WITH_ERROR');
342: fnd_message.set_token('PROGRAM',h_progname,FALSE);
343: h_mesg_str := fnd_message.get;
344: fa_rx_conc_mesg_pkg.log(h_mesg_str);
345: fa_rx_conc_mesg_pkg.out(h_mesg_str);
346:
339: fa_rx_conc_mesg_pkg.log('');
340:
341: fnd_message.set_name('OFA', 'FA_SHARED_END_WITH_ERROR');
342: fnd_message.set_token('PROGRAM',h_progname,FALSE);
343: h_mesg_str := fnd_message.get;
344: fa_rx_conc_mesg_pkg.log(h_mesg_str);
345: fa_rx_conc_mesg_pkg.out(h_mesg_str);
346:
347: rollback to savepoint asset_maint;