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

5616:
5617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5618: THEN
5619:
5620: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
5621: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id or Header Id ');
5622: OE_MSG_PUB.Add;
5623: END IF;
5624: RAISE FND_API.G_EXC_ERROR;

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

5617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5618: THEN
5619:
5620: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
5621: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id or Header Id ');
5622: OE_MSG_PUB.Add;
5623: END IF;
5624: RAISE FND_API.G_EXC_ERROR;
5625: end if;

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

5804: Exception
5805: When no_data_found then
5806: null;
5807: End;
5808: fnd_message.set_name('ONT','ONT_INVALID_AGR_REVISION');
5809: fnd_message.set_TOKEN('AGREEMENT',l_agreement_name||' : '||l_revision);
5810: fnd_message.set_TOKEN('PRICING_DATE',l_line_tbl(line_Tbl_Index).PRICING_DATE);
5811: OE_MSG_PUB.Add;
5812: RAISE OE_AGREEMENT_ERROR;

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

5805: When no_data_found then
5806: null;
5807: End;
5808: fnd_message.set_name('ONT','ONT_INVALID_AGR_REVISION');
5809: fnd_message.set_TOKEN('AGREEMENT',l_agreement_name||' : '||l_revision);
5810: fnd_message.set_TOKEN('PRICING_DATE',l_line_tbl(line_Tbl_Index).PRICING_DATE);
5811: OE_MSG_PUB.Add;
5812: RAISE OE_AGREEMENT_ERROR;
5813: END;

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

5806: null;
5807: End;
5808: fnd_message.set_name('ONT','ONT_INVALID_AGR_REVISION');
5809: fnd_message.set_TOKEN('AGREEMENT',l_agreement_name||' : '||l_revision);
5810: fnd_message.set_TOKEN('PRICING_DATE',l_line_tbl(line_Tbl_Index).PRICING_DATE);
5811: OE_MSG_PUB.Add;
5812: RAISE OE_AGREEMENT_ERROR;
5813: END;
5814: End If;

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

6029: END IF;
6030:
6031:
6032: If Not l_message_displayed Then
6033: -- FND_MESSAGE.SET_NAME('ONT','ONT_LINE_FROZEN');
6034: --need to a method to display message as hint in the future
6035: l_message_displayed := TRUE;
6036: End If;
6037: l_any_frozen_line:=FALSE;

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

6285: EXCEPTION
6286:
6287: WHEN FND_API.G_EXC_ERROR THEN
6288:
6289: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6290: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
6291: OE_MSG_PUB.Add;
6292: x_return_status := FND_API.G_RET_STS_ERROR;
6293:

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

6286:
6287: WHEN FND_API.G_EXC_ERROR THEN
6288:
6289: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6290: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
6291: OE_MSG_PUB.Add;
6292: x_return_status := FND_API.G_RET_STS_ERROR;
6293:
6294: adj_debug('g_exc_error is '||g_stmt_no||' '||sqlerrm,1);

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

6303: RAISE FND_API.G_EXC_ERROR;
6304:
6305: /* END 2124989 */
6306: WHEN QP_ATTR_MAPPING_ERROR THEN
6307: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6308: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Please make sure Run QP Build Sourcing Rule has completed sucessfully');
6309: OE_MSG_PUB.Add;
6310: oe_debug_pub.add(' QP Attr Mapping threw exception');
6311: RAISE FND_API.G_EXC_ERROR;

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

6304:
6305: /* END 2124989 */
6306: WHEN QP_ATTR_MAPPING_ERROR THEN
6307: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6308: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Please make sure Run QP Build Sourcing Rule has completed sucessfully');
6309: OE_MSG_PUB.Add;
6310: oe_debug_pub.add(' QP Attr Mapping threw exception');
6311: RAISE FND_API.G_EXC_ERROR;
6312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

6310: oe_debug_pub.add(' QP Attr Mapping threw exception');
6311: RAISE FND_API.G_EXC_ERROR;
6312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6313:
6314: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6315: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
6316: OE_MSG_PUB.Add;
6317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6318: adj_debug('G_EXC_UNEXPECTED_ERROR is '||g_stmt_no||' '||sqlerrm,1);

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

6311: RAISE FND_API.G_EXC_ERROR;
6312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6313:
6314: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6315: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
6316: OE_MSG_PUB.Add;
6317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6318: adj_debug('G_EXC_UNEXPECTED_ERROR is '||g_stmt_no||' '||sqlerrm,1);
6319: adj_debug('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);

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

6394: x_return_status,
6395: x_return_status_txt
6396: );
6397: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6398: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6399: FND_MESSAGE.SET_TOKEN('ERR_TEXT',x_return_status_txt);
6400: OE_MSG_PUB.Add;
6401: RAISE FND_API.G_EXC_ERROR;
6402: END IF;

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

6395: x_return_status_txt
6396: );
6397: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6398: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
6399: FND_MESSAGE.SET_TOKEN('ERR_TEXT',x_return_status_txt);
6400: OE_MSG_PUB.Add;
6401: RAISE FND_API.G_EXC_ERROR;
6402: END IF;
6403: else

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

7654: p_Line_Tbl(p_Line_Tbl.last+1) := l_line_rec;
7655:
7656: -- Display the PRG Item
7657: /* 2270949 : delay logging message
7658: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
7659: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.ordered_item);
7660: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_rec.Ordered_quantity);
7661: OE_MSG_PUB.Add('N');
7662: */

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

7655:
7656: -- Display the PRG Item
7657: /* 2270949 : delay logging message
7658: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
7659: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.ordered_item);
7660: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_rec.Ordered_quantity);
7661: OE_MSG_PUB.Add('N');
7662: */
7663: adj_debug('inside price line: setting cascade');

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

7656: -- Display the PRG Item
7657: /* 2270949 : delay logging message
7658: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
7659: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.ordered_item);
7660: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_rec.Ordered_quantity);
7661: OE_MSG_PUB.Add('N');
7662: */
7663: adj_debug('inside price line: setting cascade');
7664:

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

7923: Exception when no_data_found then
7924: Null;
7925: End;
7926: if nvl(p_price_event1,'N') <> 'PRICE' then --bug 2273446
7927: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
7928: l_msg_text := l_operand||' ( '||l_msg_text||' )';
7929: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
7930: OE_MSG_PUB.Add;
7931: end if; --bug 2273446

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

7925: End;
7926: if nvl(p_price_event1,'N') <> 'PRICE' then --bug 2273446
7927: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
7928: l_msg_text := l_operand||' ( '||l_msg_text||' )';
7929: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
7930: OE_MSG_PUB.Add;
7931: end if; --bug 2273446
7932:
7933: Else

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

7938: /*Begin
7939: Select hold_id into l_hold_source_rec.hold_id
7940: from oe_hold_definitions where type_code='GSA';
7941: Exception when no_data_found then
7942: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
7943: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Missing hold_definition for type_code GSA');
7944: OE_MSG_PUB.Add;
7945: adj_debug('Missing hold_definition for type_code GSA');
7946: End;*/

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

7939: Select hold_id into l_hold_source_rec.hold_id
7940: from oe_hold_definitions where type_code='GSA';
7941: Exception when no_data_found then
7942: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
7943: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Missing hold_definition for type_code GSA');
7944: OE_MSG_PUB.Add;
7945: adj_debug('Missing hold_definition for type_code GSA');
7946: End;*/
7947:

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

7946: End;*/
7947:
7948: If p_line_id is null or
7949: p_line_id = fnd_api.g_miss_num then
7950: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
7951: FND_MESSAGE.SET_TOKEN('ERR_TEXT','GSA_INVALID_LINE_ID');
7952: OE_MSG_PUB.Add;
7953: RAISE FND_API.G_EXC_ERROR;
7954: End if;

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

7947:
7948: If p_line_id is null or
7949: p_line_id = fnd_api.g_miss_num then
7950: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
7951: FND_MESSAGE.SET_TOKEN('ERR_TEXT','GSA_INVALID_LINE_ID');
7952: OE_MSG_PUB.Add;
7953: RAISE FND_API.G_EXC_ERROR;
7954: End if;
7955:

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

8003:
8004: If l_return_status = FND_API.g_ret_sts_success then
8005: if nvl(p_price_event1,'N') <> 'PRICE' then --bug 2273446
8006:
8007: FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');
8008: OE_MSG_PUB.Add;
8009: end if; --bug 2273446
8010: Else
8011: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');

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

8007: FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');
8008: OE_MSG_PUB.Add;
8009: end if; --bug 2273446
8010: Else
8011: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
8012: FND_MESSAGE.SET_TOKEN('ERR_TEXT','APPLY_GSA_HOLD');
8013: OE_MSG_PUB.Add;
8014: RAISE FND_API.G_EXC_ERROR;
8015: End If;

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

8008: OE_MSG_PUB.Add;
8009: end if; --bug 2273446
8010: Else
8011: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
8012: FND_MESSAGE.SET_TOKEN('ERR_TEXT','APPLY_GSA_HOLD');
8013: OE_MSG_PUB.Add;
8014: RAISE FND_API.G_EXC_ERROR;
8015: End If;
8016: End If; /* check hold */

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

8772: p_allow_negative_price = 'N' then
8773:
8774: adj_debug('Negative list price '||p_line_tbl(i).unit_List_price_per_pqty ||
8775: 'Or selling price '||p_line_tbl(i).Unit_Selling_price_per_pqty);
8776: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
8777: FND_MESSAGE.SET_TOKEN('ITEM',p_line_tbl(i).Ordered_Item);
8778: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_line_tbl(i).unit_List_price_per_pqty);
8779: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_line_tbl(i).Unit_Selling_price_per_pqty);
8780: OE_MSG_PUB.Add;

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

8773:
8774: adj_debug('Negative list price '||p_line_tbl(i).unit_List_price_per_pqty ||
8775: 'Or selling price '||p_line_tbl(i).Unit_Selling_price_per_pqty);
8776: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
8777: FND_MESSAGE.SET_TOKEN('ITEM',p_line_tbl(i).Ordered_Item);
8778: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_line_tbl(i).unit_List_price_per_pqty);
8779: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_line_tbl(i).Unit_Selling_price_per_pqty);
8780: OE_MSG_PUB.Add;
8781: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');

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

8774: adj_debug('Negative list price '||p_line_tbl(i).unit_List_price_per_pqty ||
8775: 'Or selling price '||p_line_tbl(i).Unit_Selling_price_per_pqty);
8776: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
8777: FND_MESSAGE.SET_TOKEN('ITEM',p_line_tbl(i).Ordered_Item);
8778: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_line_tbl(i).unit_List_price_per_pqty);
8779: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_line_tbl(i).Unit_Selling_price_per_pqty);
8780: OE_MSG_PUB.Add;
8781: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
8782: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_line_tbl(i).line_id));

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

8775: 'Or selling price '||p_line_tbl(i).Unit_Selling_price_per_pqty);
8776: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
8777: FND_MESSAGE.SET_TOKEN('ITEM',p_line_tbl(i).Ordered_Item);
8778: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_line_tbl(i).unit_List_price_per_pqty);
8779: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_line_tbl(i).Unit_Selling_price_per_pqty);
8780: OE_MSG_PUB.Add;
8781: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
8782: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_line_tbl(i).line_id));
8783: OE_MSG_PUB.ADD;

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

8777: FND_MESSAGE.SET_TOKEN('ITEM',p_line_tbl(i).Ordered_Item);
8778: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_line_tbl(i).unit_List_price_per_pqty);
8779: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_line_tbl(i).Unit_Selling_price_per_pqty);
8780: OE_MSG_PUB.Add;
8781: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
8782: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_line_tbl(i).line_id));
8783: OE_MSG_PUB.ADD;
8784:
8785: RAISE FND_API.G_EXC_ERROR;

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

8778: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_line_tbl(i).unit_List_price_per_pqty);
8779: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_line_tbl(i).Unit_Selling_price_per_pqty);
8780: OE_MSG_PUB.Add;
8781: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
8782: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_line_tbl(i).line_id));
8783: OE_MSG_PUB.ADD;
8784:
8785: RAISE FND_API.G_EXC_ERROR;
8786:

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

9171: or (G_IPL_ERRORS_TBL.exists(l_line_rec.line_id)
9172: and
9173: G_IPL_ERRORS_TBL(l_line_rec.line_id)<>l_line_rec.price_list_id)
9174: Then
9175: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
9176: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9177: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
9178: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
9179: OE_MSG_PUB.Add;

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

9172: and
9173: G_IPL_ERRORS_TBL(l_line_rec.line_id)<>l_line_rec.price_list_id)
9174: Then
9175: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
9176: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9177: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
9178: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
9179: OE_MSG_PUB.Add;
9180: End If;

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

9173: G_IPL_ERRORS_TBL(l_line_rec.line_id)<>l_line_rec.price_list_id)
9174: Then
9175: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
9176: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9177: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
9178: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
9179: OE_MSG_PUB.Add;
9180: End If;
9181:

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

9174: Then
9175: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
9176: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9177: FND_MESSAGE.SET_TOKEN('UNIT',l_line_rec.Order_Quantity_uom);
9178: FND_MESSAGE.SET_TOKEN('PRICE_LIST',l_Price_List);
9179: OE_MSG_PUB.Add;
9180: End If;
9181:
9182: G_IPL_ERRORS_TBL(l_line_rec.line_id):=l_line_rec.price_list_id;

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

9185: oe_debug_pub.add('Invalid line flag:'||l_invalid_line);
9186:
9187: If nvl(l_line_rec.booked_flag,'X') = 'Y' Then
9188: oe_debug_pub.add(' Before setting message');
9189: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
9190: oe_debug_pub.add(' Before setting token');
9191: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price list');
9192: OE_MSG_PUB.ADD;
9193: oe_debug_pub.add('Process adjustments before raising g_exc_error');

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

9187: If nvl(l_line_rec.booked_flag,'X') = 'Y' Then
9188: oe_debug_pub.add(' Before setting message');
9189: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
9190: oe_debug_pub.add(' Before setting token');
9191: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price list');
9192: OE_MSG_PUB.ADD;
9193: oe_debug_pub.add('Process adjustments before raising g_exc_error');
9194: RAISE FND_API.G_EXC_ERROR;
9195: End If;

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

9220: l_line_rec.unit_list_price_per_pqty:=NULL;
9221:
9222: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
9223: adj_debug('Price List Not found');
9224: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
9225: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9226: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9227: OE_MSG_PUB.Add;
9228: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then

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

9221:
9222: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
9223: adj_debug('Price List Not found');
9224: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
9225: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9226: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9227: OE_MSG_PUB.Add;
9228: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
9229: adj_debug('Error in Formula processing');

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

9222: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
9223: adj_debug('Price List Not found');
9224: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
9225: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9226: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9227: OE_MSG_PUB.Add;
9228: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
9229: adj_debug('Error in Formula processing');
9230: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');

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

9226: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9227: OE_MSG_PUB.Add;
9228: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
9229: adj_debug('Error in Formula processing');
9230: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
9231: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text||SQLERRM);
9232: OE_MSG_PUB.Add;
9233: Elsif p_req_line_tbl(i).status_code in
9234: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,

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

9227: OE_MSG_PUB.Add;
9228: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
9229: adj_debug('Error in Formula processing');
9230: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
9231: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text||SQLERRM);
9232: OE_MSG_PUB.Add;
9233: Elsif p_req_line_tbl(i).status_code in
9234: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
9235: FND_API.G_RET_STS_ERROR)

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

9234: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
9235: FND_API.G_RET_STS_ERROR)
9236: then
9237: adj_debug('Other errors processing');
9238: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
9239: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text||SQLERRM);
9240: OE_MSG_PUB.Add;
9241: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
9242: adj_debug('Invalid uom');

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

9235: FND_API.G_RET_STS_ERROR)
9236: then
9237: adj_debug('Other errors processing');
9238: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
9239: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text||SQLERRM);
9240: OE_MSG_PUB.Add;
9241: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
9242: adj_debug('Invalid uom');
9243: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');

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

9239: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text||SQLERRM);
9240: OE_MSG_PUB.Add;
9241: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
9242: adj_debug('Invalid uom');
9243: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
9244: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9245: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9246: OE_MSG_PUB.Add;
9247: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then

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

9240: OE_MSG_PUB.Add;
9241: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
9242: adj_debug('Invalid uom');
9243: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
9244: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9245: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9246: OE_MSG_PUB.Add;
9247: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
9248: adj_debug('Duplicate price list');

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

9241: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
9242: adj_debug('Invalid uom');
9243: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
9244: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9245: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9246: OE_MSG_PUB.Add;
9247: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
9248: adj_debug('Duplicate price list');
9249: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');

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

9245: FND_MESSAGE.SET_TOKEN('UOM',l_line_rec.Order_Quantity_uom);
9246: OE_MSG_PUB.Add;
9247: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
9248: adj_debug('Duplicate price list');
9249: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
9250:
9251: Begin
9252: Select name into l_price_list
9253: from qp_list_headers_vl a,qp_list_lines b where

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

9263: instr(p_req_line_tbl(i).status_text,',')-1);
9264:
9265: End;
9266:
9267: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||l_line_rec.Ordered_Item||' ) '||
9268: l_price_list);
9269: Begin
9270: Select name into l_price_list
9271: from qp_list_headers_vl a,qp_list_lines b where

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

9279: l_price_list := substr(p_req_line_tbl(i).status_text,
9280: instr(p_req_line_tbl(i).status_text,',')+1);
9281:
9282: End;
9283: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
9284: OE_MSG_PUB.Add;
9285: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
9286: adj_debug('Invalid UOM Conversion');
9287: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');

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

9283: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
9284: OE_MSG_PUB.Add;
9285: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
9286: adj_debug('Invalid UOM Conversion');
9287: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
9288: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
9289: p_req_line_tbl(i).status_text);
9290: OE_MSG_PUB.Add;
9291: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then

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

9284: OE_MSG_PUB.Add;
9285: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
9286: adj_debug('Invalid UOM Conversion');
9287: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
9288: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
9289: p_req_line_tbl(i).status_text);
9290: OE_MSG_PUB.Add;
9291: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
9292: adj_debug('Unable to resolve incompatibility');

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

9289: p_req_line_tbl(i).status_text);
9290: OE_MSG_PUB.Add;
9291: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
9292: adj_debug('Unable to resolve incompatibility');
9293: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
9294: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
9295: p_req_line_tbl(i).status_text);
9296: OE_MSG_PUB.Add;
9297: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then

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

9290: OE_MSG_PUB.Add;
9291: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
9292: adj_debug('Unable to resolve incompatibility');
9293: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
9294: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
9295: p_req_line_tbl(i).status_text);
9296: OE_MSG_PUB.Add;
9297: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
9298: adj_debug('Error while evaluating the best price');

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

9295: p_req_line_tbl(i).status_text);
9296: OE_MSG_PUB.Add;
9297: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
9298: adj_debug('Error while evaluating the best price');
9299: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
9300: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9301: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text);
9302: OE_MSG_PUB.Add;
9303: End if;

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

9296: OE_MSG_PUB.Add;
9297: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
9298: adj_debug('Error while evaluating the best price');
9299: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
9300: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9301: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text);
9302: OE_MSG_PUB.Add;
9303: End if;
9304:

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

9297: Elsif p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
9298: adj_debug('Error while evaluating the best price');
9299: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
9300: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9301: FND_MESSAGE.SET_TOKEN('ERR_TEXT',p_req_line_tbl(i).status_text);
9302: OE_MSG_PUB.Add;
9303: End if;
9304:
9305: --RAISE FND_API.G_EXC_ERROR;

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

9324:
9325: 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
9326:
9327: adj_debug('Negative list price '||p_req_line_tbl(i).unit_price ||'Or selling price '||p_req_line_tbl(i).Adjusted_unit_price);
9328: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
9329: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9330: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_req_line_tbl(i).unit_price);
9331: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_req_line_tbl(i).Adjusted_unit_price);
9332: OE_MSG_PUB.Add;

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

9325: 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
9326:
9327: adj_debug('Negative list price '||p_req_line_tbl(i).unit_price ||'Or selling price '||p_req_line_tbl(i).Adjusted_unit_price);
9328: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
9329: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9330: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_req_line_tbl(i).unit_price);
9331: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_req_line_tbl(i).Adjusted_unit_price);
9332: OE_MSG_PUB.Add;
9333: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');

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

9326:
9327: adj_debug('Negative list price '||p_req_line_tbl(i).unit_price ||'Or selling price '||p_req_line_tbl(i).Adjusted_unit_price);
9328: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
9329: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9330: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_req_line_tbl(i).unit_price);
9331: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_req_line_tbl(i).Adjusted_unit_price);
9332: OE_MSG_PUB.Add;
9333: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
9334: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_req_line_tbl(i).line_id));

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

9327: adj_debug('Negative list price '||p_req_line_tbl(i).unit_price ||'Or selling price '||p_req_line_tbl(i).Adjusted_unit_price);
9328: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
9329: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9330: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_req_line_tbl(i).unit_price);
9331: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_req_line_tbl(i).Adjusted_unit_price);
9332: OE_MSG_PUB.Add;
9333: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
9334: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_req_line_tbl(i).line_id));
9335: OE_MSG_PUB.Add;

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

9329: FND_MESSAGE.SET_TOKEN('ITEM',l_line_rec.Ordered_Item);
9330: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_req_line_tbl(i).unit_price);
9331: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_req_line_tbl(i).Adjusted_unit_price);
9332: OE_MSG_PUB.Add;
9333: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
9334: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_req_line_tbl(i).line_id));
9335: OE_MSG_PUB.Add;
9336:
9337: RAISE FND_API.G_EXC_ERROR;

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

9330: FND_MESSAGE.SET_TOKEN('LIST_PRICE',p_req_line_tbl(i).unit_price);
9331: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',p_req_line_tbl(i).Adjusted_unit_price);
9332: OE_MSG_PUB.Add;
9333: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
9334: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(p_req_line_tbl(i).line_id));
9335: OE_MSG_PUB.Add;
9336:
9337: RAISE FND_API.G_EXC_ERROR;
9338: elsif

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

9339: p_req_line_tbl(i).line_Type_code ='LINE' and
9340: p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
9341: Then
9342:
9343: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
9344: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
9345: p_req_line_tbl(i).STATUS_TEXT);
9346: OE_MSG_PUB.Add;
9347:

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

9340: p_req_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
9341: Then
9342:
9343: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
9344: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||l_line_rec.Ordered_Item||' ) '||
9345: p_req_line_tbl(i).STATUS_TEXT);
9346: OE_MSG_PUB.Add;
9347:
9348: elsif

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

9492:
9493: IF (p_req_line_tbl(i).hold_code = QP_PREQ_GRP.G_STATUS_LIMIT_HOLD) or
9494: p_req_line_tbl(i).hold_code = QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED THEN
9495: IF (l_limit_hold_action = 'NO_HOLD') THEN
9496: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
9497: OE_MSG_PUB.ADD;
9498: ELSE
9499: IF ( p_req_line_tbl(i).line_type_code = 'LINE' )
9500: Then

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

9763:
9764: Elsif to_char(l_line_tbl( p_req_line_detail_Tbl(j).line_index).Inventory_item_id ) <>
9765: p_req_line_detail_Tbl(j).RELATED_ITEM_ID Then
9766:
9767: FND_MESSAGE.SET_NAME('ONT','ONT_ITEM_UPGRADE_NOT_ALLOWED');
9768: OE_MSG_PUB.Add;
9769: adj_debug('Item Upgrade not allowed after booking...');
9770: l_line_adj_Tbl(l_Adj_Index).operation := fnd_api.g_miss_char;
9771:

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

9929: ,p_source_document_id => l_source_document_id
9930: ,p_source_document_line_id => l_source_document_line_id);
9931: END IF;
9932:
9933: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
9934: FND_MESSAGE.SET_TOKEN('ERR_TEXT', p_req_line_detail_tbl(j).LIMIT_TEXT);
9935: OE_MSG_PUB.Add;
9936: IF (OE_GLOBALS.G_UI_FLAG ) THEN
9937: IF (G_REQUEST_ID IS NULL) THEN

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

9930: ,p_source_document_line_id => l_source_document_line_id);
9931: END IF;
9932:
9933: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_LIMIT_EXCEEDED');
9934: FND_MESSAGE.SET_TOKEN('ERR_TEXT', p_req_line_detail_tbl(j).LIMIT_TEXT);
9935: OE_MSG_PUB.Add;
9936: IF (OE_GLOBALS.G_UI_FLAG ) THEN
9937: IF (G_REQUEST_ID IS NULL) THEN
9938: select oe_msg_request_id_s.nextval into g_request_id from dual;

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

10227: adj_debug('operation'||l_line_tbl_final(l).operation,1);
10228: -- 2270949: logging message about free goods line
10229: if (l_line_Tbl_final(l).operation = OE_GLOBALS.G_OPR_CREATE) and p_write_to_db = TRUE then
10230: -- Display the PRG Item
10231: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
10232: FND_MESSAGE.SET_TOKEN('ITEM',l_line_tbl_final(l).ordered_item);
10233: --bug 2412868 begin
10234: if l_line_tbl_final(l).line_category_code = 'RETURN' then
10235: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_tbl_final(l).Ordered_quantity);

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

10228: -- 2270949: logging message about free goods line
10229: if (l_line_Tbl_final(l).operation = OE_GLOBALS.G_OPR_CREATE) and p_write_to_db = TRUE then
10230: -- Display the PRG Item
10231: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
10232: FND_MESSAGE.SET_TOKEN('ITEM',l_line_tbl_final(l).ordered_item);
10233: --bug 2412868 begin
10234: if l_line_tbl_final(l).line_category_code = 'RETURN' then
10235: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_tbl_final(l).Ordered_quantity);
10236: else

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

10231: FND_MESSAGE.SET_NAME('ONT','ONT_CREATED_NEW_LINE');
10232: FND_MESSAGE.SET_TOKEN('ITEM',l_line_tbl_final(l).ordered_item);
10233: --bug 2412868 begin
10234: if l_line_tbl_final(l).line_category_code = 'RETURN' then
10235: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_tbl_final(l).Ordered_quantity);
10236: else
10237: --bug 2412868 end
10238: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_tbl_final(l).Ordered_quantity);
10239: end if;

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

10234: if l_line_tbl_final(l).line_category_code = 'RETURN' then
10235: FND_MESSAGE.SET_TOKEN('QUANTITY',(-1) * l_line_tbl_final(l).Ordered_quantity);
10236: else
10237: --bug 2412868 end
10238: FND_MESSAGE.SET_TOKEN('QUANTITY',l_line_tbl_final(l).Ordered_quantity);
10239: end if;
10240: OE_MSG_PUB.Add('N');
10241: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
10242: end if;

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

10414: AND l_item_type_code <> 'INCLUDED') THEN
10415: --
10416: --
10417: If l_Line_Tbl_Final(j).unit_selling_price IS NULL Then
10418: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
10419: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
10420: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
10421: OE_MSG_PUB.ADD;
10422: End If;

Line 10419: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

10415: --
10416: --
10417: If l_Line_Tbl_Final(j).unit_selling_price IS NULL Then
10418: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
10419: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
10420: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
10421: OE_MSG_PUB.ADD;
10422: End If;
10423:

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

10421: OE_MSG_PUB.ADD;
10422: End If;
10423:
10424: If l_line_tbl_final(j).unit_list_price IS NULL Then
10425: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
10426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
10427: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
10428: OE_MSG_PUB.ADD;
10429: End If;

Line 10426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

10422: End If;
10423:
10424: If l_line_tbl_final(j).unit_list_price IS NULL Then
10425: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
10426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
10427: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
10428: OE_MSG_PUB.ADD;
10429: End If;
10430:

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

10428: OE_MSG_PUB.ADD;
10429: End If;
10430:
10431: If l_line_tbl_final(j).price_list_id IS NULL Then
10432: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
10433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','LIST PRICE');
10434: OE_MSG_PUB.ADD;
10435: End If;
10436:

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

10429: End If;
10430:
10431: If l_line_tbl_final(j).price_list_id IS NULL Then
10432: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
10433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','LIST PRICE');
10434: OE_MSG_PUB.ADD;
10435: End If;
10436:
10437: RAISE FND_API.G_EXC_ERROR;

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

10857:
10858: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
10859: THEN
10860:
10861: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
10862: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id or Header Id ');
10863: OE_MSG_PUB.Add;
10864: END IF;
10865: RAISE FND_API.G_EXC_ERROR;

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

10858: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
10859: THEN
10860:
10861: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
10862: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id or Header Id ');
10863: OE_MSG_PUB.Add;
10864: END IF;
10865: RAISE FND_API.G_EXC_ERROR;
10866: elsif (px_line_Tbl.count = 0) Then

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

13154: EXCEPTION
13155:
13156: WHEN FND_API.G_EXC_ERROR THEN
13157:
13158: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13159: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
13160: OE_MSG_PUB.Add;
13161: x_return_status := FND_API.G_RET_STS_ERROR;
13162:

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

13155:
13156: WHEN FND_API.G_EXC_ERROR THEN
13157:
13158: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13159: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
13160: OE_MSG_PUB.Add;
13161: x_return_status := FND_API.G_RET_STS_ERROR;
13162:
13163: Oe_Debug_Pub.add('g_exc_error is '||g_stmt_no||' '||sqlerrm,1);

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

13166: RAISE FND_API.G_EXC_ERROR;
13167:
13168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13169:
13170: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13171: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
13172: OE_MSG_PUB.Add;
13173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13174: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is '||g_stmt_no||' '||sqlerrm,1);

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

13167:
13168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13169:
13170: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13171: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_Text);
13172: OE_MSG_PUB.Add;
13173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13174: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is '||g_stmt_no||' '||sqlerrm,1);
13175: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);

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

13175: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);
13176: --DBMS_OUTPUT.PUT_LINE('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);
13177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13178: WHEN QP_ATTR_MAPPING_ERRORS Then
13179: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13180: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Errors return from QP_Attr_Mapping_PUB.Build_Context');
13181: OE_MSG_PUB.Add;
13182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13183: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is: QP_Attr_Mapping_PUB.Build_Context'||sqlerrm,1);

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

13176: --DBMS_OUTPUT.PUT_LINE('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);
13177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13178: WHEN QP_ATTR_MAPPING_ERRORS Then
13179: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
13180: FND_MESSAGE.SET_TOKEN('ERR_TEXT','Errors return from QP_Attr_Mapping_PUB.Build_Context');
13181: OE_MSG_PUB.Add;
13182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13183: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is: QP_Attr_Mapping_PUB.Build_Context'||sqlerrm,1);
13184: Oe_Debug_Pub.add('G_EXC_UNEXPECTED_ERROR is '||l_return_status_Text);

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

13274: );
13275:
13276: If l_return_status = FND_API.g_ret_sts_success then
13277: IF (p_line_id IS NULL) THEN
13278: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_HOLD_APPLIED');
13279: ELSE
13280: FND_MESSAGE.SET_NAME('ONT', 'ONT_LINE_PROMO_HOLD_APPLIED');
13281: END IF;
13282: OE_MSG_PUB.Add;

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

13276: If l_return_status = FND_API.g_ret_sts_success then
13277: IF (p_line_id IS NULL) THEN
13278: FND_MESSAGE.SET_NAME('ONT','ONT_PROMO_HOLD_APPLIED');
13279: ELSE
13280: FND_MESSAGE.SET_NAME('ONT', 'ONT_LINE_PROMO_HOLD_APPLIED');
13281: END IF;
13282: OE_MSG_PUB.Add;
13283: Else
13284: adj_debug('error applying hold',3);