APPS.OZF_OFFER_PUB dependencies on FND_API

Line 64: IF Fnd_Api.to_boolean(p_init_msg_list) THEN

60: WHERE activity_budget_id = l_act_budg_id;
61: BEGIN
62:
63: SAVEPOINT process_modifiers_pub;
64: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
65: Fnd_Msg_Pub.initialize;
66: END IF;
67:
68: IF NOT Fnd_Api.compatible_api_call(l_api_version,

Line 68: IF NOT Fnd_Api.compatible_api_call(l_api_version,

64: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
65: Fnd_Msg_Pub.initialize;
66: END IF;
67:
68: IF NOT Fnd_Api.compatible_api_call(l_api_version,
69: p_api_version,
70: l_api_name,
71: g_pkg_name)
72: THEN

Line 73: RAISE Fnd_Api.g_exc_unexpected_error;

69: p_api_version,
70: l_api_name,
71: g_pkg_name)
72: THEN
73: RAISE Fnd_Api.g_exc_unexpected_error;
74: END IF;
75:
76: x_return_status := Fnd_Api.g_ret_sts_success;
77: x_error_location := 0;

Line 76: x_return_status := Fnd_Api.g_ret_sts_success;

72: THEN
73: RAISE Fnd_Api.g_exc_unexpected_error;
74: END IF;
75:
76: x_return_status := Fnd_Api.g_ret_sts_success;
77: x_error_location := 0;
78:
79: l_modifier_list_rec.OFFER_ID := p_modifier_list_rec.OFFER_ID;
80: l_modifier_list_rec.QP_LIST_HEADER_ID := p_modifier_list_rec.QP_LIST_HEADER_ID;

Line 169: IF p_modifier_list_rec.OWNER_ID IS NULL OR p_modifier_list_rec.OWNER_ID = fnd_api.g_miss_num THEN

165: l_modifier_list_rec.modifier_operation := 'CREATE';
166: l_modifier_list_rec.status_code := 'DRAFT';
167: l_modifier_list_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS','DRAFT');--1600;
168:
169: IF p_modifier_list_rec.OWNER_ID IS NULL OR p_modifier_list_rec.OWNER_ID = fnd_api.g_miss_num THEN
170: l_modifier_list_rec.OWNER_ID := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
171: ELSE
172: l_modifier_list_rec.OWNER_ID := p_modifier_list_rec.OWNER_ID;
173: END IF;

Line 188: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

184: ,p_modifier_line_tbl => l_modifier_line_tbl -- need to create header first. use empty line.
185: ,x_qp_list_header_id => x_qp_list_header_id
186: ,x_error_location => x_error_location);
187:
188: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
189: RAISE Fnd_Api.g_exc_error;
190: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
191: RAISE Fnd_Api.g_exc_unexpected_error;
192: END IF;

Line 189: RAISE Fnd_Api.g_exc_error;

185: ,x_qp_list_header_id => x_qp_list_header_id
186: ,x_error_location => x_error_location);
187:
188: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
189: RAISE Fnd_Api.g_exc_error;
190: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
191: RAISE Fnd_Api.g_exc_unexpected_error;
192: END IF;
193:

Line 190: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

186: ,x_error_location => x_error_location);
187:
188: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
189: RAISE Fnd_Api.g_exc_error;
190: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
191: RAISE Fnd_Api.g_exc_unexpected_error;
192: END IF;
193:
194: l_modifier_list_rec.qp_list_header_id := x_qp_list_header_id;

Line 191: RAISE Fnd_Api.g_exc_unexpected_error;

187:
188: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
189: RAISE Fnd_Api.g_exc_error;
190: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
191: RAISE Fnd_Api.g_exc_unexpected_error;
192: END IF;
193:
194: l_modifier_list_rec.qp_list_header_id := x_qp_list_header_id;
195: IF p_modifier_list_rec.user_status_id IS NOT NULL AND p_modifier_list_rec.user_status_id <> fnd_api.g_miss_num THEN -- might have additional stage eg ACTIVE to go

Line 195: IF p_modifier_list_rec.user_status_id IS NOT NULL AND p_modifier_list_rec.user_status_id <> fnd_api.g_miss_num THEN -- might have additional stage eg ACTIVE to go

191: RAISE Fnd_Api.g_exc_unexpected_error;
192: END IF;
193:
194: l_modifier_list_rec.qp_list_header_id := x_qp_list_header_id;
195: IF p_modifier_list_rec.user_status_id IS NOT NULL AND p_modifier_list_rec.user_status_id <> fnd_api.g_miss_num THEN -- might have additional stage eg ACTIVE to go
196: l_modifier_list_rec.offer_operation := 'UPDATE';
197: l_modifier_list_rec.modifier_operation := 'UPDATE';
198: l_modifier_list_rec.user_status_id := p_modifier_list_rec.user_status_id;
199: l_modifier_list_rec.status_code := ozf_utility_pvt.get_system_status_code(p_modifier_list_rec.user_status_id);

Line 201: l_modifier_list_rec.offer_operation := fnd_api.g_miss_char;

197: l_modifier_list_rec.modifier_operation := 'UPDATE';
198: l_modifier_list_rec.user_status_id := p_modifier_list_rec.user_status_id;
199: l_modifier_list_rec.status_code := ozf_utility_pvt.get_system_status_code(p_modifier_list_rec.user_status_id);
200: ELSE -- creating draft offer hdr only
201: l_modifier_list_rec.offer_operation := fnd_api.g_miss_char;
202: l_modifier_list_rec.modifier_operation := fnd_api.g_miss_char;
203: l_modifier_list_rec.user_status_id := fnd_api.g_miss_num;
204: l_modifier_list_rec.status_code := fnd_api.g_miss_char;
205: END IF;

Line 202: l_modifier_list_rec.modifier_operation := fnd_api.g_miss_char;

198: l_modifier_list_rec.user_status_id := p_modifier_list_rec.user_status_id;
199: l_modifier_list_rec.status_code := ozf_utility_pvt.get_system_status_code(p_modifier_list_rec.user_status_id);
200: ELSE -- creating draft offer hdr only
201: l_modifier_list_rec.offer_operation := fnd_api.g_miss_char;
202: l_modifier_list_rec.modifier_operation := fnd_api.g_miss_char;
203: l_modifier_list_rec.user_status_id := fnd_api.g_miss_num;
204: l_modifier_list_rec.status_code := fnd_api.g_miss_char;
205: END IF;
206: ELSE

Line 203: l_modifier_list_rec.user_status_id := fnd_api.g_miss_num;

199: l_modifier_list_rec.status_code := ozf_utility_pvt.get_system_status_code(p_modifier_list_rec.user_status_id);
200: ELSE -- creating draft offer hdr only
201: l_modifier_list_rec.offer_operation := fnd_api.g_miss_char;
202: l_modifier_list_rec.modifier_operation := fnd_api.g_miss_char;
203: l_modifier_list_rec.user_status_id := fnd_api.g_miss_num;
204: l_modifier_list_rec.status_code := fnd_api.g_miss_char;
205: END IF;
206: ELSE
207: x_qp_list_header_id := p_modifier_list_rec.qp_list_header_id;

Line 204: l_modifier_list_rec.status_code := fnd_api.g_miss_char;

200: ELSE -- creating draft offer hdr only
201: l_modifier_list_rec.offer_operation := fnd_api.g_miss_char;
202: l_modifier_list_rec.modifier_operation := fnd_api.g_miss_char;
203: l_modifier_list_rec.user_status_id := fnd_api.g_miss_num;
204: l_modifier_list_rec.status_code := fnd_api.g_miss_char;
205: END IF;
206: ELSE
207: x_qp_list_header_id := p_modifier_list_rec.qp_list_header_id;
208: IF p_modifier_list_rec.OWNER_ID IS NULL THEN

Line 209: l_modifier_list_rec.OWNER_ID := fnd_api.g_miss_num;

205: END IF;
206: ELSE
207: x_qp_list_header_id := p_modifier_list_rec.qp_list_header_id;
208: IF p_modifier_list_rec.OWNER_ID IS NULL THEN
209: l_modifier_list_rec.OWNER_ID := fnd_api.g_miss_num;
210: ELSE
211: l_modifier_list_rec.OWNER_ID := p_modifier_list_rec.OWNER_ID;
212: END IF;
213: END IF;

Line 320: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

316: ,x_msg_data => x_msg_data
317: ,p_pricing_attr_tbl => l_exclusion_tbl
318: ,x_error_location => x_error_location);
319:
320: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
321: RAISE Fnd_Api.g_exc_error;
322: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
323: RAISE Fnd_Api.g_exc_unexpected_error;
324: END IF;

Line 321: RAISE Fnd_Api.g_exc_error;

317: ,p_pricing_attr_tbl => l_exclusion_tbl
318: ,x_error_location => x_error_location);
319:
320: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
321: RAISE Fnd_Api.g_exc_error;
322: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
323: RAISE Fnd_Api.g_exc_unexpected_error;
324: END IF;
325: END IF;

Line 322: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

318: ,x_error_location => x_error_location);
319:
320: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
321: RAISE Fnd_Api.g_exc_error;
322: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
323: RAISE Fnd_Api.g_exc_unexpected_error;
324: END IF;
325: END IF;
326:

Line 323: RAISE Fnd_Api.g_exc_unexpected_error;

319:
320: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
321: RAISE Fnd_Api.g_exc_error;
322: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
323: RAISE Fnd_Api.g_exc_unexpected_error;
324: END IF;
325: END IF;
326:
327: -- offer line

Line 353: IF p_act_product_tbl(i).act_product_used_by_id IS NULL OR p_act_product_tbl(i).act_product_used_by_id = FND_API.g_miss_num THEN

349: l_act_product_rec.quantity := p_act_product_tbl(i).quantity;
350: l_act_product_rec.adjustment_flag := p_act_product_tbl(i).adjustment_flag;
351:
352: IF p_act_product_tbl(i).operation = 'CREATE' THEN
353: IF p_act_product_tbl(i).act_product_used_by_id IS NULL OR p_act_product_tbl(i).act_product_used_by_id = FND_API.g_miss_num THEN
354: l_act_product_rec.act_product_used_by_id := x_qp_list_header_id;
355: ELSE
356: l_act_product_rec.act_product_used_by_id := p_act_product_tbl(i).act_product_used_by_id;
357: END IF;

Line 363: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

359: AMS_ActProduct_PVT.Create_Act_Product(
360: p_api_version => p_api_version,
361: p_init_msg_list => p_init_msg_list,
362: p_commit => p_commit,
363: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
364: x_return_status => x_return_status,
365: x_msg_count => x_msg_count,
366: x_msg_data => x_msg_data,
367: p_act_Product_rec => l_act_product_rec,

Line 370: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

366: x_msg_data => x_msg_data,
367: p_act_Product_rec => l_act_product_rec,
368: x_act_Product_id => l_act_product_id);
369:
370: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
371: RAISE Fnd_Api.g_exc_error;
372: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
373: RAISE Fnd_Api.g_exc_unexpected_error;
374: END IF;

Line 371: RAISE Fnd_Api.g_exc_error;

367: p_act_Product_rec => l_act_product_rec,
368: x_act_Product_id => l_act_product_id);
369:
370: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
371: RAISE Fnd_Api.g_exc_error;
372: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
373: RAISE Fnd_Api.g_exc_unexpected_error;
374: END IF;
375: ELSIF p_act_product_tbl(i).operation = 'UPDATE' THEN

Line 372: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

368: x_act_Product_id => l_act_product_id);
369:
370: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
371: RAISE Fnd_Api.g_exc_error;
372: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
373: RAISE Fnd_Api.g_exc_unexpected_error;
374: END IF;
375: ELSIF p_act_product_tbl(i).operation = 'UPDATE' THEN
376: l_act_product_rec.activity_product_id := p_act_product_tbl(i).activity_product_id;

Line 373: RAISE Fnd_Api.g_exc_unexpected_error;

369:
370: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
371: RAISE Fnd_Api.g_exc_error;
372: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
373: RAISE Fnd_Api.g_exc_unexpected_error;
374: END IF;
375: ELSIF p_act_product_tbl(i).operation = 'UPDATE' THEN
376: l_act_product_rec.activity_product_id := p_act_product_tbl(i).activity_product_id;
377: l_act_product_rec.object_version_number := p_act_product_tbl(i).object_version_number;

Line 384: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

380: AMS_ActProduct_PVT.Update_Act_Product(
381: p_api_version => p_api_version,
382: p_init_msg_list => p_init_msg_list,
383: p_commit => p_commit,
384: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
385: x_return_status => x_return_status,
386: x_msg_count => x_msg_count,
387: x_msg_data => x_msg_data,
388: p_act_Product_rec => l_act_product_rec);

Line 390: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

386: x_msg_count => x_msg_count,
387: x_msg_data => x_msg_data,
388: p_act_Product_rec => l_act_product_rec);
389:
390: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
391: RAISE Fnd_Api.g_exc_error;
392: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
393: RAISE Fnd_Api.g_exc_unexpected_error;
394: END IF;

Line 391: RAISE Fnd_Api.g_exc_error;

387: x_msg_data => x_msg_data,
388: p_act_Product_rec => l_act_product_rec);
389:
390: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
391: RAISE Fnd_Api.g_exc_error;
392: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
393: RAISE Fnd_Api.g_exc_unexpected_error;
394: END IF;
395: ELSIF p_act_product_tbl(i).operation = 'DELETE' THEN

Line 392: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

388: p_act_Product_rec => l_act_product_rec);
389:
390: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
391: RAISE Fnd_Api.g_exc_error;
392: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
393: RAISE Fnd_Api.g_exc_unexpected_error;
394: END IF;
395: ELSIF p_act_product_tbl(i).operation = 'DELETE' THEN
396: AMS_ActProduct_PVT.Delete_Act_Product(

Line 393: RAISE Fnd_Api.g_exc_unexpected_error;

389:
390: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
391: RAISE Fnd_Api.g_exc_error;
392: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
393: RAISE Fnd_Api.g_exc_unexpected_error;
394: END IF;
395: ELSIF p_act_product_tbl(i).operation = 'DELETE' THEN
396: AMS_ActProduct_PVT.Delete_Act_Product(
397: p_api_version => p_api_version,

Line 400: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

396: AMS_ActProduct_PVT.Delete_Act_Product(
397: p_api_version => p_api_version,
398: p_init_msg_list => p_init_msg_list,
399: p_commit => p_commit,
400: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
401: x_return_status => x_return_status,
402: x_msg_count => x_msg_count,
403: x_msg_data => x_msg_data,
404: p_act_Product_id => p_act_product_tbl(i).activity_product_id,

Line 407: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

403: x_msg_data => x_msg_data,
404: p_act_Product_id => p_act_product_tbl(i).activity_product_id,
405: p_object_version => p_act_product_tbl(i).object_version_number);
406:
407: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
408: RAISE Fnd_Api.g_exc_error;
409: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
410: RAISE Fnd_Api.g_exc_unexpected_error;
411: END IF;

Line 408: RAISE Fnd_Api.g_exc_error;

404: p_act_Product_id => p_act_product_tbl(i).activity_product_id,
405: p_object_version => p_act_product_tbl(i).object_version_number);
406:
407: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
408: RAISE Fnd_Api.g_exc_error;
409: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
410: RAISE Fnd_Api.g_exc_unexpected_error;
411: END IF;
412: END IF;

Line 409: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

405: p_object_version => p_act_product_tbl(i).object_version_number);
406:
407: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
408: RAISE Fnd_Api.g_exc_error;
409: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
410: RAISE Fnd_Api.g_exc_unexpected_error;
411: END IF;
412: END IF;
413: END LOOP;

Line 410: RAISE Fnd_Api.g_exc_unexpected_error;

406:
407: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
408: RAISE Fnd_Api.g_exc_error;
409: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
410: RAISE Fnd_Api.g_exc_unexpected_error;
411: END IF;
412: END IF;
413: END LOOP;
414: END IF;

Line 447: IF p_discount_tbl(i).offer_id IS NULL OR p_discount_tbl(i).offer_id = FND_API.g_miss_num THEN

443: l_discount_line_rec.product_id := p_discount_tbl(i).product_id;
444: l_discount_line_rec.excluder_flag := p_discount_tbl(i).excluder_flag;
445:
446: IF p_discount_tbl(i).operation = 'CREATE' THEN
447: IF p_discount_tbl(i).offer_id IS NULL OR p_discount_tbl(i).offer_id = FND_API.g_miss_num THEN
448: l_discount_line_rec.offer_id := l_offer_id;
449: ELSE
450: l_discount_line_rec.offer_id := p_discount_tbl(i).offer_id;
451: END IF;

Line 457: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

453: OZF_Disc_Line_PVT.Create_discount_line(
454: p_api_version_number => p_api_version,
455: p_init_msg_list => p_init_msg_list,
456: p_commit => p_commit,
457: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
458: x_return_status => x_return_status,
459: x_msg_count => x_msg_count,
460: x_msg_data => x_msg_data,
461: p_ozf_discount_line_rec => l_discount_line_rec,

Line 464: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

460: x_msg_data => x_msg_data,
461: p_ozf_discount_line_rec => l_discount_line_rec,
462: x_offer_discount_line_id => l_discount_line_id);
463:
464: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
465: RAISE Fnd_Api.g_exc_error;
466: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
467: RAISE Fnd_Api.g_exc_unexpected_error;
468: END IF;

Line 465: RAISE Fnd_Api.g_exc_error;

461: p_ozf_discount_line_rec => l_discount_line_rec,
462: x_offer_discount_line_id => l_discount_line_id);
463:
464: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
465: RAISE Fnd_Api.g_exc_error;
466: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
467: RAISE Fnd_Api.g_exc_unexpected_error;
468: END IF;
469: ELSIF p_discount_tbl(i).operation = 'UPDATE' THEN

Line 466: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

462: x_offer_discount_line_id => l_discount_line_id);
463:
464: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
465: RAISE Fnd_Api.g_exc_error;
466: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
467: RAISE Fnd_Api.g_exc_unexpected_error;
468: END IF;
469: ELSIF p_discount_tbl(i).operation = 'UPDATE' THEN
470: l_discount_line_rec.offer_discount_line_id := p_discount_tbl(i).offer_discount_line_id;

Line 467: RAISE Fnd_Api.g_exc_unexpected_error;

463:
464: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
465: RAISE Fnd_Api.g_exc_error;
466: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
467: RAISE Fnd_Api.g_exc_unexpected_error;
468: END IF;
469: ELSIF p_discount_tbl(i).operation = 'UPDATE' THEN
470: l_discount_line_rec.offer_discount_line_id := p_discount_tbl(i).offer_discount_line_id;
471: l_discount_line_rec.offer_id := p_discount_tbl(i).offer_id;

Line 478: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

474: OZF_Disc_Line_PVT.Update_discount_line(
475: p_api_version_number => p_api_version,
476: p_init_msg_list => p_init_msg_list,
477: p_commit => p_commit,
478: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
479: x_return_status => x_return_status,
480: x_msg_count => x_msg_count,
481: x_msg_data => x_msg_data,
482: p_ozf_discount_line_rec => l_discount_line_rec);

Line 484: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

480: x_msg_count => x_msg_count,
481: x_msg_data => x_msg_data,
482: p_ozf_discount_line_rec => l_discount_line_rec);
483:
484: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
485: RAISE Fnd_Api.g_exc_error;
486: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
487: RAISE Fnd_Api.g_exc_unexpected_error;
488: END IF;

Line 485: RAISE Fnd_Api.g_exc_error;

481: x_msg_data => x_msg_data,
482: p_ozf_discount_line_rec => l_discount_line_rec);
483:
484: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
485: RAISE Fnd_Api.g_exc_error;
486: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
487: RAISE Fnd_Api.g_exc_unexpected_error;
488: END IF;
489: ELSIF p_discount_tbl(i).operation = 'DELETE' THEN

Line 486: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

482: p_ozf_discount_line_rec => l_discount_line_rec);
483:
484: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
485: RAISE Fnd_Api.g_exc_error;
486: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
487: RAISE Fnd_Api.g_exc_unexpected_error;
488: END IF;
489: ELSIF p_discount_tbl(i).operation = 'DELETE' THEN
490: OZF_Disc_Line_PVT.Delete_offer_line(

Line 487: RAISE Fnd_Api.g_exc_unexpected_error;

483:
484: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
485: RAISE Fnd_Api.g_exc_error;
486: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
487: RAISE Fnd_Api.g_exc_unexpected_error;
488: END IF;
489: ELSIF p_discount_tbl(i).operation = 'DELETE' THEN
490: OZF_Disc_Line_PVT.Delete_offer_line(
491: p_api_version_number => p_api_version,

Line 494: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

490: OZF_Disc_Line_PVT.Delete_offer_line(
491: p_api_version_number => p_api_version,
492: p_init_msg_list => p_init_msg_list,
493: p_commit => p_commit,
494: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
495: x_return_status => x_return_status,
496: x_msg_count => x_msg_count,
497: x_msg_data => x_msg_data,
498: p_offer_discount_line_id => p_discount_tbl(i).offer_discount_line_id,

Line 501: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

497: x_msg_data => x_msg_data,
498: p_offer_discount_line_id => p_discount_tbl(i).offer_discount_line_id,
499: p_object_version_number => p_discount_tbl(i).object_version_number);
500:
501: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
502: RAISE Fnd_Api.g_exc_error;
503: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
504: RAISE Fnd_Api.g_exc_unexpected_error;
505: END IF;

Line 502: RAISE Fnd_Api.g_exc_error;

498: p_offer_discount_line_id => p_discount_tbl(i).offer_discount_line_id,
499: p_object_version_number => p_discount_tbl(i).object_version_number);
500:
501: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
502: RAISE Fnd_Api.g_exc_error;
503: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
504: RAISE Fnd_Api.g_exc_unexpected_error;
505: END IF;
506: END IF;

Line 503: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

499: p_object_version_number => p_discount_tbl(i).object_version_number);
500:
501: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
502: RAISE Fnd_Api.g_exc_error;
503: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
504: RAISE Fnd_Api.g_exc_unexpected_error;
505: END IF;
506: END IF;
507: END LOOP;

Line 504: RAISE Fnd_Api.g_exc_unexpected_error;

500:
501: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
502: RAISE Fnd_Api.g_exc_error;
503: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
504: RAISE Fnd_Api.g_exc_unexpected_error;
505: END IF;
506: END IF;
507: END LOOP;
508: END IF;

Line 523: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

519: OZF_Disc_Line_PVT.Create_Product_Exclusion(
520: p_api_version_number => p_api_version,
521: p_init_msg_list => p_init_msg_list,
522: p_commit => p_commit,
523: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
524: x_return_status => x_return_status,
525: x_msg_count => x_msg_count,
526: x_msg_data => x_msg_data,
527: p_ozf_excl_rec => l_excl_rec,

Line 530: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

526: x_msg_data => x_msg_data,
527: p_ozf_excl_rec => l_excl_rec,
528: x_off_discount_product_id => l_discount_product_id);
529:
530: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
531: RAISE Fnd_Api.g_exc_error;
532: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
533: RAISE Fnd_Api.g_exc_unexpected_error;
534: END IF;

Line 531: RAISE Fnd_Api.g_exc_error;

527: p_ozf_excl_rec => l_excl_rec,
528: x_off_discount_product_id => l_discount_product_id);
529:
530: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
531: RAISE Fnd_Api.g_exc_error;
532: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
533: RAISE Fnd_Api.g_exc_unexpected_error;
534: END IF;
535: ELSIF p_excl_tbl(i).operation = 'UPDATE' THEN

Line 532: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

528: x_off_discount_product_id => l_discount_product_id);
529:
530: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
531: RAISE Fnd_Api.g_exc_error;
532: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
533: RAISE Fnd_Api.g_exc_unexpected_error;
534: END IF;
535: ELSIF p_excl_tbl(i).operation = 'UPDATE' THEN
536: l_excl_rec.off_discount_product_id := p_excl_tbl(i).off_discount_product_id;

Line 533: RAISE Fnd_Api.g_exc_unexpected_error;

529:
530: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
531: RAISE Fnd_Api.g_exc_error;
532: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
533: RAISE Fnd_Api.g_exc_unexpected_error;
534: END IF;
535: ELSIF p_excl_tbl(i).operation = 'UPDATE' THEN
536: l_excl_rec.off_discount_product_id := p_excl_tbl(i).off_discount_product_id;
537: l_excl_rec.object_version_number := p_excl_tbl(i).object_version_number;

Line 543: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

539: OZF_Disc_Line_PVT.Update_Product_Exclusion(
540: p_api_version_number => p_api_version,
541: p_init_msg_list => p_init_msg_list,
542: p_commit => p_commit,
543: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
544: x_return_status => x_return_status,
545: x_msg_count => x_msg_count,
546: x_msg_data => x_msg_data,
547: p_ozf_excl_rec => l_excl_rec);

Line 549: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

545: x_msg_count => x_msg_count,
546: x_msg_data => x_msg_data,
547: p_ozf_excl_rec => l_excl_rec);
548:
549: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
550: RAISE Fnd_Api.g_exc_error;
551: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
552: RAISE Fnd_Api.g_exc_unexpected_error;
553: END IF;

Line 550: RAISE Fnd_Api.g_exc_error;

546: x_msg_data => x_msg_data,
547: p_ozf_excl_rec => l_excl_rec);
548:
549: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
550: RAISE Fnd_Api.g_exc_error;
551: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
552: RAISE Fnd_Api.g_exc_unexpected_error;
553: END IF;
554: ELSIF p_excl_tbl(i).operation = 'DELETE' THEN

Line 551: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

547: p_ozf_excl_rec => l_excl_rec);
548:
549: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
550: RAISE Fnd_Api.g_exc_error;
551: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
552: RAISE Fnd_Api.g_exc_unexpected_error;
553: END IF;
554: ELSIF p_excl_tbl(i).operation = 'DELETE' THEN
555: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(

Line 552: RAISE Fnd_Api.g_exc_unexpected_error;

548:
549: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
550: RAISE Fnd_Api.g_exc_error;
551: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
552: RAISE Fnd_Api.g_exc_unexpected_error;
553: END IF;
554: ELSIF p_excl_tbl(i).operation = 'DELETE' THEN
555: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(
556: p_api_version_number => p_api_version,

Line 559: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

555: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(
556: p_api_version_number => p_api_version,
557: p_init_msg_list => p_init_msg_list,
558: p_commit => p_commit,
559: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
560: x_return_status => x_return_status,
561: x_msg_count => x_msg_count,
562: x_msg_data => x_msg_data,
563: p_off_discount_product_id => p_excl_tbl(i).off_discount_product_id,

Line 566: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

562: x_msg_data => x_msg_data,
563: p_off_discount_product_id => p_excl_tbl(i).off_discount_product_id,
564: p_object_version_number => p_excl_tbl(i).object_version_number);
565:
566: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
567: RAISE Fnd_Api.g_exc_error;
568: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
569: RAISE Fnd_Api.g_exc_unexpected_error;
570: END IF;

Line 567: RAISE Fnd_Api.g_exc_error;

563: p_off_discount_product_id => p_excl_tbl(i).off_discount_product_id,
564: p_object_version_number => p_excl_tbl(i).object_version_number);
565:
566: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
567: RAISE Fnd_Api.g_exc_error;
568: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
569: RAISE Fnd_Api.g_exc_unexpected_error;
570: END IF;
571: END IF;

Line 568: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

564: p_object_version_number => p_excl_tbl(i).object_version_number);
565:
566: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
567: RAISE Fnd_Api.g_exc_error;
568: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
569: RAISE Fnd_Api.g_exc_unexpected_error;
570: END IF;
571: END IF;
572: END LOOP;

Line 569: RAISE Fnd_Api.g_exc_unexpected_error;

565:
566: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
567: RAISE Fnd_Api.g_exc_error;
568: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
569: RAISE Fnd_Api.g_exc_unexpected_error;
570: END IF;
571: END IF;
572: END LOOP;
573: END IF;

Line 595: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

591: OZF_Disc_Line_PVT.Create_Disc_Tiers(
592: p_api_version_number => p_api_version,
593: p_init_msg_list => p_init_msg_list,
594: p_commit => p_commit,
595: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
596: x_return_status => x_return_status,
597: x_msg_count => x_msg_count,
598: x_msg_data => x_msg_data,
599: p_tier_rec => l_offer_tier_rec,

Line 602: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

598: x_msg_data => x_msg_data,
599: p_tier_rec => l_offer_tier_rec,
600: x_offer_discount_line_id => l_discount_line_id);
601:
602: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
603: RAISE Fnd_Api.g_exc_error;
604: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
605: RAISE Fnd_Api.g_exc_unexpected_error;
606: END IF;

Line 603: RAISE Fnd_Api.g_exc_error;

599: p_tier_rec => l_offer_tier_rec,
600: x_offer_discount_line_id => l_discount_line_id);
601:
602: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
603: RAISE Fnd_Api.g_exc_error;
604: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
605: RAISE Fnd_Api.g_exc_unexpected_error;
606: END IF;
607: ELSIF p_offer_tier_tbl(i).operation = 'UPDATE' THEN

Line 604: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

600: x_offer_discount_line_id => l_discount_line_id);
601:
602: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
603: RAISE Fnd_Api.g_exc_error;
604: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
605: RAISE Fnd_Api.g_exc_unexpected_error;
606: END IF;
607: ELSIF p_offer_tier_tbl(i).operation = 'UPDATE' THEN
608: l_offer_tier_rec.offer_discount_line_id := p_offer_tier_tbl(i).offer_discount_line_id;

Line 605: RAISE Fnd_Api.g_exc_unexpected_error;

601:
602: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
603: RAISE Fnd_Api.g_exc_error;
604: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
605: RAISE Fnd_Api.g_exc_unexpected_error;
606: END IF;
607: ELSIF p_offer_tier_tbl(i).operation = 'UPDATE' THEN
608: l_offer_tier_rec.offer_discount_line_id := p_offer_tier_tbl(i).offer_discount_line_id;
609: l_offer_tier_rec.object_version_number := p_offer_tier_tbl(i).object_version_number;

Line 615: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

611: OZF_Disc_Line_PVT.Update_Disc_Tiers(
612: p_api_version_number => p_api_version,
613: p_init_msg_list => p_init_msg_list,
614: p_commit => p_commit,
615: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
616: x_return_status => x_return_status,
617: x_msg_count => x_msg_count,
618: x_msg_data => x_msg_data,
619: p_tier_rec => l_offer_tier_rec);

Line 621: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

617: x_msg_count => x_msg_count,
618: x_msg_data => x_msg_data,
619: p_tier_rec => l_offer_tier_rec);
620:
621: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
622: RAISE Fnd_Api.g_exc_error;
623: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
624: RAISE Fnd_Api.g_exc_unexpected_error;
625: END IF;

Line 622: RAISE Fnd_Api.g_exc_error;

618: x_msg_data => x_msg_data,
619: p_tier_rec => l_offer_tier_rec);
620:
621: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
622: RAISE Fnd_Api.g_exc_error;
623: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
624: RAISE Fnd_Api.g_exc_unexpected_error;
625: END IF;
626: ELSIF p_offer_tier_tbl(i).operation = 'DELETE' THEN

Line 623: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

619: p_tier_rec => l_offer_tier_rec);
620:
621: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
622: RAISE Fnd_Api.g_exc_error;
623: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
624: RAISE Fnd_Api.g_exc_unexpected_error;
625: END IF;
626: ELSIF p_offer_tier_tbl(i).operation = 'DELETE' THEN
627: IF p_offer_tier_tbl(i).parent_discount_line_id IS NULL OR p_offer_tier_tbl(i).parent_discount_line_id = FND_API.g_miss_num THEN

Line 624: RAISE Fnd_Api.g_exc_unexpected_error;

620:
621: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
622: RAISE Fnd_Api.g_exc_error;
623: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
624: RAISE Fnd_Api.g_exc_unexpected_error;
625: END IF;
626: ELSIF p_offer_tier_tbl(i).operation = 'DELETE' THEN
627: IF p_offer_tier_tbl(i).parent_discount_line_id IS NULL OR p_offer_tier_tbl(i).parent_discount_line_id = FND_API.g_miss_num THEN
628: OZF_Disc_Line_PVT.Delete_Disc_tiers(

Line 627: IF p_offer_tier_tbl(i).parent_discount_line_id IS NULL OR p_offer_tier_tbl(i).parent_discount_line_id = FND_API.g_miss_num THEN

623: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
624: RAISE Fnd_Api.g_exc_unexpected_error;
625: END IF;
626: ELSIF p_offer_tier_tbl(i).operation = 'DELETE' THEN
627: IF p_offer_tier_tbl(i).parent_discount_line_id IS NULL OR p_offer_tier_tbl(i).parent_discount_line_id = FND_API.g_miss_num THEN
628: OZF_Disc_Line_PVT.Delete_Disc_tiers(
629: p_api_version_number => p_api_version,
630: p_init_msg_list => p_init_msg_list,
631: p_commit => p_commit,

Line 632: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

628: OZF_Disc_Line_PVT.Delete_Disc_tiers(
629: p_api_version_number => p_api_version,
630: p_init_msg_list => p_init_msg_list,
631: p_commit => p_commit,
632: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
633: x_return_status => x_return_status,
634: x_msg_count => x_msg_count,
635: x_msg_data => x_msg_data,
636: p_parent_discount_line_id => p_offer_tier_tbl(i).offer_discount_line_id);

Line 638: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

634: x_msg_count => x_msg_count,
635: x_msg_data => x_msg_data,
636: p_parent_discount_line_id => p_offer_tier_tbl(i).offer_discount_line_id);
637:
638: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
639: RAISE Fnd_Api.g_exc_error;
640: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
641: RAISE Fnd_Api.g_exc_unexpected_error;
642: END IF;

Line 639: RAISE Fnd_Api.g_exc_error;

635: x_msg_data => x_msg_data,
636: p_parent_discount_line_id => p_offer_tier_tbl(i).offer_discount_line_id);
637:
638: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
639: RAISE Fnd_Api.g_exc_error;
640: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
641: RAISE Fnd_Api.g_exc_unexpected_error;
642: END IF;
643: ELSE

Line 640: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

636: p_parent_discount_line_id => p_offer_tier_tbl(i).offer_discount_line_id);
637:
638: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
639: RAISE Fnd_Api.g_exc_error;
640: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
641: RAISE Fnd_Api.g_exc_unexpected_error;
642: END IF;
643: ELSE
644: OZF_Disc_Line_PVT.Delete_Tier_line(

Line 641: RAISE Fnd_Api.g_exc_unexpected_error;

637:
638: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
639: RAISE Fnd_Api.g_exc_error;
640: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
641: RAISE Fnd_Api.g_exc_unexpected_error;
642: END IF;
643: ELSE
644: OZF_Disc_Line_PVT.Delete_Tier_line(
645: p_api_version_number => p_api_version,

Line 648: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

644: OZF_Disc_Line_PVT.Delete_Tier_line(
645: p_api_version_number => p_api_version,
646: p_init_msg_list => p_init_msg_list,
647: p_commit => p_commit,
648: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
649: x_return_status => x_return_status,
650: x_msg_count => x_msg_count,
651: x_msg_data => x_msg_data,
652: p_offer_discount_line_id => p_offer_tier_tbl(i).offer_discount_line_id,

Line 655: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

651: x_msg_data => x_msg_data,
652: p_offer_discount_line_id => p_offer_tier_tbl(i).offer_discount_line_id,
653: p_object_version_number => p_offer_tier_tbl(i).object_version_number);
654:
655: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
656: RAISE Fnd_Api.g_exc_error;
657: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
658: RAISE Fnd_Api.g_exc_unexpected_error;
659: END IF;

Line 656: RAISE Fnd_Api.g_exc_error;

652: p_offer_discount_line_id => p_offer_tier_tbl(i).offer_discount_line_id,
653: p_object_version_number => p_offer_tier_tbl(i).object_version_number);
654:
655: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
656: RAISE Fnd_Api.g_exc_error;
657: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
658: RAISE Fnd_Api.g_exc_unexpected_error;
659: END IF;
660: END IF;

Line 657: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

653: p_object_version_number => p_offer_tier_tbl(i).object_version_number);
654:
655: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
656: RAISE Fnd_Api.g_exc_error;
657: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
658: RAISE Fnd_Api.g_exc_unexpected_error;
659: END IF;
660: END IF;
661: END IF;

Line 658: RAISE Fnd_Api.g_exc_unexpected_error;

654:
655: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
656: RAISE Fnd_Api.g_exc_error;
657: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
658: RAISE Fnd_Api.g_exc_unexpected_error;
659: END IF;
660: END IF;
661: END IF;
662: END LOOP;

Line 677: IF p_prod_tbl(i).offer_id IS NULL OR p_prod_tbl(i).offer_id = FND_API.g_miss_num THEN

673: l_prod_rec.end_date_active := p_prod_tbl(i).end_date_active;
674: l_prod_rec.offer_discount_line_id := p_prod_tbl(i).offer_discount_line_id;
675:
676: IF p_prod_tbl(i).operation = 'CREATE' THEN
677: IF p_prod_tbl(i).offer_id IS NULL OR p_prod_tbl(i).offer_id = FND_API.g_miss_num THEN
678: l_prod_rec.offer_id := l_offer_id;
679: ELSE
680: l_prod_rec.offer_id := p_prod_tbl(i).offer_id;
681: END IF;

Line 687: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

683: OZF_Disc_Line_PVT.Create_Ozf_Prod_Line(
684: p_api_version_number => p_api_version,
685: p_init_msg_list => p_init_msg_list,
686: p_commit => p_commit,
687: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
688: x_return_status => x_return_status,
689: x_msg_count => x_msg_count,
690: x_msg_data => x_msg_data,
691: p_ozf_prod_rec => l_prod_rec,

Line 694: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

690: x_msg_data => x_msg_data,
691: p_ozf_prod_rec => l_prod_rec,
692: x_off_discount_product_id => l_discount_product_id);
693:
694: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
695: RAISE Fnd_Api.g_exc_error;
696: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
697: RAISE Fnd_Api.g_exc_unexpected_error;
698: END IF;

Line 695: RAISE Fnd_Api.g_exc_error;

691: p_ozf_prod_rec => l_prod_rec,
692: x_off_discount_product_id => l_discount_product_id);
693:
694: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
695: RAISE Fnd_Api.g_exc_error;
696: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
697: RAISE Fnd_Api.g_exc_unexpected_error;
698: END IF;
699: ELSIF p_prod_tbl(i).operation = 'UPDATE' THEN

Line 696: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

692: x_off_discount_product_id => l_discount_product_id);
693:
694: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
695: RAISE Fnd_Api.g_exc_error;
696: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
697: RAISE Fnd_Api.g_exc_unexpected_error;
698: END IF;
699: ELSIF p_prod_tbl(i).operation = 'UPDATE' THEN
700: l_prod_rec.off_discount_product_id := p_prod_tbl(i).off_discount_product_id;

Line 697: RAISE Fnd_Api.g_exc_unexpected_error;

693:
694: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
695: RAISE Fnd_Api.g_exc_error;
696: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
697: RAISE Fnd_Api.g_exc_unexpected_error;
698: END IF;
699: ELSIF p_prod_tbl(i).operation = 'UPDATE' THEN
700: l_prod_rec.off_discount_product_id := p_prod_tbl(i).off_discount_product_id;
701: l_prod_rec.offer_id := p_prod_tbl(i).offer_id;

Line 708: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

704: OZF_Disc_Line_PVT.Update_Ozf_Prod_Line(
705: p_api_version_number => p_api_version,
706: p_init_msg_list => p_init_msg_list,
707: p_commit => p_commit,
708: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
709: x_return_status => x_return_status,
710: x_msg_count => x_msg_count,
711: x_msg_data => x_msg_data,
712: p_ozf_prod_rec => l_prod_rec);

Line 714: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

710: x_msg_count => x_msg_count,
711: x_msg_data => x_msg_data,
712: p_ozf_prod_rec => l_prod_rec);
713:
714: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
715: RAISE Fnd_Api.g_exc_error;
716: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
717: RAISE Fnd_Api.g_exc_unexpected_error;
718: END IF;

Line 715: RAISE Fnd_Api.g_exc_error;

711: x_msg_data => x_msg_data,
712: p_ozf_prod_rec => l_prod_rec);
713:
714: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
715: RAISE Fnd_Api.g_exc_error;
716: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
717: RAISE Fnd_Api.g_exc_unexpected_error;
718: END IF;
719: ELSIF p_prod_tbl(i).operation = 'DELETE' THEN

Line 716: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

712: p_ozf_prod_rec => l_prod_rec);
713:
714: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
715: RAISE Fnd_Api.g_exc_error;
716: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
717: RAISE Fnd_Api.g_exc_unexpected_error;
718: END IF;
719: ELSIF p_prod_tbl(i).operation = 'DELETE' THEN
720: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(

Line 717: RAISE Fnd_Api.g_exc_unexpected_error;

713:
714: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
715: RAISE Fnd_Api.g_exc_error;
716: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
717: RAISE Fnd_Api.g_exc_unexpected_error;
718: END IF;
719: ELSIF p_prod_tbl(i).operation = 'DELETE' THEN
720: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(
721: p_api_version_number => p_api_version,

Line 724: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

720: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(
721: p_api_version_number => p_api_version,
722: p_init_msg_list => p_init_msg_list,
723: p_commit => p_commit,
724: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
725: x_return_status => x_return_status,
726: x_msg_count => x_msg_count,
727: x_msg_data => x_msg_data,
728: p_off_discount_product_id => p_prod_tbl(i).off_discount_product_id,

Line 731: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

727: x_msg_data => x_msg_data,
728: p_off_discount_product_id => p_prod_tbl(i).off_discount_product_id,
729: p_object_version_number => p_prod_tbl(i).object_version_number);
730:
731: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
732: RAISE Fnd_Api.g_exc_error;
733: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
734: RAISE Fnd_Api.g_exc_unexpected_error;
735: END IF;

Line 732: RAISE Fnd_Api.g_exc_error;

728: p_off_discount_product_id => p_prod_tbl(i).off_discount_product_id,
729: p_object_version_number => p_prod_tbl(i).object_version_number);
730:
731: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
732: RAISE Fnd_Api.g_exc_error;
733: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
734: RAISE Fnd_Api.g_exc_unexpected_error;
735: END IF;
736: END IF;

Line 733: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

729: p_object_version_number => p_prod_tbl(i).object_version_number);
730:
731: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
732: RAISE Fnd_Api.g_exc_error;
733: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
734: RAISE Fnd_Api.g_exc_unexpected_error;
735: END IF;
736: END IF;
737: END LOOP;

Line 734: RAISE Fnd_Api.g_exc_unexpected_error;

730:
731: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
732: RAISE Fnd_Api.g_exc_error;
733: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
734: RAISE Fnd_Api.g_exc_unexpected_error;
735: END IF;
736: END IF;
737: END LOOP;
738: END IF;

Line 754: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

750: OZF_Disc_Line_PVT.Create_Product_Exclusion(
751: p_api_version_number => p_api_version,
752: p_init_msg_list => p_init_msg_list,
753: p_commit => p_commit,
754: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
755: x_return_status => x_return_status,
756: x_msg_count => x_msg_count,
757: x_msg_data => x_msg_data,
758: p_ozf_excl_rec => l_excl_rec,

Line 761: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

757: x_msg_data => x_msg_data,
758: p_ozf_excl_rec => l_excl_rec,
759: x_off_discount_product_id => l_discount_product_id);
760:
761: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
762: RAISE Fnd_Api.g_exc_error;
763: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
764: RAISE Fnd_Api.g_exc_unexpected_error;
765: END IF;

Line 762: RAISE Fnd_Api.g_exc_error;

758: p_ozf_excl_rec => l_excl_rec,
759: x_off_discount_product_id => l_discount_product_id);
760:
761: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
762: RAISE Fnd_Api.g_exc_error;
763: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
764: RAISE Fnd_Api.g_exc_unexpected_error;
765: END IF;
766: ELSIF p_excl_tbl(i).operation = 'UPDATE' THEN

Line 763: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

759: x_off_discount_product_id => l_discount_product_id);
760:
761: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
762: RAISE Fnd_Api.g_exc_error;
763: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
764: RAISE Fnd_Api.g_exc_unexpected_error;
765: END IF;
766: ELSIF p_excl_tbl(i).operation = 'UPDATE' THEN
767: l_excl_rec.off_discount_product_id := p_excl_tbl(i).off_discount_product_id;

Line 764: RAISE Fnd_Api.g_exc_unexpected_error;

760:
761: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
762: RAISE Fnd_Api.g_exc_error;
763: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
764: RAISE Fnd_Api.g_exc_unexpected_error;
765: END IF;
766: ELSIF p_excl_tbl(i).operation = 'UPDATE' THEN
767: l_excl_rec.off_discount_product_id := p_excl_tbl(i).off_discount_product_id;
768: l_excl_rec.object_version_number := p_excl_tbl(i).object_version_number;

Line 774: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

770: OZF_Disc_Line_PVT.Update_Product_Exclusion(
771: p_api_version_number => p_api_version,
772: p_init_msg_list => p_init_msg_list,
773: p_commit => p_commit,
774: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
775: x_return_status => x_return_status,
776: x_msg_count => x_msg_count,
777: x_msg_data => x_msg_data,
778: p_ozf_excl_rec => l_excl_rec);

Line 780: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

776: x_msg_count => x_msg_count,
777: x_msg_data => x_msg_data,
778: p_ozf_excl_rec => l_excl_rec);
779:
780: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
781: RAISE Fnd_Api.g_exc_error;
782: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
783: RAISE Fnd_Api.g_exc_unexpected_error;
784: END IF;

Line 781: RAISE Fnd_Api.g_exc_error;

777: x_msg_data => x_msg_data,
778: p_ozf_excl_rec => l_excl_rec);
779:
780: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
781: RAISE Fnd_Api.g_exc_error;
782: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
783: RAISE Fnd_Api.g_exc_unexpected_error;
784: END IF;
785: ELSIF p_excl_tbl(i).operation = 'DELETE' THEN

Line 782: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

778: p_ozf_excl_rec => l_excl_rec);
779:
780: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
781: RAISE Fnd_Api.g_exc_error;
782: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
783: RAISE Fnd_Api.g_exc_unexpected_error;
784: END IF;
785: ELSIF p_excl_tbl(i).operation = 'DELETE' THEN
786: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(

Line 783: RAISE Fnd_Api.g_exc_unexpected_error;

779:
780: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
781: RAISE Fnd_Api.g_exc_error;
782: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
783: RAISE Fnd_Api.g_exc_unexpected_error;
784: END IF;
785: ELSIF p_excl_tbl(i).operation = 'DELETE' THEN
786: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(
787: p_api_version_number => p_api_version,

Line 790: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

786: OZF_Disc_Line_PVT.Delete_Ozf_Prod_Line(
787: p_api_version_number => p_api_version,
788: p_init_msg_list => p_init_msg_list,
789: p_commit => p_commit,
790: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
791: x_return_status => x_return_status,
792: x_msg_count => x_msg_count,
793: x_msg_data => x_msg_data,
794: p_off_discount_product_id => p_excl_tbl(i).off_discount_product_id,

Line 797: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

793: x_msg_data => x_msg_data,
794: p_off_discount_product_id => p_excl_tbl(i).off_discount_product_id,
795: p_object_version_number => p_excl_tbl(i).object_version_number);
796:
797: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
798: RAISE Fnd_Api.g_exc_error;
799: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
800: RAISE Fnd_Api.g_exc_unexpected_error;
801: END IF;

Line 798: RAISE Fnd_Api.g_exc_error;

794: p_off_discount_product_id => p_excl_tbl(i).off_discount_product_id,
795: p_object_version_number => p_excl_tbl(i).object_version_number);
796:
797: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
798: RAISE Fnd_Api.g_exc_error;
799: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
800: RAISE Fnd_Api.g_exc_unexpected_error;
801: END IF;
802: END IF;

Line 799: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

795: p_object_version_number => p_excl_tbl(i).object_version_number);
796:
797: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
798: RAISE Fnd_Api.g_exc_error;
799: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
800: RAISE Fnd_Api.g_exc_unexpected_error;
801: END IF;
802: END IF;
803: END LOOP;

Line 800: RAISE Fnd_Api.g_exc_unexpected_error;

796:
797: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
798: RAISE Fnd_Api.g_exc_error;
799: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
800: RAISE Fnd_Api.g_exc_unexpected_error;
801: END IF;
802: END IF;
803: END LOOP;
804: END IF;

Line 826: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

822: OZF_Disc_Line_PVT.Create_Disc_Tiers(
823: p_api_version_number => p_api_version,
824: p_init_msg_list => p_init_msg_list,
825: p_commit => p_commit,
826: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
827: x_return_status => x_return_status,
828: x_msg_count => x_msg_count,
829: x_msg_data => x_msg_data,
830: p_tier_rec => l_offer_tier_rec,

Line 833: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

829: x_msg_data => x_msg_data,
830: p_tier_rec => l_offer_tier_rec,
831: x_offer_discount_line_id => l_discount_line_id);
832:
833: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
834: RAISE Fnd_Api.g_exc_error;
835: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
836: RAISE Fnd_Api.g_exc_unexpected_error;
837: END IF;

Line 834: RAISE Fnd_Api.g_exc_error;

830: p_tier_rec => l_offer_tier_rec,
831: x_offer_discount_line_id => l_discount_line_id);
832:
833: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
834: RAISE Fnd_Api.g_exc_error;
835: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
836: RAISE Fnd_Api.g_exc_unexpected_error;
837: END IF;
838: ELSIF p_offer_tier_tbl(i).operation = 'UPDATE' THEN

Line 835: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

831: x_offer_discount_line_id => l_discount_line_id);
832:
833: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
834: RAISE Fnd_Api.g_exc_error;
835: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
836: RAISE Fnd_Api.g_exc_unexpected_error;
837: END IF;
838: ELSIF p_offer_tier_tbl(i).operation = 'UPDATE' THEN
839: l_offer_tier_rec.offer_discount_line_id := p_offer_tier_tbl(i).offer_discount_line_id;

Line 836: RAISE Fnd_Api.g_exc_unexpected_error;

832:
833: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
834: RAISE Fnd_Api.g_exc_error;
835: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
836: RAISE Fnd_Api.g_exc_unexpected_error;
837: END IF;
838: ELSIF p_offer_tier_tbl(i).operation = 'UPDATE' THEN
839: l_offer_tier_rec.offer_discount_line_id := p_offer_tier_tbl(i).offer_discount_line_id;
840: l_offer_tier_rec.object_version_number := p_offer_tier_tbl(i).object_version_number;

Line 846: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

842: OZF_Disc_Line_PVT.Update_Disc_Tiers(
843: p_api_version_number => p_api_version,
844: p_init_msg_list => p_init_msg_list,
845: p_commit => p_commit,
846: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
847: x_return_status => x_return_status,
848: x_msg_count => x_msg_count,
849: x_msg_data => x_msg_data,
850: p_tier_rec => l_offer_tier_rec);

Line 852: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

848: x_msg_count => x_msg_count,
849: x_msg_data => x_msg_data,
850: p_tier_rec => l_offer_tier_rec);
851:
852: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
853: RAISE Fnd_Api.g_exc_error;
854: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
855: RAISE Fnd_Api.g_exc_unexpected_error;
856: END IF;

Line 853: RAISE Fnd_Api.g_exc_error;

849: x_msg_data => x_msg_data,
850: p_tier_rec => l_offer_tier_rec);
851:
852: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
853: RAISE Fnd_Api.g_exc_error;
854: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
855: RAISE Fnd_Api.g_exc_unexpected_error;
856: END IF;
857: ELSIF p_offer_tier_tbl(i).operation = 'DELETE' THEN

Line 854: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

850: p_tier_rec => l_offer_tier_rec);
851:
852: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
853: RAISE Fnd_Api.g_exc_error;
854: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
855: RAISE Fnd_Api.g_exc_unexpected_error;
856: END IF;
857: ELSIF p_offer_tier_tbl(i).operation = 'DELETE' THEN
858: IF p_offer_tier_tbl(i).parent_discount_line_id IS NULL OR p_offer_tier_tbl(i).parent_discount_line_id = FND_API.g_miss_num THEN

Line 855: RAISE Fnd_Api.g_exc_unexpected_error;

851:
852: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
853: RAISE Fnd_Api.g_exc_error;
854: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
855: RAISE Fnd_Api.g_exc_unexpected_error;
856: END IF;
857: ELSIF p_offer_tier_tbl(i).operation = 'DELETE' THEN
858: IF p_offer_tier_tbl(i).parent_discount_line_id IS NULL OR p_offer_tier_tbl(i).parent_discount_line_id = FND_API.g_miss_num THEN
859: OZF_Disc_Line_PVT.Delete_Disc_tiers(

Line 858: IF p_offer_tier_tbl(i).parent_discount_line_id IS NULL OR p_offer_tier_tbl(i).parent_discount_line_id = FND_API.g_miss_num THEN

854: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
855: RAISE Fnd_Api.g_exc_unexpected_error;
856: END IF;
857: ELSIF p_offer_tier_tbl(i).operation = 'DELETE' THEN
858: IF p_offer_tier_tbl(i).parent_discount_line_id IS NULL OR p_offer_tier_tbl(i).parent_discount_line_id = FND_API.g_miss_num THEN
859: OZF_Disc_Line_PVT.Delete_Disc_tiers(
860: p_api_version_number => p_api_version,
861: p_init_msg_list => p_init_msg_list,
862: p_commit => p_commit,

Line 863: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

859: OZF_Disc_Line_PVT.Delete_Disc_tiers(
860: p_api_version_number => p_api_version,
861: p_init_msg_list => p_init_msg_list,
862: p_commit => p_commit,
863: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
864: x_return_status => x_return_status,
865: x_msg_count => x_msg_count,
866: x_msg_data => x_msg_data,
867: p_parent_discount_line_id => p_offer_tier_tbl(i).offer_discount_line_id);

Line 869: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

865: x_msg_count => x_msg_count,
866: x_msg_data => x_msg_data,
867: p_parent_discount_line_id => p_offer_tier_tbl(i).offer_discount_line_id);
868:
869: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
870: RAISE Fnd_Api.g_exc_error;
871: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
872: RAISE Fnd_Api.g_exc_unexpected_error;
873: END IF;

Line 870: RAISE Fnd_Api.g_exc_error;

866: x_msg_data => x_msg_data,
867: p_parent_discount_line_id => p_offer_tier_tbl(i).offer_discount_line_id);
868:
869: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
870: RAISE Fnd_Api.g_exc_error;
871: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
872: RAISE Fnd_Api.g_exc_unexpected_error;
873: END IF;
874: ELSE

Line 871: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

867: p_parent_discount_line_id => p_offer_tier_tbl(i).offer_discount_line_id);
868:
869: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
870: RAISE Fnd_Api.g_exc_error;
871: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
872: RAISE Fnd_Api.g_exc_unexpected_error;
873: END IF;
874: ELSE
875: OZF_Disc_Line_PVT.Delete_Tier_line(

Line 872: RAISE Fnd_Api.g_exc_unexpected_error;

868:
869: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
870: RAISE Fnd_Api.g_exc_error;
871: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
872: RAISE Fnd_Api.g_exc_unexpected_error;
873: END IF;
874: ELSE
875: OZF_Disc_Line_PVT.Delete_Tier_line(
876: p_api_version_number => p_api_version,

Line 879: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

875: OZF_Disc_Line_PVT.Delete_Tier_line(
876: p_api_version_number => p_api_version,
877: p_init_msg_list => p_init_msg_list,
878: p_commit => p_commit,
879: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
880: x_return_status => x_return_status,
881: x_msg_count => x_msg_count,
882: x_msg_data => x_msg_data,
883: p_offer_discount_line_id => p_offer_tier_tbl(i).offer_discount_line_id,

Line 886: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

882: x_msg_data => x_msg_data,
883: p_offer_discount_line_id => p_offer_tier_tbl(i).offer_discount_line_id,
884: p_object_version_number => p_offer_tier_tbl(i).object_version_number);
885:
886: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
887: RAISE Fnd_Api.g_exc_error;
888: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
889: RAISE Fnd_Api.g_exc_unexpected_error;
890: END IF;

Line 887: RAISE Fnd_Api.g_exc_error;

883: p_offer_discount_line_id => p_offer_tier_tbl(i).offer_discount_line_id,
884: p_object_version_number => p_offer_tier_tbl(i).object_version_number);
885:
886: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
887: RAISE Fnd_Api.g_exc_error;
888: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
889: RAISE Fnd_Api.g_exc_unexpected_error;
890: END IF;
891: END IF;

Line 888: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

884: p_object_version_number => p_offer_tier_tbl(i).object_version_number);
885:
886: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
887: RAISE Fnd_Api.g_exc_error;
888: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
889: RAISE Fnd_Api.g_exc_unexpected_error;
890: END IF;
891: END IF;
892: END IF;

Line 889: RAISE Fnd_Api.g_exc_unexpected_error;

885:
886: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
887: RAISE Fnd_Api.g_exc_error;
888: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
889: RAISE Fnd_Api.g_exc_unexpected_error;
890: END IF;
891: END IF;
892: END IF;
893: END LOOP;

Line 910: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

906: ,p_modifier_line_tbl => l_modifier_line_tbl
907: ,x_qp_list_header_id => l_dummy
908: ,x_error_location => x_error_location);
909:
910: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
911: RAISE Fnd_Api.g_exc_error;
912: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
913: RAISE Fnd_Api.g_exc_unexpected_error;
914: END IF;

Line 911: RAISE Fnd_Api.g_exc_error;

907: ,x_qp_list_header_id => l_dummy
908: ,x_error_location => x_error_location);
909:
910: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
911: RAISE Fnd_Api.g_exc_error;
912: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
913: RAISE Fnd_Api.g_exc_unexpected_error;
914: END IF;
915:

Line 912: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

908: ,x_error_location => x_error_location);
909:
910: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
911: RAISE Fnd_Api.g_exc_error;
912: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
913: RAISE Fnd_Api.g_exc_unexpected_error;
914: END IF;
915:
916: -- process qualifier

Line 913: RAISE Fnd_Api.g_exc_unexpected_error;

909:
910: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
911: RAISE Fnd_Api.g_exc_error;
912: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
913: RAISE Fnd_Api.g_exc_unexpected_error;
914: END IF;
915:
916: -- process qualifier
917: IF p_offer_type = 'NET_ACCRUAL' THEN

Line 957: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

953: OZF_Offr_Qual_PVT.Create_Offr_Qual(
954: p_api_version_number => p_api_version,
955: p_init_msg_list => p_init_msg_list,
956: p_commit => p_commit,
957: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
958: x_return_status => x_return_status,
959: x_msg_count => x_msg_count,
960: x_msg_data => x_msg_data,
961: p_ozf_offr_qual_rec => l_na_qualifier_rec,

Line 964: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

960: x_msg_data => x_msg_data,
961: p_ozf_offr_qual_rec => l_na_qualifier_rec,
962: x_qualifier_id => l_na_qualifier_id);
963:
964: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
965: RAISE Fnd_Api.g_exc_error;
966: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
967: RAISE Fnd_Api.g_exc_unexpected_error;
968: END IF;

Line 965: RAISE Fnd_Api.g_exc_error;

961: p_ozf_offr_qual_rec => l_na_qualifier_rec,
962: x_qualifier_id => l_na_qualifier_id);
963:
964: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
965: RAISE Fnd_Api.g_exc_error;
966: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
967: RAISE Fnd_Api.g_exc_unexpected_error;
968: END IF;
969: ELSIF p_na_qualifier_tbl(i).operation = 'UPDATE' THEN

Line 966: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

962: x_qualifier_id => l_na_qualifier_id);
963:
964: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
965: RAISE Fnd_Api.g_exc_error;
966: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
967: RAISE Fnd_Api.g_exc_unexpected_error;
968: END IF;
969: ELSIF p_na_qualifier_tbl(i).operation = 'UPDATE' THEN
970: OZF_Offr_Qual_PVT.Update_Offr_Qual(

Line 967: RAISE Fnd_Api.g_exc_unexpected_error;

963:
964: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
965: RAISE Fnd_Api.g_exc_error;
966: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
967: RAISE Fnd_Api.g_exc_unexpected_error;
968: END IF;
969: ELSIF p_na_qualifier_tbl(i).operation = 'UPDATE' THEN
970: OZF_Offr_Qual_PVT.Update_Offr_Qual(
971: p_api_version_number => p_api_version,

Line 974: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

970: OZF_Offr_Qual_PVT.Update_Offr_Qual(
971: p_api_version_number => p_api_version,
972: p_init_msg_list => p_init_msg_list,
973: p_commit => p_commit,
974: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
975: x_return_status => x_return_status,
976: x_msg_count => x_msg_count,
977: x_msg_data => x_msg_data,
978: p_ozf_offr_qual_rec => l_na_qualifier_rec);

Line 980: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

976: x_msg_count => x_msg_count,
977: x_msg_data => x_msg_data,
978: p_ozf_offr_qual_rec => l_na_qualifier_rec);
979:
980: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
981: RAISE Fnd_Api.g_exc_error;
982: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
983: RAISE Fnd_Api.g_exc_unexpected_error;
984: END IF;

Line 981: RAISE Fnd_Api.g_exc_error;

977: x_msg_data => x_msg_data,
978: p_ozf_offr_qual_rec => l_na_qualifier_rec);
979:
980: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
981: RAISE Fnd_Api.g_exc_error;
982: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
983: RAISE Fnd_Api.g_exc_unexpected_error;
984: END IF;
985: ELSIF p_na_qualifier_tbl(i).operation = 'DELETE' THEN

Line 982: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

978: p_ozf_offr_qual_rec => l_na_qualifier_rec);
979:
980: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
981: RAISE Fnd_Api.g_exc_error;
982: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
983: RAISE Fnd_Api.g_exc_unexpected_error;
984: END IF;
985: ELSIF p_na_qualifier_tbl(i).operation = 'DELETE' THEN
986: OZF_Offr_Qual_PVT.Delete_Offr_Qual(

Line 983: RAISE Fnd_Api.g_exc_unexpected_error;

979:
980: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
981: RAISE Fnd_Api.g_exc_error;
982: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
983: RAISE Fnd_Api.g_exc_unexpected_error;
984: END IF;
985: ELSIF p_na_qualifier_tbl(i).operation = 'DELETE' THEN
986: OZF_Offr_Qual_PVT.Delete_Offr_Qual(
987: p_api_version_number => p_api_version,

Line 990: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

986: OZF_Offr_Qual_PVT.Delete_Offr_Qual(
987: p_api_version_number => p_api_version,
988: p_init_msg_list => p_init_msg_list,
989: p_commit => p_commit,
990: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
991: x_return_status => x_return_status,
992: x_msg_count => x_msg_count,
993: x_msg_data => x_msg_data,
994: p_qualifier_id => l_na_qualifier_rec.qualifier_id,

Line 997: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

993: x_msg_data => x_msg_data,
994: p_qualifier_id => l_na_qualifier_rec.qualifier_id,
995: p_object_version_number => l_na_qualifier_rec.object_version_number);
996:
997: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
998: RAISE Fnd_Api.g_exc_error;
999: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1000: RAISE Fnd_Api.g_exc_unexpected_error;
1001: END IF;

Line 998: RAISE Fnd_Api.g_exc_error;

994: p_qualifier_id => l_na_qualifier_rec.qualifier_id,
995: p_object_version_number => l_na_qualifier_rec.object_version_number);
996:
997: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
998: RAISE Fnd_Api.g_exc_error;
999: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1000: RAISE Fnd_Api.g_exc_unexpected_error;
1001: END IF;
1002: END IF;

Line 999: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

995: p_object_version_number => l_na_qualifier_rec.object_version_number);
996:
997: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
998: RAISE Fnd_Api.g_exc_error;
999: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1000: RAISE Fnd_Api.g_exc_unexpected_error;
1001: END IF;
1002: END IF;
1003: END LOOP;

Line 1000: RAISE Fnd_Api.g_exc_unexpected_error;

996:
997: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
998: RAISE Fnd_Api.g_exc_error;
999: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1000: RAISE Fnd_Api.g_exc_unexpected_error;
1001: END IF;
1002: END IF;
1003: END LOOP;
1004: END IF;

Line 1049: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1045: ,x_msg_data => x_msg_data
1046: ,p_qualifiers_tbl => l_qualifiers_tbl
1047: ,x_error_location => x_error_location
1048: ,x_qualifiers_tbl => l_qualifiers_tbl_out);
1049: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1050: RAISE Fnd_Api.g_exc_error;
1051: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1052: RAISE Fnd_Api.g_exc_unexpected_error;
1053: END IF;

Line 1050: RAISE Fnd_Api.g_exc_error;

1046: ,p_qualifiers_tbl => l_qualifiers_tbl
1047: ,x_error_location => x_error_location
1048: ,x_qualifiers_tbl => l_qualifiers_tbl_out);
1049: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1050: RAISE Fnd_Api.g_exc_error;
1051: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1052: RAISE Fnd_Api.g_exc_unexpected_error;
1053: END IF;
1054: END IF;

Line 1051: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1047: ,x_error_location => x_error_location
1048: ,x_qualifiers_tbl => l_qualifiers_tbl_out);
1049: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1050: RAISE Fnd_Api.g_exc_error;
1051: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1052: RAISE Fnd_Api.g_exc_unexpected_error;
1053: END IF;
1054: END IF;
1055: END IF;

Line 1052: RAISE Fnd_Api.g_exc_unexpected_error;

1048: ,x_qualifiers_tbl => l_qualifiers_tbl_out);
1049: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1050: RAISE Fnd_Api.g_exc_error;
1051: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1052: RAISE Fnd_Api.g_exc_unexpected_error;
1053: END IF;
1054: END IF;
1055: END IF;
1056:

Line 1079: ,p_validation_level => Fnd_Api.g_valid_level_full

1075: Ozf_Actbudgets_Pvt.create_act_budgets(
1076: p_api_version => p_api_version
1077: ,p_init_msg_list => p_init_msg_list
1078: ,p_commit => p_commit
1079: ,p_validation_level => Fnd_Api.g_valid_level_full
1080: ,x_return_status => x_return_status
1081: ,x_msg_count => x_msg_count
1082: ,x_msg_data => x_msg_data
1083: ,p_act_budgets_rec => l_act_budgets_rec

Line 1086: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1082: ,x_msg_data => x_msg_data
1083: ,p_act_budgets_rec => l_act_budgets_rec
1084: ,x_act_budget_id => l_activity_budget_id);
1085:
1086: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1087: RAISE Fnd_Api.g_exc_error;
1088: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1089: RAISE Fnd_Api.g_exc_unexpected_error;
1090: END IF;

Line 1087: RAISE Fnd_Api.g_exc_error;

1083: ,p_act_budgets_rec => l_act_budgets_rec
1084: ,x_act_budget_id => l_activity_budget_id);
1085:
1086: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1087: RAISE Fnd_Api.g_exc_error;
1088: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1089: RAISE Fnd_Api.g_exc_unexpected_error;
1090: END IF;
1091: ELSIF p_budget_tbl(i).operation = 'UPDATE' THEN

Line 1088: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1084: ,x_act_budget_id => l_activity_budget_id);
1085:
1086: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1087: RAISE Fnd_Api.g_exc_error;
1088: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1089: RAISE Fnd_Api.g_exc_unexpected_error;
1090: END IF;
1091: ELSIF p_budget_tbl(i).operation = 'UPDATE' THEN
1092: Ozf_Actbudgets_Pvt.update_act_budgets(

Line 1089: RAISE Fnd_Api.g_exc_unexpected_error;

1085:
1086: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1087: RAISE Fnd_Api.g_exc_error;
1088: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1089: RAISE Fnd_Api.g_exc_unexpected_error;
1090: END IF;
1091: ELSIF p_budget_tbl(i).operation = 'UPDATE' THEN
1092: Ozf_Actbudgets_Pvt.update_act_budgets(
1093: p_api_version => p_api_version

Line 1096: ,p_validation_level => Fnd_Api.g_valid_level_full

1092: Ozf_Actbudgets_Pvt.update_act_budgets(
1093: p_api_version => p_api_version
1094: ,p_init_msg_list => p_init_msg_list
1095: ,p_commit => p_commit
1096: ,p_validation_level => Fnd_Api.g_valid_level_full
1097: ,x_return_status => x_return_status
1098: ,x_msg_count => x_msg_count
1099: ,x_msg_data => x_msg_data
1100: ,p_act_budgets_rec => l_act_budgets_rec);

Line 1102: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1098: ,x_msg_count => x_msg_count
1099: ,x_msg_data => x_msg_data
1100: ,p_act_budgets_rec => l_act_budgets_rec);
1101:
1102: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1103: RAISE Fnd_Api.g_exc_error;
1104: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1105: RAISE Fnd_Api.g_exc_unexpected_error;
1106: END IF;

Line 1103: RAISE Fnd_Api.g_exc_error;

1099: ,x_msg_data => x_msg_data
1100: ,p_act_budgets_rec => l_act_budgets_rec);
1101:
1102: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1103: RAISE Fnd_Api.g_exc_error;
1104: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1105: RAISE Fnd_Api.g_exc_unexpected_error;
1106: END IF;
1107: ELSIF p_budget_tbl(i).operation = 'DELETE' THEN

Line 1104: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1100: ,p_act_budgets_rec => l_act_budgets_rec);
1101:
1102: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1103: RAISE Fnd_Api.g_exc_error;
1104: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1105: RAISE Fnd_Api.g_exc_unexpected_error;
1106: END IF;
1107: ELSIF p_budget_tbl(i).operation = 'DELETE' THEN
1108: Ozf_Actbudgets_Pvt.delete_act_budgets(

Line 1105: RAISE Fnd_Api.g_exc_unexpected_error;

1101:
1102: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1103: RAISE Fnd_Api.g_exc_error;
1104: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1105: RAISE Fnd_Api.g_exc_unexpected_error;
1106: END IF;
1107: ELSIF p_budget_tbl(i).operation = 'DELETE' THEN
1108: Ozf_Actbudgets_Pvt.delete_act_budgets(
1109: p_api_version => p_api_version

Line 1112: ,p_validation_level => Fnd_Api.g_valid_level_full

1108: Ozf_Actbudgets_Pvt.delete_act_budgets(
1109: p_api_version => p_api_version
1110: ,p_init_msg_list => p_init_msg_list
1111: ,p_commit => p_commit
1112: ,p_validation_level => Fnd_Api.g_valid_level_full
1113: ,x_return_status => x_return_status
1114: ,x_msg_count => x_msg_count
1115: ,x_msg_data => x_msg_data
1116: ,p_act_budget_id => l_act_budgets_rec.activity_budget_id

Line 1119: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1115: ,x_msg_data => x_msg_data
1116: ,p_act_budget_id => l_act_budgets_rec.activity_budget_id
1117: ,p_object_version => l_act_budgets_rec.object_version_number);
1118:
1119: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1120: RAISE Fnd_Api.g_exc_error;
1121: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1122: RAISE Fnd_Api.g_exc_unexpected_error;
1123: END IF;

Line 1120: RAISE Fnd_Api.g_exc_error;

1116: ,p_act_budget_id => l_act_budgets_rec.activity_budget_id
1117: ,p_object_version => l_act_budgets_rec.object_version_number);
1118:
1119: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1120: RAISE Fnd_Api.g_exc_error;
1121: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1122: RAISE Fnd_Api.g_exc_unexpected_error;
1123: END IF;
1124: END IF;

Line 1121: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1117: ,p_object_version => l_act_budgets_rec.object_version_number);
1118:
1119: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1120: RAISE Fnd_Api.g_exc_error;
1121: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1122: RAISE Fnd_Api.g_exc_unexpected_error;
1123: END IF;
1124: END IF;
1125: END LOOP;

Line 1122: RAISE Fnd_Api.g_exc_unexpected_error;

1118:
1119: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1120: RAISE Fnd_Api.g_exc_error;
1121: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1122: RAISE Fnd_Api.g_exc_unexpected_error;
1123: END IF;
1124: END IF;
1125: END LOOP;
1126: END IF;

Line 1141: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1137: ,p_modifier_line_tbl => l_modifier_line_tbl
1138: ,x_qp_list_header_id => l_dummy
1139: ,x_error_location => x_error_location);
1140:
1141: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1142: RAISE Fnd_Api.g_exc_error;
1143: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1144: RAISE Fnd_Api.g_exc_unexpected_error;
1145: END IF;

Line 1142: RAISE Fnd_Api.g_exc_error;

1138: ,x_qp_list_header_id => l_dummy
1139: ,x_error_location => x_error_location);
1140:
1141: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1142: RAISE Fnd_Api.g_exc_error;
1143: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1144: RAISE Fnd_Api.g_exc_unexpected_error;
1145: END IF;
1146: */

Line 1143: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1139: ,x_error_location => x_error_location);
1140:
1141: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1142: RAISE Fnd_Api.g_exc_error;
1143: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1144: RAISE Fnd_Api.g_exc_unexpected_error;
1145: END IF;
1146: */
1147: EXCEPTION

Line 1144: RAISE Fnd_Api.g_exc_unexpected_error;

1140:
1141: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1142: RAISE Fnd_Api.g_exc_error;
1143: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1144: RAISE Fnd_Api.g_exc_unexpected_error;
1145: END IF;
1146: */
1147: EXCEPTION
1148: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1148: WHEN Fnd_Api.G_EXC_ERROR THEN

1144: RAISE Fnd_Api.g_exc_unexpected_error;
1145: END IF;
1146: */
1147: EXCEPTION
1148: WHEN Fnd_Api.G_EXC_ERROR THEN
1149: x_return_status := Fnd_Api.g_ret_sts_error ;
1150: ROLLBACK TO process_modifiers_pub;
1151: Fnd_Msg_Pub.Count_AND_Get
1152: ( p_count => x_msg_count,

Line 1149: x_return_status := Fnd_Api.g_ret_sts_error ;

1145: END IF;
1146: */
1147: EXCEPTION
1148: WHEN Fnd_Api.G_EXC_ERROR THEN
1149: x_return_status := Fnd_Api.g_ret_sts_error ;
1150: ROLLBACK TO process_modifiers_pub;
1151: Fnd_Msg_Pub.Count_AND_Get
1152: ( p_count => x_msg_count,
1153: p_data => x_msg_data,

Line 1154: p_encoded => Fnd_Api.G_FALSE

1150: ROLLBACK TO process_modifiers_pub;
1151: Fnd_Msg_Pub.Count_AND_Get
1152: ( p_count => x_msg_count,
1153: p_data => x_msg_data,
1154: p_encoded => Fnd_Api.G_FALSE
1155: );
1156: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1157: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1158: ROLLBACK TO process_modifiers_pub;

Line 1156: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1152: ( p_count => x_msg_count,
1153: p_data => x_msg_data,
1154: p_encoded => Fnd_Api.G_FALSE
1155: );
1156: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1157: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1158: ROLLBACK TO process_modifiers_pub;
1159: Fnd_Msg_Pub.Count_AND_Get
1160: ( p_count => x_msg_count,

Line 1157: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

1153: p_data => x_msg_data,
1154: p_encoded => Fnd_Api.G_FALSE
1155: );
1156: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1157: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1158: ROLLBACK TO process_modifiers_pub;
1159: Fnd_Msg_Pub.Count_AND_Get
1160: ( p_count => x_msg_count,
1161: p_data => x_msg_data,

Line 1162: p_encoded => Fnd_Api.G_FALSE

1158: ROLLBACK TO process_modifiers_pub;
1159: Fnd_Msg_Pub.Count_AND_Get
1160: ( p_count => x_msg_count,
1161: p_data => x_msg_data,
1162: p_encoded => Fnd_Api.G_FALSE
1163: );
1164: WHEN OTHERS THEN
1165: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
1166: ROLLBACK TO process_modifiers_pub;

Line 1165: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;

1161: p_data => x_msg_data,
1162: p_encoded => Fnd_Api.G_FALSE
1163: );
1164: WHEN OTHERS THEN
1165: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
1166: ROLLBACK TO process_modifiers_pub;
1167: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1168: THEN
1169: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1174: p_encoded => Fnd_Api.G_FALSE

1170: END IF;
1171: Fnd_Msg_Pub.Count_AND_Get
1172: ( p_count => x_msg_count,
1173: p_data => x_msg_data,
1174: p_encoded => Fnd_Api.G_FALSE
1175: );
1176:
1177: END process_modifiers;
1178:

Line 1229: IF Fnd_Api.to_boolean(p_init_msg_list) THEN

1225: l_dummy NUMBER;
1226:
1227: BEGIN
1228: SAVEPOINT process_vo;
1229: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
1230: Fnd_Msg_Pub.initialize;
1231: END IF;
1232:
1233: IF NOT Fnd_Api.compatible_api_call(l_api_version,

Line 1233: IF NOT Fnd_Api.compatible_api_call(l_api_version,

1229: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
1230: Fnd_Msg_Pub.initialize;
1231: END IF;
1232:
1233: IF NOT Fnd_Api.compatible_api_call(l_api_version,
1234: p_api_version,
1235: l_api_name,
1236: g_pkg_name)
1237: THEN

Line 1238: RAISE Fnd_Api.g_exc_unexpected_error;

1234: p_api_version,
1235: l_api_name,
1236: g_pkg_name)
1237: THEN
1238: RAISE Fnd_Api.g_exc_unexpected_error;
1239: END IF;
1240:
1241: x_return_status := Fnd_Api.g_ret_sts_success;
1242: x_error_location := 0;

Line 1241: x_return_status := Fnd_Api.g_ret_sts_success;

1237: THEN
1238: RAISE Fnd_Api.g_exc_unexpected_error;
1239: END IF;
1240:
1241: x_return_status := Fnd_Api.g_ret_sts_success;
1242: x_error_location := 0;
1243:
1244: l_modifier_list_rec.offer_id := p_modifier_list_rec.offer_id;
1245: l_modifier_list_rec.qp_list_header_id := p_modifier_list_rec.qp_list_header_id;

Line 1324: IF p_modifier_list_rec.OWNER_ID IS NULL OR p_modifier_list_rec.OWNER_ID = fnd_api.g_miss_num THEN

1320: l_modifier_list_rec.modifier_operation := 'CREATE';
1321: l_modifier_list_rec.status_code := 'DRAFT';
1322: l_modifier_list_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS','DRAFT');--1600;
1323:
1324: IF p_modifier_list_rec.OWNER_ID IS NULL OR p_modifier_list_rec.OWNER_ID = fnd_api.g_miss_num THEN
1325: l_modifier_list_rec.OWNER_ID := ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id);
1326: ELSE
1327: l_modifier_list_rec.OWNER_ID := p_modifier_list_rec.OWNER_ID;
1328: END IF;

Line 1343: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1339: ,p_modifier_line_tbl => l_modifier_line_tbl -- need to create header first. use empty line.
1340: ,x_qp_list_header_id => x_qp_list_header_id
1341: ,x_error_location => x_error_location);
1342:
1343: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1344: RAISE Fnd_Api.g_exc_error;
1345: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1346: RAISE Fnd_Api.g_exc_unexpected_error;
1347: END IF;

Line 1344: RAISE Fnd_Api.g_exc_error;

1340: ,x_qp_list_header_id => x_qp_list_header_id
1341: ,x_error_location => x_error_location);
1342:
1343: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1344: RAISE Fnd_Api.g_exc_error;
1345: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1346: RAISE Fnd_Api.g_exc_unexpected_error;
1347: END IF;
1348:

Line 1345: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1341: ,x_error_location => x_error_location);
1342:
1343: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1344: RAISE Fnd_Api.g_exc_error;
1345: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1346: RAISE Fnd_Api.g_exc_unexpected_error;
1347: END IF;
1348:
1349: l_modifier_list_rec.offer_operation := 'UPDATE';

Line 1346: RAISE Fnd_Api.g_exc_unexpected_error;

1342:
1343: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1344: RAISE Fnd_Api.g_exc_error;
1345: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1346: RAISE Fnd_Api.g_exc_unexpected_error;
1347: END IF;
1348:
1349: l_modifier_list_rec.offer_operation := 'UPDATE';
1350: l_modifier_list_rec.modifier_operation := 'UPDATE';

Line 1357: l_modifier_list_rec.OWNER_ID := fnd_api.g_miss_num;

1353: l_modifier_list_rec.status_code := p_modifier_list_rec.status_code;
1354: ELSE
1355: x_qp_list_header_id := p_modifier_list_rec.qp_list_header_id;
1356: IF p_modifier_list_rec.OWNER_ID IS NULL THEN
1357: l_modifier_list_rec.OWNER_ID := fnd_api.g_miss_num;
1358: ELSE
1359: l_modifier_list_rec.OWNER_ID := p_modifier_list_rec.OWNER_ID;
1360: END IF;
1361: END IF;

Line 1403: ,p_validation_level => Fnd_Api.g_valid_level_full

1399: ozf_volume_offer_qual_pvt.create_vo_qualifier(
1400: p_api_version_number => p_api_version
1401: ,p_init_msg_list => p_init_msg_list
1402: ,p_commit => p_commit
1403: ,p_validation_level => Fnd_Api.g_valid_level_full
1404: ,x_return_status => x_return_status
1405: ,x_msg_count => x_msg_count
1406: ,x_msg_data => x_msg_data
1407: ,p_qualifiers_rec => l_qualifier_rec);

Line 1409: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1405: ,x_msg_count => x_msg_count
1406: ,x_msg_data => x_msg_data
1407: ,p_qualifiers_rec => l_qualifier_rec);
1408:
1409: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1410: RAISE Fnd_Api.g_exc_error;
1411: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1412: RAISE Fnd_Api.g_exc_unexpected_error;
1413: END IF;

Line 1410: RAISE Fnd_Api.g_exc_error;

1406: ,x_msg_data => x_msg_data
1407: ,p_qualifiers_rec => l_qualifier_rec);
1408:
1409: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1410: RAISE Fnd_Api.g_exc_error;
1411: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1412: RAISE Fnd_Api.g_exc_unexpected_error;
1413: END IF;
1414: ELSIF p_qualifier_tbl(i).operation = 'UPDATE' THEN

Line 1411: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1407: ,p_qualifiers_rec => l_qualifier_rec);
1408:
1409: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1410: RAISE Fnd_Api.g_exc_error;
1411: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1412: RAISE Fnd_Api.g_exc_unexpected_error;
1413: END IF;
1414: ELSIF p_qualifier_tbl(i).operation = 'UPDATE' THEN
1415: ozf_volume_offer_qual_pvt.update_vo_qualifier(

Line 1412: RAISE Fnd_Api.g_exc_unexpected_error;

1408:
1409: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1410: RAISE Fnd_Api.g_exc_error;
1411: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1412: RAISE Fnd_Api.g_exc_unexpected_error;
1413: END IF;
1414: ELSIF p_qualifier_tbl(i).operation = 'UPDATE' THEN
1415: ozf_volume_offer_qual_pvt.update_vo_qualifier(
1416: p_api_version_number => p_api_version

Line 1419: ,p_validation_level => Fnd_Api.g_valid_level_full

1415: ozf_volume_offer_qual_pvt.update_vo_qualifier(
1416: p_api_version_number => p_api_version
1417: ,p_init_msg_list => p_init_msg_list
1418: ,p_commit => p_commit
1419: ,p_validation_level => Fnd_Api.g_valid_level_full
1420: ,x_return_status => x_return_status
1421: ,x_msg_count => x_msg_count
1422: ,x_msg_data => x_msg_data
1423: ,p_qualifiers_rec => l_qualifier_rec);

Line 1425: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1421: ,x_msg_count => x_msg_count
1422: ,x_msg_data => x_msg_data
1423: ,p_qualifiers_rec => l_qualifier_rec);
1424:
1425: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1426: RAISE Fnd_Api.g_exc_error;
1427: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1428: RAISE Fnd_Api.g_exc_unexpected_error;
1429: END IF;

Line 1426: RAISE Fnd_Api.g_exc_error;

1422: ,x_msg_data => x_msg_data
1423: ,p_qualifiers_rec => l_qualifier_rec);
1424:
1425: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1426: RAISE Fnd_Api.g_exc_error;
1427: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1428: RAISE Fnd_Api.g_exc_unexpected_error;
1429: END IF;
1430: ELSIF p_qualifier_tbl(i).operation = 'DELETE' THEN

Line 1427: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1423: ,p_qualifiers_rec => l_qualifier_rec);
1424:
1425: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1426: RAISE Fnd_Api.g_exc_error;
1427: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1428: RAISE Fnd_Api.g_exc_unexpected_error;
1429: END IF;
1430: ELSIF p_qualifier_tbl(i).operation = 'DELETE' THEN
1431: ozf_volume_offer_qual_pvt.delete_vo_qualifier(

Line 1428: RAISE Fnd_Api.g_exc_unexpected_error;

1424:
1425: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1426: RAISE Fnd_Api.g_exc_error;
1427: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1428: RAISE Fnd_Api.g_exc_unexpected_error;
1429: END IF;
1430: ELSIF p_qualifier_tbl(i).operation = 'DELETE' THEN
1431: ozf_volume_offer_qual_pvt.delete_vo_qualifier(
1432: p_api_version_number => p_api_version

Line 1435: ,p_validation_level => Fnd_Api.g_valid_level_full

1431: ozf_volume_offer_qual_pvt.delete_vo_qualifier(
1432: p_api_version_number => p_api_version
1433: ,p_init_msg_list => p_init_msg_list
1434: ,p_commit => p_commit
1435: ,p_validation_level => Fnd_Api.g_valid_level_full
1436: ,x_return_status => x_return_status
1437: ,x_msg_count => x_msg_count
1438: ,x_msg_data => x_msg_data
1439: ,p_qualifier_id => l_qualifier_rec.qualifier_id);

Line 1441: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1437: ,x_msg_count => x_msg_count
1438: ,x_msg_data => x_msg_data
1439: ,p_qualifier_id => l_qualifier_rec.qualifier_id);
1440:
1441: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1442: RAISE Fnd_Api.g_exc_error;
1443: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1444: RAISE Fnd_Api.g_exc_unexpected_error;
1445: END IF;

Line 1442: RAISE Fnd_Api.g_exc_error;

1438: ,x_msg_data => x_msg_data
1439: ,p_qualifier_id => l_qualifier_rec.qualifier_id);
1440:
1441: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1442: RAISE Fnd_Api.g_exc_error;
1443: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1444: RAISE Fnd_Api.g_exc_unexpected_error;
1445: END IF;
1446: END IF;

Line 1443: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1439: ,p_qualifier_id => l_qualifier_rec.qualifier_id);
1440:
1441: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1442: RAISE Fnd_Api.g_exc_error;
1443: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1444: RAISE Fnd_Api.g_exc_unexpected_error;
1445: END IF;
1446: END IF;
1447: END LOOP;

Line 1444: RAISE Fnd_Api.g_exc_unexpected_error;

1440:
1441: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1442: RAISE Fnd_Api.g_exc_error;
1443: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1444: RAISE Fnd_Api.g_exc_unexpected_error;
1445: END IF;
1446: END IF;
1447: END LOOP;
1448:

Line 1460: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1456: ,p_qualifiers_tbl => l_qualifiers_tbl
1457: ,x_error_location => x_error_location
1458: ,x_qualifiers_tbl => l_qualifiers_tbl_out);
1459:
1460: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1461: RAISE Fnd_Api.g_exc_error;
1462: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1463: RAISE Fnd_Api.g_exc_unexpected_error;
1464: END IF;*/

Line 1461: RAISE Fnd_Api.g_exc_error;

1457: ,x_error_location => x_error_location
1458: ,x_qualifiers_tbl => l_qualifiers_tbl_out);
1459:
1460: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1461: RAISE Fnd_Api.g_exc_error;
1462: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1463: RAISE Fnd_Api.g_exc_unexpected_error;
1464: END IF;*/
1465: END IF;

Line 1462: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1458: ,x_qualifiers_tbl => l_qualifiers_tbl_out);
1459:
1460: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1461: RAISE Fnd_Api.g_exc_error;
1462: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1463: RAISE Fnd_Api.g_exc_unexpected_error;
1464: END IF;*/
1465: END IF;
1466:

Line 1463: RAISE Fnd_Api.g_exc_unexpected_error;

1459:
1460: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1461: RAISE Fnd_Api.g_exc_error;
1462: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1463: RAISE Fnd_Api.g_exc_unexpected_error;
1464: END IF;*/
1465: END IF;
1466:
1467: IF p_budget_tbl.COUNT > 0 THEN

Line 1488: ,p_validation_level => Fnd_Api.g_valid_level_full

1484: Ozf_Actbudgets_Pvt.create_act_budgets(
1485: p_api_version => p_api_version
1486: ,p_init_msg_list => p_init_msg_list
1487: ,p_commit => p_commit
1488: ,p_validation_level => Fnd_Api.g_valid_level_full
1489: ,x_return_status => x_return_status
1490: ,x_msg_count => x_msg_count
1491: ,x_msg_data => x_msg_data
1492: ,p_act_budgets_rec => l_act_budgets_rec

Line 1495: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1491: ,x_msg_data => x_msg_data
1492: ,p_act_budgets_rec => l_act_budgets_rec
1493: ,x_act_budget_id => l_activity_budget_id);
1494:
1495: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1496: RAISE Fnd_Api.g_exc_error;
1497: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1498: RAISE Fnd_Api.g_exc_unexpected_error;
1499: END IF;

Line 1496: RAISE Fnd_Api.g_exc_error;

1492: ,p_act_budgets_rec => l_act_budgets_rec
1493: ,x_act_budget_id => l_activity_budget_id);
1494:
1495: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1496: RAISE Fnd_Api.g_exc_error;
1497: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1498: RAISE Fnd_Api.g_exc_unexpected_error;
1499: END IF;
1500: ELSIF p_budget_tbl(i).operation = 'UPDATE' THEN

Line 1497: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1493: ,x_act_budget_id => l_activity_budget_id);
1494:
1495: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1496: RAISE Fnd_Api.g_exc_error;
1497: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1498: RAISE Fnd_Api.g_exc_unexpected_error;
1499: END IF;
1500: ELSIF p_budget_tbl(i).operation = 'UPDATE' THEN
1501: Ozf_Actbudgets_Pvt.update_act_budgets(

Line 1498: RAISE Fnd_Api.g_exc_unexpected_error;

1494:
1495: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1496: RAISE Fnd_Api.g_exc_error;
1497: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1498: RAISE Fnd_Api.g_exc_unexpected_error;
1499: END IF;
1500: ELSIF p_budget_tbl(i).operation = 'UPDATE' THEN
1501: Ozf_Actbudgets_Pvt.update_act_budgets(
1502: p_api_version => p_api_version

Line 1505: ,p_validation_level => Fnd_Api.g_valid_level_full

1501: Ozf_Actbudgets_Pvt.update_act_budgets(
1502: p_api_version => p_api_version
1503: ,p_init_msg_list => p_init_msg_list
1504: ,p_commit => p_commit
1505: ,p_validation_level => Fnd_Api.g_valid_level_full
1506: ,x_return_status => x_return_status
1507: ,x_msg_count => x_msg_count
1508: ,x_msg_data => x_msg_data
1509: ,p_act_budgets_rec => l_act_budgets_rec);

Line 1511: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1507: ,x_msg_count => x_msg_count
1508: ,x_msg_data => x_msg_data
1509: ,p_act_budgets_rec => l_act_budgets_rec);
1510:
1511: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1512: RAISE Fnd_Api.g_exc_error;
1513: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1514: RAISE Fnd_Api.g_exc_unexpected_error;
1515: END IF;

Line 1512: RAISE Fnd_Api.g_exc_error;

1508: ,x_msg_data => x_msg_data
1509: ,p_act_budgets_rec => l_act_budgets_rec);
1510:
1511: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1512: RAISE Fnd_Api.g_exc_error;
1513: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1514: RAISE Fnd_Api.g_exc_unexpected_error;
1515: END IF;
1516: ELSIF p_budget_tbl(i).operation = 'DELETE' THEN

Line 1513: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1509: ,p_act_budgets_rec => l_act_budgets_rec);
1510:
1511: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1512: RAISE Fnd_Api.g_exc_error;
1513: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1514: RAISE Fnd_Api.g_exc_unexpected_error;
1515: END IF;
1516: ELSIF p_budget_tbl(i).operation = 'DELETE' THEN
1517: Ozf_Actbudgets_Pvt.delete_act_budgets(

Line 1514: RAISE Fnd_Api.g_exc_unexpected_error;

1510:
1511: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1512: RAISE Fnd_Api.g_exc_error;
1513: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1514: RAISE Fnd_Api.g_exc_unexpected_error;
1515: END IF;
1516: ELSIF p_budget_tbl(i).operation = 'DELETE' THEN
1517: Ozf_Actbudgets_Pvt.delete_act_budgets(
1518: p_api_version => p_api_version

Line 1521: ,p_validation_level => Fnd_Api.g_valid_level_full

1517: Ozf_Actbudgets_Pvt.delete_act_budgets(
1518: p_api_version => p_api_version
1519: ,p_init_msg_list => p_init_msg_list
1520: ,p_commit => p_commit
1521: ,p_validation_level => Fnd_Api.g_valid_level_full
1522: ,x_return_status => x_return_status
1523: ,x_msg_count => x_msg_count
1524: ,x_msg_data => x_msg_data
1525: ,p_act_budget_id => l_act_budgets_rec.activity_budget_id

Line 1528: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1524: ,x_msg_data => x_msg_data
1525: ,p_act_budget_id => l_act_budgets_rec.activity_budget_id
1526: ,p_object_version => l_act_budgets_rec.object_version_number);
1527:
1528: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1529: RAISE Fnd_Api.g_exc_error;
1530: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1531: RAISE Fnd_Api.g_exc_unexpected_error;
1532: END IF;

Line 1529: RAISE Fnd_Api.g_exc_error;

1525: ,p_act_budget_id => l_act_budgets_rec.activity_budget_id
1526: ,p_object_version => l_act_budgets_rec.object_version_number);
1527:
1528: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1529: RAISE Fnd_Api.g_exc_error;
1530: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1531: RAISE Fnd_Api.g_exc_unexpected_error;
1532: END IF;
1533: END IF;

Line 1530: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1526: ,p_object_version => l_act_budgets_rec.object_version_number);
1527:
1528: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1529: RAISE Fnd_Api.g_exc_error;
1530: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1531: RAISE Fnd_Api.g_exc_unexpected_error;
1532: END IF;
1533: END IF;
1534: END LOOP;

Line 1531: RAISE Fnd_Api.g_exc_unexpected_error;

1527:
1528: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1529: RAISE Fnd_Api.g_exc_error;
1530: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1531: RAISE Fnd_Api.g_exc_unexpected_error;
1532: END IF;
1533: END IF;
1534: END LOOP;
1535: END IF;

Line 1559: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1555: ozf_volume_offer_disc_pvt.create_vo_discount(
1556: p_api_version_number => p_api_version
1557: ,p_init_msg_list => p_init_msg_list
1558: ,p_commit => p_commit
1559: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1560: ,x_return_status => x_return_status
1561: ,x_msg_count => x_msg_count
1562: ,x_msg_data => x_msg_data
1563: ,p_vo_disc_rec => l_vo_pbh_rec

Line 1566: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1562: ,x_msg_data => x_msg_data
1563: ,p_vo_disc_rec => l_vo_pbh_rec
1564: ,x_vo_discount_line_id => l_vo_pbh_line_id);
1565:
1566: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1567: RAISE Fnd_Api.g_exc_error;
1568: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1569: RAISE Fnd_Api.g_exc_unexpected_error;
1570: END IF;

Line 1567: RAISE Fnd_Api.g_exc_error;

1563: ,p_vo_disc_rec => l_vo_pbh_rec
1564: ,x_vo_discount_line_id => l_vo_pbh_line_id);
1565:
1566: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1567: RAISE Fnd_Api.g_exc_error;
1568: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1569: RAISE Fnd_Api.g_exc_unexpected_error;
1570: END IF;
1571: ELSIF p_vo_pbh_tbl(i).operation = 'UPDATE' THEN

Line 1568: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1564: ,x_vo_discount_line_id => l_vo_pbh_line_id);
1565:
1566: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1567: RAISE Fnd_Api.g_exc_error;
1568: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1569: RAISE Fnd_Api.g_exc_unexpected_error;
1570: END IF;
1571: ELSIF p_vo_pbh_tbl(i).operation = 'UPDATE' THEN
1572: ozf_volume_offer_disc_pvt.update_vo_discount(

Line 1569: RAISE Fnd_Api.g_exc_unexpected_error;

1565:
1566: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1567: RAISE Fnd_Api.g_exc_error;
1568: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1569: RAISE Fnd_Api.g_exc_unexpected_error;
1570: END IF;
1571: ELSIF p_vo_pbh_tbl(i).operation = 'UPDATE' THEN
1572: ozf_volume_offer_disc_pvt.update_vo_discount(
1573: p_api_version_number => p_api_version

Line 1576: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1572: ozf_volume_offer_disc_pvt.update_vo_discount(
1573: p_api_version_number => p_api_version
1574: ,p_init_msg_list => p_init_msg_list
1575: ,p_commit => p_commit
1576: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1577: ,x_return_status => x_return_status
1578: ,x_msg_count => x_msg_count
1579: ,x_msg_data => x_msg_data
1580: ,p_vo_disc_rec => l_vo_pbh_rec);

Line 1582: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1578: ,x_msg_count => x_msg_count
1579: ,x_msg_data => x_msg_data
1580: ,p_vo_disc_rec => l_vo_pbh_rec);
1581:
1582: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1583: RAISE Fnd_Api.g_exc_error;
1584: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1585: RAISE Fnd_Api.g_exc_unexpected_error;
1586: END IF;

Line 1583: RAISE Fnd_Api.g_exc_error;

1579: ,x_msg_data => x_msg_data
1580: ,p_vo_disc_rec => l_vo_pbh_rec);
1581:
1582: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1583: RAISE Fnd_Api.g_exc_error;
1584: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1585: RAISE Fnd_Api.g_exc_unexpected_error;
1586: END IF;
1587: ELSIF p_vo_pbh_tbl(i).operation = 'DELETE' THEN

Line 1584: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1580: ,p_vo_disc_rec => l_vo_pbh_rec);
1581:
1582: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1583: RAISE Fnd_Api.g_exc_error;
1584: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1585: RAISE Fnd_Api.g_exc_unexpected_error;
1586: END IF;
1587: ELSIF p_vo_pbh_tbl(i).operation = 'DELETE' THEN
1588: ozf_volume_offer_disc_pvt.delete_vo_discount(

Line 1585: RAISE Fnd_Api.g_exc_unexpected_error;

1581:
1582: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1583: RAISE Fnd_Api.g_exc_error;
1584: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1585: RAISE Fnd_Api.g_exc_unexpected_error;
1586: END IF;
1587: ELSIF p_vo_pbh_tbl(i).operation = 'DELETE' THEN
1588: ozf_volume_offer_disc_pvt.delete_vo_discount(
1589: p_api_version_number => p_api_version

Line 1592: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1588: ozf_volume_offer_disc_pvt.delete_vo_discount(
1589: p_api_version_number => p_api_version
1590: ,p_init_msg_list => p_init_msg_list
1591: ,p_commit => p_commit
1592: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1593: ,x_return_status => x_return_status
1594: ,x_msg_count => x_msg_count
1595: ,x_msg_data => x_msg_data
1596: ,p_offer_discount_line_id => l_vo_pbh_rec.offer_discount_line_id

Line 1599: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1595: ,x_msg_data => x_msg_data
1596: ,p_offer_discount_line_id => l_vo_pbh_rec.offer_discount_line_id
1597: ,p_object_version_number => l_vo_pbh_rec.object_version_number);
1598:
1599: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1600: RAISE Fnd_Api.g_exc_error;
1601: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1602: RAISE Fnd_Api.g_exc_unexpected_error;
1603: END IF;

Line 1600: RAISE Fnd_Api.g_exc_error;

1596: ,p_offer_discount_line_id => l_vo_pbh_rec.offer_discount_line_id
1597: ,p_object_version_number => l_vo_pbh_rec.object_version_number);
1598:
1599: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1600: RAISE Fnd_Api.g_exc_error;
1601: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1602: RAISE Fnd_Api.g_exc_unexpected_error;
1603: END IF;
1604: END IF; -- end PBH operation switching

Line 1601: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1597: ,p_object_version_number => l_vo_pbh_rec.object_version_number);
1598:
1599: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1600: RAISE Fnd_Api.g_exc_error;
1601: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1602: RAISE Fnd_Api.g_exc_unexpected_error;
1603: END IF;
1604: END IF; -- end PBH operation switching
1605:

Line 1602: RAISE Fnd_Api.g_exc_unexpected_error;

1598:
1599: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1600: RAISE Fnd_Api.g_exc_error;
1601: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1602: RAISE Fnd_Api.g_exc_unexpected_error;
1603: END IF;
1604: END IF; -- end PBH operation switching
1605:
1606: -- DIS lines

Line 1628: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1624: ozf_volume_offer_disc_pvt.create_vo_discount(
1625: p_api_version_number => p_api_version
1626: ,p_init_msg_list => p_init_msg_list
1627: ,p_commit => p_commit
1628: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1629: ,x_return_status => x_return_status
1630: ,x_msg_count => x_msg_count
1631: ,x_msg_data => x_msg_data
1632: ,p_vo_disc_rec => l_vo_dis_rec

Line 1635: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1631: ,x_msg_data => x_msg_data
1632: ,p_vo_disc_rec => l_vo_dis_rec
1633: ,x_vo_discount_line_id => l_vo_dis_line_id);
1634:
1635: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1636: RAISE Fnd_Api.g_exc_error;
1637: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1638: RAISE Fnd_Api.g_exc_unexpected_error;
1639: END IF;

Line 1636: RAISE Fnd_Api.g_exc_error;

1632: ,p_vo_disc_rec => l_vo_dis_rec
1633: ,x_vo_discount_line_id => l_vo_dis_line_id);
1634:
1635: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1636: RAISE Fnd_Api.g_exc_error;
1637: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1638: RAISE Fnd_Api.g_exc_unexpected_error;
1639: END IF;
1640: ELSIF p_vo_dis_tbl(j).operation = 'UPDATE' THEN

Line 1637: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1633: ,x_vo_discount_line_id => l_vo_dis_line_id);
1634:
1635: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1636: RAISE Fnd_Api.g_exc_error;
1637: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1638: RAISE Fnd_Api.g_exc_unexpected_error;
1639: END IF;
1640: ELSIF p_vo_dis_tbl(j).operation = 'UPDATE' THEN
1641: ozf_volume_offer_disc_pvt.update_vo_discount(

Line 1638: RAISE Fnd_Api.g_exc_unexpected_error;

1634:
1635: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1636: RAISE Fnd_Api.g_exc_error;
1637: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1638: RAISE Fnd_Api.g_exc_unexpected_error;
1639: END IF;
1640: ELSIF p_vo_dis_tbl(j).operation = 'UPDATE' THEN
1641: ozf_volume_offer_disc_pvt.update_vo_discount(
1642: p_api_version_number => p_api_version

Line 1645: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1641: ozf_volume_offer_disc_pvt.update_vo_discount(
1642: p_api_version_number => p_api_version
1643: ,p_init_msg_list => p_init_msg_list
1644: ,p_commit => p_commit
1645: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1646: ,x_return_status => x_return_status
1647: ,x_msg_count => x_msg_count
1648: ,x_msg_data => x_msg_data
1649: ,p_vo_disc_rec => l_vo_dis_rec);

Line 1651: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1647: ,x_msg_count => x_msg_count
1648: ,x_msg_data => x_msg_data
1649: ,p_vo_disc_rec => l_vo_dis_rec);
1650:
1651: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1652: RAISE Fnd_Api.g_exc_error;
1653: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1654: RAISE Fnd_Api.g_exc_unexpected_error;
1655: END IF;

Line 1652: RAISE Fnd_Api.g_exc_error;

1648: ,x_msg_data => x_msg_data
1649: ,p_vo_disc_rec => l_vo_dis_rec);
1650:
1651: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1652: RAISE Fnd_Api.g_exc_error;
1653: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1654: RAISE Fnd_Api.g_exc_unexpected_error;
1655: END IF;
1656: ELSIF p_vo_dis_tbl(j).operation = 'DELETE' THEN

Line 1653: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1649: ,p_vo_disc_rec => l_vo_dis_rec);
1650:
1651: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1652: RAISE Fnd_Api.g_exc_error;
1653: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1654: RAISE Fnd_Api.g_exc_unexpected_error;
1655: END IF;
1656: ELSIF p_vo_dis_tbl(j).operation = 'DELETE' THEN
1657: ozf_volume_offer_disc_pvt.delete_vo_discount(

Line 1654: RAISE Fnd_Api.g_exc_unexpected_error;

1650:
1651: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1652: RAISE Fnd_Api.g_exc_error;
1653: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1654: RAISE Fnd_Api.g_exc_unexpected_error;
1655: END IF;
1656: ELSIF p_vo_dis_tbl(j).operation = 'DELETE' THEN
1657: ozf_volume_offer_disc_pvt.delete_vo_discount(
1658: p_api_version_number => p_api_version

Line 1661: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1657: ozf_volume_offer_disc_pvt.delete_vo_discount(
1658: p_api_version_number => p_api_version
1659: ,p_init_msg_list => p_init_msg_list
1660: ,p_commit => p_commit
1661: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1662: ,x_return_status => x_return_status
1663: ,x_msg_count => x_msg_count
1664: ,x_msg_data => x_msg_data
1665: ,p_offer_discount_line_id => l_vo_dis_rec.offer_discount_line_id

Line 1668: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1664: ,x_msg_data => x_msg_data
1665: ,p_offer_discount_line_id => l_vo_dis_rec.offer_discount_line_id
1666: ,p_object_version_number => l_vo_dis_rec.object_version_number);
1667:
1668: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1669: RAISE Fnd_Api.g_exc_error;
1670: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1671: RAISE Fnd_Api.g_exc_unexpected_error;
1672: END IF;

Line 1669: RAISE Fnd_Api.g_exc_error;

1665: ,p_offer_discount_line_id => l_vo_dis_rec.offer_discount_line_id
1666: ,p_object_version_number => l_vo_dis_rec.object_version_number);
1667:
1668: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1669: RAISE Fnd_Api.g_exc_error;
1670: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1671: RAISE Fnd_Api.g_exc_unexpected_error;
1672: END IF;
1673: END IF; -- end DIS opeartion switching

Line 1670: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1666: ,p_object_version_number => l_vo_dis_rec.object_version_number);
1667:
1668: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1669: RAISE Fnd_Api.g_exc_error;
1670: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1671: RAISE Fnd_Api.g_exc_unexpected_error;
1672: END IF;
1673: END IF; -- end DIS opeartion switching
1674: END IF; -- end pbh_index matching

Line 1671: RAISE Fnd_Api.g_exc_unexpected_error;

1667:
1668: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1669: RAISE Fnd_Api.g_exc_error;
1670: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1671: RAISE Fnd_Api.g_exc_unexpected_error;
1672: END IF;
1673: END IF; -- end DIS opeartion switching
1674: END IF; -- end pbh_index matching
1675: END LOOP;

Line 1698: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1694: ozf_volume_offer_disc_pvt.create_vo_product(
1695: p_api_version_number => p_api_version
1696: ,p_init_msg_list => p_init_msg_list
1697: ,p_commit => p_commit
1698: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1699: ,x_return_status => x_return_status
1700: ,x_msg_count => x_msg_count
1701: ,x_msg_data => x_msg_data
1702: ,p_vo_prod_rec => l_vo_prod_rec

Line 1705: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1701: ,x_msg_data => x_msg_data
1702: ,p_vo_prod_rec => l_vo_prod_rec
1703: ,x_off_discount_product_id => l_vo_prod_id);
1704:
1705: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1706: RAISE Fnd_Api.g_exc_error;
1707: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1708: RAISE Fnd_Api.g_exc_unexpected_error;
1709: END IF;

Line 1706: RAISE Fnd_Api.g_exc_error;

1702: ,p_vo_prod_rec => l_vo_prod_rec
1703: ,x_off_discount_product_id => l_vo_prod_id);
1704:
1705: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1706: RAISE Fnd_Api.g_exc_error;
1707: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1708: RAISE Fnd_Api.g_exc_unexpected_error;
1709: END IF;
1710: ELSIF p_vo_prod_tbl(k).operation = 'UPDATE' THEN

Line 1707: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1703: ,x_off_discount_product_id => l_vo_prod_id);
1704:
1705: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1706: RAISE Fnd_Api.g_exc_error;
1707: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1708: RAISE Fnd_Api.g_exc_unexpected_error;
1709: END IF;
1710: ELSIF p_vo_prod_tbl(k).operation = 'UPDATE' THEN
1711: ozf_volume_offer_disc_pvt.update_vo_product(

Line 1708: RAISE Fnd_Api.g_exc_unexpected_error;

1704:
1705: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1706: RAISE Fnd_Api.g_exc_error;
1707: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1708: RAISE Fnd_Api.g_exc_unexpected_error;
1709: END IF;
1710: ELSIF p_vo_prod_tbl(k).operation = 'UPDATE' THEN
1711: ozf_volume_offer_disc_pvt.update_vo_product(
1712: p_api_version_number => p_api_version

Line 1715: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1711: ozf_volume_offer_disc_pvt.update_vo_product(
1712: p_api_version_number => p_api_version
1713: ,p_init_msg_list => p_init_msg_list
1714: ,p_commit => p_commit
1715: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1716: ,x_return_status => x_return_status
1717: ,x_msg_count => x_msg_count
1718: ,x_msg_data => x_msg_data
1719: ,p_vo_prod_rec => l_vo_prod_rec);

Line 1721: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1717: ,x_msg_count => x_msg_count
1718: ,x_msg_data => x_msg_data
1719: ,p_vo_prod_rec => l_vo_prod_rec);
1720:
1721: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1722: RAISE Fnd_Api.g_exc_error;
1723: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1724: RAISE Fnd_Api.g_exc_unexpected_error;
1725: END IF;

Line 1722: RAISE Fnd_Api.g_exc_error;

1718: ,x_msg_data => x_msg_data
1719: ,p_vo_prod_rec => l_vo_prod_rec);
1720:
1721: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1722: RAISE Fnd_Api.g_exc_error;
1723: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1724: RAISE Fnd_Api.g_exc_unexpected_error;
1725: END IF;
1726: ELSIF p_vo_prod_tbl(k).operation = 'DELETE' THEN

Line 1723: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1719: ,p_vo_prod_rec => l_vo_prod_rec);
1720:
1721: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1722: RAISE Fnd_Api.g_exc_error;
1723: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1724: RAISE Fnd_Api.g_exc_unexpected_error;
1725: END IF;
1726: ELSIF p_vo_prod_tbl(k).operation = 'DELETE' THEN
1727: ozf_volume_offer_disc_pvt.delete_vo_product(

Line 1724: RAISE Fnd_Api.g_exc_unexpected_error;

1720:
1721: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1722: RAISE Fnd_Api.g_exc_error;
1723: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1724: RAISE Fnd_Api.g_exc_unexpected_error;
1725: END IF;
1726: ELSIF p_vo_prod_tbl(k).operation = 'DELETE' THEN
1727: ozf_volume_offer_disc_pvt.delete_vo_product(
1728: p_api_version_number => p_api_version

Line 1731: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1727: ozf_volume_offer_disc_pvt.delete_vo_product(
1728: p_api_version_number => p_api_version
1729: ,p_init_msg_list => p_init_msg_list
1730: ,p_commit => p_commit
1731: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1732: ,x_return_status => x_return_status
1733: ,x_msg_count => x_msg_count
1734: ,x_msg_data => x_msg_data
1735: ,p_off_discount_product_id => l_vo_prod_rec.off_discount_product_id

Line 1738: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1734: ,x_msg_data => x_msg_data
1735: ,p_off_discount_product_id => l_vo_prod_rec.off_discount_product_id
1736: ,p_object_version_number => l_vo_prod_rec.object_version_number);
1737:
1738: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1739: RAISE Fnd_Api.g_exc_error;
1740: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1741: RAISE Fnd_Api.g_exc_unexpected_error;
1742: END IF;

Line 1739: RAISE Fnd_Api.g_exc_error;

1735: ,p_off_discount_product_id => l_vo_prod_rec.off_discount_product_id
1736: ,p_object_version_number => l_vo_prod_rec.object_version_number);
1737:
1738: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1739: RAISE Fnd_Api.g_exc_error;
1740: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1741: RAISE Fnd_Api.g_exc_unexpected_error;
1742: END IF;
1743: END IF; -- end product operation switching

Line 1740: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1736: ,p_object_version_number => l_vo_prod_rec.object_version_number);
1737:
1738: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1739: RAISE Fnd_Api.g_exc_error;
1740: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1741: RAISE Fnd_Api.g_exc_unexpected_error;
1742: END IF;
1743: END IF; -- end product operation switching
1744: END IF; -- end pbh_idex matching

Line 1741: RAISE Fnd_Api.g_exc_unexpected_error;

1737:
1738: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1739: RAISE Fnd_Api.g_exc_error;
1740: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1741: RAISE Fnd_Api.g_exc_unexpected_error;
1742: END IF;
1743: END IF; -- end product operation switching
1744: END IF; -- end pbh_idex matching
1745: END LOOP;

Line 1771: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1767: ozf_offer_market_options_pvt.create_market_options(
1768: p_api_version_number => p_api_version
1769: ,p_init_msg_list => p_init_msg_list
1770: ,p_commit => p_commit
1771: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1772: ,x_return_status => x_return_status
1773: ,x_msg_count => x_msg_count
1774: ,x_msg_data => x_msg_data
1775: ,p_mo_rec => l_vo_mo_rec

Line 1778: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1774: ,x_msg_data => x_msg_data
1775: ,p_mo_rec => l_vo_mo_rec
1776: ,x_vo_market_option_id => l_vo_mo_id);
1777:
1778: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1779: RAISE Fnd_Api.g_exc_error;
1780: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1781: RAISE Fnd_Api.g_exc_unexpected_error;
1782: END IF;

Line 1779: RAISE Fnd_Api.g_exc_error;

1775: ,p_mo_rec => l_vo_mo_rec
1776: ,x_vo_market_option_id => l_vo_mo_id);
1777:
1778: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1779: RAISE Fnd_Api.g_exc_error;
1780: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1781: RAISE Fnd_Api.g_exc_unexpected_error;
1782: END IF;
1783: ELSIF p_vo_mo_tbl(i).operation = 'UPDATE' THEN

Line 1780: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1776: ,x_vo_market_option_id => l_vo_mo_id);
1777:
1778: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1779: RAISE Fnd_Api.g_exc_error;
1780: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1781: RAISE Fnd_Api.g_exc_unexpected_error;
1782: END IF;
1783: ELSIF p_vo_mo_tbl(i).operation = 'UPDATE' THEN
1784: ozf_offer_market_options_pvt.update_market_options(

Line 1781: RAISE Fnd_Api.g_exc_unexpected_error;

1777:
1778: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1779: RAISE Fnd_Api.g_exc_error;
1780: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1781: RAISE Fnd_Api.g_exc_unexpected_error;
1782: END IF;
1783: ELSIF p_vo_mo_tbl(i).operation = 'UPDATE' THEN
1784: ozf_offer_market_options_pvt.update_market_options(
1785: p_api_version_number => p_api_version

Line 1788: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1784: ozf_offer_market_options_pvt.update_market_options(
1785: p_api_version_number => p_api_version
1786: ,p_init_msg_list => p_init_msg_list
1787: ,p_commit => p_commit
1788: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1789: ,x_return_status => x_return_status
1790: ,x_msg_count => x_msg_count
1791: ,x_msg_data => x_msg_data
1792: ,p_mo_rec => l_vo_mo_rec);

Line 1794: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1790: ,x_msg_count => x_msg_count
1791: ,x_msg_data => x_msg_data
1792: ,p_mo_rec => l_vo_mo_rec);
1793:
1794: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1795: RAISE Fnd_Api.g_exc_error;
1796: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1797: RAISE Fnd_Api.g_exc_unexpected_error;
1798: END IF;

Line 1795: RAISE Fnd_Api.g_exc_error;

1791: ,x_msg_data => x_msg_data
1792: ,p_mo_rec => l_vo_mo_rec);
1793:
1794: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1795: RAISE Fnd_Api.g_exc_error;
1796: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1797: RAISE Fnd_Api.g_exc_unexpected_error;
1798: END IF;
1799: ELSIF p_vo_mo_tbl(i).operation = 'DELETE' THEN

Line 1796: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1792: ,p_mo_rec => l_vo_mo_rec);
1793:
1794: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1795: RAISE Fnd_Api.g_exc_error;
1796: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1797: RAISE Fnd_Api.g_exc_unexpected_error;
1798: END IF;
1799: ELSIF p_vo_mo_tbl(i).operation = 'DELETE' THEN
1800: ozf_offer_market_options_pvt.delete_market_options(

Line 1797: RAISE Fnd_Api.g_exc_unexpected_error;

1793:
1794: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1795: RAISE Fnd_Api.g_exc_error;
1796: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1797: RAISE Fnd_Api.g_exc_unexpected_error;
1798: END IF;
1799: ELSIF p_vo_mo_tbl(i).operation = 'DELETE' THEN
1800: ozf_offer_market_options_pvt.delete_market_options(
1801: p_api_version_number => p_api_version

Line 1804: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1800: ozf_offer_market_options_pvt.delete_market_options(
1801: p_api_version_number => p_api_version
1802: ,p_init_msg_list => p_init_msg_list
1803: ,p_commit => p_commit
1804: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1805: ,x_return_status => x_return_status
1806: ,x_msg_count => x_msg_count
1807: ,x_msg_data => x_msg_data
1808: ,p_offer_market_option_id => l_vo_mo_rec.offer_market_option_id

Line 1811: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1807: ,x_msg_data => x_msg_data
1808: ,p_offer_market_option_id => l_vo_mo_rec.offer_market_option_id
1809: ,p_object_version_number => l_vo_mo_rec.object_version_number);
1810:
1811: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1812: RAISE Fnd_Api.g_exc_error;
1813: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1814: RAISE Fnd_Api.g_exc_unexpected_error;
1815: END IF;

Line 1812: RAISE Fnd_Api.g_exc_error;

1808: ,p_offer_market_option_id => l_vo_mo_rec.offer_market_option_id
1809: ,p_object_version_number => l_vo_mo_rec.object_version_number);
1810:
1811: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1812: RAISE Fnd_Api.g_exc_error;
1813: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1814: RAISE Fnd_Api.g_exc_unexpected_error;
1815: END IF;
1816: END IF;

Line 1813: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1809: ,p_object_version_number => l_vo_mo_rec.object_version_number);
1810:
1811: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1812: RAISE Fnd_Api.g_exc_error;
1813: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1814: RAISE Fnd_Api.g_exc_unexpected_error;
1815: END IF;
1816: END IF;
1817: END LOOP;

Line 1814: RAISE Fnd_Api.g_exc_unexpected_error;

1810:
1811: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1812: RAISE Fnd_Api.g_exc_error;
1813: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1814: RAISE Fnd_Api.g_exc_unexpected_error;
1815: END IF;
1816: END IF;
1817: END LOOP;
1818: END IF; -- end market options

Line 1833: IF x_return_status = Fnd_Api.g_ret_sts_error THEN

1829: ,p_modifier_line_tbl => l_modifier_line_tbl
1830: ,x_qp_list_header_id => l_dummy
1831: ,x_error_location => x_error_location);
1832:
1833: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1834: RAISE Fnd_Api.g_exc_error;
1835: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1836: RAISE Fnd_Api.g_exc_unexpected_error;
1837: END IF;

Line 1834: RAISE Fnd_Api.g_exc_error;

1830: ,x_qp_list_header_id => l_dummy
1831: ,x_error_location => x_error_location);
1832:
1833: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1834: RAISE Fnd_Api.g_exc_error;
1835: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1836: RAISE Fnd_Api.g_exc_unexpected_error;
1837: END IF;
1838:

Line 1835: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

1831: ,x_error_location => x_error_location);
1832:
1833: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1834: RAISE Fnd_Api.g_exc_error;
1835: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1836: RAISE Fnd_Api.g_exc_unexpected_error;
1837: END IF;
1838:
1839: EXCEPTION

Line 1836: RAISE Fnd_Api.g_exc_unexpected_error;

1832:
1833: IF x_return_status = Fnd_Api.g_ret_sts_error THEN
1834: RAISE Fnd_Api.g_exc_error;
1835: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
1836: RAISE Fnd_Api.g_exc_unexpected_error;
1837: END IF;
1838:
1839: EXCEPTION
1840: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1840: WHEN Fnd_Api.G_EXC_ERROR THEN

1836: RAISE Fnd_Api.g_exc_unexpected_error;
1837: END IF;
1838:
1839: EXCEPTION
1840: WHEN Fnd_Api.G_EXC_ERROR THEN
1841: x_return_status := Fnd_Api.g_ret_sts_error ;
1842: ROLLBACK TO process_vo;
1843: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1844: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1841: x_return_status := Fnd_Api.g_ret_sts_error ;

1837: END IF;
1838:
1839: EXCEPTION
1840: WHEN Fnd_Api.G_EXC_ERROR THEN
1841: x_return_status := Fnd_Api.g_ret_sts_error ;
1842: ROLLBACK TO process_vo;
1843: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1844: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1845: END IF;

Line 1849: p_encoded => Fnd_Api.G_FALSE

1845: END IF;
1846: Fnd_Msg_Pub.Count_AND_Get
1847: ( p_count => x_msg_count,
1848: p_data => x_msg_data,
1849: p_encoded => Fnd_Api.G_FALSE
1850: );
1851: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1852: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1853: ROLLBACK TO process_vo;

Line 1851: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1847: ( p_count => x_msg_count,
1848: p_data => x_msg_data,
1849: p_encoded => Fnd_Api.G_FALSE
1850: );
1851: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1852: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1853: ROLLBACK TO process_vo;
1854: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1855: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1852: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

1848: p_data => x_msg_data,
1849: p_encoded => Fnd_Api.G_FALSE
1850: );
1851: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1852: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1853: ROLLBACK TO process_vo;
1854: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1855: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1856: END IF;

Line 1860: p_encoded => Fnd_Api.G_FALSE

1856: END IF;
1857: Fnd_Msg_Pub.Count_AND_Get
1858: ( p_count => x_msg_count,
1859: p_data => x_msg_data,
1860: p_encoded => Fnd_Api.G_FALSE
1861: );
1862: WHEN OTHERS THEN
1863: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
1864: ROLLBACK TO process_vo;

Line 1863: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;

1859: p_data => x_msg_data,
1860: p_encoded => Fnd_Api.G_FALSE
1861: );
1862: WHEN OTHERS THEN
1863: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
1864: ROLLBACK TO process_vo;
1865: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1866: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1867: END IF;

Line 1871: p_encoded => Fnd_Api.G_FALSE

1867: END IF;
1868: Fnd_Msg_Pub.Count_AND_Get
1869: ( p_count => x_msg_count,
1870: p_data => x_msg_data,
1871: p_encoded => Fnd_Api.G_FALSE
1872: );
1873:
1874: END process_vo;
1875: