[Home] [Help]
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,