DBA Data[Home] [Help]

APPS.CSM_PARTY_SITE_EVENT_PKG dependencies on FND_LOG

Line 89: csm_util_pkg.LOG(l_err_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_I', FND_LOG.LEVEL_ERROR);

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);
93: EXCEPTION

Line 97: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_I', FND_LOG.LEVEL_EXCEPTION);

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;
100:
101: PROCEDURE PARTY_SITES_ACC_D (p_party_site_id IN NUMBER,

Line 144: csm_util_pkg.LOG(l_err_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D', FND_LOG.LEVEL_ERROR);

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

Line 153: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D', FND_LOG.LEVEL_EXCEPTION);

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;
156:
157: PROCEDURE PARTY_SITES_ACC_U (p_party_site_id IN NUMBER,

Line 176: 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_U',FND_LOG.LEVEL_PROCEDURE);

172: WHERE party_site_id = p_party_site_id;
173:
174: BEGIN
175: CSM_UTIL_PKG.LOG('Entering PARTY_SITES_ACC_U for party_site_id: ' || p_party_site_id,
176: 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_U',FND_LOG.LEVEL_PROCEDURE);
177:
178: FOR r_party_site_acc_rec IN l_party_site_acc_csr(p_party_site_id) LOOP
179: -- Call Update
180: CSM_ACC_PKG.Update_Acc

Line 189: 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_U',FND_LOG.LEVEL_PROCEDURE);

185: );
186: END LOOP;
187:
188: CSM_UTIL_PKG.LOG('Leaving PARTY_SITES_ACC_U for party_site_id: ' || p_party_site_id,
189: 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_U',FND_LOG.LEVEL_PROCEDURE);
190: EXCEPTION
191: WHEN OTHERS THEN
192: l_sqlerrno := to_char(SQLCODE);
193: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 196: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_U',FND_LOG.LEVEL_EXCEPTION);

192: l_sqlerrno := to_char(SQLCODE);
193: l_sqlerrmsg := substr(SQLERRM, 1,2000);
194: l_error_msg := ' Exception in PARTY_SITES_ACC_U for party_site_id:'
195: || to_char(p_party_site_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
196: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_U',FND_LOG.LEVEL_EXCEPTION);
197: RAISE;
198: END PARTY_SITES_ACC_U;
199:
200: FUNCTION LOCATION_UPD_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)

Line 221: 'CSM_PARTY_SITE_EVENT_PKG.LOCATION_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);

217: AND acc.party_site_id = ps.party_site_id;
218:
219: BEGIN
220: CSM_UTIL_PKG.LOG('Entering LOCATION_UPD_EVENT_SUB',
221: 'CSM_PARTY_SITE_EVENT_PKG.LOCATION_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
222:
223: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
224: RETURN 'SUCCESS';
225: END IF;

Line 240: 'CSM_PARTY_SITE_EVENT_PKG.LOCATION_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);

236: );
237: END LOOP;
238:
239: CSM_UTIL_PKG.LOG('Leaving LOCATION_UPD_EVENT_SUB for location_id: ' || TO_CHAR(l_location_id),
240: 'CSM_PARTY_SITE_EVENT_PKG.LOCATION_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
241:
242: RETURN 'SUCCESS';
243: EXCEPTION
244: WHEN OTHERS THEN

Line 249: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PARTY_SITE_EVENT_PKG.LOCATION_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);

245: l_sqlerrno := to_char(SQLCODE);
246: l_sqlerrmsg := substr(SQLERRM, 1,2000);
247: l_error_msg := ' Exception in LOCATION_UPD_EVENT_SUB for location_id:' || to_char(l_location_id)
248: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
249: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PARTY_SITE_EVENT_PKG.LOCATION_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);
250: RETURN 'ERROR';
251: END LOCATION_UPD_WF_EVENT_SUB;
252:
253: FUNCTION PARTY_SITE_UPD_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)

Line 271: 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITE_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);

267: WHERE party_site_id = p_party_site_id;
268:
269: BEGIN
270: CSM_UTIL_PKG.LOG('Entering PARTY_SITE_UPD_WF_EVENT_SUB',
271: 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITE_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
272:
273: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
274: RETURN 'SUCCESS';
275: END IF;

Line 291: 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITE_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);

287: );
288: END LOOP;
289:
290: CSM_UTIL_PKG.LOG('Leaving PARTY_SITE_UPD_WF_EVENT_SUB for party_site_id: ' || TO_CHAR(l_party_site_id),
291: 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITE_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
292:
293: RETURN 'SUCCESS';
294: EXCEPTION
295: WHEN OTHERS THEN

Line 300: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITE_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);

296: l_sqlerrno := to_char(SQLCODE);
297: l_sqlerrmsg := substr(SQLERRM, 1,2000);
298: l_error_msg := ' Exception in PARTY_SITE_UPD_WF_EVENT_SUB for party_site_id:' || to_char(l_party_site_id)
299: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
300: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITE_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);
301: RETURN 'ERROR';
302: END PARTY_SITE_UPD_WF_EVENT_SUB;
303:
304: END CSM_PARTY_SITE_EVENT_PKG;