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);
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);
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);
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);
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);
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:
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
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';
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;
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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:
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
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';
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;
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(
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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:
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
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)
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
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;
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;
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
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:
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:
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;
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:
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
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
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;
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;
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:
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;
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: -------------------------------------------------------------------------
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;
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: -------------------------------------------------------------------------
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);
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);
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
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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:
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
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 (
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,
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;
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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:
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
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:
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 (
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
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: -------------------------------------------------------------------------
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');
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
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
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:
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';
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:
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',
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;
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;
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
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;
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;
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:
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;
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
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:
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
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
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
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
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
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;
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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:
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
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:
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 (
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
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: );
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: -------------------------------------------------------------------------
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');
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,
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: