DBA Data[Home] [Help]

APPS.OKS_IMPORT_POST_INSERT dependencies on FND_API

Line 469: WHEN FND_API.G_EXC_ERROR THEN

465:
466: END IF; */
467:
468: EXCEPTION
469: WHEN FND_API.G_EXC_ERROR THEN
470: -- ROLLBACK;
471: RAISE FND_API.G_EXC_ERROR;
472: WHEN OTHERS THEN
473: -- ROLLBACK;

Line 471: RAISE FND_API.G_EXC_ERROR;

467:
468: EXCEPTION
469: WHEN FND_API.G_EXC_ERROR THEN
470: -- ROLLBACK;
471: RAISE FND_API.G_EXC_ERROR;
472: WHEN OTHERS THEN
473: -- ROLLBACK;
474: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
475: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 478: RAISE FND_API.G_EXC_ERROR;

474: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
475: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
476: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
477: FND_MSG_PUB.Add;
478: RAISE FND_API.G_EXC_ERROR;
479:
480: END Generate_bil_sch_Subs_lines;
481:
482: --========================================================================

Line 1254: WHEN FND_API.G_EXC_ERROR THEN

1250: null;
1251: END IF; */
1252:
1253: EXCEPTION
1254: WHEN FND_API.G_EXC_ERROR THEN
1255: -- ROLLBACK;
1256: RAISE FND_API.G_EXC_ERROR;
1257: WHEN OTHERS THEN
1258: -- ROLLBACK;

Line 1256: RAISE FND_API.G_EXC_ERROR;

1252:
1253: EXCEPTION
1254: WHEN FND_API.G_EXC_ERROR THEN
1255: -- ROLLBACK;
1256: RAISE FND_API.G_EXC_ERROR;
1257: WHEN OTHERS THEN
1258: -- ROLLBACK;
1259: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1260: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 1263: RAISE FND_API.G_EXC_ERROR;

1259: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
1260: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
1261: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
1262: FND_MSG_PUB.Add;
1263: RAISE FND_API.G_EXC_ERROR;
1264:
1265: END Generate_bil_sch_Usage_lines;
1266:
1267: --========================================================================

Line 2031: WHEN FND_API.G_EXC_ERROR THEN

2027: null;
2028: END IF; */
2029:
2030: EXCEPTION
2031: WHEN FND_API.G_EXC_ERROR THEN
2032: -- ROLLBACK;
2033: RAISE FND_API.G_EXC_ERROR;
2034: WHEN OTHERS THEN
2035: -- ROLLBACK;

Line 2033: RAISE FND_API.G_EXC_ERROR;

2029:
2030: EXCEPTION
2031: WHEN FND_API.G_EXC_ERROR THEN
2032: -- ROLLBACK;
2033: RAISE FND_API.G_EXC_ERROR;
2034: WHEN OTHERS THEN
2035: -- ROLLBACK;
2036: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2037: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 2040: RAISE FND_API.G_EXC_ERROR;

2036: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2037: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2038: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2039: FND_MSG_PUB.Add;
2040: RAISE FND_API.G_EXC_ERROR;
2041:
2042: END Generate_bil_sch_Service_line;
2043:
2044: --========================================================================

Line 2090: WHEN FND_API.G_EXC_ERROR THEN

2086: null;
2087: END IF;
2088:
2089: EXCEPTION
2090: WHEN FND_API.G_EXC_ERROR THEN
2091: -- ROLLBACK;
2092: RAISE FND_API.G_EXC_ERROR;
2093: WHEN OTHERS THEN
2094: -- ROLLBACK;

Line 2092: RAISE FND_API.G_EXC_ERROR;

2088:
2089: EXCEPTION
2090: WHEN FND_API.G_EXC_ERROR THEN
2091: -- ROLLBACK;
2092: RAISE FND_API.G_EXC_ERROR;
2093: WHEN OTHERS THEN
2094: -- ROLLBACK;
2095: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2096: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 2099: RAISE FND_API.G_EXC_ERROR;

2095: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2096: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2097: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2098: FND_MSG_PUB.Add;
2099: RAISE FND_API.G_EXC_ERROR;
2100:
2101: END Generate_billing_schedules;
2102:
2103: --========================================================================

Line 2222: WHEN FND_API.G_EXC_ERROR THEN

2218: 'Exit.');
2219: END IF;
2220:
2221: EXCEPTION
2222: WHEN FND_API.G_EXC_ERROR THEN
2223: -- ROLLBACK;
2224: RAISE FND_API.G_EXC_ERROR;
2225: WHEN OTHERS THEN
2226: -- ROLLBACK;

Line 2224: RAISE FND_API.G_EXC_ERROR;

2220:
2221: EXCEPTION
2222: WHEN FND_API.G_EXC_ERROR THEN
2223: -- ROLLBACK;
2224: RAISE FND_API.G_EXC_ERROR;
2225: WHEN OTHERS THEN
2226: -- ROLLBACK;
2227: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2228: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 2231: RAISE FND_API.G_EXC_ERROR;

2227: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2228: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2229: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2230: FND_MSG_PUB.Add;
2231: RAISE FND_API.G_EXC_ERROR;
2232:
2233: END Generate_PM_schedules ;
2234:
2235: --========================================================================

Line 2491: WHEN FND_API.G_EXC_ERROR THEN

2487: END IF;
2488:
2489:
2490: EXCEPTION
2491: WHEN FND_API.G_EXC_ERROR THEN
2492: -- ROLLBACK;
2493: RAISE FND_API.G_EXC_ERROR;
2494: WHEN OTHERS THEN
2495: -- ROLLBACK;

Line 2493: RAISE FND_API.G_EXC_ERROR;

2489:
2490: EXCEPTION
2491: WHEN FND_API.G_EXC_ERROR THEN
2492: -- ROLLBACK;
2493: RAISE FND_API.G_EXC_ERROR;
2494: WHEN OTHERS THEN
2495: -- ROLLBACK;
2496: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2497: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 2500: RAISE FND_API.G_EXC_ERROR;

2496: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2497: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2498: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2499: FND_MSG_PUB.Add;
2500: RAISE FND_API.G_EXC_ERROR;
2501:
2502: END Create_JTF_notes ;
2503:
2504: --========================================================================

Line 2646: WHEN FND_API.G_EXC_ERROR THEN

2642: 'Exit.');
2643: END IF;
2644:
2645: EXCEPTION
2646: WHEN FND_API.G_EXC_ERROR THEN
2647: -- ROLLBACK;
2648: RAISE FND_API.G_EXC_ERROR;
2649: WHEN OTHERS THEN
2650: -- ROLLBACK;

Line 2648: RAISE FND_API.G_EXC_ERROR;

2644:
2645: EXCEPTION
2646: WHEN FND_API.G_EXC_ERROR THEN
2647: -- ROLLBACK;
2648: RAISE FND_API.G_EXC_ERROR;
2649: WHEN OTHERS THEN
2650: -- ROLLBACK;
2651: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2652: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 2655: RAISE FND_API.G_EXC_ERROR;

2651: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2652: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2653: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2654: FND_MSG_PUB.Add;
2655: RAISE FND_API.G_EXC_ERROR;
2656:
2657: END Instantiate_srvc_ctr_events ;
2658:
2659:

Line 2698: WHEN FND_API.G_EXC_ERROR THEN

2694: 'Exit.');
2695: END IF;
2696:
2697: EXCEPTION
2698: WHEN FND_API.G_EXC_ERROR THEN
2699: -- ROLLBACK;
2700: RAISE FND_API.G_EXC_ERROR;
2701: WHEN OTHERS THEN
2702: -- ROLLBACK;

Line 2700: RAISE FND_API.G_EXC_ERROR;

2696:
2697: EXCEPTION
2698: WHEN FND_API.G_EXC_ERROR THEN
2699: -- ROLLBACK;
2700: RAISE FND_API.G_EXC_ERROR;
2701: WHEN OTHERS THEN
2702: -- ROLLBACK;
2703: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2704: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 2707: RAISE FND_API.G_EXC_ERROR;

2703: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2704: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2705: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2706: FND_MSG_PUB.Add;
2707: RAISE FND_API.G_EXC_ERROR;
2708:
2709: END Import_Post_Insert;
2710:
2711: END OKS_IMPORT_POST_INSERT;