DBA Data[Home] [Help]

APPS.OKS_IMPORT_CONTRACTS_WORKER dependencies on FND_MESSAGE

Line 77: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');

73: EXCEPTION
74: WHEN FND_API.G_EXC_ERROR THEN
75: RAISE FND_API.G_EXC_ERROR;
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;

Line 78: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

74: WHEN FND_API.G_EXC_ERROR THEN
75: RAISE FND_API.G_EXC_ERROR;
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;

Line 79: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

75: RAISE FND_API.G_EXC_ERROR;
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:

Line 159: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');

155: EXCEPTION
156: WHEN FND_API.G_EXC_ERROR THEN
157: RAISE FND_API.G_EXC_ERROR;
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;

Line 160: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

156: WHEN FND_API.G_EXC_ERROR THEN
157: RAISE FND_API.G_EXC_ERROR;
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;

Line 161: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

157: RAISE FND_API.G_EXC_ERROR;
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:

Line 316: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');

312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: RAISE FND_API.G_EXC_ERROR;
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;

Line 317: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

313: WHEN FND_API.G_EXC_ERROR THEN
314: RAISE FND_API.G_EXC_ERROR;
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;

Line 318: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

314: RAISE FND_API.G_EXC_ERROR;
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:

Line 367: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');

363: EXCEPTION
364: WHEN FND_API.G_EXC_ERROR THEN
365: RAISE FND_API.G_EXC_ERROR;
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;

Line 368: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

364: WHEN FND_API.G_EXC_ERROR THEN
365: RAISE FND_API.G_EXC_ERROR;
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;

Line 369: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

365: RAISE FND_API.G_EXC_ERROR;
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:

Line 557: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');

553: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION, G_MODULE_HEAD || l_routine , l_msg_data);
554: END IF;
555:
556: WHEN OTHERS THEN
557: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
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';

Line 558: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

554: END IF;
555:
556: WHEN OTHERS THEN
557: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
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

Line 559: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

555:
556: WHEN OTHERS THEN
557: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
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

Line 560: X_errbuf := FND_MESSAGE.GET;

556: WHEN OTHERS THEN
557: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
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