DBA Data[Home] [Help]

APPS.OE_OE_HTML_LINE_EXT dependencies on FND_API

Line 82: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

78: oe_debug_pub.add( 'AT Beg HTML LINE- SAVE FIRST CALL-Line Type'
79: || l_old_line_tbl(1).line_type_id ) ;
80:
81: Oe_Order_Pvt.Lines
82: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
83: , p_init_msg_list => FND_API.G_FALSE
84: , p_control_rec => l_control_rec
85: , p_x_line_tbl => l_line_tbl
86: , p_x_old_line_tbl => l_old_line_tbl

Line 83: , p_init_msg_list => FND_API.G_FALSE

79: || l_old_line_tbl(1).line_type_id ) ;
80:
81: Oe_Order_Pvt.Lines
82: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
83: , p_init_msg_list => FND_API.G_FALSE
84: , p_control_rec => l_control_rec
85: , p_x_line_tbl => l_line_tbl
86: , p_x_old_line_tbl => l_old_line_tbl
87: , x_return_Status => l_return_status

Line 95: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

91: oe_debug_pub.add( 'AT END HTML LINE- SAVE FIRST CALL-Line Type'
92: || l_line_tbl(1).line_type_id ) ;
93: END IF;
94:
95: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: RAISE FND_API.G_EXC_ERROR;
99: END IF;

Line 96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

92: || l_line_tbl(1).line_type_id ) ;
93: END IF;
94:
95: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: RAISE FND_API.G_EXC_ERROR;
99: END IF;
100:

Line 97: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

93: END IF;
94:
95: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: RAISE FND_API.G_EXC_ERROR;
99: END IF;
100:
101:

Line 98: RAISE FND_API.G_EXC_ERROR;

94:
95: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: RAISE FND_API.G_EXC_ERROR;
99: END IF;
100:
101:
102: IF l_debug_level > 0 THEN

Line 121: IF FND_API.To_Boolean(l_line_tbl(i).db_flag) OR

117: I := l_line_tbl.FIRST;
118: l_num_lines := l_line_tbl.COUNT;
119: WHILE I IS NOT NULL AND l_num_lines > 0
120: LOOP
121: IF FND_API.To_Boolean(l_line_tbl(i).db_flag) OR
122: l_line_tbl(i).operation = OE_GLOBALS.G_OPR_UPDATE THEN
123: oe_debug_pub.add('Operation -Update');
124: -- The operation is set to handle if it doesn't get set in middle tier.
125: l_line_tbl(i).operation:=OE_GLOBALS.G_OPR_UPDATE;

Line 145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

141: , x_shipment_number => l_line_tbl(i).shipment_number
142: );
143: oe_debug_pub.add( 'IN GET_LINE_SHIPMENT_NUMBER'||l_line_tbl(i).line_number);
144: oe_debug_pub.add( 'IN GET_LINE_SHIPMENT_NUMBER'||l_line_tbl(i).shipment_number);
145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
148: RAISE FND_API.G_EXC_ERROR;
149: END IF;

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

142: );
143: oe_debug_pub.add( 'IN GET_LINE_SHIPMENT_NUMBER'||l_line_tbl(i).line_number);
144: oe_debug_pub.add( 'IN GET_LINE_SHIPMENT_NUMBER'||l_line_tbl(i).shipment_number);
145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
148: RAISE FND_API.G_EXC_ERROR;
149: END IF;
150: END IF;

Line 147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

143: oe_debug_pub.add( 'IN GET_LINE_SHIPMENT_NUMBER'||l_line_tbl(i).line_number);
144: oe_debug_pub.add( 'IN GET_LINE_SHIPMENT_NUMBER'||l_line_tbl(i).shipment_number);
145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
148: RAISE FND_API.G_EXC_ERROR;
149: END IF;
150: END IF;
151:

Line 148: RAISE FND_API.G_EXC_ERROR;

144: oe_debug_pub.add( 'IN GET_LINE_SHIPMENT_NUMBER'||l_line_tbl(i).shipment_number);
145: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
148: RAISE FND_API.G_EXC_ERROR;
149: END IF;
150: END IF;
151:
152: J := G_line_dff_tbl.FIRST;

Line 187: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

183: l_control_rec.clear_api_cache := FALSE;
184: l_control_rec.clear_api_requests := FALSE;
185:
186: Oe_Order_Pvt.Lines
187: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
188: , p_init_msg_list => FND_API.G_TRUE
189: , p_control_rec => l_control_rec
190: , p_x_line_tbl => l_line_tbl
191: , p_x_old_line_tbl => l_old_line_tbl

Line 188: , p_init_msg_list => FND_API.G_TRUE

184: l_control_rec.clear_api_requests := FALSE;
185:
186: Oe_Order_Pvt.Lines
187: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
188: , p_init_msg_list => FND_API.G_TRUE
189: , p_control_rec => l_control_rec
190: , p_x_line_tbl => l_line_tbl
191: , p_x_old_line_tbl => l_old_line_tbl
192: , x_return_Status => l_return_status

Line 198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

194: IF l_debug_level > 0 THEN
195: oe_debug_pub.add( 'AT END HTML LINE- SAVE SECOND CALL' ) ;
196: END IF;
197:
198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
201: RAISE FND_API.G_EXC_ERROR;
202: END IF;

Line 199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

195: oe_debug_pub.add( 'AT END HTML LINE- SAVE SECOND CALL' ) ;
196: END IF;
197:
198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203:

Line 200: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

196: END IF;
197:
198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203:
204: /* Oe_Oe_Html_Header.Process_Object

Line 201: RAISE FND_API.G_EXC_ERROR;

197:
198: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203:
204: /* Oe_Oe_Html_Header.Process_Object
205: ( x_return_status =>l_return_status

Line 212: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

208: , x_cascade_flag => l_cascade_flag
209: ); */
210: oe_debug_pub.add( 'AT END HTML LINE- PROCESS OBJECT CALL' ) ;
211:
212: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;

Line 213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

209: ); */
210: oe_debug_pub.add( 'AT END HTML LINE- PROCESS OBJECT CALL' ) ;
211:
212: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:

Line 214: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

210: oe_debug_pub.add( 'AT END HTML LINE- PROCESS OBJECT CALL' ) ;
211:
212: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:
218: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 215: RAISE FND_API.G_EXC_ERROR;

211:
212: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:
218: x_return_status := FND_API.G_RET_STS_SUCCESS;
219: G_LINE_NUMBER:=Null;

Line 218: x_return_status := FND_API.G_RET_STS_SUCCESS;

214: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:
218: x_return_status := FND_API.G_RET_STS_SUCCESS;
219: G_LINE_NUMBER:=Null;
220: G_SHIPMENT_NUMBER:=Null;
221: oe_msg_pub.count_and_get
222: ( p_count => x_msg_count

Line 227: WHEN FND_API.G_EXC_ERROR THEN

223: , p_data => x_msg_data
224: );
225: oe_debug_pub.add( 'IN END HTML LINE- SAVE' ) ;
226: EXCEPTION
227: WHEN FND_API.G_EXC_ERROR THEN
228:
229: OE_GLOBALS.G_UI_FLAG := FALSE;
230:
231: x_return_status := FND_API.G_RET_STS_ERROR;

Line 231: x_return_status := FND_API.G_RET_STS_ERROR;

227: WHEN FND_API.G_EXC_ERROR THEN
228:
229: OE_GLOBALS.G_UI_FLAG := FALSE;
230:
231: x_return_status := FND_API.G_RET_STS_ERROR;
232:
233: -- Get message count and data
234:
235: oe_msg_pub.count_and_get

Line 240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

236: ( p_count => x_msg_count
237: , p_data => x_msg_data
238: );
239:
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241:
242: OE_GLOBALS.G_UI_FLAG := FALSE;
243:
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241:
242: OE_GLOBALS.G_UI_FLAG := FALSE;
243:
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245:
246: -- Get message count and data
247:
248: oe_msg_pub.count_and_get

Line 263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

259: , 'Save_Lines'
260: );
261: END IF;
262:
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264:
265: -- Get message count and data
266:
267: oe_msg_pub.count_and_get

Line 326: x_return_status := FND_API.G_RET_STS_SUCCESS;

322: -- G_SHIPMENT_NUMBER:=G_SHIPMENT_NUMBER+1;
323: x_line_number:=G_LINE_NUMBER;
324: x_shipment_number:=G_SHIPMENT_NUMBER;
325: END IF;
326: x_return_status := FND_API.G_RET_STS_SUCCESS;
327: EXCEPTION
328:
329: WHEN OTHERS THEN
330:

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

334: ( G_PKG_NAME
335: , 'Get_Line_Shipment_Number'
336: );
337: END IF;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
339:
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341:
342: END GET_LINE_SHIPMENT_NUMBER;

Line 340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

336: );
337: END IF;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
339:
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341:
342: END GET_LINE_SHIPMENT_NUMBER;
343:
344:

Line 381: x_return_status := FND_API.G_RET_STS_SUCCESS;

377: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
378:
379: BEGIN
380:
381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:
383: OPEN c_line_info;
384: FETCH c_line_info
385: INTO x_line_val_rec.line_number,

Line 398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add( 'WHEN OTHERS OF CALL_MRP_ATP' ) ;
396: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
397: END IF;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
399: -- Get message count and data
400: OE_MSG_PUB.Count_And_Get
401: ( p_count => x_msg_count
402: , p_data => x_msg_data