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.CE_CASH_FCST dependencies on STANDARD

Line 142: cep_standard.debug('>>CE_CASH_FCST.set_parameters');

138: ELSE
139: x_exchange_type := p_exchange_type;
140: END IF;
141:
142: cep_standard.debug('>>CE_CASH_FCST.set_parameters');
143: G_rp_forecast_header_id := p_forecast_header_id;
144: G_rp_forecast_runname := p_forecast_runname;
145: G_rp_forecast_start_date := to_date(p_forecast_start_date,'YYYY/MM/DD HH24:MI:SS');
146: G_rp_calendar_name := p_calendar_name ;

Line 179: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);

175: ELSE
176: G_parent_process := FALSE;
177: END IF;
178:
179: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
180: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
181: cep_standard.debug('CE_CASH_FCST.G_rp_calendar_name : '||G_rp_calendar_name);
182: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
183: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);

Line 180: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);

176: G_parent_process := FALSE;
177: END IF;
178:
179: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
180: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
181: cep_standard.debug('CE_CASH_FCST.G_rp_calendar_name : '||G_rp_calendar_name);
182: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
183: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
184: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);

Line 181: cep_standard.debug('CE_CASH_FCST.G_rp_calendar_name : '||G_rp_calendar_name);

177: END IF;
178:
179: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
180: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
181: cep_standard.debug('CE_CASH_FCST.G_rp_calendar_name : '||G_rp_calendar_name);
182: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
183: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
184: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
185: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);

Line 182: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);

178:
179: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
180: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
181: cep_standard.debug('CE_CASH_FCST.G_rp_calendar_name : '||G_rp_calendar_name);
182: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
183: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
184: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
185: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
186: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);

Line 183: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);

179: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
180: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
181: cep_standard.debug('CE_CASH_FCST.G_rp_calendar_name : '||G_rp_calendar_name);
182: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
183: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
184: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
185: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
186: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
187: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);

Line 184: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);

180: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
181: cep_standard.debug('CE_CASH_FCST.G_rp_calendar_name : '||G_rp_calendar_name);
182: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
183: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
184: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
185: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
186: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
187: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
188: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);

Line 185: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);

181: cep_standard.debug('CE_CASH_FCST.G_rp_calendar_name : '||G_rp_calendar_name);
182: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
183: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
184: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
185: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
186: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
187: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
188: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
189: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);

Line 186: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);

182: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
183: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
184: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
185: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
186: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
187: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
188: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
189: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
190: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);

Line 187: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);

183: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
184: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
185: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
186: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
187: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
188: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
189: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
190: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
191: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);

Line 188: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);

184: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
185: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
186: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
187: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
188: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
189: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
190: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
191: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
192: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);

Line 189: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);

185: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
186: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
187: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
188: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
189: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
190: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
191: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
192: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
193: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);

Line 190: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);

186: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
187: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
188: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
189: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
190: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
191: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
192: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
193: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);
194: cep_standard.debug('CE_CASH_FCST.G_display_debug : '||G_display_debug);

Line 191: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);

187: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
188: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
189: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
190: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
191: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
192: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
193: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);
194: cep_standard.debug('CE_CASH_FCST.G_display_debug : '||G_display_debug);
195: cep_standard.debug('CE_CASH_FCST.G_debug_path : '||G_debug_path);

Line 192: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);

188: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
189: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
190: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
191: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
192: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
193: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);
194: cep_standard.debug('CE_CASH_FCST.G_display_debug : '||G_display_debug);
195: cep_standard.debug('CE_CASH_FCST.G_debug_path : '||G_debug_path);
196: cep_standard.debug('CE_CASH_FCST.G_debug_file : '||G_debug_file);

Line 193: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);

189: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
190: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
191: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
192: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
193: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);
194: cep_standard.debug('CE_CASH_FCST.G_display_debug : '||G_display_debug);
195: cep_standard.debug('CE_CASH_FCST.G_debug_path : '||G_debug_path);
196: cep_standard.debug('CE_CASH_FCST.G_debug_file : '||G_debug_file);
197:

Line 194: cep_standard.debug('CE_CASH_FCST.G_display_debug : '||G_display_debug);

190: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
191: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
192: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
193: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);
194: cep_standard.debug('CE_CASH_FCST.G_display_debug : '||G_display_debug);
195: cep_standard.debug('CE_CASH_FCST.G_debug_path : '||G_debug_path);
196: cep_standard.debug('CE_CASH_FCST.G_debug_file : '||G_debug_file);
197:
198: --

Line 195: cep_standard.debug('CE_CASH_FCST.G_debug_path : '||G_debug_path);

191: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
192: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
193: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);
194: cep_standard.debug('CE_CASH_FCST.G_display_debug : '||G_display_debug);
195: cep_standard.debug('CE_CASH_FCST.G_debug_path : '||G_debug_path);
196: cep_standard.debug('CE_CASH_FCST.G_debug_file : '||G_debug_file);
197:
198: --
199: -- Set View constants

Line 196: cep_standard.debug('CE_CASH_FCST.G_debug_file : '||G_debug_file);

192: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
193: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);
194: cep_standard.debug('CE_CASH_FCST.G_display_debug : '||G_display_debug);
195: cep_standard.debug('CE_CASH_FCST.G_debug_path : '||G_debug_path);
196: cep_standard.debug('CE_CASH_FCST.G_debug_file : '||G_debug_file);
197:
198: --
199: -- Set View constants
200: --

Line 244: cep_standard.debug('Request Id is ' || request_id);

240: request_id := to_number(reqid);
241: --
242: -- Get print options
243: --
244: cep_standard.debug('Request Id is ' || request_id);
245: IF( NOT FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS(request_id,
246: number_of_copies,
247: print_style,
248: printer,

Line 250: cep_standard.debug('Message: get print options failed');

246: number_of_copies,
247: print_style,
248: printer,
249: save_output_flag))THEN
250: cep_standard.debug('Message: get print options failed');
251: ELSE
252: IF (save_output_flag = 'Y') THEN
253: save_output_bool := TRUE;
254: ELSE

Line 263: cep_standard.debug('Message: get print options failed');

259: 'CEFCERR',
260: printer,
261: print_style,
262: save_output_flag))THEN
263: cep_standard.debug('Message: get print options failed');
264: END IF;
265: --
266: -- Set print options
267: --

Line 272: cep_standard.debug('Set print options failed');

268: IF (NOT FND_REQUEST.set_print_options(printer,
269: print_style,
270: number_of_copies,
271: save_output_bool)) THEN
272: cep_standard.debug('Set print options failed');
273: END IF;
274: END IF;
275: req_id := FND_REQUEST.SUBMIT_REQUEST('CE',
276: 'CEFCERR',

Line 319: cep_standard.debug('Request Id is ' || request_id);

315: request_id := to_number(reqid);
316: --
317: -- Get print options
318: --
319: cep_standard.debug('Request Id is ' || request_id);
320: IF( NOT FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS(request_id,
321: number_of_copies,
322: print_style,
323: printer,

Line 325: cep_standard.debug('Message: get print options failed');

321: number_of_copies,
322: print_style,
323: printer,
324: save_output_flag))THEN
325: cep_standard.debug('Message: get print options failed');
326:
327: ELSE
328: IF (save_output_flag = 'Y') THEN
329: save_output_bool := TRUE;

Line 339: cep_standard.debug('Message: get print options failed');

335: 'CEFCAMTS',
336: printer,
337: print_style,
338: save_output_flag))THEN
339: cep_standard.debug('Message: get print options failed');
340: END IF;
341:
342: --
343: -- Set print options

Line 349: cep_standard.debug('Set print options failed');

345: IF (NOT FND_REQUEST.set_print_options(printer,
346: print_style,
347: number_of_copies,
348: save_output_bool)) THEN
349: cep_standard.debug('Set print options failed');
350: END IF;
351: END IF;
352:
353: SELECT forecast_header_id

Line 422: cep_standard.debug('>>CE_CASH_FCST.populate_base_xrate_table');

418: error_msg FND_NEW_MESSAGES.message_text%TYPE;
419: xrate NUMBER;
420: all_exist_flag BOOLEAN := TRUE;
421: BEGIN
422: cep_standard.debug('>>CE_CASH_FCST.populate_base_xrate_table');
423:
424: --
425: -- For each base currencies used by OE rows, determine it's xrate from
426: -- valid currencies to the base currency.

Line 446: cep_standard.debug(' Exchange info - '||curr||'->'||to_curr||' has rate '||to_char(xrate));

442: CE_CASH_FCST.G_rp_exchange_type);
443: insert into CE_CURRENCY_RATES_TEMP
444: (forecast_request_id, currency_code, exchange_rate, to_currency)
445: values (CE_CASH_FCST.G_forecast_id, curr, xrate, to_curr);
446: cep_standard.debug(' Exchange info - '||curr||'->'||to_curr||' has rate '||to_char(xrate));
447: EXCEPTION
448: WHEN OTHERS THEN
449: -- WHEN NO_RATE THEN
450: -- bug 1200912

Line 491: cep_standard.debug('<

487: END IF;
488: END LOOP;
489: CLOSE base_curr;
490:
491: cep_standard.debug('< 492: return (all_exist_flag);
493:
494: EXCEPTION
495: WHEN OTHERS THEN

Line 496: cep_standard.debug('EXCEPTION - OTHERS:populate_base_xrate_table');

492: return (all_exist_flag);
493:
494: EXCEPTION
495: WHEN OTHERS THEN
496: cep_standard.debug('EXCEPTION - OTHERS:populate_base_xrate_table');
497: IF from_curr%ISOPEN THEN CLOSE from_curr; END IF;
498: IF base_curr%ISOPEN THEN CLOSE base_curr; END IF;
499: IF bad_curr%ISOPEN THEN CLOSE bad_curr; END IF;
500: RAISE;

Line 555: cep_standard.debug('>>CE_CASH_FCST.populate_xrate_table');

551: from_curr_is_emu VARCHAR2(1);
552: l_currency_type VARCHAR2(5);
553:
554: BEGIN
555: cep_standard.debug('>>CE_CASH_FCST.populate_xrate_table');
556:
557: --
558: -- Insert constant rate (1) for forecast_currency to forecast_currency
559: --

Line 616: cep_standard.debug(' Exchange info - '||from_curr||' has rate '||to_char(xrate));

612: insert into CE_CURRENCY_RATES_TEMP (forecast_request_id,
613: currency_code, exchange_rate, to_currency)
614: values (CE_CASH_FCST.G_forecast_id, from_curr, xrate,
615: G_rp_forecast_currency);
616: cep_standard.debug(' Exchange info - '||from_curr||' has rate '||to_char(xrate));
617: EXCEPTION
618: WHEN OTHERS THEN
619: -- WHEN NO_RATE THEN
620: skip_err_log := FALSE;

Line 701: cep_standard.debug('<

697: CLOSE bad_curr;
698:
699: END IF;
700:
701: cep_standard.debug('< 702: return (all_exist_flag);
703:
704: EXCEPTION
705: WHEN OTHERS THEN

Line 706: cep_standard.debug('EXCEPTION - OTHERS:populate_xrate_table');

702: return (all_exist_flag);
703:
704: EXCEPTION
705: WHEN OTHERS THEN
706: cep_standard.debug('EXCEPTION - OTHERS:populate_xrate_table');
707: IF C%ISOPEN THEN CLOSE C; END IF;
708: IF bad_curr%ISOPEN THEN CLOSE bad_curr; END IF;
709: RAISE;
710: return (FALSE);

Line 730: cep_standard.debug('Delete all xrate information');

726: | 21-JUL-1997 Created Wynne Chan |
727: ---------------------------------------------------------------------*/
728: PROCEDURE clear_xrate_table IS
729: BEGIN
730: cep_standard.debug('Delete all xrate information');
731: delete from CE_CURRENCY_RATES_TEMP
732: where forecast_request_id = CE_CASH_FCST.G_forecast_id;
733: EXCEPTION
734: WHEN OTHERS THEN

Line 735: cep_standard.debug('EXCEPTION - OTHERS: clear_xrate_table');

731: delete from CE_CURRENCY_RATES_TEMP
732: where forecast_request_id = CE_CASH_FCST.G_forecast_id;
733: EXCEPTION
734: WHEN OTHERS THEN
735: cep_standard.debug('EXCEPTION - OTHERS: clear_xrate_table');
736: RAISE;
737: END clear_xrate_table;
738:
739:

Line 757: cep_standard.debug('>>validate_transaction_calendar');

753: ---------------------------------------------------------------------*/
754: PROCEDURE validate_transaction_calendar IS
755: BEGIN
756:
757: cep_standard.debug('>>validate_transaction_calendar');
758:
759: SELECT min(transaction_date), max(transaction_date)
760: INTO CE_CSH_FCST_POP.G_calendar_start, CE_CSH_FCST_POP.G_calendar_end
761: FROM gl_transaction_dates

Line 766: cep_standard.debug('Cannot find transaction calendar');

762: WHERE transaction_calendar_id = G_transaction_calendar_id;
763:
764: IF(CE_CSH_FCST_POP.G_calendar_start IS NULL OR
765: CE_CSH_FCST_POP.G_calendar_end IS NULL)THEN
766: cep_standard.debug('Cannot find transaction calendar');
767: G_transaction_calendar_id := NULL;
768: END IF;
769:
770: cep_standard.debug('<

Line 770: cep_standard.debug('<

766: cep_standard.debug('Cannot find transaction calendar');
767: G_transaction_calendar_id := NULL;
768: END IF;
769:
770: cep_standard.debug('< 771: EXCEPTION
772: WHEN OTHERS THEN
773: cep_standard.debug('EXCEPTION - OTHERS: validate_transaction_calendar');
774: RAISE;

Line 773: cep_standard.debug('EXCEPTION - OTHERS: validate_transaction_calendar');

769:
770: cep_standard.debug('< 771: EXCEPTION
772: WHEN OTHERS THEN
773: cep_standard.debug('EXCEPTION - OTHERS: validate_transaction_calendar');
774: RAISE;
775: END validate_transaction_calendar;
776:
777:

Line 808: cep_standard.debug('>>CE_CASH_FCST.valid_calendar_name');

804: AND (org.org_id = DECODE(G_org_id, -1, org.org_id,-99, org.org_id, G_org_id)
805: or org.org_id IS NULL);
806:
807: BEGIN
808: cep_standard.debug('>>CE_CASH_FCST.valid_calendar_name');
809:
810: IF(G_app_short_name = 'GL')THEN
811: SELECT period_set_name, set_of_books_id, name, currency_code
812: INTO calendar, sob_id, sob_name, G_sob_currency_code

Line 843: cep_standard.debug('<

839: END IF;
840: END LOOP;
841: END IF;
842:
843: cep_standard.debug('< 844: return (valid_period);
845: EXCEPTION
846: WHEN OTHERS THEN
847: cep_standard.debug('EXCEPTION -OTHERS:valid_calendar_name');

Line 847: cep_standard.debug('EXCEPTION -OTHERS:valid_calendar_name');

843: cep_standard.debug('< 844: return (valid_period);
845: EXCEPTION
846: WHEN OTHERS THEN
847: cep_standard.debug('EXCEPTION -OTHERS:valid_calendar_name');
848: IF sob_c%ISOPEN THEN CLOSE sob_c; END IF;
849: RAISE;
850: END valid_calendar_name;
851:

Line 891: cep_standard.debug('EXCEPTION: CE_CASH_FCST.valid_col_info');

887:
888: return valid_col;
889: EXCEPTION
890: WHEN OTHERS THEN
891: cep_standard.debug('EXCEPTION: CE_CASH_FCST.valid_col_info');
892: RAISE;
893: END valid_col_info;
894:
895: /* ---------------------------------------------------------------------

Line 918: cep_standard.debug('>>CE_CASH_FCST.valid_col_range');

914: days_from NUMBER;
915: days_to NUMBER;
916: all_valid BOOLEAN DEFAULT TRUE;
917: BEGIN
918: cep_standard.debug('>>CE_CASH_FCST.valid_col_range');
919:
920: G_min_col := CEFC_VIEW_CONST.get_min_col;
921: G_max_col := CEFC_VIEW_CONST.get_max_col;
922: G_invalid_overdue := FALSE;

Line 923: cep_standard.debug('G_min_col = '||to_char(G_min_col));

919:
920: G_min_col := CEFC_VIEW_CONST.get_min_col;
921: G_max_col := CEFC_VIEW_CONST.get_max_col;
922: G_invalid_overdue := FALSE;
923: cep_standard.debug('G_min_col = '||to_char(G_min_col));
924: cep_standard.debug('G_max_col = '||to_char(G_max_col));
925:
926: OPEN cCol;
927: FETCH cCol INTO cid, col_num, days_from, days_to;

Line 924: cep_standard.debug('G_max_col = '||to_char(G_max_col));

920: G_min_col := CEFC_VIEW_CONST.get_min_col;
921: G_max_col := CEFC_VIEW_CONST.get_max_col;
922: G_invalid_overdue := FALSE;
923: cep_standard.debug('G_min_col = '||to_char(G_min_col));
924: cep_standard.debug('G_max_col = '||to_char(G_max_col));
925:
926: OPEN cCol;
927: FETCH cCol INTO cid, col_num, days_from, days_to;
928: LOOP

Line 951: cep_standard.debug('<

947:
948: FETCH cCol INTO cid, col_num, days_from, days_to;
949: END LOOP;
950:
951: cep_standard.debug('< 952: return(all_valid);
953:
954: EXCEPTION
955: WHEN OTHERS THEN

Line 957: cep_standard.debug('EXCEPTION: CE_CASH_FCST.valid_col_range');

953:
954: EXCEPTION
955: WHEN OTHERS THEN
956: IF(cCol%ISOPEN)THEN CLOSE cCol; END IF;
957: cep_standard.debug('EXCEPTION: CE_CASH_FCST.valid_col_range');
958: RAISE;
959: END valid_col_range;
960:
961:

Line 1045: cep_standard.debug('EXCEPTION: CE_CASH_FCST.valid_row_info');

1041: return valid_row;
1042: EXCEPTION
1043: WHEN OTHERS THEN
1044: IF f_row_cursor%ISOPEN THEN CLOSE f_row_cursor; END IF;
1045: cep_standard.debug('EXCEPTION: CE_CASH_FCST.valid_row_info');
1046: RAISE;
1047: END valid_row_info;
1048:
1049:

Line 1107: cep_standard.debug('>> CE_CASH_FCST.submit_child_requests ');

1103: AND forecast_header_id = p_forecast_header_id
1104: AND trx_type <> 'GLC';
1105:
1106: BEGIN
1107: cep_standard.debug('>> CE_CASH_FCST.submit_child_requests ');
1108:
1109: open CRowNumber(G_rp_forecast_header_id,G_rp_rownum_from, G_rp_rownum_to);
1110: LOOP
1111: FETCH CRowNumber INTO G_row_number;

Line 1198: cep_standard.debug('EXCEPTION: CE_CASH_FCST.submit_child_requests');

1194: CLOSE CRowNumber;
1195: EXCEPTION
1196: WHEN OTHERS THEN
1197: IF CRowNumber%ISOPEN THEN CLOSE CRowNumber; END IF;
1198: cep_standard.debug('EXCEPTION: CE_CASH_FCST.submit_child_requests');
1199: RAISE;
1200: END submit_child_requests;
1201:
1202: /* ---------------------------------------------------------------------

Line 1319: cep_standard.debug('EXCEPTION: CE_CASH_FCST.create_forecast_header ');

1315: END IF;
1316:
1317: EXCEPTION
1318: WHEN OTHERS THEN
1319: cep_standard.debug('EXCEPTION: CE_CASH_FCST.create_forecast_header ');
1320: RAISE;
1321: END create_forecast_header;
1322:
1323: /* ---------------------------------------------------------------------

Line 1400: cep_standard.debug('Forecast NOT run');

1396: UPDATE ce_forecasts
1397: SET error_status = 'E'
1398: WHERE forecast_id = G_forecast_id;
1399:
1400: cep_standard.debug('Forecast NOT run');
1401: commit;
1402: print_report;
1403: END IF;
1404:

Line 1408: cep_standard.debug('EXCEPTION: CE_CASH_FCST.valid_forecast_run');

1404:
1405: return valid_pmr;
1406: EXCEPTION
1407: WHEN OTHERS THEN
1408: cep_standard.debug('EXCEPTION: CE_CASH_FCST.valid_forecast_run');
1409: END valid_forecast_run;
1410:
1411: /* ---------------------------------------------------------------------
1412: | PUBLIC PROCEDURE |

Line 1435: cep_standard.debug('>>CE_CASH_FCST.create_forecast');

1431: req_data VARCHAR2(30);
1432: l_status VARCHAR2(1);
1433: col_setup VARCHAR2(1);
1434: BEGIN
1435: cep_standard.debug('>>CE_CASH_FCST.create_forecast');
1436:
1437: counter := 0;
1438: --
1439: -- Get forecast header info

Line 1446: cep_standard.debug('Aging type: ' || G_aging_type);

1442: FETCH f_header_cursor INTO G_forecast_name, G_aging_type,
1443: G_overdue_transactions, G_transaction_calendar_id,
1444: G_start_project_id, G_end_project_id;
1445: CLOSE f_header_cursor;
1446: cep_standard.debug('Aging type: ' || G_aging_type);
1447: cep_Standard.debug('Name: '|| G_forecast_name);
1448:
1449: FND_CURRENCY.get_info(G_rp_forecast_currency, G_precision, G_ext_precision, G_min_acct_unit);
1450:

Line 1447: cep_Standard.debug('Name: '|| G_forecast_name);

1443: G_overdue_transactions, G_transaction_calendar_id,
1444: G_start_project_id, G_end_project_id;
1445: CLOSE f_header_cursor;
1446: cep_standard.debug('Aging type: ' || G_aging_type);
1447: cep_Standard.debug('Name: '|| G_forecast_name);
1448:
1449: FND_CURRENCY.get_info(G_rp_forecast_currency, G_precision, G_ext_precision, G_min_acct_unit);
1450:
1451: IF(G_overdue_transactions = 'INCLUDE')THEN

Line 1460: cep_standard.debug('ERROR: cannot get overdue column id');

1456: WHERE forecast_header_id = G_rp_forecast_header_id AND
1457: developer_column_num = 0;
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: cep_standard.debug('ERROR: cannot get overdue column id');
1461: RAISE;
1462: END;
1463: END IF;
1464:

Line 1536: cep_standard.debug('Forecast defn valid');

1532: END IF;
1533:
1534: IF ((standalone_process AND (NOT G_gl_cash_only)) OR child_process) THEN
1535: OPEN f_row_cursor(G_rp_forecast_header_id,G_rp_rownum_from, G_rp_rownum_to);
1536: cep_standard.debug('Forecast defn valid');
1537:
1538: -- If column setup is automatic populate CE_FORECAST_COLUMNS
1539: -- before populating cells.
1540: SELECT nvl(column_setup,'M')

Line 1585: cep_standard.debug('Calling Pop Cells...for trx : ' || G_trx_type||

1581: G_rp_calendar_name, G_rp_forecast_start_period,
1582: G_rp_forecast_start_date, G_min_col, G_max_col);
1583: G_invalid_overdue_row := G_invalid_overdue;
1584:
1585: cep_standard.debug('Calling Pop Cells...for trx : ' || G_trx_type||
1586: ' and row_number :' || G_row_number);
1587: CE_CSH_FCST_POP.Populate_Cells;
1588: END LOOP;
1589: CLOSE f_row_cursor;

Line 1623: cep_standard.debug('EXCEPTION: CE_CASH_FCST.cash_forecast');

1619: EXCEPTION
1620: WHEN OTHERS THEN
1621: IF f_row_cursor%ISOPEN THEN CLOSE f_row_cursor; END IF;
1622: IF f_header_cursor%ISOPEN THEN CLOSE f_header_cursor; END IF;
1623: cep_standard.debug('EXCEPTION: CE_CASH_FCST.cash_forecast');
1624: RAISE;
1625: END create_forecast;
1626:
1627:

Line 1695: CEP_STANDARD.init_security; --for bug 5702438

1691: p_amount_threshold NUMBER;
1692: BEGIN
1693:
1694: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
1695: CEP_STANDARD.init_security; --for bug 5702438
1696:
1697: -- Now the process is officially 'Running' and not 'Pending'
1698: --bug 4345353 convert amount threshold from canonical to number
1699: p_amount_threshold := fnd_number.canonical_to_number(p_amount_threshold_x);

Line 1717: cep_standard.enable_debug(p_debug_path,

1713: WHERE forecast_id = p_forecast_id;
1714: END IF;
1715:
1716: If (p_display_debug = 'Y') then
1717: cep_standard.enable_debug(p_debug_path,
1718: p_debug_file);
1719: end if;
1720: cep_standard.debug('>>CE_CASH_FCST.Forecast');
1721:

Line 1720: cep_standard.debug('>>CE_CASH_FCST.Forecast');

1716: If (p_display_debug = 'Y') then
1717: cep_standard.enable_debug(p_debug_path,
1718: p_debug_file);
1719: end if;
1720: cep_standard.debug('>>CE_CASH_FCST.Forecast');
1721:
1722: IF (p_start_project_num IS NULL AND
1723: p_end_project_num IS NULL) THEN
1724: set_parameters( p_forecast_header_id,

Line 1780: cep_standard.disable_debug(p_display_debug);

1776: p_debug_file);
1777: create_forecast;
1778: END LOOP;
1779: IF (p_display_debug = 'Y') THEN
1780: cep_standard.disable_debug(p_display_debug);
1781: END IF;
1782: END IF;
1783:
1784: END Forecast;

Line 1853: CEP_STANDARD.init_security;

1849: error_msg FND_NEW_MESSAGES.message_text%TYPE;
1850: p_amount_threshold NUMBER;
1851: BEGIN
1852: -- populate ce_security_profiles_gt table with ce_security_procfiles_v
1853: CEP_STANDARD.init_security;
1854:
1855: -- Now the process is officially 'Running' and not 'Pending'
1856: -- --bug 4345353 convert amount threshold from canonical to number
1857: p_amount_threshold := fnd_number.canonical_to_number(p_amount_threshold_x);

Line 1876: cep_standard.enable_debug(p_debug_path,

1872: WHERE forecast_id = p_forecast_id;
1873: END IF;
1874:
1875: If (p_display_debug = 'Y') then
1876: cep_standard.enable_debug(p_debug_path,
1877: p_debug_file);
1878: end if;
1879: G_start_project_no := p_start_project_num;
1880: G_end_project_no := p_end_project_num;

Line 1941: cep_standard.disable_debug(p_display_debug);

1937: create_forecast;
1938: END LOOP;
1939: END IF;
1940: IF (p_display_debug = 'Y') THEN
1941: cep_standard.disable_debug(p_display_debug);
1942: END IF;
1943: END Forecast;
1944:
1945: