APPS.IEM_ARCH_DTLS_PVT dependencies on FND_API

Line 25: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

21: l_api_version_number NUMBER:=1.0;
22:
23: BEGIN
24: -- Standard call to check for call compatibility.
25: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
26: p_api_version_number,
27: l_api_name,
28: G_PKG_NAME)
29: THEN

Line 30: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

26: p_api_version_number,
27: l_api_name,
28: G_PKG_NAME)
29: THEN
30: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
31: END IF;
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33: SAVEPOINT IEM_ARCH_DTL_PVT;
34: FOR i in p_source_message_id.FIRST..p_source_message_id.LAST LOOP

Line 32: x_return_status := FND_API.G_RET_STS_SUCCESS;

28: G_PKG_NAME)
29: THEN
30: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
31: END IF;
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33: SAVEPOINT IEM_ARCH_DTL_PVT;
34: FOR i in p_source_message_id.FIRST..p_source_message_id.LAST LOOP
35: IF p_source_message_id(i) is not null then
36: INSERT INTO IEM_ARCHIVED_DTLS

Line 64: WHEN FND_API.G_EXC_ERROR THEN

60: ( p_count => x_msg_count,
61: p_data => x_msg_data
62: );
63: EXCEPTION
64: WHEN FND_API.G_EXC_ERROR THEN
65: x_return_status := FND_API.G_RET_STS_ERROR ;
66: rollback to IEM_ARCH_DTL_PVT;
67: FND_MSG_PUB.Count_And_Get
68: ( p_count => x_msg_count,

Line 65: x_return_status := FND_API.G_RET_STS_ERROR ;

61: p_data => x_msg_data
62: );
63: EXCEPTION
64: WHEN FND_API.G_EXC_ERROR THEN
65: x_return_status := FND_API.G_RET_STS_ERROR ;
66: rollback to IEM_ARCH_DTL_PVT;
67: FND_MSG_PUB.Count_And_Get
68: ( p_count => x_msg_count,
69: p_data => x_msg_data

Line 71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

67: FND_MSG_PUB.Count_And_Get
68: ( p_count => x_msg_count,
69: p_data => x_msg_data
70: );
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: rollback to IEM_ARCH_DTL_PVT;
74: FND_MSG_PUB.Count_And_Get
75: ( p_count => x_msg_count,

Line 72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

68: ( p_count => x_msg_count,
69: p_data => x_msg_data
70: );
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: rollback to IEM_ARCH_DTL_PVT;
74: FND_MSG_PUB.Count_And_Get
75: ( p_count => x_msg_count,
76: p_data => x_msg_data

Line 79: x_return_status := FND_API.G_RET_STS_ERROR;

75: ( p_count => x_msg_count,
76: p_data => x_msg_data
77: );
78: WHEN OTHERS THEN
79: x_return_status := FND_API.G_RET_STS_ERROR;
80: rollback to IEM_ARCH_DTL_PVT;
81: IF FND_MSG_PUB.Check_Msg_Level
82: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
83: THEN