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.2 2011/01/10 10:37:02 saradhak ship $ */
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 129: p_error_msg := 'Entering CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D' || ' for party_site_id ' || to_char(p_party_site_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;
133: CLOSE l_party_sites_csr;

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

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

Line 157: p_error_msg := 'Leaving CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_D' || ' for party_site_id ' || to_char(p_party_site_id);

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);
158:
159: EXCEPTION
160: WHEN others THEN
161: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

182: WHERE party_site_id = p_party_site_id;
183:
184: BEGIN
185: CSM_UTIL_PKG.LOG('Entering PARTY_SITES_ACC_U for party_site_id: ' || p_party_site_id,
186: 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_U',FND_LOG.LEVEL_PROCEDURE);
187:
188: FOR r_party_site_acc_rec IN l_party_site_acc_csr(p_party_site_id) LOOP
189: -- Call Update
190: CSM_ACC_PKG.Update_Acc

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

195: );
196: END LOOP;
197:
198: CSM_UTIL_PKG.LOG('Leaving PARTY_SITES_ACC_U for party_site_id: ' || p_party_site_id,
199: 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_U',FND_LOG.LEVEL_PROCEDURE);
200: EXCEPTION
201: WHEN OTHERS THEN
202: l_sqlerrno := to_char(SQLCODE);
203: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

202: l_sqlerrno := to_char(SQLCODE);
203: l_sqlerrmsg := substr(SQLERRM, 1,2000);
204: l_error_msg := ' Exception in PARTY_SITES_ACC_U for party_site_id:'
205: || to_char(p_party_site_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
206: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITES_ACC_U',FND_LOG.LEVEL_EXCEPTION);
207: RAISE;
208: END PARTY_SITES_ACC_U;
209:
210: FUNCTION LOCATION_UPD_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)

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

227: AND acc.party_site_id = ps.party_site_id;
228:
229: BEGIN
230: CSM_UTIL_PKG.LOG('Entering LOCATION_UPD_EVENT_SUB',
231: 'CSM_PARTY_SITE_EVENT_PKG.LOCATION_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
232:
233: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
234: RETURN 'SUCCESS';
235: END IF;

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

246: );
247: END LOOP;
248:
249: CSM_UTIL_PKG.LOG('Leaving LOCATION_UPD_EVENT_SUB for location_id: ' || TO_CHAR(l_location_id),
250: 'CSM_PARTY_SITE_EVENT_PKG.LOCATION_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
251:
252: RETURN 'SUCCESS';
253: EXCEPTION
254: WHEN OTHERS THEN

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

255: l_sqlerrno := to_char(SQLCODE);
256: l_sqlerrmsg := substr(SQLERRM, 1,2000);
257: l_error_msg := ' Exception in LOCATION_UPD_EVENT_SUB for location_id:' || to_char(l_location_id)
258: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
259: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PARTY_SITE_EVENT_PKG.LOCATION_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);
260: RETURN 'ERROR';
261: END LOCATION_UPD_WF_EVENT_SUB;
262:
263: FUNCTION PARTY_SITE_UPD_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)

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

277: WHERE party_site_id = p_party_site_id;
278:
279: BEGIN
280: CSM_UTIL_PKG.LOG('Entering PARTY_SITE_UPD_WF_EVENT_SUB',
281: 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITE_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
282:
283: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
284: RETURN 'SUCCESS';
285: END IF;

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

297: );
298: END LOOP;
299:
300: CSM_UTIL_PKG.LOG('Leaving PARTY_SITE_UPD_WF_EVENT_SUB for party_site_id: ' || TO_CHAR(l_party_site_id),
301: 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITE_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
302:
303: RETURN 'SUCCESS';
304: EXCEPTION
305: WHEN OTHERS THEN

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

306: l_sqlerrno := to_char(SQLCODE);
307: l_sqlerrmsg := substr(SQLERRM, 1,2000);
308: l_error_msg := ' Exception in PARTY_SITE_UPD_WF_EVENT_SUB for party_site_id:' || to_char(l_party_site_id)
309: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
310: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITE_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);
311: RETURN 'ERROR';
312: END PARTY_SITE_UPD_WF_EVENT_SUB;
313:
314: END CSM_PARTY_SITE_EVENT_PKG;

Line 314: END CSM_PARTY_SITE_EVENT_PKG;

310: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PARTY_SITE_EVENT_PKG.PARTY_SITE_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);
311: RETURN 'ERROR';
312: END PARTY_SITE_UPD_WF_EVENT_SUB;
313:
314: END CSM_PARTY_SITE_EVENT_PKG;