DBA Data[Home] [Help]

APPS.OKS_IMPORT_INSERT dependencies on FND_MESSAGE

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

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);
377: FND_MSG_PUB.Add;
378: RAISE FND_API.G_EXC_ERROR;

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

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);
377: FND_MSG_PUB.Add;
378: RAISE FND_API.G_EXC_ERROR;
379: END Insert_okc_header ;

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

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);
377: FND_MSG_PUB.Add;
378: RAISE FND_API.G_EXC_ERROR;
379: END Insert_okc_header ;
380:

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

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);
613: FND_MSG_PUB.Add;
614: RAISE FND_API.G_EXC_ERROR;

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

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);
613: FND_MSG_PUB.Add;
614: RAISE FND_API.G_EXC_ERROR;
615: END Insert_oks_header;

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

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);
613: FND_MSG_PUB.Add;
614: RAISE FND_API.G_EXC_ERROR;
615: END Insert_oks_header;
616:

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

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);
702: FND_MSG_PUB.Add;
703: RAISE FND_API.G_EXC_ERROR;

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

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);
702: FND_MSG_PUB.Add;
703: RAISE FND_API.G_EXC_ERROR;
704: END Insert_Contract_Groups;

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

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);
702: FND_MSG_PUB.Add;
703: RAISE FND_API.G_EXC_ERROR;
704: END Insert_Contract_Groups;
705:

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

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);
996: FND_MSG_PUB.Add;
997: RAISE FND_API.G_EXC_ERROR;

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

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);
996: FND_MSG_PUB.Add;
997: RAISE FND_API.G_EXC_ERROR;
998:

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

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);
996: FND_MSG_PUB.Add;
997: RAISE FND_API.G_EXC_ERROR;
998:
999: END Insert_Party_Roles;

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

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);
1250: FND_MSG_PUB.Add;
1251: RAISE FND_API.G_EXC_ERROR;

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

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);
1250: FND_MSG_PUB.Add;
1251: RAISE FND_API.G_EXC_ERROR;
1252: END Insert_Contacts;

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

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);
1250: FND_MSG_PUB.Add;
1251: RAISE FND_API.G_EXC_ERROR;
1252: END Insert_Contacts;
1253:

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

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);
1411: FND_MSG_PUB.Add;
1412: RAISE FND_API.G_EXC_ERROR;

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

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);
1411: FND_MSG_PUB.Add;
1412: RAISE FND_API.G_EXC_ERROR;
1413:

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

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);
1411: FND_MSG_PUB.Add;
1412: RAISE FND_API.G_EXC_ERROR;
1413:
1414: END Insert_Sales_Credits;

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

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);
1729: FND_MSG_PUB.Add;
1730: RAISE FND_API.G_EXC_ERROR;

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

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);
1729: FND_MSG_PUB.Add;
1730: RAISE FND_API.G_EXC_ERROR;
1731: END Insert_okc_toplines;

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

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);
1729: FND_MSG_PUB.Add;
1730: RAISE FND_API.G_EXC_ERROR;
1731: END Insert_okc_toplines;
1732:

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

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);
2124: FND_MSG_PUB.Add;
2125: RAISE FND_API.G_EXC_ERROR;

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

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);
2124: FND_MSG_PUB.Add;
2125: RAISE FND_API.G_EXC_ERROR;
2126: END Insert_oks_toplines;

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

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);
2124: FND_MSG_PUB.Add;
2125: RAISE FND_API.G_EXC_ERROR;
2126: END Insert_oks_toplines;
2127:

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

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);
2905: FND_MSG_PUB.Add;
2906: RAISE FND_API.G_EXC_ERROR;

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

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);
2905: FND_MSG_PUB.Add;
2906: RAISE FND_API.G_EXC_ERROR;
2907: END Insert_covlevel_and_usgcounter;

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

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);
2905: FND_MSG_PUB.Add;
2906: RAISE FND_API.G_EXC_ERROR;
2907: END Insert_covlevel_and_usgcounter;
2908:

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

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

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

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

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

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