86: 'Exit.');
87: END IF;
88:
89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN
91: -- ROLLBACK;
92: RAISE FND_API.G_EXC_ERROR;
93: WHEN OTHERS THEN
94: -- ROLLBACK;
88:
89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN
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);
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 ;
102:
103:
133: 'Exit.');
134: END IF;
135:
136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
138: -- ROLLBACK;
139: RAISE FND_API.G_EXC_ERROR;
140: WHEN OTHERS THEN
141: -- ROLLBACK;
135:
136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
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);
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 ;
149:
150: END OKS_IMPORT_POST_PROCESS ;