APPS.OKS_IMPORT_CONTRACTS dependencies on FND_API

Line 97: WHEN FND_API.G_EXC_ERROR THEN

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

Line 98: RAISE FND_API.G_EXC_ERROR;

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

Line 104: RAISE FND_API.G_EXC_ERROR;

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

Line 196: RAISE FND_API.G_EXC_ERROR;

192: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
193: FND_MESSAGE.set_token('ROUTINE', G_MODULE_HEAD ||l_routine);
194: FND_MESSAGE.set_token('MESSAGE', 'Unable to submit request for error report '||l_message);
195: FND_MSG_PUB.Add;
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198: END IF;
199:
200: IF G_PROCEDURE_LOG THEN

Line 208: WHEN FND_API.G_EXC_ERROR THEN

204: 'X_errbuf = ' || X_errbuf ||','||
205: 'X_retcode = ' || X_retcode);
206: END IF;
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
209:
210: FND_MSG_PUB.Count_And_Get
211: (p_encoded => FND_API.G_FALSE
212: ,p_count => l_msg_count

Line 211: (p_encoded => FND_API.G_FALSE

207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
209:
210: FND_MSG_PUB.Count_And_Get
211: (p_encoded => FND_API.G_FALSE
212: ,p_count => l_msg_count
213: ,p_data => l_msg_data
214: );
215: X_retcode := '2';

Line 226: (p_encoded => FND_API.G_FALSE

222: WHEN OTHERS THEN
223: X_errbuf := 'Stmt no '||l_stmt_num||' '||SQLCODE || substr(SQLERRM, 1, 200);
224: X_retcode := '2';
225: FND_MSG_PUB.Count_And_Get
226: (p_encoded => FND_API.G_FALSE
227: ,p_count => l_msg_count
228: ,p_data => l_msg_data
229: );
230: