345: p_count => x_msg_count,
346: p_data => x_msg_data );
347: WHEN l_msite_not_exists_excp THEN
348: x_return_status := FND_API.g_ret_sts_error;
349: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');
350: FND_MSG_PUB.ADD;
351: FND_MSG_PUB.count_and_get(
352: p_encoded => FND_API.g_false,
353: p_count => x_msg_count,
352: p_encoded => FND_API.g_false,
353: p_count => x_msg_count,
354: p_data => x_msg_data );
355: WHEN OTHERS THEN
356: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
357: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
358: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
359: FND_MESSAGE.Set_Token('REASON', SQLERRM);
360: FND_MSG_PUB.Add;
353: p_count => x_msg_count,
354: p_data => x_msg_data );
355: WHEN OTHERS THEN
356: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
357: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
358: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
359: FND_MESSAGE.Set_Token('REASON', SQLERRM);
360: FND_MSG_PUB.Add;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: p_data => x_msg_data );
355: WHEN OTHERS THEN
356: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
357: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
358: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
359: FND_MESSAGE.Set_Token('REASON', SQLERRM);
360: FND_MSG_PUB.Add;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: FND_MSG_PUB.count_and_get(
355: WHEN OTHERS THEN
356: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
357: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
358: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
359: FND_MESSAGE.Set_Token('REASON', SQLERRM);
360: FND_MSG_PUB.Add;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: FND_MSG_PUB.count_and_get(
363: p_encoded => FND_API.g_false,
415: p_encoded => FND_API.g_false,
416: p_count => x_msg_count,
417: p_data => x_msg_data );
418: WHEN OTHERS THEN
419: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
420: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
421: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
422: FND_MESSAGE.Set_Token('REASON', SQLERRM);
423: FND_MSG_PUB.Add;
416: p_count => x_msg_count,
417: p_data => x_msg_data );
418: WHEN OTHERS THEN
419: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
420: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
421: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
422: FND_MESSAGE.Set_Token('REASON', SQLERRM);
423: FND_MSG_PUB.Add;
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: p_data => x_msg_data );
418: WHEN OTHERS THEN
419: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
420: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
421: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
422: FND_MESSAGE.Set_Token('REASON', SQLERRM);
423: FND_MSG_PUB.Add;
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: FND_MSG_PUB.count_and_get(
418: WHEN OTHERS THEN
419: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
420: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
421: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
422: FND_MESSAGE.Set_Token('REASON', SQLERRM);
423: FND_MSG_PUB.Add;
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: FND_MSG_PUB.count_and_get(
426: p_encoded => FND_API.g_false,
698: l_tmp_str := ' ';
699: l_first_idx := x_msite_ids.FIRST;
700:
701: IF (x_msite_ids.COUNT <= 0) THEN
702: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_NO_MSITES_SPECIFIED');
703: FND_MSG_PUB.Add;
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;
706:
934: p_data => x_msg_data);
935:
936: WHEN OTHERS THEN
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
939: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
940: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
941: FND_MESSAGE.Set_Token('REASON', SQLERRM);
942: FND_MSG_PUB.Add;
935:
936: WHEN OTHERS THEN
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
939: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
940: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
941: FND_MESSAGE.Set_Token('REASON', SQLERRM);
942: FND_MSG_PUB.Add;
943: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
936: WHEN OTHERS THEN
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
939: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
940: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
941: FND_MESSAGE.Set_Token('REASON', SQLERRM);
942: FND_MSG_PUB.Add;
943: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
944: p_count => x_msg_count,
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
939: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
940: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
941: FND_MESSAGE.Set_Token('REASON', SQLERRM);
942: FND_MSG_PUB.Add;
943: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
944: p_count => x_msg_count,
945: p_data => x_msg_data);