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.PA_PROJECTS_MAINT_PUB dependencies on FND_MSG_PUB

Line 201: fnd_msg_pub.initialize;

197:
198: pa_debug.init_err_stack('PA_PROJECTS_MAINT_PUB.CREATE_PROJECT');
199:
200: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
201: fnd_msg_pub.initialize;
202: end if;
203:
204: -- dbms_output.put_line('After initializing the stack');
205:

Line 519: l_msg_count := FND_MSG_PUB.count_msg;

515: if (p_debug_mode = 'Y') then
516: pa_debug.debug('Create_Project PUB : checking message count');
517: end if;
518:
519: l_msg_count := FND_MSG_PUB.count_msg;
520: If l_msg_count > 0 THEN
521: x_msg_count := l_msg_count;
522: If l_msg_count = 1 THEN
523: pa_interface_utils_pub.get_messages

Line 538: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

534:
535: /*
536: IF l_msg_count = 1 THEN
537: x_msg_count := l_msg_count;
538: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,
539: p_encoded => FND_API.G_TRUE);
540: ELSE
541: x_msg_count := l_msg_count;
542: END IF;

Line 611: l_msg_count := FND_MSG_PUB.count_msg;

607: pa_debug.debug('Create_Project PUB : checking message count');
608: end if;
609: --dbms_output.put_line('After PRIVATE API call ... '||l_return_status);
610:
611: l_msg_count := FND_MSG_PUB.count_msg;
612: If l_msg_count > 0 THEN
613: x_msg_count := l_msg_count;
614: If l_msg_count = 1 THEN
615: pa_interface_utils_pub.get_messages

Line 627: l_msg_count := FND_MSG_PUB.count_msg;

623: End if;
624: RAISE FND_API.G_EXC_ERROR;
625: End if;
626: /*
627: l_msg_count := FND_MSG_PUB.count_msg;
628:
629: IF l_msg_count = 1 THEN
630: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,
631: p_encoded => FND_API.G_TRUE);

Line 630: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

626: /*
627: l_msg_count := FND_MSG_PUB.count_msg;
628:
629: IF l_msg_count = 1 THEN
630: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,
631: p_encoded => FND_API.G_TRUE);
632: x_msg_count := l_msg_count;
633: ELSE
634: x_msg_count := l_msg_count;

Line 658: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

654: IF p_commit = FND_API.G_TRUE THEN
655: ROLLBACK TO prm_create_project;
656: END IF;
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
659: p_procedure_name => 'CREATE_PROJECT',
660: p_error_text => SUBSTRB(SQLERRM,1,240));
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662:

Line 674: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

670: IF p_commit = FND_API.G_TRUE THEN
671: ROLLBACK TO prm_create_project;
672: END IF;
673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
674: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
675: p_procedure_name => 'CREATE_PROJECT',
676: p_error_text => SUBSTRB(SQLERRM,1,240));
677: raise;
678:

Line 772: FND_MSG_PUB.initialize;

768: x_return_status := FND_API.G_RET_STS_SUCCESS;
769:
770: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE))
771: THEN
772: FND_MSG_PUB.initialize;
773: END IF;
774:
775: x_return_status := 'S';
776:

Line 829: l_msg_count := FND_MSG_PUB.count_msg;

825: x_return_status => l_return_status ,
826: x_msg_count => l_msg_count ,
827: x_msg_data => l_msg_data) ;
828:
829: l_msg_count := FND_MSG_PUB.count_msg;
830: If l_msg_count > 0 THEN
831: x_msg_count := l_msg_count;
832: If l_msg_count = 1 THEN
833: pa_interface_utils_pub.get_messages

Line 845: l_msg_count := FND_MSG_PUB.count_msg;

841: End if;
842: RAISE FND_API.G_EXC_ERROR;
843: End if;
844: /*
845: l_msg_count := FND_MSG_PUB.count_msg;
846:
847: IF l_msg_count = 1 THEN
848: x_msg_count := l_msg_count;
849: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

Line 849: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

845: l_msg_count := FND_MSG_PUB.count_msg;
846:
847: IF l_msg_count = 1 THEN
848: x_msg_count := l_msg_count;
849: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,
850: p_encoded => FND_API.G_TRUE);
851: ELSE
852: x_msg_count := l_msg_count;
853: END IF;

Line 876: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

872: IF p_commit = FND_API.G_TRUE THEN
873: ROLLBACK TO create_customer;
874: END IF;
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
877: p_procedure_name => 'CREATE_CUSTOMER',
878: p_error_text => SUBSTRB(SQLERRM,1,240));
879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
880:

Line 892: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

888: IF p_commit = FND_API.G_TRUE THEN
889: ROLLBACK TO create_customer;
890: END IF;
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
893: p_procedure_name => 'CREATE_CUSTOMER',
894: p_error_text => SUBSTRB(SQLERRM,1,240));
895: raise;
896:

Line 1049: fnd_msg_pub.initialize;

1045: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1046: END IF;
1047:
1048: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
1049: fnd_msg_pub.initialize;
1050: end if;
1051:
1052: x_return_status := FND_API.G_RET_STS_SUCCESS;
1053:

Line 1099: l_msg_count := FND_MSG_PUB.count_msg;

1095: END IF;
1096:
1097: --dbms_output.put_line(' after check_org name or_id');
1098:
1099: l_msg_count := FND_MSG_PUB.count_msg;
1100: If l_msg_count > 0 THEN
1101: x_msg_count := l_msg_count;
1102: If l_msg_count = 1 THEN
1103: pa_interface_utils_pub.get_messages

Line 1115: l_msg_count := FND_MSG_PUB.count_msg;

1111: End if;
1112: RAISE FND_API.G_EXC_ERROR;
1113: End if;
1114: /*
1115: l_msg_count := FND_MSG_PUB.count_msg;
1116:
1117: IF l_msg_count = 1 THEN
1118: x_msg_count := l_msg_count;
1119: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

Line 1119: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

1115: l_msg_count := FND_MSG_PUB.count_msg;
1116:
1117: IF l_msg_count = 1 THEN
1118: x_msg_count := l_msg_count;
1119: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,
1120: p_encoded => FND_API.G_TRUE);
1121: ELSE
1122: x_msg_count := l_msg_count;
1123: END IF;

Line 1193: l_msg_count := FND_MSG_PUB.count_msg;

1189:
1190: if (p_debug_mode = 'Y') then
1191: pa_debug.debug('Update_project_basic_info PUB : Checking message count');
1192: end if;
1193: l_msg_count := FND_MSG_PUB.count_msg;
1194: If l_msg_count > 0 THEN
1195: x_msg_count := l_msg_count;
1196: If l_msg_count = 1 THEN
1197: pa_interface_utils_pub.get_messages

Line 1209: l_msg_count := FND_MSG_PUB.count_msg;

1205: End if;
1206: RAISE FND_API.G_EXC_ERROR;
1207: End if;
1208: /*
1209: l_msg_count := FND_MSG_PUB.count_msg;
1210:
1211: IF l_msg_count = 1 THEN
1212: x_msg_count := l_msg_count;
1213: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

Line 1213: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

1209: l_msg_count := FND_MSG_PUB.count_msg;
1210:
1211: IF l_msg_count = 1 THEN
1212: x_msg_count := l_msg_count;
1213: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,
1214: p_encoded => FND_API.G_TRUE);
1215: ELSE
1216: x_msg_count := l_msg_count;
1217: END IF;

Line 1235: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1231: IF p_commit = FND_API.G_TRUE THEN
1232: ROLLBACK TO update_project_basic_info;
1233: END IF;
1234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1236: p_procedure_name => 'UPDATE_PROJECT_BASIC_INFO',
1237: p_error_text => SUBSTRB(SQLERRM,1,240));
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1239:

Line 1251: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1247: IF p_commit = FND_API.G_TRUE THEN
1248: ROLLBACK TO update_project_basic_info;
1249: END IF;
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1251: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1252: p_procedure_name => 'UPDATE_PROJECT_BASIC_INFO',
1253: p_error_text => SUBSTRB(SQLERRM,1,240));
1254: raise;
1255:

Line 1363: fnd_msg_pub.initialize;

1359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1360: END IF;
1361:
1362: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
1363: fnd_msg_pub.initialize;
1364: end if;
1365:
1366: x_return_status := FND_API.G_RET_STS_SUCCESS;
1367:

Line 1407: l_msg_count := FND_MSG_PUB.count_msg;

1403: THEN
1404: l_cost_job_Group_id := PA_PROJECTS_MAINT_UTILS.GET_COST_JOB_GROUP_ID;
1405: END IF;
1406:
1407: l_msg_count := FND_MSG_PUB.count_msg;
1408: If l_msg_count > 0 THEN
1409: x_msg_count := l_msg_count;
1410: If l_msg_count = 1 THEN
1411: pa_interface_utils_pub.get_messages

Line 1423: l_msg_count := FND_MSG_PUB.count_msg;

1419: End if;
1420: RAISE FND_API.G_EXC_ERROR;
1421: End if;
1422: /*
1423: l_msg_count := FND_MSG_PUB.count_msg;
1424:
1425: IF l_msg_count = 1 THEN
1426: x_msg_count := l_msg_count;
1427: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

Line 1427: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

1423: l_msg_count := FND_MSG_PUB.count_msg;
1424:
1425: IF l_msg_count = 1 THEN
1426: x_msg_count := l_msg_count;
1427: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,
1428: p_encoded => FND_API.G_TRUE);
1429:
1430: ELSE
1431: x_msg_count := l_msg_count;

Line 1482: l_msg_count := FND_MSG_PUB.count_msg;

1478:
1479: if (p_debug_mode = 'Y') then
1480: pa_debug.debug('Update_project_Additional_info PUB : Checking message count');
1481: end if;
1482: l_msg_count := FND_MSG_PUB.count_msg;
1483: If l_msg_count > 0 THEN
1484: x_msg_count := l_msg_count;
1485: If l_msg_count = 1 THEN
1486: pa_interface_utils_pub.get_messages

Line 1498: l_msg_count := FND_MSG_PUB.count_msg;

1494: End if;
1495: RAISE FND_API.G_EXC_ERROR;
1496: End if;
1497: /*
1498: l_msg_count := FND_MSG_PUB.count_msg;
1499:
1500: IF l_msg_count = 1 THEN
1501: x_msg_count := l_msg_count;
1502: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

Line 1502: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

1498: l_msg_count := FND_MSG_PUB.count_msg;
1499:
1500: IF l_msg_count = 1 THEN
1501: x_msg_count := l_msg_count;
1502: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,
1503: p_encoded => FND_API.G_TRUE);
1504: ELSE
1505: x_msg_count := l_msg_count;
1506: END IF;

Line 1523: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1519: IF p_commit = FND_API.G_TRUE THEN
1520: ROLLBACK TO update_project_additional_info;
1521: END IF;
1522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1523: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1524: p_procedure_name => 'UPDATE_PROJECT_ADDITIONAL_INFO',
1525: p_error_text => SUBSTRB(SQLERRM,1,240));
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527:

Line 1540: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1536: IF p_commit = FND_API.G_TRUE THEN
1537: ROLLBACK TO update_project_additional_info;
1538: END IF;
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1541: p_procedure_name => 'UPDATE_PROJECT_ADDITIONAL_INFO',
1542: p_error_text => SUBSTRB(SQLERRM,1,240));
1543: raise;
1544:

Line 1655: fnd_msg_pub.initialize;

1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1652: END IF;
1653:
1654: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
1655: fnd_msg_pub.initialize;
1656: end if;
1657:
1658: x_return_status := FND_API.G_RET_STS_SUCCESS;
1659:

Line 1710: l_msg_count := FND_MSG_PUB.count_msg;

1706:
1707: if (p_debug_mode = 'Y') then
1708: pa_debug.debug('Update_project_pipeline_info PUB : Checking message count');
1709: end if;
1710: l_msg_count := FND_MSG_PUB.count_msg;
1711: If l_msg_count > 0 THEN
1712: x_msg_count := l_msg_count;
1713: If l_msg_count = 1 THEN
1714: pa_interface_utils_pub.get_messages

Line 1782: l_msg_count := FND_MSG_PUB.count_msg;

1778:
1779: if (p_debug_mode = 'Y') then
1780: pa_debug.debug('Update_project_pipeline_info PUB : Checking message count');
1781: end if;
1782: l_msg_count := FND_MSG_PUB.count_msg;
1783: If l_msg_count > 0 THEN
1784: x_msg_count := l_msg_count;
1785: If l_msg_count = 1 THEN
1786: pa_interface_utils_pub.get_messages

Line 1798: l_msg_count := FND_MSG_PUB.count_msg;

1794: End if;
1795: RAISE FND_API.G_EXC_ERROR;
1796: End if;
1797: /*
1798: l_msg_count := FND_MSG_PUB.count_msg;
1799:
1800: IF l_msg_count = 1 THEN
1801: x_msg_count := l_msg_count;
1802: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

Line 1802: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

1798: l_msg_count := FND_MSG_PUB.count_msg;
1799:
1800: IF l_msg_count = 1 THEN
1801: x_msg_count := l_msg_count;
1802: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,
1803: p_encoded => FND_API.G_TRUE);
1804:
1805: ELSE
1806: x_msg_count := l_msg_count;

Line 1825: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1821: IF p_commit = FND_API.G_TRUE THEN
1822: ROLLBACK TO update_project_pipeline_info;
1823: END IF;
1824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1825: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1826: p_procedure_name => 'UPDATE_PROJECT_PIPELINE_INFO',
1827: p_error_text => SUBSTRB(SQLERRM,1,240));
1828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1829:

Line 1841: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1837: IF p_commit = FND_API.G_TRUE THEN
1838: ROLLBACK TO update_project_pipeline_info;
1839: END IF;
1840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1841: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1842: p_procedure_name => 'UPDATE_PROJECT_PIPELINE_INFO',
1843: p_error_text => SUBSTRB(SQLERRM,1,240));
1844: raise;
1845:

Line 1960: fnd_msg_pub.initialize;

1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1957: END IF;
1958:
1959: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
1960: fnd_msg_pub.initialize;
1961: end if;
1962:
1963: x_return_status := FND_API.G_RET_STS_SUCCESS;
1964:

Line 1989: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

1985: p_msg_name => 'PA_AL_INVALID_CLASS_CATG_PROJE');
1986: x_msg_data := 'PA_AL_INVALID_CLASS_CATG_PROJE';
1987: x_return_status := 'E' ;
1988: WHEN OTHERS THEN
1989: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1990: p_procedure_name => 'CREATE_CLASSIFICATIONS',
1991: p_error_text => SUBSTRB(SQLERRM,1,240));
1992: raise;
1993: END;

Line 2015: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2011: p_msg_name => 'PA_CLASS_CATG_CODE_INVALID');
2012: x_msg_data := 'PA_CLASS_CATG_CODE_INVALID';
2013: x_return_status := 'E' ;
2014: WHEN OTHERS THEN
2015: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2016: p_procedure_name => 'CREATE_CLASSIFICATIONS',
2017: p_error_text => SUBSTRB(SQLERRM,1,240));
2018: raise;
2019: END;

Line 2021: l_msg_count := FND_MSG_PUB.count_msg;

2017: p_error_text => SUBSTRB(SQLERRM,1,240));
2018: raise;
2019: END;
2020: -- Bug 14150391 - Added condition for END DATED CLASS CODES Ends here
2021: l_msg_count := FND_MSG_PUB.count_msg;
2022: If l_msg_count > 0 THEN
2023: x_msg_count := l_msg_count;
2024: If l_msg_count = 1 THEN
2025: pa_interface_utils_pub.get_messages

Line 2038: l_msg_count := FND_MSG_PUB.count_msg;

2034: RAISE FND_API.G_EXC_ERROR;
2035: End if;
2036:
2037: /*
2038: l_msg_count := FND_MSG_PUB.count_msg;
2039:
2040: IF l_msg_count = 1 THEN
2041: x_msg_count := l_msg_count;
2042: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

Line 2042: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

2038: l_msg_count := FND_MSG_PUB.count_msg;
2039:
2040: IF l_msg_count = 1 THEN
2041: x_msg_count := l_msg_count;
2042: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,
2043: p_encoded => FND_API.G_TRUE);
2044:
2045: ELSE
2046: x_msg_count := l_msg_count;

Line 2087: l_msg_count := FND_MSG_PUB.count_msg;

2083: x_return_status => l_return_status,
2084: x_msg_count => l_msg_count,
2085: x_msg_data => l_msg_data);
2086:
2087: l_msg_count := FND_MSG_PUB.count_msg;
2088: If l_msg_count > 0 THEN
2089: x_msg_count := l_msg_count;
2090: If l_msg_count = 1 THEN
2091: pa_interface_utils_pub.get_messages

Line 2103: l_msg_count := FND_MSG_PUB.count_msg;

2099: End if;
2100: RAISE FND_API.G_EXC_ERROR;
2101: End if;
2102: /*
2103: l_msg_count := FND_MSG_PUB.count_msg;
2104:
2105: IF l_msg_count = 1 THEN
2106: x_msg_count := l_msg_count;
2107: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

Line 2107: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

2103: l_msg_count := FND_MSG_PUB.count_msg;
2104:
2105: IF l_msg_count = 1 THEN
2106: x_msg_count := l_msg_count;
2107: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,
2108: p_encoded => FND_API.G_TRUE);
2109: ELSE
2110: x_msg_count := l_msg_count;
2111: END IF;

Line 2136: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2132: IF p_commit = FND_API.G_TRUE THEN
2133: ROLLBACK TO create_classifications;
2134: END IF;
2135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2136: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2137: p_procedure_name => 'CREATE_CLASSIFICATIONS',
2138: p_error_text => SUBSTRB(SQLERRM,1,240));
2139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2140:

Line 2152: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2148: IF p_commit = FND_API.G_TRUE THEN
2149: ROLLBACK TO CREATE_CLASSIFICATIONS;
2150: END IF;
2151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2152: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2153: p_procedure_name => 'CREATE_CLASSIFICATIONS',
2154: p_error_text => SUBSTRB(SQLERRM,1,240));
2155: raise;
2156:

Line 2276: fnd_msg_pub.initialize;

2272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2273: END IF;
2274:
2275: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
2276: fnd_msg_pub.initialize;
2277: end if;
2278:
2279: x_return_status := FND_API.G_RET_STS_SUCCESS;
2280:

Line 2305: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2301: p_msg_name => 'PA_AL_INVALID_CLASS_CATG_PROJE');
2302: x_msg_data := 'PA_AL_INVALID_CLASS_CATG_PROJE';
2303: x_return_status := 'E' ;
2304: WHEN OTHERS THEN
2305: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2306: p_procedure_name => 'UPDATE_CLASSIFICATIONS',
2307: p_error_text => SUBSTRB(SQLERRM,1,240));
2308: raise;
2309: END;

Line 2331: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2327: p_msg_name => 'PA_CLASS_CATG_CODE_INVALID');
2328: x_msg_data := 'PA_CLASS_CATG_CODE_INVALID';
2329: x_return_status := 'E' ;
2330: WHEN OTHERS THEN
2331: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2332: p_procedure_name => 'UPDATE_CLASSIFICATIONS',
2333: p_error_text => SUBSTRB(SQLERRM,1,240));
2334: raise;
2335: END;

Line 2337: l_msg_count := FND_MSG_PUB.count_msg;

2333: p_error_text => SUBSTRB(SQLERRM,1,240));
2334: raise;
2335: END;
2336: -- Bug 14150391 - Added condition for END DATED CLASS CODES Ends here
2337: l_msg_count := FND_MSG_PUB.count_msg;
2338: If l_msg_count > 0 THEN
2339: x_msg_count := l_msg_count;
2340: If l_msg_count = 1 THEN
2341: pa_interface_utils_pub.get_messages

Line 2389: l_msg_count := FND_MSG_PUB.count_msg;

2385: x_return_status => l_return_status,
2386: x_msg_count => l_msg_count,
2387: x_msg_data => l_msg_data);
2388:
2389: l_msg_count := FND_MSG_PUB.count_msg;
2390: If l_msg_count > 0 THEN
2391: x_msg_count := l_msg_count;
2392: If l_msg_count = 1 THEN
2393: pa_interface_utils_pub.get_messages

Line 2415: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2411: IF p_commit = FND_API.G_TRUE THEN
2412: ROLLBACK TO update_classifications;
2413: END IF;
2414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2415: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2416: p_procedure_name => 'UPDATE_CLASSIFICATIONS',
2417: p_error_text => SUBSTRB(SQLERRM,1,240));
2418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2419:

Line 2431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2427: IF p_commit = FND_API.G_TRUE THEN
2428: ROLLBACK TO UPDATE_CLASSIFICATIONS;
2429: END IF;
2430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2431: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2432: p_procedure_name => 'UPDATE_CLASSIFICATIONS',
2433: p_error_text => SUBSTRB(SQLERRM,1,240));
2434: raise;
2435:

Line 2521: fnd_msg_pub.initialize;

2517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2518: END IF;
2519:
2520: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
2521: fnd_msg_pub.initialize;
2522: end if;
2523:
2524: x_return_status := FND_API.G_RET_STS_SUCCESS;
2525:

Line 2551: l_msg_count := FND_MSG_PUB.count_msg;

2547:
2548: if (p_debug_mode = 'Y') then
2549: pa_debug.debug('delete_classifications PUB : Checking message count');
2550: end if;
2551: l_msg_count := FND_MSG_PUB.count_msg;
2552: If l_msg_count > 0 THEN
2553: x_msg_count := l_msg_count;
2554: If l_msg_count = 1 THEN
2555: pa_interface_utils_pub.get_messages

Line 2567: l_msg_count := FND_MSG_PUB.count_msg;

2563: End if;
2564: RAISE FND_API.G_EXC_ERROR;
2565: End if;
2566: /*
2567: l_msg_count := FND_MSG_PUB.count_msg;
2568:
2569: IF l_msg_count = 1 THEN
2570: x_msg_count := l_msg_count;
2571: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

Line 2571: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

2567: l_msg_count := FND_MSG_PUB.count_msg;
2568:
2569: IF l_msg_count = 1 THEN
2570: x_msg_count := l_msg_count;
2571: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,
2572: p_encoded => FND_API.G_TRUE);
2573: ELSE
2574: x_msg_count := l_msg_count;
2575: END IF;

Line 2592: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2588: IF p_commit = FND_API.G_TRUE THEN
2589: ROLLBACK TO delete_classifications;
2590: END IF;
2591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2592: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2593: p_procedure_name => 'DELETE_CLASSIFICATIONS',
2594: p_error_text => SUBSTRB(SQLERRM,1,240));
2595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2596:

Line 2608: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2604: IF p_commit = FND_API.G_TRUE THEN
2605: ROLLBACK TO delete_classifications;
2606: END IF;
2607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2608: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2609: p_procedure_name => 'DELETE_CLASSIFICATIONS',
2610: p_error_text => SUBSTRB(SQLERRM,1,240));
2611: raise;
2612:

Line 2718: fnd_msg_pub.initialize;

2714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2715: END IF;
2716:
2717: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
2718: fnd_msg_pub.initialize;
2719: end if;
2720:
2721: x_return_status := FND_API.G_RET_STS_SUCCESS;
2722:

Line 2779: l_msg_count := FND_MSG_PUB.count_msg;

2775: END IF;
2776: END IF;
2777:
2778:
2779: l_msg_count := FND_MSG_PUB.count_msg;
2780: If l_msg_count > 0 THEN
2781: x_msg_count := l_msg_count;
2782: If l_msg_count = 1 THEN
2783: pa_interface_utils_pub.get_messages

Line 2928: l_msg_count := FND_MSG_PUB.count_msg;

2924: x_return_status := FND_API.G_RET_STS_ERROR;
2925: END IF;
2926: END IF;
2927:
2928: l_msg_count := FND_MSG_PUB.count_msg;
2929: If l_msg_count > 0 THEN
2930: x_msg_count := l_msg_count;
2931: If l_msg_count = 1 THEN
2932: pa_interface_utils_pub.get_messages

Line 2976: l_msg_count := FND_MSG_PUB.count_msg;

2972:
2973: if (p_debug_mode = 'Y') then
2974: pa_debug.debug('update_project_staffing_info PUB : Checking message count');
2975: end if;
2976: l_msg_count := FND_MSG_PUB.count_msg;
2977: If l_msg_count > 0 THEN
2978: x_msg_count := l_msg_count;
2979: If l_msg_count = 1 THEN
2980: pa_interface_utils_pub.get_messages

Line 3001: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

2997: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2998: IF p_commit = FND_API.G_TRUE THEN
2999: ROLLBACK TO update_project_staffing_info;
3000: END IF;
3001: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
3002: p_procedure_name => 'UPDATE_PROJECT_STAFFING_INFO',
3003: p_error_text => SUBSTRB(SQLERRM,1,240));
3004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3005:

Line 3017: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

3013: IF p_commit = FND_API.G_TRUE THEN
3014: ROLLBACK TO update_project_staffing_info;
3015: END IF;
3016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3017: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
3018: p_procedure_name => 'UPDATE_PROJECT_STAFFING_INFO',
3019: p_error_text => SUBSTRB(SQLERRM,1,240));
3020: raise;
3021:

Line 3136: FND_MSG_PUB.initialize;

3132: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3133: end if;
3134:
3135: if FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) then
3136: FND_MSG_PUB.initialize;
3137: end if;
3138:
3139: if (p_debug_mode = 'Y') then
3140: pa_debug.debug('Check if the role to be created is in CUSTOMER role class...');

Line 3179: fnd_msg_pub.add;

3175: ,x_error_message_code => l_error_message_code);
3176:
3177: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3178: fnd_message.set_name('PA',l_error_message_code);
3179: fnd_msg_pub.add;
3180: end if;
3181:
3182: l_msg_count := FND_MSG_PUB.count_msg;
3183: if l_msg_count > 0 then

Line 3182: l_msg_count := FND_MSG_PUB.count_msg;

3178: fnd_message.set_name('PA',l_error_message_code);
3179: fnd_msg_pub.add;
3180: end if;
3181:
3182: l_msg_count := FND_MSG_PUB.count_msg;
3183: if l_msg_count > 0 then
3184: x_msg_count := l_msg_count;
3185: if x_msg_count = 1 then
3186: pa_interface_utils_pub.get_messages

Line 3232: x_msg_count := FND_MSG_PUB.count_msg;

3228: ,x_msg_count => l_msg_count
3229: ,x_msg_data => l_msg_data );
3230:
3231: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3232: x_msg_count := FND_MSG_PUB.count_msg;
3233: if x_msg_count = 1 then
3234: pa_interface_utils_pub.get_messages
3235: (p_encoded => FND_API.G_TRUE,
3236: p_msg_index => 1,

Line 3279: x_msg_count := FND_MSG_PUB.count_msg;

3275: ,x_msg_count => l_msg_count
3276: ,x_msg_data => l_msg_data );
3277:
3278: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3279: x_msg_count := FND_MSG_PUB.count_msg;
3280: if x_msg_count = 1 then
3281: pa_interface_utils_pub.get_messages
3282: (p_encoded => FND_API.G_TRUE,
3283: p_msg_index => 1,

Line 3327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

3323: if p_commit = FND_API.G_TRUE then
3324: rollback to create_org_role;
3325: end if;
3326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
3328: p_procedure_name => 'Create_Org_Role',
3329: p_error_text => SUBSTRB(SQLERRM,1,240));
3330: when OTHERS then
3331: if p_commit = FND_API.G_TRUE then

Line 3335: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

3331: if p_commit = FND_API.G_TRUE then
3332: rollback to create_org_role;
3333: end if;
3334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3335: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
3336: p_procedure_name => 'Create_Org_Role',
3337: p_error_text => SUBSTRB(SQLERRM,1,240));
3338: raise;
3339: END CREATE_ORG_ROLE;

Line 3436: FND_MSG_PUB.initialize;

3432: SAVEPOINT project_status_change;
3433: END IF;
3434:
3435: IF p_init_msg_list = FND_API.G_TRUE THEN
3436: FND_MSG_PUB.initialize;
3437: END IF;
3438:
3439: IF l_debug_mode = 'Y' THEN
3440: PA_DEBUG.set_curr_function( p_function => 'project_status_change',

Line 3779: l_msg_count := Fnd_Msg_Pub.count_msg;

3775: IF p_commit = FND_API.G_TRUE THEN
3776: ROLLBACK TO project_status_change;
3777: END IF;
3778:
3779: l_msg_count := Fnd_Msg_Pub.count_msg;
3780: IF l_msg_count = 1 AND x_msg_data IS NULL
3781: THEN
3782: Pa_Interface_Utils_Pub.get_messages
3783: ( p_encoded => Fnd_Api.G_FALSE

Line 3808: Fnd_Msg_Pub.add_exc_msg

3804: IF p_commit = FND_API.G_TRUE THEN
3805: ROLLBACK TO project_status_change;
3806: END IF;
3807:
3808: Fnd_Msg_Pub.add_exc_msg
3809: ( p_pkg_name => 'PA_PROJECTS_MAINT_PUB'
3810: , p_procedure_name => 'project_status_change'
3811: , p_error_text => x_msg_data);
3812:

Line 3830: Fnd_Msg_Pub.add_exc_msg

3826: IF p_commit = FND_API.G_TRUE THEN
3827: ROLLBACK TO project_status_change;
3828: END IF;
3829:
3830: Fnd_Msg_Pub.add_exc_msg
3831: ( p_pkg_name => 'PA_PROJECTS_MAINT_PUB'
3832: , p_procedure_name => 'project_status_change'
3833: , p_error_text => x_msg_data);
3834: