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_HTML_LINE dependencies on FND_API

Line 211: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

207: l_error := 3;
208:
209:
210: Oe_Order_Pvt.Lines
211: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
212: , p_init_msg_list => FND_API.G_TRUE
213: , p_control_rec => l_control_rec
214: , p_x_line_tbl => x_line_tbl
215: , p_x_old_line_tbl => x_old_line_tbl

Line 212: , p_init_msg_list => FND_API.G_TRUE

208:
209:
210: Oe_Order_Pvt.Lines
211: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
212: , p_init_msg_list => FND_API.G_TRUE
213: , p_control_rec => l_control_rec
214: , p_x_line_tbl => x_line_tbl
215: , p_x_old_line_tbl => x_old_line_tbl
216: , x_return_status => l_return_status

Line 224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

220: IF l_debug_level > 0 THEN
221: oe_debug_pub.add( 'LINE CONTROLLER - DEFAULT ATTRIBUTES - AFTER PROCESS' , 2 ) ;
222: END IF;
223:
224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
226: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
227: RAISE FND_API.G_EXC_ERROR;
228: END IF;

Line 225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

221: oe_debug_pub.add( 'LINE CONTROLLER - DEFAULT ATTRIBUTES - AFTER PROCESS' , 2 ) ;
222: END IF;
223:
224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
226: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
227: RAISE FND_API.G_EXC_ERROR;
228: END IF;
229:

Line 226: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

222: END IF;
223:
224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
226: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
227: RAISE FND_API.G_EXC_ERROR;
228: END IF;
229:
230:

Line 227: RAISE FND_API.G_EXC_ERROR;

223:
224: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
226: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
227: RAISE FND_API.G_EXC_ERROR;
228: END IF;
229:
230:
231: -- Unload out tbl

Line 247: x_line_tbl(1).db_flag := FND_API.G_FALSE;

243: IF l_debug_level > 0 THEN
244: oe_debug_pub.add( 'LINE CONTROLLER - DEFAULT ATTRIBUTES - CALLING WRITE LINE' , 2 ) ;
245: END IF;
246:
247: x_line_tbl(1).db_flag := FND_API.G_FALSE;
248:
249:
250: -- Re-set the UI flag to FALSE
251: OE_GLOBALS.G_UI_FLAG := FALSE;

Line 255: x_return_status := FND_API.G_RET_STS_SUCCESS;

251: OE_GLOBALS.G_UI_FLAG := FALSE;
252:
253: -- Set return status.
254:
255: x_return_status := FND_API.G_RET_STS_SUCCESS;
256:
257: -- Get message count and data
258:
259: oe_msg_pub.count_and_get

Line 270: WHEN FND_API.G_EXC_ERROR THEN

266: END IF;
267:
268: EXCEPTION
269:
270: WHEN FND_API.G_EXC_ERROR THEN
271:
272: OE_GLOBALS.G_UI_FLAG := FALSE;
273:
274: x_return_status := FND_API.G_RET_STS_ERROR;

Line 274: x_return_status := FND_API.G_RET_STS_ERROR;

270: WHEN FND_API.G_EXC_ERROR THEN
271:
272: OE_GLOBALS.G_UI_FLAG := FALSE;
273:
274: x_return_status := FND_API.G_RET_STS_ERROR;
275:
276: -- Get message count and data
277:
278: oe_msg_pub.count_and_get

Line 283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

279: ( p_count => x_msg_count
280: , p_data => x_msg_data
281: );
282:
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284:
285: OE_GLOBALS.G_UI_FLAG := FALSE;
286:
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284:
285: OE_GLOBALS.G_UI_FLAG := FALSE;
286:
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
288:
289: -- Get message count and data
290:
291: oe_msg_pub.count_and_get

Line 300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

296: WHEN OTHERS THEN
297:
298: OE_GLOBALS.G_UI_FLAG := FALSE;
299:
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
301:
302: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
303: THEN
304: oe_msg_pub.Add_Exc_Msg

Line 343: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

339:
340: )
341: IS
342: l_control_rec OE_GLOBALS.Control_Rec_Type;
343: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
344: l_order_date_type_code VARCHAR2(30) := null;
345: l_orig_ship_from_org_id OE_Order_LINES.ship_from_org_id%TYPE;
346: l_x_item_rec_type OE_ORDER_CACHE.item_rec_type; -- OPM 2/JUN/00
347: file_name varchar2(100);

Line 396: IF FND_API.To_Boolean(x_line_tbl(1).db_flag) THEN

392:
393: x_line_tbl(1):=x_line_Rec;
394: x_old_line_tbl(1):=x_old_line_Rec;
395:
396: IF FND_API.To_Boolean(x_line_tbl(1).db_flag) THEN
397: x_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
398: ELSE
399: x_line_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
400: END IF;

Line 415: p_validation_level => FND_API.G_VALID_LEVEL_NONE

411:
412: -- Call Oe_Order_Pvt.Process_order
413: Oe_Order_Pvt.Lines
414: (
415: p_validation_level => FND_API.G_VALID_LEVEL_NONE
416: , p_init_msg_list => FND_API.G_TRUE
417: , p_control_rec => l_control_rec
418: , p_x_line_tbl => x_line_tbl
419: , p_x_old_line_tbl => x_old_line_tbl

Line 416: , p_init_msg_list => FND_API.G_TRUE

412: -- Call Oe_Order_Pvt.Process_order
413: Oe_Order_Pvt.Lines
414: (
415: p_validation_level => FND_API.G_VALID_LEVEL_NONE
416: , p_init_msg_list => FND_API.G_TRUE
417: , p_control_rec => l_control_rec
418: , p_x_line_tbl => x_line_tbl
419: , p_x_old_line_tbl => x_old_line_tbl
420: , x_return_status => l_return_status

Line 424: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

420: , x_return_status => l_return_status
421: );
422:
423:
424: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
425: IF l_debug_level > 0 THEN
426: oe_debug_pub.add( 'PROCESS ORDER RETURN UNEXP_ERROR' , 2 ) ;
427: END IF;
428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

424: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
425: IF l_debug_level > 0 THEN
426: oe_debug_pub.add( 'PROCESS ORDER RETURN UNEXP_ERROR' , 2 ) ;
427: END IF;
428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
429: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
430: IF l_debug_level > 0 THEN
431: oe_debug_pub.add( 'PROCESS ORDER RETURN RET_STS_ERROR' , 2 ) ;
432: END IF;

Line 429: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

425: IF l_debug_level > 0 THEN
426: oe_debug_pub.add( 'PROCESS ORDER RETURN UNEXP_ERROR' , 2 ) ;
427: END IF;
428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
429: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
430: IF l_debug_level > 0 THEN
431: oe_debug_pub.add( 'PROCESS ORDER RETURN RET_STS_ERROR' , 2 ) ;
432: END IF;
433: RAISE FND_API.G_EXC_ERROR;

Line 433: RAISE FND_API.G_EXC_ERROR;

429: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
430: IF l_debug_level > 0 THEN
431: oe_debug_pub.add( 'PROCESS ORDER RETURN RET_STS_ERROR' , 2 ) ;
432: END IF;
433: RAISE FND_API.G_EXC_ERROR;
434: END IF;
435:
436:
437: -- Unload out tbl

Line 461: x_return_status := FND_API.G_RET_STS_SUCCESS;

457: OE_GLOBALS.G_UI_FLAG := FALSE;
458:
459: -- Set return status.
460:
461: x_return_status := FND_API.G_RET_STS_SUCCESS;
462:
463: -- Get message count and data
464: x_line_rec:=x_line_tbl(1);
465: x_old_line_rec:=x_old_line_tbl(1);

Line 479: WHEN FND_API.G_EXC_ERROR THEN

475: END IF;
476:
477: EXCEPTION
478:
479: WHEN FND_API.G_EXC_ERROR THEN
480:
481: OE_GLOBALS.G_UI_FLAG := FALSE;
482:
483: x_return_status := FND_API.G_RET_STS_ERROR;

Line 483: x_return_status := FND_API.G_RET_STS_ERROR;

479: WHEN FND_API.G_EXC_ERROR THEN
480:
481: OE_GLOBALS.G_UI_FLAG := FALSE;
482:
483: x_return_status := FND_API.G_RET_STS_ERROR;
484:
485: -- Get message count and data
486:
487: oe_msg_pub.count_and_get

Line 492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

488: ( p_count => x_msg_count
489: , p_data => x_msg_data
490: );
491:
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
493:
494: OE_GLOBALS.G_UI_FLAG := FALSE;
495:
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
493:
494: OE_GLOBALS.G_UI_FLAG := FALSE;
495:
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
497:
498: -- Get message count and data
499:
500: oe_msg_pub.count_and_get

Line 509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

505: WHEN OTHERS THEN
506:
507: OE_GLOBALS.G_UI_FLAG := FALSE;
508:
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
510:
511: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
512: THEN
513: oe_msg_pub.Add_Exc_Msg

Line 589: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

585:
586: -- Call Oe_Order_Pvt.Process_order
587:
588: Oe_Order_Pvt.Lines
589: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
590: , p_init_msg_list => FND_API.G_TRUE
591: , p_control_rec => l_control_rec
592: , p_x_line_tbl => l_x_line_tbl
593: , p_x_old_line_tbl => l_x_old_line_tbl

Line 590: , p_init_msg_list => FND_API.G_TRUE

586: -- Call Oe_Order_Pvt.Process_order
587:
588: Oe_Order_Pvt.Lines
589: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
590: , p_init_msg_list => FND_API.G_TRUE
591: , p_control_rec => l_control_rec
592: , p_x_line_tbl => l_x_line_tbl
593: , p_x_old_line_tbl => l_x_old_line_tbl
594: , x_return_status => l_return_status

Line 599: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

595:
596: );
597:
598:
599: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;

Line 600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

596: );
597:
598:
599: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604:

Line 601: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

597:
598:
599: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604:
605: -- Re-set the UI flag to FALSE

Line 602: RAISE FND_API.G_EXC_ERROR;

598:
599: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604:
605: -- Re-set the UI flag to FALSE
606: OE_GLOBALS.G_UI_FLAG := FALSE;

Line 613: x_return_status := FND_API.G_RET_STS_SUCCESS;

609:
610:
611: -- Set return status.
612:
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:
615: -- Get message count and data
616:
617: oe_msg_pub.count_and_get

Line 628: WHEN FND_API.G_EXC_ERROR THEN

624: END IF;
625:
626: EXCEPTION
627:
628: WHEN FND_API.G_EXC_ERROR THEN
629: ROLLBACK TO SAVEPOINT Line_Delete;
630: OE_GLOBALS.G_UI_FLAG := FALSE;
631:
632: x_return_status := FND_API.G_RET_STS_ERROR;

Line 632: x_return_status := FND_API.G_RET_STS_ERROR;

628: WHEN FND_API.G_EXC_ERROR THEN
629: ROLLBACK TO SAVEPOINT Line_Delete;
630: OE_GLOBALS.G_UI_FLAG := FALSE;
631:
632: x_return_status := FND_API.G_RET_STS_ERROR;
633:
634: -- Get message count and data
635:
636: oe_msg_pub.count_and_get

Line 641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

637: ( p_count => x_msg_count
638: , p_data => x_msg_data
639: );
640:
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642: ROLLBACK TO SAVEPOINT Line_Delete;
643:
644: OE_GLOBALS.G_UI_FLAG := FALSE;
645:

Line 646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

642: ROLLBACK TO SAVEPOINT Line_Delete;
643:
644: OE_GLOBALS.G_UI_FLAG := FALSE;
645:
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
647:
648: -- Get message count and data
649:
650: oe_msg_pub.count_and_get

Line 660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

656: ROLLBACK TO SAVEPOINT Line_Delete;
657:
658: OE_GLOBALS.G_UI_FLAG := FALSE;
659:
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661:
662: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
663: THEN
664: oe_msg_pub.Add_Exc_Msg

Line 719: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

715: ( x_return_status => l_return_status
716: , p_x_line_rec => l_x_line_rec
717: , p_line_id => p_line_id);
718:
719: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
720:
721: -- Set DB flag and write record to cache.
722:
723: l_x_line_rec.db_flag := FND_API.G_TRUE;

Line 723: l_x_line_rec.db_flag := FND_API.G_TRUE;

719: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
720:
721: -- Set DB flag and write record to cache.
722:
723: l_x_line_rec.db_flag := FND_API.G_TRUE;
724: IF l_debug_level > 0 THEN
725: oe_debug_pub.add( 'EXITING Oe_Oe_Html_Line.LOCK_ROW'||L_X_LINE_REC.LINE_ID , 1 ) ;
726: END IF;
727:

Line 734: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

730:
731: -- Set return status.
732:
733: x_return_status := l_return_status;
734: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
736: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;

Line 735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

731: -- Set return status.
732:
733: x_return_status := l_return_status;
734: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
736: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;
739:

Line 736: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

732:
733: x_return_status := l_return_status;
734: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
736: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;
739:
740: -- Get message count and data

Line 737: RAISE FND_API.G_EXC_ERROR;

733: x_return_status := l_return_status;
734: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
736: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;
739:
740: -- Get message count and data
741:

Line 752: WHEN FND_API.G_EXC_ERROR THEN

748: oe_debug_pub.add( 'EXITING Oe_Oe_Html_Line.LOCK_ROW' , 1 ) ;
749: END IF;
750:
751: EXCEPTION
752: WHEN FND_API.G_EXC_ERROR THEN
753:
754: OE_GLOBALS.G_UI_FLAG := FALSE;
755:
756: x_return_status := FND_API.G_RET_STS_ERROR;

Line 756: x_return_status := FND_API.G_RET_STS_ERROR;

752: WHEN FND_API.G_EXC_ERROR THEN
753:
754: OE_GLOBALS.G_UI_FLAG := FALSE;
755:
756: x_return_status := FND_API.G_RET_STS_ERROR;
757:
758: -- Get message count and data
759:
760: oe_msg_pub.count_and_get

Line 765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

761: ( p_count => x_msg_count
762: , p_data => x_msg_data
763: );
764:
765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
766:
767: OE_GLOBALS.G_UI_FLAG := FALSE;
768:
769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
766:
767: OE_GLOBALS.G_UI_FLAG := FALSE;
768:
769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
770:
771: -- Get message count and data
772:
773: oe_msg_pub.count_and_get

Line 788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

784: , 'Lock_Row'
785: );
786: END IF;
787:
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789:
790: -- Get message count and data
791:
792: oe_msg_pub.count_and_get

Line 820: x_return_status := FND_API.G_RET_STS_SUCCESS;

816: l_old_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
817: l_index NUMBER; --3445778
818: BEGIN
819: OE_MSG_PUB.initialize;
820: x_return_status := FND_API.G_RET_STS_SUCCESS;
821:
822: OE_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
823: p_entity_code => OE_GLOBALS.G_ENTITY_LINE
824: ,p_entity_id => p_line_id

Line 867: x_return_status := FND_API.G_RET_STS_ERROR;

863: OE_MSG_PUB.Count_And_Get
864: ( p_count => x_msg_count
865: , p_data => x_msg_data
866: );
867: x_return_status := FND_API.G_RET_STS_ERROR;
868:
869: END Clear_Record;
870:
871: