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 FA_QUERY_BALANCES_PKG

Line 1: PACKAGE BODY FA_QUERY_BALANCES_PKG as

1: PACKAGE BODY FA_QUERY_BALANCES_PKG as
2: /* $Header: faxqbalb.pls 120.9.12010000.1 2008/07/28 13:27:22 appldev ship $ */
3:
4: g_print_debug boolean := fa_cache_pkg.fa_print_debug;
5:

Line 179: fname => 'FA_QUERY_BALANCES_PKG.QUERY_BALANCES',

175: ,p_log_level_rec => p_log_level_rec);
176: when others then
177: if (p_log_level_rec.statement_level) then
178: FA_DEBUG_PKG.ADD(
179: fname => 'FA_QUERY_BALANCES_PKG.QUERY_BALANCES',
180: element => 'ASSET_ID',
181: value => H_DPR_ROW.ASSET_ID
182: ,p_log_level_rec => p_log_level_rec);
183: FA_DEBUG_PKG.ADD(

Line 184: fname => 'FA_QUERY_BALANCES_PKG.QUERY_BALANCES',

180: element => 'ASSET_ID',
181: value => H_DPR_ROW.ASSET_ID
182: ,p_log_level_rec => p_log_level_rec);
183: FA_DEBUG_PKG.ADD(
184: fname => 'FA_QUERY_BALANCES_PKG.QUERY_BALANCES',
185: element => 'BOOK',
186: value => H_DPR_ROW.BOOK
187: ,p_log_level_rec => p_log_level_rec);
188: FA_DEBUG_PKG.ADD(

Line 189: fname => 'FA_QUERY_BALANCES_PKG.QUERY_BALANCES',

185: element => 'BOOK',
186: value => H_DPR_ROW.BOOK
187: ,p_log_level_rec => p_log_level_rec);
188: FA_DEBUG_PKG.ADD(
189: fname => 'FA_QUERY_BALANCES_PKG.QUERY_BALANCES',
190: element => 'COST',
191: value => H_DPR_ROW.COST
192: ,p_log_level_rec => p_log_level_rec);
193: end if;

Line 597: (calling_fn => 'fa_query_balances_pkg.query_balances_int'

593: ,p_log_level_rec => p_log_level_rec);
594:
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,

Line 608: fname => 'FA_QUERY_BALANCES_PKG.QUERY_BALANCES_INT',

604:
605: when others then
606: if (p_log_level_rec.statement_level) then
607: FA_DEBUG_PKG.ADD (
608: fname => 'FA_QUERY_BALANCES_PKG.QUERY_BALANCES_INT',
609: element => 'DIST_ID',
610: value => X_DPR_ROW.DIST_ID
611: ,p_log_level_rec => p_log_level_rec);
612: FA_DEBUG_PKG.ADD (

Line 613: fname => 'FA_QUERY_BALANCES_PKG.QUERY_BALANCES_INT',

609: element => 'DIST_ID',
610: value => X_DPR_ROW.DIST_ID
611: ,p_log_level_rec => p_log_level_rec);
612: FA_DEBUG_PKG.ADD (
613: fname => 'FA_QUERY_BALANCES_PKG.QUERY_BALANCES_INT',
614: element => 'PERIOD_CTR',
615: value => X_DPR_ROW.PERIOD_CTR
616: ,p_log_level_rec => p_log_level_rec);
617: FA_DEBUG_PKG.ADD (

Line 618: fname => 'FA_QUERY_BALANCES_PKG.QUERY_BALANCES_INT',

614: element => 'PERIOD_CTR',
615: value => X_DPR_ROW.PERIOD_CTR
616: ,p_log_level_rec => p_log_level_rec);
617: FA_DEBUG_PKG.ADD (
618: fname => 'FA_QUERY_BALANCES_PKG.QUERY_BALANCES_INT',
619: element => 'RUN_MODE',
620: value => X_RUN_MODE
621: ,p_log_level_rec => p_log_level_rec);
622: end if;

Line 683: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO'

679:
680: EXCEPTION
681: when error_found then
682: fa_srvr_msg.add_sql_error(
683: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO'
684: ,p_log_level_rec => p_log_level_rec);
685: fa_srvr_msg.add_message(
686: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO',
687: name => 'FA_EXP_GET_CUR_PERIOD_INFO'

Line 686: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO',

682: fa_srvr_msg.add_sql_error(
683: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO'
684: ,p_log_level_rec => p_log_level_rec);
685: fa_srvr_msg.add_message(
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 (

Line 691: CALLED_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
695: if (p_log_level_rec.statement_level) then

Line 697: fname =>'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO',

693: ,p_log_level_rec => p_log_level_rec);
694: when others then
695: if (p_log_level_rec.statement_level) then
696: FA_DEBUG_PKG.ADD (
697: fname =>'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO',
698: element =>'CUR_PER_CTR',
699: value =>X_CUR_PER_CTR
700: ,p_log_level_rec => p_log_level_rec);
701: FA_DEBUG_PKG.ADD (

Line 702: fname =>'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO',

698: element =>'CUR_PER_CTR',
699: value =>X_CUR_PER_CTR
700: ,p_log_level_rec => p_log_level_rec);
701: FA_DEBUG_PKG.ADD (
702: fname =>'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO',
703: element => 'NUM_PERS_FY',
704: value => X_NUM_PERS_FY
705: ,p_log_level_rec => p_log_level_rec);
706: end if;

Line 709: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO'

705: ,p_log_level_rec => p_log_level_rec);
706: end if;
707:
708: fa_srvr_msg.add_sql_error(
709: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO'
710: ,p_log_level_rec => p_log_level_rec);
711: fa_srvr_msg.add_message(
712: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO',
713: name => 'FA_EXP_GET_CUR_PERIOD_INFO'

Line 712: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO',

708: fa_srvr_msg.add_sql_error(
709: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_PERIOD_INFO'
710: ,p_log_level_rec => p_log_level_rec);
711: fa_srvr_msg.add_message(
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 (

Line 717: CALLED_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:
721: END GET_PERIOD_INFO;

Line 1308: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY',

1304: EXCEPTION
1305: when others then
1306: if (p_log_level_rec.statement_level) then
1307: FA_DEBUG_PKG.ADD (
1308: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY',
1309: element => 'ASSET_ID',
1310: value => X_DPR_ROW.ASSET_ID
1311: ,p_log_level_rec => p_log_level_rec);
1312: FA_DEBUG_PKG.ADD (

Line 1313: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY',

1309: element => 'ASSET_ID',
1310: value => X_DPR_ROW.ASSET_ID
1311: ,p_log_level_rec => p_log_level_rec);
1312: FA_DEBUG_PKG.ADD (
1313: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY',
1314: element => 'BOOK',
1315: value => X_DPR_ROW.BOOK
1316: ,p_log_level_rec => p_log_level_rec);
1317: FA_DEBUG_PKG.ADD (

Line 1318: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY',

1314: element => 'BOOK',
1315: value => X_DPR_ROW.BOOK
1316: ,p_log_level_rec => p_log_level_rec);
1317: FA_DEBUG_PKG.ADD (
1318: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY',
1319: element => 'h_cur_per_ctr',
1320: value => h_cur_per_ctr
1321: ,p_log_level_rec => p_log_level_rec);
1322: FA_DEBUG_PKG.ADD (

Line 1323: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY',

1319: element => 'h_cur_per_ctr',
1320: value => h_cur_per_ctr
1321: ,p_log_level_rec => p_log_level_rec);
1322: FA_DEBUG_PKG.ADD (
1323: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY',
1324: element => 'RUN_MODE',
1325: value => X_RUN_MODE
1326: ,p_log_level_rec => p_log_level_rec);
1327: end if;

Line 1330: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY'

1326: ,p_log_level_rec => p_log_level_rec);
1327: end if;
1328:
1329: fa_srvr_msg.add_sql_error(
1330: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY'
1331: ,p_log_level_rec => p_log_level_rec);
1332: fa_srvr_msg.add_message(
1333: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY',
1334: name => h_mesg_name

Line 1333: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY',

1329: fa_srvr_msg.add_sql_error(
1330: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_SUMMARY'
1331: ,p_log_level_rec => p_log_level_rec);
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',

Line 1648: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL',

1644: EXCEPTION
1645: when others then
1646: if (p_log_level_rec.statement_level) then
1647: FA_DEBUG_PKG.ADD (
1648: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL',
1649: element => 'ASSET_ID',
1650: value => X_DPR_ROW.ASSET_ID
1651: ,p_log_level_rec => p_log_level_rec);
1652: FA_DEBUG_PKG.ADD (

Line 1653: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL',

1649: element => 'ASSET_ID',
1650: value => X_DPR_ROW.ASSET_ID
1651: ,p_log_level_rec => p_log_level_rec);
1652: FA_DEBUG_PKG.ADD (
1653: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL',
1654: element => 'BOOK',
1655: value => X_DPR_ROW.BOOK
1656: ,p_log_level_rec => p_log_level_rec);
1657: FA_DEBUG_PKG.ADD (

Line 1658: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL',

1654: element => 'BOOK',
1655: value => X_DPR_ROW.BOOK
1656: ,p_log_level_rec => p_log_level_rec);
1657: FA_DEBUG_PKG.ADD (
1658: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL',
1659: element => 'h_cur_per_ctr',
1660: value => h_cur_per_ctr
1661: ,p_log_level_rec => p_log_level_rec);
1662: FA_DEBUG_PKG.ADD (

Line 1663: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL',

1659: element => 'h_cur_per_ctr',
1660: value => h_cur_per_ctr
1661: ,p_log_level_rec => p_log_level_rec);
1662: FA_DEBUG_PKG.ADD (
1663: fname => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL',
1664: element => 'RUN_MODE',
1665: value => X_RUN_MODE
1666: ,p_log_level_rec => p_log_level_rec);
1667: end if;

Line 1669: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL'

1665: value => X_RUN_MODE
1666: ,p_log_level_rec => p_log_level_rec);
1667: end if;
1668: fa_srvr_msg.add_sql_error(
1669: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL'
1670: ,p_log_level_rec => p_log_level_rec);
1671: fa_srvr_msg.add_message(
1672: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL',
1673: name => h_mesg_name

Line 1672: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL',

1668: fa_srvr_msg.add_sql_error(
1669: calling_fn => 'FA_QUERY_BALANCES_PKG.QUERY_DEPRN_DETAIL'
1670: ,p_log_level_rec => p_log_level_rec);
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',

Line 2193: fname => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',

2189: X_success := TRUE;
2190: else
2191: if (p_log_level_rec.statement_level) then
2192: FA_DEBUG_PKG.ADD (
2193: fname => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',
2194: element => 'FOUND_PER_CTR',
2195: value => X_FOUND_PER_CTR
2196: ,p_log_level_rec => p_log_level_rec);
2197: FA_DEBUG_PKG.ADD (

Line 2198: fname => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',

2194: element => 'FOUND_PER_CTR',
2195: value => X_FOUND_PER_CTR
2196: ,p_log_level_rec => p_log_level_rec);
2197: FA_DEBUG_PKG.ADD (
2198: fname => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',
2199: element => 'RUN_MODE',
2200: value => h_mode_str
2201: ,p_log_level_rec => p_log_level_rec);
2202: FA_DEBUG_PKG.ADD (

Line 2203: fname => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',

2199: element => 'RUN_MODE',
2200: value => h_mode_str
2201: ,p_log_level_rec => p_log_level_rec);
2202: FA_DEBUG_PKG.ADD (
2203: fname => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',
2204: element => 'ASSET_ID',
2205: value => X_ADJ_ROW.ASSET_ID
2206: ,p_log_level_rec => p_log_level_rec);
2207: FA_DEBUG_PKG.ADD (

Line 2208: fname => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',

2204: element => 'ASSET_ID',
2205: value => X_ADJ_ROW.ASSET_ID
2206: ,p_log_level_rec => p_log_level_rec);
2207: FA_DEBUG_PKG.ADD (
2208: fname => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',
2209: element => 'BOOK',
2210: value => X_ADJ_ROW.BOOK
2211: ,p_log_level_rec => p_log_level_rec);
2212: FA_DEBUG_PKG.ADD (

Line 2213: fname => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',

2209: element => 'BOOK',
2210: value => X_ADJ_ROW.BOOK
2211: ,p_log_level_rec => p_log_level_rec);
2212: FA_DEBUG_PKG.ADD (
2213: fname => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',
2214: element => 'DIST_ID',
2215: value => X_ADJ_ROW.DIST_ID
2216: ,p_log_level_rec => p_log_level_rec);
2217: FA_DEBUG_PKG.ADD (

Line 2218: fname => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',

2214: element => 'DIST_ID',
2215: value => X_ADJ_ROW.DIST_ID
2216: ,p_log_level_rec => p_log_level_rec);
2217: FA_DEBUG_PKG.ADD (
2218: fname => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',
2219: element => 'TRANSACTION_HEADER_ID',
2220: value => X_TRANSACTION_HEADER_ID
2221: ,p_log_level_rec => p_log_level_rec);
2222: end if;

Line 2224: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO'

2220: value => X_TRANSACTION_HEADER_ID
2221: ,p_log_level_rec => p_log_level_rec);
2222: end if;
2223: fa_srvr_msg.add_sql_error(
2224: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO'
2225: ,p_log_level_rec => p_log_level_rec);
2226: fa_srvr_msg.add_message(
2227: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',
2228: name => h_mesg_name

Line 2227: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO',

2223: fa_srvr_msg.add_sql_error(
2224: calling_fn => 'FA_QUERY_BALANCES_PKG.GET_ADJUSTMENTS_INFO'
2225: ,p_log_level_rec => p_log_level_rec);
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',

Line 2239: END FA_QUERY_BALANCES_PKG;

2235: end if;
2236:
2237: END GET_ADJUSTMENTS_INFO;
2238:
2239: END FA_QUERY_BALANCES_PKG;