DBA Data[Home] [Help]

APPS.FARX_C_WD dependencies on FND_MESSAGE

Line 187: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');

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;

Line 188: h_mesg_str := fnd_message.get;

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;

Line 201: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');

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;

Line 202: h_mesg_str := fnd_message.get;

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;

Line 232: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');

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;

Line 233: h_mesg_str := fnd_message.get;

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;

Line 249: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');

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;

Line 250: h_mesg_str := fnd_message.get;

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;

Line 264: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');

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;

Line 265: h_mesg_str := fnd_message.get;

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;

Line 287: fnd_message.set_name('OFA','FA_PROJ_CALS_UNDEFINED');

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;

Line 288: h_mesg_str := fnd_message.get;

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;

Line 305: fnd_message.set_name('OFA','FA_WHATIF_BEGIN_END_ASSET');

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;

Line 306: h_mesg_str := fnd_message.get;

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;

Line 355: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');

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:

Line 356: fnd_message.set_token('CAT',argument9,FALSE);

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;

Line 357: h_mesg_str := fnd_message.get;

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;

Line 376: fnd_message.set_name('OFA','FA_WHATIF_CAT_NOT_SET_UP');

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:

Line 377: fnd_message.set_token('CAT',argument9,FALSE);

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;

Line 378: h_mesg_str := fnd_message.get;

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;

Line 396: fnd_message.set_name('OFA',h_mesg_name);

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;

Line 398: fnd_message.set_token('VALUE',h_value_error,FALSE);

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);

Line 399: fnd_message.set_token('PARAM',h_param_error,FALSE);

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;

Line 401: h_mesg_str := fnd_message.get;

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;

Line 421: fnd_message.set_name('OFA','FA_SHARED_BAD_END_DATE');

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;

Line 422: h_mesg_str := fnd_message.get;

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;

Line 445: fnd_message.set_name('OFA','FA_WHATIF_NO_METHOD');

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:

Line 446: fnd_message.set_token('METHOD',argument11,FALSE);

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;

Line 447: h_mesg_str := fnd_message.get;

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;

Line 474: fnd_message.set_name('OFA','FA_MASSCHG_LIFE_BASED_METHOD');

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;

Line 475: h_mesg_str := fnd_message.get;

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;

Line 488: fnd_message.set_name('OFA','FA_SHARED_INVALID_METHOD_LIFE');

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;

Line 489: h_mesg_str := fnd_message.get;

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;

Line 497: fnd_message.set_name('OFA','FA_METHOD_NO_RATES');

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;

Line 498: h_mesg_str := fnd_message.get;

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;

Line 522: fnd_message.set_name('OFA','FA_MASSCHG_RATE_BASED_METHOD');

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;

Line 523: h_mesg_str := fnd_message.get;

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;

Line 539: fnd_message.set_name('OFA','FA_SHARED_INVALID_METHOD_RATE');

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;

Line 540: h_mesg_str := fnd_message.get;

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;

Line 549: fnd_message.set_name('OFA','FA_METHOD_NO_LIFE');

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;

Line 550: h_mesg_str := fnd_message.get;

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;

Line 576: fnd_message.set_name('OFA','FA_WHATIF_NO_CONVENTION');

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:

Line 577: fnd_message.set_token('CONV',argument14,FALSE);

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;

Line 578: h_mesg_str := fnd_message.get;

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;

Line 595: fnd_message.set_name('OFA','FA_SHARED_BAD_PERCENT');

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;

Line 596: h_mesg_str := fnd_message.get;

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;

Line 614: fnd_message.set_name('OFA',h_mesg_name);

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;

Line 616: fnd_message.set_token('VALUE',h_value_error,FALSE);

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);

Line 617: fnd_message.set_token('PARAM',h_param_error,FALSE);

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;

Line 619: h_mesg_str := fnd_message.get;

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;

Line 641: fnd_message.set_name('OFA',h_mesg_name);

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;

Line 643: fnd_message.set_token('VALUE',h_value_error,FALSE);

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);

Line 644: fnd_message.set_token('PARAM',h_param_error,FALSE);

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;

Line 646: h_mesg_str := fnd_message.get;

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;

Line 680: fnd_message.set_name('OFA',h_mesg_name);

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;

Line 682: fnd_message.set_token('VALUE',h_value_error,FALSE);

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);

Line 683: fnd_message.set_token('PARAM',h_param_error,FALSE);

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;

Line 685: h_mesg_str := fnd_message.get;

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:

Line 738: fnd_message.set_name('OFA','FA_WHATIF_NO_ASSETS');

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;

Line 739: h_mesg_str := fnd_message.get;

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;

Line 818: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');

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:

Line 819: fnd_message.set_token('CAT',argument7,FALSE);

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;

Line 820: h_mesg_str := fnd_message.get;

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;

Line 840: fnd_message.set_name('OFA','FA_WHATIF_CAT_NOT_SET_UP');

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:

Line 841: fnd_message.set_token('CAT',argument7,FALSE);

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;

Line 842: h_mesg_str := fnd_message.get;

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;

Line 886: fnd_message.set_name('OFA',h_mesg_name);

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;

Line 888: fnd_message.set_token('VALUE',h_value_error,FALSE);

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);

Line 889: fnd_message.set_token('PARAM',h_param_error,FALSE);

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:

Line 891: h_mesg_str := fnd_message.get;

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: