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

Line 1: PACKAGE BODY PA_PROJECT_PARTIES_UTILS AS

1: PACKAGE BODY PA_PROJECT_PARTIES_UTILS AS
2: /* $Header: PARPPU2B.pls 120.12 2011/12/06 21:14:11 skkoppul ship $ */
3:
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:

Line 51: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

47: /* Bug 2636791 - changes end */
48:
49: EXCEPTION WHEN OTHERS THEN
50: fnd_message.set_name('PA','PA_NO_PROJECT_ID');
51: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
52: fnd_message.set_token('PROCEDURE_NAME','GET_PROJECT_DATES');
53: fnd_msg_pub.ADD;
54: x_return_status := FND_API.G_RET_STS_ERROR;
55: END;

Line 85: FROM pa_project_parties ppp,

81: l_end_date_active DATE; --Bug 4565156 NOCOPY changes
82:
83: CURSOR c_duplicate_customer_org IS
84: SELECT 'Y'
85: FROM pa_project_parties ppp,
86: pa_project_role_types_b r1,
87: pa_project_role_types_b r2
88: WHERE r1.project_role_id = p_project_role_id
89: AND r1.role_party_class = 'CUSTOMER'

Line 132: pa_project_parties_utils.check_mandatory_fields(p_project_role_id => p_project_role_id,

128: --- call to check all mandatory fields are given
129: IF (p_debug_mode = 'Y') THEN
130: pa_debug.debug('Validate_project_party: Calling check_mandatory_fields.');
131: END IF;
132: pa_project_parties_utils.check_mandatory_fields(p_project_role_id => p_project_role_id,
133: p_resource_type_id => p_resource_type_id,
134: p_resource_source_id => p_resource_source_id,
135: p_start_date_active => p_start_date_active,
136: p_end_date_active => p_end_date_active,

Line 154: pa_project_parties_utils.Validate_role_party(p_project_role_id => p_project_role_id,

150: IF (p_debug_mode = 'Y') THEN
151: pa_debug.debug('Validate_role_party: Calling Validate_role_party.');
152: END IF;
153:
154: pa_project_parties_utils.Validate_role_party(p_project_role_id => p_project_role_id,
155: p_resource_type_id => p_resource_type_id,
156: p_resource_source_id => p_resource_source_id,
157: x_error_occured => l_error_occured);
158:

Line 168: pa_project_parties_utils.validate_dates(p_start_date_active => p_start_date_active,

164: --- call to validate the start and end dates for the person
165: IF (p_debug_mode = 'Y') THEN
166: pa_debug.debug('Validate_project_party: Calling validate_dates.');
167: END IF;
168: pa_project_parties_utils.validate_dates(p_start_date_active => p_start_date_active,
169: p_end_date_active => p_end_date_active,
170: x_error_occured => l_error_occured);
171:
172: IF (l_error_occured = 'Y') THEN

Line 199: IF (p_action = 'INSERT' OR pa_project_parties_utils.get_scheduled_flag(p_project_party_id, p_record_version_number) <> p_scheduled_flag) THEN

195: x_assignment_action := 'NOACTION';
196:
197: IF (p_calling_module NOT IN ('EXCHANGE','FORM')) THEN
198:
199: IF (p_action = 'INSERT' OR pa_project_parties_utils.get_scheduled_flag(p_project_party_id, p_record_version_number) <> p_scheduled_flag) THEN
200:
201: IF p_resource_type_id = 112 THEN
202: IF (p_debug_mode = 'Y') THEN
203: pa_debug.debug('Validate_project_party: Looking for customer org duplicate.');

Line 231: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

227: ELSE
228: --dbms_output.put_line('schedule is not allowed for this role');
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: fnd_message.set_name('PA','PA_NO_SCHEDULE_ALLOWED');
231: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
232: --fnd_message.set_token('PROCEDURE_NAME','VALIDATE_PROJECT_PARTY');
233: fnd_msg_pub.ADD;
234: END IF;
235: ELSE

Line 259: pa_project_parties_utils.get_person_party_id(p_object_type => p_object_type,

255: --dbms_output.put_line('trying to get person id');
256: IF (p_debug_mode = 'Y') THEN
257: pa_debug.debug('Validate_project_party: Getting the project party id.');
258: END IF;
259: pa_project_parties_utils.get_person_party_id(p_object_type => p_object_type,
260: p_object_id => p_object_id,
261: p_project_role_id => p_project_role_id,
262: p_resource_type_id => p_resource_type_id,
263: p_resource_source_id => p_resource_source_id,

Line 272: IF pa_project_parties_utils.get_scheduled_flag(l_project_party_id, l_record_version_number) <> 'Y' THEN

268:
269: --dbms_output.put_line('person id'||to_char(l_project_party_id));
270: IF l_project_party_id <> -999 THEN
271: x_call_overlap := 'N';
272: IF pa_project_parties_utils.get_scheduled_flag(l_project_party_id, l_record_version_number) <> 'Y' THEN
273: p_project_party_id := l_project_party_id;
274: p_record_version_number := l_record_version_number;
275: ELSE
276: --dbms_output.put_line('cannot create duplicate record');

Line 279: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

275: ELSE
276: --dbms_output.put_line('cannot create duplicate record');
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: fnd_message.set_name('PA','PA_XC_TOO_MANY_OMGRS');
279: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
280: --fnd_message.set_token('PROCEDURE_NAME','VALIDATE_PROJECT_PARTY');
281: fnd_msg_pub.ADD;
282: END IF;
283: END IF;

Line 294: pa_project_parties_utils.validate_no_overlap_manager(p_object_type => p_object_type,

290: IF p_project_role_id = 1 THEN -- hard coded for Project Manager
291: IF (p_debug_mode = 'Y') THEN
292: pa_debug.debug('Validate_project_party: Calling validate_no_overlap_manager.');
293: END IF;
294: pa_project_parties_utils.validate_no_overlap_manager(p_object_type => p_object_type,
295: p_object_id => p_object_id,
296: p_project_role_id => p_project_role_id,
297: p_project_party_id => p_project_party_id,
298: p_start_date_active => p_start_date_active,

Line 309: pa_project_parties_utils.validate_person_not_overlapped(p_object_type => p_object_type,

305: ELSE
306: IF (p_debug_mode = 'Y') THEN
307: pa_debug.debug('Validate_project_party: Calling validate_person_not_overlapped.');
308: END IF;
309: pa_project_parties_utils.validate_person_not_overlapped(p_object_type => p_object_type,
310: p_object_id => p_object_id,
311: p_project_role_id => p_project_role_id,
312: p_project_party_id => p_project_party_id,
313: p_resource_type_id => p_resource_type_id,

Line 328: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',

324:
325: EXCEPTION WHEN OTHERS THEN
326: p_end_date_active := l_end_date_active; --Bug 4565156 NOCOPY changes
327: x_return_status := fnd_api.g_ret_sts_unexp_error;
328: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',
329: p_procedure_name => 'VALIDATE_PROJECT_PARTY',
330: p_error_text => SUBSTRB(SQLERRM,1,240));
331: RAISE;
332:

Line 342: FROM pa_project_parties

338: l_scheduled_flag VARCHAR2(1);
339: BEGIN
340: pa_debug.set_err_stack('Get_scheduled_flag');
341: SELECT scheduled_flag INTO l_scheduled_flag
342: FROM pa_project_parties
343: WHERE project_party_id = NVL(p_project_party_id,-999)
344: AND record_version_number = NVL(p_record_version_number,record_version_number);
345:
346: pa_debug.reset_err_stack;

Line 352: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

348:
349: EXCEPTION
350: WHEN NO_DATA_FOUND THEN
351: fnd_message.set_name('PA','PA_NO_SCHEDULE_ALLOWED');
352: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
353: --fnd_message.set_token('FUNCTION_NAME','GET_SCHEDULED_FLAG');
354: fnd_msg_pub.ADD;
355: RETURN 'X';
356: WHEN OTHERS THEN

Line 357: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',

353: --fnd_message.set_token('FUNCTION_NAME','GET_SCHEDULED_FLAG');
354: fnd_msg_pub.ADD;
355: RETURN 'X';
356: WHEN OTHERS THEN
357: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',
358: p_procedure_name => pa_debug.g_err_stack,
359: p_error_text => SUBSTRB(SQLERRM,1,240));
360: RAISE;
361: END GET_SCHEDULED_FLAG;

Line 376: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',

372:
373: RETURN x_sch_flag;
374:
375: EXCEPTION WHEN OTHERS THEN
376: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',
377: p_procedure_name => pa_debug.g_err_stack,
378: p_error_text => SUBSTRB(SQLERRM,1,240));
379: RAISE;
380: END VALIDATE_SCHEDULE_ALLOWED;

Line 397: FROM pa_project_parties

393: pa_debug.set_err_stack('Get_person_party_id');
394: x_project_party_id := -999;
395:
396: SELECT project_party_id, record_version_number INTO x_project_party_id, x_record_version_number
397: FROM pa_project_parties
398: WHERE object_type = p_object_type
399: AND object_id = p_object_id
400: AND project_role_id = p_project_role_id
401: AND resource_type_id = p_resource_type_id

Line 411: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',

407:
408: EXCEPTION WHEN NO_DATA_FOUND THEN
409: x_project_party_id := -999;
410: WHEN OTHERS THEN
411: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',
412: p_procedure_name => pa_debug.g_err_stack,
413: p_error_text => SUBSTRB(SQLERRM,1,240));
414: RAISE;
415: END GET_PERSON_PARTY_ID;

Line 431: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

427: BEGIN
428: pa_debug.set_err_stack('Check_mandatory_fields');
429: IF p_project_Role_id IS NULL THEN
430: fnd_message.set_name('PA','PA_XC_NO_ROLE_TYPE');
431: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
432: --fnd_message.set_token('PROCEDURE_NAME','CHECK_MANDATORY_FIELDS');
433: fnd_msg_pub.ADD;
434: --dbms_output.put_line('PA_XC_NO_ROLE_TYPE');
435: x_error_occured := 'Y';

Line 440: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

436: END IF;
437:
438: IF p_resource_source_id IS NULL THEN
439: fnd_message.set_name('PA','PA_XC_NO_PERSON_ID');
440: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
441: --fnd_message.set_token('PROCEDURE_NAME','CHECK_MANDATORY_FIELDS');
442: fnd_msg_pub.ADD;
443: --dbms_output.put_line('PA_XC_NO_PERSON_ID');
444: x_error_occured := 'Y';

Line 449: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

445: END IF;
446:
447: IF p_start_date_active IS NULL THEN
448: fnd_message.set_name('PA','PA_START_DATE_IS_MISSING');
449: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
450: --fnd_message.set_token('PROCEDURE_NAME','CHECK_MANDATORY_FIELDS');
451: fnd_msg_pub.ADD;
452: --dbms_output.put_line('PA_START_DATE_IS_MISSING');
453: x_error_occured := 'Y';

Line 457: IF (p_scheduled_flag = 'Y' AND pa_project_parties_utils.validate_schedule_allowed(p_project_role_id)='Y') THEN

453: x_error_occured := 'Y';
454: END IF;
455:
456: IF p_end_date_active IS NULL THEN
457: IF (p_scheduled_flag = 'Y' AND pa_project_parties_utils.validate_schedule_allowed(p_project_role_id)='Y') THEN
458: IF p_project_end_date IS NULL OR p_project_end_date < p_start_date_active THEN
459: fnd_message.set_name('PA','PA_END_DATE_IS_MISSING');
460: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
461: --fnd_message.set_token('PROCEDURE_NAME','CHECK_MANDATORY_FIELDS');

Line 460: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

456: IF p_end_date_active IS NULL THEN
457: IF (p_scheduled_flag = 'Y' AND pa_project_parties_utils.validate_schedule_allowed(p_project_role_id)='Y') THEN
458: IF p_project_end_date IS NULL OR p_project_end_date < p_start_date_active THEN
459: fnd_message.set_name('PA','PA_END_DATE_IS_MISSING');
460: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
461: --fnd_message.set_token('PROCEDURE_NAME','CHECK_MANDATORY_FIELDS');
462: fnd_msg_pub.ADD;
463: x_error_occured := 'Y';
464: --dbms_output.put_line('PA_END_DATE_IS_MISSING');

Line 486: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

482: pa_debug.set_err_stack('Validate_dates');
483: IF p_end_date_active IS NOT NULL THEN
484: IF (p_end_date_active < p_start_date_active) THEN
485: fnd_message.set_name('PA','PA_SU_INVALID_DATES');
486: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
487: --fnd_message.set_token('PROCEDURE_NAME',pa_debug.g_err_stack);
488: fnd_msg_pub.ADD;
489: x_error_occured := 'Y';
490: END IF;

Line 509: FROM pa_project_parties

505: BEGIN
506: pa_debug.set_err_stack('Validate_no_overlap_manager');
507:
508: SELECT 'Y' INTO l_error_occured
509: FROM pa_project_parties
510: WHERE object_type = p_object_type
511: AND object_id = p_object_id
512: AND project_role_id = p_project_role_id
513: AND project_party_id <> NVL(p_project_party_id,-999)

Line 522: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

518: OR (p_start_date_active > start_date_active AND end_date_active IS NULL));
519:
520: x_error_occured := l_error_occured;
521: fnd_message.set_name('PA','PA_PR_TOO_MANY_MGRS');
522: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
523: --fnd_message.set_token('PROCEDURE_NAME','VALIDATE_NO_OVERLAP_MANAGER');
524: fnd_msg_pub.ADD;
525: --dbms_output.put_line('here');
526: pa_debug.reset_err_stack;

Line 536: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',

532: fnd_message.set_name('PA','PA_PR_TOO_MANY_MGRS');
533: fnd_msg_pub.ADD;
534: x_error_occured := 'Y';
535: WHEN OTHERS THEN
536: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',
537: p_procedure_name => pa_debug.g_err_stack,
538: p_error_text => SUBSTRB(SQLERRM,1,240));
539: RAISE;
540: END VALIDATE_NO_OVERLAP_MANAGER;

Line 557: FROM pa_project_parties

553: BEGIN
554: pa_debug.set_err_stack('Validate_person_not_overlapped');
555:
556: SELECT 'Y' INTO l_error_occured
557: FROM pa_project_parties
558: WHERE object_type = p_object_type
559: AND object_id = p_object_id
560: AND project_role_id = p_project_role_id
561: AND resource_type_id = p_resource_type_id

Line 584: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',

580: fnd_message.set_name('PA','PA_XC_TOO_MANY_OMGRS');
581: fnd_msg_pub.ADD;
582: x_error_occured := 'Y';
583: WHEN OTHERS THEN
584: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',
585: p_procedure_name => pa_debug.g_err_stack,
586: p_error_text => SUBSTRB(SQLERRM,1,240));
587: RAISE;
588:

Line 605: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

601: OR (project_role_type = p_project_role_type AND p_calling_module = 'FORM');
602: RETURN l_project_role_id;
603: EXCEPTION WHEN NO_DATA_FOUND THEN
604: fnd_message.set_name('PA','PA_XC_NO_ROLE_TYPE');
605: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
606: --fnd_message.set_token('PROCEDURE_NAME','GET_PROJECT_ROLE_ID');
607: fnd_msg_pub.ADD;
608: RETURN -999;
609: END;

Line 612: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

608: RETURN -999;
609: END;
610: ELSE
611: fnd_message.set_name('PA','PA_XC_NO_ROLE_TYPE');
612: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
613: --fnd_message.set_token('PROCEDURE_NAME','GET_PROJECT_ROLE_ID');
614: fnd_msg_pub.ADD;
615: RETURN -999;
616: END IF;

Line 631: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

627: AND active = '*';
628: RETURN l_resource_id;
629: EXCEPTION WHEN NO_DATA_FOUND THEN
630: fnd_message.set_name('PA','PA_XC_NO_PERSON_ID');
631: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
632: --fnd_message.set_token('PROCEDURE_NAME','GET_RESOURCE_SOURCE_ID');
633: fnd_msg_pub.ADD;
634: RETURN -999;
635: WHEN TOO_MANY_ROWS THEN

Line 637: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

633: fnd_msg_pub.ADD;
634: RETURN -999;
635: WHEN TOO_MANY_ROWS THEN
636: fnd_message.set_name('PA','PA_TOO_MANY_PERSONS');
637: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
638: --fnd_message.set_token('PROCEDURE_NAME','GET_RESOURCE_SOURCE_ID');
639: fnd_msg_pub.ADD;
640: RETURN -999;
641: END;

Line 644: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

640: RETURN -999;
641: END;
642: ELSE
643: fnd_message.set_name('PA','PA_XC_NO_PERSON_ID');
644: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
645: --fnd_message.set_token('PROCEDURE_NAME','GET_RESOURCE_SOURCE_ID');
646: fnd_msg_pub.ADD;
647: RETURN -999;
648: END IF;

Line 669: FROM pa_project_parties

665:
666: BEGIN
667: pa_debug.set_err_stack('get_grant_id');
668: SELECT grant_id INTO l_grant_id
669: FROM pa_project_parties
670: WHERE project_party_id = p_project_party_id;
671: pa_debug.reset_err_stack;
672:
673: RETURN l_grant_id;

Line 678: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',

674:
675: EXCEPTION WHEN NO_DATA_FOUND THEN
676: RETURN NULL;
677: WHEN OTHERS THEN
678: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',
679: p_procedure_name => pa_debug.g_err_stack,
680: p_error_text => SUBSTRB(SQLERRM,1,240));
681: RAISE;
682: END;

Line 708: FROM pa_project_parties ppp,

704: x_project_party_id,
705: x_project_role_id,
706: x_project_role_name,
707: x_manager_name
708: FROM pa_project_parties ppp,
709: pa_project_role_types pprt,
710: per_all_people_f pe
711: WHERE ppp.project_id = p_project_id
712: AND ppp.project_role_id = 1

Line 732: FROM pa_project_parties ppp,

728: x_project_party_id,
729: x_project_role_id,
730: x_project_role_name,
731: x_manager_name
732: FROM pa_project_parties ppp,
733: pa_project_role_types pprt,
734: per_all_people_f pe
735: WHERE ppp.project_id = p_project_id
736: AND ppp.project_role_id = 1

Line 745: FROM pa_project_parties ppp1

741: AND pe.effective_end_date
742: AND ppp.object_type = 'PA_PROJECTS'
743: AND ppp.start_date_active > TRUNC(SYSDATE)
744: AND ppp.start_date_active = (SELECT MIN(ppp1.start_date_active)
745: FROM pa_project_parties ppp1
746: WHERE ppp1.project_id = p_project_id
747: AND ppp1.project_role_id = 1
748: AND ppp1.start_date_active > TRUNC(SYSDATE));
749: END;

Line 757: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',

753: WHEN NO_DATA_FOUND THEN
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: x_error_message_code := 'PA_NO_PROJ_MGR_EXISTS';
756: WHEN OTHERS THEN
757: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',
758: p_procedure_name => pa_debug.g_err_stack,
759: p_error_text => SUBSTRB(SQLERRM,1,240));
760: RAISE;
761: END GET_CURR_PROJ_MGR_DETAILS;

Line 773: FROM pa_project_parties p,

769: ret NUMBER;
770: BEGIN
771: SELECT project_party_id
772: INTO ret
773: FROM pa_project_parties p,
774: pa_project_role_types_b r,
775: pa_customers_v c
776: WHERE r.role_party_class = 'CUSTOMER'
777: AND p.project_role_id = r.project_role_id

Line 826: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',

822:
823: pa_debug.reset_err_stack;
824: EXCEPTION
825: WHEN OTHERS THEN
826: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',
827: p_procedure_name => pa_debug.g_err_stack,
828: p_error_text => SUBSTRB(SQLERRM,1,240));
829: RAISE;
830: END VALIDATE_ROLE_PARTY;

Line 839: FROM PA_PROJECT_PARTIES PPP ,

835: IS
836:
837: CURSOR C1 (c_as_of_date DATE) IS
838: Select PPP.RESOURCE_SOURCE_ID
839: FROM PA_PROJECT_PARTIES PPP ,
840: --PA_PROJECT_ROLE_TYPES PPRT --bug 4004821
841: PA_PROJECT_ROLE_TYPES_B PPRT
842: WHERE
843: PPP.PROJECT_ID = p_project_id

Line 856: PA_PROJECT_PARTIES_UTILS.G_PROJECT_MANAGER_ID := null;

852: l_project_start_date DATE;
853:
854: BEGIN
855:
856: PA_PROJECT_PARTIES_UTILS.G_PROJECT_MANAGER_ID := null;
857:
858: l_project_finish_date := PA_PROJECT_DATES_UTILS.Get_Project_Finish_Date(p_project_id);
859:
860: -- return project manager as of project finish date for past projects

Line 883: PA_PROJECT_PARTIES_UTILS.G_PROJECT_MANAGER_ID := l_return_value;

879: END IF;
880:
881: END IF;
882:
883: PA_PROJECT_PARTIES_UTILS.G_PROJECT_MANAGER_ID := l_return_value;
884: RETURN l_return_value;
885:
886: END;
887:

Line 902: IF PA_PROJECT_PARTIES_UTILS.G_PROJECT_MANAGER_ID is not null THEN

898:
899: l_return_value VARCHAR2(250);
900: BEGIN
901:
902: IF PA_PROJECT_PARTIES_UTILS.G_PROJECT_MANAGER_ID is not null THEN
903:
904: OPEN C1(PA_PROJECT_PARTIES_UTILS.G_PROJECT_MANAGER_ID);
905: FETCH C1 INTO l_return_value;
906: CLOSE C1;

Line 904: OPEN C1(PA_PROJECT_PARTIES_UTILS.G_PROJECT_MANAGER_ID);

900: BEGIN
901:
902: IF PA_PROJECT_PARTIES_UTILS.G_PROJECT_MANAGER_ID is not null THEN
903:
904: OPEN C1(PA_PROJECT_PARTIES_UTILS.G_PROJECT_MANAGER_ID);
905: FETCH C1 INTO l_return_value;
906: CLOSE C1;
907: END IF;
908:

Line 918: FROM PA_PROJECT_PARTIES PPP,

914: IS
915:
916: CURSOR C1 (c_as_of_date DATE) IS
917: Select ppf.full_name
918: FROM PA_PROJECT_PARTIES PPP,
919: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821
920: PA_PROJECT_ROLE_TYPES_B PPRT,
921: per_all_people_f PPF
922: WHERE

Line 984: l_party_id pa_project_parties.project_party_id%TYPE;

980: l_proj_type pa_project_types_all.project_type%TYPE; -- Added for bug#5098966
981: l_proj_start_date pa_projects_all.start_date%TYPE;
982: l_proj_end_date pa_projects_all.completion_date%TYPE;
983: l_person_id pa_project_players.person_id%TYPE;
984: l_party_id pa_project_parties.project_party_id%TYPE;
985: l_start_date pa_project_players.start_date_active%TYPE;
986: l_end_date pa_project_players.end_date_active%TYPE;
987: l_end_date_old pa_project_players.end_date_active%TYPE;
988:

Line 1020: from pa_project_parties

1016: CURSOR c_project_parties IS
1017: select project_party_id
1018: ,start_date_active
1019: ,end_date_active
1020: from pa_project_parties
1021: where project_id = p_project_id
1022: and project_role_id = 1
1023: order by start_date_active;
1024: */ --End of commenting by sunkalya for bug#4636169

Line 1061: from pa_project_parties

1057: CURSOR c_project_parties IS
1058: select project_party_id
1059: ,trunc(start_date_active)
1060: ,trunc(end_date_active)
1061: from pa_project_parties
1062: where project_id = p_project_id
1063: and project_role_id = 1
1064: AND NOT (
1065: exists(

Line 1213: from pa_project_parties

1209: /* changes end for Bug 4940945 */
1210:
1211: CURSOR c_prj_count IS
1212: select count(*)
1213: from pa_project_parties
1214: where project_id = p_project_id
1215: and project_role_id = 1;
1216:
1217: l_proj_status pa_projects_all.project_status_code%TYPE;

Line 1267: ( p_pkg_name => 'PA_PROJECT_PARTIES_UTILS.VALIDATE_ONE_MANAGER_EXISTS'

1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1264: x_msg_count := 1;
1265: x_msg_data := SQLERRM;
1266: FND_MSG_PUB.add_exc_msg
1267: ( p_pkg_name => 'PA_PROJECT_PARTIES_UTILS.VALIDATE_ONE_MANAGER_EXISTS'
1268: ,p_procedure_name => pa_debug.G_Err_Stack );
1269: IF P_DEBUG_MODE = 'Y' THEN
1270: pa_debug.write('VALIDATE_ONE_MANAGER_EXISTS: ', SQLERRM, 3);
1271: pa_debug.write('VALIDATE_ONE_MANAGER_EXISTS: ', pa_debug.G_Err_Stack, 3);

Line 1296: FROM PA_PROJECT_PARTIES PPP ,

1292: IS
1293:
1294: CURSOR C1 (c_as_of_date DATE) IS
1295: Select PPP.RESOURCE_SOURCE_ID
1296: FROM PA_PROJECT_PARTIES PPP ,
1297: --PA_PROJECT_ROLE_TYPES PPRT --bug 4004821
1298: PA_PROJECT_ROLE_TYPES_B PPRT
1299: WHERE
1300: PPP.PROJECT_ID = p_project_id

Line 1310: PA_PROJECT_PARTIES_UTILS.G_PROJECT_MANAGER_ID := null;

1306:
1307: l_return_value NUMBER(10);
1308: BEGIN
1309:
1310: PA_PROJECT_PARTIES_UTILS.G_PROJECT_MANAGER_ID := null;
1311:
1312: OPEN C1 (sysdate);
1313: FETCH C1 INTO l_return_value;
1314: CLOSE C1;

Line 1317: PA_PROJECT_PARTIES_UTILS.G_PROJECT_MANAGER_ID := l_return_value;

1313: FETCH C1 INTO l_return_value;
1314: CLOSE C1;
1315:
1316:
1317: PA_PROJECT_PARTIES_UTILS.G_PROJECT_MANAGER_ID := l_return_value;
1318: RETURN l_return_value;
1319:
1320: END GET_CURRENT_PROJECT_MANAGER;
1321:

Line 1341: FROM PA_PROJECT_PARTIES PPP,

1337: IS
1338:
1339: CURSOR C1 (c_as_of_date DATE) IS
1340: Select ppf.full_name
1341: FROM PA_PROJECT_PARTIES PPP,
1342: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821
1343: PA_PROJECT_ROLE_TYPES_B PPRT,
1344: per_all_people_f PPF
1345: WHERE

Line 1370: END PA_PROJECT_PARTIES_UTILS;

1366:
1367: RETURN l_return_value;
1368: END GET_CURRENT_PROJ_MANAGER_NAME;
1369:
1370: END PA_PROJECT_PARTIES_UTILS;
1371: