eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CAC_TASK_PURGE_PVT dependencies on FND_MESSAGE

Line 204: FND_MESSAGE.Set_Name ('JTF', 'CAC_NO_TO_DATE_PROVIDED');

200: IF ((l_creation_date_to is null) And (l_last_updation_date_to is null)
201: And (l_planned_end_date_to is null) And (l_scheduled_end_date_to is null)
202: And (l_actual_end_date_to is null))
203: THEN
204: FND_MESSAGE.Set_Name ('JTF', 'CAC_NO_TO_DATE_PROVIDED');
205: FND_MSG_PUB.Add;
206: --fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
207: RAISE fnd_api.g_exc_unexpected_error;
208: End if;

Line 206: --fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

202: And (l_actual_end_date_to is null))
203: THEN
204: FND_MESSAGE.Set_Name ('JTF', 'CAC_NO_TO_DATE_PROVIDED');
205: FND_MSG_PUB.Add;
206: --fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
207: RAISE fnd_api.g_exc_unexpected_error;
208: End if;
209:
210:

Line 576: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_PURGE_SUBMIT_REQUEST');

572: -- process.
573:
574: IF l_worker_conc_req_arr(j) = 0
575: THEN
576: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_PURGE_SUBMIT_REQUEST');
577: FND_MSG_PUB.Add;
578: RAISE fnd_api.g_exc_unexpected_error;
579: END IF;
580: END LOOP;

Line 711: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_NO_CP_STATUS');

707:
708: -- There was a failure while collecting a child request
709: -- status, raising an unexpected exception
710:
711: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_NO_CP_STATUS');
712: FND_MSG_PUB.Add;
713:
714: RAISE fnd_api.g_exc_unexpected_error;
715: END IF;

Line 723: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_WORKER_RET_STAT_WARN');

719: -- by raising corresponding exceptions.
720:
721: IF l_main_conc_req_dev_status = 'WARNING'
722: THEN
723: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_WORKER_RET_STAT_WARN');
724: FND_MSG_PUB.Add;
725: RAISE fnd_api.g_exc_unexpected_error;
726: ELSIF l_main_conc_req_dev_status = 'ERROR'
727: THEN

Line 728: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_WORKER_RET_STAT_ERR');

724: FND_MSG_PUB.Add;
725: RAISE fnd_api.g_exc_unexpected_error;
726: ELSIF l_main_conc_req_dev_status = 'ERROR'
727: THEN
728: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_WORKER_RET_STAT_ERR');
729: FND_MSG_PUB.Add;
730: RAISE fnd_api.g_exc_unexpected_error;
731: END IF;
732:

Line 738: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_WORKER_RET_STAT_SUCC');

734: -- committing the work and also truncating JTF_TASK_PURGE table
735:
736: IF l_main_conc_req_dev_status = 'NORMAL'
737: THEN
738: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_WORKER_RET_STAT_SUCC');
739: FND_MSG_PUB.Add;
740:
741: l_msg_data:=FND_MSG_PUB.Get(
742: p_msg_index => FND_MSG_PUB.G_LAST ,

Line 806: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');

802:
803: WHEN OTHERS
804: THEN
805: ROLLBACK TO purge_standalone_tasks;
806: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
807: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name||' : '||SQLCODE||': '|| SQLERRM);
808: FND_MSG_PUB.Add;
809: FND_MSG_PUB.Count_And_Get (
810: p_count => l_msg_count,

Line 807: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name||' : '||SQLCODE||': '|| SQLERRM);

803: WHEN OTHERS
804: THEN
805: ROLLBACK TO purge_standalone_tasks;
806: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
807: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name||' : '||SQLCODE||': '|| SQLERRM);
808: FND_MSG_PUB.Add;
809: FND_MSG_PUB.Count_And_Get (
810: p_count => l_msg_count,
811: p_data => l_msg_data

Line 977: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');

973:
974: WHEN OTHERS
975: THEN
976: ROLLBACK TO delete_task_attachments;
977: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
978: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name ||' : '||SQLCODE||' : '|| SQLERRM);
979: FND_MSG_PUB.Add;
980: x_return_status := fnd_api.g_ret_sts_unexp_error;
981: FND_MSG_PUB.Count_And_Get (

Line 978: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name ||' : '||SQLCODE||' : '|| SQLERRM);

974: WHEN OTHERS
975: THEN
976: ROLLBACK TO delete_task_attachments;
977: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
978: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name ||' : '||SQLCODE||' : '|| SQLERRM);
979: FND_MSG_PUB.Add;
980: x_return_status := fnd_api.g_ret_sts_unexp_error;
981: FND_MSG_PUB.Count_And_Get (
982: p_count => x_msg_count,

Line 1128: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');

1124:
1125: WHEN OTHERS
1126: THEN
1127: ROLLBACK TO validate_standalone_task;
1128: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
1129: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name ||' : '||SQLCODE||' : '|| SQLERRM);
1130: FND_MSG_PUB.Add;
1131: x_return_status := fnd_api.g_ret_sts_unexp_error;
1132: FND_MSG_PUB.Count_And_Get (

Line 1129: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name ||' : '||SQLCODE||' : '|| SQLERRM);

1125: WHEN OTHERS
1126: THEN
1127: ROLLBACK TO validate_standalone_task;
1128: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
1129: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name ||' : '||SQLCODE||' : '|| SQLERRM);
1130: FND_MSG_PUB.Add;
1131: x_return_status := fnd_api.g_ret_sts_unexp_error;
1132: FND_MSG_PUB.Count_And_Get (
1133: p_count => x_msg_count,

Line 1529: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_WORKER_RET_STAT_SUCC');

1525: END IF;
1526:
1527: -- setting the message to success
1528:
1529: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_WORKER_RET_STAT_SUCC');
1530: FND_MSG_PUB.Add;
1531:
1532: l_msg_data:=FND_MSG_PUB.Get(
1533: p_msg_index => FND_MSG_PUB.G_LAST ,

Line 1594: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');

1590:
1591: WHEN OTHERS
1592: THEN
1593: ROLLBACK TO populate_purge_tmp;
1594: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
1595: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name ||' : '||SQLCODE||' : '|| SQLERRM);
1596: FND_MSG_PUB.Add;
1597: FND_MSG_PUB.Count_And_Get (
1598: p_count => l_msg_count,

Line 1595: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name ||' : '||SQLCODE||' : '|| SQLERRM);

1591: WHEN OTHERS
1592: THEN
1593: ROLLBACK TO populate_purge_tmp;
1594: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
1595: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name ||' : '||SQLCODE||' : '|| SQLERRM);
1596: FND_MSG_PUB.Add;
1597: FND_MSG_PUB.Count_And_Get (
1598: p_count => l_msg_count,
1599: p_data => l_msg_data

Line 1993: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');

1989:
1990: WHEN OTHERS
1991: THEN
1992: ROLLBACK TO purge_task_entities;
1993: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
1994: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name ||' : '||SQLCODE||' : '|| SQLERRM);
1995: FND_MSG_PUB.Add;
1996: x_return_status := fnd_api.g_ret_sts_unexp_error;
1997: FND_MSG_PUB.Count_And_Get (

Line 1994: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name ||' : '||SQLCODE||' : '|| SQLERRM);

1990: WHEN OTHERS
1991: THEN
1992: ROLLBACK TO purge_task_entities;
1993: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
1994: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name ||' : '||SQLCODE||' : '|| SQLERRM);
1995: FND_MSG_PUB.Add;
1996: x_return_status := fnd_api.g_ret_sts_unexp_error;
1997: FND_MSG_PUB.Count_And_Get (
1998: p_count => x_msg_count,