DBA Data[Home] [Help]

APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on AHL_FMP_COMMON_PVT

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

105: l_pm_install_flag:= 'N';
106: END IF;
107:
108: --check if mr is terminated and get the mr status.
109: l_mr_status_code :=AHL_FMP_COMMON_PVT.check_mr_status(p_mr_header_id);
110: IF l_mr_status_code IS NULL THEN
111: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR' );
112: FND_MSG_PUB.add;
113: x_return_status := FND_API.G_RET_STS_ERROR;

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

114: RETURN;
115: END IF;
116:
117: --check if mr type.
118: l_mr_type_code :=AHL_FMP_COMMON_PVT.check_mr_type(p_mr_header_id);
119:
120: -- Check if the Maintenance Requirement is in Updatable status
121: IF ( l_pm_install_flag = 'Y' AND
122: p_super_user ='Y' AND

Line 124: AHL_FMP_COMMON_PVT.validate_mr_pm_status

120: -- Check if the Maintenance Requirement is in Updatable status
121: IF ( l_pm_install_flag = 'Y' AND
122: p_super_user ='Y' AND
123: l_mr_status_code = 'COMPLETE') THEN
124: AHL_FMP_COMMON_PVT.validate_mr_pm_status
125: (
126: x_return_status => l_return_status,
127: x_msg_data => l_error_code,
128: p_mr_header_id => p_mr_header_id

Line 131: AHL_FMP_COMMON_PVT.validate_mr_status

127: x_msg_data => l_error_code,
128: p_mr_header_id => p_mr_header_id
129: );
130: ELSE
131: AHL_FMP_COMMON_PVT.validate_mr_status
132: (
133: x_return_status => l_return_status,
134: x_msg_data => l_error_code,
135: p_mr_header_id => p_mr_header_id

Line 176: AHL_FMP_COMMON_PVT.validate_mr_type_activity

172: p_effectivity_tbl(i).dml_operation = 'D' AND
173: l_mr_status_code = 'COMPLETE' AND
174: l_mr_type_code ='ACTIVITY')
175: THEN
176: AHL_FMP_COMMON_PVT.validate_mr_type_activity
177: (
178: x_return_status => l_return_status,
179: x_msg_data => l_error_code,
180: p_effectivity_id => p_effectivity_tbl(i).MR_EFFECTIVITY_ID,

Line 196: AHL_FMP_COMMON_PVT.validate_mr_type_program

192: p_effectivity_tbl(i).dml_operation = 'D'AND
193: l_mr_status_code = 'COMPLETE' AND
194: l_mr_type_code ='PROGRAM')
195: THEN
196: AHL_FMP_COMMON_PVT.validate_mr_type_program
197: (
198: x_return_status => l_return_status,
199: x_msg_data => l_error_code,
200: p_mr_header_id => p_mr_header_id,

Line 320: AHL_FMP_COMMON_PVT.validate_item

316: p_x_effectivity_rec.inventory_item_id <> FND_API.G_MISS_NUM ) OR
317: ( p_x_effectivity_rec.item_number IS NOT NULL AND
318: p_x_effectivity_rec.item_number <> FND_API.G_MISS_CHAR ) ) THEN
319:
320: AHL_FMP_COMMON_PVT.validate_item
321: (
322: x_return_status => l_return_status,
323: x_msg_data => l_msg_data,
324: p_item_number => p_x_effectivity_rec.item_number,

Line 351: AHL_FMP_COMMON_PVT.validate_position

347: ( p_x_effectivity_rec.position_ref_meaning IS NOT NULL AND
348: p_x_effectivity_rec.position_ref_meaning <> FND_API.G_MISS_CHAR ) )
349: THEN
350:
351: AHL_FMP_COMMON_PVT.validate_position
352: (
353: x_return_status => l_return_status,
354: x_msg_data => l_msg_data,
355: p_position_ref_meaning => p_x_effectivity_rec.position_ref_meaning,

Line 383: AHL_FMP_COMMON_PVT.validate_item

379: ( p_x_effectivity_rec.position_item_number IS NOT NULL AND
380: p_x_effectivity_rec.position_item_number <> FND_API.G_MISS_CHAR ) )
381: THEN
382:
383: AHL_FMP_COMMON_PVT.validate_item
384: (
385: x_return_status => l_return_status,
386: x_msg_data => l_msg_data,
387: p_item_number => p_x_effectivity_rec.position_item_number,

Line 413: AHL_FMP_COMMON_PVT.validate_pc_node

409: p_x_effectivity_rec.pc_node_id <> FND_API.G_MISS_NUM ) OR
410: ( p_x_effectivity_rec.pc_node_name IS NOT NULL AND
411: p_x_effectivity_rec.pc_node_name <> FND_API.G_MISS_CHAR ) ) THEN
412:
413: AHL_FMP_COMMON_PVT.validate_pc_node
414: (
415: x_return_status => l_return_status,
416: x_msg_data => l_msg_data,
417: p_pc_node_name => p_x_effectivity_rec.pc_node_name,

Line 983: /* AHL_FMP_COMMON_PVT.validate_position_item

979: IF ( p_effectivity_rec.relationship_id IS NOT NULL AND
980: p_effectivity_rec.position_inventory_item_id IS NOT NULL ) THEN
981:
982: -- Check if the given Item can be installed in the given Position.
983: /* AHL_FMP_COMMON_PVT.validate_position_item
984: (
985: x_return_status => l_return_status,
986: x_msg_data => l_msg_data,
987: p_inventory_item_id => p_effectivity_rec.position_inventory_item_id,

Line 1052: AHL_FMP_COMMON_PVT.validate_manufacturer

1048:
1049: IF get_eff_dtls_rec%FOUND THEN
1050:
1051: IF ( p_effectivity_rec.inventory_item_id IS NOT NULL ) THEN
1052: AHL_FMP_COMMON_PVT.validate_manufacturer
1053: (
1054: x_return_status => l_return_status,
1055: x_msg_data => l_msg_data,
1056: p_inventory_item_id => p_effectivity_rec.inventory_item_id,

Line 1060: AHL_FMP_COMMON_PVT.validate_manufacturer

1056: p_inventory_item_id => p_effectivity_rec.inventory_item_id,
1057: p_x_manufacturer_id => l_manufacturer_id
1058: );
1059: ELSIF ( p_effectivity_rec.position_inventory_item_id IS NOT NULL ) THEN
1060: AHL_FMP_COMMON_PVT.validate_manufacturer
1061: (
1062: x_return_status => l_return_status,
1063: x_msg_data => l_msg_data,
1064: p_inventory_item_id => p_effectivity_rec.position_inventory_item_id,

Line 1068: AHL_FMP_COMMON_PVT.validate_manufacturer

1064: p_inventory_item_id => p_effectivity_rec.position_inventory_item_id,
1065: p_x_manufacturer_id => l_manufacturer_id
1066: );
1067: ELSIF ( p_effectivity_rec.relationship_id IS NOT NULL ) THEN
1068: AHL_FMP_COMMON_PVT.validate_manufacturer
1069: (
1070: x_return_status => l_return_status,
1071: x_msg_data => l_msg_data,
1072: p_relationship_id => p_effectivity_rec.relationship_id,

Line 1102: AHL_FMP_COMMON_PVT.validate_counter_template

1098:
1099: IF get_intervals_rec%FOUND THEN
1100:
1101: IF ( p_effectivity_rec.inventory_item_id IS NOT NULL ) THEN
1102: AHL_FMP_COMMON_PVT.validate_counter_template
1103: (
1104: x_return_status => l_return_status,
1105: x_msg_data => l_msg_data,
1106: p_inventory_item_id => p_effectivity_rec.inventory_item_id,

Line 1110: AHL_FMP_COMMON_PVT.validate_counter_template

1106: p_inventory_item_id => p_effectivity_rec.inventory_item_id,
1107: p_x_counter_id => l_counter_id
1108: );
1109: ELSIF ( p_effectivity_rec.position_inventory_item_id IS NOT NULL ) THEN
1110: AHL_FMP_COMMON_PVT.validate_counter_template
1111: (
1112: x_return_status => l_return_status,
1113: x_msg_data => l_msg_data,
1114: p_inventory_item_id => p_effectivity_rec.position_inventory_item_id,

Line 1118: AHL_FMP_COMMON_PVT.validate_counter_template

1114: p_inventory_item_id => p_effectivity_rec.position_inventory_item_id,
1115: p_x_counter_id => l_counter_id
1116: );
1117: ELSIF ( p_effectivity_rec.relationship_id IS NOT NULL ) THEN
1118: AHL_FMP_COMMON_PVT.validate_counter_template
1119: (
1120: x_return_status => l_return_status,
1121: x_msg_data => l_msg_data,
1122: p_relationship_id => p_effectivity_rec.relationship_id,