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

Line 175: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

171:
172: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
173: fnd_message.set_token('ROUTINE',l_proc);
174: fnd_message.set_token('REASON',SQLERRM);
175: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
176: End ;
177:
178:
179: ----This procecure is added for rules migration, conversion data now resides in okc_k_headers_b

Line 287: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

283:
284: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
285: fnd_message.set_token('ROUTINE',l_proc);
286: fnd_message.set_token('REASON',SQLERRM);
287: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
288:
289: END;
290:
291:

Line 339: fnd_file.put_line(FND_FILE.LOG,'Trace Mode is Enabled');

335:
336: p_update_mode_yn := nvl(p_update_yn,'N');
337: IF NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y' THEN
338: okc_util.init_trace;
339: fnd_file.put_line(FND_FILE.LOG,'Trace Mode is Enabled');
340: END IF;
341:
342: IF (l_debug = 'Y') THEN
343: okc_debug.Set_Indentation('OKC_EURO_CONV_PUB');

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

343: okc_debug.Set_Indentation('OKC_EURO_CONV_PUB');
344: okc_debug.log('900: Entered CONVERT_CONTRACTS', 2);
345: END IF;
346:
347: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
348: fnd_file.put_line(FND_FILE.LOG,' Starting Concurrent Program ... ');
349: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
350: fnd_file.put_line(FND_FILE.LOG,' ');
351: fnd_file.put_line(FND_FILE.LOG,' ');

Line 348: fnd_file.put_line(FND_FILE.LOG,' Starting Concurrent Program ... ');

344: okc_debug.log('900: Entered CONVERT_CONTRACTS', 2);
345: END IF;
346:
347: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
348: fnd_file.put_line(FND_FILE.LOG,' Starting Concurrent Program ... ');
349: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
350: fnd_file.put_line(FND_FILE.LOG,' ');
351: fnd_file.put_line(FND_FILE.LOG,' ');
352: -- log session details

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

345: END IF;
346:
347: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
348: fnd_file.put_line(FND_FILE.LOG,' Starting Concurrent Program ... ');
349: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
350: fnd_file.put_line(FND_FILE.LOG,' ');
351: fnd_file.put_line(FND_FILE.LOG,' ');
352: -- log session details
353: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');

Line 350: fnd_file.put_line(FND_FILE.LOG,' ');

346:
347: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
348: fnd_file.put_line(FND_FILE.LOG,' Starting Concurrent Program ... ');
349: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
350: fnd_file.put_line(FND_FILE.LOG,' ');
351: fnd_file.put_line(FND_FILE.LOG,' ');
352: -- log session details
353: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');
354: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);

Line 351: fnd_file.put_line(FND_FILE.LOG,' ');

347: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
348: fnd_file.put_line(FND_FILE.LOG,' Starting Concurrent Program ... ');
349: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
350: fnd_file.put_line(FND_FILE.LOG,' ');
351: fnd_file.put_line(FND_FILE.LOG,' ');
352: -- log session details
353: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');
354: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
355: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);

Line 353: fnd_file.put_line(FND_FILE.LOG,' DATABASE TRACE INFORMATION***** ');

349: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
350: fnd_file.put_line(FND_FILE.LOG,' ');
351: fnd_file.put_line(FND_FILE.LOG,' ');
352: -- log session details
353: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');
354: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
355: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);
356: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
357: fnd_file.put_line(FND_FILE.LOG,' ');

Line 354: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);

350: fnd_file.put_line(FND_FILE.LOG,' ');
351: fnd_file.put_line(FND_FILE.LOG,' ');
352: -- log session details
353: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');
354: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
355: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);
356: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
357: fnd_file.put_line(FND_FILE.LOG,' ');
358: fnd_file.put_line(FND_FILE.LOG,' ');

Line 355: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);

351: fnd_file.put_line(FND_FILE.LOG,' ');
352: -- log session details
353: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');
354: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
355: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);
356: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
357: fnd_file.put_line(FND_FILE.LOG,' ');
358: fnd_file.put_line(FND_FILE.LOG,' ');
359:

Line 356: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');

352: -- log session details
353: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');
354: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
355: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);
356: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
357: fnd_file.put_line(FND_FILE.LOG,' ');
358: fnd_file.put_line(FND_FILE.LOG,' ');
359:
360: -- log messages with parameters

Line 357: fnd_file.put_line(FND_FILE.LOG,' ');

353: fnd_file.put_line(FND_FILE.LOG,' ********** DATABASE TRACE INFORMATION*************** ');
354: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
355: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);
356: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
357: fnd_file.put_line(FND_FILE.LOG,' ');
358: fnd_file.put_line(FND_FILE.LOG,' ');
359:
360: -- log messages with parameters
361: fnd_file.put_line(FND_FILE.LOG,' ********* Program Parameters **************** ');

Line 358: fnd_file.put_line(FND_FILE.LOG,' ');

354: fnd_file.put_line(FND_FILE.LOG,'User id : '||fnd_global.user_id);
355: fnd_file.put_line(FND_FILE.LOG,'Conc Req id : '||fnd_global.conc_request_id);
356: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
357: fnd_file.put_line(FND_FILE.LOG,' ');
358: fnd_file.put_line(FND_FILE.LOG,' ');
359:
360: -- log messages with parameters
361: fnd_file.put_line(FND_FILE.LOG,' ********* Program Parameters **************** ');
362: fnd_file.put_line(FND_FILE.LOG,' Update Mode :'||p_update_mode_yn);

Line 361: fnd_file.put_line(FND_FILE.LOG,' * Program Parameters ******** ');

357: fnd_file.put_line(FND_FILE.LOG,' ');
358: fnd_file.put_line(FND_FILE.LOG,' ');
359:
360: -- log messages with parameters
361: fnd_file.put_line(FND_FILE.LOG,' ********* Program Parameters **************** ');
362: fnd_file.put_line(FND_FILE.LOG,' Update Mode :'||p_update_mode_yn);
363: fnd_file.put_line(FND_FILE.LOG,' Conversion Date :'||p_conversion_date);
364: fnd_file.put_line(FND_FILE.LOG,' Conversion Type :'||p_conversion_type);
365: fnd_file.put_line(FND_FILE.LOG,' Organization Id :'||p_org_id);

Line 362: fnd_file.put_line(FND_FILE.LOG,' Update Mode :'||p_update_mode_yn);

358: fnd_file.put_line(FND_FILE.LOG,' ');
359:
360: -- log messages with parameters
361: fnd_file.put_line(FND_FILE.LOG,' ********* Program Parameters **************** ');
362: fnd_file.put_line(FND_FILE.LOG,' Update Mode :'||p_update_mode_yn);
363: fnd_file.put_line(FND_FILE.LOG,' Conversion Date :'||p_conversion_date);
364: fnd_file.put_line(FND_FILE.LOG,' Conversion Type :'||p_conversion_type);
365: fnd_file.put_line(FND_FILE.LOG,' Organization Id :'||p_org_id);
366: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');

Line 363: fnd_file.put_line(FND_FILE.LOG,' Conversion Date :'||p_conversion_date);

359:
360: -- log messages with parameters
361: fnd_file.put_line(FND_FILE.LOG,' ********* Program Parameters **************** ');
362: fnd_file.put_line(FND_FILE.LOG,' Update Mode :'||p_update_mode_yn);
363: fnd_file.put_line(FND_FILE.LOG,' Conversion Date :'||p_conversion_date);
364: fnd_file.put_line(FND_FILE.LOG,' Conversion Type :'||p_conversion_type);
365: fnd_file.put_line(FND_FILE.LOG,' Organization Id :'||p_org_id);
366: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
367: fnd_file.put_line(FND_FILE.LOG,' ');

Line 364: fnd_file.put_line(FND_FILE.LOG,' Conversion Type :'||p_conversion_type);

360: -- log messages with parameters
361: fnd_file.put_line(FND_FILE.LOG,' ********* Program Parameters **************** ');
362: fnd_file.put_line(FND_FILE.LOG,' Update Mode :'||p_update_mode_yn);
363: fnd_file.put_line(FND_FILE.LOG,' Conversion Date :'||p_conversion_date);
364: fnd_file.put_line(FND_FILE.LOG,' Conversion Type :'||p_conversion_type);
365: fnd_file.put_line(FND_FILE.LOG,' Organization Id :'||p_org_id);
366: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
367: fnd_file.put_line(FND_FILE.LOG,' ');
368:

Line 365: fnd_file.put_line(FND_FILE.LOG,' Organization Id :'||p_org_id);

361: fnd_file.put_line(FND_FILE.LOG,' ********* Program Parameters **************** ');
362: fnd_file.put_line(FND_FILE.LOG,' Update Mode :'||p_update_mode_yn);
363: fnd_file.put_line(FND_FILE.LOG,' Conversion Date :'||p_conversion_date);
364: fnd_file.put_line(FND_FILE.LOG,' Conversion Type :'||p_conversion_type);
365: fnd_file.put_line(FND_FILE.LOG,' Organization Id :'||p_org_id);
366: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
367: fnd_file.put_line(FND_FILE.LOG,' ');
368:
369: fnd_file.put_line(FND_FILE.OUTPUT,' ********* Program Parameters **************** ');

Line 366: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');

362: fnd_file.put_line(FND_FILE.LOG,' Update Mode :'||p_update_mode_yn);
363: fnd_file.put_line(FND_FILE.LOG,' Conversion Date :'||p_conversion_date);
364: fnd_file.put_line(FND_FILE.LOG,' Conversion Type :'||p_conversion_type);
365: fnd_file.put_line(FND_FILE.LOG,' Organization Id :'||p_org_id);
366: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
367: fnd_file.put_line(FND_FILE.LOG,' ');
368:
369: fnd_file.put_line(FND_FILE.OUTPUT,' ********* Program Parameters **************** ');
370: fnd_file.put_line(FND_FILE.OUTPUT,' Update Mode :'||p_update_mode_yn);

Line 367: fnd_file.put_line(FND_FILE.LOG,' ');

363: fnd_file.put_line(FND_FILE.LOG,' Conversion Date :'||p_conversion_date);
364: fnd_file.put_line(FND_FILE.LOG,' Conversion Type :'||p_conversion_type);
365: fnd_file.put_line(FND_FILE.LOG,' Organization Id :'||p_org_id);
366: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
367: fnd_file.put_line(FND_FILE.LOG,' ');
368:
369: fnd_file.put_line(FND_FILE.OUTPUT,' ********* Program Parameters **************** ');
370: fnd_file.put_line(FND_FILE.OUTPUT,' Update Mode :'||p_update_mode_yn);
371: fnd_file.put_line(FND_FILE.OUTPUT,' Conversion Date :'||p_conversion_date);

Line 369: fnd_file.put_line(FND_FILE.OUTPUT,' * Program Parameters ******** ');

365: fnd_file.put_line(FND_FILE.LOG,' Organization Id :'||p_org_id);
366: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
367: fnd_file.put_line(FND_FILE.LOG,' ');
368:
369: fnd_file.put_line(FND_FILE.OUTPUT,' ********* Program Parameters **************** ');
370: fnd_file.put_line(FND_FILE.OUTPUT,' Update Mode :'||p_update_mode_yn);
371: fnd_file.put_line(FND_FILE.OUTPUT,' Conversion Date :'||p_conversion_date);
372: fnd_file.put_line(FND_FILE.OUTPUT,' Conversion Type :'||p_conversion_type);
373: fnd_file.put_line(FND_FILE.OUTPUT,' Organization Id :'||p_org_id);

Line 370: fnd_file.put_line(FND_FILE.OUTPUT,' Update Mode :'||p_update_mode_yn);

366: fnd_file.put_line(FND_FILE.LOG,' **************************************************** ');
367: fnd_file.put_line(FND_FILE.LOG,' ');
368:
369: fnd_file.put_line(FND_FILE.OUTPUT,' ********* Program Parameters **************** ');
370: fnd_file.put_line(FND_FILE.OUTPUT,' Update Mode :'||p_update_mode_yn);
371: fnd_file.put_line(FND_FILE.OUTPUT,' Conversion Date :'||p_conversion_date);
372: fnd_file.put_line(FND_FILE.OUTPUT,' Conversion Type :'||p_conversion_type);
373: fnd_file.put_line(FND_FILE.OUTPUT,' Organization Id :'||p_org_id);
374: fnd_file.put_line(FND_FILE.OUTPUT,' ************************************************ ');

Line 371: fnd_file.put_line(FND_FILE.OUTPUT,' Conversion Date :'||p_conversion_date);

367: fnd_file.put_line(FND_FILE.LOG,' ');
368:
369: fnd_file.put_line(FND_FILE.OUTPUT,' ********* Program Parameters **************** ');
370: fnd_file.put_line(FND_FILE.OUTPUT,' Update Mode :'||p_update_mode_yn);
371: fnd_file.put_line(FND_FILE.OUTPUT,' Conversion Date :'||p_conversion_date);
372: fnd_file.put_line(FND_FILE.OUTPUT,' Conversion Type :'||p_conversion_type);
373: fnd_file.put_line(FND_FILE.OUTPUT,' Organization Id :'||p_org_id);
374: fnd_file.put_line(FND_FILE.OUTPUT,' ************************************************ ');
375:

Line 372: fnd_file.put_line(FND_FILE.OUTPUT,' Conversion Type :'||p_conversion_type);

368:
369: fnd_file.put_line(FND_FILE.OUTPUT,' ********* Program Parameters **************** ');
370: fnd_file.put_line(FND_FILE.OUTPUT,' Update Mode :'||p_update_mode_yn);
371: fnd_file.put_line(FND_FILE.OUTPUT,' Conversion Date :'||p_conversion_date);
372: fnd_file.put_line(FND_FILE.OUTPUT,' Conversion Type :'||p_conversion_type);
373: fnd_file.put_line(FND_FILE.OUTPUT,' Organization Id :'||p_org_id);
374: fnd_file.put_line(FND_FILE.OUTPUT,' ************************************************ ');
375:
376: IF (l_debug = 'Y') THEN

Line 373: fnd_file.put_line(FND_FILE.OUTPUT,' Organization Id :'||p_org_id);

369: fnd_file.put_line(FND_FILE.OUTPUT,' ********* Program Parameters **************** ');
370: fnd_file.put_line(FND_FILE.OUTPUT,' Update Mode :'||p_update_mode_yn);
371: fnd_file.put_line(FND_FILE.OUTPUT,' Conversion Date :'||p_conversion_date);
372: fnd_file.put_line(FND_FILE.OUTPUT,' Conversion Type :'||p_conversion_type);
373: fnd_file.put_line(FND_FILE.OUTPUT,' Organization Id :'||p_org_id);
374: fnd_file.put_line(FND_FILE.OUTPUT,' ************************************************ ');
375:
376: IF (l_debug = 'Y') THEN
377: okc_debug.Log('20: p_org_id : '||p_org_id,2);

Line 374: fnd_file.put_line(FND_FILE.OUTPUT,' ************************************************ ');

370: fnd_file.put_line(FND_FILE.OUTPUT,' Update Mode :'||p_update_mode_yn);
371: fnd_file.put_line(FND_FILE.OUTPUT,' Conversion Date :'||p_conversion_date);
372: fnd_file.put_line(FND_FILE.OUTPUT,' Conversion Type :'||p_conversion_type);
373: fnd_file.put_line(FND_FILE.OUTPUT,' Organization Id :'||p_org_id);
374: fnd_file.put_line(FND_FILE.OUTPUT,' ************************************************ ');
375:
376: IF (l_debug = 'Y') THEN
377: okc_debug.Log('20: p_org_id : '||p_org_id,2);
378: okc_debug.Log('20: p_conversion_date : '||p_conversion_date,2);

Line 412: fnd_file.put_line(FND_FILE.OUTPUT,' ');

408: Else
409: l_report_title:='CONTRACTS TO BE PROCESSED FOR EURO CONVERSION';
410: l_upgrade_status_hdr:='Upgrade changes Needed';
411: End If;
412: fnd_file.put_line(FND_FILE.OUTPUT,' ');
413: fnd_file.put_line(FND_FILE.OUTPUT,' ');
414: fnd_file.put_line(FND_FILE.OUTPUT,lpad(l_report_title,90));
415: fnd_file.put_line(FND_FILE.OUTPUT,' ');
416: fnd_file.put_line(FND_FILE.OUTPUT,' ');

Line 413: fnd_file.put_line(FND_FILE.OUTPUT,' ');

409: l_report_title:='CONTRACTS TO BE PROCESSED FOR EURO CONVERSION';
410: l_upgrade_status_hdr:='Upgrade changes Needed';
411: End If;
412: fnd_file.put_line(FND_FILE.OUTPUT,' ');
413: fnd_file.put_line(FND_FILE.OUTPUT,' ');
414: fnd_file.put_line(FND_FILE.OUTPUT,lpad(l_report_title,90));
415: fnd_file.put_line(FND_FILE.OUTPUT,' ');
416: fnd_file.put_line(FND_FILE.OUTPUT,' ');
417: fnd_file.put_line(FND_FILE.OUTPUT,

Line 414: fnd_file.put_line(FND_FILE.OUTPUT,lpad(l_report_title,90));

410: l_upgrade_status_hdr:='Upgrade changes Needed';
411: End If;
412: fnd_file.put_line(FND_FILE.OUTPUT,' ');
413: fnd_file.put_line(FND_FILE.OUTPUT,' ');
414: fnd_file.put_line(FND_FILE.OUTPUT,lpad(l_report_title,90));
415: fnd_file.put_line(FND_FILE.OUTPUT,' ');
416: fnd_file.put_line(FND_FILE.OUTPUT,' ');
417: fnd_file.put_line(FND_FILE.OUTPUT,
418: '-----------------------------------------------------------------------------------------------------------------------------');

Line 415: fnd_file.put_line(FND_FILE.OUTPUT,' ');

411: End If;
412: fnd_file.put_line(FND_FILE.OUTPUT,' ');
413: fnd_file.put_line(FND_FILE.OUTPUT,' ');
414: fnd_file.put_line(FND_FILE.OUTPUT,lpad(l_report_title,90));
415: fnd_file.put_line(FND_FILE.OUTPUT,' ');
416: fnd_file.put_line(FND_FILE.OUTPUT,' ');
417: fnd_file.put_line(FND_FILE.OUTPUT,
418: '-----------------------------------------------------------------------------------------------------------------------------');
419: fnd_file.put_line(FND_FILE.OUTPUT,

Line 416: fnd_file.put_line(FND_FILE.OUTPUT,' ');

412: fnd_file.put_line(FND_FILE.OUTPUT,' ');
413: fnd_file.put_line(FND_FILE.OUTPUT,' ');
414: fnd_file.put_line(FND_FILE.OUTPUT,lpad(l_report_title,90));
415: fnd_file.put_line(FND_FILE.OUTPUT,' ');
416: fnd_file.put_line(FND_FILE.OUTPUT,' ');
417: fnd_file.put_line(FND_FILE.OUTPUT,
418: '-----------------------------------------------------------------------------------------------------------------------------');
419: fnd_file.put_line(FND_FILE.OUTPUT,
420: rpad('Contract Number',30)||rpad('Modifier',20)||rpad('Currency Code',15)||rpad('Status',10)||

Line 417: fnd_file.put_line(FND_FILE.OUTPUT,

413: fnd_file.put_line(FND_FILE.OUTPUT,' ');
414: fnd_file.put_line(FND_FILE.OUTPUT,lpad(l_report_title,90));
415: fnd_file.put_line(FND_FILE.OUTPUT,' ');
416: fnd_file.put_line(FND_FILE.OUTPUT,' ');
417: fnd_file.put_line(FND_FILE.OUTPUT,
418: '-----------------------------------------------------------------------------------------------------------------------------');
419: fnd_file.put_line(FND_FILE.OUTPUT,
420: rpad('Contract Number',30)||rpad('Modifier',20)||rpad('Currency Code',15)||rpad('Status',10)||
421: rpad('Start_date',15)||rpad('End date',15)||rpad(l_upgrade_status_hdr,30));

Line 419: fnd_file.put_line(FND_FILE.OUTPUT,

415: fnd_file.put_line(FND_FILE.OUTPUT,' ');
416: fnd_file.put_line(FND_FILE.OUTPUT,' ');
417: fnd_file.put_line(FND_FILE.OUTPUT,
418: '-----------------------------------------------------------------------------------------------------------------------------');
419: fnd_file.put_line(FND_FILE.OUTPUT,
420: rpad('Contract Number',30)||rpad('Modifier',20)||rpad('Currency Code',15)||rpad('Status',10)||
421: rpad('Start_date',15)||rpad('End date',15)||rpad(l_upgrade_status_hdr,30));
422:
423: fnd_file.put_line(FND_FILE.OUTPUT,

Line 423: fnd_file.put_line(FND_FILE.OUTPUT,

419: fnd_file.put_line(FND_FILE.OUTPUT,
420: rpad('Contract Number',30)||rpad('Modifier',20)||rpad('Currency Code',15)||rpad('Status',10)||
421: rpad('Start_date',15)||rpad('End date',15)||rpad(l_upgrade_status_hdr,30));
422:
423: fnd_file.put_line(FND_FILE.OUTPUT,
424: '=============================================================================================================================');
425: FOR contracts_rec IN contracts_csr LOOP
426: --- Check if contract eligible for conversion
427: --dbms_output.put_line(contracts_rec.contract_number);

Line 442: /* fnd_file.put_line(FND_FILE.OUTPUT,contracts_rec.contract_number,20) ||

438: ' Currency: ' || contracts_rec.currency_code ||
439: ' Status: ' || contracts_rec.sts_code), 2);
440: END IF;
441:
442: /* fnd_file.put_line(FND_FILE.OUTPUT,contracts_rec.contract_number,20) ||
443: ', '|| contracts_rec.contract_number_modifier ||
444: ', '|| contracts_rec.currency_code ||
445: ', '|| contracts_rec.sts_code);*/
446:

Line 465: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

461: END IF;
462: Else
463: fnd_message.set_name('OKC','OKC_K_CONV_ERROR');
464: fnd_message.set_token('CONTRACT_NUMBER',contracts_rec.contract_number);
465: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
466: IF (l_debug = 'Y') THEN
467: okc_debug.log('1100: Record not Updated ', 2);
468: END IF;
469: k_failure_counter := k_failure_counter+1;

Line 492: fnd_file.put_line(FND_FILE.OUTPUT,rpad(contracts_rec.contract_number,30)||

488: 'A','No Conversion data ','N','No change required'))
489: into l_upgrade_status
490: from dual;
491:
492: fnd_file.put_line(FND_FILE.OUTPUT,rpad(contracts_rec.contract_number,30)||
493: substr(rpad(nvl(contracts_rec.contract_number_modifier,'X'),21),2)||
494: rpad(contracts_rec.currency_code,15)||
495: rpad(contracts_rec.sts_code,10)||
496: rpad(contracts_rec.start_date,15)||

Line 504: fnd_file.put_line(FND_FILE.OUTPUT,

500:
501: END LOOP;
502:
503:
504: fnd_file.put_line(FND_FILE.OUTPUT,
505: '----------------------------------------------------------------------------------------------------------------------------');
506: fnd_file.put_line(FND_FILE.OUTPUT,'Total Contracts processed : '||k1_counter);
507: fnd_file.put_line(FND_FILE.LOG,'Total Contracts processed : '||k1_counter);
508:

Line 506: fnd_file.put_line(FND_FILE.OUTPUT,'Total Contracts processed : '||k1_counter);

502:
503:
504: fnd_file.put_line(FND_FILE.OUTPUT,
505: '----------------------------------------------------------------------------------------------------------------------------');
506: fnd_file.put_line(FND_FILE.OUTPUT,'Total Contracts processed : '||k1_counter);
507: fnd_file.put_line(FND_FILE.LOG,'Total Contracts processed : '||k1_counter);
508:
509: IF (l_debug = 'Y') THEN
510: okc_debug.log('1115: After LOOP' || 'Contracts proccessed' ,2);

Line 507: fnd_file.put_line(FND_FILE.LOG,'Total Contracts processed : '||k1_counter);

503:
504: fnd_file.put_line(FND_FILE.OUTPUT,
505: '----------------------------------------------------------------------------------------------------------------------------');
506: fnd_file.put_line(FND_FILE.OUTPUT,'Total Contracts processed : '||k1_counter);
507: fnd_file.put_line(FND_FILE.LOG,'Total Contracts processed : '||k1_counter);
508:
509: IF (l_debug = 'Y') THEN
510: okc_debug.log('1115: After LOOP' || 'Contracts proccessed' ,2);
511: END IF;

Line 514: fnd_file.put_line(FND_FILE.OUTPUT,'Number of Contracts - Success: '||k_success_counter);

510: okc_debug.log('1115: After LOOP' || 'Contracts proccessed' ,2);
511: END IF;
512:
513: If p_update_mode_yn = 'Y' then
514: fnd_file.put_line(FND_FILE.OUTPUT,'Number of Contracts - Success: '||k_success_counter);
515: fnd_file.put_line(FND_FILE.OUTPUT,'Number of Contracts - Failure: '||k_failure_counter);
516: commit;
517: End If;
518:

Line 515: fnd_file.put_line(FND_FILE.OUTPUT,'Number of Contracts - Failure: '||k_failure_counter);

511: END IF;
512:
513: If p_update_mode_yn = 'Y' then
514: fnd_file.put_line(FND_FILE.OUTPUT,'Number of Contracts - Success: '||k_success_counter);
515: fnd_file.put_line(FND_FILE.OUTPUT,'Number of Contracts - Failure: '||k_failure_counter);
516: commit;
517: End If;
518:
519: IF (l_debug = 'Y') THEN

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

519: IF (l_debug = 'Y') THEN
520: okc_debug.log('1100: ' || k1_counter || 'Contracts Processed' ,2);
521: END IF;
522:
523: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
524: fnd_file.put_line(FND_FILE.LOG,'Completed Concurrent Program. ');
525: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
526:
527: IF NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y' THEN

Line 524: fnd_file.put_line(FND_FILE.LOG,'Completed Concurrent Program. ');

520: okc_debug.log('1100: ' || k1_counter || 'Contracts Processed' ,2);
521: END IF;
522:
523: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
524: fnd_file.put_line(FND_FILE.LOG,'Completed Concurrent Program. ');
525: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
526:
527: IF NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y' THEN
528: okc_util.stop_trace;

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

521: END IF;
522:
523: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
524: fnd_file.put_line(FND_FILE.LOG,'Completed Concurrent Program. ');
525: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
526:
527: IF NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y' THEN
528: okc_util.stop_trace;
529: END IF;

Line 547: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

543: okc_debug.Reset_Indentation;
544: END IF;
545:
546: fnd_message.set_name('OKC','OKC_CONV_NOT_REQD');
547: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
548:
549: WHEN others THEN
550:
551: IF (l_debug = 'Y') THEN

Line 559: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

555:
556: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
557: fnd_message.set_token('ROUTINE',l_proc);
558: fnd_message.set_token('REASON',SQLERRM);
559: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
560: raise;
561:
562:
563: END CONVERT_CONTRACTS;