DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on FA_FISCAL_YEAR

Line 451: -- if p_check_fa_year = Y then will check for FA fiscal year validity

447: -- Description : checks asset validity in Fixed Assets
448: -- Business Rules : FA has following restriction during adjustment/retirment
449: -- 1. You can retire retroactively only in the current fiscal year,
450: -- 2. and only after the most recent transaction date.
451: -- if p_check_fa_year = Y then will check for FA fiscal year validity
452: -- if p_check_fa_trn = Y then will check for FA transaction date validity
453: -- Parameters :
454: -- History : rmunjulu EDAT Created
455: -- : rmunjulu Bug 4143251 Added code to check quote effective date should be

Line 456: -- in FA Fiscal year

452: -- if p_check_fa_trn = Y then will check for FA transaction date validity
453: -- Parameters :
454: -- History : rmunjulu EDAT Created
455: -- : rmunjulu Bug 4143251 Added code to check quote effective date should be
456: -- in FA Fiscal year
457: -- Version : 1.0
458: --
459: -- End of comments
460: PROCEDURE check_asset_validity_in_fa(

Line 494: l_fa_fiscal_year VARCHAR2(10);

490: fa_exception EXCEPTION;
491: l_return_status VARCHAR2(3);
492:
493: -- rmunjulu Bug 4143251
494: l_fa_fiscal_year VARCHAR2(10);
495: l_quote_eff_year VARCHAR2(10);
496:
497: -- CDUBEY for Bug 5181502
498: p_calendar_period_close_date DATE;

Line 554: -- check for FA fiscal year check to make sure trn date is not before current fiscal year date

550: RAISE fa_exception;
551:
552: END IF;
553:
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

Line 604: -- rmunjulu Bug 4143251 Added check to make sure quote effective from date falls in current FA fiscal year

600: RAISE fa_exception;
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

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

Line 608: -- If FA Fiscal year and quote effective date year do not match then error

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
610:
611: -- message : Quote Effective From date EFFECTIVE_DATE should be in current fixed assets fiscal year FA_FISCAL_YEAR.
612: OKL_API.set_message (

Line 609: IF l_fa_fiscal_year <> l_quote_eff_year THEN

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
610:
611: -- message : Quote Effective From date EFFECTIVE_DATE should be in current fixed assets fiscal year FA_FISCAL_YEAR.
612: OKL_API.set_message (
613: p_app_name => 'OKL',

Line 611: -- message : Quote Effective From date EFFECTIVE_DATE should be in current fixed assets fiscal year FA_FISCAL_YEAR.

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
610:
611: -- message : Quote Effective From date EFFECTIVE_DATE should be in current fixed assets fiscal year FA_FISCAL_YEAR.
612: OKL_API.set_message (
613: p_app_name => 'OKL',
614: p_msg_name => 'OKL_AM_ERR_FA_FISCAL_YEAR',
615: p_token1 => 'EFFECTIVE_DATE',

Line 614: p_msg_name => 'OKL_AM_ERR_FA_FISCAL_YEAR',

610:
611: -- message : Quote Effective From date EFFECTIVE_DATE should be in current fixed assets fiscal year FA_FISCAL_YEAR.
612: OKL_API.set_message (
613: p_app_name => 'OKL',
614: p_msg_name => 'OKL_AM_ERR_FA_FISCAL_YEAR',
615: p_token1 => 'EFFECTIVE_DATE',
616: p_token1_value => trunc(p_trn_date),
617: p_token2 => 'FA_FISCAL_YEAR',
618: p_token2_value => l_fa_fiscal_year);

Line 617: p_token2 => 'FA_FISCAL_YEAR',

613: p_app_name => 'OKL',
614: p_msg_name => 'OKL_AM_ERR_FA_FISCAL_YEAR',
615: p_token1 => 'EFFECTIVE_DATE',
616: p_token1_value => trunc(p_trn_date),
617: p_token2 => 'FA_FISCAL_YEAR',
618: p_token2_value => l_fa_fiscal_year);
619:
620: RAISE fa_exception;
621:

Line 618: p_token2_value => l_fa_fiscal_year);

614: p_msg_name => 'OKL_AM_ERR_FA_FISCAL_YEAR',
615: p_token1 => 'EFFECTIVE_DATE',
616: p_token1_value => trunc(p_trn_date),
617: p_token2 => 'FA_FISCAL_YEAR',
618: p_token2_value => l_fa_fiscal_year);
619:
620: RAISE fa_exception;
621:
622: END IF;