DBA Data[Home] [Help]

APPS.PO_LINK_REQ_DIST_PVT dependencies on PO_MULTI_MOD_VAL_RESULTS_S

Line 1079: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL

1075:
1076: IF L_AT_SOURCING_REQS > 0 THEN
1077:
1078: X_RESULTS.ADD_RESULT(
1079: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL
1080: , P_MULTI_MOD_REQUEST_ID => 1
1081: , P_RESULT_TYPE => 'ERROR'
1082: , P_VALIDATION_TYPE => 'PRE_SUBMIT'
1083: , P_MESSAGE_APPLICATION => 'PO'

Line 1149: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL

1145: -- Validate for the funded value of new distributions should not be greater than the distribution amount.
1146: IF FUND_VAL_GT_DA_CUR.FUNDED_VALUE > FUND_VAL_GT_DA_CUR.DIST_AMT THEN
1147:
1148: X_RESULTS.ADD_RESULT(
1149: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL
1150: , P_MULTI_MOD_REQUEST_ID => 1
1151: , P_RESULT_TYPE => 'ERROR'
1152: , P_VALIDATION_TYPE => 'PRE_SUBMIT'
1153: , P_MESSAGE_APPLICATION => 'PO'

Line 1217: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL

1213: -- Validate for the funded value of new distributions should not be greater than the distribution amount.
1214: IF FUND_VAL_GT_DA_CUR.FUNDED_VALUE > FUND_VAL_GT_DA_CUR.DIST_AMT THEN
1215:
1216: X_RESULTS.ADD_RESULT(
1217: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL
1218: , P_MULTI_MOD_REQUEST_ID => 1
1219: , P_RESULT_TYPE => 'ERROR'
1220: , P_VALIDATION_TYPE => 'PRE_SUBMIT'
1221: , P_MESSAGE_APPLICATION => 'PO'

Line 1255: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL

1251: -- Validate for the Total funded value of new distributions should not be greater than the Funds to use for that requistion.
1252: IF FUNDED_VALUES_C.TOTAL_FUNDED_VALUE > FUNDED_VALUES_C.FUNDS_TO_USE THEN
1253:
1254: X_RESULTS.ADD_RESULT(
1255: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL
1256: , P_MULTI_MOD_REQUEST_ID => 1
1257: , P_RESULT_TYPE => 'ERROR'
1258: , P_VALIDATION_TYPE => 'PRE_SUBMIT'
1259: , P_MESSAGE_APPLICATION => 'PO'

Line 1272: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL

1268: -- Validate for the Total funded value of new distributions should not be greater than the Funds to use for that requistion.
1269: IF FUNDED_VALUES_C.TOTAL_FUNDED_VALUE > FUNDED_VALUES_C.FUNDS_REMAINING THEN
1270:
1271: X_RESULTS.ADD_RESULT(
1272: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL
1273: , P_MULTI_MOD_REQUEST_ID => 1
1274: , P_RESULT_TYPE => 'ERROR'
1275: , P_VALIDATION_TYPE => 'PRE_SUBMIT'
1276: , P_MESSAGE_APPLICATION => 'PO'

Line 1318: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL

1314: FETCH UNIQUE_DIST_NUM_REFCUR INTO L_LINE_NUM, L_SHIPMENT_NUM, L_DISTRIBUTION_NUM ;
1315: EXIT WHEN UNIQUE_DIST_NUM_REFCUR%NOTFOUND;
1316:
1317: X_RESULTS.ADD_RESULT(
1318: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL
1319: , P_MULTI_MOD_REQUEST_ID => 1
1320: , P_RESULT_TYPE => 'ERROR'
1321: , P_VALIDATION_TYPE => 'PRE_SUBMIT'
1322: , P_MESSAGE_APPLICATION => 'PO'

Line 1367: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL

1363: FETCH UNIQUE_DIST_NUM_REFCUR INTO L_LINE_NUM, L_SHIPMENT_NUM, L_DISTRIBUTION_NUM ;
1364: EXIT WHEN UNIQUE_DIST_NUM_REFCUR%NOTFOUND;
1365:
1366: X_RESULTS.ADD_RESULT(
1367: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL
1368: , P_MULTI_MOD_REQUEST_ID => 1
1369: , P_RESULT_TYPE => 'ERROR'
1370: , P_VALIDATION_TYPE => 'PRE_SUBMIT'
1371: , P_MESSAGE_APPLICATION => 'PO'

Line 1420: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL

1416: FETCH UNIQUE_DIST_NUM_REFCUR INTO L_LINE_NUM, L_SHIPMENT_NUM, L_DISTRIBUTION_NUM ;
1417: EXIT WHEN UNIQUE_DIST_NUM_REFCUR%NOTFOUND;
1418:
1419: X_RESULTS.ADD_RESULT(
1420: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL
1421: , P_MULTI_MOD_REQUEST_ID => 1
1422: , P_RESULT_TYPE => 'ERROR'
1423: , P_VALIDATION_TYPE => 'PRE_SUBMIT'
1424: , P_MESSAGE_APPLICATION => 'PO'

Line 1469: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL

1465: EXIT WHEN UNIQUE_DIST_NUM_REFCUR%NOTFOUND;
1466:
1467:
1468: X_RESULTS.ADD_RESULT(
1469: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL
1470: , P_MULTI_MOD_REQUEST_ID => 1
1471: , P_RESULT_TYPE => 'ERROR'
1472: , P_VALIDATION_TYPE => 'PRE_SUBMIT'
1473: , P_MESSAGE_APPLICATION => 'PO'

Line 1539: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL

1535: EXIT WHEN GT_ZERO_VALIDATION_REFCUR%NOTFOUND;
1536:
1537: IF (L_MATCHING_BASIS = 'QUANTITY' AND (L_QUANTITY_ORDERED IS NULL OR L_QUANTITY_ORDERED <= 0)) THEN
1538: X_RESULTS.ADD_RESULT(
1539: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL
1540: , P_MULTI_MOD_REQUEST_ID => 1
1541: , P_RESULT_TYPE => 'ERROR'
1542: , P_VALIDATION_TYPE => 'PRE_SUBMIT'
1543: , P_MESSAGE_APPLICATION => 'PO'

Line 1562: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL

1558:
1559:
1560: IF (L_MATCHING_BASIS = 'AMOUNT' AND (L_AMOUNT_ORDERED IS NULL OR L_AMOUNT_ORDERED <= 0)) THEN
1561: X_RESULTS.ADD_RESULT(
1562: P_MULTI_MOD_VAL_RESULT_ID => PO_MULTI_MOD_VAL_RESULTS_S.NEXTVAL
1563: , P_MULTI_MOD_REQUEST_ID => 1
1564: , P_RESULT_TYPE => 'ERROR'
1565: , P_VALIDATION_TYPE => 'PRE_SUBMIT'
1566: , P_MESSAGE_APPLICATION => 'PO'