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_PROJ_ELEMENTS_UTILS dependencies on PA_PROJ_ELEMENTS_UTILS

Line 1: PACKAGE BODY PA_PROJ_ELEMENTS_UTILS AS

1: PACKAGE BODY PA_PROJ_ELEMENTS_UTILS AS
2: /* $Header: PATSK1UB.pls 120.15.12010000.3 2008/11/28 11:09:39 vgovvala ship $ */
3:
4: Invalid_Arg_Exc_WP Exception ;
5: g_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_elements_utils';

Line 5: g_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_elements_utils';

1: PACKAGE BODY PA_PROJ_ELEMENTS_UTILS AS
2: /* $Header: PATSK1UB.pls 120.15.12010000.3 2008/11/28 11:09:39 vgovvala ship $ */
3:
4: Invalid_Arg_Exc_WP Exception ;
5: g_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_elements_utils';
6:
7: -- Added for Bug 6156686
8: TYPE l_lookup_cache_tbl_typ IS TABLE OF VARCHAR2(80)
9: INDEX BY VARCHAR2(70);

Line 21: PA_PROJ_ELEMENTS_UTILS.g_Struc_Ver_Id := p_structure_version_id;

17:
18: PROCEDURE SetGlobalStrucVerId ( p_structure_version_id IN NUMBER )
19: IS
20: BEGIN
21: PA_PROJ_ELEMENTS_UTILS.g_Struc_Ver_Id := p_structure_version_id;
22: END SetGlobalStrucVerId;
23:
24: FUNCTION GetGlobalStrucVerId RETURN NUMBER
25: IS

Line 27: RETURN ( PA_PROJ_ELEMENTS_UTILS.g_Struc_Ver_Id );

23:
24: FUNCTION GetGlobalStrucVerId RETURN NUMBER
25: IS
26: BEGIN
27: RETURN ( PA_PROJ_ELEMENTS_UTILS.g_Struc_Ver_Id );
28: END GetGlobalStrucVerId;
29:
30: --This function checks if a WORKPLAN (split or shared) task
31: --may be updtaed by the logged in user.

Line 330: l_module_name VARCHAR2(100) := 'pa.plsql.PA_PROJ_ELEMENTS_UTILS';

326: l_debug_level2 CONSTANT NUMBER := 2;
327: l_debug_level3 CONSTANT NUMBER := 3;
328: l_debug_level4 CONSTANT NUMBER := 4;
329: l_debug_level5 CONSTANT NUMBER := 5;
330: l_module_name VARCHAR2(100) := 'pa.plsql.PA_PROJ_ELEMENTS_UTILS';
331:
332: l_date1 DATE ;
333: l_pev_structure_id1 pa_proj_elem_ver_structure.pev_structure_id%TYPE ;
334: l_element_version_id1 pa_proj_elem_ver_structure.element_version_id%TYPE ;

Line 598: ( p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS'

594: CLOSE cur_elem_ver_stru2;
595: END IF;
596:
597: FND_MSG_PUB.add_exc_msg
598: ( p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS'
599: ,p_procedure_name => 'Get_Last_Upd_Working_Wp_Ver'
600: ,p_error_text => x_msg_data);
601:
602: IF l_debug_mode = 'Y' THEN

Line 960: IF PA_PROJ_ELEMENTS_UTILS.structure_type(

956: return;
957: END IF;
958: -- anlee end of changes
959:
960: IF PA_PROJ_ELEMENTS_UTILS.structure_type(
961: p_structure_version_id => p_parent_structure_ver_id
962: ,p_task_version_id => null
963: ,p_structure_type => 'WORKPLAN'
964: ) = 'Y'

Line 1030: IF PA_PROJ_ELEMENTS_UTILS.structure_type(

1026: END IF;
1027: */
1028: END IF;
1029:
1030: IF PA_PROJ_ELEMENTS_UTILS.structure_type(
1031: p_structure_version_id => p_parent_structure_ver_id
1032: ,p_task_version_id => null
1033: ,p_structure_type => 'FINANCIAL'
1034: ) = 'Y' THEN

Line 1099: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',

1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1096:
1097: -- 4537865
1098: x_error_message_code := SQLCODE;
1099: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',
1100: p_procedure_name => 'Check_Delete_task_Ver_Ok',
1101: p_error_text => SUBSTRB(SQLERRM,1,240)); -- 4537865
1102: RAISE;
1103: END Check_Delete_task_Ver_Ok;

Line 1295: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',

1291: EXCEPTION
1292: WHEN OTHERS THEN
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: x_error_message_code := SQLCODE ;
1295: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',
1296: p_procedure_name => 'Check_Date_range',
1297: p_error_text => SUBSTRB(SQLERRM,1,240));
1298: RAISE;
1299: end Check_Date_range;

Line 2689: l_element_version_id := PA_PROJ_ELEMENTS_UTILS.GET_LATEST_FIN_PUB_TASK_VER_ID

2685: OPEN c1 (p_task_id);
2686: FETCH c1 INTO v_c1;
2687: CLOSE c1;
2688:
2689: l_element_version_id := PA_PROJ_ELEMENTS_UTILS.GET_LATEST_FIN_PUB_TASK_VER_ID
2690: (p_project_id => v_c1.project_id,
2691: p_task_id => p_task_id);
2692:
2693: IF l_element_version_id IS NULL THEN

Line 2735: PA_PROJ_ELEMENTS_UTILS.CHECK_DELETE_TASK_VER_OK(

2731:
2732: l_task_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ; -- 4201927 for performance issue
2733: BEGIN
2734:
2735: PA_PROJ_ELEMENTS_UTILS.CHECK_DELETE_TASK_VER_OK(
2736: p_project_id => p_project_id
2737: ,p_task_version_id => p_task_version_id
2738: ,p_parent_structure_ver_id => p_parent_structure_ver_id
2739: ,x_return_status => x_return_status

Line 2753: PA_PROJ_ELEMENTS_UTILS.Check_delete_task_ver_ok(

2749: OPEN c1;
2750: LOOP
2751: FETCH c1 into l_task_ver_id;
2752: EXIT WHEN c1%NOTFOUND;
2753: PA_PROJ_ELEMENTS_UTILS.Check_delete_task_ver_ok(
2754: p_project_id => p_project_id
2755: ,p_task_version_id => l_task_ver_id
2756: ,p_parent_structure_ver_id => p_parent_structure_ver_id
2757: ,x_return_status => x_return_status

Line 2776: PA_PROJ_ELEMENTS_UTILS.Check_delete_task_ver_ok(

2772:
2773: IF nvl(l_task_ver_id_tbl.LAST,0) > 0 THEN
2774: FOR i in reverse l_task_ver_id_tbl.FIRST..l_task_ver_id_tbl.LAST LOOP
2775:
2776: PA_PROJ_ELEMENTS_UTILS.Check_delete_task_ver_ok(
2777: p_project_id => p_project_id
2778: ,p_task_version_id => l_task_ver_id_tbl(i)
2779: ,p_parent_structure_ver_id => p_parent_structure_ver_id
2780: ,x_return_status => x_return_status

Line 2802: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',

2798: WHEN OTHERS THEN
2799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2800: -- 4537865
2801: x_error_message_code := SQLCODE ;
2802: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',
2803: p_procedure_name => 'Check_Del_all_task_Ver_Ok
2804: ');
2805: RAISE;
2806: END Check_Del_all_task_Ver_Ok;

Line 2900: If (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_proj_element_id) = 'Y') AND

2896:
2897: --if financial, check if ok to create subtask.
2898: --Bug 5988335 Adding condition for partial share project to skip financial validation
2899: --when a new subtask is getting created in workplan.
2900: If (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_proj_element_id) = 'Y') AND
2901: (PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id) <> 'SHARE_PARTIAL') --Bug 5988335
2902: THEN
2903: PA_TASK_UTILS.CHECK_CREATE_SUBTASK_OK(x_task_id => l_proj_element_id,
2904: x_err_code => l_err_code,

Line 2972: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',

2968: EXCEPTION
2969: WHEN OTHERS THEN
2970: x_return_status := 'N';
2971: x_error_message_code := SQLCODE ;
2972: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',
2973: p_procedure_name => 'Check_create_subtask_ok',
2974: p_error_text => SUBSTRB(SQLERRM,1,240));
2975: RAISE ;
2976: END Check_create_subtask_ok;

Line 3236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',

3232: EXCEPTION
3233: WHEN OTHERS THEN
3234: x_return_status := 'N' ;
3235: x_error_message_code := SQLCODE ;
3236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',
3237: p_procedure_name => 'check_move_task_ok',
3238: p_error_text => SUBSTRB(SQLERRM,1,240));
3239: RAISE ;
3240: END check_move_task_ok;

Line 3366: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',

3362: -- 4537865
3363: -- Not resetting x_error_message_code as at this point it would have been already populated.
3364: WHEN OTHERS THEN
3365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3366: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',
3367: p_procedure_name => 'Check_chg_stat_cancel_ok');
3368:
3369: -- 4537865
3370: x_error_message_code := SQLCODE ;

Line 3390: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',

3386:
3387: RETURN l_ret;
3388: EXCEPTION
3389: WHEN OTHERS THEN
3390: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',
3391: p_procedure_name => 'get_element_name');
3392: RAISE;
3393: END get_element_name;
3394:

Line 3411: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',

3407:
3408: RETURN l_ret;
3409: EXCEPTION
3410: WHEN OTHERS THEN
3411: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',
3412: p_procedure_name => 'get_element_number');
3413: RAISE;
3414: END get_element_number;
3415:

Line 3432: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',

3428:
3429: RETURN l_ret;
3430: EXCEPTION
3431: WHEN OTHERS THEN
3432: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS',
3433: p_procedure_name => 'get_element_name_number');
3434: RAISE;
3435: END get_element_name_number;
3436:

Line 3782: ( p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS'

3778: x_structure_version_id := NULL;
3779: -- 4537865 : End
3780:
3781: FND_MSG_PUB.add_exc_msg
3782: ( p_pkg_name => 'PA_PROJ_ELEMENTS_UTILS'
3783: ,p_procedure_name => 'GET_STRUCTURE_INFO'
3784: ,p_error_text => x_msg_data);
3785:
3786: IF l_debug_mode = 'Y' THEN

Line 3802: -- : PA_PROJ_ELEMENT_VERSIONS and pass to API PA_PROJ_ELEMENTS_UTILS.structure_type

3798: -- Purpose : This procedure will check whether the task has transaction or not.This API will be
3799: -- : called from Set_Financial_task_API.
3800: -- Note : Check whether it is a financial task or workplan task.
3801: -- : Fetch the parent_structure_version_id for the passed proj_element_Id from
3802: -- : PA_PROJ_ELEMENT_VERSIONS and pass to API PA_PROJ_ELEMENTS_UTILS.structure_type
3803:
3804: -- Assumptions : Only called for Financial task
3805:
3806: -- Parameters Type Required Description and Purpose

Line 3869: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : Printing Input parameters';

3865: PA_DEBUG.set_curr_function( p_function =>'CHECK_TASK_HAS_TRANSACTION' , p_debug_mode => l_debug_mode );
3866: END IF;
3867:
3868: IF l_debug_mode = 'Y' THEN
3869: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : Printing Input parameters';
3870: Pa_Debug.WRITE(g_module_name , Pa_Debug.g_err_stage , l_debug_level3);
3871: Pa_Debug.WRITE(g_module_name , 'p_task_id'||':'||p_task_id , l_debug_level3);
3872: END IF;
3873:

Line 3876: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : Validating Input Paramater';

3872: END IF;
3873:
3874:
3875: IF l_debug_mode = 'Y' THEN
3876: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : Validating Input Paramater';
3877: Pa_Debug.WRITE(g_module_name , Pa_Debug.g_err_stage , l_debug_level3);
3878: END IF;
3879:
3880: -- Validating for Input parameter

Line 3885: -- Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : Checking for financial type';

3881: IF ( p_task_id IS NOT NULL ) THEN
3882:
3883: --Commented to be reviewed once more with set financial task
3884: --IF l_debug_mode = 'Y' THEN
3885: -- Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : Checking for financial type';
3886: -- Pa_Debug.WRITE ( g_module_name , Pa_Debug.g_err_stage , l_debug_level3 );
3887: --END IF;
3888:
3889: --Select the parent structure version id for the passed task id

Line 3896: -- PA_PROJ_ELEMENTS_UTILS.structure_type

3892: --CLOSE c_get_parent_str_ver_id;
3893:
3894: --check if the structure type is financial
3895: --IF (
3896: -- PA_PROJ_ELEMENTS_UTILS.structure_type
3897: -- ( p_structure_version_id => l_prnt_str_ver_id
3898: -- , p_task_version_id => null
3899: -- , p_structure_type => 'FINANCIAL'
3900: -- ) = 'Y'

Line 3907: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check expenditure item for '|| p_task_id;

3903:
3904: -- Commenting code for 4903460 and replacing this wth new code
3905: --Check if task has expenditure item
3906: /* IF l_debug_mode = 'Y' THEN
3907: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check expenditure item for '|| p_task_id;
3908: Pa_Debug.WRITE(g_module_name , Pa_Debug.g_err_stage , l_debug_level3);
3909: END IF;
3910: l_status_code :=
3911: pa_proj_tsk_utils.check_exp_item_exists(null, p_task_id);

Line 3923: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check purchase order for '|| p_task_id;

3919: END IF;
3920:
3921: --Check if task has purchase order distribution
3922: IF l_debug_mode = 'Y' THEN
3923: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check purchase order for '|| p_task_id;
3924: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
3925: l_debug_level3);
3926: END IF;
3927: l_status_code :=

Line 3940: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check purchase order requisition for '|| p_task_id;

3936: END IF;
3937:
3938: -- Check if task has purchase order requisition
3939: IF l_debug_mode = 'Y' THEN
3940: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check purchase order requisition for '|| p_task_id;
3941: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
3942: l_debug_level3);
3943: END IF;
3944:

Line 3958: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check supplier invoice for '|| p_task_id;

3954: END IF;
3955:
3956: -- Check if task has supplier invoices
3957: IF l_debug_mode = 'Y' THEN
3958: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check supplier invoice for '|| p_task_id;
3959: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
3960: l_debug_level3);
3961: END IF;
3962:

Line 3976: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check supplier inv distribution for '|| p_task_id;

3972: END IF;
3973:
3974: -- Check if task has supplier invoice distribution
3975: IF l_debug_mode = 'Y' THEN
3976: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check supplier inv distribution for '|| p_task_id;
3977: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
3978: l_debug_level3);
3979: END IF;
3980:

Line 3994: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check commitment transaction for '|| p_task_id;

3990: END IF;
3991:
3992: -- Check if task has commitment transaction
3993: IF l_debug_mode = 'Y' THEN
3994: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check commitment transaction for '|| p_task_id;
3995: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
3996: l_debug_level3);
3997: END IF;
3998: l_status_code :=

Line 4011: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check compensation rule set for '|| p_task_id;

4007: END IF;
4008:
4009: -- Check if task has compensation rule set
4010: IF l_debug_mode = 'Y' THEN
4011: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check compensation rule set for '|| p_task_id;
4012: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
4013: l_debug_level3);
4014: END IF;
4015:

Line 4029: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check for task used in external system for'|| p_task_id;

4025: END IF; */
4026: -- End of Commenting for 4903460
4027: -- Check if task is in use in an external system
4028: IF l_debug_mode = 'Y' THEN
4029: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check for task used in external system for'|| p_task_id;
4030: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
4031: l_debug_level3);
4032: END IF;
4033:

Line 4057: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check if project allocations uses task '|| p_task_id;

4053: END IF;
4054:
4055: -- Check if task is used in allocations
4056: IF l_debug_mode = 'Y' THEN
4057: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check if project allocations uses task '|| p_task_id;
4058: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
4059: l_debug_level3);
4060: END IF;
4061:

Line 4074: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check draft invoice for '|| p_task_id;

4070: -- Commenting for Performance fix 4903460
4071: /*
4072: -- Check if task has draft invoices
4073: IF l_debug_mode = 'Y' THEN
4074: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check draft invoice for '|| p_task_id;
4075: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
4076: l_debug_level3);
4077: END IF;
4078:

Line 4092: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check Project Customers for '|| p_task_id;

4088: END IF;
4089:
4090: -- Check if task has Project_customers
4091: IF l_debug_mode = 'Y' THEN
4092: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check Project Customers for '|| p_task_id;
4093: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
4094: l_debug_level3);
4095: END IF;
4096:

Line 4111: PA_PROJ_ELEMENTS_UTILS.perform_task_validations

4107: END IF; */
4108: --End of Commenting for Performance fix 4903460
4109:
4110: -- Start of new code for Performance fix 4903460
4111: PA_PROJ_ELEMENTS_UTILS.perform_task_validations
4112: (
4113: p_project_id => p_project_id
4114: ,p_task_id => p_task_id
4115: ,x_error_code => x_error_code

Line 4127: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : Check contract association for task '|| p_task_id;

4123:
4124: -- Check if project contract is installed
4125: IF (pa_install.is_product_installed('OKE')) THEN
4126: IF l_debug_mode = 'Y' THEN
4127: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : Check contract association for task '|| p_task_id;
4128: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
4129: l_debug_level3);
4130: END IF;
4131:

Line 4157: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check if task '|| p_task_id || ' is charged in iexpense';

4153: --end of OTL check.
4154: Is_IEX_Installed := pa_install.is_product_installed('IEX');
4155: If Is_IEX_Installed then
4156: IF l_debug_mode = 'Y' THEN
4157: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : check if task '|| p_task_id || ' is charged in iexpense';
4158: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
4159: l_debug_level3);
4160: END IF;
4161:

Line 4174: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : PA_FIN_PLAN_UTILS.CHECK_DELETE_TASK_OK'|| p_task_id;

4170: END IF;
4171: END IF;
4172: --BEGIN
4173: IF l_debug_mode = 'Y' THEN
4174: Pa_Debug.g_err_stage:= 'PA_PROJ_ELEMENTS_UTILS : CHECK_TASK_HAS_TRANSACTION : PA_FIN_PLAN_UTILS.CHECK_DELETE_TASK_OK'|| p_task_id;
4175: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
4176: l_debug_level3);
4177: END IF;
4178:

Line 4528: ELSIF PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(p_proj_element_id) = 'N' THEN

4524: --If sharing is enabled, then financial and workplan tasks would be common
4525: IF str_sharing_code = 'SHARE_FULL' OR
4526: str_sharing_code = 'SHARE_PARTIAL' THEN
4527: return_flag := 'Y';
4528: ELSIF PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(p_proj_element_id) = 'N' THEN
4529: return_flag := 'Y';
4530: ELSE
4531: return_flag := 'N';
4532: END IF;

Line 5907: END PA_PROJ_ELEMENTS_UTILS;

5903: raise;
5904: END IS_LOWEST_PROJ_TASK;
5905:
5906:
5907: END PA_PROJ_ELEMENTS_UTILS;