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 89: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');

85: -- Check for fields required on a booked order line
86:
87: IF p_line_rec.sold_to_org_id(p_index) IS NULL THEN
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
90: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
91: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
92: OE_BULK_MSG_PUB.ADD;
93: END IF;

Line 90: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

93: END IF;
94:
95: IF p_line_rec.invoice_to_org_id(p_index) IS NULL THEN
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
99: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
100: OE_BULK_MSG_PUB.ADD;
101: END IF;

Line 98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

94:
95: IF p_line_rec.invoice_to_org_id(p_index) IS NULL THEN
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
99: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
100: OE_BULK_MSG_PUB.ADD;
101: END IF;
102:

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

101: END IF;
102:
103: IF p_line_rec.tax_exempt_flag(p_index) IS NULL THEN
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
107: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
108: OE_BULK_MSG_PUB.ADD;
109: END IF;

Line 106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

102:
103: IF p_line_rec.tax_exempt_flag(p_index) IS NULL THEN
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
107: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
108: OE_BULK_MSG_PUB.ADD;
109: END IF;
110:

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

111: -- Quantity and UOM Required
112:
113: IF p_line_rec.order_quantity_uom(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('ORDER_QUANTITY_UOM'));
118: OE_BULK_MSG_PUB.ADD;
119: END IF;

Line 116: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

112:
113: IF p_line_rec.order_quantity_uom(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('ORDER_QUANTITY_UOM'));
118: OE_BULK_MSG_PUB.ADD;
119: END IF;
120:

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

121: -- Fix bug 1277092: ordered quantity should not be = 0 on a booked line
122: IF p_line_rec.ordered_quantity(p_index) IS NULL
123: OR p_line_rec.ordered_quantity(p_index) = 0 THEN
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
126: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
127: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));
128: OE_BULK_MSG_PUB.ADD;
129: END IF;

Line 126: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

122: IF p_line_rec.ordered_quantity(p_index) IS NULL
123: OR p_line_rec.ordered_quantity(p_index) = 0 THEN
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
126: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
127: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));
128: OE_BULK_MSG_PUB.ADD;
129: END IF;
130:

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

136: <> OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
137:
138: IF p_line_rec.ship_to_org_id(p_index) IS NULL THEN
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
142: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
143: OE_BULK_MSG_PUB.ADD;
144: END IF;

Line 141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

137:
138: IF p_line_rec.ship_to_org_id(p_index) IS NULL THEN
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
142: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
143: OE_BULK_MSG_PUB.ADD;
144: END IF;
145:

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

144: END IF;
145:
146: IF p_line_rec.payment_term_id(p_index) IS NULL THEN
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
150: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
151: OE_BULK_MSG_PUB.ADD;
152: END IF;

Line 149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

145:
146: IF p_line_rec.payment_term_id(p_index) IS NULL THEN
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
150: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
151: OE_BULK_MSG_PUB.ADD;
152: END IF;
153: --serla

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

167: END IF;
168: IF l_rule_type = 'ACC_DUR' THEN
169: IF p_line_rec.accounting_rule_duration(p_index) IS NULL THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
172: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
173: OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_DURATION'));
174: OE_BULK_MSG_PUB.ADD;
175: END IF; -- end of accounting_rule_duration null

Line 172: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

168: IF l_rule_type = 'ACC_DUR' THEN
169: IF p_line_rec.accounting_rule_duration(p_index) IS NULL THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
172: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
173: OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_DURATION'));
174: OE_BULK_MSG_PUB.ADD;
175: END IF; -- end of accounting_rule_duration null
176: END IF; -- end of variable accounting rule type

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

186: -- Commenting out as of 1/23/2003 as tax checks not req'd
187: /*
188: IF p_line_rec.tax_date(p_index) IS NULL THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
191: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
192: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
193: OE_BULK_MSG_PUB.ADD;
194: END IF;

Line 191: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

187: /*
188: IF p_line_rec.tax_date(p_index) IS NULL THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
191: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
192: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
193: OE_BULK_MSG_PUB.ADD;
194: END IF;
195: */

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

205: IF p_line_rec.calculate_price_flag(p_index) = 'N' THEN
206:
207: IF p_line_rec.price_list_id(p_index) IS NULL THEN
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
210: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
211: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
212: OE_BULK_MSG_PUB.ADD;
213: END IF;

Line 210: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

206:
207: IF p_line_rec.price_list_id(p_index) IS NULL THEN
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
210: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
211: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
212: OE_BULK_MSG_PUB.ADD;
213: END IF;
214:

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

255:
256: -- Check for Required Scheduling Attributes
257:
258: IF p_line_rec.ordered_quantity(p_index) IS NULL THEN
259: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_QUANTITY');
260: OE_BULK_MSG_PUB.Add;
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: END IF;
263:

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

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

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

278: -- and if the user is trying to performing scheduling,
279: -- it is an error
280:
281: IF p_line_rec.order_quantity_uom(p_index) IS NULL THEN
282: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_UOM');
283: OE_BULK_MSG_PUB.Add;
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: END IF;
286:

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

290: -- if the user is trying to performing scheduling,
291: -- it is an error
292:
293: IF p_line_rec.request_date(p_index) IS NULL THEN
294: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_REQUEST_DATE');
295: OE_BULK_MSG_PUB.Add;
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: END IF;
298:

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

315: IF l_debug_level > 0 THEN
316: oe_debug_pub.add( 'CHECKING THAT IT IS A STANDARD ITEM...' , 1 ) ;
317: END IF;
318:
319: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
320: FND_MESSAGE.SET_TOKEN('LTYPE',
321: nvl(Oe_Schedule_Util.sch_cached_line_type ,'0'));
322: OE_BULK_MSG_PUB.Add;
323:

Line 320: FND_MESSAGE.SET_TOKEN('LTYPE',

316: oe_debug_pub.add( 'CHECKING THAT IT IS A STANDARD ITEM...' , 1 ) ;
317: END IF;
318:
319: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
320: FND_MESSAGE.SET_TOKEN('LTYPE',
321: nvl(Oe_Schedule_Util.sch_cached_line_type ,'0'));
322: OE_BULK_MSG_PUB.Add;
323:
324: IF l_debug_level > 0 THEN

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

338: THEN
339: IF MSC_ATP_GLOBAL.GET_APS_VERSION <> 10 AND
340: p_line_rec.ship_from_org_id(p_index) is NULL
341: THEN
342: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATO_WHSE_REQD');
343: OE_BULK_MSG_PUB.Add;
344: IF l_debug_level > 0 THEN
345: oe_debug_pub.add( 'OE_SCH_ATO_WHSE_REQD' , 1 ) ;
346: END IF;

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

380: IF l_debug_level > 0 THEN
381: oe_debug_pub.add( 'OE_BOM_NO_BILL_IN_SHP_ORG' , 2 ) ;
382: END IF;
383:
384: FND_MESSAGE.SET_NAME('ONT','OE_BOM_NO_BILL_IN_SHP_ORG');
385: FND_MESSAGE.SET_TOKEN('ITEM',p_line_rec.ordered_item(p_index));
386:
387: Select ORGANIZATION_CODE
388: Into l_org_code

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

381: oe_debug_pub.add( 'OE_BOM_NO_BILL_IN_SHP_ORG' , 2 ) ;
382: END IF;
383:
384: FND_MESSAGE.SET_NAME('ONT','OE_BOM_NO_BILL_IN_SHP_ORG');
385: FND_MESSAGE.SET_TOKEN('ITEM',p_line_rec.ordered_item(p_index));
386:
387: Select ORGANIZATION_CODE
388: Into l_org_code
389: From ORG_ORGANIZATION_DEFINITIONS

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

390: Where ORGANIZATION_ID = l_org_id;
391: IF l_debug_level > 0 THEN
392: oe_debug_pub.add( 'ORGANIZATION CODE:'||L_ORG_CODE , 2 ) ;
393: END IF;
394: FND_MESSAGE.SET_TOKEN('ORG',l_org_code);
395: OE_MSG_PUB.Add;
396: x_return_status := FND_API.G_RET_STS_ERROR;
397:
398: WHEN OTHERS THEN

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

639: IF p_line_rec.sold_to_org_id(p_index) IS NULL THEN
640: IF l_debug_level > 0 THEN
641: oe_debug_pub.add( 'SOLD TO ORG ID IS MISSING , CAN NOT GET CUST ITEM' ) ;
642: END IF;
643: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_CUSTOMER_ID');
644: OE_BULK_MSG_PUB.Add;
645: RAISE FND_API.G_EXC_ERROR;
646: END IF;
647:

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

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

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

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

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

664: oe_debug_pub.add( 'INV API CI_ATTR_VAL FOR INV_ITEM_ID RETURNED ERROR' ) ;
665: END IF;
666: FND_MESSAGE.SET_NAME('ONT','OE_INV_CUS_ITEM');
667: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code);
668: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', l_error_message);
669: OE_BULK_MSG_PUB.Add;
670: END IF;
671:
672: INV_CUSTOMER_ITEM_GRP.CI_Attribute_Value(

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

686: IF l_error_message IS NOT NULL THEN
687: IF l_debug_level > 0 THEN
688: oe_debug_pub.add( 'INV API CI_ATTR_VAL FOR ORDERED_ITEM_ID RETURNED ERROR' ) ;
689: END IF;
690: FND_MESSAGE.SET_NAME('ONT','OE_INV_CUS_ITEM');
691: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code);
692: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', l_error_message);
693: OE_BULK_MSG_PUB.Add;
694: END IF;

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

687: IF l_debug_level > 0 THEN
688: oe_debug_pub.add( 'INV API CI_ATTR_VAL FOR ORDERED_ITEM_ID RETURNED ERROR' ) ;
689: END IF;
690: FND_MESSAGE.SET_NAME('ONT','OE_INV_CUS_ITEM');
691: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code);
692: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', l_error_message);
693: OE_BULK_MSG_PUB.Add;
694: END IF;
695:

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

688: oe_debug_pub.add( 'INV API CI_ATTR_VAL FOR ORDERED_ITEM_ID RETURNED ERROR' ) ;
689: END IF;
690: FND_MESSAGE.SET_NAME('ONT','OE_INV_CUS_ITEM');
691: FND_MESSAGE.SET_TOKEN('ERROR_CODE', l_error_code);
692: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', l_error_message);
693: OE_BULK_MSG_PUB.Add;
694: END IF;
695:
696: IF l_inventory_item_id_int <> l_inventory_item_id_cust THEN

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

696: IF l_inventory_item_id_int <> l_inventory_item_id_cust THEN
697: IF l_debug_level > 0 THEN
698: oe_debug_pub.add( 'INV ITEM AND CUST ITEM MISMATCH' ) ;
699: END IF;
700: FND_MESSAGE.SET_NAME('ONT','OE_INV_INT_CUS_ITEM_ID');
701: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_inventory_item_id_int);
702: FND_MESSAGE.SET_TOKEN('CUST_ITEM_ID',l_inventory_item_id_cust);
703: OE_BULK_MSG_PUB.Add;
704: ELSIF l_inventory_item_id_int IS NOT NULL

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

697: IF l_debug_level > 0 THEN
698: oe_debug_pub.add( 'INV ITEM AND CUST ITEM MISMATCH' ) ;
699: END IF;
700: FND_MESSAGE.SET_NAME('ONT','OE_INV_INT_CUS_ITEM_ID');
701: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_inventory_item_id_int);
702: FND_MESSAGE.SET_TOKEN('CUST_ITEM_ID',l_inventory_item_id_cust);
703: OE_BULK_MSG_PUB.Add;
704: ELSIF l_inventory_item_id_int IS NOT NULL
705: THEN

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

698: oe_debug_pub.add( 'INV ITEM AND CUST ITEM MISMATCH' ) ;
699: END IF;
700: FND_MESSAGE.SET_NAME('ONT','OE_INV_INT_CUS_ITEM_ID');
701: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',l_inventory_item_id_int);
702: FND_MESSAGE.SET_TOKEN('CUST_ITEM_ID',l_inventory_item_id_cust);
703: OE_BULK_MSG_PUB.Add;
704: ELSIF l_inventory_item_id_int IS NOT NULL
705: THEN
706: p_line_rec.inventory_item_id(p_index):= l_inventory_item_id_int;

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

735: WHEN TOO_MANY_ROWS THEN
736: IF l_debug_level > 0 THEN
737: oe_debug_pub.add( 'TOO MANY ROWS ERROR: '||SQLERRM ) ;
738: END IF;
739: FND_MESSAGE.SET_NAME('ONT','OE_NOT_UNIQUE_ITEM');
740: FND_MESSAGE.SET_TOKEN('GENERIC_ITEM', p_line_rec.ordered_item(p_index));
741: OE_BULK_MSG_PUB.Add;
742: END;
743:

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

736: IF l_debug_level > 0 THEN
737: oe_debug_pub.add( 'TOO MANY ROWS ERROR: '||SQLERRM ) ;
738: END IF;
739: FND_MESSAGE.SET_NAME('ONT','OE_NOT_UNIQUE_ITEM');
740: FND_MESSAGE.SET_TOKEN('GENERIC_ITEM', p_line_rec.ordered_item(p_index));
741: OE_BULK_MSG_PUB.Add;
742: END;
743:
744: IF l_inventory_item_Id_int <> l_inventory_item_id_gen

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

745: THEN
746: IF l_debug_level > 0 THEN
747: oe_debug_pub.add( 'WARNING: GENERIC AND INVENTORY ITEM ARE DIFFERENT' ) ;
748: END IF;
749: FND_MESSAGE.SET_NAME('ONT','OE_INV_INT_CUS_ITEM_ID');
750: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', l_inventory_item_id_int);
751: FND_MESSAGE.SET_TOKEN('CUST_ITEM_ID', l_inventory_item_id_gen);
752: OE_BULK_MSG_PUB.Add;
753: p_line_rec.inventory_item_id(p_index):= l_inventory_item_id_gen;

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

746: IF l_debug_level > 0 THEN
747: oe_debug_pub.add( 'WARNING: GENERIC AND INVENTORY ITEM ARE DIFFERENT' ) ;
748: END IF;
749: FND_MESSAGE.SET_NAME('ONT','OE_INV_INT_CUS_ITEM_ID');
750: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', l_inventory_item_id_int);
751: FND_MESSAGE.SET_TOKEN('CUST_ITEM_ID', l_inventory_item_id_gen);
752: OE_BULK_MSG_PUB.Add;
753: p_line_rec.inventory_item_id(p_index):= l_inventory_item_id_gen;
754: ELSIF l_inventory_item_id_int IS NOT NULL

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

747: oe_debug_pub.add( 'WARNING: GENERIC AND INVENTORY ITEM ARE DIFFERENT' ) ;
748: END IF;
749: FND_MESSAGE.SET_NAME('ONT','OE_INV_INT_CUS_ITEM_ID');
750: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID', l_inventory_item_id_int);
751: FND_MESSAGE.SET_TOKEN('CUST_ITEM_ID', l_inventory_item_id_gen);
752: OE_BULK_MSG_PUB.Add;
753: p_line_rec.inventory_item_id(p_index):= l_inventory_item_id_gen;
754: ELSIF l_inventory_item_id_int IS NOT NULL
755: THEN

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

808: WHERE organization_id = p_ship_from_org_id
809: AND secondary_inventory_name = p_subinventory;
810: EXCEPTION
811: WHEN OTHERS THEN
812: fnd_message.set_name('ONT','OE_SUBINV_INVALID');
813: OE_BULK_MSG_PUB.Add;
814: RETURN FALSE;
815: END;
816:

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

819: IF p_source_type_code = 'INTERNAL' THEN
820:
821: IF p_ship_from_org_id is null THEN
822:
823: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
824: fnd_message.set_token('ATTRIBUTE'
825: ,OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
826: OE_BULK_MSG_PUB.Add;
827: RETURN FALSE;

Line 824: fnd_message.set_token('ATTRIBUTE'

820:
821: IF p_ship_from_org_id is null THEN
822:
823: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
824: fnd_message.set_token('ATTRIBUTE'
825: ,OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
826: OE_BULK_MSG_PUB.Add;
827: RETURN FALSE;
828:

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

867: )
868: );
869: EXCEPTION
870: WHEN OTHERS THEN
871: fnd_message.set_name('ONT', 'OE_SUBINV_NON_ASSET');
872: OE_BULK_MSG_PUB.ADD;
873: RETURN FALSE;
874: END;
875:

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

1027: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1028: IF nvl(p_input_quantity, 0) < 0 -- Process HVOP added check for negative as was missing -NB take out when support for RMAs needed
1029:
1030: THEN
1031: FND_MESSAGE.SET_NAME('ONT', 'SO_PR_NEGATIVE_AMOUNT');
1032: OE_BULK_MSG_PUB.Add('Y','ERROR');
1033: x_return_status := -99;
1034: IF l_debug_level > 0 THEN
1035: oe_debug_pub.add ('Validate decimal quantity - quantity negative so error ', 3);

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

1048: THEN
1049: IF l_debug_level > 0 THEN
1050: oe_debug_pub.add( 'ITEM IS CONFIG RELATED WITH DECIMAL QTY' , 2 ) ;
1051: END IF;
1052: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
1053: OE_BULK_MSG_PUB.Add('Y','ERROR');
1054: x_return_status := -99;
1055:
1056: ELSE

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

1074: oe_debug_pub.add( 'L_VAL_QTY '|| L_VALIDATED_QUANTITY , 2 ) ;
1075: END IF;
1076: /* bug 2926436 */
1077: IF l_qty_return_status = 'W' THEN
1078: fnd_message.set_name('ONT', 'OE_DECIMAL_MAX_PRECISION');
1079: END IF;
1080: --move INV error message to OE message stack
1081: OE_BULK_MSG_PUB.Add('Y','ERROR');
1082: x_return_status := -99;

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

1265: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1266: --
1267: BEGIN
1268: IF LENGTHB(p_user_item_description) > 240 THEN
1269: fnd_message.set_name('ONT','ONT_USER_ITEM_DESC_TOO_LONG');
1270: OE_BULK_MSG_PUB.ADD;
1271: IF l_debug_level > 0 THEN
1272: oe_debug_pub.add( 'THE LENGTH OF USER_ITEM_DESCRIPTION SHOULD NOT EXCEED 240 CHARA CTERS FOR DROP SHIP LINES.' , 3 ) ;
1273: END IF;

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

1652: OE_Bulk_Order_PVT.g_header_rec.invoice_to_org_id(p_header_index);
1653: ELSIF p_line_rec.invoice_to_org_id(p_index) <>
1654: OE_Bulk_Order_PVT.g_header_rec.invoice_to_org_id(p_header_index)
1655: THEN
1656: FND_MESSAGE.SET_NAME('ONT','OE_BULK_DIFF_INVOICE_TO');
1657: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1658: x_return_status := FND_API.G_RET_STS_ERROR;
1659: END IF;
1660:

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

1775: IF (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).bom_item_type = 4
1776: AND OE_BULK_CACHE.G_ITEM_TBL(l_c_index).service_item_flag = 'Y')
1777: THEN -- Service item type
1778: oe_debug_pub.add( 'Populate_Internal_Fields ab' ) ;
1779: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');
1780: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1781: x_return_status := FND_API.G_RET_STS_ERROR;
1782: x_unsupported_feature := 'Y';
1783: p_line_rec.lock_control(p_index) := -98;

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

1910: -- ATO Items
1911: OR (OE_BULK_CACHE.G_ITEM_TBL(l_c_index).replenish_to_order_flag = 'Y')
1912: THEN
1913: oe_debug_pub.add( 'Populate_Internal_Fields 4a' ) ;
1914: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');
1915: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1916: x_return_status := FND_API.G_RET_STS_ERROR;
1917: x_unsupported_feature := 'Y';
1918: p_line_rec.lock_control(p_index) := -98;

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

1987: IF l_debug_level > 0 THEN
1988: oe_debug_pub.add( 'error in calculate_dual_quantity 2 ' ) ;
1989: END IF;
1990:
1991: FND_MESSAGE.SET_NAME('ONT','OE_BULK_OPM_DUAL_QTY_ERROR'); -- HVOP define better OM or GMI error code
1992: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1993: x_return_status := FND_API.G_RET_STS_ERROR;
1994: END IF;
1995: oe_debug_pub.add( 'Populate_Internal_Fields 6' ) ;

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

2046:
2047: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_c_index).order_category_code
2048: <> 'ORDER'
2049: THEN
2050: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_RETURN');
2051: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
2052: x_return_status := FND_API.G_RET_STS_ERROR;
2053: ELSE
2054: p_line_rec.line_category_code(p_index) := 'ORDER';

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

2071: AND ((OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event NOT IN ( 'INVOICING' , 'SHIPPING' ))
2072: OR (OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_d_index).tax_calculation_event IS NULL))
2073: AND NVL(p_process_tax,'N') <> 'Y'
2074: THEN
2075: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_TAX_CAL');
2076: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
2077: x_return_status := FND_API.G_RET_STS_ERROR;
2078: END IF;
2079: */

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

2086: x_return_status := FND_API.G_RET_STS_ERROR;
2087:
2088: -- fix bug 5109227
2089: p_line_rec.lock_control(p_index) := -99 ;
2090: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2091: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2092: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2093: OE_BULK_MSG_PUB.Add('Y','ERROR');
2094: -- fix bug 5109227

Line 2091: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2087:
2088: -- fix bug 5109227
2089: p_line_rec.lock_control(p_index) := -99 ;
2090: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2091: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2092: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2093: OE_BULK_MSG_PUB.Add('Y','ERROR');
2094: -- fix bug 5109227
2095:

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

2210: ,l_unit_selling_price)
2211: <> nvl(l_unit_selling_price,FND_API.G_MISS_NUM)
2212: THEN
2213:
2214: FND_MESSAGE.SET_NAME('ONT','OE_OI_PRICE_WARNING');
2215: FND_MESSAGE.SET_TOKEN('CUST_PRICE'
2216: ,p_line_rec.customer_item_net_price(p_line_index));
2217: FND_MESSAGE.SET_TOKEN('SPLR_PRICE',l_unit_selling_price);
2218: OE_BULK_MSG_PUB.Add;

Line 2215: FND_MESSAGE.SET_TOKEN('CUST_PRICE'

2211: <> nvl(l_unit_selling_price,FND_API.G_MISS_NUM)
2212: THEN
2213:
2214: FND_MESSAGE.SET_NAME('ONT','OE_OI_PRICE_WARNING');
2215: FND_MESSAGE.SET_TOKEN('CUST_PRICE'
2216: ,p_line_rec.customer_item_net_price(p_line_index));
2217: FND_MESSAGE.SET_TOKEN('SPLR_PRICE',l_unit_selling_price);
2218: OE_BULK_MSG_PUB.Add;
2219:

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

2213:
2214: FND_MESSAGE.SET_NAME('ONT','OE_OI_PRICE_WARNING');
2215: FND_MESSAGE.SET_TOKEN('CUST_PRICE'
2216: ,p_line_rec.customer_item_net_price(p_line_index));
2217: FND_MESSAGE.SET_TOKEN('SPLR_PRICE',l_unit_selling_price);
2218: OE_BULK_MSG_PUB.Add;
2219:
2220: END IF;
2221:

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

2223: ,l_payment_term_id)
2224: <> nvl(l_payment_term_id,FND_API.G_MISS_NUM)
2225: THEN
2226:
2227: FND_MESSAGE.SET_NAME('ONT','OE_OI_PAYMENT_TERM_WARNING');
2228: FND_MESSAGE.SET_TOKEN('CUST_TERM'
2229: ,p_line_rec.customer_payment_term_id(p_line_index));
2230: FND_MESSAGE.SET_TOKEN('SPLR_TERM',l_payment_term_id);
2231: OE_BULK_MSG_PUB.Add;

Line 2228: FND_MESSAGE.SET_TOKEN('CUST_TERM'

2224: <> nvl(l_payment_term_id,FND_API.G_MISS_NUM)
2225: THEN
2226:
2227: FND_MESSAGE.SET_NAME('ONT','OE_OI_PAYMENT_TERM_WARNING');
2228: FND_MESSAGE.SET_TOKEN('CUST_TERM'
2229: ,p_line_rec.customer_payment_term_id(p_line_index));
2230: FND_MESSAGE.SET_TOKEN('SPLR_TERM',l_payment_term_id);
2231: OE_BULK_MSG_PUB.Add;
2232:

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

2226:
2227: FND_MESSAGE.SET_NAME('ONT','OE_OI_PAYMENT_TERM_WARNING');
2228: FND_MESSAGE.SET_TOKEN('CUST_TERM'
2229: ,p_line_rec.customer_payment_term_id(p_line_index));
2230: FND_MESSAGE.SET_TOKEN('SPLR_TERM',l_payment_term_id);
2231: OE_BULK_MSG_PUB.Add;
2232:
2233: END IF;
2234:

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

2427: IF OE_Bulk_Order_PVT.G_IMPORT_SHIPMENTS = 'NO' THEN
2428: IF (p_line_rec.orig_sys_line_ref(l_last_line_index)
2429: = p_line_rec.orig_sys_line_ref(l_index))
2430: THEN
2431: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
2432: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF'
2433: ,'orig_sys_line_ref');
2434: p_line_rec.lock_control(l_index) := -99;
2435: OE_BULK_MSG_PUB.Add;

Line 2432: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF'

2428: IF (p_line_rec.orig_sys_line_ref(l_last_line_index)
2429: = p_line_rec.orig_sys_line_ref(l_index))
2430: THEN
2431: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
2432: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF'
2433: ,'orig_sys_line_ref');
2434: p_line_rec.lock_control(l_index) := -99;
2435: OE_BULK_MSG_PUB.Add;
2436: END IF;

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

2439: = p_line_rec.orig_sys_line_ref(l_index))
2440: AND (p_line_rec.orig_sys_shipment_ref(l_last_line_index)
2441: = p_line_rec.orig_sys_shipment_ref(l_index))
2442: THEN
2443: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
2444: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF'
2445: ,'orig_sys_line_ref and orig_sys_shipment_ref');
2446: p_line_rec.lock_control(l_index) := -99;
2447: OE_BULK_MSG_PUB.Add;

Line 2444: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF'

2440: AND (p_line_rec.orig_sys_shipment_ref(l_last_line_index)
2441: = p_line_rec.orig_sys_shipment_ref(l_index))
2442: THEN
2443: FND_MESSAGE.SET_NAME('ONT','OE_OI_DUPLICATE_REF');
2444: FND_MESSAGE.SET_TOKEN('DUPLICATE_REF'
2445: ,'orig_sys_line_ref and orig_sys_shipment_ref');
2446: p_line_rec.lock_control(l_index) := -99;
2447: OE_BULK_MSG_PUB.Add;
2448: END IF;

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

2543: -- Validate Required Attributes
2544:
2545: IF (p_line_rec.inventory_item_id(l_index) IS NULL) THEN
2546:
2547: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2548: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2549: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
2550: OE_BULK_MSG_PUB.Add('Y','ERROR');
2551: p_line_rec.lock_control(l_index) := -99;

Line 2548: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2544:
2545: IF (p_line_rec.inventory_item_id(l_index) IS NULL) THEN
2546:
2547: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2548: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2549: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
2550: OE_BULK_MSG_PUB.Add('Y','ERROR');
2551: p_line_rec.lock_control(l_index) := -99;
2552:

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

2561: oe_debug_pub.add('after inventory_item_id');
2562:
2563: IF (p_line_rec.line_type_id(l_index) IS NULL) THEN
2564:
2565: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2566: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2567: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2568: OE_BULK_MSG_PUB.Add('Y','ERROR');
2569: p_line_rec.lock_control(l_index) := -99;

Line 2566: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2562:
2563: IF (p_line_rec.line_type_id(l_index) IS NULL) THEN
2564:
2565: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2566: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2567: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2568: OE_BULK_MSG_PUB.Add('Y','ERROR');
2569: p_line_rec.lock_control(l_index) := -99;
2570: IF l_debug_level > 0 THEN

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

2587: p_header_rec.ordered_date(header_counter))
2588: THEN
2589:
2590: p_line_rec.lock_control(l_index) := -99 ;
2591: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2592: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2593: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2594: OE_BULK_MSG_PUB.Add('Y','ERROR');
2595:

Line 2592: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2588: THEN
2589:
2590: p_line_rec.lock_control(l_index) := -99 ;
2591: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2592: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2593: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2594: OE_BULK_MSG_PUB.Add('Y','ERROR');
2595:
2596: ELSE

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

2611: IF l_debug_level > 0 THEN
2612: oe_debug_pub.add( 'FAILURE IN OE_BULK_WF_UTIL.Validate_LT_WF_Assignment ' ) ;
2613: END IF;
2614: p_line_rec.lock_control(l_index) := -99 ;
2615: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2616: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2617: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2618: OE_BULK_MSG_PUB.Add('Y','ERROR');
2619: ELSE

Line 2616: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2612: oe_debug_pub.add( 'FAILURE IN OE_BULK_WF_UTIL.Validate_LT_WF_Assignment ' ) ;
2613: END IF;
2614: p_line_rec.lock_control(l_index) := -99 ;
2615: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2616: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2617: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
2618: OE_BULK_MSG_PUB.Add('Y','ERROR');
2619: ELSE
2620: p_line_rec.wf_process_name(l_index) := l_process_name;

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

2633:
2634: -- Tax exempt reason code is required
2635: IF (p_line_rec.tax_exempt_reason_code(l_index) IS NULL) THEN
2636: p_line_rec.lock_control(l_index) := -99;
2637: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2638: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Tax Exempt Reason');
2639: OE_BULK_MSG_PUB.Add('Y','ERROR');
2640:
2641: ELSIF NOT OE_BULK_PROCESS_HEADER.Valid_Tax_Exempt_Reason

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

2634: -- Tax exempt reason code is required
2635: IF (p_line_rec.tax_exempt_reason_code(l_index) IS NULL) THEN
2636: p_line_rec.lock_control(l_index) := -99;
2637: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2638: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Tax Exempt Reason');
2639: OE_BULK_MSG_PUB.Add('Y','ERROR');
2640:
2641: ELSIF NOT OE_BULK_PROCESS_HEADER.Valid_Tax_Exempt_Reason
2642: (p_line_rec.tax_exempt_reason_code(l_index)) THEN

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

2641: ELSIF NOT OE_BULK_PROCESS_HEADER.Valid_Tax_Exempt_Reason
2642: (p_line_rec.tax_exempt_reason_code(l_index)) THEN
2643:
2644: p_line_rec.lock_control(l_index) := -99;
2645: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2646: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2647: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
2648: OE_BULK_MSG_PUB.Add('Y','ERROR');
2649:

Line 2646: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2642: (p_line_rec.tax_exempt_reason_code(l_index)) THEN
2643:
2644: p_line_rec.lock_control(l_index) := -99;
2645: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2646: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2647: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
2648: OE_BULK_MSG_PUB.Add('Y','ERROR');
2649:
2650: END IF;

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

2659: p_line_rec.lock_control(l_index) := -99;
2660: IF l_debug_level > 0 THEN
2661: oe_debug_pub.add( 'IN ERROR 6 ' ) ;
2662: END IF;
2663: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');
2664: OE_BULK_MSG_PUB.Add('Y','ERROR');
2665: END IF;
2666:
2667: END IF;

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

2710: p_line_rec.lock_control(l_index) := -99;
2711: IF l_debug_level > 0 THEN
2712: oe_debug_pub.add( 'IN ERROR 7 ' ) ;
2713: END IF;
2714: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
2715: OE_BULK_MSG_PUB.add('Y','ERROR');
2716: END IF;
2717:
2718: END IF;

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

2744: IF l_count = 0 THEN
2745: p_line_rec.shipping_method_code(l_index) := NULL;
2746:
2747: OE_BULK_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
2748: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2749: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2750: OE_Order_UTIL.Get_Attribute_Name('SHIPPING_METHOD_CODE'));
2751: OE_BULK_MSG_PUB.Add;
2752: OE_BULK_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

Line 2749: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2745: p_line_rec.shipping_method_code(l_index) := NULL;
2746:
2747: OE_BULK_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
2748: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2749: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2750: OE_Order_UTIL.Get_Attribute_Name('SHIPPING_METHOD_CODE'));
2751: OE_BULK_MSG_PUB.Add;
2752: OE_BULK_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
2753: END IF;

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

2773: p_line_rec.lock_control(l_index) := -99;
2774: IF l_debug_level > 0 THEN
2775: oe_debug_pub.add( 'error 1 ' ) ;
2776: END IF;
2777: fnd_message.set_name('ONT','OE_BULK_OPM_NOT_PROCESS');
2778: OE_BULK_MSG_PUB.Add('Y','ERROR');
2779: END IF;
2780:
2781: END IF; */

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

2802: p_line_rec.lock_control(l_index) := -99;
2803: IF l_debug_level > 0 THEN
2804: oe_debug_pub.add( 'error 2 ' ) ;
2805: END IF;
2806: fnd_message.set_name('ONT','OE_BULK_OPM_NOT_PROCESS');
2807: OE_BULK_MSG_PUB.Add('Y','ERROR');
2808: END IF;
2809: END IF; -- OE_BULK_CACHE.G_ITEM_TBL(l_c_index).opm_item_id IS NULL THEN
2810:

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

2854: IF l_debug_level > 0 THEN
2855: oe_debug_pub.add( 'UOM OTHER THAN PRIMARY UOM IS ENTERED' , 1 ) ;
2856: END IF;
2857:
2858: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2859: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );
2860: fnd_message.set_token('UOM', l_uom);
2861: OE_BULK_MSG_PUB.Add('Y','ERROR');
2862: --RAISE FND_API.G_EXC_ERROR;

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

2855: oe_debug_pub.add( 'UOM OTHER THAN PRIMARY UOM IS ENTERED' , 1 ) ;
2856: END IF;
2857:
2858: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2859: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );
2860: fnd_message.set_token('UOM', l_uom);
2861: OE_BULK_MSG_PUB.Add('Y','ERROR');
2862: --RAISE FND_API.G_EXC_ERROR;
2863: END IF;

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

2856: END IF;
2857:
2858: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2859: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );
2860: fnd_message.set_token('UOM', l_uom);
2861: OE_BULK_MSG_PUB.Add('Y','ERROR');
2862: --RAISE FND_API.G_EXC_ERROR;
2863: END IF;
2864: EXCEPTION

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

2866: IF l_debug_level > 0 THEN
2867: oe_debug_pub.add( 'OEXLLINB , NO_DATA_FOUND IN UOM VALIDATION' , 1 ) ;
2868: END IF;
2869: p_line_rec.lock_control(l_index) := -99;
2870: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2871: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );
2872: fnd_message.set_token('UOM', l_uom);
2873: OE_BULK_MSG_PUB.Add('Y','ERROR');
2874: END;

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

2867: oe_debug_pub.add( 'OEXLLINB , NO_DATA_FOUND IN UOM VALIDATION' , 1 ) ;
2868: END IF;
2869: p_line_rec.lock_control(l_index) := -99;
2870: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2871: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );
2872: fnd_message.set_token('UOM', l_uom);
2873: OE_BULK_MSG_PUB.Add('Y','ERROR');
2874: END;
2875:

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

2868: END IF;
2869: p_line_rec.lock_control(l_index) := -99;
2870: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2871: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );
2872: fnd_message.set_token('UOM', l_uom);
2873: OE_BULK_MSG_PUB.Add('Y','ERROR');
2874: END;
2875:
2876: ELSE

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

2889: oe_debug_pub.add( 'UOM :'||P_LINE_REC.ORDER_QUANTITY_UOM ( L_INDEX ) ) ;
2890: oe_debug_pub.add( 'ITEM ID :'||P_LINE_REC.INVENTORY_ITEM_ID ( L_INDEX ) ) ;
2891: END IF;
2892: p_line_rec.lock_control(l_index) := -99;
2893: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
2894: OE_BULK_MSG_PUB.Add('Y','ERROR');
2895: END IF;
2896:
2897: END IF; -- uom validation based on item type

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

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

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

2928: -- Validate project/warehouse combination.
2929: IF pjm_project.val_proj_idtonum(p_line_rec.project_id(l_index),
2930: p_line_rec.ship_from_org_id(l_index)) IS NULL
2931: THEN
2932: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SHIP_FROM_PROJ');
2933: OE_BULK_MSG_PUB.Add('Y','ERROR');
2934: p_line_rec.lock_control(l_index) := -99;
2935: IF l_debug_level > 0 THEN
2936: oe_debug_pub.add( 'IN ERROR 12 ' ) ;

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

2939: END IF;
2940:
2941: IF (p_line_rec.task_id(l_index) IS NOT NULL
2942: AND p_line_rec.project_id(l_index) IS NULL) THEN
2943: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');
2944: OE_BULK_MSG_PUB.Add('Y','ERROR');
2945: p_line_rec.lock_control(l_index) := -99;
2946: IF l_debug_level > 0 THEN
2947: oe_debug_pub.add( 'IN ERROR 13 ' ) ;

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

2951: AND p_line_rec.project_id(l_index) IS NOT NULL) THEN
2952:
2953: IF NOT Validate_task(p_line_rec.project_id(l_index),
2954: p_line_rec.task_id(l_index)) THEN
2955: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2956: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2957: OE_Order_Util.Get_Attribute_Name('task_id'));
2958: OE_BULK_MSG_PUB.Add('Y','ERROR');
2959: p_line_rec.lock_control(l_index) := -99;

Line 2956: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2952:
2953: IF NOT Validate_task(p_line_rec.project_id(l_index),
2954: p_line_rec.task_id(l_index)) THEN
2955: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2956: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2957: OE_Order_Util.Get_Attribute_Name('task_id'));
2958: OE_BULK_MSG_PUB.Add('Y','ERROR');
2959: p_line_rec.lock_control(l_index) := -99;
2960: IF l_debug_level > 0 THEN

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

2967: AND p_line_rec.project_id(l_index) IS NOT NULL) THEN
2968:
2969: IF Validate_task_reqd(p_line_rec.project_id(l_index),
2970: p_line_rec.ship_from_org_id(l_index)) THEN
2971: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_TASK_REQD');
2972: OE_BULK_MSG_PUB.Add('Y','ERROR');
2973: p_line_rec.lock_control(l_index) := -99;
2974: IF l_debug_level > 0 THEN
2975: oe_debug_pub.add( 'IN ERROR 15 ' ) ;

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

2984: IF PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM
2985: (p_line_rec.inventory_item_id(l_index),
2986: p_line_rec.ship_from_org_id(l_index)) = 'Y'
2987: THEN
2988: fnd_message.set_name('ONT', 'OE_UEFF_NUMBER_REQD');
2989: OE_BULK_MSG_PUB.Add('Y','ERROR');
2990: p_line_rec.lock_control(l_index) := -99;
2991: IF l_debug_level > 0 THEN
2992: oe_debug_pub.add( 'IN ERROR 16 ' ) ;

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

2998: IF (p_line_rec.project_id(l_index) IS NOT NULL OR
2999: p_line_rec.task_id(l_index) IS NOT NULL OR
3000: p_line_rec.end_item_unit_number(l_index) IS NOT NULL)
3001: THEN
3002: fnd_message.set_name('ONT', 'OE_PJM_NOT_INSTALLED');
3003: OE_BULK_MSG_PUB.Add('Y','ERROR');
3004: p_line_rec.lock_control(l_index) := -99;
3005: IF l_debug_level > 0 THEN
3006: oe_debug_pub.add( 'IN ERROR 17 ' ) ;

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

3028: , NULL --p_line_rec.source_document_type_id(l_index)
3029: )
3030: THEN
3031: p_line_rec.lock_control(l_index) := -99;
3032: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');
3033: OE_BULK_MSG_PUB.Add('Y','ERROR');
3034: IF l_debug_level > 0 THEN
3035: oe_debug_pub.add( 'IN ERROR 18 ' ) ;
3036: END IF;

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

3060: , p_line_rec.deliver_to_org_id(l_index)
3061: )
3062: THEN
3063: p_line_rec.lock_control(l_index) := -99;
3064: fnd_message.set_name('ONT', 'OE_ITORD_VALIDATION_FAILED');
3065: fnd_message.set_token('ITEM',OE_ITORD_UTIL.get_item_name(p_line_rec.inventory_item_id(l_index)));
3066: fnd_message.set_token('CATEGORY',OE_ITORD_UTIL.get_item_category_name(p_line_rec.inventory_item_id(l_index)));
3067: OE_BULK_MSG_PUB.Add('Y','ERROR');
3068: IF l_debug_level > 0 THEN

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

3061: )
3062: THEN
3063: p_line_rec.lock_control(l_index) := -99;
3064: fnd_message.set_name('ONT', 'OE_ITORD_VALIDATION_FAILED');
3065: fnd_message.set_token('ITEM',OE_ITORD_UTIL.get_item_name(p_line_rec.inventory_item_id(l_index)));
3066: fnd_message.set_token('CATEGORY',OE_ITORD_UTIL.get_item_category_name(p_line_rec.inventory_item_id(l_index)));
3067: OE_BULK_MSG_PUB.Add('Y','ERROR');
3068: IF l_debug_level > 0 THEN
3069: oe_debug_pub.add( 'IN ERROR 19 ' ) ;

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

3062: THEN
3063: p_line_rec.lock_control(l_index) := -99;
3064: fnd_message.set_name('ONT', 'OE_ITORD_VALIDATION_FAILED');
3065: fnd_message.set_token('ITEM',OE_ITORD_UTIL.get_item_name(p_line_rec.inventory_item_id(l_index)));
3066: fnd_message.set_token('CATEGORY',OE_ITORD_UTIL.get_item_category_name(p_line_rec.inventory_item_id(l_index)));
3067: OE_BULK_MSG_PUB.Add('Y','ERROR');
3068: IF l_debug_level > 0 THEN
3069: oe_debug_pub.add( 'IN ERROR 19 ' ) ;
3070: END IF;

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

3083: IF NOT Validate_User_Item_Description
3084: ( p_line_rec.user_item_description(l_index))
3085: THEN
3086: p_line_rec.lock_control(l_index) := -99;
3087: fnd_message.set_name('ONT', 'ONT_USER_ITEM_DESC_TOO_LONG');
3088: OE_BULK_MSG_PUB.Add('Y','ERROR');
3089: IF l_debug_level > 0 THEN
3090: oe_debug_pub.add( 'LENGTH OF USER ITEM DESC EXCEEDS LIMIT FOR EXTERNAL ORDERS. ' ) ;
3091: END IF;

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

3159: p_line_rec.lock_control(l_index) := -99;
3160: IF l_debug_level > 0 THEN
3161: oe_debug_pub.add( 'IN ERROR 22 ' ) ;
3162: END IF;
3163: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3165: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
3166: OE_BULK_MSG_PUB.Add('Y','ERROR');
3167: END IF;

Line 3164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3160: IF l_debug_level > 0 THEN
3161: oe_debug_pub.add( 'IN ERROR 22 ' ) ;
3162: END IF;
3163: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3165: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
3166: OE_BULK_MSG_PUB.Add('Y','ERROR');
3167: END IF;
3168:

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

3182: p_line_rec.lock_control(l_index) := -99;
3183: IF l_debug_level > 0 THEN
3184: oe_debug_pub.add( 'IN ERROR 22 ' ) ;
3185: END IF;
3186: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3188: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
3189: OE_BULK_MSG_PUB.Add('Y','ERROR');
3190: END IF;

Line 3187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3183: IF l_debug_level > 0 THEN
3184: oe_debug_pub.add( 'IN ERROR 22 ' ) ;
3185: END IF;
3186: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3188: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
3189: OE_BULK_MSG_PUB.Add('Y','ERROR');
3190: END IF;
3191:

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

3204: p_line_rec.lock_control(l_index) := -99;
3205: IF l_debug_level > 0 THEN
3206: oe_debug_pub.add( 'IN ERROR 22 ' ) ;
3207: END IF;
3208: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3209: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3210: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_ORG_ID'));
3211: OE_BULK_MSG_PUB.Add('Y','ERROR');
3212: END IF;

Line 3209: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3205: IF l_debug_level > 0 THEN
3206: oe_debug_pub.add( 'IN ERROR 22 ' ) ;
3207: END IF;
3208: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3209: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3210: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_ORG_ID'));
3211: OE_BULK_MSG_PUB.Add('Y','ERROR');
3212: END IF;
3213:

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

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

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

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

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

3263: p_line_rec.Ship_to_contact_id(l_index)
3264: )
3265: THEN
3266: p_line_rec.lock_control(l_index) := -99;
3267: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3268: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: SHIP To Contact ');
3269: OE_BULK_MSG_PUB.Add('Y','ERROR');
3270: END IF;
3271:

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

3264: )
3265: THEN
3266: p_line_rec.lock_control(l_index) := -99;
3267: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3268: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: SHIP To Contact ');
3269: OE_BULK_MSG_PUB.Add('Y','ERROR');
3270: END IF;
3271:
3272: END IF;

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

3290: p_line_rec.Deliver_to_contact_id(l_index)
3291: )
3292: THEN
3293: p_line_rec.lock_control(l_index) := -99;
3294: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3295: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: DeliverToContact');
3296: OE_BULK_MSG_PUB.Add('Y','ERROR');
3297: END IF;
3298:

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

3291: )
3292: THEN
3293: p_line_rec.lock_control(l_index) := -99;
3294: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3295: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: DeliverToContact');
3296: OE_BULK_MSG_PUB.Add('Y','ERROR');
3297: END IF;
3298:
3299: END IF;

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

3305: IF p_line_rec.end_Customer_id(l_index) IS NOT NULL
3306: AND NOT OE_GLOBALS.Equal(p_line_rec.end_Customer_id(l_index),p_header_rec.end_customer_id(header_counter))THEN
3307: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer(p_line_rec.end_customer_id(l_index)) THEN
3308: p_line_rec.lock_control(l_index) := -99;
3309: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_id'));
3311: OE_BULK_MSG_PUB.Add('Y','ERROR');
3312: END IF;
3313: END IF;

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

3306: AND NOT OE_GLOBALS.Equal(p_line_rec.end_Customer_id(l_index),p_header_rec.end_customer_id(header_counter))THEN
3307: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer(p_line_rec.end_customer_id(l_index)) THEN
3308: p_line_rec.lock_control(l_index) := -99;
3309: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_id'));
3311: OE_BULK_MSG_PUB.Add('Y','ERROR');
3312: END IF;
3313: END IF;
3314:

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

3315: IF p_line_rec.end_Customer_Contact_id(l_index) IS NOT NULL AND
3316: NOT OE_GLOBALS.Equal(p_line_rec.end_Customer_Contact_id(l_index),p_header_rec.end_customer_Contact_id(header_counter)) THEN
3317: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer_Contact(p_line_rec.end_customer_contact_id(l_index)) THEN
3318: p_line_rec.lock_control(l_index) := -99;
3319: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3320: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));
3321: OE_BULK_MSG_PUB.Add('Y','ERROR');
3322: END IF;
3323: END IF;

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

3316: NOT OE_GLOBALS.Equal(p_line_rec.end_Customer_Contact_id(l_index),p_header_rec.end_customer_Contact_id(header_counter)) THEN
3317: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer_Contact(p_line_rec.end_customer_contact_id(l_index)) THEN
3318: p_line_rec.lock_control(l_index) := -99;
3319: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3320: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));
3321: OE_BULK_MSG_PUB.Add('Y','ERROR');
3322: END IF;
3323: END IF;
3324:

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

3327: OE_GLOBALS.Equal(p_line_rec.end_Customer_site_use_id(l_index),p_header_rec.end_customer_site_use_id(header_counter)) THEN
3328: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer_site_use(p_line_rec.end_customer_site_use_id(l_index),
3329: p_line_rec.end_customer_id(l_index)) THEN
3330: p_line_rec.lock_control(l_index) := -99;
3331: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3332: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
3333: OE_BULK_MSG_PUB.Add('Y','ERROR');
3334: END IF;
3335: END IF;

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

3328: IF NOT OE_BULK_PROCESS_HEADER.Validate_End_Customer_site_use(p_line_rec.end_customer_site_use_id(l_index),
3329: p_line_rec.end_customer_id(l_index)) THEN
3330: p_line_rec.lock_control(l_index) := -99;
3331: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3332: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
3333: OE_BULK_MSG_PUB.Add('Y','ERROR');
3334: END IF;
3335: END IF;
3336:

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

3337: IF p_line_rec.IB_owner(l_index) IS NOT NULL AND NOT
3338: OE_GLOBALS.Equal(p_line_rec.IB_owner(l_index),p_header_rec.IB_owner(header_counter))THEN
3339: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_Owner(p_line_rec.IB_owner(l_index)) THEN
3340: p_line_rec.lock_control(l_index) := -99;
3341: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3342: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_owner'));
3343: OE_BULK_MSG_PUB.Add('Y','ERROR');
3344: END IF;
3345: END IF;

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

3338: OE_GLOBALS.Equal(p_line_rec.IB_owner(l_index),p_header_rec.IB_owner(header_counter))THEN
3339: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_Owner(p_line_rec.IB_owner(l_index)) THEN
3340: p_line_rec.lock_control(l_index) := -99;
3341: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3342: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_owner'));
3343: OE_BULK_MSG_PUB.Add('Y','ERROR');
3344: END IF;
3345: END IF;
3346:

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

3347: IF p_line_rec.IB_current_location(l_index) IS NOT NULL AND NOT
3348: OE_GLOBALS.Equal(p_line_rec.IB_current_location(l_index),p_header_rec.IB_current_location(header_counter)) THEN
3349: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_current_Location (p_line_rec.IB_current_location(l_index)) THEN
3350: p_line_rec.lock_control(l_index) := -99;
3351: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3352: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_location'));
3353: OE_BULK_MSG_PUB.Add('Y','ERROR');
3354: END IF;
3355: END IF;

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

3348: OE_GLOBALS.Equal(p_line_rec.IB_current_location(l_index),p_header_rec.IB_current_location(header_counter)) THEN
3349: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_current_Location (p_line_rec.IB_current_location(l_index)) THEN
3350: p_line_rec.lock_control(l_index) := -99;
3351: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3352: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_location'));
3353: OE_BULK_MSG_PUB.Add('Y','ERROR');
3354: END IF;
3355: END IF;
3356:

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

3357: IF p_line_rec.IB_Installed_at_location(l_index) IS NOT NULL AND NOT
3358: OE_GLOBALS.Equal(p_line_rec.IB_Installed_at_location(l_index),p_header_rec.IB_Installed_at_location(header_counter)) THEN
3359: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_Inst_loc(p_line_rec.IB_Installed_at_location(l_index)) THEN
3360: p_line_rec.lock_control(l_index) := -99;
3361: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('Installed_at_location'));
3363: OE_BULK_MSG_PUB.Add('Y','ERROR');
3364: END IF;
3365: END IF;

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

3358: OE_GLOBALS.Equal(p_line_rec.IB_Installed_at_location(l_index),p_header_rec.IB_Installed_at_location(header_counter)) THEN
3359: IF NOT OE_BULK_PROCESS_HEADER.Validate_IB_Inst_loc(p_line_rec.IB_Installed_at_location(l_index)) THEN
3360: p_line_rec.lock_control(l_index) := -99;
3361: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('Installed_at_location'));
3363: OE_BULK_MSG_PUB.Add('Y','ERROR');
3364: END IF;
3365: END IF;
3366: --Bug 5054618}

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

3384: oe_debug_pub.add( 'RULE_TYPE IS :'||L_RULE_TYPE) ;
3385: END IF;
3386: IF l_rule_type = 'PP_DR_ALL' OR l_rule_type = 'PP_DR_PP' THEN
3387: p_line_rec.lock_control(l_index) := -99 ;
3388: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3389: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_ID'));
3390: OE_BULK_MSG_PUB.Add('Y','ERROR');
3391: END IF; -- end of accounting rule type
3392: END IF; -- end of accounting_rule_id not null

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

3385: END IF;
3386: IF l_rule_type = 'PP_DR_ALL' OR l_rule_type = 'PP_DR_PP' THEN
3387: p_line_rec.lock_control(l_index) := -99 ;
3388: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3389: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_ID'));
3390: OE_BULK_MSG_PUB.Add('Y','ERROR');
3391: END IF; -- end of accounting rule type
3392: END IF; -- end of accounting_rule_id not null
3393: END IF; -- end of non-service line

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

3476: EXCEPTION
3477:
3478: WHEN NO_DATA_FOUND THEN
3479: p_line_rec.lock_control(l_index) := -99;
3480: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3481: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: Tax Exemptions');
3482: OE_BULK_MSG_PUB.Add('Y','ERROR');
3483:
3484:

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

3477:
3478: WHEN NO_DATA_FOUND THEN
3479: p_line_rec.lock_control(l_index) := -99;
3480: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3481: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: Tax Exemptions');
3482: OE_BULK_MSG_PUB.Add('Y','ERROR');
3483:
3484:
3485: END;

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

3547: p_line_rec.lock_control(l_index) := -99;
3548: IF l_debug_level > 0 THEN
3549: oe_debug_pub.add( 'IN ERROR 29 ' ) ;
3550: END IF;
3551: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3552: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: Tax Code');
3553: OE_BULK_MSG_PUB.Add('Y','ERROR');
3554: END; -- BEGIN
3555: END IF;

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

3548: IF l_debug_level > 0 THEN
3549: oe_debug_pub.add( 'IN ERROR 29 ' ) ;
3550: END IF;
3551: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3552: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Entity: Tax Code');
3553: OE_BULK_MSG_PUB.Add('Y','ERROR');
3554: END; -- BEGIN
3555: END IF;
3556:

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

3565: IF (l_is_ota_line)
3566: AND p_line_rec.ordered_quantity(l_index) > 1 THEN
3567:
3568: p_line_rec.lock_control(l_index) := -99;
3569: FND_Message.Set_Name('ONT', 'OE_OTA_INVALID_QTY');
3570: OE_BULK_MSG_PUB.Add('Y','ERROR');
3571:
3572: END IF;
3573:

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

3581: (p_line_rec.cust_po_number(l_index)
3582: ,p_line_rec.sold_to_org_id(l_index)
3583: ,p_line_rec.header_id(l_index) )
3584: THEN
3585: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_PO_NUMBER');
3586: OE_BULK_MSG_PUB.Add('Y','ERROR');
3587: END IF;
3588: END IF;
3589: IF p_line_rec.service_end_date(l_index) IS NOT NULL

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

3591: THEN
3592: IF p_line_rec.service_start_date(l_index) >=
3593: p_line_rec.service_end_date(l_index)
3594: THEN
3595: fnd_message.set_name('ONT','OE_SERV_END_DATE');
3596: OE_BULK_MSG_PUB.Add('Y','ERROR');
3597: p_line_rec.lock_control(l_index) := -99;
3598: END IF;
3599: END IF;

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

3626: ,p_attribute19 => p_line_rec.attribute19(l_index)
3627: ,p_attribute20 => p_line_rec.attribute20(l_index))
3628: THEN
3629: p_line_rec.lock_control(l_index) := -99;
3630: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
3631: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3632: 'Entity:Flexfield:Line_Desc_Flex');
3633: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
3634:

Line 3631: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3627: ,p_attribute20 => p_line_rec.attribute20(l_index))
3628: THEN
3629: p_line_rec.lock_control(l_index) := -99;
3630: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
3631: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3632: 'Entity:Flexfield:Line_Desc_Flex');
3633: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
3634:
3635: ELSE -- if the flex validation is successfull

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

3777: ,p_attribute29 => p_line_rec.Industry_attribute29(l_index)
3778: ,p_attribute30 => p_line_rec.Industry_attribute30(l_index))
3779: THEN
3780: p_line_rec.lock_control(l_index) := -99;
3781: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
3782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3783: 'Entity:Flexfield:Industry Line_Desc_Flex');
3784: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
3785:

Line 3782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3778: ,p_attribute30 => p_line_rec.Industry_attribute30(l_index))
3779: THEN
3780: p_line_rec.lock_control(l_index) := -99;
3781: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
3782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3783: 'Entity:Flexfield:Industry Line_Desc_Flex');
3784: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
3785:
3786: ELSE -- for bug 2511313

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

3964: ,p_attribute14 => p_line_rec.tp_attribute14(l_index)
3965: ,p_attribute15 => p_line_rec.tp_attribute15(l_index))
3966: THEN
3967: p_line_rec.lock_control(l_index) := -99;
3968: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
3969: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3970: 'Entity:Flexfield:TP Line_Desc_Flex');
3971: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
3972:

Line 3969: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3965: ,p_attribute15 => p_line_rec.tp_attribute15(l_index))
3966: THEN
3967: p_line_rec.lock_control(l_index) := -99;
3968: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
3969: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3970: 'Entity:Flexfield:TP Line_Desc_Flex');
3971: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
3972:
3973: ELSE -- if the flex validation is successfull

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

4072: IF l_debug_level > 0 THEN
4073: oe_debug_pub.add( 'LIST PRICE OR SELLING PRICE IS NULL... ' ) ;
4074: END IF;
4075: p_line_rec.lock_control(l_index) := -99;
4076: FND_MESSAGE.SET_NAME('ONT','OE_OI_PRICE');
4077: OE_BULK_MSG_PUB.Add;
4078: ELSIF p_line_rec.pricing_quantity(l_index) IS NULL
4079: THEN
4080: IF l_debug_level > 0 THEN

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

4252: IF ( OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD = 'N'
4253: AND l_on_generic_hold )
4254: THEN
4255: -- Add scheduling on hold message
4256: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
4257: OE_BULK_MSG_PUB.Add;
4258: ELSE
4259: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'ONE'
4260: OR (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code IS NULL

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

4260: OR (OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code IS NULL
4261: AND OE_BULK_CACHE.G_ORDER_TYPE_TBL(l_c_index).scheduling_level_code = 'ONE')
4262: THEN
4263: -- Add ATP Only message
4264: FND_MESSAGE.SET_NAME('ONT','OE_ATP_ONLY');
4265: OE_BULK_MSG_PUB.Add;
4266: ELSE
4267: Check_Scheduling_Attributes(p_line_rec => p_line_rec
4268: ,p_index =>l_index

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

4290: END IF;
4291: p_line_rec.schedule_status_code(l_index) := 'SCHEDULED';
4292: p_line_rec.visible_demand_flag(l_index) := 'N';
4293: ELSE
4294: FND_MESSAGE.SET_NAME('ONT','OE_INV_NO_WAREHOUSE');
4295: OE_BULK_MSG_PUB.Add;
4296: IF p_line_rec.schedule_ship_date(l_index) IS NOT NULL
4297: OR p_line_rec.schedule_arrival_date(l_index) IS NOT NULL THEN
4298: p_line_rec.lock_control(l_index) := -99;

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

4322: < trunc(p_line_rec.request_date(l_index)) THEN -- LAD less than request date
4323: IF l_debug_level > 0 THEN
4324: oe_debug_pub.add( 'Request date exceeds Latest Acceptable Date ',1 ) ;
4325: END IF;
4326: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_REQUEST_EXCEED_LAD');
4327: OE_BULK_MSG_PUB.Add;
4328: ELSIF ((l_order_date_type_code = 'SHIP'
4329: AND trunc(NVL(p_line_rec.schedule_ship_date(l_index),p_line_rec.request_date(l_index)))
4330: > trunc(NVL(p_line_rec.latest_acceptable_date(l_index),p_line_rec.request_date(l_index))))

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

4330: > trunc(NVL(p_line_rec.latest_acceptable_date(l_index),p_line_rec.request_date(l_index))))
4331: OR (l_order_date_type_code = 'ARRIVAL'
4332: AND trunc(NVL(p_line_rec.schedule_arrival_date(l_index),p_line_rec.request_date(l_index)))
4333: > trunc(NVL(p_line_rec.latest_acceptable_date(l_index),p_line_rec.request_date(l_index))))) THEN
4334: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_LAD_SCH_FAILED');
4335: OE_BULK_MSG_PUB.Add;
4336: IF l_debug_level > 0 THEN
4337: oe_debug_pub.add( 'SCHEDULE DATE EXCEEDS LAD ',1 ) ;
4338: END IF;

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

4588: /* If quantity2 is present and negative, then error */
4589:
4590: IF nvl(p_line_rec.ordered_quantity2(p_index), 0) < 0
4591: THEN
4592: FND_MESSAGE.SET_NAME('ONT','SO_PR_NEGATIVE_AMOUNT'); -- HVOP define better OM or GMI error code
4593: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4594: p_x_return_status := -1;
4595: IF l_debug_level > 0 THEN
4596: oe_debug_pub.add ('calculate_dual_qty- quantity2 negative so error ', 3);

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

4614: IF l_debug_level > 0 THEN
4615: oe_debug_pub.add( 'calculate_dual_qty - invalid warehouse/item combo' ) ;
4616: END IF;
4617: p_x_return_status := -1;
4618: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
4619: OE_BULK_MSG_PUB.add('Y','ERROR');
4620: RETURN;
4621: END IF;
4622:

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

4735: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
4736: p_encoded => 'F');
4737: p_x_return_status := -1;
4738: oe_msg_pub.add_text(p_message_text => l_buffer);
4739: --fnd_message.set_name('ONT',l_buffer); -- PAL
4740: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4741: /*IF l_debug_level > 0 THEN
4742: oe_debug_pub.add(l_buffer,1);
4743: END IF; */

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: END IF; -- (NVL(p_line_rec.ordered_quantity2(p_index),0) <> 0 )

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

4862: ,p_opm_item_um2
4863: ,0);
4864: IF (l_return = -68 ) THEN
4865: p_x_return_status := -1;
4866: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
4867: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4868: ELSIF(l_return = -69 ) THEN
4869: p_x_return_status := -1;
4870: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');

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

4866: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
4867: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4868: ELSIF(l_return = -69 ) THEN
4869: p_x_return_status := -1;
4870: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
4871: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4872: END IF; */
4873:
4874: IF l_debug_level > 0 THEN

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

4896: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
4897: p_encoded => 'F');
4898: p_x_return_status := -1;
4899: oe_msg_pub.add_text(p_message_text => l_buffer);
4900: --fnd_message.set_name('ONT',l_buffer);
4901: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4902:
4903: IF l_debug_level > 0 THEN
4904: oe_debug_pub.add(l_buffer,1);

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

4915:
4916: IF (NVL(p_line_rec.ordered_quantity2(p_index),0) = 0 )
4917: OR (NVL(p_line_rec.ordered_quantity(p_index),0) = 0 ) THEN
4918: p_x_return_status := -1;
4919: FND_MESSAGE.set_name('ONT','OE_BULK_OPM_NULL_QTY'); --PROCESS HVOP
4920: OE_BULK_MSG_PUB.Add;
4921:
4922: END IF;
4923:

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

4932: EXCEPTION
4933:
4934: WHEN UOM_CONVERSION_FAILED THEN
4935: oe_debug_pub.add('Exception handling: UOM_CONVERSION_FAILED in calculate_dual_qauntity', 1);
4936: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
4937: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4938:
4939: RAISE FND_API.G_EXC_ERROR;
4940: