DBA Data[Home] [Help]

APPS.IBE_MINISITERUNTIME_PVT dependencies on FND_MSG_PUB

Line 337: FND_MSG_PUB.count_and_get(

333:
334: EXCEPTION
335: WHEN FND_API.G_EXC_ERROR THEN
336: x_return_status := FND_API.g_ret_sts_error;
337: FND_MSG_PUB.count_and_get(
338: p_encoded => FND_API.g_false,
339: p_count => x_msg_count,
340: p_data => x_msg_data );
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 343: FND_MSG_PUB.count_and_get(

339: p_count => x_msg_count,
340: p_data => x_msg_data );
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: FND_MSG_PUB.count_and_get(
344: p_encoded => FND_API.g_false,
345: p_count => x_msg_count,
346: p_data => x_msg_data );
347: WHEN l_msite_not_exists_excp THEN

Line 350: FND_MSG_PUB.ADD;

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,
354: p_data => x_msg_data );

Line 351: FND_MSG_PUB.count_and_get(

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,
354: p_data => x_msg_data );
355: WHEN OTHERS THEN

Line 360: FND_MSG_PUB.Add;

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,
364: p_count => x_msg_count,

Line 362: FND_MSG_PUB.count_and_get(

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,
364: p_count => x_msg_count,
365: p_data => x_msg_data );
366:

Line 408: FND_MSG_PUB.count_and_get(

404:
405: EXCEPTION
406: WHEN FND_API.G_EXC_ERROR THEN
407: x_return_status := FND_API.g_ret_sts_error;
408: FND_MSG_PUB.count_and_get(
409: p_encoded => FND_API.g_false,
410: p_count => x_msg_count,
411: p_data => x_msg_data );
412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 414: FND_MSG_PUB.count_and_get(

410: p_count => x_msg_count,
411: p_data => x_msg_data );
412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: FND_MSG_PUB.count_and_get(
415: p_encoded => FND_API.g_false,
416: p_count => x_msg_count,
417: p_data => x_msg_data );
418: WHEN OTHERS THEN

Line 423: FND_MSG_PUB.Add;

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,
427: p_count => x_msg_count,

Line 425: FND_MSG_PUB.count_and_get(

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,
427: p_count => x_msg_count,
428: p_data => x_msg_data );
429:

Line 703: FND_MSG_PUB.Add;

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:
707: Get_Master_Mini_Site_Id

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

922: EXCEPTION
923:
924: WHEN FND_API.G_EXC_ERROR THEN
925: x_return_status := FND_API.G_RET_STS_ERROR;
926: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
927: p_count => x_msg_count,
928: p_data => x_msg_data);
929:
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

928: p_data => x_msg_data);
929:
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
932: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
933: p_count => x_msg_count,
934: p_data => x_msg_data);
935:
936: WHEN OTHERS THEN

Line 942: FND_MSG_PUB.Add;

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

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

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);
946:
947: End Load_Msite_List_Details ;