APPS.FARX_C_WD dependencies on FARX_C_WD

Line 1: PACKAGE BODY FARX_C_WD as

1: PACKAGE BODY FARX_C_WD as
2: /* $Header: farxcwdb.pls 120.18 2011/09/30 17:59:35 gigupta ship $ */
3:
4: g_print_debug boolean := fa_cache_pkg.fa_print_debug;
5:

Line 183: l_calling_fn varchar2(40) := 'FARX_C_WD.WHATIF';

179: l_count number := 0;
180: l_start_range number := 0;
181: l_end_range number := 0;
182:
183: l_calling_fn varchar2(40) := 'FARX_C_WD.WHATIF';
184:
185: done_exc exception;
186: error_found exception;
187:

Line 240: FARX_C_WD.sob_id := to_number(argument20);

236: h_value_error := argument20;
237: h_param_error := 'SET OF BOOKS ID';
238:
239: -- Enhancement Bug 3037321
240: FARX_C_WD.sob_id := to_number(argument20);
241: select mrc_sob_type_code,currency_code
242: into FARX_C_WD.mrc_sob_type,FARX_C_WD.currency
243: from gl_sets_of_books
244: where set_of_books_id = to_number(argument20);

Line 242: into FARX_C_WD.mrc_sob_type,FARX_C_WD.currency

238:
239: -- Enhancement Bug 3037321
240: FARX_C_WD.sob_id := to_number(argument20);
241: select mrc_sob_type_code,currency_code
242: into FARX_C_WD.mrc_sob_type,FARX_C_WD.currency
243: from gl_sets_of_books
244: where set_of_books_id = to_number(argument20);
245:
246: -- Enhancement Bug 3037321

Line 247: if(FARX_C_WD.mrc_sob_type = 'R') then

243: from gl_sets_of_books
244: where set_of_books_id = to_number(argument20);
245:
246: -- Enhancement Bug 3037321
247: if(FARX_C_WD.mrc_sob_type = 'R') then
248: fnd_client_info.set_currency_context(FARX_C_WD.sob_id);
249: end if;
250:
251: -- PERIOD NAME

Line 248: fnd_client_info.set_currency_context(FARX_C_WD.sob_id);

244: where set_of_books_id = to_number(argument20);
245:
246: -- Enhancement Bug 3037321
247: if(FARX_C_WD.mrc_sob_type = 'R') then
248: fnd_client_info.set_currency_context(FARX_C_WD.sob_id);
249: end if;
250:
251: -- PERIOD NAME
252: h_mesg_name := 'FA_WHATIF_PARAM_ERROR';

Line 1113: fa_srvr_msg.add_message(calling_fn => 'FARX_C_WD.WHATIF');

1109:
1110: commit;
1111:
1112: x_failure_count := x_failure_count + 1;
1113: fa_srvr_msg.add_message(calling_fn => 'FARX_C_WD.WHATIF');
1114: if (g_print_debug) then
1115: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1116: end if;
1117: x_return_status := 2;

Line 1131: fa_srvr_msg.add_sql_error(calling_fn => 'FARX_C_WD.WHATIF');

1127:
1128: commit;
1129:
1130: x_failure_count := x_failure_count + 1;
1131: fa_srvr_msg.add_sql_error(calling_fn => 'FARX_C_WD.WHATIF');
1132: if (g_print_debug) then
1133: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1134: end if;
1135: x_return_status := 2;

Line 1165: l_calling_fn varchar2(60) := 'FARX_C_WD.Load_Workers';

1161: x_return_status OUT NOCOPY number
1162: ) is
1163:
1164: l_batch_size number;
1165: l_calling_fn varchar2(60) := 'FARX_C_WD.Load_Workers';
1166:
1167: error_found exception;
1168:
1169: BEGIN

Line 1202: fa_srvr_msg.add_sql_error(calling_fn => 'FARX_C_WD.WHATIF');

1198: x_return_status := 0;
1199:
1200: EXCEPTION
1201: when OTHERS then
1202: fa_srvr_msg.add_sql_error(calling_fn => 'FARX_C_WD.WHATIF');
1203: rollback;
1204: if (g_print_debug) then
1205: fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
1206: end if;

Line 1211: END FARX_C_WD;

1207: x_return_status := 2;
1208:
1209: END Load_Workers;
1210:
1211: END FARX_C_WD;