DBA Data[Home] [Help]

APPS.OE_LINE_ACK_UTIL dependencies on OE_ORDER_UTIL

Line 185: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL

181: oe_debug_pub.add('new unit selling price: ' || l_line_rec.unit_selling_price);
182: oe_debug_pub.add('old unit selling price: ' || p_old_line_tbl(I).unit_selling_price);
183: oe_debug_pub.add('ack code: price changed');
184: END IF;
185: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
186: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
187:
188: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
189: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);

Line 186: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN

182: oe_debug_pub.add('old unit selling price: ' || p_old_line_tbl(I).unit_selling_price);
183: oe_debug_pub.add('ack code: price changed');
184: END IF;
185: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
186: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
187:
188: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
189: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
190:

Line 188: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);

184: END IF;
185: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
186: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
187:
188: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
189: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
190:
191: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
192: l_line_rec.FIRST_ACK_CODE := 'IP';

Line 189: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);

185: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
186: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
187:
188: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
189: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
190:
191: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
192: l_line_rec.FIRST_ACK_CODE := 'IP';
193: oe_debug_pub.add(' ack code: price changed : '||l_line_rec.FIRST_ACK_CODE,5);

Line 191: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN

187:
188: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
189: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
190:
191: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
192: l_line_rec.FIRST_ACK_CODE := 'IP';
193: oe_debug_pub.add(' ack code: price changed : '||l_line_rec.FIRST_ACK_CODE,5);
194: END IF;
195: oe_debug_pub.add(' new unit selling price: ' || l_line_rec.unit_selling_price,5);

Line 285: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL

281: oe_debug_pub.add('old unit selling price: ' || p_old_line_tbl(I).unit_selling_price);
282: oe_debug_pub.add('ack code: price changed');
283: END IF;
284:
285: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
286: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
287:
288: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
289: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);

Line 286: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN

282: oe_debug_pub.add('ack code: price changed');
283: END IF;
284:
285: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
286: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
287:
288: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
289: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
290:

Line 288: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);

284:
285: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
286: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
287:
288: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
289: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
290:
291: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
292: l_line_rec.LAST_ACK_CODE := 'IP';

Line 289: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);

285: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
286: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
287:
288: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
289: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
290:
291: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
292: l_line_rec.LAST_ACK_CODE := 'IP';
293: oe_debug_pub.add(' ack code: price changed : '||l_line_rec.FIRST_ACK_CODE,5);

Line 291: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN

287:
288: oe_debug_pub.add(' unit_selling_price in global : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
289: oe_debug_pub.add(' CUSTOMER_ITEM_NET_PRICE in global : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
290:
291: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
292: l_line_rec.LAST_ACK_CODE := 'IP';
293: oe_debug_pub.add(' ack code: price changed : '||l_line_rec.FIRST_ACK_CODE,5);
294: END IF;
295: oe_debug_pub.add(' new unit selling price: ' || l_line_rec.unit_selling_price,5);

Line 1667: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL

1663: -- Added for bug 4771523 start
1664: If l_line_tbl(i).unit_selling_price <> p_old_line_tbl(i).unit_selling_price Then
1665: l_line_tbl(i).first_ack_code := 'IP';
1666: End If;
1667: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1668: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1669: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1670: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1671: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN

Line 1668: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN

1664: If l_line_tbl(i).unit_selling_price <> p_old_line_tbl(i).unit_selling_price Then
1665: l_line_tbl(i).first_ack_code := 'IP';
1666: End If;
1667: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1668: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1669: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1670: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1671: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1672: l_line_tbl(i).FIRST_ACK_CODE := 'IP';

Line 1669: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);

1665: l_line_tbl(i).first_ack_code := 'IP';
1666: End If;
1667: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1668: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1669: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1670: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1671: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1672: l_line_tbl(i).FIRST_ACK_CODE := 'IP';
1673: oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);

Line 1670: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);

1666: End If;
1667: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1668: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1669: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1670: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1671: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1672: l_line_tbl(i).FIRST_ACK_CODE := 'IP';
1673: oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);
1674: END IF;

Line 1671: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN

1667: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1668: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1669: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1670: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1671: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1672: l_line_tbl(i).FIRST_ACK_CODE := 'IP';
1673: oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);
1674: END IF;
1675: oe_debug_pub.add(' new unit selling price: ' || l_line_tbl(i).unit_selling_price,5);

Line 1739: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL

1735: -- Added for bug 4771523
1736: If l_line_tbl(i).unit_selling_price <> p_old_line_tbl(i).unit_selling_price Then
1737: l_line_tbl(i).LAST_ACK_CODE := 'IP';
1738: End If;
1739: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1740: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1741: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1742: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1743: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN

Line 1740: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN

1736: If l_line_tbl(i).unit_selling_price <> p_old_line_tbl(i).unit_selling_price Then
1737: l_line_tbl(i).LAST_ACK_CODE := 'IP';
1738: End If;
1739: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1740: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1741: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1742: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1743: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1744: l_line_tbl(i).LAST_ACK_CODE := 'IP';

Line 1741: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);

1737: l_line_tbl(i).LAST_ACK_CODE := 'IP';
1738: End If;
1739: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1740: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1741: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1742: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1743: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1744: l_line_tbl(i).LAST_ACK_CODE := 'IP';
1745: oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);

Line 1742: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);

1738: End If;
1739: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1740: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1741: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1742: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1743: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1744: l_line_tbl(i).LAST_ACK_CODE := 'IP';
1745: oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);
1746: END IF;

Line 1743: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN

1739: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price IS NOT NULL
1740: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM THEN
1741: oe_debug_pub.add(' Global Unit_Selling_Price : '||OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price,5);
1742: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,5);
1743: IF OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> OE_ORDER_UTIL.g_line_tbl(I).unit_selling_price THEN
1744: l_line_tbl(i).LAST_ACK_CODE := 'IP';
1745: oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);
1746: END IF;
1747: oe_debug_pub.add(' new unit selling price: ' || l_line_tbl(i).unit_selling_price,5);