DBA Data[Home] [Help]

APPS.IEM_SERVER_PUB dependencies on FND_API

Line 35: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

31: BEGIN
32: -- Standard Start of API savepoint
33: SAVEPOINT Get_EmailServer_List_PUB;
34: -- Standard call to check for call compatibility.
35: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
36: p_api_version_number,
37: l_api_name,
38: G_PKG_NAME)
39: THEN

Line 40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

36: p_api_version_number,
37: l_api_name,
38: G_PKG_NAME)
39: THEN
40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
41: END IF;
42: -- Initialize message list if p_init_msg_list is set to TRUE.
43: IF FND_API.to_Boolean( p_init_msg_list )
44: THEN

Line 43: IF FND_API.to_Boolean( p_init_msg_list )

39: THEN
40: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
41: END IF;
42: -- Initialize message list if p_init_msg_list is set to TRUE.
43: IF FND_API.to_Boolean( p_init_msg_list )
44: THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47: -- Initialize API return status to SUCCESS

Line 48: x_return_status := FND_API.G_RET_STS_SUCCESS;

44: THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47: -- Initialize API return status to SUCCESS
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49: IF p_server_type='IMAP' then
50: FOR v1 IN in_server LOOP
51: x_Email_Svr_tbl(l_email_svr_index).server_name:=v1.in_host;
52: x_Email_Svr_tbl(l_email_svr_index).active:='Y';

Line 65: IF FND_API.To_Boolean(p_commit) THEN

61: l_email_svr_index:=l_email_svr_index+1;
62: END LOOP;
63: END IF;
64: -- Standard Check Of p_commit.
65: IF FND_API.To_Boolean(p_commit) THEN
66: COMMIT WORK;
67: END IF;
68: -- Standard callto get message count and if count is 1, get message info.
69: FND_MSG_PUB.Count_And_Get

Line 74: WHEN FND_API.G_EXC_ERROR THEN

70: ( p_count => x_msg_count,
71: p_data => x_msg_data
72: );
73: EXCEPTION
74: WHEN FND_API.G_EXC_ERROR THEN
75: ROLLBACK TO Get_EmailServer_List_PUB;
76: x_return_status := FND_API.G_RET_STS_ERROR ;
77: FND_MSG_PUB.Count_And_Get
78: ( p_count => x_msg_count,

Line 76: x_return_status := FND_API.G_RET_STS_ERROR ;

72: );
73: EXCEPTION
74: WHEN FND_API.G_EXC_ERROR THEN
75: ROLLBACK TO Get_EmailServer_List_PUB;
76: x_return_status := FND_API.G_RET_STS_ERROR ;
77: FND_MSG_PUB.Count_And_Get
78: ( p_count => x_msg_count,
79: p_data => x_msg_data
80: );

Line 81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

77: FND_MSG_PUB.Count_And_Get
78: ( p_count => x_msg_count,
79: p_data => x_msg_data
80: );
81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
82: ROLLBACK TO Get_EmailServer_List_PUB;
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
84: FND_MSG_PUB.Count_And_Get
85: ( p_count => x_msg_count,

Line 83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

79: p_data => x_msg_data
80: );
81: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
82: ROLLBACK TO Get_EmailServer_List_PUB;
83: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
84: FND_MSG_PUB.Count_And_Get
85: ( p_count => x_msg_count,
86: p_data => x_msg_data
87: );

Line 90: x_return_status := FND_API.G_RET_STS_ERROR;

86: p_data => x_msg_data
87: );
88: WHEN OTHERS THEN
89: ROLLBACK TO Get_EmailServer_List_PUB;
90: x_return_status := FND_API.G_RET_STS_ERROR;
91: IF FND_MSG_PUB.Check_Msg_Level
92: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
93: THEN
94: FND_MSG_PUB.Add_Exc_Msg