DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS dependencies on PO_MESSAGE_S

Line 192: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

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:

Line 220: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

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:

Line 255: l_message_name := PO_MESSAGE_S.PO_IDV_AMT_LIMIT_CK_FAILED;

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

Line 257: l_message_name := PO_MESSAGE_S.PO_PO_AMT_LIMIT_CK_FAILED;

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(

Line 296: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

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:

Line 342: , p_message_name => PO_MESSAGE_S.PO_AMT_LMT_NOT_NULL

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:

Line 408: , PO_MESSAGE_S.PO_PO_VENDOR_ON_HOLD

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)

Line 459: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

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:

Line 527: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

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

Line 536: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

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

Line 545: , p_message_name => PO_MESSAGE_S.PO_HTML_NO_RATE_DEFINED

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

Line 552: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

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;

Line 621: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

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(

Line 629: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

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;

Line 673: l_message_name := PO_MESSAGE_S.PO_IDV_ORD_ST_DT_LT_END_DT_CLM;

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:

Line 675: l_message_name := PO_MESSAGE_S.PO_ALL_DATE_BETWEEN_START_END;

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

Line 737: , PO_MESSAGE_S.PO_CONTRACT_ST_LT_REF_CR

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: (

Line 820: , PO_MESSAGE_S.PO_IDV_EFF_DT_LT_ORD_ST_DT_CLM

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:

Line 894: , PO_MESSAGE_S.PO_IDV_MX_CL_AMT_GT_RLSD_CLM

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:

Line 968: , PO_MESSAGE_S.PO_IDV_MX_CL_AMT_GT_MNPM_CLM

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:

Line 1041: , PO_MESSAGE_S.PO_IDV_MX_CL_AMT_GT_MXPM_CLM

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:

Line 1097: ,p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT

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:

Line 1153: , PO_MESSAGE_S.PO_IDV_MX_OD_AMT_GT_MN_OD_CLM

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:

Line 1227: , PO_MESSAGE_S.PO_PRINT_FORM_FORMAT_INVALID

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 (

Line 1310: , PO_MESSAGE_S.PO_CONTRACT_ST_GT_REF_CR

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

Line 1394: , PO_MESSAGE_S.PO_CONTRACT_ST_LT_REF_CR

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

Line 1478: , PO_MESSAGE_S.PO_CONTRACT_ST_GT_REF_CR

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

Line 1629: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_NUMERIC

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:

Line 1858: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_UNIQUE_VAL

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:

Line 1926: l_message_name := PO_MESSAGE_S.POX_EXPIRATION_DATES;

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

Line 1972: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES4;

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

Line 2020: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES1;

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

Line 2068: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES;

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

Line 2116: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES5;

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

Line 2192: , p_message_name => PO_MESSAGE_S.PO_ALL_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
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:

Line 2218: , p_message_name => PO_MESSAGE_S.PO_ALL_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
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:

Line 2244: , p_message_name => PO_MESSAGE_S.PO_ALL_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
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:

Line 2270: , p_message_name => PO_MESSAGE_S.PO_ALL_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
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:

Line 2307: , PO_MESSAGE_S.PO_ALL_NOT_NULL

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

Line 2450: ,PO_MESSAGE_S.PO_MOD_EFFECT_DT_INVALID

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

Line 2516: ,PO_MESSAGE_S.PO_MOD_EFFECT_DT_NOTNULL

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';

Line 2574: ,PO_MESSAGE_S.PO_MOD_CANCEL_INVALID

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'

Line 2653: , p_message_name => PO_MESSAGE_S.PO_PRINT_FORM_FORMAT_INVALID

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;

Line 2712: , p_message_name => PO_MESSAGE_S.PO_PRINT_FORM_FORMAT_INVALID

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

Line 2733: , p_message_name => PO_MESSAGE_S.PO_PRINT_FORM_FORMAT_INVALID

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;

Line 3227: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

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