DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_PRD_PARTS_CHANGE_PVT

Line 1354: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition with ' ||

1350: -- Change by jaramana on 06-DEC-2011 to capture instance condition in IB
1351: -- Functionality required as part of Various Execution Enhancements (VEE)
1352: -- Part Removal has happened: Update Instance condition
1353: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1354: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition with ' ||
1355: ' p_instance_id = ' || l_removed_instance_id ||
1356: ', and p_instance_condition_id = ' || p_x_disposition_rec.condition_id);
1357: END IF;
1358: AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition(p_init_msg_list => FND_API.G_FALSE,

Line 1358: AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition(p_init_msg_list => FND_API.G_FALSE,

1354: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition with ' ||
1355: ' p_instance_id = ' || l_removed_instance_id ||
1356: ', and p_instance_condition_id = ' || p_x_disposition_rec.condition_id);
1357: END IF;
1358: AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition(p_init_msg_list => FND_API.G_FALSE,
1359: p_commit => FND_API.G_FALSE,
1360: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1361: p_instance_id => l_removed_instance_id,
1362: p_instance_condition_id => p_x_disposition_rec.condition_id,

Line 1367: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition: ' ||

1363: x_return_status => x_return_status,
1364: x_msg_data => x_msg_data,
1365: x_msg_count => x_msg_count);
1366: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1367: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition: ' ||
1368: ' x_return_status = ' || x_return_status);
1369: END IF;
1370: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1371: RAISE FND_API.G_EXC_ERROR;

Line 1381: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator with ' ||

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 ||
1383: ' and disposition_id = ' || p_x_disposition_rec.disposition_id);
1384: END IF;
1385: AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator(p_part_change_id => p_x_disposition_rec.part_change_id,

Line 1385: AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator(p_part_change_id => p_x_disposition_rec.part_change_id,

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 ||
1383: ' and disposition_id = ' || p_x_disposition_rec.disposition_id);
1384: END IF;
1385: AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator(p_part_change_id => p_x_disposition_rec.part_change_id,
1386: p_disposition_id => p_x_disposition_rec.disposition_id,
1387: x_return_status => x_return_status,
1388: x_msg_data => x_msg_data,
1389: x_msg_count => x_msg_count,

Line 1393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator: ' ||

1389: x_msg_count => x_msg_count,
1390: x_ahl_mtltxn_rec => l_ahl_mtltxn_rec);
1391:
1392: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator: ' ||
1394: ' x_return_status = ' || x_return_status);
1395: END IF;
1396: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1397: RAISE FND_API.G_EXC_ERROR;

Line 1642: l_move_item_ins_tbl AHL_PRD_PARTS_CHANGE_PVT.move_item_instance_tbl_type;

1638: l_ahl_mtltxn_rec AHL_PRD_MTLTXN_PVT.Ahl_Mtltxn_Rec_Type;
1639: l_dummy VARCHAR(1);
1640:
1641: -- SATHAPLI::Bug 7111116, 21-May-2008
1642: l_move_item_ins_tbl AHL_PRD_PARTS_CHANGE_PVT.move_item_instance_tbl_type;
1643: l_rel_nm_wo_id NUMBER;
1644: l_primary_sr_created BOOLEAN := FALSE;
1645:
1646: cursor is_qa_coll_reqd(p_plan_id IN NUMBER) IS

Line 2456: 'About to call the API AHL_PRD_PARTS_CHANGE_PVT.move_instance_location with the parameters:'||

2452: l_move_item_ins_tbl(1).to_workorder_id := l_rel_nm_wo_id;
2453:
2454: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2455: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key,
2456: 'About to call the API AHL_PRD_PARTS_CHANGE_PVT.move_instance_location with the parameters:'||
2457: ' instance_id => '||l_removed_instance_id||
2458: ' ,quantity => '||p_x_disposition_rec.quantity||
2459: ' ,to_workorder_id => '||l_rel_nm_wo_id);
2460: END IF;

Line 2463: AHL_PRD_PARTS_CHANGE_PVT.move_instance_location(

2459: ' ,to_workorder_id => '||l_rel_nm_wo_id);
2460: END IF;
2461:
2462: -- call the required API
2463: AHL_PRD_PARTS_CHANGE_PVT.move_instance_location(
2464: p_api_version => 1.0,
2465: p_init_msg_list => FND_API.G_FALSE,
2466: p_commit => FND_API.G_FALSE,
2467: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2478: 'Call to the API AHL_PRD_PARTS_CHANGE_PVT.move_instance_location returned with status => '||x_return_status);

2474: );
2475:
2476: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2477: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key,
2478: 'Call to the API AHL_PRD_PARTS_CHANGE_PVT.move_instance_location returned with status => '||x_return_status);
2479: END IF;
2480:
2481: -- check the API call return status
2482: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 2533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition with ' ||

2529: -- Change by jaramana on 06-DEC-2011 to capture instance condition in IB
2530: -- Functionality required as part of Various Execution Enhancements (VEE)
2531: -- Part Removal has happened: Update Instance condition
2532: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition with ' ||
2534: ' p_instance_id = ' || l_removed_instance_id ||
2535: ', and p_instance_condition_id = ' || p_x_disposition_rec.condition_id);
2536: END IF;
2537: AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition(p_init_msg_list => FND_API.G_FALSE,

Line 2537: AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition(p_init_msg_list => FND_API.G_FALSE,

2533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition with ' ||
2534: ' p_instance_id = ' || l_removed_instance_id ||
2535: ', and p_instance_condition_id = ' || p_x_disposition_rec.condition_id);
2536: END IF;
2537: AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition(p_init_msg_list => FND_API.G_FALSE,
2538: p_commit => FND_API.G_FALSE,
2539: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2540: p_instance_id => l_removed_instance_id,
2541: p_instance_condition_id => p_x_disposition_rec.condition_id,

Line 2546: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition: ' ||

2542: x_return_status => x_return_status,
2543: x_msg_data => x_msg_data,
2544: x_msg_count => x_msg_count);
2545: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2546: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from AHL_PRD_PARTS_CHANGE_PVT.Update_Part_Condition: ' ||
2547: ' x_return_status = ' || x_return_status);
2548: END IF;
2549: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2550: RAISE FND_API.G_EXC_ERROR;

Line 2560: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator with ' ||

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 ||
2562: ' and disposition_id = ' || p_x_disposition_rec.disposition_id);
2563: END IF;
2564: AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator(p_part_change_id => p_x_disposition_rec.part_change_id,

Line 2564: AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator(p_part_change_id => p_x_disposition_rec.part_change_id,

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 ||
2562: ' and disposition_id = ' || p_x_disposition_rec.disposition_id);
2563: END IF;
2564: AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator(p_part_change_id => p_x_disposition_rec.part_change_id,
2565: p_disposition_id => p_x_disposition_rec.disposition_id,
2566: x_return_status => x_return_status,
2567: x_msg_data => x_msg_data,
2568: x_msg_count => x_msg_count,

Line 2571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator: ' ||

2567: x_msg_data => x_msg_data,
2568: x_msg_count => x_msg_count,
2569: x_ahl_mtltxn_rec => l_ahl_mtltxn_rec);
2570: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator: ' ||
2572: ' x_return_status = ' || x_return_status);
2573: END IF;
2574: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2575: RAISE FND_API.G_EXC_ERROR;

Line 2643: l_move_item_ins_tbl AHL_PRD_PARTS_CHANGE_PVT.move_item_instance_tbl_type;

2639: WHERE workorder_id = p_workorder_id;
2640:
2641:
2642: l_rel_nm_wo_id NUMBER;
2643: l_move_item_ins_tbl AHL_PRD_PARTS_CHANGE_PVT.move_item_instance_tbl_type;
2644:
2645: l_sr_task_tbl AHL_PRD_NONROUTINE_PVT.sr_task_tbl_type;
2646: l_visit_id NUMBER;
2647:

Line 2898: 'About to call the API AHL_PRD_PARTS_CHANGE_PVT.move_instance_location with the parameters:'||

2894: l_move_item_ins_tbl(1).to_workorder_id := l_rel_nm_wo_id;
2895:
2896: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2897: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key,
2898: 'About to call the API AHL_PRD_PARTS_CHANGE_PVT.move_instance_location with the parameters:'||
2899: ' instance_id => ' || l_removed_instance_id ||
2900: ', quantity => ' || p_disposition_rec.quantity ||
2901: ', from Work order id: ' || p_disposition_rec.workorder_id ||
2902: ', to_workorder_id => '||l_rel_nm_wo_id);

Line 2906: AHL_PRD_PARTS_CHANGE_PVT.move_instance_location(

2902: ', to_workorder_id => '||l_rel_nm_wo_id);
2903: END IF;
2904:
2905: -- call the required API
2906: AHL_PRD_PARTS_CHANGE_PVT.move_instance_location(
2907: p_api_version => 1.0,
2908: p_init_msg_list => FND_API.G_FALSE,
2909: p_commit => FND_API.G_FALSE,
2910: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2921: 'Call to the API AHL_PRD_PARTS_CHANGE_PVT.move_instance_location returned with status => '||x_return_status);

2917: );
2918:
2919: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2920: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key,
2921: 'Call to the API AHL_PRD_PARTS_CHANGE_PVT.move_instance_location returned with status => '||x_return_status);
2922: END IF;
2923:
2924: -- check the API call return status
2925: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 4389: AHL_PRD_PARTS_CHANGE_PVT.Get_Unit_Config_Information(p_item_instance_id => NULL,

4385: FETCH instance_in_disp_csr INTO l_exist;
4386: IF instance_in_disp_csr%FOUND THEN
4387: -- Added by jaramana on August 7, 2007 to support IB Trees
4388: -- Allow duplicate instances for IB Trees when created from Part Change
4389: AHL_PRD_PARTS_CHANGE_PVT.Get_Unit_Config_Information(p_item_instance_id => NULL,
4390: p_workorder_id => p_workorder_id,
4391: x_unit_config_id => l_unit_config_id,
4392: x_unit_config_name => l_unit_config_name,
4393: x_return_status => l_return_status);