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('');
180:
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('');
180:
181: -- check if valid argument is passed in
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('');
180:
181: -- check if valid argument is passed in
182:
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('');
180:
181: -- check if valid argument is passed in
182:
183: if (argument1 is NULL) then
278: set status = 'COMPLETED'
279: where schedule_id = h_schedule_id;
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;
279: where schedule_id = h_schedule_id;
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);
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:
291: fnd_message.set_name('OFA', 'FA_SHARED_END_SUCCESS');
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:
291: fnd_message.set_name('OFA', 'FA_SHARED_END_SUCCESS');
292: fnd_message.set_token('PROGRAM',h_progname,FALSE);
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:
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;
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:
298: retcode := 0;
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:
298: retcode := 0;
299:
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:
298: retcode := 0;
299:
300: EXCEPTION
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');
317: fnd_message.set_token('PROGRAM',h_progname,FALSE);
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');
317: fnd_message.set_token('PROGRAM',h_progname,FALSE);
318: h_mesg_str := fnd_message.get;
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:
323: END do_schedule;
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:
323: END do_schedule;
324:
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');
342: fnd_message.set_token('PROGRAM',h_progname,FALSE);
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');
342: fnd_message.set_token('PROGRAM',h_progname,FALSE);
343: h_mesg_str := fnd_message.get;
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;
348: if (p_sch_id is not NULL) then
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;
348: if (p_sch_id is not NULL) then
349: update fa_maint_schedule_hdr