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 2013: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

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

Line 2019: l_msg_count := FND_MSG_PUB.count_msg;

2015: p_error_text => SUBSTRB(SQLERRM,1,240));
2016: raise;
2017: END;
2018:
2019: l_msg_count := FND_MSG_PUB.count_msg;
2020: If l_msg_count > 0 THEN
2021: x_msg_count := l_msg_count;
2022: If l_msg_count = 1 THEN
2023: pa_interface_utils_pub.get_messages

Line 2036: l_msg_count := FND_MSG_PUB.count_msg;

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

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

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

Line 2085: l_msg_count := FND_MSG_PUB.count_msg;

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

Line 2101: l_msg_count := FND_MSG_PUB.count_msg;

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

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

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

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

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

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

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

Line 2274: fnd_msg_pub.initialize;

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

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

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

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

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

Line 2333: l_msg_count := FND_MSG_PUB.count_msg;

2329: p_error_text => SUBSTRB(SQLERRM,1,240));
2330: raise;
2331: END;
2332:
2333: l_msg_count := FND_MSG_PUB.count_msg;
2334: If l_msg_count > 0 THEN
2335: x_msg_count := l_msg_count;
2336: If l_msg_count = 1 THEN
2337: pa_interface_utils_pub.get_messages

Line 2385: l_msg_count := FND_MSG_PUB.count_msg;

2381: x_return_status => l_return_status,
2382: x_msg_count => l_msg_count,
2383: x_msg_data => l_msg_data);
2384:
2385: l_msg_count := FND_MSG_PUB.count_msg;
2386: If l_msg_count > 0 THEN
2387: x_msg_count := l_msg_count;
2388: If l_msg_count = 1 THEN
2389: pa_interface_utils_pub.get_messages

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

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

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

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

Line 2517: fnd_msg_pub.initialize;

2513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2514: END IF;
2515:
2516: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
2517: fnd_msg_pub.initialize;
2518: end if;
2519:
2520: x_return_status := FND_API.G_RET_STS_SUCCESS;
2521:

Line 2547: l_msg_count := FND_MSG_PUB.count_msg;

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

Line 2563: l_msg_count := FND_MSG_PUB.count_msg;

2559: End if;
2560: RAISE FND_API.G_EXC_ERROR;
2561: End if;
2562: /*
2563: l_msg_count := FND_MSG_PUB.count_msg;
2564:
2565: IF l_msg_count = 1 THEN
2566: x_msg_count := l_msg_count;
2567: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,

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

2563: l_msg_count := FND_MSG_PUB.count_msg;
2564:
2565: IF l_msg_count = 1 THEN
2566: x_msg_count := l_msg_count;
2567: x_msg_data := FND_MSG_PUB.get(p_msg_index => 1,
2568: p_encoded => FND_API.G_TRUE);
2569: ELSE
2570: x_msg_count := l_msg_count;
2571: END IF;

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

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

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

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

Line 2714: fnd_msg_pub.initialize;

2710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2711: END IF;
2712:
2713: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
2714: fnd_msg_pub.initialize;
2715: end if;
2716:
2717: x_return_status := FND_API.G_RET_STS_SUCCESS;
2718:

Line 2775: l_msg_count := FND_MSG_PUB.count_msg;

2771: END IF;
2772: END IF;
2773:
2774:
2775: l_msg_count := FND_MSG_PUB.count_msg;
2776: If l_msg_count > 0 THEN
2777: x_msg_count := l_msg_count;
2778: If l_msg_count = 1 THEN
2779: pa_interface_utils_pub.get_messages

Line 2924: l_msg_count := FND_MSG_PUB.count_msg;

2920: x_return_status := FND_API.G_RET_STS_ERROR;
2921: END IF;
2922: END IF;
2923:
2924: l_msg_count := FND_MSG_PUB.count_msg;
2925: If l_msg_count > 0 THEN
2926: x_msg_count := l_msg_count;
2927: If l_msg_count = 1 THEN
2928: pa_interface_utils_pub.get_messages

Line 2972: l_msg_count := FND_MSG_PUB.count_msg;

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

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

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

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

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

Line 3132: FND_MSG_PUB.initialize;

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

Line 3175: fnd_msg_pub.add;

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

Line 3178: l_msg_count := FND_MSG_PUB.count_msg;

3174: fnd_message.set_name('PA',l_error_message_code);
3175: fnd_msg_pub.add;
3176: end if;
3177:
3178: l_msg_count := FND_MSG_PUB.count_msg;
3179: if l_msg_count > 0 then
3180: x_msg_count := l_msg_count;
3181: if x_msg_count = 1 then
3182: pa_interface_utils_pub.get_messages

Line 3228: x_msg_count := FND_MSG_PUB.count_msg;

3224: ,x_msg_count => l_msg_count
3225: ,x_msg_data => l_msg_data );
3226:
3227: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3228: x_msg_count := FND_MSG_PUB.count_msg;
3229: if x_msg_count = 1 then
3230: pa_interface_utils_pub.get_messages
3231: (p_encoded => FND_API.G_TRUE,
3232: p_msg_index => 1,

Line 3275: x_msg_count := FND_MSG_PUB.count_msg;

3271: ,x_msg_count => l_msg_count
3272: ,x_msg_data => l_msg_data );
3273:
3274: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3275: x_msg_count := FND_MSG_PUB.count_msg;
3276: if x_msg_count = 1 then
3277: pa_interface_utils_pub.get_messages
3278: (p_encoded => FND_API.G_TRUE,
3279: p_msg_index => 1,

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

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

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

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

Line 3431: FND_MSG_PUB.initialize;

3427: SAVEPOINT project_status_change;
3428: END IF;
3429:
3430: IF p_init_msg_list = FND_API.G_TRUE THEN
3431: FND_MSG_PUB.initialize;
3432: END IF;
3433:
3434: IF l_debug_mode = 'Y' THEN
3435: PA_DEBUG.set_curr_function( p_function => 'project_status_change',

Line 3752: l_msg_count := Fnd_Msg_Pub.count_msg;

3748: IF p_commit = FND_API.G_TRUE THEN
3749: ROLLBACK TO project_status_change;
3750: END IF;
3751:
3752: l_msg_count := Fnd_Msg_Pub.count_msg;
3753: IF l_msg_count = 1 AND x_msg_data IS NULL
3754: THEN
3755: Pa_Interface_Utils_Pub.get_messages
3756: ( p_encoded => Fnd_Api.G_FALSE

Line 3781: Fnd_Msg_Pub.add_exc_msg

3777: IF p_commit = FND_API.G_TRUE THEN
3778: ROLLBACK TO project_status_change;
3779: END IF;
3780:
3781: Fnd_Msg_Pub.add_exc_msg
3782: ( p_pkg_name => 'PA_PROJECTS_MAINT_PUB'
3783: , p_procedure_name => 'project_status_change'
3784: , p_error_text => x_msg_data);
3785:

Line 3803: Fnd_Msg_Pub.add_exc_msg

3799: IF p_commit = FND_API.G_TRUE THEN
3800: ROLLBACK TO project_status_change;
3801: END IF;
3802:
3803: Fnd_Msg_Pub.add_exc_msg
3804: ( p_pkg_name => 'PA_PROJECTS_MAINT_PUB'
3805: , p_procedure_name => 'project_status_change'
3806: , p_error_text => x_msg_data);
3807: