APPS.IEM_EMTA_ACCT_PVT dependencies on FND_API

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

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

Line 59: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

Line 64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 69: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 75: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 110: IF FND_API.To_Boolean(p_commit) THEN

106: X_IN_HOST := l_in_host;
107: X_IN_PORT := l_in_port;
108:
109: -- Standard Check Of p_commit.
110: IF FND_API.To_Boolean(p_commit) THEN
111: COMMIT WORK;
112: END IF;
113:
114:

Line 124: x_return_status := FND_API.G_RET_STS_ERROR;

120:
121: EXCEPTION
122: WHEN IEM_FAILED_DECRYPT_ACCT_PWD THEN
123: ROLLBACK TO CHECK_IF_ACCOUNT_UPDATED_PVT;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125:
126: FND_MESSAGE.SET_NAME('IEM', 'IEM_FAILED_DECRYPT_ACCT_PWD');
127:
128: FND_MSG_PUB.ADD;

Line 132: WHEN FND_API.G_EXC_ERROR THEN

128: FND_MSG_PUB.ADD;
129: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
130:
131:
132: WHEN FND_API.G_EXC_ERROR THEN
133: ROLLBACK TO LOAD_ACCOUNT_INFO_PVT;
134: x_return_status := FND_API.G_RET_STS_ERROR ;
135: FND_MSG_PUB.Count_And_Get
136:

Line 134: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

137: ( p_count => x_msg_count,
138: p_data => x_msg_data
139: );
140:
141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
142: ROLLBACK TO LOAD_ACCOUNT_INFO_PVT;
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
144: FND_MSG_PUB.Count_And_Get
145: ( p_count => x_msg_count,

Line 143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 151: x_return_status := FND_API.G_RET_STS_ERROR;

147: );
148:
149: WHEN OTHERS THEN
150: ROLLBACK TO LOAD_ACCOUNT_INFO_PVT;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: IF FND_MSG_PUB.Check_Msg_Level
153: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
154: THEN
155: FND_MSG_PUB.Add_Exc_Msg