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:
74: -- Initialize API return status to SUCCESS
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
112: END IF;
113:
114:
115: -- Standard callto get message count and if count is 1, get message info.
116: FND_MSG_PUB.Count_And_Get
117: ( p_count => x_msg_count,
118: p_data => x_msg_data
119: );
120:
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;
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
125:
126: FND_MESSAGE.SET_NAME('IEM', 'IEM_FAILED_DECRYPT_ACCT_PWD');
127:
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;
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
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: );
148:
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
156: ( G_PKG_NAME ,
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
156: ( G_PKG_NAME ,
157: l_api_name
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
156: ( G_PKG_NAME ,
157: l_api_name
158: );
159: END IF;
157: l_api_name
158: );
159: END IF;
160:
161: FND_MSG_PUB.Count_And_Get
162: ( p_count => x_msg_count,
163: p_data => x_msg_data
164:
165: );