DBA Data[Home] [Help]

APPS.JAI_FA_ASSETS_PKG dependencies on FND_FILE

Line 202: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');

198: );
199:
200: if lv_dev_phase = 'COMPLETE' then
201: if lv_dev_status <> 'NORMAL' then
202: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');
203: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || lv_message);
204: retcode := 1;
205: errbuf := 'Exiting with warningr as parent request not completed with normal status';
206: return;

Line 203: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || lv_message);

199:
200: if lv_dev_phase = 'COMPLETE' then
201: if lv_dev_status <> 'NORMAL' then
202: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');
203: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || lv_message);
204: retcode := 1;
205: errbuf := 'Exiting with warningr as parent request not completed with normal status';
206: return;
207: end if;

Line 212: Fnd_File.put_line(Fnd_File.LOG,

208: end if;
209:
210: end if; /* p_parent_request_id is not null */
211:
212: Fnd_File.put_line(Fnd_File.LOG,
213: 'Process Details for mass addition id / Invoice number / Distribution Line No / No of tax lines inserted :');
214:
215: for cur_rec_invoice_line in c_ja_in_fa_mass_additions(p_parent_request_id) loop
216:

Line 358: Fnd_File.put_line(Fnd_File.LOG,

354: process_message = lv_error_message,/*rchandan for bug#4428980*/
355: last_update_date = sysdate
356: where rowid = cur_rec_invoice_line.rowid;
357:
358: Fnd_File.put_line(Fnd_File.LOG,
359: ' Successful :' ||
360: to_char(cur_rec_invoice_line.mass_addition_id) || ' / ' ||
361: cur_rec_invoice_line.invoice_number || ' / ' ||
362: cur_rec_invoice_line.distribution_line_number || ' / ' ||

Line 379: Fnd_File.put_line(Fnd_File.LOG,

375: process_message = lv_error_message,
376: last_update_date = sysdate
377: where rowid = cur_rec_invoice_line.rowid;
378:
379: Fnd_File.put_line(Fnd_File.LOG,
380: '**** Processed with Error for mass addition id / Invoice number / Distribution Line No / Error :' ||
381: to_char(cur_rec_invoice_line.mass_addition_id) || ' / ' ||
382: cur_rec_invoice_line.invoice_number || ' / ' ||
383: cur_rec_invoice_line.distribution_line_number || ' / ' ||

Line 448: FND_FILE.PUT_LINE(FND_FILE.LOG,'********Start of Claiming Modvat for FA Retirement *********');

444: --------------------------------------------------------------------------------------------*/
445: V_DEBUG := jai_constants.yes ; --Ramananda for File.Sql.35
446:
447: IF V_DEBUG ='Y' THEN
448: FND_FILE.PUT_LINE(FND_FILE.LOG,'********Start of Claiming Modvat for FA Retirement *********');
449: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.0 The Value of p_organization_id:' ||p_organization_id
450: ||', p_location_id:' ||p_location_id||', p_receipt_num:' ||p_receipt_num
451: ||', p_shipment_line_id:' ||p_shipment_line_id||', p_booktype_id:' ||p_booktype_id
452: ||', p_asset_id:' ||p_asset_id);

Line 449: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.0 The Value of p_organization_id:' ||p_organization_id

445: V_DEBUG := jai_constants.yes ; --Ramananda for File.Sql.35
446:
447: IF V_DEBUG ='Y' THEN
448: FND_FILE.PUT_LINE(FND_FILE.LOG,'********Start of Claiming Modvat for FA Retirement *********');
449: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.0 The Value of p_organization_id:' ||p_organization_id
450: ||', p_location_id:' ||p_location_id||', p_receipt_num:' ||p_receipt_num
451: ||', p_shipment_line_id:' ||p_shipment_line_id||', p_booktype_id:' ||p_booktype_id
452: ||', p_asset_id:' ||p_asset_id);
453: END IF;

Line 465: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.5 The PO Number for the Asset is ' ||V_PO_NUMBER_ASSET);

461: LOOP
462: V_PO_NUMBER_ASSET := C_FETCH_PO_NUMBER.PO_NUMBER;
463: END LOOP;
464: IF V_DEBUG ='Y' THEN
465: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.5 The PO Number for the Asset is ' ||V_PO_NUMBER_ASSET);
466: END IF;
467: --Ends here for PO Number Asset
468: lv_transaction_type := 'RECEIVE'; --rchandan for bug#4428980
469: --This is for Fetching the PO Number for the Receipt Number...............

Line 488: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.6 The PO Number for the Receipt is ' ||V_PO_NUMBER_RECEIPT);

484: LOOP
485: V_PO_NUMBER_RECEIPT := C_FETCH_PO_NUMBER_RECEIPT.SEGMENT1;
486: END LOOP;
487: IF V_DEBUG ='Y' THEN
488: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.6 The PO Number for the Receipt is ' ||V_PO_NUMBER_RECEIPT);
489: END IF;
490: --Ends here for PO Number Asset
491: IF V_PO_NUMBER_ASSET <> V_PO_NUMBER_RECEIPT THEN
492: IF V_DEBUG ='Y' THEN

Line 493: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.61 The PO Numbers are not Matching hence further Processing will not be done');

489: END IF;
490: --Ends here for PO Number Asset
491: IF V_PO_NUMBER_ASSET <> V_PO_NUMBER_RECEIPT THEN
492: IF V_DEBUG ='Y' THEN
493: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.61 The PO Numbers are not Matching hence further Processing will not be done');
494: END IF;
495: END IF;
496:
497: IF V_PO_NUMBER_ASSET = V_PO_NUMBER_RECEIPT THEN

Line 519: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.7 shipment_line_id:' ||cur_rec.shipment_line_id

515: and shipment_line_id =p_shipment_line_id
516: )
517: LOOP
518: IF V_DEBUG ='Y' THEN
519: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.7 shipment_line_id:' ||cur_rec.shipment_line_id
520: ||', quantity:' ||cur_rec.quantity||', transaction_id:' ||cur_rec.transaction_id);
521: END IF;
522:
523: /*Commented. Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.

Line 541: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.2 After Update of JAI_RCV_CENVAT_CLAIMS');

537: RAISE_APPLICATION_ERROR(-20010,'Exception Raised in Updation of JAI_RCV_CENVAT_CLAIMS ' || SQLERRM) ;
538: END;
539:
540: IF V_DEBUG ='Y' THEN
541: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.2 After Update of JAI_RCV_CENVAT_CLAIMS');
542: END IF;
543: */
544:
545: BEGIN

Line 547: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.3 Before Insert into JAI_RCV_CENVAT_CLAIM_T');

543: */
544:
545: BEGIN
546: IF V_DEBUG ='Y' THEN
547: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.3 Before Insert into JAI_RCV_CENVAT_CLAIM_T');
548: END IF;
549:
550:
551: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.

Line 618: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.4 After Insert into ja_in_temp_mod_params');

614: RAISE_APPLICATION_ERROR(-20010,'Exception Raised in Insert of JA_IN_TEMP_MOD_PARAMS ' || SQLERRM) ;
615: END;
616:
617: IF V_DEBUG ='Y' THEN
618: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.4 After Insert into ja_in_temp_mod_params');
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.5 Before Claim Modvat Process is called');
620: END IF;
621:
622: /*

Line 619: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.5 Before Claim Modvat Process is called');

615: END;
616:
617: IF V_DEBUG ='Y' THEN
618: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.4 After Insert into ja_in_temp_mod_params');
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.5 Before Claim Modvat Process is called');
620: END IF;
621:
622: /*
623: JA_IN_CLAIM_MODVAT_PROCESS(V_ERRBUF,

Line 659: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.6 After Claim Modvat Process Procedure');

655: RAISE_APPLICATION_ERROR(-20111, 'Problem in invocation to jai_rcv_trx_processing_pkg.process_batch.');
656: end if;
657:
658: IF V_DEBUG ='Y' THEN
659: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.6 After Claim Modvat Process Procedure');
660: END IF;
661:
662: END IF; --End If for comparison of PO Numbers
663: