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 1175: AND(p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR

1171: -- create service request and non-routine job
1172: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
1173: -- Add a check for the create_work_order_option attribute too.
1174: IF p_x_disposition_rec.primary_service_request_id IS NULL AND p_x_disposition_rec.instance_id IS NOT NULL -- ITEM is tracked
1175: AND(p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR
1176: p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))
1177: AND(p_x_disposition_rec.create_work_order_option <> 'CREATE_SR_NO') THEN
1178:
1179: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007

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

1172: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
1173: -- Add a check for the create_work_order_option attribute too.
1174: IF p_x_disposition_rec.primary_service_request_id IS NULL AND p_x_disposition_rec.instance_id IS NOT NULL -- ITEM is tracked
1175: AND(p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR
1176: p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))
1177: AND(p_x_disposition_rec.create_work_order_option <> 'CREATE_SR_NO') THEN
1178:
1179: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
1180: -- The option CREATE_WO_NO is not valid for non-serialized items. If chosen, throw an error.

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

1275: -- For FP OGMA Issue# 105 - Non-Serialized Item Maintenance, if the instance was removed in 'Inspection'
1276: -- condition, then it should not be returned to the locator.
1277: IF (NVL(x_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS AND
1278: p_x_disposition_rec.part_change_id IS NOT NULL AND
1279: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
1280: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
1281: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
1282: OPEN part_change_dtls_csr(p_x_disposition_rec.part_change_id);
1283: FETCH part_change_dtls_csr INTO l_removed_instance_id, l_part_change_type;

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

1276: -- condition, then it should not be returned to the locator.
1277: IF (NVL(x_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS AND
1278: p_x_disposition_rec.part_change_id IS NOT NULL AND
1279: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
1280: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
1281: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
1282: OPEN part_change_dtls_csr(p_x_disposition_rec.part_change_id);
1283: FETCH part_change_dtls_csr INTO l_removed_instance_id, l_part_change_type;
1284: CLOSE part_change_dtls_csr;

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

1277: IF (NVL(x_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS AND
1278: p_x_disposition_rec.part_change_id IS NOT NULL AND
1279: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
1280: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
1281: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
1282: OPEN part_change_dtls_csr(p_x_disposition_rec.part_change_id);
1283: FETCH part_change_dtls_csr INTO l_removed_instance_id, l_part_change_type;
1284: CLOSE part_change_dtls_csr;
1285: IF (l_removed_instance_id = p_x_disposition_rec.instance_id AND -- Removed instance is the Disposition instance

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

1309: END IF;
1310:
1311: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
1312: -- If the part is removed in 'Inspection' condition, then move the disposition to Complete status.
1313: IF (p_x_disposition_rec.condition_id = NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1) AND
1314: p_x_disposition_rec.part_change_id IS NOT NULL) THEN
1315: UPDATE AHL_PRD_DISPOSITIONS_B
1316: SET status_code = 'COMPLETE'
1317: WHERE disposition_id = p_x_disposition_rec.disposition_id;

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

1882: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1883: p_default => FND_API.G_FALSE,
1884: p_organization_id => p_x_disposition_rec.item_org_id,
1885: p_transaction_number => 2004, -- MRB_TRANSACTION_NUMBER
1886: p_col_trigger_value => fnd_profile.value('AHL_MRB_DISP_PLAN_TYPE'),
1887: x_return_status => l_return_status,
1888: x_msg_count => l_msg_count,
1889: x_msg_data => l_msg_data,
1890: x_plan_id => l_plan_id);

Line 1892: 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

1888: x_msg_count => l_msg_count,
1889: x_msg_data => l_msg_data,
1890: x_plan_id => l_plan_id);
1891: /**
1892: 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
1893: **/
1894: IF p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND
1895: p_x_disposition_rec.instance_id IS NOT NULL AND
1896: l_plan_id IS NOT NULL THEN -- status is MRB and tracked item and QA plan is defined in Org

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

1890: x_plan_id => l_plan_id);
1891: /**
1892: 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
1893: **/
1894: IF p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND
1895: p_x_disposition_rec.instance_id IS NOT NULL AND
1896: l_plan_id IS NOT NULL THEN -- status is MRB and tracked item and QA plan is defined in Org
1897: IF p_x_disposition_rec.collection_id IS NULL THEN
1898: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DIS_QA_RESULT_REQ'); -- QA Result Required

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

1906:
1907: -- SERVICE REQUEST
1908: IF ((p_x_disposition_rec.instance_id IS NULL
1909: OR
1910: (nvl(p_x_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
1911: AND nvl(p_x_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
1912: )
1913: )
1914: AND

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

1907: -- SERVICE REQUEST
1908: IF ((p_x_disposition_rec.instance_id IS NULL
1909: OR
1910: (nvl(p_x_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
1911: AND nvl(p_x_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
1912: )
1913: )
1914: AND
1915: ( p_x_disposition_rec.summary IS NOT NULL OR p_x_disposition_rec.problem_code IS NOT NULL

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

1922: -- create service request and non-routine job
1923: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
1924: -- Add a check for the create_work_order_option attribute too.
1925: 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
1926: AND(p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR
1927: p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))
1928: AND(p_x_disposition_rec.create_work_order_option <> 'CREATE_SR_NO') THEN
1929: --dbms_output.put_line(SubStr('Update_Disp Before Create_SR', 1, 255));
1930:

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

1923: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
1924: -- Add a check for the create_work_order_option attribute too.
1925: 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
1926: AND(p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR
1927: p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))
1928: AND(p_x_disposition_rec.create_work_order_option <> 'CREATE_SR_NO') THEN
1929: --dbms_output.put_line(SubStr('Update_Disp Before Create_SR', 1, 255));
1930:
1931: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007

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

2005: p_x_disposition_rec.last_update_login := fnd_global.login_id;
2006:
2007: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
2008: -- If the part is removed in 'Inspection' condition, then move the disposition to Complete status.
2009: IF (p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION') AND
2010: p_x_disposition_rec.part_change_id IS NOT NULL ) THEN
2011: p_x_disposition_rec.status_code := 'COMPLETE';
2012: END IF;
2013:

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

2161: -- then the removed part should be assigned to the released NR workorder.
2162: -- This should be done only if the primary SR was not created along with removal in this cycle itself.
2163: IF (l_disposition_rec.part_change_id IS NULL AND p_x_disposition_rec.part_change_id IS NOT NULL
2164: AND
2165: (p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
2166: OR
2167: p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
2168: )
2169: AND

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

2163: IF (l_disposition_rec.part_change_id IS NULL AND p_x_disposition_rec.part_change_id IS NOT NULL
2164: AND
2165: (p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
2166: OR
2167: p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
2168: )
2169: AND
2170: p_x_disposition_rec.non_routine_workorder_id IS NOT NULL
2171: AND

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

2246: -- condition, then it should not be returned to the locator.
2247: IF (NVL(x_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS AND
2248: l_disposition_rec.part_change_id IS NULL AND
2249: p_x_disposition_rec.part_change_id IS NOT NULL AND
2250: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
2251: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
2252: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
2253: OPEN part_change_dtls_csr(p_x_disposition_rec.part_change_id);
2254: FETCH part_change_dtls_csr INTO l_removed_instance_id, l_part_change_type;

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

2247: IF (NVL(x_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS AND
2248: l_disposition_rec.part_change_id IS NULL AND
2249: p_x_disposition_rec.part_change_id IS NOT NULL AND
2250: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
2251: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
2252: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
2253: OPEN part_change_dtls_csr(p_x_disposition_rec.part_change_id);
2254: FETCH part_change_dtls_csr INTO l_removed_instance_id, l_part_change_type;
2255: CLOSE part_change_dtls_csr;

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

2248: l_disposition_rec.part_change_id IS NULL AND
2249: p_x_disposition_rec.part_change_id IS NOT NULL AND
2250: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1) AND
2251: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1) AND
2252: p_x_disposition_rec.condition_id <> NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION'), -1)) THEN
2253: OPEN part_change_dtls_csr(p_x_disposition_rec.part_change_id);
2254: FETCH part_change_dtls_csr INTO l_removed_instance_id, l_part_change_type;
2255: CLOSE part_change_dtls_csr;
2256: IF (l_removed_instance_id = p_x_disposition_rec.instance_id AND -- Removed instance is the Disposition instance

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

2631: -- Disposition being created from Part Change UI for installing to an Empty position
2632: -- Default the condition of the Disposition to Serviceable if not already set
2633: IF (p_x_disposition_rec.condition_id IS NULL) THEN
2634: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Defaulting Condition to ' || fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE'));
2636: END IF;
2637: p_x_disposition_rec.condition_id := fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE');
2638: IF (p_x_disposition_rec.condition_id IS NULL) THEN
2639: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2633: IF (p_x_disposition_rec.condition_id IS NULL) THEN
2634: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2635: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Defaulting Condition to ' || fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE'));
2636: END IF;
2637: p_x_disposition_rec.condition_id := fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE');
2638: IF (p_x_disposition_rec.condition_id IS NULL) THEN
2639: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2640: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Profile AHL_MTL_MAT_STATUS_SERVICABLE not set. Unable to derive Default Condition.');
2641: END IF;

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

2655: p_x_disposition_rec.condition_id IS NULL) THEN
2656: -- Install of an Instance to an IB Tree from the Part Change UI with creation of
2657: -- a new Disposition: Default the condition to Serviceable
2658: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Defaulting Condition to ' || fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE'));
2660: END IF;
2661: p_x_disposition_rec.condition_id := fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE');
2662: IF (p_x_disposition_rec.condition_id IS NULL) THEN
2663: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2657: -- a new Disposition: Default the condition to Serviceable
2658: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Defaulting Condition to ' || fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE'));
2660: END IF;
2661: p_x_disposition_rec.condition_id := fnd_profile.value('AHL_MTL_MAT_STATUS_SERVICABLE');
2662: IF (p_x_disposition_rec.condition_id IS NULL) THEN
2663: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2664: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Profile AHL_MTL_MAT_STATUS_SERVICABLE not set. Unable to derive Default Condition.');
2665: END IF;

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

3435: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3436: p_default => FND_API.G_FALSE,
3437: p_organization_id => p_disposition_rec.item_org_id,
3438: p_transaction_number => 2004, -- MRB_TRANSACTION_NUMBER
3439: p_col_trigger_value => fnd_profile.value('AHL_MRB_DISP_PLAN_TYPE'),
3440: x_return_status => l_return_status,
3441: x_msg_count => l_msg_count,
3442: x_msg_data => l_msg_data,
3443: x_plan_id => l_plan_id);

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

3440: x_return_status => l_return_status,
3441: x_msg_count => l_msg_count,
3442: x_msg_data => l_msg_data,
3443: x_plan_id => l_plan_id);
3444: --IF p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND p_disposition_rec.instance_id IS NOT NULL THEN
3445: IF p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND
3446: p_disposition_rec.instance_id IS NOT NULL AND
3447: l_plan_id IS NOT NULL THEN
3448: IF p_disposition_rec.collection_id IS NULL THEN

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

3441: x_msg_count => l_msg_count,
3442: x_msg_data => l_msg_data,
3443: x_plan_id => l_plan_id);
3444: --IF p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND p_disposition_rec.instance_id IS NOT NULL THEN
3445: IF p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB') AND
3446: p_disposition_rec.instance_id IS NOT NULL AND
3447: l_plan_id IS NOT NULL THEN
3448: IF p_disposition_rec.collection_id IS NULL THEN
3449: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DIS_QA_RESULT_REQ'); -- QA Result Required

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

3454: END IF;
3455: -- End fix for bug 4243200
3456:
3457: IF ((p_disposition_rec.instance_id IS NULL OR
3458: (nvl(p_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
3459: AND nvl(p_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
3460: )
3461: )AND
3462: ( p_disposition_rec.summary IS NOT NULL OR p_disposition_rec.problem_code IS NOT NULL

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

3455: -- End fix for bug 4243200
3456:
3457: IF ((p_disposition_rec.instance_id IS NULL OR
3458: (nvl(p_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
3459: AND nvl(p_disposition_rec.condition_id, -1) <> fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
3460: )
3461: )AND
3462: ( p_disposition_rec.summary IS NOT NULL OR p_disposition_rec.problem_code IS NOT NULL
3463: OR p_disposition_rec.severity_id IS NOT NULL

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

3536: SELECT fl.lookup_code FROM fnd_lookup_values_vl FL
3537: WHERE fl.meaning = p_problem_meaning
3538: AND lookup_type = 'REQUEST_PROBLEM_CODE'
3539: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active,sysdate)) AND trunc(nvl(end_date_active,sysdate))
3540: AND (( NOT EXISTS (SELECT 1 FROM CS_SR_PROB_CODE_MAPPING_V WHERE INCIDENT_TYPE_ID = FND_PROFILE.Value('AHL_PRD_SR_TYPE')
3541: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))) )
3542: OR ( EXISTS (SELECT 1 FROM CS_SR_PROB_CODE_MAPPING_V MAP WHERE MAP.INCIDENT_TYPE_ID = FND_PROFILE.Value('AHL_PRD_SR_TYPE')
3543: AND MAP.INVENTORY_ITEM_ID IS NULL AND MAP.PROBLEM_CODE = FL.LOOKUP_CODE
3544: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(MAP.START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(MAP.END_DATE_ACTIVE,SYSDATE)))));

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

3538: AND lookup_type = 'REQUEST_PROBLEM_CODE'
3539: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active,sysdate)) AND trunc(nvl(end_date_active,sysdate))
3540: AND (( NOT EXISTS (SELECT 1 FROM CS_SR_PROB_CODE_MAPPING_V WHERE INCIDENT_TYPE_ID = FND_PROFILE.Value('AHL_PRD_SR_TYPE')
3541: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))) )
3542: OR ( EXISTS (SELECT 1 FROM CS_SR_PROB_CODE_MAPPING_V MAP WHERE MAP.INCIDENT_TYPE_ID = FND_PROFILE.Value('AHL_PRD_SR_TYPE')
3543: AND MAP.INVENTORY_ITEM_ID IS NULL AND MAP.PROBLEM_CODE = FL.LOOKUP_CODE
3544: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(MAP.START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(MAP.END_DATE_ACTIVE,SYSDATE)))));
3545: */
3546: -- AnRaj: Changed query, Perf Bug#4908609,Issue#6

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

4315:
4316: -- Non-conformance request required. When tracked instance is in non-serviceable condition
4317: ELSIF (p_disposition_rec.immediate_disposition_code NOT IN ('NA','NOT_RECEIVED','NOT_REMOVED')
4318: AND l_disp_dtl_rec.trackable_flag = 'Y'
4319: AND (p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
4320: OR p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))
4321: AND p_disposition_rec.primary_service_request_id IS NULL) THEN
4322: x_status_code := 'NON_CONF_REQD';
4323:

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

4316: -- Non-conformance request required. When tracked instance is in non-serviceable condition
4317: ELSIF (p_disposition_rec.immediate_disposition_code NOT IN ('NA','NOT_RECEIVED','NOT_REMOVED')
4318: AND l_disp_dtl_rec.trackable_flag = 'Y'
4319: AND (p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE')
4320: OR p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))
4321: AND p_disposition_rec.primary_service_request_id IS NULL) THEN
4322: x_status_code := 'NON_CONF_REQD';
4323:
4324: --Mtl_txn required

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

4343: x_status_code := 'REMOVAL_COMP';
4344: --QA collection ID
4345: ELSIF (p_disposition_rec.immediate_disposition_code NOT IN ('NA','NOT_RECEIVED','NOT_REMOVED')
4346: AND p_disposition_rec.instance_id IS NOT NULL
4347: AND p_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
4348: AND p_disposition_rec.collection_id IS NULL)THEN
4349: x_status_code := 'PENDING_MRB';
4350:
4351: --Install required

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

4503:
4504: --If RTV/RTC/HOLD/REWORK_RR, condition has to be unserviceable or MRB
4505: IF (p_disposition_rec.secondary_disposition_code <> 'REWORK_NR' AND
4506: p_disposition_rec.secondary_disposition_code <> 'SCRAP' AND
4507: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
4508: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
4509: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_TYPE_COND_INV');
4510: FND_MSG_PUB.ADD;
4511: --If SCRAP, condition has to be MRB

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

4504: --If RTV/RTC/HOLD/REWORK_RR, condition has to be unserviceable or MRB
4505: IF (p_disposition_rec.secondary_disposition_code <> 'REWORK_NR' AND
4506: p_disposition_rec.secondary_disposition_code <> 'SCRAP' AND
4507: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
4508: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
4509: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_TYPE_COND_INV');
4510: FND_MSG_PUB.ADD;
4511: --If SCRAP, condition has to be MRB
4512: ELSIF (p_disposition_rec.secondary_disposition_code = 'SCRAP' AND

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

4509: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_TYPE_COND_INV');
4510: FND_MSG_PUB.ADD;
4511: --If SCRAP, condition has to be MRB
4512: ELSIF (p_disposition_rec.secondary_disposition_code = 'SCRAP' AND
4513: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
4514: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_TYPE_COND_INV');
4515: FND_MSG_PUB.ADD;
4516: END IF;
4517:

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

4517:
4518: ELSE
4519: --Use_as_is means condition must be serviceable
4520: IF (p_disposition_rec.immediate_disposition_code = 'USE_AS_IS' AND
4521: (p_disposition_rec.condition_id=fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR
4522: p_disposition_rec.condition_id=fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))) THEN
4523: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_TYPE_COND_INV');
4524: FND_MSG_PUB.ADD;
4525: END IF;

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

4518: ELSE
4519: --Use_as_is means condition must be serviceable
4520: IF (p_disposition_rec.immediate_disposition_code = 'USE_AS_IS' AND
4521: (p_disposition_rec.condition_id=fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') OR
4522: p_disposition_rec.condition_id=fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'))) THEN
4523: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_TYPE_COND_INV');
4524: FND_MSG_PUB.ADD;
4525: END IF;
4526: --SCRAP means condition is MRB

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

4524: FND_MSG_PUB.ADD;
4525: END IF;
4526: --SCRAP means condition is MRB
4527: IF (p_disposition_rec.immediate_disposition_code = 'SCRAP' AND
4528: p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
4529: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_TYPE_COND_INV');
4530: FND_MSG_PUB.ADD;
4531: END IF;
4532: --not BFS or NON_CONF, secondary must be null

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

4575: CLOSE get_disp_rec_csr;
4576:
4577: --Validate that condition id flows only 1 way.
4578: --'MRB' must stay as MRB
4579: IF (l_disp_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
4580: AND p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
4581: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_COND_CHANGE_INV');
4582: FND_MESSAGE.Set_Token('OLD_CONDITION', l_disp_rec.condition_code);
4583: FND_MESSAGE.Set_Token('NEW_CONDITION', p_disposition_rec.condition_meaning);

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

4576:
4577: --Validate that condition id flows only 1 way.
4578: --'MRB' must stay as MRB
4579: IF (l_disp_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')
4580: AND p_disposition_rec.condition_id <> fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
4581: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_COND_CHANGE_INV');
4582: FND_MESSAGE.Set_Token('OLD_CONDITION', l_disp_rec.condition_code);
4583: FND_MESSAGE.Set_Token('NEW_CONDITION', p_disposition_rec.condition_meaning);
4584: FND_MSG_PUB.ADD;

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

4582: FND_MESSAGE.Set_Token('OLD_CONDITION', l_disp_rec.condition_code);
4583: FND_MESSAGE.Set_Token('NEW_CONDITION', p_disposition_rec.condition_meaning);
4584: FND_MSG_PUB.ADD;
4585: --Unserviceable cannot become serviceable
4586: ELSIF (l_disp_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
4587: p_disposition_rec.condition_id<>fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
4588: p_disposition_rec.condition_id<>fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
4589: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_COND_CHANGE_INV');
4590: FND_MESSAGE.Set_Token('OLD_CONDITION', l_disp_rec.condition_code);

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

4583: FND_MESSAGE.Set_Token('NEW_CONDITION', p_disposition_rec.condition_meaning);
4584: FND_MSG_PUB.ADD;
4585: --Unserviceable cannot become serviceable
4586: ELSIF (l_disp_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
4587: p_disposition_rec.condition_id<>fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
4588: p_disposition_rec.condition_id<>fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
4589: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_COND_CHANGE_INV');
4590: FND_MESSAGE.Set_Token('OLD_CONDITION', l_disp_rec.condition_code);
4591: FND_MESSAGE.Set_Token('NEW_CONDITION', p_disposition_rec.condition_meaning);

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

4584: FND_MSG_PUB.ADD;
4585: --Unserviceable cannot become serviceable
4586: ELSIF (l_disp_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
4587: p_disposition_rec.condition_id<>fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE') AND
4588: p_disposition_rec.condition_id<>fnd_profile.value('AHL_MTL_MAT_STATUS_MRB')) THEN
4589: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_PRD_DISP_COND_CHANGE_INV');
4590: FND_MESSAGE.Set_Token('OLD_CONDITION', l_disp_rec.condition_code);
4591: FND_MESSAGE.Set_Token('NEW_CONDITION', p_disposition_rec.condition_meaning);
4592: FND_MSG_PUB.ADD;