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.IGI_EFC_UPGRADE dependencies on FND_FILE

Line 105: fnd_file.put_line(fnd_file.log, 'Module: INSERT_ENTITY '||'Insertion failed '||SQLERRM);

101: END IF;
102:
103: EXCEPTION
104: WHEN OTHERS THEN
105: fnd_file.put_line(fnd_file.log, 'Module: INSERT_ENTITY '||'Insertion failed '||SQLERRM);
106: errbuf := 'Module: INSERT_ENTITY '||'Insertion failed '||SQLERRM;
107: retcode := -1;
108: RETURN;
109: END INSERT_ENTITY;

Line 164: fnd_file.put(fnd_file.output,lc_upg_gl_bud.LEDGER_NAME||' ');

160: OPEN C_UPG_GL_BUDGET_ASSIGNMENT(p_range_id);
161: FETCH C_UPG_GL_BUDGET_ASSIGNMENT INTO lc_upg_gl_bud;
162: CLOSE C_UPG_GL_BUDGET_ASSIGNMENT;
163:
164: fnd_file.put(fnd_file.output,lc_upg_gl_bud.LEDGER_NAME||' ');
165: fnd_file.put(fnd_file.output,lc_upg_gl_bud.BUDGET_NAME||' ');
166:
167: fnd_file.put(fnd_file.output,lc_upg_gl_bud.CURRENCY_CODE||' ');
168:

Line 165: fnd_file.put(fnd_file.output,lc_upg_gl_bud.BUDGET_NAME||' ');

161: FETCH C_UPG_GL_BUDGET_ASSIGNMENT INTO lc_upg_gl_bud;
162: CLOSE C_UPG_GL_BUDGET_ASSIGNMENT;
163:
164: fnd_file.put(fnd_file.output,lc_upg_gl_bud.LEDGER_NAME||' ');
165: fnd_file.put(fnd_file.output,lc_upg_gl_bud.BUDGET_NAME||' ');
166:
167: fnd_file.put(fnd_file.output,lc_upg_gl_bud.CURRENCY_CODE||' ');
168:
169: IF lc_upg_gl_bud.SEGMENT1_LOW IS NOT NULL THEN

Line 167: fnd_file.put(fnd_file.output,lc_upg_gl_bud.CURRENCY_CODE||' ');

163:
164: fnd_file.put(fnd_file.output,lc_upg_gl_bud.LEDGER_NAME||' ');
165: fnd_file.put(fnd_file.output,lc_upg_gl_bud.BUDGET_NAME||' ');
166:
167: fnd_file.put(fnd_file.output,lc_upg_gl_bud.CURRENCY_CODE||' ');
168:
169: IF lc_upg_gl_bud.SEGMENT1_LOW IS NOT NULL THEN
170: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT1_LOW||'-');
171: END IF;

Line 170: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT1_LOW||'-');

166:
167: fnd_file.put(fnd_file.output,lc_upg_gl_bud.CURRENCY_CODE||' ');
168:
169: IF lc_upg_gl_bud.SEGMENT1_LOW IS NOT NULL THEN
170: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT1_LOW||'-');
171: END IF;
172:
173: IF lc_upg_gl_bud.SEGMENT2_LOW IS NOT NULL THEN
174: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT2_LOW||'-');

Line 174: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT2_LOW||'-');

170: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT1_LOW||'-');
171: END IF;
172:
173: IF lc_upg_gl_bud.SEGMENT2_LOW IS NOT NULL THEN
174: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT2_LOW||'-');
175: END IF;
176:
177: IF lc_upg_gl_bud.SEGMENT3_LOW IS NOT NULL THEN
178: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT3_LOW||'-');

Line 178: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT3_LOW||'-');

174: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT2_LOW||'-');
175: END IF;
176:
177: IF lc_upg_gl_bud.SEGMENT3_LOW IS NOT NULL THEN
178: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT3_LOW||'-');
179: END IF;
180:
181: IF lc_upg_gl_bud.SEGMENT4_LOW IS NOT NULL THEN
182: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT4_LOW||'-');

Line 182: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT4_LOW||'-');

178: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT3_LOW||'-');
179: END IF;
180:
181: IF lc_upg_gl_bud.SEGMENT4_LOW IS NOT NULL THEN
182: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT4_LOW||'-');
183: END IF;
184:
185: IF lc_upg_gl_bud.SEGMENT5_LOW IS NOT NULL THEN
186: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT5_LOW||'-');

Line 186: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT5_LOW||'-');

182: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT4_LOW||'-');
183: END IF;
184:
185: IF lc_upg_gl_bud.SEGMENT5_LOW IS NOT NULL THEN
186: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT5_LOW||'-');
187: END IF;
188:
189: IF lc_upg_gl_bud.SEGMENT6_LOW IS NOT NULL THEN
190: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT6_LOW||'-');

Line 190: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT6_LOW||'-');

186: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT5_LOW||'-');
187: END IF;
188:
189: IF lc_upg_gl_bud.SEGMENT6_LOW IS NOT NULL THEN
190: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT6_LOW||'-');
191: END IF;
192:
193: IF lc_upg_gl_bud.SEGMENT7_LOW IS NOT NULL THEN
194: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT7_LOW||'-');

Line 194: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT7_LOW||'-');

190: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT6_LOW||'-');
191: END IF;
192:
193: IF lc_upg_gl_bud.SEGMENT7_LOW IS NOT NULL THEN
194: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT7_LOW||'-');
195: END IF;
196:
197: IF lc_upg_gl_bud.SEGMENT8_LOW IS NOT NULL THEN
198: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT8_LOW||'-');

Line 198: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT8_LOW||'-');

194: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT7_LOW||'-');
195: END IF;
196:
197: IF lc_upg_gl_bud.SEGMENT8_LOW IS NOT NULL THEN
198: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT8_LOW||'-');
199: END IF;
200:
201: IF lc_upg_gl_bud.SEGMENT9_LOW IS NOT NULL THEN
202: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT9_LOW||'-');

Line 202: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT9_LOW||'-');

198: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT8_LOW||'-');
199: END IF;
200:
201: IF lc_upg_gl_bud.SEGMENT9_LOW IS NOT NULL THEN
202: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT9_LOW||'-');
203: END IF;
204:
205: IF lc_upg_gl_bud.SEGMENT10_LOW IS NOT NULL THEN
206: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT10_LOW||'-');

Line 206: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT10_LOW||'-');

202: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT9_LOW||'-');
203: END IF;
204:
205: IF lc_upg_gl_bud.SEGMENT10_LOW IS NOT NULL THEN
206: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT10_LOW||'-');
207: END IF;
208:
209: IF lc_upg_gl_bud.SEGMENT11_LOW IS NOT NULL THEN
210: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT11_LOW||'-');

Line 210: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT11_LOW||'-');

206: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT10_LOW||'-');
207: END IF;
208:
209: IF lc_upg_gl_bud.SEGMENT11_LOW IS NOT NULL THEN
210: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT11_LOW||'-');
211: END IF;
212:
213: IF lc_upg_gl_bud.SEGMENT12_LOW IS NOT NULL THEN
214: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT12_LOW||'-');

Line 214: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT12_LOW||'-');

210: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT11_LOW||'-');
211: END IF;
212:
213: IF lc_upg_gl_bud.SEGMENT12_LOW IS NOT NULL THEN
214: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT12_LOW||'-');
215: END IF;
216:
217: IF lc_upg_gl_bud.SEGMENT13_LOW IS NOT NULL THEN
218: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT13_LOW||'-');

Line 218: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT13_LOW||'-');

214: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT12_LOW||'-');
215: END IF;
216:
217: IF lc_upg_gl_bud.SEGMENT13_LOW IS NOT NULL THEN
218: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT13_LOW||'-');
219: END IF;
220:
221: IF lc_upg_gl_bud.SEGMENT14_LOW IS NOT NULL THEN
222: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT14_LOW||'-');

Line 222: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT14_LOW||'-');

218: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT13_LOW||'-');
219: END IF;
220:
221: IF lc_upg_gl_bud.SEGMENT14_LOW IS NOT NULL THEN
222: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT14_LOW||'-');
223: END IF;
224:
225: IF lc_upg_gl_bud.SEGMENT15_LOW IS NOT NULL THEN
226: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT15_LOW||'-');

Line 226: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT15_LOW||'-');

222: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT14_LOW||'-');
223: END IF;
224:
225: IF lc_upg_gl_bud.SEGMENT15_LOW IS NOT NULL THEN
226: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT15_LOW||'-');
227: END IF;
228:
229: IF lc_upg_gl_bud.SEGMENT16_LOW IS NOT NULL THEN
230: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT16_LOW||'-');

Line 230: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT16_LOW||'-');

226: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT15_LOW||'-');
227: END IF;
228:
229: IF lc_upg_gl_bud.SEGMENT16_LOW IS NOT NULL THEN
230: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT16_LOW||'-');
231: END IF;
232:
233: IF lc_upg_gl_bud.SEGMENT17_LOW IS NOT NULL THEN
234: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT17_LOW||'-');

Line 234: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT17_LOW||'-');

230: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT16_LOW||'-');
231: END IF;
232:
233: IF lc_upg_gl_bud.SEGMENT17_LOW IS NOT NULL THEN
234: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT17_LOW||'-');
235: END IF;
236:
237: IF lc_upg_gl_bud.SEGMENT18_LOW IS NOT NULL THEN
238: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT18_LOW||'-');

Line 238: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT18_LOW||'-');

234: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT17_LOW||'-');
235: END IF;
236:
237: IF lc_upg_gl_bud.SEGMENT18_LOW IS NOT NULL THEN
238: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT18_LOW||'-');
239: END IF;
240: IF lc_upg_gl_bud.SEGMENT19_LOW IS NOT NULL THEN
241: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT19_LOW||'-');
242: END IF;

Line 241: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT19_LOW||'-');

237: IF lc_upg_gl_bud.SEGMENT18_LOW IS NOT NULL THEN
238: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT18_LOW||'-');
239: END IF;
240: IF lc_upg_gl_bud.SEGMENT19_LOW IS NOT NULL THEN
241: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT19_LOW||'-');
242: END IF;
243:
244: IF lc_upg_gl_bud.SEGMENT20_LOW IS NOT NULL THEN
245: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT20_LOW||'-');

Line 245: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT20_LOW||'-');

241: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT19_LOW||'-');
242: END IF;
243:
244: IF lc_upg_gl_bud.SEGMENT20_LOW IS NOT NULL THEN
245: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT20_LOW||'-');
246: END IF;
247:
248: IF lc_upg_gl_bud.SEGMENT21_LOW IS NOT NULL THEN
249: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT21_LOW||'-');

Line 249: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT21_LOW||'-');

245: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT20_LOW||'-');
246: END IF;
247:
248: IF lc_upg_gl_bud.SEGMENT21_LOW IS NOT NULL THEN
249: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT21_LOW||'-');
250: END IF;
251:
252: IF lc_upg_gl_bud.SEGMENT22_LOW IS NOT NULL THEN
253: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT22_LOW||'-');

Line 253: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT22_LOW||'-');

249: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT21_LOW||'-');
250: END IF;
251:
252: IF lc_upg_gl_bud.SEGMENT22_LOW IS NOT NULL THEN
253: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT22_LOW||'-');
254: END IF;
255:
256: IF lc_upg_gl_bud.SEGMENT23_LOW IS NOT NULL THEN
257: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT23_LOW||'-');

Line 257: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT23_LOW||'-');

253: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT22_LOW||'-');
254: END IF;
255:
256: IF lc_upg_gl_bud.SEGMENT23_LOW IS NOT NULL THEN
257: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT23_LOW||'-');
258: END IF;
259:
260: IF lc_upg_gl_bud.SEGMENT24_LOW IS NOT NULL THEN
261: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT24_LOW||'-');

Line 261: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT24_LOW||'-');

257: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT23_LOW||'-');
258: END IF;
259:
260: IF lc_upg_gl_bud.SEGMENT24_LOW IS NOT NULL THEN
261: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT24_LOW||'-');
262: END IF;
263:
264: IF lc_upg_gl_bud.SEGMENT25_LOW IS NOT NULL THEN
265: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT25_LOW||'-');

Line 265: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT25_LOW||'-');

261: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT24_LOW||'-');
262: END IF;
263:
264: IF lc_upg_gl_bud.SEGMENT25_LOW IS NOT NULL THEN
265: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT25_LOW||'-');
266: END IF;
267:
268: IF lc_upg_gl_bud.SEGMENT26_LOW IS NOT NULL THEN
269: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT26_LOW||'-');

Line 269: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT26_LOW||'-');

265: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT25_LOW||'-');
266: END IF;
267:
268: IF lc_upg_gl_bud.SEGMENT26_LOW IS NOT NULL THEN
269: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT26_LOW||'-');
270: END IF;
271:
272: IF lc_upg_gl_bud.SEGMENT27_LOW IS NOT NULL THEN
273: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT27_LOW||'-');

Line 273: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT27_LOW||'-');

269: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT26_LOW||'-');
270: END IF;
271:
272: IF lc_upg_gl_bud.SEGMENT27_LOW IS NOT NULL THEN
273: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT27_LOW||'-');
274: END IF;
275:
276: IF lc_upg_gl_bud.SEGMENT28_LOW IS NOT NULL THEN
277: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT28_LOW||'-');

Line 277: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT28_LOW||'-');

273: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT27_LOW||'-');
274: END IF;
275:
276: IF lc_upg_gl_bud.SEGMENT28_LOW IS NOT NULL THEN
277: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT28_LOW||'-');
278: END IF;
279:
280: IF lc_upg_gl_bud.SEGMENT29_LOW IS NOT NULL THEN
281: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT29_LOW||'-');

Line 281: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT29_LOW||'-');

277: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT28_LOW||'-');
278: END IF;
279:
280: IF lc_upg_gl_bud.SEGMENT29_LOW IS NOT NULL THEN
281: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT29_LOW||'-');
282: END IF;
283:
284: IF lc_upg_gl_bud.SEGMENT30_LOW IS NOT NULL THEN
285: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT30_LOW||'-');

Line 285: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT30_LOW||'-');

281: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT29_LOW||'-');
282: END IF;
283:
284: IF lc_upg_gl_bud.SEGMENT30_LOW IS NOT NULL THEN
285: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT30_LOW||'-');
286: END IF;
287:
288: fnd_file.put(fnd_file.output,' to ');
289:

Line 288: fnd_file.put(fnd_file.output,' to ');

284: IF lc_upg_gl_bud.SEGMENT30_LOW IS NOT NULL THEN
285: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT30_LOW||'-');
286: END IF;
287:
288: fnd_file.put(fnd_file.output,' to ');
289:
290: IF lc_upg_gl_bud.SEGMENT1_HIGH IS NOT NULL THEN
291: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT1_HIGH||'-');
292: END IF;

Line 291: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT1_HIGH||'-');

287:
288: fnd_file.put(fnd_file.output,' to ');
289:
290: IF lc_upg_gl_bud.SEGMENT1_HIGH IS NOT NULL THEN
291: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT1_HIGH||'-');
292: END IF;
293:
294: IF lc_upg_gl_bud.SEGMENT2_HIGH IS NOT NULL THEN
295: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT2_HIGH||'-');

Line 295: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT2_HIGH||'-');

291: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT1_HIGH||'-');
292: END IF;
293:
294: IF lc_upg_gl_bud.SEGMENT2_HIGH IS NOT NULL THEN
295: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT2_HIGH||'-');
296: END IF;
297:
298: IF lc_upg_gl_bud.SEGMENT3_HIGH IS NOT NULL THEN
299: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT3_HIGH||'-');

Line 299: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT3_HIGH||'-');

295: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT2_HIGH||'-');
296: END IF;
297:
298: IF lc_upg_gl_bud.SEGMENT3_HIGH IS NOT NULL THEN
299: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT3_HIGH||'-');
300: END IF;
301:
302: IF lc_upg_gl_bud.SEGMENT4_HIGH IS NOT NULL THEN
303: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT4_HIGH||'-');

Line 303: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT4_HIGH||'-');

299: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT3_HIGH||'-');
300: END IF;
301:
302: IF lc_upg_gl_bud.SEGMENT4_HIGH IS NOT NULL THEN
303: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT4_HIGH||'-');
304: END IF;
305:
306: IF lc_upg_gl_bud.SEGMENT5_HIGH IS NOT NULL THEN
307: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT5_HIGH||'-');

Line 307: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT5_HIGH||'-');

303: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT4_HIGH||'-');
304: END IF;
305:
306: IF lc_upg_gl_bud.SEGMENT5_HIGH IS NOT NULL THEN
307: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT5_HIGH||'-');
308: END IF;
309:
310: IF lc_upg_gl_bud.SEGMENT6_HIGH IS NOT NULL THEN
311: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT6_HIGH||'-');

Line 311: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT6_HIGH||'-');

307: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT5_HIGH||'-');
308: END IF;
309:
310: IF lc_upg_gl_bud.SEGMENT6_HIGH IS NOT NULL THEN
311: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT6_HIGH||'-');
312: END IF;
313:
314: IF lc_upg_gl_bud.SEGMENT7_HIGH IS NOT NULL THEN
315: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT7_HIGH||'-');

Line 315: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT7_HIGH||'-');

311: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT6_HIGH||'-');
312: END IF;
313:
314: IF lc_upg_gl_bud.SEGMENT7_HIGH IS NOT NULL THEN
315: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT7_HIGH||'-');
316: END IF;
317:
318: IF lc_upg_gl_bud.SEGMENT8_HIGH IS NOT NULL THEN
319: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT8_HIGH||'-');

Line 319: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT8_HIGH||'-');

315: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT7_HIGH||'-');
316: END IF;
317:
318: IF lc_upg_gl_bud.SEGMENT8_HIGH IS NOT NULL THEN
319: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT8_HIGH||'-');
320: END IF;
321:
322: IF lc_upg_gl_bud.SEGMENT9_HIGH IS NOT NULL THEN
323: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT9_HIGH||'-');

Line 323: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT9_HIGH||'-');

319: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT8_HIGH||'-');
320: END IF;
321:
322: IF lc_upg_gl_bud.SEGMENT9_HIGH IS NOT NULL THEN
323: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT9_HIGH||'-');
324: END IF;
325:
326: IF lc_upg_gl_bud.SEGMENT10_HIGH IS NOT NULL THEN
327: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT10_HIGH||'-');

Line 327: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT10_HIGH||'-');

323: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT9_HIGH||'-');
324: END IF;
325:
326: IF lc_upg_gl_bud.SEGMENT10_HIGH IS NOT NULL THEN
327: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT10_HIGH||'-');
328: END IF;
329:
330: IF lc_upg_gl_bud.SEGMENT11_HIGH IS NOT NULL THEN
331: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT11_HIGH||'-');

Line 331: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT11_HIGH||'-');

327: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT10_HIGH||'-');
328: END IF;
329:
330: IF lc_upg_gl_bud.SEGMENT11_HIGH IS NOT NULL THEN
331: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT11_HIGH||'-');
332: END IF;
333:
334: IF lc_upg_gl_bud.SEGMENT12_HIGH IS NOT NULL THEN
335: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT12_HIGH||'-');

Line 335: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT12_HIGH||'-');

331: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT11_HIGH||'-');
332: END IF;
333:
334: IF lc_upg_gl_bud.SEGMENT12_HIGH IS NOT NULL THEN
335: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT12_HIGH||'-');
336: END IF;
337:
338: IF lc_upg_gl_bud.SEGMENT13_HIGH IS NOT NULL THEN
339: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT13_HIGH||'-');

Line 339: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT13_HIGH||'-');

335: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT12_HIGH||'-');
336: END IF;
337:
338: IF lc_upg_gl_bud.SEGMENT13_HIGH IS NOT NULL THEN
339: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT13_HIGH||'-');
340: END IF;
341:
342: IF lc_upg_gl_bud.SEGMENT14_HIGH IS NOT NULL THEN
343: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT14_HIGH||'-');

Line 343: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT14_HIGH||'-');

339: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT13_HIGH||'-');
340: END IF;
341:
342: IF lc_upg_gl_bud.SEGMENT14_HIGH IS NOT NULL THEN
343: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT14_HIGH||'-');
344: END IF;
345:
346: IF lc_upg_gl_bud.SEGMENT15_HIGH IS NOT NULL THEN
347: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT15_HIGH||'-');

Line 347: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT15_HIGH||'-');

343: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT14_HIGH||'-');
344: END IF;
345:
346: IF lc_upg_gl_bud.SEGMENT15_HIGH IS NOT NULL THEN
347: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT15_HIGH||'-');
348: END IF;
349:
350: IF lc_upg_gl_bud.SEGMENT16_HIGH IS NOT NULL THEN
351: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT16_HIGH||'-');

Line 351: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT16_HIGH||'-');

347: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT15_HIGH||'-');
348: END IF;
349:
350: IF lc_upg_gl_bud.SEGMENT16_HIGH IS NOT NULL THEN
351: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT16_HIGH||'-');
352: END IF;
353:
354: IF lc_upg_gl_bud.SEGMENT17_HIGH IS NOT NULL THEN
355: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT17_HIGH||'-');

Line 355: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT17_HIGH||'-');

351: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT16_HIGH||'-');
352: END IF;
353:
354: IF lc_upg_gl_bud.SEGMENT17_HIGH IS NOT NULL THEN
355: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT17_HIGH||'-');
356: END IF;
357:
358: IF lc_upg_gl_bud.SEGMENT18_HIGH IS NOT NULL THEN
359: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT18_HIGH||'-');

Line 359: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT18_HIGH||'-');

355: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT17_HIGH||'-');
356: END IF;
357:
358: IF lc_upg_gl_bud.SEGMENT18_HIGH IS NOT NULL THEN
359: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT18_HIGH||'-');
360: END IF;
361: IF lc_upg_gl_bud.SEGMENT19_HIGH IS NOT NULL THEN
362: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT19_HIGH||'-');
363: END IF;

Line 362: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT19_HIGH||'-');

358: IF lc_upg_gl_bud.SEGMENT18_HIGH IS NOT NULL THEN
359: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT18_HIGH||'-');
360: END IF;
361: IF lc_upg_gl_bud.SEGMENT19_HIGH IS NOT NULL THEN
362: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT19_HIGH||'-');
363: END IF;
364:
365: IF lc_upg_gl_bud.SEGMENT20_HIGH IS NOT NULL THEN
366: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT20_HIGH||'-');

Line 366: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT20_HIGH||'-');

362: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT19_HIGH||'-');
363: END IF;
364:
365: IF lc_upg_gl_bud.SEGMENT20_HIGH IS NOT NULL THEN
366: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT20_HIGH||'-');
367: END IF;
368:
369: IF lc_upg_gl_bud.SEGMENT21_HIGH IS NOT NULL THEN
370: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT21_HIGH||'-');

Line 370: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT21_HIGH||'-');

366: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT20_HIGH||'-');
367: END IF;
368:
369: IF lc_upg_gl_bud.SEGMENT21_HIGH IS NOT NULL THEN
370: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT21_HIGH||'-');
371: END IF;
372:
373: IF lc_upg_gl_bud.SEGMENT22_HIGH IS NOT NULL THEN
374: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT22_HIGH||'-');

Line 374: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT22_HIGH||'-');

370: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT21_HIGH||'-');
371: END IF;
372:
373: IF lc_upg_gl_bud.SEGMENT22_HIGH IS NOT NULL THEN
374: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT22_HIGH||'-');
375: END IF;
376:
377: IF lc_upg_gl_bud.SEGMENT23_HIGH IS NOT NULL THEN
378: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT23_HIGH||'-');

Line 378: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT23_HIGH||'-');

374: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT22_HIGH||'-');
375: END IF;
376:
377: IF lc_upg_gl_bud.SEGMENT23_HIGH IS NOT NULL THEN
378: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT23_HIGH||'-');
379: END IF;
380:
381: IF lc_upg_gl_bud.SEGMENT24_HIGH IS NOT NULL THEN
382: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT24_HIGH||'-');

Line 382: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT24_HIGH||'-');

378: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT23_HIGH||'-');
379: END IF;
380:
381: IF lc_upg_gl_bud.SEGMENT24_HIGH IS NOT NULL THEN
382: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT24_HIGH||'-');
383: END IF;
384:
385: IF lc_upg_gl_bud.SEGMENT25_HIGH IS NOT NULL THEN
386: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT25_HIGH||'-');

Line 386: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT25_HIGH||'-');

382: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT24_HIGH||'-');
383: END IF;
384:
385: IF lc_upg_gl_bud.SEGMENT25_HIGH IS NOT NULL THEN
386: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT25_HIGH||'-');
387: END IF;
388:
389: IF lc_upg_gl_bud.SEGMENT26_HIGH IS NOT NULL THEN
390: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT26_HIGH||'-');

Line 390: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT26_HIGH||'-');

386: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT25_HIGH||'-');
387: END IF;
388:
389: IF lc_upg_gl_bud.SEGMENT26_HIGH IS NOT NULL THEN
390: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT26_HIGH||'-');
391: END IF;
392:
393: IF lc_upg_gl_bud.SEGMENT27_HIGH IS NOT NULL THEN
394: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT27_HIGH||'-');

Line 394: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT27_HIGH||'-');

390: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT26_HIGH||'-');
391: END IF;
392:
393: IF lc_upg_gl_bud.SEGMENT27_HIGH IS NOT NULL THEN
394: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT27_HIGH||'-');
395: END IF;
396:
397: IF lc_upg_gl_bud.SEGMENT28_HIGH IS NOT NULL THEN
398: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT28_HIGH||'-');

Line 398: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT28_HIGH||'-');

394: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT27_HIGH||'-');
395: END IF;
396:
397: IF lc_upg_gl_bud.SEGMENT28_HIGH IS NOT NULL THEN
398: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT28_HIGH||'-');
399: END IF;
400:
401: IF lc_upg_gl_bud.SEGMENT29_HIGH IS NOT NULL THEN
402: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT29_HIGH||'-');

Line 402: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT29_HIGH||'-');

398: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT28_HIGH||'-');
399: END IF;
400:
401: IF lc_upg_gl_bud.SEGMENT29_HIGH IS NOT NULL THEN
402: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT29_HIGH||'-');
403: END IF;
404:
405: IF lc_upg_gl_bud.SEGMENT30_HIGH IS NOT NULL THEN
406: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT30_HIGH||'-');

Line 406: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT30_HIGH||'-');

402: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT29_HIGH||'-');
403: END IF;
404:
405: IF lc_upg_gl_bud.SEGMENT30_HIGH IS NOT NULL THEN
406: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT30_HIGH||'-');
407: END IF;
408:
409: fnd_file.put_line(fnd_file.output,' ');
410:

Line 409: fnd_file.put_line(fnd_file.output,' ');

405: IF lc_upg_gl_bud.SEGMENT30_HIGH IS NOT NULL THEN
406: fnd_file.put(fnd_file.output,lc_upg_gl_bud.SEGMENT30_HIGH||'-');
407: END IF;
408:
409: fnd_file.put_line(fnd_file.output,' ');
410:
411: fnd_file.put(fnd_file.output,'Associated Budgets are ');
412:
413: OPEN C_BC_OPTIONS(p_range_id);

Line 411: fnd_file.put(fnd_file.output,'Associated Budgets are ');

407: END IF;
408:
409: fnd_file.put_line(fnd_file.output,' ');
410:
411: fnd_file.put(fnd_file.output,'Associated Budgets are ');
412:
413: OPEN C_BC_OPTIONS(p_range_id);
414: FETCH C_BC_OPTIONS BULK COLLECT INTO lc_bc_options;
415: CLOSE C_BC_OPTIONS;

Line 418: fnd_file.put(fnd_file.output,lc_bc_options(i).budget_name||', ');

414: FETCH C_BC_OPTIONS BULK COLLECT INTO lc_bc_options;
415: CLOSE C_BC_OPTIONS;
416:
417: FOR i IN 1..lc_bc_options.COUNT LOOP
418: fnd_file.put(fnd_file.output,lc_bc_options(i).budget_name||', ');
419: END LOOP;
420:
421: fnd_file.put_line(fnd_file.output,' ');
422:

Line 421: fnd_file.put_line(fnd_file.output,' ');

417: FOR i IN 1..lc_bc_options.COUNT LOOP
418: fnd_file.put(fnd_file.output,lc_bc_options(i).budget_name||', ');
419: END LOOP;
420:
421: fnd_file.put_line(fnd_file.output,' ');
422:
423: EXCEPTION
424: WHEN OTHERS THEN
425: fnd_file.put_line(fnd_file.output, 'Module: PRINT_BUDGET_INFO => '||SQLERRM);

Line 425: fnd_file.put_line(fnd_file.output, 'Module: PRINT_BUDGET_INFO => '||SQLERRM);

421: fnd_file.put_line(fnd_file.output,' ');
422:
423: EXCEPTION
424: WHEN OTHERS THEN
425: fnd_file.put_line(fnd_file.output, 'Module: PRINT_BUDGET_INFO => '||SQLERRM);
426: errbuf := 'Module: PRINT_BUDGET_INFO => '||SQLERRM;
427: retcode := -1;
428: RETURN;
429: END;

Line 622: fnd_file.put_line(fnd_file.log, 'l_segment1.segment_low = '||l_segment1.segment_low);

618: l_segment2 := p_segment1;
619: END IF;
620:
621: IF g_debug_enabled = 1 THEN
622: fnd_file.put_line(fnd_file.log, 'l_segment1.segment_low = '||l_segment1.segment_low);
623: fnd_file.put_line(fnd_file.log, 'l_segment1.segment_high = '||l_segment1.segment_high);
624: fnd_file.put_line(fnd_file.log, 'l_segment2.segment_low = '||l_segment2.segment_low);
625: fnd_file.put_line(fnd_file.log, 'l_segment2.segment_high = '||l_segment2.segment_high);
626: END IF;

Line 623: fnd_file.put_line(fnd_file.log, 'l_segment1.segment_high = '||l_segment1.segment_high);

619: END IF;
620:
621: IF g_debug_enabled = 1 THEN
622: fnd_file.put_line(fnd_file.log, 'l_segment1.segment_low = '||l_segment1.segment_low);
623: fnd_file.put_line(fnd_file.log, 'l_segment1.segment_high = '||l_segment1.segment_high);
624: fnd_file.put_line(fnd_file.log, 'l_segment2.segment_low = '||l_segment2.segment_low);
625: fnd_file.put_line(fnd_file.log, 'l_segment2.segment_high = '||l_segment2.segment_high);
626: END IF;
627:

Line 624: fnd_file.put_line(fnd_file.log, 'l_segment2.segment_low = '||l_segment2.segment_low);

620:
621: IF g_debug_enabled = 1 THEN
622: fnd_file.put_line(fnd_file.log, 'l_segment1.segment_low = '||l_segment1.segment_low);
623: fnd_file.put_line(fnd_file.log, 'l_segment1.segment_high = '||l_segment1.segment_high);
624: fnd_file.put_line(fnd_file.log, 'l_segment2.segment_low = '||l_segment2.segment_low);
625: fnd_file.put_line(fnd_file.log, 'l_segment2.segment_high = '||l_segment2.segment_high);
626: END IF;
627:
628: -- Corresponding segments should be compared. If wrong segment numbers are

Line 625: fnd_file.put_line(fnd_file.log, 'l_segment2.segment_high = '||l_segment2.segment_high);

621: IF g_debug_enabled = 1 THEN
622: fnd_file.put_line(fnd_file.log, 'l_segment1.segment_low = '||l_segment1.segment_low);
623: fnd_file.put_line(fnd_file.log, 'l_segment1.segment_high = '||l_segment1.segment_high);
624: fnd_file.put_line(fnd_file.log, 'l_segment2.segment_low = '||l_segment2.segment_low);
625: fnd_file.put_line(fnd_file.log, 'l_segment2.segment_high = '||l_segment2.segment_high);
626: END IF;
627:
628: -- Corresponding segments should be compared. If wrong segment numbers are
629: -- exit with error

Line 632: fnd_file.put_line(fnd_file.log, 'Module: SPLIT_RANGES '||'Splitting failed as segment_numbers do not match');

628: -- Corresponding segments should be compared. If wrong segment numbers are
629: -- exit with error
630: IF l_segment1.segment_number <> l_segment2.segment_number THEN
631:
632: fnd_file.put_line(fnd_file.log, 'Module: SPLIT_RANGES '||'Splitting failed as segment_numbers do not match');
633: errbuf := 'Module: SPLIT_RANGES '||'Splitting failed as segment_numbers do not match';
634: retcode := -1;
635: RETURN;
636: END IF;

Line 650: fnd_file.put_line(fnd_file.log, 'Module: SPLIT_RANGES '||'Null value retured ');

646: p_segment_tab(p_segment_tab.COUNT).segment_low := l_segment2.segment_low;
647: p_segment_tab(p_segment_tab.COUNT).segment_high := PREVIOUS_VALUE(l_segment1.segment_low,l_segment1.data_type);
648:
649: IF p_segment_tab(p_segment_tab.COUNT).segment_high IS NULL THEN
650: fnd_file.put_line(fnd_file.log, 'Module: SPLIT_RANGES '||'Null value retured ');
651: errbuf := 'Module: SPLIT_RANGES '||'Null value retured for PREVIOUS_VALUE(l_segment1.segment_low,l_segment1.data_type);';
652: retcode := -1;
653: RETURN;
654: END IF;

Line 672: fnd_file.put_line(fnd_file.log, 'Module: SPLIT_RANGES '||'Null value retured ');

668: p_segment_tab(p_segment_tab.COUNT).budget_tab := BUDGET_TYPE();
669: p_segment_tab(p_segment_tab.COUNT).budget_tab := MERGE_BUDGETS(l_segment1.budget_tab,l_segment2.budget_tab);
670:
671: IF p_segment_tab(p_segment_tab.COUNT).budget_tab IS NULL THEN
672: fnd_file.put_line(fnd_file.log, 'Module: SPLIT_RANGES '||'Null value retured ');
673: errbuf := 'Module: SPLIT_RANGES '||'Null value retured for p_segment_tab(p_segment_tab.COUNT).budget_tab';
674: retcode := -1;
675: RETURN;
676: END IF;

Line 685: fnd_file.put_line(fnd_file.log, 'Module: SPLIT_RANGES '||'Null value retured ');

681: p_segment_tab(p_segment_tab.COUNT).segment_number := l_segment1.segment_number;
682: p_segment_tab(p_segment_tab.COUNT).segment_low := NEXT_VALUE(l_segment2.segment_high,l_segment2.data_type);
683:
684: IF p_segment_tab(p_segment_tab.COUNT).segment_low IS NULL THEN
685: fnd_file.put_line(fnd_file.log, 'Module: SPLIT_RANGES '||'Null value retured ');
686: errbuf := 'Module: SPLIT_RANGES '||'Null value retured for NEXT_VALUE(l_segment2.segment_high,l_segment2.data_type);';
687: retcode := -1;
688: RETURN;
689: END IF;

Line 707: fnd_file.put_line(fnd_file.log, 'Module: SPLIT_RANGES '||'Null value retured ');

703: p_segment_tab(p_segment_tab.COUNT).budget_tab := BUDGET_TYPE();
704: p_segment_tab(p_segment_tab.COUNT).budget_tab := MERGE_BUDGETS(l_segment1.budget_tab,l_segment2.budget_tab);
705:
706: IF p_segment_tab(p_segment_tab.COUNT).budget_tab IS NULL THEN
707: fnd_file.put_line(fnd_file.log, 'Module: SPLIT_RANGES '||'Null value retured ');
708: errbuf := 'Module: SPLIT_RANGES '||'Null value retured for p_segment_tab(p_segment_tab.COUNT).budget_tab';
709: retcode := -1;
710: RETURN;
711: END IF;

Line 719: fnd_file.put_line(fnd_file.log, 'Module: SPLIT_RANGES '||'Null value retured ');

715: p_segment_tab(p_segment_tab.COUNT).segment_number := l_segment1.segment_number;
716: p_segment_tab(p_segment_tab.COUNT).segment_low := NEXT_VALUE(l_segment1.segment_high,l_segment1.data_type);
717:
718: IF p_segment_tab(p_segment_tab.COUNT).segment_low IS NULL THEN
719: fnd_file.put_line(fnd_file.log, 'Module: SPLIT_RANGES '||'Null value retured ');
720: errbuf := 'Module: SPLIT_RANGES '||'Null value retured for NEXT_VALUE(l_segment2.segment_high,l_segment2.data_type);';
721: retcode := -1;
722: RETURN;
723: END IF;

Line 737: fnd_file.put_line(fnd_file.log, 'Module: SPLIT_RANGES '||'Splitting failed '||SQLERRM);

733: END IF;
734:
735: EXCEPTION
736: WHEN OTHERS THEN
737: fnd_file.put_line(fnd_file.log, 'Module: SPLIT_RANGES '||'Splitting failed '||SQLERRM);
738: errbuf := 'Module: SPLIT_RANGES '||'Splitting failed '||SQLERRM;
739: retcode := -1;
740: RETURN;
741: END;

Line 828: fnd_file.put_line(fnd_file.log, 'Module: RECURSIVE_MERGE '||'p_no_of_segments < p_current_segment_index');

824: l_errbuf VARCHAR2(2000);
825: l_retcode NUMBER;
826: BEGIN
827: IF p_no_of_segments < p_current_segment_index THEN
828: fnd_file.put_line(fnd_file.log, 'Module: RECURSIVE_MERGE '||'p_no_of_segments < p_current_segment_index');
829: errbuf := 'Module: RECURSIVE_MERGE '||'p_no_of_segments < p_current_segment_index';
830: retcode := -1;
831: RETURN;
832: END IF;

Line 1035: fnd_file.put_line(fnd_file.log, 'p_budget_range1.range_id is NULL');

1031: l_errbuf VARCHAR2(2000);
1032: l_retcode VARCHAR2(2000);
1033: BEGIN
1034: IF p_budget_range1.range_id IS NULL THEN
1035: fnd_file.put_line(fnd_file.log, 'p_budget_range1.range_id is NULL');
1036: errbuf := 'p_budget_range1.range_id is NULL';
1037: retcode := -1;
1038: RETURN;
1039: END IF;

Line 1063: fnd_file.put(fnd_file.log, '-'||p_final_budget_ranges(i).segment_range_tab(k).segment_low);

1059: FOR i IN 1..p_final_budget_ranges.COUNT LOOP
1060:
1061: FOR k IN 1..p_final_budget_ranges(i).segment_range_tab.COUNT LOOP
1062: IF p_final_budget_ranges(i).segment_range_tab(k).segment_low IS NOT NULL THEN
1063: fnd_file.put(fnd_file.log, '-'||p_final_budget_ranges(i).segment_range_tab(k).segment_low);
1064: END IF;
1065: END LOOP;
1066: fnd_file.put(fnd_file.log, ' to ');
1067:

Line 1066: fnd_file.put(fnd_file.log, ' to ');

1062: IF p_final_budget_ranges(i).segment_range_tab(k).segment_low IS NOT NULL THEN
1063: fnd_file.put(fnd_file.log, '-'||p_final_budget_ranges(i).segment_range_tab(k).segment_low);
1064: END IF;
1065: END LOOP;
1066: fnd_file.put(fnd_file.log, ' to ');
1067:
1068: FOR k IN 1..p_final_budget_ranges(i).segment_range_tab.COUNT LOOP
1069: IF p_final_budget_ranges(i).segment_range_tab(k).segment_high IS NOT NULL THEN
1070: fnd_file.put(fnd_file.log, '-'||p_final_budget_ranges(i).segment_range_tab(k).segment_high);

Line 1070: fnd_file.put(fnd_file.log, '-'||p_final_budget_ranges(i).segment_range_tab(k).segment_high);

1066: fnd_file.put(fnd_file.log, ' to ');
1067:
1068: FOR k IN 1..p_final_budget_ranges(i).segment_range_tab.COUNT LOOP
1069: IF p_final_budget_ranges(i).segment_range_tab(k).segment_high IS NOT NULL THEN
1070: fnd_file.put(fnd_file.log, '-'||p_final_budget_ranges(i).segment_range_tab(k).segment_high);
1071: END IF;
1072: END LOOP;
1073:
1074: FOR j IN 1..p_final_budget_ranges(i).budget_tab.COUNT LOOP

Line 1075: fnd_file.put(fnd_file.log, ' '||p_final_budget_ranges(i).budget_tab(j));

1071: END IF;
1072: END LOOP;
1073:
1074: FOR j IN 1..p_final_budget_ranges(i).budget_tab.COUNT LOOP
1075: fnd_file.put(fnd_file.log, ' '||p_final_budget_ranges(i).budget_tab(j));
1076: END LOOP;
1077: fnd_file.put_line(fnd_file.log, '');
1078: END LOOP;
1079: END PRINT_MERGE_INFO;

Line 1077: fnd_file.put_line(fnd_file.log, '');

1073:
1074: FOR j IN 1..p_final_budget_ranges(i).budget_tab.COUNT LOOP
1075: fnd_file.put(fnd_file.log, ' '||p_final_budget_ranges(i).budget_tab(j));
1076: END LOOP;
1077: fnd_file.put_line(fnd_file.log, '');
1078: END LOOP;
1079: END PRINT_MERGE_INFO;
1080:
1081:

Line 1088: fnd_file.put(fnd_file.log, p_segment_tab(i).segment_low||' to '||p_segment_tab(i).segment_high||' ');

1084: PROCEDURE PRINT_SPLIT_INFO (p_segment_tab segment_type)
1085: IS
1086: BEGIN
1087: FOR i IN 1..p_segment_tab.COUNT LOOP
1088: fnd_file.put(fnd_file.log, p_segment_tab(i).segment_low||' to '||p_segment_tab(i).segment_high||' ');
1089: FOR j IN 1..p_segment_tab(i).budget_tab.COUNT LOOP
1090: fnd_file.put(fnd_file.log,p_segment_tab(i).budget_tab(j));
1091: fnd_file.put(fnd_file.log,'');
1092: END LOOP;

Line 1090: fnd_file.put(fnd_file.log,p_segment_tab(i).budget_tab(j));

1086: BEGIN
1087: FOR i IN 1..p_segment_tab.COUNT LOOP
1088: fnd_file.put(fnd_file.log, p_segment_tab(i).segment_low||' to '||p_segment_tab(i).segment_high||' ');
1089: FOR j IN 1..p_segment_tab(i).budget_tab.COUNT LOOP
1090: fnd_file.put(fnd_file.log,p_segment_tab(i).budget_tab(j));
1091: fnd_file.put(fnd_file.log,'');
1092: END LOOP;
1093: fnd_file.put_line(fnd_file.log,'');
1094: END LOOP;

Line 1091: fnd_file.put(fnd_file.log,'');

1087: FOR i IN 1..p_segment_tab.COUNT LOOP
1088: fnd_file.put(fnd_file.log, p_segment_tab(i).segment_low||' to '||p_segment_tab(i).segment_high||' ');
1089: FOR j IN 1..p_segment_tab(i).budget_tab.COUNT LOOP
1090: fnd_file.put(fnd_file.log,p_segment_tab(i).budget_tab(j));
1091: fnd_file.put(fnd_file.log,'');
1092: END LOOP;
1093: fnd_file.put_line(fnd_file.log,'');
1094: END LOOP;
1095:

Line 1093: fnd_file.put_line(fnd_file.log,'');

1089: FOR j IN 1..p_segment_tab(i).budget_tab.COUNT LOOP
1090: fnd_file.put(fnd_file.log,p_segment_tab(i).budget_tab(j));
1091: fnd_file.put(fnd_file.log,'');
1092: END LOOP;
1093: fnd_file.put_line(fnd_file.log,'');
1094: END LOOP;
1095:
1096: END PRINT_SPLIT_INFO;
1097:

Line 1102: fnd_file.put_line(fnd_file.log,'Module:'||p_module||' => '||p_log_message);

1098:
1099: PROCEDURE DEBUG_LOG (p_log_message VARCHAR2, p_module VARCHAR2)
1100: IS
1101: BEGIN
1102: fnd_file.put_line(fnd_file.log,'Module:'||p_module||' => '||p_log_message);
1103: END;
1104:
1105:
1106: PROCEDURE PRINT_OUTPUT (p_output_message VARCHAR2)

Line 1109: fnd_file.put_line(fnd_file.log,p_output_message);

1105:
1106: PROCEDURE PRINT_OUTPUT (p_output_message VARCHAR2)
1107: IS
1108: BEGIN
1109: fnd_file.put_line(fnd_file.log,p_output_message);
1110: END;
1111:
1112:
1113: -- PROCEDURE LOOP_AND_PROCESS does the main processing logic

Line 1439: fnd_file.put_line(fnd_file.output,'Ledger - Budget Organization - Currency - Range From - Range To ');

1435:
1436: BEGIN
1437:
1438: l_data_type := p_data_type;
1439: fnd_file.put_line(fnd_file.output,'Ledger - Budget Organization - Currency - Range From - Range To ');
1440: BEGIN
1441: SELECT gl_budget_assignment_ranges_s.NEXTVAL
1442: INTO l_range_id_seq
1443: FROM dual;

Line 1447: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');

1443: FROM dual;
1444: l_range_id_seq := l_range_id_seq + 1;
1445: EXCEPTION
1446: WHEN OTHERS THEN
1447: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1448: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error fetching sequence value
1449: from gl_budget_assignment_ranges_s');
1450: errbuf := 'Module: LOOP_AND_PROCESS => Error fetching sequence value from gl_budget_assignment_ranges_s';
1451: retcode := -1;

Line 1448: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error fetching sequence value

1444: l_range_id_seq := l_range_id_seq + 1;
1445: EXCEPTION
1446: WHEN OTHERS THEN
1447: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1448: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error fetching sequence value
1449: from gl_budget_assignment_ranges_s');
1450: errbuf := 'Module: LOOP_AND_PROCESS => Error fetching sequence value from gl_budget_assignment_ranges_s';
1451: retcode := -1;
1452: RETURN;

Line 1479: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');

1475: INTO l_actual_range_id
1476: FROM dual;
1477: EXCEPTION
1478: WHEN OTHERS THEN
1479: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1480: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS (overlap) =>'
1481: ||'Error fetching sequence value from gl_budget_assignment_ranges_s');
1482: errbuf := 'Module: LOOP_AND_PROCESS (overlap) => Error fetching sequence value from gl_budget_assignment_ranges_s';
1483: retcode := -1;

Line 1480: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS (overlap) =>'

1476: FROM dual;
1477: EXCEPTION
1478: WHEN OTHERS THEN
1479: fnd_file.put_line(fnd_file.output, 'Error fetching sequence value from gl_budget_assignment_ranges_s');
1480: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS (overlap) =>'
1481: ||'Error fetching sequence value from gl_budget_assignment_ranges_s');
1482: errbuf := 'Module: LOOP_AND_PROCESS (overlap) => Error fetching sequence value from gl_budget_assignment_ranges_s';
1483: retcode := -1;
1484: RETURN;

Line 1749: fnd_file.put_line(fnd_file.output, 'Error processing demerged data');

1745:
1746:
1747: EXCEPTION
1748: WHEN OTHERS THEN
1749: fnd_file.put_line(fnd_file.output, 'Error processing demerged data');
1750: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error processing demerged data =>'||SQLERRM);
1751: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error processing demerged data =>'||SQLERRM;
1752: retcode := -1;
1753: RETURN;

Line 1750: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error processing demerged data =>'||SQLERRM);

1746:
1747: EXCEPTION
1748: WHEN OTHERS THEN
1749: fnd_file.put_line(fnd_file.output, 'Error processing demerged data');
1750: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error processing demerged data =>'||SQLERRM);
1751: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error processing demerged data =>'||SQLERRM;
1752: retcode := -1;
1753: RETURN;
1754: END;

Line 1773: fnd_file.put_line(fnd_file.output, 'Error processing demerged data - prelim mode');

1769:
1770: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1771: EXCEPTION
1772: WHEN OTHERS THEN
1773: fnd_file.put_line(fnd_file.output, 'Error processing demerged data - prelim mode');
1774: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
1775: ||'Error processing demerged data - prelim mode =>'||SQLERRM);
1776: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error processing demerged data - prelim mode =>'||SQLERRM;
1777: retcode := -1;

Line 1774: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'

1770: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_non_overlapping_ranges(i).range_id;
1771: EXCEPTION
1772: WHEN OTHERS THEN
1773: fnd_file.put_line(fnd_file.output, 'Error processing demerged data - prelim mode');
1774: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
1775: ||'Error processing demerged data - prelim mode =>'||SQLERRM);
1776: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error processing demerged data - prelim mode =>'||SQLERRM;
1777: retcode := -1;
1778: RETURN;

Line 1793: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS => Processing completed');

1789: OPEN C_ALL_RANGES;
1790: FETCH C_ALL_RANGES INTO lc_exact_merge_range1;
1791: IF C_ALL_RANGES%NOTFOUND THEN
1792: CLOSE C_ALL_RANGES;
1793: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS => Processing completed');
1794: EXIT;
1795: END IF;
1796: CLOSE C_ALL_RANGES;
1797:

Line 1824: fnd_file.put_line(fnd_file.output, 'Error merging data which overlaps exactly');

1820: DELETE FROM IGI_UPG_GL_BUDGET_ASSIGNMENT WHERE RANGE_ID = lc_exact_merge_range2.range_id;
1821:
1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: fnd_file.put_line(fnd_file.output, 'Error merging data which overlaps exactly');
1825: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
1826: ||'Error merging data which overlaps exactly =>'||SQLERRM);
1827: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error merging data which overlaps exactly =>'||SQLERRM;
1828: retcode := -1;

Line 1825: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'

1821:
1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: fnd_file.put_line(fnd_file.output, 'Error merging data which overlaps exactly');
1825: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
1826: ||'Error merging data which overlaps exactly =>'||SQLERRM);
1827: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error merging data which overlaps exactly =>'||SQLERRM;
1828: retcode := -1;
1829: RETURN;

Line 1844: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS => Processing completed');

1840: OPEN C_ALL_RANGES;
1841: FETCH C_ALL_RANGES INTO lc_merge_range1;
1842: IF C_ALL_RANGES%NOTFOUND THEN
1843: CLOSE C_ALL_RANGES;
1844: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS => Processing completed');
1845: EXIT;
1846: END IF;
1847: IF C_ALL_RANGES%FOUND AND l_data_type <> 0 THEN
1848: CLOSE C_ALL_RANGES;

Line 1849: fnd_file.put_line(fnd_file.output, 'Module: LOOP_AND_PROCESS - You have segment ranges which merge with other segment ranges

1845: EXIT;
1846: END IF;
1847: IF C_ALL_RANGES%FOUND AND l_data_type <> 0 THEN
1848: CLOSE C_ALL_RANGES;
1849: fnd_file.put_line(fnd_file.output, 'Module: LOOP_AND_PROCESS - You have segment ranges which merge with other segment ranges
1850: for the same ledger and currency. This upgrade script does
1851: not support merging segment ranges for segments which have variable
1852: non numeric values. Merging segment ranges are supported only if your
1853: segment contains fixed length numeric values. Please contact Oracle Support for help');

Line 1854: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS - You have segment ranges which merge with other segment ranges

1850: for the same ledger and currency. This upgrade script does
1851: not support merging segment ranges for segments which have variable
1852: non numeric values. Merging segment ranges are supported only if your
1853: segment contains fixed length numeric values. Please contact Oracle Support for help');
1854: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS - You have segment ranges which merge with other segment ranges
1855: for the same ledger and currency code. This upgrade script does
1856: not support merging segment ranges for segments which have variable
1857: non numeric values. Merging segment ranges are supported only if your
1858: segment contains fixed length numeric values. Please contact Oracle Support for help');

Line 2488: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1');

2484: lc_merge_range2.attribute15
2485: );
2486: EXCEPTION
2487: WHEN OTHERS THEN
2488: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1');
2489: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2490: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM);
2491: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM;
2492: retcode := -1;

Line 2489: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'

2485: );
2486: EXCEPTION
2487: WHEN OTHERS THEN
2488: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1');
2489: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2490: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM);
2491: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 1 '||SQLERRM;
2492: retcode := -1;
2493: RETURN;

Line 2532: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1');

2528: sysdate
2529: );
2530: EXCEPTION
2531: WHEN OTHERS THEN
2532: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1');
2533: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2534: ||'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM);
2535: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2536: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM;

Line 2533: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'

2529: );
2530: EXCEPTION
2531: WHEN OTHERS THEN
2532: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1');
2533: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2534: ||'Error inserting records into IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM);
2535: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2536: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 1 '||SQLERRM;
2537: retcode := -1;

Line 2545: fnd_file.put_line(fnd_file.output, 'Insertion failed - Reason not explicit in merge 1');

2541: EXIT;
2542: END IF;
2543: END LOOP;
2544: IF NOT l_inserted THEN
2545: fnd_file.put_line(fnd_file.output, 'Insertion failed - Reason not explicit in merge 1');
2546: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Insertion failed - Reason not explicit in merge 1');
2547: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Insertion failed - Reason not explicit in merge 1';
2548: retcode := -1;
2549: RETURN;

Line 2546: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Insertion failed - Reason not explicit in merge 1');

2542: END IF;
2543: END LOOP;
2544: IF NOT l_inserted THEN
2545: fnd_file.put_line(fnd_file.output, 'Insertion failed - Reason not explicit in merge 1');
2546: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Insertion failed - Reason not explicit in merge 1');
2547: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Insertion failed - Reason not explicit in merge 1';
2548: retcode := -1;
2549: RETURN;
2550: END IF;

Line 2804: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2');

2800: );
2801:
2802: EXCEPTION
2803: WHEN OTHERS THEN
2804: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2');
2805: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2806: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM);
2807: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2808: IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM;

Line 2805: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'

2801:
2802: EXCEPTION
2803: WHEN OTHERS THEN
2804: fnd_file.put_line(fnd_file.output, 'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2');
2805: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'
2806: ||'Error inserting records into IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM);
2807: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2808: IGI_UPG_GL_BUDGET_ASSIGNMENT Location 2 '||SQLERRM;
2809: retcode := -1;

Line 2855: fnd_file.put_line(fnd_file.output, 'Error inserting records into

2851: sysdate
2852: );
2853: EXCEPTION
2854: WHEN OTHERS THEN
2855: fnd_file.put_line(fnd_file.output, 'Error inserting records into
2856: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2');
2857: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2858: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2 '||SQLERRM);
2859: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into

Line 2857: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into

2853: EXCEPTION
2854: WHEN OTHERS THEN
2855: fnd_file.put_line(fnd_file.output, 'Error inserting records into
2856: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2');
2857: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2858: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2 '||SQLERRM);
2859: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2860: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 2 '||SQLERRM;
2861: retcode := -1;

Line 2901: fnd_file.put_line(fnd_file.output, 'Error inserting records into

2897: sysdate
2898: );
2899: EXCEPTION
2900: WHEN OTHERS THEN
2901: fnd_file.put_line(fnd_file.output, 'Error inserting records into
2902: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4');
2903: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2904: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4 '||SQLERRM);
2905: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into

Line 2903: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into

2899: EXCEPTION
2900: WHEN OTHERS THEN
2901: fnd_file.put_line(fnd_file.output, 'Error inserting records into
2902: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4');
2903: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2904: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4 '||SQLERRM);
2905: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error inserting records into
2906: IGI_UPG_GL_BUDORG_BC_OPTIONS Location 4 '||SQLERRM;
2907: retcode := -1;

Line 2917: fnd_file.put_line(fnd_file.output, 'Insertion failed - Reason not explicit');

2913: END LOOP;
2914: END IF;
2915:
2916: IF NOT l_inserted THEN
2917: fnd_file.put_line(fnd_file.output, 'Insertion failed - Reason not explicit');
2918: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Insertion failed - Reason not explicit');
2919: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Insertion failed - Reason not explicit';
2920: retcode := -1;
2921: RETURN;

Line 2918: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Insertion failed - Reason not explicit');

2914: END IF;
2915:
2916: IF NOT l_inserted THEN
2917: fnd_file.put_line(fnd_file.output, 'Insertion failed - Reason not explicit');
2918: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Insertion failed - Reason not explicit');
2919: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Insertion failed - Reason not explicit';
2920: retcode := -1;
2921: RETURN;
2922: END IF;

Line 2942: fnd_file.put_line(fnd_file.output, 'Error deleting data');

2938: range_id = lc_merge_range2.range_id OR
2939: range_id = lc_merge_range1.range_id;
2940: EXCEPTION
2941: WHEN OTHERS THEN
2942: fnd_file.put_line(fnd_file.output, 'Error deleting data');
2943: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error deleting data'||SQLERRM);
2944: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error deleting data'||SQLERRM;
2945: retcode := -1;
2946: RETURN;

Line 2943: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error deleting data'||SQLERRM);

2939: range_id = lc_merge_range1.range_id;
2940: EXCEPTION
2941: WHEN OTHERS THEN
2942: fnd_file.put_line(fnd_file.output, 'Error deleting data');
2943: fnd_file.put_line(fnd_file.log, 'Module: LOOP_AND_PROCESS =>'||'Error deleting data'||SQLERRM);
2944: errbuf := 'Module: LOOP_AND_PROCESS =>'||'Error deleting data'||SQLERRM;
2945: retcode := -1;
2946: RETURN;
2947: END;

Line 3173: fnd_file.put_line(fnd_file.output, 'No EFC Ledgers Found');

3169: OPEN c_ledger_info;
3170: FETCH c_ledger_info INTO lc_c_ledger_info;
3171: IF c_ledger_info%NOTFOUND THEN
3172: CLOSE c_ledger_info;
3173: fnd_file.put_line(fnd_file.output, 'No EFC Ledgers Found');
3174: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'No EFC Ledgers Found');
3175: errbuf := 'No EFC Ledgers Found';
3176: retcode := -1;
3177: RETURN;

Line 3174: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'No EFC Ledgers Found');

3170: FETCH c_ledger_info INTO lc_c_ledger_info;
3171: IF c_ledger_info%NOTFOUND THEN
3172: CLOSE c_ledger_info;
3173: fnd_file.put_line(fnd_file.output, 'No EFC Ledgers Found');
3174: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'No EFC Ledgers Found');
3175: errbuf := 'No EFC Ledgers Found';
3176: retcode := -1;
3177: RETURN;
3178: END IF;

Line 3191: fnd_file.put_line(fnd_file.output, 'You have segment ranges which merge with other segment ranges

3187: OPEN C_OVERLAPPING_RANGE_EXISTS;
3188: FETCH C_OVERLAPPING_RANGE_EXISTS INTO lc_overlapping_range_exists;
3189: IF C_OVERLAPPING_RANGE_EXISTS%FOUND AND p_data_type <> 0 THEN
3190: CLOSE C_OVERLAPPING_RANGE_EXISTS;
3191: fnd_file.put_line(fnd_file.output, 'You have segment ranges which merge with other segment ranges
3192: for the same ledger and currency. This upgrade script does
3193: not support merging segment ranges for segments which have variable
3194: non numeric values. Merging segment ranges are supported only if your
3195: segment contains fixed length numeric values. Please contact Oracle Support for help');

Line 3196: fnd_file.put_line(fnd_file.log, 'You have segment ranges which merge with other segment ranges

3192: for the same ledger and currency. This upgrade script does
3193: not support merging segment ranges for segments which have variable
3194: non numeric values. Merging segment ranges are supported only if your
3195: segment contains fixed length numeric values. Please contact Oracle Support for help');
3196: fnd_file.put_line(fnd_file.log, 'You have segment ranges which merge with other segment ranges
3197: for the same ledger and currency code. This upgrade script does
3198: not support merging segment ranges for segments which have variable
3199: non numeric values. Merging segment ranges are supported only if your
3200: segment contains fixed length numeric values. Please contact Oracle Support for help');

Line 3209: fnd_file.put_line(fnd_file.output, 'Running EFC Upgrade in Final Mode');

3205: CLOSE C_OVERLAPPING_RANGE_EXISTS;
3206: END IF;
3207:
3208: IF p_mode = 1 THEN
3209: fnd_file.put_line(fnd_file.output, 'Running EFC Upgrade in Final Mode');
3210: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Running EFC Upgrade in Final Mode');
3211: ELSE
3212: fnd_file.put_line(fnd_file.output, 'Running EFC Upgrade in Preliminary Mode');
3213: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Running EFC Upgrade in Preliminary Mode');

Line 3210: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Running EFC Upgrade in Final Mode');

3206: END IF;
3207:
3208: IF p_mode = 1 THEN
3209: fnd_file.put_line(fnd_file.output, 'Running EFC Upgrade in Final Mode');
3210: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Running EFC Upgrade in Final Mode');
3211: ELSE
3212: fnd_file.put_line(fnd_file.output, 'Running EFC Upgrade in Preliminary Mode');
3213: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Running EFC Upgrade in Preliminary Mode');
3214: END IF;

Line 3212: fnd_file.put_line(fnd_file.output, 'Running EFC Upgrade in Preliminary Mode');

3208: IF p_mode = 1 THEN
3209: fnd_file.put_line(fnd_file.output, 'Running EFC Upgrade in Final Mode');
3210: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Running EFC Upgrade in Final Mode');
3211: ELSE
3212: fnd_file.put_line(fnd_file.output, 'Running EFC Upgrade in Preliminary Mode');
3213: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Running EFC Upgrade in Preliminary Mode');
3214: END IF;
3215:
3216:

Line 3213: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Running EFC Upgrade in Preliminary Mode');

3209: fnd_file.put_line(fnd_file.output, 'Running EFC Upgrade in Final Mode');
3210: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Running EFC Upgrade in Final Mode');
3211: ELSE
3212: fnd_file.put_line(fnd_file.output, 'Running EFC Upgrade in Preliminary Mode');
3213: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Running EFC Upgrade in Preliminary Mode');
3214: END IF;
3215:
3216:
3217: -- Typically data should not exist in these tables at this point. Deletion

Line 3226: fnd_file.put_line(fnd_file.output, 'Purging of tables failed');

3222: DELETE FROM IGI_UPG_GL_BUDORG_BC_OPTIONS;
3223:
3224: EXCEPTION
3225: WHEN OTHERS THEN
3226: fnd_file.put_line(fnd_file.output, 'Purging of tables failed');
3227: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Purging of tables failed =>'||SQLERRM);
3228: errbuf := 'Purging of tables failed'||SQLERRM;
3229: retcode := -1;
3230: RETURN;

Line 3227: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Purging of tables failed =>'||SQLERRM);

3223:
3224: EXCEPTION
3225: WHEN OTHERS THEN
3226: fnd_file.put_line(fnd_file.output, 'Purging of tables failed');
3227: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Purging of tables failed =>'||SQLERRM);
3228: errbuf := 'Purging of tables failed'||SQLERRM;
3229: retcode := -1;
3230: RETURN;
3231: END;

Line 3242: fnd_file.put_line(fnd_file.output, 'Upgrade Script has been run in Final Mode and thus cannot be run in Final Mode again');

3238: FETCH c_backup_exists INTO lc_backup_exists;
3239: IF c_backup_exists%FOUND THEN
3240: --Error final mode run twice
3241: CLOSE c_backup_exists;
3242: fnd_file.put_line(fnd_file.output, 'Upgrade Script has been run in Final Mode and thus cannot be run in Final Mode again');
3243: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Upgrade Script has been run in Final Mode');
3244: errbuf := 'Upgrade Script has been run in Final Mode and thus cannot be run again';
3245: retcode := -1;
3246: RETURN;

Line 3243: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Upgrade Script has been run in Final Mode');

3239: IF c_backup_exists%FOUND THEN
3240: --Error final mode run twice
3241: CLOSE c_backup_exists;
3242: fnd_file.put_line(fnd_file.output, 'Upgrade Script has been run in Final Mode and thus cannot be run in Final Mode again');
3243: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Upgrade Script has been run in Final Mode');
3244: errbuf := 'Upgrade Script has been run in Final Mode and thus cannot be run again';
3245: retcode := -1;
3246: RETURN;
3247: END IF;

Line 3466: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');

3462: ));
3463:
3464: EXCEPTION
3465: WHEN OTHERS THEN
3466: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3467: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3468: IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM);
3469: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3470: IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM;

Line 3467: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into

3463:
3464: EXCEPTION
3465: WHEN OTHERS THEN
3466: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3467: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3468: IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM);
3469: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3470: IGI_EFC_BUDGET_ASSIGNMENT_BCK =>'||SQLERRM;
3471: retcode := -1;

Line 3509: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');

3505: IGI_EFC_BUDGET_ASSIGNMENT_BCK);
3506:
3507: EXCEPTION
3508: WHEN OTHERS THEN
3509: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3510: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3511: IGI_BUDORG_BC_OPTIONS_BCK =>'||SQLERRM);
3512: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3513: IGI_BUDORG_BC_OPTIONS_BCK =>'||SQLERRM;

Line 3510: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into

3506:
3507: EXCEPTION
3508: WHEN OTHERS THEN
3509: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3510: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3511: IGI_BUDORG_BC_OPTIONS_BCK =>'||SQLERRM);
3512: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3513: IGI_BUDORG_BC_OPTIONS_BCK =>'||SQLERRM;
3514: retcode := -1;

Line 3592: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');

3588: IGI_EFC_BUDGET_ASSIGNMENT_BCK);
3589:
3590: EXCEPTION
3591: WHEN OTHERS THEN
3592: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3593: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3594: IGI_GL_BUDGET_ASSIGN_BCK =>'||SQLERRM);
3595: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3596: IGI_GL_BUDGET_ASSIGN_BCK =>'||SQLERRM;

Line 3593: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into

3589:
3590: EXCEPTION
3591: WHEN OTHERS THEN
3592: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3593: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3594: IGI_GL_BUDGET_ASSIGN_BCK =>'||SQLERRM);
3595: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3596: IGI_GL_BUDGET_ASSIGN_BCK =>'||SQLERRM;
3597: retcode := -1;

Line 3824: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');

3820: ));
3821:
3822: EXCEPTION
3823: WHEN OTHERS THEN
3824: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3825: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3826: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM);
3827: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3828: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM;

Line 3825: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into

3821:
3822: EXCEPTION
3823: WHEN OTHERS THEN
3824: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3825: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3826: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM);
3827: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3828: IGI_UPG_GL_BUDGET_ASSIGNMENT =>'||SQLERRM;
3829: retcode := -1;

Line 3868: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');

3864: IGI_UPG_GL_BUDGET_ASSIGNMENT);
3865:
3866: EXCEPTION
3867: WHEN OTHERS THEN
3868: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3869: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3870: IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM);
3871: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3872: IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM;

Line 3869: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into

3865:
3866: EXCEPTION
3867: WHEN OTHERS THEN
3868: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3869: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3870: IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM);
3871: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while inserting into
3872: IGI_UPG_GL_BUDORG_BC_OPTIONS =>'||SQLERRM;
3873: retcode := -1;

Line 3903: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');

3899: IGI_EFC_BUDGET_ASSIGNMENT_BCK);
3900:
3901: EXCEPTION
3902: WHEN OTHERS THEN
3903: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3904: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while deletion =>'||SQLERRM);
3905: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while deletion =>'||SQLERRM;
3906: retcode := -1;
3907: RETURN;

Line 3904: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while deletion =>'||SQLERRM);

3900:
3901: EXCEPTION
3902: WHEN OTHERS THEN
3903: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3904: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'||'Error while deletion =>'||SQLERRM);
3905: errbuf := 'Module: START_EFC_UPGRADE =>'||'Error while deletion =>'||SQLERRM;
3906: retcode := -1;
3907: RETURN;
3908: END;

Line 3923: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');

3919: -- concurrent request in error.
3920: IF l_retcode IS NOT NULL AND l_retcode = -1 THEN
3921: errbuf := l_errbuf;
3922: retcode := l_retcode;
3923: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3924: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'|| l_errbuf);
3925: ROLLBACK TO EFC_UPGRADE_START;
3926: fnd_file.put_line(fnd_file.log, 'Rollback Completed');
3927: ELSE

Line 3924: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'|| l_errbuf);

3920: IF l_retcode IS NOT NULL AND l_retcode = -1 THEN
3921: errbuf := l_errbuf;
3922: retcode := l_retcode;
3923: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3924: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'|| l_errbuf);
3925: ROLLBACK TO EFC_UPGRADE_START;
3926: fnd_file.put_line(fnd_file.log, 'Rollback Completed');
3927: ELSE
3928:

Line 3926: fnd_file.put_line(fnd_file.log, 'Rollback Completed');

3922: retcode := l_retcode;
3923: fnd_file.put_line(fnd_file.output, 'Unexpected Error: Please check the log');
3924: fnd_file.put_line(fnd_file.log, 'Module: START_EFC_UPGRADE =>'|| l_errbuf);
3925: ROLLBACK TO EFC_UPGRADE_START;
3926: fnd_file.put_line(fnd_file.log, 'Rollback Completed');
3927: ELSE
3928:
3929: -- If run in final mode, fire GL concurrent request
3930: -- "Assign Budget Ranges" in order to create assignments for the new

Line 3949: fnd_file.put_line(fnd_file.output, 'Unable to fire GLBAAR for ledger '

3945: '','','','','','','','','','',
3946: '','','','','','','','','','',
3947: '','','','','','','','','','');
3948: IF request_id IS NULL or request_id = 0 THEN
3949: fnd_file.put_line(fnd_file.output, 'Unable to fire GLBAAR for ledger '
3950: ||budget_entity_tab(i).ledger_id||' and Budget Organization '||budget_entity_tab(i).budget_entity_id);
3951: fnd_file.put_line(fnd_file.log,'Unable to fire GLBAAR for ledger '
3952: ||budget_entity_tab(i).ledger_id||' and Budget Organization '||budget_entity_tab(i).budget_entity_id);
3953: errbuf := 'Unable to fire GLBAAR';

Line 3951: fnd_file.put_line(fnd_file.log,'Unable to fire GLBAAR for ledger '

3947: '','','','','','','','','','');
3948: IF request_id IS NULL or request_id = 0 THEN
3949: fnd_file.put_line(fnd_file.output, 'Unable to fire GLBAAR for ledger '
3950: ||budget_entity_tab(i).ledger_id||' and Budget Organization '||budget_entity_tab(i).budget_entity_id);
3951: fnd_file.put_line(fnd_file.log,'Unable to fire GLBAAR for ledger '
3952: ||budget_entity_tab(i).ledger_id||' and Budget Organization '||budget_entity_tab(i).budget_entity_id);
3953: errbuf := 'Unable to fire GLBAAR';
3954: retcode := -1;
3955: ROLLBACK TO EFC_UPGRADE_START;

Line 3958: fnd_file.put_line(fnd_file.output, 'Fired Concurrent Request '||request_id);

3954: retcode := -1;
3955: ROLLBACK TO EFC_UPGRADE_START;
3956: RETURN;
3957: ELSE
3958: fnd_file.put_line(fnd_file.output, 'Fired Concurrent Request '||request_id);
3959: fnd_file.put_line(fnd_file.log, 'Fired Concurrent Request '||request_id);
3960: END IF;
3961: END LOOP;
3962:

Line 3959: fnd_file.put_line(fnd_file.log, 'Fired Concurrent Request '||request_id);

3955: ROLLBACK TO EFC_UPGRADE_START;
3956: RETURN;
3957: ELSE
3958: fnd_file.put_line(fnd_file.output, 'Fired Concurrent Request '||request_id);
3959: fnd_file.put_line(fnd_file.log, 'Fired Concurrent Request '||request_id);
3960: END IF;
3961: END LOOP;
3962:
3963: COMMIT;

Line 3964: fnd_file.put_line(fnd_file.output, 'Process completed successfully in Final Mode');

3960: END IF;
3961: END LOOP;
3962:
3963: COMMIT;
3964: fnd_file.put_line(fnd_file.output, 'Process completed successfully in Final Mode');
3965: fnd_file.put_line(fnd_file.log, 'Process completed successfully in Final Mode');
3966: ELSE
3967: ROLLBACK TO EFC_UPGRADE_START;
3968: fnd_file.put_line(fnd_file.output, 'Process completed successfully in Preliminary Mode');

Line 3965: fnd_file.put_line(fnd_file.log, 'Process completed successfully in Final Mode');

3961: END LOOP;
3962:
3963: COMMIT;
3964: fnd_file.put_line(fnd_file.output, 'Process completed successfully in Final Mode');
3965: fnd_file.put_line(fnd_file.log, 'Process completed successfully in Final Mode');
3966: ELSE
3967: ROLLBACK TO EFC_UPGRADE_START;
3968: fnd_file.put_line(fnd_file.output, 'Process completed successfully in Preliminary Mode');
3969: fnd_file.put_line(fnd_file.log, 'Process completed successfully in Preliminary Mode');

Line 3968: fnd_file.put_line(fnd_file.output, 'Process completed successfully in Preliminary Mode');

3964: fnd_file.put_line(fnd_file.output, 'Process completed successfully in Final Mode');
3965: fnd_file.put_line(fnd_file.log, 'Process completed successfully in Final Mode');
3966: ELSE
3967: ROLLBACK TO EFC_UPGRADE_START;
3968: fnd_file.put_line(fnd_file.output, 'Process completed successfully in Preliminary Mode');
3969: fnd_file.put_line(fnd_file.log, 'Process completed successfully in Preliminary Mode');
3970: END IF;
3971:
3972: END IF;

Line 3969: fnd_file.put_line(fnd_file.log, 'Process completed successfully in Preliminary Mode');

3965: fnd_file.put_line(fnd_file.log, 'Process completed successfully in Final Mode');
3966: ELSE
3967: ROLLBACK TO EFC_UPGRADE_START;
3968: fnd_file.put_line(fnd_file.output, 'Process completed successfully in Preliminary Mode');
3969: fnd_file.put_line(fnd_file.log, 'Process completed successfully in Preliminary Mode');
3970: END IF;
3971:
3972: END IF;
3973: