eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_MINISITERUNTIME_PVT dependencies on FND_API

Line 38: RAISE FND_API.G_EXC_ERROR;

34: OPEN c1;
35: FETCH c1 INTO x_mini_site_id, x_root_section_id;
36: IF (c1%NOTFOUND) THEN
37: CLOSE c1;
38: RAISE FND_API.G_EXC_ERROR;
39: END IF;
40: CLOSE c1;
41:
42: END Get_Master_Mini_Site_Id;

Line 98: x_return_status := FND_API.G_RET_STS_SUCCESS;

94: And NVL(end_date_active,sysdate) ;
95:
96: BEGIN
97:
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: SAVEPOINT get_msite_details;
101: l_msite_id := p_msite_id ;
102: If (l_msite_id IS NULL OR l_msite_id = FND_API.G_MISS_NUM) And

Line 102: If (l_msite_id IS NULL OR l_msite_id = FND_API.G_MISS_NUM) And

98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: SAVEPOINT get_msite_details;
101: l_msite_id := p_msite_id ;
102: If (l_msite_id IS NULL OR l_msite_id = FND_API.G_MISS_NUM) And
103: (p_access_name IS NOT NULL) Then
104: Open C_msite_Id(p_access_name);
105: Fetch C_msite_Id INTO l_msite_id, l_root_section_id;
106: If C_msite_Id%NOTFOUND Then

Line 243: WHEN FND_API.G_EXC_ERROR THEN

239: And sysdate Between accss.start_date_Active
240: And NVL(accss.end_date_active,sysdate);
241:
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,

Line 245: x_return_status := FND_API.g_ret_sts_error;

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

Line 247: p_encoded => FND_API.g_false,

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
251: ROLLBACK TO get_msite_details;

Line 250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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,

Line 252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

248: p_count => x_msg_count,
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 );

Line 254: p_encoded => FND_API.g_false,

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
258: ROLLBACK TO get_msite_details;

Line 259: x_return_status := FND_API.g_ret_sts_error;

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

Line 263: p_encoded => FND_API.g_false,

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
267: ROLLBACK TO get_msite_details;

Line 273: x_return_status := FND_API.G_RET_STS_UNEXP_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,
277: p_data => x_msg_data );

Line 275: p_encoded => FND_API.g_false,

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:
279: END Get_Msite_Details;

Line 399: x_return_status := FND_API.G_RET_STS_SUCCESS;

395: AND master_msite_flag = 'N';
396:
397: BEGIN
398:
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400:
401: --+
402: -- If p_msite_ids is null, then load all the ids and put it in x_msite_ids
403: --+

Line 422: RAISE FND_API.G_EXC_ERROR;

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
426: (

Line 553: WHEN FND_API.G_EXC_ERROR THEN

549: END IF; -- end of exclusion block
550:
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);

Line 554: x_return_status := FND_API.G_RET_STS_ERROR;

550:
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:

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 559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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 566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

562: p_count => x_msg_count,
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);

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 ;