DBA Data[Home] [Help]

APPS.FA_QUERY_BALANCES_PKG dependencies on FA_SRVR_MSG

Line 158: fa_srvr_msg.add_sql_error(

154:
155:
156: EXCEPTION
157: when error_found then
158: fa_srvr_msg.add_sql_error(
159: calling_fn => 'QUERY_BALANCES', p_log_level_rec => p_log_level_rec);
160: fa_srvr_msg.add_message(
161: calling_fn => 'QUERY_BALANCES',
162: name => 'FA_WHATIF_ASSET_QUERY_BAL',

Line 160: fa_srvr_msg.add_message(

156: EXCEPTION
157: when error_found then
158: fa_srvr_msg.add_sql_error(
159: calling_fn => 'QUERY_BALANCES', p_log_level_rec => p_log_level_rec);
160: fa_srvr_msg.add_message(
161: calling_fn => 'QUERY_BALANCES',
162: name => 'FA_WHATIF_ASSET_QUERY_BAL',
163: token1 => 'ASSET_ID',
164: value1 => to_char(X_asset_id),

Line 184: fa_srvr_msg.add_sql_error(

180: fname => 'FA_QUERY_BALANCES_PKG.QUERY_BALANCES',
181: element => 'COST',
182: value => H_DPR_ROW.COST, p_log_level_rec => p_log_level_rec);
183: end if;
184: fa_srvr_msg.add_sql_error(
185: calling_fn => 'QUERY_BALANCES', p_log_level_rec => p_log_level_rec);
186: fa_srvr_msg.add_message(
187: calling_fn => 'QUERY_BALANCES',
188: name => 'FA_WHATIF_ASSET_QUERY_BAL',

Line 186: fa_srvr_msg.add_message(

182: value => H_DPR_ROW.COST, p_log_level_rec => p_log_level_rec);
183: end if;
184: fa_srvr_msg.add_sql_error(
185: calling_fn => 'QUERY_BALANCES', p_log_level_rec => p_log_level_rec);
186: fa_srvr_msg.add_message(
187: calling_fn => 'QUERY_BALANCES',
188: name => 'FA_WHATIF_ASSET_QUERY_BAL',
189: token1 => 'ASSET_ID',
190: value1 => to_char(X_asset_id),

Line 397: fa_srvr_msg.add_sql_error(calling_fn => 'ADD_ADJ_TO_DEPRN', p_log_level_rec => p_log_level_rec);

393: X_success := TRUE;
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:

Line 600: fa_srvr_msg.add_sql_error

596: CALLING_FN => X_CALLING_FN,
597: NAME => 'FA_QADD_INVALID_TRXID', p_log_level_rec => p_log_level_rec);
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,

Line 622: fa_srvr_msg.add_sql_error(calling_fn => 'QUERY_BALANCES_INT', p_log_level_rec => p_log_level_rec);

618: fname => 'FA_QUERY_BALANCES_PKG.QUERY_BALANCES_INT',
619: element => 'RUN_MODE',
620: value => X_RUN_MODE, p_log_level_rec => p_log_level_rec);
621: end if;
622: fa_srvr_msg.add_sql_error(calling_fn => 'QUERY_BALANCES_INT', p_log_level_rec => p_log_level_rec);
623: if h_mesg_name = 'FA_WHATIF_ASSET_QUERY_BAL' then
624: fa_srvr_msg.add_message
625: (calling_fn => 'QUERY_BALANCES_INT',
626: name => h_mesg_name,

Line 624: fa_srvr_msg.add_message

620: value => X_RUN_MODE, p_log_level_rec => p_log_level_rec);
621: end if;
622: fa_srvr_msg.add_sql_error(calling_fn => 'QUERY_BALANCES_INT', p_log_level_rec => p_log_level_rec);
623: if h_mesg_name = 'FA_WHATIF_ASSET_QUERY_BAL' then
624: fa_srvr_msg.add_message
625: (calling_fn => 'QUERY_BALANCES_INT',
626: name => h_mesg_name,
627: token1 => 'ASSET_ID',
628: value1 => to_char(X_dpr_row.asset_id),

Line 631: fa_srvr_msg.add_message

627: token1 => 'ASSET_ID',
628: value1 => to_char(X_dpr_row.asset_id),
629: p_log_level_rec => p_log_level_rec);
630: else
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(

Line 677: fa_srvr_msg.add_sql_error(

673: X_SUCCESS := TRUE;
674:
675: EXCEPTION
676: when error_found then
677: fa_srvr_msg.add_sql_error(
678: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO', p_log_level_rec => p_log_level_rec);
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);

Line 679: fa_srvr_msg.add_message(

675: EXCEPTION
676: when error_found then
677: fa_srvr_msg.add_sql_error(
678: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO', p_log_level_rec => p_log_level_rec);
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 (

Line 698: fa_srvr_msg.add_sql_error(

694: element => 'NUM_PERS_FY',
695: value => X_NUM_PERS_FY, p_log_level_rec => p_log_level_rec);
696: end if;
697:
698: fa_srvr_msg.add_sql_error(
699: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO', p_log_level_rec => p_log_level_rec);
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);

Line 700: fa_srvr_msg.add_message(

696: end if;
697:
698: fa_srvr_msg.add_sql_error(
699: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO', p_log_level_rec => p_log_level_rec);
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 (

Line 1409: fa_srvr_msg.add_sql_error(

1405: element => 'RUN_MODE',
1406: value => X_RUN_MODE, p_log_level_rec => p_log_level_rec);
1407: end if;
1408:
1409: fa_srvr_msg.add_sql_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);

Line 1411: fa_srvr_msg.add_message(

1407: end if;
1408:
1409: fa_srvr_msg.add_sql_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',

Line 1782: fa_srvr_msg.add_sql_error(

1778: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL',
1779: element => 'RUN_MODE',
1780: value => X_RUN_MODE, p_log_level_rec => p_log_level_rec);
1781: end if;
1782: fa_srvr_msg.add_sql_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);

Line 1784: fa_srvr_msg.add_message(

1780: value => X_RUN_MODE, p_log_level_rec => p_log_level_rec);
1781: end if;
1782: fa_srvr_msg.add_sql_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',

Line 2488: fa_srvr_msg.add_sql_error(

2484: fname => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',
2485: element => 'TRANSACTION_HEADER_ID',
2486: value => X_TRANSACTION_HEADER_ID, p_log_level_rec => p_log_level_rec);
2487: end if;
2488: fa_srvr_msg.add_sql_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);

Line 2490: fa_srvr_msg.add_message(

2486: value => X_TRANSACTION_HEADER_ID, p_log_level_rec => p_log_level_rec);
2487: end if;
2488: fa_srvr_msg.add_sql_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',