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

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

Line 385: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

Line 403: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

Line 452: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

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

543: THEN
544: 15878235 end*/
545: IF l_validate_result = 'N' THEN --15878235
546: l_return_status := FND_API.G_RET_STS_ERROR;
547: fnd_message.set_name('ONT','OE_VAL_ORD_CURRENCY_MISMATCH');
548: FND_MESSAGE.SET_TOKEN('ORDER_CURRENCY',
549: p_header_rec.transactional_curr_code);
550: FND_MESSAGE.SET_TOKEN('PRICE_LIST_CURRENCY',
551: l_price_list_rec.currency_code);

Line 548: FND_MESSAGE.SET_TOKEN('ORDER_CURRENCY',

544: 15878235 end*/
545: IF l_validate_result = 'N' THEN --15878235
546: l_return_status := FND_API.G_RET_STS_ERROR;
547: fnd_message.set_name('ONT','OE_VAL_ORD_CURRENCY_MISMATCH');
548: FND_MESSAGE.SET_TOKEN('ORDER_CURRENCY',
549: p_header_rec.transactional_curr_code);
550: FND_MESSAGE.SET_TOKEN('PRICE_LIST_CURRENCY',
551: l_price_list_rec.currency_code);
552: OE_MSG_PUB.Add;

Line 550: FND_MESSAGE.SET_TOKEN('PRICE_LIST_CURRENCY',

546: l_return_status := FND_API.G_RET_STS_ERROR;
547: fnd_message.set_name('ONT','OE_VAL_ORD_CURRENCY_MISMATCH');
548: FND_MESSAGE.SET_TOKEN('ORDER_CURRENCY',
549: p_header_rec.transactional_curr_code);
550: FND_MESSAGE.SET_TOKEN('PRICE_LIST_CURRENCY',
551: l_price_list_rec.currency_code);
552: OE_MSG_PUB.Add;
553: END IF; -- Currency Mismatch.
554:

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

566: Nvl(p_header_rec.conversion_rate_date, FND_API.G_MISS_DATE)
567: <> FND_API.G_MISS_DATE
568: THEN
569: l_return_status := FND_API.G_RET_STS_ERROR;
570: fnd_message.set_name('ONT','OE_VAL_CONVERSION_TYPE');
571: OE_MSG_PUB.Add;
572: END IF;
573:
574: END IF;

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

579: IF p_header_rec.conversion_type_code <> 'User' AND
580: p_header_rec.conversion_rate IS NOT NULL
581: THEN
582: l_return_status := FND_API.G_RET_STS_ERROR;
583: FND_MESSAGE.SET_NAME('ONT','OE_VALIDATION_CONV_TYPE');
584: OE_MSG_PUB.ADD;
585:
586: END IF; -- END of checks based on conversion type
587:

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

604:
605: EXCEPTION
606: WHEN NO_DATA_FOUND THEN
607: l_return_status := FND_API.G_RET_STS_ERROR;
608: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
609: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
610: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));
611: OE_MSG_PUB.Add;
612:

Line 609: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

605: EXCEPTION
606: WHEN NO_DATA_FOUND THEN
607: l_return_status := FND_API.G_RET_STS_ERROR;
608: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
609: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
610: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));
611: OE_MSG_PUB.Add;
612:
613: WHEN OTHERS THEN

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

662:
663: -- Geresh added
664: IF l_price_list_id <> p_Header_rec.price_list_id
665: THEN
666: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
667: fnd_message.set_Token
668: ('AGREEMENT_NAME', l_agreement_name || sqlerrm);
669: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
670: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);

Line 667: fnd_message.set_Token

663: -- Geresh added
664: IF l_price_list_id <> p_Header_rec.price_list_id
665: THEN
666: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
667: fnd_message.set_Token
668: ('AGREEMENT_NAME', l_agreement_name || sqlerrm);
669: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
670: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);
671: OE_MSG_PUB.Add;

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

665: THEN
666: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
667: fnd_message.set_Token
668: ('AGREEMENT_NAME', l_agreement_name || sqlerrm);
669: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
670: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);
671: OE_MSG_PUB.Add;
672: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
673: raise FND_API.G_EXC_ERROR;

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

666: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
667: fnd_message.set_Token
668: ('AGREEMENT_NAME', l_agreement_name || sqlerrm);
669: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
670: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);
671: OE_MSG_PUB.Add;
672: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
673: raise FND_API.G_EXC_ERROR;
674: END IF;

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

676:
677:
678: EXCEPTION
679: WHEN NO_DATA_FOUND THEN
680: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
681: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
682: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
683: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);
684: OE_MSG_PUB.Add;

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

677:
678: EXCEPTION
679: WHEN NO_DATA_FOUND THEN
680: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
681: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
682: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
683: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);
684: OE_MSG_PUB.Add;
685: oe_debug_pub.add

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

678: EXCEPTION
679: WHEN NO_DATA_FOUND THEN
680: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
681: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
682: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
683: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);
684: OE_MSG_PUB.Add;
685: oe_debug_pub.add
686: ('No Data Found Agreement+price_list_id combination',2);

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

679: WHEN NO_DATA_FOUND THEN
680: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
681: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
682: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
683: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);
684: OE_MSG_PUB.Add;
685: oe_debug_pub.add
686: ('No Data Found Agreement+price_list_id combination',2);
687: raise FND_API.G_EXC_ERROR;

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

781: WHEN NO_DATA_FOUND THEN
782: oe_debug_pub.add
783: ('In: No data found',2);
784: l_return_status := FND_API.G_RET_STS_ERROR;
785: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
786: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name
787: ('ship_to_org_id'));
788: OE_MSG_PUB.Add;
789:

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

782: oe_debug_pub.add
783: ('In: No data found',2);
784: l_return_status := FND_API.G_RET_STS_ERROR;
785: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
786: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name
787: ('ship_to_org_id'));
788: OE_MSG_PUB.Add;
789:
790: WHEN OTHERS THEN

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

854: EXCEPTION
855:
856: WHEN NO_DATA_FOUND THEN
857: l_return_status := FND_API.G_RET_STS_ERROR;
858: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
859: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
860: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
861: OE_MSG_PUB.Add;
862:

Line 859: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

855:
856: WHEN NO_DATA_FOUND THEN
857: l_return_status := FND_API.G_RET_STS_ERROR;
858: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
859: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
860: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
861: OE_MSG_PUB.Add;
862:
863: WHEN OTHERS THEN

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

948: EXCEPTION
949:
950: WHEN NO_DATA_FOUND THEN
951: l_return_status := FND_API.G_RET_STS_ERROR;
952: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
953: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
954: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
955: OE_MSG_PUB.Add;
956:

Line 953: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

949:
950: WHEN NO_DATA_FOUND THEN
951: l_return_status := FND_API.G_RET_STS_ERROR;
952: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
953: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
954: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
955: OE_MSG_PUB.Add;
956:
957: WHEN OTHERS THEN

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

990: EXCEPTION
991:
992: WHEN NO_DATA_FOUND THEN
993: l_return_status := FND_API.G_RET_STS_ERROR;
994: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
995: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
996: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
997: OE_MSG_PUB.Add;
998:

Line 995: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

991:
992: WHEN NO_DATA_FOUND THEN
993: l_return_status := FND_API.G_RET_STS_ERROR;
994: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
995: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
996: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
997: OE_MSG_PUB.Add;
998:
999: WHEN OTHERS THEN

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

1033: EXCEPTION
1034:
1035: WHEN NO_DATA_FOUND THEN
1036: l_return_status := FND_API.G_RET_STS_ERROR;
1037: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1038: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1039: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
1040: OE_MSG_PUB.Add;
1041:

Line 1038: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1034:
1035: WHEN NO_DATA_FOUND THEN
1036: l_return_status := FND_API.G_RET_STS_ERROR;
1037: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1038: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1039: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
1040: OE_MSG_PUB.Add;
1041:
1042: WHEN OTHERS THEN

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

1083:
1084: WHEN NO_DATA_FOUND THEN
1085:
1086: l_return_status := FND_API.G_RET_STS_ERROR;
1087: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1088: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1089: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_CONTACT_ID'));
1090: OE_MSG_PUB.Add;
1091:

Line 1088: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1084: WHEN NO_DATA_FOUND THEN
1085:
1086: l_return_status := FND_API.G_RET_STS_ERROR;
1087: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1088: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1089: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_CONTACT_ID'));
1090: OE_MSG_PUB.Add;
1091:
1092: WHEN OTHERS THEN

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

1138: EXCEPTION
1139:
1140: WHEN NO_DATA_FOUND THEN
1141: l_return_status := FND_API.G_RET_STS_ERROR;
1142: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1143: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1144: OE_Order_Util.Get_Attribute_Name('SHIP_TO_CONTACT_ID'));
1145: OE_MSG_PUB.Add;
1146:

Line 1143: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1139:
1140: WHEN NO_DATA_FOUND THEN
1141: l_return_status := FND_API.G_RET_STS_ERROR;
1142: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1143: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1144: OE_Order_Util.Get_Attribute_Name('SHIP_TO_CONTACT_ID'));
1145: OE_MSG_PUB.Add;
1146:
1147: WHEN OTHERS THEN

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

1190: EXCEPTION
1191:
1192: WHEN NO_DATA_FOUND THEN
1193: l_return_status := FND_API.G_RET_STS_ERROR;
1194: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1195: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1196: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_CONTACT_ID'));
1197: OE_MSG_PUB.Add;
1198:

Line 1195: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1191:
1192: WHEN NO_DATA_FOUND THEN
1193: l_return_status := FND_API.G_RET_STS_ERROR;
1194: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1195: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1196: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_CONTACT_ID'));
1197: OE_MSG_PUB.Add;
1198:
1199: WHEN OTHERS THEN

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

1295:
1296: WHEN NO_DATA_FOUND THEN
1297:
1298: l_return_status := FND_API.G_RET_STS_ERROR;
1299: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1300: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1301: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
1302: OE_MSG_PUB.Add;
1303:

Line 1300: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1296: WHEN NO_DATA_FOUND THEN
1297:
1298: l_return_status := FND_API.G_RET_STS_ERROR;
1299: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1300: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1301: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
1302: OE_MSG_PUB.Add;
1303:
1304: WHEN OTHERS THEN

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

1328: (p_header_rec.cust_po_number
1329: ,p_header_rec.sold_to_org_id
1330: ,p_header_rec.header_id )
1331: THEN
1332: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_PO_NUMBER');
1333: OE_MSG_PUB.ADD;
1334: END IF;
1335:
1336: END IF;

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

1384: -- validate Sales agreements Attributes
1385: IF p_x_header_rec.Blanket_number IS NOT NULL
1386: THEN
1387: x_return_status := FND_API.G_RET_STS_ERROR;
1388: fnd_message.set_name('ONT', 'OE_BLKT_DISALLOW_CLOSE_REL');
1389: OE_MSG_PUB.add;
1390: END IF;
1391:
1392: