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 769: -- Standard Start of API savepoint

765: WHERE cust_account_id = c_id;
766:
767: BEGIN
768:
769: -- Standard Start of API savepoint
770: SAVEPOINT Create_Supp_Trade_Profile_PVT;
771: IF g_debug THEN
772: OZF_UTILITY_PVT.debug_message('Private API: Create trade profile');
773: END IF;

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

770: SAVEPOINT Create_Supp_Trade_Profile_PVT;
771: IF g_debug THEN
772: OZF_UTILITY_PVT.debug_message('Private API: Create trade profile');
773: END IF;
774: -- Standard call to check for call compatibility.
775: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
776: p_api_version_number,
777: l_api_name,
778: G_PKG_NAME)

Line 975: -- Standard check for p_commit

971: --
972: -- End of API body
973: --
974:
975: -- Standard check for p_commit
976: IF FND_API.to_Boolean( p_commit )
977: THEN
978: COMMIT WORK;
979: END IF;

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

982: IF g_debug THEN
983: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
984: END IF;
985:
986: -- Standard call to get message count and if count is 1, get message info.
987: FND_MSG_PUB.Count_And_Get
988: (p_count => x_msg_count,
989: p_data => x_msg_data
990: );

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

998: END IF;
999: WHEN FND_API.G_EXC_ERROR THEN
1000: ROLLBACK TO Create_Supp_Trade_Profile_PVT;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: -- Standard call to get message count and if count=1, get the message
1003: FND_MSG_PUB.Count_And_Get (
1004: p_encoded => FND_API.G_FALSE,
1005: p_count => x_msg_count,
1006: p_data => x_msg_data

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

1007: );
1008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1009: ROLLBACK TO Create_Supp_Trade_Profile_PVT;
1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1011: -- Standard call to get message count and if count=1, get the message
1012: FND_MSG_PUB.Count_And_Get (
1013: p_encoded => FND_API.G_FALSE,
1014: p_count => x_msg_count,
1015: p_data => x_msg_data

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

1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message
1025: FND_MSG_PUB.Count_And_Get (
1026: p_encoded => FND_API.G_FALSE,
1027: p_count => x_msg_count,
1028: p_data => x_msg_data

Line 1080: -- Standard Start of API savepoint

1076: WHERE supp_trade_profile_id = p_id;
1077:
1078:
1079: BEGIN
1080: -- Standard Start of API savepoint
1081: SAVEPOINT UPDATE_Supp_Trade_Profile_PVT;
1082: -- OZF_UTILITY_PVT.debug_message('IN UPDATE_Supp_Trade_Profile_PVT org id '||p_supp_trade_profile_rec.org_id);
1083: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1084: -- Standard call to check for call compatibility

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

1080: -- Standard Start of API savepoint
1081: SAVEPOINT UPDATE_Supp_Trade_Profile_PVT;
1082: -- OZF_UTILITY_PVT.debug_message('IN UPDATE_Supp_Trade_Profile_PVT org id '||p_supp_trade_profile_rec.org_id);
1083: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1084: -- Standard call to check for call compatibility
1085: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1086: p_api_version_number,
1087: l_api_name,
1088: G_PKG_NAME

Line 1327: -- Standard check for p_commit

1323: -- set the return object version number
1324: x_object_version_number := l_supp_trade_profile_rec.object_version_number;
1325: END IF; -- end of check for create or update of trade profile
1326: -- End of API body.
1327: -- Standard check for p_commit
1328: IF FND_API.to_Boolean( p_commit )
1329: THEN
1330: COMMIT WORK;
1331: END IF;

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

1332: -- Debug Message
1333: IF g_debug THEN
1334: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1335: END IF;
1336: -- Standard call to get message count and if count is 1, get message info.
1337: FND_MSG_PUB.Count_And_Get
1338: (p_count => x_msg_count,
1339: p_data => x_msg_data
1340: );

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

1347: END IF;
1348: WHEN FND_API.G_EXC_ERROR THEN
1349: ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: -- Standard call to get message count and if count=1, get the message
1352: FND_MSG_PUB.Count_And_Get (
1353: p_encoded => FND_API.G_FALSE,
1354: p_count => x_msg_count,
1355: p_data => x_msg_data

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

1356: );
1357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1358: ROLLBACK TO UPDATE_Supp_Trade_Profile_PVT;
1359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1360: -- Standard call to get message count and if count=1, get the message
1361: FND_MSG_PUB.Count_And_Get (
1362: p_encoded => FND_API.G_FALSE,
1363: p_count => x_msg_count,
1364: p_data => x_msg_data

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

1369: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1370: THEN
1371: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1372: END IF;
1373: -- Standard call to get message count and if count=1, get the message
1374: FND_MSG_PUB.Count_And_Get (
1375: p_encoded => FND_API.G_FALSE,
1376: p_count => x_msg_count,
1377: p_data => x_msg_data

Line 1399: -- Standard Start of API savepoint

1395: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1396: l_object_version_number NUMBER;
1397:
1398: BEGIN
1399: -- Standard Start of API savepoint
1400: SAVEPOINT Delete_Supp_Trade_Profile_PVT;
1401: -- Standard call to check for call compatibility.
1402: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1403: p_api_version_number,

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

1397:
1398: BEGIN
1399: -- Standard Start of API savepoint
1400: SAVEPOINT Delete_Supp_Trade_Profile_PVT;
1401: -- Standard call to check for call compatibility.
1402: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1403: p_api_version_number,
1404: l_api_name,
1405: G_PKG_NAME)

Line 1430: -- Standard check for p_commit

1426: -- Invoke table handler(OZF_supp_trd_prfls_PKG.Delete_Row)
1427: OZF_supp_trd_prfls_PKG.Delete_Row(
1428: p_SUPP_TRADE_PROFILE_ID => p_SUPP_TRADE_PROFILE_ID);
1429: -- End of API body
1430: -- Standard check for p_commit
1431: IF FND_API.to_Boolean( p_commit )
1432: THEN
1433: COMMIT WORK;
1434: END IF;

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

1435: -- Debug Message
1436: IF g_debug THEN
1437: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1438: END IF;
1439: -- Standard call to get message count and if count is 1, get message info.
1440: FND_MSG_PUB.Count_And_Get
1441: (p_count => x_msg_count,
1442: p_data => x_msg_data
1443: );

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

1451: END IF;
1452: WHEN FND_API.G_EXC_ERROR THEN
1453: ROLLBACK TO Delete_Supp_Trade_Profile_PVT;
1454: x_return_status := FND_API.G_RET_STS_ERROR;
1455: -- Standard call to get message count and if count=1, get the message
1456: FND_MSG_PUB.Count_And_Get (
1457: p_encoded => FND_API.G_FALSE,
1458: p_count => x_msg_count,
1459: p_data => x_msg_data

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

1461:
1462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1463: ROLLBACK TO Delete_Supp_Trade_Profile_PVT;
1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: -- Standard call to get message count and if count=1, get the message
1466: FND_MSG_PUB.Count_And_Get (
1467: p_encoded => FND_API.G_FALSE,
1468: p_count => x_msg_count,
1469: p_data => x_msg_data

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

1474: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1475: THEN
1476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1477: END IF;
1478: -- Standard call to get message count and if count=1, get the message
1479: FND_MSG_PUB.Count_And_Get (
1480: p_encoded => FND_API.G_FALSE,
1481: p_count => x_msg_count,
1482: p_data => x_msg_data

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

1515: THEN
1516: FND_MSG_PUB.initialize;
1517: END IF;
1518:
1519: -- Standard call to check for call compatibility.
1520: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1521: p_api_version_number,
1522: l_api_name,
1523: G_PKG_NAME)

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

1558: END IF;
1559: WHEN FND_API.G_EXC_ERROR THEN
1560: ROLLBACK TO LOCK_Supp_Trade_Profile_PVT;
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: -- Standard call to get message count and if count=1, get the message
1563: FND_MSG_PUB.Count_And_Get (
1564: p_encoded => FND_API.G_FALSE,
1565: p_count => x_msg_count,
1566: p_data => x_msg_data

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

1567: );
1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1569: ROLLBACK TO LOCK_Supp_Trade_Profile_PVT;
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1571: -- Standard call to get message count and if count=1, get the message
1572: FND_MSG_PUB.Count_And_Get (
1573: p_encoded => FND_API.G_FALSE,
1574: p_count => x_msg_count,
1575: p_data => x_msg_data

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

1580: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1581: THEN
1582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1583: END IF;
1584: -- Standard call to get message count and if count=1, get the message
1585: FND_MSG_PUB.Count_And_Get (
1586: p_encoded => FND_API.G_FALSE,
1587: p_count => x_msg_count,
1588: p_data => x_msg_data

Line 1796: -- Standard Start of API savepoint

1792: l_object_version_number NUMBER;
1793: l_supp_trade_profile_rec OZF_SUPP_TRADE_PROFILE_PVT.supp_trade_profile_rec_type;
1794:
1795: BEGIN
1796: -- Standard Start of API savepoint
1797: SAVEPOINT VALIDATE_Supp_Trade_Prfl_PVT;
1798: -- Standard call to check for call compatibility.
1799: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1800: p_api_version_number,

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

1794:
1795: BEGIN
1796: -- Standard Start of API savepoint
1797: SAVEPOINT VALIDATE_Supp_Trade_Prfl_PVT;
1798: -- Standard call to check for call compatibility.
1799: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1800: p_api_version_number,
1801: l_api_name,
1802: G_PKG_NAME)

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

1837: END IF;
1838:
1839: -- Initialize API return status to SUCCESS
1840: x_return_status := FND_API.G_RET_STS_SUCCESS;
1841: -- Standard call to get message count and if count is 1, get message info.
1842: FND_MSG_PUB.Count_And_Get
1843: (p_count => x_msg_count,
1844: p_data => x_msg_data
1845: );

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

1852: END IF;
1853: WHEN FND_API.G_EXC_ERROR THEN
1854: ROLLBACK TO VALIDATE_Supp_Trade_Prfl_PVT;
1855: x_return_status := FND_API.G_RET_STS_ERROR;
1856: -- Standard call to get message count and if count=1, get the message
1857: FND_MSG_PUB.Count_And_Get (
1858: p_encoded => FND_API.G_FALSE,
1859: p_count => x_msg_count,
1860: p_data => x_msg_data

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

1861: );
1862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1863: ROLLBACK TO VALIDATE_Supp_Trade_Prfl_PVT;
1864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1865: -- Standard call to get message count and if count=1, get the message
1866: FND_MSG_PUB.Count_And_Get (
1867: p_encoded => FND_API.G_FALSE,
1868: p_count => x_msg_count,
1869: p_data => x_msg_data

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

1874: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1875: THEN
1876: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1877: END IF;
1878: -- Standard call to get message count and if count=1, get the message
1879: FND_MSG_PUB.Count_And_Get (
1880: p_encoded => FND_API.G_FALSE,
1881: p_count => x_msg_count,
1882: p_data => x_msg_data

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

2016: -- Debug Message
2017: IF g_debug THEN
2018: OZF_UTILITY_PVT.debug_message('Private API: Validate the trade profile record');
2019: END IF;
2020: -- Standard call to get message count and if count is 1, get message info.
2021: FND_MSG_PUB.Count_And_Get
2022: (p_count => x_msg_count,
2023: p_data => x_msg_data
2024: );