APPS.CSM_PARTY_SITE_EVENT_PKG dependencies on FND_API

Line 63: x_return_status := FND_API.G_RET_STS_SUCCESS;

59: from hz_party_sites
60: where party_site_id = p_party_site_id;
61:
62: BEGIN
63: x_return_status := FND_API.G_RET_STS_SUCCESS;
64: p_error_msg := 'Entering CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_I' || ' for party_site_id ' || to_char(p_party_site_id);
65:
66: OPEN l_party_sites_csr(p_party_site_id);
67: FETCH l_party_sites_csr into l_party_id;

Line 88: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

84: p_flowtype => p_flowtype,
85: p_error_msg => l_err_msg,
86: x_return_status => l_ret_status);
87:
88: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
89: csm_util_pkg.LOG(l_err_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_I', FND_LOG.LEVEL_ERROR);
90: END IF;
91:
92: p_error_msg := 'Leaving CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_I' || ' for party_site_id ' || to_char(p_party_site_id);

Line 95: x_return_status := FND_API.G_RET_STS_ERROR;

91:
92: p_error_msg := 'Leaving CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_I' || ' for party_site_id ' || to_char(p_party_site_id);
93: EXCEPTION
94: WHEN others THEN
95: x_return_status := FND_API.G_RET_STS_ERROR;
96: p_error_msg := ' FAILED PARTY_SITES_ACC_I:' || to_char(p_party_site_id);
97: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_I', FND_LOG.LEVEL_EXCEPTION);
98: RAISE;
99: END PARTY_SITES_ACC_I;

Line 119: x_return_status := FND_API.G_RET_STS_SUCCESS;

115: from hz_party_sites
116: where party_site_id = p_party_site_id;
117:
118: BEGIN
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120: p_error_msg := 'Entering CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D' || ' for party_site_id ' || to_char(p_party_site_id);
121:
122: OPEN l_party_sites_csr(p_party_site_id);
123: FETCH l_party_sites_csr into l_party_id;

Line 143: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

139: p_flowtype => p_flowtype,
140: p_error_msg => l_err_msg,
141: x_return_status => l_ret_status);
142:
143: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
144: csm_util_pkg.LOG(l_err_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D', FND_LOG.LEVEL_ERROR);
145: END IF;
146:
147: p_error_msg := 'Leaving CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D' || ' for party_site_id ' || to_char(p_party_site_id);

Line 151: x_return_status := FND_API.G_RET_STS_ERROR;

147: p_error_msg := 'Leaving CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D' || ' for party_site_id ' || to_char(p_party_site_id);
148:
149: EXCEPTION
150: WHEN others THEN
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: p_error_msg := ' FAILED PARTY_SITES_ACC_D:' || to_char(p_party_site_id);
153: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D', FND_LOG.LEVEL_EXCEPTION);
154: RAISE;
155: END PARTY_SITES_ACC_D;