DBA Data[Home] [Help]

APPS.OKS_IMPORT_POST_INSERT dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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