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

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

458: BEGIN
459:
460: x_msg_count := 0;
461: x_return_status := FND_API.G_RET_STS_SUCCESS;
462: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
463:
464: IF l_debug_mode = 'Y' THEN
465: PA_DEBUG.set_curr_function( p_function => 'GET_OKE_FLAGS'
466: ,p_debug_mode => l_debug_mode );

Line 465: PA_DEBUG.set_curr_function( p_function => 'GET_OKE_FLAGS'

461: x_return_status := FND_API.G_RET_STS_SUCCESS;
462: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
463:
464: IF l_debug_mode = 'Y' THEN
465: PA_DEBUG.set_curr_function( p_function => 'GET_OKE_FLAGS'
466: ,p_debug_mode => l_debug_mode );
467: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';
468: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
469: END IF;

Line 467: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';

463:
464: IF l_debug_mode = 'Y' THEN
465: PA_DEBUG.set_curr_function( p_function => 'GET_OKE_FLAGS'
466: ,p_debug_mode => l_debug_mode );
467: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';
468: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
469: END IF;
470:
471: x_ready_to_ship := 'N' ;

Line 468: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

464: IF l_debug_mode = 'Y' THEN
465: PA_DEBUG.set_curr_function( p_function => 'GET_OKE_FLAGS'
466: ,p_debug_mode => l_debug_mode );
467: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';
468: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
469: END IF;
470:
471: x_ready_to_ship := 'N' ;
472: x_ready_to_procure := 'N' ;

Line 501: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';

497: x_item_shippable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Shippable_Yn(P_Deliverable_ID=>p_dlvr_version_id),'N') ;
498: x_item_billable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Billable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;
499: x_item_purchasable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Purchasable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;
500:
501: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';
502: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
503: END IF ;
504:
505: IF l_debug_mode = 'Y' THEN --Added for bug 4945876

Line 502: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

498: x_item_billable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Billable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;
499: x_item_purchasable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Purchasable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;
500:
501: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';
502: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
503: END IF ;
504:
505: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
506: pa_debug.reset_curr_function;

Line 506: pa_debug.reset_curr_function;

502: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
503: END IF ;
504:
505: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
506: pa_debug.reset_curr_function;
507: END IF ;
508:
509: EXCEPTION
510: WHEN OTHERS THEN

Line 519: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

515: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLE_UTILS'
516: ,p_procedure_name => 'GET_OKE_FLAGS');
517:
518: IF l_debug_mode = 'Y' THEN
519: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
520: pa_debug.write('GET_OKE_FLAGS:'|| g_module_name,pa_debug.g_err_stage,5);
521: pa_debug.reset_curr_function;
522: END IF;
523: RAISE;

Line 520: pa_debug.write('GET_OKE_FLAGS:'|| g_module_name,pa_debug.g_err_stage,5);

516: ,p_procedure_name => 'GET_OKE_FLAGS');
517:
518: IF l_debug_mode = 'Y' THEN
519: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
520: pa_debug.write('GET_OKE_FLAGS:'|| g_module_name,pa_debug.g_err_stage,5);
521: pa_debug.reset_curr_function;
522: END IF;
523: RAISE;
524: END GET_OKE_FLAGS ;

Line 521: pa_debug.reset_curr_function;

517:
518: IF l_debug_mode = 'Y' THEN
519: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
520: pa_debug.write('GET_OKE_FLAGS:'|| g_module_name,pa_debug.g_err_stage,5);
521: pa_debug.reset_curr_function;
522: END IF;
523: RAISE;
524: END GET_OKE_FLAGS ;
525:

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

1025:
1026: BEGIN
1027: x_msg_count := 0;
1028: x_return_status := FND_API.G_RET_STS_SUCCESS;
1029: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1030:
1031: IF l_debug_mode = 'Y' THEN
1032: PA_DEBUG.set_curr_function( p_function => 'GET_STRICTURE_INFO',
1033: p_debug_mode => l_debug_mode );

Line 1032: PA_DEBUG.set_curr_function( p_function => 'GET_STRICTURE_INFO',

1028: x_return_status := FND_API.G_RET_STS_SUCCESS;
1029: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1030:
1031: IF l_debug_mode = 'Y' THEN
1032: PA_DEBUG.set_curr_function( p_function => 'GET_STRICTURE_INFO',
1033: p_debug_mode => l_debug_mode );
1034: END IF;
1035:
1036: IF l_debug_mode = 'Y' THEN

Line 1037: Pa_Debug.g_err_stage:= 'GET_STRICTURE_INFO : Printing Input parameters';

1033: p_debug_mode => l_debug_mode );
1034: END IF;
1035:
1036: IF l_debug_mode = 'Y' THEN
1037: Pa_Debug.g_err_stage:= 'GET_STRICTURE_INFO : Printing Input parameters';
1038: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1039: l_debug_level3);
1040: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,
1041: l_debug_level3);

Line 1038: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1034: END IF;
1035:
1036: IF l_debug_mode = 'Y' THEN
1037: Pa_Debug.g_err_stage:= 'GET_STRICTURE_INFO : Printing Input parameters';
1038: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1039: l_debug_level3);
1040: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,
1041: l_debug_level3);
1042: Pa_Debug.WRITE(g_module_name,' P_STRUCTURE_TYPE '||':'|| p_structure_type,

Line 1040: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,

1036: IF l_debug_mode = 'Y' THEN
1037: Pa_Debug.g_err_stage:= 'GET_STRICTURE_INFO : Printing Input parameters';
1038: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1039: l_debug_level3);
1040: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,
1041: l_debug_level3);
1042: Pa_Debug.WRITE(g_module_name,' P_STRUCTURE_TYPE '||':'|| p_structure_type,
1043: l_debug_level3);
1044: END IF;

Line 1042: Pa_Debug.WRITE(g_module_name,' P_STRUCTURE_TYPE '||':'|| p_structure_type,

1038: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1039: l_debug_level3);
1040: Pa_Debug.WRITE(g_module_name,' P_PROJECT_ID '||':'|| p_project_id,
1041: l_debug_level3);
1042: Pa_Debug.WRITE(g_module_name,' P_STRUCTURE_TYPE '||':'|| p_structure_type,
1043: l_debug_level3);
1044: END IF;
1045:
1046: IF l_debug_mode = 'Y' THEN

Line 1047: Pa_Debug.g_err_stage:= 'Fetch Structure Info From Cursor';

1043: l_debug_level3);
1044: END IF;
1045:
1046: IF l_debug_mode = 'Y' THEN
1047: Pa_Debug.g_err_stage:= 'Fetch Structure Info From Cursor';
1048: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1049: l_debug_level3);
1050: END IF;
1051:

Line 1048: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1044: END IF;
1045:
1046: IF l_debug_mode = 'Y' THEN
1047: Pa_Debug.g_err_stage:= 'Fetch Structure Info From Cursor';
1048: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1049: l_debug_level3);
1050: END IF;
1051:
1052: OPEN l_struct_info_csr;

Line 1062: pa_debug.reset_curr_function;

1058:
1059: x_return_status := FND_API.G_RET_STS_SUCCESS;
1060:
1061: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
1062: pa_debug.reset_curr_function;
1063: END IF ;
1064:
1065: EXCEPTION
1066:

Line 1083: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

1079: , p_procedure_name => 'GET_STRUCTURE_INFO'
1080: , p_error_text => x_msg_data);
1081:
1082: IF l_debug_mode = 'Y' THEN
1083: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1084: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1085: l_debug_level5);
1086: Pa_Debug.reset_curr_function;
1087: END IF;

Line 1084: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

1080: , p_error_text => x_msg_data);
1081:
1082: IF l_debug_mode = 'Y' THEN
1083: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1084: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1085: l_debug_level5);
1086: Pa_Debug.reset_curr_function;
1087: END IF;
1088:

Line 1086: Pa_Debug.reset_curr_function;

1082: IF l_debug_mode = 'Y' THEN
1083: Pa_Debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
1084: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
1085: l_debug_level5);
1086: Pa_Debug.reset_curr_function;
1087: END IF;
1088:
1089: END GET_STRUCTURE_INFO;
1090:

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

2745:
2746: x_return_flag := null;
2747: x_return_status := FND_API.G_RET_STS_SUCCESS;
2748: x_msg_count := 0;
2749: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2750:
2751: IF l_debug_mode = 'Y' THEN
2752: PA_DEBUG.set_curr_function( p_function => 'PA_DELIVERABLE_UTILS : CHECK_DLVR_DISABLE_ALLOWED',
2753: p_debug_mode => l_debug_mode );

Line 2752: PA_DEBUG.set_curr_function( p_function => 'PA_DELIVERABLE_UTILS : CHECK_DLVR_DISABLE_ALLOWED',

2748: x_msg_count := 0;
2749: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2750:
2751: IF l_debug_mode = 'Y' THEN
2752: PA_DEBUG.set_curr_function( p_function => 'PA_DELIVERABLE_UTILS : CHECK_DLVR_DISABLE_ALLOWED',
2753: p_debug_mode => l_debug_mode );
2754: END IF;
2755:
2756: IF l_debug_mode = 'Y' THEN

Line 2757: Pa_Debug.g_err_stage:= 'PA_DELIVERABLE_UTILS : CHECK_DLVR_DISABLE_ALLOWED : Printing Input parameters';

2753: p_debug_mode => l_debug_mode );
2754: END IF;
2755:
2756: IF l_debug_mode = 'Y' THEN
2757: Pa_Debug.g_err_stage:= 'PA_DELIVERABLE_UTILS : CHECK_DLVR_DISABLE_ALLOWED : Printing Input parameters';
2758: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
2759: l_debug_level3);
2760: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,
2761: l_debug_level3);

Line 2758: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

2754: END IF;
2755:
2756: IF l_debug_mode = 'Y' THEN
2757: Pa_Debug.g_err_stage:= 'PA_DELIVERABLE_UTILS : CHECK_DLVR_DISABLE_ALLOWED : Printing Input parameters';
2758: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
2759: l_debug_level3);
2760: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,
2761: l_debug_level3);
2762: END IF;

Line 2760: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,

2756: IF l_debug_mode = 'Y' THEN
2757: Pa_Debug.g_err_stage:= 'PA_DELIVERABLE_UTILS : CHECK_DLVR_DISABLE_ALLOWED : Printing Input parameters';
2758: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
2759: l_debug_level3);
2760: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,
2761: l_debug_level3);
2762: END IF;
2763:
2764: IF 'N' = PA_PROJECT_STRUCTURE_UTILS.CHECK_DELIVERABLE_ENABLED(p_project_id) THEN

Line 2830: pa_debug.reset_curr_function;

2826: return;
2827: END IF;
2828:
2829: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
2830: pa_debug.reset_curr_function;
2831: END IF ;
2832:
2833: EXCEPTION
2834: WHEN OTHERS THEN

Line 2847: pa_debug.reset_curr_function;

2843: CLOSE cur_ship_or_proc;
2844: END IF;
2845:
2846: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
2847: pa_debug.reset_curr_function;
2848: END IF ;
2849:
2850: Fnd_Msg_Pub.add_exc_msg
2851: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'

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

2917: l_dummy NUMBER;
2918: BEGIN
2919: x_return_status := FND_API.G_RET_STS_SUCCESS;
2920: x_msg_count := 0;
2921: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2922:
2923: IF l_debug_mode = 'Y' THEN
2924: PA_DEBUG.set_curr_function( p_function => 'PA_DELIVERABLE_UTILS : UPDATE_TSK_STATUS_CANCELLED',
2925: p_debug_mode => l_debug_mode );

Line 2924: PA_DEBUG.set_curr_function( p_function => 'PA_DELIVERABLE_UTILS : UPDATE_TSK_STATUS_CANCELLED',

2920: x_msg_count := 0;
2921: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2922:
2923: IF l_debug_mode = 'Y' THEN
2924: PA_DEBUG.set_curr_function( p_function => 'PA_DELIVERABLE_UTILS : UPDATE_TSK_STATUS_CANCELLED',
2925: p_debug_mode => l_debug_mode );
2926: END IF;
2927: IF l_debug_mode = 'Y' THEN
2928: Pa_Debug.g_err_stage:= 'PA_DELIVERABLE_UTILS : UPDATE_TSK_STATUS_CANCELLED : Printing Input parameters';

Line 2928: Pa_Debug.g_err_stage:= 'PA_DELIVERABLE_UTILS : UPDATE_TSK_STATUS_CANCELLED : Printing Input parameters';

2924: PA_DEBUG.set_curr_function( p_function => 'PA_DELIVERABLE_UTILS : UPDATE_TSK_STATUS_CANCELLED',
2925: p_debug_mode => l_debug_mode );
2926: END IF;
2927: IF l_debug_mode = 'Y' THEN
2928: Pa_Debug.g_err_stage:= 'PA_DELIVERABLE_UTILS : UPDATE_TSK_STATUS_CANCELLED : Printing Input parameters';
2929: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
2930: l_debug_level3);
2931: Pa_Debug.WRITE(g_module_name,'p_task_id'||':'||p_task_id,
2932: l_debug_level3);

Line 2929: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

2925: p_debug_mode => l_debug_mode );
2926: END IF;
2927: IF l_debug_mode = 'Y' THEN
2928: Pa_Debug.g_err_stage:= 'PA_DELIVERABLE_UTILS : UPDATE_TSK_STATUS_CANCELLED : Printing Input parameters';
2929: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
2930: l_debug_level3);
2931: Pa_Debug.WRITE(g_module_name,'p_task_id'||':'||p_task_id,
2932: l_debug_level3);
2933: Pa_Debug.WRITE(g_module_name,'p_status_code'||':'||p_status_code,

Line 2931: Pa_Debug.WRITE(g_module_name,'p_task_id'||':'||p_task_id,

2927: IF l_debug_mode = 'Y' THEN
2928: Pa_Debug.g_err_stage:= 'PA_DELIVERABLE_UTILS : UPDATE_TSK_STATUS_CANCELLED : Printing Input parameters';
2929: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
2930: l_debug_level3);
2931: Pa_Debug.WRITE(g_module_name,'p_task_id'||':'||p_task_id,
2932: l_debug_level3);
2933: Pa_Debug.WRITE(g_module_name,'p_status_code'||':'||p_status_code,
2934: l_debug_level3);
2935: END IF;

Line 2933: Pa_Debug.WRITE(g_module_name,'p_status_code'||':'||p_status_code,

2929: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
2930: l_debug_level3);
2931: Pa_Debug.WRITE(g_module_name,'p_task_id'||':'||p_task_id,
2932: l_debug_level3);
2933: Pa_Debug.WRITE(g_module_name,'p_status_code'||':'||p_status_code,
2934: l_debug_level3);
2935: END IF;
2936:
2937: SELECT distinct PROJECT_SYSTEM_STATUS_CODE INTO l_system_code

Line 2965: pa_debug.reset_curr_function;

2961: WHERE proj_element_id = assoc_dlvr_rec.proj_element_id;
2962: END LOOP;
2963:
2964: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
2965: pa_debug.reset_curr_function;
2966: END IF ;
2967:
2968: EXCEPTION
2969: WHEN OTHERS THEN

Line 2982: pa_debug.reset_curr_function;

2978: CLOSE cur_get_assoc_dlvr;
2979: END IF;
2980:
2981: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
2982: pa_debug.reset_curr_function;
2983: END IF ;
2984:
2985: Fnd_Msg_Pub.add_exc_msg
2986: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'

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

3040: l_dummy NUMBER;
3041: BEGIN
3042: x_return_status := FND_API.G_RET_STS_SUCCESS;
3043: x_msg_count := 0;
3044: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3045:
3046: IF l_debug_mode = 'Y' THEN
3047: PA_DEBUG.set_curr_function( p_function => 'PA_DELIVERABLE_UTILS : CHECK_CHANGE_MAPPING_OK',
3048: p_debug_mode => l_debug_mode );

Line 3047: PA_DEBUG.set_curr_function( p_function => 'PA_DELIVERABLE_UTILS : CHECK_CHANGE_MAPPING_OK',

3043: x_msg_count := 0;
3044: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3045:
3046: IF l_debug_mode = 'Y' THEN
3047: PA_DEBUG.set_curr_function( p_function => 'PA_DELIVERABLE_UTILS : CHECK_CHANGE_MAPPING_OK',
3048: p_debug_mode => l_debug_mode );
3049: END IF;
3050:
3051: IF l_debug_mode = 'Y' THEN

Line 3052: Pa_Debug.g_err_stage := 'PA_DELIVERABLE_UTILS : CHECK_CHANGE_MAPPING_OK : Printing Input parameters';

3048: p_debug_mode => l_debug_mode );
3049: END IF;
3050:
3051: IF l_debug_mode = 'Y' THEN
3052: Pa_Debug.g_err_stage := 'PA_DELIVERABLE_UTILS : CHECK_CHANGE_MAPPING_OK : Printing Input parameters';
3053: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
3054: l_debug_level3);
3055: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,
3056: l_debug_level3);

Line 3053: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

3049: END IF;
3050:
3051: IF l_debug_mode = 'Y' THEN
3052: Pa_Debug.g_err_stage := 'PA_DELIVERABLE_UTILS : CHECK_CHANGE_MAPPING_OK : Printing Input parameters';
3053: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
3054: l_debug_level3);
3055: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,
3056: l_debug_level3);
3057: Pa_Debug.WRITE(g_module_name,'p_fp_task_verison_id'||':'||p_fp_task_verison_id,

Line 3055: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,

3051: IF l_debug_mode = 'Y' THEN
3052: Pa_Debug.g_err_stage := 'PA_DELIVERABLE_UTILS : CHECK_CHANGE_MAPPING_OK : Printing Input parameters';
3053: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
3054: l_debug_level3);
3055: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,
3056: l_debug_level3);
3057: Pa_Debug.WRITE(g_module_name,'p_fp_task_verison_id'||':'||p_fp_task_verison_id,
3058: l_debug_level3);
3059: END IF;

Line 3057: Pa_Debug.WRITE(g_module_name,'p_fp_task_verison_id'||':'||p_fp_task_verison_id,

3053: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
3054: l_debug_level3);
3055: Pa_Debug.WRITE(g_module_name,'p_wp_task_version_id'||':'||p_wp_task_version_id,
3056: l_debug_level3);
3057: Pa_Debug.WRITE(g_module_name,'p_fp_task_verison_id'||':'||p_fp_task_verison_id,
3058: l_debug_level3);
3059: END IF;
3060:
3061: OPEN cur_check_transaction_init;

Line 3071: pa_debug.reset_curr_function;

3067: END IF;
3068: CLOSE cur_check_transaction_init;
3069:
3070: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
3071: pa_debug.reset_curr_function;
3072: END IF ;
3073:
3074: EXCEPTION
3075: WHEN OTHERS THEN

Line 3084: pa_debug.reset_curr_function;

3080: IF cur_check_transaction_init%ISOPEN THEN
3081: CLOSE cur_check_transaction_init;
3082: END IF;
3083: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
3084: pa_debug.reset_curr_function;
3085: END IF ;
3086: Fnd_Msg_Pub.add_exc_msg
3087: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
3088: , p_procedure_name => 'CHECK_DLVR_DISABLE_ALLOWED'

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

3268: l_return_flag VARCHAR2(1) := 'Y';
3269: BEGIN
3270: x_return_status := FND_API.G_RET_STS_SUCCESS;
3271: x_msg_count := 0;
3272: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3273:
3274: IF l_debug_mode = 'Y' THEN
3275: PA_DEBUG.set_curr_function( p_function => 'PA_DELIVERABLE_UTILS : CHECK_PROJ_DLV_TXN_EXISTS',
3276: p_debug_mode => l_debug_mode );

Line 3275: PA_DEBUG.set_curr_function( p_function => 'PA_DELIVERABLE_UTILS : CHECK_PROJ_DLV_TXN_EXISTS',

3271: x_msg_count := 0;
3272: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3273:
3274: IF l_debug_mode = 'Y' THEN
3275: PA_DEBUG.set_curr_function( p_function => 'PA_DELIVERABLE_UTILS : CHECK_PROJ_DLV_TXN_EXISTS',
3276: p_debug_mode => l_debug_mode );
3277: END IF;
3278: IF l_debug_mode = 'Y' THEN
3279: Pa_Debug.g_err_stage:= 'PA_DELIVERABLE_UTILS : CHECK_PROJ_DLV_TXN_EXISTS : Printing Input parameters';

Line 3279: Pa_Debug.g_err_stage:= 'PA_DELIVERABLE_UTILS : CHECK_PROJ_DLV_TXN_EXISTS : Printing Input parameters';

3275: PA_DEBUG.set_curr_function( p_function => 'PA_DELIVERABLE_UTILS : CHECK_PROJ_DLV_TXN_EXISTS',
3276: p_debug_mode => l_debug_mode );
3277: END IF;
3278: IF l_debug_mode = 'Y' THEN
3279: Pa_Debug.g_err_stage:= 'PA_DELIVERABLE_UTILS : CHECK_PROJ_DLV_TXN_EXISTS : Printing Input parameters';
3280: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
3281: l_debug_level3);
3282: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,
3283: l_debug_level3);

Line 3280: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,

3276: p_debug_mode => l_debug_mode );
3277: END IF;
3278: IF l_debug_mode = 'Y' THEN
3279: Pa_Debug.g_err_stage:= 'PA_DELIVERABLE_UTILS : CHECK_PROJ_DLV_TXN_EXISTS : Printing Input parameters';
3280: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
3281: l_debug_level3);
3282: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,
3283: l_debug_level3);
3284: END IF;

Line 3282: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,

3278: IF l_debug_mode = 'Y' THEN
3279: Pa_Debug.g_err_stage:= 'PA_DELIVERABLE_UTILS : CHECK_PROJ_DLV_TXN_EXISTS : Printing Input parameters';
3280: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
3281: l_debug_level3);
3282: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,
3283: l_debug_level3);
3284: END IF;
3285:
3286: OPEN cur_proj_txn_exists;

Line 3298: pa_debug.reset_curr_function;

3294: END IF;
3295: CLOSE cur_proj_txn_exists;
3296:
3297: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
3298: pa_debug.reset_curr_function;
3299: END IF ;
3300:
3301: return l_return_flag;
3302: EXCEPTION

Line 3313: pa_debug.reset_curr_function;

3309: CLOSE cur_proj_txn_exists;
3310: END IF;
3311:
3312: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
3313: pa_debug.reset_curr_function;
3314: END IF ;
3315:
3316: Fnd_Msg_Pub.add_exc_msg
3317: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'

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

3849: BEGIN
3850:
3851: x_msg_count := 0;
3852: x_return_status := FND_API.G_RET_STS_SUCCESS;
3853: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3854:
3855: IF l_debug_mode = 'Y' THEN
3856: PA_DEBUG.set_curr_function( p_function => 'VALIDATE_DELIVERABLE', p_debug_mode => l_debug_mode );
3857: END IF;

Line 3856: PA_DEBUG.set_curr_function( p_function => 'VALIDATE_DELIVERABLE', p_debug_mode => l_debug_mode );

3852: x_return_status := FND_API.G_RET_STS_SUCCESS;
3853: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3854:
3855: IF l_debug_mode = 'Y' THEN
3856: PA_DEBUG.set_curr_function( p_function => 'VALIDATE_DELIVERABLE', p_debug_mode => l_debug_mode );
3857: END IF;
3858:
3859: IF px_dlvr_owner_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
3860: l_dlvr_owner_id := NULL;

Line 3885: Pa_Debug.WRITE(g_module_name, 'token values proj ['||l_Project_Number||'] task ['||l_task_Number||']',l_debug_level3);

3881: FROM Pa_Projects_All
3882: WHERE project_id = p_project_id;
3883:
3884: IF l_debug_mode = 'Y' THEN
3885: Pa_Debug.WRITE(g_module_name, 'token values proj ['||l_Project_Number||'] task ['||l_task_Number||']',l_debug_level3);
3886: END IF;
3887:
3888: -- Validating deliverable_name - not null
3889: IF p_dlvr_name IS NULL

Line 3912: Pa_Debug.WRITE(g_module_name,' validating deliverable name '||p_dlvr_name, l_debug_level3);

3908: RAISE FND_API.G_EXC_ERROR;
3909: END IF;
3910:
3911: IF l_debug_mode = 'Y' THEN
3912: Pa_Debug.WRITE(g_module_name,' validating deliverable name '||p_dlvr_name, l_debug_level3);
3913: END IF;
3914:
3915: -- Validating deliverable_short_name - not null
3916: IF p_dlvr_number IS NULL

Line 3939: Pa_Debug.WRITE(g_module_name,' validating deliverable short name '||p_dlvr_number, l_debug_level3);

3935: RAISE FND_API.G_EXC_ERROR;
3936: END IF;
3937:
3938: IF l_debug_mode = 'Y' THEN
3939: Pa_Debug.WRITE(g_module_name,' validating deliverable short name '||p_dlvr_number, l_debug_level3);
3940: END IF;
3941:
3942: -- Validating Deliverable Type Id - not null, valid value
3943: IF p_dlvr_type_id IS NULL

Line 3987: Pa_Debug.WRITE(g_module_name,' validating deliverable type'||p_dlvr_type_id, l_debug_level3);

3983: END IF;
3984: END IF;
3985:
3986: IF l_debug_mode = 'Y' THEN
3987: Pa_Debug.WRITE(g_module_name,' validating deliverable type'||p_dlvr_type_id, l_debug_level3);
3988: END IF;
3989:
3990: -- Validating Deliverable Owner Id - valid value
3991: IF (l_dlvr_owner_id IS NOT NULL ) THEN

Line 4003: Pa_Debug.WRITE(g_module_name,' validated owner id'||l_dlvr_owner_id||x_return_status , l_debug_level3);

3999: ,x_task_mgr_id => l_new_dlvr_owner_id -- added for bug: 4537865
4000: ,x_return_status => x_return_status
4001: ,x_error_msg_code => l_msg_data );
4002: IF l_debug_mode = 'Y' THEN
4003: Pa_Debug.WRITE(g_module_name,' validated owner id'||l_dlvr_owner_id||x_return_status , l_debug_level3);
4004: END IF;
4005:
4006: -- added for bug: 4537865
4007: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 4037: Pa_Debug.WRITE(g_module_name,' validated status code ['||px_status_code||'] outcome ['||l_status_code_valid||']' , l_debug_level3);

4033: -- Validating Status Code - valid value
4034: l_status_code_valid := Pa_Deliverable_Utils.IS_STATUS_CODE_VALID(px_status_code, p_calling_mode);
4035:
4036: IF l_debug_mode = 'Y' THEN
4037: Pa_Debug.WRITE(g_module_name,' validated status code ['||px_status_code||'] outcome ['||l_status_code_valid||']' , l_debug_level3);
4038: END IF;
4039:
4040: IF (px_status_code IS NOT NULL and l_status_code_valid = 'N') THEN
4041: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 4072: Pa_Debug.WRITE(g_module_name,' validating carrying out org'||l_carrying_out_org_id||x_return_status, l_debug_level3);

4068: ,x_organization_id => l_new_carrying_out_org_id -- added for Bug: 4537685
4069: ,x_return_status => x_return_status
4070: ,x_error_msg_code => l_msg_data);
4071: IF l_debug_mode = 'Y' THEN
4072: Pa_Debug.WRITE(g_module_name,' validating carrying out org'||l_carrying_out_org_id||x_return_status, l_debug_level3);
4073: END IF;
4074:
4075: -- added for Bug: 4537685
4076: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 4114: pa_debug.reset_curr_function;

4110: , p_calling_Mode => p_calling_Mode
4111: ) ;
4112:
4113: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
4114: pa_debug.reset_curr_function;
4115: END IF ;
4116:
4117: EXCEPTION
4118: WHEN FND_API.G_EXC_ERROR THEN

Line 4121: pa_debug.reset_curr_function;

4117: EXCEPTION
4118: WHEN FND_API.G_EXC_ERROR THEN
4119: x_return_status := FND_API.G_RET_STS_ERROR;
4120: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
4121: pa_debug.reset_curr_function;
4122: END IF ;
4123:
4124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4127: pa_debug.reset_curr_function;

4123:
4124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4126: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
4127: pa_debug.reset_curr_function;
4128: END IF ;
4129:
4130: WHEN OTHERS THEN
4131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4134: pa_debug.reset_curr_function;

4130: WHEN OTHERS THEN
4131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4132:
4133: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
4134: pa_debug.reset_curr_function;
4135: END IF ;
4136:
4137: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4138: FND_MSG_PUB.add_exc_msg

Line 4989: Pa_Debug.WRITE(g_module_name,'Progress_Enabled dlvr_type['||p_dlvr_type_id||']Prg Enabled[' ||l_dlvr_prg_enabled||

4985: x_dlvr_action_enabled => l_dlvr_action_enabled,
4986: x_dlvr_default_status_code => l_status_code
4987: );
4988:
4989: Pa_Debug.WRITE(g_module_name,'Progress_Enabled dlvr_type['||p_dlvr_type_id||']Prg Enabled[' ||l_dlvr_prg_enabled||
4990: ']Action Enabled['||l_dlvr_action_enabled||']status['||l_status_code||']',l_debug_level3);
4991:
4992: -- Override the default status code in case passed by customer.
4993: IF px_status_code IS NOT NULL THEN

Line 5068: PA_DEBUG.set_curr_function( p_function => l_api_name,

5064: savepoint CREATE_DELIVERABLE_PUB;
5065: END IF;
5066:
5067: IF p_debug_mode = 'Y' THEN
5068: PA_DEBUG.set_curr_function( p_function => l_api_name,
5069: p_debug_mode => p_debug_mode );
5070: pa_debug.g_err_stage:= 'Inside '||l_api_name;
5071: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
5072: END IF;

Line 5070: pa_debug.g_err_stage:= 'Inside '||l_api_name;

5066:
5067: IF p_debug_mode = 'Y' THEN
5068: PA_DEBUG.set_curr_function( p_function => l_api_name,
5069: p_debug_mode => p_debug_mode );
5070: pa_debug.g_err_stage:= 'Inside '||l_api_name;
5071: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
5072: END IF;
5073:
5074: -- Set API return status to success

Line 5071: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

5067: IF p_debug_mode = 'Y' THEN
5068: PA_DEBUG.set_curr_function( p_function => l_api_name,
5069: p_debug_mode => p_debug_mode );
5070: pa_debug.g_err_stage:= 'Inside '||l_api_name;
5071: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
5072: END IF;
5073:
5074: -- Set API return status to success
5075: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5099: pa_debug.write(g_module_name,'PA_PROJECT_STRUCTURE_PUB1.create_structure Return Status ['||x_return_status||']Struc ID['||l_structure_id||']',3) ;

5095: , x_structure_id => l_structure_Id
5096: );
5097:
5098: IF p_debug_mode = 'Y' THEN
5099: pa_debug.write(g_module_name,'PA_PROJECT_STRUCTURE_PUB1.create_structure Return Status ['||x_return_status||']Struc ID['||l_structure_id||']',3) ;
5100: END IF;
5101:
5102: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5124: pa_debug.write(g_module_name,'PA_PROJECT_STRUCTURE_PUB1.Create_Structure_Version Return Status ['||x_return_status||']Struc Vers ID['||l_structure_version_id||']',3) ;

5120: , x_structure_version_id => l_structure_version_id
5121: );
5122:
5123: IF p_debug_mode = 'Y' THEN
5124: pa_debug.write(g_module_name,'PA_PROJECT_STRUCTURE_PUB1.Create_Structure_Version Return Status ['||x_return_status||']Struc Vers ID['||l_structure_version_id||']',3) ;
5125: END IF;
5126:
5127: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5152: pa_debug.write(g_module_name,'PA_PROJECT_STRUCTURE_PUB1.Create_Structure_Version_Attr Return Status ['||x_return_status||']Struc ID['||l_pev_structure_id||']',3) ;

5148: , x_msg_data => x_msg_data
5149: );
5150:
5151: IF p_debug_mode = 'Y' THEN
5152: pa_debug.write(g_module_name,'PA_PROJECT_STRUCTURE_PUB1.Create_Structure_Version_Attr Return Status ['||x_return_status||']Struc ID['||l_pev_structure_id||']',3) ;
5153: END IF;
5154:
5155: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5162: pa_debug.reset_curr_function;

5158: RAISE FND_API.G_EXC_ERROR;
5159: END IF;
5160:
5161: IF p_debug_mode = 'Y' THEN --Added for bug 4945876
5162: pa_debug.reset_curr_function;
5163: END IF ;
5164:
5165: EXCEPTION
5166: WHEN FND_API.G_EXC_ERROR THEN

Line 5171: pa_debug.reset_curr_function;

5167: IF (p_commit = FND_API.G_TRUE) THEN
5168: ROLLBACK TO CREATE_DELIVERABLE_PUB;
5169: END IF;
5170: IF p_debug_mode = 'Y' THEN
5171: pa_debug.reset_curr_function;
5172: pa_debug.write(g_module_name,l_api_name||': Inside G_EXC_ERROR exception',5);
5173: END IF;
5174: x_return_status := FND_API.G_RET_STS_ERROR;
5175: x_msg_count := FND_MSG_PUB.count_msg;

Line 5172: pa_debug.write(g_module_name,l_api_name||': Inside G_EXC_ERROR exception',5);

5168: ROLLBACK TO CREATE_DELIVERABLE_PUB;
5169: END IF;
5170: IF p_debug_mode = 'Y' THEN
5171: pa_debug.reset_curr_function;
5172: pa_debug.write(g_module_name,l_api_name||': Inside G_EXC_ERROR exception',5);
5173: END IF;
5174: x_return_status := FND_API.G_RET_STS_ERROR;
5175: x_msg_count := FND_MSG_PUB.count_msg;
5176:

Line 5197: pa_debug.reset_curr_function;

5193: IF (p_commit = FND_API.G_TRUE) THEN
5194: ROLLBACK TO CREATE_DELIVERABLE_PUB;
5195: END IF;
5196: IF p_debug_mode = 'Y' THEN
5197: pa_debug.reset_curr_function;
5198:
5199: pa_debug.write(g_module_name,l_api_name||': Inside G_EXC_UNEXPECTED_ERROR exception',5);
5200: END IF;
5201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5199: pa_debug.write(g_module_name,l_api_name||': Inside G_EXC_UNEXPECTED_ERROR exception',5);

5195: END IF;
5196: IF p_debug_mode = 'Y' THEN
5197: pa_debug.reset_curr_function;
5198:
5199: pa_debug.write(g_module_name,l_api_name||': Inside G_EXC_UNEXPECTED_ERROR exception',5);
5200: END IF;
5201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5202: x_msg_count := FND_MSG_PUB.count_msg;
5203:

Line 5229: pa_debug.g_err_stage:=l_api_name||': Unexpected Error'||SQLERRM;

5225: x_msg_count := 1;
5226: x_msg_data := SQLERRM;
5227:
5228: IF p_debug_mode = 'Y' THEN
5229: pa_debug.g_err_stage:=l_api_name||': Unexpected Error'||SQLERRM;
5230: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
5231: pa_debug.reset_curr_function;
5232: END IF;
5233:

Line 5230: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);

5226: x_msg_data := SQLERRM;
5227:
5228: IF p_debug_mode = 'Y' THEN
5229: pa_debug.g_err_stage:=l_api_name||': Unexpected Error'||SQLERRM;
5230: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
5231: pa_debug.reset_curr_function;
5232: END IF;
5233:
5234:

Line 5231: pa_debug.reset_curr_function;

5227:
5228: IF p_debug_mode = 'Y' THEN
5229: pa_debug.g_err_stage:=l_api_name||': Unexpected Error'||SQLERRM;
5230: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
5231: pa_debug.reset_curr_function;
5232: END IF;
5233:
5234:
5235: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

5680: BEGIN
5681:
5682: x_msg_count := 0;
5683: x_return_status := FND_API.G_RET_STS_SUCCESS;
5684: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
5685:
5686: IF l_debug_mode = 'Y' THEN
5687: PA_DEBUG.set_curr_function( p_function => 'GET_DEFAULT_TASK'
5688: ,p_debug_mode => l_debug_mode );

Line 5687: PA_DEBUG.set_curr_function( p_function => 'GET_DEFAULT_TASK'

5683: x_return_status := FND_API.G_RET_STS_SUCCESS;
5684: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
5685:
5686: IF l_debug_mode = 'Y' THEN
5687: PA_DEBUG.set_curr_function( p_function => 'GET_DEFAULT_TASK'
5688: ,p_debug_mode => l_debug_mode );
5689: pa_debug.g_err_stage:= 'Inside GET_DEFAULT_TASK ';
5690: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
5691: END IF;

Line 5689: pa_debug.g_err_stage:= 'Inside GET_DEFAULT_TASK ';

5685:
5686: IF l_debug_mode = 'Y' THEN
5687: PA_DEBUG.set_curr_function( p_function => 'GET_DEFAULT_TASK'
5688: ,p_debug_mode => l_debug_mode );
5689: pa_debug.g_err_stage:= 'Inside GET_DEFAULT_TASK ';
5690: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
5691: END IF;
5692:
5693: l_share_type := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(p_project_id => p_project_id );

Line 5690: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

5686: IF l_debug_mode = 'Y' THEN
5687: PA_DEBUG.set_curr_function( p_function => 'GET_DEFAULT_TASK'
5688: ,p_debug_mode => l_debug_mode );
5689: pa_debug.g_err_stage:= 'Inside GET_DEFAULT_TASK ';
5690: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
5691: END IF;
5692:
5693: l_share_type := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(p_project_id => p_project_id );
5694:

Line 5698: pa_debug.write(g_module_name,'l_share_type: ' || l_share_type,3);

5694:
5695: -- 3586196 added debug statements
5696:
5697: IF l_debug_mode = 'Y' THEN
5698: pa_debug.write(g_module_name,'l_share_type: ' || l_share_type,3);
5699: END IF;
5700:
5701: -- First get the current working version. If its not available get the latest published version.
5702: l_struct_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_CURRENT_WORKING_VER_ID(p_project_id => p_project_id) ;

Line 5705: pa_debug.write(g_module_name,'l_struct_version_id: ' || l_struct_version_id,3);

5701: -- First get the current working version. If its not available get the latest published version.
5702: l_struct_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_CURRENT_WORKING_VER_ID(p_project_id => p_project_id) ;
5703:
5704: IF l_debug_mode = 'Y' THEN
5705: pa_debug.write(g_module_name,'l_struct_version_id: ' || l_struct_version_id,3);
5706: END IF;
5707:
5708: If nvl(l_struct_version_id,-99)=-99 THEN
5709: l_struct_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id => p_project_id) ;

Line 5713: pa_debug.write(g_module_name,'l_struct_version_id: ' || l_struct_version_id,3);

5709: l_struct_version_id := PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION(p_project_id => p_project_id) ;
5710: END IF ;
5711:
5712: IF l_debug_mode = 'Y' THEN
5713: pa_debug.write(g_module_name,'l_struct_version_id: ' || l_struct_version_id,3);
5714: END IF;
5715:
5716: IF l_share_type = 'SPLIT_MAPPING' THEN
5717:

Line 5729: pa_debug.write(g_module_name,'i: ' || i,3);

5725: END LOOP;
5726: CLOSE split_mapping ;
5727:
5728: IF l_debug_mode = 'Y' THEN
5729: pa_debug.write(g_module_name,'i: ' || i,3);
5730: END IF;
5731:
5732: IF i>2 THEN
5733: x_oke_task_id := null ;

Line 5749: pa_debug.write(g_module_name,'i: ' || i,3);

5745: END LOOP;
5746: CLOSE split_mapping_bill ;
5747:
5748: IF l_debug_mode = 'Y' THEN
5749: pa_debug.write(g_module_name,'i: ' || i,3);
5750: END IF;
5751:
5752: IF i>2 THEN
5753: x_bill_task_id := null ;

Line 5776: pa_debug.write(g_module_name,'i: ' || i,3);

5772: x_oke_task_number := null;
5773: END IF ;
5774:
5775: IF l_debug_mode = 'Y' THEN
5776: pa_debug.write(g_module_name,'i: ' || i,3);
5777: END IF;
5778:
5779: -- Get the default task id for BILLING
5780: OPEN share_partial_or_full_bill(l_struct_version_id) ;

Line 5790: pa_debug.write(g_module_name,'i: ' || i,3);

5786: END LOOP;
5787: CLOSE share_partial_or_full_bill ;
5788:
5789: IF l_debug_mode = 'Y' THEN
5790: pa_debug.write(g_module_name,'i: ' || i,3);
5791: END IF;
5792:
5793: IF i>2 THEN
5794: x_bill_task_id := null ;

Line 5802: pa_debug.write(g_module_name,'x_oke_task_id: ' || x_oke_task_id,3);

5798:
5799: END IF ;
5800:
5801: IF l_debug_mode = 'Y' THEN
5802: pa_debug.write(g_module_name,'x_oke_task_id: ' || x_oke_task_id,3);
5803: pa_debug.write(g_module_name,'x_oke_task_name: ' || x_oke_task_name,3);
5804: pa_debug.write(g_module_name,'x_oke_task_number: ' || x_oke_task_number,3);
5805: pa_debug.write(x_bill_task_id,'x_bill_task_id: ' || x_bill_task_id,3);
5806: pa_debug.write(g_module_name,'x_bill_task_name: ' || x_bill_task_name,3);

Line 5803: pa_debug.write(g_module_name,'x_oke_task_name: ' || x_oke_task_name,3);

5799: END IF ;
5800:
5801: IF l_debug_mode = 'Y' THEN
5802: pa_debug.write(g_module_name,'x_oke_task_id: ' || x_oke_task_id,3);
5803: pa_debug.write(g_module_name,'x_oke_task_name: ' || x_oke_task_name,3);
5804: pa_debug.write(g_module_name,'x_oke_task_number: ' || x_oke_task_number,3);
5805: pa_debug.write(x_bill_task_id,'x_bill_task_id: ' || x_bill_task_id,3);
5806: pa_debug.write(g_module_name,'x_bill_task_name: ' || x_bill_task_name,3);
5807: pa_debug.write(g_module_name,'x_bill_task_number: ' || x_bill_task_number,3);

Line 5804: pa_debug.write(g_module_name,'x_oke_task_number: ' || x_oke_task_number,3);

5800:
5801: IF l_debug_mode = 'Y' THEN
5802: pa_debug.write(g_module_name,'x_oke_task_id: ' || x_oke_task_id,3);
5803: pa_debug.write(g_module_name,'x_oke_task_name: ' || x_oke_task_name,3);
5804: pa_debug.write(g_module_name,'x_oke_task_number: ' || x_oke_task_number,3);
5805: pa_debug.write(x_bill_task_id,'x_bill_task_id: ' || x_bill_task_id,3);
5806: pa_debug.write(g_module_name,'x_bill_task_name: ' || x_bill_task_name,3);
5807: pa_debug.write(g_module_name,'x_bill_task_number: ' || x_bill_task_number,3);
5808: END IF;

Line 5805: pa_debug.write(x_bill_task_id,'x_bill_task_id: ' || x_bill_task_id,3);

5801: IF l_debug_mode = 'Y' THEN
5802: pa_debug.write(g_module_name,'x_oke_task_id: ' || x_oke_task_id,3);
5803: pa_debug.write(g_module_name,'x_oke_task_name: ' || x_oke_task_name,3);
5804: pa_debug.write(g_module_name,'x_oke_task_number: ' || x_oke_task_number,3);
5805: pa_debug.write(x_bill_task_id,'x_bill_task_id: ' || x_bill_task_id,3);
5806: pa_debug.write(g_module_name,'x_bill_task_name: ' || x_bill_task_name,3);
5807: pa_debug.write(g_module_name,'x_bill_task_number: ' || x_bill_task_number,3);
5808: END IF;
5809:

Line 5806: pa_debug.write(g_module_name,'x_bill_task_name: ' || x_bill_task_name,3);

5802: pa_debug.write(g_module_name,'x_oke_task_id: ' || x_oke_task_id,3);
5803: pa_debug.write(g_module_name,'x_oke_task_name: ' || x_oke_task_name,3);
5804: pa_debug.write(g_module_name,'x_oke_task_number: ' || x_oke_task_number,3);
5805: pa_debug.write(x_bill_task_id,'x_bill_task_id: ' || x_bill_task_id,3);
5806: pa_debug.write(g_module_name,'x_bill_task_name: ' || x_bill_task_name,3);
5807: pa_debug.write(g_module_name,'x_bill_task_number: ' || x_bill_task_number,3);
5808: END IF;
5809:
5810:

Line 5807: pa_debug.write(g_module_name,'x_bill_task_number: ' || x_bill_task_number,3);

5803: pa_debug.write(g_module_name,'x_oke_task_name: ' || x_oke_task_name,3);
5804: pa_debug.write(g_module_name,'x_oke_task_number: ' || x_oke_task_number,3);
5805: pa_debug.write(x_bill_task_id,'x_bill_task_id: ' || x_bill_task_id,3);
5806: pa_debug.write(g_module_name,'x_bill_task_name: ' || x_bill_task_name,3);
5807: pa_debug.write(g_module_name,'x_bill_task_number: ' || x_bill_task_number,3);
5808: END IF;
5809:
5810:
5811: IF l_debug_mode = 'Y' THEN

Line 5812: pa_debug.g_err_stage:= 'Exiting GET_DEFAULT_TASK' ;

5808: END IF;
5809:
5810:
5811: IF l_debug_mode = 'Y' THEN
5812: pa_debug.g_err_stage:= 'Exiting GET_DEFAULT_TASK' ;
5813: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
5814: pa_debug.reset_curr_function;
5815: END IF;
5816: EXCEPTION

Line 5813: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

5809:
5810:
5811: IF l_debug_mode = 'Y' THEN
5812: pa_debug.g_err_stage:= 'Exiting GET_DEFAULT_TASK' ;
5813: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
5814: pa_debug.reset_curr_function;
5815: END IF;
5816: EXCEPTION
5817: WHEN OTHERS THEN

Line 5814: pa_debug.reset_curr_function;

5810:
5811: IF l_debug_mode = 'Y' THEN
5812: pa_debug.g_err_stage:= 'Exiting GET_DEFAULT_TASK' ;
5813: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
5814: pa_debug.reset_curr_function;
5815: END IF;
5816: EXCEPTION
5817: WHEN OTHERS THEN
5818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5826: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

5822: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLE_UTILS'
5823: ,p_procedure_name => 'GET_DEFAULT_TASK');
5824:
5825: IF l_debug_mode = 'Y' THEN
5826: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
5827: pa_debug.write('GET_DEFAULT_TASK: ' || g_module_name,pa_debug.g_err_stage,5);
5828: pa_debug.reset_curr_function;
5829: END IF;
5830: RAISE;

Line 5827: pa_debug.write('GET_DEFAULT_TASK: ' || g_module_name,pa_debug.g_err_stage,5);

5823: ,p_procedure_name => 'GET_DEFAULT_TASK');
5824:
5825: IF l_debug_mode = 'Y' THEN
5826: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
5827: pa_debug.write('GET_DEFAULT_TASK: ' || g_module_name,pa_debug.g_err_stage,5);
5828: pa_debug.reset_curr_function;
5829: END IF;
5830: RAISE;
5831: END GET_DEFAULT_TASK;

Line 5828: pa_debug.reset_curr_function;

5824:
5825: IF l_debug_mode = 'Y' THEN
5826: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
5827: pa_debug.write('GET_DEFAULT_TASK: ' || g_module_name,pa_debug.g_err_stage,5);
5828: pa_debug.reset_curr_function;
5829: END IF;
5830: RAISE;
5831: END GET_DEFAULT_TASK;
5832:

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

6014: BEGIN
6015:
6016: x_msg_count := 0;
6017: x_return_status := FND_API.G_RET_STS_SUCCESS;
6018: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6019:
6020: IF l_debug_mode = 'Y' THEN
6021: PA_DEBUG.set_curr_function( p_function => 'GET_BILLING_DETAILS'
6022: ,p_debug_mode => l_debug_mode );

Line 6021: PA_DEBUG.set_curr_function( p_function => 'GET_BILLING_DETAILS'

6017: x_return_status := FND_API.G_RET_STS_SUCCESS;
6018: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6019:
6020: IF l_debug_mode = 'Y' THEN
6021: PA_DEBUG.set_curr_function( p_function => 'GET_BILLING_DETAILS'
6022: ,p_debug_mode => l_debug_mode );
6023: pa_debug.g_err_stage:= 'Inside GET_BILLING_DETAILS ';
6024: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
6025: END IF;

Line 6023: pa_debug.g_err_stage:= 'Inside GET_BILLING_DETAILS ';

6019:
6020: IF l_debug_mode = 'Y' THEN
6021: PA_DEBUG.set_curr_function( p_function => 'GET_BILLING_DETAILS'
6022: ,p_debug_mode => l_debug_mode );
6023: pa_debug.g_err_stage:= 'Inside GET_BILLING_DETAILS ';
6024: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
6025: END IF;
6026:
6027: OPEN bill_details;

Line 6024: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

6020: IF l_debug_mode = 'Y' THEN
6021: PA_DEBUG.set_curr_function( p_function => 'GET_BILLING_DETAILS'
6022: ,p_debug_mode => l_debug_mode );
6023: pa_debug.g_err_stage:= 'Inside GET_BILLING_DETAILS ';
6024: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
6025: END IF;
6026:
6027: OPEN bill_details;
6028: FETCH bill_details into x_bill_description, x_bill_completion_date ;

Line 6032: pa_debug.g_err_stage:= 'Exiting GET_BILLING_DETAILS' ;

6028: FETCH bill_details into x_bill_description, x_bill_completion_date ;
6029: CLOSE bill_details;
6030:
6031: IF l_debug_mode = 'Y' THEN
6032: pa_debug.g_err_stage:= 'Exiting GET_BILLING_DETAILS' ;
6033: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6034: pa_debug.reset_curr_function;
6035: END IF;
6036:

Line 6033: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);

6029: CLOSE bill_details;
6030:
6031: IF l_debug_mode = 'Y' THEN
6032: pa_debug.g_err_stage:= 'Exiting GET_BILLING_DETAILS' ;
6033: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6034: pa_debug.reset_curr_function;
6035: END IF;
6036:
6037: EXCEPTION

Line 6034: pa_debug.reset_curr_function;

6030:
6031: IF l_debug_mode = 'Y' THEN
6032: pa_debug.g_err_stage:= 'Exiting GET_BILLING_DETAILS' ;
6033: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
6034: pa_debug.reset_curr_function;
6035: END IF;
6036:
6037: EXCEPTION
6038: WHEN OTHERS THEN

Line 6047: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

6043: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLE_UTILS'
6044: ,p_procedure_name => 'GET_BILLING_DETAILS');
6045:
6046: IF l_debug_mode = 'Y' THEN
6047: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
6048: pa_debug.write('GET_BILLING_DETAILS: ' || g_module_name,pa_debug.g_err_stage,5);
6049: pa_debug.reset_curr_function;
6050: END IF;
6051: RAISE;

Line 6048: pa_debug.write('GET_BILLING_DETAILS: ' || g_module_name,pa_debug.g_err_stage,5);

6044: ,p_procedure_name => 'GET_BILLING_DETAILS');
6045:
6046: IF l_debug_mode = 'Y' THEN
6047: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
6048: pa_debug.write('GET_BILLING_DETAILS: ' || g_module_name,pa_debug.g_err_stage,5);
6049: pa_debug.reset_curr_function;
6050: END IF;
6051: RAISE;
6052: END GET_BILLING_DETAILS;

Line 6049: pa_debug.reset_curr_function;

6045:
6046: IF l_debug_mode = 'Y' THEN
6047: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
6048: pa_debug.write('GET_BILLING_DETAILS: ' || g_module_name,pa_debug.g_err_stage,5);
6049: pa_debug.reset_curr_function;
6050: END IF;
6051: RAISE;
6052: END GET_BILLING_DETAILS;
6053: