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_TRADE_PROFILE_PVT dependencies on OZF_UTILITY_PVT

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

466:
467: -- Standard Start of API savepoint
468: SAVEPOINT CREATE_Trade_Profile_PVT;
469: IF g_debug THEN
470: OZF_UTILITY_PVT.debug_message('Private API: Create trade profile');
471: END IF;
472: -- Standard call to check for call compatibility.
473: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
474: p_api_version_number,

Line 525: OZF_UTILITY_PVT.debug_message('Party Id is null');

521: IF p_trade_profile_rec.party_id = FND_API.g_miss_num OR
522: p_trade_profile_rec.party_id IS NULL
523: THEN
524: IF g_debug THEN
525: OZF_UTILITY_PVT.debug_message('Party Id is null');
526: END IF;
527: IF l_trade_profile_rec.cust_account_id = FND_API.g_miss_num OR
528: l_trade_profile_rec.cust_account_id IS NULL
529: THEN

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

664: END IF;
665:
666: -- Debug Message
667: IF g_debug THEN
668: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
669: END IF;
670:
671: -- Standard call to get message count and if count is 1, get message info.
672: FND_MSG_PUB.Count_And_Get

Line 678: WHEN OZF_Utility_PVT.resource_locked THEN

674: p_data => x_msg_data
675: );
676:
677: EXCEPTION
678: WHEN OZF_Utility_PVT.resource_locked THEN
679: x_return_status := FND_API.g_ret_sts_error;
680: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
681: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
682: FND_MSG_PUB.add;

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

786: THEN
787: FND_MSG_PUB.initialize;
788: END IF;
789: -- Debug Message
790: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
791: -- Initialize API return status to SUCCESS
792: x_return_status := FND_API.G_RET_STS_SUCCESS;
793: l_org_id := l_tar_trade_profile_rec.org_id; -- R12 Enhancements
794:

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

793: l_org_id := l_tar_trade_profile_rec.org_id; -- R12 Enhancements
794:
795: -- Debug Message
796: IF g_debug THEN
797: OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
798: END IF;
799: OPEN c_trade;
800: FETCH c_trade INTO l_ref_trade_profile_rec;
801: IF ( c_trade%NOTFOUND) THEN

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

807: END IF;
808: CLOSE c_trade;
809: -- Debug Message
810: IF g_debug THEN
811: OZF_UTILITY_PVT.debug_message('Private API: - Close Cursor');
812: END IF;
813:
814: IF (l_tar_trade_profile_rec.object_version_number is NULL or
815: l_tar_trade_profile_rec.object_version_number = FND_API.G_MISS_NUM ) THEN

Line 835: OZF_UTILITY_PVT.debug_message('before create in update!!');

831: END IF;
832:
833: -- if cust account id in db is not the same as the account from user create a trade profile
834: IF g_debug THEN
835: OZF_UTILITY_PVT.debug_message('before create in update!!');
836: END IF;
837: IF l_site_use_id <> p_trade_profile_rec.site_use_id THEN
838: IF g_debug THEN
839: OZF_UTILITY_PVT.debug_message('into create');

Line 839: OZF_UTILITY_PVT.debug_message('into create');

835: OZF_UTILITY_PVT.debug_message('before create in update!!');
836: END IF;
837: IF l_site_use_id <> p_trade_profile_rec.site_use_id THEN
838: IF g_debug THEN
839: OZF_UTILITY_PVT.debug_message('into create');
840: END IF;
841: Create_Trade_Profile (
842: p_api_version_number => 1.0,
843: p_init_msg_list => FND_API.G_FALSE,

Line 865: OZF_UTILITY_PVT.debug_message('into update part');

861: p_trade_profile_rec => p_trade_profile_rec,
862: x_complete_rec => l_trade_profile_rec
863: );
864: IF g_debug THEN
865: OZF_UTILITY_PVT.debug_message('into update part');
866: END IF;
867: -- populate defaults
868: populate_defaults (p_trade_profile_rec => l_trade_profile_rec,
869: x_trade_profile_rec => l_x_trade_profile_rec,

Line 908: OZF_UTILITY_PVT.debug_message('cust_account_id'||l_trade_profile_rec.cust_account_id);

904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
905: END IF;
906: END IF;
907: IF g_debug THEN
908: OZF_UTILITY_PVT.debug_message('cust_account_id'||l_trade_profile_rec.cust_account_id);
909: END IF;
910:
911: -- Debug Message
912: OZF_cust_trd_prfls_PKG.Update_Row(

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

977: COMMIT WORK;
978: END IF;
979: -- Debug Message
980: IF g_debug THEN
981: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
982: END IF;
983: -- Standard call to get message count and if count is 1, get message info.
984: FND_MSG_PUB.Count_And_Get
985: (p_count => x_msg_count,

Line 989: WHEN OZF_Utility_PVT.resource_locked THEN

985: (p_count => x_msg_count,
986: p_data => x_msg_data
987: );
988: EXCEPTION
989: WHEN OZF_Utility_PVT.resource_locked THEN
990: x_return_status := FND_API.g_ret_sts_error;
991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
992: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
993: FND_MSG_PUB.add;

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

1059: FND_MSG_PUB.initialize;
1060: END IF;
1061: -- Debug Message
1062: IF g_debug THEN
1063: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1064: END IF;
1065: -- Initialize API return status to SUCCESS
1066: x_return_status := FND_API.G_RET_STS_SUCCESS;
1067: -- Api body

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

1067: -- Api body
1068: --
1069: -- Debug Message
1070: IF g_debug THEN
1071: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1072: END IF;
1073: -- Invoke table handler(OZF_cust_trd_prfls_PKG.Delete_Row)
1074: OZF_cust_trd_prfls_PKG.Delete_Row(
1075: p_TRADE_PROFILE_ID => p_TRADE_PROFILE_ID);

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

1080: COMMIT WORK;
1081: END IF;
1082: -- Debug Message
1083: IF g_debug THEN
1084: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1085: END IF;
1086: -- Standard call to get message count and if count is 1, get message info.
1087: FND_MSG_PUB.Count_And_Get
1088: (p_count => x_msg_count,

Line 1092: WHEN OZF_Utility_PVT.resource_locked THEN

1088: (p_count => x_msg_count,
1089: p_data => x_msg_data
1090: );
1091: EXCEPTION
1092: WHEN OZF_Utility_PVT.resource_locked THEN
1093: x_return_status := FND_API.g_ret_sts_error;
1094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1095: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES_LOCKED');
1096: FND_MSG_PUB.add;

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

1152: FOR UPDATE NOWAIT;
1153: BEGIN
1154: -- Debug Message
1155: IF g_debug THEN
1156: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1157: END IF;
1158:
1159: -- Initialize message list if p_init_msg_list is set to TRUE.
1160: IF FND_API.to_Boolean( p_init_msg_list )

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

1173: -- Initialize API return status to SUCCESS
1174: x_return_status := FND_API.G_RET_STS_SUCCESS;
1175: ------------------------ lock -------------------------
1176: IF g_debug THEN
1177: OZF_Utility_PVT.debug_message(l_full_name||': start');
1178: END IF;
1179: OPEN c_Trade_Profile;
1180: FETCH c_Trade_Profile INTO l_TRADE_PROFILE_ID;
1181: IF (c_Trade_Profile%NOTFOUND) THEN

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

1192: p_encoded => FND_API.g_false,
1193: p_count => x_msg_count,
1194: p_data => x_msg_data);
1195: IF g_debug THEN
1196: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1197: END IF;
1198: EXCEPTION
1199: WHEN OZF_Utility_PVT.resource_locked THEN
1200: x_return_status := FND_API.g_ret_sts_error;

Line 1199: WHEN OZF_Utility_PVT.resource_locked THEN

1195: IF g_debug THEN
1196: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1197: END IF;
1198: EXCEPTION
1199: WHEN OZF_Utility_PVT.resource_locked THEN
1200: x_return_status := FND_API.g_ret_sts_error;
1201: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1202: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCES LOCKED');
1203: FND_MSG_PUB.add;

Line 1296: OZF_UTILITY_PVT.debug_message('no cust or party 2'|| l_party_dummy ||l_valid_flag);

1292: FETCH c_party_id_exists INTO l_party_dummy;
1293: CLOSE c_party_id_exists;
1294: IF l_party_dummy <> 0 THEN
1295: IF g_debug THEN
1296: OZF_UTILITY_PVT.debug_message('no cust or party 2'|| l_party_dummy ||l_valid_flag);
1297: END IF;
1298: -- l_valid_flag := FND_API.g_false;
1299: END IF;
1300: END IF;

Line 1312: OZF_UTILITY_PVT.debug_message('no l_site_dummy '|| l_site_dummy );

1308:
1309: OPEN c_cust_site_use_exists(l_CUST_ACCOUNT_ID);
1310: FETCH c_cust_site_use_exists INTO l_site_dummy;
1311: CLOSE c_cust_site_use_exists;
1312: OZF_UTILITY_PVT.debug_message('no l_site_dummy '|| l_site_dummy );
1313: IF l_site_dummy <> 0 THEN
1314: l_valid_flag := FND_API.g_false;
1315: END IF;
1316: END IF;

Line 1365: OZF_UTILITY_PVT.debug_message('p_trade_profile_rec.payment_method : ' || p_trade_profile_rec.payment_method);

1361: END IF;
1362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1363: END IF;
1364: END IF;
1365: OZF_UTILITY_PVT.debug_message('p_trade_profile_rec.payment_method : ' || p_trade_profile_rec.payment_method);
1366: -- Fix for ER#9453443
1367: IF p_trade_profile_rec.payment_method IN ('CHECK','EFT','WIRE','AP_DEBIT','AP_DEFAULT') THEN
1368: IF p_trade_profile_rec.vendor_id = FND_API.g_miss_num OR
1369: p_trade_profile_rec.vendor_id IS NULL THEN

Line 1683: WHEN OZF_Utility_PVT.resource_locked THEN

1679: (p_count => x_msg_count,
1680: p_data => x_msg_data
1681: );
1682: EXCEPTION
1683: WHEN OZF_Utility_PVT.resource_locked THEN
1684: x_return_status := FND_API.g_ret_sts_error;
1685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1686: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED ');
1687: FND_MSG_PUB.add;

Line 1747: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1743: -- THEN
1744: -- x_return_status := FND_API.G_RET_STS_ERROR;
1745: -- Debug Message
1746: IF g_debug THEN
1747: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1748: END IF;
1749: -- Standard call to get message count and if count is 1, get message info.
1750: FND_MSG_PUB.Count_And_Get
1751: (p_count => x_msg_count,