DBA Data[Home] [Help]

APPS.OE_CNCL_VALIDATE_HEADER dependencies on OE_ORDER_UTIL

Line 36: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));

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

Line 45: OE_Order_UTIL.Get_Attribute_Name('SALESREP_ID'));

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

Line 54: OE_Order_UTIL.Get_Attribute_Name('ORDERED_DATE'));

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

Line 63: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));

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

Line 72: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));

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

Line 91: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));

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

Line 100: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));

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

Line 119: OE_Order_UTIL.Get_Attribute_Name('AGREEMENT_ID'));

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:
123: IF ( l_order_type_rec.require_po_flag = 'Y' AND

Line 129: OE_Order_UTIL.Get_Attribute_Name('CUST_PO_NUMBER'));

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

Line 183: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_AMOUNT'));

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

Line 386: OE_Order_UTIL.Get_Attribute_Name('ORDER_TYPE_ID'));

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

Line 404: OE_Order_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE'));

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

Line 453: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));

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

Line 610: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));

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

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 860: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));

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

Line 954: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));

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

Line 996: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));

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

Line 1039: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));

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

Line 1089: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_CONTACT_ID'));

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

Line 1144: OE_Order_Util.Get_Attribute_Name('SHIP_TO_CONTACT_ID'));

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

Line 1196: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_CONTACT_ID'));

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

Line 1301: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));

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