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

743:
744: WHEN NO_DATA_FOUND THEN
745: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
746: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
747: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
748: OE_MSG_PUB.Add;
749: if l_debug_level > 0 then
750: OE_DEBUG_PUB.Add('No Data Found when Validating Blanket',3);
751: end if;

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

776: AND ROWNUM = 1;
777: exception
778: when no_data_found then
779: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
780: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
781: ('SOLD_TO_ORG_ID'));
782: --for bug 3257240
783: OE_Id_To_Value.Sold_To_Org
784: ( p_sold_to_org_id => l_sold_to_org_id

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

790: x_return_status := FND_API.G_RET_STS_ERROR;
791: end;
792: else
793: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
794: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
795: ('SOLD_TO_ORG_ID'));
796: --for bug 3257240
797: OE_Id_To_Value.Sold_To_Org
798: ( p_sold_to_org_id => l_sold_to_org_id

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

828: oe_debug_pub.add('Request date is not within active blanket dates', 1);
829: end if;
830: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
831: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
832: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
833: OE_MSG_PUB.Add;
834: x_return_status := FND_API.G_RET_STS_ERROR;
835: END IF;
836:

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

842: oe_debug_pub.add('Not an active Blanket for Release', 1);
843: end if;
844: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
845: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
846: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
847: OE_MSG_PUB.Add;
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: END IF;
850:

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

979: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
980: THEN
981: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
982: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
983: OE_Order_UTIL.Get_Attribute_Name('HEADER_ID'));
984: OE_MSG_PUB.Add;
985: END IF;
986:
987: END IF;

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

996: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
997: THEN
998: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
999: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1000: OE_Order_UTIL.Get_Attribute_Name('TRANSACTION_PHASE_CODE'));
1001: OE_MSG_PUB.Add;
1002: END IF;
1003:
1004: END IF;

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

1015: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1016: THEN
1017: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1018: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1019: OE_Order_UTIL.Get_Attribute_Name('ORDER_TYPE_ID'));
1020: OE_MSG_PUB.Add;
1021: END IF;
1022: ELSE
1023: Validate_Order_Type

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

1035: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1036: THEN
1037: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1038: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1039: OE_Order_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE'));
1040: OE_MSG_PUB.Add;
1041: END IF;
1042:
1043: END IF;

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

1140: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1141: THEN
1142: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1143: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1144: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
1145: OE_MSG_PUB.Add;
1146: END IF;
1147:
1148: END IF;

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

1353: WHEN NO_DATA_FOUND THEN
1354: l_return_status := FND_API.G_RET_STS_ERROR;
1355: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1356: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1357: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));
1358: OE_MSG_PUB.Add;
1359:
1360: WHEN OTHERS THEN
1361:

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

1651: oe_debug_pub.add
1652: ('In: No data found',2);
1653: l_return_status := FND_API.G_RET_STS_ERROR;
1654: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1655: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name
1656: ('ship_to_org_id'));
1657: OE_MSG_PUB.Add;
1658:
1659: WHEN OTHERS THEN

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

1745: WHEN NO_DATA_FOUND THEN
1746: l_return_status := FND_API.G_RET_STS_ERROR;
1747: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1748: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1749: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
1750: OE_MSG_PUB.Add;
1751:
1752: WHEN OTHERS THEN
1753:

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

1829: WHEN NO_DATA_FOUND THEN
1830: l_return_status := FND_API.G_RET_STS_ERROR;
1831: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1832: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1833: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
1834: OE_MSG_PUB.Add;
1835:
1836: WHEN OTHERS THEN
1837:

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

1883: WHEN NO_DATA_FOUND THEN
1884: l_return_status := FND_API.G_RET_STS_ERROR;
1885: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1886: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1887: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
1888: OE_MSG_PUB.Add;
1889:
1890: WHEN OTHERS THEN
1891:

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

1935: WHEN NO_DATA_FOUND THEN
1936: l_return_status := FND_API.G_RET_STS_ERROR;
1937: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1938: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1939: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_CONTACT_ID'));
1940: OE_MSG_PUB.Add;
1941:
1942: WHEN OTHERS THEN
1943: IF OE_MSG_PUB.Check_Msg_Level

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

1983: WHEN NO_DATA_FOUND THEN
1984: l_return_status := FND_API.G_RET_STS_ERROR;
1985: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1986: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1987: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));
1988: OE_MSG_PUB.Add;
1989:
1990: WHEN OTHERS THEN
1991: IF OE_MSG_PUB.Check_Msg_Level

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

2033: WHEN NO_DATA_FOUND THEN
2034: l_return_status := FND_API.G_RET_STS_ERROR;
2035: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2036: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2037: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
2038: OE_MSG_PUB.Add;
2039:
2040: WHEN OTHERS THEN
2041: IF OE_MSG_PUB.Check_Msg_Level

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

2090:
2091: l_return_status := FND_API.G_RET_STS_ERROR;
2092: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2093: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2094: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_CONTACT_ID'));
2095: OE_MSG_PUB.Add;
2096:
2097:
2098: WHEN OTHERS THEN

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

2150: WHEN NO_DATA_FOUND THEN
2151: l_return_status := FND_API.G_RET_STS_ERROR;
2152: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2153: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2154: OE_Order_Util.Get_Attribute_Name('SHIP_TO_CONTACT_ID'));
2155: OE_MSG_PUB.Add;
2156:
2157:
2158: WHEN OTHERS THEN

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

2210: WHEN NO_DATA_FOUND THEN
2211: l_return_status := FND_API.G_RET_STS_ERROR;
2212: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2214: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_CONTACT_ID'));
2215: OE_MSG_PUB.Add;
2216:
2217: WHEN OTHERS THEN
2218:

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

2342: ELSE
2343: l_return_status := FND_API.G_RET_STS_ERROR;
2344: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2345: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2346: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
2347: OE_MSG_PUB.Add;
2348: END IF;
2349:
2350: WHEN OTHERS THEN

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

2520: p_header_rec.sold_to_org_id is null)
2521: THEN
2522: l_return_status := FND_API.G_RET_STS_ERROR;
2523: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2524: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
2525: OE_MSG_PUB.Add;
2526: ELSIF p_header_rec.ib_owner = 'END_CUSTOMER' AND
2527: p_header_rec.end_customer_id is null
2528: THEN

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

2527: p_header_rec.end_customer_id is null
2528: THEN
2529: l_return_status := FND_API.G_RET_STS_ERROR;
2530: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2531: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
2532: OE_MSG_PUB.Add;
2533: END IF;
2534: END IF;
2535: oe_debug_pub.ADD('ib_installed_at_location: '||p_header_rec.ib_installed_at_location);

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

2548: p_header_rec.invoice_to_org_id is null)
2549: THEN
2550: l_return_status := FND_API.G_RET_STS_ERROR;
2551: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2552: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2553: OE_MSG_PUB.Add;
2554: ELSIF p_header_rec.ib_installed_at_location = 'SHIP_TO' AND
2555: p_header_rec.ship_to_org_id is null
2556: THEN

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

2555: p_header_rec.ship_to_org_id is null
2556: THEN
2557: l_return_status := FND_API.G_RET_STS_ERROR;
2558: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2559: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2560: OE_MSG_PUB.Add;
2561: ELSIF p_header_rec.ib_installed_at_location = 'DELIVER_TO' AND
2562: p_header_rec.deliver_to_org_id is null
2563: THEN

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

2562: p_header_rec.deliver_to_org_id is null
2563: THEN
2564: l_return_status := FND_API.G_RET_STS_ERROR;
2565: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2566: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2567: OE_MSG_PUB.Add;
2568: ELSIF p_header_rec.ib_installed_at_location = 'END_CUSTOMER' AND
2569: p_header_rec.end_customer_site_use_id is null
2570: THEN

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

2569: p_header_rec.end_customer_site_use_id is null
2570: THEN
2571: l_return_status := FND_API.G_RET_STS_ERROR;
2572: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2574: OE_MSG_PUB.Add;
2575: ELSIF p_header_rec.ib_installed_at_location = 'SOLD_TO' AND
2576: p_header_rec.sold_to_site_use_id is null
2577: THEN

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

2576: p_header_rec.sold_to_site_use_id is null
2577: THEN
2578: l_return_status := FND_API.G_RET_STS_ERROR;
2579: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2580: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2581: OE_MSG_PUB.Add;
2582: END IF;
2583: END IF;
2584: oe_debug_pub.ADD('ib_current_location: '||p_header_rec.ib_current_location);

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

2597: p_header_rec.invoice_to_org_id is null)
2598: THEN
2599: l_return_status := FND_API.G_RET_STS_ERROR;
2600: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2601: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2602: OE_MSG_PUB.Add;
2603: ELSIF p_header_rec.ib_current_location = 'SHIP_TO' AND
2604: p_header_rec.ship_to_org_id is null
2605: THEN

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

2604: p_header_rec.ship_to_org_id is null
2605: THEN
2606: l_return_status := FND_API.G_RET_STS_ERROR;
2607: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2609: OE_MSG_PUB.Add;
2610: ELSIF p_header_rec.ib_current_location = 'DELIVER_TO' AND
2611: p_header_rec.deliver_to_org_id is null
2612: THEN

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

2611: p_header_rec.deliver_to_org_id is null
2612: THEN
2613: l_return_status := FND_API.G_RET_STS_ERROR;
2614: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2615: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2616: OE_MSG_PUB.Add;
2617: ELSIF p_header_rec.ib_current_location = 'END_CUSTOMER' AND
2618: p_header_rec.end_customer_site_use_id is null
2619: THEN

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

2618: p_header_rec.end_customer_site_use_id is null
2619: THEN
2620: l_return_status := FND_API.G_RET_STS_ERROR;
2621: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2623: OE_MSG_PUB.Add;
2624: ELSIF p_header_rec.ib_current_location = 'SOLD_TO' AND
2625: p_header_rec.sold_to_site_use_id is null
2626: THEN

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

2625: p_header_rec.sold_to_site_use_id is null
2626: THEN
2627: l_return_status := FND_API.G_RET_STS_ERROR;
2628: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2629: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2630: OE_MSG_PUB.Add;
2631: END IF;
2632: END IF;
2633:

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

2652: oe_debug_pub.add('>line_id:'||l.line_id||' has ib_current_location as SOLD_TO');
2653: end if;
2654: l_return_status := FND_API.G_RET_STS_ERROR;
2655: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2656: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2657: OE_MSG_PUB.Add;
2658: elsif l.ib_installed_at_location='SOLD_TO'
2659: then
2660: If l_debug_level > 0 THEN

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

2661: oe_debug_pub.add('>line_id:'||l.line_id||' has ib_installed_at_location as SOLD_TO');
2662: end if;
2663: l_return_status := FND_API.G_RET_STS_ERROR;
2664: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2666: OE_MSG_PUB.Add;
2667: end if;
2668: end loop;
2669: end if;