DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on FND_API

Line 2: PROCEDURE IDENTIFY_CANDIDATES(p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1: PACKAGE BODY HZ_PURGE_GEN AS
2: PROCEDURE IDENTIFY_CANDIDATES(p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3: x_return_status OUT NOCOPY VARCHAR2,
4: x_msg_count OUT NOCOPY NUMBER,
5: x_msg_data OUT NOCOPY VARCHAR2,
6: check_flag boolean, con_prg boolean, regid_proc boolean) IS

Line 23: IF FND_API.to_Boolean(p_init_msg_list) THEN

19: BEGIN
20:
21:
22: SAVEPOINT identify_candidates;
23: IF FND_API.to_Boolean(p_init_msg_list) THEN
24: FND_MSG_PUB.initialize;
25: END IF;
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27: delete from hz_application_trans_gt;

Line 26: x_return_status := FND_API.G_RET_STS_SUCCESS;

22: SAVEPOINT identify_candidates;
23: IF FND_API.to_Boolean(p_init_msg_list) THEN
24: FND_MSG_PUB.initialize;
25: END IF;
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27: delete from hz_application_trans_gt;
28: open repopulate;
29: fetch repopulate into single_party;
30: close repopulate;

Line 5480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5476:
5477: EXCEPTION
5478: WHEN OTHERS THEN
5479: ROLLBACK to identify_candidates;
5480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5481: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
5482: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
5483: FND_MSG_PUB.ADD;
5484: FND_MSG_PUB.Count_And_Get(

Line 5485: p_encoded => FND_API.G_FALSE,

5481: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
5482: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
5483: FND_MSG_PUB.ADD;
5484: FND_MSG_PUB.Count_And_Get(
5485: p_encoded => FND_API.G_FALSE,
5486: p_count => x_msg_count,
5487: p_data => x_msg_data );
5488: RAISE FND_API.G_EXC_ERROR;
5489: END IDENTIFY_CANDIDATES;

Line 5488: RAISE FND_API.G_EXC_ERROR;

5484: FND_MSG_PUB.Count_And_Get(
5485: p_encoded => FND_API.G_FALSE,
5486: p_count => x_msg_count,
5487: p_data => x_msg_data );
5488: RAISE FND_API.G_EXC_ERROR;
5489: END IDENTIFY_CANDIDATES;
5490: END HZ_PURGE_GEN;