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_BULK_PROCESS_LINE dependencies on FND_MESSAGE

Line 64: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

60: -- Check for fields required on a booked order line
61:
62: IF p_line_rec.sold_to_org_id(p_index) IS NULL THEN
63: x_return_status := FND_API.G_RET_STS_ERROR;
64: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
65: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
66: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
67: OE_BULK_MSG_PUB.ADD;
68: END IF;

Line 65: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

61:
62: IF p_line_rec.sold_to_org_id(p_index) IS NULL THEN
63: x_return_status := FND_API.G_RET_STS_ERROR;
64: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
65: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
66: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
67: OE_BULK_MSG_PUB.ADD;
68: END IF;
69:

Line 72: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

68: END IF;
69:
70: IF p_line_rec.invoice_to_org_id(p_index) IS NULL THEN
71: x_return_status := FND_API.G_RET_STS_ERROR;
72: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
73: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
74: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
75: OE_BULK_MSG_PUB.ADD;
76: END IF;

Line 73: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

69:
70: IF p_line_rec.invoice_to_org_id(p_index) IS NULL THEN
71: x_return_status := FND_API.G_RET_STS_ERROR;
72: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
73: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
74: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
75: OE_BULK_MSG_PUB.ADD;
76: END IF;
77:

Line 80: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

76: END IF;
77:
78: IF p_line_rec.tax_exempt_flag(p_index) IS NULL THEN
79: x_return_status := FND_API.G_RET_STS_ERROR;
80: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
81: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
82: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
83: OE_BULK_MSG_PUB.ADD;
84: END IF;

Line 81: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

77:
78: IF p_line_rec.tax_exempt_flag(p_index) IS NULL THEN
79: x_return_status := FND_API.G_RET_STS_ERROR;
80: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
81: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
82: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
83: OE_BULK_MSG_PUB.ADD;
84: END IF;
85:

Line 90: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

86: -- Quantity and UOM Required
87:
88: IF p_line_rec.order_quantity_uom(p_index) IS NULL THEN
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
91: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
92: OE_Order_UTIL.Get_Attribute_Name('ORDER_QUANTITY_UOM'));
93: OE_BULK_MSG_PUB.ADD;
94: END IF;

Line 91: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

87:
88: IF p_line_rec.order_quantity_uom(p_index) IS NULL THEN
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
91: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
92: OE_Order_UTIL.Get_Attribute_Name('ORDER_QUANTITY_UOM'));
93: OE_BULK_MSG_PUB.ADD;
94: END IF;
95:

Line 100: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

96: -- Fix bug 1277092: ordered quantity should not be = 0 on a booked line
97: IF p_line_rec.ordered_quantity(p_index) IS NULL
98: OR p_line_rec.ordered_quantity(p_index) = 0 THEN
99: x_return_status := FND_API.G_RET_STS_ERROR;
100: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
102: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));
103: OE_BULK_MSG_PUB.ADD;
104: END IF;

Line 101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

97: IF p_line_rec.ordered_quantity(p_index) IS NULL
98: OR p_line_rec.ordered_quantity(p_index) = 0 THEN
99: x_return_status := FND_API.G_RET_STS_ERROR;
100: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
102: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));
103: OE_BULK_MSG_PUB.ADD;
104: END IF;
105:

Line 115: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

111: <> OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
112:
113: IF p_line_rec.ship_to_org_id(p_index) IS NULL THEN
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
116: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
117: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
118: OE_BULK_MSG_PUB.ADD;
119: END IF;

Line 116: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

112:
113: IF p_line_rec.ship_to_org_id(p_index) IS NULL THEN
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
116: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
117: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
118: OE_BULK_MSG_PUB.ADD;
119: END IF;
120:

Line 123: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

119: END IF;
120:
121: IF p_line_rec.payment_term_id(p_index) IS NULL THEN
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
124: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
125: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
126: OE_BULK_MSG_PUB.ADD;
127: END IF;

Line 124: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

120:
121: IF p_line_rec.payment_term_id(p_index) IS NULL THEN
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
124: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
125: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
126: OE_BULK_MSG_PUB.ADD;
127: END IF;
128: --serla

Line 146: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

142: END IF;
143: IF l_rule_type = 'ACC_DUR' THEN
144: IF p_line_rec.accounting_rule_duration(p_index) IS NULL THEN
145: x_return_status := FND_API.G_RET_STS_ERROR;
146: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
147: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
148: OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_DURATION'));
149: OE_BULK_MSG_PUB.ADD;
150: END IF; -- end of accounting_rule_duration null

Line 147: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

143: IF l_rule_type = 'ACC_DUR' THEN
144: IF p_line_rec.accounting_rule_duration(p_index) IS NULL THEN
145: x_return_status := FND_API.G_RET_STS_ERROR;
146: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
147: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
148: OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_DURATION'));
149: OE_BULK_MSG_PUB.ADD;
150: END IF; -- end of accounting_rule_duration null
151: END IF; -- end of variable accounting rule type

Line 165: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

161: -- Commenting out as of 1/23/2003 as tax checks not req'd
162: /*
163: IF p_line_rec.tax_date(p_index) IS NULL THEN
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
166: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
167: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
168: OE_BULK_MSG_PUB.ADD;
169: END IF;

Line 166: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

162: /*
163: IF p_line_rec.tax_date(p_index) IS NULL THEN
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
166: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
167: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
168: OE_BULK_MSG_PUB.ADD;
169: END IF;
170: */

Line 184: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

180: IF p_line_rec.calculate_price_flag(p_index) = 'N' THEN
181:
182: IF p_line_rec.price_list_id(p_index) IS NULL THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
185: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
186: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
187: OE_BULK_MSG_PUB.ADD;
188: END IF;

Line 185: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

181:
182: IF p_line_rec.price_list_id(p_index) IS NULL THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
185: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
186: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
187: OE_BULK_MSG_PUB.ADD;
188: END IF;
189:

Line 234: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_QUANTITY');

230:
231: -- Check for Required Scheduling Attributes
232:
233: IF p_line_rec.ordered_quantity(p_index) IS NULL THEN
234: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_QUANTITY');
235: OE_BULK_MSG_PUB.Add;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: END IF;
238:

Line 244: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ZERO_QTY');

240: -- missing) and if the user is trying to performing scheduling,
241: -- it is an error
242:
243: IF p_line_rec.ordered_quantity(p_index) = 0 THEN
244: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ZERO_QTY');
245: OE_BULK_MSG_PUB.Add;
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: END IF;
248:

Line 257: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_UOM');

253: -- and if the user is trying to performing scheduling,
254: -- it is an error
255:
256: IF p_line_rec.order_quantity_uom(p_index) IS NULL THEN
257: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_UOM');
258: OE_BULK_MSG_PUB.Add;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: END IF;
261:

Line 269: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_REQUEST_DATE');

265: -- if the user is trying to performing scheduling,
266: -- it is an error
267:
268: IF p_line_rec.request_date(p_index) IS NULL THEN
269: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_REQUEST_DATE');
270: OE_BULK_MSG_PUB.Add;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: END IF;
273:

Line 294: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');

290: IF l_debug_level > 0 THEN
291: oe_debug_pub.add( 'CHECKING THAT IT IS A STANDARD ITEM...' , 1 ) ;
292: END IF;
293:
294: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
295: FND_MESSAGE.SET_TOKEN('LTYPE',
296: nvl(Oe_Schedule_Util.sch_cached_line_type ,'0'));
297: OE_BULK_MSG_PUB.Add;
298:

Line 295: FND_MESSAGE.SET_TOKEN('LTYPE',

291: oe_debug_pub.add( 'CHECKING THAT IT IS A STANDARD ITEM...' , 1 ) ;
292: END IF;
293:
294: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
295: FND_MESSAGE.SET_TOKEN('LTYPE',
296: nvl(Oe_Schedule_Util.sch_cached_line_type ,'0'));
297: OE_BULK_MSG_PUB.Add;
298:
299: IF l_debug_level > 0 THEN

Line 316: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATO_WHSE_REQD');

312: THEN
313: IF MSC_ATP_GLOBAL.GET_APS_VERSION <> 10 AND
314: p_line_rec.ship_from_org_id(p_index) is NULL
315: THEN
316: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATO_WHSE_REQD');
317: OE_BULK_MSG_PUB.Add;
318: IF l_debug_level > 0 THEN
319: oe_debug_pub.add( 'OE_SCH_ATO_WHSE_REQD' , 1 ) ;
320: END IF;

Line 358: FND_MESSAGE.SET_NAME('ONT','OE_BOM_NO_BILL_IN_SHP_ORG');

354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( 'OE_BOM_NO_BILL_IN_SHP_ORG' , 2 ) ;
356: END IF;
357:
358: FND_MESSAGE.SET_NAME('ONT','OE_BOM_NO_BILL_IN_SHP_ORG');
359: FND_MESSAGE.SET_TOKEN('ITEM',p_line_rec.ordered_item(p_index));
360:
361: Select ORGANIZATION_CODE
362: Into l_org_code

Line 359: FND_MESSAGE.SET_TOKEN('ITEM',p_line_rec.ordered_item(p_index));

355: oe_debug_pub.add( 'OE_BOM_NO_BILL_IN_SHP_ORG' , 2 ) ;
356: END IF;
357:
358: FND_MESSAGE.SET_NAME('ONT','OE_BOM_NO_BILL_IN_SHP_ORG');
359: FND_MESSAGE.SET_TOKEN('ITEM',p_line_rec.ordered_item(p_index));
360:
361: Select ORGANIZATION_CODE
362: Into l_org_code
363: From ORG_ORGANIZATION_DEFINITIONS

Line 368: FND_MESSAGE.SET_TOKEN('ORG',l_org_code);

364: Where ORGANIZATION_ID = l_org_id;
365: IF l_debug_level > 0 THEN
366: oe_debug_pub.add( 'ORGANIZATION CODE:'||L_ORG_CODE , 2 ) ;
367: END IF;
368: FND_MESSAGE.SET_TOKEN('ORG',l_org_code);
369: OE_MSG_PUB.Add;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371:
372: WHEN OTHERS THEN

Line 617: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_CUSTOMER_ID');

613: IF p_line_rec.sold_to_org_id(p_index) IS NULL THEN
614: IF l_debug_level > 0 THEN
615: oe_debug_pub.add( 'SOLD TO ORG ID IS MISSING , CAN NOT GET CUST ITEM' ) ;
616: END IF;
617: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_CUSTOMER_ID');
618: OE_BULK_MSG_PUB.Add;
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;
621:

Line 640: FND_MESSAGE.SET_NAME('ONT','OE_INV_CUS_ITEM');

636: IF l_error_message IS NOT NULL THEN
637: IF l_debug_level > 0 THEN
638: oe_debug_pub.add( 'INV API CI_ATTR_VAL FOR INV_ITEM_ID RETURNED ERROR' ) ;
639: END IF;
640: FND_MESSAGE.SET_NAME('ONT','OE_INV_CUS_ITEM');
641: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code);
642: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', l_error_message);
643: OE_BULK_MSG_PUB.Add;
644: END IF;

Line 641: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code);

637: IF l_debug_level > 0 THEN
638: oe_debug_pub.add( 'INV API CI_ATTR_VAL FOR INV_ITEM_ID RETURNED ERROR' ) ;
639: END IF;
640: FND_MESSAGE.SET_NAME('ONT','OE_INV_CUS_ITEM');
641: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code);
642: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', l_error_message);
643: OE_BULK_MSG_PUB.Add;
644: END IF;
645:

Line 642: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', l_error_message);

638: oe_debug_pub.add( 'INV API CI_ATTR_VAL FOR INV_ITEM_ID RETURNED ERROR' ) ;
639: END IF;
640: FND_MESSAGE.SET_NAME('ONT','OE_INV_CUS_ITEM');
641: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code);
642: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', l_error_message);
643: OE_BULK_MSG_PUB.Add;
644: END IF;
645:
646: INV_CUSTOMER_ITEM_GRP.CI_Attribute_Value(

Line 664: FND_MESSAGE.SET_NAME('ONT','OE_INV_CUS_ITEM');

660: IF l_error_message IS NOT NULL THEN
661: IF l_debug_level > 0 THEN
662: oe_debug_pub.add( 'INV API CI_ATTR_VAL FOR ORDERED_ITEM_ID RETURNED ERROR' ) ;
663: END IF;
664: FND_MESSAGE.SET_NAME('ONT','OE_INV_CUS_ITEM');
665: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code);
666: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', l_error_message);
667: OE_BULK_MSG_PUB.Add;
668: END IF;

Line 665: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code);

661: IF l_debug_level > 0 THEN
662: oe_debug_pub.add( 'INV API CI_ATTR_VAL FOR ORDERED_ITEM_ID RETURNED ERROR' ) ;
663: END IF;
664: FND_MESSAGE.SET_NAME('ONT','OE_INV_CUS_ITEM');
665: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code);
666: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', l_error_message);
667: OE_BULK_MSG_PUB.Add;
668: END IF;
669:

Line 666: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', l_error_message);

662: oe_debug_pub.add( 'INV API CI_ATTR_VAL FOR ORDERED_ITEM_ID RETURNED ERROR' ) ;
663: END IF;
664: FND_MESSAGE.SET_NAME('ONT','OE_INV_CUS_ITEM');
665: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code);
666: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', l_error_message);
667: OE_BULK_MSG_PUB.Add;
668: END IF;
669:
670: IF l_inventory_item_id_int <> l_inventory_item_id_cust THEN

Line 674: FND_MESSAGE.SET_NAME('ONT','OE_INV_INT_CUS_ITEM_ID');

670: IF l_inventory_item_id_int <> l_inventory_item_id_cust THEN
671: IF l_debug_level > 0 THEN
672: oe_debug_pub.add( 'INV ITEM AND CUST ITEM MISMATCH' ) ;
673: END IF;
674: FND_MESSAGE.SET_NAME('ONT','OE_INV_INT_CUS_ITEM_ID');
675: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_inventory_item_id_int);
676: FND_MESSAGE.SET_TOKEN('CUST_ITEM_ID',l_inventory_item_id_cust);
677: OE_BULK_MSG_PUB.Add;
678: ELSIF l_inventory_item_id_int IS NOT NULL

Line 675: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_inventory_item_id_int);

671: IF l_debug_level > 0 THEN
672: oe_debug_pub.add( 'INV ITEM AND CUST ITEM MISMATCH' ) ;
673: END IF;
674: FND_MESSAGE.SET_NAME('ONT','OE_INV_INT_CUS_ITEM_ID');
675: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_inventory_item_id_int);
676: FND_MESSAGE.SET_TOKEN('CUST_ITEM_ID',l_inventory_item_id_cust);
677: OE_BULK_MSG_PUB.Add;
678: ELSIF l_inventory_item_id_int IS NOT NULL
679: THEN

Line 676: FND_MESSAGE.SET_TOKEN('CUST_ITEM_ID',l_inventory_item_id_cust);

672: oe_debug_pub.add( 'INV ITEM AND CUST ITEM MISMATCH' ) ;
673: END IF;
674: FND_MESSAGE.SET_NAME('ONT','OE_INV_INT_CUS_ITEM_ID');
675: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_inventory_item_id_int);
676: FND_MESSAGE.SET_TOKEN('CUST_ITEM_ID',l_inventory_item_id_cust);
677: OE_BULK_MSG_PUB.Add;
678: ELSIF l_inventory_item_id_int IS NOT NULL
679: THEN
680: p_line_rec.inventory_item_id(p_index):= l_inventory_item_id_int;

Line 713: FND_MESSAGE.SET_NAME('ONT','OE_NOT_UNIQUE_ITEM');

709: WHEN TOO_MANY_ROWS THEN
710: IF l_debug_level > 0 THEN
711: oe_debug_pub.add( 'TOO MANY ROWS ERROR: '||SQLERRM ) ;
712: END IF;
713: FND_MESSAGE.SET_NAME('ONT','OE_NOT_UNIQUE_ITEM');
714: FND_MESSAGE.SET_TOKEN('GENERIC_ITEM', p_line_rec.ordered_item(p_index));
715: OE_BULK_MSG_PUB.Add;
716: END;
717:

Line 714: FND_MESSAGE.SET_TOKEN('GENERIC_ITEM', p_line_rec.ordered_item(p_index));

710: IF l_debug_level > 0 THEN
711: oe_debug_pub.add( 'TOO MANY ROWS ERROR: '||SQLERRM ) ;
712: END IF;
713: FND_MESSAGE.SET_NAME('ONT','OE_NOT_UNIQUE_ITEM');
714: FND_MESSAGE.SET_TOKEN('GENERIC_ITEM', p_line_rec.ordered_item(p_index));
715: OE_BULK_MSG_PUB.Add;
716: END;
717:
718: IF l_inventory_item_Id_int <> l_inventory_item_id_gen

Line 723: FND_MESSAGE.SET_NAME('ONT','OE_INV_INT_CUS_ITEM_ID');

719: THEN
720: IF l_debug_level > 0 THEN
721: oe_debug_pub.add( 'WARNING: GENERIC AND INVENTORY ITEM ARE DIFFERENT' ) ;
722: END IF;
723: FND_MESSAGE.SET_NAME('ONT','OE_INV_INT_CUS_ITEM_ID');
724: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', l_inventory_item_id_int);
725: FND_MESSAGE.SET_TOKEN('CUST_ITEM_ID', l_inventory_item_id_gen);
726: OE_BULK_MSG_PUB.Add;
727: p_line_rec.inventory_item_id(p_index):= l_inventory_item_id_gen;

Line 724: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', l_inventory_item_id_int);

720: IF l_debug_level > 0 THEN
721: oe_debug_pub.add( 'WARNING: GENERIC AND INVENTORY ITEM ARE DIFFERENT' ) ;
722: END IF;
723: FND_MESSAGE.SET_NAME('ONT','OE_INV_INT_CUS_ITEM_ID');
724: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', l_inventory_item_id_int);
725: FND_MESSAGE.SET_TOKEN('CUST_ITEM_ID', l_inventory_item_id_gen);
726: OE_BULK_MSG_PUB.Add;
727: p_line_rec.inventory_item_id(p_index):= l_inventory_item_id_gen;
728: ELSIF l_inventory_item_id_int IS NOT NULL

Line 725: FND_MESSAGE.SET_TOKEN('CUST_ITEM_ID', l_inventory_item_id_gen);

721: oe_debug_pub.add( 'WARNING: GENERIC AND INVENTORY ITEM ARE DIFFERENT' ) ;
722: END IF;
723: FND_MESSAGE.SET_NAME('ONT','OE_INV_INT_CUS_ITEM_ID');
724: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', l_inventory_item_id_int);
725: FND_MESSAGE.SET_TOKEN('CUST_ITEM_ID', l_inventory_item_id_gen);
726: OE_BULK_MSG_PUB.Add;
727: p_line_rec.inventory_item_id(p_index):= l_inventory_item_id_gen;
728: ELSIF l_inventory_item_id_int IS NOT NULL
729: THEN

Line 786: fnd_message.set_name('ONT','OE_SUBINV_INVALID');

782: WHERE organization_id = p_ship_from_org_id
783: AND secondary_inventory_name = p_subinventory;
784: EXCEPTION
785: WHEN OTHERS THEN
786: fnd_message.set_name('ONT','OE_SUBINV_INVALID');
787: OE_BULK_MSG_PUB.Add;
788: RETURN FALSE;
789: END;
790:

Line 797: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');

793: IF p_source_type_code = 'INTERNAL' THEN
794:
795: IF p_ship_from_org_id is null THEN
796:
797: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
798: fnd_message.set_token('ATTRIBUTE'
799: ,OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
800: OE_BULK_MSG_PUB.Add;
801: RETURN FALSE;

Line 798: fnd_message.set_token('ATTRIBUTE'

794:
795: IF p_ship_from_org_id is null THEN
796:
797: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
798: fnd_message.set_token('ATTRIBUTE'
799: ,OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
800: OE_BULK_MSG_PUB.Add;
801: RETURN FALSE;
802:

Line 845: fnd_message.set_name('ONT', 'OE_SUBINV_NON_ASSET');

841: )
842: );
843: EXCEPTION
844: WHEN OTHERS THEN
845: fnd_message.set_name('ONT', 'OE_SUBINV_NON_ASSET');
846: OE_BULK_MSG_PUB.ADD;
847: RETURN FALSE;
848: END;
849:

Line 1005: FND_MESSAGE.SET_NAME('ONT', 'SO_PR_NEGATIVE_AMOUNT');

1001: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1002: IF nvl(p_input_quantity, 0) < 0 -- Process HVOP added check for negative as was missing -NB take out when support for RMAs needed
1003:
1004: THEN
1005: FND_MESSAGE.SET_NAME('ONT', 'SO_PR_NEGATIVE_AMOUNT');
1006: OE_BULK_MSG_PUB.Add('Y','ERROR');
1007: x_return_status := -99;
1008: IF l_debug_level > 0 THEN
1009: oe_debug_pub.add ('Validate decimal quantity - quantity negative so error ', 3);

Line 1026: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');

1022: THEN
1023: IF l_debug_level > 0 THEN
1024: oe_debug_pub.add( 'ITEM IS CONFIG RELATED WITH DECIMAL QTY' , 2 ) ;
1025: END IF;
1026: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
1027: OE_BULK_MSG_PUB.Add('Y','ERROR');
1028: x_return_status := -99;
1029:
1030: ELSE

Line 1052: fnd_message.set_name('ONT', 'OE_DECIMAL_MAX_PRECISION');

1048: oe_debug_pub.add( 'L_VAL_QTY '|| L_VALIDATED_QUANTITY , 2 ) ;
1049: END IF;
1050: /* bug 2926436 */
1051: IF l_qty_return_status = 'W' THEN
1052: fnd_message.set_name('ONT', 'OE_DECIMAL_MAX_PRECISION');
1053: END IF;
1054: --move INV error message to OE message stack
1055: OE_BULK_MSG_PUB.Add('Y','ERROR');
1056: x_return_status := -99;

Line 1243: fnd_message.set_name('ONT','ONT_USER_ITEM_DESC_TOO_LONG');

1239: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1240: --
1241: BEGIN
1242: IF LENGTHB(p_user_item_description) > 240 THEN
1243: fnd_message.set_name('ONT','ONT_USER_ITEM_DESC_TOO_LONG');
1244: OE_BULK_MSG_PUB.ADD;
1245: IF l_debug_level > 0 THEN
1246: oe_debug_pub.add( 'THE LENGTH OF USER_ITEM_DESCRIPTION SHOULD NOT EXCEED 240 CHARA CTERS FOR DROP SHIP LINES.' , 3 ) ;
1247: END IF;

Line 1628: FND_MESSAGE.SET_NAME('ONT','OE_BULK_DIFF_INVOICE_TO');

1624: OE_Bulk_Order_PVT.g_header_rec.invoice_to_org_id(p_header_index);
1625: ELSIF p_line_rec.invoice_to_org_id(p_index) <>
1626: OE_Bulk_Order_PVT.g_header_rec.invoice_to_org_id(p_header_index)
1627: THEN
1628: FND_MESSAGE.SET_NAME('ONT','OE_BULK_DIFF_INVOICE_TO');
1629: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1630: x_return_status := FND_API.G_RET_STS_ERROR;
1631: END IF;
1632:

Line 1751: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');

1747: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4
1748: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')
1749: THEN -- Service item type
1750: oe_debug_pub.add( 'Populate_Internal_Fields ab' ) ;
1751: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');
1752: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1753: x_return_status := FND_API.G_RET_STS_ERROR;
1754: x_unsupported_feature := 'Y';
1755: p_line_rec.lock_control(p_index) := -98;

Line 1886: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');

1882: -- ATO Items
1883: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).replenish_to_order_flag = 'Y')
1884: THEN
1885: oe_debug_pub.add( 'Populate_Internal_Fields 4a' ) ;
1886: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');
1887: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1888: x_return_status := FND_API.G_RET_STS_ERROR;
1889: x_unsupported_feature := 'Y';
1890: p_line_rec.lock_control(p_index) := -98;

Line 1963: FND_MESSAGE.SET_NAME('ONT','OE_BULK_OPM_DUAL_QTY_ERROR'); -- HVOP define better OM or GMI error code

1959: IF l_debug_level > 0 THEN
1960: oe_debug_pub.add( 'error in calculate_dual_quantity 2 ' ) ;
1961: END IF;
1962:
1963: FND_MESSAGE.SET_NAME('ONT','OE_BULK_OPM_DUAL_QTY_ERROR'); -- HVOP define better OM or GMI error code
1964: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1965: x_return_status := FND_API.G_RET_STS_ERROR;
1966: END IF;
1967: oe_debug_pub.add( 'Populate_Internal_Fields 6' ) ;

Line 1995: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_RETURN');

1991:
1992: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).order_category_code
1993: <> 'ORDER'
1994: THEN
1995: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_RETURN');
1996: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1997: x_return_status := FND_API.G_RET_STS_ERROR;
1998: ELSE
1999: p_line_rec.line_category_code(p_index) := 'ORDER';

Line 2020: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_TAX_CAL');

2016: AND ((OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event NOT IN ( 'INVOICING' , 'SHIPPING' ))
2017: OR (OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event IS NULL))
2018: AND NVL(p_process_tax,'N') <> 'Y'
2019: THEN
2020: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_TAX_CAL');
2021: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
2022: x_return_status := FND_API.G_RET_STS_ERROR;
2023: END IF;
2024: */

Line 2035: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

2031: x_return_status := FND_API.G_RET_STS_ERROR;
2032:
2033: -- fix bug 5109227
2034: p_line_rec.lock_control(p_index) := -99 ;
2035: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2036: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2037: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2038: OE_BULK_MSG_PUB.Add('Y','ERROR');
2039: -- fix bug 5109227

Line 2036: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2032:
2033: -- fix bug 5109227
2034: p_line_rec.lock_control(p_index) := -99 ;
2035: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2036: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2037: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2038: OE_BULK_MSG_PUB.Add('Y','ERROR');
2039: -- fix bug 5109227
2040:

Line 2159: FND_MESSAGE.SET_NAME('ONT','OE_OI_PRICE_WARNING');

2155: ,l_unit_selling_price)
2156: <> nvl(l_unit_selling_price,FND_API.G_MISS_NUM)
2157: THEN
2158:
2159: FND_MESSAGE.SET_NAME('ONT','OE_OI_PRICE_WARNING');
2160: FND_MESSAGE.SET_TOKEN('CUST_PRICE'
2161: ,p_line_rec.customer_item_net_price(p_line_index));
2162: FND_MESSAGE.SET_TOKEN('SPLR_PRICE',l_unit_selling_price);
2163: OE_BULK_MSG_PUB.Add;

Line 2160: FND_MESSAGE.SET_TOKEN('CUST_PRICE'

2156: <> nvl(l_unit_selling_price,FND_API.G_MISS_NUM)
2157: THEN
2158:
2159: FND_MESSAGE.SET_NAME('ONT','OE_OI_PRICE_WARNING');
2160: FND_MESSAGE.SET_TOKEN('CUST_PRICE'
2161: ,p_line_rec.customer_item_net_price(p_line_index));
2162: FND_MESSAGE.SET_TOKEN('SPLR_PRICE',l_unit_selling_price);
2163: OE_BULK_MSG_PUB.Add;
2164:

Line 2162: FND_MESSAGE.SET_TOKEN('SPLR_PRICE',l_unit_selling_price);

2158:
2159: FND_MESSAGE.SET_NAME('ONT','OE_OI_PRICE_WARNING');
2160: FND_MESSAGE.SET_TOKEN('CUST_PRICE'
2161: ,p_line_rec.customer_item_net_price(p_line_index));
2162: FND_MESSAGE.SET_TOKEN('SPLR_PRICE',l_unit_selling_price);
2163: OE_BULK_MSG_PUB.Add;
2164:
2165: END IF;
2166:

Line 2172: FND_MESSAGE.SET_NAME('ONT','OE_OI_PAYMENT_TERM_WARNING');

2168: ,l_payment_term_id)
2169: <> nvl(l_payment_term_id,FND_API.G_MISS_NUM)
2170: THEN
2171:
2172: FND_MESSAGE.SET_NAME('ONT','OE_OI_PAYMENT_TERM_WARNING');
2173: FND_MESSAGE.SET_TOKEN('CUST_TERM'
2174: ,p_line_rec.customer_payment_term_id(p_line_index));
2175: FND_MESSAGE.SET_TOKEN('SPLR_TERM',l_payment_term_id);
2176: OE_BULK_MSG_PUB.Add;

Line 2173: FND_MESSAGE.SET_TOKEN('CUST_TERM'

2169: <> nvl(l_payment_term_id,FND_API.G_MISS_NUM)
2170: THEN
2171:
2172: FND_MESSAGE.SET_NAME('ONT','OE_OI_PAYMENT_TERM_WARNING');
2173: FND_MESSAGE.SET_TOKEN('CUST_TERM'
2174: ,p_line_rec.customer_payment_term_id(p_line_index));
2175: FND_MESSAGE.SET_TOKEN('SPLR_TERM',l_payment_term_id);
2176: OE_BULK_MSG_PUB.Add;
2177:

Line 2175: FND_MESSAGE.SET_TOKEN('SPLR_TERM',l_payment_term_id);

2171:
2172: FND_MESSAGE.SET_NAME('ONT','OE_OI_PAYMENT_TERM_WARNING');
2173: FND_MESSAGE.SET_TOKEN('CUST_TERM'
2174: ,p_line_rec.customer_payment_term_id(p_line_index));
2175: FND_MESSAGE.SET_TOKEN('SPLR_TERM',l_payment_term_id);
2176: OE_BULK_MSG_PUB.Add;
2177:
2178: END IF;
2179:

Line 2376: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');

2372: IF OE_Bulk_Order_PVT.G_IMPORT_SHIPMENTS = 'NO' THEN
2373: IF (p_line_rec.orig_sys_line_ref(l_last_line_index)
2374: = p_line_rec.orig_sys_line_ref(l_index))
2375: THEN
2376: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
2377: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF'
2378: ,'orig_sys_line_ref');
2379: p_line_rec.lock_control(l_index) := -99;
2380: OE_BULK_MSG_PUB.Add;

Line 2377: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF'

2373: IF (p_line_rec.orig_sys_line_ref(l_last_line_index)
2374: = p_line_rec.orig_sys_line_ref(l_index))
2375: THEN
2376: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
2377: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF'
2378: ,'orig_sys_line_ref');
2379: p_line_rec.lock_control(l_index) := -99;
2380: OE_BULK_MSG_PUB.Add;
2381: END IF;

Line 2388: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');

2384: = p_line_rec.orig_sys_line_ref(l_index))
2385: AND (p_line_rec.orig_sys_shipment_ref(l_last_line_index)
2386: = p_line_rec.orig_sys_shipment_ref(l_index))
2387: THEN
2388: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
2389: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF'
2390: ,'orig_sys_line_ref and orig_sys_shipment_ref');
2391: p_line_rec.lock_control(l_index) := -99;
2392: OE_BULK_MSG_PUB.Add;

Line 2389: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF'

2385: AND (p_line_rec.orig_sys_shipment_ref(l_last_line_index)
2386: = p_line_rec.orig_sys_shipment_ref(l_index))
2387: THEN
2388: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
2389: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF'
2390: ,'orig_sys_line_ref and orig_sys_shipment_ref');
2391: p_line_rec.lock_control(l_index) := -99;
2392: OE_BULK_MSG_PUB.Add;
2393: END IF;

Line 2492: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

2488: -- Validate Required Attributes
2489:
2490: IF (p_line_rec.inventory_item_id(l_index) IS NULL) THEN
2491:
2492: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2493: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2494: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
2495: OE_BULK_MSG_PUB.Add('Y','ERROR');
2496: p_line_rec.lock_control(l_index) := -99;

Line 2493: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2489:
2490: IF (p_line_rec.inventory_item_id(l_index) IS NULL) THEN
2491:
2492: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2493: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2494: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
2495: OE_BULK_MSG_PUB.Add('Y','ERROR');
2496: p_line_rec.lock_control(l_index) := -99;
2497:

Line 2510: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

2506: oe_debug_pub.add('after inventory_item_id');
2507:
2508: IF (p_line_rec.line_type_id(l_index) IS NULL) THEN
2509:
2510: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2511: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2512: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2513: OE_BULK_MSG_PUB.Add('Y','ERROR');
2514: p_line_rec.lock_control(l_index) := -99;

Line 2511: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2507:
2508: IF (p_line_rec.line_type_id(l_index) IS NULL) THEN
2509:
2510: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2511: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2512: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2513: OE_BULK_MSG_PUB.Add('Y','ERROR');
2514: p_line_rec.lock_control(l_index) := -99;
2515: IF l_debug_level > 0 THEN

Line 2536: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

2532: p_header_rec.ordered_date(header_counter))
2533: THEN
2534:
2535: p_line_rec.lock_control(l_index) := -99 ;
2536: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2537: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2538: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2539: OE_BULK_MSG_PUB.Add('Y','ERROR');
2540:

Line 2537: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2533: THEN
2534:
2535: p_line_rec.lock_control(l_index) := -99 ;
2536: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2537: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2538: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2539: OE_BULK_MSG_PUB.Add('Y','ERROR');
2540:
2541: ELSE

Line 2560: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

2556: IF l_debug_level > 0 THEN
2557: oe_debug_pub.add( 'FAILURE IN OE_BULK_WF_UTIL.Validate_LT_WF_Assignment ' ) ;
2558: END IF;
2559: p_line_rec.lock_control(l_index) := -99 ;
2560: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2561: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2562: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2563: OE_BULK_MSG_PUB.Add('Y','ERROR');
2564: ELSE

Line 2561: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2557: oe_debug_pub.add( 'FAILURE IN OE_BULK_WF_UTIL.Validate_LT_WF_Assignment ' ) ;
2558: END IF;
2559: p_line_rec.lock_control(l_index) := -99 ;
2560: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2561: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2562: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2563: OE_BULK_MSG_PUB.Add('Y','ERROR');
2564: ELSE
2565: p_line_rec.wf_process_name(l_index) := l_process_name;

Line 2582: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

2578:
2579: -- Tax exempt reason code is required
2580: IF (p_line_rec.tax_exempt_reason_code(l_index) IS NULL) THEN
2581: p_line_rec.lock_control(l_index) := -99;
2582: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2583: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Tax Exempt Reason');
2584: OE_BULK_MSG_PUB.Add('Y','ERROR');
2585:
2586: ELSIF NOT OE_BULK_PROCESS_HEADER.Valid_Tax_Exempt_Reason

Line 2583: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Tax Exempt Reason');

2579: -- Tax exempt reason code is required
2580: IF (p_line_rec.tax_exempt_reason_code(l_index) IS NULL) THEN
2581: p_line_rec.lock_control(l_index) := -99;
2582: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2583: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Tax Exempt Reason');
2584: OE_BULK_MSG_PUB.Add('Y','ERROR');
2585:
2586: ELSIF NOT OE_BULK_PROCESS_HEADER.Valid_Tax_Exempt_Reason
2587: (p_line_rec.tax_exempt_reason_code(l_index)) THEN

Line 2590: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2586: ELSIF NOT OE_BULK_PROCESS_HEADER.Valid_Tax_Exempt_Reason
2587: (p_line_rec.tax_exempt_reason_code(l_index)) THEN
2588:
2589: p_line_rec.lock_control(l_index) := -99;
2590: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2591: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2592: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
2593: OE_BULK_MSG_PUB.Add('Y','ERROR');
2594:

Line 2591: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2587: (p_line_rec.tax_exempt_reason_code(l_index)) THEN
2588:
2589: p_line_rec.lock_control(l_index) := -99;
2590: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2591: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2592: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
2593: OE_BULK_MSG_PUB.Add('Y','ERROR');
2594:
2595: END IF;

Line 2608: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');

2604: p_line_rec.lock_control(l_index) := -99;
2605: IF l_debug_level > 0 THEN
2606: oe_debug_pub.add( 'IN ERROR 6 ' ) ;
2607: END IF;
2608: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');
2609: OE_BULK_MSG_PUB.Add('Y','ERROR');
2610: END IF;
2611:
2612: END IF;

Line 2659: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');

2655: p_line_rec.lock_control(l_index) := -99;
2656: IF l_debug_level > 0 THEN
2657: oe_debug_pub.add( 'IN ERROR 7 ' ) ;
2658: END IF;
2659: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
2660: OE_BULK_MSG_PUB.add('Y','ERROR');
2661: END IF;
2662:
2663: END IF;

Line 2693: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

2689: IF l_count = 0 THEN
2690: p_line_rec.shipping_method_code(l_index) := NULL;
2691:
2692: OE_BULK_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
2693: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2694: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2695: OE_Order_UTIL.Get_Attribute_Name('SHIPPING_METHOD_CODE'));
2696: OE_BULK_MSG_PUB.Add;
2697: OE_BULK_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

Line 2694: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2690: p_line_rec.shipping_method_code(l_index) := NULL;
2691:
2692: OE_BULK_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
2693: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2694: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2695: OE_Order_UTIL.Get_Attribute_Name('SHIPPING_METHOD_CODE'));
2696: OE_BULK_MSG_PUB.Add;
2697: OE_BULK_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2698: END IF;

Line 2722: fnd_message.set_name('ONT','OE_BULK_OPM_NOT_PROCESS');

2718: p_line_rec.lock_control(l_index) := -99;
2719: IF l_debug_level > 0 THEN
2720: oe_debug_pub.add( 'error 1 ' ) ;
2721: END IF;
2722: fnd_message.set_name('ONT','OE_BULK_OPM_NOT_PROCESS');
2723: OE_BULK_MSG_PUB.Add('Y','ERROR');
2724: END IF;
2725:
2726: END IF; */

Line 2751: fnd_message.set_name('ONT','OE_BULK_OPM_NOT_PROCESS');

2747: p_line_rec.lock_control(l_index) := -99;
2748: IF l_debug_level > 0 THEN
2749: oe_debug_pub.add( 'error 2 ' ) ;
2750: END IF;
2751: fnd_message.set_name('ONT','OE_BULK_OPM_NOT_PROCESS');
2752: OE_BULK_MSG_PUB.Add('Y','ERROR');
2753: END IF;
2754: END IF; -- OE_BULK_CACHE.G_ITEM_TBL(l_c_index).opm_item_id IS NULL THEN
2755:

Line 2803: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');

2799: IF l_debug_level > 0 THEN
2800: oe_debug_pub.add( 'UOM OTHER THAN PRIMARY UOM IS ENTERED' , 1 ) ;
2801: END IF;
2802:
2803: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2804: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );
2805: fnd_message.set_token('UOM', l_uom);
2806: OE_BULK_MSG_PUB.Add('Y','ERROR');
2807: --RAISE FND_API.G_EXC_ERROR;

Line 2804: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );

2800: oe_debug_pub.add( 'UOM OTHER THAN PRIMARY UOM IS ENTERED' , 1 ) ;
2801: END IF;
2802:
2803: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2804: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );
2805: fnd_message.set_token('UOM', l_uom);
2806: OE_BULK_MSG_PUB.Add('Y','ERROR');
2807: --RAISE FND_API.G_EXC_ERROR;
2808: END IF;

Line 2805: fnd_message.set_token('UOM', l_uom);

2801: END IF;
2802:
2803: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2804: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );
2805: fnd_message.set_token('UOM', l_uom);
2806: OE_BULK_MSG_PUB.Add('Y','ERROR');
2807: --RAISE FND_API.G_EXC_ERROR;
2808: END IF;
2809: EXCEPTION

Line 2815: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');

2811: IF l_debug_level > 0 THEN
2812: oe_debug_pub.add( 'OEXLLINB , NO_DATA_FOUND IN UOM VALIDATION' , 1 ) ;
2813: END IF;
2814: p_line_rec.lock_control(l_index) := -99;
2815: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2816: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );
2817: fnd_message.set_token('UOM', l_uom);
2818: OE_BULK_MSG_PUB.Add('Y','ERROR');
2819: END;

Line 2816: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );

2812: oe_debug_pub.add( 'OEXLLINB , NO_DATA_FOUND IN UOM VALIDATION' , 1 ) ;
2813: END IF;
2814: p_line_rec.lock_control(l_index) := -99;
2815: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2816: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );
2817: fnd_message.set_token('UOM', l_uom);
2818: OE_BULK_MSG_PUB.Add('Y','ERROR');
2819: END;
2820:

Line 2817: fnd_message.set_token('UOM', l_uom);

2813: END IF;
2814: p_line_rec.lock_control(l_index) := -99;
2815: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2816: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );
2817: fnd_message.set_token('UOM', l_uom);
2818: OE_BULK_MSG_PUB.Add('Y','ERROR');
2819: END;
2820:
2821: ELSE

Line 2838: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');

2834: oe_debug_pub.add( 'UOM :'||P_LINE_REC.ORDER_QUANTITY_UOM ( L_INDEX ) ) ;
2835: oe_debug_pub.add( 'ITEM ID :'||P_LINE_REC.INVENTORY_ITEM_ID ( L_INDEX ) ) ;
2836: END IF;
2837: p_line_rec.lock_control(l_index) := -99;
2838: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
2839: OE_BULK_MSG_PUB.Add('Y','ERROR');
2840: END IF;
2841:
2842: END IF; -- uom validation based on item type

Line 2862: FND_MESSAGE.SET_NAME('ONT', 'OE_SHIP_FROM_REQD');

2858:
2859: IF (p_line_rec.project_id(l_index) IS NOT NULL AND
2860: p_line_rec.ship_from_org_id(l_index) IS NULL)
2861: THEN
2862: FND_MESSAGE.SET_NAME('ONT', 'OE_SHIP_FROM_REQD');
2863: OE_BULK_MSG_PUB.Add('Y','ERROR');
2864: p_line_rec.lock_control(l_index) := -99;
2865: IF l_debug_level > 0 THEN
2866: oe_debug_pub.add( 'IN ERROR 11 ' ) ;

Line 2877: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SHIP_FROM_PROJ');

2873: -- Validate project/warehouse combination.
2874: IF pjm_project.val_proj_idtonum(p_line_rec.project_id(l_index),
2875: p_line_rec.ship_from_org_id(l_index)) IS NULL
2876: THEN
2877: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SHIP_FROM_PROJ');
2878: OE_BULK_MSG_PUB.Add('Y','ERROR');
2879: p_line_rec.lock_control(l_index) := -99;
2880: IF l_debug_level > 0 THEN
2881: oe_debug_pub.add( 'IN ERROR 12 ' ) ;

Line 2888: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');

2884: END IF;
2885:
2886: IF (p_line_rec.task_id(l_index) IS NOT NULL
2887: AND p_line_rec.project_id(l_index) IS NULL) THEN
2888: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');
2889: OE_BULK_MSG_PUB.Add('Y','ERROR');
2890: p_line_rec.lock_control(l_index) := -99;
2891: IF l_debug_level > 0 THEN
2892: oe_debug_pub.add( 'IN ERROR 13 ' ) ;

Line 2900: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

2896: AND p_line_rec.project_id(l_index) IS NOT NULL) THEN
2897:
2898: IF NOT Validate_task(p_line_rec.project_id(l_index),
2899: p_line_rec.task_id(l_index)) THEN
2900: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2902: OE_Order_Util.Get_Attribute_Name('task_id'));
2903: OE_BULK_MSG_PUB.Add('Y','ERROR');
2904: p_line_rec.lock_control(l_index) := -99;

Line 2901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2897:
2898: IF NOT Validate_task(p_line_rec.project_id(l_index),
2899: p_line_rec.task_id(l_index)) THEN
2900: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2901: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2902: OE_Order_Util.Get_Attribute_Name('task_id'));
2903: OE_BULK_MSG_PUB.Add('Y','ERROR');
2904: p_line_rec.lock_control(l_index) := -99;
2905: IF l_debug_level > 0 THEN

Line 2916: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_TASK_REQD');

2912: AND p_line_rec.project_id(l_index) IS NOT NULL) THEN
2913:
2914: IF Validate_task_reqd(p_line_rec.project_id(l_index),
2915: p_line_rec.ship_from_org_id(l_index)) THEN
2916: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_TASK_REQD');
2917: OE_BULK_MSG_PUB.Add('Y','ERROR');
2918: p_line_rec.lock_control(l_index) := -99;
2919: IF l_debug_level > 0 THEN
2920: oe_debug_pub.add( 'IN ERROR 15 ' ) ;

Line 2933: fnd_message.set_name('ONT', 'OE_UEFF_NUMBER_REQD');

2929: IF PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM
2930: (p_line_rec.inventory_item_id(l_index),
2931: p_line_rec.ship_from_org_id(l_index)) = 'Y'
2932: THEN
2933: fnd_message.set_name('ONT', 'OE_UEFF_NUMBER_REQD');
2934: OE_BULK_MSG_PUB.Add('Y','ERROR');
2935: p_line_rec.lock_control(l_index) := -99;
2936: IF l_debug_level > 0 THEN
2937: oe_debug_pub.add( 'IN ERROR 16 ' ) ;

Line 2947: fnd_message.set_name('ONT', 'OE_PJM_NOT_INSTALLED');

2943: IF (p_line_rec.project_id(l_index) IS NOT NULL OR
2944: p_line_rec.task_id(l_index) IS NOT NULL OR
2945: p_line_rec.end_item_unit_number(l_index) IS NOT NULL)
2946: THEN
2947: fnd_message.set_name('ONT', 'OE_PJM_NOT_INSTALLED');
2948: OE_BULK_MSG_PUB.Add('Y','ERROR');
2949: p_line_rec.lock_control(l_index) := -99;
2950: IF l_debug_level > 0 THEN
2951: oe_debug_pub.add( 'IN ERROR 17 ' ) ;

Line 2977: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');

2973: , NULL --p_line_rec.source_document_type_id(l_index)
2974: )
2975: THEN
2976: p_line_rec.lock_control(l_index) := -99;
2977: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');
2978: OE_BULK_MSG_PUB.Add('Y','ERROR');
2979: IF l_debug_level > 0 THEN
2980: oe_debug_pub.add( 'IN ERROR 18 ' ) ;
2981: END IF;

Line 3009: fnd_message.set_name('ONT', 'OE_ITORD_VALIDATION_FAILED');

3005: , p_line_rec.deliver_to_org_id(l_index)
3006: )
3007: THEN
3008: p_line_rec.lock_control(l_index) := -99;
3009: fnd_message.set_name('ONT', 'OE_ITORD_VALIDATION_FAILED');
3010: fnd_message.set_token('ITEM',OE_ITORD_UTIL.get_item_name(p_line_rec.inventory_item_id(l_index)));
3011: fnd_message.set_token('CATEGORY',OE_ITORD_UTIL.get_item_category_name(p_line_rec.inventory_item_id(l_index)));
3012: OE_BULK_MSG_PUB.Add('Y','ERROR');
3013: IF l_debug_level > 0 THEN

Line 3010: fnd_message.set_token('ITEM',OE_ITORD_UTIL.get_item_name(p_line_rec.inventory_item_id(l_index)));

3006: )
3007: THEN
3008: p_line_rec.lock_control(l_index) := -99;
3009: fnd_message.set_name('ONT', 'OE_ITORD_VALIDATION_FAILED');
3010: fnd_message.set_token('ITEM',OE_ITORD_UTIL.get_item_name(p_line_rec.inventory_item_id(l_index)));
3011: fnd_message.set_token('CATEGORY',OE_ITORD_UTIL.get_item_category_name(p_line_rec.inventory_item_id(l_index)));
3012: OE_BULK_MSG_PUB.Add('Y','ERROR');
3013: IF l_debug_level > 0 THEN
3014: oe_debug_pub.add( 'IN ERROR 19 ' ) ;

Line 3011: fnd_message.set_token('CATEGORY',OE_ITORD_UTIL.get_item_category_name(p_line_rec.inventory_item_id(l_index)));

3007: THEN
3008: p_line_rec.lock_control(l_index) := -99;
3009: fnd_message.set_name('ONT', 'OE_ITORD_VALIDATION_FAILED');
3010: fnd_message.set_token('ITEM',OE_ITORD_UTIL.get_item_name(p_line_rec.inventory_item_id(l_index)));
3011: fnd_message.set_token('CATEGORY',OE_ITORD_UTIL.get_item_category_name(p_line_rec.inventory_item_id(l_index)));
3012: OE_BULK_MSG_PUB.Add('Y','ERROR');
3013: IF l_debug_level > 0 THEN
3014: oe_debug_pub.add( 'IN ERROR 19 ' ) ;
3015: END IF;

Line 3032: fnd_message.set_name('ONT', 'ONT_USER_ITEM_DESC_TOO_LONG');

3028: IF NOT Validate_User_Item_Description
3029: ( p_line_rec.user_item_description(l_index))
3030: THEN
3031: p_line_rec.lock_control(l_index) := -99;
3032: fnd_message.set_name('ONT', 'ONT_USER_ITEM_DESC_TOO_LONG');
3033: OE_BULK_MSG_PUB.Add('Y','ERROR');
3034: IF l_debug_level > 0 THEN
3035: oe_debug_pub.add( 'LENGTH OF USER ITEM DESC EXCEEDS LIMIT FOR EXTERNAL ORDERS. ' ) ;
3036: END IF;

Line 3108: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3104: p_line_rec.lock_control(l_index) := -99;
3105: IF l_debug_level > 0 THEN
3106: oe_debug_pub.add( 'IN ERROR 22 ' ) ;
3107: END IF;
3108: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3109: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3110: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
3111: OE_BULK_MSG_PUB.Add('Y','ERROR');
3112: END IF;

Line 3109: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3105: IF l_debug_level > 0 THEN
3106: oe_debug_pub.add( 'IN ERROR 22 ' ) ;
3107: END IF;
3108: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3109: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3110: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
3111: OE_BULK_MSG_PUB.Add('Y','ERROR');
3112: END IF;
3113:

Line 3131: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3127: p_line_rec.lock_control(l_index) := -99;
3128: IF l_debug_level > 0 THEN
3129: oe_debug_pub.add( 'IN ERROR 22 ' ) ;
3130: END IF;
3131: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3132: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3133: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
3134: OE_BULK_MSG_PUB.Add('Y','ERROR');
3135: END IF;

Line 3132: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3128: IF l_debug_level > 0 THEN
3129: oe_debug_pub.add( 'IN ERROR 22 ' ) ;
3130: END IF;
3131: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3132: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3133: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
3134: OE_BULK_MSG_PUB.Add('Y','ERROR');
3135: END IF;
3136:

Line 3153: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3149: p_line_rec.lock_control(l_index) := -99;
3150: IF l_debug_level > 0 THEN
3151: oe_debug_pub.add( 'IN ERROR 22 ' ) ;
3152: END IF;
3153: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3155: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_ORG_ID'));
3156: OE_BULK_MSG_PUB.Add('Y','ERROR');
3157: END IF;

Line 3154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3150: IF l_debug_level > 0 THEN
3151: oe_debug_pub.add( 'IN ERROR 22 ' ) ;
3152: END IF;
3153: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3155: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_ORG_ID'));
3156: OE_BULK_MSG_PUB.Add('Y','ERROR');
3157: END IF;
3158:

Line 3185: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3181: p_line_rec.invoice_to_contact_id(l_index)
3182: )
3183: THEN
3184: p_line_rec.lock_control(l_index) := -99;
3185: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: Bill To Contact ');
3187: OE_BULK_MSG_PUB.Add('Y','ERROR');
3188: END IF;
3189:

Line 3186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: Bill To Contact ');

3182: )
3183: THEN
3184: p_line_rec.lock_control(l_index) := -99;
3185: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3186: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: Bill To Contact ');
3187: OE_BULK_MSG_PUB.Add('Y','ERROR');
3188: END IF;
3189:
3190: END IF;

Line 3212: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3208: p_line_rec.Ship_to_contact_id(l_index)
3209: )
3210: THEN
3211: p_line_rec.lock_control(l_index) := -99;
3212: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: SHIP To Contact ');
3214: OE_BULK_MSG_PUB.Add('Y','ERROR');
3215: END IF;
3216:

Line 3213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: SHIP To Contact ');

3209: )
3210: THEN
3211: p_line_rec.lock_control(l_index) := -99;
3212: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: SHIP To Contact ');
3214: OE_BULK_MSG_PUB.Add('Y','ERROR');
3215: END IF;
3216:
3217: END IF;

Line 3239: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3235: p_line_rec.Deliver_to_contact_id(l_index)
3236: )
3237: THEN
3238: p_line_rec.lock_control(l_index) := -99;
3239: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: DeliverToContact');
3241: OE_BULK_MSG_PUB.Add('Y','ERROR');
3242: END IF;
3243:

Line 3240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: DeliverToContact');

3236: )
3237: THEN
3238: p_line_rec.lock_control(l_index) := -99;
3239: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: DeliverToContact');
3241: OE_BULK_MSG_PUB.Add('Y','ERROR');
3242: END IF;
3243:
3244: END IF;

Line 3254: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3250: IF p_line_rec.end_Customer_id(l_index) IS NOT NULL
3251: AND NOT OE_GLOBALS.Equal(p_line_rec.end_Customer_id(l_index),p_header_rec.end_customer_id(header_counter))THEN
3252: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer(p_line_rec.end_customer_id(l_index)) THEN
3253: p_line_rec.lock_control(l_index) := -99;
3254: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3255: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_id'));
3256: OE_BULK_MSG_PUB.Add('Y','ERROR');
3257: END IF;
3258: END IF;

Line 3255: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_id'));

3251: AND NOT OE_GLOBALS.Equal(p_line_rec.end_Customer_id(l_index),p_header_rec.end_customer_id(header_counter))THEN
3252: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer(p_line_rec.end_customer_id(l_index)) THEN
3253: p_line_rec.lock_control(l_index) := -99;
3254: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3255: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_id'));
3256: OE_BULK_MSG_PUB.Add('Y','ERROR');
3257: END IF;
3258: END IF;
3259:

Line 3264: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3260: IF p_line_rec.end_Customer_Contact_id(l_index) IS NOT NULL AND
3261: NOT OE_GLOBALS.Equal(p_line_rec.end_Customer_Contact_id(l_index),p_header_rec.end_customer_Contact_id(header_counter)) THEN
3262: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer_Contact(p_line_rec.end_customer_contact_id(l_index)) THEN
3263: p_line_rec.lock_control(l_index) := -99;
3264: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3265: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));
3266: OE_BULK_MSG_PUB.Add('Y','ERROR');
3267: END IF;
3268: END IF;

Line 3265: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));

3261: NOT OE_GLOBALS.Equal(p_line_rec.end_Customer_Contact_id(l_index),p_header_rec.end_customer_Contact_id(header_counter)) THEN
3262: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer_Contact(p_line_rec.end_customer_contact_id(l_index)) THEN
3263: p_line_rec.lock_control(l_index) := -99;
3264: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3265: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));
3266: OE_BULK_MSG_PUB.Add('Y','ERROR');
3267: END IF;
3268: END IF;
3269:

Line 3276: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3272: OE_GLOBALS.Equal(p_line_rec.end_Customer_site_use_id(l_index),p_header_rec.end_customer_site_use_id(header_counter)) THEN
3273: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer_site_use(p_line_rec.end_customer_site_use_id(l_index),
3274: p_line_rec.end_customer_id(l_index)) THEN
3275: p_line_rec.lock_control(l_index) := -99;
3276: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
3278: OE_BULK_MSG_PUB.Add('Y','ERROR');
3279: END IF;
3280: END IF;

Line 3277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));

3273: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer_site_use(p_line_rec.end_customer_site_use_id(l_index),
3274: p_line_rec.end_customer_id(l_index)) THEN
3275: p_line_rec.lock_control(l_index) := -99;
3276: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
3278: OE_BULK_MSG_PUB.Add('Y','ERROR');
3279: END IF;
3280: END IF;
3281:

Line 3286: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3282: IF p_line_rec.IB_owner(l_index) IS NOT NULL AND NOT
3283: OE_GLOBALS.Equal(p_line_rec.IB_owner(l_index),p_header_rec.IB_owner(header_counter))THEN
3284: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_Owner(p_line_rec.IB_owner(l_index)) THEN
3285: p_line_rec.lock_control(l_index) := -99;
3286: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3287: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_owner'));
3288: OE_BULK_MSG_PUB.Add('Y','ERROR');
3289: END IF;
3290: END IF;

Line 3287: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_owner'));

3283: OE_GLOBALS.Equal(p_line_rec.IB_owner(l_index),p_header_rec.IB_owner(header_counter))THEN
3284: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_Owner(p_line_rec.IB_owner(l_index)) THEN
3285: p_line_rec.lock_control(l_index) := -99;
3286: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3287: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_owner'));
3288: OE_BULK_MSG_PUB.Add('Y','ERROR');
3289: END IF;
3290: END IF;
3291:

Line 3296: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3292: IF p_line_rec.IB_current_location(l_index) IS NOT NULL AND NOT
3293: OE_GLOBALS.Equal(p_line_rec.IB_current_location(l_index),p_header_rec.IB_current_location(header_counter)) THEN
3294: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_current_Location (p_line_rec.IB_current_location(l_index)) THEN
3295: p_line_rec.lock_control(l_index) := -99;
3296: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3297: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_location'));
3298: OE_BULK_MSG_PUB.Add('Y','ERROR');
3299: END IF;
3300: END IF;

Line 3297: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_location'));

3293: OE_GLOBALS.Equal(p_line_rec.IB_current_location(l_index),p_header_rec.IB_current_location(header_counter)) THEN
3294: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_current_Location (p_line_rec.IB_current_location(l_index)) THEN
3295: p_line_rec.lock_control(l_index) := -99;
3296: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3297: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_location'));
3298: OE_BULK_MSG_PUB.Add('Y','ERROR');
3299: END IF;
3300: END IF;
3301:

Line 3306: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3302: IF p_line_rec.IB_Installed_at_location(l_index) IS NOT NULL AND NOT
3303: OE_GLOBALS.Equal(p_line_rec.IB_Installed_at_location(l_index),p_header_rec.IB_Installed_at_location(header_counter)) THEN
3304: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_Inst_loc(p_line_rec.IB_Installed_at_location(l_index)) THEN
3305: p_line_rec.lock_control(l_index) := -99;
3306: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('Installed_at_location'));
3308: OE_BULK_MSG_PUB.Add('Y','ERROR');
3309: END IF;
3310: END IF;

Line 3307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('Installed_at_location'));

3303: OE_GLOBALS.Equal(p_line_rec.IB_Installed_at_location(l_index),p_header_rec.IB_Installed_at_location(header_counter)) THEN
3304: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_Inst_loc(p_line_rec.IB_Installed_at_location(l_index)) THEN
3305: p_line_rec.lock_control(l_index) := -99;
3306: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('Installed_at_location'));
3308: OE_BULK_MSG_PUB.Add('Y','ERROR');
3309: END IF;
3310: END IF;
3311: --Bug 5054618}

Line 3333: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3329: oe_debug_pub.add( 'RULE_TYPE IS :'||L_RULE_TYPE) ;
3330: END IF;
3331: IF l_rule_type = 'PP_DR_ALL' OR l_rule_type = 'PP_DR_PP' THEN
3332: p_line_rec.lock_control(l_index) := -99 ;
3333: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3334: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_ID'));
3335: OE_BULK_MSG_PUB.Add('Y','ERROR');
3336: END IF; -- end of accounting rule type
3337: END IF; -- end of accounting_rule_id not null

Line 3334: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_ID'));

3330: END IF;
3331: IF l_rule_type = 'PP_DR_ALL' OR l_rule_type = 'PP_DR_PP' THEN
3332: p_line_rec.lock_control(l_index) := -99 ;
3333: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3334: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_ID'));
3335: OE_BULK_MSG_PUB.Add('Y','ERROR');
3336: END IF; -- end of accounting rule type
3337: END IF; -- end of accounting_rule_id not null
3338: END IF; -- end of non-service line

Line 3425: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3421: EXCEPTION
3422:
3423: WHEN NO_DATA_FOUND THEN
3424: p_line_rec.lock_control(l_index) := -99;
3425: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: Tax Exemptions');
3427: OE_BULK_MSG_PUB.Add('Y','ERROR');
3428:
3429:

Line 3426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: Tax Exemptions');

3422:
3423: WHEN NO_DATA_FOUND THEN
3424: p_line_rec.lock_control(l_index) := -99;
3425: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: Tax Exemptions');
3427: OE_BULK_MSG_PUB.Add('Y','ERROR');
3428:
3429:
3430: END;

Line 3496: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3492: p_line_rec.lock_control(l_index) := -99;
3493: IF l_debug_level > 0 THEN
3494: oe_debug_pub.add( 'IN ERROR 29 ' ) ;
3495: END IF;
3496: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3497: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: Tax Code');
3498: OE_BULK_MSG_PUB.Add('Y','ERROR');
3499: END; -- BEGIN
3500: END IF;

Line 3497: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: Tax Code');

3493: IF l_debug_level > 0 THEN
3494: oe_debug_pub.add( 'IN ERROR 29 ' ) ;
3495: END IF;
3496: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3497: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: Tax Code');
3498: OE_BULK_MSG_PUB.Add('Y','ERROR');
3499: END; -- BEGIN
3500: END IF;
3501:

Line 3514: FND_Message.Set_Name('ONT', 'OE_OTA_INVALID_QTY');

3510: IF (l_is_ota_line)
3511: AND p_line_rec.ordered_quantity(l_index) > 1 THEN
3512:
3513: p_line_rec.lock_control(l_index) := -99;
3514: FND_Message.Set_Name('ONT', 'OE_OTA_INVALID_QTY');
3515: OE_BULK_MSG_PUB.Add('Y','ERROR');
3516:
3517: END IF;
3518:

Line 3530: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_PO_NUMBER');

3526: (p_line_rec.cust_po_number(l_index)
3527: ,p_line_rec.sold_to_org_id(l_index)
3528: ,p_line_rec.header_id(l_index) )
3529: THEN
3530: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_PO_NUMBER');
3531: OE_BULK_MSG_PUB.Add('Y','ERROR');
3532: END IF;
3533: END IF;
3534: IF p_line_rec.service_end_date(l_index) IS NOT NULL

Line 3540: fnd_message.set_name('ONT','OE_SERV_END_DATE');

3536: THEN
3537: IF p_line_rec.service_start_date(l_index) >=
3538: p_line_rec.service_end_date(l_index)
3539: THEN
3540: fnd_message.set_name('ONT','OE_SERV_END_DATE');
3541: OE_BULK_MSG_PUB.Add('Y','ERROR');
3542: p_line_rec.lock_control(l_index) := -99;
3543: END IF;
3544: END IF;

Line 3575: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

3571: ,p_attribute19 => p_line_rec.attribute19(l_index)
3572: ,p_attribute20 => p_line_rec.attribute20(l_index))
3573: THEN
3574: p_line_rec.lock_control(l_index) := -99;
3575: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
3576: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3577: 'Entity:Flexfield:Line_Desc_Flex');
3578: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
3579:

Line 3576: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3572: ,p_attribute20 => p_line_rec.attribute20(l_index))
3573: THEN
3574: p_line_rec.lock_control(l_index) := -99;
3575: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
3576: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3577: 'Entity:Flexfield:Line_Desc_Flex');
3578: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
3579:
3580: ELSE -- if the flex validation is successfull

Line 3726: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

3722: ,p_attribute29 => p_line_rec.Industry_attribute29(l_index)
3723: ,p_attribute30 => p_line_rec.Industry_attribute30(l_index))
3724: THEN
3725: p_line_rec.lock_control(l_index) := -99;
3726: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
3727: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3728: 'Entity:Flexfield:Industry Line_Desc_Flex');
3729: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
3730:

Line 3727: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3723: ,p_attribute30 => p_line_rec.Industry_attribute30(l_index))
3724: THEN
3725: p_line_rec.lock_control(l_index) := -99;
3726: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
3727: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3728: 'Entity:Flexfield:Industry Line_Desc_Flex');
3729: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
3730:
3731: ELSE -- for bug 2511313

Line 3913: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

3909: ,p_attribute14 => p_line_rec.tp_attribute14(l_index)
3910: ,p_attribute15 => p_line_rec.tp_attribute15(l_index))
3911: THEN
3912: p_line_rec.lock_control(l_index) := -99;
3913: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
3914: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3915: 'Entity:Flexfield:TP Line_Desc_Flex');
3916: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
3917:

Line 3914: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3910: ,p_attribute15 => p_line_rec.tp_attribute15(l_index))
3911: THEN
3912: p_line_rec.lock_control(l_index) := -99;
3913: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
3914: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3915: 'Entity:Flexfield:TP Line_Desc_Flex');
3916: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
3917:
3918: ELSE -- if the flex validation is successfull

Line 4021: FND_MESSAGE.SET_NAME('ONT','OE_OI_PRICE');

4017: IF l_debug_level > 0 THEN
4018: oe_debug_pub.add( 'LIST PRICE OR SELLING PRICE IS NULL... ' ) ;
4019: END IF;
4020: p_line_rec.lock_control(l_index) := -99;
4021: FND_MESSAGE.SET_NAME('ONT','OE_OI_PRICE');
4022: OE_BULK_MSG_PUB.Add;
4023: ELSIF p_line_rec.pricing_quantity(l_index) IS NULL
4024: THEN
4025: IF l_debug_level > 0 THEN

Line 4193: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');

4189: IF ( OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'
4190: AND l_on_generic_hold )
4191: THEN
4192: -- Add scheduling on hold message
4193: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
4194: OE_BULK_MSG_PUB.Add;
4195: ELSE
4196: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'ONE'
4197: OR (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code IS NULL

Line 4201: FND_MESSAGE.SET_NAME('ONT','OE_ATP_ONLY');

4197: OR (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code IS NULL
4198: AND OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).scheduling_level_code = 'ONE')
4199: THEN
4200: -- Add ATP Only message
4201: FND_MESSAGE.SET_NAME('ONT','OE_ATP_ONLY');
4202: OE_BULK_MSG_PUB.Add;
4203: ELSE
4204: Check_Scheduling_Attributes(p_line_rec => p_line_rec
4205: ,p_index =>l_index

Line 4231: FND_MESSAGE.SET_NAME('ONT','OE_INV_NO_WAREHOUSE');

4227: END IF;
4228: p_line_rec.schedule_status_code(l_index) := 'SCHEDULED';
4229: p_line_rec.visible_demand_flag(l_index) := 'N';
4230: ELSE
4231: FND_MESSAGE.SET_NAME('ONT','OE_INV_NO_WAREHOUSE');
4232: OE_BULK_MSG_PUB.Add;
4233: IF p_line_rec.schedule_ship_date(l_index) IS NOT NULL
4234: OR p_line_rec.schedule_arrival_date(l_index) IS NOT NULL THEN
4235: p_line_rec.lock_control(l_index) := -99;

Line 4263: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_REQUEST_EXCEED_LAD');

4259: < trunc(p_line_rec.request_date(l_index)) THEN -- LAD less than request date
4260: IF l_debug_level > 0 THEN
4261: oe_debug_pub.add( 'Request date exceeds Latest Acceptable Date ',1 ) ;
4262: END IF;
4263: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_REQUEST_EXCEED_LAD');
4264: OE_BULK_MSG_PUB.Add;
4265: ELSIF ((l_order_date_type_code = 'SHIP'
4266: AND trunc(NVL(p_line_rec.schedule_ship_date(l_index),p_line_rec.request_date(l_index)))
4267: > trunc(NVL(p_line_rec.latest_acceptable_date(l_index),p_line_rec.request_date(l_index))))

Line 4271: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_LAD_SCH_FAILED');

4267: > trunc(NVL(p_line_rec.latest_acceptable_date(l_index),p_line_rec.request_date(l_index))))
4268: OR (l_order_date_type_code = 'ARRIVAL'
4269: AND trunc(NVL(p_line_rec.schedule_arrival_date(l_index),p_line_rec.request_date(l_index)))
4270: > trunc(NVL(p_line_rec.latest_acceptable_date(l_index),p_line_rec.request_date(l_index))))) THEN
4271: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_LAD_SCH_FAILED');
4272: OE_BULK_MSG_PUB.Add;
4273: IF l_debug_level > 0 THEN
4274: oe_debug_pub.add( 'SCHEDULE DATE EXCEEDS LAD ',1 ) ;
4275: END IF;

Line 4487: FND_MESSAGE.SET_NAME('ONT','SO_PR_NEGATIVE_AMOUNT'); -- HVOP define better OM or GMI error code

4483: /* If quantity2 is present and negative, then error */
4484:
4485: IF nvl(p_line_rec.ordered_quantity2(p_index), 0) < 0
4486: THEN
4487: FND_MESSAGE.SET_NAME('ONT','SO_PR_NEGATIVE_AMOUNT'); -- HVOP define better OM or GMI error code
4488: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4489: p_x_return_status := -1;
4490: IF l_debug_level > 0 THEN
4491: oe_debug_pub.add ('calculate_dual_qty- quantity2 negative so error ', 3);

Line 4513: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');

4509: IF l_debug_level > 0 THEN
4510: oe_debug_pub.add( 'calculate_dual_qty - invalid warehouse/item combo' ) ;
4511: END IF;
4512: p_x_return_status := -1;
4513: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
4514: OE_BULK_MSG_PUB.add('Y','ERROR');
4515: RETURN;
4516: END IF;
4517:

Line 4634: --fnd_message.set_name('ONT',l_buffer); -- PAL

4630: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
4631: p_encoded => 'F');
4632: p_x_return_status := -1;
4633: oe_msg_pub.add_text(p_message_text => l_buffer);
4634: --fnd_message.set_name('ONT',l_buffer); -- PAL
4635: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4636: /*IF l_debug_level > 0 THEN
4637: oe_debug_pub.add(l_buffer,1);
4638: END IF; */

Line 4656: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');

4652: ,p_opm_item_um2
4653: ,0);
4654: IF (l_return = -68 ) THEN
4655: p_x_return_status := -1;
4656: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
4657: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4658: ELSIF(l_return = -69 ) THEN
4659: p_x_return_status := -1;
4660: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');

Line 4660: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');

4656: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
4657: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4658: ELSIF(l_return = -69 ) THEN
4659: p_x_return_status := -1;
4660: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
4661: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4662: END IF; */
4663:
4664: END IF; -- (NVL(p_line_rec.ordered_quantity2(p_index),0) <> 0 )

Line 4761: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');

4757: ,p_opm_item_um2
4758: ,0);
4759: IF (l_return = -68 ) THEN
4760: p_x_return_status := -1;
4761: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
4762: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4763: ELSIF(l_return = -69 ) THEN
4764: p_x_return_status := -1;
4765: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');

Line 4765: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');

4761: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
4762: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4763: ELSIF(l_return = -69 ) THEN
4764: p_x_return_status := -1;
4765: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
4766: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4767: END IF; */
4768:
4769: IF l_debug_level > 0 THEN

Line 4795: --fnd_message.set_name('ONT',l_buffer);

4791: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
4792: p_encoded => 'F');
4793: p_x_return_status := -1;
4794: oe_msg_pub.add_text(p_message_text => l_buffer);
4795: --fnd_message.set_name('ONT',l_buffer);
4796: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4797:
4798: IF l_debug_level > 0 THEN
4799: oe_debug_pub.add(l_buffer,1);

Line 4814: FND_MESSAGE.set_name('ONT','OE_BULK_OPM_NULL_QTY'); --PROCESS HVOP

4810:
4811: IF (NVL(p_line_rec.ordered_quantity2(p_index),0) = 0 )
4812: OR (NVL(p_line_rec.ordered_quantity(p_index),0) = 0 ) THEN
4813: p_x_return_status := -1;
4814: FND_MESSAGE.set_name('ONT','OE_BULK_OPM_NULL_QTY'); --PROCESS HVOP
4815: OE_BULK_MSG_PUB.Add;
4816:
4817: END IF;
4818:

Line 4831: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV

4827: EXCEPTION
4828:
4829: WHEN UOM_CONVERSION_FAILED THEN
4830: oe_debug_pub.add('Exception handling: UOM_CONVERSION_FAILED in calculate_dual_qauntity', 1);
4831: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
4832: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4833:
4834: RAISE FND_API.G_EXC_ERROR;
4835: