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

APPS.FA_ASSET_VAL_PVT dependencies on FA_CACHE_PKG

Line 62: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then

58: raise val_err;
59: end if;
60:
61:
62: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
63:
64: if not validate_asset_number (
65: p_transaction_type_code => p_trans_rec.transaction_type_code,
66: p_asset_number => p_asset_desc_rec.asset_number,

Line 204: p_gl_chart_id => fa_cache_pkg.fazcbc_record.accounting_flex_structure,

200: end if;
201:
202: if not validate_expense_ccid (
203: p_expense_ccid => p_asset_dist_tbl(i).expense_ccid,
204: p_gl_chart_id => fa_cache_pkg.fazcbc_record.accounting_flex_structure,
205: p_calling_fn => p_calling_fn,
206: p_log_level_rec => p_log_level_rec
207: ) then
208: raise val_err;

Line 236: nvl(fa_cache_pkg.fazcbc_record.allow_interco_group_flag, 'N') <> 'Y') then

232: end if; -- corporate
233:
234: if (p_asset_fin_rec.group_asset_id is not null and
235: p_asset_fin_rec.group_asset_id <> FND_API.G_MISS_NUM and
236: nvl(fa_cache_pkg.fazcbc_record.allow_interco_group_flag, 'N') <> 'Y') then
237: if not fa_interco_pvt.validate_grp_interco
238: (p_asset_hdr_rec => p_asset_hdr_rec,
239: p_trans_rec => p_trans_rec,
240: p_asset_type_rec => p_asset_type_rec,

Line 347: if not fa_cache_pkg.fazsys() then

343: value1 => p_asset_number);
344: return FALSE;
345: end;
346:
347: if not fa_cache_pkg.fazsys() then
348: fa_srvr_msg.add_message (
349: calling_fn => 'fa_asset_val_pvt.validate_asset_number');
350: end if;
351:

Line 355: fa_cache_pkg.fazsys_record.initial_asset_id) and

351:
352: -- Fix for Bug #2585811. You don't need to validate if they
353: -- are using custom asset numbering.
354: if ((l_asset_number >=
355: fa_cache_pkg.fazsys_record.initial_asset_id) and
356: (nvl(fa_cache_pkg.fazsys_record.use_custom_asset_numbers_flag, 'N') <> 'Y')
357: ) then
358: fa_srvr_msg.add_message(
359: calling_fn => 'fa_asset_val_pvt.validate_asset_number',

Line 356: (nvl(fa_cache_pkg.fazsys_record.use_custom_asset_numbers_flag, 'N') <> 'Y')

352: -- Fix for Bug #2585811. You don't need to validate if they
353: -- are using custom asset numbering.
354: if ((l_asset_number >=
355: fa_cache_pkg.fazsys_record.initial_asset_id) and
356: (nvl(fa_cache_pkg.fazsys_record.use_custom_asset_numbers_flag, 'N') <> 'Y')
357: ) then
358: fa_srvr_msg.add_message(
359: calling_fn => 'fa_asset_val_pvt.validate_asset_number',
360: name => 'FA_ADD_AUTOMATIC_NUMBER');

Line 366: if not fa_cache_pkg.fazsys() then

362: end if;
363: end if;
364: end if;
365: else -- Asset Number is NULL
366: if not fa_cache_pkg.fazsys() then
367: fa_srvr_msg.add_message (
368: calling_fn => 'fa_asset_val_pvt.validate_asset_number');
369: end if;
370:

Line 373: if (nvl(fa_cache_pkg.fazsys_record.use_custom_asset_numbers_flag, 'N')

369: end if;
370:
371: -- Fix for Bug #2585811. If they are using custom asset numbering,
372: -- they must populate asset number.
373: if (nvl(fa_cache_pkg.fazsys_record.use_custom_asset_numbers_flag, 'N')
374: = 'Y')
375: then
376: fa_srvr_msg.add_message(
377: calling_fn => 'fa_asset_val_pvt.validate_asset_number',

Line 421: if not fa_cache_pkg.fazcat (

417: ) RETURN BOOLEAN IS
418:
419: BEGIN
420: -- Check that the category exists.
421: if not fa_cache_pkg.fazcat (
422: X_cat_id => p_category_id,
423: p_log_level_rec => p_log_level_rec
424: ) then
425: fa_srvr_msg.add_message(

Line 431: if (fa_cache_pkg.fazcat_record.enabled_flag <> 'Y') then

427: return FALSE;
428: end if;
429:
430: -- Check that the category is enabled.
431: if (fa_cache_pkg.fazcat_record.enabled_flag <> 'Y') then
432: fa_srvr_msg.add_message(
433: calling_fn => 'fa_asset_val_pvt.validate_asset_category',
434: name => 'FA_INCORRECT_CATEGORY_ID',
435: token1 => 'CATEGORY_ID',

Line 444: if not (fa_cache_pkg.fazccb (

440: -- removed check on capitalize flag as this isn't an asset level thing - bmr
441: if (p_book_type_code is not null) then
442:
443: -- Make sure that the category/book exists.
444: if not (fa_cache_pkg.fazccb (
445: X_Book => p_book_type_code,
446: X_Cat_Id => p_category_id,
447: p_log_level_rec => p_log_level_rec
448: )) then

Line 450: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX') then

446: X_Cat_Id => p_category_id,
447: p_log_level_rec => p_log_level_rec
448: )) then
449:
450: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX') then
451: fa_srvr_msg.add_message(
452: calling_fn => 'fa_asset_val_pvt.validate_asset_category',
453: name => 'FA_MCP_CAT_NOT_IN_TAX');
454: else

Line 536: and id_flex_num = fa_cache_pkg.fazsys_record.asset_key_flex_structure

532: select 1
533: from fnd_id_flex_segments
534: where application_id = 140
535: and id_flex_code = 'KEY#'
536: and id_flex_num = fa_cache_pkg.fazsys_record.asset_key_flex_structure
537: and required_flag = 'Y';
538:
539: BEGIN
540: -- check if the flexfield has any required segments

Line 542: if not fa_cache_pkg.fazsys then

538:
539: BEGIN
540: -- check if the flexfield has any required segments
541: if G_asset_key_required is null then
542: if not fa_cache_pkg.fazsys then
543: fa_srvr_msg.add_message(
544: calling_fn => 'fa_asset_val_pvt.validate_asset_key');
545: return false;
546: end if;

Line 618: if ((fa_cache_pkg.fazcat_record.capitalize_flag = 'YES') and

614: return FALSE;
615: end if;
616:
617: -- Check for invalid asset_type/category combinations.
618: if ((fa_cache_pkg.fazcat_record.capitalize_flag = 'YES') and
619: (p_asset_type = 'EXPENSED')) then
620:
621: fa_srvr_msg.add_message(
622: calling_fn => 'fa_asset_val_pvt.validate_asset_type',

Line 627: if ((fa_cache_pkg.fazcat_record.capitalize_flag = 'NO') and

623: name => 'FA_INCORRECT_ASSET_TYPE');
624: return FALSE;
625: end if;
626:
627: if ((fa_cache_pkg.fazcat_record.capitalize_flag = 'NO') and
628: ((p_asset_type = 'CAPITALIZED') or
629: (p_asset_type = 'CIP') or
630: (p_asset_type = 'GROUP'))) then
631:

Line 640: if ((fa_cache_pkg.fazccb_record.cip_clearing_acct is null) OR

636: end if;
637:
638: -- If asset is CIP, check the CIP accounts.
639: if (p_asset_type = 'CIP') then
640: if ((fa_cache_pkg.fazccb_record.cip_clearing_acct is null) OR
641: (fa_cache_pkg.fazccb_record.cip_cost_acct is null)) then
642:
643: fa_srvr_msg.add_message(
644: calling_fn => 'fa_asset_val_pvt.validate_asset_type',

Line 641: (fa_cache_pkg.fazccb_record.cip_cost_acct is null)) then

637:
638: -- If asset is CIP, check the CIP accounts.
639: if (p_asset_type = 'CIP') then
640: if ((fa_cache_pkg.fazccb_record.cip_clearing_acct is null) OR
641: (fa_cache_pkg.fazccb_record.cip_cost_acct is null)) then
642:
643: fa_srvr_msg.add_message(
644: calling_fn => 'fa_asset_val_pvt.validate_asset_type',
645: name => 'FA_SHARED_NO_CIP_ACCOUNTS');

Line 652: nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') <> 'Y') then

648: end if;
649:
650: -- do not allow group if not enabled
651: if (p_asset_type = 'GROUP' and
652: nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') <> 'Y') then
653: fa_srvr_msg.add_message(
654: calling_fn => 'fa_asset_val_pvt.validate_asset_type',
655: name => '***FA_GROUP_NOT_ALLOWED***');
656: return FALSE;

Line 732: if (fa_cache_pkg.fazcbc_record.date_ineffective is not null) then

728: -- book controls cache should have already been loaded by calling api
729: -- so this is obsolete: Validate that book exists.
730:
731: -- Validate that book is active.
732: if (fa_cache_pkg.fazcbc_record.date_ineffective is not null) then
733:
734: fa_srvr_msg.add_message(
735: calling_fn => 'fa_asset_val_pvt.validate_asset_book',
736: name => 'FA_BOOK_INEFFECTIVE_BOOK');

Line 764: if (fa_cache_pkg.fazcbc_record.book_class <> 'CORPORATE') then

760: return FALSE;
761: end if;
762:
763: -- For Addition transactions, asset must exist in the Corporate book.
764: if (fa_cache_pkg.fazcbc_record.book_class <> 'CORPORATE') then
765:
766: select count(*)
767: into l_exists
768: from fa_books bks

Line 804: fa_cache_pkg.fazcbc_record.book_class <> 'CORPORATE') then

800:
801: if ((p_transaction_type_code = 'TRANSFER' or
802: p_transaction_type_code = 'RECLASS' or
803: p_transaction_type_code = 'UNIT ADJUSTMENT') and
804: fa_cache_pkg.fazcbc_record.book_class <> 'CORPORATE') then
805: fa_srvr_msg.add_message(
806: calling_fn => 'fa_asset_val_pvt.validate_asset_book',
807: name => '***FA_BOOK_NOT_CORP***');
808: return false;

Line 826: if ((fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') AND

822: ) RETURN BOOLEAN IS
823:
824: BEGIN
825: -- If asset type is CIP, cost should be zero.
826: if ((fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') AND
827: (p_asset_type = 'CIP') AND (p_cost <> 0) AND (p_num_invoices = 0)) then
828: fa_srvr_msg.add_message(
829: calling_fn => 'fa_asset_val_pvt.validate_cost',
830: name => 'FA_BOOK_CIP_COST');

Line 1002: if (NOT fa_cache_pkg.fazcbc (

998: l_temp_num number;
999:
1000: BEGIN
1001: -- Need to call the cache for book
1002: if (NOT fa_cache_pkg.fazcbc (
1003: X_book => p_book_type_code
1004: )) then
1005: fa_srvr_msg.add_message(
1006: calling_fn => 'fa_asset_val_pvt.validate_dpis',

Line 1046: if not fa_cache_pkg.fazsys() then

1042: return FALSE;
1043: end if;
1044:
1045: -- Check that dpis is not too old.
1046: if not fa_cache_pkg.fazsys() then
1047: fa_srvr_msg.add_message(calling_fn => 'fa_asset_val_pvt.validate_dpis');
1048: return false;
1049: else
1050: l_earliest_dpis := fa_cache_pkg.fazsys_record.date_placed_in_service;

Line 1050: l_earliest_dpis := fa_cache_pkg.fazsys_record.date_placed_in_service;

1046: if not fa_cache_pkg.fazsys() then
1047: fa_srvr_msg.add_message(calling_fn => 'fa_asset_val_pvt.validate_dpis');
1048: return false;
1049: else
1050: l_earliest_dpis := fa_cache_pkg.fazsys_record.date_placed_in_service;
1051: end if;
1052:
1053: if (p_date_placed_in_service < l_earliest_dpis) then
1054: fa_srvr_msg.add_message(

Line 1166: if (not fa_cache_pkg.fazccp (

1162:
1163: -- Check to see if calendar periods are setup
1164: l_dpis_jdate := to_number(to_char(p_date_placed_in_service,'J'));
1165:
1166: if (not fa_cache_pkg.fazccp (
1167: X_target_calendar => fa_cache_pkg.fazcbc_record.deprn_calendar,
1168: X_target_fy_name => fa_cache_pkg.fazcbc_record.fiscal_year_name,
1169: X_target_jdate => l_dpis_jdate,
1170: X_period_num => l_dpis_per_num,

Line 1167: X_target_calendar => fa_cache_pkg.fazcbc_record.deprn_calendar,

1163: -- Check to see if calendar periods are setup
1164: l_dpis_jdate := to_number(to_char(p_date_placed_in_service,'J'));
1165:
1166: if (not fa_cache_pkg.fazccp (
1167: X_target_calendar => fa_cache_pkg.fazcbc_record.deprn_calendar,
1168: X_target_fy_name => fa_cache_pkg.fazcbc_record.fiscal_year_name,
1169: X_target_jdate => l_dpis_jdate,
1170: X_period_num => l_dpis_per_num,
1171: X_fiscal_year => l_dpis_fy,

Line 1168: X_target_fy_name => fa_cache_pkg.fazcbc_record.fiscal_year_name,

1164: l_dpis_jdate := to_number(to_char(p_date_placed_in_service,'J'));
1165:
1166: if (not fa_cache_pkg.fazccp (
1167: X_target_calendar => fa_cache_pkg.fazcbc_record.deprn_calendar,
1168: X_target_fy_name => fa_cache_pkg.fazcbc_record.fiscal_year_name,
1169: X_target_jdate => l_dpis_jdate,
1170: X_period_num => l_dpis_per_num,
1171: X_fiscal_year => l_dpis_fy,
1172: X_start_jdate => l_start_jdate,

Line 1286: l_current_fiscal_year := fa_cache_pkg.fazcbc_record.current_fiscal_year;

1282:
1283: BEGIN
1284:
1285: -- no need to load book controls cache as it's loaded
1286: l_current_fiscal_year := fa_cache_pkg.fazcbc_record.current_fiscal_year;
1287: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
1288:
1289: -- Get absolute values.
1290: l_abs_deprn_reserve := abs (nvl(p_deprn_reserve, 0));

Line 1287: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;

1283: BEGIN
1284:
1285: -- no need to load book controls cache as it's loaded
1286: l_current_fiscal_year := fa_cache_pkg.fazcbc_record.current_fiscal_year;
1287: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
1288:
1289: -- Get absolute values.
1290: l_abs_deprn_reserve := abs (nvl(p_deprn_reserve, 0));
1291: l_abs_ytd_deprn := abs (nvl(p_ytd_deprn, 0));

Line 1563: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;

1559: end if;
1560:
1561: -- get book controls info from cache
1562: -- assumes cache has been called
1563: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
1564: l_cal_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
1565:
1566: -- checks if amort start date is valid
1567: l_amort_jdate := to_number(to_char(x_amortization_start_date,'J'));

Line 1564: l_cal_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

1560:
1561: -- get book controls info from cache
1562: -- assumes cache has been called
1563: l_fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
1564: l_cal_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
1565:
1566: -- checks if amort start date is valid
1567: l_amort_jdate := to_number(to_char(x_amortization_start_date,'J'));
1568: if (not fa_cache_pkg.fazccp

Line 1568: if (not fa_cache_pkg.fazccp

1564: l_cal_type := fa_cache_pkg.fazcbc_record.deprn_calendar;
1565:
1566: -- checks if amort start date is valid
1567: l_amort_jdate := to_number(to_char(x_amortization_start_date,'J'));
1568: if (not fa_cache_pkg.fazccp
1569: (l_cal_type,
1570: l_fy_name,
1571: l_amort_jdate,
1572: l_amort_per_num,

Line 1774: if not fa_cache_pkg.fazccmt

1770: if (p_log_level_rec.statement_level) then
1771: fa_debug_pkg.add(l_calling_fn, 'calling', 'fazccmt');
1772: end if;
1773:
1774: if not fa_cache_pkg.fazccmt
1775: (X_method => p_deprn_method,
1776: X_life => p_lim,
1777: p_log_level_rec => p_log_level_rec) then -- method not found
1778:

Line 1808: p_life_in_months => fa_cache_pkg.fazccbd_record.life_in_months);

1804: -- pass the values as parameter into this function
1805: -- creating dependancies...
1806:
1807: OPEN METHOD_DEF(p_deprn_method => p_deprn_method,
1808: p_life_in_months => fa_cache_pkg.fazccbd_record.life_in_months);
1809: FETCH METHOD_DEF
1810: INTO l_method_id_old,
1811: l_method_name,
1812: l_deprn_basis_rule,

Line 2406: l_last_pc := FA_CACHE_PKG.fazcbc_record.last_period_counter;

2402:
2403: BEGIN
2404:
2405: -- no need to load book controls cache here as it's loaded
2406: l_last_pc := FA_CACHE_PKG.fazcbc_record.last_period_counter;
2407:
2408: if (p_mode = 'ABSOLUTE') then
2409: SELECT count(*)
2410: INTO l_count

Line 3351: if (fa_cache_pkg.fazccmt_record.rate_source_rule NOT IN ('CALCULATED','FLAT')) OR

3347: --Also, using the already loaded cache structures here since this is only
3348: --called from calc now. Should this change, we may need to consider
3349: --changing the params passed in to this proc.
3350:
3351: if (fa_cache_pkg.fazccmt_record.rate_source_rule NOT IN ('CALCULATED','FLAT')) OR
3352: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV') OR
3353: (NVL(fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,'N') = 'N') then
3354:
3355: --Members must also belong to a group that has the Over Depreciate Option as

Line 3352: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV') OR

3348: --called from calc now. Should this change, we may need to consider
3349: --changing the params passed in to this proc.
3350:
3351: if (fa_cache_pkg.fazccmt_record.rate_source_rule NOT IN ('CALCULATED','FLAT')) OR
3352: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV') OR
3353: (NVL(fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,'N') = 'N') then
3354:
3355: --Members must also belong to a group that has the Over Depreciate Option as
3356: --"Allow and Depreciate"

Line 3353: (NVL(fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,'N') = 'N') then

3349: --changing the params passed in to this proc.
3350:
3351: if (fa_cache_pkg.fazccmt_record.rate_source_rule NOT IN ('CALCULATED','FLAT')) OR
3352: (fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV') OR
3353: (NVL(fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,'N') = 'N') then
3354:
3355: --Members must also belong to a group that has the Over Depreciate Option as
3356: --"Allow and Depreciate"
3357:

Line 3361: (NVL(fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,'N') = 'Y')) then

3357:
3358: if ((p_group_asset_id is not null) and
3359: (nvl(p_over_depreciate_option, fa_std_types.FA_OVER_DEPR_NO) =
3360: fa_std_types.FA_OVER_DEPR_DEPRN) and
3361: (NVL(fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,'N') = 'Y')) then
3362: if (p_log_level_rec.statement_level) then
3363: fa_debug_pkg.add(l_calling_fn, 'Member cost sign','can be changed',p_log_level_rec);
3364: fa_debug_pkg.add(l_calling_fn, 'over depreciate option',p_over_depreciate_option,p_log_level_rec);
3365: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id,p_log_level_rec);

Line 3371: fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,p_log_level_rec);

3367: else
3368: if (p_log_level_rec.statement_level) then
3369: fa_debug_pkg.add(l_calling_fn, 'validating cost and salvage','',p_log_level_rec);
3370: fa_debug_pkg.add(l_calling_fn, 'sign change flag',
3371: fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,p_log_level_rec);
3372: fa_debug_pkg.add(l_calling_fn, 'over depr option',p_over_depreciate_option,p_log_level_rec);
3373: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id,p_log_level_rec);
3374: end if;
3375:

Line 3522: if not fa_cache_pkg.fazccmt (

3518:
3519: BEGIN
3520:
3521: -- First find out if we have a polish mechanism here
3522: if not fa_cache_pkg.fazccmt (
3523: X_method => p_method_code,
3524: X_life => p_life_in_months,
3525: p_log_level_rec => p_log_level_rec
3526: ) then

Line 3532: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then

3528:
3529: return FALSE;
3530: end if;
3531:
3532: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then
3533: l_polish_rule := fa_cache_pkg.fazcdbr_record.polish_rule;
3534: else
3535: -- No deprn basis rule attached to this method, so not Polish either
3536: return TRUE;

Line 3533: l_polish_rule := fa_cache_pkg.fazcdbr_record.polish_rule;

3529: return FALSE;
3530: end if;
3531:
3532: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then
3533: l_polish_rule := fa_cache_pkg.fazcdbr_record.polish_rule;
3534: else
3535: -- No deprn basis rule attached to this method, so not Polish either
3536: return TRUE;
3537: end if;