[Home] [Help]
2311: p_entity_type => c_entity_type_header,
2312: p_column_name => 'END DATE',
2313: p_column_val_selector => 'END_DATE',
2314: p_message_name => 'PO_PDOI_INVALID_END_DATE',
2315: p_validation_id => PO_VAL_CONSTANTS.c_end_date,
2316: x_results => x_results,
2317: x_result_type => l_result_type);
2318:
2319: WHEN c_type_lookup_code THEN
2352: p_entity_id_tbl => p_headers.interface_id,
2353: p_entity_type => c_entity_type_header,
2354: p_column_name => 'REVISION_NUM',
2355: p_message_name => 'PO_PDOI_COLUMN_ZERO',
2356: p_validation_id => PO_VAL_CONSTANTS.c_revision_num,
2357: x_results => x_results,
2358: x_result_type => l_result_type);
2359: WHEN c_currency_code THEN
2360: -- validate currency_code is not null and valid in FND_CURRENCIES.
2416: p_entity_id_tbl => p_headers.interface_id,
2417: p_entity_type => c_entity_type_header,
2418: p_column_name => 'LAST_UPDATE_DATE',
2419: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
2420: p_validation_id => PO_VAL_CONSTANTS.c_last_update_date,
2421: x_results => x_results,
2422: x_result_type => l_result_type);
2423: WHEN c_last_updated_by THEN
2424: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,
2426: p_entity_id_tbl => p_headers.interface_id,
2427: p_entity_type => c_entity_type_header,
2428: p_column_name => 'LAST_UPDATED_BY',
2429: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
2430: p_validation_id => PO_VAL_CONSTANTS.c_last_updated_by,
2431: x_results => x_results,
2432: x_result_type => l_result_type);
2433: WHEN c_po_release_id THEN
2434: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2440: p_token1_name => 'COLUMN_NAME',
2441: p_token1_value => 'PO_RELEASE_ID',
2442: p_token2_name => 'VALUE',
2443: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.po_release_id),
2444: p_validation_id => PO_VAL_CONSTANTS.c_po_release_id,
2445: x_results => x_results,
2446: x_result_type => l_result_type);
2447: WHEN c_release_num THEN
2448: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2454: p_token1_name => 'COLUMN_NAME',
2455: p_token1_value => 'RELEASE_NUM',
2456: p_token2_name => 'VALUE',
2457: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.release_num),
2458: p_validation_id => PO_VAL_CONSTANTS.c_release_num,
2459: x_results => x_results,
2460: x_result_type => l_result_type);
2461: WHEN c_release_date THEN
2462: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2468: p_token1_name => 'COLUMN_NAME',
2469: p_token1_value => 'RELEASE_DATE',
2470: p_token2_name => 'VALUE',
2471: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.release_date),
2472: p_validation_id => PO_VAL_CONSTANTS.c_release_date,
2473: x_results => x_results,
2474: x_result_type => l_result_type);
2475: WHEN c_revised_date THEN
2476: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2482: p_token1_name => 'COLUMN_NAME',
2483: p_token1_value => 'REVISED_DATE',
2484: p_token2_name => 'VALUE',
2485: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.revised_date),
2486: p_validation_id => PO_VAL_CONSTANTS.c_revised_date,
2487: x_results => x_results,
2488: x_result_type => l_result_type);
2489: WHEN c_printed_date THEN
2490: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2496: p_token1_name => 'COLUMN_NAME',
2497: p_token1_value => 'PRINTED_DATE',
2498: p_token2_name => 'VALUE',
2499: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.printed_date),
2500: p_validation_id => PO_VAL_CONSTANTS.c_printed_date,
2501: x_results => x_results,
2502: x_result_type => l_result_type);
2503: WHEN c_closed_date THEN
2504: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2510: p_token1_name => 'COLUMN_NAME',
2511: p_token1_value => 'CLOSED_DATE',
2512: p_token2_name => 'VALUE',
2513: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.closed_date),
2514: p_validation_id => PO_VAL_CONSTANTS.c_closed_date,
2515: x_results => x_results,
2516: x_result_type => l_result_type);
2517: WHEN c_terms_id_header THEN
2518: PO_VALIDATION_HELPER.terms_id(p_calling_module => p_calling_program,
2518: PO_VALIDATION_HELPER.terms_id(p_calling_module => p_calling_program,
2519: p_terms_id_tbl => p_headers.terms_id,
2520: p_entity_id_tbl => p_headers.interface_id,
2521: p_entity_type => c_entity_type_header,
2522: p_validation_id => PO_VAL_CONSTANTS.c_terms_id_header,
2523: x_result_set_id => l_result_set_id,
2524: x_result_type => l_result_type);
2525: WHEN c_ship_via_lookup_code THEN
2526: PO_VAL_HEADERS2.ship_via_lookup_code(p_id_tbl => p_headers.interface_id,
2553: p_token1_name => 'COLUMN_NAME',
2554: p_token1_value => 'CONFIRMING_ORDER_FLAG',
2555: p_token2_name => 'VALUE',
2556: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.confirming_order_flag),
2557: p_validation_id => PO_VAL_CONSTANTS.c_confirming_order_flag,
2558: x_results => x_results,
2559: x_result_type => l_result_type);
2560: WHEN c_acceptance_due_date THEN
2561: PO_VAL_HEADERS2.acceptance_due_date(p_id_tbl => p_headers.interface_id,
2574: p_token1_name => 'COLUMN_NAME',
2575: p_token1_value => 'AMOUNT_AGREED',
2576: p_token2_name => 'VALUE',
2577: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.amount_agreed),
2578: p_validation_id => PO_VAL_CONSTANTS.c_amount_agreed,
2579: x_results => x_results,
2580: x_result_type => l_result_type);
2581: WHEN c_amount_limit THEN
2582: -- bug 5352625
2598: p_token1_name => 'COLUMN_NAME',
2599: p_token1_value => 'FIRM_STATUS_LOOKUP_CODE',
2600: p_token2_name => 'VALUE',
2601: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.firm_status_lookup_code),
2602: p_validation_id => PO_VAL_CONSTANTS.c_firm_status_lookup_header,
2603: x_results => x_results,
2604: x_result_type => l_result_type);
2605: WHEN c_cancel_flag THEN
2606: PO_VAL_HEADERS2.cancel_flag(p_id_tbl => p_headers.interface_id,
2629: p_token1_name => 'COLUMN_NAME',
2630: p_token1_value => 'FROZEN_FLAG',
2631: p_token2_name => 'VALUE',
2632: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.frozen_flag),
2633: p_validation_id => PO_VAL_CONSTANTS.c_frozen_flag,
2634: x_results => x_results,
2635: x_result_type => l_result_type);
2636: WHEN c_approval_status THEN
2637: PO_VAL_HEADERS2.approval_status(p_id_tbl => p_headers.interface_id,
2653: p_token1_name => 'COLUMN_NAME',
2654: p_token1_value => 'QUOTE_WARNING_DELAY',
2655: p_token2_name => 'VALUE',
2656: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.quote_warning_delay),
2657: p_validation_id => PO_VAL_CONSTANTS.c_quote_warning_delay,
2658: x_results => x_results,
2659: x_result_type => l_result_type);
2660: WHEN c_approval_required_flag THEN
2661: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,
2667: p_token1_name => 'COLUMN_NAME',
2668: p_token1_value => 'APPROVAL_REQUIRED_FLAG',
2669: p_token2_name => 'VALUE',
2670: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.approval_required_flag),
2671: p_validation_id => PO_VAL_CONSTANTS.c_approval_required_flag,
2672: x_results => x_results,
2673: x_result_type => l_result_type);
2674:
2675: WHEN c_ord_st_dt_gt_effec_dt THEN
3914: p_token1_name => 'COLUMN_NAME',
3915: p_token1_value => 'CATEGORY_ID',
3916: p_token2_name => 'VALUE',
3917: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.category_id),
3918: p_validation_id => PO_VAL_CONSTANTS.c_category_id_not_null,
3919: x_results => x_results,
3920: x_result_type => l_result_type);
3921: WHEN c_ip_category_id_null THEN
3922: -- Validate ip_category_id is empty
3962: p_item_id_tbl => p_lines.item_id,
3963: p_item_tbl => p_lines.item,
3964: p_organization_id_tbl => p_lines.inventory_org_id,
3965: p_create_or_update_item_flag => l_create_or_update_item,
3966: p_validation_id => PO_VAL_CONSTANTS.c_line_preferred_grade,
3967: x_results => x_results,
3968: x_result_set_id => l_result_set_id,
3969: x_result_type => l_result_type);
3970: WHEN c_release_num_null THEN
3977: p_token1_name => 'COLUMN_NAME',
3978: p_token1_value => 'RELEASE_NUM',
3979: p_token2_name => 'VALUE',
3980: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.release_num),
3981: p_validation_id => PO_VAL_CONSTANTS.c_release_num_null,
3982: x_results => x_results,
3983: x_result_type => l_result_type);
3984: WHEN c_po_release_id_null THEN
3985: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3991: p_token1_name => 'COLUMN_NAME',
3992: p_token1_value => 'PO_RELEASE_ID',
3993: p_token2_name => 'VALUE',
3994: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.po_release_id),
3995: p_validation_id => PO_VAL_CONSTANTS.c_po_release_id_null,
3996: x_results => x_results,
3997: x_result_type => l_result_type);
3998: WHEN c_source_shipment_id_null THEN
3999: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4070: p_token1_name => 'COLUMN_NAME',
4071: p_token1_value => 'CLOSED_DATE',
4072: p_token2_name => 'VALUE',
4073: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.closed_date),
4074: p_validation_id => PO_VAL_CONSTANTS.c_closed_date_null,
4075: x_results => x_results,
4076: x_result_type => l_result_type);
4077: WHEN c_closed_by_null THEN
4078: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4097: p_token1_name => 'COLUMN_NAME',
4098: p_token1_value => 'OVER_TOLERANCE_ERROR_FLAG',
4099: p_token2_name => 'VALUE',
4100: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.over_tolerance_error_flag),
4101: p_validation_id => PO_VAL_CONSTANTS.c_over_tolerance_err_flag_null,
4102: x_results => x_results,
4103: x_result_type => l_result_type);
4104: WHEN c_committed_amount_null THEN
4105: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4111: p_token1_name => 'COLUMN_NAME',
4112: p_token1_value => 'COMMITTED_AMOUNT',
4113: p_token2_name => 'VALUE',
4114: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.committed_amount),
4115: p_validation_id => PO_VAL_CONSTANTS.c_committed_amount_null,
4116: x_results => x_results,
4117: x_result_type => l_result_type);
4118: WHEN c_allow_price_override_null THEN
4119: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4125: p_token1_name => 'COLUMN_NAME',
4126: p_token1_value => 'ALLOW_PRICE_OVERRIDE_FLAG',
4127: p_token2_name => 'VALUE',
4128: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.allow_price_override_flag),
4129: p_validation_id => PO_VAL_CONSTANTS.c_allow_price_override_null,
4130: x_results => x_results,
4131: x_result_type => l_result_type);
4132: WHEN c_negotiated_by_preparer_null THEN
4133: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4139: p_token1_name => 'COLUMN_NAME',
4140: p_token1_value => 'NEGOTIATED_BY_PREPARER_FLAG',
4141: p_token2_name => 'VALUE',
4142: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.negotiated_by_preparer_flag),
4143: p_validation_id => PO_VAL_CONSTANTS.c_negotiated_by_preparer_null,
4144: x_results => x_results,
4145: x_result_type => l_result_type);
4146: WHEN c_capital_expense_flag_null THEN
4147: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4153: p_token1_name => 'COLUMN_NAME',
4154: p_token1_value => 'CAPITAL_EXPENSE_FLAG',
4155: p_token2_name => 'VALUE',
4156: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.capital_expense_flag),
4157: p_validation_id => PO_VAL_CONSTANTS.c_capital_expense_flag_null,
4158: x_results => x_results,
4159: x_result_type => l_result_type);
4160: WHEN c_min_release_amount_null THEN
4161: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4167: p_token1_name => 'COLUMN_NAME',
4168: p_token1_value => 'MIN_RELEASE_AMOUNT',
4169: p_token2_name => 'VALUE',
4170: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.min_release_amount),
4171: p_validation_id => PO_VAL_CONSTANTS.c_min_release_amount_null,
4172: x_results => x_results,
4173: x_result_type => l_result_type);
4174: --
4175: WHEN c_pdoi_qty_ge_qty_mstone_exec THEN
4270: p_token1_name => 'COLUMN_NAME',
4271: p_token1_value => 'MARKET_PRICE',
4272: p_token2_name => 'VALUE',
4273: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.market_price),
4274: p_validation_id => PO_VAL_CONSTANTS.c_market_price_null,
4275: x_results => x_results,
4276: x_result_type => l_result_type);
4277: END IF;
4278:
4593: PO_VALIDATION_HELPER.terms_id(p_calling_module => p_calling_program,
4594: p_terms_id_tbl => p_line_locations.terms_id,
4595: p_entity_id_tbl => p_line_locations.interface_id,
4596: p_entity_type => c_entity_type_line_location,
4597: p_validation_id => PO_VAL_CONSTANTS.c_terms_id_line_loc,
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
4815: p_item_id_tbl => p_line_locations.item_id,
4816: p_item_tbl => p_line_locations.item,
4817: p_organization_id_tbl => p_line_locations.ship_to_organization_id,
4818: p_create_or_update_item_flag => l_create_or_update_item,
4819: p_validation_id => PO_VAL_CONSTANTS.c_loc_preferred_grade,
4820: x_results => x_results,
4821: x_result_set_id => l_result_set_id,
4822: x_result_type => l_result_type);
4823: WHEN c_firm_flag_null THEN
4830: p_token1_name => 'COLUMN_NAME',
4831: p_token1_value => 'FIRM_FLAG',
4832: p_token2_name => 'VALUE',
4833: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.firm_status_lookup_code),
4834: p_validation_id => PO_VAL_CONSTANTS.c_firm_flag_null,
4835: x_results => x_results,
4836: x_result_type => l_result_type);
4837: WHEN c_freight_carrier_null THEN
4838: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4844: p_token1_name => 'COLUMN_NAME',
4845: p_token1_value => 'FREIGHT_CARRIER',
4846: p_token2_name => 'VALUE',
4847: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.freight_carrier),
4848: p_validation_id => PO_VAL_CONSTANTS.c_freight_carrier_null,
4849: x_results => x_results,
4850: x_result_type => l_result_type);
4851: WHEN c_fob_lookup_code_null THEN
4852: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4858: p_token1_name => 'COLUMN_NAME',
4859: p_token1_value => 'FOB_LOOKUP_CODE',
4860: p_token2_name => 'VALUE',
4861: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.fob_lookup_code),
4862: p_validation_id => PO_VAL_CONSTANTS.c_fob_lookup_code_null,
4863: x_results => x_results,
4864: x_result_type => l_result_type);
4865: WHEN c_freight_terms_lookup_null THEN
4866: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4872: p_token1_name => 'COLUMN_NAME',
4873: p_token1_value => 'FREIGHT_TERMS_LOOKUP_CODE',
4874: p_token2_name => 'VALUE',
4875: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.freight_terms_lookup_code),
4876: p_validation_id => PO_VAL_CONSTANTS.c_freight_terms_null,
4877: x_results => x_results,
4878: x_result_type => l_result_type);
4879: WHEN c_qty_rcv_tolerance_null THEN
4880: IF l_create_or_update_item <> 'Y' THEN
4887: p_token1_name => 'COLUMN_NAME',
4888: p_token1_value => 'QTY_RCV_TOLERANCE',
4889: p_token2_name => 'VALUE',
4890: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.qty_rcv_tolerance),
4891: p_validation_id => PO_VAL_CONSTANTS.c_qty_rcv_tolerance_null,
4892: x_results => x_results,
4893: x_result_type => l_result_type);
4894: END IF;
4895: WHEN c_receipt_required_flag_null THEN
4903: p_token1_name => 'COLUMN_NAME',
4904: p_token1_value => 'RECEIPT_REQUIRED_FLAG',
4905: p_token2_name => 'VALUE',
4906: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receipt_required_flag),
4907: p_validation_id => PO_VAL_CONSTANTS.c_receipt_reqd_flag_null,
4908: x_results => x_results,
4909: x_result_type => l_result_type);
4910: END IF;
4911: WHEN c_inspection_reqd_flag_null THEN
4915: p_entity_id_tbl => p_line_locations.interface_id,
4916: p_entity_type => c_entity_type_line_location,
4917: p_column_name => 'INSPECTION_REQUIRED_FLAG',
4918: p_message_name => 'PO_PDOI_COLUMN_NULL',
4919: p_validation_id => PO_VAL_CONSTANTS.c_inspection_reqd_flag_null,
4920: x_results => x_results,
4921: x_result_type => l_result_type);
4922: END IF;
4923: WHEN c_receipt_days_exception_null THEN
4931: p_token1_name => 'COLUMN_NAME',
4932: p_token1_value => 'RECEIPT_DAYS_EXCEPTION_CODE',
4933: p_token2_name => 'VALUE',
4934: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receipt_days_exception_code),
4935: p_validation_id => PO_VAL_CONSTANTS.c_receipt_days_except_null,
4936: x_results => x_results,
4937: x_result_type => l_result_type);
4938: END IF;
4939: WHEN c_invoice_close_toler_null THEN
4947: p_token1_name => 'COLUMN_NAME',
4948: p_token1_value => 'INVOICE_CLOSE_TOLERANCE',
4949: p_token2_name => 'VALUE',
4950: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.invoice_close_tolerance),
4951: p_validation_id => PO_VAL_CONSTANTS.c_invoice_close_toler_null,
4952: x_results => x_results,
4953: x_result_type => l_result_type);
4954: END IF;
4955: WHEN c_receive_close_toler_null THEN
4963: p_token1_name => 'COLUMN_NAME',
4964: p_token1_value => 'RECEIVE_CLOSE_TOLERANCE',
4965: p_token2_name => 'VALUE',
4966: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receive_close_tolerance),
4967: p_validation_id => PO_VAL_CONSTANTS.c_receive_close_toler_null,
4968: x_results => x_results,
4969: x_result_type => l_result_type);
4970: END IF;
4971: WHEN c_days_early_rcpt_allowed_null THEN
4979: p_token1_name => 'COLUMN_NAME',
4980: p_token1_value => 'DAYS_EARLY_RECEIPT_ALLOWED',
4981: p_token2_name => 'VALUE',
4982: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.days_early_receipt_allowed),
4983: p_validation_id => PO_VAL_CONSTANTS.c_days_early_rcpt_allowed_null,
4984: x_results => x_results,
4985: x_result_type => l_result_type);
4986: END IF;
4987: WHEN c_days_late_rcpt_allowed_null THEN
4995: p_token1_name => 'COLUMN_NAME',
4996: p_token1_value => 'DAYS_LATE_RECEIPT_ALLOWED',
4997: p_token2_name => 'VALUE',
4998: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.days_late_receipt_allowed),
4999: p_validation_id => PO_VAL_CONSTANTS.c_days_late_rcpt_allowed_null,
5000: x_results => x_results,
5001: x_result_type => l_result_type);
5002: END IF;
5003: WHEN c_enfrce_ship_to_loc_code_null THEN
5011: p_token1_name => 'COLUMN_NAME',
5012: p_token1_value => 'ENFORCE_SHIP_TO_LOCATION_CODE',
5013: p_token2_name => 'VALUE',
5014: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.enforce_ship_to_location_code),
5015: p_validation_id => PO_VAL_CONSTANTS.c_enforce_shipto_loc_code_null,
5016: x_results => x_results,
5017: x_result_type => l_result_type);
5018: END IF;
5019: WHEN c_allow_sub_receipts_flag_null THEN
5027: p_token1_name => 'COLUMN_NAME',
5028: p_token1_value => 'ALLOW_SUBSTITUTE_RECEIPTS_FLAG',
5029: p_token2_name => 'VALUE',
5030: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.allow_substitute_receipts_flag),
5031: p_validation_id => PO_VAL_CONSTANTS.c_allow_sub_receipts_flag_null,
5032: x_results => x_results,
5033: x_result_type => l_result_type);
5034: END IF;
5035: WHEN c_receiving_routing_null THEN
5043: p_token1_name => 'COLUMN_NAME',
5044: p_token1_value => 'RECEIVING_ROUTING_ID',
5045: p_token2_name => 'VALUE',
5046: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receiving_routing_id),
5047: p_validation_id => PO_VAL_CONSTANTS.c_receiving_routing_null,
5048: x_results => x_results,
5049: x_result_type => l_result_type);
5050: END IF;
5051: WHEN c_need_by_date_null THEN
5058: p_token1_name => 'COLUMN_NAME',
5059: p_token1_value => 'NEED_BY_DATE',
5060: p_token2_name => 'VALUE',
5061: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.need_by_date),
5062: p_validation_id => PO_VAL_CONSTANTS.c_need_by_date_null,
5063: x_results => x_results,
5064: x_result_type => l_result_type);
5065: WHEN c_promised_date_null THEN
5066: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
5072: p_token1_name => 'COLUMN_NAME',
5073: p_token1_value => 'PROMISED_DATE',
5074: p_token2_name => 'VALUE',
5075: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.promised_date),
5076: p_validation_id => PO_VAL_CONSTANTS.c_promised_date_null,
5077: x_results => x_results,
5078: x_result_type => l_result_type);
5079:
5080:
5968: p_entity_id_tbl => p_po_line_ucas.PO_LINE_UCA_ID,
5969: p_entity_type => c_entity_type_LINE_UCAS,
5970: p_column_name => 'UNDEF_AMOUNT',
5971: p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO,
5972: p_validation_id => PO_VAL_CONSTANTS.c_undef_amt_gt_zero,
5973: x_results => x_results,
5974: x_result_type => l_result_type);
5975:
5976: WHEN c_lgl_gt_zero THEN
5980: p_entity_id_tbl => p_po_line_ucas.PO_LINE_UCA_ID,
5981: p_entity_type => c_entity_type_LINE_UCAS,
5982: p_column_name => 'LIMIT_GOV_LIABILITY_AMT',
5983: p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO,
5984: p_validation_id => PO_VAL_CONSTANTS.c_lgl_gt_zero,
5985: x_results => x_results,
5986: x_result_type => l_result_type);
5987:
5988: WHEN c_nte_gt_zero THEN
5992: p_entity_id_tbl => p_po_line_ucas.PO_LINE_UCA_ID,
5993: p_entity_type => c_entity_type_LINE_UCAS,
5994: p_column_name => 'NOT_TO_EXCEED_AMOUNT',
5995: p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO,
5996: p_validation_id => PO_VAL_CONSTANTS.c_nte_gt_zero,
5997: x_results => x_results,
5998: x_result_type => l_result_type);
5999: WHEN c_lgl_le_nte THEN
6000: PO_VALIDATION_HELPER.num1_less_or_equal_num2(