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_RESOURCE_UTILS dependencies on PA_RESOURCE_UTILS

Line 1: PACKAGE BODY pa_resource_utils AS

1: PACKAGE BODY pa_resource_utils AS
2: -- $Header: PARSUTLB.pls 120.54.12020000.2 2012/10/31 07:19:49 svmohamm ship $
3: --
4: -- PROCEDURE
5: -- check_internal_or_external

Line 133: SELECT pa_resource_utils.get_resource_id(p_resource_id)

129:
130: END IF;
131:
132: /* Start of Changes for Bug 6056112 */
133: SELECT pa_resource_utils.get_resource_id(p_resource_id)
134: INTO l_pa_resource_id
135: FROM dual;
136:
137: IF (l_pa_resource_id <> -999) THEN

Line 344: -- (`pa_resource_utils.check_resourcename_or_id');

340: x_return_status := FND_API.G_RET_STS_ERROR;
341: x_error_message_code := 'PA_MULTIPLE_RESOURCE';
342: WHEN OTHERS THEN
343: --PA_Error_Utils.Set_Error_Stack
344: -- (`pa_resource_utils.check_resourcename_or_id');
345: -- This sets the current program unit name in the
346: -- error stack. Helpful in Debugging
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
348: x_resource_id := NULL;

Line 411: -- (`pa_resource_utils.check_resourcename_or_id');

407: --x_return_status := FND_API.G_RET_STS_ERROR;
408: --x_error_message_code := 'PA_CRM_RES_NULL';
409: WHEN OTHERS THEN
410: --PA_Error_Utils.Set_Error_Stack
411: -- (`pa_resource_utils.check_resourcename_or_id');
412: -- This sets the current program unit name in the
413: -- error stack. Helpful in Debugging
414:
415: X_JTF_RESOURCE_ID := NULL ; -- 4537865

Line 863: ( p_pkg_name => 'pa_resource_utils'

859: x_frcst_prim_ctct_flag := 'N';
860:
861: -- Populate the Error Message
862: Fnd_Msg_Pub.add_exc_msg
863: ( p_pkg_name => 'pa_resource_utils'
864: , p_procedure_name => 'populate_role_flags'
865: , p_error_text => SUBSTRB(SQLERRM,1,100));
866:
867: -- Raise the Error

Line 1026: ( p_pkg_name => 'pa_resource_utils'

1022: EXCEPTION
1023: WHEN OTHERS THEN
1024: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1025: Fnd_Msg_Pub.add_exc_msg
1026: ( p_pkg_name => 'pa_resource_utils'
1027: , p_procedure_name => 'insert_grant'
1028: , p_error_text => SUBSTRB(SQLERRM,1,100));
1029: RAISE;
1030: END insert_grant;

Line 1139: ( p_pkg_name => 'pa_resource_utils'

1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1138: Fnd_Msg_Pub.add_exc_msg
1139: ( p_pkg_name => 'pa_resource_utils'
1140: , p_procedure_name => 'delete_grant'
1141: , p_error_text => SUBSTRB(SQLERRM,1,100));
1142: RAISE;
1143: END delete_grant;

Line 1550: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_prim_contact_id_name');

1546: BEGIN
1547:
1548:
1549: -- initialize the error stack
1550: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_prim_contact_id_name');
1551: -- initialize the return status to success
1552: x_return_status := FND_API.G_RET_STS_SUCCESS;
1553:
1554:

Line 1616: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_manager_id_name');

1612: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1613: IS
1614: BEGIN
1615: -- initialize the error stack
1616: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_manager_id_name');
1617: -- initialize the return status to success
1618: x_return_status := FND_API.G_RET_STS_SUCCESS;
1619:
1620: --Modified code for future dated person

Line 1725: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_org_id');

1721: IS
1722: BEGIN
1723:
1724: -- initialize the error stack
1725: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_org_id');
1726: -- initialize the return status to success
1727: x_return_status := FND_API.G_RET_STS_SUCCESS;
1728:
1729: -- pick the Organization id for the Current Assignment

Line 1747: -- FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_id'

1743:
1744: EXCEPTION
1745: WHEN OTHERS THEN
1746: -- set the exception message and stack
1747: -- FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_id'
1748: -- ,PA_DEBUG.g_err_stack);
1749: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1750: -- raise;
1751: -- null; 4537865

Line 1774: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_person_id');

1770:
1771: BEGIN
1772:
1773: -- initialize the error stack
1774: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_person_id');
1775: -- initialize the return status to success
1776: x_return_status := FND_API.G_RET_STS_SUCCESS;
1777:
1778: IF P_resourceid is NOT NULL then

Line 1837: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_id'

1833:
1834: WHEN OTHERS THEN
1835: -- set the exception message and stack
1836: x_PersonId := NULL ; -- 4537865
1837: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_id'
1838: ,PA_DEBUG.g_err_stack);
1839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1840: raise;
1841:

Line 1853: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_object_id');

1849: IS
1850: BEGIN
1851:
1852: -- initialize the error stack
1853: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_object_id');
1854: -- initialize the return status to success
1855: x_return_status := FND_API.G_RET_STS_SUCCESS;
1856:
1857:

Line 1917: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_org_primary_contact');

1913: l_start_date DATE;
1914:
1915: BEGIN
1916: -- initialize the error stack
1917: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_org_primary_contact');
1918:
1919: -- initialize the return status to success
1920: x_return_status := FND_API.G_RET_STS_SUCCESS;
1921:

Line 2050: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_primary_contact'

2046: x_ManagerName := NULL ;
2047: x_return_Status := NULL ;
2048:
2049: -- set the exception message and stack
2050: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_primary_contact'
2051: ,PA_DEBUG.g_err_stack);
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2053: -- dbms_output.put_line('missing');
2054: raise;

Line 2410: PA_RESOURCE_UTILS.G_PERIOD_DATE := l_date;

2406: ELSE
2407: l_date := p_end_date - 6;
2408: END IF;
2409:
2410: PA_RESOURCE_UTILS.G_PERIOD_DATE := l_date;
2411: EXCEPTION
2412: WHEN NO_DATA_FOUND THEN
2413: PA_RESOURCE_UTILS.G_PERIOD_DATE := sysdate - 50 * 365;
2414: WHEN OTHERS THEN

Line 2413: PA_RESOURCE_UTILS.G_PERIOD_DATE := sysdate - 50 * 365;

2409:
2410: PA_RESOURCE_UTILS.G_PERIOD_DATE := l_date;
2411: EXCEPTION
2412: WHEN NO_DATA_FOUND THEN
2413: PA_RESOURCE_UTILS.G_PERIOD_DATE := sysdate - 50 * 365;
2414: WHEN OTHERS THEN
2415: PA_RESOURCE_UTILS.G_PERIOD_DATE := sysdate - 50 * 365;
2416: END Set_Period_Date;
2417:

Line 2415: PA_RESOURCE_UTILS.G_PERIOD_DATE := sysdate - 50 * 365;

2411: EXCEPTION
2412: WHEN NO_DATA_FOUND THEN
2413: PA_RESOURCE_UTILS.G_PERIOD_DATE := sysdate - 50 * 365;
2414: WHEN OTHERS THEN
2415: PA_RESOURCE_UTILS.G_PERIOD_DATE := sysdate - 50 * 365;
2416: END Set_Period_Date;
2417:
2418: FUNCTION get_resource_manager_id(p_user_id IN NUMBER) RETURN NUMBER IS
2419: l_root_manager_id NUMBER;

Line 2497: PA_RESOURCE_UTILS.G_CURRENT_PROJECT_ID := NULL;

2493: l_proj_name_number varchar2(65);
2494: l_project_id NUMBER;
2495: BEGIN
2496: -- reset current_project_id before set it up again
2497: PA_RESOURCE_UTILS.G_CURRENT_PROJECT_ID := NULL;
2498:
2499: -- 4778041 : For performance , removed join of pa_resources_denorm
2500: SELECT proj.name || '(' || proj.segment1 || ')',
2501: proj.project_id

Line 2545: return PA_RESOURCE_UTILS.G_CURRENT_PROJECT_ID;

2541: FUNCTION Get_Current_Project_Id(p_resource_id IN NUMBER)
2542: RETURN NUMBER
2543: IS
2544: BEGIN
2545: return PA_RESOURCE_UTILS.G_CURRENT_PROJECT_ID;
2546:
2547: END Get_Current_Project_Id;
2548:
2549: -- PROCEDURE

Line 2565: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_person_name');

2561: IS
2562: BEGIN
2563:
2564: -- initialize the error stack
2565: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_person_name');
2566: -- initialize the return status to success
2567: x_return_status := FND_API.G_RET_STS_SUCCESS;
2568:
2569: IF p_person_id IS NOT NULL then

Line 2602: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_person_name'

2598: -- RESET OUT PARAM 4537865
2599: x_person_name := null;
2600:
2601: -- set the exception message and stack
2602: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_person_name'
2603: ,PA_DEBUG.g_err_stack);
2604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2605: raise;
2606:

Line 2630: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_location_details');

2626: IS
2627: BEGIN
2628:
2629: -- initialize the error stack
2630: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_location_details');
2631: -- initialize the return status to success
2632: x_return_status := FND_API.G_RET_STS_SUCCESS;
2633:
2634: IF p_location_id IS NOT NULL then

Line 2683: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_location_details'

2679: x_postal_code := null;
2680: x_country := null;
2681:
2682: -- set the exception message and stack
2683: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_location_details'
2684: ,PA_DEBUG.g_err_stack);
2685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2686: raise;
2687:

Line 2707: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_org_defaults');

2703: IS
2704: BEGIN
2705:
2706: -- initialize the error stack
2707: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_org_defaults');
2708: -- initialize the return status to success
2709: x_return_status := FND_API.G_RET_STS_SUCCESS;
2710:
2711: IF p_organization_id IS NOT NULL then

Line 2758: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_defaults'

2754: x_default_ou := null;
2755: x_default_cal_id := null;
2756:
2757: -- set the exception message and stack
2758: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_defaults'
2759: ,PA_DEBUG.g_err_stack);
2760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2761: raise;
2762:

Line 2786: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.check_exp_org');

2782: IS
2783: BEGIN
2784:
2785: -- initialize the error stack
2786: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.check_exp_org');
2787: -- initialize the return status to success
2788: x_return_status := FND_API.G_RET_STS_SUCCESS;
2789:
2790: x_valid := 'N';

Line 2831: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.check_exp_org'

2827:
2828: x_valid := 'N';
2829:
2830: -- set the exception message and stack
2831: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.check_exp_org'
2832: ,PA_DEBUG.g_err_stack);
2833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2834: raise;
2835:

Line 2858: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.check_res_exists');

2854: IS
2855: BEGIN
2856:
2857: -- initialize the error stack
2858: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.check_res_exists');
2859: -- initialize the return status to success
2860: x_return_status := FND_API.G_RET_STS_SUCCESS;
2861:
2862: x_valid := 'N';

Line 2894: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.check_res_exists'

2890: --4537865 RESET OUT PARAMS
2891: x_valid := 'N';
2892:
2893: -- set the exception message and stack
2894: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.check_res_exists'
2895: ,PA_DEBUG.g_err_stack);
2896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2897: raise;
2898:

Line 2913: RETURN PA_RESOURCE_UTILS.G_PRIMARY_CONTACT_NAME;

2909: IS
2910:
2911: BEGIN
2912:
2913: RETURN PA_RESOURCE_UTILS.G_PRIMARY_CONTACT_NAME;
2914:
2915: END get_org_prim_contact_name;
2916:
2917:

Line 2934: PA_RESOURCE_UTILS.G_PRIMARY_CONTACT_NAME:= NULL;

2930: l_primary_contact_id NUMBER;
2931: l_menu_id NUMBER; /* Bug# 2499051 */
2932: BEGIN
2933: -- reset primary_contact_id before set it up again
2934: PA_RESOURCE_UTILS.G_PRIMARY_CONTACT_NAME:= NULL;
2935:
2936: /* Bug# 2499051 */
2937: select pa_security_pvt.get_menu_id(p_prim_role_name)
2938: into l_menu_id

Line 2972: PA_RESOURCE_UTILS.G_PRIMARY_CONTACT_NAME := l_primary_contact_name;

2968: AND (pep.current_employee_flag = 'Y' OR pep.current_npw_flag = 'Y'); -- Added for bug 4938392
2969:
2970: -- set primary_contact_name to the global variable to get it later
2971: -- from the function 'Get_Org_Prim_Contact_Name'
2972: PA_RESOURCE_UTILS.G_PRIMARY_CONTACT_NAME := l_primary_contact_name;
2973:
2974: RETURN l_primary_contact_id;
2975:
2976: EXCEPTION

Line 3350: IF pa_resource_utils.is_future_resource ( p_resource_id ) = 'Y' THEN

3346: ---------------------------------------------------------------------
3347: --If Future resource use organization calendar, otherwise use resources
3348: --JTF calendar
3349: ----------------------------------------------------------------------
3350: IF pa_resource_utils.is_future_resource ( p_resource_id ) = 'Y' THEN
3351:
3352: --dbms_output.put_line('Future Resource');
3353:
3354: BEGIN

Line 3369: pa_resource_utils.get_org_defaults ( P_ORGANIZATION_ID => l_organization_id,

3365: END;
3366:
3367: --dbms_output.put_line('Resource Organization Id: ' || l_organization_id);
3368:
3369: pa_resource_utils.get_org_defaults ( P_ORGANIZATION_ID => l_organization_id,
3370: X_DEFAULT_OU => l_default_ou,
3371: X_DEFAULT_CAL_ID => l_calendar_id,
3372: X_RETURN_STATUS => l_return_status);
3373:

Line 4005: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_RESOURCE_UTILS.Validate_person'

4001: EXCEPTION
4002:
4003: WHEN OTHERS THEN
4004: -- Set the exception Message and the stack
4005: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_RESOURCE_UTILS.Validate_person'
4006: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4008: RAISE;
4009:

Line 4109: pa_resource_utils.allocate_unique(

4105: Return -99;
4106: END IF;
4107:
4108: /* Get lock handle for user lock */
4109: pa_resource_utils.allocate_unique(
4110: p_lock_name =>lock_name,
4111: p_lock_handle =>lockhndl);
4112:
4113: IF ( lockhndl IS NOT NULL ) then

Line 4163: pa_resource_utils.allocate_unique(

4159: Return -99;
4160: END IF;
4161:
4162: /* Get lock handle for user lock */
4163: pa_resource_utils.allocate_unique(
4164: p_lock_name =>lock_name,
4165: p_lock_handle =>lockhndl);
4166:
4167: IF ( lockhndl IS NOT NULL ) then

Line 4727: PA_RESOURCE_UTILS.G_HR_SUPERVISOR_NAME := x_ManagerName;

4723: END;
4724: END IF;
4725: END LOOP;
4726:
4727: PA_RESOURCE_UTILS.G_HR_SUPERVISOR_NAME := x_ManagerName;
4728: PA_RESOURCE_UTILS.G_HR_SUPERVISOR_ID := x_ManagerId;
4729: -- PA_RESOURCE_UTILS.G_ASSIGNMENT_ID := p_assignment_id; -- Bug 4473484
4730: PA_RESOURCE_UTILS.G_START_DATE := p_start_date; -- Bug 4473484
4731: PA_RESOURCE_UTILS.G_RESOURCE_ID := p_resource_id;

Line 4728: PA_RESOURCE_UTILS.G_HR_SUPERVISOR_ID := x_ManagerId;

4724: END IF;
4725: END LOOP;
4726:
4727: PA_RESOURCE_UTILS.G_HR_SUPERVISOR_NAME := x_ManagerName;
4728: PA_RESOURCE_UTILS.G_HR_SUPERVISOR_ID := x_ManagerId;
4729: -- PA_RESOURCE_UTILS.G_ASSIGNMENT_ID := p_assignment_id; -- Bug 4473484
4730: PA_RESOURCE_UTILS.G_START_DATE := p_start_date; -- Bug 4473484
4731: PA_RESOURCE_UTILS.G_RESOURCE_ID := p_resource_id;
4732:

Line 4729: -- PA_RESOURCE_UTILS.G_ASSIGNMENT_ID := p_assignment_id; -- Bug 4473484

4725: END LOOP;
4726:
4727: PA_RESOURCE_UTILS.G_HR_SUPERVISOR_NAME := x_ManagerName;
4728: PA_RESOURCE_UTILS.G_HR_SUPERVISOR_ID := x_ManagerId;
4729: -- PA_RESOURCE_UTILS.G_ASSIGNMENT_ID := p_assignment_id; -- Bug 4473484
4730: PA_RESOURCE_UTILS.G_START_DATE := p_start_date; -- Bug 4473484
4731: PA_RESOURCE_UTILS.G_RESOURCE_ID := p_resource_id;
4732:
4733: RETURN x_ManagerId;

Line 4730: PA_RESOURCE_UTILS.G_START_DATE := p_start_date; -- Bug 4473484

4726:
4727: PA_RESOURCE_UTILS.G_HR_SUPERVISOR_NAME := x_ManagerName;
4728: PA_RESOURCE_UTILS.G_HR_SUPERVISOR_ID := x_ManagerId;
4729: -- PA_RESOURCE_UTILS.G_ASSIGNMENT_ID := p_assignment_id; -- Bug 4473484
4730: PA_RESOURCE_UTILS.G_START_DATE := p_start_date; -- Bug 4473484
4731: PA_RESOURCE_UTILS.G_RESOURCE_ID := p_resource_id;
4732:
4733: RETURN x_ManagerId;
4734:

Line 4731: PA_RESOURCE_UTILS.G_RESOURCE_ID := p_resource_id;

4727: PA_RESOURCE_UTILS.G_HR_SUPERVISOR_NAME := x_ManagerName;
4728: PA_RESOURCE_UTILS.G_HR_SUPERVISOR_ID := x_ManagerId;
4729: -- PA_RESOURCE_UTILS.G_ASSIGNMENT_ID := p_assignment_id; -- Bug 4473484
4730: PA_RESOURCE_UTILS.G_START_DATE := p_start_date; -- Bug 4473484
4731: PA_RESOURCE_UTILS.G_RESOURCE_ID := p_resource_id;
4732:
4733: RETURN x_ManagerId;
4734:
4735: END get_hr_manager_id;

Line 4741: IF PA_RESOURCE_UTILS.G_RESOURCE_ID = p_resource_id and PA_RESOURCE_UTILS.G_START_DATE = p_start_date THEN -- Bug 4473484

4737: FUNCTION get_hr_manager_name(p_resource_id IN NUMBER,p_start_date IN DATE DEFAULT NULL) RETURN VARCHAR2 -- Bug 4473484
4738: IS
4739: l_supervisor NUMBER;
4740: BEGIN
4741: IF PA_RESOURCE_UTILS.G_RESOURCE_ID = p_resource_id and PA_RESOURCE_UTILS.G_START_DATE = p_start_date THEN -- Bug 4473484
4742: null;
4743: ELSE
4744: l_supervisor := get_hr_manager_id(p_resource_id => p_resource_id, p_start_date => p_start_date); -- Bug 4473484
4745: END IF;

Line 4746: RETURN PA_RESOURCE_UTILS.G_HR_SUPERVISOR_NAME;

4742: null;
4743: ELSE
4744: l_supervisor := get_hr_manager_id(p_resource_id => p_resource_id, p_start_date => p_start_date); -- Bug 4473484
4745: END IF;
4746: RETURN PA_RESOURCE_UTILS.G_HR_SUPERVISOR_NAME;
4747:
4748: END get_hr_manager_name;
4749:
4750: /*Bug 3737529: Code Addition ends*/

Line 4943: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.Init_FTE_Sync_WF');

4939:
4940: BEGIN
4941:
4942: -- initialize the error stack
4943: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.Init_FTE_Sync_WF');
4944: -- initialize the return status to success
4945: x_return_status := FND_API.G_RET_STS_SUCCESS;
4946:
4947: l_term_type := pa_resource_utils.get_term_type(p_person_id) ;

Line 4947: l_term_type := pa_resource_utils.get_term_type(p_person_id) ;

4943: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.Init_FTE_Sync_WF');
4944: -- initialize the return status to success
4945: x_return_status := FND_API.G_RET_STS_SUCCESS;
4946:
4947: l_term_type := pa_resource_utils.get_term_type(p_person_id) ;
4948:
4949: IF (l_term_type = 'I') THEN
4950:
4951: IF( p_person_id <> nvl(G_TERM_PERSON_ID, -999) ) THEN

Line 4955: pa_resource_utils.is_fte(p_person_id => G_TERM_PERSON_ID,

4951: IF( p_person_id <> nvl(G_TERM_PERSON_ID, -999) ) THEN
4952:
4953: G_TERM_PERSON_ID := p_person_id ;
4954:
4955: pa_resource_utils.is_fte(p_person_id => G_TERM_PERSON_ID,
4956: x_return_end_date => l_return_end_date,
4957: x_invol_term => l_invol_term ,
4958: x_wait_days => l_wait_days ,
4959: x_msg_data => x_msg_data,

Line 4984: pa_resource_utils.get_fte_flag(p_person_id => G_TERM_PERSON_ID,

4980: last_update_login = fnd_global.login_id
4981: WHERE person_id = G_TERM_PERSON_ID --l_person_id
4982: AND resource_effective_end_date = l_resource_effective_end_date;
4983:
4984: pa_resource_utils.get_fte_flag(p_person_id => G_TERM_PERSON_ID,
4985: x_future_term_wf_flag => l_future_term_wf_flag,
4986: x_msg_data => x_msg_data,
4987: x_msg_count => x_msg_count,
4988: x_return_status => x_return_status);

Line 4999: pa_resource_utils.set_fte_flag(p_person_id => G_TERM_PERSON_ID,

4995: x_msg_count => x_msg_count,
4996: x_msg_data => x_msg_data);
4997:
4998:
4999: pa_resource_utils.set_fte_flag(p_person_id => G_TERM_PERSON_ID,
5000: p_future_term_wf_flag => 'Y',
5001: x_msg_data => x_msg_data,
5002: x_msg_count => x_msg_count,
5003: x_return_status => x_return_status ) ;

Line 5016: pa_resource_utils.set_fte_flag(p_person_id => G_TERM_PERSON_ID,

5012: END IF ; --IF l_future_term_wf_flag IS NULL
5013:
5014: ELSE -- IF (G_FTE_FLAG = 'Y')
5015:
5016: pa_resource_utils.set_fte_flag(p_person_id => G_TERM_PERSON_ID,
5017: p_future_term_wf_flag => NULL,
5018: x_msg_data => x_msg_data,
5019: x_msg_count => x_msg_count,
5020: x_return_status => x_return_status) ;

Line 5032: pa_resource_utils.set_fte_flag(p_person_id => p_person_id,

5028:
5029: l_invol_term := 'N';
5030:
5031: /* Added for Bug 6056112 */
5032: pa_resource_utils.set_fte_flag(p_person_id => p_person_id,
5033: p_future_term_wf_flag => NULL,
5034: x_msg_data => x_msg_data,
5035: x_msg_count => x_msg_count,
5036: x_return_status => x_return_status) ;

Line 5052: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',

5048: WHEN OTHERS THEN
5049: x_return_status := FND_API.G_RET_STS_ERROR;
5050: x_msg_count := 1;
5051: x_msg_data := substr(SQLERRM,1,240);
5052: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',
5053: p_procedure_name => 'Init_FTE_sync_wf');
5054: If x_msg_count = 1 THEN
5055: pa_interface_utils_pub.get_messages
5056: (p_encoded => FND_API.G_TRUE,

Line 5088: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.set_fte_flag');

5084: l_msg_index_out NUMBER;
5085:
5086: BEGIN
5087: -- initialize the error stack
5088: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.set_fte_flag');
5089: -- initialize the return status to success
5090: x_return_status := FND_API.G_RET_STS_SUCCESS;
5091:
5092: l_resource_id := pa_resource_utils.get_resource_id(p_person_id);

Line 5092: l_resource_id := pa_resource_utils.get_resource_id(p_person_id);

5088: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.set_fte_flag');
5089: -- initialize the return status to success
5090: x_return_status := FND_API.G_RET_STS_SUCCESS;
5091:
5092: l_resource_id := pa_resource_utils.get_resource_id(p_person_id);
5093:
5094: IF NVL(l_resource_id,-999) <> -999 THEN
5095:
5096: UPDATE pa_resources

Line 5117: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',

5113: WHEN OTHERS THEN
5114: x_return_status := FND_API.G_RET_STS_ERROR;
5115: x_msg_count := 1;
5116: x_msg_data := substr(SQLERRM,1,240);
5117: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',
5118: p_procedure_name => 'set_fte_flag');
5119: If x_msg_count = 1 THEN
5120: pa_interface_utils_pub.get_messages
5121: (p_encoded => FND_API.G_TRUE,

Line 5154: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_fte_flag');

5150: l_msg_index_out NUMBER;
5151:
5152: BEGIN
5153: -- initialize the error stack
5154: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_fte_flag');
5155: -- initialize the return status to success
5156: x_return_status := FND_API.G_RET_STS_SUCCESS;
5157:
5158: l_resource_id := pa_resource_utils.get_resource_id(p_person_id);

Line 5158: l_resource_id := pa_resource_utils.get_resource_id(p_person_id);

5154: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_fte_flag');
5155: -- initialize the return status to success
5156: x_return_status := FND_API.G_RET_STS_SUCCESS;
5157:
5158: l_resource_id := pa_resource_utils.get_resource_id(p_person_id);
5159:
5160: IF NVL(l_resource_id,-999) <> -999 THEN
5161:
5162: SELECT pa_resources.future_term_wf_flag

Line 5185: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',

5181: x_future_term_wf_flag := NULL;
5182: x_return_status := FND_API.G_RET_STS_ERROR;
5183: x_msg_count := 1;
5184: x_msg_data := substr(SQLERRM,1,240);
5185: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',
5186: p_procedure_name => 'get_fte_flag');
5187: If x_msg_count = 1 THEN
5188: pa_interface_utils_pub.get_messages
5189: (p_encoded => FND_API.G_TRUE,

Line 5226: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.is_fte');

5222: l_msg_index_out NUMBER;
5223:
5224: BEGIN
5225: -- initialize the error stack
5226: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.is_fte');
5227: -- initialize the return status to success
5228: x_return_status := FND_API.G_RET_STS_SUCCESS;
5229:
5230: SELECT distinct(resource_person_type)

Line 5255: pa_resource_utils.get_valid_enddate(p_person_id => p_person_id,

5251: END IF ; --IF (l_system_person_type = 'EMP' )
5252:
5253: IF (l_end_date > trunc(sysdate)) THEN
5254:
5255: pa_resource_utils.get_valid_enddate(p_person_id => p_person_id,
5256: p_actual_term_date => l_end_date,
5257: x_valid_end_date => l_valid_end_date,
5258: x_msg_data => x_msg_data,
5259: x_msg_count => x_msg_count,

Line 5283: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',

5279: WHEN OTHERS THEN
5280: x_return_status := FND_API.G_RET_STS_ERROR;
5281: x_msg_count := 1;
5282: x_msg_data := substr(SQLERRM,1,240);
5283: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',
5284: p_procedure_name => 'is_fte');
5285: If x_msg_count = 1 THEN
5286: pa_interface_utils_pub.get_messages
5287: (p_encoded => FND_API.G_TRUE,

Line 5320: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_valid_enddate');

5316: l_msg_index_out NUMBER;
5317:
5318: BEGIN
5319: -- initialize the error stack
5320: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.get_valid_enddate');
5321: -- initialize the return status to success
5322: x_return_status := FND_API.G_RET_STS_SUCCESS;
5323:
5324:

Line 5351: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',

5347: WHEN OTHERS THEN
5348: x_return_status := FND_API.G_RET_STS_ERROR;
5349: x_msg_count := 1;
5350: x_msg_data := substr(SQLERRM,1,240);
5351: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',
5352: p_procedure_name => 'get_valid_enddate');
5353: If x_msg_count = 1 THEN
5354: pa_interface_utils_pub.get_messages
5355: (p_encoded => FND_API.G_TRUE,

Line 5410: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.is_term_as_of_sys_date');

5406:
5407: BEGIN
5408: -- initialize the error stack
5409: --
5410: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.is_term_as_of_sys_date');
5411:
5412: IF (l_pa_debug_mode = 'Y') THEN
5413: pa_debug.write('PA_RESOURCE_UTILS',
5414: 'log: ' || 'in procedure is_term_as_of_sys_date', 3);

Line 5413: pa_debug.write('PA_RESOURCE_UTILS',

5409: --
5410: PA_DEBUG.init_err_stack('PA_RESOURCE_UTILS.is_term_as_of_sys_date');
5411:
5412: IF (l_pa_debug_mode = 'Y') THEN
5413: pa_debug.write('PA_RESOURCE_UTILS',
5414: 'log: ' || 'in procedure is_term_as_of_sys_date', 3);
5415: END IF;
5416:
5417:

Line 5426: pa_resource_utils.get_fte_flag(p_person_id => l_person_id,

5422: aname => 'PERSON_ID' );
5423:
5424: --get the future_term_wf_flag from pa_resources
5425: --
5426: pa_resource_utils.get_fte_flag(p_person_id => l_person_id,
5427: x_future_term_wf_flag => l_future_term_wf_flag,
5428: x_msg_data => l_msg_data,
5429: x_msg_count => l_msg_count,
5430: x_return_status => l_return_status);

Line 5433: pa_debug.write('PA_RESOURCE_UTILS',

5429: x_msg_count => l_msg_count,
5430: x_return_status => l_return_status);
5431:
5432: IF (l_pa_debug_mode = 'Y') THEN
5433: pa_debug.write('PA_RESOURCE_UTILS',
5434: 'log: ' || 'in procedure is_term_as_of_sys_date, l_future_term_wf_flag: '||l_future_term_wf_flag, 3);
5435: END IF ;
5436:
5437: OPEN c_act_term_date(l_person_id);

Line 5444: pa_debug.write('PA_RESOURCE_UTILS',

5440: IF c_act_term_date%NOTFOUND THEN
5441: CLOSE c_act_term_date;
5442: resultout := wf_engine.eng_completed||':'||'E';
5443: IF (l_pa_debug_mode = 'Y') THEN
5444: pa_debug.write('PA_RESOURCE_UTILS',
5445: 'log: ' || 'in procedure is_term_as_of_sys_date, no end date found', 3);
5446: END IF;
5447:
5448: ELSE --IF c_act_term_date%NOTFOUND

Line 5452: pa_debug.write('PA_RESOURCE_UTILS',

5448: ELSE --IF c_act_term_date%NOTFOUND
5449:
5450: CLOSE c_act_term_date;
5451: IF (l_pa_debug_mode = 'Y') THEN
5452: pa_debug.write('PA_RESOURCE_UTILS',
5453: 'log: ' || 'in procedure is_term_as_of_sys_date, l_end_date: '||l_end_date, 3);
5454: END IF;
5455:
5456:

Line 5466: pa_debug.write('PA_RESOURCE_UTILS',

5462:
5463: END IF ; --IF c_act_term_date%NOTFOUND
5464:
5465: IF (l_pa_debug_mode = 'Y') THEN
5466: pa_debug.write('PA_RESOURCE_UTILS',
5467: 'log: ' || 'in procedure is_term_as_of_sys_date, resultout: '||resultout, 3);
5468: END IF;
5469:
5470:

Line 5473: wf_core.context('pa_resource_utils',

5469:
5470:
5471: EXCEPTION
5472: WHEN OTHERS THEN
5473: wf_core.context('pa_resource_utils',
5474: 'is_term_as_of_sys_date',
5475: itemtype,
5476: itemkey,
5477: to_char(actid),

Line 5485: END pa_resource_utils ;

5481:
5482:
5483: END is_term_as_of_sys_date;
5484:
5485: END pa_resource_utils ;