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 550: fnd_file.put_line(fnd_file.log, 'In Generate Schedule -- LOOP 1:');

546:
547: FOR rec_lines IN cur_lines(p_shipment_header_id, p_shipment_line_id)
548: LOOP
549: IF gv_debug THEN
550: fnd_file.put_line(fnd_file.log, 'In Generate Schedule -- LOOP 1:');
551: fnd_file.put_line(fnd_file.log, 'Shipment Header :'||rec_lines.shipment_header_id||' shipment_line_id '||rec_lines.shipment_line_id);
552: END IF;
553:
554: OPEN cur_term(rec_lines.shipment_line_id);

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

547: FOR rec_lines IN cur_lines(p_shipment_header_id, p_shipment_line_id)
548: LOOP
549: IF gv_debug THEN
550: fnd_file.put_line(fnd_file.log, 'In Generate Schedule -- LOOP 1:');
551: fnd_file.put_line(fnd_file.log, 'Shipment Header :'||rec_lines.shipment_header_id||' shipment_line_id '||rec_lines.shipment_line_id);
552: END IF;
553:
554: OPEN cur_term(rec_lines.shipment_line_id);
555: FETCH cur_term INTO r_term;

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

559: LOOP
560: ln_apportion_factor := ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(rec_txns.transaction_id));
561:
562: IF gv_debug THEN
563: fnd_file.put_line(fnd_file.log, 'ln_apportion_factor: '||ln_apportion_factor);
564: fnd_file.put_line(fnd_file.log, 'Transaction_id: '||rec_txns.transaction_id);
565: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id: '||rec_txns.tax_transaction_id);
566: fnd_file.put_line(fnd_file.log, 'p_simulate_flag: '||p_simulate_flag);
567: END IF;

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

560: ln_apportion_factor := ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(rec_txns.transaction_id));
561:
562: IF gv_debug THEN
563: fnd_file.put_line(fnd_file.log, 'ln_apportion_factor: '||ln_apportion_factor);
564: fnd_file.put_line(fnd_file.log, 'Transaction_id: '||rec_txns.transaction_id);
565: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id: '||rec_txns.tax_transaction_id);
566: fnd_file.put_line(fnd_file.log, 'p_simulate_flag: '||p_simulate_flag);
567: END IF;
568:

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

561:
562: IF gv_debug THEN
563: fnd_file.put_line(fnd_file.log, 'ln_apportion_factor: '||ln_apportion_factor);
564: fnd_file.put_line(fnd_file.log, 'Transaction_id: '||rec_txns.transaction_id);
565: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id: '||rec_txns.tax_transaction_id);
566: fnd_file.put_line(fnd_file.log, 'p_simulate_flag: '||p_simulate_flag);
567: END IF;
568:
569:

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

562: IF gv_debug THEN
563: fnd_file.put_line(fnd_file.log, 'ln_apportion_factor: '||ln_apportion_factor);
564: fnd_file.put_line(fnd_file.log, 'Transaction_id: '||rec_txns.transaction_id);
565: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id: '||rec_txns.tax_transaction_id);
566: fnd_file.put_line(fnd_file.log, 'p_simulate_flag: '||p_simulate_flag);
567: END IF;
568:
569:
570: FOR tax_rec IN cur_tax(rec_txns.tax_transaction_id, rec_txns.currency_conversion_rate)

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

574: * will have unrounded amount. Effectively there will be no rounding if there is only one
575: * installment.*/
576:
577: IF gv_debug THEN
578: fnd_file.put_line(fnd_file.log, 'tax_rec.tax_amount: '||tax_rec.tax_amount);
579: fnd_file.put_line(fnd_file.log, 'ln_amount: '||ln_amount);
580: END IF;
581:
582: jai_cmn_rgm_terms_pkg.generate_term_schedules(p_term_id => NVL(p_term_id,r_term.term_id),

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

575: * installment.*/
576:
577: IF gv_debug THEN
578: fnd_file.put_line(fnd_file.log, 'tax_rec.tax_amount: '||tax_rec.tax_amount);
579: fnd_file.put_line(fnd_file.log, 'ln_amount: '||ln_amount);
580: END IF;
581:
582: jai_cmn_rgm_terms_pkg.generate_term_schedules(p_term_id => NVL(p_term_id,r_term.term_id),
583: p_amount => ln_amount,

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

590:
591: --Added for Bug#4950914
592: DELETE jai_rgm_trm_schedules_t
593: WHERE schedule_id = ln_schedule_id;
594: fnd_file.put_line(fnd_file.log, ' After Generating jai_cmn_rgm_terms_pkg.generate_term_schedules');
595: p_process_status := lv_process_flag;
596: p_process_message := lv_process_msg;
597: RETURN;
598: END IF;

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

713: EXCEPTION
714: WHEN OTHERS THEN
715: p_process_status := jai_constants.unexpected_error;
716: p_process_message := SUBSTR(SQLERRM,1,200);
717: fnd_file.put_line(fnd_file.log, 'gone into error ');
718: END generate_schedule;
719:
720: PROCEDURE insert_rcv_lines(
721: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

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

852: FETCH c_receipt_source_code INTO r_receipt_source_code;
853: CLOSE c_receipt_source_code;
854:
855: IF gv_debug THEN
856: fnd_file.put_line(fnd_file.log, '1 insert_rcv_lines: Bef Main loop:');
857: END IF;
858:
859: FOR rec_lines IN c_shipment_lines(p_shipment_header_id, p_shipment_line_id)
860: LOOP

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

870: from jai_rcv_rgm_lines
871: where transaction_id = r_trx.transaction_id;
872:
873: IF gv_debug THEN
874: fnd_file.put_line(fnd_file.log, '2 insert_rcv_lines:ln_dup_chk:'||ln_dup_chk);
875: END IF;
876:
877: IF ln_dup_chk > 0 THEN
878: return;

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

890: 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*/
891: END LOOP;
892:
893: IF gv_debug THEN
894: fnd_file.put_line(fnd_file.log, '3 insert_rcv_lines:ln_recoverable_amount:'||ln_recoverable_amount);
895: END IF;
896:
897: --In the Final Observation Change
898: if ln_recoverable_amount = 0 then

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

922: RETURN;
923: END IF;
924: END IF;
925: IF gv_debug THEN
926: fnd_file.put_line(fnd_file.log, '4 insert_rcv_lines: after get_location:'||r_base_trx.location_id);
927: END IF;
928:
929:
930: jai_inv_items_pkg.jai_get_attrib(

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

988: -- All the reference to r_trx.excise_invoice_no and r_trx.excise_invoice_date are changed to
989: -- rec_lines.excise_invoice_no and rec_lines.excise_invoice_date resp.
990: --
991: IF gv_debug THEN
992: fnd_file.put_line(fnd_file.log, 'ABCD def_inv_setup : lv_default_invoice_setup:'||lv_default_invoice_setup);
993: fnd_file.put_line(fnd_file.log, 'ABCD r_trx.organization_id : '||r_trx.organization_id);
994: fnd_file.put_line(fnd_file.log, 'ABCD ln_location_id : '||ln_location_id);
995: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_no : '||rec_lines.excise_invoice_no); -- Bug# 6109941
996: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_date : '||rec_lines.excise_invoice_date); -- Bug# 6109941

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

989: -- rec_lines.excise_invoice_no and rec_lines.excise_invoice_date resp.
990: --
991: IF gv_debug THEN
992: fnd_file.put_line(fnd_file.log, 'ABCD def_inv_setup : lv_default_invoice_setup:'||lv_default_invoice_setup);
993: fnd_file.put_line(fnd_file.log, 'ABCD r_trx.organization_id : '||r_trx.organization_id);
994: fnd_file.put_line(fnd_file.log, 'ABCD ln_location_id : '||ln_location_id);
995: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_no : '||rec_lines.excise_invoice_no); -- Bug# 6109941
996: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_date : '||rec_lines.excise_invoice_date); -- Bug# 6109941
997:

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

990: --
991: IF gv_debug THEN
992: fnd_file.put_line(fnd_file.log, 'ABCD def_inv_setup : lv_default_invoice_setup:'||lv_default_invoice_setup);
993: fnd_file.put_line(fnd_file.log, 'ABCD r_trx.organization_id : '||r_trx.organization_id);
994: fnd_file.put_line(fnd_file.log, 'ABCD ln_location_id : '||ln_location_id);
995: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_no : '||rec_lines.excise_invoice_no); -- Bug# 6109941
996: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_date : '||rec_lines.excise_invoice_date); -- Bug# 6109941
997:
998: END IF;

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

991: IF gv_debug THEN
992: fnd_file.put_line(fnd_file.log, 'ABCD def_inv_setup : lv_default_invoice_setup:'||lv_default_invoice_setup);
993: fnd_file.put_line(fnd_file.log, 'ABCD r_trx.organization_id : '||r_trx.organization_id);
994: fnd_file.put_line(fnd_file.log, 'ABCD ln_location_id : '||ln_location_id);
995: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_no : '||rec_lines.excise_invoice_no); -- Bug# 6109941
996: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_date : '||rec_lines.excise_invoice_date); -- Bug# 6109941
997:
998: END IF;
999:

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

992: fnd_file.put_line(fnd_file.log, 'ABCD def_inv_setup : lv_default_invoice_setup:'||lv_default_invoice_setup);
993: fnd_file.put_line(fnd_file.log, 'ABCD r_trx.organization_id : '||r_trx.organization_id);
994: fnd_file.put_line(fnd_file.log, 'ABCD ln_location_id : '||ln_location_id);
995: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_no : '||rec_lines.excise_invoice_no); -- Bug# 6109941
996: fnd_file.put_line(fnd_file.log, 'ABCD rec_lines.excise_invoice_date : '||rec_lines.excise_invoice_date); -- Bug# 6109941
997:
998: END IF;
999:
1000: IF upper(lv_default_invoice_setup) in ( 'Y', 'YES') then

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

1428:
1429: lv_currency_code := jai_constants.func_curr;
1430:
1431: IF gv_debug THEN
1432: fnd_file.put_line(fnd_file.log, 'r_base_trx.transaction_type:'||r_base_trx.transaction_type);
1433: END IF;
1434:
1435: ln_statement_id := 6;
1436: IF r_base_trx.transaction_type IN ('RECEIVE', 'MATCH') THEN

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

1435: ln_statement_id := 6;
1436: IF r_base_trx.transaction_type IN ('RECEIVE', 'MATCH') THEN
1437:
1438: IF gv_debug THEN
1439: fnd_file.put_line(fnd_file.log, '1 RECEIVE: Before insert_rcv_lines:');
1440: END IF;
1441:
1442: ln_statement_id := 7;
1443: --Populate the lines for quantity and Recoverable amount

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

1450: p_simulate_flag => lv_simulate_flag --File.Sql.35 Cbabu
1451: );
1452:
1453: IF gv_debug THEN
1454: fnd_file.put_line(fnd_file.log, '1.1 RECEIVE: After insert_rcv_lines:');
1455: END IF;
1456:
1457: IF lv_process_status <> jai_constants.successful THEN
1458: p_process_status := lv_process_status;

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

1495: ln_statement_id := 9;
1496: lv_accounting_type := 'REVERSAL';
1497:
1498: IF gv_debug THEN
1499: fnd_file.put_line(fnd_file.log, 'Inside RTV:');
1500: END IF;
1501:
1502: IF gv_debug THEN
1503: fnd_file.put_line(fnd_file.log, 'Before generate Schedule');

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

1499: fnd_file.put_line(fnd_file.log, 'Inside RTV:');
1500: END IF;
1501:
1502: IF gv_debug THEN
1503: fnd_file.put_line(fnd_file.log, 'Before generate Schedule');
1504: END IF;
1505:
1506: ln_statement_id := 10;
1507: generate_schedule (

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

1519: GOTO EXIT_POINT;
1520: END IF;
1521:
1522: IF gv_debug THEN
1523: fnd_file.put_line(fnd_file.log, 'After generate Schedule');
1524: END IF;
1525:
1526: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
1527: IF gv_debug THEN

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

1524: END IF;
1525:
1526: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
1527: IF gv_debug THEN
1528: fnd_file.put_line(fnd_file.log, 'r_base_trx.attribute_category'||r_base_trx.attribute_category);
1529: fnd_file.put_line(fnd_file.log, 'r_base_trx.attribute4'||r_base_trx.attribute4);
1530: END IF;
1531: */
1532:

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

1525:
1526: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
1527: IF gv_debug THEN
1528: fnd_file.put_line(fnd_file.log, 'r_base_trx.attribute_category'||r_base_trx.attribute_category);
1529: fnd_file.put_line(fnd_file.log, 'r_base_trx.attribute4'||r_base_trx.attribute4);
1530: END IF;
1531: */
1532:
1533: ln_statement_id := 11;

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

1574: GOTO EXIT_POINT;
1575: END IF;
1576:
1577: IF gv_debug THEN
1578: fnd_file.put_line(fnd_file.log, 'After update_rcv_lines:');
1579: END IF;
1580: ln_statement_id := 17;
1581:
1582: ELSIF r_base_trx.transaction_type = 'CORRECT' THEN

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

1585: ln_statement_id := 18;
1586: lv_accounting_type := 'REGULAR';
1587:
1588: IF gv_debug THEN
1589: fnd_file.put_line(fnd_file.log, 'r_trx.parent_transaction_type :'||r_trx.parent_transaction_type);
1590: END IF;
1591:
1592: ln_statement_id := 19;
1593: generate_schedule (

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

1606: END IF;
1607:
1608: ln_statement_id := 20;
1609: IF gv_debug THEN
1610: fnd_file.put_line(fnd_file.log, 'After Generate Schedule');
1611: END IF;
1612:
1613: OPEN c_vat_invoice(r_trx.parent_transaction_id);
1614: FETCH c_vat_invoice INTO r_vat_invoice;

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

1620: vat_invoice_date = r_vat_invoice.vat_invoice_date
1621: WHERE transaction_id = r_trx.transaction_id;
1622:
1623: IF gv_debug THEN
1624: fnd_file.put_line(fnd_file.log, 'Before Process_Claim');
1625: END IF;
1626:
1627: ln_statement_id := 22;
1628: --Call the Claim API with Shipment_line_id

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

1656: END IF;
1657:
1658: ln_statement_id := 23;
1659: IF gv_debug THEN
1660: fnd_file.put_line(fnd_file.log, 'After Process_claim');
1661: END IF;
1662:
1663: --ln_total_cenvat_amount := ln_total_cenvat_amount * r_txn.quantity_multiplier * ln_apportion_factor;
1664:

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

1680: END IF;
1681:
1682: ln_statement_id := 24;
1683: IF gv_debug THEN
1684: fnd_file.put_line(fnd_file.log, 'After Update_rcv_lines');
1685: END IF;
1686:
1687: ELSIF r_trx.parent_transaction_type = 'RETURN TO VENDOR' THEN
1688: lv_accounting_type := 'REVERSAL';

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

1689:
1690: ln_statement_id := 25;
1691:
1692: IF gv_debug THEN
1693: fnd_file.put_line(fnd_file.log, 'r_trx.parent_transaction_type :'||r_trx.parent_transaction_type);
1694: END IF;
1695:
1696: generate_schedule (
1697: p_shipment_header_id => r_base_trx.shipment_header_id,

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

1710:
1711: ln_statement_id := 26;
1712:
1713: IF gv_debug THEN
1714: fnd_file.put_line(fnd_file.log, 'After Generate Schedule');
1715: END IF;
1716:
1717: --Get the VAT Invoice no from Parent
1718: OPEN c_trx(r_base_trx.parent_transaction_id);

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

1727: vat_invoice_date = TRUNC(SYSDATE)
1728: WHERE transaction_id = r_base_trx.transaction_id; --r_trx now points to the parent transaction
1729:
1730: IF gv_debug THEN
1731: fnd_file.put_line(fnd_file.log, 'Before Process_Claim');
1732: END IF;
1733:
1734: ln_statement_id := 28;
1735:

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

1767: GOTO EXIT_POINT;
1768: END IF;
1769:
1770: IF gv_debug THEN
1771: fnd_file.put_line(fnd_file.log, 'After Process_claim');
1772: END IF;
1773: */
1774:
1775: --ln_total_cenvat_amount := ln_total_cenvat_amount * r_txn.quantity_multiplier * ln_apportion_factor;

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

1791: GOTO EXIT_POINT;
1792: END IF;
1793:
1794: IF gv_debug THEN
1795: fnd_file.put_line(fnd_file.log, 'After Update_rcv_lines');
1796: END IF;
1797:
1798: END IF;
1799: END IF;

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

1806: EXCEPTION
1807: WHEN OTHERS THEN
1808: p_process_status := jai_constants.unexpected_error;
1809: p_process_message := 'Stmt :'||ln_statement_id||' '||SUBSTR(SQLERRM,1,200);
1810: fnd_file.put_line(fnd_file.log, 'PROCESS_VAT ERROR:'||p_process_message);
1811:
1812: END process_vat;
1813:
1814: PROCEDURE process_claim(

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

1954: /* End of File.Sql.35 by Brathod */
1955:
1956:
1957: IF gv_debug THEN
1958: fnd_file.put_line(fnd_file.log, 'Inside Claim Process');
1959: END IF;
1960:
1961: OPEN c_regime(p_regime_id, NULL);
1962: FETCH c_regime INTO r_regime;

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

1978: p_force)
1979: LOOP
1980:
1981: IF gv_debug THEN
1982: fnd_file.put_line(fnd_file.log, 'Inside Loop');
1983: fnd_file.put_line(fnd_file.log, 'Installment Amount : '||rec_claims.installment_amount);
1984: fnd_file.put_line(fnd_file.log, 'receipt_num : '||rec_claims.receipt_num);
1985:
1986: END IF;

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

1979: LOOP
1980:
1981: IF gv_debug THEN
1982: fnd_file.put_line(fnd_file.log, 'Inside Loop');
1983: fnd_file.put_line(fnd_file.log, 'Installment Amount : '||rec_claims.installment_amount);
1984: fnd_file.put_line(fnd_file.log, 'receipt_num : '||rec_claims.receipt_num);
1985:
1986: END IF;
1987:

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

1980:
1981: IF gv_debug THEN
1982: fnd_file.put_line(fnd_file.log, 'Inside Loop');
1983: fnd_file.put_line(fnd_file.log, 'Installment Amount : '||rec_claims.installment_amount);
1984: fnd_file.put_line(fnd_file.log, 'receipt_num : '||rec_claims.receipt_num);
1985:
1986: END IF;
1987:
1988: 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 2054: fnd_file.put_line(fnd_file.log, 'Before Start of Accounting');

2050: FETCH c_claim_schedule INTO r_claim_schedule;
2051: CLOSE c_claim_schedule;
2052:
2053: IF gv_debug THEN
2054: fnd_file.put_line(fnd_file.log, 'Before Start of Accounting');
2055: END IF;
2056:
2057: --Accounting
2058: lv_currency_code := jai_constants.func_curr;

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

2127: ld_invoice_date := p_invoice_date;
2128: END IF;
2129:
2130: IF gv_debug THEN
2131: fnd_file.put_line(fnd_file.log, 'Before Passing the Repository Entry');
2132: END IF;
2133:
2134: IF NVL(ln_entered_cr,0) <> 0 OR NVL(ln_entered_dr,0) <> 0 THEN --Added for Bug#4950914
2135: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry(

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

2173:
2174: );
2175:
2176: IF gv_debug THEN
2177: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);
2178: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);
2179: END IF;
2180:
2181:

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

2174: );
2175:
2176: IF gv_debug THEN
2177: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);
2178: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);
2179: END IF;
2180:
2181:
2182: IF lv_process_status <> jai_constants.successful THEN

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

2186: END IF;
2187: END IF;
2188:
2189: IF gv_debug THEN
2190: fnd_file.put_line(fnd_file.log, 'After Passing the Repository Entry');
2191: END IF;
2192:
2193: -- Dr VAT Recovery
2194: ln_entered_dr := rec_claims.installment_amount;

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

2279: END IF;
2280: END IF;
2281:
2282: IF gv_debug THEN
2283: fnd_file.put_line(fnd_file.log, 'After Passing the Accounting Entry');
2284: END IF;
2285:
2286: UPDATE jai_rcv_rgm_claims
2287: SET status = 'Y',

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

2740:
2741: -- LOOP Through DELIVER/RTR
2742:
2743: IF gv_debug THEN
2744: fnd_file.put_line(fnd_file.log, 'Before the Deliver RTR Transaction Cost Reversal');
2745: fnd_file.put_line(fnd_file.log, 'Shipment_header_id'||r_shipment_lines.shipment_header_id);
2746: fnd_file.put_line(fnd_file.log, 'Shipment_line_id'||r_shipment_lines.shipment_line_id);
2747: END IF;
2748:

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

2741: -- LOOP Through DELIVER/RTR
2742:
2743: IF gv_debug THEN
2744: fnd_file.put_line(fnd_file.log, 'Before the Deliver RTR Transaction Cost Reversal');
2745: fnd_file.put_line(fnd_file.log, 'Shipment_header_id'||r_shipment_lines.shipment_header_id);
2746: fnd_file.put_line(fnd_file.log, 'Shipment_line_id'||r_shipment_lines.shipment_line_id);
2747: END IF;
2748:
2749: lv_ttype_deliver := 'DELIVER' ;

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

2742:
2743: IF gv_debug THEN
2744: fnd_file.put_line(fnd_file.log, 'Before the Deliver RTR Transaction Cost Reversal');
2745: fnd_file.put_line(fnd_file.log, 'Shipment_header_id'||r_shipment_lines.shipment_header_id);
2746: fnd_file.put_line(fnd_file.log, 'Shipment_line_id'||r_shipment_lines.shipment_line_id);
2747: END IF;
2748:
2749: lv_ttype_deliver := 'DELIVER' ;
2750: lv_ttype_rtr := 'RETURN TO RECEIVING' ;

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

2762: ln_process_special_amount := rec_total_tax.tax_amount *
2763: ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(r_deliver_rtr_txns.transaction_id)) *
2764: r_deliver_rtr_txns.quantity_multiplier;
2765: IF gv_debug THEN
2766: fnd_file.put_line(fnd_file.log, 'In the LOOP');
2767: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id'||r_deliver_rtr_txns.Tax_transaction_id);
2768: fnd_file.put_line(fnd_file.log, 'transaction_id'||r_deliver_rtr_txns.transaction_id);
2769: fnd_file.put_line(fnd_file.log, 'currency_conversion_rate'||r_receive_transaction.currency_conversion_rate);
2770: fnd_file.put_line(fnd_file.log, 'Tax_amount'||rec_total_tax.tax_amount);

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

2763: ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(r_deliver_rtr_txns.transaction_id)) *
2764: r_deliver_rtr_txns.quantity_multiplier;
2765: IF gv_debug THEN
2766: fnd_file.put_line(fnd_file.log, 'In the LOOP');
2767: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id'||r_deliver_rtr_txns.Tax_transaction_id);
2768: fnd_file.put_line(fnd_file.log, 'transaction_id'||r_deliver_rtr_txns.transaction_id);
2769: fnd_file.put_line(fnd_file.log, 'currency_conversion_rate'||r_receive_transaction.currency_conversion_rate);
2770: fnd_file.put_line(fnd_file.log, 'Tax_amount'||rec_total_tax.tax_amount);
2771: 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 2768: fnd_file.put_line(fnd_file.log, 'transaction_id'||r_deliver_rtr_txns.transaction_id);

2764: r_deliver_rtr_txns.quantity_multiplier;
2765: IF gv_debug THEN
2766: fnd_file.put_line(fnd_file.log, 'In the LOOP');
2767: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id'||r_deliver_rtr_txns.Tax_transaction_id);
2768: fnd_file.put_line(fnd_file.log, 'transaction_id'||r_deliver_rtr_txns.transaction_id);
2769: fnd_file.put_line(fnd_file.log, 'currency_conversion_rate'||r_receive_transaction.currency_conversion_rate);
2770: fnd_file.put_line(fnd_file.log, 'Tax_amount'||rec_total_tax.tax_amount);
2771: fnd_file.put_line(fnd_file.log, 'Apportion Factor'||ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(r_deliver_rtr_txns.transaction_id)));
2772:

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

2765: IF gv_debug THEN
2766: fnd_file.put_line(fnd_file.log, 'In the LOOP');
2767: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id'||r_deliver_rtr_txns.Tax_transaction_id);
2768: fnd_file.put_line(fnd_file.log, 'transaction_id'||r_deliver_rtr_txns.transaction_id);
2769: fnd_file.put_line(fnd_file.log, 'currency_conversion_rate'||r_receive_transaction.currency_conversion_rate);
2770: fnd_file.put_line(fnd_file.log, 'Tax_amount'||rec_total_tax.tax_amount);
2771: fnd_file.put_line(fnd_file.log, 'Apportion Factor'||ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(r_deliver_rtr_txns.transaction_id)));
2772:
2773: END IF;

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

2766: fnd_file.put_line(fnd_file.log, 'In the LOOP');
2767: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id'||r_deliver_rtr_txns.Tax_transaction_id);
2768: fnd_file.put_line(fnd_file.log, 'transaction_id'||r_deliver_rtr_txns.transaction_id);
2769: fnd_file.put_line(fnd_file.log, 'currency_conversion_rate'||r_receive_transaction.currency_conversion_rate);
2770: fnd_file.put_line(fnd_file.log, 'Tax_amount'||rec_total_tax.tax_amount);
2771: fnd_file.put_line(fnd_file.log, 'Apportion Factor'||ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(r_deliver_rtr_txns.transaction_id)));
2772:
2773: END IF;
2774:

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

2767: fnd_file.put_line(fnd_file.log, 'Tax_transaction_id'||r_deliver_rtr_txns.Tax_transaction_id);
2768: fnd_file.put_line(fnd_file.log, 'transaction_id'||r_deliver_rtr_txns.transaction_id);
2769: fnd_file.put_line(fnd_file.log, 'currency_conversion_rate'||r_receive_transaction.currency_conversion_rate);
2770: fnd_file.put_line(fnd_file.log, 'Tax_amount'||rec_total_tax.tax_amount);
2771: fnd_file.put_line(fnd_file.log, 'Apportion Factor'||ABS(jai_rcv_trx_processing_pkg.get_apportion_factor(r_deliver_rtr_txns.transaction_id)));
2772:
2773: END IF;
2774:
2775: jai_rcv_deliver_rtr_pkg.process_transaction(

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

3412: --Added by Bo Li for bug9305067 2010-4-14 END
3413: );
3414: ln_statement_id := 106;
3415: IF gv_debug THEN
3416: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);
3417: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);
3418: END IF;
3419:
3420: IF lv_process_status <> jai_constants.successful THEN

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

3413: );
3414: ln_statement_id := 106;
3415: IF gv_debug THEN
3416: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);
3417: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);
3418: END IF;
3419:
3420: IF lv_process_status <> jai_constants.successful THEN
3421: p_process_status := lv_process_status;

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

3478: );/*Bug 11880460 abezgam Changed the parameters from pv_attribute% to pv_tax_reference% as per precedure definition in jai_cmn_rgm_recording_pkg*/
3479:
3480: ln_statement_id := 109;
3481: IF gv_debug THEN
3482: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);
3483: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);
3484: END IF;
3485:
3486: IF lv_process_status <> jai_constants.successful THEN

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

3479:
3480: ln_statement_id := 109;
3481: IF gv_debug THEN
3482: fnd_file.put_line(fnd_file.log, 'lv_process_status'||lv_process_status);
3483: fnd_file.put_line(fnd_file.log, 'lv_process_message'||lv_process_message);
3484: END IF;
3485:
3486: IF lv_process_status <> jai_constants.successful THEN
3487: p_process_status := lv_process_status;

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

3635:
3636: ln_tax_amount := rec_tax.tax_amount*ln_apportion_factor;
3637:
3638: IF gv_debug THEN
3639: fnd_file.put_line(fnd_file.log, 'rec_tax.tax_amount:'||rec_tax.tax_amount);
3640: fnd_file.put_line(fnd_file.log, 'ln_tax_amount:'||ln_tax_amount);
3641: END IF;
3642:
3643: -- Added by JMEENA for bug#8302581

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

3636: ln_tax_amount := rec_tax.tax_amount*ln_apportion_factor;
3637:
3638: IF gv_debug THEN
3639: fnd_file.put_line(fnd_file.log, 'rec_tax.tax_amount:'||rec_tax.tax_amount);
3640: fnd_file.put_line(fnd_file.log, 'ln_tax_amount:'||ln_tax_amount);
3641: END IF;
3642:
3643: -- Added by JMEENA for bug#8302581
3644: OPEN get_item_id(p_transaction_id);

Line 3669: fnd_file.put_line(fnd_file.log, 'lv_account_name:'||lv_account_name||'jai_constants.recovery_interim:'|| jai_constants.recovery_interim);

3665: ELSE
3666: lv_account_name:= jai_constants.recovery_interim;
3667: END IF;
3668: -- End bug#8302581
3669: fnd_file.put_line(fnd_file.log, 'lv_account_name:'||lv_account_name||'jai_constants.recovery_interim:'|| jai_constants.recovery_interim);
3670: ln_debit_ccid :=
3671: jai_cmn_rgm_recording_pkg.get_account(
3672: p_regime_id => r_regime.regime_id,
3673: p_organization_type => jai_constants.orgn_type_io,