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 3703: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

3699: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3700: IF l_debug_level > 0 THEN
3701: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
3702: END IF;
3703: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3704: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
3705: OE_MSG_PUB.Add;
3706: RAISE FND_API.G_EXC_ERROR;
3707: END IF;

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

3700: IF l_debug_level > 0 THEN
3701: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
3702: END IF;
3703: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3704: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
3705: OE_MSG_PUB.Add;
3706: RAISE FND_API.G_EXC_ERROR;
3707: END IF;
3708:

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

3744: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3745: IF l_debug_level > 0 THEN
3746: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
3747: END IF;
3748: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3749: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
3750: OE_MSG_PUB.Add;
3751: raise fnd_api.g_exc_unexpected_error;
3752: END IF;

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

3745: IF l_debug_level > 0 THEN
3746: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
3747: END IF;
3748: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
3749: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
3750: OE_MSG_PUB.Add;
3751: raise fnd_api.g_exc_unexpected_error;
3752: END IF;
3753:

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

5272: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_panda_rec_table(1).p_PRICE_LIST_ID ) ;
5273: END IF;
5274: IF g_panda_rec_table(1).p_price_list_id is null then
5275:
5276: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
5277: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);
5278: IF l_debug_level > 0 THEN
5279: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;
5280: END IF;

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

5273: END IF;
5274: IF g_panda_rec_table(1).p_price_list_id is null then
5275:
5276: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
5277: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);
5278: IF l_debug_level > 0 THEN
5279: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;
5280: END IF;
5281: OE_MSG_PUB.Add;

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

5283: ELSE
5284: IF l_debug_level > 0 THEN
5285: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
5286: END IF;
5287: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
5288: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5289: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
5290: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
5291: OE_MSG_PUB.Add;

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

5284: IF l_debug_level > 0 THEN
5285: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
5286: END IF;
5287: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
5288: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5289: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
5290: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
5291: OE_MSG_PUB.Add;
5292:

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

5285: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
5286: END IF;
5287: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
5288: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5289: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
5290: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
5291: OE_MSG_PUB.Add;
5292:
5293: END IF;

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

5286: END IF;
5287: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
5288: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5289: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);
5290: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
5291: OE_MSG_PUB.Add;
5292:
5293: END IF;
5294:

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

5293: END IF;
5294:
5295: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
5296:
5297: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
5298: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5299: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5300: OE_MSG_PUB.Add;
5301:

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

5294:
5295: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
5296:
5297: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
5298: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5299: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5300: OE_MSG_PUB.Add;
5301:
5302: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then

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

5295: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
5296:
5297: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
5298: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5299: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5300: OE_MSG_PUB.Add;
5301:
5302: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
5303: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');

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

5299: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5300: OE_MSG_PUB.Add;
5301:
5302: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
5303: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
5304: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text); --3730467
5305: OE_MSG_PUB.Add;
5306:
5307:

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

5300: OE_MSG_PUB.Add;
5301:
5302: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
5303: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
5304: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text); --3730467
5305: OE_MSG_PUB.Add;
5306:
5307:
5308: ELSIF in_status_code in

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

5307:
5308: ELSIF in_status_code in
5309: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
5310: FND_API.G_RET_STS_ERROR) then
5311: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5312: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5313: OE_MSG_PUB.Add;
5314:
5315: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then

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

5308: ELSIF in_status_code in
5309: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
5310: FND_API.G_RET_STS_ERROR) then
5311: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5312: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5313: OE_MSG_PUB.Add;
5314:
5315: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
5316: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');

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

5312: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5313: OE_MSG_PUB.Add;
5314:
5315: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
5316: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
5317: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5318: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5319: OE_MSG_PUB.Add;
5320:

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

5313: OE_MSG_PUB.Add;
5314:
5315: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
5316: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
5317: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5318: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5319: OE_MSG_PUB.Add;
5320:
5321: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then

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

5314:
5315: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
5316: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
5317: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5318: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5319: OE_MSG_PUB.Add;
5320:
5321: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
5322: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');

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

5318: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
5319: OE_MSG_PUB.Add;
5320:
5321: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
5322: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
5323:
5324: IF l_debug_level > 0 THEN
5325: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
5326: END IF;

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

5340:
5341: IF l_debug_level > 0 THEN
5342: oe_debug_pub.add( 'PRICE LIST 1='||L_PRICE_LIST ) ;
5343: END IF;
5344: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
5345: Begin
5346: Select name into l_price_list
5347: from qp_list_headers_vl a,qp_list_lines b where
5348: b.list_line_id = to_number(substr(in_status_text,

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

5358: IF l_debug_level > 0 THEN
5359: oe_debug_pub.add( 'PRICE LIST 2='||L_PRICE_LIST ) ;
5360: END IF;
5361:
5362: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
5363: OE_MSG_PUB.Add;
5364:
5365: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
5366: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');

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

5362: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
5363: OE_MSG_PUB.Add;
5364:
5365: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
5366: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
5367: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
5368: in_status_text);
5369: OE_MSG_PUB.Add;
5370:

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

5363: OE_MSG_PUB.Add;
5364:
5365: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
5366: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
5367: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
5368: in_status_text);
5369: OE_MSG_PUB.Add;
5370:
5371: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then

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

5368: in_status_text);
5369: OE_MSG_PUB.Add;
5370:
5371: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
5372: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
5373: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
5374: in_status_text);
5375: OE_MSG_PUB.Add;
5376:

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

5369: OE_MSG_PUB.Add;
5370:
5371: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
5372: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
5373: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
5374: in_status_text);
5375: OE_MSG_PUB.Add;
5376:
5377: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then

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

5374: in_status_text);
5375: OE_MSG_PUB.Add;
5376:
5377: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
5378: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
5379: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5380: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5381: OE_MSG_PUB.Add;
5382: END IF;

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

5375: OE_MSG_PUB.Add;
5376:
5377: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
5378: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
5379: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5380: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5381: OE_MSG_PUB.Add;
5382: END IF;
5383:

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

5376:
5377: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
5378: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
5379: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
5380: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5381: OE_MSG_PUB.Add;
5382: END IF;
5383:
5384:

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

5388:
5389: IF l_debug_level > 0 THEN
5390: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
5391: END IF;
5392: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
5393: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
5394: OE_MSG_PUB.Add;
5395:
5396: ELSIF in_line_Type_code ='LINE' and in_status_code in

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

5389: IF l_debug_level > 0 THEN
5390: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
5391: END IF;
5392: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
5393: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
5394: OE_MSG_PUB.Add;
5395:
5396: ELSIF in_line_Type_code ='LINE' and in_status_code in
5397: --( QP_PREQ_GRP.G_STATUS_UPDATED,

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

5416: l_return_status := 'E';
5417: END IF;
5418: --Bug 7409782 ends
5419:
5420: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5421: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5422: OE_MSG_PUB.Add;
5423: END IF;
5424:

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

5417: END IF;
5418: --Bug 7409782 ends
5419:
5420: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5421: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
5422: OE_MSG_PUB.Add;
5423: END IF;
5424:
5425: -- we need to do this check in UPDATED code or do the gsa check through

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

5451: End;
5452:
5453: l_return_status := 'E';
5454: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);
5455: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
5456: l_msg_text := l_operand||' ( '||l_msg_text||' )';
5457: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
5458: OE_MSG_PUB.Add;
5459: END IF;

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

5453: l_return_status := 'E';
5454: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);
5455: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
5456: l_msg_text := l_operand||' ( '||l_msg_text||' )';
5457: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
5458: OE_MSG_PUB.Add;
5459: END IF;
5460: END IF; */
5461:

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

6458: IF l_debug_level > 0 THEN
6459: oe_debug_pub.add( 'MSG DATA IS NOT NULL' ) ;
6460: END IF;
6461: x_return_status := 'E';
6462: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
6463: IF l_debug_level > 0 THEN
6464: oe_debug_pub.add( 'MSG DATA IS NOT NULL 2' ) ;
6465: END IF;
6466: FND_MESSAGE.SET_TOKEN('TEXT',x_msg_data);

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

6462: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
6463: IF l_debug_level > 0 THEN
6464: oe_debug_pub.add( 'MSG DATA IS NOT NULL 2' ) ;
6465: END IF;
6466: FND_MESSAGE.SET_TOKEN('TEXT',x_msg_data);
6467: OE_MSG_PUB.Add;
6468:
6469: END IF;
6470:

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

6533: using l_instance_id,in_inventory_item_id,l_org_id;
6534:
6535:
6536: IF x_plan_id is null then
6537: fnd_message.set_name('MSC', 'MSC_NO_PLANS_DEFINED');
6538: oe_msg_pub.add;
6539: x_return_status := 'E';
6540: oe_debug_pub.add('Plan Id NOT FOUND');
6541: END IF;

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

6614: IF nvl(x_return_status,'S') <> 'S' THEN
6615: IF l_debug_level > 0 THEN
6616: oe_debug_pub.add( ' ERROR IN CALL TO get_supply_sources_local');
6617: END IF;
6618: fnd_message.set_name('MSC', x_err_mesg);
6619: oe_msg_pub.add;
6620:
6621: ELSE
6622:

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

6672: oe_debug_pub.add( ' THERE ARE NO SOURCES TO BE DISPLAYED ' ) ;
6673: END IF;
6674: x_return_status := 'E';
6675: x_error_mesg := 'MRP_ATP_NO_SOURCES';
6676: FND_MESSAGE.SET_NAME('MSC','MRP_ATP_NO_SOURCES');
6677: OE_MSG_PUB.Add;
6678: x_return_status := 'E';
6679:
6680: END IF; -- IF x_sources.organization_id.COUNT > 0