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_R12_CAT_UPG_VAL_PVT dependencies on PO_LOOKUP_CODES

Line 1535: -- Performs the id-to-name conversion for PO_LOOKUP_CODES.

1531: -- None
1532: --Locks:
1533: -- None.
1534: --Function:
1535: -- Performs the id-to-name conversion for PO_LOOKUP_CODES.
1536: -- Used when logging validation errors.
1537: --Parameters:
1538: --IN:
1539: --p_po_lookup_code

Line 1571: FROM PO_LOOKUP_CODES

1567: l_progress := '020';
1568: BEGIN
1569: SELECT displayed_field
1570: INTO x_lookup_meaning
1571: FROM PO_LOOKUP_CODES
1572: WHERE lookup_code = p_po_lookup_code
1573: AND lookup_type = p_po_lookup_type;
1574: -- The PO_LOOKUP_CODES is a view on top of FND_LOOKUP_VALUES with a userenv('LANG') join
1575: --AND language = userenv('LANG');

Line 1574: -- The PO_LOOKUP_CODES is a view on top of FND_LOOKUP_VALUES with a userenv('LANG') join

1570: INTO x_lookup_meaning
1571: FROM PO_LOOKUP_CODES
1572: WHERE lookup_code = p_po_lookup_code
1573: AND lookup_type = p_po_lookup_type;
1574: -- The PO_LOOKUP_CODES is a view on top of FND_LOOKUP_VALUES with a userenv('LANG') join
1575: --AND language = userenv('LANG');
1576: EXCEPTION
1577: WHEN OTHERS THEN
1578: l_progress := '030';

Line 1579: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Exception while getting name from PO_LOOKUP_CODES: '||SQLERRM); END IF;

1575: --AND language = userenv('LANG');
1576: EXCEPTION
1577: WHEN OTHERS THEN
1578: l_progress := '030';
1579: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Exception while getting name from PO_LOOKUP_CODES: '||SQLERRM); END IF;
1580:
1581: x_lookup_meaning := p_po_lookup_code;
1582: END;
1583: -- ECO bug 5584556: End

Line 1607: -- Validates fob_lookup_code against PO_LOOKUP_CODES.

1603: -- b) FND_MSG_PUB on unhandled exceptions.
1604: --Locks:
1605: -- None.
1606: --Function:
1607: -- Validates fob_lookup_code against PO_LOOKUP_CODES.
1608: --Parameters:
1609: --IN:
1610: --p_key
1611: -- Key used to access records in PO_SESSION_GT table.

Line 1639: l_lookup_meaning PO_LOOKUP_CODES.displayed_field%TYPE;

1635: l_index NUMBER;
1636: i NUMBER;
1637: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1638:
1639: l_lookup_meaning PO_LOOKUP_CODES.displayed_field%TYPE;
1640: BEGIN
1641: l_progress := '010';
1642: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1643: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Validating a defaulted field -- FOB_LOOKUP_CODE'); END IF;

Line 1654: -- SQL What: Bulk validate fob_lookup_code not null and against PO_LOOKUP_CODES.

1650: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.has_errors(1)='||p_headers_rec.has_errors(1)); END IF;
1651: END IF;
1652:
1653: l_progress := '020';
1654: -- SQL What: Bulk validate fob_lookup_code not null and against PO_LOOKUP_CODES.
1655: -- Get the errored rows into GT table.
1656: -- SQL Why : It will be used to mark the record in plsql table as error.
1657: -- SQL Join: bill_to_location_id
1658: FORALL i IN 1 .. p_headers_rec.fob.COUNT

Line 1672: FROM PO_LOOKUP_CODES PLC

1668: WHERE --p_headers_rec.has_errors(i) = 'N'
1669: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1670: AND p_headers_rec.fob(i) IS NOT NULL
1671: AND NOT EXISTS(SELECT 1
1672: FROM PO_LOOKUP_CODES PLC
1673: WHERE p_headers_rec.fob(i) = PLC.lookup_code
1674: AND PLC.lookup_type = 'FOB'
1675: AND SYSDATE < NVL(PLC.inactive_date, SYSDATE + 1));
1676:

Line 1866: -- Validates freight_terms_lookup_code against PO_LOOKUP_CODES.

1862: -- b) FND_MSG_PUB on unhandled exceptions.
1863: --Locks:
1864: -- None.
1865: --Function:
1866: -- Validates freight_terms_lookup_code against PO_LOOKUP_CODES.
1867: --Parameters:
1868: --IN:
1869: --p_key
1870: -- Key used to access records in PO_SESSION_GT table.

Line 1898: l_lookup_meaning PO_LOOKUP_CODES.displayed_field%TYPE;

1894: l_index NUMBER;
1895: i NUMBER;
1896: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1897:
1898: l_lookup_meaning PO_LOOKUP_CODES.displayed_field%TYPE;
1899: BEGIN
1900: l_progress := '010';
1901: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1902: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Validating a defaulted field -- SHIP_VIA_LOOKUP_CODE (freight_carrier)'); END IF;

Line 1913: -- SQL What: Bulk validate freight_terms_lookup_code against PO_LOOKUP_CODES.

1909: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_headers_rec.has_errors(1)='||p_headers_rec.has_errors(1)); END IF;
1910: END IF;
1911:
1912: l_progress := '020';
1913: -- SQL What: Bulk validate freight_terms_lookup_code against PO_LOOKUP_CODES.
1914: -- Get the errored rows into GT table.
1915: -- SQL Why : It will be used to mark the record in plsql table as error.
1916: -- SQL Join: ship_via_lookup_code
1917: FORALL i IN 1 .. p_headers_rec.freight_terms.COUNT

Line 1932: FROM PO_LOOKUP_CODES PLC

1928: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
1929: AND p_headers_rec.freight_terms(i) IS NOT NULL
1930: AND NOT EXISTS(
1931: SELECT 1
1932: FROM PO_LOOKUP_CODES PLC
1933: WHERE p_headers_rec.freight_terms(i) = PLC.lookup_code
1934: AND PLC.lookup_type = 'FREIGHT TERMS'
1935: AND SYSDATE < NVL(PLC.inactive_date, SYSDATE + 1));
1936:

Line 2203: -- Validates shipping_control against PO_LOOKUP_CODES.

2199: -- b) FND_MSG_PUB on unhandled exceptions.
2200: --Locks:
2201: -- None.
2202: --Function:
2203: -- Validates shipping_control against PO_LOOKUP_CODES.
2204: --Parameters:
2205: --IN:
2206: --p_key
2207: -- Key used to access records in PO_SESSION_GT table.

Line 2235: l_lookup_meaning PO_LOOKUP_CODES.displayed_field%TYPE;

2231: l_index NUMBER;
2232: i NUMBER;
2233: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2234:
2235: l_lookup_meaning PO_LOOKUP_CODES.displayed_field%TYPE;
2236: BEGIN
2237: l_progress := '010';
2238: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2239: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Validating a defaulted field -- SHIP_VIA_LOOKUP_CODE (freight_carrier)'); END IF;

Line 2269: FROM PO_LOOKUP_CODES PLC

2265: p_headers_rec.action(i) = PO_R12_CAT_UPG_PVT.g_action_header_create --Bug#5018883
2266: AND p_headers_rec.shipping_control(i) IS NOT NULL
2267: AND NOT EXISTS(
2268: SELECT 1
2269: FROM PO_LOOKUP_CODES PLC
2270: WHERE p_headers_rec.shipping_control(i) = PLC.lookup_code
2271: AND PLC.lookup_type = 'SHIPPING CONTROL'
2272: AND SYSDATE < NVL(PLC.inactive_date, SYSDATE + 1));
2273: