DBA Data[Home] [Help]

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 187: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;

Line 190: IF FND_API.to_Boolean(p_init_msg_list) THEN

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:

Line 225: WHEN fnd_api.g_exc_error THEN

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,

Line 226: x_return_status := fnd_api.g_ret_sts_error;

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

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

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.

Line 244: WHEN fnd_api.g_exc_unexpected_error THEN

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,

Line 245: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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.

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

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

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.