[Home] [Help]
181: )
182: IS
183: BEGIN
184:
185: PO_VALIDATION_HELPER.greater_or_equal_zero(
186: p_calling_module => D_price_update_tol_ge_zero
187: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
188: , p_value_tbl => p_price_update_tol_tbl
189: , p_entity_id_tbl => p_header_id_tbl
209: )
210: IS
211: BEGIN
212:
213: PO_VALIDATION_HELPER.greater_or_equal_zero(
214: p_calling_module => D_amount_limit_ge_zero
215: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
216: , p_value_tbl => p_amount_limit_tbl
217: , p_entity_id_tbl => p_header_id_tbl
257: l_message_name := PO_MESSAGE_S.PO_PO_AMT_LIMIT_CK_FAILED;
258: END IF ;
259: --End Bug 12660599
260:
261: PO_VALIDATION_HELPER.num1_less_or_equal_num2(
262: p_calling_module => D_amt_limit_ge_amt_agreed
263: , p_num1_tbl => p_blanket_total_amount_tbl
264: , p_num2_tbl => p_amount_limit_tbl
265: , p_entity_id_tbl => p_header_id_tbl
285: )
286: IS
287: BEGIN
288:
289: PO_VALIDATION_HELPER.greater_or_equal_zero(
290: p_calling_module => D_amount_agreed_ge_zero
291: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
292: , p_value_tbl => p_blanket_total_amount_tbl
293: , p_entity_id_tbl => p_header_id_tbl
448: )
449: IS
450: BEGIN
451:
452: PO_VALIDATION_HELPER.greater_than_zero(
453: p_calling_module => D_rate_gt_zero
454: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
455: , p_value_tbl => p_rate_tbl
456: , p_entity_id_tbl => p_header_id_tbl
674: ELSE
675: l_message_name := PO_MESSAGE_S.PO_ALL_DATE_BETWEEN_START_END;
676: END IF;
677:
678: PO_VALIDATION_HELPER.start_date_le_end_date(
679: p_calling_module => D_effective_le_expiration
680: , p_start_date_tbl => p_start_date_tbl
681: , p_end_date_tbl => p_end_date_tbl
682: , p_entity_id_tbl => p_header_id_tbl
681: , p_end_date_tbl => p_end_date_tbl
682: , p_entity_id_tbl => p_header_id_tbl
683: , p_entity_type => c_entity_type_HEADER
684: , p_column_name => c_END_DATE
685: , p_column_val_selector => PO_VALIDATION_HELPER.c_END_DATE
686: , p_message_name => l_message_name
687: , x_results => x_results
688: , x_result_type => x_result_type
689: );
1086: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1087: RETURN;
1088: END IF;
1089:
1090: PO_VALIDATION_HELPER.within_percentage_range(
1091: p_calling_module => D_min_guar_perc_range_check
1092: ,p_null_allowed_flag => PO_CORE_S.g_parameter_YES
1093: ,p_value_tbl => p_min_guar_perc_tbl
1094: ,p_entity_id_tbl => p_header_id_tbl
2182: )
2183: IS
2184: BEGIN
2185:
2186: PO_VALIDATION_HELPER.not_null(
2187: p_calling_module => D_agent_id_not_null
2188: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_agent_id_tbl)
2189: , p_entity_id_tbl => p_header_id_tbl
2190: , p_entity_type => c_entity_type_HEADER
2208: )
2209: IS
2210: BEGIN
2211:
2212: PO_VALIDATION_HELPER.not_null(
2213: p_calling_module => D_ship_to_loc_not_null
2214: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_ship_to_loc_id_tbl)
2215: , p_entity_id_tbl => p_header_id_tbl
2216: , p_entity_type => c_entity_type_HEADER
2234: )
2235: IS
2236: BEGIN
2237:
2238: PO_VALIDATION_HELPER.not_null(
2239: p_calling_module => D_vendor_id_not_null
2240: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_vendor_id_tbl)
2241: , p_entity_id_tbl => p_header_id_tbl
2242: , p_entity_type => c_entity_type_HEADER
2260: )
2261: IS
2262: BEGIN
2263:
2264: PO_VALIDATION_HELPER.not_null(
2265: p_calling_module => D_vendor_site_id_not_null
2266: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_vendor_site_id_tbl)
2267: , p_entity_id_tbl => p_header_id_tbl
2268: , p_entity_type => c_entity_type_HEADER