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

Line 24: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.

20: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
21: --
22: -- ARGUMENTS
23: -- IN:
24: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.
25: -- p_subject_id relationship subject ID.
26: --
27: -- OUT:
28: -- x_relationship_objs Table of relationship objects.

Line 30: -- be fnd_api.g_ret_sts_success (success),

26: --
27: -- OUT:
28: -- x_relationship_objs Table of relationship objects.
29: -- x_return_status Return status after the call. The status can
30: -- be fnd_api.g_ret_sts_success (success),
31: -- fnd_api.g_ret_sts_error (error),
32: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
33: -- x_msg_count Number of messages in message stack.
34: -- x_msg_data Message text if x_msg_count is 1.

Line 31: -- fnd_api.g_ret_sts_error (error),

27: -- OUT:
28: -- x_relationship_objs Table of relationship objects.
29: -- x_return_status Return status after the call. The status can
30: -- be fnd_api.g_ret_sts_success (success),
31: -- fnd_api.g_ret_sts_error (error),
32: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
33: -- x_msg_count Number of messages in message stack.
34: -- x_msg_data Message text if x_msg_count is 1.
35: --

Line 32: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

28: -- x_relationship_objs Table of relationship objects.
29: -- x_return_status Return status after the call. The status can
30: -- be fnd_api.g_ret_sts_success (success),
31: -- fnd_api.g_ret_sts_error (error),
32: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
33: -- x_msg_count Number of messages in message stack.
34: -- x_msg_data Message text if x_msg_count is 1.
35: --
36: -- NOTES

Line 47: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

43:
44:
45:
46: PROCEDURE get_relationship_bos(
47: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
48: p_subject_id IN NUMBER,
49: p_action_type IN VARCHAR2 := NULL,
50: x_relationship_objs OUT NOCOPY HZ_RELATIONSHIP_OBJ_TBL,
51: x_return_status OUT NOCOPY VARCHAR2,

Line 188: x_return_status := FND_API.G_RET_STS_SUCCESS;

184: BEGIN
185:
186:
187: -- initialize API return status to success.
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189:
190: -- Initialize message list if p_init_msg_list is set to TRUE
191: IF FND_API.to_Boolean(p_init_msg_list) THEN
192: FND_MSG_PUB.initialize;

Line 191: IF FND_API.to_Boolean(p_init_msg_list) THEN

187: -- initialize API return status to success.
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189:
190: -- Initialize message list if p_init_msg_list is set to TRUE
191: IF FND_API.to_Boolean(p_init_msg_list) THEN
192: FND_MSG_PUB.initialize;
193: END IF;
194:
195:

Line 226: WHEN fnd_api.g_exc_error THEN

222:
223:
224: EXCEPTION
225:
226: WHEN fnd_api.g_exc_error THEN
227: x_return_status := fnd_api.g_ret_sts_error;
228:
229: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
230: p_count => x_msg_count,

Line 227: x_return_status := fnd_api.g_ret_sts_error;

223:
224: EXCEPTION
225:
226: WHEN fnd_api.g_exc_error THEN
227: x_return_status := fnd_api.g_ret_sts_error;
228:
229: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
230: p_count => x_msg_count,
231: p_data => x_msg_data);

Line 229: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

225:
226: WHEN fnd_api.g_exc_error THEN
227: x_return_status := fnd_api.g_ret_sts_error;
228:
229: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
230: p_count => x_msg_count,
231: p_data => x_msg_data);
232:
233: -- Debug info.

Line 245: WHEN fnd_api.g_exc_unexpected_error THEN

241: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
242: p_prefix=>l_debug_prefix,
243: p_msg_level=>fnd_log.level_procedure);
244: END IF;
245: WHEN fnd_api.g_exc_unexpected_error THEN
246: x_return_status := fnd_api.g_ret_sts_unexp_error;
247:
248: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
249: p_count => x_msg_count,

Line 246: x_return_status := fnd_api.g_ret_sts_unexp_error;

242: p_prefix=>l_debug_prefix,
243: p_msg_level=>fnd_log.level_procedure);
244: END IF;
245: WHEN fnd_api.g_exc_unexpected_error THEN
246: x_return_status := fnd_api.g_ret_sts_unexp_error;
247:
248: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
249: p_count => x_msg_count,
250: p_data => x_msg_data);

Line 248: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

244: END IF;
245: WHEN fnd_api.g_exc_unexpected_error THEN
246: x_return_status := fnd_api.g_ret_sts_unexp_error;
247:
248: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
249: p_count => x_msg_count,
250: p_data => x_msg_data);
251:
252: -- Debug info.

Line 265: x_return_status := fnd_api.g_ret_sts_unexp_error;

261: p_prefix=>l_debug_prefix,
262: p_msg_level=>fnd_log.level_procedure);
263: END IF;
264: WHEN OTHERS THEN
265: x_return_status := fnd_api.g_ret_sts_unexp_error;
266:
267: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
268: fnd_message.set_token('ERROR' ,SQLERRM);
269: fnd_msg_pub.add;

Line 271: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

267: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
268: fnd_message.set_token('ERROR' ,SQLERRM);
269: fnd_msg_pub.add;
270:
271: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
272: p_count => x_msg_count,
273: p_data => x_msg_data);
274:
275: -- Debug info.