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

Line 82: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

78: (p_line_id => to_number(itemkey),
79: p_x_line_rec => l_line_rec,
80: x_return_status => l_return_status);
81:
82: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
83: IF l_debug_level > 0 THEN
84: oe_debug_pub.add( 'LOCK ROW RETURNED WITH ERROR' , 1 ) ;
85: END IF;
86: resultout := 'COMPLETE:INCOMPLETE';

Line 141: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

137: -- If error is generated by the Insert Procedure then we need to
138: -- capture the that error and do not allow the Workflow to process
139: -- further.
140: --
141: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
142: IF l_result_out = OE_GLOBALS.G_WFR_COMPLETE THEN
143: resultout := 'NOTIFIED';
144: OE_STANDARD_WF.Save_Messages;
145: OE_STANDARD_WF.Clear_Msg_Context;

Line 148: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

144: OE_STANDARD_WF.Save_Messages;
145: OE_STANDARD_WF.Clear_Msg_Context;
146: RETURN;
147: END IF;
148: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
149: resultout := 'COMPLETE:INCOMPLETE';
150: OE_STANDARD_WF.Save_Messages;
151: OE_STANDARD_WF.Clear_Msg_Context;
152: RETURN;

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

150: OE_STANDARD_WF.Save_Messages;
151: OE_STANDARD_WF.Clear_Msg_Context;
152: RETURN;
153: ELSE
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:
157: RETURN;
158:

Line 332: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

328: Oe_debug_pub.add('request_set_id : ' || l_request_set_id);
329: Oe_debug_pub.add('process_flag : ' || l_process_flag);
330: Oe_debug_pub.add('return status : ' || l_return_status);
331:
332: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
333: Oe_debug_pub.add('get_compliance_status API returned error.!');
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336:

Line 334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

330: Oe_debug_pub.add('return status : ' || l_return_status);
331:
332: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
333: Oe_debug_pub.add('get_compliance_status API returned error.!');
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336:
337: -- This select statement is used to lock the Top Model Line.
338: -- After the Top Model Line is Locked we go ahead the Lock the

Line 420: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

416: ROLLBACK TO UPDATE_API;
417:
418: resultout := 'COMPLETE:INCOMPLETE';
419:
420: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: RETURN;
422: END; --bug 4503620 ends
423:
424: -- Check whether the Line is cancelled

Line 466: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

462: x_return_status => l_return_status
463: );
464:
465:
466: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
467: OE_STANDARD_WF.Save_Messages;
468: OE_STANDARD_WF.Clear_Msg_Context;
469: APP_EXCEPTION.Raise_Exception;
470: END IF;

Line 609: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

605: p_flow_status_code => 'EXPORT_SCREENING_DATA_ERROR',
606: x_return_status => l_return_status
607: );
608:
609: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
610: resultout := 'COMPLETE:INCOMPLETE';
611: OE_STANDARD_WF.Save_Messages;
612: OE_STANDARD_WF.Clear_Msg_Context;
613: APP_EXCEPTION.Raise_Exception;

Line 636: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

632: l_hold_source_rec.line_id := l_line_rec.line_id;
633:
634: OE_HOLDS_PUB.Apply_Holds
635: ( p_api_version => 1.0
636: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
637: , p_hold_source_rec => l_hold_source_rec
638: , x_return_status => l_return_status
639: , x_msg_count => l_msg_count
640: , x_msg_data => l_msg_data

Line 643: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

639: , x_msg_count => l_msg_count
640: , x_msg_data => l_msg_data
641: );
642:
643: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
644: RAISE FND_API.G_EXC_ERROR;
645: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
647: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 644: RAISE FND_API.G_EXC_ERROR;

640: , x_msg_data => l_msg_data
641: );
642:
643: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
644: RAISE FND_API.G_EXC_ERROR;
645: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
647: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
648: IF l_debug_level > 0 THEN

Line 645: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

641: );
642:
643: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
644: RAISE FND_API.G_EXC_ERROR;
645: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
647: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
648: IF l_debug_level > 0 THEN
649: oe_debug_pub.add('Applied Generic hold on line:' || l_line_rec.line_id, 1);

Line 646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

642:
643: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
644: RAISE FND_API.G_EXC_ERROR;
645: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
647: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
648: IF l_debug_level > 0 THEN
649: oe_debug_pub.add('Applied Generic hold on line:' || l_line_rec.line_id, 1);
650: END IF;

Line 647: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

643: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
644: RAISE FND_API.G_EXC_ERROR;
645: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
647: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
648: IF l_debug_level > 0 THEN
649: oe_debug_pub.add('Applied Generic hold on line:' || l_line_rec.line_id, 1);
650: END IF;
651: END IF;

Line 659: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

655: p_flow_status_code => 'EXPORT_SCREENING_COMPLETED',
656: x_return_status => l_return_status
657: );
658:
659: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
660: resultout := 'COMPLETE:INCOMPLETE';
661: OE_STANDARD_WF.Save_Messages;
662: OE_STANDARD_WF.Clear_Msg_Context;
663: APP_EXCEPTION.Raise_Exception;

Line 685: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

681: l_hold_source_rec.line_id := l_line_rec.line_id;
682:
683: OE_HOLDS_PUB.Apply_Holds
684: ( p_api_version => 1.0
685: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
686: , p_hold_source_rec => l_hold_source_rec
687: , x_return_status => l_return_status
688: , x_msg_count => l_msg_count
689: , x_msg_data => l_msg_data

Line 692: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

688: , x_msg_count => l_msg_count
689: , x_msg_data => l_msg_data
690: );
691:
692: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
693: RAISE FND_API.G_EXC_ERROR;
694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 693: RAISE FND_API.G_EXC_ERROR;

689: , x_msg_data => l_msg_data
690: );
691:
692: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
693: RAISE FND_API.G_EXC_ERROR;
694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
697: IF l_debug_level > 0 THEN

Line 694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

690: );
691:
692: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
693: RAISE FND_API.G_EXC_ERROR;
694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
697: IF l_debug_level > 0 THEN
698: oe_debug_pub.add('Applied denied party hold on line:' || l_line_rec.line_id, 1);

Line 695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

691:
692: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
693: RAISE FND_API.G_EXC_ERROR;
694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
697: IF l_debug_level > 0 THEN
698: oe_debug_pub.add('Applied denied party hold on line:' || l_line_rec.line_id, 1);
699: END IF;

Line 696: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

692: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
693: RAISE FND_API.G_EXC_ERROR;
694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
697: IF l_debug_level > 0 THEN
698: oe_debug_pub.add('Applied denied party hold on line:' || l_line_rec.line_id, 1);
699: END IF;
700: END IF;

Line 708: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

704: p_flow_status_code => 'EXPORT_SCREENING_COMPLETED',
705: x_return_status => l_return_status
706: );
707:
708: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
709: resultout := 'COMPLETE:INCOMPLETE';
710: OE_STANDARD_WF.Save_Messages;
711: OE_STANDARD_WF.Clear_Msg_Context;
712: APP_EXCEPTION.Raise_Exception;

Line 727: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

723: p_flow_status_code => 'EXPORT_SCREENING_COMPLETED',
724: x_return_status => l_return_status
725: );
726:
727: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
728: resultout := 'COMPLETE:INCOMPLETE';
729: OE_STANDARD_WF.Save_Messages;
730: OE_STANDARD_WF.Clear_Msg_Context;
731: APP_EXCEPTION.Raise_Exception;