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_PRICE_PVT dependencies on OE_MSG_PUB

Line 322: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

318: RAISE NO_DATA_FOUND;
319:
320: WHEN OTHERS THEN
321:
322: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: OE_MSG_PUB.Add_Exc_Msg
325: ( G_PKG_NAME
326: , 'Query_Header'

Line 324: OE_MSG_PUB.Add_Exc_Msg

320: WHEN OTHERS THEN
321:
322: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: OE_MSG_PUB.Add_Exc_Msg
325: ( G_PKG_NAME
326: , 'Query_Header'
327: );
328: END IF;

Line 617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614:
615: WHEN OTHERS THEN
616:
617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
618: THEN
619: OE_MSG_PUB.Add_Exc_Msg
620: ( G_PKG_NAME
621: , 'Query_lines'

Line 619: OE_MSG_PUB.Add_Exc_Msg

615: WHEN OTHERS THEN
616:
617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
618: THEN
619: OE_MSG_PUB.Add_Exc_Msg
620: ( G_PKG_NAME
621: , 'Query_lines'
622: );
623: END IF;

Line 1835: OE_MSG_PUB.Add;

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
1839:

Line 2441: OE_MSG_PUB.set_msg_context

2437: IF l_debug_level > 0 THEN
2438: oe_debug_pub.add( 'LINE ID'||L_LINE_REC.LINE_ID ) ;
2439: END IF;
2440: -- bug 4866684 setting the msg context
2441: OE_MSG_PUB.set_msg_context
2442: ( p_entity_code => 'LINE'
2443: ,p_entity_id => l_line_rec.line_id
2444: ,p_header_id => l_line_rec.header_id
2445: ,p_line_id => l_line_rec.line_id

Line 2656: OE_MSG_PUB.Add;*/

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');
2660: l_line_num := OE_ORDER_MISC_PUB.get_concat_line_number(i.line_id);

Line 2665: OE_MSG_PUB.Add;

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
2669: ELSE -- violation action is error

Line 2679: OE_MSG_PUB.Add;

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:
2683: G_STMT_NO := 'Gsa_Check#20.20';

Line 2740: OE_MSG_PUB.Add;*/

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');
2744: OE_MSG_PUB.Add;

Line 2744: OE_MSG_PUB.Add;

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
2748:

Line 2752: OE_MSG_PUB.Add;

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 */
2756: End if; --for bug 2028480

Line 3823: OE_MSG_PUB.Add;

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
3827: IF l_debug_level > 0 THEN

Line 5487: oe_msg_pub.transfer_msg_stack;

5483: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5484: IF l_debug_level > 0 THEN
5485: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5486: END IF;
5487: oe_msg_pub.transfer_msg_stack;
5488: RAISE FND_API.G_EXC_ERROR;
5489: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5490: IF l_debug_level > 0 THEN
5491: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);

Line 5493: oe_msg_pub.transfer_msg_stack;

5489: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5490: IF l_debug_level > 0 THEN
5491: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5492: END IF;
5493: oe_msg_pub.transfer_msg_stack;
5494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5495: END IF;
5496:
5497: l_req_line_rec.LINE_QUANTITY := x_secondary_quantity;

Line 5544: OE_MSG_PUB.Add;

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
5548: END IF; -- end check for shipped_quantity

Line 5722: OE_MSG_PUB.Add;

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:
5726: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN

Line 5767: OE_MSG_PUB.Add;

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:
5771: END IF;

Line 5987: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

5983: and p_control_rec.p_use_current_header = FALSE
5984: then
5985: l_return_status := FND_API.G_RET_STS_ERROR;
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 ');

Line 5992: OE_MSG_PUB.Add;

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;
5996:

Line 5999: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5995: end if;
5996:
5997: G_STMT_NO := 'calculate_adjustments#20';
5998: if p_Line_id is not null and p_Header_id is not null then
5999: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6000: THEN
6001: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,
6002: 'oe_line_adj.calulate_adjustments'
6003: ,'Keys are mutually exclusive');

Line 6001: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,

5997: G_STMT_NO := 'calculate_adjustments#20';
5998: if p_Line_id is not null and p_Header_id is not null then
5999: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6000: THEN
6001: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,
6002: 'oe_line_adj.calulate_adjustments'
6003: ,'Keys are mutually exclusive');
6004: END IF;
6005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6207: OE_MSG_PUB.Add;

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;
6211: --End 2740845

Line 6752: OE_MSG_PUB.Add;

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
6756: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);

Line 6757: 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:
6761: END Call_Pricing_Engine;

Line 6830: OE_MSG_PUB.Add;

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
6834: null;

Line 6983: OE_MSG_PUB.set_msg_context

6979: J:= px_Line_Tbl.next(j);
6980: end loop;
6981: End If;
6982:
6983: OE_MSG_PUB.set_msg_context
6984: ( p_entity_code => 'LINE'
6985: ,p_entity_id => l_line_rec.line_id
6986: ,p_header_id => l_line_rec.header_id
6987: ,p_line_id => l_line_rec.line_id

Line 7023: OE_MSG_PUB.Add;

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
7026: OE_MSG_PUB.Add;
7027: END IF;

Line 7026: OE_MSG_PUB.Add;

7022: else
7023: OE_MSG_PUB.Add;
7024: end if;
7025: ELSE
7026: OE_MSG_PUB.Add;
7027: END IF;
7028: END IF;
7029: l_invalid_line := 'Y';
7030: END IF; */

Line 7077: OE_MSG_PUB.Add;

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
7080: OE_MSG_PUB.Add;
7081: END IF;

Line 7080: OE_MSG_PUB.Add;

7076: ELSE
7077: OE_MSG_PUB.Add;
7078: END IF;
7079: ELSE
7080: OE_MSG_PUB.Add;
7081: END IF;
7082: ELSE
7083: l_invalid_line := 'N';
7084: End IF;

Line 7100: OE_MSG_PUB.ADD;

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
7104: oe_debug_pub.add( 'PRICE'||L_LINE_REC.UNIT_SELLING_PRICE||':'||L_LINE_REC.UNIT_LIST_PRICE ) ;

Line 7132: OE_MSG_PUB.Add;

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
7135: OE_MSG_PUB.Add;
7136: end if;

Line 7135: OE_MSG_PUB.Add;

7131: else
7132: OE_MSG_PUB.Add;
7133: end if;
7134: else
7135: OE_MSG_PUB.Add;
7136: end if;
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' ) ;

Line 7147: OE_MSG_PUB.Add;

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
7150: OE_MSG_PUB.Add;
7151: end if;

Line 7150: OE_MSG_PUB.Add;

7146: else
7147: OE_MSG_PUB.Add;
7148: end if;
7149: else
7150: OE_MSG_PUB.Add;
7151: end if;
7152: Elsif wrong_line.pricing_status_code in
7153: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
7154: FND_API.G_RET_STS_ERROR)

Line 7165: OE_MSG_PUB.Add;

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
7168: OE_MSG_PUB.Add;
7169: end if;

Line 7168: OE_MSG_PUB.Add;

7164: else
7165: OE_MSG_PUB.Add;
7166: end if;
7167: else
7168: OE_MSG_PUB.Add;
7169: end if;
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' ) ;

Line 7181: OE_MSG_PUB.Add;

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
7184: OE_MSG_PUB.Add;
7185: end if;

Line 7184: OE_MSG_PUB.Add;

7180: else
7181: OE_MSG_PUB.Add;
7182: end if;
7183: else
7184: OE_MSG_PUB.Add;
7185: end if;
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' ) ;

Line 7229: OE_MSG_PUB.Add;

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
7232: OE_MSG_PUB.Add;
7233: end if;

Line 7232: OE_MSG_PUB.Add;

7228: else
7229: OE_MSG_PUB.Add;
7230: end if;
7231: else
7232: OE_MSG_PUB.Add;
7233: end if;
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' ) ;

Line 7245: OE_MSG_PUB.Add;

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
7248: OE_MSG_PUB.Add;
7249: end if;

Line 7248: OE_MSG_PUB.Add;

7244: else
7245: OE_MSG_PUB.Add;
7246: end if;
7247: else
7248: OE_MSG_PUB.Add;
7249: end if;
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' ) ;

Line 7261: OE_MSG_PUB.Add;

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
7264: OE_MSG_PUB.Add;
7265: end if;

Line 7264: OE_MSG_PUB.Add;

7260: else
7261: OE_MSG_PUB.Add;
7262: end if;
7263: else
7264: OE_MSG_PUB.Add;
7265: end if;
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' ) ;

Line 7277: OE_MSG_PUB.Add;

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
7280: OE_MSG_PUB.Add;
7281: end if;

Line 7280: OE_MSG_PUB.Add;

7276: else
7277: OE_MSG_PUB.Add;
7278: end if;
7279: else
7280: OE_MSG_PUB.Add;
7281: end if;
7282: End if; /* wrong pricing status code */
7283:
7284: --RAISE FND_API.G_EXC_ERROR;

Line 7326: OE_MSG_PUB.Add;

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)
7329: Then
7330:

Line 7338: OE_MSG_PUB.Add;

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;
7342: l_list_line_no:=get_list_lines(wrong_line.line_id);

Line 7347: OE_MSG_PUB.Add;

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
7351: oe_debug_pub.add( 'MODIFIERS:'||GET_LIST_LINES ( WRONG_LINE.LINE_ID ) ) ;

Line 7360: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');

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');
7361: -- 4919922
7362: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7363: IF (G_REQUEST_ID IS NULL) THEN
7364: select oe_msg_request_id_s.nextval into g_request_id from dual;

Line 7366: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');

7362: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7363: IF (G_REQUEST_ID IS NULL) THEN
7364: select oe_msg_request_id_s.nextval into g_request_id from dual;
7365: END IF;
7366: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7367: END IF;
7368:
7369: ELSE
7370: RAISE FND_API.G_EXC_ERROR;

Line 7380: OE_MSG_PUB.Add;

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

Line 7386: OE_MSG_PUB.Add;

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
7390:

Line 7400: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');

7396: END IF;
7397: pricing_errors_hold(l_line_rec.header_id,l_line_rec.line_id,vmsg);
7398: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7399:
7400: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7401: -- 4919922
7402: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7403: IF (G_REQUEST_ID IS NULL) THEN
7404: select oe_msg_request_id_s.nextval into g_request_id from dual;

Line 7406: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');

7402: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7403: IF (G_REQUEST_ID IS NULL) THEN
7404: select oe_msg_request_id_s.nextval into g_request_id from dual;
7405: END IF;
7406: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7407: END IF;
7408:
7409: else
7410: oe_debug_pub.add('has invalid line');

Line 7419: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');

7415: l_temp_line_rec.pricing_quantity := Wrong_line.priced_quantity;
7416: oe_debug_pub.add('has invalid line4');
7417: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7418:
7419: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7420: -- 4919922
7421: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7422: IF (G_REQUEST_ID IS NULL) THEN
7423: select oe_msg_request_id_s.nextval into g_request_id from dual;

Line 7425: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');

7421: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7422: IF (G_REQUEST_ID IS NULL) THEN
7423: select oe_msg_request_id_s.nextval into g_request_id from dual;
7424: END IF;
7425: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7426: END IF;
7427:
7428: oe_debug_pub.add('has invalid line 5');
7429: Oe_Order_Adj_Pvt.Reset_Fields(l_temp_line_rec);

Line 7437: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');

7433: l_temp_line_rec.ordered_quantity := Wrong_line.line_quantity;
7434: l_temp_line_rec.pricing_quantity := Wrong_line.priced_quantity;
7435: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7436:
7437: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7438: -- 4919922
7439: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7440: IF (G_REQUEST_ID IS NULL) THEN
7441: select oe_msg_request_id_s.nextval into g_request_id from dual;

Line 7443: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');

7439: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7440: IF (G_REQUEST_ID IS NULL) THEN
7441: select oe_msg_request_id_s.nextval into g_request_id from dual;
7442: END IF;
7443: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7444: END IF;
7445:
7446: Oe_Order_Adj_Pvt.Reset_Fields(l_temp_line_rec);
7447: end if;

Line 7461: OE_MSG_PUB.ADD;

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:
7464: If book_line.unit_price IS NULL
7465: Then

Line 7477: OE_MSG_PUB.ADD;

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;
7479: l_temp_line_rec.ordered_quantity := book_line.line_quantity;
7480: l_temp_line_rec.pricing_quantity := book_line.priced_quantity;
7481: Oe_Order_Adj_Pvt.Reset_Fields(l_temp_line_rec);

Line 7485: OE_MSG_PUB.ADD;

7481: Oe_Order_Adj_Pvt.Reset_Fields(l_temp_line_rec);
7482: RAISE FND_API.G_EXC_ERROR;
7483: end if;
7484: else
7485: OE_MSG_PUB.ADD;
7486: end if;
7487: End If;
7488:
7489: If book_line.price_list_header_id IS NULL Then

Line 7492: OE_MSG_PUB.ADD;

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;
7496: RAISE FND_API.G_EXC_ERROR;

Line 7735: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7731: IF l_debug_level > 0 THEN
7732: oe_debug_pub.add( SQLERRM , 1 ) ;
7733: END IF;
7734:
7735: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7736: THEN
7737: OE_MSG_PUB.Add_Exc_Msg
7738: ( G_PKG_NAME
7739: , 'Process_Adjustments',

Line 7737: OE_MSG_PUB.Add_Exc_Msg

7733: END IF;
7734:
7735: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7736: THEN
7737: OE_MSG_PUB.Add_Exc_Msg
7738: ( G_PKG_NAME
7739: , 'Process_Adjustments',
7740: sqlerrm
7741: );

Line 7925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

7921: IF l_debug_level > 0 THEN
7922: oe_debug_pub.add( SQLERRM , 1 ) ;
7923: END IF;
7924:
7925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7926: THEN
7927: OE_MSG_PUB.Add_Exc_Msg
7928: ( G_PKG_NAME
7929: , 'Price_line'

Line 7927: OE_MSG_PUB.Add_Exc_Msg

7923: END IF;
7924:
7925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7926: THEN
7927: OE_MSG_PUB.Add_Exc_Msg
7928: ( G_PKG_NAME
7929: , 'Price_line'
7930: );
7931: END IF;