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 4758: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

4754: savepoint lock_unlock_wp_str;
4755:
4756: x_msg_count := 0;
4757: x_return_status := FND_API.G_RET_STS_SUCCESS;
4758: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4759:
4760: if l_debug_mode = 'Y' THEN
4761: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str_autonomous');
4762: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);

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

4757: x_return_status := FND_API.G_RET_STS_SUCCESS;
4758: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4759:
4760: if l_debug_mode = 'Y' THEN
4761: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str_autonomous');
4762: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4763: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4764: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4765: end if;

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

4758: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4759:
4760: if l_debug_mode = 'Y' THEN
4761: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str_autonomous');
4762: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4763: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4764: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4765: end if;
4766:

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

4759:
4760: if l_debug_mode = 'Y' THEN
4761: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str_autonomous');
4762: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4763: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4764: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4765: end if;
4766:
4767: l_wp_str := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');

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

4760: if l_debug_mode = 'Y' THEN
4761: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str_autonomous');
4762: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4763: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4764: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4765: end if;
4766:
4767: l_wp_str := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
4768:

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

4766:
4767: l_wp_str := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
4768:
4769: if l_debug_mode = 'Y' THEN
4770: pa_debug.write(l_module_name,'l_wp_str = '||l_wp_str,3);
4771: end if;
4772:
4773: if (l_wp_str = 'Y') then
4774:

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

4776: fetch l_cur_ppevs into l_rec_ppevs;
4777: close l_cur_ppevs;
4778:
4779: if l_debug_mode = 'Y' THEN
4780: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4781: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4782: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4783: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4784: end if;

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

4777: close l_cur_ppevs;
4778:
4779: if l_debug_mode = 'Y' THEN
4780: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4781: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4782: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4783: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4784: end if;
4785:

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

4778:
4779: if l_debug_mode = 'Y' THEN
4780: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4781: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4782: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4783: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4784: end if;
4785:
4786: pa_project_structure_pub1.update_structure_version_attr

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

4779: if l_debug_mode = 'Y' THEN
4780: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4781: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4782: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4783: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4784: end if;
4785:
4786: pa_project_structure_pub1.update_structure_version_attr
4787: (p_pev_structure_id => l_rec_ppevs.pev_structure_id

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

4794: , x_msg_count => x_msg_count
4795: , x_msg_data => x_msg_data);
4796:
4797: if l_debug_mode = 'Y' THEN
4798: pa_debug.write(l_module_name,'After calling pa_project_structure_pub1.update_structure_version_attr x_return_status='||x_return_status,3);
4799: end if;
4800:
4801:
4802: end if;

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

4851: savepoint lock_unlock_wp_str2;
4852:
4853: x_msg_count := 0;
4854: x_return_status := FND_API.G_RET_STS_SUCCESS;
4855: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4856:
4857: if l_debug_mode = 'Y' THEN
4858: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str');
4859: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);

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

4854: x_return_status := FND_API.G_RET_STS_SUCCESS;
4855: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4856:
4857: if l_debug_mode = 'Y' THEN
4858: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str');
4859: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4860: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4861: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4862: end if;

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

4855: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4856:
4857: if l_debug_mode = 'Y' THEN
4858: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str');
4859: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4860: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4861: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4862: end if;
4863:

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

4856:
4857: if l_debug_mode = 'Y' THEN
4858: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str');
4859: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4860: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4861: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4862: end if;
4863:
4864: l_wp_str := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');

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

4857: if l_debug_mode = 'Y' THEN
4858: pa_debug.set_curr_function( p_function => 'lock_unlock_wp_str');
4859: pa_debug.write(l_module_name,'p_project_id = '||p_project_id,3);
4860: pa_debug.write(l_module_name,'p_structure_version_id = '||p_structure_version_id,3);
4861: pa_debug.write(l_module_name,'p_lock_status_code = '||p_lock_status_code,3);
4862: end if;
4863:
4864: l_wp_str := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
4865:

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

4863:
4864: l_wp_str := PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN');
4865:
4866: if l_debug_mode = 'Y' THEN
4867: pa_debug.write(l_module_name,'l_wp_str = '||l_wp_str,3);
4868: end if;
4869:
4870: if (l_wp_str = 'Y') then
4871:

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

4873: fetch l_cur_ppevs into l_rec_ppevs;
4874: close l_cur_ppevs;
4875:
4876: if l_debug_mode = 'Y' THEN
4877: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4878: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4879: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4880: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4881: end if;

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

4874: close l_cur_ppevs;
4875:
4876: if l_debug_mode = 'Y' THEN
4877: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4878: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4879: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4880: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4881: end if;
4882:

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

4875:
4876: if l_debug_mode = 'Y' THEN
4877: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4878: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4879: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4880: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4881: end if;
4882:
4883: pa_project_structure_pub1.update_structure_version_attr

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

4876: if l_debug_mode = 'Y' THEN
4877: pa_debug.write(l_module_name,'Before Calling pa_project_structure_pub1.update_structure_version_attr',3);
4878: pa_debug.write(l_module_name,'l_rec_ppevs.pev_structure_id = '||l_rec_ppevs.pev_structure_id,3);
4879: pa_debug.write(l_module_name,'l_rec_ppevs.name= '||l_rec_ppevs.name,3);
4880: pa_debug.write(l_module_name,'l_rec_ppevs.record_version_number= '||l_rec_ppevs.record_version_number,3);
4881: end if;
4882:
4883: pa_project_structure_pub1.update_structure_version_attr
4884: (p_pev_structure_id => l_rec_ppevs.pev_structure_id

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

4891: , x_msg_count => x_msg_count
4892: , x_msg_data => x_msg_data);
4893:
4894: if l_debug_mode = 'Y' THEN
4895: pa_debug.write(l_module_name,'After calling pa_project_structure_pub1.update_structure_version_attr x_return_status='||x_return_status,3);
4896: end if;
4897:
4898:
4899: end if;