APPS.IEM_EMTA_ACCT_PVT dependencies on FND_API

Line 38: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

34: is
35: l_api_name VARCHAR2(255):='LOAD_ACCOUNT_INFO';
36: l_api_version_number NUMBER:=1.0;
37:
38: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
39: l_msg_count NUMBER := 0;
40: l_msg_data VARCHAR2(2000);
41:
42: l_user_name varchar2(100);

Line 62: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

58: SAVEPOINT LOAD_ACCOUNT_INFO_PVT;
59:
60: -- Standard call to check for call compatibility.
61:
62: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
63: p_api_version_number,
64: l_api_name,
65: G_PKG_NAME)
66: THEN

Line 67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

63: p_api_version_number,
64: l_api_name,
65: G_PKG_NAME)
66: THEN
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69:
70:
71: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 72: IF FND_API.to_Boolean( p_init_msg_list )

68: END IF;
69:
70:
71: -- Initialize message list if p_init_msg_list is set to TRUE.
72: IF FND_API.to_Boolean( p_init_msg_list )
73: THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76:

Line 78: x_return_status := FND_API.G_RET_STS_SUCCESS;

74: FND_MSG_PUB.initialize;
75: END IF;
76:
77: -- Initialize API return status to SUCCESS
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79:
80: --begins here
81:
82: --select user_name, user_password, encrypt_key, in_host, in_port

Line 101: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

97: x_return_status =>l_return_status,
98: x_msg_count => l_msg_count,
99: x_msg_data => l_msg_data);
100:
101: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
102: raise IEM_FAILED_DECRYPT_ACCT_PWD;
103: end if;
104:
105: */

Line 114: IF FND_API.To_Boolean(p_commit) THEN

110: X_IN_PORT := l_in_port;
111: X_SSL_CONNECTION_FLAG := l_ssl_connection_flag;
112:
113: -- Standard Check Of p_commit.
114: IF FND_API.To_Boolean(p_commit) THEN
115: COMMIT WORK;
116: END IF;
117:
118:

Line 128: x_return_status := FND_API.G_RET_STS_ERROR;

124:
125: EXCEPTION
126: WHEN IEM_FAILED_DECRYPT_ACCT_PWD THEN
127: ROLLBACK TO CHECK_IF_ACCOUNT_UPDATED_PVT;
128: x_return_status := FND_API.G_RET_STS_ERROR;
129:
130: FND_MESSAGE.SET_NAME('IEM', 'IEM_FAILED_DECRYPT_ACCT_PWD');
131:
132: FND_MSG_PUB.ADD;

Line 136: WHEN FND_API.G_EXC_ERROR THEN

132: FND_MSG_PUB.ADD;
133: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
134:
135:
136: WHEN FND_API.G_EXC_ERROR THEN
137: ROLLBACK TO LOAD_ACCOUNT_INFO_PVT;
138: x_return_status := FND_API.G_RET_STS_ERROR ;
139: FND_MSG_PUB.Count_And_Get
140:

Line 138: x_return_status := FND_API.G_RET_STS_ERROR ;

134:
135:
136: WHEN FND_API.G_EXC_ERROR THEN
137: ROLLBACK TO LOAD_ACCOUNT_INFO_PVT;
138: x_return_status := FND_API.G_RET_STS_ERROR ;
139: FND_MSG_PUB.Count_And_Get
140:
141: ( p_count => x_msg_count,
142: p_data => x_msg_data

Line 145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

141: ( p_count => x_msg_count,
142: p_data => x_msg_data
143: );
144:
145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
146: ROLLBACK TO LOAD_ACCOUNT_INFO_PVT;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
148: FND_MSG_PUB.Count_And_Get
149: ( p_count => x_msg_count,

Line 147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

143: );
144:
145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
146: ROLLBACK TO LOAD_ACCOUNT_INFO_PVT;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
148: FND_MSG_PUB.Count_And_Get
149: ( p_count => x_msg_count,
150: p_data => x_msg_data
151: );

Line 155: x_return_status := FND_API.G_RET_STS_ERROR;

151: );
152:
153: WHEN OTHERS THEN
154: ROLLBACK TO LOAD_ACCOUNT_INFO_PVT;
155: x_return_status := FND_API.G_RET_STS_ERROR;
156: IF FND_MSG_PUB.Check_Msg_Level
157: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
158: THEN
159: FND_MSG_PUB.Add_Exc_Msg