DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_MAIN_PVT dependencies on OE_MSG_PUB

Line 62: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

58: WHEN OTHERS THEN
59: IF l_debug_level > 0 THEN
60: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
61: END IF;
62: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
63: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order_stats');
64: END IF;
65:
66: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);

Line 63: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order_stats');

59: IF l_debug_level > 0 THEN
60: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
61: END IF;
62: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
63: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order_stats');
64: END IF;
65:
66: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
67:

Line 803: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

799: when others then
800: IF l_debug_level > 0 THEN
801: oe_debug_pub.add('Unexpected error: '||sqlerrm);
802: END IF;
803: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
804: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');
805: END IF;
806: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 804: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');

800: IF l_debug_level > 0 THEN
801: oe_debug_pub.add('Unexpected error: '||sqlerrm);
802: END IF;
803: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
804: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');
805: END IF;
806: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
808:

Line 1098: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1094: when others then
1095: IF l_debug_level > 0 THEN
1096: oe_debug_pub.add('others exception when attempting update' ||sqlerrm);
1097: END IF;
1098: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1099: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');
1100: END IF;
1101: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1099: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');

1095: IF l_debug_level > 0 THEN
1096: oe_debug_pub.add('others exception when attempting update' ||sqlerrm);
1097: END IF;
1098: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1099: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');
1100: END IF;
1101: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1103: end;

Line 1184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1180: WHEN OTHERS THEN
1181: IF l_debug_level > 0 THEN
1182: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
1183: END IF;
1184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1185: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
1186: END IF;
1187:
1188: retcode := 2;

Line 1185: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');

1181: IF l_debug_level > 0 THEN
1182: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
1183: END IF;
1184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1185: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
1186: END IF;
1187:
1188: retcode := 2;
1189: