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 5260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5256:
5257: EXCEPTION
5258: WHEN OTHERS THEN
5259: ROLLBACK to identify_candidates;
5260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5261: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
5262: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
5263: FND_MSG_PUB.ADD;
5264: FND_MSG_PUB.Count_And_Get(

Line 5265: p_encoded => FND_API.G_FALSE,

5261: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
5262: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
5263: FND_MSG_PUB.ADD;
5264: FND_MSG_PUB.Count_And_Get(
5265: p_encoded => FND_API.G_FALSE,
5266: p_count => x_msg_count,
5267: p_data => x_msg_data );
5268: RAISE FND_API.G_EXC_ERROR;
5269: END IDENTIFY_CANDIDATES;

Line 5268: RAISE FND_API.G_EXC_ERROR;

5264: FND_MSG_PUB.Count_And_Get(
5265: p_encoded => FND_API.G_FALSE,
5266: p_count => x_msg_count,
5267: p_data => x_msg_data );
5268: RAISE FND_API.G_EXC_ERROR;
5269: END IDENTIFY_CANDIDATES;
5270: END HZ_PURGE_GEN;