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;
765: INTO l_blanket_number
766: FROM oe_blanket_headers_all
767: WHERE header_id = l_header_id;
768:
769: fnd_message.set_name ('ONT', 'OE_WF_BLANKET_ORDER');
770: fnd_message.set_token ('BLANKET_NUMBER', TO_CHAR (l_blanket_number));
771: l_header_txt := fnd_message.get;
772: document := SUBSTRB (l_header_txt, 1, 240);
773: ELSIF l_sales_document_type_code = 'O'
766: FROM oe_blanket_headers_all
767: WHERE header_id = l_header_id;
768:
769: fnd_message.set_name ('ONT', 'OE_WF_BLANKET_ORDER');
770: fnd_message.set_token ('BLANKET_NUMBER', TO_CHAR (l_blanket_number));
771: l_header_txt := fnd_message.get;
772: document := SUBSTRB (l_header_txt, 1, 240);
773: ELSIF l_sales_document_type_code = 'O'
774: THEN
767: WHERE header_id = l_header_id;
768:
769: fnd_message.set_name ('ONT', 'OE_WF_BLANKET_ORDER');
770: fnd_message.set_token ('BLANKET_NUMBER', TO_CHAR (l_blanket_number));
771: l_header_txt := fnd_message.get;
772: document := SUBSTRB (l_header_txt, 1, 240);
773: ELSIF l_sales_document_type_code = 'O'
774: THEN
775: SELECT oh.order_number, oh.order_type_id,
780: WHERE header_id = l_header_id
781: AND t.LANGUAGE = USERENV ('LANG')
782: AND t.transaction_type_id = oh.order_type_id;
783:
784: fnd_message.set_name ('ONT', 'OE_WF_TRANSACTION_TYPE');
785: fnd_message.set_token ('TRANSACTION_TYPE', l_transaction_type_name);
786: l_transaction_type_txt := fnd_message.get;
787: fnd_message.set_name ('ONT', 'OE_WF_QUOTE_ORDER');
788: fnd_message.set_token ('QUOTE_NUMBER', TO_CHAR (l_quote_number));
781: AND t.LANGUAGE = USERENV ('LANG')
782: AND t.transaction_type_id = oh.order_type_id;
783:
784: fnd_message.set_name ('ONT', 'OE_WF_TRANSACTION_TYPE');
785: fnd_message.set_token ('TRANSACTION_TYPE', l_transaction_type_name);
786: l_transaction_type_txt := fnd_message.get;
787: fnd_message.set_name ('ONT', 'OE_WF_QUOTE_ORDER');
788: fnd_message.set_token ('QUOTE_NUMBER', TO_CHAR (l_quote_number));
789: l_header_txt := fnd_message.get;
782: AND t.transaction_type_id = oh.order_type_id;
783:
784: fnd_message.set_name ('ONT', 'OE_WF_TRANSACTION_TYPE');
785: fnd_message.set_token ('TRANSACTION_TYPE', l_transaction_type_name);
786: l_transaction_type_txt := fnd_message.get;
787: fnd_message.set_name ('ONT', 'OE_WF_QUOTE_ORDER');
788: fnd_message.set_token ('QUOTE_NUMBER', TO_CHAR (l_quote_number));
789: l_header_txt := fnd_message.get;
790: document :=
783:
784: fnd_message.set_name ('ONT', 'OE_WF_TRANSACTION_TYPE');
785: fnd_message.set_token ('TRANSACTION_TYPE', l_transaction_type_name);
786: l_transaction_type_txt := fnd_message.get;
787: fnd_message.set_name ('ONT', 'OE_WF_QUOTE_ORDER');
788: fnd_message.set_token ('QUOTE_NUMBER', TO_CHAR (l_quote_number));
789: l_header_txt := fnd_message.get;
790: document :=
791: SUBSTRB (l_transaction_type_txt || ', ' || l_header_txt, 1, 240);
784: fnd_message.set_name ('ONT', 'OE_WF_TRANSACTION_TYPE');
785: fnd_message.set_token ('TRANSACTION_TYPE', l_transaction_type_name);
786: l_transaction_type_txt := fnd_message.get;
787: fnd_message.set_name ('ONT', 'OE_WF_QUOTE_ORDER');
788: fnd_message.set_token ('QUOTE_NUMBER', TO_CHAR (l_quote_number));
789: l_header_txt := fnd_message.get;
790: document :=
791: SUBSTRB (l_transaction_type_txt || ', ' || l_header_txt, 1, 240);
792: ELSE
785: fnd_message.set_token ('TRANSACTION_TYPE', l_transaction_type_name);
786: l_transaction_type_txt := fnd_message.get;
787: fnd_message.set_name ('ONT', 'OE_WF_QUOTE_ORDER');
788: fnd_message.set_token ('QUOTE_NUMBER', TO_CHAR (l_quote_number));
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
846: EXCEPTION
847: WHEN OTHERS THEN
848:
849: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
850: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
851: ELSE -- assume blanket
852: fnd_message.set_name('ONT', 'OE_NTF_BSA');
853: END IF;
854: l_sales_document_type := fnd_message.get;
848:
849: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
850: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
851: ELSE -- assume blanket
852: fnd_message.set_name('ONT', 'OE_NTF_BSA');
853: END IF;
854: l_sales_document_type := fnd_message.get;
855:
856: fnd_message.set_name('ONT', 'OE_WF_NO_LOST'); --flow not at notified state
850: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
851: ELSE -- assume blanket
852: fnd_message.set_name('ONT', 'OE_NTF_BSA');
853: END IF;
854: l_sales_document_type := fnd_message.get;
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;
852: fnd_message.set_name('ONT', 'OE_NTF_BSA');
853: END IF;
854: l_sales_document_type := fnd_message.get;
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
853: END IF;
854: l_sales_document_type := fnd_message.get;
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);
968:
969: EXCEPTION
970: WHEN OTHERS THEN
971: IF l_sales_document_type_code = 'O' THEN
972: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
973: ELSE -- assume blanket
974: fnd_message.set_name('ONT', 'OE_NTF_BSA');
975: END IF;
976: l_sales_document_type := fnd_message.get;
970: WHEN OTHERS THEN
971: IF l_sales_document_type_code = 'O' THEN
972: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
973: ELSE -- assume blanket
974: fnd_message.set_name('ONT', 'OE_NTF_BSA');
975: END IF;
976: l_sales_document_type := fnd_message.get;
977:
978: fnd_message.set_name('ONT', 'OE_WF_NO_CUST_ACCEPTED'); --flow not at right state
972: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
973: ELSE -- assume blanket
974: fnd_message.set_name('ONT', 'OE_NTF_BSA');
975: END IF;
976: l_sales_document_type := fnd_message.get;
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;
974: fnd_message.set_name('ONT', 'OE_NTF_BSA');
975: END IF;
976: l_sales_document_type := fnd_message.get;
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
975: END IF;
976: l_sales_document_type := fnd_message.get;
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);
1074: EXCEPTION
1075: WHEN OTHERS THEN
1076:
1077: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
1078: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1079: ELSE -- assume blanket
1080: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1081: END IF;
1082: l_sales_document_type := fnd_message.get;
1076:
1077: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
1078: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1079: ELSE -- assume blanket
1080: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1081: END IF;
1082: l_sales_document_type := fnd_message.get;
1083:
1084: fnd_message.set_name('ONT', 'OE_WF_NO_CUST_REJECTED'); --flow not at right state
1078: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1079: ELSE -- assume blanket
1080: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1081: END IF;
1082: l_sales_document_type := fnd_message.get;
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;
1080: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1081: END IF;
1082: l_sales_document_type := fnd_message.get;
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
1081: END IF;
1082: l_sales_document_type := fnd_message.get;
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);
1157: EXCEPTION
1158: WHEN OTHERS THEN
1159: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');
1160: IF l_sales_document_type_code = 'O' THEN
1161: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1162: ELSE -- assume blanket
1163: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1164: END IF;
1165: l_sales_document_type := fnd_message.get;
1159: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(OE_GLOBALS.G_WFI_NGO, p_header_id, 'SALES_DOCUMENT_TYPE_CODE');
1160: IF l_sales_document_type_code = 'O' THEN
1161: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1162: ELSE -- assume blanket
1163: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1164: END IF;
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);
1161: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1162: ELSE -- assume blanket
1163: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1164: END IF;
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;
1162: ELSE -- assume blanket
1163: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1164: END IF;
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
1163: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1164: END IF;
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);
1284:
1285: EXCEPTION
1286: WHEN OTHERS THEN
1287: IF l_sales_document_type_code = 'O' THEN
1288: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1289: ELSE -- assume blanket
1290: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1291: END IF;
1292: l_sales_document_type := fnd_message.get;
1286: WHEN OTHERS THEN
1287: IF l_sales_document_type_code = 'O' THEN
1288: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1289: ELSE -- assume blanket
1290: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1291: END IF;
1292: l_sales_document_type := fnd_message.get;
1293:
1294: fnd_message.set_name('ONT', 'OE_WF_NO_SUBMIT_DRAFT'); --flow not at right state
1288: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
1289: ELSE -- assume blanket
1290: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1291: END IF;
1292: l_sales_document_type := fnd_message.get;
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;
1290: fnd_message.set_name('ONT', 'OE_NTF_BSA');
1291: END IF;
1292: l_sales_document_type := fnd_message.get;
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
1291: END IF;
1292: l_sales_document_type := fnd_message.get;
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);