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 544: FND_MSG_PUB.Count_And_Get

540: END IF;
541: EXCEPTION
542: WHEN FND_API.G_EXC_ERROR THEN
543:
544: FND_MSG_PUB.Count_And_Get
545: (p_encoded => FND_API.G_FALSE
546: ,p_count => l_msg_count
547: ,p_data => l_msg_data
548: );

Line 562: FND_MSG_PUB.Count_And_Get

558: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
559: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
560: X_errbuf := FND_MESSAGE.GET;
561: X_retcode := '2';
562: FND_MSG_PUB.Count_And_Get
563: (p_encoded => FND_API.G_FALSE
564: ,p_count => l_msg_count
565: ,p_data => l_msg_data
566: );