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_PLANNING_RESOURCE_UTILS dependencies on PA_PLANNING_RESOURCE_UTILS

Line 1: PACKAGE BODY PA_PLANNING_RESOURCE_UTILS AS

1: PACKAGE BODY PA_PLANNING_RESOURCE_UTILS AS
2: /* $Header: PARPRLUB.pls 120.29 2012/02/01 13:05:24 djambhek ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: g_module_name VARCHAR2(100) := 'pa.plsql.PA_PLANNING_RESOURCE_UTILS';

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

1: PACKAGE BODY PA_PLANNING_RESOURCE_UTILS AS
2: /* $Header: PARPRLUB.pls 120.29 2012/02/01 13:05:24 djambhek ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: g_module_name VARCHAR2(100) := 'pa.plsql.PA_PLANNING_RESOURCE_UTILS';
6: g_job_group_id NUMBER;
7: /********************************************************
8: * Check whether any planning resources or class defaults for the spread
9: * curve exist.

Line 1597: pa_planning_resource_utils.Check_PersonName_or_ID(

1593: Pa_Planning_Resource_Pvt.g_token);
1594: END;
1595: ELSIF p_res_type_code = 'NAMED_PERSON' THEN
1596:
1597: pa_planning_resource_utils.Check_PersonName_or_ID(
1598: p_person_id => p_resource_code,
1599: p_person_name => p_resource_name,
1600: p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,
1601: x_person_id => l_person_id,

Line 1649: pa_planning_resource_utils.Check_BOM_EqLabor_or_ID(

1645: Return;
1646: END IF;
1647: ELSIF p_res_type_code = 'BOM_LABOR' THEN
1648:
1649: pa_planning_resource_utils.Check_BOM_EqLabor_or_ID(
1650: p_bom_eqlabor_id => p_resource_code,
1651: p_bom_eqlabor_name => p_resource_name,
1652: p_res_type_code => 2,
1653: p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,

Line 1675: pa_planning_resource_utils.Check_BOM_EqLabor_or_ID(

1671: Return;
1672: END IF;
1673: ELSIF p_res_type_code = 'BOM_EQUIPMENT' THEN
1674:
1675: pa_planning_resource_utils.Check_BOM_EqLabor_or_ID(
1676: p_bom_eqlabor_id => p_resource_code,
1677: p_bom_eqlabor_name => p_resource_name,
1678: p_res_type_code => 1,
1679: p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,

Line 1721: Pa_planning_resource_utils.Check_ItemCat_or_ID(

1717: x_error_msg_code:= 'PA_NO_ITEM_CATEGORY_SET';
1718: Return;
1719: END;
1720:
1721: Pa_planning_resource_utils.Check_ItemCat_or_ID(
1722: P_item_cat_id => p_resource_code,
1723: P_item_cat_name => p_resource_name,
1724: P_item_category_set_id => l_item_category_set_id,
1725: P_check_id_flag => PA_STARTUP.G_Check_ID_Flag,

Line 1762: Pa_planning_resource_utils.Check_InventoryItem_or_ID(

1758: --Need to get a proper message
1759: x_error_msg_code:= 'PA_NO_MAT_ITEM_ID';
1760: Return;
1761: END;
1762: Pa_planning_resource_utils.Check_InventoryItem_or_ID(
1763: P_item_id => p_resource_code,
1764: P_item_name => p_resource_name,
1765: P_item_master_id => l_item_master_id,
1766: P_check_id_flag => PA_STARTUP.G_Check_ID_Flag,

Line 2678: pa_planning_resource_utils.default_job;

2674: * Call the Procedure Default_job which will Update the Job ID
2675: * in the temp table pa_res_members_temp with the correct
2676: * value.
2677: * *****************************************************************/
2678: pa_planning_resource_utils.default_job;
2679:
2680: /******************************************************************
2681: * Call the Procedure default_person_type which will Update the
2682: * person_type_code in the temp table pa_res_members_temp with the correct

Line 2685: pa_planning_resource_utils.default_person_type;

2681: * Call the Procedure default_person_type which will Update the
2682: * person_type_code in the temp table pa_res_members_temp with the correct
2683: * value.
2684: * *****************************************************************/
2685: pa_planning_resource_utils.default_person_type;
2686:
2687: /******************************************************************
2688: * Call the Procedure Default_Organization which will
2689: * Update the organization_id and rate_incurred_by_org_id

Line 2693: pa_planning_resource_utils.default_organization(

2689: * Update the organization_id and rate_incurred_by_org_id
2690: * in the temp table pa_res_members_temp with the correct
2691: * values.
2692: * *****************************************************************/
2693: pa_planning_resource_utils.default_organization(
2694: p_project_id => p_project_id);
2695:
2696: /******************************************************************
2697: * Call the Procedure Default_Expenditure_Type which will

Line 2702: pa_planning_resource_utils.default_expenditure_type;

2698: * Update the expenditure_type
2699: * in the temp table pa_res_members_temp with the correct
2700: * values.
2701: * *****************************************************************/
2702: pa_planning_resource_utils.default_expenditure_type;
2703:
2704: /******************************************************************
2705: * Call the Procedure Default_Rate_Expenditure_Type which will
2706: * Update the rate_expenditure_type

Line 2710: pa_planning_resource_utils.default_rate_expenditure_type;

2706: * Update the rate_expenditure_type
2707: * in the temp table pa_res_members_temp with the correct
2708: * values.
2709: * *****************************************************************/
2710: pa_planning_resource_utils.default_rate_expenditure_type;
2711:
2712: /******************************************************************
2713: * Call the Procedure Default_Supplier which will
2714: * Update the vendor_id

Line 2718: pa_planning_resource_utils.default_supplier;

2714: * Update the vendor_id
2715: * in the temp table pa_res_members_temp with the correct
2716: * values.
2717: * *****************************************************************/
2718: pa_planning_resource_utils.default_supplier;
2719:
2720: /******************************************************************
2721: * Call the Procedure Default_rate_based which will
2722: * Update the Rate_based_flag

Line 2726: pa_planning_resource_utils.default_rate_based;

2722: * Update the Rate_based_flag
2723: * in the temp table pa_res_members_temp with the correct
2724: * values.
2725: * *****************************************************************/
2726: pa_planning_resource_utils.default_rate_based;
2727:
2728: /******************************************************************
2729: * Call the Procedure Default_OU which will
2730: * Update the OU

Line 2734: pa_planning_resource_utils.default_ou(p_project_id);

2730: * Update the OU
2731: * in the temp table pa_res_members_temp with the correct
2732: * values.
2733: *****************************************************************/
2734: pa_planning_resource_utils.default_ou(p_project_id);
2735:
2736: /******************************************************************
2737: * Call the Procedure Default_UOM which will
2738: * Update the Unit_of_measure

Line 2742: pa_planning_resource_utils.default_uom;

2738: * Update the Unit_of_measure
2739: * in the temp table pa_res_members_temp with the correct
2740: * values.
2741: *****************************************************************/
2742: pa_planning_resource_utils.default_uom;
2743:
2744: /******************************************************************
2745: * Call the Procedure Default_Currency_Code which will
2746: * Update the Rate_Func_Curr_Code

Line 2750: pa_planning_resource_utils.default_currency_code;

2746: * Update the Rate_Func_Curr_Code
2747: * in the temp table pa_res_members_temp with the correct
2748: * values.
2749: *****************************************************************/
2750: pa_planning_resource_utils.default_currency_code;
2751:
2752: /*****************************************************************
2753: * Fetch the values that are currently there in the pa_res_members_temp
2754: * table into the out var's. Select it from the Temp table

Line 2892: pa_planning_resource_utils.Get_Resource_Name (

2888: l_Resource_Name Varchar2(1000) := Null;
2889:
2890: Begin
2891:
2892: pa_planning_resource_utils.Get_Resource_Name (
2893: P_Res_Type_Code => P_Res_Type_Code,
2894: P_Person_Id => P_Person_Id,
2895: P_Bom_Resource_Id => P_Bom_Resource_Id,
2896: P_Job_Id => P_Job_Id,

Line 3326: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',

3322: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
3323: --x_msg_count := x_msg_count + 1;
3324: x_msg_data := Null;
3325: Fnd_Msg_Pub.Add_Exc_Msg(
3326: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',
3327: P_Procedure_Name => 'Get_Resource_Name');
3328:
3329: Return;
3330: /* When NULL_PER_IN_RES_LIST_MEM Then

Line 3531: Pa_Planning_Resource_Utils.Get_Fin_Category_Name (

3527: l_Fin_Cat_Displayed Varchar2(80) := Null;
3528:
3529: Begin
3530:
3531: Pa_Planning_Resource_Utils.Get_Fin_Category_Name (
3532: P_FC_Res_Type_Code => P_FC_Res_Type_Code,
3533: P_Expenditure_Type => P_Expenditure_Type,
3534: P_Expenditure_Category => P_Expenditure_Category,
3535: P_Event_Type => P_Event_Type,

Line 3716: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',

3712: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
3713: --x_msg_count := x_msg_count + 1;
3714: x_msg_data := Null;
3715: Fnd_Msg_Pub.Add_Exc_Msg(
3716: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',
3717: P_Procedure_Name => 'Get_Fin_Category_Name');
3718: Return;
3719: /*When NULL_FC_RES_TYPE_IN_LIST_MEM Then
3720:

Line 3834: pa_planning_resource_utils.Get_Organization_Name (

3830: l_Organization_Name Varchar2(240) := Null;
3831:
3832: Begin
3833:
3834: pa_planning_resource_utils.Get_Organization_Name (
3835: P_Organization_Id => P_Organization_Id,
3836: P_Proc_Func_Flag => 'F',
3837: X_Org_Displayed => l_Organization_Name,
3838: X_Return_Status => l_Return_Status,

Line 3899: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',

3895: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
3896: --x_msg_count := x_msg_count + 1;
3897: x_msg_data := Null;
3898: Fnd_Msg_Pub.Add_Exc_Msg(
3899: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',
3900: P_Procedure_Name => 'Get_Organization_Name');
3901: Return;
3902: /*When NULL_ORG_ID_IN_LIST_MEM Then
3903:

Line 3954: Pa_Planning_Resource_Utils.Get_Supplier_Name(

3950: l_Supplier_Name Varchar2(240) := Null;
3951:
3952: Begin
3953:
3954: Pa_Planning_Resource_Utils.Get_Supplier_Name(
3955: P_Supplier_Id => P_Supplier_Id,
3956: P_Proc_Func_Flag => 'F',
3957: X_Supplier_Displayed => l_Supplier_Name,
3958: X_Return_Status => l_Return_Status,

Line 4029: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',

4025: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
4026: --x_msg_count := x_msg_count + 1;
4027: x_msg_data := Null;
4028: Fnd_Msg_Pub.Add_Exc_Msg(
4029: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',
4030: P_Procedure_Name => 'Get_Supplier_Name');
4031: Return;
4032: /*When NULL_VEND_IN_LIST_MEM Then
4033:

Line 4083: Pa_Planning_Resource_Utils.Get_Role_Name(

4079: l_Role_Name Varchar2(80) := Null;
4080:
4081: Begin
4082:
4083: Pa_Planning_Resource_Utils.Get_Role_Name(
4084: P_Role_Id => P_Role_Id,
4085: P_Proc_Func_Flag => 'F',
4086: X_Role_Displayed => l_Role_Name,
4087: X_Return_Status => l_Return_Status,

Line 4160: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',

4156: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
4157: --x_msg_count := x_msg_count + 1;
4158: x_msg_data := Null;
4159: Fnd_Msg_Pub.Add_Exc_Msg(
4160: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',
4161: P_Procedure_Name => 'Get_Role_Name');
4162: Return;
4163: /*When NULL_ROLE_IN_LIST_MEM Then
4164:

Line 4218: Pa_Planning_Resource_Utils.Get_Incur_By_Res_Name(

4214: l_Inc_By_Name Varchar2(1000) := Null;
4215:
4216: Begin
4217:
4218: Pa_Planning_Resource_Utils.Get_Incur_By_Res_Name(
4219: P_Person_Id => P_Person_Id,
4220: P_Job_Id => P_Job_Id,
4221: P_Incur_By_Role_Id => P_Incur_By_Role_Id,
4222: P_Person_Type_Code => P_Person_Type_Code,

Line 4455: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',

4451: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
4452: --x_msg_count := x_msg_count + 1;
4453: x_msg_data := Null;
4454: Fnd_Msg_Pub.Add_Exc_Msg(
4455: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',
4456: P_Procedure_Name => 'Get_Incur_By_Res_Name');
4457: Return;
4458: /*When BAD_PER_IN_RES_LIST_MEM Then
4459:

Line 4706: Pa_Planning_Resource_Utils.Get_Resource_Name (

4702:
4703: -- Check res_type_enabled_flag = 'Y'
4704: If Res_Format_Rec.Res_Type_Enabled_Flag = 'Y' Then
4705:
4706: Pa_Planning_Resource_Utils.Get_Resource_Name (
4707: P_Res_Type_Code => Res_Format_Rec.Res_Type_Code,
4708: P_Person_Id => Res_List_Member_Rec.Person_Id,
4709: P_Bom_Resource_Id => Res_List_Member_Rec.BOM_Resource_Id,
4710: P_Job_Id => Res_List_Member_Rec.Job_Id,

Line 4756: Pa_Planning_Resource_Utils.Get_Fin_Category_Name (

4752:
4753: -- Check fin_cat_enabled_flag = 'Y'
4754: If Res_Format_Rec.Fin_Cat_Enabled_Flag = 'Y' Then
4755:
4756: Pa_Planning_Resource_Utils.Get_Fin_Category_Name (
4757: P_FC_Res_Type_Code => Res_List_Member_Rec.Fc_Res_Type_Code,
4758: P_Expenditure_Type => Res_List_Member_Rec.Expenditure_Type,
4759: P_Expenditure_Category => Res_List_Member_Rec.Expenditure_Category,
4760: P_Event_Type => Res_List_Member_Rec.Event_Type,

Line 4792: Pa_Planning_Resource_Utils.Get_Organization_Name (

4788:
4789: -- Check orgn_enabled_flag = 'Y'
4790: If Res_Format_Rec.Orgn_Enabled_Flag = 'Y' Then
4791:
4792: Pa_Planning_Resource_Utils.Get_Organization_Name (
4793: P_Organization_Id => Res_List_Member_Rec.Organization_Id,
4794: P_Proc_Func_Flag => 'P',
4795: X_Org_Displayed => l_Orgn_Displayed,
4796: X_Return_Status => X_Return_Status,

Line 4823: Pa_Planning_Resource_Utils.Get_Supplier_Name (

4819:
4820: -- Check supplier_enabled_flag = 'Y'
4821: If Res_Format_Rec.Supplier_Enabled_Flag = 'Y' Then
4822:
4823: Pa_Planning_Resource_Utils.Get_Supplier_Name (
4824: P_Supplier_Id => Res_List_Member_Rec.Vendor_Id,
4825: P_Proc_Func_Flag => 'P',
4826: X_Supplier_Displayed => l_Supplier_Displayed,
4827: X_Return_Status => X_Return_Status,

Line 4854: /*Pa_Planning_Resource_Utils.Get_Role_Name (

4850:
4851: -- Check role_enabled_flag = 'Y'
4852: If Res_Format_Rec.Role_Enabled_Flag = 'Y' Then
4853: -- Team Role Changes
4854: /*Pa_Planning_Resource_Utils.Get_Role_Name (
4855: P_Role_Id => Res_List_Member_Rec.Project_Role_Id,
4856: P_Proc_Func_Flag => 'P',
4857: X_Role_Displayed => l_Role_Displayed,
4858: X_Return_Status => X_Return_Status,

Line 4889: Pa_Planning_Resource_Utils.Get_Incur_By_Res_Name (

4885: -- Check incurred_by_enabled_flag = 'Y'
4886: If Res_Format_Rec.Incurred_By_Enabled_Flag = 'Y' and
4887: Res_List_Member_Rec.Incurred_By_Res_Flag = 'Y' Then
4888:
4889: Pa_Planning_Resource_Utils.Get_Incur_By_Res_Name (
4890: P_Person_Id => Res_List_Member_Rec.Person_Id,
4891: P_Job_Id => Res_List_Member_Rec.Job_Id,
4892: P_Incur_By_Role_Id => Res_List_Member_Rec.Incur_By_Role_Id,
4893: P_Person_Type_Code => Res_List_Member_Rec.Person_Type_Code,

Line 4989: Pa_Planning_Resource_Utils.Get_Plan_Res_Combination(

4985: l_Error_Count Number;
4986: l_resource_class_flag PA_RESOURCE_LISTS_ALL_BG.resource_class_flag%TYPE := 'Y';
4987: BEGIN
4988:
4989: Pa_Planning_Resource_Utils.Get_Plan_Res_Combination(
4990: P_Resource_List_Member_Id => P_Resource_List_Member_Id,
4991: X_Resource_Alias => l_Res_List_Member_Alias,
4992: X_Plan_Res_Combination => l_Plan_Res_Combination,
4993: X_Return_Status => l_Return_Status,

Line 5231: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',

5227: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
5228: --x_msg_count := x_msg_count + 1;
5229: x_error_message_code := Null;
5230: Fnd_Msg_Pub.Add_Exc_Msg(
5231: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',
5232: P_Procedure_Name => 'Validate_Fin_Category');
5233: When INVALID_FIN_CAT_CODE Then
5234: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
5235: X_Error_Message_Code := 'PA_VFC_INVALID_FIN_CAT_CODE';

Line 5590: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',

5586: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
5587: --x_msg_count := x_msg_count + 1;
5588: x_error_message_code := Null;
5589: Fnd_Msg_Pub.Add_Exc_Msg(
5590: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',
5591: P_Procedure_Name => 'Validate_Incur_by_Resource');
5592:
5593: When MAN_PARAMS_NULL Then
5594: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

Line 5949: -- hr_utility.trace('Before Pa_Planning_Resource_Utils.Validate_Resource');

5945:
5946: End If;
5947:
5948: -- hr_utility.trace('g_job_group_id IS : ' || g_job_group_id);
5949: -- hr_utility.trace('Before Pa_Planning_Resource_Utils.Validate_Resource');
5950: IF P_PA_DEBUG_MODE = 'Y' THEN
5951: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_code '|| p_resource_code ,1);
5952: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_name '|| p_resource_name ,1);
5953: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_class_code '|| p_resource_class_code ,1);

Line 5951: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_code '|| p_resource_code ,1);

5947:
5948: -- hr_utility.trace('g_job_group_id IS : ' || g_job_group_id);
5949: -- hr_utility.trace('Before Pa_Planning_Resource_Utils.Validate_Resource');
5950: IF P_PA_DEBUG_MODE = 'Y' THEN
5951: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_code '|| p_resource_code ,1);
5952: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_name '|| p_resource_name ,1);
5953: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_class_code '|| p_resource_class_code ,1);
5954: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_res_type_code '|| p_res_type_code ,1);
5955: END IF;

Line 5952: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_name '|| p_resource_name ,1);

5948: -- hr_utility.trace('g_job_group_id IS : ' || g_job_group_id);
5949: -- hr_utility.trace('Before Pa_Planning_Resource_Utils.Validate_Resource');
5950: IF P_PA_DEBUG_MODE = 'Y' THEN
5951: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_code '|| p_resource_code ,1);
5952: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_name '|| p_resource_name ,1);
5953: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_class_code '|| p_resource_class_code ,1);
5954: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_res_type_code '|| p_res_type_code ,1);
5955: END IF;
5956: Pa_Planning_Resource_Utils.Validate_Resource(

Line 5953: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_class_code '|| p_resource_class_code ,1);

5949: -- hr_utility.trace('Before Pa_Planning_Resource_Utils.Validate_Resource');
5950: IF P_PA_DEBUG_MODE = 'Y' THEN
5951: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_code '|| p_resource_code ,1);
5952: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_name '|| p_resource_name ,1);
5953: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_class_code '|| p_resource_class_code ,1);
5954: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_res_type_code '|| p_res_type_code ,1);
5955: END IF;
5956: Pa_Planning_Resource_Utils.Validate_Resource(
5957: P_resource_Code => P_Resource_Code,

Line 5954: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_res_type_code '|| p_res_type_code ,1);

5950: IF P_PA_DEBUG_MODE = 'Y' THEN
5951: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_code '|| p_resource_code ,1);
5952: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_name '|| p_resource_name ,1);
5953: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_class_code '|| p_resource_class_code ,1);
5954: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_res_type_code '|| p_res_type_code ,1);
5955: END IF;
5956: Pa_Planning_Resource_Utils.Validate_Resource(
5957: P_resource_Code => P_Resource_Code,
5958: P_Resource_Name => P_Resource_Name,

Line 5956: Pa_Planning_Resource_Utils.Validate_Resource(

5952: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_name '|| p_resource_name ,1);
5953: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_resource_class_code '|| p_resource_class_code ,1);
5954: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_res_type_code '|| p_res_type_code ,1);
5955: END IF;
5956: Pa_Planning_Resource_Utils.Validate_Resource(
5957: P_resource_Code => P_Resource_Code,
5958: P_Resource_Name => P_Resource_Name,
5959: P_Resource_Class_Code => P_Resource_Class_Code,
5960: P_Res_Type_Code => P_Res_Type_Code,

Line 5973: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Person_Id '|| X_Person_Id ,1);

5969: X_Resource_Class_Flag => X_resource_class_flag,
5970: X_Return_Status => X_Return_Status,
5971: X_Error_Msg_Code => X_Msg_Data);
5972: IF P_PA_DEBUG_MODE = 'Y' THEN
5973: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Person_Id '|| X_Person_Id ,1);
5974: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Bom_Resource_Id '|| X_Bom_Resource_Id ,1);
5975: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Job_Id '|| X_Job_Id ,1);
5976: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Person_Type_Code '|| X_Person_Type_Code ,1);
5977: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Non_Labor_Resource '|| X_Non_Labor_Resource ,1);

Line 5974: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Bom_Resource_Id '|| X_Bom_Resource_Id ,1);

5970: X_Return_Status => X_Return_Status,
5971: X_Error_Msg_Code => X_Msg_Data);
5972: IF P_PA_DEBUG_MODE = 'Y' THEN
5973: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Person_Id '|| X_Person_Id ,1);
5974: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Bom_Resource_Id '|| X_Bom_Resource_Id ,1);
5975: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Job_Id '|| X_Job_Id ,1);
5976: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Person_Type_Code '|| X_Person_Type_Code ,1);
5977: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Non_Labor_Resource '|| X_Non_Labor_Resource ,1);
5978: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Inventory_Item_Id '|| X_Inventory_Item_Id ,1);

Line 5975: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Job_Id '|| X_Job_Id ,1);

5971: X_Error_Msg_Code => X_Msg_Data);
5972: IF P_PA_DEBUG_MODE = 'Y' THEN
5973: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Person_Id '|| X_Person_Id ,1);
5974: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Bom_Resource_Id '|| X_Bom_Resource_Id ,1);
5975: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Job_Id '|| X_Job_Id ,1);
5976: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Person_Type_Code '|| X_Person_Type_Code ,1);
5977: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Non_Labor_Resource '|| X_Non_Labor_Resource ,1);
5978: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Inventory_Item_Id '|| X_Inventory_Item_Id ,1);
5979: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Item_Category_Id '|| X_Item_Category_Id ,1);

Line 5976: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Person_Type_Code '|| X_Person_Type_Code ,1);

5972: IF P_PA_DEBUG_MODE = 'Y' THEN
5973: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Person_Id '|| X_Person_Id ,1);
5974: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Bom_Resource_Id '|| X_Bom_Resource_Id ,1);
5975: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Job_Id '|| X_Job_Id ,1);
5976: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Person_Type_Code '|| X_Person_Type_Code ,1);
5977: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Non_Labor_Resource '|| X_Non_Labor_Resource ,1);
5978: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Inventory_Item_Id '|| X_Inventory_Item_Id ,1);
5979: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Item_Category_Id '|| X_Item_Category_Id ,1);
5980: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'l_Dummy_Res_Class_Code '|| l_Dummy_Res_Class_Code ,1);

Line 5977: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Non_Labor_Resource '|| X_Non_Labor_Resource ,1);

5973: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Person_Id '|| X_Person_Id ,1);
5974: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Bom_Resource_Id '|| X_Bom_Resource_Id ,1);
5975: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Job_Id '|| X_Job_Id ,1);
5976: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Person_Type_Code '|| X_Person_Type_Code ,1);
5977: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Non_Labor_Resource '|| X_Non_Labor_Resource ,1);
5978: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Inventory_Item_Id '|| X_Inventory_Item_Id ,1);
5979: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Item_Category_Id '|| X_Item_Category_Id ,1);
5980: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'l_Dummy_Res_Class_Code '|| l_Dummy_Res_Class_Code ,1);
5981: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_resource_class_flag '|| X_resource_class_flag ,1);

Line 5978: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Inventory_Item_Id '|| X_Inventory_Item_Id ,1);

5974: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Bom_Resource_Id '|| X_Bom_Resource_Id ,1);
5975: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Job_Id '|| X_Job_Id ,1);
5976: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Person_Type_Code '|| X_Person_Type_Code ,1);
5977: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Non_Labor_Resource '|| X_Non_Labor_Resource ,1);
5978: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Inventory_Item_Id '|| X_Inventory_Item_Id ,1);
5979: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Item_Category_Id '|| X_Item_Category_Id ,1);
5980: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'l_Dummy_Res_Class_Code '|| l_Dummy_Res_Class_Code ,1);
5981: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_resource_class_flag '|| X_resource_class_flag ,1);
5982: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Return_Status '|| X_Return_Status ,1);

Line 5979: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Item_Category_Id '|| X_Item_Category_Id ,1);

5975: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Job_Id '|| X_Job_Id ,1);
5976: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Person_Type_Code '|| X_Person_Type_Code ,1);
5977: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Non_Labor_Resource '|| X_Non_Labor_Resource ,1);
5978: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Inventory_Item_Id '|| X_Inventory_Item_Id ,1);
5979: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Item_Category_Id '|| X_Item_Category_Id ,1);
5980: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'l_Dummy_Res_Class_Code '|| l_Dummy_Res_Class_Code ,1);
5981: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_resource_class_flag '|| X_resource_class_flag ,1);
5982: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Return_Status '|| X_Return_Status ,1);
5983: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Msg_Data '|| X_Msg_Data ,1);

Line 5980: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'l_Dummy_Res_Class_Code '|| l_Dummy_Res_Class_Code ,1);

5976: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Person_Type_Code '|| X_Person_Type_Code ,1);
5977: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Non_Labor_Resource '|| X_Non_Labor_Resource ,1);
5978: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Inventory_Item_Id '|| X_Inventory_Item_Id ,1);
5979: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Item_Category_Id '|| X_Item_Category_Id ,1);
5980: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'l_Dummy_Res_Class_Code '|| l_Dummy_Res_Class_Code ,1);
5981: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_resource_class_flag '|| X_resource_class_flag ,1);
5982: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Return_Status '|| X_Return_Status ,1);
5983: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Msg_Data '|| X_Msg_Data ,1);
5984: END IF;

Line 5981: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_resource_class_flag '|| X_resource_class_flag ,1);

5977: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Non_Labor_Resource '|| X_Non_Labor_Resource ,1);
5978: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Inventory_Item_Id '|| X_Inventory_Item_Id ,1);
5979: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Item_Category_Id '|| X_Item_Category_Id ,1);
5980: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'l_Dummy_Res_Class_Code '|| l_Dummy_Res_Class_Code ,1);
5981: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_resource_class_flag '|| X_resource_class_flag ,1);
5982: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Return_Status '|| X_Return_Status ,1);
5983: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Msg_Data '|| X_Msg_Data ,1);
5984: END IF;
5985:

Line 5982: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Return_Status '|| X_Return_Status ,1);

5978: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Inventory_Item_Id '|| X_Inventory_Item_Id ,1);
5979: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Item_Category_Id '|| X_Item_Category_Id ,1);
5980: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'l_Dummy_Res_Class_Code '|| l_Dummy_Res_Class_Code ,1);
5981: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_resource_class_flag '|| X_resource_class_flag ,1);
5982: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Return_Status '|| X_Return_Status ,1);
5983: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Msg_Data '|| X_Msg_Data ,1);
5984: END IF;
5985:
5986: -- hr_utility.trace('After Pa_Planning_Resource_Utils.Validate_Resource');

Line 5983: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Msg_Data '|| X_Msg_Data ,1);

5979: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Item_Category_Id '|| X_Item_Category_Id ,1);
5980: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'l_Dummy_Res_Class_Code '|| l_Dummy_Res_Class_Code ,1);
5981: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_resource_class_flag '|| X_resource_class_flag ,1);
5982: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Return_Status '|| X_Return_Status ,1);
5983: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Msg_Data '|| X_Msg_Data ,1);
5984: END IF;
5985:
5986: -- hr_utility.trace('After Pa_Planning_Resource_Utils.Validate_Resource');
5987: -- hr_utility.trace('X_Return_Status IS : ' || X_Return_Status);

Line 5986: -- hr_utility.trace('After Pa_Planning_Resource_Utils.Validate_Resource');

5982: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Return_Status '|| X_Return_Status ,1);
5983: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'X_Msg_Data '|| X_Msg_Data ,1);
5984: END IF;
5985:
5986: -- hr_utility.trace('After Pa_Planning_Resource_Utils.Validate_Resource');
5987: -- hr_utility.trace('X_Return_Status IS : ' || X_Return_Status);
5988: -- hr_utility.trace('X_Msg_Data IS : ' || X_Msg_Data);
5989: If X_Return_Status = Fnd_Api.G_Ret_Sts_Error Then
5990:

Line 6005: Pa_Planning_Resource_Utils.Validate_Organization(

6001: Raise MISSING_ORG_VALUES;
6002:
6003: ElsIf P_Organization_Id is Not Null or
6004: P_Organization_Name is Not Null Then
6005: Pa_Planning_Resource_Utils.Validate_Organization(
6006: P_Organization_Name => P_Organization_Name,
6007: P_Organization_Id => P_Organization_Id,
6008: X_Organization_Id => X_Organization_Id,
6009: X_Return_Status => X_Return_Status,

Line 6065: pa_debug.write(' Before Calling Pa_Planning_Resource_Utils.Validate_Fin_Category resource_class_flag :'||l_resource_class_flag ,1);

6061:
6062: End If;
6063: /* End Bug13625913 */
6064: IF P_PA_DEBUG_MODE = 'Y' THEN
6065: pa_debug.write(' Before Calling Pa_Planning_Resource_Utils.Validate_Fin_Category resource_class_flag :'||l_resource_class_flag ,1);
6066: END IF;
6067:
6068: Pa_Planning_Resource_Utils.Validate_Fin_Category(
6069: P_FC_Res_Type_Code => P_FC_Res_Type_Code,

Line 6068: Pa_Planning_Resource_Utils.Validate_Fin_Category(

6064: IF P_PA_DEBUG_MODE = 'Y' THEN
6065: pa_debug.write(' Before Calling Pa_Planning_Resource_Utils.Validate_Fin_Category resource_class_flag :'||l_resource_class_flag ,1);
6066: END IF;
6067:
6068: Pa_Planning_Resource_Utils.Validate_Fin_Category(
6069: P_FC_Res_Type_Code => P_FC_Res_Type_Code,
6070: P_Resource_Class_Code => P_Resource_Class_Code,
6071: P_Fin_Category_Name => P_Fin_Category_Name,
6072: P_migration_code => l_migration_code,

Line 6100: Pa_Planning_Resource_Utils.Validate_Incur_by_Resource(

6096: P_Incur_By_Resource_Type is Not Null Then
6097:
6098: If P_Resource_Class_Code = 'FINANCIAL_ELEMENTS' Then
6099:
6100: Pa_Planning_Resource_Utils.Validate_Incur_by_Resource(
6101: P_Resource_Class_Code => P_Resource_Class_Code,
6102: P_Res_Type_Code => P_Incur_By_Resource_Type,
6103: P_Incur_By_Res_Code => P_Incur_By_Resource_Code,
6104: X_Person_Id => l_Person_Id,

Line 6155: Pa_Planning_Resource_Utils.Validate_Supplier(

6151:
6152: ElsIf P_Supplier_Id is Not Null or
6153: P_Supplier_Name is Not Null Then
6154:
6155: Pa_Planning_Resource_Utils.Validate_Supplier(
6156: P_Resource_Class_Code => P_Resource_Class_Code,
6157: P_Person_Id => x_person_id,
6158: P_Supplier_Id => P_Supplier_Id,
6159: P_Supplier_Name => P_Supplier_Name,

Line 6193: l_team_role := Pa_Planning_Resource_Utils.Ret_Role_Name

6189: IF P_Project_Role_Name IS NOT NULL THEN
6190: l_team_role := P_Project_Role_Name;
6191: ELSE
6192: IF p_project_role_id IS NOT NULL THEN
6193: l_team_role := Pa_Planning_Resource_Utils.Ret_Role_Name
6194: (P_Role_Id => p_project_role_id );
6195: END IF;
6196: END IF;
6197: ELSE

Line 6278: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'Validate_Planning_Resource ',1);

6274:
6275: END IF;
6276:
6277: IF P_PA_DEBUG_MODE = 'Y' THEN
6278: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'Validate_Planning_Resource ',1);
6279: END IF;
6280: Exception
6281: When UNEXPEC_ERROR THEN
6282: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;

Line 6286: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',

6282: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
6283: --x_msg_count := x_msg_count + 1;
6284: x_msg_data := Null;
6285: Fnd_Msg_Pub.Add_Exc_Msg(
6286: P_Pkg_Name => 'PA_PLANNING_RESOURCE_UTILS',
6287: P_Procedure_Name => 'Validate_Planning_Resource');
6288:
6289: /*When PARAMS_ALL_NULL Then
6290: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

Line 7408: 'Pa_Planning_Resource_Utils.Delete_proj_specific_resource'

7404:
7405: EXCEPTION
7406: WHEN OTHERS THEN
7407: FND_MSG_PUB.add_exc_msg( p_pkg_name =>
7408: 'Pa_Planning_Resource_Utils.Delete_proj_specific_resource'
7409: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
7410: x_msg_count := x_msg_count+1;
7411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7412: END Delete_Proj_Specific_Resource;

Line 7768: pa_planning_resource_utils.Check_PersonName_or_ID(

7764: (l_fmt_details.Res_Type_Code = 'NAMED_PERSON' AND
7765: (P_person_id is not NULL OR P_person_name is NOT NULL)) THEN
7766: IF l_fmt_details.Orgn_Enabled_Flag = 'Y' THEN
7767: -- Do name to ID conversion on person
7768: pa_planning_resource_utils.Check_PersonName_or_ID(
7769: p_person_id => P_person_id,
7770: p_person_name => P_person_name,
7771: p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,
7772: x_person_id => l_person_id,

Line 7809: pa_planning_resource_utils.Check_BOM_EqLabor_or_ID(

7805: (p_bom_resource_id is not NULL OR p_bom_resource_name is NOT NULL)) THEN
7806:
7807: -- Do name to ID conversion on bom resource
7808: IF l_fmt_details.Res_Type_Code = 'BOM_LABOR' THEN
7809: pa_planning_resource_utils.Check_BOM_EqLabor_or_ID(
7810: p_bom_eqlabor_id => p_bom_resource_id,
7811: p_bom_eqlabor_name => p_bom_resource_name,
7812: p_res_type_code => 2,
7813: p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,

Line 7824: pa_planning_resource_utils.Check_BOM_EqLabor_or_ID(

7820: Pa_Planning_Resource_Pvt.g_token);
7821: Return;
7822: END IF;
7823: ELSIF l_fmt_details.Res_Type_Code = 'BOM_EQUIPMENT' THEN
7824: pa_planning_resource_utils.Check_BOM_EqLabor_or_ID(
7825: p_bom_eqlabor_id => p_bom_resource_id,
7826: p_bom_eqlabor_name => p_bom_resource_name,
7827: p_res_type_code => 1,
7828: p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,

Line 7870: END PA_PLANNING_RESOURCE_UTILS;

7866: END IF;
7867:
7868: END default_other_elements;
7869:
7870: END PA_PLANNING_RESOURCE_UTILS;
7871: /******************************************************************/