eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_OE_FORM_LINE_SCREDIT dependencies on FND_API

Line 173: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

169:
170: -- Call OE_Order_PVT.Process_order
171:
172: OE_Order_PVT.Line_Scredits
173: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
174: , p_init_msg_list => FND_API.G_TRUE
175: , p_control_rec => l_control_rec
176: , p_x_Line_Scredit_tbl => l_x_Line_Scredit_tbl
177: , p_x_old_Line_Scredit_tbl => l_x_old_Line_Scredit_tbl

Line 174: , p_init_msg_list => FND_API.G_TRUE

170: -- Call OE_Order_PVT.Process_order
171:
172: OE_Order_PVT.Line_Scredits
173: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
174: , p_init_msg_list => FND_API.G_TRUE
175: , p_control_rec => l_control_rec
176: , p_x_Line_Scredit_tbl => l_x_Line_Scredit_tbl
177: , p_x_old_Line_Scredit_tbl => l_x_old_Line_Scredit_tbl
178: , x_return_status => l_return_status

Line 182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

178: , x_return_status => l_return_status
179:
180: );
181:
182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;

Line 183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

179:
180: );
181:
182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:

Line 184: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

180: );
181:
182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
188:

Line 185: RAISE FND_API.G_EXC_ERROR;

181:
182: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
188:
189: -- Unload out tbl

Line 230: l_x_Line_Scredit_rec.db_flag := FND_API.G_FALSE;

226:
227: -- Write to cache.
228: -- Set db_flag to False before writing to cache
229:
230: l_x_Line_Scredit_rec.db_flag := FND_API.G_FALSE;
231:
232: Write_Line_Scredit
233: ( p_Line_Scredit_rec => l_x_Line_Scredit_rec
234: );

Line 241: x_return_status := FND_API.G_RET_STS_SUCCESS;

237: OE_GLOBALS.G_UI_FLAG := FALSE;
238:
239: -- Set return status.
240:
241: x_return_status := FND_API.G_RET_STS_SUCCESS;
242:
243: -- Get message count and data
244:
245: oe_msg_pub.Count_And_Get

Line 256: WHEN FND_API.G_EXC_ERROR THEN

252: END IF;
253:
254: EXCEPTION
255:
256: WHEN FND_API.G_EXC_ERROR THEN
257:
258: OE_GLOBALS.G_UI_FLAG := FALSE;
259:
260: x_return_status := FND_API.G_RET_STS_ERROR;

Line 260: x_return_status := FND_API.G_RET_STS_ERROR;

256: WHEN FND_API.G_EXC_ERROR THEN
257:
258: OE_GLOBALS.G_UI_FLAG := FALSE;
259:
260: x_return_status := FND_API.G_RET_STS_ERROR;
261:
262: -- Get message count and data
263:
264: oe_msg_pub.Count_And_Get

Line 269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

265: ( p_count => x_msg_count
266: , p_data => x_msg_data
267: );
268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270:
271: OE_GLOBALS.G_UI_FLAG := FALSE;
272:
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270:
271: OE_GLOBALS.G_UI_FLAG := FALSE;
272:
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
274:
275: -- Get message count and data
276:
277: oe_msg_pub.Count_And_Get

Line 286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

282: WHEN OTHERS THEN
283:
284: OE_GLOBALS.G_UI_FLAG := FALSE;
285:
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
287:
288: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
289: THEN
290: oe_msg_pub.Add_Exc_Msg

Line 513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

509: , 'Unrecognized attribute'
510: );
511: END IF;
512:
513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514:
515: END IF;
516:
517: -- Set Operation.

Line 519: IF FND_API.To_Boolean(l_Line_Scredit_rec.db_flag) THEN

515: END IF;
516:
517: -- Set Operation.
518:
519: IF FND_API.To_Boolean(l_Line_Scredit_rec.db_flag) THEN
520: l_Line_Scredit_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
521: ELSE
522: l_Line_Scredit_rec.operation := OE_GLOBALS.G_OPR_CREATE;
523: END IF;

Line 533: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

529:
530: -- Call OE_Order_PVT.Process_order
531:
532: OE_Order_PVT.Line_Scredits
533: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
534: , p_control_rec => l_control_rec
535: , p_init_msg_list => FND_API.G_TRUE
536: , p_x_Line_Scredit_tbl => l_x_Line_Scredit_tbl
537: , p_x_old_Line_Scredit_tbl => l_x_old_Line_Scredit_tbl

Line 535: , p_init_msg_list => FND_API.G_TRUE

531:
532: OE_Order_PVT.Line_Scredits
533: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
534: , p_control_rec => l_control_rec
535: , p_init_msg_list => FND_API.G_TRUE
536: , p_x_Line_Scredit_tbl => l_x_Line_Scredit_tbl
537: , p_x_old_Line_Scredit_tbl => l_x_old_Line_Scredit_tbl
538: , x_return_status => l_return_status
539: );

Line 541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

537: , p_x_old_Line_Scredit_tbl => l_x_old_Line_Scredit_tbl
538: , x_return_status => l_return_status
539: );
540:
541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;

Line 542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

538: , x_return_status => l_return_status
539: );
540:
541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546:

Line 543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

539: );
540:
541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546:
547:

Line 544: RAISE FND_API.G_EXC_ERROR;

540:
541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546:
547:
548: -- Unload out tbl

Line 554: x_attribute1 := FND_API.G_MISS_CHAR;

550: l_x_Line_Scredit_rec := l_x_Line_Scredit_tbl(1);
551:
552: -- Init OUT parameters to missing.
553:
554: x_attribute1 := FND_API.G_MISS_CHAR;
555: x_attribute10 := FND_API.G_MISS_CHAR;
556: x_attribute11 := FND_API.G_MISS_CHAR;
557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;

Line 555: x_attribute10 := FND_API.G_MISS_CHAR;

551:
552: -- Init OUT parameters to missing.
553:
554: x_attribute1 := FND_API.G_MISS_CHAR;
555: x_attribute10 := FND_API.G_MISS_CHAR;
556: x_attribute11 := FND_API.G_MISS_CHAR;
557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;

Line 556: x_attribute11 := FND_API.G_MISS_CHAR;

552: -- Init OUT parameters to missing.
553:
554: x_attribute1 := FND_API.G_MISS_CHAR;
555: x_attribute10 := FND_API.G_MISS_CHAR;
556: x_attribute11 := FND_API.G_MISS_CHAR;
557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;

Line 557: x_attribute12 := FND_API.G_MISS_CHAR;

553:
554: x_attribute1 := FND_API.G_MISS_CHAR;
555: x_attribute10 := FND_API.G_MISS_CHAR;
556: x_attribute11 := FND_API.G_MISS_CHAR;
557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;

Line 558: x_attribute13 := FND_API.G_MISS_CHAR;

554: x_attribute1 := FND_API.G_MISS_CHAR;
555: x_attribute10 := FND_API.G_MISS_CHAR;
556: x_attribute11 := FND_API.G_MISS_CHAR;
557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;

Line 559: x_attribute14 := FND_API.G_MISS_CHAR;

555: x_attribute10 := FND_API.G_MISS_CHAR;
556: x_attribute11 := FND_API.G_MISS_CHAR;
557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;

Line 560: x_attribute15 := FND_API.G_MISS_CHAR;

556: x_attribute11 := FND_API.G_MISS_CHAR;
557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;

Line 561: x_attribute2 := FND_API.G_MISS_CHAR;

557: x_attribute12 := FND_API.G_MISS_CHAR;
558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;

Line 562: x_attribute3 := FND_API.G_MISS_CHAR;

558: x_attribute13 := FND_API.G_MISS_CHAR;
559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;

Line 563: x_attribute4 := FND_API.G_MISS_CHAR;

559: x_attribute14 := FND_API.G_MISS_CHAR;
560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;

Line 564: x_attribute5 := FND_API.G_MISS_CHAR;

560: x_attribute15 := FND_API.G_MISS_CHAR;
561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;

Line 565: x_attribute6 := FND_API.G_MISS_CHAR;

561: x_attribute2 := FND_API.G_MISS_CHAR;
562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;

Line 566: x_attribute7 := FND_API.G_MISS_CHAR;

562: x_attribute3 := FND_API.G_MISS_CHAR;
563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;
570: x_dw_update_advice_flag := FND_API.G_MISS_CHAR;

Line 567: x_attribute8 := FND_API.G_MISS_CHAR;

563: x_attribute4 := FND_API.G_MISS_CHAR;
564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;
570: x_dw_update_advice_flag := FND_API.G_MISS_CHAR;
571: x_header_id := FND_API.G_MISS_NUM;

Line 568: x_attribute9 := FND_API.G_MISS_CHAR;

564: x_attribute5 := FND_API.G_MISS_CHAR;
565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;
570: x_dw_update_advice_flag := FND_API.G_MISS_CHAR;
571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;

Line 569: x_context := FND_API.G_MISS_CHAR;

565: x_attribute6 := FND_API.G_MISS_CHAR;
566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;
570: x_dw_update_advice_flag := FND_API.G_MISS_CHAR;
571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
573: x_percent := FND_API.G_MISS_NUM;

Line 570: x_dw_update_advice_flag := FND_API.G_MISS_CHAR;

566: x_attribute7 := FND_API.G_MISS_CHAR;
567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;
570: x_dw_update_advice_flag := FND_API.G_MISS_CHAR;
571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
573: x_percent := FND_API.G_MISS_NUM;
574: x_salesrep_id := FND_API.G_MISS_NUM;

Line 571: x_header_id := FND_API.G_MISS_NUM;

567: x_attribute8 := FND_API.G_MISS_CHAR;
568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;
570: x_dw_update_advice_flag := FND_API.G_MISS_CHAR;
571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
573: x_percent := FND_API.G_MISS_NUM;
574: x_salesrep_id := FND_API.G_MISS_NUM;
575: x_sales_credit_type_id := FND_API.G_MISS_NUM;

Line 572: x_line_id := FND_API.G_MISS_NUM;

568: x_attribute9 := FND_API.G_MISS_CHAR;
569: x_context := FND_API.G_MISS_CHAR;
570: x_dw_update_advice_flag := FND_API.G_MISS_CHAR;
571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
573: x_percent := FND_API.G_MISS_NUM;
574: x_salesrep_id := FND_API.G_MISS_NUM;
575: x_sales_credit_type_id := FND_API.G_MISS_NUM;
576: x_sales_credit_id := FND_API.G_MISS_NUM;

Line 573: x_percent := FND_API.G_MISS_NUM;

569: x_context := FND_API.G_MISS_CHAR;
570: x_dw_update_advice_flag := FND_API.G_MISS_CHAR;
571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
573: x_percent := FND_API.G_MISS_NUM;
574: x_salesrep_id := FND_API.G_MISS_NUM;
575: x_sales_credit_type_id := FND_API.G_MISS_NUM;
576: x_sales_credit_id := FND_API.G_MISS_NUM;
577: x_wh_update_date := FND_API.G_MISS_DATE;

Line 574: x_salesrep_id := FND_API.G_MISS_NUM;

570: x_dw_update_advice_flag := FND_API.G_MISS_CHAR;
571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
573: x_percent := FND_API.G_MISS_NUM;
574: x_salesrep_id := FND_API.G_MISS_NUM;
575: x_sales_credit_type_id := FND_API.G_MISS_NUM;
576: x_sales_credit_id := FND_API.G_MISS_NUM;
577: x_wh_update_date := FND_API.G_MISS_DATE;
578: x_salesrep := FND_API.G_MISS_CHAR;

Line 575: x_sales_credit_type_id := FND_API.G_MISS_NUM;

571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
573: x_percent := FND_API.G_MISS_NUM;
574: x_salesrep_id := FND_API.G_MISS_NUM;
575: x_sales_credit_type_id := FND_API.G_MISS_NUM;
576: x_sales_credit_id := FND_API.G_MISS_NUM;
577: x_wh_update_date := FND_API.G_MISS_DATE;
578: x_salesrep := FND_API.G_MISS_CHAR;
579: x_sales_credit_type := FND_API.G_MISS_CHAR;

Line 576: x_sales_credit_id := FND_API.G_MISS_NUM;

572: x_line_id := FND_API.G_MISS_NUM;
573: x_percent := FND_API.G_MISS_NUM;
574: x_salesrep_id := FND_API.G_MISS_NUM;
575: x_sales_credit_type_id := FND_API.G_MISS_NUM;
576: x_sales_credit_id := FND_API.G_MISS_NUM;
577: x_wh_update_date := FND_API.G_MISS_DATE;
578: x_salesrep := FND_API.G_MISS_CHAR;
579: x_sales_credit_type := FND_API.G_MISS_CHAR;
580: --SG{

Line 577: x_wh_update_date := FND_API.G_MISS_DATE;

573: x_percent := FND_API.G_MISS_NUM;
574: x_salesrep_id := FND_API.G_MISS_NUM;
575: x_sales_credit_type_id := FND_API.G_MISS_NUM;
576: x_sales_credit_id := FND_API.G_MISS_NUM;
577: x_wh_update_date := FND_API.G_MISS_DATE;
578: x_salesrep := FND_API.G_MISS_CHAR;
579: x_sales_credit_type := FND_API.G_MISS_CHAR;
580: --SG{
581: x_sales_group := FND_API.G_MISS_CHAR;

Line 578: x_salesrep := FND_API.G_MISS_CHAR;

574: x_salesrep_id := FND_API.G_MISS_NUM;
575: x_sales_credit_type_id := FND_API.G_MISS_NUM;
576: x_sales_credit_id := FND_API.G_MISS_NUM;
577: x_wh_update_date := FND_API.G_MISS_DATE;
578: x_salesrep := FND_API.G_MISS_CHAR;
579: x_sales_credit_type := FND_API.G_MISS_CHAR;
580: --SG{
581: x_sales_group := FND_API.G_MISS_CHAR;
582: x_sales_group_id := FND_API.G_MISS_NUM;

Line 579: x_sales_credit_type := FND_API.G_MISS_CHAR;

575: x_sales_credit_type_id := FND_API.G_MISS_NUM;
576: x_sales_credit_id := FND_API.G_MISS_NUM;
577: x_wh_update_date := FND_API.G_MISS_DATE;
578: x_salesrep := FND_API.G_MISS_CHAR;
579: x_sales_credit_type := FND_API.G_MISS_CHAR;
580: --SG{
581: x_sales_group := FND_API.G_MISS_CHAR;
582: x_sales_group_id := FND_API.G_MISS_NUM;
583: x_sales_group_updated_flag := FND_API.G_MISS_CHAR;

Line 581: x_sales_group := FND_API.G_MISS_CHAR;

577: x_wh_update_date := FND_API.G_MISS_DATE;
578: x_salesrep := FND_API.G_MISS_CHAR;
579: x_sales_credit_type := FND_API.G_MISS_CHAR;
580: --SG{
581: x_sales_group := FND_API.G_MISS_CHAR;
582: x_sales_group_id := FND_API.G_MISS_NUM;
583: x_sales_group_updated_flag := FND_API.G_MISS_CHAR;
584: --SG}
585:

Line 582: x_sales_group_id := FND_API.G_MISS_NUM;

578: x_salesrep := FND_API.G_MISS_CHAR;
579: x_sales_credit_type := FND_API.G_MISS_CHAR;
580: --SG{
581: x_sales_group := FND_API.G_MISS_CHAR;
582: x_sales_group_id := FND_API.G_MISS_NUM;
583: x_sales_group_updated_flag := FND_API.G_MISS_CHAR;
584: --SG}
585:
586: -- Load display out parameters if any

Line 583: x_sales_group_updated_flag := FND_API.G_MISS_CHAR;

579: x_sales_credit_type := FND_API.G_MISS_CHAR;
580: --SG{
581: x_sales_group := FND_API.G_MISS_CHAR;
582: x_sales_group_id := FND_API.G_MISS_NUM;
583: x_sales_group_updated_flag := FND_API.G_MISS_CHAR;
584: --SG}
585:
586: -- Load display out parameters if any
587:

Line 767: x_return_status := FND_API.G_RET_STS_SUCCESS;

763: OE_GLOBALS.G_UI_FLAG := FALSE;
764:
765: -- Set return status.
766:
767: x_return_status := FND_API.G_RET_STS_SUCCESS;
768:
769: -- Get message count and data
770:
771: oe_msg_pub.Count_And_Get

Line 782: WHEN FND_API.G_EXC_ERROR THEN

778: END IF;
779:
780: EXCEPTION
781:
782: WHEN FND_API.G_EXC_ERROR THEN
783:
784: OE_GLOBALS.G_UI_FLAG := FALSE;
785:
786: x_return_status := FND_API.G_RET_STS_ERROR;

Line 786: x_return_status := FND_API.G_RET_STS_ERROR;

782: WHEN FND_API.G_EXC_ERROR THEN
783:
784: OE_GLOBALS.G_UI_FLAG := FALSE;
785:
786: x_return_status := FND_API.G_RET_STS_ERROR;
787:
788: -- Get message count and data
789:
790: oe_msg_pub.Count_And_Get

Line 795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

791: ( p_count => x_msg_count
792: , p_data => x_msg_data
793: );
794:
795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
796:
797: OE_GLOBALS.G_UI_FLAG := FALSE;
798:
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
796:
797: OE_GLOBALS.G_UI_FLAG := FALSE;
798:
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
800:
801: -- Get message count and data
802:
803: oe_msg_pub.Count_And_Get

Line 812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

808: WHEN OTHERS THEN
809:
810: OE_GLOBALS.G_UI_FLAG := FALSE;
811:
812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
813:
814: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
815: THEN
816: oe_msg_pub.Add_Exc_Msg

Line 911: IF FND_API.To_Boolean(l_Line_Scredit_rec.db_flag) THEN

907: );
908:
909: -- Set Operation.
910:
911: IF FND_API.To_Boolean(l_Line_Scredit_rec.db_flag) THEN
912: l_Line_Scredit_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
913: ELSE
914: l_Line_Scredit_rec.operation := OE_GLOBALS.G_OPR_CREATE;
915: END IF;

Line 930: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

926:
927: -- Call OE_Order_PVT.Process_order
928:
929: OE_Order_PVT.Line_Scredits
930: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
931: , p_init_msg_list => FND_API.G_TRUE
932: , p_control_rec => l_control_rec
933: , p_x_Line_Scredit_tbl => l_x_Line_Scredit_tbl
934: , p_x_old_Line_Scredit_tbl => l_x_old_Line_Scredit_tbl

Line 931: , p_init_msg_list => FND_API.G_TRUE

927: -- Call OE_Order_PVT.Process_order
928:
929: OE_Order_PVT.Line_Scredits
930: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
931: , p_init_msg_list => FND_API.G_TRUE
932: , p_control_rec => l_control_rec
933: , p_x_Line_Scredit_tbl => l_x_Line_Scredit_tbl
934: , p_x_old_Line_Scredit_tbl => l_x_old_Line_Scredit_tbl
935: , x_return_status => l_return_status

Line 938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

934: , p_x_old_Line_Scredit_tbl => l_x_old_Line_Scredit_tbl
935: , x_return_status => l_return_status
936: );
937:
938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
940: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;

Line 939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

935: , x_return_status => l_return_status
936: );
937:
938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
940: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;
943:

Line 940: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

936: );
937:
938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
940: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;
943:
944:

Line 941: RAISE FND_API.G_EXC_ERROR;

937:
938: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
940: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;
943:
944:
945: /* The Process Request and Notify call should still be called */

Line 952: , p_init_msg_list => FND_API.G_FALSE

948: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110508' THEN
949:
950: Oe_Order_Pvt.Process_Requests_And_Notify
951: ( p_process_requests => FALSE
952: , p_init_msg_list => FND_API.G_FALSE
953: , p_notify => TRUE
954: , x_return_status => l_return_status
955: , p_line_scredit_tbl => l_x_Line_Scredit_tbl
956: , p_old_line_scredit_tbl => l_x_old_Line_Scredit_tbl

Line 959: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

955: , p_line_scredit_tbl => l_x_Line_Scredit_tbl
956: , p_old_line_scredit_tbl => l_x_old_Line_Scredit_tbl
957: );
958:
959: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
962: RAISE FND_API.G_EXC_ERROR;
963: END IF;

Line 960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

956: , p_old_line_scredit_tbl => l_x_old_Line_Scredit_tbl
957: );
958:
959: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
962: RAISE FND_API.G_EXC_ERROR;
963: END IF;
964: END IF;

Line 961: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

957: );
958:
959: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
962: RAISE FND_API.G_EXC_ERROR;
963: END IF;
964: END IF;
965:

Line 962: RAISE FND_API.G_EXC_ERROR;

958:
959: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
962: RAISE FND_API.G_EXC_ERROR;
963: END IF;
964: END IF;
965:
966:

Line 991: x_return_status := FND_API.G_RET_STS_SUCCESS;

987: OE_GLOBALS.G_UI_FLAG := FALSE;
988:
989: -- Set return status.
990:
991: x_return_status := FND_API.G_RET_STS_SUCCESS;
992:
993: -- Get message count and data
994:
995: oe_msg_pub.Count_And_Get

Line 1006: WHEN FND_API.G_EXC_ERROR THEN

1002: END IF;
1003:
1004: EXCEPTION
1005:
1006: WHEN FND_API.G_EXC_ERROR THEN
1007:
1008: OE_GLOBALS.G_UI_FLAG := FALSE;
1009:
1010: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1010: x_return_status := FND_API.G_RET_STS_ERROR;

1006: WHEN FND_API.G_EXC_ERROR THEN
1007:
1008: OE_GLOBALS.G_UI_FLAG := FALSE;
1009:
1010: x_return_status := FND_API.G_RET_STS_ERROR;
1011:
1012: -- Get message count and data
1013:
1014: oe_msg_pub.Count_And_Get

Line 1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1015: ( p_count => x_msg_count
1016: , p_data => x_msg_data
1017: );
1018:
1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1020:
1021: OE_GLOBALS.G_UI_FLAG := FALSE;
1022:
1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1020:
1021: OE_GLOBALS.G_UI_FLAG := FALSE;
1022:
1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1024:
1025: -- Get message count and data
1026:
1027: oe_msg_pub.Count_And_Get

Line 1036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1032: WHEN OTHERS THEN
1033:
1034: OE_GLOBALS.G_UI_FLAG := FALSE;
1035:
1036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1037:
1038: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1039: THEN
1040: oe_msg_pub.Add_Exc_Msg

Line 1127: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

1123:
1124: -- Call OE_Order_PVT.Process_order
1125:
1126: OE_Order_PVT.Line_Scredits
1127: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1128: , p_init_msg_list => FND_API.G_TRUE
1129: , p_control_rec => l_control_rec
1130: , p_x_Line_Scredit_tbl => l_x_Line_Scredit_tbl
1131: , p_x_old_Line_Scredit_tbl => l_x_old_Line_Scredit_tbl

Line 1128: , p_init_msg_list => FND_API.G_TRUE

1124: -- Call OE_Order_PVT.Process_order
1125:
1126: OE_Order_PVT.Line_Scredits
1127: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1128: , p_init_msg_list => FND_API.G_TRUE
1129: , p_control_rec => l_control_rec
1130: , p_x_Line_Scredit_tbl => l_x_Line_Scredit_tbl
1131: , p_x_old_Line_Scredit_tbl => l_x_old_Line_Scredit_tbl
1132: , x_return_status => l_return_status

Line 1135: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1131: , p_x_old_Line_Scredit_tbl => l_x_old_Line_Scredit_tbl
1132: , x_return_status => l_return_status
1133: );
1134:
1135: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;

Line 1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1132: , x_return_status => l_return_status
1133: );
1134:
1135: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140:

Line 1137: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1133: );
1134:
1135: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140:
1141:

Line 1138: RAISE FND_API.G_EXC_ERROR;

1134:
1135: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140:
1141:
1142: -- Clear Line_Scredit record cache

Line 1151: x_return_status := FND_API.G_RET_STS_SUCCESS;

1147: OE_GLOBALS.G_UI_FLAG := FALSE;
1148:
1149: -- Set return status.
1150:
1151: x_return_status := FND_API.G_RET_STS_SUCCESS;
1152:
1153: -- Get message count and data
1154:
1155: oe_msg_pub.Count_And_Get

Line 1166: WHEN FND_API.G_EXC_ERROR THEN

1162: END IF;
1163:
1164: EXCEPTION
1165:
1166: WHEN FND_API.G_EXC_ERROR THEN
1167:
1168: OE_GLOBALS.G_UI_FLAG := FALSE;
1169:
1170: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1170: x_return_status := FND_API.G_RET_STS_ERROR;

1166: WHEN FND_API.G_EXC_ERROR THEN
1167:
1168: OE_GLOBALS.G_UI_FLAG := FALSE;
1169:
1170: x_return_status := FND_API.G_RET_STS_ERROR;
1171:
1172: -- Get message count and data
1173:
1174: oe_msg_pub.Count_And_Get

Line 1179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1175: ( p_count => x_msg_count
1176: , p_data => x_msg_data
1177: );
1178:
1179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1180:
1181: OE_GLOBALS.G_UI_FLAG := FALSE;
1182:
1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1180:
1181: OE_GLOBALS.G_UI_FLAG := FALSE;
1182:
1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1184:
1185: -- Get message count and data
1186:
1187: oe_msg_pub.Count_And_Get

Line 1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1192: WHEN OTHERS THEN
1193:
1194: OE_GLOBALS.G_UI_FLAG := FALSE;
1195:
1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1197:
1198: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1199: THEN
1200: oe_msg_pub.Add_Exc_Msg

Line 1284: , p_init_msg_list => FND_API.G_TRUE

1280: -- Call OE_Order_PVT.Process_order
1281:
1282: OE_Order_PVT.Process_order
1283: ( p_api_version_number => 1.0
1284: , p_init_msg_list => FND_API.G_TRUE
1285: , x_return_status => l_return_status
1286: , x_msg_count => x_msg_count
1287: , x_msg_data => x_msg_data
1288: , p_control_rec => l_control_rec

Line 1308: , p_init_msg_list => FND_API.G_TRUE

1304: );
1305: */
1306: Oe_Order_Pvt.Process_Requests_And_Notify
1307: ( p_process_requests => TRUE
1308: , p_init_msg_list => FND_API.G_TRUE
1309: , p_notify => FALSE -- jolin
1310: , x_return_status => l_return_status
1311: );
1312:

Line 1313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1309: , p_notify => FALSE -- jolin
1310: , x_return_status => l_return_status
1311: );
1312:
1313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1316: RAISE FND_API.G_EXC_ERROR;
1317: END IF;

Line 1314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1310: , x_return_status => l_return_status
1311: );
1312:
1313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1316: RAISE FND_API.G_EXC_ERROR;
1317: END IF;
1318:

Line 1315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1311: );
1312:
1313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1316: RAISE FND_API.G_EXC_ERROR;
1317: END IF;
1318:
1319:

Line 1316: RAISE FND_API.G_EXC_ERROR;

1312:
1313: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1315: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1316: RAISE FND_API.G_EXC_ERROR;
1317: END IF;
1318:
1319:
1320: -- Re-set the UI flag to FALSE

Line 1325: x_return_status := FND_API.G_RET_STS_SUCCESS;

1321: OE_GLOBALS.G_UI_FLAG := FALSE;
1322:
1323: -- Set return status.
1324:
1325: x_return_status := FND_API.G_RET_STS_SUCCESS;
1326:
1327: -- Get message count and data
1328:
1329: oe_msg_pub.Count_And_Get

Line 1340: WHEN FND_API.G_EXC_ERROR THEN

1336: END IF;
1337:
1338: EXCEPTION
1339:
1340: WHEN FND_API.G_EXC_ERROR THEN
1341:
1342: OE_GLOBALS.G_UI_FLAG := FALSE;
1343:
1344: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1344: x_return_status := FND_API.G_RET_STS_ERROR;

1340: WHEN FND_API.G_EXC_ERROR THEN
1341:
1342: OE_GLOBALS.G_UI_FLAG := FALSE;
1343:
1344: x_return_status := FND_API.G_RET_STS_ERROR;
1345:
1346: -- Get message count and data
1347:
1348: oe_msg_pub.Count_And_Get

Line 1353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1349: ( p_count => x_msg_count
1350: , p_data => x_msg_data
1351: );
1352:
1353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1354:
1355: OE_GLOBALS.G_UI_FLAG := FALSE;
1356:
1357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1354:
1355: OE_GLOBALS.G_UI_FLAG := FALSE;
1356:
1357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1358:
1359: -- Get message count and data
1360:
1361: oe_msg_pub.Count_And_Get

Line 1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1366: WHEN OTHERS THEN
1367:
1368: OE_GLOBALS.G_UI_FLAG := FALSE;
1369:
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1371:
1372: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1373: THEN
1374: oe_msg_pub.Add_Exc_Msg

Line 1429: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1425: OE_Line_Scredit_Util.Lock_Row
1426: ( x_return_status => l_return_status
1427: , p_x_Line_Scredit_rec => l_x_Line_Scredit_rec );
1428:
1429: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1430:
1431: -- Set DB flag and write record to cache.
1432:
1433: l_x_Line_Scredit_rec.db_flag := FND_API.G_TRUE;

Line 1433: l_x_Line_Scredit_rec.db_flag := FND_API.G_TRUE;

1429: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1430:
1431: -- Set DB flag and write record to cache.
1432:
1433: l_x_Line_Scredit_rec.db_flag := FND_API.G_TRUE;
1434:
1435: Write_Line_Scredit
1436: ( p_Line_Scredit_rec => l_x_Line_Scredit_rec
1437: , p_db_record => TRUE

Line 1470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1466: , 'Lock_Row'
1467: );
1468: END IF;
1469:
1470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1471:
1472: -- Get message count and data
1473:
1474: oe_msg_pub.Count_And_Get

Line 1538: g_Line_Scredit_rec.db_flag := FND_API.G_TRUE;

1534: ( p_sales_credit_id => p_sales_credit_id
1535: , x_line_scredit_rec => g_Line_Scredit_rec
1536: );
1537:
1538: g_Line_Scredit_rec.db_flag := FND_API.G_TRUE;
1539:
1540: -- Load DB record
1541:
1542: g_db_Line_Scredit_rec := g_Line_Scredit_rec;