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_OE_FORM_LOT_SERIAL dependencies on FND_API

Line 172: ( p_validation_level => FND_API.G_VALID_LEVEL_FULL

168:
169: -- Call OE_Order_PVT.Process_order
170:
171: OE_Order_PVT.Lot_Serials
172: ( p_validation_level => FND_API.G_VALID_LEVEL_FULL
173: , p_init_msg_list => FND_API.G_TRUE
174: , p_control_rec => l_control_rec
175: , p_x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
176: , p_x_old_Lot_Serial_tbl => l_x_old_Lot_Serial_tbl

Line 173: , p_init_msg_list => FND_API.G_TRUE

169: -- Call OE_Order_PVT.Process_order
170:
171: OE_Order_PVT.Lot_Serials
172: ( p_validation_level => FND_API.G_VALID_LEVEL_FULL
173: , p_init_msg_list => FND_API.G_TRUE
174: , p_control_rec => l_control_rec
175: , p_x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
176: , p_x_old_Lot_Serial_tbl => l_x_old_Lot_Serial_tbl
177: , x_return_status => l_return_status

Line 180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

176: , p_x_old_Lot_Serial_tbl => l_x_old_Lot_Serial_tbl
177: , x_return_status => l_return_status
178: );
179:
180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;

Line 181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

177: , x_return_status => l_return_status
178: );
179:
180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:

Line 182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

178: );
179:
180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186:

Line 183: RAISE FND_API.G_EXC_ERROR;

179:
180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186:
187: -- Unload out tbl

Line 229: l_x_Lot_Serial_rec.db_flag := FND_API.G_FALSE;

225:
226: -- Write to cache.
227: -- Set db_flag to False before writing to cache
228:
229: l_x_Lot_Serial_rec.db_flag := FND_API.G_FALSE;
230:
231: Write_Lot_Serial
232: ( p_Lot_Serial_rec => l_x_Lot_Serial_rec
233: );

Line 240: x_return_status := FND_API.G_RET_STS_SUCCESS;

236: OE_GLOBALS.G_UI_FLAG := FALSE;
237:
238: -- Set return status.
239:
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241:
242: -- Get message count and data
243:
244: OE_MSG_PUB.Count_And_Get

Line 255: WHEN FND_API.G_EXC_ERROR THEN

251: END IF;
252:
253: EXCEPTION
254:
255: WHEN FND_API.G_EXC_ERROR THEN
256:
257: OE_GLOBALS.G_UI_FLAG := FALSE;
258:
259: x_return_status := FND_API.G_RET_STS_ERROR;

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

255: WHEN FND_API.G_EXC_ERROR THEN
256:
257: OE_GLOBALS.G_UI_FLAG := FALSE;
258:
259: x_return_status := FND_API.G_RET_STS_ERROR;
260:
261: -- Get message count and data
262:
263: OE_MSG_PUB.Count_And_Get

Line 268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

264: ( p_count => x_msg_count
265: , p_data => x_msg_data
266: );
267:
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269:
270: OE_GLOBALS.G_UI_FLAG := FALSE;
271:
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269:
270: OE_GLOBALS.G_UI_FLAG := FALSE;
271:
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273:
274: -- Get message count and data
275:
276: OE_MSG_PUB.Count_And_Get

Line 285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

281: WHEN OTHERS THEN
282:
283: OE_GLOBALS.G_UI_FLAG := FALSE;
284:
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
286:
287: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
288: THEN
289: OE_MSG_PUB.Add_Exc_Msg

Line 508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

504: );
505: END IF;
506:
507:
508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509:
510: END IF;
511:
512: -- Set Operation.

Line 513: IF FND_API.To_Boolean(l_x_Lot_Serial_rec.db_flag) THEN

509:
510: END IF;
511:
512: -- Set Operation.
513: IF FND_API.To_Boolean(l_x_Lot_Serial_rec.db_flag) THEN
514: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
515: ELSE
516: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_CREATE;
517: END IF;

Line 530: p_validation_level => FND_API.G_VALID_LEVEL_NONE

526: oe_debug_pub.add( 'BEFORE CALLING OE_ORDER_PVT.LOT_SERIALS'||TO_CHAR ( L_X_LOT_SERIAL_TBL ( 1 ) .QUANTITY ) , 1 ) ;
527: END IF;
528: OE_Order_PVT.Lot_Serials
529: (
530: p_validation_level => FND_API.G_VALID_LEVEL_NONE
531: , p_init_msg_list => FND_API.G_TRUE
532: , p_control_rec => l_control_rec
533: , p_x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
534: , p_x_old_Lot_Serial_tbl => l_x_old_Lot_Serial_tbl

Line 531: , p_init_msg_list => FND_API.G_TRUE

527: END IF;
528: OE_Order_PVT.Lot_Serials
529: (
530: p_validation_level => FND_API.G_VALID_LEVEL_NONE
531: , p_init_msg_list => FND_API.G_TRUE
532: , p_control_rec => l_control_rec
533: , p_x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
534: , p_x_old_Lot_Serial_tbl => l_x_old_Lot_Serial_tbl
535: , x_return_status => l_return_status

Line 538: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

534: , p_x_old_Lot_Serial_tbl => l_x_old_Lot_Serial_tbl
535: , x_return_status => l_return_status
536: );
537:
538: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
540: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
541: RAISE FND_API.G_EXC_ERROR;
542: END IF;

Line 539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

535: , x_return_status => l_return_status
536: );
537:
538: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
540: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
541: RAISE FND_API.G_EXC_ERROR;
542: END IF;
543:

Line 540: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

536: );
537:
538: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
540: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
541: RAISE FND_API.G_EXC_ERROR;
542: END IF;
543:
544: IF l_debug_level > 0 THEN

Line 541: RAISE FND_API.G_EXC_ERROR;

537:
538: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
540: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
541: RAISE FND_API.G_EXC_ERROR;
542: END IF;
543:
544: IF l_debug_level > 0 THEN
545: oe_debug_pub.add( 'AFTER CALLING OE_ORDER_PVT.LOT_SERIALS'||TO_CHAR ( L_X_LOT_SERIAL_TBL ( 1 ) .QUANTITY ) , 1 ) ;

Line 554: x_attribute1 := FND_API.G_MISS_CHAR;

550: l_x_Lot_Serial_rec := l_x_Lot_Serial_tbl(1);
551:
552: -- Init OUT parameters to missing.
553:
554: x_attribute1 := FND_API.G_MISS_CHAR;
555: x_attribute10 := FND_API.G_MISS_CHAR;
556: x_attribute11 := FND_API.G_MISS_CHAR;
557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;

Line 555: x_attribute10 := FND_API.G_MISS_CHAR;

551:
552: -- Init OUT parameters to missing.
553:
554: x_attribute1 := FND_API.G_MISS_CHAR;
555: x_attribute10 := FND_API.G_MISS_CHAR;
556: x_attribute11 := FND_API.G_MISS_CHAR;
557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;

Line 556: x_attribute11 := FND_API.G_MISS_CHAR;

552: -- Init OUT parameters to missing.
553:
554: x_attribute1 := FND_API.G_MISS_CHAR;
555: x_attribute10 := FND_API.G_MISS_CHAR;
556: x_attribute11 := FND_API.G_MISS_CHAR;
557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;

Line 557: x_attribute12 := FND_API.G_MISS_CHAR;

553:
554: x_attribute1 := FND_API.G_MISS_CHAR;
555: x_attribute10 := FND_API.G_MISS_CHAR;
556: x_attribute11 := FND_API.G_MISS_CHAR;
557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;

Line 558: x_attribute13 := FND_API.G_MISS_CHAR;

554: x_attribute1 := FND_API.G_MISS_CHAR;
555: x_attribute10 := FND_API.G_MISS_CHAR;
556: x_attribute11 := FND_API.G_MISS_CHAR;
557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;

Line 559: x_attribute14 := FND_API.G_MISS_CHAR;

555: x_attribute10 := FND_API.G_MISS_CHAR;
556: x_attribute11 := FND_API.G_MISS_CHAR;
557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;

Line 560: x_attribute15 := FND_API.G_MISS_CHAR;

556: x_attribute11 := FND_API.G_MISS_CHAR;
557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;

Line 561: x_attribute2 := FND_API.G_MISS_CHAR;

557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;

Line 562: x_attribute3 := FND_API.G_MISS_CHAR;

558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;

Line 563: x_attribute4 := FND_API.G_MISS_CHAR;

559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;

Line 564: x_attribute5 := FND_API.G_MISS_CHAR;

560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;

Line 565: x_attribute6 := FND_API.G_MISS_CHAR;

561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;

Line 566: x_attribute7 := FND_API.G_MISS_CHAR;

562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;
570: x_from_serial_number := FND_API.G_MISS_CHAR;

Line 567: x_attribute8 := FND_API.G_MISS_CHAR;

563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;
570: x_from_serial_number := FND_API.G_MISS_CHAR;
571: x_line_id := FND_API.G_MISS_NUM;

Line 568: x_attribute9 := FND_API.G_MISS_CHAR;

564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;
570: x_from_serial_number := FND_API.G_MISS_CHAR;
571: x_line_id := FND_API.G_MISS_NUM;
572: x_lot_number := FND_API.G_MISS_CHAR;

Line 569: x_context := FND_API.G_MISS_CHAR;

565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;
570: x_from_serial_number := FND_API.G_MISS_CHAR;
571: x_line_id := FND_API.G_MISS_NUM;
572: x_lot_number := FND_API.G_MISS_CHAR;
573: -- x_sublot_number := FND_API.G_MISS_CHAR; --OPM 2380194 INVCONV

Line 570: x_from_serial_number := FND_API.G_MISS_CHAR;

566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;
570: x_from_serial_number := FND_API.G_MISS_CHAR;
571: x_line_id := FND_API.G_MISS_NUM;
572: x_lot_number := FND_API.G_MISS_CHAR;
573: -- x_sublot_number := FND_API.G_MISS_CHAR; --OPM 2380194 INVCONV
574: x_lot_serial_id := FND_API.G_MISS_NUM;

Line 571: x_line_id := FND_API.G_MISS_NUM;

567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;
570: x_from_serial_number := FND_API.G_MISS_CHAR;
571: x_line_id := FND_API.G_MISS_NUM;
572: x_lot_number := FND_API.G_MISS_CHAR;
573: -- x_sublot_number := FND_API.G_MISS_CHAR; --OPM 2380194 INVCONV
574: x_lot_serial_id := FND_API.G_MISS_NUM;
575: x_quantity := FND_API.G_MISS_NUM;

Line 572: x_lot_number := FND_API.G_MISS_CHAR;

568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;
570: x_from_serial_number := FND_API.G_MISS_CHAR;
571: x_line_id := FND_API.G_MISS_NUM;
572: x_lot_number := FND_API.G_MISS_CHAR;
573: -- x_sublot_number := FND_API.G_MISS_CHAR; --OPM 2380194 INVCONV
574: x_lot_serial_id := FND_API.G_MISS_NUM;
575: x_quantity := FND_API.G_MISS_NUM;
576: x_quantity2 := FND_API.G_MISS_NUM; --OPM 2380194

Line 573: -- x_sublot_number := FND_API.G_MISS_CHAR; --OPM 2380194 INVCONV

569: x_context := FND_API.G_MISS_CHAR;
570: x_from_serial_number := FND_API.G_MISS_CHAR;
571: x_line_id := FND_API.G_MISS_NUM;
572: x_lot_number := FND_API.G_MISS_CHAR;
573: -- x_sublot_number := FND_API.G_MISS_CHAR; --OPM 2380194 INVCONV
574: x_lot_serial_id := FND_API.G_MISS_NUM;
575: x_quantity := FND_API.G_MISS_NUM;
576: x_quantity2 := FND_API.G_MISS_NUM; --OPM 2380194
577: x_to_serial_number := FND_API.G_MISS_CHAR;

Line 574: x_lot_serial_id := FND_API.G_MISS_NUM;

570: x_from_serial_number := FND_API.G_MISS_CHAR;
571: x_line_id := FND_API.G_MISS_NUM;
572: x_lot_number := FND_API.G_MISS_CHAR;
573: -- x_sublot_number := FND_API.G_MISS_CHAR; --OPM 2380194 INVCONV
574: x_lot_serial_id := FND_API.G_MISS_NUM;
575: x_quantity := FND_API.G_MISS_NUM;
576: x_quantity2 := FND_API.G_MISS_NUM; --OPM 2380194
577: x_to_serial_number := FND_API.G_MISS_CHAR;
578: x_line := FND_API.G_MISS_CHAR;

Line 575: x_quantity := FND_API.G_MISS_NUM;

571: x_line_id := FND_API.G_MISS_NUM;
572: x_lot_number := FND_API.G_MISS_CHAR;
573: -- x_sublot_number := FND_API.G_MISS_CHAR; --OPM 2380194 INVCONV
574: x_lot_serial_id := FND_API.G_MISS_NUM;
575: x_quantity := FND_API.G_MISS_NUM;
576: x_quantity2 := FND_API.G_MISS_NUM; --OPM 2380194
577: x_to_serial_number := FND_API.G_MISS_CHAR;
578: x_line := FND_API.G_MISS_CHAR;
579: x_lot_serial := FND_API.G_MISS_CHAR;

Line 576: x_quantity2 := FND_API.G_MISS_NUM; --OPM 2380194

572: x_lot_number := FND_API.G_MISS_CHAR;
573: -- x_sublot_number := FND_API.G_MISS_CHAR; --OPM 2380194 INVCONV
574: x_lot_serial_id := FND_API.G_MISS_NUM;
575: x_quantity := FND_API.G_MISS_NUM;
576: x_quantity2 := FND_API.G_MISS_NUM; --OPM 2380194
577: x_to_serial_number := FND_API.G_MISS_CHAR;
578: x_line := FND_API.G_MISS_CHAR;
579: x_lot_serial := FND_API.G_MISS_CHAR;
580:

Line 577: x_to_serial_number := FND_API.G_MISS_CHAR;

573: -- x_sublot_number := FND_API.G_MISS_CHAR; --OPM 2380194 INVCONV
574: x_lot_serial_id := FND_API.G_MISS_NUM;
575: x_quantity := FND_API.G_MISS_NUM;
576: x_quantity2 := FND_API.G_MISS_NUM; --OPM 2380194
577: x_to_serial_number := FND_API.G_MISS_CHAR;
578: x_line := FND_API.G_MISS_CHAR;
579: x_lot_serial := FND_API.G_MISS_CHAR;
580:
581: -- Load display out parameters if any

Line 578: x_line := FND_API.G_MISS_CHAR;

574: x_lot_serial_id := FND_API.G_MISS_NUM;
575: x_quantity := FND_API.G_MISS_NUM;
576: x_quantity2 := FND_API.G_MISS_NUM; --OPM 2380194
577: x_to_serial_number := FND_API.G_MISS_CHAR;
578: x_line := FND_API.G_MISS_CHAR;
579: x_lot_serial := FND_API.G_MISS_CHAR;
580:
581: -- Load display out parameters if any
582:

Line 579: x_lot_serial := FND_API.G_MISS_CHAR;

575: x_quantity := FND_API.G_MISS_NUM;
576: x_quantity2 := FND_API.G_MISS_NUM; --OPM 2380194
577: x_to_serial_number := FND_API.G_MISS_CHAR;
578: x_line := FND_API.G_MISS_CHAR;
579: x_lot_serial := FND_API.G_MISS_CHAR;
580:
581: -- Load display out parameters if any
582:
583: l_Lot_Serial_val_rec := OE_Lot_Serial_Util.Get_Values

Line 769: x_return_status := FND_API.G_RET_STS_SUCCESS;

765: OE_GLOBALS.G_UI_FLAG := FALSE;
766:
767: -- Set return status.
768:
769: x_return_status := FND_API.G_RET_STS_SUCCESS;
770:
771: -- Get message count and data
772:
773: OE_MSG_PUB.Count_And_Get

Line 784: WHEN FND_API.G_EXC_ERROR THEN

780:
781:
782: EXCEPTION
783:
784: WHEN FND_API.G_EXC_ERROR THEN
785:
786: OE_GLOBALS.G_UI_FLAG := FALSE;
787:
788: x_return_status := FND_API.G_RET_STS_ERROR;

Line 788: x_return_status := FND_API.G_RET_STS_ERROR;

784: WHEN FND_API.G_EXC_ERROR THEN
785:
786: OE_GLOBALS.G_UI_FLAG := FALSE;
787:
788: x_return_status := FND_API.G_RET_STS_ERROR;
789:
790: -- Get message count and data
791:
792: OE_MSG_PUB.Count_And_Get

Line 797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

793: ( p_count => x_msg_count
794: , p_data => x_msg_data
795: );
796:
797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
798:
799: OE_GLOBALS.G_UI_FLAG := FALSE;
800:
801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
798:
799: OE_GLOBALS.G_UI_FLAG := FALSE;
800:
801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
802:
803: -- Get message count and data
804:
805: OE_MSG_PUB.Count_And_Get

Line 814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

810: WHEN OTHERS THEN
811:
812: OE_GLOBALS.G_UI_FLAG := FALSE;
813:
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
815:
816: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
817: THEN
818: OE_MSG_PUB.Add_Exc_Msg

Line 909: IF FND_API.To_Boolean(l_x_Lot_Serial_rec.db_flag) THEN

905: );
906:
907: -- Set Operation.
908:
909: IF FND_API.To_Boolean(l_x_Lot_Serial_rec.db_flag) THEN
910: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
911: ELSE
912: l_x_Lot_Serial_rec.operation := OE_GLOBALS.G_OPR_CREATE;
913: END IF;

Line 923: ( p_validation_level =>FND_API.G_VALID_LEVEL_FULL

919:
920: -- Call OE_Order_PVT.Process_order
921:
922: OE_Order_PVT.Lot_Serials
923: ( p_validation_level =>FND_API.G_VALID_LEVEL_FULL
924: , p_init_msg_list => FND_API.G_TRUE
925: , p_control_rec => l_control_rec
926: , p_x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
927: , p_x_old_Lot_Serial_tbl => l_x_old_Lot_Serial_tbl

Line 924: , p_init_msg_list => FND_API.G_TRUE

920: -- Call OE_Order_PVT.Process_order
921:
922: OE_Order_PVT.Lot_Serials
923: ( p_validation_level =>FND_API.G_VALID_LEVEL_FULL
924: , p_init_msg_list => FND_API.G_TRUE
925: , p_control_rec => l_control_rec
926: , p_x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
927: , p_x_old_Lot_Serial_tbl => l_x_old_Lot_Serial_tbl
928: , x_return_status => l_return_status

Line 931: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

927: , p_x_old_Lot_Serial_tbl => l_x_old_Lot_Serial_tbl
928: , x_return_status => l_return_status
929: );
930:
931: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;

Line 932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

928: , x_return_status => l_return_status
929: );
930:
931: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936: /* The Process Requests and Notify call should be there for */

Line 933: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

929: );
930:
931: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936: /* The Process Requests and Notify call should be there for */
937: /* Pre-Pack code level */

Line 934: RAISE FND_API.G_EXC_ERROR;

930:
931: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936: /* The Process Requests and Notify call should be there for */
937: /* Pre-Pack code level */
938:

Line 943: , p_init_msg_list => FND_API.G_FALSE

939: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110508' THEN
940:
941: Oe_Order_Pvt.Process_Requests_And_Notify
942: ( p_process_requests => FALSE
943: , p_init_msg_list => FND_API.G_FALSE
944: , p_notify => TRUE
945: , x_return_status => l_return_status
946: , p_Lot_Serial_Tbl => l_x_Lot_Serial_Tbl
947: , p_Old_Lot_Serial_Tbl => l_x_old_Lot_Serial_Tbl

Line 950: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

946: , p_Lot_Serial_Tbl => l_x_Lot_Serial_Tbl
947: , p_Old_Lot_Serial_Tbl => l_x_old_Lot_Serial_Tbl
948: );
949:
950: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
952: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
953: RAISE FND_API.G_EXC_ERROR;
954: END IF;

Line 951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

947: , p_Old_Lot_Serial_Tbl => l_x_old_Lot_Serial_Tbl
948: );
949:
950: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
952: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
953: RAISE FND_API.G_EXC_ERROR;
954: END IF;
955:

Line 952: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

948: );
949:
950: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
952: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
953: RAISE FND_API.G_EXC_ERROR;
954: END IF;
955:
956: END IF;

Line 953: RAISE FND_API.G_EXC_ERROR;

949:
950: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
952: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
953: RAISE FND_API.G_EXC_ERROR;
954: END IF;
955:
956: END IF;
957:

Line 983: x_return_status := FND_API.G_RET_STS_SUCCESS;

979: OE_GLOBALS.G_UI_FLAG := FALSE;
980:
981: -- Set return status.
982:
983: x_return_status := FND_API.G_RET_STS_SUCCESS;
984:
985: -- Get message count and data
986:
987: OE_MSG_PUB.Count_And_Get

Line 998: WHEN FND_API.G_EXC_ERROR THEN

994: END IF;
995:
996: EXCEPTION
997:
998: WHEN FND_API.G_EXC_ERROR THEN
999:
1000: OE_GLOBALS.G_UI_FLAG := FALSE;
1001:
1002: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1002: x_return_status := FND_API.G_RET_STS_ERROR;

998: WHEN FND_API.G_EXC_ERROR THEN
999:
1000: OE_GLOBALS.G_UI_FLAG := FALSE;
1001:
1002: x_return_status := FND_API.G_RET_STS_ERROR;
1003:
1004: -- Get message count and data
1005:
1006: OE_MSG_PUB.Count_And_Get

Line 1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1013: IF l_debug_level > 0 THEN
1014: oe_debug_pub.add( 'ERROR IN OE_OE_FORM_LOT_SERIAL.VALIDATE_AND_WRITE '|| X_MSG_DATA , 1 ) ;
1015: END IF;
1016:
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018:
1019: OE_GLOBALS.G_UI_FLAG := FALSE;
1020:
1021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018:
1019: OE_GLOBALS.G_UI_FLAG := FALSE;
1020:
1021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1022:
1023: -- Get message count and data
1024:
1025: OE_MSG_PUB.Count_And_Get

Line 1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1030: WHEN OTHERS THEN
1031:
1032: OE_GLOBALS.G_UI_FLAG := FALSE;
1033:
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1035:
1036: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1037: THEN
1038: OE_MSG_PUB.Add_Exc_Msg

Line 1115: ( p_validation_level => FND_API.G_VALID_LEVEL_FULL

1111:
1112: -- Call OE_Order_PVT.Process_order
1113:
1114: OE_Order_PVT.Lot_Serials
1115: ( p_validation_level => FND_API.G_VALID_LEVEL_FULL
1116: , p_init_msg_list => FND_API.G_TRUE
1117: , p_control_rec => l_control_rec
1118: , p_x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
1119: , p_x_old_Lot_Serial_tbl => l_x_old_Lot_Serial_tbl

Line 1116: , p_init_msg_list => FND_API.G_TRUE

1112: -- Call OE_Order_PVT.Process_order
1113:
1114: OE_Order_PVT.Lot_Serials
1115: ( p_validation_level => FND_API.G_VALID_LEVEL_FULL
1116: , p_init_msg_list => FND_API.G_TRUE
1117: , p_control_rec => l_control_rec
1118: , p_x_Lot_Serial_tbl => l_x_Lot_Serial_tbl
1119: , p_x_old_Lot_Serial_tbl => l_x_old_Lot_Serial_tbl
1120: , x_return_status => l_return_status

Line 1123: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1119: , p_x_old_Lot_Serial_tbl => l_x_old_Lot_Serial_tbl
1120: , x_return_status => l_return_status
1121: );
1122:
1123: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;

Line 1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1120: , x_return_status => l_return_status
1121: );
1122:
1123: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1128:

Line 1125: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1121: );
1122:
1123: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1128:
1129:

Line 1126: RAISE FND_API.G_EXC_ERROR;

1122:
1123: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1128:
1129:
1130: -- Clear Lot_Serial record cache

Line 1139: x_return_status := FND_API.G_RET_STS_SUCCESS;

1135: OE_GLOBALS.G_UI_FLAG := FALSE;
1136:
1137: -- Set return status.
1138:
1139: x_return_status := FND_API.G_RET_STS_SUCCESS;
1140:
1141: -- Get message count and data
1142:
1143: OE_MSG_PUB.Count_And_Get

Line 1151: WHEN FND_API.G_EXC_ERROR THEN

1147:
1148:
1149: EXCEPTION
1150:
1151: WHEN FND_API.G_EXC_ERROR THEN
1152:
1153: OE_GLOBALS.G_UI_FLAG := FALSE;
1154:
1155: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1155: x_return_status := FND_API.G_RET_STS_ERROR;

1151: WHEN FND_API.G_EXC_ERROR THEN
1152:
1153: OE_GLOBALS.G_UI_FLAG := FALSE;
1154:
1155: x_return_status := FND_API.G_RET_STS_ERROR;
1156:
1157: -- Get message count and data
1158:
1159: OE_MSG_PUB.Count_And_Get

Line 1164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1160: ( p_count => x_msg_count
1161: , p_data => x_msg_data
1162: );
1163:
1164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1165:
1166: OE_GLOBALS.G_UI_FLAG := FALSE;
1167:
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1165:
1166: OE_GLOBALS.G_UI_FLAG := FALSE;
1167:
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1169:
1170: -- Get message count and data
1171:
1172: OE_MSG_PUB.Count_And_Get

Line 1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1177: WHEN OTHERS THEN
1178:
1179: OE_GLOBALS.G_UI_FLAG := FALSE;
1180:
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1182:
1183: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1184: THEN
1185: OE_MSG_PUB.Add_Exc_Msg

Line 1264: , p_init_msg_list => FND_API.G_TRUE

1260: -- Call OE_Order_PVT.Process_order
1261:
1262: OE_Order_PVT.Process_order
1263: ( p_api_version_number => 1.0
1264: , p_init_msg_list => FND_API.G_TRUE
1265: , x_return_status => l_return_status
1266: , x_msg_count => x_msg_count
1267: , x_msg_data => x_msg_data
1268: , p_control_rec => l_control_rec

Line 1288: , p_init_msg_list => FND_API.G_TRUE

1284: */
1285:
1286: Oe_Order_Pvt.Process_Requests_And_Notify
1287: ( p_process_requests => TRUE
1288: , p_init_msg_list => FND_API.G_TRUE
1289: , p_notify => TRUE
1290: , x_return_status => l_return_status
1291: );
1292:

Line 1293: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1289: , p_notify => TRUE
1290: , x_return_status => l_return_status
1291: );
1292:
1293: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;

Line 1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1290: , x_return_status => l_return_status
1291: );
1292:
1293: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;
1298:

Line 1295: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1291: );
1292:
1293: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;
1298:
1299:

Line 1296: RAISE FND_API.G_EXC_ERROR;

1292:
1293: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;
1298:
1299:
1300: -- Re-set the UI flag to FALSE

Line 1305: x_return_status := FND_API.G_RET_STS_SUCCESS;

1301: OE_GLOBALS.G_UI_FLAG := FALSE;
1302:
1303: -- Set return status.
1304:
1305: x_return_status := FND_API.G_RET_STS_SUCCESS;
1306:
1307: -- Get message count and data
1308:
1309: OE_MSG_PUB.Count_And_Get

Line 1317: WHEN FND_API.G_EXC_ERROR THEN

1313:
1314:
1315: EXCEPTION
1316:
1317: WHEN FND_API.G_EXC_ERROR THEN
1318:
1319: OE_GLOBALS.G_UI_FLAG := FALSE;
1320:
1321: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1321: x_return_status := FND_API.G_RET_STS_ERROR;

1317: WHEN FND_API.G_EXC_ERROR THEN
1318:
1319: OE_GLOBALS.G_UI_FLAG := FALSE;
1320:
1321: x_return_status := FND_API.G_RET_STS_ERROR;
1322:
1323: -- Get message count and data
1324:
1325: OE_MSG_PUB.Count_And_Get

Line 1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1326: ( p_count => x_msg_count
1327: , p_data => x_msg_data
1328: );
1329:
1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1331:
1332: OE_GLOBALS.G_UI_FLAG := FALSE;
1333:
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1331:
1332: OE_GLOBALS.G_UI_FLAG := FALSE;
1333:
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1335:
1336: -- Get message count and data
1337:
1338: OE_MSG_PUB.Count_And_Get

Line 1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1343: WHEN OTHERS THEN
1344:
1345: OE_GLOBALS.G_UI_FLAG := FALSE;
1346:
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1348:
1349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1350: THEN
1351: OE_MSG_PUB.Add_Exc_Msg

Line 1399: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1395: OE_Lot_Serial_Util.Lock_Row
1396: ( x_return_status => l_return_status
1397: , p_x_Lot_Serial_rec => l_x_Lot_Serial_rec );
1398:
1399: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1400:
1401: -- Set DB flag and write record to cache.
1402:
1403: l_x_Lot_Serial_rec.db_flag := FND_API.G_TRUE;

Line 1403: l_x_Lot_Serial_rec.db_flag := FND_API.G_TRUE;

1399: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1400:
1401: -- Set DB flag and write record to cache.
1402:
1403: l_x_Lot_Serial_rec.db_flag := FND_API.G_TRUE;
1404:
1405: Write_Lot_Serial
1406: ( p_Lot_Serial_rec => l_x_Lot_Serial_rec
1407: , p_db_record => TRUE

Line 1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1432: , 'Lock_Row'
1433: );
1434: END IF;
1435:
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1437:
1438: -- Get message count and data
1439:
1440: OE_MSG_PUB.Count_And_Get

Line 1504: g_Lot_Serial_rec.db_flag := FND_API.G_TRUE;

1500: ( p_lot_serial_id => p_lot_serial_id
1501: , x_lot_serial_rec => g_Lot_Serial_rec
1502: );
1503:
1504: g_Lot_Serial_rec.db_flag := FND_API.G_TRUE;
1505:
1506: -- Load DB record
1507:
1508: g_db_Lot_Serial_rec := g_Lot_Serial_rec;