DBA Data[Home] [Help]

APPS.HZ_EXTRACT_ACCT_CONT_BO_PVT dependencies on FND_API

Line 27: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.

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

Line 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.

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

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

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

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

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

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,

Line 272: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;

Line 275: IF FND_API.to_Boolean(p_init_msg_list) THEN

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:

Line 312: WHEN fnd_api.g_exc_error THEN

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,

Line 313: x_return_status := fnd_api.g_ret_sts_error;

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

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

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.

Line 331: WHEN fnd_api.g_exc_unexpected_error THEN

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,

Line 332: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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.

Line 351: x_return_status := fnd_api.g_ret_sts_unexp_error;

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;

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

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.