APPS.JTF_EC_PUB dependencies on JTF_EC_UTIL

Line 59: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note);

55:
56: -------------------------------------------------------------------------------------------
57: -- Convert the missing fields to NULLs
58: -------------------------------------------------------------------------------------------
59: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note);
60: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_detail);
61: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_type);
62: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_01);
63: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_01);

Line 60: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_detail);

56: -------------------------------------------------------------------------------------------
57: -- Convert the missing fields to NULLs
58: -------------------------------------------------------------------------------------------
59: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note);
60: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_detail);
61: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_type);
62: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_01);
63: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_01);
64: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_02);

Line 61: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_type);

57: -- Convert the missing fields to NULLs
58: -------------------------------------------------------------------------------------------
59: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note);
60: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_detail);
61: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_type);
62: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_01);
63: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_01);
64: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_02);
65: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_02);

Line 62: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_01);

58: -------------------------------------------------------------------------------------------
59: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note);
60: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_detail);
61: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_type);
62: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_01);
63: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_01);
64: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_02);
65: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_02);
66: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_03);

Line 63: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_01);

59: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note);
60: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_detail);
61: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_type);
62: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_01);
63: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_01);
64: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_02);
65: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_02);
66: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_03);
67: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_03);

Line 64: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_02);

60: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_detail);
61: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_type);
62: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_01);
63: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_01);
64: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_02);
65: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_02);
66: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_03);
67: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_03);
68:

Line 65: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_02);

61: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_type);
62: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_01);
63: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_01);
64: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_02);
65: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_02);
66: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_03);
67: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_03);
68:
69: if l_notes_rec.note_status = fnd_api.g_miss_char then

Line 66: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_03);

62: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_01);
63: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_01);
64: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_02);
65: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_02);
66: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_03);
67: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_03);
68:
69: if l_notes_rec.note_status = fnd_api.g_miss_char then
70: l_notes_rec.note_status := 'I';

Line 67: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_03);

63: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_01);
64: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_02);
65: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_02);
66: jtf_ec_util.Conv_Miss_Char(l_notes_rec.note_context_type_03);
67: jtf_ec_util.Conv_Miss_Num(l_notes_rec.note_context_type_id_03);
68:
69: if l_notes_rec.note_status = fnd_api.g_miss_char then
70: l_notes_rec.note_status := 'I';
71: end if;

Line 250: jtf_ec_util.Conv_Miss_Num(l_esc_contacts.contact_id);

246:
247: -------------------------------------------------------------------------------------------
248: -- Convert the missing fields to NULLs
249: -------------------------------------------------------------------------------------------
250: jtf_ec_util.Conv_Miss_Num(l_esc_contacts.contact_id);
251: -- jtf_ec_util.Conv_Miss_Num(l_esc_contacts.task_contact_id);
252: -- jtf_ec_util.Conv_Miss_Num(l_esc_contacts.object_version_number);
253: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.contact_type_code);
254: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_requester_flag);

Line 251: -- jtf_ec_util.Conv_Miss_Num(l_esc_contacts.task_contact_id);

247: -------------------------------------------------------------------------------------------
248: -- Convert the missing fields to NULLs
249: -------------------------------------------------------------------------------------------
250: jtf_ec_util.Conv_Miss_Num(l_esc_contacts.contact_id);
251: -- jtf_ec_util.Conv_Miss_Num(l_esc_contacts.task_contact_id);
252: -- jtf_ec_util.Conv_Miss_Num(l_esc_contacts.object_version_number);
253: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.contact_type_code);
254: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_requester_flag);
255: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_notify_flag);

Line 252: -- jtf_ec_util.Conv_Miss_Num(l_esc_contacts.object_version_number);

248: -- Convert the missing fields to NULLs
249: -------------------------------------------------------------------------------------------
250: jtf_ec_util.Conv_Miss_Num(l_esc_contacts.contact_id);
251: -- jtf_ec_util.Conv_Miss_Num(l_esc_contacts.task_contact_id);
252: -- jtf_ec_util.Conv_Miss_Num(l_esc_contacts.object_version_number);
253: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.contact_type_code);
254: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_requester_flag);
255: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_notify_flag);
256: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute1);

Line 253: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.contact_type_code);

249: -------------------------------------------------------------------------------------------
250: jtf_ec_util.Conv_Miss_Num(l_esc_contacts.contact_id);
251: -- jtf_ec_util.Conv_Miss_Num(l_esc_contacts.task_contact_id);
252: -- jtf_ec_util.Conv_Miss_Num(l_esc_contacts.object_version_number);
253: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.contact_type_code);
254: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_requester_flag);
255: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_notify_flag);
256: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute1);
257: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute2);

Line 254: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_requester_flag);

250: jtf_ec_util.Conv_Miss_Num(l_esc_contacts.contact_id);
251: -- jtf_ec_util.Conv_Miss_Num(l_esc_contacts.task_contact_id);
252: -- jtf_ec_util.Conv_Miss_Num(l_esc_contacts.object_version_number);
253: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.contact_type_code);
254: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_requester_flag);
255: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_notify_flag);
256: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute1);
257: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute2);
258: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute3);

Line 255: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_notify_flag);

251: -- jtf_ec_util.Conv_Miss_Num(l_esc_contacts.task_contact_id);
252: -- jtf_ec_util.Conv_Miss_Num(l_esc_contacts.object_version_number);
253: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.contact_type_code);
254: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_requester_flag);
255: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_notify_flag);
256: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute1);
257: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute2);
258: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute3);
259: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute4);

Line 256: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute1);

252: -- jtf_ec_util.Conv_Miss_Num(l_esc_contacts.object_version_number);
253: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.contact_type_code);
254: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_requester_flag);
255: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_notify_flag);
256: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute1);
257: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute2);
258: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute3);
259: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute4);
260: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute5);

Line 257: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute2);

253: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.contact_type_code);
254: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_requester_flag);
255: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_notify_flag);
256: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute1);
257: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute2);
258: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute3);
259: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute4);
260: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute5);
261: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute6);

Line 258: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute3);

254: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_requester_flag);
255: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_notify_flag);
256: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute1);
257: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute2);
258: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute3);
259: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute4);
260: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute5);
261: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute6);
262: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute7);

Line 259: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute4);

255: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.escalation_notify_flag);
256: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute1);
257: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute2);
258: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute3);
259: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute4);
260: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute5);
261: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute6);
262: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute7);
263: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute8);

Line 260: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute5);

256: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute1);
257: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute2);
258: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute3);
259: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute4);
260: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute5);
261: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute6);
262: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute7);
263: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute8);
264: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute9);

Line 261: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute6);

257: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute2);
258: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute3);
259: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute4);
260: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute5);
261: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute6);
262: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute7);
263: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute8);
264: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute9);
265: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute10);

Line 262: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute7);

258: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute3);
259: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute4);
260: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute5);
261: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute6);
262: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute7);
263: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute8);
264: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute9);
265: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute10);
266: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute11);

Line 263: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute8);

259: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute4);
260: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute5);
261: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute6);
262: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute7);
263: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute8);
264: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute9);
265: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute10);
266: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute11);
267: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute12);

Line 264: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute9);

260: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute5);
261: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute6);
262: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute7);
263: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute8);
264: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute9);
265: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute10);
266: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute11);
267: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute12);
268: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute13);

Line 265: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute10);

261: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute6);
262: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute7);
263: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute8);
264: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute9);
265: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute10);
266: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute11);
267: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute12);
268: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute13);
269: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute14);

Line 266: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute11);

262: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute7);
263: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute8);
264: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute9);
265: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute10);
266: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute11);
267: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute12);
268: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute13);
269: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute14);
270: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute15);

Line 267: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute12);

263: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute8);
264: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute9);
265: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute10);
266: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute11);
267: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute12);
268: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute13);
269: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute14);
270: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute15);
271: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute_category);

Line 268: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute13);

264: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute9);
265: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute10);
266: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute11);
267: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute12);
268: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute13);
269: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute14);
270: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute15);
271: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute_category);
272:

Line 269: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute14);

265: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute10);
266: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute11);
267: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute12);
268: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute13);
269: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute14);
270: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute15);
271: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute_category);
272:
273: if l_esc_contacts.escalation_notify_flag is NULL then

Line 270: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute15);

266: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute11);
267: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute12);
268: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute13);
269: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute14);
270: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute15);
271: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute_category);
272:
273: if l_esc_contacts.escalation_notify_flag is NULL then
274: l_esc_contacts.escalation_notify_flag := 'N';

Line 271: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute_category);

267: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute12);
268: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute13);
269: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute14);
270: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute15);
271: jtf_ec_util.Conv_Miss_Char(l_esc_contacts.attribute_category);
272:
273: if l_esc_contacts.escalation_notify_flag is NULL then
274: l_esc_contacts.escalation_notify_flag := 'N';
275: end if;

Line 283: if jtf_ec_util.Contact_Duplicated(l_esc_contacts.contact_id,

279: end if;
280:
281: -- check whether this is a duplicate contact. Skip it if it is.
282:
283: if jtf_ec_util.Contact_Duplicated(l_esc_contacts.contact_id,
284: l_esc_contacts.contact_type_code,
285: l_escalation_id) = FALSE then
286:
287: JTF_EC_CONTACTS_PVT.CREATE_ESCALATION_CONTACTS(

Line 400: jtf_ec_util.Conv_Miss_Char(l_reference_documents.object_type_code);

396: x_return_status := FND_API.G_RET_STS_SUCCESS;
397:
398: l_return_status := 'x';
399:
400: jtf_ec_util.Conv_Miss_Char(l_reference_documents.object_type_code);
401: jtf_ec_util.Conv_Miss_Char(l_reference_documents.object_name);
402: jtf_ec_util.Conv_Miss_Num(l_reference_documents.object_id);
403: jtf_ec_util.Conv_Miss_Char(l_reference_documents.reference_code);
404: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute1);

Line 401: jtf_ec_util.Conv_Miss_Char(l_reference_documents.object_name);

397:
398: l_return_status := 'x';
399:
400: jtf_ec_util.Conv_Miss_Char(l_reference_documents.object_type_code);
401: jtf_ec_util.Conv_Miss_Char(l_reference_documents.object_name);
402: jtf_ec_util.Conv_Miss_Num(l_reference_documents.object_id);
403: jtf_ec_util.Conv_Miss_Char(l_reference_documents.reference_code);
404: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute1);
405: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute2);

Line 402: jtf_ec_util.Conv_Miss_Num(l_reference_documents.object_id);

398: l_return_status := 'x';
399:
400: jtf_ec_util.Conv_Miss_Char(l_reference_documents.object_type_code);
401: jtf_ec_util.Conv_Miss_Char(l_reference_documents.object_name);
402: jtf_ec_util.Conv_Miss_Num(l_reference_documents.object_id);
403: jtf_ec_util.Conv_Miss_Char(l_reference_documents.reference_code);
404: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute1);
405: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute2);
406: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute3);

Line 403: jtf_ec_util.Conv_Miss_Char(l_reference_documents.reference_code);

399:
400: jtf_ec_util.Conv_Miss_Char(l_reference_documents.object_type_code);
401: jtf_ec_util.Conv_Miss_Char(l_reference_documents.object_name);
402: jtf_ec_util.Conv_Miss_Num(l_reference_documents.object_id);
403: jtf_ec_util.Conv_Miss_Char(l_reference_documents.reference_code);
404: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute1);
405: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute2);
406: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute3);
407: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute4);

Line 404: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute1);

400: jtf_ec_util.Conv_Miss_Char(l_reference_documents.object_type_code);
401: jtf_ec_util.Conv_Miss_Char(l_reference_documents.object_name);
402: jtf_ec_util.Conv_Miss_Num(l_reference_documents.object_id);
403: jtf_ec_util.Conv_Miss_Char(l_reference_documents.reference_code);
404: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute1);
405: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute2);
406: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute3);
407: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute4);
408: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute5);

Line 405: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute2);

401: jtf_ec_util.Conv_Miss_Char(l_reference_documents.object_name);
402: jtf_ec_util.Conv_Miss_Num(l_reference_documents.object_id);
403: jtf_ec_util.Conv_Miss_Char(l_reference_documents.reference_code);
404: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute1);
405: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute2);
406: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute3);
407: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute4);
408: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute5);
409: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute6);

Line 406: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute3);

402: jtf_ec_util.Conv_Miss_Num(l_reference_documents.object_id);
403: jtf_ec_util.Conv_Miss_Char(l_reference_documents.reference_code);
404: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute1);
405: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute2);
406: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute3);
407: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute4);
408: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute5);
409: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute6);
410: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute7);

Line 407: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute4);

403: jtf_ec_util.Conv_Miss_Char(l_reference_documents.reference_code);
404: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute1);
405: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute2);
406: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute3);
407: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute4);
408: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute5);
409: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute6);
410: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute7);
411: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute8);

Line 408: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute5);

404: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute1);
405: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute2);
406: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute3);
407: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute4);
408: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute5);
409: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute6);
410: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute7);
411: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute8);
412: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute9);

Line 409: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute6);

405: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute2);
406: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute3);
407: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute4);
408: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute5);
409: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute6);
410: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute7);
411: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute8);
412: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute9);
413: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute10);

Line 410: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute7);

406: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute3);
407: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute4);
408: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute5);
409: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute6);
410: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute7);
411: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute8);
412: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute9);
413: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute10);
414: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute11);

Line 411: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute8);

407: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute4);
408: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute5);
409: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute6);
410: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute7);
411: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute8);
412: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute9);
413: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute10);
414: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute11);
415: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute12);

Line 412: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute9);

408: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute5);
409: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute6);
410: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute7);
411: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute8);
412: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute9);
413: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute10);
414: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute11);
415: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute12);
416: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute13);

Line 413: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute10);

409: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute6);
410: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute7);
411: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute8);
412: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute9);
413: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute10);
414: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute11);
415: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute12);
416: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute13);
417: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute14);

Line 414: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute11);

410: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute7);
411: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute8);
412: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute9);
413: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute10);
414: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute11);
415: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute12);
416: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute13);
417: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute14);
418: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute15);

Line 415: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute12);

411: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute8);
412: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute9);
413: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute10);
414: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute11);
415: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute12);
416: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute13);
417: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute14);
418: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute15);
419: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute_category);

Line 416: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute13);

412: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute9);
413: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute10);
414: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute11);
415: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute12);
416: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute13);
417: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute14);
418: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute15);
419: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute_category);
420:

Line 417: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute14);

413: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute10);
414: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute11);
415: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute12);
416: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute13);
417: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute14);
418: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute15);
419: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute_category);
420:
421: if (l_reference_documents.object_id is not NULL or

Line 418: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute15);

414: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute11);
415: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute12);
416: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute13);
417: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute14);
418: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute15);
419: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute_category);
420:
421: if (l_reference_documents.object_id is not NULL or
422: l_reference_documents.object_name is not NULL)

Line 419: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute_category);

415: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute12);
416: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute13);
417: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute14);
418: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute15);
419: jtf_ec_util.Conv_Miss_Char(l_reference_documents.attribute_category);
420:
421: if (l_reference_documents.object_id is not NULL or
422: l_reference_documents.object_name is not NULL)
423: and l_reference_documents.object_type_code is not NULL

Line 425: if jtf_ec_util.Validate_Lookup('JTF_TASK_REFERENCE_CODES',

421: if (l_reference_documents.object_id is not NULL or
422: l_reference_documents.object_name is not NULL)
423: and l_reference_documents.object_type_code is not NULL
424: then
425: if jtf_ec_util.Validate_Lookup('JTF_TASK_REFERENCE_CODES',
426: l_reference_documents.reference_code) = FALSE
427: then
428: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_reference_documents.reference_code, 'reference_code');
429: raise fnd_api.g_exc_error;

Line 428: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_reference_documents.reference_code, 'reference_code');

424: then
425: if jtf_ec_util.Validate_Lookup('JTF_TASK_REFERENCE_CODES',
426: l_reference_documents.reference_code) = FALSE
427: then
428: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_reference_documents.reference_code, 'reference_code');
429: raise fnd_api.g_exc_error;
430: end if;
431:
432: -- check whether the same document is passed twice. If yes - skip it;

Line 434: if jtf_ec_util.Reference_Duplicated(l_reference_documents.object_type_code,

430: end if;
431:
432: -- check whether the same document is passed twice. If yes - skip it;
433:
434: if jtf_ec_util.Reference_Duplicated(l_reference_documents.object_type_code,
435: l_reference_documents.object_id,
436: l_reference_documents.object_name,
437: l_reference_documents.reference_code,
438: l_escalation_id) = FALSE then

Line 442: if jtf_ec_util.check_if_escalated(l_reference_documents.object_type_code,

438: l_escalation_id) = FALSE then
439:
440: if l_reference_documents.reference_code = 'ESC' then
441:
442: if jtf_ec_util.check_if_escalated(l_reference_documents.object_type_code,
443: l_reference_documents.object_id,
444: l_reference_documents.object_name,
445: l_task_ref_id) = TRUE then
446:

Line 498: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'object_id');

494: else
495:
496: -- in case the object_id/name or object_code are not passed
497:
498: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'object_id');
499: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'object_name');
500: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'object_type_code');
501: raise fnd_api.g_exc_error;
502:

Line 499: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'object_name');

495:
496: -- in case the object_id/name or object_code are not passed
497:
498: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'object_id');
499: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'object_name');
500: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'object_type_code');
501: raise fnd_api.g_exc_error;
502:
503: end if;

Line 500: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'object_type_code');

496: -- in case the object_id/name or object_code are not passed
497:
498: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'object_id');
499: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'object_name');
500: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'object_type_code');
501: raise fnd_api.g_exc_error;
502:
503: end if;
504:

Line 675: jtf_ec_util.Validate_Who_Info( l_api_name, l_user_id,

671: -- validate p_user
672: -------------------------------------------------------------------------
673:
674: if l_user_id is NOT NULL then
675: jtf_ec_util.Validate_Who_Info( l_api_name, l_user_id,
676: l_login_id, l_return_status);
677: if (l_return_status = fnd_api.g_ret_sts_error) then
678: raise fnd_api.g_exc_error;
679: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then

Line 683: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL' ,'user_id');

679: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
680: raise fnd_api.g_exc_unexpected_error;
681: end if;
682: else
683: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL' ,'user_id');
684: raise fnd_api.g_exc_error;
685: end if;
686:
687: if l_esc_record.esc_name is NULL or l_esc_record.esc_name = fnd_api.g_miss_char then

Line 708: --jtf_ec_util.validate_owner(l_esc_record.esc_owner_id, g_escalation_owner_type_code, l_return_status);

704: l_user_id, l_resp_id, l_resp_appl_id);
705: end if;
706:
707: --Bug 2723761
708: --jtf_ec_util.validate_owner(l_esc_record.esc_owner_id, g_escalation_owner_type_code, l_return_status);
709: if l_esc_record.esc_owner_type_code is NULL OR
710: l_esc_record.esc_owner_type_code = fnd_api.g_miss_char then
711: l_esc_record.esc_owner_type_code := g_escalation_owner_type_code;
712: end if;

Line 714: jtf_ec_util.validate_owner( l_esc_record.esc_owner_id,

710: l_esc_record.esc_owner_type_code = fnd_api.g_miss_char then
711: l_esc_record.esc_owner_type_code := g_escalation_owner_type_code;
712: end if;
713:
714: jtf_ec_util.validate_owner( l_esc_record.esc_owner_id,
715: l_esc_record.esc_owner_type_code,
716: l_return_status);
717: if l_return_status <> fnd_api.g_ret_sts_success then
718: raise fnd_api.g_exc_error;

Line 735: jtf_ec_util.Validate_Esc_Status(p_esc_status_id => l_esc_record.status_id,

731: end if;
732:
733: l_return_status := 'x';
734:
735: jtf_ec_util.Validate_Esc_Status(p_esc_status_id => l_esc_record.status_id,
736: p_esc_status_name => l_esc_record.status_name,
737: x_return_status => l_return_status,
738: x_esc_status_id => l_esc_status_id);
739:

Line 757: if jtf_ec_util.Validate_Lookup('JTF_TASK_REASON_CODES',

753: l_resp_id,
754: l_resp_appl_id);
755: end if;
756:
757: if jtf_ec_util.Validate_Lookup('JTF_TASK_REASON_CODES',
758: l_esc_record.reason_code) = FALSE
759: then
760: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_esc_record.reason_code, 'reason_code');
761: raise fnd_api.g_exc_error;

Line 760: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_esc_record.reason_code, 'reason_code');

756:
757: if jtf_ec_util.Validate_Lookup('JTF_TASK_REASON_CODES',
758: l_esc_record.reason_code) = FALSE
759: then
760: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_esc_record.reason_code, 'reason_code');
761: raise fnd_api.g_exc_error;
762: end if;
763:
764: -------------------------------------------------------------------------

Line 776: if jtf_ec_util.Validate_Lookup('JTF_TASK_ESC_LEVEL',

772: l_user_id, l_resp_id,
773: l_resp_appl_id);
774: end if;
775:
776: if jtf_ec_util.Validate_Lookup('JTF_TASK_ESC_LEVEL',
777: l_esc_record.escalation_level ) = FALSE
778: then
779: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_esc_record.escalation_level, 'escalation_level');
780: raise fnd_api.g_exc_error;

Line 779: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_esc_record.escalation_level, 'escalation_level');

775:
776: if jtf_ec_util.Validate_Lookup('JTF_TASK_ESC_LEVEL',
777: l_esc_record.escalation_level ) = FALSE
778: then
779: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_esc_record.escalation_level, 'escalation_level');
780: raise fnd_api.g_exc_error;
781: end if;
782:
783: -------------------------------------------------------------------------

Line 791: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_name);

787: -------------------------------------------------------------------------
788: -- convert the missing fields to NULL
789: -------------------------------------------------------------------------
790:
791: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_name);
792: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_description);
793: jtf_ec_util.Conv_Miss_Char(l_esc_record.status_name);
794: jtf_ec_util.Conv_Miss_Num(l_esc_record.status_id);
795: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_open_date);

Line 792: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_description);

788: -- convert the missing fields to NULL
789: -------------------------------------------------------------------------
790:
791: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_name);
792: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_description);
793: jtf_ec_util.Conv_Miss_Char(l_esc_record.status_name);
794: jtf_ec_util.Conv_Miss_Num(l_esc_record.status_id);
795: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_open_date);
796: jtf_ec_util.Conv_Miss_Num(l_esc_record.esc_owner_id);

Line 793: jtf_ec_util.Conv_Miss_Char(l_esc_record.status_name);

789: -------------------------------------------------------------------------
790:
791: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_name);
792: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_description);
793: jtf_ec_util.Conv_Miss_Char(l_esc_record.status_name);
794: jtf_ec_util.Conv_Miss_Num(l_esc_record.status_id);
795: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_open_date);
796: jtf_ec_util.Conv_Miss_Num(l_esc_record.esc_owner_id);
797: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_owner_type_code); --bug 2723761

Line 794: jtf_ec_util.Conv_Miss_Num(l_esc_record.status_id);

790:
791: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_name);
792: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_description);
793: jtf_ec_util.Conv_Miss_Char(l_esc_record.status_name);
794: jtf_ec_util.Conv_Miss_Num(l_esc_record.status_id);
795: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_open_date);
796: jtf_ec_util.Conv_Miss_Num(l_esc_record.esc_owner_id);
797: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_owner_type_code); --bug 2723761
798: jtf_ec_util.Conv_Miss_Num(l_esc_record.customer_id);

Line 795: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_open_date);

791: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_name);
792: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_description);
793: jtf_ec_util.Conv_Miss_Char(l_esc_record.status_name);
794: jtf_ec_util.Conv_Miss_Num(l_esc_record.status_id);
795: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_open_date);
796: jtf_ec_util.Conv_Miss_Num(l_esc_record.esc_owner_id);
797: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_owner_type_code); --bug 2723761
798: jtf_ec_util.Conv_Miss_Num(l_esc_record.customer_id);
799: jtf_ec_util.Conv_Miss_Char(l_esc_record.customer_number);

Line 796: jtf_ec_util.Conv_Miss_Num(l_esc_record.esc_owner_id);

792: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_description);
793: jtf_ec_util.Conv_Miss_Char(l_esc_record.status_name);
794: jtf_ec_util.Conv_Miss_Num(l_esc_record.status_id);
795: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_open_date);
796: jtf_ec_util.Conv_Miss_Num(l_esc_record.esc_owner_id);
797: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_owner_type_code); --bug 2723761
798: jtf_ec_util.Conv_Miss_Num(l_esc_record.customer_id);
799: jtf_ec_util.Conv_Miss_Char(l_esc_record.customer_number);
800: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_account_id);

Line 797: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_owner_type_code); --bug 2723761

793: jtf_ec_util.Conv_Miss_Char(l_esc_record.status_name);
794: jtf_ec_util.Conv_Miss_Num(l_esc_record.status_id);
795: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_open_date);
796: jtf_ec_util.Conv_Miss_Num(l_esc_record.esc_owner_id);
797: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_owner_type_code); --bug 2723761
798: jtf_ec_util.Conv_Miss_Num(l_esc_record.customer_id);
799: jtf_ec_util.Conv_Miss_Char(l_esc_record.customer_number);
800: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_account_id);
801: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_account_number);

Line 798: jtf_ec_util.Conv_Miss_Num(l_esc_record.customer_id);

794: jtf_ec_util.Conv_Miss_Num(l_esc_record.status_id);
795: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_open_date);
796: jtf_ec_util.Conv_Miss_Num(l_esc_record.esc_owner_id);
797: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_owner_type_code); --bug 2723761
798: jtf_ec_util.Conv_Miss_Num(l_esc_record.customer_id);
799: jtf_ec_util.Conv_Miss_Char(l_esc_record.customer_number);
800: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_account_id);
801: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_account_number);
802: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_address_id);

Line 799: jtf_ec_util.Conv_Miss_Char(l_esc_record.customer_number);

795: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_open_date);
796: jtf_ec_util.Conv_Miss_Num(l_esc_record.esc_owner_id);
797: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_owner_type_code); --bug 2723761
798: jtf_ec_util.Conv_Miss_Num(l_esc_record.customer_id);
799: jtf_ec_util.Conv_Miss_Char(l_esc_record.customer_number);
800: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_account_id);
801: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_account_number);
802: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_address_id);
803: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_address_number);

Line 800: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_account_id);

796: jtf_ec_util.Conv_Miss_Num(l_esc_record.esc_owner_id);
797: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_owner_type_code); --bug 2723761
798: jtf_ec_util.Conv_Miss_Num(l_esc_record.customer_id);
799: jtf_ec_util.Conv_Miss_Char(l_esc_record.customer_number);
800: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_account_id);
801: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_account_number);
802: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_address_id);
803: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_address_number);
804: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_target_date);

Line 801: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_account_number);

797: jtf_ec_util.Conv_Miss_Char(l_esc_record.esc_owner_type_code); --bug 2723761
798: jtf_ec_util.Conv_Miss_Num(l_esc_record.customer_id);
799: jtf_ec_util.Conv_Miss_Char(l_esc_record.customer_number);
800: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_account_id);
801: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_account_number);
802: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_address_id);
803: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_address_number);
804: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_target_date);
805: jtf_ec_util.Conv_Miss_Char(l_esc_record.reason_code);

Line 802: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_address_id);

798: jtf_ec_util.Conv_Miss_Num(l_esc_record.customer_id);
799: jtf_ec_util.Conv_Miss_Char(l_esc_record.customer_number);
800: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_account_id);
801: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_account_number);
802: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_address_id);
803: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_address_number);
804: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_target_date);
805: jtf_ec_util.Conv_Miss_Char(l_esc_record.reason_code);
806: jtf_ec_util.Conv_Miss_Char(l_esc_record.escalation_level);

Line 803: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_address_number);

799: jtf_ec_util.Conv_Miss_Char(l_esc_record.customer_number);
800: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_account_id);
801: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_account_number);
802: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_address_id);
803: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_address_number);
804: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_target_date);
805: jtf_ec_util.Conv_Miss_Char(l_esc_record.reason_code);
806: jtf_ec_util.Conv_Miss_Char(l_esc_record.escalation_level);
807: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute1);

Line 804: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_target_date);

800: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_account_id);
801: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_account_number);
802: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_address_id);
803: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_address_number);
804: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_target_date);
805: jtf_ec_util.Conv_Miss_Char(l_esc_record.reason_code);
806: jtf_ec_util.Conv_Miss_Char(l_esc_record.escalation_level);
807: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute1);
808: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute2);

Line 805: jtf_ec_util.Conv_Miss_Char(l_esc_record.reason_code);

801: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_account_number);
802: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_address_id);
803: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_address_number);
804: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_target_date);
805: jtf_ec_util.Conv_Miss_Char(l_esc_record.reason_code);
806: jtf_ec_util.Conv_Miss_Char(l_esc_record.escalation_level);
807: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute1);
808: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute2);
809: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute3);

Line 806: jtf_ec_util.Conv_Miss_Char(l_esc_record.escalation_level);

802: jtf_ec_util.Conv_Miss_Num(l_esc_record.cust_address_id);
803: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_address_number);
804: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_target_date);
805: jtf_ec_util.Conv_Miss_Char(l_esc_record.reason_code);
806: jtf_ec_util.Conv_Miss_Char(l_esc_record.escalation_level);
807: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute1);
808: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute2);
809: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute3);
810: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute4);

Line 807: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute1);

803: jtf_ec_util.Conv_Miss_Char(l_esc_record.cust_address_number);
804: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_target_date);
805: jtf_ec_util.Conv_Miss_Char(l_esc_record.reason_code);
806: jtf_ec_util.Conv_Miss_Char(l_esc_record.escalation_level);
807: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute1);
808: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute2);
809: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute3);
810: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute4);
811: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute5);

Line 808: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute2);

804: jtf_ec_util.Conv_Miss_Date(l_esc_record.esc_target_date);
805: jtf_ec_util.Conv_Miss_Char(l_esc_record.reason_code);
806: jtf_ec_util.Conv_Miss_Char(l_esc_record.escalation_level);
807: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute1);
808: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute2);
809: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute3);
810: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute4);
811: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute5);
812: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute6);

Line 809: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute3);

805: jtf_ec_util.Conv_Miss_Char(l_esc_record.reason_code);
806: jtf_ec_util.Conv_Miss_Char(l_esc_record.escalation_level);
807: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute1);
808: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute2);
809: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute3);
810: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute4);
811: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute5);
812: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute6);
813: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute7);

Line 810: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute4);

806: jtf_ec_util.Conv_Miss_Char(l_esc_record.escalation_level);
807: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute1);
808: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute2);
809: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute3);
810: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute4);
811: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute5);
812: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute6);
813: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute7);
814: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute8);

Line 811: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute5);

807: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute1);
808: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute2);
809: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute3);
810: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute4);
811: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute5);
812: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute6);
813: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute7);
814: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute8);
815: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute9);

Line 812: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute6);

808: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute2);
809: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute3);
810: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute4);
811: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute5);
812: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute6);
813: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute7);
814: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute8);
815: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute9);
816: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute10);

Line 813: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute7);

809: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute3);
810: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute4);
811: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute5);
812: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute6);
813: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute7);
814: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute8);
815: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute9);
816: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute10);
817: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute11);

Line 814: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute8);

810: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute4);
811: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute5);
812: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute6);
813: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute7);
814: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute8);
815: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute9);
816: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute10);
817: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute11);
818: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute12);

Line 815: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute9);

811: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute5);
812: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute6);
813: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute7);
814: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute8);
815: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute9);
816: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute10);
817: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute11);
818: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute12);
819: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute13);

Line 816: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute10);

812: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute6);
813: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute7);
814: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute8);
815: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute9);
816: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute10);
817: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute11);
818: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute12);
819: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute13);
820: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute14);

Line 817: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute11);

813: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute7);
814: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute8);
815: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute9);
816: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute10);
817: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute11);
818: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute12);
819: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute13);
820: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute14);
821: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute15);

Line 818: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute12);

814: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute8);
815: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute9);
816: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute10);
817: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute11);
818: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute12);
819: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute13);
820: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute14);
821: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute15);
822: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute_category);

Line 819: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute13);

815: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute9);
816: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute10);
817: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute11);
818: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute12);
819: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute13);
820: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute14);
821: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute15);
822: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute_category);
823:

Line 820: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute14);

816: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute10);
817: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute11);
818: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute12);
819: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute13);
820: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute14);
821: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute15);
822: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute_category);
823:
824: -- Bug 2650521

Line 821: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute15);

817: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute11);
818: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute12);
819: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute13);
820: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute14);
821: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute15);
822: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute_category);
823:
824: -- Bug 2650521
825: JTF_EC_PVT.CREATE_ESCALATION (

Line 822: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute_category);

818: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute12);
819: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute13);
820: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute14);
821: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute15);
822: jtf_ec_util.Conv_Miss_Char(l_esc_record.attribute_category);
823:
824: -- Bug 2650521
825: JTF_EC_PVT.CREATE_ESCALATION (
826: P_API_VERSION => l_api_version,

Line 922: jtf_ec_util.Validate_Requester(l_escalation_id, l_return_status);

918: -------------------------------------------------------------------------
919:
920: l_return_status := 'x';
921:
922: jtf_ec_util.Validate_Requester(l_escalation_id, l_return_status);
923:
924: if l_return_status <> fnd_api.g_ret_sts_success then
925: raise fnd_api.g_exc_error;
926: end if;

Line 940: jtf_ec_util.Validate_Contact_id(l_cont_points(j).contact_id,

936: l_return_status := 'x';
937:
938: -- check whether this is a valid contact for this escalation. Also get the task contact id.
939:
940: jtf_ec_util.Validate_Contact_id(l_cont_points(j).contact_id,
941: l_cont_points(j).contact_type_code,
942: l_escalation_id,
943: l_escalation_contact_id,
944: l_return_status);

Line 952: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute1);

948: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
949: raise fnd_api.g_exc_unexpected_error;
950: end if;
951:
952: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute1);
953: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute2);
954: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);
955: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
956: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);

Line 953: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute2);

949: raise fnd_api.g_exc_unexpected_error;
950: end if;
951:
952: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute1);
953: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute2);
954: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);
955: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
956: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
957: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);

Line 954: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);

950: end if;
951:
952: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute1);
953: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute2);
954: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);
955: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
956: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
957: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
958: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);

Line 955: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);

951:
952: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute1);
953: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute2);
954: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);
955: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
956: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
957: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
958: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
959: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);

Line 956: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);

952: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute1);
953: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute2);
954: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);
955: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
956: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
957: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
958: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
959: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
960: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);

Line 957: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);

953: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute2);
954: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);
955: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
956: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
957: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
958: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
959: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
960: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
961: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);

Line 958: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);

954: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);
955: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
956: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
957: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
958: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
959: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
960: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
961: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
962: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);

Line 959: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);

955: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
956: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
957: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
958: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
959: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
960: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
961: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
962: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
963: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);

Line 960: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);

956: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
957: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
958: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
959: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
960: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
961: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
962: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
963: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
964: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);

Line 961: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);

957: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
958: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
959: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
960: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
961: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
962: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
963: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
964: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);
965: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);

Line 962: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);

958: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
959: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
960: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
961: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
962: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
963: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
964: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);
965: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);
966: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute15);

Line 963: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);

959: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
960: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
961: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
962: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
963: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
964: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);
965: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);
966: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute15);
967: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute_category);

Line 964: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);

960: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
961: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
962: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
963: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
964: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);
965: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);
966: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute15);
967: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute_category);
968:

Line 965: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);

961: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
962: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
963: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
964: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);
965: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);
966: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute15);
967: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute_category);
968:
969: -- insert the phone_id (contact_point) for this contact

Line 966: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute15);

962: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
963: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
964: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);
965: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);
966: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute15);
967: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute_category);
968:
969: -- insert the phone_id (contact_point) for this contact
970:

Line 967: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute_category);

963: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
964: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);
965: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);
966: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute15);
967: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute_category);
968:
969: -- insert the phone_id (contact_point) for this contact
970:
971: Jtf_Task_Phones_Pub.create_task_phones (

Line 1352: jtf_ec_util.Validate_Who_Info( l_api_name, l_user_id,

1348: -- validate p_user
1349: -------------------------------------------------------------------------
1350:
1351: if l_user_id is NOT NULL then
1352: jtf_ec_util.Validate_Who_Info( l_api_name, l_user_id,
1353: l_login_id, l_return_status);
1354: if (l_return_status = fnd_api.g_ret_sts_error) then
1355: raise fnd_api.g_exc_error;
1356: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then

Line 1360: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL' ,'user_id');

1356: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
1357: raise fnd_api.g_exc_unexpected_error;
1358: end if;
1359: else
1360: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL' ,'user_id');
1361: raise fnd_api.g_exc_error;
1362: end if;
1363:
1364: -------------------------------------------------------------------------

Line 1372: jtf_ec_util.add_param_ignored_msg(l_api_name, 'p_esc_number');

1368:
1369: if p_esc_id <> fnd_api.g_miss_num then
1370: l_escalation_id := p_esc_id;
1371: if p_esc_number <> fnd_api.g_miss_char then
1372: jtf_ec_util.add_param_ignored_msg(l_api_name, 'p_esc_number');
1373: end if;
1374: elsif p_esc_number <> fnd_api.g_miss_char then
1375: l_escalation_number := p_esc_number;
1376: else jtf_ec_util.add_missing_param_msg(l_api_name, 'p_esc_name');

Line 1376: else jtf_ec_util.add_missing_param_msg(l_api_name, 'p_esc_name');

1372: jtf_ec_util.add_param_ignored_msg(l_api_name, 'p_esc_number');
1373: end if;
1374: elsif p_esc_number <> fnd_api.g_miss_char then
1375: l_escalation_number := p_esc_number;
1376: else jtf_ec_util.add_missing_param_msg(l_api_name, 'p_esc_name');
1377: end if;
1378:
1379: jtf_ec_util.Validate_Esc_Document(l_escalation_id, l_escalation_number,
1380: l_esc_task_id, -- converted number to id

Line 1379: jtf_ec_util.Validate_Esc_Document(l_escalation_id, l_escalation_number,

1375: l_escalation_number := p_esc_number;
1376: else jtf_ec_util.add_missing_param_msg(l_api_name, 'p_esc_name');
1377: end if;
1378:
1379: jtf_ec_util.Validate_Esc_Document(l_escalation_id, l_escalation_number,
1380: l_esc_task_id, -- converted number to id
1381: l_return_status);
1382:
1383: if (l_return_status = fnd_api.g_ret_sts_error) then

Line 1403: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'status_id');

1399:
1400: if (l_esc_record.status_id is NULL)
1401: and (l_esc_record.status_name is NULL)
1402: then
1403: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'status_id');
1404: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'status_name');
1405: raise fnd_api.g_exc_error;
1406: end if;
1407:

Line 1404: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'status_name');

1400: if (l_esc_record.status_id is NULL)
1401: and (l_esc_record.status_name is NULL)
1402: then
1403: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'status_id');
1404: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'status_name');
1405: raise fnd_api.g_exc_error;
1406: end if;
1407:
1408: l_return_status := 'x';

Line 1413: jtf_ec_util.Validate_Esc_Status(p_esc_status_id => l_esc_record.status_id,

1409:
1410: if l_esc_record.status_id <> fnd_api.g_miss_num
1411: or l_esc_record.status_name <> fnd_api.g_miss_char then
1412:
1413: jtf_ec_util.Validate_Esc_Status(p_esc_status_id => l_esc_record.status_id,
1414: p_esc_status_name => l_esc_record.status_name,
1415: x_return_status => l_return_status,
1416: x_esc_status_id => l_esc_status_id);
1417:

Line 1429: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_esc_record.escalation_level, 'escalation_level');

1425: -- validate level. It is required parameter
1426: ----------------------------------------------------------------------------------------
1427:
1428: if l_esc_record.escalation_level is NULL then
1429: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_esc_record.escalation_level, 'escalation_level');
1430: raise fnd_api.g_exc_error;
1431: elsif l_esc_record.escalation_level <> fnd_api.g_miss_char then
1432:
1433: if jtf_ec_util.Validate_Lookup('JTF_TASK_ESC_LEVEL',

Line 1433: if jtf_ec_util.Validate_Lookup('JTF_TASK_ESC_LEVEL',

1429: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_esc_record.escalation_level, 'escalation_level');
1430: raise fnd_api.g_exc_error;
1431: elsif l_esc_record.escalation_level <> fnd_api.g_miss_char then
1432:
1433: if jtf_ec_util.Validate_Lookup('JTF_TASK_ESC_LEVEL',
1434: l_esc_record.escalation_level ) = FALSE
1435: then
1436: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_esc_record.escalation_level, 'escalation_level');
1437: raise fnd_api.g_exc_error;

Line 1436: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_esc_record.escalation_level, 'escalation_level');

1432:
1433: if jtf_ec_util.Validate_Lookup('JTF_TASK_ESC_LEVEL',
1434: l_esc_record.escalation_level ) = FALSE
1435: then
1436: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_esc_record.escalation_level, 'escalation_level');
1437: raise fnd_api.g_exc_error;
1438: end if;
1439:
1440: end if;

Line 1446: jtf_ec_util.Check_Completed_Status(l_esc_status_id, l_escalation_id,

1442: ----------------------------------------------------------------------------------------
1443: -- Set the close date to sysdate if it is not passed and the Status is updated to 'Closed'
1444: ----------------------------------------------------------------------------------------
1445:
1446: jtf_ec_util.Check_Completed_Status(l_esc_status_id, l_escalation_id,
1447: l_esc_record.escalation_level,
1448: l_closed_flag, l_return_status);
1449:
1450: if (l_return_status = fnd_api.g_ret_sts_error) then

Line 1467: jtf_ec_util.validate_owner( l_esc_record.esc_owner_id,

1463: l_esc_record.esc_owner_type_code = fnd_api.g_miss_char then
1464: l_esc_record.esc_owner_type_code := g_escalation_owner_type_code;
1465: end if;
1466:
1467: jtf_ec_util.validate_owner( l_esc_record.esc_owner_id,
1468: l_esc_record.esc_owner_type_code,
1469: l_return_status);
1470: if l_return_status <> fnd_api.g_ret_sts_success then
1471: raise fnd_api.g_exc_error;

Line 1481: if jtf_ec_util.Validate_Lookup('JTF_TASK_REASON_CODES',

1477: ----------------------------------------------------------------------------------------
1478:
1479: if (l_esc_record.reason_code <> fnd_api.g_miss_char)
1480: then
1481: if jtf_ec_util.Validate_Lookup('JTF_TASK_REASON_CODES',
1482: l_esc_record.reason_code) = FALSE
1483: then
1484: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_esc_record.reason_code, 'reason_code');
1485: raise fnd_api.g_exc_error;

Line 1484: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_esc_record.reason_code, 'reason_code');

1480: then
1481: if jtf_ec_util.Validate_Lookup('JTF_TASK_REASON_CODES',
1482: l_esc_record.reason_code) = FALSE
1483: then
1484: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, l_esc_record.reason_code, 'reason_code');
1485: raise fnd_api.g_exc_error;
1486: end if;
1487: end if;
1488:

Line 1606: jtf_ec_util.Validate_Task_Reference_Id( l_reference_documents(j).reference_id,

1602: l_return_status := 'x';
1603:
1604: -- validate the reference document against the escalation document id.
1605:
1606: jtf_ec_util.Validate_Task_Reference_Id( l_reference_documents(j).reference_id,
1607: l_escalation_id, l_return_status);
1608:
1609: if (l_return_status = fnd_api.g_ret_sts_error) then
1610: raise fnd_api.g_exc_error;

Line 1636: jtf_ec_util.Validate_Task_Reference_Id( l_reference_documents(j).reference_id,

1632: l_return_status := 'x';
1633:
1634: -- validate the reference document against the escalation document id.
1635:
1636: jtf_ec_util.Validate_Task_Reference_Id( l_reference_documents(j).reference_id,
1637: l_escalation_id,
1638: l_return_status);
1639:
1640: if (l_return_status = fnd_api.g_ret_sts_error) then

Line 1664: if jtf_ec_util.check_if_escalated( l_object_type_code,

1660: if l_reference_documents(j).object_name <> fnd_api.g_miss_char then
1661: l_object_name := l_reference_documents(j).object_name;
1662: end if;
1663:
1664: if jtf_ec_util.check_if_escalated( l_object_type_code,
1665: l_object_id,
1666: l_object_name,
1667: l_task_ref_id) = TRUE then
1668:

Line 1682: if jtf_ec_util.Reference_Duplicated(l_reference_documents(j).object_type_code,

1678: end if;
1679:
1680: end if;
1681:
1682: if jtf_ec_util.Reference_Duplicated(l_reference_documents(j).object_type_code,
1683: l_reference_documents(j).object_id,
1684: l_reference_documents(j).object_name,
1685: l_reference_documents(j).reference_code,
1686: l_escalation_id) = FALSE then

Line 1777: jtf_ec_util.validate_task_phone_id(l_cont_points(j).task_phone_id,

1773: -- validate the task_phone_id - must be for this escalation document
1774:
1775: l_return_status := 'x';
1776:
1777: jtf_ec_util.validate_task_phone_id(l_cont_points(j).task_phone_id,
1778: l_escalation_id,
1779: l_return_status);
1780:
1781: if (l_return_status = fnd_api.g_ret_sts_error) then

Line 1810: jtf_ec_util.validate_task_phone_id(l_cont_points(j).task_phone_id,

1806: l_return_status := 'x';
1807:
1808: -- validate the task_phone_id - must be for this escalation document
1809:
1810: jtf_ec_util.validate_task_phone_id(l_cont_points(j).task_phone_id,
1811: l_escalation_id,
1812: l_return_status);
1813:
1814: if (l_return_status = fnd_api.g_ret_sts_error) then

Line 1875: jtf_ec_util.Validate_Task_Contact_Id( l_esc_contacts(j).task_contact_id,

1871: l_return_status := 'x';
1872:
1873: -- validate the task_contact_id against the escalation_id
1874:
1875: jtf_ec_util.Validate_Task_Contact_Id( l_esc_contacts(j).task_contact_id,
1876: l_escalation_id,
1877: l_return_status);
1878:
1879: if (l_return_status = fnd_api.g_ret_sts_error) then

Line 1945: jtf_ec_util.Validate_Task_Contact_Id( l_esc_contacts(j).task_contact_id,

1941: end if;
1942:
1943: -- validate the task_contact_id against the escalation_id
1944:
1945: jtf_ec_util.Validate_Task_Contact_Id( l_esc_contacts(j).task_contact_id,
1946: l_escalation_id,
1947: l_return_status);
1948:
1949: if (l_return_status = fnd_api.g_ret_sts_error) then

Line 2021: jtf_ec_util.Validate_Requester(l_escalation_id,

2017: -------------------------------------------------------------------------------
2018:
2019: l_return_status := 'x';
2020:
2021: jtf_ec_util.Validate_Requester(l_escalation_id,
2022: l_return_status);
2023:
2024: if l_return_status <> fnd_api.g_ret_sts_success then
2025: raise fnd_api.g_exc_error;

Line 2041: jtf_ec_util.Validate_Contact_id(l_cont_points(j).contact_id,

2037: l_return_status := 'x';
2038:
2039: -- check whether this is a valid contact for this escalation. Also get the task contact id.
2040:
2041: jtf_ec_util.Validate_Contact_id(l_cont_points(j).contact_id,
2042: l_cont_points(j).contact_type_code,
2043: l_escalation_id,
2044: l_escalation_contact_id,
2045: l_return_status);

Line 2053: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute1);

2049: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
2050: raise fnd_api.g_exc_unexpected_error;
2051: end if;
2052:
2053: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute1);
2054: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute2);
2055: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);
2056: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
2057: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);

Line 2054: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute2);

2050: raise fnd_api.g_exc_unexpected_error;
2051: end if;
2052:
2053: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute1);
2054: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute2);
2055: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);
2056: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
2057: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
2058: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);

Line 2055: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);

2051: end if;
2052:
2053: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute1);
2054: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute2);
2055: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);
2056: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
2057: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
2058: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
2059: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);

Line 2056: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);

2052:
2053: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute1);
2054: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute2);
2055: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);
2056: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
2057: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
2058: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
2059: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
2060: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);

Line 2057: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);

2053: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute1);
2054: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute2);
2055: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);
2056: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
2057: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
2058: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
2059: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
2060: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
2061: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);

Line 2058: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);

2054: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute2);
2055: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);
2056: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
2057: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
2058: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
2059: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
2060: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
2061: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
2062: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);

Line 2059: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);

2055: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute3);
2056: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
2057: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
2058: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
2059: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
2060: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
2061: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
2062: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
2063: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);

Line 2060: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);

2056: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute4);
2057: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
2058: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
2059: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
2060: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
2061: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
2062: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
2063: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
2064: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);

Line 2061: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);

2057: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute5);
2058: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
2059: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
2060: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
2061: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
2062: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
2063: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
2064: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
2065: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);

Line 2062: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);

2058: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute6);
2059: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
2060: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
2061: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
2062: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
2063: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
2064: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
2065: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);
2066: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);

Line 2063: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);

2059: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute7);
2060: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
2061: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
2062: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
2063: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
2064: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
2065: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);
2066: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);
2067: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute15);

Line 2064: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);

2060: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute8);
2061: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
2062: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
2063: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
2064: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
2065: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);
2066: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);
2067: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute15);
2068: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute_category);

Line 2065: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);

2061: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute9);
2062: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
2063: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
2064: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
2065: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);
2066: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);
2067: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute15);
2068: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute_category);
2069:

Line 2066: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);

2062: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute10);
2063: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
2064: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
2065: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);
2066: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);
2067: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute15);
2068: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute_category);
2069:
2070: -- create a phone_id for this contact

Line 2067: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute15);

2063: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute11);
2064: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
2065: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);
2066: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);
2067: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute15);
2068: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute_category);
2069:
2070: -- create a phone_id for this contact
2071:

Line 2068: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute_category);

2064: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute12);
2065: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute13);
2066: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute14);
2067: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute15);
2068: jtf_ec_util.Conv_Miss_Char(l_cont_points(j).attribute_category);
2069:
2070: -- create a phone_id for this contact
2071:
2072: Jtf_Task_Phones_Pub.create_task_phones (

Line 2142: jtf_ec_util.Validate_Note_Id(l_notes(j).note_id,

2138: l_return_status := 'x';
2139:
2140: -- check whether the note belongs to this escalation document
2141:
2142: jtf_ec_util.Validate_Note_Id(l_notes(j).note_id,
2143: l_escalation_id,
2144: l_return_status);
2145:
2146: if (l_return_status = fnd_api.g_ret_sts_error) then

Line 2446: jtf_ec_util.Validate_Who_Info( l_api_name,

2442: -- validate p_user_id
2443: -------------------------------------------------------------------------
2444:
2445: if l_user_id is NOT NULL then
2446: jtf_ec_util.Validate_Who_Info( l_api_name,
2447: l_user_id,
2448: l_login_id,
2449: l_return_status
2450: );

Line 2457: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL' ,'user_id');

2453: elsif (l_return_status = fnd_api.g_ret_sts_unexp_error) then
2454: raise fnd_api.g_exc_unexpected_error;
2455: end if;
2456: else
2457: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL' ,'user_id');
2458: raise fnd_api.g_exc_error;
2459: end if;
2460:
2461: -------------------------------------------------------------------------

Line 2471: jtf_ec_util.add_param_ignored_msg(l_api_name, 'p_esc_number');

2467:
2468: if p_esc_id <> fnd_api.g_miss_num then
2469: l_escalation_id := p_esc_id;
2470: if p_esc_number <> fnd_api.g_miss_char then
2471: jtf_ec_util.add_param_ignored_msg(l_api_name, 'p_esc_number');
2472: end if;
2473: elsif p_esc_number <> fnd_api.g_miss_char then
2474: l_escalation_number := p_esc_number;
2475: else jtf_ec_util.add_missing_param_msg(l_api_name, 'p_esc_name');

Line 2475: else jtf_ec_util.add_missing_param_msg(l_api_name, 'p_esc_name');

2471: jtf_ec_util.add_param_ignored_msg(l_api_name, 'p_esc_number');
2472: end if;
2473: elsif p_esc_number <> fnd_api.g_miss_char then
2474: l_escalation_number := p_esc_number;
2475: else jtf_ec_util.add_missing_param_msg(l_api_name, 'p_esc_name');
2476: end if;
2477:
2478: jtf_ec_util.Validate_Esc_Document(l_escalation_id,
2479: l_escalation_number,

Line 2478: jtf_ec_util.Validate_Esc_Document(l_escalation_id,

2474: l_escalation_number := p_esc_number;
2475: else jtf_ec_util.add_missing_param_msg(l_api_name, 'p_esc_name');
2476: end if;
2477:
2478: jtf_ec_util.Validate_Esc_Document(l_escalation_id,
2479: l_escalation_number,
2480: l_esc_task_id, -- converted number to id
2481: l_return_status);
2482: