[Home] [Help]
283: )
284: IS
285: BEGIN
286:
287: PO_VALIDATION_HELPER.greater_or_equal_zero(
288: p_calling_module => D_amt_agreed_ge_zero
289: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
290: , p_value_tbl => p_committed_amount_tbl
291: , p_entity_id_tbl => p_line_id_tbl
310: )
311: IS
312: BEGIN
313:
314: PO_VALIDATION_HELPER.greater_or_equal_zero(
315: p_calling_module => D_min_rel_amt_ge_zero
316: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
317: , p_value_tbl => p_min_release_amount_tbl
318: , p_entity_id_tbl => p_line_id_tbl
341: )
342: IS
343: BEGIN
344:
345: PO_VALIDATION_HELPER.gt_zero_order_type_filter(
346: p_calling_module => D_quantity_gt_zero
347: , p_value_tbl => p_quantity_tbl
348: , p_entity_id_tbl => p_line_id_tbl
349: , p_order_type_lookup_code_tbl => p_order_type_lookup_code_tbl
772: )
773: IS
774: BEGIN
775:
776: PO_VALIDATION_HELPER.amount_notif_ctrl_warning(
777: p_calling_module => D_quantity_notif_change
778: , p_line_id_tbl => p_line_id_tbl
779: , p_quantity_tbl => p_quantity_tbl
780: , p_column_name => c_QUANTITY
802: )
803: IS
804: BEGIN
805:
806: PO_VALIDATION_HELPER.gt_zero_order_type_filter(
807: p_calling_module => D_amount_gt_zero
808: , p_value_tbl => p_amount_tbl
809: , p_entity_id_tbl => p_line_id_tbl
810: , p_order_type_lookup_code_tbl => p_order_type_lookup_code_tbl
1167: )
1168: IS
1169: BEGIN
1170:
1171: PO_VALIDATION_HELPER.child_num_unique(
1172: p_calling_module => D_line_num_unique
1173: , p_entity_type => c_entity_type_LINE
1174: , p_entity_id_tbl => p_line_id_tbl
1175: , p_parent_id_tbl => p_header_id_tbl
1194: )
1195: IS
1196: BEGIN
1197:
1198: PO_VALIDATION_HELPER.greater_than_zero(
1199: p_calling_module => D_line_num_gt_zero
1200: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
1201: , p_value_tbl => p_line_num_tbl
1202: , p_entity_id_tbl => p_line_id_tbl
1340: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1341: RETURN;
1342: END IF;
1343:
1344: PO_VALIDATION_HELPER.start_date_le_end_date(
1345: p_calling_module => D_start_date_le_end_date
1346: , p_start_date_tbl => p_start_date_tbl
1347: , p_end_date_tbl => p_expiration_date_tbl
1348: , p_entity_id_tbl => p_line_id_tbl
1401: );
1402: END IF;
1403: END LOOP;
1404:
1405: PO_VALIDATION_HELPER.start_date_le_end_date
1406: (
1407: p_calling_module => D_start_date_le_end_date
1408: , p_start_date_tbl => p_start_date_tbl
1409: , p_end_date_tbl => p_expiration_date_tbl
1968: )
1969: IS
1970: BEGIN
1971:
1972: PO_VALIDATION_HELPER.no_timecards_exist(
1973: p_calling_module => D_otl_inv_start_date_change
1974: , p_line_id_tbl => p_line_id_tbl
1975: , p_start_date_tbl => p_start_date_tbl
1976: , p_expiration_date_tbl => NULL
2001: )
2002: IS
2003: BEGIN
2004:
2005: PO_VALIDATION_HELPER.no_timecards_exist(
2006: p_calling_module => D_otl_invalid_end_date_change
2007: , p_line_id_tbl => p_line_id_tbl
2008: , p_start_date_tbl => NULL
2009: , p_expiration_date_tbl => p_expiration_date_tbl
2066:
2067: l_line_id_tbl.trim(l_input_size-l_count);
2068: l_unit_price_tbl.trim(l_input_size-l_count);
2069:
2070: PO_VALIDATION_HELPER.greater_or_equal_zero(
2071: p_calling_module => d_mod
2072: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
2073: , p_value_tbl => l_unit_price_tbl
2074: , p_entity_id_tbl => l_line_id_tbl
2100: )
2101: IS
2102: BEGIN
2103:
2104: PO_VALIDATION_HELPER.greater_or_equal_zero(
2105: p_calling_module => D_list_price_ge_zero
2106: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
2107: , p_value_tbl => p_list_price_per_unit_tbl
2108: , p_entity_id_tbl => p_line_id_tbl
2127: )
2128: IS
2129: BEGIN
2130:
2131: PO_VALIDATION_HELPER.greater_or_equal_zero(
2132: p_calling_module => D_market_price_ge_zero
2133: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
2134: , p_value_tbl => p_market_price_tbl
2135: , p_entity_id_tbl => p_line_id_tbl
2267: )
2268: IS
2269: BEGIN
2270:
2271: PO_VALIDATION_HELPER.start_date_le_end_date(
2272: p_calling_module => D_expiration_ge_blanket_start
2273: , p_start_date_tbl => p_blanket_start_date_tbl
2274: , p_end_date_tbl => p_expiration_date_tbl
2275: , p_entity_id_tbl => p_line_id_tbl
2274: , p_end_date_tbl => p_expiration_date_tbl
2275: , p_entity_id_tbl => p_line_id_tbl
2276: , p_entity_type => c_entity_type_LINE
2277: , p_column_name => c_EXPIRATION_DATE
2278: , p_column_val_selector => PO_VALIDATION_HELPER.c_END_DATE
2279: , p_message_name => PO_MESSAGE_S.POX_EXPIRATION_DATES
2280: , x_results => x_results
2281: , x_result_type => x_result_type
2282: );
2299: )
2300: IS
2301: BEGIN
2302:
2303: PO_VALIDATION_HELPER.start_date_le_end_date(
2304: p_calling_module => D_expiration_le_blanket_end
2305: , p_start_date_tbl => p_expiration_date_tbl
2306: , p_end_date_tbl => p_blanket_end_date_tbl
2307: , p_entity_id_tbl => p_line_id_tbl
2306: , p_end_date_tbl => p_blanket_end_date_tbl
2307: , p_entity_id_tbl => p_line_id_tbl
2308: , p_entity_type => c_entity_type_LINE
2309: , p_column_name => c_EXPIRATION_DATE
2310: , p_column_val_selector => PO_VALIDATION_HELPER.c_START_DATE
2311: , p_message_name => PO_MESSAGE_S.POX_EXPIRATION_DATES
2312: , x_results => x_results
2313: , x_result_type => x_result_type
2314: );
2330: )
2331: IS
2332: BEGIN
2333:
2334: PO_VALIDATION_HELPER.within_percentage_range(
2335: p_calling_module => D_recoupment_rate_range_check
2336: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
2337: , p_value_tbl => p_recoupment_rate_tbl
2338: , p_entity_id_tbl => p_line_id_tbl
2353: )
2354: IS
2355: BEGIN
2356:
2357: PO_VALIDATION_HELPER.within_percentage_range(
2358: p_calling_module => D_retainage_rate_range_check
2359: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
2360: , p_value_tbl => p_retainage_rate_tbl
2361: , p_entity_id_tbl => p_line_id_tbl
2376: )
2377: IS
2378: BEGIN
2379:
2380: PO_VALIDATION_HELPER.within_percentage_range(
2381: p_calling_module => D_prog_pay_rate_range_check
2382: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
2383: , p_value_tbl => p_prog_pay_rate_tbl
2384: , p_entity_id_tbl => p_line_id_tbl
2657: )
2658: IS
2659: BEGIN
2660:
2661: PO_VALIDATION_HELPER.not_null(
2662: p_calling_module => D_item_description_not_null
2663: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_item_description_tbl)
2664: , p_entity_id_tbl => p_line_id_tbl
2665: , p_entity_type => c_entity_type_LINE
2710:
2711: l_line_id_tbl.trim(l_input_size-l_count);
2712: l_category_id_tbl.trim(l_input_size-l_count);
2713:
2714: PO_VALIDATION_HELPER.not_null(
2715: p_calling_module => D_category_id_not_null
2716: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(l_category_id_tbl)
2717: , p_entity_id_tbl => l_line_id_tbl
2718: , p_entity_type => c_entity_type_LINE
3008:
3009: l_line_id_tbl.trim(l_input_size-l_count);
3010: l_line_type_id_tbl.trim(l_input_size-l_count);
3011:
3012: PO_VALIDATION_HELPER.not_null(
3013: p_calling_module => D_line_type_id_not_null
3014: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(l_line_type_id_tbl)
3015: , p_entity_id_tbl => l_line_id_tbl
3016: , p_entity_type => c_entity_type_LINE
3124: FOR i IN 1 .. p_line_id_tbl.COUNT LOOP
3125: l_inv_org_id_tbl(i) := l_def_inv_org_id;
3126: END LOOP;
3127:
3128: PO_VALIDATION_HELPER.gt_zero_opm_filter(
3129: p_calling_module => D_line_sec_quantity_gt_zero
3130: , p_value_tbl => p_sec_quantity_tbl
3131: , p_entity_id_tbl => p_line_id_tbl
3132: , p_item_id_tbl => p_item_id_tbl
3190: FOR i IN 1 .. p_line_id_tbl.COUNT LOOP
3191: l_inv_org_id_tbl(i) := l_def_inv_org_id;
3192: END LOOP;
3193:
3194: PO_VALIDATION_HELPER.qtys_within_deviation (
3195: p_calling_module => D_line_qtys_within_deviation
3196: , p_entity_id_tbl => p_line_id_tbl
3197: , p_item_id_tbl => p_item_id_tbl
3198: , p_inv_org_id_tbl => l_inv_org_id_tbl
3314: )
3315: IS
3316: BEGIN
3317:
3318: PO_VALIDATION_HELPER.greater_or_equal_zero(
3319: p_calling_module => D_max_retain_amt_ge_zero
3320: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
3321: , p_value_tbl => p_max_retain_amt_tbl
3322: , p_entity_id_tbl => p_line_id_tbl
3928: -------------------------------------------------------------------------------
3929: -- This procedure validates:
3930: -- 1. line_num_display is unique.
3931: -- 2. SLIN numbers are in sync with CLIN numbers.
3932: -- NOTE: The logic has been copied from PO_VALIDATION_HELPER.child_num_unique.
3933: -------------------------------------------------------------------------------
3934: PROCEDURE clin_slin_num_check(
3935: p_header_id_tbl IN PO_TBL_NUMBER,
3936: p_draft_id_tbl IN PO_TBL_NUMBER,
3968: l_data_key := PO_CORE_S.get_session_gt_nextval();
3969:
3970: FOR i IN 1 .. l_parent_id_tbl.COUNT LOOP
3971: -- Extract Par Line ids of this line
3972: PO_VALIDATION_HELPER.extract_par_draft_id_tbl(p_par_draft_id_tbl(i),
3973: l_par_draft_id_tbl);
3974: INSERT INTO PO_SESSION_GT
3975: ( key
3976: , index_num1
5083: RETURN;
5084: END IF;
5085: END LOOP;
5086:
5087: PO_VALIDATION_HELPER.not_null(
5088: p_calling_module => D_validate_comments_not_null
5089: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_comments_tbl)
5090: , p_entity_id_tbl => p_line_id_tbl
5091: , p_entity_type => c_entity_type_LINE
5286: -- NOW CALLING VALIDATION API TO COMPARE THE NUMBERS
5287: --Bug 16385613 Begin
5288: IF l_po_line_uca_id_tbl.Count > 0 THEN
5289: IF l_po_draft_id_tbl(1) = -1 THEN -- IF BASE DOC
5290: PO_VALIDATION_HELPER.num1_less_or_equal_num2(
5291: p_calling_module => D_mod_undef_amt_le_line_amt
5292: , p_num1_tbl => l_undef_amt_tbl
5293: , p_num2_tbl => l_extended_price_tbl
5294: , p_entity_id_tbl => l_po_line_uca_id_tbl
5298: , x_results => x_results
5299: , x_result_type => x_result_type);
5300:
5301: ELSE --IF MOD DOC
5302: PO_VALIDATION_HELPER.num1_less_or_equal_num2(
5303: p_calling_module => D_mod_undef_amt_le_line_amt
5304: , p_num1_tbl => l_undef_amt_tbl
5305: , p_num2_tbl => l_extended_price_tbl
5306: , p_entity_id_tbl => l_po_line_uca_id_tbl