DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on FND_API

Line 2248: WHEN FND_API.G_EXC_ERROR THEN

2244: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
2245: 'Exit.');
2246: END IF; */
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);

Line 2249: RAISE FND_API.G_EXC_ERROR;

2245: 'Exit.');
2246: END IF; */
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);

Line 2255: RAISE FND_API.G_EXC_ERROR;

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:
2258: --========================================================================
2259: -- PROCEDURE : Validate_lines PRIVATE

Line 3763: WHEN FND_API.G_EXC_ERROR THEN

3759: 'Exit.');
3760: END IF; */
3761:
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);

Line 3764: RAISE FND_API.G_EXC_ERROR;

3760: END IF; */
3761:
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);

Line 3770: RAISE FND_API.G_EXC_ERROR;

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:
3773: --========================================================================
3774: -- PROCEDURE : Validate_covered_levels PRIVATE

Line 4740: WHEN FND_API.G_EXC_ERROR THEN

4736: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
4737: 'Exit.');
4738: END IF;
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);

Line 4741: RAISE FND_API.G_EXC_ERROR;

4737: 'Exit.');
4738: END IF;
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);

Line 4747: RAISE FND_API.G_EXC_ERROR;

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:
4750: --========================================================================
4751: -- PROCEDURE : Validate_usage_counters PRIVATE

Line 5286: WHEN FND_API.G_EXC_ERROR THEN

5282: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5283: 'Exit.');
5284: END IF;
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);

Line 5287: RAISE FND_API.G_EXC_ERROR;

5283: 'Exit.');
5284: END IF;
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);

Line 5293: RAISE FND_API.G_EXC_ERROR;

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: --========================================================================
5296: -- PROCEDURE : Validate_Sales_Credits PRIVATE
5297: -- PARAMETERS:

Line 5514: WHEN FND_API.G_EXC_ERROR THEN

5510: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5511: 'Exit.');
5512: END IF;
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);

Line 5515: RAISE FND_API.G_EXC_ERROR;

5511: 'Exit.');
5512: END IF;
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);

Line 5521: RAISE FND_API.G_EXC_ERROR;

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:
5524: --========================================================================
5525: -- PROCEDURE : Validate_notes PRIVATE

Line 5793: WHEN FND_API.G_EXC_ERROR THEN

5789: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5790: 'Exit.');
5791: END IF;
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);

Line 5794: RAISE FND_API.G_EXC_ERROR;

5790: 'Exit.');
5791: END IF;
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);

Line 5800: RAISE FND_API.G_EXC_ERROR;

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:
5803: --========================================================================
5804: -- PROCEDURE : Validate_Contracts PUBLIC

Line 5856: WHEN FND_API.G_EXC_ERROR THEN

5852: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5853: 'Exit.');
5854: END IF;
5855: EXCEPTION
5856: WHEN FND_API.G_EXC_ERROR THEN
5857: -- ROLLBACK;
5858: RAISE FND_API.G_EXC_ERROR;
5859: WHEN OTHERS THEN
5860: -- ROLLBACK;

Line 5858: RAISE FND_API.G_EXC_ERROR;

5854: END IF;
5855: EXCEPTION
5856: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 5865: RAISE FND_API.G_EXC_ERROR;

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:
5868: END OKS_IMPORT_VALIDATE;