DBA Data[Home] [Help]

APPS.JTF_TASK_DEPENDENCY_PUB dependencies on FND_MSG_PUB

Line 63: fnd_msg_pub.initialize;

59: END IF;
60:
61: IF fnd_api.to_boolean (p_init_msg_list)
62: THEN
63: fnd_msg_pub.initialize;
64: END IF;
65:
66: --- Validate if the template flag is in the following fnd_api.g_true , fnd_api.g_false , NULL
67: jtf_task_utl.validate_flag (

Line 105: fnd_msg_pub.add;

101: THEN
102: x_return_status := fnd_api.g_ret_sts_unexp_error;
103: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
104: fnd_message.set_token ('P_TASK_TEMPLATE_ID', l_task_id);
105: fnd_msg_pub.add;
106: RAISE fnd_api.g_exc_unexpected_error;
107: END IF;
108:
109: jtf_task_utl.validate_task_template (

Line 148: fnd_msg_pub.add;

144: THEN
145: x_return_status := fnd_api.g_ret_sts_unexp_error;
146: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
147: fnd_message.set_token ('P_TASK_TEMPLATE_ID', l_task_id);
148: fnd_msg_pub.add;
149: RAISE fnd_api.g_exc_unexpected_error;
150: END IF;
151:
152:

Line 236: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

232: THEN
233: COMMIT WORK;
234: END IF;
235:
236: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
237: EXCEPTION
238: WHEN fnd_api.g_exc_unexpected_error
239: THEN
240: ROLLBACK TO create_task_dependency_pub;

Line 242: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

238: WHEN fnd_api.g_exc_unexpected_error
239: THEN
240: ROLLBACK TO create_task_dependency_pub;
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
243: WHEN OTHERS
244: THEN
245: ROLLBACK TO create_task_dependency_pub;
246: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 249: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

245: ROLLBACK TO create_task_dependency_pub;
246: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
247: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
248: x_return_status := fnd_api.g_ret_sts_unexp_error;
249: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
250: END;
251:
252: /**********************************************************************************************************
253: ***********************************************************************************************************

Line 287: fnd_msg_pub.initialize;

283: END IF;
284:
285: IF fnd_api.to_boolean (p_init_msg_list)
286: THEN
287: fnd_msg_pub.initialize;
288: END IF;
289:
290: x_return_status := fnd_api.g_ret_sts_success;
291:

Line 297: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

293: x_dependency_id => p_dependency_id ,
294: x_object_version_number => p_object_version_number );
295:
296:
297: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
298:
299: EXCEPTION
300: WHEN Resource_Locked then
301: ROLLBACK TO lock_task_depends_pub;

Line 305: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

301: ROLLBACK TO lock_task_depends_pub;
302: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
303: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');
304: x_return_status := fnd_api.g_ret_sts_unexp_error;
305: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
306:
307: WHEN fnd_api.g_exc_unexpected_error
308: THEN
309: ROLLBACK TO lock_task_depends_pub;

Line 311: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

307: WHEN fnd_api.g_exc_unexpected_error
308: THEN
309: ROLLBACK TO lock_task_depends_pub;
310: x_return_status := fnd_api.g_ret_sts_unexp_error;
311: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
312: WHEN OTHERS
313: THEN
314: ROLLBACK TO lock_task_depends_pub;
315: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

Line 318: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

314: ROLLBACK TO lock_task_depends_pub;
315: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
316: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
317: x_return_status := fnd_api.g_ret_sts_unexp_error;
318: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
319: END;
320: /**********************************************************************************************************
321: ***********************************************************************************************************
322: ***********************************************************************************************************

Line 412: fnd_msg_pub.initialize;

408: END IF;
409:
410: IF fnd_api.to_boolean (p_init_msg_list)
411: THEN
412: fnd_msg_pub.initialize;
413: END IF;
414:
415: -- check if the dependency is invalid or null.
416: IF (l_dependency_id IS NULL)

Line 419: fnd_msg_pub.add;

415: -- check if the dependency is invalid or null.
416: IF (l_dependency_id IS NULL)
417: THEN
418: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_DEPENDENCY_ID');
419: fnd_msg_pub.add;
420: x_return_status := fnd_api.g_ret_sts_unexp_error;
421: RAISE fnd_api.g_exc_unexpected_error;
422: END IF;
423:

Line 431: fnd_msg_pub.add;

427: IF c_jtf_task_depends%NOTFOUND
428: THEN
429: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');
430: fnd_message.set_token ('P_DEPENDENCY_ID', p_dependency_id);
431: fnd_msg_pub.add;
432: x_return_status := fnd_api.g_ret_sts_unexp_error;
433: RAISE fnd_api.g_exc_unexpected_error;
434: END IF;
435:

Line 483: fnd_msg_pub.add;

479: IF l_dependent_on_task_id IS NULL
480: THEN
481: x_return_status := fnd_api.g_ret_sts_unexp_error;
482: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
483: fnd_msg_pub.add;
484: RAISE fnd_api.g_exc_unexpected_error;
485: END IF;
486: ELSE
487: l_dependent_on_task_id := task_depends.dependent_on_task_id;

Line 554: fnd_msg_pub.count_and_get (

550: THEN
551: CLOSE c_jtf_task_depends;
552: END IF;
553:
554: fnd_msg_pub.count_and_get (
555: p_count => x_msg_count,
556: p_data => x_msg_data);
557: EXCEPTION
558: WHEN fnd_api.g_exc_unexpected_error

Line 568: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

564: CLOSE c_jtf_task_depends;
565: END IF;
566:
567: x_return_status := fnd_api.g_ret_sts_unexp_error;
568: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
569: WHEN OTHERS
570: THEN
571: IF c_jtf_task_depends%ISOPEN
572: THEN

Line 580: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

576: ROLLBACK TO update_task_dependency_pub;
577: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
578: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
579: x_return_status := fnd_api.g_ret_sts_unexp_error;
580: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
581: END;
582:
583: PROCEDURE delete_task_dependency (
584: p_api_version IN NUMBER,

Line 620: fnd_msg_pub.initialize;

616: END IF;
617:
618: IF fnd_api.to_boolean (p_init_msg_list)
619: THEN
620: fnd_msg_pub.initialize;
621: END IF;
622:
623:
624:

Line 630: fnd_msg_pub.add;

626: IF (l_dependency_id IS NULL)
627: THEN
628:
629: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_DEPENDS');
630: fnd_msg_pub.add;
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632: RAISE fnd_api.g_exc_unexpected_error;
633: END IF;
634:

Line 643: fnd_msg_pub.add;

639: IF c_jtf_task_depends%NOTFOUND
640: THEN
641: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');
642: fnd_message.set_token('P_DEPENDENCY_ID',P_DEPENDENCY_ID);
643: fnd_msg_pub.add;
644: x_return_status := fnd_api.g_ret_sts_unexp_error;
645: RAISE fnd_api.g_exc_unexpected_error;
646: ELSE
647: jtf_task_dependency_pvt.delete_task_dependency (

Line 676: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

672: THEN
673: COMMIT WORK;
674: END IF;
675:
676: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
677: EXCEPTION
678: WHEN fnd_api.g_exc_error
679: THEN
680:

Line 690: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

686: CLOSE c_jtf_task_depends;
687: END IF;
688:
689: x_return_status := fnd_api.g_ret_sts_error;
690: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
691: WHEN fnd_api.g_exc_unexpected_error
692: THEN
693:
694:

Line 703: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

699: CLOSE c_jtf_task_depends;
700: END IF;
701:
702: x_return_status := fnd_api.g_ret_sts_unexp_error;
703: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
704: WHEN OTHERS
705: THEN
706:
707: ROLLBACK TO delete_task_dependency_pub;

Line 717: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

713:
714: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
715: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
716: x_return_status := fnd_api.g_ret_sts_unexp_error;
717: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
718: END; -- Delete Task dependency
719: END;