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_VALIDATIONS dependencies on PO_VAL_HEADERS

Line 1775: PO_VAL_HEADERS.warn_supplier_on_hold(

1771: -- Header Validations
1772: ---------------------------------------------------------------
1773:
1774: WHEN c_warn_supplier_on_hold THEN
1775: PO_VAL_HEADERS.warn_supplier_on_hold(
1776: p_header_id_tbl => p_headers.po_header_id
1777: , p_vendor_id_tbl => p_headers.vendor_id
1778: , x_result_set_id => l_result_set_id
1779: , x_result_type => l_result_type

Line 1783: PO_VAL_HEADERS.rate_gt_zero(

1779: , x_result_type => l_result_type
1780: );
1781:
1782: WHEN c_rate_gt_zero THEN
1783: PO_VAL_HEADERS.rate_gt_zero(
1784: p_header_id_tbl => p_headers.po_header_id
1785: , p_rate_tbl => p_headers.rate
1786: , x_results => x_results
1787: , x_result_type => l_result_type

Line 1791: PO_VAL_HEADERS.fax_email_address_valid(

1787: , x_result_type => l_result_type
1788: );
1789:
1790: WHEN c_fax_email_address_valid THEN
1791: PO_VAL_HEADERS.fax_email_address_valid(
1792: p_header_id_tbl => p_headers.po_header_id
1793: , p_supplier_notif_method_tbl => p_headers.supplier_notif_method
1794: , p_fax_tbl => p_headers.fax
1795: , p_email_address_tbl => p_headers.email_address

Line 1801: PO_VAL_HEADERS.rate_combination_valid(

1797: , x_result_type => l_result_type
1798: );
1799:
1800: WHEN c_rate_combination_valid THEN
1801: PO_VAL_HEADERS.rate_combination_valid(
1802: p_header_id_tbl => p_headers.po_header_id
1803: , p_org_id_tbl => p_headers.org_id
1804: , p_currency_code_tbl => p_headers.currency_code
1805: , p_rate_type_tbl => p_headers.rate_type

Line 1813: PO_VAL_HEADERS.doc_num_chars_valid(

1809: , x_result_type => l_result_type
1810: );
1811:
1812: WHEN c_doc_num_chars_valid THEN
1813: PO_VAL_HEADERS.doc_num_chars_valid(
1814: p_header_id_tbl => p_headers.po_header_id
1815: , p_org_id_tbl => p_headers.org_id
1816: , p_segment1_tbl => p_headers.segment1
1817: , x_results => x_results

Line 1822: PO_VAL_HEADERS.doc_num_unique(

1818: , x_result_type => l_result_type
1819: );
1820:
1821: WHEN c_doc_num_unique THEN
1822: PO_VAL_HEADERS.doc_num_unique(
1823: p_header_id_tbl => p_headers.po_header_id
1824: , p_org_id_tbl => p_headers.org_id
1825: , p_segment1_tbl => p_headers.segment1
1826: , p_type_lookup_code_tbl => p_headers.type_lookup_code

Line 1832: PO_VAL_HEADERS.price_update_tol_ge_zero(

1828: , x_result_type => l_result_type
1829: );
1830:
1831: WHEN c_price_update_tol_ge_zero THEN
1832: PO_VAL_HEADERS.price_update_tol_ge_zero(
1833: p_header_id_tbl => p_headers.po_header_id
1834: , p_price_update_tol_tbl => p_headers.price_update_tolerance
1835: , x_results => x_results
1836: , x_result_type => l_result_type

Line 1840: PO_VAL_HEADERS.amount_limit_ge_zero(

1836: , x_result_type => l_result_type
1837: );
1838:
1839: WHEN c_amount_limit_ge_zero THEN
1840: PO_VAL_HEADERS.amount_limit_ge_zero(
1841: p_header_id_tbl => p_headers.po_header_id
1842: , p_amount_limit_tbl => p_headers.amount_limit
1843: , x_results => x_results
1844: , x_result_type => l_result_type

Line 1848: PO_VAL_HEADERS.amt_limit_ge_amt_agreed(

1844: , x_result_type => l_result_type
1845: );
1846:
1847: WHEN c_amt_limit_ge_amt_agreed THEN
1848: PO_VAL_HEADERS.amt_limit_ge_amt_agreed(
1849: p_header_id_tbl => p_headers.po_header_id
1850: , p_blanket_total_amount_tbl => p_headers.blanket_total_amount
1851: , p_amount_limit_tbl => p_headers.amount_limit
1852: , x_results => x_results

Line 1857: PO_VAL_HEADERS.amount_agreed_ge_zero(

1853: , x_result_type => l_result_type
1854: );
1855:
1856: WHEN c_amount_agreed_ge_zero THEN
1857: PO_VAL_HEADERS.amount_agreed_ge_zero(
1858: p_header_id_tbl => p_headers.po_header_id
1859: , p_blanket_total_amount_tbl => p_headers.blanket_total_amount
1860: , x_results => x_results
1861: , x_result_type => l_result_type

Line 1865: PO_VAL_HEADERS.amount_agreed_not_null(

1861: , x_result_type => l_result_type
1862: );
1863:
1864: WHEN c_amount_agreed_not_null THEN
1865: PO_VAL_HEADERS.amount_agreed_not_null(
1866: p_header_id_tbl => p_headers.po_header_id
1867: , p_blanket_total_amount_tbl => p_headers.blanket_total_amount
1868: , p_amount_limit_tbl => p_headers.amount_limit
1869: , x_results => x_results

Line 1874: PO_VAL_HEADERS.effective_le_expiration(

1870: , x_result_type => l_result_type
1871: );
1872:
1873: WHEN c_effective_le_expiration THEN
1874: PO_VAL_HEADERS.effective_le_expiration(
1875: p_header_id_tbl => p_headers.po_header_id
1876: , p_start_date_tbl => p_headers.start_date
1877: , p_end_date_tbl => p_headers.end_date
1878: , x_results => x_results

Line 1883: PO_VAL_HEADERS.effective_from_le_order_date(

1879: , x_result_type => l_result_type
1880: );
1881:
1882: WHEN c_effective_from_le_order_date THEN
1883: PO_VAL_HEADERS.effective_from_le_order_date(
1884: p_header_id_tbl => p_headers.po_header_id
1885: , p_type_lookup_code_tbl => p_headers.type_lookup_code
1886: , p_start_date_tbl => p_headers.start_date
1887: , x_result_set_id => l_result_set_id

Line 1892: PO_VAL_HEADERS.effective_to_ge_order_date(

1888: , x_result_type => l_result_type
1889: );
1890:
1891: WHEN c_effective_to_ge_order_date THEN
1892: PO_VAL_HEADERS.effective_to_ge_order_date(
1893: p_header_id_tbl => p_headers.po_header_id
1894: , p_type_lookup_code_tbl => p_headers.type_lookup_code
1895: , p_end_date_tbl => p_headers.end_date
1896: , x_result_set_id => l_result_set_id

Line 1901: PO_VAL_HEADERS.contract_start_le_order_date(

1897: , x_result_type => l_result_type
1898: );
1899:
1900: WHEN c_contract_start_le_order_date THEN
1901: PO_VAL_HEADERS.contract_start_le_order_date(
1902: p_header_id_tbl => p_headers.po_header_id
1903: , p_type_lookup_code_tbl => p_headers.type_lookup_code
1904: , p_start_date_tbl => p_headers.start_date
1905: , x_result_set_id => l_result_set_id

Line 1910: PO_VAL_HEADERS.contract_end_ge_order_date(

1906: , x_result_type => l_result_type
1907: );
1908:
1909: WHEN c_contract_end_ge_order_date THEN
1910: PO_VAL_HEADERS.contract_end_ge_order_date(
1911: p_header_id_tbl => p_headers.po_header_id
1912: , p_type_lookup_code_tbl => p_headers.type_lookup_code
1913: , p_end_date_tbl => p_headers.end_date
1914: , x_result_set_id => l_result_set_id

Line 1919: PO_VAL_HEADERS.agent_id_not_null(

1915: , x_result_type => l_result_type
1916: );
1917:
1918: WHEN c_agent_id_not_null THEN
1919: PO_VAL_HEADERS.agent_id_not_null(
1920: p_header_id_tbl => p_headers.po_header_id
1921: , p_agent_id_tbl => p_headers.agent_id
1922: , x_results => x_results
1923: , x_result_type => l_result_type

Line 1927: PO_VAL_HEADERS.ship_to_loc_not_null(

1923: , x_result_type => l_result_type
1924: );
1925:
1926: WHEN c_hdr_ship_to_loc_not_null THEN
1927: PO_VAL_HEADERS.ship_to_loc_not_null(
1928: p_header_id_tbl => p_headers.po_header_id
1929: , p_ship_to_loc_id_tbl => p_headers.ship_to_location_id
1930: , x_results => x_results
1931: , x_result_type => l_result_type

Line 1935: PO_VAL_HEADERS.vendor_id_not_null(

1931: , x_result_type => l_result_type
1932: );
1933:
1934: WHEN c_vendor_id_not_null THEN
1935: PO_VAL_HEADERS.vendor_id_not_null(
1936: p_header_id_tbl => p_headers.po_header_id
1937: , p_vendor_id_tbl => p_headers.vendor_id
1938: , x_results => x_results
1939: , x_result_type => l_result_type

Line 1943: PO_VAL_HEADERS.vendor_site_id_not_null(

1939: , x_result_type => l_result_type
1940: );
1941:
1942: WHEN c_vendor_site_id_not_null THEN
1943: PO_VAL_HEADERS.vendor_site_id_not_null(
1944: p_header_id_tbl => p_headers.po_header_id
1945: , p_vendor_site_id_tbl => p_headers.vendor_site_id
1946: , x_results => x_results
1947: , x_result_type => l_result_type

Line 1952: PO_VAL_HEADERS.segment1_not_null(

1948: );
1949:
1950: -- EXCEPTION WHEN SAVE PO WO/ NUMBER IF DOCUMENT NUMBERING IS SET TO MANUAL
1951: WHEN c_segment1_not_null THEN
1952: PO_VAL_HEADERS.segment1_not_null(
1953: p_header_id_tbl => p_headers.po_header_id
1954: , p_segment1_tbl => p_headers.segment1
1955: , p_org_id_tbl => p_headers.org_id
1956: , x_result_set_id => l_result_set_id

Line 1967: PO_VAL_HEADERS2.po_header_id(p_id_tbl => p_headers.interface_id,

1963: -------------------------------------------------------------------------
1964: WHEN c_po_header_id THEN
1965: -- validate that the PO Header Id is not null and
1966: -- does not already exist in the Transaction table (for create case).
1967: PO_VAL_HEADERS2.po_header_id(p_id_tbl => p_headers.interface_id,
1968: p_po_header_id_tbl => p_headers.po_header_id,
1969: x_result_set_id => l_result_set_id,
1970: x_result_type => l_result_type);
1971: WHEN c_end_date THEN

Line 1987: PO_VAL_HEADERS2.type_lookup_code(p_id_tbl => p_headers.interface_id,

1983: x_result_type => l_result_type);
1984:
1985: WHEN c_type_lookup_code THEN
1986: -- validate type_lookup_code not null and equal to BLANKET, STANDARD or QUOTATION.
1987: PO_VAL_HEADERS2.type_lookup_code(p_id_tbl => p_headers.interface_id,
1988: p_type_lookup_code_tbl => p_headers.type_lookup_code,
1989: x_results => x_results,
1990: x_result_type => l_result_type);
1991: WHEN c_document_num THEN

Line 1993: PO_VAL_HEADERS2.document_num(p_id_tbl => p_headers.interface_id,

1989: x_results => x_results,
1990: x_result_type => l_result_type);
1991: WHEN c_document_num THEN
1992: -- document_num must not be null, must be unique, greater than or equal to zero and be of the correct type.
1993: PO_VAL_HEADERS2.document_num(p_id_tbl => p_headers.interface_id,
1994: p_po_header_id_tbl => p_headers.po_header_id,
1995: p_document_num_tbl => p_headers.document_num,
1996: p_type_lookup_code_tbl => p_headers.type_lookup_code,
1997: p_manual_po_num_type => l_manual_po_num_type,

Line 2005: PO_VAL_HEADERS2.acceptance_required_flag

2001: x_result_type => l_result_type);
2002:
2003: WHEN c_acceptance_required_flag THEN
2004: -- bug4911383
2005: PO_VAL_HEADERS2.acceptance_required_flag
2006: ( p_id_tbl => p_headers.interface_id,
2007: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2008: p_acceptance_required_flag_tbl => p_headers.acceptance_required_flag,
2009: x_results => x_results,

Line 2027: PO_VAL_HEADERS2.currency_code(p_id_tbl => p_headers.interface_id,

2023: x_results => x_results,
2024: x_result_type => l_result_type);
2025: WHEN c_currency_code THEN
2026: -- validate currency_code is not null and valid in FND_CURRENCIES.
2027: PO_VAL_HEADERS2.currency_code(p_id_tbl => p_headers.interface_id,
2028: p_currency_code_tbl => p_headers.currency_code,
2029: x_result_set_id => l_result_set_id,
2030: x_result_type => l_result_type);
2031: WHEN c_rate_info THEN

Line 2033: PO_VAL_HEADERS2.rate_info(p_id_tbl => p_headers.interface_id,

2029: x_result_set_id => l_result_set_id,
2030: x_result_type => l_result_type);
2031: WHEN c_rate_info THEN
2032: -- validate rate information
2033: PO_VAL_HEADERS2.rate_info(p_id_tbl => p_headers.interface_id,
2034: p_currency_code_tbl => p_headers.currency_code,
2035: p_rate_type_tbl => p_headers.rate_type,
2036: p_rate_tbl => p_headers.rate,
2037: p_rate_date_tbl => p_headers.rate_date,

Line 2045: PO_VAL_HEADERS2.agent_id(p_id_tbl => p_headers.interface_id,

2041: x_results => x_results,
2042: x_result_type => l_result_type);
2043: WHEN c_agent_id THEN
2044: -- validate agent_id is not null and valid in PO_AGENTS.
2045: PO_VAL_HEADERS2.agent_id(p_id_tbl => p_headers.interface_id,
2046: p_agent_id_tbl => p_headers.agent_id,
2047: x_result_set_id => l_result_set_id,
2048: x_result_type => l_result_type);
2049: WHEN c_vendor_info THEN

Line 2051: PO_VAL_HEADERS2.vendor_info(p_id_tbl => p_headers.interface_id,

2047: x_result_set_id => l_result_set_id,
2048: x_result_type => l_result_type);
2049: WHEN c_vendor_info THEN
2050: -- validate vendor information
2051: PO_VAL_HEADERS2.vendor_info(p_id_tbl => p_headers.interface_id,
2052: p_vendor_id_tbl => p_headers.vendor_id,
2053: p_vendor_site_id_tbl => p_headers.vendor_site_id,
2054: p_vendor_contact_id_tbl => p_headers.vendor_contact_id,
2055: p_federal_instance => l_federal_instance,

Line 2060: PO_VAL_HEADERS2.ship_to_location_id(p_id_tbl => p_headers.interface_id,

2056: x_result_set_id => l_result_set_id,
2057: x_results => x_results,
2058: x_result_type => l_result_type);
2059: WHEN c_ship_to_location_id THEN
2060: PO_VAL_HEADERS2.ship_to_location_id(p_id_tbl => p_headers.interface_id,
2061: p_ship_to_location_id_tbl => p_headers.ship_to_location_id,
2062: -- Bug 7007502: Added new param p_type_lookup_code_tbl
2063: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2064: x_result_set_id => l_result_set_id,

Line 2067: PO_VAL_HEADERS2.bill_to_location_id(p_id_tbl => p_headers.interface_id,

2063: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2064: x_result_set_id => l_result_set_id,
2065: x_result_type => l_result_type);
2066: WHEN c_bill_to_location_id THEN
2067: PO_VAL_HEADERS2.bill_to_location_id(p_id_tbl => p_headers.interface_id,
2068: p_bill_to_location_id_tbl => p_headers.bill_to_location_id,
2069: -- Bug 7007502: Added new param p_type_lookup_code_tbl
2070: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2071: x_result_set_id => l_result_set_id,

Line 2074: PO_VAL_HEADERS2.style_id(p_id_tbl => p_headers.interface_id,

2070: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2071: x_result_set_id => l_result_set_id,
2072: x_result_type => l_result_type);
2073: WHEN c_style_id THEN
2074: PO_VAL_HEADERS2.style_id(p_id_tbl => p_headers.interface_id,
2075: p_style_id_tbl => p_headers.style_id,
2076: x_result_set_id => l_result_set_id,
2077: x_result_type => l_result_type);
2078: WHEN c_last_update_date THEN

Line 2191: PO_VAL_HEADERS2.ship_via_lookup_code(p_id_tbl => p_headers.interface_id,

2187: p_validation_id => PO_VAL_CONSTANTS.c_terms_id_header,
2188: x_result_set_id => l_result_set_id,
2189: x_result_type => l_result_type);
2190: WHEN c_ship_via_lookup_code THEN
2191: PO_VAL_HEADERS2.ship_via_lookup_code(p_id_tbl => p_headers.interface_id,
2192: p_ship_via_lookup_code_tbl => p_headers.ship_via_lookup_code,
2193: p_inventory_org_id => l_inventory_org_id,
2194: x_result_set_id => l_result_set_id,
2195: x_result_type => l_result_type);

Line 2197: PO_VAL_HEADERS2.fob_lookup_code(p_id_tbl => p_headers.interface_id,

2193: p_inventory_org_id => l_inventory_org_id,
2194: x_result_set_id => l_result_set_id,
2195: x_result_type => l_result_type);
2196: WHEN c_fob_lookup_code THEN
2197: PO_VAL_HEADERS2.fob_lookup_code(p_id_tbl => p_headers.interface_id,
2198: p_fob_lookup_code_tbl => p_headers.fob_lookup_code,
2199: x_result_set_id => l_result_set_id,
2200: x_result_type => l_result_type);
2201: WHEN c_freight_terms_lookup_code THEN

Line 2202: PO_VAL_HEADERS2.freight_terms_lookup_code(p_id_tbl => p_headers.interface_id,

2198: p_fob_lookup_code_tbl => p_headers.fob_lookup_code,
2199: x_result_set_id => l_result_set_id,
2200: x_result_type => l_result_type);
2201: WHEN c_freight_terms_lookup_code THEN
2202: PO_VAL_HEADERS2.freight_terms_lookup_code(p_id_tbl => p_headers.interface_id,
2203: p_freight_terms_lookup_tbl => p_headers.freight_terms_lookup_code,
2204: x_result_set_id => l_result_set_id,
2205: x_result_type => l_result_type);
2206: WHEN c_shipping_control THEN

Line 2207: PO_VAL_HEADERS2.shipping_control(p_id_tbl => p_headers.interface_id,

2203: p_freight_terms_lookup_tbl => p_headers.freight_terms_lookup_code,
2204: x_result_set_id => l_result_set_id,
2205: x_result_type => l_result_type);
2206: WHEN c_shipping_control THEN
2207: PO_VAL_HEADERS2.shipping_control(p_id_tbl => p_headers.interface_id,
2208: p_shipping_control_tbl => p_headers.shipping_control,
2209: x_result_set_id => l_result_set_id,
2210: x_result_type => l_result_type);
2211: WHEN c_confirming_order_flag THEN

Line 2226: PO_VAL_HEADERS2.acceptance_due_date(p_id_tbl => p_headers.interface_id,

2222: p_validation_id => PO_VAL_CONSTANTS.c_confirming_order_flag,
2223: x_results => x_results,
2224: x_result_type => l_result_type);
2225: WHEN c_acceptance_due_date THEN
2226: PO_VAL_HEADERS2.acceptance_due_date(p_id_tbl => p_headers.interface_id,
2227: p_acceptance_reqd_flag_tbl => p_headers.acceptance_required_flag,
2228: p_acceptance_due_date_tbl => p_headers.acceptance_due_date,
2229: x_results => x_results,
2230: x_result_type => l_result_type);

Line 2248: PO_VAL_HEADERS2.amount_limit

2244: x_results => x_results,
2245: x_result_type => l_result_type);
2246: WHEN c_amount_limit THEN
2247: -- bug 5352625
2248: PO_VAL_HEADERS2.amount_limit
2249: ( p_id_tbl => p_headers.interface_id,
2250: p_amount_limit_tbl => p_headers.amount_limit,
2251: p_amount_agreed_tbl => p_headers.amount_agreed,
2252: x_results => x_results,

Line 2271: PO_VAL_HEADERS2.cancel_flag(p_id_tbl => p_headers.interface_id,

2267: p_validation_id => PO_VAL_CONSTANTS.c_firm_status_lookup_header,
2268: x_results => x_results,
2269: x_result_type => l_result_type);
2270: WHEN c_cancel_flag THEN
2271: PO_VAL_HEADERS2.cancel_flag(p_id_tbl => p_headers.interface_id,
2272: p_cancel_flag_tbl => p_headers.cancel_flag,
2273: x_results => x_results,
2274: x_result_type => l_result_type);
2275: WHEN c_closed_code THEN

Line 2276: PO_VAL_HEADERS2.closed_code(p_id_tbl => p_headers.interface_id,

2272: p_cancel_flag_tbl => p_headers.cancel_flag,
2273: x_results => x_results,
2274: x_result_type => l_result_type);
2275: WHEN c_closed_code THEN
2276: PO_VAL_HEADERS2.closed_code(p_id_tbl => p_headers.interface_id,
2277: p_closed_code_tbl => p_headers.closed_code,
2278: p_acceptance_reqd_flag_tbl => p_headers.acceptance_required_flag,
2279: x_results => x_results,
2280: x_result_type => l_result_type);

Line 2282: PO_VAL_HEADERS2.print_count(p_id_tbl => p_headers.interface_id,

2278: p_acceptance_reqd_flag_tbl => p_headers.acceptance_required_flag,
2279: x_results => x_results,
2280: x_result_type => l_result_type);
2281: WHEN c_print_count THEN
2282: PO_VAL_HEADERS2.print_count(p_id_tbl => p_headers.interface_id,
2283: p_print_count_tbl => p_headers.print_count,
2284: p_approval_status_tbl => p_headers.approval_status,
2285: x_results => x_results,
2286: x_result_type => l_result_type);

Line 2302: PO_VAL_HEADERS2.approval_status(p_id_tbl => p_headers.interface_id,

2298: p_validation_id => PO_VAL_CONSTANTS.c_frozen_flag,
2299: x_results => x_results,
2300: x_result_type => l_result_type);
2301: WHEN c_approval_status THEN
2302: PO_VAL_HEADERS2.approval_status(p_id_tbl => p_headers.interface_id,
2303: p_approval_status_tbl => p_headers.approval_status,
2304: x_results => x_results,
2305: x_result_type => l_result_type);
2306: WHEN c_amount_to_encumber THEN

Line 2307: PO_VAL_HEADERS2.amount_to_encumber(p_id_tbl => p_headers.interface_id,

2303: p_approval_status_tbl => p_headers.approval_status,
2304: x_results => x_results,
2305: x_result_type => l_result_type);
2306: WHEN c_amount_to_encumber THEN
2307: PO_VAL_HEADERS2.amount_to_encumber(p_id_tbl => p_headers.interface_id,
2308: p_amount_to_encumber_tbl => p_headers.amount_to_encumber,
2309: x_results => x_results,
2310: x_result_type => l_result_type);
2311: WHEN c_quote_warning_delay THEN