DBA Data[Home] [Help]

APPS.OKS_IMPORT_POST_INSERT dependencies on FND_MESSAGE

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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 ;

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

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;

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

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:

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

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 ;

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

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;

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

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:

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

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 ;

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

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;

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

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:

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

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;