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

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

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

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

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

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

Line 676: WHEN OZF_Utility_PVT.resource_locked THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 987: WHEN OZF_Utility_PVT.resource_locked THEN

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

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

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

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

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

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

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

Line 1090: WHEN OZF_Utility_PVT.resource_locked THEN

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

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

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

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

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

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

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

Line 1197: WHEN OZF_Utility_PVT.resource_locked THEN

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

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

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

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

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

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

1359: END IF;
1360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1361: END IF;
1362: END IF;
1363: OZF_UTILITY_PVT.debug_message('p_trade_profile_rec.payment_method : ' || p_trade_profile_rec.payment_method);
1364: IF p_trade_profile_rec.payment_method = 'CHECK' THEN
1365: IF p_trade_profile_rec.vendor_id = FND_API.g_miss_num OR
1366: p_trade_profile_rec.vendor_id IS NULL THEN
1367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 1679: WHEN OZF_Utility_PVT.resource_locked THEN

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

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

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