eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_CACHE_PKG dependencies on FA_SRVR_MSG

Line 369: fa_srvr_msg.add_message(calling_fn => NULL,

365: return (TRUE);
366:
367: exception
368: when NO_DATA_FOUND then
369: fa_srvr_msg.add_message(calling_fn => NULL,
370: name => 'FA_CACHE_BOOK_CONTROLS',
371: token1 => 'BOOK',
372: value1 => X_book, p_log_level_rec => p_log_level_rec);
373: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc', p_log_level_rec => p_log_level_rec);

Line 373: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc', p_log_level_rec => p_log_level_rec);

369: fa_srvr_msg.add_message(calling_fn => NULL,
370: name => 'FA_CACHE_BOOK_CONTROLS',
371: token1 => 'BOOK',
372: value1 => X_book, p_log_level_rec => p_log_level_rec);
373: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc', p_log_level_rec => p_log_level_rec);
374: return (false);
375: when fazcbc_err then
376: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc', p_log_level_rec => p_log_level_rec);
377: return (false);

Line 376: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc', p_log_level_rec => p_log_level_rec);

372: value1 => X_book, p_log_level_rec => p_log_level_rec);
373: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc', p_log_level_rec => p_log_level_rec);
374: return (false);
375: when fazcbc_err then
376: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc', p_log_level_rec => p_log_level_rec);
377: return (false);
378: when others then
379: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc', p_log_level_rec => p_log_level_rec);
380: return (FALSE);

Line 379: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc', p_log_level_rec => p_log_level_rec);

375: when fazcbc_err then
376: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc', p_log_level_rec => p_log_level_rec);
377: return (false);
378: when others then
379: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc', p_log_level_rec => p_log_level_rec);
380: return (FALSE);
381:
382: end FAZCBC;
383:

Line 402: fa_srvr_msg.add_sql_error

398: if (X_set_of_books_id is not null) then
399: if not fazcsob
400: (X_set_of_books_id => X_set_of_books_id,
401: X_mrc_sob_type_code => h_reporting_flag) then
402: fa_srvr_msg.add_sql_error
403: (calling_fn => 'fa_cache_pkg.fazcbcs', p_log_level_rec => p_log_level_rec);
404: return(FALSE);
405: end if;
406: else

Line 437: fa_srvr_msg.add_sql_error

433: -- load primary cache first if needed
434: if (nvl(fazcbc_record.book_type_code, X_book || 'NULL') <> X_book)
435: then
436: if not (fazcbc (X_book, p_log_level_rec)) then
437: fa_srvr_msg.add_sql_error
438: (calling_fn => 'fa_cache_pkg.fazcbcs', p_log_level_rec => p_log_level_rec);
439: return(FALSE);
440: end if;
441: end if;

Line 491: fa_srvr_msg.add_message(calling_fn => NULL,

487: return (TRUE);
488:
489: exception
490: when NO_DATA_FOUND then
491: fa_srvr_msg.add_message(calling_fn => NULL,
492: name => 'FA_CACHE_MC_BOOK_CONTROLS',
493: token1 => 'BOOK',
494: value1 => X_book,
495: token2 => 'SET_OF_BOOKS_ID',

Line 497: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbcs', p_log_level_rec => p_log_level_rec);

493: token1 => 'BOOK',
494: value1 => X_book,
495: token2 => 'SET_OF_BOOKS_ID',
496: value2 => X_set_of_books_id, p_log_level_rec => p_log_level_rec);
497: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbcs', p_log_level_rec => p_log_level_rec);
498: return (FALSE);
499: when others then
500: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbcs', p_log_level_rec => p_log_level_rec);
501: return (FALSE);

Line 500: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbcs', p_log_level_rec => p_log_level_rec);

496: value2 => X_set_of_books_id, p_log_level_rec => p_log_level_rec);
497: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbcs', p_log_level_rec => p_log_level_rec);
498: return (FALSE);
499: when others then
500: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbcs', p_log_level_rec => p_log_level_rec);
501: return (FALSE);
502:
503: end FAZCBCS;
504:

Line 565: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc_clr', p_log_level_rec => p_log_level_rec);

561: return TRUE;
562:
563: exception
564: when others then
565: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc_clr', p_log_level_rec => p_log_level_rec);
566: return (FALSE);
567:
568: END fazcbc_clr;
569:

Line 617: fa_srvr_msg.add_message(calling_fn => NULL,

613: return (TRUE);
614:
615: exception
616: when NO_DATA_FOUND then
617: fa_srvr_msg.add_message(calling_fn => NULL,
618: name => 'FA_CACHE_CALENDAR_TYPES',
619: token1 => 'CALENDAR',
620: value1 => X_calendar, p_log_level_rec => p_log_level_rec);
621: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcct', p_log_level_rec => p_log_level_rec);

Line 621: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcct', p_log_level_rec => p_log_level_rec);

617: fa_srvr_msg.add_message(calling_fn => NULL,
618: name => 'FA_CACHE_CALENDAR_TYPES',
619: token1 => 'CALENDAR',
620: value1 => X_calendar, p_log_level_rec => p_log_level_rec);
621: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcct', p_log_level_rec => p_log_level_rec);
622: return (FALSE);
623:
624: when others then
625: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcct', p_log_level_rec => p_log_level_rec);

Line 625: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcct', p_log_level_rec => p_log_level_rec);

621: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcct', p_log_level_rec => p_log_level_rec);
622: return (FALSE);
623:
624: when others then
625: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcct', p_log_level_rec => p_log_level_rec);
626: return (FALSE);
627:
628: end FAZCCT;
629:

Line 687: fa_srvr_msg.add_message(calling_fn => 'fa_cache_pkg.fazcff', p_log_level_rec => p_log_level_rec);

683: end loop;
684:
685: -- Get number of periods per year
686: if not fazcct (X_calendar) then
687: fa_srvr_msg.add_message(calling_fn => 'fa_cache_pkg.fazcff', p_log_level_rec => p_log_level_rec);
688: return (FALSE);
689: end if;
690:
691: h_pers_per_yr := fazcct_record.number_per_fiscal_year;

Line 769: fa_srvr_msg.add_message(calling_fn => NULL,

765: return (TRUE);
766:
767: Exception
768: when NO_DATA_FOUND then
769: fa_srvr_msg.add_message(calling_fn => NULL,
770: name => 'FA_CACHE_CALENDAR_FRAC',
771: token1 => 'CALENDAR',
772: value1 => X_calendar,
773: token2 => 'BOOK',

Line 777: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcff', p_log_level_rec => p_log_level_rec);

773: token2 => 'BOOK',
774: value2 => X_book,
775: token3 => 'FY',
776: value3 => X_fy, p_log_level_rec => p_log_level_rec);
777: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcff', p_log_level_rec => p_log_level_rec);
778: return (FALSE);
779: when others then
780: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcff', p_log_level_rec => p_log_level_rec);
781: return (FALSE);

Line 780: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcff', p_log_level_rec => p_log_level_rec);

776: value3 => X_fy, p_log_level_rec => p_log_level_rec);
777: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcff', p_log_level_rec => p_log_level_rec);
778: return (FALSE);
779: when others then
780: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcff', p_log_level_rec => p_log_level_rec);
781: return (FALSE);
782:
783: end FAZCFF;
784:

Line 867: fa_srvr_msg.add_sql_error (calling_fn => 'fa_cache_pkg.fazccl', p_log_level_rec => p_log_level_rec);

863: when no_data_found then
864: X_ceiling := 1000000000000.00;
865: return (TRUE);
866: when others then
867: fa_srvr_msg.add_sql_error (calling_fn => 'fa_cache_pkg.fazccl', p_log_level_rec => p_log_level_rec);
868: return (FALSE);
869:
870: end FAZCCL;
871:

Line 946: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbr', p_log_level_rec => p_log_level_rec);

942: X_alternate_deprn_factor := 0;
943:
944: return (TRUE);
945: when others then
946: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbr', p_log_level_rec => p_log_level_rec);
947: return (FALSE);
948:
949: end FAZCBR;
950:

Line 1027: fa_srvr_msg.add_message(calling_fn => NULL,

1023: return (TRUE);
1024:
1025: exception
1026: when NO_DATA_FOUND then
1027: fa_srvr_msg.add_message(calling_fn => NULL,
1028: name => 'FA_CACHE_CALENDAR_PERIODS',
1029: token1 => 'CALENDAR',
1030: value1 => X_target_calendar,
1031: token2 => 'FY_NAME',

Line 1035: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);

1031: token2 => 'FY_NAME',
1032: value2 => X_target_fy_name,
1033: token3 => 'DATE',
1034: value3 => X_target_date, p_log_level_rec => p_log_level_rec);
1035: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
1036: return (FALSE);
1037: when others then
1038: fa_srvr_msg.add_sql_error ( calling_fn => 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
1039: return (FALSE);

Line 1038: fa_srvr_msg.add_sql_error ( calling_fn => 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);

1034: value3 => X_target_date, p_log_level_rec => p_log_level_rec);
1035: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
1036: return (FALSE);
1037: when others then
1038: fa_srvr_msg.add_sql_error ( calling_fn => 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
1039: return (FALSE);
1040:
1041: end FAZCCP;
1042:

Line 1093: fa_srvr_msg.add_message(calling_fn => NULL,

1089: return (TRUE);
1090:
1091: exception
1092: when NO_DATA_FOUND then
1093: fa_srvr_msg.add_message(calling_fn => NULL,
1094: name => 'FA_CACHE_CATEGORY_BOOKS',
1095: token1 => 'CATEGORY_ID',
1096: value1 => X_cat_id,
1097: token2 => 'BOOK',

Line 1099: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccb', p_log_level_rec => p_log_level_rec);

1095: token1 => 'CATEGORY_ID',
1096: value1 => X_cat_id,
1097: token2 => 'BOOK',
1098: value2 => X_book, p_log_level_rec => p_log_level_rec);
1099: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccb', p_log_level_rec => p_log_level_rec);
1100: return (FALSE);
1101: when others then
1102: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccb', p_log_level_rec => p_log_level_rec);
1103: return (FALSE);

Line 1102: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccb', p_log_level_rec => p_log_level_rec);

1098: value2 => X_book, p_log_level_rec => p_log_level_rec);
1099: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccb', p_log_level_rec => p_log_level_rec);
1100: return (FALSE);
1101: when others then
1102: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccb', p_log_level_rec => p_log_level_rec);
1103: return (FALSE);
1104:
1105: end fazccb;
1106:

Line 1406: fa_srvr_msg.add_message(calling_fn => NULL,

1402:
1403: exception
1404: when NO_DATA_FOUND then
1405: if (l_table_name = 'METHODS')then
1406: fa_srvr_msg.add_message(calling_fn => NULL,
1407: name => 'FA_CACHE_METHODS',
1408: token1 => 'METHOD',
1409: value1 => X_method,
1410: token2 => 'LIFE',

Line 1413: fa_srvr_msg.add_message(calling_fn => NULL,

1409: value1 => X_method,
1410: token2 => 'LIFE',
1411: value2 => X_life, p_log_level_rec => p_log_level_rec);
1412: else
1413: fa_srvr_msg.add_message(calling_fn => NULL,
1414: name => 'FA_CACHE_DEPRN_BASIS_RULES',
1415: token1 => 'RULE_ID',
1416: value1 => fazccmt_record.deprn_basis_rule_id, p_log_level_rec => p_log_level_rec);
1417: end if;

Line 1419: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);

1415: token1 => 'RULE_ID',
1416: value1 => fazccmt_record.deprn_basis_rule_id, p_log_level_rec => p_log_level_rec);
1417: end if;
1418:
1419: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
1420: return (FALSE);
1421:
1422: when others then
1423: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);

Line 1423: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);

1419: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
1420: return (FALSE);
1421:
1422: when others then
1423: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccmt', p_log_level_rec => p_log_level_rec);
1424: return (False);
1425:
1426: end FAZCCMT;
1427:

Line 1481: fa_srvr_msg.add_message(calling_fn => NULL,

1477: return (TRUE);
1478:
1479: exception
1480: when NO_DATA_FOUND then
1481: fa_srvr_msg.add_message(calling_fn => NULL,
1482: name => 'FA_CACHE_SETS_OF_BOOKS',
1483: token1 => 'SET_OF_BOOKS_ID',
1484: value1 => X_set_of_books_id, p_log_level_rec => p_log_level_rec);
1485: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsob', p_log_level_rec => p_log_level_rec);

Line 1485: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsob', p_log_level_rec => p_log_level_rec);

1481: fa_srvr_msg.add_message(calling_fn => NULL,
1482: name => 'FA_CACHE_SETS_OF_BOOKS',
1483: token1 => 'SET_OF_BOOKS_ID',
1484: value1 => X_set_of_books_id, p_log_level_rec => p_log_level_rec);
1485: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsob', p_log_level_rec => p_log_level_rec);
1486: return (FALSE);
1487: when others then
1488: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsob', p_log_level_rec => p_log_level_rec);
1489: return(FALSE);

Line 1488: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsob', p_log_level_rec => p_log_level_rec);

1484: value1 => X_set_of_books_id, p_log_level_rec => p_log_level_rec);
1485: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsob', p_log_level_rec => p_log_level_rec);
1486: return (FALSE);
1487: when others then
1488: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsob', p_log_level_rec => p_log_level_rec);
1489: return(FALSE);
1490:
1491: end fazcsob;
1492:

Line 1576: fa_srvr_msg.add_message(calling_fn => NULL,

1572: return (TRUE);
1573:
1574: exception
1575: when NO_DATA_FOUND then
1576: fa_srvr_msg.add_message(calling_fn => NULL,
1577: name => 'FA_CACHE_CATEGORY_BOOK_DEF',
1578: token1 => 'BOOK',
1579: value1 => X_book,
1580: token2 => 'CATEGORY_ID',

Line 1584: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccbd', p_log_level_rec => p_log_level_rec);

1580: token2 => 'CATEGORY_ID',
1581: value2 => X_cat_id,
1582: token3 => 'DATE',
1583: value3 => to_date(X_jdpis, 'J'));
1584: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccbd', p_log_level_rec => p_log_level_rec);
1585: return (FALSE);
1586:
1587: when others then
1588: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccbd', p_log_level_rec => p_log_level_rec);

Line 1588: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccbd', p_log_level_rec => p_log_level_rec);

1584: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccbd', p_log_level_rec => p_log_level_rec);
1585: return (FALSE);
1586:
1587: when others then
1588: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccbd', p_log_level_rec => p_log_level_rec);
1589: return (FALSE);
1590:
1591: end fazccbd;
1592:

Line 1664: fa_srvr_msg.add_message(calling_fn => NULL,

1660: return (TRUE);
1661:
1662: exception
1663: when NO_DATA_FOUND then
1664: fa_srvr_msg.add_message(calling_fn => NULL,
1665: name => 'FA_CACHE_CATEGORIES',
1666: token1 => 'CATEGORY',
1667: value1 => X_cat_id, p_log_level_rec => p_log_level_rec);
1668: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcat', p_log_level_rec => p_log_level_rec);

Line 1668: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcat', p_log_level_rec => p_log_level_rec);

1664: fa_srvr_msg.add_message(calling_fn => NULL,
1665: name => 'FA_CACHE_CATEGORIES',
1666: token1 => 'CATEGORY',
1667: value1 => X_cat_id, p_log_level_rec => p_log_level_rec);
1668: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcat', p_log_level_rec => p_log_level_rec);
1669: return (FALSE);
1670:
1671: when others then
1672: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcat', p_log_level_rec => p_log_level_rec);

Line 1672: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcat', p_log_level_rec => p_log_level_rec);

1668: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcat', p_log_level_rec => p_log_level_rec);
1669: return (FALSE);
1670:
1671: when others then
1672: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcat', p_log_level_rec => p_log_level_rec);
1673: return (FALSE);
1674:
1675: end fazcat;
1676:

Line 1697: fa_srvr_msg.add_message(calling_fn => NULL,

1693: return (TRUE);
1694:
1695: exception
1696: when NO_DATA_FOUND then
1697: fa_srvr_msg.add_message(calling_fn => NULL,
1698: name => 'FA_SYSTEM_CONTROLS', p_log_level_rec => p_log_level_rec);
1699: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazsys', p_log_level_rec => p_log_level_rec);
1700: return (FALSE);
1701:

Line 1699: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazsys', p_log_level_rec => p_log_level_rec);

1695: exception
1696: when NO_DATA_FOUND then
1697: fa_srvr_msg.add_message(calling_fn => NULL,
1698: name => 'FA_SYSTEM_CONTROLS', p_log_level_rec => p_log_level_rec);
1699: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazsys', p_log_level_rec => p_log_level_rec);
1700: return (FALSE);
1701:
1702: when others then
1703: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazsys', p_log_level_rec => p_log_level_rec);

Line 1703: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazsys', p_log_level_rec => p_log_level_rec);

1699: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazsys', p_log_level_rec => p_log_level_rec);
1700: return (FALSE);
1701:
1702: when others then
1703: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazsys', p_log_level_rec => p_log_level_rec);
1704: return (FALSE);
1705:
1706: end FAZSYS;
1707:

Line 1833: fa_srvr_msg.add_message(calling_fn => NULL,

1829: return (TRUE);
1830:
1831: exception
1832: when NO_DATA_FOUND then
1833: fa_srvr_msg.add_message(calling_fn => NULL,
1834: name => 'FA_CACHE_BOOK_CONTROLS',
1835: token1 => 'BOOK',
1836: value1 => X_corp_book, p_log_level_rec => p_log_level_rec);
1837: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazctbk', p_log_level_rec => p_log_level_rec);

Line 1837: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazctbk', p_log_level_rec => p_log_level_rec);

1833: fa_srvr_msg.add_message(calling_fn => NULL,
1834: name => 'FA_CACHE_BOOK_CONTROLS',
1835: token1 => 'BOOK',
1836: value1 => X_corp_book, p_log_level_rec => p_log_level_rec);
1837: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazctbk', p_log_level_rec => p_log_level_rec);
1838: return (FALSE);
1839:
1840: when others then
1841: fa_srvr_msg.add_sql_error (calling_fn => 'fa_cache_pkg.fazctbk', p_log_level_rec => p_log_level_rec);

Line 1841: fa_srvr_msg.add_sql_error (calling_fn => 'fa_cache_pkg.fazctbk', p_log_level_rec => p_log_level_rec);

1837: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazctbk', p_log_level_rec => p_log_level_rec);
1838: return (FALSE);
1839:
1840: when others then
1841: fa_srvr_msg.add_sql_error (calling_fn => 'fa_cache_pkg.fazctbk', p_log_level_rec => p_log_level_rec);
1842: return (FALSE);
1843:
1844: end fazctbk;
1845:

Line 1949: fa_srvr_msg.add_sql_error (calling_fn => 'fa_cache_pkg.fazcrsob', p_log_level_rec => p_log_level_rec);

1945: return (TRUE);
1946:
1947: exception
1948: when others then
1949: fa_srvr_msg.add_sql_error (calling_fn => 'fa_cache_pkg.fazcrsob', p_log_level_rec => p_log_level_rec);
1950: return (FALSE);
1951:
1952: end fazcrsob;
1953:

Line 2027: fa_srvr_msg.add_message(calling_fn => NULL,

2023: return (TRUE);
2024:
2025: exception
2026: when NO_DATA_FOUND then
2027: fa_srvr_msg.add_message(calling_fn => NULL,
2028: name => 'FA_CACHE_CONVENTION_TYPES',
2029: token1 => 'CONVENTION',
2030: value1 => X_prorate_convention_code,
2031: token2 => 'FISCAL_YEAR_NAME',

Line 2033: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccvt', p_log_level_rec => p_log_level_rec);

2029: token1 => 'CONVENTION',
2030: value1 => X_prorate_convention_code,
2031: token2 => 'FISCAL_YEAR_NAME',
2032: value2 => X_fiscal_year_name, p_log_level_rec => p_log_level_rec);
2033: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccvt', p_log_level_rec => p_log_level_rec);
2034: return (FALSE);
2035: when others then
2036: fa_srvr_msg.add_sql_error (
2037: calling_fn => 'fa_cache_pkg.fazccvt', p_log_level_rec => p_log_level_rec);

Line 2036: fa_srvr_msg.add_sql_error (

2032: value2 => X_fiscal_year_name, p_log_level_rec => p_log_level_rec);
2033: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccvt', p_log_level_rec => p_log_level_rec);
2034: return (FALSE);
2035: when others then
2036: fa_srvr_msg.add_sql_error (
2037: calling_fn => 'fa_cache_pkg.fazccvt', p_log_level_rec => p_log_level_rec);
2038: return (FALSE);
2039: end fazccvt;
2040:

Line 2115: fa_srvr_msg.add_message(calling_fn => NULL,

2111: return (TRUE);
2112:
2113: exception
2114: when NO_DATA_FOUND then
2115: fa_srvr_msg.add_message(calling_fn => NULL,
2116: name => 'FA_CACHE_FISCAL_YEARS',
2117: token1 => 'FY_NAME',
2118: value1 => X_fiscal_year_name,
2119: token2 => 'FY',

Line 2121: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcfy', p_log_level_rec => p_log_level_rec);

2117: token1 => 'FY_NAME',
2118: value1 => X_fiscal_year_name,
2119: token2 => 'FY',
2120: value2 => X_fiscal_year, p_log_level_rec => p_log_level_rec);
2121: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcfy', p_log_level_rec => p_log_level_rec);
2122: return (FALSE);
2123:
2124: when others then
2125: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcfy', p_log_level_rec => p_log_level_rec);

Line 2125: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcfy', p_log_level_rec => p_log_level_rec);

2121: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcfy', p_log_level_rec => p_log_level_rec);
2122: return (FALSE);
2123:
2124: when others then
2125: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcfy', p_log_level_rec => p_log_level_rec);
2126: return (FALSE);
2127: end fazcfy;
2128:
2129: -----------------------------------------------------------------------------

Line 2263: fa_srvr_msg.add_message(calling_fn => NULL,

2259: return (TRUE);
2260:
2261: exception
2262: when NO_DATA_FOUND then
2263: fa_srvr_msg.add_message(calling_fn => NULL,
2264: name => 'FA_CACHE_DEPRN_PERIODS',
2265: token1 => 'BOOK',
2266: value1 => X_book_type_code,
2267: token2 => 'PERIOD_COUNTER',

Line 2271: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcdp', p_log_level_rec => p_log_level_rec);

2267: token2 => 'PERIOD_COUNTER',
2268: value2 => X_period_counter,
2269: token3 => 'DATE',
2270: value3 => X_effective_date, p_log_level_rec => p_log_level_rec);
2271: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcdp', p_log_level_rec => p_log_level_rec);
2272: return (FALSE);
2273:
2274: when others then
2275: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcdp', p_log_level_rec => p_log_level_rec);

Line 2275: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcdp', p_log_level_rec => p_log_level_rec);

2271: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcdp', p_log_level_rec => p_log_level_rec);
2272: return (FALSE);
2273:
2274: when others then
2275: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcdp', p_log_level_rec => p_log_level_rec);
2276: return (FALSE);
2277: end fazcdp;
2278:
2279: -----------------------------------------------------------------------------

Line 2314: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcdp_clr', p_log_level_rec => p_log_level_rec);

2310: return TRUE;
2311:
2312: exception
2313: when others then
2314: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcdp_clr', p_log_level_rec => p_log_level_rec);
2315: return (FALSE);
2316:
2317: END fazcdp_clr;
2318:

Line 2447: fa_srvr_msg.add_message(calling_fn => 'fa_cache_pkg.fazprof');

2443: return true;
2444:
2445: EXCEPTION
2446: WHEN fazprof_err then
2447: fa_srvr_msg.add_message(calling_fn => 'fa_cache_pkg.fazprof');
2448: return (FALSE);
2449:
2450: WHEN others then
2451: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazprof');

Line 2451: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazprof');

2447: fa_srvr_msg.add_message(calling_fn => 'fa_cache_pkg.fazprof');
2448: return (FALSE);
2449:
2450: WHEN others then
2451: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazprof');
2452: return (FALSE);
2453:
2454: END fazprof;
2455:

Line 2589: fa_srvr_msg.add_message(calling_fn => NULL,

2585: return (TRUE);
2586:
2587: exception
2588: when NO_DATA_FOUND then
2589: fa_srvr_msg.add_message(calling_fn => NULL,
2590: name => 'FA_CACHE_SUPER_GROUP_RULES',
2591: token1 => 'BOOK',
2592: value1 => X_book_type_code,
2593: token2 => 'PERIOD_COUNTER',

Line 2595: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsgr', p_log_level_rec => p_log_level_rec);

2591: token1 => 'BOOK',
2592: value1 => X_book_type_code,
2593: token2 => 'PERIOD_COUNTER',
2594: value2 => X_period_counter, p_log_level_rec => p_log_level_rec);
2595: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsgr', p_log_level_rec => p_log_level_rec);
2596: return (FALSE);
2597:
2598: when others then
2599: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsgr', p_log_level_rec => p_log_level_rec);

Line 2599: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsgr', p_log_level_rec => p_log_level_rec);

2595: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsgr', p_log_level_rec => p_log_level_rec);
2596: return (FALSE);
2597:
2598: when others then
2599: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsgr', p_log_level_rec => p_log_level_rec);
2600: return (FALSE);
2601: end fazcsgr;
2602:
2603: -----------------------------------------------------------------------------

Line 2635: fa_srvr_msg.add_message(calling_fn => 'fa_cache_pkg.fazarel');

2631: return (TRUE);
2632:
2633: Exception
2634: when fazarel_err then
2635: fa_srvr_msg.add_message(calling_fn => 'fa_cache_pkg.fazarel');
2636: return (FALSE);
2637:
2638: when others then
2639: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazarel');

Line 2639: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazarel');

2635: fa_srvr_msg.add_message(calling_fn => 'fa_cache_pkg.fazarel');
2636: return (FALSE);
2637:
2638: when others then
2639: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazarel');
2640: return (FALSE);
2641:
2642: end FAZAREL;
2643: