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_INSERT dependencies on FND_API

Line 366: WHEN FND_API.G_EXC_ERROR THEN

362: 'Number of records Inserted = '|| l_int_count);
363: END IF;
364:
365: EXCEPTION
366: WHEN FND_API.G_EXC_ERROR THEN
367: RAISE FND_API.G_EXC_ERROR;
368: WHEN OTHERS THEN
369: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
370: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 367: RAISE FND_API.G_EXC_ERROR;

363: END IF;
364:
365: EXCEPTION
366: WHEN FND_API.G_EXC_ERROR THEN
367: RAISE FND_API.G_EXC_ERROR;
368: WHEN OTHERS THEN
369: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
370: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
371: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 373: RAISE FND_API.G_EXC_ERROR;

369: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
370: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
371: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
372: FND_MSG_PUB.Add;
373: RAISE FND_API.G_EXC_ERROR;
374: END Insert_okc_header ;
375:
376:
377: --========================================================================

Line 602: WHEN FND_API.G_EXC_ERROR THEN

598: 'Exit with ' ||
599: 'Number of records Inserted = '|| l_int_count);
600: END IF;
601: EXCEPTION
602: WHEN FND_API.G_EXC_ERROR THEN
603: RAISE FND_API.G_EXC_ERROR;
604: WHEN OTHERS THEN
605: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
606: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 603: RAISE FND_API.G_EXC_ERROR;

599: 'Number of records Inserted = '|| l_int_count);
600: END IF;
601: EXCEPTION
602: WHEN FND_API.G_EXC_ERROR THEN
603: RAISE FND_API.G_EXC_ERROR;
604: WHEN OTHERS THEN
605: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
606: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
607: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 609: RAISE FND_API.G_EXC_ERROR;

605: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
606: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
607: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
608: FND_MSG_PUB.Add;
609: RAISE FND_API.G_EXC_ERROR;
610: END Insert_oks_header;
611:
612:
613: --========================================================================

Line 691: WHEN FND_API.G_EXC_ERROR THEN

687: 'Exit with ' ||
688: 'Number of records Inserted = '|| l_int_count);
689: END IF;
690: EXCEPTION
691: WHEN FND_API.G_EXC_ERROR THEN
692: RAISE FND_API.G_EXC_ERROR;
693: WHEN OTHERS THEN
694: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
695: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 692: RAISE FND_API.G_EXC_ERROR;

688: 'Number of records Inserted = '|| l_int_count);
689: END IF;
690: EXCEPTION
691: WHEN FND_API.G_EXC_ERROR THEN
692: RAISE FND_API.G_EXC_ERROR;
693: WHEN OTHERS THEN
694: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
695: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
696: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 698: RAISE FND_API.G_EXC_ERROR;

694: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
695: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
696: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
697: FND_MSG_PUB.Add;
698: RAISE FND_API.G_EXC_ERROR;
699: END Insert_Contract_Groups;
700:
701:
702: --========================================================================

Line 985: WHEN FND_API.G_EXC_ERROR THEN

981: 'Number of records Inserted = '|| l_int_count);
982: END IF;
983: EXCEPTION
984:
985: WHEN FND_API.G_EXC_ERROR THEN
986: RAISE FND_API.G_EXC_ERROR;
987: WHEN OTHERS THEN
988: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
989: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 986: RAISE FND_API.G_EXC_ERROR;

982: END IF;
983: EXCEPTION
984:
985: WHEN FND_API.G_EXC_ERROR THEN
986: RAISE FND_API.G_EXC_ERROR;
987: WHEN OTHERS THEN
988: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
989: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
990: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 992: RAISE FND_API.G_EXC_ERROR;

988: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
989: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
990: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
991: FND_MSG_PUB.Add;
992: RAISE FND_API.G_EXC_ERROR;
993:
994: END Insert_Party_Roles;
995:
996: --========================================================================

Line 1239: WHEN FND_API.G_EXC_ERROR THEN

1235: 'Exit with ' ||
1236: 'Number of records Inserted = '|| l_int_count);
1237: END IF;
1238: EXCEPTION
1239: WHEN FND_API.G_EXC_ERROR THEN
1240: RAISE FND_API.G_EXC_ERROR;
1241: WHEN OTHERS THEN
1242: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1243: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 1240: RAISE FND_API.G_EXC_ERROR;

1236: 'Number of records Inserted = '|| l_int_count);
1237: END IF;
1238: EXCEPTION
1239: WHEN FND_API.G_EXC_ERROR THEN
1240: RAISE FND_API.G_EXC_ERROR;
1241: WHEN OTHERS THEN
1242: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1243: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1244: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 1246: RAISE FND_API.G_EXC_ERROR;

1242: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1243: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1244: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
1245: FND_MSG_PUB.Add;
1246: RAISE FND_API.G_EXC_ERROR;
1247: END Insert_Contacts;
1248:
1249:
1250: --========================================================================

Line 1400: WHEN FND_API.G_EXC_ERROR THEN

1396: 'Number of records Inserted = '|| l_int_count);
1397: END IF;
1398:
1399: EXCEPTION
1400: WHEN FND_API.G_EXC_ERROR THEN
1401: RAISE FND_API.G_EXC_ERROR;
1402: WHEN OTHERS THEN
1403: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1404: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 1401: RAISE FND_API.G_EXC_ERROR;

1397: END IF;
1398:
1399: EXCEPTION
1400: WHEN FND_API.G_EXC_ERROR THEN
1401: RAISE FND_API.G_EXC_ERROR;
1402: WHEN OTHERS THEN
1403: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1404: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1405: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 1407: RAISE FND_API.G_EXC_ERROR;

1403: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1404: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1405: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
1406: FND_MSG_PUB.Add;
1407: RAISE FND_API.G_EXC_ERROR;
1408:
1409: END Insert_Sales_Credits;
1410:
1411: --========================================================================

Line 1715: WHEN FND_API.G_EXC_ERROR THEN

1711: 'Number of records Inserted = '|| l_int_count);
1712: END IF; */
1713:
1714: EXCEPTION
1715: WHEN FND_API.G_EXC_ERROR THEN
1716: RAISE FND_API.G_EXC_ERROR;
1717: WHEN OTHERS THEN
1718: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1719: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 1716: RAISE FND_API.G_EXC_ERROR;

1712: END IF; */
1713:
1714: EXCEPTION
1715: WHEN FND_API.G_EXC_ERROR THEN
1716: RAISE FND_API.G_EXC_ERROR;
1717: WHEN OTHERS THEN
1718: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1719: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1720: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 1722: RAISE FND_API.G_EXC_ERROR;

1718: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1719: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1720: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
1721: FND_MSG_PUB.Add;
1722: RAISE FND_API.G_EXC_ERROR;
1723: END Insert_okc_toplines;
1724:
1725:
1726: --========================================================================

Line 2110: WHEN FND_API.G_EXC_ERROR THEN

2106: 'Exit with ' ||
2107: 'Number of records Inserted = '|| l_int_count);
2108: END IF;
2109: EXCEPTION
2110: WHEN FND_API.G_EXC_ERROR THEN
2111: RAISE FND_API.G_EXC_ERROR;
2112: WHEN OTHERS THEN
2113: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2114: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 2111: RAISE FND_API.G_EXC_ERROR;

2107: 'Number of records Inserted = '|| l_int_count);
2108: END IF;
2109: EXCEPTION
2110: WHEN FND_API.G_EXC_ERROR THEN
2111: RAISE FND_API.G_EXC_ERROR;
2112: WHEN OTHERS THEN
2113: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2114: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2115: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 2117: RAISE FND_API.G_EXC_ERROR;

2113: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2114: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2115: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2116: FND_MSG_PUB.Add;
2117: RAISE FND_API.G_EXC_ERROR;
2118: END Insert_oks_toplines;
2119:
2120:
2121: --========================================================================

Line 2889: WHEN FND_API.G_EXC_ERROR THEN

2885: 'Exit.');
2886: END IF;
2887:
2888: EXCEPTION
2889: WHEN FND_API.G_EXC_ERROR THEN
2890: RAISE FND_API.G_EXC_ERROR;
2891: WHEN OTHERS THEN
2892: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2893: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 2890: RAISE FND_API.G_EXC_ERROR;

2886: END IF;
2887:
2888: EXCEPTION
2889: WHEN FND_API.G_EXC_ERROR THEN
2890: RAISE FND_API.G_EXC_ERROR;
2891: WHEN OTHERS THEN
2892: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2893: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2894: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 2896: RAISE FND_API.G_EXC_ERROR;

2892: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2893: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2894: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2895: FND_MSG_PUB.Add;
2896: RAISE FND_API.G_EXC_ERROR;
2897: END Insert_covlevel_and_usgcounter;
2898:
2899:
2900: --========================================================================

Line 2941: WHEN FND_API.G_EXC_ERROR THEN

2937: 'Exit.');
2938: END IF;
2939:
2940: EXCEPTION
2941: WHEN FND_API.G_EXC_ERROR THEN
2942: -- ROLLBACK;
2943: RAISE FND_API.G_EXC_ERROR;
2944: WHEN OTHERS THEN
2945: -- ROLLBACK;

Line 2943: RAISE FND_API.G_EXC_ERROR;

2939:
2940: EXCEPTION
2941: WHEN FND_API.G_EXC_ERROR THEN
2942: -- ROLLBACK;
2943: RAISE FND_API.G_EXC_ERROR;
2944: WHEN OTHERS THEN
2945: -- ROLLBACK;
2946: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2947: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 2950: RAISE FND_API.G_EXC_ERROR;

2946: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2947: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2948: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2949: FND_MSG_PUB.Add;
2950: RAISE FND_API.G_EXC_ERROR;
2951: END Insert_Contracts;
2952:
2953: END OKS_IMPORT_INSERT;