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

Line 33: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');

29: BEGIN
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
32: IF p_preset_tier_rec.offer_market_option_id IS NULL OR p_preset_tier_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN
33: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');
34: x_return_status := FND_API.g_ret_sts_error;
35: return;
36: END IF;
37: IF p_preset_tier_rec.pbh_offer_discount_id IS NULL OR p_preset_tier_rec.pbh_offer_discount_id = FND_API.G_MISS_NUM THEN

Line 38: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','pbh_offer_discount_id');

34: x_return_status := FND_API.g_ret_sts_error;
35: return;
36: END IF;
37: IF p_preset_tier_rec.pbh_offer_discount_id IS NULL OR p_preset_tier_rec.pbh_offer_discount_id = FND_API.G_MISS_NUM THEN
38: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','pbh_offer_discount_id');
39: x_return_status := FND_API.g_ret_sts_error;
40: return;
41: END IF;
42: IF p_preset_tier_rec.dis_offer_discount_id IS NULL OR p_preset_tier_rec.dis_offer_discount_id = FND_API.G_MISS_NUM THEN

Line 43: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','dis_offer_discount_id');

39: x_return_status := FND_API.g_ret_sts_error;
40: return;
41: END IF;
42: IF p_preset_tier_rec.dis_offer_discount_id IS NULL OR p_preset_tier_rec.dis_offer_discount_id = FND_API.G_MISS_NUM THEN
43: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','dis_offer_discount_id');
44: x_return_status := FND_API.g_ret_sts_error;
45: return;
46: END IF;
47: ELSE

Line 49: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','market_preset_tier_id');

45: return;
46: END IF;
47: ELSE
48: IF p_preset_tier_rec.market_preset_tier_id = FND_API.G_MISS_NUM THEN
49: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','market_preset_tier_id');
50: x_return_status := FND_API.g_ret_sts_error;
51: return;
52: END IF;
53: IF p_preset_tier_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN

Line 54: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');

50: x_return_status := FND_API.g_ret_sts_error;
51: return;
52: END IF;
53: IF p_preset_tier_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN
54: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');
55: x_return_status := FND_API.g_ret_sts_error;
56: return;
57: END IF;
58: IF p_preset_tier_rec.pbh_offer_discount_id = FND_API.G_MISS_NUM THEN

Line 59: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','pbh_offer_discount_id');

55: x_return_status := FND_API.g_ret_sts_error;
56: return;
57: END IF;
58: IF p_preset_tier_rec.pbh_offer_discount_id = FND_API.G_MISS_NUM THEN
59: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','pbh_offer_discount_id');
60: x_return_status := FND_API.g_ret_sts_error;
61: return;
62: END IF;
63: IF p_preset_tier_rec.dis_offer_discount_id = FND_API.G_MISS_NUM THEN

Line 64: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','dis_offer_discount_id');

60: x_return_status := FND_API.g_ret_sts_error;
61: return;
62: END IF;
63: IF p_preset_tier_rec.dis_offer_discount_id = FND_API.G_MISS_NUM THEN
64: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','dis_offer_discount_id');
65: x_return_status := FND_API.g_ret_sts_error;
66: return;
67: END IF;
68: IF p_preset_tier_rec.object_version_number = FND_API.G_MISS_NUM THEN

Line 69: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','object_version_number');

65: x_return_status := FND_API.g_ret_sts_error;
66: return;
67: END IF;
68: IF p_preset_tier_rec.object_version_number = FND_API.G_MISS_NUM THEN
69: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','object_version_number');
70: x_return_status := FND_API.g_ret_sts_error;
71: return;
72: END IF;
73: END IF;

Line 88: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers','market_preset_tier_id = '||p_preset_tier_rec.market_preset_tier_id) = FND_API.g_false THEN

84: BEGIN
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
87: IF p_preset_tier_rec.market_preset_tier_id IS NOT NULL AND p_preset_tier_rec.market_preset_tier_id <> FND_API.G_MISS_NUM THEN
88: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers','market_preset_tier_id = '||p_preset_tier_rec.market_preset_tier_id) = FND_API.g_false THEN
89: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_ID_DUP');
90: x_return_status := FND_API.g_ret_sts_error;
91: return;
92: END IF;

Line 89: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_ID_DUP');

85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
87: IF p_preset_tier_rec.market_preset_tier_id IS NOT NULL AND p_preset_tier_rec.market_preset_tier_id <> FND_API.G_MISS_NUM THEN
88: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers','market_preset_tier_id = '||p_preset_tier_rec.market_preset_tier_id) = FND_API.g_false THEN
89: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_ID_DUP');
90: x_return_status := FND_API.g_ret_sts_error;
91: return;
92: END IF;
93: END IF;

Line 114: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers'

110: (
111: p_preset_tier_rec.market_preset_tier_id IS NOT NULL AND p_preset_tier_rec.market_preset_tier_id <> FND_API.G_MISS_NUM
112: )
113: THEN
114: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers'
115: ,'offer_market_option_id = '||p_preset_tier_rec.offer_market_option_id
116: ||' AND pbh_offer_discount_id = '|| p_preset_tier_rec.pbh_offer_discount_id
117: || ' AND dis_offer_discount_id = '||p_preset_tier_rec.dis_offer_discount_id
118: || ' AND market_preset_tier_id <> ' ||p_preset_tier_rec.market_preset_tier_id

Line 122: OZF_Utility_PVT.Error_Message('OZF_MO_PRESTE_TIER_DUP');

118: || ' AND market_preset_tier_id <> ' ||p_preset_tier_rec.market_preset_tier_id
119: )
120: = FND_API.G_FALSE
121: THEN
122: OZF_Utility_PVT.Error_Message('OZF_MO_PRESTE_TIER_DUP');
123: x_return_status := FND_API.g_ret_sts_error;
124: return;
125: END IF;
126: END IF;

Line 141: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers'

137: (
138: p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM
139: )
140: THEN
141: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers'
142: ,'offer_market_option_id = '||p_preset_tier_rec.offer_market_option_id ||' AND pbh_offer_discount_id = '|| p_preset_tier_rec.pbh_offer_discount_id || ' AND dis_offer_discount_id = '||p_preset_tier_rec.dis_offer_discount_id ) = FND_API.G_FALSE
143: THEN
144: OZF_Utility_PVT.Error_Message('OZF_MO_PRESTE_TIER_DUP');
145: x_return_status := FND_API.g_ret_sts_error;

Line 144: OZF_Utility_PVT.Error_Message('OZF_MO_PRESTE_TIER_DUP');

140: THEN
141: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers'
142: ,'offer_market_option_id = '||p_preset_tier_rec.offer_market_option_id ||' AND pbh_offer_discount_id = '|| p_preset_tier_rec.pbh_offer_discount_id || ' AND dis_offer_discount_id = '||p_preset_tier_rec.dis_offer_discount_id ) = FND_API.G_FALSE
143: THEN
144: OZF_Utility_PVT.Error_Message('OZF_MO_PRESTE_TIER_DUP');
145: x_return_status := FND_API.g_ret_sts_error;
146: return;
147: END IF;
148: END IF;

Line 173: IF ozf_utility_pvt.check_fk_exists('ozf_offr_market_options','offer_market_option_id',to_char(p_preset_tier_rec.offer_market_option_id)) = FND_API.G_FALSE THEN

169: l_dummy NUMBER;
170: BEGIN
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172: IF p_preset_tier_rec.offer_market_option_id IS NOT NULL AND p_preset_tier_rec.offer_market_option_id <> FND_API.G_MISS_NUM THEN
173: IF ozf_utility_pvt.check_fk_exists('ozf_offr_market_options','offer_market_option_id',to_char(p_preset_tier_rec.offer_market_option_id)) = FND_API.G_FALSE THEN
174: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_MO_ID');
175: x_return_status := FND_API.g_ret_sts_error;
176: return;
177: END IF;

Line 174: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_MO_ID');

170: BEGIN
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172: IF p_preset_tier_rec.offer_market_option_id IS NOT NULL AND p_preset_tier_rec.offer_market_option_id <> FND_API.G_MISS_NUM THEN
173: IF ozf_utility_pvt.check_fk_exists('ozf_offr_market_options','offer_market_option_id',to_char(p_preset_tier_rec.offer_market_option_id)) = FND_API.G_FALSE THEN
174: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_MO_ID');
175: x_return_status := FND_API.g_ret_sts_error;
176: return;
177: END IF;
178: END IF;

Line 181: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES','offer_discount_line_id',to_char(p_preset_tier_rec.pbh_offer_discount_id)) =FND_API.G_FALSE THEN

177: END IF;
178: END IF;
179:
180: IF p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM THEN
181: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES','offer_discount_line_id',to_char(p_preset_tier_rec.pbh_offer_discount_id)) =FND_API.G_FALSE THEN
182: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_PBH_ID');
183: x_return_status := FND_API.g_ret_sts_error;
184: return;
185: END IF;

Line 182: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_PBH_ID');

178: END IF;
179:
180: IF p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM THEN
181: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES','offer_discount_line_id',to_char(p_preset_tier_rec.pbh_offer_discount_id)) =FND_API.G_FALSE THEN
182: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_PBH_ID');
183: x_return_status := FND_API.g_ret_sts_error;
184: return;
185: END IF;
186: IF p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM THEN

Line 187: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'OFFER_DISCOUNT_LINE_ID', to_char(p_preset_tier_rec.dis_offer_discount_id)) = FND_API.G_FALSE THEN

183: x_return_status := FND_API.g_ret_sts_error;
184: return;
185: END IF;
186: IF p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM THEN
187: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'OFFER_DISCOUNT_LINE_ID', to_char(p_preset_tier_rec.dis_offer_discount_id)) = FND_API.G_FALSE THEN
188: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIERS_INV_DIS_ID');
189: x_return_status := FND_API.g_ret_sts_error;
190: return;
191: END IF;

Line 188: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIERS_INV_DIS_ID');

184: return;
185: END IF;
186: IF p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM THEN
187: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'OFFER_DISCOUNT_LINE_ID', to_char(p_preset_tier_rec.dis_offer_discount_id)) = FND_API.G_FALSE THEN
188: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIERS_INV_DIS_ID');
189: x_return_status := FND_API.g_ret_sts_error;
190: return;
191: END IF;
192: END IF;

Line 234: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_DIS_PBH');

230: OPEN c_valid(p_preset_tier_rec.dis_offer_discount_id,p_preset_tier_rec.pbh_offer_discount_id);
231: FETCH c_valid INTO l_dummy;
232: IF (c_valid%NOTFOUND) THEN
233: CLOSE c_valid;
234: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_DIS_PBH');
235: x_return_status := FND_API.g_ret_sts_error;
236: return;
237: END IF;
238: CLOSE c_valid;

Line 327: ozf_utility_pvt.debug_message('Private API: '|| l_api_name||' Start');

323: l_api_name CONSTANT VARCHAR2(30) := 'Validate_mo_preset_tiers';
324: BEGIN
325: x_return_status := FND_API.G_RET_STS_SUCCESS;
326:
327: ozf_utility_pvt.debug_message('Private API: '|| l_api_name||' Start');
328:
329: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
330: check_preset_tier_items
331: (

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

338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;
341: END IF;
342: ozf_utility_pvt.debug_message('Private API: '||l_api_name ||' End');
343:
344: END Validate_mo_preset_tiers;
345:
346: PROCEDURE Create_mo_preset_tiers(

Line 392: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');

388: IF FND_API.to_boolean(p_init_msg_list) THEN
389: FND_MSG_PUB.initialize;
390: END IF;
391:
392: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:
395: IF FND_GLOBAL.USER_ID IS NULL
396: THEN

Line 397: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:
395: IF FND_GLOBAL.USER_ID IS NULL
396: THEN
397: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;
400:
401: l_preset_tier_rec := p_preset_tier_rec;

Line 460: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');

456: END IF;
457:
458: x_market_preset_tier_id := l_market_preset_tier_id;
459:
460: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
461:
462: IF FND_API.to_boolean(p_commit) THEN
463: COMMIT WORK;
464: END IF;

Line 541: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');

537: IF FND_API.to_boolean(p_init_msg_list) THEN
538: FND_MSG_PUB.initialize;
539: END IF;
540:
541: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
542: x_return_status := FND_API.G_RET_STS_SUCCESS;
543:
544: open c_get_preset_tiers(l_tar_preset_rec.market_preset_tier_id, l_tar_preset_rec.object_version_number);
545: FETCH c_get_preset_tiers INTO l_ref_preset_tiers;

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

543:
544: open c_get_preset_tiers(l_tar_preset_rec.market_preset_tier_id, l_tar_preset_rec.object_version_number);
545: FETCH c_get_preset_tiers INTO l_ref_preset_tiers;
546: IF (c_get_preset_tiers%NOTFOUND) THEN
547: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'
548: , p_token_name => 'INFO'
549: , p_token_value => 'OZF_MO_PRESET_TIERS') ;
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;

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

549: , p_token_value => 'OZF_MO_PRESET_TIERS') ;
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552: IF l_tar_preset_rec.object_version_number = FND_API.G_MISS_NUM OR l_tar_preset_rec.object_version_number IS NULL THEN
553: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'
554: , p_token_name => 'COLUMN'
555: , p_token_value => 'Last_Update_Date') ;
556: RAISE FND_API.G_EXC_ERROR;
557: END IF;

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

555: , p_token_value => 'Last_Update_Date') ;
556: RAISE FND_API.G_EXC_ERROR;
557: END IF;
558: IF l_tar_preset_rec.object_version_number <> l_ref_preset_tiers.object_version_number THEN
559: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED'
560: , p_token_name => 'INFO'
561: , p_token_value => 'Ozf_Market_Options') ;
562: RAISE FND_API.G_EXC_ERROR;
563: END IF;

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

600: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:
604: ozf_utility_pvt.debug_message('Private API: '|| l_api_name ||' End');
605:
606: IF FND_API.to_boolean(p_commit) THEN
607: COMMIT WORK;
608: END IF;

Line 675: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');

671: FND_MSG_PUB.initialize;
672: END IF;
673:
674: x_return_status := FND_API.G_RET_STS_SUCCESS;
675: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
676:
677: OZF_MO_PRESET_TIERS_PKG.Delete_row(p_market_preset_tier_id => p_market_preset_tier_id, p_object_version_number => p_object_version_number);
678:
679: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

681: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
683: END IF;
684:
685: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' End');
686: IF FND_API.to_boolean(p_commit) THEN
687: COMMIT WORK;
688: END IF;
689: