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 OE_DEBUG_PUB

Line 26: oe_debug_pub.add('return Pending');

22: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
23: If nvl(FND_PROFILE.VALUE('ONT_XML_ACCEPT_STATE'), 'ENTERED') = 'ENTERED' Then
24: Return '0';
25: Elsif nvl(p_booked_flag, 'N') = 'N' AND p_transaction_type = OE_Acknowledgment_Pub.G_TRANSACTION_POI Then
26: oe_debug_pub.add('return Pending');
27: Return '3'; -- pending
28: Else
29: oe_debug_pub.add('return Accepted - code is 0, post-110510');
30: Return '0';

Line 29: oe_debug_pub.add('return Accepted - code is 0, post-110510');

25: Elsif nvl(p_booked_flag, 'N') = 'N' AND p_transaction_type = OE_Acknowledgment_Pub.G_TRANSACTION_POI Then
26: oe_debug_pub.add('return Pending');
27: Return '3'; -- pending
28: Else
29: oe_debug_pub.add('return Accepted - code is 0, post-110510');
30: Return '0';
31: End If;
32: Else
33: oe_debug_pub.add('return Accepted - code is 0, pre-110510');

Line 33: oe_debug_pub.add('return Accepted - code is 0, pre-110510');

29: oe_debug_pub.add('return Accepted - code is 0, post-110510');
30: Return '0';
31: End If;
32: Else
33: oe_debug_pub.add('return Accepted - code is 0, pre-110510');
34: Return '0';
35: End If;
36: Else
37: Return 'IA'; --Changed AT to IA for bug 4137350

Line 41: oe_debug_pub.add('return Rejected - code is 2');

37: Return 'IA'; --Changed AT to IA for bug 4137350
38: End If;
39: Elsif p_reject_order = 'Y' Then
40: If p_order_source_id = 20 Then
41: oe_debug_pub.add('return Rejected - code is 2');
42: Return '2';
43: Else
44: Return 'RJ';
45: End If;

Line 60: oe_debug_pub.add ('Entering Update_Header_Ack_Code with params: header id ' ||

56: p_last_ack_code IN VARCHAR2
57: )
58: IS
59: BEGIN
60: oe_debug_pub.add ('Entering Update_Header_Ack_Code with params: header id ' ||
61: p_header_id || ', first_ack_code ' || p_first_ack_code
62: || ', last_ack_code ' || p_last_ack_code || '.');
63: IF p_first_ack_code IS NOT NULL THEN
64: UPDATE oe_header_acks

Line 67: oe_debug_pub.add ('rows updated: ' || SQL%ROWCOUNT);

63: IF p_first_ack_code IS NOT NULL THEN
64: UPDATE oe_header_acks
65: SET first_ack_code = p_first_ack_code
66: WHERE header_id = p_header_id;
67: oe_debug_pub.add ('rows updated: ' || SQL%ROWCOUNT);
68: ELSIF p_last_ack_code IS NOT NULL THEN
69: UPDATE oe_header_acks
70: SET last_ack_code = p_last_ack_code
71: WHERE header_id = p_header_id;

Line 72: oe_debug_pub.add ('rows updated: ' || SQL%ROWCOUNT);

68: ELSIF p_last_ack_code IS NOT NULL THEN
69: UPDATE oe_header_acks
70: SET last_ack_code = p_last_ack_code
71: WHERE header_id = p_header_id;
72: oe_debug_pub.add ('rows updated: ' || SQL%ROWCOUNT);
73: ELSE
74: oe_debug_pub.add ('Bad args passed to update_header_ack_code, no header records updated');
75: END IF;
76: EXCEPTION

Line 74: oe_debug_pub.add ('Bad args passed to update_header_ack_code, no header records updated');

70: SET last_ack_code = p_last_ack_code
71: WHERE header_id = p_header_id;
72: oe_debug_pub.add ('rows updated: ' || SQL%ROWCOUNT);
73: ELSE
74: oe_debug_pub.add ('Bad args passed to update_header_ack_code, no header records updated');
75: END IF;
76: EXCEPTION
77: WHEN OTHERS THEN
78: oe_debug_pub.add ('When Others in Update_Header_Ack_Code');

Line 78: oe_debug_pub.add ('When Others in Update_Header_Ack_Code');

74: oe_debug_pub.add ('Bad args passed to update_header_ack_code, no header records updated');
75: END IF;
76: EXCEPTION
77: WHEN OTHERS THEN
78: oe_debug_pub.add ('When Others in Update_Header_Ack_Code');
79: END Update_Header_Ack_Code;
80:
81:
82: PROCEDURE Insert_Row

Line 175: oe_debug_pub.add('l_line_rec.SCHEDULE_SHIP_DATE :' || l_line_rec.SCHEDULE_SHIP_DATE,1);

171: Else
172: l_line_val_rec := p_line_val_tbl(I);
173:
174: -- Following Check will determine if this is a 855 or 865
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

Line 176: oe_debug_pub.add('l_line_rec.REQUEST_DATE :' || l_line_rec.REQUEST_DATE, 1);

172: l_line_val_rec := p_line_val_tbl(I);
173:
174: -- Following Check will determine if this is a 855 or 865
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' ));

Line 180: oe_debug_pub.add('trans is 855 with first_ack_code ' ||nvl(l_line_rec.FIRST_ACK_CODE, 'NULL' ));

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';
184: END IF;

Line 182: oe_debug_pub.add('ack code: schedule ship date is null');

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';
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)

Line 188: oe_debug_pub.add('ack code: date rescheduled');

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;
191:
192: --Added for bug 4771523+bug 4454400 start

Line 196: oe_debug_pub.add('new unit selling price: ' || l_line_rec.unit_selling_price);

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);
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

Line 197: oe_debug_pub.add('old unit selling price: ' || p_old_line_tbl(I).unit_selling_price);

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);
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

Line 198: oe_debug_pub.add('ack code: price changed');

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);
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:

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

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';

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

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);

Line 208: oe_debug_pub.add(' ack code: price changed : '||l_line_rec.FIRST_ACK_CODE,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);
211: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(I).unit_selling_price,5);
212: END IF;

Line 210: oe_debug_pub.add(' new unit selling price: ' || l_line_rec.unit_selling_price,5);

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);
211: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(I).unit_selling_price,5);
212: END IF;
213: --Added for bug 4771523+bug 4454400 end
214:

Line 211: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(I).unit_selling_price,5);

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);
211: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(I).unit_selling_price,5);
212: END IF;
213: --Added for bug 4771523+bug 4454400 end
214:
215:

Line 295: oe_debug_pub.add('new unit selling price: ' || l_line_rec.unit_selling_price);

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);
297: oe_debug_pub.add('ack code: price changed');
298: END IF;
299:

Line 296: oe_debug_pub.add('old unit selling price: ' || p_old_line_tbl(I).unit_selling_price);

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);
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

Line 297: oe_debug_pub.add('ack code: price changed');

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);
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

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

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';

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

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);

Line 308: oe_debug_pub.add(' ack code: price changed : '||l_line_rec.FIRST_ACK_CODE,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);
311: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(I).unit_selling_price,5);
312: END IF;

Line 310: oe_debug_pub.add(' new unit selling price: ' || l_line_rec.unit_selling_price,5);

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);
311: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(I).unit_selling_price,5);
312: END IF;
313: -- Added for bug 4771523 + bug 4454400 end
314:

Line 311: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(I).unit_selling_price,5);

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);
311: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(I).unit_selling_price,5);
312: END IF;
313: -- Added for bug 4771523 + bug 4454400 end
314:
315: IF l_line_rec.ORDERED_QUANTITY <> p_old_line_tbl(I).ORDERED_QUANTITY

Line 372: oe_debug_pub.add('855 nulling first_ack_date');

368:
369: Else
370: IF nvl(l_line_rec.FIRST_ACK_CODE,' ')=' ' THEN -- It is 855
371: l_line_rec.FIRST_ACK_CODE := 'IR';
372: oe_debug_pub.add('855 nulling first_ack_date');
373: l_line_rec.FIRST_ACK_DATE := '';
374: l_line_rec.LAST_ACK_CODE := '';
375: l_line_rec.LAST_ACK_DATE := '';
376: ELSE

Line 435: oe_debug_pub.add('l_count > 0, Calling Delete_Row');

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,
437: p_ack_type => p_ack_type,
438: p_sold_to_org_id => l_line_rec.sold_to_org_id,
439: p_sold_to_org => l_line_val_rec.sold_to_org,

Line 445: oe_debug_pub.add('l_count <= 0 for line_id, attempting delete by doc ref, line ref and ship ref');

441: p_request_id => l_line_rec.request_id,
442: p_header_id => l_line_rec.header_id);
443:
444: ELSE
445: oe_debug_pub.add('l_count <= 0 for line_id, attempting delete by doc ref, line ref and ship ref');
446: OE_Line_Ack_Util.Delete_Row (p_line_id => NULL,
447: p_ack_type => p_ack_type,
448: p_orig_sys_document_ref => l_line_rec.orig_sys_document_ref,
449: p_orig_sys_line_ref => l_line_rec.orig_sys_line_ref,

Line 480: oe_debug_pub.add('inserting line ack record for'||

476: -- AND nvl(l_line_rec.line_id,0) <> 0)
477:
478: THEN
479:
480: oe_debug_pub.add('inserting line ack record for'||
481: ' source id: ' ||to_char(l_line_rec.order_source_id)||
482: ', order ref: ' ||l_line_rec.orig_sys_document_ref||
483: ', line ref: ' ||l_line_rec.orig_sys_line_ref||
484: ', line id: ' ||to_char(l_line_rec.line_id)||

Line 489: oe_debug_pub.add('item id = '||l_line_rec.inventory_item_id);

485: ', line no: ' ||to_char(l_line_rec.line_number)||
486: ', shipment no: '||to_char(l_line_rec.shipment_number)||
487: ', option no: ' ||to_char(l_line_rec.option_number));
488:
489: oe_debug_pub.add('item id = '||l_line_rec.inventory_item_id);
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

Line 490: oe_debug_pub.add('item nm = '||l_line_val_rec.inventory_item);

486: ', shipment no: '||to_char(l_line_rec.shipment_number)||
487: ', option no: ' ||to_char(l_line_rec.option_number));
488:
489: oe_debug_pub.add('item id = '||l_line_rec.inventory_item_id);
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

Line 491: oe_debug_pub.add('first_ack_date = '||l_line_rec.first_ack_date);

487: ', option no: ' ||to_char(l_line_rec.option_number));
488:
489: oe_debug_pub.add('item id = '||l_line_rec.inventory_item_id);
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

Line 497: oe_debug_pub.add('bsadri get the reference for split id :' ||

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);
499: BEGIN
500: SELECT orig_sys_line_ref, orig_sys_shipment_ref
501: INTO l_line_rec.split_from_line_ref, l_line_rec.split_from_shipment_ref

Line 506: oe_debug_pub.add('bsadri failed to get the refernce for split line');

502: FROM OE_ORDER_LINES
503: WHERE line_id = l_line_rec.split_from_line_id;
504: EXCEPTION
505: WHEN OTHERS THEN
506: oe_debug_pub.add('bsadri failed to get the refernce for split line');
507: END;
508: END IF;
509: --added end customer fields for bug 4034441
510: INSERT INTO OE_LINE_ACKS

Line 1328: oe_debug_pub.add('Incomplete data for inserting line ack rec');

1324: ,l_line_rec.SERVICE_FIRST_PERIOD_ENDDATE
1325: --Sol_ord_er #16014165 end
1326: );
1327: ELSE
1328: oe_debug_pub.add('Incomplete data for inserting line ack rec');
1329: END IF;
1330: <>
1331: I := p_line_tbl.NEXT(I);
1332: END LOOP;

Line 1338: oe_debug_pub.Add('Encountered Others Error Exception in OE_Line_Ack_Util.Insert_Row: '||sqlerrm);

1334: EXCEPTION
1335:
1336: WHEN OTHERS THEN
1337:
1338: oe_debug_pub.Add('Encountered Others Error Exception in OE_Line_Ack_Util.Insert_Row: '||sqlerrm);
1339:
1340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1341: THEN
1342: FND_MSG_PUB.Add_Exc_Msg

Line 1358: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1354: p_count In Number)
1355:
1356: Is
1357:
1358: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1359:
1360: Begin
1361: oe_debug_pub.add('Entering Extend_Line_Rec');
1362:

Line 1361: oe_debug_pub.add('Entering Extend_Line_Rec');

1357:
1358: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1359:
1360: Begin
1361: oe_debug_pub.add('Entering Extend_Line_Rec');
1362:
1363: p_line_rec.line_id.extend(p_count);
1364: p_line_rec.header_id.extend(p_count);
1365: p_line_rec.ship_to_org_id.extend(p_count);

Line 1663: oe_debug_pub.add('Exiting Extend_Line_Rec');

1659: p_line_rec.SERVICE_FIRST_PERIOD_AMOUNT.extend(p_count);
1660: p_line_rec.SUBSCRIPTION_ENABLE_FLAG.extend(p_count);
1661: p_line_rec.SERVICE_FIRST_PERIOD_ENDDATE.extend(p_count);
1662: --Sol_ord_er #16014165 end
1663: oe_debug_pub.add('Exiting Extend_Line_Rec');
1664:
1665: Exception
1666: When Others Then
1667: If l_debug_level > 0 Then

Line 1668: Oe_Debug_Pub.Add('When Others in Extend_Line_Rec');

1664:
1665: Exception
1666: When Others Then
1667: If l_debug_level > 0 Then
1668: Oe_Debug_Pub.Add('When Others in Extend_Line_Rec');
1669: Oe_Debug_Pub.Add('Error: '||sqlerrm);
1670: End If;
1671:
1672: End Extend_Line_Rec;

Line 1669: Oe_Debug_Pub.Add('Error: '||sqlerrm);

1665: Exception
1666: When Others Then
1667: If l_debug_level > 0 Then
1668: Oe_Debug_Pub.Add('When Others in Extend_Line_Rec');
1669: Oe_Debug_Pub.Add('Error: '||sqlerrm);
1670: End If;
1671:
1672: End Extend_Line_Rec;
1673:

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

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);

Line 1722: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,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;

Line 1725: oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);

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);
1728: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(i).unit_selling_price,5);
1729: END IF;

Line 1727: oe_debug_pub.add(' new unit selling price: ' || l_line_tbl(i).unit_selling_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);
1728: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(i).unit_selling_price,5);
1729: END IF;
1730: -- Added for bug 4771523 end
1731:

Line 1728: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(i).unit_selling_price,5);

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);
1728: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(i).unit_selling_price,5);
1729: END IF;
1730: -- Added for bug 4771523 end
1731:
1732:

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

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);

Line 1794: oe_debug_pub.add(' Global CUSTOMER_ITEM_NET_PRICE : '||OE_ORDER_UTIL.g_line_tbl(I).CUSTOMER_ITEM_NET_PRICE,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;

Line 1797: oe_debug_pub.add(' ack code: price changed : '||l_line_tbl(i).FIRST_ACK_CODE,5);

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);
1800: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(i).unit_selling_price,5);
1801: END IF;

Line 1799: oe_debug_pub.add(' new unit selling price: ' || l_line_tbl(i).unit_selling_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);
1800: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(i).unit_selling_price,5);
1801: END IF;
1802: -- Added for bug 4771523
1803:

Line 1800: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(i).unit_selling_price,5);

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);
1800: oe_debug_pub.add(' old unit selling price: ' || p_old_line_tbl(i).unit_selling_price,5);
1801: END IF;
1802: -- Added for bug 4771523
1803:
1804: If l_line_tbl(i).ORDERED_QUANTITY <> p_old_line_tbl(I).ORDERED_QUANTITY Then

Line 2827: oe_debug_pub.add('Input Header ID: '|| p_header_id);

2823: )
2824: IS
2825: BEGIN
2826:
2827: oe_debug_pub.add('Input Header ID: '|| p_header_id);
2828: oe_debug_pub.add('Input Line ID: '|| p_line_id);
2829: oe_debug_pub.add('Input Orig Sys Document Ref: '|| p_orig_sys_document_ref);
2830:
2831: If (p_header_id is not null AND

Line 2828: oe_debug_pub.add('Input Line ID: '|| p_line_id);

2824: IS
2825: BEGIN
2826:
2827: oe_debug_pub.add('Input Header ID: '|| p_header_id);
2828: oe_debug_pub.add('Input Line ID: '|| p_line_id);
2829: oe_debug_pub.add('Input Orig Sys Document Ref: '|| p_orig_sys_document_ref);
2830:
2831: If (p_header_id is not null AND
2832: p_line_id is not null) Then

Line 2829: oe_debug_pub.add('Input Orig Sys Document Ref: '|| p_orig_sys_document_ref);

2825: BEGIN
2826:
2827: oe_debug_pub.add('Input Header ID: '|| p_header_id);
2828: oe_debug_pub.add('Input Line ID: '|| p_line_id);
2829: oe_debug_pub.add('Input Orig Sys Document Ref: '|| p_orig_sys_document_ref);
2830:
2831: If (p_header_id is not null AND
2832: p_line_id is not null) Then
2833:

Line 2868: oe_debug_pub.add('Row Deleted from the oe_line_Acks table');

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;
2870: Elsif (p_orig_sys_document_ref is not null) Then
2871: oe_debug_pub.add('before deleting line acknowledgment by orig_sys_document_Ref, line_ref and shipment_ref ',3);
2872:

Line 2871: oe_debug_pub.add('before deleting line acknowledgment by orig_sys_document_Ref, line_ref and shipment_ref ',3);

2867: if sql%rowcount > 0 then
2868: oe_debug_pub.add('Row Deleted from the oe_line_Acks table');
2869: end If;
2870: Elsif (p_orig_sys_document_ref is not null) Then
2871: oe_debug_pub.add('before deleting line acknowledgment by orig_sys_document_Ref, line_ref and shipment_ref ',3);
2872:
2873: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
2874: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
2875: then

Line 2908: oe_debug_pub.add('Row(s) Deleted from the oe_line_acks table');

2904:
2905: end if;
2906:
2907: if sql%rowcount > 0 then
2908: oe_debug_pub.add('Row(s) Deleted from the oe_line_acks table');
2909: end If;
2910: Else
2911: oe_debug_pub.add('not deleting any rows from oe_line_acks ',3);
2912:

Line 2911: oe_debug_pub.add('not deleting any rows from oe_line_acks ',3);

2907: if sql%rowcount > 0 then
2908: oe_debug_pub.add('Row(s) Deleted from the oe_line_acks table');
2909: end If;
2910: Else
2911: oe_debug_pub.add('not deleting any rows from oe_line_acks ',3);
2912:
2913: End If;
2914:
2915:

Line 2920: oe_debug_pub.Add('Encountered Others Error Exception in OE_Line_Ack_Util.Delete_Row: '||sqlerrm);

2916: EXCEPTION
2917:
2918: WHEN OTHERS THEN
2919:
2920: oe_debug_pub.Add('Encountered Others Error Exception in OE_Line_Ack_Util.Delete_Row: '||sqlerrm);
2921:
2922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2923: THEN
2924: FND_MSG_PUB.Add_Exc_Msg