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

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

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

Line 35: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

31: IF p_header_rec.sold_to_org_id IS NULL
32: THEN
33: x_return_status := FND_API.G_RET_STS_ERROR;
34: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
35: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
36: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
37: OE_MSG_PUB.ADD;
38: END IF;
39:

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

39:
40: IF p_header_rec.salesrep_id IS NULL
41: THEN
42: x_return_status := FND_API.G_RET_STS_ERROR;
43: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
44: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
45: OE_Order_UTIL.Get_Attribute_Name('SALESREP_ID'));
46: OE_MSG_PUB.ADD;
47: END IF;

Line 44: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

40: IF p_header_rec.salesrep_id IS NULL
41: THEN
42: x_return_status := FND_API.G_RET_STS_ERROR;
43: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
44: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
45: OE_Order_UTIL.Get_Attribute_Name('SALESREP_ID'));
46: OE_MSG_PUB.ADD;
47: END IF;
48:

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

48:
49: IF p_header_rec.ordered_date IS NULL
50: THEN
51: x_return_status := FND_API.G_RET_STS_ERROR;
52: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
53: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
54: OE_Order_UTIL.Get_Attribute_Name('ORDERED_DATE'));
55: OE_MSG_PUB.ADD;
56: END IF;

Line 53: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

49: IF p_header_rec.ordered_date IS NULL
50: THEN
51: x_return_status := FND_API.G_RET_STS_ERROR;
52: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
53: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
54: OE_Order_UTIL.Get_Attribute_Name('ORDERED_DATE'));
55: OE_MSG_PUB.ADD;
56: END IF;
57:

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

57:
58: IF p_header_rec.invoice_to_org_id IS NULL
59: THEN
60: x_return_status := FND_API.G_RET_STS_ERROR;
61: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
62: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
63: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
64: OE_MSG_PUB.ADD;
65: END IF;

Line 62: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

58: IF p_header_rec.invoice_to_org_id IS NULL
59: THEN
60: x_return_status := FND_API.G_RET_STS_ERROR;
61: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
62: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
63: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
64: OE_MSG_PUB.ADD;
65: END IF;
66:

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

66:
67: IF p_header_rec.tax_exempt_flag IS NULL
68: THEN
69: x_return_status := FND_API.G_RET_STS_ERROR;
70: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
71: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
72: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
73: OE_MSG_PUB.ADD;
74: END IF;

Line 71: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

67: IF p_header_rec.tax_exempt_flag IS NULL
68: THEN
69: x_return_status := FND_API.G_RET_STS_ERROR;
70: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
71: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
72: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
73: OE_MSG_PUB.ADD;
74: END IF;
75:

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

85:
86: IF p_header_rec.ship_to_org_id IS NULL
87: THEN
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
90: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
91: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
92: OE_MSG_PUB.ADD;
93: END IF;

Line 90: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

86: IF p_header_rec.ship_to_org_id IS NULL
87: THEN
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
90: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
91: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
92: OE_MSG_PUB.ADD;
93: END IF;
94:

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

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

Line 99: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

95: IF p_header_rec.payment_term_id IS NULL
96: THEN
97: x_return_status := FND_API.G_RET_STS_ERROR;
98: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
99: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
100: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
101: OE_MSG_PUB.ADD;
102: END IF;
103:

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

113: IF ( l_order_type_rec.agreement_required_flag = 'Y' AND
114: p_header_rec.agreement_id IS NULL)
115: THEN
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
118: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
119: OE_Order_UTIL.Get_Attribute_Name('AGREEMENT_ID'));
120: OE_MSG_PUB.ADD;
121: END IF;

Line 118: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

114: p_header_rec.agreement_id IS NULL)
115: THEN
116: x_return_status := FND_API.G_RET_STS_ERROR;
117: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
118: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
119: OE_Order_UTIL.Get_Attribute_Name('AGREEMENT_ID'));
120: OE_MSG_PUB.ADD;
121: END IF;
122:

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

123: IF ( l_order_type_rec.require_po_flag = 'Y' AND
124: p_header_rec.cust_po_number IS NULL)
125: THEN
126: x_return_status := FND_API.G_RET_STS_ERROR;
127: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
129: OE_Order_UTIL.Get_Attribute_Name('CUST_PO_NUMBER'));
130: OE_MSG_PUB.ADD;
131: END IF;

Line 128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

124: p_header_rec.cust_po_number IS NULL)
125: THEN
126: x_return_status := FND_API.G_RET_STS_ERROR;
127: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
129: OE_Order_UTIL.Get_Attribute_Name('CUST_PO_NUMBER'));
130: OE_MSG_PUB.ADD;
131: END IF;
132:

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

142:
143: IF ( l_set_of_books_rec.currency_code <>
144: p_header_rec.transactional_curr_code) THEN
145: x_return_status := FND_API.G_RET_STS_ERROR;
146: FND_MESSAGE.SET_NAME('ONT','OE_VAL_REQ_NON_BASE_CURRENCY');
147: FND_MESSAGE.SET_TOKEN
148: ('ORDER_CURRENCY',p_header_rec.transactional_curr_code);
149: FND_MESSAGE.SET_TOKEN('SOB_CURRENCY',l_set_of_books_rec.currency_code);
150: OE_MSG_PUB.ADD;

Line 147: FND_MESSAGE.SET_TOKEN

143: IF ( l_set_of_books_rec.currency_code <>
144: p_header_rec.transactional_curr_code) THEN
145: x_return_status := FND_API.G_RET_STS_ERROR;
146: FND_MESSAGE.SET_NAME('ONT','OE_VAL_REQ_NON_BASE_CURRENCY');
147: FND_MESSAGE.SET_TOKEN
148: ('ORDER_CURRENCY',p_header_rec.transactional_curr_code);
149: FND_MESSAGE.SET_TOKEN('SOB_CURRENCY',l_set_of_books_rec.currency_code);
150: OE_MSG_PUB.ADD;
151: END IF;

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

145: x_return_status := FND_API.G_RET_STS_ERROR;
146: FND_MESSAGE.SET_NAME('ONT','OE_VAL_REQ_NON_BASE_CURRENCY');
147: FND_MESSAGE.SET_TOKEN
148: ('ORDER_CURRENCY',p_header_rec.transactional_curr_code);
149: FND_MESSAGE.SET_TOKEN('SOB_CURRENCY',l_set_of_books_rec.currency_code);
150: OE_MSG_PUB.ADD;
151: END IF;
152:
153: -- IF conversion type is 'User', conversion rate AND conversion rate date

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

159: IF p_header_rec.conversion_rate IS NULL OR
160: p_header_rec.conversion_rate_date IS NULL
161: THEN
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: FND_MESSAGE.SET_NAME('ONT','OE_VAL_USER_CONVERSION_TYPE');
164: OE_MSG_PUB.ADD;
165: END IF;
166:
167: END IF; -- END of checks based on conversion type

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

177: IF p_header_rec.payment_type_code <> 'CREDIT_CARD' AND
178: p_header_rec.payment_amount IS NULL
179: THEN
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
183: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_AMOUNT'));
184: OE_MSG_PUB.ADD;
185: END IF;

Line 182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

178: p_header_rec.payment_amount IS NULL
179: THEN
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
183: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_AMOUNT'));
184: OE_MSG_PUB.ADD;
185: END IF;
186:

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

189: IF (p_header_rec.payment_type_code = 'CHECK' AND
190: p_header_rec.check_number IS NULL )
191: THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CHECK_NUM_REQD');
194: OE_MSG_PUB.ADD;
195: END IF;
196:
197: -- credit card holder name, number AND expiration date

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

205: OR p_header_rec.credit_card_number IS NULL
206: OR p_header_rec.credit_card_expiration_date IS NULL
207: THEN
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CREDIT_CARD_REQD');
210: OE_MSG_PUB.ADD;
211: END IF;
212: END IF;
213: */

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

379: l_return_status := FND_API.G_RET_STS_ERROR;
380:
381: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
382: THEN
383: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
384: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
385: OE_Order_UTIL.Get_Attribute_Name('ORDER_TYPE_ID'));
386: OE_MSG_PUB.Add;
387: END IF;

Line 384: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

380:
381: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
382: THEN
383: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
384: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
385: OE_Order_UTIL.Get_Attribute_Name('ORDER_TYPE_ID'));
386: OE_MSG_PUB.Add;
387: END IF;
388: END IF;

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

397: l_return_status := FND_API.G_RET_STS_ERROR;
398:
399: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
400: THEN
401: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
402: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
403: OE_Order_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE'));
404: OE_MSG_PUB.Add;
405: END IF;

Line 402: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

398:
399: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
400: THEN
401: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
402: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
403: OE_Order_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE'));
404: OE_MSG_PUB.Add;
405: END IF;
406:

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

446: l_return_status := FND_API.G_RET_STS_ERROR;
447:
448: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
449: THEN
450: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
452: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
453: OE_MSG_PUB.Add;
454: END IF;

Line 451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

447:
448: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
449: THEN
450: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
452: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
453: OE_MSG_PUB.Add;
454: END IF;
455:

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

475: l_return_status := FND_API.G_RET_STS_ERROR;
476:
477: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
478: THEN
479: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');
480: OE_MSG_PUB.Add;
481: END IF;
482: END IF;
483:

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

512: IF p_header_rec.transactional_curr_code <>
513: l_price_list_rec.currency_code
514: THEN
515: l_return_status := FND_API.G_RET_STS_ERROR;
516: fnd_message.set_name('ONT','OE_VAL_ORD_CURRENCY_MISMATCH');
517: FND_MESSAGE.SET_TOKEN('ORDER_CURRENCY',
518: p_header_rec.transactional_curr_code);
519: FND_MESSAGE.SET_TOKEN('PRICE_LIST_CURRENCY',
520: l_price_list_rec.currency_code);

Line 517: FND_MESSAGE.SET_TOKEN('ORDER_CURRENCY',

513: l_price_list_rec.currency_code
514: THEN
515: l_return_status := FND_API.G_RET_STS_ERROR;
516: fnd_message.set_name('ONT','OE_VAL_ORD_CURRENCY_MISMATCH');
517: FND_MESSAGE.SET_TOKEN('ORDER_CURRENCY',
518: p_header_rec.transactional_curr_code);
519: FND_MESSAGE.SET_TOKEN('PRICE_LIST_CURRENCY',
520: l_price_list_rec.currency_code);
521: OE_MSG_PUB.Add;

Line 519: FND_MESSAGE.SET_TOKEN('PRICE_LIST_CURRENCY',

515: l_return_status := FND_API.G_RET_STS_ERROR;
516: fnd_message.set_name('ONT','OE_VAL_ORD_CURRENCY_MISMATCH');
517: FND_MESSAGE.SET_TOKEN('ORDER_CURRENCY',
518: p_header_rec.transactional_curr_code);
519: FND_MESSAGE.SET_TOKEN('PRICE_LIST_CURRENCY',
520: l_price_list_rec.currency_code);
521: OE_MSG_PUB.Add;
522: END IF; -- Currency Mismatch.
523:

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

535: Nvl(p_header_rec.conversion_rate_date, FND_API.G_MISS_DATE)
536: <> FND_API.G_MISS_DATE
537: THEN
538: l_return_status := FND_API.G_RET_STS_ERROR;
539: fnd_message.set_name('ONT','OE_VAL_CONVERSION_TYPE');
540: OE_MSG_PUB.Add;
541: END IF;
542:
543: END IF;

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

548: IF p_header_rec.conversion_type_code <> 'User' AND
549: p_header_rec.conversion_rate IS NOT NULL
550: THEN
551: l_return_status := FND_API.G_RET_STS_ERROR;
552: FND_MESSAGE.SET_NAME('ONT','OE_VALIDATION_CONV_TYPE');
553: OE_MSG_PUB.ADD;
554:
555: END IF; -- END of checks based on conversion type
556:

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

573:
574: EXCEPTION
575: WHEN NO_DATA_FOUND THEN
576: l_return_status := FND_API.G_RET_STS_ERROR;
577: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
578: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
579: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));
580: OE_MSG_PUB.Add;
581:

Line 578: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

574: EXCEPTION
575: WHEN NO_DATA_FOUND THEN
576: l_return_status := FND_API.G_RET_STS_ERROR;
577: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
578: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
579: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));
580: OE_MSG_PUB.Add;
581:
582: WHEN OTHERS THEN

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

631:
632: -- Geresh added
633: IF l_price_list_id <> p_Header_rec.price_list_id
634: THEN
635: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
636: fnd_message.set_Token
637: ('AGREEMENT_NAME', l_agreement_name || sqlerrm);
638: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
639: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);

Line 636: fnd_message.set_Token

632: -- Geresh added
633: IF l_price_list_id <> p_Header_rec.price_list_id
634: THEN
635: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
636: fnd_message.set_Token
637: ('AGREEMENT_NAME', l_agreement_name || sqlerrm);
638: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
639: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);
640: OE_MSG_PUB.Add;

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

634: THEN
635: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
636: fnd_message.set_Token
637: ('AGREEMENT_NAME', l_agreement_name || sqlerrm);
638: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
639: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);
640: OE_MSG_PUB.Add;
641: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
642: raise FND_API.G_EXC_ERROR;

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

635: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
636: fnd_message.set_Token
637: ('AGREEMENT_NAME', l_agreement_name || sqlerrm);
638: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
639: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);
640: OE_MSG_PUB.Add;
641: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
642: raise FND_API.G_EXC_ERROR;
643: END IF;

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

645:
646:
647: EXCEPTION
648: WHEN NO_DATA_FOUND THEN
649: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
650: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
651: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
652: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);
653: OE_MSG_PUB.Add;

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

646:
647: EXCEPTION
648: WHEN NO_DATA_FOUND THEN
649: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
650: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
651: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
652: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);
653: OE_MSG_PUB.Add;
654: oe_debug_pub.add

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

647: EXCEPTION
648: WHEN NO_DATA_FOUND THEN
649: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
650: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
651: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
652: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);
653: OE_MSG_PUB.Add;
654: oe_debug_pub.add
655: ('No Data Found Agreement+price_list_id combination',2);

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

648: WHEN NO_DATA_FOUND THEN
649: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
650: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
651: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
652: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);
653: OE_MSG_PUB.Add;
654: oe_debug_pub.add
655: ('No Data Found Agreement+price_list_id combination',2);
656: raise FND_API.G_EXC_ERROR;

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

750: WHEN NO_DATA_FOUND THEN
751: oe_debug_pub.add
752: ('In: No data found',2);
753: l_return_status := FND_API.G_RET_STS_ERROR;
754: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
755: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name
756: ('ship_to_org_id'));
757: OE_MSG_PUB.Add;
758:

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

751: oe_debug_pub.add
752: ('In: No data found',2);
753: l_return_status := FND_API.G_RET_STS_ERROR;
754: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
755: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name
756: ('ship_to_org_id'));
757: OE_MSG_PUB.Add;
758:
759: WHEN OTHERS THEN

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

823: EXCEPTION
824:
825: WHEN NO_DATA_FOUND THEN
826: l_return_status := FND_API.G_RET_STS_ERROR;
827: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
828: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
829: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
830: OE_MSG_PUB.Add;
831:

Line 828: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

824:
825: WHEN NO_DATA_FOUND THEN
826: l_return_status := FND_API.G_RET_STS_ERROR;
827: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
828: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
829: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
830: OE_MSG_PUB.Add;
831:
832: WHEN OTHERS THEN

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

917: EXCEPTION
918:
919: WHEN NO_DATA_FOUND THEN
920: l_return_status := FND_API.G_RET_STS_ERROR;
921: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
922: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
923: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
924: OE_MSG_PUB.Add;
925:

Line 922: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

918:
919: WHEN NO_DATA_FOUND THEN
920: l_return_status := FND_API.G_RET_STS_ERROR;
921: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
922: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
923: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
924: OE_MSG_PUB.Add;
925:
926: WHEN OTHERS THEN

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

959: EXCEPTION
960:
961: WHEN NO_DATA_FOUND THEN
962: l_return_status := FND_API.G_RET_STS_ERROR;
963: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
964: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
965: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
966: OE_MSG_PUB.Add;
967:

Line 964: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

960:
961: WHEN NO_DATA_FOUND THEN
962: l_return_status := FND_API.G_RET_STS_ERROR;
963: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
964: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
965: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
966: OE_MSG_PUB.Add;
967:
968: WHEN OTHERS THEN

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

1002: EXCEPTION
1003:
1004: WHEN NO_DATA_FOUND THEN
1005: l_return_status := FND_API.G_RET_STS_ERROR;
1006: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1007: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1008: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
1009: OE_MSG_PUB.Add;
1010:

Line 1007: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1003:
1004: WHEN NO_DATA_FOUND THEN
1005: l_return_status := FND_API.G_RET_STS_ERROR;
1006: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1007: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1008: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
1009: OE_MSG_PUB.Add;
1010:
1011: WHEN OTHERS THEN

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

1052:
1053: WHEN NO_DATA_FOUND THEN
1054:
1055: l_return_status := FND_API.G_RET_STS_ERROR;
1056: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1057: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1058: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_CONTACT_ID'));
1059: OE_MSG_PUB.Add;
1060:

Line 1057: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1053: WHEN NO_DATA_FOUND THEN
1054:
1055: l_return_status := FND_API.G_RET_STS_ERROR;
1056: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1057: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1058: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_CONTACT_ID'));
1059: OE_MSG_PUB.Add;
1060:
1061: WHEN OTHERS THEN

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

1107: EXCEPTION
1108:
1109: WHEN NO_DATA_FOUND THEN
1110: l_return_status := FND_API.G_RET_STS_ERROR;
1111: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1113: OE_Order_Util.Get_Attribute_Name('SHIP_TO_CONTACT_ID'));
1114: OE_MSG_PUB.Add;
1115:

Line 1112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1108:
1109: WHEN NO_DATA_FOUND THEN
1110: l_return_status := FND_API.G_RET_STS_ERROR;
1111: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1113: OE_Order_Util.Get_Attribute_Name('SHIP_TO_CONTACT_ID'));
1114: OE_MSG_PUB.Add;
1115:
1116: WHEN OTHERS THEN

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

1159: EXCEPTION
1160:
1161: WHEN NO_DATA_FOUND THEN
1162: l_return_status := FND_API.G_RET_STS_ERROR;
1163: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1165: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_CONTACT_ID'));
1166: OE_MSG_PUB.Add;
1167:

Line 1164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1160:
1161: WHEN NO_DATA_FOUND THEN
1162: l_return_status := FND_API.G_RET_STS_ERROR;
1163: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1165: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_CONTACT_ID'));
1166: OE_MSG_PUB.Add;
1167:
1168: WHEN OTHERS THEN

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

1264:
1265: WHEN NO_DATA_FOUND THEN
1266:
1267: l_return_status := FND_API.G_RET_STS_ERROR;
1268: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1270: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
1271: OE_MSG_PUB.Add;
1272:

Line 1269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1265: WHEN NO_DATA_FOUND THEN
1266:
1267: l_return_status := FND_API.G_RET_STS_ERROR;
1268: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1270: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
1271: OE_MSG_PUB.Add;
1272:
1273: WHEN OTHERS THEN

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

1297: (p_header_rec.cust_po_number
1298: ,p_header_rec.sold_to_org_id
1299: ,p_header_rec.header_id )
1300: THEN
1301: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_PO_NUMBER');
1302: OE_MSG_PUB.ADD;
1303: END IF;
1304:
1305: END IF;

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

1353: -- validate Sales agreements Attributes
1354: IF p_x_header_rec.Blanket_number IS NOT NULL
1355: THEN
1356: x_return_status := FND_API.G_RET_STS_ERROR;
1357: fnd_message.set_name('ONT', 'OE_BLKT_DISALLOW_CLOSE_REL');
1358: OE_MSG_PUB.add;
1359: END IF;
1360:
1361: