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_LOG_TO_PHY_PVT dependencies on FND_API

Line 10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

6: -- get physical object given logical id, site id and language code
7: -- ****************************************************************************
8: PROCEDURE get_obj_by_id(
9: p_api_version IN NUMBER,
10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_logicalid IN ibe_dsp_obj_lgl_ctnt.item_id%TYPE,

Line 34: IF NOT FND_API.compatible_api_call(

30: l_api_name CONSTANT varchar2(30) := 'get_obj_by_id';
31: l_phymed_found boolean := false;
32: BEGIN
33: ---dbms_output.put_line('making api version call');
34: IF NOT FND_API.compatible_api_call(
35: g_api_version,
36: p_api_version,
37: l_api_name,
38: g_pkg_name

Line 40: RAISE FND_API.g_exc_unexpected_error;

36: p_api_version,
37: l_api_name,
38: g_pkg_name
39: ) THEN
40: RAISE FND_API.g_exc_unexpected_error;
41: END IF;
42:
43: -- Initialize message list if p_init_msg_list is set to TRUE.
44: ---dbms_output.put_line(' -- Initialize message list if p_init_msg_list is set to TRUE.');

Line 45: IF FND_API.to_Boolean(p_init_msg_list) THEN

41: END IF;
42:
43: -- Initialize message list if p_init_msg_list is set to TRUE.
44: ---dbms_output.put_line(' -- Initialize message list if p_init_msg_list is set to TRUE.');
45: IF FND_API.to_Boolean(p_init_msg_list) THEN
46: FND_MSG_PUB.initialize;
47: END IF;
48:
49: -- Initialize API return status to error, i.e, its not duplicate

Line 50: x_return_status := FND_API.g_ret_sts_success;

46: FND_MSG_PUB.initialize;
47: END IF;
48:
49: -- Initialize API return status to error, i.e, its not duplicate
50: x_return_status := FND_API.g_ret_sts_success;
51:
52: l_logid := p_logicalid;
53:
54: BEGIN

Line 81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

77: WHEN NO_DATA_FOUND THEN
78: NULL;
79: WHEN OTHERS THEN
80: -- TODO put fnd_messages
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: END;
83:
84: if NOT l_phymed_found THEN
85: BEGIN

Line 111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

107: WHEN NO_DATA_FOUND THEN
108: NULL;
109: WHEN OTHERS THEN
110: -- TODO put fnd_messages
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END;
113:
114: if NOT l_phymed_found THEN
115: BEGIN

Line 141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

137: WHEN NO_DATA_FOUND THEN
138: NULL;
139: WHEN OTHERS THEN
140: -- TODO put fnd_messages
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END;
143:
144: if NOT l_phymed_found THEN
145: BEGIN

Line 177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

173:
174: RETURN;
175: WHEN OTHERS THEN
176: -- TODO put fnd_messages
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END;
179: END IF;
180: END IF;
181: END IF;

Line 194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

190:
191: ---dbms_output.put_line('just before returning');
192: -- RETURN;
193: EXCEPTION
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
197: p_data => x_msg_data);
198:

Line 195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

191: ---dbms_output.put_line('just before returning');
192: -- RETURN;
193: EXCEPTION
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
197: p_data => x_msg_data);
198:
199: WHEN OTHERS THEN

Line 200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

196: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
197: p_data => x_msg_data);
198:
199: WHEN OTHERS THEN
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201:
202: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
203: THEN
204: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 217: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

213: -- get physical object given access name, site id and language code
214: -- ****************************************************************************
215: PROCEDURE GET_OBJ_BY_NAME(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_access_name IN jtf_amv_items_vl.access_name%TYPE,

Line 241: IF NOT FND_API.compatible_api_call(

237: l_api_name CONSTANT varchar2(30) := 'get_obj_by_name';
238: l_phymed_found boolean := false;
239: BEGIN
240: ---dbms_output.put_line('making api version call');
241: IF NOT FND_API.compatible_api_call(
242: g_api_version,
243: p_api_version,
244: l_api_name,
245: g_pkg_name

Line 247: RAISE FND_API.g_exc_unexpected_error;

243: p_api_version,
244: l_api_name,
245: g_pkg_name
246: ) THEN
247: RAISE FND_API.g_exc_unexpected_error;
248: END IF;
249:
250: -- Initialize message list if p_init_msg_list is set to TRUE.
251: ---dbms_output.put_line(' -- Initialize message list if p_init_msg_list is set to TRUE.');

Line 252: IF FND_API.to_Boolean(p_init_msg_list) THEN

248: END IF;
249:
250: -- Initialize message list if p_init_msg_list is set to TRUE.
251: ---dbms_output.put_line(' -- Initialize message list if p_init_msg_list is set to TRUE.');
252: IF FND_API.to_Boolean(p_init_msg_list) THEN
253: FND_MSG_PUB.initialize;
254: END IF;
255:
256: -- Initialize API return status to error, i.e, its not duplicate

Line 257: x_return_status := FND_API.g_ret_sts_success;

253: FND_MSG_PUB.initialize;
254: END IF;
255:
256: -- Initialize API return status to error, i.e, its not duplicate
257: x_return_status := FND_API.g_ret_sts_success;
258:
259: l_accessname := p_access_name;
260:
261: BEGIN

Line 289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

285: WHEN NO_DATA_FOUND THEN
286: NULL;
287: WHEN OTHERS THEN
288: -- TODO put fnd_messages
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END;
291:
292: if NOT l_phymed_found THEN
293: BEGIN

Line 320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

316: WHEN NO_DATA_FOUND THEN
317: NULL;
318: WHEN OTHERS THEN
319: -- TODO put fnd_messages
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END;
322: if NOT l_phymed_found THEN
323: BEGIN
324: -- try at this site and ALL language

Line 350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

346: WHEN NO_DATA_FOUND THEN
347: NULL;
348: WHEN OTHERS THEN
349: -- TODO put fnd_messages
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
351: END;
352:
353: if NOT l_phymed_found THEN
354: BEGIN

Line 388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

384:
385: RETURN;
386: WHEN OTHERS THEN
387: -- TODO put fnd_messages
388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: END;
390: END IF;
391: END IF;
392: END IF;

Line 405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

401:
402: ---dbms_output.put_line('just before returning');
403: -- RETURN;
404: EXCEPTION
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
408: p_data => x_msg_data);
409:

Line 406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

402: ---dbms_output.put_line('just before returning');
403: -- RETURN;
404: EXCEPTION
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
408: p_data => x_msg_data);
409:
410: WHEN OTHERS THEN

Line 411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

407: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
408: p_data => x_msg_data);
409:
410: WHEN OTHERS THEN
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412:
413: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
414: THEN
415: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);