DBA Data[Home] [Help]

APPS.OKS_IMPORT_POST_INSERT dependencies on FND_API

Line 573: WHEN FND_API.G_EXC_ERROR THEN

569:
570: END IF; */
571:
572: EXCEPTION
573: WHEN FND_API.G_EXC_ERROR THEN
574: -- ROLLBACK;
575: RAISE FND_API.G_EXC_ERROR;
576: WHEN OTHERS THEN
577: -- ROLLBACK;

Line 575: RAISE FND_API.G_EXC_ERROR;

571:
572: EXCEPTION
573: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 582: RAISE FND_API.G_EXC_ERROR;

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;
585:
586: --========================================================================

Line 1504: WHEN FND_API.G_EXC_ERROR THEN

1500: null;
1501: END IF; */
1502:
1503: EXCEPTION
1504: WHEN FND_API.G_EXC_ERROR THEN
1505: -- ROLLBACK;
1506: RAISE FND_API.G_EXC_ERROR;
1507: WHEN OTHERS THEN
1508: -- ROLLBACK;

Line 1506: RAISE FND_API.G_EXC_ERROR;

1502:
1503: EXCEPTION
1504: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 1513: RAISE FND_API.G_EXC_ERROR;

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;
1516:
1517: --========================================================================

Line 2429: WHEN FND_API.G_EXC_ERROR THEN

2425: null;
2426: END IF; */
2427:
2428: EXCEPTION
2429: WHEN FND_API.G_EXC_ERROR THEN
2430: -- ROLLBACK;
2431: RAISE FND_API.G_EXC_ERROR;
2432: WHEN OTHERS THEN
2433: -- ROLLBACK;

Line 2431: RAISE FND_API.G_EXC_ERROR;

2427:
2428: EXCEPTION
2429: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 2438: RAISE FND_API.G_EXC_ERROR;

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;
2441:
2442: --========================================================================

Line 2488: WHEN FND_API.G_EXC_ERROR THEN

2484: null;
2485: END IF;
2486:
2487: EXCEPTION
2488: WHEN FND_API.G_EXC_ERROR THEN
2489: -- ROLLBACK;
2490: RAISE FND_API.G_EXC_ERROR;
2491: WHEN OTHERS THEN
2492: -- ROLLBACK;

Line 2490: RAISE FND_API.G_EXC_ERROR;

2486:
2487: EXCEPTION
2488: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 2497: RAISE FND_API.G_EXC_ERROR;

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;
2500:
2501: --========================================================================

Line 2620: WHEN FND_API.G_EXC_ERROR THEN

2616: 'Exit.');
2617: END IF;
2618:
2619: EXCEPTION
2620: WHEN FND_API.G_EXC_ERROR THEN
2621: -- ROLLBACK;
2622: RAISE FND_API.G_EXC_ERROR;
2623: WHEN OTHERS THEN
2624: -- ROLLBACK;

Line 2622: RAISE FND_API.G_EXC_ERROR;

2618:
2619: EXCEPTION
2620: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 2629: RAISE FND_API.G_EXC_ERROR;

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 ;
2632:
2633: --========================================================================

Line 2889: WHEN FND_API.G_EXC_ERROR THEN

2885: END IF;
2886:
2887:
2888: EXCEPTION
2889: WHEN FND_API.G_EXC_ERROR THEN
2890: -- ROLLBACK;
2891: RAISE FND_API.G_EXC_ERROR;
2892: WHEN OTHERS THEN
2893: -- ROLLBACK;

Line 2891: RAISE FND_API.G_EXC_ERROR;

2887:
2888: EXCEPTION
2889: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 2898: RAISE FND_API.G_EXC_ERROR;

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 ;
2901:
2902: --========================================================================

Line 3044: WHEN FND_API.G_EXC_ERROR THEN

3040: 'Exit.');
3041: END IF;
3042:
3043: EXCEPTION
3044: WHEN FND_API.G_EXC_ERROR THEN
3045: -- ROLLBACK;
3046: RAISE FND_API.G_EXC_ERROR;
3047: WHEN OTHERS THEN
3048: -- ROLLBACK;

Line 3046: RAISE FND_API.G_EXC_ERROR;

3042:
3043: EXCEPTION
3044: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 3053: RAISE FND_API.G_EXC_ERROR;

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 ;
3056:
3057:

Line 3096: WHEN FND_API.G_EXC_ERROR THEN

3092: 'Exit.');
3093: END IF;
3094:
3095: EXCEPTION
3096: WHEN FND_API.G_EXC_ERROR THEN
3097: -- ROLLBACK;
3098: RAISE FND_API.G_EXC_ERROR;
3099: WHEN OTHERS THEN
3100: -- ROLLBACK;

Line 3098: RAISE FND_API.G_EXC_ERROR;

3094:
3095: EXCEPTION
3096: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 3105: RAISE FND_API.G_EXC_ERROR;

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;
3108:
3109: END OKS_IMPORT_POST_INSERT;