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 713: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');

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

Line 714: fnd_message.set_token('BLANKET_NUMBER', to_char(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
718: SELECT oh.order_number, oh.order_type_id, t.name

Line 715: l_header_txt := fnd_message.get;

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

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

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

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

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

Line 727: l_transaction_type_txt := fnd_message.get;

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;

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

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

Line 730: fnd_message.set_token('QUOTE_NUMBER', to_char(l_quote_number));

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:

Line 731: l_header_txt := fnd_message.get;

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

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

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;

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

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

Line 799: l_sales_document_type := fnd_message.get;

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;

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

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

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

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

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

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;

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

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

Line 921: l_sales_document_type := fnd_message.get;

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;

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

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

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

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

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

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;

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

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

Line 1027: l_sales_document_type := fnd_message.get;

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;

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

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

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

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

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

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;

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

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

Line 1110: l_sales_document_type := fnd_message.get;

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;

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

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

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

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

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

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;

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

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

Line 1237: l_sales_document_type := fnd_message.get;

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;

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

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

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

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