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 461: fnd_message.set_name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');

457:
458: WHEN OTHERS
459: THEN
460: ROLLBACK TO purge_tasks;
461: fnd_message.set_name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
462: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
463: fnd_msg_pub.add;
464: x_return_status := fnd_api.g_ret_sts_unexp_error;
465: if (get_tasks_ids%ISOPEN) then

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

458: WHEN OTHERS
459: THEN
460: ROLLBACK TO purge_tasks;
461: fnd_message.set_name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
462: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
463: fnd_msg_pub.add;
464: x_return_status := fnd_api.g_ret_sts_unexp_error;
465: if (get_tasks_ids%ISOPEN) then
466: Close get_tasks_ids;

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

696: ROLLBACK TO validate_tasks;
697: if (tasks_ids%ISOPEN) then
698: CLOSE tasks_ids;
699: end if;
700: fnd_message.set_name ('JTF', 'JTF_TASK_VALID_UNKNOWN_ERR');
701: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
702: fnd_msg_pub.add;
703: x_return_status := fnd_api.g_ret_sts_unexp_error;
704:

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

697: if (tasks_ids%ISOPEN) then
698: CLOSE tasks_ids;
699: end if;
700: fnd_message.set_name ('JTF', 'JTF_TASK_VALID_UNKNOWN_ERR');
701: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
702: fnd_msg_pub.add;
703: x_return_status := fnd_api.g_ret_sts_unexp_error;
704:
705: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then