APPS.OE_SALES_CAN_UTIL dependencies on FND_API

Line 53: x_return_status := FND_API.G_RET_STS_SUCCESS;

49: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
50: --
51: Begin
52:
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54:
55: IF l_debug_level > 0 THEN
56: oe_debug_pub.add( 'ENTERING OE_SALES_CAN_UTIL.UPDATE_LINE' ) ;
57: END IF;

Line 91: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

87: IF l_debug_level > 0 THEN
88: oe_debug_pub.add( 'AFTER CALLING LOCK ROW' ) ;
89: END IF;
90:
91: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;

Line 92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

88: oe_debug_pub.add( 'AFTER CALLING LOCK ROW' ) ;
89: END IF;
90:
91: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96:

Line 93: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

89: END IF;
90:
91: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96:
97: l_line_tbl(1) := l_line_rec;

Line 94: RAISE FND_API.G_EXC_ERROR;

90:
91: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96:
97: l_line_tbl(1) := l_line_rec;
98: l_line_tbl(1).db_flag := FND_API.G_TRUE;

Line 98: l_line_tbl(1).db_flag := FND_API.G_TRUE;

94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96:
97: l_line_tbl(1) := l_line_rec;
98: l_line_tbl(1).db_flag := FND_API.G_TRUE;
99:
100: l_old_line_tbl(1) := l_line_tbl(1);
101:
102: l_line_tbl(1).ordered_quantity := p_ordered_quantity;

Line 122: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

118: oe_debug_pub.add( 'BEFORE CALLING PROCESS ORDER' ) ;
119: END IF;
120:
121: oe_order_pvt.Lines
122: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
123: , p_control_rec => l_control_rec
124: , p_x_line_tbl => l_line_tbl
125: , p_x_old_line_tbl => l_old_line_tbl
126: , x_return_status => l_return_status

Line 129: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

125: , p_x_old_line_tbl => l_old_line_tbl
126: , x_return_status => l_return_status
127: );
128:
129: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;

Line 130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

126: , x_return_status => l_return_status
127: );
128:
129: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:

Line 131: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

127: );
128:
129: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: IF l_debug_level > 0 THEN

Line 132: RAISE FND_API.G_EXC_ERROR;

128:
129: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: IF l_debug_level > 0 THEN
136: oe_debug_pub.add( 'AFTER CALLING PROCESS ORDER' ) ;

Line 150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

146: , p_line_tbl => l_line_tbl
147: , p_old_line_tbl => l_old_line_tbl
148: );
149:
150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
151: oe_debug_pub.ADD('Update Line Process Order return UNEXP_ERROR');
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
154: oe_debug_pub.ADD('Update Line Process Order return RET_STS_ERROR');

Line 152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

148: );
149:
150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
151: oe_debug_pub.ADD('Update Line Process Order return UNEXP_ERROR');
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
154: oe_debug_pub.ADD('Update Line Process Order return RET_STS_ERROR');
155: RAISE FND_API.G_EXC_ERROR;
156: END IF;

Line 153: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

149:
150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
151: oe_debug_pub.ADD('Update Line Process Order return UNEXP_ERROR');
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
154: oe_debug_pub.ADD('Update Line Process Order return RET_STS_ERROR');
155: RAISE FND_API.G_EXC_ERROR;
156: END IF;
157: jolin end */

Line 155: RAISE FND_API.G_EXC_ERROR;

151: oe_debug_pub.ADD('Update Line Process Order return UNEXP_ERROR');
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
154: oe_debug_pub.ADD('Update Line Process Order return RET_STS_ERROR');
155: RAISE FND_API.G_EXC_ERROR;
156: END IF;
157: jolin end */
158:
159: g_ser_cascade := FALSE;

Line 166: WHEN FND_API.G_EXC_ERROR THEN

162: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.UPDATE_LINE' ) ;
163: END IF;
164:
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: g_ser_cascade := FALSE;
168: x_return_status := FND_API.G_RET_STS_ERROR;
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 168: x_return_status := FND_API.G_RET_STS_ERROR;

164:
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: g_ser_cascade := FALSE;
168: x_return_status := FND_API.G_RET_STS_ERROR;
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
171: oe_msg_pub.Add_Exc_Msg
172: (G_PKG_NAME

Line 169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: g_ser_cascade := FALSE;
168: x_return_status := FND_API.G_RET_STS_ERROR;
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
171: oe_msg_pub.Add_Exc_Msg
172: (G_PKG_NAME
173: ,l_api_name);

Line 176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

172: (G_PKG_NAME
173: ,l_api_name);
174: END IF;
175: g_ser_cascade := FALSE;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: WHEN OTHERS THEN
178: g_ser_cascade := FALSE;
179: IF l_debug_level > 0 THEN
180: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;

Line 187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

183: oe_msg_pub.Add_Exc_Msg
184: (G_PKG_NAME
185: ,l_api_name);
186: END IF;
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: END UpdateLine;
189:
190: PROCEDURE perform_line_change
191: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

Line 259: Nvl(p_line_rec.split_action_code,Fnd_Api.G_Miss_Char) <> 'SPLIT') THEN

255: oe_debug_pub.add('5702849: Value of l_order_quantity_uom :'||l_order_quantity_uom);
256:
257: IF (p_line_rec.operation <> oe_globals.g_opr_create AND
258: -- p_line_rec.split_action_code <> 'SPLIT') THEN -- Bug 8841055
259: Nvl(p_line_rec.split_action_code,Fnd_Api.G_Miss_Char) <> 'SPLIT') THEN
260:
261: IF l_debug_level > 0 THEN
262: oe_debug_pub.add('Entering oe_sales_can_util.perform_line_change' ) ;
263: END IF;

Line 265: x_return_status := FND_API.G_RET_STS_SUCCESS;

261: IF l_debug_level > 0 THEN
262: oe_debug_pub.add('Entering oe_sales_can_util.perform_line_change' ) ;
263: END IF;
264:
265: x_return_status := FND_API.G_RET_STS_SUCCESS;
266:
267: IF (nvl(p_line_rec.ordered_quantity, 0) < nvl(p_old_line_rec.ordered_quantity, 0)) THEN
268: l_cancelled_qty := nvl(p_old_line_rec.ordered_quantity, 0) - nvl(p_line_rec.ordered_quantity, 0);
269: --13939745 start

Line 318: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

314: IF l_debug_level > 0 THEN
315: oe_debug_pub.add('After calling update_service , return status : '||x_return_status,1) ;
316: END IF;
317:
318: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
319: if x_return_status = FND_API.G_RET_STS_ERROR then
320: raise FND_API.G_EXC_ERROR;
321: else
322: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 319: if x_return_status = FND_API.G_RET_STS_ERROR then

315: oe_debug_pub.add('After calling update_service , return status : '||x_return_status,1) ;
316: END IF;
317:
318: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
319: if x_return_status = FND_API.G_RET_STS_ERROR then
320: raise FND_API.G_EXC_ERROR;
321: else
322: raise FND_API.G_EXC_UNEXPECTED_ERROR;
323: end if;

Line 320: raise FND_API.G_EXC_ERROR;

316: END IF;
317:
318: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
319: if x_return_status = FND_API.G_RET_STS_ERROR then
320: raise FND_API.G_EXC_ERROR;
321: else
322: raise FND_API.G_EXC_UNEXPECTED_ERROR;
323: end if;
324: end if;

Line 322: raise FND_API.G_EXC_UNEXPECTED_ERROR;

318: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
319: if x_return_status = FND_API.G_RET_STS_ERROR then
320: raise FND_API.G_EXC_ERROR;
321: else
322: raise FND_API.G_EXC_UNEXPECTED_ERROR;
323: end if;
324: end if;
325:
326: oe_sales_can_util.g_require_reason := l_require_reason ;

Line 382: raise FND_API.G_EXC_ERROR;

378: NULL;
379: WHEN TOO_MANY_ROWS THEN
380: fnd_message.set_name('ONT','OE_CAN_UPDATE_SUPPLY');
381: oe_msg_pub.add;
382: raise FND_API.G_EXC_ERROR;
383: END;
384:
385: IF p_old_line_rec.ordered_quantity <> l_mtl_supply_quantity THEN
386:

Line 389: raise FND_API.G_EXC_ERROR;

385: IF p_old_line_rec.ordered_quantity <> l_mtl_supply_quantity THEN
386:
387: fnd_message.set_name('ONT','OE_CAN_UPDATE_SUPPLY');
388: oe_msg_pub.add;
389: raise FND_API.G_EXC_ERROR;
390: END IF;
391:
392: END IF; -- 6710187 end
393:

Line 415: -- raise FND_API.G_EXC_ERROR;

411:
412: IF po_supply_id IS NULL THEN
413: fnd_message.set_name('ONT','OE_CAN_NO_SUPPLY_ID');
414: oe_msg_pub.add;
415: -- raise FND_API.G_EXC_ERROR;
416: END IF;
417: END IF;
418: END IF; -- For cancellation
419:

Line 441: p_line_rec.change_reason = FND_API.G_MISS_CHAR THEN

437: /* IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN -- reinstated for 2653505
438:
439: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'N' THEN
440: IF p_line_rec.change_reason IS NULL OR
441: p_line_rec.change_reason = FND_API.G_MISS_CHAR THEN
442: IF l_debug_level > 0 THEN
443: oe_debug_pub.add('Cancellation Reason is Not Provided',1);
444: END IF;
445: fnd_message.set_name('ONT','OE_CAN_REASON_NOT');

Line 447: raise FND_API.G_EXC_ERROR;

443: oe_debug_pub.add('Cancellation Reason is Not Provided',1);
444: END IF;
445: fnd_message.set_name('ONT','OE_CAN_REASON_NOT');
446: oe_msg_pub.add;
447: raise FND_API.G_EXC_ERROR;
448: END IF;
449: END IF;
450:
451: ELSE.*/

Line 453: p_line_rec.change_reason = FND_API.G_MISS_CHAR THEN

449: END IF;
450:
451: ELSE.*/
452: IF p_line_rec.change_reason IS NULL OR
453: p_line_rec.change_reason = FND_API.G_MISS_CHAR THEN
454: IF l_debug_level > 0 THEN
455: oe_debug_pub.add('Cancellation Reason is Not Provided',1);
456: END IF;
457: fnd_message.set_name('ONT','OE_CAN_REASON_NOT');

Line 459: raise FND_API.G_EXC_ERROR;

455: oe_debug_pub.add('Cancellation Reason is Not Provided',1);
456: END IF;
457: fnd_message.set_name('ONT','OE_CAN_REASON_NOT');
458: oe_msg_pub.add;
459: raise FND_API.G_EXC_ERROR;
460: END IF;
461: -- END IF;
462: END IF;
463:

Line 464: IF p_line_rec.change_reason IS NOT NULL AND p_line_rec.change_reason <> FND_API.G_MISS_CHAR THEN

460: END IF;
461: -- END IF;
462: END IF;
463:
464: IF p_line_rec.change_reason IS NOT NULL AND p_line_rec.change_reason <> FND_API.G_MISS_CHAR THEN
465:
466: IF l_debug_level > 0 THEN
467: oe_debug_pub.add('Before calling record line history',5);
468: END IF;

Line 495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

491: , p_wf_result_code => 'COMPLETE'
492: , x_return_status => l_return_status);
493:
494: END IF;
495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496: IF l_return_status = FND_API.G_RET_STS_ERROR then
497: RAISE FND_API.G_EXC_ERROR;
498: ELSE
499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 496: IF l_return_status = FND_API.G_RET_STS_ERROR then

492: , x_return_status => l_return_status);
493:
494: END IF;
495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496: IF l_return_status = FND_API.G_RET_STS_ERROR then
497: RAISE FND_API.G_EXC_ERROR;
498: ELSE
499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
500: END IF;

Line 497: RAISE FND_API.G_EXC_ERROR;

493:
494: END IF;
495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496: IF l_return_status = FND_API.G_RET_STS_ERROR then
497: RAISE FND_API.G_EXC_ERROR;
498: ELSE
499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
500: END IF;
501: END IF;

Line 499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
496: IF l_return_status = FND_API.G_RET_STS_ERROR then
497: RAISE FND_API.G_EXC_ERROR;
498: ELSE
499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
500: END IF;
501: END IF;
502:
503: IF l_debug_level > 0 THEN

Line 535: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

531: IF l_debug_level > 0 THEN
532: oe_debug_pub.add( 'JPN: AFTER CALLING NOTIFY_OTA' , 1 ) ;
533: END IF;
534:
535: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
536: if l_return_status = FND_API.G_RET_STS_ERROR then
537: RAISE FND_API.G_EXC_ERROR;
538: else
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 536: if l_return_status = FND_API.G_RET_STS_ERROR then

532: oe_debug_pub.add( 'JPN: AFTER CALLING NOTIFY_OTA' , 1 ) ;
533: END IF;
534:
535: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
536: if l_return_status = FND_API.G_RET_STS_ERROR then
537: RAISE FND_API.G_EXC_ERROR;
538: else
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
540: end if;

Line 537: RAISE FND_API.G_EXC_ERROR;

533: END IF;
534:
535: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
536: if l_return_status = FND_API.G_RET_STS_ERROR then
537: RAISE FND_API.G_EXC_ERROR;
538: else
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
540: end if;
541: end if;

Line 539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

535: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
536: if l_return_status = FND_API.G_RET_STS_ERROR then
537: RAISE FND_API.G_EXC_ERROR;
538: else
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
540: end if;
541: end if;
542: end if;
543:

Line 566: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

562:
563: oe_line_fullfill.cancel_line(p_line_id => p_line_rec.line_id,
564: x_return_status => l_return_status);
565:
566: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
567: if l_return_status = FND_API.G_RET_STS_ERROR then
568: raise FND_API.G_EXC_ERROR;
569: else
570: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 567: if l_return_status = FND_API.G_RET_STS_ERROR then

563: oe_line_fullfill.cancel_line(p_line_id => p_line_rec.line_id,
564: x_return_status => l_return_status);
565:
566: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
567: if l_return_status = FND_API.G_RET_STS_ERROR then
568: raise FND_API.G_EXC_ERROR;
569: else
570: raise FND_API.G_EXC_UNEXPECTED_ERROR;
571: end if;

Line 568: raise FND_API.G_EXC_ERROR;

564: x_return_status => l_return_status);
565:
566: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
567: if l_return_status = FND_API.G_RET_STS_ERROR then
568: raise FND_API.G_EXC_ERROR;
569: else
570: raise FND_API.G_EXC_UNEXPECTED_ERROR;
571: end if;
572: end if;

Line 570: raise FND_API.G_EXC_UNEXPECTED_ERROR;

566: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
567: if l_return_status = FND_API.G_RET_STS_ERROR then
568: raise FND_API.G_EXC_ERROR;
569: else
570: raise FND_API.G_EXC_UNEXPECTED_ERROR;
571: end if;
572: end if;
573: end if;
574:

Line 627: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

623: IF l_debug_level > 0 THEN
624: oe_debug_pub.add( 'AFTER CALLING RELEASE HOLDS :' || L_RETURN_STATUS ) ;
625: END IF;
626:
627: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
628: if l_return_status = FND_API.G_RET_STS_ERROR then
629: raise FND_API.G_EXC_ERROR;
630: else
631: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 628: if l_return_status = FND_API.G_RET_STS_ERROR then

624: oe_debug_pub.add( 'AFTER CALLING RELEASE HOLDS :' || L_RETURN_STATUS ) ;
625: END IF;
626:
627: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
628: if l_return_status = FND_API.G_RET_STS_ERROR then
629: raise FND_API.G_EXC_ERROR;
630: else
631: raise FND_API.G_EXC_UNEXPECTED_ERROR;
632: end if;

Line 629: raise FND_API.G_EXC_ERROR;

625: END IF;
626:
627: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
628: if l_return_status = FND_API.G_RET_STS_ERROR then
629: raise FND_API.G_EXC_ERROR;
630: else
631: raise FND_API.G_EXC_UNEXPECTED_ERROR;
632: end if;
633: end if;

Line 631: raise FND_API.G_EXC_UNEXPECTED_ERROR;

627: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
628: if l_return_status = FND_API.G_RET_STS_ERROR then
629: raise FND_API.G_EXC_ERROR;
630: else
631: raise FND_API.G_EXC_UNEXPECTED_ERROR;
632: end if;
633: end if;
634: End if; -- Rlease holds
635:

Line 660: WHEN FND_API.G_EXC_ERROR THEN

656: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.PERFORM_LINE_CHANGE' ) ;
657: END IF;
658:
659: EXCEPTION
660: WHEN FND_API.G_EXC_ERROR THEN
661: x_return_status := FND_API.G_RET_STS_ERROR;
662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
663: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
664: oe_msg_pub.Add_Exc_Msg

Line 661: x_return_status := FND_API.G_RET_STS_ERROR;

657: END IF;
658:
659: EXCEPTION
660: WHEN FND_API.G_EXC_ERROR THEN
661: x_return_status := FND_API.G_RET_STS_ERROR;
662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
663: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
664: oe_msg_pub.Add_Exc_Msg
665: (G_PKG_NAME

Line 662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

658:
659: EXCEPTION
660: WHEN FND_API.G_EXC_ERROR THEN
661: x_return_status := FND_API.G_RET_STS_ERROR;
662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
663: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
664: oe_msg_pub.Add_Exc_Msg
665: (G_PKG_NAME
666: ,l_api_name);

Line 668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

664: oe_msg_pub.Add_Exc_Msg
665: (G_PKG_NAME
666: ,l_api_name);
667: END IF;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: WHEN OTHERS THEN
670: IF l_debug_level > 0 THEN
671: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || 'PERFORM_LINE_CHANGE' ) ;
672: END IF;

Line 678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

674: oe_msg_pub.Add_Exc_Msg
675: (G_PKG_NAME
676: ,l_api_name);
677: END IF;
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: END Perform_Line_change;
680:
681: -- Comment Label for procedure added as part of Inline Documentation Drive.
682: ---------------------------------------------------------------------------------

Line 708: l_return_status VARCHAR2(30) :=FND_API.G_RET_STS_SUCCESS;

704: , x_return_status OUT NOCOPY varchar2
705:
706: )
707: IS
708: l_return_status VARCHAR2(30) :=FND_API.G_RET_STS_SUCCESS;
709: --l_line_Rec oe_order_pub.line_rec_type := p_line_Rec;
710: x_result NUMBER := 0 ;
711: x_msg_count NUMBER;
712: x_msg_data VARCHAR2(255);

Line 729: l_return_status := FND_API.G_RET_STS_SUCCESS;

725: IF l_debug_level > 0 THEN
726: oe_debug_pub.add( 'ENTERING OE_SALES_CAN_UTIL.CHECK_CONSTRAINTS' ) ;
727: END IF;
728: -- initialize API return status to success
729: l_return_status := FND_API.G_RET_STS_SUCCESS;
730:
731: IF l_debug_level > 0 THEN
732: oe_debug_pub.add( 'CHECKING CONSTRAINTS FOR LINE ID '|| TO_CHAR ( P_X_LINE_REC.LINE_ID ) ) ;
733: END IF;

Line 738: RAISE FND_API.G_EXC_ERROR ;

734:
735: if ( p_old_line_rec.cancelled_flag = 'Y') then
736: fnd_message.set_name('ONT', 'OE_CANCEL_NOTHING');
737: oe_msg_pub.add;
738: RAISE FND_API.G_EXC_ERROR ;
739: end if;
740:
741: -- Check if line is booked and and is not a cancellations and orderquantity is
742: -- zero

Line 757: RAISE FND_API.G_EXC_ERROR ;

753: nvl(p_x_line_rec.ordered_quantity,0) = 0 ) THEN
754:
755: fnd_message.set_name('ONT', 'OE_QTY_ZERO_NOT_ALLOWED');
756: oe_msg_pub.add;
757: RAISE FND_API.G_EXC_ERROR ;
758: END IF;
759: END IF;
760:
761: -- Check Service here. We allow only full cancellation of service

Line 774: RAISE FND_API.G_EXC_ERROR;

770: if (p_x_line_rec.Ordered_Quantity <>
771: p_old_line_rec.Ordered_Quantity) THEN
772: fnd_message.set_name('ONT', 'OE_CAN_SERV_AMT_NOT_ALLOWED');
773: oe_msg_pub.add;
774: RAISE FND_API.G_EXC_ERROR;
775: end if;
776: end if;
777:
778: -- Set Ordered level cancellation to true or false

Line 951: WHEN FND_API.G_EXC_ERROR THEN

947:
948: END IF;
949:
950: EXCEPTION
951: WHEN FND_API.G_EXC_ERROR THEN
952: x_return_status := FND_API.G_RET_STS_ERROR;
953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
954: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
955: oe_msg_pub.Add_Exc_Msg

Line 952: x_return_status := FND_API.G_RET_STS_ERROR;

948: END IF;
949:
950: EXCEPTION
951: WHEN FND_API.G_EXC_ERROR THEN
952: x_return_status := FND_API.G_RET_STS_ERROR;
953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
954: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
955: oe_msg_pub.Add_Exc_Msg
956: (G_PKG_NAME

Line 953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

949:
950: EXCEPTION
951: WHEN FND_API.G_EXC_ERROR THEN
952: x_return_status := FND_API.G_RET_STS_ERROR;
953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
954: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
955: oe_msg_pub.Add_Exc_Msg
956: (G_PKG_NAME
957: ,l_api_name);

Line 959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

955: oe_msg_pub.Add_Exc_Msg
956: (G_PKG_NAME
957: ,l_api_name);
958: END IF;
959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
960: WHEN OTHERS THEN
961: IF l_debug_level > 0 THEN
962: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
963: END IF;

Line 969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

965: oe_msg_pub.Add_Exc_Msg
966: (G_PKG_NAME
967: ,l_api_name);
968: END IF;
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
970:
971: END check_constraints;
972:
973: PROCEDURE update_service

Line 1038: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1034: END IF;
1035:
1036: end loop;
1037:
1038: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1039: if l_return_status = FND_API.G_RET_STS_ERROR then
1040: raise FND_API.G_EXC_ERROR;
1041: else
1042: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1039: if l_return_status = FND_API.G_RET_STS_ERROR then

1035:
1036: end loop;
1037:
1038: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1039: if l_return_status = FND_API.G_RET_STS_ERROR then
1040: raise FND_API.G_EXC_ERROR;
1041: else
1042: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1043: end if;

Line 1040: raise FND_API.G_EXC_ERROR;

1036: end loop;
1037:
1038: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1039: if l_return_status = FND_API.G_RET_STS_ERROR then
1040: raise FND_API.G_EXC_ERROR;
1041: else
1042: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1043: end if;
1044: end if;

Line 1042: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1038: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1039: if l_return_status = FND_API.G_RET_STS_ERROR then
1040: raise FND_API.G_EXC_ERROR;
1041: else
1042: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1043: end if;
1044: end if;
1045:
1046: IF l_debug_level > 0 THEN

Line 1051: WHEN FND_API.G_EXC_ERROR THEN

1047: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.UPDATE_SERVICE' ) ;
1048: END IF;
1049:
1050: EXCEPTION
1051: WHEN FND_API.G_EXC_ERROR THEN
1052: x_return_status := FND_API.G_RET_STS_ERROR;
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1055: oe_msg_pub.Add_Exc_Msg

Line 1052: x_return_status := FND_API.G_RET_STS_ERROR;

1048: END IF;
1049:
1050: EXCEPTION
1051: WHEN FND_API.G_EXC_ERROR THEN
1052: x_return_status := FND_API.G_RET_STS_ERROR;
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1055: oe_msg_pub.Add_Exc_Msg
1056: (G_PKG_NAME

Line 1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1049:
1050: EXCEPTION
1051: WHEN FND_API.G_EXC_ERROR THEN
1052: x_return_status := FND_API.G_RET_STS_ERROR;
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1055: oe_msg_pub.Add_Exc_Msg
1056: (G_PKG_NAME
1057: ,l_api_name);

Line 1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1055: oe_msg_pub.Add_Exc_Msg
1056: (G_PKG_NAME
1057: ,l_api_name);
1058: END IF;
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: WHEN OTHERS THEN
1061: IF l_debug_level > 0 THEN
1062: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
1063: END IF;

Line 1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1065: oe_msg_pub.Add_Exc_Msg
1066: (G_PKG_NAME
1067: ,l_api_name);
1068: END IF;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070: end update_service;
1071:
1072: FUNCTION Cal_Cancelled_Qty
1073: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

Line 1157: IF p_old_line_rec.cancelled_quantity = FND_API.G_MISS_NUM OR

1153: IF (p_old_line_rec.ordered_quantity > p_line_rec.ordered_quantity) THEN
1154: l_ordered_quantity :=
1155: (p_old_line_rec.ordered_quantity - p_line_rec.ordered_quantity);
1156:
1157: IF p_old_line_rec.cancelled_quantity = FND_API.G_MISS_NUM OR
1158: p_old_line_rec.cancelled_quantity is NULL THEN
1159: oe_debug_pub.ADD('rajeevcancell');
1160: RETURN l_ordered_quantity;
1161: ELSE

Line 1176: IF p_old_line_rec.cancelled_quantity = FND_API.G_MISS_NUM OR

1172: IF (p_old_line_rec.ordered_quantity < p_line_rec.ordered_quantity) THEN
1173: l_ordered_quantity :=
1174: (p_old_line_rec.ordered_quantity - p_line_rec.ordered_quantity);
1175:
1176: IF p_old_line_rec.cancelled_quantity = FND_API.G_MISS_NUM OR
1177: p_old_line_rec.cancelled_quantity is NULL THEN
1178: RETURN l_ordered_quantity;
1179: ELSE
1180: RETURN (l_ordered_quantity +

Line 1215: l_return_status varchar2(30) :=FND_API.G_RET_STS_SUCCESS;

1211: , x_return_status OUT NOCOPY VARCHAR2
1212:
1213: ) IS
1214: l_api_name CONSTANT VARCHAR2(30) := 'Check_Constraints';
1215: l_return_status varchar2(30) :=FND_API.G_RET_STS_SUCCESS;
1216: x_result NUMBER := 0 ;
1217: l_constrain_all_flag varchar2(255);
1218: l_constraint_id NUMBER;
1219: l_resolving_wf_activity_name varchar2(255);

Line 1235: x_return_status := FND_API.G_RET_STS_SUCCESS;

1231: IF l_debug_level > 0 THEN
1232: oe_debug_pub.add( 'IN CHECK CONSTRAINS FOR CANCELLATION' ) ;
1233: END IF;
1234: -- initialize API return status to success
1235: x_return_status := FND_API.G_RET_STS_SUCCESS;
1236: -- Prepare security record
1237:
1238: EXCEPTION
1239: WHEN FND_API.G_EXC_ERROR THEN

Line 1239: WHEN FND_API.G_EXC_ERROR THEN

1235: x_return_status := FND_API.G_RET_STS_SUCCESS;
1236: -- Prepare security record
1237:
1238: EXCEPTION
1239: WHEN FND_API.G_EXC_ERROR THEN
1240: x_return_status := FND_API.G_RET_STS_ERROR;
1241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1242: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1243: oe_msg_pub.Add_Exc_Msg

Line 1240: x_return_status := FND_API.G_RET_STS_ERROR;

1236: -- Prepare security record
1237:
1238: EXCEPTION
1239: WHEN FND_API.G_EXC_ERROR THEN
1240: x_return_status := FND_API.G_RET_STS_ERROR;
1241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1242: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1243: oe_msg_pub.Add_Exc_Msg
1244: (G_PKG_NAME

Line 1241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1237:
1238: EXCEPTION
1239: WHEN FND_API.G_EXC_ERROR THEN
1240: x_return_status := FND_API.G_RET_STS_ERROR;
1241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1242: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1243: oe_msg_pub.Add_Exc_Msg
1244: (G_PKG_NAME
1245: ,l_api_name);

Line 1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1243: oe_msg_pub.Add_Exc_Msg
1244: (G_PKG_NAME
1245: ,l_api_name);
1246: END IF;
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1248: WHEN OTHERS THEN
1249: IF l_debug_level > 0 THEN
1250: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
1251: END IF;

Line 1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1253: oe_msg_pub.Add_Exc_Msg
1254: (G_PKG_NAME
1255: ,l_api_name);
1256: END IF;
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: end check_constraints;
1259:
1260: PROCEDURE perform_cancel_order
1261: ( p_header_rec IN OE_Order_PUB.header_Rec_Type

Line 1309: raise FND_API.G_EXC_ERROR;

1305: END IF;
1306: IF p_header_rec.change_reason IS NULL THEN
1307: fnd_message.set_name('ONT','OE_CAN_REASON_NOT');
1308: oe_msg_pub.add;
1309: raise FND_API.G_EXC_ERROR;
1310: END IF;
1311: END IF;
1312:
1313: oe_line_util.Query_Rows( p_header_id => p_header_rec.header_id

Line 1389: l_line_tbl(i).db_flag := FND_API.G_TRUE;

1385: i := i + 1;
1386:
1387: l_line_tbl(i) := l_line_old_tbl(j);
1388: l_x_line_old_tbl(i) := l_line_old_tbl(j);
1389: l_line_tbl(i).db_flag := FND_API.G_TRUE;
1390: --l_line_tbl(i).cancelled_quantity := l_line_tbl(i).ordered_quantity;
1391: l_line_tbl(i).ordered_quantity :=0;
1392: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
1393: l_line_tbl(i).change_reason :=p_header_rec.change_reason;

Line 1423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1419: l_x_line_old_tbl,
1420: l_return_status);
1421: END IF;
1422:
1423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN UNEXP_ERROR' ) ;
1426: END IF;
1427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN UNEXP_ERROR' ) ;
1426: END IF;
1427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1429: IF l_debug_level > 0 THEN
1430: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN RET_STS_ERROR' ) ;
1431: END IF;

Line 1428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1424: IF l_debug_level > 0 THEN
1425: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN UNEXP_ERROR' ) ;
1426: END IF;
1427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1429: IF l_debug_level > 0 THEN
1430: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN RET_STS_ERROR' ) ;
1431: END IF;
1432: RAISE FND_API.G_EXC_ERROR;

Line 1432: RAISE FND_API.G_EXC_ERROR;

1428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1429: IF l_debug_level > 0 THEN
1430: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN RET_STS_ERROR' ) ;
1431: END IF;
1432: RAISE FND_API.G_EXC_ERROR;
1433: END IF;
1434:
1435:
1436: -- Need to process payment refund if there is any prepayment.

Line 1452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1448: IF l_debug_level > 0 THEN
1449: oe_debug_pub.add('return status after calling process_payment_refund is: '||x_return_status, 3);
1450: END IF;
1451:
1452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1453: RAISE FND_API.G_EXC_ERROR;
1454: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1456: END IF;

Line 1453: RAISE FND_API.G_EXC_ERROR;

1449: oe_debug_pub.add('return status after calling process_payment_refund is: '||x_return_status, 3);
1450: END IF;
1451:
1452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1453: RAISE FND_API.G_EXC_ERROR;
1454: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1456: END IF;
1457: ELSIF NVL(p_header_rec.payment_type_code,'NULL') = 'CREDIT_CARD'

Line 1454: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1450: END IF;
1451:
1452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1453: RAISE FND_API.G_EXC_ERROR;
1454: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1456: END IF;
1457: ELSIF NVL(p_header_rec.payment_type_code,'NULL') = 'CREDIT_CARD'
1458: AND OE_PrePayment_UTIL.is_prepaid_order(p_header_rec) = 'Y'

Line 1455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1451:
1452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1453: RAISE FND_API.G_EXC_ERROR;
1454: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1456: END IF;
1457: ELSIF NVL(p_header_rec.payment_type_code,'NULL') = 'CREDIT_CARD'
1458: AND OE_PrePayment_UTIL.is_prepaid_order(p_header_rec) = 'Y'
1459: THEN

Line 1464: , p_delayed_request => FND_API.G_FALSE

1460: oe_debug_pub.ADD('Calling Payment Refund.');
1461: OE_PrePayment_PVT.Process_PrePayment_Order
1462: ( p_header_rec => p_header_rec
1463: , p_calling_action => NULL
1464: , p_delayed_request => FND_API.G_FALSE
1465: , x_msg_count => l_msg_count
1466: , x_msg_data => l_msg_data
1467: , x_return_status => x_return_status
1468: );

Line 1473: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1469: IF l_debug_level > 0 THEN
1470: oe_debug_pub.add('return status after calling process_prepayment_order is: '||x_return_status, 3);
1471: END IF;
1472:
1473: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1474: RAISE FND_API.G_EXC_ERROR;
1475: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477: END IF;

Line 1474: RAISE FND_API.G_EXC_ERROR;

1470: oe_debug_pub.add('return status after calling process_prepayment_order is: '||x_return_status, 3);
1471: END IF;
1472:
1473: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1474: RAISE FND_API.G_EXC_ERROR;
1475: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477: END IF;
1478: END IF;

Line 1475: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1471: END IF;
1472:
1473: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1474: RAISE FND_API.G_EXC_ERROR;
1475: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477: END IF;
1478: END IF;
1479:

Line 1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1472:
1473: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1474: RAISE FND_API.G_EXC_ERROR;
1475: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477: END IF;
1478: END IF;
1479:
1480: -- Release Holds

Line 1503: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1499: IF l_debug_level > 0 THEN
1500: oe_debug_pub.add( 'THE HOLD RELEASED WITH STATUS :'|| L_RETURN_STATUS ) ;
1501: END IF;
1502:
1503: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1504: if l_return_status = FND_API.G_RET_STS_ERROR then
1505: raise FND_API.G_EXC_ERROR;
1506: else
1507: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1504: if l_return_status = FND_API.G_RET_STS_ERROR then

1500: oe_debug_pub.add( 'THE HOLD RELEASED WITH STATUS :'|| L_RETURN_STATUS ) ;
1501: END IF;
1502:
1503: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1504: if l_return_status = FND_API.G_RET_STS_ERROR then
1505: raise FND_API.G_EXC_ERROR;
1506: else
1507: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1508: end if;

Line 1505: raise FND_API.G_EXC_ERROR;

1501: END IF;
1502:
1503: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1504: if l_return_status = FND_API.G_RET_STS_ERROR then
1505: raise FND_API.G_EXC_ERROR;
1506: else
1507: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1508: end if;
1509: end if;

Line 1507: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1503: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1504: if l_return_status = FND_API.G_RET_STS_ERROR then
1505: raise FND_API.G_EXC_ERROR;
1506: else
1507: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1508: end if;
1509: end if;
1510:
1511: /*

Line 1530: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1526: , p_msg_data => l_msg_data
1527: , p_result_out => l_result_out
1528: , p_return_status => l_return_status
1529: );
1530: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1531: RAISE FND_API.G_EXC_ERROR;
1532: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1534: END IF;

Line 1531: RAISE FND_API.G_EXC_ERROR;

1527: , p_result_out => l_result_out
1528: , p_return_status => l_return_status
1529: );
1530: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1531: RAISE FND_API.G_EXC_ERROR;
1532: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1534: END IF;
1535: END IF; -- IF Credit Card Approval Code is NOT NULL

Line 1532: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1528: , p_return_status => l_return_status
1529: );
1530: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1531: RAISE FND_API.G_EXC_ERROR;
1532: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1534: END IF;
1535: END IF; -- IF Credit Card Approval Code is NOT NULL
1536: */

Line 1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1529: );
1530: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1531: RAISE FND_API.G_EXC_ERROR;
1532: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1534: END IF;
1535: END IF; -- IF Credit Card Approval Code is NOT NULL
1536: */
1537:

Line 1559: WHEN FND_API.G_EXC_ERROR THEN

1555: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.PERFORM_CANCEL_ORDER' ) ;
1556: END IF;
1557:
1558: EXCEPTION
1559: WHEN FND_API.G_EXC_ERROR THEN
1560: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1563: --g_ord_lvl_can := FALSE; Commented for bug# 2922468

Line 1561: x_return_status := FND_API.G_RET_STS_ERROR;

1557:
1558: EXCEPTION
1559: WHEN FND_API.G_EXC_ERROR THEN
1560: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1563: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1565: WHEN OTHERS THEN

Line 1562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1558: EXCEPTION
1559: WHEN FND_API.G_EXC_ERROR THEN
1560: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1563: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1565: WHEN OTHERS THEN
1566: --g_ord_lvl_can := FALSE; Commented for bug# 2922468

Line 1564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1560: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1563: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1565: WHEN OTHERS THEN
1566: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1567: x_return_status := FND_API.G_RET_STS_ERROR;

1563: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1565: WHEN OTHERS THEN
1566: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1569: oe_msg_pub.Add_Exc_Msg
1570: (G_PKG_NAME
1571: ,'Peform_Cancel_order');

Line 1620: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

1616: oe_debug_pub.add( 'BEFORE CALLING PROCESS ORDER' ) ;
1617: END IF;
1618:
1619: oe_order_pvt.Lines
1620: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1621: , p_control_rec => l_control_rec
1622: , p_x_line_tbl => l_line_tbl
1623: , p_x_old_line_tbl => l_old_line_tbl
1624: , x_return_status => x_return_status

Line 1631: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1627: IF l_debug_level > 0 THEN
1628: oe_debug_pub.add( 'AFTER CALLING PROCESS ORDER' ) ;
1629: END IF;
1630:
1631: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1633: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1634: RAISE FND_API.G_EXC_ERROR;
1635: END IF;

Line 1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1628: oe_debug_pub.add( 'AFTER CALLING PROCESS ORDER' ) ;
1629: END IF;
1630:
1631: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1633: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1634: RAISE FND_API.G_EXC_ERROR;
1635: END IF;
1636:

Line 1633: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1629: END IF;
1630:
1631: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1633: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1634: RAISE FND_API.G_EXC_ERROR;
1635: END IF;
1636:
1637: -- Api to call OC and ACK and process delayed requests

Line 1634: RAISE FND_API.G_EXC_ERROR;

1630:
1631: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1633: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1634: RAISE FND_API.G_EXC_ERROR;
1635: END IF;
1636:
1637: -- Api to call OC and ACK and process delayed requests
1638: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110508' THEN -- reinstated for 2653505

Line 1648: if l_line_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN

1644: , p_old_line_tbl => l_old_line_tbl
1645: );
1646:
1647: FOR I IN 1..l_line_tbl.COUNT LOOP
1648: if l_line_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
1649: x_return_status := FND_API.G_RET_STS_ERROR;
1650: elsif l_line_tbl(I).return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1652: end if;

Line 1649: x_return_status := FND_API.G_RET_STS_ERROR;

1645: );
1646:
1647: FOR I IN 1..l_line_tbl.COUNT LOOP
1648: if l_line_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
1649: x_return_status := FND_API.G_RET_STS_ERROR;
1650: elsif l_line_tbl(I).return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1652: end if;
1653: end loop;

Line 1650: elsif l_line_tbl(I).return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1646:
1647: FOR I IN 1..l_line_tbl.COUNT LOOP
1648: if l_line_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
1649: x_return_status := FND_API.G_RET_STS_ERROR;
1650: elsif l_line_tbl(I).return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1652: end if;
1653: end loop;
1654: END IF; -- 2653505

Line 1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1647: FOR I IN 1..l_line_tbl.COUNT LOOP
1648: if l_line_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
1649: x_return_status := FND_API.G_RET_STS_ERROR;
1650: elsif l_line_tbl(I).return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1652: end if;
1653: end loop;
1654: END IF; -- 2653505
1655:

Line 1661: WHEN FND_API.G_EXC_ERROR THEN

1657: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.PERFORMLINECANCELLATION' ) ;
1658: END IF;
1659:
1660: EXCEPTION
1661: WHEN FND_API.G_EXC_ERROR THEN
1662: x_return_status := FND_API.G_RET_STS_ERROR;
1663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: WHEN OTHERS THEN

Line 1662: x_return_status := FND_API.G_RET_STS_ERROR;

1658: END IF;
1659:
1660: EXCEPTION
1661: WHEN FND_API.G_EXC_ERROR THEN
1662: x_return_status := FND_API.G_RET_STS_ERROR;
1663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: WHEN OTHERS THEN
1666: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1659:
1660: EXCEPTION
1661: WHEN FND_API.G_EXC_ERROR THEN
1662: x_return_status := FND_API.G_RET_STS_ERROR;
1663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: WHEN OTHERS THEN
1666: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1667: oe_msg_pub.Add_Exc_Msg

Line 1664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1660: EXCEPTION
1661: WHEN FND_API.G_EXC_ERROR THEN
1662: x_return_status := FND_API.G_RET_STS_ERROR;
1663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1665: WHEN OTHERS THEN
1666: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1667: oe_msg_pub.Add_Exc_Msg
1668: (G_PKG_NAME

Line 1671: x_return_status := FND_API.G_RET_STS_ERROR;

1667: oe_msg_pub.Add_Exc_Msg
1668: (G_PKG_NAME
1669: ,'PeformLineCancellation');
1670: END IF;
1671: x_return_status := FND_API.G_RET_STS_ERROR;
1672:
1673: END PerformLineCancellation;
1674:
1675: FUNCTION Query_Rows

Line 1677: FND_API.G_MISS_NUM

1673: END PerformLineCancellation;
1674:
1675: FUNCTION Query_Rows
1676: ( p_line_id IN NUMBER :=
1677: FND_API.G_MISS_NUM
1678: , p_header_id IN NUMBER :=
1679: FND_API.G_MISS_NUM
1680: ) RETURN OE_Order_PUB.Line_Tbl_Type
1681: IS

Line 1679: FND_API.G_MISS_NUM

1675: FUNCTION Query_Rows
1676: ( p_line_id IN NUMBER :=
1677: FND_API.G_MISS_NUM
1678: , p_header_id IN NUMBER :=
1679: FND_API.G_MISS_NUM
1680: ) RETURN OE_Order_PUB.Line_Tbl_Type
1681: IS
1682: l_line_rec OE_Order_PUB.Line_Rec_Type;
1683: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1700: RETURN l_line_tbl;
1701:
1702: EXCEPTION
1703:
1704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1705:
1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1707:
1708: WHEN OTHERS THEN

Line 1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1702: EXCEPTION
1703:
1704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1705:
1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1707:
1708: WHEN OTHERS THEN
1709:
1710: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1714: , 'Query_Rows'
1715: );
1716: END IF;
1717:
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1719:
1720: END Query_Rows;
1721:
1722: -- bug 4887806

Line 1829: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1825: , x_return_status => l_return_status
1826: , x_msg_count => l_msg_count
1827: , x_msg_data => l_msg_data);
1828:
1829: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1830: IF l_debug_level > 0 THEN
1831: oe_debug_pub.add('Exception from Process_Fulfillment:'||l_result_out,2);
1832: END IF;
1833: OE_MSG_PUB.Add_Text(p_message_text => l_msg_data);

Line 1837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1833: OE_MSG_PUB.Add_Text(p_message_text => l_msg_data);
1834: OE_MSG_PUB.Save_API_Messages;
1835:
1836: ROLLBACK TO Process_Set;
1837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1838:
1839: ELSE -- fulfillment of all related lines was successful
1840: l_item_key := to_char(l_line_id);
1841: Oe_line_fullfill.Get_Activity_Result(

Line 1854: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND

1850: IF l_debug_level > 0 THEN
1851: oe_debug_pub.add('After Get_Activity_Result, ret status:'||l_return_status||' ,Fulfill:'||l_activity_status,3);
1852: END IF;
1853:
1854: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND
1855: l_activity_status = 'NOTIFIED' THEN
1856: IF l_debug_level > 0 THEN
1857: oe_debug_pub.add('Calling wf_engine.CompleteActivityInternalName for lineID='||l_item_key,2);
1858: END IF;

Line 1886: p_header_id IN NUMBER := FND_API.G_MISS_NUM

1882: END Call_Process_Fulfillment;
1883:
1884: PROCEDURE Cancel_Remaining_Order
1885: ( p_header_Rec IN OE_Order_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC,
1886: p_header_id IN NUMBER := FND_API.G_MISS_NUM
1887: , x_return_status OUT NOCOPY VARCHAR2
1888:
1889: )
1890: IS

Line 1920: x_return_status := FND_API.G_RET_STS_SUCCESS;

1916: IF l_debug_level > 0 THEN
1917: oe_debug_pub.add( 'ENTERING OE_SALES_CAN_UTIL.CANCEL_REMAINING_ORDER' ) ;
1918: END IF;
1919:
1920: x_return_status := FND_API.G_RET_STS_SUCCESS;
1921:
1922: g_par_ord_lvl_can := TRUE; --Fix for bug 2230777
1923:
1924: l_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;

Line 1926: IF (p_header_rec.header_id = FND_API.G_MISS_NUM OR

1922: g_par_ord_lvl_can := TRUE; --Fix for bug 2230777
1923:
1924: l_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
1925:
1926: IF (p_header_rec.header_id = FND_API.G_MISS_NUM OR
1927: p_header_rec.header_id = NULL) THEN
1928: l_header_id := p_header_id;
1929: ELSE
1930: l_header_id := p_header_rec.header_id;

Line 2026: l_line_tbl(J).db_flag := FND_API.G_TRUE;

2022: J := J + 1;
2023:
2024: l_line_tbl(J) := l_line_old_tbl(I);
2025: l_x_line_old_tbl(J) := l_line_old_tbl(I);
2026: l_line_tbl(J).db_flag := FND_API.G_TRUE;
2027: --l_line_tbl(J).cancelled_quantity := l_line_tbl(J).ordered_quantity;
2028: l_line_tbl(j).ordered_quantity :=0;
2029: l_line_tbl(j).operation := OE_GLOBALS.G_OPR_UPDATE;
2030: l_line_tbl(j).change_reason :=p_header_rec.change_reason;

Line 2066: RAISE FND_API.G_EXC_ERROR;

2062: IF l_line_tbl.count = 0 THEN
2063: FND_MESSAGE.SET_NAME('ONT','OE_NO_ELIGIBLE_LINES');
2064: FND_MESSAGE.SET_TOKEN('ORDER', L_header_rec.Order_Number);
2065: OE_MSG_PUB.ADD;
2066: RAISE FND_API.G_EXC_ERROR;
2067: END IF;
2068:
2069: IF l_debug_level > 0 THEN
2070: oe_debug_pub.add( 'BEFORE CALLING PERFORM LINE CANCELLATION' ) ;

Line 2078: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2074: PerformLinecancellation(l_line_tbl,
2075: l_x_line_old_tbl,
2076: x_return_status => l_return_status);
2077:
2078: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2079: IF l_debug_level > 0 THEN
2080: oe_debug_pub.add( 'PERFORM LINE CANCELLATION UNEXP_ERROR' ) ;
2081: END IF;
2082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2078: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2079: IF l_debug_level > 0 THEN
2080: oe_debug_pub.add( 'PERFORM LINE CANCELLATION UNEXP_ERROR' ) ;
2081: END IF;
2082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2083: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2084: IF l_debug_level > 0 THEN
2085: oe_debug_pub.add( 'PERFORM LINE CANCELLATION RET_STS_ERROR' ) ;
2086: END IF;

Line 2083: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2079: IF l_debug_level > 0 THEN
2080: oe_debug_pub.add( 'PERFORM LINE CANCELLATION UNEXP_ERROR' ) ;
2081: END IF;
2082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2083: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2084: IF l_debug_level > 0 THEN
2085: oe_debug_pub.add( 'PERFORM LINE CANCELLATION RET_STS_ERROR' ) ;
2086: END IF;
2087: RAISE FND_API.G_EXC_ERROR;

Line 2087: RAISE FND_API.G_EXC_ERROR;

2083: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2084: IF l_debug_level > 0 THEN
2085: oe_debug_pub.add( 'PERFORM LINE CANCELLATION RET_STS_ERROR' ) ;
2086: END IF;
2087: RAISE FND_API.G_EXC_ERROR;
2088: END IF;
2089:
2090: g_par_ord_lvl_can := FALSE;
2091:

Line 2100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2096: , x_return_status => l_return_status
2097: , p_line_tbl => l_line_tbl
2098: , p_old_line_tbl => l_x_line_old_tbl
2099: );
2100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2101: IF l_debug_level > 0 THEN
2102: oe_debug_pub.add( 'Process_requests_and_notify UNEXP_ERROR' ) ;
2103: END IF;
2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2101: IF l_debug_level > 0 THEN
2102: oe_debug_pub.add( 'Process_requests_and_notify UNEXP_ERROR' ) ;
2103: END IF;
2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2105: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2106: IF l_debug_level > 0 THEN
2107: oe_debug_pub.add( 'Process_requests_and_notify RET_STS_ERROR' ) ;
2108: END IF;

Line 2105: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2101: IF l_debug_level > 0 THEN
2102: oe_debug_pub.add( 'Process_requests_and_notify UNEXP_ERROR' ) ;
2103: END IF;
2104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2105: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2106: IF l_debug_level > 0 THEN
2107: oe_debug_pub.add( 'Process_requests_and_notify RET_STS_ERROR' ) ;
2108: END IF;
2109: RAISE FND_API.G_EXC_ERROR;

Line 2109: RAISE FND_API.G_EXC_ERROR;

2105: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2106: IF l_debug_level > 0 THEN
2107: oe_debug_pub.add( 'Process_requests_and_notify RET_STS_ERROR' ) ;
2108: END IF;
2109: RAISE FND_API.G_EXC_ERROR;
2110: END IF;
2111: --end bug 4567339
2112:
2113: -- bug 4887806

Line 2121: WHEN FND_API.G_EXC_ERROR THEN

2117: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.CANCEL_REMAINING_ORDER' ) ;
2118: END IF;
2119:
2120: EXCEPTION
2121: WHEN FND_API.G_EXC_ERROR THEN
2122: g_par_ord_lvl_can := FALSE;
2123: x_return_status := FND_API.G_RET_STS_ERROR;
2124: WHEN OTHERS THEN
2125: g_par_ord_lvl_can := FALSE;

Line 2123: x_return_status := FND_API.G_RET_STS_ERROR;

2119:
2120: EXCEPTION
2121: WHEN FND_API.G_EXC_ERROR THEN
2122: g_par_ord_lvl_can := FALSE;
2123: x_return_status := FND_API.G_RET_STS_ERROR;
2124: WHEN OTHERS THEN
2125: g_par_ord_lvl_can := FALSE;
2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2127: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2122: g_par_ord_lvl_can := FALSE;
2123: x_return_status := FND_API.G_RET_STS_ERROR;
2124: WHEN OTHERS THEN
2125: g_par_ord_lvl_can := FALSE;
2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2127: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2128: THEN
2129: OE_MSG_PUB.Add_Exc_Msg
2130: ( G_PKG_NAME ,

Line 2218: WHEN FND_API.G_EXC_ERROR THEN

2214: END IF;
2215:
2216: EXCEPTION
2217:
2218: WHEN FND_API.G_EXC_ERROR THEN
2219:
2220: x_return_status := FND_API.G_RET_STS_ERROR;
2221:
2222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2220: x_return_status := FND_API.G_RET_STS_ERROR;

2216: EXCEPTION
2217:
2218: WHEN FND_API.G_EXC_ERROR THEN
2219:
2220: x_return_status := FND_API.G_RET_STS_ERROR;
2221:
2222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2223:
2224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2218: WHEN FND_API.G_EXC_ERROR THEN
2219:
2220: x_return_status := FND_API.G_RET_STS_ERROR;
2221:
2222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2223:
2224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2225:
2226: WHEN OTHERS THEN

Line 2224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2220: x_return_status := FND_API.G_RET_STS_ERROR;
2221:
2222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2223:
2224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2225:
2226: WHEN OTHERS THEN
2227:
2228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2225:
2226: WHEN OTHERS THEN
2227:
2228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2229:
2230: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2231: THEN
2232: OE_MSG_PUB.Add_Exc_Msg

Line 2331: IF p_old_line_rec.cancelled_quantity = FND_API.G_MISS_NUM OR

2327: IF (p_old_line_rec.ordered_quantity > p_line_rec.ordered_quantity) THEN
2328: l_ordered_quantity :=
2329: (p_old_line_rec.ordered_quantity - p_line_rec.ordered_quantity);
2330:
2331: IF p_old_line_rec.cancelled_quantity = FND_API.G_MISS_NUM OR
2332: p_old_line_rec.cancelled_quantity is NULL THEN
2333: oe_debug_pub.ADD('rajeevcancell');
2334: RETURN l_ordered_quantity;
2335: ELSE

Line 2350: IF p_old_line_rec.cancelled_quantity = FND_API.G_MISS_NUM OR

2346: IF (p_old_line_rec.ordered_quantity < p_line_rec.ordered_quantity) THEN
2347: l_ordered_quantity :=
2348: (p_old_line_rec.ordered_quantity - p_line_rec.ordered_quantity);
2349:
2350: IF p_old_line_rec.cancelled_quantity = FND_API.G_MISS_NUM OR
2351: p_old_line_rec.cancelled_quantity is NULL THEN
2352: RETURN l_ordered_quantity;
2353: ELSE
2354: RETURN (l_ordered_quantity +