[Home] [Help]
2873: );
2874:
2875: -- bug 8633959 start
2876: WHEN c_validate_category THEN
2877: PO_VAL_LINES2.category_combination_valid(
2878: p_po_line_id_tbl => p_lines.po_line_id
2879: , p_category_id_tbl => p_lines.category_id
2880: , p_clm_info_flag_tbl => p_lines.clm_info_flag --Bug 12768893
2881: , x_results => x_results
3528: WHEN c_over_tolerance_error_flag THEN
3529: -- The lookup code specified in over_tolerance_error_flag with the lookup type
3530: -- 'RECEIVING CONTROL LEVEL' has to exist in po_lookup_codes and still active.
3531: -- This method is called only for Standard PO and quotation documents
3532: PO_VAL_LINES2.over_tolerance_err_flag(p_id_tbl => p_lines.interface_id,
3533: p_over_tolerance_err_flag_tbl => p_lines.over_tolerance_error_flag,
3534: x_result_set_id => l_result_set_id,
3535: x_result_type => l_result_type);
3536: WHEN c_expiration_date_blanket THEN
3534: x_result_set_id => l_result_set_id,
3535: x_result_type => l_result_type);
3536: WHEN c_expiration_date_blanket THEN
3537: -- Expiration date on the line cannot be earlier than the header effective start date and cannot be later than header effective end date
3538: PO_VAL_LINES2.expiration_date_blanket(p_id_tbl => p_lines.interface_id,
3539: p_expiration_date_tbl => p_lines.expiration_date,
3540: p_header_start_date_tbl => p_lines.hdr_start_date,
3541: p_header_end_date_tbl => p_lines.hdr_end_date,
3542: x_results => x_results,
3543: x_result_type => l_result_type);
3544: WHEN c_global_agreement_flag THEN
3545: -- For blanket document with purchase type 'TEMP LABOR', the global agreement
3546: -- flag has to be 'Y'. Global_agreement_flag and outside operation flag cannot both be 'Y'
3547: PO_VAL_LINES2.global_agreement_flag(p_id_tbl => p_lines.interface_id,
3548: p_global_agreement_flag_tbl => p_lines.global_agreement_flag,
3549: p_purchase_basis_tbl => p_lines.purchase_basis,
3550: p_line_type_id_tbl => p_lines.line_type_id,
3551: x_result_set_id => l_result_set_id,
3552: x_results => x_results,
3553: x_result_type => l_result_type);
3554: WHEN c_amount_blanket THEN
3555: -- If order_type_lookup_code is 'RATE', amount has to be null
3556: PO_VAL_LINES2.amount_blanket(p_id_tbl => p_lines.interface_id,
3557: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3558: p_amount_tbl => p_lines.amount,
3559: x_results => x_results,
3560: x_result_type => l_result_type);
3560: x_result_type => l_result_type);
3561: WHEN c_order_type_lookup_code THEN
3562: -- If services procurement is not enabled, the order_type_lookup_code cannot
3563: -- be 'FIXED PRICE' or 'RATE'.
3564: PO_VAL_LINES2.order_type_lookup_code(p_id_tbl => p_lines.interface_id,
3565: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3566: x_results => x_results,
3567: x_result_type => l_result_type);
3568: WHEN c_contractor_name THEN
3567: x_result_type => l_result_type);
3568: WHEN c_contractor_name THEN
3569: -- If purchase basis is not 'TEMP LABOR' or document type is not STANDARD,
3570: -- contractor first name and last name fields should be empty
3571: PO_VAL_LINES2.contractor_name(p_id_tbl => p_lines.interface_id,
3572: p_doc_type => l_doc_type,
3573: p_purchase_basis_tbl => p_lines.purchase_basis,
3574: p_contractor_last_name_tbl => p_lines.contractor_last_name,
3575: p_contractor_first_name_tbl => p_lines.contractor_first_name,
3576: x_results => x_results,
3577: x_result_type => l_result_type);
3578: WHEN c_job_id THEN
3579: -- If purchase basis is TEMP LABOR, then job id must be null
3580: PO_VAL_LINES2.job_id(p_id_tbl => p_lines.interface_id,
3581: p_job_id_tbl => p_lines.job_id,
3582: p_job_business_group_id_tbl => p_lines.job_business_group_id,
3583: p_purchase_basis_tbl => p_lines.purchase_basis,
3584: p_category_id_tbl => p_lines.category_id,
3587: x_result_type => l_result_type);
3588: WHEN c_job_business_group_id THEN
3589: -- If services procurement not enabled, order_type_lookup_code cannot be
3590: -- 'FIXED PRICE' or 'RATE'
3591: PO_VAL_LINES2.job_business_group_id(p_id_tbl => p_lines.interface_id,
3592: p_job_id_tbl => p_lines.job_id,
3593: p_job_business_group_id_tbl => p_lines.job_business_group_id,
3594: p_purchase_basis_tbl => p_lines.purchase_basis,
3595: x_result_set_id => l_result_set_id,
3595: x_result_set_id => l_result_set_id,
3596: x_result_type => l_result_type);
3597: WHEN c_capital_expense_flag THEN
3598: -- If purchase_basis = 'TEMP LABOR', then capital_expense_flag cannot = 'Y'
3599: PO_VAL_LINES2.capital_expense_flag(p_id_tbl => p_lines.interface_id,
3600: p_purchase_basis_tbl => p_lines.purchase_basis,
3601: p_capital_expense_flag_tbl => p_lines.capital_expense_flag,
3602: x_results => x_results,
3603: x_result_type => l_result_type);
3602: x_results => x_results,
3603: x_result_type => l_result_type);
3604: WHEN c_un_number_id THEN
3605: -- If purchase_basis = 'TEMP LABOR', then un_number must be null
3606: PO_VAL_LINES2.un_number_id(p_id_tbl => p_lines.interface_id,
3607: p_purchase_basis_tbl => p_lines.purchase_basis,
3608: p_un_number_id_tbl => p_lines.un_number_id,
3609: x_result_set_id => l_result_set_id,
3610: x_results => x_results,
3610: x_results => x_results,
3611: x_result_type => l_result_type);
3612: WHEN c_hazard_class_id THEN
3613: -- If purchase_basis = 'TEMP LABOR', then un_number must be null
3614: PO_VAL_LINES2.hazard_class_id(p_id_tbl => p_lines.interface_id,
3615: p_purchase_basis_tbl => p_lines.purchase_basis,
3616: p_hazard_class_id_tbl => p_lines.hazard_class_id,
3617: x_result_set_id => l_result_set_id,
3618: x_results => x_results,
3618: x_results => x_results,
3619: x_result_type => l_result_type);
3620: WHEN c_item_id THEN
3621: -- If order_type_lookup_code is 'FIXED PRICE', 'RATE', or 'AMOUNT', item_id has to be null
3622: PO_VAL_LINES2.item_id(p_id_tbl => p_lines.interface_id,
3623: p_item_id_tbl => p_lines.item_id,
3624: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3625: p_line_type_id_tbl => p_lines.line_type_id,
3626: p_inventory_org_id => l_inventory_org_id,
3630: WHEN c_item_description THEN
3631: -- Make sure that the item_description is populated, and also need to find out if it is different from
3632: -- what is setup for the item. Would not allow item_description update if item attribute
3633: -- allow_item_desc_update_flag is N.
3634: PO_VAL_LINES2.item_description(p_id_tbl => p_lines.interface_id,
3635: p_item_description_tbl => p_lines.item_description,
3636: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3637: p_item_id_tbl => p_lines.item_id,
3638: p_create_or_update_item => l_create_or_update_item,
3640: x_result_set_id => l_result_set_id,
3641: x_result_type => l_result_type);
3642: WHEN c_unit_meas_lookup_code THEN
3643: -- check to see if x_item_unit_of_measure is valid
3644: PO_VAL_LINES2.unit_meas_lookup_code(p_id_tbl => p_lines.interface_id,
3645: p_unit_meas_lookup_code_tbl => p_lines.unit_meas_lookup_code,
3646: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3647: p_item_id_tbl => p_lines.item_id,
3648: p_line_type_id_tbl => p_lines.line_type_id,
3652: x_result_type => l_result_type);
3653: WHEN c_item_revision THEN
3654: -- if order_type_lookup_code is FIXED PRICE or RATE, or item id is null, then item revision has to
3655: -- be NULL. Check to see if there are x_item_revision exists in mtl_item_revisions table
3656: PO_VAL_LINES2.item_revision(p_id_tbl => p_lines.interface_id,
3657: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3658: p_item_revision_tbl => p_lines.item_revision,
3659: p_item_id_tbl => p_lines.item_id,
3660: x_result_set_id => l_result_set_id,
3664: -- Validate and make sure category_id is a valid category within the default category set for Purchasing.
3665: -- Validate if X_category_id belong to the X_item. Check if the Purchasing Category set has
3666: -- 'Validate flag' ON. If Yes, we will validate the Category to exist in the 'Valid Category List'.
3667: -- If No, we will just validate if the category is Enable and Active.
3668: PO_VAL_LINES2.category_id(p_id_tbl => p_lines.interface_id,
3669: p_category_id_tbl => p_lines.category_id,
3670: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3671: p_item_id_tbl => p_lines.item_id,
3672: p_inventory_org_id => l_inventory_org_id,
3675: x_result_type => l_result_type);
3676: WHEN c_ip_category_id THEN
3677: -- Validate ip_category_id is not empty
3678: -- Validate ip_category_id is valid if not empty.
3679: PO_VAL_LINES2.ip_category_id(p_id_tbl => p_lines.interface_id,
3680: p_ip_category_id_tbl => p_lines.ip_category_id,
3681: x_result_set_id => l_result_set_id,
3682: x_results => x_results,
3683: x_result_type => l_result_type);
3684: WHEN c_unit_price THEN
3685: --If order_type_lookup_code is not 'FIXED PRICE', unit_price cannot be null and cannot be less than zero.
3686: --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.
3687: --If order_type_lookup_code is 'FIXED PRICE', unit_price has to be null.
3688: PO_VAL_LINES2.unit_price(p_id_tbl => p_lines.interface_id,
3689: p_unit_price_tbl => p_lines.unit_price,
3690: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3691: p_line_type_id_tbl => p_lines.line_type_id,
3692: x_result_set_id => l_result_set_id,
3694: x_result_type => l_result_type);
3695: WHEN c_quantity THEN
3696: -- If order_type_lookup_code is not 'FIXED PRICE' or 'RATE', quantity cannot be less than zero
3697: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', quantity has to be null.
3698: PO_VAL_LINES2.quantity(p_id_tbl => p_lines.interface_id,
3699: p_quantity_tbl => p_lines.quantity,
3700: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3701: x_results => x_results,
3702: x_result_type => l_result_type);
3701: x_results => x_results,
3702: x_result_type => l_result_type);
3703: WHEN c_amount THEN
3704: -- If order_type_lookup_code is not 'FIXED PRICE' or 'RATE', amount has to be null
3705: PO_VAL_LINES2.amount(p_id_tbl => p_lines.interface_id,
3706: p_amount_tbl => p_lines.amount,
3707: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3708: x_results => x_results,
3709: x_result_type => l_result_type);
3708: x_results => x_results,
3709: x_result_type => l_result_type);
3710: WHEN c_rate_type THEN
3711: -- For rate based temp labor line, the currency rate_type cannot be 'user'
3712: PO_VAL_LINES2.rate_type(p_id_tbl => p_lines.interface_id,
3713: p_rate_type_tbl => p_lines.hdr_rate_type,
3714: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3715: x_results => x_results,
3716: x_result_type => l_result_type);
3716: x_result_type => l_result_type);
3717: WHEN c_line_num THEN
3718: -- Line num must be populated and cannot be <= 0.
3719: -- Line num has to be unique in a requisition.
3720: PO_VAL_LINES2.line_num(p_id_tbl => p_lines.interface_id,
3721: p_po_header_id_tbl => p_lines.po_header_id,
3722: p_line_num_tbl => p_lines.line_num,
3723: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3724: p_draft_id_tbl => p_lines.draft_id, -- bug5129752
3726: x_results => x_results,
3727: x_result_type => l_result_type);
3728: WHEN c_po_line_id THEN
3729: -- Po_line_id must be populated and unique.
3730: PO_VAL_LINES2.po_line_id(p_id_tbl => p_lines.interface_id,
3731: p_po_line_id_tbl => p_lines.po_line_id,
3732: p_po_header_id_tbl => p_lines.po_header_id,
3733: x_result_set_id => l_result_set_id,
3734: x_result_type => l_result_type);
3733: x_result_set_id => l_result_set_id,
3734: x_result_type => l_result_type);
3735: WHEN c_line_type_id THEN
3736: -- Line type id must be populated and exist in po_line_types_val_v
3737: PO_VAL_LINES2.line_type_id(p_id_tbl => p_lines.interface_id,
3738: p_line_type_id_tbl => p_lines.line_type_id,
3739: x_result_set_id => l_result_set_id,
3740: x_result_type => l_result_type);
3741: WHEN c_line_style_related_info THEN
3738: p_line_type_id_tbl => p_lines.line_type_id,
3739: x_result_set_id => l_result_set_id,
3740: x_result_type => l_result_type);
3741: WHEN c_line_style_related_info THEN
3742: PO_VAL_LINES2.style_related_info(p_id_tbl => p_lines.interface_id,
3743: p_style_id_tbl => p_lines.hdr_style_id,
3744: p_line_type_id_tbl => p_lines.line_type_id,
3745: p_purchase_basis_tbl => p_lines.purchase_basis,
3746: x_result_set_id => l_result_set_id,
3746: x_result_set_id => l_result_set_id,
3747: x_result_type => l_result_type);
3748: WHEN c_price_type_lookup_code THEN
3749: -- If price_type_lookup_code is not null, it has to be a valid price type in po_lookup_codes
3750: PO_VAL_LINES2.price_type_lookup_code(p_id_tbl => p_lines.interface_id,
3751: p_price_type_lookup_code_tbl => p_lines.price_type_lookup_code,
3752: x_result_set_id => l_result_set_id,
3753: x_result_type => l_result_type);
3754: WHEN c_start_date_standard THEN
3754: WHEN c_start_date_standard THEN
3755: -- Start date is required for Standard PO with purchase basis 'TEMP LABOR'
3756: -- Expiration date if provided should be later than the start date
3757: -- If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
3758: PO_VAL_LINES2.start_date_standard(p_id_tbl => p_lines.interface_id,
3759: p_start_date_tbl => p_lines.start_date,
3760: p_expiration_date_tbl => p_lines.expiration_date,
3761: p_purchase_basis_tbl => p_lines.purchase_basis,
3762: x_results => x_results,
3762: x_results => x_results,
3763: x_result_type => l_result_type);
3764: WHEN c_item_id_standard THEN
3765: -- 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.
3766: PO_VAL_LINES2.item_id_standard(p_id_tbl => p_lines.interface_id,
3767: p_item_id_tbl => p_lines.item_id,
3768: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3769: p_inventory_org_id => l_inventory_org_id,
3770: x_result_set_id => l_result_set_id,
3771: x_result_type => l_result_type);
3772: WHEN c_quantity_standard THEN
3773: -- Quantity cannot be zero for SPO
3774: -- And qiantity cannot be empty for SPO if order type is QUANTITY/AMOUNT
3775: PO_VAL_LINES2.quantity_standard(p_id_tbl => p_lines.interface_id,
3776: p_quantity_tbl => p_lines.quantity,
3777: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3778: x_results => x_results,
3779: x_result_type => l_result_type);
3778: x_results => x_results,
3779: x_result_type => l_result_type);
3780: WHEN c_amount_standard THEN
3781: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', amount cannot be null
3782: PO_VAL_LINES2.amount_standard(p_id_tbl => p_lines.interface_id,
3783: p_amount_tbl => p_lines.amount,
3784: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3785: x_results => x_results,
3786: x_result_type => l_result_type);
3785: x_results => x_results,
3786: x_result_type => l_result_type);
3787: WHEN c_price_break_lookup_code THEN
3788: -- bug5016163
3789: PO_VAL_LINES2.price_break_lookup_code(p_id_tbl => p_lines.interface_id,
3790: p_price_break_lookup_code_tbl => p_lines.price_break_lookup_code,
3791: p_global_agreement_flag_tbl => p_lines.global_agreement_flag,
3792: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3793: p_purchase_basis_tbl => p_lines.purchase_basis,
3796: x_result_type => l_result_type);
3797: WHEN c_not_to_exceed_price THEN
3798: -- If allow_price_override_flag is 'N', then not_to_exceed_price has to be null.
3799: -- If not_to_exceed_price is not null, then it cannot be less than unit_price.
3800: PO_VAL_LINES2.not_to_exceed_price(p_id_tbl => p_lines.interface_id,
3801: p_not_to_exceed_price_tbl => p_lines.not_to_exceed_price,
3802: p_allow_price_override_tbl => p_lines.allow_price_override_flag,
3803: p_unit_price_tbl => p_lines.unit_price,
3804: x_results => x_results,
3805: x_result_type => l_result_type);
3806: WHEN c_uom_update THEN
3807: -- validate unit_meas_lookup_code against po_lines_all and po_units_of_measure_val_v
3808: -- for the Update case
3809: PO_VAL_LINES2.uom_update(p_id_tbl => p_lines.interface_id,
3810: p_unit_meas_lookup_code_tbl => p_lines.unit_meas_lookup_code,
3811: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3812: p_po_header_id_tbl => p_lines.po_header_id,
3813: p_po_line_id_tbl => p_lines.po_line_id,
3815: x_result_set_id => l_result_set_id,
3816: x_result_type => l_result_type);
3817: WHEN c_unit_price_update THEN
3818: -- In the UPDATE case, unit_price cannot be negative. Also handle #DEL.
3819: PO_VAL_LINES2.unit_price_update
3820: ( p_id_tbl => p_lines.interface_id,
3821: p_po_line_id_tbl => p_lines.po_line_id, -- bug5008206
3822: p_draft_id_tbl => p_lines.draft_id, -- bug5258790
3823: p_unit_price_tbl => p_lines.unit_price,
3827: );
3828:
3829: WHEN c_amount_update THEN
3830: -- In the UPDATE case, unit_price cannot be negative. Also handle #DEL.
3831: PO_VAL_LINES2.amount_update
3832: ( p_id_tbl => p_lines.interface_id,
3833: p_po_line_id_tbl => p_lines.po_line_id, -- bug5008206
3834: p_draft_id_tbl => p_lines.draft_id, -- bug5258790
3835: p_amount_tbl => p_lines.amount,
3838: x_result_type => l_result_type
3839: );
3840:
3841: WHEN c_item_desc_update THEN
3842: PO_VAL_LINES2.item_desc_update(p_id_tbl => p_lines.interface_id,
3843: p_item_description_tbl => p_lines.item_description,
3844: p_item_id_tbl => p_lines.item_id,
3845: p_inventory_org_id => l_inventory_org_id,
3846: p_po_header_id_tbl => p_lines.po_header_id,
3849: x_result_set_id => l_result_set_id,
3850: x_result_type => l_result_type);
3851: WHEN c_ip_category_id_update THEN
3852: -- Validate ip_category_id is valid if not empty.
3853: PO_VAL_LINES2.ip_category_id_update(p_id_tbl => p_lines.interface_id,
3854: p_ip_category_id_tbl => p_lines.ip_category_id,
3855: x_result_set_id => l_result_set_id,
3856: x_results => x_results,
3857: x_result_type => l_result_type);
3858: WHEN c_negotiated_by_preparer THEN
3859: ----------------------------------------------------------------------------------------
3860: -- Called in create case for Blanket AND SPO, negotiated_by_preparer must be 'Y' or 'N'.
3861: ----------------------------------------------------------------------------------------
3862: PO_VAL_LINES2.negotiated_by_preparer(p_id_tbl => p_lines.interface_id,
3863: p_negotiated_by_preparer_tbl => p_lines.negotiated_by_preparer_flag,
3864: x_results => x_results,
3865: x_result_type => l_result_type);
3866: WHEN c_negotiated_by_prep_update THEN
3866: WHEN c_negotiated_by_prep_update THEN
3867: --------------------------------------------------------------------------------------
3868: -- Called in update case for Blanket, negotiated_by_preparer must be NULL, 'Y' or 'N'.
3869: --------------------------------------------------------------------------------------
3870: PO_VAL_LINES2.negotiated_by_prep_update(p_id_tbl => p_lines.interface_id,
3871: p_negotiated_by_preparer_tbl => p_lines.negotiated_by_preparer_flag,
3872: x_results => x_results,
3873: x_result_type => l_result_type);
3874: WHEN c_category_id_update THEN
3875: -------------------------------------------------------------------------
3876: -- If either item_id or job_id are populated, then you are not allowed to change the po_category_id
3877: -- If change is allowed, the new category_id must be valid.
3878: -------------------------------------------------------------------------
3879: PO_VAL_LINES2.category_id_update(p_id_tbl => p_lines.interface_id,
3880: p_category_id_tbl => p_lines.category_id,
3881: p_po_line_id_tbl => p_lines.po_line_id,
3882: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3883: p_item_id_tbl => p_lines.item_id,