DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on FND_MESSAGE

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

2247: EXCEPTION
2248: WHEN FND_API.G_EXC_ERROR THEN
2249: RAISE FND_API.G_EXC_ERROR;
2250: WHEN OTHERS THEN
2251: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2252: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2253: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2254: FND_MSG_PUB.Add;
2255: RAISE FND_API.G_EXC_ERROR;

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

2248: WHEN FND_API.G_EXC_ERROR THEN
2249: RAISE FND_API.G_EXC_ERROR;
2250: WHEN OTHERS THEN
2251: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2252: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2253: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2254: FND_MSG_PUB.Add;
2255: RAISE FND_API.G_EXC_ERROR;
2256: END Validate_header;

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

2249: RAISE FND_API.G_EXC_ERROR;
2250: WHEN OTHERS THEN
2251: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2252: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2253: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2254: FND_MSG_PUB.Add;
2255: RAISE FND_API.G_EXC_ERROR;
2256: END Validate_header;
2257:

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

3762: EXCEPTION
3763: WHEN FND_API.G_EXC_ERROR THEN
3764: RAISE FND_API.G_EXC_ERROR;
3765: WHEN OTHERS THEN
3766: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
3767: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3768: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
3769: FND_MSG_PUB.Add;
3770: RAISE FND_API.G_EXC_ERROR;

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

3763: WHEN FND_API.G_EXC_ERROR THEN
3764: RAISE FND_API.G_EXC_ERROR;
3765: WHEN OTHERS THEN
3766: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
3767: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3768: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
3769: FND_MSG_PUB.Add;
3770: RAISE FND_API.G_EXC_ERROR;
3771: END Validate_lines;

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

3764: RAISE FND_API.G_EXC_ERROR;
3765: WHEN OTHERS THEN
3766: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
3767: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3768: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
3769: FND_MSG_PUB.Add;
3770: RAISE FND_API.G_EXC_ERROR;
3771: END Validate_lines;
3772:

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

4739: EXCEPTION
4740: WHEN FND_API.G_EXC_ERROR THEN
4741: RAISE FND_API.G_EXC_ERROR;
4742: WHEN OTHERS THEN
4743: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
4744: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4745: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
4746: FND_MSG_PUB.Add;
4747: RAISE FND_API.G_EXC_ERROR;

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

4740: WHEN FND_API.G_EXC_ERROR THEN
4741: RAISE FND_API.G_EXC_ERROR;
4742: WHEN OTHERS THEN
4743: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
4744: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4745: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
4746: FND_MSG_PUB.Add;
4747: RAISE FND_API.G_EXC_ERROR;
4748: END Validate_covered_levels;

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

4741: RAISE FND_API.G_EXC_ERROR;
4742: WHEN OTHERS THEN
4743: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
4744: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4745: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
4746: FND_MSG_PUB.Add;
4747: RAISE FND_API.G_EXC_ERROR;
4748: END Validate_covered_levels;
4749:

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

5285: EXCEPTION
5286: WHEN FND_API.G_EXC_ERROR THEN
5287: RAISE FND_API.G_EXC_ERROR;
5288: WHEN OTHERS THEN
5289: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5290: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5291: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5292: FND_MSG_PUB.Add;
5293: RAISE FND_API.G_EXC_ERROR;

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

5286: WHEN FND_API.G_EXC_ERROR THEN
5287: RAISE FND_API.G_EXC_ERROR;
5288: WHEN OTHERS THEN
5289: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5290: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5291: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5292: FND_MSG_PUB.Add;
5293: RAISE FND_API.G_EXC_ERROR;
5294: END Validate_usage_counters;

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

5287: RAISE FND_API.G_EXC_ERROR;
5288: WHEN OTHERS THEN
5289: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5290: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5291: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5292: FND_MSG_PUB.Add;
5293: RAISE FND_API.G_EXC_ERROR;
5294: END Validate_usage_counters;
5295: --========================================================================

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

5513: EXCEPTION
5514: WHEN FND_API.G_EXC_ERROR THEN
5515: RAISE FND_API.G_EXC_ERROR;
5516: WHEN OTHERS THEN
5517: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5518: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5519: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5520: FND_MSG_PUB.Add;
5521: RAISE FND_API.G_EXC_ERROR;

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

5514: WHEN FND_API.G_EXC_ERROR THEN
5515: RAISE FND_API.G_EXC_ERROR;
5516: WHEN OTHERS THEN
5517: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5518: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5519: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5520: FND_MSG_PUB.Add;
5521: RAISE FND_API.G_EXC_ERROR;
5522: END Validate_Sales_Credits;

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

5515: RAISE FND_API.G_EXC_ERROR;
5516: WHEN OTHERS THEN
5517: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5518: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5519: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5520: FND_MSG_PUB.Add;
5521: RAISE FND_API.G_EXC_ERROR;
5522: END Validate_Sales_Credits;
5523:

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

5792: EXCEPTION
5793: WHEN FND_API.G_EXC_ERROR THEN
5794: RAISE FND_API.G_EXC_ERROR;
5795: WHEN OTHERS THEN
5796: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5797: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5798: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5799: FND_MSG_PUB.Add;
5800: RAISE FND_API.G_EXC_ERROR;

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

5793: WHEN FND_API.G_EXC_ERROR THEN
5794: RAISE FND_API.G_EXC_ERROR;
5795: WHEN OTHERS THEN
5796: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5797: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5798: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5799: FND_MSG_PUB.Add;
5800: RAISE FND_API.G_EXC_ERROR;
5801: END Validate_notes;

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

5794: RAISE FND_API.G_EXC_ERROR;
5795: WHEN OTHERS THEN
5796: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5797: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5798: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5799: FND_MSG_PUB.Add;
5800: RAISE FND_API.G_EXC_ERROR;
5801: END Validate_notes;
5802:

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

5857: -- ROLLBACK;
5858: RAISE FND_API.G_EXC_ERROR;
5859: WHEN OTHERS THEN
5860: -- ROLLBACK;
5861: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5862: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5863: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5864: FND_MSG_PUB.Add;
5865: RAISE FND_API.G_EXC_ERROR;

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

5858: RAISE FND_API.G_EXC_ERROR;
5859: WHEN OTHERS THEN
5860: -- ROLLBACK;
5861: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5862: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5863: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5864: FND_MSG_PUB.Add;
5865: RAISE FND_API.G_EXC_ERROR;
5866: END Validate_Contracts;

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

5859: WHEN OTHERS THEN
5860: -- ROLLBACK;
5861: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5862: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5863: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5864: FND_MSG_PUB.Add;
5865: RAISE FND_API.G_EXC_ERROR;
5866: END Validate_Contracts;
5867: