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

Line 29: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','off_discount_product_id');

25: BEGIN
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
28: IF p_qp_product_rec.off_discount_product_id IS NULL OR p_qp_product_rec.off_discount_product_id = FND_API.G_MISS_NUM THEN
29: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','off_discount_product_id');
30: x_return_status := FND_API.g_ret_sts_error;
31: return;
32: END IF;
33: IF p_qp_product_rec.pricing_attribute_id IS NULL OR p_qp_product_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

Line 34: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRICING_ATTRIBUTE_ID');

30: x_return_status := FND_API.g_ret_sts_error;
31: return;
32: END IF;
33: IF p_qp_product_rec.pricing_attribute_id IS NULL OR p_qp_product_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
34: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRICING_ATTRIBUTE_ID');
35: x_return_status := FND_API.g_ret_sts_error;
36: return;
37: END IF;
38: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN

Line 40: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','QP_PRODUCT_ID');

36: return;
37: END IF;
38: ELSIF p_validation_mode = JTF_PLSQL_API.g_update THEN
39: IF p_qp_product_rec.qp_product_id = FND_API.G_MISS_NUM THEN
40: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','QP_PRODUCT_ID');
41: x_return_status := FND_API.g_ret_sts_error;
42: return;
43: END IF;
44: IF p_qp_product_rec.off_discount_product_id = FND_API.G_MISS_NUM THEN

Line 45: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OFF_DISCOUNT_PRODUCT_ID');

41: x_return_status := FND_API.g_ret_sts_error;
42: return;
43: END IF;
44: IF p_qp_product_rec.off_discount_product_id = FND_API.G_MISS_NUM THEN
45: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OFF_DISCOUNT_PRODUCT_ID');
46: x_return_status := FND_API.g_ret_sts_error;
47: return;
48: END IF;
49: IF p_qp_product_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

Line 50: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRICING_ATTRIBUTE_ID');

46: x_return_status := FND_API.g_ret_sts_error;
47: return;
48: END IF;
49: IF p_qp_product_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
50: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','PRICING_ATTRIBUTE_ID');
51: x_return_status := FND_API.g_ret_sts_error;
52: return;
53: END IF;
54: IF p_qp_product_rec.object_version_number = FND_API.G_MISS_NUM THEN

Line 55: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OBJECT_VERSION_NUMBER');

51: x_return_status := FND_API.g_ret_sts_error;
52: return;
53: END IF;
54: IF p_qp_product_rec.object_version_number = FND_API.G_MISS_NUM THEN
55: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','OBJECT_VERSION_NUMBER');
56: x_return_status := FND_API.g_ret_sts_error;
57: return;
58: END IF;
59: END IF;

Line 73: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','qp_product_id = ''' || p_qp_product_rec.qp_product_id ||'''') = FND_API.g_false THEN

69: BEGIN
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
72: IF p_qp_product_rec.qp_product_id IS NOT NULL AND p_qp_product_rec.qp_product_id <> FND_API.G_MISS_NUM THEN
73: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','qp_product_id = ''' || p_qp_product_rec.qp_product_id ||'''') = FND_API.g_false THEN
74: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_QP_PROD_ID_DUP');
75: x_return_status := FND_API.g_ret_sts_error;
76: return;
77: END IF;

Line 74: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_QP_PROD_ID_DUP');

70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
72: IF p_qp_product_rec.qp_product_id IS NOT NULL AND p_qp_product_rec.qp_product_id <> FND_API.G_MISS_NUM THEN
73: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','qp_product_id = ''' || p_qp_product_rec.qp_product_id ||'''') = FND_API.g_false THEN
74: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_QP_PROD_ID_DUP');
75: x_return_status := FND_API.g_ret_sts_error;
76: return;
77: END IF;
78: END IF;

Line 89: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','off_discount_product_id = ' || p_qp_product_rec.off_discount_product_id || ' AND pricing_attribute_id = ' ||p_qp_product_rec.pricing_attribute_id) = FND_API.g_false THEN

85: (
86: p_qp_product_rec.pricing_attribute_id IS NOT NULL AND p_qp_product_rec.pricing_attribute_id <> FND_API.G_MISS_NUM
87: )
88: THEN
89: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','off_discount_product_id = ' || p_qp_product_rec.off_discount_product_id || ' AND pricing_attribute_id = ' ||p_qp_product_rec.pricing_attribute_id) = FND_API.g_false THEN
90: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_QP_PROD_DUP');
91: x_return_status := FND_API.g_ret_sts_error;
92: return;
93: END IF;

Line 90: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_QP_PROD_DUP');

86: p_qp_product_rec.pricing_attribute_id IS NOT NULL AND p_qp_product_rec.pricing_attribute_id <> FND_API.G_MISS_NUM
87: )
88: THEN
89: IF OZF_Utility_PVT.check_uniqueness('ozf_qp_products','off_discount_product_id = ' || p_qp_product_rec.off_discount_product_id || ' AND pricing_attribute_id = ' ||p_qp_product_rec.pricing_attribute_id) = FND_API.g_false THEN
90: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_QP_PROD_DUP');
91: x_return_status := FND_API.g_ret_sts_error;
92: return;
93: END IF;
94: END IF;

Line 110: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_products','off_discount_product_id',to_char(p_qp_product_rec.off_discount_product_id)) = FND_API.g_false THEN

106: IS
107: BEGIN
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109: IF p_qp_product_rec.off_discount_product_id IS NOT NULL AND p_qp_product_rec.off_discount_product_id <> FND_API.G_MISS_NUM THEN
110: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_products','off_discount_product_id',to_char(p_qp_product_rec.off_discount_product_id)) = FND_API.g_false THEN
111: OZF_Utility_PVT.Error_Message('OZF_INVALID_OZF_PROD_ID' );
112: x_return_status := FND_API.g_ret_sts_error;
113: return;
114: END IF;

Line 111: OZF_Utility_PVT.Error_Message('OZF_INVALID_OZF_PROD_ID' );

107: BEGIN
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109: IF p_qp_product_rec.off_discount_product_id IS NOT NULL AND p_qp_product_rec.off_discount_product_id <> FND_API.G_MISS_NUM THEN
110: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_products','off_discount_product_id',to_char(p_qp_product_rec.off_discount_product_id)) = FND_API.g_false THEN
111: OZF_Utility_PVT.Error_Message('OZF_INVALID_OZF_PROD_ID' );
112: x_return_status := FND_API.g_ret_sts_error;
113: return;
114: END IF;
115: END IF;

Line 118: IF ozf_utility_pvt.check_fk_exists('qp_pricing_attributes','pricing_attribute_id',to_char(p_qp_product_rec.pricing_attribute_id)) = FND_API.g_false THEN

114: END IF;
115: END IF;
116:
117: IF p_qp_product_rec.pricing_attribute_id IS NOT NULL AND p_qp_product_rec.pricing_attribute_id <> FND_API.G_MISS_NUM THEN
118: IF ozf_utility_pvt.check_fk_exists('qp_pricing_attributes','pricing_attribute_id',to_char(p_qp_product_rec.pricing_attribute_id)) = FND_API.g_false THEN
119: OZF_Utility_PVT.Error_Message('OZF_INVALID_OZF_PROD_ID' );
120: x_return_status := FND_API.g_ret_sts_error;
121: return;
122: END IF;

Line 119: OZF_Utility_PVT.Error_Message('OZF_INVALID_OZF_PROD_ID' );

115: END IF;
116:
117: IF p_qp_product_rec.pricing_attribute_id IS NOT NULL AND p_qp_product_rec.pricing_attribute_id <> FND_API.G_MISS_NUM THEN
118: IF ozf_utility_pvt.check_fk_exists('qp_pricing_attributes','pricing_attribute_id',to_char(p_qp_product_rec.pricing_attribute_id)) = FND_API.g_false THEN
119: OZF_Utility_PVT.Error_Message('OZF_INVALID_OZF_PROD_ID' );
120: x_return_status := FND_API.g_ret_sts_error;
121: return;
122: END IF;
123: END IF;

Line 152: OZF_Utility_PVT.Error_Message('OZF_OFFR_INVALID_PROD_PAIR');

148: FETCH c_list_header2 INTO l_list_header2;
149: CLOSE c_list_header2;
150:
151: IF l_list_header2 <> l_list_header THEN
152: OZF_Utility_PVT.Error_Message('OZF_OFFR_INVALID_PROD_PAIR');
153: x_return_status := FND_API.g_ret_sts_error;
154: END IF;
155: END check_qp_prod_attr;
156:

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

245: END IF;
246: -- Initialize message list if p_init_msg_list is set to TRUE.
247:
248: -- Debug Message
249: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
250:
251: -- Initialize API return status to SUCCESS
252: x_return_status := FND_API.G_RET_STS_SUCCESS;
253:

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

263: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266: END IF;
267: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
268:
269: EXCEPTION
270:
271: WHEN OZF_Utility_PVT.resource_locked THEN

Line 271: WHEN OZF_Utility_PVT.resource_locked THEN

267: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
268:
269: EXCEPTION
270:
271: WHEN OZF_Utility_PVT.resource_locked THEN
272: x_return_status := FND_API.g_ret_sts_error;
273: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
274:
275: WHEN FND_API.G_EXC_ERROR THEN

Line 273: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

269: EXCEPTION
270:
271: WHEN OZF_Utility_PVT.resource_locked THEN
272: x_return_status := FND_API.g_ret_sts_error;
273: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
274:
275: WHEN FND_API.G_EXC_ERROR THEN
276: -- ROLLBACK TO validate_market_options_pvt;
277: x_return_status := FND_API.G_RET_STS_ERROR;

Line 387: ozf_utility_pvt.debug_message('Private API: '|| l_api_name|| 'start');

383: IF FND_API.to_boolean(p_init_msg_list) THEN
384: FND_MSG_PUB.initialize;
385: END IF;
386: -- debug message start
387: ozf_utility_pvt.debug_message('Private API: '|| l_api_name|| 'start');
388: -- set return status
389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390:
391: IF FND_GLOBAL.USER_ID IS NULL THEN

Line 392: OZF_Utility_PVT.Error_Message('USER_PROFILE_MISSING');

388: -- set return status
389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390:
391: IF FND_GLOBAL.USER_ID IS NULL THEN
392: OZF_Utility_PVT.Error_Message('USER_PROFILE_MISSING');
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: END IF;
395:
396: l_qp_product_rec := p_qp_product_rec;

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

449: IF FND_API.to_boolean(p_commit) THEN
450: COMMIT WORK;
451: END IF;
452:
453: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
454:
455: FND_MSG_PUB.COUNT_AND_GET
456: (
457: p_count => x_msg_count

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

573: THEN
574: FND_MSG_PUB.initialize;
575: END IF;
576: -- Debug Message
577: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
578:
579: -- Initialize API return status to SUCCESS
580: x_return_status := FND_API.G_RET_STS_SUCCESS;
581:

Line 585: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'

581:
582: OPEN c_get_qp_prod( l_tar_qp_prod_rec.qp_product_id,l_tar_qp_prod_rec.object_version_number);
583: FETCH c_get_qp_prod INTO l_ref_qp_prod_rec ;
584: If ( c_get_qp_prod%NOTFOUND) THEN
585: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'
586: , p_token_name => 'INFO'
587: , p_token_value => 'OZF_MARKET_OPTIONS') ;
588: RAISE FND_API.G_EXC_ERROR;
589: END IF;

Line 594: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'

590: CLOSE c_get_qp_prod;
591:
592: If (l_tar_qp_prod_rec.object_version_number is NULL or
593: l_tar_qp_prod_rec.object_version_number = FND_API.G_MISS_NUM ) Then
594: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'
595: , p_token_name => 'COLUMN'
596: , p_token_value => 'Last_Update_Date') ;
597: RAISE FND_API.G_EXC_ERROR;
598: End if;

Line 601: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED'

597: RAISE FND_API.G_EXC_ERROR;
598: End if;
599: -- Check Whether record has been changed by someone else
600: If (l_tar_qp_prod_rec.object_version_number <> l_ref_qp_prod_rec.object_version_number) Then
601: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED'
602: , p_token_name => 'INFO'
603: , p_token_value => 'Ozf_Market_Options') ;
604: RAISE FND_API.G_EXC_ERROR;
605: End if;

Line 640: ozf_utility_pvt.debug_message('Private API : '||l_api_name || ' End');

636: -- commit
637: IF FND_API.to_boolean(p_commit) THEN
638: COMMIT WORK;
639: END IF;
640: ozf_utility_pvt.debug_message('Private API : '||l_api_name || ' End');
641: FND_MSG_PUB.count_and_get
642: (
643: p_count => x_msg_count
644: , p_data => x_msg_data

Line 648: WHEN OZF_Utility_PVT.resource_locked THEN

644: , p_data => x_msg_data
645: );
646: -- exception
647: EXCEPTION
648: WHEN OZF_Utility_PVT.resource_locked THEN
649: x_return_status := FND_API.g_ret_sts_error;
650: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
651:
652: WHEN FND_API.G_EXC_ERROR THEN

Line 650: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');

646: -- exception
647: EXCEPTION
648: WHEN OZF_Utility_PVT.resource_locked THEN
649: x_return_status := FND_API.g_ret_sts_error;
650: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
651:
652: WHEN FND_API.G_EXC_ERROR THEN
653: ROLLBACK TO Update_ozf_qp_product_pvt;
654: x_return_status := FND_API.G_RET_STS_ERROR;

Line 764: WHEN OZF_UTILITY_PVT.resource_locked THEN

760: , p_data => x_msg_data
761: );
762: -- exception
763: EXCEPTION
764: WHEN OZF_UTILITY_PVT.resource_locked THEN
765: OZF_Utility_PVT.Error_Message('OZF_API_RESOURCE_LOCKED');
766: x_return_status := FND_API.g_ret_sts_error;
767: WHEN FND_API.G_EXC_ERROR THEN
768: rollback to Delete_ozf_qp_product_pvt;

Line 765: OZF_Utility_PVT.Error_Message('OZF_API_RESOURCE_LOCKED');

761: );
762: -- exception
763: EXCEPTION
764: WHEN OZF_UTILITY_PVT.resource_locked THEN
765: OZF_Utility_PVT.Error_Message('OZF_API_RESOURCE_LOCKED');
766: x_return_status := FND_API.g_ret_sts_error;
767: WHEN FND_API.G_EXC_ERROR THEN
768: rollback to Delete_ozf_qp_product_pvt;
769: x_return_status := FND_API.G_RET_STS_ERROR;