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.RCV_WSH_INTERFACE_PKG dependencies on ASN_DEBUG

Line 27: IF (g_asn_debug = 'Y') THEN

23:
24: RETURN l_unit_of_measure;
25: EXCEPTION
26: WHEN OTHERS THEN
27: IF (g_asn_debug = 'Y') THEN
28: asn_debug.put_line('Unexpected exception in get_uom_from_code : ' || SQLERRM);
29: END IF;
30: raise fnd_api.g_exc_unexpected_error;
31: END get_uom_from_code;

Line 28: asn_debug.put_line('Unexpected exception in get_uom_from_code : ' || SQLERRM);

24: RETURN l_unit_of_measure;
25: EXCEPTION
26: WHEN OTHERS THEN
27: IF (g_asn_debug = 'Y') THEN
28: asn_debug.put_line('Unexpected exception in get_uom_from_code : ' || SQLERRM);
29: END IF;
30: raise fnd_api.g_exc_unexpected_error;
31: END get_uom_from_code;
32:

Line 42: IF (g_asn_debug = 'Y') THEN

38: RETURN NUMBER IS
39: l_lpn_id number;
40: BEGIN
41:
42: IF (g_asn_debug = 'Y') THEN
43: asn_debug.put_line('p_wdd_id : ' || p_wdd_id);
44: END IF;
45: IF (p_wdd_id IS NULL) THEN
46: RETURN NULL;

Line 43: asn_debug.put_line('p_wdd_id : ' || p_wdd_id);

39: l_lpn_id number;
40: BEGIN
41:
42: IF (g_asn_debug = 'Y') THEN
43: asn_debug.put_line('p_wdd_id : ' || p_wdd_id);
44: END IF;
45: IF (p_wdd_id IS NULL) THEN
46: RETURN NULL;
47: END IF;

Line 55: IF (g_asn_debug = 'Y') THEN

51: FROM wsh_delivery_Details wdd, wsh_delivery_assignments wda
52: WHERE wdd.delivery_detail_id(+) = wda.parent_delivery_detail_id
53: AND wda.delivery_detail_id = p_wdd_id;
54:
55: IF (g_asn_debug = 'Y') THEN
56: asn_debug.put_line('l_lpn_id : ' || l_lpn_id);
57: END IF;
58: RETURN l_lpn_id;
59: EXCEPTION

Line 56: asn_debug.put_line('l_lpn_id : ' || l_lpn_id);

52: WHERE wdd.delivery_detail_id(+) = wda.parent_delivery_detail_id
53: AND wda.delivery_detail_id = p_wdd_id;
54:
55: IF (g_asn_debug = 'Y') THEN
56: asn_debug.put_line('l_lpn_id : ' || l_lpn_id);
57: END IF;
58: RETURN l_lpn_id;
59: EXCEPTION
60: WHEN OTHERS THEN

Line 61: IF (g_asn_debug = 'Y') THEN

57: END IF;
58: RETURN l_lpn_id;
59: EXCEPTION
60: WHEN OTHERS THEN
61: IF (g_asn_debug = 'Y') THEN
62: asn_debug.put_line('Unexpected exception in get_return_lpn_id : ' || SQLERRM);
63: END IF;
64: raise fnd_api.g_exc_unexpected_error;
65: END get_return_lpn_id;

Line 62: asn_debug.put_line('Unexpected exception in get_return_lpn_id : ' || SQLERRM);

58: RETURN l_lpn_id;
59: EXCEPTION
60: WHEN OTHERS THEN
61: IF (g_asn_debug = 'Y') THEN
62: asn_debug.put_line('Unexpected exception in get_return_lpn_id : ' || SQLERRM);
63: END IF;
64: raise fnd_api.g_exc_unexpected_error;
65: END get_return_lpn_id;
66:

Line 97: asn_debug.put_line('unmark lpn successfully');

93: p_org_id => p_wdd_rec.organization_id,
94: p_lot_number => p_wdd_rec.lot_number);
95:
96: IF (nvl(x_msg_count,0) = 0) THEN
97: asn_debug.put_line('unmark lpn successfully');
98: ELSE
99: asn_debug.put_line(' Could not unmark lpn : ----> ' || l_lpn_id);
100: asn_debug.put_line(' Could not unmark for item : ----> ' || p_wdd_rec.inventory_item_id);
101: FOR i IN 1..x_msg_count LOOP

Line 99: asn_debug.put_line(' Could not unmark lpn : ----> ' || l_lpn_id);

95:
96: IF (nvl(x_msg_count,0) = 0) THEN
97: asn_debug.put_line('unmark lpn successfully');
98: ELSE
99: asn_debug.put_line(' Could not unmark lpn : ----> ' || l_lpn_id);
100: asn_debug.put_line(' Could not unmark for item : ----> ' || p_wdd_rec.inventory_item_id);
101: FOR i IN 1..x_msg_count LOOP
102: l_message := fnd_msg_pub.get(I, 'F');
103: asn_debug.put_line(substr(l_message,1,255));

Line 100: asn_debug.put_line(' Could not unmark for item : ----> ' || p_wdd_rec.inventory_item_id);

96: IF (nvl(x_msg_count,0) = 0) THEN
97: asn_debug.put_line('unmark lpn successfully');
98: ELSE
99: asn_debug.put_line(' Could not unmark lpn : ----> ' || l_lpn_id);
100: asn_debug.put_line(' Could not unmark for item : ----> ' || p_wdd_rec.inventory_item_id);
101: FOR i IN 1..x_msg_count LOOP
102: l_message := fnd_msg_pub.get(I, 'F');
103: asn_debug.put_line(substr(l_message,1,255));
104: end LOOP;

Line 103: asn_debug.put_line(substr(l_message,1,255));

99: asn_debug.put_line(' Could not unmark lpn : ----> ' || l_lpn_id);
100: asn_debug.put_line(' Could not unmark for item : ----> ' || p_wdd_rec.inventory_item_id);
101: FOR i IN 1..x_msg_count LOOP
102: l_message := fnd_msg_pub.get(I, 'F');
103: asn_debug.put_line(substr(l_message,1,255));
104: end LOOP;
105: END IF;
106:
107: EXCEPTION

Line 109: IF (g_asn_debug = 'Y') THEN

105: END IF;
106:
107: EXCEPTION
108: WHEN OTHERS THEN
109: IF (g_asn_debug = 'Y') THEN
110: asn_debug.put_line('Unexpected exception in unmark_wdd_lpn with lpn_id : '||l_lpn_id||', SQLERRM:' || SQLERRM);
111: END IF;
112: raise fnd_api.g_exc_unexpected_error;
113: END unmark_wdd_lpn;

Line 110: asn_debug.put_line('Unexpected exception in unmark_wdd_lpn with lpn_id : '||l_lpn_id||', SQLERRM:' || SQLERRM);

106:
107: EXCEPTION
108: WHEN OTHERS THEN
109: IF (g_asn_debug = 'Y') THEN
110: asn_debug.put_line('Unexpected exception in unmark_wdd_lpn with lpn_id : '||l_lpn_id||', SQLERRM:' || SQLERRM);
111: END IF;
112: raise fnd_api.g_exc_unexpected_error;
113: END unmark_wdd_lpn;
114:

Line 120: IF (g_asn_debug = 'Y') THEN

116: ( p_bkup_rti_id IN NUMBER) IS
117: BEGIN
118: DELETE FROM rcv_transactions_interface
119: WHERE interface_transaction_id = p_bkup_rti_id;
120: IF (g_asn_debug = 'Y') THEN
121: asn_debug.put_line('DELETED RTI');
122: END IF;
123: --
124: BEGIN

Line 121: asn_debug.put_line('DELETED RTI');

117: BEGIN
118: DELETE FROM rcv_transactions_interface
119: WHERE interface_transaction_id = p_bkup_rti_id;
120: IF (g_asn_debug = 'Y') THEN
121: asn_debug.put_line('DELETED RTI');
122: END IF;
123: --
124: BEGIN
125: DELETE FROM rcv_lots_interface

Line 128: IF (g_asn_debug = 'Y') THEN

124: BEGIN
125: DELETE FROM rcv_lots_interface
126: WHERE interface_transaction_id = p_bkup_rti_id;
127:
128: IF (g_asn_debug = 'Y') THEN
129: asn_debug.put_line('DELETED RLI');
130: END IF;
131: EXCEPTION
132: WHEN OTHERS THEN NULL;

Line 129: asn_debug.put_line('DELETED RLI');

125: DELETE FROM rcv_lots_interface
126: WHERE interface_transaction_id = p_bkup_rti_id;
127:
128: IF (g_asn_debug = 'Y') THEN
129: asn_debug.put_line('DELETED RLI');
130: END IF;
131: EXCEPTION
132: WHEN OTHERS THEN NULL;
133: END;

Line 139: IF (g_asn_debug = 'Y') THEN

135: BEGIN
136: DELETE FROM rcv_serials_interface
137: WHERE interface_transaction_id = p_bkup_rti_id;
138:
139: IF (g_asn_debug = 'Y') THEN
140: asn_debug.put_line('DELETED RSI');
141: END IF;
142: EXCEPTION
143: WHEN OTHERS THEN NULL;

Line 140: asn_debug.put_line('DELETED RSI');

136: DELETE FROM rcv_serials_interface
137: WHERE interface_transaction_id = p_bkup_rti_id;
138:
139: IF (g_asn_debug = 'Y') THEN
140: asn_debug.put_line('DELETED RSI');
141: END IF;
142: EXCEPTION
143: WHEN OTHERS THEN NULL;
144: END;

Line 150: IF (g_asn_debug = 'Y') THEN

146: BEGIN
147: DELETE FROM mtl_transaction_lots_temp
148: WHERE product_transaction_id = p_bkup_rti_id;
149:
150: IF (g_asn_debug = 'Y') THEN
151: asn_debug.put_line('DELETED MTLT');
152: END IF;
153: EXCEPTION
154: WHEN OTHERS THEN NULL;

Line 151: asn_debug.put_line('DELETED MTLT');

147: DELETE FROM mtl_transaction_lots_temp
148: WHERE product_transaction_id = p_bkup_rti_id;
149:
150: IF (g_asn_debug = 'Y') THEN
151: asn_debug.put_line('DELETED MTLT');
152: END IF;
153: EXCEPTION
154: WHEN OTHERS THEN NULL;
155: END;

Line 161: IF (g_asn_debug = 'Y') THEN

157: BEGIN
158: DELETE FROM mtl_serial_numbers_temp
159: WHERE product_transaction_id = p_bkup_rti_id;
160:
161: IF (g_asn_debug = 'Y') THEN
162: asn_debug.put_line('DELETED MSNT');
163: END IF;
164: EXCEPTION
165: WHEN OTHERS THEN NULL;

Line 162: asn_debug.put_line('DELETED MSNT');

158: DELETE FROM mtl_serial_numbers_temp
159: WHERE product_transaction_id = p_bkup_rti_id;
160:
161: IF (g_asn_debug = 'Y') THEN
162: asn_debug.put_line('DELETED MSNT');
163: END IF;
164: EXCEPTION
165: WHEN OTHERS THEN NULL;
166: END;

Line 171: IF (g_asn_debug = 'Y') THEN

167:
168: --
169: EXCEPTION
170: WHEN OTHERS THEN
171: IF (g_asn_debug = 'Y') THEN
172: asn_debug.put_line('Unexpected exception in remove_RTV_order : ' || SQLERRM);
173: END IF;
174: raise fnd_api.g_exc_unexpected_error;
175: END remove_RTV_order;

Line 172: asn_debug.put_line('Unexpected exception in remove_RTV_order : ' || SQLERRM);

168: --
169: EXCEPTION
170: WHEN OTHERS THEN
171: IF (g_asn_debug = 'Y') THEN
172: asn_debug.put_line('Unexpected exception in remove_RTV_order : ' || SQLERRM);
173: END IF;
174: raise fnd_api.g_exc_unexpected_error;
175: END remove_RTV_order;
176: --RTV2 rtv project phase 2 : end

Line 217: IF (g_asn_debug = 'Y') THEN

213: l_rsv_rec.ship_ready_flag := 1;
214: l_rsv_rec.staged_flag := 'Y';
215: --RTV2 rtv project phase 2 : start
216: l_rsv_rec.lpn_id := p_lpn_id;
217: IF (g_asn_debug = 'Y') THEN
218: asn_debug.put_line('In create_return_reservation,p_lpn_id : ' || p_lpn_id);
219: END IF;
220: --We need to call clear_quantity_cache, as for multiple lines cases
221: --if one line fails, the qty tree will be cached with incorrect qty

Line 218: asn_debug.put_line('In create_return_reservation,p_lpn_id : ' || p_lpn_id);

214: l_rsv_rec.staged_flag := 'Y';
215: --RTV2 rtv project phase 2 : start
216: l_rsv_rec.lpn_id := p_lpn_id;
217: IF (g_asn_debug = 'Y') THEN
218: asn_debug.put_line('In create_return_reservation,p_lpn_id : ' || p_lpn_id);
219: END IF;
220: --We need to call clear_quantity_cache, as for multiple lines cases
221: --if one line fails, the qty tree will be cached with incorrect qty
222: inv_quantity_tree_pub.clear_quantity_cache;

Line 223: IF (g_asn_debug = 'Y') THEN

219: END IF;
220: --We need to call clear_quantity_cache, as for multiple lines cases
221: --if one line fails, the qty tree will be cached with incorrect qty
222: inv_quantity_tree_pub.clear_quantity_cache;
223: IF (g_asn_debug = 'Y') THEN
224: asn_debug.put_line('inv_quantity_tree_pub.clear_quantity_cache ');
225: END IF;
226: --RTV2 rtv project phase 2 : end
227:

Line 224: asn_debug.put_line('inv_quantity_tree_pub.clear_quantity_cache ');

220: --We need to call clear_quantity_cache, as for multiple lines cases
221: --if one line fails, the qty tree will be cached with incorrect qty
222: inv_quantity_tree_pub.clear_quantity_cache;
223: IF (g_asn_debug = 'Y') THEN
224: asn_debug.put_line('inv_quantity_tree_pub.clear_quantity_cache ');
225: END IF;
226: --RTV2 rtv project phase 2 : end
227:
228: INV_Reservation_PUB.Create_Reservation

Line 246: asn_debug.put_line('Created reservation successfully');--RTV2 rtv project phase 2

242: , x_reservation_id => l_org_wide_res_id
243: );
244:
245: IF (nvl(x_msg_count,0) = 0) THEN
246: asn_debug.put_line('Created reservation successfully');--RTV2 rtv project phase 2
247: ELSE
248: asn_debug.put_line(' Could not reserve for org : ----> ' || p_wdd_rec.organization_id);
249: asn_debug.put_line(' Could not reserve for item : ----> ' || p_wdd_rec.inventory_item_id);
250: FOR i IN 1..x_msg_count LOOP --RTV2 rtv project phase 2

Line 248: asn_debug.put_line(' Could not reserve for org : ----> ' || p_wdd_rec.organization_id);

244:
245: IF (nvl(x_msg_count,0) = 0) THEN
246: asn_debug.put_line('Created reservation successfully');--RTV2 rtv project phase 2
247: ELSE
248: asn_debug.put_line(' Could not reserve for org : ----> ' || p_wdd_rec.organization_id);
249: asn_debug.put_line(' Could not reserve for item : ----> ' || p_wdd_rec.inventory_item_id);
250: FOR i IN 1..x_msg_count LOOP --RTV2 rtv project phase 2
251: l_message := fnd_msg_pub.get(I, 'F');
252: asn_debug.put_line(substr(l_message,1,255));

Line 249: asn_debug.put_line(' Could not reserve for item : ----> ' || p_wdd_rec.inventory_item_id);

245: IF (nvl(x_msg_count,0) = 0) THEN
246: asn_debug.put_line('Created reservation successfully');--RTV2 rtv project phase 2
247: ELSE
248: asn_debug.put_line(' Could not reserve for org : ----> ' || p_wdd_rec.organization_id);
249: asn_debug.put_line(' Could not reserve for item : ----> ' || p_wdd_rec.inventory_item_id);
250: FOR i IN 1..x_msg_count LOOP --RTV2 rtv project phase 2
251: l_message := fnd_msg_pub.get(I, 'F');
252: asn_debug.put_line(substr(l_message,1,255));
253: end LOOP;

Line 252: asn_debug.put_line(substr(l_message,1,255));

248: asn_debug.put_line(' Could not reserve for org : ----> ' || p_wdd_rec.organization_id);
249: asn_debug.put_line(' Could not reserve for item : ----> ' || p_wdd_rec.inventory_item_id);
250: FOR i IN 1..x_msg_count LOOP --RTV2 rtv project phase 2
251: l_message := fnd_msg_pub.get(I, 'F');
252: asn_debug.put_line(substr(l_message,1,255));
253: end LOOP;
254: END IF;
255: EXCEPTION
256: WHEN OTHERS THEN

Line 257: IF (g_asn_debug = 'Y') THEN

253: end LOOP;
254: END IF;
255: EXCEPTION
256: WHEN OTHERS THEN
257: IF (g_asn_debug = 'Y') THEN
258: asn_debug.put_line('Unexpected exception in create_return_reservation : ' || SQLERRM);
259: END IF;
260: raise fnd_api.g_exc_unexpected_error;
261: END create_return_reservation;

Line 258: asn_debug.put_line('Unexpected exception in create_return_reservation : ' || SQLERRM);

254: END IF;
255: EXCEPTION
256: WHEN OTHERS THEN
257: IF (g_asn_debug = 'Y') THEN
258: asn_debug.put_line('Unexpected exception in create_return_reservation : ' || SQLERRM);
259: END IF;
260: raise fnd_api.g_exc_unexpected_error;
261: END create_return_reservation;
262: --

Line 282: IF (g_asn_debug = 'Y') THEN

278: l_message VARCHAR2(2000);
279:
280: BEGIN
281:
282: IF (g_asn_debug = 'Y') THEN
283: asn_debug.put_line('Relieving reservation against WDD : ' || p_wdd_rec.delivery_detail_id);
284: END IF;
285:
286: inv_trx_relief_c_pvt.rsv_relief

Line 283: asn_debug.put_line('Relieving reservation against WDD : ' || p_wdd_rec.delivery_detail_id);

279:
280: BEGIN
281:
282: IF (g_asn_debug = 'Y') THEN
283: asn_debug.put_line('Relieving reservation against WDD : ' || p_wdd_rec.delivery_detail_id);
284: END IF;
285:
286: inv_trx_relief_c_pvt.rsv_relief
287: ( x_return_status => x_return_status,-- RTV2 rtv project phase 2

Line 309: asn_debug.put_line('Relieved reservation successfully');

305: p_qty_at_puom => p_wdd_rec.shipped_quantity,
306: p_lpn_id => p_lpn_id); -- RTV2 rtv project phase 2
307:
308: IF (nvl(x_msg_count,0) = 0) THEN -- RTV2 rtv project phase 2
309: asn_debug.put_line('Relieved reservation successfully');
310: ELSE
311: asn_debug.put_line(' Could not relieve reservation for org : ----> ' || p_wdd_rec.organization_id);
312: asn_debug.put_line(' Could not relieve reservation for item : ----> ' || p_wdd_rec.inventory_item_id);
313: FOR i IN 1..x_msg_count LOOP -- RTV2 rtv project phase 2

Line 311: asn_debug.put_line(' Could not relieve reservation for org : ----> ' || p_wdd_rec.organization_id);

307:
308: IF (nvl(x_msg_count,0) = 0) THEN -- RTV2 rtv project phase 2
309: asn_debug.put_line('Relieved reservation successfully');
310: ELSE
311: asn_debug.put_line(' Could not relieve reservation for org : ----> ' || p_wdd_rec.organization_id);
312: asn_debug.put_line(' Could not relieve reservation for item : ----> ' || p_wdd_rec.inventory_item_id);
313: FOR i IN 1..x_msg_count LOOP -- RTV2 rtv project phase 2
314: l_message := fnd_msg_pub.get(I, 'F');
315: asn_debug.put_line(substr(l_message,1,255));

Line 312: asn_debug.put_line(' Could not relieve reservation for item : ----> ' || p_wdd_rec.inventory_item_id);

308: IF (nvl(x_msg_count,0) = 0) THEN -- RTV2 rtv project phase 2
309: asn_debug.put_line('Relieved reservation successfully');
310: ELSE
311: asn_debug.put_line(' Could not relieve reservation for org : ----> ' || p_wdd_rec.organization_id);
312: asn_debug.put_line(' Could not relieve reservation for item : ----> ' || p_wdd_rec.inventory_item_id);
313: FOR i IN 1..x_msg_count LOOP -- RTV2 rtv project phase 2
314: l_message := fnd_msg_pub.get(I, 'F');
315: asn_debug.put_line(substr(l_message,1,255));
316: end LOOP;

Line 315: asn_debug.put_line(substr(l_message,1,255));

311: asn_debug.put_line(' Could not relieve reservation for org : ----> ' || p_wdd_rec.organization_id);
312: asn_debug.put_line(' Could not relieve reservation for item : ----> ' || p_wdd_rec.inventory_item_id);
313: FOR i IN 1..x_msg_count LOOP -- RTV2 rtv project phase 2
314: l_message := fnd_msg_pub.get(I, 'F');
315: asn_debug.put_line(substr(l_message,1,255));
316: end LOOP;
317: END IF;
318:
319: EXCEPTION

Line 321: IF (g_asn_debug = 'Y') THEN

317: END IF;
318:
319: EXCEPTION
320: WHEN OTHERS THEN
321: IF (g_asn_debug = 'Y') THEN
322: asn_debug.put_line('Unexpected exception in relieve_return_reservation : ' || SQLERRM);
323: END IF;
324: raise fnd_api.g_exc_unexpected_error;
325: END relieve_return_reservation;

Line 322: asn_debug.put_line('Unexpected exception in relieve_return_reservation : ' || SQLERRM);

318:
319: EXCEPTION
320: WHEN OTHERS THEN
321: IF (g_asn_debug = 'Y') THEN
322: asn_debug.put_line('Unexpected exception in relieve_return_reservation : ' || SQLERRM);
323: END IF;
324: raise fnd_api.g_exc_unexpected_error;
325: END relieve_return_reservation;
326:

Line 350: IF (g_asn_debug = 'Y') THEN

346: raise fnd_api.g_exc_unexpected_error;
347: END IF;
348: EXCEPTION
349: WHEN OTHERS THEN
350: IF (g_asn_debug = 'Y') THEN
351: asn_debug.put_line('Unexpected exception in relieve_return_reservation : ' || SQLERRM);
352: END IF;
353: raise fnd_api.g_exc_unexpected_error;
354: END relieve_return_reservation;

Line 351: asn_debug.put_line('Unexpected exception in relieve_return_reservation : ' || SQLERRM);

347: END IF;
348: EXCEPTION
349: WHEN OTHERS THEN
350: IF (g_asn_debug = 'Y') THEN
351: asn_debug.put_line('Unexpected exception in relieve_return_reservation : ' || SQLERRM);
352: END IF;
353: raise fnd_api.g_exc_unexpected_error;
354: END relieve_return_reservation;
355: --

Line 416: IF (g_asn_debug = 'Y') THEN

412: END IF;
413: END IF;
414: EXCEPTION
415: WHEN OTHERS THEN
416: IF (g_asn_debug = 'Y') THEN
417: asn_debug.put_line('Unexpected exception in rollback_rtp_fail : ' || SQLERRM);
418: END IF;
419: raise fnd_api.g_exc_unexpected_error;
420: END;

Line 417: asn_debug.put_line('Unexpected exception in rollback_rtp_fail : ' || SQLERRM);

413: END IF;
414: EXCEPTION
415: WHEN OTHERS THEN
416: IF (g_asn_debug = 'Y') THEN
417: asn_debug.put_line('Unexpected exception in rollback_rtp_fail : ' || SQLERRM);
418: END IF;
419: raise fnd_api.g_exc_unexpected_error;
420: END;
421: --this procedure is used for RTV in receipt org only.

Line 478: asn_debug.put_line(' Could not remark lpn : ----> ' || mark_rec.transfer_lpn_id);

474: p_subinventory => mark_rec.from_subinventory,
475: p_locator_id => mark_rec.from_locator_id);
476:
477: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
478: asn_debug.put_line(' Could not remark lpn : ----> ' || mark_rec.transfer_lpn_id);
479: asn_debug.put_line(' Could not remark for item : ----> ' || mark_rec.item_id);
480: FOR i IN 1..l_msg_count LOOP
481: l_message := fnd_msg_pub.get(i, 'F');
482: asn_debug.put_line(substr(l_message,1,255));

Line 479: asn_debug.put_line(' Could not remark for item : ----> ' || mark_rec.item_id);

475: p_locator_id => mark_rec.from_locator_id);
476:
477: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
478: asn_debug.put_line(' Could not remark lpn : ----> ' || mark_rec.transfer_lpn_id);
479: asn_debug.put_line(' Could not remark for item : ----> ' || mark_rec.item_id);
480: FOR i IN 1..l_msg_count LOOP
481: l_message := fnd_msg_pub.get(i, 'F');
482: asn_debug.put_line(substr(l_message,1,255));
483: end LOOP;

Line 482: asn_debug.put_line(substr(l_message,1,255));

478: asn_debug.put_line(' Could not remark lpn : ----> ' || mark_rec.transfer_lpn_id);
479: asn_debug.put_line(' Could not remark for item : ----> ' || mark_rec.item_id);
480: FOR i IN 1..l_msg_count LOOP
481: l_message := fnd_msg_pub.get(i, 'F');
482: asn_debug.put_line(substr(l_message,1,255));
483: end LOOP;
484: raise fnd_api.g_exc_unexpected_error;
485: END IF;
486: END LOOP;

Line 489: IF (g_asn_debug = 'Y') THEN

485: END IF;
486: END LOOP;
487: EXCEPTION
488: WHEN OTHERS THEN
489: IF (g_asn_debug = 'Y') THEN
490: asn_debug.put_line('Unexpected exception in marklpn_rtp_fail : ' || SQLERRM);
491: END IF;
492: raise fnd_api.g_exc_unexpected_error;
493: END;

Line 490: asn_debug.put_line('Unexpected exception in marklpn_rtp_fail : ' || SQLERRM);

486: END LOOP;
487: EXCEPTION
488: WHEN OTHERS THEN
489: IF (g_asn_debug = 'Y') THEN
490: asn_debug.put_line('Unexpected exception in marklpn_rtp_fail : ' || SQLERRM);
491: END IF;
492: raise fnd_api.g_exc_unexpected_error;
493: END;
494: -- RTV2 rtv project phase 2 : end

Line 542: IF (g_asn_debug = 'Y') THEN

538:
539:
540: BEGIN
541:
542: IF (g_asn_debug = 'Y') THEN
543: asn_debug.put_line('Entering create_delivery_details');
544: END IF;
545:
546: l_progress := '000';

Line 543: asn_debug.put_line('Entering create_delivery_details');

539:
540: BEGIN
541:
542: IF (g_asn_debug = 'Y') THEN
543: asn_debug.put_line('Entering create_delivery_details');
544: END IF;
545:
546: l_progress := '000';
547: SELECT *

Line 649: IF (g_asn_debug = 'Y') THEN

645: ( in_org_id => p_return_org_id,
646: in_item_id => rti_rec.item_id,
647: in_locator_id => rti_rec.from_locator_id);
648:
649: IF (g_asn_debug = 'Y') THEN
650: asn_debug.put_line('l_functional_currency : ' || l_functional_currency);
651: asn_debug.put_line('l_price_in_fc : ' || l_price_in_fc);
652: END IF;
653:

Line 650: asn_debug.put_line('l_functional_currency : ' || l_functional_currency);

646: in_item_id => rti_rec.item_id,
647: in_locator_id => rti_rec.from_locator_id);
648:
649: IF (g_asn_debug = 'Y') THEN
650: asn_debug.put_line('l_functional_currency : ' || l_functional_currency);
651: asn_debug.put_line('l_price_in_fc : ' || l_price_in_fc);
652: END IF;
653:
654: IF (l_currency IS NOT NULL AND l_currency <> l_functional_currency) THEN

Line 651: asn_debug.put_line('l_price_in_fc : ' || l_price_in_fc);

647: in_locator_id => rti_rec.from_locator_id);
648:
649: IF (g_asn_debug = 'Y') THEN
650: asn_debug.put_line('l_functional_currency : ' || l_functional_currency);
651: asn_debug.put_line('l_price_in_fc : ' || l_price_in_fc);
652: END IF;
653:
654: IF (l_currency IS NOT NULL AND l_currency <> l_functional_currency) THEN
655: l_progress := '055';

Line 664: IF (g_asn_debug = 'Y') THEN

660: l_currency,
661: rti_rec.transaction_date,
662: l_currency_conv_type );
663:
664: IF (g_asn_debug = 'Y') THEN
665: asn_debug.put_line('l_currency_conv_type : ' || l_currency_conv_type);
666: asn_debug.put_line('l_rate : ' || l_rate);
667: END IF;
668:

Line 665: asn_debug.put_line('l_currency_conv_type : ' || l_currency_conv_type);

661: rti_rec.transaction_date,
662: l_currency_conv_type );
663:
664: IF (g_asn_debug = 'Y') THEN
665: asn_debug.put_line('l_currency_conv_type : ' || l_currency_conv_type);
666: asn_debug.put_line('l_rate : ' || l_rate);
667: END IF;
668:
669: l_price := l_price_in_fc * l_rate ;

Line 666: asn_debug.put_line('l_rate : ' || l_rate);

662: l_currency_conv_type );
663:
664: IF (g_asn_debug = 'Y') THEN
665: asn_debug.put_line('l_currency_conv_type : ' || l_currency_conv_type);
666: asn_debug.put_line('l_rate : ' || l_rate);
667: END IF;
668:
669: l_price := l_price_in_fc * l_rate ;
670:

Line 693: IF (g_asn_debug = 'Y') THEN

689:
690: l_wdd_tbl(1).currency_code := l_currency;
691: l_wdd_tbl(1).unit_price := l_price;
692:
693: IF (g_asn_debug = 'Y') THEN
694: asn_debug.put_line('currency : ' || l_wdd_tbl(1).currency_code);
695: asn_debug.put_line('unit_price : ' || l_wdd_tbl(1).unit_price);
696: END IF;
697:

Line 694: asn_debug.put_line('currency : ' || l_wdd_tbl(1).currency_code);

690: l_wdd_tbl(1).currency_code := l_currency;
691: l_wdd_tbl(1).unit_price := l_price;
692:
693: IF (g_asn_debug = 'Y') THEN
694: asn_debug.put_line('currency : ' || l_wdd_tbl(1).currency_code);
695: asn_debug.put_line('unit_price : ' || l_wdd_tbl(1).unit_price);
696: END IF;
697:
698: l_progress := '080';

Line 695: asn_debug.put_line('unit_price : ' || l_wdd_tbl(1).unit_price);

691: l_wdd_tbl(1).unit_price := l_price;
692:
693: IF (g_asn_debug = 'Y') THEN
694: asn_debug.put_line('currency : ' || l_wdd_tbl(1).currency_code);
695: asn_debug.put_line('unit_price : ' || l_wdd_tbl(1).unit_price);
696: END IF;
697:
698: l_progress := '080';
699:

Line 736: IF (g_asn_debug = 'Y') THEN

732: AND msi.organization_id = p_return_org_id;
733:
734: l_wdd_tbl(1).gross_weight := l_wdd_tbl(1).net_weight;
735:
736: IF (g_asn_debug = 'Y') THEN
737: asn_debug.put_line('l_wdd_tbl(1).requested_quantity_uom : ' || l_wdd_tbl(1).requested_quantity_uom);
738: asn_debug.put_line('l_wdd_tbl(1).weight_uom_code : ' || l_wdd_tbl(1).weight_uom_code);
739: asn_debug.put_line('l_wdd_tbl(1).unit_weight : ' || l_wdd_tbl(1).unit_weight);
740: asn_debug.put_line('l_wdd_tbl(1).net_weight : ' || l_wdd_tbl(1).net_weight);

Line 737: asn_debug.put_line('l_wdd_tbl(1).requested_quantity_uom : ' || l_wdd_tbl(1).requested_quantity_uom);

733:
734: l_wdd_tbl(1).gross_weight := l_wdd_tbl(1).net_weight;
735:
736: IF (g_asn_debug = 'Y') THEN
737: asn_debug.put_line('l_wdd_tbl(1).requested_quantity_uom : ' || l_wdd_tbl(1).requested_quantity_uom);
738: asn_debug.put_line('l_wdd_tbl(1).weight_uom_code : ' || l_wdd_tbl(1).weight_uom_code);
739: asn_debug.put_line('l_wdd_tbl(1).unit_weight : ' || l_wdd_tbl(1).unit_weight);
740: asn_debug.put_line('l_wdd_tbl(1).net_weight : ' || l_wdd_tbl(1).net_weight);
741: asn_debug.put_line('l_wdd_tbl(1).gross_weight : ' || l_wdd_tbl(1).gross_weight);

Line 738: asn_debug.put_line('l_wdd_tbl(1).weight_uom_code : ' || l_wdd_tbl(1).weight_uom_code);

734: l_wdd_tbl(1).gross_weight := l_wdd_tbl(1).net_weight;
735:
736: IF (g_asn_debug = 'Y') THEN
737: asn_debug.put_line('l_wdd_tbl(1).requested_quantity_uom : ' || l_wdd_tbl(1).requested_quantity_uom);
738: asn_debug.put_line('l_wdd_tbl(1).weight_uom_code : ' || l_wdd_tbl(1).weight_uom_code);
739: asn_debug.put_line('l_wdd_tbl(1).unit_weight : ' || l_wdd_tbl(1).unit_weight);
740: asn_debug.put_line('l_wdd_tbl(1).net_weight : ' || l_wdd_tbl(1).net_weight);
741: asn_debug.put_line('l_wdd_tbl(1).gross_weight : ' || l_wdd_tbl(1).gross_weight);
742: asn_debug.put_line('l_wdd_tbl(1).volume_uom_code : ' || l_wdd_tbl(1).volume_uom_code);

Line 739: asn_debug.put_line('l_wdd_tbl(1).unit_weight : ' || l_wdd_tbl(1).unit_weight);

735:
736: IF (g_asn_debug = 'Y') THEN
737: asn_debug.put_line('l_wdd_tbl(1).requested_quantity_uom : ' || l_wdd_tbl(1).requested_quantity_uom);
738: asn_debug.put_line('l_wdd_tbl(1).weight_uom_code : ' || l_wdd_tbl(1).weight_uom_code);
739: asn_debug.put_line('l_wdd_tbl(1).unit_weight : ' || l_wdd_tbl(1).unit_weight);
740: asn_debug.put_line('l_wdd_tbl(1).net_weight : ' || l_wdd_tbl(1).net_weight);
741: asn_debug.put_line('l_wdd_tbl(1).gross_weight : ' || l_wdd_tbl(1).gross_weight);
742: asn_debug.put_line('l_wdd_tbl(1).volume_uom_code : ' || l_wdd_tbl(1).volume_uom_code);
743: asn_debug.put_line('l_wdd_tbl(1).unit_volume : ' || l_wdd_tbl(1).unit_volume);

Line 740: asn_debug.put_line('l_wdd_tbl(1).net_weight : ' || l_wdd_tbl(1).net_weight);

736: IF (g_asn_debug = 'Y') THEN
737: asn_debug.put_line('l_wdd_tbl(1).requested_quantity_uom : ' || l_wdd_tbl(1).requested_quantity_uom);
738: asn_debug.put_line('l_wdd_tbl(1).weight_uom_code : ' || l_wdd_tbl(1).weight_uom_code);
739: asn_debug.put_line('l_wdd_tbl(1).unit_weight : ' || l_wdd_tbl(1).unit_weight);
740: asn_debug.put_line('l_wdd_tbl(1).net_weight : ' || l_wdd_tbl(1).net_weight);
741: asn_debug.put_line('l_wdd_tbl(1).gross_weight : ' || l_wdd_tbl(1).gross_weight);
742: asn_debug.put_line('l_wdd_tbl(1).volume_uom_code : ' || l_wdd_tbl(1).volume_uom_code);
743: asn_debug.put_line('l_wdd_tbl(1).unit_volume : ' || l_wdd_tbl(1).unit_volume);
744: asn_debug.put_line('l_wdd_tbl(1).volume : ' || l_wdd_tbl(1).volume);

Line 741: asn_debug.put_line('l_wdd_tbl(1).gross_weight : ' || l_wdd_tbl(1).gross_weight);

737: asn_debug.put_line('l_wdd_tbl(1).requested_quantity_uom : ' || l_wdd_tbl(1).requested_quantity_uom);
738: asn_debug.put_line('l_wdd_tbl(1).weight_uom_code : ' || l_wdd_tbl(1).weight_uom_code);
739: asn_debug.put_line('l_wdd_tbl(1).unit_weight : ' || l_wdd_tbl(1).unit_weight);
740: asn_debug.put_line('l_wdd_tbl(1).net_weight : ' || l_wdd_tbl(1).net_weight);
741: asn_debug.put_line('l_wdd_tbl(1).gross_weight : ' || l_wdd_tbl(1).gross_weight);
742: asn_debug.put_line('l_wdd_tbl(1).volume_uom_code : ' || l_wdd_tbl(1).volume_uom_code);
743: asn_debug.put_line('l_wdd_tbl(1).unit_volume : ' || l_wdd_tbl(1).unit_volume);
744: asn_debug.put_line('l_wdd_tbl(1).volume : ' || l_wdd_tbl(1).volume);
745: END IF;

Line 742: asn_debug.put_line('l_wdd_tbl(1).volume_uom_code : ' || l_wdd_tbl(1).volume_uom_code);

738: asn_debug.put_line('l_wdd_tbl(1).weight_uom_code : ' || l_wdd_tbl(1).weight_uom_code);
739: asn_debug.put_line('l_wdd_tbl(1).unit_weight : ' || l_wdd_tbl(1).unit_weight);
740: asn_debug.put_line('l_wdd_tbl(1).net_weight : ' || l_wdd_tbl(1).net_weight);
741: asn_debug.put_line('l_wdd_tbl(1).gross_weight : ' || l_wdd_tbl(1).gross_weight);
742: asn_debug.put_line('l_wdd_tbl(1).volume_uom_code : ' || l_wdd_tbl(1).volume_uom_code);
743: asn_debug.put_line('l_wdd_tbl(1).unit_volume : ' || l_wdd_tbl(1).unit_volume);
744: asn_debug.put_line('l_wdd_tbl(1).volume : ' || l_wdd_tbl(1).volume);
745: END IF;
746:

Line 743: asn_debug.put_line('l_wdd_tbl(1).unit_volume : ' || l_wdd_tbl(1).unit_volume);

739: asn_debug.put_line('l_wdd_tbl(1).unit_weight : ' || l_wdd_tbl(1).unit_weight);
740: asn_debug.put_line('l_wdd_tbl(1).net_weight : ' || l_wdd_tbl(1).net_weight);
741: asn_debug.put_line('l_wdd_tbl(1).gross_weight : ' || l_wdd_tbl(1).gross_weight);
742: asn_debug.put_line('l_wdd_tbl(1).volume_uom_code : ' || l_wdd_tbl(1).volume_uom_code);
743: asn_debug.put_line('l_wdd_tbl(1).unit_volume : ' || l_wdd_tbl(1).unit_volume);
744: asn_debug.put_line('l_wdd_tbl(1).volume : ' || l_wdd_tbl(1).volume);
745: END IF;
746:
747: l_progress := '090';

Line 744: asn_debug.put_line('l_wdd_tbl(1).volume : ' || l_wdd_tbl(1).volume);

740: asn_debug.put_line('l_wdd_tbl(1).net_weight : ' || l_wdd_tbl(1).net_weight);
741: asn_debug.put_line('l_wdd_tbl(1).gross_weight : ' || l_wdd_tbl(1).gross_weight);
742: asn_debug.put_line('l_wdd_tbl(1).volume_uom_code : ' || l_wdd_tbl(1).volume_uom_code);
743: asn_debug.put_line('l_wdd_tbl(1).unit_volume : ' || l_wdd_tbl(1).unit_volume);
744: asn_debug.put_line('l_wdd_tbl(1).volume : ' || l_wdd_tbl(1).volume);
745: END IF;
746:
747: l_progress := '090';
748: IF (p_use_mtl_lot <> 2) THEN

Line 898: IF (g_asn_debug = 'Y') THEN

894:
895: END IF;
896:
897: l_progress := '300';
898: IF (g_asn_debug = 'Y') THEN
899: asn_debug.put_line('Leaving create_delivery_details');
900: END IF;
901:
902: EXCEPTION

Line 899: asn_debug.put_line('Leaving create_delivery_details');

895: END IF;
896:
897: l_progress := '300';
898: IF (g_asn_debug = 'Y') THEN
899: asn_debug.put_line('Leaving create_delivery_details');
900: END IF;
901:
902: EXCEPTION
903: WHEN e_location_error THEN

Line 904: IF (g_asn_debug = 'Y') THEN

900: END IF;
901:
902: EXCEPTION
903: WHEN e_location_error THEN
904: IF (g_asn_debug = 'Y') THEN
905: asn_debug.put_line('e_wsh_loc_error in create_delivery_details : ' || l_progress);
906: END IF;
907:
908: fnd_msg_pub.count_and_get (p_encoded => 'T',

Line 905: asn_debug.put_line('e_wsh_loc_error in create_delivery_details : ' || l_progress);

901:
902: EXCEPTION
903: WHEN e_location_error THEN
904: IF (g_asn_debug = 'Y') THEN
905: asn_debug.put_line('e_wsh_loc_error in create_delivery_details : ' || l_progress);
906: END IF;
907:
908: fnd_msg_pub.count_and_get (p_encoded => 'T',
909: p_count => l_msg_count,

Line 921: IF (g_asn_debug = 'Y') THEN

917: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);
918: raise fnd_api.g_exc_error;
919:
920: WHEN e_wdd_creation_error THEN
921: IF (g_asn_debug = 'Y') THEN
922: asn_debug.put_line('e_wdd_creation_error in create_delivery_details : ' || l_progress);
923: END IF;
924: l_msg_data := fnd_msg_pub.get (1, 'F');
925: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);

Line 922: asn_debug.put_line('e_wdd_creation_error in create_delivery_details : ' || l_progress);

918: raise fnd_api.g_exc_error;
919:
920: WHEN e_wdd_creation_error THEN
921: IF (g_asn_debug = 'Y') THEN
922: asn_debug.put_line('e_wdd_creation_error in create_delivery_details : ' || l_progress);
923: END IF;
924: l_msg_data := fnd_msg_pub.get (1, 'F');
925: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);
926: raise fnd_api.g_exc_error;

Line 930: IF (g_asn_debug = 'Y') THEN

926: raise fnd_api.g_exc_error;
927:
928: --RTV2 rtv project phase 2 : start
929: WHEN e_con_wdd_creation_error THEN
930: IF (g_asn_debug = 'Y') THEN
931: asn_debug.put_line('e_con_wdd_creation_error in create_delivery_details : ' || l_progress);
932: END IF;
933: fnd_msg_pub.count_and_get (p_encoded => 'T',
934: p_count => l_msg_count,

Line 931: asn_debug.put_line('e_con_wdd_creation_error in create_delivery_details : ' || l_progress);

927:
928: --RTV2 rtv project phase 2 : start
929: WHEN e_con_wdd_creation_error THEN
930: IF (g_asn_debug = 'Y') THEN
931: asn_debug.put_line('e_con_wdd_creation_error in create_delivery_details : ' || l_progress);
932: END IF;
933: fnd_msg_pub.count_and_get (p_encoded => 'T',
934: p_count => l_msg_count,
935: p_data => l_msg_data

Line 945: IF (g_asn_debug = 'Y') THEN

941: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);
942: raise fnd_api.g_exc_error;
943:
944: WHEN e_mr_creation_error THEN
945: IF (g_asn_debug = 'Y') THEN
946: asn_debug.put_line('e_mr_creation_error in create_delivery_details : ' || l_progress);
947: END IF;
948: fnd_msg_pub.count_and_get (p_encoded => 'T',
949: p_count => l_msg_count,

Line 946: asn_debug.put_line('e_mr_creation_error in create_delivery_details : ' || l_progress);

942: raise fnd_api.g_exc_error;
943:
944: WHEN e_mr_creation_error THEN
945: IF (g_asn_debug = 'Y') THEN
946: asn_debug.put_line('e_mr_creation_error in create_delivery_details : ' || l_progress);
947: END IF;
948: fnd_msg_pub.count_and_get (p_encoded => 'T',
949: p_count => l_msg_count,
950: p_data => l_msg_data

Line 961: IF (g_asn_debug = 'Y') THEN

957: raise fnd_api.g_exc_error;
958: --RTV2 rtv project phase 2 : end
959:
960: WHEN OTHERS THEN
961: IF (g_asn_debug = 'Y') THEN
962: asn_debug.put_line('Unexpected exception in create_delivery_details : ' || SQLERRM);
963: asn_debug.put_line('l_progress : ' || l_progress);
964: END IF;
965: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', 'Unexpected exception', sqlcode);

Line 962: asn_debug.put_line('Unexpected exception in create_delivery_details : ' || SQLERRM);

958: --RTV2 rtv project phase 2 : end
959:
960: WHEN OTHERS THEN
961: IF (g_asn_debug = 'Y') THEN
962: asn_debug.put_line('Unexpected exception in create_delivery_details : ' || SQLERRM);
963: asn_debug.put_line('l_progress : ' || l_progress);
964: END IF;
965: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', 'Unexpected exception', sqlcode);
966: raise fnd_api.g_exc_unexpected_error;

Line 963: asn_debug.put_line('l_progress : ' || l_progress);

959:
960: WHEN OTHERS THEN
961: IF (g_asn_debug = 'Y') THEN
962: asn_debug.put_line('Unexpected exception in create_delivery_details : ' || SQLERRM);
963: asn_debug.put_line('l_progress : ' || l_progress);
964: END IF;
965: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', 'Unexpected exception', sqlcode);
966: raise fnd_api.g_exc_unexpected_error;
967: END create_delivery_details;

Line 1106: IF (g_asn_debug = 'Y') THEN

1102: l_index NUMBER:= 0;
1103: l_detail_rows wsh_util_core.id_tab_type;
1104:
1105: BEGIN
1106: IF (g_asn_debug = 'Y') THEN
1107: asn_debug.put_line('Inside interface_to_rcv : p_delivery_id => ' || p_delivery_id);
1108: END IF;
1109:
1110: ----------------------------------------- Return agaist no document ---------------------------

Line 1107: asn_debug.put_line('Inside interface_to_rcv : p_delivery_id => ' || p_delivery_id);

1103: l_detail_rows wsh_util_core.id_tab_type;
1104:
1105: BEGIN
1106: IF (g_asn_debug = 'Y') THEN
1107: asn_debug.put_line('Inside interface_to_rcv : p_delivery_id => ' || p_delivery_id);
1108: END IF;
1109:
1110: ----------------------------------------- Return agaist no document ---------------------------
1111: BEGIN

Line 1120: IF (g_asn_debug = 'Y') THEN

1116: l_INVTM_status := NULL;
1117:
1118: FOR wdd_rec IN wdd_cursor_1 LOOP
1119: IF ( l_header_id IS NULL) THEN
1120: IF (g_asn_debug = 'Y') THEN
1121: asn_debug.put_line('-------------------------------------------');
1122: asn_debug.put_line(' Processing Returns without receipts');
1123: asn_debug.put_line('-------------------------------------------');
1124: END IF;

Line 1121: asn_debug.put_line('-------------------------------------------');

1117:
1118: FOR wdd_rec IN wdd_cursor_1 LOOP
1119: IF ( l_header_id IS NULL) THEN
1120: IF (g_asn_debug = 'Y') THEN
1121: asn_debug.put_line('-------------------------------------------');
1122: asn_debug.put_line(' Processing Returns without receipts');
1123: asn_debug.put_line('-------------------------------------------');
1124: END IF;
1125: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232

Line 1122: asn_debug.put_line(' Processing Returns without receipts');

1118: FOR wdd_rec IN wdd_cursor_1 LOOP
1119: IF ( l_header_id IS NULL) THEN
1120: IF (g_asn_debug = 'Y') THEN
1121: asn_debug.put_line('-------------------------------------------');
1122: asn_debug.put_line(' Processing Returns without receipts');
1123: asn_debug.put_line('-------------------------------------------');
1124: END IF;
1125: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232
1126: END IF;

Line 1123: asn_debug.put_line('-------------------------------------------');

1119: IF ( l_header_id IS NULL) THEN
1120: IF (g_asn_debug = 'Y') THEN
1121: asn_debug.put_line('-------------------------------------------');
1122: asn_debug.put_line(' Processing Returns without receipts');
1123: asn_debug.put_line('-------------------------------------------');
1124: END IF;
1125: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232
1126: END IF;
1127: load_mtl_interfaces ('Issue out', wdd_rec, l_header_id, p_delivery_id);

Line 1136: IF (g_asn_debug = 'Y') THEN

1132:
1133: IF (l_INVTM_status = 'S') THEN
1134: perform_post_TM_updates ('INV', p_delivery_id);
1135: COMMIT;
1136: IF (g_asn_debug = 'Y') THEN
1137: asn_debug.put_line ('Returns without receipts processed successfully');
1138: END IF;
1139:
1140: ELSE

Line 1137: asn_debug.put_line ('Returns without receipts processed successfully');

1133: IF (l_INVTM_status = 'S') THEN
1134: perform_post_TM_updates ('INV', p_delivery_id);
1135: COMMIT;
1136: IF (g_asn_debug = 'Y') THEN
1137: asn_debug.put_line ('Returns without receipts processed successfully');
1138: END IF;
1139:
1140: ELSE
1141: ROLLBACK TO SP_InvTM;

Line 1145: asn_debug.put_line(' l_case_1_status => ' || l_case_1_status);

1141: ROLLBACK TO SP_InvTM;
1142: l_case_1_status := l_INVTM_status;
1143: END IF;
1144: END IF;
1145: asn_debug.put_line(' l_case_1_status => ' || l_case_1_status);
1146: --
1147: EXCEPTION
1148: WHEN OTHERS THEN
1149: IF (g_asn_debug = 'Y') THEN

Line 1149: IF (g_asn_debug = 'Y') THEN

1145: asn_debug.put_line(' l_case_1_status => ' || l_case_1_status);
1146: --
1147: EXCEPTION
1148: WHEN OTHERS THEN
1149: IF (g_asn_debug = 'Y') THEN
1150: asn_debug.put_line ('Case1 Unexpected exception : ' || SQLERRM);
1151: END IF;
1152: l_case_1_status := 'E';
1153: ROLLBACK TO SP_InvTM;

Line 1150: asn_debug.put_line ('Case1 Unexpected exception : ' || SQLERRM);

1146: --
1147: EXCEPTION
1148: WHEN OTHERS THEN
1149: IF (g_asn_debug = 'Y') THEN
1150: asn_debug.put_line ('Case1 Unexpected exception : ' || SQLERRM);
1151: END IF;
1152: l_case_1_status := 'E';
1153: ROLLBACK TO SP_InvTM;
1154: END;

Line 1166: IF (g_asn_debug = 'Y') THEN

1162: l_RCVTM_status := NULL;
1163:
1164: FOR wdd_rec IN wdd_cursor_2 LOOP
1165: IF ( l_group_id IS NULL) THEN
1166: IF (g_asn_debug = 'Y') THEN
1167: asn_debug.put_line('-------------------------------------------');
1168: asn_debug.put_line(' Processing Returns in the Receipt org');
1169: asn_debug.put_line('-------------------------------------------');
1170: END IF;

Line 1167: asn_debug.put_line('-------------------------------------------');

1163:
1164: FOR wdd_rec IN wdd_cursor_2 LOOP
1165: IF ( l_group_id IS NULL) THEN
1166: IF (g_asn_debug = 'Y') THEN
1167: asn_debug.put_line('-------------------------------------------');
1168: asn_debug.put_line(' Processing Returns in the Receipt org');
1169: asn_debug.put_line('-------------------------------------------');
1170: END IF;
1171: SELECT rcv_interface_groups_s.nextval INTO l_group_id FROM DUAL; -- Bug 11831232

Line 1168: asn_debug.put_line(' Processing Returns in the Receipt org');

1164: FOR wdd_rec IN wdd_cursor_2 LOOP
1165: IF ( l_group_id IS NULL) THEN
1166: IF (g_asn_debug = 'Y') THEN
1167: asn_debug.put_line('-------------------------------------------');
1168: asn_debug.put_line(' Processing Returns in the Receipt org');
1169: asn_debug.put_line('-------------------------------------------');
1170: END IF;
1171: SELECT rcv_interface_groups_s.nextval INTO l_group_id FROM DUAL; -- Bug 11831232
1172: END IF;

Line 1169: asn_debug.put_line('-------------------------------------------');

1165: IF ( l_group_id IS NULL) THEN
1166: IF (g_asn_debug = 'Y') THEN
1167: asn_debug.put_line('-------------------------------------------');
1168: asn_debug.put_line(' Processing Returns in the Receipt org');
1169: asn_debug.put_line('-------------------------------------------');
1170: END IF;
1171: SELECT rcv_interface_groups_s.nextval INTO l_group_id FROM DUAL; -- Bug 11831232
1172: END IF;
1173: load_rcv_interfaces (p_delivery_id, wdd_rec,l_group_id);

Line 1183: IF (g_asn_debug = 'Y') THEN

1179: invoke_rtp (l_group_id, l_RCVTM_status);
1180:
1181: IF (l_RCVTM_status = 'S') THEN
1182: perform_post_TM_updates ('RCV', p_delivery_id);
1183: IF (g_asn_debug = 'Y') THEN
1184: asn_debug.put_line ('Returns within receipts org processed successfully');
1185: END IF;
1186: ELSE
1187: --RTV2 rtv project phase 2 : start

Line 1184: asn_debug.put_line ('Returns within receipts org processed successfully');

1180:
1181: IF (l_RCVTM_status = 'S') THEN
1182: perform_post_TM_updates ('RCV', p_delivery_id);
1183: IF (g_asn_debug = 'Y') THEN
1184: asn_debug.put_line ('Returns within receipts org processed successfully');
1185: END IF;
1186: ELSE
1187: --RTV2 rtv project phase 2 : start
1188: FOR wdd_rec IN wdd_cursor_2 LOOP

Line 1198: asn_debug.put_line(' l_case_2_status => ' || l_case_2_status);

1194: l_case_2_status := l_RCVTM_status;
1195: END IF;
1196: COMMIT;
1197: END IF;
1198: asn_debug.put_line(' l_case_2_status => ' || l_case_2_status);
1199: --
1200: EXCEPTION
1201: WHEN OTHERS THEN
1202: IF (g_asn_debug = 'Y') THEN

Line 1202: IF (g_asn_debug = 'Y') THEN

1198: asn_debug.put_line(' l_case_2_status => ' || l_case_2_status);
1199: --
1200: EXCEPTION
1201: WHEN OTHERS THEN
1202: IF (g_asn_debug = 'Y') THEN
1203: asn_debug.put_line ('Case2 Unexpected exception : ' || SQLERRM);
1204: END IF;
1205: l_case_2_status := 'E';
1206: ROLLBACK TO SP_RcvTM;

Line 1203: asn_debug.put_line ('Case2 Unexpected exception : ' || SQLERRM);

1199: --
1200: EXCEPTION
1201: WHEN OTHERS THEN
1202: IF (g_asn_debug = 'Y') THEN
1203: asn_debug.put_line ('Case2 Unexpected exception : ' || SQLERRM);
1204: END IF;
1205: l_case_2_status := 'E';
1206: ROLLBACK TO SP_RcvTM;
1207: END;

Line 1219: IF (g_asn_debug = 'Y') THEN

1215: l_INVTM_status := NULL;
1216:
1217: FOR wdd_rec IN wdd_cursor_3 LOOP
1218: IF ( l_header_id IS NULL) THEN
1219: IF (g_asn_debug = 'Y') THEN
1220: asn_debug.put_line('-------------------------------------------');
1221: asn_debug.put_line('Processing Direct transfers from Return hub');
1222: asn_debug.put_line('-------------------------------------------');
1223: END IF;

Line 1220: asn_debug.put_line('-------------------------------------------');

1216:
1217: FOR wdd_rec IN wdd_cursor_3 LOOP
1218: IF ( l_header_id IS NULL) THEN
1219: IF (g_asn_debug = 'Y') THEN
1220: asn_debug.put_line('-------------------------------------------');
1221: asn_debug.put_line('Processing Direct transfers from Return hub');
1222: asn_debug.put_line('-------------------------------------------');
1223: END IF;
1224: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232

Line 1221: asn_debug.put_line('Processing Direct transfers from Return hub');

1217: FOR wdd_rec IN wdd_cursor_3 LOOP
1218: IF ( l_header_id IS NULL) THEN
1219: IF (g_asn_debug = 'Y') THEN
1220: asn_debug.put_line('-------------------------------------------');
1221: asn_debug.put_line('Processing Direct transfers from Return hub');
1222: asn_debug.put_line('-------------------------------------------');
1223: END IF;
1224: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232
1225: END IF;

Line 1222: asn_debug.put_line('-------------------------------------------');

1218: IF ( l_header_id IS NULL) THEN
1219: IF (g_asn_debug = 'Y') THEN
1220: asn_debug.put_line('-------------------------------------------');
1221: asn_debug.put_line('Processing Direct transfers from Return hub');
1222: asn_debug.put_line('-------------------------------------------');
1223: END IF;
1224: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232
1225: END IF;
1226: load_mtl_interfaces ('Direct Transfer', wdd_rec, l_header_id, p_delivery_id);

Line 1234: IF (g_asn_debug = 'Y') THEN

1230: process_txn(l_header_id, l_INVTM_status);
1231:
1232: IF (l_INVTM_status = 'S') THEN
1233: COMMIT;
1234: IF (g_asn_debug = 'Y') THEN
1235: asn_debug.put_line ('Direct Transfer processed successfully');
1236: END IF;
1237: ELSE
1238: ROLLBACK TO SP_IOT;

Line 1235: asn_debug.put_line ('Direct Transfer processed successfully');

1231:
1232: IF (l_INVTM_status = 'S') THEN
1233: COMMIT;
1234: IF (g_asn_debug = 'Y') THEN
1235: asn_debug.put_line ('Direct Transfer processed successfully');
1236: END IF;
1237: ELSE
1238: ROLLBACK TO SP_IOT;
1239: l_case_3_status := l_INVTM_status;

Line 1242: asn_debug.put_line(' l_case_3_status => ' || l_case_3_status);

1238: ROLLBACK TO SP_IOT;
1239: l_case_3_status := l_INVTM_status;
1240: END IF;
1241: END IF;
1242: asn_debug.put_line(' l_case_3_status => ' || l_case_3_status);
1243: --
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: IF (g_asn_debug = 'Y') THEN

Line 1246: IF (g_asn_debug = 'Y') THEN

1242: asn_debug.put_line(' l_case_3_status => ' || l_case_3_status);
1243: --
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: IF (g_asn_debug = 'Y') THEN
1247: asn_debug.put_line ('Case3 Unexpected exception : ' || SQLERRM);
1248: END IF;
1249: l_case_3_status := 'E';
1250: ROLLBACK;

Line 1247: asn_debug.put_line ('Case3 Unexpected exception : ' || SQLERRM);

1243: --
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: IF (g_asn_debug = 'Y') THEN
1247: asn_debug.put_line ('Case3 Unexpected exception : ' || SQLERRM);
1248: END IF;
1249: l_case_3_status := 'E';
1250: ROLLBACK;
1251: END;

Line 1262: IF (g_asn_debug = 'Y') THEN

1258: l_RCVTM_status := NULL;
1259:
1260: FOR wdd_rec IN wdd_cursor_4 LOOP
1261: IF ( l_group_id IS NULL) THEN
1262: IF (g_asn_debug = 'Y') THEN
1263: asn_debug.put_line('-------------------------------------------');
1264: asn_debug.put_line(' Processing Returns after Direct txr');
1265: asn_debug.put_line('-------------------------------------------');
1266: END IF;

Line 1263: asn_debug.put_line('-------------------------------------------');

1259:
1260: FOR wdd_rec IN wdd_cursor_4 LOOP
1261: IF ( l_group_id IS NULL) THEN
1262: IF (g_asn_debug = 'Y') THEN
1263: asn_debug.put_line('-------------------------------------------');
1264: asn_debug.put_line(' Processing Returns after Direct txr');
1265: asn_debug.put_line('-------------------------------------------');
1266: END IF;
1267: SELECT rcv_interface_groups_s.nextval INTO l_group_id FROM DUAL; -- Bug 11831232

Line 1264: asn_debug.put_line(' Processing Returns after Direct txr');

1260: FOR wdd_rec IN wdd_cursor_4 LOOP
1261: IF ( l_group_id IS NULL) THEN
1262: IF (g_asn_debug = 'Y') THEN
1263: asn_debug.put_line('-------------------------------------------');
1264: asn_debug.put_line(' Processing Returns after Direct txr');
1265: asn_debug.put_line('-------------------------------------------');
1266: END IF;
1267: SELECT rcv_interface_groups_s.nextval INTO l_group_id FROM DUAL; -- Bug 11831232
1268: END IF;

Line 1265: asn_debug.put_line('-------------------------------------------');

1261: IF ( l_group_id IS NULL) THEN
1262: IF (g_asn_debug = 'Y') THEN
1263: asn_debug.put_line('-------------------------------------------');
1264: asn_debug.put_line(' Processing Returns after Direct txr');
1265: asn_debug.put_line('-------------------------------------------');
1266: END IF;
1267: SELECT rcv_interface_groups_s.nextval INTO l_group_id FROM DUAL; -- Bug 11831232
1268: END IF;
1269: load_rcv_interfaces (p_delivery_id, wdd_rec,l_group_id);

Line 1278: IF (g_asn_debug = 'Y') THEN

1274: invoke_rtp (l_group_id, l_RCVTM_status);
1275:
1276: IF (l_RCVTM_status = 'S') THEN
1277: perform_post_TM_updates ('RCV', p_delivery_id);
1278: IF (g_asn_debug = 'Y') THEN
1279: asn_debug.put_line ('Returns after Direct txr processed successfully');
1280: END IF;
1281: ELSE
1282: --RTV2 rtv project phase 2 : start

Line 1279: asn_debug.put_line ('Returns after Direct txr processed successfully');

1275:
1276: IF (l_RCVTM_status = 'S') THEN
1277: perform_post_TM_updates ('RCV', p_delivery_id);
1278: IF (g_asn_debug = 'Y') THEN
1279: asn_debug.put_line ('Returns after Direct txr processed successfully');
1280: END IF;
1281: ELSE
1282: --RTV2 rtv project phase 2 : start
1283: FOR wdd_rec IN wdd_cursor_4 LOOP

Line 1292: asn_debug.put_line(' l_case_4_status => ' || l_case_4_status);

1288: l_case_4_status := l_RCVTM_status;
1289: END IF;
1290: COMMIT;
1291: END IF;
1292: asn_debug.put_line(' l_case_4_status => ' || l_case_4_status);
1293: EXCEPTION
1294: WHEN OTHERS THEN
1295: IF (g_asn_debug = 'Y') THEN
1296: asn_debug.put_line ('Case4 Unexpected exception : ' || SQLERRM);

Line 1295: IF (g_asn_debug = 'Y') THEN

1291: END IF;
1292: asn_debug.put_line(' l_case_4_status => ' || l_case_4_status);
1293: EXCEPTION
1294: WHEN OTHERS THEN
1295: IF (g_asn_debug = 'Y') THEN
1296: asn_debug.put_line ('Case4 Unexpected exception : ' || SQLERRM);
1297: END IF;
1298: l_case_4_status := 'E';
1299: ROLLBACK;

Line 1296: asn_debug.put_line ('Case4 Unexpected exception : ' || SQLERRM);

1292: asn_debug.put_line(' l_case_4_status => ' || l_case_4_status);
1293: EXCEPTION
1294: WHEN OTHERS THEN
1295: IF (g_asn_debug = 'Y') THEN
1296: asn_debug.put_line ('Case4 Unexpected exception : ' || SQLERRM);
1297: END IF;
1298: l_case_4_status := 'E';
1299: ROLLBACK;
1300: END;

Line 1305: IF (g_asn_debug = 'Y') THEN

1301: ----------------------------------------- Set WDDs as interfaced ---------------------------
1302:
1303: BEGIN
1304: --
1305: IF (g_asn_debug = 'Y') THEN
1306: asn_debug.put_line('-------------------------------------------');
1307: asn_debug.put_line(' Checking for completely processed WDDs');
1308: asn_debug.put_line('-------------------------------------------');
1309: END IF;

Line 1306: asn_debug.put_line('-------------------------------------------');

1302:
1303: BEGIN
1304: --
1305: IF (g_asn_debug = 'Y') THEN
1306: asn_debug.put_line('-------------------------------------------');
1307: asn_debug.put_line(' Checking for completely processed WDDs');
1308: asn_debug.put_line('-------------------------------------------');
1309: END IF;
1310: --

Line 1307: asn_debug.put_line(' Checking for completely processed WDDs');

1303: BEGIN
1304: --
1305: IF (g_asn_debug = 'Y') THEN
1306: asn_debug.put_line('-------------------------------------------');
1307: asn_debug.put_line(' Checking for completely processed WDDs');
1308: asn_debug.put_line('-------------------------------------------');
1309: END IF;
1310: --
1311: asn_debug.put_line('Picking RT interfaced WDDs');

Line 1308: asn_debug.put_line('-------------------------------------------');

1304: --
1305: IF (g_asn_debug = 'Y') THEN
1306: asn_debug.put_line('-------------------------------------------');
1307: asn_debug.put_line(' Checking for completely processed WDDs');
1308: asn_debug.put_line('-------------------------------------------');
1309: END IF;
1310: --
1311: asn_debug.put_line('Picking RT interfaced WDDs');
1312:

Line 1311: asn_debug.put_line('Picking RT interfaced WDDs');

1307: asn_debug.put_line(' Checking for completely processed WDDs');
1308: asn_debug.put_line('-------------------------------------------');
1309: END IF;
1310: --
1311: asn_debug.put_line('Picking RT interfaced WDDs');
1312:
1313: FOR wdd_rec IN wdd_cursor_5 LOOP
1314: l_index := l_index + 1;
1315: l_detail_rows(l_index) := (wdd_rec.delivery_detail_id);

Line 1317: IF (g_asn_debug = 'Y') THEN

1313: FOR wdd_rec IN wdd_cursor_5 LOOP
1314: l_index := l_index + 1;
1315: l_detail_rows(l_index) := (wdd_rec.delivery_detail_id);
1316:
1317: IF (g_asn_debug = 'Y') THEN
1318: asn_debug.put_line('l_detail_rows(' || l_index || ') => ' || l_detail_rows(l_index));
1319: END IF;
1320: END LOOP;
1321: --

Line 1318: asn_debug.put_line('l_detail_rows(' || l_index || ') => ' || l_detail_rows(l_index));

1314: l_index := l_index + 1;
1315: l_detail_rows(l_index) := (wdd_rec.delivery_detail_id);
1316:
1317: IF (g_asn_debug = 'Y') THEN
1318: asn_debug.put_line('l_detail_rows(' || l_index || ') => ' || l_detail_rows(l_index));
1319: END IF;
1320: END LOOP;
1321: --
1322: asn_debug.put_line('Picking MMT interfaced WDDs');

Line 1322: asn_debug.put_line('Picking MMT interfaced WDDs');

1318: asn_debug.put_line('l_detail_rows(' || l_index || ') => ' || l_detail_rows(l_index));
1319: END IF;
1320: END LOOP;
1321: --
1322: asn_debug.put_line('Picking MMT interfaced WDDs');
1323:
1324: FOR wdd_rec IN wdd_cursor_6 LOOP
1325: l_index := l_index + 1;
1326: l_detail_rows(l_index) := (wdd_rec.delivery_detail_id);

Line 1328: IF (g_asn_debug = 'Y') THEN

1324: FOR wdd_rec IN wdd_cursor_6 LOOP
1325: l_index := l_index + 1;
1326: l_detail_rows(l_index) := (wdd_rec.delivery_detail_id);
1327:
1328: IF (g_asn_debug = 'Y') THEN
1329: asn_debug.put_line('l_detail_rows(' || l_index || ') => ' || l_detail_rows(l_index));
1330: END IF;
1331: END LOOP;
1332: --

Line 1329: asn_debug.put_line('l_detail_rows(' || l_index || ') => ' || l_detail_rows(l_index));

1325: l_index := l_index + 1;
1326: l_detail_rows(l_index) := (wdd_rec.delivery_detail_id);
1327:
1328: IF (g_asn_debug = 'Y') THEN
1329: asn_debug.put_line('l_detail_rows(' || l_index || ') => ' || l_detail_rows(l_index));
1330: END IF;
1331: END LOOP;
1332: --
1333: IF (l_index > 0) THEN

Line 1338: IF (g_asn_debug = 'Y') THEN

1334: WSH_INTEGRATION.update_delivery_details
1335: ( p_detail_rows => l_detail_rows,
1336: x_return_status => l_return_status);
1337:
1338: IF (g_asn_debug = 'Y') THEN
1339: asn_debug.put_line('l_return_status => ' || l_return_status);
1340: END IF;
1341: END IF;
1342:

Line 1339: asn_debug.put_line('l_return_status => ' || l_return_status);

1335: ( p_detail_rows => l_detail_rows,
1336: x_return_status => l_return_status);
1337:
1338: IF (g_asn_debug = 'Y') THEN
1339: asn_debug.put_line('l_return_status => ' || l_return_status);
1340: END IF;
1341: END IF;
1342:
1343: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 1349: asn_debug.put_line(' l_case_5_status => ' || l_case_5_status);

1345: ELSE
1346: COMMIT;
1347: END IF;
1348:
1349: asn_debug.put_line(' l_case_5_status => ' || l_case_5_status);
1350: --
1351: IF (l_case_1_status = 'S' AND l_case_2_status = 'S' AND l_case_3_status = 'S' AND l_case_4_status = 'S' AND l_case_5_status = 'S') THEN
1352: p_return_status := 'S';
1353: ELSE

Line 1357: IF (g_asn_debug = 'Y') THEN

1353: ELSE
1354: p_return_status := 'E';
1355: END IF;
1356:
1357: IF (g_asn_debug = 'Y') THEN
1358: asn_debug.put_line('Leaving interface_to_rcv : p_delivery_id => ' || p_delivery_id || ', p_return_status => ' || p_return_status);
1359: END IF;
1360:
1361: EXCEPTION

Line 1358: asn_debug.put_line('Leaving interface_to_rcv : p_delivery_id => ' || p_delivery_id || ', p_return_status => ' || p_return_status);

1354: p_return_status := 'E';
1355: END IF;
1356:
1357: IF (g_asn_debug = 'Y') THEN
1358: asn_debug.put_line('Leaving interface_to_rcv : p_delivery_id => ' || p_delivery_id || ', p_return_status => ' || p_return_status);
1359: END IF;
1360:
1361: EXCEPTION
1362: WHEN OTHERS THEN

Line 1363: IF (g_asn_debug = 'Y') THEN

1359: END IF;
1360:
1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: IF (g_asn_debug = 'Y') THEN
1364: asn_debug.put_line ('Case5 Unexpected exception : ' || SQLERRM);
1365: END IF;
1366: p_return_status := 'E';
1367: ROLLBACK;

Line 1364: asn_debug.put_line ('Case5 Unexpected exception : ' || SQLERRM);

1360:
1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: IF (g_asn_debug = 'Y') THEN
1364: asn_debug.put_line ('Case5 Unexpected exception : ' || SQLERRM);
1365: END IF;
1366: p_return_status := 'E';
1367: ROLLBACK;
1368: END;

Line 1411: asn_debug.put_line('Inside invoke_RTP');

1407: l_str VARCHAR2(4000) := NULL;
1408:
1409: BEGIN
1410:
1411: asn_debug.put_line('Inside invoke_RTP');
1412:
1413: SELECT COUNT(*)
1414: INTO l_rcv_count
1415: FROM rcv_transactions_interface

Line 1417: asn_debug.put_line('RTI record count for group_id ' || p_group_id || ' : ' || l_rcv_count);

1413: SELECT COUNT(*)
1414: INTO l_rcv_count
1415: FROM rcv_transactions_interface
1416: WHERE group_id = p_group_id;
1417: asn_debug.put_line('RTI record count for group_id ' || p_group_id || ' : ' || l_rcv_count);
1418:
1419: l_status := fnd_transaction.synchronous
1420: ( l_timeout, l_outcome, l_msg, 'PO', 'RCVTPO', 'ONLINE', p_group_id,
1421: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 1428: asn_debug.put_line('RT record count for group_id ' || p_group_id || ' : ' || l_rcv_count);

1424: SELECT COUNT(*)
1425: INTO l_rcv_count
1426: FROM rcv_transactions
1427: WHERE group_id = p_group_id;
1428: asn_debug.put_line('RT record count for group_id ' || p_group_id || ' : ' || l_rcv_count);
1429:
1430: IF (l_status = 0 and (l_outcome NOT IN ('WARNING', 'ERROR'))) THEN
1431: p_return_status := 'S';
1432: IF (g_asn_debug = 'Y') THEN

Line 1432: IF (g_asn_debug = 'Y') THEN

1428: asn_debug.put_line('RT record count for group_id ' || p_group_id || ' : ' || l_rcv_count);
1429:
1430: IF (l_status = 0 and (l_outcome NOT IN ('WARNING', 'ERROR'))) THEN
1431: p_return_status := 'S';
1432: IF (g_asn_debug = 'Y') THEN
1433: asn_debug.put_line('RCV transaction processed successfully');
1434: END IF;
1435:
1436: ELSIF (l_status = 1) THEN

Line 1433: asn_debug.put_line('RCV transaction processed successfully');

1429:
1430: IF (l_status = 0 and (l_outcome NOT IN ('WARNING', 'ERROR'))) THEN
1431: p_return_status := 'S';
1432: IF (g_asn_debug = 'Y') THEN
1433: asn_debug.put_line('RCV transaction processed successfully');
1434: END IF;
1435:
1436: ELSIF (l_status = 1) THEN
1437: p_return_status := 'E';

Line 1438: IF (g_asn_debug = 'Y') THEN

1434: END IF;
1435:
1436: ELSIF (l_status = 1) THEN
1437: p_return_status := 'E';
1438: IF (g_asn_debug = 'Y') THEN
1439: asn_debug.put_line('RCVTM timeout!');
1440: END IF;
1441:
1442: ELSIF (l_status = 2) THEN

Line 1439: asn_debug.put_line('RCVTM timeout!');

1435:
1436: ELSIF (l_status = 1) THEN
1437: p_return_status := 'E';
1438: IF (g_asn_debug = 'Y') THEN
1439: asn_debug.put_line('RCVTM timeout!');
1440: END IF;
1441:
1442: ELSIF (l_status = 2) THEN
1443: p_return_status := 'E';

Line 1444: IF (g_asn_debug = 'Y') THEN

1440: END IF;
1441:
1442: ELSIF (l_status = 2) THEN
1443: p_return_status := 'E';
1444: IF (g_asn_debug = 'Y') THEN
1445: asn_debug.put_line('RCV Manager not available!');
1446: END IF;
1447:
1448: ELSIF (l_status = 3 or (l_outcome IN ('WARNING', 'ERROR'))) THEN

Line 1445: asn_debug.put_line('RCV Manager not available!');

1441:
1442: ELSIF (l_status = 2) THEN
1443: p_return_status := 'E';
1444: IF (g_asn_debug = 'Y') THEN
1445: asn_debug.put_line('RCV Manager not available!');
1446: END IF;
1447:
1448: ELSIF (l_status = 3 or (l_outcome IN ('WARNING', 'ERROR'))) THEN
1449: p_return_status := 'E';

Line 1450: IF (g_asn_debug = 'Y') THEN

1446: END IF;
1447:
1448: ELSIF (l_status = 3 or (l_outcome IN ('WARNING', 'ERROR'))) THEN
1449: p_return_status := 'E';
1450: IF (g_asn_debug = 'Y') THEN
1451: asn_debug.put_line('RCV Manager failed!');
1452: END IF;
1453: l_status := fnd_transaction.get_values
1454: ( l_msg01, l_msg02, l_msg03, l_msg04, l_msg05,

Line 1451: asn_debug.put_line('RCV Manager failed!');

1447:
1448: ELSIF (l_status = 3 or (l_outcome IN ('WARNING', 'ERROR'))) THEN
1449: p_return_status := 'E';
1450: IF (g_asn_debug = 'Y') THEN
1451: asn_debug.put_line('RCV Manager failed!');
1452: END IF;
1453: l_status := fnd_transaction.get_values
1454: ( l_msg01, l_msg02, l_msg03, l_msg04, l_msg05,
1455: l_msg06, l_msg07, l_msg08, l_msg09, l_msg10,

Line 1480: IF (g_asn_debug = 'Y') THEN

1476: IF (l_msg18 IS NOT NULL) THEN l_str := l_str || ' ' || l_msg18; END IF;
1477: IF (l_msg19 IS NOT NULL) THEN l_str := l_str || ' ' || l_msg19; END IF;
1478: IF (l_msg20 IS NOT NULL) THEN l_str := l_str || ' ' || l_msg20; END IF;
1479:
1480: IF (g_asn_debug = 'Y') THEN
1481: asn_debug.put_line('Error is : ' || l_str);
1482: END IF;
1483: END IF;
1484:

Line 1481: asn_debug.put_line('Error is : ' || l_str);

1477: IF (l_msg19 IS NOT NULL) THEN l_str := l_str || ' ' || l_msg19; END IF;
1478: IF (l_msg20 IS NOT NULL) THEN l_str := l_str || ' ' || l_msg20; END IF;
1479:
1480: IF (g_asn_debug = 'Y') THEN
1481: asn_debug.put_line('Error is : ' || l_str);
1482: END IF;
1483: END IF;
1484:
1485: asn_debug.put_line('Leaving invoke_RTP');

Line 1485: asn_debug.put_line('Leaving invoke_RTP');

1481: asn_debug.put_line('Error is : ' || l_str);
1482: END IF;
1483: END IF;
1484:
1485: asn_debug.put_line('Leaving invoke_RTP');
1486:
1487: EXCEPTION
1488: WHEN OTHERS THEN
1489: p_return_status := 'E';

Line 1490: IF (g_asn_debug = 'Y') THEN

1486:
1487: EXCEPTION
1488: WHEN OTHERS THEN
1489: p_return_status := 'E';
1490: IF (g_asn_debug = 'Y') THEN
1491: asn_debug.put_line ('Case3 Unexpected exception from invoke_RTP: ' || SQLERRM);
1492: END IF;
1493: END invoke_RTP;
1494:

Line 1491: asn_debug.put_line ('Case3 Unexpected exception from invoke_RTP: ' || SQLERRM);

1487: EXCEPTION
1488: WHEN OTHERS THEN
1489: p_return_status := 'E';
1490: IF (g_asn_debug = 'Y') THEN
1491: asn_debug.put_line ('Case3 Unexpected exception from invoke_RTP: ' || SQLERRM);
1492: END IF;
1493: END invoke_RTP;
1494:
1495: /*===========================================================================

Line 1530: IF (g_asn_debug = 'Y') THEN

1526: raise e_INVTM_error;
1527: END IF;
1528:
1529: p_return_status := 'S';
1530: IF (g_asn_debug = 'Y') THEN
1531: asn_debug.put_line('INV transaction processed successfully');
1532: END IF;
1533:
1534: EXCEPTION

Line 1531: asn_debug.put_line('INV transaction processed successfully');

1527: END IF;
1528:
1529: p_return_status := 'S';
1530: IF (g_asn_debug = 'Y') THEN
1531: asn_debug.put_line('INV transaction processed successfully');
1532: END IF;
1533:
1534: EXCEPTION
1535: WHEN e_INVTM_error THEN

Line 1536: IF (g_asn_debug = 'Y') THEN

1532: END IF;
1533:
1534: EXCEPTION
1535: WHEN e_INVTM_error THEN
1536: IF (g_asn_debug = 'Y') THEN
1537: asn_debug.put_line('INV transaction failed');
1538: asn_debug.put_line('l_msg_count : ' || l_msg_count);
1539: asn_debug.put_line('l_msg_data : ' || l_msg_data);
1540: END IF;

Line 1537: asn_debug.put_line('INV transaction failed');

1533:
1534: EXCEPTION
1535: WHEN e_INVTM_error THEN
1536: IF (g_asn_debug = 'Y') THEN
1537: asn_debug.put_line('INV transaction failed');
1538: asn_debug.put_line('l_msg_count : ' || l_msg_count);
1539: asn_debug.put_line('l_msg_data : ' || l_msg_data);
1540: END IF;
1541: p_return_status := 'E';

Line 1538: asn_debug.put_line('l_msg_count : ' || l_msg_count);

1534: EXCEPTION
1535: WHEN e_INVTM_error THEN
1536: IF (g_asn_debug = 'Y') THEN
1537: asn_debug.put_line('INV transaction failed');
1538: asn_debug.put_line('l_msg_count : ' || l_msg_count);
1539: asn_debug.put_line('l_msg_data : ' || l_msg_data);
1540: END IF;
1541: p_return_status := 'E';
1542:

Line 1539: asn_debug.put_line('l_msg_data : ' || l_msg_data);

1535: WHEN e_INVTM_error THEN
1536: IF (g_asn_debug = 'Y') THEN
1537: asn_debug.put_line('INV transaction failed');
1538: asn_debug.put_line('l_msg_count : ' || l_msg_count);
1539: asn_debug.put_line('l_msg_data : ' || l_msg_data);
1540: END IF;
1541: p_return_status := 'E';
1542:
1543: WHEN OTHERS THEN

Line 1544: IF (g_asn_debug = 'Y') THEN

1540: END IF;
1541: p_return_status := 'E';
1542:
1543: WHEN OTHERS THEN
1544: IF (g_asn_debug = 'Y') THEN
1545: asn_debug.put_line ('Unexpected exception in process_txn: ' || SQLERRM);
1546: END IF;
1547: p_return_status := 'E';
1548: END process_txn;

Line 1545: asn_debug.put_line ('Unexpected exception in process_txn: ' || SQLERRM);

1541: p_return_status := 'E';
1542:
1543: WHEN OTHERS THEN
1544: IF (g_asn_debug = 'Y') THEN
1545: asn_debug.put_line ('Unexpected exception in process_txn: ' || SQLERRM);
1546: END IF;
1547: p_return_status := 'E';
1548: END process_txn;
1549:

Line 1588: IF (g_asn_debug = 'Y') THEN

1584: --RTV2 rtv project phase 2 : end
1585:
1586: BEGIN
1587:
1588: IF (g_asn_debug = 'Y') THEN
1589: asn_debug.put_line('Entering load_mtl_interfaces');
1590: asn_debug.put_line('p_txn_desc : ' || p_txn_desc);
1591: END IF;
1592:

Line 1589: asn_debug.put_line('Entering load_mtl_interfaces');

1585:
1586: BEGIN
1587:
1588: IF (g_asn_debug = 'Y') THEN
1589: asn_debug.put_line('Entering load_mtl_interfaces');
1590: asn_debug.put_line('p_txn_desc : ' || p_txn_desc);
1591: END IF;
1592:
1593: --RTV2 rtv project phase 2 : start

Line 1590: asn_debug.put_line('p_txn_desc : ' || p_txn_desc);

1586: BEGIN
1587:
1588: IF (g_asn_debug = 'Y') THEN
1589: asn_debug.put_line('Entering load_mtl_interfaces');
1590: asn_debug.put_line('p_txn_desc : ' || p_txn_desc);
1591: END IF;
1592:
1593: --RTV2 rtv project phase 2 : start
1594: l_lpn_id := get_return_lpn_id(p_wdd_rec.delivery_detail_id);

Line 1609: IF (g_asn_debug = 'Y') THEN

1605: AND rti.interface_transaction_id = p_wdd_rec.source_line_id
1606: AND rt.transaction_type = 'DELIVER'
1607: AND mp.organization_id = rt.organization_id;
1608:
1609: IF (g_asn_debug = 'Y') THEN
1610: asn_debug.put_line('l_deliver_subinv : ' || l_deliver_subinv);
1611: asn_debug.put_line('l_deliver_locator : ' || l_deliver_locator);
1612: asn_debug.put_line('l_receipt_org : ' || l_receipt_org);
1613: asn_debug.put_line('l_wms_rec_org : ' || l_wms_rec_org);

Line 1610: asn_debug.put_line('l_deliver_subinv : ' || l_deliver_subinv);

1606: AND rt.transaction_type = 'DELIVER'
1607: AND mp.organization_id = rt.organization_id;
1608:
1609: IF (g_asn_debug = 'Y') THEN
1610: asn_debug.put_line('l_deliver_subinv : ' || l_deliver_subinv);
1611: asn_debug.put_line('l_deliver_locator : ' || l_deliver_locator);
1612: asn_debug.put_line('l_receipt_org : ' || l_receipt_org);
1613: asn_debug.put_line('l_wms_rec_org : ' || l_wms_rec_org);
1614: END IF;

Line 1611: asn_debug.put_line('l_deliver_locator : ' || l_deliver_locator);

1607: AND mp.organization_id = rt.organization_id;
1608:
1609: IF (g_asn_debug = 'Y') THEN
1610: asn_debug.put_line('l_deliver_subinv : ' || l_deliver_subinv);
1611: asn_debug.put_line('l_deliver_locator : ' || l_deliver_locator);
1612: asn_debug.put_line('l_receipt_org : ' || l_receipt_org);
1613: asn_debug.put_line('l_wms_rec_org : ' || l_wms_rec_org);
1614: END IF;
1615:

Line 1612: asn_debug.put_line('l_receipt_org : ' || l_receipt_org);

1608:
1609: IF (g_asn_debug = 'Y') THEN
1610: asn_debug.put_line('l_deliver_subinv : ' || l_deliver_subinv);
1611: asn_debug.put_line('l_deliver_locator : ' || l_deliver_locator);
1612: asn_debug.put_line('l_receipt_org : ' || l_receipt_org);
1613: asn_debug.put_line('l_wms_rec_org : ' || l_wms_rec_org);
1614: END IF;
1615:
1616: IF(nvl(l_wms_rec_org, 'N') = 'N') THEN

Line 1613: asn_debug.put_line('l_wms_rec_org : ' || l_wms_rec_org);

1609: IF (g_asn_debug = 'Y') THEN
1610: asn_debug.put_line('l_deliver_subinv : ' || l_deliver_subinv);
1611: asn_debug.put_line('l_deliver_locator : ' || l_deliver_locator);
1612: asn_debug.put_line('l_receipt_org : ' || l_receipt_org);
1613: asn_debug.put_line('l_wms_rec_org : ' || l_wms_rec_org);
1614: END IF;
1615:
1616: IF(nvl(l_wms_rec_org, 'N') = 'N') THEN
1617: l_transfer_lpn_id := NULL;

Line 1631: IF (g_asn_debug = 'Y') THEN

1627: INTO l_account_id
1628: FROM mtl_parameters
1629: WHERE organization_id = p_wdd_rec.organization_id;
1630:
1631: IF (g_asn_debug = 'Y') THEN
1632: asn_debug.put_line('l_account_id : ' || l_account_id);
1633: END IF;
1634:
1635: IF (l_account_id IS NULL) THEN

Line 1632: asn_debug.put_line('l_account_id : ' || l_account_id);

1628: FROM mtl_parameters
1629: WHERE organization_id = p_wdd_rec.organization_id;
1630:
1631: IF (g_asn_debug = 'Y') THEN
1632: asn_debug.put_line('l_account_id : ' || l_account_id);
1633: END IF;
1634:
1635: IF (l_account_id IS NULL) THEN
1636: raise fnd_api.g_exc_unexpected_error;

Line 1644: IF (g_asn_debug = 'Y') THEN

1640: INTO l_functional_currency, l_ou_id
1641: FROM cst_organization_definitions
1642: WHERE organization_id = p_wdd_rec.organization_id;
1643:
1644: IF (g_asn_debug = 'Y') THEN
1645: asn_debug.put_line('l_functional_currency : ' || l_functional_currency);
1646: END IF;
1647:
1648: IF (p_wdd_rec.currency_code IS NOT NULL AND p_wdd_rec.currency_code <> l_functional_currency) THEN

Line 1645: asn_debug.put_line('l_functional_currency : ' || l_functional_currency);

1641: FROM cst_organization_definitions
1642: WHERE organization_id = p_wdd_rec.organization_id;
1643:
1644: IF (g_asn_debug = 'Y') THEN
1645: asn_debug.put_line('l_functional_currency : ' || l_functional_currency);
1646: END IF;
1647:
1648: IF (p_wdd_rec.currency_code IS NOT NULL AND p_wdd_rec.currency_code <> l_functional_currency) THEN
1649: l_txn_cost := inv_transaction_flow_pub.convert_currency

Line 1664: IF (g_asn_debug = 'Y') THEN

1660: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1661: raise fnd_api.g_exc_unexpected_error;
1662: END IF;
1663: END IF;
1664: IF (g_asn_debug = 'Y') THEN
1665: asn_debug.put_line('l_functional_currency : ' || l_functional_currency);
1666: asn_debug.put_line('l_txn_cost : ' || l_txn_cost);
1667: END IF;
1668: --

Line 1665: asn_debug.put_line('l_functional_currency : ' || l_functional_currency);

1661: raise fnd_api.g_exc_unexpected_error;
1662: END IF;
1663: END IF;
1664: IF (g_asn_debug = 'Y') THEN
1665: asn_debug.put_line('l_functional_currency : ' || l_functional_currency);
1666: asn_debug.put_line('l_txn_cost : ' || l_txn_cost);
1667: END IF;
1668: --
1669: ELSE

Line 1666: asn_debug.put_line('l_txn_cost : ' || l_txn_cost);

1662: END IF;
1663: END IF;
1664: IF (g_asn_debug = 'Y') THEN
1665: asn_debug.put_line('l_functional_currency : ' || l_functional_currency);
1666: asn_debug.put_line('l_txn_cost : ' || l_txn_cost);
1667: END IF;
1668: --
1669: ELSE
1670: RETURN;

Line 1673: IF (g_asn_debug = 'Y') THEN

1669: ELSE
1670: RETURN;
1671: END IF;
1672: --RTV2 rtv project phase 2 : start
1673: IF (g_asn_debug = 'Y') THEN
1674: asn_debug.put_line('l_lpn_id : ' || l_lpn_id);
1675: asn_debug.put_line('l_transfer_lpn_id : ' || l_transfer_lpn_id);
1676: END IF;
1677: --RTV2 rtv project phase 2 : end

Line 1674: asn_debug.put_line('l_lpn_id : ' || l_lpn_id);

1670: RETURN;
1671: END IF;
1672: --RTV2 rtv project phase 2 : start
1673: IF (g_asn_debug = 'Y') THEN
1674: asn_debug.put_line('l_lpn_id : ' || l_lpn_id);
1675: asn_debug.put_line('l_transfer_lpn_id : ' || l_transfer_lpn_id);
1676: END IF;
1677: --RTV2 rtv project phase 2 : end
1678:

Line 1675: asn_debug.put_line('l_transfer_lpn_id : ' || l_transfer_lpn_id);

1671: END IF;
1672: --RTV2 rtv project phase 2 : start
1673: IF (g_asn_debug = 'Y') THEN
1674: asn_debug.put_line('l_lpn_id : ' || l_lpn_id);
1675: asn_debug.put_line('l_transfer_lpn_id : ' || l_transfer_lpn_id);
1676: END IF;
1677: --RTV2 rtv project phase 2 : end
1678:
1679: --

Line 1779: IF (g_asn_debug = 'Y') THEN

1775: l_transfer_lpn_id, -- RTV2 rtv project phase 2
1776: l_transfer_lpn_id -- RTV2 rtv project phase 2
1777: FROM DUAL;
1778:
1779: IF (g_asn_debug = 'Y') THEN
1780: asn_debug.put_line('Inserted MTI with transaction_interface_id : ' || l_temp_id);
1781: END IF;
1782:
1783: load_lot_serial_interfaces ('INV', p_wdd_rec, l_temp_id);

Line 1780: asn_debug.put_line('Inserted MTI with transaction_interface_id : ' || l_temp_id);

1776: l_transfer_lpn_id -- RTV2 rtv project phase 2
1777: FROM DUAL;
1778:
1779: IF (g_asn_debug = 'Y') THEN
1780: asn_debug.put_line('Inserted MTI with transaction_interface_id : ' || l_temp_id);
1781: END IF;
1782:
1783: load_lot_serial_interfaces ('INV', p_wdd_rec, l_temp_id);
1784:

Line 1796: IF (g_asn_debug = 'Y') THEN

1792: raise fnd_api.g_exc_unexpected_error;
1793: END IF;
1794: --RTV2 rtv project phase 2 : end
1795:
1796: IF (g_asn_debug = 'Y') THEN
1797: asn_debug.put_line('Leaving load_mtl_interfaces');
1798: END IF;
1799:
1800: EXCEPTION

Line 1797: asn_debug.put_line('Leaving load_mtl_interfaces');

1793: END IF;
1794: --RTV2 rtv project phase 2 : end
1795:
1796: IF (g_asn_debug = 'Y') THEN
1797: asn_debug.put_line('Leaving load_mtl_interfaces');
1798: END IF;
1799:
1800: EXCEPTION
1801: WHEN OTHERS THEN

Line 1802: IF (g_asn_debug = 'Y') THEN

1798: END IF;
1799:
1800: EXCEPTION
1801: WHEN OTHERS THEN
1802: IF (g_asn_debug = 'Y') THEN
1803: asn_debug.put_line('Unexpected exception in load_mtl_interfaces : ' || SQLERRM);
1804: raise;
1805: END IF;
1806:

Line 1803: asn_debug.put_line('Unexpected exception in load_mtl_interfaces : ' || SQLERRM);

1799:
1800: EXCEPTION
1801: WHEN OTHERS THEN
1802: IF (g_asn_debug = 'Y') THEN
1803: asn_debug.put_line('Unexpected exception in load_mtl_interfaces : ' || SQLERRM);
1804: raise;
1805: END IF;
1806:
1807: END load_mtl_interfaces;

Line 1839: IF (g_asn_debug = 'Y') THEN

1835: --RTV2 rtv project phase 2 : end
1836:
1837: BEGIN
1838:
1839: IF (g_asn_debug = 'Y') THEN
1840: asn_debug.put_line('Entering load_rcv_interfaces');
1841: END IF;
1842: --
1843: l_shipped_uom := get_uom_from_code (p_wdd_rec.requested_quantity_uom);

Line 1840: asn_debug.put_line('Entering load_rcv_interfaces');

1836:
1837: BEGIN
1838:
1839: IF (g_asn_debug = 'Y') THEN
1840: asn_debug.put_line('Entering load_rcv_interfaces');
1841: END IF;
1842: --
1843: l_shipped_uom := get_uom_from_code (p_wdd_rec.requested_quantity_uom);
1844: l_shipped_uom2 := get_uom_from_code (p_wdd_rec.requested_quantity_uom2);

Line 1846: IF (g_asn_debug = 'Y') THEN

1842: --
1843: l_shipped_uom := get_uom_from_code (p_wdd_rec.requested_quantity_uom);
1844: l_shipped_uom2 := get_uom_from_code (p_wdd_rec.requested_quantity_uom2);
1845:
1846: IF (g_asn_debug = 'Y') THEN
1847: asn_debug.put_line('l_shipped_uom : ' || l_shipped_uom);
1848: asn_debug.put_line('l_shipped_uom2 : ' || l_shipped_uom2);
1849: END IF;
1850: --

Line 1847: asn_debug.put_line('l_shipped_uom : ' || l_shipped_uom);

1843: l_shipped_uom := get_uom_from_code (p_wdd_rec.requested_quantity_uom);
1844: l_shipped_uom2 := get_uom_from_code (p_wdd_rec.requested_quantity_uom2);
1845:
1846: IF (g_asn_debug = 'Y') THEN
1847: asn_debug.put_line('l_shipped_uom : ' || l_shipped_uom);
1848: asn_debug.put_line('l_shipped_uom2 : ' || l_shipped_uom2);
1849: END IF;
1850: --
1851: SELECT *

Line 1848: asn_debug.put_line('l_shipped_uom2 : ' || l_shipped_uom2);

1844: l_shipped_uom2 := get_uom_from_code (p_wdd_rec.requested_quantity_uom2);
1845:
1846: IF (g_asn_debug = 'Y') THEN
1847: asn_debug.put_line('l_shipped_uom : ' || l_shipped_uom);
1848: asn_debug.put_line('l_shipped_uom2 : ' || l_shipped_uom2);
1849: END IF;
1850: --
1851: SELECT *
1852: INTO rti_rec

Line 1856: IF (g_asn_debug = 'Y') THEN

1852: INTO rti_rec
1853: FROM rcv_transactions_interface
1854: WHERE interface_transaction_id = p_wdd_rec.source_line_id;
1855:
1856: IF (g_asn_debug = 'Y') THEN
1857: asn_debug.put_line('rti_rec.primary_unit_of_measure : ' || rti_rec.primary_unit_of_measure);
1858: asn_debug.put_line('rti_rec.to_organization_id : ' || rti_rec.to_organization_id);
1859: END IF;
1860:

Line 1857: asn_debug.put_line('rti_rec.primary_unit_of_measure : ' || rti_rec.primary_unit_of_measure);

1853: FROM rcv_transactions_interface
1854: WHERE interface_transaction_id = p_wdd_rec.source_line_id;
1855:
1856: IF (g_asn_debug = 'Y') THEN
1857: asn_debug.put_line('rti_rec.primary_unit_of_measure : ' || rti_rec.primary_unit_of_measure);
1858: asn_debug.put_line('rti_rec.to_organization_id : ' || rti_rec.to_organization_id);
1859: END IF;
1860:
1861: --RTV2 rtv project phase 2 : start

Line 1858: asn_debug.put_line('rti_rec.to_organization_id : ' || rti_rec.to_organization_id);

1854: WHERE interface_transaction_id = p_wdd_rec.source_line_id;
1855:
1856: IF (g_asn_debug = 'Y') THEN
1857: asn_debug.put_line('rti_rec.primary_unit_of_measure : ' || rti_rec.primary_unit_of_measure);
1858: asn_debug.put_line('rti_rec.to_organization_id : ' || rti_rec.to_organization_id);
1859: END IF;
1860:
1861: --RTV2 rtv project phase 2 : start
1862: IF (rti_rec.transfer_lpn_id IS NOT NULL) THEN

Line 1899: IF (g_asn_debug = 'Y') THEN

1895: ELSE
1896: l_primary_qty := p_wdd_rec.shipped_quantity;
1897: END IF;
1898:
1899: IF (g_asn_debug = 'Y') THEN
1900: asn_debug.put_line('l_primary_qty : ' || l_primary_qty);
1901: END IF;
1902: --
1903: IF (rti_rec.item_revision IS NOT NULL) THEN

Line 1900: asn_debug.put_line('l_primary_qty : ' || l_primary_qty);

1896: l_primary_qty := p_wdd_rec.shipped_quantity;
1897: END IF;
1898:
1899: IF (g_asn_debug = 'Y') THEN
1900: asn_debug.put_line('l_primary_qty : ' || l_primary_qty);
1901: END IF;
1902: --
1903: IF (rti_rec.item_revision IS NOT NULL) THEN
1904: SELECT revision_qty_control_code

Line 1910: IF (g_asn_debug = 'Y') THEN

1906: FROM mtl_system_items msi
1907: WHERE msi.organization_id = rti_rec.to_organization_id
1908: AND msi.inventory_item_id = rti_rec.item_id;
1909:
1910: IF (g_asn_debug = 'Y') THEN
1911: asn_debug.put_line('l_rev_control : ' || l_rev_control);
1912: END IF;
1913:
1914: IF (l_rev_control = 1) THEN

Line 1911: asn_debug.put_line('l_rev_control : ' || l_rev_control);

1907: WHERE msi.organization_id = rti_rec.to_organization_id
1908: AND msi.inventory_item_id = rti_rec.item_id;
1909:
1910: IF (g_asn_debug = 'Y') THEN
1911: asn_debug.put_line('l_rev_control : ' || l_rev_control);
1912: END IF;
1913:
1914: IF (l_rev_control = 1) THEN
1915: rti_rec.item_revision := NULL;

Line 1937: IF (g_asn_debug = 'Y') THEN

1933: END IF;
1934: --RTV2 rtv project phase 2 : end
1935: END IF;
1936: --
1937: IF (g_asn_debug = 'Y') THEN
1938: asn_debug.put_line('l_from_subinventory : ' || l_from_subinventory);
1939: asn_debug.put_line('l_from_locator_id : ' || l_from_locator_id);
1940: END IF;
1941: --

Line 1938: asn_debug.put_line('l_from_subinventory : ' || l_from_subinventory);

1934: --RTV2 rtv project phase 2 : end
1935: END IF;
1936: --
1937: IF (g_asn_debug = 'Y') THEN
1938: asn_debug.put_line('l_from_subinventory : ' || l_from_subinventory);
1939: asn_debug.put_line('l_from_locator_id : ' || l_from_locator_id);
1940: END IF;
1941: --
1942: SELECT wts.actual_departure_date

Line 1939: asn_debug.put_line('l_from_locator_id : ' || l_from_locator_id);

1935: END IF;
1936: --
1937: IF (g_asn_debug = 'Y') THEN
1938: asn_debug.put_line('l_from_subinventory : ' || l_from_subinventory);
1939: asn_debug.put_line('l_from_locator_id : ' || l_from_locator_id);
1940: END IF;
1941: --
1942: SELECT wts.actual_departure_date
1943: INTO l_txn_date

Line 2167: IF (g_asn_debug = 'Y') THEN

2163: rti_rec.unit_landed_cost,
2164: 'Y'
2165: );
2166:
2167: IF (g_asn_debug = 'Y') THEN
2168: asn_debug.put_line('Inserted RTI with transaction_interface_id : ' || l_rti_id);
2169: END IF;
2170: --
2171: load_lot_serial_interfaces ('RCV', p_wdd_rec, l_rti_id);

Line 2168: asn_debug.put_line('Inserted RTI with transaction_interface_id : ' || l_rti_id);

2164: 'Y'
2165: );
2166:
2167: IF (g_asn_debug = 'Y') THEN
2168: asn_debug.put_line('Inserted RTI with transaction_interface_id : ' || l_rti_id);
2169: END IF;
2170: --
2171: load_lot_serial_interfaces ('RCV', p_wdd_rec, l_rti_id);
2172:

Line 2211: IF (g_asn_debug = 'Y') THEN

2207: END IF;
2208: END IF;
2209: --RTV2 rtv project phase 2 : end
2210:
2211: IF (g_asn_debug = 'Y') THEN
2212: asn_debug.put_line('Leaving load_rcv_interfaces');
2213: END IF;
2214:
2215: EXCEPTION

Line 2212: asn_debug.put_line('Leaving load_rcv_interfaces');

2208: END IF;
2209: --RTV2 rtv project phase 2 : end
2210:
2211: IF (g_asn_debug = 'Y') THEN
2212: asn_debug.put_line('Leaving load_rcv_interfaces');
2213: END IF;
2214:
2215: EXCEPTION
2216: WHEN OTHERS THEN

Line 2217: IF (g_asn_debug = 'Y') THEN

2213: END IF;
2214:
2215: EXCEPTION
2216: WHEN OTHERS THEN
2217: IF (g_asn_debug = 'Y') THEN
2218: asn_debug.put_line('Unexpected exception in load_rcv_interfaces : ' || SQLERRM);
2219: raise;
2220: END IF;
2221:

Line 2218: asn_debug.put_line('Unexpected exception in load_rcv_interfaces : ' || SQLERRM);

2214:
2215: EXCEPTION
2216: WHEN OTHERS THEN
2217: IF (g_asn_debug = 'Y') THEN
2218: asn_debug.put_line('Unexpected exception in load_rcv_interfaces : ' || SQLERRM);
2219: raise;
2220: END IF;
2221:
2222: END load_rcv_interfaces;

Line 2254: IF (g_asn_debug = 'Y') THEN

2250: l_rti_item_id NUMBER;
2251:
2252: BEGIN
2253:
2254: IF (g_asn_debug = 'Y') THEN
2255: asn_debug.put_line('Entering load_lot_serial_interfaces : Source => ' || p_source || ' ,parent => ' || p_parent_id);
2256: END IF;
2257:
2258: IF (p_wdd_rec.lot_number IS NULL AND p_wdd_rec.transaction_temp_id IS NULL) THEN

Line 2255: asn_debug.put_line('Entering load_lot_serial_interfaces : Source => ' || p_source || ' ,parent => ' || p_parent_id);

2251:
2252: BEGIN
2253:
2254: IF (g_asn_debug = 'Y') THEN
2255: asn_debug.put_line('Entering load_lot_serial_interfaces : Source => ' || p_source || ' ,parent => ' || p_parent_id);
2256: END IF;
2257:
2258: IF (p_wdd_rec.lot_number IS NULL AND p_wdd_rec.transaction_temp_id IS NULL) THEN
2259: IF (g_asn_debug = 'Y') THEN

Line 2259: IF (g_asn_debug = 'Y') THEN

2255: asn_debug.put_line('Entering load_lot_serial_interfaces : Source => ' || p_source || ' ,parent => ' || p_parent_id);
2256: END IF;
2257:
2258: IF (p_wdd_rec.lot_number IS NULL AND p_wdd_rec.transaction_temp_id IS NULL) THEN
2259: IF (g_asn_debug = 'Y') THEN
2260: asn_debug.put_line('No lot/serial attached to WDD : ' || p_wdd_rec.delivery_detail_id);
2261: END IF;
2262: RETURN;
2263: END IF;

Line 2260: asn_debug.put_line('No lot/serial attached to WDD : ' || p_wdd_rec.delivery_detail_id);

2256: END IF;
2257:
2258: IF (p_wdd_rec.lot_number IS NULL AND p_wdd_rec.transaction_temp_id IS NULL) THEN
2259: IF (g_asn_debug = 'Y') THEN
2260: asn_debug.put_line('No lot/serial attached to WDD : ' || p_wdd_rec.delivery_detail_id);
2261: END IF;
2262: RETURN;
2263: END IF;
2264: --

Line 2277: IF (g_asn_debug = 'Y') THEN

2273: AND rti.interface_transaction_id = p_parent_id;
2274:
2275: l_serial_tagged := inv_cache.get_serial_tagged (l_rti_org_id, l_rti_item_id , 36);
2276:
2277: IF (g_asn_debug = 'Y') THEN
2278: asn_debug.put_line('l_serial_control : ' || l_serial_control || ' ,l_lot_control : ' || l_lot_control || ', l_serial_tagged : ' || l_serial_tagged);
2279: END IF;
2280:
2281: IF (l_lot_control <> 2) THEN

Line 2278: asn_debug.put_line('l_serial_control : ' || l_serial_control || ' ,l_lot_control : ' || l_lot_control || ', l_serial_tagged : ' || l_serial_tagged);

2274:
2275: l_serial_tagged := inv_cache.get_serial_tagged (l_rti_org_id, l_rti_item_id , 36);
2276:
2277: IF (g_asn_debug = 'Y') THEN
2278: asn_debug.put_line('l_serial_control : ' || l_serial_control || ' ,l_lot_control : ' || l_lot_control || ', l_serial_tagged : ' || l_serial_tagged);
2279: END IF;
2280:
2281: IF (l_lot_control <> 2) THEN
2282: l_source_allows_lot := FALSE;

Line 2361: IF (g_asn_debug = 'Y') THEN

2357: AND mtlt.lot_number = p_wdd_rec.lot_number;
2358:
2359: l_lot_inserted := TRUE;
2360:
2361: IF (g_asn_debug = 'Y') THEN
2362: asn_debug.put_line('Inserted MTLI for Lot# : ' || p_wdd_rec.lot_number);
2363: END IF;
2364:
2365: END IF;

Line 2362: asn_debug.put_line('Inserted MTLI for Lot# : ' || p_wdd_rec.lot_number);

2358:
2359: l_lot_inserted := TRUE;
2360:
2361: IF (g_asn_debug = 'Y') THEN
2362: asn_debug.put_line('Inserted MTLI for Lot# : ' || p_wdd_rec.lot_number);
2363: END IF;
2364:
2365: END IF;
2366: --

Line 2557: IF (g_asn_debug = 'Y') THEN

2553: wsn_rec.number_of_repairs
2554: FROM dual;
2555: --
2556: l_serial_inserted := TRUE;
2557: IF (g_asn_debug = 'Y') THEN
2558: asn_debug.put_line('Inserted MSNI : fm_serial_number : ' || wsn_rec.fm_serial_number || ' and to_serial_number : ' || wsn_rec.to_serial_number );
2559: END IF;
2560:
2561: END LOOP;

Line 2558: asn_debug.put_line('Inserted MSNI : fm_serial_number : ' || wsn_rec.fm_serial_number || ' and to_serial_number : ' || wsn_rec.to_serial_number );

2554: FROM dual;
2555: --
2556: l_serial_inserted := TRUE;
2557: IF (g_asn_debug = 'Y') THEN
2558: asn_debug.put_line('Inserted MSNI : fm_serial_number : ' || wsn_rec.fm_serial_number || ' and to_serial_number : ' || wsn_rec.to_serial_number );
2559: END IF;
2560:
2561: END LOOP;
2562: END IF;

Line 2570: IF (g_asn_debug = 'Y') THEN

2566: SET serial_transaction_temp_id = l_serial_temp_id
2567: WHERE transaction_interface_id = l_temp_id;
2568: END IF;
2569: --
2570: IF (g_asn_debug = 'Y') THEN
2571: asn_debug.put_line('Leaving load_lot_serial_interfaces');
2572: END IF;
2573:
2574: EXCEPTION

Line 2571: asn_debug.put_line('Leaving load_lot_serial_interfaces');

2567: WHERE transaction_interface_id = l_temp_id;
2568: END IF;
2569: --
2570: IF (g_asn_debug = 'Y') THEN
2571: asn_debug.put_line('Leaving load_lot_serial_interfaces');
2572: END IF;
2573:
2574: EXCEPTION
2575: WHEN OTHERS THEN

Line 2576: IF (g_asn_debug = 'Y') THEN

2572: END IF;
2573:
2574: EXCEPTION
2575: WHEN OTHERS THEN
2576: IF (g_asn_debug = 'Y') THEN
2577: asn_debug.put_line('Unexpected exception in load_lot_serial_interfaces : ' || SQLERRM);
2578: raise;
2579: END IF;
2580:

Line 2577: asn_debug.put_line('Unexpected exception in load_lot_serial_interfaces : ' || SQLERRM);

2573:
2574: EXCEPTION
2575: WHEN OTHERS THEN
2576: IF (g_asn_debug = 'Y') THEN
2577: asn_debug.put_line('Unexpected exception in load_lot_serial_interfaces : ' || SQLERRM);
2578: raise;
2579: END IF;
2580:
2581: END load_lot_serial_interfaces;

Line 2658: asn_debug.put_line('perform_post_TM_updates for returned RTs');

2654: pre_rti_id NUMBER := NULL; --RTV project phase 2
2655: pre_rti_qty NUMBER := NULL; --RTV project phase 2
2656: BEGIN
2657: IF (p_TM_source = 'RCV') THEN
2658: asn_debug.put_line('perform_post_TM_updates for returned RTs');
2659: FOR c_rec IN wdd_rt_cursor LOOP
2660: --RTV project phase 2 : start
2661: IF (c_rec.bkup_rti_id = pre_rti_id) THEN
2662: c_rec.bkup_rti_quantity := pre_rti_qty;

Line 2683: asn_debug.put_line('perform_post_TM_updates for issued out MMTs');

2679: pre_rti_qty := c_rec.bkup_rti_quantity; --RTV project phase 2
2680: END LOOP;
2681:
2682: ELSIF (p_TM_source = 'INV') THEN
2683: asn_debug.put_line('perform_post_TM_updates for issued out MMTs');
2684: FOR c_rec IN wdd_mmt_cursor LOOP
2685: --RTV project phase 2 : start
2686: IF (c_rec.bkup_rti_id = pre_rti_id) THEN
2687: c_rec.bkup_rti_quantity := pre_rti_qty;

Line 2710: IF (g_asn_debug = 'Y') THEN

2706: END IF;
2707:
2708: EXCEPTION
2709: WHEN OTHERS THEN
2710: IF (g_asn_debug = 'Y') THEN
2711: asn_debug.put_line('Unexpected exception in adjust_lot_data : ' || SQLERRM);
2712: raise;
2713: END IF;
2714: END perform_post_TM_updates;

Line 2711: asn_debug.put_line('Unexpected exception in adjust_lot_data : ' || SQLERRM);

2707:
2708: EXCEPTION
2709: WHEN OTHERS THEN
2710: IF (g_asn_debug = 'Y') THEN
2711: asn_debug.put_line('Unexpected exception in adjust_lot_data : ' || SQLERRM);
2712: raise;
2713: END IF;
2714: END perform_post_TM_updates;
2715:

Line 2754: IF (g_asn_debug = 'Y') THEN

2750: -- RTV project phase 2 : end
2751:
2752: BEGIN
2753: --
2754: IF (g_asn_debug = 'Y') THEN
2755: asn_debug.put_line('p_delivery_detail_id : ' || p_delivery_detail_id);
2756: asn_debug.put_line('p_item_id : ' || p_item_id);
2757: asn_debug.put_line('p_wdd_shipped_qty : ' || p_wdd_shipped_qty);
2758: asn_debug.put_line('p_wdd_shipped_uom_code : ' || p_wdd_shipped_uom_code);

Line 2755: asn_debug.put_line('p_delivery_detail_id : ' || p_delivery_detail_id);

2751:
2752: BEGIN
2753: --
2754: IF (g_asn_debug = 'Y') THEN
2755: asn_debug.put_line('p_delivery_detail_id : ' || p_delivery_detail_id);
2756: asn_debug.put_line('p_item_id : ' || p_item_id);
2757: asn_debug.put_line('p_wdd_shipped_qty : ' || p_wdd_shipped_qty);
2758: asn_debug.put_line('p_wdd_shipped_uom_code : ' || p_wdd_shipped_uom_code);
2759: asn_debug.put_line('p_wdd_shipped_uom_code2 : ' || p_wdd_shipped_uom_code2);

Line 2756: asn_debug.put_line('p_item_id : ' || p_item_id);

2752: BEGIN
2753: --
2754: IF (g_asn_debug = 'Y') THEN
2755: asn_debug.put_line('p_delivery_detail_id : ' || p_delivery_detail_id);
2756: asn_debug.put_line('p_item_id : ' || p_item_id);
2757: asn_debug.put_line('p_wdd_shipped_qty : ' || p_wdd_shipped_qty);
2758: asn_debug.put_line('p_wdd_shipped_uom_code : ' || p_wdd_shipped_uom_code);
2759: asn_debug.put_line('p_wdd_shipped_uom_code2 : ' || p_wdd_shipped_uom_code2);
2760: asn_debug.put_line('p_bkup_rti_id : ' || p_bkup_rti_id);

Line 2757: asn_debug.put_line('p_wdd_shipped_qty : ' || p_wdd_shipped_qty);

2753: --
2754: IF (g_asn_debug = 'Y') THEN
2755: asn_debug.put_line('p_delivery_detail_id : ' || p_delivery_detail_id);
2756: asn_debug.put_line('p_item_id : ' || p_item_id);
2757: asn_debug.put_line('p_wdd_shipped_qty : ' || p_wdd_shipped_qty);
2758: asn_debug.put_line('p_wdd_shipped_uom_code : ' || p_wdd_shipped_uom_code);
2759: asn_debug.put_line('p_wdd_shipped_uom_code2 : ' || p_wdd_shipped_uom_code2);
2760: asn_debug.put_line('p_bkup_rti_id : ' || p_bkup_rti_id);
2761: asn_debug.put_line('p_bkup_rti_quantity : ' || p_bkup_rti_quantity);

Line 2758: asn_debug.put_line('p_wdd_shipped_uom_code : ' || p_wdd_shipped_uom_code);

2754: IF (g_asn_debug = 'Y') THEN
2755: asn_debug.put_line('p_delivery_detail_id : ' || p_delivery_detail_id);
2756: asn_debug.put_line('p_item_id : ' || p_item_id);
2757: asn_debug.put_line('p_wdd_shipped_qty : ' || p_wdd_shipped_qty);
2758: asn_debug.put_line('p_wdd_shipped_uom_code : ' || p_wdd_shipped_uom_code);
2759: asn_debug.put_line('p_wdd_shipped_uom_code2 : ' || p_wdd_shipped_uom_code2);
2760: asn_debug.put_line('p_bkup_rti_id : ' || p_bkup_rti_id);
2761: asn_debug.put_line('p_bkup_rti_quantity : ' || p_bkup_rti_quantity);
2762: asn_debug.put_line('p_bkup_rti_uom : ' || p_bkup_rti_uom);

Line 2759: asn_debug.put_line('p_wdd_shipped_uom_code2 : ' || p_wdd_shipped_uom_code2);

2755: asn_debug.put_line('p_delivery_detail_id : ' || p_delivery_detail_id);
2756: asn_debug.put_line('p_item_id : ' || p_item_id);
2757: asn_debug.put_line('p_wdd_shipped_qty : ' || p_wdd_shipped_qty);
2758: asn_debug.put_line('p_wdd_shipped_uom_code : ' || p_wdd_shipped_uom_code);
2759: asn_debug.put_line('p_wdd_shipped_uom_code2 : ' || p_wdd_shipped_uom_code2);
2760: asn_debug.put_line('p_bkup_rti_id : ' || p_bkup_rti_id);
2761: asn_debug.put_line('p_bkup_rti_quantity : ' || p_bkup_rti_quantity);
2762: asn_debug.put_line('p_bkup_rti_uom : ' || p_bkup_rti_uom);
2763: asn_debug.put_line('p_bkup_rti_puom : ' || p_bkup_rti_puom);

Line 2760: asn_debug.put_line('p_bkup_rti_id : ' || p_bkup_rti_id);

2756: asn_debug.put_line('p_item_id : ' || p_item_id);
2757: asn_debug.put_line('p_wdd_shipped_qty : ' || p_wdd_shipped_qty);
2758: asn_debug.put_line('p_wdd_shipped_uom_code : ' || p_wdd_shipped_uom_code);
2759: asn_debug.put_line('p_wdd_shipped_uom_code2 : ' || p_wdd_shipped_uom_code2);
2760: asn_debug.put_line('p_bkup_rti_id : ' || p_bkup_rti_id);
2761: asn_debug.put_line('p_bkup_rti_quantity : ' || p_bkup_rti_quantity);
2762: asn_debug.put_line('p_bkup_rti_uom : ' || p_bkup_rti_uom);
2763: asn_debug.put_line('p_bkup_rti_puom : ' || p_bkup_rti_puom);
2764: asn_debug.put_line('p_bkup_rti_suom : ' || p_bkup_rti_suom);

Line 2761: asn_debug.put_line('p_bkup_rti_quantity : ' || p_bkup_rti_quantity);

2757: asn_debug.put_line('p_wdd_shipped_qty : ' || p_wdd_shipped_qty);
2758: asn_debug.put_line('p_wdd_shipped_uom_code : ' || p_wdd_shipped_uom_code);
2759: asn_debug.put_line('p_wdd_shipped_uom_code2 : ' || p_wdd_shipped_uom_code2);
2760: asn_debug.put_line('p_bkup_rti_id : ' || p_bkup_rti_id);
2761: asn_debug.put_line('p_bkup_rti_quantity : ' || p_bkup_rti_quantity);
2762: asn_debug.put_line('p_bkup_rti_uom : ' || p_bkup_rti_uom);
2763: asn_debug.put_line('p_bkup_rti_puom : ' || p_bkup_rti_puom);
2764: asn_debug.put_line('p_bkup_rti_suom : ' || p_bkup_rti_suom);
2765: asn_debug.put_line('p_bkup_rti_src_uom : ' || p_bkup_rti_src_uom);

Line 2762: asn_debug.put_line('p_bkup_rti_uom : ' || p_bkup_rti_uom);

2758: asn_debug.put_line('p_wdd_shipped_uom_code : ' || p_wdd_shipped_uom_code);
2759: asn_debug.put_line('p_wdd_shipped_uom_code2 : ' || p_wdd_shipped_uom_code2);
2760: asn_debug.put_line('p_bkup_rti_id : ' || p_bkup_rti_id);
2761: asn_debug.put_line('p_bkup_rti_quantity : ' || p_bkup_rti_quantity);
2762: asn_debug.put_line('p_bkup_rti_uom : ' || p_bkup_rti_uom);
2763: asn_debug.put_line('p_bkup_rti_puom : ' || p_bkup_rti_puom);
2764: asn_debug.put_line('p_bkup_rti_suom : ' || p_bkup_rti_suom);
2765: asn_debug.put_line('p_bkup_rti_src_uom : ' || p_bkup_rti_src_uom);
2766: END IF;

Line 2763: asn_debug.put_line('p_bkup_rti_puom : ' || p_bkup_rti_puom);

2759: asn_debug.put_line('p_wdd_shipped_uom_code2 : ' || p_wdd_shipped_uom_code2);
2760: asn_debug.put_line('p_bkup_rti_id : ' || p_bkup_rti_id);
2761: asn_debug.put_line('p_bkup_rti_quantity : ' || p_bkup_rti_quantity);
2762: asn_debug.put_line('p_bkup_rti_uom : ' || p_bkup_rti_uom);
2763: asn_debug.put_line('p_bkup_rti_puom : ' || p_bkup_rti_puom);
2764: asn_debug.put_line('p_bkup_rti_suom : ' || p_bkup_rti_suom);
2765: asn_debug.put_line('p_bkup_rti_src_uom : ' || p_bkup_rti_src_uom);
2766: END IF;
2767: --

Line 2764: asn_debug.put_line('p_bkup_rti_suom : ' || p_bkup_rti_suom);

2760: asn_debug.put_line('p_bkup_rti_id : ' || p_bkup_rti_id);
2761: asn_debug.put_line('p_bkup_rti_quantity : ' || p_bkup_rti_quantity);
2762: asn_debug.put_line('p_bkup_rti_uom : ' || p_bkup_rti_uom);
2763: asn_debug.put_line('p_bkup_rti_puom : ' || p_bkup_rti_puom);
2764: asn_debug.put_line('p_bkup_rti_suom : ' || p_bkup_rti_suom);
2765: asn_debug.put_line('p_bkup_rti_src_uom : ' || p_bkup_rti_src_uom);
2766: END IF;
2767: --
2768: l_shipped_uom := get_uom_from_code (p_wdd_shipped_uom_code);

Line 2765: asn_debug.put_line('p_bkup_rti_src_uom : ' || p_bkup_rti_src_uom);

2761: asn_debug.put_line('p_bkup_rti_quantity : ' || p_bkup_rti_quantity);
2762: asn_debug.put_line('p_bkup_rti_uom : ' || p_bkup_rti_uom);
2763: asn_debug.put_line('p_bkup_rti_puom : ' || p_bkup_rti_puom);
2764: asn_debug.put_line('p_bkup_rti_suom : ' || p_bkup_rti_suom);
2765: asn_debug.put_line('p_bkup_rti_src_uom : ' || p_bkup_rti_src_uom);
2766: END IF;
2767: --
2768: l_shipped_uom := get_uom_from_code (p_wdd_shipped_uom_code);
2769: IF (g_asn_debug = 'Y') THEN

Line 2769: IF (g_asn_debug = 'Y') THEN

2765: asn_debug.put_line('p_bkup_rti_src_uom : ' || p_bkup_rti_src_uom);
2766: END IF;
2767: --
2768: l_shipped_uom := get_uom_from_code (p_wdd_shipped_uom_code);
2769: IF (g_asn_debug = 'Y') THEN
2770: asn_debug.put_line('l_shipped_uom : ' || l_shipped_uom);
2771: END IF;
2772: --
2773: IF (l_shipped_uom <> p_bkup_rti_uom) THEN

Line 2770: asn_debug.put_line('l_shipped_uom : ' || l_shipped_uom);

2766: END IF;
2767: --
2768: l_shipped_uom := get_uom_from_code (p_wdd_shipped_uom_code);
2769: IF (g_asn_debug = 'Y') THEN
2770: asn_debug.put_line('l_shipped_uom : ' || l_shipped_uom);
2771: END IF;
2772: --
2773: IF (l_shipped_uom <> p_bkup_rti_uom) THEN
2774: po_uom_s.uom_convert

Line 2787: IF (g_asn_debug = 'Y') THEN

2783:
2784: l_txn_qty := p_bkup_rti_quantity - l_shipped_qty;
2785: p_bkup_rti_quantity := l_txn_qty; --RTV project phase 2
2786:
2787: IF (g_asn_debug = 'Y') THEN
2788: asn_debug.put_line('l_shipped_qty : ' || l_shipped_qty);
2789: asn_debug.put_line('l_txn_qty : ' || l_txn_qty);
2790: END IF;
2791: --

Line 2788: asn_debug.put_line('l_shipped_qty : ' || l_shipped_qty);

2784: l_txn_qty := p_bkup_rti_quantity - l_shipped_qty;
2785: p_bkup_rti_quantity := l_txn_qty; --RTV project phase 2
2786:
2787: IF (g_asn_debug = 'Y') THEN
2788: asn_debug.put_line('l_shipped_qty : ' || l_shipped_qty);
2789: asn_debug.put_line('l_txn_qty : ' || l_txn_qty);
2790: END IF;
2791: --
2792: IF (l_txn_qty > 0) THEN

Line 2789: asn_debug.put_line('l_txn_qty : ' || l_txn_qty);

2785: p_bkup_rti_quantity := l_txn_qty; --RTV project phase 2
2786:
2787: IF (g_asn_debug = 'Y') THEN
2788: asn_debug.put_line('l_shipped_qty : ' || l_shipped_qty);
2789: asn_debug.put_line('l_txn_qty : ' || l_txn_qty);
2790: END IF;
2791: --
2792: IF (l_txn_qty > 0) THEN
2793:

Line 2804: IF (g_asn_debug = 'Y') THEN

2800: to_quantity => l_primary_qty);
2801: ELSE
2802: l_primary_qty := p_wdd_shipped_qty;
2803: END IF;
2804: IF (g_asn_debug = 'Y') THEN
2805: asn_debug.put_line('p_bkup_rti_puom : ' || p_bkup_rti_puom);
2806: asn_debug.put_line('l_primary_qty : ' || l_primary_qty);
2807: END IF;
2808: --

Line 2805: asn_debug.put_line('p_bkup_rti_puom : ' || p_bkup_rti_puom);

2801: ELSE
2802: l_primary_qty := p_wdd_shipped_qty;
2803: END IF;
2804: IF (g_asn_debug = 'Y') THEN
2805: asn_debug.put_line('p_bkup_rti_puom : ' || p_bkup_rti_puom);
2806: asn_debug.put_line('l_primary_qty : ' || l_primary_qty);
2807: END IF;
2808: --
2809: l_shipped_sec_uom := get_uom_from_code (p_wdd_shipped_uom_code2);

Line 2806: asn_debug.put_line('l_primary_qty : ' || l_primary_qty);

2802: l_primary_qty := p_wdd_shipped_qty;
2803: END IF;
2804: IF (g_asn_debug = 'Y') THEN
2805: asn_debug.put_line('p_bkup_rti_puom : ' || p_bkup_rti_puom);
2806: asn_debug.put_line('l_primary_qty : ' || l_primary_qty);
2807: END IF;
2808: --
2809: l_shipped_sec_uom := get_uom_from_code (p_wdd_shipped_uom_code2);
2810: IF (g_asn_debug = 'Y') THEN

Line 2810: IF (g_asn_debug = 'Y') THEN

2806: asn_debug.put_line('l_primary_qty : ' || l_primary_qty);
2807: END IF;
2808: --
2809: l_shipped_sec_uom := get_uom_from_code (p_wdd_shipped_uom_code2);
2810: IF (g_asn_debug = 'Y') THEN
2811: asn_debug.put_line('l_shipped_sec_uom : ' || l_shipped_sec_uom);
2812: END IF;
2813:
2814: IF (p_bkup_rti_suom IS NOT NULL) THEN

Line 2811: asn_debug.put_line('l_shipped_sec_uom : ' || l_shipped_sec_uom);

2807: END IF;
2808: --
2809: l_shipped_sec_uom := get_uom_from_code (p_wdd_shipped_uom_code2);
2810: IF (g_asn_debug = 'Y') THEN
2811: asn_debug.put_line('l_shipped_sec_uom : ' || l_shipped_sec_uom);
2812: END IF;
2813:
2814: IF (p_bkup_rti_suom IS NOT NULL) THEN
2815: IF (l_shipped_sec_uom <> p_bkup_rti_suom) THEN

Line 2827: IF (g_asn_debug = 'Y') THEN

2823: l_shipped_qty2 := p_wdd_shipped_qty2;
2824: END IF;
2825: END IF;
2826:
2827: IF (g_asn_debug = 'Y') THEN
2828: asn_debug.put_line('p_bkup_rti_suom : ' || p_bkup_rti_suom);
2829: asn_debug.put_line('l_shipped_qty2 : ' || l_shipped_qty2);
2830: END IF;
2831: --

Line 2828: asn_debug.put_line('p_bkup_rti_suom : ' || p_bkup_rti_suom);

2824: END IF;
2825: END IF;
2826:
2827: IF (g_asn_debug = 'Y') THEN
2828: asn_debug.put_line('p_bkup_rti_suom : ' || p_bkup_rti_suom);
2829: asn_debug.put_line('l_shipped_qty2 : ' || l_shipped_qty2);
2830: END IF;
2831: --
2832: IF (p_bkup_rti_src_uom IS NOT NULL) THEN

Line 2829: asn_debug.put_line('l_shipped_qty2 : ' || l_shipped_qty2);

2825: END IF;
2826:
2827: IF (g_asn_debug = 'Y') THEN
2828: asn_debug.put_line('p_bkup_rti_suom : ' || p_bkup_rti_suom);
2829: asn_debug.put_line('l_shipped_qty2 : ' || l_shipped_qty2);
2830: END IF;
2831: --
2832: IF (p_bkup_rti_src_uom IS NOT NULL) THEN
2833: IF (nvl(p_bkup_rti_uom, -99) <> nvl(p_bkup_rti_src_uom,-99)) THEN

Line 2845: IF (g_asn_debug = 'Y') THEN

2841: l_src_uom_qty := l_txn_qty;
2842: END IF;
2843: END IF;
2844:
2845: IF (g_asn_debug = 'Y') THEN
2846: asn_debug.put_line('l_src_uom_qty : ' || l_src_uom_qty);
2847: END IF;
2848: --
2849: UPDATE rcv_transactions_interface

Line 2846: asn_debug.put_line('l_src_uom_qty : ' || l_src_uom_qty);

2842: END IF;
2843: END IF;
2844:
2845: IF (g_asn_debug = 'Y') THEN
2846: asn_debug.put_line('l_src_uom_qty : ' || l_src_uom_qty);
2847: END IF;
2848: --
2849: UPDATE rcv_transactions_interface
2850: SET quantity = l_txn_qty,

Line 2880: IF (g_asn_debug = 'Y') THEN

2876: -- RTV project phase 2 : end
2877: --
2878: EXCEPTION
2879: WHEN e_Overship_Error THEN
2880: IF (g_asn_debug = 'Y') THEN
2881: asn_debug.put_line('Overship error');
2882: raise;
2883: END IF;
2884: --RTV project phase 2 : start

Line 2881: asn_debug.put_line('Overship error');

2877: --
2878: EXCEPTION
2879: WHEN e_Overship_Error THEN
2880: IF (g_asn_debug = 'Y') THEN
2881: asn_debug.put_line('Overship error');
2882: raise;
2883: END IF;
2884: --RTV project phase 2 : start
2885: WHEN e_WMS_post_Error THEN

Line 2886: IF (g_asn_debug = 'Y') THEN

2882: raise;
2883: END IF;
2884: --RTV project phase 2 : start
2885: WHEN e_WMS_post_Error THEN
2886: IF (g_asn_debug = 'Y') THEN
2887: asn_debug.put_line('Unexpected exception in adjust_lot_data while calling wms_return_sv.perform_post_TM_wms_updates');
2888: raise;
2889: END IF;
2890: --RTV project phase 2 : end

Line 2887: asn_debug.put_line('Unexpected exception in adjust_lot_data while calling wms_return_sv.perform_post_TM_wms_updates');

2883: END IF;
2884: --RTV project phase 2 : start
2885: WHEN e_WMS_post_Error THEN
2886: IF (g_asn_debug = 'Y') THEN
2887: asn_debug.put_line('Unexpected exception in adjust_lot_data while calling wms_return_sv.perform_post_TM_wms_updates');
2888: raise;
2889: END IF;
2890: --RTV project phase 2 : end
2891: WHEN OTHERS THEN

Line 2892: IF (g_asn_debug = 'Y') THEN

2888: raise;
2889: END IF;
2890: --RTV project phase 2 : end
2891: WHEN OTHERS THEN
2892: IF (g_asn_debug = 'Y') THEN
2893: asn_debug.put_line('Unexpected exception in adjust_lot_data : ' || SQLERRM);
2894: raise;
2895: END IF;
2896: END adjust_rcv_quantities;

Line 2893: asn_debug.put_line('Unexpected exception in adjust_lot_data : ' || SQLERRM);

2889: END IF;
2890: --RTV project phase 2 : end
2891: WHEN OTHERS THEN
2892: IF (g_asn_debug = 'Y') THEN
2893: asn_debug.put_line('Unexpected exception in adjust_lot_data : ' || SQLERRM);
2894: raise;
2895: END IF;
2896: END adjust_rcv_quantities;
2897:

Line 2921: asn_debug.put_line('After deleting MSNI : count = ' || sql%rowcount);

2917:
2918: EXCEPTION
2919: WHEN OTHERS THEN NULL;
2920: END;
2921: asn_debug.put_line('After deleting MSNI : count = ' || sql%rowcount);
2922: --
2923: BEGIN
2924: DELETE FROM mtl_transaction_lots_interface
2925: WHERE product_transaction_id IN

Line 2934: asn_debug.put_line('After deleting MTLI : count = ' || sql%rowcount);

2930:
2931: EXCEPTION
2932: WHEN OTHERS THEN NULL;
2933: END;
2934: asn_debug.put_line('After deleting MTLI : count = ' || sql%rowcount);
2935: --
2936: DELETE FROM rcv_transactions_interface
2937: WHERE group_id = p_group_id
2938: AND processing_mode_code = 'ONLINE';

Line 2939: asn_debug.put_line('After deleting RTI : count = ' || sql%rowcount);

2935: --
2936: DELETE FROM rcv_transactions_interface
2937: WHERE group_id = p_group_id
2938: AND processing_mode_code = 'ONLINE';
2939: asn_debug.put_line('After deleting RTI : count = ' || sql%rowcount);
2940: --
2941: EXCEPTION
2942: WHEN OTHERS THEN
2943: IF (g_asn_debug = 'Y') THEN

Line 2943: IF (g_asn_debug = 'Y') THEN

2939: asn_debug.put_line('After deleting RTI : count = ' || sql%rowcount);
2940: --
2941: EXCEPTION
2942: WHEN OTHERS THEN
2943: IF (g_asn_debug = 'Y') THEN
2944: asn_debug.put_line('Unexpected exception in clean_up_after_rtp : ' || SQLERRM);
2945: raise;
2946: END IF;
2947: END clean_up_after_rtp;

Line 2944: asn_debug.put_line('Unexpected exception in clean_up_after_rtp : ' || SQLERRM);

2940: --
2941: EXCEPTION
2942: WHEN OTHERS THEN
2943: IF (g_asn_debug = 'Y') THEN
2944: asn_debug.put_line('Unexpected exception in clean_up_after_rtp : ' || SQLERRM);
2945: raise;
2946: END IF;
2947: END clean_up_after_rtp;
2948:

Line 3017: IF (g_asn_debug = 'Y') THEN

3013: l_rtv_order NUMBER := -1;
3014: -- RTV2 rtv project phase 2 : end
3015:
3016: BEGIN
3017: IF (g_asn_debug = 'Y') THEN
3018: asn_debug.put_line('Entering cancel_rtv_lines');
3019: END IF;
3020:
3021: FOR i IN 1 .. p_rti_id_tbl.COUNT LOOP

Line 3018: asn_debug.put_line('Entering cancel_rtv_lines');

3014: -- RTV2 rtv project phase 2 : end
3015:
3016: BEGIN
3017: IF (g_asn_debug = 'Y') THEN
3018: asn_debug.put_line('Entering cancel_rtv_lines');
3019: END IF;
3020:
3021: FOR i IN 1 .. p_rti_id_tbl.COUNT LOOP
3022: wsh_integration.get_cancel_qty_allowed

Line 3031: IF (g_asn_debug = 'Y') THEN

3027: x_msg_count => l_msg_count,
3028: x_msg_data => l_msg_data );
3029:
3030: IF l_return_status = 'S' THEN
3031: IF (g_asn_debug = 'Y') THEN
3032: asn_debug.put_line('l_wdd_cancel_qty : ' || l_wdd_cancel_qty);
3033: END IF;
3034:
3035: IF l_wdd_cancel_qty > 0 THEN

Line 3032: asn_debug.put_line('l_wdd_cancel_qty : ' || l_wdd_cancel_qty);

3028: x_msg_data => l_msg_data );
3029:
3030: IF l_return_status = 'S' THEN
3031: IF (g_asn_debug = 'Y') THEN
3032: asn_debug.put_line('l_wdd_cancel_qty : ' || l_wdd_cancel_qty);
3033: END IF;
3034:
3035: IF l_wdd_cancel_qty > 0 THEN
3036: SELECT item_id,

Line 3063: IF (g_asn_debug = 'Y') THEN

3059: FROM wsh_delivery_details
3060: WHERE source_line_id = p_rti_id_tbl(i)
3061: AND source_code = 'RTV';
3062:
3063: IF (g_asn_debug = 'Y') THEN
3064: asn_debug.put_line('l_item_id : ' || l_item_id);
3065: asn_debug.put_line('l_rti_qty : ' || l_rti_qty );
3066: asn_debug.put_line('l_rti_uom : ' || l_rti_uom);
3067: asn_debug.put_line('l_rti_puom : ' || l_rti_puom);

Line 3064: asn_debug.put_line('l_item_id : ' || l_item_id);

3060: WHERE source_line_id = p_rti_id_tbl(i)
3061: AND source_code = 'RTV';
3062:
3063: IF (g_asn_debug = 'Y') THEN
3064: asn_debug.put_line('l_item_id : ' || l_item_id);
3065: asn_debug.put_line('l_rti_qty : ' || l_rti_qty );
3066: asn_debug.put_line('l_rti_uom : ' || l_rti_uom);
3067: asn_debug.put_line('l_rti_puom : ' || l_rti_puom);
3068: asn_debug.put_line('l_rti_suom : ' || l_rti_suom);

Line 3065: asn_debug.put_line('l_rti_qty : ' || l_rti_qty );

3061: AND source_code = 'RTV';
3062:
3063: IF (g_asn_debug = 'Y') THEN
3064: asn_debug.put_line('l_item_id : ' || l_item_id);
3065: asn_debug.put_line('l_rti_qty : ' || l_rti_qty );
3066: asn_debug.put_line('l_rti_uom : ' || l_rti_uom);
3067: asn_debug.put_line('l_rti_puom : ' || l_rti_puom);
3068: asn_debug.put_line('l_rti_suom : ' || l_rti_suom);
3069: asn_debug.put_line('l_rti_src_uom : ' || l_rti_src_uom);

Line 3066: asn_debug.put_line('l_rti_uom : ' || l_rti_uom);

3062:
3063: IF (g_asn_debug = 'Y') THEN
3064: asn_debug.put_line('l_item_id : ' || l_item_id);
3065: asn_debug.put_line('l_rti_qty : ' || l_rti_qty );
3066: asn_debug.put_line('l_rti_uom : ' || l_rti_uom);
3067: asn_debug.put_line('l_rti_puom : ' || l_rti_puom);
3068: asn_debug.put_line('l_rti_suom : ' || l_rti_suom);
3069: asn_debug.put_line('l_rti_src_uom : ' || l_rti_src_uom);
3070: asn_debug.put_line('l_source_header_id : ' || l_source_header_id);

Line 3067: asn_debug.put_line('l_rti_puom : ' || l_rti_puom);

3063: IF (g_asn_debug = 'Y') THEN
3064: asn_debug.put_line('l_item_id : ' || l_item_id);
3065: asn_debug.put_line('l_rti_qty : ' || l_rti_qty );
3066: asn_debug.put_line('l_rti_uom : ' || l_rti_uom);
3067: asn_debug.put_line('l_rti_puom : ' || l_rti_puom);
3068: asn_debug.put_line('l_rti_suom : ' || l_rti_suom);
3069: asn_debug.put_line('l_rti_src_uom : ' || l_rti_src_uom);
3070: asn_debug.put_line('l_source_header_id : ' || l_source_header_id);
3071: asn_debug.put_line('l_wdd_uom_code : ' || l_wdd_uom_code);

Line 3068: asn_debug.put_line('l_rti_suom : ' || l_rti_suom);

3064: asn_debug.put_line('l_item_id : ' || l_item_id);
3065: asn_debug.put_line('l_rti_qty : ' || l_rti_qty );
3066: asn_debug.put_line('l_rti_uom : ' || l_rti_uom);
3067: asn_debug.put_line('l_rti_puom : ' || l_rti_puom);
3068: asn_debug.put_line('l_rti_suom : ' || l_rti_suom);
3069: asn_debug.put_line('l_rti_src_uom : ' || l_rti_src_uom);
3070: asn_debug.put_line('l_source_header_id : ' || l_source_header_id);
3071: asn_debug.put_line('l_wdd_uom_code : ' || l_wdd_uom_code);
3072: END IF;

Line 3069: asn_debug.put_line('l_rti_src_uom : ' || l_rti_src_uom);

3065: asn_debug.put_line('l_rti_qty : ' || l_rti_qty );
3066: asn_debug.put_line('l_rti_uom : ' || l_rti_uom);
3067: asn_debug.put_line('l_rti_puom : ' || l_rti_puom);
3068: asn_debug.put_line('l_rti_suom : ' || l_rti_suom);
3069: asn_debug.put_line('l_rti_src_uom : ' || l_rti_src_uom);
3070: asn_debug.put_line('l_source_header_id : ' || l_source_header_id);
3071: asn_debug.put_line('l_wdd_uom_code : ' || l_wdd_uom_code);
3072: END IF;
3073:

Line 3070: asn_debug.put_line('l_source_header_id : ' || l_source_header_id);

3066: asn_debug.put_line('l_rti_uom : ' || l_rti_uom);
3067: asn_debug.put_line('l_rti_puom : ' || l_rti_puom);
3068: asn_debug.put_line('l_rti_suom : ' || l_rti_suom);
3069: asn_debug.put_line('l_rti_src_uom : ' || l_rti_src_uom);
3070: asn_debug.put_line('l_source_header_id : ' || l_source_header_id);
3071: asn_debug.put_line('l_wdd_uom_code : ' || l_wdd_uom_code);
3072: END IF;
3073:
3074: l_wdd_uom := get_uom_from_code (l_wdd_uom_code);

Line 3071: asn_debug.put_line('l_wdd_uom_code : ' || l_wdd_uom_code);

3067: asn_debug.put_line('l_rti_puom : ' || l_rti_puom);
3068: asn_debug.put_line('l_rti_suom : ' || l_rti_suom);
3069: asn_debug.put_line('l_rti_src_uom : ' || l_rti_src_uom);
3070: asn_debug.put_line('l_source_header_id : ' || l_source_header_id);
3071: asn_debug.put_line('l_wdd_uom_code : ' || l_wdd_uom_code);
3072: END IF;
3073:
3074: l_wdd_uom := get_uom_from_code (l_wdd_uom_code);
3075:

Line 3076: IF (g_asn_debug = 'Y') THEN

3072: END IF;
3073:
3074: l_wdd_uom := get_uom_from_code (l_wdd_uom_code);
3075:
3076: IF (g_asn_debug = 'Y') THEN
3077: asn_debug.put_line('l_wdd_uom : ' || l_wdd_uom);
3078: END IF;
3079:
3080: l_changed_attributes(1).source_code := 'RTV';

Line 3077: asn_debug.put_line('l_wdd_uom : ' || l_wdd_uom);

3073:
3074: l_wdd_uom := get_uom_from_code (l_wdd_uom_code);
3075:
3076: IF (g_asn_debug = 'Y') THEN
3077: asn_debug.put_line('l_wdd_uom : ' || l_wdd_uom);
3078: END IF;
3079:
3080: l_changed_attributes(1).source_code := 'RTV';
3081: l_changed_attributes(1).source_header_id := l_source_header_id;

Line 3091: IF (g_asn_debug = 'Y') THEN

3087:
3088: --RTV2 rtv project phase 2 : start
3089: --Before cancelling , keep association between content wdd and lpns.
3090: IF (l_transfer_lpn_id IS NOT NULL) THEN
3091: IF (g_asn_debug = 'Y') THEN
3092: asn_debug.put_line('open cursor cancelled_lpn_cur before cancellation. ' );
3093: END IF;
3094: OPEN cancelled_lpn_cur(p_rti_id_tbl(i));
3095: FETCH cancelled_lpn_cur BULK COLLECT INTO l_wdd_lpns;

Line 3092: asn_debug.put_line('open cursor cancelled_lpn_cur before cancellation. ' );

3088: --RTV2 rtv project phase 2 : start
3089: --Before cancelling , keep association between content wdd and lpns.
3090: IF (l_transfer_lpn_id IS NOT NULL) THEN
3091: IF (g_asn_debug = 'Y') THEN
3092: asn_debug.put_line('open cursor cancelled_lpn_cur before cancellation. ' );
3093: END IF;
3094: OPEN cancelled_lpn_cur(p_rti_id_tbl(i));
3095: FETCH cancelled_lpn_cur BULK COLLECT INTO l_wdd_lpns;
3096: CLOSE cancelled_lpn_cur;

Line 3121: IF (g_asn_debug = 'Y') THEN

3117: IF(l_transfer_lpn_id IS NOT NULL) THEN
3118: FOR indx IN 1 .. l_wdd_lpns.COUNT LOOP
3119: IF( wdd_rec.delivery_detail_id = l_wdd_lpns(indx).delivery_detail_id ) THEN
3120: l_lpn_id := l_wdd_lpns(indx).lpn_id;
3121: IF (g_asn_debug = 'Y') THEN
3122: asn_debug.put_line('before calling wms_return_sv.unmark_returns for lpn_id:'|| l_lpn_id);
3123: END IF;
3124: --we should pass lpn_id here, since we are not able to fetch lpn_id
3125: --from wsh_delivery_assignments

Line 3122: asn_debug.put_line('before calling wms_return_sv.unmark_returns for lpn_id:'|| l_lpn_id);

3118: FOR indx IN 1 .. l_wdd_lpns.COUNT LOOP
3119: IF( wdd_rec.delivery_detail_id = l_wdd_lpns(indx).delivery_detail_id ) THEN
3120: l_lpn_id := l_wdd_lpns(indx).lpn_id;
3121: IF (g_asn_debug = 'Y') THEN
3122: asn_debug.put_line('before calling wms_return_sv.unmark_returns for lpn_id:'|| l_lpn_id);
3123: END IF;
3124: --we should pass lpn_id here, since we are not able to fetch lpn_id
3125: --from wsh_delivery_assignments
3126: unmark_wdd_lpn(p_wdd_rec => wdd_rec,

Line 3140: IF (g_asn_debug = 'Y') THEN

3136: INTO l_count
3137: FROM wsh_delivery_assignments
3138: WHERE parent_delivery_detail_id = l_wdd_lpns(indx).lpn_wdd_id;
3139: IF( l_count = 0 ) THEN
3140: IF (g_asn_debug = 'Y') THEN
3141: asn_debug.put_line('before deleting container wdd :'||l_wdd_lpns(indx).lpn_wdd_id);
3142: END IF;
3143: wsh_container_actions.delete_containers
3144: (p_container_id => l_wdd_lpns(indx).lpn_wdd_id,

Line 3141: asn_debug.put_line('before deleting container wdd :'||l_wdd_lpns(indx).lpn_wdd_id);

3137: FROM wsh_delivery_assignments
3138: WHERE parent_delivery_detail_id = l_wdd_lpns(indx).lpn_wdd_id;
3139: IF( l_count = 0 ) THEN
3140: IF (g_asn_debug = 'Y') THEN
3141: asn_debug.put_line('before deleting container wdd :'||l_wdd_lpns(indx).lpn_wdd_id);
3142: END IF;
3143: wsh_container_actions.delete_containers
3144: (p_container_id => l_wdd_lpns(indx).lpn_wdd_id,
3145: x_return_status => l_return_status);

Line 3166: IF (g_asn_debug = 'Y') THEN

3162: raise e_cancel_MR_error;
3163: END IF;
3164: --RTV2 rtv project phase 2 : end
3165: END LOOP;
3166: IF (g_asn_debug = 'Y') THEN
3167: asn_debug.put_line('After relieve_return_reservation Loop');
3168: END IF;
3169: --
3170: IF (l_rti_uom <> l_wdd_uom) THEN

Line 3167: asn_debug.put_line('After relieve_return_reservation Loop');

3163: END IF;
3164: --RTV2 rtv project phase 2 : end
3165: END LOOP;
3166: IF (g_asn_debug = 'Y') THEN
3167: asn_debug.put_line('After relieve_return_reservation Loop');
3168: END IF;
3169: --
3170: IF (l_rti_uom <> l_wdd_uom) THEN
3171: po_uom_s.uom_convert

Line 3182: IF (g_asn_debug = 'Y') THEN

3178: l_rti_cancel_qty := l_wdd_cancel_qty;
3179: END IF;
3180:
3181: l_rti_new_qty := l_rti_qty - l_rti_cancel_qty;
3182: IF (g_asn_debug = 'Y') THEN
3183: asn_debug.put_line('l_rti_new_qty : ' || l_rti_new_qty);
3184: END IF;
3185: --
3186: IF (l_rti_new_qty > 0) THEN

Line 3183: asn_debug.put_line('l_rti_new_qty : ' || l_rti_new_qty);

3179: END IF;
3180:
3181: l_rti_new_qty := l_rti_qty - l_rti_cancel_qty;
3182: IF (g_asn_debug = 'Y') THEN
3183: asn_debug.put_line('l_rti_new_qty : ' || l_rti_new_qty);
3184: END IF;
3185: --
3186: IF (l_rti_new_qty > 0) THEN
3187: --

Line 3199: IF (g_asn_debug = 'Y') THEN

3195: ELSE
3196: l_rti_new_pqty := l_rti_new_qty;
3197: END IF;
3198:
3199: IF (g_asn_debug = 'Y') THEN
3200: asn_debug.put_line('l_rti_new_pqty : ' || l_rti_new_pqty);
3201: END IF;
3202: --
3203: IF (l_rti_suom IS NOT NULL) THEN

Line 3200: asn_debug.put_line('l_rti_new_pqty : ' || l_rti_new_pqty);

3196: l_rti_new_pqty := l_rti_new_qty;
3197: END IF;
3198:
3199: IF (g_asn_debug = 'Y') THEN
3200: asn_debug.put_line('l_rti_new_pqty : ' || l_rti_new_pqty);
3201: END IF;
3202: --
3203: IF (l_rti_suom IS NOT NULL) THEN
3204: IF (l_rti_uom <> l_rti_suom) THEN

Line 3216: IF (g_asn_debug = 'Y') THEN

3212: l_rti_new_sqty := l_rti_new_qty;
3213: END IF;
3214: END IF;
3215:
3216: IF (g_asn_debug = 'Y') THEN
3217: asn_debug.put_line('l_rti_new_sqty : ' || l_rti_new_sqty);
3218: END IF;
3219: --
3220: IF (l_rti_src_uom IS NOT NULL) THEN

Line 3217: asn_debug.put_line('l_rti_new_sqty : ' || l_rti_new_sqty);

3213: END IF;
3214: END IF;
3215:
3216: IF (g_asn_debug = 'Y') THEN
3217: asn_debug.put_line('l_rti_new_sqty : ' || l_rti_new_sqty);
3218: END IF;
3219: --
3220: IF (l_rti_src_uom IS NOT NULL) THEN
3221:

Line 3234: IF (g_asn_debug = 'Y') THEN

3230: l_rti_new_src_qty := l_rti_new_qty;
3231: END IF;
3232: END IF;
3233:
3234: IF (g_asn_debug = 'Y') THEN
3235: asn_debug.put_line('l_rti_new_src_qty : ' || l_rti_new_src_qty);
3236: END IF;
3237: --
3238: UPDATE rcv_transactions_interface

Line 3235: asn_debug.put_line('l_rti_new_src_qty : ' || l_rti_new_src_qty);

3231: END IF;
3232: END IF;
3233:
3234: IF (g_asn_debug = 'Y') THEN
3235: asn_debug.put_line('l_rti_new_src_qty : ' || l_rti_new_src_qty);
3236: END IF;
3237: --
3238: UPDATE rcv_transactions_interface
3239: SET quantity = l_rti_new_qty,

Line 3277: IF (g_asn_debug = 'Y') THEN

3273: END IF;
3274: --RTV project phase 2 : end
3275:
3276:
3277: IF (g_asn_debug = 'Y') THEN
3278: asn_debug.put_line('Leaving cancel_rtv_line');
3279: END IF;
3280:
3281: EXCEPTION

Line 3278: asn_debug.put_line('Leaving cancel_rtv_line');

3274: --RTV project phase 2 : end
3275:
3276:
3277: IF (g_asn_debug = 'Y') THEN
3278: asn_debug.put_line('Leaving cancel_rtv_line');
3279: END IF;
3280:
3281: EXCEPTION
3282: -- Bug 10089980 : Start

Line 3284: IF (g_asn_debug = 'Y') THEN

3280:
3281: EXCEPTION
3282: -- Bug 10089980 : Start
3283: WHEN e_cancel_error1 THEN
3284: IF (g_asn_debug = 'Y') THEN
3285: asn_debug.put_line('wsh_integration.get_cancel_qty_allowed returned error!');
3286: END IF;
3287: l_msg_data := fnd_msg_pub.get (1, 'F');
3288: po_message_s.sql_error('wsh_integration.get_cancel_qty_allowed', l_msg_data, sqlcode);

Line 3285: asn_debug.put_line('wsh_integration.get_cancel_qty_allowed returned error!');

3281: EXCEPTION
3282: -- Bug 10089980 : Start
3283: WHEN e_cancel_error1 THEN
3284: IF (g_asn_debug = 'Y') THEN
3285: asn_debug.put_line('wsh_integration.get_cancel_qty_allowed returned error!');
3286: END IF;
3287: l_msg_data := fnd_msg_pub.get (1, 'F');
3288: po_message_s.sql_error('wsh_integration.get_cancel_qty_allowed', l_msg_data, sqlcode);
3289: raise fnd_api.g_exc_error;

Line 3292: IF (g_asn_debug = 'Y') THEN

3288: po_message_s.sql_error('wsh_integration.get_cancel_qty_allowed', l_msg_data, sqlcode);
3289: raise fnd_api.g_exc_error;
3290:
3291: WHEN e_cancel_error2 THEN
3292: IF (g_asn_debug = 'Y') THEN
3293: asn_debug.put_line('wsh_interface.update_shipping_attributes returned error!');
3294: END IF;
3295: fnd_msg_pub.count_and_get (p_encoded => 'T',
3296: p_count => l_msg_count,

Line 3293: asn_debug.put_line('wsh_interface.update_shipping_attributes returned error!');

3289: raise fnd_api.g_exc_error;
3290:
3291: WHEN e_cancel_error2 THEN
3292: IF (g_asn_debug = 'Y') THEN
3293: asn_debug.put_line('wsh_interface.update_shipping_attributes returned error!');
3294: END IF;
3295: fnd_msg_pub.count_and_get (p_encoded => 'T',
3296: p_count => l_msg_count,
3297: p_data => l_msg_data

Line 3309: IF (g_asn_debug = 'Y') THEN

3305: raise fnd_api.g_exc_error;
3306: -- Bug 10089980 : End
3307: -- RTV project phase 2 : start
3308: WHEN e_cancel_MR_error THEN
3309: IF (g_asn_debug = 'Y') THEN
3310: asn_debug.put_line('inv_trx_relief_c_pvt.rsv_relief returned error!');
3311: END IF;
3312: fnd_msg_pub.count_and_get (p_encoded => 'T',
3313: p_count => l_msg_count,

Line 3310: asn_debug.put_line('inv_trx_relief_c_pvt.rsv_relief returned error!');

3306: -- Bug 10089980 : End
3307: -- RTV project phase 2 : start
3308: WHEN e_cancel_MR_error THEN
3309: IF (g_asn_debug = 'Y') THEN
3310: asn_debug.put_line('inv_trx_relief_c_pvt.rsv_relief returned error!');
3311: END IF;
3312: fnd_msg_pub.count_and_get (p_encoded => 'T',
3313: p_count => l_msg_count,
3314: p_data => l_msg_data

Line 3325: IF (g_asn_debug = 'Y') THEN

3321: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);
3322: raise fnd_api.g_exc_error;
3323:
3324: WHEN e_cancel_unmark_lpn_error THEN
3325: IF (g_asn_debug = 'Y') THEN
3326: asn_debug.put_line('wms_return_sv.unmark_returns returned error!');
3327: END IF;
3328: fnd_msg_pub.count_and_get (p_encoded => 'T',
3329: p_count => l_msg_count,

Line 3326: asn_debug.put_line('wms_return_sv.unmark_returns returned error!');

3322: raise fnd_api.g_exc_error;
3323:
3324: WHEN e_cancel_unmark_lpn_error THEN
3325: IF (g_asn_debug = 'Y') THEN
3326: asn_debug.put_line('wms_return_sv.unmark_returns returned error!');
3327: END IF;
3328: fnd_msg_pub.count_and_get (p_encoded => 'T',
3329: p_count => l_msg_count,
3330: p_data => l_msg_data

Line 3341: IF (g_asn_debug = 'Y') THEN

3337: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);
3338: raise fnd_api.g_exc_error;
3339:
3340: WHEN e_cancel_unpack_lpn_error THEN
3341: IF (g_asn_debug = 'Y') THEN
3342: asn_debug.put_line('wms_return_sv.cancel_return_order_RTV returned error!');
3343: END IF;
3344: fnd_msg_pub.count_and_get (p_encoded => 'T',
3345: p_count => l_msg_count,

Line 3342: asn_debug.put_line('wms_return_sv.cancel_return_order_RTV returned error!');

3338: raise fnd_api.g_exc_error;
3339:
3340: WHEN e_cancel_unpack_lpn_error THEN
3341: IF (g_asn_debug = 'Y') THEN
3342: asn_debug.put_line('wms_return_sv.cancel_return_order_RTV returned error!');
3343: END IF;
3344: fnd_msg_pub.count_and_get (p_encoded => 'T',
3345: p_count => l_msg_count,
3346: p_data => l_msg_data

Line 3357: IF (g_asn_debug = 'Y') THEN

3353: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);
3354: raise fnd_api.g_exc_error;
3355:
3356: WHEN e_cancel_lpn_wdd_error THEN
3357: IF (g_asn_debug = 'Y') THEN
3358: asn_debug.put_line('whs_container_actions.delete_containers returned error!');
3359: END IF;
3360: l_msg_data := fnd_msg_pub.get (1, 'F');
3361: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);

Line 3358: asn_debug.put_line('whs_container_actions.delete_containers returned error!');

3354: raise fnd_api.g_exc_error;
3355:
3356: WHEN e_cancel_lpn_wdd_error THEN
3357: IF (g_asn_debug = 'Y') THEN
3358: asn_debug.put_line('whs_container_actions.delete_containers returned error!');
3359: END IF;
3360: l_msg_data := fnd_msg_pub.get (1, 'F');
3361: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);
3362: raise fnd_api.g_exc_error;

Line 3366: IF (g_asn_debug = 'Y') THEN

3362: raise fnd_api.g_exc_error;
3363: -- RTV project phase 2 : end
3364:
3365: WHEN OTHERS THEN
3366: IF (g_asn_debug = 'Y') THEN
3367: asn_debug.put_line('Unexpected exception in cancel_rtv_lines : ' || SQLERRM);
3368: END IF;
3369: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', 'Unexpected exception', sqlcode);
3370: raise fnd_api.g_exc_unexpected_error;

Line 3367: asn_debug.put_line('Unexpected exception in cancel_rtv_lines : ' || SQLERRM);

3363: -- RTV project phase 2 : end
3364:
3365: WHEN OTHERS THEN
3366: IF (g_asn_debug = 'Y') THEN
3367: asn_debug.put_line('Unexpected exception in cancel_rtv_lines : ' || SQLERRM);
3368: END IF;
3369: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', 'Unexpected exception', sqlcode);
3370: raise fnd_api.g_exc_unexpected_error;
3371: END cancel_rtv_lines;