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_TASKS_PVT dependencies on AHL_VWP_RULES_PVT

Line 70: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

66: -- START: Defining local functions and procedures SIGNATURES --
67: --------------------------------------------------------------------
68: -- To Check_Visit_Task_Req_Items
69: PROCEDURE Check_Visit_Task_Req_Items (
70: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
71: --Added by rnahata for Issue 105
72: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
73: x_return_status OUT NOCOPY VARCHAR2
74: );

Line 78: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

74: );
75:
76: -- To Check_Visit_Task_UK_Items
77: PROCEDURE Check_Visit_Task_UK_Items (
78: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
79: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
80: x_return_status OUT NOCOPY VARCHAR2
81: );
82:

Line 85: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,

81: );
82:
83: -- To Check_Task_Items
84: PROCEDURE Check_Task_Items (
85: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,
86: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
87: x_return_status OUT NOCOPY VARCHAR2
88: );
89:

Line 96: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,

92: p_api_version IN NUMBER,
93: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
94: p_commit IN VARCHAR2 := Fnd_Api.g_false,
95: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
96: p_Task_rec IN AHL_VWP_RULES_PVT.task_rec_type,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2
100: );

Line 104: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type

100: );
101:
102: -- To assign Null to missing attributes of visit while creation/updation.
103: PROCEDURE Default_Missing_Attribs(
104: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
105: );
106:
107: -- To Create Unassociated Task
108: PROCEDURE Create_Unassociated_Task(

Line 114: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

110: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
111: p_commit IN VARCHAR2 := Fnd_Api.g_false,
112: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
113: p_module_type IN VARCHAR2 := 'JSP',
114: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2
118: );

Line 127: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

123: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
124: p_commit IN VARCHAR2 := Fnd_Api.g_false,
125: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
126: p_module_type IN VARCHAR2 :='JSP',
127: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2
131: );

Line 153: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

149: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
150: p_commit IN VARCHAR2 := Fnd_Api.g_false,
151: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
152: p_module_type IN VARCHAR2 := 'JSP',
153: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2
157: );

Line 167: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

163: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
164: p_commit IN VARCHAR2 := Fnd_Api.g_false,
165: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
166: p_module_type IN VARCHAR2 := 'JSP',
167: p_x_task_Rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2
171: );

Line 196: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

192: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
193: p_commit IN VARCHAR2:= FND_API.G_FALSE,
194: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
195: p_module_type IN VARCHAR2:= 'JSP',
196: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2
200: );

Line 208: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

204: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
205: p_commit IN VARCHAR2:= FND_API.G_FALSE,
206: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
207: p_module_type IN VARCHAR2:= 'JSP',
208: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2
212: );

Line 346: ( p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type)

342:
343: -- end of the local procedure to set default attribs.
344:
345: PROCEDURE Default_Missing_Attribs
346: ( p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type)
347: AS
348: L_API_NAME CONSTANT VARCHAR2(30) := 'Default_Missing_Attribs';
349: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
350: BEGIN

Line 449: x_task_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

445: p_commit IN VARCHAR2 := Fnd_Api.g_false,
446: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
447: p_module_type IN VARCHAR2 :='JSP',
448: p_task_id IN NUMBER,
449: x_task_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
450: x_return_status OUT NOCOPY VARCHAR2,
451: x_msg_count OUT NOCOPY NUMBER,
452: x_msg_data OUT NOCOPY VARCHAR2
453: )

Line 460: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := NULL;

456: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Task_Details';
457: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
458:
459: -- local variables defined for the procedure
460: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := NULL;
461: l_zone VARCHAR2(30);
462: l_sub_zone VARCHAR2(30);
463: l_uom VARCHAR2(30);
464: l_route_id NUMBER;

Line 1338: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

1334: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
1335: p_commit IN VARCHAR2 := Fnd_Api.g_false,
1336: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
1337: p_module_type IN VARCHAR2 := 'JSP',
1338: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
1339: x_return_status OUT NOCOPY VARCHAR2,
1340: x_msg_count OUT NOCOPY NUMBER,
1341: x_msg_data OUT NOCOPY VARCHAR2
1342: )

Line 1351: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;

1347: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
1348: l_msg_count NUMBER;
1349: l_msg_data VARCHAR2(2000);
1350: l_return_status VARCHAR2(1);
1351: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;
1352:
1353: -- To find visit related information
1354: CURSOR c_visit(x_id IN NUMBER) IS
1355: SELECT * FROM AHL_VISITS_VL

Line 1463: AHL_VWP_RULES_PVT.Validate_Past_Task_Dates ( p_task_rec => l_Task_rec,

1459: RAISE FND_API.G_EXC_ERROR;
1460: END IF;
1461: -- SKPATHAK :: Bug #9402556 :: 24-FEB-2010 :: Added call to Validate_Past_Task_Dates
1462: -- Validate past dates against visit stages, task hierarchy and cost parent hierarchy
1463: AHL_VWP_RULES_PVT.Validate_Past_Task_Dates ( p_task_rec => l_Task_rec,
1464: x_return_status => l_return_status);
1465: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1466: IF (l_log_statement >= l_log_current_level) THEN
1467: fnd_log.string(l_log_statement,

Line 1469: 'Returned success from AHL_VWP_RULES_PVT.Validate_Past_Task_Dates');

1465: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1466: IF (l_log_statement >= l_log_current_level) THEN
1467: fnd_log.string(l_log_statement,
1468: L_DEBUG_KEY,
1469: 'Returned success from AHL_VWP_RULES_PVT.Validate_Past_Task_Dates');
1470: END IF;
1471: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1472: RAISE FND_API.G_EXC_ERROR;
1473: ELSE

Line 1836: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

1832: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
1833: p_commit IN VARCHAR2 := Fnd_Api.g_false,
1834: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
1835: p_module_type IN VARCHAR2 := 'JSP',
1836: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
1837: x_return_status OUT NOCOPY VARCHAR2,
1838: x_msg_count OUT NOCOPY NUMBER,
1839: x_msg_data OUT NOCOPY VARCHAR2
1840: )

Line 1847: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;

1843: L_API_NAME CONSTANT VARCHAR2(30) := 'CREATE UNASSOCIATED TASK';
1844: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
1845:
1846: -- Local variables defined for the procedure
1847: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;
1848: l_msg_data VARCHAR2(2000);
1849: l_item_name VARCHAR2(40);
1850: l_rowid VARCHAR2(30);
1851: l_return_status VARCHAR2(1);

Line 1922: AHL_VWP_RULES_PVT.Validate_Service_Type(

1918: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1919: END IF;
1920:
1921: -- PRAKKUM :: FP:PIE :: 13-OCT-2010 :: validate Service Type attributes
1922: AHL_VWP_RULES_PVT.Validate_Service_Type(
1923: p_service_type => l_task_rec.service_type,
1924: p_module_type => p_module_type,
1925: p_unit_effectivity_id => l_task_rec.unit_effectivity_id,
1926: p_x_service_type_code => l_task_rec.service_type_code

Line 2004: AHL_VWP_RULES_PVT.Check_Item_Name_Or_Id

2000: l_Task_rec.inventory_item_id <> Fnd_Api.G_MISS_NUM) AND
2001: (l_Task_rec.item_organization_id IS NOT NULL AND
2002: l_Task_rec.item_organization_id <> Fnd_Api.G_MISS_NUM) THEN
2003:
2004: AHL_VWP_RULES_PVT.Check_Item_Name_Or_Id
2005: (p_item_id => l_Task_rec.inventory_item_id,
2006: p_org_id => l_Task_rec.item_organization_id,
2007: p_item_name => l_Task_rec.item_name,
2008: x_item_id => l_item_id,

Line 2066: 'Calling AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id');

2062:
2063: IF (l_log_statement >= l_log_current_level) THEN
2064: fnd_log.string(l_log_statement,
2065: L_DEBUG_KEY,
2066: 'Calling AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id');
2067: END IF;
2068:
2069: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
2070: (p_organization_id => c_visit_rec.organization_id,

Line 2069: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

2065: L_DEBUG_KEY,
2066: 'Calling AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id');
2067: END IF;
2068:
2069: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
2070: (p_organization_id => c_visit_rec.organization_id,
2071: p_dept_name => l_task_rec.dept_name,
2072: p_department_id => NULL,
2073: x_department_id => l_department_id,

Line 2085: Ahl_vwp_rules_pvt.CHECK_DEPARTMENT_SHIFT

2081: RAISE Fnd_Api.G_EXC_ERROR;
2082: END IF;
2083:
2084: -- Changes for Post 11.5.10 by amagrawa
2085: Ahl_vwp_rules_pvt.CHECK_DEPARTMENT_SHIFT
2086: ( P_DEPT_ID => l_department_id,
2087: X_RETURN_STATUS => l_return_status);
2088:
2089: IF (NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2111: ': AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id ' );

2107: l_Task_rec.serial_number <> Fnd_Api.G_MISS_CHAR) THEN
2108: IF (l_log_statement >= l_log_current_level) THEN
2109: fnd_log.string(l_log_statement,
2110: L_DEBUG_KEY,
2111: ': AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id ' );
2112: END IF;
2113: AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id
2114: (p_item_id => l_Task_rec.inventory_item_id,
2115: p_org_id => l_Task_rec.item_organization_id,

Line 2113: AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id

2109: fnd_log.string(l_log_statement,
2110: L_DEBUG_KEY,
2111: ': AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id ' );
2112: END IF;
2113: AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id
2114: (p_item_id => l_Task_rec.inventory_item_id,
2115: p_org_id => l_Task_rec.item_organization_id,
2116: p_serial_id => l_Task_rec.instance_id,
2117: p_serial_number => l_Task_rec.serial_number,

Line 2139: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(l_task_rec.visit_id, l_task_rec.instance_id)

2135: ': Before UC Item Org ID= ' || l_Task_rec.item_organization_id );
2136: END IF;
2137: /* sowsubra - start
2138: --BEGIN: jeli added for bug 3777720
2139: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(l_task_rec.visit_id, l_task_rec.instance_id)
2140: = FND_API.G_RET_STS_ERROR) THEN
2141: --END: jeli added for bug 3777720
2142: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
2143: Fnd_Msg_Pub.ADD;

Line 2198: 'Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID ' );

2194: l_Task_rec.cost_parent_number <> Fnd_Api.G_MISS_NUM ) THEN
2195: IF (l_log_statement >= l_log_current_level) THEN
2196: fnd_log.string(l_log_statement,
2197: L_DEBUG_KEY,
2198: 'Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID ' );
2199: END IF;
2200: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
2201: (p_visit_task_id => l_Task_rec.cost_parent_id,
2202: p_visit_task_number => l_Task_rec.cost_parent_number,

Line 2200: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID

2196: fnd_log.string(l_log_statement,
2197: L_DEBUG_KEY,
2198: 'Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID ' );
2199: END IF;
2200: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
2201: (p_visit_task_id => l_Task_rec.cost_parent_id,
2202: p_visit_task_number => l_Task_rec.cost_parent_number,
2203: p_visit_id => l_Task_rec.visit_id,
2204: x_visit_task_id => l_cost_parent_id,

Line 2232: 'Calling AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop ' );

2228:
2229: IF (l_log_statement >= l_log_current_level) THEN
2230: fnd_log.string(l_log_statement,
2231: L_DEBUG_KEY,
2232: 'Calling AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop ' );
2233: END IF;
2234: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop
2235: (p_visit_id => l_Task_rec.visit_id,
2236: p_visit_task_id => l_Task_rec.visit_task_id ,

Line 2234: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop

2230: fnd_log.string(l_log_statement,
2231: L_DEBUG_KEY,
2232: 'Calling AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop ' );
2233: END IF;
2234: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop
2235: (p_visit_id => l_Task_rec.visit_id,
2236: p_visit_task_id => l_Task_rec.visit_task_id ,
2237: p_cost_parent_id => l_Task_rec.cost_parent_id
2238: );

Line 2254: 'Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID ' );

2250: l_Task_rec.orginating_task_number <> Fnd_Api.G_MISS_NUM ) THEN
2251: IF (l_log_statement >= l_log_current_level) THEN
2252: fnd_log.string(l_log_statement,
2253: L_DEBUG_KEY,
2254: 'Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID ' );
2255: END IF;
2256: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
2257: (p_visit_task_id => l_Task_rec.originating_task_id,
2258: p_visit_task_number => l_Task_rec.orginating_task_number,

Line 2256: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID

2252: fnd_log.string(l_log_statement,
2253: L_DEBUG_KEY,
2254: 'Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID ' );
2255: END IF;
2256: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
2257: (p_visit_task_id => l_Task_rec.originating_task_id,
2258: p_visit_task_number => l_Task_rec.orginating_task_number,
2259: p_visit_id => l_Task_rec.visit_id,
2260: x_visit_task_id => l_originating_task_id,

Line 2284: AHL_VWP_RULES_PVT.Check_Origin_Task_Loop

2280: -- To Check for originating task id not forming loop
2281: IF (l_Task_rec.originating_task_id IS NOT NULL AND
2282: l_Task_rec.originating_task_id <> Fnd_Api.G_MISS_NUM ) THEN
2283:
2284: AHL_VWP_RULES_PVT.Check_Origin_Task_Loop
2285: (p_visit_id => l_Task_rec.visit_id ,
2286: p_visit_task_id => l_Task_rec.visit_task_id ,
2287: p_originating_task_id => l_Task_rec.originating_task_id
2288: );

Line 2331: l_Visit_Task_ID := AHL_VWP_RULES_PVT.Get_Visit_Task_Id();

2327: */
2328: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: STARTS
2329: -- If task id or task number is null, generate the same
2330: IF ((l_task_rec.visit_task_ID = Fnd_Api.g_miss_num ) OR (l_task_rec.visit_task_ID IS NULL)) THEN
2331: l_Visit_Task_ID := AHL_VWP_RULES_PVT.Get_Visit_Task_Id();
2332: l_task_rec.visit_task_ID := l_Visit_Task_ID;
2333: END IF;
2334:
2335: -- Check for the Visit Number.

Line 2337: l_task_number := AHL_VWP_RULES_PVT.Get_Visit_Task_Number(l_task_rec.visit_id);

2333: END IF;
2334:
2335: -- Check for the Visit Number.
2336: IF ((l_task_rec.visit_task_number = Fnd_Api.g_miss_num ) OR (l_task_rec.visit_task_number IS NULL)) THEN
2337: l_task_number := AHL_VWP_RULES_PVT.Get_Visit_Task_Number(l_task_rec.visit_id);
2338: l_task_rec.visit_task_number := l_task_number;
2339: END IF;
2340: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: ENDS
2341:

Line 2431: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Create

2427:
2428: ------------------------- finish -------------------------------
2429:
2430: -- salogan added for supplier warranty starts
2431: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Create
2432: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Create(
2433: p_task_id => l_task_rec.visit_task_id,
2434: p_instance_id => l_task_rec.instance_id,
2435: x_warranty_entl_tbl => l_entl_rec_tbl);

Line 2432: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Create(

2428: ------------------------- finish -------------------------------
2429:
2430: -- salogan added for supplier warranty starts
2431: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Create
2432: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Create(
2433: p_task_id => l_task_rec.visit_task_id,
2434: p_instance_id => l_task_rec.instance_id,
2435: x_warranty_entl_tbl => l_entl_rec_tbl);
2436:

Line 2512: AHL_VWP_RULES_PVT.update_visit_task_flag(

2508: select VISIT_TASK_NUMBER INTO p_x_task_rec.Visit_Task_Number from AHL_VISIT_TASKS_B where VISIT_TASK_ID = p_x_task_rec.Visit_Task_ID;
2509:
2510: IF (c_visit_rec.Any_Task_Chg_Flag = 'N') THEN
2511:
2512: AHL_VWP_RULES_PVT.update_visit_task_flag(
2513: p_visit_id =>c_visit_rec.visit_id,
2514: p_flag =>'Y',
2515: x_return_status =>x_return_status);
2516:

Line 2626: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

2622: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
2623: p_commit IN VARCHAR2 := Fnd_Api.g_false,
2624: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
2625: p_module_type IN VARCHAR2 := 'JSP',
2626: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
2627: x_return_status OUT NOCOPY VARCHAR2,
2628: x_msg_count OUT NOCOPY NUMBER,
2629: x_msg_data OUT NOCOPY VARCHAR2
2630: )

Line 2637: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;

2633: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Summary_Task';
2634: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
2635:
2636: -- Local variables defined for the procedure
2637: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;
2638: l_msg_data VARCHAR2(2000);
2639: l_item_name VARCHAR2(40);
2640: l_rowid VARCHAR2(30);
2641: l_return_status VARCHAR2(1);

Line 2734: 'Calling AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id ');

2730: IF (l_task_rec.dept_name IS NOT NULL AND l_task_rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
2731: IF (l_log_statement >= l_log_current_level) THEN
2732: fnd_log.string(l_log_statement,
2733: L_DEBUG_KEY,
2734: 'Calling AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id ');
2735: END IF;
2736: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
2737: (p_organization_id => c_visit_rec.organization_id,
2738: p_dept_name => l_task_rec.dept_name,

Line 2736: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

2732: fnd_log.string(l_log_statement,
2733: L_DEBUG_KEY,
2734: 'Calling AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id ');
2735: END IF;
2736: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
2737: (p_organization_id => c_visit_rec.organization_id,
2738: p_dept_name => l_task_rec.dept_name,
2739: p_department_id => NULL,
2740: x_department_id => l_department_id,

Line 2752: Ahl_vwp_rules_pvt.CHECK_DEPARTMENT_SHIFT

2748: RAISE Fnd_Api.G_EXC_ERROR;
2749: END IF;
2750:
2751: -- Changes for Post 11.5.10 by amagrawa
2752: Ahl_vwp_rules_pvt.CHECK_DEPARTMENT_SHIFT
2753: ( P_DEPT_ID => l_department_id,
2754: X_RETURN_STATUS => l_return_status);
2755:
2756: IF (NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2787: 'Calling AHL_VWP_RULES_PVT.Check_Item_Name_Or_Id ' );

2783:
2784: IF (l_log_statement >= l_log_current_level) THEN
2785: fnd_log.string(l_log_statement,
2786: L_DEBUG_KEY,
2787: 'Calling AHL_VWP_RULES_PVT.Check_Item_Name_Or_Id ' );
2788: END IF;
2789: AHL_VWP_RULES_PVT.Check_Item_Name_Or_Id
2790: (p_item_id => l_Task_rec.inventory_item_id,
2791: p_org_id => l_Task_rec.item_organization_id,

Line 2789: AHL_VWP_RULES_PVT.Check_Item_Name_Or_Id

2785: fnd_log.string(l_log_statement,
2786: L_DEBUG_KEY,
2787: 'Calling AHL_VWP_RULES_PVT.Check_Item_Name_Or_Id ' );
2788: END IF;
2789: AHL_VWP_RULES_PVT.Check_Item_Name_Or_Id
2790: (p_item_id => l_Task_rec.inventory_item_id,
2791: p_org_id => l_Task_rec.item_organization_id,
2792: p_item_name => l_Task_rec.item_name,
2793: x_item_id => l_item_id,

Line 2868: AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id

2864: -- Convert serial number to instance/ serial id
2865: IF (l_Task_rec.serial_number IS NOT NULL AND
2866: l_Task_rec.serial_number <> Fnd_Api.G_MISS_CHAR) THEN
2867:
2868: AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id
2869: (p_item_id => l_Task_rec.inventory_item_id,
2870: p_org_id => l_Task_rec.item_organization_id,
2871: p_serial_id => l_Task_rec.instance_id,
2872: p_serial_number => l_Task_rec.serial_number,

Line 2894: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(l_task_rec.visit_id, l_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN

2890: ', Org ID= ' || l_Task_rec.item_organization_id);
2891: END IF;
2892: /* sowsubra - start
2893: --BEGIN: jeli added for bug 3777720
2894: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(l_task_rec.visit_id, l_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN
2895: --END: jeli added for bug 3777720
2896: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
2897: Fnd_Msg_Pub.ADD;
2898: RAISE Fnd_Api.G_EXC_ERROR;

Line 2917: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID

2913: -- Convert cost parent number to id
2914: IF (l_Task_rec.cost_parent_number IS NOT NULL AND
2915: l_Task_rec.cost_parent_number <> Fnd_Api.G_MISS_NUM ) THEN
2916:
2917: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
2918: (p_visit_task_id => l_Task_rec.cost_parent_id,
2919: p_visit_task_number => l_Task_rec.cost_parent_number,
2920: p_visit_id => l_Task_rec.visit_id,
2921: x_visit_task_id => l_cost_parent_id,

Line 2946: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop

2942: -- To Check for cost parent task id not forming loop
2943: IF (l_Task_rec.cost_parent_id IS NOT NULL AND
2944: l_Task_rec.cost_parent_id <> Fnd_Api.G_MISS_NUM ) THEN
2945:
2946: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop
2947: (p_visit_id => l_Task_rec.visit_id,
2948: p_visit_task_id => l_Task_rec.visit_task_id ,
2949: p_cost_parent_id => l_Task_rec.cost_parent_id
2950: );

Line 2966: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID

2962: -- Convert originating task number to id
2963: IF (l_Task_rec.orginating_task_number IS NOT NULL AND
2964: l_Task_rec.orginating_task_number <> Fnd_Api.G_MISS_NUM ) THEN
2965:
2966: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
2967: (p_visit_task_id => l_Task_rec.originating_task_id,
2968: p_visit_task_number => l_Task_rec.orginating_task_number,
2969: p_visit_id => l_Task_rec.visit_id,
2970: x_visit_task_id => l_originating_task_id,

Line 2995: AHL_VWP_RULES_PVT.Check_Origin_Task_Loop

2991: -- To Check for originating task id not forming loop
2992: IF (l_Task_rec.originating_task_id IS NOT NULL AND
2993: l_Task_rec.originating_task_id <> Fnd_Api.G_MISS_NUM ) THEN
2994:
2995: AHL_VWP_RULES_PVT.Check_Origin_Task_Loop
2996: (p_visit_id => l_Task_rec.visit_id ,
2997: p_visit_task_id => l_Task_rec.visit_task_id ,
2998: p_originating_task_id => l_Task_rec.originating_task_id
2999: );

Line 3041: l_Visit_Task_ID := AHL_VWP_RULES_PVT.Get_Visit_Task_Id();

3037:
3038: -- Check for the ID.
3039: IF l_task_rec.Visit_Task_ID = Fnd_Api.g_miss_num OR l_task_rec.Visit_Task_ID IS NULL THEN
3040: -- Check for the ID.
3041: l_Visit_Task_ID := AHL_VWP_RULES_PVT.Get_Visit_Task_Id();
3042: l_task_rec.visit_task_ID := l_Visit_Task_ID;
3043:
3044: END IF;
3045:

Line 3048: l_task_number := AHL_VWP_RULES_PVT.Get_Visit_Task_Number(l_task_rec.visit_id);

3044: END IF;
3045:
3046: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063 :: Check for the Task Number
3047: IF l_task_rec.visit_task_number = Fnd_Api.g_miss_num OR l_task_rec.visit_task_number IS NULL THEN
3048: l_task_number := AHL_VWP_RULES_PVT.Get_Visit_Task_Number(l_task_rec.visit_id);
3049: l_task_rec.visit_task_number := l_task_number;
3050: END IF;
3051:
3052: IF (l_log_statement >= l_log_current_level) THEN

Line 3153: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Create

3149:
3150: ------------------------- finish -------------------------------
3151:
3152: -- salogan added for supplier warranty starts
3153: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Create
3154: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Create(
3155: p_task_id => l_task_rec.visit_task_id,
3156: p_instance_id => l_task_rec.instance_id,
3157: x_warranty_entl_tbl => l_entl_rec_tbl);

Line 3154: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Create(

3150: ------------------------- finish -------------------------------
3151:
3152: -- salogan added for supplier warranty starts
3153: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Create
3154: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Create(
3155: p_task_id => l_task_rec.visit_task_id,
3156: p_instance_id => l_task_rec.instance_id,
3157: x_warranty_entl_tbl => l_entl_rec_tbl);
3158:

Line 3230: AHL_VWP_RULES_PVT.update_visit_task_flag(

3226: --p_x_task_rec.Visit_Task_Number := l_task_rec.Visit_Task_Number;
3227: select VISIT_TASK_NUMBER INTO p_x_task_rec.Visit_Task_Number from AHL_VISIT_TASKS_B where VISIT_TASK_ID = p_x_task_rec.Visit_Task_ID;
3228:
3229: IF c_visit_rec.Any_Task_Chg_Flag='N' THEN
3230: AHL_VWP_RULES_PVT.update_visit_task_flag(
3231: p_visit_id =>c_visit_rec.visit_id,
3232: p_flag =>'Y',
3233: x_return_status =>x_return_status);
3234: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3312: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

3308: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
3309: p_commit IN VARCHAR2 := Fnd_Api.g_false,
3310: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
3311: p_module_type IN VARCHAR2 := 'JSP',
3312: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
3313: x_return_status OUT NOCOPY VARCHAR2,
3314: x_msg_count OUT NOCOPY NUMBER,
3315: x_msg_data OUT NOCOPY VARCHAR2
3316: )

Line 3323: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;

3319: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Task';
3320: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
3321:
3322: -- local variables defined for the procedure
3323: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;
3324: l_msg_data VARCHAR2(2000);
3325: l_return_status VARCHAR2(1);
3326: l_msg_count NUMBER;
3327: l_visit_end_date DATE;

Line 3428: AHL_VWP_RULES_PVT.Validate_Past_Task_Dates ( p_task_rec => l_Task_rec,

3424: Fnd_Msg_Pub.ADD;
3425: RAISE FND_API.G_EXC_ERROR;
3426: END IF;
3427: -- Validate past dates against visit stages, task hierarchy and cost parent hierarchy
3428: AHL_VWP_RULES_PVT.Validate_Past_Task_Dates ( p_task_rec => l_Task_rec,
3429: x_return_status => l_return_status);
3430: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3431: IF (l_log_statement >= l_log_current_level) THEN
3432: fnd_log.string(l_log_statement,

Line 3434: 'Returned success from AHL_VWP_RULES_PVT.Validate_Past_Task_Dates');

3430: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
3431: IF (l_log_statement >= l_log_current_level) THEN
3432: fnd_log.string(l_log_statement,
3433: L_DEBUG_KEY,
3434: 'Returned success from AHL_VWP_RULES_PVT.Validate_Past_Task_Dates');
3435: END IF;
3436: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3437: RAISE FND_API.G_EXC_ERROR;
3438: ELSE

Line 3641: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

3637: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
3638: p_commit IN VARCHAR2:= FND_API.G_FALSE,
3639: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3640: p_module_type IN VARCHAR2:= 'JSP',
3641: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
3642: x_return_status OUT NOCOPY VARCHAR2,
3643: x_msg_count OUT NOCOPY NUMBER,
3644: x_msg_data OUT NOCOPY VARCHAR2
3645:

Line 3714: l_Task_rec AHL_VWP_RULES_PVT.Task_Rec_Type default p_x_task_rec;

3710: FROM Ahl_Visits_VL
3711: WHERE VISIT_ID = p_visit_id;
3712:
3713: l_Visit_rec c_Visit%ROWTYPE;
3714: l_Task_rec AHL_VWP_RULES_PVT.Task_Rec_Type default p_x_task_rec;
3715:
3716: Cursor c_visit_task_det(p_visit_task_id in number)
3717: is
3718: Select ROW_ID ,

Line 3827: AHL_VWP_RULES_PVT.Validate_Service_Type(

3823: RAISE Fnd_Api.g_exc_unexpected_error;
3824: END IF;
3825:
3826: -- PRAKKUM :: FP:PIE :: 13-OCT-2010 :: validate Service Type attributes, before calling any other update API
3827: AHL_VWP_RULES_PVT.Validate_Service_Type(
3828: p_service_type => l_task_rec.service_type,
3829: p_module_type => p_module_type,
3830: p_unit_effectivity_id => l_task_rec.unit_effectivity_id,
3831: p_x_service_type_code => l_task_rec.service_type_code

Line 3876: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

3872:
3873: -- Code added to make sure that department name to id conversion takes place
3874: -- Irrespective of above API Being Called.
3875: IF (l_task_rec.dept_name IS NOT NULL AND l_task_rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
3876: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
3877: (p_organization_id => l_visit_rec.organization_id,
3878: p_dept_name => l_task_rec.dept_name,
3879: p_department_id => NULL,
3880: x_department_id => l_task_rec.department_id,

Line 3891: Ahl_vwp_rules_pvt.CHECK_DEPARTMENT_SHIFT

3887: RAISE Fnd_Api.G_EXC_ERROR;
3888: END IF;
3889:
3890: -- Changes for Post 11.5.10 by cxcheng
3891: Ahl_vwp_rules_pvt.CHECK_DEPARTMENT_SHIFT
3892: ( P_DEPT_ID => l_task_rec.department_id,
3893: X_RETURN_STATUS => l_return_status);
3894:
3895: IF (NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS) THEN

Line 4123: 'Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID ');

4119:
4120: IF (l_log_statement >= l_log_current_level)THEN
4121: fnd_log.string(l_log_statement,
4122: L_DEBUG_KEY,
4123: 'Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID ');
4124: END IF;
4125:
4126: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
4127: (p_visit_task_id => p_x_task_rec.cost_parent_id,

Line 4126: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID

4122: L_DEBUG_KEY,
4123: 'Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID ');
4124: END IF;
4125:
4126: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
4127: (p_visit_task_id => p_x_task_rec.cost_parent_id,
4128: p_visit_task_number => p_x_task_rec.cost_parent_number,
4129: p_visit_id => p_x_task_rec.visit_id,
4130: x_visit_task_id => p_x_task_rec.cost_parent_id,

Line 4147: 'Before Calling AHL_VWP_RULES_PVT.Update_Visit_Task_Flag ' ||

4143: IF l_visit_rec.any_task_chg_flag = 'N' THEN
4144: IF (l_log_statement >= l_log_current_level)THEN
4145: fnd_log.string(l_log_statement,
4146: L_DEBUG_KEY,
4147: 'Before Calling AHL_VWP_RULES_PVT.Update_Visit_Task_Flag ' ||
4148: 'Any_task_chg_flag = ' ||l_visit_rec.any_task_chg_flag);
4149: END IF;
4150:
4151: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

Line 4151: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

4147: 'Before Calling AHL_VWP_RULES_PVT.Update_Visit_Task_Flag ' ||
4148: 'Any_task_chg_flag = ' ||l_visit_rec.any_task_chg_flag);
4149: END IF;
4150:
4151: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag
4152: (p_visit_id => l_old_Task_rec.visit_id,
4153: p_flag => 'Y',
4154: x_return_status => x_return_status);
4155:

Line 4159: 'After Calling AHL_VWP_RULES_PVT.Update_Visit_Task_Flag, Return Status = ' ||x_return_status);

4155:
4156: IF (l_log_statement >= l_log_current_level)THEN
4157: fnd_log.string(l_log_statement,
4158: L_DEBUG_KEY,
4159: 'After Calling AHL_VWP_RULES_PVT.Update_Visit_Task_Flag, Return Status = ' ||x_return_status);
4160: END IF;
4161:
4162: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4163: RAISE FND_API.G_EXC_ERROR;

Line 4239: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

4235: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
4236: p_commit IN VARCHAR2:= FND_API.G_FALSE,
4237: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4238: p_module_type IN VARCHAR2:= 'JSP',
4239: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
4240: x_return_status OUT NOCOPY VARCHAR2,
4241: x_msg_count OUT NOCOPY NUMBER,
4242: x_msg_data OUT NOCOPY VARCHAR2
4243:

Line 4249: l_Task_rec AHL_VWP_RULES_PVT.Task_Rec_Type default p_x_task_rec;

4245:
4246: L_API_VERSION CONSTANT NUMBER := 1.0;
4247: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Tasks_in_Production';
4248: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
4249: l_Task_rec AHL_VWP_RULES_PVT.Task_Rec_Type default p_x_task_rec;
4250:
4251: Cursor c_visit_task_det(p_visit_task_id in number)
4252: is
4253: Select ROW_ID ,

Line 4363: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID

4359:
4360: IF (l_Task_rec.cost_parent_number IS NOT NULL AND
4361: l_Task_rec.cost_parent_number <> Fnd_Api.G_MISS_NUM ) THEN
4362:
4363: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
4364: (p_visit_task_id => l_Task_rec.cost_parent_id,
4365: p_visit_task_number => l_Task_rec.cost_parent_number,
4366: p_visit_id => l_Task_rec.visit_id,
4367: x_visit_task_id => l_cost_parent_id,

Line 4390: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop

4386: -- To Check for cost parent task id not forming loop
4387: IF (l_Task_rec.cost_parent_id IS NOT NULL AND
4388: l_Task_rec.cost_parent_id <> Fnd_Api.G_MISS_NUM ) THEN
4389:
4390: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop
4391: (p_visit_id => l_Task_rec.visit_id,
4392: p_visit_task_id => l_Task_rec.visit_task_id ,
4393: p_cost_parent_id => l_Task_rec.cost_parent_id
4394: );

Line 4546: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

4542: FETCH c_any_task_flg INTO l_any_task_chg_flag;
4543: CLOSE c_any_task_flg;
4544:
4545: IF l_any_task_chg_flag = 'N' THEN
4546: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag
4547: (p_visit_id => l_old_Task_rec.visit_id,
4548: p_flag => 'Y',
4549: x_return_status => x_return_status);
4550: END IF;

Line 4616: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

4612: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
4613: p_commit IN VARCHAR2 := Fnd_Api.g_false,
4614: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
4615: p_module_type IN VARCHAR2 := 'JSP',
4616: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
4617: x_return_status OUT NOCOPY VARCHAR2,
4618: x_msg_count OUT NOCOPY NUMBER,
4619: x_msg_data OUT NOCOPY VARCHAR2
4620: )

Line 4626: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;

4622: L_API_VERSION CONSTANT NUMBER := 1.0;
4623: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Unassociated_Task';
4624: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
4625: -- local variables defined for the procedure
4626: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;
4627: l_return_status VARCHAR2(1);
4628: l_msg_data VARCHAR2(2000);
4629: l_msg_count NUMBER;
4630: l_serial_ID NUMBER;

Line 4706: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

4702: -- For DEPARTMENT
4703: -- Convert department name to department id
4704: IF (l_task_rec.dept_name IS NOT NULL AND l_task_rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
4705:
4706: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
4707: (p_organization_id => c_visit_rec.organization_id,
4708: p_dept_name => l_task_rec.dept_name,
4709: p_department_id => NULL,
4710: x_department_id => l_department_id,

Line 4742: ' Calling AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id' );

4738:
4739: IF (l_log_statement >= l_log_current_level) THEN
4740: fnd_log.string(l_log_statement,
4741: L_DEBUG_KEY,
4742: ' Calling AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id' );
4743: END IF;
4744:
4745: AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id
4746: (p_item_id => l_Task_rec.inventory_item_id,

Line 4745: AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id

4741: L_DEBUG_KEY,
4742: ' Calling AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id' );
4743: END IF;
4744:
4745: AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id
4746: (p_item_id => l_Task_rec.inventory_item_id,
4747: p_org_id => l_Task_rec.item_organization_id,
4748: p_serial_id => l_Task_rec.instance_id,
4749: p_serial_number => l_Task_rec.serial_number,

Line 4774: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(l_task_rec.visit_id, l_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN

4770: /* sowsubra - start
4771: IF c_Visit_rec.item_instance_id IS NOT NULL THEN
4772:
4773: --BEGIN: jeli added for bug 3777720
4774: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(l_task_rec.visit_id, l_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN
4775: --END: jeli added for bug 3777720
4776: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
4777: Fnd_Msg_Pub.ADD;
4778: RAISE Fnd_Api.G_EXC_ERROR;

Line 4798: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID

4794: -- Convert cost parent number to id
4795: IF (l_Task_rec.cost_parent_number IS NOT NULL AND
4796: l_Task_rec.cost_parent_number <> Fnd_Api.G_MISS_NUM ) THEN
4797:
4798: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
4799: (p_visit_task_id => l_Task_rec.cost_parent_id,
4800: p_visit_task_number => l_Task_rec.cost_parent_number,
4801: p_visit_id => l_Task_rec.visit_id,
4802: x_visit_task_id => l_cost_parent_id,

Line 4828: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop

4824: -- To Check for cost parent task id not forming loop
4825: IF (l_Task_rec.cost_parent_id IS NOT NULL AND
4826: l_Task_rec.cost_parent_id <> Fnd_Api.G_MISS_NUM ) THEN
4827:
4828: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop
4829: (p_visit_id => l_Task_rec.visit_id,
4830: p_visit_task_id => l_Task_rec.visit_task_id ,
4831: p_cost_parent_id => l_Task_rec.cost_parent_id
4832: );

Line 4852: ' Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID');

4848:
4849: IF (l_log_statement >= l_log_current_level) THEN
4850: fnd_log.string(l_log_statement,
4851: L_DEBUG_KEY,
4852: ' Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID');
4853: END IF;
4854:
4855: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
4856: (p_visit_task_id => l_Task_rec.originating_task_id,

Line 4855: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID

4851: L_DEBUG_KEY,
4852: ' Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID');
4853: END IF;
4854:
4855: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
4856: (p_visit_task_id => l_Task_rec.originating_task_id,
4857: p_visit_task_number => l_Task_rec.orginating_task_number,
4858: p_visit_id => l_Task_rec.visit_id,
4859: x_visit_task_id => l_originating_task_id,

Line 4885: AHL_VWP_RULES_PVT.Check_Origin_Task_Loop

4881: -- To Check for originating task id not forming loop
4882: IF (l_Task_rec.originating_task_id IS NOT NULL AND
4883: l_Task_rec.originating_task_id <> Fnd_Api.G_MISS_NUM ) THEN
4884:
4885: AHL_VWP_RULES_PVT.Check_Origin_Task_Loop
4886: (p_visit_id => l_Task_rec.visit_id ,
4887: p_visit_task_id => l_Task_rec.visit_task_id ,
4888: p_originating_task_id => l_Task_rec.originating_task_id
4889: );

Line 5075: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update

5071: 'After Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');
5072: END IF;
5073:
5074: --salogan added for supplier warranty starts
5075: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update
5076: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update(
5077: p_task_rec => l_task_rec,
5078: x_warranty_entl_tbl => l_entl_rec_tbl);
5079:

Line 5076: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update(

5072: END IF;
5073:
5074: --salogan added for supplier warranty starts
5075: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update
5076: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update(
5077: p_task_rec => l_task_rec,
5078: x_warranty_entl_tbl => l_entl_rec_tbl);
5079:
5080: IF (l_log_statement >= l_log_current_level) THEN

Line 5195: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag

5191:
5192: END IF; -- Start_date_time check.
5193:
5194: IF c_visit_rec.any_task_chg_flag = 'N' THEN
5195: AHL_VWP_RULES_PVT.Update_Visit_Task_Flag
5196: (p_visit_id => l_task_rec.visit_id,
5197: p_flag => 'Y',
5198: x_return_status => x_return_status);
5199: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 5271: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,

5267: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
5268: p_commit IN VARCHAR2 := Fnd_Api.g_false,
5269: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
5270: p_module_type IN VARCHAR2 := 'JSP',
5271: p_x_task_rec IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type,
5272: x_return_status OUT NOCOPY VARCHAR2,
5273: x_msg_count OUT NOCOPY NUMBER,
5274: x_msg_data OUT NOCOPY VARCHAR2
5275: )

Line 5282: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;

5278: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Summary_Task';
5279: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
5280:
5281: -- local variables defined for the procedure
5282: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;
5283: l_return_status VARCHAR2(1);
5284: l_msg_data VARCHAR2(2000);
5285:
5286: l_msg_count NUMBER;

Line 5360: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id

5356: -- For DEPARTMENT
5357: -- Convert department name to department id
5358: IF (l_task_rec.dept_name IS NOT NULL AND l_task_rec.dept_name <> Fnd_Api.G_MISS_CHAR ) THEN
5359:
5360: AHL_VWP_RULES_PVT.Check_Dept_Desc_Or_Id
5361: (p_organization_id => c_visit_rec.organization_id,
5362: p_dept_name => l_task_rec.dept_name,
5363: p_department_id => NULL,
5364: x_department_id => l_department_id,

Line 5401: AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id

5397: -- Convert serial number to instance/ serial id
5398: IF (l_Task_rec.serial_number IS NOT NULL AND
5399: l_Task_rec.serial_number <> Fnd_Api.G_MISS_CHAR) THEN
5400:
5401: AHL_VWP_RULES_PVT.Check_Serial_Name_Or_Id
5402: (p_item_id => l_Task_rec.inventory_item_id,
5403: p_org_id => l_Task_rec.item_organization_id,
5404: p_serial_id => l_Task_rec.instance_id,
5405: p_serial_number => l_Task_rec.serial_number,

Line 5428: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(l_task_rec.visit_id, l_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN

5424: ': Before UC Item Org ID= ' || l_Task_rec.item_organization_id);
5425: END IF;
5426: /* sowsubra - start
5427: --BEGIN: jeli added for bug 3777720
5428: IF (AHL_VWP_RULES_PVT.instance_in_config_tree(l_task_rec.visit_id, l_task_rec.instance_id) = FND_API.G_RET_STS_ERROR) THEN
5429: --END: jeli added for bug 3777720
5430: Fnd_Message.SET_NAME('AHL','AHL_VWP_TASK_SERIAL');
5431: Fnd_Msg_Pub.ADD;
5432: RAISE Fnd_Api.G_EXC_ERROR;

Line 5465: ' Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID');

5461:
5462: IF (l_log_statement >= l_log_current_level) THEN
5463: fnd_log.string(l_log_statement,
5464: L_DEBUG_KEY,
5465: ' Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID');
5466: END IF;
5467:
5468: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
5469: (p_visit_task_id => l_Task_rec.cost_parent_id,

Line 5468: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID

5464: L_DEBUG_KEY,
5465: ' Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID');
5466: END IF;
5467:
5468: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
5469: (p_visit_task_id => l_Task_rec.cost_parent_id,
5470: p_visit_task_number => l_Task_rec.cost_parent_number,
5471: p_visit_id => l_Task_rec.visit_id,
5472: x_visit_task_id => l_cost_parent_id,

Line 5493: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop

5489: -- To Check for cost parent task id not forming loop
5490: IF (l_Task_rec.cost_parent_id IS NOT NULL AND
5491: l_Task_rec.cost_parent_id <> Fnd_Api.G_MISS_NUM ) THEN
5492:
5493: AHL_VWP_RULES_PVT.Check_Cost_Parent_Loop
5494: (p_visit_id => l_Task_rec.visit_id,
5495: p_visit_task_id => l_Task_rec.visit_task_id ,
5496: p_cost_parent_id => l_Task_rec.cost_parent_id
5497: );

Line 5522: ' Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID');

5518:
5519: IF (l_log_statement >= l_log_current_level) THEN
5520: fnd_log.string(l_log_statement,
5521: L_DEBUG_KEY,
5522: ' Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID');
5523: END IF;
5524:
5525: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
5526: (p_visit_task_id => l_Task_rec.originating_task_id,

Line 5525: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID

5521: L_DEBUG_KEY,
5522: ' Calling AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID');
5523: END IF;
5524:
5525: AHL_VWP_RULES_PVT.Check_Visit_Task_Number_OR_ID
5526: (p_visit_task_id => l_Task_rec.originating_task_id,
5527: p_visit_task_number => l_Task_rec.orginating_task_number,
5528: p_visit_id => l_Task_rec.visit_id,
5529: x_visit_task_id => l_originating_task_id,

Line 5556: AHL_VWP_RULES_PVT.Check_Origin_Task_Loop

5552: -- To Check for originating task id not forming loop
5553: IF (l_Task_rec.originating_task_id IS NOT NULL AND
5554: l_Task_rec.originating_task_id <> Fnd_Api.G_MISS_NUM ) THEN
5555:
5556: AHL_VWP_RULES_PVT.Check_Origin_Task_Loop
5557: (p_visit_id => l_Task_rec.visit_id ,
5558: p_visit_task_id => l_Task_rec.visit_task_id ,
5559: p_originating_task_id => l_Task_rec.originating_task_id
5560: );

Line 5722: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update

5718: 'After Calling Ahl_Visit_Tasks_Pkg.UPDATE_ROW');
5719: END IF;
5720:
5721: --salogan added for supplier warranty starts
5722: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update
5723: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update(
5724: p_task_rec => l_task_rec,
5725: x_warranty_entl_tbl => l_entl_rec_tbl);
5726:

Line 5723: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update(

5719: END IF;
5720:
5721: --salogan added for supplier warranty starts
5722: -- calling AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update
5723: AHL_VWP_RULES_PVT.Get_Warranty_Rec_for_Update(
5724: p_task_rec => l_task_rec,
5725: x_warranty_entl_tbl => l_entl_rec_tbl);
5726:
5727: IF (l_log_statement >= l_log_current_level) THEN

Line 6319: AHL_VWP_RULES_PVT.update_visit_task_flag(

6315:
6316: -- Bug fix #4187213
6317: -- yazhou 16-Feb-2005
6318: IF c_visit_rec.Any_Task_Chg_Flag='N' THEN
6319: AHL_VWP_RULES_PVT.update_visit_task_flag(
6320: p_visit_id =>c_visit_rec.visit_id,
6321: p_flag =>'Y',
6322: x_return_status =>x_return_status);
6323:

Line 6603: AHL_VWP_RULES_PVT.Update_Cost_Origin_Task

6599: l_visit_id := c_task_rec.visit_id;
6600: l_task_id := p_Visit_Task_ID;
6601:
6602: --To update all tasks which have the deleting task as cost or originating task
6603: AHL_VWP_RULES_PVT.Update_Cost_Origin_Task
6604: (p_visit_task_id =>l_task_Id,
6605: x_return_status =>x_return_status
6606: );
6607:

Line 7088: AHL_VWP_RULES_PVT.Update_Cost_Origin_Task

7084: ' Calling Update_Cost_Origin_Task, task id : '||l_task_ID );
7085: END IF;
7086:
7087: -- To update all tasks which have the deleting task as cost or originating task
7088: AHL_VWP_RULES_PVT.Update_Cost_Origin_Task
7089: (
7090: p_visit_task_id =>l_task_ID,
7091: x_return_status =>x_return_status
7092: );

Line 7708: ' Calling AHL_VWP_RULES_PVT.Update_Cost_Origin_Task');

7704:
7705: IF (l_log_statement >= l_log_current_level)THEN
7706: fnd_log.string(l_log_statement,
7707: L_DEBUG_KEY,
7708: ' Calling AHL_VWP_RULES_PVT.Update_Cost_Origin_Task');
7709: END IF;
7710:
7711: -- To update all tasks which have the deleting task as cost or originating task
7712: AHL_VWP_RULES_PVT.Update_Cost_Origin_Task

Line 7712: AHL_VWP_RULES_PVT.Update_Cost_Origin_Task

7708: ' Calling AHL_VWP_RULES_PVT.Update_Cost_Origin_Task');
7709: END IF;
7710:
7711: -- To update all tasks which have the deleting task as cost or originating task
7712: AHL_VWP_RULES_PVT.Update_Cost_Origin_Task
7713: (
7714: p_visit_task_id =>l_task_ID,
7715: x_return_status =>x_return_status
7716: );

Line 8008: 'Before AHL_VWP_RULES_PVT.Update_Cost_Origin_Task Call');

8004:
8005: IF (l_log_statement >= l_log_current_level) THEN
8006: fnd_log.string(l_log_statement,
8007: L_DEBUG_KEY,
8008: 'Before AHL_VWP_RULES_PVT.Update_Cost_Origin_Task Call');
8009: END IF;
8010:
8011: -- To update all tasks which have the deleting task as cost or originating task
8012: AHL_VWP_RULES_PVT.Update_Cost_Origin_Task

Line 8012: AHL_VWP_RULES_PVT.Update_Cost_Origin_Task

8008: 'Before AHL_VWP_RULES_PVT.Update_Cost_Origin_Task Call');
8009: END IF;
8010:
8011: -- To update all tasks which have the deleting task as cost or originating task
8012: AHL_VWP_RULES_PVT.Update_Cost_Origin_Task
8013: (
8014: p_visit_task_id =>l_task_ID,
8015: x_return_status =>x_return_status
8016: );

Line 8402: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

8398: p_api_version IN NUMBER,
8399: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
8400: p_commit IN VARCHAR2 := Fnd_Api.g_false,
8401: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
8402: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
8403:
8404: x_return_status OUT NOCOPY VARCHAR2,
8405: x_msg_count OUT NOCOPY NUMBER,
8406: x_msg_data OUT NOCOPY VARCHAR2

Line 8513: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

8509: -- PURPOSE
8510: --
8511: ---------------------------------------------------------------------
8512: PROCEDURE Check_Task_Items (
8513: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
8514: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
8515:
8516: x_return_status OUT NOCOPY VARCHAR2
8517: )

Line 8579: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

8575: --
8576: ---------------------------------------------------------------------
8577: /*
8578: PROCEDURE Complete_Visit_Task_Rec (
8579: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
8580: x_complete_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
8581: )
8582: IS
8583: CURSOR c_Visit_Task IS

Line 8580: x_complete_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type

8576: ---------------------------------------------------------------------
8577: /*
8578: PROCEDURE Complete_Visit_Task_Rec (
8579: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
8580: x_complete_rec OUT NOCOPY AHL_VWP_RULES_PVT.Task_Rec_Type
8581: )
8582: IS
8583: CURSOR c_Visit_Task IS
8584: SELECT *

Line 8618: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

8614: -- PURPOSE
8615: --
8616: ---------------------------------------------------------------------
8617: PROCEDURE Check_Visit_Task_Req_Items (
8618: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
8619: -- Added by rnahata for Issue 105 - validation mode parameter
8620: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
8621: x_return_status OUT NOCOPY VARCHAR2
8622: )

Line 8728: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,

8724: -- PURPOSE
8725: --
8726: ---------------------------------------------------------------------
8727: PROCEDURE Check_Visit_Task_UK_Items (
8728: p_task_rec IN AHL_VWP_RULES_PVT.Task_Rec_Type,
8729: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
8730: x_return_status OUT NOCOPY VARCHAR2
8731: )
8732: IS

Line 8792: p_x_task_tbl IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Tbl_Type,

8788: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
8789: p_commit IN VARCHAR2 := Fnd_Api.g_false,
8790: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
8791: p_module_type IN VARCHAR2 := 'JSP',
8792: p_x_task_tbl IN OUT NOCOPY AHL_VWP_RULES_PVT.Task_Tbl_Type,
8793: x_return_status OUT NOCOPY VARCHAR2,
8794: x_msg_count OUT NOCOPY NUMBER,
8795: x_msg_data OUT NOCOPY VARCHAR2
8796: )

Line 8805: l_task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type := p_x_task_tbl;

8801: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
8802: l_msg_count NUMBER;
8803: l_msg_data VARCHAR2(2000);
8804: l_return_status VARCHAR2(1);
8805: l_task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type := p_x_task_tbl;
8806: -- Begin changes by rnahata for Issue 105
8807: l_instance_qty NUMBER := 0;
8808: l_instance_id NUMBER := 0;
8809: l_task_type VARCHAR2(30);

Line 8840: l_task_data AHL_VWP_RULES_PVT.Task_Tbl_Type := p_x_task_tbl;

8836: l_rts_wip_id NUMBER;
8837: l_rpr_batch_task_id NUMBER;
8838: l_target_qty NUMBER := 0;
8839: l_summary_task_id NUMBER;
8840: l_task_data AHL_VWP_RULES_PVT.Task_Tbl_Type := p_x_task_tbl;
8841: l_repair_batch_name VARCHAR2(100);
8842: l_task_status_code VARCHAR2(30);
8843: l_is_cost_parent_setting_done BOOLEAN;
8844: l_repair_batch_task_id NUMBER;

Line 9215: 'Before Calling AHL_VWP_RULES_PVT.Handle_Task_Dependency');

9211: -- We are making this call after AHL_VWP_TIMES_PVT.Calculate_Task_Times, so that by this point of time, we can access all the already validated task rules and task related info from the DB.
9212: IF (l_log_statement >= l_log_current_level) THEN
9213: fnd_log.string(l_log_statement,
9214: L_DEBUG_KEY,
9215: 'Before Calling AHL_VWP_RULES_PVT.Handle_Task_Dependency');
9216: END IF;
9217: AHL_VWP_RULES_PVT.Handle_Task_Dependency(p_api_version => 1.0,
9218: p_init_msg_list => Fnd_Api.G_FALSE,
9219: p_commit => Fnd_Api.G_FALSE,

Line 9217: AHL_VWP_RULES_PVT.Handle_Task_Dependency(p_api_version => 1.0,

9213: fnd_log.string(l_log_statement,
9214: L_DEBUG_KEY,
9215: 'Before Calling AHL_VWP_RULES_PVT.Handle_Task_Dependency');
9216: END IF;
9217: AHL_VWP_RULES_PVT.Handle_Task_Dependency(p_api_version => 1.0,
9218: p_init_msg_list => Fnd_Api.G_FALSE,
9219: p_commit => Fnd_Api.G_FALSE,
9220: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
9221: p_visit_id => c_visit_rec.VISIT_ID,

Line 9230: 'After Calling AHL_VWP_RULES_PVT.Handle_Task_Dependency. Return Status = ' || l_return_status );

9226:
9227: IF (l_log_statement >= l_log_current_level) THEN
9228: fnd_log.string(l_log_statement,
9229: L_DEBUG_KEY,
9230: 'After Calling AHL_VWP_RULES_PVT.Handle_Task_Dependency. Return Status = ' || l_return_status );
9231: END IF;
9232: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
9233: x_msg_count := l_msg_count;
9234: l_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 9678: l_Task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type;

9674:
9675: l_instance_qty NUMBER := 0;
9676: -- End changes by rnahata for Issue 105
9677:
9678: l_Task_tbl AHL_VWP_RULES_PVT.Task_Tbl_Type;
9679:
9680: BEGIN
9681: --------------------- initialize -----------------------
9682: SAVEPOINT associate_default_mrs;

Line 10093: l_visit_task_id := AHL_VWP_RULES_PVT.Get_Visit_Task_Id();

10089: RAISE FND_API.G_EXC_ERROR;
10090: END IF;
10091: CLOSE Get_Visit_Details;
10092:
10093: l_visit_task_id := AHL_VWP_RULES_PVT.Get_Visit_Task_Id();
10094: l_visit_task_number := AHL_VWP_RULES_PVT.Get_Visit_Task_Number(P_VISIT_ID);
10095:
10096: -- TCHIMIRA :: 04-May-2012 :: Bug 14009280 :: START
10097: IF p_stage_id IS NOT NULL THEN

Line 10094: l_visit_task_number := AHL_VWP_RULES_PVT.Get_Visit_Task_Number(P_VISIT_ID);

10090: END IF;
10091: CLOSE Get_Visit_Details;
10092:
10093: l_visit_task_id := AHL_VWP_RULES_PVT.Get_Visit_Task_Id();
10094: l_visit_task_number := AHL_VWP_RULES_PVT.Get_Visit_Task_Number(P_VISIT_ID);
10095:
10096: -- TCHIMIRA :: 04-May-2012 :: Bug 14009280 :: START
10097: IF p_stage_id IS NOT NULL THEN
10098: OPEN get_stage_dates (p_stage_id);