DBA Data[Home] [Help]

APPS.FARX_AD dependencies on FA_RX_UTIL_PKG

Line 134: fa_rx_util_pkg.debug('farx_ad.add_by_period()+');

130: h_group_asset_number varchar2(15);
131:
132: begin
133: IF (g_print_debug) THEN
134: fa_rx_util_pkg.debug('farx_ad.add_by_period()+');
135: END IF;
136:
137: h_book := book;
138: h_period_name := begin_period;

Line 149: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '********login_id:' || h_login_id);

145: from fnd_concurrent_requests fcr
146: where fcr.request_id = h_request_id;
147:
148: IF (g_print_debug) THEN
149: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '********login_id:' || h_login_id);
150: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '********login_id:' || h_login_id);
151: END IF;
152:
153: h_mesg_name := 'FA_AMT_SEL_PERIODS';

Line 150: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '********login_id:' || h_login_id);

146: where fcr.request_id = h_request_id;
147:
148: IF (g_print_debug) THEN
149: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '********login_id:' || h_login_id);
150: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '********login_id:' || h_login_id);
151: END IF;
152:
153: h_mesg_name := 'FA_AMT_SEL_PERIODS';
154:

Line 174: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'begin_period,h_period1_pc:' || begin_period || ',' || h_period1_pc);

170: h_period2_pc := null;
171: end if;
172:
173: IF (g_print_debug) THEN
174: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'begin_period,h_period1_pc:' || begin_period || ',' || h_period1_pc);
175: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'end_period,h_period2_pc:' || end_period || ',' || h_period2_pc);
176: END IF;
177:
178: h_mesg_name := 'FA_REC_SQL_ACCT_FLEX';

Line 175: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'end_period,h_period2_pc:' || end_period || ',' || h_period2_pc);

171: end if;
172:
173: IF (g_print_debug) THEN
174: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'begin_period,h_period1_pc:' || begin_period || ',' || h_period1_pc);
175: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'end_period,h_period2_pc:' || end_period || ',' || h_period2_pc);
176: END IF;
177:
178: h_mesg_name := 'FA_REC_SQL_ACCT_FLEX';
179:

Line 215: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'chart of account ID:' || h_chart_of_accounts_id);

211: AND sob.currency_code = cur.currency_code; -- Added set_of_books_id and currency_code to display those on report
212:
213:
214: IF (g_print_debug) THEN
215: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'chart of account ID:' || h_chart_of_accounts_id);
216: END IF;
217:
218: --
219: -- Get Columns for Major_category, Minor_category and Specified_category

Line 418: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'l_param_where:' || l_param_where);

414: l_param_where := l_param_where || ' AND (AD.ASSET_NUMBER >= :from_asset_num OR :from_asset_num is NULL)';
415: l_param_where := l_param_where || ' AND (AD.ASSET_NUMBER <= :to_asset_num OR :to_asset_num is NULL)';
416:
417: IF (g_print_debug) THEN
418: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'l_param_where:' || l_param_where);
419: END IF;
420:
421: where_clause1 := 'DS.BOOK_TYPE_CODE (+) = :h_book AND
422: DS.ASSET_ID (+) = DD.ASSET_ID AND

Line 625: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause1:' || where_clause1);

621:
622: h_mesg_name := 'FA_ADDITION_SQL_DCUR';
623:
624: IF (g_print_debug) THEN
625: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause1:' || where_clause1);
626: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause2:' || where_clause2);
627: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause3:' || where_clause3);
628: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause4:' || where_clause4);
629: END IF;

Line 626: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause2:' || where_clause2);

622: h_mesg_name := 'FA_ADDITION_SQL_DCUR';
623:
624: IF (g_print_debug) THEN
625: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause1:' || where_clause1);
626: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause2:' || where_clause2);
627: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause3:' || where_clause3);
628: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause4:' || where_clause4);
629: END IF;
630:

Line 627: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause3:' || where_clause3);

623:
624: IF (g_print_debug) THEN
625: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause1:' || where_clause1);
626: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause2:' || where_clause2);
627: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause3:' || where_clause3);
628: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause4:' || where_clause4);
629: END IF;
630:
631: -- open additions for

Line 628: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause4:' || where_clause4);

624: IF (g_print_debug) THEN
625: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause1:' || where_clause1);
626: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause2:' || where_clause2);
627: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause3:' || where_clause3);
628: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'where_clause4:' || where_clause4);
629: END IF;
630:
631: -- open additions for
632:

Line 852: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'select_statement:='|| select_statement);

848: FA_ADDITIONS_B GAD
849: WHERE ' || where_clause4 ;
850:
851: IF (g_print_debug) THEN
852: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'select_statement:='|| select_statement);
853: END IF;
854:
855: /* BUG# 2939771
856: open additions for select_statement;

Line 984: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'Before Loop');

980: to_asset_num;
981:
982:
983: IF (g_print_debug) THEN
984: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'Before Loop');
985: END IF;
986:
987: loop
988:

Line 1116: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '** assetkey_flex_struct:' || h_assetkey_flex_structure);

1112: p_data => h_acct_segs(h_cost_seg));
1113:
1114:
1115: IF (g_print_debug) THEN
1116: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '** assetkey_flex_struct:' || h_assetkey_flex_structure);
1117: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '** category_id:' || h_category_id);
1118: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '** specified_cat:' || h_cat_seg_num);
1119: END IF;
1120:

Line 1117: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '** category_id:' || h_category_id);

1113:
1114:
1115: IF (g_print_debug) THEN
1116: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '** assetkey_flex_struct:' || h_assetkey_flex_structure);
1117: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '** category_id:' || h_category_id);
1118: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '** specified_cat:' || h_cat_seg_num);
1119: END IF;
1120:
1121: /*

Line 1118: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '** specified_cat:' || h_cat_seg_num);

1114:
1115: IF (g_print_debug) THEN
1116: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '** assetkey_flex_struct:' || h_assetkey_flex_structure);
1117: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '** category_id:' || h_category_id);
1118: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || '** specified_cat:' || h_cat_seg_num);
1119: END IF;
1120:
1121: /*
1122: h_maj_cat :=

Line 1240: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'loop counter:' || ctr);

1236:
1237: close additions;
1238:
1239: IF (g_print_debug) THEN
1240: fa_rx_util_pkg.debug('ADD_BY_PERIOD: ' || 'loop counter:' || ctr);
1241: END IF;
1242:
1243: exception when others then
1244: fa_Rx_conc_mesg_pkg.log('Error occurred');