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 793: RAISE fnd_api.g_exc_unexpected_error; -- unrecognized code

789: l_header_txt := fnd_message.get;
790: document :=
791: SUBSTRB (l_transaction_type_txt || ', ' || l_header_txt, 1, 240);
792: ELSE
793: RAISE fnd_api.g_exc_unexpected_error; -- unrecognized code
794: END IF;
795: EXCEPTION
796: WHEN OTHERS
797: THEN

Line 803: RAISE fnd_api.g_exc_unexpected_error;

799: THEN
800: oe_msg_pub.add_exc_msg (g_pkg_name,
801: 'Set_Negotiate_Hdr_Descriptor'
802: );
803: RAISE fnd_api.g_exc_unexpected_error;
804: END IF;
805: END set_negotiate_hdr_descriptor;
806:
807:

Line 827: x_return_status := FND_API.G_RET_STS_SUCCESS;

823:
824: --
825: BEGIN
826: OE_MSG_PUB.initialize;
827: x_return_status := FND_API.G_RET_STS_SUCCESS;
828: IF l_debug_level > 0 THEN
829: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Lost: '|| TO_CHAR (p_header_id) ,1) ;
830: END IF;
831: OE_MSG_PUB.set_msg_context(

Line 859: x_return_status := FND_API.G_RET_STS_ERROR;

855:
856: fnd_message.set_name('ONT', 'OE_WF_NO_LOST'); --flow not at notified state
857: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
858: oe_msg_pub.add;
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: IF l_debug_level > 0 THEN
861: oe_debug_pub.add('EXITING OE_Negotiate_WF.Lost WITH STATUS: '||X_RETURN_STATUS ,1);
862: END IF;
863: return;

Line 884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 917: x_return_status := FND_API.G_RET_STS_SUCCESS;

913: --
914: l_customer_acceptance VARCHAR2(30) := 'CUSTOMER_ACCEPTANCE';
915: BEGIN
916: OE_MSG_PUB.initialize;
917: x_return_status := FND_API.G_RET_STS_SUCCESS;
918: IF l_debug_level > 0 THEN
919: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Customer_Accepted: '|| TO_CHAR (p_header_id) ,1) ;
920: END IF;
921:

Line 944: raise FND_API.G_EXC_ERROR;

940: where header_id = p_header_id;
941:
942: IF l_so_count > 0 THEN
943: l_sales_document_type_code := 'O';
944: raise FND_API.G_EXC_ERROR;
945: ELSE
946: select count(1)
947: into l_bsa_count
948: from oe_blanket_headers_all

Line 953: raise FND_API.G_EXC_ERROR;

949: where header_id = p_header_id;
950:
951: IF l_bsa_count > 0 THEN
952: l_sales_document_type_code := 'B';
953: raise FND_API.G_EXC_ERROR;
954: END IF;
955: END IF;
956: END IF;
957: -- END Bug3435165

Line 981: x_return_status := FND_API.G_RET_STS_ERROR;

977:
978: fnd_message.set_name('ONT', 'OE_WF_NO_CUST_ACCEPTED'); --flow not at right state
979: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
980: oe_msg_pub.add;
981: x_return_status := FND_API.G_RET_STS_ERROR;
982: IF l_debug_level > 0 THEN
983: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted WITH STATUS: '||X_RETURN_STATUS ,1);
984: END IF;
985: return;

Line 1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1014: END IF;
1015: EXCEPTION
1016:
1017: WHEN OTHERS THEN
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1019: IF l_debug_level > 0 THEN
1020: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Accepted WITH STATUS: '||X_RETURN_STATUS ,1);
1021: END IF;
1022: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1055: x_return_status := FND_API.G_RET_STS_SUCCESS;

1051: l_customer_acceptance VARCHAR2(30) := 'CUSTOMER_ACCEPTANCE';
1052: --
1053: BEGIN
1054: OE_MSG_PUB.initialize;
1055: x_return_status := FND_API.G_RET_STS_SUCCESS;
1056: IF l_debug_level > 0 THEN
1057: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Customer_Rejected: '|| TO_CHAR (p_header_id) ,1) ;
1058: END IF;
1059: OE_MSG_PUB.set_msg_context(

Line 1087: x_return_status := FND_API.G_RET_STS_ERROR;

1083:
1084: fnd_message.set_name('ONT', 'OE_WF_NO_CUST_REJECTED'); --flow not at right state
1085: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
1086: oe_msg_pub.add;
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: IF l_debug_level > 0 THEN
1089: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected WITH STATUS: '||X_RETURN_STATUS ,1);
1090: END IF;
1091: return;

Line 1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1107: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected normally', 1);
1108: END IF;
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1112: IF l_debug_level > 0 THEN
1113: oe_debug_pub.add('EXITING OE_Negotiate_WF.Customer_Rejected WITH STATUS: '||X_RETURN_STATUS ,1);
1114: END IF;
1115: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1138: x_return_status := FND_API.G_RET_STS_SUCCESS;

1134: l_sales_document_type VARCHAR2(30);
1135: --
1136: BEGIN
1137: OE_MSG_PUB.initialize;
1138: x_return_status := FND_API.G_RET_STS_SUCCESS;
1139: IF l_debug_level > 0 THEN
1140: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Offer_Date_Changed: '|| TO_CHAR (p_header_id) ,1) ;
1141: END IF;
1142: OE_MSG_PUB.set_msg_context(

Line 1169: x_return_status := FND_API.G_RET_STS_ERROR;

1165: l_sales_document_type := fnd_message.get;
1166: fnd_message.set_name('ONT', 'OE_WF_NO_OFFER_DATE_CHANGE'); --flow not at right state
1167: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
1168: oe_msg_pub.add;
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: IF l_debug_level > 0 THEN
1171: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);
1172: END IF;
1173: return;

Line 1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1181: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed normally', 1);
1182: END IF;
1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add('EXITING OE_Negotiate_WF.Offer_Date_Changed WITH STATUS: '||X_RETURN_STATUS ,1);
1188: END IF;
1189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1218: x_return_status := FND_API.G_RET_STS_SUCCESS;

1214:
1215: --
1216: BEGIN
1217: -- OE_MSG_PUB.initialize; commented out for 4671489
1218: x_return_status := FND_API.G_RET_STS_SUCCESS;
1219: IF l_debug_level > 0 THEN
1220: oe_debug_pub.add('ENTERING OE_Negotiate_WF.Submit_Draft: '|| TO_CHAR (p_header_id) ,1) ;
1221: END IF;
1222:

Line 1241: raise FND_API.G_EXC_ERROR;

1237: where header_id = p_header_id;
1238:
1239: IF l_so_count > 0 THEN
1240: l_sales_document_type_code := 'O';
1241: raise FND_API.G_EXC_ERROR;
1242: ELSE --should never come here, given how BSA is coded now
1243: select count(1)
1244: into l_bsa_count
1245: from oe_blanket_headers_all

Line 1250: raise FND_API.G_EXC_ERROR;

1246: where header_id = p_header_id;
1247:
1248: IF l_bsa_count > 0 THEN
1249: l_sales_document_type_code := 'B';
1250: raise FND_API.G_EXC_ERROR;
1251: END IF;
1252: END IF;
1253: END IF;
1254: -- END Bug3435165

Line 1297: x_return_status := FND_API.G_RET_STS_ERROR;

1293:
1294: fnd_message.set_name('ONT', 'OE_WF_NO_SUBMIT_DRAFT'); --flow not at right state
1295: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);
1296: oe_msg_pub.add;
1297: x_return_status := FND_API.G_RET_STS_ERROR;
1298: IF l_debug_level > 0 THEN
1299: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);
1300: END IF;
1301: return;

Line 1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1309: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft normally', 1);
1310: END IF;
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1314: IF l_debug_level > 0 THEN
1315: oe_debug_pub.add('EXITING OE_Negotiate_WF.Submit_Draft WITH STATUS: '||X_RETURN_STATUS ,1);
1316: END IF;
1317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1382: OE_MSG_PUB.Add_Exc_Msg
1383: (G_PKG_NAME
1384: , 'Set_Header_Attributes_Internal'
1385: );
1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1387: END IF;
1388:
1389: END Set_Header_Attributes_Internal;
1390: