DBA Data[Home] [Help]

APPS.OE_ORDER_PRICE_PVT dependencies on FND_MESSAGE

Line 1831: FND_MESSAGE.SET_NAME('ONT', 'ONT_CONV_INFO_NEEDED');

1827: (nvl(oe_order_pub.g_hdr.transactional_curr_code,'XXX') <> nvl(l_set_of_books.currency_code,'XXX') AND
1828: (oe_order_pub.g_hdr.conversion_type_code IS NULL OR
1829: (oe_order_pub.g_hdr.conversion_type_code= 'User' AND
1830: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN
1831: FND_MESSAGE.SET_NAME('ONT', 'ONT_CONV_INFO_NEEDED');
1832: FND_MESSAGE.SET_TOKEN('SERVICE_CURR', oe_order_pub.g_hdr.transactional_curr_code);
1833: FND_MESSAGE.SET_TOKEN('PARENT_CURR',l_transactional_curr_code);
1834: FND_MESSAGE.SET_TOKEN('FUNC_CURR', l_set_of_books.currency_code);
1835: OE_MSG_PUB.Add;

Line 1832: FND_MESSAGE.SET_TOKEN('SERVICE_CURR', oe_order_pub.g_hdr.transactional_curr_code);

1828: (oe_order_pub.g_hdr.conversion_type_code IS NULL OR
1829: (oe_order_pub.g_hdr.conversion_type_code= 'User' AND
1830: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN
1831: FND_MESSAGE.SET_NAME('ONT', 'ONT_CONV_INFO_NEEDED');
1832: FND_MESSAGE.SET_TOKEN('SERVICE_CURR', oe_order_pub.g_hdr.transactional_curr_code);
1833: FND_MESSAGE.SET_TOKEN('PARENT_CURR',l_transactional_curr_code);
1834: FND_MESSAGE.SET_TOKEN('FUNC_CURR', l_set_of_books.currency_code);
1835: OE_MSG_PUB.Add;
1836: px_Line_Tbl(line_Tbl_index).unit_list_price := null;

Line 1833: FND_MESSAGE.SET_TOKEN('PARENT_CURR',l_transactional_curr_code);

1829: (oe_order_pub.g_hdr.conversion_type_code= 'User' AND
1830: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN
1831: FND_MESSAGE.SET_NAME('ONT', 'ONT_CONV_INFO_NEEDED');
1832: FND_MESSAGE.SET_TOKEN('SERVICE_CURR', oe_order_pub.g_hdr.transactional_curr_code);
1833: FND_MESSAGE.SET_TOKEN('PARENT_CURR',l_transactional_curr_code);
1834: FND_MESSAGE.SET_TOKEN('FUNC_CURR', l_set_of_books.currency_code);
1835: OE_MSG_PUB.Add;
1836: px_Line_Tbl(line_Tbl_index).unit_list_price := null;
1837: px_Line_Tbl(line_Tbl_index).unit_list_price_per_pqty := null;

Line 1834: FND_MESSAGE.SET_TOKEN('FUNC_CURR', l_set_of_books.currency_code);

1830: oe_order_pub.g_hdr.conversion_rate IS NULL))) THEN
1831: FND_MESSAGE.SET_NAME('ONT', 'ONT_CONV_INFO_NEEDED');
1832: FND_MESSAGE.SET_TOKEN('SERVICE_CURR', oe_order_pub.g_hdr.transactional_curr_code);
1833: FND_MESSAGE.SET_TOKEN('PARENT_CURR',l_transactional_curr_code);
1834: FND_MESSAGE.SET_TOKEN('FUNC_CURR', l_set_of_books.currency_code);
1835: OE_MSG_PUB.Add;
1836: px_Line_Tbl(line_Tbl_index).unit_list_price := null;
1837: px_Line_Tbl(line_Tbl_index).unit_list_price_per_pqty := null;
1838: ELSE

Line 2653: /* FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');

2649: END IF;
2650: l_mod_lineid := MOD(i.line_id,2147483647) ;
2651: IF l_gsa_violation_action = 'WARNING' THEN
2652:
2653: /* FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
2654: l_msg_text := i.pricing_status_text||' ( '||nvl(i.ordered_item,i.inventory_item_id)||' )';
2655: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
2656: OE_MSG_PUB.Add;*/
2657: --3021992

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

2651: IF l_gsa_violation_action = 'WARNING' THEN
2652:
2653: /* FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
2654: l_msg_text := i.pricing_status_text||' ( '||nvl(i.ordered_item,i.inventory_item_id)||' )';
2655: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
2656: OE_MSG_PUB.Add;*/
2657: --3021992
2658: IF not(g_lineid_tbl.EXISTS(l_mod_lineid)) THEN
2659: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');

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

2655: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
2656: OE_MSG_PUB.Add;*/
2657: --3021992
2658: IF not(g_lineid_tbl.EXISTS(l_mod_lineid)) THEN
2659: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
2660: l_line_num := OE_ORDER_MISC_PUB.get_concat_line_number(i.line_id);
2661: l_msg_text := nvl(i.ordered_item,i.inventory_item_id);
2662: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_num);
2663: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_msg_text);

Line 2662: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_num);

2658: IF not(g_lineid_tbl.EXISTS(l_mod_lineid)) THEN
2659: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
2660: l_line_num := OE_ORDER_MISC_PUB.get_concat_line_number(i.line_id);
2661: l_msg_text := nvl(i.ordered_item,i.inventory_item_id);
2662: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_num);
2663: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_msg_text);
2664: FND_MESSAGE.SET_TOKEN('GSA_PRICE',i.pricing_status_text);
2665: OE_MSG_PUB.Add;
2666: END IF ;

Line 2663: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_msg_text);

2659: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
2660: l_line_num := OE_ORDER_MISC_PUB.get_concat_line_number(i.line_id);
2661: l_msg_text := nvl(i.ordered_item,i.inventory_item_id);
2662: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_num);
2663: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_msg_text);
2664: FND_MESSAGE.SET_TOKEN('GSA_PRICE',i.pricing_status_text);
2665: OE_MSG_PUB.Add;
2666: END IF ;
2667: g_lineid_tbl(l_mod_lineid) := i.line_id ;

Line 2664: FND_MESSAGE.SET_TOKEN('GSA_PRICE',i.pricing_status_text);

2660: l_line_num := OE_ORDER_MISC_PUB.get_concat_line_number(i.line_id);
2661: l_msg_text := nvl(i.ordered_item,i.inventory_item_id);
2662: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_num);
2663: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_msg_text);
2664: FND_MESSAGE.SET_TOKEN('GSA_PRICE',i.pricing_status_text);
2665: OE_MSG_PUB.Add;
2666: END IF ;
2667: g_lineid_tbl(l_mod_lineid) := i.line_id ;
2668: --3021992 ends

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

2673: l_hold_source_rec.hold_id := G_SEEDED_GSA_HOLD_ID;
2674:
2675: If i.line_id is null or
2676: i.line_id = fnd_api.g_miss_num then
2677: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
2678: FND_MESSAGE.SET_TOKEN('ERR_TEXT','GSA_INVALID_LINE_ID');
2679: OE_MSG_PUB.Add;
2680: RAISE FND_API.G_EXC_ERROR;
2681: End if;

Line 2678: FND_MESSAGE.SET_TOKEN('ERR_TEXT','GSA_INVALID_LINE_ID');

2674:
2675: If i.line_id is null or
2676: i.line_id = fnd_api.g_miss_num then
2677: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
2678: FND_MESSAGE.SET_TOKEN('ERR_TEXT','GSA_INVALID_LINE_ID');
2679: OE_MSG_PUB.Add;
2680: RAISE FND_API.G_EXC_ERROR;
2681: End if;
2682:

Line 2739: /*FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');

2735: );
2736:
2737: If l_return_status = FND_API.g_ret_sts_success then
2738:
2739: /*FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');
2740: OE_MSG_PUB.Add;*/
2741: --3021992
2742: if not(g_lineid_tbl.EXISTS(l_mod_lineid)) THEN
2743: FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');

Line 2743: FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');

2739: /*FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');
2740: OE_MSG_PUB.Add;*/
2741: --3021992
2742: if not(g_lineid_tbl.EXISTS(l_mod_lineid)) THEN
2743: FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');
2744: OE_MSG_PUB.Add;
2745: END IF;
2746: g_lineid_tbl(l_mod_lineid) := i.line_id;
2747: --3021992 ends

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

2746: g_lineid_tbl(l_mod_lineid) := i.line_id;
2747: --3021992 ends
2748:
2749: Else
2750: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
2751: FND_MESSAGE.SET_TOKEN('ERR_TEXT','APPLY_GSA_HOLD');
2752: OE_MSG_PUB.Add;
2753: RAISE FND_API.G_EXC_ERROR;
2754: End If;

Line 2751: FND_MESSAGE.SET_TOKEN('ERR_TEXT','APPLY_GSA_HOLD');

2747: --3021992 ends
2748:
2749: Else
2750: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
2751: FND_MESSAGE.SET_TOKEN('ERR_TEXT','APPLY_GSA_HOLD');
2752: OE_MSG_PUB.Add;
2753: RAISE FND_API.G_EXC_ERROR;
2754: End If;
2755: End If; /* check hold */

Line 3822: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');

3818: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3819: IF l_debug_level > 0 THEN
3820: oe_debug_pub.add('in lock record exception, someone else working on the row');
3821: END IF;
3822: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
3823: OE_MSG_PUB.Add;
3824: RAISE FND_API.G_EXC_ERROR;
3825:
3826: WHEN NO_DATA_FOUND THEN

Line 5543: FND_MESSAGE.SET_NAME('ONT','ONT_CATCHWEIGHT_QTY2_REQUIRED');

5539: ELSE /*<< raise error here if shipped_quantity exists but not shipped_quantity2>> -- This error should not be raised for returns and dropship orders. */
5540: IF l_debug_level > 0 THEN
5541: oe_debug_pub.add('Shipped_quantity2 is null and not dropship, return- Raise error');
5542: END IF;
5543: FND_MESSAGE.SET_NAME('ONT','ONT_CATCHWEIGHT_QTY2_REQUIRED');
5544: OE_MSG_PUB.Add;
5545: RAISE FND_API.G_EXC_ERROR;
5546: END IF; -- end checks for source_type_code
5547: END IF; -- end checks for shipped_quantity2

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

5716: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5717: IF l_debug_level > 0 THEN
5718: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
5719: END IF;
5720: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5721: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
5722: OE_MSG_PUB.Add;
5723: RAISE FND_API.G_EXC_ERROR;
5724: END IF;

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

5717: IF l_debug_level > 0 THEN
5718: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
5719: END IF;
5720: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5721: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
5722: OE_MSG_PUB.Add;
5723: RAISE FND_API.G_EXC_ERROR;
5724: END IF;
5725:

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

5761: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5762: IF l_debug_level > 0 THEN
5763: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
5764: END IF;
5765: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5766: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
5767: OE_MSG_PUB.Add;
5768: raise fnd_api.g_exc_unexpected_error;
5769: END IF;

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

5762: IF l_debug_level > 0 THEN
5763: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
5764: END IF;
5765: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
5766: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
5767: OE_MSG_PUB.Add;
5768: raise fnd_api.g_exc_unexpected_error;
5769: END IF;
5770:

Line 5990: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');

5986:
5987: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5988: THEN
5989:
5990: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
5991: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id or Header Id ');
5992: OE_MSG_PUB.Add;
5993: END IF;
5994: RAISE FND_API.G_EXC_ERROR;

Line 5991: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id or Header Id ');

5987: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5988: THEN
5989:
5990: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
5991: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id or Header Id ');
5992: OE_MSG_PUB.Add;
5993: END IF;
5994: RAISE FND_API.G_EXC_ERROR;
5995: end if;

Line 6204: fnd_message.set_name('ONT','ONT_INVALID_AGR_REVISION');

6200: Exception
6201: When no_data_found then
6202: null;
6203: End;
6204: fnd_message.set_name('ONT','ONT_INVALID_AGR_REVISION');
6205: fnd_message.set_TOKEN('AGREEMENT',l_agreement_name||' : '||l_revision);
6206: fnd_message.set_TOKEN('PRICING_DATE',l_line_tbl(line_Tbl_Index).PRICING_DATE);
6207: OE_MSG_PUB.Add;
6208: RAISE FND_API.G_EXC_ERROR;

Line 6205: fnd_message.set_TOKEN('AGREEMENT',l_agreement_name||' : '||l_revision);

6201: When no_data_found then
6202: null;
6203: End;
6204: fnd_message.set_name('ONT','ONT_INVALID_AGR_REVISION');
6205: fnd_message.set_TOKEN('AGREEMENT',l_agreement_name||' : '||l_revision);
6206: fnd_message.set_TOKEN('PRICING_DATE',l_line_tbl(line_Tbl_Index).PRICING_DATE);
6207: OE_MSG_PUB.Add;
6208: RAISE FND_API.G_EXC_ERROR;
6209: END;

Line 6206: fnd_message.set_TOKEN('PRICING_DATE',l_line_tbl(line_Tbl_Index).PRICING_DATE);

6202: null;
6203: End;
6204: fnd_message.set_name('ONT','ONT_INVALID_AGR_REVISION');
6205: fnd_message.set_TOKEN('AGREEMENT',l_agreement_name||' : '||l_revision);
6206: fnd_message.set_TOKEN('PRICING_DATE',l_line_tbl(line_Tbl_Index).PRICING_DATE);
6207: OE_MSG_PUB.Add;
6208: RAISE FND_API.G_EXC_ERROR;
6209: END;
6210: End If;

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

6746: ,x_return_status_Text =>l_return_status_Text
6747: );
6748:
6749: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6750: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
6751: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
6752: OE_MSG_PUB.Add;
6753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6754: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

6747: );
6748:
6749: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6750: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
6751: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
6752: OE_MSG_PUB.Add;
6753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6754: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6755: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

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

6751: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
6752: OE_MSG_PUB.Add;
6753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6754: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6755: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
6756: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
6757: OE_MSG_PUB.Add;
6758: RAISE FND_API.G_EXC_ERROR;
6759: END IF;

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

6752: OE_MSG_PUB.Add;
6753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6754: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
6755: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
6756: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
6757: OE_MSG_PUB.Add;
6758: RAISE FND_API.G_EXC_ERROR;
6759: END IF;
6760:

Line 6828: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR_HOLD');

6824: IF l_debug_level > 0 THEN
6825: oe_debug_pub.add('just before showing formula error',1);
6826: END IF;
6827:
6828: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR_HOLD');
6829: FND_MESSAGE.SET_TOKEN('ERR_TEXT',pmsg);
6830: OE_MSG_PUB.Add;
6831: End if;
6832: exception

Line 6829: FND_MESSAGE.SET_TOKEN('ERR_TEXT',pmsg);

6825: oe_debug_pub.add('just before showing formula error',1);
6826: END IF;
6827:
6828: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR_HOLD');
6829: FND_MESSAGE.SET_TOKEN('ERR_TEXT',pmsg);
6830: OE_MSG_PUB.Add;
6831: End if;
6832: exception
6833: WHEN FND_API.G_EXC_ERROR then

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

7012: END IF;
7013: IF l_debug_level > 0 THEN
7014: oe_debug_pub.add( 'INVALID PRICE LIST ' , 1 ) ;
7015: END IF;
7016: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
7017: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7018: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7019: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7020: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

Line 7017: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));

7013: IF l_debug_level > 0 THEN
7014: oe_debug_pub.add( 'INVALID PRICE LIST ' , 1 ) ;
7015: END IF;
7016: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
7017: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7018: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7019: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7020: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7021: vmsg := FND_MESSAGE.GET;

Line 7018: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);

7014: oe_debug_pub.add( 'INVALID PRICE LIST ' , 1 ) ;
7015: END IF;
7016: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
7017: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7018: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7019: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7020: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7021: vmsg := FND_MESSAGE.GET;
7022: else

Line 7021: vmsg := FND_MESSAGE.GET;

7017: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7018: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7019: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7020: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7021: vmsg := FND_MESSAGE.GET;
7022: else
7023: OE_MSG_PUB.Add;
7024: end if;
7025: ELSE

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

7065: and
7066: G_IPL_ERRORS_TBL(MOD(l_line_rec.line_id,G_BINARY_LIMIT))<>l_line_rec.price_list_id)
7067: Then
7068:
7069: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
7070: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7071: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
7072: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
7073: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN

Line 7070: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));

7066: G_IPL_ERRORS_TBL(MOD(l_line_rec.line_id,G_BINARY_LIMIT))<>l_line_rec.price_list_id)
7067: Then
7068:
7069: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
7070: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7071: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
7072: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
7073: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7074: IF l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

Line 7071: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);

7067: Then
7068:
7069: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
7070: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7071: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
7072: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
7073: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7074: IF l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7075: vmsg := FND_MESSAGE.GET;

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

7068:
7069: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
7070: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7071: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
7072: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
7073: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7074: IF l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7075: vmsg := FND_MESSAGE.GET;
7076: ELSE

Line 7075: vmsg := FND_MESSAGE.GET;

7071: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
7072: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
7073: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7074: IF l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7075: vmsg := FND_MESSAGE.GET;
7076: ELSE
7077: OE_MSG_PUB.Add;
7078: END IF;
7079: ELSE

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

7094: If nvl(l_line_rec.booked_flag,'X') = 'Y' Then
7095: IF l_debug_level > 0 THEN
7096: oe_debug_pub.add( ' EXCEPTION: PRICE LIST MISSING FOR BOOKED ORDER' ) ;
7097: END IF;
7098: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
7099: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.GET_ATTRIBUTE_NAME('UNIT_LIST_PRICE'));
7100: OE_MSG_PUB.ADD;
7101: RAISE FND_API.G_EXC_ERROR;
7102: End If;

Line 7099: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.GET_ATTRIBUTE_NAME('UNIT_LIST_PRICE'));

7095: IF l_debug_level > 0 THEN
7096: oe_debug_pub.add( ' EXCEPTION: PRICE LIST MISSING FOR BOOKED ORDER' ) ;
7097: END IF;
7098: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
7099: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.GET_ATTRIBUTE_NAME('UNIT_LIST_PRICE'));
7100: OE_MSG_PUB.ADD;
7101: RAISE FND_API.G_EXC_ERROR;
7102: End If;
7103: IF l_debug_level > 0 THEN

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

7121: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
7122: IF l_debug_level > 0 THEN
7123: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
7124: END IF;
7125: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
7126: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7127: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7128: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7129: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

Line 7126: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));

7122: IF l_debug_level > 0 THEN
7123: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
7124: END IF;
7125: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
7126: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7127: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7128: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7129: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7130: vmsg := FND_MESSAGE.GET;

Line 7127: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);

7123: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
7124: END IF;
7125: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
7126: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7127: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7128: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7129: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7130: vmsg := FND_MESSAGE.GET;
7131: else

Line 7130: vmsg := FND_MESSAGE.GET;

7126: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7127: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7128: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7129: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7130: vmsg := FND_MESSAGE.GET;
7131: else
7132: OE_MSG_PUB.Add;
7133: end if;
7134: else

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

7137: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
7138: IF l_debug_level > 0 THEN
7139: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;
7140: END IF;
7141: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
7142: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text||','||get_formula(wrong_line.line_index));
7143: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7144: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7145: vmsg := FND_MESSAGE.GET;

Line 7142: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text||','||get_formula(wrong_line.line_index));

7138: IF l_debug_level > 0 THEN
7139: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;
7140: END IF;
7141: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
7142: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text||','||get_formula(wrong_line.line_index));
7143: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7144: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7145: vmsg := FND_MESSAGE.GET;
7146: else

Line 7145: vmsg := FND_MESSAGE.GET;

7141: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
7142: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text||','||get_formula(wrong_line.line_index));
7143: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7144: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7145: vmsg := FND_MESSAGE.GET;
7146: else
7147: OE_MSG_PUB.Add;
7148: end if;
7149: else

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

7155: then
7156: IF l_debug_level > 0 THEN
7157: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
7158: END IF;
7159: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7160: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
7161: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7162: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7163: vmsg := FND_MESSAGE.GET;

Line 7160: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);

7156: IF l_debug_level > 0 THEN
7157: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
7158: END IF;
7159: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7160: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
7161: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7162: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7163: vmsg := FND_MESSAGE.GET;
7164: else

Line 7163: vmsg := FND_MESSAGE.GET;

7159: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7160: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
7161: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7162: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7163: vmsg := FND_MESSAGE.GET;
7164: else
7165: OE_MSG_PUB.Add;
7166: end if;
7167: else

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

7170: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
7171: IF l_debug_level > 0 THEN
7172: oe_debug_pub.add( 'INVALID UOM' ) ;
7173: END IF;
7174: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
7175: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7176: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7177: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7178: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

Line 7175: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));

7171: IF l_debug_level > 0 THEN
7172: oe_debug_pub.add( 'INVALID UOM' ) ;
7173: END IF;
7174: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
7175: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7176: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7177: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7178: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7179: vmsg := FND_MESSAGE.GET;

Line 7176: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);

7172: oe_debug_pub.add( 'INVALID UOM' ) ;
7173: END IF;
7174: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
7175: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7176: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7177: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7178: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7179: vmsg := FND_MESSAGE.GET;
7180: else

Line 7179: vmsg := FND_MESSAGE.GET;

7175: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7176: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
7177: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7178: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7179: vmsg := FND_MESSAGE.GET;
7180: else
7181: OE_MSG_PUB.Add;
7182: end if;
7183: else

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

7186: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
7187: IF l_debug_level > 0 THEN
7188: oe_debug_pub.add( 'DUPLICATE PRICE LIST' ) ;
7189: END IF;
7190: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
7191:
7192: Begin
7193: Select name into l_price_list
7194: from qp_list_headers_vl a,qp_list_lines b where

Line 7208: FND_MESSAGE.SET_TOKEN('PRICE_LIST1',

7204: instr(wrong_line.status_text,',')-1);
7205:
7206: End;
7207:
7208: FND_MESSAGE.SET_TOKEN('PRICE_LIST1',
7209: '( '||l_line_rec.Ordered_Item||' ) '||l_price_list);
7210: Begin
7211: Select name into l_price_list
7212: from qp_list_headers_vl a,qp_list_lines b where

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

7220: When invalid_number then
7221: l_price_list := substr(wrong_line.status_text,
7222: instr(wrong_line.status_text,',')+1);
7223: End;
7224: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
7225: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7226: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7227: vmsg := FND_MESSAGE.GET;
7228: else

Line 7227: vmsg := FND_MESSAGE.GET;

7223: End;
7224: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
7225: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7226: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7227: vmsg := FND_MESSAGE.GET;
7228: else
7229: OE_MSG_PUB.Add;
7230: end if;
7231: else

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

7234: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
7235: IF l_debug_level > 0 THEN
7236: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;
7237: END IF;
7238: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
7239: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
7240: wrong_line.status_text);
7241: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7242: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

Line 7239: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||

7235: IF l_debug_level > 0 THEN
7236: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;
7237: END IF;
7238: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
7239: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
7240: wrong_line.status_text);
7241: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7242: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7243: vmsg := FND_MESSAGE.GET;

Line 7243: vmsg := FND_MESSAGE.GET;

7239: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
7240: wrong_line.status_text);
7241: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7242: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7243: vmsg := FND_MESSAGE.GET;
7244: else
7245: OE_MSG_PUB.Add;
7246: end if;
7247: else

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

7250: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
7251: IF l_debug_level > 0 THEN
7252: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;
7253: END IF;
7254: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
7255: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||
7256: l_line_rec.Ordered_Item||' ) '||wrong_line.status_text);
7257: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7258: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

Line 7255: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||

7251: IF l_debug_level > 0 THEN
7252: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;
7253: END IF;
7254: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
7255: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||
7256: l_line_rec.Ordered_Item||' ) '||wrong_line.status_text);
7257: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7258: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7259: vmsg := FND_MESSAGE.GET;

Line 7259: vmsg := FND_MESSAGE.GET;

7255: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||
7256: l_line_rec.Ordered_Item||' ) '||wrong_line.status_text);
7257: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7258: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7259: vmsg := FND_MESSAGE.GET;
7260: else
7261: OE_MSG_PUB.Add;
7262: end if;
7263: else

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

7266: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
7267: IF l_debug_level > 0 THEN
7268: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;
7269: END IF;
7270: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
7271: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7272: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
7273: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7274: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then

Line 7271: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));

7267: IF l_debug_level > 0 THEN
7268: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;
7269: END IF;
7270: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
7271: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7272: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
7273: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7274: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7275: vmsg := FND_MESSAGE.GET;

Line 7272: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);

7268: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;
7269: END IF;
7270: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
7271: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7272: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
7273: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7274: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7275: vmsg := FND_MESSAGE.GET;
7276: else

Line 7275: vmsg := FND_MESSAGE.GET;

7271: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7272: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
7273: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7274: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7275: vmsg := FND_MESSAGE.GET;
7276: else
7277: OE_MSG_PUB.Add;
7278: end if;
7279: else

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

7319: wrong_line.line_Type_code ='LINE' and
7320: wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
7321: Then
7322:
7323: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
7324: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '
7325: ||l_line_rec.Ordered_Item||' ) '||wrong_line.status_text);
7326: OE_MSG_PUB.Add;
7327: elsif wrong_line.line_type_code='LINE' and

Line 7324: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '

7320: wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
7321: Then
7322:
7323: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
7324: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '
7325: ||l_line_rec.Ordered_Item||' ) '||wrong_line.status_text);
7326: OE_MSG_PUB.Add;
7327: elsif wrong_line.line_type_code='LINE' and
7328: (wrong_line.unit_price <0 or wrong_line.adjusted_unit_price<0)

Line 7334: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');

7330:
7331: IF l_debug_level > 0 THEN
7332: oe_debug_pub.add( 'NEGATIVE LIST PRICE '||WRONG_LINE.UNIT_PRICE ||'OR SELLING PRICE '||WRONG_LINE.ADJUSTED_UNIT_PRICE ) ;
7333: END IF;
7334: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
7335: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7336: FND_MESSAGE.SET_TOKEN('LIST_PRICE',wrong_line.unit_price);
7337: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',wrong_line.Adjusted_unit_price);
7338: OE_MSG_PUB.Add;

Line 7335: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));

7331: IF l_debug_level > 0 THEN
7332: oe_debug_pub.add( 'NEGATIVE LIST PRICE '||WRONG_LINE.UNIT_PRICE ||'OR SELLING PRICE '||WRONG_LINE.ADJUSTED_UNIT_PRICE ) ;
7333: END IF;
7334: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
7335: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7336: FND_MESSAGE.SET_TOKEN('LIST_PRICE',wrong_line.unit_price);
7337: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',wrong_line.Adjusted_unit_price);
7338: OE_MSG_PUB.Add;
7339: IF l_debug_level > 0 THEN

Line 7336: FND_MESSAGE.SET_TOKEN('LIST_PRICE',wrong_line.unit_price);

7332: oe_debug_pub.add( 'NEGATIVE LIST PRICE '||WRONG_LINE.UNIT_PRICE ||'OR SELLING PRICE '||WRONG_LINE.ADJUSTED_UNIT_PRICE ) ;
7333: END IF;
7334: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
7335: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7336: FND_MESSAGE.SET_TOKEN('LIST_PRICE',wrong_line.unit_price);
7337: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',wrong_line.Adjusted_unit_price);
7338: OE_MSG_PUB.Add;
7339: IF l_debug_level > 0 THEN
7340: oe_debug_pub.add( 'BEFORE SHOWING NEGATIVE MODIFIERS MESSAGE' ) ;

Line 7337: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',wrong_line.Adjusted_unit_price);

7333: END IF;
7334: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
7335: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7336: FND_MESSAGE.SET_TOKEN('LIST_PRICE',wrong_line.unit_price);
7337: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',wrong_line.Adjusted_unit_price);
7338: OE_MSG_PUB.Add;
7339: IF l_debug_level > 0 THEN
7340: oe_debug_pub.add( 'BEFORE SHOWING NEGATIVE MODIFIERS MESSAGE' ) ;
7341: END IF;

Line 7345: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');

7341: END IF;
7342: l_list_line_no:=get_list_lines(wrong_line.line_id);
7343:
7344: IF l_list_line_no IS NOT NULL THEN
7345: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
7346: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(wrong_line.line_id));
7347: OE_MSG_PUB.Add;
7348: END IF;
7349:

Line 7346: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(wrong_line.line_id));

7342: l_list_line_no:=get_list_lines(wrong_line.line_id);
7343:
7344: IF l_list_line_no IS NOT NULL THEN
7345: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
7346: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(wrong_line.line_id));
7347: OE_MSG_PUB.Add;
7348: END IF;
7349:
7350: IF l_debug_level > 0 THEN

Line 7356: vmsg := FND_MESSAGE.GET;

7352: END IF;
7353:
7354: --place the line on invoicing hold to avoid stuck order it the ship quatity is there.
7355: IF l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM THEN
7356: vmsg := FND_MESSAGE.GET;
7357: oe_debug_pub.add('vmsg = '||vmsg,1);
7358: pricing_errors_hold(l_line_rec.header_id,l_line_rec.line_id,vmsg);
7359: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7360: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');

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

7374:
7375: IF wrong_line.line_type_code='ORDER' THEN
7376: if wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
7377: oe_debug_pub.add( 'ERROR IN ORDER LEVEL FORMULA PROCESSING' ) ;
7378: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
7379: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text||','||get_formula(wrong_line.line_index));
7380: OE_MSG_PUB.Add;
7381: vmsg := FND_MESSAGE.GET;
7382: else

Line 7379: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text||','||get_formula(wrong_line.line_index));

7375: IF wrong_line.line_type_code='ORDER' THEN
7376: if wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
7377: oe_debug_pub.add( 'ERROR IN ORDER LEVEL FORMULA PROCESSING' ) ;
7378: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
7379: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text||','||get_formula(wrong_line.line_index));
7380: OE_MSG_PUB.Add;
7381: vmsg := FND_MESSAGE.GET;
7382: else
7383: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;

Line 7381: vmsg := FND_MESSAGE.GET;

7377: oe_debug_pub.add( 'ERROR IN ORDER LEVEL FORMULA PROCESSING' ) ;
7378: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
7379: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text||','||get_formula(wrong_line.line_index));
7380: OE_MSG_PUB.Add;
7381: vmsg := FND_MESSAGE.GET;
7382: else
7383: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
7384: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7385: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);

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

7380: OE_MSG_PUB.Add;
7381: vmsg := FND_MESSAGE.GET;
7382: else
7383: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
7384: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7385: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
7386: OE_MSG_PUB.Add;
7387: vmsg := FND_MESSAGE.GET;
7388: end if;

Line 7385: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);

7381: vmsg := FND_MESSAGE.GET;
7382: else
7383: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
7384: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7385: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
7386: OE_MSG_PUB.Add;
7387: vmsg := FND_MESSAGE.GET;
7388: end if;
7389: END IF; --end if for 'ORDER' line_type_code

Line 7387: vmsg := FND_MESSAGE.GET;

7383: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
7384: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7385: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
7386: OE_MSG_PUB.Add;
7387: vmsg := FND_MESSAGE.GET;
7388: end if;
7389: END IF; --end if for 'ORDER' line_type_code
7390:
7391: If l_invalid_line = 'Y' Then

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

7454:
7455: For book_line in wrong_book_lines loop
7456:
7457: If book_line.adjusted_unit_price IS NULL Then
7458: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
7459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7460: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
7461: OE_MSG_PUB.ADD;
7462: End If;

Line 7459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

7455: For book_line in wrong_book_lines loop
7456:
7457: If book_line.adjusted_unit_price IS NULL Then
7458: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
7459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7460: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
7461: OE_MSG_PUB.ADD;
7462: End If;
7463:

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

7462: End If;
7463:
7464: If book_line.unit_price IS NULL
7465: Then
7466: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
7467: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7468: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
7469: IF l_debug_level > 0 THEN
7470: oe_debug_pub.add( ' ERROR: UNIT LIST PRICE CAN NOT BE NULL' ) ;

Line 7467: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

7463:
7464: If book_line.unit_price IS NULL
7465: Then
7466: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
7467: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7468: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
7469: IF l_debug_level > 0 THEN
7470: oe_debug_pub.add( ' ERROR: UNIT LIST PRICE CAN NOT BE NULL' ) ;
7471: END IF;

Line 7474: vmsg := FND_MESSAGE.GET;

7470: oe_debug_pub.add( ' ERROR: UNIT LIST PRICE CAN NOT BE NULL' ) ;
7471: END IF;
7472: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7473: if book_line.shipped_quantity is not null or book_line.shipped_quantity <> FND_API.G_MISS_NUM then
7474: vmsg := FND_MESSAGE.GET;
7475: pricing_errors_hold(book_line.header_id,book_line.line_id,vmsg);
7476: else
7477: OE_MSG_PUB.ADD;
7478: l_temp_line_rec.line_id := book_line.line_id;

Line 7490: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRUIBUTE');

7486: end if;
7487: End If;
7488:
7489: If book_line.price_list_header_id IS NULL Then
7490: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRUIBUTE');
7491: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
7492: OE_MSG_PUB.ADD;
7493: IF l_debug_level > 0 THEN
7494: oe_debug_pub.add( ' ERROR: PRICE LIST ID CAN NOT BE NULL' ) ;

Line 7491: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));

7487: End If;
7488:
7489: If book_line.price_list_header_id IS NULL Then
7490: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRUIBUTE');
7491: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
7492: OE_MSG_PUB.ADD;
7493: IF l_debug_level > 0 THEN
7494: oe_debug_pub.add( ' ERROR: PRICE LIST ID CAN NOT BE NULL' ) ;
7495: END IF;