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

367: 'Number of records Inserted = '|| l_int_count);
368: END IF;
369:
370: EXCEPTION
371: WHEN FND_API.G_EXC_ERROR THEN
372: RAISE FND_API.G_EXC_ERROR;
373: WHEN OTHERS THEN
374: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
375: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 372: RAISE FND_API.G_EXC_ERROR;

368: END IF;
369:
370: EXCEPTION
371: WHEN FND_API.G_EXC_ERROR THEN
372: RAISE FND_API.G_EXC_ERROR;
373: WHEN OTHERS THEN
374: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
375: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
376: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 378: RAISE FND_API.G_EXC_ERROR;

374: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
375: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
376: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
377: FND_MSG_PUB.Add;
378: RAISE FND_API.G_EXC_ERROR;
379: END Insert_okc_header ;
380:
381:
382: --========================================================================

Line 607: WHEN FND_API.G_EXC_ERROR THEN

603: 'Exit with ' ||
604: 'Number of records Inserted = '|| l_int_count);
605: END IF;
606: EXCEPTION
607: WHEN FND_API.G_EXC_ERROR THEN
608: RAISE FND_API.G_EXC_ERROR;
609: WHEN OTHERS THEN
610: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
611: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 608: RAISE FND_API.G_EXC_ERROR;

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

Line 614: RAISE FND_API.G_EXC_ERROR;

610: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
611: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
612: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
613: FND_MSG_PUB.Add;
614: RAISE FND_API.G_EXC_ERROR;
615: END Insert_oks_header;
616:
617:
618: --========================================================================

Line 696: WHEN FND_API.G_EXC_ERROR THEN

692: 'Exit with ' ||
693: 'Number of records Inserted = '|| l_int_count);
694: END IF;
695: EXCEPTION
696: WHEN FND_API.G_EXC_ERROR THEN
697: RAISE FND_API.G_EXC_ERROR;
698: WHEN OTHERS THEN
699: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
700: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 697: RAISE FND_API.G_EXC_ERROR;

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

Line 703: RAISE FND_API.G_EXC_ERROR;

699: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
700: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
701: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
702: FND_MSG_PUB.Add;
703: RAISE FND_API.G_EXC_ERROR;
704: END Insert_Contract_Groups;
705:
706:
707: --========================================================================

Line 990: WHEN FND_API.G_EXC_ERROR THEN

986: 'Number of records Inserted = '|| l_int_count);
987: END IF;
988: EXCEPTION
989:
990: WHEN FND_API.G_EXC_ERROR THEN
991: RAISE FND_API.G_EXC_ERROR;
992: WHEN OTHERS THEN
993: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
994: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 991: RAISE FND_API.G_EXC_ERROR;

987: END IF;
988: EXCEPTION
989:
990: WHEN FND_API.G_EXC_ERROR THEN
991: RAISE FND_API.G_EXC_ERROR;
992: WHEN OTHERS THEN
993: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
994: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
995: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 997: RAISE FND_API.G_EXC_ERROR;

993: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
994: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
995: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
996: FND_MSG_PUB.Add;
997: RAISE FND_API.G_EXC_ERROR;
998:
999: END Insert_Party_Roles;
1000:
1001: --========================================================================

Line 1244: WHEN FND_API.G_EXC_ERROR THEN

1240: 'Exit with ' ||
1241: 'Number of records Inserted = '|| l_int_count);
1242: END IF;
1243: EXCEPTION
1244: WHEN FND_API.G_EXC_ERROR THEN
1245: RAISE FND_API.G_EXC_ERROR;
1246: WHEN OTHERS THEN
1247: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1248: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 1245: RAISE FND_API.G_EXC_ERROR;

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

Line 1251: RAISE FND_API.G_EXC_ERROR;

1247: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1248: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1249: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
1250: FND_MSG_PUB.Add;
1251: RAISE FND_API.G_EXC_ERROR;
1252: END Insert_Contacts;
1253:
1254:
1255: --========================================================================

Line 1405: WHEN FND_API.G_EXC_ERROR THEN

1401: 'Number of records Inserted = '|| l_int_count);
1402: END IF;
1403:
1404: EXCEPTION
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: RAISE FND_API.G_EXC_ERROR;
1407: WHEN OTHERS THEN
1408: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1409: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 1406: RAISE FND_API.G_EXC_ERROR;

1402: END IF;
1403:
1404: EXCEPTION
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: RAISE FND_API.G_EXC_ERROR;
1407: WHEN OTHERS THEN
1408: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1409: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1410: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 1412: RAISE FND_API.G_EXC_ERROR;

1408: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1409: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1410: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
1411: FND_MSG_PUB.Add;
1412: RAISE FND_API.G_EXC_ERROR;
1413:
1414: END Insert_Sales_Credits;
1415:
1416: --========================================================================

Line 1723: WHEN FND_API.G_EXC_ERROR THEN

1719: 'Number of records Inserted = '|| l_int_count);
1720: END IF; */
1721:
1722: EXCEPTION
1723: WHEN FND_API.G_EXC_ERROR THEN
1724: RAISE FND_API.G_EXC_ERROR;
1725: WHEN OTHERS THEN
1726: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1727: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 1724: RAISE FND_API.G_EXC_ERROR;

1720: END IF; */
1721:
1722: EXCEPTION
1723: WHEN FND_API.G_EXC_ERROR THEN
1724: RAISE FND_API.G_EXC_ERROR;
1725: WHEN OTHERS THEN
1726: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1727: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1728: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 1730: RAISE FND_API.G_EXC_ERROR;

1726: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1727: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1728: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
1729: FND_MSG_PUB.Add;
1730: RAISE FND_API.G_EXC_ERROR;
1731: END Insert_okc_toplines;
1732:
1733:
1734: --========================================================================

Line 2118: WHEN FND_API.G_EXC_ERROR THEN

2114: 'Exit with ' ||
2115: 'Number of records Inserted = '|| l_int_count);
2116: END IF;
2117: EXCEPTION
2118: WHEN FND_API.G_EXC_ERROR THEN
2119: RAISE FND_API.G_EXC_ERROR;
2120: WHEN OTHERS THEN
2121: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2122: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 2119: RAISE FND_API.G_EXC_ERROR;

2115: 'Number of records Inserted = '|| l_int_count);
2116: END IF;
2117: EXCEPTION
2118: WHEN FND_API.G_EXC_ERROR THEN
2119: RAISE FND_API.G_EXC_ERROR;
2120: WHEN OTHERS THEN
2121: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2122: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2123: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 2125: RAISE FND_API.G_EXC_ERROR;

2121: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2122: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2123: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2124: FND_MSG_PUB.Add;
2125: RAISE FND_API.G_EXC_ERROR;
2126: END Insert_oks_toplines;
2127:
2128:
2129: --========================================================================

Line 2899: WHEN FND_API.G_EXC_ERROR THEN

2895: 'Exit.');
2896: END IF;
2897:
2898: EXCEPTION
2899: WHEN FND_API.G_EXC_ERROR THEN
2900: RAISE FND_API.G_EXC_ERROR;
2901: WHEN OTHERS THEN
2902: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2903: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 2900: RAISE FND_API.G_EXC_ERROR;

2896: END IF;
2897:
2898: EXCEPTION
2899: WHEN FND_API.G_EXC_ERROR THEN
2900: RAISE FND_API.G_EXC_ERROR;
2901: WHEN OTHERS THEN
2902: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2903: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2904: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 2906: RAISE FND_API.G_EXC_ERROR;

2902: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2903: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2904: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2905: FND_MSG_PUB.Add;
2906: RAISE FND_API.G_EXC_ERROR;
2907: END Insert_covlevel_and_usgcounter;
2908:
2909:
2910: --========================================================================

Line 2951: WHEN FND_API.G_EXC_ERROR THEN

2947: 'Exit.');
2948: END IF;
2949:
2950: EXCEPTION
2951: WHEN FND_API.G_EXC_ERROR THEN
2952: -- ROLLBACK;
2953: RAISE FND_API.G_EXC_ERROR;
2954: WHEN OTHERS THEN
2955: -- ROLLBACK;

Line 2953: RAISE FND_API.G_EXC_ERROR;

2949:
2950: EXCEPTION
2951: WHEN FND_API.G_EXC_ERROR THEN
2952: -- ROLLBACK;
2953: RAISE FND_API.G_EXC_ERROR;
2954: WHEN OTHERS THEN
2955: -- ROLLBACK;
2956: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2957: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 2960: RAISE FND_API.G_EXC_ERROR;

2956: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2957: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2958: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2959: FND_MSG_PUB.Add;
2960: RAISE FND_API.G_EXC_ERROR;
2961: END Insert_Contracts;
2962:
2963: END OKS_IMPORT_INSERT;