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

Line 739: fnd_file.put_line(FND_FILE.LOG, ' Value of total cnt '|| ln_total_count);

735: open c_check_not_validate(p_invoice_id, lv_section_type); -- Harshita, added lv_section_type for Bug 4870243
736: fetch c_check_not_validate into ln_total_count, ln_validated_a_cnt, ln_validated_t_cnt;
737: close c_check_not_validate;
738:
739: fnd_file.put_line(FND_FILE.LOG, ' Value of total cnt '|| ln_total_count);
740:
741: fnd_file.put_line(FND_FILE.LOG, ' Value of validated A cnt '|| ln_validated_a_cnt);
742: fnd_file.put_line(FND_FILE.LOG, ' Value of validated T cnt '|| ln_validated_t_cnt);
743:

Line 741: fnd_file.put_line(FND_FILE.LOG, ' Value of validated A cnt '|| ln_validated_a_cnt);

737: close c_check_not_validate;
738:
739: fnd_file.put_line(FND_FILE.LOG, ' Value of total cnt '|| ln_total_count);
740:
741: fnd_file.put_line(FND_FILE.LOG, ' Value of validated A cnt '|| ln_validated_a_cnt);
742: fnd_file.put_line(FND_FILE.LOG, ' Value of validated T cnt '|| ln_validated_t_cnt);
743:
744: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
745:

Line 742: fnd_file.put_line(FND_FILE.LOG, ' Value of validated T cnt '|| ln_validated_t_cnt);

738:
739: fnd_file.put_line(FND_FILE.LOG, ' Value of total cnt '|| ln_total_count);
740:
741: fnd_file.put_line(FND_FILE.LOG, ' Value of validated A cnt '|| ln_validated_a_cnt);
742: fnd_file.put_line(FND_FILE.LOG, ' Value of validated T cnt '|| ln_validated_t_cnt);
743:
744: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
745:
746: if ln_total_count = (ln_validated_a_cnt + ln_validated_t_cnt) then

Line 773: fnd_file.put_line(FND_FILE.LOG, 'Status_update_chk_validate - Status of parent invoice '|| p_is_invoice_validated);

769: end if;
770:
771: -- end if; /*commented by mmurtuza for bug 16016037 */
772:
773: fnd_file.put_line(FND_FILE.LOG, 'Status_update_chk_validate - Status of parent invoice '|| p_is_invoice_validated);
774:
775: << exit_from_procedure >>
776: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath, null, 'END'); /* 7 */
777: return;

Line 1150: fnd_file.put_line(FND_FILE.LOG, '1. Check for tax count'|| ln_count);

1146: open c_check_if_exists(p_invoice_id);
1147: fetch c_check_if_exists into ln_count;
1148: close c_check_if_exists;
1149:
1150: fnd_file.put_line(FND_FILE.LOG, '1. Check for tax count'|| ln_count);
1151:
1152: if nvl(ln_count, 0) = 0 then
1153: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
1154: fnd_file.put_line(FND_FILE.LOG, '2. TDS tax is not applicable');

Line 1154: fnd_file.put_line(FND_FILE.LOG, '2. TDS tax is not applicable');

1150: fnd_file.put_line(FND_FILE.LOG, '1. Check for tax count'|| ln_count);
1151:
1152: if nvl(ln_count, 0) = 0 then
1153: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
1154: fnd_file.put_line(FND_FILE.LOG, '2. TDS tax is not applicable');
1155: p_process_flag := 'X';
1156: p_process_message := ' TDS tax is not applicable';
1157: goto exit_from_procedure;
1158: end if;

Line 1165: fnd_file.put_line(FND_FILE.LOG, '3. Check for processed already '|| ln_cnt_already_processed);

1161: open c_check_if_processed(p_invoice_id,'P');
1162: fetch c_check_if_processed into ln_cnt_already_processed;
1163: close c_check_if_processed;
1164:
1165: fnd_file.put_line(FND_FILE.LOG, '3. Check for processed already '|| ln_cnt_already_processed);
1166:
1167: if nvl(ln_cnt_already_processed, 0) > 0 then
1168: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
1169: p_process_flag := 'X';

Line 1376: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 value of tax_amount before update'||ln_tax_amount);

1372: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1373: ln_tmp_tds_amt := get_rnded_value(ln_tmp_tds_amt);
1374: END IF;
1375: */
1376: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 value of tax_amount before update'||ln_tax_amount);
1377: -- End for bug 5722028.
1378: /* bug 7280925. Added by Lakshmi Gopalsami
1379: * changed from ln_tmp_tds_amt to ln_tax_amount
1380: */

Line 1399: fnd_file.put_line(FND_FILE.LOG,' 8. TDS Vendor type '|| lv_vendor_type_lookup_code);

1395: open c_po_vendors(p_vendor_id);
1396: fetch c_po_vendors into lv_vendor_type_lookup_code;
1397: close c_po_vendors;
1398:
1399: fnd_file.put_line(FND_FILE.LOG,' 8. TDS Vendor type '|| lv_vendor_type_lookup_code);
1400:
1401:
1402: lv_attr_code := 'TAN NO';
1403: lv_attr_type_code := 'PRIMARY';

Line 1407: fnd_file.put_line(FND_FILE.LOG,' 8.1 Pan number-> '|| lv_pan_no);

1403: lv_attr_type_code := 'PRIMARY';
1404: lv_tds_regime := 'TDS';
1405: lv_regn_type_others := 'OTHERS';
1406:
1407: fnd_file.put_line(FND_FILE.LOG,' 8.1 Pan number-> '|| lv_pan_no);
1408:
1409: fnd_file.put_line(FND_FILE.LOG,' 8.1 Tan number-> '|| lv_tan_no);
1410:
1411: /* Get the fin year */

Line 1409: fnd_file.put_line(FND_FILE.LOG,' 8.1 Tan number-> '|| lv_tan_no);

1405: lv_regn_type_others := 'OTHERS';
1406:
1407: fnd_file.put_line(FND_FILE.LOG,' 8.1 Pan number-> '|| lv_pan_no);
1408:
1409: fnd_file.put_line(FND_FILE.LOG,' 8.1 Tan number-> '|| lv_tan_no);
1410:
1411: /* Get the fin year */
1412: open c_get_fin_year(p_accounting_date, p_org_id);
1413: fetch c_get_fin_year into ln_fin_year;

Line 1416: fnd_file.put_line(FND_FILE.LOG,' 8.2 Fin Year -> '|| ln_fin_year);

1412: open c_get_fin_year(p_accounting_date, p_org_id);
1413: fetch c_get_fin_year into ln_fin_year;
1414: close c_get_fin_year;
1415:
1416: fnd_file.put_line(FND_FILE.LOG,' 8.2 Fin Year -> '|| ln_fin_year);
1417:
1418: /* Start Loop through for each tds section and process for TDS section taxes only */
1419: /* This section is meant for threshold, specific to TDS section taxes only */
1420: /*Bug 12671504 - Replaced ln_prepayment_app_amt with ln_application_amount as it is the correct Prepayment applied amount

Line 1437: fnd_file.put_line(FND_FILE.LOG,' 9. Threshold hdr id-> '|| ln_threshold_hdr_id);

1433: (p_vendor_id , p_vendor_site_id , cur_rec_section.actual_section_code,'TDS_SECTION'); --rchandan for bug#4428980
1434: fetch c_get_threshold into ln_threshold_hdr_id;
1435: close c_get_threshold; --Commented by xiao for bug#6596019
1436:
1437: fnd_file.put_line(FND_FILE.LOG,' 9. Threshold hdr id-> '|| ln_threshold_hdr_id);
1438:
1439: /* if nvl(ln_threshold_hdr_id, 0) = 0 then
1440: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); -- 10
1441: fnd_file.put_line(FND_FILE.LOG, '10. Threshold is not defined for the

Line 1441: fnd_file.put_line(FND_FILE.LOG, '10. Threshold is not defined for the

1437: fnd_file.put_line(FND_FILE.LOG,' 9. Threshold hdr id-> '|| ln_threshold_hdr_id);
1438:
1439: /* if nvl(ln_threshold_hdr_id, 0) = 0 then
1440: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); -- 10
1441: fnd_file.put_line(FND_FILE.LOG, '10. Threshold is not defined for the
1442: applicable TDS section '||
1443: cur_rec_section.actual_section_code||
1444: '- Error');
1445: p_process_flag := 'E';

Line 1457: fnd_file.put_line(FND_FILE.LOG, '11. Threshold grp id ->'||ln_threshold_grp_id);

1453: open c_get_threshold_group(p_vendor_id, lv_tan_no, lv_pan_no, cur_rec_section.actual_section_code, ln_fin_year,'TDS_SECTION'); --rchandan for bug#4428980
1454: fetch c_get_threshold_group into ln_threshold_grp_id;
1455: close c_get_threshold_group;
1456:
1457: fnd_file.put_line(FND_FILE.LOG, '11. Threshold grp id ->'||ln_threshold_grp_id);
1458:
1459: /* Get the threshold group details */
1460: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
1461: if nvl(ln_threshold_grp_id, 0) <> 0 then

Line 1479: fnd_file.put_line(FND_FILE.LOG, '12. Total invoice amount -> '||

1475: ln_total_invoice_amount := 0;
1476:
1477: end if;
1478:
1479: fnd_file.put_line(FND_FILE.LOG, '12. Total invoice amount -> '||
1480: ln_total_invoice_amount);
1481:
1482: /* Get the threshold position before this invoice impact */
1483: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */

Line 1493: fnd_file.put_line(FND_FILE.LOG, '15. Threshold slab id before '||

1489: close c_jai_ap_tds_thhold_slabs;
1490:
1491: ln_threshold_slab_id_before := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);
1492:
1493: fnd_file.put_line(FND_FILE.LOG, '15. Threshold slab id before '||
1494: ln_threshold_slab_id_before);
1495:
1496: /* Get the threshold position after this invoice impact */
1497: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */

Line 1521: fnd_file.put_line(FND_FILE.LOG, '16. Threshold slab id after ->'||

1517: close c_check_slabs_end_dated; */ --commented by bgowrava for bug#6596019
1518: /*end addition for bug 6345725*/
1519:
1520:
1521: fnd_file.put_line(FND_FILE.LOG, '16. Threshold slab id after ->'||
1522: ln_threshold_slab_id_after);
1523: --p_codepath := p_codepath || to_char(ln_threshold_slab_id_after) || '**'; --commented by Bgowrava for Bug#8716477
1524: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath); /* 17 */
1525: if ln_threshold_slab_id_after <> 0 then

Line 1534: fnd_file.put_line(FND_FILE.LOG, '19. Generate invoices -> ' ||

1530: lv_generate_all_invoices := 'N';
1531: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath); /* 19 */
1532: end if; /* if ln_threshold_slab_id_after <> 0 */
1533:
1534: fnd_file.put_line(FND_FILE.LOG, '19. Generate invoices -> ' ||
1535: lv_generate_all_invoices);
1536:
1537: /* Check for Single Invoice threshold if cumulative has not been reached */
1538: if lv_generate_all_invoices = 'N' then

Line 1553: fnd_file.put_line(FND_FILE.LOG, '19.1 Call maintain thhold grps ');

1549: if nvl(ln_threshold_grp_id, 0) = 0 then
1550:
1551: p_codepath := jai_general_pkg.plot_codepath(19.1, p_codepath); /* 19.1 */
1552:
1553: fnd_file.put_line(FND_FILE.LOG, '19.1 Call maintain thhold grps ');
1554:
1555: jai_ap_tds_generation_pkg.maintain_thhold_grps
1556: (
1557: p_threshold_grp_id => ln_threshold_grp_id,

Line 1576: fnd_file.put_line(FND_FILE.LOG, '19.1 Process flag '|| p_process_flag);

1572: P_process_message => P_process_message,
1573: p_codepath => p_codepath
1574: );
1575:
1576: fnd_file.put_line(FND_FILE.LOG, '19.1 Process flag '|| p_process_flag);
1577: fnd_file.put_line(FND_FILE.LOG, '19.1 Process message '|| p_process_message);
1578:
1579: else
1580:

Line 1577: fnd_file.put_line(FND_FILE.LOG, '19.1 Process message '|| p_process_message);

1573: p_codepath => p_codepath
1574: );
1575:
1576: fnd_file.put_line(FND_FILE.LOG, '19.1 Process flag '|| p_process_flag);
1577: fnd_file.put_line(FND_FILE.LOG, '19.1 Process message '|| p_process_message);
1578:
1579: else
1580:
1581: p_codepath := jai_general_pkg.plot_codepath(19.2, p_codepath); /* 19.2 */

Line 1595: fnd_file.put_line(FND_FILE.LOG, '19.2 Process flag '|| p_process_flag);

1591: P_process_message => P_process_message,
1592: p_codepath => p_codepath
1593: );
1594:
1595: fnd_file.put_line(FND_FILE.LOG, '19.2 Process flag '|| p_process_flag);
1596: fnd_file.put_line(FND_FILE.LOG, '19.2 Process message '|| p_process_message);
1597:
1598: end if;
1599:

Line 1596: fnd_file.put_line(FND_FILE.LOG, '19.2 Process message '|| p_process_message);

1592: p_codepath => p_codepath
1593: );
1594:
1595: fnd_file.put_line(FND_FILE.LOG, '19.2 Process flag '|| p_process_flag);
1596: fnd_file.put_line(FND_FILE.LOG, '19.2 Process message '|| p_process_message);
1597:
1598: end if;
1599:
1600: --Added by Sanjikum for Bug#5131075(4722011)

Line 1642: fnd_file.put_line(FND_FILE.LOG, '20. Call generate tds invoices' );

1638: lv_tds_invoice_num := null;
1639: lv_tds_cm_num := null;
1640: p_process_flag := null;
1641:
1642: fnd_file.put_line(FND_FILE.LOG, '20. Call generate tds invoices' );
1643:
1644: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - tax amount while calling generate tds invoices '|| cur_rec.tax_amount);
1645:
1646: jai_ap_tds_generation_pkg.generate_tds_invoices

Line 1644: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - tax amount while calling generate tds invoices '|| cur_rec.tax_amount);

1640: p_process_flag := null;
1641:
1642: fnd_file.put_line(FND_FILE.LOG, '20. Call generate tds invoices' );
1643:
1644: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - tax amount while calling generate tds invoices '|| cur_rec.tax_amount);
1645:
1646: jai_ap_tds_generation_pkg.generate_tds_invoices
1647: (
1648: pn_invoice_id => p_invoice_id ,

Line 1668: fnd_file.put_line(FND_FILE.LOG, '20 Process flag '|| p_process_flag);

1664: );
1665:
1666:
1667: if p_process_flag = 'E' then
1668: fnd_file.put_line(FND_FILE.LOG, '20 Process flag '|| p_process_flag);
1669: fnd_file.put_line(FND_FILE.LOG, '20 Process message '|| p_process_message);
1670: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
1671: goto exit_from_procedure;
1672: end if;

Line 1669: fnd_file.put_line(FND_FILE.LOG, '20 Process message '|| p_process_message);

1665:
1666:
1667: if p_process_flag = 'E' then
1668: fnd_file.put_line(FND_FILE.LOG, '20 Process flag '|| p_process_flag);
1669: fnd_file.put_line(FND_FILE.LOG, '20 Process message '|| p_process_message);
1670: p_codepath := jai_general_pkg.plot_codepath(21, p_codepath); /* 21 */
1671: goto exit_from_procedure;
1672: end if;
1673:

Line 1680: fnd_file.put_line(FND_FILE.LOG,' 22. start thhold trx id '||

1676: if ln_start_threshold_trx_id is null then
1677: ln_start_threshold_trx_id := ln_threshold_trx_id;
1678: end if;
1679:
1680: fnd_file.put_line(FND_FILE.LOG,' 22. start thhold trx id '||
1681: ln_start_threshold_trx_id);
1682:
1683: /* Bug 7280925. Added by Lakshmi Gopalsami -- can be removed
1684: * Need to round the value before calling maintain_thhold_grps

Line 1692: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value of tmp tds before maintain thhold grps'||ln_tax_amount);

1688: ln_tmp_tds_amt := get_rnded_value(cur_rec.tax_amount);
1689: END IF;
1690: */
1691:
1692: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value of tmp tds before maintain thhold grps'||ln_tax_amount);
1693:
1694: /* Update the total tax amount for which invoice was raised */
1695:
1696: /* bug 7280925. Added by Lakshmi Gopalsami

Line 1715: fnd_file.put_line(FND_FILE.LOG, '23 Process flag '|| p_process_flag);

1711: P_process_message => P_process_message,
1712: p_codepath => p_codepath
1713: );
1714:
1715: fnd_file.put_line(FND_FILE.LOG, '23 Process flag '|| p_process_flag);
1716: fnd_file.put_line(FND_FILE.LOG, '23 Process message '|| p_process_message);
1717:
1718: --Added by Sanjikum for Bug#5131075(4722011)
1719: IF p_process_flag = 'E' THEN

Line 1716: fnd_file.put_line(FND_FILE.LOG, '23 Process message '|| p_process_message);

1712: p_codepath => p_codepath
1713: );
1714:
1715: fnd_file.put_line(FND_FILE.LOG, '23 Process flag '|| p_process_flag);
1716: fnd_file.put_line(FND_FILE.LOG, '23 Process message '|| p_process_message);
1717:
1718: --Added by Sanjikum for Bug#5131075(4722011)
1719: IF p_process_flag = 'E' THEN
1720: p_codepath := jai_general_pkg.plot_codepath(23.1, p_codepath); /* 23.1 */

Line 1768: fnd_file.put_line(FND_FILE.LOG, '26. Call process transition ');

1764: --4407184
1765: lv_slab_transition_tds_event := 'THRESHOLD TRANSITION(from slab id -' || ln_threshold_slab_id_before ||
1766: 'to slab id - ' || ln_threshold_slab_id_after || ')';
1767:
1768: fnd_file.put_line(FND_FILE.LOG, '26. Call process transition ');
1769: fnd_file.put_line(FND_FILE.LOG, '26. Event is '|| lv_slab_transition_tds_event);
1770:
1771: process_threshold_transition
1772: (

Line 1769: fnd_file.put_line(FND_FILE.LOG, '26. Event is '|| lv_slab_transition_tds_event);

1765: lv_slab_transition_tds_event := 'THRESHOLD TRANSITION(from slab id -' || ln_threshold_slab_id_before ||
1766: 'to slab id - ' || ln_threshold_slab_id_after || ')';
1767:
1768: fnd_file.put_line(FND_FILE.LOG, '26. Call process transition ');
1769: fnd_file.put_line(FND_FILE.LOG, '26. Event is '|| lv_slab_transition_tds_event);
1770:
1771: process_threshold_transition
1772: (
1773: p_threshold_grp_id => ln_threshold_grp_id,

Line 1788: fnd_file.put_line(FND_FILE.LOG, '27 Process flag '|| p_process_flag);

1784: p_process_message => p_process_message
1785: );
1786:
1787: if p_process_flag = 'E' then
1788: fnd_file.put_line(FND_FILE.LOG, '27 Process flag '|| p_process_flag);
1789: fnd_file.put_line(FND_FILE.LOG, '27 Process message '|| p_process_message);
1790:
1791: p_codepath := jai_general_pkg.plot_codepath(27, p_codepath); /* 27 */
1792: goto exit_from_procedure;

Line 1789: fnd_file.put_line(FND_FILE.LOG, '27 Process message '|| p_process_message);

1785: );
1786:
1787: if p_process_flag = 'E' then
1788: fnd_file.put_line(FND_FILE.LOG, '27 Process flag '|| p_process_flag);
1789: fnd_file.put_line(FND_FILE.LOG, '27 Process message '|| p_process_message);
1790:
1791: p_codepath := jai_general_pkg.plot_codepath(27, p_codepath); /* 27 */
1792: goto exit_from_procedure;
1793: end if;

Line 1813: fnd_file.put_line(FND_FILE.LOG, '31 Call generate tds invoices ');

1809: lv_tds_invoice_num := null;
1810: lv_tds_cm_num := null;
1811: p_process_flag := null;
1812:
1813: fnd_file.put_line(FND_FILE.LOG, '31 Call generate tds invoices ');
1814:
1815: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - WCT Tax amt '||cur_non_tds_rec.tax_amount);
1816:
1817: jai_ap_tds_generation_pkg.generate_tds_invoices

Line 1815: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - WCT Tax amt '||cur_non_tds_rec.tax_amount);

1811: p_process_flag := null;
1812:
1813: fnd_file.put_line(FND_FILE.LOG, '31 Call generate tds invoices ');
1814:
1815: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - WCT Tax amt '||cur_non_tds_rec.tax_amount);
1816:
1817: jai_ap_tds_generation_pkg.generate_tds_invoices
1818: (
1819: pn_invoice_id => p_invoice_id ,

Line 1838: fnd_file.put_line(FND_FILE.LOG, '31 Process flag '|| p_process_flag);

1834: p_process_message => p_process_message
1835: );
1836:
1837: if p_process_flag = 'E' then
1838: fnd_file.put_line(FND_FILE.LOG, '31 Process flag '|| p_process_flag);
1839: fnd_file.put_line(FND_FILE.LOG, '31 Process message '|| p_process_message);
1840:
1841: p_codepath := jai_general_pkg.plot_codepath(32, p_codepath); /* 32 */
1842: goto exit_from_procedure;

Line 1839: fnd_file.put_line(FND_FILE.LOG, '31 Process message '|| p_process_message);

1835: );
1836:
1837: if p_process_flag = 'E' then
1838: fnd_file.put_line(FND_FILE.LOG, '31 Process flag '|| p_process_flag);
1839: fnd_file.put_line(FND_FILE.LOG, '31 Process message '|| p_process_message);
1840:
1841: p_codepath := jai_general_pkg.plot_codepath(32, p_codepath); /* 32 */
1842: goto exit_from_procedure;
1843: end if;

Line 1852: fnd_file.put_line(FND_FILE.LOG, '34. Start thhold trx id '|| ln_start_threshold_trx_id);

1848: p_codepath := jai_general_pkg.plot_codepath(34, p_codepath); /* 34 */
1849: ln_start_threshold_trx_id := ln_threshold_trx_id;
1850: end if;
1851:
1852: fnd_file.put_line(FND_FILE.LOG, '34. Start thhold trx id '|| ln_start_threshold_trx_id);
1853:
1854: /* Punch threshold_trx_id in jai_ap_tds_inv_taxes */
1855: update jai_ap_tds_inv_taxes
1856: set threshold_trx_id = ln_threshold_trx_id,

Line 1871: fnd_file.put_line(FND_FILE.LOG, '35. called from '|| p_call_from);

1867:
1868:
1869: /* If the process is called from batch do not fire import request */
1870:
1871: fnd_file.put_line(FND_FILE.LOG, '35. called from '|| p_call_from);
1872:
1873: if p_call_from <> 'BATCH' then
1874: /* Not Called from Batch */
1875:

Line 1880: fnd_file.put_line(FND_FILE.LOG, '36 start thhold trx id '||

1876: p_codepath := jai_general_pkg.plot_codepath(36, p_codepath); /* 36 */
1877:
1878: if ln_start_threshold_trx_id is not null then
1879:
1880: fnd_file.put_line(FND_FILE.LOG, '36 start thhold trx id '||
1881: ln_start_threshold_trx_id);
1882:
1883: p_codepath := jai_general_pkg.plot_codepath(37, p_codepath); /* 37 */
1884: import_and_approve

Line 1893: fnd_file.put_line(FND_FILE.LOG, '37 Process flag '|| p_process_flag);

1889: p_process_flag => p_process_flag,
1890: p_process_message => p_process_message
1891: );
1892:
1893: fnd_file.put_line(FND_FILE.LOG, '37 Process flag '|| p_process_flag);
1894: fnd_file.put_line(FND_FILE.LOG, '37 Process message '|| p_process_message);
1895:
1896: --Added by Sanjikum for Bug#5131075(4722011)
1897: IF p_process_flag = 'E' THEN

Line 1894: fnd_file.put_line(FND_FILE.LOG, '37 Process message '|| p_process_message);

1890: p_process_message => p_process_message
1891: );
1892:
1893: fnd_file.put_line(FND_FILE.LOG, '37 Process flag '|| p_process_flag);
1894: fnd_file.put_line(FND_FILE.LOG, '37 Process message '|| p_process_message);
1895:
1896: --Added by Sanjikum for Bug#5131075(4722011)
1897: IF p_process_flag = 'E' THEN
1898: p_codepath := jai_general_pkg.plot_codepath(37.1, p_codepath); /* 37.1 */

Line 2316: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_tds_amount);

2312: -- Bug 7280925. Commented by Lakshmi Gopalsami ('INVOICE CANCEL',
2313: ('PREPAYMENT UNAPPLICATION')
2314: THEN
2315: ln_invoice_to_tds_amount := ROUND(ln_invoice_to_tds_amount,g_inr_currency_rounding);
2316: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_tds_amount);
2317: IF trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
2318: /* Bug 7280925. Added by Lakshmi Gopalsami
2319: * we should not round for WCT and ESSI. For those threshold_grp_id
2320: * will be null

Line 2325: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round per setup TDS auth inv'||ln_invoice_to_tds_amount);

2321: */
2322: and pn_threshold_grp_id is not null
2323: THEN
2324: ln_invoice_to_tds_amount := get_rnded_value(ln_invoice_to_tds_amount);
2325: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round per setup TDS auth inv'||ln_invoice_to_tds_amount);
2326: END IF;
2327: END IF ; -- pv_tds_event not in
2328:
2329: -- End for Bug 5722028

Line 2444: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_vendor_amount);

2440: END IF; --2
2441: END IF;
2442:
2443:
2444: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_vendor_amount);
2445: /*IF trunc(pd_creation_date) >=
2446: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
2447: and pn_threshold_grp_id is not null
2448: THEN

Line 2450: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round per setup - vendor invoice'||ln_invoice_to_vendor_amount);

2446: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
2447: and pn_threshold_grp_id is not null
2448: THEN
2449: ln_invoice_to_vendor_amount := get_rnded_value(ln_invoice_to_vendor_amount);
2450: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round per setup - vendor invoice'||ln_invoice_to_vendor_amount);
2451: END IF; */ --commented by bgowrava for Bug#8995604
2452:
2453:
2454: if upper(r_ap_invoices_all.exchange_rate_type) = 'USER' then

Line 2460: fnd_file.put_line(FND_FILE.LOG, ' CALL utils for inserting interface lines');

2456: else
2457: ln_exchange_rate := null;
2458: end if;
2459:
2460: fnd_file.put_line(FND_FILE.LOG, ' CALL utils for inserting interface lines');
2461:
2462: /*Bug 9759709 - Liability Account for the Credit Note must be fetched from the Standard Invoice
2463: If it is not present, then it needs to be defaulted from Vendor Site Setup. Passing NULL to
2464: parameter p_accts_pay_ccid in jai_ap_utils_pkg.insert_ap_inv_interface would cause it to default

Line 2545: Fnd_File.put_line(Fnd_File.LOG, 'pn_taxable_amount '||pn_taxable_amount);

2541: * in the insert to jai_ap_tds_thhold_trxs. This has to be derived irrespective
2542: * of the tds event.
2543: */
2544:
2545: Fnd_File.put_line(Fnd_File.LOG, 'pn_taxable_amount '||pn_taxable_amount);
2546: /*IF pn_taxable_amount IS NOT NULL THEN
2547: ln_invoice_amount := pn_taxable_amount;
2548: ELSE*/ /*Commented the above if condition for bug 13070779 */
2549: ln_invoice_amount := pn_tax_amount * ( 100 / r_ja_in_tax_codes.tax_rate);

Line 2551: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);

2547: ln_invoice_amount := pn_taxable_amount;
2548: ELSE*/ /*Commented the above if condition for bug 13070779 */
2549: ln_invoice_amount := pn_tax_amount * ( 100 / r_ja_in_tax_codes.tax_rate);
2550: -- END IF;
2551: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
2552:
2553: /* For downward compatibility with the pre-cleanup code */
2554: if ( (pv_tds_event = 'INVOICE VALIDATE') or (pv_tds_event like 'THRESHOLD TRANSITION%') ) then
2555:

Line 2569: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);

2565: ELSIF r_ja_in_tax_codes.section_type = 'ESSI_SECTION' THEN
2566: lv_source_attribute := 'ATTRIBUTE3';
2567: END IF;
2568:
2569: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
2570: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
2571: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
2572: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
2573: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);

Line 2570: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);

2566: lv_source_attribute := 'ATTRIBUTE3';
2567: END IF;
2568:
2569: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
2570: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
2571: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
2572: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
2573: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
2574: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);

Line 2571: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);

2567: END IF;
2568:
2569: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
2570: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
2571: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
2572: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
2573: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
2574: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
2575: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);

Line 2572: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);

2568:
2569: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
2570: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
2571: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
2572: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
2573: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
2574: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
2575: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
2576: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);

Line 2573: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);

2569: fnd_file.put_line(FND_FILE.LOG, ' invoice id '|| pn_invoice_id);
2570: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
2571: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
2572: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
2573: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
2574: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
2575: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
2576: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
2577: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);

Line 2574: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);

2570: fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
2571: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
2572: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
2573: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
2574: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
2575: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
2576: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
2577: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
2578: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);

Line 2575: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);

2571: fnd_file.put_line(FND_FILE.LOG, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
2572: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
2573: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
2574: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
2575: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
2576: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
2577: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
2578: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
2579: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);

Line 2576: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);

2572: fnd_file.put_line(FND_FILE.LOG, 'vendor num' ||lv_invoice_to_vendor_num);
2573: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
2574: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
2575: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
2576: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
2577: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
2578: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
2579: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
2580:

Line 2577: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);

2573: fnd_file.put_line(FND_FILE.LOG, 'tax id '||pn_tax_id);
2574: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
2575: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
2576: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
2577: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
2578: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
2579: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
2580:
2581: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019

Line 2578: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);

2574: fnd_file.put_line(FND_FILE.LOG, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
2575: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
2576: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
2577: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
2578: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
2579: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
2580:
2581: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019
2582: insert into JAI_AP_TDS_INVOICES

Line 2579: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);

2575: fnd_file.put_line(FND_FILE.LOG, 'tds amt'||ln_invoice_to_tds_amount);
2576: fnd_file.put_line(FND_FILE.LOG, 'sec code '||r_ja_in_tax_codes.section_code);
2577: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
2578: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
2579: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
2580:
2581: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019
2582: insert into JAI_AP_TDS_INVOICES
2583: (TDS_INVOICE_ID,

Line 2661: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round before insert into trxs'||ln_tds_rnded_amt);

2657: and pn_threshold_grp_id is not null )
2658: THEN
2659: ln_tds_rnding_factor := jai_ap_tds_generation_pkg.gn_tds_rounding_factor;
2660: ln_tds_rnded_amt := get_rnded_value(ln_tds_rnded_amt);
2661: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round before insert into trxs'||ln_tds_rnded_amt);
2662: END IF;
2663: ln_tds_rnded_amt := ROUND(pn_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
2664: END IF ;
2665: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_tds_rnded_amt);

Line 2665: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_tds_rnded_amt);

2661: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round before insert into trxs'||ln_tds_rnded_amt);
2662: END IF;
2663: ln_tds_rnded_amt := ROUND(pn_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
2664: END IF ;
2665: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_tds_rnded_amt);
2666:
2667: END IF;
2668: -- End for bug 5722028.
2669:

Line 3311: fnd_file.put_line (fnd_file.log, 'p_tds_event='||p_tds_event);

3307: lv_batch_name ap_batches_all.batch_name%TYPE; --added by Ramananda for Bug#4584221
3308: lv_group_id VARCHAR2(80); --Added by Sanjikum for Bug#5131075(4722011)
3309:
3310: begin
3311: fnd_file.put_line (fnd_file.log, 'p_tds_event='||p_tds_event);
3312: --Added by Sanjikum for Bug#5131075(4722011)
3313: IF p_tds_event = 'PREPAYMENT APPLICATION' OR p_tds_event = 'PREPAYMENT UNAPPLICATION' THEN
3314: lv_group_id := to_char(p_invoice_id)||p_tds_event;
3315: ELSE

Line 3476: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');

3472:
3473: begin
3474:
3475: /* Check for the status of the import request */
3476: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
3477: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
3478: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
3479: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
3480: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);

Line 3477: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);

3473: begin
3474:
3475: /* Check for the status of the import request */
3476: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
3477: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
3478: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
3479: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
3480: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);
3481: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);

Line 3478: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );

3474:
3475: /* Check for the status of the import request */
3476: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
3477: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
3478: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
3479: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
3480: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);
3481: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);
3482:

Line 3479: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);

3475: /* Check for the status of the import request */
3476: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
3477: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
3478: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
3479: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
3480: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);
3481: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);
3482:
3483: lb_request_status :=

Line 3480: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);

3476: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
3477: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
3478: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
3479: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
3480: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);
3481: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);
3482:
3483: lb_request_status :=
3484: fnd_concurrent.wait_for_request

Line 3481: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);

3477: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
3478: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
3479: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
3480: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);
3481: Fnd_File.put_line(Fnd_File.LOG, 'p_start_thhold_trx_id=> ' || p_start_thhold_trx_id);
3482:
3483: lb_request_status :=
3484: fnd_concurrent.wait_for_request
3485: (

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

3495:
3496:
3497: if not ( lv_dev_phase = 'COMPLETE' and lv_dev_status = 'NORMAL' ) then
3498:
3499: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');
3500: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || lv_message);
3501: retcode := 1;
3502: errbuf := 'Exiting with warnings as parent request not completed with normal status';
3503: goto exit_from_procedure;

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

3496:
3497: if not ( lv_dev_phase = 'COMPLETE' and lv_dev_status = 'NORMAL' ) then
3498:
3499: Fnd_File.put_line(Fnd_File.LOG, 'Exiting with warning as parent request not completed with normal status');
3500: Fnd_File.put_line(Fnd_File.LOG, 'Message from parent request :' || lv_message);
3501: retcode := 1;
3502: errbuf := 'Exiting with warnings as parent request not completed with normal status';
3503: goto exit_from_procedure;
3504:

Line 3508: Fnd_File.put_line(Fnd_File.LOG, 'Before Loop ');

3504:
3505: end if;
3506:
3507: /* Control comes here only when the concurrent request has completed with Normal Status */
3508: Fnd_File.put_line(Fnd_File.LOG, 'Before Loop ');
3509:
3510: /* Get all the tds invoices that have been created and call the base API to approve it */
3511: for cur_rec in
3512: c_jai_ap_tds_thhold_trxs(p_invoice_id , p_start_thhold_trx_id , p_vendor_id , p_vendor_site_id)

Line 3526: fnd_file.put_line(FND_FILE.LOG, ' Check for the TDS authority invoice ');

3522: the invoice is not existing. Base requires the org_id from the
3523: invoice_id we pass. Ensure that the invoice_id exists before calling approval
3524: */
3525:
3526: fnd_file.put_line(FND_FILE.LOG, ' Check for the TDS authority invoice ');
3527:
3528: /*Added by nprashar for bug # 6720018*/
3529: IF (FND_GLOBAL.CONC_REQUEST_ID is NULL) THEN
3530: lv_conc_flag := 'N';

Line 3544: fnd_file.put_line(FND_FILE.LOG, ' Org id ' || ln_org_id);

3540: --Bug 6819855. Added by Lakshmi Gopalsami
3541: ln_sob_id;
3542: CLOSE c_jai_chk_tds_inv;
3543:
3544: fnd_file.put_line(FND_FILE.LOG, ' Org id ' || ln_org_id);
3545:
3546:
3547: mo_global.set_policy_context('S', ln_org_id);
3548:

Line 3549: fnd_file.put_line(FND_FILE.LOG,' TDS authority invoice id '

3545:
3546:
3547: mo_global.set_policy_context('S', ln_org_id);
3548:
3549: fnd_file.put_line(FND_FILE.LOG,' TDS authority invoice id '
3550: || cur_rec.invoice_to_tds_authority_id);
3551:
3552: /* Invoice to TDS Authority */
3553: /* Bug 6819855. Added by Lakshmi Gopalsami

Line 3593: Fnd_File.put_line(Fnd_File.LOG, 'Invoice to TDS Authority ' ||

3589: p_org_id => ln_org_id,
3590: p_report_holds_count => ln_holds_count
3591: ) THEN
3592:
3593: Fnd_File.put_line(Fnd_File.LOG, 'Invoice to TDS Authority ' ||
3594: cur_rec.invoice_to_tds_authority_num ||
3595: '(' || cur_rec.invoice_to_tds_authority_id ||
3596: ') Was submitted for Approval.
3597: Holds count ' || ln_holds_count);

Line 3623: fnd_file.put_line(FND_FILE.LOG,' Supplier credit invoice id '

3619: CLOSE c_jai_chk_tds_inv;
3620:
3621: mo_global.set_policy_context('S', ln_org_id);
3622:
3623: fnd_file.put_line(FND_FILE.LOG,' Supplier credit invoice id '
3624: || cur_rec.invoice_to_vendor_id);
3625: /* Bug 6819855. Added by Lakshmi Gopalsami
3626: Commented the following code and added a call to function batch_approval
3627: ap_approval_pkg.approve

Line 3666: Fnd_File.put_line(Fnd_File.LOG, 'Invoice to Supplier for TDS' ||

3662: p_org_id => ln_org_id,
3663: p_report_holds_count => ln_holds_count1
3664: ) THEN
3665:
3666: Fnd_File.put_line(Fnd_File.LOG, 'Invoice to Supplier for TDS' ||
3667: cur_rec.invoice_to_vendor_num ||
3668: '(' || cur_rec.invoice_to_vendor_id ||
3669: ') Was submitted for Approval.
3670: Holds count ' || ln_holds_count1);

Line 4145: fnd_file.put_line(FND_FILE.LOG,' Error in maintain thhold grps '|| substr(SQLERRM,1,200));

4141: return;
4142:
4143: exception
4144: when others then
4145: fnd_file.put_line(FND_FILE.LOG,' Error in maintain thhold grps '|| substr(SQLERRM,1,200));
4146: p_process_flag := 'E';
4147: p_process_message := 'Error from jai_ap_tds_generation_pkg.maintain_thhold_grps :' || sqlerrm;
4148: end maintain_thhold_grps;
4149:

Line 4181: fnd_file.put_line(FND_FILE.LOG, ' Insert -> insert_tds_thhold_trxs ');

4177: )
4178: is
4179: begin
4180:
4181: fnd_file.put_line(FND_FILE.LOG, ' Insert -> insert_tds_thhold_trxs ');
4182:
4183: insert into jai_ap_tds_thhold_trxs
4184: (
4185: threshold_trx_id ,

Line 4246: fnd_file.put_line(FND_FILE.LOG, ' Done Insert -> insert_tds_thhold_trxs ');

4242: sysdate ,
4243: fnd_global.login_id
4244: );
4245:
4246: fnd_file.put_line(FND_FILE.LOG, ' Done Insert -> insert_tds_thhold_trxs ');
4247: end insert_tds_thhold_trxs;
4248:
4249: /* ******************************** create_tds_after_holds_rel ******************************************* */
4250:

Line 4352: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||

4348: dev_status => lv_dev_status,
4349: message => lv_message) ;
4350:
4351: IF not ln_req_status THEN
4352: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
4353: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
4354: FND_FILE.put_line(FND_FILE.log, 'Status of Completion of previous Concurrent Create TDS Invoice After Holds Release - Request Id ' || p_request_id || ' ' || SQLERRM );
4355: END IF ;
4356:

Line 4354: FND_FILE.put_line(FND_FILE.log, 'Status of Completion of previous Concurrent Create TDS Invoice After Holds Release - Request Id ' || p_request_id || ' ' || SQLERRM );

4350:
4351: IF not ln_req_status THEN
4352: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
4353: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
4354: FND_FILE.put_line(FND_FILE.log, 'Status of Completion of previous Concurrent Create TDS Invoice After Holds Release - Request Id ' || p_request_id || ' ' || SQLERRM );
4355: END IF ;
4356:
4357: END IF ;
4358:

Line 4361: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||

4357: END IF ;
4358:
4359: EXCEPTION
4360: WHEN OTHERS THEN
4361: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
4362: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
4363: FND_FILE.put_line(FND_FILE.log, 'Status of Completion of previous Concurrent Create TDS Invoice After Holds Release - Request Id ' || p_request_id || ' ' || SQLERRM );
4364: END;
4365:

Line 4363: FND_FILE.put_line(FND_FILE.log, 'Status of Completion of previous Concurrent Create TDS Invoice After Holds Release - Request Id ' || p_request_id || ' ' || SQLERRM );

4359: EXCEPTION
4360: WHEN OTHERS THEN
4361: FND_FILE.put_line(FND_FILE.log, 'Phase : ' || lv_phase || 'Status : ' || lv_status || 'Dev Phase : ' || lv_dev_phase ||
4362: ' Dev Status : ' || lv_dev_status || ' Message : ' || lv_message );
4363: FND_FILE.put_line(FND_FILE.log, 'Status of Completion of previous Concurrent Create TDS Invoice After Holds Release - Request Id ' || p_request_id || ' ' || SQLERRM );
4364: END;
4365:
4366:
4367: lv_invoice_validation_status :=

Line 4381: fnd_file.put_line(FND_FILE.LOG, ' value of validate'||lv_is_invoice_validated);

4377: lv_is_invoice_validated := 'Y';
4378: end if;
4379:
4380: if lv_debug='Y' then
4381: fnd_file.put_line(FND_FILE.LOG, ' value of validate'||lv_is_invoice_validated);
4382: end if ;
4383:
4384: if lv_is_invoice_validated = 'Y' then
4385:

Line 4411: fnd_file.put_line(FND_FILE.LOG, ' Error in the concurrent program '|| lv_process_message);

4407: );
4408:
4409: --Moved this from below to here by Sanjikum for Bug#5131075(4722011)
4410: if nvl(lv_process_flag, 'N') = 'E' then
4411: fnd_file.put_line(FND_FILE.LOG, ' Error in the concurrent program '|| lv_process_message);
4412: goto exit_from_procedure;
4413: END IF;
4414:
4415: --Start Addition by Sanjikum for Bug#5131075(4722011)

Line 4541: fnd_file.put_line(FND_FILE.LOG,' Not generating the TDS invoice

4537:
4538: --End Addition by Sanjikum for Bug#5131075(4722011)
4539:
4540: Else
4541: fnd_file.put_line(FND_FILE.LOG,' Not generating the TDS invoice
4542: as the parent invoice is not yet validated');
4543: retcode := 1;
4544: End if; /* lv_is_invoice_validated = 'Y' */
4545:

Line 4957: fnd_file.put_line(FND_FILE.LOG,' inside rollback ');

4953: * Get the taxable basis for threshold rollback.
4954: * Calculate the taxable amount.
4955: */
4956:
4957: fnd_file.put_line(FND_FILE.LOG,' inside rollback ');
4958: OPEN get_tds_not_deducted ( p_threshold_grp_id );
4959: FETCH get_tds_not_deducted INTO ln_tds_not_deducted;
4960: CLOSE get_tds_not_deducted;
4961: -- TDS not deducted for Prepayment application

Line 4979: fnd_file.put_line(FND_FILE.LOG,'SI not deducted ' || ln_tds_not_deducted);

4975: CLOSE get_thhold_transn;*/
4976:
4977: /*End commenting by mmurtuza for bug 13561970*/
4978:
4979: fnd_file.put_line(FND_FILE.LOG,'SI not deducted ' || ln_tds_not_deducted);
4980: fnd_file.put_line(FND_FILE.LOG,'PPA/U not deducted ' || ln_pp_tds_not_deducted);
4981: fnd_file.put_line(FND_FILE.LOG,'Transitioned taxable amount ' || ln_thhold_trxn_trsn);
4982: ln_taxable_amount := NVL(ln_tds_not_deducted,0) -
4983: NVL(ln_pp_tds_not_deducted,0);

Line 4980: fnd_file.put_line(FND_FILE.LOG,'PPA/U not deducted ' || ln_pp_tds_not_deducted);

4976:
4977: /*End commenting by mmurtuza for bug 13561970*/
4978:
4979: fnd_file.put_line(FND_FILE.LOG,'SI not deducted ' || ln_tds_not_deducted);
4980: fnd_file.put_line(FND_FILE.LOG,'PPA/U not deducted ' || ln_pp_tds_not_deducted);
4981: fnd_file.put_line(FND_FILE.LOG,'Transitioned taxable amount ' || ln_thhold_trxn_trsn);
4982: ln_taxable_amount := NVL(ln_tds_not_deducted,0) -
4983: NVL(ln_pp_tds_not_deducted,0);
4984: /* -NVL(ln_thhold_trxn_trsn,0);*/ /*Bug 13561970*/

Line 4981: fnd_file.put_line(FND_FILE.LOG,'Transitioned taxable amount ' || ln_thhold_trxn_trsn);

4977: /*End commenting by mmurtuza for bug 13561970*/
4978:
4979: fnd_file.put_line(FND_FILE.LOG,'SI not deducted ' || ln_tds_not_deducted);
4980: fnd_file.put_line(FND_FILE.LOG,'PPA/U not deducted ' || ln_pp_tds_not_deducted);
4981: fnd_file.put_line(FND_FILE.LOG,'Transitioned taxable amount ' || ln_thhold_trxn_trsn);
4982: ln_taxable_amount := NVL(ln_tds_not_deducted,0) -
4983: NVL(ln_pp_tds_not_deducted,0);
4984: /* -NVL(ln_thhold_trxn_trsn,0);*/ /*Bug 13561970*/
4985: fnd_file.put_line(FND_FILE.LOG,'Remaining taxable amount' || ln_taxable_amount);

Line 4985: fnd_file.put_line(FND_FILE.LOG,'Remaining taxable amount' || ln_taxable_amount);

4981: fnd_file.put_line(FND_FILE.LOG,'Transitioned taxable amount ' || ln_thhold_trxn_trsn);
4982: ln_taxable_amount := NVL(ln_tds_not_deducted,0) -
4983: NVL(ln_pp_tds_not_deducted,0);
4984: /* -NVL(ln_thhold_trxn_trsn,0);*/ /*Bug 13561970*/
4985: fnd_file.put_line(FND_FILE.LOG,'Remaining taxable amount' || ln_taxable_amount);
4986:
4987:
4988: END IF;
4989: