DBA Data[Home] [Help]

APPS.OE_SCH_ORGANIZER_UTIL dependencies on FND_API

Line 18: l_init_msg VARCHAR2(30) := FND_API.G_TRUE;

14: l_x_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
15: l_x_line_rec OE_ORDER_PUB.Line_Rec_Type;
16: l_control_rec OE_GLOBALS.Control_Rec_Type;
17: l_count NUMBER;
18: l_init_msg VARCHAR2(30) := FND_API.G_TRUE;
19: l_failed_count NUMBER := 0;
20: K NUMBER := 2;
21: L NUMBER;
22: l_dummy NUMBER;

Line 176: OE_ORDER_PVT.Lines(p_validation_level => FND_API.G_VALID_LEVEL_FULL,

172: K := 2; --reset K
173:
174: SAVEPOINT PRE_LINES;
175:
176: OE_ORDER_PVT.Lines(p_validation_level => FND_API.G_VALID_LEVEL_FULL,
177: p_init_msg_list => l_init_msg,
178: p_control_rec => l_control_rec,
179: p_x_line_tbl => l_x_line_tbl,
180: p_x_old_line_tbl => l_x_old_line_tbl,

Line 183: l_init_msg := FND_API.G_FALSE;

179: p_x_line_tbl => l_x_line_tbl,
180: p_x_old_line_tbl => l_x_old_line_tbl,
181: x_return_status => x_return_status);
182:
183: l_init_msg := FND_API.G_FALSE;
184: IF l_debug_level > 0 THEN
185: oe_debug_pub.add( 'SCH: DONE CALLING LINES: ' || X_RETURN_STATUS ) ;
186: END IF;
187:

Line 188: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

184: IF l_debug_level > 0 THEN
185: oe_debug_pub.add( 'SCH: DONE CALLING LINES: ' || X_RETURN_STATUS ) ;
186: END IF;
187:
188: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
191: RAISE FND_API.G_EXC_ERROR;
192: END IF;

Line 189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

185: oe_debug_pub.add( 'SCH: DONE CALLING LINES: ' || X_RETURN_STATUS ) ;
186: END IF;
187:
188: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
191: RAISE FND_API.G_EXC_ERROR;
192: END IF;
193:

Line 190: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

186: END IF;
187:
188: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
191: RAISE FND_API.G_EXC_ERROR;
192: END IF;
193:
194: Oe_Order_Pvt.Process_Requests_And_Notify

Line 191: RAISE FND_API.G_EXC_ERROR;

187:
188: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
191: RAISE FND_API.G_EXC_ERROR;
192: END IF;
193:
194: Oe_Order_Pvt.Process_Requests_And_Notify
195: ( p_process_requests => TRUE

Line 196: , p_init_msg_list => FND_API.G_FALSE

192: END IF;
193:
194: Oe_Order_Pvt.Process_Requests_And_Notify
195: ( p_process_requests => TRUE
196: , p_init_msg_list => FND_API.G_FALSE
197: , p_notify => TRUE
198: , x_return_status => x_return_status
199: , p_line_tbl => l_x_line_tbl
200: , p_old_line_tbl => l_x_old_line_tbl

Line 203: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

199: , p_line_tbl => l_x_line_tbl
200: , p_old_line_tbl => l_x_old_line_tbl
201: );
202:
203: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
204: ROLLBACK TO SAVEPOINT PRE_LINES;
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
207: ROLLBACK TO SAVEPOINT PRE_LINES;

Line 205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

201: );
202:
203: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
204: ROLLBACK TO SAVEPOINT PRE_LINES;
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
207: ROLLBACK TO SAVEPOINT PRE_LINES;
208: RAISE FND_API.G_EXC_ERROR;
209: END IF;

Line 206: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

202:
203: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
204: ROLLBACK TO SAVEPOINT PRE_LINES;
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
207: ROLLBACK TO SAVEPOINT PRE_LINES;
208: RAISE FND_API.G_EXC_ERROR;
209: END IF;
210:

Line 208: RAISE FND_API.G_EXC_ERROR;

204: ROLLBACK TO SAVEPOINT PRE_LINES;
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
207: ROLLBACK TO SAVEPOINT PRE_LINES;
208: RAISE FND_API.G_EXC_ERROR;
209: END IF;
210:
211: l_x_line_tbl.delete; -- clear out the table for every order
212: l_x_old_line_tbl.delete;

Line 217: WHEN FND_API.G_EXC_ERROR THEN

213:
214: END IF; -- not marked as exclude
215:
216: EXCEPTION
217: WHEN FND_API.G_EXC_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: l_failed_count := l_failed_count + l_x_line_tbl.count;
220: x_failed_count := l_failed_count;
221: l_x_line_tbl.delete;

Line 218: x_return_status := FND_API.G_RET_STS_ERROR;

214: END IF; -- not marked as exclude
215:
216: EXCEPTION
217: WHEN FND_API.G_EXC_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: l_failed_count := l_failed_count + l_x_line_tbl.count;
220: x_failed_count := l_failed_count;
221: l_x_line_tbl.delete;
222: l_x_old_line_tbl.delete;

Line 231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

227: IF l_debug_level > 0 THEN
228: oe_debug_pub.add( 'SCH: IN EXCEPTION HANDLER! MSG COUNT: ' || OE_MSG_PUB.COUNT_MSG ) ;
229: END IF;
230:
231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: l_failed_count := l_failed_count + l_x_line_tbl.count;
234: x_failed_count := l_failed_count;
235: IF l_debug_level > 0 THEN

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

228: oe_debug_pub.add( 'SCH: IN EXCEPTION HANDLER! MSG COUNT: ' || OE_MSG_PUB.COUNT_MSG ) ;
229: END IF;
230:
231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: l_failed_count := l_failed_count + l_x_line_tbl.count;
234: x_failed_count := l_failed_count;
235: IF l_debug_level > 0 THEN
236: oe_debug_pub.add( 'SCH: IN UNEXP EXCEPTION HANDLER! FAILED COUNT: ' || L_FAILED_COUNT ) ;

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

243: oe_debug_pub.add( 'SCH: IN UNEXP EXCEPTION HANDLER! MSG COUNT: ' || OE_MSG_PUB.COUNT_MSG ) ;
244: END IF;
245:
246: WHEN OTHERS THEN
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: l_failed_count := l_failed_count + l_x_line_tbl.count;
249: x_failed_count := l_failed_count;
250: IF l_debug_level > 0 THEN
251: oe_debug_pub.add( 'SCH: IN OTHER EXCEPTION HANDLER! FAILED COUNT: ' || L_FAILED_COUNT ) ;

Line 608: x_return_status := FND_API.G_RET_STS_SUCCESS;

604: END IF;
605: /* MOAC Changes */
606: --Remember and re-set the access mode, if its Multi.
607: l_access_mode := mo_global.get_access_mode();
608: x_return_status := FND_API.G_RET_STS_SUCCESS;
609: l_count := p_selected_line_tbl.count;
610:
611: IF l_debug_level > 0 THEN
612: oe_debug_pub.add( 'Lines selected '||l_count , 1 ) ;

Line 699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

695: oe_debug_pub.add( 'EXITING Process_Schedule_Action ' , 1 ) ;
696: END IF;
697: EXCEPTION
698: WHEN OTHERS THEN
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
701: OE_MSG_PUB.Add_Exc_Msg
702: ( G_PKG_NAME
703: , 'process_schedule_action');

Line 706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

702: ( G_PKG_NAME
703: , 'process_schedule_action');
704: END IF;
705:
706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707:
708: END Process_Schedule_Action;
709:
710: