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_MSG_PUB

Line 141: fnd_msg_pub.initialize;

137: THEN
138: RAISE fnd_api.g_exc_unexpected_error;
139: END IF;
140:
141: fnd_msg_pub.initialize;
142:
143: -- To get concurrent request id as well as data
144:
145: l_request_id := fnd_global.conc_request_id;

Line 205: FND_MSG_PUB.Add;

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;
209:

Line 577: FND_MSG_PUB.Add;

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;
581:

Line 712: FND_MSG_PUB.Add;

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;
716: END LOOP;

Line 724: FND_MSG_PUB.Add;

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
728: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_WORKER_RET_STAT_ERR');

Line 729: 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:
733: -- In case of 'NORMAL', setting OUT variable to successful,

Line 739: FND_MSG_PUB.Add;

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 ,
743: p_encoded => 'F'

Line 741: l_msg_data:=FND_MSG_PUB.Get(

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 ,
743: p_encoded => 'F'
744: );
745:

Line 742: p_msg_index => FND_MSG_PUB.G_LAST ,

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 ,
743: p_encoded => 'F'
744: );
745:
746: -- Setting the completion status of this concurrent

Line 773: FND_MSG_PUB.Count_And_Get (

769: EXCEPTION
770: WHEN fnd_api.g_exc_unexpected_error
771: THEN
772: ROLLBACK TO purge_standalone_tasks;
773: FND_MSG_PUB.Count_And_Get (
774: p_count => l_msg_count,
775: p_data => l_msg_data
776: );
777:

Line 808: FND_MSG_PUB.Add;

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
812: );

Line 809: FND_MSG_PUB.Count_And_Get (

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
812: );
813:

Line 885: fnd_msg_pub.initialize;

881: END IF;
882:
883: IF fnd_api.to_boolean (p_init_msg_list)
884: THEN
885: fnd_msg_pub.initialize;
886: END IF;
887:
888:
889: ----------------------------

Line 951: FND_MSG_PUB.Count_And_Get (

947: WHEN fnd_api.g_exc_unexpected_error
948: THEN
949: ROLLBACK TO delete_task_attachments;
950: x_return_status := fnd_api.g_ret_sts_unexp_error;
951: FND_MSG_PUB.Count_And_Get (
952: p_count => x_msg_count,
953: p_data => x_msg_data
954: );
955: IF l_tab_task_id.COUNT > 0

Line 979: FND_MSG_PUB.Add;

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,
983: p_data => x_msg_data

Line 981: FND_MSG_PUB.Count_And_Get (

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,
983: p_data => x_msg_data
984: );
985:

Line 1036: fnd_msg_pub.initialize;

1032: END IF;
1033:
1034: IF fnd_api.to_boolean (p_init_msg_list)
1035: THEN
1036: fnd_msg_pub.initialize;
1037: END IF;
1038:
1039:
1040: ----------------------------

Line 1094: FND_MSG_PUB.Count_And_Get (

1090: THEN
1091: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'End of VALIDATE_STANDALONE_TASK');
1092: END IF;
1093:
1094: FND_MSG_PUB.Count_And_Get (
1095: p_count => x_msg_count,
1096: p_data => x_msg_data
1097: );
1098:

Line 1104: FND_MSG_PUB.Count_And_Get (

1100: WHEN fnd_api.g_exc_unexpected_error
1101: THEN
1102: ROLLBACK TO validate_standalone_task;
1103: x_return_status := fnd_api.g_ret_sts_unexp_error;
1104: FND_MSG_PUB.Count_And_Get (
1105: p_count => x_msg_count,
1106: p_data => x_msg_data
1107: );
1108:

Line 1130: FND_MSG_PUB.Add;

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,
1134: p_data => x_msg_data

Line 1132: FND_MSG_PUB.Count_And_Get (

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,
1134: p_data => x_msg_data
1135: );
1136:

Line 1219: fnd_msg_pub.initialize;

1215: END IF;
1216:
1217: IF fnd_api.to_boolean (p_init_msg_list)
1218: THEN
1219: fnd_msg_pub.initialize;
1220: END IF;
1221:
1222:
1223: ----------------------------

Line 1530: FND_MSG_PUB.Add;

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 ,
1534: p_encoded => 'F'

Line 1532: l_msg_data:=FND_MSG_PUB.Get(

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 ,
1534: p_encoded => 'F'
1535: );
1536:

Line 1533: p_msg_index => FND_MSG_PUB.G_LAST ,

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 ,
1534: p_encoded => 'F'
1535: );
1536:
1537: -- Setting the completion status of this child concurrent

Line 1561: FND_MSG_PUB.Count_And_Get (

1557: EXCEPTION
1558: WHEN fnd_api.g_exc_unexpected_error
1559: THEN
1560: ROLLBACK TO populate_purge_tmp;
1561: FND_MSG_PUB.Count_And_Get (
1562: p_count => l_msg_count,
1563: p_data => l_msg_data
1564: );
1565:

Line 1596: FND_MSG_PUB.Add;

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
1600: );

Line 1597: FND_MSG_PUB.Count_And_Get (

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
1600: );
1601:

Line 1675: fnd_msg_pub.initialize;

1671: END IF;
1672:
1673: IF fnd_api.to_boolean (p_init_msg_list)
1674: THEN
1675: fnd_msg_pub.initialize;
1676: END IF;
1677:
1678:
1679: ----------------------------

Line 1967: FND_MSG_PUB.Count_And_Get (

1963: WHEN fnd_api.g_exc_unexpected_error
1964: THEN
1965: ROLLBACK TO purge_task_entities;
1966: x_return_status := fnd_api.g_ret_sts_unexp_error;
1967: FND_MSG_PUB.Count_And_Get (
1968: p_count => x_msg_count,
1969: p_data => x_msg_data
1970: );
1971: IF l_tab_task_id.COUNT > 0

Line 1995: FND_MSG_PUB.Add;

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,
1999: p_data => x_msg_data

Line 1997: FND_MSG_PUB.Count_And_Get (

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,
1999: p_data => x_msg_data
2000: );
2001: