256: p_data => x_msg_data );
257: WHEN l_msite_not_exists_excp THEN
258: ROLLBACK TO get_msite_details;
259: x_return_status := FND_API.g_ret_sts_error;
260: FND_MESSAGE.set_name('JTF','JTF_MSITE_NOT_EXISTS');
261: FND_MSG_PUB.ADD;
262: FND_MSG_PUB.count_and_get(
263: p_encoded => FND_API.g_false,
264: p_count => x_msg_count,
264: p_count => x_msg_count,
265: p_data => x_msg_data );
266: WHEN OTHERS THEN
267: ROLLBACK TO get_msite_details;
268: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
269: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
270: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
271: FND_MESSAGE.Set_Token('REASON', SQLERRM);
272: FND_MSG_PUB.Add;
265: p_data => x_msg_data );
266: WHEN OTHERS THEN
267: ROLLBACK TO get_msite_details;
268: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
269: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
270: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
271: FND_MESSAGE.Set_Token('REASON', SQLERRM);
272: FND_MSG_PUB.Add;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: WHEN OTHERS THEN
267: ROLLBACK TO get_msite_details;
268: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
269: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
270: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
271: FND_MESSAGE.Set_Token('REASON', SQLERRM);
272: FND_MSG_PUB.Add;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: FND_MSG_PUB.count_and_get(
267: ROLLBACK TO get_msite_details;
268: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
269: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
270: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
271: FND_MESSAGE.Set_Token('REASON', SQLERRM);
272: FND_MSG_PUB.Add;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: FND_MSG_PUB.count_and_get(
275: p_encoded => FND_API.g_false,
416: l_tmp_str := ' ';
417: l_first_idx := x_msite_ids.FIRST;
418:
419: IF (x_msite_ids.COUNT <= 0) THEN
420: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_NO_MSITES_SPECIFIED');
421: FND_MSG_PUB.Add;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424:
563: p_data => x_msg_data);
564:
565: WHEN OTHERS THEN
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
568: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
569: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
570: FND_MESSAGE.Set_Token('REASON', SQLERRM);
571: FND_MSG_PUB.Add;
564:
565: WHEN OTHERS THEN
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
568: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
569: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
570: FND_MESSAGE.Set_Token('REASON', SQLERRM);
571: FND_MSG_PUB.Add;
572: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
565: WHEN OTHERS THEN
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
568: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
569: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
570: FND_MESSAGE.Set_Token('REASON', SQLERRM);
571: FND_MSG_PUB.Add;
572: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
573: p_count => x_msg_count,
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
568: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
569: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
570: FND_MESSAGE.Set_Token('REASON', SQLERRM);
571: FND_MSG_PUB.Add;
572: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
573: p_count => x_msg_count,
574: p_data => x_msg_data);