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.AHL_VWP_VISITS_PVT dependencies on AHL_VWP_RULES_PVT

Line 1874: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id (

1870: -- To find Visit Type Code when Visit Type Name has input values
1871: IF l_Visit_rec.visit_type_name IS NOT NULL AND
1872: l_Visit_rec.visit_type_name <> Fnd_Api.G_MISS_CHAR THEN
1873:
1874: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id (
1875: p_lookup_type => 'AHL_PLANNING_VISIT_TYPE',
1876: p_lookup_code => NULL,
1877: p_meaning => l_Visit_rec.visit_type_name,
1878: p_check_id_flag => 'Y',

Line 1920: AHL_VWP_RULES_PVT.Check_Org_Name_Or_Id

1916: -- To Convert Organization Name to Organization Id
1917: IF (l_Visit_rec.org_name IS NOT NULL AND
1918: l_Visit_rec.org_name <> Fnd_Api.G_MISS_CHAR) THEN
1919:
1920: AHL_VWP_RULES_PVT.Check_Org_Name_Or_Id
1921: (p_organization_id => l_Visit_rec.organization_id,
1922: p_org_name => l_Visit_rec.org_name,
1923: x_organization_id => l_organization_id,
1924: x_return_status => l_return_status,

Line 1953: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

1949: l_Visit_rec.dept_name <> Fnd_Api.G_MISS_CHAR ) OR
1950: (l_Visit_rec.department_id IS NOT NULL AND
1951: l_Visit_rec.department_id <> Fnd_Api.G_MISS_NUM) THEN
1952:
1953: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
1954: (p_organization_id => l_Visit_rec.organization_id,
1955: p_dept_name => l_Visit_rec.dept_name,
1956: p_department_id => l_Visit_rec.department_id,
1957: x_department_id => l_department_id,

Line 1967: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT

1963: Fnd_Msg_Pub.ADD;
1964: RAISE Fnd_Api.G_EXC_ERROR;
1965: END IF;
1966:
1967: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT
1968: (p_dept_id => l_department_id,
1969: x_return_status => l_return_status);
1970:
1971: IF NVL(l_return_status,'x') <> 'S' THEN

Line 1992: AHL_VWP_RULES_PVT.Check_SR_Request_Number_Or_Id

1988:
1989: -- For SERVICE REQUEST
1990: -- To Convert Service Request Number to Service Request Id
1991: IF (l_Visit_rec.service_request_number IS NOT NULL AND l_Visit_rec.service_request_number <> Fnd_Api.G_MISS_CHAR ) THEN
1992: AHL_VWP_RULES_PVT.Check_SR_Request_Number_Or_Id
1993: (p_service_id => l_Visit_rec.service_request_id,
1994: p_service_number => l_Visit_rec.service_request_number,
1995: x_service_id => l_service_id,
1996: x_return_status => l_return_status,

Line 2090: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id

2086:
2087: -- Post 11.5.10 Enhancements
2088: -- For PRIORITY
2089: IF l_Visit_rec.priority_value IS NOT NULL AND l_Visit_rec.priority_value <> Fnd_Api.G_MISS_CHAR THEN
2090: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id
2091: (p_lookup_type => 'AHL_VWP_VISIT_PRIORITY',
2092: p_lookup_code => l_Visit_rec.priority_code,
2093: p_meaning => l_Visit_rec.priority_value,
2094: p_check_id_flag => 'Y',

Line 2115: AHL_VWP_RULES_PVT.Check_Project_Template_Or_Id

2111: Fnd_Message.SET_NAME('AHL', 'AHL_VWP_INV_PROJ_AND_TEMP');
2112: Fnd_Msg_Pub.ADD;
2113: RAISE Fnd_Api.G_EXC_ERROR;
2114: ELSE --i.e. name is null but template is not null
2115: AHL_VWP_RULES_PVT.Check_Project_Template_Or_Id
2116: ( p_proj_temp_name => l_visit_rec.proj_template_name,
2117: x_project_id => l_proj_template_id,
2118: x_return_status => l_return_status,
2119: x_error_msg_code => l_msg_data);

Line 3063: c_task_rec.visit_task_id := AHL_VWP_RULES_PVT.Get_Visit_Task_Id();

3059: LOOP
3060: FETCH c_task INTO c_task_rec;
3061: EXIT WHEN c_task%NOTFOUND;
3062:
3063: c_task_rec.visit_task_id := AHL_VWP_RULES_PVT.Get_Visit_Task_Id();
3064:
3065: -- if visit org/dept/dates are changed, then clear up task price
3066: IF l_price_changed = 'Y' THEN
3067: l_actual_price := NULL;

Line 3729: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id

3725: ----------- LOVs on Update Visit UI Screen---
3726: -- For VISIT TYPE
3727: -- To find Visit Type Code when Visit Type Name has input values
3728: IF l_Visit_rec.visit_type_name IS NOT NULL AND l_Visit_rec.visit_type_name <> Fnd_Api.G_MISS_CHAR THEN
3729: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id
3730: ( p_lookup_type => 'AHL_PLANNING_VISIT_TYPE',
3731: p_lookup_code => NULL,
3732: p_meaning => l_Visit_rec.visit_type_name,
3733: p_check_id_flag => 'Y',

Line 3762: AHL_VWP_RULES_PVT.Check_SR_Request_Number_Or_Id

3758: -- To Convert Service Request Number to Service Request Id
3759: IF (l_Visit_rec.service_request_number IS NOT NULL AND
3760: l_Visit_rec.service_request_number <> Fnd_Api.G_MISS_CHAR ) THEN
3761:
3762: AHL_VWP_RULES_PVT.Check_SR_Request_Number_Or_Id
3763: ( p_service_id => l_Visit_rec.service_request_id,
3764: p_service_number => l_Visit_rec.service_request_number,
3765: x_service_id => l_service_id,
3766: x_return_status => l_return_status,

Line 3786: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id

3782: ----------- End defining and validate all LOVs on Update Visit UI Screen---
3783: -- For Priority
3784: -- To Convert Priority Value to Code
3785: IF l_Visit_rec.priority_value IS NOT NULL AND l_Visit_rec.priority_value <> Fnd_Api.G_MISS_CHAR THEN
3786: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id
3787: (p_lookup_type => 'AHL_VWP_VISIT_PRIORITY',
3788: p_lookup_code => l_Visit_rec.priority_code,
3789: p_meaning => l_Visit_rec.priority_value,
3790: p_check_id_flag => 'Y',

Line 3807: AHL_VWP_RULES_PVT.Check_Org_Name_Or_Id

3803: -- To Convert Organization Name to ID
3804: IF (l_visit_rec.ORG_NAME IS NOT NULL AND l_visit_rec.ORG_NAME <> Fnd_Api.G_MISS_CHAR ) OR
3805: (l_visit_rec.organization_id IS NOT NULL AND l_visit_rec.organization_id <> Fnd_Api.G_MISS_NUM )
3806: THEN
3807: AHL_VWP_RULES_PVT.Check_Org_Name_Or_Id
3808: (p_organization_id => l_visit_rec.organization_id,
3809: p_org_name => l_visit_rec.ORG_NAME,
3810: x_organization_id => l_organization_id,
3811: x_return_status => l_return_status,

Line 3839: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

3835: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3836: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Inside Dept Name/ID - '||l_visit_rec.DEPT_NAME ||' - '||l_visit_rec.department_id );
3837: END IF;
3838:
3839: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
3840: ( p_organization_id => l_visit_rec.organization_id,
3841: p_dept_name => l_visit_rec.DEPT_NAME,
3842: p_department_id => l_visit_rec.department_id,
3843: x_department_id => l_department_id,

Line 3854: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT

3850: RAISE Fnd_Api.G_EXC_ERROR;
3851: END IF;
3852:
3853: l_visit_rec.department_id := l_department_id;
3854: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT
3855: (p_dept_id => l_visit_rec.department_id,
3856: x_return_status => l_return_status);
3857:
3858: IF NVL(l_return_status,'x') <> 'S' THEN

Line 3880: AHL_VWP_RULES_PVT.Check_Project_Template_Or_Id

3876: Fnd_Message.SET_NAME('AHL', 'AHL_VWP_INV_PROJ_AND_TEMP');
3877: Fnd_Msg_Pub.ADD;
3878: RAISE Fnd_Api.G_EXC_ERROR;
3879: ELSE --i.e. name is null but template is not null
3880: AHL_VWP_RULES_PVT.Check_Project_Template_Or_Id
3881: ( p_proj_temp_name => l_visit_rec.proj_template_name,
3882: x_project_id => l_proj_template_id,
3883: x_return_status => l_return_status,
3884: x_error_msg_code => l_msg_data);

Line 5006: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

5002:
5003: -- Set any task changed flag to "Y" if start/end date changed
5004: IF NVL(TO_CHAR(l_date_time_start,'DD-MM-YYYY HH24:MI'),'XXX') <> NVL(TO_CHAR(c_Visit_rec.START_DATE_TIME,'DD-MM-YYYY HH24:MI'),'XXX')
5005: OR NVL(TO_CHAR(l_date_time_end,'DD-MM-YYYY HH24:MI'),'XXX') <> NVL(TO_CHAR(c_Visit_rec.CLOSE_DATE_TIME,'DD-MM-YYYY HH24:MI'),'XXX') THEN
5006: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag
5007: (
5008: p_visit_id => l_Visit_rec.visit_id,
5009: p_flag => 'Y',
5010: x_return_status => l_return_status);

Line 7443: AHL_VWP_RULES_PVT.Check_Org_Name_Or_Id

7439: l_visit_rec.START_DATE := SYSDATE;
7440: END IF;
7441:
7442: -- Organization belongs to user's operating unit
7443: AHL_VWP_RULES_PVT.Check_Org_Name_Or_Id
7444: ( p_organization_id => l_visit_rec.organization_id,
7445: p_org_name => null,
7446: x_organization_id => l_org_id,
7447: x_return_status => l_return_status,

Line 7459: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT

7455: RAISE Fnd_Api.G_EXC_ERROR;
7456: END IF;
7457:
7458: -- Department must have shift defined
7459: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT
7460: (p_dept_id => l_visit_rec.department_id,
7461: x_return_status => l_return_status);
7462:
7463: IF NVL(l_return_status,'x') <> 'S' THEN