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:
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:
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:
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:
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
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:
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: );
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
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: );
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
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: );
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:
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:
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:
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
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
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:
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:
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
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
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
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) >
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:
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
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
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
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) >
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: