APPS.OKS_IMPORT_PURGE dependencies on FND_API

Line 95: WHEN FND_API.G_EXC_ERROR THEN

91: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
92: 'Exit.');
93: END IF;
94: EXCEPTION
95: WHEN FND_API.G_EXC_ERROR THEN
96: RAISE FND_API.G_EXC_ERROR;
97: WHEN OTHERS THEN
98: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
99: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 96: RAISE FND_API.G_EXC_ERROR;

92: 'Exit.');
93: END IF;
94: EXCEPTION
95: WHEN FND_API.G_EXC_ERROR THEN
96: RAISE FND_API.G_EXC_ERROR;
97: WHEN OTHERS THEN
98: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
99: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
100: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 102: RAISE FND_API.G_EXC_ERROR;

98: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
99: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
100: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
101: FND_MSG_PUB.Add;
102: RAISE FND_API.G_EXC_ERROR;
103: END clear_ad_cache;
104:
105: --========================================================================
106: -- PROCEDURE : Purge PRIVATE

Line 172: WHEN FND_API.G_EXC_ERROR THEN

168: 'X_errbuf = ' || X_errbuf ||','||
169: 'X_retcode = ' || X_retcode);
170: END IF;
171: EXCEPTION
172: WHEN FND_API.G_EXC_ERROR THEN
173:
174: FND_MSG_PUB.Count_And_Get
175: (p_encoded => FND_API.G_FALSE
176: ,p_count => l_msg_count

Line 175: (p_encoded => FND_API.G_FALSE

171: EXCEPTION
172: WHEN FND_API.G_EXC_ERROR THEN
173:
174: FND_MSG_PUB.Count_And_Get
175: (p_encoded => FND_API.G_FALSE
176: ,p_count => l_msg_count
177: ,p_data => l_msg_data
178: );
179: X_retcode := '2';

Line 190: (p_encoded => FND_API.G_FALSE

186: WHEN OTHERS THEN
187: X_errbuf := 'Stmt no '||l_stmt_num||' '|| SQLCODE || substr(SQLERRM, 1, 200);
188: X_retcode := '2';
189: FND_MSG_PUB.Count_And_Get
190: (p_encoded => FND_API.G_FALSE
191: ,p_count => l_msg_count
192: ,p_data => l_msg_data
193: );
194: