188: , p_value_tbl => p_price_update_tol_tbl
189: , p_entity_id_tbl => p_header_id_tbl
190: , p_entity_type => c_entity_type_HEADER
191: , p_column_name => c_PRICE_UPDATE_TOLERANCE
192: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
193: , x_results => x_results
194: , x_result_type => x_result_type
195: );
196:
216: , p_value_tbl => p_amount_limit_tbl
217: , p_entity_id_tbl => p_header_id_tbl
218: , p_entity_type => c_entity_type_HEADER
219: , p_column_name => c_AMOUNT_LIMIT
220: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
221: , x_results => x_results
222: , x_result_type => x_result_type
223: );
224:
251: WHERE style_id = p_style_id_tbl(p_style_id_tbl.COUNT);
252:
253:
254: IF l_is_clm_po LIKE 'Y' THEN
255: l_message_name := PO_MESSAGE_S.PO_IDV_AMT_LIMIT_CK_FAILED;
256: ELSE
257: l_message_name := PO_MESSAGE_S.PO_PO_AMT_LIMIT_CK_FAILED;
258: END IF ;
259: --End Bug 12660599
253:
254: IF l_is_clm_po LIKE 'Y' THEN
255: l_message_name := PO_MESSAGE_S.PO_IDV_AMT_LIMIT_CK_FAILED;
256: ELSE
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(
292: , p_value_tbl => p_blanket_total_amount_tbl
293: , p_entity_id_tbl => p_header_id_tbl
294: , p_entity_type => c_entity_type_HEADER
295: , p_column_name => c_BLANKET_TOTAL_AMOUNT
296: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
297: , x_results => x_results
298: , x_result_type => x_result_type
299: );
300:
338: x_results.add_result(
339: p_entity_type => c_entity_type_HEADER
340: , p_entity_id => p_header_id_tbl(i)
341: , p_column_name => c_BLANKET_TOTAL_AMOUNT
342: , p_message_name => PO_MESSAGE_S.PO_AMT_LMT_NOT_NULL
343: );
344: END IF;
345: END LOOP;
346:
404: , c_entity_type_HEADER
405: , p_header_id_tbl(i)
406: , c_VENDOR_ID
407: , TO_CHAR(p_vendor_id_tbl(i))
408: , PO_MESSAGE_S.PO_PO_VENDOR_ON_HOLD
409: FROM
410: PO_VENDORS SUPPLIER
411: WHERE
412: SUPPLIER.vendor_id = p_vendor_id_tbl(i)
455: , p_value_tbl => p_rate_tbl
456: , p_entity_id_tbl => p_header_id_tbl
457: , p_entity_type => c_entity_type_HEADER
458: , p_column_name => c_RATE
459: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
460: , x_results => x_results
461: , x_result_type => x_result_type
462: );
463:
523: x_results.add_result(
524: p_entity_type => c_entity_type_HEADER
525: , p_entity_id => p_header_id_tbl(i)
526: , p_column_name => c_RATE_TYPE
527: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
528: );
529: END IF;
530:
531: IF (p_rate_date_tbl(i) IS NULL) THEN
532: x_results.add_result(
533: p_entity_type => c_entity_type_HEADER
534: , p_entity_id => p_header_id_tbl(i)
535: , p_column_name => c_RATE_DATE
536: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
537: );
538: END IF;
539:
540: IF (p_rate_type_tbl(i) <> c_User AND p_rate_tbl(i) IS NULL) THEN
541: x_results.add_result(
542: p_entity_type => c_entity_type_HEADER
543: , p_entity_id => p_header_id_tbl(i)
544: , p_column_name => NULL
545: , p_message_name => PO_MESSAGE_S.PO_HTML_NO_RATE_DEFINED
546: );
547: ELSIF (p_rate_tbl(i) IS NULL) THEN
548: x_results.add_result(
549: p_entity_type => c_entity_type_HEADER
548: x_results.add_result(
549: p_entity_type => c_entity_type_HEADER
550: , p_entity_id => p_header_id_tbl(i)
551: , p_column_name => c_RATE
552: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
553: );
554: END IF;
555:
556: END IF;
617: x_results.add_result(
618: p_entity_type => c_entity_type_HEADER
619: , p_entity_id => p_header_id_tbl(i)
620: , p_column_name => c_EMAIL_ADDRESS
621: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
622: );
623: ELSIF ((p_supplier_notif_method_tbl(i) = c_FAX) AND
624: (p_fax_tbl(i) IS NULL)) THEN
625: x_results.add_result(
625: x_results.add_result(
626: p_entity_type => c_entity_type_HEADER
627: , p_entity_id => p_header_id_tbl(i)
628: , p_column_name => c_FAX
629: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
630: );
631: END IF;
632:
633: END LOOP;
669: l_message_name VARCHAR2(100);
670: BEGIN
671:
672: IF PO_CLM_CLO_UTIL.isCLMInstalled THEN
673: l_message_name := PO_MESSAGE_S.PO_IDV_ORD_ST_DT_LT_END_DT_CLM;
674: ELSE
675: l_message_name := PO_MESSAGE_S.PO_ALL_DATE_BETWEEN_START_END;
676: END IF;
677:
671:
672: IF PO_CLM_CLO_UTIL.isCLMInstalled THEN
673: l_message_name := PO_MESSAGE_S.PO_IDV_ORD_ST_DT_LT_END_DT_CLM;
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
733: , c_entity_type_HEADER
734: , p_header_id_tbl(i)
735: , c_START_DATE
736: , TO_CHAR(p_start_date_tbl(i))
737: , PO_MESSAGE_S.PO_CONTRACT_ST_LT_REF_CR
738: FROM DUAL
739: WHERE p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
740: AND EXISTS
741: (
816: , c_entity_type_HEADER
817: , p_header_id_tbl(i)
818: , c_START_DATE
819: , TO_CHAR(p_start_date_tbl(i))
820: , PO_MESSAGE_S.PO_IDV_EFF_DT_LT_ORD_ST_DT_CLM
821: FROM DUAL
822: WHERE p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
823: AND p_start_date_tbl(i) < p_clm_effective_date_tbl(i);
824:
890: , c_entity_type_HEADER
891: , p_header_id_tbl(i)
892: , c_AMOUNT_LIMIT
893: , TO_CHAR(p_amount_limit_tbl(i))
894: , PO_MESSAGE_S.PO_IDV_MX_CL_AMT_GT_RLSD_CLM
895: FROM DUAL
896: WHERE p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
897: AND p_amount_limit_tbl(i) < p_min_grnt_awd_amt_tbl(i);
898:
964: , c_entity_type_HEADER
965: , p_header_id_tbl(i)
966: , c_AMOUNT_LIMIT
967: , TO_CHAR(p_amount_limit_tbl(i))
968: , PO_MESSAGE_S.PO_IDV_MX_CL_AMT_GT_MNPM_CLM
969: FROM DUAL
970: WHERE p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
971: AND p_amount_limit_tbl(i) < p_min_order_amt_tbl(i);
972:
1037: , c_entity_type_HEADER
1038: , p_header_id_tbl(i)
1039: , c_AMOUNT_LIMIT
1040: , TO_CHAR(p_amount_limit_tbl(i))
1041: , PO_MESSAGE_S.PO_IDV_MX_CL_AMT_GT_MXPM_CLM
1042: FROM DUAL
1043: WHERE p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
1044: AND p_amount_limit_tbl(i) < p_max_order_amt_tbl(i);
1045:
1093: ,p_value_tbl => p_min_guar_perc_tbl
1094: ,p_entity_id_tbl => p_header_id_tbl
1095: ,p_entity_type => c_ENTITY_TYPE_HEADER
1096: ,p_column_name => c_MIN_GUAR_PERC
1097: ,p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT
1098: ,x_results => x_results
1099: ,x_result_type => x_result_type
1100: );
1101:
1149: , c_entity_type_HEADER
1150: , p_header_id_tbl(i)
1151: , c_CLM_MAX_ORD_AMT
1152: , TO_CHAR(p_max_order_amt_tbl(i))
1153: , PO_MESSAGE_S.PO_IDV_MX_OD_AMT_GT_MN_OD_CLM
1154: FROM DUAL
1155: WHERE p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
1156: AND p_max_order_amt_tbl(i) < p_min_order_amt_tbl(i);
1157:
1223: , c_entity_type_HEADER
1224: , p_header_id_tbl(i)
1225: , decode(nvl(p_document_format_tbl(i), '*'), '*', c_CLM_DOCUMENT_FORMAT, c_CLM_STANDARD_FORM)
1226: , null
1227: , PO_MESSAGE_S.PO_PRINT_FORM_FORMAT_INVALID
1228: FROM PO_DOC_STYLE_HEADERS PDSH
1229: WHERE PDSH.style_id = p_style_id_tbl(i)
1230: AND nvl(clm_flag, 'N') ='Y'
1231: AND NOT EXISTS (
1306: , c_entity_type_HEADER
1307: , p_header_id_tbl(i)
1308: , c_END_DATE
1309: , TO_CHAR(p_end_date_tbl(i))
1310: , PO_MESSAGE_S.PO_CONTRACT_ST_GT_REF_CR
1311: FROM DUAL
1312: WHERE
1313: p_type_lookup_code_tbl(i) IN (c_CONTRACT,c_BLANKET)
1314: AND EXISTS
1390: , c_entity_type_HEADER
1391: , p_header_id_tbl(i)
1392: , c_START_DATE
1393: , TO_CHAR(p_start_date_tbl(i))
1394: , PO_MESSAGE_S.PO_CONTRACT_ST_LT_REF_CR
1395: FROM DUAL
1396: WHERE
1397: p_type_lookup_code_tbl(i) = c_CONTRACT
1398: AND EXISTS
1474: , c_entity_type_HEADER
1475: , p_header_id_tbl(i)
1476: , c_END_DATE
1477: , TO_CHAR(p_end_date_tbl(i))
1478: , PO_MESSAGE_S.PO_CONTRACT_ST_GT_REF_CR
1479: FROM DUAL
1480: WHERE
1481: p_type_lookup_code_tbl(i) = c_CONTRACT
1482: AND EXISTS
1625: p_entity_type => c_entity_type_HEADER
1626: , p_entity_id => l_header_id_tbl(i)
1627: , p_column_name => c_SEGMENT1
1628: , p_column_val => l_segment1_tbl(i)
1629: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_NUMERIC
1630: );
1631: END;
1632: END LOOP;
1633:
1854: p_entity_type => c_entity_type_HEADER
1855: , p_entity_id => l_header_id_tbl(i)
1856: , p_column_name => c_SEGMENT1
1857: , p_column_val => l_segment1_tbl(i)
1858: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_UNIQUE_VAL
1859: );
1860: END IF;
1861: END LOOP;
1862:
1922:
1923: -- Check that the line's Expiration date is within the
1924: -- Effective From and To dates of the agreement.
1925:
1926: l_message_name := PO_MESSAGE_S.POX_EXPIRATION_DATES;
1927:
1928: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
1929:
1930: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
1968:
1969: -- Check that the price break's Effective From date
1970: -- is before the Effective To date of the agreement.
1971:
1972: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES4;
1973:
1974: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
1975:
1976: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
2016:
2017: -- Check that the price break's Effective From date
2018: -- is after the Effective From date of the agreement.
2019:
2020: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES1;
2021:
2022: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
2023:
2024: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
2064:
2065: -- Check that the price break's Effective To date
2066: -- is before the Effective To date of the agreement.
2067:
2068: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES;
2069:
2070: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
2071:
2072: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
2112:
2113: -- Check that the price break's Effective To date
2114: -- is after the Effective From date of the agreement.
2115:
2116: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES5;
2117:
2118: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
2119:
2120: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
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
2191: , p_column_name => c_AGENT_ID
2192: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
2193: , x_results => x_results
2194: , x_result_type => x_result_type
2195: );
2196:
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
2217: , p_column_name => c_SHIP_TO_LOCATION_ID
2218: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
2219: , x_results => x_results
2220: , x_result_type => x_result_type
2221: );
2222:
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
2243: , p_column_name => c_VENDOR_ID
2244: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
2245: , x_results => x_results
2246: , x_result_type => x_result_type
2247: );
2248:
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
2269: , p_column_name => c_VENDOR_SITE_ID
2270: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
2271: , x_results => x_results
2272: , x_result_type => x_result_type
2273: );
2274:
2303: SELECT
2304: x_result_set_id
2305: , c_entity_type_HEADER
2306: , p_header_id_tbl(i)
2307: , PO_MESSAGE_S.PO_ALL_NOT_NULL
2308: , c_SEGMENT1
2309: FROM
2310: PO_SYSTEM_PARAMETERS_ALL
2311: WHERE
2446: column_val)
2447: SELECT x_result_set_id,
2448: c_entity_type_HEADER
2449: ,p_header_id_tbl(i)
2450: ,PO_MESSAGE_S.PO_MOD_EFFECT_DT_INVALID
2451: ,c_MOD_EFFECTIVE_DATE
2452: ,TO_CHAR(p_mod_eff_date_tbl(i))
2453: FROM DUAL
2454: WHERE p_mod_eff_date_tbl(i) is not NULL
2512: column_name)
2513: SELECT x_result_set_id,
2514: c_entity_type_HEADER
2515: ,p_header_id_tbl(i)
2516: ,PO_MESSAGE_S.PO_MOD_EFFECT_DT_NOTNULL
2517: ,c_MOD_EFFECTIVE_DATE
2518: FROM DUAL
2519: WHERE p_mod_eff_date_tbl(i) is NULL
2520: AND nvl(p_draft_type_tbl(i), '*') = 'MOD';
2570: column_val)
2571: SELECT x_result_set_id,
2572: c_entity_type_HEADER
2573: ,p_header_id_tbl(i)
2574: ,PO_MESSAGE_S.PO_MOD_CANCEL_INVALID
2575: ,c_CONTROL_ACTION
2576: ,TO_CHAR(p_control_action_tbl(i))
2577: FROM DUAL
2578: WHERE nvl(p_control_action_tbl(i), '*') = 'CANCEL'
2649: x_results.add_result(
2650: p_entity_type => c_entity_type_HEADER
2651: , p_entity_id => p_intf_header_id(i)
2652: , p_column_name => c_CLM_STANDARD_FORM
2653: , p_message_name => PO_MESSAGE_S.PO_PRINT_FORM_FORMAT_INVALID
2654: );
2655: l_results_count := l_results_count + 1;
2656: END;
2657: END IF;
2708: x_results.add_result(
2709: p_entity_type => c_entity_type_HEADER
2710: , p_entity_id => p_intf_header_id(i)
2711: , p_column_name => c_CLM_DOCUMENT_FORMAT
2712: , p_message_name => PO_MESSAGE_S.PO_PRINT_FORM_FORMAT_INVALID
2713: );
2714: l_results_count := l_results_count + 1;
2715: ELSE
2716: BEGIN
2729: x_results.add_result(
2730: p_entity_type => c_entity_type_HEADER
2731: , p_entity_id => p_intf_header_id(i)
2732: , p_column_name => c_CLM_STANDARD_FORM
2733: , p_message_name => PO_MESSAGE_S.PO_PRINT_FORM_FORMAT_INVALID
2734: );
2735: l_results_count := l_results_count + 1;
2736: END;
2737: END IF;
3223: x_results.add_result(
3224: p_entity_type => c_ENTITY_TYPE_HEADER
3225: , p_entity_id => l_intf_header_id_tbl(i)
3226: , p_column_name => c_STYLE_ID
3227: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
3228: );
3229: ELSE
3230: x_results.add_result(
3231: p_entity_type => c_ENTITY_TYPE_HEADER