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);
2224: FND_MSG_PUB.Add;
2225: RAISE FND_API.G_EXC_ERROR;
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);
2224: FND_MSG_PUB.Add;
2225: RAISE FND_API.G_EXC_ERROR;
2226: END Validate_header;
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);
2224: FND_MSG_PUB.Add;
2225: RAISE FND_API.G_EXC_ERROR;
2226: END Validate_header;
2227:
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);
3717: FND_MSG_PUB.Add;
3718: RAISE FND_API.G_EXC_ERROR;
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);
3717: FND_MSG_PUB.Add;
3718: RAISE FND_API.G_EXC_ERROR;
3719: END Validate_lines;
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);
3717: FND_MSG_PUB.Add;
3718: RAISE FND_API.G_EXC_ERROR;
3719: END Validate_lines;
3720:
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);
4620: FND_MSG_PUB.Add;
4621: RAISE FND_API.G_EXC_ERROR;
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);
4620: FND_MSG_PUB.Add;
4621: RAISE FND_API.G_EXC_ERROR;
4622: END Validate_covered_levels;
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);
4620: FND_MSG_PUB.Add;
4621: RAISE FND_API.G_EXC_ERROR;
4622: END Validate_covered_levels;
4623:
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);
5166: FND_MSG_PUB.Add;
5167: RAISE FND_API.G_EXC_ERROR;
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);
5166: FND_MSG_PUB.Add;
5167: RAISE FND_API.G_EXC_ERROR;
5168: END Validate_usage_counters;
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);
5166: FND_MSG_PUB.Add;
5167: RAISE FND_API.G_EXC_ERROR;
5168: END Validate_usage_counters;
5169: --========================================================================
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);
5376: FND_MSG_PUB.Add;
5377: RAISE FND_API.G_EXC_ERROR;
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);
5376: FND_MSG_PUB.Add;
5377: RAISE FND_API.G_EXC_ERROR;
5378: END Validate_Sales_Credits;
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);
5376: FND_MSG_PUB.Add;
5377: RAISE FND_API.G_EXC_ERROR;
5378: END Validate_Sales_Credits;
5379:
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);
5655: FND_MSG_PUB.Add;
5656: RAISE FND_API.G_EXC_ERROR;
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);
5655: FND_MSG_PUB.Add;
5656: RAISE FND_API.G_EXC_ERROR;
5657: END Validate_notes;
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);
5655: FND_MSG_PUB.Add;
5656: RAISE FND_API.G_EXC_ERROR;
5657: END Validate_notes;
5658:
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);
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;
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);
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;
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);
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: