eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_IMPORT_CONTRACTS_WORKER dependencies on FND_API

Line 74: WHEN FND_API.G_EXC_ERROR THEN

70: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
71: 'Exit.');
72: END IF;
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);

Line 75: RAISE FND_API.G_EXC_ERROR;

71: 'Exit.');
72: END IF;
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);

Line 81: RAISE FND_API.G_EXC_ERROR;

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: --========================================================================
85: -- PROCEDURE : Rollup_errors PRIVATE

Line 156: WHEN FND_API.G_EXC_ERROR THEN

152: 'Exit with ' ||
153: 'X_rows_processed = '|| X_rows_processed);
154: END IF;
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);

Line 157: RAISE FND_API.G_EXC_ERROR;

153: 'X_rows_processed = '|| X_rows_processed);
154: END IF;
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);

Line 163: RAISE FND_API.G_EXC_ERROR;

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: --========================================================================
167: -- PROCEDURE : Gather_Statistics PRIVATE

Line 313: WHEN FND_API.G_EXC_ERROR THEN

309: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
310: 'Exit.');
311: END IF;
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);

Line 314: RAISE FND_API.G_EXC_ERROR;

310: 'Exit.');
311: END IF;
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);

Line 320: RAISE FND_API.G_EXC_ERROR;

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: --========================================================================
324: -- PROCEDURE : Truncate_stg_tables PRIVATE

Line 364: WHEN FND_API.G_EXC_ERROR THEN

360: 'Exit.');
361: END IF;
362:
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);

Line 365: RAISE FND_API.G_EXC_ERROR;

361: END IF;
362:
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);

Line 371: RAISE FND_API.G_EXC_ERROR;

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: --========================================================================
375: -- PROCEDURE : Worker_process PRIVATE

Line 644: WHEN FND_API.G_EXC_ERROR THEN

640: 'X_errbuf = ' || X_errbuf ||','||
641: 'X_retcode = ' || X_retcode);
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

Line 647: (p_encoded => FND_API.G_FALSE

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: );
651: X_retcode := '2';

Line 665: (p_encoded => FND_API.G_FALSE

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: );
669: