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 385: OE_Order_UTIL.Get_Attribute_Name('ORDER_TYPE_ID'));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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