DBA Data[Home] [Help]

APPS.JTF_MINISITERUNTIME_PVT dependencies on FND_MESSAGE

Line 260: FND_MESSAGE.set_name('JTF','JTF_MSITE_NOT_EXISTS');

256: p_data => x_msg_data );
257: WHEN l_msite_not_exists_excp THEN
258: ROLLBACK TO get_msite_details;
259: x_return_status := FND_API.g_ret_sts_error;
260: FND_MESSAGE.set_name('JTF','JTF_MSITE_NOT_EXISTS');
261: FND_MSG_PUB.ADD;
262: FND_MSG_PUB.count_and_get(
263: p_encoded => FND_API.g_false,
264: p_count => x_msg_count,

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

264: p_count => x_msg_count,
265: p_data => x_msg_data );
266: WHEN OTHERS THEN
267: ROLLBACK TO get_msite_details;
268: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
269: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
270: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
271: FND_MESSAGE.Set_Token('REASON', SQLERRM);
272: FND_MSG_PUB.Add;

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

265: p_data => x_msg_data );
266: WHEN OTHERS THEN
267: ROLLBACK TO get_msite_details;
268: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
269: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
270: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
271: FND_MESSAGE.Set_Token('REASON', SQLERRM);
272: FND_MSG_PUB.Add;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

266: WHEN OTHERS THEN
267: ROLLBACK TO get_msite_details;
268: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
269: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
270: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
271: FND_MESSAGE.Set_Token('REASON', SQLERRM);
272: FND_MSG_PUB.Add;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: FND_MSG_PUB.count_and_get(

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

267: ROLLBACK TO get_msite_details;
268: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
269: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
270: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
271: FND_MESSAGE.Set_Token('REASON', SQLERRM);
272: FND_MSG_PUB.Add;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: FND_MSG_PUB.count_and_get(
275: p_encoded => FND_API.g_false,

Line 420: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_NO_MSITES_SPECIFIED');

416: l_tmp_str := ' ';
417: l_first_idx := x_msite_ids.FIRST;
418:
419: IF (x_msite_ids.COUNT <= 0) THEN
420: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_NO_MSITES_SPECIFIED');
421: FND_MSG_PUB.Add;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424:

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

563: p_data => x_msg_data);
564:
565: WHEN OTHERS THEN
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
568: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
569: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
570: FND_MESSAGE.Set_Token('REASON', SQLERRM);
571: FND_MSG_PUB.Add;

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

564:
565: WHEN OTHERS THEN
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
568: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
569: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
570: FND_MESSAGE.Set_Token('REASON', SQLERRM);
571: FND_MSG_PUB.Add;
572: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

565: WHEN OTHERS THEN
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
568: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
569: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
570: FND_MESSAGE.Set_Token('REASON', SQLERRM);
571: FND_MSG_PUB.Add;
572: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
573: p_count => x_msg_count,

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

566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
568: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
569: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
570: FND_MESSAGE.Set_Token('REASON', SQLERRM);
571: FND_MSG_PUB.Add;
572: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
573: p_count => x_msg_count,
574: p_data => x_msg_data);