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.PO_THIRD_PARTY_STOCK_GRP dependencies on PO_LOG

Line 40: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('PO_THIRD_PARTY_STOCK_GRP');

36: -- GLOBAL VARIABLES
37: --=============================================
38: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
39: --
40: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('PO_THIRD_PARTY_STOCK_GRP');
41:
42: D_get_consigned_flag CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag');
43: --
44:

Line 42: D_get_consigned_flag CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag');

38: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
39: --
40: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('PO_THIRD_PARTY_STOCK_GRP');
41:
42: D_get_consigned_flag CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_consigned_flag');
43: --
44:
45: --==========================================================================
46: -- FUNCTION NAME: Validate_Local_Asl

Line 1626: IF (PO_LOG.d_proc) THEN

1622:
1623: e_invalid_asset_flag EXCEPTION;
1624: e_invalid_consigned_flag EXCEPTION;
1625: BEGIN
1626: IF (PO_LOG.d_proc) THEN
1627: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
1628: PO_LOG.proc_begin(d_mod,'p_item_id',p_item_id);
1629: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1630: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);

Line 1627: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);

1623: e_invalid_asset_flag EXCEPTION;
1624: e_invalid_consigned_flag EXCEPTION;
1625: BEGIN
1626: IF (PO_LOG.d_proc) THEN
1627: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
1628: PO_LOG.proc_begin(d_mod,'p_item_id',p_item_id);
1629: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1630: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1631: END IF;

Line 1628: PO_LOG.proc_begin(d_mod,'p_item_id',p_item_id);

1624: e_invalid_consigned_flag EXCEPTION;
1625: BEGIN
1626: IF (PO_LOG.d_proc) THEN
1627: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
1628: PO_LOG.proc_begin(d_mod,'p_item_id',p_item_id);
1629: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1630: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1631: END IF;
1632:

Line 1629: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);

1625: BEGIN
1626: IF (PO_LOG.d_proc) THEN
1627: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
1628: PO_LOG.proc_begin(d_mod,'p_item_id',p_item_id);
1629: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1630: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1631: END IF;
1632:
1633: -- When either item ID or org ID is null, don't call get_item_inv_asset_flag

Line 1630: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);

1626: IF (PO_LOG.d_proc) THEN
1627: PO_LOG.proc_begin(d_mod,'p_org_id',p_org_id);
1628: PO_LOG.proc_begin(d_mod,'p_item_id',p_item_id);
1629: PO_LOG.proc_begin(d_mod,'p_supplier_id',p_supplier_id);
1630: PO_LOG.proc_begin(d_mod,'p_site_id',p_site_id);
1631: END IF;
1632:
1633: -- When either item ID or org ID is null, don't call get_item_inv_asset_flag
1634: -- because it will error out. Instead, just set consigned flag to 'N' and

Line 1640: IF (PO_LOG.d_proc) THEN

1636: IF (p_item_id IS NULL OR (p_org_id IS NULL AND p_inv_org_id IS NULL)) -- Bug 5976612 Added the 'p_inv_org_id' check
1637: THEN
1638: l_consigned_flag := 'N';
1639:
1640: IF (PO_LOG.d_proc) THEN
1641: PO_LOG.proc_return(d_mod, l_consigned_flag);
1642: END IF;
1643:
1644: RETURN l_consigned_flag;

Line 1641: PO_LOG.proc_return(d_mod, l_consigned_flag);

1637: THEN
1638: l_consigned_flag := 'N';
1639:
1640: IF (PO_LOG.d_proc) THEN
1641: PO_LOG.proc_return(d_mod, l_consigned_flag);
1642: END IF;
1643:
1644: RETURN l_consigned_flag;
1645: END IF;

Line 1685: IF PO_LOG.d_stmt THEN

1681: );
1682:
1683: d_position := 10;
1684:
1685: IF PO_LOG.d_stmt THEN
1686: PO_LOG.stmt(d_mod,d_position,'asset flag is: ' || l_asset_flag || ' and l_return_status is: ' || l_return_status);
1687: END IF;
1688:
1689: d_position := 20;

Line 1686: PO_LOG.stmt(d_mod,d_position,'asset flag is: ' || l_asset_flag || ' and l_return_status is: ' || l_return_status);

1682:
1683: d_position := 10;
1684:
1685: IF PO_LOG.d_stmt THEN
1686: PO_LOG.stmt(d_mod,d_position,'asset flag is: ' || l_asset_flag || ' and l_return_status is: ' || l_return_status);
1687: END IF;
1688:
1689: d_position := 20;
1690:

Line 1704: IF (PO_LOG.d_proc) THEN

1700: IF (NVL(l_asset_flag, 'N') = 'N')
1701: THEN
1702: l_consigned_flag := 'N';
1703:
1704: IF (PO_LOG.d_proc) THEN
1705: PO_LOG.proc_return(d_mod, l_consigned_flag);
1706: END IF;
1707:
1708: RETURN l_consigned_flag;

Line 1705: PO_LOG.proc_return(d_mod, l_consigned_flag);

1701: THEN
1702: l_consigned_flag := 'N';
1703:
1704: IF (PO_LOG.d_proc) THEN
1705: PO_LOG.proc_return(d_mod, l_consigned_flag);
1706: END IF;
1707:
1708: RETURN l_consigned_flag;
1709: END IF;

Line 1713: IF PO_LOG.d_stmt THEN

1709: END IF;
1710:
1711: d_position := 40;
1712:
1713: IF PO_LOG.d_stmt THEN
1714: PO_LOG.stmt(d_mod,d_position,'consigned flag before call to get_asl_attributes is: ' || l_consigned_flag);
1715: END IF;
1716:
1717: PO_THIRD_PARTY_STOCK_GRP.get_asl_attributes(

Line 1714: PO_LOG.stmt(d_mod,d_position,'consigned flag before call to get_asl_attributes is: ' || l_consigned_flag);

1710:
1711: d_position := 40;
1712:
1713: IF PO_LOG.d_stmt THEN
1714: PO_LOG.stmt(d_mod,d_position,'consigned flag before call to get_asl_attributes is: ' || l_consigned_flag);
1715: END IF;
1716:
1717: PO_THIRD_PARTY_STOCK_GRP.get_asl_attributes(
1718: p_api_version => 1.0,

Line 1735: IF PO_LOG.d_stmt THEN

1731: );
1732:
1733: d_position := 50;
1734:
1735: IF PO_LOG.d_stmt THEN
1736: PO_LOG.stmt(d_mod,d_position,'consigned flag after call to get_asl_attributes is: ' || l_consigned_flag || ' and l_return_status is: ' || l_return_status);
1737: END IF;
1738:
1739: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 1736: PO_LOG.stmt(d_mod,d_position,'consigned flag after call to get_asl_attributes is: ' || l_consigned_flag || ' and l_return_status is: ' || l_return_status);

1732:
1733: d_position := 50;
1734:
1735: IF PO_LOG.d_stmt THEN
1736: PO_LOG.stmt(d_mod,d_position,'consigned flag after call to get_asl_attributes is: ' || l_consigned_flag || ' and l_return_status is: ' || l_return_status);
1737: END IF;
1738:
1739: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1740: THEN

Line 1746: IF (PO_LOG.d_proc) THEN

1742: END IF;
1743:
1744: l_consigned_flag := NVL(l_consigned_flag, 'N');
1745:
1746: IF (PO_LOG.d_proc) THEN
1747: PO_LOG.proc_return(d_mod, l_consigned_flag);
1748: END IF;
1749:
1750: RETURN l_consigned_flag;

Line 1747: PO_LOG.proc_return(d_mod, l_consigned_flag);

1743:
1744: l_consigned_flag := NVL(l_consigned_flag, 'N');
1745:
1746: IF (PO_LOG.d_proc) THEN
1747: PO_LOG.proc_return(d_mod, l_consigned_flag);
1748: END IF;
1749:
1750: RETURN l_consigned_flag;
1751: EXCEPTION

Line 1753: IF (PO_LOG.d_exc) THEN

1749:
1750: RETURN l_consigned_flag;
1751: EXCEPTION
1752: WHEN e_invalid_asset_flag THEN
1753: IF (PO_LOG.d_exc) THEN
1754: PO_LOG.exc(d_mod, d_position, 'An error occured in get_consigned_flag: e_invalid_asset_flag');
1755: END IF;
1756:
1757: RAISE;

Line 1754: PO_LOG.exc(d_mod, d_position, 'An error occured in get_consigned_flag: e_invalid_asset_flag');

1750: RETURN l_consigned_flag;
1751: EXCEPTION
1752: WHEN e_invalid_asset_flag THEN
1753: IF (PO_LOG.d_exc) THEN
1754: PO_LOG.exc(d_mod, d_position, 'An error occured in get_consigned_flag: e_invalid_asset_flag');
1755: END IF;
1756:
1757: RAISE;
1758: WHEN e_invalid_consigned_flag THEN

Line 1759: IF (PO_LOG.d_exc) THEN

1755: END IF;
1756:
1757: RAISE;
1758: WHEN e_invalid_consigned_flag THEN
1759: IF (PO_LOG.d_exc) THEN
1760: PO_LOG.exc(d_mod, d_position, 'An error occured in get_consigned_flag: e_invalid_consigned_flag');
1761: END IF;
1762:
1763: RAISE;

Line 1760: PO_LOG.exc(d_mod, d_position, 'An error occured in get_consigned_flag: e_invalid_consigned_flag');

1756:
1757: RAISE;
1758: WHEN e_invalid_consigned_flag THEN
1759: IF (PO_LOG.d_exc) THEN
1760: PO_LOG.exc(d_mod, d_position, 'An error occured in get_consigned_flag: e_invalid_consigned_flag');
1761: END IF;
1762:
1763: RAISE;
1764: WHEN OTHERS THEN

Line 1765: IF (PO_LOG.d_exc) THEN

1761: END IF;
1762:
1763: RAISE;
1764: WHEN OTHERS THEN
1765: IF (PO_LOG.d_exc) THEN
1766: PO_LOG.exc(d_mod, d_position, 'An error occured in get_consigned_flag');
1767: END IF;
1768:
1769: RAISE;

Line 1766: PO_LOG.exc(d_mod, d_position, 'An error occured in get_consigned_flag');

1762:
1763: RAISE;
1764: WHEN OTHERS THEN
1765: IF (PO_LOG.d_exc) THEN
1766: PO_LOG.exc(d_mod, d_position, 'An error occured in get_consigned_flag');
1767: END IF;
1768:
1769: RAISE;
1770: END get_consigned_flag;

Line 1814: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base( D_PACKAGE_BASE, l_module_name);

1810: l_enable_vmi_flag po_asl_attributes.enable_vmi_flag%TYPE := NULL;
1811: l_last_billing_date date := NULL;
1812: l_consigned_billing_cycle number := NULL;
1813: l_module_name CONSTANT VARCHAR2(100) := 'IS_ASL_CONSIGNED_FROM_SUPPLIER';
1814: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base( D_PACKAGE_BASE, l_module_name);
1815: d_progress NUMBER;
1816: BEGIN
1817: IF (PO_LOG.d_proc) THEN
1818: PO_LOG.proc_begin(d_module_base);

Line 1817: IF (PO_LOG.d_proc) THEN

1813: l_module_name CONSTANT VARCHAR2(100) := 'IS_ASL_CONSIGNED_FROM_SUPPLIER';
1814: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base( D_PACKAGE_BASE, l_module_name);
1815: d_progress NUMBER;
1816: BEGIN
1817: IF (PO_LOG.d_proc) THEN
1818: PO_LOG.proc_begin(d_module_base);
1819: PO_LOG.proc_begin(d_module_base, 'p_item_id', p_item_id);
1820: PO_LOG.proc_begin(d_module_base, 'p_vendor_id', p_vendor_id);
1821: PO_LOG.proc_begin(d_module_base, 'p_vendor_site_id', p_vendor_site_id);

Line 1818: PO_LOG.proc_begin(d_module_base);

1814: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base( D_PACKAGE_BASE, l_module_name);
1815: d_progress NUMBER;
1816: BEGIN
1817: IF (PO_LOG.d_proc) THEN
1818: PO_LOG.proc_begin(d_module_base);
1819: PO_LOG.proc_begin(d_module_base, 'p_item_id', p_item_id);
1820: PO_LOG.proc_begin(d_module_base, 'p_vendor_id', p_vendor_id);
1821: PO_LOG.proc_begin(d_module_base, 'p_vendor_site_id', p_vendor_site_id);
1822: IF(p_use_ship_to_org_ids <> null)THEN

Line 1819: PO_LOG.proc_begin(d_module_base, 'p_item_id', p_item_id);

1815: d_progress NUMBER;
1816: BEGIN
1817: IF (PO_LOG.d_proc) THEN
1818: PO_LOG.proc_begin(d_module_base);
1819: PO_LOG.proc_begin(d_module_base, 'p_item_id', p_item_id);
1820: PO_LOG.proc_begin(d_module_base, 'p_vendor_id', p_vendor_id);
1821: PO_LOG.proc_begin(d_module_base, 'p_vendor_site_id', p_vendor_site_id);
1822: IF(p_use_ship_to_org_ids <> null)THEN
1823: FOR i in 1..p_use_ship_to_org_ids.count LOOP

Line 1820: PO_LOG.proc_begin(d_module_base, 'p_vendor_id', p_vendor_id);

1816: BEGIN
1817: IF (PO_LOG.d_proc) THEN
1818: PO_LOG.proc_begin(d_module_base);
1819: PO_LOG.proc_begin(d_module_base, 'p_item_id', p_item_id);
1820: PO_LOG.proc_begin(d_module_base, 'p_vendor_id', p_vendor_id);
1821: PO_LOG.proc_begin(d_module_base, 'p_vendor_site_id', p_vendor_site_id);
1822: IF(p_use_ship_to_org_ids <> null)THEN
1823: FOR i in 1..p_use_ship_to_org_ids.count LOOP
1824: PO_LOG.proc_begin(d_module_base, 'p_use_ship_to_org_ids('||i||')', p_use_ship_to_org_ids(i));

Line 1821: PO_LOG.proc_begin(d_module_base, 'p_vendor_site_id', p_vendor_site_id);

1817: IF (PO_LOG.d_proc) THEN
1818: PO_LOG.proc_begin(d_module_base);
1819: PO_LOG.proc_begin(d_module_base, 'p_item_id', p_item_id);
1820: PO_LOG.proc_begin(d_module_base, 'p_vendor_id', p_vendor_id);
1821: PO_LOG.proc_begin(d_module_base, 'p_vendor_site_id', p_vendor_site_id);
1822: IF(p_use_ship_to_org_ids <> null)THEN
1823: FOR i in 1..p_use_ship_to_org_ids.count LOOP
1824: PO_LOG.proc_begin(d_module_base, 'p_use_ship_to_org_ids('||i||')', p_use_ship_to_org_ids(i));
1825: END LOOP;

Line 1824: PO_LOG.proc_begin(d_module_base, 'p_use_ship_to_org_ids('||i||')', p_use_ship_to_org_ids(i));

1820: PO_LOG.proc_begin(d_module_base, 'p_vendor_id', p_vendor_id);
1821: PO_LOG.proc_begin(d_module_base, 'p_vendor_site_id', p_vendor_site_id);
1822: IF(p_use_ship_to_org_ids <> null)THEN
1823: FOR i in 1..p_use_ship_to_org_ids.count LOOP
1824: PO_LOG.proc_begin(d_module_base, 'p_use_ship_to_org_ids('||i||')', p_use_ship_to_org_ids(i));
1825: END LOOP;
1826: END IF;
1827: END IF;
1828: d_progress :=10;

Line 1841: IF PO_LOG.d_stmt THEN

1837: x_msg_data => l_msg_data,
1838: p_organization_id => p_use_ship_to_org_ids(i),
1839: p_inventory_item_id => p_item_id,
1840: x_inventory_asset_flag => l_item_inv_asset_flag);
1841: IF PO_LOG.d_stmt THEN
1842: PO_LOG.stmt(d_module_base,d_progress,'l_item_inv_asset_flag('||i||')= '||l_item_inv_asset_flag);
1843: PO_LOG.stmt(d_module_base,d_progress,'x_return_status('||i||')= '||l_return_status);
1844: END IF;
1845: END IF;

Line 1842: PO_LOG.stmt(d_module_base,d_progress,'l_item_inv_asset_flag('||i||')= '||l_item_inv_asset_flag);

1838: p_organization_id => p_use_ship_to_org_ids(i),
1839: p_inventory_item_id => p_item_id,
1840: x_inventory_asset_flag => l_item_inv_asset_flag);
1841: IF PO_LOG.d_stmt THEN
1842: PO_LOG.stmt(d_module_base,d_progress,'l_item_inv_asset_flag('||i||')= '||l_item_inv_asset_flag);
1843: PO_LOG.stmt(d_module_base,d_progress,'x_return_status('||i||')= '||l_return_status);
1844: END IF;
1845: END IF;
1846: -- if the item is not an expense item

Line 1843: PO_LOG.stmt(d_module_base,d_progress,'x_return_status('||i||')= '||l_return_status);

1839: p_inventory_item_id => p_item_id,
1840: x_inventory_asset_flag => l_item_inv_asset_flag);
1841: IF PO_LOG.d_stmt THEN
1842: PO_LOG.stmt(d_module_base,d_progress,'l_item_inv_asset_flag('||i||')= '||l_item_inv_asset_flag);
1843: PO_LOG.stmt(d_module_base,d_progress,'x_return_status('||i||')= '||l_return_status);
1844: END IF;
1845: END IF;
1846: -- if the item is not an expense item
1847: d_progress :=20;

Line 1862: IF PO_LOG.d_stmt THEN

1858: x_consigned_from_supplier_flag => x_consigned_from_supplier_flag,
1859: x_enable_vmi_flag => l_enable_vmi_flag,
1860: x_last_billing_date => l_last_billing_date,
1861: x_consigned_billing_cycle => l_consigned_billing_cycle);
1862: IF PO_LOG.d_stmt THEN
1863: PO_LOG.stmt(d_module_base,d_progress,'x_consigned_from_supplier_flag=('||i||')= '||x_consigned_from_supplier_flag);
1864: END IF;
1865:
1866: IF(x_consigned_from_supplier_flag='Y')THEN

Line 1863: PO_LOG.stmt(d_module_base,d_progress,'x_consigned_from_supplier_flag=('||i||')= '||x_consigned_from_supplier_flag);

1859: x_enable_vmi_flag => l_enable_vmi_flag,
1860: x_last_billing_date => l_last_billing_date,
1861: x_consigned_billing_cycle => l_consigned_billing_cycle);
1862: IF PO_LOG.d_stmt THEN
1863: PO_LOG.stmt(d_module_base,d_progress,'x_consigned_from_supplier_flag=('||i||')= '||x_consigned_from_supplier_flag);
1864: END IF;
1865:
1866: IF(x_consigned_from_supplier_flag='Y')THEN
1867: RETURN;

Line 1873: IF (PO_LOG.d_proc) THEN

1869:
1870: END IF;
1871: END LOOP;
1872:
1873: IF (PO_LOG.d_proc) THEN
1874: PO_LOG.proc_end(d_module_base);
1875: END IF;
1876: EXCEPTION
1877: WHEN OTHERS THEN

Line 1874: PO_LOG.proc_end(d_module_base);

1870: END IF;
1871: END LOOP;
1872:
1873: IF (PO_LOG.d_proc) THEN
1874: PO_LOG.proc_end(d_module_base);
1875: END IF;
1876: EXCEPTION
1877: WHEN OTHERS THEN
1878: IF (PO_LOG.d_exc) THEN

Line 1878: IF (PO_LOG.d_exc) THEN

1874: PO_LOG.proc_end(d_module_base);
1875: END IF;
1876: EXCEPTION
1877: WHEN OTHERS THEN
1878: IF (PO_LOG.d_exc) THEN
1879: PO_LOG.exc(d_module_base, d_progress, SQLCODE || SQLERRM);
1880: END IF;
1881: RAISE;
1882: END;

Line 1879: PO_LOG.exc(d_module_base, d_progress, SQLCODE || SQLERRM);

1875: END IF;
1876: EXCEPTION
1877: WHEN OTHERS THEN
1878: IF (PO_LOG.d_exc) THEN
1879: PO_LOG.exc(d_module_base, d_progress, SQLCODE || SQLERRM);
1880: END IF;
1881: RAISE;
1882: END;
1883: --