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

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;

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

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:

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

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;

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

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;

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

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;

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

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: