[Home] [Help]
89: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type
90: )
91: IS
92: BEGIN
93: p_modifier_line_rec.list_line_id := FND_API.g_miss_num;
94: p_modifier_line_rec.pricing_attribute_id := FND_API.g_miss_num;
95: END complete_rec_for_create;
96:
97:
90: )
91: IS
92: BEGIN
93: p_modifier_line_rec.list_line_id := FND_API.g_miss_num;
94: p_modifier_line_rec.pricing_attribute_id := FND_API.g_miss_num;
95: END complete_rec_for_create;
96:
97:
98: PROCEDURE populate_volume_offer(p_list_line_rec IN offadj_new_line_rec_type,
167: p_modifier_line_rec.ORDER_VALUE_TO := p_list_line_rec.order_value_to;
168: p_modifier_line_rec.QUALIFIER_ID := p_list_line_rec.qualifier_id;
169:
170:
171: p_modifier_line_rec.QD_OPERAND:= Fnd_Api.g_miss_num;
172: p_modifier_line_rec.QD_ARITHMETIC_OPERATOR:= Fnd_Api.g_miss_char;
173: p_modifier_line_rec.QD_RELATED_DEAL_LINES_ID:= Fnd_Api.g_miss_num;
174: p_modifier_line_rec.QD_OBJECT_VERSION_NUMBER:= Fnd_Api.g_miss_num;
175: p_modifier_line_rec.QD_ESTIMATED_QTY_IS_MAX:= Fnd_Api.g_miss_char;
168: p_modifier_line_rec.QUALIFIER_ID := p_list_line_rec.qualifier_id;
169:
170:
171: p_modifier_line_rec.QD_OPERAND:= Fnd_Api.g_miss_num;
172: p_modifier_line_rec.QD_ARITHMETIC_OPERATOR:= Fnd_Api.g_miss_char;
173: p_modifier_line_rec.QD_RELATED_DEAL_LINES_ID:= Fnd_Api.g_miss_num;
174: p_modifier_line_rec.QD_OBJECT_VERSION_NUMBER:= Fnd_Api.g_miss_num;
175: p_modifier_line_rec.QD_ESTIMATED_QTY_IS_MAX:= Fnd_Api.g_miss_char;
176: p_modifier_line_rec.QD_LIST_LINE_ID := Fnd_Api.g_miss_num;
169:
170:
171: p_modifier_line_rec.QD_OPERAND:= Fnd_Api.g_miss_num;
172: p_modifier_line_rec.QD_ARITHMETIC_OPERATOR:= Fnd_Api.g_miss_char;
173: p_modifier_line_rec.QD_RELATED_DEAL_LINES_ID:= Fnd_Api.g_miss_num;
174: p_modifier_line_rec.QD_OBJECT_VERSION_NUMBER:= Fnd_Api.g_miss_num;
175: p_modifier_line_rec.QD_ESTIMATED_QTY_IS_MAX:= Fnd_Api.g_miss_char;
176: p_modifier_line_rec.QD_LIST_LINE_ID := Fnd_Api.g_miss_num;
177: p_modifier_line_rec.QD_ESTIMATED_AMOUNT_IS_MAX := Fnd_Api.g_miss_char;
170:
171: p_modifier_line_rec.QD_OPERAND:= Fnd_Api.g_miss_num;
172: p_modifier_line_rec.QD_ARITHMETIC_OPERATOR:= Fnd_Api.g_miss_char;
173: p_modifier_line_rec.QD_RELATED_DEAL_LINES_ID:= Fnd_Api.g_miss_num;
174: p_modifier_line_rec.QD_OBJECT_VERSION_NUMBER:= Fnd_Api.g_miss_num;
175: p_modifier_line_rec.QD_ESTIMATED_QTY_IS_MAX:= Fnd_Api.g_miss_char;
176: p_modifier_line_rec.QD_LIST_LINE_ID := Fnd_Api.g_miss_num;
177: p_modifier_line_rec.QD_ESTIMATED_AMOUNT_IS_MAX := Fnd_Api.g_miss_char;
178: p_modifier_line_rec.ESTIM_GL_VALUE := Fnd_Api.g_miss_num;
171: p_modifier_line_rec.QD_OPERAND:= Fnd_Api.g_miss_num;
172: p_modifier_line_rec.QD_ARITHMETIC_OPERATOR:= Fnd_Api.g_miss_char;
173: p_modifier_line_rec.QD_RELATED_DEAL_LINES_ID:= Fnd_Api.g_miss_num;
174: p_modifier_line_rec.QD_OBJECT_VERSION_NUMBER:= Fnd_Api.g_miss_num;
175: p_modifier_line_rec.QD_ESTIMATED_QTY_IS_MAX:= Fnd_Api.g_miss_char;
176: p_modifier_line_rec.QD_LIST_LINE_ID := Fnd_Api.g_miss_num;
177: p_modifier_line_rec.QD_ESTIMATED_AMOUNT_IS_MAX := Fnd_Api.g_miss_char;
178: p_modifier_line_rec.ESTIM_GL_VALUE := Fnd_Api.g_miss_num;
179: p_modifier_line_rec.BENEFIT_PRICE_LIST_LINE_ID := p_list_line_rec.BENEFIT_PRICE_LIST_LINE_ID;
172: p_modifier_line_rec.QD_ARITHMETIC_OPERATOR:= Fnd_Api.g_miss_char;
173: p_modifier_line_rec.QD_RELATED_DEAL_LINES_ID:= Fnd_Api.g_miss_num;
174: p_modifier_line_rec.QD_OBJECT_VERSION_NUMBER:= Fnd_Api.g_miss_num;
175: p_modifier_line_rec.QD_ESTIMATED_QTY_IS_MAX:= Fnd_Api.g_miss_char;
176: p_modifier_line_rec.QD_LIST_LINE_ID := Fnd_Api.g_miss_num;
177: p_modifier_line_rec.QD_ESTIMATED_AMOUNT_IS_MAX := Fnd_Api.g_miss_char;
178: p_modifier_line_rec.ESTIM_GL_VALUE := Fnd_Api.g_miss_num;
179: p_modifier_line_rec.BENEFIT_PRICE_LIST_LINE_ID := p_list_line_rec.BENEFIT_PRICE_LIST_LINE_ID;
180: p_modifier_line_rec.BENEFIT_LIMIT := Fnd_Api.g_miss_num;
173: p_modifier_line_rec.QD_RELATED_DEAL_LINES_ID:= Fnd_Api.g_miss_num;
174: p_modifier_line_rec.QD_OBJECT_VERSION_NUMBER:= Fnd_Api.g_miss_num;
175: p_modifier_line_rec.QD_ESTIMATED_QTY_IS_MAX:= Fnd_Api.g_miss_char;
176: p_modifier_line_rec.QD_LIST_LINE_ID := Fnd_Api.g_miss_num;
177: p_modifier_line_rec.QD_ESTIMATED_AMOUNT_IS_MAX := Fnd_Api.g_miss_char;
178: p_modifier_line_rec.ESTIM_GL_VALUE := Fnd_Api.g_miss_num;
179: p_modifier_line_rec.BENEFIT_PRICE_LIST_LINE_ID := p_list_line_rec.BENEFIT_PRICE_LIST_LINE_ID;
180: p_modifier_line_rec.BENEFIT_LIMIT := Fnd_Api.g_miss_num;
181: p_modifier_line_rec.BENEFIT_QTY := p_list_line_rec.BENEFIT_QTY;
174: p_modifier_line_rec.QD_OBJECT_VERSION_NUMBER:= Fnd_Api.g_miss_num;
175: p_modifier_line_rec.QD_ESTIMATED_QTY_IS_MAX:= Fnd_Api.g_miss_char;
176: p_modifier_line_rec.QD_LIST_LINE_ID := Fnd_Api.g_miss_num;
177: p_modifier_line_rec.QD_ESTIMATED_AMOUNT_IS_MAX := Fnd_Api.g_miss_char;
178: p_modifier_line_rec.ESTIM_GL_VALUE := Fnd_Api.g_miss_num;
179: p_modifier_line_rec.BENEFIT_PRICE_LIST_LINE_ID := p_list_line_rec.BENEFIT_PRICE_LIST_LINE_ID;
180: p_modifier_line_rec.BENEFIT_LIMIT := Fnd_Api.g_miss_num;
181: p_modifier_line_rec.BENEFIT_QTY := p_list_line_rec.BENEFIT_QTY;
182: p_modifier_line_rec.BENEFIT_UOM_CODE := p_list_line_rec.BENEFIT_UOM_CODE;
176: p_modifier_line_rec.QD_LIST_LINE_ID := Fnd_Api.g_miss_num;
177: p_modifier_line_rec.QD_ESTIMATED_AMOUNT_IS_MAX := Fnd_Api.g_miss_char;
178: p_modifier_line_rec.ESTIM_GL_VALUE := Fnd_Api.g_miss_num;
179: p_modifier_line_rec.BENEFIT_PRICE_LIST_LINE_ID := p_list_line_rec.BENEFIT_PRICE_LIST_LINE_ID;
180: p_modifier_line_rec.BENEFIT_LIMIT := Fnd_Api.g_miss_num;
181: p_modifier_line_rec.BENEFIT_QTY := p_list_line_rec.BENEFIT_QTY;
182: p_modifier_line_rec.BENEFIT_UOM_CODE := p_list_line_rec.BENEFIT_UOM_CODE;
183: p_modifier_line_rec.SUBSTITUTION_CONTEXT := Fnd_Api.g_miss_char;
184: p_modifier_line_rec.SUBSTITUTION_ATTR := Fnd_Api.g_miss_char;
179: p_modifier_line_rec.BENEFIT_PRICE_LIST_LINE_ID := p_list_line_rec.BENEFIT_PRICE_LIST_LINE_ID;
180: p_modifier_line_rec.BENEFIT_LIMIT := Fnd_Api.g_miss_num;
181: p_modifier_line_rec.BENEFIT_QTY := p_list_line_rec.BENEFIT_QTY;
182: p_modifier_line_rec.BENEFIT_UOM_CODE := p_list_line_rec.BENEFIT_UOM_CODE;
183: p_modifier_line_rec.SUBSTITUTION_CONTEXT := Fnd_Api.g_miss_char;
184: p_modifier_line_rec.SUBSTITUTION_ATTR := Fnd_Api.g_miss_char;
185: p_modifier_line_rec.SUBSTITUTION_VAL := Fnd_Api.g_miss_char;
186: p_modifier_line_rec.PRICE_BREAK_TYPE_CODE := Fnd_Api.g_miss_char;
187: --p_modifier_line_rec.PRICING_ATTRIBUTE_ID:= Fnd_Api.g_miss_num;
180: p_modifier_line_rec.BENEFIT_LIMIT := Fnd_Api.g_miss_num;
181: p_modifier_line_rec.BENEFIT_QTY := p_list_line_rec.BENEFIT_QTY;
182: p_modifier_line_rec.BENEFIT_UOM_CODE := p_list_line_rec.BENEFIT_UOM_CODE;
183: p_modifier_line_rec.SUBSTITUTION_CONTEXT := Fnd_Api.g_miss_char;
184: p_modifier_line_rec.SUBSTITUTION_ATTR := Fnd_Api.g_miss_char;
185: p_modifier_line_rec.SUBSTITUTION_VAL := Fnd_Api.g_miss_char;
186: p_modifier_line_rec.PRICE_BREAK_TYPE_CODE := Fnd_Api.g_miss_char;
187: --p_modifier_line_rec.PRICING_ATTRIBUTE_ID:= Fnd_Api.g_miss_num;
188:
181: p_modifier_line_rec.BENEFIT_QTY := p_list_line_rec.BENEFIT_QTY;
182: p_modifier_line_rec.BENEFIT_UOM_CODE := p_list_line_rec.BENEFIT_UOM_CODE;
183: p_modifier_line_rec.SUBSTITUTION_CONTEXT := Fnd_Api.g_miss_char;
184: p_modifier_line_rec.SUBSTITUTION_ATTR := Fnd_Api.g_miss_char;
185: p_modifier_line_rec.SUBSTITUTION_VAL := Fnd_Api.g_miss_char;
186: p_modifier_line_rec.PRICE_BREAK_TYPE_CODE := Fnd_Api.g_miss_char;
187: --p_modifier_line_rec.PRICING_ATTRIBUTE_ID:= Fnd_Api.g_miss_num;
188:
189:
182: p_modifier_line_rec.BENEFIT_UOM_CODE := p_list_line_rec.BENEFIT_UOM_CODE;
183: p_modifier_line_rec.SUBSTITUTION_CONTEXT := Fnd_Api.g_miss_char;
184: p_modifier_line_rec.SUBSTITUTION_ATTR := Fnd_Api.g_miss_char;
185: p_modifier_line_rec.SUBSTITUTION_VAL := Fnd_Api.g_miss_char;
186: p_modifier_line_rec.PRICE_BREAK_TYPE_CODE := Fnd_Api.g_miss_char;
187: --p_modifier_line_rec.PRICING_ATTRIBUTE_ID:= Fnd_Api.g_miss_num;
188:
189:
190: p_modifier_line_rec.COMMENTS := Fnd_Api.g_miss_char;
183: p_modifier_line_rec.SUBSTITUTION_CONTEXT := Fnd_Api.g_miss_char;
184: p_modifier_line_rec.SUBSTITUTION_ATTR := Fnd_Api.g_miss_char;
185: p_modifier_line_rec.SUBSTITUTION_VAL := Fnd_Api.g_miss_char;
186: p_modifier_line_rec.PRICE_BREAK_TYPE_CODE := Fnd_Api.g_miss_char;
187: --p_modifier_line_rec.PRICING_ATTRIBUTE_ID:= Fnd_Api.g_miss_num;
188:
189:
190: p_modifier_line_rec.COMMENTS := Fnd_Api.g_miss_char;
191: p_modifier_line_rec.CONTEXT := p_list_line_rec.CONTEXT;
186: p_modifier_line_rec.PRICE_BREAK_TYPE_CODE := Fnd_Api.g_miss_char;
187: --p_modifier_line_rec.PRICING_ATTRIBUTE_ID:= Fnd_Api.g_miss_num;
188:
189:
190: p_modifier_line_rec.COMMENTS := Fnd_Api.g_miss_char;
191: p_modifier_line_rec.CONTEXT := p_list_line_rec.CONTEXT;
192: p_modifier_line_rec.ATTRIBUTE1 := p_list_line_rec.ATTRIBUTE1;
193: p_modifier_line_rec.ATTRIBUTE2 := p_list_line_rec.ATTRIBUTE2;
194: p_modifier_line_rec.ATTRIBUTE3 := p_list_line_rec.ATTRIBUTE3;
203: p_modifier_line_rec.ATTRIBUTE12:= p_list_line_rec.attribute12;
204: p_modifier_line_rec.ATTRIBUTE13:= p_list_line_rec.attribute13;
205: p_modifier_line_rec.ATTRIBUTE14:= p_list_line_rec.attribute14;
206: p_modifier_line_rec.ATTRIBUTE15:= p_list_line_rec.attribute15;
207: p_modifier_line_rec.MAX_QTY_PER_ORDER:= Fnd_Api.g_miss_num;
208: p_modifier_line_rec.MAX_QTY_PER_ORDER_ID := Fnd_Api.g_miss_num;
209: p_modifier_line_rec.MAX_QTY_PER_CUSTOMER := Fnd_Api.g_miss_num;
210: p_modifier_line_rec.MAX_QTY_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
211: p_modifier_line_rec.MAX_QTY_PER_RULE := Fnd_Api.g_miss_num;
204: p_modifier_line_rec.ATTRIBUTE13:= p_list_line_rec.attribute13;
205: p_modifier_line_rec.ATTRIBUTE14:= p_list_line_rec.attribute14;
206: p_modifier_line_rec.ATTRIBUTE15:= p_list_line_rec.attribute15;
207: p_modifier_line_rec.MAX_QTY_PER_ORDER:= Fnd_Api.g_miss_num;
208: p_modifier_line_rec.MAX_QTY_PER_ORDER_ID := Fnd_Api.g_miss_num;
209: p_modifier_line_rec.MAX_QTY_PER_CUSTOMER := Fnd_Api.g_miss_num;
210: p_modifier_line_rec.MAX_QTY_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
211: p_modifier_line_rec.MAX_QTY_PER_RULE := Fnd_Api.g_miss_num;
212: p_modifier_line_rec.MAX_QTY_PER_RULE_ID := Fnd_Api.g_miss_num;
205: p_modifier_line_rec.ATTRIBUTE14:= p_list_line_rec.attribute14;
206: p_modifier_line_rec.ATTRIBUTE15:= p_list_line_rec.attribute15;
207: p_modifier_line_rec.MAX_QTY_PER_ORDER:= Fnd_Api.g_miss_num;
208: p_modifier_line_rec.MAX_QTY_PER_ORDER_ID := Fnd_Api.g_miss_num;
209: p_modifier_line_rec.MAX_QTY_PER_CUSTOMER := Fnd_Api.g_miss_num;
210: p_modifier_line_rec.MAX_QTY_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
211: p_modifier_line_rec.MAX_QTY_PER_RULE := Fnd_Api.g_miss_num;
212: p_modifier_line_rec.MAX_QTY_PER_RULE_ID := Fnd_Api.g_miss_num;
213: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER := Fnd_Api.g_miss_num;
206: p_modifier_line_rec.ATTRIBUTE15:= p_list_line_rec.attribute15;
207: p_modifier_line_rec.MAX_QTY_PER_ORDER:= Fnd_Api.g_miss_num;
208: p_modifier_line_rec.MAX_QTY_PER_ORDER_ID := Fnd_Api.g_miss_num;
209: p_modifier_line_rec.MAX_QTY_PER_CUSTOMER := Fnd_Api.g_miss_num;
210: p_modifier_line_rec.MAX_QTY_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
211: p_modifier_line_rec.MAX_QTY_PER_RULE := Fnd_Api.g_miss_num;
212: p_modifier_line_rec.MAX_QTY_PER_RULE_ID := Fnd_Api.g_miss_num;
213: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER := Fnd_Api.g_miss_num;
214: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
207: p_modifier_line_rec.MAX_QTY_PER_ORDER:= Fnd_Api.g_miss_num;
208: p_modifier_line_rec.MAX_QTY_PER_ORDER_ID := Fnd_Api.g_miss_num;
209: p_modifier_line_rec.MAX_QTY_PER_CUSTOMER := Fnd_Api.g_miss_num;
210: p_modifier_line_rec.MAX_QTY_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
211: p_modifier_line_rec.MAX_QTY_PER_RULE := Fnd_Api.g_miss_num;
212: p_modifier_line_rec.MAX_QTY_PER_RULE_ID := Fnd_Api.g_miss_num;
213: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER := Fnd_Api.g_miss_num;
214: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
215: p_modifier_line_rec.MAX_AMOUNT_PER_RULE := Fnd_Api.g_miss_num;
208: p_modifier_line_rec.MAX_QTY_PER_ORDER_ID := Fnd_Api.g_miss_num;
209: p_modifier_line_rec.MAX_QTY_PER_CUSTOMER := Fnd_Api.g_miss_num;
210: p_modifier_line_rec.MAX_QTY_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
211: p_modifier_line_rec.MAX_QTY_PER_RULE := Fnd_Api.g_miss_num;
212: p_modifier_line_rec.MAX_QTY_PER_RULE_ID := Fnd_Api.g_miss_num;
213: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER := Fnd_Api.g_miss_num;
214: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
215: p_modifier_line_rec.MAX_AMOUNT_PER_RULE := Fnd_Api.g_miss_num;
216: p_modifier_line_rec.MAX_AMOUNT_PER_RULE_ID := Fnd_Api.g_miss_num;
209: p_modifier_line_rec.MAX_QTY_PER_CUSTOMER := Fnd_Api.g_miss_num;
210: p_modifier_line_rec.MAX_QTY_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
211: p_modifier_line_rec.MAX_QTY_PER_RULE := Fnd_Api.g_miss_num;
212: p_modifier_line_rec.MAX_QTY_PER_RULE_ID := Fnd_Api.g_miss_num;
213: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER := Fnd_Api.g_miss_num;
214: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
215: p_modifier_line_rec.MAX_AMOUNT_PER_RULE := Fnd_Api.g_miss_num;
216: p_modifier_line_rec.MAX_AMOUNT_PER_RULE_ID := Fnd_Api.g_miss_num;
217: p_modifier_line_rec.ESTIMATE_QTY_UOM := Fnd_Api.g_miss_char;
210: p_modifier_line_rec.MAX_QTY_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
211: p_modifier_line_rec.MAX_QTY_PER_RULE := Fnd_Api.g_miss_num;
212: p_modifier_line_rec.MAX_QTY_PER_RULE_ID := Fnd_Api.g_miss_num;
213: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER := Fnd_Api.g_miss_num;
214: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
215: p_modifier_line_rec.MAX_AMOUNT_PER_RULE := Fnd_Api.g_miss_num;
216: p_modifier_line_rec.MAX_AMOUNT_PER_RULE_ID := Fnd_Api.g_miss_num;
217: p_modifier_line_rec.ESTIMATE_QTY_UOM := Fnd_Api.g_miss_char;
218: p_modifier_line_rec.generate_using_formula_id := FND_API.G_MISS_NUM;
211: p_modifier_line_rec.MAX_QTY_PER_RULE := Fnd_Api.g_miss_num;
212: p_modifier_line_rec.MAX_QTY_PER_RULE_ID := Fnd_Api.g_miss_num;
213: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER := Fnd_Api.g_miss_num;
214: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
215: p_modifier_line_rec.MAX_AMOUNT_PER_RULE := Fnd_Api.g_miss_num;
216: p_modifier_line_rec.MAX_AMOUNT_PER_RULE_ID := Fnd_Api.g_miss_num;
217: p_modifier_line_rec.ESTIMATE_QTY_UOM := Fnd_Api.g_miss_char;
218: p_modifier_line_rec.generate_using_formula_id := FND_API.G_MISS_NUM;
219: p_modifier_line_rec.price_by_formula_id := FND_API.G_MISS_NUM;
212: p_modifier_line_rec.MAX_QTY_PER_RULE_ID := Fnd_Api.g_miss_num;
213: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER := Fnd_Api.g_miss_num;
214: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
215: p_modifier_line_rec.MAX_AMOUNT_PER_RULE := Fnd_Api.g_miss_num;
216: p_modifier_line_rec.MAX_AMOUNT_PER_RULE_ID := Fnd_Api.g_miss_num;
217: p_modifier_line_rec.ESTIMATE_QTY_UOM := Fnd_Api.g_miss_char;
218: p_modifier_line_rec.generate_using_formula_id := FND_API.G_MISS_NUM;
219: p_modifier_line_rec.price_by_formula_id := FND_API.G_MISS_NUM;
220: p_modifier_line_rec.generate_using_formula := FND_API.G_MISS_CHAR;
213: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER := Fnd_Api.g_miss_num;
214: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
215: p_modifier_line_rec.MAX_AMOUNT_PER_RULE := Fnd_Api.g_miss_num;
216: p_modifier_line_rec.MAX_AMOUNT_PER_RULE_ID := Fnd_Api.g_miss_num;
217: p_modifier_line_rec.ESTIMATE_QTY_UOM := Fnd_Api.g_miss_char;
218: p_modifier_line_rec.generate_using_formula_id := FND_API.G_MISS_NUM;
219: p_modifier_line_rec.price_by_formula_id := FND_API.G_MISS_NUM;
220: p_modifier_line_rec.generate_using_formula := FND_API.G_MISS_CHAR;
221: p_modifier_line_rec.price_by_formula := FND_API.G_MISS_CHAR;
214: p_modifier_line_rec.MAX_ORDERS_PER_CUSTOMER_ID := Fnd_Api.g_miss_num;
215: p_modifier_line_rec.MAX_AMOUNT_PER_RULE := Fnd_Api.g_miss_num;
216: p_modifier_line_rec.MAX_AMOUNT_PER_RULE_ID := Fnd_Api.g_miss_num;
217: p_modifier_line_rec.ESTIMATE_QTY_UOM := Fnd_Api.g_miss_char;
218: p_modifier_line_rec.generate_using_formula_id := FND_API.G_MISS_NUM;
219: p_modifier_line_rec.price_by_formula_id := FND_API.G_MISS_NUM;
220: p_modifier_line_rec.generate_using_formula := FND_API.G_MISS_CHAR;
221: p_modifier_line_rec.price_by_formula := FND_API.G_MISS_CHAR;
222:
215: p_modifier_line_rec.MAX_AMOUNT_PER_RULE := Fnd_Api.g_miss_num;
216: p_modifier_line_rec.MAX_AMOUNT_PER_RULE_ID := Fnd_Api.g_miss_num;
217: p_modifier_line_rec.ESTIMATE_QTY_UOM := Fnd_Api.g_miss_char;
218: p_modifier_line_rec.generate_using_formula_id := FND_API.G_MISS_NUM;
219: p_modifier_line_rec.price_by_formula_id := FND_API.G_MISS_NUM;
220: p_modifier_line_rec.generate_using_formula := FND_API.G_MISS_CHAR;
221: p_modifier_line_rec.price_by_formula := FND_API.G_MISS_CHAR;
222:
223: IF p_list_line_rec.operation = 'CREATE' THEN
216: p_modifier_line_rec.MAX_AMOUNT_PER_RULE_ID := Fnd_Api.g_miss_num;
217: p_modifier_line_rec.ESTIMATE_QTY_UOM := Fnd_Api.g_miss_char;
218: p_modifier_line_rec.generate_using_formula_id := FND_API.G_MISS_NUM;
219: p_modifier_line_rec.price_by_formula_id := FND_API.G_MISS_NUM;
220: p_modifier_line_rec.generate_using_formula := FND_API.G_MISS_CHAR;
221: p_modifier_line_rec.price_by_formula := FND_API.G_MISS_CHAR;
222:
223: IF p_list_line_rec.operation = 'CREATE' THEN
224: complete_rec_for_create(p_modifier_line_rec => p_modifier_line_rec);
217: p_modifier_line_rec.ESTIMATE_QTY_UOM := Fnd_Api.g_miss_char;
218: p_modifier_line_rec.generate_using_formula_id := FND_API.G_MISS_NUM;
219: p_modifier_line_rec.price_by_formula_id := FND_API.G_MISS_NUM;
220: p_modifier_line_rec.generate_using_formula := FND_API.G_MISS_CHAR;
221: p_modifier_line_rec.price_by_formula := FND_API.G_MISS_CHAR;
222:
223: IF p_list_line_rec.operation = 'CREATE' THEN
224: complete_rec_for_create(p_modifier_line_rec => p_modifier_line_rec);
225: END IF;
242: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type )
243: IS
244: BEGIN
245: P_modifier_line_rec.list_line_type_code := 'DIS';
246: p_modifier_line_rec.list_line_id := FND_API.G_MISS_NUM;
247: p_modifier_line_rec.pricing_attribute_id := FND_API.G_MISS_NUM;
248: p_modifier_line_rec.product_attr := 'PRICING_ATTRIBUTE1';
249: -- l_orec[i].arithmetic_operator = (String) getAPIParamValue(this, "arithmeticOperator",l_orec[i].arithmetic_operator);
250: END populate_pro_good_get_rec;
243: IS
244: BEGIN
245: P_modifier_line_rec.list_line_type_code := 'DIS';
246: p_modifier_line_rec.list_line_id := FND_API.G_MISS_NUM;
247: p_modifier_line_rec.pricing_attribute_id := FND_API.G_MISS_NUM;
248: p_modifier_line_rec.product_attr := 'PRICING_ATTRIBUTE1';
249: -- l_orec[i].arithmetic_operator = (String) getAPIParamValue(this, "arithmeticOperator",l_orec[i].arithmetic_operator);
250: END populate_pro_good_get_rec;
251:
309: -- Parameters
310: --
311: -- IN
312: -- p_api_version_number IN NUMBER Required
313: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
314: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
315: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
316: -- p_offadj_line_rec IN offadj_line_rec_type Required
317: --
310: --
311: -- IN
312: -- p_api_version_number IN NUMBER Required
313: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
314: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
315: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
316: -- p_offadj_line_rec IN offadj_line_rec_type Required
317: --
318: -- OUT
311: -- IN
312: -- p_api_version_number IN NUMBER Required
313: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
314: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
315: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
316: -- p_offadj_line_rec IN offadj_line_rec_type Required
317: --
318: -- OUT
319: -- x_return_status OUT VARCHAR2
331: -- ==============================================================================
332:
333: PROCEDURE Create_Offer_Adj_Line(
334: p_api_version_number IN NUMBER,
335: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
336: p_commit IN VARCHAR2 := FND_API.G_FALSE,
337: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
338:
339: x_return_status OUT NOCOPY VARCHAR2,
332:
333: PROCEDURE Create_Offer_Adj_Line(
334: p_api_version_number IN NUMBER,
335: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
336: p_commit IN VARCHAR2 := FND_API.G_FALSE,
337: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
338:
339: x_return_status OUT NOCOPY VARCHAR2,
340: x_msg_count OUT NOCOPY NUMBER,
333: PROCEDURE Create_Offer_Adj_Line(
334: p_api_version_number IN NUMBER,
335: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
336: p_commit IN VARCHAR2 := FND_API.G_FALSE,
337: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
338:
339: x_return_status OUT NOCOPY VARCHAR2,
340: x_msg_count OUT NOCOPY NUMBER,
341: x_msg_data OUT NOCOPY VARCHAR2,
348: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Offer_Adj_Line';
349: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
350: l_return_status_full VARCHAR2(1);
351: l_object_version_number NUMBER := 1;
352: l_org_id NUMBER := FND_API.G_MISS_NUM;
353: l_offer_adjustment_line_id NUMBER;
354: l_dummy NUMBER;
355: CURSOR c_id IS
356: SELECT ozf_offer_adjustment_lines_s.NEXTVAL
364: -- Standard Start of API savepoint
365: SAVEPOINT create_offer_adj_line_pvt;
366:
367: -- Standard call to check for call compatibility.
368: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
369: p_api_version_number,
370: l_api_name,
371: G_PKG_NAME)
372: THEN
369: p_api_version_number,
370: l_api_name,
371: G_PKG_NAME)
372: THEN
373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
374: END IF;
375:
376:
377: -- Initialize message list if p_init_msg_list is set to TRUE.
374: END IF;
375:
376:
377: -- Initialize message list if p_init_msg_list is set to TRUE.
378: IF FND_API.to_Boolean( p_init_msg_list )
379: THEN
380: FND_MSG_PUB.initialize;
381: END IF;
382:
387:
388:
389:
390: -- Initialize API return status to SUCCESS
391: x_return_status := FND_API.G_RET_STS_SUCCESS;
392:
393:
394: -- Local variable initialization
395:
392:
393:
394: -- Local variable initialization
395:
396: IF p_offadj_line_rec.offer_adjustment_line_id IS NULL OR p_offadj_line_rec.offer_adjustment_line_id = FND_API.g_miss_num THEN
397: LOOP
398: l_dummy := NULL;
399: OPEN c_id;
400: FETCH c_id INTO l_offer_adjustment_line_id;
416:
417: IF FND_GLOBAL.USER_ID IS NULL
418: THEN
419: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
420: RAISE FND_API.G_EXC_ERROR;
421: END IF;
422:
423:
424:
421: END IF;
422:
423:
424:
425: --IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
426: --THEN
427: -- Debug message
428: debug_message('Private API: Validate_Offer_Adj_Line');
429:
430:
431: -- Invoke validation procedures
432: Validate_offer_adj_line(
433: p_api_version_number => 1.0,
434: p_init_msg_list => FND_API.G_FALSE,
435: p_validation_level => p_validation_level,
436: p_validation_mode => JTF_PLSQL_API.g_create,
437: p_offadj_line_rec => p_offadj_line_rec,
438: x_return_status => x_return_status,
440: x_msg_data => x_msg_data);
441:
442: --END IF;
443:
444: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447:
448:
441:
442: --END IF;
443:
444: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447:
448:
449: -- Debug Message
474: p_discount_end_date => p_offadj_line_rec.discount_end_date
475: );
476:
477: x_offer_adjustment_line_id := l_offer_adjustment_line_id;
478: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
479: RAISE FND_API.G_EXC_ERROR;
480: END IF;
481: --
482: -- End of API body
475: );
476:
477: x_offer_adjustment_line_id := l_offer_adjustment_line_id;
478: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
479: RAISE FND_API.G_EXC_ERROR;
480: END IF;
481: --
482: -- End of API body
483: --
482: -- End of API body
483: --
484:
485: -- Standard check for p_commit
486: IF FND_API.to_Boolean( p_commit )
487: THEN
488: COMMIT WORK;
489: END IF;
490:
501:
502: EXCEPTION
503:
504: WHEN OZF_Utility_PVT.resource_locked THEN
505: x_return_status := FND_API.g_ret_sts_error;
506: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
507:
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO CREATE_Offer_Adj_Line_PVT;
504: WHEN OZF_Utility_PVT.resource_locked THEN
505: x_return_status := FND_API.g_ret_sts_error;
506: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
507:
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO CREATE_Offer_Adj_Line_PVT;
510: x_return_status := FND_API.G_RET_STS_ERROR;
511: -- Standard call to get message count and if count=1, get the message
512: FND_MSG_PUB.Count_And_Get (
506: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
507:
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO CREATE_Offer_Adj_Line_PVT;
510: x_return_status := FND_API.G_RET_STS_ERROR;
511: -- Standard call to get message count and if count=1, get the message
512: FND_MSG_PUB.Count_And_Get (
513: p_encoded => FND_API.G_FALSE,
514: p_count => x_msg_count,
509: ROLLBACK TO CREATE_Offer_Adj_Line_PVT;
510: x_return_status := FND_API.G_RET_STS_ERROR;
511: -- Standard call to get message count and if count=1, get the message
512: FND_MSG_PUB.Count_And_Get (
513: p_encoded => FND_API.G_FALSE,
514: p_count => x_msg_count,
515: p_data => x_msg_data
516: );
517:
514: p_count => x_msg_count,
515: p_data => x_msg_data
516: );
517:
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519: ROLLBACK TO CREATE_Offer_Adj_Line_PVT;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: -- Standard call to get message count and if count=1, get the message
522: FND_MSG_PUB.Count_And_Get (
516: );
517:
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519: ROLLBACK TO CREATE_Offer_Adj_Line_PVT;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: -- Standard call to get message count and if count=1, get the message
522: FND_MSG_PUB.Count_And_Get (
523: p_encoded => FND_API.G_FALSE,
524: p_count => x_msg_count,
519: ROLLBACK TO CREATE_Offer_Adj_Line_PVT;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: -- Standard call to get message count and if count=1, get the message
522: FND_MSG_PUB.Count_And_Get (
523: p_encoded => FND_API.G_FALSE,
524: p_count => x_msg_count,
525: p_data => x_msg_data
526: );
527:
526: );
527:
528: WHEN OTHERS THEN
529: ROLLBACK TO CREATE_Offer_Adj_Line_PVT;
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
532: THEN
533: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
534: END IF;
533: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
534: END IF;
535: -- Standard call to get message count and if count=1, get the message
536: FND_MSG_PUB.Count_And_Get (
537: p_encoded => FND_API.G_FALSE,
538: p_count => x_msg_count,
539: p_data => x_msg_data
540: );
541: End Create_Offer_Adj_Line;
550: -- line is created at a time
551: --======================================================================================
552: PROCEDURE Create_New_Offer_Adj_Line(
553: p_api_version_number IN NUMBER,
554: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
555: p_commit IN VARCHAR2 := FND_API.G_FALSE,
556: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
557:
558: x_return_status OUT NOCOPY VARCHAR2,
551: --======================================================================================
552: PROCEDURE Create_New_Offer_Adj_Line(
553: p_api_version_number IN NUMBER,
554: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
555: p_commit IN VARCHAR2 := FND_API.G_FALSE,
556: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
557:
558: x_return_status OUT NOCOPY VARCHAR2,
559: x_msg_count OUT NOCOPY NUMBER,
552: PROCEDURE Create_New_Offer_Adj_Line(
553: p_api_version_number IN NUMBER,
554: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
555: p_commit IN VARCHAR2 := FND_API.G_FALSE,
556: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
557:
558: x_return_status OUT NOCOPY VARCHAR2,
559: x_msg_count OUT NOCOPY NUMBER,
560: x_msg_data OUT NOCOPY VARCHAR2,
567: l_api_name CONSTANT VARCHAR2(30) := 'Create_New_Offer_Adj_Line';
568: l_api_version_number CONSTANT NUMBER := 1.0;
569: l_return_status_full VARCHAR2(1);
570: l_object_version_number NUMBER := 1;
571: l_org_id NUMBER := FND_API.G_MISS_NUM;
572: l_offer_adjustment_line_id NUMBER;
573: l_dummy NUMBER;
574: l_offer_type OZF_OFFERS.OFFER_TYPE%TYPE;
575: l_error_loc NUMBER;
597: -- Standard Start of API savepoint
598: SAVEPOINT create_new_offer_adj_line_pvt;
599:
600: -- Standard call to check for call compatibility.
601: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
602: p_api_version_number,
603: l_api_name,
604: G_PKG_NAME)
605: THEN
602: p_api_version_number,
603: l_api_name,
604: G_PKG_NAME)
605: THEN
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607: END IF;
608:
609:
610: -- Initialize message list if p_init_msg_list is set to TRUE.
607: END IF;
608:
609:
610: -- Initialize message list if p_init_msg_list is set to TRUE.
611: IF FND_API.to_Boolean( p_init_msg_list )
612: THEN
613: FND_MSG_PUB.initialize;
614: END IF;
615:
620:
621:
622:
623: -- Initialize API return status to SUCCESS
624: x_return_status := FND_API.G_RET_STS_SUCCESS;
625:
626: --CREATE NEW LIST LINE IN QP
627: /*
628: INactive flag not working right now.
631: --===========================================================
632: --Populate record for Creating new LIne in QP
633: --===========================================================
634: l_modifier_line_tbl(i).operation := 'CREATE';
635: --l_modifier_line_tbl(i).list_line_id := Fnd_Api.g_miss_num
636: populate_new_adj_rec(p_modifier_line_rec => l_modifier_line_tbl(i)
637: , p_list_line_rec => p_list_line_rec);
638:
639: open c_offer_type(p_list_line_rec.list_header_id);
678: x_modifier_line_tbl => v_modifiers_tbl,
679: x_error_location => l_error_loc
680: );
681:
682: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
683: RAISE FND_API.G_EXC_ERROR;
684: END IF;
685:
686: debug_message('Return status is '||x_return_status);
679: x_error_location => l_error_loc
680: );
681:
682: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
683: RAISE FND_API.G_EXC_ERROR;
684: END IF;
685:
686: debug_message('Return status is '||x_return_status);
687: -- create a new adjustment line in ozf_offer_adjustments with created from ADJUSTMENTS ='Y'
714: -- create adjustment line
715: --===============================================================
716: Create_Offer_Adj_Line(
717: p_api_version_number => 1.0,
718: p_init_msg_list => FND_API.G_FALSE,
719: p_commit => FND_API.G_FALSE,
720: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
721: x_return_status =>x_return_status,
722: x_msg_count => x_msg_count,
715: --===============================================================
716: Create_Offer_Adj_Line(
717: p_api_version_number => 1.0,
718: p_init_msg_list => FND_API.G_FALSE,
719: p_commit => FND_API.G_FALSE,
720: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
721: x_return_status =>x_return_status,
722: x_msg_count => x_msg_count,
723: x_msg_data => x_msg_data,
716: Create_Offer_Adj_Line(
717: p_api_version_number => 1.0,
718: p_init_msg_list => FND_API.G_FALSE,
719: p_commit => FND_API.G_FALSE,
720: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
721: x_return_status =>x_return_status,
722: x_msg_count => x_msg_count,
723: x_msg_data => x_msg_data,
724: p_offadj_line_rec => l_offadj_line_rec,
725: x_offer_adjustment_line_id => l_offer_adjustment_line_id
726: );
727:
728: debug_message('New Created adjustment line id is '||l_offer_adjustment_line_id);
729: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
730: RAISE FND_API.G_EXC_ERROR;
731: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: END IF;
726: );
727:
728: debug_message('New Created adjustment line id is '||l_offer_adjustment_line_id);
729: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
730: RAISE FND_API.G_EXC_ERROR;
731: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: END IF;
734:
727:
728: debug_message('New Created adjustment line id is '||l_offer_adjustment_line_id);
729: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
730: RAISE FND_API.G_EXC_ERROR;
731: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: END IF;
734:
735: x_offer_adjustment_line_id := l_offer_adjustment_line_id;
728: debug_message('New Created adjustment line id is '||l_offer_adjustment_line_id);
729: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
730: RAISE FND_API.G_EXC_ERROR;
731: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: END IF;
734:
735: x_offer_adjustment_line_id := l_offer_adjustment_line_id;
736: --
737: -- End of API body
738: --
739:
740: -- Standard check for p_commit
741: IF FND_API.to_Boolean( p_commit )
742: THEN
743: COMMIT WORK;
744: END IF;
745:
754: );
755:
756: EXCEPTION
757: WHEN OZF_UTILITY_PVT.resource_locked THEN
758: x_return_status := FND_API.g_ret_sts_error;
759: OZF_UTILITY_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
760:
761: WHEN FND_API.G_EXC_ERROR THEN
762: ROLLBACK TO CREATE_new_Offer_Adj_Line_PVT;
757: WHEN OZF_UTILITY_PVT.resource_locked THEN
758: x_return_status := FND_API.g_ret_sts_error;
759: OZF_UTILITY_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
760:
761: WHEN FND_API.G_EXC_ERROR THEN
762: ROLLBACK TO CREATE_new_Offer_Adj_Line_PVT;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: -- Standard call to get message count and if count=1, get the message
765: FND_MSG_PUB.Count_And_Get (
759: OZF_UTILITY_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
760:
761: WHEN FND_API.G_EXC_ERROR THEN
762: ROLLBACK TO CREATE_new_Offer_Adj_Line_PVT;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: -- Standard call to get message count and if count=1, get the message
765: FND_MSG_PUB.Count_And_Get (
766: p_encoded => FND_API.G_FALSE,
767: p_count => x_msg_count,
762: ROLLBACK TO CREATE_new_Offer_Adj_Line_PVT;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: -- Standard call to get message count and if count=1, get the message
765: FND_MSG_PUB.Count_And_Get (
766: p_encoded => FND_API.G_FALSE,
767: p_count => x_msg_count,
768: p_data => x_msg_data
769: );
770:
767: p_count => x_msg_count,
768: p_data => x_msg_data
769: );
770:
771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
772: ROLLBACK TO CREATE_New_Offer_Adj_Line_PVT;
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: -- Standard call to get message count and if count=1, get the message
775: FND_MSG_PUB.Count_And_Get (
769: );
770:
771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
772: ROLLBACK TO CREATE_New_Offer_Adj_Line_PVT;
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: -- Standard call to get message count and if count=1, get the message
775: FND_MSG_PUB.Count_And_Get (
776: p_encoded => FND_API.G_FALSE,
777: p_count => x_msg_count,
772: ROLLBACK TO CREATE_New_Offer_Adj_Line_PVT;
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: -- Standard call to get message count and if count=1, get the message
775: FND_MSG_PUB.Count_And_Get (
776: p_encoded => FND_API.G_FALSE,
777: p_count => x_msg_count,
778: p_data => x_msg_data
779: );
780:
779: );
780:
781: WHEN OTHERS THEN
782: ROLLBACK TO CREATE_New_Offer_Adj_Line_PVT;
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
785: THEN
786: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
787: END IF;
786: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
787: END IF;
788: -- Standard call to get message count and if count=1, get the message
789: FND_MSG_PUB.Count_And_Get (
790: p_encoded => FND_API.G_FALSE,
791: p_count => x_msg_count,
792: p_data => x_msg_data
793: );
794:
806: -- Parameters
807: --
808: -- IN
809: -- p_api_version_number IN NUMBER Required
810: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
811: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
812: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
813: -- p_offadj_line_rec IN offadj_line_rec_type Required
814: --
807: --
808: -- IN
809: -- p_api_version_number IN NUMBER Required
810: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
811: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
812: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
813: -- p_offadj_line_rec IN offadj_line_rec_type Required
814: --
815: -- OUT
808: -- IN
809: -- p_api_version_number IN NUMBER Required
810: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
811: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
812: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
813: -- p_offadj_line_rec IN offadj_line_rec_type Required
814: --
815: -- OUT
816: -- x_return_status OUT VARCHAR2
828: -- ==============================================================================
829:
830: PROCEDURE Update_Offer_Adj_Line(
831: p_api_version_number IN NUMBER,
832: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
833: p_commit IN VARCHAR2 := FND_API.G_FALSE,
834: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
835:
836: x_return_status OUT NOCOPY VARCHAR2,
829:
830: PROCEDURE Update_Offer_Adj_Line(
831: p_api_version_number IN NUMBER,
832: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
833: p_commit IN VARCHAR2 := FND_API.G_FALSE,
834: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
835:
836: x_return_status OUT NOCOPY VARCHAR2,
837: x_msg_count OUT NOCOPY NUMBER,
830: PROCEDURE Update_Offer_Adj_Line(
831: p_api_version_number IN NUMBER,
832: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
833: p_commit IN VARCHAR2 := FND_API.G_FALSE,
834: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
835:
836: x_return_status OUT NOCOPY VARCHAR2,
837: x_msg_count OUT NOCOPY NUMBER,
838: x_msg_data OUT NOCOPY VARCHAR2,
864: -- Standard Start of API savepoint
865: SAVEPOINT update_offer_adj_line_pvt;
866:
867: -- Standard call to check for call compatibility.
868: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
869: p_api_version_number,
870: l_api_name,
871: G_PKG_NAME)
872: THEN
869: p_api_version_number,
870: l_api_name,
871: G_PKG_NAME)
872: THEN
873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
874: END IF;
875:
876:
877: -- Initialize message list if p_init_msg_list is set to TRUE.
874: END IF;
875:
876:
877: -- Initialize message list if p_init_msg_list is set to TRUE.
878: IF FND_API.to_Boolean( p_init_msg_list )
879: THEN
880: FND_MSG_PUB.initialize;
881: END IF;
882:
887:
888:
889:
890: -- Initialize API return status to SUCCESS
891: x_return_status := FND_API.G_RET_STS_SUCCESS;
892:
893: -- Debug Message
894: debug_message('Private API: - Open Cursor to Select');
895:
900: If ( c_get_Offer_Adj_Line%NOTFOUND) THEN
901: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
902: p_token_name => 'INFO',
903: p_token_value => 'Offer_Adj_Line') ;
904: RAISE FND_API.G_EXC_ERROR;
905: END IF;
906: -- Debug Message
907: debug_message('Private API: - Close Cursor');
908: CLOSE c_get_Offer_Adj_Line;
908: CLOSE c_get_Offer_Adj_Line;
909:
910:
911: If (l_tar_offadj_line_rec.object_version_number is NULL or
912: l_tar_offadj_line_rec.object_version_number = FND_API.G_MISS_NUM ) Then
913: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
914: p_token_name => 'COLUMN',
915: p_token_value => 'Last_Update_Date') ;
916: raise FND_API.G_EXC_ERROR;
912: l_tar_offadj_line_rec.object_version_number = FND_API.G_MISS_NUM ) Then
913: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
914: p_token_name => 'COLUMN',
915: p_token_value => 'Last_Update_Date') ;
916: raise FND_API.G_EXC_ERROR;
917: End if;
918: -- Check Whether record has been changed by someone else
919: If (l_tar_offadj_line_rec.object_version_number <> l_ref_offadj_line_rec.object_version_number) Then
920: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
919: If (l_tar_offadj_line_rec.object_version_number <> l_ref_offadj_line_rec.object_version_number) Then
920: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
921: p_token_name => 'INFO',
922: p_token_value => 'Offer_Adj_Line') ;
923: raise FND_API.G_EXC_ERROR;
924: End if;
925:
926:
927: --IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
923: raise FND_API.G_EXC_ERROR;
924: End if;
925:
926:
927: --IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
928: --THEN
929: -- Debug message
930: debug_message('Private API: Validate_Offer_Adj_Line');
931:
931:
932: -- Invoke validation procedures
933: Validate_offer_adj_line(
934: p_api_version_number => 1.0,
935: p_init_msg_list => FND_API.G_FALSE,
936: p_validation_level => p_validation_level,
937: p_validation_mode => JTF_PLSQL_API.g_update,
938: p_offadj_line_rec => p_offadj_line_rec,
939: x_return_status => x_return_status,
941: x_msg_data => x_msg_data);
942: --END IF;
943:
944:
945: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
946: RAISE FND_API.G_EXC_ERROR;
947: END IF;
948:
949: -- assigned to obj.ver.num variable which is passed to Update_Row() -- sangara
942: --END IF;
943:
944:
945: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
946: RAISE FND_API.G_EXC_ERROR;
947: END IF;
948:
949: -- assigned to obj.ver.num variable which is passed to Update_Row() -- sangara
950: l_object_version_number := p_offadj_line_rec.object_version_number;
958: -- Invoke table handler(Ozf_Offer_Adj_Line_Pkg.Update_Row)
959:
960: debug_message('b4 update off inv discount='||p_offadj_line_rec.modified_discount);
961: debug_message('b4 update off acc discount='||p_offadj_line_rec.modified_discount_td);
962: -- RAISE FND_API.G_EXC_ERROR;
963: Ozf_Offer_Adj_Line_Pkg.Update_Row(
964: p_offer_adjustment_line_id => p_offadj_line_rec.offer_adjustment_line_id,
965: p_offer_adjustment_id => p_offadj_line_rec.offer_adjustment_id,
966: p_list_line_id => p_offadj_line_rec.list_line_id,
985: -- End of API body.
986: --
987:
988: -- Standard check for p_commit
989: IF FND_API.to_Boolean( p_commit )
990: THEN
991: COMMIT WORK;
992: END IF;
993:
1003: );
1004: EXCEPTION
1005:
1006: WHEN OZF_Utility_PVT.resource_locked THEN
1007: x_return_status := FND_API.g_ret_sts_error;
1008: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1009:
1010: WHEN FND_API.G_EXC_ERROR THEN
1011: ROLLBACK TO UPDATE_Offer_Adj_Line_PVT;
1006: WHEN OZF_Utility_PVT.resource_locked THEN
1007: x_return_status := FND_API.g_ret_sts_error;
1008: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1009:
1010: WHEN FND_API.G_EXC_ERROR THEN
1011: ROLLBACK TO UPDATE_Offer_Adj_Line_PVT;
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: -- Standard call to get message count and if count=1, get the message
1014: FND_MSG_PUB.Count_And_Get (
1008: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1009:
1010: WHEN FND_API.G_EXC_ERROR THEN
1011: ROLLBACK TO UPDATE_Offer_Adj_Line_PVT;
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: -- Standard call to get message count and if count=1, get the message
1014: FND_MSG_PUB.Count_And_Get (
1015: p_encoded => FND_API.G_FALSE,
1016: p_count => x_msg_count,
1011: ROLLBACK TO UPDATE_Offer_Adj_Line_PVT;
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: -- Standard call to get message count and if count=1, get the message
1014: FND_MSG_PUB.Count_And_Get (
1015: p_encoded => FND_API.G_FALSE,
1016: p_count => x_msg_count,
1017: p_data => x_msg_data
1018: );
1019:
1016: p_count => x_msg_count,
1017: p_data => x_msg_data
1018: );
1019:
1020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1021: ROLLBACK TO UPDATE_Offer_Adj_Line_PVT;
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1023: -- Standard call to get message count and if count=1, get the message
1024: FND_MSG_PUB.Count_And_Get (
1018: );
1019:
1020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1021: ROLLBACK TO UPDATE_Offer_Adj_Line_PVT;
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1023: -- Standard call to get message count and if count=1, get the message
1024: FND_MSG_PUB.Count_And_Get (
1025: p_encoded => FND_API.G_FALSE,
1026: p_count => x_msg_count,
1021: ROLLBACK TO UPDATE_Offer_Adj_Line_PVT;
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1023: -- Standard call to get message count and if count=1, get the message
1024: FND_MSG_PUB.Count_And_Get (
1025: p_encoded => FND_API.G_FALSE,
1026: p_count => x_msg_count,
1027: p_data => x_msg_data
1028: );
1029:
1028: );
1029:
1030: WHEN OTHERS THEN
1031: ROLLBACK TO UPDATE_Offer_Adj_Line_PVT;
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1033: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1034: THEN
1035: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1036: END IF;
1035: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1036: END IF;
1037: -- Standard call to get message count and if count=1, get the message
1038: FND_MSG_PUB.Count_And_Get (
1039: p_encoded => FND_API.G_FALSE,
1040: p_count => x_msg_count,
1041: p_data => x_msg_data
1042: );
1043: End Update_Offer_Adj_Line;
1056: -- Parameters
1057: --
1058: -- IN
1059: -- p_api_version_number IN NUMBER Required
1060: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1061: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1062: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1063: -- p_list_line_rec IN offadj_new_line_rec_type Required
1064: --
1057: --
1058: -- IN
1059: -- p_api_version_number IN NUMBER Required
1060: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1061: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1062: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1063: -- p_list_line_rec IN offadj_new_line_rec_type Required
1064: --
1065: -- OUT
1058: -- IN
1059: -- p_api_version_number IN NUMBER Required
1060: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1061: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1062: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1063: -- p_list_line_rec IN offadj_new_line_rec_type Required
1064: --
1065: -- OUT
1066: -- x_return_status OUT VARCHAR2
1084: -- ==============================================================================
1085:
1086: PROCEDURE Update_New_Offer_Adj_Line(
1087: p_api_version_number IN NUMBER,
1088: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1089: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1090: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1091:
1092: x_return_status OUT NOCOPY VARCHAR2,
1085:
1086: PROCEDURE Update_New_Offer_Adj_Line(
1087: p_api_version_number IN NUMBER,
1088: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1089: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1090: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1091:
1092: x_return_status OUT NOCOPY VARCHAR2,
1093: x_msg_count OUT NOCOPY NUMBER,
1086: PROCEDURE Update_New_Offer_Adj_Line(
1087: p_api_version_number IN NUMBER,
1088: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1089: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1090: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1091:
1092: x_return_status OUT NOCOPY VARCHAR2,
1093: x_msg_count OUT NOCOPY NUMBER,
1094: x_msg_data OUT NOCOPY VARCHAR2,
1101: l_api_name CONSTANT VARCHAR2(30) := 'Update_New_Offer_Adj_Line';
1102: l_api_version_number CONSTANT NUMBER := 1.0;
1103: l_return_status_full VARCHAR2(1);
1104: l_object_version_number NUMBER := 1;
1105: l_org_id NUMBER := FND_API.G_MISS_NUM;
1106: l_offer_adjustment_line_id NUMBER;
1107: l_dummy NUMBER;
1108: l_offer_type OZF_OFFERS.OFFER_TYPE%TYPE;
1109: l_error_loc NUMBER;
1128: -- Standard Start of API savepoint
1129: SAVEPOINT update_new_offer_adj_line_pvt;
1130:
1131: -- Standard call to check for call compatibility.
1132: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1133: p_api_version_number,
1134: l_api_name,
1135: G_PKG_NAME)
1136: THEN
1133: p_api_version_number,
1134: l_api_name,
1135: G_PKG_NAME)
1136: THEN
1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1138: END IF;
1139:
1140:
1141: -- Initialize message list if p_init_msg_list is set to TRUE.
1138: END IF;
1139:
1140:
1141: -- Initialize message list if p_init_msg_list is set to TRUE.
1142: IF FND_API.to_Boolean( p_init_msg_list )
1143: THEN
1144: FND_MSG_PUB.initialize;
1145: END IF;
1146:
1147: -- Debug Message
1148: debug_message('Private API: ' || l_api_name || 'start');
1149:
1150: -- Initialize API return status to SUCCESS
1151: x_return_status := FND_API.G_RET_STS_SUCCESS;
1152:
1153: --UPDATE LIST LINE IN QP
1154: /*
1155: INactive flag not working right now.
1191: x_modifier_line_tbl => v_modifiers_tbl,
1192: x_error_location => l_error_loc
1193: );
1194:
1195: -- RAISE FND_API.G_EXC_ERROR;
1196: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1197: RAISE FND_API.G_EXC_ERROR;
1198: END IF;
1199:
1192: x_error_location => l_error_loc
1193: );
1194:
1195: -- RAISE FND_API.G_EXC_ERROR;
1196: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1197: RAISE FND_API.G_EXC_ERROR;
1198: END IF;
1199:
1200: -- flipping automatic flag back to N
1193: );
1194:
1195: -- RAISE FND_API.G_EXC_ERROR;
1196: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1197: RAISE FND_API.G_EXC_ERROR;
1198: END IF;
1199:
1200: -- flipping automatic flag back to N
1201: --update qp_list_lines set automatic_flag = 'N' where list_line_id = p_list_line_rec.list_line_id;
1231: --============================================================================
1232: -- call update api
1233: Update_Offer_Adj_Line(
1234: p_api_version_number => 1.0 ,
1235: p_init_msg_list => FND_API.G_TRUE,
1236: p_commit => FND_API.G_FALSE,
1237: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1238: x_return_status => x_return_status,
1239: x_msg_count => x_msg_count,
1232: -- call update api
1233: Update_Offer_Adj_Line(
1234: p_api_version_number => 1.0 ,
1235: p_init_msg_list => FND_API.G_TRUE,
1236: p_commit => FND_API.G_FALSE,
1237: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1238: x_return_status => x_return_status,
1239: x_msg_count => x_msg_count,
1240: x_msg_data => x_msg_data,
1233: Update_Offer_Adj_Line(
1234: p_api_version_number => 1.0 ,
1235: p_init_msg_list => FND_API.G_TRUE,
1236: p_commit => FND_API.G_FALSE,
1237: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1238: x_return_status => x_return_status,
1239: x_msg_count => x_msg_count,
1240: x_msg_data => x_msg_data,
1241: p_offadj_line_rec =>l_offadj_line_rec,
1245:
1246: --update qp_list_lines set automatic_flag = 'N' where list_line_id = v_modifiers_tbl(1).list_line_id;
1247:
1248: debug_message('Updated adjustment line id is '||l_offer_adjustment_line_id);
1249: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1250: RAISE FND_API.G_EXC_ERROR;
1251: END IF;
1252: --
1253: -- End of API body
1246: --update qp_list_lines set automatic_flag = 'N' where list_line_id = v_modifiers_tbl(1).list_line_id;
1247:
1248: debug_message('Updated adjustment line id is '||l_offer_adjustment_line_id);
1249: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1250: RAISE FND_API.G_EXC_ERROR;
1251: END IF;
1252: --
1253: -- End of API body
1254: --
1253: -- End of API body
1254: --
1255:
1256: -- Standard check for p_commit
1257: IF FND_API.to_Boolean( p_commit )
1258: THEN
1259: COMMIT WORK;
1260: END IF;
1261:
1270: );
1271:
1272: EXCEPTION
1273: WHEN OZF_UTILITY_PVT.resource_locked THEN
1274: x_return_status := FND_API.g_ret_sts_error;
1275: OZF_UTILITY_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1276:
1277: WHEN FND_API.G_EXC_ERROR THEN
1278: ROLLBACK TO Update_new_Offer_Adj_Line_PVT;
1273: WHEN OZF_UTILITY_PVT.resource_locked THEN
1274: x_return_status := FND_API.g_ret_sts_error;
1275: OZF_UTILITY_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1276:
1277: WHEN FND_API.G_EXC_ERROR THEN
1278: ROLLBACK TO Update_new_Offer_Adj_Line_PVT;
1279: x_return_status := FND_API.G_RET_STS_ERROR;
1280: -- Standard call to get message count and if count=1, get the message
1281: FND_MSG_PUB.Count_And_Get (
1275: OZF_UTILITY_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1276:
1277: WHEN FND_API.G_EXC_ERROR THEN
1278: ROLLBACK TO Update_new_Offer_Adj_Line_PVT;
1279: x_return_status := FND_API.G_RET_STS_ERROR;
1280: -- Standard call to get message count and if count=1, get the message
1281: FND_MSG_PUB.Count_And_Get (
1282: p_encoded => FND_API.G_FALSE,
1283: p_count => x_msg_count,
1278: ROLLBACK TO Update_new_Offer_Adj_Line_PVT;
1279: x_return_status := FND_API.G_RET_STS_ERROR;
1280: -- Standard call to get message count and if count=1, get the message
1281: FND_MSG_PUB.Count_And_Get (
1282: p_encoded => FND_API.G_FALSE,
1283: p_count => x_msg_count,
1284: p_data => x_msg_data
1285: );
1286:
1283: p_count => x_msg_count,
1284: p_data => x_msg_data
1285: );
1286:
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1288: ROLLBACK TO Update_New_Offer_Adj_Line_PVT;
1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1290: -- Standard call to get message count and if count=1, get the message
1291: FND_MSG_PUB.Count_And_Get (
1285: );
1286:
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1288: ROLLBACK TO Update_New_Offer_Adj_Line_PVT;
1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1290: -- Standard call to get message count and if count=1, get the message
1291: FND_MSG_PUB.Count_And_Get (
1292: p_encoded => FND_API.G_FALSE,
1293: p_count => x_msg_count,
1288: ROLLBACK TO Update_New_Offer_Adj_Line_PVT;
1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1290: -- Standard call to get message count and if count=1, get the message
1291: FND_MSG_PUB.Count_And_Get (
1292: p_encoded => FND_API.G_FALSE,
1293: p_count => x_msg_count,
1294: p_data => x_msg_data
1295: );
1296:
1295: );
1296:
1297: WHEN OTHERS THEN
1298: ROLLBACK TO Update_New_Offer_Adj_Line_PVT;
1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1300: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1301: THEN
1302: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1303: END IF;
1302: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1303: END IF;
1304: -- Standard call to get message count and if count=1, get the message
1305: FND_MSG_PUB.Count_And_Get (
1306: p_encoded => FND_API.G_FALSE,
1307: p_count => x_msg_count,
1308: p_data => x_msg_data
1309: );
1310:
1323: -- Parameters
1324: --
1325: -- IN
1326: -- p_api_version_number IN NUMBER Required
1327: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1328: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1329: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1330: -- p_offer_adjustment_line_id IN NUMBER
1331: -- p_object_version_number IN NUMBER Optional Default = NULL
1324: --
1325: -- IN
1326: -- p_api_version_number IN NUMBER Required
1327: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1328: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1329: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1330: -- p_offer_adjustment_line_id IN NUMBER
1331: -- p_object_version_number IN NUMBER Optional Default = NULL
1332: --
1325: -- IN
1326: -- p_api_version_number IN NUMBER Required
1327: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1328: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1329: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1330: -- p_offer_adjustment_line_id IN NUMBER
1331: -- p_object_version_number IN NUMBER Optional Default = NULL
1332: --
1333: -- OUT
1346: -- ==============================================================================
1347:
1348: PROCEDURE Delete_Offer_Adj_Line(
1349: p_api_version_number IN NUMBER,
1350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1351: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1353: x_return_status OUT NOCOPY VARCHAR2,
1354: x_msg_count OUT NOCOPY NUMBER,
1347:
1348: PROCEDURE Delete_Offer_Adj_Line(
1349: p_api_version_number IN NUMBER,
1350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1351: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1353: x_return_status OUT NOCOPY VARCHAR2,
1354: x_msg_count OUT NOCOPY NUMBER,
1355: x_msg_data OUT NOCOPY VARCHAR2,
1348: PROCEDURE Delete_Offer_Adj_Line(
1349: p_api_version_number IN NUMBER,
1350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1351: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1353: x_return_status OUT NOCOPY VARCHAR2,
1354: x_msg_count OUT NOCOPY NUMBER,
1355: x_msg_data OUT NOCOPY VARCHAR2,
1356: p_offer_adjustment_line_id IN NUMBER,
1366: -- Standard Start of API savepoint
1367: SAVEPOINT delete_offer_adj_line_pvt;
1368:
1369: -- Standard call to check for call compatibility.
1370: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1371: p_api_version_number,
1372: l_api_name,
1373: G_PKG_NAME)
1374: THEN
1371: p_api_version_number,
1372: l_api_name,
1373: G_PKG_NAME)
1374: THEN
1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1376: END IF;
1377:
1378:
1379: -- Initialize message list if p_init_msg_list is set to TRUE.
1376: END IF;
1377:
1378:
1379: -- Initialize message list if p_init_msg_list is set to TRUE.
1380: IF FND_API.to_Boolean( p_init_msg_list )
1381: THEN
1382: FND_MSG_PUB.initialize;
1383: END IF;
1384:
1389:
1390:
1391:
1392: -- Initialize API return status to SUCCESS
1393: x_return_status := FND_API.G_RET_STS_SUCCESS;
1394:
1395: --
1396: -- Api body
1397: --
1406: -- End of API body
1407: --
1408:
1409: -- Standard check for p_commit
1410: IF FND_API.to_Boolean( p_commit )
1411: THEN
1412: COMMIT WORK;
1413: END IF;
1414:
1424: );
1425: EXCEPTION
1426:
1427: WHEN OZF_Utility_PVT.resource_locked THEN
1428: x_return_status := FND_API.g_ret_sts_error;
1429: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1430:
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: ROLLBACK TO DELETE_Offer_Adj_Line_PVT;
1427: WHEN OZF_Utility_PVT.resource_locked THEN
1428: x_return_status := FND_API.g_ret_sts_error;
1429: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1430:
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: ROLLBACK TO DELETE_Offer_Adj_Line_PVT;
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: -- Standard call to get message count and if count=1, get the message
1435: FND_MSG_PUB.Count_And_Get (
1429: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1430:
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: ROLLBACK TO DELETE_Offer_Adj_Line_PVT;
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: -- Standard call to get message count and if count=1, get the message
1435: FND_MSG_PUB.Count_And_Get (
1436: p_encoded => FND_API.G_FALSE,
1437: p_count => x_msg_count,
1432: ROLLBACK TO DELETE_Offer_Adj_Line_PVT;
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: -- Standard call to get message count and if count=1, get the message
1435: FND_MSG_PUB.Count_And_Get (
1436: p_encoded => FND_API.G_FALSE,
1437: p_count => x_msg_count,
1438: p_data => x_msg_data
1439: );
1440:
1437: p_count => x_msg_count,
1438: p_data => x_msg_data
1439: );
1440:
1441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1442: ROLLBACK TO DELETE_Offer_Adj_Line_PVT;
1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1444: -- Standard call to get message count and if count=1, get the message
1445: FND_MSG_PUB.Count_And_Get (
1439: );
1440:
1441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1442: ROLLBACK TO DELETE_Offer_Adj_Line_PVT;
1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1444: -- Standard call to get message count and if count=1, get the message
1445: FND_MSG_PUB.Count_And_Get (
1446: p_encoded => FND_API.G_FALSE,
1447: p_count => x_msg_count,
1442: ROLLBACK TO DELETE_Offer_Adj_Line_PVT;
1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1444: -- Standard call to get message count and if count=1, get the message
1445: FND_MSG_PUB.Count_And_Get (
1446: p_encoded => FND_API.G_FALSE,
1447: p_count => x_msg_count,
1448: p_data => x_msg_data
1449: );
1450:
1449: );
1450:
1451: WHEN OTHERS THEN
1452: ROLLBACK TO DELETE_Offer_Adj_Line_PVT;
1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1454: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1455: THEN
1456: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1457: END IF;
1456: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1457: END IF;
1458: -- Standard call to get message count and if count=1, get the message
1459: FND_MSG_PUB.Count_And_Get (
1460: p_encoded => FND_API.G_FALSE,
1461: p_count => x_msg_count,
1462: p_data => x_msg_data
1463: );
1464: End Delete_Offer_Adj_Line;
1478: -- Parameters
1479: --
1480: -- IN
1481: -- p_api_version_number IN NUMBER Required
1482: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1483: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1484: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1485: -- p_offadj_line_rec IN offadj_line_rec_type Required
1486: --
1479: --
1480: -- IN
1481: -- p_api_version_number IN NUMBER Required
1482: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1483: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1484: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1485: -- p_offadj_line_rec IN offadj_line_rec_type Required
1486: --
1487: -- OUT
1480: -- IN
1481: -- p_api_version_number IN NUMBER Required
1482: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1483: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1484: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1485: -- p_offadj_line_rec IN offadj_line_rec_type Required
1486: --
1487: -- OUT
1488: -- x_return_status OUT VARCHAR2
1500: -- ==============================================================================
1501:
1502: PROCEDURE Lock_Offer_Adj_Line(
1503: p_api_version_number IN NUMBER,
1504: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1505:
1506: x_return_status OUT NOCOPY VARCHAR2,
1507: x_msg_count OUT NOCOPY NUMBER,
1508: x_msg_data OUT NOCOPY VARCHAR2,
1523: debug_message('Private API: ' || l_api_name || 'start');
1524:
1525:
1526: -- Initialize message list if p_init_msg_list is set to TRUE.
1527: IF FND_API.to_Boolean( p_init_msg_list )
1528: THEN
1529: FND_MSG_PUB.initialize;
1530: END IF;
1531:
1531:
1532:
1533:
1534: -- Standard call to check for call compatibility.
1535: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1536: p_api_version_number,
1537: l_api_name,
1538: G_PKG_NAME)
1539: THEN
1536: p_api_version_number,
1537: l_api_name,
1538: G_PKG_NAME)
1539: THEN
1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1541: END IF;
1542:
1543:
1544:
1542:
1543:
1544:
1545: -- Initialize API return status to SUCCESS
1546: x_return_status := FND_API.G_RET_STS_SUCCESS;
1547:
1548:
1549: ------------------------ lock -------------------------
1550: OZF_Offer_Adj_Line_PKG.Lock_Row(l_offer_adjustment_line_id,p_object_version);
1551:
1552:
1553: -------------------- finish --------------------------
1554: FND_MSG_PUB.count_and_get(
1555: p_encoded => FND_API.g_false,
1556: p_count => x_msg_count,
1557: p_data => x_msg_data);
1558: debug_message(l_full_name ||': end');
1559: EXCEPTION
1558: debug_message(l_full_name ||': end');
1559: EXCEPTION
1560:
1561: WHEN OZF_Utility_PVT.resource_locked THEN
1562: x_return_status := FND_API.g_ret_sts_error;
1563: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1564:
1565: WHEN FND_API.G_EXC_ERROR THEN
1566: ROLLBACK TO LOCK_Offer_Adj_Line_PVT;
1561: WHEN OZF_Utility_PVT.resource_locked THEN
1562: x_return_status := FND_API.g_ret_sts_error;
1563: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1564:
1565: WHEN FND_API.G_EXC_ERROR THEN
1566: ROLLBACK TO LOCK_Offer_Adj_Line_PVT;
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: -- Standard call to get message count and if count=1, get the message
1569: FND_MSG_PUB.Count_And_Get (
1563: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
1564:
1565: WHEN FND_API.G_EXC_ERROR THEN
1566: ROLLBACK TO LOCK_Offer_Adj_Line_PVT;
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: -- Standard call to get message count and if count=1, get the message
1569: FND_MSG_PUB.Count_And_Get (
1570: p_encoded => FND_API.G_FALSE,
1571: p_count => x_msg_count,
1566: ROLLBACK TO LOCK_Offer_Adj_Line_PVT;
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: -- Standard call to get message count and if count=1, get the message
1569: FND_MSG_PUB.Count_And_Get (
1570: p_encoded => FND_API.G_FALSE,
1571: p_count => x_msg_count,
1572: p_data => x_msg_data
1573: );
1574:
1571: p_count => x_msg_count,
1572: p_data => x_msg_data
1573: );
1574:
1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1576: ROLLBACK TO LOCK_Offer_Adj_Line_PVT;
1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1578: -- Standard call to get message count and if count=1, get the message
1579: FND_MSG_PUB.Count_And_Get (
1573: );
1574:
1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1576: ROLLBACK TO LOCK_Offer_Adj_Line_PVT;
1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1578: -- Standard call to get message count and if count=1, get the message
1579: FND_MSG_PUB.Count_And_Get (
1580: p_encoded => FND_API.G_FALSE,
1581: p_count => x_msg_count,
1576: ROLLBACK TO LOCK_Offer_Adj_Line_PVT;
1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1578: -- Standard call to get message count and if count=1, get the message
1579: FND_MSG_PUB.Count_And_Get (
1580: p_encoded => FND_API.G_FALSE,
1581: p_count => x_msg_count,
1582: p_data => x_msg_data
1583: );
1584:
1583: );
1584:
1585: WHEN OTHERS THEN
1586: ROLLBACK TO LOCK_Offer_Adj_Line_PVT;
1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1588: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1589: THEN
1590: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1591: END IF;
1590: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1591: END IF;
1592: -- Standard call to get message count and if count=1, get the message
1593: FND_MSG_PUB.Count_And_Get (
1594: p_encoded => FND_API.G_FALSE,
1595: p_count => x_msg_count,
1596: p_data => x_msg_data
1597: );
1598: End Lock_Offer_Adj_Line;
1607: IS
1608: l_valid_flag VARCHAR2(1);
1609:
1610: BEGIN
1611: x_return_status := FND_API.g_ret_sts_success;
1612:
1613: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1614: -- l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1615: -- 'ozf_offer_adjustment_lines',
1614: -- l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1615: -- 'ozf_offer_adjustment_lines',
1616: -- 'offer_adjustment_line_id = ''' || p_offadj_line_rec.offer_adjustment_line_id ||''''
1617: -- );
1618: l_valid_flag := FND_API.g_true;
1619: ELSE
1620: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1621: 'ozf_offer_adjustment_lines',
1622: 'offer_adjustment_line_id = ''' || p_offadj_line_rec.offer_adjustment_line_id ||
1623: ''' AND offer_adjustment_line_id <> ' || p_offadj_line_rec.offer_adjustment_line_id
1624: );
1625: END IF;
1626:
1627: IF l_valid_flag = FND_API.g_false THEN
1628: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_LINE_ID_DUP');
1629: x_return_status := FND_API.g_ret_sts_error;
1630: END IF;
1631:
1625: END IF;
1626:
1627: IF l_valid_flag = FND_API.g_false THEN
1628: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_ADJ_LINE_ID_DUP');
1629: x_return_status := FND_API.g_ret_sts_error;
1630: END IF;
1631:
1632: END check_Offadj_Line_Uk_Items;
1633:
1640: )
1641: IS
1642: BEGIN
1643: IF (
1644: p_offadj_line_rec.modified_discount IS NOT NULL AND p_offadj_line_rec.modified_discount <> FND_API.G_MISS_NUM
1645: )
1646: AND
1647: (
1648: p_offadj_line_rec.original_discount IS NOT NULL AND p_offadj_line_rec.original_discount <> FND_API.G_MISS_NUM
1644: p_offadj_line_rec.modified_discount IS NOT NULL AND p_offadj_line_rec.modified_discount <> FND_API.G_MISS_NUM
1645: )
1646: AND
1647: (
1648: p_offadj_line_rec.original_discount IS NOT NULL AND p_offadj_line_rec.original_discount <> FND_API.G_MISS_NUM
1649: )
1650: THEN
1651: IF
1652: (p_offadj_line_rec.original_discount < 0 AND p_offadj_line_rec.modified_discount > 0)
1653: OR
1654: (p_offadj_line_rec.original_discount > 0 AND p_offadj_line_rec.modified_discount < 0)
1655: THEN
1656: OZF_Utility_PVT.Error_Message('OZF_OFFADJ_DISC_DIFF');
1657: x_return_status := FND_API.g_ret_sts_error;
1658: return;
1659: END IF;
1660: END IF;
1661: IF (
1658: return;
1659: END IF;
1660: END IF;
1661: IF (
1662: p_offadj_line_rec.modified_discount_td IS NOT NULL AND p_offadj_line_rec.modified_discount_td <> FND_API.G_MISS_NUM
1663: )
1664: AND
1665: (
1666: p_offadj_line_rec.original_discount_td IS NOT NULL AND p_offadj_line_rec.original_discount_td <> FND_API.G_MISS_NUM
1662: p_offadj_line_rec.modified_discount_td IS NOT NULL AND p_offadj_line_rec.modified_discount_td <> FND_API.G_MISS_NUM
1663: )
1664: AND
1665: (
1666: p_offadj_line_rec.original_discount_td IS NOT NULL AND p_offadj_line_rec.original_discount_td <> FND_API.G_MISS_NUM
1667: )
1668: THEN
1669: IF
1670: (p_offadj_line_rec.original_discount_td < 0 AND p_offadj_line_rec.modified_discount_td > 0)
1671: OR
1672: (p_offadj_line_rec.original_discount_td > 0 AND p_offadj_line_rec.modified_discount_td < 0)
1673: THEN
1674: OZF_Utility_PVT.Error_Message('OZF_OFFADJ_DISC_DIFF');
1675: x_return_status := FND_API.g_ret_sts_error;
1676: return;
1677: END IF;
1678: END IF;
1679:
1706: close c_list_line_type_code;
1707:
1708:
1709: debug_message('OfferType is '||l_offer_type);
1710: x_return_status := FND_API.g_ret_sts_success;
1711:
1712: OZF_Offer_Adj_Line_PVT.debug_message('ValidationMOde is '||p_validation_mode || ' : '||JTF_PLSQL_API.g_create);
1713: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1714: IF p_offadj_line_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offadj_line_rec.offer_adjustment_id IS NULL THEN
1710: x_return_status := FND_API.g_ret_sts_success;
1711:
1712: OZF_Offer_Adj_Line_PVT.debug_message('ValidationMOde is '||p_validation_mode || ' : '||JTF_PLSQL_API.g_create);
1713: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1714: IF p_offadj_line_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offadj_line_rec.offer_adjustment_id IS NULL THEN
1715: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1716: x_return_status := FND_API.g_ret_sts_error;
1717: return;
1718: END IF;
1712: OZF_Offer_Adj_Line_PVT.debug_message('ValidationMOde is '||p_validation_mode || ' : '||JTF_PLSQL_API.g_create);
1713: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1714: IF p_offadj_line_rec.offer_adjustment_id = FND_API.G_MISS_NUM OR p_offadj_line_rec.offer_adjustment_id IS NULL THEN
1715: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1716: x_return_status := FND_API.g_ret_sts_error;
1717: return;
1718: END IF;
1719: IF p_offadj_line_rec.list_line_id = FND_API.G_MISS_NUM OR p_offadj_line_rec.list_line_id IS NULL THEN
1720: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_LINE_ID' );
1715: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1716: x_return_status := FND_API.g_ret_sts_error;
1717: return;
1718: END IF;
1719: IF p_offadj_line_rec.list_line_id = FND_API.G_MISS_NUM OR p_offadj_line_rec.list_line_id IS NULL THEN
1720: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_LINE_ID' );
1721: x_return_status := FND_API.g_ret_sts_error;
1722: return;
1723: END IF;
1717: return;
1718: END IF;
1719: IF p_offadj_line_rec.list_line_id = FND_API.G_MISS_NUM OR p_offadj_line_rec.list_line_id IS NULL THEN
1720: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_LINE_ID' );
1721: x_return_status := FND_API.g_ret_sts_error;
1722: return;
1723: END IF;
1724: IF p_offadj_line_rec.list_header_id = FND_API.G_MISS_NUM OR p_offadj_line_rec.list_header_id IS NULL THEN
1725: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1720: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_LINE_ID' );
1721: x_return_status := FND_API.g_ret_sts_error;
1722: return;
1723: END IF;
1724: IF p_offadj_line_rec.list_header_id = FND_API.G_MISS_NUM OR p_offadj_line_rec.list_header_id IS NULL THEN
1725: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1726: x_return_status := FND_API.g_ret_sts_error;
1727: return;
1728: END IF;
1722: return;
1723: END IF;
1724: IF p_offadj_line_rec.list_header_id = FND_API.G_MISS_NUM OR p_offadj_line_rec.list_header_id IS NULL THEN
1725: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1726: x_return_status := FND_API.g_ret_sts_error;
1727: return;
1728: END IF;
1729: debug_message('MOdified discount:' ||p_offadj_line_rec.modified_discount);
1730:
1730:
1731: IF (l_offer_type = 'OID' AND l_list_line_type_code <> 'DIS') THEN
1732: debug_message('Promotional Goods buy: offer type' ||l_offer_type||' list line type code: '|| l_list_line_type_code);
1733: ELSIF l_offer_type = 'DEAL' THEN
1734: IF (p_offadj_line_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount IS NULL)
1735: AND
1736: (p_offadj_line_rec.modified_discount_td = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount_td IS NULL)
1737: THEN
1738: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT/MODIFIED_DISCOUNT_TD' );
1732: debug_message('Promotional Goods buy: offer type' ||l_offer_type||' list line type code: '|| l_list_line_type_code);
1733: ELSIF l_offer_type = 'DEAL' THEN
1734: IF (p_offadj_line_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount IS NULL)
1735: AND
1736: (p_offadj_line_rec.modified_discount_td = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount_td IS NULL)
1737: THEN
1738: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT/MODIFIED_DISCOUNT_TD' );
1739: x_return_status := FND_API.g_ret_sts_error;
1740: return;
1735: AND
1736: (p_offadj_line_rec.modified_discount_td = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount_td IS NULL)
1737: THEN
1738: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT/MODIFIED_DISCOUNT_TD' );
1739: x_return_status := FND_API.g_ret_sts_error;
1740: return;
1741: END IF;
1742: IF (p_offadj_line_rec.original_discount IS NULL OR p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM )
1743: AND
1738: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT/MODIFIED_DISCOUNT_TD' );
1739: x_return_status := FND_API.g_ret_sts_error;
1740: return;
1741: END IF;
1742: IF (p_offadj_line_rec.original_discount IS NULL OR p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM )
1743: AND
1744: (p_offadj_line_rec.original_discount_td IS NULL OR p_offadj_line_rec.original_discount_td = FND_API.G_MISS_NUM)
1745:
1746: THEN
1740: return;
1741: END IF;
1742: IF (p_offadj_line_rec.original_discount IS NULL OR p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM )
1743: AND
1744: (p_offadj_line_rec.original_discount_td IS NULL OR p_offadj_line_rec.original_discount_td = FND_API.G_MISS_NUM)
1745:
1746: THEN
1747: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ORIGINAL_DISCOUNT/ORIGINAL_DISCOUNT_TD');
1748: x_return_status := FND_API.g_ret_sts_error;
1744: (p_offadj_line_rec.original_discount_td IS NULL OR p_offadj_line_rec.original_discount_td = FND_API.G_MISS_NUM)
1745:
1746: THEN
1747: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ORIGINAL_DISCOUNT/ORIGINAL_DISCOUNT_TD');
1748: x_return_status := FND_API.g_ret_sts_error;
1749: return;
1750: END IF;
1751: ELSE
1752: /* IF p_offadj_line_rec.quantity = FND_API.G_MISS_NUM OR p_offadj_line_rec.quantity IS NULL THEN
1748: x_return_status := FND_API.g_ret_sts_error;
1749: return;
1750: END IF;
1751: ELSE
1752: /* IF p_offadj_line_rec.quantity = FND_API.G_MISS_NUM OR p_offadj_line_rec.quantity IS NULL THEN
1753: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'Quantity' );
1754: -- x_return_status := FND_API.g_ret_sts_error;
1755: END IF;
1756: */
1750: END IF;
1751: ELSE
1752: /* IF p_offadj_line_rec.quantity = FND_API.G_MISS_NUM OR p_offadj_line_rec.quantity IS NULL THEN
1753: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'Quantity' );
1754: -- x_return_status := FND_API.g_ret_sts_error;
1755: END IF;
1756: */
1757: debug_message('MOdified discount:' ||p_offadj_line_rec.modified_discount);
1758: IF p_offadj_line_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount IS NULL THEN
1754: -- x_return_status := FND_API.g_ret_sts_error;
1755: END IF;
1756: */
1757: debug_message('MOdified discount:' ||p_offadj_line_rec.modified_discount);
1758: IF p_offadj_line_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount IS NULL THEN
1759: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );
1760: x_return_status := FND_API.g_ret_sts_error;
1761: return;
1762: END IF;
1756: */
1757: debug_message('MOdified discount:' ||p_offadj_line_rec.modified_discount);
1758: IF p_offadj_line_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount IS NULL THEN
1759: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );
1760: x_return_status := FND_API.g_ret_sts_error;
1761: return;
1762: END IF;
1763: IF p_offadj_line_rec.original_discount IS NULL OR p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM THEN
1764: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ORIGINAL_DISCOUNT');
1759: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT' );
1760: x_return_status := FND_API.g_ret_sts_error;
1761: return;
1762: END IF;
1763: IF p_offadj_line_rec.original_discount IS NULL OR p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM THEN
1764: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ORIGINAL_DISCOUNT');
1765: x_return_status := FND_API.g_ret_sts_error;
1766: return;
1767: END IF;
1761: return;
1762: END IF;
1763: IF p_offadj_line_rec.original_discount IS NULL OR p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM THEN
1764: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ORIGINAL_DISCOUNT');
1765: x_return_status := FND_API.g_ret_sts_error;
1766: return;
1767: END IF;
1768: END IF;
1769:
1767: END IF;
1768: END IF;
1769:
1770: ELSE
1771: IF p_offadj_line_rec.offer_adjustment_line_id = FND_API.G_MISS_NUM THEN
1772: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_LINE_ID' );
1773: x_return_status := FND_API.g_ret_sts_error;
1774: return;
1775: END IF;
1769:
1770: ELSE
1771: IF p_offadj_line_rec.offer_adjustment_line_id = FND_API.G_MISS_NUM THEN
1772: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_LINE_ID' );
1773: x_return_status := FND_API.g_ret_sts_error;
1774: return;
1775: END IF;
1776:
1777: IF p_offadj_line_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN
1773: x_return_status := FND_API.g_ret_sts_error;
1774: return;
1775: END IF;
1776:
1777: IF p_offadj_line_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN
1778: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1779: x_return_status := FND_API.g_ret_sts_error;
1780: return;
1781: END IF;
1775: END IF;
1776:
1777: IF p_offadj_line_rec.offer_adjustment_id = FND_API.G_MISS_NUM THEN
1778: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'OFFER_ADJUSTMENT_ID' );
1779: x_return_status := FND_API.g_ret_sts_error;
1780: return;
1781: END IF;
1782:
1783:
1780: return;
1781: END IF;
1782:
1783:
1784: IF p_offadj_line_rec.list_line_id = FND_API.G_MISS_NUM THEN
1785: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_LINE_ID' );
1786: x_return_status := FND_API.g_ret_sts_error;
1787: return;
1788: END IF;
1782:
1783:
1784: IF p_offadj_line_rec.list_line_id = FND_API.G_MISS_NUM THEN
1785: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_LINE_ID' );
1786: x_return_status := FND_API.g_ret_sts_error;
1787: return;
1788: END IF;
1789:
1790: IF p_offadj_line_rec.list_header_id = FND_API.G_MISS_NUM THEN
1786: x_return_status := FND_API.g_ret_sts_error;
1787: return;
1788: END IF;
1789:
1790: IF p_offadj_line_rec.list_header_id = FND_API.G_MISS_NUM THEN
1791: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1792: x_return_status := FND_API.g_ret_sts_error;
1793: return;
1794: END IF;
1788: END IF;
1789:
1790: IF p_offadj_line_rec.list_header_id = FND_API.G_MISS_NUM THEN
1791: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LIST_HEADER_ID' );
1792: x_return_status := FND_API.g_ret_sts_error;
1793: return;
1794: END IF;
1795:
1796: IF (l_offer_type = 'OID' AND l_list_line_type_code <> 'DIS') THEN
1795:
1796: IF (l_offer_type = 'OID' AND l_list_line_type_code <> 'DIS') THEN
1797: debug_message('Promotional Goods buy: offer type' ||l_offer_type||' list line type code: '|| l_list_line_type_code);
1798: ELSIF l_offer_type = 'DEAL' THEN
1799: IF (p_offadj_line_rec.modified_discount = FND_API.G_MISS_NUM )
1800: AND
1801: (p_offadj_line_rec.modified_discount_td = FND_API.G_MISS_NUM )
1802: THEN
1803: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT/MODIFIED_DISCOUNT_TD' );
1797: debug_message('Promotional Goods buy: offer type' ||l_offer_type||' list line type code: '|| l_list_line_type_code);
1798: ELSIF l_offer_type = 'DEAL' THEN
1799: IF (p_offadj_line_rec.modified_discount = FND_API.G_MISS_NUM )
1800: AND
1801: (p_offadj_line_rec.modified_discount_td = FND_API.G_MISS_NUM )
1802: THEN
1803: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT/MODIFIED_DISCOUNT_TD' );
1804: x_return_status := FND_API.g_ret_sts_error;
1805: return;
1800: AND
1801: (p_offadj_line_rec.modified_discount_td = FND_API.G_MISS_NUM )
1802: THEN
1803: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT/MODIFIED_DISCOUNT_TD' );
1804: x_return_status := FND_API.g_ret_sts_error;
1805: return;
1806: END IF;
1807: IF ( p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM )
1808: AND
1803: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT/MODIFIED_DISCOUNT_TD' );
1804: x_return_status := FND_API.g_ret_sts_error;
1805: return;
1806: END IF;
1807: IF ( p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM )
1808: AND
1809: (p_offadj_line_rec.original_discount_td = FND_API.G_MISS_NUM)
1810: THEN
1811: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ORIGINAL_DISCOUNT/ORIGINAL_DISCOUNT_TD');
1805: return;
1806: END IF;
1807: IF ( p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM )
1808: AND
1809: (p_offadj_line_rec.original_discount_td = FND_API.G_MISS_NUM)
1810: THEN
1811: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ORIGINAL_DISCOUNT/ORIGINAL_DISCOUNT_TD');
1812: x_return_status := FND_API.g_ret_sts_error;
1813: return;
1808: AND
1809: (p_offadj_line_rec.original_discount_td = FND_API.G_MISS_NUM)
1810: THEN
1811: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','ORIGINAL_DISCOUNT/ORIGINAL_DISCOUNT_TD');
1812: x_return_status := FND_API.g_ret_sts_error;
1813: return;
1814: END IF;
1815: ELSE
1816: debug_message('MOdified discount:' ||p_offadj_line_rec.modified_discount);
1813: return;
1814: END IF;
1815: ELSE
1816: debug_message('MOdified discount:' ||p_offadj_line_rec.modified_discount);
1817: IF p_offadj_line_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount IS NULL THEN
1818: IF p_offadj_line_rec.modified_discount_td = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount_td IS NULL THEN
1819: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT');
1820: x_return_status := FND_API.g_ret_sts_error;
1821: END IF;
1814: END IF;
1815: ELSE
1816: debug_message('MOdified discount:' ||p_offadj_line_rec.modified_discount);
1817: IF p_offadj_line_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount IS NULL THEN
1818: IF p_offadj_line_rec.modified_discount_td = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount_td IS NULL THEN
1819: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT');
1820: x_return_status := FND_API.g_ret_sts_error;
1821: END IF;
1822: debug_message('Original discount:' ||p_offadj_line_rec.original_discount);
1816: debug_message('MOdified discount:' ||p_offadj_line_rec.modified_discount);
1817: IF p_offadj_line_rec.modified_discount = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount IS NULL THEN
1818: IF p_offadj_line_rec.modified_discount_td = FND_API.G_MISS_NUM OR p_offadj_line_rec.modified_discount_td IS NULL THEN
1819: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT');
1820: x_return_status := FND_API.g_ret_sts_error;
1821: END IF;
1822: debug_message('Original discount:' ||p_offadj_line_rec.original_discount);
1823: IF p_offadj_line_rec.original_discount IS NULL OR p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM THEN
1824: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','original_discount');
1819: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'MODIFIED_DISCOUNT');
1820: x_return_status := FND_API.g_ret_sts_error;
1821: END IF;
1822: debug_message('Original discount:' ||p_offadj_line_rec.original_discount);
1823: IF p_offadj_line_rec.original_discount IS NULL OR p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM THEN
1824: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','original_discount');
1825: x_return_status := FND_API.g_ret_sts_error;
1826: return;
1827: END IF;
1821: END IF;
1822: debug_message('Original discount:' ||p_offadj_line_rec.original_discount);
1823: IF p_offadj_line_rec.original_discount IS NULL OR p_offadj_line_rec.original_discount = FND_API.G_MISS_NUM THEN
1824: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','original_discount');
1825: x_return_status := FND_API.g_ret_sts_error;
1826: return;
1827: END IF;
1828:
1829: END IF;
1839: x_return_status OUT NOCOPY VARCHAR2
1840: )
1841: IS
1842: BEGIN
1843: x_return_status := FND_API.g_ret_sts_success;
1844:
1845: -- Enter custom code here
1846:
1847: END check_Offadj_Line_Fk_Items;
1853: x_return_status OUT NOCOPY VARCHAR2
1854: )
1855: IS
1856: BEGIN
1857: x_return_status := FND_API.g_ret_sts_success;
1858:
1859: -- Enter custom code here
1860:
1861: END check_Offadj_Line_Lookup_Items;
1870: IS
1871: l_return_status VARCHAR2(1);
1872: BEGIN
1873:
1874: l_return_status := FND_API.g_ret_sts_success;
1875: debug_message('inside check offadj line Req items');
1876: check_offadj_line_req_items(
1877: p_offadj_line_rec => p_offadj_line_rec,
1878: p_validation_mode => p_validation_mode,
1876: check_offadj_line_req_items(
1877: p_offadj_line_rec => p_offadj_line_rec,
1878: p_validation_mode => p_validation_mode,
1879: x_return_status => x_return_status);
1880: IF x_return_status <> FND_API.g_ret_sts_success THEN
1881: l_return_status := FND_API.g_ret_sts_error;
1882: END IF;
1883:
1884: -- Check Items Uniqueness API calls
1877: p_offadj_line_rec => p_offadj_line_rec,
1878: p_validation_mode => p_validation_mode,
1879: x_return_status => x_return_status);
1880: IF x_return_status <> FND_API.g_ret_sts_success THEN
1881: l_return_status := FND_API.g_ret_sts_error;
1882: END IF;
1883:
1884: -- Check Items Uniqueness API calls
1885:
1887: check_Offadj_line_Uk_Items(
1888: p_offadj_line_rec => p_offadj_line_rec,
1889: p_validation_mode => p_validation_mode,
1890: x_return_status => x_return_status);
1891: IF x_return_status <> FND_API.g_ret_sts_success THEN
1892: l_return_status := FND_API.g_ret_sts_error;
1893: END IF;
1894:
1895: -- Check Items Required/NOT NULL API calls
1888: p_offadj_line_rec => p_offadj_line_rec,
1889: p_validation_mode => p_validation_mode,
1890: x_return_status => x_return_status);
1891: IF x_return_status <> FND_API.g_ret_sts_success THEN
1892: l_return_status := FND_API.g_ret_sts_error;
1893: END IF;
1894:
1895: -- Check Items Required/NOT NULL API calls
1896:
1899: debug_message('inside check offadj line Fk items');
1900: check_offadj_line_FK_items(
1901: p_offadj_line_rec => p_offadj_line_rec,
1902: x_return_status => x_return_status);
1903: IF x_return_status <> FND_API.g_ret_sts_success THEN
1904: l_return_status := FND_API.g_ret_sts_error;
1905: END IF;
1906:
1907: -- Check Items Lookups
1900: check_offadj_line_FK_items(
1901: p_offadj_line_rec => p_offadj_line_rec,
1902: x_return_status => x_return_status);
1903: IF x_return_status <> FND_API.g_ret_sts_success THEN
1904: l_return_status := FND_API.g_ret_sts_error;
1905: END IF;
1906:
1907: -- Check Items Lookups
1908: debug_message('inside check offadj line LkUP items');
1908: debug_message('inside check offadj line LkUP items');
1909: check_offadj_line_Lookup_items(
1910: p_offadj_line_rec => p_offadj_line_rec,
1911: x_return_status => x_return_status);
1912: IF x_return_status <> FND_API.g_ret_sts_success THEN
1913: l_return_status := FND_API.g_ret_sts_error;
1914: END IF;
1915:
1916: check_offadj_inter_attr
1909: check_offadj_line_Lookup_items(
1910: p_offadj_line_rec => p_offadj_line_rec,
1911: x_return_status => x_return_status);
1912: IF x_return_status <> FND_API.g_ret_sts_success THEN
1913: l_return_status := FND_API.g_ret_sts_error;
1914: END IF;
1915:
1916: check_offadj_inter_attr
1917: (
1918: p_offadj_line_rec => p_offadj_line_rec,
1919: p_validation_mode => p_validation_mode,
1920: x_return_status => x_return_status
1921: );
1922: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1923: RAISE FND_API.G_EXC_ERROR;
1924: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1926: END IF;
1919: p_validation_mode => p_validation_mode,
1920: x_return_status => x_return_status
1921: );
1922: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1923: RAISE FND_API.G_EXC_ERROR;
1924: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1926: END IF;
1927:
1920: x_return_status => x_return_status
1921: );
1922: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1923: RAISE FND_API.G_EXC_ERROR;
1924: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1926: END IF;
1927:
1928: x_return_status := l_return_status;
1921: );
1922: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1923: RAISE FND_API.G_EXC_ERROR;
1924: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1925: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1926: END IF;
1927:
1928: x_return_status := l_return_status;
1929:
2056: l_offadj_line_rec offadj_line_rec_type := p_offadj_line_rec;
2057: BEGIN
2058: -- Developers should put their code to default the record type
2059: -- e.g. IF p_campaign_rec.status_code IS NULL
2060: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
2061: -- l_campaign_rec.status_code := 'NEW' ;
2062: -- END IF ;
2063: --
2064: x_offadj_line_rec.offer_adjustment_line_id := p_offadj_line_rec.offer_adjustment_line_id;
2086:
2087:
2088: PROCEDURE Validate_Offer_Adj_Line(
2089: p_api_version_number IN NUMBER,
2090: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2091: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2092: p_offadj_line_rec IN offadj_line_rec_type,
2093: p_validation_mode IN VARCHAR2,
2094: x_return_status OUT NOCOPY VARCHAR2,
2087:
2088: PROCEDURE Validate_Offer_Adj_Line(
2089: p_api_version_number IN NUMBER,
2090: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2091: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2092: p_offadj_line_rec IN offadj_line_rec_type,
2093: p_validation_mode IN VARCHAR2,
2094: x_return_status OUT NOCOPY VARCHAR2,
2095: x_msg_count OUT NOCOPY NUMBER,
2105: -- Standard Start of API savepoint
2106: SAVEPOINT validate_offer_adj_line_;
2107:
2108: -- Standard call to check for call compatibility.
2109: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2110: p_api_version_number,
2111: l_api_name,
2112: G_PKG_NAME)
2113: THEN
2110: p_api_version_number,
2111: l_api_name,
2112: G_PKG_NAME)
2113: THEN
2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2115: END IF;
2116:
2117:
2118: -- Initialize message list if p_init_msg_list is set to TRUE.
2115: END IF;
2116:
2117:
2118: -- Initialize message list if p_init_msg_list is set to TRUE.
2119: IF FND_API.to_Boolean( p_init_msg_list )
2120: THEN
2121: FND_MSG_PUB.initialize;
2122: END IF;
2123:
2127: p_validation_mode => p_validation_mode,
2128: x_return_status => x_return_status
2129: );
2130:
2131: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2132: RAISE FND_API.G_EXC_ERROR;
2133: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: END IF;
2128: x_return_status => x_return_status
2129: );
2130:
2131: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2132: RAISE FND_API.G_EXC_ERROR;
2133: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: END IF;
2136: END IF;
2129: );
2130:
2131: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2132: RAISE FND_API.G_EXC_ERROR;
2133: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: END IF;
2136: END IF;
2137:
2130:
2131: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2132: RAISE FND_API.G_EXC_ERROR;
2133: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2135: END IF;
2136: END IF;
2137:
2138: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2148:
2149: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2150: Validate_offadj_line_Rec(
2151: p_api_version_number => 1.0,
2152: p_init_msg_list => FND_API.G_FALSE,
2153: x_return_status => x_return_status,
2154: x_msg_count => x_msg_count,
2155: x_msg_data => x_msg_data,
2156: p_offadj_line_rec => l_offadj_line_rec);
2154: x_msg_count => x_msg_count,
2155: x_msg_data => x_msg_data,
2156: p_offadj_line_rec => l_offadj_line_rec);
2157:
2158: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2159: RAISE FND_API.G_EXC_ERROR;
2160: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2162: END IF;
2155: x_msg_data => x_msg_data,
2156: p_offadj_line_rec => l_offadj_line_rec);
2157:
2158: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2159: RAISE FND_API.G_EXC_ERROR;
2160: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2162: END IF;
2163: END IF;
2156: p_offadj_line_rec => l_offadj_line_rec);
2157:
2158: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2159: RAISE FND_API.G_EXC_ERROR;
2160: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2162: END IF;
2163: END IF;
2164:
2157:
2158: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2159: RAISE FND_API.G_EXC_ERROR;
2160: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2162: END IF;
2163: END IF;
2164:
2165:
2168:
2169:
2170:
2171: -- Initialize API return status to SUCCESS
2172: x_return_status := FND_API.G_RET_STS_SUCCESS;
2173:
2174:
2175: -- Debug Message
2176: debug_message('Private API: ' || l_api_name || 'end');
2183: );
2184: EXCEPTION
2185:
2186: WHEN OZF_Utility_PVT.resource_locked THEN
2187: x_return_status := FND_API.g_ret_sts_error;
2188: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
2189:
2190: WHEN FND_API.G_EXC_ERROR THEN
2191: ROLLBACK TO VALIDATE_Offer_Adj_Line_;
2186: WHEN OZF_Utility_PVT.resource_locked THEN
2187: x_return_status := FND_API.g_ret_sts_error;
2188: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
2189:
2190: WHEN FND_API.G_EXC_ERROR THEN
2191: ROLLBACK TO VALIDATE_Offer_Adj_Line_;
2192: x_return_status := FND_API.G_RET_STS_ERROR;
2193: -- Standard call to get message count and if count=1, get the message
2194: FND_MSG_PUB.Count_And_Get (
2188: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_API_RESOURCE_LOCKED');
2189:
2190: WHEN FND_API.G_EXC_ERROR THEN
2191: ROLLBACK TO VALIDATE_Offer_Adj_Line_;
2192: x_return_status := FND_API.G_RET_STS_ERROR;
2193: -- Standard call to get message count and if count=1, get the message
2194: FND_MSG_PUB.Count_And_Get (
2195: p_encoded => FND_API.G_FALSE,
2196: p_count => x_msg_count,
2191: ROLLBACK TO VALIDATE_Offer_Adj_Line_;
2192: x_return_status := FND_API.G_RET_STS_ERROR;
2193: -- Standard call to get message count and if count=1, get the message
2194: FND_MSG_PUB.Count_And_Get (
2195: p_encoded => FND_API.G_FALSE,
2196: p_count => x_msg_count,
2197: p_data => x_msg_data
2198: );
2199:
2196: p_count => x_msg_count,
2197: p_data => x_msg_data
2198: );
2199:
2200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2201: ROLLBACK TO VALIDATE_Offer_Adj_Line_;
2202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2203: -- Standard call to get message count and if count=1, get the message
2204: FND_MSG_PUB.Count_And_Get (
2198: );
2199:
2200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2201: ROLLBACK TO VALIDATE_Offer_Adj_Line_;
2202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2203: -- Standard call to get message count and if count=1, get the message
2204: FND_MSG_PUB.Count_And_Get (
2205: p_encoded => FND_API.G_FALSE,
2206: p_count => x_msg_count,
2201: ROLLBACK TO VALIDATE_Offer_Adj_Line_;
2202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2203: -- Standard call to get message count and if count=1, get the message
2204: FND_MSG_PUB.Count_And_Get (
2205: p_encoded => FND_API.G_FALSE,
2206: p_count => x_msg_count,
2207: p_data => x_msg_data
2208: );
2209:
2208: );
2209:
2210: WHEN OTHERS THEN
2211: ROLLBACK TO VALIDATE_Offer_Adj_Line_;
2212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2214: THEN
2215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2216: END IF;
2215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2216: END IF;
2217: -- Standard call to get message count and if count=1, get the message
2218: FND_MSG_PUB.Count_And_Get (
2219: p_encoded => FND_API.G_FALSE,
2220: p_count => x_msg_count,
2221: p_data => x_msg_data
2222: );
2223: End Validate_Offer_Adj_Line;
2224:
2225:
2226: PROCEDURE Validate_Offadj_Line_Rec (
2227: p_api_version_number IN NUMBER,
2228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2229: x_return_status OUT NOCOPY VARCHAR2,
2230: x_msg_count OUT NOCOPY NUMBER,
2231: x_msg_data OUT NOCOPY VARCHAR2,
2232: p_offadj_line_rec IN offadj_line_rec_type
2233: )
2234: IS
2235: BEGIN
2236: -- Initialize message list if p_init_msg_list is set to TRUE.
2237: IF FND_API.to_Boolean( p_init_msg_list )
2238: THEN
2239: FND_MSG_PUB.initialize;
2240: END IF;
2241:
2241:
2242:
2243:
2244: -- Initialize API return status to SUCCESS
2245: x_return_status := FND_API.G_RET_STS_SUCCESS;
2246:
2247: -- Hint: Validate data
2248: -- If data not valid
2249: -- THEN
2246:
2247: -- Hint: Validate data
2248: -- If data not valid
2249: -- THEN
2250: -- x_return_status := FND_API.G_RET_STS_ERROR;
2251:
2252: -- Debug Message
2253: debug_message('Private API: Validate_dm_model_rec');
2254: -- Standard call to get message count and if count is 1, get message info.