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_VALIDATE_HEADER dependencies on OE_ORDER_UTIL

Line 73: OE_Order_UTIL.Get_Attribute_Name('QUOTE_NUMBER'));

69: --OR cnd added for Bug 5060064
70: THEN
71: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');
72: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
73: OE_Order_UTIL.Get_Attribute_Name('QUOTE_NUMBER'));
74: OE_MSG_PUB.ADD;
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: END IF;
77:

Line 86: OE_Order_UTIL.Get_Attribute_Name('QUOTE_DATE'));

82: --OR cnd added for Bug 5060064
83: THEN
84: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');
85: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
86: OE_Order_UTIL.Get_Attribute_Name('QUOTE_DATE'));
87: OE_MSG_PUB.ADD;
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: END IF;
90:

Line 99: OE_Order_UTIL.Get_Attribute_Name('EXPIRATION_DATE'));

95: --OR cnd added for Bug 5060064
96: THEN
97: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
99: OE_Order_UTIL.Get_Attribute_Name('EXPIRATION_DATE'));
100: OE_MSG_PUB.ADD;
101: x_return_status := FND_API.G_RET_STS_ERROR;
102: END IF;
103:

Line 122: OE_Order_UTIL.Get_Attribute_Name('ORDER_NUMBER'));

118: --OR cnd added for Bug 5060064
119: THEN
120: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
122: OE_Order_UTIL.Get_Attribute_Name('ORDER_NUMBER'));
123: OE_MSG_PUB.ADD;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: END IF;
126:

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

131: --OR cnd added for Bug 5060064
132: THEN
133: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
134: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
135: OE_Order_UTIL.Get_Attribute_Name('ORDERED_DATE'));
136: OE_MSG_PUB.ADD;
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: END IF;
139:

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

203: THEN
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
206: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
207: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
208: OE_MSG_PUB.ADD;
209: END IF;
210:
211: IF p_header_rec.salesrep_id IS NULL

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

212: THEN
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
215: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
216: OE_Order_UTIL.Get_Attribute_Name('SALESREP_ID'));
217: OE_MSG_PUB.ADD;
218: END IF;
219:
220: IF p_header_rec.ordered_date IS NULL

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

221: THEN
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
224: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
225: OE_Order_UTIL.Get_Attribute_Name('ORDERED_DATE'));
226: OE_MSG_PUB.ADD;
227: END IF;
228:
229: IF p_header_rec.invoice_to_org_id IS NULL

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

230: THEN
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
233: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
234: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
235: OE_MSG_PUB.ADD;
236: END IF;
237:
238: IF p_header_rec.tax_exempt_flag IS NULL

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

239: THEN
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
242: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
243: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
244: OE_MSG_PUB.ADD;
245: END IF;
246:
247:

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

256: THEN
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
260: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
261: OE_MSG_PUB.ADD;
262: END IF;
263:
264: IF p_header_rec.payment_term_id IS NULL

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

265: THEN
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
268: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
269: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
270: OE_MSG_PUB.ADD;
271: END IF;
272:
273: END IF;

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

291: THEN
292: x_return_status := FND_API.G_RET_STS_ERROR;
293: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
294: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
295: OE_Order_UTIL.Get_Attribute_Name('AGREEMENT_ID'));
296: OE_MSG_PUB.ADD;
297: END IF;
298:
299: IF ( l_order_type_rec.require_po_flag = 'Y' AND

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

301: THEN
302: x_return_status := FND_API.G_RET_STS_ERROR;
303: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
305: OE_Order_UTIL.Get_Attribute_Name('CUST_PO_NUMBER'));
306: OE_MSG_PUB.ADD;
307: END IF;
308:
309:

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

354: THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
357: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
358: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_AMOUNT'));
359: OE_MSG_PUB.ADD;
360: END IF;
361:
362: -- check number required IF payment type is Check

Line 778: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));

774:
775: WHEN NO_DATA_FOUND THEN
776: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
777: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
778: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
779: OE_MSG_PUB.Add;
780: if l_debug_level > 0 then
781: OE_DEBUG_PUB.Add('No Data Found when Validating Blanket',3);
782: end if;

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

807: AND ROWNUM = 1;
808: exception
809: when no_data_found then
810: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
812: ('SOLD_TO_ORG_ID'));
813: --for bug 3257240
814: OE_Id_To_Value.Sold_To_Org
815: ( p_sold_to_org_id => l_sold_to_org_id

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

821: x_return_status := FND_API.G_RET_STS_ERROR;
822: end;
823: else
824: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
825: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
826: ('SOLD_TO_ORG_ID'));
827: --for bug 3257240
828: OE_Id_To_Value.Sold_To_Org
829: ( p_sold_to_org_id => l_sold_to_org_id

Line 863: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));

859: oe_debug_pub.add('Request date is not within active blanket dates', 1);
860: end if;
861: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
862: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
863: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
864: OE_MSG_PUB.Add;
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: END IF;
867:

Line 877: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));

873: oe_debug_pub.add('Not an active Blanket for Release', 1);
874: end if;
875: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
876: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
877: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
878: OE_MSG_PUB.Add;
879: x_return_status := FND_API.G_RET_STS_ERROR;
880: END IF;
881:

Line 1014: OE_Order_UTIL.Get_Attribute_Name('HEADER_ID'));

1010: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1011: THEN
1012: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1013: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1014: OE_Order_UTIL.Get_Attribute_Name('HEADER_ID'));
1015: OE_MSG_PUB.Add;
1016: END IF;
1017:
1018: END IF;

Line 1031: OE_Order_UTIL.Get_Attribute_Name('TRANSACTION_PHASE_CODE'));

1027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1028: THEN
1029: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1030: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1031: OE_Order_UTIL.Get_Attribute_Name('TRANSACTION_PHASE_CODE'));
1032: OE_MSG_PUB.Add;
1033: END IF;
1034:
1035: END IF;

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

1046: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1047: THEN
1048: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1049: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1050: OE_Order_UTIL.Get_Attribute_Name('ORDER_TYPE_ID'));
1051: OE_MSG_PUB.Add;
1052: END IF;
1053: ELSE
1054: Validate_Order_Type

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

1066: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1067: THEN
1068: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1070: OE_Order_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE'));
1071: OE_MSG_PUB.Add;
1072: END IF;
1073:
1074: END IF;

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

1171: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1172: THEN
1173: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1174: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1175: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
1176: OE_MSG_PUB.Add;
1177: END IF;
1178:
1179: END IF;

Line 1228: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('CHECK_NUMBER'));

1224:
1225: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1226: THEN
1227: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1228: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('CHECK_NUMBER'));
1229: OE_MSG_PUB.Add;
1230: END IF;
1231: END IF;
1232: END IF;

Line 1242: --FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('CREDIT_CARD_CODE'));

1238: l_return_status := FND_API.G_RET_STS_ERROR;
1239: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1240: THEN
1241: fnd_message.set_name('ONT','OE_VAL_CREDIT_CARD_REQD');
1242: --FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('CREDIT_CARD_CODE'));
1243: OE_MSG_PUB.Add;
1244: END IF;
1245: END IF;
1246: END IF;

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

1421: WHEN NO_DATA_FOUND THEN
1422: l_return_status := FND_API.G_RET_STS_ERROR;
1423: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1425: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));
1426: OE_MSG_PUB.Add;
1427:
1428: WHEN OTHERS THEN
1429:

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

1719: oe_debug_pub.add
1720: ('In: No data found',2);
1721: l_return_status := FND_API.G_RET_STS_ERROR;
1722: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1723: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name
1724: ('ship_to_org_id'));
1725: OE_MSG_PUB.Add;
1726:
1727: WHEN OTHERS THEN

Line 1817: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));

1813: WHEN NO_DATA_FOUND THEN
1814: l_return_status := FND_API.G_RET_STS_ERROR;
1815: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1816: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1817: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
1818: OE_MSG_PUB.Add;
1819:
1820: WHEN OTHERS THEN
1821:

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

1897: WHEN NO_DATA_FOUND THEN
1898: l_return_status := FND_API.G_RET_STS_ERROR;
1899: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1900: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1901: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
1902: OE_MSG_PUB.Add;
1903:
1904: WHEN OTHERS THEN
1905:

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

1952: WHEN NO_DATA_FOUND THEN
1953: l_return_status := FND_API.G_RET_STS_ERROR;
1954: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1955: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1956: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
1957: OE_MSG_PUB.Add;
1958:
1959: WHEN OTHERS THEN
1960:

Line 2008: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_CONTACT_ID'));

2004: WHEN NO_DATA_FOUND THEN
2005: l_return_status := FND_API.G_RET_STS_ERROR;
2006: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2007: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2008: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_CONTACT_ID'));
2009: OE_MSG_PUB.Add;
2010:
2011: WHEN OTHERS THEN
2012: IF OE_MSG_PUB.Check_Msg_Level

Line 2056: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));

2052: WHEN NO_DATA_FOUND THEN
2053: l_return_status := FND_API.G_RET_STS_ERROR;
2054: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2056: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));
2057: OE_MSG_PUB.Add;
2058:
2059: WHEN OTHERS THEN
2060: IF OE_MSG_PUB.Check_Msg_Level

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

2102: WHEN NO_DATA_FOUND THEN
2103: l_return_status := FND_API.G_RET_STS_ERROR;
2104: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2106: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
2107: OE_MSG_PUB.Add;
2108:
2109: WHEN OTHERS THEN
2110: IF OE_MSG_PUB.Check_Msg_Level

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

2159:
2160: l_return_status := FND_API.G_RET_STS_ERROR;
2161: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2163: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_CONTACT_ID'));
2164: OE_MSG_PUB.Add;
2165:
2166:
2167: WHEN OTHERS THEN

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

2219: WHEN NO_DATA_FOUND THEN
2220: l_return_status := FND_API.G_RET_STS_ERROR;
2221: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2222: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2223: OE_Order_Util.Get_Attribute_Name('SHIP_TO_CONTACT_ID'));
2224: OE_MSG_PUB.Add;
2225:
2226:
2227: WHEN OTHERS THEN

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

2279: WHEN NO_DATA_FOUND THEN
2280: l_return_status := FND_API.G_RET_STS_ERROR;
2281: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2283: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_CONTACT_ID'));
2284: OE_MSG_PUB.Add;
2285:
2286: WHEN OTHERS THEN
2287:

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

2411: ELSE
2412: l_return_status := FND_API.G_RET_STS_ERROR;
2413: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2415: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
2416: OE_MSG_PUB.Add;
2417: END IF;
2418:
2419: WHEN OTHERS THEN

Line 2593: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));

2589: p_header_rec.sold_to_org_id is null)
2590: THEN
2591: l_return_status := FND_API.G_RET_STS_ERROR;
2592: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2593: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
2594: OE_MSG_PUB.Add;
2595: ELSIF p_header_rec.ib_owner = 'END_CUSTOMER' AND
2596: p_header_rec.end_customer_id is null
2597: THEN

Line 2600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));

2596: p_header_rec.end_customer_id is null
2597: THEN
2598: l_return_status := FND_API.G_RET_STS_ERROR;
2599: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
2601: OE_MSG_PUB.Add;
2602: END IF;
2603: END IF;
2604: oe_debug_pub.ADD('ib_installed_at_location: '||p_header_rec.ib_installed_at_location);

Line 2621: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));

2617: p_header_rec.invoice_to_org_id is null)
2618: THEN
2619: l_return_status := FND_API.G_RET_STS_ERROR;
2620: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2621: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2622: OE_MSG_PUB.Add;
2623: ELSIF p_header_rec.ib_installed_at_location = 'SHIP_TO' AND
2624: p_header_rec.ship_to_org_id is null
2625: THEN

Line 2628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));

2624: p_header_rec.ship_to_org_id is null
2625: THEN
2626: l_return_status := FND_API.G_RET_STS_ERROR;
2627: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2629: OE_MSG_PUB.Add;
2630: ELSIF p_header_rec.ib_installed_at_location = 'DELIVER_TO' AND
2631: p_header_rec.deliver_to_org_id is null
2632: THEN

Line 2635: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));

2631: p_header_rec.deliver_to_org_id is null
2632: THEN
2633: l_return_status := FND_API.G_RET_STS_ERROR;
2634: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2635: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2636: OE_MSG_PUB.Add;
2637: ELSIF p_header_rec.ib_installed_at_location = 'END_CUSTOMER' AND
2638: p_header_rec.end_customer_site_use_id is null
2639: THEN

Line 2642: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));

2638: p_header_rec.end_customer_site_use_id is null
2639: THEN
2640: l_return_status := FND_API.G_RET_STS_ERROR;
2641: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2642: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2643: OE_MSG_PUB.Add;
2644: ELSIF p_header_rec.ib_installed_at_location = 'SOLD_TO' AND
2645: p_header_rec.sold_to_site_use_id is null
2646: THEN

Line 2649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));

2645: p_header_rec.sold_to_site_use_id is null
2646: THEN
2647: l_return_status := FND_API.G_RET_STS_ERROR;
2648: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2650: OE_MSG_PUB.Add;
2651: END IF;
2652: END IF;
2653: oe_debug_pub.ADD('ib_current_location: '||p_header_rec.ib_current_location);

Line 2670: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));

2666: p_header_rec.invoice_to_org_id is null)
2667: THEN
2668: l_return_status := FND_API.G_RET_STS_ERROR;
2669: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2670: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2671: OE_MSG_PUB.Add;
2672: ELSIF p_header_rec.ib_current_location = 'SHIP_TO' AND
2673: p_header_rec.ship_to_org_id is null
2674: THEN

Line 2677: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));

2673: p_header_rec.ship_to_org_id is null
2674: THEN
2675: l_return_status := FND_API.G_RET_STS_ERROR;
2676: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2677: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2678: OE_MSG_PUB.Add;
2679: ELSIF p_header_rec.ib_current_location = 'DELIVER_TO' AND
2680: p_header_rec.deliver_to_org_id is null
2681: THEN

Line 2684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));

2680: p_header_rec.deliver_to_org_id is null
2681: THEN
2682: l_return_status := FND_API.G_RET_STS_ERROR;
2683: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2685: OE_MSG_PUB.Add;
2686: ELSIF p_header_rec.ib_current_location = 'END_CUSTOMER' AND
2687: p_header_rec.end_customer_site_use_id is null
2688: THEN

Line 2691: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));

2687: p_header_rec.end_customer_site_use_id is null
2688: THEN
2689: l_return_status := FND_API.G_RET_STS_ERROR;
2690: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2691: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2692: OE_MSG_PUB.Add;
2693: ELSIF p_header_rec.ib_current_location = 'SOLD_TO' AND
2694: p_header_rec.sold_to_site_use_id is null
2695: THEN

Line 2698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));

2694: p_header_rec.sold_to_site_use_id is null
2695: THEN
2696: l_return_status := FND_API.G_RET_STS_ERROR;
2697: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2699: OE_MSG_PUB.Add;
2700: END IF;
2701: END IF;
2702:

Line 2725: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));

2721: oe_debug_pub.add('>line_id:'||l.line_id||' has ib_current_location as SOLD_TO');
2722: end if;
2723: l_return_status := FND_API.G_RET_STS_ERROR;
2724: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2725: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2726: OE_MSG_PUB.Add;
2727: elsif l.ib_installed_at_location='SOLD_TO'
2728: then
2729: If l_debug_level > 0 THEN

Line 2734: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));

2730: oe_debug_pub.add('>line_id:'||l.line_id||' has ib_installed_at_location as SOLD_TO');
2731: end if;
2732: l_return_status := FND_API.G_RET_STS_ERROR;
2733: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2734: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2735: OE_MSG_PUB.Add;
2736: end if;
2737: end loop;
2738: end if;