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_PRD_DISPOSITION_PVT dependencies on FND_PROFILE

Line 1234: AND(p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR

1230: -- create service request and non-routine job
1231: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
1232: -- Add a check for the create_work_order_option attribute too.
1233: IF p_x_disposition_rec.primary_service_request_id IS NULL AND p_x_disposition_rec.instance_id IS NOT NULL -- ITEM is tracked
1234: AND(p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR
1235: p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))
1236: AND(p_x_disposition_rec.create_work_order_option <> 'CREATE_SR_NO') THEN
1237:
1238: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007

Line 1235: p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))

1231: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
1232: -- Add a check for the create_work_order_option attribute too.
1233: IF p_x_disposition_rec.primary_service_request_id IS NULL AND p_x_disposition_rec.instance_id IS NOT NULL -- ITEM is tracked
1234: AND(p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR
1235: p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))
1236: AND(p_x_disposition_rec.create_work_order_option <> 'CREATE_SR_NO') THEN
1237:
1238: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
1239: -- The option CREATE_WO_NO is not valid for non-serialized items. If chosen, throw an error.

Line 1338: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND

1334: -- For FP OGMA Issue# 105 - Non-Serialized Item Maintenance, if the instance was removed in 'Inspection'
1335: -- condition, then it should not be returned to the locator.
1336: IF (NVL(x_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS AND
1337: p_x_disposition_rec.part_change_id IS NOT NULL AND
1338: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
1339: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
1340: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
1341: OPEN part_change_dtls_csr(p_x_disposition_rec.part_change_id);
1342: FETCH part_change_dtls_csr INTO l_removed_instance_id, l_part_change_type;

Line 1339: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND

1335: -- condition, then it should not be returned to the locator.
1336: IF (NVL(x_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS AND
1337: p_x_disposition_rec.part_change_id IS NOT NULL AND
1338: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
1339: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
1340: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
1341: OPEN part_change_dtls_csr(p_x_disposition_rec.part_change_id);
1342: FETCH part_change_dtls_csr INTO l_removed_instance_id, l_part_change_type;
1343: CLOSE part_change_dtls_csr;

Line 1340: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN

1336: IF (NVL(x_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS AND
1337: p_x_disposition_rec.part_change_id IS NOT NULL AND
1338: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
1339: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
1340: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
1341: OPEN part_change_dtls_csr(p_x_disposition_rec.part_change_id);
1342: FETCH part_change_dtls_csr INTO l_removed_instance_id, l_part_change_type;
1343: CLOSE part_change_dtls_csr;
1344: -- Changed by jaramana on 17-FEB-2011 for bug 11676572; sorao for backporting project

Line 1376: IF (p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND

1372: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1374: END IF;
1375:
1376: IF (p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
1377: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
1378: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
1379: -- Serviceable Removal: Move part to WO locator
1380: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1377: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND

1373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1374: END IF;
1375:
1376: IF (p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
1377: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
1378: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
1379: -- Serviceable Removal: Move part to WO locator
1380: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1381: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator with ' ||

Line 1378: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN

1374: END IF;
1375:
1376: IF (p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
1377: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
1378: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
1379: -- Serviceable Removal: Move part to WO locator
1380: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1381: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator with ' ||
1382: ' part change id = ' || p_x_disposition_rec.part_change_id ||

Line 1407: IF (p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1) AND

1403: END IF; -- x_return_status is Success and Part Change has happened
1404:
1405: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
1406: -- If the part is removed in 'Inspection' condition, then move the disposition to Complete status.
1407: IF (p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1) AND
1408: p_x_disposition_rec.part_change_id IS NOT NULL) THEN
1409: UPDATE AHL_PRD_DISPOSITIONS_B
1410: SET status_code = 'COMPLETE'
1411: WHERE disposition_id = p_x_disposition_rec.disposition_id;

Line 1421: ', NVL(fnd_profile.value(AHL_MTL_MAT_STATUS_UNSERVICABLE), -1) = ' || NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) ||

1417: -- This is to prevent the Material returns UI from incorrectly showing this disposition quantity as available for return
1418: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1419: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to check if Disposition status can be set to Complete for non Inspection.' ||
1420: ' p_x_disposition_rec.condition_id = ' || p_x_disposition_rec.condition_id ||
1421: ', NVL(fnd_profile.value(AHL_MTL_MAT_STATUS_UNSERVICABLE), -1) = ' || NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) ||
1422: ', NVL(fnd_profile.value(AHL_MTL_MAT_STATUS_MRB), -1) = ' || NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) ||
1423: ', p_x_disposition_rec.part_change_id = ' || p_x_disposition_rec.part_change_id ||
1424: ', l_non_routine_workorder_id = ' || l_non_routine_workorder_id ||
1425: ', l_primary_service_request_id = ' || l_primary_service_request_id);

Line 1422: ', NVL(fnd_profile.value(AHL_MTL_MAT_STATUS_MRB), -1) = ' || NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) ||

1418: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1419: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to check if Disposition status can be set to Complete for non Inspection.' ||
1420: ' p_x_disposition_rec.condition_id = ' || p_x_disposition_rec.condition_id ||
1421: ', NVL(fnd_profile.value(AHL_MTL_MAT_STATUS_UNSERVICABLE), -1) = ' || NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) ||
1422: ', NVL(fnd_profile.value(AHL_MTL_MAT_STATUS_MRB), -1) = ' || NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) ||
1423: ', p_x_disposition_rec.part_change_id = ' || p_x_disposition_rec.part_change_id ||
1424: ', l_non_routine_workorder_id = ' || l_non_routine_workorder_id ||
1425: ', l_primary_service_request_id = ' || l_primary_service_request_id);
1426: END IF;

Line 1431: (p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) OR

1427:
1428: -- Changes by jaramana on 31-MAR-2011 for bug 11856373;sorao for backporting project
1429: -- Do not use the part change id for determining this
1430: IF (p_x_disposition_rec.serial_number IS NULL AND p_x_disposition_rec.instance_id IS NOT NULL AND
1431: (p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) OR
1432: p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) AND
1433: l_non_routine_workorder_id IS NOT NULL) THEN
1434:
1435: -- Cursor to get the removal instance removed by jaramana on 31-MAR-2011 for bug 11856373

Line 1432: p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) AND

1428: -- Changes by jaramana on 31-MAR-2011 for bug 11856373;sorao for backporting project
1429: -- Do not use the part change id for determining this
1430: IF (p_x_disposition_rec.serial_number IS NULL AND p_x_disposition_rec.instance_id IS NOT NULL AND
1431: (p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) OR
1432: p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) AND
1433: l_non_routine_workorder_id IS NOT NULL) THEN
1434:
1435: -- Cursor to get the removal instance removed by jaramana on 31-MAR-2011 for bug 11856373
1436: -- Do not use the removed instance for this check

Line 2074: p_col_trigger_value => fnd_profile.value('AHL_MRB_DISP_PLAN_TYPE'),

2070: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2071: p_default => FND_API.G_FALSE,
2072: p_organization_id => p_x_disposition_rec.item_org_id,
2073: p_transaction_number => 2004, -- MRB_TRANSACTION_NUMBER
2074: p_col_trigger_value => fnd_profile.value('AHL_MRB_DISP_PLAN_TYPE'),
2075: x_return_status => l_return_status,
2076: x_msg_count => l_msg_count,
2077: x_msg_data => l_msg_data,
2078: x_plan_id => l_plan_id);

Line 2080: IF p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND p_x_disposition_rec.instance_id IS NOT NULL THEN -- status is MRB and tracked item

2076: x_msg_count => l_msg_count,
2077: x_msg_data => l_msg_data,
2078: x_plan_id => l_plan_id);
2079: /**
2080: IF p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND p_x_disposition_rec.instance_id IS NOT NULL THEN -- status is MRB and tracked item
2081: **/
2082: IF p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND
2083: p_x_disposition_rec.instance_id IS NOT NULL AND
2084: l_plan_id IS NOT NULL THEN -- status is MRB and tracked item and QA plan is defined in Org

Line 2082: IF p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND

2078: x_plan_id => l_plan_id);
2079: /**
2080: IF p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND p_x_disposition_rec.instance_id IS NOT NULL THEN -- status is MRB and tracked item
2081: **/
2082: IF p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND
2083: p_x_disposition_rec.instance_id IS NOT NULL AND
2084: l_plan_id IS NOT NULL THEN -- status is MRB and tracked item and QA plan is defined in Org
2085: IF p_x_disposition_rec.collection_id IS NULL THEN
2086: OPEN is_qa_coll_reqd(l_plan_id);

Line 2103: (nvl(p_x_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')

2099:
2100: -- SERVICE REQUEST
2101: IF ((p_x_disposition_rec.instance_id IS NULL
2102: OR
2103: (nvl(p_x_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
2104: AND nvl(p_x_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
2105: )
2106: )
2107: AND

Line 2104: AND nvl(p_x_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')

2100: -- SERVICE REQUEST
2101: IF ((p_x_disposition_rec.instance_id IS NULL
2102: OR
2103: (nvl(p_x_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
2104: AND nvl(p_x_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
2105: )
2106: )
2107: AND
2108: ( p_x_disposition_rec.summary IS NOT NULL OR p_x_disposition_rec.problem_code IS NOT NULL

Line 2119: AND(p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR

2115: -- create service request and non-routine job
2116: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
2117: -- Add a check for the create_work_order_option attribute too.
2118: IF p_x_disposition_rec.primary_service_request_id IS NULL AND p_x_disposition_rec.instance_id IS NOT NULL -- AND ITEM is tracked
2119: AND(p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR
2120: p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))
2121: AND(p_x_disposition_rec.create_work_order_option <> 'CREATE_SR_NO') THEN
2122: --dbms_output.put_line(SubStr('Update_Disp Before Create_SR', 1, 255));
2123:

Line 2120: p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))

2116: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
2117: -- Add a check for the create_work_order_option attribute too.
2118: IF p_x_disposition_rec.primary_service_request_id IS NULL AND p_x_disposition_rec.instance_id IS NOT NULL -- AND ITEM is tracked
2119: AND(p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR
2120: p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))
2121: AND(p_x_disposition_rec.create_work_order_option <> 'CREATE_SR_NO') THEN
2122: --dbms_output.put_line(SubStr('Update_Disp Before Create_SR', 1, 255));
2123:
2124: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007

Line 2203: IF (p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION') AND

2199:
2200: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
2201: -- If the part is removed in 'Inspection' condition, then move the disposition to Complete status.
2202: -- SURRKUMA :: BUG 12658774 - STATUS 'COMPLETED' SHOWN EVEN AFTER TERMINATION, 25-Nov-2011; sorao for backporting
2203: IF (p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION') AND
2204: p_x_disposition_rec.part_change_id IS NOT NULL AND p_x_disposition_rec.status_code <> 'TERMINATED') THEN
2205: p_x_disposition_rec.status_code := 'COMPLETE';
2206: END IF;
2207:

Line 2218: ', NVL(fnd_profile.value(AHL_MTL_MAT_STATUS_UNSERVICABLE), -1) = ' || NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) ||

2214: ' p_x_disposition_rec.serial_number = ' || p_x_disposition_rec.serial_number ||
2215: ', p_x_disposition_rec.instance_id = ' || p_x_disposition_rec.instance_id ||
2216: ', p_x_disposition_rec.condition_id = ' || p_x_disposition_rec.condition_id ||
2217: ', p_x_disposition_rec.status_code = ' || p_x_disposition_rec.status_code ||
2218: ', NVL(fnd_profile.value(AHL_MTL_MAT_STATUS_UNSERVICABLE), -1) = ' || NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) ||
2219: ', NVL(fnd_profile.value(AHL_MTL_MAT_STATUS_MRB), -1) = ' || NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) ||
2220: ', p_x_disposition_rec.part_change_id = ' || p_x_disposition_rec.part_change_id ||
2221: ', l_non_routine_workorder_id = ' || l_non_routine_workorder_id ||
2222: ', l_primary_service_request_id = ' || l_primary_service_request_id);

Line 2219: ', NVL(fnd_profile.value(AHL_MTL_MAT_STATUS_MRB), -1) = ' || NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) ||

2215: ', p_x_disposition_rec.instance_id = ' || p_x_disposition_rec.instance_id ||
2216: ', p_x_disposition_rec.condition_id = ' || p_x_disposition_rec.condition_id ||
2217: ', p_x_disposition_rec.status_code = ' || p_x_disposition_rec.status_code ||
2218: ', NVL(fnd_profile.value(AHL_MTL_MAT_STATUS_UNSERVICABLE), -1) = ' || NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) ||
2219: ', NVL(fnd_profile.value(AHL_MTL_MAT_STATUS_MRB), -1) = ' || NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) ||
2220: ', p_x_disposition_rec.part_change_id = ' || p_x_disposition_rec.part_change_id ||
2221: ', l_non_routine_workorder_id = ' || l_non_routine_workorder_id ||
2222: ', l_primary_service_request_id = ' || l_primary_service_request_id);
2223: END IF;

Line 2227: (p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) OR

2223: END IF;
2224: -- Changes by jaramana on 31-MAR-2011 for bug 11856373
2225: -- Do not use the part change id for determining this
2226: IF (p_x_disposition_rec.serial_number IS NULL AND p_x_disposition_rec.instance_id IS NOT NULL AND
2227: (p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) OR
2228: p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) AND
2229: l_non_routine_workorder_id IS NOT NULL) THEN
2230:
2231: -- Cursor to get the removal instance removed by jaramana on 31-MAR-2011 for bug 11856373

Line 2228: p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) AND

2224: -- Changes by jaramana on 31-MAR-2011 for bug 11856373
2225: -- Do not use the part change id for determining this
2226: IF (p_x_disposition_rec.serial_number IS NULL AND p_x_disposition_rec.instance_id IS NOT NULL AND
2227: (p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) OR
2228: p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) AND
2229: l_non_routine_workorder_id IS NOT NULL) THEN
2230:
2231: -- Cursor to get the removal instance removed by jaramana on 31-MAR-2011 for bug 11856373
2232: -- Do not use the removed instance for this check

Line 2421: (p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')

2417: -- then the removed part should be assigned to the released NR workorder.
2418: -- This should be done only if the primary SR was not created along with removal in this cycle itself.
2419: IF (l_disposition_rec.part_change_id IS NULL AND p_x_disposition_rec.part_change_id IS NOT NULL
2420: AND
2421: (p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
2422: OR
2423: p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
2424: )
2425: AND

Line 2423: p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')

2419: IF (l_disposition_rec.part_change_id IS NULL AND p_x_disposition_rec.part_change_id IS NOT NULL
2420: AND
2421: (p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
2422: OR
2423: p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
2424: )
2425: AND
2426: p_x_disposition_rec.non_routine_workorder_id IS NOT NULL
2427: AND

Line 2518: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND

2514: -- condition, then it should not be returned to the locator.
2515: IF (NVL(x_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS AND
2516: l_disposition_rec.part_change_id IS NULL AND
2517: p_x_disposition_rec.part_change_id IS NOT NULL AND
2518: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
2519: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
2520: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
2521: OPEN part_change_dtls_csr(p_x_disposition_rec.part_change_id);
2522: FETCH part_change_dtls_csr INTO l_removed_instance_id, l_part_change_type;

Line 2519: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND

2515: IF (NVL(x_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS AND
2516: l_disposition_rec.part_change_id IS NULL AND
2517: p_x_disposition_rec.part_change_id IS NOT NULL AND
2518: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
2519: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
2520: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
2521: OPEN part_change_dtls_csr(p_x_disposition_rec.part_change_id);
2522: FETCH part_change_dtls_csr INTO l_removed_instance_id, l_part_change_type;
2523: CLOSE part_change_dtls_csr;

Line 2520: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN

2516: l_disposition_rec.part_change_id IS NULL AND
2517: p_x_disposition_rec.part_change_id IS NOT NULL AND
2518: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
2519: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
2520: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
2521: OPEN part_change_dtls_csr(p_x_disposition_rec.part_change_id);
2522: FETCH part_change_dtls_csr INTO l_removed_instance_id, l_part_change_type;
2523: CLOSE part_change_dtls_csr;
2524: -- Changed by jaramana on 17-FEB-2011 for bug 11676572 ;sorao for backporting project

Line 2555: IF (p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND

2551: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2553: END IF;
2554:
2555: IF (p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
2556: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
2557: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
2558: -- Serviceable Removal: Move part to WO locator
2559: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2556: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND

2552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2553: END IF;
2554:
2555: IF (p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
2556: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
2557: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
2558: -- Serviceable Removal: Move part to WO locator
2559: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2560: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator with ' ||

Line 2557: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN

2553: END IF;
2554:
2555: IF (p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
2556: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
2557: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
2558: -- Serviceable Removal: Move part to WO locator
2559: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2560: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator with ' ||
2561: ' part change id = ' || p_x_disposition_rec.part_change_id ||

Line 3058: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Defaulting Condition to ' || fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE'));

3054: -- Disposition being created from Part Change UI for installing to an Empty position
3055: -- Default the condition of the Disposition to Serviceable if not already set
3056: IF (p_x_disposition_rec.condition_id IS NULL) THEN
3057: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3058: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Defaulting Condition to ' || fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE'));
3059: END IF;
3060: p_x_disposition_rec.condition_id := fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE');
3061: IF (p_x_disposition_rec.condition_id IS NULL) THEN
3062: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3060: p_x_disposition_rec.condition_id := fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE');

3056: IF (p_x_disposition_rec.condition_id IS NULL) THEN
3057: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3058: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Defaulting Condition to ' || fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE'));
3059: END IF;
3060: p_x_disposition_rec.condition_id := fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE');
3061: IF (p_x_disposition_rec.condition_id IS NULL) THEN
3062: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3063: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Profile AHL_MTL_MAT_STATUS_SERVICABLE not set. Unable to derive Default Condition.');
3064: END IF;

Line 3082: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Defaulting Condition to ' || fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE'));

3078: p_x_disposition_rec.condition_id IS NULL) THEN
3079: -- Install of an Instance to an IB Tree from the Part Change UI with creation of
3080: -- a new Disposition: Default the condition to Serviceable
3081: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3082: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Defaulting Condition to ' || fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE'));
3083: END IF;
3084: p_x_disposition_rec.condition_id := fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE');
3085: IF (p_x_disposition_rec.condition_id IS NULL) THEN
3086: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3084: p_x_disposition_rec.condition_id := fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE');

3080: -- a new Disposition: Default the condition to Serviceable
3081: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3082: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Defaulting Condition to ' || fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE'));
3083: END IF;
3084: p_x_disposition_rec.condition_id := fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE');
3085: IF (p_x_disposition_rec.condition_id IS NULL) THEN
3086: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3087: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Profile AHL_MTL_MAT_STATUS_SERVICABLE not set. Unable to derive Default Condition.');
3088: END IF;

Line 3867: p_col_trigger_value => fnd_profile.value('AHL_MRB_DISP_PLAN_TYPE'),

3863: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3864: p_default => FND_API.G_FALSE,
3865: p_organization_id => p_disposition_rec.item_org_id,
3866: p_transaction_number => 2004, -- MRB_TRANSACTION_NUMBER
3867: p_col_trigger_value => fnd_profile.value('AHL_MRB_DISP_PLAN_TYPE'),
3868: x_return_status => l_return_status,
3869: x_msg_count => l_msg_count,
3870: x_msg_data => l_msg_data,
3871: x_plan_id => l_plan_id);

Line 3872: --IF p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND p_disposition_rec.instance_id IS NOT NULL THEN

3868: x_return_status => l_return_status,
3869: x_msg_count => l_msg_count,
3870: x_msg_data => l_msg_data,
3871: x_plan_id => l_plan_id);
3872: --IF p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND p_disposition_rec.instance_id IS NOT NULL THEN
3873: IF p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND
3874: p_disposition_rec.instance_id IS NOT NULL AND
3875: l_plan_id IS NOT NULL THEN
3876: IF p_disposition_rec.collection_id IS NULL THEN

Line 3873: IF p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND

3869: x_msg_count => l_msg_count,
3870: x_msg_data => l_msg_data,
3871: x_plan_id => l_plan_id);
3872: --IF p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND p_disposition_rec.instance_id IS NOT NULL THEN
3873: IF p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND
3874: p_disposition_rec.instance_id IS NOT NULL AND
3875: l_plan_id IS NOT NULL THEN
3876: IF p_disposition_rec.collection_id IS NULL THEN
3877: OPEN is_qa_coll_reqd(l_plan_id);

Line 3891: (nvl(p_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')

3887: END IF;
3888: -- End fix for bug 4243200
3889:
3890: IF ((p_disposition_rec.instance_id IS NULL OR
3891: (nvl(p_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
3892: AND nvl(p_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
3893: )
3894: )AND
3895: ( p_disposition_rec.summary IS NOT NULL OR p_disposition_rec.problem_code IS NOT NULL

Line 3892: AND nvl(p_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')

3888: -- End fix for bug 4243200
3889:
3890: IF ((p_disposition_rec.instance_id IS NULL OR
3891: (nvl(p_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
3892: AND nvl(p_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
3893: )
3894: )AND
3895: ( p_disposition_rec.summary IS NOT NULL OR p_disposition_rec.problem_code IS NOT NULL
3896: OR p_disposition_rec.severity_id IS NOT NULL

Line 3984: AND (( NOT EXISTS (SELECT 1 FROM CS_SR_PROB_CODE_MAPPING_V WHERE INCIDENT_TYPE_ID = FND_PROFILE.Value('AHL_PRD_SR_TYPE')

3980: SELECT fl.lookup_code FROM fnd_lookup_values_vl FL
3981: WHERE fl.meaning = p_problem_meaning
3982: AND lookup_type = 'REQUEST_PROBLEM_CODE'
3983: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active,sysdate)) AND trunc(nvl(end_date_active,sysdate))
3984: AND (( NOT EXISTS (SELECT 1 FROM CS_SR_PROB_CODE_MAPPING_V WHERE INCIDENT_TYPE_ID = FND_PROFILE.Value('AHL_PRD_SR_TYPE')
3985: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))) )
3986: OR ( EXISTS (SELECT 1 FROM CS_SR_PROB_CODE_MAPPING_V MAP WHERE MAP.INCIDENT_TYPE_ID = FND_PROFILE.Value('AHL_PRD_SR_TYPE')
3987: AND MAP.INVENTORY_ITEM_ID IS NULL AND MAP.PROBLEM_CODE = FL.LOOKUP_CODE
3988: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(MAP.START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(MAP.END_DATE_ACTIVE,SYSDATE)))));

Line 3986: OR ( EXISTS (SELECT 1 FROM CS_SR_PROB_CODE_MAPPING_V MAP WHERE MAP.INCIDENT_TYPE_ID = FND_PROFILE.Value('AHL_PRD_SR_TYPE')

3982: AND lookup_type = 'REQUEST_PROBLEM_CODE'
3983: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active,sysdate)) AND trunc(nvl(end_date_active,sysdate))
3984: AND (( NOT EXISTS (SELECT 1 FROM CS_SR_PROB_CODE_MAPPING_V WHERE INCIDENT_TYPE_ID = FND_PROFILE.Value('AHL_PRD_SR_TYPE')
3985: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))) )
3986: OR ( EXISTS (SELECT 1 FROM CS_SR_PROB_CODE_MAPPING_V MAP WHERE MAP.INCIDENT_TYPE_ID = FND_PROFILE.Value('AHL_PRD_SR_TYPE')
3987: AND MAP.INVENTORY_ITEM_ID IS NULL AND MAP.PROBLEM_CODE = FL.LOOKUP_CODE
3988: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(MAP.START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(MAP.END_DATE_ACTIVE,SYSDATE)))));
3989: */
3990: -- AnRaj: Changed query, Perf Bug#4908609,Issue#6

Line 4779: AND (p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')

4775:
4776: -- Non-conformance request required. When tracked instance is in non-serviceable condition
4777: ELSIF (p_disposition_rec.immediate_disposition_code NOT IN ('NA','NOT_RECEIVED','NOT_REMOVED')
4778: AND l_disp_dtl_rec.trackable_flag = 'Y'
4779: AND (p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
4780: OR p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))
4781: AND p_disposition_rec.primary_service_request_id IS NULL) THEN
4782: x_status_code := 'NON_CONF_REQD';
4783:

Line 4780: OR p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))

4776: -- Non-conformance request required. When tracked instance is in non-serviceable condition
4777: ELSIF (p_disposition_rec.immediate_disposition_code NOT IN ('NA','NOT_RECEIVED','NOT_REMOVED')
4778: AND l_disp_dtl_rec.trackable_flag = 'Y'
4779: AND (p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
4780: OR p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))
4781: AND p_disposition_rec.primary_service_request_id IS NULL) THEN
4782: x_status_code := 'NON_CONF_REQD';
4783:
4784: --Mtl_txn required

Line 4807: AND p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')

4803: x_status_code := 'REMOVAL_COMP';
4804: --QA collection ID
4805: ELSIF (p_disposition_rec.immediate_disposition_code NOT IN ('NA','NOT_RECEIVED','NOT_REMOVED')
4806: AND p_disposition_rec.instance_id IS NOT NULL
4807: AND p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
4808: AND p_disposition_rec.collection_id IS NULL)THEN
4809: x_status_code := 'PENDING_MRB';
4810:
4811: --Install required

Line 4967: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND

4963:
4964: --If RTV/RTC/HOLD/REWORK_RR, condition has to be unserviceable or MRB
4965: IF (p_disposition_rec.secondary_disposition_code <> 'REWORK_NR' AND
4966: p_disposition_rec.secondary_disposition_code <> 'SCRAP' AND
4967: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
4968: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
4969: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_TYPE_COND_INV');
4970: FND_MSG_PUB.ADD;
4971: --If SCRAP, condition has to be MRB

Line 4968: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN

4964: --If RTV/RTC/HOLD/REWORK_RR, condition has to be unserviceable or MRB
4965: IF (p_disposition_rec.secondary_disposition_code <> 'REWORK_NR' AND
4966: p_disposition_rec.secondary_disposition_code <> 'SCRAP' AND
4967: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
4968: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
4969: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_TYPE_COND_INV');
4970: FND_MSG_PUB.ADD;
4971: --If SCRAP, condition has to be MRB
4972: ELSIF (p_disposition_rec.secondary_disposition_code = 'SCRAP' AND

Line 4973: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN

4969: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_TYPE_COND_INV');
4970: FND_MSG_PUB.ADD;
4971: --If SCRAP, condition has to be MRB
4972: ELSIF (p_disposition_rec.secondary_disposition_code = 'SCRAP' AND
4973: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
4974: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_TYPE_COND_INV');
4975: FND_MSG_PUB.ADD;
4976: END IF;
4977:

Line 4981: (p_disposition_rec.condition_id=fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR

4977:
4978: ELSE
4979: --Use_as_is means condition must be serviceable
4980: IF (p_disposition_rec.immediate_disposition_code = 'USE_AS_IS' AND
4981: (p_disposition_rec.condition_id=fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR
4982: p_disposition_rec.condition_id=fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))) THEN
4983: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_TYPE_COND_INV');
4984: FND_MSG_PUB.ADD;
4985: END IF;

Line 4982: p_disposition_rec.condition_id=fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))) THEN

4978: ELSE
4979: --Use_as_is means condition must be serviceable
4980: IF (p_disposition_rec.immediate_disposition_code = 'USE_AS_IS' AND
4981: (p_disposition_rec.condition_id=fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR
4982: p_disposition_rec.condition_id=fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))) THEN
4983: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_TYPE_COND_INV');
4984: FND_MSG_PUB.ADD;
4985: END IF;
4986: --SCRAP means condition is MRB

Line 4988: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN

4984: FND_MSG_PUB.ADD;
4985: END IF;
4986: --SCRAP means condition is MRB
4987: IF (p_disposition_rec.immediate_disposition_code = 'SCRAP' AND
4988: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
4989: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_TYPE_COND_INV');
4990: FND_MSG_PUB.ADD;
4991: END IF;
4992: --not BFS or NON_CONF, secondary must be null

Line 5039: IF (l_disp_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')

5035: CLOSE get_disp_rec_csr;
5036:
5037: --Validate that condition id flows only 1 way.
5038: --'MRB' must stay as MRB
5039: IF (l_disp_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
5040: AND p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
5041: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_COND_CHANGE_INV');
5042: FND_MESSAGE.Set_Token('OLD_CONDITION', l_disp_rec.condition_code);
5043: FND_MESSAGE.Set_Token('NEW_CONDITION', p_disposition_rec.condition_meaning);

Line 5040: AND p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN

5036:
5037: --Validate that condition id flows only 1 way.
5038: --'MRB' must stay as MRB
5039: IF (l_disp_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
5040: AND p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
5041: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_COND_CHANGE_INV');
5042: FND_MESSAGE.Set_Token('OLD_CONDITION', l_disp_rec.condition_code);
5043: FND_MESSAGE.Set_Token('NEW_CONDITION', p_disposition_rec.condition_meaning);
5044: FND_MSG_PUB.ADD;

Line 5046: ELSIF (l_disp_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND

5042: FND_MESSAGE.Set_Token('OLD_CONDITION', l_disp_rec.condition_code);
5043: FND_MESSAGE.Set_Token('NEW_CONDITION', p_disposition_rec.condition_meaning);
5044: FND_MSG_PUB.ADD;
5045: --Unserviceable cannot become serviceable
5046: ELSIF (l_disp_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
5047: p_disposition_rec.condition_id<>fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
5048: p_disposition_rec.condition_id<>fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
5049: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_COND_CHANGE_INV');
5050: FND_MESSAGE.Set_Token('OLD_CONDITION', l_disp_rec.condition_code);

Line 5047: p_disposition_rec.condition_id<>fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND

5043: FND_MESSAGE.Set_Token('NEW_CONDITION', p_disposition_rec.condition_meaning);
5044: FND_MSG_PUB.ADD;
5045: --Unserviceable cannot become serviceable
5046: ELSIF (l_disp_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
5047: p_disposition_rec.condition_id<>fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
5048: p_disposition_rec.condition_id<>fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
5049: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_COND_CHANGE_INV');
5050: FND_MESSAGE.Set_Token('OLD_CONDITION', l_disp_rec.condition_code);
5051: FND_MESSAGE.Set_Token('NEW_CONDITION', p_disposition_rec.condition_meaning);

Line 5048: p_disposition_rec.condition_id<>fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN

5044: FND_MSG_PUB.ADD;
5045: --Unserviceable cannot become serviceable
5046: ELSIF (l_disp_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
5047: p_disposition_rec.condition_id<>fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
5048: p_disposition_rec.condition_id<>fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
5049: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_COND_CHANGE_INV');
5050: FND_MESSAGE.Set_Token('OLD_CONDITION', l_disp_rec.condition_code);
5051: FND_MESSAGE.Set_Token('NEW_CONDITION', p_disposition_rec.condition_meaning);
5052: FND_MSG_PUB.ADD;