DBA Data[Home] [Help]

APPS.IBE_MINISITERUNTIME_PVT dependencies on FND_MSG_PUB

Line 173: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 179: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 186: FND_MSG_PUB.ADD;

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 );

Line 187: FND_MSG_PUB.count_and_get(

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:

Line 198: FND_MSG_PUB.Add;

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;

Line 199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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:

Line 282: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 288: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 295: FND_MSG_PUB.ADD;

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 );

Line 296: FND_MSG_PUB.count_and_get(

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:

Line 307: FND_MSG_PUB.Add;

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:

Line 308: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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;

Line 602: FND_MSG_PUB.count_and_get(

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

Line 608: FND_MSG_PUB.count_and_get(

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

Line 615: FND_MSG_PUB.ADD;

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 );

Line 616: FND_MSG_PUB.count_and_get(

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

Line 625: FND_MSG_PUB.Add;

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,

Line 627: FND_MSG_PUB.count_and_get(

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:

Line 673: FND_MSG_PUB.count_and_get(

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

Line 679: FND_MSG_PUB.count_and_get(

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

Line 688: FND_MSG_PUB.Add;

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,

Line 690: FND_MSG_PUB.count_and_get(

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:

Line 968: FND_MSG_PUB.Add;

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

Line 1199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 1205: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

Line 1215: FND_MSG_PUB.Add;

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:

Line 1216: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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 ;