5769: END IF;
5770: --
5771: EXCEPTION
5772: WHEN OTHERS THEN
5773: FND_File.Put_Line(Fnd_File.LOG,'Into when others of bulk_insert');
5774: FND_File.Put_Line(Fnd_File.LOG,'SQLERRM:'||substr(SQLERRM,1,200));
5775: csi_gen_utility_pvt.put_line('SQLERRM:'||substr(SQLERRM,1,200));
5776: ROLLBACK TO Bulk_Insert;
5777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5770: --
5771: EXCEPTION
5772: WHEN OTHERS THEN
5773: FND_File.Put_Line(Fnd_File.LOG,'Into when others of bulk_insert');
5774: FND_File.Put_Line(Fnd_File.LOG,'SQLERRM:'||substr(SQLERRM,1,200));
5775: csi_gen_utility_pvt.put_line('SQLERRM:'||substr(SQLERRM,1,200));
5776: ROLLBACK TO Bulk_Insert;
5777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5778: END Bulk_Insert;
7654: p_data => x_msg_data
7655: );
7656:
7657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7658: FND_File.Put_Line(Fnd_File.LOG,'Into unexpected exception of grp.create_item_instance');
7659: FND_File.Put_Line(Fnd_File.LOG,'SQLERRM:'||substr(SQLERRM,1,200));
7660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7661: ROLLBACK TO create_item_instance;
7662: FND_MSG_PUB.Count_And_Get
7655: );
7656:
7657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7658: FND_File.Put_Line(Fnd_File.LOG,'Into unexpected exception of grp.create_item_instance');
7659: FND_File.Put_Line(Fnd_File.LOG,'SQLERRM:'||substr(SQLERRM,1,200));
7660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7661: ROLLBACK TO create_item_instance;
7662: FND_MSG_PUB.Count_And_Get
7663: ( p_count => x_msg_count,
7664: p_data => x_msg_data
7665: );
7666:
7667: WHEN OTHERS THEN
7668: FND_File.Put_Line(Fnd_File.LOG,'Into when others exception of grp.create_item_instance');
7669: FND_File.Put_Line(Fnd_File.LOG,'SQLERRM:'||substr(SQLERRM,1,200));
7670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7671: ROLLBACK TO create_item_instance;
7672: IF FND_MSG_PUB.Check_Msg_Level
7665: );
7666:
7667: WHEN OTHERS THEN
7668: FND_File.Put_Line(Fnd_File.LOG,'Into when others exception of grp.create_item_instance');
7669: FND_File.Put_Line(Fnd_File.LOG,'SQLERRM:'||substr(SQLERRM,1,200));
7670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7671: ROLLBACK TO create_item_instance;
7672: IF FND_MSG_PUB.Check_Msg_Level
7673: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)