DBA Data[Home] [Help]

APPS.FARX_C_WD dependencies on FND_MESSAGE

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

209: h_count := 0;
210:
211: if argument1 is null then
212:
213: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
214: h_mesg_str := fnd_message.get;
215: fa_rx_conc_mesg_pkg.log(h_mesg_str);
216:
217: x_return_status := 2;

Line 214: h_mesg_str := fnd_message.get;

210:
211: if argument1 is null then
212:
213: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
214: h_mesg_str := fnd_message.get;
215: fa_rx_conc_mesg_pkg.log(h_mesg_str);
216:
217: x_return_status := 2;
218: return;

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

223: from fa_book_controls
224: where book_Type_code = argument1 and rownum < 2;
225:
226: if h_count = 0 then
227: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
228: h_mesg_str := fnd_message.get;
229: fa_rx_conc_mesg_pkg.log(h_mesg_str);
230:
231: x_return_status := 2;

Line 228: h_mesg_str := fnd_message.get;

224: where book_Type_code = argument1 and rownum < 2;
225:
226: if h_count = 0 then
227: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
228: h_mesg_str := fnd_message.get;
229: fa_rx_conc_mesg_pkg.log(h_mesg_str);
230:
231: x_return_status := 2;
232: return;

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

254: h_param_error := 'PERIOD NAME';
255:
256:
257: if argument2 is null then
258: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
259: h_mesg_str := fnd_message.get;
260: fa_rx_conc_mesg_pkg.log(h_mesg_str);
261:
262: x_return_status := 2;

Line 259: h_mesg_str := fnd_message.get;

255:
256:
257: if argument2 is null then
258: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
259: h_mesg_str := fnd_message.get;
260: fa_rx_conc_mesg_pkg.log(h_mesg_str);
261:
262: x_return_status := 2;
263: return;

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

271: and cp.period_name = argument2 and rownum < 2;
272:
273: if h_count = 0 then
274:
275: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
276: h_mesg_str := fnd_message.get;
277: fa_rx_conc_mesg_pkg.log(h_mesg_str);
278:
279: x_return_status := 2;

Line 276: h_mesg_str := fnd_message.get;

272:
273: if h_count = 0 then
274:
275: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
276: h_mesg_str := fnd_message.get;
277: fa_rx_conc_mesg_pkg.log(h_mesg_str);
278:
279: x_return_status := 2;
280: return;

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

286:
287: if ((argument3 is null) OR (to_number(argument3) <= 0 OR
288: to_number(argument3) <> floor(to_number(argument3)))) then
289:
290: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
291: h_mesg_str := fnd_message.get;
292: fa_rx_conc_mesg_pkg.log(h_mesg_str);
293:
294: x_return_status := 2;

Line 291: h_mesg_str := fnd_message.get;

287: if ((argument3 is null) OR (to_number(argument3) <= 0 OR
288: to_number(argument3) <> floor(to_number(argument3)))) then
289:
290: fnd_message.set_name('OFA','FA_WHATIF_PARAM_REQUIRED');
291: h_mesg_str := fnd_message.get;
292: fa_rx_conc_mesg_pkg.log(h_mesg_str);
293:
294: x_return_status := 2;
295: return;

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

309: where cp1.calendar_type = cp.calendar_type
310: and cp1.period_name = argument2);
311:
312: if h_count < to_number(argument3) then
313: fnd_message.set_name('OFA','FA_PROJ_CALS_UNDEFINED');
314: h_mesg_str := fnd_message.get;
315: fa_rx_conc_mesg_pkg.log(h_mesg_str);
316: x_return_status := 2;
317: return;

Line 314: h_mesg_str := fnd_message.get;

310: and cp1.period_name = argument2);
311:
312: if h_count < to_number(argument3) then
313: fnd_message.set_name('OFA','FA_PROJ_CALS_UNDEFINED');
314: h_mesg_str := fnd_message.get;
315: fa_rx_conc_mesg_pkg.log(h_mesg_str);
316: x_return_status := 2;
317: return;
318: end if;

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

327:
328: if (argument4 is not null and argument5 is not null AND
329: argument5 < argument4) then
330:
331: fnd_message.set_name('OFA','FA_WHATIF_BEGIN_END_ASSET');
332: h_mesg_str := fnd_message.get;
333: fa_rx_conc_mesg_pkg.log(h_mesg_str);
334:
335: x_return_status := 2;

Line 332: h_mesg_str := fnd_message.get;

328: if (argument4 is not null and argument5 is not null AND
329: argument5 < argument4) then
330:
331: fnd_message.set_name('OFA','FA_WHATIF_BEGIN_END_ASSET');
332: h_mesg_str := fnd_message.get;
333: fa_rx_conc_mesg_pkg.log(h_mesg_str);
334:
335: x_return_status := 2;
336: return;

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

377: resp_appl_id => NULL,
378: resp_id => NULL,
379: user_id => NULL) = FALSE then
380:
381: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');
382: fnd_message.set_token('CAT',argument9,FALSE);
383: h_mesg_str := fnd_message.get;
384: fa_rx_conc_mesg_pkg.log(h_mesg_str);
385:

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

378: resp_id => NULL,
379: user_id => NULL) = FALSE then
380:
381: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');
382: fnd_message.set_token('CAT',argument9,FALSE);
383: h_mesg_str := fnd_message.get;
384: fa_rx_conc_mesg_pkg.log(h_mesg_str);
385:
386: x_return_status := 2;

Line 383: h_mesg_str := fnd_message.get;

379: user_id => NULL) = FALSE then
380:
381: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');
382: fnd_message.set_token('CAT',argument9,FALSE);
383: h_mesg_str := fnd_message.get;
384: fa_rx_conc_mesg_pkg.log(h_mesg_str);
385:
386: x_return_status := 2;
387: return;

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

398: and cat.category_id = cb.category_id
399: and cb.book_type_code = argument1 and rownum < 2;
400:
401: if h_count = 0 then
402: fnd_message.set_name('OFA','FA_WHATIF_CAT_NOT_SET_UP');
403: fnd_message.set_token('CAT',argument9,FALSE);
404: h_mesg_str := fnd_message.get;
405: fa_rx_conc_mesg_pkg.log(h_mesg_str);
406:

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

399: and cb.book_type_code = argument1 and rownum < 2;
400:
401: if h_count = 0 then
402: fnd_message.set_name('OFA','FA_WHATIF_CAT_NOT_SET_UP');
403: fnd_message.set_token('CAT',argument9,FALSE);
404: h_mesg_str := fnd_message.get;
405: fa_rx_conc_mesg_pkg.log(h_mesg_str);
406:
407: x_return_status := 2;

Line 404: h_mesg_str := fnd_message.get;

400:
401: if h_count = 0 then
402: fnd_message.set_name('OFA','FA_WHATIF_CAT_NOT_SET_UP');
403: fnd_message.set_token('CAT',argument9,FALSE);
404: h_mesg_str := fnd_message.get;
405: fa_rx_conc_mesg_pkg.log(h_mesg_str);
406:
407: x_return_status := 2;
408: return;

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

418: h_param_error := 'FULLY_RSVD_FLAG';
419:
420: if (argument17 not in ('Y','N','YES','NO')) then
421:
422: fnd_message.set_name('OFA',h_mesg_name);
423: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
424: fnd_message.set_token('VALUE',h_value_error,FALSE);
425: fnd_message.set_token('PARAM',h_param_error,FALSE);
426: end if;

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

420: if (argument17 not in ('Y','N','YES','NO')) then
421:
422: fnd_message.set_name('OFA',h_mesg_name);
423: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
424: fnd_message.set_token('VALUE',h_value_error,FALSE);
425: fnd_message.set_token('PARAM',h_param_error,FALSE);
426: end if;
427: h_mesg_str := fnd_message.get;
428: fa_rx_conc_mesg_pkg.log(h_mesg_str);

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

421:
422: fnd_message.set_name('OFA',h_mesg_name);
423: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
424: fnd_message.set_token('VALUE',h_value_error,FALSE);
425: fnd_message.set_token('PARAM',h_param_error,FALSE);
426: end if;
427: h_mesg_str := fnd_message.get;
428: fa_rx_conc_mesg_pkg.log(h_mesg_str);
429: x_return_status := 2;

Line 427: h_mesg_str := fnd_message.get;

423: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
424: fnd_message.set_token('VALUE',h_value_error,FALSE);
425: fnd_message.set_token('PARAM',h_param_error,FALSE);
426: end if;
427: h_mesg_str := fnd_message.get;
428: fa_rx_conc_mesg_pkg.log(h_mesg_str);
429: x_return_status := 2;
430:
431: return;

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

443: end if;
444:
445: if (argument6 is not null and argument7 is not null) then
446: if h_end_dpis < h_begin_dpis then
447: fnd_message.set_name('OFA','FA_SHARED_BAD_END_DATE');
448: h_mesg_str := fnd_message.get;
449: fa_rx_conc_mesg_pkg.log(h_mesg_str);
450: x_return_status := 2;
451: return;

Line 448: h_mesg_str := fnd_message.get;

444:
445: if (argument6 is not null and argument7 is not null) then
446: if h_end_dpis < h_begin_dpis then
447: fnd_message.set_name('OFA','FA_SHARED_BAD_END_DATE');
448: h_mesg_str := fnd_message.get;
449: fa_rx_conc_mesg_pkg.log(h_mesg_str);
450: x_return_status := 2;
451: return;
452: end if;

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

467: from fa_methods
468: where method_code = argument11 and rownum < 2;
469:
470: if h_count = 0 then
471: fnd_message.set_name('OFA','FA_WHATIF_NO_METHOD');
472: fnd_message.set_token('METHOD',argument11,FALSE);
473: h_mesg_str := fnd_message.get;
474: fa_rx_conc_mesg_pkg.log(h_mesg_str);
475:

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

468: where method_code = argument11 and rownum < 2;
469:
470: if h_count = 0 then
471: fnd_message.set_name('OFA','FA_WHATIF_NO_METHOD');
472: fnd_message.set_token('METHOD',argument11,FALSE);
473: h_mesg_str := fnd_message.get;
474: fa_rx_conc_mesg_pkg.log(h_mesg_str);
475:
476: x_return_status := 2;

Line 473: h_mesg_str := fnd_message.get;

469:
470: if h_count = 0 then
471: fnd_message.set_name('OFA','FA_WHATIF_NO_METHOD');
472: fnd_message.set_token('METHOD',argument11,FALSE);
473: h_mesg_str := fnd_message.get;
474: fa_rx_conc_mesg_pkg.log(h_mesg_str);
475:
476: x_return_status := 2;
477: return;

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

496: if h_count > 0 then -- this is a life-based method
497:
498: if (argument12 is null) then
499:
500: fnd_message.set_name('OFA','FA_MASSCHG_LIFE_BASED_METHOD');
501: h_mesg_str := fnd_message.get;
502: fa_rx_conc_mesg_pkg.log(h_mesg_str);
503:
504: x_return_status := 2;

Line 501: h_mesg_str := fnd_message.get;

497:
498: if (argument12 is null) then
499:
500: fnd_message.set_name('OFA','FA_MASSCHG_LIFE_BASED_METHOD');
501: h_mesg_str := fnd_message.get;
502: fa_rx_conc_mesg_pkg.log(h_mesg_str);
503:
504: x_return_status := 2;
505: return;

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

510: where method_code = argument11 and life_in_months = to_number(argument12)
511: and rownum < 2;
512:
513: if h_count = 0 then
514: fnd_message.set_name('OFA','FA_SHARED_INVALID_METHOD_LIFE');
515: h_mesg_str := fnd_message.get;
516: fa_rx_conc_mesg_pkg.log(h_mesg_str);
517:
518: x_return_status := 2;

Line 515: h_mesg_str := fnd_message.get;

511: and rownum < 2;
512:
513: if h_count = 0 then
514: fnd_message.set_name('OFA','FA_SHARED_INVALID_METHOD_LIFE');
515: h_mesg_str := fnd_message.get;
516: fa_rx_conc_mesg_pkg.log(h_mesg_str);
517:
518: x_return_status := 2;
519: return;

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

519: return;
520: end if;
521:
522: if (argument13 is not null) then
523: fnd_message.set_name('OFA','FA_METHOD_NO_RATES');
524: h_mesg_str := fnd_message.get;
525: fa_rx_conc_mesg_pkg.log(h_mesg_str);
526:
527: x_return_status := 2;

Line 524: h_mesg_str := fnd_message.get;

520: end if;
521:
522: if (argument13 is not null) then
523: fnd_message.set_name('OFA','FA_METHOD_NO_RATES');
524: h_mesg_str := fnd_message.get;
525: fa_rx_conc_mesg_pkg.log(h_mesg_str);
526:
527: x_return_status := 2;
528: return;

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

544:
545: if h_count > 0 then -- this is a rate-based method
546:
547: if (argument13 is null) then
548: fnd_message.set_name('OFA','FA_MASSCHG_RATE_BASED_METHOD');
549: h_mesg_str := fnd_message.get;
550: fa_rx_conc_mesg_pkg.log(h_mesg_str);
551:
552: x_return_status := 2;

Line 549: h_mesg_str := fnd_message.get;

545: if h_count > 0 then -- this is a rate-based method
546:
547: if (argument13 is null) then
548: fnd_message.set_name('OFA','FA_MASSCHG_RATE_BASED_METHOD');
549: h_mesg_str := fnd_message.get;
550: fa_rx_conc_mesg_pkg.log(h_mesg_str);
551:
552: x_return_status := 2;
553: return;

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

561: and m.method_id = r.method_id
562: and r.adjusted_rate = h_adj_rate and rownum < 2;
563:
564: if h_count = 0 then
565: fnd_message.set_name('OFA','FA_SHARED_INVALID_METHOD_RATE');
566: h_mesg_str := fnd_message.get;
567: fa_rx_conc_mesg_pkg.log(h_mesg_str);
568:
569: x_return_status := 2;

Line 566: h_mesg_str := fnd_message.get;

562: and r.adjusted_rate = h_adj_rate and rownum < 2;
563:
564: if h_count = 0 then
565: fnd_message.set_name('OFA','FA_SHARED_INVALID_METHOD_RATE');
566: h_mesg_str := fnd_message.get;
567: fa_rx_conc_mesg_pkg.log(h_mesg_str);
568:
569: x_return_status := 2;
570: return;

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

571:
572: end if;
573:
574: if (argument12 is not null) then
575: fnd_message.set_name('OFA','FA_METHOD_NO_LIFE');
576: h_mesg_str := fnd_message.get;
577: fa_rx_conc_mesg_pkg.log(h_mesg_str);
578:
579: x_return_status := 2;

Line 576: h_mesg_str := fnd_message.get;

572: end if;
573:
574: if (argument12 is not null) then
575: fnd_message.set_name('OFA','FA_METHOD_NO_LIFE');
576: h_mesg_str := fnd_message.get;
577: fa_rx_conc_mesg_pkg.log(h_mesg_str);
578:
579: x_return_status := 2;
580: return;

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

598: select count(*) into h_count from fa_conventions
599: where prorate_convention_code = argument14 and rownum < 2;
600:
601: if h_count = 0 then
602: fnd_message.set_name('OFA','FA_WHATIF_NO_CONVENTION');
603: fnd_message.set_token('CONV',argument14,FALSE);
604: h_mesg_str := fnd_message.get;
605: fa_rx_conc_mesg_pkg.log(h_mesg_str);
606:

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

599: where prorate_convention_code = argument14 and rownum < 2;
600:
601: if h_count = 0 then
602: fnd_message.set_name('OFA','FA_WHATIF_NO_CONVENTION');
603: fnd_message.set_token('CONV',argument14,FALSE);
604: h_mesg_str := fnd_message.get;
605: fa_rx_conc_mesg_pkg.log(h_mesg_str);
606:
607: x_return_status := 2;

Line 604: h_mesg_str := fnd_message.get;

600:
601: if h_count = 0 then
602: fnd_message.set_name('OFA','FA_WHATIF_NO_CONVENTION');
603: fnd_message.set_token('CONV',argument14,FALSE);
604: h_mesg_str := fnd_message.get;
605: fa_rx_conc_mesg_pkg.log(h_mesg_str);
606:
607: x_return_status := 2;
608: return;

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

617:
618: if argument15 is not null then
619:
620: if (to_number(argument15) < 0 OR to_number(argument15) > 100) then
621: fnd_message.set_name('OFA','FA_SHARED_BAD_PERCENT');
622: h_mesg_str := fnd_message.get;
623: fa_rx_conc_mesg_pkg.log(h_mesg_str);
624:
625: x_return_status := 2;

Line 622: h_mesg_str := fnd_message.get;

618: if argument15 is not null then
619:
620: if (to_number(argument15) < 0 OR to_number(argument15) > 100) then
621: fnd_message.set_name('OFA','FA_SHARED_BAD_PERCENT');
622: h_mesg_str := fnd_message.get;
623: fa_rx_conc_mesg_pkg.log(h_mesg_str);
624:
625: x_return_status := 2;
626: return;

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

636:
637: if (upper(argument16) not in ('Y','N','YES','NO','EXPENSED','AMORTIZED'))
638: then
639:
640: fnd_message.set_name('OFA',h_mesg_name);
641: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
642: fnd_message.set_token('VALUE',h_value_error,FALSE);
643: fnd_message.set_token('PARAM',h_param_error,FALSE);
644: end if;

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

638: then
639:
640: fnd_message.set_name('OFA',h_mesg_name);
641: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
642: fnd_message.set_token('VALUE',h_value_error,FALSE);
643: fnd_message.set_token('PARAM',h_param_error,FALSE);
644: end if;
645: h_mesg_str := fnd_message.get;
646: fa_rx_conc_mesg_pkg.log(h_mesg_str);

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

639:
640: fnd_message.set_name('OFA',h_mesg_name);
641: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
642: fnd_message.set_token('VALUE',h_value_error,FALSE);
643: fnd_message.set_token('PARAM',h_param_error,FALSE);
644: end if;
645: h_mesg_str := fnd_message.get;
646: fa_rx_conc_mesg_pkg.log(h_mesg_str);
647: x_return_status := 2;

Line 645: h_mesg_str := fnd_message.get;

641: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
642: fnd_message.set_token('VALUE',h_value_error,FALSE);
643: fnd_message.set_token('PARAM',h_param_error,FALSE);
644: end if;
645: h_mesg_str := fnd_message.get;
646: fa_rx_conc_mesg_pkg.log(h_mesg_str);
647: x_return_status := 2;
648:
649: return;

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

663: where user_id = to_number(argument17) and rownum < 2;
664:
665: if (h_count = 0 and to_number(nvl(argument17,'0')) <> 0) then
666:
667: fnd_message.set_name('OFA',h_mesg_name);
668: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
669: fnd_message.set_token('VALUE',h_value_error,FALSE);
670: fnd_message.set_token('PARAM',h_param_error,FALSE);
671: end if;

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

665: if (h_count = 0 and to_number(nvl(argument17,'0')) <> 0) then
666:
667: fnd_message.set_name('OFA',h_mesg_name);
668: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
669: fnd_message.set_token('VALUE',h_value_error,FALSE);
670: fnd_message.set_token('PARAM',h_param_error,FALSE);
671: end if;
672: h_mesg_str := fnd_message.get;
673: fa_rx_conc_mesg_pkg.log(h_mesg_str);

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

666:
667: fnd_message.set_name('OFA',h_mesg_name);
668: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
669: fnd_message.set_token('VALUE',h_value_error,FALSE);
670: fnd_message.set_token('PARAM',h_param_error,FALSE);
671: end if;
672: h_mesg_str := fnd_message.get;
673: fa_rx_conc_mesg_pkg.log(h_mesg_str);
674: x_return_status := 2;

Line 672: h_mesg_str := fnd_message.get;

668: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
669: fnd_message.set_token('VALUE',h_value_error,FALSE);
670: fnd_message.set_token('PARAM',h_param_error,FALSE);
671: end if;
672: h_mesg_str := fnd_message.get;
673: fa_rx_conc_mesg_pkg.log(h_mesg_str);
674: x_return_status := 2;
675: return;
676: end if;

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

702:
703: if h_count = 0 then
704:
705:
706: fnd_message.set_name('OFA',h_mesg_name);
707: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
708: fnd_message.set_token('VALUE',h_value_error,FALSE);
709: fnd_message.set_token('PARAM',h_param_error,FALSE);
710: end if;

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

704:
705:
706: fnd_message.set_name('OFA',h_mesg_name);
707: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
708: fnd_message.set_token('VALUE',h_value_error,FALSE);
709: fnd_message.set_token('PARAM',h_param_error,FALSE);
710: end if;
711: h_mesg_str := fnd_message.get;
712: fa_rx_conc_mesg_pkg.log(h_mesg_str);

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

705:
706: fnd_message.set_name('OFA',h_mesg_name);
707: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
708: fnd_message.set_token('VALUE',h_value_error,FALSE);
709: fnd_message.set_token('PARAM',h_param_error,FALSE);
710: end if;
711: h_mesg_str := fnd_message.get;
712: fa_rx_conc_mesg_pkg.log(h_mesg_str);
713: x_return_status := 2;

Line 711: h_mesg_str := fnd_message.get;

707: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
708: fnd_message.set_token('VALUE',h_value_error,FALSE);
709: fnd_message.set_token('PARAM',h_param_error,FALSE);
710: end if;
711: h_mesg_str := fnd_message.get;
712: fa_rx_conc_mesg_pkg.log(h_mesg_str);
713: x_return_status := 2;
714: return;
715:

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

859: -- NO NEED TO RUN WHATIF. NO ROWS WOULD GET GENERATED ANYWAYS.
860: -- Bug 8930129, changing the return status to 0 so that no error is raised
861: -- when there is NO ASSET is there to process.
862: if h_num_assets = 0 then
863: fnd_message.set_name('OFA','FA_WHATIF_NO_ASSETS');
864: h_mesg_str := fnd_message.get;
865: fa_rx_conc_mesg_pkg.log(h_mesg_str);
866:
867: if (p_total_requests > 1) then

Line 864: h_mesg_str := fnd_message.get;

860: -- Bug 8930129, changing the return status to 0 so that no error is raised
861: -- when there is NO ASSET is there to process.
862: if h_num_assets = 0 then
863: fnd_message.set_name('OFA','FA_WHATIF_NO_ASSETS');
864: h_mesg_str := fnd_message.get;
865: fa_rx_conc_mesg_pkg.log(h_mesg_str);
866:
867: if (p_total_requests > 1) then
868: update fa_worker_jobs

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

978: resp_appl_id => NULL,
979: resp_id => NULL,
980: user_id => NULL) = FALSE then
981:
982: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');
983: fnd_message.set_token('CAT',argument7,FALSE);
984: h_mesg_str := fnd_message.get;
985: fa_rx_conc_mesg_pkg.log(h_mesg_str);
986:

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

979: resp_id => NULL,
980: user_id => NULL) = FALSE then
981:
982: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');
983: fnd_message.set_token('CAT',argument7,FALSE);
984: h_mesg_str := fnd_message.get;
985: fa_rx_conc_mesg_pkg.log(h_mesg_str);
986:
987: x_return_status := 2;

Line 984: h_mesg_str := fnd_message.get;

980: user_id => NULL) = FALSE then
981:
982: fnd_message.set_name('OFA','FA_WHATIF_NO_CAT');
983: fnd_message.set_token('CAT',argument7,FALSE);
984: h_mesg_str := fnd_message.get;
985: fa_rx_conc_mesg_pkg.log(h_mesg_str);
986:
987: x_return_status := 2;
988: return;

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

1000: and cat.category_id = cb.category_id
1001: and cb.book_type_code = argument1 and rownum < 2;
1002:
1003: if h_count = 0 then
1004: fnd_message.set_name('OFA','FA_WHATIF_CAT_NOT_SET_UP');
1005: fnd_message.set_token('CAT',argument7,FALSE);
1006: h_mesg_str := fnd_message.get;
1007: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1008:

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

1001: and cb.book_type_code = argument1 and rownum < 2;
1002:
1003: if h_count = 0 then
1004: fnd_message.set_name('OFA','FA_WHATIF_CAT_NOT_SET_UP');
1005: fnd_message.set_token('CAT',argument7,FALSE);
1006: h_mesg_str := fnd_message.get;
1007: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1008:
1009: x_return_status := 2;

Line 1006: h_mesg_str := fnd_message.get;

1002:
1003: if h_count = 0 then
1004: fnd_message.set_name('OFA','FA_WHATIF_CAT_NOT_SET_UP');
1005: fnd_message.set_token('CAT',argument7,FALSE);
1006: h_mesg_str := fnd_message.get;
1007: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1008:
1009: x_return_status := 2;
1010: return;

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

1139: if SQLCODE <> 0 then
1140: fa_Rx_conc_mesg_pkg.log(SQLERRM);
1141: end if;
1142:
1143: fnd_message.set_name('OFA',h_mesg_name);
1144: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
1145: fnd_message.set_token('VALUE',h_value_error,FALSE);
1146: fnd_message.set_token('PARAM',h_param_error,FALSE);
1147: end if;

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

1141: end if;
1142:
1143: fnd_message.set_name('OFA',h_mesg_name);
1144: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
1145: fnd_message.set_token('VALUE',h_value_error,FALSE);
1146: fnd_message.set_token('PARAM',h_param_error,FALSE);
1147: end if;
1148: h_mesg_str := fnd_message.get;
1149: fa_rx_conc_mesg_pkg.log(h_mesg_str);

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

1142:
1143: fnd_message.set_name('OFA',h_mesg_name);
1144: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
1145: fnd_message.set_token('VALUE',h_value_error,FALSE);
1146: fnd_message.set_token('PARAM',h_param_error,FALSE);
1147: end if;
1148: h_mesg_str := fnd_message.get;
1149: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1150:

Line 1148: h_mesg_str := fnd_message.get;

1144: if h_mesg_name = 'FA_WHATIF_PARAM_ERROR' then
1145: fnd_message.set_token('VALUE',h_value_error,FALSE);
1146: fnd_message.set_token('PARAM',h_param_error,FALSE);
1147: end if;
1148: h_mesg_str := fnd_message.get;
1149: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1150:
1151: x_return_status := 2;
1152: */