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_SR_CONTACT_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 34: CSM_UTIL_PKG.LOG('Entering SR_CNTACT_MDIRTY_U_FOREACHUSER for sr_contact_point_id: ' || p_sr_contact_point_id,

30:
31:
32: BEGIN
33: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
34: CSM_UTIL_PKG.LOG('Entering SR_CNTACT_MDIRTY_U_FOREACHUSER for sr_contact_point_id: ' || p_sr_contact_point_id,
35: 'CSM_SR_CONTACT_EVENT_PKG.SR_CNTACT_MDIRTY_U_FOREACHUSER',FND_LOG.LEVEL_PROCEDURE);
36:
37:
38: -- l_sr_contact_point_id := p_sr_contact_point_id;

Line 52: CSM_UTIL_PKG.LOG('Leaving SR_CNTACT_MDIRTY_U_FOREACHUSER for sr_contact_point_id: ' || p_sr_contact_point_id,

48: ,P_ACCESS_ID => l_user_rec.access_id
49: );
50: END LOOP;
51:
52: CSM_UTIL_PKG.LOG('Leaving SR_CNTACT_MDIRTY_U_FOREACHUSER for sr_contact_point_id: ' || p_sr_contact_point_id,
53: 'CSM_SR_CONTACT_EVENT_PKG.SR_CNTACT_MDIRTY_U_FOREACHUSER',FND_LOG.LEVEL_PROCEDURE);
54:
55: EXCEPTION
56: WHEN others THEN

Line 61: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_CONTACT_EVENT_PKG.SR_CNTACT_MDIRTY_U_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);

57: l_sqlerrno := to_char(SQLCODE);
58: l_sqlerrmsg := substr(SQLERRM, 1,2000);
59: l_error_msg := ' Exception in SR_CNTACT_MDIRTY_U_FOREACHUSER for sr_contact_point_id:' || to_char(p_sr_contact_point_id)
60: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
61: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_CONTACT_EVENT_PKG.SR_CNTACT_MDIRTY_U_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);
62: RAISE;
63: END SR_CNTACT_MDIRTY_U_FOREACHUSER;
64:
65: PROCEDURE SR_CNTACT_MDIRTY_I(p_sr_contact_point_id IN NUMBER, p_user_id IN NUMBER)

Line 73: CSM_UTIL_PKG.LOG('Entering SR_CNTACT_MDIRTY_I for sr_contact_point_id: ' || p_sr_contact_point_id,

69: l_error_msg VARCHAR2(4000);
70: l_return_status VARCHAR2(2000);
71:
72: BEGIN
73: CSM_UTIL_PKG.LOG('Entering SR_CNTACT_MDIRTY_I for sr_contact_point_id: ' || p_sr_contact_point_id,
74: 'CSM_SR_CONTACT_EVENT_PKG.SR_CNTACT_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
75:
76: CSM_ACC_PKG.Insert_Acc
77: ( P_PUBLICATION_ITEM_NAMES => g_srcntacts_pubi_name

Line 85: CSM_UTIL_PKG.LOG('Leaving SR_CNTACT_MDIRTY_I for sr_contact_point_id: ' || p_sr_contact_point_id,

81: ,P_PK1_NUM_VALUE => p_sr_contact_point_id
82: ,P_USER_ID => p_user_id
83: );
84:
85: CSM_UTIL_PKG.LOG('Leaving SR_CNTACT_MDIRTY_I for sr_contact_point_id: ' || p_sr_contact_point_id,
86: 'CSM_SR_CONTACT_EVENT_PKG.SR_CNTACT_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
87: EXCEPTION
88: WHEN OTHERS THEN
89: l_sqlerrno := to_char(SQLCODE);

Line 93: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_CONTACT_EVENT_PKG.SR_CNTACT_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);

89: l_sqlerrno := to_char(SQLCODE);
90: l_sqlerrmsg := substr(SQLERRM, 1,2000);
91: l_error_msg := ' Exception in SR_CNTACT_MDIRTY_I for sr_contact_point_id:' || to_char(p_sr_contact_point_id)
92: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
93: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_CONTACT_EVENT_PKG.SR_CNTACT_MDIRTY_I',FND_LOG.LEVEL_EXCEPTION);
94: RAISE;
95: END SR_CNTACT_MDIRTY_I;
96:
97: PROCEDURE SPAWN_USERLOOP_SR_CONTACT_INS(p_sr_contact_point_id IN NUMBER)

Line 120: CSM_UTIL_PKG.LOG('Entering SPAWN_USERLOOP_SR_CONTACT_INS for sr_contact_point_id: ' || p_sr_contact_point_id,

116: AND cont_acc.user_id = acc.user_id)
117: ;
118:
119: BEGIN
120: CSM_UTIL_PKG.LOG('Entering SPAWN_USERLOOP_SR_CONTACT_INS for sr_contact_point_id: ' || p_sr_contact_point_id,
121: 'CSM_SR_CONTACT_EVENT_PKG.SPAWN_USERLOOP_SR_CONTACT_INS',FND_LOG.LEVEL_PROCEDURE);
122:
123: FOR r_sr_contact_usr_rec IN l_sr_contact_usr_csr(p_sr_contact_point_id) LOOP
124: csm_sr_event_pkg.spawn_sr_contacts_ins(p_incident_id=>r_sr_contact_usr_rec.incident_id,

Line 130: CSM_UTIL_PKG.LOG('Leaving SPAWN_USERLOOP_SR_CONTACT_INS for sr_contact_point_id: ' || p_sr_contact_point_id,

126: p_user_id=>r_sr_contact_usr_rec.user_id,
127: p_flowtype=>NULL);
128: END LOOP;
129:
130: CSM_UTIL_PKG.LOG('Leaving SPAWN_USERLOOP_SR_CONTACT_INS for sr_contact_point_id: ' || p_sr_contact_point_id,
131: 'CSM_SR_CONTACT_EVENT_PKG.SPAWN_USERLOOP_SR_CONTACT_INS',FND_LOG.LEVEL_PROCEDURE);
132: EXCEPTION
133: WHEN OTHERS THEN
134: l_sqlerrno := to_char(SQLCODE);

Line 138: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_CONTACT_EVENT_PKG.SPAWN_USERLOOP_SR_CONTACT_INS',FND_LOG.LEVEL_EXCEPTION);

134: l_sqlerrno := to_char(SQLCODE);
135: l_sqlerrmsg := substr(SQLERRM, 1,2000);
136: l_error_msg := ' Exception in SPAWN_USERLOOP_SR_CONTACT_INS for sr_contact_point_id:' || to_char(p_sr_contact_point_id)
137: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
138: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_CONTACT_EVENT_PKG.SPAWN_USERLOOP_SR_CONTACT_INS',FND_LOG.LEVEL_EXCEPTION);
139: RAISE;
140: END SPAWN_USERLOOP_SR_CONTACT_INS;
141:
142: PROCEDURE SR_CNTACT_MDIRTY_D(p_sr_contact_point_id IN NUMBER, p_user_id IN NUMBER)

Line 150: CSM_UTIL_PKG.LOG('Entering SR_CNTACT_MDIRTY_D for sr_contact_point_id: ' || p_sr_contact_point_id,

146: l_error_msg VARCHAR2(4000);
147: l_return_status VARCHAR2(2000);
148:
149: BEGIN
150: CSM_UTIL_PKG.LOG('Entering SR_CNTACT_MDIRTY_D for sr_contact_point_id: ' || p_sr_contact_point_id,
151: 'CSM_SR_CONTACT_EVENT_PKG.SR_CNTACT_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
152:
153: CSM_ACC_PKG.Delete_Acc
154: ( P_PUBLICATION_ITEM_NAMES => g_srcntacts_pubi_name

Line 161: CSM_UTIL_PKG.LOG('Leaving SR_CNTACT_MDIRTY_D for sr_contact_point_id: ' || p_sr_contact_point_id,

157: ,P_PK1_NUM_VALUE => p_sr_contact_point_id
158: ,P_USER_ID => p_user_id
159: );
160:
161: CSM_UTIL_PKG.LOG('Leaving SR_CNTACT_MDIRTY_D for sr_contact_point_id: ' || p_sr_contact_point_id,
162: 'CSM_SR_CONTACT_EVENT_PKG.SR_CNTACT_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
163: EXCEPTION
164: WHEN OTHERS THEN
165: l_sqlerrno := to_char(SQLCODE);

Line 169: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_CONTACT_EVENT_PKG.SR_CNTACT_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);

165: l_sqlerrno := to_char(SQLCODE);
166: l_sqlerrmsg := substr(SQLERRM, 1,2000);
167: l_error_msg := ' Exception in SR_CNTACT_MDIRTY_D for sr_contact_point_id:' || to_char(p_sr_contact_point_id)
168: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
169: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_CONTACT_EVENT_PKG.SR_CNTACT_MDIRTY_D',FND_LOG.LEVEL_EXCEPTION);
170: RAISE;
171: END SR_CNTACT_MDIRTY_D;
172:
173: PROCEDURE SPAWN_USERLOOP_SR_CONTACT_DEL(p_sr_contact_point_id IN NUMBER)

Line 196: CSM_UTIL_PKG.LOG('Entering SPAWN_USERLOOP_SR_CONTACT_DEL for sr_contact_point_id: ' || p_sr_contact_point_id,

192: AND cont_acc.user_id = acc.user_id)
193: ;
194:
195: BEGIN
196: CSM_UTIL_PKG.LOG('Entering SPAWN_USERLOOP_SR_CONTACT_DEL for sr_contact_point_id: ' || p_sr_contact_point_id,
197: 'CSM_SR_CONTACT_EVENT_PKG.SPAWN_USERLOOP_SR_CONTACT_DEL',FND_LOG.LEVEL_PROCEDURE);
198:
199: FOR r_sr_contact_usr_rec IN l_sr_contact_usr_csr(p_sr_contact_point_id) LOOP
200: csm_sr_event_pkg.spawn_sr_contact_del(p_incident_id=>r_sr_contact_usr_rec.incident_id,

Line 206: CSM_UTIL_PKG.LOG('Leaving SPAWN_USERLOOP_SR_CONTACT_DEL for sr_contact_point_id: ' || p_sr_contact_point_id,

202: p_user_id=>r_sr_contact_usr_rec.user_id,
203: p_flowtype=>NULL);
204: END LOOP;
205:
206: CSM_UTIL_PKG.LOG('Leaving SPAWN_USERLOOP_SR_CONTACT_DEL for sr_contact_point_id: ' || p_sr_contact_point_id,
207: 'CSM_SR_CONTACT_EVENT_PKG.SPAWN_USERLOOP_SR_CONTACT_DEL',FND_LOG.LEVEL_PROCEDURE);
208: EXCEPTION
209: WHEN OTHERS THEN
210: l_sqlerrno := to_char(SQLCODE);

Line 214: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_CONTACT_EVENT_PKG.SPAWN_USERLOOP_SR_CONTACT_DEL',FND_LOG.LEVEL_EXCEPTION);

210: l_sqlerrno := to_char(SQLCODE);
211: l_sqlerrmsg := substr(SQLERRM, 1,2000);
212: l_error_msg := ' Exception in SPAWN_USERLOOP_SR_CONTACT_DEL for sr_contact_point_id:' || to_char(p_sr_contact_point_id)
213: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
214: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_CONTACT_EVENT_PKG.SPAWN_USERLOOP_SR_CONTACT_DEL',FND_LOG.LEVEL_EXCEPTION);
215: RAISE;
216: END SPAWN_USERLOOP_SR_CONTACT_DEL;
217:
218: FUNCTION CONTACT_POINT_UPD_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)

Line 237: CSM_UTIL_PKG.LOG('Entering CONTACT_POINT_UPD_WF_EVENT_SUB',

233: WHERE acc.sr_contact_point_id = pts.sr_contact_point_id
234: AND pts.contact_point_id = p_contact_point_id;
235:
236: BEGIN
237: CSM_UTIL_PKG.LOG('Entering CONTACT_POINT_UPD_WF_EVENT_SUB',
238: 'CSM_SR_CONTACT_EVENT_PKG.CONTACT_POINT_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
239:
240: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
241: RETURN 'SUCCESS';

Line 240: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

236: BEGIN
237: CSM_UTIL_PKG.LOG('Entering CONTACT_POINT_UPD_WF_EVENT_SUB',
238: 'CSM_SR_CONTACT_EVENT_PKG.CONTACT_POINT_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
239:
240: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
241: RETURN 'SUCCESS';
242: END IF;
243:
244: l_contact_point_id := p_event.GetValueForParameter('CONTACT_POINT_ID');

Line 257: CSM_UTIL_PKG.LOG('Leaving CONTACT_POINT_UPD_WF_EVENT_SUB for contact_point_id: ' || TO_CHAR(l_contact_point_id),

253: ,P_ACCESS_ID => l_user_rec.access_id
254: );
255: END LOOP;
256:
257: CSM_UTIL_PKG.LOG('Leaving CONTACT_POINT_UPD_WF_EVENT_SUB for contact_point_id: ' || TO_CHAR(l_contact_point_id),
258: 'CSM_SR_CONTACT_EVENT_PKG.CONTACT_POINT_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
259: RETURN 'SUCCESS';
260: EXCEPTION
261: WHEN OTHERS THEN

Line 266: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_CONTACT_EVENT_PKG.CONTACT_POINT_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);

262: l_sqlerrno := to_char(SQLCODE);
263: l_sqlerrmsg := substr(SQLERRM, 1,2000);
264: l_error_msg := ' Exception in CONTACT_POINT_UPD_WF_EVENT_SUB for contact_point_id:' || to_char(l_contact_point_id)
265: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
266: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_CONTACT_EVENT_PKG.CONTACT_POINT_UPD_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);
267: RETURN 'ERROR';
268: END CONTACT_POINT_UPD_WF_EVENT_SUB;
269:
270: END CSM_SR_CONTACT_EVENT_PKG;