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 171: fa_rx_util_pkg.debug('ret: ' || 'h_period2:' || h_period2);

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

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

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

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

359: l_param_where := l_param_where || ' AND (AD.ASSET_NUMBER >= :from_asset_num OR :from_asset_num is NULL)';
360: l_param_where := l_param_where || ' AND (AD.ASSET_NUMBER <= :to_asset_num OR :to_asset_num is NULL)';
361:
362: IF (g_print_debug) THEN
363: fa_rx_util_pkg.debug('ret: ' || 'l_param_where:' || l_param_where);
364: END IF;
365:
366:
367: where_clause := 'th.date_effective >= to_date(:h_period1_pod,''dd-mm-yyyy hh24:mi:ss'') AND

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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