eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_MESSAGE_S

Line 170: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO

166: , p_value_tbl => p_dist_num_tbl
167: , p_entity_id_tbl => p_dist_id_tbl
168: , p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
169: , p_column_name => c_DISTRIBUTION_NUM
170: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GT_ZERO
171: , x_results => x_results
172: , x_result_type => x_result_type
173: );
174:

Line 276: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_DEL_NA

272: , TO_CHAR(p_qty_ordered_tbl(i))
273: , (CASE
274: WHEN NVL(POD.quantity_delivered, 0) >
275: GREATEST(NVL(POD.quantity_billed, 0), NVL(POD.quantity_financed, 0))
276: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_DEL_NA
277: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA
278: END
279: )
280: --PBWC Message Change Impact: Adding a token

Line 277: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA

273: , (CASE
274: WHEN NVL(POD.quantity_delivered, 0) >
275: GREATEST(NVL(POD.quantity_billed, 0), NVL(POD.quantity_financed, 0))
276: THEN PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_DEL_NA
277: ELSE PO_MESSAGE_S.PO_PO_QTY_ORD_LT_QTY_BILLED_NA
278: END
279: )
280: --PBWC Message Change Impact: Adding a token
281: , (CASE

Line 284: THEN PO_MESSAGE_S.c_QTY_DEL_token

280: --PBWC Message Change Impact: Adding a token
281: , (CASE
282: WHEN NVL(POD.quantity_delivered, 0) >
283: GREATEST(NVL(POD.quantity_billed, 0), NVL(POD.quantity_financed, 0))
284: THEN PO_MESSAGE_S.c_QTY_DEL_token
285: ELSE PO_MESSAGE_S.c_QTY_BILLED_token
286: END
287: )
288: , (CASE

Line 285: ELSE PO_MESSAGE_S.c_QTY_BILLED_token

281: , (CASE
282: WHEN NVL(POD.quantity_delivered, 0) >
283: GREATEST(NVL(POD.quantity_billed, 0), NVL(POD.quantity_financed, 0))
284: THEN PO_MESSAGE_S.c_QTY_DEL_token
285: ELSE PO_MESSAGE_S.c_QTY_BILLED_token
286: END
287: )
288: , (CASE
289: WHEN NVL(POD.quantity_delivered, 0) >

Line 428: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_DEL_NA

424: , TO_CHAR(p_amt_ordered_tbl(i))
425: , (CASE
426: WHEN NVL(POD.amount_delivered, 0) >
427: GREATEST(NVL(POD.amount_billed, 0), NVL(POD.amount_financed, 0))
428: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_DEL_NA
429: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA
430: END
431: )
432: --PBWC Message Change Impact: Adding a token

Line 429: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA

425: , (CASE
426: WHEN NVL(POD.amount_delivered, 0) >
427: GREATEST(NVL(POD.amount_billed, 0), NVL(POD.amount_financed, 0))
428: THEN PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_DEL_NA
429: ELSE PO_MESSAGE_S.PO_PO_AMT_ORD_LT_AMT_BILLED_NA
430: END
431: )
432: --PBWC Message Change Impact: Adding a token
433: , (CASE

Line 436: THEN PO_MESSAGE_S.c_AMT_DEL_token

432: --PBWC Message Change Impact: Adding a token
433: , (CASE
434: WHEN NVL(POD.amount_delivered, 0) >
435: GREATEST(NVL(POD.amount_billed, 0), NVL(POD.amount_financed, 0))
436: THEN PO_MESSAGE_S.c_AMT_DEL_token
437: ELSE PO_MESSAGE_S.c_AMT_BILLED_token
438: END
439: )
440: , (CASE

Line 437: ELSE PO_MESSAGE_S.c_AMT_BILLED_token

433: , (CASE
434: WHEN NVL(POD.amount_delivered, 0) >
435: GREATEST(NVL(POD.amount_billed, 0), NVL(POD.amount_financed, 0))
436: THEN PO_MESSAGE_S.c_AMT_DEL_token
437: ELSE PO_MESSAGE_S.c_AMT_BILLED_token
438: END
439: )
440: , (CASE
441: WHEN NVL(POD.amount_delivered, 0) >

Line 547: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL -- Bug 5193851 - Changed the message

543: x_results.add_result(
544: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
545: , p_entity_id => p_dist_id_tbl(i)
546: , p_column_name => c_END_ITEM_UNIT_NUMBER
547: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL -- Bug 5193851 - Changed the message
548: );
549:
550: END IF;
551:

Line 628: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS

624: x_results.add_result(
625: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
626: , p_entity_id => p_dist_id_tbl(i)
627: , p_column_name => c_WIP_ENTITY_ID
628: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS
629: );
630: END IF;
631:
632: IF (p_wip_operation_seq_num_tbl(i) IS NULL)

Line 638: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS

634: x_results.add_result(
635: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
636: , p_entity_id => p_dist_id_tbl(i)
637: , p_column_name => c_WIP_OPERATION_SEQ_NUM
638: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS
639: );
640: END IF;
641:
642: -- BR says that if WIP line id is not null,

Line 655: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS

651: x_results.add_result(
652: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
653: , p_entity_id => p_dist_id_tbl(i)
654: , p_column_name => c_WIP_ENTITY_ID
655: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS
656: );
657: END IF;
658:
659: -- If OSP line, then also validate that resource sequence is not null

Line 667: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS

663: x_results.add_result(
664: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
665: , p_entity_id => p_dist_id_tbl(i)
666: , p_column_name => c_WIP_RESOURCE_SEQ_NUM
667: , p_message_name => PO_MESSAGE_S.PO_OOP_ENTER_ALL_FIELDS
668: );
669: END IF;
670: END IF; -- IF (p_destination_type_code_tbl(i) = c_DEST_TYPE_SHOP_FLOOR)
671:

Line 717: , p_message_name => PO_MESSAGE_S.PO_AMT_TO_ENCUM_LT_UNENCUM

713: , p_num2_tbl => p_amount_to_encumber_tbl
714: , p_entity_id_tbl => p_dist_id_tbl
715: , p_entity_type => c_entity_type_DISTRIBUTION
716: , p_column_name => c_AMOUNT_TO_ENCUMBER
717: , p_message_name => PO_MESSAGE_S.PO_AMT_TO_ENCUM_LT_UNENCUM
718: , x_results => x_results
719: , x_result_type => x_result_type
720: );
721:

Line 744: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO

740: , p_value_tbl => p_amount_to_encumber_tbl
741: , p_entity_id_tbl => p_dist_id_tbl
742: , p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
743: , p_column_name => c_AMOUNT_TO_ENCUMBER
744: , p_message_name => PO_MESSAGE_S.PO_ALL_ENTER_VALUE_GE_ZERO
745: , x_results => x_results
746: , x_result_type => x_result_type
747: );
748:

Line 771: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

767: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_budget_account_id_tbl)
768: , p_entity_id_tbl => p_dist_id_tbl
769: , p_entity_type => c_entity_type_DISTRIBUTION
770: , p_column_name => c_BUDGET_ACCOUNT_ID
771: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
772: , x_results => x_results
773: , x_result_type => x_result_type
774: );
775:

Line 798: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

794: , p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_gl_encumbered_date_tbl)
795: , p_entity_id_tbl => p_dist_id_tbl
796: , p_entity_type => c_entity_type_DISTRIBUTION
797: , p_column_name => c_GL_ENCUMBERED_DATE
798: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
799: , x_results => x_results
800: , x_result_type => x_result_type
801: );
802:

Line 861: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

857: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
858: , p_entity_id => p_dist_id_tbl(i)
859: , p_column_name => c_GL_ENCUMBERED_DATE
860: , p_column_val => NULL
861: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
862: );
863:
864: ELSE -- Verify that GL Date is in an open period.
865: po_periods_sv.get_period_name(l_sob_id,

Line 875: , p_message_name => PO_MESSAGE_S.PO_PO_ENTER_OPEN_GL_DATE

871: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
872: , p_entity_id => p_dist_id_tbl(i)
873: , p_column_name => c_GL_ENCUMBERED_DATE
874: , p_column_val => TO_CHAR(p_gl_encumbered_date_tbl(i))
875: , p_message_name => PO_MESSAGE_S.PO_PO_ENTER_OPEN_GL_DATE
876: );
877: END IF;
878:
879: END IF; -- p_gl_date_tbl(i) IS NULL

Line 942: , p_message_name => PO_MESSAGE_S.PO_WRAPPER_MESSAGE

938: x_results.add_result(
939: p_entity_type => c_entity_type_DISTRIBUTION
940: , p_entity_id => l_failure_dist_id_tbl(i)
941: , p_column_name => c_AWARD_ID
942: , p_message_name => PO_MESSAGE_S.PO_WRAPPER_MESSAGE
943: , p_token1_name => PO_MESSAGE_S.c_MESSAGE_token
944: , p_token1_value => l_failure_message_tbl(i)
945: );
946: END LOOP;

Line 943: , p_token1_name => PO_MESSAGE_S.c_MESSAGE_token

939: p_entity_type => c_entity_type_DISTRIBUTION
940: , p_entity_id => l_failure_dist_id_tbl(i)
941: , p_column_name => c_AWARD_ID
942: , p_message_name => PO_MESSAGE_S.PO_WRAPPER_MESSAGE
943: , p_token1_name => PO_MESSAGE_S.c_MESSAGE_token
944: , p_token1_value => l_failure_message_tbl(i)
945: );
946: END LOOP;
947: END IF;

Line 1143: , p_message_name => PO_MESSAGE_S.PO_PDOI_INVALID_FUND_VAL

1139: x_results.add_result(
1140: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
1141: , p_entity_id => p_dist_id_tbl(i)
1142: , p_column_name => c_FUNDED_VALUE
1143: , p_message_name => PO_MESSAGE_S.PO_PDOI_INVALID_FUND_VAL
1144: );
1145:
1146: END IF;
1147:

Line 1265: , p_message_name => PO_MESSAGE_S.PO_PDOI_INVALID_FUND_VAL_ENC

1261: x_results.add_result(
1262: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
1263: , p_entity_id => p_dist_id_tbl(i)
1264: , p_column_name => c_FUNDED_VALUE
1265: , p_message_name => PO_MESSAGE_S.PO_PDOI_INVALID_FUND_VAL_ENC
1266: );
1267: END IF;
1268:
1269: ELSE

Line 1279: , p_message_name => PO_MESSAGE_S.PO_PDOI_INVALID_FUND_VAL

1275: x_results.add_result(
1276: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
1277: , p_entity_id => p_dist_id_tbl(i)
1278: , p_column_name => c_FUNDED_VALUE
1279: , p_message_name => PO_MESSAGE_S.PO_PDOI_INVALID_FUND_VAL
1280: );
1281: END IF;
1282:
1283: END IF;

Line 1364: , p_message_name => PO_MESSAGE_S.PO_PF_QTY_FUND_LT_QTY_BIL_NA

1360: x_results.add_result(
1361: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
1362: , p_entity_id => p_dist_id_tbl(i)
1363: , p_column_name => c_QUANTITY_FUNDED
1364: , p_message_name => PO_MESSAGE_S.PO_PF_QTY_FUND_LT_QTY_BIL_NA
1365: );
1366:
1367: ELSIF (NVL(p_quantity_delivered_tbl(i),0) > NVL(p_quantity_funded_tbl(i),0)) THEN
1368:

Line 1373: , p_message_name => PO_MESSAGE_S.PO_PF_QTY_FUND_LT_QTY_DEL_NA

1369: x_results.add_result(
1370: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
1371: , p_entity_id => p_dist_id_tbl(i)
1372: , p_column_name => c_QUANTITY_FUNDED
1373: , p_message_name => PO_MESSAGE_S.PO_PF_QTY_FUND_LT_QTY_DEL_NA
1374: );
1375:
1376: END IF;
1377:

Line 1461: , p_message_name => PO_MESSAGE_S.PO_PF_AMT_FUND_LT_AMT_BIL_NA

1457: x_results.add_result(
1458: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
1459: , p_entity_id => p_dist_id_tbl(i)
1460: , p_column_name => c_AMOUNT_FUNDED
1461: , p_message_name => PO_MESSAGE_S.PO_PF_AMT_FUND_LT_AMT_BIL_NA
1462: );
1463:
1464: ELSIF (NVL(p_amount_delivered_tbl(i),0) > NVL(p_amount_funded_tbl(i),0)) THEN
1465:

Line 1470: , p_message_name => PO_MESSAGE_S.PO_PF_AMT_FUND_LT_AMT_DEL_NA

1466: x_results.add_result(
1467: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
1468: , p_entity_id => p_dist_id_tbl(i)
1469: , p_column_name => c_AMOUNT_FUNDED
1470: , p_message_name => PO_MESSAGE_S.PO_PF_AMT_FUND_LT_AMT_DEL_NA
1471: );
1472:
1473: END IF;
1474:

Line 1559: , p_message_name => PO_MESSAGE_S.PO_PF_FUND_VAL_GT_BACK_REQ

1555: x_results.add_result(
1556: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
1557: , p_entity_id => p_dist_id_tbl(i)
1558: , p_column_name => c_FUNDED_VALUE
1559: , p_message_name => PO_MESSAGE_S.PO_PF_FUND_VAL_GT_BACK_REQ
1560: );
1561:
1562: END IF;
1563:

Line 1667: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1663: p_entity_type => c_entity_type_DISTRIBUTION
1664: , p_entity_id => p_dist_id_tbl(i)
1665: , p_column_name => 'TASK_ID'
1666: , p_column_val => NULL
1667: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1668: );
1669: END IF;
1670:
1671: IF (p_dest_type_code_tbl(i) = c_DEST_TYPE_EXPENSE) THEN

Line 1701: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1697: p_entity_type => c_entity_type_DISTRIBUTION
1698: , p_entity_id => p_dist_id_tbl(i)
1699: , p_column_name => 'EXPENDITURE_TYPE'
1700: , p_column_val => NULL
1701: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1702: );
1703: END IF; --expenditure type validation check
1704:
1705: IF (p_expenditure_org_id_tbl(i) IS NULL) THEN

Line 1711: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1707: p_entity_type => c_entity_type_DISTRIBUTION
1708: , p_entity_id => p_dist_id_tbl(i)
1709: , p_column_name => 'EXPENDITURE_ORGANIZATION_ID'
1710: , p_column_val => NULL
1711: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1712: );
1713: END IF;
1714:
1715: IF (p_expenditure_item_date_tbl(i) IS NULL) THEN

Line 1721: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

1717: p_entity_type => c_entity_type_DISTRIBUTION
1718: , p_entity_id => p_dist_id_tbl(i)
1719: , p_column_name => 'EXPENDITURE_ITEM_DATE'
1720: , p_column_val => NULL
1721: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
1722: );
1723: END IF;
1724: END IF; -- destination type check
1725: END IF;

Line 1856: PO_MESSAGE_S.PO_FUNDED_VAL_GT_REQ_FUNDS_RMN

1852: x_result_set_id,
1853: c_ENTITY_TYPE_DISTRIBUTION,
1854: GT.index_num1, -- po_distribution_id
1855: c_FUNDED_VALUE,
1856: PO_MESSAGE_S.PO_FUNDED_VAL_GT_REQ_FUNDS_RMN
1857: FROM
1858: PO_SESSION_GT GT
1859: WHERE
1860: GT.key = l_data_key

Line 2110: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL

2106: x_results.add_result(
2107: p_entity_type => c_ENTITY_TYPE_DISTRIBUTION
2108: , p_entity_id => p_intf_dist_id_tbl(i)
2109: , p_column_name => c_CLM_DEFENCE_FUNDING
2110: , p_message_name => PO_MESSAGE_S.PO_ALL_NOT_NULL
2111: );
2112: l_results_count := l_results_count + l_lines_count;
2113: ELSE
2114: BEGIN