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.
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.
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: --
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
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,
183: BEGIN
184:
185:
186: -- initialize API return status to success.
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188:
189: -- Initialize message list if p_init_msg_list is set to TRUE
190: IF FND_API.to_Boolean(p_init_msg_list) THEN
191: FND_MSG_PUB.initialize;
186: -- initialize API return status to success.
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188:
189: -- Initialize message list if p_init_msg_list is set to TRUE
190: IF FND_API.to_Boolean(p_init_msg_list) THEN
191: FND_MSG_PUB.initialize;
192: END IF;
193:
194:
221:
222:
223: EXCEPTION
224:
225: WHEN fnd_api.g_exc_error THEN
226: x_return_status := fnd_api.g_ret_sts_error;
227:
228: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
229: p_count => x_msg_count,
222:
223: EXCEPTION
224:
225: WHEN fnd_api.g_exc_error THEN
226: x_return_status := fnd_api.g_ret_sts_error;
227:
228: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
229: p_count => x_msg_count,
230: p_data => x_msg_data);
224:
225: WHEN fnd_api.g_exc_error THEN
226: x_return_status := fnd_api.g_ret_sts_error;
227:
228: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
229: p_count => x_msg_count,
230: p_data => x_msg_data);
231:
232: -- Debug info.
240: hz_utility_v2pub.debug(p_message=>'get_relationship_bos (-)',
241: p_prefix=>l_debug_prefix,
242: p_msg_level=>fnd_log.level_procedure);
243: END IF;
244: WHEN fnd_api.g_exc_unexpected_error THEN
245: x_return_status := fnd_api.g_ret_sts_unexp_error;
246:
247: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
248: p_count => x_msg_count,
241: p_prefix=>l_debug_prefix,
242: p_msg_level=>fnd_log.level_procedure);
243: END IF;
244: WHEN fnd_api.g_exc_unexpected_error THEN
245: x_return_status := fnd_api.g_ret_sts_unexp_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);
243: END IF;
244: WHEN fnd_api.g_exc_unexpected_error THEN
245: x_return_status := fnd_api.g_ret_sts_unexp_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.
260: p_prefix=>l_debug_prefix,
261: p_msg_level=>fnd_log.level_procedure);
262: END IF;
263: WHEN OTHERS THEN
264: x_return_status := fnd_api.g_ret_sts_unexp_error;
265:
266: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
267: fnd_message.set_token('ERROR' ,SQLERRM);
268: fnd_msg_pub.add;
266: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
267: fnd_message.set_token('ERROR' ,SQLERRM);
268: fnd_msg_pub.add;
269:
270: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
271: p_count => x_msg_count,
272: p_data => x_msg_data);
273:
274: -- Debug info.