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_PVT dependencies on FND_MSG_PUB

Line 369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

365: pa_debug.debug('Create_Project PVT: Checking error messages returned from copy project');
366: end if;
367: IF l_err_code > 0
368: THEN
369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
370: THEN
371: /* IF NOT pa_project_pvt.check_valid_message(l_err_stage)
372: THEN
373: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 413: /* IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

409: x_return_status := FND_API.G_RET_STS_ERROR;
410:
411: ELSIF l_err_code < 0
412: THEN
413: /* IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
414: THEN
415: PA_UTILS.ADD_MESSAGE
416: (p_app_short_name => 'PA',
417: p_msg_name => 'PA_PROJ_COPY_PROJECT_FAILED');

Line 434: l_msg_count := FND_MSG_PUB.count_msg;

430: p_new_project_number := l_project_number_out;
431:
432: end if; -- p_validate_only = 'Y'
433:
434: l_msg_count := FND_MSG_PUB.count_msg;
435:
436: --dbms_output.put_line('MSG_COUNT : CREATE_PROJECT ERROR : '||to_char(l_msg_count));
437:
438: IF l_msg_count > 0 THEN

Line 494: l_msg_count := FND_MSG_PUB.count_msg;

490: --dbms_output.put_line('IN create_customer call ... '||l_return_status);
491:
492: END IF;
493:
494: l_msg_count := FND_MSG_PUB.count_msg;
495:
496: --dbms_output.put_line('After create_customer call ... '||to_char(l_msg_count));
497:
498: IF l_msg_count > 0 THEN

Line 526: l_msg_count := FND_MSG_PUB.count_msg;

522: ,x_return_status => l_return_status
523: ,x_msg_count => l_msg_count
524: ,x_msg_data => l_msg_data );
525:
526: l_msg_count := FND_MSG_PUB.count_msg;
527:
528: IF l_msg_count > 0 THEN
529: x_msg_count := l_msg_count;
530: RAISE FND_API.G_EXC_ERROR;

Line 545: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

541: IF p_commit = FND_API.G_TRUE THEN
542: ROLLBACK TO prm_create_project;
543: END IF;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
546: p_procedure_name => 'CREATE_PROJECT',
547: p_error_text => SUBSTRB(SQLERRM,1,240));
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549:

Line 561: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

557: IF p_commit = FND_API.G_TRUE THEN
558: ROLLBACK TO prm_create_project;
559: END IF;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
562: p_procedure_name => 'CREATE_PROJECT',
563: p_error_text => SUBSTRB(SQLERRM,1,240));
564: raise;
565:

Line 765: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

761: end if;
762: IF l_err_code > 10
763: THEN
764:
765: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
766: THEN
767: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
768: THEN
769: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

780: x_return_status := 'E';
781:
782: ELSIF l_err_code < 0
783: THEN
784: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
785: THEN
786: PA_UTILS.ADD_MESSAGE
787: (p_app_short_name => 'PA',
788: p_msg_name => 'PA_PROJ_GET_CUST_INFO_FAILED');

Line 883: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

879: pa_debug.debug('Create_customer PVT: Checking errors returned from create_customer_contacts API');
880: end if;
881: IF l_err_code > 0
882: THEN
883: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
884: THEN
885: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
886: THEN
887: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 910: l_msg_count := FND_MSG_PUB.count_msg;

906: END IF;
907:
908: --dbms_output.put_line('RETURN STATUS : CREATE_CUSTOMER ERROR : '||x_return_status);
909:
910: l_msg_count := FND_MSG_PUB.count_msg;
911:
912: --dbms_output.put_line('MSG_COUNT : CREATE_CUSTOMER ERROR : '||to_char(l_msg_count));
913:
914: IF l_msg_count > 0 THEN

Line 956: l_msg_count := FND_MSG_PUB.count_msg;

952: , x_return_status => l_return_status
953: , x_msg_count => l_msg_count
954: , x_msg_data => l_msg_data );
955:
956: l_msg_count := FND_MSG_PUB.count_msg;
957: IF l_msg_count > 0 THEN
958: x_msg_count := l_msg_count;
959: x_return_status := 'E';
960: RAISE FND_API.G_EXC_ERROR;

Line 984: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

980: IF p_commit = FND_API.G_TRUE THEN
981: ROLLBACK TO prm_create_customer;
982: END IF;
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
985: p_procedure_name => 'CREATE_CUSTOMER',
986: p_error_text => SUBSTRB(SQLERRM,1,240));
987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
988:

Line 1000: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

996: IF p_commit = FND_API.G_TRUE THEN
997: ROLLBACK TO prm_create_customer;
998: END IF;
999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1000: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
1001: p_procedure_name => 'CREATE_CUSTOMER',
1002: p_error_text => SUBSTRB(SQLERRM,1,240));
1003: raise;
1004:

Line 1294: l_msg_count := FND_MSG_PUB.count_msg;

1290: x_return_status := 'E' ;
1291: END IF;
1292: END;
1293: end if;
1294: l_msg_count := FND_MSG_PUB.count_msg;
1295:
1296: IF l_msg_count > 0 THEN
1297: x_msg_count := l_msg_count;
1298: x_return_status := 'E';

Line 1350: l_msg_count := FND_MSG_PUB.count_msg;

1346: -- Project Long Name changes
1347: p_long_name => p_long_name );
1348: -- End of changes
1349:
1350: l_msg_count := FND_MSG_PUB.count_msg;
1351:
1352: IF l_msg_count > 0 THEN
1353: x_msg_count := l_msg_count;
1354: x_return_status := 'E';

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

1611: END IF;
1612:
1613: EXCEPTION WHEN OTHERS THEN
1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1616: p_procedure_name => 'UPDATE_PROJECT_BASIC_INFO',
1617: p_error_text => SUBSTRB(SQLERRM,1,240));
1618: rollback to copy_project;
1619: return;

Line 1637: l_msg_count := FND_MSG_PUB.count_msg;

1633: ,p_project_long_name => p_long_name
1634: ,p_project_description => l_description
1635: ,x_return_status => l_return_status );
1636:
1637: l_msg_count := FND_MSG_PUB.count_msg;
1638:
1639: IF l_msg_count > 0 THEN
1640: x_msg_count := l_msg_count;
1641: x_return_status := 'E';

Line 1663: l_msg_count := FND_MSG_PUB.count_msg;

1659: ,x_return_status => l_return_status
1660: ,x_msg_count => l_msg_count
1661: ,x_msg_data => l_msg_data );
1662:
1663: l_msg_count := FND_MSG_PUB.count_msg;
1664:
1665: IF l_msg_count > 0 THEN
1666: x_msg_count := l_msg_count;
1667: x_return_status := 'E';

Line 1794: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

1790: IF p_commit = FND_API.G_TRUE THEN
1791: ROLLBACK TO update_project_basic_info;
1792: END IF;
1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
1795: p_procedure_name => 'UPDATE_PROJECT_BASIC_INFO',
1796: p_error_text => SUBSTRB(SQLERRM,1,240));
1797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1798:

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

1806: IF p_commit = FND_API.G_TRUE THEN
1807: ROLLBACK TO update_project_basic_info;
1808: END IF;
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1810: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
1811: p_procedure_name => 'UPDATE_PROJECT_BASIC_INFO',
1812: p_error_text => SUBSTRB(SQLERRM,1,240));
1813: raise;
1814:

Line 2009: l_msg_count := FND_MSG_PUB.count_msg;

2005: raise;
2006: END IF;
2007: END;
2008: end if;
2009: l_msg_count := FND_MSG_PUB.count_msg;
2010:
2011: IF l_msg_count > 0 THEN
2012: x_msg_count := l_msg_count;
2013: x_return_status := 'E';

Line 2041: l_msg_count := FND_MSG_PUB.count_msg;

2037: p_cost_job_group_id => p_cost_job_group_id,
2038: p_bill_job_group_id => p_bill_job_group_id,
2039: p_record_version_number => p_record_version_number);
2040:
2041: l_msg_count := FND_MSG_PUB.count_msg;
2042:
2043: IF l_msg_count > 0 THEN
2044: x_msg_count := l_msg_count;
2045: x_return_status := 'E';

Line 2218: l_msg_count := FND_MSG_PUB.count_msg;

2214: ,x_msg_count => l_msg_count
2215: ,x_msg_data => l_msg_data
2216: ,x_return_status => l_return_status);
2217:
2218: l_msg_count := FND_MSG_PUB.count_msg;
2219:
2220: IF l_msg_count > 0 THEN
2221: x_msg_count := l_msg_count;
2222: x_return_status := 'E';

Line 2238: l_msg_count := FND_MSG_PUB.count_msg;

2234: ,x_msg_count => l_msg_count
2235: ,x_msg_data => l_msg_data
2236: );
2237:
2238: l_msg_count := FND_MSG_PUB.count_msg;
2239:
2240: IF l_msg_count > 0 THEN
2241: x_msg_count := l_msg_count;
2242: x_return_status := 'E';

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

2311: IF p_commit = FND_API.G_TRUE THEN
2312: ROLLBACK TO update_project_additional_info;
2313: END IF;
2314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2315: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2316: p_procedure_name => 'UPDATE_PROJECT_ADDITIONAL_INFO',
2317: p_error_text => SUBSTRB(SQLERRM,1,240));
2318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2319:

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

2327: IF p_commit = FND_API.G_TRUE THEN
2328: ROLLBACK TO update_project_additional_info;
2329: END IF;
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2331: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2332: p_procedure_name => 'UPDATE_PROJECT_ADDITIONAL_INFO',
2333: p_error_text => SUBSTRB(SQLERRM,1,240));
2334: raise;
2335:

Line 2462: l_msg_count := FND_MSG_PUB.count_msg;

2458: raise;
2459: END IF;
2460: END;
2461: end if;
2462: l_msg_count := FND_MSG_PUB.count_msg;
2463:
2464: IF l_msg_count > 0 THEN
2465: x_msg_count := l_msg_count;
2466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2487: l_msg_count := FND_MSG_PUB.count_msg;

2483: p_project_value => p_project_value,
2484: p_expected_approval_date => p_expected_approval_date,
2485: p_record_version_number => p_record_version_number);
2486:
2487: l_msg_count := FND_MSG_PUB.count_msg;
2488:
2489: IF l_msg_count > 0 THEN
2490: x_msg_count := l_msg_count;
2491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2534: IF p_commit = FND_API.G_TRUE THEN
2535: ROLLBACK TO update_project_pipeline_info;
2536: END IF;
2537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2538: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2539: p_procedure_name => 'UPDATE_PROJECT_PIPELINE_INFO',
2540: p_error_text => SUBSTRB(SQLERRM,1,240));
2541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2542:

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

2550: IF p_commit = FND_API.G_TRUE THEN
2551: ROLLBACK TO update_project_pipeline_info;
2552: END IF;
2553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2554: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
2555: p_procedure_name => 'UPDATE_PROJECT_PIPELINE_INFO',
2556: p_error_text => SUBSTRB(SQLERRM,1,240));
2557: raise;
2558:

Line 2699: l_msg_count := FND_MSG_PUB.count_msg;

2695: p_class_category => p_class_category,
2696: p_class_code => p_class_code,
2697: p_code_percentage => l_code_percentage);
2698:
2699: l_msg_count := FND_MSG_PUB.count_msg;
2700:
2701: --dbms_output.put_line('VALIDATE_CLASSIFICATIONS '||to_char(l_msg_count));
2702:
2703: IF l_msg_count > 0 THEN

Line 2892: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

2888: IF p_commit = FND_API.G_TRUE THEN
2889: ROLLBACK TO create_classifications_pvt;
2890: END IF;
2891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2892: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
2893: p_procedure_name => 'CREATE_CLASSIFICATIONS',
2894: p_error_text => SUBSTRB(SQLERRM,1,240));
2895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2896:

Line 2908: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

2904: IF p_commit = FND_API.G_TRUE THEN
2905: ROLLBACK TO create_classifications_pvt;
2906: END IF;
2907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2908: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
2909: p_procedure_name => 'CREATE_CLASSIFICATIONS',
2910: p_error_text => SUBSTRB(SQLERRM,1,240));
2911: raise;
2912:

Line 3102: l_msg_count := FND_MSG_PUB.count_msg;

3098: raise;
3099: END;
3100: end if;
3101:
3102: l_msg_count := FND_MSG_PUB.count_msg;
3103: if l_msg_count > 0 then
3104: x_msg_count := l_msg_count;
3105: if x_msg_count = 1 then
3106: x_msg_data := l_msg_data;

Line 3132: l_msg_count := FND_MSG_PUB.count_msg;

3128: p_class_code => p_class_code,
3129: p_code_percentage => l_code_percentage,
3130: p_rowid => p_rowid);
3131:
3132: l_msg_count := FND_MSG_PUB.count_msg;
3133: if l_msg_count > 0 then
3134: x_msg_count := l_msg_count;
3135:
3136: raise FND_API.G_EXC_ERROR;

Line 3293: l_msg_count := FND_MSG_PUB.count_msg;

3289: ,x_return_status => l_return_status
3290: ,x_msg_count => l_msg_count
3291: ,x_msg_data => l_msg_data );
3292:
3293: l_msg_count := FND_MSG_PUB.count_msg;
3294:
3295: IF l_msg_count > 0 THEN
3296: x_msg_count := l_msg_count;
3297: x_return_status := 'E';

Line 3312: l_msg_count := FND_MSG_PUB.count_msg;

3308: ,x_return_status => l_return_status
3309: ,x_msg_count => l_msg_count
3310: ,x_msg_data => l_msg_data );
3311:
3312: l_msg_count := FND_MSG_PUB.count_msg;
3313:
3314: IF l_msg_count > 0 THEN
3315: x_msg_count := l_msg_count;
3316: x_return_status := 'E';

Line 3343: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

3339: if p_commit = FND_API.G_TRUE then
3340: rollback to update_classifications_pvt;
3341: end if;
3342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3343: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
3344: p_procedure_name => 'Update_Classifications',
3345: p_error_text => SUBSTRB(SQLERRM,1,240));
3346: raise;
3347: END UPDATE_CLASSIFICATIONS;

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

3696: --dbms_output.put_line('SUCCESSFUL VALIDATION OVER ... '||l_error_msg_code||'Status :'||l_return_status);
3697:
3698: EXCEPTION
3699: when FND_API.G_EXC_UNEXPECTED_ERROR then
3700: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
3701: p_procedure_name => 'VALIDATE_CLASSIFICATIONS',
3702: p_error_text => SUBSTRB(SQLERRM,1,240));
3703: WHEN OTHERS THEN
3704: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',

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

3700: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
3701: p_procedure_name => 'VALIDATE_CLASSIFICATIONS',
3702: p_error_text => SUBSTRB(SQLERRM,1,240));
3703: WHEN OTHERS THEN
3704: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
3705: p_procedure_name => 'VALIDATE_CLASSIFICATIONS',
3706: p_error_text => SUBSTRB(SQLERRM,1,240));
3707: raise;
3708:

Line 3864: l_msg_count := FND_MSG_PUB.count_msg;

3860: END IF;
3861: END;
3862:
3863: END IF;
3864: l_msg_count := FND_MSG_PUB.count_msg;
3865:
3866: IF l_msg_count > 0 THEN
3867: x_msg_count := l_msg_count;
3868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3891: l_msg_count := FND_MSG_PUB.count_msg;

3887: p_class_code => p_class_Code,
3888: p_code_percentage => l_code_percentage,
3889: p_rowid => l_row_id);
3890:
3891: l_msg_count := FND_MSG_PUB.count_msg;
3892:
3893: IF l_msg_count > 0 THEN
3894: x_msg_count := l_msg_count;
3895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3924: l_msg_count := FND_MSG_PUB.count_msg;

3920: ,x_return_status => l_return_status
3921: ,x_msg_count => l_msg_count
3922: ,x_msg_data => l_msg_data );
3923:
3924: l_msg_count := FND_MSG_PUB.count_msg;
3925:
3926: IF l_msg_count > 0 THEN
3927: x_msg_count := l_msg_count;
3928: x_return_status := 'E';

Line 3946: l_msg_count := FND_MSG_PUB.count_msg;

3942: ,x_return_status => l_return_status
3943: ,x_msg_count => l_msg_count
3944: ,x_msg_data => l_msg_data );
3945:
3946: l_msg_count := FND_MSG_PUB.count_msg;
3947:
3948: IF l_msg_count > 0 THEN
3949: x_msg_count := l_msg_count;
3950: x_return_status := 'E';

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

3963: IF p_commit = FND_API.G_TRUE THEN
3964: ROLLBACK TO delete_classifications_pvt;
3965: END IF;
3966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3967: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
3968: p_procedure_name => 'DELETE_CLASSIFICATIONS',
3969: p_error_text => SUBSTRB(SQLERRM,1,240));
3970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3971:

Line 3983: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

3979: IF p_commit = FND_API.G_TRUE THEN
3980: ROLLBACK TO prm_create_project;
3981: END IF;
3982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3983: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
3984: p_procedure_name => 'DELETE_CLASSIFICATIONS',
3985: p_error_text => SUBSTRB(SQLERRM,1,240));
3986: raise;
3987:

Line 4387: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4383: TO_NUMBER(p_project_number);
4384: END IF; -- PA_PROJECT_UTILS.GetProjNumType
4385: EXCEPTION
4386: WHEN VALUE_ERROR THEN
4387: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4388: THEN
4389: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4390: p_msg_name => 'PA_PR_NUMERIC_NUM_REQ');
4391: END IF; -- FND_MSG_PUB.check_msg_level

Line 4391: END IF; -- FND_MSG_PUB.check_msg_level

4387: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4388: THEN
4389: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4390: p_msg_name => 'PA_PR_NUMERIC_NUM_REQ');
4391: END IF; -- FND_MSG_PUB.check_msg_level
4392: END ;
4393:
4394: END IF; -- l_err_code
4395:

Line 5498: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',

5494:
5495: close l_project_details_csr;
5496:
5497: EXCEPTION WHEN OTHERS THEN
5498: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PVT',
5499: p_procedure_name => 'VALIDATE_PROJECT_INFO',
5500: p_error_text => SUBSTRB(SQLERRM,1,240));
5501: raise;
5502:

Line 5654: l_msg_count := FND_MSG_PUB.count_msg;

5650: raise;
5651: END IF;
5652: END;
5653: end if;
5654: l_msg_count := FND_MSG_PUB.count_msg;
5655:
5656: IF l_msg_count > 0 THEN
5657: x_msg_count := l_msg_count;
5658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5743: IF p_commit = FND_API.G_TRUE THEN
5744: ROLLBACK TO update_project_staffing_info;
5745: END IF;
5746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5747: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
5748: p_procedure_name => 'UPDATE_PROJECT_STAFFING_INFO',
5749: p_error_text => SUBSTRB(SQLERRM,1,240));
5750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5751:

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

5759: IF p_commit = FND_API.G_TRUE THEN
5760: ROLLBACK TO update_project_staffing_info;
5761: END IF;
5762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5763: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECTS_MAINT_PUB',
5764: p_procedure_name => 'UPDATE_PROJECT_STAFFING_INFO',
5765: p_error_text => SUBSTRB(SQLERRM,1,240));
5766: raise;
5767: