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:
77: -- Initialize API return status to SUCCESS
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
116: END IF;
117:
118:
119: -- Standard callto get message count and if count is 1, get message info.
120: FND_MSG_PUB.Count_And_Get
121: ( p_count => x_msg_count,
122: p_data => x_msg_data
123: );
124:
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;
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
129:
130: FND_MESSAGE.SET_NAME('IEM', 'IEM_FAILED_DECRYPT_ACCT_PWD');
131:
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;
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
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: );
152:
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
160: ( G_PKG_NAME ,
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
160: ( G_PKG_NAME ,
161: l_api_name
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
160: ( G_PKG_NAME ,
161: l_api_name
162: );
163: END IF;
161: l_api_name
162: );
163: END IF;
164:
165: FND_MSG_PUB.Count_And_Get
166: ( p_count => x_msg_count,
167: p_data => x_msg_data
168:
169: );