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 2058: PO_VAL_HEADERS.warn_supplier_on_hold(

2054: -- Header Validations
2055: ---------------------------------------------------------------
2056:
2057: WHEN c_warn_supplier_on_hold THEN
2058: PO_VAL_HEADERS.warn_supplier_on_hold(
2059: p_header_id_tbl => p_headers.po_header_id
2060: , p_vendor_id_tbl => p_headers.vendor_id
2061: , x_result_set_id => l_result_set_id
2062: , x_result_type => l_result_type

Line 2066: PO_VAL_HEADERS.rate_gt_zero(

2062: , x_result_type => l_result_type
2063: );
2064:
2065: WHEN c_rate_gt_zero THEN
2066: PO_VAL_HEADERS.rate_gt_zero(
2067: p_header_id_tbl => p_headers.po_header_id
2068: , p_rate_tbl => p_headers.rate
2069: , x_results => x_results
2070: , x_result_type => l_result_type

Line 2074: PO_VAL_HEADERS.fax_email_address_valid(

2070: , x_result_type => l_result_type
2071: );
2072:
2073: WHEN c_fax_email_address_valid THEN
2074: PO_VAL_HEADERS.fax_email_address_valid(
2075: p_header_id_tbl => p_headers.po_header_id
2076: , p_supplier_notif_method_tbl => p_headers.supplier_notif_method
2077: , p_fax_tbl => p_headers.fax
2078: , p_email_address_tbl => p_headers.email_address

Line 2084: PO_VAL_HEADERS.rate_combination_valid(

2080: , x_result_type => l_result_type
2081: );
2082:
2083: WHEN c_rate_combination_valid THEN
2084: PO_VAL_HEADERS.rate_combination_valid(
2085: p_header_id_tbl => p_headers.po_header_id
2086: , p_org_id_tbl => p_headers.org_id
2087: , p_currency_code_tbl => p_headers.currency_code
2088: , p_rate_type_tbl => p_headers.rate_type

Line 2096: PO_VAL_HEADERS.doc_num_chars_valid(

2092: , x_result_type => l_result_type
2093: );
2094:
2095: WHEN c_doc_num_chars_valid THEN
2096: PO_VAL_HEADERS.doc_num_chars_valid(
2097: p_header_id_tbl => p_headers.po_header_id
2098: , p_org_id_tbl => p_headers.org_id
2099: , p_style_id_tbl => p_headers.style_id
2100: , p_segment1_tbl => p_headers.segment1

Line 2106: PO_VAL_HEADERS.doc_num_unique(

2102: , x_result_type => l_result_type
2103: );
2104:
2105: WHEN c_doc_num_unique THEN
2106: PO_VAL_HEADERS.doc_num_unique(
2107: p_header_id_tbl => p_headers.po_header_id
2108: , p_org_id_tbl => p_headers.org_id
2109: , p_segment1_tbl => p_headers.segment1
2110: , p_type_lookup_code_tbl => p_headers.type_lookup_code

Line 2116: PO_VAL_HEADERS.price_update_tol_ge_zero(

2112: , x_result_type => l_result_type
2113: );
2114:
2115: WHEN c_price_update_tol_ge_zero THEN
2116: PO_VAL_HEADERS.price_update_tol_ge_zero(
2117: p_header_id_tbl => p_headers.po_header_id
2118: , p_price_update_tol_tbl => p_headers.price_update_tolerance
2119: , x_results => x_results
2120: , x_result_type => l_result_type

Line 2124: PO_VAL_HEADERS.amount_limit_ge_zero(

2120: , x_result_type => l_result_type
2121: );
2122:
2123: WHEN c_amount_limit_ge_zero THEN
2124: PO_VAL_HEADERS.amount_limit_ge_zero(
2125: p_header_id_tbl => p_headers.po_header_id
2126: , p_amount_limit_tbl => p_headers.amount_limit
2127: , x_results => x_results
2128: , x_result_type => l_result_type

Line 2132: PO_VAL_HEADERS.amt_limit_ge_amt_agreed(

2128: , x_result_type => l_result_type
2129: );
2130:
2131: WHEN c_amt_limit_ge_amt_agreed THEN
2132: PO_VAL_HEADERS.amt_limit_ge_amt_agreed(
2133: p_header_id_tbl => p_headers.po_header_id
2134: , p_style_id_tbl =>p_headers.style_id --Bug 12660599
2135: , p_blanket_total_amount_tbl => p_headers.blanket_total_amount
2136: , p_amount_limit_tbl => p_headers.amount_limit

Line 2142: PO_VAL_HEADERS.amount_agreed_ge_zero(

2138: , x_result_type => l_result_type
2139: );
2140:
2141: WHEN c_amount_agreed_ge_zero THEN
2142: PO_VAL_HEADERS.amount_agreed_ge_zero(
2143: p_header_id_tbl => p_headers.po_header_id
2144: , p_blanket_total_amount_tbl => p_headers.blanket_total_amount
2145: , x_results => x_results
2146: , x_result_type => l_result_type

Line 2150: PO_VAL_HEADERS.amount_agreed_not_null(

2146: , x_result_type => l_result_type
2147: );
2148:
2149: WHEN c_amount_agreed_not_null THEN
2150: PO_VAL_HEADERS.amount_agreed_not_null(
2151: p_header_id_tbl => p_headers.po_header_id
2152: , p_blanket_total_amount_tbl => p_headers.blanket_total_amount
2153: , p_amount_limit_tbl => p_headers.amount_limit
2154: , x_results => x_results

Line 2159: PO_VAL_HEADERS.effective_le_expiration(

2155: , x_result_type => l_result_type
2156: );
2157:
2158: WHEN c_effective_le_expiration THEN
2159: PO_VAL_HEADERS.effective_le_expiration(
2160: p_header_id_tbl => p_headers.po_header_id
2161: , p_start_date_tbl => p_headers.start_date
2162: , p_end_date_tbl => p_headers.end_date
2163: , x_results => x_results

Line 2168: PO_VAL_HEADERS.effective_from_le_order_date(

2164: , x_result_type => l_result_type
2165: );
2166:
2167: WHEN c_effective_from_le_order_date THEN
2168: PO_VAL_HEADERS.effective_from_le_order_date(
2169: p_header_id_tbl => p_headers.po_header_id
2170: , p_type_lookup_code_tbl => p_headers.type_lookup_code
2171: , p_start_date_tbl => p_headers.start_date
2172: , x_result_set_id => l_result_set_id

Line 2177: PO_VAL_HEADERS.effective_to_ge_order_date(

2173: , x_result_type => l_result_type
2174: );
2175:
2176: WHEN c_effective_to_ge_order_date THEN
2177: PO_VAL_HEADERS.effective_to_ge_order_date(
2178: p_header_id_tbl => p_headers.po_header_id
2179: , p_type_lookup_code_tbl => p_headers.type_lookup_code
2180: , p_end_date_tbl => p_headers.end_date
2181: , x_result_set_id => l_result_set_id

Line 2186: PO_VAL_HEADERS.contract_start_le_order_date(

2182: , x_result_type => l_result_type
2183: );
2184:
2185: WHEN c_contract_start_le_order_date THEN
2186: PO_VAL_HEADERS.contract_start_le_order_date(
2187: p_header_id_tbl => p_headers.po_header_id
2188: , p_type_lookup_code_tbl => p_headers.type_lookup_code
2189: , p_start_date_tbl => p_headers.start_date
2190: , x_result_set_id => l_result_set_id

Line 2195: PO_VAL_HEADERS.contract_end_ge_order_date(

2191: , x_result_type => l_result_type
2192: );
2193:
2194: WHEN c_contract_end_ge_order_date THEN
2195: PO_VAL_HEADERS.contract_end_ge_order_date(
2196: p_header_id_tbl => p_headers.po_header_id
2197: , p_type_lookup_code_tbl => p_headers.type_lookup_code
2198: , p_end_date_tbl => p_headers.end_date
2199: , x_result_set_id => l_result_set_id

Line 2204: PO_VAL_HEADERS.agent_id_not_null(

2200: , x_result_type => l_result_type
2201: );
2202:
2203: WHEN c_agent_id_not_null THEN
2204: PO_VAL_HEADERS.agent_id_not_null(
2205: p_header_id_tbl => p_headers.po_header_id
2206: , p_agent_id_tbl => p_headers.agent_id
2207: , x_results => x_results
2208: , x_result_type => l_result_type

Line 2212: PO_VAL_HEADERS.ship_to_loc_not_null(

2208: , x_result_type => l_result_type
2209: );
2210:
2211: WHEN c_hdr_ship_to_loc_not_null THEN
2212: PO_VAL_HEADERS.ship_to_loc_not_null(
2213: p_header_id_tbl => p_headers.po_header_id
2214: , p_ship_to_loc_id_tbl => p_headers.ship_to_location_id
2215: , x_results => x_results
2216: , x_result_type => l_result_type

Line 2220: PO_VAL_HEADERS.vendor_id_not_null(

2216: , x_result_type => l_result_type
2217: );
2218:
2219: WHEN c_vendor_id_not_null THEN
2220: PO_VAL_HEADERS.vendor_id_not_null(
2221: p_header_id_tbl => p_headers.po_header_id
2222: , p_vendor_id_tbl => p_headers.vendor_id
2223: , x_results => x_results
2224: , x_result_type => l_result_type

Line 2228: PO_VAL_HEADERS.vendor_site_id_not_null(

2224: , x_result_type => l_result_type
2225: );
2226:
2227: WHEN c_vendor_site_id_not_null THEN
2228: PO_VAL_HEADERS.vendor_site_id_not_null(
2229: p_header_id_tbl => p_headers.po_header_id
2230: , p_vendor_site_id_tbl => p_headers.vendor_site_id
2231: , x_results => x_results
2232: , x_result_type => l_result_type

Line 2237: PO_VAL_HEADERS.segment1_not_null(

2233: );
2234:
2235: -- EXCEPTION WHEN SAVE PO WO/ NUMBER IF DOCUMENT NUMBERING IS SET TO MANUAL
2236: WHEN c_segment1_not_null THEN
2237: PO_VAL_HEADERS.segment1_not_null(
2238: p_header_id_tbl => p_headers.po_header_id
2239: , p_segment1_tbl => p_headers.segment1
2240: , p_org_id_tbl => p_headers.org_id
2241: , x_result_set_id => l_result_set_id

Line 2247: PO_VAL_HEADERS.ship_via_lookup_code_valid(

2243: );
2244: --
2245: -- Error when the ship_via field has an invalid value.
2246: WHEN c_ship_via_lookup_code_valid THEN
2247: PO_VAL_HEADERS.ship_via_lookup_code_valid(
2248: p_header_id_tbl=> p_headers.po_header_id,
2249: p_ship_via_lookup_code_tbl => p_headers.ship_via_lookup_code,
2250: --Bug 12409257 begin. Bug 13771850 Revert the Bug 12409257 back
2251: p_org_id_tbl => p_headers.org_id,

Line 2261: PO_VAL_HEADERS.print_form_format_valid(

2257:
2258: --Mod project
2259:
2260: WHEN c_print_form_format_valid THEN
2261: PO_VAL_HEADERS.print_form_format_valid(
2262: p_header_id_tbl => p_headers.po_header_id
2263: , p_type_lookup_code_tbl => p_headers.type_lookup_code
2264: , p_style_id_tbl => p_headers.style_id
2265: , p_draft_type_tbl => p_headers.draft_type

Line 2276: PO_VAL_HEADERS.mod_no_cancel_shp_complt(

2272: , x_result_type => l_result_type
2273: );
2274:
2275: WHEN c_hmod_no_cancel_shp_complt THEN
2276: PO_VAL_HEADERS.mod_no_cancel_shp_complt(
2277: p_header_id_tbl => p_headers.po_header_id
2278: , p_control_action_tbl => p_headers.control_action
2279: , x_result_set_id => l_result_set_id
2280: , x_result_type => l_result_type

Line 2285: PO_VAL_HEADERS.validate_mod_number(

2281: );
2282:
2283: --
2284: WHEN c_validate_mod_number THEN
2285: PO_VAL_HEADERS.validate_mod_number(
2286: p_header_id_tbl => p_headers.po_header_id
2287: , p_draft_type_tbl => p_headers.draft_type
2288: , p_mod_number_tbl => p_headers.modification_number
2289: , x_results => x_results

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

2297: -------------------------------------------------------------------------
2298: WHEN c_po_header_id THEN
2299: -- validate that the PO Header Id is not null and
2300: -- does not already exist in the Transaction table (for create case).
2301: PO_VAL_HEADERS2.po_header_id(p_id_tbl => p_headers.interface_id,
2302: p_po_header_id_tbl => p_headers.po_header_id,
2303: x_result_set_id => l_result_set_id,
2304: x_result_type => l_result_type);
2305: WHEN c_end_date THEN

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

2317: x_result_type => l_result_type);
2318:
2319: WHEN c_type_lookup_code THEN
2320: -- validate type_lookup_code not null and equal to BLANKET, STANDARD or QUOTATION.
2321: PO_VAL_HEADERS2.type_lookup_code(p_id_tbl => p_headers.interface_id,
2322: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2323: x_results => x_results,
2324: x_result_type => l_result_type);
2325: WHEN c_document_num THEN

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

2323: x_results => x_results,
2324: x_result_type => l_result_type);
2325: WHEN c_document_num THEN
2326: -- document_num must not be null, must be unique, greater than or equal to zero and be of the correct type.
2327: PO_VAL_HEADERS2.document_num(p_id_tbl => p_headers.interface_id,
2328: p_po_header_id_tbl => p_headers.po_header_id,
2329: p_document_num_tbl => p_headers.document_num,
2330: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2331: p_manual_po_num_type => l_manual_po_num_type,

Line 2339: PO_VAL_HEADERS2.acceptance_required_flag

2335: x_result_type => l_result_type);
2336:
2337: WHEN c_acceptance_required_flag THEN
2338: -- bug4911383
2339: PO_VAL_HEADERS2.acceptance_required_flag
2340: ( p_id_tbl => p_headers.interface_id,
2341: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2342: p_acceptance_required_flag_tbl => p_headers.acceptance_required_flag,
2343: x_results => x_results,

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

2357: x_results => x_results,
2358: x_result_type => l_result_type);
2359: WHEN c_currency_code THEN
2360: -- validate currency_code is not null and valid in FND_CURRENCIES.
2361: PO_VAL_HEADERS2.currency_code(p_id_tbl => p_headers.interface_id,
2362: p_currency_code_tbl => p_headers.currency_code,
2363: x_result_set_id => l_result_set_id,
2364: x_result_type => l_result_type);
2365: WHEN c_rate_info THEN

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

2363: x_result_set_id => l_result_set_id,
2364: x_result_type => l_result_type);
2365: WHEN c_rate_info THEN
2366: -- validate rate information
2367: PO_VAL_HEADERS2.rate_info(p_id_tbl => p_headers.interface_id,
2368: p_currency_code_tbl => p_headers.currency_code,
2369: p_rate_type_tbl => p_headers.rate_type,
2370: p_rate_tbl => p_headers.rate,
2371: p_rate_date_tbl => p_headers.rate_date,

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

2375: x_results => x_results,
2376: x_result_type => l_result_type);
2377: WHEN c_agent_id THEN
2378: -- validate agent_id is not null and valid in PO_AGENTS.
2379: PO_VAL_HEADERS2.agent_id(p_id_tbl => p_headers.interface_id,
2380: p_agent_id_tbl => p_headers.agent_id,
2381: x_result_set_id => l_result_set_id,
2382: x_result_type => l_result_type);
2383: WHEN c_vendor_info THEN

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

2381: x_result_set_id => l_result_set_id,
2382: x_result_type => l_result_type);
2383: WHEN c_vendor_info THEN
2384: -- validate vendor information
2385: PO_VAL_HEADERS2.vendor_info(p_id_tbl => p_headers.interface_id,
2386: p_vendor_id_tbl => p_headers.vendor_id,
2387: p_vendor_site_id_tbl => p_headers.vendor_site_id,
2388: p_vendor_contact_id_tbl => p_headers.vendor_contact_id,
2389: p_type_lookup_code_tbl => p_headers.type_lookup_code, -- 8913559 bug

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

2391: x_result_set_id => l_result_set_id,
2392: x_results => x_results,
2393: x_result_type => l_result_type);
2394: WHEN c_ship_to_location_id THEN
2395: PO_VAL_HEADERS2.ship_to_location_id(p_id_tbl => p_headers.interface_id,
2396: p_ship_to_location_id_tbl => p_headers.ship_to_location_id,
2397: -- Bug 7007502: Added new param p_type_lookup_code_tbl
2398: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2399: x_result_set_id => l_result_set_id,

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

2398: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2399: x_result_set_id => l_result_set_id,
2400: x_result_type => l_result_type);
2401: WHEN c_bill_to_location_id THEN
2402: PO_VAL_HEADERS2.bill_to_location_id(p_id_tbl => p_headers.interface_id,
2403: p_bill_to_location_id_tbl => p_headers.bill_to_location_id,
2404: -- Bug 7007502: Added new param p_type_lookup_code_tbl
2405: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2406: x_result_set_id => l_result_set_id,

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

2405: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2406: x_result_set_id => l_result_set_id,
2407: x_result_type => l_result_type);
2408: WHEN c_style_id THEN
2409: PO_VAL_HEADERS2.style_id(p_id_tbl => p_headers.interface_id,
2410: p_style_id_tbl => p_headers.style_id,
2411: x_result_set_id => l_result_set_id,
2412: x_result_type => l_result_type);
2413: WHEN c_last_update_date THEN

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

2522: p_validation_id => PO_VAL_CONSTANTS.c_terms_id_header,
2523: x_result_set_id => l_result_set_id,
2524: x_result_type => l_result_type);
2525: WHEN c_ship_via_lookup_code THEN
2526: PO_VAL_HEADERS2.ship_via_lookup_code(p_id_tbl => p_headers.interface_id,
2527: p_ship_via_lookup_code_tbl => p_headers.ship_via_lookup_code,
2528: p_inventory_org_id => l_inventory_org_id,
2529: x_result_set_id => l_result_set_id,
2530: x_result_type => l_result_type);

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

2528: p_inventory_org_id => l_inventory_org_id,
2529: x_result_set_id => l_result_set_id,
2530: x_result_type => l_result_type);
2531: WHEN c_fob_lookup_code THEN
2532: PO_VAL_HEADERS2.fob_lookup_code(p_id_tbl => p_headers.interface_id,
2533: p_fob_lookup_code_tbl => p_headers.fob_lookup_code,
2534: x_result_set_id => l_result_set_id,
2535: x_result_type => l_result_type);
2536: WHEN c_freight_terms_lookup_code THEN

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

2533: p_fob_lookup_code_tbl => p_headers.fob_lookup_code,
2534: x_result_set_id => l_result_set_id,
2535: x_result_type => l_result_type);
2536: WHEN c_freight_terms_lookup_code THEN
2537: PO_VAL_HEADERS2.freight_terms_lookup_code(p_id_tbl => p_headers.interface_id,
2538: p_freight_terms_lookup_tbl => p_headers.freight_terms_lookup_code,
2539: x_result_set_id => l_result_set_id,
2540: x_result_type => l_result_type);
2541: WHEN c_shipping_control THEN

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

2538: p_freight_terms_lookup_tbl => p_headers.freight_terms_lookup_code,
2539: x_result_set_id => l_result_set_id,
2540: x_result_type => l_result_type);
2541: WHEN c_shipping_control THEN
2542: PO_VAL_HEADERS2.shipping_control(p_id_tbl => p_headers.interface_id,
2543: p_shipping_control_tbl => p_headers.shipping_control,
2544: x_result_set_id => l_result_set_id,
2545: x_result_type => l_result_type);
2546: WHEN c_confirming_order_flag THEN

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

2557: p_validation_id => PO_VAL_CONSTANTS.c_confirming_order_flag,
2558: x_results => x_results,
2559: x_result_type => l_result_type);
2560: WHEN c_acceptance_due_date THEN
2561: PO_VAL_HEADERS2.acceptance_due_date(p_id_tbl => p_headers.interface_id,
2562: p_acceptance_reqd_flag_tbl => p_headers.acceptance_required_flag,
2563: p_acceptance_due_date_tbl => p_headers.acceptance_due_date,
2564: x_results => x_results,
2565: x_result_type => l_result_type);

Line 2583: PO_VAL_HEADERS2.amount_limit

2579: x_results => x_results,
2580: x_result_type => l_result_type);
2581: WHEN c_amount_limit THEN
2582: -- bug 5352625
2583: PO_VAL_HEADERS2.amount_limit
2584: ( p_id_tbl => p_headers.interface_id,
2585: p_amount_limit_tbl => p_headers.amount_limit,
2586: p_amount_agreed_tbl => p_headers.amount_agreed,
2587: x_results => x_results,

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

2602: p_validation_id => PO_VAL_CONSTANTS.c_firm_status_lookup_header,
2603: x_results => x_results,
2604: x_result_type => l_result_type);
2605: WHEN c_cancel_flag THEN
2606: PO_VAL_HEADERS2.cancel_flag(p_id_tbl => p_headers.interface_id,
2607: p_cancel_flag_tbl => p_headers.cancel_flag,
2608: x_results => x_results,
2609: x_result_type => l_result_type);
2610: WHEN c_closed_code THEN

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

2607: p_cancel_flag_tbl => p_headers.cancel_flag,
2608: x_results => x_results,
2609: x_result_type => l_result_type);
2610: WHEN c_closed_code THEN
2611: PO_VAL_HEADERS2.closed_code(p_id_tbl => p_headers.interface_id,
2612: p_closed_code_tbl => p_headers.closed_code,
2613: p_acceptance_reqd_flag_tbl => p_headers.acceptance_required_flag,
2614: x_results => x_results,
2615: x_result_type => l_result_type);

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

2613: p_acceptance_reqd_flag_tbl => p_headers.acceptance_required_flag,
2614: x_results => x_results,
2615: x_result_type => l_result_type);
2616: WHEN c_print_count THEN
2617: PO_VAL_HEADERS2.print_count(p_id_tbl => p_headers.interface_id,
2618: p_print_count_tbl => p_headers.print_count,
2619: p_approval_status_tbl => p_headers.approval_status,
2620: x_results => x_results,
2621: x_result_type => l_result_type);

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

2633: p_validation_id => PO_VAL_CONSTANTS.c_frozen_flag,
2634: x_results => x_results,
2635: x_result_type => l_result_type);
2636: WHEN c_approval_status THEN
2637: PO_VAL_HEADERS2.approval_status(p_id_tbl => p_headers.interface_id,
2638: p_approval_status_tbl => p_headers.approval_status,
2639: x_results => x_results,
2640: x_result_type => l_result_type);
2641: WHEN c_amount_to_encumber THEN

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

2638: p_approval_status_tbl => p_headers.approval_status,
2639: x_results => x_results,
2640: x_result_type => l_result_type);
2641: WHEN c_amount_to_encumber THEN
2642: PO_VAL_HEADERS2.amount_to_encumber(p_id_tbl => p_headers.interface_id,
2643: p_amount_to_encumber_tbl => p_headers.amount_to_encumber,
2644: x_results => x_results,
2645: x_result_type => l_result_type);
2646: WHEN c_quote_warning_delay THEN

Line 2677: PO_VAL_HEADERS.clm_eff_from_le_order_date

2673: x_result_type => l_result_type);
2674:
2675: WHEN c_ord_st_dt_gt_effec_dt THEN
2676: -- validate order start date not earlier than effective date.
2677: PO_VAL_HEADERS.clm_eff_from_le_order_date
2678: (
2679: p_header_id_tbl => p_headers.po_header_id
2680: , p_type_lookup_code_tbl => p_headers.type_lookup_code
2681: , p_start_date_tbl => p_headers.start_date

Line 2689: PO_VAL_HEADERS.max_ceil_awd_amt_gt_min

2685: );
2686:
2687: WHEN c_max_ceil_awd_amt_gt_min THEN
2688: -- validate order start date not earlier than effective date.
2689: PO_VAL_HEADERS.max_ceil_awd_amt_gt_min
2690: (
2691: p_header_id_tbl => p_headers.po_header_id
2692: , p_type_lookup_code_tbl => p_headers.type_lookup_code
2693: , p_amount_limit_tbl => p_headers.amount_limit

Line 2700: PO_VAL_HEADERS.max_ceil_amt_gt_min_ord

2696: , x_result_type => l_result_type
2697: );
2698:
2699: WHEN c_max_ceil_amt_gt_min_ord THEN
2700: PO_VAL_HEADERS.max_ceil_amt_gt_min_ord
2701: (
2702: p_header_id_tbl => p_headers.po_header_id
2703: , p_type_lookup_code_tbl => p_headers.type_lookup_code
2704: , p_amount_limit_tbl => p_headers.amount_limit

Line 2711: PO_VAL_HEADERS.max_ceil_amt_gt_max_ord

2707: , x_result_type => l_result_type
2708: );
2709:
2710: WHEN c_max_ceil_amt_gt_max_ord THEN
2711: PO_VAL_HEADERS.max_ceil_amt_gt_max_ord
2712: (
2713: p_header_id_tbl => p_headers.po_header_id
2714: , p_type_lookup_code_tbl => p_headers.type_lookup_code
2715: , p_amount_limit_tbl => p_headers.amount_limit

Line 2722: PO_VAL_HEADERS.min_guar_perc_range_check(

2718: , x_result_type => l_result_type
2719: );
2720:
2721: WHEN c_min_guar_perc_range_check THEN
2722: PO_VAL_HEADERS.min_guar_perc_range_check(
2723: p_header_id_tbl => p_headers.po_header_id
2724: , p_min_guar_perc_tbl => p_headers.clm_min_guarantee_award_perc
2725: , x_results => x_results
2726: , x_result_type => l_result_type

Line 2731: PO_VAL_HEADERS.max_ord_amt_gt_min

2727: );
2728:
2729: WHEN c_max_ord_amt_gt_min THEN
2730: -- validate order start date not earlier than effective date.
2731: PO_VAL_HEADERS.max_ord_amt_gt_min
2732: (
2733: p_header_id_tbl => p_headers.po_header_id
2734: , p_type_lookup_code_tbl => p_headers.type_lookup_code
2735: , p_min_order_amt_tbl => p_headers.clm_min_order_amount

Line 2745: PO_VAL_HEADERS.validate_clm_standard_form

2741: --PDOI CLM Integration Start
2742:
2743:
2744: WHEN c_validate_clm_standard_form THEN
2745: PO_VAL_HEADERS.validate_clm_standard_form
2746: (
2747: p_intf_header_id => p_headers.interface_id,
2748: p_clm_standard_form_tbl => p_headers.clm_standard_form,
2749: p_style_id_tbl => p_headers.style_id,

Line 2754: PO_VAL_HEADERS.validate_clm_document_format

2750: x_results => x_results,
2751: x_result_type => l_result_type
2752: );
2753: WHEN c_validate_clm_document_format THEN
2754: PO_VAL_HEADERS.validate_clm_document_format
2755: (
2756: p_intf_header_id => p_headers.interface_id,
2757: p_clm_standard_form_tbl => p_headers.clm_standard_form,
2758: p_clm_document_format_tbl => p_headers.clm_document_format,

Line 2764: PO_VAL_HEADERS.validate_source_idv

2760: x_results => x_results,
2761: x_result_type => l_result_type
2762: );
2763: WHEN c_validate_source_idv THEN
2764: PO_VAL_HEADERS.validate_source_idv
2765: (
2766: p_intf_header_id => p_headers.interface_id,
2767: p_src_doc_id_tbl => p_headers.clm_source_document_id,
2768: p_currency_code_tbl => p_headers.currency_code,

Line 2774: PO_VAL_HEADERS.validate_award_admin

2770: x_results => x_results,
2771: x_result_type => l_result_type
2772: );
2773: WHEN c_validate_award_admin THEN
2774: PO_VAL_HEADERS.validate_award_admin
2775: (
2776: p_intf_header_id => p_headers.interface_id,
2777: p_award_admin_tbl => p_headers.clm_award_administrator,
2778: x_results => x_results,

Line 2782: PO_VAL_HEADERS.validate_contract_officer

2778: x_results => x_results,
2779: x_result_type => l_result_type
2780: );
2781: WHEN c_validate_contract_officer THEN
2782: PO_VAL_HEADERS.validate_contract_officer
2783: (
2784: p_intf_header_id => p_headers.interface_id,
2785: p_contract_officer_tbl => p_headers.clm_contract_officer,
2786: x_results => x_results,

Line 2790: PO_VAL_HEADERS.validate_umbrella_program_id

2786: x_results => x_results,
2787: x_result_type => l_result_type
2788: );
2789: WHEN c_validate_umbrella_program_id THEN
2790: PO_VAL_HEADERS.validate_umbrella_program_id
2791: (
2792: p_intf_header_id => p_headers.interface_id,
2793: p_umbrella_program_id_tbl => p_headers.umbrella_program_id,
2794: p_src_doc_id_tbl => p_headers.clm_source_document_id,

Line 2799: PO_VAL_HEADERS.validate_clm_award_type

2795: x_results => x_results,
2796: x_result_type => l_result_type
2797: );
2798: WHEN c_validate_clm_award_type THEN
2799: PO_VAL_HEADERS.validate_clm_award_type
2800: (
2801: p_intf_header_id => p_headers.interface_id,
2802: p_clm_award_type_tbl => p_headers.clm_award_type,
2803: p_type_lookup_code_tbl => p_headers.type_lookup_code,

Line 2808: PO_VAL_HEADERS.validate_style_id

2804: x_results => x_results,
2805: x_result_type => l_result_type
2806: );
2807: WHEN c_validate_style_id THEN
2808: PO_VAL_HEADERS.validate_style_id
2809: (
2810: p_intf_header_id => p_headers.interface_id,
2811: p_style_id_tbl => p_headers.style_id,
2812: x_results => x_results,

Line 2816: PO_VAL_HEADERS.validate_idv_style_id

2812: x_results => x_results,
2813: x_result_type => l_result_type
2814: );
2815: WHEN c_validate_idv_style_id THEN
2816: PO_VAL_HEADERS.validate_idv_style_id
2817: (
2818: p_intf_header_id => p_headers.interface_id,
2819: p_style_id_tbl => p_headers.style_id,
2820: p_clm_source_document_id_tbl => p_headers.clm_source_document_id,

Line 2825: PO_VAL_HEADERS.validate_po_idv_vendor_site_id

2821: x_results => x_results,
2822: x_result_type => l_result_type
2823: );
2824: WHEN c_val_po_idv_vendor_site_id THEN
2825: PO_VAL_HEADERS.validate_po_idv_vendor_site_id
2826: (
2827: p_intf_header_id => p_headers.interface_id,
2828: p_vendor_site_id_tbl => p_headers.vendor_site_id,
2829: p_clm_source_document_id_tbl => p_headers.clm_source_document_id,

Line 2834: PO_VAL_HEADERS.validate_po_idv_vendor_id

2830: x_results => x_results,
2831: x_result_type => l_result_type
2832: );
2833: WHEN c_validate_po_idv_vendor_id THEN
2834: PO_VAL_HEADERS.validate_po_idv_vendor_id
2835: (
2836: p_intf_header_id => p_headers.interface_id,
2837: p_vendor_id_tbl => p_headers.vendor_id,
2838: p_clm_source_document_id_tbl => p_headers.clm_source_document_id,