DBA Data[Home] [Help]

APPS.FARX_RT dependencies on FA_RX_UTIL_PKG

Line 115: fa_rx_util_pkg.debug('farx_rt.ret()+');

111: ret_lines var_cur;
112:
113: begin
114: IF (g_print_debug) THEN
115: fa_rx_util_pkg.debug('farx_rt.ret()+');
116: END IF;
117:
118: h_book := book;
119: h_request_id := request_id;

Line 129: fa_rx_util_pkg.debug('ret: ' || '********login_id:' || h_login_id);

125: from fnd_concurrent_requests fcr
126: where fcr.request_id = h_request_id;
127:
128: IF (g_print_debug) THEN
129: fa_rx_util_pkg.debug('ret: ' || '********login_id:' || h_login_id);
130: fa_rx_util_pkg.debug('ret: ' || '********login_id:' || h_login_id);
131: END IF;
132:
133: h_mesg_name := 'FA_FA_LOOKUP_IN_SYSTEM_CTLS';

Line 130: fa_rx_util_pkg.debug('ret: ' || '********login_id:' || h_login_id);

126: where fcr.request_id = h_request_id;
127:
128: IF (g_print_debug) THEN
129: fa_rx_util_pkg.debug('ret: ' || '********login_id:' || h_login_id);
130: fa_rx_util_pkg.debug('ret: ' || '********login_id:' || h_login_id);
131: END IF;
132:
133: h_mesg_name := 'FA_FA_LOOKUP_IN_SYSTEM_CTLS';
134:

Line 174: fa_rx_util_pkg.debug('ret: ' || 'h_period2:' || h_period2);

170: end if;
171: */
172:
173: IF (g_print_debug) THEN
174: fa_rx_util_pkg.debug('ret: ' || 'h_period2:' || h_period2);
175: END IF;
176:
177: h_mesg_name := 'FA_REC_SQL_ACCT_FLEX';
178:

Line 220: fa_rx_util_pkg.debug('ret: ' || 'chart of account ID:' || h_chart_of_accounts_id);

216:
217:
218:
219: IF (g_print_debug) THEN
220: fa_rx_util_pkg.debug('ret: ' || 'chart of account ID:' || h_chart_of_accounts_id);
221: END IF;
222:
223: --
224: -- Get Columns for Major_category, Minor_category and Specified_category

Line 366: fa_rx_util_pkg.debug('ret: ' || 'l_param_where:' || l_param_where);

362: l_param_where := l_param_where || ' AND (AD.ASSET_NUMBER >= :from_asset_num OR :from_asset_num is NULL)';
363: l_param_where := l_param_where || ' AND (AD.ASSET_NUMBER <= :to_asset_num OR :to_asset_num is NULL)';
364:
365: IF (g_print_debug) THEN
366: fa_rx_util_pkg.debug('ret: ' || 'l_param_where:' || l_param_where);
367: END IF;
368:
369:
370: where_clause := 'th.date_effective between :h_period1_pod AND nvl(:h_period2_pcd,sysdate) AND

Line 422: fa_rx_util_pkg.debug('ret: ' || 'where_clause:' || where_clause);

418:
419: h_mesg_name := 'FA_RETIREMENTS_SQL_DCUR';
420:
421: IF (g_print_debug) THEN
422: fa_rx_util_pkg.debug('ret: ' || 'where_clause:' || where_clause);
423: fa_rx_util_pkg.debug('ret: ' || 'from_clause:' || from_clause);
424: END IF;
425:
426: select_statement := '

Line 423: fa_rx_util_pkg.debug('ret: ' || 'from_clause:' || from_clause);

419: h_mesg_name := 'FA_RETIREMENTS_SQL_DCUR';
420:
421: IF (g_print_debug) THEN
422: fa_rx_util_pkg.debug('ret: ' || 'where_clause:' || where_clause);
423: fa_rx_util_pkg.debug('ret: ' || 'from_clause:' || from_clause);
424: END IF;
425:
426: select_statement := '
427: SELECT /*+ leading(th ad) use_nl(ad) index(FA_ADDITIONS_B_U1 )*/ --Bug# 7587861

Line 495: fa_rx_util_pkg.debug('ret: ' || 'select_statement:' || select_statement);

491: FROM ' || from_clause || '
492: WHERE ' || where_clause;
493:
494: IF (g_print_debug) THEN
495: fa_rx_util_pkg.debug('ret: ' || 'select_statement:' || select_statement);
496: END IF;
497:
498: /* BUG# 2939771
499: open ret_lines for select_statement ;

Line 538: fa_rx_util_pkg.debug('ret: ' || 'after_open');

534: to_asset_num;
535:
536:
537: IF (g_print_debug) THEN
538: fa_rx_util_pkg.debug('ret: ' || 'after_open');
539: END IF;
540:
541: loop
542:

Line 579: fa_rx_util_pkg.debug('ret_lines:');

575:
576: if (ret_lines%NOTFOUND) then exit; end if;
577:
578: IF (g_print_debug) THEN
579: fa_rx_util_pkg.debug('ret_lines:');
580: END IF;
581:
582: h_mesg_name := 'FA_RX_CONCAT_SEGS';
583: h_flex_error := 'GL#';

Line 628: fa_rx_util_pkg.debug('ret: ' || '** assetkey_flex_struct:' || h_assetkey_flex_structure);

624: p_data => h_acct_segs(h_cc_seg));
625:
626:
627: IF (g_print_debug) THEN
628: fa_rx_util_pkg.debug('ret: ' || '** assetkey_flex_struct:' || h_assetkey_flex_structure);
629: fa_rx_util_pkg.debug('ret: ' || '** category_id:' || h_category_id);
630: fa_rx_util_pkg.debug('ret: ' || '** specified_cat:' || h_cat_seg_num);
631: END IF;
632:

Line 629: fa_rx_util_pkg.debug('ret: ' || '** category_id:' || h_category_id);

625:
626:
627: IF (g_print_debug) THEN
628: fa_rx_util_pkg.debug('ret: ' || '** assetkey_flex_struct:' || h_assetkey_flex_structure);
629: fa_rx_util_pkg.debug('ret: ' || '** category_id:' || h_category_id);
630: fa_rx_util_pkg.debug('ret: ' || '** specified_cat:' || h_cat_seg_num);
631: END IF;
632:
633: /*

Line 630: fa_rx_util_pkg.debug('ret: ' || '** specified_cat:' || h_cat_seg_num);

626:
627: IF (g_print_debug) THEN
628: fa_rx_util_pkg.debug('ret: ' || '** assetkey_flex_struct:' || h_assetkey_flex_structure);
629: fa_rx_util_pkg.debug('ret: ' || '** category_id:' || h_category_id);
630: fa_rx_util_pkg.debug('ret: ' || '** specified_cat:' || h_cat_seg_num);
631: END IF;
632:
633: /*
634: h_maj_cat :=

Line 746: fa_rx_util_pkg.debug('ret: ' || 'During loop');

742:
743:
744:
745: IF (g_print_debug) THEN
746: fa_rx_util_pkg.debug('ret: ' || 'During loop');
747: END IF;
748:
749: end loop;
750: