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.OZF_SUPP_TRADE_PROFILE_PVT dependencies on STANDARD

Line 876: -- Standard Start of API savepoint

872: WHERE cust_account_id = c_id;
873:
874: BEGIN
875:
876: -- Standard Start of API savepoint
877: SAVEPOINT Create_Supp_Trade_Profile_PVT;
878: IF g_debug THEN
879: OZF_UTILITY_PVT.debug_message('Private API: Create trade profile');
880: END IF;

Line 881: -- Standard call to check for call compatibility.

877: SAVEPOINT Create_Supp_Trade_Profile_PVT;
878: IF g_debug THEN
879: OZF_UTILITY_PVT.debug_message('Private API: Create trade profile');
880: END IF;
881: -- Standard call to check for call compatibility.
882: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
883: p_api_version_number,
884: l_api_name,
885: G_PKG_NAME)

Line 1094: -- Standard check for p_commit

1090: --
1091: -- End of API body
1092: --
1093:
1094: -- Standard check for p_commit
1095: IF FND_API.to_Boolean( p_commit )
1096: THEN
1097: COMMIT WORK;
1098: END IF;

Line 1105: -- Standard call to get message count and if count is 1, get message info.

1101: IF g_debug THEN
1102: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1103: END IF;
1104:
1105: -- Standard call to get message count and if count is 1, get message info.
1106: FND_MSG_PUB.Count_And_Get
1107: (p_count => x_msg_count,
1108: p_data => x_msg_data
1109: );

Line 1121: -- Standard call to get message count and if count=1, get the message

1117: END IF;
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: ROLLBACK TO Create_Supp_Trade_Profile_PVT;
1120: x_return_status := FND_API.G_RET_STS_ERROR;
1121: -- Standard call to get message count and if count=1, get the message
1122: FND_MSG_PUB.Count_And_Get (
1123: p_encoded => FND_API.G_FALSE,
1124: p_count => x_msg_count,
1125: p_data => x_msg_data

Line 1130: -- Standard call to get message count and if count=1, get the message

1126: );
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO Create_Supp_Trade_Profile_PVT;
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130: -- Standard call to get message count and if count=1, get the message
1131: FND_MSG_PUB.Count_And_Get (
1132: p_encoded => FND_API.G_FALSE,
1133: p_count => x_msg_count,
1134: p_data => x_msg_data

Line 1143: -- Standard call to get message count and if count=1, get the message

1139: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1140: THEN
1141: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1142: END IF;
1143: -- Standard call to get message count and if count=1, get the message
1144: FND_MSG_PUB.Count_And_Get (
1145: p_encoded => FND_API.G_FALSE,
1146: p_count => x_msg_count,
1147: p_data => x_msg_data

Line 1199: -- Standard Start of API savepoint

1195: WHERE supp_trade_profile_id = p_id;
1196:
1197:
1198: BEGIN
1199: -- Standard Start of API savepoint
1200: SAVEPOINT UPDATE_Supp_Trade_Profile_PVT;
1201: -- OZF_UTILITY_PVT.debug_message('IN UPDATE_Supp_Trade_Profile_PVT org id '||p_supp_trade_profile_rec.org_id);
1202: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1203: -- Standard call to check for call compatibility

Line 1203: -- Standard call to check for call compatibility

1199: -- Standard Start of API savepoint
1200: SAVEPOINT UPDATE_Supp_Trade_Profile_PVT;
1201: -- OZF_UTILITY_PVT.debug_message('IN UPDATE_Supp_Trade_Profile_PVT org id '||p_supp_trade_profile_rec.org_id);
1202: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1203: -- Standard call to check for call compatibility
1204: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1205: p_api_version_number,
1206: l_api_name,
1207: G_PKG_NAME

Line 1458: -- Standard check for p_commit

1454: -- set the return object version number
1455: x_object_version_number := l_supp_trade_profile_rec.object_version_number;
1456: END IF; -- end of check for create or update of trade profile
1457: -- End of API body.
1458: -- Standard check for p_commit
1459: IF FND_API.to_Boolean( p_commit )
1460: THEN
1461: COMMIT WORK;
1462: END IF;

Line 1467: -- Standard call to get message count and if count is 1, get message info.

1463: -- Debug Message
1464: IF g_debug THEN
1465: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1466: END IF;
1467: -- Standard call to get message count and if count is 1, get message info.
1468: FND_MSG_PUB.Count_And_Get
1469: (p_count => x_msg_count,
1470: p_data => x_msg_data
1471: );

Line 1482: -- Standard call to get message count and if count=1, get the message

1478: END IF;
1479: WHEN FND_API.G_EXC_ERROR THEN
1480: ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;
1481: x_return_status := FND_API.G_RET_STS_ERROR;
1482: -- Standard call to get message count and if count=1, get the message
1483: FND_MSG_PUB.Count_And_Get (
1484: p_encoded => FND_API.G_FALSE,
1485: p_count => x_msg_count,
1486: p_data => x_msg_data

Line 1491: -- Standard call to get message count and if count=1, get the message

1487: );
1488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1489: ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;
1490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1491: -- Standard call to get message count and if count=1, get the message
1492: FND_MSG_PUB.Count_And_Get (
1493: p_encoded => FND_API.G_FALSE,
1494: p_count => x_msg_count,
1495: p_data => x_msg_data

Line 1504: -- Standard call to get message count and if count=1, get the message

1500: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1501: THEN
1502: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1503: END IF;
1504: -- Standard call to get message count and if count=1, get the message
1505: FND_MSG_PUB.Count_And_Get (
1506: p_encoded => FND_API.G_FALSE,
1507: p_count => x_msg_count,
1508: p_data => x_msg_data

Line 1530: -- Standard Start of API savepoint

1526: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1527: l_object_version_number NUMBER;
1528:
1529: BEGIN
1530: -- Standard Start of API savepoint
1531: SAVEPOINT Delete_Supp_Trade_Profile_PVT;
1532: -- Standard call to check for call compatibility.
1533: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1534: p_api_version_number,

Line 1532: -- Standard call to check for call compatibility.

1528:
1529: BEGIN
1530: -- Standard Start of API savepoint
1531: SAVEPOINT Delete_Supp_Trade_Profile_PVT;
1532: -- Standard call to check for call compatibility.
1533: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1534: p_api_version_number,
1535: l_api_name,
1536: G_PKG_NAME)

Line 1561: -- Standard check for p_commit

1557: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Delete_Row)
1558: OZF_supp_trd_prfls_PKG.Delete_Row(
1559: p_SUPP_TRADE_PROFILE_ID => p_SUPP_TRADE_PROFILE_ID);
1560: -- End of API body
1561: -- Standard check for p_commit
1562: IF FND_API.to_Boolean( p_commit )
1563: THEN
1564: COMMIT WORK;
1565: END IF;

Line 1570: -- Standard call to get message count and if count is 1, get message info.

1566: -- Debug Message
1567: IF g_debug THEN
1568: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1569: END IF;
1570: -- Standard call to get message count and if count is 1, get message info.
1571: FND_MSG_PUB.Count_And_Get
1572: (p_count => x_msg_count,
1573: p_data => x_msg_data
1574: );

Line 1586: -- Standard call to get message count and if count=1, get the message

1582: END IF;
1583: WHEN FND_API.G_EXC_ERROR THEN
1584: ROLLBACK TO Delete_Supp_Trade_Profile_PVT;
1585: x_return_status := FND_API.G_RET_STS_ERROR;
1586: -- Standard call to get message count and if count=1, get the message
1587: FND_MSG_PUB.Count_And_Get (
1588: p_encoded => FND_API.G_FALSE,
1589: p_count => x_msg_count,
1590: p_data => x_msg_data

Line 1596: -- Standard call to get message count and if count=1, get the message

1592:
1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1594: ROLLBACK TO Delete_Supp_Trade_Profile_PVT;
1595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1596: -- Standard call to get message count and if count=1, get the message
1597: FND_MSG_PUB.Count_And_Get (
1598: p_encoded => FND_API.G_FALSE,
1599: p_count => x_msg_count,
1600: p_data => x_msg_data

Line 1609: -- Standard call to get message count and if count=1, get the message

1605: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1606: THEN
1607: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1608: END IF;
1609: -- Standard call to get message count and if count=1, get the message
1610: FND_MSG_PUB.Count_And_Get (
1611: p_encoded => FND_API.G_FALSE,
1612: p_count => x_msg_count,
1613: p_data => x_msg_data

Line 1650: -- Standard call to check for call compatibility.

1646: THEN
1647: FND_MSG_PUB.initialize;
1648: END IF;
1649:
1650: -- Standard call to check for call compatibility.
1651: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1652: p_api_version_number,
1653: l_api_name,
1654: G_PKG_NAME)

Line 1693: -- Standard call to get message count and if count=1, get the message

1689: END IF;
1690: WHEN FND_API.G_EXC_ERROR THEN
1691: ROLLBACK TO LOCK_Supp_Trade_Profile_PVT;
1692: x_return_status := FND_API.G_RET_STS_ERROR;
1693: -- Standard call to get message count and if count=1, get the message
1694: FND_MSG_PUB.Count_And_Get (
1695: p_encoded => FND_API.G_FALSE,
1696: p_count => x_msg_count,
1697: p_data => x_msg_data

Line 1702: -- Standard call to get message count and if count=1, get the message

1698: );
1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1700: ROLLBACK TO LOCK_Supp_Trade_Profile_PVT;
1701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1702: -- Standard call to get message count and if count=1, get the message
1703: FND_MSG_PUB.Count_And_Get (
1704: p_encoded => FND_API.G_FALSE,
1705: p_count => x_msg_count,
1706: p_data => x_msg_data

Line 1715: -- Standard call to get message count and if count=1, get the message

1711: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1712: THEN
1713: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1714: END IF;
1715: -- Standard call to get message count and if count=1, get the message
1716: FND_MSG_PUB.Count_And_Get (
1717: p_encoded => FND_API.G_FALSE,
1718: p_count => x_msg_count,
1719: p_data => x_msg_data

Line 1927: -- Standard Start of API savepoint

1923: l_object_version_number NUMBER;
1924: l_supp_trade_profile_rec OZF_SUPP_TRADE_PROFILE_PVT.supp_trade_profile_rec_type;
1925:
1926: BEGIN
1927: -- Standard Start of API savepoint
1928: SAVEPOINT VALIDATE_Supp_Trade_Prfl_PVT;
1929: -- Standard call to check for call compatibility.
1930: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1931: p_api_version_number,

Line 1929: -- Standard call to check for call compatibility.

1925:
1926: BEGIN
1927: -- Standard Start of API savepoint
1928: SAVEPOINT VALIDATE_Supp_Trade_Prfl_PVT;
1929: -- Standard call to check for call compatibility.
1930: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1931: p_api_version_number,
1932: l_api_name,
1933: G_PKG_NAME)

Line 1972: -- Standard call to get message count and if count is 1, get message info.

1968: END IF;
1969:
1970: -- Initialize API return status to SUCCESS
1971: x_return_status := FND_API.G_RET_STS_SUCCESS;
1972: -- Standard call to get message count and if count is 1, get message info.
1973: FND_MSG_PUB.Count_And_Get
1974: (p_count => x_msg_count,
1975: p_data => x_msg_data
1976: );

Line 1987: -- Standard call to get message count and if count=1, get the message

1983: END IF;
1984: WHEN FND_API.G_EXC_ERROR THEN
1985: ROLLBACK TO VALIDATE_Supp_Trade_Prfl_PVT;
1986: x_return_status := FND_API.G_RET_STS_ERROR;
1987: -- Standard call to get message count and if count=1, get the message
1988: FND_MSG_PUB.Count_And_Get (
1989: p_encoded => FND_API.G_FALSE,
1990: p_count => x_msg_count,
1991: p_data => x_msg_data

Line 1996: -- Standard call to get message count and if count=1, get the message

1992: );
1993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1994: ROLLBACK TO VALIDATE_Supp_Trade_Prfl_PVT;
1995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1996: -- Standard call to get message count and if count=1, get the message
1997: FND_MSG_PUB.Count_And_Get (
1998: p_encoded => FND_API.G_FALSE,
1999: p_count => x_msg_count,
2000: p_data => x_msg_data

Line 2009: -- Standard call to get message count and if count=1, get the message

2005: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2006: THEN
2007: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2008: END IF;
2009: -- Standard call to get message count and if count=1, get the message
2010: FND_MSG_PUB.Count_And_Get (
2011: p_encoded => FND_API.G_FALSE,
2012: p_count => x_msg_count,
2013: p_data => x_msg_data

Line 2151: -- Standard call to get message count and if count is 1, get message info.

2147: -- Debug Message
2148: IF g_debug THEN
2149: OZF_UTILITY_PVT.debug_message('Private API: Validate the trade profile record');
2150: END IF;
2151: -- Standard call to get message count and if count is 1, get message info.
2152: FND_MSG_PUB.Count_And_Get
2153: (p_count => x_msg_count,
2154: p_data => x_msg_data
2155: );