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 772: OZF_UTILITY_PVT.debug_message('Private API: Create trade profile');

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

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

979: END IF;
980:
981: -- Debug Message
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

Line 993: WHEN OZF_Utility_PVT.resource_locked THEN

989: p_data => x_msg_data
990: );
991:
992: EXCEPTION
993: WHEN OZF_Utility_PVT.resource_locked THEN
994: x_return_status := FND_API.g_ret_sts_error;
995: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
996: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
997: FND_MSG_PUB.add;

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

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

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

1095: THEN
1096: FND_MSG_PUB.initialize;
1097: END IF;
1098: -- Debug Message
1099: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1100: -- Initialize API return status to SUCCESS
1101: x_return_status := FND_API.G_RET_STS_SUCCESS;
1102: l_org_id := l_tar_supp_trade_profile_rec.org_id; -- R12 Enhancements
1103:

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

1102: l_org_id := l_tar_supp_trade_profile_rec.org_id; -- R12 Enhancements
1103:
1104: -- Debug Message
1105: IF g_debug THEN
1106: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
1107: END IF;
1108: OPEN c_supp_trade;
1109: FETCH c_supp_trade INTO l_ref_supp_trade_profile_rec;
1110: IF ( c_supp_trade%NOTFOUND) THEN

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

1116: END IF;
1117: CLOSE c_supp_trade;
1118: -- Debug Message
1119: IF g_debug THEN
1120: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
1121: END IF;
1122:
1123: IF (l_tar_supp_trade_profile_rec.object_version_number is NULL or
1124: l_tar_supp_trade_profile_rec.object_version_number = FND_API.G_MISS_NUM ) THEN

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

1147: IF l_supp_id <> p_supp_trade_profile_rec.supplier_id or
1148: l_supp_site_id <> p_supp_trade_profile_rec.supplier_site_id
1149: THEN
1150: IF g_debug THEN
1151: OZF_UTILITY_PVT.debug_message('Calling create in update method');
1152: END IF;
1153: Create_Supp_Trade_Profile (
1154: p_api_version_number => 1.0,
1155: p_init_msg_list => FND_API.G_FALSE,

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

1173: p_supp_trade_profile_rec => p_supp_trade_profile_rec,
1174: x_complete_rec => l_supp_trade_profile_rec
1175: );
1176: IF g_debug THEN
1177: OZF_UTILITY_PVT.debug_message('In the update');
1178: END IF;
1179: -- populate defaults
1180: populate_supp_defaults (p_supp_trade_profile_rec => l_supp_trade_profile_rec,
1181: x_supp_trade_profile_rec => l_x_supp_trade_profile_rec,

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

1330: COMMIT WORK;
1331: END IF;
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,

Line 1342: WHEN OZF_Utility_PVT.resource_locked THEN

1338: (p_count => x_msg_count,
1339: p_data => x_msg_data
1340: );
1341: EXCEPTION
1342: WHEN OZF_Utility_PVT.resource_locked THEN
1343: x_return_status := FND_API.g_ret_sts_error;
1344: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1345: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
1346: FND_MSG_PUB.add;

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

1412: FND_MSG_PUB.initialize;
1413: END IF;
1414: -- Debug Message
1415: IF g_debug THEN
1416: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1417: END IF;
1418: -- Initialize API return status to SUCCESS
1419: x_return_status := FND_API.G_RET_STS_SUCCESS;
1420: -- Api body

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

1420: -- Api body
1421: --
1422: -- Debug Message
1423: IF g_debug THEN
1424: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1425: END IF;
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);

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

1433: COMMIT WORK;
1434: END IF;
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,

Line 1446: WHEN OZF_Utility_PVT.resource_locked THEN

1442: p_data => x_msg_data
1443: );
1444:
1445: EXCEPTION
1446: WHEN OZF_Utility_PVT.resource_locked THEN
1447: x_return_status := FND_API.g_ret_sts_error;
1448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1449: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
1450: FND_MSG_PUB.add;

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

1506: FOR UPDATE NOWAIT;
1507: BEGIN
1508: -- Debug Message
1509: IF g_debug THEN
1510: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1511: END IF;
1512:
1513: -- Initialize message list if p_init_msg_list is set to TRUE.
1514: IF FND_API.to_Boolean( p_init_msg_list )

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

1527: -- Initialize API return status to SUCCESS
1528: x_return_status := FND_API.G_RET_STS_SUCCESS;
1529: ------------------------ lock -------------------------
1530: IF g_debug THEN
1531: OZF_Utility_PVT.debug_message(l_full_name||': start');
1532: END IF;
1533: OPEN c_Supp_Trade_Profile;
1534: FETCH c_Supp_Trade_Profile INTO l_SUPP_TRADE_PROFILE_ID;
1535: IF (c_Supp_Trade_Profile%NOTFOUND) THEN

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

1546: p_encoded => FND_API.g_false,
1547: p_count => x_msg_count,
1548: p_data => x_msg_data);
1549: IF g_debug THEN
1550: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1551: END IF;
1552: EXCEPTION
1553: WHEN OZF_Utility_PVT.resource_locked THEN
1554: x_return_status := FND_API.g_ret_sts_error;

Line 1553: WHEN OZF_Utility_PVT.resource_locked THEN

1549: IF g_debug THEN
1550: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1551: END IF;
1552: EXCEPTION
1553: WHEN OZF_Utility_PVT.resource_locked THEN
1554: x_return_status := FND_API.g_ret_sts_error;
1555: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1556: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES LOCKED');
1557: FND_MSG_PUB.add;

Line 1847: WHEN OZF_Utility_PVT.resource_locked THEN

1843: (p_count => x_msg_count,
1844: p_data => x_msg_data
1845: );
1846: EXCEPTION
1847: WHEN OZF_Utility_PVT.resource_locked THEN
1848: x_return_status := FND_API.g_ret_sts_error;
1849: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1850: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
1851: FND_MSG_PUB.add;

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

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