[Home] [Help]
2341: -- Line Validations
2342: ---------------------------------------------------------------
2343:
2344: WHEN c_amt_agreed_ge_zero THEN
2345: PO_VAL_LINES.amt_agreed_ge_zero(
2346: p_line_id_tbl => p_lines.po_line_id
2347: , p_committed_amount_tbl => p_lines.committed_amount
2348: , x_results => x_results
2349: , x_result_type => l_result_type
2349: , x_result_type => l_result_type
2350: );
2351:
2352: WHEN c_min_rel_amt_ge_zero THEN
2353: PO_VAL_LINES.min_rel_amt_ge_zero(
2354: p_line_id_tbl => p_lines.po_line_id
2355: , p_min_release_amount_tbl => p_lines.min_release_amount
2356: , x_results => x_results
2357: , x_result_type => l_result_type
2357: , x_result_type => l_result_type
2358: );
2359:
2360: WHEN c_line_qty_gt_zero THEN
2361: PO_VAL_LINES.quantity_gt_zero(
2362: p_line_id_tbl => p_lines.po_line_id
2363: , p_quantity_tbl => p_lines.quantity
2364: , p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code
2365: , x_results => x_results
2367: );
2368:
2369: --
2370: WHEN c_line_qty_ge_qty_exec THEN
2371: PO_VAL_LINES.quantity_ge_quantity_exec(
2372: p_line_id_tbl => p_lines.po_line_id
2373: , p_quantity_tbl => p_lines.quantity
2374: , x_result_set_id => l_result_set_id
2375: , x_result_type => l_result_type
2376: );
2377: --
2378:
2379: WHEN c_line_qty_ge_qty_enc THEN
2380: PO_VAL_LINES.quantity_ge_quantity_enc(
2381: p_line_id_tbl => p_lines.po_line_id
2382: , p_quantity_tbl => p_lines.quantity
2383: , x_result_set_id => l_result_set_id
2384: , x_result_type => l_result_type
2384: , x_result_type => l_result_type
2385: );
2386:
2387: WHEN c_quantity_notif_change THEN
2388: PO_VAL_LINES.quantity_notif_change(
2389: p_line_id_tbl => p_lines.po_line_id
2390: , p_quantity_tbl => p_lines.quantity
2391: , x_result_set_id => l_result_set_id
2392: , x_result_type => l_result_type
2392: , x_result_type => l_result_type
2393: );
2394:
2395: WHEN c_line_amt_gt_zero THEN
2396: PO_VAL_LINES.amount_gt_zero(
2397: p_line_id_tbl => p_lines.po_line_id
2398: , p_amount_tbl => p_lines.amount
2399: , p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code
2400: , x_results => x_results
2402: );
2403:
2404: --
2405: WHEN c_line_amt_ge_amt_exec THEN
2406: PO_VAL_LINES.amount_ge_amount_exec(
2407: p_line_id_tbl => p_lines.po_line_id
2408: , p_amount_tbl => p_lines.amount
2409: , p_currency_code_tbl => p_lines.hdr_currency_code
2410: , x_result_set_id => l_result_set_id
2412: );
2413: --
2414:
2415: WHEN c_line_amt_ge_timecard THEN
2416: PO_VAL_LINES.amount_ge_timecard(
2417: p_line_id_tbl => p_lines.po_line_id
2418: , p_amount_tbl => p_lines.amount
2419: , x_results => x_results
2420: , x_result_type => l_result_type
2420: , x_result_type => l_result_type
2421: );
2422:
2423: WHEN c_line_num_unique THEN
2424: PO_VAL_LINES.line_num_unique(
2425: p_line_id_tbl => p_lines.po_line_id
2426: , p_header_id_tbl => p_lines.po_header_id
2427: , p_line_num_tbl => p_lines.line_num
2428: , x_result_set_id => l_result_set_id
2429: , x_result_type => l_result_type
2430: );
2431:
2432: WHEN c_line_num_gt_zero THEN
2433: PO_VAL_LINES.line_num_gt_zero(
2434: p_line_id_tbl => p_lines.po_line_id
2435: , p_line_num_tbl => p_lines.line_num
2436: , x_results => x_results
2437: , x_result_type => l_result_type
2437: , x_result_type => l_result_type
2438: );
2439:
2440: WHEN c_vmi_asl_exists THEN
2441: PO_VAL_LINES.vmi_asl_exists(
2442: p_line_id_tbl => p_lines.po_line_id
2443: , p_type_lookup_code_tbl => p_lines.hdr_type_lookup_code
2444: , p_item_id_tbl => p_lines.item_id
2445: -- Bug# 4634769: Pass in the inventory org id
2450: , x_result_type => l_result_type
2451: );
2452:
2453: WHEN c_start_date_le_end_date THEN
2454: PO_VAL_LINES.start_date_le_end_date(
2455: p_line_id_tbl => p_lines.po_line_id
2456: , p_start_date_tbl => p_lines.start_date
2457: , p_expiration_date_tbl => p_lines.expiration_date
2458: , x_results => x_results
2459: , x_result_type => l_result_type
2460: );
2461:
2462: WHEN c_otl_inv_start_date_change THEN
2463: PO_VAL_LINES.otl_invalid_start_date_change(
2464: p_line_id_tbl => p_lines.po_line_id
2465: , p_start_date_tbl => p_lines.start_date
2466: , x_results => x_results
2467: , x_result_type => l_result_type
2467: , x_result_type => l_result_type
2468: );
2469:
2470: WHEN c_otl_inv_end_date_change THEN
2471: PO_VAL_LINES.otl_invalid_end_date_change(
2472: p_line_id_tbl => p_lines.po_line_id
2473: , p_expiration_date_tbl => p_lines.expiration_date
2474: , x_results => x_results
2475: , x_result_type => l_result_type
2475: , x_result_type => l_result_type
2476: );
2477:
2478: WHEN c_unit_price_ge_zero THEN
2479: PO_VAL_LINES.unit_price_ge_zero(
2480: p_line_id_tbl => p_lines.po_line_id
2481: , p_unit_price_tbl => p_lines.unit_price
2482: , p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code
2483: , x_results => x_results
2484: , x_result_type => l_result_type
2485: );
2486:
2487: WHEN c_list_price_ge_zero THEN
2488: PO_VAL_LINES.list_price_ge_zero(
2489: p_line_id_tbl => p_lines.po_line_id
2490: , p_list_price_per_unit_tbl => p_lines.list_price_per_unit
2491: , x_results => x_results
2492: , x_result_type => l_result_type
2492: , x_result_type => l_result_type
2493: );
2494:
2495: WHEN c_market_price_ge_zero THEN
2496: PO_VAL_LINES.market_price_ge_zero(
2497: p_line_id_tbl => p_lines.po_line_id
2498: , p_market_price_tbl => p_lines.market_price
2499: , x_results => x_results
2500: , x_result_type => l_result_type
2500: , x_result_type => l_result_type
2501: );
2502:
2503: WHEN c_validate_unit_price_change THEN
2504: PO_VAL_LINES.validate_unit_price_change(
2505: p_line_id_tbl => p_lines.po_line_id
2506: , p_unit_price_tbl => p_lines.unit_price
2507: , p_price_break_lookup_code_tbl => p_lines.price_break_lookup_code
2508: , x_result_set_id => l_result_set_id
2510: , x_result_type => l_result_type
2511: );
2512:
2513: WHEN c_expiration_ge_blanket_start THEN
2514: PO_VAL_LINES.expiration_ge_blanket_start(
2515: p_line_id_tbl => p_lines.po_line_id
2516: , p_blanket_start_date_tbl => p_lines.hdr_start_date
2517: , p_expiration_date_tbl => p_lines.expiration_date
2518: , x_results => x_results
2519: , x_result_type => l_result_type
2520: );
2521:
2522: WHEN c_expiration_le_blanket_end THEN
2523: PO_VAL_LINES.expiration_le_blanket_end(
2524: p_line_id_tbl => p_lines.po_line_id
2525: , p_blanket_end_date_tbl => p_lines.hdr_end_date
2526: , p_expiration_date_tbl => p_lines.expiration_date
2527: , x_results => x_results
2529: );
2530:
2531: --
2532: WHEN c_qty_ge_qty_milestone_exec THEN
2533: PO_VAL_LINES.qty_ge_qty_milestone_exec(
2534: p_line_id_tbl => p_lines.po_line_id
2535: , p_quantity_tbl => p_lines.quantity
2536: , x_result_set_id => l_result_set_id
2537: , x_result_type => l_result_type
2537: , x_result_type => l_result_type
2538: );
2539:
2540: WHEN c_price_ge_price_mstone_exec THEN
2541: PO_VAL_LINES.price_ge_price_milestone_exec(
2542: p_line_id_tbl => p_lines.po_line_id
2543: , p_price_tbl => p_lines.unit_price
2544: , x_result_set_id => l_result_set_id
2545: , x_result_type => l_result_type
2546: );
2547:
2548: -- Bug 5072189 START
2549: WHEN c_recoupment_rate_range_check THEN
2550: PO_VAL_LINES.recoupment_rate_range_check(
2551: p_line_id_tbl => p_lines.po_line_id
2552: , p_recoupment_rate_tbl => p_lines.recoupment_rate
2553: , x_results => x_results
2554: , x_result_type => l_result_type
2554: , x_result_type => l_result_type
2555: );
2556:
2557: WHEN c_retainage_rate_range_check THEN
2558: PO_VAL_LINES.retainage_rate_range_check(
2559: p_line_id_tbl => p_lines.po_line_id
2560: , p_retainage_rate_tbl => p_lines.retainage_rate
2561: , x_results => x_results
2562: , x_result_type => l_result_type
2562: , x_result_type => l_result_type
2563: );
2564:
2565: WHEN c_prog_pay_rate_range_check THEN
2566: PO_VAL_LINES.prog_pay_rate_range_check(
2567: p_line_id_tbl => p_lines.po_line_id
2568: , p_prog_pay_rate_tbl => p_lines.progress_payment_rate
2569: , x_results => x_results
2570: , x_result_type => l_result_type
2572: -- Bug 5072189 END
2573:
2574: -- Bug 5221843 START
2575: WHEN c_max_retain_amt_ge_zero THEN
2576: PO_VAL_LINES.max_retain_amt_ge_zero (
2577: p_line_id_tbl => p_lines.po_line_id
2578: , p_max_retain_amt_tbl => p_lines.max_retainage_amount
2579: , x_results => x_results
2580: , x_result_type => l_result_type
2582: -- Bug 5221843 END
2583:
2584: -- Bug 5453079 START
2585: WHEN c_max_retain_amt_ge_retained THEN
2586: PO_VAL_LINES.max_retain_amt_ge_retained (
2587: p_line_id_tbl => p_lines.po_line_id
2588: , p_max_retain_amt_tbl => p_lines.max_retainage_amount
2589: , x_result_set_id => l_result_set_id
2590: , x_result_type => l_result_type
2593:
2594: --
2595:
2596: WHEN c_unit_meas_not_null THEN
2597: PO_VAL_LINES.unit_meas_not_null(
2598: p_line_id_tbl => p_lines.po_line_id
2599: , p_unit_meas_lookup_code_tbl => p_lines.unit_meas_lookup_code
2600: , p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code
2601: , x_results => x_results
2602: , x_result_type => l_result_type
2603: );
2604:
2605: WHEN c_item_description_not_null THEN
2606: PO_VAL_LINES.item_description_not_null(
2607: p_line_id_tbl => p_lines.po_line_id
2608: , p_item_description_tbl => p_lines.item_description
2609: , x_results => x_results
2610: , x_result_type => l_result_type
2610: , x_result_type => l_result_type
2611: );
2612:
2613: WHEN c_category_id_not_null THEN
2614: PO_VAL_LINES.category_id_not_null(
2615: p_line_id_tbl => p_lines.po_line_id
2616: , p_category_id_tbl => p_lines.category_id
2617: , x_results => x_results
2618: , x_result_type => l_result_type
2619: );
2620:
2621: WHEN c_item_id_not_null THEN
2622: IF (p_calling_program = c_program_PDOI) THEN
2623: PO_VAL_LINES.item_id_not_null(
2624: p_id_tbl => p_lines.interface_id
2625: , p_item_id_tbl => p_lines.item_id
2626: , p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code
2627: , p_line_type_id_tbl => p_lines.line_type_id
2629: , x_result_set_id => l_result_set_id
2630: , x_result_type => l_result_type
2631: );
2632: ELSE
2633: PO_VAL_LINES.item_id_not_null(
2634: p_id_tbl => p_lines.po_line_id
2635: , p_item_id_tbl => p_lines.item_id
2636: , p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code
2637: , p_line_type_id_tbl => p_lines.line_type_id
2641: );
2642: END IF;
2643:
2644: WHEN c_temp_labor_job_id_not_null THEN
2645: PO_VAL_LINES.temp_labor_job_id_not_null(
2646: p_line_id_tbl => p_lines.po_line_id
2647: , p_job_id_tbl => p_lines.job_id
2648: , p_purchase_basis_tbl => p_lines.purchase_basis
2649: , x_results => x_results
2650: , x_result_type => l_result_type
2651: );
2652:
2653: WHEN c_line_type_id_not_null THEN
2654: PO_VAL_LINES.line_type_id_not_null(
2655: p_line_id_tbl => p_lines.po_line_id
2656: , p_line_type_id_tbl => p_lines.line_type_id
2657: , x_results => x_results
2658: , x_result_type => l_result_type
2658: , x_result_type => l_result_type
2659: );
2660:
2661: WHEN c_temp_lbr_start_date_not_null THEN
2662: PO_VAL_LINES.temp_lbr_start_date_not_null(
2663: p_line_id_tbl => p_lines.po_line_id
2664: , p_start_date_tbl => p_lines.start_date
2665: , p_purchase_basis_tbl => p_lines.purchase_basis
2666: , x_results => x_results
2667: , x_result_type => l_result_type
2668: );
2669:
2670: WHEN c_src_doc_line_not_null THEN
2671: PO_VAL_LINES.src_doc_line_not_null(
2672: p_line_id_tbl => p_lines.po_line_id
2673: , p_from_header_id_tbl => p_lines.from_header_id
2674: , p_from_line_id_tbl => p_lines.from_line_id
2675: , x_results => x_results
2677: );
2678:
2679: -- Opm related validation : OPM Integration R12 Start
2680: WHEN c_line_sec_qty_gt_zero THEN
2681: PO_VAL_LINES.line_sec_quantity_gt_zero(
2682: p_line_id_tbl => p_lines.po_line_id
2683: , p_item_id_tbl => p_lines.item_id
2684: , p_sec_quantity_tbl => p_lines.secondary_quantity
2685: , x_results => x_results
2686: , x_result_type => l_result_type
2687: );
2688:
2689: WHEN c_line_qtys_within_deviation THEN
2690: PO_VAL_LINES.line_qtys_within_deviation(
2691: p_line_id_tbl => p_lines.po_line_id
2692: , p_item_id_tbl => p_lines.item_id
2693: , p_quantity_tbl => p_lines.quantity
2694: , p_primary_uom_tbl => p_lines.unit_meas_lookup_code
2699: );
2700: -- Opm related validation : OPM Integration R12 End
2701:
2702: WHEN c_from_line_id_not_null THEN
2703: PO_VAL_LINES.from_line_id_not_null(
2704: p_line_id_tbl => p_lines.po_line_id
2705: , p_from_header_id_tbl => p_lines.from_header_id
2706: , p_from_line_id_tbl => p_lines.from_line_id
2707: , x_results => x_results
2709: );
2710:
2711: -- Bug 5070210 Start
2712: WHEN c_amt_ge_advance_amt THEN
2713: PO_VAL_LINES.advance_amt_le_amt(
2714: p_line_id_tbl => p_lines.po_line_id,
2715: p_advance_tbl => p_lines.advance_amount,
2716: p_amount_tbl => p_lines.amount,
2717: p_quantity_tbl => p_lines.quantity,
2753: WHEN c_over_tolerance_error_flag THEN
2754: -- The lookup code specified in over_tolerance_error_flag with the lookup type
2755: -- 'RECEIVING CONTROL LEVEL' has to exist in po_lookup_codes and still active.
2756: -- This method is called only for Standard PO and quotation documents
2757: PO_VAL_LINES2.over_tolerance_err_flag(p_id_tbl => p_lines.interface_id,
2758: p_over_tolerance_err_flag_tbl => p_lines.over_tolerance_error_flag,
2759: x_result_set_id => l_result_set_id,
2760: x_result_type => l_result_type);
2761: WHEN c_expiration_date_blanket THEN
2759: x_result_set_id => l_result_set_id,
2760: x_result_type => l_result_type);
2761: WHEN c_expiration_date_blanket THEN
2762: -- Expiration date on the line cannot be earlier than the header effective start date and cannot be later than header effective end date
2763: PO_VAL_LINES2.expiration_date_blanket(p_id_tbl => p_lines.interface_id,
2764: p_expiration_date_tbl => p_lines.expiration_date,
2765: p_header_start_date_tbl => p_lines.hdr_start_date,
2766: p_header_end_date_tbl => p_lines.hdr_end_date,
2767: x_results => x_results,
2768: x_result_type => l_result_type);
2769: WHEN c_global_agreement_flag THEN
2770: -- For blanket document with purchase type 'TEMP LABOR', the global agreement
2771: -- flag has to be 'Y'. Global_agreement_flag and outside operation flag cannot both be 'Y'
2772: PO_VAL_LINES2.global_agreement_flag(p_id_tbl => p_lines.interface_id,
2773: p_global_agreement_flag_tbl => p_lines.global_agreement_flag,
2774: p_purchase_basis_tbl => p_lines.purchase_basis,
2775: p_line_type_id_tbl => p_lines.line_type_id,
2776: x_result_set_id => l_result_set_id,
2777: x_results => x_results,
2778: x_result_type => l_result_type);
2779: WHEN c_amount_blanket THEN
2780: -- If order_type_lookup_code is 'RATE', amount has to be null
2781: PO_VAL_LINES2.amount_blanket(p_id_tbl => p_lines.interface_id,
2782: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2783: p_amount_tbl => p_lines.amount,
2784: x_results => x_results,
2785: x_result_type => l_result_type);
2785: x_result_type => l_result_type);
2786: WHEN c_order_type_lookup_code THEN
2787: -- If services procurement is not enabled, the order_type_lookup_code cannot
2788: -- be 'FIXED PRICE' or 'RATE'.
2789: PO_VAL_LINES2.order_type_lookup_code(p_id_tbl => p_lines.interface_id,
2790: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2791: x_results => x_results,
2792: x_result_type => l_result_type);
2793: WHEN c_contractor_name THEN
2792: x_result_type => l_result_type);
2793: WHEN c_contractor_name THEN
2794: -- If purchase basis is not 'TEMP LABOR' or document type is not STANDARD,
2795: -- contractor first name and last name fields should be empty
2796: PO_VAL_LINES2.contractor_name(p_id_tbl => p_lines.interface_id,
2797: p_doc_type => l_doc_type,
2798: p_purchase_basis_tbl => p_lines.purchase_basis,
2799: p_contractor_last_name_tbl => p_lines.contractor_last_name,
2800: p_contractor_first_name_tbl => p_lines.contractor_first_name,
2801: x_results => x_results,
2802: x_result_type => l_result_type);
2803: WHEN c_job_id THEN
2804: -- If purchase basis is TEMP LABOR, then job id must be null
2805: PO_VAL_LINES2.job_id(p_id_tbl => p_lines.interface_id,
2806: p_job_id_tbl => p_lines.job_id,
2807: p_job_business_group_id_tbl => p_lines.job_business_group_id,
2808: p_purchase_basis_tbl => p_lines.purchase_basis,
2809: p_category_id_tbl => p_lines.category_id,
2812: x_result_type => l_result_type);
2813: WHEN c_job_business_group_id THEN
2814: -- If services procurement not enabled, order_type_lookup_code cannot be
2815: -- 'FIXED PRICE' or 'RATE'
2816: PO_VAL_LINES2.job_business_group_id(p_id_tbl => p_lines.interface_id,
2817: p_job_id_tbl => p_lines.job_id,
2818: p_job_business_group_id_tbl => p_lines.job_business_group_id,
2819: p_purchase_basis_tbl => p_lines.purchase_basis,
2820: x_result_set_id => l_result_set_id,
2820: x_result_set_id => l_result_set_id,
2821: x_result_type => l_result_type);
2822: WHEN c_capital_expense_flag THEN
2823: -- If purchase_basis = 'TEMP LABOR', then capital_expense_flag cannot = 'Y'
2824: PO_VAL_LINES2.capital_expense_flag(p_id_tbl => p_lines.interface_id,
2825: p_purchase_basis_tbl => p_lines.purchase_basis,
2826: p_capital_expense_flag_tbl => p_lines.capital_expense_flag,
2827: x_results => x_results,
2828: x_result_type => l_result_type);
2827: x_results => x_results,
2828: x_result_type => l_result_type);
2829: WHEN c_un_number_id THEN
2830: -- If purchase_basis = 'TEMP LABOR', then un_number must be null
2831: PO_VAL_LINES2.un_number_id(p_id_tbl => p_lines.interface_id,
2832: p_purchase_basis_tbl => p_lines.purchase_basis,
2833: p_un_number_id_tbl => p_lines.un_number_id,
2834: x_result_set_id => l_result_set_id,
2835: x_results => x_results,
2835: x_results => x_results,
2836: x_result_type => l_result_type);
2837: WHEN c_hazard_class_id THEN
2838: -- If purchase_basis = 'TEMP LABOR', then un_number must be null
2839: PO_VAL_LINES2.hazard_class_id(p_id_tbl => p_lines.interface_id,
2840: p_purchase_basis_tbl => p_lines.purchase_basis,
2841: p_hazard_class_id_tbl => p_lines.hazard_class_id,
2842: x_result_set_id => l_result_set_id,
2843: x_results => x_results,
2843: x_results => x_results,
2844: x_result_type => l_result_type);
2845: WHEN c_item_id THEN
2846: -- If order_type_lookup_code is 'FIXED PRICE', 'RATE', or 'AMOUNT', item_id has to be null
2847: PO_VAL_LINES2.item_id(p_id_tbl => p_lines.interface_id,
2848: p_item_id_tbl => p_lines.item_id,
2849: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2850: p_line_type_id_tbl => p_lines.line_type_id,
2851: p_inventory_org_id => l_inventory_org_id,
2855: WHEN c_item_description THEN
2856: -- Make sure that the item_description is populated, and also need to find out if it is different from
2857: -- what is setup for the item. Would not allow item_description update if item attribute
2858: -- allow_item_desc_update_flag is N.
2859: PO_VAL_LINES2.item_description(p_id_tbl => p_lines.interface_id,
2860: p_item_description_tbl => p_lines.item_description,
2861: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2862: p_item_id_tbl => p_lines.item_id,
2863: p_create_or_update_item => l_create_or_update_item,
2865: x_result_set_id => l_result_set_id,
2866: x_result_type => l_result_type);
2867: WHEN c_unit_meas_lookup_code THEN
2868: -- check to see if x_item_unit_of_measure is valid
2869: PO_VAL_LINES2.unit_meas_lookup_code(p_id_tbl => p_lines.interface_id,
2870: p_unit_meas_lookup_code_tbl => p_lines.unit_meas_lookup_code,
2871: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2872: p_item_id_tbl => p_lines.item_id,
2873: p_line_type_id_tbl => p_lines.line_type_id,
2877: x_result_type => l_result_type);
2878: WHEN c_item_revision THEN
2879: -- if order_type_lookup_code is FIXED PRICE or RATE, or item id is null, then item revision has to
2880: -- be NULL. Check to see if there are x_item_revision exists in mtl_item_revisions table
2881: PO_VAL_LINES2.item_revision(p_id_tbl => p_lines.interface_id,
2882: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2883: p_item_revision_tbl => p_lines.item_revision,
2884: p_item_id_tbl => p_lines.item_id,
2885: x_result_set_id => l_result_set_id,
2889: -- Validate and make sure category_id is a valid category within the default category set for Purchasing.
2890: -- Validate if X_category_id belong to the X_item. Check if the Purchasing Category set has
2891: -- 'Validate flag' ON. If Yes, we will validate the Category to exist in the 'Valid Category List'.
2892: -- If No, we will just validate if the category is Enable and Active.
2893: PO_VAL_LINES2.category_id(p_id_tbl => p_lines.interface_id,
2894: p_category_id_tbl => p_lines.category_id,
2895: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2896: p_item_id_tbl => p_lines.item_id,
2897: p_inventory_org_id => l_inventory_org_id,
2900: x_result_type => l_result_type);
2901: WHEN c_ip_category_id THEN
2902: -- Validate ip_category_id is not empty
2903: -- Validate ip_category_id is valid if not empty.
2904: PO_VAL_LINES2.ip_category_id(p_id_tbl => p_lines.interface_id,
2905: p_ip_category_id_tbl => p_lines.ip_category_id,
2906: x_result_set_id => l_result_set_id,
2907: x_results => x_results,
2908: x_result_type => l_result_type);
2909: WHEN c_unit_price THEN
2910: --If order_type_lookup_code is not 'FIXED PRICE', unit_price cannot be null and cannot be less than zero.
2911: --If line_type_id is not null and order_type_lookup_code is 'AMOUNT', unit_price should be the same as the one defined in the line_type.
2912: --If order_type_lookup_code is 'FIXED PRICE', unit_price has to be null.
2913: PO_VAL_LINES2.unit_price(p_id_tbl => p_lines.interface_id,
2914: p_unit_price_tbl => p_lines.unit_price,
2915: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2916: p_line_type_id_tbl => p_lines.line_type_id,
2917: x_result_set_id => l_result_set_id,
2919: x_result_type => l_result_type);
2920: WHEN c_quantity THEN
2921: -- If order_type_lookup_code is not 'FIXED PRICE' or 'RATE', quantity cannot be less than zero
2922: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', quantity has to be null.
2923: PO_VAL_LINES2.quantity(p_id_tbl => p_lines.interface_id,
2924: p_quantity_tbl => p_lines.quantity,
2925: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2926: x_results => x_results,
2927: x_result_type => l_result_type);
2926: x_results => x_results,
2927: x_result_type => l_result_type);
2928: WHEN c_amount THEN
2929: -- If order_type_lookup_code is not 'FIXED PRICE' or 'RATE', amount has to be null
2930: PO_VAL_LINES2.amount(p_id_tbl => p_lines.interface_id,
2931: p_amount_tbl => p_lines.amount,
2932: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2933: x_results => x_results,
2934: x_result_type => l_result_type);
2933: x_results => x_results,
2934: x_result_type => l_result_type);
2935: WHEN c_rate_type THEN
2936: -- For rate based temp labor line, the currency rate_type cannot be 'user'
2937: PO_VAL_LINES2.rate_type(p_id_tbl => p_lines.interface_id,
2938: p_rate_type_tbl => p_lines.hdr_rate_type,
2939: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2940: x_results => x_results,
2941: x_result_type => l_result_type);
2941: x_result_type => l_result_type);
2942: WHEN c_line_num THEN
2943: -- Line num must be populated and cannot be <= 0.
2944: -- Line num has to be unique in a requisition.
2945: PO_VAL_LINES2.line_num(p_id_tbl => p_lines.interface_id,
2946: p_po_header_id_tbl => p_lines.po_header_id,
2947: p_line_num_tbl => p_lines.line_num,
2948: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2949: p_draft_id_tbl => p_lines.draft_id, -- bug5129752
2951: x_results => x_results,
2952: x_result_type => l_result_type);
2953: WHEN c_po_line_id THEN
2954: -- Po_line_id must be populated and unique.
2955: PO_VAL_LINES2.po_line_id(p_id_tbl => p_lines.interface_id,
2956: p_po_line_id_tbl => p_lines.po_line_id,
2957: p_po_header_id_tbl => p_lines.po_header_id,
2958: x_result_set_id => l_result_set_id,
2959: x_result_type => l_result_type);
2958: x_result_set_id => l_result_set_id,
2959: x_result_type => l_result_type);
2960: WHEN c_line_type_id THEN
2961: -- Line type id must be populated and exist in po_line_types_val_v
2962: PO_VAL_LINES2.line_type_id(p_id_tbl => p_lines.interface_id,
2963: p_line_type_id_tbl => p_lines.line_type_id,
2964: x_result_set_id => l_result_set_id,
2965: x_result_type => l_result_type);
2966: WHEN c_line_style_related_info THEN
2963: p_line_type_id_tbl => p_lines.line_type_id,
2964: x_result_set_id => l_result_set_id,
2965: x_result_type => l_result_type);
2966: WHEN c_line_style_related_info THEN
2967: PO_VAL_LINES2.style_related_info(p_id_tbl => p_lines.interface_id,
2968: p_style_id_tbl => p_lines.hdr_style_id,
2969: p_line_type_id_tbl => p_lines.line_type_id,
2970: p_purchase_basis_tbl => p_lines.purchase_basis,
2971: x_result_set_id => l_result_set_id,
2971: x_result_set_id => l_result_set_id,
2972: x_result_type => l_result_type);
2973: WHEN c_price_type_lookup_code THEN
2974: -- If price_type_lookup_code is not null, it has to be a valid price type in po_lookup_codes
2975: PO_VAL_LINES2.price_type_lookup_code(p_id_tbl => p_lines.interface_id,
2976: p_price_type_lookup_code_tbl => p_lines.price_type_lookup_code,
2977: x_result_set_id => l_result_set_id,
2978: x_result_type => l_result_type);
2979: WHEN c_start_date_standard THEN
2979: WHEN c_start_date_standard THEN
2980: -- Start date is required for Standard PO with purchase basis 'TEMP LABOR'
2981: -- Expiration date if provided should be later than the start date
2982: -- If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
2983: PO_VAL_LINES2.start_date_standard(p_id_tbl => p_lines.interface_id,
2984: p_start_date_tbl => p_lines.start_date,
2985: p_expiration_date_tbl => p_lines.expiration_date,
2986: p_purchase_basis_tbl => p_lines.purchase_basis,
2987: x_results => x_results,
2987: x_results => x_results,
2988: x_result_type => l_result_type);
2989: WHEN c_item_id_standard THEN
2990: -- If order_type_lookup_code is not 'RATE' or 'FIXED PRICE', and item_id is not null, then bom_item_type cannot be 1 or 2.
2991: PO_VAL_LINES2.item_id_standard(p_id_tbl => p_lines.interface_id,
2992: p_item_id_tbl => p_lines.item_id,
2993: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
2994: p_inventory_org_id => l_inventory_org_id,
2995: x_result_set_id => l_result_set_id,
2996: x_result_type => l_result_type);
2997: WHEN c_quantity_standard THEN
2998: -- Quantity cannot be zero for SPO
2999: -- And qiantity cannot be empty for SPO if order type is QUANTITY/AMOUNT
3000: PO_VAL_LINES2.quantity_standard(p_id_tbl => p_lines.interface_id,
3001: p_quantity_tbl => p_lines.quantity,
3002: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3003: x_results => x_results,
3004: x_result_type => l_result_type);
3003: x_results => x_results,
3004: x_result_type => l_result_type);
3005: WHEN c_amount_standard THEN
3006: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', amount cannot be null
3007: PO_VAL_LINES2.amount_standard(p_id_tbl => p_lines.interface_id,
3008: p_amount_tbl => p_lines.amount,
3009: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3010: x_results => x_results,
3011: x_result_type => l_result_type);
3010: x_results => x_results,
3011: x_result_type => l_result_type);
3012: WHEN c_price_break_lookup_code THEN
3013: -- bug5016163
3014: PO_VAL_LINES2.price_break_lookup_code(p_id_tbl => p_lines.interface_id,
3015: p_price_break_lookup_code_tbl => p_lines.price_break_lookup_code,
3016: p_global_agreement_flag_tbl => p_lines.global_agreement_flag,
3017: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3018: p_purchase_basis_tbl => p_lines.purchase_basis,
3021: x_result_type => l_result_type);
3022: WHEN c_not_to_exceed_price THEN
3023: -- If allow_price_override_flag is 'N', then not_to_exceed_price has to be null.
3024: -- If not_to_exceed_price is not null, then it cannot be less than unit_price.
3025: PO_VAL_LINES2.not_to_exceed_price(p_id_tbl => p_lines.interface_id,
3026: p_not_to_exceed_price_tbl => p_lines.not_to_exceed_price,
3027: p_allow_price_override_tbl => p_lines.allow_price_override_flag,
3028: p_unit_price_tbl => p_lines.unit_price,
3029: x_results => x_results,
3030: x_result_type => l_result_type);
3031: WHEN c_uom_update THEN
3032: -- validate unit_meas_lookup_code against po_lines_all and po_units_of_measure_val_v
3033: -- for the Update case
3034: PO_VAL_LINES2.uom_update(p_id_tbl => p_lines.interface_id,
3035: p_unit_meas_lookup_code_tbl => p_lines.unit_meas_lookup_code,
3036: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3037: p_po_header_id_tbl => p_lines.po_header_id,
3038: p_po_line_id_tbl => p_lines.po_line_id,
3040: x_result_set_id => l_result_set_id,
3041: x_result_type => l_result_type);
3042: WHEN c_unit_price_update THEN
3043: -- In the UPDATE case, unit_price cannot be negative. Also handle #DEL.
3044: PO_VAL_LINES2.unit_price_update
3045: ( p_id_tbl => p_lines.interface_id,
3046: p_po_line_id_tbl => p_lines.po_line_id, -- bug5008206
3047: p_draft_id_tbl => p_lines.draft_id, -- bug5258790
3048: p_unit_price_tbl => p_lines.unit_price,
3052: );
3053:
3054: WHEN c_amount_update THEN
3055: -- In the UPDATE case, unit_price cannot be negative. Also handle #DEL.
3056: PO_VAL_LINES2.amount_update
3057: ( p_id_tbl => p_lines.interface_id,
3058: p_po_line_id_tbl => p_lines.po_line_id, -- bug5008206
3059: p_draft_id_tbl => p_lines.draft_id, -- bug5258790
3060: p_amount_tbl => p_lines.amount,
3063: x_result_type => l_result_type
3064: );
3065:
3066: WHEN c_item_desc_update THEN
3067: PO_VAL_LINES2.item_desc_update(p_id_tbl => p_lines.interface_id,
3068: p_item_description_tbl => p_lines.item_description,
3069: p_item_id_tbl => p_lines.item_id,
3070: p_inventory_org_id => l_inventory_org_id,
3071: p_po_header_id_tbl => p_lines.po_header_id,
3074: x_result_set_id => l_result_set_id,
3075: x_result_type => l_result_type);
3076: WHEN c_ip_category_id_update THEN
3077: -- Validate ip_category_id is valid if not empty.
3078: PO_VAL_LINES2.ip_category_id_update(p_id_tbl => p_lines.interface_id,
3079: p_ip_category_id_tbl => p_lines.ip_category_id,
3080: x_result_set_id => l_result_set_id,
3081: x_results => x_results,
3082: x_result_type => l_result_type);
3083: WHEN c_negotiated_by_preparer THEN
3084: ----------------------------------------------------------------------------------------
3085: -- Called in create case for Blanket AND SPO, negotiated_by_preparer must be 'Y' or 'N'.
3086: ----------------------------------------------------------------------------------------
3087: PO_VAL_LINES2.negotiated_by_preparer(p_id_tbl => p_lines.interface_id,
3088: p_negotiated_by_preparer_tbl => p_lines.negotiated_by_preparer_flag,
3089: x_results => x_results,
3090: x_result_type => l_result_type);
3091: WHEN c_negotiated_by_prep_update THEN
3091: WHEN c_negotiated_by_prep_update THEN
3092: --------------------------------------------------------------------------------------
3093: -- Called in update case for Blanket, negotiated_by_preparer must be NULL, 'Y' or 'N'.
3094: --------------------------------------------------------------------------------------
3095: PO_VAL_LINES2.negotiated_by_prep_update(p_id_tbl => p_lines.interface_id,
3096: p_negotiated_by_preparer_tbl => p_lines.negotiated_by_preparer_flag,
3097: x_results => x_results,
3098: x_result_type => l_result_type);
3099: WHEN c_category_id_update THEN
3100: -------------------------------------------------------------------------
3101: -- If either item_id or job_id are populated, then you are not allowed to change the po_category_id
3102: -- If change is allowed, the new category_id must be valid.
3103: -------------------------------------------------------------------------
3104: PO_VAL_LINES2.category_id_update(p_id_tbl => p_lines.interface_id,
3105: p_category_id_tbl => p_lines.category_id,
3106: p_po_line_id_tbl => p_lines.po_line_id,
3107: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3108: p_item_id_tbl => p_lines.item_id,