APPS.AHL_FMP_MR_INTERVAL_PVT dependencies on AHL_FMP_COMMON_PVT

Line 166: l_mr_status_code :=AHL_FMP_COMMON_PVT.check_mr_status(p_mr_header_id);

162: l_pm_install_flag:= 'N';
163: END IF;
164:
165: --check if mr is terminated and get the mr status.
166: l_mr_status_code :=AHL_FMP_COMMON_PVT.check_mr_status(p_mr_header_id);
167: IF l_mr_status_code IS NULL THEN
168: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR' );
169: FND_MSG_PUB.add;
170: x_return_status := FND_API.G_RET_STS_ERROR;

Line 178: AHL_FMP_COMMON_PVT.validate_mr_pm_status

174: -- Check if the Maintenance Requirement is in Updatable status based on the pm,super user,mrstatus
175: IF ( l_pm_install_flag = 'Y' AND
176: p_super_user ='Y' AND
177: l_mr_status_code = 'COMPLETE') THEN
178: AHL_FMP_COMMON_PVT.validate_mr_pm_status
179: (
180: x_return_status => l_return_status,
181: x_msg_data => l_msg_data,
182: p_mr_header_id => p_mr_header_id

Line 185: AHL_FMP_COMMON_PVT.validate_mr_status

181: x_msg_data => l_msg_data,
182: p_mr_header_id => p_mr_header_id
183: );
184: ELSE
185: AHL_FMP_COMMON_PVT.validate_mr_status
186: (
187: x_return_status => l_return_status,
188: x_msg_data => l_msg_data,
189: p_mr_header_id => p_mr_header_id

Line 211: AHL_FMP_COMMON_PVT.validate_mr_effectivity

207: RETURN;
208: END IF;
209:
210: -- Check if the Maintenance Requirement Effectivity exists
211: AHL_FMP_COMMON_PVT.validate_mr_effectivity
212: (
213: x_return_status => l_return_status,
214: x_msg_data => l_msg_data,
215: p_mr_effectivity_id => p_threshold_rec.mr_effectivity_id,

Line 226: l_mr_type_code :=AHL_FMP_COMMON_PVT.check_mr_type(p_mr_header_id);

222: x_return_status := l_return_status;
223: RETURN;
224: END IF;
225:
226: l_mr_type_code :=AHL_FMP_COMMON_PVT.check_mr_type(p_mr_header_id);
227:
228: -- Check if atleast one record is passed in p_interval_tbl or p_threshold_rec is passed
229: IF ( p_interval_tbl.count < 1 AND
230: ( p_threshold_rec.threshold_date IS NULL OR

Line 271: AHL_FMP_COMMON_PVT.validate_mr_type_activity

267: p_super_user ='Y' AND
268: p_interval_tbl(i).dml_operation = 'D' AND
269: l_mr_status_code = 'COMPLETE' AND
270: l_mr_type_code ='ACTIVITY')THEN
271: AHL_FMP_COMMON_PVT.validate_mr_type_activity
272: (
273: x_return_status => l_return_status,
274: x_msg_data => l_msg_data,
275: p_effectivity_id => p_threshold_rec.MR_EFFECTIVITY_ID,

Line 292: AHL_FMP_COMMON_PVT.validate_mr_type_program

288: p_super_user ='Y' AND
289: p_interval_tbl(i).dml_operation = 'D' AND
290: l_mr_status_code = 'COMPLETE' AND
291: l_mr_type_code ='PROGRAM') THEN
292: AHL_FMP_COMMON_PVT.validate_mr_type_program
293: (
294: x_return_status => l_return_status,
295: x_msg_data => l_msg_data,
296: p_mr_header_id => p_mr_header_id,

Line 389: AHL_FMP_COMMON_PVT.validate_counter_template

385: l_position_ref_meaning;
386:
387: CLOSE get_item_effectivity;
388:
389: AHL_FMP_COMMON_PVT.validate_counter_template
390: (
391: x_return_status => l_return_status,
392: x_msg_data => l_msg_data,
393: p_inventory_item_id => l_inventory_item_id,

Line 1577: AHL_FMP_COMMON_PVT.validate_lookup

1573:
1574: -- Check if the Program Duration UOM is a valid value.
1575: IF ( p_x_threshold_rec.program_duration_uom_code IS NOT NULL ) THEN
1576:
1577: AHL_FMP_COMMON_PVT.validate_lookup
1578: (
1579: x_return_status => l_return_status,
1580: x_msg_data => l_msg_data,
1581: p_lookup_type => 'AHL_UMP_TIME_UOM',

Line 1638: l_mr_status_code :=AHL_FMP_COMMON_PVT.check_mr_status(p_mr_header_id);

1634: l_old_threshold_rec.threshold_date <> p_x_threshold_rec.threshold_date) OR
1635: (p_x_threshold_rec.threshold_date IS NOT NULL AND
1636: l_old_threshold_rec.threshold_date IS NULL) ) THEN
1637:
1638: l_mr_status_code :=AHL_FMP_COMMON_PVT.check_mr_status(p_mr_header_id);
1639: IF ( l_pm_install_flag = 'Y' AND
1640: p_super_user = 'Y' AND
1641: l_mr_status_code = 'COMPLETE' AND
1642: p_mr_type_code ='PROGRAM' ) THEN

Line 1643: AHL_FMP_COMMON_PVT.validate_mr_type_program

1639: IF ( l_pm_install_flag = 'Y' AND
1640: p_super_user = 'Y' AND
1641: l_mr_status_code = 'COMPLETE' AND
1642: p_mr_type_code ='PROGRAM' ) THEN
1643: AHL_FMP_COMMON_PVT.validate_mr_type_program
1644: (
1645: x_return_status => l_return_status,
1646: x_msg_data => l_msg_data,
1647: p_mr_header_id => p_mr_header_id,

Line 1663: AHL_FMP_COMMON_PVT.validate_mr_type_activity

1659: IF ( l_pm_install_flag = 'Y' AND
1660: p_super_user = 'Y' AND
1661: l_mr_status_code = 'COMPLETE' AND
1662: p_mr_type_code ='ACTIVITY' ) THEN
1663: AHL_FMP_COMMON_PVT.validate_mr_type_activity
1664: (
1665: x_return_status => l_return_status,
1666: x_msg_data => l_msg_data,
1667: p_effectivity_id => p_x_threshold_rec.MR_EFFECTIVITY_ID,