574: -- ROLLBACK;
575: RAISE FND_API.G_EXC_ERROR;
576: WHEN OTHERS THEN
577: -- ROLLBACK;
578: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
579: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
580: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
581: FND_MSG_PUB.Add;
582: RAISE FND_API.G_EXC_ERROR;
575: RAISE FND_API.G_EXC_ERROR;
576: WHEN OTHERS THEN
577: -- ROLLBACK;
578: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
579: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
580: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
581: FND_MSG_PUB.Add;
582: RAISE FND_API.G_EXC_ERROR;
583:
576: WHEN OTHERS THEN
577: -- ROLLBACK;
578: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
579: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
580: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
581: FND_MSG_PUB.Add;
582: RAISE FND_API.G_EXC_ERROR;
583:
584: END Generate_bil_sch_Subs_lines;
1505: -- ROLLBACK;
1506: RAISE FND_API.G_EXC_ERROR;
1507: WHEN OTHERS THEN
1508: -- ROLLBACK;
1509: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1510: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1511: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
1512: FND_MSG_PUB.Add;
1513: RAISE FND_API.G_EXC_ERROR;
1506: RAISE FND_API.G_EXC_ERROR;
1507: WHEN OTHERS THEN
1508: -- ROLLBACK;
1509: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1510: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1511: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
1512: FND_MSG_PUB.Add;
1513: RAISE FND_API.G_EXC_ERROR;
1514:
1507: WHEN OTHERS THEN
1508: -- ROLLBACK;
1509: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1510: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1511: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
1512: FND_MSG_PUB.Add;
1513: RAISE FND_API.G_EXC_ERROR;
1514:
1515: END Generate_bil_sch_Usage_lines;
2430: -- ROLLBACK;
2431: RAISE FND_API.G_EXC_ERROR;
2432: WHEN OTHERS THEN
2433: -- ROLLBACK;
2434: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2435: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2436: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2437: FND_MSG_PUB.Add;
2438: RAISE FND_API.G_EXC_ERROR;
2431: RAISE FND_API.G_EXC_ERROR;
2432: WHEN OTHERS THEN
2433: -- ROLLBACK;
2434: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2435: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2436: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2437: FND_MSG_PUB.Add;
2438: RAISE FND_API.G_EXC_ERROR;
2439:
2432: WHEN OTHERS THEN
2433: -- ROLLBACK;
2434: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2435: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2436: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2437: FND_MSG_PUB.Add;
2438: RAISE FND_API.G_EXC_ERROR;
2439:
2440: END Generate_bil_sch_Service_line;
2489: -- ROLLBACK;
2490: RAISE FND_API.G_EXC_ERROR;
2491: WHEN OTHERS THEN
2492: -- ROLLBACK;
2493: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2494: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2495: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2496: FND_MSG_PUB.Add;
2497: RAISE FND_API.G_EXC_ERROR;
2490: RAISE FND_API.G_EXC_ERROR;
2491: WHEN OTHERS THEN
2492: -- ROLLBACK;
2493: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2494: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2495: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2496: FND_MSG_PUB.Add;
2497: RAISE FND_API.G_EXC_ERROR;
2498:
2491: WHEN OTHERS THEN
2492: -- ROLLBACK;
2493: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2494: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2495: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2496: FND_MSG_PUB.Add;
2497: RAISE FND_API.G_EXC_ERROR;
2498:
2499: END Generate_billing_schedules;
2621: -- ROLLBACK;
2622: RAISE FND_API.G_EXC_ERROR;
2623: WHEN OTHERS THEN
2624: -- ROLLBACK;
2625: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2626: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2627: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2628: FND_MSG_PUB.Add;
2629: RAISE FND_API.G_EXC_ERROR;
2622: RAISE FND_API.G_EXC_ERROR;
2623: WHEN OTHERS THEN
2624: -- ROLLBACK;
2625: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2626: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2627: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2628: FND_MSG_PUB.Add;
2629: RAISE FND_API.G_EXC_ERROR;
2630:
2623: WHEN OTHERS THEN
2624: -- ROLLBACK;
2625: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2626: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2627: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2628: FND_MSG_PUB.Add;
2629: RAISE FND_API.G_EXC_ERROR;
2630:
2631: END Generate_PM_schedules ;
2890: -- ROLLBACK;
2891: RAISE FND_API.G_EXC_ERROR;
2892: WHEN OTHERS THEN
2893: -- ROLLBACK;
2894: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2895: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2896: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2897: FND_MSG_PUB.Add;
2898: RAISE FND_API.G_EXC_ERROR;
2891: RAISE FND_API.G_EXC_ERROR;
2892: WHEN OTHERS THEN
2893: -- ROLLBACK;
2894: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2895: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2896: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2897: FND_MSG_PUB.Add;
2898: RAISE FND_API.G_EXC_ERROR;
2899:
2892: WHEN OTHERS THEN
2893: -- ROLLBACK;
2894: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2895: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2896: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2897: FND_MSG_PUB.Add;
2898: RAISE FND_API.G_EXC_ERROR;
2899:
2900: END Create_JTF_notes ;
3045: -- ROLLBACK;
3046: RAISE FND_API.G_EXC_ERROR;
3047: WHEN OTHERS THEN
3048: -- ROLLBACK;
3049: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
3050: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3051: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
3052: FND_MSG_PUB.Add;
3053: RAISE FND_API.G_EXC_ERROR;
3046: RAISE FND_API.G_EXC_ERROR;
3047: WHEN OTHERS THEN
3048: -- ROLLBACK;
3049: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
3050: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3051: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
3052: FND_MSG_PUB.Add;
3053: RAISE FND_API.G_EXC_ERROR;
3054:
3047: WHEN OTHERS THEN
3048: -- ROLLBACK;
3049: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
3050: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3051: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
3052: FND_MSG_PUB.Add;
3053: RAISE FND_API.G_EXC_ERROR;
3054:
3055: END Instantiate_srvc_ctr_events ;
3097: -- ROLLBACK;
3098: RAISE FND_API.G_EXC_ERROR;
3099: WHEN OTHERS THEN
3100: -- ROLLBACK;
3101: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
3102: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3103: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
3104: FND_MSG_PUB.Add;
3105: RAISE FND_API.G_EXC_ERROR;
3098: RAISE FND_API.G_EXC_ERROR;
3099: WHEN OTHERS THEN
3100: -- ROLLBACK;
3101: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
3102: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3103: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
3104: FND_MSG_PUB.Add;
3105: RAISE FND_API.G_EXC_ERROR;
3106:
3099: WHEN OTHERS THEN
3100: -- ROLLBACK;
3101: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
3102: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3103: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
3104: FND_MSG_PUB.Add;
3105: RAISE FND_API.G_EXC_ERROR;
3106:
3107: END Import_Post_Insert;