APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on FA_CACHE_PKG

Line 523: IF NOT fa_cache_pkg.fazcbc(X_book => get_fa_dtls_rec.book_type_code) THEN

519: -- loop thru all the FA books for the asset and for each book check the fa validations
520: FOR get_fa_dtls_rec IN get_fa_dtls_csr (p_kle_id) LOOP
521:
522: -- call cache for book details
523: IF NOT fa_cache_pkg.fazcbc(X_book => get_fa_dtls_rec.book_type_code) THEN
524:
525: -- message : error during FA check for contract CONTRACT_NUMBER.
526: OKL_API.set_message (
527: p_app_name => 'OKL',

Line 537: IF NOT fa_cache_pkg.fazcfy

533:
534: END IF;
535:
536: -- call the cache for fiscal year details
537: IF NOT fa_cache_pkg.fazcfy
538:
539: (X_fiscal_year_name => fa_cache_pkg.fazcbc_record.fiscal_year_name,
540:
541: X_fiscal_year => fa_cache_pkg.fazcbc_record.current_fiscal_year) THEN

Line 539: (X_fiscal_year_name => fa_cache_pkg.fazcbc_record.fiscal_year_name,

535:
536: -- call the cache for fiscal year details
537: IF NOT fa_cache_pkg.fazcfy
538:
539: (X_fiscal_year_name => fa_cache_pkg.fazcbc_record.fiscal_year_name,
540:
541: X_fiscal_year => fa_cache_pkg.fazcbc_record.current_fiscal_year) THEN
542:
543: -- message : error during FA check for contract CONTRACT_NUMBER.

Line 541: X_fiscal_year => fa_cache_pkg.fazcbc_record.current_fiscal_year) THEN

537: IF NOT fa_cache_pkg.fazcfy
538:
539: (X_fiscal_year_name => fa_cache_pkg.fazcbc_record.fiscal_year_name,
540:
541: X_fiscal_year => fa_cache_pkg.fazcbc_record.current_fiscal_year) THEN
542:
543: -- message : error during FA check for contract CONTRACT_NUMBER.
544: OKL_API.set_message (
545: p_app_name => 'OKL',

Line 558: IF NOT fa_cache_pkg.fazcdp(X_book_type_code => get_fa_dtls_rec.book_type_code) THEN

554: -- check for FA fiscal year check to make sure trn date is not before current fiscal year date
555: IF p_check_fa_year = 'Y' THEN
556:
557: -- rmunjulu 4384945
558: IF NOT fa_cache_pkg.fazcdp(X_book_type_code => get_fa_dtls_rec.book_type_code) THEN
559:
560: -- message : error during FA check Deprn Period information.
561: OKL_API.set_message (
562: p_app_name => 'OKL',

Line 572: -- CDUBEY for Bug 5181502, fa_cache_pkg is not refreshed with the current close period, so have quried the data from the table directly

568: END IF;
569:
570: -- if okl transaction date before current fiscal year then raise error
571:
572: -- CDUBEY for Bug 5181502, fa_cache_pkg is not refreshed with the current close period, so have quried the data from the table directly
573: SELECT calendar_period_close_date INTO p_calendar_period_close_date FROM fa_deprn_periods WHERE book_type_code = get_fa_dtls_rec.book_type_code AND period_close_date is null;
574:
575: IF (trunc(p_trn_date) < trunc(fa_cache_pkg.fazcfy_record.start_date)) THEN -- rmunjulu 4384945
576:

Line 575: IF (trunc(p_trn_date) < trunc(fa_cache_pkg.fazcfy_record.start_date)) THEN -- rmunjulu 4384945

571:
572: -- CDUBEY for Bug 5181502, fa_cache_pkg is not refreshed with the current close period, so have quried the data from the table directly
573: SELECT calendar_period_close_date INTO p_calendar_period_close_date FROM fa_deprn_periods WHERE book_type_code = get_fa_dtls_rec.book_type_code AND period_close_date is null;
574:
575: IF (trunc(p_trn_date) < trunc(fa_cache_pkg.fazcfy_record.start_date)) THEN -- rmunjulu 4384945
576:
577: -- message Quote Effective From date EFFECTIVE_DATE can not be before Fixed Assets fiscal year start date START_DATE.
578: OKL_API.set_message (
579: p_app_name => 'OKL',

Line 584: p_token2_value =>trunc(fa_cache_pkg.fazcfy_record.start_date));

580: p_msg_name => 'OKL_AM_ERR_FA_YEAR_START_DATE',
581: p_token1 => 'EFFECTIVE_DATE',
582: p_token1_value => trunc(p_trn_date),
583: p_token2 => 'START_DATE',
584: p_token2_value =>trunc(fa_cache_pkg.fazcfy_record.start_date));
585:
586: RAISE fa_exception;
587:
588: -- rmunjulu 4384945 if okl transaction date after Fixed Assets calendar period close date

Line 605: l_fa_fiscal_year := to_char(fa_cache_pkg.fazcbc_record.current_fiscal_year);

601: END IF;
602:
603: /*
604: -- rmunjulu Bug 4143251 Added check to make sure quote effective from date falls in current FA fiscal year
605: l_fa_fiscal_year := to_char(fa_cache_pkg.fazcbc_record.current_fiscal_year);
606: l_quote_eff_year := substr(to_char(p_trn_date,'MM/DD/YYYY'),7);
607:
608: -- If FA Fiscal year and quote effective date year do not match then error
609: IF l_fa_fiscal_year <> l_quote_eff_year THEN