199: END IF;
200:
201: IF nvl(l_ordered_quantity, 0) = 0 THEN
202: IF l_sales_document_type_code = 'O' THEN
203: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
204: ELSE -- assume blanket
205: fnd_message.set_name('ONT', 'OE_NTF_BSA');
206: END IF;
207: l_sales_document_type := fnd_message.get;
201: IF nvl(l_ordered_quantity, 0) = 0 THEN
202: IF l_sales_document_type_code = 'O' THEN
203: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
204: ELSE -- assume blanket
205: fnd_message.set_name('ONT', 'OE_NTF_BSA');
206: END IF;
207: l_sales_document_type := fnd_message.get;
208:
209: FND_MESSAGE.SET_NAME('ONT', 'OE_ZERO_QUANTITY');
203: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
204: ELSE -- assume blanket
205: fnd_message.set_name('ONT', 'OE_NTF_BSA');
206: END IF;
207: l_sales_document_type := fnd_message.get;
208:
209: FND_MESSAGE.SET_NAME('ONT', 'OE_ZERO_QUANTITY');
210: FND_MESSAGE.SET_TOKEN('SALES_DOCUMENT_TYPE', l_sales_document_type);
211: oe_msg_pub.add;
205: fnd_message.set_name('ONT', 'OE_NTF_BSA');
206: END IF;
207: l_sales_document_type := fnd_message.get;
208:
209: FND_MESSAGE.SET_NAME('ONT', 'OE_ZERO_QUANTITY');
210: FND_MESSAGE.SET_TOKEN('SALES_DOCUMENT_TYPE', l_sales_document_type);
211: oe_msg_pub.add;
212: resultout := 'COMPLETE:INCOMPLETE';
213: OE_STANDARD_WF.Save_Messages;
206: END IF;
207: l_sales_document_type := fnd_message.get;
208:
209: FND_MESSAGE.SET_NAME('ONT', 'OE_ZERO_QUANTITY');
210: FND_MESSAGE.SET_TOKEN('SALES_DOCUMENT_TYPE', l_sales_document_type);
211: oe_msg_pub.add;
212: resultout := 'COMPLETE:INCOMPLETE';
213: OE_STANDARD_WF.Save_Messages;
214: OE_STANDARD_WF.Clear_Msg_Context;
709: INTO l_blanket_number
710: FROM oe_blanket_headers_all
711: WHERE header_id = l_header_id;
712:
713: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');
714: fnd_message.set_token('BLANKET_NUMBER', to_char(l_blanket_number));
715: l_header_txt := fnd_message.get;
716: document := substrb(l_header_txt, 1, 240);
717: ELSIF l_sales_document_type_code = 'O' THEN
710: FROM oe_blanket_headers_all
711: WHERE header_id = l_header_id;
712:
713: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');
714: fnd_message.set_token('BLANKET_NUMBER', to_char(l_blanket_number));
715: l_header_txt := fnd_message.get;
716: document := substrb(l_header_txt, 1, 240);
717: ELSIF l_sales_document_type_code = 'O' THEN
718: SELECT oh.order_number, oh.order_type_id, t.name
711: WHERE header_id = l_header_id;
712:
713: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');
714: fnd_message.set_token('BLANKET_NUMBER', to_char(l_blanket_number));
715: l_header_txt := fnd_message.get;
716: document := substrb(l_header_txt, 1, 240);
717: ELSIF l_sales_document_type_code = 'O' THEN
718: SELECT oh.order_number, oh.order_type_id, t.name
719: INTO l_quote_number, l_transaction_type_id, l_transaction_type_name
721: WHERE header_id = l_header_id
722: AND t.language = userenv('LANG')
723: AND t.transaction_type_id = oh.order_type_id;
724:
725: fnd_message.set_name('ONT', 'OE_WF_TRANSACTION_TYPE');
726: fnd_message.set_token('TRANSACTION_TYPE', l_transaction_type_name);
727: l_transaction_type_txt := fnd_message.get;
728:
729: fnd_message.set_name('ONT', 'OE_WF_QUOTE_ORDER');
722: AND t.language = userenv('LANG')
723: AND t.transaction_type_id = oh.order_type_id;
724:
725: fnd_message.set_name('ONT', 'OE_WF_TRANSACTION_TYPE');
726: fnd_message.set_token('TRANSACTION_TYPE', l_transaction_type_name);
727: l_transaction_type_txt := fnd_message.get;
728:
729: fnd_message.set_name('ONT', 'OE_WF_QUOTE_ORDER');
730: fnd_message.set_token('QUOTE_NUMBER', to_char(l_quote_number));
723: AND t.transaction_type_id = oh.order_type_id;
724:
725: fnd_message.set_name('ONT', 'OE_WF_TRANSACTION_TYPE');
726: fnd_message.set_token('TRANSACTION_TYPE', l_transaction_type_name);
727: l_transaction_type_txt := fnd_message.get;
728:
729: fnd_message.set_name('ONT', 'OE_WF_QUOTE_ORDER');
730: fnd_message.set_token('QUOTE_NUMBER', to_char(l_quote_number));
731: l_header_txt := fnd_message.get;
725: fnd_message.set_name('ONT', 'OE_WF_TRANSACTION_TYPE');
726: fnd_message.set_token('TRANSACTION_TYPE', l_transaction_type_name);
727: l_transaction_type_txt := fnd_message.get;
728:
729: fnd_message.set_name('ONT', 'OE_WF_QUOTE_ORDER');
730: fnd_message.set_token('QUOTE_NUMBER', to_char(l_quote_number));
731: l_header_txt := fnd_message.get;
732:
733: document := substrb(l_transaction_type_txt || ', ' || l_header_txt, 1, 240);
726: fnd_message.set_token('TRANSACTION_TYPE', l_transaction_type_name);
727: l_transaction_type_txt := fnd_message.get;
728:
729: fnd_message.set_name('ONT', 'OE_WF_QUOTE_ORDER');
730: fnd_message.set_token('QUOTE_NUMBER', to_char(l_quote_number));
731: l_header_txt := fnd_message.get;
732:
733: document := substrb(l_transaction_type_txt || ', ' || l_header_txt, 1, 240);
734:
727: l_transaction_type_txt := fnd_message.get;
728:
729: fnd_message.set_name('ONT', 'OE_WF_QUOTE_ORDER');
730: fnd_message.set_token('QUOTE_NUMBER', to_char(l_quote_number));
731: l_header_txt := fnd_message.get;
732:
733: document := substrb(l_transaction_type_txt || ', ' || l_header_txt, 1, 240);
734:
735: ELSE
791: EXCEPTION
792: WHEN OTHERS THEN
793:
794: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
795: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
796: ELSE -- assume blanket
797: fnd_message.set_name('ONT', 'OE_NTF_BSA');
798: END IF;
799: l_sales_document_type := fnd_message.get;
793:
794: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
795: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
796: ELSE -- assume blanket
797: fnd_message.set_name('ONT', 'OE_NTF_BSA');
798: END IF;
799: l_sales_document_type := fnd_message.get;
800:
801: fnd_message.set_name('ONT', 'OE_WF_NO_LOST'); --flow not at notified state
795: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
796: ELSE -- assume blanket
797: fnd_message.set_name('ONT', 'OE_NTF_BSA');
798: END IF;
799: l_sales_document_type := fnd_message.get;
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;
797: fnd_message.set_name('ONT', 'OE_NTF_BSA');
798: END IF;
799: l_sales_document_type := fnd_message.get;
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
798: END IF;
799: l_sales_document_type := fnd_message.get;
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);
913:
914: EXCEPTION
915: WHEN OTHERS THEN
916: IF l_sales_document_type_code = 'O' THEN
917: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
918: ELSE -- assume blanket
919: fnd_message.set_name('ONT', 'OE_NTF_BSA');
920: END IF;
921: l_sales_document_type := fnd_message.get;
915: WHEN OTHERS THEN
916: IF l_sales_document_type_code = 'O' THEN
917: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
918: ELSE -- assume blanket
919: fnd_message.set_name('ONT', 'OE_NTF_BSA');
920: END IF;
921: l_sales_document_type := fnd_message.get;
922:
923: fnd_message.set_name('ONT', 'OE_WF_NO_CUST_ACCEPTED'); --flow not at right state
917: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
918: ELSE -- assume blanket
919: fnd_message.set_name('ONT', 'OE_NTF_BSA');
920: END IF;
921: l_sales_document_type := fnd_message.get;
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;
919: fnd_message.set_name('ONT', 'OE_NTF_BSA');
920: END IF;
921: l_sales_document_type := fnd_message.get;
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
920: END IF;
921: l_sales_document_type := fnd_message.get;
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);
1019: EXCEPTION
1020: WHEN OTHERS THEN
1021:
1022: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
1023: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1024: ELSE -- assume blanket
1025: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1026: END IF;
1027: l_sales_document_type := fnd_message.get;
1021:
1022: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
1023: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1024: ELSE -- assume blanket
1025: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1026: END IF;
1027: l_sales_document_type := fnd_message.get;
1028:
1029: fnd_message.set_name('ONT', 'OE_WF_NO_CUST_REJECTED'); --flow not at right state
1023: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1024: ELSE -- assume blanket
1025: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1026: END IF;
1027: l_sales_document_type := fnd_message.get;
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;
1025: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1026: END IF;
1027: l_sales_document_type := fnd_message.get;
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
1026: END IF;
1027: l_sales_document_type := fnd_message.get;
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);
1102: EXCEPTION
1103: WHEN OTHERS THEN
1104: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');
1105: IF l_sales_document_type_code = 'O' THEN
1106: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1107: ELSE -- assume blanket
1108: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1109: END IF;
1110: l_sales_document_type := fnd_message.get;
1104: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');
1105: IF l_sales_document_type_code = 'O' THEN
1106: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1107: ELSE -- assume blanket
1108: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1109: END IF;
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);
1106: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1107: ELSE -- assume blanket
1108: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1109: END IF;
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;
1107: ELSE -- assume blanket
1108: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1109: END IF;
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
1108: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1109: END IF;
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);
1229:
1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: IF l_sales_document_type_code = 'O' THEN
1233: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1234: ELSE -- assume blanket
1235: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1236: END IF;
1237: l_sales_document_type := fnd_message.get;
1231: WHEN OTHERS THEN
1232: IF l_sales_document_type_code = 'O' THEN
1233: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1234: ELSE -- assume blanket
1235: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1236: END IF;
1237: l_sales_document_type := fnd_message.get;
1238:
1239: fnd_message.set_name('ONT', 'OE_WF_NO_SUBMIT_DRAFT'); --flow not at right state
1233: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1234: ELSE -- assume blanket
1235: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1236: END IF;
1237: l_sales_document_type := fnd_message.get;
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;
1235: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1236: END IF;
1237: l_sales_document_type := fnd_message.get;
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
1236: END IF;
1237: l_sales_document_type := fnd_message.get;
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);