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 1584: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id (

1580: -- To find Visit Type Code when Visit Type Name has input values
1581: IF l_Visit_rec.visit_type_name IS NOT NULL AND
1582: l_Visit_rec.visit_type_name <> Fnd_Api.G_MISS_CHAR THEN
1583:
1584: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id (
1585: p_lookup_type => 'AHL_PLANNING_VISIT_TYPE',
1586: p_lookup_code => NULL,
1587: p_meaning => l_Visit_rec.visit_type_name,
1588: p_check_id_flag => 'Y',

Line 1629: AHL_VWP_RULES_PVT.Check_Org_Name_Or_Id

1625: -- To Convert Organization Name to Organization Id
1626: IF (l_Visit_rec.org_name IS NOT NULL AND
1627: l_Visit_rec.org_name <> Fnd_Api.G_MISS_CHAR) THEN
1628:
1629: AHL_VWP_RULES_PVT.Check_Org_Name_Or_Id
1630: (p_organization_id => l_Visit_rec.organization_id,
1631: p_org_name => l_Visit_rec.org_name,
1632: x_organization_id => l_organization_id,
1633: x_return_status => l_return_status,

Line 1662: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

1658: l_Visit_rec.dept_name <> Fnd_Api.G_MISS_CHAR ) OR
1659: (l_Visit_rec.department_id IS NOT NULL AND
1660: l_Visit_rec.department_id <> Fnd_Api.G_MISS_NUM) THEN
1661:
1662: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
1663: (p_organization_id => l_Visit_rec.organization_id,
1664: p_dept_name => l_Visit_rec.dept_name,
1665: p_department_id => l_Visit_rec.department_id,
1666: x_department_id => l_department_id,

Line 1676: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT

1672: Fnd_Msg_Pub.ADD;
1673: RAISE Fnd_Api.G_EXC_ERROR;
1674: END IF;
1675:
1676: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT
1677: (p_dept_id => l_department_id,
1678: x_return_status => l_return_status);
1679:
1680: IF NVL(l_return_status,'x') <> 'S' THEN

Line 1701: AHL_VWP_RULES_PVT.Check_SR_Request_Number_Or_Id

1697:
1698: -- For SERVICE REQUEST
1699: -- To Convert Service Request Number to Service Request Id
1700: IF (l_Visit_rec.service_request_number IS NOT NULL AND l_Visit_rec.service_request_number <> Fnd_Api.G_MISS_CHAR ) THEN
1701: AHL_VWP_RULES_PVT.Check_SR_Request_Number_Or_Id
1702: (p_service_id => l_Visit_rec.service_request_id,
1703: p_service_number => l_Visit_rec.service_request_number,
1704: x_service_id => l_service_id,
1705: x_return_status => l_return_status,

Line 1797: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id

1793:
1794: -- Post 11.5.10 Enhancements
1795: -- For PRIORITY
1796: IF l_Visit_rec.priority_value IS NOT NULL AND l_Visit_rec.priority_value <> Fnd_Api.G_MISS_CHAR THEN
1797: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id
1798: (p_lookup_type => 'AHL_VWP_VISIT_PRIORITY',
1799: p_lookup_code => l_Visit_rec.priority_code,
1800: p_meaning => l_Visit_rec.priority_value,
1801: p_check_id_flag => 'Y',

Line 1816: AHL_VWP_RULES_PVT.Check_Project_Template_Or_Id

1812:
1813: -- Post 11.5.10 Enhancements
1814: -- For PROJECT TEMPLATE
1815: IF l_visit_rec.proj_template_name IS NOT NULL THEN
1816: AHL_VWP_RULES_PVT.Check_Project_Template_Or_Id
1817: ( p_proj_temp_name => l_visit_rec.proj_template_name,
1818: x_project_id => l_proj_template_id,
1819: x_return_status => l_return_status,
1820: x_error_msg_code => l_msg_data);

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

2501: LOOP
2502: FETCH c_task INTO c_task_rec;
2503: EXIT WHEN c_task%NOTFOUND;
2504:
2505: c_task_rec.visit_task_id := AHL_VWP_RULES_PVT.Get_Visit_Task_Id();
2506:
2507: -- if visit org/dept/dates are changed, then clear up task price
2508: IF l_price_changed = 'Y' THEN
2509: l_actual_price := NULL;

Line 3019: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id

3015: ----------- LOVs on Update Visit UI Screen---
3016: -- For VISIT TYPE
3017: -- To find Visit Type Code when Visit Type Name has input values
3018: IF l_Visit_rec.visit_type_name IS NOT NULL AND l_Visit_rec.visit_type_name <> Fnd_Api.G_MISS_CHAR THEN
3019: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id
3020: ( p_lookup_type => 'AHL_PLANNING_VISIT_TYPE',
3021: p_lookup_code => NULL,
3022: p_meaning => l_Visit_rec.visit_type_name,
3023: p_check_id_flag => 'Y',

Line 3044: AHL_VWP_RULES_PVT.Check_SR_Request_Number_Or_Id

3040: -- To Convert Service Request Number to Service Request Id
3041: IF (l_Visit_rec.service_request_number IS NOT NULL AND
3042: l_Visit_rec.service_request_number <> Fnd_Api.G_MISS_CHAR ) THEN
3043:
3044: AHL_VWP_RULES_PVT.Check_SR_Request_Number_Or_Id
3045: ( p_service_id => l_Visit_rec.service_request_id,
3046: p_service_number => l_Visit_rec.service_request_number,
3047: x_service_id => l_service_id,
3048: x_return_status => l_return_status,

Line 3068: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id

3064: ----------- End defining and validate all LOVs on Update Visit UI Screen---
3065: -- For Priority
3066: -- To Convert Priority Value to Code
3067: IF l_Visit_rec.priority_value IS NOT NULL AND l_Visit_rec.priority_value <> Fnd_Api.G_MISS_CHAR THEN
3068: AHL_VWP_RULES_PVT.Check_Lookup_Name_Or_Id
3069: (p_lookup_type => 'AHL_VWP_VISIT_PRIORITY',
3070: p_lookup_code => l_Visit_rec.priority_code,
3071: p_meaning => l_Visit_rec.priority_value,
3072: p_check_id_flag => 'Y',

Line 3089: AHL_VWP_RULES_PVT.Check_Org_Name_Or_Id

3085: -- To Convert Organization Name to ID
3086: IF (l_visit_rec.ORG_NAME IS NOT NULL AND l_visit_rec.ORG_NAME <> Fnd_Api.G_MISS_CHAR ) OR
3087: (l_visit_rec.organization_id IS NOT NULL AND l_visit_rec.organization_id <> Fnd_Api.G_MISS_NUM )
3088: THEN
3089: AHL_VWP_RULES_PVT.Check_Org_Name_Or_Id
3090: (p_organization_id => l_visit_rec.organization_id,
3091: p_org_name => l_visit_rec.ORG_NAME,
3092: x_organization_id => l_organization_id,
3093: x_return_status => l_return_status,

Line 3121: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

3117: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3118: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Inside Dept Name/ID - '||l_visit_rec.DEPT_NAME ||' - '||l_visit_rec.department_id );
3119: END IF;
3120:
3121: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
3122: ( p_organization_id => l_visit_rec.organization_id,
3123: p_dept_name => l_visit_rec.DEPT_NAME,
3124: p_department_id => l_visit_rec.department_id,
3125: x_department_id => l_department_id,

Line 3136: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT

3132: RAISE Fnd_Api.G_EXC_ERROR;
3133: END IF;
3134:
3135: l_visit_rec.department_id := l_department_id;
3136: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT
3137: (p_dept_id => l_visit_rec.department_id,
3138: x_return_status => l_return_status);
3139:
3140: IF NVL(l_return_status,'x') <> 'S' THEN

Line 3157: AHL_VWP_RULES_PVT.Check_Project_Template_Or_Id

3153:
3154: -- For Project Template
3155: -- To Convert Project Template Name to ID
3156: IF l_visit_rec.proj_template_name IS NOT NULL THEN
3157: AHL_VWP_RULES_PVT.Check_Project_Template_Or_Id
3158: ( p_proj_temp_name => l_visit_rec.proj_template_name,
3159: x_project_id => l_proj_template_id,
3160: x_return_status => l_return_status,
3161: x_error_msg_code => l_msg_data);

Line 3781: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

3777:
3778: -- Set any task changed flag to "Y" if start/end date changed
3779: 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')
3780: 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
3781: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag
3782: (
3783: p_visit_id => l_Visit_rec.visit_id,
3784: p_flag => 'Y',
3785: x_return_status => l_return_status);

Line 5682: AHL_VWP_RULES_PVT.Check_Org_Name_Or_Id

5678: l_visit_rec.START_DATE := SYSDATE;
5679: END IF;
5680:
5681: -- Organization belongs to user's operating unit
5682: AHL_VWP_RULES_PVT.Check_Org_Name_Or_Id
5683: ( p_organization_id => l_visit_rec.organization_id,
5684: p_org_name => null,
5685: x_organization_id => l_org_id,
5686: x_return_status => l_return_status,

Line 5698: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT

5694: RAISE Fnd_Api.G_EXC_ERROR;
5695: END IF;
5696:
5697: -- Department must have shift defined
5698: AHL_VWP_RULES_PVT.CHECK_DEPARTMENT_SHIFT
5699: (p_dept_id => l_visit_rec.department_id,
5700: x_return_status => l_return_status);
5701:
5702: IF NVL(l_return_status,'x') <> 'S' THEN