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 10: -- STANDARD: Query detail/summary in given period from CORPORATE book.

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

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

8:
9: -- Can call in several "RUN_MODEs":
10: -- STANDARD: Query detail/summary in given period from CORPORATE book.
11: -- ADJUSTED: Query detail/summary in given period from TAX book.
12: -- For both STANDARD/ADJUSTED: Returns period-closing balances if period
13: -- is closed. If current period, returns last period's closing balances
14: -- plus any adjustments from this period.
15: -- DEPRN: Query everything except deprn balances... return these as
16: -- 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 68: -- Use the Standard Type define in faxstds.pls

64: X_MRC_SOB_TYPE_CODE IN VARCHAR2,
65: X_SET_OF_BOOKS_ID IN NUMBER,
66: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
67:
68: -- Use the Standard Type define in faxstds.pls
69: H_DPR_ROW FA_STD_TYPES.FA_DEPRN_ROW_STRUCT;
70: H_SUCCESS BOOLEAN;
71:
72: cursor c_get_group_info is

Line 166: fa_standard_pkg.raise_error(

162: name => 'FA_WHATIF_ASSET_QUERY_BAL',
163: token1 => 'ASSET_ID',
164: value1 => to_char(X_asset_id),
165: p_log_level_rec => p_log_level_rec);
166: fa_standard_pkg.raise_error(
167: CALLED_FN => 'QUERY_BALANCES',
168: CALLING_FN => 'CLIENT', p_log_level_rec => p_log_level_rec);
169: when others then
170: if (p_log_level_rec.statement_level) then

Line 192: fa_standard_pkg.raise_error(

188: name => 'FA_WHATIF_ASSET_QUERY_BAL',
189: token1 => 'ASSET_ID',
190: value1 => to_char(X_asset_id),
191: p_log_level_rec => p_log_level_rec);
192: fa_standard_pkg.raise_error(
193: CALLED_FN => 'QUERY_BALANCES',
194: CALLING_FN => 'CLIENT', p_log_level_rec => p_log_level_rec);
195:
196: END QUERY_BALANCES;

Line 398: fa_standard_pkg.raise_error(

394:
395: EXCEPTION
396: when others then
397: fa_srvr_msg.add_sql_error(calling_fn => 'ADD_ADJ_TO_DEPRN', p_log_level_rec => p_log_level_rec);
398: fa_standard_pkg.raise_error(
399: CALLED_FN => 'ADD_ADJ_TO_DEPRN',
400: CALLING_FN => X_CALLING_FN, p_log_level_rec => p_log_level_rec);
401:
402: END ADD_ADJ_TO_DEPRN;

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

432:
433: X_success := FALSE;
434: h_is_acc_null := FALSE;
435:
436: if (X_RUN_MODE not in ('STANDARD','ADJUSTED','DEPRN',
437: 'TRANSACTION','INVALID')) then
438: raise bad_mode;
439: end if;
440:

Line 588: fa_standard_pkg.raise_error(

584: X_success := TRUE;
585:
586: EXCEPTION
587: when bad_mode then
588: fa_standard_pkg.raise_error(
589: CALLED_FN =>'QUERY_BALANCES_INT',
590: CALLING_FN => X_CALLING_FN,
591: NAME => 'FA_QADD_INVALID_MODE', p_log_level_rec => p_log_level_rec);
592:

Line 594: fa_standard_pkg.raise_error(

590: CALLING_FN => X_CALLING_FN,
591: NAME => 'FA_QADD_INVALID_MODE', p_log_level_rec => p_log_level_rec);
592:
593: when bad_trx_id then
594: fa_standard_pkg.raise_error(
595: CALLED_FN =>'QUERY_BALANCES_INT',
596: CALLING_FN => X_CALLING_FN,
597: NAME => 'FA_QADD_INVALID_TRXID', p_log_level_rec => p_log_level_rec);
598:

Line 602: fa_standard_pkg.raise_error(

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

Line 635: fa_standard_pkg.raise_error(

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

Line 683: FA_STANDARD_PKG.RAISE_ERROR (

679: fa_srvr_msg.add_message(
680: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO',
681: name => 'FA_EXP_GET_CUR_PERIOD_INFO', p_log_level_rec => p_log_level_rec);
682:
683: FA_STANDARD_PKG.RAISE_ERROR (
684: CALLED_FN => 'fa_query_balances_pkg.get_period_info',
685: CALLING_FN => X_CALLING_FN, p_log_level_rec => p_log_level_rec);
686: when others then
687: if (p_log_level_rec.statement_level) then

Line 704: FA_STANDARD_PKG.RAISE_ERROR (

700: fa_srvr_msg.add_message(
701: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO',
702: name => 'FA_EXP_GET_CUR_PERIOD_INFO', p_log_level_rec => p_log_level_rec);
703:
704: FA_STANDARD_PKG.RAISE_ERROR (
705: CALLED_FN => 'fa_query_balances_pkg.get_period_info',
706: CALLING_FN => X_CALLING_FN, p_log_level_rec => p_log_level_rec);
707:
708: END GET_PERIOD_INFO;

Line 1414: fa_standard_pkg.raise_error(

1410: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY', p_log_level_rec => p_log_level_rec);
1411: fa_srvr_msg.add_message(
1412: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY',
1413: name => h_mesg_name, p_log_level_rec => p_log_level_rec);
1414: fa_standard_pkg.raise_error(
1415: CALLED_FN => 'QUERY_DEPRN_SUMMARY',
1416: CALLING_FN => X_CALLING_FN,
1417: NAME => h_mesg_name, p_log_level_rec => p_log_level_rec);
1418:

Line 1787: fa_standard_pkg.raise_error(

1783: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL', p_log_level_rec => p_log_level_rec);
1784: fa_srvr_msg.add_message(
1785: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL',
1786: name => h_mesg_name, p_log_level_rec => p_log_level_rec);
1787: fa_standard_pkg.raise_error(
1788: CALLED_FN => 'QUERY_DEPRN_DETAIL',
1789: CALLING_FN => X_CALLING_FN,
1790: NAME => h_mesg_name, p_log_level_rec => p_log_level_rec);
1791:

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

1830: end if;
1831:
1832: -- If running in ADJUSTED mode (querying from TAX book) then we're
1833: -- also interested in tax book's deprn adjustments. If in
1834: -- STANDARD or DEPRN mode, then we want to disregard these.
1835:
1836: if (X_RUN_MODE = 'ADJUSTED') then
1837: h_mode_str := 'ADJUSTED';
1838: else

Line 1839: h_mode_str := 'STANDARD';

1835:
1836: if (X_RUN_MODE = 'ADJUSTED') then
1837: h_mode_str := 'ADJUSTED';
1838: else
1839: h_mode_str := 'STANDARD';
1840: end if;
1841:
1842: -- Get book class
1843: h_book_class := fa_cache_pkg.fazcbc_record.book_class;

Line 2493: fa_standard_pkg.raise_error(

2489: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO', p_log_level_rec => p_log_level_rec);
2490: fa_srvr_msg.add_message(
2491: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',
2492: name => h_mesg_name, p_log_level_rec => p_log_level_rec);
2493: fa_standard_pkg.raise_error(
2494: CALLED_FN => 'GET_ADJUSTMENTS_INFO',
2495: CALLING_FN => X_CALLING_FN,
2496: NAME => 'FA_QADD_DET_ADJS', p_log_level_rec => p_log_level_rec);
2497: end if;