23: -- IN:
24: -- p_init_msg_list Initialize message stack if it is set to
25: -- p_parent_id parent id.
26: -- p_cust_acct_contact_id customer account contact ID.
27: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
28: -- OUT:
29: -- x_cust_acct_contact_objs Logical customer account contact records.
30: -- x_return_status Return status after the call. The status can
31: -- be fnd_api.g_ret_sts_success (success),
27: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
28: -- OUT:
29: -- x_cust_acct_contact_objs Logical customer account contact records.
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.
28: -- OUT:
29: -- x_cust_acct_contact_objs Logical customer account contact records.
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: --
29: -- x_cust_acct_contact_objs Logical customer account contact records.
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
68:
69:
70:
71: PROCEDURE get_cust_acct_contact_bos(
72: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
73: p_parent_id IN NUMBER,
74: p_cust_acct_contact_id IN NUMBER,
75: p_action_type IN VARCHAR2 := NULL,
76: x_cust_acct_contact_objs OUT NOCOPY HZ_CUST_ACCT_CONTACT_BO_TBL,
268: BEGIN
269:
270:
271: -- initialize API return status to success.
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273:
274: -- Initialize message list if p_init_msg_list is set to TRUE
275: IF FND_API.to_Boolean(p_init_msg_list) THEN
276: FND_MSG_PUB.initialize;
271: -- initialize API return status to success.
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273:
274: -- Initialize message list if p_init_msg_list is set to TRUE
275: IF FND_API.to_Boolean(p_init_msg_list) THEN
276: FND_MSG_PUB.initialize;
277: END IF;
278:
279:
308:
309:
310: EXCEPTION
311:
312: WHEN fnd_api.g_exc_error THEN
313: x_return_status := fnd_api.g_ret_sts_error;
314:
315: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
316: p_count => x_msg_count,
309:
310: EXCEPTION
311:
312: WHEN fnd_api.g_exc_error THEN
313: x_return_status := fnd_api.g_ret_sts_error;
314:
315: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
316: p_count => x_msg_count,
317: p_data => x_msg_data);
311:
312: WHEN fnd_api.g_exc_error THEN
313: x_return_status := fnd_api.g_ret_sts_error;
314:
315: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
316: p_count => x_msg_count,
317: p_data => x_msg_data);
318:
319: -- Debug info.
327: hz_utility_v2pub.debug(p_message=>'get_cust_acct_contact_bos (-)',
328: p_prefix=>l_debug_prefix,
329: p_msg_level=>fnd_log.level_procedure);
330: END IF;
331: WHEN fnd_api.g_exc_unexpected_error THEN
332: x_return_status := fnd_api.g_ret_sts_unexp_error;
333:
334: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
335: p_count => x_msg_count,
328: p_prefix=>l_debug_prefix,
329: p_msg_level=>fnd_log.level_procedure);
330: END IF;
331: WHEN fnd_api.g_exc_unexpected_error THEN
332: x_return_status := fnd_api.g_ret_sts_unexp_error;
333:
334: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
335: p_count => x_msg_count,
336: p_data => x_msg_data);
330: END IF;
331: WHEN fnd_api.g_exc_unexpected_error THEN
332: x_return_status := fnd_api.g_ret_sts_unexp_error;
333:
334: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
335: p_count => x_msg_count,
336: p_data => x_msg_data);
337:
338: -- Debug info.
347: p_prefix=>l_debug_prefix,
348: p_msg_level=>fnd_log.level_procedure);
349: END IF;
350: WHEN OTHERS THEN
351: x_return_status := fnd_api.g_ret_sts_unexp_error;
352:
353: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
354: fnd_message.set_token('ERROR' ,SQLERRM);
355: fnd_msg_pub.add;
353: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
354: fnd_message.set_token('ERROR' ,SQLERRM);
355: fnd_msg_pub.add;
356:
357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
358: p_count => x_msg_count,
359: p_data => x_msg_data);
360:
361: -- Debug info.