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 542: WHEN FND_API.G_EXC_ERROR THEN

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

Line 545: (p_encoded => FND_API.G_FALSE

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

Line 563: (p_encoded => FND_API.G_FALSE

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