DBA Data[Home] [Help]

APPS.OKS_IMPORT_CONTRACTS_WORKER dependencies on FND_MSG_PUB

Line 80: FND_MSG_PUB.Add;

76: WHEN OTHERS THEN
77: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
78: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
79: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
80: FND_MSG_PUB.Add;
81: RAISE FND_API.G_EXC_ERROR;
82: END PreInsert_Rollup_errors;
83:
84: --========================================================================

Line 162: FND_MSG_PUB.Add;

158: WHEN OTHERS THEN
159: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
160: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
161: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
162: FND_MSG_PUB.Add;
163: RAISE FND_API.G_EXC_ERROR;
164: END Rollup_errors;
165:
166: --========================================================================

Line 319: FND_MSG_PUB.Add;

315: WHEN OTHERS THEN
316: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
317: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
318: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
319: FND_MSG_PUB.Add;
320: RAISE FND_API.G_EXC_ERROR;
321: END Gather_Statistics;
322:
323: --========================================================================

Line 370: FND_MSG_PUB.Add;

366: WHEN OTHERS THEN
367: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
368: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
369: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
370: FND_MSG_PUB.Add;
371: RAISE FND_API.G_EXC_ERROR;
372: END Truncate_stg_tables;
373:
374: --========================================================================

Line 646: FND_MSG_PUB.Count_And_Get

642: END IF;
643: EXCEPTION
644: WHEN FND_API.G_EXC_ERROR THEN
645:
646: FND_MSG_PUB.Count_And_Get
647: (p_encoded => FND_API.G_FALSE
648: ,p_count => l_msg_count
649: ,p_data => l_msg_data
650: );

Line 664: FND_MSG_PUB.Count_And_Get

660: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
661: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
662: X_errbuf := FND_MESSAGE.GET;
663: X_retcode := '2';
664: FND_MSG_PUB.Count_And_Get
665: (p_encoded => FND_API.G_FALSE
666: ,p_count => l_msg_count
667: ,p_data => l_msg_data
668: );