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

Line 170: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

166: WHEN FND_API.G_EXC_ERROR THEN
167: g_ser_cascade := FALSE;
168: x_return_status := FND_API.G_RET_STS_ERROR;
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
171: oe_msg_pub.Add_Exc_Msg
172: (G_PKG_NAME
173: ,l_api_name);
174: END IF;

Line 171: oe_msg_pub.Add_Exc_Msg

167: g_ser_cascade := FALSE;
168: x_return_status := FND_API.G_RET_STS_ERROR;
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
171: oe_msg_pub.Add_Exc_Msg
172: (G_PKG_NAME
173: ,l_api_name);
174: END IF;
175: g_ser_cascade := FALSE;

Line 182: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

178: g_ser_cascade := FALSE;
179: IF l_debug_level > 0 THEN
180: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
181: END IF;
182: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
183: oe_msg_pub.Add_Exc_Msg
184: (G_PKG_NAME
185: ,l_api_name);
186: END IF;

Line 183: oe_msg_pub.Add_Exc_Msg

179: IF l_debug_level > 0 THEN
180: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
181: END IF;
182: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
183: oe_msg_pub.Add_Exc_Msg
184: (G_PKG_NAME
185: ,l_api_name);
186: END IF;
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 377: oe_msg_pub.add;

373: WHEN NO_DATA_FOUND THEN
374: NULL;
375: WHEN TOO_MANY_ROWS THEN
376: fnd_message.set_name('ONT','OE_CAN_UPDATE_SUPPLY');
377: oe_msg_pub.add;
378: raise FND_API.G_EXC_ERROR;
379: END;
380:
381: IF p_old_line_rec.ordered_quantity <> l_mtl_supply_quantity THEN

Line 384: oe_msg_pub.add;

380:
381: IF p_old_line_rec.ordered_quantity <> l_mtl_supply_quantity THEN
382:
383: fnd_message.set_name('ONT','OE_CAN_UPDATE_SUPPLY');
384: oe_msg_pub.add;
385: raise FND_API.G_EXC_ERROR;
386: END IF;
387:
388: END IF; -- 6710187 end

Line 410: oe_msg_pub.add;

406: END IF;
407:
408: IF po_supply_id IS NULL THEN
409: fnd_message.set_name('ONT','OE_CAN_NO_SUPPLY_ID');
410: oe_msg_pub.add;
411: -- raise FND_API.G_EXC_ERROR;
412: END IF;
413: END IF;
414: END IF; -- For cancellation

Line 442: oe_msg_pub.add;

438: IF l_debug_level > 0 THEN
439: oe_debug_pub.add('Cancellation Reason is Not Provided',1);
440: END IF;
441: fnd_message.set_name('ONT','OE_CAN_REASON_NOT');
442: oe_msg_pub.add;
443: raise FND_API.G_EXC_ERROR;
444: END IF;
445: END IF;
446:

Line 454: oe_msg_pub.add;

450: IF l_debug_level > 0 THEN
451: oe_debug_pub.add('Cancellation Reason is Not Provided',1);
452: END IF;
453: fnd_message.set_name('ONT','OE_CAN_REASON_NOT');
454: oe_msg_pub.add;
455: raise FND_API.G_EXC_ERROR;
456: END IF;
457: -- END IF;
458: END IF;

Line 659: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

655: EXCEPTION
656: WHEN FND_API.G_EXC_ERROR THEN
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
659: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
660: oe_msg_pub.Add_Exc_Msg
661: (G_PKG_NAME
662: ,l_api_name);
663: END IF;

Line 660: oe_msg_pub.Add_Exc_Msg

656: WHEN FND_API.G_EXC_ERROR THEN
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
659: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
660: oe_msg_pub.Add_Exc_Msg
661: (G_PKG_NAME
662: ,l_api_name);
663: END IF;
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 669: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

665: WHEN OTHERS THEN
666: IF l_debug_level > 0 THEN
667: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || 'PERFORM_LINE_CHANGE' ) ;
668: END IF;
669: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
670: oe_msg_pub.Add_Exc_Msg
671: (G_PKG_NAME
672: ,l_api_name);
673: END IF;

Line 670: oe_msg_pub.Add_Exc_Msg

666: IF l_debug_level > 0 THEN
667: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || 'PERFORM_LINE_CHANGE' ) ;
668: END IF;
669: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
670: oe_msg_pub.Add_Exc_Msg
671: (G_PKG_NAME
672: ,l_api_name);
673: END IF;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 713: oe_msg_pub.add;

709: END IF;
710:
711: if ( p_old_line_rec.cancelled_flag = 'Y') then
712: fnd_message.set_name('ONT', 'OE_CANCEL_NOTHING');
713: oe_msg_pub.add;
714: RAISE FND_API.G_EXC_ERROR ;
715: end if;
716:
717: -- Check if line is booked and and is not a cancellations and orderquantity is

Line 732: oe_msg_pub.add;

728: IF (nvl(p_x_line_rec.booked_flag,'N') = 'Y' AND
729: nvl(p_x_line_rec.ordered_quantity,0) = 0 ) THEN
730:
731: fnd_message.set_name('ONT', 'OE_QTY_ZERO_NOT_ALLOWED');
732: oe_msg_pub.add;
733: RAISE FND_API.G_EXC_ERROR ;
734: END IF;
735: END IF;
736:

Line 747: oe_msg_pub.add;

743:
744: if (p_x_line_rec.Ordered_Quantity <>
745: p_old_line_rec.Ordered_Quantity) THEN
746: fnd_message.set_name('ONT', 'OE_CAN_SERV_AMT_NOT_ALLOWED');
747: oe_msg_pub.add;
748: RAISE FND_API.G_EXC_ERROR;
749: end if;
750: end if;
751:

Line 800: oe_msg_pub.add;*/

796: END IF;
797:
798: IF p_x_line_rec.change_reason IS NULL THEN
799: /*fnd_message.set_name('ONT','OE_CAN_REASON_NOT');
800: oe_msg_pub.add;*/
801: NULL;
802: END IF;
803:
804: IF l_debug_level > 0 THEN

Line 902: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

898: EXCEPTION
899: WHEN FND_API.G_EXC_ERROR THEN
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
903: oe_msg_pub.Add_Exc_Msg
904: (G_PKG_NAME
905: ,l_api_name);
906: END IF;

Line 903: oe_msg_pub.Add_Exc_Msg

899: WHEN FND_API.G_EXC_ERROR THEN
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
903: oe_msg_pub.Add_Exc_Msg
904: (G_PKG_NAME
905: ,l_api_name);
906: END IF;
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 912: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

908: WHEN OTHERS THEN
909: IF l_debug_level > 0 THEN
910: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
911: END IF;
912: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
913: oe_msg_pub.Add_Exc_Msg
914: (G_PKG_NAME
915: ,l_api_name);
916: END IF;

Line 913: oe_msg_pub.Add_Exc_Msg

909: IF l_debug_level > 0 THEN
910: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
911: END IF;
912: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
913: oe_msg_pub.Add_Exc_Msg
914: (G_PKG_NAME
915: ,l_api_name);
916: END IF;
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1002: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1002: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1003: oe_msg_pub.Add_Exc_Msg
1004: (G_PKG_NAME
1005: ,l_api_name);
1006: END IF;

Line 1003: oe_msg_pub.Add_Exc_Msg

999: WHEN FND_API.G_EXC_ERROR THEN
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1002: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1003: oe_msg_pub.Add_Exc_Msg
1004: (G_PKG_NAME
1005: ,l_api_name);
1006: END IF;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1012: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1008: WHEN OTHERS THEN
1009: IF l_debug_level > 0 THEN
1010: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
1011: END IF;
1012: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1013: oe_msg_pub.Add_Exc_Msg
1014: (G_PKG_NAME
1015: ,l_api_name);
1016: END IF;

Line 1013: oe_msg_pub.Add_Exc_Msg

1009: IF l_debug_level > 0 THEN
1010: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
1011: END IF;
1012: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1013: oe_msg_pub.Add_Exc_Msg
1014: (G_PKG_NAME
1015: ,l_api_name);
1016: END IF;
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1179: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1175: EXCEPTION
1176: WHEN FND_API.G_EXC_ERROR THEN
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1180: oe_msg_pub.Add_Exc_Msg
1181: (G_PKG_NAME
1182: ,l_api_name);
1183: END IF;

Line 1180: oe_msg_pub.Add_Exc_Msg

1176: WHEN FND_API.G_EXC_ERROR THEN
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1180: oe_msg_pub.Add_Exc_Msg
1181: (G_PKG_NAME
1182: ,l_api_name);
1183: END IF;
1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1189: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1185: WHEN OTHERS THEN
1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
1188: END IF;
1189: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1190: oe_msg_pub.Add_Exc_Msg
1191: (G_PKG_NAME
1192: ,l_api_name);
1193: END IF;

Line 1190: oe_msg_pub.Add_Exc_Msg

1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
1188: END IF;
1189: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1190: oe_msg_pub.Add_Exc_Msg
1191: (G_PKG_NAME
1192: ,l_api_name);
1193: END IF;
1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1245: oe_msg_pub.add;

1241: oe_debug_pub.add( 'CHANGE REASON IS REQUIRED' ) ;
1242: END IF;
1243: IF p_header_rec.change_reason IS NULL THEN
1244: fnd_message.set_name('ONT','OE_CAN_REASON_NOT');
1245: oe_msg_pub.add;
1246: raise FND_API.G_EXC_ERROR;
1247: END IF;
1248: END IF;
1249:

Line 1505: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1502: WHEN OTHERS THEN
1503: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1506: oe_msg_pub.Add_Exc_Msg
1507: (G_PKG_NAME
1508: ,'Peform_Cancel_order');
1509: END IF;

Line 1506: oe_msg_pub.Add_Exc_Msg

1502: WHEN OTHERS THEN
1503: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1506: oe_msg_pub.Add_Exc_Msg
1507: (G_PKG_NAME
1508: ,'Peform_Cancel_order');
1509: END IF;
1510:

Line 1603: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1599: x_return_status := FND_API.G_RET_STS_ERROR;
1600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: WHEN OTHERS THEN
1603: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1604: oe_msg_pub.Add_Exc_Msg
1605: (G_PKG_NAME
1606: ,'PeformLineCancellation');
1607: END IF;

Line 1604: oe_msg_pub.Add_Exc_Msg

1600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: WHEN OTHERS THEN
1603: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1604: oe_msg_pub.Add_Exc_Msg
1605: (G_PKG_NAME
1606: ,'PeformLineCancellation');
1607: END IF;
1608: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1647: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1644:
1645: WHEN OTHERS THEN
1646:
1647: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1648: THEN
1649: oe_msg_pub.Add_Exc_Msg
1650: ( G_PKG_NAME
1651: , 'Query_Rows'

Line 1649: oe_msg_pub.Add_Exc_Msg

1645: WHEN OTHERS THEN
1646:
1647: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1648: THEN
1649: oe_msg_pub.Add_Exc_Msg
1650: ( G_PKG_NAME
1651: , 'Query_Rows'
1652: );
1653: END IF;

Line 1770: OE_MSG_PUB.Add_Text(p_message_text => l_msg_data);

1766: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1767: IF l_debug_level > 0 THEN
1768: oe_debug_pub.add('Exception from Process_Fulfillment:'||l_result_out,2);
1769: END IF;
1770: OE_MSG_PUB.Add_Text(p_message_text => l_msg_data);
1771: OE_MSG_PUB.Save_API_Messages;
1772:
1773: ROLLBACK TO Process_Set;
1774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1771: OE_MSG_PUB.Save_API_Messages;

1767: IF l_debug_level > 0 THEN
1768: oe_debug_pub.add('Exception from Process_Fulfillment:'||l_result_out,2);
1769: END IF;
1770: OE_MSG_PUB.Add_Text(p_message_text => l_msg_data);
1771: OE_MSG_PUB.Save_API_Messages;
1772:
1773: ROLLBACK TO Process_Set;
1774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1775:

Line 2001: OE_MSG_PUB.ADD;

1997:
1998: IF l_line_tbl.count = 0 THEN
1999: FND_MESSAGE.SET_NAME('ONT','OE_NO_ELIGIBLE_LINES');
2000: FND_MESSAGE.SET_TOKEN('ORDER', L_header_rec.Order_Number);
2001: OE_MSG_PUB.ADD;
2002: RAISE FND_API.G_EXC_ERROR;
2003: END IF;
2004:
2005: IF l_debug_level > 0 THEN

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

2059: x_return_status := FND_API.G_RET_STS_ERROR;
2060: WHEN OTHERS THEN
2061: g_par_ord_lvl_can := FALSE;
2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2063: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2064: THEN
2065: OE_MSG_PUB.Add_Exc_Msg
2066: ( G_PKG_NAME ,
2067: 'Cancel Remaining Order'

Line 2065: OE_MSG_PUB.Add_Exc_Msg

2061: g_par_ord_lvl_can := FALSE;
2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2063: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2064: THEN
2065: OE_MSG_PUB.Add_Exc_Msg
2066: ( G_PKG_NAME ,
2067: 'Cancel Remaining Order'
2068: );
2069: END IF;

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

2162: WHEN OTHERS THEN
2163:
2164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2165:
2166: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2167: THEN
2168: OE_MSG_PUB.Add_Exc_Msg
2169: ( G_PKG_NAME
2170: , 'CANCEL_WF' );

Line 2168: OE_MSG_PUB.Add_Exc_Msg

2164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2165:
2166: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2167: THEN
2168: OE_MSG_PUB.Add_Exc_Msg
2169: ( G_PKG_NAME
2170: , 'CANCEL_WF' );
2171: END IF;
2172: