DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS dependencies on PO_MESSAGE_S

Line 145: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

141: , p_value_tbl => p_days_early_rcpt_allowed_tbl
142: , p_entity_id_tbl => p_line_loc_id_tbl
143: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
144: , p_column_name => c_DAYS_EARLY_RECEIPT_ALLOWED
145: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
146: , x_results => x_results
147: , x_result_type => x_result_type
148: );
149:

Line 172: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

168: , p_value_tbl => p_days_late_rcpt_allowed_tbl
169: , p_entity_id_tbl => p_line_loc_id_tbl
170: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
171: , p_column_name => c_DAYS_LATE_RECEIPT_ALLOWED
172: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
173: , x_results => x_results
174: , x_result_type => x_result_type
175: );
176:

Line 200: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT

196: , p_value_tbl => p_receive_close_tolerance_tbl
197: , p_entity_id_tbl => p_line_loc_id_tbl
198: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
199: , p_column_name => c_RECEIVE_CLOSE_TOLERANCE
200: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT
201: , x_results => x_results
202: , x_result_type => x_result_type
203: );
204:

Line 227: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT

223: , p_value_tbl => p_qty_rcv_tolerance_tbl
224: , p_entity_id_tbl => p_line_loc_id_tbl
225: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
226: , p_column_name => c_QTY_RCV_TOLERANCE
227: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT
228: , x_results => x_results
229: , x_result_type => x_result_type
230: );
231:

Line 303: , PO_MESSAGE_S.PO_PO_PLANNED_ITEM_DATE_REQ

299: SELECT
300: x_result_set_id
301: , c_ENTITY_TYPE_LINE_LOCATION
302: , l_line_loc_id_tbl(i)
303: , PO_MESSAGE_S.PO_PO_PLANNED_ITEM_DATE_REQ
304: FROM
305: FINANCIALS_SYSTEM_PARAMETERS FSP
306: , MTL_SYSTEM_ITEMS MSI
307: WHERE

Line 383: , p_message_name => PO_MESSAGE_S.PO_INVALID_INVOICE_MATCH_FPS

379: x_results.add_result(
380: p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
381: , p_entity_id => p_line_loc_id_tbl(i)
382: , p_column_name => NULL
383: , p_message_name => PO_MESSAGE_S.PO_INVALID_INVOICE_MATCH_FPS
384: );
385: END IF;
386: END LOOP;
387:

Line 428: , p_message_name => PO_MESSAGE_S.PO_PDOI_INV_CLOSE_TOLERANCE

424: , p_value_tbl => p_invoice_close_tolerance_tbl
425: , p_entity_id_tbl => p_line_loc_id_tbl
426: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
427: , p_column_name => c_INVOICE_CLOSE_TOLERANCE
428: , p_message_name => PO_MESSAGE_S.PO_PDOI_INV_CLOSE_TOLERANCE
429: --PBWC Message Change Impact: Removing a token.
430: , x_results => x_results
431: , x_result_type => x_result_type
432: );

Line 460: , p_message_name => PO_MESSAGE_S.RCV_ALL_OPEN_PO_PERIOD_HTML

456: , p_org_id_tbl => p_org_id_tbl
457: , p_entity_id_tbl => p_line_loc_id_tbl
458: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
459: , p_column_name => c_NEED_BY_DATE
460: , p_message_name => PO_MESSAGE_S.RCV_ALL_OPEN_PO_PERIOD_HTML
461: --PBWC Message Change Impact: Adding a token
462: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token
463: , p_token1_value => p_line_id_tbl
464: , x_result_set_id => x_result_set_id

Line 462: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token

458: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
459: , p_column_name => c_NEED_BY_DATE
460: , p_message_name => PO_MESSAGE_S.RCV_ALL_OPEN_PO_PERIOD_HTML
461: --PBWC Message Change Impact: Adding a token
462: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token
463: , p_token1_value => p_line_id_tbl
464: , x_result_set_id => x_result_set_id
465: , x_result_type => x_result_type
466: );

Line 494: , p_message_name => PO_MESSAGE_S.RCV_ALL_OPEN_PO_PERIOD_HTML

490: , p_org_id_tbl => p_org_id_tbl
491: , p_entity_id_tbl => p_line_loc_id_tbl
492: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
493: , p_column_name => c_PROMISED_DATE
494: , p_message_name => PO_MESSAGE_S.RCV_ALL_OPEN_PO_PERIOD_HTML
495: --PBWC Message Change Impact: Adding a token
496: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token
497: , p_token1_value => p_line_id_tbl
498: , x_result_set_id => x_result_set_id

Line 496: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token

492: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
493: , p_column_name => c_PROMISED_DATE
494: , p_message_name => PO_MESSAGE_S.RCV_ALL_OPEN_PO_PERIOD_HTML
495: --PBWC Message Change Impact: Adding a token
496: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token
497: , p_token1_value => p_line_id_tbl
498: , x_result_set_id => x_result_set_id
499: , x_result_type => x_result_type
500: );

Line 559: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

555: , p_entity_id_tbl => l_line_loc_id_tbl
556: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
557: , p_column_name => c_SHIP_TO_ORGANIZATION_ID
558: -- ECO# 4708990/4586199: Obsoleting some messages
559: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
560: , x_results => x_results
561: , x_result_type => x_result_type
562: );
563:

Line 627: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

623: , p_entity_id_tbl => l_line_loc_id_tbl
624: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
625: , p_column_name => c_SHIP_TO_LOCATION_ID
626: -- ECO# 4708990/4586199: Obsoleting some messages
627: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
628: , x_results => x_results
629: , x_result_type => x_result_type
630: );
631:

Line 684: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

680: , p_value_tbl => l_shipment_num_tbl --
681: , p_entity_id_tbl => l_line_loc_id_tbl --
682: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
683: , p_column_name => c_SHIPMENT_NUM
684: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
685: , x_results => x_results
686: , x_result_type => x_result_type
687: );
688:

Line 826: , p_message_name => PO_MESSAGE_S.PO_CONS_SHIP_TO_ORG_DIFF_SOB

822: p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
823: , p_entity_id => l_line_loc_id_tbl(i)
824: , p_column_name => c_SHIP_TO_ORGANIZATION_ID
825: , p_column_val => TO_CHAR(l_ship_to_org_id_tbl(i))
826: , p_message_name => PO_MESSAGE_S.PO_CONS_SHIP_TO_ORG_DIFF_SOB
827: --PBWC Message Change Impact: Adding token
828: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token
829: , p_token1_value => TO_CHAR(l_line_id_tbl(i))
830: , p_token2_name => PO_MESSAGE_S.c_SCHED_NUM_token

Line 828: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token

824: , p_column_name => c_SHIP_TO_ORGANIZATION_ID
825: , p_column_val => TO_CHAR(l_ship_to_org_id_tbl(i))
826: , p_message_name => PO_MESSAGE_S.PO_CONS_SHIP_TO_ORG_DIFF_SOB
827: --PBWC Message Change Impact: Adding token
828: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token
829: , p_token1_value => TO_CHAR(l_line_id_tbl(i))
830: , p_token2_name => PO_MESSAGE_S.c_SCHED_NUM_token
831: , p_token2_value => TO_CHAR(l_line_loc_id_tbl(i))
832: --End PBWC Message Change Impact: Adding token

Line 830: , p_token2_name => PO_MESSAGE_S.c_SCHED_NUM_token

826: , p_message_name => PO_MESSAGE_S.PO_CONS_SHIP_TO_ORG_DIFF_SOB
827: --PBWC Message Change Impact: Adding token
828: , p_token1_name => PO_MESSAGE_S.c_LINE_NUM_token
829: , p_token1_value => TO_CHAR(l_line_id_tbl(i))
830: , p_token2_name => PO_MESSAGE_S.c_SCHED_NUM_token
831: , p_token2_value => TO_CHAR(l_line_loc_id_tbl(i))
832: --End PBWC Message Change Impact: Adding token
833: );
834:

Line 918: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

914: , p_value_tbl => l_quantity_tbl
915: , p_entity_id_tbl => l_line_loc_id_tbl
916: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
917: , p_column_name => c_QUANTITY
918: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
919: , x_results => x_results
920: , x_result_type => x_result_type
921: );
922:

Line 984: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_RCVD_NA

980: , (CASE
981: WHEN NVL(PLL.quantity_received, 0) >
982: GREATEST(NVL(quantity_billed, 0), NVL(quantity_financed, 0))
983: --PBWC Message Change Impact: Make it use the same message
984: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_RCVD_NA
985: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA
986: END
987: )
988: --PBWC Message Change Impact: Adding a token

Line 985: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA

981: WHEN NVL(PLL.quantity_received, 0) >
982: GREATEST(NVL(quantity_billed, 0), NVL(quantity_financed, 0))
983: --PBWC Message Change Impact: Make it use the same message
984: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_RCVD_NA
985: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA
986: END
987: )
988: --PBWC Message Change Impact: Adding a token
989: , (CASE

Line 992: THEN PO_MESSAGE_S.c_QTY_RCVD_TOKEN

988: --PBWC Message Change Impact: Adding a token
989: , (CASE
990: WHEN NVL(PLL.quantity_received, 0) >
991: GREATEST(NVL(quantity_billed, 0), NVL(quantity_financed, 0))
992: THEN PO_MESSAGE_S.c_QTY_RCVD_TOKEN
993: ELSE PO_MESSAGE_S.c_QTY_BILLED_TOKEN
994: END
995: )
996: , (CASE

Line 993: ELSE PO_MESSAGE_S.c_QTY_BILLED_TOKEN

989: , (CASE
990: WHEN NVL(PLL.quantity_received, 0) >
991: GREATEST(NVL(quantity_billed, 0), NVL(quantity_financed, 0))
992: THEN PO_MESSAGE_S.c_QTY_RCVD_TOKEN
993: ELSE PO_MESSAGE_S.c_QTY_BILLED_TOKEN
994: END
995: )
996: , (CASE
997: WHEN NVL(PLL.quantity_received, 0) >

Line 1100: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

1096: , p_value_tbl => l_amount_tbl
1097: , p_entity_id_tbl => l_line_loc_id_tbl
1098: , p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
1099: , p_column_name => c_AMOUNT
1100: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
1101: , x_results => x_results
1102: , x_result_type => x_result_type
1103: );
1104:

Line 1164: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_RCVD_NA

1160: , TO_CHAR(p_amount_tbl(i))
1161: , (CASE
1162: WHEN NVL(PLL.amount_received, 0) >
1163: GREATEST(NVL(amount_billed, 0), NVL(amount_financed, 0))
1164: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_RCVD_NA
1165: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA
1166: END
1167: )
1168: --PBWC Message Change Impact: Adding a token

Line 1165: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA

1161: , (CASE
1162: WHEN NVL(PLL.amount_received, 0) >
1163: GREATEST(NVL(amount_billed, 0), NVL(amount_financed, 0))
1164: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_RCVD_NA
1165: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA
1166: END
1167: )
1168: --PBWC Message Change Impact: Adding a token
1169: , (CASE

Line 1172: THEN PO_MESSAGE_S.c_AMT_RCVD_TOKEN

1168: --PBWC Message Change Impact: Adding a token
1169: , (CASE
1170: WHEN NVL(PLL.amount_received, 0) >
1171: GREATEST(NVL(amount_billed, 0), NVL(amount_financed, 0))
1172: THEN PO_MESSAGE_S.c_AMT_RCVD_TOKEN
1173: ELSE PO_MESSAGE_S.c_AMT_BILLED_TOKEN
1174: END
1175: )
1176: , (CASE

Line 1173: ELSE PO_MESSAGE_S.c_AMT_BILLED_TOKEN

1169: , (CASE
1170: WHEN NVL(PLL.amount_received, 0) >
1171: GREATEST(NVL(amount_billed, 0), NVL(amount_financed, 0))
1172: THEN PO_MESSAGE_S.c_AMT_RCVD_TOKEN
1173: ELSE PO_MESSAGE_S.c_AMT_BILLED_TOKEN
1174: END
1175: )
1176: , (CASE
1177: WHEN NVL(PLL.amount_received, 0) >

Line 1357: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1353: p_entity_type => c_ENTITY_TYPE_LINE_LOCATION
1354: , p_entity_id => p_line_loc_id_tbl(i)
1355: , p_column_name => c_UNIT_MEAS_LOOKUP_CODE
1356: , p_column_val => NULL
1357: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1358: );
1359: END IF;
1360: END LOOP;
1361: