APPS.CSM_STATE_TRANSITION_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 52: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForUser('CSF_M_STATE_TRANSITIONS',

48: l_pkvalueslist := l_null_pkvalueslist;
49: l_pkvalueslist(1) := l_state_transition_id;
50:
51: --mark dirty the SDQ
52: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForUser('CSF_M_STATE_TRANSITIONS',
53: -- l_access_id, p_user_id, ASG_DOWNLOAD.DEL, SYSDATE, l_pkvalueslist);
54: -- Since access_id's are sequence based, we do not need to pass pk values for delete
55: l_access_id, p_user_id, ASG_DOWNLOAD.DEL, SYSDATE);
56:

Line 89: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

85:
86: l_state_transition_id JTF_STATE_TRANSITIONS.state_transition_id%TYPE;
87: l_last_update_date JTF_STATE_TRANSITIONS.LAST_UPDATE_DATE%TYPE;
88: l_access_id CSM_STATE_TRANSITIONS_ACC.ACCESS_ID%TYPE;
89: l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
90: l_dsql varchar2(2048);
91: l_bind_count NUMBER :=1;
92:
93: BEGIN

Line 122: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForUser('CSF_M_STATE_TRANSITIONS',

118: FETCH l_updates_cur INTO l_state_transition_id, l_last_update_date, l_access_id;
119: EXIT WHEN l_updates_cur%NOTFOUND;
120:
121: --mark dirty the SDQ
122: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForUser('CSF_M_STATE_TRANSITIONS',
123: l_access_id, p_user_id,
124: ASG_DOWNLOAD.UPD, sysdate);
125:
126: --update ACC

Line 165: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

161: l_state_transition_id JTF_STATE_TRANSITIONS.state_transition_id%TYPE;
162: l_last_update_date JTF_STATE_TRANSITIONS.LAST_UPDATE_DATE%TYPE;
163: l_responsibility_id jtf_state_responsibilities.responsibility_id%TYPE;
164: l_access_id CSM_STATE_TRANSITIONS_ACC.ACCESS_ID%TYPE;
165: l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;
166: l_dsql varchar2(2048);
167: l_bind_count NUMBER :=2;
168: BEGIN
169: -- get the user responsibility id

Line 214: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForUser('CSF_M_STATE_TRANSITIONS',

210: l_access_id := p_access_id;
211: END IF;
212:
213: --mark dirty the SDQ
214: l_mark_dirty := CSM_UTIL_PKG.MakeDirtyForUser('CSF_M_STATE_TRANSITIONS',
215: l_access_id, p_user_id,
216: ASG_DOWNLOAD.INS, sysdate);
217:
218: --insert into ACC

Line 305: l_responsibility_id := CSM_UTIL_PKG.get_responsibility_id(p_user_id);

301:
302: --if user id is passed, refresh for only that user.
303: --else refresh for all the users
304: /* IF p_user_id IS NOT NULL THEN
305: l_responsibility_id := CSM_UTIL_PKG.get_responsibility_id(p_user_id);
306:
307: IF l_responsibility_id IS NULL THEN
308: RAISE l_no_status_transition_resp;
309: END IF;

Line 312: p_user_name => CSM_UTIL_PKG.get_user_name( p_user_id),

308: RAISE l_no_status_transition_resp;
309: END IF;
310:
311: refresh_acc( p_user_id => p_user_id,
312: p_user_name => CSM_UTIL_PKG.get_user_name( p_user_id),
313: p_access_id => p_access_id,
314: p_respid => l_responsibility_id);
315: ELSE
316: */

Line 321: l_responsibility_id := CSM_UTIL_PKG.get_responsibility_id(l_omfs_palm_resources_rec.user_id);

317: --refresh for all the users
318: FOR l_omfs_palm_resources_rec IN l_omfs_palm_resources_csr LOOP
319: BEGIN
320: l_user_id := l_omfs_palm_resources_rec.user_id;
321: l_responsibility_id := CSM_UTIL_PKG.get_responsibility_id(l_omfs_palm_resources_rec.user_id);
322:
323: IF l_responsibility_id IS NULL THEN
324: RAISE l_no_status_transition_resp;
325: END IF;

Line 333: csm_util_pkg.log('No Status Transition responsibility defined for user: ' || l_omfs_palm_resources_rec.user_name);

329: p_access_id => NULL,
330: p_respid => l_responsibility_id);
331: EXCEPTION
332: WHEN l_no_status_transition_resp THEN
333: csm_util_pkg.log('No Status Transition responsibility defined for user: ' || l_omfs_palm_resources_rec.user_name);
334: END;
335: END LOOP;
336: -- END IF;
337:

Line 350: csm_util_pkg.log('No Status Transition responsibility defined for user: ' || l_user_id);

346: p_message := 'CSM_STATE_TRANSITION_EVENT_PKG.Refresh_Acc Executed successfully';
347:
348: EXCEPTION
349: WHEN l_no_status_transition_resp THEN
350: csm_util_pkg.log('No Status Transition responsibility defined for user: ' || l_user_id);
351: p_status := 'ERROR';
352: p_message := 'Error in CSM_STATE_TRANSITION_EVENT_PKG.Refresh_Acc';
353:
354: WHEN others THEN

Line 357: csm_util_pkg.log('State Tansition Error:' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_STATE_TRANISITION_EVENT_PKG.Refresh_Acc');

353:
354: WHEN others THEN
355: l_sqlerrno := to_char(SQLCODE);
356: l_sqlerrmsg := substr(SQLERRM, 1,300);
357: csm_util_pkg.log('State Tansition Error:' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_STATE_TRANISITION_EVENT_PKG.Refresh_Acc');
358: p_status := 'ERROR';
359: p_message := 'Error in CSM_STATE_TRANSITION_EVENT_PKG.Refresh_Acc :' ||l_sqlerrno || ':' || l_sqlerrmsg;
360: ROLLBACK;
361: -- logm('State Transition Error:' || l_sqlerrno || ':' || substr(l_sqlerrmsg,1,200));