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_VALIDATE_HEADER dependencies on FND_MESSAGE

Line 42: FND_MESSAGE.SET_NAME('ONT','OE_PHASE_UPDATE_NOT_ALLOWED');

38: IF OE_Quote_Util.G_COMPLETE_NEG = 'N' AND
39: NOT OE_GLOBALS.EQUAL(p_header_rec.transaction_phase_code
40: ,p_old_header_rec.transaction_phase_code)
41: THEN
42: FND_MESSAGE.SET_NAME('ONT','OE_PHASE_UPDATE_NOT_ALLOWED');
43: OE_MSG_PUB.ADD;
44: RAISE FND_API.G_EXC_ERROR;
45: END IF;
46:

Line 51: FND_MESSAGE.SET_NAME('ONT','OE_VERSION_NUM_ERROR');

47: -- New version number cannot be lower than previous version
48:
49: IF nvl(p_header_rec.version_number,-1) < p_old_header_rec.version_number
50: THEN
51: FND_MESSAGE.SET_NAME('ONT','OE_VERSION_NUM_ERROR');
52: OE_MSG_PUB.ADD;
53: x_return_status := FND_API.G_RET_STS_ERROR;
54: END IF;
55:

Line 71: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');

67: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
68: p_header_rec.quote_number IS NOT NULL )
69: --OR cnd added for Bug 5060064
70: THEN
71: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');
72: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
73: OE_Order_UTIL.Get_Attribute_Name('QUOTE_NUMBER'));
74: OE_MSG_PUB.ADD;
75: x_return_status := FND_API.G_RET_STS_ERROR;

Line 72: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

68: p_header_rec.quote_number IS NOT NULL )
69: --OR cnd added for Bug 5060064
70: THEN
71: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');
72: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
73: OE_Order_UTIL.Get_Attribute_Name('QUOTE_NUMBER'));
74: OE_MSG_PUB.ADD;
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: END IF;

Line 84: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');

80: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
81: p_header_rec.quote_date IS NOT NULL )
82: --OR cnd added for Bug 5060064
83: THEN
84: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');
85: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
86: OE_Order_UTIL.Get_Attribute_Name('QUOTE_DATE'));
87: OE_MSG_PUB.ADD;
88: x_return_status := FND_API.G_RET_STS_ERROR;

Line 85: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

81: p_header_rec.quote_date IS NOT NULL )
82: --OR cnd added for Bug 5060064
83: THEN
84: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');
85: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
86: OE_Order_UTIL.Get_Attribute_Name('QUOTE_DATE'));
87: OE_MSG_PUB.ADD;
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: END IF;

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

93: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
94: p_header_rec.expiration_date IS NOT NULL )
95: --OR cnd added for Bug 5060064
96: THEN
97: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
99: OE_Order_UTIL.Get_Attribute_Name('EXPIRATION_DATE'));
100: OE_MSG_PUB.ADD;
101: x_return_status := FND_API.G_RET_STS_ERROR;

Line 98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

94: p_header_rec.expiration_date IS NOT NULL )
95: --OR cnd added for Bug 5060064
96: THEN
97: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
99: OE_Order_UTIL.Get_Attribute_Name('EXPIRATION_DATE'));
100: OE_MSG_PUB.ADD;
101: x_return_status := FND_API.G_RET_STS_ERROR;
102: END IF;

Line 120: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');

116: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
117: p_header_rec.order_number IS NOT NULL)
118: --OR cnd added for Bug 5060064
119: THEN
120: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
122: OE_Order_UTIL.Get_Attribute_Name('ORDER_NUMBER'));
123: OE_MSG_PUB.ADD;
124: x_return_status := FND_API.G_RET_STS_ERROR;

Line 121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

117: p_header_rec.order_number IS NOT NULL)
118: --OR cnd added for Bug 5060064
119: THEN
120: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
122: OE_Order_UTIL.Get_Attribute_Name('ORDER_NUMBER'));
123: OE_MSG_PUB.ADD;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: END IF;

Line 133: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');

129: (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
130: p_header_rec.ordered_date IS NOT NULL )
131: --OR cnd added for Bug 5060064
132: THEN
133: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
134: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
135: OE_Order_UTIL.Get_Attribute_Name('ORDERED_DATE'));
136: OE_MSG_PUB.ADD;
137: x_return_status := FND_API.G_RET_STS_ERROR;

Line 134: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

130: p_header_rec.ordered_date IS NOT NULL )
131: --OR cnd added for Bug 5060064
132: THEN
133: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
134: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
135: OE_Order_UTIL.Get_Attribute_Name('ORDERED_DATE'));
136: OE_MSG_PUB.ADD;
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: END IF;

Line 142: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_RETURN_NOT_SUPP');

138: END IF;
139:
140: -- Return orders not supported
141: IF p_header_rec.order_category_code = 'RETURN' THEN
142: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_RETURN_NOT_SUPP');
143: OE_MSG_PUB.ADD;
144: x_return_status := FND_API.G_RET_STS_ERROR;
145: END IF;
146:

Line 149: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_INT_ORD_NOT_SUPP');

145: END IF;
146:
147: -- Internal sales orders not allowed
148: IF p_header_rec.order_source_id = 10 THEN
149: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_INT_ORD_NOT_SUPP');
150: OE_MSG_PUB.ADD;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: END IF;
153:

Line 156: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_CANCEL_NOT_SUPP');

152: END IF;
153:
154: -- Cancellation operation not supported for quotes
155: IF p_header_rec.cancelled_flag = 'Y' THEN
156: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_CANCEL_NOT_SUPP');
157: OE_MSG_PUB.ADD;
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: END IF;
160:

Line 205: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

201:
202: IF p_header_rec.sold_to_org_id IS NULL
203: THEN
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
206: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
207: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
208: OE_MSG_PUB.ADD;
209: END IF;

Line 206: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

202: IF p_header_rec.sold_to_org_id IS NULL
203: THEN
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
206: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
207: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
208: OE_MSG_PUB.ADD;
209: END IF;
210:

Line 214: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

210:
211: IF p_header_rec.salesrep_id IS NULL
212: THEN
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
215: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
216: OE_Order_UTIL.Get_Attribute_Name('SALESREP_ID'));
217: OE_MSG_PUB.ADD;
218: END IF;

Line 215: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

211: IF p_header_rec.salesrep_id IS NULL
212: THEN
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
215: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
216: OE_Order_UTIL.Get_Attribute_Name('SALESREP_ID'));
217: OE_MSG_PUB.ADD;
218: END IF;
219:

Line 223: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

219:
220: IF p_header_rec.ordered_date IS NULL
221: THEN
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
224: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
225: OE_Order_UTIL.Get_Attribute_Name('ORDERED_DATE'));
226: OE_MSG_PUB.ADD;
227: END IF;

Line 224: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

220: IF p_header_rec.ordered_date IS NULL
221: THEN
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
224: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
225: OE_Order_UTIL.Get_Attribute_Name('ORDERED_DATE'));
226: OE_MSG_PUB.ADD;
227: END IF;
228:

Line 232: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

228:
229: IF p_header_rec.invoice_to_org_id IS NULL
230: THEN
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
233: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
234: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
235: OE_MSG_PUB.ADD;
236: END IF;

Line 233: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

229: IF p_header_rec.invoice_to_org_id IS NULL
230: THEN
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
233: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
234: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
235: OE_MSG_PUB.ADD;
236: END IF;
237:

Line 241: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

237:
238: IF p_header_rec.tax_exempt_flag IS NULL
239: THEN
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
242: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
243: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
244: OE_MSG_PUB.ADD;
245: END IF;

Line 242: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

238: IF p_header_rec.tax_exempt_flag IS NULL
239: THEN
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
242: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
243: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
244: OE_MSG_PUB.ADD;
245: END IF;
246:

Line 258: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

254:
255: IF p_header_rec.ship_to_org_id IS NULL
256: THEN
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
260: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
261: OE_MSG_PUB.ADD;
262: END IF;

Line 259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

255: IF p_header_rec.ship_to_org_id IS NULL
256: THEN
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
260: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
261: OE_MSG_PUB.ADD;
262: END IF;
263:

Line 267: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

263:
264: IF p_header_rec.payment_term_id IS NULL
265: THEN
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
268: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
269: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
270: OE_MSG_PUB.ADD;
271: END IF;

Line 268: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

264: IF p_header_rec.payment_term_id IS NULL
265: THEN
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
268: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
269: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
270: OE_MSG_PUB.ADD;
271: END IF;
272:

Line 278: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_FIRMED_DATE_INVALID');

274:
275: --key transaction dates
276: IF (OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' and p_header_rec.order_firmed_date > p_header_rec.booked_date) THEN
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_FIRMED_DATE_INVALID');
279: OE_MSG_PUB.ADD;
280: END IF;
281: --end
282:

Line 293: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

289: IF ( l_order_type_rec.agreement_required_flag = 'Y' AND
290: p_header_rec.agreement_id IS NULL)
291: THEN
292: x_return_status := FND_API.G_RET_STS_ERROR;
293: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
294: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
295: OE_Order_UTIL.Get_Attribute_Name('AGREEMENT_ID'));
296: OE_MSG_PUB.ADD;
297: END IF;

Line 294: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

290: p_header_rec.agreement_id IS NULL)
291: THEN
292: x_return_status := FND_API.G_RET_STS_ERROR;
293: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
294: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
295: OE_Order_UTIL.Get_Attribute_Name('AGREEMENT_ID'));
296: OE_MSG_PUB.ADD;
297: END IF;
298:

Line 303: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

299: IF ( l_order_type_rec.require_po_flag = 'Y' AND
300: p_header_rec.cust_po_number IS NULL)
301: THEN
302: x_return_status := FND_API.G_RET_STS_ERROR;
303: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
305: OE_Order_UTIL.Get_Attribute_Name('CUST_PO_NUMBER'));
306: OE_MSG_PUB.ADD;
307: END IF;

Line 304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

300: p_header_rec.cust_po_number IS NULL)
301: THEN
302: x_return_status := FND_API.G_RET_STS_ERROR;
303: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
305: OE_Order_UTIL.Get_Attribute_Name('CUST_PO_NUMBER'));
306: OE_MSG_PUB.ADD;
307: END IF;
308:

Line 322: FND_MESSAGE.SET_NAME('ONT','OE_VAL_REQ_NON_BASE_CURRENCY');

318:
319: IF ( l_set_of_books_rec.currency_code <>
320: p_header_rec.transactional_curr_code) THEN
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: FND_MESSAGE.SET_NAME('ONT','OE_VAL_REQ_NON_BASE_CURRENCY');
323: FND_MESSAGE.SET_TOKEN
324: ('ORDER_CURRENCY',p_header_rec.transactional_curr_code);
325: FND_MESSAGE.SET_TOKEN('SOB_CURRENCY',l_set_of_books_rec.currency_code);
326: OE_MSG_PUB.ADD;

Line 323: FND_MESSAGE.SET_TOKEN

319: IF ( l_set_of_books_rec.currency_code <>
320: p_header_rec.transactional_curr_code) THEN
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: FND_MESSAGE.SET_NAME('ONT','OE_VAL_REQ_NON_BASE_CURRENCY');
323: FND_MESSAGE.SET_TOKEN
324: ('ORDER_CURRENCY',p_header_rec.transactional_curr_code);
325: FND_MESSAGE.SET_TOKEN('SOB_CURRENCY',l_set_of_books_rec.currency_code);
326: OE_MSG_PUB.ADD;
327: END IF;

Line 325: FND_MESSAGE.SET_TOKEN('SOB_CURRENCY',l_set_of_books_rec.currency_code);

321: x_return_status := FND_API.G_RET_STS_ERROR;
322: FND_MESSAGE.SET_NAME('ONT','OE_VAL_REQ_NON_BASE_CURRENCY');
323: FND_MESSAGE.SET_TOKEN
324: ('ORDER_CURRENCY',p_header_rec.transactional_curr_code);
325: FND_MESSAGE.SET_TOKEN('SOB_CURRENCY',l_set_of_books_rec.currency_code);
326: OE_MSG_PUB.ADD;
327: END IF;
328:
329: -- IF conversion type is 'User', conversion rate AND conversion rate date

Line 339: FND_MESSAGE.SET_NAME('ONT','OE_VAL_USER_CONVERSION_TYPE');

335: IF p_header_rec.conversion_rate IS NULL OR
336: p_header_rec.conversion_rate_date IS NULL
337: THEN
338: x_return_status := FND_API.G_RET_STS_ERROR;
339: FND_MESSAGE.SET_NAME('ONT','OE_VAL_USER_CONVERSION_TYPE');
340: OE_MSG_PUB.ADD;
341: END IF;
342: END IF; -- END of checks based on conversion type
343:

Line 356: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

352: AND p_header_rec.payment_type_code <> 'CREDIT_CARD'
353: AND p_header_rec.payment_amount IS NULL
354: THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
357: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
358: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_AMOUNT'));
359: OE_MSG_PUB.ADD;
360: END IF;

Line 357: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

353: AND p_header_rec.payment_amount IS NULL
354: THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
357: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
358: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_AMOUNT'));
359: OE_MSG_PUB.ADD;
360: END IF;
361:

Line 368: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CHECK_NUM_REQD');

364: IF (p_header_rec.payment_type_code = 'CHECK' AND
365: p_header_rec.check_number IS NULL )
366: THEN
367: x_return_status := FND_API.G_RET_STS_ERROR;
368: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CHECK_NUM_REQD');
369: OE_MSG_PUB.ADD;
370: END IF;
371:
372: -- credit card holder name, number AND expiration date

Line 384: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CREDIT_CARD_REQD');

380: OR p_header_rec.credit_card_number IS NULL
381: OR p_header_rec.credit_card_expiration_date IS NULL
382: THEN
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CREDIT_CARD_REQD');
385: OE_MSG_PUB.ADD;
386: END IF;
387: END IF;
388: */

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

447:
448: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.Validate_Order_Type',1);
449: EXCEPTION
450: WHEN NO_DATA_FOUND THEN
451: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
452: OE_MSG_PUB.ADD;
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454:
455: WHEN OTHERS THEN

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

515: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.Validate_Commitment_Currency',1);
516:
517: EXCEPTION
518: WHEN NO_DATA_FOUND THEN
519: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
520: OE_MSG_PUB.ADD;
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522:
523: WHEN OTHERS THEN

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

619: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.Validate_Commitment_Customer',1);
620:
621: EXCEPTION
622: WHEN NO_DATA_FOUND THEN
623: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
624: OE_MSG_PUB.ADD;
625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
626:
627: WHEN OTHERS THEN

Line 746: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NO_BLANKET_LINE_NUM');

742: OE_DEBUG_PUB.Add('Blanket Number :'||p_header_rec.blanket_number,1);
743: end if;
744:
745: IF p_header_rec.blanket_number IS NULL THEN
746: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NO_BLANKET_LINE_NUM');
747: OE_MSG_PUB.Add;
748: x_return_status := FND_API.G_RET_STS_ERROR;
749: RETURN;
750: END IF;

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

772:
773: EXCEPTION
774:
775: WHEN NO_DATA_FOUND THEN
776: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
777: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
778: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
779: OE_MSG_PUB.Add;
780: if l_debug_level > 0 then

Line 777: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

773: EXCEPTION
774:
775: WHEN NO_DATA_FOUND THEN
776: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
777: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
778: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
779: OE_MSG_PUB.Add;
780: if l_debug_level > 0 then
781: OE_DEBUG_PUB.Add('No Data Found when Validating Blanket',3);

Line 810: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');

806: AND STATUS = 'A'
807: AND ROWNUM = 1;
808: exception
809: when no_data_found then
810: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
812: ('SOLD_TO_ORG_ID'));
813: --for bug 3257240
814: OE_Id_To_Value.Sold_To_Org

Line 811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name

807: AND ROWNUM = 1;
808: exception
809: when no_data_found then
810: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
812: ('SOLD_TO_ORG_ID'));
813: --for bug 3257240
814: OE_Id_To_Value.Sold_To_Org
815: ( p_sold_to_org_id => l_sold_to_org_id

Line 819: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_customer_name);

815: ( p_sold_to_org_id => l_sold_to_org_id
816: , x_org => l_customer_name
817: , x_customer_number => l_customer_number
818: );
819: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_customer_name);
820: OE_MSG_PUB.Add;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: end;
823: else

Line 824: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');

820: OE_MSG_PUB.Add;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: end;
823: else
824: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
825: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
826: ('SOLD_TO_ORG_ID'));
827: --for bug 3257240
828: OE_Id_To_Value.Sold_To_Org

Line 825: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name

821: x_return_status := FND_API.G_RET_STS_ERROR;
822: end;
823: else
824: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
825: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
826: ('SOLD_TO_ORG_ID'));
827: --for bug 3257240
828: OE_Id_To_Value.Sold_To_Org
829: ( p_sold_to_org_id => l_sold_to_org_id

Line 833: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_customer_name);

829: ( p_sold_to_org_id => l_sold_to_org_id
830: , x_org => l_customer_name
831: , x_customer_number => l_customer_number
832: );
833: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_customer_name);
834: OE_MSG_PUB.Add;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: end if;
837: END IF;

Line 845: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_ON_HOLD');

841: ,p_old_header_rec.blanket_number) ) THEN
842: if l_debug_level > 0 then
843: OE_DEBUG_PUB.Add('Blanket order is currently on hold', 1);
844: end if;
845: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_ON_HOLD');
846: OE_MSG_PUB.Add;
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: END IF;
849:

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

857: AND trunc(nvl(l_end_date_active, nvl(p_header_rec.request_date,sysdate)))) THEN
858: if l_debug_level > 0 then
859: oe_debug_pub.add('Request date is not within active blanket dates', 1);
860: end if;
861: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
862: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
863: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
864: OE_MSG_PUB.Add;
865: x_return_status := FND_API.G_RET_STS_ERROR;

Line 862: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

858: if l_debug_level > 0 then
859: oe_debug_pub.add('Request date is not within active blanket dates', 1);
860: end if;
861: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
862: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
863: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
864: OE_MSG_PUB.Add;
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: END IF;

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

871: THEN
872: if l_debug_level > 0 then
873: oe_debug_pub.add('Not an active Blanket for Release', 1);
874: end if;
875: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
876: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
877: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
878: OE_MSG_PUB.Add;
879: x_return_status := FND_API.G_RET_STS_ERROR;

Line 876: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

872: if l_debug_level > 0 then
873: oe_debug_pub.add('Not an active Blanket for Release', 1);
874: end if;
875: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
876: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
877: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
878: OE_MSG_PUB.Add;
879: x_return_status := FND_API.G_RET_STS_ERROR;
880: END IF;

Line 883: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_AGREEMENT_EXISTS');

879: x_return_status := FND_API.G_RET_STS_ERROR;
880: END IF;
881:
882: IF p_header_rec.agreement_id IS NOT NULL THEN
883: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_AGREEMENT_EXISTS');
884: OE_MSG_PUB.Add;
885: x_return_status := FND_API.G_RET_STS_ERROR;
886: END IF;
887: if l_debug_level > 0 then

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

1008: l_return_status := FND_API.G_RET_STS_ERROR;
1009:
1010: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1011: THEN
1012: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1013: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1014: OE_Order_UTIL.Get_Attribute_Name('HEADER_ID'));
1015: OE_MSG_PUB.Add;
1016: END IF;

Line 1013: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1009:
1010: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1011: THEN
1012: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1013: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1014: OE_Order_UTIL.Get_Attribute_Name('HEADER_ID'));
1015: OE_MSG_PUB.Add;
1016: END IF;
1017:

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

1025: l_return_status := FND_API.G_RET_STS_ERROR;
1026:
1027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1028: THEN
1029: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1030: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1031: OE_Order_UTIL.Get_Attribute_Name('TRANSACTION_PHASE_CODE'));
1032: OE_MSG_PUB.Add;
1033: END IF;

Line 1030: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1026:
1027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1028: THEN
1029: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1030: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1031: OE_Order_UTIL.Get_Attribute_Name('TRANSACTION_PHASE_CODE'));
1032: OE_MSG_PUB.Add;
1033: END IF;
1034:

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

1044: l_return_status := FND_API.G_RET_STS_ERROR;
1045:
1046: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1047: THEN
1048: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1049: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1050: OE_Order_UTIL.Get_Attribute_Name('ORDER_TYPE_ID'));
1051: OE_MSG_PUB.Add;
1052: END IF;

Line 1049: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1045:
1046: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1047: THEN
1048: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1049: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1050: OE_Order_UTIL.Get_Attribute_Name('ORDER_TYPE_ID'));
1051: OE_MSG_PUB.Add;
1052: END IF;
1053: ELSE

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

1064: l_return_status := FND_API.G_RET_STS_ERROR;
1065:
1066: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1067: THEN
1068: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1070: OE_Order_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE'));
1071: OE_MSG_PUB.Add;
1072: END IF;

Line 1069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1065:
1066: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1067: THEN
1068: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1070: OE_Order_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE'));
1071: OE_MSG_PUB.Add;
1072: END IF;
1073:

Line 1102: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_INVALID_RELEASE');

1098: ELSE
1099:
1100: -- Feature not supported prior to 11i10, raise error
1101: IF p_header_rec.transaction_phase_code = 'N' THEN
1102: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_INVALID_RELEASE');
1103: OE_MSG_PUB.ADD;
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;
1106:

Line 1138: fnd_message.set_name('ONT','OE_NO_TAX_EXEMPTION');

1134: l_return_status := FND_API.G_RET_STS_ERROR;
1135:
1136: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1137: THEN
1138: fnd_message.set_name('ONT','OE_NO_TAX_EXEMPTION');
1139: OE_MSG_PUB.Add;
1140: END IF;
1141: END IF;
1142:

Line 1158: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_REQUIRED');

1154: l_return_status := FND_API.G_RET_STS_ERROR;
1155:
1156: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1157: THEN
1158: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_REQUIRED');
1159: OE_MSG_PUB.Add;
1160: END IF;
1161:
1162: END IF; */

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

1169: l_return_status := FND_API.G_RET_STS_ERROR;
1170:
1171: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1172: THEN
1173: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1174: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1175: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
1176: OE_MSG_PUB.Add;
1177: END IF;

Line 1174: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1170:
1171: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1172: THEN
1173: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1174: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1175: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
1176: OE_MSG_PUB.Add;
1177: END IF;
1178:

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

1193: l_return_status := FND_API.G_RET_STS_ERROR;
1194:
1195: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1196: THEN
1197: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');
1198: OE_MSG_PUB.Add;
1199: END IF;
1200: END IF;
1201:

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

1223: l_return_status := FND_API.G_RET_STS_ERROR;
1224:
1225: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1226: THEN
1227: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1228: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('CHECK_NUMBER'));
1229: OE_MSG_PUB.Add;
1230: END IF;
1231: END IF;

Line 1228: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('CHECK_NUMBER'));

1224:
1225: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1226: THEN
1227: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1228: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('CHECK_NUMBER'));
1229: OE_MSG_PUB.Add;
1230: END IF;
1231: END IF;
1232: END IF;

Line 1241: fnd_message.set_name('ONT','OE_VAL_CREDIT_CARD_REQD');

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

Line 1242: --FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('CREDIT_CARD_CODE'));

1238: l_return_status := FND_API.G_RET_STS_ERROR;
1239: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1240: THEN
1241: fnd_message.set_name('ONT','OE_VAL_CREDIT_CARD_REQD');
1242: --FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('CREDIT_CARD_CODE'));
1243: OE_MSG_PUB.Add;
1244: END IF;
1245: END IF;
1246: END IF;

Line 1343: fnd_message.set_name('ONT','OE_VAL_ORD_CURRENCY_MISMATCH');

1339:
1340: ELSE
1341: --no frozen lines, error condition
1342: l_return_status := FND_API.G_RET_STS_ERROR;
1343: fnd_message.set_name('ONT','OE_VAL_ORD_CURRENCY_MISMATCH');
1344: FND_MESSAGE.SET_TOKEN('ORDER_CURRENCY',p_header_rec.transactional_curr_code);
1345: FND_MESSAGE.SET_TOKEN('PRICE_LIST_CURRENCY',l_price_list_rec.currency_code);
1346: OE_MSG_PUB.Add;
1347: END IF;

Line 1344: FND_MESSAGE.SET_TOKEN('ORDER_CURRENCY',p_header_rec.transactional_curr_code);

1340: ELSE
1341: --no frozen lines, error condition
1342: l_return_status := FND_API.G_RET_STS_ERROR;
1343: fnd_message.set_name('ONT','OE_VAL_ORD_CURRENCY_MISMATCH');
1344: FND_MESSAGE.SET_TOKEN('ORDER_CURRENCY',p_header_rec.transactional_curr_code);
1345: FND_MESSAGE.SET_TOKEN('PRICE_LIST_CURRENCY',l_price_list_rec.currency_code);
1346: OE_MSG_PUB.Add;
1347: END IF;
1348: End;

Line 1345: FND_MESSAGE.SET_TOKEN('PRICE_LIST_CURRENCY',l_price_list_rec.currency_code);

1341: --no frozen lines, error condition
1342: l_return_status := FND_API.G_RET_STS_ERROR;
1343: fnd_message.set_name('ONT','OE_VAL_ORD_CURRENCY_MISMATCH');
1344: FND_MESSAGE.SET_TOKEN('ORDER_CURRENCY',p_header_rec.transactional_curr_code);
1345: FND_MESSAGE.SET_TOKEN('PRICE_LIST_CURRENCY',l_price_list_rec.currency_code);
1346: OE_MSG_PUB.Add;
1347: END IF;
1348: End;
1349: END IF;

Line 1365: Fnd_Message.Set_Name('ONT','ONT_INVALID_CURR_CHANGE');

1361: ,x_return_status => l_comt_curr_status);
1362:
1363: IF l_comt_curr_status = FND_API.G_RET_STS_ERROR THEN
1364: l_return_status := FND_API.G_RET_STS_ERROR;
1365: Fnd_Message.Set_Name('ONT','ONT_INVALID_CURR_CHANGE');
1366: Fnd_message.set_token('REASON','ONT_COMMITMENT_ON_LINE',TRUE);
1367: OE_MSG_PUB.Add;
1368: oe_debug_pub.add('Error: currency code does not match the currency for the commitment.', 3);
1369: RAISE FND_API.G_EXC_ERROR;

Line 1366: Fnd_message.set_token('REASON','ONT_COMMITMENT_ON_LINE',TRUE);

1362:
1363: IF l_comt_curr_status = FND_API.G_RET_STS_ERROR THEN
1364: l_return_status := FND_API.G_RET_STS_ERROR;
1365: Fnd_Message.Set_Name('ONT','ONT_INVALID_CURR_CHANGE');
1366: Fnd_message.set_token('REASON','ONT_COMMITMENT_ON_LINE',TRUE);
1367: OE_MSG_PUB.Add;
1368: oe_debug_pub.add('Error: currency code does not match the currency for the commitment.', 3);
1369: RAISE FND_API.G_EXC_ERROR;
1370: END IF;

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

1379: Nvl(p_header_rec.conversion_rate_date, FND_API.G_MISS_DATE)
1380: <> FND_API.G_MISS_DATE
1381: THEN
1382: l_return_status := FND_API.G_RET_STS_ERROR;
1383: fnd_message.set_name('ONT','OE_VAL_CONVERSION_TYPE');
1384: OE_MSG_PUB.Add;
1385: END IF;
1386:
1387: END IF;

Line 1394: FND_MESSAGE.SET_NAME('ONT','OE_VALIDATION_CONV_TYPE');

1390: IF p_header_rec.conversion_type_code <> 'User' AND
1391: p_header_rec.conversion_rate IS NOT NULL
1392: THEN
1393: l_return_status := FND_API.G_RET_STS_ERROR;
1394: FND_MESSAGE.SET_NAME('ONT','OE_VALIDATION_CONV_TYPE');
1395: OE_MSG_PUB.ADD;
1396:
1397: END IF; -- END of checks based on conversion type
1398:

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

1419:
1420: EXCEPTION
1421: WHEN NO_DATA_FOUND THEN
1422: l_return_status := FND_API.G_RET_STS_ERROR;
1423: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1425: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));
1426: OE_MSG_PUB.Add;
1427:

Line 1424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1420: EXCEPTION
1421: WHEN NO_DATA_FOUND THEN
1422: l_return_status := FND_API.G_RET_STS_ERROR;
1423: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1425: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));
1426: OE_MSG_PUB.Add;
1427:
1428: WHEN OTHERS THEN

Line 1524: fnd_message.set_name('ONT', 'ONT_INVALID_AGREEMENT');

1520: END IF;
1521:
1522: /* End of code added to fix the bug 2824240 */
1523: ELSE
1524: fnd_message.set_name('ONT', 'ONT_INVALID_AGREEMENT');
1525: fnd_message.set_Token('AGREEMENT_NAME',l_agreement_name);
1526: fnd_message.set_Token('REVISION',l_agreement_revision);
1527: OE_MSG_PUB.Add;
1528: oe_debug_pub.add('Invalid Agreement ',1);

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

1521:
1522: /* End of code added to fix the bug 2824240 */
1523: ELSE
1524: fnd_message.set_name('ONT', 'ONT_INVALID_AGREEMENT');
1525: fnd_message.set_Token('AGREEMENT_NAME',l_agreement_name);
1526: fnd_message.set_Token('REVISION',l_agreement_revision);
1527: OE_MSG_PUB.Add;
1528: oe_debug_pub.add('Invalid Agreement ',1);
1529: raise FND_API.G_EXC_ERROR;

Line 1526: fnd_message.set_Token('REVISION',l_agreement_revision);

1522: /* End of code added to fix the bug 2824240 */
1523: ELSE
1524: fnd_message.set_name('ONT', 'ONT_INVALID_AGREEMENT');
1525: fnd_message.set_Token('AGREEMENT_NAME',l_agreement_name);
1526: fnd_message.set_Token('REVISION',l_agreement_revision);
1527: OE_MSG_PUB.Add;
1528: oe_debug_pub.add('Invalid Agreement ',1);
1529: raise FND_API.G_EXC_ERROR;
1530: END IF;

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

1546:
1547: -- Geresh added
1548: IF l_price_list_id <> p_Header_rec.price_list_id
1549: THEN
1550: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
1551: fnd_message.set_Token
1552: ('AGREEMENT_NAME', l_agreement_name || sqlerrm);
1553: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
1554: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);

Line 1551: fnd_message.set_Token

1547: -- Geresh added
1548: IF l_price_list_id <> p_Header_rec.price_list_id
1549: THEN
1550: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
1551: fnd_message.set_Token
1552: ('AGREEMENT_NAME', l_agreement_name || sqlerrm);
1553: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
1554: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);
1555: OE_MSG_PUB.Add;

Line 1553: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);

1549: THEN
1550: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
1551: fnd_message.set_Token
1552: ('AGREEMENT_NAME', l_agreement_name || sqlerrm);
1553: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
1554: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);
1555: OE_MSG_PUB.Add;
1556: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
1557: raise FND_API.G_EXC_ERROR;

Line 1554: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);

1550: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
1551: fnd_message.set_Token
1552: ('AGREEMENT_NAME', l_agreement_name || sqlerrm);
1553: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
1554: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);
1555: OE_MSG_PUB.Add;
1556: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
1557: raise FND_API.G_EXC_ERROR;
1558: END IF;

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

1561: --bug 5206956 to check for customer relationships
1562: IF l_sold_to_org IS NOT NULL AND l_sold_to_org <> -1
1563: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_header_rec.sold_to_org_id) THEN
1564: IF nvl(lcustomer_relations,'N') = 'N' THEN
1565: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
1566: fnd_message.set_Token('AGREEMENT_ID', p_header_rec.agreement_id);
1567: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
1568: fnd_message.set_Token('CUSTOMER_ID', p_header_rec.sold_to_org_id);
1569: OE_MSG_PUB.Add;

Line 1566: fnd_message.set_Token('AGREEMENT_ID', p_header_rec.agreement_id);

1562: IF l_sold_to_org IS NOT NULL AND l_sold_to_org <> -1
1563: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_header_rec.sold_to_org_id) THEN
1564: IF nvl(lcustomer_relations,'N') = 'N' THEN
1565: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
1566: fnd_message.set_Token('AGREEMENT_ID', p_header_rec.agreement_id);
1567: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
1568: fnd_message.set_Token('CUSTOMER_ID', p_header_rec.sold_to_org_id);
1569: OE_MSG_PUB.Add;
1570: IF l_debug_level > 0 then

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

1563: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_header_rec.sold_to_org_id) THEN
1564: IF nvl(lcustomer_relations,'N') = 'N' THEN
1565: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
1566: fnd_message.set_Token('AGREEMENT_ID', p_header_rec.agreement_id);
1567: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
1568: fnd_message.set_Token('CUSTOMER_ID', p_header_rec.sold_to_org_id);
1569: OE_MSG_PUB.Add;
1570: IF l_debug_level > 0 then
1571: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);

Line 1568: fnd_message.set_Token('CUSTOMER_ID', p_header_rec.sold_to_org_id);

1564: IF nvl(lcustomer_relations,'N') = 'N' THEN
1565: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
1566: fnd_message.set_Token('AGREEMENT_ID', p_header_rec.agreement_id);
1567: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
1568: fnd_message.set_Token('CUSTOMER_ID', p_header_rec.sold_to_org_id);
1569: OE_MSG_PUB.Add;
1570: IF l_debug_level > 0 then
1571: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
1572: END IF;

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

1586: );
1587:
1588: EXCEPTION
1589: WHEN NO_DATA_FOUND THEN
1590: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
1591: fnd_message.set_Token('AGREEMENT_ID', p_header_rec.agreement_id);
1592: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
1593: fnd_message.set_Token('CUSTOMER_ID', p_header_rec.sold_to_org_id);
1594: OE_MSG_PUB.Add;

Line 1591: fnd_message.set_Token('AGREEMENT_ID', p_header_rec.agreement_id);

1587:
1588: EXCEPTION
1589: WHEN NO_DATA_FOUND THEN
1590: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
1591: fnd_message.set_Token('AGREEMENT_ID', p_header_rec.agreement_id);
1592: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
1593: fnd_message.set_Token('CUSTOMER_ID', p_header_rec.sold_to_org_id);
1594: OE_MSG_PUB.Add;
1595: IF l_debug_level > 0 then

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

1588: EXCEPTION
1589: WHEN NO_DATA_FOUND THEN
1590: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
1591: fnd_message.set_Token('AGREEMENT_ID', p_header_rec.agreement_id);
1592: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
1593: fnd_message.set_Token('CUSTOMER_ID', p_header_rec.sold_to_org_id);
1594: OE_MSG_PUB.Add;
1595: IF l_debug_level > 0 then
1596: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);

Line 1593: fnd_message.set_Token('CUSTOMER_ID', p_header_rec.sold_to_org_id);

1589: WHEN NO_DATA_FOUND THEN
1590: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
1591: fnd_message.set_Token('AGREEMENT_ID', p_header_rec.agreement_id);
1592: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
1593: fnd_message.set_Token('CUSTOMER_ID', p_header_rec.sold_to_org_id);
1594: OE_MSG_PUB.Add;
1595: IF l_debug_level > 0 then
1596: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
1597: END IF;

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

1604:
1605:
1606: EXCEPTION
1607: WHEN NO_DATA_FOUND THEN
1608: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
1609: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
1610: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
1611: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);
1612: OE_MSG_PUB.Add;

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

1605:
1606: EXCEPTION
1607: WHEN NO_DATA_FOUND THEN
1608: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
1609: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
1610: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
1611: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);
1612: OE_MSG_PUB.Add;
1613: oe_debug_pub.add

Line 1610: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);

1606: EXCEPTION
1607: WHEN NO_DATA_FOUND THEN
1608: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
1609: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
1610: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
1611: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);
1612: OE_MSG_PUB.Add;
1613: oe_debug_pub.add
1614: ('No Data Found Agreement+price_list_id combination',2);

Line 1611: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);

1607: WHEN NO_DATA_FOUND THEN
1608: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
1609: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
1610: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
1611: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);
1612: OE_MSG_PUB.Add;
1613: oe_debug_pub.add
1614: ('No Data Found Agreement+price_list_id combination',2);
1615: raise FND_API.G_EXC_ERROR;

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

1627: l_order_type_rec.agreement_type_code ) THEN
1628: l_return_status := FND_API.G_RET_STS_ERROR;
1629: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1630: THEN
1631: fnd_message.set_name('ONT','OE_INVALID_AGREEMENT');
1632: OE_MSG_PUB.Add;
1633: END IF;
1634: END IF;
1635: ***/

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

1718: WHEN NO_DATA_FOUND THEN
1719: oe_debug_pub.add
1720: ('In: No data found',2);
1721: l_return_status := FND_API.G_RET_STS_ERROR;
1722: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1723: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name
1724: ('ship_to_org_id'));
1725: OE_MSG_PUB.Add;
1726:

Line 1723: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name

1719: oe_debug_pub.add
1720: ('In: No data found',2);
1721: l_return_status := FND_API.G_RET_STS_ERROR;
1722: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1723: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name
1724: ('ship_to_org_id'));
1725: OE_MSG_PUB.Add;
1726:
1727: WHEN OTHERS THEN

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

1811: EXCEPTION
1812:
1813: WHEN NO_DATA_FOUND THEN
1814: l_return_status := FND_API.G_RET_STS_ERROR;
1815: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1816: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1817: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
1818: OE_MSG_PUB.Add;
1819:

Line 1816: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1812:
1813: WHEN NO_DATA_FOUND THEN
1814: l_return_status := FND_API.G_RET_STS_ERROR;
1815: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1816: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1817: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
1818: OE_MSG_PUB.Add;
1819:
1820: WHEN OTHERS THEN

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

1895: EXCEPTION
1896:
1897: WHEN NO_DATA_FOUND THEN
1898: l_return_status := FND_API.G_RET_STS_ERROR;
1899: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1900: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1901: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
1902: OE_MSG_PUB.Add;
1903:

Line 1900: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1896:
1897: WHEN NO_DATA_FOUND THEN
1898: l_return_status := FND_API.G_RET_STS_ERROR;
1899: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1900: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1901: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
1902: OE_MSG_PUB.Add;
1903:
1904: WHEN OTHERS THEN

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

1950: EXCEPTION
1951:
1952: WHEN NO_DATA_FOUND THEN
1953: l_return_status := FND_API.G_RET_STS_ERROR;
1954: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1955: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1956: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
1957: OE_MSG_PUB.Add;
1958:

Line 1955: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1951:
1952: WHEN NO_DATA_FOUND THEN
1953: l_return_status := FND_API.G_RET_STS_ERROR;
1954: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1955: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1956: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
1957: OE_MSG_PUB.Add;
1958:
1959: WHEN OTHERS THEN

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

2002: EXCEPTION
2003:
2004: WHEN NO_DATA_FOUND THEN
2005: l_return_status := FND_API.G_RET_STS_ERROR;
2006: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2007: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2008: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_CONTACT_ID'));
2009: OE_MSG_PUB.Add;
2010:

Line 2007: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

2050: EXCEPTION
2051:
2052: WHEN NO_DATA_FOUND THEN
2053: l_return_status := FND_API.G_RET_STS_ERROR;
2054: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2056: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));
2057: OE_MSG_PUB.Add;
2058:

Line 2055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2051:
2052: WHEN NO_DATA_FOUND THEN
2053: l_return_status := FND_API.G_RET_STS_ERROR;
2054: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2056: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));
2057: OE_MSG_PUB.Add;
2058:
2059: WHEN OTHERS THEN

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

2100: EXCEPTION
2101:
2102: WHEN NO_DATA_FOUND THEN
2103: l_return_status := FND_API.G_RET_STS_ERROR;
2104: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2106: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
2107: OE_MSG_PUB.Add;
2108:

Line 2105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2101:
2102: WHEN NO_DATA_FOUND THEN
2103: l_return_status := FND_API.G_RET_STS_ERROR;
2104: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2106: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
2107: OE_MSG_PUB.Add;
2108:
2109: WHEN OTHERS THEN

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

2157:
2158: WHEN NO_DATA_FOUND THEN
2159:
2160: l_return_status := FND_API.G_RET_STS_ERROR;
2161: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2163: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_CONTACT_ID'));
2164: OE_MSG_PUB.Add;
2165:

Line 2162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2158: WHEN NO_DATA_FOUND THEN
2159:
2160: l_return_status := FND_API.G_RET_STS_ERROR;
2161: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2163: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_CONTACT_ID'));
2164: OE_MSG_PUB.Add;
2165:
2166:

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

2217: EXCEPTION
2218:
2219: WHEN NO_DATA_FOUND THEN
2220: l_return_status := FND_API.G_RET_STS_ERROR;
2221: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2222: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2223: OE_Order_Util.Get_Attribute_Name('SHIP_TO_CONTACT_ID'));
2224: OE_MSG_PUB.Add;
2225:

Line 2222: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2218:
2219: WHEN NO_DATA_FOUND THEN
2220: l_return_status := FND_API.G_RET_STS_ERROR;
2221: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2222: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2223: OE_Order_Util.Get_Attribute_Name('SHIP_TO_CONTACT_ID'));
2224: OE_MSG_PUB.Add;
2225:
2226:

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

2277: EXCEPTION
2278:
2279: WHEN NO_DATA_FOUND THEN
2280: l_return_status := FND_API.G_RET_STS_ERROR;
2281: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2283: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_CONTACT_ID'));
2284: OE_MSG_PUB.Add;
2285:

Line 2282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2278:
2279: WHEN NO_DATA_FOUND THEN
2280: l_return_status := FND_API.G_RET_STS_ERROR;
2281: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2283: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_CONTACT_ID'));
2284: OE_MSG_PUB.Add;
2285:
2286: WHEN OTHERS THEN

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

2409:
2410: oe_debug_pub.Add('Redefault the tax_exempt_number',1);
2411: ELSE
2412: l_return_status := FND_API.G_RET_STS_ERROR;
2413: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2415: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
2416: OE_MSG_PUB.Add;
2417: END IF;

Line 2414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2410: oe_debug_pub.Add('Redefault the tax_exempt_number',1);
2411: ELSE
2412: l_return_status := FND_API.G_RET_STS_ERROR;
2413: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2415: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
2416: OE_MSG_PUB.Add;
2417: END IF;
2418:

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

2453: (p_header_rec.cust_po_number
2454: ,p_header_rec.sold_to_org_id
2455: ,p_header_rec.header_id )
2456: THEN
2457: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_PO_NUMBER');
2458: OE_MSG_PUB.ADD;
2459: END IF;
2460:
2461: END IF;

Line 2499: Fnd_Message.Set_Name('ONT','ONT_COM_CUSTOMER_MISMATCH');

2495: EXCEPTION WHEN NO_DATA_FOUND THEN
2496: null;
2497: END;
2498:
2499: Fnd_Message.Set_Name('ONT','ONT_COM_CUSTOMER_MISMATCH');
2500: Fnd_message.set_token('CUSTOMER',l_customer_name);
2501: OE_MSG_PUB.Add;
2502: oe_debug_pub.add('Error: customer of the order does not match the customer for the commitment.', 3);
2503: RAISE FND_API.G_EXC_ERROR;

Line 2500: Fnd_message.set_token('CUSTOMER',l_customer_name);

2496: null;
2497: END;
2498:
2499: Fnd_Message.Set_Name('ONT','ONT_COM_CUSTOMER_MISMATCH');
2500: Fnd_message.set_token('CUSTOMER',l_customer_name);
2501: OE_MSG_PUB.Add;
2502: oe_debug_pub.add('Error: customer of the order does not match the customer for the commitment.', 3);
2503: RAISE FND_API.G_EXC_ERROR;
2504: END IF;

Line 2518: FND_MESSAGE.Set_Name('ONT','OE_BLANKET_INVALID_VERSION');

2514: If l_debug_level > 0 THEN
2515: OE_DEBUG_PUB.Add('Blankets are only available in Pack I or greater',1);
2516: End if;
2517: l_return_status := FND_API.G_RET_STS_ERROR;
2518: FND_MESSAGE.Set_Name('ONT','OE_BLANKET_INVALID_VERSION');
2519: OE_MSG_PUB.Add;
2520: ELSE
2521: IF p_header_rec.blanket_number IS NOT NULL THEN
2522: Validate_Blanket_Values

Line 2569: fnd_message.Set_Name('ONT','ONT_MULTIPLE_PAYMENTS_EXIST');

2565:
2566: if l_payment_count > 1 then
2567: l_return_status := FND_API.G_RET_STS_ERROR;
2568:
2569: fnd_message.Set_Name('ONT','ONT_MULTIPLE_PAYMENTS_EXIST');
2570: OE_MSG_PUB.Add;
2571: oe_debug_pub.add('Error: multiple payments exist. cannot update order header',3);
2572:
2573: end if;

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

2588: IF (p_header_rec.ib_owner = 'SOLD_TO' AND
2589: p_header_rec.sold_to_org_id is null)
2590: THEN
2591: l_return_status := FND_API.G_RET_STS_ERROR;
2592: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2593: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
2594: OE_MSG_PUB.Add;
2595: ELSIF p_header_rec.ib_owner = 'END_CUSTOMER' AND
2596: p_header_rec.end_customer_id is null

Line 2593: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));

2589: p_header_rec.sold_to_org_id is null)
2590: THEN
2591: l_return_status := FND_API.G_RET_STS_ERROR;
2592: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2593: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
2594: OE_MSG_PUB.Add;
2595: ELSIF p_header_rec.ib_owner = 'END_CUSTOMER' AND
2596: p_header_rec.end_customer_id is null
2597: THEN

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

2595: ELSIF p_header_rec.ib_owner = 'END_CUSTOMER' AND
2596: p_header_rec.end_customer_id is null
2597: THEN
2598: l_return_status := FND_API.G_RET_STS_ERROR;
2599: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
2601: OE_MSG_PUB.Add;
2602: END IF;
2603: END IF;

Line 2600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));

2596: p_header_rec.end_customer_id is null
2597: THEN
2598: l_return_status := FND_API.G_RET_STS_ERROR;
2599: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
2601: OE_MSG_PUB.Add;
2602: END IF;
2603: END IF;
2604: oe_debug_pub.ADD('ib_installed_at_location: '||p_header_rec.ib_installed_at_location);

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

2616: IF (p_header_rec.ib_installed_at_location = 'BILL_TO' AND
2617: p_header_rec.invoice_to_org_id is null)
2618: THEN
2619: l_return_status := FND_API.G_RET_STS_ERROR;
2620: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2621: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2622: OE_MSG_PUB.Add;
2623: ELSIF p_header_rec.ib_installed_at_location = 'SHIP_TO' AND
2624: p_header_rec.ship_to_org_id is null

Line 2621: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));

2617: p_header_rec.invoice_to_org_id is null)
2618: THEN
2619: l_return_status := FND_API.G_RET_STS_ERROR;
2620: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2621: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2622: OE_MSG_PUB.Add;
2623: ELSIF p_header_rec.ib_installed_at_location = 'SHIP_TO' AND
2624: p_header_rec.ship_to_org_id is null
2625: THEN

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

2623: ELSIF p_header_rec.ib_installed_at_location = 'SHIP_TO' AND
2624: p_header_rec.ship_to_org_id is null
2625: THEN
2626: l_return_status := FND_API.G_RET_STS_ERROR;
2627: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2629: OE_MSG_PUB.Add;
2630: ELSIF p_header_rec.ib_installed_at_location = 'DELIVER_TO' AND
2631: p_header_rec.deliver_to_org_id is null

Line 2628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));

2624: p_header_rec.ship_to_org_id is null
2625: THEN
2626: l_return_status := FND_API.G_RET_STS_ERROR;
2627: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2629: OE_MSG_PUB.Add;
2630: ELSIF p_header_rec.ib_installed_at_location = 'DELIVER_TO' AND
2631: p_header_rec.deliver_to_org_id is null
2632: THEN

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

2630: ELSIF p_header_rec.ib_installed_at_location = 'DELIVER_TO' AND
2631: p_header_rec.deliver_to_org_id is null
2632: THEN
2633: l_return_status := FND_API.G_RET_STS_ERROR;
2634: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2635: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2636: OE_MSG_PUB.Add;
2637: ELSIF p_header_rec.ib_installed_at_location = 'END_CUSTOMER' AND
2638: p_header_rec.end_customer_site_use_id is null

Line 2635: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));

2631: p_header_rec.deliver_to_org_id is null
2632: THEN
2633: l_return_status := FND_API.G_RET_STS_ERROR;
2634: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2635: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2636: OE_MSG_PUB.Add;
2637: ELSIF p_header_rec.ib_installed_at_location = 'END_CUSTOMER' AND
2638: p_header_rec.end_customer_site_use_id is null
2639: THEN

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

2637: ELSIF p_header_rec.ib_installed_at_location = 'END_CUSTOMER' AND
2638: p_header_rec.end_customer_site_use_id is null
2639: THEN
2640: l_return_status := FND_API.G_RET_STS_ERROR;
2641: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2642: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2643: OE_MSG_PUB.Add;
2644: ELSIF p_header_rec.ib_installed_at_location = 'SOLD_TO' AND
2645: p_header_rec.sold_to_site_use_id is null

Line 2642: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));

2638: p_header_rec.end_customer_site_use_id is null
2639: THEN
2640: l_return_status := FND_API.G_RET_STS_ERROR;
2641: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2642: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2643: OE_MSG_PUB.Add;
2644: ELSIF p_header_rec.ib_installed_at_location = 'SOLD_TO' AND
2645: p_header_rec.sold_to_site_use_id is null
2646: THEN

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

2644: ELSIF p_header_rec.ib_installed_at_location = 'SOLD_TO' AND
2645: p_header_rec.sold_to_site_use_id is null
2646: THEN
2647: l_return_status := FND_API.G_RET_STS_ERROR;
2648: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2650: OE_MSG_PUB.Add;
2651: END IF;
2652: END IF;

Line 2649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));

2645: p_header_rec.sold_to_site_use_id is null
2646: THEN
2647: l_return_status := FND_API.G_RET_STS_ERROR;
2648: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2650: OE_MSG_PUB.Add;
2651: END IF;
2652: END IF;
2653: oe_debug_pub.ADD('ib_current_location: '||p_header_rec.ib_current_location);

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

2665: IF (p_header_rec.ib_current_location = 'BILL_TO' AND
2666: p_header_rec.invoice_to_org_id is null)
2667: THEN
2668: l_return_status := FND_API.G_RET_STS_ERROR;
2669: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2670: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2671: OE_MSG_PUB.Add;
2672: ELSIF p_header_rec.ib_current_location = 'SHIP_TO' AND
2673: p_header_rec.ship_to_org_id is null

Line 2670: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));

2666: p_header_rec.invoice_to_org_id is null)
2667: THEN
2668: l_return_status := FND_API.G_RET_STS_ERROR;
2669: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2670: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2671: OE_MSG_PUB.Add;
2672: ELSIF p_header_rec.ib_current_location = 'SHIP_TO' AND
2673: p_header_rec.ship_to_org_id is null
2674: THEN

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

2672: ELSIF p_header_rec.ib_current_location = 'SHIP_TO' AND
2673: p_header_rec.ship_to_org_id is null
2674: THEN
2675: l_return_status := FND_API.G_RET_STS_ERROR;
2676: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2677: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2678: OE_MSG_PUB.Add;
2679: ELSIF p_header_rec.ib_current_location = 'DELIVER_TO' AND
2680: p_header_rec.deliver_to_org_id is null

Line 2677: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));

2673: p_header_rec.ship_to_org_id is null
2674: THEN
2675: l_return_status := FND_API.G_RET_STS_ERROR;
2676: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2677: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2678: OE_MSG_PUB.Add;
2679: ELSIF p_header_rec.ib_current_location = 'DELIVER_TO' AND
2680: p_header_rec.deliver_to_org_id is null
2681: THEN

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

2679: ELSIF p_header_rec.ib_current_location = 'DELIVER_TO' AND
2680: p_header_rec.deliver_to_org_id is null
2681: THEN
2682: l_return_status := FND_API.G_RET_STS_ERROR;
2683: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2685: OE_MSG_PUB.Add;
2686: ELSIF p_header_rec.ib_current_location = 'END_CUSTOMER' AND
2687: p_header_rec.end_customer_site_use_id is null

Line 2684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));

2680: p_header_rec.deliver_to_org_id is null
2681: THEN
2682: l_return_status := FND_API.G_RET_STS_ERROR;
2683: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2685: OE_MSG_PUB.Add;
2686: ELSIF p_header_rec.ib_current_location = 'END_CUSTOMER' AND
2687: p_header_rec.end_customer_site_use_id is null
2688: THEN

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

2686: ELSIF p_header_rec.ib_current_location = 'END_CUSTOMER' AND
2687: p_header_rec.end_customer_site_use_id is null
2688: THEN
2689: l_return_status := FND_API.G_RET_STS_ERROR;
2690: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2691: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2692: OE_MSG_PUB.Add;
2693: ELSIF p_header_rec.ib_current_location = 'SOLD_TO' AND
2694: p_header_rec.sold_to_site_use_id is null

Line 2691: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));

2687: p_header_rec.end_customer_site_use_id is null
2688: THEN
2689: l_return_status := FND_API.G_RET_STS_ERROR;
2690: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2691: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2692: OE_MSG_PUB.Add;
2693: ELSIF p_header_rec.ib_current_location = 'SOLD_TO' AND
2694: p_header_rec.sold_to_site_use_id is null
2695: THEN

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

2693: ELSIF p_header_rec.ib_current_location = 'SOLD_TO' AND
2694: p_header_rec.sold_to_site_use_id is null
2695: THEN
2696: l_return_status := FND_API.G_RET_STS_ERROR;
2697: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2699: OE_MSG_PUB.Add;
2700: END IF;
2701: END IF;

Line 2698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));

2694: p_header_rec.sold_to_site_use_id is null
2695: THEN
2696: l_return_status := FND_API.G_RET_STS_ERROR;
2697: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2699: OE_MSG_PUB.Add;
2700: END IF;
2701: END IF;
2702:

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

2720: If l_debug_level > 0 THEN
2721: oe_debug_pub.add('>line_id:'||l.line_id||' has ib_current_location as SOLD_TO');
2722: end if;
2723: l_return_status := FND_API.G_RET_STS_ERROR;
2724: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2725: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2726: OE_MSG_PUB.Add;
2727: elsif l.ib_installed_at_location='SOLD_TO'
2728: then

Line 2725: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));

2721: oe_debug_pub.add('>line_id:'||l.line_id||' has ib_current_location as SOLD_TO');
2722: end if;
2723: l_return_status := FND_API.G_RET_STS_ERROR;
2724: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2725: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2726: OE_MSG_PUB.Add;
2727: elsif l.ib_installed_at_location='SOLD_TO'
2728: then
2729: If l_debug_level > 0 THEN

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

2729: If l_debug_level > 0 THEN
2730: oe_debug_pub.add('>line_id:'||l.line_id||' has ib_installed_at_location as SOLD_TO');
2731: end if;
2732: l_return_status := FND_API.G_RET_STS_ERROR;
2733: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2734: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2735: OE_MSG_PUB.Add;
2736: end if;
2737: end loop;

Line 2734: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));

2730: oe_debug_pub.add('>line_id:'||l.line_id||' has ib_installed_at_location as SOLD_TO');
2731: end if;
2732: l_return_status := FND_API.G_RET_STS_ERROR;
2733: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2734: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2735: OE_MSG_PUB.Add;
2736: end if;
2737: end loop;
2738: end if;

Line 2748: FND_MESSAGE.SET_NAME('ONT','OE_VPM_INV_TO_REQUIRED');

2744: --R12 CC Encryption
2745: IF p_header_rec.payment_type_code = 'CREDIT_CARD' THEN
2746: IF p_header_rec.invoice_to_org_id is NULL THEN
2747: l_return_status := FND_API.G_RET_STS_ERROR;
2748: FND_MESSAGE.SET_NAME('ONT','OE_VPM_INV_TO_REQUIRED');
2749: OE_MSG_PUB.ADD;
2750: END IF;
2751: END IF;
2752: --R12 CC Encryption

Line 2757: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_NUM_REQUIRED');

2753: /*
2754: OE_MSG_PUB.ADD;
2755: ELSIF p_header_rec.credit_card_number is NULL THEN
2756: l_return_status := FND_API.G_RET_STS_ERROR;
2757: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_NUM_REQUIRED');
2758: OE_MSG_PUB.ADD;
2759: ELSIF p_header_rec.credit_card_expiration_date is NULL THEN
2760: l_return_status := FND_API.G_RET_STS_ERROR;
2761: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_EXP_DT_REQUIRED');

Line 2761: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_EXP_DT_REQUIRED');

2757: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_NUM_REQUIRED');
2758: OE_MSG_PUB.ADD;
2759: ELSIF p_header_rec.credit_card_expiration_date is NULL THEN
2760: l_return_status := FND_API.G_RET_STS_ERROR;
2761: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_EXP_DT_REQUIRED');
2762: OE_MSG_PUB.ADD;
2763: ELSIF p_header_rec.credit_card_holder_name is NULL THEN
2764: l_return_status := FND_API.G_RET_STS_ERROR;
2765: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_HOLDER_REQUIRED');

Line 2765: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_HOLDER_REQUIRED');

2761: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_EXP_DT_REQUIRED');
2762: OE_MSG_PUB.ADD;
2763: ELSIF p_header_rec.credit_card_holder_name is NULL THEN
2764: l_return_status := FND_API.G_RET_STS_ERROR;
2765: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_HOLDER_REQUIRED');
2766: OE_MSG_PUB.ADD;
2767: END IF;
2768: END IF;*/
2769:

Line 3733: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');

3729: l_auth_exist := 'N';
3730: END;
3731: IF nvl(l_auth_exist,'N') = 'N' THEN
3732: --Bug# 16099743 End
3733: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3734: OE_MSG_PUB.ADD;
3735: x_return_status := FND_API.G_RET_STS_ERROR;
3736: END IF; --Bug# 16099743
3737: END IF;