APPS.JTF_MINISITERUNTIME_PVT dependencies on FND_MSG_PUB

Line 246: FND_MSG_PUB.count_and_get(

242: EXCEPTION
243: WHEN FND_API.G_EXC_ERROR THEN
244: ROLLBACK TO get_msite_details;
245: x_return_status := FND_API.g_ret_sts_error;
246: FND_MSG_PUB.count_and_get(
247: p_encoded => FND_API.g_false,
248: p_count => x_msg_count,
249: p_data => x_msg_data );
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 253: FND_MSG_PUB.count_and_get(

249: p_data => x_msg_data );
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: ROLLBACK TO get_msite_details;
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: FND_MSG_PUB.count_and_get(
254: p_encoded => FND_API.g_false,
255: p_count => x_msg_count,
256: p_data => x_msg_data );
257: WHEN l_msite_not_exists_excp THEN

Line 261: FND_MSG_PUB.ADD;

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

Line 262: FND_MSG_PUB.count_and_get(

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

Line 272: FND_MSG_PUB.Add;

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

Line 274: FND_MSG_PUB.count_and_get(

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,
276: p_count => x_msg_count,
277: p_data => x_msg_data );
278:

Line 421: FND_MSG_PUB.Add;

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

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

551: EXCEPTION
552:
553: WHEN FND_API.G_EXC_ERROR THEN
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
556: p_count => x_msg_count,
557: p_data => x_msg_data);
558:
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

557: p_data => x_msg_data);
558:
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
562: p_count => x_msg_count,
563: p_data => x_msg_data);
564:
565: WHEN OTHERS THEN

Line 571: FND_MSG_PUB.Add;

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

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

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);
575:
576: End Load_Msite_List_Details ;