DBA Data[Home] [Help]

APPS.CSM_PARTY_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 81: IF NOT csm_util_pkg.is_flow_history(p_flowtype) THEN

77: ,P_USER_ID => p_user_id
78: );
79:
80: -- if not history, get notes for customer
81: IF NOT csm_util_pkg.is_flow_history(p_flowtype) THEN
82: CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_GRP(p_sourceobjectcode => 'PARTY',
83: p_sourceobjectid => p_party_id,
84: p_userid => p_user_id,
85: p_error_msg => l_err_msg,

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 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 160: IF NOT (csm_util_pkg.is_flow_history(p_flowtype)) THEN

156: ,P_USER_ID => p_user_id
157: );
158:
159: -- delete notes if flow is not history
160: IF NOT (csm_util_pkg.is_flow_history(p_flowtype)) THEN
161: CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_D_GRP(p_sourceobjectcode => 'PARTY',
162: p_sourceobjectid => p_party_id,
163: p_userid => p_user_id,
164: p_error_msg => l_err_msg,

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 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 207: CSM_UTIL_PKG.LOG('Entering PARTY_ORG_UPD_WF_EVENT_SUB',

203: FROM csm_party_sites_acc
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';

Line 210: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

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;
213:
214: l_party_id := p_event.GetValueForParameter('PARTY_ID');

Line 238: CSM_UTIL_PKG.LOG('Leaving PARTY_ORG_UPD_WF_EVENT_SUB for party_id: ' || TO_CHAR(l_party_id),

234: ,P_ACCESS_ID => r_party_sites_rec.access_id
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

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;