DBA Data[Home] [Help]

APPS.OE_NEGOTIATE_WF dependencies on FND_MESSAGE

Line 203: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');

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;

Line 205: fnd_message.set_name('ONT', 'OE_NTF_BSA');

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');

Line 207: l_sales_document_type := fnd_message.get;

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;

Line 209: FND_MESSAGE.SET_NAME('ONT', 'OE_ZERO_QUANTITY');

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;

Line 210: FND_MESSAGE.SET_TOKEN('SALES_DOCUMENT_TYPE', l_sales_document_type);

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;

Line 769: fnd_message.set_name ('ONT', 'OE_WF_BLANKET_ORDER');

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'

Line 770: fnd_message.set_token ('BLANKET_NUMBER', TO_CHAR (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'
774: THEN

Line 771: l_header_txt := fnd_message.get;

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,

Line 784: fnd_message.set_name ('ONT', 'OE_WF_TRANSACTION_TYPE');

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));

Line 785: fnd_message.set_token ('TRANSACTION_TYPE', l_transaction_type_name);

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;

Line 786: l_transaction_type_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 :=

Line 787: fnd_message.set_name ('ONT', 'OE_WF_QUOTE_ORDER');

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);

Line 788: fnd_message.set_token ('QUOTE_NUMBER', TO_CHAR (l_quote_number));

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

Line 789: l_header_txt := fnd_message.get;

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

Line 850: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');

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;

Line 852: fnd_message.set_name('ONT', 'OE_NTF_BSA');

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

Line 854: l_sales_document_type := fnd_message.get;

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;

Line 856: fnd_message.set_name('ONT', 'OE_WF_NO_LOST'); --flow not at notified state

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

Line 857: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);

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);

Line 972: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');

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;

Line 974: fnd_message.set_name('ONT', 'OE_NTF_BSA');

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

Line 976: l_sales_document_type := fnd_message.get;

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;

Line 978: fnd_message.set_name('ONT', 'OE_WF_NO_CUST_ACCEPTED'); --flow not at right state

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

Line 979: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);

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);

Line 1078: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');

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;

Line 1080: fnd_message.set_name('ONT', 'OE_NTF_BSA');

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

Line 1082: l_sales_document_type := fnd_message.get;

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;

Line 1084: fnd_message.set_name('ONT', 'OE_WF_NO_CUST_REJECTED'); --flow not at right state

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

Line 1085: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);

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);

Line 1161: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');

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;

Line 1163: fnd_message.set_name('ONT', 'OE_NTF_BSA');

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);

Line 1165: l_sales_document_type := fnd_message.get;

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;

Line 1166: fnd_message.set_name('ONT', 'OE_WF_NO_OFFER_DATE_CHANGE'); --flow not at right state

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

Line 1167: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);

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);

Line 1288: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');

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;

Line 1290: fnd_message.set_name('ONT', 'OE_NTF_BSA');

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

Line 1292: l_sales_document_type := fnd_message.get;

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;

Line 1294: fnd_message.set_name('ONT', 'OE_WF_NO_SUBMIT_DRAFT'); --flow not at right state

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

Line 1295: fnd_message.set_token('SALES_DOCUMENT_TYPE', l_sales_document_type);

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);