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

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

343:
344: lv_process_message := 'Check tax amount difference between JAI LINE and OE order Line.'
345: || 'Order Header ID: '||header_check_rec.header_id
346: || ', Check Result: ' ||lv_tax_difference_flag;
347: fnd_file.put_line(FND_FILE.LOG,lv_process_message);
348:
349: -- IF any tax amount in JAI LINE is different from the TAX AMOUNT of ORDER LINE
350: -- Then below program will synchronize the jai TAX amount to OE_ORDRER_LINES_ALL.TAX_VALUE for each ORDER line
351: -- ELSE the below programe unit will not process the order

Line 363: fnd_file.put_line(FND_FILE.LOG,lv_process_message);

359: CLOSE get_process_order_lock_cur;
360:
361: lv_process_message := 'Lock OE header for update.'
362: || 'Order Header ID: '|| lv_header_id;
363: fnd_file.put_line(FND_FILE.LOG,lv_process_message);
364:
365: -- Get the type name
366: OPEN get_type_name(header_check_rec.order_type_id);
367: FETCH get_type_name

Line 391: fnd_file.put_line(FND_FILE.LOG,lv_process_message);

387: -- process each order line
388: IF ( lv_credit_setup_flag = 'Y')
389: THEN
390: lv_process_message := 'Order process started.'||'Order Type '||lv_order_type||' Order Number '||header_check_rec.order_number;
391: fnd_file.put_line(FND_FILE.LOG,lv_process_message);
392:
393: FOR order_line_rec IN get_order_lines_cur(header_check_rec.header_id)
394: LOOP
395: -- get jai tax amount

Line 403: fnd_file.put_line(FND_FILE.LOG,lv_process_message);

399: IF (ln_jai_line_tax_amount <> order_line_rec.tax_value)
400: THEN
401: lv_process_message := 'Order line process started.'||'Order Type '||lv_order_type||
402: ' Order Number '||header_check_rec.order_number||' Order Line '||order_line_rec.LINE_NUMBER;
403: fnd_file.put_line(FND_FILE.LOG,lv_process_message);
404:
405: process_order_line
406: ( pn_header_id => header_check_rec.header_id
407: , pn_line_id => order_line_rec.line_id

Line 419: fnd_file.put_line(FND_FILE.LOG,lv_process_message);

415: RAISE le_error;
416: ELSE
417: lv_process_message := 'Order Type '||lv_order_type||' Order Number '||header_check_rec.order_number||
418: ' Order Line '||order_line_rec.LINE_NUMBER||' updated Tax Successfully.';
419: fnd_file.put_line(FND_FILE.LOG,lv_process_message);
420: END IF;
421: END IF;--(ln_jai_line_tax_amount <> order_line_rec.tax_value)
422: END LOOP;
423: END IF;

Line 432: fnd_file.put_line(FND_FILE.LOG,lv_process_message);

428:
429: ROLLBACK TO PROC_MAIN_SVP;
430:
431: lv_process_message := 'Order Type '||lv_order_type||' Order Number '||header_check_rec.order_number||' Order Line '||ln_line_number||' updated Tax failed.';
432: fnd_file.put_line(FND_FILE.LOG,lv_process_message);
433:
434: lv_process_message := 'Exception Information: '|| lv_return_message ;
435: fnd_file.put_line(FND_FILE.LOG,lv_process_message);
436:

Line 435: fnd_file.put_line(FND_FILE.LOG,lv_process_message);

431: lv_process_message := 'Order Type '||lv_order_type||' Order Number '||header_check_rec.order_number||' Order Line '||ln_line_number||' updated Tax failed.';
432: fnd_file.put_line(FND_FILE.LOG,lv_process_message);
433:
434: lv_process_message := 'Exception Information: '|| lv_return_message ;
435: fnd_file.put_line(FND_FILE.LOG,lv_process_message);
436:
437: GOTO NEXT_ORDER;
438: WHEN OTHERS
439: THEN

Line 444: fnd_file.put_line(FND_FILE.LOG,lv_process_message);

440:
441: lv_error_flag := 'Y';
442:
443: lv_process_message := 'Order Type '||lv_order_type||' Order Number '||header_check_rec.order_number||' Order Line '||ln_line_number||' updated Tax failed.';
444: fnd_file.put_line(FND_FILE.LOG,lv_process_message);
445:
446: lv_process_message := 'Exception Information: '|| SQLERRM ;
447: fnd_file.put_line(FND_FILE.LOG,lv_process_message);
448:

Line 447: fnd_file.put_line(FND_FILE.LOG,lv_process_message);

443: lv_process_message := 'Order Type '||lv_order_type||' Order Number '||header_check_rec.order_number||' Order Line '||ln_line_number||' updated Tax failed.';
444: fnd_file.put_line(FND_FILE.LOG,lv_process_message);
445:
446: lv_process_message := 'Exception Information: '|| SQLERRM ;
447: fnd_file.put_line(FND_FILE.LOG,lv_process_message);
448:
449: ROLLBACK TO PROC_MAIN_SVP;
450:
451: GOTO NEXT_ORDER;

Line 456: fnd_file.put_line(FND_FILE.LOG,lv_process_message);

452: END;
453:
454: if(lv_error_flag = 'N')then
455: lv_process_message := 'Order Type '||lv_order_type||' Order Number '||header_check_rec.order_number||' updated Tax Successfully.';
456: fnd_file.put_line(FND_FILE.LOG,lv_process_message);
457: end if;
458:
459: <>
460: NULL;

Line 559: fnd_file.put_line(FND_FILE.LOG,'Deleted records in oe_price_adjustments.'||'Header:'||pn_header_id||',line:'||pn_line_id);

555: where HEADER_ID = pn_header_id
556: and line_id = pn_line_id
557: and LIST_LINE_TYPE_CODE = 'TAX';
558:
559: fnd_file.put_line(FND_FILE.LOG,'Deleted records in oe_price_adjustments.'||'Header:'||pn_header_id||',line:'||pn_line_id);
560:
561: IF nvl(pv_line_type,'####') = 'ORDER' THEN
562: -- SO order process
563: ln_line_exclusive_tax_amt := 0;

Line 605: fnd_file.put_line(FND_FILE.LOG,'Inserted records of SO into oe_price_adjustments.'||'Header:'||pn_header_id||',line:'||pn_line_id||',tax amount:'||ln_line_exclusive_tax_amt);

601: -- accumulate amounts
602: ln_line_exclusive_tax_amt := ln_line_exclusive_tax_amt + NVL(so_tax_rec.TAX_AMOUNT,0);
603: END LOOP;
604:
605: fnd_file.put_line(FND_FILE.LOG,'Inserted records of SO into oe_price_adjustments.'||'Header:'||pn_header_id||',line:'||pn_line_id||',tax amount:'||ln_line_exclusive_tax_amt);
606:
607: ELSIF nvl(pv_line_type,'####') = 'RETURN' THEN
608: --The RMA order process
609: ln_line_exclusive_tax_amt := 0;

Line 651: fnd_file.put_line(FND_FILE.LOG,'Inserted records of RMA into oe_price_adjustments.'||'Header:'||pn_header_id||',line:'||pn_line_id||',tax amount:'||ln_line_exclusive_tax_amt);

647: -- accumulate amounts
648: ln_line_exclusive_tax_amt := ln_line_exclusive_tax_amt + NVL(so_tax_rec.TAX_AMOUNT,0);
649: END LOOP;
650:
651: fnd_file.put_line(FND_FILE.LOG,'Inserted records of RMA into oe_price_adjustments.'||'Header:'||pn_header_id||',line:'||pn_line_id||',tax amount:'||ln_line_exclusive_tax_amt);
652:
653: END IF;
654:
655: --Update tax value with exclusive tax summary.

Line 660: fnd_file.put_line(FND_FILE.LOG,'Updated oe_order_lines.'||'Header:'||pn_header_id||',line:'||pn_line_id||',tax value:'||ln_line_exclusive_tax_amt);

656: UPDATE OE_ORDER_LINES
657: SET tax_value = ln_line_exclusive_tax_amt
658: WHERE header_id = pn_header_id
659: AND line_id = pn_line_id;
660: fnd_file.put_line(FND_FILE.LOG,'Updated oe_order_lines.'||'Header:'||pn_header_id||',line:'||pn_line_id||',tax value:'||ln_line_exclusive_tax_amt);
661:
662: EXCEPTION
663: WHEN OTHERS THEN
664: xv_return_code := jai_constants.unexpected_error;