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 123: cep_standard.debug('>>CE_CASH_FCST.set_parameters'); -- 14164001: Added debug

119: scenario can occur due to the inability of flex fields to handle
120: conditional value sets the way CE needs it and will result in erroneous
121: forecast amounts. */
122:
123: cep_standard.debug('>>CE_CASH_FCST.set_parameters'); -- 14164001: Added debug
124: IF (p_src_curr_type = 'E')
125: THEN
126: GL_CURRENCY_API.get_relation(
127: p_forecast_currency,

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

183: ELSE
184: G_parent_process := FALSE;
185: END IF;
186:
187: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
188: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
189: cep_standard.debug('CE_CASH_FCST.G_rp_calendar_name : '||G_rp_calendar_name);
190: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
191: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);

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

184: G_parent_process := FALSE;
185: END IF;
186:
187: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
188: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
189: cep_standard.debug('CE_CASH_FCST.G_rp_calendar_name : '||G_rp_calendar_name);
190: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
191: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
192: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);

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

185: END IF;
186:
187: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
188: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
189: cep_standard.debug('CE_CASH_FCST.G_rp_calendar_name : '||G_rp_calendar_name);
190: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
191: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
192: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
193: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);

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

186:
187: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
188: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
189: cep_standard.debug('CE_CASH_FCST.G_rp_calendar_name : '||G_rp_calendar_name);
190: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
191: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
192: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
193: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
194: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);

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

187: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
188: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
189: cep_standard.debug('CE_CASH_FCST.G_rp_calendar_name : '||G_rp_calendar_name);
190: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
191: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
192: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
193: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
194: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
195: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);

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

188: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
189: cep_standard.debug('CE_CASH_FCST.G_rp_calendar_name : '||G_rp_calendar_name);
190: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
191: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
192: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
193: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
194: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
195: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
196: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);

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

189: cep_standard.debug('CE_CASH_FCST.G_rp_calendar_name : '||G_rp_calendar_name);
190: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
191: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
192: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
193: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
194: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
195: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
196: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
197: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);

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

190: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
191: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
192: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
193: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
194: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
195: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
196: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
197: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
198: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);

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

191: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
192: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
193: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
194: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
195: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
196: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
197: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
198: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
199: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);

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

192: cep_standard.debug('CE_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
193: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
194: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
195: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
196: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
197: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
198: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
199: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
200: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);

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

193: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
194: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
195: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
196: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
197: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
198: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
199: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
200: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
201: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);

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

194: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
195: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
196: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
197: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
198: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
199: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
200: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
201: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);
202: cep_standard.debug('CE_CASH_FCST.G_display_debug : '||G_display_debug);

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

195: cep_standard.debug('CE_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
196: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
197: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
198: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
199: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
200: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
201: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);
202: cep_standard.debug('CE_CASH_FCST.G_display_debug : '||G_display_debug);
203: cep_standard.debug('CE_CASH_FCST.G_debug_path : '||G_debug_path);

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

196: cep_standard.debug('CE_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
197: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
198: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
199: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
200: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
201: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);
202: cep_standard.debug('CE_CASH_FCST.G_display_debug : '||G_display_debug);
203: cep_standard.debug('CE_CASH_FCST.G_debug_path : '||G_debug_path);
204: cep_standard.debug('CE_CASH_FCST.G_debug_file : '||G_debug_file);

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

197: cep_standard.debug('CE_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
198: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
199: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
200: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
201: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);
202: cep_standard.debug('CE_CASH_FCST.G_display_debug : '||G_display_debug);
203: cep_standard.debug('CE_CASH_FCST.G_debug_path : '||G_debug_path);
204: cep_standard.debug('CE_CASH_FCST.G_debug_file : '||G_debug_file);
205:

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

198: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
199: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
200: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
201: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);
202: cep_standard.debug('CE_CASH_FCST.G_display_debug : '||G_display_debug);
203: cep_standard.debug('CE_CASH_FCST.G_debug_path : '||G_debug_path);
204: cep_standard.debug('CE_CASH_FCST.G_debug_file : '||G_debug_file);
205:
206: --

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

199: cep_standard.debug('CE_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
200: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
201: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);
202: cep_standard.debug('CE_CASH_FCST.G_display_debug : '||G_display_debug);
203: cep_standard.debug('CE_CASH_FCST.G_debug_path : '||G_debug_path);
204: cep_standard.debug('CE_CASH_FCST.G_debug_file : '||G_debug_file);
205:
206: --
207: -- Set View constants

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

200: cep_standard.debug('CE_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
201: cep_standard.debug('CE_CASH_FCST.G_forecast_id : '||G_forecast_id);
202: cep_standard.debug('CE_CASH_FCST.G_display_debug : '||G_display_debug);
203: cep_standard.debug('CE_CASH_FCST.G_debug_path : '||G_debug_path);
204: cep_standard.debug('CE_CASH_FCST.G_debug_file : '||G_debug_file);
205:
206: --
207: -- Set View constants
208: -- 14164001: Added named parameters

Line 218: cep_standard.debug('<

214: pn_start_date => G_rp_forecast_start_date,
215: pn_min_col => NULL,
216: pn_max_col => NULL);
217:
218: cep_standard.debug('< 219:
220: END set_parameters;
221:
222:

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

254: request_id := to_number(reqid);
255: --
256: -- Get print options
257: --
258: cep_standard.debug('Request Id is ' || request_id);
259: IF( NOT FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS(request_id,
260: number_of_copies,
261: print_style,
262: printer,

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

260: number_of_copies,
261: print_style,
262: printer,
263: save_output_flag))THEN
264: cep_standard.debug('Message: get print options failed');
265: ELSE
266: IF (save_output_flag = 'Y') THEN
267: save_output_bool := TRUE;
268: ELSE

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

273: 'CEFCERR',
274: printer,
275: print_style,
276: save_output_flag))THEN
277: cep_standard.debug('Message: get print options failed');
278: END IF;
279: --
280: -- Set print options
281: --

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

282: IF (NOT FND_REQUEST.set_print_options(printer,
283: print_style,
284: number_of_copies,
285: save_output_bool)) THEN
286: cep_standard.debug('Set print options failed');
287: END IF;
288: END IF;
289: req_id := FND_REQUEST.SUBMIT_REQUEST('CE',
290: 'CEFCERR',

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

329: request_id := to_number(reqid);
330: --
331: -- Get print options
332: --
333: cep_standard.debug('Request Id is ' || request_id);
334: IF( NOT FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS(request_id,
335: number_of_copies,
336: print_style,
337: printer,

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

335: number_of_copies,
336: print_style,
337: printer,
338: save_output_flag))THEN
339: cep_standard.debug('Message: get print options failed');
340:
341: ELSE
342: IF (save_output_flag = 'Y') THEN
343: save_output_bool := TRUE;

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

349: 'CEFCAMTS',
350: printer,
351: print_style,
352: save_output_flag))THEN
353: cep_standard.debug('Message: get print options failed');
354: END IF;
355:
356: --
357: -- Set print options

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

359: IF (NOT FND_REQUEST.set_print_options(printer,
360: print_style,
361: number_of_copies,
362: save_output_bool)) THEN
363: cep_standard.debug('Set print options failed');
364: END IF;
365: END IF;
366:
367: SELECT forecast_header_id

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

432: error_msg FND_NEW_MESSAGES.message_text%TYPE;
433: xrate NUMBER;
434: all_exist_flag BOOLEAN := TRUE;
435: BEGIN
436: cep_standard.debug('>>CE_CASH_FCST.populate_base_xrate_table');
437:
438: --
439: -- For each base currencies used by OE rows, determine it's xrate from
440: -- valid currencies to the base currency.

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

456: CE_CASH_FCST.G_rp_exchange_type);
457: insert into CE_CURRENCY_RATES_TEMP
458: (forecast_request_id, currency_code, exchange_rate, to_currency)
459: values (CE_CASH_FCST.G_forecast_id, curr, xrate, to_curr);
460: cep_standard.debug(' Exchange info - '||curr||'->'||to_curr||' has rate '||to_char(xrate));
461: EXCEPTION
462: WHEN OTHERS THEN
463: -- WHEN NO_RATE THEN
464: -- bug 1200912

Line 505: cep_standard.debug('<

501: END IF;
502: END LOOP;
503: CLOSE base_curr;
504:
505: cep_standard.debug('< 506: return (all_exist_flag);
507:
508: EXCEPTION
509: WHEN OTHERS THEN

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

506: return (all_exist_flag);
507:
508: EXCEPTION
509: WHEN OTHERS THEN
510: cep_standard.debug('EXCEPTION - OTHERS:populate_base_xrate_table');
511: IF from_curr%ISOPEN THEN CLOSE from_curr; END IF;
512: IF base_curr%ISOPEN THEN CLOSE base_curr; END IF;
513: IF bad_curr%ISOPEN THEN CLOSE bad_curr; END IF;
514: RAISE;

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

565: from_curr_is_emu VARCHAR2(1);
566: l_currency_type VARCHAR2(5);
567:
568: BEGIN
569: cep_standard.debug('>>CE_CASH_FCST.populate_xrate_table');
570:
571: --
572: -- Insert constant rate (1) for forecast_currency to forecast_currency
573: --

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

626: insert into CE_CURRENCY_RATES_TEMP (forecast_request_id,
627: currency_code, exchange_rate, to_currency)
628: values (CE_CASH_FCST.G_forecast_id, from_curr, xrate,
629: G_rp_forecast_currency);
630: cep_standard.debug(' Exchange info - '||from_curr||' has rate '||to_char(xrate));
631: EXCEPTION
632: WHEN OTHERS THEN
633: -- WHEN NO_RATE THEN
634: skip_err_log := FALSE;

Line 715: cep_standard.debug('<

711: CLOSE bad_curr;
712:
713: END IF;
714:
715: cep_standard.debug('< 716: return (all_exist_flag);
717:
718: EXCEPTION
719: WHEN OTHERS THEN

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

716: return (all_exist_flag);
717:
718: EXCEPTION
719: WHEN OTHERS THEN
720: cep_standard.debug('EXCEPTION - OTHERS:populate_xrate_table');
721: IF C%ISOPEN THEN CLOSE C; END IF;
722: IF bad_curr%ISOPEN THEN CLOSE bad_curr; END IF;
723: RAISE;
724: return (FALSE);

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

740: | 21-JUL-1997 Created Wynne Chan |
741: ---------------------------------------------------------------------*/
742: PROCEDURE clear_xrate_table IS
743: BEGIN
744: cep_standard.debug('Delete all xrate information');
745: delete from CE_CURRENCY_RATES_TEMP
746: where forecast_request_id = CE_CASH_FCST.G_forecast_id;
747: EXCEPTION
748: WHEN OTHERS THEN

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

745: delete from CE_CURRENCY_RATES_TEMP
746: where forecast_request_id = CE_CASH_FCST.G_forecast_id;
747: EXCEPTION
748: WHEN OTHERS THEN
749: cep_standard.debug('EXCEPTION - OTHERS: clear_xrate_table');
750: RAISE;
751: END clear_xrate_table;
752:
753:

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

767: ---------------------------------------------------------------------*/
768: PROCEDURE validate_transaction_calendar IS
769: BEGIN
770:
771: cep_standard.debug('>>validate_transaction_calendar');
772:
773: SELECT min(transaction_date), max(transaction_date)
774: INTO CE_CSH_FCST_POP.G_calendar_start, CE_CSH_FCST_POP.G_calendar_end
775: FROM gl_transaction_dates

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

776: WHERE transaction_calendar_id = G_transaction_calendar_id;
777:
778: IF(CE_CSH_FCST_POP.G_calendar_start IS NULL OR
779: CE_CSH_FCST_POP.G_calendar_end IS NULL)THEN
780: cep_standard.debug('Cannot find transaction calendar');
781: G_transaction_calendar_id := NULL;
782: END IF;
783:
784: cep_standard.debug('<

Line 784: cep_standard.debug('<

780: cep_standard.debug('Cannot find transaction calendar');
781: G_transaction_calendar_id := NULL;
782: END IF;
783:
784: cep_standard.debug('< 785: EXCEPTION
786: WHEN OTHERS THEN
787: cep_standard.debug('EXCEPTION - OTHERS: validate_transaction_calendar');
788: RAISE;

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

783:
784: cep_standard.debug('< 785: EXCEPTION
786: WHEN OTHERS THEN
787: cep_standard.debug('EXCEPTION - OTHERS: validate_transaction_calendar');
788: RAISE;
789: END validate_transaction_calendar;
790:
791:

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

818: AND (org.org_id = DECODE(G_org_id, -1, org.org_id,-99, org.org_id, G_org_id)
819: or org.org_id IS NULL);
820:
821: BEGIN
822: cep_standard.debug('>>CE_CASH_FCST.valid_calendar_name');
823:
824: IF(G_app_short_name = 'GL')THEN
825: SELECT period_set_name, set_of_books_id, name, currency_code
826: INTO calendar, sob_id, sob_name, G_sob_currency_code

Line 857: cep_standard.debug('<

853: END IF;
854: END LOOP;
855: END IF;
856:
857: cep_standard.debug('< 858: return (valid_period);
859: EXCEPTION
860: WHEN OTHERS THEN
861: cep_standard.debug('EXCEPTION -OTHERS:valid_calendar_name');

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

857: cep_standard.debug('< 858: return (valid_period);
859: EXCEPTION
860: WHEN OTHERS THEN
861: cep_standard.debug('EXCEPTION -OTHERS:valid_calendar_name');
862: IF sob_c%ISOPEN THEN CLOSE sob_c; END IF;
863: RAISE;
864: END valid_calendar_name;
865:

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

901:
902: return valid_col;
903: EXCEPTION
904: WHEN OTHERS THEN
905: cep_standard.debug('EXCEPTION: CE_CASH_FCST.valid_col_info');
906: RAISE;
907: END valid_col_info;
908:
909: /* ---------------------------------------------------------------------

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

928: days_from NUMBER;
929: days_to NUMBER;
930: all_valid BOOLEAN DEFAULT TRUE;
931: BEGIN
932: cep_standard.debug('>>CE_CASH_FCST.valid_col_range');
933:
934: G_min_col := CEFC_VIEW_CONST.get_min_col;
935: G_max_col := CEFC_VIEW_CONST.get_max_col;
936: G_invalid_overdue := FALSE;

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

933:
934: G_min_col := CEFC_VIEW_CONST.get_min_col;
935: G_max_col := CEFC_VIEW_CONST.get_max_col;
936: G_invalid_overdue := FALSE;
937: cep_standard.debug('G_min_col = '||to_char(G_min_col));
938: cep_standard.debug('G_max_col = '||to_char(G_max_col));
939:
940: OPEN cCol;
941: FETCH cCol INTO cid, col_num, days_from, days_to;

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

934: G_min_col := CEFC_VIEW_CONST.get_min_col;
935: G_max_col := CEFC_VIEW_CONST.get_max_col;
936: G_invalid_overdue := FALSE;
937: cep_standard.debug('G_min_col = '||to_char(G_min_col));
938: cep_standard.debug('G_max_col = '||to_char(G_max_col));
939:
940: OPEN cCol;
941: FETCH cCol INTO cid, col_num, days_from, days_to;
942: LOOP

Line 965: cep_standard.debug('<

961:
962: FETCH cCol INTO cid, col_num, days_from, days_to;
963: END LOOP;
964:
965: cep_standard.debug('< 966: return(all_valid);
967:
968: EXCEPTION
969: WHEN OTHERS THEN

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

967:
968: EXCEPTION
969: WHEN OTHERS THEN
970: IF(cCol%ISOPEN)THEN CLOSE cCol; END IF;
971: cep_standard.debug('EXCEPTION: CE_CASH_FCST.valid_col_range');
972: RAISE;
973: END valid_col_range;
974:
975:

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

1055: return valid_row;
1056: EXCEPTION
1057: WHEN OTHERS THEN
1058: IF f_row_cursor%ISOPEN THEN CLOSE f_row_cursor; END IF;
1059: cep_standard.debug('EXCEPTION: CE_CASH_FCST.valid_row_info');
1060: RAISE;
1061: END valid_row_info;
1062:
1063:

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

1117: AND forecast_header_id = p_forecast_header_id
1118: AND trx_type <> 'GLC';
1119:
1120: BEGIN
1121: cep_standard.debug('>> CE_CASH_FCST.submit_child_requests ');
1122:
1123: open CRowNumber(G_rp_forecast_header_id,G_rp_rownum_from, G_rp_rownum_to);
1124: LOOP
1125: FETCH CRowNumber INTO G_row_number;

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

1208: CLOSE CRowNumber;
1209: EXCEPTION
1210: WHEN OTHERS THEN
1211: IF CRowNumber%ISOPEN THEN CLOSE CRowNumber; END IF;
1212: cep_standard.debug('EXCEPTION: CE_CASH_FCST.submit_child_requests');
1213: RAISE;
1214: END submit_child_requests;
1215:
1216: /* ---------------------------------------------------------------------

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

1329: END IF;
1330:
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: cep_standard.debug('EXCEPTION: CE_CASH_FCST.create_forecast_header ');
1334: RAISE;
1335: END create_forecast_header;
1336:
1337: /* ---------------------------------------------------------------------

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

1410: UPDATE ce_forecasts
1411: SET error_status = 'E'
1412: WHERE forecast_id = G_forecast_id;
1413:
1414: cep_standard.debug('Forecast NOT run');
1415: commit;
1416: print_report;
1417: END IF;
1418:

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

1418:
1419: return valid_pmr;
1420: EXCEPTION
1421: WHEN OTHERS THEN
1422: cep_standard.debug('EXCEPTION: CE_CASH_FCST.valid_forecast_run');
1423: END valid_forecast_run;
1424:
1425: /* ---------------------------------------------------------------------
1426: | PUBLIC PROCEDURE |

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

1448: req_data VARCHAR2(30);
1449: l_status VARCHAR2(1);
1450: col_setup VARCHAR2(1);
1451: BEGIN
1452: cep_standard.debug('>>CE_CASH_FCST.create_forecast');
1453:
1454: counter := 0;
1455: --
1456: -- Get forecast header info

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

1464: G_transaction_calendar_id,
1465: G_start_project_id, G_end_project_id;
1466: CLOSE f_header_cursor;
1467:
1468: cep_standard.debug('Aging type : '|| G_aging_type);
1469: cep_Standard.debug('Name : '|| G_forecast_name);
1470:
1471: FND_CURRENCY.get_info(
1472: G_rp_forecast_currency,

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

1465: G_start_project_id, G_end_project_id;
1466: CLOSE f_header_cursor;
1467:
1468: cep_standard.debug('Aging type : '|| G_aging_type);
1469: cep_Standard.debug('Name : '|| G_forecast_name);
1470:
1471: FND_CURRENCY.get_info(
1472: G_rp_forecast_currency,
1473: G_precision,

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

1483: WHERE forecast_header_id = G_rp_forecast_header_id
1484: AND developer_column_num = 0;
1485: EXCEPTION
1486: WHEN OTHERS THEN
1487: cep_standard.debug('ERROR: cannot get overdue column id');
1488: RAISE;
1489: END;
1490: END IF;
1491:

Line 1508: cep_standard.debug('NOT valid_forecast_run'); -- 14164001

1504:
1505: create_forecast_header;
1506: IF( NOT valid_forecast_run )
1507: THEN
1508: cep_standard.debug('NOT valid_forecast_run'); -- 14164001
1509: RETURN;
1510: END IF;
1511:
1512: -- Populate exchange information from GL for forecast currency

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

1569:
1570: IF ((standalone_process AND (NOT G_gl_cash_only)) OR child_process)
1571: THEN
1572: OPEN f_row_cursor(G_rp_forecast_header_id,G_rp_rownum_from, G_rp_rownum_to);
1573: cep_standard.debug('Forecast defn valid');
1574:
1575: -- If column setup is automatic populate CE_FORECAST_COLUMNS
1576: -- before populating cells.
1577: SELECT nvl(column_setup,'M')

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

1667: G_max_col);
1668:
1669: G_invalid_overdue_row := G_invalid_overdue;
1670:
1671: cep_standard.debug('Calling Pop Cells...for trx : ' || G_trx_type||
1672: ' and row_number :' || G_row_number);
1673: CE_CSH_FCST_POP.Populate_Cells;
1674: END LOOP;
1675:

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

1717: IF f_header_cursor%ISOPEN THEN
1718: CLOSE f_header_cursor;
1719: END IF;
1720:
1721: cep_standard.debug('EXCEPTION: CE_CASH_FCST.cash_forecast');
1722: RAISE;
1723: END create_forecast;
1724:
1725:

Line 1796: cep_standard.debug('>>CE_CASH_FCST.Forecast (with p_dummy)'); -- 14164001: Added

1792:
1793: error_msg FND_NEW_MESSAGES.message_text%TYPE;
1794: p_amount_threshold NUMBER;
1795: BEGIN
1796: cep_standard.debug('>>CE_CASH_FCST.Forecast (with p_dummy)'); -- 14164001: Added
1797:
1798: -- populate ce_security_profiles_gt table with ce_security_profiles_v
1799: CEP_STANDARD.init_security; --for bug 5702438
1800:

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

1795: BEGIN
1796: cep_standard.debug('>>CE_CASH_FCST.Forecast (with p_dummy)'); -- 14164001: Added
1797:
1798: -- populate ce_security_profiles_gt table with ce_security_profiles_v
1799: CEP_STANDARD.init_security; --for bug 5702438
1800:
1801: -- Now the process is officially 'Running' and not 'Pending'
1802: --bug 4345353 convert amount threshold from canonical to number
1803: p_amount_threshold := fnd_number.canonical_to_number(p_amount_threshold_x);

Line 1829: -- cep_standard.enable_debug(p_debug_path, p_debug_file);

1825: END IF;
1826:
1827: -- Bug 14164001: Obsoleted
1828: -- IF (p_display_debug = 'Y') THEN
1829: -- cep_standard.enable_debug(p_debug_path, p_debug_file);
1830: -- END IF;
1831: -- cep_standard.debug('>>CE_CASH_FCST.Forecast');
1832:
1833: IF (p_start_project_num IS NULL AND p_end_project_num IS NULL)

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

1827: -- Bug 14164001: Obsoleted
1828: -- IF (p_display_debug = 'Y') THEN
1829: -- cep_standard.enable_debug(p_debug_path, p_debug_file);
1830: -- END IF;
1831: -- cep_standard.debug('>>CE_CASH_FCST.Forecast');
1832:
1833: IF (p_start_project_num IS NULL AND p_end_project_num IS NULL)
1834: THEN
1835: set_parameters(

Line 1896: -- cep_standard.disable_debug(p_display_debug);

1892: END LOOP;
1893:
1894: -- Bug 14164001: Obsoleted
1895: -- IF (p_display_debug = 'Y') THEN
1896: -- cep_standard.disable_debug(p_display_debug);
1897: -- END IF;
1898: END IF;
1899: cep_standard.debug('< 1900:

Line 1899: cep_standard.debug('<

1895: -- IF (p_display_debug = 'Y') THEN
1896: -- cep_standard.disable_debug(p_display_debug);
1897: -- END IF;
1898: END IF;
1899: cep_standard.debug('< 1900:
1901: END Forecast;
1902:
1903: /* ---------------------------------------------------------------------

Line 1973: cep_standard.debug('>>CE_CASH_FCST.Forecast (without p_dummy)');

1969: error_msg FND_NEW_MESSAGES.message_text%TYPE;
1970: p_amount_threshold NUMBER;
1971:
1972: BEGIN
1973: cep_standard.debug('>>CE_CASH_FCST.Forecast (without p_dummy)');
1974: -- populate ce_security_profiles_gt table with ce_security_profiles_v
1975: CEP_STANDARD.init_security;
1976:
1977: -- bug 4345353 convert amount threshold from canonical to number

Line 1975: CEP_STANDARD.init_security;

1971:
1972: BEGIN
1973: cep_standard.debug('>>CE_CASH_FCST.Forecast (without p_dummy)');
1974: -- populate ce_security_profiles_gt table with ce_security_profiles_v
1975: CEP_STANDARD.init_security;
1976:
1977: -- bug 4345353 convert amount threshold from canonical to number
1978: p_amount_threshold := fnd_number.canonical_to_number(p_amount_threshold_x);
1979:

Line 2005: -- cep_standard.enable_debug(p_debug_path,p_debug_file);

2001: END IF;
2002:
2003: -- Bug 14164001: Obsoleted
2004: -- IF (p_display_debug = 'Y') THEN
2005: -- cep_standard.enable_debug(p_debug_path,p_debug_file);
2006: -- END IF;
2007:
2008: G_start_project_no := p_start_project_num;
2009: G_end_project_no := p_end_project_num;

Line 2074: -- cep_standard.disable_debug(p_display_debug);

2070: END LOOP;
2071: END IF;
2072: -- Bug 14164001: Obsoleted
2073: -- IF (p_display_debug = 'Y') THEN
2074: -- cep_standard.disable_debug(p_display_debug);
2075: -- END IF;
2076: cep_standard.debug('< 2077:
2078: END Forecast;

Line 2076: cep_standard.debug('<

2072: -- Bug 14164001: Obsoleted
2073: -- IF (p_display_debug = 'Y') THEN
2074: -- cep_standard.disable_debug(p_display_debug);
2075: -- END IF;
2076: cep_standard.debug('< 2077:
2078: END Forecast;
2079:
2080: END CE_CASH_FCST;