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

Line 225: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_NO_SOURCES');

221: END IF;
222:
223: IF in_global_orgs = 'N' then
224:
225: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_NO_SOURCES');
226: OE_MSG_PUB.Add;
227: ELSE
228: x_error_message := l_explanation;
229: END IF;

Line 270: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');

266: IF l_debug_level > 0 THEN
267: oe_debug_pub.add( 'ERROR CODE = 53' ) ;
268: END IF;
269:
270: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
271: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
272: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
273: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
274:

Line 271: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));

267: oe_debug_pub.add( 'ERROR CODE = 53' ) ;
268: END IF;
269:
270: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
271: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
272: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
273: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
274:
275: g_mrp_error_msg :=FND_MESSAGE.GET;

Line 272: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));

268: END IF;
269:
270: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
271: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
272: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
273: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
274:
275: g_mrp_error_msg :=FND_MESSAGE.GET;
276: g_mrp_error_msg_flag := 'T';

Line 273: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));

269:
270: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
271: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
272: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
273: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
274:
275: g_mrp_error_msg :=FND_MESSAGE.GET;
276: g_mrp_error_msg_flag := 'T';
277:

Line 275: g_mrp_error_msg :=FND_MESSAGE.GET;

271: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
272: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
273: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
274:
275: g_mrp_error_msg :=FND_MESSAGE.GET;
276: g_mrp_error_msg_flag := 'T';
277:
278: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
279: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));

Line 278: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');

274:
275: g_mrp_error_msg :=FND_MESSAGE.GET;
276: g_mrp_error_msg_flag := 'T';
277:
278: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
279: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
280: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
281: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
282:

Line 279: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));

275: g_mrp_error_msg :=FND_MESSAGE.GET;
276: g_mrp_error_msg_flag := 'T';
277:
278: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
279: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
280: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
281: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
282:
283: IF in_global_orgs = 'N' then

Line 280: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));

276: g_mrp_error_msg_flag := 'T';
277:
278: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
279: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
280: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
281: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
282:
283: IF in_global_orgs = 'N' then
284: OE_MSG_PUB.Add;

Line 281: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));

277:
278: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
279: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));
280: FND_MESSAGE.SET_TOKEN('REQUEST_DATE', p_atp_rec.requested_ship_date(J));
281: FND_MESSAGE.SET_TOKEN('EARLIEST_DATE', p_atp_rec.ship_date(J));
282:
283: IF in_global_orgs = 'N' then
284: OE_MSG_PUB.Add;
285: ELSE

Line 286: x_error_message := fnd_message.get;

282:
283: IF in_global_orgs = 'N' then
284: OE_MSG_PUB.Add;
285: ELSE
286: x_error_message := fnd_message.get;
287: END IF;
288:
289: /* End of code added to fix the bug 3245976 - issue 8 */
290:

Line 302: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');

298: ELSE
299: IF l_debug_level > 0 THEN
300: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
301: END IF;
302: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
303: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
304:
305: IF in_global_orgs = 'N' then
306: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');

Line 303: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);

299: IF l_debug_level > 0 THEN
300: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
301: END IF;
302: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
303: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
304:
305: IF in_global_orgs = 'N' then
306: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');
307: FND_MESSAGE.SET_TOKEN('TEXT',l_explanation);

Line 306: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');

302: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
303: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
304:
305: IF in_global_orgs = 'N' then
306: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');
307: FND_MESSAGE.SET_TOKEN('TEXT',l_explanation);
308: OE_MSG_PUB.Add;
309: ELSE
310: x_error_message := l_explanation;

Line 307: FND_MESSAGE.SET_TOKEN('TEXT',l_explanation);

303: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
304:
305: IF in_global_orgs = 'N' then
306: FND_MESSAGE.SET_NAME('ONT','ONT_INLNE_CUSTOMER');
307: FND_MESSAGE.SET_TOKEN('TEXT',l_explanation);
308: OE_MSG_PUB.Add;
309: ELSE
310: x_error_message := l_explanation;
311: END IF;

Line 385: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');

381: END IF; -- Main If;
382:
383: -- umcomment for testing the error handling
384: --x_return_status := 'E';
385: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
386: --OE_MSG_PUB.Add;
387:
388: IF x_return_status ='E' and in_global_orgs = 'N' then
389: IF l_debug_level > 0 THEN

Line 3678: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

3674: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3675: IF l_debug_level > 0 THEN
3676: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
3677: END IF;
3678: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3679: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
3680: OE_MSG_PUB.Add;
3681: RAISE FND_API.G_EXC_ERROR;
3682: END IF;

Line 3679: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);

3675: IF l_debug_level > 0 THEN
3676: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
3677: END IF;
3678: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3679: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
3680: OE_MSG_PUB.Add;
3681: RAISE FND_API.G_EXC_ERROR;
3682: END IF;
3683:

Line 3723: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

3719: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3720: IF l_debug_level > 0 THEN
3721: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
3722: END IF;
3723: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3724: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
3725: OE_MSG_PUB.Add;
3726: raise fnd_api.g_exc_unexpected_error;
3727: END IF;

Line 3724: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);

3720: IF l_debug_level > 0 THEN
3721: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
3722: END IF;
3723: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3724: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
3725: OE_MSG_PUB.Add;
3726: raise fnd_api.g_exc_unexpected_error;
3727: END IF;
3728:

Line 5251: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');

5247: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_panda_rec_table(1).p_PRICE_LIST_ID ) ;
5248: END IF;
5249: IF g_panda_rec_table(1).p_price_list_id is null then
5250:
5251: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
5252: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);
5253: IF l_debug_level > 0 THEN
5254: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;
5255: END IF;

Line 5252: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);

5248: END IF;
5249: IF g_panda_rec_table(1).p_price_list_id is null then
5250:
5251: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
5252: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);
5253: IF l_debug_level > 0 THEN
5254: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;
5255: END IF;
5256: OE_MSG_PUB.Add;

Line 5262: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');

5258: ELSE
5259: IF l_debug_level > 0 THEN
5260: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
5261: END IF;
5262: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
5263: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5264: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
5265: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
5266: OE_MSG_PUB.Add;

Line 5263: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);

5259: IF l_debug_level > 0 THEN
5260: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
5261: END IF;
5262: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
5263: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5264: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
5265: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
5266: OE_MSG_PUB.Add;
5267:

Line 5264: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);

5260: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
5261: END IF;
5262: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
5263: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5264: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
5265: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
5266: OE_MSG_PUB.Add;
5267:
5268: END IF;

Line 5265: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);

5261: END IF;
5262: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
5263: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5264: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
5265: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
5266: OE_MSG_PUB.Add;
5267:
5268: END IF;
5269:

Line 5272: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');

5268: END IF;
5269:
5270: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
5271:
5272: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
5273: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5274: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5275: OE_MSG_PUB.Add;
5276:

Line 5273: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);

5269:
5270: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
5271:
5272: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
5273: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5274: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5275: OE_MSG_PUB.Add;
5276:
5277: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then

Line 5274: FND_MESSAGE.SET_TOKEN('UOM',in_uom);

5270: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
5271:
5272: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
5273: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5274: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5275: OE_MSG_PUB.Add;
5276:
5277: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
5278: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');

Line 5278: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');

5274: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5275: OE_MSG_PUB.Add;
5276:
5277: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
5278: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
5279: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text); --3730467
5280: OE_MSG_PUB.Add;
5281:
5282:

Line 5279: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text); --3730467

5275: OE_MSG_PUB.Add;
5276:
5277: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
5278: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
5279: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text); --3730467
5280: OE_MSG_PUB.Add;
5281:
5282:
5283: ELSIF in_status_code in

Line 5286: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

5282:
5283: ELSIF in_status_code in
5284: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
5285: FND_API.G_RET_STS_ERROR) then
5286: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5287: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5288: OE_MSG_PUB.Add;
5289:
5290: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then

Line 5287: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);

5283: ELSIF in_status_code in
5284: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
5285: FND_API.G_RET_STS_ERROR) then
5286: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5287: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5288: OE_MSG_PUB.Add;
5289:
5290: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
5291: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');

Line 5291: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');

5287: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5288: OE_MSG_PUB.Add;
5289:
5290: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
5291: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
5292: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5293: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5294: OE_MSG_PUB.Add;
5295:

Line 5292: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);

5288: OE_MSG_PUB.Add;
5289:
5290: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
5291: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
5292: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5293: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5294: OE_MSG_PUB.Add;
5295:
5296: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then

Line 5293: FND_MESSAGE.SET_TOKEN('UOM',in_uom);

5289:
5290: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
5291: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
5292: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5293: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5294: OE_MSG_PUB.Add;
5295:
5296: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
5297: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');

Line 5297: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');

5293: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5294: OE_MSG_PUB.Add;
5295:
5296: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
5297: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
5298:
5299: IF l_debug_level > 0 THEN
5300: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
5301: END IF;

Line 5319: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);

5315:
5316: IF l_debug_level > 0 THEN
5317: oe_debug_pub.add( 'PRICE LIST 1='||L_PRICE_LIST ) ;
5318: END IF;
5319: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
5320: Begin
5321: Select name into l_price_list
5322: from qp_list_headers_vl a,qp_list_lines b where
5323: b.list_line_id = to_number(substr(in_status_text,

Line 5337: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);

5333: IF l_debug_level > 0 THEN
5334: oe_debug_pub.add( 'PRICE LIST 2='||L_PRICE_LIST ) ;
5335: END IF;
5336:
5337: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
5338: OE_MSG_PUB.Add;
5339:
5340: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
5341: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');

Line 5341: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');

5337: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
5338: OE_MSG_PUB.Add;
5339:
5340: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
5341: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
5342: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
5343: in_status_text);
5344: OE_MSG_PUB.Add;
5345:

Line 5342: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||

5338: OE_MSG_PUB.Add;
5339:
5340: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
5341: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
5342: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
5343: in_status_text);
5344: OE_MSG_PUB.Add;
5345:
5346: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then

Line 5347: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');

5343: in_status_text);
5344: OE_MSG_PUB.Add;
5345:
5346: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
5347: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
5348: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
5349: in_status_text);
5350: OE_MSG_PUB.Add;
5351:

Line 5348: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||

5344: OE_MSG_PUB.Add;
5345:
5346: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
5347: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
5348: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
5349: in_status_text);
5350: OE_MSG_PUB.Add;
5351:
5352: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then

Line 5353: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');

5349: in_status_text);
5350: OE_MSG_PUB.Add;
5351:
5352: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
5353: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
5354: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5355: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5356: OE_MSG_PUB.Add;
5357: END IF;

Line 5354: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);

5350: OE_MSG_PUB.Add;
5351:
5352: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
5353: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
5354: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5355: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5356: OE_MSG_PUB.Add;
5357: END IF;
5358:

Line 5355: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);

5351:
5352: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
5353: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
5354: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5355: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5356: OE_MSG_PUB.Add;
5357: END IF;
5358:
5359:

Line 5367: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');

5363:
5364: IF l_debug_level > 0 THEN
5365: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
5366: END IF;
5367: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
5368: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
5369: OE_MSG_PUB.Add;
5370:
5371: ELSIF in_line_Type_code ='LINE' and in_status_code in

Line 5368: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);

5364: IF l_debug_level > 0 THEN
5365: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
5366: END IF;
5367: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
5368: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
5369: OE_MSG_PUB.Add;
5370:
5371: ELSIF in_line_Type_code ='LINE' and in_status_code in
5372: --( QP_PREQ_GRP.G_STATUS_UPDATED,

Line 5395: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

5391: l_return_status := 'E';
5392: END IF;
5393: --Bug 7409782 ends
5394:
5395: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5396: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5397: OE_MSG_PUB.Add;
5398: END IF;
5399:

Line 5396: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);

5392: END IF;
5393: --Bug 7409782 ends
5394:
5395: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5396: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5397: OE_MSG_PUB.Add;
5398: END IF;
5399:
5400: -- we need to do this check in UPDATED code or do the gsa check through

Line 5430: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');

5426: End;
5427:
5428: l_return_status := 'E';
5429: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);
5430: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
5431: l_msg_text := l_operand||' ( '||l_msg_text||' )';
5432: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
5433: OE_MSG_PUB.Add;
5434: END IF;

Line 5432: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);

5428: l_return_status := 'E';
5429: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);
5430: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
5431: l_msg_text := l_operand||' ( '||l_msg_text||' )';
5432: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
5433: OE_MSG_PUB.Add;
5434: END IF;
5435: END IF; */
5436:

Line 6437: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');

6433: IF l_debug_level > 0 THEN
6434: oe_debug_pub.add( 'MSG DATA IS NOT NULL' ) ;
6435: END IF;
6436: x_return_status := 'E';
6437: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
6438: IF l_debug_level > 0 THEN
6439: oe_debug_pub.add( 'MSG DATA IS NOT NULL 2' ) ;
6440: END IF;
6441: FND_MESSAGE.SET_TOKEN('TEXT',x_msg_data);

Line 6441: FND_MESSAGE.SET_TOKEN('TEXT',x_msg_data);

6437: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
6438: IF l_debug_level > 0 THEN
6439: oe_debug_pub.add( 'MSG DATA IS NOT NULL 2' ) ;
6440: END IF;
6441: FND_MESSAGE.SET_TOKEN('TEXT',x_msg_data);
6442: OE_MSG_PUB.Add;
6443:
6444: END IF;
6445:

Line 6512: fnd_message.set_name('MSC', 'MSC_NO_PLANS_DEFINED');

6508: using l_instance_id,in_inventory_item_id,l_org_id;
6509:
6510:
6511: IF x_plan_id is null then
6512: fnd_message.set_name('MSC', 'MSC_NO_PLANS_DEFINED');
6513: oe_msg_pub.add;
6514: x_return_status := 'E';
6515: oe_debug_pub.add('Plan Id NOT FOUND');
6516: END IF;

Line 6593: fnd_message.set_name('MSC', x_err_mesg);

6589: IF nvl(x_return_status,'S') <> 'S' THEN
6590: IF l_debug_level > 0 THEN
6591: oe_debug_pub.add( ' ERROR IN CALL TO get_supply_sources_local');
6592: END IF;
6593: fnd_message.set_name('MSC', x_err_mesg);
6594: oe_msg_pub.add;
6595:
6596: ELSE
6597:

Line 6651: FND_MESSAGE.SET_NAME('MSC','MRP_ATP_NO_SOURCES');

6647: oe_debug_pub.add( ' THERE ARE NO SOURCES TO BE DISPLAYED ' ) ;
6648: END IF;
6649: x_return_status := 'E';
6650: x_error_mesg := 'MRP_ATP_NO_SOURCES';
6651: FND_MESSAGE.SET_NAME('MSC','MRP_ATP_NO_SOURCES');
6652: OE_MSG_PUB.Add;
6653: x_return_status := 'E';
6654:
6655: END IF; -- IF x_sources.organization_id.COUNT > 0