61: END IF;
62:
63: IF fnd_api.to_boolean (p_init_msg_list)
64: THEN
65: fnd_msg_pub.initialize;
66: END IF;
67:
68: -----
69: ----- Validate escaltion
83:
84: IF l_escalation_id IS NULL
85: THEN
86: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
87: fnd_msg_pub.add;
88: x_return_status := fnd_api.g_ret_sts_unexp_error;
89: RAISE fnd_api.g_exc_unexpected_error;
90: END IF;
91:
151: THEN
152: COMMIT WORK;
153: END IF;
154:
155: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
156:
157: --Created for BES enh 2660883
158: begin
159:
176: WHEN fnd_api.g_exc_unexpected_error
177: THEN
178: ROLLBACK TO create_references_pub;
179: x_return_status := fnd_api.g_ret_sts_unexp_error;
180: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
181: WHEN NO_DATA_FOUND
182: THEN
183: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
184: fnd_message.set_token ('P_OBJECT_TYPE_CODE', p_object_type_code);
182: THEN
183: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
184: fnd_message.set_token ('P_OBJECT_TYPE_CODE', p_object_type_code);
185: fnd_message.set_token ('P_OBJECT_NAME', p_object_name);
186: fnd_msg_pub.add;
187: x_return_status := fnd_api.g_ret_sts_unexp_error;
188: WHEN OTHERS
189: THEN
190: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
189: THEN
190: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
191: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
192: x_return_status := fnd_api.g_ret_sts_unexp_error;
193: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
194: END;
195:
196: /* PROCEDURE lock_references (
197: p_api_version IN NUMBER,
282: END IF;
283:
284: IF fnd_api.to_boolean (p_init_msg_list)
285: THEN
286: fnd_msg_pub.initialize;
287: END IF;
288:
289: IF p_escalation_reference_id IS NULL
290: THEN
288:
289: IF p_escalation_reference_id IS NULL
290: THEN
291: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_REFER');
292: fnd_msg_pub.add;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: RAISE fnd_api.g_exc_unexpected_error;
295: END IF;
296:
301: IF c_escalation_reference%NOTFOUND
302: THEN
303: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_REFER');
304: fnd_message.set_token ('P_TASK_REFERENCE_ID', p_escalation_reference_id);
305: fnd_msg_pub.add;
306: x_return_status := fnd_api.g_ret_sts_unexp_error;
307: RAISE fnd_api.g_exc_unexpected_error;
308: END IF;
309:
325: AND tasks.task_status_id = status.task_status_id
326: AND status.closed_flag = 'Y';
327:
328: fnd_message.set_name ('JTF', 'JTF_EC_DUPLICATE_ESCALATION');
329: fnd_msg_pub.add;
330: x_return_status := fnd_api.g_ret_sts_unexp_error;
331: RAISE fnd_api.g_exc_unexpected_error;
332: EXCEPTION
333: WHEN NO_DATA_FOUND
335: NULL;
336: WHEN TOO_MANY_ROWS
337: THEN
338: fnd_message.set_name ('JTF', 'JTF_EC_DUPLICATE_ESCALATION');
339: fnd_msg_pub.add;
340: x_return_status := fnd_api.g_ret_sts_unexp_error;
341: RAISE fnd_api.g_exc_unexpected_error;
342: END;
343:
407: THEN
408: COMMIT WORK;
409: END IF;
410:
411: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
412:
413:
414: jtf_esc_wf_events_pvt.publish_update_escRef
415: (P_ESC_REF_REC_OLD => l_esc_ref_rec_old,
424: WHEN fnd_api.g_exc_unexpected_error
425: THEN
426: ROLLBACK TO update_references_pub;
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
429: WHEN NO_DATA_FOUND
430: THEN
431: ROLLBACK TO update_references_pub;
432: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
431: ROLLBACK TO update_references_pub;
432: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
433: fnd_message.set_token ('P_OBJECT_TYPE_CODE', p_object_type_code);
434: fnd_message.set_token ('P_OBJECT_NAME', p_object_name);
435: fnd_msg_pub.add;
436: x_return_status := fnd_api.g_ret_sts_unexp_error;
437: WHEN OTHERS
438: THEN
439: ROLLBACK TO update_references_pub;
438: THEN
439: ROLLBACK TO update_references_pub;
440: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
441: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
442: fnd_msg_pub.add;
443: x_return_status := fnd_api.g_ret_sts_unexp_error;
444: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
445: END;
446:
440: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
441: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
442: fnd_msg_pub.add;
443: x_return_status := fnd_api.g_ret_sts_unexp_error;
444: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
445: END;
446:
447: ---------
448: ---------
489: END IF;
490:
491: IF fnd_api.to_boolean (p_init_msg_list)
492: THEN
493: fnd_msg_pub.initialize;
494: END IF;
495:
496: --Created for BES enh 2660883
497: OPEN c_ref_orig (p_escalation_reference_id);
519: THEN
520: COMMIT WORK;
521: END IF;
522:
523: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
524:
525: --Created for BES enh 2660883
526: begin
527:
543: WHEN fnd_api.g_exc_unexpected_error
544: THEN
545: ROLLBACK TO delete_task_reference_pub;
546: x_return_status := fnd_api.g_ret_sts_unexp_error;
547: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
548: WHEN OTHERS
549: THEN
550: ROLLBACK TO delete_task_reference_pub;
551: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
550: ROLLBACK TO delete_task_reference_pub;
551: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
552: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
553: x_return_status := fnd_api.g_ret_sts_unexp_error;
554: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
555: END;
556:
557: END;