eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_PARTY_SITE_EVENT_PKG dependencies on CSM_PARTY_SITE_EVENT_PKG

Line 1: PACKAGE BODY CSM_PARTY_SITE_EVENT_PKG AS

1: PACKAGE BODY CSM_PARTY_SITE_EVENT_PKG AS
2: /* $Header: csmeptsb.pls 120.1 2005/07/25 00:18:18 trajasek noship $ */
3:
4: g_table_name1 CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITES';
5: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC';

Line 64: p_error_msg := 'Entering CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_I' || ' for party_site_id ' || to_char(p_party_site_id);

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;
68: CLOSE l_party_sites_csr;

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 92: p_error_msg := 'Leaving CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_I' || ' for party_site_id ' || to_char(p_party_site_id);

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

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 120: p_error_msg := 'Entering CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D' || ' for party_site_id ' || to_char(p_party_site_id);

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;
124: CLOSE l_party_sites_csr;

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 147: p_error_msg := 'Leaving CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D' || ' for party_site_id ' || to_char(p_party_site_id);

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:
149: EXCEPTION
150: WHEN others THEN
151: x_return_status := FND_API.G_RET_STS_ERROR;

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;

Line 304: END CSM_PARTY_SITE_EVENT_PKG;

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;