169:
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
174: p_count => x_msg_count,
175: p_data => x_msg_data);
176:
177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
175: p_data => x_msg_data);
176:
177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
180: p_count => x_msg_count,
181: p_data => x_msg_data);
182:
183: WHEN l_msite_not_exists_excp THEN
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 );
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:
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);
202: END Get_Msite_Excluded_Items;
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);
202: END Get_Msite_Excluded_Items;
203:
278: EXCEPTION
279:
280: WHEN FND_API.G_EXC_ERROR THEN
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
283: p_count => x_msg_count,
284: p_data => x_msg_data);
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: p_data => x_msg_data);
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
289: p_count => x_msg_count,
290: p_data => x_msg_data);
291:
292: WHEN l_msite_not_exists_excp THEN
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 );
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:
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);
311:
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);
311:
312: END Get_Msite_Excluded_Sections;
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: x_return_status := FND_API.g_ret_sts_error;
602: FND_MSG_PUB.count_and_get(
603: p_encoded => FND_API.g_false,
604: p_count => x_msg_count,
605: p_data => x_msg_data );
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
604: p_count => x_msg_count,
605: p_data => x_msg_data );
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.count_and_get(
609: p_encoded => FND_API.g_false,
610: p_count => x_msg_count,
611: p_data => x_msg_data );
612: WHEN l_msite_not_exists_excp THEN
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,
619: 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,
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(
628: p_encoded => FND_API.g_false,
629: p_count => x_msg_count,
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,
629: p_count => x_msg_count,
630: p_data => x_msg_data );
631:
669:
670: EXCEPTION
671: WHEN FND_API.G_EXC_ERROR THEN
672: x_return_status := FND_API.g_ret_sts_error;
673: FND_MSG_PUB.count_and_get(
674: p_encoded => FND_API.g_false,
675: p_count => x_msg_count,
676: p_data => x_msg_data );
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
675: p_count => x_msg_count,
676: p_data => x_msg_data );
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: FND_MSG_PUB.count_and_get(
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;
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,
692: p_count => x_msg_count,
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,
692: p_count => x_msg_count,
693: p_data => x_msg_data );
694:
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:
972: Get_Master_Mini_Site_Id
1195: EXCEPTION
1196:
1197: WHEN FND_API.G_EXC_ERROR THEN
1198: x_return_status := FND_API.G_RET_STS_ERROR;
1199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1200: p_count => x_msg_count,
1201: p_data => x_msg_data);
1202:
1203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1201: p_data => x_msg_data);
1202:
1203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1206: p_count => x_msg_count,
1207: p_data => x_msg_data);
1208:
1209: WHEN OTHERS THEN
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);
1219:
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);
1219:
1220: End Load_Msite_List_Details ;