363: return (TRUE);
364:
365: exception
366: when NO_DATA_FOUND then
367: fa_srvr_msg.add_message(calling_fn => NULL,
368: name => 'FA_CACHE_BOOK_CONTROLS',
369: token1 => 'BOOK',
370: value1 => X_book
371: ,p_log_level_rec => p_log_level_rec);
368: name => 'FA_CACHE_BOOK_CONTROLS',
369: token1 => 'BOOK',
370: value1 => X_book
371: ,p_log_level_rec => p_log_level_rec);
372: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc'
373: ,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'
372: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc'
373: ,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'
377: ,p_log_level_rec => p_log_level_rec);
378: return (false);
379: when others then
380: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc'
376: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc'
377: ,p_log_level_rec => p_log_level_rec);
378: return (false);
379: when others then
380: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc'
381: ,p_log_level_rec => p_log_level_rec);
382: return (FALSE);
383:
384: end FAZCBC;
404: if not fazcsob
405: (X_set_of_books_id => h_set_of_books_id,
406: X_mrc_sob_type_code => h_reporting_flag,
407: p_log_level_rec => p_log_level_rec) then
408: fa_srvr_msg.add_sql_error
409: (calling_fn => 'fa_cache_pkg.fazcbcs'
410: ,p_log_level_rec => p_log_level_rec);
411: return(FALSE);
412: end if;
743: return (TRUE);
744:
745: exception
746: when NO_DATA_FOUND then
747: fa_srvr_msg.add_message(calling_fn => NULL,
748: name => 'FA_CACHE_MC_BOOK_CONTROLS',
749: token1 => 'BOOK',
750: value1 => X_book,
751: token2 => 'SET_OF_BOOKS_ID',
750: value1 => X_book,
751: token2 => 'SET_OF_BOOKS_ID',
752: value2 => h_set_of_books_id
753: ,p_log_level_rec => p_log_level_rec);
754: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbcs'
755: ,p_log_level_rec => p_log_level_rec);
756: return (FALSE);
757: when others then
758: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbcs'
754: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbcs'
755: ,p_log_level_rec => p_log_level_rec);
756: return (FALSE);
757: when others then
758: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbcs'
759: ,p_log_level_rec => p_log_level_rec);
760: return (FALSE);
761:
762: end FAZCBCS;
821: return TRUE;
822:
823: exception
824: when others then
825: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbc_clr'
826: ,p_log_level_rec => p_log_level_rec);
827: return (FALSE);
828:
829: END fazcbc_clr;
874: return (TRUE);
875:
876: exception
877: when NO_DATA_FOUND then
878: fa_srvr_msg.add_message(calling_fn => NULL,
879: name => 'FA_CACHE_CALENDAR_TYPES',
880: token1 => 'CALENDAR',
881: value1 => X_calendar
882: ,p_log_level_rec => p_log_level_rec);
879: name => 'FA_CACHE_CALENDAR_TYPES',
880: token1 => 'CALENDAR',
881: value1 => X_calendar
882: ,p_log_level_rec => p_log_level_rec);
883: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcct'
884: ,p_log_level_rec => p_log_level_rec);
885: return (FALSE);
886:
887: when others then
884: ,p_log_level_rec => p_log_level_rec);
885: return (FALSE);
886:
887: when others then
888: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcct'
889: ,p_log_level_rec => p_log_level_rec);
890: return (FALSE);
891:
892: end FAZCCT;
947:
948: -- Get number of periods per year
949: if not fazcct (X_calendar,
950: p_log_level_rec => p_log_level_rec) then
951: fa_srvr_msg.add_message(calling_fn => 'fa_cache_pkg.fazcff'
952: ,p_log_level_rec => p_log_level_rec);
953: return (FALSE);
954: end if;
955:
1030: return (TRUE);
1031:
1032: Exception
1033: when NO_DATA_FOUND then
1034: fa_srvr_msg.add_message(calling_fn => NULL,
1035: name => 'FA_CACHE_CALENDAR_FRAC',
1036: token1 => 'CALENDAR',
1037: value1 => X_calendar,
1038: token2 => 'BOOK',
1039: value2 => X_book,
1040: token3 => 'FY',
1041: value3 => X_fy
1042: ,p_log_level_rec => p_log_level_rec);
1043: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcff'
1044: ,p_log_level_rec => p_log_level_rec);
1045: return (FALSE);
1046: when others then
1047: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcff'
1043: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcff'
1044: ,p_log_level_rec => p_log_level_rec);
1045: return (FALSE);
1046: when others then
1047: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcff'
1048: ,p_log_level_rec => p_log_level_rec);
1049: return (FALSE);
1050:
1051: end FAZCFF;
1130: when no_data_found then
1131: X_ceiling := 1000000000000.00;
1132: return (TRUE);
1133: when others then
1134: fa_srvr_msg.add_sql_error (calling_fn => 'fa_cache_pkg.fazccl'
1135: ,p_log_level_rec => p_log_level_rec);
1136: return (FALSE);
1137:
1138: end FAZCCL;
1210: X_alternate_deprn_factor := 0;
1211:
1212: return (TRUE);
1213: when others then
1214: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbr'
1215: ,p_log_level_rec => p_log_level_rec);
1216: return (FALSE);
1217:
1218: end FAZCBR;
1292: return (TRUE);
1293:
1294: exception
1295: when NO_DATA_FOUND then
1296: fa_srvr_msg.add_message(calling_fn => NULL,
1297: name => 'FA_CACHE_CALENDAR_PERIODS',
1298: token1 => 'CALENDAR',
1299: value1 => X_target_calendar,
1300: token2 => 'FY_NAME',
1301: value2 => X_target_fy_name,
1302: token3 => 'DATE',
1303: value3 => X_target_date
1304: ,p_log_level_rec => p_log_level_rec);
1305: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccp'
1306: ,p_log_level_rec => p_log_level_rec);
1307: return (FALSE);
1308: when others then
1309: fa_srvr_msg.add_sql_error ( calling_fn => 'fa_cache_pkg.fazccp'
1305: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccp'
1306: ,p_log_level_rec => p_log_level_rec);
1307: return (FALSE);
1308: when others then
1309: fa_srvr_msg.add_sql_error ( calling_fn => 'fa_cache_pkg.fazccp'
1310: ,p_log_level_rec => p_log_level_rec);
1311: return (FALSE);
1312:
1313: end FAZCCP;
1362: return (TRUE);
1363:
1364: exception
1365: when NO_DATA_FOUND then
1366: fa_srvr_msg.add_message(calling_fn => NULL,
1367: name => 'FA_CACHE_CATEGORY_BOOKS',
1368: token1 => 'CATEGORY_ID',
1369: value1 => X_cat_id,
1370: token2 => 'BOOK',
1369: value1 => X_cat_id,
1370: token2 => 'BOOK',
1371: value2 => X_book
1372: ,p_log_level_rec => p_log_level_rec);
1373: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccb'
1374: ,p_log_level_rec => p_log_level_rec);
1375: return (FALSE);
1376: when others then
1377: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccb'
1373: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccb'
1374: ,p_log_level_rec => p_log_level_rec);
1375: return (FALSE);
1376: when others then
1377: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccb'
1378: ,p_log_level_rec => p_log_level_rec);
1379: return (FALSE);
1380:
1381: end fazccb;
1655:
1656: exception
1657: when NO_DATA_FOUND then
1658: if (l_table_name = 'METHODS')then
1659: fa_srvr_msg.add_message(calling_fn => NULL,
1660: name => 'FA_CACHE_METHODS',
1661: token1 => 'METHOD',
1662: value1 => X_method,
1663: token2 => 'LIFE',
1663: token2 => 'LIFE',
1664: value2 => X_life
1665: ,p_log_level_rec => p_log_level_rec);
1666: else
1667: fa_srvr_msg.add_message(calling_fn => NULL,
1668: name => 'FA_CACHE_DEPRN_BASIS_RULES',
1669: token1 => 'RULE_ID',
1670: value1 => fazccmt_record.deprn_basis_rule_id
1671: ,p_log_level_rec => p_log_level_rec);
1670: value1 => fazccmt_record.deprn_basis_rule_id
1671: ,p_log_level_rec => p_log_level_rec);
1672: end if;
1673:
1674: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccmt'
1675: ,p_log_level_rec => p_log_level_rec);
1676: return (FALSE);
1677:
1678: when others then
1675: ,p_log_level_rec => p_log_level_rec);
1676: return (FALSE);
1677:
1678: when others then
1679: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccmt'
1680: ,p_log_level_rec => p_log_level_rec);
1681: return (False);
1682:
1683: end FAZCCMT;
1735: return (TRUE);
1736:
1737: exception
1738: when NO_DATA_FOUND then
1739: fa_srvr_msg.add_message(calling_fn => NULL,
1740: name => 'FA_CACHE_SETS_OF_BOOKS',
1741: token1 => 'SET_OF_BOOKS_ID',
1742: value1 => X_set_of_books_id
1743: ,p_log_level_rec => p_log_level_rec);
1740: name => 'FA_CACHE_SETS_OF_BOOKS',
1741: token1 => 'SET_OF_BOOKS_ID',
1742: value1 => X_set_of_books_id
1743: ,p_log_level_rec => p_log_level_rec);
1744: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsob'
1745: ,p_log_level_rec => p_log_level_rec);
1746: return (FALSE);
1747: when others then
1748: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsob'
1744: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsob'
1745: ,p_log_level_rec => p_log_level_rec);
1746: return (FALSE);
1747: when others then
1748: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsob'
1749: ,p_log_level_rec => p_log_level_rec);
1750: return(FALSE);
1751:
1752: end fazcsob;
1833: return (TRUE);
1834:
1835: exception
1836: when NO_DATA_FOUND then
1837: fa_srvr_msg.add_message(calling_fn => NULL,
1838: name => 'FA_CACHE_CATEGORY_BOOK_DEF',
1839: token1 => 'BOOK',
1840: value1 => X_book,
1841: token2 => 'CATEGORY_ID',
1841: token2 => 'CATEGORY_ID',
1842: value2 => X_cat_id,
1843: token3 => 'DATE',
1844: value3 => to_date(X_jdpis, 'J'));
1845: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccbd'
1846: ,p_log_level_rec => p_log_level_rec);
1847: return (FALSE);
1848:
1849: when others then
1846: ,p_log_level_rec => p_log_level_rec);
1847: return (FALSE);
1848:
1849: when others then
1850: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccbd'
1851: ,p_log_level_rec => p_log_level_rec);
1852: return (FALSE);
1853:
1854: end fazccbd;
1925: return (TRUE);
1926:
1927: exception
1928: when NO_DATA_FOUND then
1929: fa_srvr_msg.add_message(calling_fn => NULL,
1930: name => 'FA_CACHE_CATEGORIES',
1931: token1 => 'CATEGORY',
1932: value1 => X_cat_id
1933: ,p_log_level_rec => p_log_level_rec);
1930: name => 'FA_CACHE_CATEGORIES',
1931: token1 => 'CATEGORY',
1932: value1 => X_cat_id
1933: ,p_log_level_rec => p_log_level_rec);
1934: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcat'
1935: ,p_log_level_rec => p_log_level_rec);
1936: return (FALSE);
1937:
1938: when others then
1935: ,p_log_level_rec => p_log_level_rec);
1936: return (FALSE);
1937:
1938: when others then
1939: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcat'
1940: ,p_log_level_rec => p_log_level_rec);
1941: return (FALSE);
1942:
1943: end fazcat;
1959: return (TRUE);
1960:
1961: exception
1962: when NO_DATA_FOUND then
1963: fa_srvr_msg.add_message(calling_fn => NULL,
1964: name => 'FA_SYSTEM_CONTROLS'
1965: );
1966: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazsys'
1967: );
1962: when NO_DATA_FOUND then
1963: fa_srvr_msg.add_message(calling_fn => NULL,
1964: name => 'FA_SYSTEM_CONTROLS'
1965: );
1966: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazsys'
1967: );
1968: return (FALSE);
1969:
1970: when others then
1967: );
1968: return (FALSE);
1969:
1970: when others then
1971: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazsys'
1972: );
1973: return (FALSE);
1974:
1975: end FAZSYS;
2099: return (TRUE);
2100:
2101: exception
2102: when NO_DATA_FOUND then
2103: fa_srvr_msg.add_message(calling_fn => NULL,
2104: name => 'FA_CACHE_BOOK_CONTROLS',
2105: token1 => 'BOOK',
2106: value1 => X_corp_book
2107: ,p_log_level_rec => p_log_level_rec);
2104: name => 'FA_CACHE_BOOK_CONTROLS',
2105: token1 => 'BOOK',
2106: value1 => X_corp_book
2107: ,p_log_level_rec => p_log_level_rec);
2108: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazctbk'
2109: ,p_log_level_rec => p_log_level_rec);
2110: return (FALSE);
2111:
2112: when others then
2109: ,p_log_level_rec => p_log_level_rec);
2110: return (FALSE);
2111:
2112: when others then
2113: fa_srvr_msg.add_sql_error (calling_fn => 'fa_cache_pkg.fazctbk'
2114: ,p_log_level_rec => p_log_level_rec);
2115: return (FALSE);
2116:
2117: end fazctbk;
2219: return (TRUE);
2220:
2221: exception
2222: when others then
2223: fa_srvr_msg.add_sql_error (calling_fn => 'fa_cache_pkg.fazcrsob'
2224: ,p_log_level_rec => p_log_level_rec);
2225: return (FALSE);
2226:
2227: end fazcrsob;
2299: return (TRUE);
2300:
2301: exception
2302: when NO_DATA_FOUND then
2303: fa_srvr_msg.add_message(calling_fn => NULL,
2304: name => 'FA_CACHE_CONVENTION_TYPES',
2305: token1 => 'CONVENTION',
2306: value1 => X_prorate_convention_code,
2307: token2 => 'FISCAL_YEAR_NAME',
2306: value1 => X_prorate_convention_code,
2307: token2 => 'FISCAL_YEAR_NAME',
2308: value2 => X_fiscal_year_name
2309: ,p_log_level_rec => p_log_level_rec);
2310: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccvt'
2311: ,p_log_level_rec => p_log_level_rec);
2312: return (FALSE);
2313: when others then
2314: fa_srvr_msg.add_sql_error (
2310: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazccvt'
2311: ,p_log_level_rec => p_log_level_rec);
2312: return (FALSE);
2313: when others then
2314: fa_srvr_msg.add_sql_error (
2315: calling_fn => 'fa_cache_pkg.fazccvt'
2316: ,p_log_level_rec => p_log_level_rec);
2317: return (FALSE);
2318: end fazccvt;
2391: return (TRUE);
2392:
2393: exception
2394: when NO_DATA_FOUND then
2395: fa_srvr_msg.add_message(calling_fn => NULL,
2396: name => 'FA_CACHE_FISCAL_YEARS',
2397: token1 => 'FY_NAME',
2398: value1 => X_fiscal_year_name,
2399: token2 => 'FY',
2398: value1 => X_fiscal_year_name,
2399: token2 => 'FY',
2400: value2 => X_fiscal_year
2401: ,p_log_level_rec => p_log_level_rec);
2402: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcfy'
2403: ,p_log_level_rec => p_log_level_rec);
2404: return (FALSE);
2405:
2406: when others then
2403: ,p_log_level_rec => p_log_level_rec);
2404: return (FALSE);
2405:
2406: when others then
2407: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcfy'
2408: ,p_log_level_rec => p_log_level_rec);
2409: return (FALSE);
2410: end fazcfy;
2411:
2543: return (TRUE);
2544:
2545: exception
2546: when NO_DATA_FOUND then
2547: fa_srvr_msg.add_message(calling_fn => NULL,
2548: name => 'FA_CACHE_DEPRN_PERIODS',
2549: token1 => 'BOOK',
2550: value1 => X_book_type_code,
2551: token2 => 'PERIOD_COUNTER',
2552: value2 => X_period_counter,
2553: token3 => 'DATE',
2554: value3 => X_effective_date
2555: ,p_log_level_rec => p_log_level_rec);
2556: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcdp'
2557: ,p_log_level_rec => p_log_level_rec);
2558: return (FALSE);
2559:
2560: when others then
2557: ,p_log_level_rec => p_log_level_rec);
2558: return (FALSE);
2559:
2560: when others then
2561: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcdp'
2562: ,p_log_level_rec => p_log_level_rec);
2563: return (FALSE);
2564: end fazcdp;
2565:
2598: return TRUE;
2599:
2600: exception
2601: when others then
2602: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcdp_clr'
2603: ,p_log_level_rec => p_log_level_rec);
2604: return (FALSE);
2605:
2606: END fazcdp_clr;
2723: return true;
2724:
2725: EXCEPTION
2726: WHEN others then
2727: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazprof'
2728: );
2729: return (FALSE);
2730:
2731:
2863: return (TRUE);
2864:
2865: exception
2866: when NO_DATA_FOUND then
2867: fa_srvr_msg.add_message(calling_fn => NULL,
2868: name => 'FA_CACHE_SUPER_GROUP_RULES',
2869: token1 => 'BOOK',
2870: value1 => X_book_type_code,
2871: token2 => 'PERIOD_COUNTER',
2870: value1 => X_book_type_code,
2871: token2 => 'PERIOD_COUNTER',
2872: value2 => X_period_counter
2873: ,p_log_level_rec => p_log_level_rec);
2874: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsgr'
2875: ,p_log_level_rec => p_log_level_rec);
2876: return (FALSE);
2877:
2878: when others then
2875: ,p_log_level_rec => p_log_level_rec);
2876: return (FALSE);
2877:
2878: when others then
2879: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcsgr'
2880: ,p_log_level_rec => p_log_level_rec);
2881: return (FALSE);
2882: end fazcsgr;
2883:
2901: end if;
2902: return (TRUE);
2903: exception
2904: when fazcbcsob_err then
2905: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbcsob'
2906: ,p_log_level_rec => p_log_level_rec);
2907: return (false);
2908: when others then
2909: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbcsob'
2905: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbcsob'
2906: ,p_log_level_rec => p_log_level_rec);
2907: return (false);
2908: when others then
2909: fa_srvr_msg.add_sql_error(calling_fn => 'fa_cache_pkg.fazcbcsob'
2910: ,p_log_level_rec => p_log_level_rec);
2911: return (FALSE);
2912: end fazcbcsob;
2913: