93: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
94: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
95: BEGIN
96:
97: oe_debug_pub.add('Ren: inside default attr of prc attr 1');
98: -- Set control flags.
99:
100: l_control_rec.controlled_operation := TRUE;
101: l_control_rec.default_attributes := TRUE;
164: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
165: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
166: );
167:
168: oe_debug_pub.add('Ren: after process price list 1');
169:
170: oe_debug_pub.add('return status is : ' || l_return_status);
171:
172: oe_debug_pub.add('ren: msg data 1 is : ' || x_msg_data);
166: );
167:
168: oe_debug_pub.add('Ren: after process price list 1');
169:
170: oe_debug_pub.add('return status is : ' || l_return_status);
171:
172: oe_debug_pub.add('ren: msg data 1 is : ' || x_msg_data);
173:
174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
168: oe_debug_pub.add('Ren: after process price list 1');
169:
170: oe_debug_pub.add('return status is : ' || l_return_status);
171:
172: oe_debug_pub.add('ren: msg data 1 is : ' || x_msg_data);
173:
174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
219: x_product_attribute_datatype := l_x_PRICING_ATTR_rec.product_attribute_datatype;
220:
221: -- Load display out parameters if any
222:
223: oe_debug_pub.add('Ren: before get_values 1');
224: oe_debug_pub.add('ren : msg data 0.5 is : ' || x_msg_data);
225:
226: l_PRICING_ATTR_val_rec := Qp_pll_pricing_attr_Util.Get_Values
227: ( p_PRICING_ATTR_rec => l_x_PRICING_ATTR_rec
220:
221: -- Load display out parameters if any
222:
223: oe_debug_pub.add('Ren: before get_values 1');
224: oe_debug_pub.add('ren : msg data 0.5 is : ' || x_msg_data);
225:
226: l_PRICING_ATTR_val_rec := Qp_pll_pricing_attr_Util.Get_Values
227: ( p_PRICING_ATTR_rec => l_x_PRICING_ATTR_rec
228: );
231: x_list_line := l_PRICING_ATTR_val_rec.list_line;
232: x_product_uom := l_PRICING_ATTR_val_rec.product_uom;
233:
234:
235: oe_debug_pub.add('Ren: after get_values 1 ');
236:
237: -- Write to cache.
238: -- Set db_flag to False before writing to cache
239:
238: -- Set db_flag to False before writing to cache
239:
240: l_x_PRICING_ATTR_rec.db_flag := FND_API.G_FALSE;
241:
242: oe_debug_pub.add('Ren: before write prc attr 1');
243: oe_debug_pub.add('Ren: msg data 1 is :' || x_msg_data);
244:
245: Write_PRICING_ATTR
246: ( p_PRICING_ATTR_rec => l_x_PRICING_ATTR_rec
239:
240: l_x_PRICING_ATTR_rec.db_flag := FND_API.G_FALSE;
241:
242: oe_debug_pub.add('Ren: before write prc attr 1');
243: oe_debug_pub.add('Ren: msg data 1 is :' || x_msg_data);
244:
245: Write_PRICING_ATTR
246: ( p_PRICING_ATTR_rec => l_x_PRICING_ATTR_rec
247: );
245: Write_PRICING_ATTR
246: ( p_PRICING_ATTR_rec => l_x_PRICING_ATTR_rec
247: );
248:
249: oe_debug_pub.add('Ren: msg data 2 is :' || x_msg_data);
250:
251: -- Set return status.
252:
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
258: ( p_count => x_msg_count
259: , p_data => x_msg_data
260: );
261:
262: oe_debug_pub.add('Ren: msg data 2.5 is :' || x_msg_data);
263:
264: oe_debug_pub.add('exiting default attributes');
265:
266:
260: );
261:
262: oe_debug_pub.add('Ren: msg data 2.5 is :' || x_msg_data);
263:
264: oe_debug_pub.add('exiting default attributes');
265:
266:
267: EXCEPTION
268:
893: l_x_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
894: l_x_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;
895: BEGIN
896:
897: oe_debug_pub.add('entering validate_and_write');
898: -- Set control flags.
899:
900: l_control_rec.controlled_operation := TRUE;
901: l_control_rec.validate_entity := TRUE;
987: x_return_status := FND_API.G_RET_STS_SUCCESS;
988:
989: -- Get message count and data
990:
991: oe_debug_pub.add('Ren: msg data in val_and_write of attr 1 is :' || x_msg_data);
992:
993: oe_msg_pub.Count_And_Get
994: ( p_count => x_msg_count
995: , p_data => x_msg_data
993: oe_msg_pub.Count_And_Get
994: ( p_count => x_msg_count
995: , p_data => x_msg_data
996: );
997: oe_debug_pub.add('Ren: msg data in val_and_write of attr 2 is :' || x_msg_data);
998:
999: oe_debug_pub.add('exiting validate_and_write');
1000:
1001: EXCEPTION
995: , p_data => x_msg_data
996: );
997: oe_debug_pub.add('Ren: msg data in val_and_write of attr 2 is :' || x_msg_data);
998:
999: oe_debug_pub.add('exiting validate_and_write');
1000:
1001: EXCEPTION
1002:
1003: WHEN FND_API.G_EXC_ERROR THEN
1009: oe_msg_pub.Count_And_Get
1010: ( p_count => x_msg_count
1011: , p_data => x_msg_data
1012: );
1013: oe_debug_pub.add('Ren: msg data in val_and_write of attr 10 is :' || x_msg_data);
1014:
1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1016:
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1021: oe_msg_pub.Count_And_Get
1022: ( p_count => x_msg_count
1023: , p_data => x_msg_data
1024: );
1025: oe_debug_pub.add('Ren: msg data in val_and_write of attr 11 is :' || x_msg_data);
1026:
1027: WHEN OTHERS THEN
1028:
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1041: oe_msg_pub.Count_And_Get
1042: ( p_count => x_msg_count
1043: , p_data => x_msg_data
1044: );
1045: oe_debug_pub.add('Ren: msg data in val_and_write of attr 12 is :' || x_msg_data);
1046:
1047: END Validate_And_Write;
1048:
1049: -- Procedure Delete_Row
1116:
1117: IF (QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' or QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES IS NULL)
1118: THEN -- 5018856, 5024919 do not log request if N
1119:
1120: oe_debug_pub.add('about to log a request to check duplicate list lines ');
1121:
1122: QP_DELAYED_REQUESTS_PVT.Log_Request
1123: ( p_entity_code => QP_GLOBALS.G_ENTITY_ALL
1124: , p_entity_id => l_pricing_attr_rec.list_line_id
1133: );
1134:
1135: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1136:
1137: oe_debug_pub.add('failed in logging a delayed request in delete_row ');
1138:
1139: RAISE FND_API.G_EXC_ERROR;
1140:
1141: END IF;
1139: RAISE FND_API.G_EXC_ERROR;
1140:
1141: END IF;
1142:
1143: oe_debug_pub.add('after logging delayed request ');
1144:
1145: -- end bug2301959
1146: END IF; -- END IF QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' -- 5018856,, 5024919
1147:
1144:
1145: -- end bug2301959
1146: END IF; -- END IF QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES <> 'N' -- 5018856,, 5024919
1147:
1148: oe_debug_pub.add('Logging a request to update qualification_ind ', 1);
1149: qp_delayed_requests_PVT.log_request(
1150: p_entity_code => QP_GLOBALS.G_ENTITY_Price_List_Line,
1151: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1152: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_Price_List_Line,
1155: x_return_status => l_return_status);
1156:
1157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1158:
1159: oe_debug_pub.add('failed in logging a delayed request in delete_row ');
1160:
1161: RAISE FND_API.G_EXC_ERROR;
1162:
1163: END IF;
2169: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2170: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2171: , x_return_status => l_return_status);
2172: END IF;
2173: oe_debug_pub.add('QPXFPLAB - l_return_status = ' || l_return_status);
2174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2177: RAISE FND_API.G_EXC_ERROR;