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 OE_MSG_PUB

Line 37: OE_MSG_PUB.ADD;

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:
40: IF p_header_rec.salesrep_id IS NULL
41: THEN

Line 46: OE_MSG_PUB.ADD;

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:
49: IF p_header_rec.ordered_date IS NULL
50: THEN

Line 55: OE_MSG_PUB.ADD;

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:
58: IF p_header_rec.invoice_to_org_id IS NULL
59: THEN

Line 64: OE_MSG_PUB.ADD;

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:
67: IF p_header_rec.tax_exempt_flag IS NULL
68: THEN

Line 73: OE_MSG_PUB.ADD;

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:
76:
77: -- Fix bug 1262790

Line 92: OE_MSG_PUB.ADD;

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:
95: IF p_header_rec.payment_term_id IS NULL
96: THEN

Line 101: OE_MSG_PUB.ADD;

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:
104: END IF;
105:

Line 120: OE_MSG_PUB.ADD;

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:
123: IF ( l_order_type_rec.require_po_flag = 'Y' AND
124: p_header_rec.cust_po_number IS NULL)

Line 130: OE_MSG_PUB.ADD;

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:
133:
134: -- Conversion Type Related Checks

Line 150: OE_MSG_PUB.ADD;

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
154: -- required.

Line 164: OE_MSG_PUB.ADD;

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
168:

Line 184: OE_MSG_PUB.ADD;

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:
187: -- check number required IF payment type is Check
188:

Line 194: OE_MSG_PUB.ADD;

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
198: -- required for payment type of Credit Card

Line 210: OE_MSG_PUB.ADD;

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: */
214:

Line 222: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

218: EXCEPTION
219: WHEN OTHERS THEN
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221:
222: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
223: THEN
224: OE_MSG_PUB.Add_Exc_Msg
225: ( G_PKG_NAME ,
226: 'Check_Book_Reqd_Attributes'

Line 224: OE_MSG_PUB.Add_Exc_Msg

220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221:
222: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
223: THEN
224: OE_MSG_PUB.Add_Exc_Msg
225: ( G_PKG_NAME ,
226: 'Check_Book_Reqd_Attributes'
227: );
228: END IF;

Line 381: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)

377: IF p_header_rec.order_type_id IS NULL
378: THEN
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'));

Line 386: OE_MSG_PUB.Add;

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;
389:
390: --add messages

Line 399: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)

395: IF p_header_rec.transactional_curr_code IS NULL
396: THEN
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'));

Line 404: OE_MSG_PUB.Add;

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:
407: END IF;
408:

Line 448: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)

444: p_header_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR
445: THEN
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'));

Line 453: OE_MSG_PUB.Add;

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:
456: END IF;
457:

Line 477: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)

473: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR)
474: THEN
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;

Line 480: OE_MSG_PUB.Add;

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:
484: END IF;

Line 521: OE_MSG_PUB.Add;

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:
524: END IF; -- Price list or currency changed.
525:

Line 540: OE_MSG_PUB.Add;

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;
544:

Line 553: OE_MSG_PUB.ADD;

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:
557: oe_debug_pub.add('p_header_rec.ordered_date' || p_header_rec.ordered_date, 2);

Line 580: OE_MSG_PUB.Add;

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
583:
584: IF OE_MSG_PUB.Check_Msg_Level

Line 584: IF OE_MSG_PUB.Check_Msg_Level

580: OE_MSG_PUB.Add;
581:
582: WHEN OTHERS THEN
583:
584: IF OE_MSG_PUB.Check_Msg_Level
585: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
586: THEN
587:
588: OE_MSG_PUB.Add_Exc_Msg

Line 585: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

581:
582: WHEN OTHERS THEN
583:
584: IF OE_MSG_PUB.Check_Msg_Level
585: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
586: THEN
587:
588: OE_MSG_PUB.Add_Exc_Msg
589: ( G_PKG_NAME ,

Line 588: OE_MSG_PUB.Add_Exc_Msg

584: IF OE_MSG_PUB.Check_Msg_Level
585: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
586: THEN
587:
588: OE_MSG_PUB.Add_Exc_Msg
589: ( G_PKG_NAME ,
590: 'Record - Order Type'
591: );
592: END IF;

Line 640: OE_MSG_PUB.Add;

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;
644: END IF;

Line 653: OE_MSG_PUB.Add;

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;
657: END;

Line 757: OE_MSG_PUB.Add;

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
760:
761: IF OE_MSG_PUB.Check_Msg_Level

Line 761: IF OE_MSG_PUB.Check_Msg_Level

757: OE_MSG_PUB.Add;
758:
759: WHEN OTHERS THEN
760:
761: IF OE_MSG_PUB.Check_Msg_Level
762: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
763: THEN
764: OE_MSG_PUB.Add_Exc_Msg
765: ( G_PKG_NAME ,

Line 762: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

758:
759: WHEN OTHERS THEN
760:
761: IF OE_MSG_PUB.Check_Msg_Level
762: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
763: THEN
764: OE_MSG_PUB.Add_Exc_Msg
765: ( G_PKG_NAME ,
766: 'Record - Ship To'

Line 764: OE_MSG_PUB.Add_Exc_Msg

760:
761: IF OE_MSG_PUB.Check_Msg_Level
762: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
763: THEN
764: OE_MSG_PUB.Add_Exc_Msg
765: ( G_PKG_NAME ,
766: 'Record - Ship To'
767: );
768: END IF;

Line 830: OE_MSG_PUB.Add;

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
833:
834: IF OE_MSG_PUB.Check_Msg_Level

Line 834: IF OE_MSG_PUB.Check_Msg_Level

830: OE_MSG_PUB.Add;
831:
832: WHEN OTHERS THEN
833:
834: IF OE_MSG_PUB.Check_Msg_Level
835: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
836: THEN
837:
838: OE_MSG_PUB.Add_Exc_Msg

Line 835: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

831:
832: WHEN OTHERS THEN
833:
834: IF OE_MSG_PUB.Check_Msg_Level
835: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
836: THEN
837:
838: OE_MSG_PUB.Add_Exc_Msg
839: ( G_PKG_NAME ,

Line 838: OE_MSG_PUB.Add_Exc_Msg

834: IF OE_MSG_PUB.Check_Msg_Level
835: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
836: THEN
837:
838: OE_MSG_PUB.Add_Exc_Msg
839: ( G_PKG_NAME ,
840: 'Record - Deliver To'
841: );
842: END IF;

Line 924: OE_MSG_PUB.Add;

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
927:
928: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 928: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

924: OE_MSG_PUB.Add;
925:
926: WHEN OTHERS THEN
927:
928: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
929: THEN
930: OE_MSG_PUB.Add_Exc_Msg
931: ( G_PKG_NAME ,
932: 'Record - Invoice To'

Line 930: OE_MSG_PUB.Add_Exc_Msg

926: WHEN OTHERS THEN
927:
928: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
929: THEN
930: OE_MSG_PUB.Add_Exc_Msg
931: ( G_PKG_NAME ,
932: 'Record - Invoice To'
933: );
934: END IF;

Line 966: OE_MSG_PUB.Add;

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
969: IF OE_MSG_PUB.Check_Msg_Level
970: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 969: IF OE_MSG_PUB.Check_Msg_Level

965: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
966: OE_MSG_PUB.Add;
967:
968: WHEN OTHERS THEN
969: IF OE_MSG_PUB.Check_Msg_Level
970: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
971: THEN
972: OE_MSG_PUB.Add_Exc_Msg
973: ( G_PKG_NAME ,

Line 970: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

966: OE_MSG_PUB.Add;
967:
968: WHEN OTHERS THEN
969: IF OE_MSG_PUB.Check_Msg_Level
970: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
971: THEN
972: OE_MSG_PUB.Add_Exc_Msg
973: ( G_PKG_NAME ,
974: 'Record - Customer Location'

Line 972: OE_MSG_PUB.Add_Exc_Msg

968: WHEN OTHERS THEN
969: IF OE_MSG_PUB.Check_Msg_Level
970: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
971: THEN
972: OE_MSG_PUB.Add_Exc_Msg
973: ( G_PKG_NAME ,
974: 'Record - Customer Location'
975: );
976: END IF;

Line 1009: OE_MSG_PUB.Add;

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
1012: IF OE_MSG_PUB.Check_Msg_Level
1013: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1012: IF OE_MSG_PUB.Check_Msg_Level

1008: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
1009: OE_MSG_PUB.Add;
1010:
1011: WHEN OTHERS THEN
1012: IF OE_MSG_PUB.Check_Msg_Level
1013: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: OE_MSG_PUB.Add_Exc_Msg
1016: ( G_PKG_NAME ,

Line 1013: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1009: OE_MSG_PUB.Add;
1010:
1011: WHEN OTHERS THEN
1012: IF OE_MSG_PUB.Check_Msg_Level
1013: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: OE_MSG_PUB.Add_Exc_Msg
1016: ( G_PKG_NAME ,
1017: 'Record - Sold To Contact'

Line 1015: OE_MSG_PUB.Add_Exc_Msg

1011: WHEN OTHERS THEN
1012: IF OE_MSG_PUB.Check_Msg_Level
1013: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: OE_MSG_PUB.Add_Exc_Msg
1016: ( G_PKG_NAME ,
1017: 'Record - Sold To Contact'
1018: );
1019: END IF;

Line 1059: OE_MSG_PUB.Add;

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
1062:
1063: IF OE_MSG_PUB.Check_Msg_Level

Line 1063: IF OE_MSG_PUB.Check_Msg_Level

1059: OE_MSG_PUB.Add;
1060:
1061: WHEN OTHERS THEN
1062:
1063: IF OE_MSG_PUB.Check_Msg_Level
1064: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1065: THEN
1066:
1067: OE_MSG_PUB.Add_Exc_Msg

Line 1064: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1060:
1061: WHEN OTHERS THEN
1062:
1063: IF OE_MSG_PUB.Check_Msg_Level
1064: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1065: THEN
1066:
1067: OE_MSG_PUB.Add_Exc_Msg
1068: ( G_PKG_NAME ,

Line 1067: OE_MSG_PUB.Add_Exc_Msg

1063: IF OE_MSG_PUB.Check_Msg_Level
1064: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1065: THEN
1066:
1067: OE_MSG_PUB.Add_Exc_Msg
1068: ( G_PKG_NAME ,
1069: 'Record - Invoice To Contact'
1070: );
1071: END IF;

Line 1114: OE_MSG_PUB.Add;

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
1117:
1118: IF OE_MSG_PUB.Check_Msg_Level

Line 1118: IF OE_MSG_PUB.Check_Msg_Level

1114: OE_MSG_PUB.Add;
1115:
1116: WHEN OTHERS THEN
1117:
1118: IF OE_MSG_PUB.Check_Msg_Level
1119: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1120: THEN
1121:
1122: OE_MSG_PUB.Add_Exc_Msg

Line 1119: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1115:
1116: WHEN OTHERS THEN
1117:
1118: IF OE_MSG_PUB.Check_Msg_Level
1119: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1120: THEN
1121:
1122: OE_MSG_PUB.Add_Exc_Msg
1123: ( G_PKG_NAME ,

Line 1122: OE_MSG_PUB.Add_Exc_Msg

1118: IF OE_MSG_PUB.Check_Msg_Level
1119: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1120: THEN
1121:
1122: OE_MSG_PUB.Add_Exc_Msg
1123: ( G_PKG_NAME ,
1124: 'Record - Ship To Contact'
1125: );
1126: END IF;

Line 1166: OE_MSG_PUB.Add;

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
1169:
1170: IF OE_MSG_PUB.Check_Msg_Level (

Line 1170: IF OE_MSG_PUB.Check_Msg_Level (

1166: OE_MSG_PUB.Add;
1167:
1168: WHEN OTHERS THEN
1169:
1170: IF OE_MSG_PUB.Check_Msg_Level (
1171: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1172: THEN
1173: OE_MSG_PUB.Add_Exc_Msg
1174: ( G_PKG_NAME ,

Line 1171: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1167:
1168: WHEN OTHERS THEN
1169:
1170: IF OE_MSG_PUB.Check_Msg_Level (
1171: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1172: THEN
1173: OE_MSG_PUB.Add_Exc_Msg
1174: ( G_PKG_NAME ,
1175: 'Record - Deliver To Contact'

Line 1173: OE_MSG_PUB.Add_Exc_Msg

1169:
1170: IF OE_MSG_PUB.Check_Msg_Level (
1171: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1172: THEN
1173: OE_MSG_PUB.Add_Exc_Msg
1174: ( G_PKG_NAME ,
1175: 'Record - Deliver To Contact'
1176: );
1177: END IF;

Line 1271: OE_MSG_PUB.Add;

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
1274:
1275: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1275: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1271: OE_MSG_PUB.Add;
1272:
1273: WHEN OTHERS THEN
1274:
1275: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1276: THEN
1277:
1278: OE_MSG_PUB.Add_Exc_Msg
1279: ( G_PKG_NAME ,

Line 1278: OE_MSG_PUB.Add_Exc_Msg

1274:
1275: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1276: THEN
1277:
1278: OE_MSG_PUB.Add_Exc_Msg
1279: ( G_PKG_NAME ,
1280: 'Record - Tax Exempt Number'
1281: );
1282: END IF;

Line 1302: OE_MSG_PUB.ADD;

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;
1306: -- End of check for duplicate PO number

Line 1325: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1321:
1322: WHEN OTHERS THEN
1323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1324:
1325: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1326: THEN
1327: OE_MSG_PUB.Add_Exc_Msg
1328: ( G_PKG_NAME
1329: , 'Entity'

Line 1327: OE_MSG_PUB.Add_Exc_Msg

1323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1324:
1325: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1326: THEN
1327: OE_MSG_PUB.Add_Exc_Msg
1328: ( G_PKG_NAME
1329: , 'Entity'
1330: );
1331: END IF;

Line 1358: OE_MSG_PUB.add;

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:
1362: -- Validate header attributes

Line 2599: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2595:
2596: WHEN OTHERS THEN
2597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2598:
2599: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2600: THEN
2601: OE_MSG_PUB.Add_Exc_Msg
2602: ( G_PKG_NAME
2603: ,'Attributes'

Line 2601: OE_MSG_PUB.Add_Exc_Msg

2597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2598:
2599: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2600: THEN
2601: OE_MSG_PUB.Add_Exc_Msg
2602: ( G_PKG_NAME
2603: ,'Attributes'
2604: );
2605: END IF;