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

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

Line 120: fnd_msg_pub.ADD;

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

Line 188: fnd_msg_pub.ADD;

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

Line 208: fnd_msg_pub.ADD;

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

Line 230: fnd_msg_pub.ADD;

226: x_return_status := FND_API.G_RET_STS_ERROR;
227: fnd_message.set_name('PA','PA_NO_SCHEDULE_ALLOWED');
228: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
229: --fnd_message.set_token('PROCEDURE_NAME','VALIDATE_PROJECT_PARTY');
230: fnd_msg_pub.ADD;
231: END IF;
232: ELSE
233: IF (p_debug_mode = 'Y') THEN
234: pa_debug.debug('Validate_project_party: No schedule required.');

Line 278: fnd_msg_pub.ADD;

274: x_return_status := FND_API.G_RET_STS_ERROR;
275: fnd_message.set_name('PA','PA_XC_TOO_MANY_OMGRS');
276: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
277: --fnd_message.set_token('PROCEDURE_NAME','VALIDATE_PROJECT_PARTY');
278: fnd_msg_pub.ADD;
279: END IF;
280: END IF;
281: END IF;
282:

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

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

Line 351: fnd_msg_pub.ADD;

347: WHEN NO_DATA_FOUND THEN
348: fnd_message.set_name('PA','PA_NO_SCHEDULE_ALLOWED');
349: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
350: --fnd_message.set_token('FUNCTION_NAME','GET_SCHEDULED_FLAG');
351: fnd_msg_pub.ADD;
352: RETURN 'X';
353: WHEN OTHERS THEN
354: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',
355: p_procedure_name => pa_debug.g_err_stack,

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

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

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

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

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

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

Line 430: fnd_msg_pub.ADD;

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

Line 439: fnd_msg_pub.ADD;

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

Line 448: fnd_msg_pub.ADD;

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

Line 459: fnd_msg_pub.ADD;

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

Line 485: fnd_msg_pub.ADD;

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

Line 521: fnd_msg_pub.ADD;

517: x_error_occured := l_error_occured;
518: fnd_message.set_name('PA','PA_PR_TOO_MANY_MGRS');
519: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
520: --fnd_message.set_token('PROCEDURE_NAME','VALIDATE_NO_OVERLAP_MANAGER');
521: fnd_msg_pub.ADD;
522: --dbms_output.put_line('here');
523: pa_debug.reset_err_stack;
524:
525: EXCEPTION

Line 530: fnd_msg_pub.ADD;

526: WHEN NO_DATA_FOUND THEN
527: x_error_occured := 'N';
528: WHEN TOO_MANY_ROWS THEN
529: fnd_message.set_name('PA','PA_PR_TOO_MANY_MGRS');
530: fnd_msg_pub.ADD;
531: x_error_occured := 'Y';
532: WHEN OTHERS THEN
533: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',
534: p_procedure_name => pa_debug.g_err_stack,

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

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

Line 572: fnd_msg_pub.ADD;

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

Line 578: fnd_msg_pub.ADD;

574: EXCEPTION WHEN NO_DATA_FOUND THEN
575: x_error_occured := 'N';
576: WHEN TOO_MANY_ROWS THEN
577: fnd_message.set_name('PA','PA_XC_TOO_MANY_OMGRS');
578: fnd_msg_pub.ADD;
579: x_error_occured := 'Y';
580: WHEN OTHERS THEN
581: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_UTILS',
582: p_procedure_name => pa_debug.g_err_stack,

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

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

Line 604: fnd_msg_pub.ADD;

600: EXCEPTION WHEN NO_DATA_FOUND THEN
601: fnd_message.set_name('PA','PA_XC_NO_ROLE_TYPE');
602: --fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_UTILS');
603: --fnd_message.set_token('PROCEDURE_NAME','GET_PROJECT_ROLE_ID');
604: fnd_msg_pub.ADD;
605: RETURN -999;
606: END;
607: ELSE
608: fnd_message.set_name('PA','PA_XC_NO_ROLE_TYPE');

Line 611: fnd_msg_pub.ADD;

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

Line 630: fnd_msg_pub.ADD;

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

Line 636: fnd_msg_pub.ADD;

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

Line 643: fnd_msg_pub.ADD;

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

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

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

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

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

Line 816: fnd_msg_pub.ADD;

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

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

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

Line 1166: fnd_msg_pub.add_exc_msg(p_pkg_name => 'VALIDATE_MANAGER_DATE_RANGE',

1162: END IF;
1163: IF c_project_parties%ISOPEN THEN
1164: CLOSE c_project_parties;
1165: END IF;
1166: fnd_msg_pub.add_exc_msg(p_pkg_name => 'VALIDATE_MANAGER_DATE_RANGE',
1167: p_procedure_name => pa_debug.g_err_stack,
1168: p_error_text => SUBSTRB(SQLERRM,1,240));
1169: RAISE;
1170:

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

1229: OPEN c_prj_count;
1230: FETCH c_prj_count INTO l_prj_mgr_count;
1231: CLOSE c_prj_count;
1232: IF l_prj_mgr_count = 0 THEN
1233: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1234: pa_utils.add_message
1235: ( p_app_short_name => 'PA'
1236: ,p_msg_name => 'PA_PR_INSUF_PROJ_MGR'
1237: );

Line 1252: FND_MSG_PUB.add_exc_msg

1248: WHEN OTHERS THEN
1249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1250: x_msg_count := 1;
1251: x_msg_data := SQLERRM;
1252: FND_MSG_PUB.add_exc_msg
1253: ( p_pkg_name => 'PA_PROJECT_PARTIES_UTILS.VALIDATE_ONE_MANAGER_EXISTS'
1254: ,p_procedure_name => pa_debug.G_Err_Stack );
1255: IF P_DEBUG_MODE = 'Y' THEN
1256: pa_debug.write('VALIDATE_ONE_MANAGER_EXISTS: ', SQLERRM, 3);