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_MTLTXN_PVT dependencies on WIP_CONSTANTS

Line 538: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN

534:
535:
536: --Convert Problem_code_Meaning to Problem_code incase of returns
537:
538: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
539: IF (p_x_ahl_mtltxn_rec.Problem_Code IS NULL
540: OR p_x_ahl_mtltxn_rec.Problem_Code = FND_API.G_MISS_CHAR) THEN
541: IF (p_x_ahl_mtltxn_rec.Problem_Code_Meaning IS NOT NULL
542: AND p_x_ahl_mtltxn_rec.Problem_Code_Meaning <> FND_API.G_MISS_CHAR) THEN

Line 598: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)

594: OPEN RECEPIENT_CUR(p_x_ahl_mtltxn_rec.RECEPIENT_NAME);
595: FETCH RECEPIENT_CUR INTO p_x_ahl_mtltxn_rec.RECEPIENT_ID;
596: IF(RECEPIENT_CUR%NOTFOUND)
597: THEN
598: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
599: THEN
600: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
601: ELSE
602: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');

Line 620: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)

616: OPEN RECEPIENT_CUR(p_x_ahl_mtltxn_rec.RECEPIENT_NAME);
617: FETCH RECEPIENT_CUR INTO l_recepient_id;
618: IF(RECEPIENT_CUR%NOTFOUND)
619: THEN
620: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
621: THEN
622: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
623: ELSE
624: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');

Line 635: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)

631: IF(p_x_ahl_mtltxn_rec.recepient_id IS NOT NULL AND p_x_ahl_mtltxn_rec.recepient_id <> FND_API.G_MISS_NUM)
632: THEN
633: IF(l_recepient_id <> p_x_ahl_mtltxn_rec.RECEPIENT_ID)
634: THEN
635: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
636: THEN
637: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
638: ELSE
639: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');

Line 658: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)

654: IF(p_x_ahl_mtltxn_rec.recepient_id IS NULL OR p_x_ahl_mtltxn_rec.recepient_id = FND_API.G_MISS_NUM)
655: THEN
656: IF(NVL(FND_PROFILE.VALUE('AHL_PRD_MTX_RECEPIENT'),'N')='Y')
657: THEN
658: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
659: THEN
660: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_MANDATORY2');
661: ELSE
662: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_MANDATORY');

Line 671: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)

667: OPEN DEFAULT_USER_CUR;
668: FETCH DEFAULT_USER_CUR INTO p_x_ahl_mtltxn_rec.RECEPIENT_ID;
669: IF DEFAULT_USER_CUR%NOTFOUND
670: THEN
671: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
672: THEN
673: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
674: ELSE
675: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');

Line 1012: --IF (p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN

1008: If(Sch_Mtl_Exists_Cur%NOTFOUND) THEN
1009:
1010: --Check if the material exists in the AHL_SCHEDULE_MATERIALS table
1011: --for the given work order operation id.
1012: --IF (p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN
1013:
1014: Insert_Sch_Mtl_Row( p_mtl_txn_rec => p_x_ahl_mtltxn_tbl(i),
1015: x_return_status => x_Return_Status,
1016: x_msg_count => x_Msg_Count,

Line 1194: IF (p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN

1190: -- to ensure that quantity is not updated to NULL in mtl_txn rows
1191: -- Tamal: Bug #4095376: End
1192:
1193: -- Update Completion quantity for cMRO-APS integration.
1194: IF (p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN
1195: -- Issue Txn.
1196: UPDATE AHL_SCHEDULE_MATERIALS
1197: SET completed_quantity = nvl(completed_quantity,0) + l_quantity,
1198: object_version_number = l_object_version_number + 1

Line 1202: ELSIF (p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN

1198: object_version_number = l_object_version_number + 1
1199: WHERE CURRENT OF Sch_Mtl_Cur;
1200: -- 11/20: Commented out updation of completed quantity to fix bug# 6598809
1201: /*
1202: ELSIF (p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
1203: -- Return Txn.
1204: UPDATE AHL_SCHEDULE_MATERIALS
1205: SET completed_quantity = nvl(completed_quantity,0) - l_quantity,
1206: object_version_number = l_object_version_number + 1

Line 1291: (p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN

1287: p_x_ahl_mtltxn_tbl(i).ahl_mtltxn_id := l_x_Mtl_Txn_Id;
1288:
1289: -- For trackable returns, update ahl_parts_change table for return_mtl_txn_id.
1290: IF (l_instance_id_tbl(i) IS NOT NULL) AND
1291: (p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
1292: AHL_PRD_PARTS_CHANGE_PVT.Update_Material_Return
1293: (
1294: p_return_mtl_txn_id => l_x_Mtl_Txn_Id,
1295: p_workorder_id => p_x_ahl_mtltxn_tbl(i).workorder_id,

Line 1344: IF ((p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)

1340: --If (condition is unserviceable/MRB AND P_create_SR == 'Y' ) then
1341: --Select EMP_ID from FND_USERS table for the FND_GLOBAL.USER_ID
1342: --Call Service request API to create service request.
1343: --( AHL_NONROUTINE_JOB_PVT.process_nonroutine_job)
1344: IF ((p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
1345: AND l_eam_item_type_id_tbl(i) = wip_constants.rebuild_item_type
1346: AND (p_x_ahl_mtltxn_tbl(i).Condition = G_AHL_UNSERVICEABLE_CONDITION
1347: OR p_x_ahl_mtltxn_tbl(i).Condition = G_AHL_MRB_CONDITION)
1348: AND (p_create_sr = 'Y')

Line 1345: AND l_eam_item_type_id_tbl(i) = wip_constants.rebuild_item_type

1341: --Select EMP_ID from FND_USERS table for the FND_GLOBAL.USER_ID
1342: --Call Service request API to create service request.
1343: --( AHL_NONROUTINE_JOB_PVT.process_nonroutine_job)
1344: IF ((p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
1345: AND l_eam_item_type_id_tbl(i) = wip_constants.rebuild_item_type
1346: AND (p_x_ahl_mtltxn_tbl(i).Condition = G_AHL_UNSERVICEABLE_CONDITION
1347: OR p_x_ahl_mtltxn_tbl(i).Condition = G_AHL_MRB_CONDITION)
1348: AND (p_create_sr = 'Y')
1349: AND (l_instance_id_tbl(i) IS NOT NULL)

Line 1418: IF (p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE AND

1414: -- Fix for bug# 5501482.
1415: IF (p_x_ahl_mtltxn_tbl.COUNT > 0) THEN
1416:
1417: FOR i IN p_x_ahl_mtltxn_tbl.FIRST..p_x_ahl_mtltxn_tbl.LAST LOOP
1418: IF (p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE AND
1419: p_x_ahl_mtltxn_tbl(i).Condition = G_AHL_MRB_CONDITION AND
1420: p_x_ahl_mtltxn_tbl(i).disposition_id IS NULL AND
1421: p_x_ahl_mtltxn_tbl(i).Qa_Collection_Id IS NOT NULL AND FND_API.to_boolean( p_commit )) THEN
1422: QA_SS_RESULTS.wrapper_fire_action

Line 1942: IF(p_x_ahl_mtltxn_rec.Transaction_Type_Id <> WIP_CONSTANTS.RETCOMP_TYPE AND

1938: AHL_DEBUG_PUB.debug('Ahl Validating TxnType...['||to_Char(p_x_ahl_mtltxn_rec.Transaction_Type_Id)||']');
1939: END IF;
1940:
1941: -- Validate transaction type id(should be one of wip conponent issue or return
1942: IF(p_x_ahl_mtltxn_rec.Transaction_Type_Id <> WIP_CONSTANTS.RETCOMP_TYPE AND
1943: p_x_ahl_mtltxn_rec.Transaction_Type_Id <> WIP_CONSTANTS.ISSCOMP_TYPE ) THEN
1944: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXNTYPE');
1945: FND_MSG_PUB.ADD;
1946: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1943: p_x_ahl_mtltxn_rec.Transaction_Type_Id <> WIP_CONSTANTS.ISSCOMP_TYPE ) THEN

1939: END IF;
1940:
1941: -- Validate transaction type id(should be one of wip conponent issue or return
1942: IF(p_x_ahl_mtltxn_rec.Transaction_Type_Id <> WIP_CONSTANTS.RETCOMP_TYPE AND
1943: p_x_ahl_mtltxn_rec.Transaction_Type_Id <> WIP_CONSTANTS.ISSCOMP_TYPE ) THEN
1944: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXNTYPE');
1945: FND_MSG_PUB.ADD;
1946: x_return_status := FND_API.G_RET_STS_ERROR;
1947: END IF;

Line 2036: If p_x_ahl_mtltxn_rec.transaction_type_id= WIP_CONSTANTS.RETCOMP_TYPE

2032: IF G_DEBUG='Y' THEN
2033: AHL_DEBUG_PUB.debug('Validating item_id['||to_Char(p_x_ahl_mtltxn_rec.Organization_ID)||','||to_Char(p_x_ahl_mtltxn_rec.Inventory_Item_Id)||']');
2034: END IF;
2035:
2036: If p_x_ahl_mtltxn_rec.transaction_type_id= WIP_CONSTANTS.RETCOMP_TYPE
2037: and p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id is null
2038: then
2039:
2040: Validate_item_duplic

Line 2092: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)

2088:
2089:
2090: -- default project locator if move_to_project flag is checked.(ER 5854712).
2091: -- For return txns only.
2092: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
2093: AND (p_x_ahl_mtltxn_rec.move_to_project_flag = 'Y') THEN
2094: IF (l_inv_locator_id IS NOT NULL) THEN
2095: IF G_DEBUG='Y' THEN
2096: AHL_DEBUG_PUB.debug('Defaulting from Visit Locator['||l_inv_locator_id||','|| l_project_id ||',' || l_project_task_id || ']');

Line 2183: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN

2179: AHL_DEBUG_PUB.debug('Validating Create WO Option['||p_x_ahl_mtltxn_rec.create_wo_option ||']');
2180: END IF;
2181:
2182: -- Validate Create WO Option lookup code.
2183: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
2184: IF (p_x_ahl_mtltxn_rec.create_wo_option IS NULL OR
2185: p_x_ahl_mtltxn_rec.create_wo_option = FND_API.G_MISS_CHAR) THEN
2186: IF (nvl(l_serial_Control,0) = C_NO_SERIAL_CONTROL) THEN
2187: p_x_ahl_mtltxn_rec.create_wo_option := 'CREATE_SR_NO';

Line 2367: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN

2363: END IF;
2364: CLOSE AHL_REASON_CUR;
2365: END IF;
2366:
2367: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
2368: --Condition Validation
2369: OPEN Condition_Cur(p_x_ahl_mtltxn_rec.Condition);
2370: FETCH Condition_Cur INTO l_Count;
2371: IF(Condition_Cur%NOTFOUND) THEN

Line 2416: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN

2412: END IF;
2413: END IF;
2414:
2415: --If the Transaction_type_id is WIP RETURN
2416: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
2417:
2418:
2419: --If the item is trackkable check if the parent item
2420: --exists for the item, if exists return error : AHL_MTL_TXN_NOT_ALLOWED

Line 2715: (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN

2711: -- that from mtl_serial_numbers.
2712: IF (p_x_ahl_mtltxn_rec.Serial_Number IS NOT NULL) AND
2713: (p_x_ahl_mtltxn_rec.Serial_Number <> FND_API.G_MISS_CHAR) AND
2714: (nvl(l_serial_Control,0) <> 1) AND
2715: (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN
2716: OPEN mtl_srl_num_csr(p_x_ahl_mtltxn_rec.Organization_ID,
2717: p_x_ahl_mtltxn_rec.Inventory_Item_id,
2718: p_x_ahl_mtltxn_rec.Serial_Number);
2719: FETCH mtl_srl_num_csr INTO l_curr_subinventory_code, l_curr_locator_id;

Line 2984: if(p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN

2980: IF(p_x_ahl_mtltxn_rec.Locator_Id IS NOT NULL
2981: AND p_x_ahl_mtltxn_rec.Locator_Id <> FND_API.G_MISS_NUM) THEN
2982: l_mmtt_rec.LOCATOR_ID := p_x_ahl_mtltxn_rec.Locator_Id;
2983: END IF;
2984: if(p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN
2985: l_mmtt_rec.TRANSACTION_QUANTITY := - p_x_ahl_mtltxn_rec.Quantity;
2986: l_mmtt_rec.PRIMARY_QUANTITY := - p_x_ahl_mtltxn_rec.Quantity;
2987: ELSE
2988: l_mmtt_rec.TRANSACTION_QUANTITY := p_x_ahl_mtltxn_rec.Quantity;

Line 3009: l_mmtt_rec.WIP_ENTITY_TYPE := WIP_CONSTANTS.DISCRETE;

3005: END IF;
3006: --l_mmtt_rec.LOT_NUMBER := p_lot_number;
3007: --l_mmtt_rec.LOT_EXPIRATION_DATE :=
3008: --l_mmtt_rec.SERIAL_NUMBER := p_srl_number;
3009: l_mmtt_rec.WIP_ENTITY_TYPE := WIP_CONSTANTS.DISCRETE;
3010: l_mmtt_rec.WIP_SUPPLY_TYPE := 3;
3011: l_mmtt_rec.OPERATION_SEQ_NUM := p_x_ahl_mtltxn_rec.Operation_Seq_Num;
3012: --l_mmtt_rec.ITEM_LOCATION_CONTROL_CODE :=
3013: l_mmtt_rec.PROCESS_FLAG := l_Process_Flag;

Line 3593: if(p_x_ahl_mtl_txn_rec.Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN

3589: END IF;
3590: IF(p_x_ahl_mtl_txn_rec.Locator_Id = FND_API.G_MISS_NUM) THEN
3591: p_x_ahl_mtl_txn_rec.Locator_Id := NULL;
3592: END IF;
3593: if(p_x_ahl_mtl_txn_rec.Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN
3594: IF (p_eam_item_type_id = WIP_CONSTANTS.rebuild_item_type AND p_x_ahl_mtl_txn_rec.Quantity > 1) THEN
3595: l_qty := - 1;
3596: l_loop_count := l_loop_count + 1;
3597: ELSE

Line 3594: IF (p_eam_item_type_id = WIP_CONSTANTS.rebuild_item_type AND p_x_ahl_mtl_txn_rec.Quantity > 1) THEN

3590: IF(p_x_ahl_mtl_txn_rec.Locator_Id = FND_API.G_MISS_NUM) THEN
3591: p_x_ahl_mtl_txn_rec.Locator_Id := NULL;
3592: END IF;
3593: if(p_x_ahl_mtl_txn_rec.Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN
3594: IF (p_eam_item_type_id = WIP_CONSTANTS.rebuild_item_type AND p_x_ahl_mtl_txn_rec.Quantity > 1) THEN
3595: l_qty := - 1;
3596: l_loop_count := l_loop_count + 1;
3597: ELSE
3598: l_qty := - p_x_ahl_mtl_txn_rec.Quantity;

Line 3602: IF (p_eam_item_type_id = WIP_CONSTANTS.rebuild_item_type AND p_x_ahl_mtl_txn_rec.Quantity > 1) THEN

3598: l_qty := - p_x_ahl_mtl_txn_rec.Quantity;
3599: l_loop_count := p_x_ahl_mtl_txn_rec.Quantity + 1;
3600: END IF;
3601: ELSE
3602: IF (p_eam_item_type_id = WIP_CONSTANTS.rebuild_item_type AND p_x_ahl_mtl_txn_rec.Quantity > 1) THEN
3603: l_qty := 1;
3604: l_loop_count := l_loop_count + 1;
3605: ELSE
3606: l_qty := p_x_ahl_mtl_txn_rec.Quantity;

Line 3840: WIP_CONSTANTS.DISCRETE, p_x_ahl_mtl_txn_rec.Operation_Seq_Num,

3836: l_qty, p_x_ahl_mtl_txn_rec.Uom,
3837: p_x_ahl_mtl_txn_rec.Transaction_Date, p_x_ahl_mtl_txn_rec.Subinventory_Name,
3838: p_x_ahl_mtl_txn_rec.Locator_Id, p_x_ahl_mtl_txn_rec.Transaction_Type_Id,
3839: p_x_ahl_mtl_txn_rec.Revision, p_x_ahl_mtl_txn_rec.Transaction_Reference,
3840: WIP_CONSTANTS.DISCRETE, p_x_ahl_mtl_txn_rec.Operation_Seq_Num,
3841: l_txn_source_type, p_x_ahl_mtl_txn_rec.Wip_Entity_id,
3842: p_x_ahl_mtl_txn_rec.Operation_Seq_Num, -- TRX_SOURCE_LINE_ID (needed for relieving reservations)
3843: p_x_ahl_mtl_txn_rec.Attribute_Category, p_x_ahl_mtl_txn_rec.Attribute1,
3844: p_x_ahl_mtl_txn_rec.Attribute2, p_x_ahl_mtl_txn_rec.Attribute3,