DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on FND_API

Line 2218: WHEN FND_API.G_EXC_ERROR THEN

2214: G_MODULE_HEAD || l_routine || '.' || l_stmt_num,
2215: 'Exit.');
2216: END IF; */
2217: EXCEPTION
2218: WHEN FND_API.G_EXC_ERROR THEN
2219: RAISE FND_API.G_EXC_ERROR;
2220: WHEN OTHERS THEN
2221: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2222: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 2219: RAISE FND_API.G_EXC_ERROR;

2215: 'Exit.');
2216: END IF; */
2217: EXCEPTION
2218: WHEN FND_API.G_EXC_ERROR THEN
2219: RAISE FND_API.G_EXC_ERROR;
2220: WHEN OTHERS THEN
2221: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2222: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2223: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 2225: RAISE FND_API.G_EXC_ERROR;

2221: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
2222: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
2223: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
2224: FND_MSG_PUB.Add;
2225: RAISE FND_API.G_EXC_ERROR;
2226: END Validate_header;
2227:
2228: --========================================================================
2229: -- PROCEDURE : Validate_lines PRIVATE

Line 3711: WHEN FND_API.G_EXC_ERROR THEN

3707: 'Exit.');
3708: END IF; */
3709:
3710: EXCEPTION
3711: WHEN FND_API.G_EXC_ERROR THEN
3712: RAISE FND_API.G_EXC_ERROR;
3713: WHEN OTHERS THEN
3714: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
3715: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 3712: RAISE FND_API.G_EXC_ERROR;

3708: END IF; */
3709:
3710: EXCEPTION
3711: WHEN FND_API.G_EXC_ERROR THEN
3712: RAISE FND_API.G_EXC_ERROR;
3713: WHEN OTHERS THEN
3714: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
3715: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3716: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 3718: RAISE FND_API.G_EXC_ERROR;

3714: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
3715: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
3716: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
3717: FND_MSG_PUB.Add;
3718: RAISE FND_API.G_EXC_ERROR;
3719: END Validate_lines;
3720:
3721: --========================================================================
3722: -- PROCEDURE : Validate_covered_levels PRIVATE

Line 4614: WHEN FND_API.G_EXC_ERROR THEN

4610: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
4611: 'Exit.');
4612: END IF;
4613: EXCEPTION
4614: WHEN FND_API.G_EXC_ERROR THEN
4615: RAISE FND_API.G_EXC_ERROR;
4616: WHEN OTHERS THEN
4617: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
4618: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 4615: RAISE FND_API.G_EXC_ERROR;

4611: 'Exit.');
4612: END IF;
4613: EXCEPTION
4614: WHEN FND_API.G_EXC_ERROR THEN
4615: RAISE FND_API.G_EXC_ERROR;
4616: WHEN OTHERS THEN
4617: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
4618: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4619: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 4621: RAISE FND_API.G_EXC_ERROR;

4617: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
4618: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
4619: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
4620: FND_MSG_PUB.Add;
4621: RAISE FND_API.G_EXC_ERROR;
4622: END Validate_covered_levels;
4623:
4624: --========================================================================
4625: -- PROCEDURE : Validate_usage_counters PRIVATE

Line 5160: WHEN FND_API.G_EXC_ERROR THEN

5156: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5157: 'Exit.');
5158: END IF;
5159: EXCEPTION
5160: WHEN FND_API.G_EXC_ERROR THEN
5161: RAISE FND_API.G_EXC_ERROR;
5162: WHEN OTHERS THEN
5163: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5164: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 5161: RAISE FND_API.G_EXC_ERROR;

5157: 'Exit.');
5158: END IF;
5159: EXCEPTION
5160: WHEN FND_API.G_EXC_ERROR THEN
5161: RAISE FND_API.G_EXC_ERROR;
5162: WHEN OTHERS THEN
5163: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5164: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5165: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 5167: RAISE FND_API.G_EXC_ERROR;

5163: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5164: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5165: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5166: FND_MSG_PUB.Add;
5167: RAISE FND_API.G_EXC_ERROR;
5168: END Validate_usage_counters;
5169: --========================================================================
5170: -- PROCEDURE : Validate_Sales_Credits PRIVATE
5171: -- PARAMETERS:

Line 5370: WHEN FND_API.G_EXC_ERROR THEN

5366: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5367: 'Exit.');
5368: END IF;
5369: EXCEPTION
5370: WHEN FND_API.G_EXC_ERROR THEN
5371: RAISE FND_API.G_EXC_ERROR;
5372: WHEN OTHERS THEN
5373: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5374: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 5371: RAISE FND_API.G_EXC_ERROR;

5367: 'Exit.');
5368: END IF;
5369: EXCEPTION
5370: WHEN FND_API.G_EXC_ERROR THEN
5371: RAISE FND_API.G_EXC_ERROR;
5372: WHEN OTHERS THEN
5373: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5374: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5375: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 5377: RAISE FND_API.G_EXC_ERROR;

5373: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5374: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5375: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5376: FND_MSG_PUB.Add;
5377: RAISE FND_API.G_EXC_ERROR;
5378: END Validate_Sales_Credits;
5379:
5380: --========================================================================
5381: -- PROCEDURE : Validate_notes PRIVATE

Line 5649: WHEN FND_API.G_EXC_ERROR THEN

5645: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5646: 'Exit.');
5647: END IF;
5648: EXCEPTION
5649: WHEN FND_API.G_EXC_ERROR THEN
5650: RAISE FND_API.G_EXC_ERROR;
5651: WHEN OTHERS THEN
5652: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5653: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 5650: RAISE FND_API.G_EXC_ERROR;

5646: 'Exit.');
5647: END IF;
5648: EXCEPTION
5649: WHEN FND_API.G_EXC_ERROR THEN
5650: RAISE FND_API.G_EXC_ERROR;
5651: WHEN OTHERS THEN
5652: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5653: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5654: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);

Line 5656: RAISE FND_API.G_EXC_ERROR;

5652: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5653: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5654: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5655: FND_MSG_PUB.Add;
5656: RAISE FND_API.G_EXC_ERROR;
5657: END Validate_notes;
5658:
5659: --========================================================================
5660: -- PROCEDURE : Validate_Contracts PUBLIC

Line 5712: WHEN FND_API.G_EXC_ERROR THEN

5708: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
5709: 'Exit.');
5710: END IF;
5711: EXCEPTION
5712: WHEN FND_API.G_EXC_ERROR THEN
5713: -- ROLLBACK;
5714: RAISE FND_API.G_EXC_ERROR;
5715: WHEN OTHERS THEN
5716: -- ROLLBACK;

Line 5714: RAISE FND_API.G_EXC_ERROR;

5710: END IF;
5711: EXCEPTION
5712: WHEN FND_API.G_EXC_ERROR THEN
5713: -- ROLLBACK;
5714: RAISE FND_API.G_EXC_ERROR;
5715: WHEN OTHERS THEN
5716: -- ROLLBACK;
5717: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5718: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);

Line 5721: RAISE FND_API.G_EXC_ERROR;

5717: FND_MESSAGE.Set_Name('OKS', 'OKS_IMPORT_UNEXPECTED');
5718: FND_MESSAGE.set_token('ROUTINE', G_PKG_NAME||'.'||l_routine);
5719: FND_MESSAGE.set_token('MESSAGE', 'stmt_num '||l_stmt_num||' ('||SQLCODE||') '||SQLERRM);
5720: FND_MSG_PUB.Add;
5721: RAISE FND_API.G_EXC_ERROR;
5722: END Validate_Contracts;
5723:
5724: END OKS_IMPORT_VALIDATE;