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_EVENT_PKG dependencies on CSM_PARTY_EVENT_PKG

Line 1: PACKAGE BODY CSM_PARTY_EVENT_PKG AS

1: PACKAGE BODY CSM_PARTY_EVENT_PKG AS
2: /* $Header: csmeptyb.pls 120.1 2005/07/25 00:18:48 trajasek noship $ */
3:
4: g_table_name1 CONSTANT VARCHAR2(30) := 'HZ_PARTIES';
5: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PARTIES_ACC';

Line 69: p_error_msg := 'Entering CSM_PARTY_EVENT_PKG.PARTY_ACC_I' || ' for party_id ' || to_char(p_party_id);

65: l_ret_status VARCHAR2(4000);
66:
67: BEGIN
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69: p_error_msg := 'Entering CSM_PARTY_EVENT_PKG.PARTY_ACC_I' || ' for party_id ' || to_char(p_party_id);
70:
71: CSM_ACC_PKG.Insert_Acc
72: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
73: ,P_ACC_TABLE_NAME => g_acc_table_name1

Line 90: csm_util_pkg.LOG(l_err_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ACC_I', FND_LOG.LEVEL_ERROR);

86: x_return_status => l_ret_status
87: );
88:
89: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
90: csm_util_pkg.LOG(l_err_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ACC_I', FND_LOG.LEVEL_ERROR);
91: END IF;
92: END IF;
93:
94: p_error_msg := 'Leaving CSM_PARTY_EVENT_PKG.PARTY_ACC_I' || ' for party_id ' || to_char(p_party_id);

Line 94: p_error_msg := 'Leaving CSM_PARTY_EVENT_PKG.PARTY_ACC_I' || ' for party_id ' || to_char(p_party_id);

90: csm_util_pkg.LOG(l_err_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ACC_I', FND_LOG.LEVEL_ERROR);
91: END IF;
92: END IF;
93:
94: p_error_msg := 'Leaving CSM_PARTY_EVENT_PKG.PARTY_ACC_I' || ' for party_id ' || to_char(p_party_id);
95: EXCEPTION
96: WHEN others THEN
97: x_return_status := FND_API.G_RET_STS_ERROR;
98: p_error_msg := ' FAILED PARTY_ACC_I:' || to_char(p_party_id);

Line 99: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ACC_I', FND_LOG.LEVEL_EXCEPTION);

95: EXCEPTION
96: WHEN others THEN
97: x_return_status := FND_API.G_RET_STS_ERROR;
98: p_error_msg := ' FAILED PARTY_ACC_I:' || to_char(p_party_id);
99: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ACC_I', FND_LOG.LEVEL_EXCEPTION);
100: RAISE;
101:
102: END PARTY_ACC_I;
103:

Line 131: p_error_msg := 'Entering CSM_PARTY_EVENT_PKG.PARTY_ACC_D' || ' for party_id ' || to_char(p_party_id);

127: AND c.user_id = l_user_id ;
128:
129: BEGIN
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131: p_error_msg := 'Entering CSM_PARTY_EVENT_PKG.PARTY_ACC_D' || ' for party_id ' || to_char(p_party_id);
132:
133: /* OPEN l_check_party_ref(p_party_id, p_user_id) ;
134: FETCH l_check_party_REF INTO l_REF_EXISTS ;
135: IF l_check_party_REF%NOTFOUND THEN

Line 169: csm_util_pkg.LOG(l_err_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ACC_D', FND_LOG.LEVEL_ERROR);

165: x_return_status => l_ret_status
166: );
167:
168: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
169: csm_util_pkg.LOG(l_err_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ACC_D', FND_LOG.LEVEL_ERROR);
170: END IF;
171: END IF;
172:
173: p_error_msg := 'Leaving CSM_PARTY_EVENT_PKG.PARTY_ACC_D' || ' for party_id ' || to_char(p_party_id);

Line 173: p_error_msg := 'Leaving CSM_PARTY_EVENT_PKG.PARTY_ACC_D' || ' for party_id ' || to_char(p_party_id);

169: csm_util_pkg.LOG(l_err_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ACC_D', FND_LOG.LEVEL_ERROR);
170: END IF;
171: END IF;
172:
173: p_error_msg := 'Leaving CSM_PARTY_EVENT_PKG.PARTY_ACC_D' || ' for party_id ' || to_char(p_party_id);
174: EXCEPTION
175: WHEN others THEN
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: p_error_msg := ' FAILED PARTY_ACC_D:' || to_char(p_party_id);

Line 178: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ACC_D', FND_LOG.LEVEL_EXCEPTION);

174: EXCEPTION
175: WHEN others THEN
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: p_error_msg := ' FAILED PARTY_ACC_D:' || to_char(p_party_id);
178: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ACC_D', FND_LOG.LEVEL_EXCEPTION);
179: RAISE;
180:
181: END PARTY_ACC_D;
182:

Line 208: 'CSM_PARTY_EVENT_PKG.PARTY_ORG_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);

204: WHERE party_id = p_party_id;
205:
206: BEGIN
207: CSM_UTIL_PKG.LOG('Entering PARTY_ORG_UPD_WF_EVENT_SUB',
208: 'CSM_PARTY_EVENT_PKG.PARTY_ORG_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
209:
210: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
211: RETURN 'SUCCESS';
212: END IF;

Line 239: 'CSM_PARTY_EVENT_PKG.PARTY_ORG_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);

235: );
236: END LOOP;
237:
238: CSM_UTIL_PKG.LOG('Leaving PARTY_ORG_UPD_WF_EVENT_SUB for party_id: ' || TO_CHAR(l_party_id),
239: 'CSM_PARTY_EVENT_PKG.PARTY_ORG_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
240: RETURN 'SUCCESS';
241: EXCEPTION
242: WHEN OTHERS THEN
243: l_sqlerrno := to_char(SQLCODE);

Line 247: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ORG_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);

243: l_sqlerrno := to_char(SQLCODE);
244: l_sqlerrmsg := substr(SQLERRM, 1,2000);
245: l_error_msg := ' Exception in PARTY_ORG_UPD_WF_EVENT_SUB for party_id:' || to_char(l_party_id)
246: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
247: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ORG_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);
248: RETURN 'ERROR';
249: END PARTY_ORG_UPD_WF_EVENT_SUB;
250:
251: END CSM_PARTY_EVENT_PKG;

Line 251: END CSM_PARTY_EVENT_PKG;

247: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_PARTY_EVENT_PKG.PARTY_ORG_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);
248: RETURN 'ERROR';
249: END PARTY_ORG_UPD_WF_EVENT_SUB;
250:
251: END CSM_PARTY_EVENT_PKG;