DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS dependencies on PO_MESSAGE_S

Line 162: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

158: , p_value_tbl => p_days_early_rcpt_allowed_tbl
159: , p_entity_id_tbl => p_line_loc_id_tbl
160: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
161: , p_column_name => c_DAYS_EARLY_RECEIPT_ALLOWED
162: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
163: , x_results => x_results
164: , x_result_type => x_result_type
165: );
166:

Line 189: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

185: , p_value_tbl => p_days_late_rcpt_allowed_tbl
186: , p_entity_id_tbl => p_line_loc_id_tbl
187: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
188: , p_column_name => c_DAYS_LATE_RECEIPT_ALLOWED
189: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
190: , x_results => x_results
191: , x_result_type => x_result_type
192: );
193:

Line 217: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT

213: , p_value_tbl => p_receive_close_tolerance_tbl
214: , p_entity_id_tbl => p_line_loc_id_tbl
215: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
216: , p_column_name => c_RECEIVE_CLOSE_TOLERANCE
217: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT
218: , x_results => x_results
219: , x_result_type => x_result_type
220: );
221:

Line 244: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT

240: , p_value_tbl => p_qty_rcv_tolerance_tbl
241: , p_entity_id_tbl => p_line_loc_id_tbl
242: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
243: , p_column_name => c_QTY_RCV_TOLERANCE
244: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT
245: , x_results => x_results
246: , x_result_type => x_result_type
247: );
248:

Line 320: , PO_MESSAGE_S.PO_PO_PLANNED_ITEM_DATE_REQ

316: SELECT
317: x_result_set_id
318: , c_ENTITY_TYPE_LINE_LOCATION
319: , l_line_loc_id_tbl(i)
320: , PO_MESSAGE_S.PO_PO_PLANNED_ITEM_DATE_REQ
321: FROM
322: FINANCIALS_SYSTEM_PARAMETERS FSP
323: , MTL_SYSTEM_ITEMS MSI
324: WHERE

Line 400: , p_message_name => PO_MESSAGE_S.PO_INVALID_INVOICE_MATCH_FPS

396: x_results.add_result(
397: p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
398: , p_entity_id => p_line_loc_id_tbl(i)
399: , p_column_name => NULL
400: , p_message_name => PO_MESSAGE_S.PO_INVALID_INVOICE_MATCH_FPS
401: );
402: END IF;
403: END LOOP;
404:

Line 445: , p_message_name => PO_MESSAGE_S.PO_PDOI_INV_CLOSE_TOLERANCE

441: , p_value_tbl => p_invoice_close_tolerance_tbl
442: , p_entity_id_tbl => p_line_loc_id_tbl
443: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
444: , p_column_name => c_INVOICE_CLOSE_TOLERANCE
445: , p_message_name => PO_MESSAGE_S.PO_PDOI_INV_CLOSE_TOLERANCE
446: --PBWC Message Change Impact: Removing a token.
447: , x_results => x_results
448: , x_result_type => x_result_type
449: );

Line 477: , p_message_name => PO_MESSAGE_S.RCV_ALL_OPEN_PO_PERIOD_HTML

473: , p_org_id_tbl => p_org_id_tbl
474: , p_entity_id_tbl => p_line_loc_id_tbl
475: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
476: , p_column_name => c_NEED_BY_DATE
477: , p_message_name => PO_MESSAGE_S.RCV_ALL_OPEN_PO_PERIOD_HTML
478: --PBWC Message Change Impact: Adding a token
479: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token
480: , p_token1_value => p_line_id_tbl
481: , x_result_set_id => x_result_set_id

Line 479: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token

475: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
476: , p_column_name => c_NEED_BY_DATE
477: , p_message_name => PO_MESSAGE_S.RCV_ALL_OPEN_PO_PERIOD_HTML
478: --PBWC Message Change Impact: Adding a token
479: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token
480: , p_token1_value => p_line_id_tbl
481: , x_result_set_id => x_result_set_id
482: , x_result_type => x_result_type
483: );

Line 511: , p_message_name => PO_MESSAGE_S.RCV_ALL_OPEN_PO_PERIOD_HTML

507: , p_org_id_tbl => p_org_id_tbl
508: , p_entity_id_tbl => p_line_loc_id_tbl
509: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
510: , p_column_name => c_PROMISED_DATE
511: , p_message_name => PO_MESSAGE_S.RCV_ALL_OPEN_PO_PERIOD_HTML
512: --PBWC Message Change Impact: Adding a token
513: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token
514: , p_token1_value => p_line_id_tbl
515: , x_result_set_id => x_result_set_id

Line 513: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token

509: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
510: , p_column_name => c_PROMISED_DATE
511: , p_message_name => PO_MESSAGE_S.RCV_ALL_OPEN_PO_PERIOD_HTML
512: --PBWC Message Change Impact: Adding a token
513: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token
514: , p_token1_value => p_line_id_tbl
515: , x_result_set_id => x_result_set_id
516: , x_result_type => x_result_type
517: );

Line 576: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

572: , p_entity_id_tbl => l_line_loc_id_tbl
573: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
574: , p_column_name => c_SHIP_TO_ORGANIZATION_ID
575: -- ECO# 4708990/4586199: Obsoleting some messages
576: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
577: , x_results => x_results
578: , x_result_type => x_result_type
579: );
580:

Line 644: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

640: , p_entity_id_tbl => l_line_loc_id_tbl
641: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
642: , p_column_name => c_SHIP_TO_LOCATION_ID
643: -- ECO# 4708990/4586199: Obsoleting some messages
644: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
645: , x_results => x_results
646: , x_result_type => x_result_type
647: );
648:

Line 701: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

697: , p_value_tbl => l_shipment_num_tbl --
698: , p_entity_id_tbl => l_line_loc_id_tbl --
699: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
700: , p_column_name => c_SHIPMENT_NUM
701: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
702: , x_results => x_results
703: , x_result_type => x_result_type
704: );
705:

Line 847: , p_message_name => PO_MESSAGE_S.PO_CONS_SHIP_TO_ORG_DIFF_SOB

843: p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
844: , p_entity_id => l_line_loc_id_tbl(i)
845: , p_column_name => c_SHIP_TO_ORGANIZATION_ID
846: , p_column_val => TO_CHAR(l_ship_to_org_id_tbl(i))
847: , p_message_name => PO_MESSAGE_S.PO_CONS_SHIP_TO_ORG_DIFF_SOB
848: --PBWC Message Change Impact: Adding token
849: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token
850: , p_token1_value => TO_CHAR(l_line_id_tbl(i))
851: , p_token2_name => PO_MESSAGE_S.c_SCHED_NUM_token

Line 849: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token

845: , p_column_name => c_SHIP_TO_ORGANIZATION_ID
846: , p_column_val => TO_CHAR(l_ship_to_org_id_tbl(i))
847: , p_message_name => PO_MESSAGE_S.PO_CONS_SHIP_TO_ORG_DIFF_SOB
848: --PBWC Message Change Impact: Adding token
849: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token
850: , p_token1_value => TO_CHAR(l_line_id_tbl(i))
851: , p_token2_name => PO_MESSAGE_S.c_SCHED_NUM_token
852: , p_token2_value => TO_CHAR(l_line_loc_id_tbl(i))
853: --End PBWC Message Change Impact: Adding token

Line 851: , p_token2_name => PO_MESSAGE_S.c_SCHED_NUM_token

847: , p_message_name => PO_MESSAGE_S.PO_CONS_SHIP_TO_ORG_DIFF_SOB
848: --PBWC Message Change Impact: Adding token
849: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token
850: , p_token1_value => TO_CHAR(l_line_id_tbl(i))
851: , p_token2_name => PO_MESSAGE_S.c_SCHED_NUM_token
852: , p_token2_value => TO_CHAR(l_line_loc_id_tbl(i))
853: --End PBWC Message Change Impact: Adding token
854: );
855:

Line 968: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

964: , p_value_tbl => l_quantity_tbl
965: , p_entity_id_tbl => l_line_loc_id_tbl
966: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
967: , p_column_name => c_QUANTITY
968: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
969: , x_results => x_results
970: , x_result_type => x_result_type
971: );
972:

Line 982: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

978: , p_value_tbl => l_quantity_tbl
979: , p_entity_id_tbl => l_line_loc_id_tbl
980: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
981: , p_column_name => c_QUANTITY
982: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
983: , x_results => x_results
984: , x_result_type => x_result_type
985: );
986:

Line 1051: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_RCVD_NA

1047: , (CASE
1048: WHEN NVL(PLL.quantity_received, 0) >
1049: GREATEST(NVL(quantity_billed, 0), NVL(quantity_financed, 0))
1050: --PBWC Message Change Impact: Make it use the same message
1051: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_RCVD_NA
1052: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA
1053: END
1054: )
1055: --PBWC Message Change Impact: Adding a token

Line 1052: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA

1048: WHEN NVL(PLL.quantity_received, 0) >
1049: GREATEST(NVL(quantity_billed, 0), NVL(quantity_financed, 0))
1050: --PBWC Message Change Impact: Make it use the same message
1051: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_RCVD_NA
1052: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA
1053: END
1054: )
1055: --PBWC Message Change Impact: Adding a token
1056: , (CASE

Line 1059: THEN PO_MESSAGE_S.c_QTY_RCVD_TOKEN

1055: --PBWC Message Change Impact: Adding a token
1056: , (CASE
1057: WHEN NVL(PLL.quantity_received, 0) >
1058: GREATEST(NVL(quantity_billed, 0), NVL(quantity_financed, 0))
1059: THEN PO_MESSAGE_S.c_QTY_RCVD_TOKEN
1060: ELSE PO_MESSAGE_S.c_QTY_BILLED_TOKEN
1061: END
1062: )
1063: , (CASE

Line 1060: ELSE PO_MESSAGE_S.c_QTY_BILLED_TOKEN

1056: , (CASE
1057: WHEN NVL(PLL.quantity_received, 0) >
1058: GREATEST(NVL(quantity_billed, 0), NVL(quantity_financed, 0))
1059: THEN PO_MESSAGE_S.c_QTY_RCVD_TOKEN
1060: ELSE PO_MESSAGE_S.c_QTY_BILLED_TOKEN
1061: END
1062: )
1063: , (CASE
1064: WHEN NVL(PLL.quantity_received, 0) >

Line 1196: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

1192: , p_value_tbl => l_amount_tbl
1193: , p_entity_id_tbl => l_line_loc_id_tbl
1194: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
1195: , p_column_name => c_AMOUNT
1196: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
1197: , x_results => x_results
1198: , x_result_type => x_result_type
1199: );
1200:

Line 1210: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

1206: , p_value_tbl => l_amount_tbl
1207: , p_entity_id_tbl => l_line_loc_id_tbl
1208: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
1209: , p_column_name => c_AMOUNT
1210: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
1211: , x_results => x_results
1212: , x_result_type => x_result_type
1213: );
1214:

Line 1277: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_RCVD_NA

1273: , TO_CHAR(p_amount_tbl(i))
1274: , (CASE
1275: WHEN NVL(PLL.amount_received, 0) >
1276: GREATEST(NVL(amount_billed, 0), NVL(amount_financed, 0))
1277: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_RCVD_NA
1278: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA
1279: END
1280: )
1281: --PBWC Message Change Impact: Adding a token

Line 1278: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA

1274: , (CASE
1275: WHEN NVL(PLL.amount_received, 0) >
1276: GREATEST(NVL(amount_billed, 0), NVL(amount_financed, 0))
1277: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_RCVD_NA
1278: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA
1279: END
1280: )
1281: --PBWC Message Change Impact: Adding a token
1282: , (CASE

Line 1285: THEN PO_MESSAGE_S.c_AMT_RCVD_TOKEN

1281: --PBWC Message Change Impact: Adding a token
1282: , (CASE
1283: WHEN NVL(PLL.amount_received, 0) >
1284: GREATEST(NVL(amount_billed, 0), NVL(amount_financed, 0))
1285: THEN PO_MESSAGE_S.c_AMT_RCVD_TOKEN
1286: ELSE PO_MESSAGE_S.c_AMT_BILLED_TOKEN
1287: END
1288: )
1289: , (CASE

Line 1286: ELSE PO_MESSAGE_S.c_AMT_BILLED_TOKEN

1282: , (CASE
1283: WHEN NVL(PLL.amount_received, 0) >
1284: GREATEST(NVL(amount_billed, 0), NVL(amount_financed, 0))
1285: THEN PO_MESSAGE_S.c_AMT_RCVD_TOKEN
1286: ELSE PO_MESSAGE_S.c_AMT_BILLED_TOKEN
1287: END
1288: )
1289: , (CASE
1290: WHEN NVL(PLL.amount_received, 0) >

Line 1470: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1466: p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
1467: , p_entity_id => p_line_loc_id_tbl(i)
1468: , p_column_name => c_UNIT_MEAS_LOOKUP_CODE
1469: , p_column_val => NULL
1470: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1471: );
1472: END IF;
1473: END LOOP;
1474:

Line 1527: ,PO_MESSAGE_S.PO_MOD_CANCEL_INVALID

1523: column_val)
1524: SELECT x_result_set_id,
1525: c_entity_type_LINE
1526: ,p_line_loc_id_tbl(i)
1527: ,PO_MESSAGE_S.PO_MOD_CANCEL_INVALID
1528: ,c_CONTROL_ACTION
1529: ,TO_CHAR(p_control_action_tbl(i))
1530: FROM DUAL
1531: WHERE nvl(p_control_action_tbl(i), '*') = 'CANCEL'

Line 1593: , p_message_name => PO_MESSAGE_S.PO_IDV_POP_END_DT_NULL

1589: (
1590: p_entity_type => c_ENTITY_TYPE_LINE
1591: , p_entity_id => p_line_id_tbl(i)
1592: , p_column_name => c_POP_END_DATE
1593: , p_message_name => PO_MESSAGE_S.PO_IDV_POP_END_DT_NULL
1594: );
1595: END IF;
1596: END LOOP;
1597:

Line 1611: , p_message_name => PO_MESSAGE_S.PO_IDV_LINE_POP_DATES

1607: , p_entity_id_tbl => p_line_id_tbl
1608: , p_entity_type => c_ENTITY_TYPE_LINE
1609: , p_column_name => c_POP_END_DATE
1610: , p_column_val_selector => NULL
1611: , p_message_name => PO_MESSAGE_S.PO_IDV_LINE_POP_DATES
1612: , x_results => x_results
1613: , x_result_type => x_result_type
1614: );
1615: END IF;

Line 1655: , p_message_name => PO_MESSAGE_S.PO_IDV_POP_DT_NEED_BY_NULL

1651: (
1652: p_entity_type => c_ENTITY_TYPE_LINE
1653: , p_entity_id => p_line_id_tbl(i)
1654: , p_column_name => c_POP_END_DATE
1655: , p_message_name => PO_MESSAGE_S.PO_IDV_POP_DT_NEED_BY_NULL
1656: );
1657: END IF;
1658: END LOOP;
1659:

Line 1726: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

1722: , p_value_tbl => l_price_override_tbl
1723: , p_entity_id_tbl => l_line_loc_id_tbl
1724: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
1725: , p_column_name => c_PRICE_OVERRIDE
1726: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
1727: , x_results => x_results
1728: , x_result_type => x_result_type
1729: );
1730: EXCEPTION