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 128: x_return_status := FND_API.G_RET_STS_SUCCESS;

124: AND ps.party_site_id = b.incident_location_id);
125:
126:
127: BEGIN
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129: p_error_msg := 'Entering CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D' || ' for party_site_id ' || to_char(p_party_site_id);
130:
131: OPEN l_party_sites_csr(p_party_site_id, p_user_id);
132: FETCH l_party_sites_csr into l_party_id;

Line 153: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN

149: p_flowtype => p_flowtype,
150: p_error_msg => l_err_msg,
151: x_return_status => l_ret_status);
152:
153: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
154: csm_util_pkg.LOG(l_err_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D', FND_LOG.LEVEL_ERROR);
155: END IF;
156: END IF;
157: p_error_msg := 'Leaving CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D' || ' for party_site_id ' || to_char(p_party_site_id);

Line 161: x_return_status := FND_API.G_RET_STS_ERROR;

157: p_error_msg := 'Leaving CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D' || ' for party_site_id ' || to_char(p_party_site_id);
158:
159: EXCEPTION
160: WHEN others THEN
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: p_error_msg := ' FAILED PARTY_SITES_ACC_D:' || to_char(p_party_site_id);
163: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D', FND_LOG.LEVEL_EXCEPTION);
164: RAISE;
165: END PARTY_SITES_ACC_D;