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

Line 185: x_return_status := FND_API.G_RET_STS_SUCCESS;

181: l_credit_rejected_qty VARCHAR2(1); -- Added for bug 6052676
182: BEGIN
183:
184: -- Initialize API return status to success
185: x_return_status := FND_API.G_RET_STS_SUCCESS;
186:
187: -- OM: Debug Level. Just remove the comments
188: IF To_number(Nvl(fnd_profile.value('ONT_DEBUG_LEVEL'), '0')) > 0 THEN
189: oe_debug_pub.initialize;

Line 238: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

234: ( p_line_id => p_RMA_Line_id
235: , x_line_tbl => l_old_line_tbl
236: , x_return_status => l_return_status
237: );
238: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
239: RAISE FND_API.G_EXC_ERROR;
240: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;

Line 239: RAISE FND_API.G_EXC_ERROR;

235: , x_line_tbl => l_old_line_tbl
236: , x_return_status => l_return_status
237: );
238: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
239: RAISE FND_API.G_EXC_ERROR;
240: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;
243:

Line 240: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

236: , x_return_status => l_return_status
237: );
238: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
239: RAISE FND_API.G_EXC_ERROR;
240: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;
243:
244: l_old_line_tbl(1).db_flag := FND_API.G_TRUE;

Line 241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

237: );
238: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
239: RAISE FND_API.G_EXC_ERROR;
240: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;
243:
244: l_old_line_tbl(1).db_flag := FND_API.G_TRUE;
245: l_line_tbl(1) := l_old_line_tbl(1);

Line 244: l_old_line_tbl(1).db_flag := FND_API.G_TRUE;

240: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;
243:
244: l_old_line_tbl(1).db_flag := FND_API.G_TRUE;
245: l_line_tbl(1) := l_old_line_tbl(1);
246:
247: -- Set control flags.
248:

Line 267: IF (l_line_tbl(1).ship_tolerance_below = FND_API.G_MISS_NUM)

263: l_control_rec.check_security := FALSE;
264:
265: -- setting ship tolerances
266:
267: IF (l_line_tbl(1).ship_tolerance_below = FND_API.G_MISS_NUM)
268: OR (l_line_tbl(1).ship_tolerance_below is NULL) THEN
269: l_tolerance_below := 0.0;
270: ELSE
271: l_tolerance_below := l_line_tbl(1).ship_tolerance_below * l_line_tbl(1).ordered_quantity/100;

Line 274: IF (l_line_tbl(1).ship_tolerance_above = FND_API.G_MISS_NUM)

270: ELSE
271: l_tolerance_below := l_line_tbl(1).ship_tolerance_below * l_line_tbl(1).ordered_quantity/100;
272: END IF;
273:
274: IF (l_line_tbl(1).ship_tolerance_above = FND_API.G_MISS_NUM)
275: OR (l_line_tbl(1).ship_tolerance_above is NULL) THEN
276: l_tolerance_above := 0.0;
277: ELSE
278: l_tolerance_above := l_line_tbl(1).ship_tolerance_above * l_line_tbl(1).ordered_quantity/100;

Line 283: IF (p_quantity2 = FND_API.G_MISS_NUM)

279: END IF;
280:
281:
282: -- set boolean for presence of quantity2 for OPM
283: IF (p_quantity2 = FND_API.G_MISS_NUM)
284: OR (p_quantity2 = 0 )
285: OR (p_quantity2 is NULL) THEN
286: b_dual_qty := FALSE;
287: ELSE

Line 311: IF ((l_line_tbl(1).shipped_quantity = FND_API.G_MISS_NUM) OR

307: b_complete_receiving := TRUE;
308:
309: -- should not be receiving more than the ordered quantity
310:
311: IF ((l_line_tbl(1).shipped_quantity = FND_API.G_MISS_NUM) OR
312: (l_line_tbl(1).shipped_quantity is NULL)) THEN
313: l_updated_quantity := p_quantity;
314: IF b_dual_qty THEN
315: l_updated_quantity2 := p_quantity2; -- 04/20/2001 OPM

Line 329: x_return_status := FND_API.G_RET_STS_ERROR ;

325: IF (l_updated_quantity >
326: l_line_tbl(1).ordered_quantity + l_tolerance_above) THEN
327: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_RCVD_QTY');
328: OE_MSG_PUB.Add;
329: x_return_status := FND_API.G_RET_STS_ERROR ;
330: RAISE FND_API.G_EXC_ERROR;
331: END IF;
332:
333: -- under return, split the line

Line 330: RAISE FND_API.G_EXC_ERROR;

326: l_line_tbl(1).ordered_quantity + l_tolerance_above) THEN
327: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_RCVD_QTY');
328: OE_MSG_PUB.Add;
329: x_return_status := FND_API.G_RET_STS_ERROR ;
330: RAISE FND_API.G_EXC_ERROR;
331: END IF;
332:
333: -- under return, split the line
334: IF (l_updated_quantity <

Line 341: l_open_line_rec.db_flag := FND_API.G_FALSE;

337: IF l_debug_level > 0 THEN
338: oe_debug_pub.add( 'UNDER RETURN:'||TO_CHAR ( P_QUANTITY ) ||'<'||TO_CHAR ( L_LINE_TBL ( 1 ) .ORDERED_QUANTITY+L_TOLERANCE_BELOW ) , 1 ) ;
339: END IF;
340:
341: l_open_line_rec.db_flag := FND_API.G_FALSE;
342: l_open_line_rec.ordered_quantity
343: := l_old_line_tbl(1).ordered_quantity - p_quantity;
344: IF b_dual_qty THEN
345: l_open_line_rec.ordered_quantity2

Line 403: IF ((l_line_tbl(1).fulfilled_quantity = FND_API.G_MISS_NUM) OR

399: -- update fulfilled_quantity, and possibility to complete inspection.
400: b_om_processing := TRUE;
401:
402: -- get the current fulfilled quantity
403: IF ((l_line_tbl(1).fulfilled_quantity = FND_API.G_MISS_NUM) OR
404: (l_line_tbl(1).fulfilled_quantity is NULL)) THEN
405: l_updated_quantity := p_quantity;
406: IF b_dual_qty THEN
407: l_updated_quantity2 := p_quantity2; -- 04/20/2001 OPM

Line 420: x_return_status := FND_API.G_RET_STS_ERROR ;

416: -- over quantity being passed
417: IF (l_line_tbl(1).shipped_quantity < l_updated_quantity ) THEN
418: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_DLVR_QTY');
419: OE_MSG_PUB.Add;
420: x_return_status := FND_API.G_RET_STS_ERROR ;
421: RAISE FND_API.G_EXC_ERROR;
422: END IF;
423:
424: l_line_tbl(1).fulfilled_quantity := l_updated_quantity;

Line 421: RAISE FND_API.G_EXC_ERROR;

417: IF (l_line_tbl(1).shipped_quantity < l_updated_quantity ) THEN
418: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_DLVR_QTY');
419: OE_MSG_PUB.Add;
420: x_return_status := FND_API.G_RET_STS_ERROR ;
421: RAISE FND_API.G_EXC_ERROR;
422: END IF;
423:
424: l_line_tbl(1).fulfilled_quantity := l_updated_quantity;
425: IF b_dual_qty THEN

Line 486: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

482: (p_line_id => l_open_line_id
483: ,p_x_line_rec => l_temp_open_line_rec
484: ,x_return_status => l_return_status
485: );
486: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
487: RAISE FND_API.G_EXC_ERROR;
488: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: END IF;

Line 487: RAISE FND_API.G_EXC_ERROR;

483: ,p_x_line_rec => l_temp_open_line_rec
484: ,x_return_status => l_return_status
485: );
486: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
487: RAISE FND_API.G_EXC_ERROR;
488: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: END IF;
491: END IF;

Line 488: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

484: ,x_return_status => l_return_status
485: );
486: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
487: RAISE FND_API.G_EXC_ERROR;
488: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: END IF;
491: END IF;
492:

Line 489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

485: );
486: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
487: RAISE FND_API.G_EXC_ERROR;
488: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: END IF;
491: END IF;
492:
493: IF ( p_quantity > 0 ) THEN -- received more

Line 538: x_return_status := FND_API.G_RET_STS_ERROR ;

534: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_RCVD_QTY');
535: END IF;
536: END IF;
537: OE_MSG_PUB.Add;
538: x_return_status := FND_API.G_RET_STS_ERROR ;
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: -- Never receive on open line as this line will never have any receipt
542: -- associated with it.

Line 539: RAISE FND_API.G_EXC_ERROR;

535: END IF;
536: END IF;
537: OE_MSG_PUB.Add;
538: x_return_status := FND_API.G_RET_STS_ERROR ;
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: -- Never receive on open line as this line will never have any receipt
542: -- associated with it.
543:

Line 573: l_open_line_rec.db_flag := FND_API.G_FALSE;

569: (l_line_tbl(1).ordered_quantity + l_tolerance_above)) OR
570: ( l_updated_quantity = 0 ) THEN
571: -- split line if the l_updated_quantity is > 0.
572: IF l_updated_quantity > 0 THEN
573: l_open_line_rec.db_flag := FND_API.G_FALSE;
574: l_open_line_rec.ordered_quantity := -p_quantity;
575: IF b_dual_qty THEN
576: l_open_line_rec.ordered_quantity2 := -p_quantity2;
577: -- 04/20/2001 OPM

Line 610: x_return_status := FND_API.G_RET_STS_ERROR ;

606: l_line_tbl(1).flow_status_code := 'AWAITING_RETURN';
607: ELSE
608: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_RCVD_QTY');
609: OE_MSG_PUB.Add;
610: x_return_status := FND_API.G_RET_STS_ERROR ;
611: RAISE FND_API.G_EXC_ERROR;
612: END IF;
613:
614: END IF; -- IF l_updated_quantity not between

Line 611: RAISE FND_API.G_EXC_ERROR;

607: ELSE
608: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_RCVD_QTY');
609: OE_MSG_PUB.Add;
610: x_return_status := FND_API.G_RET_STS_ERROR ;
611: RAISE FND_API.G_EXC_ERROR;
612: END IF;
613:
614: END IF; -- IF l_updated_quantity not between
615:

Line 664: x_return_status := FND_API.G_RET_STS_ERROR ;

660: ELSE
661: -- Give error that it is a wrong correction
662: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_RCVD_QTY');
663: OE_MSG_PUB.Add;
664: x_return_status := FND_API.G_RET_STS_ERROR ;
665: RAISE FND_API.G_EXC_ERROR;
666: END IF;
667: END IF; -- IF (l_open_line_id is NULL) THEN
668:

Line 665: RAISE FND_API.G_EXC_ERROR;

661: -- Give error that it is a wrong correction
662: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_RCVD_QTY');
663: OE_MSG_PUB.Add;
664: x_return_status := FND_API.G_RET_STS_ERROR ;
665: RAISE FND_API.G_EXC_ERROR;
666: END IF;
667: END IF; -- IF (l_open_line_id is NULL) THEN
668:
669: END IF;

Line 682: IF ((l_line_tbl(1).fulfilled_quantity = FND_API.G_MISS_NUM) OR

678: -- update fulfilled_quantity, and possibility to complete inspection.
679: b_om_processing := TRUE;
680:
681: -- get the current fulfilled quantity
682: IF ((l_line_tbl(1).fulfilled_quantity = FND_API.G_MISS_NUM) OR
683: (l_line_tbl(1).fulfilled_quantity is NULL)) THEN
684: l_updated_quantity := p_quantity;
685: IF b_dual_qty THEN
686: l_updated_quantity2 := p_quantity2; -- 04/20/2001 OPM

Line 699: x_return_status := FND_API.G_RET_STS_ERROR ;

695: -- over quantity being passed
696: IF (l_line_tbl(1).shipped_quantity < l_updated_quantity ) THEN
697: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_DLVR_QTY');
698: OE_MSG_PUB.Add;
699: x_return_status := FND_API.G_RET_STS_ERROR ;
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702:
703: /* Commented for Bug 5501949

Line 700: RAISE FND_API.G_EXC_ERROR;

696: IF (l_line_tbl(1).shipped_quantity < l_updated_quantity ) THEN
697: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_DLVR_QTY');
698: OE_MSG_PUB.Add;
699: x_return_status := FND_API.G_RET_STS_ERROR ;
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702:
703: /* Commented for Bug 5501949
704: l_line_tbl(1).fulfilled_quantity := l_updated_quantity;

Line 926: IF ((l_line_tbl(1).shipped_quantity = FND_API.G_MISS_NUM) OR

922: b_complete_receiving := TRUE;
923:
924: -- should not be receiving more than the ordered quantity
925:
926: IF ((l_line_tbl(1).shipped_quantity = FND_API.G_MISS_NUM) OR
927: (l_line_tbl(1).shipped_quantity is NULL)) THEN
928: l_updated_quantity := p_quantity;
929: IF b_dual_qty THEN
930: l_updated_quantity2 := p_quantity2; -- 04/20/2001 OPM

Line 944: x_return_status := FND_API.G_RET_STS_ERROR ;

940: IF (l_updated_quantity >
941: l_line_tbl(1).ordered_quantity + l_tolerance_above) THEN
942: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_RCVD_QTY');
943: OE_MSG_PUB.Add;
944: x_return_status := FND_API.G_RET_STS_ERROR ;
945: RAISE FND_API.G_EXC_ERROR;
946: END IF;
947:
948: -- under return, split the line

Line 945: RAISE FND_API.G_EXC_ERROR;

941: l_line_tbl(1).ordered_quantity + l_tolerance_above) THEN
942: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_RCVD_QTY');
943: OE_MSG_PUB.Add;
944: x_return_status := FND_API.G_RET_STS_ERROR ;
945: RAISE FND_API.G_EXC_ERROR;
946: END IF;
947:
948: -- under return, split the line
949: IF (l_updated_quantity <

Line 956: l_open_line_rec.db_flag := FND_API.G_FALSE;

952: IF l_debug_level > 0 THEN
953: oe_debug_pub.add( 'UNDER RETURN:'||TO_CHAR ( P_QUANTITY ) ||'<'||TO_CHAR ( L_LINE_TBL ( 1 ) .ORDERED_QUANTITY+L_TOLERANCE_BELOW ) , 1 ) ;
954: END IF;
955:
956: l_open_line_rec.db_flag := FND_API.G_FALSE;
957: l_open_line_rec.ordered_quantity
958: := l_old_line_tbl(1).ordered_quantity - p_quantity;
959: l_open_line_rec.split_from_line_id := p_RMA_Line_ID;
960: l_open_line_rec.split_by := 'SYSTEM';

Line 1020: , p_init_msg_list => FND_API.G_TRUE

1016: -- Call OE_Order_PVT.Process_order
1017:
1018: OE_Order_PVT.Process_order
1019: ( p_api_version_number => 1.0
1020: , p_init_msg_list => FND_API.G_TRUE
1021: , x_return_status => x_return_status
1022: , x_msg_count => x_msg_count
1023: , x_msg_data => x_msg_data
1024: , p_control_rec => l_control_rec

Line 1051: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1047:
1048: IF l_debug_level > 0 THEN
1049: oe_debug_pub.add( 'PROCESS ORDER Return Status IS '||x_return_status);
1050: END IF;
1051: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1053: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;

Line 1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1048: IF l_debug_level > 0 THEN
1049: oe_debug_pub.add( 'PROCESS ORDER Return Status IS '||x_return_status);
1050: END IF;
1051: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1053: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056:

Line 1053: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1049: oe_debug_pub.add( 'PROCESS ORDER Return Status IS '||x_return_status);
1050: END IF;
1051: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1053: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056:
1057: -- complete workflow activity

Line 1054: RAISE FND_API.G_EXC_ERROR;

1050: END IF;
1051: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1053: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056:
1057: -- complete workflow activity
1058:

Line 1123: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1119: IF l_debug_level > 0 THEN
1120: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API 1 '|| L_RETURN_STATUS , 1 ) ;
1121: END IF;
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: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API 1 '|| L_RETURN_STATUS , 1 ) ;
1121: END IF;
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: END IF;
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: END IF;

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

Line 1146: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1142: IF l_debug_level > 0 THEN
1143: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API 2'|| L_RETURN_STATUS , 1 ) ;
1144: END IF;
1145:
1146: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1148: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: END IF;

Line 1147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1143: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API 2'|| L_RETURN_STATUS , 1 ) ;
1144: END IF;
1145:
1146: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1148: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: END IF;
1151:

Line 1148: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1144: END IF;
1145:
1146: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1148: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: END IF;
1151:
1152: END IF;

Line 1149: RAISE FND_API.G_EXC_ERROR;

1145:
1146: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1148: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1149: RAISE FND_API.G_EXC_ERROR;
1150: END IF;
1151:
1152: END IF;
1153:

Line 1162: WHEN FND_API.G_EXC_ERROR THEN

1158: END IF;
1159:
1160: EXCEPTION
1161:
1162: WHEN FND_API.G_EXC_ERROR THEN
1163: x_return_status := FND_API.G_RET_STS_ERROR;
1164:
1165: OE_MSG_PUB.Get
1166: ( p_msg_index => OE_MSG_PUB.G_LAST

Line 1163: x_return_status := FND_API.G_RET_STS_ERROR;

1159:
1160: EXCEPTION
1161:
1162: WHEN FND_API.G_EXC_ERROR THEN
1163: x_return_status := FND_API.G_RET_STS_ERROR;
1164:
1165: OE_MSG_PUB.Get
1166: ( p_msg_index => OE_MSG_PUB.G_LAST
1167: , p_encoded => FND_API.G_FALSE

Line 1167: , p_encoded => FND_API.G_FALSE

1163: x_return_status := FND_API.G_RET_STS_ERROR;
1164:
1165: OE_MSG_PUB.Get
1166: ( p_msg_index => OE_MSG_PUB.G_LAST
1167: , p_encoded => FND_API.G_FALSE
1168: , p_data => x_msg_data
1169: , p_msg_index_out => x_msg_count
1170: );
1171:

Line 1172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1168: , p_data => x_msg_data
1169: , p_msg_index_out => x_msg_count
1170: );
1171:
1172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1173: IF OE_MSG_PUB.Check_MSg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1174: OE_MSG_PUB.Add_Exc_Msg
1175: (G_PKG_NAME
1176: ,'Push_Receiving_Info'

Line 1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1175: (G_PKG_NAME
1176: ,'Push_Receiving_Info'
1177: );
1178: END IF;
1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1180:
1181: OE_MSG_PUB.Get
1182: ( p_msg_index => OE_MSG_PUB.G_LAST
1183: , p_encoded => FND_API.G_FALSE

Line 1183: , p_encoded => FND_API.G_FALSE

1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1180:
1181: OE_MSG_PUB.Get
1182: ( p_msg_index => OE_MSG_PUB.G_LAST
1183: , p_encoded => FND_API.G_FALSE
1184: , p_data => x_msg_data
1185: , p_msg_index_out => x_msg_count
1186: );
1187:

Line 1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1194: , 'Push_Receiving_Info'
1195: );
1196: END IF;
1197:
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1199:
1200: OE_MSG_PUB.Get
1201: ( p_msg_index => OE_MSG_PUB.G_LAST
1202: , p_encoded => FND_API.G_FALSE

Line 1202: , p_encoded => FND_API.G_FALSE

1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1199:
1200: OE_MSG_PUB.Get
1201: ( p_msg_index => OE_MSG_PUB.G_LAST
1202: , p_encoded => FND_API.G_FALSE
1203: , p_data => x_msg_data
1204: , p_msg_index_out => x_msg_count
1205: );
1206:

Line 1349: x_return_status := FND_API.G_RET_STS_SUCCESS;

1345: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1346: --
1347: BEGIN
1348:
1349: x_return_status := FND_API.G_RET_STS_SUCCESS;
1350:
1351:
1352: Select SHIP_TOLERANCE_BELOW, SHIP_TOLERANCE_ABOVE
1353: into x_Under_Return_Tolerance,x_Over_Return_Tolerance

Line 1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1372: ( p_count => x_msg_count
1373: , p_data => x_msg_data
1374: );
1375:
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377:
1378: END Get_RMA_Tolerances;
1379:
1380: END OE_RMA_RECEIVING;