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

APPS.OE_ORDER_IMPORT_RESERVE_PVT dependencies on FND_API

Line 54: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

50: l_qty_already_rsv_global NUMBER := 0;
51: l_qty_to_reserve NUMBER := 0;
52: l_msg_count NUMBER;
53: l_msg_data VARCHAR2(2000);
54: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
55: l_reservable_type NUMBER;
56: -- INVCONV
57:
58: l_qty2_already_rsv_loop NUMBER := 0;

Line 103: -- IF (nvl(l_reservation_tbl(I).revision, FND_API.G_MISS_CHAR)

99: IF l_debug_level > 0 THEN
100: oe_debug_pub.add( 'ORD_QTY: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORDERED_QUANTITY ) ;
101: END IF;
102: -- Following code can be removed yet to confirm with old release
103: -- IF (nvl(l_reservation_tbl(I).revision, FND_API.G_MISS_CHAR)
104: -- <> FND_API.G_MISS_CHAR OR
105: -- nvl(l_reservation_tbl(I).lot_number_id, FND_API.G_MISS_NUM)
106: -- <> FND_API.G_MISS_NUM OR
107: -- nvl(l_reservation_val_tbl(I).lot_number, FND_API.G_MISS_CHAR)

Line 104: -- <> FND_API.G_MISS_CHAR OR

100: oe_debug_pub.add( 'ORD_QTY: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORDERED_QUANTITY ) ;
101: END IF;
102: -- Following code can be removed yet to confirm with old release
103: -- IF (nvl(l_reservation_tbl(I).revision, FND_API.G_MISS_CHAR)
104: -- <> FND_API.G_MISS_CHAR OR
105: -- nvl(l_reservation_tbl(I).lot_number_id, FND_API.G_MISS_NUM)
106: -- <> FND_API.G_MISS_NUM OR
107: -- nvl(l_reservation_val_tbl(I).lot_number, FND_API.G_MISS_CHAR)
108: -- <> FND_API.G_MISS_CHAR OR

Line 105: -- nvl(l_reservation_tbl(I).lot_number_id, FND_API.G_MISS_NUM)

101: END IF;
102: -- Following code can be removed yet to confirm with old release
103: -- IF (nvl(l_reservation_tbl(I).revision, FND_API.G_MISS_CHAR)
104: -- <> FND_API.G_MISS_CHAR OR
105: -- nvl(l_reservation_tbl(I).lot_number_id, FND_API.G_MISS_NUM)
106: -- <> FND_API.G_MISS_NUM OR
107: -- nvl(l_reservation_val_tbl(I).lot_number, FND_API.G_MISS_CHAR)
108: -- <> FND_API.G_MISS_CHAR OR
109: -- nvl(l_reservation_tbl(I).subinventory_id, FND_API.G_MISS_NUM)

Line 106: -- <> FND_API.G_MISS_NUM OR

102: -- Following code can be removed yet to confirm with old release
103: -- IF (nvl(l_reservation_tbl(I).revision, FND_API.G_MISS_CHAR)
104: -- <> FND_API.G_MISS_CHAR OR
105: -- nvl(l_reservation_tbl(I).lot_number_id, FND_API.G_MISS_NUM)
106: -- <> FND_API.G_MISS_NUM OR
107: -- nvl(l_reservation_val_tbl(I).lot_number, FND_API.G_MISS_CHAR)
108: -- <> FND_API.G_MISS_CHAR OR
109: -- nvl(l_reservation_tbl(I).subinventory_id, FND_API.G_MISS_NUM)
110: -- <> FND_API.G_MISS_NUM OR

Line 107: -- nvl(l_reservation_val_tbl(I).lot_number, FND_API.G_MISS_CHAR)

103: -- IF (nvl(l_reservation_tbl(I).revision, FND_API.G_MISS_CHAR)
104: -- <> FND_API.G_MISS_CHAR OR
105: -- nvl(l_reservation_tbl(I).lot_number_id, FND_API.G_MISS_NUM)
106: -- <> FND_API.G_MISS_NUM OR
107: -- nvl(l_reservation_val_tbl(I).lot_number, FND_API.G_MISS_CHAR)
108: -- <> FND_API.G_MISS_CHAR OR
109: -- nvl(l_reservation_tbl(I).subinventory_id, FND_API.G_MISS_NUM)
110: -- <> FND_API.G_MISS_NUM OR
111: -- nvl(l_reservation_val_tbl(I).subinventory_code, FND_API.G_MISS_CHAR)

Line 108: -- <> FND_API.G_MISS_CHAR OR

104: -- <> FND_API.G_MISS_CHAR OR
105: -- nvl(l_reservation_tbl(I).lot_number_id, FND_API.G_MISS_NUM)
106: -- <> FND_API.G_MISS_NUM OR
107: -- nvl(l_reservation_val_tbl(I).lot_number, FND_API.G_MISS_CHAR)
108: -- <> FND_API.G_MISS_CHAR OR
109: -- nvl(l_reservation_tbl(I).subinventory_id, FND_API.G_MISS_NUM)
110: -- <> FND_API.G_MISS_NUM OR
111: -- nvl(l_reservation_val_tbl(I).subinventory_code, FND_API.G_MISS_CHAR)
112: -- <> FND_API.G_MISS_CHAR OR

Line 109: -- nvl(l_reservation_tbl(I).subinventory_id, FND_API.G_MISS_NUM)

105: -- nvl(l_reservation_tbl(I).lot_number_id, FND_API.G_MISS_NUM)
106: -- <> FND_API.G_MISS_NUM OR
107: -- nvl(l_reservation_val_tbl(I).lot_number, FND_API.G_MISS_CHAR)
108: -- <> FND_API.G_MISS_CHAR OR
109: -- nvl(l_reservation_tbl(I).subinventory_id, FND_API.G_MISS_NUM)
110: -- <> FND_API.G_MISS_NUM OR
111: -- nvl(l_reservation_val_tbl(I).subinventory_code, FND_API.G_MISS_CHAR)
112: -- <> FND_API.G_MISS_CHAR OR
113: -- nvl(l_reservation_tbl(I).locator_id, FND_API.G_MISS_NUM)

Line 110: -- <> FND_API.G_MISS_NUM OR

106: -- <> FND_API.G_MISS_NUM OR
107: -- nvl(l_reservation_val_tbl(I).lot_number, FND_API.G_MISS_CHAR)
108: -- <> FND_API.G_MISS_CHAR OR
109: -- nvl(l_reservation_tbl(I).subinventory_id, FND_API.G_MISS_NUM)
110: -- <> FND_API.G_MISS_NUM OR
111: -- nvl(l_reservation_val_tbl(I).subinventory_code, FND_API.G_MISS_CHAR)
112: -- <> FND_API.G_MISS_CHAR OR
113: -- nvl(l_reservation_tbl(I).locator_id, FND_API.G_MISS_NUM)
114: -- <> FND_API.G_MISS_NUM)

Line 111: -- nvl(l_reservation_val_tbl(I).subinventory_code, FND_API.G_MISS_CHAR)

107: -- nvl(l_reservation_val_tbl(I).lot_number, FND_API.G_MISS_CHAR)
108: -- <> FND_API.G_MISS_CHAR OR
109: -- nvl(l_reservation_tbl(I).subinventory_id, FND_API.G_MISS_NUM)
110: -- <> FND_API.G_MISS_NUM OR
111: -- nvl(l_reservation_val_tbl(I).subinventory_code, FND_API.G_MISS_CHAR)
112: -- <> FND_API.G_MISS_CHAR OR
113: -- nvl(l_reservation_tbl(I).locator_id, FND_API.G_MISS_NUM)
114: -- <> FND_API.G_MISS_NUM)
115: -- Upto Here

Line 112: -- <> FND_API.G_MISS_CHAR OR

108: -- <> FND_API.G_MISS_CHAR OR
109: -- nvl(l_reservation_tbl(I).subinventory_id, FND_API.G_MISS_NUM)
110: -- <> FND_API.G_MISS_NUM OR
111: -- nvl(l_reservation_val_tbl(I).subinventory_code, FND_API.G_MISS_CHAR)
112: -- <> FND_API.G_MISS_CHAR OR
113: -- nvl(l_reservation_tbl(I).locator_id, FND_API.G_MISS_NUM)
114: -- <> FND_API.G_MISS_NUM)
115: -- Upto Here
116: -- Changed following line AND to IF

Line 113: -- nvl(l_reservation_tbl(I).locator_id, FND_API.G_MISS_NUM)

109: -- nvl(l_reservation_tbl(I).subinventory_id, FND_API.G_MISS_NUM)
110: -- <> FND_API.G_MISS_NUM OR
111: -- nvl(l_reservation_val_tbl(I).subinventory_code, FND_API.G_MISS_CHAR)
112: -- <> FND_API.G_MISS_CHAR OR
113: -- nvl(l_reservation_tbl(I).locator_id, FND_API.G_MISS_NUM)
114: -- <> FND_API.G_MISS_NUM)
115: -- Upto Here
116: -- Changed following line AND to IF
117: -- AND (l_reservation_tbl(I).quantity > 0)

Line 114: -- <> FND_API.G_MISS_NUM)

110: -- <> FND_API.G_MISS_NUM OR
111: -- nvl(l_reservation_val_tbl(I).subinventory_code, FND_API.G_MISS_CHAR)
112: -- <> FND_API.G_MISS_CHAR OR
113: -- nvl(l_reservation_tbl(I).locator_id, FND_API.G_MISS_NUM)
114: -- <> FND_API.G_MISS_NUM)
115: -- Upto Here
116: -- Changed following line AND to IF
117: -- AND (l_reservation_tbl(I).quantity > 0)
118: IF (l_reservation_tbl(I).quantity > 0)

Line 120: AND nvl(l_header_rec.header_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM

116: -- Changed following line AND to IF
117: -- AND (l_reservation_tbl(I).quantity > 0)
118: IF (l_reservation_tbl(I).quantity > 0)
119:
120: AND nvl(l_header_rec.header_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
121: AND nvl(l_line_tbl(l_reservation_tbl(I).line_index).line_id,
122: FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
123: -- This condition is removed for the bug 1579224 --
124: -- Single Org installation ------------------------

Line 122: FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM

118: IF (l_reservation_tbl(I).quantity > 0)
119:
120: AND nvl(l_header_rec.header_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
121: AND nvl(l_line_tbl(l_reservation_tbl(I).line_index).line_id,
122: FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
123: -- This condition is removed for the bug 1579224 --
124: -- Single Org installation ------------------------
125: -- AND nvl(l_line_tbl(l_reservation_tbl(I).line_index).org_id,
126: -- FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM

Line 126: -- FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM

122: FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
123: -- This condition is removed for the bug 1579224 --
124: -- Single Org installation ------------------------
125: -- AND nvl(l_line_tbl(l_reservation_tbl(I).line_index).org_id,
126: -- FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
127: -- This condition is changed for the bug 1817012 --
128: -- The check should be done with the schedule_ship_date
129: -- Also check for the Null condition during testing
130: -- AND nvl(l_line_tbl(l_reservation_tbl(I).line_index).request_date,

Line 131: -- FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE

127: -- This condition is changed for the bug 1817012 --
128: -- The check should be done with the schedule_ship_date
129: -- Also check for the Null condition during testing
130: -- AND nvl(l_line_tbl(l_reservation_tbl(I).line_index).request_date,
131: -- FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE
132: AND nvl(l_line_tbl(l_reservation_tbl(I).line_index).schedule_ship_date,
133: FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE
134: AND nvl(l_line_tbl(l_reservation_tbl(I).line_index).order_quantity_uom,
135: FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR

Line 133: FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE

129: -- Also check for the Null condition during testing
130: -- AND nvl(l_line_tbl(l_reservation_tbl(I).line_index).request_date,
131: -- FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE
132: AND nvl(l_line_tbl(l_reservation_tbl(I).line_index).schedule_ship_date,
133: FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE
134: AND nvl(l_line_tbl(l_reservation_tbl(I).line_index).order_quantity_uom,
135: FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
136: THEN
137: BEGIN

Line 135: FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR

131: -- FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE
132: AND nvl(l_line_tbl(l_reservation_tbl(I).line_index).schedule_ship_date,
133: FND_API.G_MISS_DATE) <> FND_API.G_MISS_DATE
134: AND nvl(l_line_tbl(l_reservation_tbl(I).line_index).order_quantity_uom,
135: FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
136: THEN
137: BEGIN
138: IF l_debug_level > 0 THEN
139: oe_debug_pub.add( 'BEFORE SETTING RESERVATION PARAMETERS' ) ;

Line 418: --p_return_status := FND_API.G_RET_STS_ERROR;

414: THEN
415:
416: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_MORE_ORD_QTY');
417: OE_MSG_PUB.Add;
418: --p_return_status := FND_API.G_RET_STS_ERROR;
419: --EXIT;
420: goto next_rec_rsrv;
421: END IF;
422:

Line 456: IF p_return_status NOT IN (FND_API.G_RET_STS_ERROR)

452: IF l_debug_level > 0 THEN
453: oe_debug_pub.add( 'AFTER CALLING CREATE_RESERVATION' ) ;
454: END IF;
455:
456: IF p_return_status NOT IN (FND_API.G_RET_STS_ERROR)
457: AND l_return_status IN (FND_API.G_RET_STS_ERROR,
458: FND_API.G_RET_STS_UNEXP_ERROR)
459: THEN
460: p_return_status := l_return_status;

Line 457: AND l_return_status IN (FND_API.G_RET_STS_ERROR,

453: oe_debug_pub.add( 'AFTER CALLING CREATE_RESERVATION' ) ;
454: END IF;
455:
456: IF p_return_status NOT IN (FND_API.G_RET_STS_ERROR)
457: AND l_return_status IN (FND_API.G_RET_STS_ERROR,
458: FND_API.G_RET_STS_UNEXP_ERROR)
459: THEN
460: p_return_status := l_return_status;
461: END IF;

Line 458: FND_API.G_RET_STS_UNEXP_ERROR)

454: END IF;
455:
456: IF p_return_status NOT IN (FND_API.G_RET_STS_ERROR)
457: AND l_return_status IN (FND_API.G_RET_STS_ERROR,
458: FND_API.G_RET_STS_UNEXP_ERROR)
459: THEN
460: p_return_status := l_return_status;
461: END IF;
462:

Line 469: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

465: IF l_debug_level > 0 THEN
466: oe_debug_pub.add( 'UNEXPECTED ERROR IN RESERVE_INVENTORY: '||SQLERRM ) ;
467: END IF;
468: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
469: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Reserve_Inventory');
471: END IF;
472:
473: END;

Line 526: ,p_init_msg_lst => FND_API.G_TRUE

522: END IF;
523:
524: INV_RESERVATION_PUB.Create_Reservation (
525: p_api_version_number => 1.0
526: ,p_init_msg_lst => FND_API.G_TRUE
527: ,p_partial_reservation_flag => FND_API.G_TRUE
528: ,p_force_reservation_flag => FND_API.G_FALSE
529: ,p_validation_flag => FND_API.G_TRUE
530: ,p_rsv_rec => l_rsv

Line 527: ,p_partial_reservation_flag => FND_API.G_TRUE

523:
524: INV_RESERVATION_PUB.Create_Reservation (
525: p_api_version_number => 1.0
526: ,p_init_msg_lst => FND_API.G_TRUE
527: ,p_partial_reservation_flag => FND_API.G_TRUE
528: ,p_force_reservation_flag => FND_API.G_FALSE
529: ,p_validation_flag => FND_API.G_TRUE
530: ,p_rsv_rec => l_rsv
531: ,p_serial_number => l_dummy_sn

Line 528: ,p_force_reservation_flag => FND_API.G_FALSE

524: INV_RESERVATION_PUB.Create_Reservation (
525: p_api_version_number => 1.0
526: ,p_init_msg_lst => FND_API.G_TRUE
527: ,p_partial_reservation_flag => FND_API.G_TRUE
528: ,p_force_reservation_flag => FND_API.G_FALSE
529: ,p_validation_flag => FND_API.G_TRUE
530: ,p_rsv_rec => l_rsv
531: ,p_serial_number => l_dummy_sn
532: ,x_reservation_id => l_rsv_id

Line 529: ,p_validation_flag => FND_API.G_TRUE

525: p_api_version_number => 1.0
526: ,p_init_msg_lst => FND_API.G_TRUE
527: ,p_partial_reservation_flag => FND_API.G_TRUE
528: ,p_force_reservation_flag => FND_API.G_FALSE
529: ,p_validation_flag => FND_API.G_TRUE
530: ,p_rsv_rec => l_rsv
531: ,p_serial_number => l_dummy_sn
532: ,x_reservation_id => l_rsv_id
533: ,x_quantity_reserved => l_rsv_qty

Line 541: IF l_return_status IN (FND_API.G_RET_STS_SUCCESS) THEN

537: ,x_msg_data => l_msg_data
538: ,x_return_status => l_return_status
539: );
540:
541: IF l_return_status IN (FND_API.G_RET_STS_SUCCESS) THEN
542: IF l_debug_level > 0 THEN
543: oe_debug_pub.add( 'QUANTITY RESERVED: ' || TO_CHAR ( L_RSV_QTY ) ) ;
544: oe_debug_pub.add( 'QUANTITY2 RESERVED: ' || TO_CHAR ( L_RSV_QTY2 ) ) ;
545: END IF;

Line 568: p_encoded => FND_API.G_TRUE,

564: FOR i IN 1..l_msg_count
565: LOOP
566: FND_Msg_Pub.Get(
567: -- p_msg_index => FND_MSG_PUB.G_NEXT,
568: p_encoded => FND_API.G_TRUE,
569: p_data => l_msg_data,
570: p_msg_index_out => l_msg_index);
571:
572: OE_Msg_Pub.Add_Text(p_message_text => l_msg_data);

Line 582: p_return_status := FND_API.G_RET_STS_SUCCESS;

578: END IF;
579:
580: p_msg_count := l_msg_count;
581: p_msg_data := l_msg_data;
582: p_return_status := FND_API.G_RET_STS_SUCCESS;
583:
584: EXCEPTION
585: WHEN OTHERS THEN
586: IF l_debug_level > 0 THEN

Line 593: p_return_status := FND_API.G_RET_STS_SUCCESS;

589: IF l_debug_level > 0 THEN
590: oe_debug_pub.add( 'BUT THE SUCCESS WILL BE RETURNED' ) ;
591: END IF;
592: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
593: p_return_status := FND_API.G_RET_STS_SUCCESS;
594: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Create_Reservation');
595: END IF;
596:
597: END Create_Reservation;

Line 634: ,p_init_msg_lst => FND_API.G_TRUE

630: END IF;
631:
632: INV_RESERVATION_PUB.Delete_Reservation (
633: p_api_version_number => 1.0
634: ,p_init_msg_lst => FND_API.G_TRUE
635: ,p_rsv_rec => l_rsv
636: ,p_serial_number => l_dummy_sn
637: ,x_msg_count => l_msg_count
638: ,x_msg_data => l_msg_data

Line 642: IF l_return_status IN (FND_API.G_RET_STS_SUCCESS) THEN

638: ,x_msg_data => l_msg_data
639: ,x_return_status => l_return_status
640: );
641:
642: IF l_return_status IN (FND_API.G_RET_STS_SUCCESS) THEN
643: IF l_debug_level > 0 THEN
644: oe_debug_pub.add( 'RESERVATION DELETED' ) ;
645: END IF;
646: ELSE

Line 665: p_encoded => FND_API.G_TRUE,

661: FOR i IN 1..l_msg_count
662: LOOP
663: FND_Msg_Pub.Get(
664: -- p_msg_index => FND_MSG_PUB.G_NEXT,
665: p_encoded => FND_API.G_TRUE,
666: p_data => l_msg_data,
667: p_msg_index_out => l_msg_index);
668:
669: OE_Msg_Pub.Add_Text(p_message_text => l_msg_data);

Line 679: p_return_status := FND_API.G_RET_STS_SUCCESS;

675: END IF;
676:
677: p_msg_count := l_msg_count;
678: p_msg_data := l_msg_data;
679: p_return_status := FND_API.G_RET_STS_SUCCESS;
680:
681: EXCEPTION
682: WHEN OTHERS THEN
683: IF l_debug_level > 0 THEN

Line 690: p_return_status := FND_API.G_RET_STS_SUCCESS;

686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add( 'BUT THE SUCCESS WILL BE RETURNED' ) ;
688: END IF;
689: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
690: p_return_status := FND_API.G_RET_STS_SUCCESS;
691: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Delete_Reservation');
692: END IF;
693:
694: END Delete_Reservation;