DBA Data[Home] [Help]

APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on AHL_FMP_COMMON_PVT

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

113: l_pm_install_flag:= 'N';
114: END IF;
115:
116: --check if mr is terminated and get the mr status.
117: l_mr_status_code :=AHL_FMP_COMMON_PVT.check_mr_status(p_mr_header_id);
118: IF l_mr_status_code IS NULL THEN
119: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR' );
120: FND_MSG_PUB.add;
121: x_return_status := FND_API.G_RET_STS_ERROR;

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

122: RETURN;
123: END IF;
124:
125: --check if mr type.
126: l_mr_type_code :=AHL_FMP_COMMON_PVT.check_mr_type(p_mr_header_id);
127:
128: -- Check if the Maintenance Requirement is in Updatable status
129: IF ( l_pm_install_flag = 'Y' AND
130: p_super_user ='Y' AND

Line 132: AHL_FMP_COMMON_PVT.validate_mr_pm_status

128: -- Check if the Maintenance Requirement is in Updatable status
129: IF ( l_pm_install_flag = 'Y' AND
130: p_super_user ='Y' AND
131: l_mr_status_code = 'COMPLETE') THEN
132: AHL_FMP_COMMON_PVT.validate_mr_pm_status
133: (
134: x_return_status => l_return_status,
135: x_msg_data => l_error_code,
136: p_mr_header_id => p_mr_header_id

Line 139: AHL_FMP_COMMON_PVT.validate_mr_status

135: x_msg_data => l_error_code,
136: p_mr_header_id => p_mr_header_id
137: );
138: ELSE
139: AHL_FMP_COMMON_PVT.validate_mr_status
140: (
141: x_return_status => l_return_status,
142: x_msg_data => l_error_code,
143: p_mr_header_id => p_mr_header_id

Line 184: AHL_FMP_COMMON_PVT.validate_mr_type_activity

180: p_effectivity_tbl(i).dml_operation = 'D' AND
181: l_mr_status_code = 'COMPLETE' AND
182: l_mr_type_code ='ACTIVITY')
183: THEN
184: AHL_FMP_COMMON_PVT.validate_mr_type_activity
185: (
186: x_return_status => l_return_status,
187: x_msg_data => l_error_code,
188: p_effectivity_id => p_effectivity_tbl(i).MR_EFFECTIVITY_ID,

Line 204: AHL_FMP_COMMON_PVT.validate_mr_type_program

200: p_effectivity_tbl(i).dml_operation = 'D'AND
201: l_mr_status_code = 'COMPLETE' AND
202: l_mr_type_code ='PROGRAM')
203: THEN
204: AHL_FMP_COMMON_PVT.validate_mr_type_program
205: (
206: x_return_status => l_return_status,
207: x_msg_data => l_error_code,
208: p_mr_header_id => p_mr_header_id,

Line 336: AHL_FMP_COMMON_PVT.validate_item

332: p_x_effectivity_rec.inventory_item_id <> FND_API.G_MISS_NUM ) OR
333: ( p_x_effectivity_rec.item_number IS NOT NULL AND
334: p_x_effectivity_rec.item_number <> FND_API.G_MISS_CHAR ) ) THEN
335:
336: AHL_FMP_COMMON_PVT.validate_item
337: (
338: x_return_status => l_return_status,
339: x_msg_data => l_msg_data,
340: p_item_number => p_x_effectivity_rec.item_number,

Line 367: AHL_FMP_COMMON_PVT.validate_position

363: ( p_x_effectivity_rec.position_ref_meaning IS NOT NULL AND
364: p_x_effectivity_rec.position_ref_meaning <> FND_API.G_MISS_CHAR ) )
365: THEN
366:
367: AHL_FMP_COMMON_PVT.validate_position
368: (
369: x_return_status => l_return_status,
370: x_msg_data => l_msg_data,
371: p_position_ref_meaning => p_x_effectivity_rec.position_ref_meaning,

Line 399: AHL_FMP_COMMON_PVT.validate_item

395: ( p_x_effectivity_rec.position_item_number IS NOT NULL AND
396: p_x_effectivity_rec.position_item_number <> FND_API.G_MISS_CHAR ) )
397: THEN
398:
399: AHL_FMP_COMMON_PVT.validate_item
400: (
401: x_return_status => l_return_status,
402: x_msg_data => l_msg_data,
403: p_item_number => p_x_effectivity_rec.position_item_number,

Line 429: AHL_FMP_COMMON_PVT.validate_pc_node

425: p_x_effectivity_rec.pc_node_id <> FND_API.G_MISS_NUM ) OR
426: ( p_x_effectivity_rec.pc_node_name IS NOT NULL AND
427: p_x_effectivity_rec.pc_node_name <> FND_API.G_MISS_CHAR ) ) THEN
428:
429: AHL_FMP_COMMON_PVT.validate_pc_node
430: (
431: x_return_status => l_return_status,
432: x_msg_data => l_msg_data,
433: p_pc_node_name => p_x_effectivity_rec.pc_node_name,

Line 460: AHL_FMP_COMMON_PVT.validate_fleet_node

456: p_x_effectivity_rec.FLEET_HEADER_ID <> FND_API.G_MISS_NUM ) OR
457: ( p_x_effectivity_rec.FLEET_NAME IS NOT NULL AND
458: p_x_effectivity_rec.FLEET_NAME <> FND_API.G_MISS_CHAR ) ) THEN
459:
460: AHL_FMP_COMMON_PVT.validate_fleet_node
461: (
462: x_return_status => l_return_status,
463: x_msg_data => l_msg_data,
464: p_fleet_name => p_x_effectivity_rec.FLEET_NAME,

Line 1068: /* AHL_FMP_COMMON_PVT.validate_position_item

1064: IF ( p_effectivity_rec.relationship_id IS NOT NULL AND
1065: p_effectivity_rec.position_inventory_item_id IS NOT NULL ) THEN
1066:
1067: -- Check if the given Item can be installed in the given Position.
1068: /* AHL_FMP_COMMON_PVT.validate_position_item
1069: (
1070: x_return_status => l_return_status,
1071: x_msg_data => l_msg_data,
1072: p_inventory_item_id => p_effectivity_rec.position_inventory_item_id,

Line 1137: AHL_FMP_COMMON_PVT.validate_manufacturer

1133:
1134: IF get_eff_dtls_rec%FOUND THEN
1135:
1136: IF ( p_effectivity_rec.inventory_item_id IS NOT NULL ) THEN
1137: AHL_FMP_COMMON_PVT.validate_manufacturer
1138: (
1139: x_return_status => l_return_status,
1140: x_msg_data => l_msg_data,
1141: p_inventory_item_id => p_effectivity_rec.inventory_item_id,

Line 1145: AHL_FMP_COMMON_PVT.validate_manufacturer

1141: p_inventory_item_id => p_effectivity_rec.inventory_item_id,
1142: p_x_manufacturer_id => l_manufacturer_id
1143: );
1144: ELSIF ( p_effectivity_rec.position_inventory_item_id IS NOT NULL ) THEN
1145: AHL_FMP_COMMON_PVT.validate_manufacturer
1146: (
1147: x_return_status => l_return_status,
1148: x_msg_data => l_msg_data,
1149: p_inventory_item_id => p_effectivity_rec.position_inventory_item_id,

Line 1153: AHL_FMP_COMMON_PVT.validate_manufacturer

1149: p_inventory_item_id => p_effectivity_rec.position_inventory_item_id,
1150: p_x_manufacturer_id => l_manufacturer_id
1151: );
1152: ELSIF ( p_effectivity_rec.relationship_id IS NOT NULL ) THEN
1153: AHL_FMP_COMMON_PVT.validate_manufacturer
1154: (
1155: x_return_status => l_return_status,
1156: x_msg_data => l_msg_data,
1157: p_relationship_id => p_effectivity_rec.relationship_id,

Line 1187: AHL_FMP_COMMON_PVT.validate_counter_template

1183:
1184: IF get_intervals_rec%FOUND THEN
1185:
1186: IF ( p_effectivity_rec.inventory_item_id IS NOT NULL ) THEN
1187: AHL_FMP_COMMON_PVT.validate_counter_template
1188: (
1189: x_return_status => l_return_status,
1190: x_msg_data => l_msg_data,
1191: p_inventory_item_id => p_effectivity_rec.inventory_item_id,

Line 1195: AHL_FMP_COMMON_PVT.validate_counter_template

1191: p_inventory_item_id => p_effectivity_rec.inventory_item_id,
1192: p_x_counter_id => l_counter_id
1193: );
1194: ELSIF ( p_effectivity_rec.position_inventory_item_id IS NOT NULL ) THEN
1195: AHL_FMP_COMMON_PVT.validate_counter_template
1196: (
1197: x_return_status => l_return_status,
1198: x_msg_data => l_msg_data,
1199: p_inventory_item_id => p_effectivity_rec.position_inventory_item_id,

Line 1203: AHL_FMP_COMMON_PVT.validate_counter_template

1199: p_inventory_item_id => p_effectivity_rec.position_inventory_item_id,
1200: p_x_counter_id => l_counter_id
1201: );
1202: ELSIF ( p_effectivity_rec.relationship_id IS NOT NULL ) THEN
1203: AHL_FMP_COMMON_PVT.validate_counter_template
1204: (
1205: x_return_status => l_return_status,
1206: x_msg_data => l_msg_data,
1207: p_relationship_id => p_effectivity_rec.relationship_id,