DBA Data[Home] [Help]

APPS.OE_NEGOTIATE_WF dependencies on FND_API

Line 35: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

31: p_flow_status_code => 'LOST',
32: p_open_flag => 'N',
33: x_return_status => l_return_status);
34:
35: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
36: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
37: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
38: RAISE FND_API.G_EXC_ERROR;
39: END IF;

Line 36: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

32: p_open_flag => 'N',
33: x_return_status => l_return_status);
34:
35: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
36: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
37: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
38: RAISE FND_API.G_EXC_ERROR;
39: END IF;
40:

Line 37: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

33: x_return_status => l_return_status);
34:
35: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
36: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
37: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
38: RAISE FND_API.G_EXC_ERROR;
39: END IF;
40:
41: resultout := 'COMPLETE';

Line 38: RAISE FND_API.G_EXC_ERROR;

34:
35: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
36: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
37: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
38: RAISE FND_API.G_EXC_ERROR;
39: END IF;
40:
41: resultout := 'COMPLETE';
42:

Line 97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

93: -- Blanket Complete_Negotiation
94: OE_BLANKET_WF_UTIL.Complete_Negotiation(p_header_id => to_number(itemkey),
95: x_return_status => l_return_status);
96: ELSE
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
100: resultout := 'COMPLETE:COMPLETE';
101: ELSE

Line 99: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

95: x_return_status => l_return_status);
96: ELSE
97: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
98: END IF;
99: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
100: resultout := 'COMPLETE:COMPLETE';
101: ELSE
102: resultout := 'COMPLETE:INCOMPLETE';
103: oe_standard_wf.save_messages;

Line 177: IF l_return_status = FND_API.G_RET_STS_SUCCESS

173: oe_debug_pub.add( 'Contract returns: x_return_status:' || l_return_status || ' x_qa_return_status:' || l_qa_return_status, 1);
174: END IF;
175: -- If API call is successful, but the check failed, return incomplete
176:
177: IF l_return_status = FND_API.G_RET_STS_SUCCESS
178: AND l_qa_return_status <> FND_API.G_RET_STS_SUCCESS
179: AND l_qa_return_status <> 'W' THEN
180: resultout := 'COMPLETE:INCOMPLETE';
181: OE_STANDARD_WF.Save_Messages;

Line 178: AND l_qa_return_status <> FND_API.G_RET_STS_SUCCESS

174: END IF;
175: -- If API call is successful, but the check failed, return incomplete
176:
177: IF l_return_status = FND_API.G_RET_STS_SUCCESS
178: AND l_qa_return_status <> FND_API.G_RET_STS_SUCCESS
179: AND l_qa_return_status <> 'W' THEN
180: resultout := 'COMPLETE:INCOMPLETE';
181: OE_STANDARD_WF.Save_Messages;
182: OE_STANDARD_WF.Clear_Msg_Context;

Line 184: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

180: resultout := 'COMPLETE:INCOMPLETE';
181: OE_STANDARD_WF.Save_Messages;
182: OE_STANDARD_WF.Clear_Msg_Context;
183: return;
184: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
185: -- API call failed completely, fail the activity
186: app_exception.raise_exception;
187: END IF;
188:

Line 230: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

226: IF l_debug_level > 0 THEN
227: oe_debug_pub.add( 'RETURN STATUS AFTER VALIDATE CFGS:'||L_RETURN_STATUS );
228: END IF;
229:
230: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
231: resultout := 'COMPLETE:INCOMPLETE';
232: OE_STANDARD_WF.Save_Messages;
233: OE_STANDARD_WF.Clear_Msg_Context;
234: return;

Line 235: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

231: resultout := 'COMPLETE:INCOMPLETE';
232: OE_STANDARD_WF.Save_Messages;
233: OE_STANDARD_WF.Clear_Msg_Context;
234: return;
235: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
236: app_exception.raise_exception;
237: END IF;
238:
239: END IF;

Line 252: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

248: IF l_debug_level > 0 THEN
249: oe_debug_pub.add('Submit_Draft_Internal: Finish calling Update Draft Submitted status: ' || l_return_status, 1);
250: END IF;
251:
252: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
253: resultout := 'COMPLETE:INCOMPLETE';
254: OE_STANDARD_WF.Save_Messages;
255: OE_STANDARD_WF.Clear_Msg_Context;
256: return;

Line 257: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

253: resultout := 'COMPLETE:INCOMPLETE';
254: OE_STANDARD_WF.Save_Messages;
255: OE_STANDARD_WF.Clear_Msg_Context;
256: return;
257: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
258: app_exception.raise_exception;
259: END IF;
260:
261: resultout := 'COMPLETE:COMPLETE';

Line 312: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

308: p_item_key => itemkey,
309: p_flow_status_code => 'PENDING_CUSTOMER_ACCEPTANCE',
310: x_return_status => l_return_status);
311:
312: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;

Line 313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

309: p_flow_status_code => 'PENDING_CUSTOMER_ACCEPTANCE',
310: x_return_status => l_return_status);
311:
312: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;
317:

Line 314: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

310: x_return_status => l_return_status);
311:
312: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;
317:
318: resultout := 'NOTIFIED:#NULL';

Line 315: RAISE FND_API.G_EXC_ERROR;

311:
312: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
315: RAISE FND_API.G_EXC_ERROR;
316: END IF;
317:
318: resultout := 'NOTIFIED:#NULL';
319:

Line 364: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

360: p_item_key => itemkey,
361: p_flow_status_code => 'CUSTOMER_ACCEPTED',
362: x_return_status => l_return_status);
363:
364: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;

Line 365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

361: p_flow_status_code => 'CUSTOMER_ACCEPTED',
362: x_return_status => l_return_status);
363:
364: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369:

Line 366: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

362: x_return_status => l_return_status);
363:
364: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369:
370:

Line 367: RAISE FND_API.G_EXC_ERROR;

363:
364: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369:
370:
371: resultout := 'COMPLETE';

Line 419: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

415: p_flow_status_code => 'DRAFT_CUSTOMER_REJECTED',
416: p_draft_submitted_flag => 'N',
417: x_return_status => l_return_status);
418:
419: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;

Line 420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

416: p_draft_submitted_flag => 'N',
417: x_return_status => l_return_status);
418:
419: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424:

Line 421: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

417: x_return_status => l_return_status);
418:
419: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424:
425: resultout := 'COMPLETE';

Line 422: RAISE FND_API.G_EXC_ERROR;

418:
419: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424:
425: resultout := 'COMPLETE';
426:

Line 617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

613: p_flow_status_code => 'OFFER_EXPIRED',
614: p_open_flag => 'N',
615: x_return_status => l_return_status);
616:
617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
619: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
620: RAISE FND_API.G_EXC_ERROR;
621: END IF;

Line 618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

614: p_open_flag => 'N',
615: x_return_status => l_return_status);
616:
617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
619: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
620: RAISE FND_API.G_EXC_ERROR;
621: END IF;
622:

Line 619: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

615: x_return_status => l_return_status);
616:
617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
619: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
620: RAISE FND_API.G_EXC_ERROR;
621: END IF;
622:
623: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'SALES_DOCUMENT_TYPE_CODE');

Line 620: RAISE FND_API.G_EXC_ERROR;

616:
617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
619: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
620: RAISE FND_API.G_EXC_ERROR;
621: END IF;
622:
623: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'SALES_DOCUMENT_TYPE_CODE');
624: IF l_sales_document_type_code = 'O' THEN

Line 736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; -- unrecognized code

732:
733: document := substrb(l_transaction_type_txt || ', ' || l_header_txt, 1, 240);
734:
735: ELSE
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; -- unrecognized code
737: END IF;
738:
739: EXCEPTION
740: WHEN OTHERS THEN

Line 747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

743: OE_MSG_PUB.Add_Exc_Msg
744: (G_PKG_NAME
745: , 'Set_Negotiate_Hdr_Descriptor'
746: );
747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
748: END IF;
749:
750: END Set_Negotiate_Hdr_Descriptor;
751:

Line 772: x_return_status := FND_API.G_RET_STS_SUCCESS;

768:
769: --
770: BEGIN
771: OE_MSG_PUB.initialize;
772: x_return_status := FND_API.G_RET_STS_SUCCESS;
773: IF l_debug_level > 0 THEN
774: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Lost: '|| TO_CHAR (p_header_id) ,1) ;
775: END IF;
776: OE_MSG_PUB.set_msg_context(

Line 804: x_return_status := FND_API.G_RET_STS_ERROR;

800:
801: fnd_message.set_name('ONT', 'OE_WF_NO_LOST'); --flow not at notified state
802: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
803: oe_msg_pub.add;
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: IF l_debug_level > 0 THEN
806: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost WITH STATUS: '||X_RETURN_STATUS ,1);
807: END IF;
808: return;

Line 829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

825: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost normally', 1);
826: END IF;
827: EXCEPTION
828: WHEN OTHERS THEN
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
830: IF l_debug_level > 0 THEN
831: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost WITH STATUS: '||X_RETURN_STATUS ,1);
832: END IF;
833: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 862: x_return_status := FND_API.G_RET_STS_SUCCESS;

858: --
859: l_customer_acceptance VARCHAR2(30) := 'CUSTOMER_ACCEPTANCE';
860: BEGIN
861: OE_MSG_PUB.initialize;
862: x_return_status := FND_API.G_RET_STS_SUCCESS;
863: IF l_debug_level > 0 THEN
864: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Customer_Accepted: '|| TO_CHAR (p_header_id) ,1) ;
865: END IF;
866:

Line 889: raise FND_API.G_EXC_ERROR;

885: where header_id = p_header_id;
886:
887: IF l_so_count > 0 THEN
888: l_sales_document_type_code := 'O';
889: raise FND_API.G_EXC_ERROR;
890: ELSE
891: select count(1)
892: into l_bsa_count
893: from oe_blanket_headers_all

Line 898: raise FND_API.G_EXC_ERROR;

894: where header_id = p_header_id;
895:
896: IF l_bsa_count > 0 THEN
897: l_sales_document_type_code := 'B';
898: raise FND_API.G_EXC_ERROR;
899: END IF;
900: END IF;
901: END IF;
902: -- END Bug3435165

Line 926: x_return_status := FND_API.G_RET_STS_ERROR;

922:
923: fnd_message.set_name('ONT', 'OE_WF_NO_CUST_ACCEPTED'); --flow not at right state
924: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
925: oe_msg_pub.add;
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: IF l_debug_level > 0 THEN
928: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted WITH STATUS: '||X_RETURN_STATUS ,1);
929: END IF;
930: return;

Line 963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

959: END IF;
960: EXCEPTION
961:
962: WHEN OTHERS THEN
963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
964: IF l_debug_level > 0 THEN
965: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted WITH STATUS: '||X_RETURN_STATUS ,1);
966: END IF;
967: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1000: x_return_status := FND_API.G_RET_STS_SUCCESS;

996: l_customer_acceptance VARCHAR2(30) := 'CUSTOMER_ACCEPTANCE';
997: --
998: BEGIN
999: OE_MSG_PUB.initialize;
1000: x_return_status := FND_API.G_RET_STS_SUCCESS;
1001: IF l_debug_level > 0 THEN
1002: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Customer_Rejected: '|| TO_CHAR (p_header_id) ,1) ;
1003: END IF;
1004: OE_MSG_PUB.set_msg_context(

Line 1032: x_return_status := FND_API.G_RET_STS_ERROR;

1028:
1029: fnd_message.set_name('ONT', 'OE_WF_NO_CUST_REJECTED'); --flow not at right state
1030: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
1031: oe_msg_pub.add;
1032: x_return_status := FND_API.G_RET_STS_ERROR;
1033: IF l_debug_level > 0 THEN
1034: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected WITH STATUS: '||X_RETURN_STATUS ,1);
1035: END IF;
1036: return;

Line 1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1052: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected normally', 1);
1053: END IF;
1054: EXCEPTION
1055: WHEN OTHERS THEN
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1057: IF l_debug_level > 0 THEN
1058: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected WITH STATUS: '||X_RETURN_STATUS ,1);
1059: END IF;
1060: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1083: x_return_status := FND_API.G_RET_STS_SUCCESS;

1079: l_sales_document_type VARCHAR2(30);
1080: --
1081: BEGIN
1082: OE_MSG_PUB.initialize;
1083: x_return_status := FND_API.G_RET_STS_SUCCESS;
1084: IF l_debug_level > 0 THEN
1085: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Offer_Date_Changed: '|| TO_CHAR (p_header_id) ,1) ;
1086: END IF;
1087: OE_MSG_PUB.set_msg_context(

Line 1114: x_return_status := FND_API.G_RET_STS_ERROR;

1110: l_sales_document_type := fnd_message.get;
1111: fnd_message.set_name('ONT', 'OE_WF_NO_OFFER_DATE_CHANGE'); --flow not at right state
1112: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
1113: oe_msg_pub.add;
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: IF l_debug_level > 0 THEN
1116: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);
1117: END IF;
1118: return;

Line 1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1126: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed normally', 1);
1127: END IF;
1128: EXCEPTION
1129: WHEN OTHERS THEN
1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1131: IF l_debug_level > 0 THEN
1132: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);
1133: END IF;
1134: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1163: x_return_status := FND_API.G_RET_STS_SUCCESS;

1159:
1160: --
1161: BEGIN
1162: -- OE_MSG_PUB.initialize; commented out for 4671489
1163: x_return_status := FND_API.G_RET_STS_SUCCESS;
1164: IF l_debug_level > 0 THEN
1165: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Submit_Draft: '|| TO_CHAR (p_header_id) ,1) ;
1166: END IF;
1167:

Line 1186: raise FND_API.G_EXC_ERROR;

1182: where header_id = p_header_id;
1183:
1184: IF l_so_count > 0 THEN
1185: l_sales_document_type_code := 'O';
1186: raise FND_API.G_EXC_ERROR;
1187: ELSE --should never come here, given how BSA is coded now
1188: select count(1)
1189: into l_bsa_count
1190: from oe_blanket_headers_all

Line 1195: raise FND_API.G_EXC_ERROR;

1191: where header_id = p_header_id;
1192:
1193: IF l_bsa_count > 0 THEN
1194: l_sales_document_type_code := 'B';
1195: raise FND_API.G_EXC_ERROR;
1196: END IF;
1197: END IF;
1198: END IF;
1199: -- END Bug3435165

Line 1242: x_return_status := FND_API.G_RET_STS_ERROR;

1238:
1239: fnd_message.set_name('ONT', 'OE_WF_NO_SUBMIT_DRAFT'); --flow not at right state
1240: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
1241: oe_msg_pub.add;
1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: IF l_debug_level > 0 THEN
1244: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);
1245: END IF;
1246: return;

Line 1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1254: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft normally', 1);
1255: END IF;
1256: EXCEPTION
1257: WHEN OTHERS THEN
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1259: IF l_debug_level > 0 THEN
1260: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);
1261: END IF;
1262: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1326: OE_MSG_PUB.Add_Exc_Msg
1327: (G_PKG_NAME
1328: , 'Set_Header_Attributes_Internal'
1329: );
1330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1331: END IF;
1332:
1333: END Set_Header_Attributes_Internal;
1334: