eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_LINE_ACK_UTIL dependencies on FND_API

Line 179: l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR) THEN -- It is 855

175: oe_debug_pub.add('l_line_rec.SCHEDULE_SHIP_DATE :' || l_line_rec.SCHEDULE_SHIP_DATE,1);
176: oe_debug_pub.add('l_line_rec.REQUEST_DATE :' || l_line_rec.REQUEST_DATE, 1);
177:
178: IF (nvl(l_line_rec.FIRST_ACK_CODE, ' ')= ' ' OR
179: l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR) THEN -- It is 855
180: oe_debug_pub.add('trans is 855 with first_ack_code ' ||nvl(l_line_rec.FIRST_ACK_CODE, 'NULL' ));
181: IF l_line_rec.SCHEDULE_SHIP_DATE is NULL THEN
182: oe_debug_pub.add('ack code: schedule ship date is null');
183: l_line_rec.FIRST_ACK_CODE := 'SP';

Line 186: AND trunc(l_line_rec.SCHEDULE_SHIP_DATE) <> nvl(trunc(l_line_rec.REQUEST_DATE), FND_API.G_MISS_DATE)

182: oe_debug_pub.add('ack code: schedule ship date is null');
183: l_line_rec.FIRST_ACK_CODE := 'SP';
184: END IF;
185: IF l_line_rec.SCHEDULE_SHIP_DATE is NOT NULL
186: AND trunc(l_line_rec.SCHEDULE_SHIP_DATE) <> nvl(trunc(l_line_rec.REQUEST_DATE), FND_API.G_MISS_DATE)
187: THEN
188: oe_debug_pub.add('ack code: date rescheduled');
189: l_line_rec.FIRST_ACK_CODE := 'DR';
190: END IF;

Line 193: If nvl(l_line_rec.unit_selling_price, FND_API.G_MISS_NUM) <> nvl(p_old_line_tbl(I).unit_selling_price, FND_API.G_MISS_NUM)

189: l_line_rec.FIRST_ACK_CODE := 'DR';
190: END IF;
191:
192: --Added for bug 4771523+bug 4454400 start
193: If nvl(l_line_rec.unit_selling_price, FND_API.G_MISS_NUM) <> nvl(p_old_line_tbl(I).unit_selling_price, FND_API.G_MISS_NUM)
194: THEN
195: l_line_rec.FIRST_ACK_CODE := 'IP';
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);

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

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:

Line 218: IF l_line_rec.FIRST_ACK_CODE IS NULL or l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then

214:
215:
216: IF l_line_rec.ORDERED_QUANTITY <> p_old_line_tbl(I).ORDERED_QUANTITY
217: THEN
218: IF l_line_rec.FIRST_ACK_CODE IS NULL or l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then
219: l_line_rec.FIRST_ACK_CODE := 'IQ';
220: ELSE
221: l_line_rec.FIRST_ACK_CODE := 'IC'; -- item accepted, (multiple) changes made , refer to HLD
222: END IF;

Line 239: IF l_line_rec.FIRST_ACK_CODE IS NULL OR l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then

235: OR l_line_rec.ITEM_RELATIONSHIP_TYPE = 2
236: OR l_line_rec.ITEM_RELATIONSHIP_TYPE = 4
237: OR l_line_rec.ITEM_RELATIONSHIP_TYPE = 8
238: OR l_line_rec.ITEM_RELATIONSHIP_TYPE = 14) THEN
239: IF l_line_rec.FIRST_ACK_CODE IS NULL OR l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then
240: l_line_rec.FIRST_ACK_CODE := 'IS';
241: ELSE l_line_rec.FIRST_ACK_CODE := 'IC'; -- item accepted, (multiple) changes made , refer to HLD
242: END IF;
243: ELSE

Line 244: IF l_line_rec.FIRST_ACK_CODE IS NULL OR l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then

240: l_line_rec.FIRST_ACK_CODE := 'IS';
241: ELSE l_line_rec.FIRST_ACK_CODE := 'IC'; -- item accepted, (multiple) changes made , refer to HLD
242: END IF;
243: ELSE
244: IF l_line_rec.FIRST_ACK_CODE IS NULL OR l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then
245: l_line_rec.FIRST_ACK_CODE := 'IA';
246: END IF;
247: END IF;
248: END IF;

Line 262: IF l_line_rec.FIRST_ACK_CODE is NULL or l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR THEN

258: END IF;
259:
260:
261: -- If Everything Accepted as it is
262: IF l_line_rec.FIRST_ACK_CODE is NULL or l_line_rec.FIRST_ACK_CODE = FND_API.G_MISS_CHAR THEN
263: l_line_rec.FIRST_ACK_CODE := 'IA';
264: ELSIF l_line_rec.FIRST_ACK_CODE is NOT NULL THEN
265: -- the ack code was modified, we should update the header ack code
266: Update_Header_Ack_Code (l_line_rec.header_id, 'AC', NULL);

Line 286: AND l_line_rec.SCHEDULE_SHIP_DATE <> nvl(p_old_line_tbl(I).SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE)

282: IF l_line_rec.SCHEDULE_SHIP_DATE is NULL THEN
283: l_line_rec.LAST_ACK_CODE := 'SP';
284: END IF;
285: IF l_line_rec.SCHEDULE_SHIP_DATE is NOT NULL
286: AND l_line_rec.SCHEDULE_SHIP_DATE <> nvl(p_old_line_tbl(I).SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE)
287: AND l_line_rec.SCHEDULE_SHIP_DATE <> nvl(l_line_rec.REQUEST_DATE, FND_API.G_MISS_DATE)
288: THEN
289: l_line_rec.LAST_ACK_CODE := 'DR';
290: END IF;

Line 287: AND l_line_rec.SCHEDULE_SHIP_DATE <> nvl(l_line_rec.REQUEST_DATE, FND_API.G_MISS_DATE)

283: l_line_rec.LAST_ACK_CODE := 'SP';
284: END IF;
285: IF l_line_rec.SCHEDULE_SHIP_DATE is NOT NULL
286: AND l_line_rec.SCHEDULE_SHIP_DATE <> nvl(p_old_line_tbl(I).SCHEDULE_SHIP_DATE, FND_API.G_MISS_DATE)
287: AND l_line_rec.SCHEDULE_SHIP_DATE <> nvl(l_line_rec.REQUEST_DATE, FND_API.G_MISS_DATE)
288: THEN
289: l_line_rec.LAST_ACK_CODE := 'DR';
290: END IF;
291: -- Added for bug 4771523 + bug 4454400 start

Line 292: If nvl(l_line_rec.unit_selling_price, FND_API.G_MISS_NUM) <> nvl(p_old_line_tbl(I).unit_selling_price, FND_API.G_MISS_NUM)

288: THEN
289: l_line_rec.LAST_ACK_CODE := 'DR';
290: END IF;
291: -- Added for bug 4771523 + bug 4454400 start
292: If nvl(l_line_rec.unit_selling_price, FND_API.G_MISS_NUM) <> nvl(p_old_line_tbl(I).unit_selling_price, FND_API.G_MISS_NUM)
293: THEN
294: l_line_rec.LAST_ACK_CODE := 'IP';
295: oe_debug_pub.add('new unit selling price: ' || l_line_rec.unit_selling_price);
296: oe_debug_pub.add('old unit selling price: ' || p_old_line_tbl(I).unit_selling_price);

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

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:

Line 317: IF l_line_rec.LAST_ACK_CODE IS NULL or l_line_rec.LAST_ACK_CODE = FND_API.G_MISS_CHAR Then

313: -- Added for bug 4771523 + bug 4454400 end
314:
315: IF l_line_rec.ORDERED_QUANTITY <> p_old_line_tbl(I).ORDERED_QUANTITY
316: THEN
317: IF l_line_rec.LAST_ACK_CODE IS NULL or l_line_rec.LAST_ACK_CODE = FND_API.G_MISS_CHAR Then
318: l_line_rec.LAST_ACK_CODE := 'IQ';
319: ELSE
320: l_line_rec.LAST_ACK_CODE := 'IC'; -- item accepted, (multiple) changes made , refer to HLD
321: END IF;

Line 337: IF l_line_rec.LAST_ACK_CODE is NULL OR l_line_rec.LAST_ACK_CODE = FND_API.G_MISS_CHAR THEN

333: l_line_rec.LAST_ACK_CODE := 'ID';
334: END IF;
335:
336: -- If Everything Accepted as it is
337: IF l_line_rec.LAST_ACK_CODE is NULL OR l_line_rec.LAST_ACK_CODE = FND_API.G_MISS_CHAR THEN
338: l_line_rec.LAST_ACK_CODE := 'IA';
339: END IF;
340: -- in the case of 865, the header last ack code defaults to AC, so we don't need to change it here
341: -- (unlike 855)

Line 410: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

406: AND line_id = l_line_rec.line_id
407: AND acknowledgment_flag Is Null
408: -- Change this condition once ack type is ins for POAO/POCAO
409: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
410: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
411: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
412: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
413: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
414: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

Line 411: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)

407: AND acknowledgment_flag Is Null
408: -- Change this condition once ack type is ins for POAO/POCAO
409: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
410: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
411: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
412: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
413: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
414: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
415: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR)

Line 412: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

408: -- Change this condition once ack type is ins for POAO/POCAO
409: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
410: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
411: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
412: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
413: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
414: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
415: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR)
416: AND request_id = l_line_rec.request_id;

Line 413: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)

409: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
410: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
411: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
412: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
413: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
414: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
415: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR)
416: AND request_id = l_line_rec.request_id;
417:

Line 414: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

410: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
411: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
412: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
413: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
414: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
415: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR)
416: AND request_id = l_line_rec.request_id;
417:
418:

Line 415: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR)

411: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
412: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
413: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
414: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
415: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR)
416: AND request_id = l_line_rec.request_id;
417:
418:
419: else

Line 427: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

423: AND line_id = l_line_rec.line_id
424: AND acknowledgment_flag Is Null
425: -- Change this condition once ack type is ins for POAO/POCAO
426: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
427: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
428: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
429: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
430: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
431: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

Line 428: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)

424: AND acknowledgment_flag Is Null
425: -- Change this condition once ack type is ins for POAO/POCAO
426: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
427: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
428: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
429: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
430: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
431: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
432: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR);

Line 429: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

425: -- Change this condition once ack type is ins for POAO/POCAO
426: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
427: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
428: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
429: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
430: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
431: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
432: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR);
433: end if;

Line 430: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)

426: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
427: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
428: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
429: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
430: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
431: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
432: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR);
433: end if;
434: IF l_count > 0 THEN

Line 431: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

427: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
428: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
429: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
430: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
431: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
432: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR);
433: end if;
434: IF l_count > 0 THEN
435: oe_debug_pub.add('l_count > 0, Calling Delete_Row');

Line 432: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR);

428: = nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
429: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
430: = nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
431: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
432: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR);
433: end if;
434: IF l_count > 0 THEN
435: oe_debug_pub.add('l_count > 0, Calling Delete_Row');
436: OE_Line_Ack_Util.Delete_Row (p_line_id => l_line_rec.line_id,

Line 465: IF l_line_rec.order_source_id <> FND_API.G_MISS_NUM

461: END;
462:
463:
464:
465: IF l_line_rec.order_source_id <> FND_API.G_MISS_NUM
466: -- Changed the following condition to compare -1 instead of 0
467: -- as 0 is valid order_source_id
468: AND nvl(l_line_rec.order_source_id,-1) <> -1
469: AND l_line_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR

Line 469: AND l_line_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR

465: IF l_line_rec.order_source_id <> FND_API.G_MISS_NUM
466: -- Changed the following condition to compare -1 instead of 0
467: -- as 0 is valid order_source_id
468: AND nvl(l_line_rec.order_source_id,-1) <> -1
469: AND l_line_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR
470: AND nvl(l_line_rec.orig_sys_document_ref,' ') <> ' '
471: AND l_line_rec.orig_sys_line_ref <> FND_API.G_MISS_CHAR
472: AND nvl(l_line_rec.orig_sys_line_ref,' ') <> ' '
473: -- Commenting the next 2 lines for the bug 2922709 fix

Line 471: AND l_line_rec.orig_sys_line_ref <> FND_API.G_MISS_CHAR

467: -- as 0 is valid order_source_id
468: AND nvl(l_line_rec.order_source_id,-1) <> -1
469: AND l_line_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR
470: AND nvl(l_line_rec.orig_sys_document_ref,' ') <> ' '
471: AND l_line_rec.orig_sys_line_ref <> FND_API.G_MISS_CHAR
472: AND nvl(l_line_rec.orig_sys_line_ref,' ') <> ' '
473: -- Commenting the next 2 lines for the bug 2922709 fix
474: -- As for the rejected lines line_id can be null
475: -- OR (l_line_rec.line_id <> FND_API.G_MISS_NUM

Line 475: -- OR (l_line_rec.line_id <> FND_API.G_MISS_NUM

471: AND l_line_rec.orig_sys_line_ref <> FND_API.G_MISS_CHAR
472: AND nvl(l_line_rec.orig_sys_line_ref,' ') <> ' '
473: -- Commenting the next 2 lines for the bug 2922709 fix
474: -- As for the rejected lines line_id can be null
475: -- OR (l_line_rec.line_id <> FND_API.G_MISS_NUM
476: -- AND nvl(l_line_rec.line_id,0) <> 0)
477:
478: THEN
479:

Line 494: AND l_line_rec.split_from_line_id <> FND_API.G_MISS_NUM

490: oe_debug_pub.add('item nm = '||l_line_val_rec.inventory_item);
491: oe_debug_pub.add('first_ack_date = '||l_line_rec.first_ack_date);
492:
493: IF l_line_rec.split_from_line_id IS NOT NULL
494: AND l_line_rec.split_from_line_id <> FND_API.G_MISS_NUM
495: THEN
496: --bsadri get the split reference
497: oe_debug_pub.add('bsadri get the reference for split id :' ||
498: l_line_rec.split_from_line_id);

Line 1347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1343: ( G_PKG_NAME, 'OE_Line_Ack_Util.Insert_Row'
1344: );
1345: END IF;
1346:
1347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1348:
1349: END Insert_Row;
1350:
1351:

Line 1697: l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR) Then

1693: i := l_line_tbl.First;
1694:
1695: While i Is Not Null Loop
1696: If (nvl(l_line_tbl(i).FIRST_ACK_CODE, ' ')= ' ' OR
1697: l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR) Then
1698: -- Trans is 855
1699: --l_ack_type := '855'; for bug4730258
1700: If l_line_tbl(i).schedule_ship_date Is Null Then
1701: l_line_tbl(i).first_ack_code := 'SP';

Line 1704: trunc (l_line_tbl(i).schedule_ship_date) <> nvl(trunc (l_line_tbl(i).Request_date),FND_API.G_MISS_DATE) Then

1700: If l_line_tbl(i).schedule_ship_date Is Null Then
1701: l_line_tbl(i).first_ack_code := 'SP';
1702: End If;
1703: If l_line_tbl(i).schedule_ship_date Is Not Null And
1704: trunc (l_line_tbl(i).schedule_ship_date) <> nvl(trunc (l_line_tbl(i).Request_date),FND_API.G_MISS_DATE) Then
1705: l_line_tbl(i).first_ack_code := 'DR';
1706: End If;
1707: If l_line_tbl(i).ordered_quantity <> p_old_line_tbl(i).ordered_quantity Then
1708: If l_line_tbl(i).first_ack_code Is Null Or

Line 1709: l_line_tbl(i).first_ack_code = FND_API.G_MISS_CHAR Then

1705: l_line_tbl(i).first_ack_code := 'DR';
1706: End If;
1707: If l_line_tbl(i).ordered_quantity <> p_old_line_tbl(i).ordered_quantity Then
1708: If l_line_tbl(i).first_ack_code Is Null Or
1709: l_line_tbl(i).first_ack_code = FND_API.G_MISS_CHAR Then
1710: l_line_tbl(i).first_ack_code := 'IQ';
1711: Else
1712: l_line_tbl(i).first_ack_code := 'IC';
1713: End If;

Line 1720: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM 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';

Line 1740: l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then

1736: OR l_line_tbl(i).ITEM_RELATIONSHIP_TYPE = 4
1737: OR l_line_tbl(i).ITEM_RELATIONSHIP_TYPE = 8
1738: OR l_line_tbl(i).ITEM_RELATIONSHIP_TYPE = 14) Then
1739: If l_line_tbl(i).FIRST_ACK_CODE Is Null Or
1740: l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then
1741: l_line_tbl(i).FIRST_ACK_CODE := 'IS';
1742: Else
1743: l_line_tbl(i).FIRST_ACK_CODE := 'IC';
1744: End If;

Line 1747: l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then

1743: l_line_tbl(i).FIRST_ACK_CODE := 'IC';
1744: End If;
1745: Else
1746: If l_line_tbl(i).FIRST_ACK_CODE Is Null Or
1747: l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then
1748: l_line_tbl(i).FIRST_ACK_CODE := 'IA';
1749: End If;
1750: End If;
1751: End If;

Line 1763: l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then

1759: l_line_tbl(i).FIRST_ACK_CODE := 'ID';
1760: End If;
1761:
1762: If l_line_tbl(i).FIRST_ACK_CODE Is Null Or
1763: l_line_tbl(i).FIRST_ACK_CODE = FND_API.G_MISS_CHAR Then
1764: l_line_tbl(i).FIRST_ACK_CODE := 'IA';
1765: Elsif l_line_tbl(i).FIRST_ACK_CODE Is Not Null Then
1766: Update_Header_Ack_Code (l_line_tbl(i).header_id, 'AC', NULL);
1767: End If;

Line 1782: l_line_tbl(i).schedule_ship_date <> nvl(p_old_line_tbl(I).schedule_ship_date,FND_API.G_MISS_DATE) And

1778: If l_line_tbl(i).SCHEDULE_SHIP_DATE Is Null Then
1779: l_line_tbl(i).LAST_ACK_CODE := 'SP';
1780: End If;
1781: If l_line_tbl(i).SCHEDULE_SHIP_DATE Is Not Null And
1782: l_line_tbl(i).schedule_ship_date <> nvl(p_old_line_tbl(I).schedule_ship_date,FND_API.G_MISS_DATE) And
1783: l_line_tbl(i).schedule_ship_date <> nvl(l_line_tbl(i).REQUEST_DATE, FND_API.G_MISS_DATE) Then
1784: l_line_tbl(i).LAST_ACK_CODE := 'DR';
1785: End If;
1786:

Line 1783: l_line_tbl(i).schedule_ship_date <> nvl(l_line_tbl(i).REQUEST_DATE, FND_API.G_MISS_DATE) Then

1779: l_line_tbl(i).LAST_ACK_CODE := 'SP';
1780: End If;
1781: If l_line_tbl(i).SCHEDULE_SHIP_DATE Is Not Null And
1782: l_line_tbl(i).schedule_ship_date <> nvl(p_old_line_tbl(I).schedule_ship_date,FND_API.G_MISS_DATE) And
1783: l_line_tbl(i).schedule_ship_date <> nvl(l_line_tbl(i).REQUEST_DATE, FND_API.G_MISS_DATE) Then
1784: l_line_tbl(i).LAST_ACK_CODE := 'DR';
1785: End If;
1786:
1787: -- Added for bug 4771523

Line 1792: AND OE_ORDER_UTIL.g_line_tbl(I).customer_item_net_price <> FND_API.G_MISS_NUM 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';

Line 1806: l_line_tbl(i).LAST_ACK_CODE = FND_API.G_MISS_CHAR Then

1802: -- Added for bug 4771523
1803:
1804: If l_line_tbl(i).ORDERED_QUANTITY <> p_old_line_tbl(I).ORDERED_QUANTITY Then
1805: If l_line_tbl(i).LAST_ACK_CODE Is Null Or
1806: l_line_tbl(i).LAST_ACK_CODE = FND_API.G_MISS_CHAR Then
1807: l_line_tbl(i).LAST_ACK_CODE := 'IQ';
1808: Else
1809: l_line_tbl(i).LAST_ACK_CODE := 'IC';
1810: End If;

Line 1821: l_line_tbl(i).LAST_ACK_CODE = FND_API.G_MISS_CHAR Then

1817: l_line_tbl(i).LAST_ACK_CODE := 'ID';
1818: End If;
1819:
1820: If l_line_tbl(i).LAST_ACK_CODE Is Null Or
1821: l_line_tbl(i).LAST_ACK_CODE = FND_API.G_MISS_CHAR Then
1822: l_line_tbl(i).LAST_ACK_CODE := 'IA';
1823: End If;
1824:
1825: l_line_tbl(i).LAST_ACK_DATE := '';

Line 1830: l_line_tbl(i).split_from_line_id <> FND_API.G_MISS_NUM Then

1826:
1827: End If;
1828:
1829: If l_line_tbl(i).split_from_line_id Is Not Null And
1830: l_line_tbl(i).split_from_line_id <> FND_API.G_MISS_NUM Then
1831: --bsadri get the split reference
1832: Begin
1833: Select orig_sys_line_ref, orig_sys_shipment_ref
1834: Into l_line_tbl(i).split_from_line_ref, l_line_tbl(i).split_from_shipment_ref

Line 2183: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

2179: AND LINE_ID = l_line_acks_rec.line_id(y)
2180: AND ACKNOWLEDGMENT_FLAG is null
2181: -- Change this condition once a type is inserted for POAO/POCAO
2182: AND nvl(acknowledgment_type,'ALL') = nvl(l_ack_type,'ALL')
2183: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2184: = nvl(l_line_acks_rec.CHANGE_SEQUENCE(y), FND_API.G_MISS_CHAR) ;
2185: --Added for bug4730258 end
2186: FORALL j in l_line_acks_rec.line_id.First..l_line_acks_rec.line_id.Last
2187: Insert Into Oe_Line_Acks

Line 2184: = nvl(l_line_acks_rec.CHANGE_SEQUENCE(y), FND_API.G_MISS_CHAR) ;

2180: AND ACKNOWLEDGMENT_FLAG is null
2181: -- Change this condition once a type is inserted for POAO/POCAO
2182: AND nvl(acknowledgment_type,'ALL') = nvl(l_ack_type,'ALL')
2183: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2184: = nvl(l_line_acks_rec.CHANGE_SEQUENCE(y), FND_API.G_MISS_CHAR) ;
2185: --Added for bug4730258 end
2186: FORALL j in l_line_acks_rec.line_id.First..l_line_acks_rec.line_id.Last
2187: Insert Into Oe_Line_Acks
2188: (

Line 2806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2802: FND_MSG_PUB.Add_Exc_Msg
2803: (G_PKG_NAME, 'OE_Line_Ack_Util.Insert_Row');
2804: End If;
2805:
2806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2807:
2808:
2809: End Insert_Row;
2810:

Line 2845: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

2841: AND LINE_ID = p_line_id
2842: AND ACKNOWLEDGMENT_FLAG is null
2843: -- Change this condition once a type is inserted for POAO/POCAO
2844: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
2845: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2846: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2847: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2848: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2849: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

Line 2846: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

2842: AND ACKNOWLEDGMENT_FLAG is null
2843: -- Change this condition once a type is inserted for POAO/POCAO
2844: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
2845: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2846: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2847: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2848: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2849: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2850: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)

Line 2847: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

2843: -- Change this condition once a type is inserted for POAO/POCAO
2844: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
2845: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2846: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2847: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2848: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2849: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2850: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
2851: AND request_id = p_request_id;

Line 2848: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

2844: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
2845: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2846: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2847: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2848: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2849: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2850: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
2851: AND request_id = p_request_id;
2852:

Line 2849: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

2845: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2846: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2847: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2848: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2849: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2850: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
2851: AND request_id = p_request_id;
2852:
2853: else

Line 2850: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)

2846: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2847: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2848: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2849: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2850: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
2851: AND request_id = p_request_id;
2852:
2853: else
2854: DELETE FROM OE_LINE_ACKS

Line 2860: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

2856: AND LINE_ID = p_line_id
2857: AND ACKNOWLEDGMENT_FLAG is null
2858: -- Change this condition once a type is inserted for POAO/POCAO
2859: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
2860: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2861: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2862: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2863: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2864: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

Line 2861: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

2857: AND ACKNOWLEDGMENT_FLAG is null
2858: -- Change this condition once a type is inserted for POAO/POCAO
2859: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
2860: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2861: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2862: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2863: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2864: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2865: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);

Line 2862: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

2858: -- Change this condition once a type is inserted for POAO/POCAO
2859: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
2860: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2861: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2862: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2863: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2864: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2865: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
2866: end if;

Line 2863: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

2859: AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
2860: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2861: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2862: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2863: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2864: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2865: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
2866: end if;
2867: if sql%rowcount > 0 then

Line 2864: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

2860: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2861: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2862: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2863: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2864: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2865: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
2866: end if;
2867: if sql%rowcount > 0 then
2868: oe_debug_pub.add('Row Deleted from the oe_line_Acks table');

Line 2865: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);

2861: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2862: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2863: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2864: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2865: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
2866: end if;
2867: if sql%rowcount > 0 then
2868: oe_debug_pub.add('Row Deleted from the oe_line_Acks table');
2869: end If;

Line 2882: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

2878: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
2879: AND ORIG_SYS_LINE_REF = p_orig_sys_line_ref
2880: AND ORIG_SYS_SHIPMENT_REF = p_orig_sys_shipment_ref
2881: AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
2882: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2883: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2884: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2885: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2886: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

Line 2883: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

2879: AND ORIG_SYS_LINE_REF = p_orig_sys_line_ref
2880: AND ORIG_SYS_SHIPMENT_REF = p_orig_sys_shipment_ref
2881: AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
2882: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2883: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2884: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2885: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2886: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2887: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)

Line 2884: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

2880: AND ORIG_SYS_SHIPMENT_REF = p_orig_sys_shipment_ref
2881: AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
2882: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2883: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2884: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2885: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2886: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2887: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
2888: AND REQUEST_ID = p_request_id;

Line 2885: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

2881: AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
2882: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2883: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2884: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2885: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2886: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2887: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
2888: AND REQUEST_ID = p_request_id;
2889:

Line 2886: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

2882: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2883: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2884: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2885: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2886: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2887: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
2888: AND REQUEST_ID = p_request_id;
2889:
2890: else

Line 2887: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)

2883: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2884: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2885: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2886: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2887: = nvl(p_change_sequence, FND_API.G_MISS_CHAR)
2888: AND REQUEST_ID = p_request_id;
2889:
2890: else
2891:

Line 2897: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

2893: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
2894: AND ORIG_SYS_LINE_REF = p_orig_sys_line_ref
2895: AND ORIG_SYS_SHIPMENT_REF = p_orig_sys_shipment_ref
2896: AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
2897: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2898: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2899: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2900: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2901: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

Line 2898: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)

2894: AND ORIG_SYS_LINE_REF = p_orig_sys_line_ref
2895: AND ORIG_SYS_SHIPMENT_REF = p_orig_sys_shipment_ref
2896: AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
2897: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2898: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2899: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2900: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2901: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2902: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);

Line 2899: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)

2895: AND ORIG_SYS_SHIPMENT_REF = p_orig_sys_shipment_ref
2896: AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
2897: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2898: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2899: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2900: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2901: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2902: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
2903:

Line 2900: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)

2896: AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
2897: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2898: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2899: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2900: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2901: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2902: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
2903:
2904:

Line 2901: AND nvl(change_sequence, FND_API.G_MISS_CHAR)

2897: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
2898: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2899: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2900: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2901: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2902: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
2903:
2904:
2905: end if;

Line 2902: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);

2898: = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
2899: AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
2900: = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
2901: AND nvl(change_sequence, FND_API.G_MISS_CHAR)
2902: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
2903:
2904:
2905: end if;
2906:

Line 2928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2924: FND_MSG_PUB.Add_Exc_Msg
2925: (G_PKG_NAME, 'OE_Line_Ack_Util.Delete_Row');
2926: END IF;
2927:
2928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2929:
2930: END Delete_Row;
2931:
2932: