DBA Data[Home] [Help]

APPS.CSZ_INTERACTION_PVT dependencies on FND_MESSAGE

Line 86: Fnd_Message.set_name('CS','Error:Invalid Direction specified for Interaction.');

82: l_media_rec.media_item_type := SR_MEDIA_TYPE;
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;

Line 95: Fnd_Message.SET_NAME('CS','Invalid Application id found');

91: end if;
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

Line 100: Fnd_Message.SET_NAME('CS','Invalid Responsibility 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');
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

Line 105: Fnd_Message.SET_NAME('CS','Invalid User Id');

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');
106: Fnd_Msg_Pub.ADD;
107: RAISE Fnd_Api.G_EXC_ERROR;
108: end if;
109:

Line 111: Fnd_Message.SET_NAME('CS','Invalid User Login Id');

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
111: Fnd_Message.SET_NAME('CS','Invalid User Login Id');
112: Fnd_Msg_Pub.ADD;
113: end if;
114:
115: begin

Line 132: Fnd_Message.SET_NAME('CS','Error while trying to Open MediaItem');

128: l_media_id ); -- returns media id
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,

Line 161: Fnd_Message.SET_NAME('CS','No resource Id found for User:' || p_user_id);

157: SELECT resource_id INTO l_interaction_rec.resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id;
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

Line 171: Fnd_Message.SET_NAME('CS','Profile "CSC_CC_WRAPUP_INTERACTION_DEFAULTS" could not be found');

167: select FND_PROFILE.Value('CSC_CC_WRAPUP_INTERACTION_DEFAULTS') into l_wrap_id from dual;
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:

Line 182: Fnd_Message.SET_NAME('CS','Outcome, result, reason codes could not be found');

178: select outcome_id, result_id, reason_id into l_outcome_id, l_result_id, l_reason_id from jtf_ih_wrap_ups_vl where wrap_id = l_wrap_id;
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;

Line 196: Fnd_Message.SET_NAME('CS','Action Id could not be found for SR Update action');

192: AND rownum < 2;
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:

Line 249: Fnd_Message.SET_NAME('CS','ActionItemId not found for "Service Request" module');

245: select action_item_id into l_activity_rec.action_item_id from jtf_ih_action_items_tl where short_description = SR_MODULE;
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

Line 269: Fnd_Message.SET_NAME('CS','Error while creating Activity record');

265: l_activity_id );
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

Line 362: Fnd_Message.SET_NAME('CS','No Media Id found for corresponding Interaction Id:' || p_interaction_id);

358: exception
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);

Line 368: Fnd_Message.SET_NAME('CS','EndInteraction :: Error while retrieving media Id for Interaction Id:' || p_interaction_id);

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;
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:

Line 389: Fnd_Message.SET_NAME('CS','No Action Id found for corresponding Action:' || l_action_value);

385: exception
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);

Line 395: Fnd_Message.SET_NAME('CS','EndInteraction :: Error while retrieving action Id for Action:' || l_action_value);

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;
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);

Line 406: Fnd_Message.SET_NAME('CS','ActionItemId not found for "Service Request" module');

402: select action_item_id into l_activity_rec.action_item_id from jtf_ih_action_items_tl where short_description = SR_MODULE;
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;

Line 450: Fnd_Message.SET_NAME('CS','No resource Id found for User:' || p_user_id);

446: exception
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);

Line 463: Fnd_Message.SET_NAME('CS','Profile "CSC_CC_WRAPUP_INTERACTION_DEFAULTS" could not be found');

459: exception
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:

Line 476: Fnd_Message.SET_NAME('CS','Outcome, result, reason codes could not be found');

472: exception
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);