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_RCV_RGM_CLAIMS_PKG dependencies on FND_FILE

Line 483: fnd_file.put_line(fnd_file.log, 'In Generate Schedule -- LOOP 1:');

479:
480: FOR rec_lines IN cur_lines(p_shipment_header_id, p_shipment_line_id)
481: LOOP
482: IF gv_debug THEN
483: fnd_file.put_line(fnd_file.log, 'In Generate Schedule -- LOOP 1:');
484: fnd_file.put_line(fnd_file.log, 'Shipment Header :'||rec_lines.shipment_header_id||' shipment_line_id '||rec_lines.shipment_line_id);
485: END IF;
486:
487: OPEN cur_term(rec_lines.shipment_line_id);

Line 484: fnd_file.put_line(fnd_file.log, 'Shipment Header :'||rec_lines.shipment_header_id||' shipment_line_id '||rec_lines.shipment_line_id);

480: FOR rec_lines IN cur_lines(p_shipment_header_id, p_shipment_line_id)
481: LOOP
482: IF gv_debug THEN
483: fnd_file.put_line(fnd_file.log, 'In Generate Schedule -- LOOP 1:');
484: fnd_file.put_line(fnd_file.log, 'Shipment Header :'||rec_lines.shipment_header_id||' shipment_line_id '||rec_lines.shipment_line_id);
485: END IF;
486:
487: OPEN cur_term(rec_lines.shipment_line_id);
488: FETCH cur_term INTO r_term;

Line 496: fnd_file.put_line(fnd_file.log, 'ln_apportion_factor: '||ln_apportion_factor);

492: LOOP
493: ln_apportion_factor := ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(rec_txns.transaction_id));
494:
495: IF gv_debug THEN
496: fnd_file.put_line(fnd_file.log, 'ln_apportion_factor: '||ln_apportion_factor);
497: fnd_file.put_line(fnd_file.log, 'Transaction_id: '||rec_txns.transaction_id);
498: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id: '||rec_txns.tax_transaction_id);
499: fnd_file.put_line(fnd_file.log, 'p_simulate_flag: '||p_simulate_flag);
500: END IF;

Line 497: fnd_file.put_line(fnd_file.log, 'Transaction_id: '||rec_txns.transaction_id);

493: ln_apportion_factor := ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(rec_txns.transaction_id));
494:
495: IF gv_debug THEN
496: fnd_file.put_line(fnd_file.log, 'ln_apportion_factor: '||ln_apportion_factor);
497: fnd_file.put_line(fnd_file.log, 'Transaction_id: '||rec_txns.transaction_id);
498: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id: '||rec_txns.tax_transaction_id);
499: fnd_file.put_line(fnd_file.log, 'p_simulate_flag: '||p_simulate_flag);
500: END IF;
501:

Line 498: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id: '||rec_txns.tax_transaction_id);

494:
495: IF gv_debug THEN
496: fnd_file.put_line(fnd_file.log, 'ln_apportion_factor: '||ln_apportion_factor);
497: fnd_file.put_line(fnd_file.log, 'Transaction_id: '||rec_txns.transaction_id);
498: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id: '||rec_txns.tax_transaction_id);
499: fnd_file.put_line(fnd_file.log, 'p_simulate_flag: '||p_simulate_flag);
500: END IF;
501:
502:

Line 499: fnd_file.put_line(fnd_file.log, 'p_simulate_flag: '||p_simulate_flag);

495: IF gv_debug THEN
496: fnd_file.put_line(fnd_file.log, 'ln_apportion_factor: '||ln_apportion_factor);
497: fnd_file.put_line(fnd_file.log, 'Transaction_id: '||rec_txns.transaction_id);
498: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id: '||rec_txns.tax_transaction_id);
499: fnd_file.put_line(fnd_file.log, 'p_simulate_flag: '||p_simulate_flag);
500: END IF;
501:
502:
503: FOR tax_rec IN cur_tax(rec_txns.tax_transaction_id, rec_txns.currency_conversion_rate)

Line 508: fnd_file.put_line(fnd_file.log, 'tax_rec.tax_amount: '||tax_rec.tax_amount);

504: LOOP
505: ln_amount := tax_rec.tax_amount * ln_apportion_factor;
506:
507: IF gv_debug THEN
508: fnd_file.put_line(fnd_file.log, 'tax_rec.tax_amount: '||tax_rec.tax_amount);
509: fnd_file.put_line(fnd_file.log, 'ln_amount: '||ln_amount);
510: END IF;
511:
512: jai_cmn_rgm_terms_pkg.generate_term_schedules(p_term_id => NVL(p_term_id,r_term.term_id),

Line 509: fnd_file.put_line(fnd_file.log, 'ln_amount: '||ln_amount);

505: ln_amount := tax_rec.tax_amount * ln_apportion_factor;
506:
507: IF gv_debug THEN
508: fnd_file.put_line(fnd_file.log, 'tax_rec.tax_amount: '||tax_rec.tax_amount);
509: fnd_file.put_line(fnd_file.log, 'ln_amount: '||ln_amount);
510: END IF;
511:
512: jai_cmn_rgm_terms_pkg.generate_term_schedules(p_term_id => NVL(p_term_id,r_term.term_id),
513: p_amount => ln_amount,

Line 524: fnd_file.put_line(fnd_file.log, ' After Generating jai_cmn_rgm_terms_pkg.generate_term_schedules');

520:
521: --Added for Bug#4950914
522: DELETE jai_rgm_trm_schedules_t
523: WHERE schedule_id = ln_schedule_id;
524: fnd_file.put_line(fnd_file.log, ' After Generating jai_cmn_rgm_terms_pkg.generate_term_schedules');
525: p_process_status := lv_process_flag;
526: p_process_message := lv_process_msg;
527: RETURN;
528: END IF;

Line 647: fnd_file.put_line(fnd_file.log, 'gone into error ');

643: EXCEPTION
644: WHEN OTHERS THEN
645: p_process_status := jai_constants.unexpected_error;
646: p_process_message := SUBSTR(SQLERRM,1,200);
647: fnd_file.put_line(fnd_file.log, 'gone into error ');
648: END generate_schedule;
649:
650: PROCEDURE insert_rcv_lines(
651: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

Line 786: fnd_file.put_line(fnd_file.log, '1 insert_rcv_lines: Bef Main loop:');

782: FETCH c_receipt_source_code INTO r_receipt_source_code;
783: CLOSE c_receipt_source_code;
784:
785: IF gv_debug THEN
786: fnd_file.put_line(fnd_file.log, '1 insert_rcv_lines: Bef Main loop:');
787: END IF;
788:
789: FOR rec_lines IN c_shipment_lines(p_shipment_header_id, p_shipment_line_id)
790: LOOP

Line 804: fnd_file.put_line(fnd_file.log, '2 insert_rcv_lines:ln_dup_chk:'||ln_dup_chk);

800: from jai_rcv_rgm_lines
801: where transaction_id = r_trx.transaction_id;
802:
803: IF gv_debug THEN
804: fnd_file.put_line(fnd_file.log, '2 insert_rcv_lines:ln_dup_chk:'||ln_dup_chk);
805: END IF;
806:
807: IF ln_dup_chk > 0 THEN
808: return;

Line 824: fnd_file.put_line(fnd_file.log, '3 insert_rcv_lines:ln_recoverable_amount:'||ln_recoverable_amount);

820: ln_recoverable_amount := ln_recoverable_amount + round(tax_rec.tax_amount * ln_curr_conv * (tax_rec.modvat_percentage/100), tax_rec.rnd); /*ADDED BY NITIN FOR BUG # 6681800*/
821: END LOOP;
822:
823: IF gv_debug THEN
824: fnd_file.put_line(fnd_file.log, '3 insert_rcv_lines:ln_recoverable_amount:'||ln_recoverable_amount);
825: END IF;
826:
827: --In the Final Observation Change
828: if ln_recoverable_amount = 0 then

Line 856: fnd_file.put_line(fnd_file.log, '4 insert_rcv_lines: after get_location:'||r_base_trx.location_id);

852: RETURN;
853: END IF;
854: END IF;
855: IF gv_debug THEN
856: fnd_file.put_line(fnd_file.log, '4 insert_rcv_lines: after get_location:'||r_base_trx.location_id);
857: END IF;
858:
859:
860: jai_inv_items_pkg.jai_get_attrib(

Line 922: fnd_file.put_line(fnd_file.log, 'ABCD def_inv_setup : lv_default_invoice_setup:'||lv_default_invoice_setup);

918: -- All the reference to r_trx.excise_invoice_no and r_trx.excise_invoice_date are changed to
919: -- rec_lines.excise_invoice_no and rec_lines.excise_invoice_date resp.
920: --
921: IF gv_debug THEN
922: fnd_file.put_line(fnd_file.log, 'ABCD def_inv_setup : lv_default_invoice_setup:'||lv_default_invoice_setup);
923: fnd_file.put_line(fnd_file.log, 'ABCD r_trx.organization_id : '||r_trx.organization_id);
924: fnd_file.put_line(fnd_file.log, 'ABCD ln_location_id : '||ln_location_id);
925: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_no : '||rec_lines.excise_invoice_no); -- Bug# 6109941
926: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_date : '||rec_lines.excise_invoice_date); -- Bug# 6109941

Line 923: fnd_file.put_line(fnd_file.log, 'ABCD r_trx.organization_id : '||r_trx.organization_id);

919: -- rec_lines.excise_invoice_no and rec_lines.excise_invoice_date resp.
920: --
921: IF gv_debug THEN
922: fnd_file.put_line(fnd_file.log, 'ABCD def_inv_setup : lv_default_invoice_setup:'||lv_default_invoice_setup);
923: fnd_file.put_line(fnd_file.log, 'ABCD r_trx.organization_id : '||r_trx.organization_id);
924: fnd_file.put_line(fnd_file.log, 'ABCD ln_location_id : '||ln_location_id);
925: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_no : '||rec_lines.excise_invoice_no); -- Bug# 6109941
926: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_date : '||rec_lines.excise_invoice_date); -- Bug# 6109941
927:

Line 924: fnd_file.put_line(fnd_file.log, 'ABCD ln_location_id : '||ln_location_id);

920: --
921: IF gv_debug THEN
922: fnd_file.put_line(fnd_file.log, 'ABCD def_inv_setup : lv_default_invoice_setup:'||lv_default_invoice_setup);
923: fnd_file.put_line(fnd_file.log, 'ABCD r_trx.organization_id : '||r_trx.organization_id);
924: fnd_file.put_line(fnd_file.log, 'ABCD ln_location_id : '||ln_location_id);
925: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_no : '||rec_lines.excise_invoice_no); -- Bug# 6109941
926: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_date : '||rec_lines.excise_invoice_date); -- Bug# 6109941
927:
928: END IF;

Line 925: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_no : '||rec_lines.excise_invoice_no); -- Bug# 6109941

921: IF gv_debug THEN
922: fnd_file.put_line(fnd_file.log, 'ABCD def_inv_setup : lv_default_invoice_setup:'||lv_default_invoice_setup);
923: fnd_file.put_line(fnd_file.log, 'ABCD r_trx.organization_id : '||r_trx.organization_id);
924: fnd_file.put_line(fnd_file.log, 'ABCD ln_location_id : '||ln_location_id);
925: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_no : '||rec_lines.excise_invoice_no); -- Bug# 6109941
926: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_date : '||rec_lines.excise_invoice_date); -- Bug# 6109941
927:
928: END IF;
929:

Line 926: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_date : '||rec_lines.excise_invoice_date); -- Bug# 6109941

922: fnd_file.put_line(fnd_file.log, 'ABCD def_inv_setup : lv_default_invoice_setup:'||lv_default_invoice_setup);
923: fnd_file.put_line(fnd_file.log, 'ABCD r_trx.organization_id : '||r_trx.organization_id);
924: fnd_file.put_line(fnd_file.log, 'ABCD ln_location_id : '||ln_location_id);
925: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_no : '||rec_lines.excise_invoice_no); -- Bug# 6109941
926: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_date : '||rec_lines.excise_invoice_date); -- Bug# 6109941
927:
928: END IF;
929:
930: IF upper(lv_default_invoice_setup) in ( 'Y', 'YES') then

Line 1361: fnd_file.put_line(fnd_file.log, 'r_base_trx.transaction_type:'||r_base_trx.transaction_type);

1357:
1358: lv_currency_code := jai_constants.func_curr;
1359:
1360: IF gv_debug THEN
1361: fnd_file.put_line(fnd_file.log, 'r_base_trx.transaction_type:'||r_base_trx.transaction_type);
1362: END IF;
1363:
1364: ln_statement_id := 6;
1365: IF r_base_trx.transaction_type IN ('RECEIVE', 'MATCH') THEN

Line 1368: fnd_file.put_line(fnd_file.log, '1 RECEIVE: Before insert_rcv_lines:');

1364: ln_statement_id := 6;
1365: IF r_base_trx.transaction_type IN ('RECEIVE', 'MATCH') THEN
1366:
1367: IF gv_debug THEN
1368: fnd_file.put_line(fnd_file.log, '1 RECEIVE: Before insert_rcv_lines:');
1369: END IF;
1370:
1371: ln_statement_id := 7;
1372: --Populate the lines for quantity and Recoverable amount

Line 1383: fnd_file.put_line(fnd_file.log, '1.1 RECEIVE: After insert_rcv_lines:');

1379: p_simulate_flag => lv_simulate_flag --File.Sql.35 Cbabu
1380: );
1381:
1382: IF gv_debug THEN
1383: fnd_file.put_line(fnd_file.log, '1.1 RECEIVE: After insert_rcv_lines:');
1384: END IF;
1385:
1386: IF lv_process_status <> jai_constants.successful THEN
1387: p_process_status := lv_process_status;

Line 1428: fnd_file.put_line(fnd_file.log, 'Inside RTV:');

1424: ln_statement_id := 9;
1425: lv_accounting_type := 'REVERSAL';
1426:
1427: IF gv_debug THEN
1428: fnd_file.put_line(fnd_file.log, 'Inside RTV:');
1429: END IF;
1430:
1431: IF gv_debug THEN
1432: fnd_file.put_line(fnd_file.log, 'Before generate Schedule');

Line 1432: fnd_file.put_line(fnd_file.log, 'Before generate Schedule');

1428: fnd_file.put_line(fnd_file.log, 'Inside RTV:');
1429: END IF;
1430:
1431: IF gv_debug THEN
1432: fnd_file.put_line(fnd_file.log, 'Before generate Schedule');
1433: END IF;
1434:
1435: ln_statement_id := 10;
1436: generate_schedule (

Line 1452: fnd_file.put_line(fnd_file.log, 'After generate Schedule');

1448: GOTO EXIT_POINT;
1449: END IF;
1450:
1451: IF gv_debug THEN
1452: fnd_file.put_line(fnd_file.log, 'After generate Schedule');
1453: END IF;
1454:
1455: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
1456: IF gv_debug THEN

Line 1457: fnd_file.put_line(fnd_file.log, 'r_base_trx.attribute_category'||r_base_trx.attribute_category);

1453: END IF;
1454:
1455: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
1456: IF gv_debug THEN
1457: fnd_file.put_line(fnd_file.log, 'r_base_trx.attribute_category'||r_base_trx.attribute_category);
1458: fnd_file.put_line(fnd_file.log, 'r_base_trx.attribute4'||r_base_trx.attribute4);
1459: END IF;
1460: */
1461:

Line 1458: fnd_file.put_line(fnd_file.log, 'r_base_trx.attribute4'||r_base_trx.attribute4);

1454:
1455: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
1456: IF gv_debug THEN
1457: fnd_file.put_line(fnd_file.log, 'r_base_trx.attribute_category'||r_base_trx.attribute_category);
1458: fnd_file.put_line(fnd_file.log, 'r_base_trx.attribute4'||r_base_trx.attribute4);
1459: END IF;
1460: */
1461:
1462: ln_statement_id := 11;

Line 1507: fnd_file.put_line(fnd_file.log, 'After update_rcv_lines:');

1503: GOTO EXIT_POINT;
1504: END IF;
1505:
1506: IF gv_debug THEN
1507: fnd_file.put_line(fnd_file.log, 'After update_rcv_lines:');
1508: END IF;
1509: ln_statement_id := 17;
1510:
1511: ELSIF r_base_trx.transaction_type = 'CORRECT' THEN

Line 1518: fnd_file.put_line(fnd_file.log, 'r_trx.parent_transaction_type :'||r_trx.parent_transaction_type);

1514: ln_statement_id := 18;
1515: lv_accounting_type := 'REGULAR';
1516:
1517: IF gv_debug THEN
1518: fnd_file.put_line(fnd_file.log, 'r_trx.parent_transaction_type :'||r_trx.parent_transaction_type);
1519: END IF;
1520:
1521: ln_statement_id := 19;
1522: generate_schedule (

Line 1539: fnd_file.put_line(fnd_file.log, 'After Generate Schedule');

1535: END IF;
1536:
1537: ln_statement_id := 20;
1538: IF gv_debug THEN
1539: fnd_file.put_line(fnd_file.log, 'After Generate Schedule');
1540: END IF;
1541:
1542: OPEN c_vat_invoice(r_trx.parent_transaction_id);
1543: FETCH c_vat_invoice INTO r_vat_invoice;

Line 1553: fnd_file.put_line(fnd_file.log, 'Before Process_Claim');

1549: vat_invoice_date = r_vat_invoice.vat_invoice_date
1550: WHERE transaction_id = r_trx.transaction_id;
1551:
1552: IF gv_debug THEN
1553: fnd_file.put_line(fnd_file.log, 'Before Process_Claim');
1554: END IF;
1555:
1556: ln_statement_id := 22;
1557: --Call the Claim API with Shipment_line_id

Line 1589: fnd_file.put_line(fnd_file.log, 'After Process_claim');

1585: END IF;
1586:
1587: ln_statement_id := 23;
1588: IF gv_debug THEN
1589: fnd_file.put_line(fnd_file.log, 'After Process_claim');
1590: END IF;
1591:
1592: --ln_total_cenvat_amount := ln_total_cenvat_amount * r_txn.quantity_multiplier * ln_apportion_factor;
1593:

Line 1613: fnd_file.put_line(fnd_file.log, 'After Update_rcv_lines');

1609: END IF;
1610:
1611: ln_statement_id := 24;
1612: IF gv_debug THEN
1613: fnd_file.put_line(fnd_file.log, 'After Update_rcv_lines');
1614: END IF;
1615:
1616: ELSIF r_trx.parent_transaction_type = 'RETURN TO VENDOR' THEN
1617: lv_accounting_type := 'REVERSAL';

Line 1622: fnd_file.put_line(fnd_file.log, 'r_trx.parent_transaction_type :'||r_trx.parent_transaction_type);

1618:
1619: ln_statement_id := 25;
1620:
1621: IF gv_debug THEN
1622: fnd_file.put_line(fnd_file.log, 'r_trx.parent_transaction_type :'||r_trx.parent_transaction_type);
1623: END IF;
1624:
1625: generate_schedule (
1626: p_shipment_header_id => r_base_trx.shipment_header_id,

Line 1643: fnd_file.put_line(fnd_file.log, 'After Generate Schedule');

1639:
1640: ln_statement_id := 26;
1641:
1642: IF gv_debug THEN
1643: fnd_file.put_line(fnd_file.log, 'After Generate Schedule');
1644: END IF;
1645:
1646: --Get the VAT Invoice no from Parent
1647: OPEN c_trx(r_base_trx.parent_transaction_id);

Line 1660: fnd_file.put_line(fnd_file.log, 'Before Process_Claim');

1656: vat_invoice_date = TRUNC(SYSDATE)
1657: WHERE transaction_id = r_base_trx.transaction_id; --r_trx now points to the parent transaction
1658:
1659: IF gv_debug THEN
1660: fnd_file.put_line(fnd_file.log, 'Before Process_Claim');
1661: END IF;
1662:
1663: ln_statement_id := 28;
1664:

Line 1700: fnd_file.put_line(fnd_file.log, 'After Process_claim');

1696: GOTO EXIT_POINT;
1697: END IF;
1698:
1699: IF gv_debug THEN
1700: fnd_file.put_line(fnd_file.log, 'After Process_claim');
1701: END IF;
1702: */
1703:
1704: --ln_total_cenvat_amount := ln_total_cenvat_amount * r_txn.quantity_multiplier * ln_apportion_factor;

Line 1724: fnd_file.put_line(fnd_file.log, 'After Update_rcv_lines');

1720: GOTO EXIT_POINT;
1721: END IF;
1722:
1723: IF gv_debug THEN
1724: fnd_file.put_line(fnd_file.log, 'After Update_rcv_lines');
1725: END IF;
1726:
1727: END IF;
1728: END IF;

Line 1739: fnd_file.put_line(fnd_file.log, 'PROCESS_VAT ERROR:'||p_process_message);

1735: EXCEPTION
1736: WHEN OTHERS THEN
1737: p_process_status := jai_constants.unexpected_error;
1738: p_process_message := 'Stmt :'||ln_statement_id||' '||SUBSTR(SQLERRM,1,200);
1739: fnd_file.put_line(fnd_file.log, 'PROCESS_VAT ERROR:'||p_process_message);
1740:
1741: END process_vat;
1742:
1743: PROCEDURE process_claim(

Line 1886: fnd_file.put_line(fnd_file.log, 'Inside Claim Process');

1882: /* End of File.Sql.35 by Brathod */
1883:
1884:
1885: IF gv_debug THEN
1886: fnd_file.put_line(fnd_file.log, 'Inside Claim Process');
1887: END IF;
1888:
1889: OPEN c_regime(p_regime_id, NULL);
1890: FETCH c_regime INTO r_regime;

Line 1910: fnd_file.put_line(fnd_file.log, 'Inside Loop');

1906: p_force)
1907: LOOP
1908:
1909: IF gv_debug THEN
1910: fnd_file.put_line(fnd_file.log, 'Inside Loop');
1911: fnd_file.put_line(fnd_file.log, 'Installment Amount : '||rec_claims.installment_amount);
1912: fnd_file.put_line(fnd_file.log, 'receipt_num : '||rec_claims.receipt_num);
1913:
1914: END IF;

Line 1911: fnd_file.put_line(fnd_file.log, 'Installment Amount : '||rec_claims.installment_amount);

1907: LOOP
1908:
1909: IF gv_debug THEN
1910: fnd_file.put_line(fnd_file.log, 'Inside Loop');
1911: fnd_file.put_line(fnd_file.log, 'Installment Amount : '||rec_claims.installment_amount);
1912: fnd_file.put_line(fnd_file.log, 'receipt_num : '||rec_claims.receipt_num);
1913:
1914: END IF;
1915:

Line 1912: fnd_file.put_line(fnd_file.log, 'receipt_num : '||rec_claims.receipt_num);

1908:
1909: IF gv_debug THEN
1910: fnd_file.put_line(fnd_file.log, 'Inside Loop');
1911: fnd_file.put_line(fnd_file.log, 'Installment Amount : '||rec_claims.installment_amount);
1912: fnd_file.put_line(fnd_file.log, 'receipt_num : '||rec_claims.receipt_num);
1913:
1914: END IF;
1915:
1916: lv_reference_10 := 'India Local VAT Claim Entries For Receipt:'||rec_claims.receipt_num||' Transaction Type CLAIM for installment no '||rec_claims.installment_no;

Line 1982: fnd_file.put_line(fnd_file.log, 'Before Start of Accounting');

1978: FETCH c_claim_schedule INTO r_claim_schedule;
1979: CLOSE c_claim_schedule;
1980:
1981: IF gv_debug THEN
1982: fnd_file.put_line(fnd_file.log, 'Before Start of Accounting');
1983: END IF;
1984:
1985: --Accounting
1986: lv_currency_code := jai_constants.func_curr;

Line 2058: fnd_file.put_line(fnd_file.log, 'Before Passing the Repository Entry');

2054: ld_invoice_date := p_invoice_date;
2055: END IF;
2056:
2057: IF gv_debug THEN
2058: fnd_file.put_line(fnd_file.log, 'Before Passing the Repository Entry');
2059: END IF;
2060:
2061: IF NVL(ln_entered_cr,0) <> 0 OR NVL(ln_entered_dr,0) <> 0 THEN --Added for Bug#4950914
2062: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(

Line 2097: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);

2093: pv_attribute4 => NULL,
2094: pv_attribute5 => NULL);
2095:
2096: IF gv_debug THEN
2097: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);
2098: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);
2099: END IF;
2100:
2101:

Line 2098: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);

2094: pv_attribute5 => NULL);
2095:
2096: IF gv_debug THEN
2097: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);
2098: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);
2099: END IF;
2100:
2101:
2102: IF lv_process_status <> jai_constants.successful THEN

Line 2110: fnd_file.put_line(fnd_file.log, 'After Passing the Repository Entry');

2106: END IF;
2107: END IF;
2108:
2109: IF gv_debug THEN
2110: fnd_file.put_line(fnd_file.log, 'After Passing the Repository Entry');
2111: END IF;
2112:
2113: -- Dr VAT Recovery
2114: ln_entered_dr := rec_claims.installment_amount;

Line 2203: fnd_file.put_line(fnd_file.log, 'After Passing the Accounting Entry');

2199: END IF;
2200: END IF;
2201:
2202: IF gv_debug THEN
2203: fnd_file.put_line(fnd_file.log, 'After Passing the Accounting Entry');
2204: END IF;
2205:
2206: UPDATE jai_rcv_rgm_claims
2207: SET status = 'Y',

Line 2590: fnd_file.put_line(fnd_file.log, 'Before the Deliver RTR Transaction Cost Reversal');

2586:
2587: -- LOOP Through DELIVER/RTR
2588:
2589: IF gv_debug THEN
2590: fnd_file.put_line(fnd_file.log, 'Before the Deliver RTR Transaction Cost Reversal');
2591: fnd_file.put_line(fnd_file.log, 'Shipment_header_id'||r_shipment_lines.shipment_header_id);
2592: fnd_file.put_line(fnd_file.log, 'Shipment_line_id'||r_shipment_lines.shipment_line_id);
2593: END IF;
2594:

Line 2591: fnd_file.put_line(fnd_file.log, 'Shipment_header_id'||r_shipment_lines.shipment_header_id);

2587: -- LOOP Through DELIVER/RTR
2588:
2589: IF gv_debug THEN
2590: fnd_file.put_line(fnd_file.log, 'Before the Deliver RTR Transaction Cost Reversal');
2591: fnd_file.put_line(fnd_file.log, 'Shipment_header_id'||r_shipment_lines.shipment_header_id);
2592: fnd_file.put_line(fnd_file.log, 'Shipment_line_id'||r_shipment_lines.shipment_line_id);
2593: END IF;
2594:
2595: lv_ttype_deliver := 'DELIVER' ;

Line 2592: fnd_file.put_line(fnd_file.log, 'Shipment_line_id'||r_shipment_lines.shipment_line_id);

2588:
2589: IF gv_debug THEN
2590: fnd_file.put_line(fnd_file.log, 'Before the Deliver RTR Transaction Cost Reversal');
2591: fnd_file.put_line(fnd_file.log, 'Shipment_header_id'||r_shipment_lines.shipment_header_id);
2592: fnd_file.put_line(fnd_file.log, 'Shipment_line_id'||r_shipment_lines.shipment_line_id);
2593: END IF;
2594:
2595: lv_ttype_deliver := 'DELIVER' ;
2596: lv_ttype_rtr := 'RETURN TO RECEIVING' ;

Line 2612: fnd_file.put_line(fnd_file.log, 'In the LOOP');

2608: ln_process_special_amount := rec_total_tax.tax_amount *
2609: ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(r_deliver_rtr_txns.transaction_id)) *
2610: r_deliver_rtr_txns.quantity_multiplier;
2611: IF gv_debug THEN
2612: fnd_file.put_line(fnd_file.log, 'In the LOOP');
2613: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id'||r_deliver_rtr_txns.Tax_transaction_id);
2614: fnd_file.put_line(fnd_file.log, 'transaction_id'||r_deliver_rtr_txns.transaction_id);
2615: fnd_file.put_line(fnd_file.log, 'currency_conversion_rate'||r_receive_transaction.currency_conversion_rate);
2616: fnd_file.put_line(fnd_file.log, 'Tax_amount'||rec_total_tax.tax_amount);

Line 2613: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id'||r_deliver_rtr_txns.Tax_transaction_id);

2609: ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(r_deliver_rtr_txns.transaction_id)) *
2610: r_deliver_rtr_txns.quantity_multiplier;
2611: IF gv_debug THEN
2612: fnd_file.put_line(fnd_file.log, 'In the LOOP');
2613: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id'||r_deliver_rtr_txns.Tax_transaction_id);
2614: fnd_file.put_line(fnd_file.log, 'transaction_id'||r_deliver_rtr_txns.transaction_id);
2615: fnd_file.put_line(fnd_file.log, 'currency_conversion_rate'||r_receive_transaction.currency_conversion_rate);
2616: fnd_file.put_line(fnd_file.log, 'Tax_amount'||rec_total_tax.tax_amount);
2617: fnd_file.put_line(fnd_file.log, 'Apportion Factor'||ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(r_deliver_rtr_txns.transaction_id)));

Line 2614: fnd_file.put_line(fnd_file.log, 'transaction_id'||r_deliver_rtr_txns.transaction_id);

2610: r_deliver_rtr_txns.quantity_multiplier;
2611: IF gv_debug THEN
2612: fnd_file.put_line(fnd_file.log, 'In the LOOP');
2613: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id'||r_deliver_rtr_txns.Tax_transaction_id);
2614: fnd_file.put_line(fnd_file.log, 'transaction_id'||r_deliver_rtr_txns.transaction_id);
2615: fnd_file.put_line(fnd_file.log, 'currency_conversion_rate'||r_receive_transaction.currency_conversion_rate);
2616: fnd_file.put_line(fnd_file.log, 'Tax_amount'||rec_total_tax.tax_amount);
2617: fnd_file.put_line(fnd_file.log, 'Apportion Factor'||ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(r_deliver_rtr_txns.transaction_id)));
2618:

Line 2615: fnd_file.put_line(fnd_file.log, 'currency_conversion_rate'||r_receive_transaction.currency_conversion_rate);

2611: IF gv_debug THEN
2612: fnd_file.put_line(fnd_file.log, 'In the LOOP');
2613: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id'||r_deliver_rtr_txns.Tax_transaction_id);
2614: fnd_file.put_line(fnd_file.log, 'transaction_id'||r_deliver_rtr_txns.transaction_id);
2615: fnd_file.put_line(fnd_file.log, 'currency_conversion_rate'||r_receive_transaction.currency_conversion_rate);
2616: fnd_file.put_line(fnd_file.log, 'Tax_amount'||rec_total_tax.tax_amount);
2617: fnd_file.put_line(fnd_file.log, 'Apportion Factor'||ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(r_deliver_rtr_txns.transaction_id)));
2618:
2619: END IF;

Line 2616: fnd_file.put_line(fnd_file.log, 'Tax_amount'||rec_total_tax.tax_amount);

2612: fnd_file.put_line(fnd_file.log, 'In the LOOP');
2613: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id'||r_deliver_rtr_txns.Tax_transaction_id);
2614: fnd_file.put_line(fnd_file.log, 'transaction_id'||r_deliver_rtr_txns.transaction_id);
2615: fnd_file.put_line(fnd_file.log, 'currency_conversion_rate'||r_receive_transaction.currency_conversion_rate);
2616: fnd_file.put_line(fnd_file.log, 'Tax_amount'||rec_total_tax.tax_amount);
2617: fnd_file.put_line(fnd_file.log, 'Apportion Factor'||ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(r_deliver_rtr_txns.transaction_id)));
2618:
2619: END IF;
2620:

Line 2617: fnd_file.put_line(fnd_file.log, 'Apportion Factor'||ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(r_deliver_rtr_txns.transaction_id)));

2613: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id'||r_deliver_rtr_txns.Tax_transaction_id);
2614: fnd_file.put_line(fnd_file.log, 'transaction_id'||r_deliver_rtr_txns.transaction_id);
2615: fnd_file.put_line(fnd_file.log, 'currency_conversion_rate'||r_receive_transaction.currency_conversion_rate);
2616: fnd_file.put_line(fnd_file.log, 'Tax_amount'||rec_total_tax.tax_amount);
2617: fnd_file.put_line(fnd_file.log, 'Apportion Factor'||ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(r_deliver_rtr_txns.transaction_id)));
2618:
2619: END IF;
2620:
2621: jai_rcv_deliver_rtr_pkg.process_transaction(

Line 3174: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);

3170: pv_attribute4 => NULL,
3171: pv_attribute5 => NULL);
3172: ln_statement_id := 106;
3173: IF gv_debug THEN
3174: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);
3175: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);
3176: END IF;
3177:
3178: IF lv_process_status <> jai_constants.successful THEN

Line 3175: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);

3171: pv_attribute5 => NULL);
3172: ln_statement_id := 106;
3173: IF gv_debug THEN
3174: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);
3175: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);
3176: END IF;
3177:
3178: IF lv_process_status <> jai_constants.successful THEN
3179: p_process_status := lv_process_status;

Line 3235: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);

3231: pv_attribute5 => NULL);
3232:
3233: ln_statement_id := 109;
3234: IF gv_debug THEN
3235: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);
3236: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);
3237: END IF;
3238:
3239: IF lv_process_status <> jai_constants.successful THEN

Line 3236: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);

3232:
3233: ln_statement_id := 109;
3234: IF gv_debug THEN
3235: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);
3236: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);
3237: END IF;
3238:
3239: IF lv_process_status <> jai_constants.successful THEN
3240: p_process_status := lv_process_status;

Line 3377: fnd_file.put_line(fnd_file.log, 'rec_tax.tax_amount:'||rec_tax.tax_amount);

3373:
3374: ln_tax_amount := rec_tax.tax_amount*ln_apportion_factor;
3375:
3376: IF gv_debug THEN
3377: fnd_file.put_line(fnd_file.log, 'rec_tax.tax_amount:'||rec_tax.tax_amount);
3378: fnd_file.put_line(fnd_file.log, 'ln_tax_amount:'||ln_tax_amount);
3379: END IF;
3380:
3381: ln_debit_ccid :=

Line 3378: fnd_file.put_line(fnd_file.log, 'ln_tax_amount:'||ln_tax_amount);

3374: ln_tax_amount := rec_tax.tax_amount*ln_apportion_factor;
3375:
3376: IF gv_debug THEN
3377: fnd_file.put_line(fnd_file.log, 'rec_tax.tax_amount:'||rec_tax.tax_amount);
3378: fnd_file.put_line(fnd_file.log, 'ln_tax_amount:'||ln_tax_amount);
3379: END IF;
3380:
3381: ln_debit_ccid :=
3382: jai_cmn_rgm_recording_pkg.get_account(