eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_HEADERS dependencies on PO_MESSAGE_S

Line 121: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

117: , p_value_tbl => p_price_update_tol_tbl
118: , p_entity_id_tbl => p_header_id_tbl
119: , p_entity_type => c_entity_type_HEADER
120: , p_column_name => c_PRICE_UPDATE_TOLERANCE
121: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
122: , x_results => x_results
123: , x_result_type => x_result_type
124: );
125:

Line 149: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

145: , p_value_tbl => p_amount_limit_tbl
146: , p_entity_id_tbl => p_header_id_tbl
147: , p_entity_type => c_entity_type_HEADER
148: , p_column_name => c_AMOUNT_LIMIT
149: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
150: , x_results => x_results
151: , x_result_type => x_result_type
152: );
153:

Line 178: , p_message_name => PO_MESSAGE_S.PO_PO_AMT_LIMIT_CK_FAILED

174: , p_num2_tbl => p_amount_limit_tbl
175: , p_entity_id_tbl => p_header_id_tbl
176: , p_entity_type => c_entity_type_HEADER
177: , p_column_name => c_AMOUNT_LIMIT
178: , p_message_name => PO_MESSAGE_S.PO_PO_AMT_LIMIT_CK_FAILED
179: , x_results => x_results
180: , x_result_type => x_result_type
181: );
182:

Line 206: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

202: , p_value_tbl => p_blanket_total_amount_tbl
203: , p_entity_id_tbl => p_header_id_tbl
204: , p_entity_type => c_entity_type_HEADER
205: , p_column_name => c_BLANKET_TOTAL_AMOUNT
206: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
207: , x_results => x_results
208: , x_result_type => x_result_type
209: );
210:

Line 252: , p_message_name => PO_MESSAGE_S.PO_AMT_LMT_NOT_NULL

248: x_results.add_result(
249: p_entity_type => c_entity_type_HEADER
250: , p_entity_id => p_header_id_tbl(i)
251: , p_column_name => c_BLANKET_TOTAL_AMOUNT
252: , p_message_name => PO_MESSAGE_S.PO_AMT_LMT_NOT_NULL
253: );
254: END IF;
255: END LOOP;
256:

Line 318: , PO_MESSAGE_S.PO_PO_VENDOR_ON_HOLD

314: , c_entity_type_HEADER
315: , p_header_id_tbl(i)
316: , c_VENDOR_ID
317: , TO_CHAR(p_vendor_id_tbl(i))
318: , PO_MESSAGE_S.PO_PO_VENDOR_ON_HOLD
319: FROM
320: PO_VENDORS SUPPLIER
321: WHERE
322: SUPPLIER.vendor_id = p_vendor_id_tbl(i)

Line 369: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

365: , p_value_tbl => p_rate_tbl
366: , p_entity_id_tbl => p_header_id_tbl
367: , p_entity_type => c_entity_type_HEADER
368: , p_column_name => c_RATE
369: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
370: , x_results => x_results
371: , x_result_type => x_result_type
372: );
373:

Line 437: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

433: x_results.add_result(
434: p_entity_type => c_entity_type_HEADER
435: , p_entity_id => p_header_id_tbl(i)
436: , p_column_name => c_RATE_TYPE
437: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
438: );
439: END IF;
440:
441: IF (p_rate_date_tbl(i) IS NULL) THEN

Line 446: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

442: x_results.add_result(
443: p_entity_type => c_entity_type_HEADER
444: , p_entity_id => p_header_id_tbl(i)
445: , p_column_name => c_RATE_DATE
446: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
447: );
448: END IF;
449:
450: IF (p_rate_type_tbl(i) <> c_User AND p_rate_tbl(i) IS NULL) THEN

Line 455: , p_message_name => PO_MESSAGE_S.PO_HTML_NO_RATE_DEFINED

451: x_results.add_result(
452: p_entity_type => c_entity_type_HEADER
453: , p_entity_id => p_header_id_tbl(i)
454: , p_column_name => NULL
455: , p_message_name => PO_MESSAGE_S.PO_HTML_NO_RATE_DEFINED
456: );
457: ELSIF (p_rate_tbl(i) IS NULL) THEN
458: x_results.add_result(
459: p_entity_type => c_entity_type_HEADER

Line 462: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

458: x_results.add_result(
459: p_entity_type => c_entity_type_HEADER
460: , p_entity_id => p_header_id_tbl(i)
461: , p_column_name => c_RATE
462: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
463: );
464: END IF;
465:
466: END IF;

Line 531: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

527: x_results.add_result(
528: p_entity_type => c_entity_type_HEADER
529: , p_entity_id => p_header_id_tbl(i)
530: , p_column_name => c_EMAIL_ADDRESS
531: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
532: );
533: ELSIF ((p_supplier_notif_method_tbl(i) = c_FAX) AND
534: (p_fax_tbl(i) IS NULL)) THEN
535: x_results.add_result(

Line 539: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

535: x_results.add_result(
536: p_entity_type => c_entity_type_HEADER
537: , p_entity_id => p_header_id_tbl(i)
538: , p_column_name => c_FAX
539: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
540: );
541: END IF;
542:
543: END LOOP;

Line 589: , p_message_name => PO_MESSAGE_S.PO_ALL_DATE_BETWEEN_START_END

585: , p_entity_id_tbl => p_header_id_tbl
586: , p_entity_type => c_entity_type_HEADER
587: , p_column_name => c_END_DATE
588: , p_column_val_selector => PO_VALIDATION_HELPER.c_END_DATE
589: , p_message_name => PO_MESSAGE_S.PO_ALL_DATE_BETWEEN_START_END
590: , x_results => x_results
591: , x_result_type => x_result_type
592: );
593:

Line 639: , PO_MESSAGE_S.PO_CONTRACT_ST_LT_REF_CR --- Bug 5548899

635: , c_entity_type_HEADER
636: , p_header_id_tbl(i)
637: , c_START_DATE
638: , TO_CHAR(p_start_date_tbl(i))
639: , PO_MESSAGE_S.PO_CONTRACT_ST_LT_REF_CR --- Bug 5548899
640: FROM DUAL
641: WHERE
642: p_type_lookup_code_tbl(i) = c_BLANKET
643: AND EXISTS

Line 717: , PO_MESSAGE_S.PO_CONTRACT_ST_GT_REF_CR --- Bug 5548899

713: , c_entity_type_HEADER
714: , p_header_id_tbl(i)
715: , c_END_DATE
716: , TO_CHAR(p_end_date_tbl(i))
717: , PO_MESSAGE_S.PO_CONTRACT_ST_GT_REF_CR --- Bug 5548899
718: FROM DUAL
719: WHERE
720: p_type_lookup_code_tbl(i) = c_BLANKET
721: AND EXISTS

Line 794: , PO_MESSAGE_S.PO_CONTRACT_ST_LT_REF_CR

790: , c_entity_type_HEADER
791: , p_header_id_tbl(i)
792: , c_START_DATE
793: , TO_CHAR(p_start_date_tbl(i))
794: , PO_MESSAGE_S.PO_CONTRACT_ST_LT_REF_CR
795: FROM DUAL
796: WHERE
797: p_type_lookup_code_tbl(i) = c_CONTRACT
798: AND EXISTS

Line 878: , PO_MESSAGE_S.PO_CONTRACT_ST_GT_REF_CR

874: , c_entity_type_HEADER
875: , p_header_id_tbl(i)
876: , c_END_DATE
877: , TO_CHAR(p_end_date_tbl(i))
878: , PO_MESSAGE_S.PO_CONTRACT_ST_GT_REF_CR
879: FROM DUAL
880: WHERE
881: p_type_lookup_code_tbl(i) = c_CONTRACT
882: AND EXISTS

Line 996: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_NUMERIC

992: p_entity_type => c_entity_type_HEADER
993: , p_entity_id => l_header_id_tbl(i)
994: , p_column_name => c_SEGMENT1
995: , p_column_val => l_segment1_tbl(i)
996: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_NUMERIC
997: );
998: END;
999: END LOOP;
1000:

Line 1225: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_UNIQUE_VAL

1221: p_entity_type => c_entity_type_HEADER
1222: , p_entity_id => l_header_id_tbl(i)
1223: , p_column_name => c_SEGMENT1
1224: , p_column_val => l_segment1_tbl(i)
1225: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_UNIQUE_VAL
1226: );
1227: END IF;
1228: END LOOP;
1229:

Line 1293: l_message_name := PO_MESSAGE_S.POX_EXPIRATION_DATES;

1289:
1290: -- Check that the line's Expiration date is within the
1291: -- Effective From and To dates of the agreement.
1292:
1293: l_message_name := PO_MESSAGE_S.POX_EXPIRATION_DATES;
1294:
1295: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
1296:
1297: INSERT INTO PO_ONLINE_REPORT_TEXT_GT

Line 1339: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES4;

1335:
1336: -- Check that the price break's Effective From date
1337: -- is before the Effective To date of the agreement.
1338:
1339: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES4;
1340:
1341: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
1342:
1343: INSERT INTO PO_ONLINE_REPORT_TEXT_GT

Line 1387: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES1;

1383:
1384: -- Check that the price break's Effective From date
1385: -- is after the Effective From date of the agreement.
1386:
1387: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES1;
1388:
1389: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
1390:
1391: INSERT INTO PO_ONLINE_REPORT_TEXT_GT

Line 1435: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES;

1431:
1432: -- Check that the price break's Effective To date
1433: -- is before the Effective To date of the agreement.
1434:
1435: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES;
1436:
1437: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
1438:
1439: INSERT INTO PO_ONLINE_REPORT_TEXT_GT

Line 1483: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES5;

1479:
1480: -- Check that the price break's Effective To date
1481: -- is after the Effective From date of the agreement.
1482:
1483: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES5;
1484:
1485: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
1486:
1487: INSERT INTO PO_ONLINE_REPORT_TEXT_GT

Line 1559: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1555: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_agent_id_tbl)
1556: , p_entity_id_tbl => p_header_id_tbl
1557: , p_entity_type => c_entity_type_HEADER
1558: , p_column_name => c_AGENT_ID
1559: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1560: , x_results => x_results
1561: , x_result_type => x_result_type
1562: );
1563:

Line 1585: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1581: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_ship_to_loc_id_tbl)
1582: , p_entity_id_tbl => p_header_id_tbl
1583: , p_entity_type => c_entity_type_HEADER
1584: , p_column_name => c_SHIP_TO_LOCATION_ID
1585: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1586: , x_results => x_results
1587: , x_result_type => x_result_type
1588: );
1589:

Line 1611: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1607: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_vendor_id_tbl)
1608: , p_entity_id_tbl => p_header_id_tbl
1609: , p_entity_type => c_entity_type_HEADER
1610: , p_column_name => c_VENDOR_ID
1611: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1612: , x_results => x_results
1613: , x_result_type => x_result_type
1614: );
1615:

Line 1637: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1633: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_vendor_site_id_tbl)
1634: , p_entity_id_tbl => p_header_id_tbl
1635: , p_entity_type => c_entity_type_HEADER
1636: , p_column_name => c_VENDOR_SITE_ID
1637: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1638: , x_results => x_results
1639: , x_result_type => x_result_type
1640: );
1641:

Line 1674: , PO_MESSAGE_S.PO_ALL_NOT_NULL

1670: SELECT
1671: x_result_set_id
1672: , c_entity_type_HEADER
1673: , p_header_id_tbl(i)
1674: , PO_MESSAGE_S.PO_ALL_NOT_NULL
1675: , c_SEGMENT1
1676: FROM
1677: PO_SYSTEM_PARAMETERS_ALL
1678: WHERE