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

Line 213: fnd_file.put_line (fnd_file.LOG, '');

209: IF l_ledger_short_name = 'Y'
210: THEN
211: IF p_start_date < p_end_date
212: THEN
213: fnd_file.put_line (fnd_file.LOG, '');
214: fnd_file.put_line
215: (fnd_file.LOG,
216: '+---------------------------------------------------------------------------+'
217: );

Line 214: fnd_file.put_line

210: THEN
211: IF p_start_date < p_end_date
212: THEN
213: fnd_file.put_line (fnd_file.LOG, '');
214: fnd_file.put_line
215: (fnd_file.LOG,
216: '+---------------------------------------------------------------------------+'
217: );
218: fnd_file.put_line

Line 215: (fnd_file.LOG,

211: IF p_start_date < p_end_date
212: THEN
213: fnd_file.put_line (fnd_file.LOG, '');
214: fnd_file.put_line
215: (fnd_file.LOG,
216: '+---------------------------------------------------------------------------+'
217: );
218: fnd_file.put_line
219: (fnd_file.LOG,

Line 218: fnd_file.put_line

214: fnd_file.put_line
215: (fnd_file.LOG,
216: '+---------------------------------------------------------------------------+'
217: );
218: fnd_file.put_line
219: (fnd_file.LOG,
220: '+--------------------****GL OPEN PERIOD SYNCHRONIZATION****-----------------+'
221: );
222: fnd_file.put_line

Line 219: (fnd_file.LOG,

215: (fnd_file.LOG,
216: '+---------------------------------------------------------------------------+'
217: );
218: fnd_file.put_line
219: (fnd_file.LOG,
220: '+--------------------****GL OPEN PERIOD SYNCHRONIZATION****-----------------+'
221: );
222: fnd_file.put_line
223: (fnd_file.LOG,

Line 222: fnd_file.put_line

218: fnd_file.put_line
219: (fnd_file.LOG,
220: '+--------------------****GL OPEN PERIOD SYNCHRONIZATION****-----------------+'
221: );
222: fnd_file.put_line
223: (fnd_file.LOG,
224: '+---------------------------------------------------------------------------+'
225: );
226: fnd_file.put_line (fnd_file.LOG, '');

Line 223: (fnd_file.LOG,

219: (fnd_file.LOG,
220: '+--------------------****GL OPEN PERIOD SYNCHRONIZATION****-----------------+'
221: );
222: fnd_file.put_line
223: (fnd_file.LOG,
224: '+---------------------------------------------------------------------------+'
225: );
226: fnd_file.put_line (fnd_file.LOG, '');
227: --Difinitions

Line 226: fnd_file.put_line (fnd_file.LOG, '');

222: fnd_file.put_line
223: (fnd_file.LOG,
224: '+---------------------------------------------------------------------------+'
225: );
226: fnd_file.put_line (fnd_file.LOG, '');
227: --Difinitions
228: fnd_file.put_line (fnd_file.LOG, 'DEFINITIONS');
229: fnd_file.put_line (fnd_file.LOG, '-----------');
230: fnd_file.put_line

Line 228: fnd_file.put_line (fnd_file.LOG, 'DEFINITIONS');

224: '+---------------------------------------------------------------------------+'
225: );
226: fnd_file.put_line (fnd_file.LOG, '');
227: --Difinitions
228: fnd_file.put_line (fnd_file.LOG, 'DEFINITIONS');
229: fnd_file.put_line (fnd_file.LOG, '-----------');
230: fnd_file.put_line
231: (fnd_file.LOG,
232: ' GLPSL : GL PERIOD STATUS SYNCHRONIZATION LOG(LINES)'

Line 229: fnd_file.put_line (fnd_file.LOG, '-----------');

225: );
226: fnd_file.put_line (fnd_file.LOG, '');
227: --Difinitions
228: fnd_file.put_line (fnd_file.LOG, 'DEFINITIONS');
229: fnd_file.put_line (fnd_file.LOG, '-----------');
230: fnd_file.put_line
231: (fnd_file.LOG,
232: ' GLPSL : GL PERIOD STATUS SYNCHRONIZATION LOG(LINES)'
233: );

Line 230: fnd_file.put_line

226: fnd_file.put_line (fnd_file.LOG, '');
227: --Difinitions
228: fnd_file.put_line (fnd_file.LOG, 'DEFINITIONS');
229: fnd_file.put_line (fnd_file.LOG, '-----------');
230: fnd_file.put_line
231: (fnd_file.LOG,
232: ' GLPSL : GL PERIOD STATUS SYNCHRONIZATION LOG(LINES)'
233: );
234: fnd_file.put_line

Line 231: (fnd_file.LOG,

227: --Difinitions
228: fnd_file.put_line (fnd_file.LOG, 'DEFINITIONS');
229: fnd_file.put_line (fnd_file.LOG, '-----------');
230: fnd_file.put_line
231: (fnd_file.LOG,
232: ' GLPSL : GL PERIOD STATUS SYNCHRONIZATION LOG(LINES)'
233: );
234: fnd_file.put_line
235: (fnd_file.LOG,

Line 234: fnd_file.put_line

230: fnd_file.put_line
231: (fnd_file.LOG,
232: ' GLPSL : GL PERIOD STATUS SYNCHRONIZATION LOG(LINES)'
233: );
234: fnd_file.put_line
235: (fnd_file.LOG,
236: ' GLPSL : GL PERIOD STATUS SYNCHRONIZATION ERROR'
237: );
238: fnd_file.put_line (fnd_file.LOG, 'RESP ID : RESPONSIBILITY ID');

Line 235: (fnd_file.LOG,

231: (fnd_file.LOG,
232: ' GLPSL : GL PERIOD STATUS SYNCHRONIZATION LOG(LINES)'
233: );
234: fnd_file.put_line
235: (fnd_file.LOG,
236: ' GLPSL : GL PERIOD STATUS SYNCHRONIZATION ERROR'
237: );
238: fnd_file.put_line (fnd_file.LOG, 'RESP ID : RESPONSIBILITY ID');
239: fnd_file.put_line (fnd_file.LOG, 'APPS ID : APPLICATION ID');

Line 238: fnd_file.put_line (fnd_file.LOG, 'RESP ID : RESPONSIBILITY ID');

234: fnd_file.put_line
235: (fnd_file.LOG,
236: ' GLPSL : GL PERIOD STATUS SYNCHRONIZATION ERROR'
237: );
238: fnd_file.put_line (fnd_file.LOG, 'RESP ID : RESPONSIBILITY ID');
239: fnd_file.put_line (fnd_file.LOG, 'APPS ID : APPLICATION ID');
240: fnd_file.put_line (fnd_file.LOG, ' C : CLOSED');
241: fnd_file.put_line (fnd_file.LOG, ' O : OPENED');
242: fnd_file.put_line (fnd_file.LOG, '');

Line 239: fnd_file.put_line (fnd_file.LOG, 'APPS ID : APPLICATION ID');

235: (fnd_file.LOG,
236: ' GLPSL : GL PERIOD STATUS SYNCHRONIZATION ERROR'
237: );
238: fnd_file.put_line (fnd_file.LOG, 'RESP ID : RESPONSIBILITY ID');
239: fnd_file.put_line (fnd_file.LOG, 'APPS ID : APPLICATION ID');
240: fnd_file.put_line (fnd_file.LOG, ' C : CLOSED');
241: fnd_file.put_line (fnd_file.LOG, ' O : OPENED');
242: fnd_file.put_line (fnd_file.LOG, '');
243: fnd_file.put_line (fnd_file.LOG, 'GLPSL: Program Begins...');

Line 240: fnd_file.put_line (fnd_file.LOG, ' C : CLOSED');

236: ' GLPSL : GL PERIOD STATUS SYNCHRONIZATION ERROR'
237: );
238: fnd_file.put_line (fnd_file.LOG, 'RESP ID : RESPONSIBILITY ID');
239: fnd_file.put_line (fnd_file.LOG, 'APPS ID : APPLICATION ID');
240: fnd_file.put_line (fnd_file.LOG, ' C : CLOSED');
241: fnd_file.put_line (fnd_file.LOG, ' O : OPENED');
242: fnd_file.put_line (fnd_file.LOG, '');
243: fnd_file.put_line (fnd_file.LOG, 'GLPSL: Program Begins...');
244: fnd_file.put_line (fnd_file.LOG, '');

Line 241: fnd_file.put_line (fnd_file.LOG, ' O : OPENED');

237: );
238: fnd_file.put_line (fnd_file.LOG, 'RESP ID : RESPONSIBILITY ID');
239: fnd_file.put_line (fnd_file.LOG, 'APPS ID : APPLICATION ID');
240: fnd_file.put_line (fnd_file.LOG, ' C : CLOSED');
241: fnd_file.put_line (fnd_file.LOG, ' O : OPENED');
242: fnd_file.put_line (fnd_file.LOG, '');
243: fnd_file.put_line (fnd_file.LOG, 'GLPSL: Program Begins...');
244: fnd_file.put_line (fnd_file.LOG, '');
245: --Find the Concurrent Request Id for Period Synchronization

Line 242: fnd_file.put_line (fnd_file.LOG, '');

238: fnd_file.put_line (fnd_file.LOG, 'RESP ID : RESPONSIBILITY ID');
239: fnd_file.put_line (fnd_file.LOG, 'APPS ID : APPLICATION ID');
240: fnd_file.put_line (fnd_file.LOG, ' C : CLOSED');
241: fnd_file.put_line (fnd_file.LOG, ' O : OPENED');
242: fnd_file.put_line (fnd_file.LOG, '');
243: fnd_file.put_line (fnd_file.LOG, 'GLPSL: Program Begins...');
244: fnd_file.put_line (fnd_file.LOG, '');
245: --Find the Concurrent Request Id for Period Synchronization
246: fnd_file.put_line

Line 243: fnd_file.put_line (fnd_file.LOG, 'GLPSL: Program Begins...');

239: fnd_file.put_line (fnd_file.LOG, 'APPS ID : APPLICATION ID');
240: fnd_file.put_line (fnd_file.LOG, ' C : CLOSED');
241: fnd_file.put_line (fnd_file.LOG, ' O : OPENED');
242: fnd_file.put_line (fnd_file.LOG, '');
243: fnd_file.put_line (fnd_file.LOG, 'GLPSL: Program Begins...');
244: fnd_file.put_line (fnd_file.LOG, '');
245: --Find the Concurrent Request Id for Period Synchronization
246: fnd_file.put_line
247: (fnd_file.LOG,

Line 244: fnd_file.put_line (fnd_file.LOG, '');

240: fnd_file.put_line (fnd_file.LOG, ' C : CLOSED');
241: fnd_file.put_line (fnd_file.LOG, ' O : OPENED');
242: fnd_file.put_line (fnd_file.LOG, '');
243: fnd_file.put_line (fnd_file.LOG, 'GLPSL: Program Begins...');
244: fnd_file.put_line (fnd_file.LOG, '');
245: --Find the Concurrent Request Id for Period Synchronization
246: fnd_file.put_line
247: (fnd_file.LOG,
248: 'GLPSL: Get The Concurrent request ID for Period Synchronization....'

Line 246: fnd_file.put_line

242: fnd_file.put_line (fnd_file.LOG, '');
243: fnd_file.put_line (fnd_file.LOG, 'GLPSL: Program Begins...');
244: fnd_file.put_line (fnd_file.LOG, '');
245: --Find the Concurrent Request Id for Period Synchronization
246: fnd_file.put_line
247: (fnd_file.LOG,
248: 'GLPSL: Get The Concurrent request ID for Period Synchronization....'
249: );
250: l_conc_request_id := fnd_global.conc_request_id;

Line 247: (fnd_file.LOG,

243: fnd_file.put_line (fnd_file.LOG, 'GLPSL: Program Begins...');
244: fnd_file.put_line (fnd_file.LOG, '');
245: --Find the Concurrent Request Id for Period Synchronization
246: fnd_file.put_line
247: (fnd_file.LOG,
248: 'GLPSL: Get The Concurrent request ID for Period Synchronization....'
249: );
250: l_conc_request_id := fnd_global.conc_request_id;
251: fnd_file.put_line (fnd_file.LOG,

Line 251: fnd_file.put_line (fnd_file.LOG,

247: (fnd_file.LOG,
248: 'GLPSL: Get The Concurrent request ID for Period Synchronization....'
249: );
250: l_conc_request_id := fnd_global.conc_request_id;
251: fnd_file.put_line (fnd_file.LOG,
252: 'GLPSL: Concurrent Request ID = '
253: || l_conc_request_id
254: );
255: --------------------------------------------------

Line 258: fnd_file.put_line (fnd_file.LOG,

254: );
255: --------------------------------------------------
256: ------****Initializing Global Parameters****------
257: --------------------------------------------------
258: fnd_file.put_line (fnd_file.LOG,
259: 'GLPSL: Initializing Global Parameters.......'
260: );
261: --FND_GLOBAL.APPS_INITIALIZE(1001530,50553,101);
262: l_user_id := fnd_global.user_id; --1318

Line 272: fnd_file.put_line (fnd_file.LOG,

268: (fnd_profile.value('USER_ID'),
269: fnd_profile.value('RESP_ID'),
270: fnd_profile.value('RESP_APPL_ID'));*/--commented by Vamshi
271: l_access_set_id := fnd_profile.VALUE ('GL_ACCESS_SET_ID');
272: fnd_file.put_line (fnd_file.LOG,
273: 'GLPSL: USER ID : '
274: || l_user_id
275: || ', '
276: || 'RESP ID : '

Line 285: fnd_file.put_line (fnd_file.LOG, '');

281: || ', '
282: || 'Access Set ID : '
283: || l_access_set_id
284: );
285: fnd_file.put_line (fnd_file.LOG, '');
286:
287: OPEN c_start_date (p_ledger_short_name, l_apps_id, p_start_date);
288:
289: FETCH c_start_date

Line 311: fnd_file.put_line (fnd_file.LOG, '');

307:
308: --------------------------------------------------
309: --Get the Primary, its secondary and ALC Ledgers--
310: --------------------------------------------------
311: fnd_file.put_line (fnd_file.LOG, '');
312: fnd_file.put_line
313: (fnd_file.LOG,
314: 'GLPSL: GETS INTO PRIMARY, ITS SECONDARY AND ALC LEDGER RECORDS'
315: );

Line 312: fnd_file.put_line

308: --------------------------------------------------
309: --Get the Primary, its secondary and ALC Ledgers--
310: --------------------------------------------------
311: fnd_file.put_line (fnd_file.LOG, '');
312: fnd_file.put_line
313: (fnd_file.LOG,
314: 'GLPSL: GETS INTO PRIMARY, ITS SECONDARY AND ALC LEDGER RECORDS'
315: );
316: fnd_file.put_line (fnd_file.LOG, '');

Line 313: (fnd_file.LOG,

309: --Get the Primary, its secondary and ALC Ledgers--
310: --------------------------------------------------
311: fnd_file.put_line (fnd_file.LOG, '');
312: fnd_file.put_line
313: (fnd_file.LOG,
314: 'GLPSL: GETS INTO PRIMARY, ITS SECONDARY AND ALC LEDGER RECORDS'
315: );
316: fnd_file.put_line (fnd_file.LOG, '');
317:

Line 316: fnd_file.put_line (fnd_file.LOG, '');

312: fnd_file.put_line
313: (fnd_file.LOG,
314: 'GLPSL: GETS INTO PRIMARY, ITS SECONDARY AND ALC LEDGER RECORDS'
315: );
316: fnd_file.put_line (fnd_file.LOG, '');
317:
318: FOR c1 IN c_get_ledgers_rec (p_ledger_short_name,
319: 'L',
320: l_apps_id,

Line 335: fnd_file.put_line

331: )
332: LOOP
333: IF c2.period_name IS NOT NULL
334: THEN
335: fnd_file.put_line
336: (fnd_file.LOG,
337: '-----**Open Period for the Given Date Range**-----'
338: );
339: fnd_file.put_line (fnd_file.LOG, '');

Line 336: (fnd_file.LOG,

332: LOOP
333: IF c2.period_name IS NOT NULL
334: THEN
335: fnd_file.put_line
336: (fnd_file.LOG,
337: '-----**Open Period for the Given Date Range**-----'
338: );
339: fnd_file.put_line (fnd_file.LOG, '');
340: fnd_file.put_line

Line 339: fnd_file.put_line (fnd_file.LOG, '');

335: fnd_file.put_line
336: (fnd_file.LOG,
337: '-----**Open Period for the Given Date Range**-----'
338: );
339: fnd_file.put_line (fnd_file.LOG, '');
340: fnd_file.put_line
341: (fnd_file.LOG,
342: 'GLPSL: Nullifying request_id for open period Process'
343: );

Line 340: fnd_file.put_line

336: (fnd_file.LOG,
337: '-----**Open Period for the Given Date Range**-----'
338: );
339: fnd_file.put_line (fnd_file.LOG, '');
340: fnd_file.put_line
341: (fnd_file.LOG,
342: 'GLPSL: Nullifying request_id for open period Process'
343: );
344: l_request_id := NULL;

Line 341: (fnd_file.LOG,

337: '-----**Open Period for the Given Date Range**-----'
338: );
339: fnd_file.put_line (fnd_file.LOG, '');
340: fnd_file.put_line
341: (fnd_file.LOG,
342: 'GLPSL: Nullifying request_id for open period Process'
343: );
344: l_request_id := NULL;
345: fnd_file.put_line

Line 345: fnd_file.put_line

341: (fnd_file.LOG,
342: 'GLPSL: Nullifying request_id for open period Process'
343: );
344: l_request_id := NULL;
345: fnd_file.put_line
346: (fnd_file.LOG,
347: 'GLPSL: Submit the Open Period request for the Period of '
348: || c2.period_name
349: );

Line 346: (fnd_file.LOG,

342: 'GLPSL: Nullifying request_id for open period Process'
343: );
344: l_request_id := NULL;
345: fnd_file.put_line
346: (fnd_file.LOG,
347: 'GLPSL: Submit the Open Period request for the Period of '
348: || c2.period_name
349: );
350: fnd_file.put_line

Line 350: fnd_file.put_line

346: (fnd_file.LOG,
347: 'GLPSL: Submit the Open Period request for the Period of '
348: || c2.period_name
349: );
350: fnd_file.put_line
351: (fnd_file.LOG,
352: 'GLPSL: Submit Concurrent GLOOAP...'
353: );
354: l_request_id :=

Line 351: (fnd_file.LOG,

347: 'GLPSL: Submit the Open Period request for the Period of '
348: || c2.period_name
349: );
350: fnd_file.put_line
351: (fnd_file.LOG,
352: 'GLPSL: Submit Concurrent GLOOAP...'
353: );
354: l_request_id :=
355: fnd_request.submit_request

Line 381: fnd_file.put_line

377: '','','','','','','','','','',
378: '',''
379: );
380: COMMIT;
381: fnd_file.put_line
382: (fnd_file.LOG,
383: 'GLPSL: Commit to get the Request ID'
384: );
385: fnd_file.put_line (fnd_file.LOG,

Line 382: (fnd_file.LOG,

378: '',''
379: );
380: COMMIT;
381: fnd_file.put_line
382: (fnd_file.LOG,
383: 'GLPSL: Commit to get the Request ID'
384: );
385: fnd_file.put_line (fnd_file.LOG,
386: 'GLPSL: Request ID = '

Line 385: fnd_file.put_line (fnd_file.LOG,

381: fnd_file.put_line
382: (fnd_file.LOG,
383: 'GLPSL: Commit to get the Request ID'
384: );
385: fnd_file.put_line (fnd_file.LOG,
386: 'GLPSL: Request ID = '
387: || l_request_id
388: );
389: fnd_file.put_line (fnd_file.LOG, '');

Line 389: fnd_file.put_line (fnd_file.LOG, '');

385: fnd_file.put_line (fnd_file.LOG,
386: 'GLPSL: Request ID = '
387: || l_request_id
388: );
389: fnd_file.put_line (fnd_file.LOG, '');
390:
391: IF l_request_id > 0
392: THEN
393: --------------------------------------------------

Line 396: fnd_file.put_line

392: THEN
393: --------------------------------------------------
394: ---**Monitoring Request Status on Open Period**---
395: --------------------------------------------------
396: fnd_file.put_line
397: (fnd_file.LOG,
398: 'GLPSL: Monitoring Request Status on Open Period'
399: );
400: fnd_file.put_line

Line 397: (fnd_file.LOG,

393: --------------------------------------------------
394: ---**Monitoring Request Status on Open Period**---
395: --------------------------------------------------
396: fnd_file.put_line
397: (fnd_file.LOG,
398: 'GLPSL: Monitoring Request Status on Open Period'
399: );
400: fnd_file.put_line
401: (fnd_file.LOG,

Line 400: fnd_file.put_line

396: fnd_file.put_line
397: (fnd_file.LOG,
398: 'GLPSL: Monitoring Request Status on Open Period'
399: );
400: fnd_file.put_line
401: (fnd_file.LOG,
402: 'GLPSL: Open Period Monitoring Loop.....'
403: );
404: fnd_file.put_line

Line 401: (fnd_file.LOG,

397: (fnd_file.LOG,
398: 'GLPSL: Monitoring Request Status on Open Period'
399: );
400: fnd_file.put_line
401: (fnd_file.LOG,
402: 'GLPSL: Open Period Monitoring Loop.....'
403: );
404: fnd_file.put_line
405: (fnd_file.LOG,

Line 404: fnd_file.put_line

400: fnd_file.put_line
401: (fnd_file.LOG,
402: 'GLPSL: Open Period Monitoring Loop.....'
403: );
404: fnd_file.put_line
405: (fnd_file.LOG,
406: 'GLPSL: Wait Untill request complete.....'
407: );
408:

Line 405: (fnd_file.LOG,

401: (fnd_file.LOG,
402: 'GLPSL: Open Period Monitoring Loop.....'
403: );
404: fnd_file.put_line
405: (fnd_file.LOG,
406: 'GLPSL: Wait Untill request complete.....'
407: );
408:
409: LOOP

Line 429: fnd_file.put_line (fnd_file.LOG,

425: );
426: EXIT WHEN l_phase = 'Completed';
427: END LOOP;
428:
429: fnd_file.put_line (fnd_file.LOG,
430: 'GLPSL: Phase : '
431: || l_phase
432: || ' '
433: || 'Status : '

Line 437: fnd_file.put_line

433: || 'Status : '
434: || l_status
435: );
436: ELSE
437: fnd_file.put_line
438: (fnd_file.LOG,
439: 'GLPSL: Request Not Submitted'
440: );
441: END IF;

Line 438: (fnd_file.LOG,

434: || l_status
435: );
436: ELSE
437: fnd_file.put_line
438: (fnd_file.LOG,
439: 'GLPSL: Request Not Submitted'
440: );
441: END IF;
442:

Line 449: fnd_file.put_line

445: c2.period_name
446: )
447: LOOP
448: l_closing_status := c.closing_status;
449: fnd_file.put_line
450: (fnd_file.LOG,
451: 'GLPSL: CLOSING STATUS OF '
452: || c2.period_name
453: || ' IS '

Line 450: (fnd_file.LOG,

446: )
447: LOOP
448: l_closing_status := c.closing_status;
449: fnd_file.put_line
450: (fnd_file.LOG,
451: 'GLPSL: CLOSING STATUS OF '
452: || c2.period_name
453: || ' IS '
454: || l_closing_status

Line 456: fnd_file.put_line (fnd_file.LOG, '');

452: || c2.period_name
453: || ' IS '
454: || l_closing_status
455: );
456: fnd_file.put_line (fnd_file.LOG, '');
457: END LOOP;
458:
459: IF l_closing_status <> 'O'
460: THEN

Line 467: fnd_file.put_line

463: 'GLPSE: Execution Failed in Open Period '
464: || c2.period_name
465: || ' of Ledger '
466: || c1.short_name;
467: fnd_file.put_line
468: (fnd_file.LOG,
469: 'GLPSE: Error and Exiting From Open Period Loop'
470: );
471: fnd_file.put_line (fnd_file.LOG,

Line 468: (fnd_file.LOG,

464: || c2.period_name
465: || ' of Ledger '
466: || c1.short_name;
467: fnd_file.put_line
468: (fnd_file.LOG,
469: 'GLPSE: Error and Exiting From Open Period Loop'
470: );
471: fnd_file.put_line (fnd_file.LOG,
472: 'GLPSE: Error IN '

Line 471: fnd_file.put_line (fnd_file.LOG,

467: fnd_file.put_line
468: (fnd_file.LOG,
469: 'GLPSE: Error and Exiting From Open Period Loop'
470: );
471: fnd_file.put_line (fnd_file.LOG,
472: 'GLPSE: Error IN '
473: || c2.period_name
474: || ' Period of '
475: || c1.NAME

Line 480: fnd_file.put_line

476: );
477: EXIT;
478: END IF;
479: ELSE
480: fnd_file.put_line
481: (fnd_file.LOG,
482: 'GLPSL: There Are No periods To Process for '
483: || c1.NAME
484: );

Line 481: (fnd_file.LOG,

477: EXIT;
478: END IF;
479: ELSE
480: fnd_file.put_line
481: (fnd_file.LOG,
482: 'GLPSL: There Are No periods To Process for '
483: || c1.NAME
484: );
485: END IF;

Line 490: fnd_file.put_line

486: END LOOP;
487:
488: IF l_closing_status <> 'O'
489: THEN
490: fnd_file.put_line
491: (fnd_file.LOG,
492: 'GLPSE: Error and Exiting From Ledger Loop'
493: );
494: EXIT;

Line 491: (fnd_file.LOG,

487:
488: IF l_closing_status <> 'O'
489: THEN
490: fnd_file.put_line
491: (fnd_file.LOG,
492: 'GLPSE: Error and Exiting From Ledger Loop'
493: );
494: EXIT;
495: END IF;

Line 508: fnd_file.put_line

504: )
505: LOOP
506: IF c3.period_name IS NOT NULL
507: THEN
508: fnd_file.put_line
509: (fnd_file.LOG,
510: '--**Closing Period Beyond the Given Date Range**--'
511: );
512: fnd_file.put_line (fnd_file.LOG, '');

Line 509: (fnd_file.LOG,

505: LOOP
506: IF c3.period_name IS NOT NULL
507: THEN
508: fnd_file.put_line
509: (fnd_file.LOG,
510: '--**Closing Period Beyond the Given Date Range**--'
511: );
512: fnd_file.put_line (fnd_file.LOG, '');
513: fnd_file.put_line

Line 512: fnd_file.put_line (fnd_file.LOG, '');

508: fnd_file.put_line
509: (fnd_file.LOG,
510: '--**Closing Period Beyond the Given Date Range**--'
511: );
512: fnd_file.put_line (fnd_file.LOG, '');
513: fnd_file.put_line
514: (fnd_file.LOG,
515: 'GLPSL: Nullifying request_id for open period Process'
516: );

Line 513: fnd_file.put_line

509: (fnd_file.LOG,
510: '--**Closing Period Beyond the Given Date Range**--'
511: );
512: fnd_file.put_line (fnd_file.LOG, '');
513: fnd_file.put_line
514: (fnd_file.LOG,
515: 'GLPSL: Nullifying request_id for open period Process'
516: );
517: l_request_id := NULL;

Line 514: (fnd_file.LOG,

510: '--**Closing Period Beyond the Given Date Range**--'
511: );
512: fnd_file.put_line (fnd_file.LOG, '');
513: fnd_file.put_line
514: (fnd_file.LOG,
515: 'GLPSL: Nullifying request_id for open period Process'
516: );
517: l_request_id := NULL;
518: fnd_file.put_line

Line 518: fnd_file.put_line

514: (fnd_file.LOG,
515: 'GLPSL: Nullifying request_id for open period Process'
516: );
517: l_request_id := NULL;
518: fnd_file.put_line
519: (fnd_file.LOG,
520: 'GLPSL: Submit the Open Period request for the Period of '
521: || c3.period_name
522: );

Line 519: (fnd_file.LOG,

515: 'GLPSL: Nullifying request_id for open period Process'
516: );
517: l_request_id := NULL;
518: fnd_file.put_line
519: (fnd_file.LOG,
520: 'GLPSL: Submit the Open Period request for the Period of '
521: || c3.period_name
522: );
523: fnd_file.put_line

Line 523: fnd_file.put_line

519: (fnd_file.LOG,
520: 'GLPSL: Submit the Open Period request for the Period of '
521: || c3.period_name
522: );
523: fnd_file.put_line
524: (fnd_file.LOG,
525: 'GLPSL: Submit Concurrent GLOCPP...'
526: );
527: l_request_id :=

Line 524: (fnd_file.LOG,

520: 'GLPSL: Submit the Open Period request for the Period of '
521: || c3.period_name
522: );
523: fnd_file.put_line
524: (fnd_file.LOG,
525: 'GLPSL: Submit Concurrent GLOCPP...'
526: );
527: l_request_id :=
528: fnd_request.submit_request ('SQLGL',

Line 553: fnd_file.put_line

549: '','','','','','','','','','',
550: '',''
551: );
552: COMMIT;
553: fnd_file.put_line
554: (fnd_file.LOG,
555: 'GLPSL: Commit to get the Request ID'
556: );
557: fnd_file.put_line (fnd_file.LOG,

Line 554: (fnd_file.LOG,

550: '',''
551: );
552: COMMIT;
553: fnd_file.put_line
554: (fnd_file.LOG,
555: 'GLPSL: Commit to get the Request ID'
556: );
557: fnd_file.put_line (fnd_file.LOG,
558: 'GLPSL: Request ID : '

Line 557: fnd_file.put_line (fnd_file.LOG,

553: fnd_file.put_line
554: (fnd_file.LOG,
555: 'GLPSL: Commit to get the Request ID'
556: );
557: fnd_file.put_line (fnd_file.LOG,
558: 'GLPSL: Request ID : '
559: || l_request_id
560: );
561: fnd_file.put_line (fnd_file.LOG, '');

Line 561: fnd_file.put_line (fnd_file.LOG, '');

557: fnd_file.put_line (fnd_file.LOG,
558: 'GLPSL: Request ID : '
559: || l_request_id
560: );
561: fnd_file.put_line (fnd_file.LOG, '');
562:
563: IF l_request_id > 0
564: THEN
565: --------------------------------------------------

Line 568: fnd_file.put_line

564: THEN
565: --------------------------------------------------
566: --**Monitoring Request Status for Close Period**--
567: --------------------------------------------------
568: fnd_file.put_line
569: (fnd_file.LOG,
570: 'GLPSL: Monitoring Request Status on Close Period'
571: );
572: fnd_file.put_line

Line 569: (fnd_file.LOG,

565: --------------------------------------------------
566: --**Monitoring Request Status for Close Period**--
567: --------------------------------------------------
568: fnd_file.put_line
569: (fnd_file.LOG,
570: 'GLPSL: Monitoring Request Status on Close Period'
571: );
572: fnd_file.put_line
573: (fnd_file.LOG,

Line 572: fnd_file.put_line

568: fnd_file.put_line
569: (fnd_file.LOG,
570: 'GLPSL: Monitoring Request Status on Close Period'
571: );
572: fnd_file.put_line
573: (fnd_file.LOG,
574: 'GLPSL: Wait Untill request complete.....'
575: );
576:

Line 573: (fnd_file.LOG,

569: (fnd_file.LOG,
570: 'GLPSL: Monitoring Request Status on Close Period'
571: );
572: fnd_file.put_line
573: (fnd_file.LOG,
574: 'GLPSL: Wait Untill request complete.....'
575: );
576:
577: LOOP

Line 597: fnd_file.put_line (fnd_file.LOG,

593: );
594: EXIT WHEN l_phase = 'Completed';
595: END LOOP;
596:
597: fnd_file.put_line (fnd_file.LOG,
598: 'GLPSL: Phase : '
599: || l_phase
600: || ' '
601: || 'Status : '

Line 605: fnd_file.put_line

601: || 'Status : '
602: || l_status
603: );
604: ELSE
605: fnd_file.put_line
606: (fnd_file.LOG,
607: 'GLPSE : Reuest Not Submitted'
608: );
609: END IF;

Line 606: (fnd_file.LOG,

602: || l_status
603: );
604: ELSE
605: fnd_file.put_line
606: (fnd_file.LOG,
607: 'GLPSE : Reuest Not Submitted'
608: );
609: END IF;
610:

Line 617: fnd_file.put_line

613: c3.period_name
614: )
615: LOOP
616: l_closing_status := c.closing_status;
617: fnd_file.put_line
618: (fnd_file.LOG,
619: 'GLPSL: CLOSING STATUS OF '
620: || c3.period_name
621: || ' IS '

Line 618: (fnd_file.LOG,

614: )
615: LOOP
616: l_closing_status := c.closing_status;
617: fnd_file.put_line
618: (fnd_file.LOG,
619: 'GLPSL: CLOSING STATUS OF '
620: || c3.period_name
621: || ' IS '
622: || l_closing_status

Line 624: fnd_file.put_line (fnd_file.LOG, '');

620: || c3.period_name
621: || ' IS '
622: || l_closing_status
623: );
624: fnd_file.put_line (fnd_file.LOG, '');
625: END LOOP;
626:
627: IF l_closing_status <> 'C'
628: THEN

Line 636: fnd_file.put_line

632: 'GLPSE: Execution Failed in Open Period '
633: || c3.period_name
634: || ' of Ledger '
635: || c1.short_name;
636: fnd_file.put_line
637: (fnd_file.LOG,
638: 'GLPSE: Error and Exiting From Open Period Loop'
639: );
640: fnd_file.put_line (fnd_file.LOG,

Line 637: (fnd_file.LOG,

633: || c3.period_name
634: || ' of Ledger '
635: || c1.short_name;
636: fnd_file.put_line
637: (fnd_file.LOG,
638: 'GLPSE: Error and Exiting From Open Period Loop'
639: );
640: fnd_file.put_line (fnd_file.LOG,
641: 'GLPSE: Error IN '

Line 640: fnd_file.put_line (fnd_file.LOG,

636: fnd_file.put_line
637: (fnd_file.LOG,
638: 'GLPSE: Error and Exiting From Open Period Loop'
639: );
640: fnd_file.put_line (fnd_file.LOG,
641: 'GLPSE: Error IN '
642: || c3.period_name
643: || ' Period of '
644: || c1.NAME

Line 646: fnd_file.put_line

642: || c3.period_name
643: || ' Period of '
644: || c1.NAME
645: );
646: fnd_file.put_line
647: (fnd_file.LOG,
648: 'GLPSE: Error and Exiting From Close Period Loop'
649: );
650: EXIT;

Line 647: (fnd_file.LOG,

643: || ' Period of '
644: || c1.NAME
645: );
646: fnd_file.put_line
647: (fnd_file.LOG,
648: 'GLPSE: Error and Exiting From Close Period Loop'
649: );
650: EXIT;
651: END IF;

Line 655: fnd_file.put_line

651: END IF;
652:
653: l_closing_status := 'O';
654: ELSE
655: fnd_file.put_line
656: (fnd_file.LOG,
657: 'GLPSE: There Are No Periods To Close for '
658: || c1.NAME
659: );

Line 656: (fnd_file.LOG,

652:
653: l_closing_status := 'O';
654: ELSE
655: fnd_file.put_line
656: (fnd_file.LOG,
657: 'GLPSE: There Are No Periods To Close for '
658: || c1.NAME
659: );
660: END IF;

Line 662: fnd_file.put_line

658: || c1.NAME
659: );
660: END IF;
661:
662: fnd_file.put_line
663: (fnd_file.LOG,
664: 'GLPSL: END of Close Period Loop.....'
665: );
666: END LOOP;

Line 663: (fnd_file.LOG,

659: );
660: END IF;
661:
662: fnd_file.put_line
663: (fnd_file.LOG,
664: 'GLPSL: END of Close Period Loop.....'
665: );
666: END LOOP;
667: --IF l_closing_status <> 'C' THEN

Line 668: --fnd_file.put_line( fnd_file.log,'Error and Exiting From Ledger Loop');

664: 'GLPSL: END of Close Period Loop.....'
665: );
666: END LOOP;
667: --IF l_closing_status <> 'C' THEN
668: --fnd_file.put_line( fnd_file.log,'Error and Exiting From Ledger Loop');
669: --EXIT;
670: --END IF;
671: ELSE
672: fnd_file.put_line

Line 672: fnd_file.put_line

668: --fnd_file.put_line( fnd_file.log,'Error and Exiting From Ledger Loop');
669: --EXIT;
670: --END IF;
671: ELSE
672: fnd_file.put_line
673: (fnd_file.LOG,
674: 'GLPSE: There are No Ledger Records To Process'
675: );
676: END IF;

Line 673: (fnd_file.LOG,

669: --EXIT;
670: --END IF;
671: ELSE
672: fnd_file.put_line
673: (fnd_file.LOG,
674: 'GLPSE: There are No Ledger Records To Process'
675: );
676: END IF;
677:

Line 678: fnd_file.put_line (fnd_file.LOG, '');

674: 'GLPSE: There are No Ledger Records To Process'
675: );
676: END IF;
677:
678: fnd_file.put_line (fnd_file.LOG, '');
679: END LOOP;
680:
681: IF l_con_status = 'FAILURE'
682: THEN

Line 686: fnd_file.put_line (fnd_file.LOG, 'TRANSACTION FAILURE');

682: THEN
683: retcode := 2;
684: x_return_status := 'E';
685: l_be_message := l_process_status_msg;
686: fnd_file.put_line (fnd_file.LOG, 'TRANSACTION FAILURE');
687: ELSE
688: l_con_status := 'SUCCESS';
689: l_be_message :=
690: 'Open Period Synchronization Process Successfully Completed for Ledger '

Line 696: fnd_file.put_line (fnd_file.LOG, 'SUCESSFULL TRANSACTION');

692: || ' Date Range Between '
693: || p_start_date
694: || ' and '
695: || p_end_date;
696: fnd_file.put_line (fnd_file.LOG, 'SUCESSFULL TRANSACTION');
697: END IF;
698: /*fnd_file.put_line( fnd_file.log,'');
699:
700: fnd_file.put_line( fnd_file.log,'GLPSL: **** RAISING '||l_con_Status||' BUSINESS EVENT ****');

Line 698: /*fnd_file.put_line( fnd_file.log,'');

694: || ' and '
695: || p_end_date;
696: fnd_file.put_line (fnd_file.LOG, 'SUCESSFULL TRANSACTION');
697: END IF;
698: /*fnd_file.put_line( fnd_file.log,'');
699:
700: fnd_file.put_line( fnd_file.log,'GLPSL: **** RAISING '||l_con_Status||' BUSINESS EVENT ****');
701:
702:

Line 700: fnd_file.put_line( fnd_file.log,'GLPSL: RAISING '||l_con_Status||' BUSINESS EVENT ');

696: fnd_file.put_line (fnd_file.LOG, 'SUCESSFULL TRANSACTION');
697: END IF;
698: /*fnd_file.put_line( fnd_file.log,'');
699:
700: fnd_file.put_line( fnd_file.log,'GLPSL: **** RAISING '||l_con_Status||' BUSINESS EVENT ****');
701:
702:
703: gl_business_events.raise(
704: p_event_name => 'oracle.apps.gl.ProcessPeriodStatus.complete',

Line 715: fnd_file.put_line

711: retcode := 2;
712: x_return_status := 'E';
713: errbuf :=
714: 'Given Start Date/ End Date Does not Match with the EBS Periods';
715: fnd_file.put_line
716: (fnd_file.LOG,
717: 'GLPSE: Given Start Date/ End Date Does not Match with the EBS Periods'
718: );
719: END IF;

Line 716: (fnd_file.LOG,

712: x_return_status := 'E';
713: errbuf :=
714: 'Given Start Date/ End Date Does not Match with the EBS Periods';
715: fnd_file.put_line
716: (fnd_file.LOG,
717: 'GLPSE: Given Start Date/ End Date Does not Match with the EBS Periods'
718: );
719: END IF;
720: ELSE

Line 724: fnd_file.put_line

720: ELSE
721: retcode := 2;
722: x_return_status := 'E';
723: errbuf := 'Strat Date is Greater Than End Date';
724: fnd_file.put_line
725: (fnd_file.LOG,
726: 'GLPSE: Given Start Date is Greater than Given End Date'
727: );
728: END IF;

Line 725: (fnd_file.LOG,

721: retcode := 2;
722: x_return_status := 'E';
723: errbuf := 'Strat Date is Greater Than End Date';
724: fnd_file.put_line
725: (fnd_file.LOG,
726: 'GLPSE: Given Start Date is Greater than Given End Date'
727: );
728: END IF;
729: ELSE

Line 733: fnd_file.put_line (fnd_file.LOG,

729: ELSE
730: retcode := 2;
731: x_return_status := 'E';
732: errbuf := 'Ledger short name is not valid';
733: fnd_file.put_line (fnd_file.LOG,
734: 'GLPSE: Given Ledger Short Name is not Valid'
735: );
736: END IF;
737:

Line 738: fnd_file.put_line (fnd_file.LOG, '');

734: 'GLPSE: Given Ledger Short Name is not Valid'
735: );
736: END IF;
737:
738: fnd_file.put_line (fnd_file.LOG, '');
739: fnd_file.put_line
740: (fnd_file.LOG,
741: '+---------------------------------------------------------------------------+'
742: );

Line 739: fnd_file.put_line

735: );
736: END IF;
737:
738: fnd_file.put_line (fnd_file.LOG, '');
739: fnd_file.put_line
740: (fnd_file.LOG,
741: '+---------------------------------------------------------------------------+'
742: );
743: fnd_file.put_line

Line 740: (fnd_file.LOG,

736: END IF;
737:
738: fnd_file.put_line (fnd_file.LOG, '');
739: fnd_file.put_line
740: (fnd_file.LOG,
741: '+---------------------------------------------------------------------------+'
742: );
743: fnd_file.put_line
744: (fnd_file.LOG,

Line 743: fnd_file.put_line

739: fnd_file.put_line
740: (fnd_file.LOG,
741: '+---------------------------------------------------------------------------+'
742: );
743: fnd_file.put_line
744: (fnd_file.LOG,
745: '+----------------------------------END--------------------------------------+'
746: );
747: fnd_file.put_line

Line 744: (fnd_file.LOG,

740: (fnd_file.LOG,
741: '+---------------------------------------------------------------------------+'
742: );
743: fnd_file.put_line
744: (fnd_file.LOG,
745: '+----------------------------------END--------------------------------------+'
746: );
747: fnd_file.put_line
748: (fnd_file.LOG,

Line 747: fnd_file.put_line

743: fnd_file.put_line
744: (fnd_file.LOG,
745: '+----------------------------------END--------------------------------------+'
746: );
747: fnd_file.put_line
748: (fnd_file.LOG,
749: '+---------------------------------------------------------------------------+'
750: );
751: EXCEPTION

Line 748: (fnd_file.LOG,

744: (fnd_file.LOG,
745: '+----------------------------------END--------------------------------------+'
746: );
747: fnd_file.put_line
748: (fnd_file.LOG,
749: '+---------------------------------------------------------------------------+'
750: );
751: EXCEPTION
752: WHEN OTHERS

Line 757: fnd_file.put_line (fnd_file.LOG, SQLERRM);

753: THEN
754: ROLLBACK;
755: retcode := 2;
756: x_return_status := 'E';
757: fnd_file.put_line (fnd_file.LOG, SQLERRM);
758: errbuf := fnd_message.get_string ('GL', 'GLPSE: Unexpected Error');
759: fnd_file.put_line (fnd_file.LOG, '');
760: fnd_file.put_line
761: (fnd_file.LOG,

Line 759: fnd_file.put_line (fnd_file.LOG, '');

755: retcode := 2;
756: x_return_status := 'E';
757: fnd_file.put_line (fnd_file.LOG, SQLERRM);
758: errbuf := fnd_message.get_string ('GL', 'GLPSE: Unexpected Error');
759: fnd_file.put_line (fnd_file.LOG, '');
760: fnd_file.put_line
761: (fnd_file.LOG,
762: '+---------------------------------------------------------------------------+'
763: );

Line 760: fnd_file.put_line

756: x_return_status := 'E';
757: fnd_file.put_line (fnd_file.LOG, SQLERRM);
758: errbuf := fnd_message.get_string ('GL', 'GLPSE: Unexpected Error');
759: fnd_file.put_line (fnd_file.LOG, '');
760: fnd_file.put_line
761: (fnd_file.LOG,
762: '+---------------------------------------------------------------------------+'
763: );
764: fnd_file.put_line

Line 761: (fnd_file.LOG,

757: fnd_file.put_line (fnd_file.LOG, SQLERRM);
758: errbuf := fnd_message.get_string ('GL', 'GLPSE: Unexpected Error');
759: fnd_file.put_line (fnd_file.LOG, '');
760: fnd_file.put_line
761: (fnd_file.LOG,
762: '+---------------------------------------------------------------------------+'
763: );
764: fnd_file.put_line
765: (fnd_file.LOG,

Line 764: fnd_file.put_line

760: fnd_file.put_line
761: (fnd_file.LOG,
762: '+---------------------------------------------------------------------------+'
763: );
764: fnd_file.put_line
765: (fnd_file.LOG,
766: '+----------------------------------END--------------------------------------+'
767: );
768: fnd_file.put_line

Line 765: (fnd_file.LOG,

761: (fnd_file.LOG,
762: '+---------------------------------------------------------------------------+'
763: );
764: fnd_file.put_line
765: (fnd_file.LOG,
766: '+----------------------------------END--------------------------------------+'
767: );
768: fnd_file.put_line
769: (fnd_file.LOG,

Line 768: fnd_file.put_line

764: fnd_file.put_line
765: (fnd_file.LOG,
766: '+----------------------------------END--------------------------------------+'
767: );
768: fnd_file.put_line
769: (fnd_file.LOG,
770: '+---------------------------------------------------------------------------+'
771: );
772: END period_status_sync;

Line 769: (fnd_file.LOG,

765: (fnd_file.LOG,
766: '+----------------------------------END--------------------------------------+'
767: );
768: fnd_file.put_line
769: (fnd_file.LOG,
770: '+---------------------------------------------------------------------------+'
771: );
772: END period_status_sync;
773: ------------********************************************************************---------------