eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CNCL_VALIDATE_LINE dependencies on FND_MESSAGE

Line 31: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

27: -- Check for fields required on a booked order line
28:
29: IF p_line_rec.sold_to_org_id IS NULL THEN
30: x_return_status := FND_API.G_RET_STS_ERROR;
31: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
32: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
33: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
34: OE_MSG_PUB.ADD;
35: END IF;

Line 32: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

28:
29: IF p_line_rec.sold_to_org_id IS NULL THEN
30: x_return_status := FND_API.G_RET_STS_ERROR;
31: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
32: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
33: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
34: OE_MSG_PUB.ADD;
35: END IF;
36:

Line 39: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

35: END IF;
36:
37: IF p_line_rec.invoice_to_org_id IS NULL THEN
38: x_return_status := FND_API.G_RET_STS_ERROR;
39: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
40: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
41: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
42: OE_MSG_PUB.ADD;
43: END IF;

Line 40: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

36:
37: IF p_line_rec.invoice_to_org_id IS NULL THEN
38: x_return_status := FND_API.G_RET_STS_ERROR;
39: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
40: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
41: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
42: OE_MSG_PUB.ADD;
43: END IF;
44:

Line 47: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

43: END IF;
44:
45: IF p_line_rec.tax_exempt_flag IS NULL THEN
46: x_return_status := FND_API.G_RET_STS_ERROR;
47: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
48: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
49: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
50: OE_MSG_PUB.ADD;
51: END IF;

Line 48: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

44:
45: IF p_line_rec.tax_exempt_flag IS NULL THEN
46: x_return_status := FND_API.G_RET_STS_ERROR;
47: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
48: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
49: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
50: OE_MSG_PUB.ADD;
51: END IF;
52:

Line 57: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

53:
54: -- Item, Quantity and UOM Required
55: IF p_line_rec.inventory_item_id IS NULL THEN
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
58: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
59: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
60: OE_MSG_PUB.ADD;
61: END IF;

Line 58: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

54: -- Item, Quantity and UOM Required
55: IF p_line_rec.inventory_item_id IS NULL THEN
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
58: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
59: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
60: OE_MSG_PUB.ADD;
61: END IF;
62:

Line 65: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

61: END IF;
62:
63: IF p_line_rec.order_quantity_uom IS NULL THEN
64: x_return_status := FND_API.G_RET_STS_ERROR;
65: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
66: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
67: OE_Order_UTIL.Get_Attribute_Name('ORDER_QUANTITY_UOM'));
68: OE_MSG_PUB.ADD;
69: END IF;

Line 66: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

62:
63: IF p_line_rec.order_quantity_uom IS NULL THEN
64: x_return_status := FND_API.G_RET_STS_ERROR;
65: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
66: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
67: OE_Order_UTIL.Get_Attribute_Name('ORDER_QUANTITY_UOM'));
68: OE_MSG_PUB.ADD;
69: END IF;
70:

Line 75: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

71: -- Fix bug 1277092: ordered quantity should not be = 0 on a booked line
72: IF p_line_rec.ordered_quantity IS NULL
73: OR p_line_rec.ordered_quantity = 0 THEN
74: x_return_status := FND_API.G_RET_STS_ERROR;
75: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
76: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
77: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));
78: OE_MSG_PUB.ADD;
79: END IF;

Line 76: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

72: IF p_line_rec.ordered_quantity IS NULL
73: OR p_line_rec.ordered_quantity = 0 THEN
74: x_return_status := FND_API.G_RET_STS_ERROR;
75: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
76: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
77: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));
78: OE_MSG_PUB.ADD;
79: END IF;
80:

Line 97: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

93: THEN
94:
95: IF p_line_rec.price_list_id IS NULL THEN
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
99: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
100: OE_MSG_PUB.ADD;
101: END IF;

Line 98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

94:
95: IF p_line_rec.price_list_id IS NULL THEN
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
99: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
100: OE_MSG_PUB.ADD;
101: END IF;
102:

Line 105: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

101: END IF;
102:
103: IF p_line_rec.unit_list_price IS NULL THEN
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
107: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
108: OE_MSG_PUB.ADD;
109: END IF;

Line 106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

102:
103: IF p_line_rec.unit_list_price IS NULL THEN
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
107: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
108: OE_MSG_PUB.ADD;
109: END IF;
110:

Line 113: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

109: END IF;
110:
111: IF p_line_rec.unit_selling_price IS NULL THEN
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
114: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
115: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
116: OE_MSG_PUB.ADD;
117: END IF;

Line 114: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

110:
111: IF p_line_rec.unit_selling_price IS NULL THEN
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
114: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
115: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
116: OE_MSG_PUB.ADD;
117: END IF;
118:

Line 130: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

126: IF p_line_rec.line_category_code <> OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
127:
128: IF p_line_rec.ship_to_org_id IS NULL THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
131: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
132: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
133: OE_MSG_PUB.ADD;
134: END IF;

Line 131: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

127:
128: IF p_line_rec.ship_to_org_id IS NULL THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
131: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
132: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
133: OE_MSG_PUB.ADD;
134: END IF;
135:

Line 138: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

134: END IF;
135:
136: IF p_line_rec.payment_term_id IS NULL THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
139: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
140: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
141: OE_MSG_PUB.ADD;
142: END IF;

Line 139: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

135:
136: IF p_line_rec.payment_term_id IS NULL THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
139: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
140: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
141: OE_MSG_PUB.ADD;
142: END IF;
143:

Line 153: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');

149: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
150:
151: IF p_line_rec.ship_from_org_id IS NULL THEN
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
155: OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
156: OE_MSG_PUB.ADD;
157: END IF;

Line 154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

150:
151: IF p_line_rec.ship_from_org_id IS NULL THEN
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
155: OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
156: OE_MSG_PUB.ADD;
157: END IF;
158:

Line 161: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');

157: END IF;
158:
159: IF p_line_rec.request_date IS NULL THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
163: OE_Order_UTIL.Get_Attribute_Name('REQUEST_DATE'));
164: OE_MSG_PUB.ADD;
165: END IF;

Line 162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

158:
159: IF p_line_rec.request_date IS NULL THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
163: OE_Order_UTIL.Get_Attribute_Name('REQUEST_DATE'));
164: OE_MSG_PUB.ADD;
165: END IF;
166:

Line 174: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');

170:
171: IF p_line_rec.tax_date IS NULL
172: THEN
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
176: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
177: OE_MSG_PUB.ADD;
178: END IF;

Line 175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

171: IF p_line_rec.tax_date IS NULL
172: THEN
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
176: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
177: OE_MSG_PUB.ADD;
178: END IF;
179:

Line 215: FND_MESSAGE.SET_NAME('ONT','OE_VAL_TAX_CODE_REQD');

211: IF (l_line_type_rec.calculate_tax_flag = 'Y' OR p_line_rec.tax_exempt_flag = 'R')
212: AND p_line_rec.tax_code IS NULL
213: THEN
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: FND_MESSAGE.SET_NAME('ONT','OE_VAL_TAX_CODE_REQD');
216: OE_MSG_PUB.ADD;
217: END IF;*/
218:
219: /* Added by Manish */

Line 226: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_SERVICE_DURATION');

222: -- Service Duration is required on SERVICE lines
223: IF l_item_type_code = 'SERVICE' THEN
224: IF p_line_rec.service_duration IS NULL THEN
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_SERVICE_DURATION');
227: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
228: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
229: OE_MSG_PUB.ADD;
230: END IF;

Line 227: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

223: IF l_item_type_code = 'SERVICE' THEN
224: IF p_line_rec.service_duration IS NULL THEN
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_SERVICE_DURATION');
227: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
228: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
229: OE_MSG_PUB.ADD;
230: END IF;
231: END IF;

Line 242: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_QUANTITY');

238: p_line_rec.cancelled_flag <> 'Y'
239: THEN
240: IF (OE_LINE_UTIL.Is_Over_Return(p_line_rec)) THEN
241: x_return_status := FND_API.G_RET_STS_ERROR;
242: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_QUANTITY');
243: OE_MSG_PUB.ADD;
244: END IF;
245: END IF;
246:

Line 307: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');

303:
304: IF p_item_type_code IN ('MODEL', 'OPTION', 'KIT',
305: 'CLASS','INCLUDED', 'CONFIG') THEN
306: oe_debug_pub.add('item is config related with decimal qty',2);
307: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
308: OE_MSG_PUB.Add;
309: x_return_status := FND_API.G_RET_STS_ERROR;
310:
311: ELSE

Line 331: fnd_message.set_name('ONT', 'OE_DECIMAL_MAX_PRECISION');

327: oe_debug_pub.add('l_pri_qty ' || l_primary_quantity,2);
328: oe_debug_pub.add('l_val_qty ' || l_validated_quantity,2);
329: /* bug 2926436 */
330: IF l_qty_return_status = 'W' THEN
331: fnd_message.set_name('ONT', 'OE_DECIMAL_MAX_PRECISION');
332: END IF;
333:
334: -- move INV error message to OE message stack
335: oe_msg_pub.add;

Line 403: FND_MESSAGE.SET_NAME('ONT','OE_EXP_ASSIGN_REQ');

399: CLOSE find_config_assign;
400:
401: IF lexists IS NULL THEN
402: oe_debug_pub.add('No explicit assignment exists',2);
403: FND_MESSAGE.SET_NAME('ONT','OE_EXP_ASSIGN_REQ');
404: OE_MSG_PUB.ADD;
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:

Line 413: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');

409:
410: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Line_Type',1);
411: EXCEPTION
412: WHEN NO_DATA_FOUND THEN
413: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
414: OE_MSG_PUB.ADD;
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: WHEN FND_API.G_EXC_ERROR THEN
417: RAISE FND_API.G_EXC_ERROR;

Line 457: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');

453: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Receiving_Org',1);
454: RETURN TRUE;
455: EXCEPTION
456: WHEN NO_DATA_FOUND THEN
457: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
458: OE_MSG_PUB.add;
459: RETURN FALSE;
460: WHEN OTHERS THEN
461: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');

Line 461: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');

457: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
458: OE_MSG_PUB.add;
459: RETURN FALSE;
460: WHEN OTHERS THEN
461: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
462: OE_MSG_PUB.add;
463: RETURN FALSE;
464: END Validate_Receiving_Org;
465:

Line 513: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');

509: EXCEPTION
510: WHEN NO_DATA_FOUND THEN
511: oe_debug_pub.add('RR: No data found',1);
512:
513: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
514: OE_MSG_PUB.add;
515: RETURN FALSE;
516:
517: WHEN OTHERS THEN

Line 519: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');

515: RETURN FALSE;
516:
517: WHEN OTHERS THEN
518: oe_debug_pub.add('RR: OTHERS',1);
519: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
520: OE_MSG_PUB.add;
521: RETURN FALSE;
522:
523: END Validate_Item_Warehouse;

Line 689: FND_MESSAGE.SET_NAME('ONT','OE_RETURN_ITEM_MISMATCH_WARNIN');

685: RETURN TRUE;
686: ELSIF (l_profile = 'R') THEN
687: RETURN FALSE;
688: ELSE -- warning
689: FND_MESSAGE.SET_NAME('ONT','OE_RETURN_ITEM_MISMATCH_WARNIN');
690: OE_MSG_PUB.ADD;
691: END IF;
692:
693: END IF;

Line 759: FND_MESSAGE.SET_NAME('ONT','OE_UNFULFILLED_LINE_WARNING');

755: RETURN TRUE;
756: ELSIF (l_profile = 'R') THEN
757: RETURN FALSE;
758: ELSE -- warning
759: FND_MESSAGE.SET_NAME('ONT','OE_UNFULFILLED_LINE_WARNING');
760: OE_MSG_PUB.ADD;
761: END IF;
762:
763: END IF;

Line 825: fnd_message.set_name('ONT', 'OE_RETURN_UNBOOKED_ORDER');

821:
822: IF l_booked_flag = 'Y' THEN
823: RETURN TRUE;
824: ELSE
825: fnd_message.set_name('ONT', 'OE_RETURN_UNBOOKED_ORDER');
826: OE_MSG_PUB.Add;
827: END IF;
828:
829: oe_debug_pub.add('Exit Validate_Return_Reference',1);

Line 835: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');

831:
832: EXCEPTION
833: WHEN NO_DATA_FOUND THEN
834: oe_debug_pub.add('Validate_Return_Reference: No data found',1);
835: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
836: OE_MSG_PUB.Add;
837: RETURN FALSE;
838: WHEN OTHERS THEN
839: oe_debug_pub.add('Validate_Return_Reference: When Others',1);

Line 840: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');

836: OE_MSG_PUB.Add;
837: RETURN FALSE;
838: WHEN OTHERS THEN
839: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
840: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
841: OE_MSG_PUB.Add;
842: RETURN FALSE;
843: END Validate_Return_Reference;
844:

Line 1044: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_VALID_ITEM');

1040: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1041: p_line_rec.ship_model_complete_flag = 'Y'
1042: THEN
1043: oe_debug_pub.add('servie / part of smc model', 4);
1044: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_VALID_ITEM');
1045: FND_MESSAGE.SET_TOKEN('ITEM', p_line_rec.ordered_item);
1046: OE_MSG_PUB.Add;
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048: RETURN;

Line 1045: FND_MESSAGE.SET_TOKEN('ITEM', p_line_rec.ordered_item);

1041: p_line_rec.ship_model_complete_flag = 'Y'
1042: THEN
1043: oe_debug_pub.add('servie / part of smc model', 4);
1044: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_VALID_ITEM');
1045: FND_MESSAGE.SET_TOKEN('ITEM', p_line_rec.ordered_item);
1046: OE_MSG_PUB.Add;
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048: RETURN;
1049: ELSE

Line 1055: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ALLOWED');

1051: END IF;
1052: ELSE
1053: IF (p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD) THEN
1054: oe_debug_pub.add('Cannot dropship non-standard item',2);
1055: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ALLOWED');
1056: OE_MSG_PUB.Add;
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: RETURN;
1059: END IF;

Line 1067: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_SET_INS_FAILED');

1063: IF p_line_rec.ship_set_id is not null OR
1064: p_line_rec.arrival_set_id is not null THEN
1065:
1066: oe_debug_pub.add('Cannot insert external line to set',2);
1067: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_SET_INS_FAILED');
1068: OE_MSG_PUB.Add;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: RETURN;
1071: END IF;

Line 1091: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');

1087: AND org.set_of_books_id= ( SELECT fsp.set_of_books_id
1088: FROM financials_system_parameters fsp);
1089:
1090: IF l_purchasing_enabled_flag = 'N' THEN
1091: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');
1092: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ship_from_org_id,
1093: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')));
1094: FND_MESSAGE.SET_TOKEN('ORG', p_line_rec.ordered_item);
1095: OE_MSG_PUB.Add;

Line 1092: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ship_from_org_id,

1088: FROM financials_system_parameters fsp);
1089:
1090: IF l_purchasing_enabled_flag = 'N' THEN
1091: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');
1092: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ship_from_org_id,
1093: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')));
1094: FND_MESSAGE.SET_TOKEN('ORG', p_line_rec.ordered_item);
1095: OE_MSG_PUB.Add;
1096: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1094: FND_MESSAGE.SET_TOKEN('ORG', p_line_rec.ordered_item);

1090: IF l_purchasing_enabled_flag = 'N' THEN
1091: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');
1092: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ship_from_org_id,
1093: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')));
1094: FND_MESSAGE.SET_TOKEN('ORG', p_line_rec.ordered_item);
1095: OE_MSG_PUB.Add;
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: END IF;
1098:

Line 1240: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

1236: THEN
1237:
1238: l_return_status := FND_API.G_RET_STS_ERROR;
1239:
1240: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1241: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1242: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
1243: OE_MSG_PUB.Add;
1244:

Line 1241: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1237:
1238: l_return_status := FND_API.G_RET_STS_ERROR;
1239:
1240: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1241: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1242: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
1243: OE_MSG_PUB.Add;
1244:
1245: END IF;

Line 1253: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

1249: THEN
1250:
1251: l_return_status := FND_API.G_RET_STS_ERROR;
1252:
1253: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1255: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
1256: OE_MSG_PUB.Add;
1257:

Line 1254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1250:
1251: l_return_status := FND_API.G_RET_STS_ERROR;
1252:
1253: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1255: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
1256: OE_MSG_PUB.Add;
1257:
1258: ELSIF p_line_rec.line_type_id IS NOT NULL THEN

Line 1283: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

1279: and p_line_rec.return_reason_code is NULL
1280: THEN
1281: l_return_status := FND_API.G_RET_STS_ERROR;
1282:
1283: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1284: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1285: OE_Order_UTIL.Get_Attribute_Name('RETURN_REASON_CODE'));
1286: OE_MSG_PUB.Add;
1287:

Line 1284: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1280: THEN
1281: l_return_status := FND_API.G_RET_STS_ERROR;
1282:
1283: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1284: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1285: OE_Order_UTIL.Get_Attribute_Name('RETURN_REASON_CODE'));
1286: OE_MSG_PUB.Add;
1287:
1288: END IF;

Line 1302: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');

1298: p_line_rec.source_type_code is null THEN
1299: oe_debug_pub.add('Entity Validateion: subinventory', 1);
1300: IF p_line_rec.ship_from_org_id is null THEN
1301: l_return_status := FND_API.G_RET_STS_ERROR;
1302: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
1303: fnd_message.set_token('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
1304: OE_MSG_PUB.Add;
1305: END IF;
1306: ELSE -- external

Line 1303: fnd_message.set_token('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));

1299: oe_debug_pub.add('Entity Validateion: subinventory', 1);
1300: IF p_line_rec.ship_from_org_id is null THEN
1301: l_return_status := FND_API.G_RET_STS_ERROR;
1302: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
1303: fnd_message.set_token('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
1304: OE_MSG_PUB.Add;
1305: END IF;
1306: ELSE -- external
1307: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1308: fnd_message.set_name('ONT', 'OE_SUBINV_EXTERNAL');

1304: OE_MSG_PUB.Add;
1305: END IF;
1306: ELSE -- external
1307: l_return_status := FND_API.G_RET_STS_ERROR;
1308: fnd_message.set_name('ONT', 'OE_SUBINV_EXTERNAL');
1309: OE_MSG_PUB.Add;
1310: END IF;
1311: END IF;
1312:

Line 1383: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

1379:
1380: oe_debug_pub.add('Primary and Secondary X-VAL qty 1 not empty', 2);
1381:
1382: l_return_status := FND_API.G_RET_STS_ERROR;
1383: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1384: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity2');
1385: OE_MSG_PUB.Add;
1386:
1387: ELSIF (p_line_rec.ordered_quantity2 <> FND_API.G_MISS_NUM OR

Line 1384: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity2');

1380: oe_debug_pub.add('Primary and Secondary X-VAL qty 1 not empty', 2);
1381:
1382: l_return_status := FND_API.G_RET_STS_ERROR;
1383: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1384: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity2');
1385: OE_MSG_PUB.Add;
1386:
1387: ELSIF (p_line_rec.ordered_quantity2 <> FND_API.G_MISS_NUM OR
1388: p_line_rec.ordered_quantity2 IS NOT NULL) AND

Line 1392: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

1388: p_line_rec.ordered_quantity2 IS NOT NULL) AND
1389: (p_line_rec.ordered_quantity IS NULL) THEN
1390:
1391: l_return_status := FND_API.G_RET_STS_ERROR;
1392: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity');
1394: OE_MSG_PUB.Add;
1395: END IF; -- IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM OR
1396: END IF; -- IF l_item_rec.tracking_quantity_ind = 'PS' IF l_item_rec.dualum_ind in (1,2,3) THEN

Line 1393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity');

1389: (p_line_rec.ordered_quantity IS NULL) THEN
1390:
1391: l_return_status := FND_API.G_RET_STS_ERROR;
1392: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity');
1394: OE_MSG_PUB.Add;
1395: END IF; -- IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM OR
1396: END IF; -- IF l_item_rec.tracking_quantity_ind = 'PS' IF l_item_rec.dualum_ind in (1,2,3) THEN
1397:

Line 1462: FND_MESSAGE.set_name('GMI', 'IC_DEVIATION_HI_ERR');

1458: ,0);
1459: -- OPM END 06/22
1460: IF(l_return = -68) THEN
1461: l_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MESSAGE.set_name('GMI', 'IC_DEVIATION_HI_ERR');
1463: OE_MSG_PUB.Add;
1464: ELSIF (l_return = -69) THEN
1465: l_return_status := FND_API.G_RET_STS_ERROR;
1466: FND_MESSAGE.set_name('GMI', 'IC_DEVIATION_LO_ERR');

Line 1466: FND_MESSAGE.set_name('GMI', 'IC_DEVIATION_LO_ERR');

1462: FND_MESSAGE.set_name('GMI', 'IC_DEVIATION_HI_ERR');
1463: OE_MSG_PUB.Add;
1464: ELSIF (l_return = -69) THEN
1465: l_return_status := FND_API.G_RET_STS_ERROR;
1466: FND_MESSAGE.set_name('GMI', 'IC_DEVIATION_LO_ERR');
1467: OE_MSG_PUB.Add;
1468: END IF; */
1469:
1470:

Line 1651: fnd_message.set_name('ONT','OE_SCH_RES_MORE_ORD_QTY');

1647: /* IF NOT OE_GLOBALS.Equal(p_line_rec.reserved_quantity,p_old_line_rec.reserved_quantity)
1648: THEN
1649:
1650: IF (p_line_rec.reserved_quantity > p_line_rec.ordered_quantity) THEN
1651: fnd_message.set_name('ONT','OE_SCH_RES_MORE_ORD_QTY');
1652: OE_MSG_PUB.Add;
1653: l_return_status := FND_API.G_RET_STS_ERROR;
1654: END IF;
1655:

Line 1676: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INVALID_CHANGE');

1672: -- Schedule_Ship_Date and schedule_Arrival_date. We should not
1673: -- error out for this item.
1674:
1675: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
1676: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INVALID_CHANGE');
1677: OE_MSG_PUB.Add;
1678: l_return_status := FND_API.G_RET_STS_ERROR;
1679: END IF;
1680:

Line 1696: FND_MESSAGE.SET_NAME('ONT', 'OE_SHIP_FROM_REQD');

1692: IF (p_line_rec.project_id IS NOT NULL
1693: AND p_line_rec.ship_from_org_id IS NULL) THEN
1694:
1695: l_return_status := FND_API.G_RET_STS_ERROR;
1696: FND_MESSAGE.SET_NAME('ONT', 'OE_SHIP_FROM_REQD');
1697: OE_MSG_PUB.add;
1698: ELSIF (p_line_rec.task_id IS NOT NULL
1699: AND p_line_rec.project_id IS NULL) THEN
1700:

Line 1702: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');

1698: ELSIF (p_line_rec.task_id IS NOT NULL
1699: AND p_line_rec.project_id IS NULL) THEN
1700:
1701: l_return_status := FND_API.G_RET_STS_ERROR;
1702: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');
1703: OE_MSG_PUB.add;
1704:
1705: END IF;
1706:

Line 1767: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SHIP_FROM_PROJ');

1763: (p_line_rec.project_id,
1764: p_line_rec.ship_from_org_id) IS NULL THEN
1765:
1766: l_return_status := FND_API.G_RET_STS_ERROR;
1767: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SHIP_FROM_PROJ');
1768: OE_MSG_PUB.add;
1769: END IF;
1770:
1771: END IF;

Line 1777: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');

1773: IF (p_line_rec.task_id IS NOT NULL
1774: AND p_line_rec.project_id IS NULL) THEN
1775:
1776: l_return_status := FND_API.G_RET_STS_ERROR;
1777: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');
1778: OE_MSG_PUB.add;
1779:
1780: ELSIF (p_line_rec.task_id is NOT NULL
1781: AND p_line_rec.project_id IS NOT NULL) THEN

Line 1789: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

1785: p_line_rec.task_id) THEN
1786:
1787: l_return_status := FND_API.G_RET_STS_ERROR;
1788: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
1789: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1791: OE_Order_Util.Get_Attribute_Name('task_id'));
1792: OE_MSG_PUB.Add;
1793: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

Line 1790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1786:
1787: l_return_status := FND_API.G_RET_STS_ERROR;
1788: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
1789: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1791: OE_Order_Util.Get_Attribute_Name('task_id'));
1792: OE_MSG_PUB.Add;
1793: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1794:

Line 1805: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_TASK_REQD');

1801: p_line_rec.project_id,
1802: p_line_rec.ship_from_org_id) THEN
1803:
1804: l_return_status := FND_API.G_RET_STS_ERROR;
1805: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_TASK_REQD');
1806: OE_MSG_PUB.ADD;
1807:
1808: END IF;
1809:

Line 1825: fnd_message.set_name('ONT', 'OE_UEFF_NUMBER_REQD');

1821: (p_line_rec.inventory_item_id,p_line_rec.ship_from_org_id) = 'Y'
1822: THEN
1823:
1824: l_return_status := FND_API.G_RET_STS_ERROR;
1825: fnd_message.set_name('ONT', 'OE_UEFF_NUMBER_REQD');
1826: OE_MSG_PUB.add;
1827: END IF;
1828:
1829: END IF;

Line 1836: fnd_message.set_name('ONT', 'OE_PJM_NOT_INSTALLED');

1832: IF (p_line_rec.project_id IS NOT NULL OR
1833: p_line_rec.task_id IS NOT NULL OR
1834: p_line_rec.end_item_unit_number IS NOT NULL) THEN
1835: l_return_status := FND_API.G_RET_STS_ERROR;
1836: fnd_message.set_name('ONT', 'OE_PJM_NOT_INSTALLED');
1837: OE_MSG_PUB.add;
1838:
1839: END IF;
1840:

Line 1856: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJ_UPD');

1852: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1853: --AND p_line_rec.line_id <> p_line_rec.ato_line_id
1854: THEN
1855:
1856: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJ_UPD');
1857: OE_MSG_PUB.add;
1858:
1859:
1860: END IF;

Line 1878: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');

1874: , p_line_rec.ordered_item
1875: , p_line_rec.sold_to_org_id)
1876: THEN
1877: l_return_status := FND_API.G_RET_STS_ERROR;
1878: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');
1879: OE_MSG_PUB.add;
1880: END IF;
1881:
1882: END IF;

Line 1896: fnd_message.set_name('ONT', 'OE_RETURN_ITEM_MISMATCH_REJECT');

1892: , p_line_rec.inventory_item_id
1893: )
1894: THEN
1895: l_return_status := FND_API.G_RET_STS_ERROR;
1896: fnd_message.set_name('ONT', 'OE_RETURN_ITEM_MISMATCH_REJECT');
1897: OE_MSG_PUB.add;
1898: END IF;
1899: END IF;
1900:

Line 1912: fnd_message.set_name('ONT', 'OE_UNFULFILLED_LINE_REJECT');

1908: ( p_line_rec.reference_line_id
1909: )
1910: THEN
1911: l_return_status := FND_API.G_RET_STS_ERROR;
1912: fnd_message.set_name('ONT', 'OE_UNFULFILLED_LINE_REJECT');
1913: OE_MSG_PUB.add;
1914: END IF;
1915:
1916: END IF;

Line 1928: fnd_message.set_name('ONT', 'OE_ITEM_NOT_RETURNABLE');

1924: IF NOT Validate_Return_Item(p_line_rec.inventory_item_id,
1925: p_line_rec.ship_from_org_id)
1926: THEN
1927: l_return_status := FND_API.G_RET_STS_ERROR;
1928: fnd_message.set_name('ONT', 'OE_ITEM_NOT_RETURNABLE');
1929: OE_MSG_PUB.add;
1930: END IF;
1931: END IF;
1932:

Line 1956: fnd_message.set_name('ONT','OE_SERIAL_REFERENCED_RMA');

1952: p_line_rec.return_context = 'SERIAL' and
1953: NVL(p_line_rec.ordered_quantity,1) <> 1)
1954: THEN
1955: l_return_status := FND_API.G_RET_STS_ERROR;
1956: fnd_message.set_name('ONT','OE_SERIAL_REFERENCED_RMA');
1957: OE_MSG_PUB.Add;
1958: END IF;
1959:
1960:

Line 1972: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

1968: IF NOT Validate_Ship_To_Org(p_line_rec.ship_to_org_id,
1969: p_line_rec.sold_to_org_id
1970: ) THEN
1971: l_return_status := FND_API.G_RET_STS_ERROR;
1972: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1973: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1974: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
1975: OE_MSG_PUB.Add;
1976: END IF;

Line 1973: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1969: p_line_rec.sold_to_org_id
1970: ) THEN
1971: l_return_status := FND_API.G_RET_STS_ERROR;
1972: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1973: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1974: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
1975: OE_MSG_PUB.Add;
1976: END IF;
1977:

Line 2008: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2004:
2005: EXCEPTION
2006: WHEN NO_DATA_FOUND THEN
2007: l_return_status := FND_API.G_RET_STS_ERROR;
2008: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2010: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
2011: OE_MSG_PUB.Add;
2012: WHEN OTHERS THEN

Line 2009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2005: EXCEPTION
2006: WHEN NO_DATA_FOUND THEN
2007: l_return_status := FND_API.G_RET_STS_ERROR;
2008: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2010: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
2011: OE_MSG_PUB.Add;
2012: WHEN OTHERS THEN
2013: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2034: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

2030: IF NOT Validate_Deliver_To_Org(p_line_rec.deliver_to_org_id,
2031: p_line_rec.sold_to_org_id
2032: ) THEN
2033: l_return_status := FND_API.G_RET_STS_ERROR;
2034: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2035: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2036: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
2037: OE_MSG_PUB.Add;
2038: END IF;

Line 2035: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2031: p_line_rec.sold_to_org_id
2032: ) THEN
2033: l_return_status := FND_API.G_RET_STS_ERROR;
2034: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2035: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2036: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
2037: OE_MSG_PUB.Add;
2038: END IF;
2039:

Line 2069: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2065:
2066: EXCEPTION
2067: WHEN NO_DATA_FOUND THEN
2068: l_return_status := FND_API.G_RET_STS_ERROR;
2069: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2070: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2071: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
2072: OE_MSG_PUB.Add;
2073: WHEN OTHERS THEN

Line 2070: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2066: EXCEPTION
2067: WHEN NO_DATA_FOUND THEN
2068: l_return_status := FND_API.G_RET_STS_ERROR;
2069: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2070: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2071: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
2072: OE_MSG_PUB.Add;
2073: WHEN OTHERS THEN
2074: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2145: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2141:
2142: EXCEPTION
2143: WHEN NO_DATA_FOUND THEN
2144: l_return_status := FND_API.G_RET_STS_ERROR;
2145: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2147: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
2148: OE_MSG_PUB.Add;
2149: WHEN OTHERS THEN

Line 2146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2142: EXCEPTION
2143: WHEN NO_DATA_FOUND THEN
2144: l_return_status := FND_API.G_RET_STS_ERROR;
2145: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2147: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
2148: OE_MSG_PUB.Add;
2149: WHEN OTHERS THEN
2150: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2187: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2183:
2184: EXCEPTION
2185: WHEN NO_DATA_FOUND THEN
2186: l_return_status := FND_API.G_RET_STS_ERROR;
2187: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2189: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
2190: OE_MSG_PUB.Add;
2191: WHEN OTHERS THEN

Line 2188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2184: EXCEPTION
2185: WHEN NO_DATA_FOUND THEN
2186: l_return_status := FND_API.G_RET_STS_ERROR;
2187: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2189: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
2190: OE_MSG_PUB.Add;
2191: WHEN OTHERS THEN
2192: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2252: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2248: EXCEPTION
2249:
2250: WHEN NO_DATA_FOUND THEN
2251: l_return_status := FND_API.G_RET_STS_ERROR;
2252: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2253: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2254: OE_Order_Util.Get_Attribute_Name('TAX_CODE'));
2255: OE_MSG_PUB.Add;
2256:

Line 2253: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2249:
2250: WHEN NO_DATA_FOUND THEN
2251: l_return_status := FND_API.G_RET_STS_ERROR;
2252: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2253: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2254: OE_Order_Util.Get_Attribute_Name('TAX_CODE'));
2255: OE_MSG_PUB.Add;
2256:
2257: WHEN OTHERS THEN

Line 2281: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

2277: THEN
2278: l_return_status := FND_API.G_RET_STS_ERROR;
2279: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
2280: THEN
2281: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2283: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
2284: OE_MSG_PUB.Add;
2285: END IF;

Line 2282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2278: l_return_status := FND_API.G_RET_STS_ERROR;
2279: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
2280: THEN
2281: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2283: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
2284: OE_MSG_PUB.Add;
2285: END IF;
2286: END IF;

Line 2303: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');

2299: THEN
2300: l_return_status := FND_API.G_RET_STS_ERROR;
2301: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
2302: THEN
2303: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');
2304: OE_MSG_PUB.Add;
2305: END IF;
2306:
2307: END IF; -- If Tax handling is Required

Line 2393: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

2389: l_return_status := FND_API.G_RET_STS_ERROR;
2390:
2391: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2392: THEN
2393: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2395: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
2396: OE_MSG_PUB.Add;
2397: END IF;

Line 2394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2390:
2391: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2392: THEN
2393: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2395: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
2396: OE_MSG_PUB.Add;
2397: END IF;
2398:

Line 2439: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');

2435: IF l_uom <> p_line_rec.order_quantity_uom
2436: THEN
2437: oe_debug_pub.add('uom other than primary uom is entered', 1);
2438:
2439: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2440: fnd_message.set_token('ITEM',p_line_rec.ordered_item );
2441: fnd_message.set_token('UOM', l_uom);
2442: OE_MSG_PUB.Add;
2443: RAISE FND_API.G_EXC_ERROR;

Line 2440: fnd_message.set_token('ITEM',p_line_rec.ordered_item );

2436: THEN
2437: oe_debug_pub.add('uom other than primary uom is entered', 1);
2438:
2439: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2440: fnd_message.set_token('ITEM',p_line_rec.ordered_item );
2441: fnd_message.set_token('UOM', l_uom);
2442: OE_MSG_PUB.Add;
2443: RAISE FND_API.G_EXC_ERROR;
2444: END IF;

Line 2441: fnd_message.set_token('UOM', l_uom);

2437: oe_debug_pub.add('uom other than primary uom is entered', 1);
2438:
2439: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2440: fnd_message.set_token('ITEM',p_line_rec.ordered_item );
2441: fnd_message.set_token('UOM', l_uom);
2442: OE_MSG_PUB.Add;
2443: RAISE FND_API.G_EXC_ERROR;
2444: END IF;
2445: EXCEPTION

Line 2464: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');

2460:
2461:
2462: IF l_uom_count = 0 THEN
2463: oe_debug_pub.add('uom/item combination invalid',2);
2464: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
2465: OE_MSG_PUB.Add;
2466: RAISE FND_API.G_EXC_ERROR;
2467: END IF;
2468: */

Line 2480: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');

2476: if l_debug_level > 0 then
2477: oe_debug_pub.add('uom/item combination invalid',2);
2478: end if;
2479:
2480: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
2481: OE_MSG_PUB.Add;
2482: RAISE FND_API.G_EXC_ERROR;
2483: END IF;
2484:

Line 2522: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');

2518: IF NOT OE_GLOBALS.EQUAL(l_list_type_code,'PRL') THEN
2519: -- any price list with 'PRL' type should be allowed to
2520: -- be associated with any agreement according to bug 1386406.
2521: IF NOT OE_GLOBALS.EQUAL(l_price_list_id, p_line_rec.price_list_id) THEN
2522: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
2523: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2524: BEGIN
2525: SELECT name
2526: INTO l_price_list_name

Line 2523: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);

2519: -- any price list with 'PRL' type should be allowed to
2520: -- be associated with any agreement according to bug 1386406.
2521: IF NOT OE_GLOBALS.EQUAL(l_price_list_id, p_line_rec.price_list_id) THEN
2522: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
2523: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2524: BEGIN
2525: SELECT name
2526: INTO l_price_list_name
2527: FROM qp_List_headers_vl

Line 2533: fnd_message.set_Token('PRICE_LIST1', l_price_list_name);

2529:
2530: Exception when no_data_found then
2531: l_price_list_name := p_line_rec.price_list_id;
2532: END;
2533: fnd_message.set_Token('PRICE_LIST1', l_price_list_name);
2534: BEGIN
2535:
2536: SELECT name
2537: INTO l_price_list_name

Line 2544: fnd_message.set_Token('PRICE_LIST2', l_price_list_name);

2540: EXCEPTION
2541: WHEN NO_DATA_FOUND THEN
2542: l_price_list_name := l_price_list_id;
2543: END;
2544: fnd_message.set_Token('PRICE_LIST2', l_price_list_name);
2545: OE_MSG_PUB.Add;
2546: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
2547: raise FND_API.G_EXC_ERROR;
2548: END IF;

Line 2556: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');

2552: -- modified by lkxu, to check for customer relationships.
2553: IF l_sold_to_org IS NOT NULL AND l_sold_to_org <> -1
2554: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_line_rec.sold_to_org_id) THEN
2555: IF nvl(lcustomer_relations,'N') = 'N' THEN
2556: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2557: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2558: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2559: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
2560: OE_MSG_PUB.Add;

Line 2557: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);

2553: IF l_sold_to_org IS NOT NULL AND l_sold_to_org <> -1
2554: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_line_rec.sold_to_org_id) THEN
2555: IF nvl(lcustomer_relations,'N') = 'N' THEN
2556: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2557: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2558: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2559: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
2560: OE_MSG_PUB.Add;
2561: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);

Line 2558: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);

2554: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_line_rec.sold_to_org_id) THEN
2555: IF nvl(lcustomer_relations,'N') = 'N' THEN
2556: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2557: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2558: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2559: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
2560: OE_MSG_PUB.Add;
2561: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
2562: RAISE FND_API.G_EXC_ERROR;

Line 2559: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);

2555: IF nvl(lcustomer_relations,'N') = 'N' THEN
2556: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2557: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2558: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2559: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
2560: OE_MSG_PUB.Add;
2561: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
2562: RAISE FND_API.G_EXC_ERROR;
2563: ELSIF lcustomer_relations = 'Y' THEN

Line 2582: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');

2578: /* Replaced ra_customer_relationships with HZ Table to fix the bug 1888440 */
2579:
2580: EXCEPTION
2581: WHEN NO_DATA_FOUND THEN
2582: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2583: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2584: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2585: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
2586: OE_MSG_PUB.Add;

Line 2583: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);

2579:
2580: EXCEPTION
2581: WHEN NO_DATA_FOUND THEN
2582: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2583: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2584: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2585: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
2586: OE_MSG_PUB.Add;
2587: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);

Line 2584: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);

2580: EXCEPTION
2581: WHEN NO_DATA_FOUND THEN
2582: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2583: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2584: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2585: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
2586: OE_MSG_PUB.Add;
2587: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
2588: RAISE FND_API.G_EXC_ERROR;

Line 2585: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);

2581: WHEN NO_DATA_FOUND THEN
2582: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2583: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2584: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2585: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
2586: OE_MSG_PUB.Add;
2587: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
2588: RAISE FND_API.G_EXC_ERROR;
2589: END;

Line 2596: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');

2592:
2593:
2594: EXCEPTION
2595: WHEN NO_DATA_FOUND THEN
2596: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2597: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2598: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2599: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
2600: OE_MSG_PUB.Add;

Line 2597: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);

2593:
2594: EXCEPTION
2595: WHEN NO_DATA_FOUND THEN
2596: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2597: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2598: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2599: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
2600: OE_MSG_PUB.Add;
2601: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);

Line 2598: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);

2594: EXCEPTION
2595: WHEN NO_DATA_FOUND THEN
2596: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2597: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2598: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2599: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
2600: OE_MSG_PUB.Add;
2601: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
2602: RAISE FND_API.G_EXC_ERROR;

Line 2599: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);

2595: WHEN NO_DATA_FOUND THEN
2596: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2597: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2598: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2599: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
2600: OE_MSG_PUB.Add;
2601: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
2602: RAISE FND_API.G_EXC_ERROR;
2603: END;

Line 2626: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');

2622: AND list_type_code = 'PRL';
2623:
2624: EXCEPTION
2625: WHEN NO_DATA_FOUND THEN
2626: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
2627: fnd_message.set_Token('PRICE_LIST1', p_line_rec.price_list_id);
2628: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
2629: OE_MSG_PUB.Add;
2630: oe_debug_pub.add('Invalid non agreement price list ',2);

Line 2627: fnd_message.set_Token('PRICE_LIST1', p_line_rec.price_list_id);

2623:
2624: EXCEPTION
2625: WHEN NO_DATA_FOUND THEN
2626: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
2627: fnd_message.set_Token('PRICE_LIST1', p_line_rec.price_list_id);
2628: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
2629: OE_MSG_PUB.Add;
2630: oe_debug_pub.add('Invalid non agreement price list ',2);
2631: RAISE FND_API.G_EXC_ERROR;

Line 2628: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);

2624: EXCEPTION
2625: WHEN NO_DATA_FOUND THEN
2626: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
2627: fnd_message.set_Token('PRICE_LIST1', p_line_rec.price_list_id);
2628: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
2629: OE_MSG_PUB.Add;
2630: oe_debug_pub.add('Invalid non agreement price list ',2);
2631: RAISE FND_API.G_EXC_ERROR;
2632: END;

Line 2657: fnd_message.set_name('ONT', 'OE_LINE_NUMBER_UPD');

2653:
2654: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,null)) THEN
2655:
2656: l_return_status := FND_API.G_RET_STS_ERROR;
2657: fnd_message.set_name('ONT', 'OE_LINE_NUMBER_UPD');
2658: OE_MSG_PUB.add;
2659:
2660: END IF;
2661: END IF;

Line 2693: FND_Message.Set_Name('ONT', 'OE_OTA_INVALID_QTY');

2689:
2690: oe_debug_pub.add('Ordered Qty cannot be greater than 1 for OTA lines',
2691: 1);
2692: l_return_status := FND_API.G_RET_STS_ERROR;
2693: FND_Message.Set_Name('ONT', 'OE_OTA_INVALID_QTY');
2694: oe_msg_pub.add;
2695: END IF;
2696:
2697: /* End of validation for OTA */

Line 2711: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_PO_NUMBER');

2707: (p_line_rec.cust_po_number
2708: ,p_line_rec.sold_to_org_id
2709: ,p_line_rec.header_id )
2710: THEN
2711: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_PO_NUMBER');
2712: OE_MSG_PUB.ADD;
2713: END IF;
2714:
2715: END IF;

Line 2730: fnd_message.set_name('ONT','OE_SERV_END_DATE');

2726:
2727: IF (p_line_rec.service_end_date <= p_line_rec.service_start_date)
2728: THEN
2729: l_return_status := FND_API.G_RET_STS_ERROR;
2730: fnd_message.set_name('ONT','OE_SERV_END_DATE');
2731: OE_MSG_PUB.Add;
2732: END IF;
2733:
2734: END IF;

Line 2787: fnd_message.set_name('ONT', 'OE_BLKT_DISALLOW_CLOSE_REL');

2783: IF p_x_line_rec.blanket_number IS NOT NULL
2784: and p_x_line_rec.blanket_line_number is NOT NULL
2785: THEN
2786: x_return_status := FND_API.G_RET_STS_ERROR;
2787: fnd_message.set_name('ONT', 'OE_BLKT_DISALLOW_CLOSE_REL');
2788: OE_MSG_PUB.add;
2789: END IF;
2790:
2791: -- Validate line attributes