DBA Data[Home] [Help]

APPS.CAC_TASK_PURGE_PUB dependencies on FND_MESSAGE

Line 102: fnd_message.set_name ('JTF', 'JTF_ATTACHMENT_PURGE_EXCEP');

98:
99: WHEN OTHERS
100: THEN
101: ROLLBACK TO purge_task_attach;
102: fnd_message.set_name ('JTF', 'JTF_ATTACHMENT_PURGE_EXCEP');
103: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
104: fnd_msg_pub.add;
105: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
106: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.delete_atth_to_tasks', ' x_return_status= '||x_return_status);

Line 103: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

99: WHEN OTHERS
100: THEN
101: ROLLBACK TO purge_task_attach;
102: fnd_message.set_name ('JTF', 'JTF_ATTACHMENT_PURGE_EXCEP');
103: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
104: fnd_msg_pub.add;
105: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
106: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.delete_atth_to_tasks', ' x_return_status= '||x_return_status);
107: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'cac_task_purge_pub.delete_atth_to_tasks', ' x_msg_data= '||x_msg_data);

Line 436: fnd_message.set_name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');

432:
433: WHEN OTHERS
434: THEN
435: ROLLBACK TO purge_tasks;
436: fnd_message.set_name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
437: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
438: fnd_msg_pub.add;
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: if (get_tasks_ids%ISOPEN) then

Line 437: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

433: WHEN OTHERS
434: THEN
435: ROLLBACK TO purge_tasks;
436: fnd_message.set_name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
437: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
438: fnd_msg_pub.add;
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: if (get_tasks_ids%ISOPEN) then
441: Close get_tasks_ids;

Line 675: fnd_message.set_name ('JTF', 'JTF_TASK_VALID_UNKNOWN_ERR');

671: ROLLBACK TO validate_tasks;
672: if (tasks_ids%ISOPEN) then
673: CLOSE tasks_ids;
674: end if;
675: fnd_message.set_name ('JTF', 'JTF_TASK_VALID_UNKNOWN_ERR');
676: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
677: fnd_msg_pub.add;
678: x_return_status := fnd_api.g_ret_sts_unexp_error;
679:

Line 676: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

672: if (tasks_ids%ISOPEN) then
673: CLOSE tasks_ids;
674: end if;
675: fnd_message.set_name ('JTF', 'JTF_TASK_VALID_UNKNOWN_ERR');
676: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
677: fnd_msg_pub.add;
678: x_return_status := fnd_api.g_ret_sts_unexp_error;
679:
680: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then