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

Line 42: OZF_UTILITY_PVT.Error_message('OZF_QP_DISC_INV_LL_DL');

38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39: OPEN c_valid_offer(p_qp_disc_rec.offer_discount_line_id, p_qp_disc_rec.list_line_id);
40: FETCH c_valid_offer INTO l_dummy;
41: IF c_valid_offer%NOTFOUND THEN
42: OZF_UTILITY_PVT.Error_message('OZF_QP_DISC_INV_LL_DL');
43: x_return_status := FND_API.G_RET_STS_ERROR;
44: CLOSE c_valid_offer;
45: RETURN;
46: ELSE

Line 62: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','list_line_id');

58: BEGIN
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
61: IF p_qp_disc_rec.list_line_id IS NULL OR p_qp_disc_rec.list_line_id = FND_API.G_MISS_NUM THEN
62: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','list_line_id');
63: x_return_status := FND_API.g_ret_sts_error;
64: return;
65: END IF;
66: IF p_qp_disc_rec.offer_discount_line_id IS NULL OR p_qp_disc_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN

Line 67: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_discount_line_id');

63: x_return_status := FND_API.g_ret_sts_error;
64: return;
65: END IF;
66: IF p_qp_disc_rec.offer_discount_line_id IS NULL OR p_qp_disc_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
67: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_discount_line_id');
68: x_return_status := FND_API.g_ret_sts_error;
69: return;
70: END IF;
71: ELSE

Line 73: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ozf_qp_discount_id');

69: return;
70: END IF;
71: ELSE
72: IF p_qp_disc_rec.ozf_qp_discount_id = FND_API.G_MISS_NUM THEN
73: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ozf_qp_discount_id');
74: x_return_status := FND_API.g_ret_sts_error;
75: return;
76: END IF;
77: IF p_qp_disc_rec.list_line_id = FND_API.G_MISS_NUM THEN

Line 78: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','list_line_id');

74: x_return_status := FND_API.g_ret_sts_error;
75: return;
76: END IF;
77: IF p_qp_disc_rec.list_line_id = FND_API.G_MISS_NUM THEN
78: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','list_line_id');
79: x_return_status := FND_API.g_ret_sts_error;
80: return;
81: END IF;
82: IF p_qp_disc_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN

Line 83: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_discount_line_id');

79: x_return_status := FND_API.g_ret_sts_error;
80: return;
81: END IF;
82: IF p_qp_disc_rec.offer_discount_line_id = FND_API.G_MISS_NUM THEN
83: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_discount_line_id');
84: x_return_status := FND_API.g_ret_sts_error;
85: return;
86: END IF;
87:

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

85: return;
86: END IF;
87:
88: IF p_qp_disc_rec.object_version_number = FND_API.G_MISS_NUM THEN
89: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','object_version_number');
90: x_return_status := FND_API.g_ret_sts_error;
91: return;
92: END IF;
93: END IF;

Line 107: IF OZF_UTILITY_PVT.check_uniqueness('ozf_qp_discounts', 'ozf_qp_discount_id = '||p_qp_disc_rec.ozf_qp_discount_id) = FND_API.G_FALSE THEN

103: BEGIN
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
106: IF p_qp_disc_rec.ozf_qp_discount_id IS NOT NULL AND p_qp_disc_rec.ozf_qp_discount_id <> FND_API.G_MISS_NUM THEN
107: IF OZF_UTILITY_PVT.check_uniqueness('ozf_qp_discounts', 'ozf_qp_discount_id = '||p_qp_disc_rec.ozf_qp_discount_id) = FND_API.G_FALSE THEN
108: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_PK_DUP');
109: x_return_status := FND_API.g_ret_sts_error;
110: return;
111: END IF;

Line 108: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_PK_DUP');

104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
106: IF p_qp_disc_rec.ozf_qp_discount_id IS NOT NULL AND p_qp_disc_rec.ozf_qp_discount_id <> FND_API.G_MISS_NUM THEN
107: IF OZF_UTILITY_PVT.check_uniqueness('ozf_qp_discounts', 'ozf_qp_discount_id = '||p_qp_disc_rec.ozf_qp_discount_id) = FND_API.G_FALSE THEN
108: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_PK_DUP');
109: x_return_status := FND_API.g_ret_sts_error;
110: return;
111: END IF;
112: END IF;

Line 122: IF OZF_UTILITY_PVT.check_uniqueness('ozf_qp_discounts', ' list_line_id = '|| p_qp_disc_rec.list_line_id || ' AND offer_discount_line_id = '|| p_qp_disc_rec.offer_discount_line_id) = FND_API.G_FALSE THEN

118: AND
119: (p_qp_disc_rec.offer_discount_line_id IS NOT NULL AND p_qp_disc_rec.offer_discount_line_id <> FND_API.G_MISS_NUM)
120: )
121: THEN
122: IF OZF_UTILITY_PVT.check_uniqueness('ozf_qp_discounts', ' list_line_id = '|| p_qp_disc_rec.list_line_id || ' AND offer_discount_line_id = '|| p_qp_disc_rec.offer_discount_line_id) = FND_API.G_FALSE THEN
123: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_DUP');
124: x_return_status := FND_API.g_ret_sts_error;
125: return;
126: END IF;

Line 123: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_DUP');

119: (p_qp_disc_rec.offer_discount_line_id IS NOT NULL AND p_qp_disc_rec.offer_discount_line_id <> FND_API.G_MISS_NUM)
120: )
121: THEN
122: IF OZF_UTILITY_PVT.check_uniqueness('ozf_qp_discounts', ' list_line_id = '|| p_qp_disc_rec.list_line_id || ' AND offer_discount_line_id = '|| p_qp_disc_rec.offer_discount_line_id) = FND_API.G_FALSE THEN
123: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_DUP');
124: x_return_status := FND_API.g_ret_sts_error;
125: return;
126: END IF;
127: END IF;

Line 140: IF ozf_utility_pvt.check_fk_exists('qp_list_lines', 'list_line_id',to_char(p_qp_disc_rec.list_line_id)) = FND_API.G_FALSE THEN

136: IS
137: BEGIN
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139: IF p_qp_disc_rec.list_line_id IS NOT NULL AND p_qp_disc_rec.list_line_id <> FND_API.G_MISS_NUM THEN
140: IF ozf_utility_pvt.check_fk_exists('qp_list_lines', 'list_line_id',to_char(p_qp_disc_rec.list_line_id)) = FND_API.G_FALSE THEN
141: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_INV_LLID');
142: x_return_status := FND_API.g_ret_sts_error;
143: return;
144: END IF;

Line 141: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_INV_LLID');

137: BEGIN
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139: IF p_qp_disc_rec.list_line_id IS NOT NULL AND p_qp_disc_rec.list_line_id <> FND_API.G_MISS_NUM THEN
140: IF ozf_utility_pvt.check_fk_exists('qp_list_lines', 'list_line_id',to_char(p_qp_disc_rec.list_line_id)) = FND_API.G_FALSE THEN
141: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_INV_LLID');
142: x_return_status := FND_API.g_ret_sts_error;
143: return;
144: END IF;
145: END IF;

Line 147: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_lines','offer_discount_line_id', to_char(p_qp_disc_rec.offer_discount_line_id)) = FND_API.G_FALSE THEN

143: return;
144: END IF;
145: END IF;
146: IF p_qp_disc_rec.offer_discount_line_id IS NOT NULL AND p_qp_disc_rec.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
147: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_lines','offer_discount_line_id', to_char(p_qp_disc_rec.offer_discount_line_id)) = FND_API.G_FALSE THEN
148: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_INV_ODID');
149: x_return_status := FND_API.g_ret_sts_error;
150: return;
151: END IF;

Line 148: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_INV_ODID');

144: END IF;
145: END IF;
146: IF p_qp_disc_rec.offer_discount_line_id IS NOT NULL AND p_qp_disc_rec.offer_discount_line_id <> FND_API.G_MISS_NUM THEN
147: IF ozf_utility_pvt.check_fk_exists('ozf_offer_discount_lines','offer_discount_line_id', to_char(p_qp_disc_rec.offer_discount_line_id)) = FND_API.G_FALSE THEN
148: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_INV_ODID');
149: x_return_status := FND_API.g_ret_sts_error;
150: return;
151: END IF;
152: END IF;

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

241: ) THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244:
245: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
246:
247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248:
249: IF p_validation_level >= JTF_PLSQL_API.G_VALID_LEVEL_ITEM THEN

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

252: , p_validation_mode => p_validation_mode
253: , x_return_status => x_return_status
254: );
255: END IF;
256: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' End');
257: NULL;
258: END Validate_ozf_qp_discounts;
259:
260: PROCEDURE Create_ozf_qp_discount

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

300: END IF;
301: -- initialize messages
302: FND_MSG_PUB.initialize;
303: -- debug start
304: ozf_utility_pvt.debug_message('Private API: '||l_api_name||' Start');
305: -- set return status
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308: IF FND_GLOBAL.USER_ID IS NULL THEN

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

305: -- set return status
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308: IF FND_GLOBAL.USER_ID IS NULL THEN
309: OZF_Utility_PVT.Error_Message('USER_PROFILE_MISSING');
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: END IF;
312:
313: l_qp_disc_rec := p_qp_disc_rec;

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

364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:
367: x_qp_discount_id := l_ozf_qp_discount_id;
368: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' End');
369: -- commit
370: IF FND_API.to_boolean(p_commit) THEN
371: COMMIT WORK;
372: END IF;

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

452: END IF;
453: IF FND_API.to_boolean(p_init_msg_list) THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459:
460:

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

458:
459:
460:
461: IF l_tar_qp_disc.object_version_number IS NULL OR l_tar_qp_disc.object_version_number = FND_API.G_MISS_NUM THEN
462: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'
463: , p_token_name => 'COLUMN'
464: , p_token_value => 'Last_Update_Date') ;
465: RAISE FND_API.G_EXC_ERROR;
466:

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

468:
469: OPEN c_get_qp_disc(l_tar_qp_disc.ozf_qp_discount_id, l_tar_qp_disc.object_version_number);
470: FETCH c_get_qp_disc INTO l_ref_qp_disc;
471: IF (c_get_qp_disc%NOTFOUND) THEN
472: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'
473: , p_token_name => 'INFO'
474: , p_token_value => 'OZF_QP_DISC') ;
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;

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

476: END IF;
477: CLOSE c_get_qp_disc;
478:
479: IF l_tar_qp_disc.object_version_number <> l_ref_qp_disc.object_version_number THEN
480: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED'
481: , p_token_name => 'INFO'
482: , p_token_value => 'OZF_QP_DISC') ;
483: RAISE FND_API.G_EXC_ERROR;
484: END IF;

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

516: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519:
520: ozf_utility_pvt.debug_message('Private API: '|| l_api_name ||' End');
521: IF FND_API.to_boolean(p_commit) THEN
522: COMMIT WORK;
523: END IF;
524:

Line 532: WHEN OZF_Utility_PVT.resource_locked THEN

528: , p_count => x_msg_count
529: );
530:
531: EXCEPTION
532: WHEN OZF_Utility_PVT.resource_locked THEN
533: x_return_status := FND_API.g_ret_sts_error;
534: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
535:
536: WHEN FND_API.G_EXC_ERROR THEN

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

530:
531: EXCEPTION
532: WHEN OZF_Utility_PVT.resource_locked THEN
533: x_return_status := FND_API.g_ret_sts_error;
534: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
535:
536: WHEN FND_API.G_EXC_ERROR THEN
537: ROLLBACK TO Update_ozf_qp_discount;
538: x_return_status := FND_API.G_RET_STS_ERROR;

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

594:
595: IF FND_API.to_boolean(p_init_msg_list) THEN
596: FND_MSG_PUB.initialize;
597: END IF;
598: ozf_utility_pvt.debug_message('Private API: '|| l_api_name|| ' Start');
599:
600: x_return_status := FND_API.G_RET_STS_SUCCESS;
601:
602: OZF_QP_DISCOUNTS_PKG.Delete_row(