DBA Data[Home] [Help]

APPS.OKS_IMPORT_INSERT dependencies on FND_MESSAGE

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

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

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

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);
372: FND_MSG_PUB.Add;
373: RAISE FND_API.G_EXC_ERROR;
374: END Insert_okc_header ;

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

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);
372: FND_MSG_PUB.Add;
373: RAISE FND_API.G_EXC_ERROR;
374: END Insert_okc_header ;
375:

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

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

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

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);
608: FND_MSG_PUB.Add;
609: RAISE FND_API.G_EXC_ERROR;
610: END Insert_oks_header;

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

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);
608: FND_MSG_PUB.Add;
609: RAISE FND_API.G_EXC_ERROR;
610: END Insert_oks_header;
611:

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

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

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

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);
697: FND_MSG_PUB.Add;
698: RAISE FND_API.G_EXC_ERROR;
699: END Insert_Contract_Groups;

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

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);
697: FND_MSG_PUB.Add;
698: RAISE FND_API.G_EXC_ERROR;
699: END Insert_Contract_Groups;
700:

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

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

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

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);
991: FND_MSG_PUB.Add;
992: RAISE FND_API.G_EXC_ERROR;
993:

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

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);
991: FND_MSG_PUB.Add;
992: RAISE FND_API.G_EXC_ERROR;
993:
994: END Insert_Party_Roles;

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

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

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

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);
1245: FND_MSG_PUB.Add;
1246: RAISE FND_API.G_EXC_ERROR;
1247: END Insert_Contacts;

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

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);
1245: FND_MSG_PUB.Add;
1246: RAISE FND_API.G_EXC_ERROR;
1247: END Insert_Contacts;
1248:

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

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

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

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);
1406: FND_MSG_PUB.Add;
1407: RAISE FND_API.G_EXC_ERROR;
1408:

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

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);
1406: FND_MSG_PUB.Add;
1407: RAISE FND_API.G_EXC_ERROR;
1408:
1409: END Insert_Sales_Credits;

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

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

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

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);
1721: FND_MSG_PUB.Add;
1722: RAISE FND_API.G_EXC_ERROR;
1723: END Insert_okc_toplines;

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

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);
1721: FND_MSG_PUB.Add;
1722: RAISE FND_API.G_EXC_ERROR;
1723: END Insert_okc_toplines;
1724:

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

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

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

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);
2116: FND_MSG_PUB.Add;
2117: RAISE FND_API.G_EXC_ERROR;
2118: END Insert_oks_toplines;

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

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);
2116: FND_MSG_PUB.Add;
2117: RAISE FND_API.G_EXC_ERROR;
2118: END Insert_oks_toplines;
2119:

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

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

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

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);
2895: FND_MSG_PUB.Add;
2896: RAISE FND_API.G_EXC_ERROR;
2897: END Insert_covlevel_and_usgcounter;

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

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);
2895: FND_MSG_PUB.Add;
2896: RAISE FND_API.G_EXC_ERROR;
2897: END Insert_covlevel_and_usgcounter;
2898:

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

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

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

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

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

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