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_VOLUME_OFFER_QUAL_PVT dependencies on FND_API

Line 31: x_return_status := FND_API.G_RET_STS_SUCCESS;

27: , x_msg_data OUT NOCOPY VARCHAR2
28: )
29: IS
30: BEGIN
31: x_return_status := FND_API.G_RET_STS_SUCCESS;
32: IF create_mo_for_group(p_qualifiers_rec.qualifier_grouping_no, p_qualifiers_rec.list_header_id) = 'N' THEN
33: IF get_market_option_id(p_qualifiers_rec.qualifier_grouping_no, p_qualifiers_rec.list_header_id) = -1 THEN
34: OZF_Utility_PVT.Error_Message('OZF_OFFR_INV_MO');
35: x_return_status := FND_API.g_ret_sts_error;

Line 35: x_return_status := FND_API.g_ret_sts_error;

31: x_return_status := FND_API.G_RET_STS_SUCCESS;
32: IF create_mo_for_group(p_qualifiers_rec.qualifier_grouping_no, p_qualifiers_rec.list_header_id) = 'N' THEN
33: IF get_market_option_id(p_qualifiers_rec.qualifier_grouping_no, p_qualifiers_rec.list_header_id) = -1 THEN
34: OZF_Utility_PVT.Error_Message('OZF_OFFR_INV_MO');
35: x_return_status := FND_API.g_ret_sts_error;
36: END IF;
37: p_qual_mo_rec.offer_market_option_id := get_market_option_id(p_qualifiers_rec.qualifier_grouping_no, p_qualifiers_rec.list_header_id);
38: ELSE
39: p_qual_mo_rec.offer_market_option_id := p_mo_rec.offer_market_option_id;

Line 60: x_return_status := FND_API.G_RET_STS_SUCCESS;

56:
57: l_offer_id NUMBER;
58:
59: BEGIN
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
61: OPEN c_offer_id(p_qualifiers_rec.list_header_id);
62: FETCH c_Offer_id INTO l_offer_id;
63: IF (c_offer_id%NOTFOUND) THEN
64: OZF_UTILITY_PVT.Error_message('OZF_OFFR_INV_OFFER_ID');

Line 65: x_return_status := FND_API.G_RET_STS_ERROR;

61: OPEN c_offer_id(p_qualifiers_rec.list_header_id);
62: FETCH c_Offer_id INTO l_offer_id;
63: IF (c_offer_id%NOTFOUND) THEN
64: OZF_UTILITY_PVT.Error_message('OZF_OFFR_INV_OFFER_ID');
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: END IF;
67: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
68: RAISE FND_API.G_EXC_ERROR;
69: END IF;

Line 67: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

63: IF (c_offer_id%NOTFOUND) THEN
64: OZF_UTILITY_PVT.Error_message('OZF_OFFR_INV_OFFER_ID');
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: END IF;
67: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
68: RAISE FND_API.G_EXC_ERROR;
69: END IF;
70: p_mo_rec.offer_id := l_offer_id;
71: p_mo_rec.qp_list_header_id := p_qualifiers_rec.list_header_id;

Line 68: RAISE FND_API.G_EXC_ERROR;

64: OZF_UTILITY_PVT.Error_message('OZF_OFFR_INV_OFFER_ID');
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: END IF;
67: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
68: RAISE FND_API.G_EXC_ERROR;
69: END IF;
70: p_mo_rec.offer_id := l_offer_id;
71: p_mo_rec.qp_list_header_id := p_qualifiers_rec.list_header_id;
72: p_mo_rec.group_number := p_qualifiers_rec.qualifier_grouping_no;

Line 122: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

118:
119: PROCEDURE create_vo_qualifier
120: (
121: p_api_version_number IN NUMBER
122: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
123: , p_commit IN VARCHAR2 := FND_API.G_FALSE
124: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
125:
126: , x_return_status OUT NOCOPY VARCHAR2

Line 123: , p_commit IN VARCHAR2 := FND_API.G_FALSE

119: PROCEDURE create_vo_qualifier
120: (
121: p_api_version_number IN NUMBER
122: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
123: , p_commit IN VARCHAR2 := FND_API.G_FALSE
124: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
125:
126: , x_return_status OUT NOCOPY VARCHAR2
127: , x_msg_count OUT NOCOPY NUMBER

Line 124: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

120: (
121: p_api_version_number IN NUMBER
122: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
123: , p_commit IN VARCHAR2 := FND_API.G_FALSE
124: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
125:
126: , x_return_status OUT NOCOPY VARCHAR2
127: , x_msg_count OUT NOCOPY NUMBER
128: , x_msg_data OUT NOCOPY VARCHAR2

Line 150: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

146: -- Standard Start of API savepoint
147: SAVEPOINT create_volume_offer_qual_pvt;
148:
149: -- Standard call to check for call compatibility.
150: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
151: p_api_version_number,
152: l_api_name,
153: G_PKG_NAME)
154: THEN

Line 155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

151: p_api_version_number,
152: l_api_name,
153: G_PKG_NAME)
154: THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: END IF;
157:
158: -- Initialize message list if p_init_msg_list is set to TRUE.
159: IF FND_API.to_Boolean( p_init_msg_list )

Line 159: IF FND_API.to_Boolean( p_init_msg_list )

155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: END IF;
157:
158: -- Initialize message list if p_init_msg_list is set to TRUE.
159: IF FND_API.to_Boolean( p_init_msg_list )
160: THEN
161: FND_MSG_PUB.initialize;
162: END IF;
163:

Line 168: x_return_status := FND_API.G_RET_STS_SUCCESS;

164: -- Debug Message
165: debug_message('Private API: ' || l_api_name || 'start');
166:
167: -- Initialize API return status to SUCCESS
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169:
170: -- =========================================================================
171: -- Validate Environment
172: -- =========================================================================

Line 177: RAISE FND_API.G_EXC_ERROR;

173:
174: IF FND_GLOBAL.USER_ID IS NULL
175: THEN
176: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
179: -- create market eligibility
180: l_qualifiers_tbl(1) := p_qualifiers_rec;
181:

Line 207: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

203: ,x_error_location => x_error_location
204: ,x_qualifiers_tbl => x_qualifiers_tbl
205: );
206:
207: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
208: RAISE FND_API.G_EXC_ERROR;
209: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;

Line 208: RAISE FND_API.G_EXC_ERROR;

204: ,x_qualifiers_tbl => x_qualifiers_tbl
205: );
206:
207: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
208: RAISE FND_API.G_EXC_ERROR;
209: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:

Line 209: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

205: );
206:
207: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
208: RAISE FND_API.G_EXC_ERROR;
209: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213: debug_message('Return count is : '||x_qualifiers_tbl.count);

Line 210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

206:
207: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
208: RAISE FND_API.G_EXC_ERROR;
209: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213: debug_message('Return count is : '||x_qualifiers_tbl.count);
214:

Line 233: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

229: , x_msg_count => x_msg_count
230: , x_msg_data => x_msg_data
231: );
232:
233: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
234: RAISE FND_API.G_EXC_ERROR;
235: END IF;
236:
237: OZF_offer_Market_Options_PVT.Create_market_options

Line 234: RAISE FND_API.G_EXC_ERROR;

230: , x_msg_data => x_msg_data
231: );
232:
233: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
234: RAISE FND_API.G_EXC_ERROR;
235: END IF;
236:
237: OZF_offer_Market_Options_PVT.Create_market_options
238: (

Line 255: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

251:
252: debug_message('Market option id is : '|| l_mo_id);
253: l_mo_rec.offer_market_option_id := l_mo_id;
254:
255: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258:
259: END IF;

Line 256: RAISE FND_API.G_EXC_ERROR;

252: debug_message('Market option id is : '|| l_mo_id);
253: l_mo_rec.offer_market_option_id := l_mo_id;
254:
255: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258:
259: END IF;
260:

Line 270: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

266: , x_msg_count => x_msg_count
267: , x_msg_data => x_msg_data
268: );
269:
270: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273:
274: OZF_QUAL_MARKET_OPTION_PVT.Create_qual_market_options(

Line 271: RAISE FND_API.G_EXC_ERROR;

267: , x_msg_data => x_msg_data
268: );
269:
270: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273:
274: OZF_QUAL_MARKET_OPTION_PVT.Create_qual_market_options(
275: p_api_version_number => p_api_version_number

Line 288: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

284: , p_qual_mo_rec => l_qual_mo_rec
285: , x_qual_market_option_id => l_qual_market_option_id
286: );
287:
288: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291: END IF;
292:

Line 289: RAISE FND_API.G_EXC_ERROR;

285: , x_qual_market_option_id => l_qual_market_option_id
286: );
287:
288: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291: END IF;
292:
293: END LOOP;

Line 299: p_encoded => Fnd_Api.G_FALSE

295: -- commit
296: Fnd_Msg_Pub.Count_AND_Get
297: ( p_count => x_msg_count,
298: p_data => x_msg_data,
299: p_encoded => Fnd_Api.G_FALSE
300: );
301: IF p_commit = Fnd_Api.g_true THEN
302: COMMIT WORK;
303: END IF;

Line 301: IF p_commit = Fnd_Api.g_true THEN

297: ( p_count => x_msg_count,
298: p_data => x_msg_data,
299: p_encoded => Fnd_Api.G_FALSE
300: );
301: IF p_commit = Fnd_Api.g_true THEN
302: COMMIT WORK;
303: END IF;
304:
305: --exception

Line 307: WHEN Fnd_Api.G_EXC_ERROR THEN

303: END IF;
304:
305: --exception
306: EXCEPTION
307: WHEN Fnd_Api.G_EXC_ERROR THEN
308: x_return_status := Fnd_Api.g_ret_sts_error ;
309: ROLLBACK TO create_volume_offer_qual_pvt;
310: Fnd_Msg_Pub.Count_AND_Get
311: ( p_count => x_msg_count,

Line 308: x_return_status := Fnd_Api.g_ret_sts_error ;

304:
305: --exception
306: EXCEPTION
307: WHEN Fnd_Api.G_EXC_ERROR THEN
308: x_return_status := Fnd_Api.g_ret_sts_error ;
309: ROLLBACK TO create_volume_offer_qual_pvt;
310: Fnd_Msg_Pub.Count_AND_Get
311: ( p_count => x_msg_count,
312: p_data => x_msg_data,

Line 313: p_encoded => Fnd_Api.G_FALSE

309: ROLLBACK TO create_volume_offer_qual_pvt;
310: Fnd_Msg_Pub.Count_AND_Get
311: ( p_count => x_msg_count,
312: p_data => x_msg_data,
313: p_encoded => Fnd_Api.G_FALSE
314: );
315: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
316: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
317: ROLLBACK TO create_volume_offer_qual_pvt;

Line 315: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

311: ( p_count => x_msg_count,
312: p_data => x_msg_data,
313: p_encoded => Fnd_Api.G_FALSE
314: );
315: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
316: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
317: ROLLBACK TO create_volume_offer_qual_pvt;
318: Fnd_Msg_Pub.Count_AND_Get
319: ( p_count => x_msg_count,

Line 316: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

312: p_data => x_msg_data,
313: p_encoded => Fnd_Api.G_FALSE
314: );
315: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
316: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
317: ROLLBACK TO create_volume_offer_qual_pvt;
318: Fnd_Msg_Pub.Count_AND_Get
319: ( p_count => x_msg_count,
320: p_data => x_msg_data,

Line 321: p_encoded => Fnd_Api.G_FALSE

317: ROLLBACK TO create_volume_offer_qual_pvt;
318: Fnd_Msg_Pub.Count_AND_Get
319: ( p_count => x_msg_count,
320: p_data => x_msg_data,
321: p_encoded => Fnd_Api.G_FALSE
322: );
323: WHEN OTHERS THEN
324: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
325: ROLLBACK TO create_volume_offer_qual_pvt;

Line 324: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;

320: p_data => x_msg_data,
321: p_encoded => Fnd_Api.G_FALSE
322: );
323: WHEN OTHERS THEN
324: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
325: ROLLBACK TO create_volume_offer_qual_pvt;
326: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
327: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
328: END IF;

Line 332: p_encoded => Fnd_Api.G_FALSE

328: END IF;
329: Fnd_Msg_Pub.Count_AND_Get
330: ( p_count => x_msg_count,
331: p_data => x_msg_data,
332: p_encoded => Fnd_Api.G_FALSE
333: );
334:
335: END create_vo_qualifier;
336:

Line 371: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

367: */
368: PROCEDURE update_vo_qualifier
369: (
370: p_api_version_number IN NUMBER
371: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
372: , p_commit IN VARCHAR2 := FND_API.G_FALSE
373: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
374:
375: , x_return_status OUT NOCOPY VARCHAR2

Line 372: , p_commit IN VARCHAR2 := FND_API.G_FALSE

368: PROCEDURE update_vo_qualifier
369: (
370: p_api_version_number IN NUMBER
371: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
372: , p_commit IN VARCHAR2 := FND_API.G_FALSE
373: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
374:
375: , x_return_status OUT NOCOPY VARCHAR2
376: , x_msg_count OUT NOCOPY NUMBER

Line 373: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

369: (
370: p_api_version_number IN NUMBER
371: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
372: , p_commit IN VARCHAR2 := FND_API.G_FALSE
373: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
374:
375: , x_return_status OUT NOCOPY VARCHAR2
376: , x_msg_count OUT NOCOPY NUMBER
377: , x_msg_data OUT NOCOPY VARCHAR2

Line 422: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

418: BEGIN
419: -- initialize
420: SAVEPOINT update_volume_offer_qual_pvt;
421: -- Standard call to check for call compatibility.
422: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
423: p_api_version_number,
424: l_api_name,
425: G_PKG_NAME)
426: THEN

Line 427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

423: p_api_version_number,
424: l_api_name,
425: G_PKG_NAME)
426: THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429: -- Initialize message list if p_init_msg_list is set to TRUE.
430: IF FND_API.to_Boolean( p_init_msg_list )
431: THEN

Line 430: IF FND_API.to_Boolean( p_init_msg_list )

426: THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: END IF;
429: -- Initialize message list if p_init_msg_list is set to TRUE.
430: IF FND_API.to_Boolean( p_init_msg_list )
431: THEN
432: FND_MSG_PUB.initialize;
433: END IF;
434: -- Debug Message

Line 438: x_return_status := FND_API.G_RET_STS_SUCCESS;

434: -- Debug Message
435: debug_message('Private API: ' || l_api_name || 'start');
436:
437: -- Initialize API return status to SUCCESS
438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439: -- update
440: l_qualifiers_tbl(1) := p_qualifiers_rec;
441:
442: -- get old group number

Line 470: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

466: ,x_qualifiers_tbl => x_qualifiers_tbl
467: );
468:
469:
470: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;
473:
474: -- check if members still exist in the old group

Line 471: RAISE FND_API.G_EXC_ERROR;

467: );
468:
469:
470: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;
473:
474: -- check if members still exist in the old group
475: l_old_group_members_exist := get_group_members(l_qualifiers_tbl(1).list_header_id,l_group_number );

Line 520: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

516: , p_object_version_number => l_mkt_opt_dtail.object_version_number
517: );
518: END IF;
519: END IF;
520: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523:
524: -- if members did not exist in the new group before the creation of the offer create new market option

Line 521: RAISE FND_API.G_EXC_ERROR;

517: );
518: END IF;
519: END IF;
520: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523:
524: -- if members did not exist in the new group before the creation of the offer create new market option
525: IF l_new_group_members_exist = 'N' THEN

Line 535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

531: , x_msg_count => x_msg_count
532: , x_msg_data => x_msg_data
533: );
534:
535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
536: RAISE FND_API.G_EXC_ERROR;
537: END IF;
538:
539: OZF_offer_Market_Options_PVT.Create_market_options

Line 536: RAISE FND_API.G_EXC_ERROR;

532: , x_msg_data => x_msg_data
533: );
534:
535: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
536: RAISE FND_API.G_EXC_ERROR;
537: END IF;
538:
539: OZF_offer_Market_Options_PVT.Create_market_options
540: (

Line 557: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

553:
554: debug_message('Market option id is : '|| l_mo_id);
555: l_mo_rec.offer_market_option_id := l_mo_id;
556:
557: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
558: RAISE FND_API.G_EXC_ERROR;
559: END IF;
560:
561: END IF; -- END IF l_new_group_members_exist = 'N'

Line 558: RAISE FND_API.G_EXC_ERROR;

554: debug_message('Market option id is : '|| l_mo_id);
555: l_mo_rec.offer_market_option_id := l_mo_id;
556:
557: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
558: RAISE FND_API.G_EXC_ERROR;
559: END IF;
560:
561: END IF; -- END IF l_new_group_members_exist = 'N'
562:

Line 563: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

559: END IF;
560:
561: END IF; -- END IF l_new_group_members_exist = 'N'
562:
563: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
564: RAISE FND_API.G_EXC_ERROR;
565: END IF;
566:
567: -- get the interface details for the qualifier id

Line 564: RAISE FND_API.G_EXC_ERROR;

560:
561: END IF; -- END IF l_new_group_members_exist = 'N'
562:
563: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
564: RAISE FND_API.G_EXC_ERROR;
565: END IF;
566:
567: -- get the interface details for the qualifier id
568: OPEN c_qual_mo(p_qualifiers_rec.qualifier_id);

Line 608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

604:
605: , p_qual_mo_rec => l_qual_mo_rec
606: );
607:
608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611:
612: ELSE

Line 609: RAISE FND_API.G_EXC_ERROR;

605: , p_qual_mo_rec => l_qual_mo_rec
606: );
607:
608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611:
612: ELSE
613: OZF_Utility_PVT.Error_Message('OZF_CANT_UPDATE_INT');

Line 614: x_return_status := FND_API.g_ret_sts_error;

610: END IF;
611:
612: ELSE
613: OZF_Utility_PVT.Error_Message('OZF_CANT_UPDATE_INT');
614: x_return_status := FND_API.g_ret_sts_error;
615: END IF; -- END IF l_market_option_id <> -1
616:
617: END IF; -- end if group nos are different
618: END IF; -- if qualifiers are in contexts CUSTOMER, CUSTOMER_GROUP, TERRITORY, SOLD_BY

Line 626: p_encoded => Fnd_Api.G_FALSE

622: -- commit;
623: Fnd_Msg_Pub.Count_AND_Get
624: ( p_count => x_msg_count,
625: p_data => x_msg_data,
626: p_encoded => Fnd_Api.G_FALSE
627: );
628: IF p_commit = Fnd_Api.g_true THEN
629: COMMIT WORK;
630: END IF;

Line 628: IF p_commit = Fnd_Api.g_true THEN

624: ( p_count => x_msg_count,
625: p_data => x_msg_data,
626: p_encoded => Fnd_Api.G_FALSE
627: );
628: IF p_commit = Fnd_Api.g_true THEN
629: COMMIT WORK;
630: END IF;
631:
632: --exception

Line 634: WHEN Fnd_Api.G_EXC_ERROR THEN

630: END IF;
631:
632: --exception
633: EXCEPTION
634: WHEN Fnd_Api.G_EXC_ERROR THEN
635: x_return_status := Fnd_Api.g_ret_sts_error ;
636: ROLLBACK TO update_volume_offer_qual_pvt;
637: Fnd_Msg_Pub.Count_AND_Get
638: ( p_count => x_msg_count,

Line 635: x_return_status := Fnd_Api.g_ret_sts_error ;

631:
632: --exception
633: EXCEPTION
634: WHEN Fnd_Api.G_EXC_ERROR THEN
635: x_return_status := Fnd_Api.g_ret_sts_error ;
636: ROLLBACK TO update_volume_offer_qual_pvt;
637: Fnd_Msg_Pub.Count_AND_Get
638: ( p_count => x_msg_count,
639: p_data => x_msg_data,

Line 640: p_encoded => Fnd_Api.G_FALSE

636: ROLLBACK TO update_volume_offer_qual_pvt;
637: Fnd_Msg_Pub.Count_AND_Get
638: ( p_count => x_msg_count,
639: p_data => x_msg_data,
640: p_encoded => Fnd_Api.G_FALSE
641: );
642: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
643: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
644: ROLLBACK TO update_volume_offer_qual_pvt;

Line 642: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

638: ( p_count => x_msg_count,
639: p_data => x_msg_data,
640: p_encoded => Fnd_Api.G_FALSE
641: );
642: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
643: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
644: ROLLBACK TO update_volume_offer_qual_pvt;
645: Fnd_Msg_Pub.Count_AND_Get
646: ( p_count => x_msg_count,

Line 643: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

639: p_data => x_msg_data,
640: p_encoded => Fnd_Api.G_FALSE
641: );
642: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
643: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
644: ROLLBACK TO update_volume_offer_qual_pvt;
645: Fnd_Msg_Pub.Count_AND_Get
646: ( p_count => x_msg_count,
647: p_data => x_msg_data,

Line 648: p_encoded => Fnd_Api.G_FALSE

644: ROLLBACK TO update_volume_offer_qual_pvt;
645: Fnd_Msg_Pub.Count_AND_Get
646: ( p_count => x_msg_count,
647: p_data => x_msg_data,
648: p_encoded => Fnd_Api.G_FALSE
649: );
650: WHEN OTHERS THEN
651: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
652: ROLLBACK TO update_volume_offer_qual_pvt;

Line 651: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;

647: p_data => x_msg_data,
648: p_encoded => Fnd_Api.G_FALSE
649: );
650: WHEN OTHERS THEN
651: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
652: ROLLBACK TO update_volume_offer_qual_pvt;
653: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
654: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
655: END IF;

Line 659: p_encoded => Fnd_Api.G_FALSE

655: END IF;
656: Fnd_Msg_Pub.Count_AND_Get
657: ( p_count => x_msg_count,
658: p_data => x_msg_data,
659: p_encoded => Fnd_Api.G_FALSE
660: );
661:
662: END update_vo_qualifier;
663:

Line 668: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

664:
665:
666: PROCEDURE Delete_vo_qualifier(
667: p_api_version_number IN NUMBER
668: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
669: , p_commit IN VARCHAR2 := FND_API.G_FALSE
670: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
671: , x_return_status OUT NOCOPY VARCHAR2
672: , x_msg_count OUT NOCOPY NUMBER

Line 669: , p_commit IN VARCHAR2 := FND_API.G_FALSE

665:
666: PROCEDURE Delete_vo_qualifier(
667: p_api_version_number IN NUMBER
668: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
669: , p_commit IN VARCHAR2 := FND_API.G_FALSE
670: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
671: , x_return_status OUT NOCOPY VARCHAR2
672: , x_msg_count OUT NOCOPY NUMBER
673: , x_msg_data OUT NOCOPY VARCHAR2

Line 670: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

666: PROCEDURE Delete_vo_qualifier(
667: p_api_version_number IN NUMBER
668: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
669: , p_commit IN VARCHAR2 := FND_API.G_FALSE
670: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
671: , x_return_status OUT NOCOPY VARCHAR2
672: , x_msg_count OUT NOCOPY NUMBER
673: , x_msg_data OUT NOCOPY VARCHAR2
674: , p_qualifier_id IN NUMBER

Line 714: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

710: l_qualifierContext VARCHAR2(30);
711: BEGIN
712: SAVEPOINT Delete_volume_offer_qual_pvt;
713: -- Standard call to check for call compatibility.
714: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
715: p_api_version_number,
716: l_api_name,
717: G_PKG_NAME)
718: THEN

Line 719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

715: p_api_version_number,
716: l_api_name,
717: G_PKG_NAME)
718: THEN
719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
720: END IF;
721: -- Initialize message list if p_init_msg_list is set to TRUE.
722: IF FND_API.to_Boolean( p_init_msg_list )
723: THEN

Line 722: IF FND_API.to_Boolean( p_init_msg_list )

718: THEN
719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
720: END IF;
721: -- Initialize message list if p_init_msg_list is set to TRUE.
722: IF FND_API.to_Boolean( p_init_msg_list )
723: THEN
724: FND_MSG_PUB.initialize;
725: END IF;
726: -- Debug Message

Line 730: x_return_status := FND_API.G_RET_STS_SUCCESS;

726: -- Debug Message
727: debug_message('Private API: ' || l_api_name || 'start');
728:
729: -- Initialize API return status to SUCCESS
730: x_return_status := FND_API.G_RET_STS_SUCCESS;
731:
732:
733: -- get group number
734: OPEN c_group_no(p_qualifier_id);

Line 758: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

754: ,x_error_location => x_error_location
755: ,x_qualifiers_tbl => x_qualifiers_tbl
756: );
757:
758: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
759: RAISE FND_API.G_EXC_ERROR;
760: END IF;
761:
762: OPEN c_qualifierContext( cp_qualifierId => p_qualifier_id);

Line 759: RAISE FND_API.G_EXC_ERROR;

755: ,x_qualifiers_tbl => x_qualifiers_tbl
756: );
757:
758: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
759: RAISE FND_API.G_EXC_ERROR;
760: END IF;
761:
762: OPEN c_qualifierContext( cp_qualifierId => p_qualifier_id);
763: FETCH c_qualifierContext INTO l_qualifierContext;

Line 800: x_return_status := FND_API.g_ret_sts_error;

796:
797: END IF;
798: ELSE
799: OZF_Utility_PVT.Error_Message('OZF_OFFR_MO_CANT_DELETE_MO');
800: x_return_status := FND_API.g_ret_sts_error;
801: END IF;
802: END IF;
803: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
804: RAISE FND_API.G_EXC_ERROR;

Line 803: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

799: OZF_Utility_PVT.Error_Message('OZF_OFFR_MO_CANT_DELETE_MO');
800: x_return_status := FND_API.g_ret_sts_error;
801: END IF;
802: END IF;
803: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806:
807: -- delete the interface reference

Line 804: RAISE FND_API.G_EXC_ERROR;

800: x_return_status := FND_API.g_ret_sts_error;
801: END IF;
802: END IF;
803: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806:
807: -- delete the interface reference
808: OPEN c_qual_mo(p_qualifier_id);

Line 812: x_return_status := FND_API.g_ret_sts_error;

808: OPEN c_qual_mo(p_qualifier_id);
809: FETCH c_qual_mo INTO l_qual_mo;
810: IF (c_qual_mo%NOTFOUND) THEN
811: OZF_Utility_PVT.Error_Message('OZF_OFFR_MO_INTF_REC_NOT_FOUND');
812: x_return_status := FND_API.g_ret_sts_error;
813: ELSE
814: OZF_QUAL_MARKET_OPTION_PVT.Delete_qual_market_options(
815: p_api_version_number => p_api_version_number
816: , p_init_msg_list => p_init_msg_list

Line 828: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

824: );
825:
826: END IF;
827:
828: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;
831:
832: END IF;

Line 829: RAISE FND_API.G_EXC_ERROR;

825:
826: END IF;
827:
828: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
829: RAISE FND_API.G_EXC_ERROR;
830: END IF;
831:
832: END IF;
833: Fnd_Msg_Pub.Count_AND_Get

Line 836: p_encoded => Fnd_Api.G_FALSE

832: END IF;
833: Fnd_Msg_Pub.Count_AND_Get
834: ( p_count => x_msg_count,
835: p_data => x_msg_data,
836: p_encoded => Fnd_Api.G_FALSE
837: );
838: IF p_commit = Fnd_Api.g_true THEN
839: COMMIT WORK;
840: END IF;

Line 838: IF p_commit = Fnd_Api.g_true THEN

834: ( p_count => x_msg_count,
835: p_data => x_msg_data,
836: p_encoded => Fnd_Api.G_FALSE
837: );
838: IF p_commit = Fnd_Api.g_true THEN
839: COMMIT WORK;
840: END IF;
841:
842: --exception

Line 844: WHEN Fnd_Api.G_EXC_ERROR THEN

840: END IF;
841:
842: --exception
843: EXCEPTION
844: WHEN Fnd_Api.G_EXC_ERROR THEN
845: x_return_status := Fnd_Api.g_ret_sts_error ;
846: ROLLBACK TO Delete_volume_offer_qual_pvt;
847: Fnd_Msg_Pub.Count_AND_Get
848: ( p_count => x_msg_count,

Line 845: x_return_status := Fnd_Api.g_ret_sts_error ;

841:
842: --exception
843: EXCEPTION
844: WHEN Fnd_Api.G_EXC_ERROR THEN
845: x_return_status := Fnd_Api.g_ret_sts_error ;
846: ROLLBACK TO Delete_volume_offer_qual_pvt;
847: Fnd_Msg_Pub.Count_AND_Get
848: ( p_count => x_msg_count,
849: p_data => x_msg_data,

Line 850: p_encoded => Fnd_Api.G_FALSE

846: ROLLBACK TO Delete_volume_offer_qual_pvt;
847: Fnd_Msg_Pub.Count_AND_Get
848: ( p_count => x_msg_count,
849: p_data => x_msg_data,
850: p_encoded => Fnd_Api.G_FALSE
851: );
852: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
853: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
854: ROLLBACK TO Delete_volume_offer_qual_pvt;

Line 852: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

848: ( p_count => x_msg_count,
849: p_data => x_msg_data,
850: p_encoded => Fnd_Api.G_FALSE
851: );
852: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
853: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
854: ROLLBACK TO Delete_volume_offer_qual_pvt;
855: Fnd_Msg_Pub.Count_AND_Get
856: ( p_count => x_msg_count,

Line 853: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

849: p_data => x_msg_data,
850: p_encoded => Fnd_Api.G_FALSE
851: );
852: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
853: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
854: ROLLBACK TO Delete_volume_offer_qual_pvt;
855: Fnd_Msg_Pub.Count_AND_Get
856: ( p_count => x_msg_count,
857: p_data => x_msg_data,

Line 858: p_encoded => Fnd_Api.G_FALSE

854: ROLLBACK TO Delete_volume_offer_qual_pvt;
855: Fnd_Msg_Pub.Count_AND_Get
856: ( p_count => x_msg_count,
857: p_data => x_msg_data,
858: p_encoded => Fnd_Api.G_FALSE
859: );
860: WHEN OTHERS THEN
861: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
862: ROLLBACK TO Delete_volume_offer_qual_pvt;

Line 861: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;

857: p_data => x_msg_data,
858: p_encoded => Fnd_Api.G_FALSE
859: );
860: WHEN OTHERS THEN
861: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
862: ROLLBACK TO Delete_volume_offer_qual_pvt;
863: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
864: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
865: END IF;

Line 869: p_encoded => Fnd_Api.G_FALSE

865: END IF;
866: Fnd_Msg_Pub.Count_AND_Get
867: ( p_count => x_msg_count,
868: p_data => x_msg_data,
869: p_encoded => Fnd_Api.G_FALSE
870: );
871:
872:
873: END Delete_vo_qualifier;