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);
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:
800: when others then
801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add('Unexpected error: '||sqlerrm);
803: END IF;
804: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
805: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');
806: END IF;
807: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add('Unexpected error: '||sqlerrm);
803: END IF;
804: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
805: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');
806: END IF;
807: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809:
1095: when others then
1096: IF l_debug_level > 0 THEN
1097: oe_debug_pub.add('others exception when attempting update' ||sqlerrm);
1098: END IF;
1099: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1100: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');
1101: END IF;
1102: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1096: IF l_debug_level > 0 THEN
1097: oe_debug_pub.add('others exception when attempting update' ||sqlerrm);
1098: END IF;
1099: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1100: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');
1101: END IF;
1102: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: end;
1181: WHEN OTHERS THEN
1182: IF l_debug_level > 0 THEN
1183: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
1184: END IF;
1185: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1186: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
1187: END IF;
1188:
1189: retcode := 2;
1182: IF l_debug_level > 0 THEN
1183: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
1184: END IF;
1185: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1186: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
1187: END IF;
1188:
1189: retcode := 2;
1190: