DBA Data[Home] [Help]

APPS.IBE_MSITE_INFORMATION_MGR_PVT dependencies on FND_MESSAGE

Line 158: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_INFO_FL');

154: x_msg_data => x_msg_data
155: );
156:
157: IF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_UNEXP_ERROR) THEN
158: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_INFO_FL');
159: FND_MSG_PUB.Add;
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: ELSIF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_ERROR) THEN
162: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_INFO_FL');

Line 162: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_INFO_FL');

158: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_INFO_FL');
159: FND_MSG_PUB.Add;
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: ELSIF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_ERROR) THEN
162: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_CREATE_MSITE_INFO_FL');
163: FND_MSG_PUB.Add;
164: RAISE FND_API.G_EXC_ERROR;
165: END IF;
166:

Line 219: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_INFO_FL');

215: x_msg_data => x_msg_data
216: );
217:
218: IF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_UNEXP_ERROR) THEN
219: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_INFO_FL');
220: FND_MSG_PUB.Add;
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: ELSIF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_ERROR) THEN
223: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_INFO_FL');

Line 223: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_INFO_FL');

219: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_INFO_FL');
220: FND_MSG_PUB.Add;
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: ELSIF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_ERROR) THEN
223: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_UPDATE_MSITE_INFO_FL');
224: FND_MSG_PUB.Add;
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227:

Line 245: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_INFO_FL');

241: x_msg_data => x_msg_data
242: );
243:
244: IF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_UNEXP_ERROR) THEN
245: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_INFO_FL');
246: FND_MSG_PUB.Add;
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: ELSIF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_ERROR) THEN
249: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_INFO_FL');

Line 249: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_INFO_FL');

245: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_INFO_FL');
246: FND_MSG_PUB.Add;
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: ELSIF (x_msite_info_return_statuses(i) = FND_API.G_RET_STS_ERROR) THEN
249: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_DELETE_MSITE_INFO_FL');
250: FND_MSG_PUB.Add;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253:

Line 260: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_OP_FLAG');

256: ELSIF (p_operation_flags(i) = 'N') THEN
257: -- do nothing
258: x_msite_information_ids(i) := p_msite_information_ids(i);
259: ELSE
260: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_OP_FLAG');
261: FND_MESSAGE.Set_Token('FLAG', p_operation_flags(i));
262: FND_MSG_PUB.Add;
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;

Line 261: FND_MESSAGE.Set_Token('FLAG', p_operation_flags(i));

257: -- do nothing
258: x_msite_information_ids(i) := p_msite_information_ids(i);
259: ELSE
260: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_INFO_INVALID_OP_FLAG');
261: FND_MESSAGE.Set_Token('FLAG', p_operation_flags(i));
262: FND_MSG_PUB.Add;
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265:

Line 299: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

295: p_encoded => 'F');
296:
297: WHEN OTHERS THEN
298: ROLLBACK TO Change_Msite_Info_Pvt;
299: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
300: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
301: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
302: FND_MESSAGE.Set_Token('REASON', SQLERRM);
303: FND_MSG_PUB.Add;

Line 300: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

296:
297: WHEN OTHERS THEN
298: ROLLBACK TO Change_Msite_Info_Pvt;
299: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
300: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
301: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
302: FND_MESSAGE.Set_Token('REASON', SQLERRM);
303: FND_MSG_PUB.Add;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 301: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

297: WHEN OTHERS THEN
298: ROLLBACK TO Change_Msite_Info_Pvt;
299: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
300: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
301: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
302: FND_MESSAGE.Set_Token('REASON', SQLERRM);
303: FND_MSG_PUB.Add;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305:

Line 302: FND_MESSAGE.Set_Token('REASON', SQLERRM);

298: ROLLBACK TO Change_Msite_Info_Pvt;
299: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
300: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
301: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
302: FND_MESSAGE.Set_Token('REASON', SQLERRM);
303: FND_MSG_PUB.Add;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305:
306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 781: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

777: p_data => x_msg_data,
778: p_encoded => 'F');
779: WHEN OTHERS THEN
780: ROLLBACK TO DUPLICATE_MSITE_INFO_SAVE;
781: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
782: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
783: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
784: FND_MESSAGE.Set_Token('REASON', SQLERRM);
785: FND_MSG_PUB.Add;

Line 782: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

778: p_encoded => 'F');
779: WHEN OTHERS THEN
780: ROLLBACK TO DUPLICATE_MSITE_INFO_SAVE;
781: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
782: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
783: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
784: FND_MESSAGE.Set_Token('REASON', SQLERRM);
785: FND_MSG_PUB.Add;
786: IF (l_debug = 'Y') THEN

Line 783: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

779: WHEN OTHERS THEN
780: ROLLBACK TO DUPLICATE_MSITE_INFO_SAVE;
781: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
782: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
783: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
784: FND_MESSAGE.Set_Token('REASON', SQLERRM);
785: FND_MSG_PUB.Add;
786: IF (l_debug = 'Y') THEN
787: IBE_UTIL.debug('SQLCODE:'||SQLCODE);

Line 784: FND_MESSAGE.Set_Token('REASON', SQLERRM);

780: ROLLBACK TO DUPLICATE_MSITE_INFO_SAVE;
781: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
782: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
783: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
784: FND_MESSAGE.Set_Token('REASON', SQLERRM);
785: FND_MSG_PUB.Add;
786: IF (l_debug = 'Y') THEN
787: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
788: IBE_UTIL.debug('SQLERRM:'||SQLERRM);