APPS.OZF_VOLUME_OFFER_ADJ dependencies on FND_API

Line 49: x_return_status := FND_API.G_RET_STS_SUCCESS;

45: initialize record
46: populate the record
47: update VO discount tiers
48: */
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50: FOR l_discountLine IN c_discountLine(cp_offerDiscountLineId => p_offerDiscountLineId , cp_offerAdjustmentId => p_offerAdjustmentId )
51: LOOP
52: l_vo_disc_rec := null;
53: l_vo_disc_rec.offer_discount_line_id := p_offerDiscountLineId;

Line 60: , p_init_msg_list => FND_API.G_FALSE

56: l_vo_disc_rec.discount := l_discountLine.modified_discount;
57: END LOOP;
58: OZF_Volume_Offer_disc_PVT.Update_vo_discount(
59: p_api_version_number => 1.0
60: , p_init_msg_list => FND_API.G_FALSE
61: , p_commit => FND_API.G_FALSE
62: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
63: , x_return_status => x_return_status
64: , x_msg_count => x_msg_count

Line 61: , p_commit => FND_API.G_FALSE

57: END LOOP;
58: OZF_Volume_Offer_disc_PVT.Update_vo_discount(
59: p_api_version_number => 1.0
60: , p_init_msg_list => FND_API.G_FALSE
61: , p_commit => FND_API.G_FALSE
62: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
63: , x_return_status => x_return_status
64: , x_msg_count => x_msg_count
65: , x_msg_data => x_msg_data

Line 62: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

58: OZF_Volume_Offer_disc_PVT.Update_vo_discount(
59: p_api_version_number => 1.0
60: , p_init_msg_list => FND_API.G_FALSE
61: , p_commit => FND_API.G_FALSE
62: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
63: , x_return_status => x_return_status
64: , x_msg_count => x_msg_count
65: , x_msg_data => x_msg_data
66: , p_vo_disc_rec => l_vo_disc_rec

Line 87: x_return_status := FND_API.G_RET_STS_SUCCESS;

83: BEGIN
84: -- initialize return status
85: -- loop thru. all adjustment tiers
86: -- for each adjustment tier update the discount line and handle exception
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88: FOR l_adjustmentTiers IN c_adjustmentTiers(cp_offerAdjustmentId => p_offerAdjustmentId)
89: LOOP
90: update_vo_tier
91: (

Line 98: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

94: , x_msg_data => x_msg_data
95: , p_offerDiscountLineId => l_adjustmentTiers.offer_discount_line_id
96: , p_offerAdjustmentId => p_offerAdjustmentId
97: );
98: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
99: RAISE FND_API.G_EXC_ERROR;
100: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;

Line 99: RAISE FND_API.G_EXC_ERROR;

95: , p_offerDiscountLineId => l_adjustmentTiers.offer_discount_line_id
96: , p_offerAdjustmentId => p_offerAdjustmentId
97: );
98: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
99: RAISE FND_API.G_EXC_ERROR;
100: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103: END LOOP;

Line 100: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

96: , p_offerAdjustmentId => p_offerAdjustmentId
97: );
98: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
99: RAISE FND_API.G_EXC_ERROR;
100: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103: END LOOP;
104: END update_adj_vo_tiers;

Line 101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

97: );
98: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
99: RAISE FND_API.G_EXC_ERROR;
100: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103: END LOOP;
104: END update_adj_vo_tiers;
105:

Line 162: x_return_status := FND_API.G_RET_STS_SUCCESS;

158: x_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
159: l_request_line_id NUMBER;
160:
161: BEGIN
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
163: -- retrieve end_date into local record
164: -- initialize record
165: -- populate record
166: -- call process_qp_list_lines

Line 194: p_init_msg_list => FND_API.G_FALSE,

190: l_qualifiers_tbl(1).qualifier_attr_value_to := null ;
191: l_qualifiers_tbl(1).comparison_operator_code := '=' ;
192: l_qualifiers_tbl(1).qualifier_grouping_no := -1 ;
193: OZF_OFFER_PVT.process_market_qualifiers(
194: p_init_msg_list => FND_API.G_FALSE,
195: p_api_version => 1.0,
196: p_commit => FND_API.G_FALSE,
197: x_return_status => x_return_status,
198: x_msg_count => x_msg_count,

Line 196: p_commit => FND_API.G_FALSE,

192: l_qualifiers_tbl(1).qualifier_grouping_no := -1 ;
193: OZF_OFFER_PVT.process_market_qualifiers(
194: p_init_msg_list => FND_API.G_FALSE,
195: p_api_version => 1.0,
196: p_commit => FND_API.G_FALSE,
197: x_return_status => x_return_status,
198: x_msg_count => x_msg_count,
199: x_msg_data => x_msg_data,
200: p_qualifiers_tbl=> l_qualifiers_tbl,

Line 230: p_init_msg_list => FND_API.G_FALSE,

226:
227: END LOOP;
228: QP_Modifiers_PUB.process_modifiers(
229: p_api_version_number => 1.0,
230: p_init_msg_list => FND_API.G_FALSE,
231: p_return_values => FND_API.G_FALSE,
232: x_return_status => x_return_status,
233: x_msg_count => x_msg_count,
234: x_msg_data => x_msg_data,

Line 231: p_return_values => FND_API.G_FALSE,

227: END LOOP;
228: QP_Modifiers_PUB.process_modifiers(
229: p_api_version_number => 1.0,
230: p_init_msg_list => FND_API.G_FALSE,
231: p_return_values => FND_API.G_FALSE,
232: x_return_status => x_return_status,
233: x_msg_count => x_msg_count,
234: x_msg_data => x_msg_data,
235: p_modifiers_tbl => l_modifier_line_tbl,

Line 263: x_return_status := FND_API.G_RET_STS_SUCCESS;

259: WHERE a.offer_discount_line_id = b.offer_discount_line_id
260: AND b.parent_discount_line_id = c.offer_discount_line_id
261: AND a.offer_adjustment_id = cp_offerAdjustmentId;
262: BEGIN
263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264: FOR l_qpListLines IN c_qpListLines(cp_offerAdjustmentId => p_offerAdjustmentId) LOOP
265: end_qp_line
266: (
267: x_return_status => x_return_status

Line 273: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

269: ,x_msg_data => x_msg_data
270: ,p_listLineId => l_qpListLines.list_line_id
271: ,p_offerAdjustmentId => p_offerAdjustmentId
272: );
273: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
274: RAISE FND_API.G_EXC_ERROR;
275: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;

Line 274: RAISE FND_API.G_EXC_ERROR;

270: ,p_listLineId => l_qpListLines.list_line_id
271: ,p_offerAdjustmentId => p_offerAdjustmentId
272: );
273: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
274: RAISE FND_API.G_EXC_ERROR;
275: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278: END LOOP;

Line 275: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

271: ,p_offerAdjustmentId => p_offerAdjustmentId
272: );
273: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
274: RAISE FND_API.G_EXC_ERROR;
275: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278: END LOOP;
279: END end_date_qp_lines;

Line 276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

272: );
273: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
274: RAISE FND_API.G_EXC_ERROR;
275: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278: END LOOP;
279: END end_date_qp_lines;
280:

Line 412: --x_return_status := FND_API.G_RET_STS_SUCCESS;

408: FROM qp_pricing_attributes a
409: WHERE a.list_line_id = cp_listLineId;
410: i NUMBER := null;
411: BEGIN
412: --x_return_status := FND_API.G_RET_STS_SUCCESS;
413: x_pricing_attr_tbl.delete;
414: i := 1;
415: FOR l_pricingAttributes in c_pricingAttributes(cp_listLineId => p_list_line_id) LOOP
416: --dbms_output.put_line('ist line id :'||p_list_line_id||' :index :'||P_INDEX||' : Attr Value :'||l_pricingAttributes.product_attr_value||': Excluder :'||l_pricingAttributes.excluder_flag);

Line 446: x_return_status := FND_API.G_RET_STS_SUCCESS;

442: )
443: IS
444: BEGIN
445: --dbms_output.put_line('IN populate pbh line');
446: x_return_status := FND_API.G_RET_STS_SUCCESS;
447: x_modifier_line_tbl.delete;
448: x_pricing_attr_tbl.delete;
449: x_modifier_line_tbl(1).operation := QP_GLOBALS.G_OPR_CREATE;
450: x_modifier_line_tbl(1).list_line_type_code := 'PBH';

Line 575: x_return_status := FND_API.G_RET_STS_SUCCESS;

571: */
572: i NUMBER;
573: l_pricingAttrTbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
574: BEGIN
575: x_return_status := FND_API.G_RET_STS_SUCCESS;
576: x_modifier_line_tbl.delete;
577: x_pricing_attr_tbl.delete;
578: l_pricingAttrTbl.delete;
579:

Line 635: x_return_status := FND_API.G_RET_STS_SUCCESS;

631: FROM ozf_offer_adjustments_b a
632: WHERE a.offer_adjustment_id = cp_offerAdjustmentId;
633: l_additionalDetails c_additionalDetails%ROWTYPE;
634: BEGIN
635: x_return_status := FND_API.G_RET_STS_SUCCESS;
636: -- initialize table
637: -- populate pbh line
638: -- populate dis lines
639: -- merge the dis lines with pbh lines

Line 654: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

650: , p_listLineId => p_listLineId
651: , x_modifier_line_tbl => pbh_modifier_line_tbl
652: , x_pricing_attr_tbl => pbh_pricing_attr_tbl
653: );
654: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
655: RAISE FND_API.G_EXC_ERROR;
656: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END IF;

Line 655: RAISE FND_API.G_EXC_ERROR;

651: , x_modifier_line_tbl => pbh_modifier_line_tbl
652: , x_pricing_attr_tbl => pbh_pricing_attr_tbl
653: );
654: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
655: RAISE FND_API.G_EXC_ERROR;
656: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END IF;
659: OPEN c_additionalDetails(cp_offerAdjustmentId => p_offerAdjustmentId);

Line 656: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

652: , x_pricing_attr_tbl => pbh_pricing_attr_tbl
653: );
654: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
655: RAISE FND_API.G_EXC_ERROR;
656: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END IF;
659: OPEN c_additionalDetails(cp_offerAdjustmentId => p_offerAdjustmentId);
660: FETCH c_additionalDetails INTO l_additionalDetails;

Line 657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

653: );
654: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
655: RAISE FND_API.G_EXC_ERROR;
656: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END IF;
659: OPEN c_additionalDetails(cp_offerAdjustmentId => p_offerAdjustmentId);
660: FETCH c_additionalDetails INTO l_additionalDetails;
661: CLOSE c_additionalDetails;

Line 674: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

670: , p_offerAdjustmentId => p_offerAdjustmentId
671: , x_modifier_line_tbl => dis_modifier_line_tbl
672: , x_pricing_attr_tbl => dis_pricing_attr_tbl
673: );
674: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
675: RAISE FND_API.G_EXC_ERROR;
676: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
678: END IF;

Line 675: RAISE FND_API.G_EXC_ERROR;

671: , x_modifier_line_tbl => dis_modifier_line_tbl
672: , x_pricing_attr_tbl => dis_pricing_attr_tbl
673: );
674: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
675: RAISE FND_API.G_EXC_ERROR;
676: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
678: END IF;
679: merge_modifiers

Line 676: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

672: , x_pricing_attr_tbl => dis_pricing_attr_tbl
673: );
674: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
675: RAISE FND_API.G_EXC_ERROR;
676: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
678: END IF;
679: merge_modifiers
680: (

Line 677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

673: );
674: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
675: RAISE FND_API.G_EXC_ERROR;
676: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
678: END IF;
679: merge_modifiers
680: (
681: p_to_modifier_line_tbl => pbh_modifier_line_tbl

Line 743: x_return_status := FND_API.G_RET_STS_SUCCESS;

739: -- initialize return status, nested tables
740: -- for given adjustment id get the adjustment tiers
741: -- populate the qp_list_lines using the tiers and adjustment tiers
742: -- create the QP list lines
743: x_return_status := FND_API.G_RET_STS_SUCCESS;
744: x_modifier_line_tbl.delete;
745: x_pricing_attr_tbl.delete;
746: l_modifier_line_tbl.delete;
747: l_pricing_attr_tbl.delete;

Line 758: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

754: , p_listLineId => p_listLineId --l_tierHeader.list_line_id
755: , x_modifier_line_tbl => l_modifier_line_tbl
756: , x_pricing_attr_tbl => l_pricing_attr_tbl
757: );
758: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
759: RAISE FND_API.G_EXC_ERROR;
760: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: END IF;

Line 759: RAISE FND_API.G_EXC_ERROR;

755: , x_modifier_line_tbl => l_modifier_line_tbl
756: , x_pricing_attr_tbl => l_pricing_attr_tbl
757: );
758: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
759: RAISE FND_API.G_EXC_ERROR;
760: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: END IF;
763: QP_Modifiers_PUB.process_modifiers(

Line 760: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

756: , x_pricing_attr_tbl => l_pricing_attr_tbl
757: );
758: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
759: RAISE FND_API.G_EXC_ERROR;
760: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: END IF;
763: QP_Modifiers_PUB.process_modifiers(
764: p_api_version_number => 1.0,

Line 761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

757: );
758: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
759: RAISE FND_API.G_EXC_ERROR;
760: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: END IF;
763: QP_Modifiers_PUB.process_modifiers(
764: p_api_version_number => 1.0,
765: p_init_msg_list => FND_API.G_FALSE,

Line 765: p_init_msg_list => FND_API.G_FALSE,

761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: END IF;
763: QP_Modifiers_PUB.process_modifiers(
764: p_api_version_number => 1.0,
765: p_init_msg_list => FND_API.G_FALSE,
766: p_return_values => FND_API.G_FALSE,
767: x_return_status => x_return_status,
768: x_msg_count => x_msg_count,
769: x_msg_data => x_msg_data,

Line 766: p_return_values => FND_API.G_FALSE,

762: END IF;
763: QP_Modifiers_PUB.process_modifiers(
764: p_api_version_number => 1.0,
765: p_init_msg_list => FND_API.G_FALSE,
766: p_return_values => FND_API.G_FALSE,
767: x_return_status => x_return_status,
768: x_msg_count => x_msg_count,
769: x_msg_data => x_msg_data,
770: p_modifiers_tbl => l_modifier_line_tbl,

Line 781: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

777: x_qualifiers_val_tbl => v_qualifiers_val_tbl,
778: x_pricing_attr_tbl => v_pricing_attr_tbl,
779: x_pricing_attr_val_tbl => v_pricing_attr_val_tbl
780: );
781: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
782: RAISE FND_API.G_EXC_ERROR;
783: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: END IF;

Line 782: RAISE FND_API.G_EXC_ERROR;

778: x_pricing_attr_tbl => v_pricing_attr_tbl,
779: x_pricing_attr_val_tbl => v_pricing_attr_val_tbl
780: );
781: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
782: RAISE FND_API.G_EXC_ERROR;
783: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: END IF;
786: x_modifier_line_tbl := v_modifiers_tbl;

Line 783: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

779: x_pricing_attr_val_tbl => v_pricing_attr_val_tbl
780: );
781: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
782: RAISE FND_API.G_EXC_ERROR;
783: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: END IF;
786: x_modifier_line_tbl := v_modifiers_tbl;
787: x_pricing_attr_tbl := v_pricing_attr_tbl;

Line 784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

780: );
781: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
782: RAISE FND_API.G_EXC_ERROR;
783: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: END IF;
786: x_modifier_line_tbl := v_modifiers_tbl;
787: x_pricing_attr_tbl := v_pricing_attr_tbl;
788: --dbms_output.put_line('Table sizes 1 are :'||v_modifiers_tbl.count||' : '||v_pricing_attr_tbl.count);

Line 834: x_return_status := FND_API.G_RET_STS_SUCCESS;

830: -- loop thru the Discount Structure
831: -- for each discount line loop thru. the qp_modifiers table
832: -- check for discount equality, in case yes insert into ozf_qp_discounts table
833: -- similar thing for relating products
834: x_return_status := FND_API.G_RET_STS_SUCCESS;
835: --dbms_output.put_line('Map Ozf qp lines');
836: --dbms_output.put_line('Table counts are :'||p_modifier_line_tbl.count||' : '||p_pricing_attr_tbl.count);
837: FOR l_discounts in c_discounts(cp_offerDiscountLineId => p_offerDiscountLineId , cp_offerAdjustmentId => p_offerAdjustmentId)
838: LOOP

Line 856: , p_init_msg_list => FND_API.G_FALSE

852: l_qpDiscountsRec.start_date := sysdate;
853: OZF_QP_DISCOUNTS_PVT. Create_ozf_qp_discount
854: (
855: p_api_version_number => 1.0
856: , p_init_msg_list => FND_API.G_FALSE
857: , p_commit => FND_API.G_FALSE
858: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
859: , x_return_status => x_return_status
860: , x_msg_count => x_msg_count

Line 857: , p_commit => FND_API.G_FALSE

853: OZF_QP_DISCOUNTS_PVT. Create_ozf_qp_discount
854: (
855: p_api_version_number => 1.0
856: , p_init_msg_list => FND_API.G_FALSE
857: , p_commit => FND_API.G_FALSE
858: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
859: , x_return_status => x_return_status
860: , x_msg_count => x_msg_count
861: , x_msg_data => x_msg_data

Line 858: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

854: (
855: p_api_version_number => 1.0
856: , p_init_msg_list => FND_API.G_FALSE
857: , p_commit => FND_API.G_FALSE
858: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
859: , x_return_status => x_return_status
860: , x_msg_count => x_msg_count
861: , x_msg_data => x_msg_data
862: , p_qp_disc_rec => l_qpDiscountsRec

Line 865: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

861: , x_msg_data => x_msg_data
862: , p_qp_disc_rec => l_qpDiscountsRec
863: , x_qp_discount_id => l_qpDiscountId
864: );
865: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
866: RAISE FND_API.G_EXC_ERROR;
867: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
869: END IF;

Line 866: RAISE FND_API.G_EXC_ERROR;

862: , p_qp_disc_rec => l_qpDiscountsRec
863: , x_qp_discount_id => l_qpDiscountId
864: );
865: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
866: RAISE FND_API.G_EXC_ERROR;
867: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
869: END IF;
870: ELSE

Line 867: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

863: , x_qp_discount_id => l_qpDiscountId
864: );
865: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
866: RAISE FND_API.G_EXC_ERROR;
867: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
869: END IF;
870: ELSE
871: null;

Line 868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

864: );
865: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
866: RAISE FND_API.G_EXC_ERROR;
867: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
869: END IF;
870: ELSE
871: null;
872: --dbms_output.put_line('No Discounts found for list line id:'||p_modifier_line_tbl(i).list_line_id||':'||l_discounts.offer_discount_line_id);

Line 893: , p_init_msg_list => FND_API.G_FALSE

889: l_qpProductsRec.off_discount_product_id := l_products.off_discount_product_id;
890: l_qpProductsRec.pricing_attribute_id := p_pricing_attr_tbl(i).pricing_attribute_id;
891: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(
892: p_api_version_number => 1.0
893: , p_init_msg_list => FND_API.G_FALSE
894: , p_commit => FND_API.G_FALSE
895: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
896: , x_return_status => x_return_status
897: , x_msg_count => x_msg_count

Line 894: , p_commit => FND_API.G_FALSE

890: l_qpProductsRec.pricing_attribute_id := p_pricing_attr_tbl(i).pricing_attribute_id;
891: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(
892: p_api_version_number => 1.0
893: , p_init_msg_list => FND_API.G_FALSE
894: , p_commit => FND_API.G_FALSE
895: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
896: , x_return_status => x_return_status
897: , x_msg_count => x_msg_count
898: , x_msg_data => x_msg_data

Line 895: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

891: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(
892: p_api_version_number => 1.0
893: , p_init_msg_list => FND_API.G_FALSE
894: , p_commit => FND_API.G_FALSE
895: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
896: , x_return_status => x_return_status
897: , x_msg_count => x_msg_count
898: , x_msg_data => x_msg_data
899: , p_qp_product_rec => l_qpProductsRec

Line 902: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

898: , x_msg_data => x_msg_data
899: , p_qp_product_rec => l_qpProductsRec
900: , x_qp_product_id => l_qpProductId
901: );
902: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
903: RAISE FND_API.G_EXC_ERROR;
904: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
906: END IF;

Line 903: RAISE FND_API.G_EXC_ERROR;

899: , p_qp_product_rec => l_qpProductsRec
900: , x_qp_product_id => l_qpProductId
901: );
902: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
903: RAISE FND_API.G_EXC_ERROR;
904: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
906: END IF;
907: ELSE

Line 904: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

900: , x_qp_product_id => l_qpProductId
901: );
902: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
903: RAISE FND_API.G_EXC_ERROR;
904: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
906: END IF;
907: ELSE
908: null;

Line 905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

901: );
902: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
903: RAISE FND_API.G_EXC_ERROR;
904: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
906: END IF;
907: ELSE
908: null;
909: --dbms_output.put_line('No Products found for pricing_attribute :'||p_pricing_attr_tbl(i).pricing_attribute_id||' : '||l_products.off_discount_product_id);

Line 946: x_return_status := FND_API.G_RET_STS_SUCCESS;

942: -- initialize
943: -- get all the tier Headers for which adjustments have been entered
944: -- for each tier header create QP Data, corresponding to data already entered in QP
945: -- merge the modifier tables created for each discount
946: x_return_status := FND_API.G_RET_STS_SUCCESS;
947: x_modifier_line_tbl.delete;
948: x_pricing_attr_tbl.delete;
949: FOR l_tierHeader in c_tierHeader(cp_offerAdjustmentId => p_offerAdjustmentId)
950: LOOP

Line 964: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

960: , x_modifier_line_tbl => l_modifier_line_tbl
961: , x_pricing_attr_tbl => l_pricing_attr_tbl
962: );
963: --dbms_output.put_line('Table sizes 3 are :'||l_modifier_line_tbl.count||' : '||l_pricing_attr_tbl.count);
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: , x_pricing_attr_tbl => l_pricing_attr_tbl
962: );
963: --dbms_output.put_line('Table sizes 3 are :'||l_modifier_line_tbl.count||' : '||l_pricing_attr_tbl.count);
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: map_ozf_qp_lines

Line 966: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

962: );
963: --dbms_output.put_line('Table sizes 3 are :'||l_modifier_line_tbl.count||' : '||l_pricing_attr_tbl.count);
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: map_ozf_qp_lines
970: (

Line 967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

963: --dbms_output.put_line('Table sizes 3 are :'||l_modifier_line_tbl.count||' : '||l_pricing_attr_tbl.count);
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: map_ozf_qp_lines
970: (
971: x_return_status => x_return_status

Line 1017: x_return_status := FND_API.G_RET_STS_SUCCESS;

1013: , x_msg_data OUT NOCOPY VARCHAR2
1014: )
1015: IS
1016: BEGIN
1017: x_return_status := FND_API.G_RET_STS_SUCCESS;
1018: INSERT INTO ozf_offer_adj_rltd_lines
1019: (
1020: OFFER_ADJ_RLTD_LINE_ID
1021: , OFFER_ADJUSTMENT_ID

Line 1048: x_return_status := Fnd_Api.g_ret_sts_error ;

1044: , null
1045: );
1046: EXCEPTION
1047: WHEN OTHERS THEN
1048: x_return_status := Fnd_Api.g_ret_sts_error ;
1049: END relate_lines;
1050:
1051: PROCEDURE relate_lines
1052: (

Line 1061: x_return_status := FND_API.G_RET_STS_SUCCESS;

1057: , x_msg_data OUT NOCOPY VARCHAR2
1058: )
1059: IS
1060: BEGIN
1061: x_return_status := FND_API.G_RET_STS_SUCCESS;
1062: IF nvl(p_modifiers_tbl.count,0) > 0 THEN
1063: FOR k IN p_modifiers_tbl.first .. p_modifiers_tbl.last LOOP
1064: IF p_modifiers_tbl.exists(k) THEN
1065: IF p_modifiers_tbl(k).operation <> 'CREATE' THEN

Line 1068: IF p_modifiers_tbl(k).comments IS NULL OR p_modifiers_tbl(k).comments = FND_API.G_MISS_CHAR THEN

1064: IF p_modifiers_tbl.exists(k) THEN
1065: IF p_modifiers_tbl(k).operation <> 'CREATE' THEN
1066: null;
1067: ELSE
1068: IF p_modifiers_tbl(k).comments IS NULL OR p_modifiers_tbl(k).comments = FND_API.G_MISS_CHAR THEN
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: return;
1071: ELSE
1072: relate_lines

Line 1069: x_return_status := FND_API.G_RET_STS_ERROR;

1065: IF p_modifiers_tbl(k).operation <> 'CREATE' THEN
1066: null;
1067: ELSE
1068: IF p_modifiers_tbl(k).comments IS NULL OR p_modifiers_tbl(k).comments = FND_API.G_MISS_CHAR THEN
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: return;
1071: ELSE
1072: relate_lines
1073: (

Line 1081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1077: , x_return_status => x_return_status
1078: , x_msg_count => x_return_status
1079: , x_msg_data => x_return_status
1080: );
1081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1082: return;
1083: END IF;
1084: END IF;
1085: END IF;

Line 1091: x_return_status := FND_API.G_RET_STS_ERROR;

1087: END LOOP;
1088: END IF;
1089: EXCEPTION
1090: WHEN OTHERS THEN
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092: return;
1093: END relate_lines;
1094:
1095:

Line 1107: x_return_status := FND_API.G_RET_STS_SUCCESS;

1103: IS
1104: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1105: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
1106: BEGIN
1107: x_return_status := FND_API.G_RET_STS_SUCCESS;
1108: /*
1109: Corresponding to the discount changes, update the tier definitions.
1110: End Date the QP List lines corresponding to the tier definitions changed.
1111: Create new QP List lines with the updated tier definitions.(1)[1]

Line 1122: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1118: ,x_msg_count => x_msg_count
1119: ,x_msg_data => x_msg_data
1120: ,p_offerAdjustmentId => p_offerAdjustmentId
1121: );
1122: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1123: RAISE FND_API.G_EXC_ERROR;
1124: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: END IF;

Line 1123: RAISE FND_API.G_EXC_ERROR;

1119: ,x_msg_data => x_msg_data
1120: ,p_offerAdjustmentId => p_offerAdjustmentId
1121: );
1122: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1123: RAISE FND_API.G_EXC_ERROR;
1124: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: END IF;
1127: end_date_qp_lines

Line 1124: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1120: ,p_offerAdjustmentId => p_offerAdjustmentId
1121: );
1122: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1123: RAISE FND_API.G_EXC_ERROR;
1124: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: END IF;
1127: end_date_qp_lines
1128: (

Line 1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1121: );
1122: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1123: RAISE FND_API.G_EXC_ERROR;
1124: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: END IF;
1127: end_date_qp_lines
1128: (
1129: x_return_status => x_return_status

Line 1134: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1130: ,x_msg_count => x_msg_count
1131: ,x_msg_data => x_msg_data
1132: ,p_offerAdjustmentId => p_offerAdjustmentId
1133: );
1134: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1138: END IF;

Line 1135: RAISE FND_API.G_EXC_ERROR;

1131: ,x_msg_data => x_msg_data
1132: ,p_offerAdjustmentId => p_offerAdjustmentId
1133: );
1134: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1138: END IF;
1139: create_new_qp_lines

Line 1136: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1132: ,p_offerAdjustmentId => p_offerAdjustmentId
1133: );
1134: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1138: END IF;
1139: create_new_qp_lines
1140: (

Line 1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1133: );
1134: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1138: END IF;
1139: create_new_qp_lines
1140: (
1141: x_return_status => x_return_status

Line 1148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1144: ,p_offerAdjustmentId => p_offerAdjustmentId
1145: , x_modifier_line_tbl => l_modifier_line_tbl
1146: , x_pricing_attr_tbl => l_pricing_attr_tbl
1147: );
1148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;

Line 1149: RAISE FND_API.G_EXC_ERROR;

1145: , x_modifier_line_tbl => l_modifier_line_tbl
1146: , x_pricing_attr_tbl => l_pricing_attr_tbl
1147: );
1148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;
1153: relate_lines

Line 1150: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1146: , x_pricing_attr_tbl => l_pricing_attr_tbl
1147: );
1148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;
1153: relate_lines
1154: (

Line 1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1147: );
1148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152: END IF;
1153: relate_lines
1154: (
1155: p_modifiers_tbl => l_modifier_line_tbl

Line 1161: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1157: , x_return_status => x_return_status
1158: ,x_msg_count => x_msg_count
1159: , x_msg_data => x_msg_data
1160: );
1161: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1162: RAISE FND_API.G_EXC_ERROR;
1163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1165: END IF;

Line 1162: RAISE FND_API.G_EXC_ERROR;

1158: ,x_msg_count => x_msg_count
1159: , x_msg_data => x_msg_data
1160: );
1161: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1162: RAISE FND_API.G_EXC_ERROR;
1163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1165: END IF;
1166: EXCEPTION

Line 1163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1159: , x_msg_data => x_msg_data
1160: );
1161: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1162: RAISE FND_API.G_EXC_ERROR;
1163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1165: END IF;
1166: EXCEPTION
1167: WHEN FND_API.G_EXC_ERROR THEN

Line 1164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1160: );
1161: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1162: RAISE FND_API.G_EXC_ERROR;
1163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1165: END IF;
1166: EXCEPTION
1167: WHEN FND_API.G_EXC_ERROR THEN
1168: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1167: WHEN FND_API.G_EXC_ERROR THEN

1163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1165: END IF;
1166: EXCEPTION
1167: WHEN FND_API.G_EXC_ERROR THEN
1168: x_return_status := FND_API.G_RET_STS_ERROR;
1169: -- Standard call to get message count and if count=1, get the message
1170: FND_MSG_PUB.Count_And_Get (
1171: p_encoded => FND_API.G_FALSE,

Line 1168: x_return_status := FND_API.G_RET_STS_ERROR;

1164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1165: END IF;
1166: EXCEPTION
1167: WHEN FND_API.G_EXC_ERROR THEN
1168: x_return_status := FND_API.G_RET_STS_ERROR;
1169: -- Standard call to get message count and if count=1, get the message
1170: FND_MSG_PUB.Count_And_Get (
1171: p_encoded => FND_API.G_FALSE,
1172: p_count => x_msg_count,

Line 1171: p_encoded => FND_API.G_FALSE,

1167: WHEN FND_API.G_EXC_ERROR THEN
1168: x_return_status := FND_API.G_RET_STS_ERROR;
1169: -- Standard call to get message count and if count=1, get the message
1170: FND_MSG_PUB.Count_And_Get (
1171: p_encoded => FND_API.G_FALSE,
1172: p_count => x_msg_count,
1173: p_data => x_msg_data
1174: );
1175: OE_MSG_PUB.Count_And_Get (

Line 1176: p_encoded => FND_API.G_FALSE,

1172: p_count => x_msg_count,
1173: p_data => x_msg_data
1174: );
1175: OE_MSG_PUB.Count_And_Get (
1176: p_encoded => FND_API.G_FALSE,
1177: p_count => x_msg_count,
1178: p_data => x_msg_data
1179: );
1180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1176: p_encoded => FND_API.G_FALSE,
1177: p_count => x_msg_count,
1178: p_data => x_msg_data
1179: );
1180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1182: -- Standard call to get message count and if count=1, get the message
1183: FND_MSG_PUB.Count_And_Get (
1184: p_encoded => FND_API.G_FALSE,

Line 1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1177: p_count => x_msg_count,
1178: p_data => x_msg_data
1179: );
1180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1182: -- Standard call to get message count and if count=1, get the message
1183: FND_MSG_PUB.Count_And_Get (
1184: p_encoded => FND_API.G_FALSE,
1185: p_count => x_msg_count,

Line 1184: p_encoded => FND_API.G_FALSE,

1180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1182: -- Standard call to get message count and if count=1, get the message
1183: FND_MSG_PUB.Count_And_Get (
1184: p_encoded => FND_API.G_FALSE,
1185: p_count => x_msg_count,
1186: p_data => x_msg_data
1187: );
1188: OE_MSG_PUB.Count_And_Get (

Line 1189: p_encoded => FND_API.G_FALSE,

1185: p_count => x_msg_count,
1186: p_data => x_msg_data
1187: );
1188: OE_MSG_PUB.Count_And_Get (
1189: p_encoded => FND_API.G_FALSE,
1190: p_count => x_msg_count,
1191: p_data => x_msg_data
1192: );
1193: WHEN OTHERS THEN

Line 1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1190: p_count => x_msg_count,
1191: p_data => x_msg_data
1192: );
1193: WHEN OTHERS THEN
1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1195: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1196: THEN
1197: FND_MSG_PUB.Add_Exc_Msg( 'VOLUME_OFFER_ADJ','adjust_old_discounts');
1198: END IF;

Line 1201: p_encoded => FND_API.G_FALSE,

1197: FND_MSG_PUB.Add_Exc_Msg( 'VOLUME_OFFER_ADJ','adjust_old_discounts');
1198: END IF;
1199: -- Standard call to get message count and if count=1, get the message
1200: FND_MSG_PUB.Count_And_Get (
1201: p_encoded => FND_API.G_FALSE,
1202: p_count => x_msg_count,
1203: p_data => x_msg_data
1204: );
1205: OE_MSG_PUB.Count_And_Get (

Line 1206: p_encoded => FND_API.G_FALSE,

1202: p_count => x_msg_count,
1203: p_data => x_msg_data
1204: );
1205: OE_MSG_PUB.Count_And_Get (
1206: p_encoded => FND_API.G_FALSE,
1207: p_count => x_msg_count,
1208: p_data => x_msg_data
1209: );
1210:

Line 1245: x_return_status := FND_API.G_RET_STS_SUCCESS;

1241:
1242: l_productsRec OZF_Volume_Offer_disc_PVT.vo_prod_rec_type;
1243: l_objId NUMBER;
1244: BEGIN
1245: x_return_status := FND_API.G_RET_STS_SUCCESS;
1246: FOR l_products in c_products(cp_offerAdjustmentId => p_offerAdjustmentId) LOOP
1247: l_productsRec := null;
1248: l_productsRec.excluder_flag := l_products.excluder_flag;
1249: l_productsRec.offer_discount_line_id := l_products.offer_discount_line_id;

Line 1259: , p_init_msg_list => FND_API.G_FALSE

1255: l_productsRec.include_volume_flag := l_products.include_volume_flag;
1256:
1257: OZF_Volume_Offer_disc_PVT.Create_vo_Product(
1258: p_api_version_number => 1.0
1259: , p_init_msg_list => FND_API.G_FALSE
1260: , p_commit => FND_API.G_FALSE
1261: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1262: , x_return_status => x_return_status
1263: , x_msg_count => x_msg_count

Line 1260: , p_commit => FND_API.G_FALSE

1256:
1257: OZF_Volume_Offer_disc_PVT.Create_vo_Product(
1258: p_api_version_number => 1.0
1259: , p_init_msg_list => FND_API.G_FALSE
1260: , p_commit => FND_API.G_FALSE
1261: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1262: , x_return_status => x_return_status
1263: , x_msg_count => x_msg_count
1264: , x_msg_data => x_msg_data

Line 1261: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1257: OZF_Volume_Offer_disc_PVT.Create_vo_Product(
1258: p_api_version_number => 1.0
1259: , p_init_msg_list => FND_API.G_FALSE
1260: , p_commit => FND_API.G_FALSE
1261: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1262: , x_return_status => x_return_status
1263: , x_msg_count => x_msg_count
1264: , x_msg_data => x_msg_data
1265: , p_vo_prod_rec => l_productsRec

Line 1268: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1264: , x_msg_data => x_msg_data
1265: , p_vo_prod_rec => l_productsRec
1266: , x_off_discount_product_id => l_objId
1267: );
1268: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1269: RAISE FND_API.G_EXC_ERROR;
1270: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: END IF;

Line 1269: RAISE FND_API.G_EXC_ERROR;

1265: , p_vo_prod_rec => l_productsRec
1266: , x_off_discount_product_id => l_objId
1267: );
1268: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1269: RAISE FND_API.G_EXC_ERROR;
1270: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: END IF;
1273: --dbms_output.put_line('Created Product successfully:'||l_objId);

Line 1270: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1266: , x_off_discount_product_id => l_objId
1267: );
1268: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1269: RAISE FND_API.G_EXC_ERROR;
1270: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: END IF;
1273: --dbms_output.put_line('Created Product successfully:'||l_objId);
1274: --dbms_output.put_line('Updating :'||l_products.offer_adjustment_product_id);

Line 1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1267: );
1268: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1269: RAISE FND_API.G_EXC_ERROR;
1270: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1272: END IF;
1273: --dbms_output.put_line('Created Product successfully:'||l_objId);
1274: --dbms_output.put_line('Updating :'||l_products.offer_adjustment_product_id);
1275: UPDATE ozf_offer_adjustment_products

Line 1283: x_return_status := FND_API.G_RET_STS_ERROR;

1279:
1280: END LOOP;
1281: EXCEPTION
1282: WHEN OTHERS THEN
1283: x_return_status := FND_API.G_RET_STS_ERROR;
1284: -- Standard call to get message count and if count=1, get the message
1285: FND_MSG_PUB.Count_And_Get (
1286: p_encoded => FND_API.G_FALSE,
1287: p_count => x_msg_count,

Line 1286: p_encoded => FND_API.G_FALSE,

1282: WHEN OTHERS THEN
1283: x_return_status := FND_API.G_RET_STS_ERROR;
1284: -- Standard call to get message count and if count=1, get the message
1285: FND_MSG_PUB.Count_And_Get (
1286: p_encoded => FND_API.G_FALSE,
1287: p_count => x_msg_count,
1288: p_data => x_msg_data
1289: );
1290:

Line 1318: --x_return_status := FND_API.G_RET_STS_SUCCESS;

1314: FROM qp_list_lines
1315: WHERE list_header_id = cp_listHeaderId
1316: AND rownum < 2;
1317: BEGIN
1318: --x_return_status := FND_API.G_RET_STS_SUCCESS;
1319: FOR l_advOptions IN c_advOptions(cp_listHeaderId => p_listHeaderId ) LOOP
1320: x_modifiers_rec.print_on_invoice_flag := l_advOptions.print_on_invoice_flag;
1321: x_modifiers_rec.accrual_flag := l_advOptions.accrual_flag;
1322: x_modifiers_rec.pricing_phase_id := l_advOptions.pricing_phase_id;

Line 1366: --x_return_status := FND_API.G_RET_STS_SUCCESS;

1362: AND a.offer_id = b.offer_id
1363: AND b.qp_list_header_id = c.list_header_id
1364: AND a.parent_discount_line_id = d.offer_discount_line_id(+);
1365: BEGIN
1366: --x_return_status := FND_API.G_RET_STS_SUCCESS;
1367: FOR l_discountDetails IN c_discountDetails(cp_offerDiscountLineId => p_offerDiscountLineId) LOOP
1368: x_modifiers_rec.list_header_id := l_discountDetails.list_header_id;
1369: x_modifiers_rec.end_date_active := null;
1370: x_modifiers_rec.arithmetic_operator := l_discountDetails.discount_type;

Line 1409: x_return_status := FND_API.G_RET_STS_SUCCESS;

1405: )
1406: IS
1407: BEGIN
1408: --dbms_output.put_line('IN populate pbh line');
1409: x_return_status := FND_API.G_RET_STS_SUCCESS;
1410: x_modifier_line_tbl.delete;
1411: --dbms_output.put_line('Before populate discounts1');
1412: x_modifier_line_tbl(1).operation := QP_GLOBALS.G_OPR_CREATE;
1413: x_modifier_line_tbl(1).list_line_type_code := 'PBH';

Line 1445: x_return_status := FND_API.G_RET_STS_SUCCESS;

1441: FROM ozf_offer_discount_lines b , ozf_offer_discount_lines a
1442: WHERE b.offer_discount_line_id = cp_offerDiscountLineId
1443: AND b.parent_discount_line_id = a.offer_discount_line_id(+);
1444: BEGIN
1445: x_return_status := FND_API.G_RET_STS_SUCCESS;
1446: for l_pricingAttr in c_pricingAttr(cp_offerDiscountLineId => p_offerDiscountLineId) LOOP
1447: x_pricing_attr_rec.product_uom_code := l_pricingAttr.uom_code;
1448: x_pricing_attr_rec.pricing_attr_value_from := l_pricingAttr.volume_from;
1449: x_pricing_attr_rec.pricing_attr_value_to := l_pricingAttr.volume_to;

Line 1507: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1503: , p_offerDiscountLineId => p_offerDiscountLineId
1504: , x_pricing_attr_rec => x_pricing_attr_rec
1505: , p_index => 2
1506: );
1507: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1508: RAISE FND_API.G_EXC_ERROR;
1509: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1511: END IF;

Line 1508: RAISE FND_API.G_EXC_ERROR;

1504: , x_pricing_attr_rec => x_pricing_attr_rec
1505: , p_index => 2
1506: );
1507: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1508: RAISE FND_API.G_EXC_ERROR;
1509: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1511: END IF;
1512: x_modifier_line_rec.operand := 0;

Line 1509: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1505: , p_index => 2
1506: );
1507: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1508: RAISE FND_API.G_EXC_ERROR;
1509: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1511: END IF;
1512: x_modifier_line_rec.operand := 0;
1513: x_modifier_line_rec.comments:= -1;

Line 1510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1506: );
1507: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1508: RAISE FND_API.G_EXC_ERROR;
1509: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1511: END IF;
1512: x_modifier_line_rec.operand := 0;
1513: x_modifier_line_rec.comments:= -1;
1514: x_pricing_attr_rec.pricing_attr_value_from := '0';

Line 1540: x_return_status := FND_API.G_RET_STS_SUCCESS;

1536: AND b.off_discount_product_id = cp_offDiscountProductId;
1537:
1538: i NUMBER;
1539: BEGIN
1540: x_return_status := FND_API.G_RET_STS_SUCCESS;
1541: x_modifier_line_tbl.delete;
1542: x_pricing_attr_tbl.delete;
1543: i := 2;
1544: IF getMinVolumeFrom(p_offDiscountProductId => p_offDiscountProductId) IS NOT NULL AND getMinVolumeFrom(p_offDiscountProductId => p_offDiscountProductId) > 0 THEN

Line 1613: x_return_status := FND_API.G_RET_STS_SUCCESS;

1609: l_pbh_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
1610: l_dis_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1611: l_pbh_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_Tbl_type;
1612: BEGIN
1613: x_return_status := FND_API.G_RET_STS_SUCCESS;
1614: x_modifier_line_tbl.delete;
1615: x_pricing_attr_tbl.delete;
1616: l_dis_modifier_line_tbl.delete;
1617: l_pbh_modifier_line_tbl.delete;

Line 1628: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1624: , x_msg_data => x_msg_data
1625: , p_offerDiscountLineId => p_offerDiscountLineId
1626: , x_modifier_line_tbl => l_pbh_modifier_line_tbl
1627: );
1628: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1629: RAISE FND_API.G_EXC_ERROR;
1630: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1632: END IF;

Line 1629: RAISE FND_API.G_EXC_ERROR;

1625: , p_offerDiscountLineId => p_offerDiscountLineId
1626: , x_modifier_line_tbl => l_pbh_modifier_line_tbl
1627: );
1628: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1629: RAISE FND_API.G_EXC_ERROR;
1630: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1632: END IF;
1633: l_pbh_pricing_attr_tbl(1) := p_pricing_attr_rec;

Line 1630: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1626: , x_modifier_line_tbl => l_pbh_modifier_line_tbl
1627: );
1628: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1629: RAISE FND_API.G_EXC_ERROR;
1630: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1632: END IF;
1633: l_pbh_pricing_attr_tbl(1) := p_pricing_attr_rec;
1634: --dbms_output.put_line('l_pbh_pricing_attr_tbl(1) := p_pricing_attr_rec;'||l_pbh_pricing_attr_tbl(1).product_attr_value);

Line 1631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1627: );
1628: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1629: RAISE FND_API.G_EXC_ERROR;
1630: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1632: END IF;
1633: l_pbh_pricing_attr_tbl(1) := p_pricing_attr_rec;
1634: --dbms_output.put_line('l_pbh_pricing_attr_tbl(1) := p_pricing_attr_rec;'||l_pbh_pricing_attr_tbl(1).product_attr_value);
1635: l_pbh_pricing_attr_tbl(1).modifiers_index := 1;

Line 1657: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1653: , x_modifier_line_tbl => l_dis_modifier_line_tbl
1654: , p_pricing_attr_rec => p_pricing_attr_rec
1655: , x_pricing_attr_tbl => l_dis_pricing_attr_tbl
1656: );
1657: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1658: RAISE FND_API.G_EXC_ERROR;
1659: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1661: END IF;

Line 1658: RAISE FND_API.G_EXC_ERROR;

1654: , p_pricing_attr_rec => p_pricing_attr_rec
1655: , x_pricing_attr_tbl => l_dis_pricing_attr_tbl
1656: );
1657: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1658: RAISE FND_API.G_EXC_ERROR;
1659: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1661: END IF;
1662: --dbms_output.put_line('After populate_dis_line');

Line 1659: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1655: , x_pricing_attr_tbl => l_dis_pricing_attr_tbl
1656: );
1657: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1658: RAISE FND_API.G_EXC_ERROR;
1659: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1661: END IF;
1662: --dbms_output.put_line('After populate_dis_line');
1663: merge_modifiers

Line 1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1656: );
1657: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1658: RAISE FND_API.G_EXC_ERROR;
1659: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1661: END IF;
1662: --dbms_output.put_line('After populate_dis_line');
1663: merge_modifiers
1664: (

Line 1706: --x_return_status := FND_API.G_RET_STS_SUCCESS;

1702: FROM
1703: ozf_offer_discount_products
1704: WHERE off_discount_product_id = cp_offDiscountProductId;
1705: BEGIN
1706: --x_return_status := FND_API.G_RET_STS_SUCCESS;
1707: x_pricing_attr_rec := null;
1708: --dbms_output.put_line('Product Id :'||p_offDiscountProductId);
1709: FOR l_productAttributes IN c_productAttributes(cp_offDiscountProductId => p_offDiscountProductId) LOOP
1710: x_pricing_attr_rec := null;

Line 1711: x_pricing_attr_rec.pricing_attribute_id := FND_API.G_MISS_NUM;

1707: x_pricing_attr_rec := null;
1708: --dbms_output.put_line('Product Id :'||p_offDiscountProductId);
1709: FOR l_productAttributes IN c_productAttributes(cp_offDiscountProductId => p_offDiscountProductId) LOOP
1710: x_pricing_attr_rec := null;
1711: x_pricing_attr_rec.pricing_attribute_id := FND_API.G_MISS_NUM;
1712: x_pricing_attr_rec.attribute_grouping_no := FND_API.G_MISS_NUM;
1713: x_pricing_attr_rec.product_attribute_context := l_productAttributes.product_context;
1714: x_pricing_attr_rec.product_attribute := l_productAttributes.product_attribute;
1715: x_pricing_attr_rec.product_attr_value := l_productAttributes.product_attr_value;

Line 1712: x_pricing_attr_rec.attribute_grouping_no := FND_API.G_MISS_NUM;

1708: --dbms_output.put_line('Product Id :'||p_offDiscountProductId);
1709: FOR l_productAttributes IN c_productAttributes(cp_offDiscountProductId => p_offDiscountProductId) LOOP
1710: x_pricing_attr_rec := null;
1711: x_pricing_attr_rec.pricing_attribute_id := FND_API.G_MISS_NUM;
1712: x_pricing_attr_rec.attribute_grouping_no := FND_API.G_MISS_NUM;
1713: x_pricing_attr_rec.product_attribute_context := l_productAttributes.product_context;
1714: x_pricing_attr_rec.product_attribute := l_productAttributes.product_attribute;
1715: x_pricing_attr_rec.product_attr_value := l_productAttributes.product_attr_value;
1716: -- x_pricing_attr_rec.product_uom_code := l_pricingAttributes.product_uom_code;

Line 1756: x_return_status := FND_API.G_RET_STS_SUCCESS;

1752: l_objectVersion NUMBER;
1753: l_prodObjectVersion NUMBER;
1754:
1755: BEGIN
1756: x_return_status := FND_API.G_RET_STS_SUCCESS;
1757: FOR i IN p_modifiers_tbl.first .. p_modifiers_tbl.last LOOP
1758: IF p_modifiers_tbl.exists(i) THEN
1759: IF p_modifiers_tbl(i).comments <> -1 THEN
1760: --dbms_output.put_line('Disocunt Mapping:'||i||' : '||p_modifiers_tbl(i).comments||' : '||p_modifiers_tbl(i).list_line_id);

Line 1768: , p_init_msg_list => FND_API.G_FALSE

1764: l_qpDiscountsRec.start_date := sysdate;
1765: OZF_QP_DISCOUNTS_PVT.Create_ozf_qp_discount
1766: (
1767: p_api_version_number => 1.0
1768: , p_init_msg_list => FND_API.G_FALSE
1769: , p_commit => FND_API.G_FALSE
1770: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1771: , x_return_status => x_return_status
1772: , x_msg_count => x_msg_count

Line 1769: , p_commit => FND_API.G_FALSE

1765: OZF_QP_DISCOUNTS_PVT.Create_ozf_qp_discount
1766: (
1767: p_api_version_number => 1.0
1768: , p_init_msg_list => FND_API.G_FALSE
1769: , p_commit => FND_API.G_FALSE
1770: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1771: , x_return_status => x_return_status
1772: , x_msg_count => x_msg_count
1773: , x_msg_data => x_msg_data

Line 1770: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1766: (
1767: p_api_version_number => 1.0
1768: , p_init_msg_list => FND_API.G_FALSE
1769: , p_commit => FND_API.G_FALSE
1770: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1771: , x_return_status => x_return_status
1772: , x_msg_count => x_msg_count
1773: , x_msg_data => x_msg_data
1774: , p_qp_disc_rec => l_qpDiscountsRec

Line 1777: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1773: , x_msg_data => x_msg_data
1774: , p_qp_disc_rec => l_qpDiscountsRec
1775: , x_qp_discount_id => l_qpDiscountId
1776: );
1777: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1778: RAISE FND_API.G_EXC_ERROR;
1779: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1781: END IF;

Line 1778: RAISE FND_API.G_EXC_ERROR;

1774: , p_qp_disc_rec => l_qpDiscountsRec
1775: , x_qp_discount_id => l_qpDiscountId
1776: );
1777: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1778: RAISE FND_API.G_EXC_ERROR;
1779: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1781: END IF;
1782: END IF;

Line 1779: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1775: , x_qp_discount_id => l_qpDiscountId
1776: );
1777: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1778: RAISE FND_API.G_EXC_ERROR;
1779: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1781: END IF;
1782: END IF;
1783: END IF;

Line 1780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1776: );
1777: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1778: RAISE FND_API.G_EXC_ERROR;
1779: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1781: END IF;
1782: END IF;
1783: END IF;
1784: END LOOP;

Line 1793: , p_init_msg_list => FND_API.G_FALSE

1789: l_qpProductsRec.off_discount_product_id := p_offDiscountProductId;
1790: l_qpProductsRec.pricing_attribute_id := p_pricing_attr_tbl(i).pricing_attribute_id;
1791: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(
1792: p_api_version_number => 1.0
1793: , p_init_msg_list => FND_API.G_FALSE
1794: , p_commit => FND_API.G_FALSE
1795: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1796: , x_return_status => x_return_status
1797: , x_msg_count => x_msg_count

Line 1794: , p_commit => FND_API.G_FALSE

1790: l_qpProductsRec.pricing_attribute_id := p_pricing_attr_tbl(i).pricing_attribute_id;
1791: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(
1792: p_api_version_number => 1.0
1793: , p_init_msg_list => FND_API.G_FALSE
1794: , p_commit => FND_API.G_FALSE
1795: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1796: , x_return_status => x_return_status
1797: , x_msg_count => x_msg_count
1798: , x_msg_data => x_msg_data

Line 1795: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1791: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(
1792: p_api_version_number => 1.0
1793: , p_init_msg_list => FND_API.G_FALSE
1794: , p_commit => FND_API.G_FALSE
1795: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1796: , x_return_status => x_return_status
1797: , x_msg_count => x_msg_count
1798: , x_msg_data => x_msg_data
1799: , p_qp_product_rec => l_qpProductsRec

Line 1802: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1798: , x_msg_data => x_msg_data
1799: , p_qp_product_rec => l_qpProductsRec
1800: , x_qp_product_id => l_qpProductId
1801: );
1802: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1803: RAISE FND_API.G_EXC_ERROR;
1804: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1806: END IF;

Line 1803: RAISE FND_API.G_EXC_ERROR;

1799: , p_qp_product_rec => l_qpProductsRec
1800: , x_qp_product_id => l_qpProductId
1801: );
1802: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1803: RAISE FND_API.G_EXC_ERROR;
1804: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1806: END IF;
1807: END IF;

Line 1804: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1800: , x_qp_product_id => l_qpProductId
1801: );
1802: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1803: RAISE FND_API.G_EXC_ERROR;
1804: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1806: END IF;
1807: END IF;
1808: END LOOP;

Line 1805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1801: );
1802: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1803: RAISE FND_API.G_EXC_ERROR;
1804: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1806: END IF;
1807: END IF;
1808: END LOOP;
1809: END map_ozf_qp_data;

Line 1827: x_return_status := FND_API.G_RET_STS_SUCCESS;

1823: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;
1824: l_qpProductId NUMBER;
1825: l_prodObjectVersion NUMBER;
1826: BEGIN
1827: x_return_status := FND_API.G_RET_STS_SUCCESS;
1828: FOR i in p_pricing_attr_tbl.first .. p_pricing_attr_tbl.last LOOP
1829: IF p_pricing_attr_tbl.exists(i) THEN
1830: l_qpProductsRec := null;
1831: l_qpProductsRec.off_discount_product_id := p_offDiscountProductId;

Line 1835: , p_init_msg_list => FND_API.G_FALSE

1831: l_qpProductsRec.off_discount_product_id := p_offDiscountProductId;
1832: l_qpProductsRec.pricing_attribute_id := p_pricing_attr_tbl(i).pricing_attribute_id;
1833: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(
1834: p_api_version_number => 1.0
1835: , p_init_msg_list => FND_API.G_FALSE
1836: , p_commit => FND_API.G_FALSE
1837: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1838: , x_return_status => x_return_status
1839: , x_msg_count => x_msg_count

Line 1836: , p_commit => FND_API.G_FALSE

1832: l_qpProductsRec.pricing_attribute_id := p_pricing_attr_tbl(i).pricing_attribute_id;
1833: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(
1834: p_api_version_number => 1.0
1835: , p_init_msg_list => FND_API.G_FALSE
1836: , p_commit => FND_API.G_FALSE
1837: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1838: , x_return_status => x_return_status
1839: , x_msg_count => x_msg_count
1840: , x_msg_data => x_msg_data

Line 1837: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1833: OZF_QP_PRODUCTS_PVT.Create_ozf_qp_product(
1834: p_api_version_number => 1.0
1835: , p_init_msg_list => FND_API.G_FALSE
1836: , p_commit => FND_API.G_FALSE
1837: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1838: , x_return_status => x_return_status
1839: , x_msg_count => x_msg_count
1840: , x_msg_data => x_msg_data
1841: , p_qp_product_rec => l_qpProductsRec

Line 1844: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1840: , x_msg_data => x_msg_data
1841: , p_qp_product_rec => l_qpProductsRec
1842: , x_qp_product_id => l_qpProductId
1843: );
1844: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1845: RAISE FND_API.G_EXC_ERROR;
1846: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1848: END IF;

Line 1845: RAISE FND_API.G_EXC_ERROR;

1841: , p_qp_product_rec => l_qpProductsRec
1842: , x_qp_product_id => l_qpProductId
1843: );
1844: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1845: RAISE FND_API.G_EXC_ERROR;
1846: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1848: END IF;
1849: END IF;

Line 1846: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1842: , x_qp_product_id => l_qpProductId
1843: );
1844: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1845: RAISE FND_API.G_EXC_ERROR;
1846: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1848: END IF;
1849: END IF;
1850: END LOOP;

Line 1847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1843: );
1844: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1845: RAISE FND_API.G_EXC_ERROR;
1846: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1848: END IF;
1849: END IF;
1850: END LOOP;
1851: END map_ozf_qp_products;

Line 1888: x_return_status := FND_API.G_RET_STS_SUCCESS;

1884: -- initialize
1885: -- retrieve all the qp_list_lines corresponding to the discount structure to which the exclusion is added.
1886: -- exclude this new product from all the qp discount structures.
1887: -- map the newly created qp_pricing_attributes to this exclusion product.
1888: x_return_status := FND_API.G_RET_STS_SUCCESS;
1889: l_pricing_attr_tbl.delete;
1890: i := 1;
1891: FOR l_qpListLines IN c_qpListLines(cp_offDiscountProductId => p_offDiscountProductId) LOOP
1892: l_pricing_attr_tbl(i).product_attribute_context := 'ITEM';

Line 1904: p_init_msg_list => FND_API.G_TRUE,

1900: i := i + 1;
1901: END LOOP;
1902: QP_Modifiers_PUB.process_modifiers(
1903: p_api_version_number => 1.0,
1904: p_init_msg_list => FND_API.G_TRUE,
1905: p_return_values => FND_API.G_TRUE,
1906: x_return_status => x_return_status,
1907: x_msg_count => x_msg_count,
1908: x_msg_data => x_msg_data,

Line 1905: p_return_values => FND_API.G_TRUE,

1901: END LOOP;
1902: QP_Modifiers_PUB.process_modifiers(
1903: p_api_version_number => 1.0,
1904: p_init_msg_list => FND_API.G_TRUE,
1905: p_return_values => FND_API.G_TRUE,
1906: x_return_status => x_return_status,
1907: x_msg_count => x_msg_count,
1908: x_msg_data => x_msg_data,
1909: p_pricing_attr_tbl => l_pricing_attr_tbl,

Line 1919: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1915: x_qualifiers_val_tbl => v_qualifiers_val_tbl,
1916: x_pricing_attr_tbl => v_pricing_attr_tbl,
1917: x_pricing_attr_val_tbl => v_pricing_attr_val_tbl
1918: );
1919: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1920: RAISE FND_API.G_EXC_ERROR;
1921: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1923: END IF;

Line 1920: RAISE FND_API.G_EXC_ERROR;

1916: x_pricing_attr_tbl => v_pricing_attr_tbl,
1917: x_pricing_attr_val_tbl => v_pricing_attr_val_tbl
1918: );
1919: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1920: RAISE FND_API.G_EXC_ERROR;
1921: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1923: END IF;
1924: map_ozf_qp_products

Line 1921: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1917: x_pricing_attr_val_tbl => v_pricing_attr_val_tbl
1918: );
1919: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1920: RAISE FND_API.G_EXC_ERROR;
1921: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1923: END IF;
1924: map_ozf_qp_products
1925: (

Line 1922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1918: );
1919: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1920: RAISE FND_API.G_EXC_ERROR;
1921: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1923: END IF;
1924: map_ozf_qp_products
1925: (
1926: p_offDiscountProductId => p_offDiscountProductId

Line 1932: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1928: , x_return_status => x_return_status
1929: , x_msg_count => x_msg_count
1930: , x_msg_data => x_msg_data
1931: );
1932: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1933: RAISE FND_API.G_EXC_ERROR;
1934: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1936: END IF;

Line 1933: RAISE FND_API.G_EXC_ERROR;

1929: , x_msg_count => x_msg_count
1930: , x_msg_data => x_msg_data
1931: );
1932: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1933: RAISE FND_API.G_EXC_ERROR;
1934: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1936: END IF;
1937: END create_new_exclusions;

Line 1934: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1930: , x_msg_data => x_msg_data
1931: );
1932: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1933: RAISE FND_API.G_EXC_ERROR;
1934: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1936: END IF;
1937: END create_new_exclusions;
1938:

Line 1935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1931: );
1932: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1933: RAISE FND_API.G_EXC_ERROR;
1934: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1936: END IF;
1937: END create_new_exclusions;
1938:
1939: /**

Line 1961: x_return_status := FND_API.G_RET_STS_SUCCESS;

1957: FROM ozf_offer_adjustments_b
1958: WHERE offer_adjustment_id = cp_offerAdjustmentId;
1959: l_adjDetails c_adjDetails%ROWTYPE;
1960: BEGIN
1961: x_return_status := FND_API.G_RET_STS_SUCCESS;
1962: OPEN c_adjDetails(cp_offerAdjustmentId => p_offerAdjustmentId);
1963: FETCH c_adjDetails INTO l_adjDetails;
1964: CLOSE c_adjDetails;
1965: IF nvl(px_modifier_line_tbl.count,0) > 0 THEN

Line 2027: x_return_status := FND_API.G_RET_STS_SUCCESS;

2023: -- query new products entered using adjustments.
2024: -- for each new product id get the offer_discount_line_id
2025: -- create the whole discount structure for the product
2026: -- map the new ozf_qp lines and products
2027: x_return_status := FND_API.G_RET_STS_SUCCESS;
2028: i := 1;
2029: l_modifier_line_tbl.delete;
2030: l_pricing_attr_tbl.delete;
2031: FOR l_products IN c_products(cp_offerAdjustmentId => p_offerAdjustmentId) LOOP

Line 2043: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2039: x_pricing_attr_rec => l_pricing_attr_rec
2040: , p_offDiscountProductId => l_products.off_discount_product_id
2041: -- , p_index IN NUMBER
2042: );
2043: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2044: RAISE FND_API.G_EXC_ERROR;
2045: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2047: END IF;

Line 2044: RAISE FND_API.G_EXC_ERROR;

2040: , p_offDiscountProductId => l_products.off_discount_product_id
2041: -- , p_index IN NUMBER
2042: );
2043: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2044: RAISE FND_API.G_EXC_ERROR;
2045: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2047: END IF;
2048: populate_discounts

Line 2045: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2041: -- , p_index IN NUMBER
2042: );
2043: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2044: RAISE FND_API.G_EXC_ERROR;
2045: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2047: END IF;
2048: populate_discounts
2049: (

Line 2046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2042: );
2043: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2044: RAISE FND_API.G_EXC_ERROR;
2045: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2047: END IF;
2048: populate_discounts
2049: (
2050: x_return_status => x_return_status

Line 2059: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2055: , x_modifier_line_tbl => l_modifier_line_tbl
2056: , x_pricing_attr_tbl => l_pricing_attr_tbl
2057: , p_pricing_attr_rec => l_pricing_attr_rec
2058: );
2059: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2060: RAISE FND_API.G_EXC_ERROR;
2061: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2063: END IF;

Line 2060: RAISE FND_API.G_EXC_ERROR;

2056: , x_pricing_attr_tbl => l_pricing_attr_tbl
2057: , p_pricing_attr_rec => l_pricing_attr_rec
2058: );
2059: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2060: RAISE FND_API.G_EXC_ERROR;
2061: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2063: END IF;
2064: process_modifiers_for_adj

Line 2061: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2057: , p_pricing_attr_rec => l_pricing_attr_rec
2058: );
2059: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2060: RAISE FND_API.G_EXC_ERROR;
2061: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2063: END IF;
2064: process_modifiers_for_adj
2065: (

Line 2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2058: );
2059: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2060: RAISE FND_API.G_EXC_ERROR;
2061: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2063: END IF;
2064: process_modifiers_for_adj
2065: (
2066: x_return_status => x_return_status

Line 2072: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2068: , x_msg_data => x_msg_data
2069: , px_modifier_line_tbl => l_modifier_line_tbl
2070: , p_offerAdjustmentId => p_offerAdjustmentId
2071: );
2072: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2073: RAISE FND_API.G_EXC_ERROR;
2074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2076: END IF;

Line 2073: RAISE FND_API.G_EXC_ERROR;

2069: , px_modifier_line_tbl => l_modifier_line_tbl
2070: , p_offerAdjustmentId => p_offerAdjustmentId
2071: );
2072: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2073: RAISE FND_API.G_EXC_ERROR;
2074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2076: END IF;
2077: QP_Modifiers_PUB.process_modifiers(

Line 2074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2070: , p_offerAdjustmentId => p_offerAdjustmentId
2071: );
2072: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2073: RAISE FND_API.G_EXC_ERROR;
2074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2076: END IF;
2077: QP_Modifiers_PUB.process_modifiers(
2078: p_api_version_number => 1.0,

Line 2075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2071: );
2072: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2073: RAISE FND_API.G_EXC_ERROR;
2074: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2076: END IF;
2077: QP_Modifiers_PUB.process_modifiers(
2078: p_api_version_number => 1.0,
2079: p_init_msg_list => FND_API.G_TRUE,

Line 2079: p_init_msg_list => FND_API.G_TRUE,

2075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2076: END IF;
2077: QP_Modifiers_PUB.process_modifiers(
2078: p_api_version_number => 1.0,
2079: p_init_msg_list => FND_API.G_TRUE,
2080: p_return_values => FND_API.G_TRUE,
2081: x_return_status => x_return_status,
2082: x_msg_count => x_msg_count,
2083: x_msg_data => x_msg_data,

Line 2080: p_return_values => FND_API.G_TRUE,

2076: END IF;
2077: QP_Modifiers_PUB.process_modifiers(
2078: p_api_version_number => 1.0,
2079: p_init_msg_list => FND_API.G_TRUE,
2080: p_return_values => FND_API.G_TRUE,
2081: x_return_status => x_return_status,
2082: x_msg_count => x_msg_count,
2083: x_msg_data => x_msg_data,
2084: p_modifiers_tbl => l_modifier_line_tbl,

Line 2095: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2091: x_qualifiers_val_tbl => v_qualifiers_val_tbl,
2092: x_pricing_attr_tbl => v_pricing_attr_tbl,
2093: x_pricing_attr_val_tbl => v_pricing_attr_val_tbl
2094: );
2095: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2096: RAISE FND_API.G_EXC_ERROR;
2097: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2099: END IF;

Line 2096: RAISE FND_API.G_EXC_ERROR;

2092: x_pricing_attr_tbl => v_pricing_attr_tbl,
2093: x_pricing_attr_val_tbl => v_pricing_attr_val_tbl
2094: );
2095: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2096: RAISE FND_API.G_EXC_ERROR;
2097: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2099: END IF;
2100: --dbms_output.put_line('After Create QP Data');

Line 2097: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2093: x_pricing_attr_val_tbl => v_pricing_attr_val_tbl
2094: );
2095: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2096: RAISE FND_API.G_EXC_ERROR;
2097: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2099: END IF;
2100: --dbms_output.put_line('After Create QP Data');
2101:

Line 2098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2094: );
2095: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2096: RAISE FND_API.G_EXC_ERROR;
2097: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2098: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2099: END IF;
2100: --dbms_output.put_line('After Create QP Data');
2101:
2102: map_ozf_qp_data

Line 2122: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2118: , x_return_status => x_return_status
2119: , x_msg_count => x_msg_count
2120: , x_msg_data => x_msg_data
2121: );
2122: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2123: RAISE FND_API.G_EXC_ERROR;
2124: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2126: END IF;

Line 2123: RAISE FND_API.G_EXC_ERROR;

2119: , x_msg_count => x_msg_count
2120: , x_msg_data => x_msg_data
2121: );
2122: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2123: RAISE FND_API.G_EXC_ERROR;
2124: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2126: END IF;
2127: END LOOP;

Line 2124: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2120: , x_msg_data => x_msg_data
2121: );
2122: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2123: RAISE FND_API.G_EXC_ERROR;
2124: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2126: END IF;
2127: END LOOP;
2128: --dbms_output.put_line('End Create new qp products');

Line 2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2121: );
2122: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2123: RAISE FND_API.G_EXC_ERROR;
2124: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2126: END IF;
2127: END LOOP;
2128: --dbms_output.put_line('End Create new qp products');
2129:

Line 2146: x_return_status := FND_API.G_RET_STS_SUCCESS;

2142: IS
2143: l_modifier_line_tbl QP_MODIFIERS_PUB.Modifiers_Tbl_Type;
2144: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
2145: BEGIN
2146: x_return_status := FND_API.G_RET_STS_SUCCESS;
2147: /*
2148: New Products are added to Particular discount tables, so discount table id is stored .
2149: Create new Product in OZF Tables
2150: Get the Discount table id for the new product and create QP list lines using the Discount table.(1)[1]

Line 2160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2156: ,x_msg_count => x_msg_count
2157: ,x_msg_data => x_msg_data
2158: ,p_offerAdjustmentId => p_offerAdjustmentId
2159: );
2160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2161: RAISE FND_API.G_EXC_ERROR;
2162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2164: END IF;

Line 2161: RAISE FND_API.G_EXC_ERROR;

2157: ,x_msg_data => x_msg_data
2158: ,p_offerAdjustmentId => p_offerAdjustmentId
2159: );
2160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2161: RAISE FND_API.G_EXC_ERROR;
2162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2164: END IF;
2165: create_new_qp_products

Line 2162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2158: ,p_offerAdjustmentId => p_offerAdjustmentId
2159: );
2160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2161: RAISE FND_API.G_EXC_ERROR;
2162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2164: END IF;
2165: create_new_qp_products
2166: (

Line 2163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2159: );
2160: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2161: RAISE FND_API.G_EXC_ERROR;
2162: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2164: END IF;
2165: create_new_qp_products
2166: (
2167: x_return_status => x_return_status

Line 2174: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2170: ,p_offerAdjustmentId => p_offerAdjustmentId
2171: , x_modifier_line_tbl => l_modifier_line_tbl
2172: , x_pricing_attr_tbl => l_pricing_attr_tbl
2173: );
2174: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2175: RAISE FND_API.G_EXC_ERROR;
2176: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2178: END IF;

Line 2175: RAISE FND_API.G_EXC_ERROR;

2171: , x_modifier_line_tbl => l_modifier_line_tbl
2172: , x_pricing_attr_tbl => l_pricing_attr_tbl
2173: );
2174: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2175: RAISE FND_API.G_EXC_ERROR;
2176: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2178: END IF;
2179: EXCEPTION

Line 2176: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2172: , x_pricing_attr_tbl => l_pricing_attr_tbl
2173: );
2174: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2175: RAISE FND_API.G_EXC_ERROR;
2176: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2178: END IF;
2179: EXCEPTION
2180: WHEN FND_API.G_EXC_ERROR THEN

Line 2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2173: );
2174: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2175: RAISE FND_API.G_EXC_ERROR;
2176: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2178: END IF;
2179: EXCEPTION
2180: WHEN FND_API.G_EXC_ERROR THEN
2181: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2180: WHEN FND_API.G_EXC_ERROR THEN

2176: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2178: END IF;
2179: EXCEPTION
2180: WHEN FND_API.G_EXC_ERROR THEN
2181: x_return_status := FND_API.G_RET_STS_ERROR;
2182: -- Standard call to get message count and if count=1, get the message
2183: FND_MSG_PUB.Count_And_Get (
2184: p_encoded => FND_API.G_FALSE,

Line 2181: x_return_status := FND_API.G_RET_STS_ERROR;

2177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2178: END IF;
2179: EXCEPTION
2180: WHEN FND_API.G_EXC_ERROR THEN
2181: x_return_status := FND_API.G_RET_STS_ERROR;
2182: -- Standard call to get message count and if count=1, get the message
2183: FND_MSG_PUB.Count_And_Get (
2184: p_encoded => FND_API.G_FALSE,
2185: p_count => x_msg_count,

Line 2184: p_encoded => FND_API.G_FALSE,

2180: WHEN FND_API.G_EXC_ERROR THEN
2181: x_return_status := FND_API.G_RET_STS_ERROR;
2182: -- Standard call to get message count and if count=1, get the message
2183: FND_MSG_PUB.Count_And_Get (
2184: p_encoded => FND_API.G_FALSE,
2185: p_count => x_msg_count,
2186: p_data => x_msg_data
2187: );
2188:

Line 2189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2185: p_count => x_msg_count,
2186: p_data => x_msg_data
2187: );
2188:
2189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2191: -- Standard call to get message count and if count=1, get the message
2192: FND_MSG_PUB.Count_And_Get (
2193: p_encoded => FND_API.G_FALSE,

Line 2190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2186: p_data => x_msg_data
2187: );
2188:
2189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2191: -- Standard call to get message count and if count=1, get the message
2192: FND_MSG_PUB.Count_And_Get (
2193: p_encoded => FND_API.G_FALSE,
2194: p_count => x_msg_count,

Line 2193: p_encoded => FND_API.G_FALSE,

2189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2191: -- Standard call to get message count and if count=1, get the message
2192: FND_MSG_PUB.Count_And_Get (
2193: p_encoded => FND_API.G_FALSE,
2194: p_count => x_msg_count,
2195: p_data => x_msg_data
2196: );
2197:

Line 2199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2195: p_data => x_msg_data
2196: );
2197:
2198: WHEN OTHERS THEN
2199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2200: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2201: THEN
2202: FND_MSG_PUB.Add_Exc_Msg( 'VOLUME_OFFER_ADJ','adjust_new_products');
2203: END IF;

Line 2206: p_encoded => FND_API.G_FALSE,

2202: FND_MSG_PUB.Add_Exc_Msg( 'VOLUME_OFFER_ADJ','adjust_new_products');
2203: END IF;
2204: -- Standard call to get message count and if count=1, get the message
2205: FND_MSG_PUB.Count_And_Get (
2206: p_encoded => FND_API.G_FALSE,
2207: p_count => x_msg_count,
2208: p_data => x_msg_data
2209: );
2210: END adjust_new_products;

Line 2220: p_init_msg_list IN VARCHAR2 := FND_API.g_false

2216: Then it processes the new products added thru. the adjustment.
2217: */
2218: PROCEDURE process_vo_adjustments
2219: (
2220: p_init_msg_list IN VARCHAR2 := FND_API.g_false
2221: ,p_api_version IN NUMBER
2222: ,p_commit IN VARCHAR2 := FND_API.g_false
2223: ,x_return_status OUT NOCOPY VARCHAR2
2224: ,x_msg_count OUT NOCOPY NUMBER

Line 2222: ,p_commit IN VARCHAR2 := FND_API.g_false

2218: PROCEDURE process_vo_adjustments
2219: (
2220: p_init_msg_list IN VARCHAR2 := FND_API.g_false
2221: ,p_api_version IN NUMBER
2222: ,p_commit IN VARCHAR2 := FND_API.g_false
2223: ,x_return_status OUT NOCOPY VARCHAR2
2224: ,x_msg_count OUT NOCOPY NUMBER
2225: ,x_msg_data OUT NOCOPY VARCHAR2
2226: ,p_offerAdjustmentId IN NUMBER

Line 2233: x_return_status := FND_API.G_RET_STS_SUCCESS;

2229: BEGIN
2230: -- initialize
2231: -- process discount changes
2232: -- process product additions.
2233: x_return_status := FND_API.G_RET_STS_SUCCESS;
2234:
2235: adjust_old_discounts
2236: (
2237: x_return_status => x_return_status

Line 2242: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2238: ,x_msg_count => x_msg_count
2239: ,x_msg_data => x_msg_data
2240: ,p_offerAdjustmentId => p_offerAdjustmentId
2241: );
2242: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2243: RAISE FND_API.G_EXC_ERROR;
2244: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2246: END IF;

Line 2243: RAISE FND_API.G_EXC_ERROR;

2239: ,x_msg_data => x_msg_data
2240: ,p_offerAdjustmentId => p_offerAdjustmentId
2241: );
2242: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2243: RAISE FND_API.G_EXC_ERROR;
2244: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2246: END IF;
2247: adjust_new_products

Line 2244: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2240: ,p_offerAdjustmentId => p_offerAdjustmentId
2241: );
2242: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2243: RAISE FND_API.G_EXC_ERROR;
2244: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2246: END IF;
2247: adjust_new_products
2248: (

Line 2245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2241: );
2242: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2243: RAISE FND_API.G_EXC_ERROR;
2244: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2246: END IF;
2247: adjust_new_products
2248: (
2249: x_return_status => x_return_status

Line 2254: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2250: ,x_msg_count => x_msg_count
2251: ,x_msg_data => x_msg_data
2252: ,p_offerAdjustmentId => p_offerAdjustmentId
2253: );
2254: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2255: RAISE FND_API.G_EXC_ERROR;
2256: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2258: END IF;

Line 2255: RAISE FND_API.G_EXC_ERROR;

2251: ,x_msg_data => x_msg_data
2252: ,p_offerAdjustmentId => p_offerAdjustmentId
2253: );
2254: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2255: RAISE FND_API.G_EXC_ERROR;
2256: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2258: END IF;
2259: END process_vo_adjustments;

Line 2256: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2252: ,p_offerAdjustmentId => p_offerAdjustmentId
2253: );
2254: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2255: RAISE FND_API.G_EXC_ERROR;
2256: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2258: END IF;
2259: END process_vo_adjustments;
2260: END OZF_VOLUME_OFFER_ADJ;

Line 2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2253: );
2254: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2255: RAISE FND_API.G_EXC_ERROR;
2256: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2258: END IF;
2259: END process_vo_adjustments;
2260: END OZF_VOLUME_OFFER_ADJ;