APPS.ECX_TP_MERGE_PKG dependencies on FND_API

Line 20: x_return_status := fnd_api.g_ret_sts_success;

16: p_batch_party_id in number,
17: x_return_status out nocopy varchar2 )
18: is
19: begin
20: x_return_status := fnd_api.g_ret_sts_success;
21: -- if parent has not changed
22: if (p_from_fk_id = p_to_fk_id) then
23: x_to_id := p_from_id;
24: return;

Line 49: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

45: fnd_message.set_name('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
46: fnd_message.set_token('ERROR_CODE', SQLCODE);
47: fnd_message.set_token('ERROR_MESSAGE', SQLERRM);
48: fnd_msg_pub.add;
49: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
50: end ecx_party_merge;
51:
52: procedure ecx_party_sites_merge(
53: p_entity_name in varchar2,

Line 77: x_return_status := fnd_api.g_ret_sts_success;

73: v_tp_details_target_tab t_tp_details_tab;
74: l_exists pls_integer;
75: v_target_header_id ecx_tp_headers.tp_header_id%type;
76: begin
77: x_return_status := fnd_api.g_ret_sts_success;
78: -- if parent has not changed
79: if (p_from_fk_id = p_to_fk_id) then
80: x_to_id := p_from_id;
81: return;

Line 125: x_return_status := fnd_api.g_ret_sts_unexp_error;

121: fnd_message.set_name('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
122: -- fnd_message.set_token('ERROR_CODE', SQLCODE);
123: fnd_message.set_token('ERROR_MESSAGE', 'Source and Destination TPs with Common TP Details');
124: fnd_msg_pub.add;
125: x_return_status := fnd_api.g_ret_sts_unexp_error;
126: return; --abort the procedure execution
127: end if;
128: end loop;
129: end loop;

Line 168: x_return_status := fnd_api.g_ret_sts_unexp_error;

164: FND_MESSAGE.SET_NAME('ECX', 'ECX_MERGE_UNEXPECTED_ERROR');
165: FND_MESSAGE.SET_TOKEN('ERROR_CODE', SQLCODE);
166: fnd_message.set_token('ERROR_MESSAGE', sqlerrm);
167: fnd_msg_pub.add;
168: x_return_status := fnd_api.g_ret_sts_unexp_error;
169: end ecx_party_sites_merge;
170: end ecx_tp_merge_pkg;