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.MRP_SOURCING_RULE_PVT dependencies on FND_MSG_PUB

Line 240: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

236: RAISE;
237:
238: WHEN OTHERS THEN
239:
240: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
241: THEN
242: FND_MSG_PUB.Add_Exc_Msg
243: ( G_PKG_NAME
244: , 'Sourcing_Rule'

Line 242: FND_MSG_PUB.Add_Exc_Msg

238: WHEN OTHERS THEN
239:
240: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
241: THEN
242: FND_MSG_PUB.Add_Exc_Msg
243: ( G_PKG_NAME
244: , 'Sourcing_Rule'
245: );
246: END IF;

Line 509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

505: l_Receiving_Org_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: l_Receiving_Org_tbl(I) := l_Receiving_Org_rec;
507: l_old_Receiving_Org_tbl(I) := l_old_Receiving_Org_rec;
508:
509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
510: THEN
511: FND_MSG_PUB.Add_Exc_Msg
512: ( G_PKG_NAME
513: , 'Receiving_Orgs'

Line 511: FND_MSG_PUB.Add_Exc_Msg

507: l_old_Receiving_Org_tbl(I) := l_old_Receiving_Org_rec;
508:
509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
510: THEN
511: FND_MSG_PUB.Add_Exc_Msg
512: ( G_PKG_NAME
513: , 'Receiving_Orgs'
514: );
515: END IF;

Line 540: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

536: RAISE;
537:
538: WHEN OTHERS THEN
539:
540: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
541: THEN
542: FND_MSG_PUB.Add_Exc_Msg
543: ( G_PKG_NAME
544: , 'Receiving_Orgs'

Line 542: FND_MSG_PUB.Add_Exc_Msg

538: WHEN OTHERS THEN
539:
540: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
541: THEN
542: FND_MSG_PUB.Add_Exc_Msg
543: ( G_PKG_NAME
544: , 'Receiving_Orgs'
545: );
546: END IF;

Line 805: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

801: l_Shipping_Org_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
802: l_Shipping_Org_tbl(I) := l_Shipping_Org_rec;
803: l_old_Shipping_Org_tbl(I) := l_old_Shipping_Org_rec;
804:
805: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
806: THEN
807: FND_MSG_PUB.Add_Exc_Msg
808: ( G_PKG_NAME
809: , 'Shipping_Orgs'

Line 807: FND_MSG_PUB.Add_Exc_Msg

803: l_old_Shipping_Org_tbl(I) := l_old_Shipping_Org_rec;
804:
805: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
806: THEN
807: FND_MSG_PUB.Add_Exc_Msg
808: ( G_PKG_NAME
809: , 'Shipping_Orgs'
810: );
811: END IF;

Line 836: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

832: RAISE;
833:
834: WHEN OTHERS THEN
835:
836: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
837: THEN
838: FND_MSG_PUB.Add_Exc_Msg
839: ( G_PKG_NAME
840: , 'Shipping_Orgs'

Line 838: FND_MSG_PUB.Add_Exc_Msg

834: WHEN OTHERS THEN
835:
836: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
837: THEN
838: FND_MSG_PUB.Add_Exc_Msg
839: ( G_PKG_NAME
840: , 'Shipping_Orgs'
841: );
842: END IF;

Line 941: FND_MSG_PUB.initialize;

937:
938: -- Initialize message list.
939:
940: IF FND_API.to_Boolean(p_init_msg_list) THEN
941: FND_MSG_PUB.initialize;
942: END IF;
943:
944: -- Init local table variables.
945:

Line 1035: FND_MSG_PUB.Add;

1031: -- dbms_output.put_line ('Invalid Receiving Organization');
1032: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1033: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receiving_Organization');
1034: FND_MESSAGE.SET_TOKEN('DETAILS', 'Mismatch between SR Organization and Receiving Organization');
1035: FND_MSG_PUB.Add;
1036: l_Receiving_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1037:
1038: END IF;
1039:

Line 1072: FND_MSG_PUB.Add;

1068: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Effective_Date');
1070: FND_MESSAGE.SET_TOKEN('DETAILS', 'Overlapping Effective ' ||
1071: 'Dates not allowed for Receiving Organizations');
1072: FND_MSG_PUB.Add;
1073: l_Receiving_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1074: END IF;
1075:
1076: END LOOP;

Line 1101: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1097: l_Shipping_Org_tbl(I).Sr_Receipt_Id := l_Receiving_Org_tbl(l_Shipping_Org_rec.Receiving_Org_index).Sr_Receipt_Id;
1098:
1099: ELSE
1100:
1101: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1102: THEN
1103:
1104: FND_MESSAGE.SET_NAME('MRP','MRP_API_INV_PARENT_INDEX');
1105: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Shipping_Org');

Line 1108: FND_MSG_PUB.Add;

1104: FND_MESSAGE.SET_NAME('MRP','MRP_API_INV_PARENT_INDEX');
1105: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Shipping_Org');
1106: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
1107: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Shipping_Org_rec.Receiving_Org_index);
1108: FND_MSG_PUB.Add;
1109:
1110: END IF;
1111: END IF;
1112: END IF;

Line 1195: FND_MSG_PUB.Add;

1191: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1192: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1193: FND_MESSAGE.SET_TOKEN('DETAILS', 'Source Organization ' ||
1194: 'should be different from Receiving Organization');
1195: FND_MSG_PUB.Add;
1196: l_Shipping_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1197:
1198: ELSE /* Bug 2263575 */
1199: BEGIN

Line 1210: FND_MSG_PUB.Add;

1206: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1207: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1208: FND_MESSAGE.SET_TOKEN('DETAILS', 'Shipping Network ' ||
1209: 'not defined between source org and receiving org');
1210: FND_MSG_PUB.Add;
1211: l_Shipping_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1212: END;
1213: END IF;
1214: END IF;

Line 1223: FND_MSG_PUB.Add;

1219: -- dbms_output.put_line ('Cannot have source type of Make At for Global SR');
1220: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1221: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Type');
1222: FND_MESSAGE.SET_TOKEN('DETAILS', 'Cannot have source type of Make At for Global SR');
1223: FND_MSG_PUB.Add;
1224: l_Shipping_Org_tbl(I).return_status :=
1225: FND_API.G_RET_STS_ERROR;
1226: END IF;
1227:

Line 1240: FND_MSG_PUB.Add;

1236: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1238: FND_MESSAGE.SET_TOKEN('DETAILS', 'Source Organization ' ||
1239: 'should be same as Receiving Organization');
1240: FND_MSG_PUB.Add;
1241: l_Shipping_Org_tbl(I).return_status :=
1242: FND_API.G_RET_STS_ERROR;
1243: END IF;
1244: END IF;

Line 1253: FND_MSG_PUB.Add;

1249: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1250: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1251: FND_MESSAGE.SET_TOKEN('DETAILS',
1252: 'Source Organization should be NULL');
1253: FND_MSG_PUB.Add;
1254: l_Shipping_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1255: END IF;
1256:
1257: -- We cannot have two shipping orgs with the same rank

Line 1277: FND_MSG_PUB.Add;

1273: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1274: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Rank');
1275: FND_MESSAGE.SET_TOKEN('DETAILS',
1276: 'Cannot have Duplicate Ranks on Shipping Organizations');
1277: FND_MSG_PUB.Add;
1278: l_Shipping_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1279: END IF;
1280:
1281: ***/

Line 1321: FND_MSG_PUB.Add;

1317: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1318: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Rank');
1319: FND_MESSAGE.SET_TOKEN('DETAILS',
1320: 'Total Allocation Percent cannot be greater than 100');
1321: FND_MSG_PUB.Add;
1322: l_Shipping_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1323: END IF;
1324:
1325: END LOOP;

Line 1358: FND_MSG_PUB.Add;

1354: FND_MESSAGE.SET_NAME('MRP','MRP_INCOMPLETE_OBJECT');
1355: FND_MESSAGE.SET_TOKEN('OBJECT','Sourcing_Rule');
1356: FND_MESSAGE.SET_TOKEN('DETAILS',
1357: 'At least one receiving organization is required');
1358: FND_MSG_PUB.Add;
1359: l_sourcing_rule_rec.return_status := FND_API.G_RET_STS_ERROR;
1360: END IF;
1361:
1362: FOR I IN 1..l_Receiving_Org_tbl.COUNT LOOP

Line 1374: FND_MSG_PUB.Add;

1370: FND_MESSAGE.SET_NAME('MRP','MRP_INCOMPLETE_ENTITY');
1371: FND_MESSAGE.SET_TOKEN('ENTITY','Receiving_Org');
1372: FND_MESSAGE.SET_TOKEN('DETAILS',
1373: 'At least one source organization is required');
1374: FND_MSG_PUB.Add;
1375: l_Receiving_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1376: END IF;
1377: END LOOP;
1378:

Line 1432: FND_MSG_PUB.Count_And_Get

1428: END LOOP;
1429:
1430: -- Get message count and data
1431:
1432: FND_MSG_PUB.Count_And_Get
1433: ( p_count => x_msg_count
1434: , p_data => x_msg_data
1435: );
1436:

Line 1446: FND_MSG_PUB.Count_And_Get

1442: x_return_status := FND_API.G_RET_STS_ERROR;
1443:
1444: -- Get message count and data
1445:
1446: FND_MSG_PUB.Count_And_Get
1447: ( p_count => x_msg_count
1448: , p_data => x_msg_data
1449: );
1450:

Line 1457: FND_MSG_PUB.Count_And_Get

1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1454:
1455: -- Get message count and data
1456:
1457: FND_MSG_PUB.Count_And_Get
1458: ( p_count => x_msg_count
1459: , p_data => x_msg_data
1460: );
1461:

Line 1466: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1462: WHEN OTHERS THEN
1463:
1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1465:
1466: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1467: THEN
1468: FND_MSG_PUB.Add_Exc_Msg
1469: ( G_PKG_NAME
1470: , 'Process_Sourcing_Rule'

Line 1468: FND_MSG_PUB.Add_Exc_Msg

1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1465:
1466: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1467: THEN
1468: FND_MSG_PUB.Add_Exc_Msg
1469: ( G_PKG_NAME
1470: , 'Process_Sourcing_Rule'
1471: );
1472: END IF;

Line 1476: FND_MSG_PUB.Count_And_Get

1472: END IF;
1473:
1474: -- Get message count and data
1475:
1476: FND_MSG_PUB.Count_And_Get
1477: ( p_count => x_msg_count
1478: , p_data => x_msg_data
1479: );
1480:

Line 1538: FND_MSG_PUB.initialize;

1534:
1535: -- Initialize message list.
1536:
1537: IF FND_API.to_Boolean(p_init_msg_list) THEN
1538: FND_MSG_PUB.initialize;
1539: END IF;
1540:
1541: -- Set Savepoint
1542:

Line 1618: FND_MSG_PUB.Count_And_Get

1614: x_return_status := FND_API.G_RET_STS_SUCCESS;
1615:
1616: -- Get message count and data
1617:
1618: FND_MSG_PUB.Count_And_Get
1619: ( p_count => x_msg_count
1620: , p_data => x_msg_data
1621: );
1622:

Line 1632: FND_MSG_PUB.Count_And_Get

1628: x_return_status := FND_API.G_RET_STS_ERROR;
1629:
1630: -- Get message count and data
1631:
1632: FND_MSG_PUB.Count_And_Get
1633: ( p_count => x_msg_count
1634: , p_data => x_msg_data
1635: );
1636:

Line 1647: FND_MSG_PUB.Count_And_Get

1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1644:
1645: -- Get message count and data
1646:
1647: FND_MSG_PUB.Count_And_Get
1648: ( p_count => x_msg_count
1649: , p_data => x_msg_data
1650: );
1651:

Line 1660: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1656: WHEN OTHERS THEN
1657:
1658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1659:
1660: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1661: THEN
1662: FND_MSG_PUB.Add_Exc_Msg
1663: ( G_PKG_NAME
1664: , 'Lock_Sourcing_Rule'

Line 1662: FND_MSG_PUB.Add_Exc_Msg

1658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1659:
1660: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1661: THEN
1662: FND_MSG_PUB.Add_Exc_Msg
1663: ( G_PKG_NAME
1664: , 'Lock_Sourcing_Rule'
1665: );
1666: END IF;

Line 1670: FND_MSG_PUB.Count_And_Get

1666: END IF;
1667:
1668: -- Get message count and data
1669:
1670: FND_MSG_PUB.Count_And_Get
1671: ( p_count => x_msg_count
1672: , p_data => x_msg_data
1673: );
1674:

Line 1732: FND_MSG_PUB.initialize;

1728:
1729: -- Initialize message list.
1730:
1731: IF FND_API.to_Boolean(p_init_msg_list) THEN
1732: FND_MSG_PUB.initialize;
1733: END IF;
1734:
1735: -- Get Sourcing_Rule
1736:

Line 1778: FND_MSG_PUB.Count_And_Get

1774: x_return_status := FND_API.G_RET_STS_SUCCESS;
1775:
1776: -- Get message count and data
1777:
1778: FND_MSG_PUB.Count_And_Get
1779: ( p_count => x_msg_count
1780: , p_data => x_msg_data
1781: );
1782:

Line 1792: FND_MSG_PUB.Count_And_Get

1788: x_return_status := FND_API.G_RET_STS_ERROR;
1789:
1790: -- Get message count and data
1791:
1792: FND_MSG_PUB.Count_And_Get
1793: ( p_count => x_msg_count
1794: , p_data => x_msg_data
1795: );
1796:

Line 1803: FND_MSG_PUB.Count_And_Get

1799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1800:
1801: -- Get message count and data
1802:
1803: FND_MSG_PUB.Count_And_Get
1804: ( p_count => x_msg_count
1805: , p_data => x_msg_data
1806: );
1807:

Line 1812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1808: WHEN OTHERS THEN
1809:
1810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1811:
1812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1813: THEN
1814: FND_MSG_PUB.Add_Exc_Msg
1815: ( G_PKG_NAME
1816: , 'Get_Sourcing_Rule'

Line 1814: FND_MSG_PUB.Add_Exc_Msg

1810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1811:
1812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1813: THEN
1814: FND_MSG_PUB.Add_Exc_Msg
1815: ( G_PKG_NAME
1816: , 'Get_Sourcing_Rule'
1817: );
1818: END IF;

Line 1822: FND_MSG_PUB.Count_And_Get

1818: END IF;
1819:
1820: -- Get message count and data
1821:
1822: FND_MSG_PUB.Count_And_Get
1823: ( p_count => x_msg_count
1824: , p_data => x_msg_data
1825: );
1826: