[Home] [Help]
290: , p_value_tbl => p_committed_amount_tbl
291: , p_entity_id_tbl => p_line_id_tbl
292: , p_entity_type => c_ENTITY_TYPE_LINE
293: , p_column_name => c_COMMITTED_AMOUNT
294: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
295: , x_results => x_results
296: , x_result_type => x_result_type
297: );
298:
317: , p_value_tbl => p_min_release_amount_tbl
318: , p_entity_id_tbl => p_line_id_tbl
319: , p_entity_type => c_ENTITY_TYPE_LINE
320: , p_column_name => c_MIN_RELEASE_AMOUNT
321: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
322: , x_results => x_results
323: , x_result_type => x_result_type
324: );
325:
410: , c_QUANTITY
411: , TO_CHAR(p_quantity_tbl(i))
412: , (CASE
413: WHEN POLL_TOTAL.qty_bill_actuals = POLL_TOTAL.qty_executed
414: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA
415: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_RCVD_NA
416: END
417: )
418: , (CASE
411: , TO_CHAR(p_quantity_tbl(i))
412: , (CASE
413: WHEN POLL_TOTAL.qty_bill_actuals = POLL_TOTAL.qty_executed
414: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA
415: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_RCVD_NA
416: END
417: )
418: , (CASE
419: WHEN POLL_TOTAL.qty_bill_actuals = POLL_TOTAL.qty_executed
416: END
417: )
418: , (CASE
419: WHEN POLL_TOTAL.qty_bill_actuals = POLL_TOTAL.qty_executed
420: THEN PO_MESSAGE_S.c_QTY_BILLED_token
421: ELSE PO_MESSAGE_S.c_QTY_RCVD_token
422: END
423: )
424: , (CASE
417: )
418: , (CASE
419: WHEN POLL_TOTAL.qty_bill_actuals = POLL_TOTAL.qty_executed
420: THEN PO_MESSAGE_S.c_QTY_BILLED_token
421: ELSE PO_MESSAGE_S.c_QTY_RCVD_token
422: END
423: )
424: , (CASE
425: WHEN POLL_TOTAL.qty_bill_actuals = POLL_TOTAL.qty_executed
519: x_results.add_result(
520: p_entity_type => c_ENTITY_TYPE_LINE
521: , p_entity_id => p_line_id_tbl(i)
522: , p_column_name => c_AMOUNT
523: , p_message_name => PO_MESSAGE_S.PO_ADVANCE_GT_LINE_AMOUNT
524: );
525: END IF;
526: END IF;
527: END LOOP;
718: , c_ENTITY_TYPE_LINE
719: , p_line_id_tbl(i)
720: , c_QUANTITY
721: , TO_CHAR(p_quantity_tbl(i))
722: , PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_ENC_NA
723: --PBWC Message Change Impact: Removing a token
724: --, PO_MESSAGE_S.c_QTY_ORD_token
725: --, TO_CHAR(p_quantity_tbl(i))
726: , PO_MESSAGE_S.c_QTY_ENC_token
720: , c_QUANTITY
721: , TO_CHAR(p_quantity_tbl(i))
722: , PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_ENC_NA
723: --PBWC Message Change Impact: Removing a token
724: --, PO_MESSAGE_S.c_QTY_ORD_token
725: --, TO_CHAR(p_quantity_tbl(i))
726: , PO_MESSAGE_S.c_QTY_ENC_token
727: , TO_CHAR(DIST_TOTAL.quantity_encumbered)
728: FROM
722: , PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_ENC_NA
723: --PBWC Message Change Impact: Removing a token
724: --, PO_MESSAGE_S.c_QTY_ORD_token
725: --, TO_CHAR(p_quantity_tbl(i))
726: , PO_MESSAGE_S.c_QTY_ENC_token
727: , TO_CHAR(DIST_TOTAL.quantity_encumbered)
728: FROM
729: ( SELECT NVL(SUM(POD.quantity_ordered),0) quantity_encumbered
730: FROM
777: p_calling_module => D_quantity_notif_change
778: , p_line_id_tbl => p_line_id_tbl
779: , p_quantity_tbl => p_quantity_tbl
780: , p_column_name => c_QUANTITY
781: , p_message_name => PO_MESSAGE_S.PO_PO_NFC_QTY_CHANGE
782: , x_result_set_id => x_result_set_id
783: , x_result_type => x_result_type
784: );
785:
910: , c_AMOUNT
911: , TO_CHAR(p_amount_tbl(i))
912: , (CASE
913: WHEN POLL_TOTAL.amt_bill_actuals = POLL_TOTAL.amt_executed
914: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA
915: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_RCVD_NA
916: END
917: )
918: --PBWC Message Change Impact: Adding a token
911: , TO_CHAR(p_amount_tbl(i))
912: , (CASE
913: WHEN POLL_TOTAL.amt_bill_actuals = POLL_TOTAL.amt_executed
914: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA
915: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_RCVD_NA
916: END
917: )
918: --PBWC Message Change Impact: Adding a token
919: , (CASE
917: )
918: --PBWC Message Change Impact: Adding a token
919: , (CASE
920: WHEN POLL_TOTAL.amt_bill_actuals = POLL_TOTAL.amt_executed
921: THEN PO_MESSAGE_S.c_AMT_BILLED_TOKEN
922: ELSE PO_MESSAGE_S.c_AMT_RCVD_TOKEN
923: END
924: )
925: , (CASE
918: --PBWC Message Change Impact: Adding a token
919: , (CASE
920: WHEN POLL_TOTAL.amt_bill_actuals = POLL_TOTAL.amt_executed
921: THEN PO_MESSAGE_S.c_AMT_BILLED_TOKEN
922: ELSE PO_MESSAGE_S.c_AMT_RCVD_TOKEN
923: END
924: )
925: , (CASE
926: WHEN POLL_TOTAL.amt_bill_actuals = POLL_TOTAL.amt_executed
1115: p_entity_type => c_ENTITY_TYPE_LINE
1116: , p_entity_id => l_line_id_tbl(i)
1117: , p_column_name => c_AMOUNT
1118: , p_column_val => TO_CHAR(l_amount_tbl(i))
1119: , p_message_name => PO_MESSAGE_S.PO_CHNG_OTL_INVALID_AMOUNT
1120: , p_token1_name => PO_MESSAGE_S.c_TOTAL_AMT_token
1121: , p_token1_value => l_timecard_amount_sum
1122: );
1123:
1116: , p_entity_id => l_line_id_tbl(i)
1117: , p_column_name => c_AMOUNT
1118: , p_column_val => TO_CHAR(l_amount_tbl(i))
1119: , p_message_name => PO_MESSAGE_S.PO_CHNG_OTL_INVALID_AMOUNT
1120: , p_token1_name => PO_MESSAGE_S.c_TOTAL_AMT_token
1121: , p_token1_value => l_timecard_amount_sum
1122: );
1123:
1124: END IF;
1201: , p_value_tbl => p_line_num_tbl
1202: , p_entity_id_tbl => p_line_id_tbl
1203: , p_entity_type => c_ENTITY_TYPE_LINE
1204: , p_column_name => c_LINE_NUM
1205: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
1206: , x_results => x_results
1207: , x_result_type => x_result_type
1208: );
1209:
1272: , c_ENTITY_TYPE_LINE
1273: , p_line_id_tbl(i)
1274: , c_ITEM_ID
1275: , TO_CHAR(p_item_id_tbl(i))
1276: , PO_MESSAGE_S.PO_VMI_ASL_EXIST
1277: FROM
1278: PO_APPROVED_SUPPLIER_LIS_VAL_V PASL
1279: , PO_ASL_ATTRIBUTES PAA
1280: , PO_ASL_STATUS_RULES_V PASR
1348: , p_entity_id_tbl => p_line_id_tbl
1349: , p_entity_type => c_ENTITY_TYPE_LINE
1350: , p_column_name => c_START_DATE
1351: , p_column_val_selector => NULL
1352: , p_message_name => PO_MESSAGE_S.PO_SVC_ASSIGNMENT_DATES
1353: , x_results => x_results
1354: , x_result_type => x_result_type
1355: );
1356:
1396: (
1397: p_entity_type => c_ENTITY_TYPE_LINE
1398: , p_entity_id => p_line_id_tbl(i)
1399: , p_column_name => c_ORDER_TO_DATE
1400: , p_message_name => PO_MESSAGE_S.PO_IDV_ORD_END_DT_NULL
1401: );
1402: END IF;
1403: END LOOP;
1404:
1410: , p_entity_id_tbl => p_line_id_tbl
1411: , p_entity_type => c_ENTITY_TYPE_LINE
1412: , p_column_name => c_ORDER_FROM_DATE
1413: , p_column_val_selector => NULL
1414: , p_message_name => PO_MESSAGE_S.PO_IDV_LINE_ORDER_DATES
1415: , x_results => x_results
1416: , x_result_type => x_result_type
1417: );
1418:
1488: (
1489: p_entity_type => c_ENTITY_TYPE_LINE
1490: , p_entity_id => p_line_id_tbl(i)
1491: , p_column_name => c_ORDER_FROM_DATE
1492: , p_message_name => PO_MESSAGE_S.PO_IDV_ORD_ST_DT_GT_SYS
1493: );
1494: END IF;
1495: END IF;
1496: END LOOP;
1552: (
1553: p_entity_type => c_ENTITY_TYPE_LINE
1554: , p_entity_id => p_line_id_tbl(i)
1555: , p_column_name => c_CLM_MAX_TOTAL_AMOUNT
1556: , p_message_name => PO_MESSAGE_S.PO_IDV_MAX_TOT_AMT_LE_LIN_TAMT
1557: );
1558: END IF;
1559: END LOOP;
1560:
1607: (
1608: p_entity_type => c_ENTITY_TYPE_LINE
1609: , p_entity_id => p_line_id_tbl(i)
1610: , p_column_name => c_CLM_MAX_TOTAL_AMOUNT
1611: , p_message_name => PO_MESSAGE_S.PO_IDV_MAX_TOT_AMT_GE_MIN_TAMT
1612: );
1613: END IF;
1614: END LOOP;
1615:
1661: (
1662: p_entity_type => c_ENTITY_TYPE_LINE
1663: , p_entity_id => p_line_id_tbl(i)
1664: , p_column_name => c_CLM_MAX_TOTAL_QUANTITY
1665: , p_message_name => PO_MESSAGE_S.PO_IDV_MAX_TOT_QTY_LE_LIN_TQTY
1666: );
1667: END IF;
1668: END LOOP;
1669:
1716: (
1717: p_entity_type => c_ENTITY_TYPE_LINE
1718: , p_entity_id => p_line_id_tbl(i)
1719: , p_column_name => c_CLM_MAX_TOTAL_QUANTITY
1720: , p_message_name => PO_MESSAGE_S.PO_IDV_MAX_TOT_QTY_GE_MIN_TQTY
1721: );
1722: END IF;
1723: END LOOP;
1724:
1771: (
1772: p_entity_type => c_ENTITY_TYPE_LINE
1773: , p_entity_id => p_line_id_tbl(i)
1774: , p_column_name => c_CLM_MAX_ORDER_AMOUNT
1775: , p_message_name => PO_MESSAGE_S.PO_IDV_MAX_ORD_AMT_LE_MAX_TAMT
1776: );
1777: END IF;
1778: END LOOP;
1779:
1826: (
1827: p_entity_type => c_ENTITY_TYPE_LINE
1828: , p_entity_id => p_line_id_tbl(i)
1829: , p_column_name => c_CLM_MAX_ORDER_AMOUNT
1830: , p_message_name => PO_MESSAGE_S.PO_IDV_MAX_ORD_AMT_GE_MIN_OAMT
1831: );
1832: END IF;
1833: END LOOP;
1834:
1880: (
1881: p_entity_type => c_ENTITY_TYPE_LINE
1882: , p_entity_id => p_line_id_tbl(i)
1883: , p_column_name => c_CLM_MAX_ORDER_QUANTITY
1884: , p_message_name => PO_MESSAGE_S.PO_IDV_MAX_ORD_QTY_LE_MAX_TQTY
1885: );
1886: END IF;
1887: END LOOP;
1888:
1935: (
1936: p_entity_type => c_ENTITY_TYPE_LINE
1937: , p_entity_id => p_line_id_tbl(i)
1938: , p_column_name => c_CLM_MAX_ORDER_QUANTITY
1939: , p_message_name => PO_MESSAGE_S.PO_IDV_MAX_ORD_QTY_GE_MIN_OQTY
1940: );
1941: END IF;
1942: END LOOP;
1943:
1974: , p_line_id_tbl => p_line_id_tbl
1975: , p_start_date_tbl => p_start_date_tbl
1976: , p_expiration_date_tbl => NULL
1977: , p_column_name => c_START_DATE
1978: , p_message_name => PO_MESSAGE_S.PO_CHNG_OTL_INVALID_START_DATE
1979: , x_results => x_results
1980: , x_result_type => x_result_type
1981: );
1982:
2007: , p_line_id_tbl => p_line_id_tbl
2008: , p_start_date_tbl => NULL
2009: , p_expiration_date_tbl => p_expiration_date_tbl
2010: , p_column_name => c_EXPIRATION_DATE
2011: , p_message_name => PO_MESSAGE_S.PO_CHNG_OTL_INVALID_END_DATE
2012: , x_results => x_results
2013: , x_result_type => x_result_type
2014: );
2015:
2073: , p_value_tbl => l_unit_price_tbl
2074: , p_entity_id_tbl => l_line_id_tbl
2075: , p_entity_type => c_ENTITY_TYPE_LINE
2076: , p_column_name => c_UNIT_PRICE
2077: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
2078: , x_results => x_results
2079: , x_result_type => x_result_type
2080: );
2081:
2107: , p_value_tbl => p_list_price_per_unit_tbl
2108: , p_entity_id_tbl => p_line_id_tbl
2109: , p_entity_type => c_ENTITY_TYPE_LINE
2110: , p_column_name => c_LIST_PRICE_PER_UNIT
2111: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
2112: , x_results => x_results
2113: , x_result_type => x_result_type
2114: );
2115:
2134: , p_value_tbl => p_market_price_tbl
2135: , p_entity_id_tbl => p_line_id_tbl
2136: , p_entity_type => c_ENTITY_TYPE_LINE
2137: , p_column_name => c_MARKET_PRICE
2138: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
2139: , x_results => x_results
2140: , x_result_type => x_result_type
2141: );
2142:
2275: , p_entity_id_tbl => p_line_id_tbl
2276: , p_entity_type => c_entity_type_LINE
2277: , p_column_name => c_EXPIRATION_DATE
2278: , p_column_val_selector => PO_VALIDATION_HELPER.c_END_DATE
2279: , p_message_name => PO_MESSAGE_S.POX_EXPIRATION_DATES
2280: , x_results => x_results
2281: , x_result_type => x_result_type
2282: );
2283:
2307: , p_entity_id_tbl => p_line_id_tbl
2308: , p_entity_type => c_entity_type_LINE
2309: , p_column_name => c_EXPIRATION_DATE
2310: , p_column_val_selector => PO_VALIDATION_HELPER.c_START_DATE
2311: , p_message_name => PO_MESSAGE_S.POX_EXPIRATION_DATES
2312: , x_results => x_results
2313: , x_result_type => x_result_type
2314: );
2315:
2337: , p_value_tbl => p_recoupment_rate_tbl
2338: , p_entity_id_tbl => p_line_id_tbl
2339: , p_entity_type => c_ENTITY_TYPE_LINE
2340: , p_column_name => c_RECOUPMENT_RATE
2341: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT
2342: , x_results => x_results
2343: , x_result_type => x_result_type
2344: );
2345:
2360: , p_value_tbl => p_retainage_rate_tbl
2361: , p_entity_id_tbl => p_line_id_tbl
2362: , p_entity_type => c_ENTITY_TYPE_LINE
2363: , p_column_name => c_RETAINAGE_RATE
2364: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT
2365: , x_results => x_results
2366: , x_result_type => x_result_type
2367: );
2368:
2383: , p_value_tbl => p_prog_pay_rate_tbl
2384: , p_entity_id_tbl => p_line_id_tbl
2385: , p_entity_type => c_ENTITY_TYPE_LINE
2386: , p_column_name => c_PROGRESS_PAYMENT_RATE
2387: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_PERCENT
2388: , x_results => x_results
2389: , x_result_type => x_result_type
2390: );
2391:
2419: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2420: END IF;
2421:
2422: --
2423: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_BILL
2424: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_RECV
2425:
2426: FORALL i IN 1 .. p_line_id_tbl.COUNT
2427: INSERT INTO PO_VALIDATION_RESULTS_GT
2420: END IF;
2421:
2422: --
2423: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_BILL
2424: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_RECV
2425:
2426: FORALL i IN 1 .. p_line_id_tbl.COUNT
2427: INSERT INTO PO_VALIDATION_RESULTS_GT
2428: ( result_set_id
2514: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
2515: END IF;
2516:
2517: --
2518: -- PO_MESSAGE_S.PO_PO_QTY_LT_MILESTONE_BILL
2519:
2520: FORALL i IN 1 .. p_line_id_tbl.COUNT
2521: INSERT INTO PO_VALIDATION_RESULTS_GT
2522: ( result_set_id
2618: x_results.add_result(
2619: p_entity_type => c_ENTITY_TYPE_LINE
2620: , p_entity_id => p_line_id_tbl(i)
2621: , p_column_name => c_UNIT_MEAS_LOOKUP_CODE
2622: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
2623: );
2624: end if;
2625: END IF;
2626: END LOOP;
2663: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_item_description_tbl)
2664: , p_entity_id_tbl => p_line_id_tbl
2665: , p_entity_type => c_entity_type_LINE
2666: , p_column_name => c_ITEM_DESCRIPTION
2667: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
2668: , x_results => x_results
2669: , x_result_type => x_result_type
2670: );
2671:
2716: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(l_category_id_tbl)
2717: , p_entity_id_tbl => l_line_id_tbl
2718: , p_entity_type => c_entity_type_LINE
2719: , p_column_name => c_CATEGORY_ID
2720: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
2721: , x_results => x_results
2722: , x_result_type => x_result_type
2723: );
2724:
2874: x_results.add_result(
2875: p_entity_type => c_ENTITY_TYPE_LINE
2876: , p_entity_id => p_line_id_tbl(i)
2877: , p_column_name => c_JOB_ID
2878: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
2879: );
2880: END IF;
2881: END LOOP;
2882:
2943: x_results.add_result(
2944: p_entity_type => c_ENTITY_TYPE_LINE
2945: , p_entity_id => p_line_id_tbl(i)
2946: , p_column_name => c_FROM_LINE_ID
2947: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
2948: );
2949: END IF;
2950: END IF;
2951:
3014: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(l_line_type_id_tbl)
3015: , p_entity_id_tbl => l_line_id_tbl
3016: , p_entity_type => c_entity_type_LINE
3017: , p_column_name => c_LINE_TYPE_ID
3018: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
3019: , x_results => x_results
3020: , x_result_type => x_result_type
3021: );
3022:
3058: x_results.add_result(
3059: p_entity_type => c_ENTITY_TYPE_LINE
3060: , p_entity_id => p_line_id_tbl(i)
3061: , p_column_name => c_START_DATE
3062: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
3063: );
3064: END IF;
3065: END LOOP;
3066:
3271: x_results.add_result(
3272: p_entity_type => c_ENTITY_TYPE_LINE
3273: , p_entity_id => p_line_id_tbl(i)
3274: , p_column_name => c_FROM_LINE_ID
3275: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
3276: );
3277: END IF; -- IF ((l_src_doc_type_lookup_code = c_BLANKET
3278:
3279: END IF; -- IF (l_from_header_id <> NULL)
3321: , p_value_tbl => p_max_retain_amt_tbl
3322: , p_entity_id_tbl => p_line_id_tbl
3323: , p_entity_type => c_ENTITY_TYPE_LINE
3324: , p_column_name => c_MAX_RETAINAGE_AMOUNT
3325: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
3326: , x_results => x_results
3327: , x_result_type => x_result_type
3328: );
3329:
3375: , c_ENTITY_TYPE_LINE
3376: , p_line_id_tbl(i)
3377: , c_MAX_RETAINAGE_AMOUNT
3378: , TO_CHAR(p_max_retain_amt_tbl(i))
3379: , PO_MESSAGE_S.PO_MAX_RET_AMT_GE_RETAINED
3380: , PO_MESSAGE_S.c_MAX_RET_AMT_token
3381: , TO_CHAR(p_max_retain_amt_tbl(i))
3382: , PO_MESSAGE_S.c_AMT_RETAINED_token
3383: , TO_CHAR(LOCATIONS_TOTAL.amount_retained)
3376: , p_line_id_tbl(i)
3377: , c_MAX_RETAINAGE_AMOUNT
3378: , TO_CHAR(p_max_retain_amt_tbl(i))
3379: , PO_MESSAGE_S.PO_MAX_RET_AMT_GE_RETAINED
3380: , PO_MESSAGE_S.c_MAX_RET_AMT_token
3381: , TO_CHAR(p_max_retain_amt_tbl(i))
3382: , PO_MESSAGE_S.c_AMT_RETAINED_token
3383: , TO_CHAR(LOCATIONS_TOTAL.amount_retained)
3384: FROM
3378: , TO_CHAR(p_max_retain_amt_tbl(i))
3379: , PO_MESSAGE_S.PO_MAX_RET_AMT_GE_RETAINED
3380: , PO_MESSAGE_S.c_MAX_RET_AMT_token
3381: , TO_CHAR(p_max_retain_amt_tbl(i))
3382: , PO_MESSAGE_S.c_AMT_RETAINED_token
3383: , TO_CHAR(LOCATIONS_TOTAL.amount_retained)
3384: FROM
3385: ( SELECT NVL(SUM(POLL.retainage_withheld_amount),0) amount_retained
3386: FROM
3890: column_val)
3891: SELECT x_result_set_id,
3892: c_entity_type_LINE
3893: ,p_line_id_tbl(i)
3894: ,PO_MESSAGE_S.PO_MOD_CANCEL_INVALID
3895: ,c_CONTROL_ACTION
3896: ,TO_CHAR(p_control_action_tbl(i))
3897: FROM DUAL
3898: WHERE nvl(p_control_action_tbl(i), '*') = 'CANCEL'
4036: , c_entity_type_LINE
4037: , CHILD.index_num2
4038: , c_LINE_NUM_DISP
4039: , CHILD.char1
4040: , PO_MESSAGE_S.PO_PO_ENTER_UNIQUE_LINE_NUM
4041: FROM
4042: PO_SESSION_GT CHILD
4043: WHERE
4044: CHILD.key = l_data_key
4661: x_results.add_result(
4662: p_entity_type => c_ENTITY_TYPE_LINE
4663: , p_entity_id => p_intf_line_id_tbl(i)
4664: , p_column_name => c_CLM_OPTION_NUM
4665: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
4666: );
4667: l_results_count := l_results_count + 1;
4668: ELSIF p_clm_option_num_tbl(i) IS NOT NULL
4669: THEN
5089: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_comments_tbl)
5090: , p_entity_id_tbl => p_line_id_tbl
5091: , p_entity_type => c_entity_type_LINE
5092: , p_column_name => c_COMMENTS
5093: , p_message_name => PO_MESSAGE_S.PO_PAR_COMMENTS_NOT_NULL
5094: , x_results => x_results
5095: , x_result_type => x_result_type
5096: );
5097:
5151: , c_ENTITY_TYPE_LINE
5152: , p_line_id_tbl(i)
5153: , c_CLM_EXHIBIT_NAME
5154: , TO_CHAR(p_exhibit_name_tbl(i))
5155: , PO_MESSAGE_S.PO_INVALID_EXHIBIT_NAME
5156:
5157: FROM PO_LINES_MERGE_V POL
5158: WHERE NOT EXISTS (SELECT 1
5159: FROM FND_LOOKUP_VALUES LK
5293: , p_num2_tbl => l_extended_price_tbl
5294: , p_entity_id_tbl => l_po_line_uca_id_tbl
5295: , p_entity_type => PO_VALIDATIONS.c_entity_type_LINE_UCAS
5296: , p_column_name => 'UNDEF_AMOUNT'
5297: , p_message_name => PO_MESSAGE_S.PO_UCA_UNDEF_LE_LINE_AMT
5298: , x_results => x_results
5299: , x_result_type => x_result_type);
5300:
5301: ELSE --IF MOD DOC