DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on FND_MESSAGE

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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: --========================================================================

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

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;

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

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;

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

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:

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

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;

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

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;

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

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:

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

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;

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

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;

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

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: