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_DEBUG

Line 4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

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

Line 1532: IF P_PA_DEBUG_MODE = 'Y' THEN

1528: -- hr_utility.trace('Start Validate_Resource');
1529: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1530: x_resource_class_flag := 'N';
1531: /* Call to the Function check_null_flag to check for the null conditions*/
1532: IF P_PA_DEBUG_MODE = 'Y' THEN
1533: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_code '|| p_resource_code ,1);
1534: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_name '|| p_resource_name ,1);
1535: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_class_code '|| p_resource_class_code ,1);
1536: pa_debug.write('Validate_Resource: ' || g_module_name,'p_res_type_code '|| p_res_type_code ,1);

Line 1533: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_code '|| p_resource_code ,1);

1529: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1530: x_resource_class_flag := 'N';
1531: /* Call to the Function check_null_flag to check for the null conditions*/
1532: IF P_PA_DEBUG_MODE = 'Y' THEN
1533: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_code '|| p_resource_code ,1);
1534: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_name '|| p_resource_name ,1);
1535: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_class_code '|| p_resource_class_code ,1);
1536: pa_debug.write('Validate_Resource: ' || g_module_name,'p_res_type_code '|| p_res_type_code ,1);
1537: END IF;

Line 1534: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_name '|| p_resource_name ,1);

1530: x_resource_class_flag := 'N';
1531: /* Call to the Function check_null_flag to check for the null conditions*/
1532: IF P_PA_DEBUG_MODE = 'Y' THEN
1533: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_code '|| p_resource_code ,1);
1534: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_name '|| p_resource_name ,1);
1535: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_class_code '|| p_resource_class_code ,1);
1536: pa_debug.write('Validate_Resource: ' || g_module_name,'p_res_type_code '|| p_res_type_code ,1);
1537: END IF;
1538:

Line 1535: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_class_code '|| p_resource_class_code ,1);

1531: /* Call to the Function check_null_flag to check for the null conditions*/
1532: IF P_PA_DEBUG_MODE = 'Y' THEN
1533: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_code '|| p_resource_code ,1);
1534: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_name '|| p_resource_name ,1);
1535: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_class_code '|| p_resource_class_code ,1);
1536: pa_debug.write('Validate_Resource: ' || g_module_name,'p_res_type_code '|| p_res_type_code ,1);
1537: END IF;
1538:
1539: IF Check_Res_Null(p_resource_code,p_resource_name,

Line 1536: pa_debug.write('Validate_Resource: ' || g_module_name,'p_res_type_code '|| p_res_type_code ,1);

1532: IF P_PA_DEBUG_MODE = 'Y' THEN
1533: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_code '|| p_resource_code ,1);
1534: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_name '|| p_resource_name ,1);
1535: pa_debug.write('Validate_Resource: ' || g_module_name,'p_resource_class_code '|| p_resource_class_code ,1);
1536: pa_debug.write('Validate_Resource: ' || g_module_name,'p_res_type_code '|| p_res_type_code ,1);
1537: END IF;
1538:
1539: IF Check_Res_Null(p_resource_code,p_resource_name,
1540: p_resource_class_code,p_res_type_code) = 'Y'

Line 1560: IF P_PA_DEBUG_MODE = 'Y' THEN

1556: IF p_resource_code = p_resource_class_code THEN
1557: x_resource_class_code := p_resource_class_code;
1558: x_resource_class_flag := 'Y';
1559: ELSE
1560: IF P_PA_DEBUG_MODE = 'Y' THEN
1561: pa_debug.write('Validate_Resource: ' || g_module_name,'RESOURCE_CLASS error' ,1);
1562: END IF;
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: Return;

Line 1561: pa_debug.write('Validate_Resource: ' || g_module_name,'RESOURCE_CLASS error' ,1);

1557: x_resource_class_code := p_resource_class_code;
1558: x_resource_class_flag := 'Y';
1559: ELSE
1560: IF P_PA_DEBUG_MODE = 'Y' THEN
1561: pa_debug.write('Validate_Resource: ' || g_module_name,'RESOURCE_CLASS error' ,1);
1562: END IF;
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: Return;
1565: END IF;

Line 1785: IF P_PA_DEBUG_MODE = 'Y' THEN

1781: /*************/
1782: END IF;
1783: END IF;
1784:
1785: IF P_PA_DEBUG_MODE = 'Y' THEN
1786: pa_debug.write('Validate_Resource: ' || g_module_name,'End Validate_Resource' ,1);
1787: END IF;
1788: END Validate_Resource;
1789: /***************************************************/

Line 1786: pa_debug.write('Validate_Resource: ' || g_module_name,'End Validate_Resource' ,1);

1782: END IF;
1783: END IF;
1784:
1785: IF P_PA_DEBUG_MODE = 'Y' THEN
1786: pa_debug.write('Validate_Resource: ' || g_module_name,'End Validate_Resource' ,1);
1787: END IF;
1788: END Validate_Resource;
1789: /***************************************************/
1790:

Line 5950: IF P_PA_DEBUG_MODE = 'Y' THEN

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);
5954: pa_debug.write('PA_PLANNING_RESOURCE_UTILS: ' || g_module_name,'p_res_type_code '|| p_res_type_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 5972: IF P_PA_DEBUG_MODE = 'Y' THEN

5968: X_Resource_Class_Code => l_Dummy_Res_Class_Code,
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);

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 6029: IF P_PA_DEBUG_MODE = 'Y' THEN

6025: ElsIf P_FC_Res_Type_Code is Not Null or
6026: P_Fin_Category_Name is Not Null Then
6027: --Added for CBS::13535688
6028: --l_resource_class_flag:='Y';
6029: IF P_PA_DEBUG_MODE = 'Y' THEN
6030: pa_debug.write(' Before Executing Cursor resource_class_flag :'||l_resource_class_flag ,1);
6031: END IF;
6032: if P_resource_list_id is Not null then
6033:

Line 6030: pa_debug.write(' Before Executing Cursor resource_class_flag :'||l_resource_class_flag ,1);

6026: P_Fin_Category_Name is Not Null Then
6027: --Added for CBS::13535688
6028: --l_resource_class_flag:='Y';
6029: IF P_PA_DEBUG_MODE = 'Y' THEN
6030: pa_debug.write(' Before Executing Cursor resource_class_flag :'||l_resource_class_flag ,1);
6031: END IF;
6032: if P_resource_list_id is Not null then
6033:
6034: open get_resource_class_flag(P_resource_list_id);

Line 6038: IF P_PA_DEBUG_MODE = 'Y' THEN

6034: open get_resource_class_flag(P_resource_list_id);
6035: FETCH get_resource_class_flag INTO l_resource_class_flag;
6036: close get_resource_class_flag;
6037:
6038: IF P_PA_DEBUG_MODE = 'Y' THEN
6039: pa_debug.write(' After Executing Cursor resource_class_flag :'||l_resource_class_flag ,1);
6040: END IF;
6041:
6042: END If;

Line 6039: pa_debug.write(' After Executing Cursor resource_class_flag :'||l_resource_class_flag ,1);

6035: FETCH get_resource_class_flag INTO l_resource_class_flag;
6036: close get_resource_class_flag;
6037:
6038: IF P_PA_DEBUG_MODE = 'Y' THEN
6039: pa_debug.write(' After Executing Cursor resource_class_flag :'||l_resource_class_flag ,1);
6040: END IF;
6041:
6042: END If;
6043:

Line 6051: IF P_PA_DEBUG_MODE = 'Y' THEN

6047: fetch get_res_list_id into l_resource_list_id;
6048: close get_res_list_id;
6049:
6050: IF l_resource_list_id is not null then
6051: IF P_PA_DEBUG_MODE = 'Y' THEN
6052: pa_debug.write(' Before Executing Cursor2 resource_class_flag :'||l_resource_class_flag ,1);
6053: END IF;
6054: open get_resource_class_flag(l_resource_list_id);
6055: FETCH get_resource_class_flag INTO l_resource_class_flag;

Line 6052: pa_debug.write(' Before Executing Cursor2 resource_class_flag :'||l_resource_class_flag ,1);

6048: close get_res_list_id;
6049:
6050: IF l_resource_list_id is not null then
6051: IF P_PA_DEBUG_MODE = 'Y' THEN
6052: pa_debug.write(' Before Executing Cursor2 resource_class_flag :'||l_resource_class_flag ,1);
6053: END IF;
6054: open get_resource_class_flag(l_resource_list_id);
6055: FETCH get_resource_class_flag INTO l_resource_class_flag;
6056: close get_resource_class_flag;

Line 6057: IF P_PA_DEBUG_MODE = 'Y' THEN

6053: END IF;
6054: open get_resource_class_flag(l_resource_list_id);
6055: FETCH get_resource_class_flag INTO l_resource_class_flag;
6056: close get_resource_class_flag;
6057: IF P_PA_DEBUG_MODE = 'Y' THEN
6058: pa_debug.write(' After Executing Cursor2 resource_class_flag :'||l_resource_class_flag ,1);
6059: END IF;
6060: END IF;
6061:

Line 6058: pa_debug.write(' After Executing Cursor2 resource_class_flag :'||l_resource_class_flag ,1);

6054: open get_resource_class_flag(l_resource_list_id);
6055: FETCH get_resource_class_flag INTO l_resource_class_flag;
6056: close get_resource_class_flag;
6057: IF P_PA_DEBUG_MODE = 'Y' THEN
6058: pa_debug.write(' After Executing Cursor2 resource_class_flag :'||l_resource_class_flag ,1);
6059: END IF;
6060: END IF;
6061:
6062: End If;

Line 6064: IF P_PA_DEBUG_MODE = 'Y' THEN

6060: END IF;
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(

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 6277: IF P_PA_DEBUG_MODE = 'Y' THEN

6273: END;
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

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 7409: ,p_procedure_name => PA_DEBUG.G_Err_Stack);

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;
7413: