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.7 2006/03/28 00:24:38 sunkalya noship $ */
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 102: pa_debug.set_err_stack('Validate_project_party');

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

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

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

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

144:
145: -- Bug 2671210. Check to validate role-party combination.
146: --- call to validate role party combination
147: IF (p_debug_mode = 'Y') THEN
148: pa_debug.debug('Validate_role_party: Calling Validate_role_party.');
149: END IF;
150:
151: pa_project_parties_utils.Validate_role_party(p_project_role_id => p_project_role_id,
152: p_resource_type_id => p_resource_type_id,

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

159: -- bug2671210 ended.
160:
161: --- call to validate the start and end dates for the person
162: IF (p_debug_mode = 'Y') THEN
163: pa_debug.debug('Validate_project_party: Calling validate_dates.');
164: END IF;
165: pa_project_parties_utils.validate_dates(p_start_date_active => p_start_date_active,
166: p_end_date_active => p_end_date_active,
167: x_error_occured => l_error_occured);

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

196: IF (p_action = 'INSERT' OR pa_project_parties_utils.get_scheduled_flag(p_project_party_id, p_record_version_number) <> p_scheduled_flag) THEN
197:
198: IF p_resource_type_id = 112 THEN
199: IF (p_debug_mode = 'Y') THEN
200: pa_debug.debug('Validate_project_party: Looking for customer org duplicate.');
201: END IF;
202:
203: OPEN c_duplicate_customer_org;
204: FETCH c_duplicate_customer_org INTO l_dummy;

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

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

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

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

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

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

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

250:
251: IF x_assignment_action = 'CREATE' OR (p_action = 'INSERT' AND p_calling_module <> 'PROJECT_MEMBER') THEN
252: --dbms_output.put_line('trying to get person id');
253: IF (p_debug_mode = 'Y') THEN
254: pa_debug.debug('Validate_project_party: Getting the project party id.');
255: END IF;
256: pa_project_parties_utils.get_person_party_id(p_object_type => p_object_type,
257: p_object_id => p_object_id,
258: p_project_role_id => p_project_role_id,

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

285: IF x_call_overlap = 'Y' OR p_action = 'UPDATE' OR p_calling_module = 'EXCHANGE' THEN
286:
287: IF p_project_role_id = 1 THEN -- hard coded for Project Manager
288: IF (p_debug_mode = 'Y') THEN
289: pa_debug.debug('Validate_project_party: Calling validate_no_overlap_manager.');
290: END IF;
291: pa_project_parties_utils.validate_no_overlap_manager(p_object_type => p_object_type,
292: p_object_id => p_object_id,
293: p_project_role_id => p_project_role_id,

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

300: END IF;
301: --dbms_output.put_line('validating manager');
302: ELSE
303: IF (p_debug_mode = 'Y') THEN
304: pa_debug.debug('Validate_project_party: Calling validate_person_not_overlapped.');
305: END IF;
306: pa_project_parties_utils.validate_person_not_overlapped(p_object_type => p_object_type,
307: p_object_id => p_object_id,
308: p_project_role_id => p_project_role_id,

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

333: FUNCTION GET_SCHEDULED_FLAG(p_project_party_id IN NUMBER,
334: p_record_version_number IN NUMBER) RETURN VARCHAR2 IS
335: l_scheduled_flag VARCHAR2(1);
336: BEGIN
337: pa_debug.set_err_stack('Get_scheduled_flag');
338: SELECT scheduled_flag INTO l_scheduled_flag
339: FROM pa_project_parties
340: WHERE project_party_id = NVL(p_project_party_id,-999)
341: AND record_version_number = NVL(p_record_version_number,record_version_number);

Line 343: pa_debug.reset_err_stack;

339: FROM pa_project_parties
340: WHERE project_party_id = NVL(p_project_party_id,-999)
341: AND record_version_number = NVL(p_record_version_number,record_version_number);
342:
343: pa_debug.reset_err_stack;
344: RETURN l_scheduled_flag;
345:
346: EXCEPTION
347: WHEN NO_DATA_FOUND THEN

Line 355: p_procedure_name => pa_debug.g_err_stack,

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

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

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

Line 368: pa_debug.reset_err_stack;

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

Line 374: p_procedure_name => pa_debug.g_err_stack,

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

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

386: p_end_date_active IN DATE,
387: x_project_party_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
388: x_record_version_number OUT NOCOPY NUMBER) IS --File.Sql.39 bug 4440895
389: BEGIN
390: pa_debug.set_err_stack('Get_person_party_id');
391: x_project_party_id := -999;
392:
393: SELECT project_party_id, record_version_number INTO x_project_party_id, x_record_version_number
394: FROM pa_project_parties

Line 403: pa_debug.reset_err_stack;

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

Line 409: p_procedure_name => pa_debug.g_err_stack,

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

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

421: p_scheduled_flag IN VARCHAR2,
422: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
423:
424: BEGIN
425: pa_debug.set_err_stack('Check_mandatory_fields');
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');

Line 469: pa_debug.reset_err_stack;

465:
466: END IF;
467:
468: END IF;
469: pa_debug.reset_err_stack;
470:
471: END CHECK_MANDATORY_FIELDS;
472:
473:

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

475: p_end_date_active IN DATE,
476: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
477: BEGIN
478:
479: pa_debug.set_err_stack('Validate_dates');
480: IF p_end_date_active IS NOT NULL THEN
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');

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

480: IF p_end_date_active IS NOT NULL THEN
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;

Line 489: pa_debug.reset_err_stack;

485: fnd_msg_pub.ADD;
486: x_error_occured := 'Y';
487: END IF;
488: END IF;
489: pa_debug.reset_err_stack;
490:
491: END VALIDATE_DATES;
492:
493:

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

499: p_end_date_active IN DATE,
500: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
501: l_error_occured VARCHAR2(1);
502: BEGIN
503: pa_debug.set_err_stack('Validate_no_overlap_manager');
504:
505: SELECT 'Y' INTO l_error_occured
506: FROM pa_project_parties
507: WHERE object_type = p_object_type

Line 523: pa_debug.reset_err_stack;

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

Line 534: p_procedure_name => pa_debug.g_err_stack,

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

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

547: p_end_date_active IN DATE,
548: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
549: l_error_occured VARCHAR2(1);
550: BEGIN
551: pa_debug.set_err_stack('Validate_person_not_overlapped');
552:
553: SELECT 'Y' INTO l_error_occured
554: FROM pa_project_parties
555: WHERE object_type = p_object_type

Line 573: pa_debug.reset_err_stack;

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

Line 582: p_procedure_name => pa_debug.g_err_stack,

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

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

660: FUNCTION get_grant_id(p_project_party_id IN NUMBER) RETURN RAW IS
661: l_grant_id RAW(16);
662:
663: BEGIN
664: pa_debug.set_err_stack('get_grant_id');
665: SELECT grant_id INTO l_grant_id
666: FROM pa_project_parties
667: WHERE project_party_id = p_project_party_id;
668: pa_debug.reset_err_stack;

Line 668: pa_debug.reset_err_stack;

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

Line 676: p_procedure_name => pa_debug.g_err_stack,

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

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

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

Line 748: pa_debug.reset_err_stack;

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

Line 755: p_procedure_name => pa_debug.g_err_stack,

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

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

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

Line 820: pa_debug.reset_err_stack;

816: fnd_msg_pub.ADD;
817: x_error_occured := 'Y';
818: END IF;
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,

Line 824: p_procedure_name => pa_debug.g_err_stack,

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

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

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

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

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

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

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

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

1146: CLOSE c_project_parties;
1147: END IF;
1148:
1149: IF P_DEBUG_MODE = 'Y' THEN
1150: pa_debug.write('VALIDATE_MANAGER_DATE_RANGE: ','l_error_occured - '||l_error_occured,3 );
1151: END IF;
1152: x_error_occured := l_error_occured;
1153: pa_debug.reset_err_stack;
1154:

Line 1153: pa_debug.reset_err_stack;

1149: IF P_DEBUG_MODE = 'Y' THEN
1150: pa_debug.write('VALIDATE_MANAGER_DATE_RANGE: ','l_error_occured - '||l_error_occured,3 );
1151: END IF;
1152: x_error_occured := l_error_occured;
1153: pa_debug.reset_err_stack;
1154:
1155: EXCEPTION
1156: WHEN NO_DATA_FOUND THEN
1157: x_error_occured := 'N';

Line 1167: p_procedure_name => pa_debug.g_err_stack,

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

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

1208:
1209:
1210: BEGIN
1211:
1212: pa_debug.set_err_stack('VALIDATE_ONE_MANAGER_EXISTS');
1213: x_msg_count := 0;
1214: x_return_status := FND_API.G_RET_STS_SUCCESS;
1215:
1216: /* Do the checking for the Manager date only for an Approved Contract Type project. */

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

1223: /* The check has to be done only for an Approved Contract Type project. */
1224: IF (nvl(l_proj_type_class,'NONE') = 'CONTRACT' AND
1225: nvl(l_proj_status,'UNAPPROVED') = 'APPROVED') THEN
1226: IF P_DEBUG_MODE = 'Y' THEN
1227: pa_debug.write('VALIDATE_ONE_MANAGER_EXISTS: ','This is an Approved Contract Project',3 );
1228: END IF;
1229: OPEN c_prj_count;
1230: FETCH c_prj_count INTO l_prj_mgr_count;
1231: CLOSE c_prj_count;

Line 1244: pa_debug.reset_err_stack;

1240: x_msg_data := 'PA_PR_INSUF_PROJ_MGR';
1241: END IF;
1242: END IF;
1243: END IF;
1244: pa_debug.reset_err_stack;
1245:
1246: EXCEPTION
1247:
1248: WHEN OTHERS THEN

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

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);
1257: pa_debug.write('VALIDATE_ONE_MANAGER_EXISTS: ', pa_debug.G_Err_Stack, 3);
1258: END IF;

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

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);
1257: pa_debug.write('VALIDATE_ONE_MANAGER_EXISTS: ', pa_debug.G_Err_Stack, 3);
1258: END IF;
1259: pa_debug.reset_err_stack;
1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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);
1257: pa_debug.write('VALIDATE_ONE_MANAGER_EXISTS: ', pa_debug.G_Err_Stack, 3);
1258: END IF;
1259: pa_debug.reset_err_stack;
1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1261:

Line 1259: pa_debug.reset_err_stack;

1255: IF P_DEBUG_MODE = 'Y' THEN
1256: pa_debug.write('VALIDATE_ONE_MANAGER_EXISTS: ', SQLERRM, 3);
1257: pa_debug.write('VALIDATE_ONE_MANAGER_EXISTS: ', pa_debug.G_Err_Stack, 3);
1258: END IF;
1259: pa_debug.reset_err_stack;
1260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1261:
1262: END VALIDATE_ONE_MANAGER_EXISTS;
1263: