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 OZF_UTILITY_PVT

Line 879: OZF_UTILITY_PVT.debug_message('Private API: Create trade profile');

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;
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,

Line 1102: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1098: END IF;
1099:
1100: -- Debug Message
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

Line 1112: WHEN OZF_Utility_PVT.resource_locked THEN

1108: p_data => x_msg_data
1109: );
1110:
1111: EXCEPTION
1112: WHEN OZF_Utility_PVT.resource_locked THEN
1113: x_return_status := FND_API.g_ret_sts_error;
1114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1115: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
1116: FND_MSG_PUB.add;

Line 1201: -- OZF_UTILITY_PVT.debug_message('IN UPDATE_Supp_Trade_Profile_PVT org id '||p_supp_trade_profile_rec.org_id);

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
1204: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1205: p_api_version_number,

Line 1218: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1214: THEN
1215: FND_MSG_PUB.initialize;
1216: END IF;
1217: -- Debug Message
1218: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1219: -- Initialize API return status to SUCCESS
1220: x_return_status := FND_API.G_RET_STS_SUCCESS;
1221: l_org_id := l_tar_supp_trade_profile_rec.org_id; -- R12 Enhancements
1222:

Line 1225: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

1221: l_org_id := l_tar_supp_trade_profile_rec.org_id; -- R12 Enhancements
1222:
1223: -- Debug Message
1224: IF g_debug THEN
1225: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
1226: END IF;
1227: OPEN c_supp_trade;
1228: FETCH c_supp_trade INTO l_ref_supp_trade_profile_rec;
1229: IF ( c_supp_trade%NOTFOUND) THEN

Line 1239: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');

1235: END IF;
1236: CLOSE c_supp_trade;
1237: -- Debug Message
1238: IF g_debug THEN
1239: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
1240: END IF;
1241:
1242: IF (l_tar_supp_trade_profile_rec.object_version_number is NULL or
1243: l_tar_supp_trade_profile_rec.object_version_number = FND_API.G_MISS_NUM ) THEN

Line 1270: OZF_UTILITY_PVT.debug_message('Calling create in update method');

1266: IF l_supp_id <> p_supp_trade_profile_rec.supplier_id or
1267: l_supp_site_id <> p_supp_trade_profile_rec.supplier_site_id
1268: THEN
1269: IF g_debug THEN
1270: OZF_UTILITY_PVT.debug_message('Calling create in update method');
1271: END IF;
1272: Create_Supp_Trade_Profile (
1273: p_api_version_number => 1.0,
1274: p_init_msg_list => FND_API.G_FALSE,

Line 1296: OZF_UTILITY_PVT.debug_message('In the update');

1292: p_supp_trade_profile_rec => p_supp_trade_profile_rec,
1293: x_complete_rec => l_supp_trade_profile_rec
1294: );
1295: IF g_debug THEN
1296: OZF_UTILITY_PVT.debug_message('In the update');
1297: END IF;
1298: -- populate defaults
1299: populate_supp_defaults (p_supp_trade_profile_rec => l_supp_trade_profile_rec,
1300: x_supp_trade_profile_rec => l_x_supp_trade_profile_rec,

Line 1465: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1461: COMMIT WORK;
1462: END IF;
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,

Line 1473: WHEN OZF_Utility_PVT.resource_locked THEN

1469: (p_count => x_msg_count,
1470: p_data => x_msg_data
1471: );
1472: EXCEPTION
1473: WHEN OZF_Utility_PVT.resource_locked THEN
1474: x_return_status := FND_API.g_ret_sts_error;
1475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1476: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
1477: FND_MSG_PUB.add;

Line 1547: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1543: FND_MSG_PUB.initialize;
1544: END IF;
1545: -- Debug Message
1546: IF g_debug THEN
1547: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1548: END IF;
1549: -- Initialize API return status to SUCCESS
1550: x_return_status := FND_API.G_RET_STS_SUCCESS;
1551: -- Api body

Line 1555: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

1551: -- Api body
1552: --
1553: -- Debug Message
1554: IF g_debug THEN
1555: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1556: END IF;
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);

Line 1568: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1564: COMMIT WORK;
1565: END IF;
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,

Line 1577: WHEN OZF_Utility_PVT.resource_locked THEN

1573: p_data => x_msg_data
1574: );
1575:
1576: EXCEPTION
1577: WHEN OZF_Utility_PVT.resource_locked THEN
1578: x_return_status := FND_API.g_ret_sts_error;
1579: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1580: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
1581: FND_MSG_PUB.add;

Line 1641: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1637: FOR UPDATE NOWAIT;
1638: BEGIN
1639: -- Debug Message
1640: IF g_debug THEN
1641: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1642: END IF;
1643:
1644: -- Initialize message list if p_init_msg_list is set to TRUE.
1645: IF FND_API.to_Boolean( p_init_msg_list )

Line 1662: OZF_Utility_PVT.debug_message(l_full_name||': start');

1658: -- Initialize API return status to SUCCESS
1659: x_return_status := FND_API.G_RET_STS_SUCCESS;
1660: ------------------------ lock -------------------------
1661: IF g_debug THEN
1662: OZF_Utility_PVT.debug_message(l_full_name||': start');
1663: END IF;
1664: OPEN c_Supp_Trade_Profile;
1665: FETCH c_Supp_Trade_Profile INTO l_SUPP_TRADE_PROFILE_ID;
1666: IF (c_Supp_Trade_Profile%NOTFOUND) THEN

Line 1681: OZF_Utility_PVT.debug_message(l_full_name ||': end');

1677: p_encoded => FND_API.g_false,
1678: p_count => x_msg_count,
1679: p_data => x_msg_data);
1680: IF g_debug THEN
1681: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1682: END IF;
1683: EXCEPTION
1684: WHEN OZF_Utility_PVT.resource_locked THEN
1685: x_return_status := FND_API.g_ret_sts_error;

Line 1684: WHEN OZF_Utility_PVT.resource_locked THEN

1680: IF g_debug THEN
1681: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1682: END IF;
1683: EXCEPTION
1684: WHEN OZF_Utility_PVT.resource_locked THEN
1685: x_return_status := FND_API.g_ret_sts_error;
1686: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1687: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES LOCKED');
1688: FND_MSG_PUB.add;

Line 1978: WHEN OZF_Utility_PVT.resource_locked THEN

1974: (p_count => x_msg_count,
1975: p_data => x_msg_data
1976: );
1977: EXCEPTION
1978: WHEN OZF_Utility_PVT.resource_locked THEN
1979: x_return_status := FND_API.g_ret_sts_error;
1980: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1981: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
1982: FND_MSG_PUB.add;

Line 2149: OZF_UTILITY_PVT.debug_message('Private API: Validate the trade profile record');

2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2146: END IF ;
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,