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.INV_EXPRESS_PICK_PUB dependencies on INV_EXPRESS_PICK_PUB

Line 1: PACKAGE BODY INV_EXPRESS_PICK_PUB AS

1: PACKAGE BODY INV_EXPRESS_PICK_PUB AS
2: /* $Header: INVEXPRB.pls 120.4 2006/09/14 10:13:15 bradha noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_EXPRESS_PICK_PUB';
4: g_true VARCHAR2(10) := 'T';
5: g_pr_status_cntr NUMBER :=0;

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_EXPRESS_PICK_PUB';

1: PACKAGE BODY INV_EXPRESS_PICK_PUB AS
2: /* $Header: INVEXPRB.pls 120.4 2006/09/14 10:13:15 bradha noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_EXPRESS_PICK_PUB';
4: g_true VARCHAR2(10) := 'T';
5: g_pr_status_cntr NUMBER :=0;
6: /* Cached values for locator control of Org and Sub */
7: g_organization_id NUMBER;

Line 39: print_debug('Inventory Cache Set Item Rec Failed', 'INV_Express_Pick_Pub.Check_Detailed_Rsv');

35: Return False;
36: END IF;
37:
38: IF NOT INV_CACHE.set_item_rec(p_mo_line_rec.organization_id, p_mo_line_rec.inventory_item_id) THEN
39: print_debug('Inventory Cache Set Item Rec Failed', 'INV_Express_Pick_Pub.Check_Detailed_Rsv');
40: RAISE fnd_api.g_exc_unexpected_error;
41: END IF;
42:
43: If (inv_cache.item_rec.lot_control_code = 2) AND l_detailed THEN

Line 70: print_debug('Inventory Cache Set ToSub Rec Failed', 'INV_Express_Pick_Pub.Check_Detailed_Rsv');

66: IF p_mo_line_rec.organization_id <> nvl(g_organization_id,-9999) OR
67: p_reservation_rec.subinventory_code <> nvl(g_subinventory_code,'-9999') THEN
68:
69: IF NOT INV_CACHE.set_tosub_rec(p_mo_line_rec.organization_id, p_reservation_rec.subinventory_code) THEN
70: print_debug('Inventory Cache Set ToSub Rec Failed', 'INV_Express_Pick_Pub.Check_Detailed_Rsv');
71: RAISE fnd_api.g_exc_unexpected_error;
72: END IF;
73:
74: IF NOT INV_CACHE.set_org_rec(p_mo_line_rec.organization_id) THEN

Line 75: print_debug('Inventory Cache Set ORG Rec Failed', 'INV_Express_Pick_Pub.Check_Detailed_Rsv');

71: RAISE fnd_api.g_exc_unexpected_error;
72: END IF;
73:
74: IF NOT INV_CACHE.set_org_rec(p_mo_line_rec.organization_id) THEN
75: print_debug('Inventory Cache Set ORG Rec Failed', 'INV_Express_Pick_Pub.Check_Detailed_Rsv');
76: RAISE fnd_api.g_exc_unexpected_error;
77: END IF;
78:
79: g_organization_id := p_mo_line_rec.organization_id;

Line 105: ,p_pick_release_status_tbl OUT NOCOPY inv_express_pick_pub.p_pick_release_status_tbl

101: ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE
102: ,p_grouping_rule_id IN NUMBER
103: ,p_allow_partial_pick IN VARCHAR2
104: ,p_reservations_tbl IN inv_reservation_global.mtl_reservation_tbl_type
105: ,p_pick_release_status_tbl OUT NOCOPY inv_express_pick_pub.p_pick_release_status_tbl
106: ) IS
107:
108: /*CURSOR c_rsv_rec (p_demand_source_type_id NUMBER
109: ,p_demand_source_line_id NUMBER) IS

Line 212: print_debug('Inside Express Pick_Release', 'INV_Express_Pick_Pub.Pick_Release');

208: END IF;
209:
210: -- Set savepoint for this API
211: If is_debug then
212: print_debug('Inside Express Pick_Release', 'INV_Express_Pick_Pub.Pick_Release');
213: End If;
214:
215: SAVEPOINT EXPRESS_PICK_RELEASE;
216:

Line 221: print_debug('Fnd_APi not compatible','INV_Express_Pick_Pub.Pick_Release');

217: -- Standard Call to check for call compatibility
218: IF NOT fnd_api.Compatible_API_Call(l_api_version , p_api_version ,
219: l_api_name , G_PKG_NAME) THEN
220: If is_debug then
221: print_debug('Fnd_APi not compatible','INV_Express_Pick_Pub.Pick_Release');
222: End If;
223: RAISE fnd_api.g_exc_unexpected_error;
224: END IF;
225:

Line 242: print_debug('No Lines to pick', 'INV_Express_Pick_Pub.Pick_Release');

238: -- any records
239: l_mo_line_count := p_mo_line_tbl.COUNT;
240: IF l_mo_line_count = 0 THEN
241: If is_debug then
242: print_debug('No Lines to pick', 'INV_Express_Pick_Pub.Pick_Release');
243: End If;
244:
245: ROLLBACK TO EXPRESS_PICK_RELEASE;
246: FND_MESSAGE.SET_NAME('INV','INV_NO_LINES_TO_PICK');

Line 257: 'INV_Express_Pick_Pub.Pick_Release');

253: p_allow_partial_pick <> fnd_api.g_false THEN
254:
255: If is_debug then
256: print_debug('Error: invalid partial pick parameter',
257: 'INV_Express_Pick_Pub.Pick_Release');
258: End If;
259: ROLLBACK TO Express_Pick_Release;
260: FND_MESSAGE.SET_NAME('INV','INV_INVALID_PARTIAL_PICK_PARAM');
261: FND_MSG_PUB.Add;

Line 277: 'Inv_Express_Pick_Pub.Pick_Release');

273: to end of failed shipset */
274: l_loop_index := l_line_index + 1;
275: If is_debug then
276: print_debug('Loop through delivery details',
277: 'Inv_Express_Pick_Pub.Pick_Release');
278: End If;
279: IF p_mo_line_tbl(l_line_index).ship_set_id IS NOT NULL AND
280: (l_cur_ship_set_id IS NULL OR
281: l_cur_ship_set_id <> p_mo_line_tbl(l_line_index).ship_set_id) THEN

Line 289: 'Inv_Express_Pick_Pub.Pick_Release');

285: l_ship_set_start_index := l_line_index;
286: l_ship_set_start_status := g_pr_status_cntr;
287: If is_debug then
288: print_debug('Start Shipset :' || l_cur_ship_set_id,
289: 'Inv_Express_Pick_Pub.Pick_Release');
290: End If;
291: ELSIF l_cur_ship_set_id IS NOT NULL AND
292: p_mo_line_tbl(l_line_index).ship_set_id IS NULL THEN
293: If is_debug then

Line 295: 'Inv_Express_Pick_Pub.Pick_Release');

291: ELSIF l_cur_ship_set_id IS NOT NULL AND
292: p_mo_line_tbl(l_line_index).ship_set_id IS NULL THEN
293: If is_debug then
294: print_debug('End of Shipset :' || l_cur_ship_set_id,
295: 'Inv_Express_Pick_Pub.Pick_Release');
296: End If;
297: l_cur_ship_set_id := NULL;
298: l_ship_set_start_index := NULL;
299: l_ship_set_start_status := NULL;

Line 305: 'Inv_Express_Pick_Pub.Pick_Release');

301:
302: If is_debug then
303: print_debug('Current positions - line_index : ' || l_line_index ||
304: ' g_pr_status_cntr : ' || g_pr_status_cntr,
305: 'Inv_Express_Pick_Pub.Pick_Release');
306: End If;
307: l_delivery_detail_id:= p_mo_line_tbl(l_line_index).txn_source_line_detail_id;
308: p_pick_release_status_tbl(g_pr_status_cntr).delivery_detail_id := l_delivery_detail_id;
309:

Line 311: print_debug('Inventory Cache Set Transaction Type Rec Failed', 'INV_Express_Pick_Pub.Pick_Release');

307: l_delivery_detail_id:= p_mo_line_tbl(l_line_index).txn_source_line_detail_id;
308: p_pick_release_status_tbl(g_pr_status_cntr).delivery_detail_id := l_delivery_detail_id;
309:
310: IF NOT INV_CACHE.set_mtt_rec(p_mo_line_tbl(l_line_index).transaction_type_id) THEN
311: print_debug('Inventory Cache Set Transaction Type Rec Failed', 'INV_Express_Pick_Pub.Pick_Release');
312: RAISE fnd_api.g_exc_unexpected_error;
313: END IF;
314:
315: l_source_type_id := inv_cache.mtt_rec.transaction_source_type_id;

Line 320: 'Inv_Express_Pick_Pub.Pick_Release');

316: l_source_line_id := p_mo_line_tbl(l_line_index).TXN_source_line_id;
317:
318: If is_debug then
319: print_debug('Checking reservations for Delivery Detail : ' || l_delivery_detail_id,
320: 'Inv_Express_Pick_Pub.Pick_Release');
321: End If;
322: /* Get All Unstaged reservations for SALES ORDER LINE */
323: /* and ignore all unstaged or non detailed reservations */
324: l_rsv_count := 0;

Line 348: || x_return_status, 'Inv_Express_Pick_Pub.Pick_Release');

344: );
345:
346: IF is_debug then
347: print_debug('l_return_status from query_reservation is '
348: || x_return_status, 'Inv_Express_Pick_Pub.Pick_Release');
349: End If;
350:
351: IF x_return_status = fnd_api.g_ret_sts_error THEN
352: IF is_debug then

Line 354: 'Inv_Express_Pick_Pub.Pick_release');

350:
351: IF x_return_status = fnd_api.g_ret_sts_error THEN
352: IF is_debug then
353: print_debug('Error from INV_QUANTITY_TREE_PVT.Lock_Tree',
354: 'Inv_Express_Pick_Pub.Pick_release');
355: END IF;
356: RAISE fnd_api.g_exc_error ;
357: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
358: If is_debug then

Line 360: 'Inv_Express_Pick_Pub.Pick_release');

356: RAISE fnd_api.g_exc_error ;
357: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
358: If is_debug then
359: print_debug('Unexpected error from INV_QUANTITY_TREE_PVT.Lock_Tree',
360: 'Inv_Express_Pick_Pub.Pick_release');
361: End If;
362: RAISE fnd_api.g_exc_unexpected_error;
363: END IF;
364: /*Bug3237610 ends*/

Line 367: print_debug('Number of reservations ' || l_rsv_count, 'Inv_Express_Pick_Pub.Pick_Release');

363: END IF;
364: /*Bug3237610 ends*/
365:
366: If is_debug then
367: print_debug('Number of reservations ' || l_rsv_count, 'Inv_Express_Pick_Pub.Pick_Release');
368: End If;
369: l_rsv_start := 1;
370: --l_rsv_count := l_rsv_rec_tbl.count;
371: FOR l_counter IN l_rsv_start..l_rsv_count LOOP

Line 377: print_debug('Check whether reservation detailed rsv id : ' || l_rsv_rec_ret_tbl(l_counter).reservation_id, 'Inv_Express_Pick_Pub.Pick_Release');

373:
374: --Added bug3237610
375:
376: If is_debug then
377: print_debug('Check whether reservation detailed rsv id : ' || l_rsv_rec_ret_tbl(l_counter).reservation_id, 'Inv_Express_Pick_Pub.Pick_Release');
378: End If;
379: inv_staged_reservation_util.query_staged_flag
380: (x_return_status => x_return_status
381: ,x_msg_count => x_msg_count

Line 388: || x_return_status, 'Inv_Express_Pick_Pub.Pick_Release');

384: ,p_reservation_id => l_rsv_rec_ret_tbl(l_counter).reservation_id);
385:
386: IF is_debug then
387: print_debug('l_return_status from query_staged_flag is '
388: || x_return_status, 'Inv_Express_Pick_Pub.Pick_Release');
389: End If;
390:
391: IF x_return_status = fnd_api.g_ret_sts_error THEN
392: IF is_debug then

Line 394: 'Inv_Express_Pick_Pub.Pick_release');

390:
391: IF x_return_status = fnd_api.g_ret_sts_error THEN
392: IF is_debug then
393: print_debug('Error from INV_QUANTITY_TREE_PVT.Lock_Tree',
394: 'Inv_Express_Pick_Pub.Pick_release');
395: END IF;
396: RAISE fnd_api.g_exc_error ;
397: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
398: If is_debug then

Line 400: 'Inv_Express_Pick_Pub.Pick_release');

396: RAISE fnd_api.g_exc_error ;
397: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
398: If is_debug then
399: print_debug('Unexpected error from INV_QUANTITY_TREE_PVT.Lock_Tree',
400: 'Inv_Express_Pick_Pub.Pick_release');
401: End If;
402: RAISE fnd_api.g_exc_unexpected_error;
403: END IF;
404: --End bug3237610

Line 412: print_debug('Reservation is Detailed' || l_dtl_rsv_count, 'Inv_Express_Pick_Pub.Pick_Release');

408: l_dtl_rsv_count := l_dtl_rsv_count +1;
409: l_rsv_rec_tbl(l_dtl_rsv_count):= l_rsv_rec_ret_tbl(l_counter);
410: l_rsv_qty := l_rsv_qty+l_rsv_rec_ret_tbl(l_counter).primary_reservation_quantity;
411: If is_debug then
412: print_debug('Reservation is Detailed' || l_dtl_rsv_count, 'Inv_Express_Pick_Pub.Pick_Release');
413: End If;
414: END IF;
415: END IF;
416: END LOOP;

Line 421: print_debug('Quantity required to be Detailed ' || l_dd_qty, 'Inv_Express_Pick_Pub.Pick_Release');

417:
418: l_dd_qty := p_mo_line_tbl(l_line_index).quantity ;
419: /* This is expected quantity to Pick release */
420: If is_debug then
421: print_debug('Quantity required to be Detailed ' || l_dd_qty, 'Inv_Express_Pick_Pub.Pick_Release');
422: print_debug('Quantity in detailed reservations' || l_rsv_qty, 'Inv_Express_Pick_Pub.Pick_Release');
423: print_debug('Current Ship Set ' || l_cur_ship_set_id, 'Inv_Express_Pick_Pub.Pick_Release');
424: End If;
425:

Line 422: print_debug('Quantity in detailed reservations' || l_rsv_qty, 'Inv_Express_Pick_Pub.Pick_Release');

418: l_dd_qty := p_mo_line_tbl(l_line_index).quantity ;
419: /* This is expected quantity to Pick release */
420: If is_debug then
421: print_debug('Quantity required to be Detailed ' || l_dd_qty, 'Inv_Express_Pick_Pub.Pick_Release');
422: print_debug('Quantity in detailed reservations' || l_rsv_qty, 'Inv_Express_Pick_Pub.Pick_Release');
423: print_debug('Current Ship Set ' || l_cur_ship_set_id, 'Inv_Express_Pick_Pub.Pick_Release');
424: End If;
425:
426:

Line 423: print_debug('Current Ship Set ' || l_cur_ship_set_id, 'Inv_Express_Pick_Pub.Pick_Release');

419: /* This is expected quantity to Pick release */
420: If is_debug then
421: print_debug('Quantity required to be Detailed ' || l_dd_qty, 'Inv_Express_Pick_Pub.Pick_Release');
422: print_debug('Quantity in detailed reservations' || l_rsv_qty, 'Inv_Express_Pick_Pub.Pick_Release');
423: print_debug('Current Ship Set ' || l_cur_ship_set_id, 'Inv_Express_Pick_Pub.Pick_Release');
424: End If;
425:
426:
427: IF (l_rsv_qty > 0) AND

Line 443: || x_return_status, 'Inv_Express_Pick_Pub.Pick_Release');

439: , p_inventory_item_id => p_mo_line_tbl(l_line_index).inventory_item_id);
440:
441: IF is_debug then
442: print_debug('l_return_status from lock_tree is '
443: || x_return_status, 'Inv_Express_Pick_Pub.Pick_Release');
444: End If;
445:
446: IF x_return_status = fnd_api.g_ret_sts_error THEN
447: IF is_debug then

Line 449: 'Inv_Express_Pick_Pub.Pick_release');

445:
446: IF x_return_status = fnd_api.g_ret_sts_error THEN
447: IF is_debug then
448: print_debug('Error from INV_QUANTITY_TREE_PVT.Lock_Tree',
449: 'Inv_Express_Pick_Pub.Pick_release');
450: END IF;
451: RAISE fnd_api.g_exc_error ;
452: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
453: If is_debug then

Line 455: 'Inv_Express_Pick_Pub.Pick_release');

451: RAISE fnd_api.g_exc_error ;
452: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
453: If is_debug then
454: print_debug('Unexpected error from INV_QUANTITY_TREE_PVT.Lock_Tree',
455: 'Inv_Express_Pick_Pub.Pick_release');
456: End If;
457: RAISE fnd_api.g_exc_unexpected_error;
458: END IF;
459:

Line 470: 'Inv_Express_Pick_Pub.Pick_release');

466:
467: IF x_return_status = fnd_api.g_ret_sts_error THEN
468: IF is_debug then
469: print_debug('Error from Stage_DD_RSV',
470: 'Inv_Express_Pick_Pub.Pick_release');
471: END IF;
472: RAISE fnd_api.g_exc_error ;
473: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
474: If is_debug then

Line 476: 'Inv_Express_Pick_Pub.Pick_release');

472: RAISE fnd_api.g_exc_error ;
473: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
474: If is_debug then
475: print_debug('Unexpected error from Stage DD RSV',
476: 'Inv_Express_Pick_Pub.Pick_release');
477: End If;
478: RAISE fnd_api.g_exc_unexpected_error;
479: END IF;
480:

Line 489: 'Inv_Express_Pick_Pub.Pick_Release');

485: -- rollback all allocations and then Skip all delivery details in Ship Set
486: -- Report skipped status to shipping
487: If is_debug then
488: print_debug('Update shipping that ship set detailing failed',
489: 'Inv_Express_Pick_Pub.Pick_Release');
490: End If;
491:
492: If l_cur_ship_set_id is not null then
493: If is_debug then

Line 495: 'Inv_Express_Pick_Pub.Pick_Release');

491:
492: If l_cur_ship_set_id is not null then
493: If is_debug then
494: print_debug('Rollback for shipset :' || l_cur_ship_set_id,
495: 'Inv_Express_Pick_Pub.Pick_Release');
496: End If;
497:
498: ROLLBACK TO SHIPSET;
499: l_loop_index :=l_ship_set_start_index;

Line 535: print_debug('SQLERRM'||SQLERRM, 'Inv_Express_Pick_Pub.Pick_Release');

531: EXCEPTION
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: ROLLBACK TO EXPRESS_PICK_RELEASE;
534: --dbms_output.put_line('SQLERRM'||SQLERRM);
535: print_debug('SQLERRM'||SQLERRM, 'Inv_Express_Pick_Pub.Pick_Release');
536: --
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: --
539: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 559: ,p_pick_release_status_tbl IN OUT NOCOPY INV_EXPRESS_PICK_PUB.p_pick_release_status_tbl

555:
556:
557: PROCEDURE STAGE_DD_RSV(P_mo_line_REC IN INV_Move_Order_PUB.Trolin_Rec_Type
558: ,p_Reservation_tbl IN inv_reservation_global.mtl_reservation_tbl_type
559: ,p_pick_release_status_tbl IN OUT NOCOPY INV_EXPRESS_PICK_PUB.p_pick_release_status_tbl
560: , x_return_status OUT NOCOPY VARCHAR2
561: , x_msg_count OUT NOCOPY NUMBER
562: , x_msg_data OUT NOCOPY VARCHAR2) IS
563: /*This API stage a Delivery detail if reservations are detailed

Line 646: print_debug('Inventory Cache Set Item Rec Failed', 'INV_Express_Pick_Pub.Pick_Release');

642:
643: BEGIN
644: x_return_status :=fnd_api.g_ret_sts_success;
645: IF NOT INV_CACHE.set_item_rec(p_mo_line_rec.organization_id, p_mo_line_rec.inventory_item_id) THEN
646: print_debug('Inventory Cache Set Item Rec Failed', 'INV_Express_Pick_Pub.Pick_Release');
647: RAISE fnd_api.g_exc_unexpected_error;
648: END IF;
649: IF inv_cache.item_rec.serial_number_control_code NOT IN (1,6) then
650: print_debug('Item is Serialized ','INV_Express_Pick_Pub.Pick_Release');

Line 650: print_debug('Item is Serialized ','INV_Express_Pick_Pub.Pick_Release');

646: print_debug('Inventory Cache Set Item Rec Failed', 'INV_Express_Pick_Pub.Pick_Release');
647: RAISE fnd_api.g_exc_unexpected_error;
648: END IF;
649: IF inv_cache.item_rec.serial_number_control_code NOT IN (1,6) then
650: print_debug('Item is Serialized ','INV_Express_Pick_Pub.Pick_Release');
651: is_serial_controlled :=true;
652: END IF;
653:
654: l_rsv_rec_tbl :=p_Reservation_tbl;

Line 668: print_debug('Reservation count '||l_rsv_count,'INV_Express_Pick_Pub.Pick_Release');

664: l_rsv_index := l_rsv_rec_tbl.FIRST;
665: l_rsv_count :=l_rsv_rec_tbl.count;
666: l_rsv_last_index :=l_rsv_rec_tbl.LAST;
667: print_debug(' l_rsv_last_index '||l_rsv_last_index,'EXPRESS_PICK');
668: print_debug('Reservation count '||l_rsv_count,'INV_Express_Pick_Pub.Pick_Release');
669: LOOP
670: l_original_rsv_rec := l_rsv_rec_tbl(l_rsv_index);
671: l_new_rsv_rec :=l_original_rsv_rec;
672: l_new_rsv_rec.reservation_id:=NULL;

Line 675: print_debug('l_current_reserved_qty '||l_reserved_qty,'INV_Express_Pick_Pub.Pick_Release');

671: l_new_rsv_rec :=l_original_rsv_rec;
672: l_new_rsv_rec.reservation_id:=NULL;
673: l_reserved_qty := l_original_rsv_rec.primary_reservation_quantity;
674: l_reserved_sec_qty := l_original_rsv_rec.secondary_reservation_quantity; --INVCONV KKILLAMS
675: print_debug('l_current_reserved_qty '||l_reserved_qty,'INV_Express_Pick_Pub.Pick_Release');
676: print_debug('l_remain_dd_qty 1 '||l_remain_dd_qty,'INV_Express_Pick_Pub.Pick_Release');
677: IF l_remain_dd_qty >l_reserved_qty THEN
678: l_new_rsv_rec.primary_reservation_quantity :=l_reserved_qty;
679: l_new_rsv_rec.reservation_quantity :=NULL;

Line 676: print_debug('l_remain_dd_qty 1 '||l_remain_dd_qty,'INV_Express_Pick_Pub.Pick_Release');

672: l_new_rsv_rec.reservation_id:=NULL;
673: l_reserved_qty := l_original_rsv_rec.primary_reservation_quantity;
674: l_reserved_sec_qty := l_original_rsv_rec.secondary_reservation_quantity; --INVCONV KKILLAMS
675: print_debug('l_current_reserved_qty '||l_reserved_qty,'INV_Express_Pick_Pub.Pick_Release');
676: print_debug('l_remain_dd_qty 1 '||l_remain_dd_qty,'INV_Express_Pick_Pub.Pick_Release');
677: IF l_remain_dd_qty >l_reserved_qty THEN
678: l_new_rsv_rec.primary_reservation_quantity :=l_reserved_qty;
679: l_new_rsv_rec.reservation_quantity :=NULL;
680: l_remain_dd_qty :=l_remain_dd_qty -l_reserved_qty;

Line 703: print_debug('modified l_remain_dd_qty 1 '||l_remain_dd_qty,'INV_Express_Pick_Pub.Pick_Release');

699:
700: IF l_new_rsv_rec.secondary_reservation_quantity = 0 THEN
701: l_new_rsv_rec.secondary_reservation_quantity := NULL;
702: END IF;
703: print_debug('modified l_remain_dd_qty 1 '||l_remain_dd_qty,'INV_Express_Pick_Pub.Pick_Release');
704: IF IS_SERIAL_CONTROLLED THEN
705: print_debug('Calling Pick serial Numbers ','INV_Express_Pick_Pub.Pick_Release');
706: PICK_SERIAL_NUMBERS(
707: p_inventory_item_id =>l_new_rsv_rec .inventory_item_id

Line 705: print_debug('Calling Pick serial Numbers ','INV_Express_Pick_Pub.Pick_Release');

701: l_new_rsv_rec.secondary_reservation_quantity := NULL;
702: END IF;
703: print_debug('modified l_remain_dd_qty 1 '||l_remain_dd_qty,'INV_Express_Pick_Pub.Pick_Release');
704: IF IS_SERIAL_CONTROLLED THEN
705: print_debug('Calling Pick serial Numbers ','INV_Express_Pick_Pub.Pick_Release');
706: PICK_SERIAL_NUMBERS(
707: p_inventory_item_id =>l_new_rsv_rec .inventory_item_id
708: , p_organization_id => l_new_rsv_rec.organization_id
709: , p_revision => l_new_rsv_rec.revision

Line 724: print_debug('return status '||l_return_status,'INV_Express_Pick_Pub.Pick_Release');

720: , x_msg_count => l_msg_count
721: , x_msg_data => l_msg_data
722: , x_serial_number => x_serial_number -- Bug 5517498
723: );
724: print_debug('return status '||l_return_status,'INV_Express_Pick_Pub.Pick_Release');
725: print_debug('g_transaction_temp_id'||g_transaction_temp_id,'INV_Express_Pick_Pub.Pick_Release');
726: print_debug('Available Serial qty'||x_available_sl_qty,'INV_Express_Pick_Pub.Pick_Release');
727: print_debug('x_serial_index'||x_serial_index,'INV_Express_Pick_Pub.Pick_Release');
728: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 725: print_debug('g_transaction_temp_id'||g_transaction_temp_id,'INV_Express_Pick_Pub.Pick_Release');

721: , x_msg_data => l_msg_data
722: , x_serial_number => x_serial_number -- Bug 5517498
723: );
724: print_debug('return status '||l_return_status,'INV_Express_Pick_Pub.Pick_Release');
725: print_debug('g_transaction_temp_id'||g_transaction_temp_id,'INV_Express_Pick_Pub.Pick_Release');
726: print_debug('Available Serial qty'||x_available_sl_qty,'INV_Express_Pick_Pub.Pick_Release');
727: print_debug('x_serial_index'||x_serial_index,'INV_Express_Pick_Pub.Pick_Release');
728: IF l_return_status = fnd_api.g_ret_sts_error THEN
729: RAISE fnd_api.g_exc_error;

Line 726: print_debug('Available Serial qty'||x_available_sl_qty,'INV_Express_Pick_Pub.Pick_Release');

722: , x_serial_number => x_serial_number -- Bug 5517498
723: );
724: print_debug('return status '||l_return_status,'INV_Express_Pick_Pub.Pick_Release');
725: print_debug('g_transaction_temp_id'||g_transaction_temp_id,'INV_Express_Pick_Pub.Pick_Release');
726: print_debug('Available Serial qty'||x_available_sl_qty,'INV_Express_Pick_Pub.Pick_Release');
727: print_debug('x_serial_index'||x_serial_index,'INV_Express_Pick_Pub.Pick_Release');
728: IF l_return_status = fnd_api.g_ret_sts_error THEN
729: RAISE fnd_api.g_exc_error;
730: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 727: print_debug('x_serial_index'||x_serial_index,'INV_Express_Pick_Pub.Pick_Release');

723: );
724: print_debug('return status '||l_return_status,'INV_Express_Pick_Pub.Pick_Release');
725: print_debug('g_transaction_temp_id'||g_transaction_temp_id,'INV_Express_Pick_Pub.Pick_Release');
726: print_debug('Available Serial qty'||x_available_sl_qty,'INV_Express_Pick_Pub.Pick_Release');
727: print_debug('x_serial_index'||x_serial_index,'INV_Express_Pick_Pub.Pick_Release');
728: IF l_return_status = fnd_api.g_ret_sts_error THEN
729: RAISE fnd_api.g_exc_error;
730: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
731: RAISE fnd_api.g_exc_unexpected_error;

Line 1259: END INV_EXPRESS_PICK_PUB;

1255: fnd_msg_pub.add_exc_msg('Pick Serial Numbers', 'PICK Serial Numbers ');
1256: end if;
1257:
1258: END pick_serial_numbers;
1259: END INV_EXPRESS_PICK_PUB;