91: -- ROLLBACK;
92: RAISE FND_API.G_EXC_ERROR;
93: WHEN OTHERS THEN
94: -- ROLLBACK;
95: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
96: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
97: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
98: FND_MSG_PUB.Add;
99: RAISE FND_API.G_EXC_ERROR;
92: RAISE FND_API.G_EXC_ERROR;
93: WHEN OTHERS THEN
94: -- ROLLBACK;
95: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
96: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
97: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
98: FND_MSG_PUB.Add;
99: RAISE FND_API.G_EXC_ERROR;
100:
93: WHEN OTHERS THEN
94: -- ROLLBACK;
95: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
96: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
97: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
98: FND_MSG_PUB.Add;
99: RAISE FND_API.G_EXC_ERROR;
100:
101: END Instantiate_workflow_process ;
138: -- ROLLBACK;
139: RAISE FND_API.G_EXC_ERROR;
140: WHEN OTHERS THEN
141: -- ROLLBACK;
142: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
143: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
144: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
145: FND_MSG_PUB.Add;
146: RAISE FND_API.G_EXC_ERROR;
139: RAISE FND_API.G_EXC_ERROR;
140: WHEN OTHERS THEN
141: -- ROLLBACK;
142: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
143: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
144: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
145: FND_MSG_PUB.Add;
146: RAISE FND_API.G_EXC_ERROR;
147:
140: WHEN OTHERS THEN
141: -- ROLLBACK;
142: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
143: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
144: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
145: FND_MSG_PUB.Add;
146: RAISE FND_API.G_EXC_ERROR;
147:
148: END Import_Post_Process ;