[Home] [Help]
1: PACKAGE BODY FA_ASSET_VAL_PVT as
2: /* $Header: FAVVALB.pls 120.136.12020000.7 2013/03/19 18:11:01 dvjoshi ship $ */
3:
4: FUNCTION validate
5: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
6: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
2: /* $Header: FAVVALB.pls 120.136.12020000.7 2013/03/19 18:11:01 dvjoshi ship $ */
3:
4: FUNCTION validate
5: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
6: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
3:
4: FUNCTION validate
5: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
6: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
4: FUNCTION validate
5: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
6: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
12: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
5: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
6: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
12: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
13: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
6: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
12: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
13: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
14: p_calling_fn IN VARCHAR2,
7: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
12: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
13: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
14: p_calling_fn IN VARCHAR2,
15: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN boolean IS
8: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
12: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
13: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
14: p_calling_fn IN VARCHAR2,
15: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN boolean IS
16:
9: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
10: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
11: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
12: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
13: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
14: p_calling_fn IN VARCHAR2,
15: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN boolean IS
16:
17: l_distribution_count number;
11: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
12: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
13: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
14: p_calling_fn IN VARCHAR2,
15: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN boolean IS
16:
17: l_distribution_count number;
18: val_err exception;
19: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
15: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN boolean IS
16:
17: l_distribution_count number;
18: val_err exception;
19: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
20: -- Changes made as per the ER No.s 6606548 and 6606552 by Vkukutam Start
21: l_japan_tax_reform varchar2(1) := fnd_profile.value('FA_JAPAN_TAX_REFORMS');
22: -- Changes made as per the ER No.s 6606548 and 6606552 by Vkukutam End
23:
434: (p_transaction_type_code IN VARCHAR2,
435: p_asset_number IN VARCHAR2,
436: p_asset_id IN NUMBER DEFAULT NULL,
437: p_calling_fn IN VARCHAR2,
438: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
439:
440: l_count number;
441: l_asset_number number(15) := 0;
442:
561: FUNCTION validate_owned_leased
562: (p_transaction_type_code IN VARCHAR2,
563: p_owned_leased IN VARCHAR2,
564: p_calling_fn IN VARCHAR2,
565: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
566:
567: BEGIN
568:
569: if (p_owned_leased not in ('OWNED', 'LEASED')) then
585: (p_transaction_type_code IN VARCHAR2,
586: p_category_id IN NUMBER,
587: p_book_type_code IN VARCHAR2 DEFAULT NULL,
588: p_calling_fn IN VARCHAR2,
589: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
590:
591: BEGIN
592: -- Check that the category exists.
593: if not fa_cache_pkg.fazcat (
640:
641: FUNCTION validate_current_units
642: (p_transaction_type_code IN VARCHAR2,
643: p_current_units IN NUMBER,
644: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
645: BEGIN
646:
647:
648: if ((p_transaction_type_code = 'ADDITION') OR
671:
672:
673: FUNCTION validate_category_df
674: (p_transaction_type_code IN VARCHAR2,
675: p_cat_desc_flex IN FA_API_TYPES.desc_flex_rec_type,
676: p_calling_fn IN VARCHAR2,
677: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
678:
679: BEGIN
673: FUNCTION validate_category_df
674: (p_transaction_type_code IN VARCHAR2,
675: p_cat_desc_flex IN FA_API_TYPES.desc_flex_rec_type,
676: p_calling_fn IN VARCHAR2,
677: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
678:
679: BEGIN
680: -- Check that the flexfield value is valid.
681:
685: FUNCTION validate_serial_number
686: (p_transaction_type_code IN VARCHAR2,
687: p_serial_number IN VARCHAR2,
688: p_calling_fn IN VARCHAR2,
689: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
690:
691: BEGIN
692: -- CRL check?
693:
697: FUNCTION validate_asset_key
698: (p_transaction_type_code IN VARCHAR2,
699: p_asset_key_ccid IN NUMBER,
700: p_calling_fn IN VARCHAR2,
701: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
702:
703: l_required number;
704: l_is_asset_key_valid number;
705:
769: p_asset_type IN VARCHAR2,
770: p_book_type_code IN VARCHAR2,
771: p_category_id IN NUMBER,
772: p_calling_fn IN VARCHAR2,
773: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
774:
775: l_capitalize_flag varchar2(3);
776:
777: BEGIN
837:
838: FUNCTION validate_depreciate_flag
839: (p_depreciate_flag IN VARCHAR2,
840: p_calling_fn IN VARCHAR2,
841: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
842:
843: BEGIN
844:
845: if ((p_depreciate_flag <> 'YES' and
857:
858: FUNCTION validate_supplier_name
859: (p_transaction_type_code IN VARCHAR2,
860: p_calling_fn IN VARCHAR2,
861: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
862:
863: BEGIN
864: -- From vendor_name_q lov in asset workbench.
865:
872:
873: FUNCTION validate_supplier_number
874: (p_transaction_type_code IN VARCHAR2,
875: p_calling_fn IN VARCHAR2,
876: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
877:
878: BEGIN
879: -- From vendor_number_q lov in asset workbench.
880:
889: (p_transaction_type_code IN VARCHAR2,
890: p_book_type_code IN VARCHAR2,
891: p_asset_id IN NUMBER,
892: p_calling_fn IN VARCHAR2,
893: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
894:
895: l_exists number;
896:
897: BEGIN
985: END validate_asset_book;
986:
987: /*Bug 8601485 - Verify the if transfer date of asset is before DPIS */
988: FUNCTION validate_asset_transfer_date
989: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
990: p_trans_rec IN FA_API_TYPES.trans_rec_type,
991: p_calling_fn IN VARCHAR2,
992: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
993: x_same_period NUMBER := 0; -- Added for 9643505
986:
987: /*Bug 8601485 - Verify the if transfer date of asset is before DPIS */
988: FUNCTION validate_asset_transfer_date
989: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
990: p_trans_rec IN FA_API_TYPES.trans_rec_type,
991: p_calling_fn IN VARCHAR2,
992: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
993: x_same_period NUMBER := 0; -- Added for 9643505
994: l_dpis DATE;
988: FUNCTION validate_asset_transfer_date
989: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
990: p_trans_rec IN FA_API_TYPES.trans_rec_type,
991: p_calling_fn IN VARCHAR2,
992: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
993: x_same_period NUMBER := 0; -- Added for 9643505
994: l_dpis DATE;
995:
996: BEGIN
1032: p_cost IN NUMBER,
1033: p_asset_type IN VARCHAR2,
1034: p_num_invoices IN NUMBER DEFAULT 0,
1035: p_calling_fn IN VARCHAR2,
1036: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1037:
1038: BEGIN
1039: -- If asset type is CIP, cost should be zero.
1040: if ((fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') AND
1061: (p_transaction_type_code IN VARCHAR2,
1062: p_assigned_to IN NUMBER,
1063: p_date IN DATE DEFAULT sysdate,
1064: p_calling_fn IN VARCHAR2,
1065: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1066:
1067: l_rowcount number;
1068:
1069: BEGIN
1098: FUNCTION validate_location_ccid
1099: (p_transaction_type_code IN VARCHAR2,
1100: p_location_ccid IN NUMBER,
1101: p_calling_fn IN VARCHAR2,
1102: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1103:
1104: l_is_location_valid number;
1105:
1106: BEGIN
1146: p_transaction_subtype IN VARCHAR2 DEFAULT 'EXPENSED',
1147: p_asset_type IN VARCHAR2 DEFAULT NULL ,
1148: p_calling_interface IN VARCHAR2 DEFAULT NULL,
1149: p_calling_fn IN VARCHAR2,
1150: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1151: --
1152: -- NOTE: ENERGY ENHANCEMENT
1153: -- p_db_rule_name and p_rate_source_rule are added so that prior
1154: -- period date will not be allowed. p_db_rule_name is depreciable basis
1192: l_start_jdate number;
1193:
1194: l_earliest_dpis date;
1195: l_count number;
1196: l_period_rec FA_API_TYPES.period_rec_type;
1197:
1198: l_prorate_date date;
1199: l_check_prorate_date varchar2(1);
1200: l_temp_num number;
1391: (p_transaction_type_code IN VARCHAR2,
1392: p_recoverable_cost IN NUMBER,
1393: p_deprn_reserve IN NUMBER,
1394: p_calling_fn IN VARCHAR2,
1395: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1396:
1397: BEGIN
1398:
1399: if (p_deprn_reserve <> 0 and
1413: FUNCTION validate_adj_rec_cost
1414: (p_adjusted_recoverable_cost IN NUMBER,
1415: p_deprn_reserve IN NUMBER,
1416: p_calling_fn IN VARCHAR2,
1417: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1418:
1419: BEGIN
1420:
1421: /* Added if condition for bug 863321 */
1438:
1439: END validate_adj_rec_cost;
1440:
1441: FUNCTION validate_ytd_reserve /*Bug#9682863 - Modified the parameters/body - using recs now instead of individual parameter. */
1442: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1443: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1444: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1445: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
1446: p_period_rec IN FA_API_TYPES.period_rec_type,
1439: END validate_adj_rec_cost;
1440:
1441: FUNCTION validate_ytd_reserve /*Bug#9682863 - Modified the parameters/body - using recs now instead of individual parameter. */
1442: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1443: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1444: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1445: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
1446: p_period_rec IN FA_API_TYPES.period_rec_type,
1447: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type, /*Fix for bug 8790562 */
1440:
1441: FUNCTION validate_ytd_reserve /*Bug#9682863 - Modified the parameters/body - using recs now instead of individual parameter. */
1442: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1443: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1444: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1445: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
1446: p_period_rec IN FA_API_TYPES.period_rec_type,
1447: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type, /*Fix for bug 8790562 */
1448: p_calling_fn IN VARCHAR2,
1441: FUNCTION validate_ytd_reserve /*Bug#9682863 - Modified the parameters/body - using recs now instead of individual parameter. */
1442: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1443: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1444: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1445: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
1446: p_period_rec IN FA_API_TYPES.period_rec_type,
1447: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type, /*Fix for bug 8790562 */
1448: p_calling_fn IN VARCHAR2,
1449: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
1442: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
1443: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1444: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1445: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
1446: p_period_rec IN FA_API_TYPES.period_rec_type,
1447: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type, /*Fix for bug 8790562 */
1448: p_calling_fn IN VARCHAR2,
1449: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
1450:
1443: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
1444: p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
1445: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
1446: p_period_rec IN FA_API_TYPES.period_rec_type,
1447: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type, /*Fix for bug 8790562 */
1448: p_calling_fn IN VARCHAR2,
1449: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
1450:
1451: l_current_fiscal_year FA_BOOK_CONTROLS.current_fiscal_year%TYPE;
1445: p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
1446: p_period_rec IN FA_API_TYPES.period_rec_type,
1447: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type, /*Fix for bug 8790562 */
1448: p_calling_fn IN VARCHAR2,
1449: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
1450:
1451: l_current_fiscal_year FA_BOOK_CONTROLS.current_fiscal_year%TYPE;
1452: l_fiscal_year_name FA_BOOK_CONTROLS.fiscal_year_name%TYPE;
1453:
1556: px_orig_deprn_start_date IN OUT NOCOPY DATE,
1557: p_date_placed_in_service IN DATE,
1558: p_ytd_deprn IN NUMBER,
1559: p_deprn_reserve IN NUMBER,
1560: p_period_rec IN FA_API_TYPES.period_rec_type,
1561: p_calling_fn IN VARCHAR2,
1562: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1563:
1564: l_abs_ytd_deprn number;
1558: p_ytd_deprn IN NUMBER,
1559: p_deprn_reserve IN NUMBER,
1560: p_period_rec IN FA_API_TYPES.period_rec_type,
1561: p_calling_fn IN VARCHAR2,
1562: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1563:
1564: l_abs_ytd_deprn number;
1565: l_abs_deprn_reserve number;
1566:
1658: FUNCTION validate_trx_date_entered
1659: (p_transaction_type_code IN VARCHAR2,
1660: p_book_type_code IN VARCHAR2,
1661: p_transaction_date_entered IN DATE,
1662: p_period_rec IN FA_API_TYPES.period_rec_type,
1663: p_calling_fn IN VARCHAR2,
1664: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1665:
1666: begin
1660: p_book_type_code IN VARCHAR2,
1661: p_transaction_date_entered IN DATE,
1662: p_period_rec IN FA_API_TYPES.period_rec_type,
1663: p_calling_fn IN VARCHAR2,
1664: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1665:
1666: begin
1667:
1668: if (p_transaction_date_entered > p_period_rec.calendar_period_close_date) then
1681: p_asset_id IN NUMBER,
1682: p_book_type_code IN VARCHAR2,
1683: p_date_placed_in_service IN DATE DEFAULT NULL,
1684: p_conversion_date IN DATE DEFAULT NULL,
1685: p_period_rec IN FA_API_TYPES.period_rec_type,
1686: p_amortization_start_date IN DATE,
1687: p_db_rule_name IN VARCHAR2 DEFAULT NULL, -- ENERGY
1688: p_rate_source_rule IN VARCHAR2 DEFAULT NULL, -- ENERGY
1689: p_transaction_key IN VARCHAR2 DEFAULT 'XX',
1689: p_transaction_key IN VARCHAR2 DEFAULT 'XX',
1690: x_amortization_start_date OUT NOCOPY DATE,
1691: x_trxs_exist OUT NOCOPY VARCHAR2,
1692: p_calling_fn IN VARCHAR2,
1693: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1694:
1695: l_transaction_date date;
1696: l_period_close_date date;
1697: l_period_open_date date;
1708: l_amort_per_num number;
1709: l_fy_name varchar2(45);
1710: l_cal_type varchar2(15);
1711: l_start_jdate number;
1712: l_period_rec FA_API_TYPES.period_rec_type;
1713: l_calling_fn varchar2(40) := 'fa_asset_val_pvt.val_amort_date';
1714: error_found exception;
1715:
1716: begin
1901: p_user_id IN NUMBER,
1902: p_curr_date IN DATE,
1903: px_new_life IN OUT NOCOPY NUMBER,
1904: p_calling_fn IN VARCHAR2,
1905: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
1906:
1907: l_method_id number;
1908: l_rowid rowid;
1909:
2133: FUNCTION validate_payables_ccid
2134: (px_payables_ccid IN OUT NOCOPY NUMBER,
2135: p_gl_chart_id IN NUMBER,
2136: p_calling_fn IN VARCHAR2,
2137: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2138:
2139: l_is_valid_payables_ccid number;
2140:
2141: BEGIN
2176: FUNCTION validate_expense_ccid
2177: (p_expense_ccid IN NUMBER,
2178: p_gl_chart_id IN NUMBER,
2179: p_calling_fn IN VARCHAR2,
2180: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2181:
2182: l_is_valid_expense_ccid number;
2183:
2184: BEGIN
2228:
2229: FUNCTION validate_fixed_assets_cost
2230: (p_fixed_assets_cost IN NUMBER,
2231: p_calling_fn IN VARCHAR2,
2232: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2233:
2234: BEGIN
2235:
2236: -- Fixed assets cost cannot be null.
2247:
2248: FUNCTION validate_fixed_assets_units
2249: (p_fixed_assets_units IN NUMBER,
2250: p_calling_fn IN VARCHAR2,
2251: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2252:
2253: BEGIN
2254:
2255: -- Fixed assets units cannot be null.
2275:
2276: FUNCTION validate_payables_cost
2277: (p_payables_cost IN NUMBER,
2278: p_calling_fn IN VARCHAR2,
2279: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2280:
2281: BEGIN
2282:
2283: -- Payables cost cannot be null.
2294:
2295: FUNCTION validate_payables_units
2296: (p_payables_units IN NUMBER,
2297: p_calling_fn IN VARCHAR2,
2298: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2299:
2300: BEGIN
2301:
2302: -- Payables units cannot be null.
2313:
2314: FUNCTION validate_po_vendor_id
2315: (p_po_vendor_id IN NUMBER,
2316: p_calling_fn IN VARCHAR2,
2317: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2318:
2319: l_is_valid_vendor_id number;
2320:
2321: BEGIN
2342:
2343: FUNCTION validate_unit_of_measure
2344: (p_unit_of_measure IN VARCHAR2,
2345: p_calling_fn IN VARCHAR2,
2346: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2347:
2348: l_is_valid_uom number;
2349:
2350: BEGIN
2370: FUNCTION validate_salvage_value
2371: (p_salvage_value IN NUMBER,
2372: p_nbv IN NUMBER,
2373: p_calling_fn IN VARCHAR2,
2374: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2375:
2376: l_calling_fn varchar2(50) := 'fa_asset_val_pvt.validate_salvage_value';
2377:
2378: BEGIN
2397: FUNCTION validate_tag_number
2398: (p_tag_number IN VARCHAR2,
2399: p_mass_addition_id IN NUMBER DEFAULT NULL,
2400: p_calling_fn IN VARCHAR2,
2401: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2402:
2403: l_tag_number_count number;
2404:
2405: BEGIN
2431:
2432: FUNCTION validate_split_merged_code
2433: (p_split_merged_code IN VARCHAR2,
2434: p_calling_fn IN VARCHAR2,
2435: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2436:
2437: BEGIN
2438:
2439: -- Split merged code cannot be zero.
2453: FUNCTION validate_exp_after_amort
2454: (p_asset_id IN number,
2455: p_book IN varchar2,
2456: p_extended_flag IN BOOLEAN DEFAULT FALSE,
2457: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
2458:
2459: l_count number := 0 ; -- 6348506: initialize
2460: l_rolled_back_imp number := 0;
2461:
2579:
2580: FUNCTION validate_unplanned_exists
2581: (p_asset_id IN number,
2582: p_book IN varchar2,
2583: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2584:
2585: l_count number;
2586:
2587: BEGIN
2610: (p_asset_id IN number,
2611: p_book IN varchar2,
2612: p_mode IN varchar2 DEFAULT 'ABSOLUTE',
2613: px_period_of_addition IN OUT NOCOPY varchar2,
2614: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
2615:
2616: l_last_pc number;
2617: l_count number;
2618: l_period_rec FA_API_TYPES.period_rec_type;
2614: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
2615:
2616: l_last_pc number;
2617: l_count number;
2618: l_period_rec FA_API_TYPES.period_rec_type;
2619:
2620: BEGIN
2621:
2622: -- no need to load book controls cache here as it's loaded
2682:
2683: FUNCTION validate_fully_retired
2684: (p_asset_id IN number,
2685: p_book IN varchar2,
2686: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2687:
2688: l_count number;
2689:
2690: BEGIN
2715:
2716: FUNCTION validate_add_to_asset_pending
2717: (p_asset_id in number,
2718: p_book in varchar2,
2719: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
2720:
2721: l_count number;
2722:
2723: BEGIN
2746:
2747:
2748: FUNCTION validate_asset_id_exist
2749: (p_asset_id in number,
2750: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
2751:
2752: l_count number;
2753:
2754: BEGIN
2775:
2776: FUNCTION validate_ret_rst_pending
2777: (p_asset_id in number,
2778: p_book in varchar2,
2779: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
2780:
2781: l_count number;
2782:
2783: BEGIN
2807:
2808: FUNCTION validate_fa_lookup_code
2809: (p_lookup_type in varchar2,
2810: p_lookup_code in varchar2,
2811: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
2812:
2813: l_count number;
2814:
2815: BEGIN
2840:
2841: FUNCTION validate_dist_id
2842: (p_asset_id in number,
2843: p_dist_id in number,
2844: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN IS
2845:
2846: l_count number;
2847:
2848: BEGIN
2872: FUNCTION validate_corp_pending_ret
2873: (p_asset_id in number,
2874: p_book in varchar2,
2875: p_transaction_header_id_in in number,
2876: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
2877:
2878: l_count1 number := 0;
2879: l_count2 number := 0;
2880:
2952:
2953: FUNCTION validate_parent_asset(
2954: p_parent_asset_id IN number,
2955: p_asset_id IN number,
2956: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
2957:
2958: l_count number:=0;
2959: l_corp_book varchar2(30);
2960: BEGIN
2986: FUNCTION validate_warranty (
2987: p_warranty_id IN NUMBER,
2988: p_date_placed_in_service IN DATE,
2989: p_book_type_code IN VARCHAR2,
2990: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
2991:
2992: l_count number := 0;
2993:
2994: BEGIN
3035: FUNCTION validate_lease(
3036: p_asset_id IN number,
3037: p_lease_id IN number,
3038: p_category_id IN NUMBER,
3039: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
3040:
3041: CURSOR get_cat_type IS
3042: select category_type
3043: from fa_categories_b
3108: END validate_lease;
3109:
3110: FUNCTION validate_property_type(
3111: p_property_type_code in VARCHAR2,
3112: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
3113: l_count number:= 0;
3114: BEGIN
3115: if p_property_type_code is not null then
3116: select count(1)
3133:
3134:
3135: FUNCTION validate_1245_1250_code(
3136: p_1245_1250_code in VARCHAR2,
3137: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
3138:
3139: l_count number:= 0;
3140: BEGIN
3141: if p_1245_1250_code is not null then
3160: FUNCTION validate_group_asset
3161: (p_group_asset_id in NUMBER,
3162: p_book_type_code in VARCHAR2,
3163: p_asset_type in VARCHAR2,
3164: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
3165:
3166: l_count number;
3167:
3168: BEGIN
3214: (p_group_asset_id in NUMBER,
3215: p_book_type_code in VARCHAR2,
3216: p_old_flag IN VARCHAR2,
3217: p_new_flag IN VARCHAR2,
3218: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
3219:
3220: l_calling_fn varchar2(40) :='fa_asset_val_pvt.validate_disabled_flag';
3221:
3222: BEGIN
3252: FUNCTION validate_group_info
3253: (p_group_asset_id in NUMBER,
3254: p_book_type_code in VARCHAR2,
3255: p_calling_fn in VARCHAR2,
3256: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
3257:
3258: l_has_members number;
3259: l_disabled number;
3260: l_calling_fn varchar2(40) :='fa_asset_val_pvt.validate_group_info';
3299:
3300: END validate_group_info; -- End HH.
3301:
3302: FUNCTION validate_over_depreciate
3303: (p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
3304: p_asset_type VARCHAR2,
3305: p_over_depreciate_option VARCHAR2 default null,
3306: p_adjusted_recoverable_cost NUMBER default null,
3307: p_recoverable_cost NUMBER default null,
3309: p_rate_source_rule VARCHAR2 default null,
3310: p_deprn_basis_rule VARCHAR2 default null,
3311: p_recapture_reserve_flag VARCHAR2 default null,
3312: p_deprn_limit_type VARCHAR2 default null,
3313: p_log_level_rec FA_API_TYPES.log_level_rec_type) return boolean is
3314:
3315: l_calling_fn varchar2(50) := 'fa_asset_val_pvt.validate_over_depreciate';
3316:
3317: l_member_count binary_integer := 0;
3425: p_deprn_limit_amount_adj number default 0,
3426: p_mrc_sob_type_code varchar2,
3427: p_set_of_books_id number,
3428: p_over_depreciate_option varchar2,
3429: p_log_level_rec FA_API_TYPES.log_level_rec_type) return boolean is
3430:
3431: l_calling_fn varchar2(50) := 'fa_asset_val_pvt.validate_cost_change';
3432:
3433: CURSOR c_get_current_amts IS
3746: -- to check for duplicates
3747:
3748: FUNCTION validate_duplicate_dist (
3749: p_transaction_type_code IN VARCHAR2,
3750: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
3751: p_curr_index IN NUMBER,
3752: p_calling_function IN VARCHAR2,
3753: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
3754:
3749: p_transaction_type_code IN VARCHAR2,
3750: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
3751: p_curr_index IN NUMBER,
3752: p_calling_function IN VARCHAR2,
3753: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
3754:
3755: l_high_bound number;
3756: dup_err exception;
3757: l_calling_fn varchar2(50) := 'fa_asset_val_pvt.validate_duplicate_dist';
3820: p_calendar_period_open_date IN DATE DEFAULT NULL,
3821: p_ytd_deprn IN NUMBER DEFAULT NULL,
3822: p_deprn_reserve IN NUMBER DEFAULT NULL,
3823: p_calling_fn IN VARCHAR2,
3824: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
3825:
3826: l_deprn_basis_rule varchar2(80);
3827: l_polish_rule number;
3828: l_calling_fn varchar2(35) := 'fa_asset_val_pvt.validate_polish';
3980: p_transaction_key IN VARCHAR2 DEFAULT NULL,
3981: p_cash_generating_unit_id IN VARCHAR2 DEFAULT NULL,
3982: p_deprn_override_flag IN VARCHAR2 DEFAULT 'N',
3983: p_calling_fn IN VARCHAR2,
3984: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
3985:
3986: l_mrc_count number := 0;
3987: l_override_count number := 0;
3988: l_calling_fn varchar2(35) := 'fa_asset_val_pvt.validate_jp250db';
4067: p_book_type_code IN VARCHAR2,
4068: p_old_super_group_id IN NUMBER,
4069: p_new_super_group_id IN NUMBER,
4070: p_calling_fn IN VARCHAR2,
4071: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4072:
4073: l_calling_fn varchar2(40) := 'fa_asset_val_pvt.validate_super_group';
4074:
4075: CURSOR c_check_used is
4132: (p_book_type_code IN VARCHAR2,
4133: p_date_placed_in_service IN DATE,
4134: p_group_asset_Id IN NUMBER,
4135: p_calling_fn IN VARCHAR2,
4136: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4137:
4138: CURSOR c_group_dpis (p_group_asset_id NUMBER,
4139: p_book_type_code VARCHAR2) is
4140: select date_placed_in_service
4176: p_transaction_key IN VARCHAR2,
4177: p_rate_source_rule IN VARCHAR2,
4178: p_rule_name IN VARCHAR2,
4179: p_calling_fn IN VARCHAR2,
4180: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4181:
4182: l_calling_fn varchar2(50) := 'FA_ASSET_VAL_PVT.validate_egy_prod_date';
4183:
4184: BEGIN
4223: FUNCTION validate_reval_exists (
4224: p_book_type_code IN VARCHAR2,
4225: p_asset_Id IN NUMBER,
4226: p_calling_fn IN VARCHAR2,
4227: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
4228:
4229: CURSOR c_reval_exists (l_asset_id NUMBER,
4230: l_book_type_code VARCHAR2) is
4231: select 'x'
4267:
4268: /* Japan Tax Phase3 Prevent cost adjustment
4269: and method change for assets in extended depreciation */
4270: FUNCTION validate_extended_asset (
4271: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4272: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4273: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4274: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4275:
4268: /* Japan Tax Phase3 Prevent cost adjustment
4269: and method change for assets in extended depreciation */
4270: FUNCTION validate_extended_asset (
4271: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4272: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4273: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4274: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4275:
4276: l_calling_fn varchar2(50) := 'FA_ASSET_VAL_PVT.validate_extended_asset';
4269: and method change for assets in extended depreciation */
4270: FUNCTION validate_extended_asset (
4271: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4272: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4273: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4274: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4275:
4276: l_calling_fn varchar2(50) := 'FA_ASSET_VAL_PVT.validate_extended_asset';
4277: l_mrc_count number := 0;
4270: FUNCTION validate_extended_asset (
4271: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4272: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4273: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4274: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4275:
4276: l_calling_fn varchar2(50) := 'FA_ASSET_VAL_PVT.validate_extended_asset';
4277: l_mrc_count number := 0;
4278:
4367: return FALSE;
4368: END validate_extended_asset;
4369:
4370: FUNCTION validate_extending_asset (
4371: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4372: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4373: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4374: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4375: p_period_rec IN FA_API_TYPES.period_rec_type,
4368: END validate_extended_asset;
4369:
4370: FUNCTION validate_extending_asset (
4371: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4372: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4373: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4374: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4375: p_period_rec IN FA_API_TYPES.period_rec_type,
4376: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
4369:
4370: FUNCTION validate_extending_asset (
4371: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4372: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4373: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4374: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4375: p_period_rec IN FA_API_TYPES.period_rec_type,
4376: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
4377:
4370: FUNCTION validate_extending_asset (
4371: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4372: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4373: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4374: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4375: p_period_rec IN FA_API_TYPES.period_rec_type,
4376: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
4377:
4378: l_calling_fn varchar2(50) := 'FA_ASSET_VAL_PVT.validate_extending_asset';
4371: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
4372: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4373: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4374: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4375: p_period_rec IN FA_API_TYPES.period_rec_type,
4376: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
4377:
4378: l_calling_fn varchar2(50) := 'FA_ASSET_VAL_PVT.validate_extending_asset';
4379: l_count number :=0 ;
4372: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4373: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
4374: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
4375: p_period_rec IN FA_API_TYPES.period_rec_type,
4376: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
4377:
4378: l_calling_fn varchar2(50) := 'FA_ASSET_VAL_PVT.validate_extending_asset';
4379: l_count number :=0 ;
4380: BEGIN
4427: p_prior_basic_rate IN NUMBER DEFAULT NULL,
4428: p_prior_adjusted_rate IN NUMBER DEFAULT NULL,
4429: p_prior_life_in_months IN NUMBER DEFAULT NULL,
4430: p_calling_fn IN VARCHAR2,
4431: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4432:
4433: cursor lcu_deprn_method(p_prior_deprn_method in varchar2)
4434: is
4435:
4548: p_prior_deprn_limit_amount IN NUMBER DEFAULT NULL,
4549: p_prior_deprn_limit IN NUMBER DEFAULT NULL,
4550: p_prior_deprn_limit_type IN VARCHAR2 DEFAULT NULL,
4551: p_calling_fn IN VARCHAR2,
4552: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4553:
4554: TYPE l_msg_error_rec IS RECORD(mass_addition_id NUMBER
4555: ,exception_code VARCHAR2(10)
4556: );
4603: p_book_type_code IN VARCHAR2,
4604: p_pc_fully_reserved IN NUMBER DEFAULT NULL,
4605: p_date_placed_in_service IN DATE,
4606: p_calling_fn IN VARCHAR2,
4607: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4608:
4609: cursor lcu_period_info(p_book_type_code in varchar2
4610: ,p_period_ctr in number
4611: )
4714: p_book_type_code IN VARCHAR2,
4715: p_extended_deprn_period IN NUMBER DEFAULT NULL,
4716: p_date_placed_in_service IN DATE,
4717: p_calling_fn IN VARCHAR2,
4718: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4719:
4720: cursor lcu_period_info(p_book_type_code in varchar2,
4721: p_period_ctr in number) is
4722: select fcp.end_date
4804: p_pc_fully_reserved IN NUMBER DEFAULT NULL,
4805: p_date_placed_in_service IN DATE,
4806: p_cost IN NUMBER DEFAULT NULL,
4807: p_calling_fn IN VARCHAR2,
4808: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4809:
4810: TYPE l_msg_error_rec IS RECORD(mass_addition_id NUMBER
4811: ,exception_code VARCHAR2(10)
4812: );
4918: p_nbv_at_switch IN NUMBER DEFAULT NULL,
4919: p_deprn_reserve IN NUMBER DEFAULT NULL,
4920: p_ytd_deprn IN NUMBER DEFAULT NULL,
4921: p_calling_fn IN VARCHAR2,
4922: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
4923:
4924: cursor lcu_rates_info(p_method_code in varchar2)
4925: is
4926: select ff.original_rate
5009: p_book_type_code IN VARCHAR2 DEFAULT NULL,
5010: p_asset_id IN NUMBER DEFAULT NULL,
5011: p_transfer_amount IN NUMBER DEFAULT 0,
5012: p_calling_fn IN VARCHAR2,
5013: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
5014:
5015: cursor c_get_books_info(c_asset_id number,
5016: c_book_type_code varchar2) IS
5017: select over_depreciate_option
5059: END validate_reserve_transfer;
5060:
5061: /* Bug#7693266- To validate change of salvage_type or deprn_limit_type of group asset */
5062: FUNCTION validate_sal_deprn_sum (
5063: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5064: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5065: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5066: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
5067:
5060:
5061: /* Bug#7693266- To validate change of salvage_type or deprn_limit_type of group asset */
5062: FUNCTION validate_sal_deprn_sum (
5063: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5064: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5065: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5066: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
5067:
5068: CURSOR c_mem_exists IS
5061: /* Bug#7693266- To validate change of salvage_type or deprn_limit_type of group asset */
5062: FUNCTION validate_sal_deprn_sum (
5063: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5064: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5065: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5066: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
5067:
5068: CURSOR c_mem_exists IS
5069: select 1
5062: FUNCTION validate_sal_deprn_sum (
5063: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5064: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
5065: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
5066: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
5067:
5068: CURSOR c_mem_exists IS
5069: select 1
5070: from fa_books
5148: (p_asset_id IN number,
5149: p_book IN varchar2,
5150: p_mrc_sob_type_code IN varchar2,
5151: p_set_of_books_id IN number,
5152: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
5153:
5154: l_check_imp_flag varchar(15);
5155: l_period_rec FA_API_TYPES.period_rec_type;
5156:
5151: p_set_of_books_id IN number,
5152: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
5153:
5154: l_check_imp_flag varchar(15);
5155: l_period_rec FA_API_TYPES.period_rec_type;
5156:
5157: CURSOR c_mc_check_imp is
5158: select 'POSTED'
5159: from fa_mc_impairments
5235:
5236: /*Bug# 8527619 This function is called from public APIs to check if group will become over depreciate
5237: NBV should not have sign different than cost, when over_depreciation_option is set to NO*/
5238: FUNCTION validate_over_depreciation (
5239: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5240: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type default null,
5241: p_validation_type IN varchar2,
5242: p_cost_adj IN number,
5243: p_rsv_adj IN number,
5236: /*Bug# 8527619 This function is called from public APIs to check if group will become over depreciate
5237: NBV should not have sign different than cost, when over_depreciation_option is set to NO*/
5238: FUNCTION validate_over_depreciation (
5239: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5240: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type default null,
5241: p_validation_type IN varchar2,
5242: p_cost_adj IN number,
5243: p_rsv_adj IN number,
5244: p_mrc_sob_type_code IN varchar2 default 'P',
5241: p_validation_type IN varchar2,
5242: p_cost_adj IN number,
5243: p_rsv_adj IN number,
5244: p_mrc_sob_type_code IN varchar2 default 'P',
5245: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type default null,
5246: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
5247: ) RETURN BOOLEAN IS
5248:
5249: l_calling_fn varchar2(50) := 'FA_ASSET_VAL_PVT.validate_over_depreciation';
5242: p_cost_adj IN number,
5243: p_rsv_adj IN number,
5244: p_mrc_sob_type_code IN varchar2 default 'P',
5245: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type default null,
5246: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
5247: ) RETURN BOOLEAN IS
5248:
5249: l_calling_fn varchar2(50) := 'FA_ASSET_VAL_PVT.validate_over_depreciation';
5250: l_deprn_reserve number :=0;
5258: l_new_mem_cost number := 0;
5259: l_new_mem_reserve number := 0;
5260: l_group_cost number := 0;
5261:
5262: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5263: l_asset_hdr_rec_mem FA_API_TYPES.asset_hdr_rec_type;
5264: l_asset_fin_rec_grp FA_API_TYPES.asset_fin_rec_type;
5265: l_asset_fin_rec_mem FA_API_TYPES.asset_fin_rec_type;
5266: l_mem_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
5259: l_new_mem_reserve number := 0;
5260: l_group_cost number := 0;
5261:
5262: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5263: l_asset_hdr_rec_mem FA_API_TYPES.asset_hdr_rec_type;
5264: l_asset_fin_rec_grp FA_API_TYPES.asset_fin_rec_type;
5265: l_asset_fin_rec_mem FA_API_TYPES.asset_fin_rec_type;
5266: l_mem_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
5267: l_grp_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
5260: l_group_cost number := 0;
5261:
5262: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5263: l_asset_hdr_rec_mem FA_API_TYPES.asset_hdr_rec_type;
5264: l_asset_fin_rec_grp FA_API_TYPES.asset_fin_rec_type;
5265: l_asset_fin_rec_mem FA_API_TYPES.asset_fin_rec_type;
5266: l_mem_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
5267: l_grp_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
5268: l_mem_salvage_val number := 0;
5261:
5262: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5263: l_asset_hdr_rec_mem FA_API_TYPES.asset_hdr_rec_type;
5264: l_asset_fin_rec_grp FA_API_TYPES.asset_fin_rec_type;
5265: l_asset_fin_rec_mem FA_API_TYPES.asset_fin_rec_type;
5266: l_mem_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
5267: l_grp_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
5268: l_mem_salvage_val number := 0;
5269: add_err1 exception;
5262: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5263: l_asset_hdr_rec_mem FA_API_TYPES.asset_hdr_rec_type;
5264: l_asset_fin_rec_grp FA_API_TYPES.asset_fin_rec_type;
5265: l_asset_fin_rec_mem FA_API_TYPES.asset_fin_rec_type;
5266: l_mem_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
5267: l_grp_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
5268: l_mem_salvage_val number := 0;
5269: add_err1 exception;
5270:
5263: l_asset_hdr_rec_mem FA_API_TYPES.asset_hdr_rec_type;
5264: l_asset_fin_rec_grp FA_API_TYPES.asset_fin_rec_type;
5265: l_asset_fin_rec_mem FA_API_TYPES.asset_fin_rec_type;
5266: l_mem_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
5267: l_grp_asset_deprn_rec fa_api_types.asset_deprn_rec_type;
5268: l_mem_salvage_val number := 0;
5269: add_err1 exception;
5270:
5271: CURSOR c_get_currency_code IS
5500: return FALSE;
5501: END validate_over_depreciation;
5502:
5503: FUNCTION validate_grp_track_method(
5504: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
5505: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
5506: p_group_reclass_options_rec IN fa_api_types.group_reclass_options_rec_type,
5507: p_log_level_rec IN fa_api_types.log_level_rec_type DEFAULT NULL) RETURN BOOLEAN IS
5508:
5501: END validate_over_depreciation;
5502:
5503: FUNCTION validate_grp_track_method(
5504: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
5505: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
5506: p_group_reclass_options_rec IN fa_api_types.group_reclass_options_rec_type,
5507: p_log_level_rec IN fa_api_types.log_level_rec_type DEFAULT NULL) RETURN BOOLEAN IS
5508:
5509: BEGIN
5502:
5503: FUNCTION validate_grp_track_method(
5504: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
5505: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
5506: p_group_reclass_options_rec IN fa_api_types.group_reclass_options_rec_type,
5507: p_log_level_rec IN fa_api_types.log_level_rec_type DEFAULT NULL) RETURN BOOLEAN IS
5508:
5509: BEGIN
5510:
5503: FUNCTION validate_grp_track_method(
5504: p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
5505: p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
5506: p_group_reclass_options_rec IN fa_api_types.group_reclass_options_rec_type,
5507: p_log_level_rec IN fa_api_types.log_level_rec_type DEFAULT NULL) RETURN BOOLEAN IS
5508:
5509: BEGIN
5510:
5511: IF (NVL(p_asset_fin_rec_old.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) AND
5529: END validate_grp_track_method;
5530:
5531: /* Bug#8584206-To validate type of transactions allowed on Energy UOP assets */
5532: FUNCTION validate_energy_transactions (
5533: p_trans_rec IN FA_API_TYPES.trans_rec_type,
5534: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type default null,
5535: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
5536: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
5537: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5530:
5531: /* Bug#8584206-To validate type of transactions allowed on Energy UOP assets */
5532: FUNCTION validate_energy_transactions (
5533: p_trans_rec IN FA_API_TYPES.trans_rec_type,
5534: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type default null,
5535: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
5536: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
5537: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5538: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
5531: /* Bug#8584206-To validate type of transactions allowed on Energy UOP assets */
5532: FUNCTION validate_energy_transactions (
5533: p_trans_rec IN FA_API_TYPES.trans_rec_type,
5534: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type default null,
5535: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
5536: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
5537: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5538: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
5539:
5532: FUNCTION validate_energy_transactions (
5533: p_trans_rec IN FA_API_TYPES.trans_rec_type,
5534: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type default null,
5535: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
5536: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
5537: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5538: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
5539:
5540: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5533: p_trans_rec IN FA_API_TYPES.trans_rec_type,
5534: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type default null,
5535: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
5536: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
5537: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5538: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
5539:
5540: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5541: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5534: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type default null,
5535: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
5536: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
5537: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5538: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
5539:
5540: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5541: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5542: l_group_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5536: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
5537: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5538: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
5539:
5540: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5541: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5542: l_group_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5543: l_group_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5544: h_asset_id number;
5537: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5538: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
5539:
5540: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5541: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5542: l_group_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5543: l_group_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5544: h_asset_id number;
5545:
5538: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
5539:
5540: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5541: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5542: l_group_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5543: l_group_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5544: h_asset_id number;
5545:
5546: CURSOR c_group_mem_no_depreciate is
5539:
5540: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5541: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5542: l_group_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5543: l_group_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5544: h_asset_id number;
5545:
5546: CURSOR c_group_mem_no_depreciate is
5547: select count(1) from dual
5775: END validate_energy_transactions;
5776:
5777: /* Bug#8633654-To validate type of transactions allowed on Energy UOP assets */
5778: FUNCTION validate_mbr_reins_possible (
5779: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
5780: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
5781: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
5782:
5783: l_calling_fn varchar2(100) := 'FA_ASSET_VAL_PVT.validate_mbr_reins_possible';
5776:
5777: /* Bug#8633654-To validate type of transactions allowed on Energy UOP assets */
5778: FUNCTION validate_mbr_reins_possible (
5779: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
5780: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
5781: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
5782:
5783: l_calling_fn varchar2(100) := 'FA_ASSET_VAL_PVT.validate_mbr_reins_possible';
5784:
5777: /* Bug#8633654-To validate type of transactions allowed on Energy UOP assets */
5778: FUNCTION validate_mbr_reins_possible (
5779: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
5780: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
5781: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
5782:
5783: l_calling_fn varchar2(100) := 'FA_ASSET_VAL_PVT.validate_mbr_reins_possible';
5784:
5785:
5961: END validate_mbr_reins_possible;
5962:
5963: -- Bug 8722521 : Validation for Japan methods during Tax upload
5964: FUNCTION validate_jp_taxupl (
5965: p_trans_rec IN FA_API_TYPES.trans_rec_type,
5966: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
5967: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
5968: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5969: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
5962:
5963: -- Bug 8722521 : Validation for Japan methods during Tax upload
5964: FUNCTION validate_jp_taxupl (
5965: p_trans_rec IN FA_API_TYPES.trans_rec_type,
5966: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
5967: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
5968: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5969: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
5970: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
5963: -- Bug 8722521 : Validation for Japan methods during Tax upload
5964: FUNCTION validate_jp_taxupl (
5965: p_trans_rec IN FA_API_TYPES.trans_rec_type,
5966: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
5967: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
5968: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5969: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
5970: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
5971:
5964: FUNCTION validate_jp_taxupl (
5965: p_trans_rec IN FA_API_TYPES.trans_rec_type,
5966: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
5967: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
5968: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5969: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
5970: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
5971:
5972:
5965: p_trans_rec IN FA_API_TYPES.trans_rec_type,
5966: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
5967: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
5968: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5969: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
5970: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
5971:
5972:
5973: --Bug# 7608030 start
5966: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
5967: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
5968: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
5969: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
5970: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
5971:
5972:
5973: --Bug# 7608030 start
5974: l_p_rsv_counter number;
6216:
6217: --Bug 8828394 - Group Asset ID should be valid Group Asset ID
6218: FUNCTION validate_group_asset_id(
6219: p_asset_id IN NUMBER,
6220: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
6221: ) RETURN BOOLEAN IS
6222:
6223: l_count number;
6224:
6252: FUNCTION validate_ltd_deprn_change (
6253: p_book_type_code IN VARCHAR2,
6254: p_asset_Id IN NUMBER,
6255: p_calling_fn IN VARCHAR2,
6256: p_log_level_rec IN FA_API_TYPES.log_level_rec_type
6257: ) RETURN BOOLEAN IS
6258:
6259: CURSOR c_check_dist IS
6260: select count(1)
6303: /*Bug 10316358 now we are allowing transaction in same fiscal year of imapairment which are effective from
6304: current period (amortization start date = current period and transaction which are not backdated to same
6305: fiscal year of an impairment*/
6306: FUNCTION check_overlapping_impairment (
6307: p_trans_rec IN FA_API_TYPES.trans_rec_type,
6308: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6309: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
6310:
6311: l_imp_exists number := 0;
6304: current period (amortization start date = current period and transaction which are not backdated to same
6305: fiscal year of an impairment*/
6306: FUNCTION check_overlapping_impairment (
6307: p_trans_rec IN FA_API_TYPES.trans_rec_type,
6308: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6309: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
6310:
6311: l_imp_exists number := 0;
6312: l_calling_fn varchar2(100) := 'FA_ASSET_VAL_PVT.check_overlapping_impairment';
6305: fiscal year of an impairment*/
6306: FUNCTION check_overlapping_impairment (
6307: p_trans_rec IN FA_API_TYPES.trans_rec_type,
6308: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6309: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
6310:
6311: l_imp_exists number := 0;
6312: l_calling_fn varchar2(100) := 'FA_ASSET_VAL_PVT.check_overlapping_impairment';
6313: l_fiscal_year varchar2 (30);
6382: /*phase5 This function will restrict any impairment posted on Asset added with depreciate flag NO and wiithout reserve*/
6383: FUNCTION check_non_depreciating_asset (
6384: p_asset_id IN NUMBER,
6385: p_book_type_code IN VARCHAR2,
6386: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
6387:
6388: l_restrict_trx VARCHAR2(1) := 'N';
6389: l_calling_fn varchar2(100) := 'FA_ASSET_VAL_PVT.check_non_depreciating_asset';
6390:
6425:
6426: END check_non_depreciating_asset;
6427:
6428: FUNCTION validate_bonus_rule_resv
6429: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6430: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
6431: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
6432: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
6433: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
6426: END check_non_depreciating_asset;
6427:
6428: FUNCTION validate_bonus_rule_resv
6429: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6430: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
6431: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
6432: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
6433: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
6434: p_calling_fn IN VARCHAR2,
6427:
6428: FUNCTION validate_bonus_rule_resv
6429: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6430: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
6431: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
6432: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
6433: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
6434: p_calling_fn IN VARCHAR2,
6435: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
6428: FUNCTION validate_bonus_rule_resv
6429: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6430: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
6431: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
6432: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
6433: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
6434: p_calling_fn IN VARCHAR2,
6435: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
6436: l_calling_fn varchar2(100) := 'FA_ASSET_VAL_PVT.validate_bonus_rule_resv';
6429: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6430: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
6431: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
6432: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
6433: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
6434: p_calling_fn IN VARCHAR2,
6435: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
6436: l_calling_fn varchar2(100) := 'FA_ASSET_VAL_PVT.validate_bonus_rule_resv';
6437: Begin
6431: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
6432: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
6433: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
6434: p_calling_fn IN VARCHAR2,
6435: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
6436: l_calling_fn varchar2(100) := 'FA_ASSET_VAL_PVT.validate_bonus_rule_resv';
6437: Begin
6438: IF (p_log_level_rec.statement_level) then
6439: fa_debug_pkg.add(l_calling_fn, 'p_asset_type_rec.asset_type', p_asset_type_rec.asset_type, p_log_level_rec);
6483: end validate_bonus_rule_resv;
6484:
6485: /* Bug 9916378 */
6486: FUNCTION validate_uop_method (
6487: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6488: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
6489: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
6490: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
6491: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
6484:
6485: /* Bug 9916378 */
6486: FUNCTION validate_uop_method (
6487: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6488: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
6489: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
6490: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
6491: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
6492: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
6485: /* Bug 9916378 */
6486: FUNCTION validate_uop_method (
6487: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6488: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
6489: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
6490: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
6491: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
6492: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
6493:
6486: FUNCTION validate_uop_method (
6487: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6488: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
6489: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
6490: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
6491: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
6492: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
6493:
6494: l_old_rate_source_rule fa_methods.rate_source_rule%type;
6487: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6488: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
6489: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
6490: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
6491: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
6492: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
6493:
6494: l_old_rate_source_rule fa_methods.rate_source_rule%type;
6495: l_old_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6488: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
6489: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
6490: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
6491: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
6492: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
6493:
6494: l_old_rate_source_rule fa_methods.rate_source_rule%type;
6495: l_old_deprn_basis_rule fa_methods.deprn_basis_rule%type;
6496: l_rate_source_rule fa_methods.rate_source_rule%type;
6794: end validate_uop_method;
6795:
6796: FUNCTION validate_prev_period_amort
6797: (
6798: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6799: p_trans_rec IN FA_API_TYPES.trans_rec_type,
6800: p_period_rec IN FA_API_TYPES.period_rec_type,
6801: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type default null,
6802: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
6795:
6796: FUNCTION validate_prev_period_amort
6797: (
6798: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6799: p_trans_rec IN FA_API_TYPES.trans_rec_type,
6800: p_period_rec IN FA_API_TYPES.period_rec_type,
6801: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type default null,
6802: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
6803:
6796: FUNCTION validate_prev_period_amort
6797: (
6798: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6799: p_trans_rec IN FA_API_TYPES.trans_rec_type,
6800: p_period_rec IN FA_API_TYPES.period_rec_type,
6801: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type default null,
6802: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
6803:
6804: l_calling_fn varchar2(100) := 'FA_ASSET_VAL_PVT.validate_prev_period_amort';
6797: (
6798: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6799: p_trans_rec IN FA_API_TYPES.trans_rec_type,
6800: p_period_rec IN FA_API_TYPES.period_rec_type,
6801: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type default null,
6802: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
6803:
6804: l_calling_fn varchar2(100) := 'FA_ASSET_VAL_PVT.validate_prev_period_amort';
6805:
6798: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6799: p_trans_rec IN FA_API_TYPES.trans_rec_type,
6800: p_period_rec IN FA_API_TYPES.period_rec_type,
6801: p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type default null,
6802: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
6803:
6804: l_calling_fn varchar2(100) := 'FA_ASSET_VAL_PVT.validate_prev_period_amort';
6805:
6806: cursor c_amort_trx is
6855:
6856: /* Bug 13513616/9559584 */
6857: FUNCTION is_financial_info_changed
6858: (
6859: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
6860: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
6861: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
6862: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
6863: l_fin_info_changed BOOLEAN := TRUE;
6856: /* Bug 13513616/9559584 */
6857: FUNCTION is_financial_info_changed
6858: (
6859: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
6860: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
6861: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
6862: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
6863: l_fin_info_changed BOOLEAN := TRUE;
6864: BEGIN
6857: FUNCTION is_financial_info_changed
6858: (
6859: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
6860: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
6861: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
6862: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
6863: l_fin_info_changed BOOLEAN := TRUE;
6864: BEGIN
6865: if not (nvl(p_asset_fin_rec_old.cash_generating_unit_id, FND_API.G_MISS_NUM) =
6858: (
6859: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
6860: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
6861: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
6862: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
6863: l_fin_info_changed BOOLEAN := TRUE;
6864: BEGIN
6865: if not (nvl(p_asset_fin_rec_old.cash_generating_unit_id, FND_API.G_MISS_NUM) =
6866: nvl(p_asset_fin_rec_adj.cash_generating_unit_id,
6950: p_gl_chart_id IN NUMBER,
6951: p_ledger_id IN NUMBER,
6952: p_validation_date IN DATE,
6953: p_calling_fn IN VARCHAR2,
6954: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
6955: l_bal_seg_col_name gl_ledgers.bal_seg_column_name%type;
6956: l_bal_seg_value_option_code gl_ledgers.bal_seg_value_option_code%type;
6957: query_str VARCHAR2(1000);
6958: l_valid varchar2(1) := 'N';
7006: END validate_ccid;
7007:
7008: /*bug#16426081 */
7009: FUNCTION validate_cca_rules (
7010: p_trans_rec IN FA_API_TYPES.trans_rec_type,
7011: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7012: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
7013: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
7014: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
7007:
7008: /*bug#16426081 */
7009: FUNCTION validate_cca_rules (
7010: p_trans_rec IN FA_API_TYPES.trans_rec_type,
7011: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7012: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
7013: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
7014: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
7015: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
7008: /*bug#16426081 */
7009: FUNCTION validate_cca_rules (
7010: p_trans_rec IN FA_API_TYPES.trans_rec_type,
7011: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7012: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
7013: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
7014: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
7015: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
7016: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
7009: FUNCTION validate_cca_rules (
7010: p_trans_rec IN FA_API_TYPES.trans_rec_type,
7011: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7012: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
7013: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
7014: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
7015: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
7016: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
7017: p_period_rec IN FA_API_TYPES.period_rec_type,
7010: p_trans_rec IN FA_API_TYPES.trans_rec_type,
7011: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7012: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
7013: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
7014: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
7015: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
7016: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
7017: p_period_rec IN FA_API_TYPES.period_rec_type,
7018: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
7011: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
7012: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
7013: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
7014: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
7015: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
7016: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
7017: p_period_rec IN FA_API_TYPES.period_rec_type,
7018: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
7019:
7012: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
7013: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
7014: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
7015: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
7016: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
7017: p_period_rec IN FA_API_TYPES.period_rec_type,
7018: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
7019:
7020: cursor c_method_details(p_method_code in varchar2) is
7013: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
7014: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
7015: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
7016: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
7017: p_period_rec IN FA_API_TYPES.period_rec_type,
7018: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
7019:
7020: cursor c_method_details(p_method_code in varchar2) is
7021: select mt.method_code, mt.method_id, mt.deprn_basis_rule,ru.rule_name
7014: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
7015: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
7016: p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
7017: p_period_rec IN FA_API_TYPES.period_rec_type,
7018: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
7019:
7020: cursor c_method_details(p_method_code in varchar2) is
7021: select mt.method_code, mt.method_id, mt.deprn_basis_rule,ru.rule_name
7022: from fa_methods mt, fa_deprn_basis_rules ru