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_EXT_ATTRI_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_ext_object_id ext object ID.ex: party_id, party_site_id
26: -- p_ext_object_name ext object name. ex: HZ_PERSON_PROFILES, etc
27: --
28: -- OUT:

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

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

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

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

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

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

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

101:
102: end;
103:
104: PROCEDURE get_ext_attribute_bos(
105: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
106: p_ext_object_id IN NUMBER,
107: p_ext_object_name IN VARCHAR2,
108: p_action_type IN VARCHAR2 := NULL,
109: x_ext_attribute_objs OUT NOCOPY HZ_EXT_ATTRIBUTE_OBJ_TBL,

Line 208: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

204: ,x_msg_count => x_msg_count
205: ,x_msg_data => x_msg_data
206: );
207:
208: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
209: FND_MESSAGE.SET_NAME('AR', 'ERROR IN EGO_USER_ATTRS_DATA_PUB.Get_User_Attrs_Data');
210: FND_MSG_PUB.ADD;
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;

Line 211: RAISE FND_API.G_EXC_ERROR;

207:
208: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
209: FND_MESSAGE.SET_NAME('AR', 'ERROR IN EGO_USER_ATTRS_DATA_PUB.Get_User_Attrs_Data');
210: FND_MSG_PUB.ADD;
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213: if (l_attributes_row_table is not null) and (l_attributes_data_table is not null)
214: then
215: for i in 1..l_attributes_row_table.count loop

Line 244: WHEN fnd_api.g_exc_error THEN

240: end loop;
241: end if;
242: EXCEPTION
243:
244: WHEN fnd_api.g_exc_error THEN
245: x_return_status := fnd_api.g_ret_sts_error;
246:
247: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
248: p_count => x_msg_count,

Line 245: x_return_status := fnd_api.g_ret_sts_error;

241: end if;
242: EXCEPTION
243:
244: WHEN fnd_api.g_exc_error THEN
245: x_return_status := fnd_api.g_ret_sts_error;
246:
247: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
248: p_count => x_msg_count,
249: p_data => x_msg_data);

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

243:
244: WHEN fnd_api.g_exc_error THEN
245: x_return_status := fnd_api.g_ret_sts_error;
246:
247: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
248: p_count => x_msg_count,
249: p_data => x_msg_data);
250:
251: -- Debug info.

Line 263: WHEN fnd_api.g_exc_unexpected_error THEN

259: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
260: p_prefix=>l_debug_prefix,
261: p_msg_level=>fnd_log.level_procedure);
262: END IF;
263: WHEN fnd_api.g_exc_unexpected_error THEN
264: x_return_status := fnd_api.g_ret_sts_unexp_error;
265:
266: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
267: p_count => x_msg_count,

Line 264: x_return_status := fnd_api.g_ret_sts_unexp_error;

260: p_prefix=>l_debug_prefix,
261: p_msg_level=>fnd_log.level_procedure);
262: END IF;
263: WHEN fnd_api.g_exc_unexpected_error THEN
264: x_return_status := fnd_api.g_ret_sts_unexp_error;
265:
266: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
267: p_count => x_msg_count,
268: p_data => x_msg_data);

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

262: END IF;
263: WHEN fnd_api.g_exc_unexpected_error THEN
264: x_return_status := fnd_api.g_ret_sts_unexp_error;
265:
266: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
267: p_count => x_msg_count,
268: p_data => x_msg_data);
269:
270: -- Debug info.

Line 283: x_return_status := fnd_api.g_ret_sts_unexp_error;

279: p_prefix=>l_debug_prefix,
280: p_msg_level=>fnd_log.level_procedure);
281: END IF;
282: WHEN OTHERS THEN
283: x_return_status := fnd_api.g_ret_sts_unexp_error;
284:
285: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
286: fnd_message.set_token('ERROR' ,SQLERRM);
287: fnd_msg_pub.add;

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

285: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
286: fnd_message.set_token('ERROR' ,SQLERRM);
287: fnd_msg_pub.add;
288:
289: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
290: p_count => x_msg_count,
291: p_data => x_msg_data);
292:
293: -- Debug info.