DBA Data[Home] [Help]

APPS.OKS_IMPORT_REPORT dependencies on FND_API

Line 137: WHEN FND_API.G_EXC_ERROR THEN

133: END IF;
134: EXCEPTION
135: WHEN G_NO_DATA_FOUND_EXC THEN
136: RAISE G_NO_DATA_FOUND_EXC;
137: WHEN FND_API.G_EXC_ERROR THEN
138: RAISE FND_API.G_EXC_ERROR;
139: WHEN OTHERS THEN
140: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
141: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 138: RAISE FND_API.G_EXC_ERROR;

134: EXCEPTION
135: WHEN G_NO_DATA_FOUND_EXC THEN
136: RAISE G_NO_DATA_FOUND_EXC;
137: WHEN FND_API.G_EXC_ERROR THEN
138: RAISE FND_API.G_EXC_ERROR;
139: WHEN OTHERS THEN
140: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
141: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
142: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 144: RAISE FND_API.G_EXC_ERROR;

140: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
141: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
142: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
143: FND_MSG_PUB.Add;
144: RAISE FND_API.G_EXC_ERROR;
145: END Print_Statistics;
146:
147: --========================================================================
148: -- PROCEDURE : Print_Error_Messages PUBLIC

Line 228: WHEN FND_API.G_EXC_ERROR THEN

224: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
225: 'Exit.');
226: END IF;
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: RAISE FND_API.G_EXC_ERROR;
230: WHEN OTHERS THEN
231: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
232: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 229: RAISE FND_API.G_EXC_ERROR;

225: 'Exit.');
226: END IF;
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: RAISE FND_API.G_EXC_ERROR;
230: WHEN OTHERS THEN
231: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
232: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
233: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 235: RAISE FND_API.G_EXC_ERROR;

231: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
232: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
233: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
234: FND_MSG_PUB.Add;
235: RAISE FND_API.G_EXC_ERROR;
236: END Print_Error_Messages;
237:
238: --========================================================================
239: -- PROCEDURE : Process_Error_Reporting PUBLIC

Line 335: WHEN FND_API.G_EXC_ERROR THEN

331: FND_MESSAGE.set_token('STMT', l_stmt_num);
332: l_msg_data := FND_MESSAGE.GET;
333: FND_FILE.put_line(FND_FILE.OUTPUT, l_msg_data);
334: X_errbuf := l_msg_data;
335: WHEN FND_API.G_EXC_ERROR THEN
336: FND_MSG_PUB.Count_And_Get
337: (p_encoded => FND_API.G_FALSE
338: ,p_count => l_msg_count
339: ,p_data => l_msg_data

Line 337: (p_encoded => FND_API.G_FALSE

333: FND_FILE.put_line(FND_FILE.OUTPUT, l_msg_data);
334: X_errbuf := l_msg_data;
335: WHEN FND_API.G_EXC_ERROR THEN
336: FND_MSG_PUB.Count_And_Get
337: (p_encoded => FND_API.G_FALSE
338: ,p_count => l_msg_count
339: ,p_data => l_msg_data
340: );
341: X_retcode := '2';

Line 352: (p_encoded => FND_API.G_FALSE

348: WHEN OTHERS THEN
349: X_errbuf := 'Stmt no '||l_stmt_num||' '||SQLCODE || substr(SQLERRM, 1, 200);
350: X_retcode := '2';
351: FND_MSG_PUB.Count_And_Get
352: (p_encoded => FND_API.G_FALSE
353: ,p_count => l_msg_count
354: ,p_data => l_msg_data
355: );
356: