DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS dependencies on PO_VALIDATION_HELPER

Line 155: PO_VALIDATION_HELPER.greater_or_equal_zero(

151: )
152: IS
153: BEGIN
154:
155: PO_VALIDATION_HELPER.greater_or_equal_zero(
156: p_calling_module => D_days_early_gte_zero
157: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
158: , p_value_tbl => p_days_early_rcpt_allowed_tbl
159: , p_entity_id_tbl => p_line_loc_id_tbl

Line 182: PO_VALIDATION_HELPER.greater_or_equal_zero(

178: )
179: IS
180: BEGIN
181:
182: PO_VALIDATION_HELPER.greater_or_equal_zero(
183: p_calling_module => D_days_late_gte_zero
184: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
185: , p_value_tbl => p_days_late_rcpt_allowed_tbl
186: , p_entity_id_tbl => p_line_loc_id_tbl

Line 210: PO_VALIDATION_HELPER.within_percentage_range(

206: )
207: IS
208: BEGIN
209:
210: PO_VALIDATION_HELPER.within_percentage_range(
211: p_calling_module => D_rcv_close_tol_within_range
212: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
213: , p_value_tbl => p_receive_close_tolerance_tbl
214: , p_entity_id_tbl => p_line_loc_id_tbl

Line 237: PO_VALIDATION_HELPER.within_percentage_range(

233: )
234: IS
235: BEGIN
236:
237: PO_VALIDATION_HELPER.within_percentage_range(
238: p_calling_module => D_over_rcpt_tol_within_range
239: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
240: , p_value_tbl => p_qty_rcv_tolerance_tbl
241: , p_entity_id_tbl => p_line_loc_id_tbl

Line 438: PO_VALIDATION_HELPER.within_percentage_range(

434: )
435: IS
436: BEGIN
437:
438: PO_VALIDATION_HELPER.within_percentage_range(
439: p_calling_module => D_inv_close_tol_range_check
440: , p_null_allowed_flag => PO_CORE_S.g_parameter_YES
441: , p_value_tbl => p_invoice_close_tolerance_tbl
442: , p_entity_id_tbl => p_line_loc_id_tbl

Line 470: PO_VALIDATION_HELPER.open_period(

466: )
467: IS
468: BEGIN
469:
470: PO_VALIDATION_HELPER.open_period(
471: p_calling_module => D_need_by_date_open_per_check
472: , p_date_tbl => p_need_by_date_tbl
473: , p_org_id_tbl => p_org_id_tbl
474: , p_entity_id_tbl => p_line_loc_id_tbl

Line 504: PO_VALIDATION_HELPER.open_period(

500: )
501: IS
502: BEGIN
503:
504: PO_VALIDATION_HELPER.open_period(
505: p_calling_module => D_promise_date_open_per_check
506: , p_date_tbl => p_promised_date_tbl
507: , p_org_id_tbl => p_org_id_tbl
508: , p_entity_id_tbl => p_line_loc_id_tbl

Line 569: PO_VALIDATION_HELPER.not_null(

565:
566: l_line_loc_id_tbl.trim(l_input_size-l_count);
567: l_ship_to_org_id_tbl.trim(l_input_size-l_count);
568:
569: PO_VALIDATION_HELPER.not_null(
570: p_calling_module => d_mod
571: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(l_ship_to_org_id_tbl)
572: , p_entity_id_tbl => l_line_loc_id_tbl
573: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION

Line 637: PO_VALIDATION_HELPER.not_null(

633:
634: l_line_loc_id_tbl.trim(l_input_size-l_count);
635: l_ship_to_loc_id_tbl.trim(l_input_size-l_count);
636:
637: PO_VALIDATION_HELPER.not_null(
638: p_calling_module => d_mod
639: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(l_ship_to_loc_id_tbl)
640: , p_entity_id_tbl => l_line_loc_id_tbl
641: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION

Line 694: PO_VALIDATION_HELPER.greater_than_zero(

690: END LOOP;
691:
692: --: only pass in the filtered
693: --list of line locations
694: PO_VALIDATION_HELPER.greater_than_zero(
695: p_calling_module => D_ship_num_gt_zero
696: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
697: , p_value_tbl => l_shipment_num_tbl --
698: , p_entity_id_tbl => l_line_loc_id_tbl --

Line 727: PO_VALIDATION_HELPER.child_num_unique(

723: )
724: IS
725: BEGIN
726:
727: PO_VALIDATION_HELPER.child_num_unique(
728: p_calling_module => D_ship_num_unique_check
729: , p_entity_type => c_entity_type_LINE_LOCATION
730: , p_entity_id_tbl => p_line_loc_id_tbl
731: , p_parent_id_tbl => p_line_id_tbl

Line 961: PO_VALIDATION_HELPER.greater_or_equal_zero(

957: END IF;
958:
959: IF l_is_clm_po = 'Y'
960: THEN
961: PO_VALIDATION_HELPER.greater_or_equal_zero(
962: p_calling_module => d_mod
963: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
964: , p_value_tbl => l_quantity_tbl
965: , p_entity_id_tbl => l_line_loc_id_tbl

Line 975: PO_VALIDATION_HELPER.greater_than_zero(

971: );
972:
973: ELSE
974:
975: PO_VALIDATION_HELPER.greater_than_zero(
976: p_calling_module => d_mod
977: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
978: , p_value_tbl => l_quantity_tbl
979: , p_entity_id_tbl => l_line_loc_id_tbl

Line 1189: PO_VALIDATION_HELPER.greater_or_equal_zero(

1185: END IF;
1186:
1187: IF l_is_clm_po = 'Y'
1188: THEN
1189: PO_VALIDATION_HELPER.greater_or_equal_zero(
1190: p_calling_module => d_mod
1191: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
1192: , p_value_tbl => l_amount_tbl
1193: , p_entity_id_tbl => l_line_loc_id_tbl

Line 1203: PO_VALIDATION_HELPER.greater_than_zero(

1199: );
1200:
1201: ELSE
1202:
1203: PO_VALIDATION_HELPER.greater_than_zero(
1204: p_calling_module => d_mod
1205: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
1206: , p_value_tbl => l_amount_tbl
1207: , p_entity_id_tbl => l_line_loc_id_tbl

Line 1355: PO_VALIDATION_HELPER.gt_zero_opm_filter(

1351: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1352: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1353: END IF;
1354:
1355: PO_VALIDATION_HELPER.gt_zero_opm_filter(
1356: p_calling_module => D_ship_sec_quantity_gt_zero
1357: , p_value_tbl => p_sec_quantity_tbl
1358: , p_entity_id_tbl => p_line_loc_id_tbl
1359: , p_item_id_tbl => p_item_id_tbl

Line 1405: PO_VALIDATION_HELPER.qtys_within_deviation (

1401: PO_LOG.proc_begin(d_mod,'p_sec_quantity_tbl',p_sec_quantity_tbl);
1402: PO_LOG.log(PO_LOG.c_PROC_BEGIN,d_mod,NULL,'x_results',x_results);
1403: END IF;
1404:
1405: PO_VALIDATION_HELPER.qtys_within_deviation (
1406: p_calling_module => D_ship_qtys_within_deviation
1407: , p_entity_id_tbl => p_line_loc_id_tbl
1408: , p_item_id_tbl => p_item_id_tbl
1409: , p_inv_org_id_tbl => p_ship_to_org_id_tbl

Line 1602: PO_VALIDATION_HELPER.start_date_le_end_date

1598: IF (l_results_count < x_results.result_type.COUNT) THEN
1599: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1600: ELSE
1601: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1602: PO_VALIDATION_HELPER.start_date_le_end_date
1603: (
1604: p_calling_module => D_start_date_le_end_date
1605: , p_start_date_tbl => p_start_date_tbl
1606: , p_end_date_tbl => p_expiration_date_tbl

Line 1719: PO_VALIDATION_HELPER.greater_than_zero(

1715:
1716: l_line_loc_id_tbl.trim(l_input_size-l_count);
1717: l_price_override_tbl.trim(l_input_size-l_count);
1718:
1719: PO_VALIDATION_HELPER.greater_than_zero(
1720: p_calling_module => D_complex_price_or_gt_zero
1721: , p_null_allowed_flag => PO_CORE_S.g_parameter_NO
1722: , p_value_tbl => l_price_override_tbl
1723: , p_entity_id_tbl => l_line_loc_id_tbl