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.CSZ_INTERACTION_PVT dependencies on FND_MSG_PUB

Line 73: Fnd_Msg_Pub.initialize;

69:
70: -- standard call to check for call compatibility.
71: IF Fnd_Api.to_boolean(l_init_msg_list)
72: THEN
73: Fnd_Msg_Pub.initialize;
74: END IF;
75:
76: -- Initialize API return status to success
77: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 87: Fnd_Msg_Pub.ADD;

83: --verify direction flag, set in media rec
84: if (p_direction <> 'INBOUND' AND p_direction <> 'OUTBOUND') then
85: x_return_status := Fnd_Api.G_RET_STS_ERROR;
86: Fnd_Message.set_name('CS','Error:Invalid Direction specified for Interaction.');
87: Fnd_Msg_Pub.ADD;
88: RAISE Fnd_Api.G_EXC_ERROR;
89: else
90: l_media_rec.direction := p_direction;
91: end if;

Line 96: Fnd_Msg_Pub.ADD;

92:
93: --verify p_resp_appl_id, p_resp_id, p_user_id, p_login_id are valid
94: if (p_resp_appl_id = null OR p_resp_appl_id = Fnd_Api.G_MISS_NUM) then
95: Fnd_Message.SET_NAME('CS','Invalid Application id found');
96: Fnd_Msg_Pub.ADD;
97: end if;
98:
99: if (p_resp_id = null OR p_resp_id = Fnd_Api.G_MISS_NUM) then
100: Fnd_Message.SET_NAME('CS','Invalid Responsibility id found');

Line 101: Fnd_Msg_Pub.ADD;

97: end if;
98:
99: if (p_resp_id = null OR p_resp_id = Fnd_Api.G_MISS_NUM) then
100: Fnd_Message.SET_NAME('CS','Invalid Responsibility id found');
101: Fnd_Msg_Pub.ADD;
102: end if;
103:
104: if (p_user_id = null OR p_user_id = Fnd_Api.G_MISS_NUM) then
105: Fnd_Message.SET_NAME('CS','Invalid User Id');

Line 106: Fnd_Msg_Pub.ADD;

102: end if;
103:
104: if (p_user_id = null OR p_user_id = Fnd_Api.G_MISS_NUM) then
105: Fnd_Message.SET_NAME('CS','Invalid User Id');
106: Fnd_Msg_Pub.ADD;
107: RAISE Fnd_Api.G_EXC_ERROR;
108: end if;
109:
110: if (p_login_id = null OR p_login_id = Fnd_Api.G_MISS_NUM) then

Line 112: Fnd_Msg_Pub.ADD;

108: end if;
109:
110: if (p_login_id = null OR p_login_id = Fnd_Api.G_MISS_NUM) then
111: Fnd_Message.SET_NAME('CS','Invalid User Login Id');
112: Fnd_Msg_Pub.ADD;
113: end if;
114:
115: begin
116: -- open media item

Line 133: Fnd_Msg_Pub.ADD;

129: exception
130: when others then
131: -- throw error
132: Fnd_Message.SET_NAME('CS','Error while trying to Open MediaItem');
133: Fnd_Msg_Pub.ADD;
134: rollback to begin_interaction_sp;
135: x_return_status := Fnd_Api.G_RET_STS_ERROR;
136: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
137: p_count => l_msg_count,

Line 136: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

132: Fnd_Message.SET_NAME('CS','Error while trying to Open MediaItem');
133: Fnd_Msg_Pub.ADD;
134: rollback to begin_interaction_sp;
135: x_return_status := Fnd_Api.G_RET_STS_ERROR;
136: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
137: p_count => l_msg_count,
138: p_data => l_msg_data);
139: end;
140: exception

Line 144: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

140: exception
141: when others then
142: rollback to begin_interaction_sp;
143: x_return_status := Fnd_Api.G_RET_STS_ERROR;
144: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
145: p_count => l_msg_count,
146: p_data => l_msg_data);
147: end;
148:

Line 162: Fnd_Msg_Pub.ADD;

158: exception
159: when NO_DATA_FOUND then
160: x_return_status := Fnd_Api.G_RET_STS_ERROR;
161: Fnd_Message.SET_NAME('CS','No resource Id found for User:' || p_user_id);
162: Fnd_Msg_Pub.ADD;
163: raise NO_DATA_FOUND;
164: end;
165: -- Profile Values from wrap up
166: begin

Line 172: Fnd_Msg_Pub.ADD;

168: exception
169: when NO_DATA_FOUND then
170: x_return_status := Fnd_Api.G_RET_STS_ERROR;
171: Fnd_Message.SET_NAME('CS','Profile "CSC_CC_WRAPUP_INTERACTION_DEFAULTS" could not be found');
172: Fnd_Msg_Pub.ADD;
173: raise NO_DATA_FOUND;
174: end;
175:
176: -- Retreive default values for populating the result, reason, outcome fields in JTF_IH_ACTIVITIES table

Line 183: Fnd_Msg_Pub.ADD;

179: exception
180: when NO_DATA_FOUND then
181: x_return_status := Fnd_Api.G_RET_STS_ERROR;
182: Fnd_Message.SET_NAME('CS','Outcome, result, reason codes could not be found');
183: Fnd_Msg_Pub.ADD;
184: raise NO_DATA_FOUND;
185: end;
186: l_action_value := SR_UPDATE;
187: -- Retreives the valid actionID for SR update actions.

Line 197: Fnd_Msg_Pub.ADD;

193: exception
194: when NO_DATA_FOUND then
195: x_return_status := Fnd_Api.G_RET_STS_ERROR;
196: Fnd_Message.SET_NAME('CS','Action Id could not be found for SR Update action');
197: Fnd_Msg_Pub.ADD;
198: raise NO_DATA_FOUND;
199: end;
200:
201: l_interaction_rec.outcome_id := l_outcome_id;

Line 222: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

218: exception
219: when others then
220: rollback to begin_interaction_sp;
221: x_return_status := Fnd_Api.G_RET_STS_ERROR;
222: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
223: p_count => l_msg_count,
224: p_data => l_msg_data);
225: end;
226: exception

Line 230: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

226: exception
227: when others then
228: rollback to begin_interaction_sp;
229: x_return_status := Fnd_Api.G_RET_STS_ERROR;
230: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
231: p_count => l_msg_count,
232: p_data => l_msg_data);
233: end;
234: -- Add activity for this interaction and return activity id if successful

Line 250: Fnd_Msg_Pub.ADD;

246: exception
247: when NO_DATA_FOUND then
248: x_return_status := Fnd_Api.G_RET_STS_ERROR;
249: Fnd_Message.SET_NAME('CS','ActionItemId not found for "Service Request" module');
250: Fnd_Msg_Pub.ADD;
251: raise NO_DATA_FOUND;
252: end;
253: begin
254: JTF_IH_PUB.add_activity( l_api_version,

Line 270: Fnd_Msg_Pub.ADD;

266: exception
267: when others then
268: x_return_status := Fnd_Api.G_RET_STS_ERROR;
269: Fnd_Message.SET_NAME('CS','Error while creating Activity record');
270: Fnd_Msg_Pub.ADD;
271: raise Fnd_Api.G_EXC_ERROR;
272: end;
273: exception
274: when others then

Line 277: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

273: exception
274: when others then
275: rollback to begin_interaction_sp;
276: x_return_status := Fnd_Api.G_RET_STS_ERROR;
277: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
278: p_count => l_msg_count,
279: p_data => l_msg_data);
280: end;
281: -- set up return values when successful.

Line 289: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

285: exception
286: when others then
287: rollback to begin_interaction_sp;
288: x_return_status := Fnd_Api.G_RET_STS_ERROR;
289: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
290: p_count => l_msg_count,
291: p_data => l_msg_data);
292: end;
293:

Line 348: Fnd_Msg_Pub.initialize;

344:
345: -- standard call to check for call compatibility.
346: IF Fnd_Api.to_boolean(l_init_msg_list)
347: THEN
348: Fnd_Msg_Pub.initialize;
349: END IF;
350:
351: -- Initialize API return status to success
352: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 363: Fnd_Msg_Pub.ADD;

359: when NO_DATA_FOUND then
360: x_return_status := Fnd_Api.G_RET_STS_ERROR;
361: -- dbms_output.put_line ('No Media Id found for corresponding Interaction Id:' || p_interaction_id);
362: Fnd_Message.SET_NAME('CS','No Media Id found for corresponding Interaction Id:' || p_interaction_id);
363: Fnd_Msg_Pub.ADD;
364: RAISE NO_DATA_FOUND;
365: when others then
366: -- dbms_output.put_line ('EndInteraction :: Error while retrieving media Id for Interaction Id:' || p_interaction_id);
367: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 369: Fnd_Msg_Pub.ADD;

365: when others then
366: -- dbms_output.put_line ('EndInteraction :: Error while retrieving media Id for Interaction Id:' || p_interaction_id);
367: x_return_status := Fnd_Api.G_RET_STS_ERROR;
368: Fnd_Message.SET_NAME('CS','EndInteraction :: Error while retrieving media Id for Interaction Id:' || p_interaction_id);
369: Fnd_Msg_Pub.ADD;
370: RAISE Fnd_Api.G_EXC_ERROR;
371: end;
372:
373: if (p_event = APPLY OR p_event = STOP) then

Line 390: Fnd_Msg_Pub.ADD;

386: when NO_DATA_FOUND then
387: x_return_status := Fnd_Api.G_RET_STS_ERROR;
388: -- dbms_output.put_line ('No Action Id found for corresponding Action:' || l_action_value);
389: Fnd_Message.SET_NAME('CS','No Action Id found for corresponding Action:' || l_action_value);
390: Fnd_Msg_Pub.ADD;
391: Raise NO_DATA_FOUND;
392: when others then
393: -- dbms_output.put_line ('EndInteraction :: Error while retrieving action Id for Action:' || l_action_value);
394: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 396: Fnd_Msg_Pub.ADD;

392: when others then
393: -- dbms_output.put_line ('EndInteraction :: Error while retrieving action Id for Action:' || l_action_value);
394: x_return_status := Fnd_Api.G_RET_STS_ERROR;
395: Fnd_Message.SET_NAME('CS','EndInteraction :: Error while retrieving action Id for Action:' || l_action_value);
396: Fnd_Msg_Pub.ADD;
397: RAISE Fnd_Api.G_EXC_ERROR;
398: end;
399: -- dbms_output.put_line ('ActionID=' || l_action_id || ' Status=' || x_return_status);
400: l_activity_rec.action_id := l_action_id; -- Created

Line 407: Fnd_Msg_Pub.ADD;

403: exception
404: when NO_DATA_FOUND then
405: x_return_status := Fnd_Api.G_RET_STS_ERROR;
406: Fnd_Message.SET_NAME('CS','ActionItemId not found for "Service Request" module');
407: Fnd_Msg_Pub.ADD;
408: raise NO_DATA_FOUND;
409: end;
410: l_activity_rec.interaction_id := p_interaction_id;
411: l_activity_rec.end_date_time := sysdate;

Line 433: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

429: when others then
430: -- dbms_output.put_line ('Error after updateActivity-' || l_msg_data);
431: rollback to end_interaction_sp;
432: x_return_status := Fnd_Api.G_RET_STS_ERROR;
433: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
434: p_count => l_msg_count,
435: p_data => l_msg_data);
436: end;
437:

Line 451: Fnd_Msg_Pub.ADD;

447: when NO_DATA_FOUND then
448: rollback to end_interaction_sp;
449: x_return_status := Fnd_Api.G_RET_STS_ERROR;
450: Fnd_Message.SET_NAME('CS','No resource Id found for User:' || p_user_id);
451: Fnd_Msg_Pub.ADD;
452: raise NO_DATA_FOUND;
453: end;
454: -- dbms_output.put_line ('Got Resource Id=' || l_interaction_rec.resource_id|| ' Status=' || x_return_status);
455:

Line 464: Fnd_Msg_Pub.ADD;

460: when NO_DATA_FOUND then
461: rollback to end_interaction_sp;
462: x_return_status := Fnd_Api.G_RET_STS_ERROR;
463: Fnd_Message.SET_NAME('CS','Profile "CSC_CC_WRAPUP_INTERACTION_DEFAULTS" could not be found');
464: Fnd_Msg_Pub.ADD;
465: raise NO_DATA_FOUND;
466: end;
467:
468: -- dbms_output.put_line ('Got Profile Id=CSC_CC_WRAPUP_INTERACTION_DEFAULTS'|| ' Status=' || x_return_status);

Line 477: Fnd_Msg_Pub.ADD;

473: when NO_DATA_FOUND then
474: rollback to end_interaction_sp;
475: x_return_status := Fnd_Api.G_RET_STS_ERROR;
476: Fnd_Message.SET_NAME('CS','Outcome, result, reason codes could not be found');
477: Fnd_Msg_Pub.ADD;
478: raise NO_DATA_FOUND;
479: end;
480: -- dbms_output.put_line ('Got Outcome,reason,result Id=' || l_outcome_id || ' Status=' || x_return_status);
481:

Line 499: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

495: exception
496: when others then
497: rollback to end_interaction_sp;
498: x_return_status := Fnd_Api.G_RET_STS_ERROR;
499: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
500: p_count => l_msg_count,
501: p_data => l_msg_data);
502: end;
503: l_media_rec.media_id := l_media_id;

Line 524: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

520: exception
521: when others then
522: rollback to end_interaction_sp;
523: x_return_status := Fnd_Api.G_RET_STS_ERROR;
524: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
525: p_count => l_msg_count,
526: p_data => l_msg_data);
527: end;
528: -- dbms_output.put_line ('Closed Media Item'|| ' Status=' || x_return_status );

Line 533: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

529: exception
530: when others then
531: rollback to end_interaction_sp;
532: x_return_status := Fnd_Api.G_RET_STS_ERROR;
533: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
534: p_count => l_msg_count,
535: p_data => l_msg_data);
536: end;
537: