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 PA_PROJECTS_MAINT_PVT

Line 1: PACKAGE BODY PA_PROJECTS_MAINT_PVT AS

1: PACKAGE BODY PA_PROJECTS_MAINT_PVT AS
2: /* $Header: PARMPRVB.pls 120.10.12010000.6 2009/10/13 11:19:04 nkapling ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECTS_MAINT_PVT';
4: -- API name : create_project
5: -- Type : Private

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECTS_MAINT_PVT';

1: PACKAGE BODY PA_PROJECTS_MAINT_PVT AS
2: /* $Header: PARMPRVB.pls 120.10.12010000.6 2009/10/13 11:19:04 nkapling ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECTS_MAINT_PVT';
4: -- API name : create_project
5: -- Type : Private
6: -- Pre-reqs : None.
7: -- Parameters :

Line 189: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PVT.CREATE_PROJECT ... ');

185: if (p_debug_mode = 'Y') then
186: pa_debug.debug('Create_Project PVT: Checking the api version number.');
187: end if;
188:
189: --dbms_output.put_line('Starts here PA_PROJECTS_MAINT_PVT.CREATE_PROJECT ... ');
190:
191: IF p_commit = FND_API.G_TRUE THEN
192: SAVEPOINT prm_create_project;
193: END IF;

Line 472: PA_PROJECTS_MAINT_PVT.CREATE_CUSTOMER

468:
469: if (p_debug_mode = 'Y') then
470: pa_debug.debug('Create_Project PVT: Calling create customer private API');
471: end if;
472: PA_PROJECTS_MAINT_PVT.CREATE_CUSTOMER
473: ( p_commit => FND_API.G_FALSE ,
474: p_validate_only => p_validate_only ,
475: p_validation_level => p_validation_level ,
476: p_debug_mode => p_debug_mode ,

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 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 1317: PA_PROJECTS_MAINT_PVT.Validate_Project_Info

1313: l_calling_module := 'BASIC_INFO';
1314: end if;
1315: --Code ends for bug 7204572
1316:
1317: PA_PROJECTS_MAINT_PVT.Validate_Project_Info
1318: (
1319: p_validation_level => p_validation_level,
1320: p_calling_module => l_calling_module, -- bug 7204572 changed 'BASIC_INFO' to l_calling_module
1321: p_debug_mode => p_debug_mode,

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 2019: --dbms_output.put_line('PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO Project Data ');

2015: END IF;
2016:
2017: -- write your program logic from here
2018:
2019: --dbms_output.put_line('PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO Project Data ');
2020:
2021: if p_validation_level > 0 then
2022: pa_debug.G_err_stage := 'Calling validate additional Info';
2023: if (p_debug_mode = 'Y') then

Line 2026: PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO

2022: pa_debug.G_err_stage := 'Calling validate additional Info';
2023: if (p_debug_mode = 'Y') then
2024: pa_debug.debug('Update_project_additional_info PVT: Calling validate project info API');
2025: end if;
2026: PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO
2027: (
2028: p_validation_level => p_validation_level,
2029: p_calling_module => 'ADDITIONAL_INFORMATION',
2030: p_action => 'UPDATE',

Line 2475: PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO

2471: pa_debug.G_err_stage := 'Calling validate pipeline Info';
2472: if (p_debug_mode = 'Y') then
2473: pa_debug.debug('Update_project_pipeline_info PVT: Calling validate project API');
2474: end if;
2475: PA_PROJECTS_MAINT_PVT.VALIDATE_PROJECT_INFO
2476: ( p_validation_level => p_validation_level,
2477: p_calling_module => 'PIPELINE',
2478: p_action => 'UPDATE',
2479: p_debug_mode => p_debug_mode,

Line 2663: --dbms_output.put_line('PA_PROJECTS_MAINT_PVT.CREATE_CLASSIFICATION ');

2659: l_application_id NUMBER;
2660:
2661: BEGIN
2662:
2663: --dbms_output.put_line('PA_PROJECTS_MAINT_PVT.CREATE_CLASSIFICATION ');
2664:
2665: IF p_commit = FND_API.G_TRUE THEN
2666: SAVEPOINT create_classifications_pvt;
2667: END IF;

Line 2678: --dbms_output.put_line('PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS Before ');

2674: end if;
2675:
2676: pa_debug.G_err_stage := 'Calling validate_classifications';
2677:
2678: --dbms_output.put_line('PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS Before ');
2679:
2680: if (p_debug_mode = 'Y') then
2681: pa_debug.debug('Create classification PVT: Calling validate_classification API ');
2682: end if;

Line 2686: PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS

2682: end if;
2683:
2684: l_code_percentage := p_code_percentage;
2685:
2686: PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS
2687: (
2688: p_validation_level => p_validation_level,
2689: p_calling_module => p_calling_module,
2690: p_action => 'INSERT',

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 3038: pa_debug.debug('PA_PROJECTS_MAINT_PVT.Update_Classifications BEGIN');

3034: -- anlee end of changes
3035:
3036: BEGIN
3037: if (p_debug_mode = 'Y') then
3038: pa_debug.debug('PA_PROJECTS_MAINT_PVT.Update_Classifications BEGIN');
3039: end if;
3040:
3041: if p_commit = FND_API.G_TRUE then
3042: savepoint update_classifications_pvt;

Line 3118: PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS

3114: end if;
3115:
3116: l_code_percentage := p_code_percentage;
3117:
3118: PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS
3119: (
3120: p_validation_level => p_validation_level,
3121: p_calling_module => p_calling_module,
3122: p_action => 'UPDATE',

Line 3329: pa_debug.debug('PA_PROJECTS_MAINT_PVT.Update_Classifications END');

3325: commit work;
3326: end if;
3327:
3328: if (p_debug_mode = 'Y') then
3329: pa_debug.debug('PA_PROJECTS_MAINT_PVT.Update_Classifications END');
3330: end if;
3331:
3332: EXCEPTION
3333: when FND_API.G_EXC_ERROR then

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 3877: PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS

3873: pa_debug.G_err_stage := 'Calling validate_classifications';
3874: if (p_debug_mode = 'Y') then
3875: pa_debug.debug('Delete classification PVT: Calling API to validate classfications');
3876: end if;
3877: PA_PROJECTS_MAINT_PVT.VALIDATE_CLASSIFICATIONS
3878: (
3879: p_validation_level => p_validation_level,
3880: p_calling_module => p_calling_module,
3881: p_action => 'DELETE',

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

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

Line 5772: END PA_PROJECTS_MAINT_PVT;

5768: raise;
5769:
5770: END UPDATE_PROJECT_STAFFING_INFO;
5771:
5772: END PA_PROJECTS_MAINT_PVT;