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

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

5699:
5700: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5701: THEN
5702:
5703: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
5704: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id or Header Id ');
5705: OE_MSG_PUB.Add;
5706: END IF;
5707: RAISE FND_API.G_EXC_ERROR;

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

5700: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5701: THEN
5702:
5703: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
5704: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id or Header Id ');
5705: OE_MSG_PUB.Add;
5706: END IF;
5707: RAISE FND_API.G_EXC_ERROR;
5708: end if;

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

5895: Exception
5896: When no_data_found then
5897: null;
5898: End;
5899: fnd_message.set_name('ONT','ONT_INVALID_AGR_REVISION');
5900: fnd_message.set_TOKEN('AGREEMENT',l_agreement_name||' : '||l_revision);
5901: fnd_message.set_TOKEN('PRICING_DATE',l_line_tbl(line_Tbl_Index).PRICING_DATE);
5902: OE_MSG_PUB.Add;
5903: RAISE OE_AGREEMENT_ERROR;

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

5896: When no_data_found then
5897: null;
5898: End;
5899: fnd_message.set_name('ONT','ONT_INVALID_AGR_REVISION');
5900: fnd_message.set_TOKEN('AGREEMENT',l_agreement_name||' : '||l_revision);
5901: fnd_message.set_TOKEN('PRICING_DATE',l_line_tbl(line_Tbl_Index).PRICING_DATE);
5902: OE_MSG_PUB.Add;
5903: RAISE OE_AGREEMENT_ERROR;
5904: END;

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

5897: null;
5898: End;
5899: fnd_message.set_name('ONT','ONT_INVALID_AGR_REVISION');
5900: fnd_message.set_TOKEN('AGREEMENT',l_agreement_name||' : '||l_revision);
5901: fnd_message.set_TOKEN('PRICING_DATE',l_line_tbl(line_Tbl_Index).PRICING_DATE);
5902: OE_MSG_PUB.Add;
5903: RAISE OE_AGREEMENT_ERROR;
5904: END;
5905: End If;

Line 6124: -- FND_MESSAGE.SET_NAME('ONT','ONT_LINE_FROZEN');

6120: END IF;
6121:
6122:
6123: If Not l_message_displayed Then
6124: -- FND_MESSAGE.SET_NAME('ONT','ONT_LINE_FROZEN');
6125: --need to a method to display message as hint in the future
6126: l_message_displayed := TRUE;
6127: End If;
6128: l_any_frozen_line:=FALSE;

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

6376: EXCEPTION
6377:
6378: WHEN FND_API.G_EXC_ERROR THEN
6379:
6380: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6381: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
6382: OE_MSG_PUB.Add;
6383: x_return_status := FND_API.G_RET_STS_ERROR;
6384:

Line 6381: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);

6377:
6378: WHEN FND_API.G_EXC_ERROR THEN
6379:
6380: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6381: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
6382: OE_MSG_PUB.Add;
6383: x_return_status := FND_API.G_RET_STS_ERROR;
6384:
6385: adj_debug('g_exc_error is '||g_stmt_no||' '||sqlerrm,1);

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

6394: RAISE FND_API.G_EXC_ERROR;
6395:
6396: /* END 2124989 */
6397: WHEN QP_ATTR_MAPPING_ERROR THEN
6398: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6399: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Please make sure Run QP Build Sourcing Rule has completed sucessfully');
6400: OE_MSG_PUB.Add;
6401: oe_debug_pub.add(' QP Attr Mapping threw exception');
6402: RAISE FND_API.G_EXC_ERROR;

Line 6399: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Please make sure Run QP Build Sourcing Rule has completed sucessfully');

6395:
6396: /* END 2124989 */
6397: WHEN QP_ATTR_MAPPING_ERROR THEN
6398: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6399: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Please make sure Run QP Build Sourcing Rule has completed sucessfully');
6400: OE_MSG_PUB.Add;
6401: oe_debug_pub.add(' QP Attr Mapping threw exception');
6402: RAISE FND_API.G_EXC_ERROR;
6403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

6401: oe_debug_pub.add(' QP Attr Mapping threw exception');
6402: RAISE FND_API.G_EXC_ERROR;
6403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6404:
6405: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6406: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
6407: OE_MSG_PUB.Add;
6408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6409: adj_debug('G_EXC_UNEXPECTED_ERROR is '||g_stmt_no||' '||sqlerrm,1);

Line 6406: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);

6402: RAISE FND_API.G_EXC_ERROR;
6403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6404:
6405: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6406: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
6407: OE_MSG_PUB.Add;
6408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6409: adj_debug('G_EXC_UNEXPECTED_ERROR is '||g_stmt_no||' '||sqlerrm,1);
6410: adj_debug('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);

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

6485: x_return_status,
6486: x_return_status_txt
6487: );
6488: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6489: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6490: FND_MESSAGE.SET_TOKEN('ERR_TEXT',x_return_status_txt);
6491: OE_MSG_PUB.Add;
6492: RAISE FND_API.G_EXC_ERROR;
6493: END IF;

Line 6490: FND_MESSAGE.SET_TOKEN('ERR_TEXT',x_return_status_txt);

6486: x_return_status_txt
6487: );
6488: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6489: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6490: FND_MESSAGE.SET_TOKEN('ERR_TEXT',x_return_status_txt);
6491: OE_MSG_PUB.Add;
6492: RAISE FND_API.G_EXC_ERROR;
6493: END IF;
6494: else

Line 7750: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');

7746: p_Line_Tbl(p_Line_Tbl.last+1) := l_line_rec;
7747:
7748: -- Display the PRG Item
7749: /* 2270949 : delay logging message
7750: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
7751: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.ordered_item);
7752: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_rec.Ordered_quantity);
7753: OE_MSG_PUB.Add('N');
7754: */

Line 7751: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.ordered_item);

7747:
7748: -- Display the PRG Item
7749: /* 2270949 : delay logging message
7750: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
7751: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.ordered_item);
7752: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_rec.Ordered_quantity);
7753: OE_MSG_PUB.Add('N');
7754: */
7755: adj_debug('inside price line: setting cascade');

Line 7752: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_rec.Ordered_quantity);

7748: -- Display the PRG Item
7749: /* 2270949 : delay logging message
7750: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
7751: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.ordered_item);
7752: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_rec.Ordered_quantity);
7753: OE_MSG_PUB.Add('N');
7754: */
7755: adj_debug('inside price line: setting cascade');
7756:

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

8015: Exception when no_data_found then
8016: Null;
8017: End;
8018: if nvl(p_price_event1,'N') <> 'PRICE' then --bug 2273446
8019: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
8020: l_msg_text := l_operand||' ( '||l_msg_text||' )';
8021: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
8022: OE_MSG_PUB.Add;
8023: end if; --bug 2273446

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

8017: End;
8018: if nvl(p_price_event1,'N') <> 'PRICE' then --bug 2273446
8019: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
8020: l_msg_text := l_operand||' ( '||l_msg_text||' )';
8021: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
8022: OE_MSG_PUB.Add;
8023: end if; --bug 2273446
8024:
8025: Else

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

8030: /*Begin
8031: Select hold_id into l_hold_source_rec.hold_id
8032: from oe_hold_definitions where type_code='GSA';
8033: Exception when no_data_found then
8034: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
8035: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Missing hold_definition for type_code GSA');
8036: OE_MSG_PUB.Add;
8037: adj_debug('Missing hold_definition for type_code GSA');
8038: End;*/

Line 8035: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Missing hold_definition for type_code GSA');

8031: Select hold_id into l_hold_source_rec.hold_id
8032: from oe_hold_definitions where type_code='GSA';
8033: Exception when no_data_found then
8034: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
8035: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Missing hold_definition for type_code GSA');
8036: OE_MSG_PUB.Add;
8037: adj_debug('Missing hold_definition for type_code GSA');
8038: End;*/
8039:

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

8038: End;*/
8039:
8040: If p_line_id is null or
8041: p_line_id = fnd_api.g_miss_num then
8042: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
8043: FND_MESSAGE.SET_TOKEN('ERR_TEXT','GSA_INVALID_LINE_ID');
8044: OE_MSG_PUB.Add;
8045: RAISE FND_API.G_EXC_ERROR;
8046: End if;

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

8039:
8040: If p_line_id is null or
8041: p_line_id = fnd_api.g_miss_num then
8042: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
8043: FND_MESSAGE.SET_TOKEN('ERR_TEXT','GSA_INVALID_LINE_ID');
8044: OE_MSG_PUB.Add;
8045: RAISE FND_API.G_EXC_ERROR;
8046: End if;
8047:

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

8095:
8096: If l_return_status = FND_API.g_ret_sts_success then
8097: if nvl(p_price_event1,'N') <> 'PRICE' then --bug 2273446
8098:
8099: FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');
8100: OE_MSG_PUB.Add;
8101: end if; --bug 2273446
8102: Else
8103: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');

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

8099: FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');
8100: OE_MSG_PUB.Add;
8101: end if; --bug 2273446
8102: Else
8103: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
8104: FND_MESSAGE.SET_TOKEN('ERR_TEXT','APPLY_GSA_HOLD');
8105: OE_MSG_PUB.Add;
8106: RAISE FND_API.G_EXC_ERROR;
8107: End If;

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

8100: OE_MSG_PUB.Add;
8101: end if; --bug 2273446
8102: Else
8103: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
8104: FND_MESSAGE.SET_TOKEN('ERR_TEXT','APPLY_GSA_HOLD');
8105: OE_MSG_PUB.Add;
8106: RAISE FND_API.G_EXC_ERROR;
8107: End If;
8108: End If; /* check hold */

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

8122: /*Begin
8123: Select hold_id into l_hold_source_rec.hold_id
8124: from oe_hold_definitions where type_code='GSA';
8125: Exception when no_data_found then
8126: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
8127: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Missing hold_definition for type_code GSA');
8128: OE_MSG_PUB.Add;
8129: adj_debug('Missing hold_definition for type_code GSA');
8130: End;*/

Line 8127: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Missing hold_definition for type_code GSA');

8123: Select hold_id into l_hold_source_rec.hold_id
8124: from oe_hold_definitions where type_code='GSA';
8125: Exception when no_data_found then
8126: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
8127: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Missing hold_definition for type_code GSA');
8128: OE_MSG_PUB.Add;
8129: adj_debug('Missing hold_definition for type_code GSA');
8130: End;*/
8131:

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

8864: p_allow_negative_price = 'N' then
8865:
8866: adj_debug('Negative list price '||p_line_tbl(i).unit_List_price_per_pqty ||
8867: 'Or selling price '||p_line_tbl(i).Unit_Selling_price_per_pqty);
8868: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
8869: FND_MESSAGE.SET_TOKEN('ITEM',p_line_tbl(i).Ordered_Item);
8870: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_line_tbl(i).unit_List_price_per_pqty);
8871: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_line_tbl(i).Unit_Selling_price_per_pqty);
8872: OE_MSG_PUB.Add;

Line 8869: FND_MESSAGE.SET_TOKEN('ITEM',p_line_tbl(i).Ordered_Item);

8865:
8866: adj_debug('Negative list price '||p_line_tbl(i).unit_List_price_per_pqty ||
8867: 'Or selling price '||p_line_tbl(i).Unit_Selling_price_per_pqty);
8868: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
8869: FND_MESSAGE.SET_TOKEN('ITEM',p_line_tbl(i).Ordered_Item);
8870: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_line_tbl(i).unit_List_price_per_pqty);
8871: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_line_tbl(i).Unit_Selling_price_per_pqty);
8872: OE_MSG_PUB.Add;
8873: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');

Line 8870: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_line_tbl(i).unit_List_price_per_pqty);

8866: adj_debug('Negative list price '||p_line_tbl(i).unit_List_price_per_pqty ||
8867: 'Or selling price '||p_line_tbl(i).Unit_Selling_price_per_pqty);
8868: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
8869: FND_MESSAGE.SET_TOKEN('ITEM',p_line_tbl(i).Ordered_Item);
8870: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_line_tbl(i).unit_List_price_per_pqty);
8871: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_line_tbl(i).Unit_Selling_price_per_pqty);
8872: OE_MSG_PUB.Add;
8873: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
8874: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_line_tbl(i).line_id));

Line 8871: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_line_tbl(i).Unit_Selling_price_per_pqty);

8867: 'Or selling price '||p_line_tbl(i).Unit_Selling_price_per_pqty);
8868: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
8869: FND_MESSAGE.SET_TOKEN('ITEM',p_line_tbl(i).Ordered_Item);
8870: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_line_tbl(i).unit_List_price_per_pqty);
8871: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_line_tbl(i).Unit_Selling_price_per_pqty);
8872: OE_MSG_PUB.Add;
8873: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
8874: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_line_tbl(i).line_id));
8875: OE_MSG_PUB.ADD;

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

8869: FND_MESSAGE.SET_TOKEN('ITEM',p_line_tbl(i).Ordered_Item);
8870: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_line_tbl(i).unit_List_price_per_pqty);
8871: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_line_tbl(i).Unit_Selling_price_per_pqty);
8872: OE_MSG_PUB.Add;
8873: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
8874: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_line_tbl(i).line_id));
8875: OE_MSG_PUB.ADD;
8876:
8877: RAISE FND_API.G_EXC_ERROR;

Line 8874: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_line_tbl(i).line_id));

8870: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_line_tbl(i).unit_List_price_per_pqty);
8871: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_line_tbl(i).Unit_Selling_price_per_pqty);
8872: OE_MSG_PUB.Add;
8873: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
8874: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_line_tbl(i).line_id));
8875: OE_MSG_PUB.ADD;
8876:
8877: RAISE FND_API.G_EXC_ERROR;
8878:

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

9263: or (G_IPL_ERRORS_TBL.exists(MOD(l_line_rec.line_id, G_BINARY_LIMIT)) -- Bug 8631297
9264: and
9265: G_IPL_ERRORS_TBL(MOD(l_line_rec.line_id,G_BINARY_LIMIT))<>l_line_rec.price_list_id) -- Bug 8631297
9266: Then
9267: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
9268: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9269: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
9270: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
9271: OE_MSG_PUB.Add;

Line 9268: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);

9264: and
9265: G_IPL_ERRORS_TBL(MOD(l_line_rec.line_id,G_BINARY_LIMIT))<>l_line_rec.price_list_id) -- Bug 8631297
9266: Then
9267: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
9268: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9269: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
9270: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
9271: OE_MSG_PUB.Add;
9272: End If;

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

9265: G_IPL_ERRORS_TBL(MOD(l_line_rec.line_id,G_BINARY_LIMIT))<>l_line_rec.price_list_id) -- Bug 8631297
9266: Then
9267: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
9268: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9269: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
9270: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
9271: OE_MSG_PUB.Add;
9272: End If;
9273:

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

9266: Then
9267: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
9268: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9269: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
9270: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
9271: OE_MSG_PUB.Add;
9272: End If;
9273:
9274: G_IPL_ERRORS_TBL(MOD(l_line_rec.line_id,G_BINARY_LIMIT)):=l_line_rec.price_list_id; -- Bug 8631297

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

9276: oe_debug_pub.add('Invalid line flag:'||l_invalid_line);
9277:
9278: If nvl(l_line_rec.booked_flag,'X') = 'Y' Then
9279: oe_debug_pub.add(' Before setting message');
9280: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
9281: oe_debug_pub.add(' Before setting token');
9282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price list');
9283: OE_MSG_PUB.ADD;
9284: oe_debug_pub.add('Process adjustments before raising g_exc_error');

Line 9282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price list');

9278: If nvl(l_line_rec.booked_flag,'X') = 'Y' Then
9279: oe_debug_pub.add(' Before setting message');
9280: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
9281: oe_debug_pub.add(' Before setting token');
9282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price list');
9283: OE_MSG_PUB.ADD;
9284: oe_debug_pub.add('Process adjustments before raising g_exc_error');
9285: RAISE FND_API.G_EXC_ERROR;
9286: End If;

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

9311: l_line_rec.unit_list_price_per_pqty:=NULL;
9312:
9313: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
9314: adj_debug('Price List Not found');
9315: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
9316: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9317: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9318: OE_MSG_PUB.Add;
9319: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then

Line 9316: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);

9312:
9313: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
9314: adj_debug('Price List Not found');
9315: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
9316: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9317: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9318: OE_MSG_PUB.Add;
9319: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
9320: adj_debug('Error in Formula processing');

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

9313: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
9314: adj_debug('Price List Not found');
9315: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
9316: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9317: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9318: OE_MSG_PUB.Add;
9319: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
9320: adj_debug('Error in Formula processing');
9321: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');

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

9317: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9318: OE_MSG_PUB.Add;
9319: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
9320: adj_debug('Error in Formula processing');
9321: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
9322: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text||SQLERRM);
9323: OE_MSG_PUB.Add;
9324: Elsif p_req_line_tbl(i).status_code in
9325: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,

Line 9322: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text||SQLERRM);

9318: OE_MSG_PUB.Add;
9319: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
9320: adj_debug('Error in Formula processing');
9321: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
9322: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text||SQLERRM);
9323: OE_MSG_PUB.Add;
9324: Elsif p_req_line_tbl(i).status_code in
9325: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
9326: FND_API.G_RET_STS_ERROR)

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

9325: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
9326: FND_API.G_RET_STS_ERROR)
9327: then
9328: adj_debug('Other errors processing');
9329: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
9330: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text||SQLERRM);
9331: OE_MSG_PUB.Add;
9332: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
9333: adj_debug('Invalid uom');

Line 9330: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text||SQLERRM);

9326: FND_API.G_RET_STS_ERROR)
9327: then
9328: adj_debug('Other errors processing');
9329: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
9330: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text||SQLERRM);
9331: OE_MSG_PUB.Add;
9332: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
9333: adj_debug('Invalid uom');
9334: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');

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

9330: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text||SQLERRM);
9331: OE_MSG_PUB.Add;
9332: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
9333: adj_debug('Invalid uom');
9334: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
9335: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9336: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9337: OE_MSG_PUB.Add;
9338: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then

Line 9335: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);

9331: OE_MSG_PUB.Add;
9332: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
9333: adj_debug('Invalid uom');
9334: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
9335: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9336: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9337: OE_MSG_PUB.Add;
9338: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
9339: adj_debug('Duplicate price list');

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

9332: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
9333: adj_debug('Invalid uom');
9334: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
9335: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9336: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9337: OE_MSG_PUB.Add;
9338: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
9339: adj_debug('Duplicate price list');
9340: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');

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

9336: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9337: OE_MSG_PUB.Add;
9338: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
9339: adj_debug('Duplicate price list');
9340: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
9341:
9342: Begin
9343: Select name into l_price_list
9344: from qp_list_headers_vl a,qp_list_lines b where

Line 9358: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||l_line_rec.Ordered_Item||' ) '||

9354: instr(p_req_line_tbl(i).status_text,',')-1);
9355:
9356: End;
9357:
9358: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||l_line_rec.Ordered_Item||' ) '||
9359: l_price_list);
9360: Begin
9361: Select name into l_price_list
9362: from qp_list_headers_vl a,qp_list_lines b where

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

9370: l_price_list := substr(p_req_line_tbl(i).status_text,
9371: instr(p_req_line_tbl(i).status_text,',')+1);
9372:
9373: End;
9374: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
9375: OE_MSG_PUB.Add;
9376: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
9377: adj_debug('Invalid UOM Conversion');
9378: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');

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

9374: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
9375: OE_MSG_PUB.Add;
9376: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
9377: adj_debug('Invalid UOM Conversion');
9378: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
9379: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
9380: p_req_line_tbl(i).status_text);
9381: OE_MSG_PUB.Add;
9382: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then

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

9375: OE_MSG_PUB.Add;
9376: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
9377: adj_debug('Invalid UOM Conversion');
9378: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
9379: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
9380: p_req_line_tbl(i).status_text);
9381: OE_MSG_PUB.Add;
9382: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
9383: adj_debug('Unable to resolve incompatibility');

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

9380: p_req_line_tbl(i).status_text);
9381: OE_MSG_PUB.Add;
9382: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
9383: adj_debug('Unable to resolve incompatibility');
9384: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
9385: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
9386: p_req_line_tbl(i).status_text);
9387: OE_MSG_PUB.Add;
9388: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then

Line 9385: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||l_line_rec.Ordered_Item||' ) '||

9381: OE_MSG_PUB.Add;
9382: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
9383: adj_debug('Unable to resolve incompatibility');
9384: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
9385: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
9386: p_req_line_tbl(i).status_text);
9387: OE_MSG_PUB.Add;
9388: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
9389: adj_debug('Error while evaluating the best price');

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

9386: p_req_line_tbl(i).status_text);
9387: OE_MSG_PUB.Add;
9388: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
9389: adj_debug('Error while evaluating the best price');
9390: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
9391: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9392: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text);
9393: OE_MSG_PUB.Add;
9394: End if;

Line 9391: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);

9387: OE_MSG_PUB.Add;
9388: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
9389: adj_debug('Error while evaluating the best price');
9390: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
9391: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9392: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text);
9393: OE_MSG_PUB.Add;
9394: End if;
9395:

Line 9392: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text);

9388: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
9389: adj_debug('Error while evaluating the best price');
9390: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
9391: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9392: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text);
9393: OE_MSG_PUB.Add;
9394: End if;
9395:
9396: --RAISE FND_API.G_EXC_ERROR;

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

9415:
9416: elsif ( p_req_line_tbl(i).unit_price < 0 or p_req_line_tbl(i).Adjusted_unit_price < 0) and l_allow_negative_price = 'N' then
9417:
9418: adj_debug('Negative list price '||p_req_line_tbl(i).unit_price ||'Or selling price '||p_req_line_tbl(i).Adjusted_unit_price);
9419: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
9420: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9421: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_req_line_tbl(i).unit_price);
9422: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_req_line_tbl(i).Adjusted_unit_price);
9423: OE_MSG_PUB.Add;

Line 9420: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);

9416: elsif ( p_req_line_tbl(i).unit_price < 0 or p_req_line_tbl(i).Adjusted_unit_price < 0) and l_allow_negative_price = 'N' then
9417:
9418: adj_debug('Negative list price '||p_req_line_tbl(i).unit_price ||'Or selling price '||p_req_line_tbl(i).Adjusted_unit_price);
9419: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
9420: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9421: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_req_line_tbl(i).unit_price);
9422: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_req_line_tbl(i).Adjusted_unit_price);
9423: OE_MSG_PUB.Add;
9424: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');

Line 9421: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_req_line_tbl(i).unit_price);

9417:
9418: adj_debug('Negative list price '||p_req_line_tbl(i).unit_price ||'Or selling price '||p_req_line_tbl(i).Adjusted_unit_price);
9419: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
9420: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9421: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_req_line_tbl(i).unit_price);
9422: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_req_line_tbl(i).Adjusted_unit_price);
9423: OE_MSG_PUB.Add;
9424: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
9425: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_req_line_tbl(i).line_id));

Line 9422: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_req_line_tbl(i).Adjusted_unit_price);

9418: adj_debug('Negative list price '||p_req_line_tbl(i).unit_price ||'Or selling price '||p_req_line_tbl(i).Adjusted_unit_price);
9419: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
9420: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9421: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_req_line_tbl(i).unit_price);
9422: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_req_line_tbl(i).Adjusted_unit_price);
9423: OE_MSG_PUB.Add;
9424: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
9425: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_req_line_tbl(i).line_id));
9426: OE_MSG_PUB.Add;

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

9420: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9421: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_req_line_tbl(i).unit_price);
9422: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_req_line_tbl(i).Adjusted_unit_price);
9423: OE_MSG_PUB.Add;
9424: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
9425: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_req_line_tbl(i).line_id));
9426: OE_MSG_PUB.Add;
9427:
9428: RAISE FND_API.G_EXC_ERROR;

Line 9425: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_req_line_tbl(i).line_id));

9421: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_req_line_tbl(i).unit_price);
9422: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_req_line_tbl(i).Adjusted_unit_price);
9423: OE_MSG_PUB.Add;
9424: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
9425: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_req_line_tbl(i).line_id));
9426: OE_MSG_PUB.Add;
9427:
9428: RAISE FND_API.G_EXC_ERROR;
9429: elsif

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

9430: p_req_line_tbl(i).line_Type_code ='LINE' and
9431: p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
9432: Then
9433:
9434: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
9435: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
9436: p_req_line_tbl(i).STATUS_TEXT);
9437: OE_MSG_PUB.Add;
9438:

Line 9435: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||l_line_rec.Ordered_Item||' ) '||

9431: p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
9432: Then
9433:
9434: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
9435: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
9436: p_req_line_tbl(i).STATUS_TEXT);
9437: OE_MSG_PUB.Add;
9438:
9439: elsif

Line 9587: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');

9583:
9584: IF (p_req_line_tbl(i).hold_code = QP_PREQ_GRP.G_STATUS_LIMIT_HOLD) or
9585: p_req_line_tbl(i).hold_code = QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED THEN
9586: IF (l_limit_hold_action = 'NO_HOLD') THEN
9587: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
9588: OE_MSG_PUB.ADD;
9589: ELSE
9590: IF ( p_req_line_tbl(i).line_type_code = 'LINE' )
9591: Then

Line 9858: FND_MESSAGE.SET_NAME('ONT','ONT_ITEM_UPGRADE_NOT_ALLOWED');

9854:
9855: Elsif to_char(l_line_tbl( p_req_line_detail_Tbl(j).line_index).Inventory_item_id ) <>
9856: p_req_line_detail_Tbl(j).RELATED_ITEM_ID Then
9857:
9858: FND_MESSAGE.SET_NAME('ONT','ONT_ITEM_UPGRADE_NOT_ALLOWED');
9859: OE_MSG_PUB.Add;
9860: adj_debug('Item Upgrade not allowed after booking...');
9861: l_line_adj_Tbl(l_Adj_Index).operation := fnd_api.g_miss_char;
9862:

Line 10024: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');

10020: ,p_source_document_id => l_source_document_id
10021: ,p_source_document_line_id => l_source_document_line_id);
10022: END IF;
10023:
10024: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
10025: FND_MESSAGE.SET_TOKEN('ERR_TEXT', p_req_line_detail_tbl(j).LIMIT_TEXT);
10026: OE_MSG_PUB.Add;
10027: IF (OE_GLOBALS.G_UI_FLAG ) THEN
10028: IF (G_REQUEST_ID IS NULL) THEN

Line 10025: FND_MESSAGE.SET_TOKEN('ERR_TEXT', p_req_line_detail_tbl(j).LIMIT_TEXT);

10021: ,p_source_document_line_id => l_source_document_line_id);
10022: END IF;
10023:
10024: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
10025: FND_MESSAGE.SET_TOKEN('ERR_TEXT', p_req_line_detail_tbl(j).LIMIT_TEXT);
10026: OE_MSG_PUB.Add;
10027: IF (OE_GLOBALS.G_UI_FLAG ) THEN
10028: IF (G_REQUEST_ID IS NULL) THEN
10029: select oe_msg_request_id_s.nextval into g_request_id from dual;

Line 10322: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');

10318: adj_debug('operation'||l_line_tbl_final(l).operation,1);
10319: -- 2270949: logging message about free goods line
10320: if (l_line_Tbl_final(l).operation = OE_GLOBALS.G_OPR_CREATE) and p_write_to_db = TRUE then
10321: -- Display the PRG Item
10322: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
10323: FND_MESSAGE.SET_TOKEN('ITEM',l_line_tbl_final(l).ordered_item);
10324: --bug 2412868 begin
10325: if l_line_tbl_final(l).line_category_code = 'RETURN' then
10326: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_tbl_final(l).Ordered_quantity);

Line 10323: FND_MESSAGE.SET_TOKEN('ITEM',l_line_tbl_final(l).ordered_item);

10319: -- 2270949: logging message about free goods line
10320: if (l_line_Tbl_final(l).operation = OE_GLOBALS.G_OPR_CREATE) and p_write_to_db = TRUE then
10321: -- Display the PRG Item
10322: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
10323: FND_MESSAGE.SET_TOKEN('ITEM',l_line_tbl_final(l).ordered_item);
10324: --bug 2412868 begin
10325: if l_line_tbl_final(l).line_category_code = 'RETURN' then
10326: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_tbl_final(l).Ordered_quantity);
10327: else

Line 10326: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_tbl_final(l).Ordered_quantity);

10322: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
10323: FND_MESSAGE.SET_TOKEN('ITEM',l_line_tbl_final(l).ordered_item);
10324: --bug 2412868 begin
10325: if l_line_tbl_final(l).line_category_code = 'RETURN' then
10326: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_tbl_final(l).Ordered_quantity);
10327: else
10328: --bug 2412868 end
10329: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_tbl_final(l).Ordered_quantity);
10330: end if;

Line 10329: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_tbl_final(l).Ordered_quantity);

10325: if l_line_tbl_final(l).line_category_code = 'RETURN' then
10326: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_tbl_final(l).Ordered_quantity);
10327: else
10328: --bug 2412868 end
10329: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_tbl_final(l).Ordered_quantity);
10330: end if;
10331: OE_MSG_PUB.Add('N');
10332: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
10333: end if;

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

10522: AND l_item_type_code <> 'INCLUDED') THEN
10523: --
10524: --
10525: If l_Line_Tbl_Final(j).unit_selling_price IS NULL Then
10526: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
10527: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
10528: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
10529: OE_MSG_PUB.ADD;
10530: End If;

Line 10527: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

10523: --
10524: --
10525: If l_Line_Tbl_Final(j).unit_selling_price IS NULL Then
10526: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
10527: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
10528: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
10529: OE_MSG_PUB.ADD;
10530: End If;
10531:

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

10529: OE_MSG_PUB.ADD;
10530: End If;
10531:
10532: If l_line_tbl_final(j).unit_list_price IS NULL Then
10533: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
10534: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
10535: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
10536: OE_MSG_PUB.ADD;
10537: End If;

Line 10534: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

10530: End If;
10531:
10532: If l_line_tbl_final(j).unit_list_price IS NULL Then
10533: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
10534: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
10535: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
10536: OE_MSG_PUB.ADD;
10537: End If;
10538:

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

10536: OE_MSG_PUB.ADD;
10537: End If;
10538:
10539: If l_line_tbl_final(j).price_list_id IS NULL Then
10540: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
10541: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','LIST PRICE');
10542: OE_MSG_PUB.ADD;
10543: End If;
10544:

Line 10541: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','LIST PRICE');

10537: End If;
10538:
10539: If l_line_tbl_final(j).price_list_id IS NULL Then
10540: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
10541: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','LIST PRICE');
10542: OE_MSG_PUB.ADD;
10543: End If;
10544:
10545: RAISE FND_API.G_EXC_ERROR;

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

10965:
10966: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
10967: THEN
10968:
10969: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
10970: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id or Header Id ');
10971: OE_MSG_PUB.Add;
10972: END IF;
10973: RAISE FND_API.G_EXC_ERROR;

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

10966: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
10967: THEN
10968:
10969: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
10970: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id or Header Id ');
10971: OE_MSG_PUB.Add;
10972: END IF;
10973: RAISE FND_API.G_EXC_ERROR;
10974: elsif (px_line_Tbl.count = 0) Then

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

13328: EXCEPTION
13329:
13330: WHEN FND_API.G_EXC_ERROR THEN
13331:
13332: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13333: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
13334: OE_MSG_PUB.Add;
13335: x_return_status := FND_API.G_RET_STS_ERROR;
13336:

Line 13333: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);

13329:
13330: WHEN FND_API.G_EXC_ERROR THEN
13331:
13332: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13333: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
13334: OE_MSG_PUB.Add;
13335: x_return_status := FND_API.G_RET_STS_ERROR;
13336:
13337: Oe_Debug_Pub.add('g_exc_error is '||g_stmt_no||' '||sqlerrm,1);

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

13340: RAISE FND_API.G_EXC_ERROR;
13341:
13342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13343:
13344: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13345: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
13346: OE_MSG_PUB.Add;
13347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13348: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is '||g_stmt_no||' '||sqlerrm,1);

Line 13345: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);

13341:
13342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13343:
13344: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13345: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
13346: OE_MSG_PUB.Add;
13347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13348: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is '||g_stmt_no||' '||sqlerrm,1);
13349: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);

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

13349: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);
13350: --DBMS_OUTPUT.PUT_LINE('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);
13351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13352: WHEN QP_ATTR_MAPPING_ERRORS Then
13353: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13354: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Errors return from QP_Attr_Mapping_PUB.Build_Context');
13355: OE_MSG_PUB.Add;
13356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13357: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is: QP_Attr_Mapping_PUB.Build_Context'||sqlerrm,1);

Line 13354: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Errors return from QP_Attr_Mapping_PUB.Build_Context');

13350: --DBMS_OUTPUT.PUT_LINE('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);
13351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13352: WHEN QP_ATTR_MAPPING_ERRORS Then
13353: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13354: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Errors return from QP_Attr_Mapping_PUB.Build_Context');
13355: OE_MSG_PUB.Add;
13356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13357: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is: QP_Attr_Mapping_PUB.Build_Context'||sqlerrm,1);
13358: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);

Line 13452: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_HOLD_APPLIED');

13448: );
13449:
13450: If l_return_status = FND_API.g_ret_sts_success then
13451: IF (p_line_id IS NULL) THEN
13452: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_HOLD_APPLIED');
13453: ELSE
13454: FND_MESSAGE.SET_NAME('ONT', 'ONT_LINE_PROMO_HOLD_APPLIED');
13455: END IF;
13456: OE_MSG_PUB.Add;

Line 13454: FND_MESSAGE.SET_NAME('ONT', 'ONT_LINE_PROMO_HOLD_APPLIED');

13450: If l_return_status = FND_API.g_ret_sts_success then
13451: IF (p_line_id IS NULL) THEN
13452: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_HOLD_APPLIED');
13453: ELSE
13454: FND_MESSAGE.SET_NAME('ONT', 'ONT_LINE_PROMO_HOLD_APPLIED');
13455: END IF;
13456: OE_MSG_PUB.Add;
13457: Else
13458: adj_debug('error applying hold',3);