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 58: fa_rx_util_pkg.debug('get_group_asset_info: '

54:
55: main_err EXCEPTION;
56: BEGIN
57: IF g_print_debug THEN
58: fa_rx_util_pkg.debug('get_group_asset_info: '
59: || 'farx_ga.get_group_asset_info()+');
60: fa_rx_util_pkg.debug('get_group_asset_info: '
61: || 'book: ' || p_book_type_code);
62: fa_rx_util_pkg.debug('get_group_asset_info: '

Line 60: fa_rx_util_pkg.debug('get_group_asset_info: '

56: BEGIN
57: IF g_print_debug THEN
58: fa_rx_util_pkg.debug('get_group_asset_info: '
59: || 'farx_ga.get_group_asset_info()+');
60: fa_rx_util_pkg.debug('get_group_asset_info: '
61: || 'book: ' || p_book_type_code);
62: fa_rx_util_pkg.debug('get_group_asset_info: '
63: || 'fiscal year from: ' || p_start_fiscal_year);
64: fa_rx_util_pkg.debug('get_group_asset_info: '

Line 62: fa_rx_util_pkg.debug('get_group_asset_info: '

58: fa_rx_util_pkg.debug('get_group_asset_info: '
59: || 'farx_ga.get_group_asset_info()+');
60: fa_rx_util_pkg.debug('get_group_asset_info: '
61: || 'book: ' || p_book_type_code);
62: fa_rx_util_pkg.debug('get_group_asset_info: '
63: || 'fiscal year from: ' || p_start_fiscal_year);
64: fa_rx_util_pkg.debug('get_group_asset_info: '
65: || 'fiscal year to: ' || p_end_fiscal_year);
66: fa_rx_util_pkg.debug('get_group_asset_info: '

Line 64: fa_rx_util_pkg.debug('get_group_asset_info: '

60: fa_rx_util_pkg.debug('get_group_asset_info: '
61: || 'book: ' || p_book_type_code);
62: fa_rx_util_pkg.debug('get_group_asset_info: '
63: || 'fiscal year from: ' || p_start_fiscal_year);
64: fa_rx_util_pkg.debug('get_group_asset_info: '
65: || 'fiscal year to: ' || p_end_fiscal_year);
66: fa_rx_util_pkg.debug('get_group_asset_info: '
67: || 'user_id: ' || p_user_id);
68: fa_rx_util_pkg.debug('get_group_asset_info: '

Line 66: fa_rx_util_pkg.debug('get_group_asset_info: '

62: fa_rx_util_pkg.debug('get_group_asset_info: '
63: || 'fiscal year from: ' || p_start_fiscal_year);
64: fa_rx_util_pkg.debug('get_group_asset_info: '
65: || 'fiscal year to: ' || p_end_fiscal_year);
66: fa_rx_util_pkg.debug('get_group_asset_info: '
67: || 'user_id: ' || p_user_id);
68: fa_rx_util_pkg.debug('get_group_asset_info: '
69: || 'request_id: ' || p_request_id);
70: END IF;

Line 68: fa_rx_util_pkg.debug('get_group_asset_info: '

64: fa_rx_util_pkg.debug('get_group_asset_info: '
65: || 'fiscal year to: ' || p_end_fiscal_year);
66: fa_rx_util_pkg.debug('get_group_asset_info: '
67: || 'user_id: ' || p_user_id);
68: fa_rx_util_pkg.debug('get_group_asset_info: '
69: || 'request_id: ' || p_request_id);
70: END IF;
71: l_message := 'get_group_asset_info start';
72:

Line 103: fa_rx_util_pkg.debug('get_group_asset_info: '

99: AND sob.set_of_books_id = bc.set_of_books_id
100: AND sob.currency_code = cur.currency_code;
101:
102: IF g_print_debug THEN
103: fa_rx_util_pkg.debug('get_group_asset_info: '
104: || 'set_of_books_id: ' || l_info_rec.set_of_books_id);
105: fa_rx_util_pkg.debug('get_group_asset_info: '
106: || 'deprn_calendar: ' || l_info_rec.deprn_calendar);
107: END IF;

Line 105: fa_rx_util_pkg.debug('get_group_asset_info: '

101:
102: IF g_print_debug THEN
103: fa_rx_util_pkg.debug('get_group_asset_info: '
104: || 'set_of_books_id: ' || l_info_rec.set_of_books_id);
105: fa_rx_util_pkg.debug('get_group_asset_info: '
106: || 'deprn_calendar: ' || l_info_rec.deprn_calendar);
107: END IF;
108: l_message := 'initialization end';
109:

Line 161: fa_rx_util_pkg.debug('get_group_asset_info: '

157: || p_asset_number_high || '''';
158: END IF;
159:
160: IF g_print_debug THEN
161: fa_rx_util_pkg.debug('get_group_asset_info: '
162: || 'l_param_where_stmt:' || l_param_where_stmt);
163: END IF;
164: l_message := 'category sql end';
165:

Line 257: fa_rx_util_pkg.debug('get_group_asset_info: '

253: get_where_sql_stmt(l_info_rec, NULL, l_sql_stmt);
254: l_group_sql_stmt := l_group_sql_stmt || l_sql_stmt || l_param_where_stmt;
255:
256: IF g_print_debug THEN
257: fa_rx_util_pkg.debug('get_group_asset_info: '
258: || 'l_group_sql_stmt:' || l_group_sql_stmt);
259: END IF;
260: l_message := 'fiscal year loop (2)';
261:

Line 273: fa_rx_util_pkg.debug('get_group_asset_info: '

269:
270: l_message := 'group loop (1)';
271:
272: IF g_print_debug THEN
273: fa_rx_util_pkg.debug('get_group_asset_info: '
274: || 'group_asset: ' || l_group_rec.asset_number);
275: END IF;
276:
277: ----------------------------------------------------------

Line 533: fa_rx_util_pkg.debug('l_all_reduced_deprn_amount: '

529: raise main_err;
530: END IF;
531:
532: IF g_print_debug THEN
533: fa_rx_util_pkg.debug('l_all_reduced_deprn_amount: '
534: || l_all_reduced_deprn_amount);
535: fa_rx_util_pkg.debug('annual_deprn_amount: '
536: || l_group_rec.annual_deprn_amount);
537: END IF;

Line 535: fa_rx_util_pkg.debug('annual_deprn_amount: '

531:
532: IF g_print_debug THEN
533: fa_rx_util_pkg.debug('l_all_reduced_deprn_amount: '
534: || l_all_reduced_deprn_amount);
535: fa_rx_util_pkg.debug('annual_deprn_amount: '
536: || l_group_rec.annual_deprn_amount);
537: END IF;
538:
539: IF l_group_rec.annual_deprn_amount = l_all_reduced_deprn_amount THEN

Line 603: fa_rx_util_pkg.debug('get_group_asset_info: '

599: l_info_rec.fiscal_year := l_info_rec.fiscal_year + 1;
600: END LOOP; -- fiscal year loop
601:
602: IF g_print_debug THEN
603: fa_rx_util_pkg.debug('get_group_asset_info: '
604: || 'farx_ga.get_group_asset_info()-');
605: END IF;
606:
607: EXCEPTION

Line 610: fa_rx_util_pkg.log(sqlcode);

606:
607: EXCEPTION
608: WHEN OTHERS THEN
609: IF g_print_debug THEN
610: fa_rx_util_pkg.log(sqlcode);
611: fa_rx_util_pkg.log(sqlerrm);
612: fa_rx_util_pkg.log(l_message);
613: END IF;
614:

Line 611: fa_rx_util_pkg.log(sqlerrm);

607: EXCEPTION
608: WHEN OTHERS THEN
609: IF g_print_debug THEN
610: fa_rx_util_pkg.log(sqlcode);
611: fa_rx_util_pkg.log(sqlerrm);
612: fa_rx_util_pkg.log(l_message);
613: END IF;
614:
615: IF sqlcode <> 0 THEN

Line 612: fa_rx_util_pkg.log(l_message);

608: WHEN OTHERS THEN
609: IF g_print_debug THEN
610: fa_rx_util_pkg.log(sqlcode);
611: fa_rx_util_pkg.log(sqlerrm);
612: fa_rx_util_pkg.log(l_message);
613: END IF;
614:
615: IF sqlcode <> 0 THEN
616: fa_rx_conc_mesg_pkg.log(sqlerrm);

Line 628: fa_rx_util_pkg.debug('get_group_asset_info: '

624: END IF;
625:
626: x_retcode := 2;
627: IF g_print_debug THEN
628: fa_rx_util_pkg.debug('get_group_asset_info: '
629: || 'farx_ga.get_group_asset_info(EXCEPTION)-');
630: END IF;
631:
632: END get_group_asset_info;

Line 653: fa_rx_util_pkg.debug('get_category_sql: '

649: x_where_stmt OUT NOCOPY VARCHAR2)
650: IS
651: BEGIN
652: IF g_print_debug THEN
653: fa_rx_util_pkg.debug('get_category_sql: '
654: || 'p_application_id: ' || p_application_id);
655: fa_rx_util_pkg.debug('get_category_sql: ' || 'p_category_flex_structure: '
656: || p_category_flex_structure);
657: fa_rx_util_pkg.debug('get_category_sql: '

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

651: BEGIN
652: IF g_print_debug THEN
653: fa_rx_util_pkg.debug('get_category_sql: '
654: || 'p_application_id: ' || p_application_id);
655: fa_rx_util_pkg.debug('get_category_sql: ' || 'p_category_flex_structure: '
656: || p_category_flex_structure);
657: fa_rx_util_pkg.debug('get_category_sql: '
658: || 'p_qualifier: ' || p_qualifier);
659: fa_rx_util_pkg.debug('get_category_sql: '

Line 657: fa_rx_util_pkg.debug('get_category_sql: '

653: fa_rx_util_pkg.debug('get_category_sql: '
654: || 'p_application_id: ' || p_application_id);
655: fa_rx_util_pkg.debug('get_category_sql: ' || 'p_category_flex_structure: '
656: || p_category_flex_structure);
657: fa_rx_util_pkg.debug('get_category_sql: '
658: || 'p_qualifier: ' || p_qualifier);
659: fa_rx_util_pkg.debug('get_category_sql: '
660: || 'p_category_low: ' || p_category_low);
661: fa_rx_util_pkg.debug('get_category_sql: '

Line 659: fa_rx_util_pkg.debug('get_category_sql: '

655: fa_rx_util_pkg.debug('get_category_sql: ' || 'p_category_flex_structure: '
656: || p_category_flex_structure);
657: fa_rx_util_pkg.debug('get_category_sql: '
658: || 'p_qualifier: ' || p_qualifier);
659: fa_rx_util_pkg.debug('get_category_sql: '
660: || 'p_category_low: ' || p_category_low);
661: fa_rx_util_pkg.debug('get_category_sql: '
662: || 'p_category_high: ' || p_category_high);
663: END IF;

Line 661: fa_rx_util_pkg.debug('get_category_sql: '

657: fa_rx_util_pkg.debug('get_category_sql: '
658: || 'p_qualifier: ' || p_qualifier);
659: fa_rx_util_pkg.debug('get_category_sql: '
660: || 'p_category_low: ' || p_category_low);
661: fa_rx_util_pkg.debug('get_category_sql: '
662: || 'p_category_high: ' || p_category_high);
663: END IF;
664:
665:

Line 736: fa_rx_util_pkg.debug('get_category_sql: '

732:
733: EXCEPTION
734: WHEN OTHERS THEN
735: IF g_print_debug THEN
736: fa_rx_util_pkg.debug('get_category_sql: '
737: || 'farx_ga.get_category_sql(EXCEPTION)-');
738: END IF;
739: raise;
740: END get_category_sql;

Line 809: fa_rx_util_pkg.debug('get_from_sql_stmt: '

805:
806: EXCEPTION
807: WHEN OTHERS THEN
808: IF g_print_debug THEN
809: fa_rx_util_pkg.debug('get_from_sql_stmt: '
810: || 'farx_ga.get_from_sql_stmt(EXCEPTION)-');
811: END IF;
812: raise;
813: END get_from_sql_stmt;

Line 882: fa_rx_util_pkg.debug('get_where_sql_stmt: '

878:
879: EXCEPTION
880: WHEN OTHERS THEN
881: IF g_print_debug THEN
882: fa_rx_util_pkg.debug('get_where_sql_stmt: '
883: || 'farx_ga.get_where_sql_stmt(EXCEPTION)-');
884: END IF;
885: raise;
886: END get_where_sql_stmt;

Line 1014: fa_rx_util_pkg.debug('get_trx_amount_sql: '

1010:
1011: EXCEPTION
1012: WHEN OTHERS THEN
1013: IF g_print_debug THEN
1014: fa_rx_util_pkg.debug('get_trx_amount_sql: '
1015: || 'farx_ga.get_trx_amount_sql(EXCEPTION)-');
1016: END IF;
1017: raise;
1018: END get_trx_amount_sql;

Line 1063: fa_rx_util_pkg.debug('get_retirement_sql: '

1059:
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062: IF g_print_debug THEN
1063: fa_rx_util_pkg.debug('get_retirement_sql: '
1064: || 'farx_ga.get_retirement_sql(EXCEPTION)-');
1065: END IF;
1066: raise;
1067: END get_retirement_sql;

Line 1193: fa_rx_util_pkg.debug('insert_data: '

1189:
1190: EXCEPTION
1191: WHEN OTHERS THEN
1192: IF g_print_debug THEN
1193: fa_rx_util_pkg.debug('insert_data: '
1194: || 'farx_ga.insert_data(EXCEPTION)-');
1195: END IF;
1196: raise;
1197: END insert_data;

Line 1519: fa_rx_util_pkg.log(sqlcode);

1515:
1516: EXCEPTION
1517: WHEN OTHERS THEN
1518: IF g_print_debug THEN
1519: fa_rx_util_pkg.log(sqlcode);
1520: fa_rx_util_pkg.log(sqlerrm);
1521: fa_rx_util_pkg.log(l_message);
1522: fa_rx_util_pkg.debug('query_member_assets: '
1523: || 'farx_ga.query_member_assets(EXCEPTION)-');

Line 1520: fa_rx_util_pkg.log(sqlerrm);

1516: EXCEPTION
1517: WHEN OTHERS THEN
1518: IF g_print_debug THEN
1519: fa_rx_util_pkg.log(sqlcode);
1520: fa_rx_util_pkg.log(sqlerrm);
1521: fa_rx_util_pkg.log(l_message);
1522: fa_rx_util_pkg.debug('query_member_assets: '
1523: || 'farx_ga.query_member_assets(EXCEPTION)-');
1524: END IF;

Line 1521: fa_rx_util_pkg.log(l_message);

1517: WHEN OTHERS THEN
1518: IF g_print_debug THEN
1519: fa_rx_util_pkg.log(sqlcode);
1520: fa_rx_util_pkg.log(sqlerrm);
1521: fa_rx_util_pkg.log(l_message);
1522: fa_rx_util_pkg.debug('query_member_assets: '
1523: || 'farx_ga.query_member_assets(EXCEPTION)-');
1524: END IF;
1525:

Line 1522: fa_rx_util_pkg.debug('query_member_assets: '

1518: IF g_print_debug THEN
1519: fa_rx_util_pkg.log(sqlcode);
1520: fa_rx_util_pkg.log(sqlerrm);
1521: fa_rx_util_pkg.log(l_message);
1522: fa_rx_util_pkg.debug('query_member_assets: '
1523: || 'farx_ga.query_member_assets(EXCEPTION)-');
1524: END IF;
1525:
1526: IF sqlcode <> 0 THEN