137: end if;
138:
139: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
140: p_api_version => 1.0
141: , p_init_msg_list => FND_API.G_TRUE
142: , p_commit => FND_API.G_FALSE
143: , p_validate_only => FND_API.G_FALSE
144: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
145: , p_debug_mode => 'Y'
138:
139: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
140: p_api_version => 1.0
141: , p_init_msg_list => FND_API.G_TRUE
142: , p_commit => FND_API.G_FALSE
143: , p_validate_only => FND_API.G_FALSE
144: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
145: , p_debug_mode => 'Y'
146: , p_object_id => p_project_id
139: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
140: p_api_version => 1.0
141: , p_init_msg_list => FND_API.G_TRUE
142: , p_commit => FND_API.G_FALSE
143: , p_validate_only => FND_API.G_FALSE
144: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
145: , p_debug_mode => 'Y'
146: , p_object_id => p_project_id
147: , p_OBJECT_TYPE => 'PA_PROJECTS'
140: p_api_version => 1.0
141: , p_init_msg_list => FND_API.G_TRUE
142: , p_commit => FND_API.G_FALSE
143: , p_validate_only => FND_API.G_FALSE
144: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
145: , p_debug_mode => 'Y'
146: , p_object_id => p_project_id
147: , p_OBJECT_TYPE => 'PA_PROJECTS'
148: , p_project_role_id => p_proj_role_id
177: l_start_date_active := l_min_member_start_date;
178:
179: IF l_debug_mode = 'Y' then
180: FOR I IN 1 .. X_MSG_COUNT LOOP
181: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_FALSE
182: ,p_msg_index => x_msg_count
183: ,p_data => x_msg_data
184: ,p_msg_index_out => l_msg_index_out);
185: tm_log('*** ERROR MESSAGE ***: '||x_msg_data);
204: end if;
205:
206: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
207: p_api_version => 1.0
208: , p_init_msg_list => FND_API.G_TRUE
209: , p_commit => FND_API.G_FALSE
210: , p_validate_only => FND_API.G_FALSE
211: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
212: , p_debug_mode => 'Y'
205:
206: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
207: p_api_version => 1.0
208: , p_init_msg_list => FND_API.G_TRUE
209: , p_commit => FND_API.G_FALSE
210: , p_validate_only => FND_API.G_FALSE
211: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
212: , p_debug_mode => 'Y'
213: , p_object_id => p_project_id
206: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
207: p_api_version => 1.0
208: , p_init_msg_list => FND_API.G_TRUE
209: , p_commit => FND_API.G_FALSE
210: , p_validate_only => FND_API.G_FALSE
211: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
212: , p_debug_mode => 'Y'
213: , p_object_id => p_project_id
214: , p_OBJECT_TYPE => 'PA_PROJECTS'
207: p_api_version => 1.0
208: , p_init_msg_list => FND_API.G_TRUE
209: , p_commit => FND_API.G_FALSE
210: , p_validate_only => FND_API.G_FALSE
211: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
212: , p_debug_mode => 'Y'
213: , p_object_id => p_project_id
214: , p_OBJECT_TYPE => 'PA_PROJECTS'
215: , p_project_role_id => p_proj_role_id
244: l_start_date_active := l_proj_member_exists_rec.start_date_active;
245:
246: IF l_debug_mode = 'Y' then
247: FOR I IN 1 .. X_MSG_COUNT LOOP
248: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_FALSE
249: ,p_msg_index => x_msg_count
250: ,p_data => x_msg_data
251: ,p_msg_index_out => l_msg_index_out);
252: tm_log('*** ERROR MESSAGE ***: '||x_msg_data);
272: end if;
273:
274: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
275: p_api_version => 1.0
276: , p_init_msg_list => FND_API.G_TRUE
277: , p_commit => FND_API.G_FALSE
278: , p_validate_only => FND_API.G_FALSE
279: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
280: , p_debug_mode => 'Y'
273:
274: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
275: p_api_version => 1.0
276: , p_init_msg_list => FND_API.G_TRUE
277: , p_commit => FND_API.G_FALSE
278: , p_validate_only => FND_API.G_FALSE
279: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
280: , p_debug_mode => 'Y'
281: , p_object_id => p_project_id
274: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
275: p_api_version => 1.0
276: , p_init_msg_list => FND_API.G_TRUE
277: , p_commit => FND_API.G_FALSE
278: , p_validate_only => FND_API.G_FALSE
279: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
280: , p_debug_mode => 'Y'
281: , p_object_id => p_project_id
282: , p_OBJECT_TYPE => 'PA_PROJECTS'
275: p_api_version => 1.0
276: , p_init_msg_list => FND_API.G_TRUE
277: , p_commit => FND_API.G_FALSE
278: , p_validate_only => FND_API.G_FALSE
279: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
280: , p_debug_mode => 'Y'
281: , p_object_id => p_project_id
282: , p_OBJECT_TYPE => 'PA_PROJECTS'
283: , p_project_role_id => p_proj_role_id
302: , x_msg_data => x_msg_data);
303:
304: IF l_debug_mode = 'Y' then
305: FOR I IN 1 .. X_MSG_COUNT LOOP
306: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_FALSE
307: ,p_msg_index => x_msg_count
308: ,p_data => x_msg_data
309: ,p_msg_index_out => l_msg_index_out);
310: tm_log('*** ERROR MESSAGE ***: '||x_msg_data);
339: end if;
340:
341: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
342: p_api_version => 1.0
343: , p_init_msg_list => FND_API.G_TRUE
344: , p_commit => FND_API.G_FALSE
345: , p_validate_only => FND_API.G_FALSE
346: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
347: , p_debug_mode => 'Y'
340:
341: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
342: p_api_version => 1.0
343: , p_init_msg_list => FND_API.G_TRUE
344: , p_commit => FND_API.G_FALSE
345: , p_validate_only => FND_API.G_FALSE
346: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
347: , p_debug_mode => 'Y'
348: , p_object_id => p_project_id
341: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
342: p_api_version => 1.0
343: , p_init_msg_list => FND_API.G_TRUE
344: , p_commit => FND_API.G_FALSE
345: , p_validate_only => FND_API.G_FALSE
346: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
347: , p_debug_mode => 'Y'
348: , p_object_id => p_project_id
349: , p_OBJECT_TYPE => 'PA_PROJECTS'
342: p_api_version => 1.0
343: , p_init_msg_list => FND_API.G_TRUE
344: , p_commit => FND_API.G_FALSE
345: , p_validate_only => FND_API.G_FALSE
346: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
347: , p_debug_mode => 'Y'
348: , p_object_id => p_project_id
349: , p_OBJECT_TYPE => 'PA_PROJECTS'
350: , p_project_role_id => p_proj_role_id
380: l_start_date_active := l_min_member_start_date;
381:
382: IF l_debug_mode = 'Y' then
383: FOR I IN 1 .. X_MSG_COUNT LOOP
384: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_FALSE
385: ,p_msg_index => x_msg_count
386: ,p_data => x_msg_data
387: ,p_msg_index_out => l_msg_index_out);
388: tm_log('*** ERROR MESSAGE ***: '||x_msg_data);
405: end if;
406:
407: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
408: p_api_version => 1.0
409: , p_init_msg_list => FND_API.G_TRUE
410: , p_commit => FND_API.G_FALSE
411: , p_validate_only => FND_API.G_FALSE
412: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
413: , p_debug_mode => 'Y'
406:
407: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
408: p_api_version => 1.0
409: , p_init_msg_list => FND_API.G_TRUE
410: , p_commit => FND_API.G_FALSE
411: , p_validate_only => FND_API.G_FALSE
412: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
413: , p_debug_mode => 'Y'
414: , p_object_id => p_project_id
407: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
408: p_api_version => 1.0
409: , p_init_msg_list => FND_API.G_TRUE
410: , p_commit => FND_API.G_FALSE
411: , p_validate_only => FND_API.G_FALSE
412: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
413: , p_debug_mode => 'Y'
414: , p_object_id => p_project_id
415: , p_OBJECT_TYPE => 'PA_PROJECTS'
408: p_api_version => 1.0
409: , p_init_msg_list => FND_API.G_TRUE
410: , p_commit => FND_API.G_FALSE
411: , p_validate_only => FND_API.G_FALSE
412: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
413: , p_debug_mode => 'Y'
414: , p_object_id => p_project_id
415: , p_OBJECT_TYPE => 'PA_PROJECTS'
416: , p_project_role_id => p_proj_role_id
446: l_start_date_active := l_proj_member_exists_rec.start_date_active;
447:
448: IF l_debug_mode = 'Y' then
449: FOR I IN 1 .. X_MSG_COUNT LOOP
450: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_FALSE
451: ,p_msg_index => x_msg_count
452: ,p_data => x_msg_data
453: ,p_msg_index_out => l_msg_index_out);
454: tm_log('*** ERROR MESSAGE ***: '||x_msg_data);
474: end if;
475:
476: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
477: p_api_version => 1.0
478: , p_init_msg_list => FND_API.G_TRUE
479: , p_commit => FND_API.G_FALSE
480: , p_validate_only => FND_API.G_FALSE
481: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
482: , p_debug_mode => 'Y'
475:
476: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
477: p_api_version => 1.0
478: , p_init_msg_list => FND_API.G_TRUE
479: , p_commit => FND_API.G_FALSE
480: , p_validate_only => FND_API.G_FALSE
481: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
482: , p_debug_mode => 'Y'
483: , p_object_id => p_project_id
476: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
477: p_api_version => 1.0
478: , p_init_msg_list => FND_API.G_TRUE
479: , p_commit => FND_API.G_FALSE
480: , p_validate_only => FND_API.G_FALSE
481: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
482: , p_debug_mode => 'Y'
483: , p_object_id => p_project_id
484: , p_OBJECT_TYPE => 'PA_PROJECTS'
477: p_api_version => 1.0
478: , p_init_msg_list => FND_API.G_TRUE
479: , p_commit => FND_API.G_FALSE
480: , p_validate_only => FND_API.G_FALSE
481: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
482: , p_debug_mode => 'Y'
483: , p_object_id => p_project_id
484: , p_OBJECT_TYPE => 'PA_PROJECTS'
485: , p_project_role_id => p_proj_role_id
504: , x_msg_data => x_msg_data);
505:
506: IF l_debug_mode = 'Y' then
507: FOR I IN 1 .. X_MSG_COUNT LOOP
508: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_FALSE
509: ,p_msg_index => x_msg_count
510: ,p_data => x_msg_data
511: ,p_msg_index_out => l_msg_index_out);
512: tm_log('*** ERROR MESSAGE ***: '||x_msg_data);
541: end if;
542:
543: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
544: p_api_version => 1.0
545: , p_init_msg_list => FND_API.G_TRUE
546: , p_commit => FND_API.G_FALSE
547: , p_validate_only => FND_API.G_FALSE
548: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
549: , p_debug_mode => 'Y'
542:
543: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
544: p_api_version => 1.0
545: , p_init_msg_list => FND_API.G_TRUE
546: , p_commit => FND_API.G_FALSE
547: , p_validate_only => FND_API.G_FALSE
548: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
549: , p_debug_mode => 'Y'
550: , p_object_id => p_project_id
543: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
544: p_api_version => 1.0
545: , p_init_msg_list => FND_API.G_TRUE
546: , p_commit => FND_API.G_FALSE
547: , p_validate_only => FND_API.G_FALSE
548: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
549: , p_debug_mode => 'Y'
550: , p_object_id => p_project_id
551: , p_OBJECT_TYPE => 'PA_PROJECTS'
544: p_api_version => 1.0
545: , p_init_msg_list => FND_API.G_TRUE
546: , p_commit => FND_API.G_FALSE
547: , p_validate_only => FND_API.G_FALSE
548: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
549: , p_debug_mode => 'Y'
550: , p_object_id => p_project_id
551: , p_OBJECT_TYPE => 'PA_PROJECTS'
552: , p_project_role_id => p_proj_role_id
582: l_start_date_active := l_min_member_start_date;
583:
584: IF l_debug_mode = 'Y' then
585: FOR I IN 1 .. X_MSG_COUNT LOOP
586: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_FALSE
587: ,p_msg_index => x_msg_count
588: ,p_data => x_msg_data
589: ,p_msg_index_out => l_msg_index_out);
590: tm_log('*** ERROR MESSAGE ***: '||x_msg_data);
606: end if;
607:
608: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
609: p_api_version => 1.0
610: , p_init_msg_list => FND_API.G_TRUE
611: , p_commit => FND_API.G_FALSE
612: , p_validate_only => FND_API.G_FALSE
613: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
614: , p_debug_mode => 'Y'
607:
608: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
609: p_api_version => 1.0
610: , p_init_msg_list => FND_API.G_TRUE
611: , p_commit => FND_API.G_FALSE
612: , p_validate_only => FND_API.G_FALSE
613: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
614: , p_debug_mode => 'Y'
615: , p_object_id => p_project_id
608: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
609: p_api_version => 1.0
610: , p_init_msg_list => FND_API.G_TRUE
611: , p_commit => FND_API.G_FALSE
612: , p_validate_only => FND_API.G_FALSE
613: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
614: , p_debug_mode => 'Y'
615: , p_object_id => p_project_id
616: , p_OBJECT_TYPE => 'PA_PROJECTS'
609: p_api_version => 1.0
610: , p_init_msg_list => FND_API.G_TRUE
611: , p_commit => FND_API.G_FALSE
612: , p_validate_only => FND_API.G_FALSE
613: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
614: , p_debug_mode => 'Y'
615: , p_object_id => p_project_id
616: , p_OBJECT_TYPE => 'PA_PROJECTS'
617: , p_project_role_id => p_proj_role_id
647: l_start_date_active := l_proj_member_exists_rec.start_date_active;
648:
649: IF l_debug_mode = 'Y' then
650: FOR I IN 1 .. X_MSG_COUNT LOOP
651: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_FALSE
652: ,p_msg_index => x_msg_count
653: ,p_data => x_msg_data
654: ,p_msg_index_out => l_msg_index_out);
655: tm_log('*** ERROR MESSAGE ***: '||x_msg_data);
673: end if;
674:
675: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
676: p_api_version => 1.0
677: , p_init_msg_list => FND_API.G_TRUE
678: , p_commit => FND_API.G_FALSE
679: , p_validate_only => FND_API.G_FALSE
680: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
681: , p_debug_mode => 'Y'
674:
675: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
676: p_api_version => 1.0
677: , p_init_msg_list => FND_API.G_TRUE
678: , p_commit => FND_API.G_FALSE
679: , p_validate_only => FND_API.G_FALSE
680: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
681: , p_debug_mode => 'Y'
682: , p_object_id => p_project_id
675: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
676: p_api_version => 1.0
677: , p_init_msg_list => FND_API.G_TRUE
678: , p_commit => FND_API.G_FALSE
679: , p_validate_only => FND_API.G_FALSE
680: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
681: , p_debug_mode => 'Y'
682: , p_object_id => p_project_id
683: , p_OBJECT_TYPE => 'PA_PROJECTS'
676: p_api_version => 1.0
677: , p_init_msg_list => FND_API.G_TRUE
678: , p_commit => FND_API.G_FALSE
679: , p_validate_only => FND_API.G_FALSE
680: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
681: , p_debug_mode => 'Y'
682: , p_object_id => p_project_id
683: , p_OBJECT_TYPE => 'PA_PROJECTS'
684: , p_project_role_id => p_proj_role_id
703: , x_msg_data => x_msg_data);
704:
705: IF l_debug_mode = 'Y' then
706: FOR I IN 1 .. X_MSG_COUNT LOOP
707: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_FALSE
708: ,p_msg_index => x_msg_count
709: ,p_data => x_msg_data
710: ,p_msg_index_out => l_msg_index_out);
711: tm_log('*** ERROR MESSAGE ***: '||x_msg_data);
875:
876:
877: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
878: p_api_version => 1.0
879: , p_init_msg_list => FND_API.G_TRUE
880: , p_commit => FND_API.G_FALSE
881: , p_validate_only => FND_API.G_FALSE
882: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
883: , p_debug_mode => 'Y'
876:
877: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
878: p_api_version => 1.0
879: , p_init_msg_list => FND_API.G_TRUE
880: , p_commit => FND_API.G_FALSE
881: , p_validate_only => FND_API.G_FALSE
882: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
883: , p_debug_mode => 'Y'
884: , p_object_id => l_selprojs_rec.project_id
877: PA_PROJECT_PARTIES_PUB.CREATE_PROJECT_PARTY(
878: p_api_version => 1.0
879: , p_init_msg_list => FND_API.G_TRUE
880: , p_commit => FND_API.G_FALSE
881: , p_validate_only => FND_API.G_FALSE
882: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
883: , p_debug_mode => 'Y'
884: , p_object_id => l_selprojs_rec.project_id
885: , p_OBJECT_TYPE => 'PA_PROJECTS'
878: p_api_version => 1.0
879: , p_init_msg_list => FND_API.G_TRUE
880: , p_commit => FND_API.G_FALSE
881: , p_validate_only => FND_API.G_FALSE
882: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
883: , p_debug_mode => 'Y'
884: , p_object_id => l_selprojs_rec.project_id
885: , p_OBJECT_TYPE => 'PA_PROJECTS'
886: , p_project_role_id => p_project_role
905: , x_msg_data => x_msg_data);
906:
907: IF l_debug_mode = 'Y' then
908: FOR I IN 1 .. X_MSG_COUNT LOOP
909: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_FALSE
910: ,p_msg_index => x_msg_count
911: ,p_data => x_msg_data
912: ,p_msg_index_out => l_msg_index_out);
913: tm_log('*** ERROR MESSAGE ***: '||x_msg_data);