DBA Data[Home] [Help]

APPS.JAI_FA_ASSETS_PKG dependencies on FND_FILE

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

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

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

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

Line 211: Fnd_File.put_line(Fnd_File.LOG,

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

Line 352: Fnd_File.put_line(Fnd_File.LOG,

348: process_message = lv_error_message,/*rchandan for bug#4428980*/
349: last_update_date = sysdate
350: where rowid = cur_rec_invoice_line.rowid;
351:
352: Fnd_File.put_line(Fnd_File.LOG,
353: ' Successful :' ||
354: to_char(cur_rec_invoice_line.mass_addition_id) || ' / ' ||
355: cur_rec_invoice_line.invoice_number || ' / ' ||
356: cur_rec_invoice_line.distribution_line_number || ' / ' ||

Line 373: Fnd_File.put_line(Fnd_File.LOG,

369: process_message = lv_error_message,
370: last_update_date = sysdate
371: where rowid = cur_rec_invoice_line.rowid;
372:
373: Fnd_File.put_line(Fnd_File.LOG,
374: '**** Processed with Error for mass addition id / Invoice number / Distribution Line No / Error :' ||
375: to_char(cur_rec_invoice_line.mass_addition_id) || ' / ' ||
376: cur_rec_invoice_line.invoice_number || ' / ' ||
377: cur_rec_invoice_line.distribution_line_number || ' / ' ||

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

438: --------------------------------------------------------------------------------------------*/
439: V_DEBUG := jai_constants.yes ; --Ramananda for File.Sql.35
440:
441: IF V_DEBUG ='Y' THEN
442: FND_FILE.PUT_LINE(FND_FILE.LOG,'********Start of Claiming Modvat for FA Retirement *********');
443: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.0 The Value of p_organization_id:' ||p_organization_id
444: ||', p_location_id:' ||p_location_id||', p_receipt_num:' ||p_receipt_num
445: ||', p_shipment_line_id:' ||p_shipment_line_id||', p_booktype_id:' ||p_booktype_id
446: ||', p_asset_id:' ||p_asset_id);

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

439: V_DEBUG := jai_constants.yes ; --Ramananda for File.Sql.35
440:
441: IF V_DEBUG ='Y' THEN
442: FND_FILE.PUT_LINE(FND_FILE.LOG,'********Start of Claiming Modvat for FA Retirement *********');
443: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.0 The Value of p_organization_id:' ||p_organization_id
444: ||', p_location_id:' ||p_location_id||', p_receipt_num:' ||p_receipt_num
445: ||', p_shipment_line_id:' ||p_shipment_line_id||', p_booktype_id:' ||p_booktype_id
446: ||', p_asset_id:' ||p_asset_id);
447: END IF;

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

455: LOOP
456: V_PO_NUMBER_ASSET := C_FETCH_PO_NUMBER.PO_NUMBER;
457: END LOOP;
458: IF V_DEBUG ='Y' THEN
459: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.5 The PO Number for the Asset is ' ||V_PO_NUMBER_ASSET);
460: END IF;
461: --Ends here for PO Number Asset
462: lv_transaction_type := 'RECEIVE'; --rchandan for bug#4428980
463: --This is for Fetching the PO Number for the Receipt Number...............

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

478: LOOP
479: V_PO_NUMBER_RECEIPT := C_FETCH_PO_NUMBER_RECEIPT.SEGMENT1;
480: END LOOP;
481: IF V_DEBUG ='Y' THEN
482: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.6 The PO Number for the Receipt is ' ||V_PO_NUMBER_RECEIPT);
483: END IF;
484: --Ends here for PO Number Asset
485: IF V_PO_NUMBER_ASSET <> V_PO_NUMBER_RECEIPT THEN
486: IF V_DEBUG ='Y' THEN

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

483: END IF;
484: --Ends here for PO Number Asset
485: IF V_PO_NUMBER_ASSET <> V_PO_NUMBER_RECEIPT THEN
486: IF V_DEBUG ='Y' THEN
487: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.61 The PO Numbers are not Matching hence further Processing will not be done');
488: END IF;
489: END IF;
490:
491: IF V_PO_NUMBER_ASSET = V_PO_NUMBER_RECEIPT THEN

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

509: and shipment_line_id =p_shipment_line_id
510: )
511: LOOP
512: IF V_DEBUG ='Y' THEN
513: FND_FILE.PUT_LINE(FND_FILE.LOG,'1.7 shipment_line_id:' ||cur_rec.shipment_line_id
514: ||', quantity:' ||cur_rec.quantity||', transaction_id:' ||cur_rec.transaction_id);
515: END IF;
516:
517: /*Commented. Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.

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

531: RAISE_APPLICATION_ERROR(-20010,'Exception Raised in Updation of JAI_RCV_CENVAT_CLAIMS ' || SQLERRM) ;
532: END;
533:
534: IF V_DEBUG ='Y' THEN
535: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.2 After Update of JAI_RCV_CENVAT_CLAIMS');
536: END IF;
537: */
538:
539: BEGIN

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

537: */
538:
539: BEGIN
540: IF V_DEBUG ='Y' THEN
541: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.3 Before Insert into JAI_RCV_CENVAT_CLAIM_T');
542: END IF;
543:
544:
545: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.

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

608: RAISE_APPLICATION_ERROR(-20010,'Exception Raised in Insert of JA_IN_TEMP_MOD_PARAMS ' || SQLERRM) ;
609: END;
610:
611: IF V_DEBUG ='Y' THEN
612: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.4 After Insert into ja_in_temp_mod_params');
613: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.5 Before Claim Modvat Process is called');
614: END IF;
615:
616: /*

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

609: END;
610:
611: IF V_DEBUG ='Y' THEN
612: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.4 After Insert into ja_in_temp_mod_params');
613: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.5 Before Claim Modvat Process is called');
614: END IF;
615:
616: /*
617: JA_IN_CLAIM_MODVAT_PROCESS(V_ERRBUF,

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

649: RAISE_APPLICATION_ERROR(-20111, 'Problem in invocation to jai_rcv_trx_processing_pkg.process_batch.');
650: end if;
651:
652: IF V_DEBUG ='Y' THEN
653: FND_FILE.PUT_LINE(FND_FILE.LOG,'2.6 After Claim Modvat Process Procedure');
654: END IF;
655:
656: END IF; --End If for comparison of PO Numbers
657: