DBA Data[Home] [Help]

APPS.IBE_MINISITERUNTIME_PVT dependencies on FND_MESSAGE

Line 349: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');

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,

Line 356: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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;

Line 357: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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;

Line 358: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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(

Line 359: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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,

Line 419: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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;

Line 420: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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;

Line 421: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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(

Line 422: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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,

Line 702: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_NO_MSITES_SPECIFIED');

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:

Line 938: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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;

Line 939: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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,

Line 940: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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,

Line 941: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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