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 FND_MSG_PUB

Line 53: fnd_msg_pub.ADD;

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;
56:
57:

Line 111: fnd_msg_pub.ADD;

107: --MT OrgRole changes: ext people are not schedulable
108: IF p_resource_type_id = 112 AND p_scheduled_flag = 'Y' THEN
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: fnd_message.set_name('PA','PA_NO_SCHEDULE_HZ_PARTY');
111: fnd_msg_pub.ADD;
112: RETURN;
113: END IF;
114: --/MT
115:

Line 121: fnd_msg_pub.ADD;

117:
118: IF p_resource_type_id = 112 AND p_project_role_id=1 THEN
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: fnd_message.set_name('PA','PA_NO_EXT_MANAGER');
121: fnd_msg_pub.ADD;
122: RETURN;
123: END IF;
124:
125: /*Code Addition ends - 2983546*/

Line 191: fnd_msg_pub.ADD;

187: EXCEPTION
188: WHEN NO_DATA_FOUND THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: fnd_message.set_name('PA','PA_ROLE_INACTIVE');
191: fnd_msg_pub.ADD;
192: END;
193: /* End of 3096700 */
194: --dbms_output.put_line('after validating dates'||x_return_status);
195: x_assignment_action := 'NOACTION';

Line 211: fnd_msg_pub.ADD;

207: FETCH c_duplicate_customer_org INTO l_dummy;
208: IF c_duplicate_customer_org%FOUND THEN
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: fnd_message.set_name('PA','PA_DUPLICATE_CUSTOMER_ORG');
211: fnd_msg_pub.ADD;
212: CLOSE c_duplicate_customer_org;
213: RETURN;
214: END IF;
215: CLOSE c_duplicate_customer_org;

Line 233: fnd_msg_pub.ADD;

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
236: IF (p_debug_mode = 'Y') THEN
237: pa_debug.debug('Validate_project_party: No schedule required.');

Line 281: fnd_msg_pub.ADD;

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;
284: END IF;
285:

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 354: fnd_msg_pub.ADD;

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
357: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',
358: p_procedure_name => pa_debug.g_err_stack,

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 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 433: fnd_msg_pub.ADD;

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';
436: END IF;
437:

Line 442: fnd_msg_pub.ADD;

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';
445: END IF;
446:

Line 451: fnd_msg_pub.ADD;

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';
454: END IF;
455:

Line 462: fnd_msg_pub.ADD;

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');
465: ELSE
466: p_end_date_active := p_project_end_date;

Line 488: fnd_msg_pub.ADD;

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;
491: END IF;
492: pa_debug.reset_err_stack;

Line 524: fnd_msg_pub.ADD;

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;
527:
528: EXCEPTION

Line 533: fnd_msg_pub.ADD;

529: WHEN NO_DATA_FOUND THEN
530: x_error_occured := 'N';
531: WHEN TOO_MANY_ROWS THEN
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,

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 575: fnd_msg_pub.ADD;

571: --dbms_output.put_line(l_error_occured);
572: fnd_message.set_name('PA','PA_XC_TOO_MANY_OMGRS');
573: --fnd_message.set_token('PKG_NAME',to_char(p_project_role_id));
574: --fnd_message.set_token('PROCEDURE_NAME',to_char(p_resource_source_id));
575: fnd_msg_pub.ADD;
576: pa_debug.reset_err_stack;
577: EXCEPTION WHEN NO_DATA_FOUND THEN
578: x_error_occured := 'N';
579: WHEN TOO_MANY_ROWS THEN

Line 581: fnd_msg_pub.ADD;

577: EXCEPTION WHEN NO_DATA_FOUND THEN
578: x_error_occured := 'N';
579: WHEN TOO_MANY_ROWS THEN
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,

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 607: fnd_msg_pub.ADD;

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;
610: ELSE
611: fnd_message.set_name('PA','PA_XC_NO_ROLE_TYPE');

Line 614: fnd_msg_pub.ADD;

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;
617: END;
618:

Line 633: fnd_msg_pub.ADD;

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
636: fnd_message.set_name('PA','PA_TOO_MANY_PERSONS');
637: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');

Line 639: fnd_msg_pub.ADD;

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;
642: ELSE
643: fnd_message.set_name('PA','PA_XC_NO_PERSON_ID');

Line 646: fnd_msg_pub.ADD;

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;
649: END;
650: -------------

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 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 819: fnd_msg_pub.ADD;

815:
816: IF (l_role_party_class = 'PERSON' AND l_party_type <> 'PERSON') OR
817: (l_role_party_class <> 'PERSON' AND l_party_type = 'PERSON') THEN
818: fnd_message.set_name('PA','PA_XC_NO_ROLE_TYPE');
819: fnd_msg_pub.ADD;
820: x_error_occured := 'Y';
821: END IF;
822:
823: pa_debug.reset_err_stack;

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

1176: END IF;
1177: IF c_project_parties%ISOPEN THEN
1178: CLOSE c_project_parties;
1179: END IF;
1180: fnd_msg_pub.add_exc_msg(p_pkg_name => 'VALIDATE_MANAGER_DATE_RANGE',
1181: p_procedure_name => pa_debug.g_err_stack,
1182: p_error_text => SUBSTRB(SQLERRM,1,240));
1183: RAISE;
1184:

Line 1247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1243: OPEN c_prj_count;
1244: FETCH c_prj_count INTO l_prj_mgr_count;
1245: CLOSE c_prj_count;
1246: IF l_prj_mgr_count = 0 THEN
1247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1248: pa_utils.add_message
1249: ( p_app_short_name => 'PA'
1250: ,p_msg_name => 'PA_PR_INSUF_PROJ_MGR'
1251: );

Line 1266: FND_MSG_PUB.add_exc_msg

1262: WHEN OTHERS THEN
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);