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 382: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)

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

Line 387: OE_MSG_PUB.Add;

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

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

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

Line 405: OE_MSG_PUB.Add;

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

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

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

Line 454: OE_MSG_PUB.Add;

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

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

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

Line 481: OE_MSG_PUB.Add;

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

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

521: WHEN OTHERS THEN
522:
523: oe_debug_pub.add('OEXVCHDB: Error when calling QP_UTIL_PUB.Validate_Price_list_Curr_code:'||SQLERRM);
524:
525: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527:
528: OE_MSG_PUB.Add_Exc_Msg
529: ( G_PKG_NAME ,

Line 528: OE_MSG_PUB.Add_Exc_Msg

524:
525: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527:
528: OE_MSG_PUB.Add_Exc_Msg
529: ( G_PKG_NAME ,
530: 'OE_CNCL_VALIDATE_HEADER-QP_UTIL_PUB'
531: );
532: END IF;

Line 552: OE_MSG_PUB.Add;

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

Line 571: OE_MSG_PUB.Add;

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

Line 584: OE_MSG_PUB.ADD;

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

Line 611: OE_MSG_PUB.Add;

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
614:
615: IF OE_MSG_PUB.Check_Msg_Level

Line 615: IF OE_MSG_PUB.Check_Msg_Level

611: OE_MSG_PUB.Add;
612:
613: WHEN OTHERS THEN
614:
615: IF OE_MSG_PUB.Check_Msg_Level
616: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN
618:
619: OE_MSG_PUB.Add_Exc_Msg

Line 616: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

612:
613: WHEN OTHERS THEN
614:
615: IF OE_MSG_PUB.Check_Msg_Level
616: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN
618:
619: OE_MSG_PUB.Add_Exc_Msg
620: ( G_PKG_NAME ,

Line 619: OE_MSG_PUB.Add_Exc_Msg

615: IF OE_MSG_PUB.Check_Msg_Level
616: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN
618:
619: OE_MSG_PUB.Add_Exc_Msg
620: ( G_PKG_NAME ,
621: 'Record - Order Type'
622: );
623: END IF;

Line 671: OE_MSG_PUB.Add;

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

Line 684: OE_MSG_PUB.Add;

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

Line 788: OE_MSG_PUB.Add;

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
791:
792: IF OE_MSG_PUB.Check_Msg_Level

Line 792: IF OE_MSG_PUB.Check_Msg_Level

788: OE_MSG_PUB.Add;
789:
790: WHEN OTHERS THEN
791:
792: IF OE_MSG_PUB.Check_Msg_Level
793: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
794: THEN
795: OE_MSG_PUB.Add_Exc_Msg
796: ( G_PKG_NAME ,

Line 793: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

789:
790: WHEN OTHERS THEN
791:
792: IF OE_MSG_PUB.Check_Msg_Level
793: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
794: THEN
795: OE_MSG_PUB.Add_Exc_Msg
796: ( G_PKG_NAME ,
797: 'Record - Ship To'

Line 795: OE_MSG_PUB.Add_Exc_Msg

791:
792: IF OE_MSG_PUB.Check_Msg_Level
793: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
794: THEN
795: OE_MSG_PUB.Add_Exc_Msg
796: ( G_PKG_NAME ,
797: 'Record - Ship To'
798: );
799: END IF;

Line 861: OE_MSG_PUB.Add;

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
864:
865: IF OE_MSG_PUB.Check_Msg_Level

Line 865: IF OE_MSG_PUB.Check_Msg_Level

861: OE_MSG_PUB.Add;
862:
863: WHEN OTHERS THEN
864:
865: IF OE_MSG_PUB.Check_Msg_Level
866: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
867: THEN
868:
869: OE_MSG_PUB.Add_Exc_Msg

Line 866: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

862:
863: WHEN OTHERS THEN
864:
865: IF OE_MSG_PUB.Check_Msg_Level
866: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
867: THEN
868:
869: OE_MSG_PUB.Add_Exc_Msg
870: ( G_PKG_NAME ,

Line 869: OE_MSG_PUB.Add_Exc_Msg

865: IF OE_MSG_PUB.Check_Msg_Level
866: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
867: THEN
868:
869: OE_MSG_PUB.Add_Exc_Msg
870: ( G_PKG_NAME ,
871: 'Record - Deliver To'
872: );
873: END IF;

Line 955: OE_MSG_PUB.Add;

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

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

955: OE_MSG_PUB.Add;
956:
957: WHEN OTHERS THEN
958:
959: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
960: THEN
961: OE_MSG_PUB.Add_Exc_Msg
962: ( G_PKG_NAME ,
963: 'Record - Invoice To'

Line 961: OE_MSG_PUB.Add_Exc_Msg

957: WHEN OTHERS THEN
958:
959: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
960: THEN
961: OE_MSG_PUB.Add_Exc_Msg
962: ( G_PKG_NAME ,
963: 'Record - Invoice To'
964: );
965: END IF;

Line 997: OE_MSG_PUB.Add;

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

Line 1000: IF OE_MSG_PUB.Check_Msg_Level

996: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
997: OE_MSG_PUB.Add;
998:
999: WHEN OTHERS THEN
1000: IF OE_MSG_PUB.Check_Msg_Level
1001: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1002: THEN
1003: OE_MSG_PUB.Add_Exc_Msg
1004: ( G_PKG_NAME ,

Line 1001: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

997: OE_MSG_PUB.Add;
998:
999: WHEN OTHERS THEN
1000: IF OE_MSG_PUB.Check_Msg_Level
1001: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1002: THEN
1003: OE_MSG_PUB.Add_Exc_Msg
1004: ( G_PKG_NAME ,
1005: 'Record - Customer Location'

Line 1003: OE_MSG_PUB.Add_Exc_Msg

999: WHEN OTHERS THEN
1000: IF OE_MSG_PUB.Check_Msg_Level
1001: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1002: THEN
1003: OE_MSG_PUB.Add_Exc_Msg
1004: ( G_PKG_NAME ,
1005: 'Record - Customer Location'
1006: );
1007: END IF;

Line 1040: OE_MSG_PUB.Add;

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

Line 1043: IF OE_MSG_PUB.Check_Msg_Level

1039: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
1040: OE_MSG_PUB.Add;
1041:
1042: WHEN OTHERS THEN
1043: IF OE_MSG_PUB.Check_Msg_Level
1044: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1045: THEN
1046: OE_MSG_PUB.Add_Exc_Msg
1047: ( G_PKG_NAME ,

Line 1044: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1040: OE_MSG_PUB.Add;
1041:
1042: WHEN OTHERS THEN
1043: IF OE_MSG_PUB.Check_Msg_Level
1044: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1045: THEN
1046: OE_MSG_PUB.Add_Exc_Msg
1047: ( G_PKG_NAME ,
1048: 'Record - Sold To Contact'

Line 1046: OE_MSG_PUB.Add_Exc_Msg

1042: WHEN OTHERS THEN
1043: IF OE_MSG_PUB.Check_Msg_Level
1044: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1045: THEN
1046: OE_MSG_PUB.Add_Exc_Msg
1047: ( G_PKG_NAME ,
1048: 'Record - Sold To Contact'
1049: );
1050: END IF;

Line 1090: OE_MSG_PUB.Add;

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
1093:
1094: IF OE_MSG_PUB.Check_Msg_Level

Line 1094: IF OE_MSG_PUB.Check_Msg_Level

1090: OE_MSG_PUB.Add;
1091:
1092: WHEN OTHERS THEN
1093:
1094: IF OE_MSG_PUB.Check_Msg_Level
1095: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1096: THEN
1097:
1098: OE_MSG_PUB.Add_Exc_Msg

Line 1095: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1091:
1092: WHEN OTHERS THEN
1093:
1094: IF OE_MSG_PUB.Check_Msg_Level
1095: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1096: THEN
1097:
1098: OE_MSG_PUB.Add_Exc_Msg
1099: ( G_PKG_NAME ,

Line 1098: OE_MSG_PUB.Add_Exc_Msg

1094: IF OE_MSG_PUB.Check_Msg_Level
1095: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1096: THEN
1097:
1098: OE_MSG_PUB.Add_Exc_Msg
1099: ( G_PKG_NAME ,
1100: 'Record - Invoice To Contact'
1101: );
1102: END IF;

Line 1145: OE_MSG_PUB.Add;

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
1148:
1149: IF OE_MSG_PUB.Check_Msg_Level

Line 1149: IF OE_MSG_PUB.Check_Msg_Level

1145: OE_MSG_PUB.Add;
1146:
1147: WHEN OTHERS THEN
1148:
1149: IF OE_MSG_PUB.Check_Msg_Level
1150: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1151: THEN
1152:
1153: OE_MSG_PUB.Add_Exc_Msg

Line 1150: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1146:
1147: WHEN OTHERS THEN
1148:
1149: IF OE_MSG_PUB.Check_Msg_Level
1150: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1151: THEN
1152:
1153: OE_MSG_PUB.Add_Exc_Msg
1154: ( G_PKG_NAME ,

Line 1153: OE_MSG_PUB.Add_Exc_Msg

1149: IF OE_MSG_PUB.Check_Msg_Level
1150: (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1151: THEN
1152:
1153: OE_MSG_PUB.Add_Exc_Msg
1154: ( G_PKG_NAME ,
1155: 'Record - Ship To Contact'
1156: );
1157: END IF;

Line 1197: OE_MSG_PUB.Add;

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
1200:
1201: IF OE_MSG_PUB.Check_Msg_Level (

Line 1201: IF OE_MSG_PUB.Check_Msg_Level (

1197: OE_MSG_PUB.Add;
1198:
1199: WHEN OTHERS THEN
1200:
1201: IF OE_MSG_PUB.Check_Msg_Level (
1202: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1203: THEN
1204: OE_MSG_PUB.Add_Exc_Msg
1205: ( G_PKG_NAME ,

Line 1202: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1198:
1199: WHEN OTHERS THEN
1200:
1201: IF OE_MSG_PUB.Check_Msg_Level (
1202: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1203: THEN
1204: OE_MSG_PUB.Add_Exc_Msg
1205: ( G_PKG_NAME ,
1206: 'Record - Deliver To Contact'

Line 1204: OE_MSG_PUB.Add_Exc_Msg

1200:
1201: IF OE_MSG_PUB.Check_Msg_Level (
1202: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1203: THEN
1204: OE_MSG_PUB.Add_Exc_Msg
1205: ( G_PKG_NAME ,
1206: 'Record - Deliver To Contact'
1207: );
1208: END IF;

Line 1302: OE_MSG_PUB.Add;

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

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

1302: OE_MSG_PUB.Add;
1303:
1304: WHEN OTHERS THEN
1305:
1306: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1307: THEN
1308:
1309: OE_MSG_PUB.Add_Exc_Msg
1310: ( G_PKG_NAME ,

Line 1309: OE_MSG_PUB.Add_Exc_Msg

1305:
1306: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1307: THEN
1308:
1309: OE_MSG_PUB.Add_Exc_Msg
1310: ( G_PKG_NAME ,
1311: 'Record - Tax Exempt Number'
1312: );
1313: END IF;

Line 1333: OE_MSG_PUB.ADD;

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

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

1352:
1353: WHEN OTHERS THEN
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1355:
1356: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1357: THEN
1358: OE_MSG_PUB.Add_Exc_Msg
1359: ( G_PKG_NAME
1360: , 'Entity'

Line 1358: OE_MSG_PUB.Add_Exc_Msg

1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1355:
1356: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1357: THEN
1358: OE_MSG_PUB.Add_Exc_Msg
1359: ( G_PKG_NAME
1360: , 'Entity'
1361: );
1362: END IF;

Line 1389: OE_MSG_PUB.add;

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

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

2626:
2627: WHEN OTHERS THEN
2628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2629:
2630: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2631: THEN
2632: OE_MSG_PUB.Add_Exc_Msg
2633: ( G_PKG_NAME
2634: ,'Attributes'

Line 2632: OE_MSG_PUB.Add_Exc_Msg

2628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2629:
2630: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2631: THEN
2632: OE_MSG_PUB.Add_Exc_Msg
2633: ( G_PKG_NAME
2634: ,'Attributes'
2635: );
2636: END IF;