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_HEADERS2

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