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_SHIPMENTS

Line 4289: PO_VAL_SHIPMENTS.days_early_gte_zero(

4285: -- ECO 4503425: Removed the planned item null date check as this
4286: -- has been moved to submission checks
4287:
4288: WHEN c_days_early_gte_zero THEN
4289: PO_VAL_SHIPMENTS.days_early_gte_zero(
4290: p_line_loc_id_tbl => p_line_locations.line_location_id
4291: , p_days_early_rcpt_allowed_tbl => p_line_locations.days_early_receipt_allowed
4292: , x_results => x_results
4293: , x_result_type => l_result_type

Line 4297: PO_VAL_SHIPMENTS.days_late_gte_zero(

4293: , x_result_type => l_result_type
4294: );
4295:
4296: WHEN c_days_late_gte_zero THEN
4297: PO_VAL_SHIPMENTS.days_late_gte_zero(
4298: p_line_loc_id_tbl => p_line_locations.line_location_id
4299: , p_days_late_rcpt_allowed_tbl => p_line_locations.days_late_receipt_allowed
4300: , x_results => x_results
4301: , x_result_type => l_result_type

Line 4305: PO_VAL_SHIPMENTS.rcv_close_tol_within_range(

4301: , x_result_type => l_result_type
4302: );
4303:
4304: WHEN c_rcv_close_tol_within_range THEN
4305: PO_VAL_SHIPMENTS.rcv_close_tol_within_range(
4306: p_line_loc_id_tbl => p_line_locations.line_location_id
4307: , p_receive_close_tolerance_tbl => p_line_locations.receive_close_tolerance
4308: , x_results => x_results
4309: , x_result_type => l_result_type

Line 4313: PO_VAL_SHIPMENTS.over_rcpt_tol_within_range(

4309: , x_result_type => l_result_type
4310: );
4311:
4312: WHEN c_over_rcpt_tol_within_range THEN
4313: PO_VAL_SHIPMENTS.over_rcpt_tol_within_range(
4314: p_line_loc_id_tbl => p_line_locations.line_location_id
4315: , p_qty_rcv_tolerance_tbl => p_line_locations.qty_rcv_tolerance
4316: , x_results => x_results
4317: , x_result_type => l_result_type

Line 4321: PO_VAL_SHIPMENTS.match_4way_check(

4317: , x_result_type => l_result_type
4318: );
4319:
4320: WHEN c_match_4way_check THEN
4321: PO_VAL_SHIPMENTS.match_4way_check(
4322: p_line_loc_id_tbl => p_line_locations.line_location_id
4323: , p_value_basis_tbl => p_line_locations.value_basis --
4324: , p_receipt_required_flag_tbl => p_line_locations.receipt_required_flag
4325: , p_inspection_required_flag_tbl => p_line_locations.inspection_required_flag

Line 4333: PO_VAL_SHIPMENTS.inv_close_tol_range_check(

4329: , x_result_type => l_result_type
4330: );
4331:
4332: WHEN c_inv_close_tol_range_check THEN
4333: PO_VAL_SHIPMENTS.inv_close_tol_range_check(
4334: p_line_loc_id_tbl => p_line_locations.line_location_id
4335: , p_invoice_close_tolerance_tbl => p_line_locations.invoice_close_tolerance
4336: , x_results => x_results
4337: , x_result_type => l_result_type

Line 4341: PO_VAL_SHIPMENTS.need_by_date_open_period_check(

4337: , x_result_type => l_result_type
4338: );
4339:
4340: WHEN c_need_by_date_open_per_check THEN
4341: PO_VAL_SHIPMENTS.need_by_date_open_period_check(
4342: p_line_loc_id_tbl => p_line_locations.line_location_id
4343: --PBWC Message Change Impact: Adding a token
4344: , p_line_id_tbl => p_line_locations.po_line_id
4345: , p_need_by_date_tbl => p_line_locations.need_by_date

Line 4352: PO_VAL_SHIPMENTS.promise_date_open_period_check(

4348: , x_result_type => l_result_type
4349: );
4350:
4351: WHEN c_promise_date_open_per_check THEN
4352: PO_VAL_SHIPMENTS.promise_date_open_period_check(
4353: p_line_loc_id_tbl => p_line_locations.line_location_id
4354: --PBWC Message Change Impact: Adding a token
4355: , p_line_id_tbl => p_line_locations.po_line_id
4356: , p_promised_date_tbl => p_line_locations.promised_date

Line 4363: PO_VAL_SHIPMENTS.ship_to_org_null_check(

4359: , x_result_type => l_result_type
4360: );
4361:
4362: WHEN c_ship_to_org_null_check THEN
4363: PO_VAL_SHIPMENTS.ship_to_org_null_check(
4364: p_line_loc_id_tbl => p_line_locations.line_location_id
4365: , p_ship_to_org_id_tbl => p_line_locations.ship_to_organization_id
4366: , p_shipment_type_tbl => p_line_locations.shipment_type
4367: , x_results => x_results

Line 4372: PO_VAL_SHIPMENTS.ship_to_loc_null_check(

4368: , x_result_type => l_result_type
4369: );
4370:
4371: WHEN c_ship_to_loc_null_check THEN
4372: PO_VAL_SHIPMENTS.ship_to_loc_null_check(
4373: p_line_loc_id_tbl => p_line_locations.line_location_id
4374: , p_ship_to_loc_id_tbl => p_line_locations.ship_to_location_id
4375: , p_shipment_type_tbl => p_line_locations.shipment_type
4376: , x_results => x_results

Line 4381: PO_VAL_SHIPMENTS.ship_num_gt_zero(

4377: , x_result_type => l_result_type
4378: );
4379:
4380: WHEN c_ship_num_gt_zero THEN
4381: PO_VAL_SHIPMENTS.ship_num_gt_zero(
4382: p_line_loc_id_tbl => p_line_locations.line_location_id
4383: , p_shipment_num_tbl => p_line_locations.shipment_num
4384: -- : Pass payment_type
4385: , p_payment_type_tbl => p_line_locations.payment_type

Line 4391: PO_VAL_SHIPMENTS.ship_num_unique_check(

4387: , x_result_type => l_result_type
4388: );
4389:
4390: WHEN c_ship_num_unique_check THEN
4391: PO_VAL_SHIPMENTS.ship_num_unique_check(
4392: p_line_loc_id_tbl => p_line_locations.line_location_id
4393: , p_line_id_tbl => p_line_locations.po_line_id
4394: , p_shipment_num_tbl => p_line_locations.shipment_num
4395: -- : Pass in shipment_type

Line 4404: PO_VAL_SHIPMENTS.is_org_in_current_sob_check(

4400: , x_result_type => l_result_type
4401: );
4402:
4403: WHEN c_is_org_in_current_sob_check THEN
4404: PO_VAL_SHIPMENTS.is_org_in_current_sob_check(
4405: p_line_loc_id_tbl => p_line_locations.line_location_id
4406: --PBWC Message Change Impact: Adding a token
4407: , p_line_id_tbl => p_line_locations.po_line_id
4408: , p_org_id_tbl => p_line_locations.org_id

Line 4416: PO_VAL_SHIPMENTS.quantity_gt_zero(

4412: , x_result_type => l_result_type
4413: );
4414:
4415: WHEN c_ship_qty_gt_zero THEN
4416: PO_VAL_SHIPMENTS.quantity_gt_zero(
4417: p_line_loc_id_tbl => p_line_locations.line_location_id
4418: , p_quantity_tbl => p_line_locations.quantity
4419: , p_shipment_type_tbl => p_line_locations.shipment_type
4420: , p_value_basis_tbl => p_line_locations.value_basis --

Line 4429: PO_VAL_SHIPMENTS.quantity_ge_quantity_exec(

4425: );
4426:
4427: -- : Combine qty billed and rcvd into qty exec
4428: WHEN c_ship_qty_ge_qty_exec THEN
4429: PO_VAL_SHIPMENTS.quantity_ge_quantity_exec(
4430: p_line_loc_id_tbl => p_line_locations.line_location_id
4431: , p_quantity_tbl => p_line_locations.quantity
4432: , x_result_set_id => l_result_set_id
4433: , x_result_type => l_result_type

Line 4438: PO_VAL_SHIPMENTS.amount_gt_zero(

4434: );
4435: --
4436:
4437: WHEN c_ship_amt_gt_zero THEN
4438: PO_VAL_SHIPMENTS.amount_gt_zero(
4439: p_line_loc_id_tbl => p_line_locations.line_location_id
4440: , p_amount_tbl => p_line_locations.amount
4441: , p_shipment_type_tbl => p_line_locations.shipment_type
4442: , p_value_basis_tbl => p_line_locations.value_basis --

Line 4451: PO_VAL_SHIPMENTS.amount_ge_amount_exec(

4447: );
4448:
4449: -- : Combine amt billed and rcvd into amt exec
4450: WHEN c_ship_amt_ge_amt_exec THEN
4451: PO_VAL_SHIPMENTS.amount_ge_amount_exec(
4452: p_line_loc_id_tbl => p_line_locations.line_location_id
4453: , p_amount_tbl => p_line_locations.amount
4454: , x_result_set_id => l_result_set_id
4455: , x_result_type => l_result_type

Line 4461: PO_VAL_SHIPMENTS.ship_sec_quantity_gt_zero(

4457: --
4458:
4459: -- Opm related validation : OPM Integration R12 Start
4460: WHEN c_ship_sec_qty_gt_zero THEN
4461: PO_VAL_SHIPMENTS.ship_sec_quantity_gt_zero(
4462: p_line_loc_id_tbl => p_line_locations.line_location_id
4463: , p_item_id_tbl => p_line_locations.line_item_id
4464: , p_ship_to_org_id_tbl => p_line_locations.ship_to_organization_id
4465: , p_sec_quantity_tbl => p_line_locations.secondary_quantity

Line 4471: PO_VAL_SHIPMENTS.ship_qtys_within_deviation(

4467: , x_result_type => l_result_type
4468: );
4469:
4470: WHEN c_ship_qtys_within_deviation THEN
4471: PO_VAL_SHIPMENTS.ship_qtys_within_deviation(
4472: p_line_loc_id_tbl => p_line_locations.line_location_id
4473: , p_item_id_tbl => p_line_locations.line_item_id
4474: , p_ship_to_org_id_tbl => p_line_locations.ship_to_organization_id
4475: , p_quantity_tbl => p_line_locations.quantity

Line 4486: PO_VAL_SHIPMENTS.unit_of_measure_not_null(

4482: -- Opm related validation : OPM Integration R12 End
4483:
4484: -- Bug 5385686 : Enforce not null check on UOM
4485: WHEN c_unit_of_measure_not_null THEN
4486: PO_VAL_SHIPMENTS.unit_of_measure_not_null(
4487: p_line_loc_id_tbl => p_line_locations.line_location_id
4488: , p_value_basis_tbl => p_line_locations.value_basis
4489: , p_payment_type_tbl => p_line_locations.payment_type
4490: , p_unit_meas_lookup_code_tbl => p_line_locations.unit_meas_lookup_code

Line 4497: PO_VAL_SHIPMENTS.mod_no_cancel_shp_complt(

4493: );
4494:
4495: -- Mod Project
4496: WHEN c_smod_no_cancel_shp_complt THEN
4497: PO_VAL_SHIPMENTS.mod_no_cancel_shp_complt(
4498: p_line_loc_id_tbl => p_line_locations.po_line_id
4499: , p_control_action_tbl => p_line_locations.control_action
4500: , x_result_set_id => l_result_set_id
4501: , x_result_type => l_result_type

Line 4506: PO_VAL_SHIPMENTS.pop_start_date_le_end_date

4502: );
4503:
4504: -- For Po Fed Fileds
4505: WHEN c_pop_start_date_le_end_date THEN
4506: PO_VAL_SHIPMENTS.pop_start_date_le_end_date
4507: (
4508: p_line_id_tbl => p_line_locations.line_location_id
4509: , p_start_date_tbl => p_line_locations.CLM_PERIOD_PERF_START_DATE
4510: , p_expiration_date_tbl => p_line_locations.CLM_PERIOD_PERF_END_DATE

Line 4516: PO_VAL_SHIPMENTS.pop_date_need_by_date

4512: , x_result_type => l_result_type
4513: );
4514:
4515: WHEN c_pop_date_need_by_date THEN
4516: PO_VAL_SHIPMENTS.pop_date_need_by_date
4517: (
4518: p_line_id_tbl => p_line_locations.line_location_id
4519: , p_start_date_tbl => p_line_locations.CLM_PERIOD_PERF_START_DATE
4520: , p_end_date_tbl => p_line_locations.CLM_PERIOD_PERF_END_DATE

Line 4526: PO_VAL_SHIPMENTS.complex_price_or_gt_zero(

4522: , x_results => x_results
4523: , x_result_type => l_result_type
4524: );
4525: WHEN c_complex_price_or_gt_zero THEN
4526: PO_VAL_SHIPMENTS.complex_price_or_gt_zero(
4527: p_line_loc_id_tbl => p_line_locations.line_location_id
4528: , p_price_override_tbl => p_line_locations.price_override
4529: , p_value_basis_tbl => p_line_locations.value_basis
4530: , p_payment_type_tbl => p_line_locations.payment_type

Line 4542: PO_VAL_SHIPMENTS2.need_by_date(p_id_tbl => p_line_locations.interface_id,

4538: -- PDOI Shipment Validation Subroutines
4539: --------------------------------------------------------------------------
4540: WHEN c_shipment_need_by_date THEN
4541: -- if purchase_basis is 'TEMP LABOR', the need_by_date column must be null
4542: PO_VAL_SHIPMENTS2.need_by_date(p_id_tbl => p_line_locations.interface_id,
4543: p_purchase_basis_tbl => p_line_locations.purchase_basis,
4544: p_need_by_date_tbl => p_line_locations.need_by_date,
4545: x_results => x_results,
4546: x_result_type => l_result_type);

Line 4549: PO_VAL_SHIPMENTS2.promised_date(p_id_tbl => p_line_locations.interface_id,

4545: x_results => x_results,
4546: x_result_type => l_result_type);
4547: WHEN c_shipment_promised_date THEN
4548: -- if purchase_basis is 'TEMP LABOR', the promised_date must be null
4549: PO_VAL_SHIPMENTS2.promised_date(p_id_tbl => p_line_locations.interface_id,
4550: p_purchase_basis_tbl => p_line_locations.purchase_basis,
4551: p_promised_date_tbl => p_line_locations.promised_date,
4552: x_results => x_results,
4553: x_result_type => l_result_type);

Line 4556: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,

4552: x_results => x_results,
4553: x_result_type => l_result_type);
4554: WHEN c_shipment_type_blanket THEN
4555: -- validate shipment type
4556: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
4557: p_shipment_type_tbl => p_line_locations.shipment_type,
4558: p_style_id_tbl => p_line_locations.hdr_style_id, -- PDOI for Complex PO Project
4559: p_doc_type => c_doc_type_blanket,
4560: x_results => x_results,

Line 4564: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,

4560: x_results => x_results,
4561: x_result_type => l_result_type);
4562: WHEN c_shipment_type_standard THEN
4563: -- validate shipment type
4564: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
4565: p_shipment_type_tbl => p_line_locations.shipment_type,
4566: p_style_id_tbl => p_line_locations.hdr_style_id, -- PDOI for Complex PO Project
4567: p_doc_type => c_doc_type_standard,
4568: x_results => x_results,

Line 4572: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,

4568: x_results => x_results,
4569: x_result_type => l_result_type);
4570: WHEN c_shipment_type_quotation THEN
4571: -- validate shipment type
4572: PO_VAL_SHIPMENTS2.shipment_type(p_id_tbl => p_line_locations.interface_id,
4573: p_shipment_type_tbl => p_line_locations.shipment_type,
4574: p_style_id_tbl => p_line_locations.hdr_style_id, -- PDOI for Complex PO Project
4575: p_doc_type => c_doc_type_quotation,
4576: x_results => x_results,

Line 4581: PO_VAL_SHIPMENTS2.shipment_num(p_id_tbl => p_line_locations.interface_id,

4577: x_result_type => l_result_type);
4578: WHEN c_shipment_num THEN
4579: -- validate shipment num is not null, greater than zero and unique
4580: -- bug 4642348: add two parameters - p_draft_id_tbl, p_doc_type
4581: PO_VAL_SHIPMENTS2.shipment_num(p_id_tbl => p_line_locations.interface_id,
4582: p_shipment_num_tbl => p_line_locations.shipment_num,
4583: p_shipment_type_tbl => p_line_locations.shipment_type,
4584: p_po_header_id_tbl => p_line_locations.po_header_id,
4585: p_po_line_id_tbl => p_line_locations.po_line_id,

Line 4602: PO_VAL_SHIPMENTS2.quantity(p_id_tbl => p_line_locations.interface_id,

4598: x_result_set_id => l_result_set_id,
4599: x_result_type => l_result_type);
4600: WHEN c_shipment_quantity THEN
4601: -- If order_type_lookup_code is RATE or FIXED PRICE, validate quantity is not null
4602: PO_VAL_SHIPMENTS2.quantity(p_id_tbl => p_line_locations.interface_id,
4603: p_quantity_tbl => p_line_locations.quantity,
4604: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
4605: p_shipment_type_tbl => p_line_locations.shipment_type, -- PDOI for Complex PO Project
4606: p_style_id_tbl => p_line_locations.hdr_style_id, -- PDOI for Complex PO Project

Line 4613: PO_VAL_SHIPMENTS2.price_override(p_id_tbl => p_line_locations.interface_id,

4609: x_results => x_results,
4610: x_result_type => l_result_type);
4611: WHEN c_shipment_price_override THEN
4612: -- If order_type_lookup_code is not FIXED PRICE, price_override cannot be null
4613: PO_VAL_SHIPMENTS2.price_override(p_id_tbl => p_line_locations.interface_id,
4614: p_price_override_tbl => p_line_locations.price_override,
4615: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
4616: p_shipment_type_tbl => p_line_locations.shipment_type, -- PDOI for Complex PO Project
4617: p_style_id_tbl => p_line_locations.hdr_style_id, -- PDOI for Complex PO Project

Line 4625: PO_VAL_SHIPMENTS2.price_discount(p_id_tbl => p_line_locations.interface_id,

4621: x_result_type => l_result_type);
4622: WHEN c_shipment_price_discount THEN
4623: -- If order_type_lookup_code is not FIXED PRICE, price_discount/price_override cannot both be null
4624: -- and price discount cannot be less than zero or greater than 100
4625: PO_VAL_SHIPMENTS2.price_discount(p_id_tbl => p_line_locations.interface_id,
4626: p_price_discount_tbl => p_line_locations.price_discount,
4627: p_price_override_tbl => p_line_locations.price_override,
4628: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
4629: x_results => x_results,

Line 4633: PO_VAL_SHIPMENTS2.ship_to_organization_id(p_id_tbl => p_line_locations.interface_id,

4629: x_results => x_results,
4630: x_result_type => l_result_type);
4631: WHEN c_ship_to_organization_id THEN
4632: -- validate ship_to_organization_id
4633: PO_VAL_SHIPMENTS2.ship_to_organization_id(p_id_tbl => p_line_locations.interface_id,
4634: p_ship_to_organization_id_tbl => p_line_locations.ship_to_organization_id,
4635: p_item_id_tbl => p_line_locations.item_id,
4636: p_item_revision_tbl => p_line_locations.item_revision,
4637: p_ship_to_location_id_tbl => p_line_locations.ship_to_location_id,

Line 4644: PO_VAL_SHIPMENTS2.effective_dates(p_id_tbl => p_line_locations.interface_id,

4640: WHEN c_shipment_effective_dates THEN
4641: -- validate_effective_dates
4642: -- bug5016163
4643: -- Added price break look up code as parameter
4644: PO_VAL_SHIPMENTS2.effective_dates(p_id_tbl => p_line_locations.interface_id,
4645: p_line_expiration_date_tbl => p_line_locations.line_expiration_date,
4646: p_to_date_tbl => p_line_locations.to_date,
4647: p_from_date_tbl => p_line_locations.from_date,
4648: p_header_start_date_tbl => p_line_locations.hdr_start_date,

Line 4655: PO_VAL_SHIPMENTS2.qty_rcv_exception_code(p_id_tbl => p_line_locations.interface_id,

4651: x_results => x_results,
4652: x_result_type => l_result_type);
4653: WHEN c_qty_rcv_exception_code THEN
4654: -- validate qty_rcv_exception_code against PO_LOOKUP_CODES
4655: PO_VAL_SHIPMENTS2.qty_rcv_exception_code(p_id_tbl => p_line_locations.interface_id,
4656: p_qty_rcv_exception_code_tbl => p_line_locations.qty_rcv_exception_code,
4657: x_result_set_id => l_result_set_id,
4658: x_result_type => l_result_type);
4659: WHEN c_enforce_ship_to_loc_code THEN

Line 4662: PO_VAL_SHIPMENTS2.enforce_ship_to_loc_code(p_id_tbl => p_line_locations.interface_id,

4658: x_result_type => l_result_type);
4659: WHEN c_enforce_ship_to_loc_code THEN
4660: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal
4661: -- to NONE, REJECT or WARNING
4662: PO_VAL_SHIPMENTS2.enforce_ship_to_loc_code(p_id_tbl => p_line_locations.interface_id,
4663: p_enforce_ship_to_loc_code_tbl => p_line_locations.enforce_ship_to_location_code,
4664: p_shipment_type_tbl => p_line_locations.shipment_type,
4665: x_results => x_results,
4666: x_result_type => l_result_type);

Line 4670: PO_VAL_SHIPMENTS2.allow_sub_receipts_flag(p_id_tbl => p_line_locations.interface_id,

4666: x_result_type => l_result_type);
4667: WHEN c_allow_sub_receipts_flag THEN
4668: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not equal
4669: -- to NONE, REJECT or WARNING
4670: PO_VAL_SHIPMENTS2.allow_sub_receipts_flag(p_id_tbl => p_line_locations.interface_id,
4671: p_shipment_type_tbl => p_line_locations.shipment_type,
4672: p_allow_sub_receipts_flag_tbl => p_line_locations.allow_substitute_receipts_flag,
4673: x_results => x_results,
4674: x_result_type => l_result_type);

Line 4678: PO_VAL_SHIPMENTS2.days_early_receipt_allowed(p_id_tbl => p_line_locations.interface_id,

4674: x_result_type => l_result_type);
4675: WHEN c_days_early_receipt_allowed THEN
4676: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null
4677: -- and less than zero.
4678: PO_VAL_SHIPMENTS2.days_early_receipt_allowed(p_id_tbl => p_line_locations.interface_id,
4679: p_shipment_type_tbl => p_line_locations.shipment_type,
4680: p_days_early_rcpt_allowed_tbl => p_line_locations.days_early_receipt_allowed,
4681: x_results => x_results,
4682: x_result_type => l_result_type);

Line 4686: PO_VAL_SHIPMENTS2.receipt_days_exception_code(p_id_tbl => p_line_locations.interface_id,

4682: x_result_type => l_result_type);
4683: WHEN c_receipt_days_exception_code THEN
4684: -- If shipment_type is STANDARD and receipt_days_expection_code is not null
4685: -- and not 'NONE', 'REJECT' not 'WARNING'
4686: PO_VAL_SHIPMENTS2.receipt_days_exception_code(p_id_tbl => p_line_locations.interface_id,
4687: p_shipment_type_tbl => p_line_locations.shipment_type,
4688: p_rcpt_days_exception_code_tbl => p_line_locations.receipt_days_exception_code,
4689: x_results => x_results,
4690: x_result_type => l_result_type);

Line 4694: PO_VAL_SHIPMENTS2.invoice_close_tolerance(p_id_tbl => p_line_locations.interface_id,

4690: x_result_type => l_result_type);
4691: WHEN c_invoice_close_tolerance THEN
4692: -- If shipment_type is STANDARD and invoice_close_tolerance is not null
4693: -- and less than or equal to zero or greater than or equal to 100.
4694: PO_VAL_SHIPMENTS2.invoice_close_tolerance(p_id_tbl => p_line_locations.interface_id,
4695: p_shipment_type_tbl => p_line_locations.shipment_type,
4696: p_invoice_close_tolerance_tbl => p_line_locations.invoice_close_tolerance,
4697: x_results => x_results,
4698: x_result_type => l_result_type);

Line 4702: PO_VAL_SHIPMENTS2.receive_close_tolerance(p_id_tbl => p_line_locations.interface_id,

4698: x_result_type => l_result_type);
4699: WHEN c_receive_close_tolerance THEN
4700: -- If shipment_type is STANDARD and receive_close_tolerance is not null
4701: -- and less than or equal to zero or greater than or equal to 100.
4702: PO_VAL_SHIPMENTS2.receive_close_tolerance(p_id_tbl => p_line_locations.interface_id,
4703: p_shipment_type_tbl => p_line_locations.shipment_type,
4704: p_receive_close_tolerance_tbl => p_line_locations.receive_close_tolerance,
4705: x_results => x_results,
4706: x_result_type => l_result_type);

Line 4709: PO_VAL_SHIPMENTS2.receiving_routing_id(p_id_tbl => p_line_locations.interface_id,

4705: x_results => x_results,
4706: x_result_type => l_result_type);
4707: WHEN c_receiving_routing_id THEN
4708: -- Validate that receiving routing id exists in rcv_routing_headers
4709: PO_VAL_SHIPMENTS2.receiving_routing_id(p_id_tbl => p_line_locations.interface_id,
4710: p_shipment_type_tbl => p_line_locations.shipment_type,
4711: p_receiving_routing_id_tbl => p_line_locations.receiving_routing_id,
4712: x_result_set_id => l_result_set_id,
4713: x_result_type => l_result_type);

Line 4716: PO_VAL_SHIPMENTS2.accrue_on_receipt_flag(p_id_tbl => p_line_locations.interface_id,

4712: x_result_set_id => l_result_set_id,
4713: x_result_type => l_result_type);
4714: WHEN c_accrue_on_receipt_flag THEN
4715: -- Validate accrue_on_receipt_flag is Y or N, if not null.
4716: PO_VAL_SHIPMENTS2.accrue_on_receipt_flag(p_id_tbl => p_line_locations.interface_id,
4717: p_accrue_on_receipt_flag_tbl => p_line_locations.accrue_on_receipt_flag,
4718: x_results => x_results,
4719: x_result_type => l_result_type);
4720: --

Line 4723: PO_VAL_SHIPMENTS2.advance_amt_le_amt(p_id_tbl => p_line_locations.interface_id,

4719: x_result_type => l_result_type);
4720: --
4721: WHEN c_pdoi_amt_ge_ship_advance_amt THEN
4722: -- Validate advance amount at shipment.
4723: PO_VAL_SHIPMENTS2.advance_amt_le_amt(p_id_tbl => p_line_locations.interface_id,
4724: p_payment_type_tbl => p_line_locations.payment_type,
4725: p_advance_tbl => p_line_locations.amount,
4726: p_amount_tbl => p_line_locations.line_amount,
4727: p_quantity_tbl => p_line_locations.line_quantity,

Line 4733: PO_VAL_SHIPMENTS2.amount(p_id_tbl => p_line_locations.interface_id,

4729: x_results => x_results,
4730: x_result_type => l_result_type);
4731: WHEN c_pdoi_shipment_amount THEN
4732: -- Validate amount at shipment.
4733: PO_VAL_SHIPMENTS2.amount(p_id_tbl => p_line_locations.interface_id,
4734: p_amount_tbl => p_line_locations.amount,
4735: p_shipment_type_tbl => p_line_locations.shipment_type,
4736: p_style_id_tbl => p_line_locations.hdr_style_id,
4737: p_payment_type_tbl => p_line_locations.payment_type,

Line 4743: PO_VAL_SHIPMENTS2.payment_type(p_id_tbl => p_line_locations.interface_id,

4739: x_results => x_results,
4740: x_result_type => l_result_type);
4741: WHEN c_pdoi_payment_type THEN
4742: -- Validate payment type.
4743: PO_VAL_SHIPMENTS2.payment_type(p_id_tbl => p_line_locations.interface_id,
4744: po_line_id_tbl => p_line_locations.po_line_id,
4745: p_style_id_tbl => p_line_locations.hdr_style_id,
4746: p_payment_type_tbl => p_line_locations.payment_type,
4747: p_shipment_type_tbl => p_line_locations.shipment_type,

Line 4752: PO_VAL_SHIPMENTS2.fob_lookup_code(p_id_tbl => p_line_locations.interface_id,

4748: x_results => x_results,
4749: x_result_type => l_result_type);
4750: --
4751: WHEN c_fob_lookup_code_line_loc THEN
4752: PO_VAL_SHIPMENTS2.fob_lookup_code(p_id_tbl => p_line_locations.interface_id,
4753: p_fob_lookup_code_tbl => p_line_locations.fob_lookup_code,
4754: x_result_set_id => l_result_set_id,
4755: x_result_type => l_result_type);
4756: WHEN c_freight_terms_line_loc THEN

Line 4757: PO_VAL_SHIPMENTS2.freight_terms(p_id_tbl => p_line_locations.interface_id,

4753: p_fob_lookup_code_tbl => p_line_locations.fob_lookup_code,
4754: x_result_set_id => l_result_set_id,
4755: x_result_type => l_result_type);
4756: WHEN c_freight_terms_line_loc THEN
4757: PO_VAL_SHIPMENTS2.freight_terms(p_id_tbl => p_line_locations.interface_id,
4758: p_freight_terms_tbl => p_line_locations.freight_terms_lookup_code,
4759: x_result_set_id => l_result_set_id,
4760: x_result_type => l_result_type);
4761: WHEN c_freight_carrier_line_loc THEN

Line 4762: PO_VAL_SHIPMENTS2.freight_carrier(p_id_tbl => p_line_locations.interface_id,

4758: p_freight_terms_tbl => p_line_locations.freight_terms_lookup_code,
4759: x_result_set_id => l_result_set_id,
4760: x_result_type => l_result_type);
4761: WHEN c_freight_carrier_line_loc THEN
4762: PO_VAL_SHIPMENTS2.freight_carrier(p_id_tbl => p_line_locations.interface_id,
4763: p_freight_carrier_tbl => p_line_locations.freight_carrier,
4764: p_inventory_org_id => l_inventory_org_id,
4765: x_result_set_id => l_result_set_id,
4766: x_result_type => l_result_type);

Line 4768: PO_VAL_SHIPMENTS2.style_related_info(p_id_tbl => p_line_locations.interface_id,

4764: p_inventory_org_id => l_inventory_org_id,
4765: x_result_set_id => l_result_set_id,
4766: x_result_type => l_result_type);
4767: WHEN c_line_loc_style_related_info THEN
4768: PO_VAL_SHIPMENTS2.style_related_info(p_id_tbl => p_line_locations.interface_id,
4769: p_style_id_tbl => p_line_locations.hdr_style_id,
4770: x_result_set_id => l_result_set_id,
4771: x_result_type => l_result_type);
4772: WHEN c_price_break THEN

Line 4775: PO_VAL_SHIPMENTS2.price_break(p_id_tbl => p_line_locations.interface_id,

4771: x_result_type => l_result_type);
4772: WHEN c_price_break THEN
4773: -- Cannot create price breaks for Amount-Based or Fixed Price lines in a Blanket
4774: -- Purchase Agreement.
4775: PO_VAL_SHIPMENTS2.price_break(p_id_tbl => p_line_locations.interface_id,
4776: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
4777: x_results => x_results,
4778: x_result_type => l_result_type);
4779: WHEN c_tax_name THEN

Line 4780: PO_VAL_SHIPMENTS2.tax_name(p_id_tbl => p_line_locations.interface_id,

4776: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
4777: x_results => x_results,
4778: x_result_type => l_result_type);
4779: WHEN c_tax_name THEN
4780: PO_VAL_SHIPMENTS2.tax_name(p_id_tbl => p_line_locations.interface_id,
4781: p_tax_name_tbl => p_line_locations.tax_name,
4782: p_tax_code_id_tbl => p_line_locations.tax_code_id,
4783: p_need_by_date_tbl => p_line_locations.need_by_date,
4784: p_allow_tax_code_override => l_allow_tax_code_override,