DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on FND_MSG_PUB

Line 2224: FND_MSG_PUB.Add;

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

Line 3717: FND_MSG_PUB.Add;

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

Line 4620: FND_MSG_PUB.Add;

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

Line 5166: FND_MSG_PUB.Add;

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: --========================================================================
5170: -- PROCEDURE : Validate_Sales_Credits PRIVATE

Line 5376: FND_MSG_PUB.Add;

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

Line 5655: FND_MSG_PUB.Add;

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

Line 5684: FND_MSG_PUB.initialize;

5680: 'P_rowid_from = '|| P_rowid_from ||','||
5681: 'P_rowid_to = '|| P_rowid_to);
5682: END IF;
5683:
5684: FND_MSG_PUB.initialize;
5685:
5686: l_stmt_num := 10;
5687: /* delete from errors table all the records related to the contracts which are going to be validated by this worker.*/
5688: DELETE FROM OKS_IMP_ERRORS

Line 5720: FND_MSG_PUB.Add;

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