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_DEBUG

Line 4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

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:
6: FUNCTION VALIDATE_DELETE_PARTY_OK (p_project_id IN NUMBER,
7: p_project_party_id IN NUMBER) RETURN VARCHAR2 IS
8:

Line 103: pa_debug.set_err_stack('Validate_project_party');

99:
100:
101: BEGIN
102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103: pa_debug.set_err_stack('Validate_project_party');
104:
105: l_end_date_active := p_end_date_active; --Bug 4565156 NOCOPY changes
106:
107: --MT OrgRole changes: ext people are not schedulable

Line 130: pa_debug.debug('Validate_project_party: Calling check_mandatory_fields.');

126:
127:
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,

Line 151: pa_debug.debug('Validate_role_party: Calling Validate_role_party.');

147:
148: -- Bug 2671210. Check to validate role-party combination.
149: --- call to validate role party combination
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,

Line 166: pa_debug.debug('Validate_project_party: Calling validate_dates.');

162: -- bug2671210 ended.
163:
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);

Line 203: pa_debug.debug('Validate_project_party: Looking for customer org duplicate.');

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.');
204: END IF;
205:
206: OPEN c_duplicate_customer_org;
207: FETCH c_duplicate_customer_org INTO l_dummy;

Line 220: pa_debug.debug('Validate_project_party: Checking for schedule flag.');

216: END IF;
217:
218:
219: IF (p_debug_mode = 'Y') THEN
220: pa_debug.debug('Validate_project_party: Checking for schedule flag.');
221: END IF;
222:
223: IF p_scheduled_flag = 'Y' THEN
224: IF VALIDATE_SCHEDULE_ALLOWED(p_project_role_id) = 'Y' THEN

Line 237: pa_debug.debug('Validate_project_party: No schedule required.');

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.');
238: END IF;
239:
240: --dbms_output.put_line('no assignment required');
241: x_assignment_action := 'NOACTION';

Line 246: pa_debug.debug('Validate_project_party: Need to delete schedule.');

242: END IF;
243:
244: IF p_scheduled_flag = 'N' AND p_action = 'UPDATE' THEN
245: IF (p_debug_mode = 'Y') THEN
246: pa_debug.debug('Validate_project_party: Need to delete schedule.');
247: END IF;
248:
249: --dbms_output.put_line('need to delete assignment');
250: x_assignment_action := 'DELETE';

Line 257: pa_debug.debug('Validate_project_party: Getting the project party id.');

253:
254: IF x_assignment_action = 'CREATE' OR (p_action = 'INSERT' AND p_calling_module <> 'PROJECT_MEMBER') THEN
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,

Line 292: pa_debug.debug('Validate_project_party: Calling validate_no_overlap_manager.');

288: IF x_call_overlap = 'Y' OR p_action = 'UPDATE' OR p_calling_module = 'EXCHANGE' THEN
289:
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,

Line 307: pa_debug.debug('Validate_project_party: Calling validate_person_not_overlapped.');

303: END IF;
304: --dbms_output.put_line('validating manager');
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,

Line 340: pa_debug.set_err_stack('Get_scheduled_flag');

336: FUNCTION GET_SCHEDULED_FLAG(p_project_party_id IN NUMBER,
337: p_record_version_number IN NUMBER) RETURN VARCHAR2 IS
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);

Line 346: pa_debug.reset_err_stack;

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;
347: RETURN l_scheduled_flag;
348:
349: EXCEPTION
350: WHEN NO_DATA_FOUND THEN

Line 358: p_procedure_name => pa_debug.g_err_stack,

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;
362:

Line 368: pa_debug.set_err_stack('Validate_scheduled_allowed');

364: FUNCTION VALIDATE_SCHEDULE_ALLOWED(p_project_role_id IN NUMBER) RETURN VARCHAR2 IS
365: x_sch_flag VARCHAR2(1) := 'N';
366: BEGIN
367:
368: pa_debug.set_err_stack('Validate_scheduled_allowed');
369: x_sch_flag := pa_role_utils.get_schedulable_flag(p_role_id => p_project_role_id);
370:
371: pa_debug.reset_err_stack;
372:

Line 371: pa_debug.reset_err_stack;

367:
368: pa_debug.set_err_stack('Validate_scheduled_allowed');
369: x_sch_flag := pa_role_utils.get_schedulable_flag(p_role_id => p_project_role_id);
370:
371: pa_debug.reset_err_stack;
372:
373: RETURN x_sch_flag;
374:
375: EXCEPTION WHEN OTHERS THEN

Line 377: p_procedure_name => pa_debug.g_err_stack,

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;
381:

Line 393: pa_debug.set_err_stack('Get_person_party_id');

389: p_end_date_active IN DATE,
390: x_project_party_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
391: x_record_version_number OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
392: BEGIN
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

Line 406: pa_debug.reset_err_stack;

402: AND resource_source_id = p_resource_source_id
403: AND start_date_active = TRUNC(p_start_date_active)
404: AND end_date_active = TRUNC(p_end_date_active);
405:
406: pa_debug.reset_err_stack;
407:
408: EXCEPTION WHEN NO_DATA_FOUND THEN
409: x_project_party_id := -999;
410: WHEN OTHERS THEN

Line 412: p_procedure_name => pa_debug.g_err_stack,

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;
416:

Line 428: pa_debug.set_err_stack('Check_mandatory_fields');

424: p_scheduled_flag IN VARCHAR2,
425: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
426:
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');

Line 472: pa_debug.reset_err_stack;

468:
469: END IF;
470:
471: END IF;
472: pa_debug.reset_err_stack;
473:
474: END CHECK_MANDATORY_FIELDS;
475:
476:

Line 482: pa_debug.set_err_stack('Validate_dates');

478: p_end_date_active IN DATE,
479: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
480: BEGIN
481:
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');

Line 487: --fnd_message.set_token('PROCEDURE_NAME',pa_debug.g_err_stack);

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

Line 492: pa_debug.reset_err_stack;

488: fnd_msg_pub.ADD;
489: x_error_occured := 'Y';
490: END IF;
491: END IF;
492: pa_debug.reset_err_stack;
493:
494: END VALIDATE_DATES;
495:
496:

Line 506: pa_debug.set_err_stack('Validate_no_overlap_manager');

502: p_end_date_active IN DATE,
503: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
504: l_error_occured VARCHAR2(1);
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

Line 526: pa_debug.reset_err_stack;

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

Line 537: p_procedure_name => pa_debug.g_err_stack,

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;
541:

Line 554: pa_debug.set_err_stack('Validate_person_not_overlapped');

550: p_end_date_active IN DATE,
551: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
552: l_error_occured VARCHAR2(1);
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

Line 576: pa_debug.reset_err_stack;

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
580: fnd_message.set_name('PA','PA_XC_TOO_MANY_OMGRS');

Line 585: p_procedure_name => pa_debug.g_err_stack,

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:
589: END VALIDATE_PERSON_NOT_OVERLAPPED;

Line 667: pa_debug.set_err_stack('get_grant_id');

663: FUNCTION get_grant_id(p_project_party_id IN NUMBER) RETURN RAW IS
664: l_grant_id RAW(16);
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;

Line 671: pa_debug.reset_err_stack;

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;
674:
675: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 679: p_procedure_name => pa_debug.g_err_stack,

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;
683:

Line 695: pa_debug.set_err_stack('get_current_project_manager_details');

691: x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
692: BEGIN
693: x_return_status := FND_API.G_RET_STS_SUCCESS;
694:
695: pa_debug.set_err_stack('get_current_project_manager_details');
696:
697: BEGIN
698: SELECT ppp.resource_source_id,
699: ppp.project_party_id,

Line 751: pa_debug.reset_err_stack;

747: AND ppp1.project_role_id = 1
748: AND ppp1.start_date_active > TRUNC(SYSDATE));
749: END;
750:
751: pa_debug.reset_err_stack;
752: EXCEPTION
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';

Line 758: p_procedure_name => pa_debug.g_err_stack,

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;
762:

Line 798: pa_debug.set_err_stack('Validate_role_party');

794:
795: l_party_type VARCHAR2(30) := 'PERSON';
796: l_role_party_class pa_project_role_types_b.role_party_class%TYPE;
797: BEGIN
798: pa_debug.set_err_stack('Validate_role_party');
799:
800: -- Check if the resource is a Person/Organization.
801: IF p_resource_type_id = 112 THEN
802: SELECT party_type

Line 823: pa_debug.reset_err_stack;

819: fnd_msg_pub.ADD;
820: x_error_occured := 'Y';
821: END IF;
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,

Line 827: p_procedure_name => pa_debug.g_err_stack,

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;
831:

Line 1028: pa_debug.set_err_stack('Validate Manager Date Range');

1024: */ --End of commenting by sunkalya for bug#4636169
1025:
1026: BEGIN
1027:
1028: pa_debug.set_err_stack('Validate Manager Date Range');
1029:
1030: IF p_project_id IS NOT NULL THEN
1031: OPEN c_prj;
1032: -- Added l_proj_type for bug#5098966

Line 1088: pa_debug.write('VALIDATE_MANAGER_DATE_RANGE: ','Mode is AMG',3 );

1084: OPEN c_project_parties;
1085: LOOP
1086: IF p_mode = 'AMG' THEN
1087: IF P_DEBUG_MODE = 'Y' THEN
1088: pa_debug.write('VALIDATE_MANAGER_DATE_RANGE: ','Mode is AMG',3 );
1089: END IF;
1090: FETCH c_project_players INTO l_person_id,l_start_date,l_end_date;
1091: ELSIF p_mode = 'SS' THEN
1092: IF P_DEBUG_MODE = 'Y' THEN

Line 1093: pa_debug.write('VALIDATE_MANAGER_DATE_RANGE: ','Mode is SS',3 );

1089: END IF;
1090: FETCH c_project_players INTO l_person_id,l_start_date,l_end_date;
1091: ELSIF p_mode = 'SS' THEN
1092: IF P_DEBUG_MODE = 'Y' THEN
1093: pa_debug.write('VALIDATE_MANAGER_DATE_RANGE: ','Mode is SS',3 );
1094: END IF;
1095: FETCH c_project_parties INTO l_party_id,l_start_date,l_end_date;
1096: END IF;
1097:

Line 1164: pa_debug.write('VALIDATE_MANAGER_DATE_RANGE: ','l_error_occured - '||l_error_occured,3 );

1160: CLOSE c_project_parties;
1161: END IF;
1162:
1163: IF P_DEBUG_MODE = 'Y' THEN
1164: pa_debug.write('VALIDATE_MANAGER_DATE_RANGE: ','l_error_occured - '||l_error_occured,3 );
1165: END IF;
1166: x_error_occured := l_error_occured;
1167: pa_debug.reset_err_stack;
1168:

Line 1167: pa_debug.reset_err_stack;

1163: IF P_DEBUG_MODE = 'Y' THEN
1164: pa_debug.write('VALIDATE_MANAGER_DATE_RANGE: ','l_error_occured - '||l_error_occured,3 );
1165: END IF;
1166: x_error_occured := l_error_occured;
1167: pa_debug.reset_err_stack;
1168:
1169: EXCEPTION
1170: WHEN NO_DATA_FOUND THEN
1171: x_error_occured := 'N';

Line 1181: p_procedure_name => pa_debug.g_err_stack,

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:
1185: END; --This END is for the BEGIN added by sunkalya for Bug#4636169

Line 1226: pa_debug.set_err_stack('VALIDATE_ONE_MANAGER_EXISTS');

1222:
1223:
1224: BEGIN
1225:
1226: pa_debug.set_err_stack('VALIDATE_ONE_MANAGER_EXISTS');
1227: x_msg_count := 0;
1228: x_return_status := FND_API.G_RET_STS_SUCCESS;
1229:
1230: /* Do the checking for the Manager date only for an Approved Contract Type project. */

Line 1241: pa_debug.write('VALIDATE_ONE_MANAGER_EXISTS: ','This is an Approved Contract Project',3 );

1237: /* The check has to be done only for an Approved Contract Type project. */
1238: IF (nvl(l_proj_type_class,'NONE') = 'CONTRACT' AND
1239: nvl(l_proj_status,'UNAPPROVED') = 'APPROVED') THEN
1240: IF P_DEBUG_MODE = 'Y' THEN
1241: pa_debug.write('VALIDATE_ONE_MANAGER_EXISTS: ','This is an Approved Contract Project',3 );
1242: END IF;
1243: OPEN c_prj_count;
1244: FETCH c_prj_count INTO l_prj_mgr_count;
1245: CLOSE c_prj_count;

Line 1258: pa_debug.reset_err_stack;

1254: x_msg_data := 'PA_PR_INSUF_PROJ_MGR';
1255: END IF;
1256: END IF;
1257: END IF;
1258: pa_debug.reset_err_stack;
1259:
1260: EXCEPTION
1261:
1262: WHEN OTHERS THEN

Line 1268: ,p_procedure_name => pa_debug.G_Err_Stack );

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);
1272: END IF;

Line 1270: pa_debug.write('VALIDATE_ONE_MANAGER_EXISTS: ', SQLERRM, 3);

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);
1272: END IF;
1273: pa_debug.reset_err_stack;
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1271: pa_debug.write('VALIDATE_ONE_MANAGER_EXISTS: ', pa_debug.G_Err_Stack, 3);

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);
1272: END IF;
1273: pa_debug.reset_err_stack;
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275:

Line 1273: pa_debug.reset_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);
1272: END IF;
1273: pa_debug.reset_err_stack;
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275:
1276: END VALIDATE_ONE_MANAGER_EXISTS;
1277: