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_STRUCTURE_UTILS dependencies on PA_DEBUG

Line 1005: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

1001:
1002:
1003: BEGIN
1004:
1005: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1006:
1007: IF l_debug_mode = 'Y' THEN
1008:
1009: pa_debug.g_err_stage := 'The value of passed user_id to this api is: ' || p_user_id;

Line 1009: pa_debug.g_err_stage := 'The value of passed user_id to this api is: ' || p_user_id;

1005: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1006:
1007: IF l_debug_mode = 'Y' THEN
1008:
1009: pa_debug.g_err_stage := 'The value of passed user_id to this api is: ' || p_user_id;
1010: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1011:
1012: pa_debug.g_err_stage := 'The value of passed structure version_id to this api is: ' || p_structure_version_id;
1013: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

Line 1010: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

1006:
1007: IF l_debug_mode = 'Y' THEN
1008:
1009: pa_debug.g_err_stage := 'The value of passed user_id to this api is: ' || p_user_id;
1010: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1011:
1012: pa_debug.g_err_stage := 'The value of passed structure version_id to this api is: ' || p_structure_version_id;
1013: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1014:

Line 1012: pa_debug.g_err_stage := 'The value of passed structure version_id to this api is: ' || p_structure_version_id;

1008:
1009: pa_debug.g_err_stage := 'The value of passed user_id to this api is: ' || p_user_id;
1010: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1011:
1012: pa_debug.g_err_stage := 'The value of passed structure version_id to this api is: ' || p_structure_version_id;
1013: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1014:
1015: END IF;
1016:

Line 1013: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

1009: pa_debug.g_err_stage := 'The value of passed user_id to this api is: ' || p_user_id;
1010: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1011:
1012: pa_debug.g_err_stage := 'The value of passed structure version_id to this api is: ' || p_structure_version_id;
1013: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1014:
1015: END IF;
1016:
1017: OPEN get_lock_user;

Line 1030: pa_debug.g_err_stage := 'The Structure version passed is locked by person id : ' || l_locked_person_id;

1026: return 'N';
1027: END IF;
1028:
1029: IF l_debug_mode = 'Y' THEN
1030: pa_debug.g_err_stage := 'The Structure version passed is locked by person id : ' || l_locked_person_id;
1031: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1032: END IF;
1033:
1034:

Line 1031: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

1027: END IF;
1028:
1029: IF l_debug_mode = 'Y' THEN
1030: pa_debug.g_err_stage := 'The Structure version passed is locked by person id : ' || l_locked_person_id;
1031: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1032: END IF;
1033:
1034:
1035: --structure version is locked. Continue.

Line 1045: pa_debug.g_err_stage := 'The person id of the fnd user passed is : ' || l_person_id;

1041: END IF;
1042: CLOSE get_person_id;
1043:
1044: IF l_debug_mode = 'Y' THEN
1045: pa_debug.g_err_stage := 'The person id of the fnd user passed is : ' || l_person_id;
1046: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1047: END IF;
1048:
1049:

Line 1046: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);

1042: CLOSE get_person_id;
1043:
1044: IF l_debug_mode = 'Y' THEN
1045: pa_debug.g_err_stage := 'The person id of the fnd user passed is : ' || l_person_id;
1046: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1047: END IF;
1048:
1049:
1050: IF (l_person_id = l_locked_person_id) THEN

Line 3563: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

3559: BEGIN
3560:
3561: x_msg_count := 0;
3562: x_return_status := FND_API.G_RET_STS_SUCCESS;
3563: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3564:
3565: IF l_debug_mode = 'Y' THEN
3566: pa_debug.set_curr_function( p_function => 'GET_CONC_REQUEST_DETAILS',
3567: p_debug_mode => l_debug_mode );

Line 3566: pa_debug.set_curr_function( p_function => 'GET_CONC_REQUEST_DETAILS',

3562: x_return_status := FND_API.G_RET_STS_SUCCESS;
3563: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3564:
3565: IF l_debug_mode = 'Y' THEN
3566: pa_debug.set_curr_function( p_function => 'GET_CONC_REQUEST_DETAILS',
3567: p_debug_mode => l_debug_mode );
3568: END IF;
3569:
3570: -- Check for business rules violations

Line 3572: pa_debug.g_err_stage:= 'Validating input parameters';

3568: END IF;
3569:
3570: -- Check for business rules violations
3571: IF l_debug_mode = 'Y' THEN
3572: pa_debug.g_err_stage:= 'Validating input parameters';
3573: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3574:
3575: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
3576: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 3573: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

3569:
3570: -- Check for business rules violations
3571: IF l_debug_mode = 'Y' THEN
3572: pa_debug.g_err_stage:= 'Validating input parameters';
3573: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3574:
3575: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
3576: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3577:

Line 3575: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;

3571: IF l_debug_mode = 'Y' THEN
3572: pa_debug.g_err_stage:= 'Validating input parameters';
3573: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3574:
3575: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
3576: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3577:
3578: pa_debug.g_err_stage:= 'p_structure_type ='|| p_structure_type;
3579: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 3576: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

3572: pa_debug.g_err_stage:= 'Validating input parameters';
3573: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3574:
3575: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
3576: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3577:
3578: pa_debug.g_err_stage:= 'p_structure_type ='|| p_structure_type;
3579: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3580: END IF;

Line 3578: pa_debug.g_err_stage:= 'p_structure_type ='|| p_structure_type;

3574:
3575: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
3576: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3577:
3578: pa_debug.g_err_stage:= 'p_structure_type ='|| p_structure_type;
3579: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3580: END IF;
3581:
3582: IF (p_project_id IS NULL) OR

Line 3579: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

3575: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
3576: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3577:
3578: pa_debug.g_err_stage:= 'p_structure_type ='|| p_structure_type;
3579: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3580: END IF;
3581:
3582: IF (p_project_id IS NULL) OR
3583: (p_structure_type IS NULL)

Line 3599: pa_debug.g_err_stage:= 'request id : ' || x_request_id;

3595: x_structure_version_id;
3596: close cur_request_details;
3597:
3598: IF l_debug_mode = 'Y' THEN
3599: pa_debug.g_err_stage:= 'request id : ' || x_request_id;
3600: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3601:
3602: pa_debug.g_err_stage:= 'process code : ' || x_process_code;
3603: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 3600: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

3596: close cur_request_details;
3597:
3598: IF l_debug_mode = 'Y' THEN
3599: pa_debug.g_err_stage:= 'request id : ' || x_request_id;
3600: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3601:
3602: pa_debug.g_err_stage:= 'process code : ' || x_process_code;
3603: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3604:

Line 3602: pa_debug.g_err_stage:= 'process code : ' || x_process_code;

3598: IF l_debug_mode = 'Y' THEN
3599: pa_debug.g_err_stage:= 'request id : ' || x_request_id;
3600: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3601:
3602: pa_debug.g_err_stage:= 'process code : ' || x_process_code;
3603: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3604:
3605: pa_debug.g_err_stage:= 'structure version id : '||x_structure_version_id;
3606: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 3603: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

3599: pa_debug.g_err_stage:= 'request id : ' || x_request_id;
3600: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3601:
3602: pa_debug.g_err_stage:= 'process code : ' || x_process_code;
3603: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3604:
3605: pa_debug.g_err_stage:= 'structure version id : '||x_structure_version_id;
3606: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3607:

Line 3605: pa_debug.g_err_stage:= 'structure version id : '||x_structure_version_id;

3601:
3602: pa_debug.g_err_stage:= 'process code : ' || x_process_code;
3603: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3604:
3605: pa_debug.g_err_stage:= 'structure version id : '||x_structure_version_id;
3606: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3607:
3608: pa_debug.g_err_stage:= 'Exiting GET_CONC_REQUEST_DETAILS';
3609: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 3606: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

3602: pa_debug.g_err_stage:= 'process code : ' || x_process_code;
3603: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3604:
3605: pa_debug.g_err_stage:= 'structure version id : '||x_structure_version_id;
3606: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3607:
3608: pa_debug.g_err_stage:= 'Exiting GET_CONC_REQUEST_DETAILS';
3609: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3610: pa_debug.reset_curr_function;

Line 3608: pa_debug.g_err_stage:= 'Exiting GET_CONC_REQUEST_DETAILS';

3604:
3605: pa_debug.g_err_stage:= 'structure version id : '||x_structure_version_id;
3606: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3607:
3608: pa_debug.g_err_stage:= 'Exiting GET_CONC_REQUEST_DETAILS';
3609: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3610: pa_debug.reset_curr_function;
3611: END IF;
3612: EXCEPTION

Line 3609: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

3605: pa_debug.g_err_stage:= 'structure version id : '||x_structure_version_id;
3606: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3607:
3608: pa_debug.g_err_stage:= 'Exiting GET_CONC_REQUEST_DETAILS';
3609: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3610: pa_debug.reset_curr_function;
3611: END IF;
3612: EXCEPTION
3613:

Line 3610: pa_debug.reset_curr_function;

3606: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3607:
3608: pa_debug.g_err_stage:= 'Exiting GET_CONC_REQUEST_DETAILS';
3609: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
3610: pa_debug.reset_curr_function;
3611: END IF;
3612: EXCEPTION
3613:
3614: WHEN Invalid_Arg_Exc_WP THEN

Line 3642: pa_debug.reset_curr_function;

3638: ELSE
3639: x_msg_count := l_msg_count;
3640: END IF;
3641: IF l_debug_mode = 'Y' THEN
3642: pa_debug.reset_curr_function;
3643: END IF;
3644:
3645: RETURN;
3646:

Line 3668: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

3664: ,p_procedure_name => 'GET_CONC_REQUEST_DETAILS'
3665: ,p_error_text => x_msg_data);
3666:
3667: IF l_debug_mode = 'Y' THEN
3668: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3669: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3670: pa_debug.reset_curr_function;
3671: END IF;
3672: RAISE;

Line 3669: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

3665: ,p_error_text => x_msg_data);
3666:
3667: IF l_debug_mode = 'Y' THEN
3668: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3669: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3670: pa_debug.reset_curr_function;
3671: END IF;
3672: RAISE;
3673: END GET_CONC_REQUEST_DETAILS;

Line 3670: pa_debug.reset_curr_function;

3666:
3667: IF l_debug_mode = 'Y' THEN
3668: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
3669: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3670: pa_debug.reset_curr_function;
3671: END IF;
3672: RAISE;
3673: END GET_CONC_REQUEST_DETAILS;
3674:

Line 4795: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

4791: savepoint lock_unlock_wp_str;
4792:
4793: x_msg_count := 0;
4794: x_return_status := FND_API.G_RET_STS_SUCCESS;
4795: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4796:
4797: if l_debug_mode = 'Y' THEN
4798: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str_autonomous');
4799: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);

Line 4798: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str_autonomous');

4794: x_return_status := FND_API.G_RET_STS_SUCCESS;
4795: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4796:
4797: if l_debug_mode = 'Y' THEN
4798: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str_autonomous');
4799: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4800: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4801: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4802: end if;

Line 4799: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);

4795: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4796:
4797: if l_debug_mode = 'Y' THEN
4798: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str_autonomous');
4799: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4800: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4801: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4802: end if;
4803:

Line 4800: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);

4796:
4797: if l_debug_mode = 'Y' THEN
4798: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str_autonomous');
4799: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4800: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4801: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4802: end if;
4803:
4804: l_wp_str := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');

Line 4801: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);

4797: if l_debug_mode = 'Y' THEN
4798: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str_autonomous');
4799: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4800: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4801: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4802: end if;
4803:
4804: l_wp_str := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
4805:

Line 4807: pa_debug.write(l_module_name,'l_wp_str = '||l_wp_str,3);

4803:
4804: l_wp_str := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
4805:
4806: if l_debug_mode = 'Y' THEN
4807: pa_debug.write(l_module_name,'l_wp_str = '||l_wp_str,3);
4808: end if;
4809:
4810: if (l_wp_str = 'Y') then
4811:

Line 4817: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);

4813: fetch l_cur_ppevs into l_rec_ppevs;
4814: close l_cur_ppevs;
4815:
4816: if l_debug_mode = 'Y' THEN
4817: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4818: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4819: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4820: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4821: end if;

Line 4818: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);

4814: close l_cur_ppevs;
4815:
4816: if l_debug_mode = 'Y' THEN
4817: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4818: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4819: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4820: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4821: end if;
4822:

Line 4819: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);

4815:
4816: if l_debug_mode = 'Y' THEN
4817: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4818: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4819: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4820: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4821: end if;
4822:
4823: pa_project_structure_pub1.update_structure_version_attr

Line 4820: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);

4816: if l_debug_mode = 'Y' THEN
4817: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4818: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4819: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4820: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4821: end if;
4822:
4823: pa_project_structure_pub1.update_structure_version_attr
4824: (p_pev_structure_id => l_rec_ppevs.pev_structure_id

Line 4835: pa_debug.write(l_module_name,'After calling pa_project_structure_pub1.update_structure_version_attr x_return_status='||x_return_status,3);

4831: , x_msg_count => x_msg_count
4832: , x_msg_data => x_msg_data);
4833:
4834: if l_debug_mode = 'Y' THEN
4835: pa_debug.write(l_module_name,'After calling pa_project_structure_pub1.update_structure_version_attr x_return_status='||x_return_status,3);
4836: end if;
4837:
4838:
4839: end if;

Line 4892: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

4888: savepoint lock_unlock_wp_str2;
4889:
4890: x_msg_count := 0;
4891: x_return_status := FND_API.G_RET_STS_SUCCESS;
4892: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4893:
4894: if l_debug_mode = 'Y' THEN
4895: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str');
4896: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);

Line 4895: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str');

4891: x_return_status := FND_API.G_RET_STS_SUCCESS;
4892: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4893:
4894: if l_debug_mode = 'Y' THEN
4895: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str');
4896: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4897: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4898: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4899: end if;

Line 4896: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);

4892: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4893:
4894: if l_debug_mode = 'Y' THEN
4895: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str');
4896: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4897: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4898: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4899: end if;
4900:

Line 4897: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);

4893:
4894: if l_debug_mode = 'Y' THEN
4895: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str');
4896: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4897: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4898: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4899: end if;
4900:
4901: l_wp_str := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');

Line 4898: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);

4894: if l_debug_mode = 'Y' THEN
4895: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str');
4896: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4897: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4898: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4899: end if;
4900:
4901: l_wp_str := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
4902:

Line 4904: pa_debug.write(l_module_name,'l_wp_str = '||l_wp_str,3);

4900:
4901: l_wp_str := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
4902:
4903: if l_debug_mode = 'Y' THEN
4904: pa_debug.write(l_module_name,'l_wp_str = '||l_wp_str,3);
4905: end if;
4906:
4907: if (l_wp_str = 'Y') then
4908:

Line 4914: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);

4910: fetch l_cur_ppevs into l_rec_ppevs;
4911: close l_cur_ppevs;
4912:
4913: if l_debug_mode = 'Y' THEN
4914: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4915: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4916: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4917: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4918: end if;

Line 4915: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);

4911: close l_cur_ppevs;
4912:
4913: if l_debug_mode = 'Y' THEN
4914: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4915: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4916: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4917: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4918: end if;
4919:

Line 4916: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);

4912:
4913: if l_debug_mode = 'Y' THEN
4914: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4915: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4916: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4917: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4918: end if;
4919:
4920: pa_project_structure_pub1.update_structure_version_attr

Line 4917: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);

4913: if l_debug_mode = 'Y' THEN
4914: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4915: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4916: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4917: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4918: end if;
4919:
4920: pa_project_structure_pub1.update_structure_version_attr
4921: (p_pev_structure_id => l_rec_ppevs.pev_structure_id

Line 4932: pa_debug.write(l_module_name,'After calling pa_project_structure_pub1.update_structure_version_attr x_return_status='||x_return_status,3);

4928: , x_msg_count => x_msg_count
4929: , x_msg_data => x_msg_data);
4930:
4931: if l_debug_mode = 'Y' THEN
4932: pa_debug.write(l_module_name,'After calling pa_project_structure_pub1.update_structure_version_attr x_return_status='||x_return_status,3);
4933: end if;
4934:
4935:
4936: end if;