APPS.HZ_EXTRACT_ORIG_SYS_REF_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_owner_table_id tca owner table ID.
26: -- p_owner_table_name tca owner table name.
27: --
28: -- OUT:

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

27: --
28: -- OUT:
29: -- x_orig_sys_ref_objs Table of ssm 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_orig_sys_ref_objs Table of ssm 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_orig_sys_ref_objs Table of ssm 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 48: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

44:
45:
46:
47: PROCEDURE get_orig_sys_ref_bos(
48: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
49: p_owner_table_id IN NUMBER,
50: p_owner_table_name IN VARCHAR2,
51: p_action_type IN VARCHAR2 := NULL,
52: x_orig_sys_ref_objs OUT NOCOPY HZ_ORIG_SYS_REF_OBJ_TBL,

Line 109: x_return_status := FND_API.G_RET_STS_SUCCESS;

105: -- AND STATUS = 'A';
106:
107: begin
108: -- initialize API return status to success.
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110:
111: -- Initialize message list if p_init_msg_list is set to TRUE
112: IF FND_API.to_Boolean(p_init_msg_list) THEN
113: FND_MSG_PUB.initialize;

Line 112: IF FND_API.to_Boolean(p_init_msg_list) THEN

108: -- initialize API return status to success.
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110:
111: -- Initialize message list if p_init_msg_list is set to TRUE
112: IF FND_API.to_Boolean(p_init_msg_list) THEN
113: FND_MSG_PUB.initialize;
114: END IF;
115:
116: -- Debug info.

Line 148: x_return_status := fnd_api.g_ret_sts_unexp_error;

144:
145:
146: EXCEPTION
147: WHEN OTHERS THEN
148: x_return_status := fnd_api.g_ret_sts_unexp_error;
149:
150: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
151: fnd_message.set_token('ERROR' ,SQLERRM);
152: fnd_msg_pub.add;

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

150: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
151: fnd_message.set_token('ERROR' ,SQLERRM);
152: fnd_msg_pub.add;
153:
154: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
155: p_count => x_msg_count,
156: p_data => x_msg_data);
157:
158: -- Debug info.