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 264: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 314: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 315: if x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 316: raise FND_API.G_EXC_ERROR;

312: END IF;
313:
314: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
315: if x_return_status = FND_API.G_RET_STS_ERROR then
316: raise FND_API.G_EXC_ERROR;
317: else
318: raise FND_API.G_EXC_UNEXPECTED_ERROR;
319: end if;
320: end if;

Line 318: raise FND_API.G_EXC_UNEXPECTED_ERROR;

314: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
315: if x_return_status = FND_API.G_RET_STS_ERROR then
316: raise FND_API.G_EXC_ERROR;
317: else
318: raise FND_API.G_EXC_UNEXPECTED_ERROR;
319: end if;
320: end if;
321:
322: oe_sales_can_util.g_require_reason := l_require_reason ;

Line 378: raise FND_API.G_EXC_ERROR;

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

Line 385: raise FND_API.G_EXC_ERROR;

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

Line 411: -- raise FND_API.G_EXC_ERROR;

407:
408: IF po_supply_id IS NULL THEN
409: fnd_message.set_name('ONT','OE_CAN_NO_SUPPLY_ID');
410: oe_msg_pub.add;
411: -- raise FND_API.G_EXC_ERROR;
412: END IF;
413: END IF;
414: END IF; -- For cancellation
415:

Line 437: p_line_rec.change_reason = FND_API.G_MISS_CHAR THEN

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

Line 443: raise FND_API.G_EXC_ERROR;

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

Line 449: p_line_rec.change_reason = FND_API.G_MISS_CHAR THEN

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

Line 455: raise FND_API.G_EXC_ERROR;

451: oe_debug_pub.add('Cancellation Reason is Not Provided',1);
452: END IF;
453: fnd_message.set_name('ONT','OE_CAN_REASON_NOT');
454: oe_msg_pub.add;
455: raise FND_API.G_EXC_ERROR;
456: END IF;
457: -- END IF;
458: END IF;
459:

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

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

Line 491: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

487: , p_wf_result_code => 'COMPLETE'
488: , x_return_status => l_return_status);
489:
490: END IF;
491: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
492: IF l_return_status = FND_API.G_RET_STS_ERROR then
493: RAISE FND_API.G_EXC_ERROR;
494: ELSE
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 492: IF l_return_status = FND_API.G_RET_STS_ERROR then

488: , x_return_status => l_return_status);
489:
490: END IF;
491: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
492: IF l_return_status = FND_API.G_RET_STS_ERROR then
493: RAISE FND_API.G_EXC_ERROR;
494: ELSE
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;

Line 493: RAISE FND_API.G_EXC_ERROR;

489:
490: END IF;
491: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
492: IF l_return_status = FND_API.G_RET_STS_ERROR then
493: RAISE FND_API.G_EXC_ERROR;
494: ELSE
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;
497: END IF;

Line 495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 531: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 532: if l_return_status = FND_API.G_RET_STS_ERROR then

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

Line 533: RAISE FND_API.G_EXC_ERROR;

529: END IF;
530:
531: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
532: if l_return_status = FND_API.G_RET_STS_ERROR then
533: RAISE FND_API.G_EXC_ERROR;
534: else
535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
536: end if;
537: end if;

Line 535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 562: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

558:
559: oe_line_fullfill.cancel_line(p_line_id => p_line_rec.line_id,
560: x_return_status => l_return_status);
561:
562: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
563: if l_return_status = FND_API.G_RET_STS_ERROR then
564: raise FND_API.G_EXC_ERROR;
565: else
566: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 563: if l_return_status = FND_API.G_RET_STS_ERROR then

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

Line 564: raise FND_API.G_EXC_ERROR;

560: x_return_status => l_return_status);
561:
562: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
563: if l_return_status = FND_API.G_RET_STS_ERROR then
564: raise FND_API.G_EXC_ERROR;
565: else
566: raise FND_API.G_EXC_UNEXPECTED_ERROR;
567: end if;
568: end if;

Line 566: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 623: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 624: if l_return_status = FND_API.G_RET_STS_ERROR then

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

Line 625: raise FND_API.G_EXC_ERROR;

621: END IF;
622:
623: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
624: if l_return_status = FND_API.G_RET_STS_ERROR then
625: raise FND_API.G_EXC_ERROR;
626: else
627: raise FND_API.G_EXC_UNEXPECTED_ERROR;
628: end if;
629: end if;

Line 627: raise FND_API.G_EXC_UNEXPECTED_ERROR;

623: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
624: if l_return_status = FND_API.G_RET_STS_ERROR then
625: raise FND_API.G_EXC_ERROR;
626: else
627: raise FND_API.G_EXC_UNEXPECTED_ERROR;
628: end if;
629: end if;
630: End if; -- Rlease holds
631:

Line 656: WHEN FND_API.G_EXC_ERROR THEN

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

Line 657: x_return_status := FND_API.G_RET_STS_ERROR;

653: END IF;
654:
655: EXCEPTION
656: WHEN FND_API.G_EXC_ERROR THEN
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
659: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
660: oe_msg_pub.Add_Exc_Msg
661: (G_PKG_NAME

Line 658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

654:
655: EXCEPTION
656: WHEN FND_API.G_EXC_ERROR THEN
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
659: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
660: oe_msg_pub.Add_Exc_Msg
661: (G_PKG_NAME
662: ,l_api_name);

Line 664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

670: oe_msg_pub.Add_Exc_Msg
671: (G_PKG_NAME
672: ,l_api_name);
673: END IF;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: END Perform_Line_change;
676:
677: PROCEDURE check_constraints
678: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

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

680: , x_return_status OUT NOCOPY varchar2
681:
682: )
683: IS
684: l_return_status VARCHAR2(30) :=FND_API.G_RET_STS_SUCCESS;
685: --l_line_Rec oe_order_pub.line_rec_type := p_line_Rec;
686: x_result NUMBER := 0 ;
687: x_msg_count NUMBER;
688: x_msg_data VARCHAR2(255);

Line 705: l_return_status := FND_API.G_RET_STS_SUCCESS;

701: IF l_debug_level > 0 THEN
702: oe_debug_pub.add( 'ENTERING OE_SALES_CAN_UTIL.CHECK_CONSTRAINTS' ) ;
703: END IF;
704: -- initialize API return status to success
705: l_return_status := FND_API.G_RET_STS_SUCCESS;
706:
707: IF l_debug_level > 0 THEN
708: oe_debug_pub.add( 'CHECKING CONSTRAINTS FOR LINE ID '|| TO_CHAR ( P_X_LINE_REC.LINE_ID ) ) ;
709: END IF;

Line 714: RAISE FND_API.G_EXC_ERROR ;

710:
711: if ( p_old_line_rec.cancelled_flag = 'Y') then
712: fnd_message.set_name('ONT', 'OE_CANCEL_NOTHING');
713: oe_msg_pub.add;
714: RAISE FND_API.G_EXC_ERROR ;
715: end if;
716:
717: -- Check if line is booked and and is not a cancellations and orderquantity is
718: -- zero

Line 733: RAISE FND_API.G_EXC_ERROR ;

729: nvl(p_x_line_rec.ordered_quantity,0) = 0 ) THEN
730:
731: fnd_message.set_name('ONT', 'OE_QTY_ZERO_NOT_ALLOWED');
732: oe_msg_pub.add;
733: RAISE FND_API.G_EXC_ERROR ;
734: END IF;
735: END IF;
736:
737: -- Check Service here. We allow only full cancellation of service

Line 748: RAISE FND_API.G_EXC_ERROR;

744: if (p_x_line_rec.Ordered_Quantity <>
745: p_old_line_rec.Ordered_Quantity) THEN
746: fnd_message.set_name('ONT', 'OE_CAN_SERV_AMT_NOT_ALLOWED');
747: oe_msg_pub.add;
748: RAISE FND_API.G_EXC_ERROR;
749: end if;
750: end if;
751:
752: -- Set Ordered level cancellation to true or false

Line 899: WHEN FND_API.G_EXC_ERROR THEN

895:
896: END IF;
897:
898: EXCEPTION
899: WHEN FND_API.G_EXC_ERROR THEN
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
903: oe_msg_pub.Add_Exc_Msg

Line 900: x_return_status := FND_API.G_RET_STS_ERROR;

896: END IF;
897:
898: EXCEPTION
899: WHEN FND_API.G_EXC_ERROR THEN
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
903: oe_msg_pub.Add_Exc_Msg
904: (G_PKG_NAME

Line 901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

897:
898: EXCEPTION
899: WHEN FND_API.G_EXC_ERROR THEN
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
903: oe_msg_pub.Add_Exc_Msg
904: (G_PKG_NAME
905: ,l_api_name);

Line 907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

903: oe_msg_pub.Add_Exc_Msg
904: (G_PKG_NAME
905: ,l_api_name);
906: END IF;
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: WHEN OTHERS THEN
909: IF l_debug_level > 0 THEN
910: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
911: END IF;

Line 917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

913: oe_msg_pub.Add_Exc_Msg
914: (G_PKG_NAME
915: ,l_api_name);
916: END IF;
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918:
919: END check_constraints;
920:
921: PROCEDURE update_service

Line 986: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

982: END IF;
983:
984: end loop;
985:
986: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
987: if l_return_status = FND_API.G_RET_STS_ERROR then
988: raise FND_API.G_EXC_ERROR;
989: else
990: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 987: if l_return_status = FND_API.G_RET_STS_ERROR then

983:
984: end loop;
985:
986: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
987: if l_return_status = FND_API.G_RET_STS_ERROR then
988: raise FND_API.G_EXC_ERROR;
989: else
990: raise FND_API.G_EXC_UNEXPECTED_ERROR;
991: end if;

Line 988: raise FND_API.G_EXC_ERROR;

984: end loop;
985:
986: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
987: if l_return_status = FND_API.G_RET_STS_ERROR then
988: raise FND_API.G_EXC_ERROR;
989: else
990: raise FND_API.G_EXC_UNEXPECTED_ERROR;
991: end if;
992: end if;

Line 990: raise FND_API.G_EXC_UNEXPECTED_ERROR;

986: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
987: if l_return_status = FND_API.G_RET_STS_ERROR then
988: raise FND_API.G_EXC_ERROR;
989: else
990: raise FND_API.G_EXC_UNEXPECTED_ERROR;
991: end if;
992: end if;
993:
994: IF l_debug_level > 0 THEN

Line 999: WHEN FND_API.G_EXC_ERROR THEN

995: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.UPDATE_SERVICE' ) ;
996: END IF;
997:
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1002: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1003: oe_msg_pub.Add_Exc_Msg

Line 1000: x_return_status := FND_API.G_RET_STS_ERROR;

996: END IF;
997:
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1002: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1003: oe_msg_pub.Add_Exc_Msg
1004: (G_PKG_NAME

Line 1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

997:
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1002: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1003: oe_msg_pub.Add_Exc_Msg
1004: (G_PKG_NAME
1005: ,l_api_name);

Line 1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1003: oe_msg_pub.Add_Exc_Msg
1004: (G_PKG_NAME
1005: ,l_api_name);
1006: END IF;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: WHEN OTHERS THEN
1009: IF l_debug_level > 0 THEN
1010: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
1011: END IF;

Line 1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1013: oe_msg_pub.Add_Exc_Msg
1014: (G_PKG_NAME
1015: ,l_api_name);
1016: END IF;
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1018: end update_service;
1019:
1020: FUNCTION Cal_Cancelled_Qty
1021: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

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

1090: IF (p_old_line_rec.ordered_quantity > p_line_rec.ordered_quantity) THEN
1091: l_ordered_quantity :=
1092: (p_old_line_rec.ordered_quantity - p_line_rec.ordered_quantity);
1093:
1094: IF p_old_line_rec.cancelled_quantity = FND_API.G_MISS_NUM OR
1095: p_old_line_rec.cancelled_quantity is NULL THEN
1096: oe_debug_pub.ADD('rajeevcancell');
1097: RETURN l_ordered_quantity;
1098: ELSE

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

1109: IF (p_old_line_rec.ordered_quantity < p_line_rec.ordered_quantity) THEN
1110: l_ordered_quantity :=
1111: (p_old_line_rec.ordered_quantity - p_line_rec.ordered_quantity);
1112:
1113: IF p_old_line_rec.cancelled_quantity = FND_API.G_MISS_NUM OR
1114: p_old_line_rec.cancelled_quantity is NULL THEN
1115: RETURN l_ordered_quantity;
1116: ELSE
1117: RETURN (l_ordered_quantity +

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

1148: , x_return_status OUT NOCOPY VARCHAR2
1149:
1150: ) IS
1151: l_api_name CONSTANT VARCHAR2(30) := 'Check_Constraints';
1152: l_return_status varchar2(30) :=FND_API.G_RET_STS_SUCCESS;
1153: x_result NUMBER := 0 ;
1154: l_constrain_all_flag varchar2(255);
1155: l_constraint_id NUMBER;
1156: l_resolving_wf_activity_name varchar2(255);

Line 1172: x_return_status := FND_API.G_RET_STS_SUCCESS;

1168: IF l_debug_level > 0 THEN
1169: oe_debug_pub.add( 'IN CHECK CONSTRAINS FOR CANCELLATION' ) ;
1170: END IF;
1171: -- initialize API return status to success
1172: x_return_status := FND_API.G_RET_STS_SUCCESS;
1173: -- Prepare security record
1174:
1175: EXCEPTION
1176: WHEN FND_API.G_EXC_ERROR THEN

Line 1176: WHEN FND_API.G_EXC_ERROR THEN

1172: x_return_status := FND_API.G_RET_STS_SUCCESS;
1173: -- Prepare security record
1174:
1175: EXCEPTION
1176: WHEN FND_API.G_EXC_ERROR THEN
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1180: oe_msg_pub.Add_Exc_Msg

Line 1177: x_return_status := FND_API.G_RET_STS_ERROR;

1173: -- Prepare security record
1174:
1175: EXCEPTION
1176: WHEN FND_API.G_EXC_ERROR THEN
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1180: oe_msg_pub.Add_Exc_Msg
1181: (G_PKG_NAME

Line 1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1174:
1175: EXCEPTION
1176: WHEN FND_API.G_EXC_ERROR THEN
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1180: oe_msg_pub.Add_Exc_Msg
1181: (G_PKG_NAME
1182: ,l_api_name);

Line 1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1180: oe_msg_pub.Add_Exc_Msg
1181: (G_PKG_NAME
1182: ,l_api_name);
1183: END IF;
1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1185: WHEN OTHERS THEN
1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
1188: END IF;

Line 1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1190: oe_msg_pub.Add_Exc_Msg
1191: (G_PKG_NAME
1192: ,l_api_name);
1193: END IF;
1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1195: end check_constraints;
1196:
1197: PROCEDURE perform_cancel_order
1198: ( p_header_rec IN OE_Order_PUB.header_Rec_Type

Line 1246: raise FND_API.G_EXC_ERROR;

1242: END IF;
1243: IF p_header_rec.change_reason IS NULL THEN
1244: fnd_message.set_name('ONT','OE_CAN_REASON_NOT');
1245: oe_msg_pub.add;
1246: raise FND_API.G_EXC_ERROR;
1247: END IF;
1248: END IF;
1249:
1250: oe_line_util.Query_Rows( p_header_id => p_header_rec.header_id

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

1322: i := i + 1;
1323:
1324: l_line_tbl(i) := l_line_old_tbl(j);
1325: l_x_line_old_tbl(i) := l_line_old_tbl(j);
1326: l_line_tbl(i).db_flag := FND_API.G_TRUE;
1327: --l_line_tbl(i).cancelled_quantity := l_line_tbl(i).ordered_quantity;
1328: l_line_tbl(i).ordered_quantity :=0;
1329: l_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
1330: l_line_tbl(i).change_reason :=p_header_rec.change_reason;

Line 1360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1356: l_x_line_old_tbl,
1357: l_return_status);
1358: END IF;
1359:
1360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1361: IF l_debug_level > 0 THEN
1362: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN UNEXP_ERROR' ) ;
1363: END IF;
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1361: IF l_debug_level > 0 THEN
1362: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN UNEXP_ERROR' ) ;
1363: END IF;
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1366: IF l_debug_level > 0 THEN
1367: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN RET_STS_ERROR' ) ;
1368: END IF;

Line 1365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1361: IF l_debug_level > 0 THEN
1362: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN UNEXP_ERROR' ) ;
1363: END IF;
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1366: IF l_debug_level > 0 THEN
1367: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN RET_STS_ERROR' ) ;
1368: END IF;
1369: RAISE FND_API.G_EXC_ERROR;

Line 1369: RAISE FND_API.G_EXC_ERROR;

1365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1366: IF l_debug_level > 0 THEN
1367: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN RET_STS_ERROR' ) ;
1368: END IF;
1369: RAISE FND_API.G_EXC_ERROR;
1370: END IF;
1371:
1372:
1373: -- Need to process payment refund if there is any prepayment.

Line 1389: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1385: IF l_debug_level > 0 THEN
1386: oe_debug_pub.add('return status after calling process_payment_refund is: '||x_return_status, 3);
1387: END IF;
1388:
1389: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1390: RAISE FND_API.G_EXC_ERROR;
1391: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393: END IF;

Line 1390: RAISE FND_API.G_EXC_ERROR;

1386: oe_debug_pub.add('return status after calling process_payment_refund is: '||x_return_status, 3);
1387: END IF;
1388:
1389: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1390: RAISE FND_API.G_EXC_ERROR;
1391: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393: END IF;
1394: ELSIF NVL(p_header_rec.payment_type_code,'NULL') = 'CREDIT_CARD'

Line 1391: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1387: END IF;
1388:
1389: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1390: RAISE FND_API.G_EXC_ERROR;
1391: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393: END IF;
1394: ELSIF NVL(p_header_rec.payment_type_code,'NULL') = 'CREDIT_CARD'
1395: AND OE_PrePayment_UTIL.is_prepaid_order(p_header_rec) = 'Y'

Line 1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1388:
1389: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1390: RAISE FND_API.G_EXC_ERROR;
1391: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393: END IF;
1394: ELSIF NVL(p_header_rec.payment_type_code,'NULL') = 'CREDIT_CARD'
1395: AND OE_PrePayment_UTIL.is_prepaid_order(p_header_rec) = 'Y'
1396: THEN

Line 1401: , p_delayed_request => FND_API.G_FALSE

1397: oe_debug_pub.ADD('Calling Payment Refund.');
1398: OE_PrePayment_PVT.Process_PrePayment_Order
1399: ( p_header_rec => p_header_rec
1400: , p_calling_action => NULL
1401: , p_delayed_request => FND_API.G_FALSE
1402: , x_msg_count => l_msg_count
1403: , x_msg_data => l_msg_data
1404: , x_return_status => x_return_status
1405: );

Line 1410: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1406: IF l_debug_level > 0 THEN
1407: oe_debug_pub.add('return status after calling process_prepayment_order is: '||x_return_status, 3);
1408: END IF;
1409:
1410: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1411: RAISE FND_API.G_EXC_ERROR;
1412: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END IF;

Line 1411: RAISE FND_API.G_EXC_ERROR;

1407: oe_debug_pub.add('return status after calling process_prepayment_order is: '||x_return_status, 3);
1408: END IF;
1409:
1410: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1411: RAISE FND_API.G_EXC_ERROR;
1412: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END IF;
1415: END IF;

Line 1412: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1408: END IF;
1409:
1410: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1411: RAISE FND_API.G_EXC_ERROR;
1412: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END IF;
1415: END IF;
1416:

Line 1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1409:
1410: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1411: RAISE FND_API.G_EXC_ERROR;
1412: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END IF;
1415: END IF;
1416:
1417: -- Release Holds

Line 1440: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1436: IF l_debug_level > 0 THEN
1437: oe_debug_pub.add( 'THE HOLD RELEASED WITH STATUS :'|| L_RETURN_STATUS ) ;
1438: END IF;
1439:
1440: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1441: if l_return_status = FND_API.G_RET_STS_ERROR then
1442: raise FND_API.G_EXC_ERROR;
1443: else
1444: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1441: if l_return_status = FND_API.G_RET_STS_ERROR then

1437: oe_debug_pub.add( 'THE HOLD RELEASED WITH STATUS :'|| L_RETURN_STATUS ) ;
1438: END IF;
1439:
1440: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1441: if l_return_status = FND_API.G_RET_STS_ERROR then
1442: raise FND_API.G_EXC_ERROR;
1443: else
1444: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1445: end if;

Line 1442: raise FND_API.G_EXC_ERROR;

1438: END IF;
1439:
1440: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1441: if l_return_status = FND_API.G_RET_STS_ERROR then
1442: raise FND_API.G_EXC_ERROR;
1443: else
1444: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1445: end if;
1446: end if;

Line 1444: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1440: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1441: if l_return_status = FND_API.G_RET_STS_ERROR then
1442: raise FND_API.G_EXC_ERROR;
1443: else
1444: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1445: end if;
1446: end if;
1447:
1448: /*

Line 1467: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1463: , p_msg_data => l_msg_data
1464: , p_result_out => l_result_out
1465: , p_return_status => l_return_status
1466: );
1467: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1468: RAISE FND_API.G_EXC_ERROR;
1469: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1471: END IF;

Line 1468: RAISE FND_API.G_EXC_ERROR;

1464: , p_result_out => l_result_out
1465: , p_return_status => l_return_status
1466: );
1467: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1468: RAISE FND_API.G_EXC_ERROR;
1469: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1471: END IF;
1472: END IF; -- IF Credit Card Approval Code is NOT NULL

Line 1469: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1465: , p_return_status => l_return_status
1466: );
1467: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1468: RAISE FND_API.G_EXC_ERROR;
1469: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1471: END IF;
1472: END IF; -- IF Credit Card Approval Code is NOT NULL
1473: */

Line 1470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1466: );
1467: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1468: RAISE FND_API.G_EXC_ERROR;
1469: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1471: END IF;
1472: END IF; -- IF Credit Card Approval Code is NOT NULL
1473: */
1474:

Line 1496: WHEN FND_API.G_EXC_ERROR THEN

1492: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.PERFORM_CANCEL_ORDER' ) ;
1493: END IF;
1494:
1495: EXCEPTION
1496: WHEN FND_API.G_EXC_ERROR THEN
1497: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1498: x_return_status := FND_API.G_RET_STS_ERROR;
1499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1500: --g_ord_lvl_can := FALSE; Commented for bug# 2922468

Line 1498: x_return_status := FND_API.G_RET_STS_ERROR;

1494:
1495: EXCEPTION
1496: WHEN FND_API.G_EXC_ERROR THEN
1497: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1498: x_return_status := FND_API.G_RET_STS_ERROR;
1499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1500: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1502: WHEN OTHERS THEN

Line 1499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1495: EXCEPTION
1496: WHEN FND_API.G_EXC_ERROR THEN
1497: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1498: x_return_status := FND_API.G_RET_STS_ERROR;
1499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1500: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1502: WHEN OTHERS THEN
1503: --g_ord_lvl_can := FALSE; Commented for bug# 2922468

Line 1501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1497: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1498: x_return_status := FND_API.G_RET_STS_ERROR;
1499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1500: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1502: WHEN OTHERS THEN
1503: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1504: x_return_status := FND_API.G_RET_STS_ERROR;

1500: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1502: WHEN OTHERS THEN
1503: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1506: oe_msg_pub.Add_Exc_Msg
1507: (G_PKG_NAME
1508: ,'Peform_Cancel_order');

Line 1557: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

1553: oe_debug_pub.add( 'BEFORE CALLING PROCESS ORDER' ) ;
1554: END IF;
1555:
1556: oe_order_pvt.Lines
1557: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1558: , p_control_rec => l_control_rec
1559: , p_x_line_tbl => l_line_tbl
1560: , p_x_old_line_tbl => l_old_line_tbl
1561: , x_return_status => x_return_status

Line 1568: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1564: IF l_debug_level > 0 THEN
1565: oe_debug_pub.add( 'AFTER CALLING PROCESS ORDER' ) ;
1566: END IF;
1567:
1568: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;

Line 1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1565: oe_debug_pub.add( 'AFTER CALLING PROCESS ORDER' ) ;
1566: END IF;
1567:
1568: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573:

Line 1570: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1566: END IF;
1567:
1568: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573:
1574: -- Api to call OC and ACK and process delayed requests

Line 1571: RAISE FND_API.G_EXC_ERROR;

1567:
1568: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573:
1574: -- Api to call OC and ACK and process delayed requests
1575: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110508' THEN -- reinstated for 2653505

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

1581: , p_old_line_tbl => l_old_line_tbl
1582: );
1583:
1584: FOR I IN 1..l_line_tbl.COUNT LOOP
1585: if l_line_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
1586: x_return_status := FND_API.G_RET_STS_ERROR;
1587: elsif l_line_tbl(I).return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1589: end if;

Line 1586: x_return_status := FND_API.G_RET_STS_ERROR;

1582: );
1583:
1584: FOR I IN 1..l_line_tbl.COUNT LOOP
1585: if l_line_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
1586: x_return_status := FND_API.G_RET_STS_ERROR;
1587: elsif l_line_tbl(I).return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1589: end if;
1590: end loop;

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

1583:
1584: FOR I IN 1..l_line_tbl.COUNT LOOP
1585: if l_line_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
1586: x_return_status := FND_API.G_RET_STS_ERROR;
1587: elsif l_line_tbl(I).return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1589: end if;
1590: end loop;
1591: END IF; -- 2653505

Line 1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1584: FOR I IN 1..l_line_tbl.COUNT LOOP
1585: if l_line_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
1586: x_return_status := FND_API.G_RET_STS_ERROR;
1587: elsif l_line_tbl(I).return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1589: end if;
1590: end loop;
1591: END IF; -- 2653505
1592:

Line 1598: WHEN FND_API.G_EXC_ERROR THEN

1594: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.PERFORMLINECANCELLATION' ) ;
1595: END IF;
1596:
1597: EXCEPTION
1598: WHEN FND_API.G_EXC_ERROR THEN
1599: x_return_status := FND_API.G_RET_STS_ERROR;
1600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: WHEN OTHERS THEN

Line 1599: x_return_status := FND_API.G_RET_STS_ERROR;

1595: END IF;
1596:
1597: EXCEPTION
1598: WHEN FND_API.G_EXC_ERROR THEN
1599: x_return_status := FND_API.G_RET_STS_ERROR;
1600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: WHEN OTHERS THEN
1603: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1596:
1597: EXCEPTION
1598: WHEN FND_API.G_EXC_ERROR THEN
1599: x_return_status := FND_API.G_RET_STS_ERROR;
1600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: WHEN OTHERS THEN
1603: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1604: oe_msg_pub.Add_Exc_Msg

Line 1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1597: EXCEPTION
1598: WHEN FND_API.G_EXC_ERROR THEN
1599: x_return_status := FND_API.G_RET_STS_ERROR;
1600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: WHEN OTHERS THEN
1603: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1604: oe_msg_pub.Add_Exc_Msg
1605: (G_PKG_NAME

Line 1608: x_return_status := FND_API.G_RET_STS_ERROR;

1604: oe_msg_pub.Add_Exc_Msg
1605: (G_PKG_NAME
1606: ,'PeformLineCancellation');
1607: END IF;
1608: x_return_status := FND_API.G_RET_STS_ERROR;
1609:
1610: END PerformLineCancellation;
1611:
1612: FUNCTION Query_Rows

Line 1614: FND_API.G_MISS_NUM

1610: END PerformLineCancellation;
1611:
1612: FUNCTION Query_Rows
1613: ( p_line_id IN NUMBER :=
1614: FND_API.G_MISS_NUM
1615: , p_header_id IN NUMBER :=
1616: FND_API.G_MISS_NUM
1617: ) RETURN OE_Order_PUB.Line_Tbl_Type
1618: IS

Line 1616: FND_API.G_MISS_NUM

1612: FUNCTION Query_Rows
1613: ( p_line_id IN NUMBER :=
1614: FND_API.G_MISS_NUM
1615: , p_header_id IN NUMBER :=
1616: FND_API.G_MISS_NUM
1617: ) RETURN OE_Order_PUB.Line_Tbl_Type
1618: IS
1619: l_line_rec OE_Order_PUB.Line_Rec_Type;
1620: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1637: RETURN l_line_tbl;
1638:
1639: EXCEPTION
1640:
1641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1642:
1643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1644:
1645: WHEN OTHERS THEN

Line 1643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1639: EXCEPTION
1640:
1641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1642:
1643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1644:
1645: WHEN OTHERS THEN
1646:
1647: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1651: , 'Query_Rows'
1652: );
1653: END IF;
1654:
1655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1656:
1657: END Query_Rows;
1658:
1659: -- bug 4887806

Line 1766: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1762: , x_return_status => l_return_status
1763: , x_msg_count => l_msg_count
1764: , x_msg_data => l_msg_data);
1765:
1766: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1767: IF l_debug_level > 0 THEN
1768: oe_debug_pub.add('Exception from Process_Fulfillment:'||l_result_out,2);
1769: END IF;
1770: OE_MSG_PUB.Add_Text(p_message_text => l_msg_data);

Line 1774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1770: OE_MSG_PUB.Add_Text(p_message_text => l_msg_data);
1771: OE_MSG_PUB.Save_API_Messages;
1772:
1773: ROLLBACK TO Process_Set;
1774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1775:
1776: ELSE -- fulfillment of all related lines was successful
1777: l_item_key := to_char(l_line_id);
1778: Oe_line_fullfill.Get_Activity_Result(

Line 1791: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND

1787: IF l_debug_level > 0 THEN
1788: oe_debug_pub.add('After Get_Activity_Result, ret status:'||l_return_status||' ,Fulfill:'||l_activity_status,3);
1789: END IF;
1790:
1791: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND
1792: l_activity_status = 'NOTIFIED' THEN
1793: IF l_debug_level > 0 THEN
1794: oe_debug_pub.add('Calling wf_engine.CompleteActivityInternalName for lineID='||l_item_key,2);
1795: END IF;

Line 1823: p_header_id IN NUMBER := FND_API.G_MISS_NUM

1819: END Call_Process_Fulfillment;
1820:
1821: PROCEDURE Cancel_Remaining_Order
1822: ( p_header_Rec IN OE_Order_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC,
1823: p_header_id IN NUMBER := FND_API.G_MISS_NUM
1824: , x_return_status OUT NOCOPY VARCHAR2
1825:
1826: )
1827: IS

Line 1857: x_return_status := FND_API.G_RET_STS_SUCCESS;

1853: IF l_debug_level > 0 THEN
1854: oe_debug_pub.add( 'ENTERING OE_SALES_CAN_UTIL.CANCEL_REMAINING_ORDER' ) ;
1855: END IF;
1856:
1857: x_return_status := FND_API.G_RET_STS_SUCCESS;
1858:
1859: g_par_ord_lvl_can := TRUE; --Fix for bug 2230777
1860:
1861: l_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;

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

1859: g_par_ord_lvl_can := TRUE; --Fix for bug 2230777
1860:
1861: l_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
1862:
1863: IF (p_header_rec.header_id = FND_API.G_MISS_NUM OR
1864: p_header_rec.header_id = NULL) THEN
1865: l_header_id := p_header_id;
1866: ELSE
1867: l_header_id := p_header_rec.header_id;

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

1958: J := J + 1;
1959:
1960: l_line_tbl(J) := l_line_old_tbl(I);
1961: l_x_line_old_tbl(J) := l_line_old_tbl(I);
1962: l_line_tbl(J).db_flag := FND_API.G_TRUE;
1963: --l_line_tbl(J).cancelled_quantity := l_line_tbl(J).ordered_quantity;
1964: l_line_tbl(j).ordered_quantity :=0;
1965: l_line_tbl(j).operation := OE_GLOBALS.G_OPR_UPDATE;
1966: l_line_tbl(j).change_reason :=p_header_rec.change_reason;

Line 2002: RAISE FND_API.G_EXC_ERROR;

1998: IF l_line_tbl.count = 0 THEN
1999: FND_MESSAGE.SET_NAME('ONT','OE_NO_ELIGIBLE_LINES');
2000: FND_MESSAGE.SET_TOKEN('ORDER', L_header_rec.Order_Number);
2001: OE_MSG_PUB.ADD;
2002: RAISE FND_API.G_EXC_ERROR;
2003: END IF;
2004:
2005: IF l_debug_level > 0 THEN
2006: oe_debug_pub.add( 'BEFORE CALLING PERFORM LINE CANCELLATION' ) ;

Line 2014: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2010: PerformLinecancellation(l_line_tbl,
2011: l_x_line_old_tbl,
2012: x_return_status => l_return_status);
2013:
2014: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2015: IF l_debug_level > 0 THEN
2016: oe_debug_pub.add( 'PERFORM LINE CANCELLATION UNEXP_ERROR' ) ;
2017: END IF;
2018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2014: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2015: IF l_debug_level > 0 THEN
2016: oe_debug_pub.add( 'PERFORM LINE CANCELLATION UNEXP_ERROR' ) ;
2017: END IF;
2018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2019: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2020: IF l_debug_level > 0 THEN
2021: oe_debug_pub.add( 'PERFORM LINE CANCELLATION RET_STS_ERROR' ) ;
2022: END IF;

Line 2019: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2015: IF l_debug_level > 0 THEN
2016: oe_debug_pub.add( 'PERFORM LINE CANCELLATION UNEXP_ERROR' ) ;
2017: END IF;
2018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2019: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2020: IF l_debug_level > 0 THEN
2021: oe_debug_pub.add( 'PERFORM LINE CANCELLATION RET_STS_ERROR' ) ;
2022: END IF;
2023: RAISE FND_API.G_EXC_ERROR;

Line 2023: RAISE FND_API.G_EXC_ERROR;

2019: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2020: IF l_debug_level > 0 THEN
2021: oe_debug_pub.add( 'PERFORM LINE CANCELLATION RET_STS_ERROR' ) ;
2022: END IF;
2023: RAISE FND_API.G_EXC_ERROR;
2024: END IF;
2025:
2026: g_par_ord_lvl_can := FALSE;
2027:

Line 2036: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2032: , x_return_status => l_return_status
2033: , p_line_tbl => l_line_tbl
2034: , p_old_line_tbl => l_x_line_old_tbl
2035: );
2036: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2037: IF l_debug_level > 0 THEN
2038: oe_debug_pub.add( 'Process_requests_and_notify UNEXP_ERROR' ) ;
2039: END IF;
2040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2036: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2037: IF l_debug_level > 0 THEN
2038: oe_debug_pub.add( 'Process_requests_and_notify UNEXP_ERROR' ) ;
2039: END IF;
2040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2041: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2042: IF l_debug_level > 0 THEN
2043: oe_debug_pub.add( 'Process_requests_and_notify RET_STS_ERROR' ) ;
2044: END IF;

Line 2041: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2037: IF l_debug_level > 0 THEN
2038: oe_debug_pub.add( 'Process_requests_and_notify UNEXP_ERROR' ) ;
2039: END IF;
2040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2041: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2042: IF l_debug_level > 0 THEN
2043: oe_debug_pub.add( 'Process_requests_and_notify RET_STS_ERROR' ) ;
2044: END IF;
2045: RAISE FND_API.G_EXC_ERROR;

Line 2045: RAISE FND_API.G_EXC_ERROR;

2041: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2042: IF l_debug_level > 0 THEN
2043: oe_debug_pub.add( 'Process_requests_and_notify RET_STS_ERROR' ) ;
2044: END IF;
2045: RAISE FND_API.G_EXC_ERROR;
2046: END IF;
2047: --end bug 4567339
2048:
2049: -- bug 4887806

Line 2057: WHEN FND_API.G_EXC_ERROR THEN

2053: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.CANCEL_REMAINING_ORDER' ) ;
2054: END IF;
2055:
2056: EXCEPTION
2057: WHEN FND_API.G_EXC_ERROR THEN
2058: g_par_ord_lvl_can := FALSE;
2059: x_return_status := FND_API.G_RET_STS_ERROR;
2060: WHEN OTHERS THEN
2061: g_par_ord_lvl_can := FALSE;

Line 2059: x_return_status := FND_API.G_RET_STS_ERROR;

2055:
2056: EXCEPTION
2057: WHEN FND_API.G_EXC_ERROR THEN
2058: g_par_ord_lvl_can := FALSE;
2059: x_return_status := FND_API.G_RET_STS_ERROR;
2060: WHEN OTHERS THEN
2061: g_par_ord_lvl_can := FALSE;
2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2063: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2058: g_par_ord_lvl_can := FALSE;
2059: x_return_status := FND_API.G_RET_STS_ERROR;
2060: WHEN OTHERS THEN
2061: g_par_ord_lvl_can := FALSE;
2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2063: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2064: THEN
2065: OE_MSG_PUB.Add_Exc_Msg
2066: ( G_PKG_NAME ,

Line 2154: WHEN FND_API.G_EXC_ERROR THEN

2150: END IF;
2151:
2152: EXCEPTION
2153:
2154: WHEN FND_API.G_EXC_ERROR THEN
2155:
2156: x_return_status := FND_API.G_RET_STS_ERROR;
2157:
2158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2156: x_return_status := FND_API.G_RET_STS_ERROR;

2152: EXCEPTION
2153:
2154: WHEN FND_API.G_EXC_ERROR THEN
2155:
2156: x_return_status := FND_API.G_RET_STS_ERROR;
2157:
2158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2159:
2160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2154: WHEN FND_API.G_EXC_ERROR THEN
2155:
2156: x_return_status := FND_API.G_RET_STS_ERROR;
2157:
2158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2159:
2160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2161:
2162: WHEN OTHERS THEN

Line 2160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2156: x_return_status := FND_API.G_RET_STS_ERROR;
2157:
2158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2159:
2160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2161:
2162: WHEN OTHERS THEN
2163:
2164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2161:
2162: WHEN OTHERS THEN
2163:
2164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2165:
2166: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2167: THEN
2168: OE_MSG_PUB.Add_Exc_Msg

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

2263: IF (p_old_line_rec.ordered_quantity > p_line_rec.ordered_quantity) THEN
2264: l_ordered_quantity :=
2265: (p_old_line_rec.ordered_quantity - p_line_rec.ordered_quantity);
2266:
2267: IF p_old_line_rec.cancelled_quantity = FND_API.G_MISS_NUM OR
2268: p_old_line_rec.cancelled_quantity is NULL THEN
2269: oe_debug_pub.ADD('rajeevcancell');
2270: RETURN l_ordered_quantity;
2271: ELSE

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

2282: IF (p_old_line_rec.ordered_quantity < p_line_rec.ordered_quantity) THEN
2283: l_ordered_quantity :=
2284: (p_old_line_rec.ordered_quantity - p_line_rec.ordered_quantity);
2285:
2286: IF p_old_line_rec.cancelled_quantity = FND_API.G_MISS_NUM OR
2287: p_old_line_rec.cancelled_quantity is NULL THEN
2288: RETURN l_ordered_quantity;
2289: ELSE
2290: RETURN (l_ordered_quantity +