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_PROJECT_PARTIES_PUB dependencies on PA_PROJECT_PARTIES

Line 1: package body PA_PROJECT_PARTIES_PUB as

1: package body PA_PROJECT_PARTIES_PUB as
2: /* $Header: PARPPPMB.pls 120.5.12010000.3 2009/09/08 07:25:19 anuragar ship $ */
3:
4: PROCEDURE CREATE_PROJECT_PARTY( p_api_version IN NUMBER := 1.0,
5: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

Line 67: l_api_name, 'PA_PROJECT_PARTIES_PUB') then

63: pa_debug.debug('create_project_party: Checking the api version number.');
64: end if;
65:
66: if NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
67: l_api_name, 'PA_PROJECT_PARTIES_PUB') then
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: end if;
70:
71: ------dbms_output.put_line('Before initializing the stack');

Line 89: l_project_role_id := pa_project_parties_utils.get_project_role_id(p_project_role_type,p_calling_module);

85:
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87:
88: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then
89: l_project_role_id := pa_project_parties_utils.get_project_role_id(p_project_role_type,p_calling_module);
90: else
91: l_project_role_id := p_project_role_id;
92: end if;
93: --dbms_output.put_line('Check2');

Line 95: l_resource_source_id := pa_project_parties_utils.get_resource_source_id(p_resource_name);

91: l_project_role_id := p_project_role_id;
92: end if;
93: --dbms_output.put_line('Check2');
94: /* if p_resource_source_id is null or p_resource_source_id = FND_API.G_MISS_NUM then
95: l_resource_source_id := pa_project_parties_utils.get_resource_source_id(p_resource_name);
96: else
97: l_resource_source_id := p_resource_source_id;
98: end if; */
99:

Line 102: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_DATES(p_project_id => p_project_id,

98: end if; */
99:
100:
101: if p_project_id is not null and p_project_id <> FND_API.G_MISS_NUM then
102: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_DATES(p_project_id => p_project_id,
103: x_project_start_date => l_project_start_date,
104: x_project_end_date => l_project_end_date,
105: x_return_status => x_return_status);
106: end if;

Line 144: l_resource_source_id := pa_project_parties_utils.get_resource_source_id(p_resource_name);

140: end if;
141: */
142:
143: /* if p_resource_source_id is null or p_resource_source_id = FND_API.G_MISS_NUM then
144: l_resource_source_id := pa_project_parties_utils.get_resource_source_id(p_resource_name);
145: else
146: l_resource_source_id := p_resource_source_id;
147: end if; */
148:

Line 257: PA_PROJECT_PARTIES_PVT.CREATE_PROJECT_PARTY( p_commit => p_commit,

253: -- dbms_output.put_line('Return Status '||x_return_status);
254:
255: if l_project_role_id <> -999 and l_resource_source_id <> -999 and x_return_status = FND_API.G_RET_STS_SUCCESS then
256: --dbms_output.put_line('Check6');
257: PA_PROJECT_PARTIES_PVT.CREATE_PROJECT_PARTY( p_commit => p_commit,
258: p_validate_only => p_validate_only,
259: p_validation_level => p_validation_level,
260: p_debug_mode => p_debug_mode,
261: p_object_id => p_object_id,

Line 305: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');

301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: --dbms_output.put_line('Check10');
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
305: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
306: fnd_message.set_token('PROCEDURE_NAME','CREATE_PROJECT_PARTY');
307: fnd_msg_pub.add();
308: fnd_msg_pub.count_and_get(p_count => x_msg_count,
309: p_data => x_msg_data);

Line 315: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',

311:
312: WHEN OTHERS THEN
313: rollback to create_project_party;
314: x_return_status := fnd_api.g_ret_sts_error;
315: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',
316: p_procedure_name => pa_debug.G_err_stack,
317: p_error_text => SUBSTRB(SQLERRM,1,240));
318: raise;
319:

Line 380: l_api_name, 'PA_PROJECT_PARTIES_PUB') then

376: pa_debug.debug('Update_project_party: Checking he api version number.');
377: end if;
378:
379: if NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
380: l_api_name, 'PA_PROJECT_PARTIES_PUB') then
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: end if;
383:
384: ------dbms_output.put_line('Before initializing the stack');

Line 402: l_project_role_id := pa_project_parties_utils.get_project_role_id(p_project_role_type,p_calling_module);

398:
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400:
401: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then
402: l_project_role_id := pa_project_parties_utils.get_project_role_id(p_project_role_type,p_calling_module);
403: else
404: l_project_role_id := p_project_role_id;
405: end if;
406:

Line 408: l_resource_source_id := pa_project_parties_utils.get_resource_source_id(p_resource_name);

404: l_project_role_id := p_project_role_id;
405: end if;
406:
407: /* if p_resource_source_id is null or p_resource_source_id = FND_API.G_MISS_NUM then
408: l_resource_source_id := pa_project_parties_utils.get_resource_source_id(p_resource_name);
409: else
410: l_resource_source_id := p_resource_source_id;
411: end if; */
412:

Line 414: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_DATES(p_project_id => p_project_id,

410: l_resource_source_id := p_resource_source_id;
411: end if; */
412:
413: if p_project_id is not null and p_project_id <> FND_API.G_MISS_NUM then
414: PA_PROJECT_PARTIES_UTILS.GET_PROJECT_DATES(p_project_id => p_project_id,
415: x_project_start_date => l_project_start_date,
416: x_project_end_date => l_project_end_date,
417: x_return_status => x_return_status);
418: end if;

Line 463: PA_PROJECT_PARTIES_PVT.UPDATE_PROJECT_PARTY( p_commit => p_commit,

459: fnd_msg_pub.add;
460: end if;
461:
462: if l_project_role_id <> -999 and l_resource_source_id <> -999 and x_return_status = FND_API.G_RET_STS_SUCCESS then
463: PA_PROJECT_PARTIES_PVT.UPDATE_PROJECT_PARTY( p_commit => p_commit,
464: p_validate_only => p_validate_only,
465: p_validation_level => p_validation_level,
466: p_debug_mode => p_debug_mode,
467: p_object_id => p_object_id,

Line 512: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');

508: EXCEPTION
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
512: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
513: fnd_message.set_token('PROCEDURE_NAME','UPDATE_PROJECT_PARTY');
514: fnd_msg_pub.add();
515: fnd_msg_pub.count_and_get(p_count => x_msg_count,
516: p_data => x_msg_data);

Line 523: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',

519:
520: WHEN OTHERS THEN
521: rollback to update_project_party;
522: x_return_status := fnd_api.g_ret_sts_error;
523: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',
524: p_procedure_name => pa_debug.g_err_stack,
525: p_error_text => SUBSTRB(SQLERRM,1,240));
526: raise;
527:

Line 560: (select resource_source_id from pa_project_parties where project_party_id=p_project_party_id

556: l_task_cnt NUMBER := 0;
557: --Changes for 8726175
558: cursor task_cnt_crsr is
559: select count(pt.task_id) from pa_tasks pt where project_id=p_project_id and task_manager_person_id =
560: (select resource_source_id from pa_project_parties where project_party_id=p_project_party_id
561: and project_id=p_project_id)
562: and exists
563: (select 1 from pa_progress_rollup where project_id=pt.project_id and proj_element_id = pt.task_id
564: and structure_version_id is null

Line 573: l_api_name, 'PA_PROJECT_PARTIES_PUB') then

569: pa_debug.debug('Delete_project_party: Checking he api version number.');
570: end if;
571:
572: if NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
573: l_api_name, 'PA_PROJECT_PARTIES_PUB') then
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: end if;
576:
577: ------dbms_output.put_line('Before initializing the stack');

Line 624: PA_PROJECT_PARTIES_PVT.DELETE_PROJECT_PARTY( p_commit => p_commit,

620: ,x_msg_count => x_msg_count
621: ,x_msg_data => x_msg_data
622: );
623: else
624: PA_PROJECT_PARTIES_PVT.DELETE_PROJECT_PARTY( p_commit => p_commit,
625: p_validate_only => p_validate_only,
626: p_validation_level => p_validation_level,
627: p_debug_mode => p_debug_mode,
628: p_record_version_number => p_record_version_number,

Line 660: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');

656:
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
660: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
661: fnd_message.set_token('PROCEDURE_NAME','DELETE_PROJECT_PARTY');
662: fnd_msg_pub.add();
663: fnd_msg_pub.count_and_get(p_count => x_msg_count,
664: p_data => x_msg_data);

Line 684: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECT_PARTIES');

680: end if;
681:
682: if(SQLCODE = -54) then
683: FND_MESSAGE.Set_Name('PA', 'PA_XC_ROW_ALREADY_LOCKED');
684: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECT_PARTIES');
685: FND_MESSAGE.Set_token('PROJECT',to_char(P_PROJECT_ID));
686: FND_MESSAGE.Set_token('TASK',NULL);
687: x_msg_data := FND_MESSAGE.get;
688: x_return_status := FND_API.G_RET_STS_ERROR;

Line 690: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',

686: FND_MESSAGE.Set_token('TASK',NULL);
687: x_msg_data := FND_MESSAGE.get;
688: x_return_status := FND_API.G_RET_STS_ERROR;
689: else
690: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',
691: p_procedure_name => pa_debug.g_err_stack,
692: p_error_text => SUBSTRB(SQLERRM,1,240));
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: end if;

Line 842: l_project_role_id := pa_project_parties_utils.get_project_role_id(p_project_role_type,p_calling_module);

838: x_msg_count := 0;
839:
840: /* get the project_role_id */
841: if p_project_role_id is null or p_project_role_id = FND_API.G_MISS_NUM then
842: l_project_role_id := pa_project_parties_utils.get_project_role_id(p_project_role_type,p_calling_module);
843: else
844: l_project_role_id := p_project_role_id;
845: end if;
846:

Line 881: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(

877: /* calling CREATE_PROJECT_PARTY unconditionally for all the key members
878: This flow is similar to AMG API. Instead of calling add_key_members , we
879: are directly calling create_project_party, after checking if a PM is being
880: terminated */
881: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
882: p_validate_only => p_validate_only
883: , p_object_id => p_object_id
884: , p_OBJECT_TYPE => p_OBJECT_TYPE
885: , p_project_role_id => p_project_role_id

Line 960: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',

956: x_wf_process := null;
957: x_msg_count := 1;
958: x_msg_data := SUBSTRB(SQLERRM,1,240);
959:
960: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',
961: p_procedure_name => 'CREATE_PROJECT_PARTY_WRP',
962: p_error_text => x_msg_data);
963:
964: END CREATE_PROJECT_PARTY_WRP;