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_RX_GROUP dependencies on FA_RX_UTIL_PKG

Line 110: fa_rx_util_pkg.debug('get_group_asset_info: '

106: l_log_level_rec FA_API_TYPES.log_level_rec_type;
107:
108: BEGIN
109: IF g_print_debug THEN
110: fa_rx_util_pkg.debug('get_group_asset_info: '
111: || 'farx_ga.get_group_asset_info()+');
112: fa_rx_util_pkg.debug('get_group_asset_info: '
113: || 'book: ' || p_book_type_code);
114: fa_rx_util_pkg.debug('get_group_asset_info: '

Line 112: fa_rx_util_pkg.debug('get_group_asset_info: '

108: BEGIN
109: IF g_print_debug THEN
110: fa_rx_util_pkg.debug('get_group_asset_info: '
111: || 'farx_ga.get_group_asset_info()+');
112: fa_rx_util_pkg.debug('get_group_asset_info: '
113: || 'book: ' || p_book_type_code);
114: fa_rx_util_pkg.debug('get_group_asset_info: '
115: || 'fiscal year from: ' || p_start_fiscal_year);
116: fa_rx_util_pkg.debug('get_group_asset_info: '

Line 114: fa_rx_util_pkg.debug('get_group_asset_info: '

110: fa_rx_util_pkg.debug('get_group_asset_info: '
111: || 'farx_ga.get_group_asset_info()+');
112: fa_rx_util_pkg.debug('get_group_asset_info: '
113: || 'book: ' || p_book_type_code);
114: fa_rx_util_pkg.debug('get_group_asset_info: '
115: || 'fiscal year from: ' || p_start_fiscal_year);
116: fa_rx_util_pkg.debug('get_group_asset_info: '
117: || 'fiscal year to: ' || p_end_fiscal_year);
118: fa_rx_util_pkg.debug('get_group_asset_info: '

Line 116: fa_rx_util_pkg.debug('get_group_asset_info: '

112: fa_rx_util_pkg.debug('get_group_asset_info: '
113: || 'book: ' || p_book_type_code);
114: fa_rx_util_pkg.debug('get_group_asset_info: '
115: || 'fiscal year from: ' || p_start_fiscal_year);
116: fa_rx_util_pkg.debug('get_group_asset_info: '
117: || 'fiscal year to: ' || p_end_fiscal_year);
118: fa_rx_util_pkg.debug('get_group_asset_info: '
119: || 'user_id: ' || p_user_id);
120: fa_rx_util_pkg.debug('get_group_asset_info: '

Line 118: fa_rx_util_pkg.debug('get_group_asset_info: '

114: fa_rx_util_pkg.debug('get_group_asset_info: '
115: || 'fiscal year from: ' || p_start_fiscal_year);
116: fa_rx_util_pkg.debug('get_group_asset_info: '
117: || 'fiscal year to: ' || p_end_fiscal_year);
118: fa_rx_util_pkg.debug('get_group_asset_info: '
119: || 'user_id: ' || p_user_id);
120: fa_rx_util_pkg.debug('get_group_asset_info: '
121: || 'request_id: ' || p_request_id);
122: END IF;

Line 120: fa_rx_util_pkg.debug('get_group_asset_info: '

116: fa_rx_util_pkg.debug('get_group_asset_info: '
117: || 'fiscal year to: ' || p_end_fiscal_year);
118: fa_rx_util_pkg.debug('get_group_asset_info: '
119: || 'user_id: ' || p_user_id);
120: fa_rx_util_pkg.debug('get_group_asset_info: '
121: || 'request_id: ' || p_request_id);
122: END IF;
123: l_message := 'get_group_asset_info start';
124:

Line 174: fa_rx_util_pkg.debug('get_group_asset_info: '

170: AND sob.set_of_books_id = decode(H_MRCSOBTYPE, 'P', bc.set_of_books_id, h_sob_id) -- MRC
171: AND sob.currency_code = cur.currency_code;
172:
173: IF g_print_debug THEN
174: fa_rx_util_pkg.debug('get_group_asset_info: '
175: || 'set_of_books_id: ' || l_info_rec.set_of_books_id);
176: fa_rx_util_pkg.debug('get_group_asset_info: '
177: || 'deprn_calendar: ' || l_info_rec.deprn_calendar);
178: END IF;

Line 176: fa_rx_util_pkg.debug('get_group_asset_info: '

172:
173: IF g_print_debug THEN
174: fa_rx_util_pkg.debug('get_group_asset_info: '
175: || 'set_of_books_id: ' || l_info_rec.set_of_books_id);
176: fa_rx_util_pkg.debug('get_group_asset_info: '
177: || 'deprn_calendar: ' || l_info_rec.deprn_calendar);
178: END IF;
179: l_message := 'initialization end';
180:

Line 232: fa_rx_util_pkg.debug('get_group_asset_info: '

228: || p_asset_number_high || '''';
229: END IF;
230:
231: IF g_print_debug THEN
232: fa_rx_util_pkg.debug('get_group_asset_info: '
233: || 'l_param_where_stmt:' || l_param_where_stmt);
234: END IF;
235: l_message := 'category sql end';
236:

Line 327: fa_rx_util_pkg.debug('get_group_asset_info: '

323: get_where_sql_stmt(l_info_rec, NULL, h_mrcsobtype, l_sql_stmt); -- MRC
324: l_group_sql_stmt := l_group_sql_stmt || l_sql_stmt || l_param_where_stmt;
325:
326: IF g_print_debug THEN
327: fa_rx_util_pkg.debug('get_group_asset_info: '
328: || 'l_group_sql_stmt:' || l_group_sql_stmt);
329: END IF;
330: l_message := 'fiscal year loop (2)';
331:

Line 343: fa_rx_util_pkg.debug('get_group_asset_info: '

339:
340: l_message := 'group loop (1)';
341:
342: IF g_print_debug THEN
343: fa_rx_util_pkg.debug('get_group_asset_info: '
344: || 'group_asset: ' || l_group_rec.asset_number);
345: END IF;
346:
347: ----------------------------------------------------------

Line 734: fa_rx_util_pkg.debug('l_all_reduced_deprn_amount: '

730: raise main_err;
731: END IF;
732:
733: IF g_print_debug THEN
734: fa_rx_util_pkg.debug('l_all_reduced_deprn_amount: '
735: || l_all_reduced_deprn_amount);
736: fa_rx_util_pkg.debug('annual_deprn_amount: '
737: || l_group_rec.annual_deprn_amount);
738: END IF;

Line 736: fa_rx_util_pkg.debug('annual_deprn_amount: '

732:
733: IF g_print_debug THEN
734: fa_rx_util_pkg.debug('l_all_reduced_deprn_amount: '
735: || l_all_reduced_deprn_amount);
736: fa_rx_util_pkg.debug('annual_deprn_amount: '
737: || l_group_rec.annual_deprn_amount);
738: END IF;
739:
740: IF l_group_rec.annual_deprn_amount = l_all_reduced_deprn_amount THEN

Line 808: fa_rx_util_pkg.debug('get_group_asset_info: '

804: l_info_rec.fiscal_year := l_info_rec.fiscal_year + 1;
805: END LOOP; -- fiscal year loop
806:
807: IF g_print_debug THEN
808: fa_rx_util_pkg.debug('get_group_asset_info: '
809: || 'farx_ga.get_group_asset_info()-');
810: END IF;
811:
812: EXCEPTION

Line 815: fa_rx_util_pkg.log(sqlcode);

811:
812: EXCEPTION
813: WHEN OTHERS THEN
814: IF g_print_debug THEN
815: fa_rx_util_pkg.log(sqlcode);
816: fa_rx_util_pkg.log(sqlerrm);
817: fa_rx_util_pkg.log(l_message);
818: END IF;
819:

Line 816: fa_rx_util_pkg.log(sqlerrm);

812: EXCEPTION
813: WHEN OTHERS THEN
814: IF g_print_debug THEN
815: fa_rx_util_pkg.log(sqlcode);
816: fa_rx_util_pkg.log(sqlerrm);
817: fa_rx_util_pkg.log(l_message);
818: END IF;
819:
820: IF sqlcode <> 0 THEN

Line 817: fa_rx_util_pkg.log(l_message);

813: WHEN OTHERS THEN
814: IF g_print_debug THEN
815: fa_rx_util_pkg.log(sqlcode);
816: fa_rx_util_pkg.log(sqlerrm);
817: fa_rx_util_pkg.log(l_message);
818: END IF;
819:
820: IF sqlcode <> 0 THEN
821: fa_rx_conc_mesg_pkg.log(sqlerrm);

Line 833: fa_rx_util_pkg.debug('get_group_asset_info: '

829: END IF;
830:
831: x_retcode := 2;
832: IF g_print_debug THEN
833: fa_rx_util_pkg.debug('get_group_asset_info: '
834: || 'farx_ga.get_group_asset_info(EXCEPTION)-');
835: END IF;
836:
837: END get_group_asset_info;

Line 858: fa_rx_util_pkg.debug('get_category_sql: '

854: x_where_stmt OUT NOCOPY VARCHAR2)
855: IS
856: BEGIN
857: IF g_print_debug THEN
858: fa_rx_util_pkg.debug('get_category_sql: '
859: || 'p_application_id: ' || p_application_id);
860: fa_rx_util_pkg.debug('get_category_sql: ' || 'p_category_flex_structure: '
861: || p_category_flex_structure);
862: fa_rx_util_pkg.debug('get_category_sql: '

Line 860: fa_rx_util_pkg.debug('get_category_sql: ' || 'p_category_flex_structure: '

856: BEGIN
857: IF g_print_debug THEN
858: fa_rx_util_pkg.debug('get_category_sql: '
859: || 'p_application_id: ' || p_application_id);
860: fa_rx_util_pkg.debug('get_category_sql: ' || 'p_category_flex_structure: '
861: || p_category_flex_structure);
862: fa_rx_util_pkg.debug('get_category_sql: '
863: || 'p_qualifier: ' || p_qualifier);
864: fa_rx_util_pkg.debug('get_category_sql: '

Line 862: fa_rx_util_pkg.debug('get_category_sql: '

858: fa_rx_util_pkg.debug('get_category_sql: '
859: || 'p_application_id: ' || p_application_id);
860: fa_rx_util_pkg.debug('get_category_sql: ' || 'p_category_flex_structure: '
861: || p_category_flex_structure);
862: fa_rx_util_pkg.debug('get_category_sql: '
863: || 'p_qualifier: ' || p_qualifier);
864: fa_rx_util_pkg.debug('get_category_sql: '
865: || 'p_category_low: ' || p_category_low);
866: fa_rx_util_pkg.debug('get_category_sql: '

Line 864: fa_rx_util_pkg.debug('get_category_sql: '

860: fa_rx_util_pkg.debug('get_category_sql: ' || 'p_category_flex_structure: '
861: || p_category_flex_structure);
862: fa_rx_util_pkg.debug('get_category_sql: '
863: || 'p_qualifier: ' || p_qualifier);
864: fa_rx_util_pkg.debug('get_category_sql: '
865: || 'p_category_low: ' || p_category_low);
866: fa_rx_util_pkg.debug('get_category_sql: '
867: || 'p_category_high: ' || p_category_high);
868: END IF;

Line 866: fa_rx_util_pkg.debug('get_category_sql: '

862: fa_rx_util_pkg.debug('get_category_sql: '
863: || 'p_qualifier: ' || p_qualifier);
864: fa_rx_util_pkg.debug('get_category_sql: '
865: || 'p_category_low: ' || p_category_low);
866: fa_rx_util_pkg.debug('get_category_sql: '
867: || 'p_category_high: ' || p_category_high);
868: END IF;
869:
870:

Line 941: fa_rx_util_pkg.debug('get_category_sql: '

937:
938: EXCEPTION
939: WHEN OTHERS THEN
940: IF g_print_debug THEN
941: fa_rx_util_pkg.debug('get_category_sql: '
942: || 'farx_ga.get_category_sql(EXCEPTION)-');
943: END IF;
944: raise;
945: END get_category_sql;

Line 1055: fa_rx_util_pkg.debug('get_from_sql_stmt: '

1051:
1052: EXCEPTION
1053: WHEN OTHERS THEN
1054: IF g_print_debug THEN
1055: fa_rx_util_pkg.debug('get_from_sql_stmt: '
1056: || 'farx_ga.get_from_sql_stmt(EXCEPTION)-');
1057: END IF;
1058: raise;
1059: END get_from_sql_stmt;

Line 1161: fa_rx_util_pkg.debug('get_where_sql_stmt: '

1157:
1158: EXCEPTION
1159: WHEN OTHERS THEN
1160: IF g_print_debug THEN
1161: fa_rx_util_pkg.debug('get_where_sql_stmt: '
1162: || 'farx_ga.get_where_sql_stmt(EXCEPTION)-');
1163: END IF;
1164: raise;
1165: END get_where_sql_stmt;

Line 1347: fa_rx_util_pkg.debug('get_trx_amount_sql: '

1343:
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: IF g_print_debug THEN
1347: fa_rx_util_pkg.debug('get_trx_amount_sql: '
1348: || 'farx_ga.get_trx_amount_sql(EXCEPTION)-');
1349: END IF;
1350: raise;
1351: END get_trx_amount_sql;

Line 1430: fa_rx_util_pkg.debug('get_retirement_sql: '

1426:
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: IF g_print_debug THEN
1430: fa_rx_util_pkg.debug('get_retirement_sql: '
1431: || 'farx_ga.get_retirement_sql(EXCEPTION)-');
1432: END IF;
1433: raise;
1434: END get_retirement_sql;

Line 1560: fa_rx_util_pkg.debug('insert_data: '

1556:
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: IF g_print_debug THEN
1560: fa_rx_util_pkg.debug('insert_data: '
1561: || 'farx_ga.insert_data(EXCEPTION)-');
1562: END IF;
1563: raise;
1564: END insert_data;

Line 1934: fa_rx_util_pkg.log(sqlcode);

1930:
1931: EXCEPTION
1932: WHEN OTHERS THEN
1933: IF g_print_debug THEN
1934: fa_rx_util_pkg.log(sqlcode);
1935: fa_rx_util_pkg.log(sqlerrm);
1936: fa_rx_util_pkg.log(l_message);
1937: fa_rx_util_pkg.debug('query_member_assets: '
1938: || 'farx_ga.query_member_assets(EXCEPTION)-');

Line 1935: fa_rx_util_pkg.log(sqlerrm);

1931: EXCEPTION
1932: WHEN OTHERS THEN
1933: IF g_print_debug THEN
1934: fa_rx_util_pkg.log(sqlcode);
1935: fa_rx_util_pkg.log(sqlerrm);
1936: fa_rx_util_pkg.log(l_message);
1937: fa_rx_util_pkg.debug('query_member_assets: '
1938: || 'farx_ga.query_member_assets(EXCEPTION)-');
1939: END IF;

Line 1936: fa_rx_util_pkg.log(l_message);

1932: WHEN OTHERS THEN
1933: IF g_print_debug THEN
1934: fa_rx_util_pkg.log(sqlcode);
1935: fa_rx_util_pkg.log(sqlerrm);
1936: fa_rx_util_pkg.log(l_message);
1937: fa_rx_util_pkg.debug('query_member_assets: '
1938: || 'farx_ga.query_member_assets(EXCEPTION)-');
1939: END IF;
1940:

Line 1937: fa_rx_util_pkg.debug('query_member_assets: '

1933: IF g_print_debug THEN
1934: fa_rx_util_pkg.log(sqlcode);
1935: fa_rx_util_pkg.log(sqlerrm);
1936: fa_rx_util_pkg.log(l_message);
1937: fa_rx_util_pkg.debug('query_member_assets: '
1938: || 'farx_ga.query_member_assets(EXCEPTION)-');
1939: END IF;
1940:
1941: IF sqlcode <> 0 THEN