181: p_data => x_msg_data);
182:
183: WHEN l_msite_not_exists_excp THEN
184: x_return_status := FND_API.g_ret_sts_error;
185: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');
186: FND_MSG_PUB.ADD;
187: FND_MSG_PUB.count_and_get(
188: p_encoded => FND_API.g_false,
189: p_count => x_msg_count,
190: p_data => x_msg_data );
191:
192: WHEN OTHERS THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
195: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
196: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
197: FND_MESSAGE.Set_Token('REASON', SQLERRM);
198: FND_MSG_PUB.Add;
191:
192: WHEN OTHERS THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
195: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
196: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
197: FND_MESSAGE.Set_Token('REASON', SQLERRM);
198: FND_MSG_PUB.Add;
199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
192: WHEN OTHERS THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
195: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
196: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
197: FND_MESSAGE.Set_Token('REASON', SQLERRM);
198: FND_MSG_PUB.Add;
199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
200: p_count => x_msg_count,
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
195: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
196: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
197: FND_MESSAGE.Set_Token('REASON', SQLERRM);
198: FND_MSG_PUB.Add;
199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
200: p_count => x_msg_count,
201: p_data => x_msg_data);
290: p_data => x_msg_data);
291:
292: WHEN l_msite_not_exists_excp THEN
293: x_return_status := FND_API.g_ret_sts_error;
294: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');
295: FND_MSG_PUB.ADD;
296: FND_MSG_PUB.count_and_get(
297: p_encoded => FND_API.g_false,
298: p_count => x_msg_count,
299: p_data => x_msg_data );
300:
301: WHEN OTHERS THEN
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
304: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
305: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
306: FND_MESSAGE.Set_Token('REASON', SQLERRM);
307: FND_MSG_PUB.Add;
300:
301: WHEN OTHERS THEN
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
304: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
305: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
306: FND_MESSAGE.Set_Token('REASON', SQLERRM);
307: FND_MSG_PUB.Add;
308: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
301: WHEN OTHERS THEN
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
304: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
305: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
306: FND_MESSAGE.Set_Token('REASON', SQLERRM);
307: FND_MSG_PUB.Add;
308: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
309: p_count => x_msg_count,
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
304: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
305: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
306: FND_MESSAGE.Set_Token('REASON', SQLERRM);
307: FND_MSG_PUB.Add;
308: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
309: p_count => x_msg_count,
310: p_data => x_msg_data);
610: p_count => x_msg_count,
611: p_data => x_msg_data );
612: WHEN l_msite_not_exists_excp THEN
613: x_return_status := FND_API.g_ret_sts_error;
614: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');
615: FND_MSG_PUB.ADD;
616: FND_MSG_PUB.count_and_get(
617: p_encoded => FND_API.g_false,
618: p_count => x_msg_count,
617: p_encoded => FND_API.g_false,
618: p_count => x_msg_count,
619: p_data => x_msg_data );
620: WHEN OTHERS THEN
621: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
622: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
623: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
624: FND_MESSAGE.Set_Token('REASON', SQLERRM);
625: FND_MSG_PUB.Add;
618: p_count => x_msg_count,
619: p_data => x_msg_data );
620: WHEN OTHERS THEN
621: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
622: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
623: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
624: FND_MESSAGE.Set_Token('REASON', SQLERRM);
625: FND_MSG_PUB.Add;
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
619: p_data => x_msg_data );
620: WHEN OTHERS THEN
621: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
622: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
623: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
624: FND_MESSAGE.Set_Token('REASON', SQLERRM);
625: FND_MSG_PUB.Add;
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: FND_MSG_PUB.count_and_get(
620: WHEN OTHERS THEN
621: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
622: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
623: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
624: FND_MESSAGE.Set_Token('REASON', SQLERRM);
625: FND_MSG_PUB.Add;
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: FND_MSG_PUB.count_and_get(
628: p_encoded => FND_API.g_false,
680: p_encoded => FND_API.g_false,
681: p_count => x_msg_count,
682: p_data => x_msg_data );
683: WHEN OTHERS THEN
684: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
685: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
686: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
687: FND_MESSAGE.Set_Token('REASON', SQLERRM);
688: FND_MSG_PUB.Add;
681: p_count => x_msg_count,
682: p_data => x_msg_data );
683: WHEN OTHERS THEN
684: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
685: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
686: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
687: FND_MESSAGE.Set_Token('REASON', SQLERRM);
688: FND_MSG_PUB.Add;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: p_data => x_msg_data );
683: WHEN OTHERS THEN
684: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
685: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
686: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
687: FND_MESSAGE.Set_Token('REASON', SQLERRM);
688: FND_MSG_PUB.Add;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: FND_MSG_PUB.count_and_get(
683: WHEN OTHERS THEN
684: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
685: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
686: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
687: FND_MESSAGE.Set_Token('REASON', SQLERRM);
688: FND_MSG_PUB.Add;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: FND_MSG_PUB.count_and_get(
691: p_encoded => FND_API.g_false,
963: l_tmp_str := ' ';
964: l_first_idx := x_msite_ids.FIRST;
965:
966: IF (x_msite_ids.COUNT <= 0) THEN
967: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_NO_MSITES_SPECIFIED');
968: FND_MSG_PUB.Add;
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971:
1207: p_data => x_msg_data);
1208:
1209: WHEN OTHERS THEN
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1212: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1213: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1214: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1215: FND_MSG_PUB.Add;
1208:
1209: WHEN OTHERS THEN
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1212: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1213: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1214: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1215: FND_MSG_PUB.Add;
1216: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1209: WHEN OTHERS THEN
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1212: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1213: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1214: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1215: FND_MSG_PUB.Add;
1216: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1217: p_count => x_msg_count,
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1212: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1213: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1214: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1215: FND_MSG_PUB.Add;
1216: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1217: p_count => x_msg_count,
1218: p_data => x_msg_data);