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

Line 49: IF l_return_status = FND_API.G_RET_STS_SUCCESS

45: oe_debug_pub.add( 'Contract returns: x_return_status:' || l_return_status || ' x_qa_return_status:' || l_qa_return_status, 1);
46: END IF;
47:
48: -- If API call is successful, but the check failed, return incomplete
49: IF l_return_status = FND_API.G_RET_STS_SUCCESS
50: AND l_qa_return_status <> FND_API.G_RET_STS_SUCCESS
51: AND l_qa_return_status <> 'W' THEN
52: resultout := 'COMPLETE:INCOMPLETE';
53: OE_STANDARD_WF.Save_Messages;

Line 50: AND l_qa_return_status <> FND_API.G_RET_STS_SUCCESS

46: END IF;
47:
48: -- If API call is successful, but the check failed, return incomplete
49: IF l_return_status = FND_API.G_RET_STS_SUCCESS
50: AND l_qa_return_status <> FND_API.G_RET_STS_SUCCESS
51: AND l_qa_return_status <> 'W' THEN
52: resultout := 'COMPLETE:INCOMPLETE';
53: OE_STANDARD_WF.Save_Messages;
54: OE_STANDARD_WF.Clear_Msg_Context;

Line 56: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

52: resultout := 'COMPLETE:INCOMPLETE';
53: OE_STANDARD_WF.Save_Messages;
54: OE_STANDARD_WF.Clear_Msg_Context;
55: return;
56: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
57: -- API call failed completely, fail the activity
58: app_exception.raise_exception;
59: END IF;
60:

Line 72: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

68: p_flow_status_code => 'DRAFT_SUBMITTED',
69: p_draft_submitted_flag => 'Y',
70: x_return_status => l_return_status);
71:
72: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
73: resultout := 'COMPLETE:INCOMPLETE';
74: OE_STANDARD_WF.Save_Messages;
75: OE_STANDARD_WF.Clear_Msg_Context;
76: return;

Line 77: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

73: resultout := 'COMPLETE:INCOMPLETE';
74: OE_STANDARD_WF.Save_Messages;
75: OE_STANDARD_WF.Clear_Msg_Context;
76: return;
77: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
78: app_exception.raise_exception;
79: END IF;
80:
81: resultout := 'COMPLETE:COMPLETE';

Line 341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

337: OE_MSG_PUB.Add_Exc_Msg
338: (G_PKG_NAME
339: , 'Set_Blanket_Hdr_Descriptor'
340: );
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: END IF;
343: END Set_Blanket_Hdr_Descriptor;
344:
345:

Line 387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

383: OE_MSG_PUB.Add_Exc_Msg
384: (G_PKG_NAME
385: , 'Get_Expire_Date'
386: );
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: END IF;
389:
390: END Get_Expire_Date;
391:

Line 423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

419: p_item_key => itemkey,
420: p_flow_status_code => 'EXPIRED',
421: x_return_status => l_return_status);
422:
423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
426: RAISE FND_API.G_EXC_ERROR;
427: END IF;

Line 424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

420: p_flow_status_code => 'EXPIRED',
421: x_return_status => l_return_status);
422:
423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
426: RAISE FND_API.G_EXC_ERROR;
427: END IF;
428:

Line 425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

421: x_return_status => l_return_status);
422:
423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
426: RAISE FND_API.G_EXC_ERROR;
427: END IF;
428:
429: -- set WF header attributes, values may have been changed during the wait period

Line 426: RAISE FND_API.G_EXC_ERROR;

422:
423: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
426: RAISE FND_API.G_EXC_ERROR;
427: END IF;
428:
429: -- set WF header attributes, values may have been changed during the wait period
430: select bh.sold_to_org_id, bhx.end_date_active, bh.salesrep_id

Line 493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

489: p_item_key => itemkey,
490: p_flow_status_code => 'TERMINATED',
491: x_return_status => l_return_status);
492:
493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;

Line 494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

490: p_flow_status_code => 'TERMINATED',
491: x_return_status => l_return_status);
492:
493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498:

Line 495: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

491: x_return_status => l_return_status);
492:
493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498:
499: resultout := 'COMPLETE';

Line 496: RAISE FND_API.G_EXC_ERROR;

492:
493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498:
499: resultout := 'COMPLETE';
500:

Line 539: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

535: IF (funcmode = 'RUN') then
536: -- check for releases of blanket
537: l_blanket_number := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'TRANSACTION_NUMBER');
538: OE_BLANKET_WF_UTIL.Check_Release(p_blanket_number => l_blanket_number, x_return_status => l_return_status);
539: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
540: --Blanket release check failed, return incomplete
541: --UI will display the message
542: resultout := 'COMPLETE:INCOMPLETE';
543: OE_STANDARD_WF.Save_Messages;

Line 553: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

549: p_item_key => itemkey,
550: p_flow_status_code => 'CLOSED',--bug#5589336
551: p_open_flag => 'N',
552: x_return_status => l_return_status);
553: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
555: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
556: RAISE FND_API.G_EXC_ERROR;
557: END IF;

Line 554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

550: p_flow_status_code => 'CLOSED',--bug#5589336
551: p_open_flag => 'N',
552: x_return_status => l_return_status);
553: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
555: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
556: RAISE FND_API.G_EXC_ERROR;
557: END IF;
558: resultout := 'COMPLETE:COMPLETE';

Line 555: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

551: p_open_flag => 'N',
552: x_return_status => l_return_status);
553: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
555: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
556: RAISE FND_API.G_EXC_ERROR;
557: END IF;
558: resultout := 'COMPLETE:COMPLETE';
559:

Line 556: RAISE FND_API.G_EXC_ERROR;

552: x_return_status => l_return_status);
553: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
555: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
556: RAISE FND_API.G_EXC_ERROR;
557: END IF;
558: resultout := 'COMPLETE:COMPLETE';
559:
560: END IF;

Line 587: x_return_status := FND_API.G_RET_STS_SUCCESS;

583: l_transaction_phase_code VARCHAR2(30);
584: --
585: BEGIN
586: OE_MSG_PUB.initialize;
587: x_return_status := FND_API.G_RET_STS_SUCCESS;
588: IF l_debug_level > 0 THEN
589: oe_debug_pub.add('ENTERING OE_Blanket_WF.Blanket_Date_Changed: '|| TO_CHAR (p_header_id) ,1);
590: END IF;
591:

Line 618: x_return_status := FND_API.G_RET_STS_ERROR;

614: EXCEPTION
615: WHEN OTHERS THEN
616: fnd_message.set_name('ONT', 'OE_BKT_NO_DATE_CHANGE');
617: oe_msg_pub.add;
618: x_return_status := FND_API.G_RET_STS_ERROR;
619: IF l_debug_level > 0 THEN
620: oe_debug_pub.add('EXITING OE_Blanket_WF.Blanket_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);
621: END IF;
622: return;

Line 638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

634: END IF;
635:
636: EXCEPTION
637: WHEN OTHERS THEN
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
639: IF l_debug_level > 0 THEN
640: oe_debug_pub.add('EXITING OE_Blanket_WF.Blanket_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);
641: END IF;
642: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 665: x_return_status := FND_API.G_RET_STS_SUCCESS;

661: l_sales_document_type VARCHAR2(30);
662: --
663: BEGIN
664: -- OE_MSG_PUB.initialize; commented out due to 4671489
665: x_return_status := FND_API.G_RET_STS_SUCCESS;
666: IF l_debug_level > 0 THEN
667: oe_debug_pub.add('ENTERING OE_Blanket_WF.Submit_Draft: '|| TO_CHAR (p_header_id) ,1);
668: END IF;
669: BEGIN

Line 687: x_return_status := FND_API.G_RET_STS_ERROR;

683: fnd_message.set_name('ONT', 'OE_WF_NO_SUBMIT_DRAFT');
684: -- FND message activity name should match WF activity name for Submit Draft in blanket
685: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
686: oe_msg_pub.add;
687: x_return_status := FND_API.G_RET_STS_ERROR;
688: IF l_debug_level > 0 THEN
689: oe_debug_pub.add('EXITING OE_Blanket_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);
690: END IF;
691: return;

Line 703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

699: END IF;
700:
701: EXCEPTION
702: WHEN OTHERS THEN
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
704: IF l_debug_level > 0 THEN
705: oe_debug_pub.add('EXITING OE_Blanket_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);
706: END IF;
707: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 729: x_return_status := FND_API.G_RET_STS_SUCCESS;

725: l_sales_document_type VARCHAR2(30);
726: --
727: BEGIN
728: OE_MSG_PUB.initialize;
729: x_return_status := FND_API.G_RET_STS_SUCCESS;
730: IF l_debug_level > 0 THEN
731: oe_debug_pub.add('ENTERING OE_Blanket_WF.Close: '|| TO_CHAR (p_header_id) ,1);
732: END IF;
733: BEGIN

Line 747: x_return_status := FND_API.G_RET_STS_ERROR;

743: EXCEPTION
744: WHEN OTHERS THEN
745: fnd_message.set_name('ONT', 'OE_BKT_NO_CLOSE');
746: oe_msg_pub.add;
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: IF l_debug_level > 0 THEN
749: oe_debug_pub.add('EXITING OE_Blanket_WF.Close WITH STATUS: '||X_RETURN_STATUS ,1);
750: END IF;
751: return;

Line 764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

760: END IF;
761:
762: EXCEPTION
763: WHEN OTHERS THEN
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
765: IF l_debug_level > 0 THEN
766: oe_debug_pub.add('EXITING OE_Blanket_WF.Close WITH STATUS: '||X_RETURN_STATUS ,1);
767: END IF;
768: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 806: x_return_status := FND_API.G_RET_STS_SUCCESS;

802: l_reason_id NUMBER;
803: --
804: BEGIN
805: OE_MSG_PUB.initialize;
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807: IF l_debug_level > 0 THEN
808: oe_debug_pub.add('ENTERING OE_Blanket_WF.Terminate: '|| TO_CHAR (p_header_id) ,1);
809: END IF;
810: BEGIN

Line 824: x_return_status := FND_API.G_RET_STS_ERROR;

820: EXCEPTION
821: WHEN OTHERS THEN
822: fnd_message.set_name('ONT', 'OE_BKT_NO_TERMINATE');
823: oe_msg_pub.add;
824: x_return_status := FND_API.G_RET_STS_ERROR;
825: IF l_debug_level > 0 THEN
826: oe_debug_pub.add('EXITING OE_Blanket_WF.Terminate WITH STATUS: '||X_RETURN_STATUS ,1);
827: END IF;
828: return;

Line 885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

881: END IF;
882:
883: EXCEPTION
884: WHEN OTHERS THEN
885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
886: IF l_debug_level > 0 THEN
887: oe_debug_pub.add('EXITING OE_Blanket_WF.Terminate WITH STATUS: '||X_RETURN_STATUS ,1);
888: END IF;
889: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 909: x_return_status := FND_API.G_RET_STS_SUCCESS;

905: l_activity_name VARCHAR2(30);
906: --
907: BEGIN
908: OE_MSG_PUB.initialize;
909: x_return_status := FND_API.G_RET_STS_SUCCESS;
910: IF l_debug_level > 0 THEN
911: oe_debug_pub.add('ENTERING OE_Blanket_WF.Extend: '|| TO_CHAR (p_header_id) ,1);
912: END IF;
913: BEGIN

Line 927: x_return_status := FND_API.G_RET_STS_ERROR;

923: EXCEPTION
924: WHEN OTHERS THEN
925: fnd_message.set_name('ONT', 'OE_BKT_NO_EXTEND');
926: oe_msg_pub.add;
927: x_return_status := FND_API.G_RET_STS_ERROR;
928: IF l_debug_level > 0 THEN
929: oe_debug_pub.add('EXITING OE_Blanket_WF.Extend WITH STATUS: '||X_RETURN_STATUS ,1);
930: END IF;
931: return;

Line 943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

939: END IF;
940:
941: EXCEPTION
942: WHEN OTHERS THEN
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
944: IF l_debug_level > 0 THEN
945: oe_debug_pub.add('EXITING OE_Blanket_WF.Extend WITH STATUS: '||X_RETURN_STATUS ,1);
946: END IF;
947: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1000: OE_MSG_PUB.Add_Exc_Msg
1001: ( G_PKG_NAME,
1002: 'Set_Header_Attributes_Internal'
1003: );
1004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1005: END IF;
1006:
1007: END Set_Header_Attributes_Internal;
1008: