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_QUERY_BALANCES_PKG dependencies on STANDARD

Line 11: -- STANDARD: Query detail/summary in given period from CORPORATE book.

7: -- version 2.0. This just loads the dpr_row struct to pass to
8: -- QUERY_BALANCES_INT, and unpacks the results.
9:
10: -- Can call in several "RUN_MODEs":
11: -- STANDARD: Query detail/summary in given period from CORPORATE book.
12: -- ADJUSTED: Query detail/summary in given period from TAX book.
13: -- For both STANDARD/ADJUSTED: Returns period-closing balances if period
14: -- is closed. If current period, returns last period's closing balances
15: -- plus any adjustments from this period.

Line 13: -- For both STANDARD/ADJUSTED: Returns period-closing balances if period

9:
10: -- Can call in several "RUN_MODEs":
11: -- STANDARD: Query detail/summary in given period from CORPORATE book.
12: -- ADJUSTED: Query detail/summary in given period from TAX book.
13: -- For both STANDARD/ADJUSTED: Returns period-closing balances if period
14: -- is closed. If current period, returns last period's closing balances
15: -- plus any adjustments from this period.
16: -- DEPRN: Query everything except deprn balances... return these as
17: -- zero so as not to interfere with deprn program which calls this.

Line 38: X_RUN_MODE VARCHAR2 DEFAULT 'STANDARD',

34: (X_ASSET_ID NUMBER,
35: X_BOOK VARCHAR2,
36: X_PERIOD_CTR NUMBER DEFAULT 0,
37: X_DIST_ID NUMBER DEFAULT 0,
38: X_RUN_MODE VARCHAR2 DEFAULT 'STANDARD',
39: X_COST OUT NOCOPY NUMBER,
40: X_DEPRN_RSV OUT NOCOPY NUMBER,
41: X_REVAL_RSV OUT NOCOPY NUMBER,
42: X_YTD_DEPRN OUT NOCOPY NUMBER,

Line 61: -- Use the Standard Type define in faxstds.pls

57: X_BONUS_YTD_DEPRN OUT NOCOPY NUMBER,
58: X_BONUS_DEPRN_AMOUNT OUT NOCOPY NUMBER,
59: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
60:
61: -- Use the Standard Type define in faxstds.pls
62: H_DPR_ROW FA_STD_TYPES.FA_DEPRN_ROW_STRUCT;
63: H_SUCCESS BOOLEAN;
64:
65: l_set_of_books_id number;

Line 172: fa_standard_pkg.raise_error(

168: calling_fn => 'QUERY_BALANCES',
169: name => 'FA_WHATIF_ASSET_QUERY_BAL',
170: token1 => 'ASSET_ID',
171: value1 => to_char(X_asset_id));
172: fa_standard_pkg.raise_error(
173: CALLED_FN => 'QUERY_BALANCES',
174: CALLING_FN => 'CLIENT'
175: ,p_log_level_rec => p_log_level_rec);
176: when others then

Line 202: fa_standard_pkg.raise_error(

198: calling_fn => 'QUERY_BALANCES',
199: name => 'FA_WHATIF_ASSET_QUERY_BAL',
200: token1 => 'ASSET_ID',
201: value1 => to_char(X_asset_id));
202: fa_standard_pkg.raise_error(
203: CALLED_FN => 'QUERY_BALANCES',
204: CALLING_FN => 'CLIENT'
205: ,p_log_level_rec => p_log_level_rec);
206:

Line 385: fa_standard_pkg.raise_error(

381: EXCEPTION
382: when others then
383: fa_srvr_msg.add_sql_error(calling_fn => 'ADD_ADJ_TO_DEPRN'
384: ,p_log_level_rec => p_log_level_rec);
385: fa_standard_pkg.raise_error(
386: CALLED_FN => 'ADD_ADJ_TO_DEPRN',
387: CALLING_FN => X_CALLING_FN
388: ,p_log_level_rec => p_log_level_rec);
389:

Line 425: if (X_RUN_MODE not in ('STANDARD','ADJUSTED','DEPRN',

421:
422: X_success := FALSE;
423: h_is_acc_null := FALSE;
424:
425: if (X_RUN_MODE not in ('STANDARD','ADJUSTED','DEPRN',
426: 'TRANSACTION','INVALID')) then
427: raise bad_mode;
428: end if;
429:

Line 582: fa_standard_pkg.raise_error(

578: X_success := TRUE;
579:
580: EXCEPTION
581: when bad_mode then
582: fa_standard_pkg.raise_error(
583: CALLED_FN =>'QUERY_BALANCES_INT',
584: CALLING_FN => X_CALLING_FN,
585: NAME => 'FA_QADD_INVALID_MODE'
586: ,p_log_level_rec => p_log_level_rec);

Line 589: fa_standard_pkg.raise_error(

585: NAME => 'FA_QADD_INVALID_MODE'
586: ,p_log_level_rec => p_log_level_rec);
587:
588: when bad_trx_id then
589: fa_standard_pkg.raise_error(
590: CALLED_FN =>'QUERY_BALANCES_INT',
591: CALLING_FN => X_CALLING_FN,
592: NAME => 'FA_QADD_INVALID_TRXID'
593: ,p_log_level_rec => p_log_level_rec);

Line 599: fa_standard_pkg.raise_error(

595: when sob_cache_error then
596: fa_srvr_msg.add_sql_error
597: (calling_fn => 'fa_query_balances_pkg.query_balances_int'
598: ,p_log_level_rec => p_log_level_rec);
599: fa_standard_pkg.raise_error(
600: CALLED_FN =>'QUERY_BALANCES_INT',
601: CALLING_FN => X_CALLING_FN,
602: NAME => 'FA_QADD_INVALID_TRXID'
603: ,p_log_level_rec => p_log_level_rec);

Line 637: fa_standard_pkg.raise_error(

633: (calling_fn => 'QUERY_BALANCES_INT',
634: name => h_mesg_name
635: ,p_log_level_rec => p_log_level_rec);
636: end if;
637: fa_standard_pkg.raise_error(
638: CALLED_FN =>'QUERY_BALANCES_INT',
639: CALLING_FN => X_CALLING_FN,
640: NAME => h_mesg_name
641: ,p_log_level_rec => p_log_level_rec);

Line 690: FA_STANDARD_PKG.RAISE_ERROR (

686: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO',
687: name => 'FA_EXP_GET_CUR_PERIOD_INFO'
688: ,p_log_level_rec => p_log_level_rec);
689:
690: FA_STANDARD_PKG.RAISE_ERROR (
691: CALLED_FN => 'fa_query_balances_pkg.get_period_info',
692: CALLING_FN => X_CALLING_FN
693: ,p_log_level_rec => p_log_level_rec);
694: when others then

Line 716: FA_STANDARD_PKG.RAISE_ERROR (

712: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO',
713: name => 'FA_EXP_GET_CUR_PERIOD_INFO'
714: ,p_log_level_rec => p_log_level_rec);
715:
716: FA_STANDARD_PKG.RAISE_ERROR (
717: CALLED_FN => 'fa_query_balances_pkg.get_period_info',
718: CALLING_FN => X_CALLING_FN
719: ,p_log_level_rec => p_log_level_rec);
720:

Line 1336: fa_standard_pkg.raise_error(

1332: fa_srvr_msg.add_message(
1333: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY',
1334: name => h_mesg_name
1335: ,p_log_level_rec => p_log_level_rec);
1336: fa_standard_pkg.raise_error(
1337: CALLED_FN => 'QUERY_DEPRN_SUMMARY',
1338: CALLING_FN => X_CALLING_FN,
1339: NAME => h_mesg_name
1340: ,p_log_level_rec => p_log_level_rec);

Line 1675: fa_standard_pkg.raise_error(

1671: fa_srvr_msg.add_message(
1672: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL',
1673: name => h_mesg_name
1674: ,p_log_level_rec => p_log_level_rec);
1675: fa_standard_pkg.raise_error(
1676: CALLED_FN => 'QUERY_DEPRN_DETAIL',
1677: CALLING_FN => X_CALLING_FN,
1678: NAME => h_mesg_name
1679: ,p_log_level_rec => p_log_level_rec);

Line 1725: -- STANDARD or DEPRN mode, then we want to disregard these.

1721: end if;
1722:
1723: -- If running in ADJUSTED mode (querying from TAX book) then we're
1724: -- also interested in tax book's deprn adjustments. If in
1725: -- STANDARD or DEPRN mode, then we want to disregard these.
1726:
1727: if (X_RUN_MODE = 'ADJUSTED') then
1728: h_mode_str := 'ADJUSTED';
1729: else

Line 1730: h_mode_str := 'STANDARD';

1726:
1727: if (X_RUN_MODE = 'ADJUSTED') then
1728: h_mode_str := 'ADJUSTED';
1729: else
1730: h_mode_str := 'STANDARD';
1731: end if;
1732:
1733: -- Get book class
1734: h_book_class := fa_cache_pkg.fazcbc_record.book_class;

Line 2230: fa_standard_pkg.raise_error(

2226: fa_srvr_msg.add_message(
2227: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',
2228: name => h_mesg_name
2229: ,p_log_level_rec => p_log_level_rec);
2230: fa_standard_pkg.raise_error(
2231: CALLED_FN => 'GET_ADJUSTMENTS_INFO',
2232: CALLING_FN => X_CALLING_FN,
2233: NAME => 'FA_QADD_DET_ADJS'
2234: ,p_log_level_rec => p_log_level_rec);