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.XTR_CASH_FCST dependencies on XTR_DEBUG_PKG

Line 139: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

135: G_rp_org_ids := l_orgs;
136: EXCEPTION
137: WHEN OTHERS THEN
138: -- G_rp_org_ids := NULL;
139: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
140: xtr_debug_pkg.debug('XTR_CASH_FCST.set_parameters-->NO_ORGS');
141: END IF;
142: Raise;
143: END;

Line 140: xtr_debug_pkg.debug('XTR_CASH_FCST.set_parameters-->NO_ORGS');

136: EXCEPTION
137: WHEN OTHERS THEN
138: -- G_rp_org_ids := NULL;
139: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
140: xtr_debug_pkg.debug('XTR_CASH_FCST.set_parameters-->NO_ORGS');
141: END IF;
142: Raise;
143: END;
144:

Line 148: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

144:
145: /* RV END */
146:
147:
148: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
149: xtr_debug_pkg.debug('>>CE_CASH_FCST.set_parameters');
150: END IF;
151: G_rp_forecast_runname := p_forecast_runname;
152: G_rp_forecast_start_date := to_date(p_forecast_start_date,'YYYY/MM/DD HH24:MI:SS');

Line 149: xtr_debug_pkg.debug('>>CE_CASH_FCST.set_parameters');

145: /* RV END */
146:
147:
148: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
149: xtr_debug_pkg.debug('>>CE_CASH_FCST.set_parameters');
150: END IF;
151: G_rp_forecast_runname := p_forecast_runname;
152: G_rp_forecast_start_date := to_date(p_forecast_start_date,'YYYY/MM/DD HH24:MI:SS');
153: G_rp_forecast_currency := p_forecast_currency;

Line 165: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

161: G_parent_process := TRUE;
162: ELSE
163: G_parent_process := FALSE;
164: END IF;
165: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
166: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
167: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);

Line 166: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);

162: ELSE
163: G_parent_process := FALSE;
164: END IF;
165: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
166: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
167: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);

Line 167: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);

163: G_parent_process := FALSE;
164: END IF;
165: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
166: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
167: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);

Line 168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);

164: END IF;
165: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
166: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
167: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);

Line 169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);

165: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
166: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
167: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);

Line 170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);

166: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_header_id : '||G_rp_forecast_header_id);
167: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);

Line 171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);

167: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_runname : '||G_rp_forecast_runname);
168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);

Line 172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);

168: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_date : '||G_rp_forecast_start_date);
169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);

Line 173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);

169: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_start_period : '||G_rp_forecast_start_period);
170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);

Line 174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);

170: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_forecast_currency : '||G_rp_forecast_currency);
171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
178: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);

Line 175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);

171: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_type : '||G_rp_exchange_type);
172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
178: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
179: xtr_debug_pkg.debug('XTR_CASH_FCST.G_forecast_id : '||G_forecast_id);

Line 176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);

172: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_date : '||G_rp_exchange_date);
173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
178: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
179: xtr_debug_pkg.debug('XTR_CASH_FCST.G_forecast_id : '||G_forecast_id);
180: END IF;

Line 177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);

173: -- xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_exchange_rate : '||G_rp_exchange_rate);
174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
178: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
179: xtr_debug_pkg.debug('XTR_CASH_FCST.G_forecast_id : '||G_forecast_id);
180: END IF;
181: --

Line 178: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);

174: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_curr_type : '||G_rp_src_curr_type);
175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
178: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
179: xtr_debug_pkg.debug('XTR_CASH_FCST.G_forecast_id : '||G_forecast_id);
180: END IF;
181: --
182: -- Set View constants

Line 179: xtr_debug_pkg.debug('XTR_CASH_FCST.G_forecast_id : '||G_forecast_id);

175: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_src_currency : '||G_rp_src_currency);
176: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_from : '||G_rp_rownum_from);
177: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_rownum_to : '||G_rp_rownum_to);
178: xtr_debug_pkg.debug('XTR_CASH_FCST.G_rp_sub_request : '||G_rp_sub_request);
179: xtr_debug_pkg.debug('XTR_CASH_FCST.G_forecast_id : '||G_forecast_id);
180: END IF;
181: --
182: -- Set View constants
183: --

Line 228: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

224: request_id := to_number(reqid);
225: --
226: -- Get print options
227: --
228: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
229: xtr_debug_pkg.debug('Request Id is ' || request_id);
230: END IF;
231: IF( NOT FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS(request_id,
232: number_of_copies,

Line 229: xtr_debug_pkg.debug('Request Id is ' || request_id);

225: --
226: -- Get print options
227: --
228: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
229: xtr_debug_pkg.debug('Request Id is ' || request_id);
230: END IF;
231: IF( NOT FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS(request_id,
232: number_of_copies,
233: print_style,

Line 236: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

232: number_of_copies,
233: print_style,
234: printer,
235: save_output_flag))THEN
236: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
237: xtr_debug_pkg.debug('Message: get print options failed');
238: END IF;
239: ELSE
240: IF (save_output_flag = 'Y') THEN

Line 237: xtr_debug_pkg.debug('Message: get print options failed');

233: print_style,
234: printer,
235: save_output_flag))THEN
236: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
237: xtr_debug_pkg.debug('Message: get print options failed');
238: END IF;
239: ELSE
240: IF (save_output_flag = 'Y') THEN
241: save_output_bool := TRUE;

Line 252: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

248: IF (NOT FND_REQUEST.set_print_options(printer,
249: print_style,
250: number_of_copies,
251: save_output_bool)) THEN
252: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
253: xtr_debug_pkg.debug('Set print options failed');
254: END IF;
255: END IF;
256: END IF;

Line 253: xtr_debug_pkg.debug('Set print options failed');

249: print_style,
250: number_of_copies,
251: save_output_bool)) THEN
252: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
253: xtr_debug_pkg.debug('Set print options failed');
254: END IF;
255: END IF;
256: END IF;
257: req_id := FND_REQUEST.SUBMIT_REQUEST('XTR',

Line 282: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

278: | 05-AUG-1997 Created Wynne Chan |
279: ---------------------------------------------------------------------*/
280: PROCEDURE validate_transaction_calendar IS
281: BEGIN
282: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
283: xtr_debug_pkg.debug('>>validate_transaction_calendar');
284: END IF;
285:
286: SELECT min(transaction_date), max(transaction_date)

Line 283: xtr_debug_pkg.debug('>>validate_transaction_calendar');

279: ---------------------------------------------------------------------*/
280: PROCEDURE validate_transaction_calendar IS
281: BEGIN
282: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
283: xtr_debug_pkg.debug('>>validate_transaction_calendar');
284: END IF;
285:
286: SELECT min(transaction_date), max(transaction_date)
287: INTO XTR_CSH_FCST_POP.G_calendar_start, XTR_CSH_FCST_POP.G_calendar_end

Line 293: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

289: WHERE transaction_calendar_id = G_transaction_calendar_id;
290:
291: IF(XTR_CSH_FCST_POP.G_calendar_start IS NULL OR
292: XTR_CSH_FCST_POP.G_calendar_end IS NULL)THEN
293: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
294: xtr_debug_pkg.debug('Cannot find transaction calendar');
295: END IF;
296: G_transaction_calendar_id := NULL;
297: END IF;

Line 294: xtr_debug_pkg.debug('Cannot find transaction calendar');

290:
291: IF(XTR_CSH_FCST_POP.G_calendar_start IS NULL OR
292: XTR_CSH_FCST_POP.G_calendar_end IS NULL)THEN
293: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
294: xtr_debug_pkg.debug('Cannot find transaction calendar');
295: END IF;
296: G_transaction_calendar_id := NULL;
297: END IF;
298: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 298: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

294: xtr_debug_pkg.debug('Cannot find transaction calendar');
295: END IF;
296: G_transaction_calendar_id := NULL;
297: END IF;
298: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
299: xtr_debug_pkg.debug('< 300: END IF;
301: EXCEPTION
302: WHEN OTHERS THEN

Line 299: xtr_debug_pkg.debug('<

295: END IF;
296: G_transaction_calendar_id := NULL;
297: END IF;
298: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
299: xtr_debug_pkg.debug('< 300: END IF;
301: EXCEPTION
302: WHEN OTHERS THEN
303: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 303: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

299: xtr_debug_pkg.debug('< 300: END IF;
301: EXCEPTION
302: WHEN OTHERS THEN
303: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
304: xtr_debug_pkg.debug('EXCEPTION - OTHERS: validate_transaction_calendar');
305: END IF;
306:
307: RAISE;

Line 304: xtr_debug_pkg.debug('EXCEPTION - OTHERS: validate_transaction_calendar');

300: END IF;
301: EXCEPTION
302: WHEN OTHERS THEN
303: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
304: xtr_debug_pkg.debug('EXCEPTION - OTHERS: validate_transaction_calendar');
305: END IF;
306:
307: RAISE;
308: END validate_transaction_calendar;

Line 341: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

337: AND (org.org_id = DECODE(G_org_id, -1, org.org_id,-99, org.org_id, G_org_id)
338: or org.org_id IS NULL);
339:
340: BEGIN
341: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
342: xtr_debug_pkg.debug('>>XTR_CASH_FCST.valid_calendar_name');
343: END IF;
344:
345: IF(G_app_short_name = 'GL')THEN

Line 342: xtr_debug_pkg.debug('>>XTR_CASH_FCST.valid_calendar_name');

338: or org.org_id IS NULL);
339:
340: BEGIN
341: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
342: xtr_debug_pkg.debug('>>XTR_CASH_FCST.valid_calendar_name');
343: END IF;
344:
345: IF(G_app_short_name = 'GL')THEN
346: SELECT period_set_name, set_of_books_id, name, currency_code

Line 356: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

352: valid_period := FALSE;
353: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
354: FND_MESSAGE.set_token('SOB_NAME', sob_name);
355: error_msg := fnd_message.get;
356: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
357: xtr_debug_pkg.debug(error_msg);
358: END IF;
359: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
360: 'CE_FC_INVALID_PERIOD', error_msg);

Line 357: xtr_debug_pkg.debug(error_msg);

353: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
354: FND_MESSAGE.set_token('SOB_NAME', sob_name);
355: error_msg := fnd_message.get;
356: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
357: xtr_debug_pkg.debug(error_msg);
358: END IF;
359: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
360: 'CE_FC_INVALID_PERIOD', error_msg);
361: END IF;

Line 373: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

369: valid_period := FALSE;
370: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
371: FND_MESSAGE.set_token('SOB_NAME', sob_name);
372: error_msg := fnd_message.get;
373: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
374: xtr_debug_pkg.debug(error_msg);
375: END IF;
376: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
377: 'CE_FC_INVALID_PERIOD', error_msg);

Line 374: xtr_debug_pkg.debug(error_msg);

370: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
371: FND_MESSAGE.set_token('SOB_NAME', sob_name);
372: error_msg := fnd_message.get;
373: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
374: xtr_debug_pkg.debug(error_msg);
375: END IF;
376: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
377: 'CE_FC_INVALID_PERIOD', error_msg);
378: END IF;

Line 381: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

377: 'CE_FC_INVALID_PERIOD', error_msg);
378: END IF;
379: END LOOP;
380: END IF;
381: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
382: xtr_debug_pkg.debug('< 383: END IF;
384: return (valid_period);
385: EXCEPTION

Line 382: xtr_debug_pkg.debug('<

378: END IF;
379: END LOOP;
380: END IF;
381: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
382: xtr_debug_pkg.debug('< 383: END IF;
384: return (valid_period);
385: EXCEPTION
386: WHEN OTHERS THEN

Line 387: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

383: END IF;
384: return (valid_period);
385: EXCEPTION
386: WHEN OTHERS THEN
387: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
388: xtr_debug_pkg.debug('EXCEPTION -OTHERS:valid_calendar_name');
389: END IF;
390: IF sob_c%ISOPEN THEN CLOSE sob_c; END IF;
391: RAISE;

Line 388: xtr_debug_pkg.debug('EXCEPTION -OTHERS:valid_calendar_name');

384: return (valid_period);
385: EXCEPTION
386: WHEN OTHERS THEN
387: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
388: xtr_debug_pkg.debug('EXCEPTION -OTHERS:valid_calendar_name');
389: END IF;
390: IF sob_c%ISOPEN THEN CLOSE sob_c; END IF;
391: RAISE;
392: END valid_calendar_name;

Line 452: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

448: AND forecast_header_id = p_forecast_header_id
449: AND trx_type <> 'GLC';
450:
451: BEGIN
452: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
453: xtr_debug_pkg.debug('>> XTR_CASH_FCST.submit_child_requests ');
454: END IF;
455: open CRowNumber(G_rp_forecast_header_id,G_rp_rownum_from, G_rp_rownum_to);
456: LOOP

Line 453: xtr_debug_pkg.debug('>> XTR_CASH_FCST.submit_child_requests ');

449: AND trx_type <> 'GLC';
450:
451: BEGIN
452: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
453: xtr_debug_pkg.debug('>> XTR_CASH_FCST.submit_child_requests ');
454: END IF;
455: open CRowNumber(G_rp_forecast_header_id,G_rp_rownum_from, G_rp_rownum_to);
456: LOOP
457: FETCH CRowNumber INTO G_row_number;

Line 483: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

479: CLOSE CRowNumber;
480: EXCEPTION
481: WHEN OTHERS THEN
482: IF CRowNumber%ISOPEN THEN CLOSE CRowNumber; END IF;
483: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
484: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.submit_child_requests');
485: END IF;
486: RAISE;
487: END submit_child_requests;

Line 484: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.submit_child_requests');

480: EXCEPTION
481: WHEN OTHERS THEN
482: IF CRowNumber%ISOPEN THEN CLOSE CRowNumber; END IF;
483: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
484: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.submit_child_requests');
485: END IF;
486: RAISE;
487: END submit_child_requests;
488:

Line 563: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

559:
560: commit;
561: EXCEPTION
562: WHEN OTHERS THEN
563: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
564: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.create_forecast_header ');
565: END IF;
566: RAISE;
567: END create_forecast_header;

Line 564: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.create_forecast_header ');

560: commit;
561: EXCEPTION
562: WHEN OTHERS THEN
563: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
564: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.create_forecast_header ');
565: END IF;
566: RAISE;
567: END create_forecast_header;
568:

Line 593: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

589: counter NUMBER;
590: req_data VARCHAR2(30);
591: l_status VARCHAR2(1);
592: BEGIN
593: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
594: xtr_debug_pkg.debug('>>XTR_CASH_FCST.create_xtr_forecast');
595: END IF;
596: counter := 0;
597: --

Line 594: xtr_debug_pkg.debug('>>XTR_CASH_FCST.create_xtr_forecast');

590: req_data VARCHAR2(30);
591: l_status VARCHAR2(1);
592: BEGIN
593: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
594: xtr_debug_pkg.debug('>>XTR_CASH_FCST.create_xtr_forecast');
595: END IF;
596: counter := 0;
597: --
598: -- Get forecast header info

Line 605: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

601: FETCH f_header_cursor INTO G_forecast_name, G_aging_type,
602: G_overdue_transactions, G_transaction_calendar_id,
603: G_start_project_id, G_end_project_id, G_treasury_template;
604: CLOSE f_header_cursor;
605: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
606: xtr_debug_pkg.debug('Aging type: ' || G_aging_type);
607: xtr_debug_pkg.debug('Name: '|| G_forecast_name);
608: END IF;
609:

Line 606: xtr_debug_pkg.debug('Aging type: ' || G_aging_type);

602: G_overdue_transactions, G_transaction_calendar_id,
603: G_start_project_id, G_end_project_id, G_treasury_template;
604: CLOSE f_header_cursor;
605: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
606: xtr_debug_pkg.debug('Aging type: ' || G_aging_type);
607: xtr_debug_pkg.debug('Name: '|| G_forecast_name);
608: END IF;
609:
610: FND_CURRENCY.get_info(G_rp_forecast_currency, G_precision, G_ext_precision, G_min_acct_unit);

Line 607: xtr_debug_pkg.debug('Name: '|| G_forecast_name);

603: G_start_project_id, G_end_project_id, G_treasury_template;
604: CLOSE f_header_cursor;
605: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
606: xtr_debug_pkg.debug('Aging type: ' || G_aging_type);
607: xtr_debug_pkg.debug('Name: '|| G_forecast_name);
608: END IF;
609:
610: FND_CURRENCY.get_info(G_rp_forecast_currency, G_precision, G_ext_precision, G_min_acct_unit);
611:

Line 621: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

617: WHERE forecast_header_id = G_rp_forecast_header_id AND
618: level_of_summary = 'O';
619: EXCEPTION
620: WHEN OTHERS THEN
621: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
622: xtr_debug_pkg.debug('ERROR: cannot get overdue period id');
623: END IF;
624: RAISE;
625: END;

Line 622: xtr_debug_pkg.debug('ERROR: cannot get overdue period id');

618: level_of_summary = 'O';
619: EXCEPTION
620: WHEN OTHERS THEN
621: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
622: xtr_debug_pkg.debug('ERROR: cannot get overdue period id');
623: END IF;
624: RAISE;
625: END;
626: END IF;

Line 650: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

646:
647: IF (standalone_process OR child_process) THEN
648: OPEN f_row_cursor(G_rp_forecast_header_id,G_rp_rownum_from, G_rp_rownum_to);
649:
650: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
651: xtr_debug_pkg.debug('Forecast defn valid');
652: END IF;
653:
654: -- RV

Line 651: xtr_debug_pkg.debug('Forecast defn valid');

647: IF (standalone_process OR child_process) THEN
648: OPEN f_row_cursor(G_rp_forecast_header_id,G_rp_rownum_from, G_rp_rownum_to);
649:
650: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
651: xtr_debug_pkg.debug('Forecast defn valid');
652: END IF;
653:
654: -- RV
655: BEGIN

Line 664: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

660: COMMIT;
661: END IF;
662: EXCEPTION
663: WHEN OTHERS THEN
664: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
665: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.create_forecast-->delete');
666: END IF;
667: RAISE;
668: END;

Line 665: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.create_forecast-->delete');

661: END IF;
662: EXCEPTION
663: WHEN OTHERS THEN
664: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
665: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.create_forecast-->delete');
666: END IF;
667: RAISE;
668: END;
669:

Line 703: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

699: CEFC_VIEW_CONST.set_constants(G_rp_forecast_header_id,
700: G_rp_calendar_name, G_rp_forecast_start_period,
701: G_rp_forecast_start_date, G_min_col, G_max_col);
702: G_invalid_overdue_row := G_invalid_overdue;
703: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
704: xtr_debug_pkg.debug('Calling Pop Cells...for trx : ' || G_trx_type||
705: ' and row_number :' || G_row_number);
706: END IF;
707: XTR_CSH_FCST_POP.Populate_Cells;

Line 704: xtr_debug_pkg.debug('Calling Pop Cells...for trx : ' || G_trx_type||

700: G_rp_calendar_name, G_rp_forecast_start_period,
701: G_rp_forecast_start_date, G_min_col, G_max_col);
702: G_invalid_overdue_row := G_invalid_overdue;
703: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
704: xtr_debug_pkg.debug('Calling Pop Cells...for trx : ' || G_trx_type||
705: ' and row_number :' || G_row_number);
706: END IF;
707: XTR_CSH_FCST_POP.Populate_Cells;
708: END LOOP;

Line 729: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

725: EXCEPTION
726: WHEN OTHERS THEN
727: IF f_row_cursor%ISOPEN THEN CLOSE f_row_cursor; END IF;
728: IF f_header_cursor%ISOPEN THEN CLOSE f_header_cursor; END IF;
729: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
730: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.cash_xtr_forecast');
731: END IF;
732: RAISE;
733: END create_forecast;

Line 730: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.cash_xtr_forecast');

726: WHEN OTHERS THEN
727: IF f_row_cursor%ISOPEN THEN CLOSE f_row_cursor; END IF;
728: IF f_header_cursor%ISOPEN THEN CLOSE f_header_cursor; END IF;
729: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
730: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.cash_xtr_forecast');
731: END IF;
732: RAISE;
733: END create_forecast;
734:

Line 795: -- xtr_debug_pkg.enable_debug;

791: AND party_type = 'C';
792:
793:
794: BEGIN
795: -- xtr_debug_pkg.enable_debug;
796:
797: -- AW Bug 1378198 The following is taken from procedure CREATE_FORECAST_HEADER
798: --
799: BEGIN

Line 813: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

809: COMMIT;
810: END IF;
811: EXCEPTION
812: WHEN OTHERS THEN
813: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
814: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.forecast-->delete');
815: END IF;
816: RAISE;
817: END;

Line 814: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.forecast-->delete');

810: END IF;
811: EXCEPTION
812: WHEN OTHERS THEN
813: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
814: xtr_debug_pkg.debug('EXCEPTION: XTR_CASH_FCST.forecast-->delete');
815: END IF;
816: RAISE;
817: END;
818: --