DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on FND_MSG_PUB

Line 2254: FND_MSG_PUB.Add;

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);
2254: FND_MSG_PUB.Add;
2255: RAISE FND_API.G_EXC_ERROR;
2256: END Validate_header;
2257:
2258: --========================================================================

Line 3769: FND_MSG_PUB.Add;

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);
3769: FND_MSG_PUB.Add;
3770: RAISE FND_API.G_EXC_ERROR;
3771: END Validate_lines;
3772:
3773: --========================================================================

Line 4746: FND_MSG_PUB.Add;

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);
4746: FND_MSG_PUB.Add;
4747: RAISE FND_API.G_EXC_ERROR;
4748: END Validate_covered_levels;
4749:
4750: --========================================================================

Line 5292: FND_MSG_PUB.Add;

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);
5292: FND_MSG_PUB.Add;
5293: RAISE FND_API.G_EXC_ERROR;
5294: END Validate_usage_counters;
5295: --========================================================================
5296: -- PROCEDURE : Validate_Sales_Credits PRIVATE

Line 5520: FND_MSG_PUB.Add;

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);
5520: FND_MSG_PUB.Add;
5521: RAISE FND_API.G_EXC_ERROR;
5522: END Validate_Sales_Credits;
5523:
5524: --========================================================================

Line 5799: FND_MSG_PUB.Add;

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);
5799: FND_MSG_PUB.Add;
5800: RAISE FND_API.G_EXC_ERROR;
5801: END Validate_notes;
5802:
5803: --========================================================================

Line 5828: FND_MSG_PUB.initialize;

5824: 'P_rowid_from = '|| P_rowid_from ||','||
5825: 'P_rowid_to = '|| P_rowid_to);
5826: END IF;
5827:
5828: FND_MSG_PUB.initialize;
5829:
5830: l_stmt_num := 10;
5831: /* delete from errors table all the records related to the contracts which are going to be validated by this worker.*/
5832: DELETE FROM OKS_IMP_ERRORS

Line 5864: FND_MSG_PUB.Add;

5860: -- ROLLBACK;
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;