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.IBE_MINISITERUNTIME_PVT dependencies on FND_API

Line 44: RAISE FND_API.G_EXC_ERROR;

40: OPEN c1;
41: FETCH c1 INTO x_mini_site_id, x_root_section_id;
42: IF (c1%NOTFOUND) THEN
43: CLOSE c1;
44: RAISE FND_API.G_EXC_ERROR;
45: END IF;
46: CLOSE c1;
47:
48: END Get_Master_Mini_Site_Id;

Line 105: x_return_status := FND_API.G_RET_STS_SUCCESS;

101: -- And NVL(end_date_active,sysdate) ;
102:
103: BEGIN
104:
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106:
107: l_msite_id := p_msite_id ;
108: If (l_msite_id IS NULL OR l_msite_id = FND_API.G_MISS_NUM) And
109: (p_access_name IS NOT NULL) Then

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

104:
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106:
107: l_msite_id := p_msite_id ;
108: If (l_msite_id IS NULL OR l_msite_id = FND_API.G_MISS_NUM) And
109: (p_access_name IS NOT NULL) Then
110: Open C_msite_Id(p_access_name);
111: Fetch C_msite_Id INTO l_msite_id, l_root_section_id;
112: If C_msite_Id%NOTFOUND Then

Line 335: WHEN FND_API.G_EXC_ERROR THEN

331: AND a.msite_information1 = cc.card_issuer_code
332: ORDER BY msite_information_context;
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,

Line 336: x_return_status := FND_API.g_ret_sts_error;

332: ORDER BY msite_information_context;
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 );

Line 338: p_encoded => FND_API.g_false,

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

Line 341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 344: p_encoded => FND_API.g_false,

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
348: x_return_status := FND_API.g_ret_sts_error;

Line 348: x_return_status := FND_API.g_ret_sts_error;

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

Line 352: p_encoded => FND_API.g_false,

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
356: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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

Line 363: p_encoded => FND_API.g_false,

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

Line 391: x_return_status := FND_API.G_RET_STS_SUCCESS;

387: BEGIN
388:
389: l_quote_id := p_quote_id;
390:
391: x_return_status := FND_API.G_RET_STS_SUCCESS;
392:
393: OPEN x_ship_method_cur FOR SELECT SHIP_METHOD_CODE
394: FROM aso_shipments where quote_header_id = l_quote_id;
395:

Line 406: WHEN FND_API.G_EXC_ERROR THEN

402: WHERE A.quote_header_id = l_quote_id
403: AND A.party_id = F.customer_id;
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,

Line 407: x_return_status := FND_API.g_ret_sts_error;

403: AND A.party_id = F.customer_id;
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 );

Line 409: p_encoded => FND_API.g_false,

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

Line 412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 415: p_encoded => FND_API.g_false,

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
419: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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

Line 426: p_encoded => FND_API.g_false,

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:
430: END Get_Quote_Details;

Line 668: x_return_status := FND_API.G_RET_STS_SUCCESS;

664:
665:
666: BEGIN
667:
668: x_return_status := FND_API.G_RET_STS_SUCCESS;
669:
670: --+
671: -- If p_msite_ids is null, then load all the ids and put it in x_msite_ids
672: --+

Line 704: RAISE FND_API.G_EXC_ERROR;

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

Line 924: WHEN FND_API.G_EXC_ERROR THEN

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

Line 925: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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 ;