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 323: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 325: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 620: OE_MSG_PUB.Add_Exc_Msg

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

Line 1836: OE_MSG_PUB.Add;

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

Line 2448: OE_MSG_PUB.set_msg_context

2444: IF l_debug_level > 0 THEN
2445: oe_debug_pub.add( 'LINE ID'||L_LINE_REC.LINE_ID ) ;
2446: END IF;
2447: -- bug 4866684 setting the msg context
2448: OE_MSG_PUB.set_msg_context
2449: ( p_entity_code => 'LINE'
2450: ,p_entity_id => l_line_rec.line_id
2451: ,p_header_id => l_line_rec.header_id
2452: ,p_line_id => l_line_rec.line_id

Line 2663: OE_MSG_PUB.Add;*/

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

Line 2672: OE_MSG_PUB.Add;

2668: l_msg_text := nvl(i.ordered_item,i.inventory_item_id);
2669: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',l_line_num);
2670: FND_MESSAGE.SET_TOKEN('ITEM_NAME',l_msg_text);
2671: FND_MESSAGE.SET_TOKEN('GSA_PRICE',i.pricing_status_text);
2672: OE_MSG_PUB.Add;
2673: END IF ;
2674: g_lineid_tbl(l_mod_lineid) := i.line_id ;
2675: --3021992 ends
2676: ELSE -- violation action is error

Line 2686: OE_MSG_PUB.Add;

2682: If i.line_id is null or
2683: i.line_id = fnd_api.g_miss_num then
2684: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
2685: FND_MESSAGE.SET_TOKEN('ERR_TEXT','GSA_INVALID_LINE_ID');
2686: OE_MSG_PUB.Add;
2687: RAISE FND_API.G_EXC_ERROR;
2688: End if;
2689:
2690: G_STMT_NO := 'Gsa_Check#20.20';

Line 2747: OE_MSG_PUB.Add;*/

2743:
2744: If l_return_status = FND_API.g_ret_sts_success then
2745:
2746: /*FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');
2747: OE_MSG_PUB.Add;*/
2748: --3021992
2749: if not(g_lineid_tbl.EXISTS(l_mod_lineid)) THEN
2750: FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');
2751: OE_MSG_PUB.Add;

Line 2751: OE_MSG_PUB.Add;

2747: OE_MSG_PUB.Add;*/
2748: --3021992
2749: if not(g_lineid_tbl.EXISTS(l_mod_lineid)) THEN
2750: FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');
2751: OE_MSG_PUB.Add;
2752: END IF;
2753: g_lineid_tbl(l_mod_lineid) := i.line_id;
2754: --3021992 ends
2755:

Line 2759: OE_MSG_PUB.Add;

2755:
2756: Else
2757: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
2758: FND_MESSAGE.SET_TOKEN('ERR_TEXT','APPLY_GSA_HOLD');
2759: OE_MSG_PUB.Add;
2760: RAISE FND_API.G_EXC_ERROR;
2761: End If;
2762: End If; /* check hold */
2763: End if; --for bug 2028480

Line 3420: OE_MSG_PUB.Add;

3416: oe_debug_pub.add('in lock record exception, someone else working on the row');
3417: END IF;
3418:
3419: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
3420: OE_MSG_PUB.Add;
3421: RAISE fnd_api.g_exc_unexpected_error;
3422: WHEN OTHERS
3423: THEN
3424: IF l_debug_level > 0 THEN

Line 3939: OE_MSG_PUB.Add;

3935: IF l_debug_level > 0 THEN
3936: oe_debug_pub.add('in lock record exception, someone else working on the row');
3937: END IF;
3938: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
3939: OE_MSG_PUB.Add;
3940: RAISE FND_API.G_EXC_ERROR;
3941:
3942: WHEN NO_DATA_FOUND THEN
3943: IF l_debug_level > 0 THEN

Line 5766: oe_msg_pub.transfer_msg_stack;

5762: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5763: IF l_debug_level > 0 THEN
5764: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5765: END IF;
5766: oe_msg_pub.transfer_msg_stack;
5767: RAISE FND_API.G_EXC_ERROR;
5768: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5769: IF l_debug_level > 0 THEN
5770: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);

Line 5772: oe_msg_pub.transfer_msg_stack;

5768: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5769: IF l_debug_level > 0 THEN
5770: oe_debug_pub.add('Error getting secondary UOM/quantity from WMS API. Return Status: '||x_return_status||' msg_count:'||x_msg_count);
5771: END IF;
5772: oe_msg_pub.transfer_msg_stack;
5773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5774: END IF;
5775:
5776: l_req_line_rec.LINE_QUANTITY := x_secondary_quantity;

Line 5823: OE_MSG_PUB.Add;

5819: IF l_debug_level > 0 THEN
5820: oe_debug_pub.add('Shipped_quantity2 is null and not dropship, return- Raise error');
5821: END IF;
5822: FND_MESSAGE.SET_NAME('ONT','ONT_CATCHWEIGHT_QTY2_REQUIRED');
5823: OE_MSG_PUB.Add;
5824: RAISE FND_API.G_EXC_ERROR;
5825: END IF; -- end checks for source_type_code
5826: END IF; -- end checks for shipped_quantity2
5827: END IF; -- end check for shipped_quantity

Line 6001: OE_MSG_PUB.Add;

5997: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
5998: END IF;
5999: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
6000: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
6001: OE_MSG_PUB.Add;
6002: RAISE FND_API.G_EXC_ERROR;
6003: END IF;
6004:
6005: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN

Line 6046: OE_MSG_PUB.Add;

6042: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
6043: END IF;
6044: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
6045: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
6046: OE_MSG_PUB.Add;
6047: raise fnd_api.g_exc_unexpected_error;
6048: END IF;
6049:
6050: END IF;

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

6266: and p_control_rec.p_use_current_header = FALSE
6267: then
6268: l_return_status := FND_API.G_RET_STS_ERROR;
6269:
6270: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6271: THEN
6272:
6273: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
6274: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id or Header Id ');

Line 6275: OE_MSG_PUB.Add;

6271: THEN
6272:
6273: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
6274: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id or Header Id ');
6275: OE_MSG_PUB.Add;
6276: END IF;
6277: RAISE FND_API.G_EXC_ERROR;
6278: end if;
6279:

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

6278: end if;
6279:
6280: G_STMT_NO := 'calculate_adjustments#20';
6281: if p_Line_id is not null and p_Header_id is not null then
6282: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6283: THEN
6284: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,
6285: 'oe_line_adj.calulate_adjustments'
6286: ,'Keys are mutually exclusive');

Line 6284: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,

6280: G_STMT_NO := 'calculate_adjustments#20';
6281: if p_Line_id is not null and p_Header_id is not null then
6282: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6283: THEN
6284: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,
6285: 'oe_line_adj.calulate_adjustments'
6286: ,'Keys are mutually exclusive');
6287: END IF;
6288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6491: OE_MSG_PUB.Add;

6487: End;
6488: fnd_message.set_name('ONT','ONT_INVALID_AGR_REVISION');
6489: fnd_message.set_TOKEN('AGREEMENT',l_agreement_name||' : '||l_revision);
6490: fnd_message.set_TOKEN('PRICING_DATE',l_line_tbl(line_Tbl_Index).PRICING_DATE);
6491: OE_MSG_PUB.Add;
6492: RAISE FND_API.G_EXC_ERROR;
6493: END;
6494: End If;
6495: --End 2740845

Line 7031: OE_MSG_PUB.Add;

7027:
7028: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7029: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7030: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
7031: OE_MSG_PUB.Add;
7032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7033: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7034: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7035: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);

Line 7036: OE_MSG_PUB.Add;

7032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7033: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
7034: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7035: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
7036: OE_MSG_PUB.Add;
7037: RAISE FND_API.G_EXC_ERROR;
7038: END IF;
7039:
7040: END Call_Pricing_Engine;

Line 7109: OE_MSG_PUB.Add;

7105: END IF;
7106:
7107: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERROR_HOLD');
7108: FND_MESSAGE.SET_TOKEN('ERR_TEXT',pmsg);
7109: OE_MSG_PUB.Add;
7110: End if;
7111: exception
7112: WHEN FND_API.G_EXC_ERROR then
7113: null;

Line 7265: OE_MSG_PUB.set_msg_context

7261: J:= px_Line_Tbl.next(j);
7262: end loop;
7263: End If;
7264:
7265: OE_MSG_PUB.set_msg_context
7266: ( p_entity_code => 'LINE'
7267: ,p_entity_id => l_line_rec.line_id
7268: ,p_header_id => l_line_rec.header_id
7269: ,p_line_id => l_line_rec.line_id

Line 7305: OE_MSG_PUB.Add;

7301: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7302: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7303: vmsg := FND_MESSAGE.GET;
7304: else
7305: OE_MSG_PUB.Add;
7306: end if;
7307: ELSE
7308: OE_MSG_PUB.Add;
7309: END IF;

Line 7308: OE_MSG_PUB.Add;

7304: else
7305: OE_MSG_PUB.Add;
7306: end if;
7307: ELSE
7308: OE_MSG_PUB.Add;
7309: END IF;
7310: END IF;
7311: l_invalid_line := 'Y';
7312: END IF; */

Line 7359: OE_MSG_PUB.Add;

7355: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7356: IF l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7357: vmsg := FND_MESSAGE.GET;
7358: ELSE
7359: OE_MSG_PUB.Add;
7360: END IF;
7361: ELSE
7362: OE_MSG_PUB.Add;
7363: END IF;

Line 7362: OE_MSG_PUB.Add;

7358: ELSE
7359: OE_MSG_PUB.Add;
7360: END IF;
7361: ELSE
7362: OE_MSG_PUB.Add;
7363: END IF;
7364: ELSE
7365: l_invalid_line := 'N';
7366: End IF;

Line 7382: OE_MSG_PUB.ADD;

7378: oe_debug_pub.add( ' EXCEPTION: PRICE LIST MISSING FOR BOOKED ORDER' ) ;
7379: END IF;
7380: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
7381: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.GET_ATTRIBUTE_NAME('UNIT_LIST_PRICE'));
7382: OE_MSG_PUB.ADD;
7383: -- Bug 8236945
7384: IF OE_GLOBALS.G_UI_FLAG THEN
7385: RAISE FND_API.G_EXC_ERROR;
7386: ELSE

Line 7419: OE_MSG_PUB.Add;

7415: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7416: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7417: vmsg := FND_MESSAGE.GET;
7418: else
7419: OE_MSG_PUB.Add;
7420: end if;
7421: else
7422: OE_MSG_PUB.Add;
7423: end if;

Line 7422: OE_MSG_PUB.Add;

7418: else
7419: OE_MSG_PUB.Add;
7420: end if;
7421: else
7422: OE_MSG_PUB.Add;
7423: end if;
7424: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
7425: IF l_debug_level > 0 THEN
7426: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;

Line 7434: OE_MSG_PUB.Add;

7430: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7431: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7432: vmsg := FND_MESSAGE.GET;
7433: else
7434: OE_MSG_PUB.Add;
7435: end if;
7436: else
7437: OE_MSG_PUB.Add;
7438: end if;

Line 7437: OE_MSG_PUB.Add;

7433: else
7434: OE_MSG_PUB.Add;
7435: end if;
7436: else
7437: OE_MSG_PUB.Add;
7438: end if;
7439: Elsif wrong_line.pricing_status_code in
7440: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
7441: FND_API.G_RET_STS_ERROR)

Line 7452: OE_MSG_PUB.Add;

7448: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7449: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7450: vmsg := FND_MESSAGE.GET;
7451: else
7452: OE_MSG_PUB.Add;
7453: end if;
7454: else
7455: OE_MSG_PUB.Add;
7456: end if;

Line 7455: OE_MSG_PUB.Add;

7451: else
7452: OE_MSG_PUB.Add;
7453: end if;
7454: else
7455: OE_MSG_PUB.Add;
7456: end if;
7457: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
7458: IF l_debug_level > 0 THEN
7459: oe_debug_pub.add( 'INVALID UOM' ) ;

Line 7468: OE_MSG_PUB.Add;

7464: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7465: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7466: vmsg := FND_MESSAGE.GET;
7467: else
7468: OE_MSG_PUB.Add;
7469: end if;
7470: else
7471: OE_MSG_PUB.Add;
7472: end if;

Line 7471: OE_MSG_PUB.Add;

7467: else
7468: OE_MSG_PUB.Add;
7469: end if;
7470: else
7471: OE_MSG_PUB.Add;
7472: end if;
7473: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
7474: IF l_debug_level > 0 THEN
7475: oe_debug_pub.add( 'DUPLICATE PRICE LIST' ) ;

Line 7516: OE_MSG_PUB.Add;

7512: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7513: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7514: vmsg := FND_MESSAGE.GET;
7515: else
7516: OE_MSG_PUB.Add;
7517: end if;
7518: else
7519: OE_MSG_PUB.Add;
7520: end if;

Line 7519: OE_MSG_PUB.Add;

7515: else
7516: OE_MSG_PUB.Add;
7517: end if;
7518: else
7519: OE_MSG_PUB.Add;
7520: end if;
7521: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
7522: IF l_debug_level > 0 THEN
7523: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;

Line 7532: OE_MSG_PUB.Add;

7528: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7529: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7530: vmsg := FND_MESSAGE.GET;
7531: else
7532: OE_MSG_PUB.Add;
7533: end if;
7534: else
7535: OE_MSG_PUB.Add;
7536: end if;

Line 7535: OE_MSG_PUB.Add;

7531: else
7532: OE_MSG_PUB.Add;
7533: end if;
7534: else
7535: OE_MSG_PUB.Add;
7536: end if;
7537: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
7538: IF l_debug_level > 0 THEN
7539: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;

Line 7548: OE_MSG_PUB.Add;

7544: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7545: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7546: vmsg := FND_MESSAGE.GET;
7547: else
7548: OE_MSG_PUB.Add;
7549: end if;
7550: else
7551: OE_MSG_PUB.Add;
7552: end if;

Line 7551: OE_MSG_PUB.Add;

7547: else
7548: OE_MSG_PUB.Add;
7549: end if;
7550: else
7551: OE_MSG_PUB.Add;
7552: end if;
7553: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
7554: IF l_debug_level > 0 THEN
7555: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;

Line 7564: OE_MSG_PUB.Add;

7560: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
7561: if l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM then
7562: vmsg := FND_MESSAGE.GET;
7563: else
7564: OE_MSG_PUB.Add;
7565: end if;
7566: else
7567: OE_MSG_PUB.Add;
7568: end if;

Line 7567: OE_MSG_PUB.Add;

7563: else
7564: OE_MSG_PUB.Add;
7565: end if;
7566: else
7567: OE_MSG_PUB.Add;
7568: end if;
7569: End if; /* wrong pricing status code */
7570:
7571: --RAISE FND_API.G_EXC_ERROR;

Line 7613: OE_MSG_PUB.Add;

7609:
7610: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
7611: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '
7612: ||l_line_rec.Ordered_Item||' ) '||wrong_line.status_text);
7613: OE_MSG_PUB.Add;
7614: elsif wrong_line.line_type_code='LINE' and
7615: (wrong_line.unit_price <0 or wrong_line.adjusted_unit_price<0)
7616: Then
7617:

Line 7625: OE_MSG_PUB.Add;

7621: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
7622: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_line_rec.Ordered_Item,l_line_rec.inventory_item_id));
7623: FND_MESSAGE.SET_TOKEN('LIST_PRICE',wrong_line.unit_price);
7624: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',wrong_line.Adjusted_unit_price);
7625: OE_MSG_PUB.Add;
7626: IF l_debug_level > 0 THEN
7627: oe_debug_pub.add( 'BEFORE SHOWING NEGATIVE MODIFIERS MESSAGE' ) ;
7628: END IF;
7629: l_list_line_no:=get_list_lines(wrong_line.line_id);

Line 7634: OE_MSG_PUB.Add;

7630:
7631: IF l_list_line_no IS NOT NULL THEN
7632: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_MODIFIERS');
7633: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(wrong_line.line_id));
7634: OE_MSG_PUB.Add;
7635: END IF;
7636:
7637: IF l_debug_level > 0 THEN
7638: oe_debug_pub.add( 'MODIFIERS:'||GET_LIST_LINES ( WRONG_LINE.LINE_ID ) ) ;

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

7643: vmsg := FND_MESSAGE.GET;
7644: oe_debug_pub.add('vmsg = '||vmsg,1);
7645: pricing_errors_hold(l_line_rec.header_id,l_line_rec.line_id,vmsg);
7646: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7647: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7648: -- 4919922
7649: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7650: IF (G_REQUEST_ID IS NULL) THEN
7651: select oe_msg_request_id_s.nextval into g_request_id from dual;

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

7649: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7650: IF (G_REQUEST_ID IS NULL) THEN
7651: select oe_msg_request_id_s.nextval into g_request_id from dual;
7652: END IF;
7653: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7654: END IF;
7655:
7656: ELSE
7657: RAISE FND_API.G_EXC_ERROR;

Line 7667: OE_MSG_PUB.Add;

7663: if wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
7664: oe_debug_pub.add( 'ERROR IN ORDER LEVEL FORMULA PROCESSING' ) ;
7665: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
7666: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text||','||get_formula(wrong_line.line_index));
7667: OE_MSG_PUB.Add;
7668: vmsg := FND_MESSAGE.GET;
7669: else
7670: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
7671: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497

Line 7673: OE_MSG_PUB.Add;

7669: else
7670: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
7671: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
7672: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
7673: OE_MSG_PUB.Add;
7674: vmsg := FND_MESSAGE.GET;
7675: end if;
7676: END IF; --end if for 'ORDER' line_type_code
7677:

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

7683: END IF;
7684: pricing_errors_hold(l_line_rec.header_id,l_line_rec.line_id,vmsg);
7685: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7686:
7687: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7688: -- 4919922
7689: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7690: IF (G_REQUEST_ID IS NULL) THEN
7691: select oe_msg_request_id_s.nextval into g_request_id from dual;

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

7689: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7690: IF (G_REQUEST_ID IS NULL) THEN
7691: select oe_msg_request_id_s.nextval into g_request_id from dual;
7692: END IF;
7693: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7694: END IF;
7695:
7696: else
7697: oe_debug_pub.add('has invalid line');

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

7702: l_temp_line_rec.pricing_quantity := Wrong_line.priced_quantity;
7703: oe_debug_pub.add('has invalid line4');
7704: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7705:
7706: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7707: -- 4919922
7708: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7709: IF (G_REQUEST_ID IS NULL) THEN
7710: select oe_msg_request_id_s.nextval into g_request_id from dual;

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

7708: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7709: IF (G_REQUEST_ID IS NULL) THEN
7710: select oe_msg_request_id_s.nextval into g_request_id from dual;
7711: END IF;
7712: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7713: END IF;
7714:
7715: oe_debug_pub.add('has invalid line 5');
7716: Oe_Order_Adj_Pvt.Reset_Fields(l_temp_line_rec);

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

7720: l_temp_line_rec.ordered_quantity := Wrong_line.line_quantity;
7721: l_temp_line_rec.pricing_quantity := Wrong_line.priced_quantity;
7722: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7723:
7724: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7725: -- 4919922
7726: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7727: IF (G_REQUEST_ID IS NULL) THEN
7728: select oe_msg_request_id_s.nextval into g_request_id from dual;

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

7726: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7727: IF (G_REQUEST_ID IS NULL) THEN
7728: select oe_msg_request_id_s.nextval into g_request_id from dual;
7729: END IF;
7730: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7731: END IF;
7732:
7733: Oe_Order_Adj_Pvt.Reset_Fields(l_temp_line_rec);
7734: end if;

Line 7748: OE_MSG_PUB.ADD;

7744: If book_line.adjusted_unit_price IS NULL Then
7745: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
7746: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7747: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
7748: OE_MSG_PUB.ADD;
7749: End If;
7750:
7751: If book_line.unit_price IS NULL
7752: Then

Line 7764: OE_MSG_PUB.ADD;

7760: if book_line.shipped_quantity is not null or book_line.shipped_quantity <> FND_API.G_MISS_NUM then
7761: vmsg := FND_MESSAGE.GET;
7762: pricing_errors_hold(book_line.header_id,book_line.line_id,vmsg);
7763: else
7764: OE_MSG_PUB.ADD;
7765: l_temp_line_rec.line_id := book_line.line_id;
7766: l_temp_line_rec.ordered_quantity := book_line.line_quantity;
7767: l_temp_line_rec.pricing_quantity := book_line.priced_quantity;
7768: Oe_Order_Adj_Pvt.Reset_Fields(l_temp_line_rec);

Line 7777: OE_MSG_PUB.ADD;

7773: l_booking_error := 'Y';
7774: END IF;
7775: end if;
7776: else
7777: OE_MSG_PUB.ADD;
7778: end if;
7779: End If;
7780:
7781: If book_line.price_list_header_id IS NULL Then

Line 7784: OE_MSG_PUB.ADD;

7780:
7781: If book_line.price_list_header_id IS NULL Then
7782: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRUIBUTE');
7783: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
7784: OE_MSG_PUB.ADD;
7785: IF l_debug_level > 0 THEN
7786: oe_debug_pub.add( ' ERROR: PRICE LIST ID CAN NOT BE NULL' ) ;
7787: END IF;
7788: -- Bug 8236945

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

8034: IF l_debug_level > 0 THEN
8035: oe_debug_pub.add( SQLERRM , 1 ) ;
8036: END IF;
8037:
8038: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8039: THEN
8040: OE_MSG_PUB.Add_Exc_Msg
8041: ( G_PKG_NAME
8042: , 'Process_Adjustments',

Line 8040: OE_MSG_PUB.Add_Exc_Msg

8036: END IF;
8037:
8038: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8039: THEN
8040: OE_MSG_PUB.Add_Exc_Msg
8041: ( G_PKG_NAME
8042: , 'Process_Adjustments',
8043: sqlerrm
8044: );

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

8383: IF l_debug_level > 0 THEN
8384: oe_debug_pub.add( SQLERRM , 1 ) ;
8385: END IF;
8386:
8387: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8388: THEN
8389: OE_MSG_PUB.Add_Exc_Msg
8390: ( G_PKG_NAME
8391: , 'Price_line'

Line 8389: OE_MSG_PUB.Add_Exc_Msg

8385: END IF;
8386:
8387: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8388: THEN
8389: OE_MSG_PUB.Add_Exc_Msg
8390: ( G_PKG_NAME
8391: , 'Price_line'
8392: );
8393: END IF;