183: h_count := 0;
184:
185: if argument1 is null then
186:
187: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
188: h_mesg_str := fnd_message.get;
189: fa_rx_conc_mesg_pkg.log(h_mesg_str);
190:
191: retcode := 2;
184:
185: if argument1 is null then
186:
187: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
188: h_mesg_str := fnd_message.get;
189: fa_rx_conc_mesg_pkg.log(h_mesg_str);
190:
191: retcode := 2;
192: return;
197: from fa_book_controls
198: where book_Type_code = argument1 and rownum < 2;
199:
200: if h_count = 0 then
201: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
202: h_mesg_str := fnd_message.get;
203: fa_rx_conc_mesg_pkg.log(h_mesg_str);
204:
205: retcode := 2;
198: where book_Type_code = argument1 and rownum < 2;
199:
200: if h_count = 0 then
201: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
202: h_mesg_str := fnd_message.get;
203: fa_rx_conc_mesg_pkg.log(h_mesg_str);
204:
205: retcode := 2;
206: return;
228: h_param_error := 'PERIOD NAME';
229:
230:
231: if argument2 is null then
232: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
233: h_mesg_str := fnd_message.get;
234: fa_rx_conc_mesg_pkg.log(h_mesg_str);
235:
236: retcode := 2;
229:
230:
231: if argument2 is null then
232: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
233: h_mesg_str := fnd_message.get;
234: fa_rx_conc_mesg_pkg.log(h_mesg_str);
235:
236: retcode := 2;
237: return;
245: and cp.period_name = argument2 and rownum < 2;
246:
247: if h_count = 0 then
248:
249: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
250: h_mesg_str := fnd_message.get;
251: fa_rx_conc_mesg_pkg.log(h_mesg_str);
252:
253: retcode := 2;
246:
247: if h_count = 0 then
248:
249: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
250: h_mesg_str := fnd_message.get;
251: fa_rx_conc_mesg_pkg.log(h_mesg_str);
252:
253: retcode := 2;
254: return;
260:
261: if ((argument3 is null) OR (to_number(argument3) <= 0 OR
262: to_number(argument3) <> floor(to_number(argument3)))) then
263:
264: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
265: h_mesg_str := fnd_message.get;
266: fa_rx_conc_mesg_pkg.log(h_mesg_str);
267:
268: retcode := 2;
261: if ((argument3 is null) OR (to_number(argument3) <= 0 OR
262: to_number(argument3) <> floor(to_number(argument3)))) then
263:
264: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
265: h_mesg_str := fnd_message.get;
266: fa_rx_conc_mesg_pkg.log(h_mesg_str);
267:
268: retcode := 2;
269: return;
283: where cp1.calendar_type = cp.calendar_type
284: and cp1.period_name = argument2);
285:
286: if h_count < to_number(argument3) then
287: fnd_message.set_name('OFA','FA_PROJ_CALS_UNDEFINED');
288: h_mesg_str := fnd_message.get;
289: fa_rx_conc_mesg_pkg.log(h_mesg_str);
290: retcode := 2;
291: return;
284: and cp1.period_name = argument2);
285:
286: if h_count < to_number(argument3) then
287: fnd_message.set_name('OFA','FA_PROJ_CALS_UNDEFINED');
288: h_mesg_str := fnd_message.get;
289: fa_rx_conc_mesg_pkg.log(h_mesg_str);
290: retcode := 2;
291: return;
292: end if;
301:
302: if (argument4 is not null and argument5 is not null AND
303: argument5 < argument4) then
304:
305: fnd_message.set_name('OFA','FA_WHATIF_BEGIN_END_ASSET');
306: h_mesg_str := fnd_message.get;
307: fa_rx_conc_mesg_pkg.log(h_mesg_str);
308:
309: retcode := 2;
302: if (argument4 is not null and argument5 is not null AND
303: argument5 < argument4) then
304:
305: fnd_message.set_name('OFA','FA_WHATIF_BEGIN_END_ASSET');
306: h_mesg_str := fnd_message.get;
307: fa_rx_conc_mesg_pkg.log(h_mesg_str);
308:
309: retcode := 2;
310: return;
351: resp_appl_id => NULL,
352: resp_id => NULL,
353: user_id => NULL) = FALSE then
354:
355: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');
356: fnd_message.set_token('CAT',argument9,FALSE);
357: h_mesg_str := fnd_message.get;
358: fa_rx_conc_mesg_pkg.log(h_mesg_str);
359:
352: resp_id => NULL,
353: user_id => NULL) = FALSE then
354:
355: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');
356: fnd_message.set_token('CAT',argument9,FALSE);
357: h_mesg_str := fnd_message.get;
358: fa_rx_conc_mesg_pkg.log(h_mesg_str);
359:
360: retcode := 2;
353: user_id => NULL) = FALSE then
354:
355: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');
356: fnd_message.set_token('CAT',argument9,FALSE);
357: h_mesg_str := fnd_message.get;
358: fa_rx_conc_mesg_pkg.log(h_mesg_str);
359:
360: retcode := 2;
361: return;
372: and cat.category_id = cb.category_id
373: and cb.book_type_code = argument1 and rownum < 2;
374:
375: if h_count = 0 then
376: fnd_message.set_name('OFA','FA_WHATIF_CAT_NOT_SET_UP');
377: fnd_message.set_token('CAT',argument9,FALSE);
378: h_mesg_str := fnd_message.get;
379: fa_rx_conc_mesg_pkg.log(h_mesg_str);
380:
373: and cb.book_type_code = argument1 and rownum < 2;
374:
375: if h_count = 0 then
376: fnd_message.set_name('OFA','FA_WHATIF_CAT_NOT_SET_UP');
377: fnd_message.set_token('CAT',argument9,FALSE);
378: h_mesg_str := fnd_message.get;
379: fa_rx_conc_mesg_pkg.log(h_mesg_str);
380:
381: retcode := 2;
374:
375: if h_count = 0 then
376: fnd_message.set_name('OFA','FA_WHATIF_CAT_NOT_SET_UP');
377: fnd_message.set_token('CAT',argument9,FALSE);
378: h_mesg_str := fnd_message.get;
379: fa_rx_conc_mesg_pkg.log(h_mesg_str);
380:
381: retcode := 2;
382: return;
392: h_param_error := 'FULLY_RSVD_FLAG';
393:
394: if (argument17 not in ('Y','N','YES','NO')) then
395:
396: fnd_message.set_name('OFA',h_mesg_name);
397: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
398: fnd_message.set_token('VALUE',h_value_error,FALSE);
399: fnd_message.set_token('PARAM',h_param_error,FALSE);
400: end if;
394: if (argument17 not in ('Y','N','YES','NO')) then
395:
396: fnd_message.set_name('OFA',h_mesg_name);
397: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
398: fnd_message.set_token('VALUE',h_value_error,FALSE);
399: fnd_message.set_token('PARAM',h_param_error,FALSE);
400: end if;
401: h_mesg_str := fnd_message.get;
402: fa_rx_conc_mesg_pkg.log(h_mesg_str);
395:
396: fnd_message.set_name('OFA',h_mesg_name);
397: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
398: fnd_message.set_token('VALUE',h_value_error,FALSE);
399: fnd_message.set_token('PARAM',h_param_error,FALSE);
400: end if;
401: h_mesg_str := fnd_message.get;
402: fa_rx_conc_mesg_pkg.log(h_mesg_str);
403: retcode := 2;
397: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
398: fnd_message.set_token('VALUE',h_value_error,FALSE);
399: fnd_message.set_token('PARAM',h_param_error,FALSE);
400: end if;
401: h_mesg_str := fnd_message.get;
402: fa_rx_conc_mesg_pkg.log(h_mesg_str);
403: retcode := 2;
404:
405: return;
417: end if;
418:
419: if (argument6 is not null and argument7 is not null) then
420: if h_end_dpis < h_begin_dpis then
421: fnd_message.set_name('OFA','FA_SHARED_BAD_END_DATE');
422: h_mesg_str := fnd_message.get;
423: fa_rx_conc_mesg_pkg.log(h_mesg_str);
424: retcode := 2;
425: return;
418:
419: if (argument6 is not null and argument7 is not null) then
420: if h_end_dpis < h_begin_dpis then
421: fnd_message.set_name('OFA','FA_SHARED_BAD_END_DATE');
422: h_mesg_str := fnd_message.get;
423: fa_rx_conc_mesg_pkg.log(h_mesg_str);
424: retcode := 2;
425: return;
426: end if;
441: from fa_methods
442: where method_code = argument11 and rownum < 2;
443:
444: if h_count = 0 then
445: fnd_message.set_name('OFA','FA_WHATIF_NO_METHOD');
446: fnd_message.set_token('METHOD',argument11,FALSE);
447: h_mesg_str := fnd_message.get;
448: fa_rx_conc_mesg_pkg.log(h_mesg_str);
449:
442: where method_code = argument11 and rownum < 2;
443:
444: if h_count = 0 then
445: fnd_message.set_name('OFA','FA_WHATIF_NO_METHOD');
446: fnd_message.set_token('METHOD',argument11,FALSE);
447: h_mesg_str := fnd_message.get;
448: fa_rx_conc_mesg_pkg.log(h_mesg_str);
449:
450: retcode := 2;
443:
444: if h_count = 0 then
445: fnd_message.set_name('OFA','FA_WHATIF_NO_METHOD');
446: fnd_message.set_token('METHOD',argument11,FALSE);
447: h_mesg_str := fnd_message.get;
448: fa_rx_conc_mesg_pkg.log(h_mesg_str);
449:
450: retcode := 2;
451: return;
470: if h_count > 0 then -- this is a life-based method
471:
472: if (argument12 is null) then
473:
474: fnd_message.set_name('OFA','FA_MASSCHG_LIFE_BASED_METHOD');
475: h_mesg_str := fnd_message.get;
476: fa_rx_conc_mesg_pkg.log(h_mesg_str);
477:
478: retcode := 2;
471:
472: if (argument12 is null) then
473:
474: fnd_message.set_name('OFA','FA_MASSCHG_LIFE_BASED_METHOD');
475: h_mesg_str := fnd_message.get;
476: fa_rx_conc_mesg_pkg.log(h_mesg_str);
477:
478: retcode := 2;
479: return;
484: where method_code = argument11 and life_in_months = to_number(argument12)
485: and rownum < 2;
486:
487: if h_count = 0 then
488: fnd_message.set_name('OFA','FA_SHARED_INVALID_METHOD_LIFE');
489: h_mesg_str := fnd_message.get;
490: fa_rx_conc_mesg_pkg.log(h_mesg_str);
491:
492: retcode := 2;
485: and rownum < 2;
486:
487: if h_count = 0 then
488: fnd_message.set_name('OFA','FA_SHARED_INVALID_METHOD_LIFE');
489: h_mesg_str := fnd_message.get;
490: fa_rx_conc_mesg_pkg.log(h_mesg_str);
491:
492: retcode := 2;
493: return;
493: return;
494: end if;
495:
496: if (argument13 is not null) then
497: fnd_message.set_name('OFA','FA_METHOD_NO_RATES');
498: h_mesg_str := fnd_message.get;
499: fa_rx_conc_mesg_pkg.log(h_mesg_str);
500:
501: retcode := 2;
494: end if;
495:
496: if (argument13 is not null) then
497: fnd_message.set_name('OFA','FA_METHOD_NO_RATES');
498: h_mesg_str := fnd_message.get;
499: fa_rx_conc_mesg_pkg.log(h_mesg_str);
500:
501: retcode := 2;
502: return;
518:
519: if h_count > 0 then -- this is a rate-based method
520:
521: if (argument13 is null) then
522: fnd_message.set_name('OFA','FA_MASSCHG_RATE_BASED_METHOD');
523: h_mesg_str := fnd_message.get;
524: fa_rx_conc_mesg_pkg.log(h_mesg_str);
525:
526: retcode := 2;
519: if h_count > 0 then -- this is a rate-based method
520:
521: if (argument13 is null) then
522: fnd_message.set_name('OFA','FA_MASSCHG_RATE_BASED_METHOD');
523: h_mesg_str := fnd_message.get;
524: fa_rx_conc_mesg_pkg.log(h_mesg_str);
525:
526: retcode := 2;
527: return;
535: and m.method_id = r.method_id
536: and r.adjusted_rate = h_adj_rate and rownum < 2;
537:
538: if h_count = 0 then
539: fnd_message.set_name('OFA','FA_SHARED_INVALID_METHOD_RATE');
540: h_mesg_str := fnd_message.get;
541: fa_rx_conc_mesg_pkg.log(h_mesg_str);
542:
543: retcode := 2;
536: and r.adjusted_rate = h_adj_rate and rownum < 2;
537:
538: if h_count = 0 then
539: fnd_message.set_name('OFA','FA_SHARED_INVALID_METHOD_RATE');
540: h_mesg_str := fnd_message.get;
541: fa_rx_conc_mesg_pkg.log(h_mesg_str);
542:
543: retcode := 2;
544: return;
545:
546: end if;
547:
548: if (argument12 is not null) then
549: fnd_message.set_name('OFA','FA_METHOD_NO_LIFE');
550: h_mesg_str := fnd_message.get;
551: fa_rx_conc_mesg_pkg.log(h_mesg_str);
552:
553: retcode := 2;
546: end if;
547:
548: if (argument12 is not null) then
549: fnd_message.set_name('OFA','FA_METHOD_NO_LIFE');
550: h_mesg_str := fnd_message.get;
551: fa_rx_conc_mesg_pkg.log(h_mesg_str);
552:
553: retcode := 2;
554: return;
572: select count(*) into h_count from fa_conventions
573: where prorate_convention_code = argument14 and rownum < 2;
574:
575: if h_count = 0 then
576: fnd_message.set_name('OFA','FA_WHATIF_NO_CONVENTION');
577: fnd_message.set_token('CONV',argument14,FALSE);
578: h_mesg_str := fnd_message.get;
579: fa_rx_conc_mesg_pkg.log(h_mesg_str);
580:
573: where prorate_convention_code = argument14 and rownum < 2;
574:
575: if h_count = 0 then
576: fnd_message.set_name('OFA','FA_WHATIF_NO_CONVENTION');
577: fnd_message.set_token('CONV',argument14,FALSE);
578: h_mesg_str := fnd_message.get;
579: fa_rx_conc_mesg_pkg.log(h_mesg_str);
580:
581: retcode := 2;
574:
575: if h_count = 0 then
576: fnd_message.set_name('OFA','FA_WHATIF_NO_CONVENTION');
577: fnd_message.set_token('CONV',argument14,FALSE);
578: h_mesg_str := fnd_message.get;
579: fa_rx_conc_mesg_pkg.log(h_mesg_str);
580:
581: retcode := 2;
582: return;
591:
592: if argument15 is not null then
593:
594: if (to_number(argument15) < 0 OR to_number(argument15) > 100) then
595: fnd_message.set_name('OFA','FA_SHARED_BAD_PERCENT');
596: h_mesg_str := fnd_message.get;
597: fa_rx_conc_mesg_pkg.log(h_mesg_str);
598:
599: retcode := 2;
592: if argument15 is not null then
593:
594: if (to_number(argument15) < 0 OR to_number(argument15) > 100) then
595: fnd_message.set_name('OFA','FA_SHARED_BAD_PERCENT');
596: h_mesg_str := fnd_message.get;
597: fa_rx_conc_mesg_pkg.log(h_mesg_str);
598:
599: retcode := 2;
600: return;
610:
611: if (upper(argument16) not in ('Y','N','YES','NO','EXPENSED','AMORTIZED'))
612: then
613:
614: fnd_message.set_name('OFA',h_mesg_name);
615: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
616: fnd_message.set_token('VALUE',h_value_error,FALSE);
617: fnd_message.set_token('PARAM',h_param_error,FALSE);
618: end if;
612: then
613:
614: fnd_message.set_name('OFA',h_mesg_name);
615: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
616: fnd_message.set_token('VALUE',h_value_error,FALSE);
617: fnd_message.set_token('PARAM',h_param_error,FALSE);
618: end if;
619: h_mesg_str := fnd_message.get;
620: fa_rx_conc_mesg_pkg.log(h_mesg_str);
613:
614: fnd_message.set_name('OFA',h_mesg_name);
615: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
616: fnd_message.set_token('VALUE',h_value_error,FALSE);
617: fnd_message.set_token('PARAM',h_param_error,FALSE);
618: end if;
619: h_mesg_str := fnd_message.get;
620: fa_rx_conc_mesg_pkg.log(h_mesg_str);
621: retcode := 2;
615: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
616: fnd_message.set_token('VALUE',h_value_error,FALSE);
617: fnd_message.set_token('PARAM',h_param_error,FALSE);
618: end if;
619: h_mesg_str := fnd_message.get;
620: fa_rx_conc_mesg_pkg.log(h_mesg_str);
621: retcode := 2;
622:
623: return;
637: where user_id = to_number(argument17) and rownum < 2;
638:
639: if (h_count = 0 and to_number(nvl(argument17,'0')) <> 0) then
640:
641: fnd_message.set_name('OFA',h_mesg_name);
642: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
643: fnd_message.set_token('VALUE',h_value_error,FALSE);
644: fnd_message.set_token('PARAM',h_param_error,FALSE);
645: end if;
639: if (h_count = 0 and to_number(nvl(argument17,'0')) <> 0) then
640:
641: fnd_message.set_name('OFA',h_mesg_name);
642: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
643: fnd_message.set_token('VALUE',h_value_error,FALSE);
644: fnd_message.set_token('PARAM',h_param_error,FALSE);
645: end if;
646: h_mesg_str := fnd_message.get;
647: fa_rx_conc_mesg_pkg.log(h_mesg_str);
640:
641: fnd_message.set_name('OFA',h_mesg_name);
642: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
643: fnd_message.set_token('VALUE',h_value_error,FALSE);
644: fnd_message.set_token('PARAM',h_param_error,FALSE);
645: end if;
646: h_mesg_str := fnd_message.get;
647: fa_rx_conc_mesg_pkg.log(h_mesg_str);
648: retcode := 2;
642: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
643: fnd_message.set_token('VALUE',h_value_error,FALSE);
644: fnd_message.set_token('PARAM',h_param_error,FALSE);
645: end if;
646: h_mesg_str := fnd_message.get;
647: fa_rx_conc_mesg_pkg.log(h_mesg_str);
648: retcode := 2;
649: return;
650: end if;
676:
677: if h_count = 0 then
678:
679:
680: fnd_message.set_name('OFA',h_mesg_name);
681: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
682: fnd_message.set_token('VALUE',h_value_error,FALSE);
683: fnd_message.set_token('PARAM',h_param_error,FALSE);
684: end if;
678:
679:
680: fnd_message.set_name('OFA',h_mesg_name);
681: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
682: fnd_message.set_token('VALUE',h_value_error,FALSE);
683: fnd_message.set_token('PARAM',h_param_error,FALSE);
684: end if;
685: h_mesg_str := fnd_message.get;
686: fa_rx_conc_mesg_pkg.log(h_mesg_str);
679:
680: fnd_message.set_name('OFA',h_mesg_name);
681: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
682: fnd_message.set_token('VALUE',h_value_error,FALSE);
683: fnd_message.set_token('PARAM',h_param_error,FALSE);
684: end if;
685: h_mesg_str := fnd_message.get;
686: fa_rx_conc_mesg_pkg.log(h_mesg_str);
687: retcode := 2;
681: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
682: fnd_message.set_token('VALUE',h_value_error,FALSE);
683: fnd_message.set_token('PARAM',h_param_error,FALSE);
684: end if;
685: h_mesg_str := fnd_message.get;
686: fa_rx_conc_mesg_pkg.log(h_mesg_str);
687: retcode := 2;
688: return;
689:
734: -- IF NO ASSETS RETURNED, EXIT WITH WARNING.
735: -- NO NEED TO RUN WHATIF. NO ROWS WOULD GET GENERATED ANYWAYS.
736:
737: if h_num_assets = 0 then
738: fnd_message.set_name('OFA','FA_WHATIF_NO_ASSETS');
739: h_mesg_str := fnd_message.get;
740: fa_rx_conc_mesg_pkg.log(h_mesg_str);
741:
742: retcode := 1;
735: -- NO NEED TO RUN WHATIF. NO ROWS WOULD GET GENERATED ANYWAYS.
736:
737: if h_num_assets = 0 then
738: fnd_message.set_name('OFA','FA_WHATIF_NO_ASSETS');
739: h_mesg_str := fnd_message.get;
740: fa_rx_conc_mesg_pkg.log(h_mesg_str);
741:
742: retcode := 1;
743: return;
814: resp_appl_id => NULL,
815: resp_id => NULL,
816: user_id => NULL) = FALSE then
817:
818: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');
819: fnd_message.set_token('CAT',argument7,FALSE);
820: h_mesg_str := fnd_message.get;
821: fa_rx_conc_mesg_pkg.log(h_mesg_str);
822:
815: resp_id => NULL,
816: user_id => NULL) = FALSE then
817:
818: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');
819: fnd_message.set_token('CAT',argument7,FALSE);
820: h_mesg_str := fnd_message.get;
821: fa_rx_conc_mesg_pkg.log(h_mesg_str);
822:
823: retcode := 2;
816: user_id => NULL) = FALSE then
817:
818: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');
819: fnd_message.set_token('CAT',argument7,FALSE);
820: h_mesg_str := fnd_message.get;
821: fa_rx_conc_mesg_pkg.log(h_mesg_str);
822:
823: retcode := 2;
824: return;
836: and cat.category_id = cb.category_id
837: and cb.book_type_code = argument1 and rownum < 2;
838:
839: if h_count = 0 then
840: fnd_message.set_name('OFA','FA_WHATIF_CAT_NOT_SET_UP');
841: fnd_message.set_token('CAT',argument7,FALSE);
842: h_mesg_str := fnd_message.get;
843: fa_rx_conc_mesg_pkg.log(h_mesg_str);
844:
837: and cb.book_type_code = argument1 and rownum < 2;
838:
839: if h_count = 0 then
840: fnd_message.set_name('OFA','FA_WHATIF_CAT_NOT_SET_UP');
841: fnd_message.set_token('CAT',argument7,FALSE);
842: h_mesg_str := fnd_message.get;
843: fa_rx_conc_mesg_pkg.log(h_mesg_str);
844:
845: retcode := 2;
838:
839: if h_count = 0 then
840: fnd_message.set_name('OFA','FA_WHATIF_CAT_NOT_SET_UP');
841: fnd_message.set_token('CAT',argument7,FALSE);
842: h_mesg_str := fnd_message.get;
843: fa_rx_conc_mesg_pkg.log(h_mesg_str);
844:
845: retcode := 2;
846: return;
882: if SQLCODE <> 0 then
883: fa_Rx_conc_mesg_pkg.log(SQLERRM);
884: end if;
885:
886: fnd_message.set_name('OFA',h_mesg_name);
887: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
888: fnd_message.set_token('VALUE',h_value_error,FALSE);
889: fnd_message.set_token('PARAM',h_param_error,FALSE);
890: end if;
884: end if;
885:
886: fnd_message.set_name('OFA',h_mesg_name);
887: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
888: fnd_message.set_token('VALUE',h_value_error,FALSE);
889: fnd_message.set_token('PARAM',h_param_error,FALSE);
890: end if;
891: h_mesg_str := fnd_message.get;
892: fa_rx_conc_mesg_pkg.log(h_mesg_str);
885:
886: fnd_message.set_name('OFA',h_mesg_name);
887: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
888: fnd_message.set_token('VALUE',h_value_error,FALSE);
889: fnd_message.set_token('PARAM',h_param_error,FALSE);
890: end if;
891: h_mesg_str := fnd_message.get;
892: fa_rx_conc_mesg_pkg.log(h_mesg_str);
893:
887: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
888: fnd_message.set_token('VALUE',h_value_error,FALSE);
889: fnd_message.set_token('PARAM',h_param_error,FALSE);
890: end if;
891: h_mesg_str := fnd_message.get;
892: fa_rx_conc_mesg_pkg.log(h_mesg_str);
893:
894:
895: