196: oe_debug_pub.add('new unit selling price: ' || l_line_rec.unit_selling_price);
197: oe_debug_pub.add('old unit selling price: ' || p_old_line_tbl(I).unit_selling_price);
198: oe_debug_pub.add('ack code: price changed');
199: END IF;
200: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
201: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
202:
203: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
204: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
197: oe_debug_pub.add('old unit selling price: ' || p_old_line_tbl(I).unit_selling_price);
198: oe_debug_pub.add('ack code: price changed');
199: END IF;
200: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
201: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
202:
203: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
204: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
205:
199: END IF;
200: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
201: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
202:
203: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
204: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
205:
206: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
207: l_line_rec.FIRST_ACK_CODE := 'IP';
200: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
201: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
202:
203: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
204: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
205:
206: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
207: l_line_rec.FIRST_ACK_CODE := 'IP';
208: oe_debug_pub.add(' ack code: price changed : '||l_line_rec.FIRST_ACK_CODE,5);
202:
203: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
204: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
205:
206: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
207: l_line_rec.FIRST_ACK_CODE := 'IP';
208: oe_debug_pub.add(' ack code: price changed : '||l_line_rec.FIRST_ACK_CODE,5);
209: END IF;
210: oe_debug_pub.add(' new unit selling price: ' || l_line_rec.unit_selling_price,5);
296: oe_debug_pub.add('old unit selling price: ' || p_old_line_tbl(I).unit_selling_price);
297: oe_debug_pub.add('ack code: price changed');
298: END IF;
299:
300: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
301: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
302:
303: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
304: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
297: oe_debug_pub.add('ack code: price changed');
298: END IF;
299:
300: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
301: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
302:
303: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
304: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
305:
299:
300: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
301: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
302:
303: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
304: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
305:
306: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
307: l_line_rec.LAST_ACK_CODE := 'IP';
300: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
301: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
302:
303: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
304: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
305:
306: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
307: l_line_rec.LAST_ACK_CODE := 'IP';
308: oe_debug_pub.add(' ack code: price changed : '||l_line_rec.FIRST_ACK_CODE,5);
302:
303: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
304: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
305:
306: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
307: l_line_rec.LAST_ACK_CODE := 'IP';
308: oe_debug_pub.add(' ack code: price changed : '||l_line_rec.FIRST_ACK_CODE,5);
309: END IF;
310: oe_debug_pub.add(' new unit selling price: ' || l_line_rec.unit_selling_price,5);
1715: -- Added for bug 4771523 start
1716: If l_line_tbl(i).unit_selling_price <> p_old_line_tbl(i).unit_selling_price Then
1717: l_line_tbl(i).first_ack_code := 'IP';
1718: End If;
1719: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1720: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1721: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1722: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1723: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1716: If l_line_tbl(i).unit_selling_price <> p_old_line_tbl(i).unit_selling_price Then
1717: l_line_tbl(i).first_ack_code := 'IP';
1718: End If;
1719: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1720: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1721: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1722: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1723: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1724: l_line_tbl(i).FIRST_ACK_CODE := 'IP';
1717: l_line_tbl(i).first_ack_code := 'IP';
1718: End If;
1719: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1720: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1721: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1722: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1723: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1724: l_line_tbl(i).FIRST_ACK_CODE := 'IP';
1725: oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);
1718: End If;
1719: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1720: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1721: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1722: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1723: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1724: l_line_tbl(i).FIRST_ACK_CODE := 'IP';
1725: oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);
1726: END IF;
1719: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1720: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1721: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1722: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1723: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1724: l_line_tbl(i).FIRST_ACK_CODE := 'IP';
1725: oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);
1726: END IF;
1727: oe_debug_pub.add(' new unit selling price: ' || l_line_tbl(i).unit_selling_price,5);
1787: -- Added for bug 4771523
1788: If l_line_tbl(i).unit_selling_price <> p_old_line_tbl(i).unit_selling_price Then
1789: l_line_tbl(i).LAST_ACK_CODE := 'IP';
1790: End If;
1791: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1792: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1793: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1794: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1795: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1788: If l_line_tbl(i).unit_selling_price <> p_old_line_tbl(i).unit_selling_price Then
1789: l_line_tbl(i).LAST_ACK_CODE := 'IP';
1790: End If;
1791: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1792: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1793: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1794: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1795: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1796: l_line_tbl(i).LAST_ACK_CODE := 'IP';
1789: l_line_tbl(i).LAST_ACK_CODE := 'IP';
1790: End If;
1791: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1792: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1793: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1794: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1795: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1796: l_line_tbl(i).LAST_ACK_CODE := 'IP';
1797: oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);
1790: End If;
1791: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1792: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1793: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1794: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1795: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1796: l_line_tbl(i).LAST_ACK_CODE := 'IP';
1797: oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);
1798: END IF;
1791: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1792: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1793: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1794: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1795: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1796: l_line_tbl(i).LAST_ACK_CODE := 'IP';
1797: oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);
1798: END IF;
1799: oe_debug_pub.add(' new unit selling price: ' || l_line_tbl(i).unit_selling_price,5);