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 1621: AHL_FMP_COMMON_PVT.validate_lookup

1617:
1618: -- Check if the Program Duration UOM is a valid value.
1619: IF ( p_x_threshold_rec.program_duration_uom_code IS NOT NULL ) THEN
1620:
1621: AHL_FMP_COMMON_PVT.validate_lookup
1622: (
1623: x_return_status => l_return_status,
1624: x_msg_data => l_msg_data,
1625: p_lookup_type => 'AHL_UMP_TIME_UOM',

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

1678: l_old_threshold_rec.threshold_date <> p_x_threshold_rec.threshold_date) OR
1679: (p_x_threshold_rec.threshold_date IS NOT NULL AND
1680: l_old_threshold_rec.threshold_date IS NULL) ) THEN
1681:
1682: l_mr_status_code :=AHL_FMP_COMMON_PVT.check_mr_status(p_mr_header_id);
1683: IF ( l_pm_install_flag = 'Y' AND
1684: p_super_user = 'Y' AND
1685: l_mr_status_code = 'COMPLETE' AND
1686: p_mr_type_code ='PROGRAM' ) THEN

Line 1687: AHL_FMP_COMMON_PVT.validate_mr_type_program

1683: IF ( l_pm_install_flag = 'Y' AND
1684: p_super_user = 'Y' AND
1685: l_mr_status_code = 'COMPLETE' AND
1686: p_mr_type_code ='PROGRAM' ) THEN
1687: AHL_FMP_COMMON_PVT.validate_mr_type_program
1688: (
1689: x_return_status => l_return_status,
1690: x_msg_data => l_msg_data,
1691: p_mr_header_id => p_mr_header_id,

Line 1707: AHL_FMP_COMMON_PVT.validate_mr_type_activity

1703: IF ( l_pm_install_flag = 'Y' AND
1704: p_super_user = 'Y' AND
1705: l_mr_status_code = 'COMPLETE' AND
1706: p_mr_type_code ='ACTIVITY' ) THEN
1707: AHL_FMP_COMMON_PVT.validate_mr_type_activity
1708: (
1709: x_return_status => l_return_status,
1710: x_msg_data => l_msg_data,
1711: p_effectivity_id => p_x_threshold_rec.MR_EFFECTIVITY_ID,