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 552: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN

548:
549:
550: --Convert Problem_code_Meaning to Problem_code incase of returns
551:
552: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
553: IF (p_x_ahl_mtltxn_rec.Problem_Code IS NULL
554: OR p_x_ahl_mtltxn_rec.Problem_Code = FND_API.G_MISS_CHAR) THEN
555: IF (p_x_ahl_mtltxn_rec.Problem_Code_Meaning IS NOT NULL
556: AND p_x_ahl_mtltxn_rec.Problem_Code_Meaning <> FND_API.G_MISS_CHAR) THEN

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

608: OPEN RECEPIENT_CUR(p_x_ahl_mtltxn_rec.RECEPIENT_NAME);
609: FETCH RECEPIENT_CUR INTO p_x_ahl_mtltxn_rec.RECEPIENT_ID;
610: IF(RECEPIENT_CUR%NOTFOUND)
611: THEN
612: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
613: THEN
614: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
615: ELSE
616: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');

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

630: OPEN RECEPIENT_CUR(p_x_ahl_mtltxn_rec.RECEPIENT_NAME);
631: FETCH RECEPIENT_CUR INTO l_recepient_id;
632: IF(RECEPIENT_CUR%NOTFOUND)
633: THEN
634: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
635: THEN
636: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
637: ELSE
638: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');

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

645: IF(p_x_ahl_mtltxn_rec.recepient_id IS NOT NULL AND p_x_ahl_mtltxn_rec.recepient_id <> FND_API.G_MISS_NUM)
646: THEN
647: IF(l_recepient_id <> p_x_ahl_mtltxn_rec.RECEPIENT_ID)
648: THEN
649: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
650: THEN
651: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
652: ELSE
653: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');

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

668: IF(p_x_ahl_mtltxn_rec.recepient_id IS NULL OR p_x_ahl_mtltxn_rec.recepient_id = FND_API.G_MISS_NUM)
669: THEN
670: IF(NVL(FND_PROFILE.VALUE('AHL_PRD_MTX_RECEPIENT'),'N')='Y')
671: THEN
672: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
673: THEN
674: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_MANDATORY2');
675: ELSE
676: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_MANDATORY');

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

681: OPEN DEFAULT_USER_CUR;
682: FETCH DEFAULT_USER_CUR INTO p_x_ahl_mtltxn_rec.RECEPIENT_ID;
683: IF DEFAULT_USER_CUR%NOTFOUND
684: THEN
685: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
686: THEN
687: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID2');
688: ELSE
689: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_INVALID');

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

1098: If(Sch_Mtl_Exists_Cur%NOTFOUND) THEN
1099:
1100: --Check if the material exists in the AHL_SCHEDULE_MATERIALS table
1101: --for the given work order operation id.
1102: --IF (p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN
1103:
1104: Insert_Sch_Mtl_Row( p_mtl_txn_rec => p_x_ahl_mtltxn_tbl(i),
1105: x_return_status => x_Return_Status,
1106: x_msg_count => x_Msg_Count,

Line 1201: IF (l_eam_item_type_id_tbl(i) = wip_constants.rebuild_item_type AND p_x_ahl_mtltxn_tbl(i).Quantity > 1) THEN

1197: FOR i IN l_txn_Id_Tbl.FIRST..l_txn_Id_Tbl.LAST LOOP
1198:
1199: -- SORAO :: Changed for USAF backporting project :: Feb 2012
1200: -- modified for multiple txns case. fix for bug# 13689288
1201: IF (l_eam_item_type_id_tbl(i) = wip_constants.rebuild_item_type AND p_x_ahl_mtltxn_tbl(i).Quantity > 1) THEN
1202: OPEN m_Txn_Error_cur(p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id, p_x_ahl_mtltxn_tbl(i).workorder_id, l_Txn_Header_Id);
1203: FETCH m_Txn_Error_cur INTO l_error_msg,l_error_code,
1204: l_concatenated_segments, l_workorder_name;
1205: IF(m_Txn_Error_cur%FOUND AND (l_error_code IS NOT NULL

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

1315: -- to ensure that quantity is not updated to NULL in mtl_txn rows
1316: -- Tamal: Bug #4095376: End
1317:
1318: -- Update Completion quantity for cMRO-APS integration.
1319: IF (p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN
1320: -- Issue Txn.
1321: UPDATE AHL_SCHEDULE_MATERIALS
1322: SET completed_quantity = nvl(completed_quantity,0) + l_quantity,
1323: object_version_number = l_object_version_number + 1

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

1323: object_version_number = l_object_version_number + 1
1324: WHERE CURRENT OF Sch_Mtl_Cur;
1325: -- 11/20: Commented out updation of completed quantity to fix bug# 6598809
1326: /*
1327: ELSIF (p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
1328: -- Return Txn.
1329: UPDATE AHL_SCHEDULE_MATERIALS
1330: SET completed_quantity = nvl(completed_quantity,0) - l_quantity,
1331: object_version_number = l_object_version_number + 1

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

1412: p_x_ahl_mtltxn_tbl(i).ahl_mtltxn_id := l_x_Mtl_Txn_Id;
1413:
1414: -- for trackable returns ..
1415: IF (l_instance_id_tbl(i) IS NOT NULL) AND
1416: (p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
1417: -- For trackable returns, update ahl_parts_change table for return_mtl_txn_id.
1418: AHL_PRD_PARTS_CHANGE_PVT.Update_Material_Return
1419: (
1420: p_return_mtl_txn_id => l_x_Mtl_Txn_Id,

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

1629: --If (condition is unserviceable/MRB AND P_create_SR == 'Y' ) then
1630: --Select EMP_ID from FND_USERS table for the FND_GLOBAL.USER_ID
1631: --Call Service request API to create service request.
1632: --( AHL_NONROUTINE_JOB_PVT.process_nonroutine_job)
1633: IF ((p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
1634: AND l_eam_item_type_id_tbl(i) = wip_constants.rebuild_item_type
1635: AND (p_x_ahl_mtltxn_tbl(i).Condition = G_AHL_UNSERVICEABLE_CONDITION
1636: OR p_x_ahl_mtltxn_tbl(i).Condition = G_AHL_MRB_CONDITION)
1637: AND (p_create_sr = 'Y')

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

1630: --Select EMP_ID from FND_USERS table for the FND_GLOBAL.USER_ID
1631: --Call Service request API to create service request.
1632: --( AHL_NONROUTINE_JOB_PVT.process_nonroutine_job)
1633: IF ((p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
1634: AND l_eam_item_type_id_tbl(i) = wip_constants.rebuild_item_type
1635: AND (p_x_ahl_mtltxn_tbl(i).Condition = G_AHL_UNSERVICEABLE_CONDITION
1636: OR p_x_ahl_mtltxn_tbl(i).Condition = G_AHL_MRB_CONDITION)
1637: AND (p_create_sr = 'Y')
1638: AND (l_instance_id_tbl(i) IS NOT NULL)

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

1703: -- Fix for bug# 5501482.
1704: IF (p_x_ahl_mtltxn_tbl.COUNT > 0) THEN
1705:
1706: FOR i IN p_x_ahl_mtltxn_tbl.FIRST..p_x_ahl_mtltxn_tbl.LAST LOOP
1707: IF (p_x_ahl_mtltxn_tbl(i).Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE AND
1708: p_x_ahl_mtltxn_tbl(i).Condition = G_AHL_MRB_CONDITION AND
1709: p_x_ahl_mtltxn_tbl(i).disposition_id IS NULL AND
1710: p_x_ahl_mtltxn_tbl(i).Qa_Collection_Id IS NOT NULL AND FND_API.to_boolean( p_commit )) THEN
1711: QA_SS_RESULTS.wrapper_fire_action

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

2294: AHL_DEBUG_PUB.debug('Ahl Validating TxnType...['||to_Char(p_x_ahl_mtltxn_rec.Transaction_Type_Id)||']');
2295: END IF;
2296:
2297: -- Validate transaction type id(should be one of wip conponent issue or return
2298: IF(p_x_ahl_mtltxn_rec.Transaction_Type_Id <> WIP_CONSTANTS.RETCOMP_TYPE AND
2299: p_x_ahl_mtltxn_rec.Transaction_Type_Id <> WIP_CONSTANTS.ISSCOMP_TYPE ) THEN
2300: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXNTYPE');
2301: FND_MSG_PUB.ADD;
2302: x_return_status := FND_API.G_RET_STS_ERROR;

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

2295: END IF;
2296:
2297: -- Validate transaction type id(should be one of wip conponent issue or return
2298: IF(p_x_ahl_mtltxn_rec.Transaction_Type_Id <> WIP_CONSTANTS.RETCOMP_TYPE AND
2299: p_x_ahl_mtltxn_rec.Transaction_Type_Id <> WIP_CONSTANTS.ISSCOMP_TYPE ) THEN
2300: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INVALID_TXNTYPE');
2301: FND_MSG_PUB.ADD;
2302: x_return_status := FND_API.G_RET_STS_ERROR;
2303: END IF;

Line 2356: IF (p_x_ahl_mtltxn_rec.transaction_type_id = WIP_CONSTANTS.RETCOMP_TYPE) THEN

2352: IF G_DEBUG='Y' THEN
2353: AHL_DEBUG_PUB.debug('JOB validation success['||l_job_status||']');
2354: END IF;
2355: -- fix for re-open case in bug# 6773241
2356: IF (p_x_ahl_mtltxn_rec.transaction_type_id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
2357: IF(l_job_status <> C_JOB_RELEASED
2358: AND l_job_status <> C_JOB_PENDING_QA
2359: AND l_job_status <> C_JOB_COMPLETE
2360: --AND l_job_status <> C_JOB_PARTS_HOLD

Line 2410: If p_x_ahl_mtltxn_rec.transaction_type_id= WIP_CONSTANTS.RETCOMP_TYPE

2406: IF G_DEBUG='Y' THEN
2407: 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)||']');
2408: END IF;
2409:
2410: If p_x_ahl_mtltxn_rec.transaction_type_id= WIP_CONSTANTS.RETCOMP_TYPE
2411: and p_x_ahl_mtltxn_rec.Ahl_mtltxn_Id is null
2412: then
2413:
2414: Validate_item_duplic

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

2462:
2463:
2464: -- default project locator if move_to_project flag is checked.(ER 5854712).
2465: -- For return txns only.
2466: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
2467: AND (p_x_ahl_mtltxn_rec.move_to_project_flag = 'Y') THEN
2468: IF (l_inv_locator_id IS NOT NULL) THEN
2469: IF G_DEBUG='Y' THEN
2470: AHL_DEBUG_PUB.debug('Defaulting from Visit Locator['||l_inv_locator_id||','|| l_project_id ||',' || l_project_task_id || ']');

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

2553: AHL_DEBUG_PUB.debug('Validating Create WO Option['||p_x_ahl_mtltxn_rec.create_wo_option ||']');
2554: END IF;
2555:
2556: -- Validate Create WO Option lookup code.
2557: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
2558: IF (p_x_ahl_mtltxn_rec.create_wo_option IS NULL OR
2559: p_x_ahl_mtltxn_rec.create_wo_option = FND_API.G_MISS_CHAR) THEN
2560: IF (nvl(l_serial_Control,0) = C_NO_SERIAL_CONTROL) THEN
2561: p_x_ahl_mtltxn_rec.create_wo_option := 'CREATE_SR_NO';

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

2750: END IF;
2751: CLOSE AHL_REASON_CUR;
2752: END IF;
2753:
2754: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
2755: --Condition Validation
2756: OPEN Condition_Cur(p_x_ahl_mtltxn_rec.Condition);
2757: FETCH Condition_Cur INTO l_Count;
2758: IF(Condition_Cur%NOTFOUND) THEN

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

2799: END IF;
2800: END IF;
2801:
2802: --If the Transaction_type_id is WIP RETURN
2803: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE) THEN
2804:
2805:
2806: --If the item is trackkable check if the parent item
2807: --exists for the item, if exists return error : AHL_MTL_TXN_NOT_ALLOWED

Line 3070: WIP_CONSTANTS.RETCOMP_TYPE,

3066: AHL_DEBUG_PUB.debug('Checking pending txns: nonserial and lot controlled case');
3067: END IF;
3068: OPEN csi_pending_lot_txn(p_x_ahl_mtltxn_rec.Wip_Entity_Id,
3069: p_x_ahl_mtltxn_rec.inventory_item_id,
3070: WIP_CONSTANTS.RETCOMP_TYPE,
3071: p_x_ahl_mtltxn_rec.Revision,
3072: p_x_ahl_mtltxn_rec.Lot_Number);
3073: FETCH csi_pending_lot_txn INTO l_pend_qty;
3074: CLOSE csi_pending_lot_txn;

Line 3130: WIP_CONSTANTS.RETCOMP_TYPE,

3126: END IF;
3127: -- nonserial and not lot controlled
3128: OPEN csi_pending_txns_csr(p_x_ahl_mtltxn_rec.Wip_Entity_Id,
3129: p_x_ahl_mtltxn_rec.inventory_item_id,
3130: WIP_CONSTANTS.RETCOMP_TYPE,
3131: p_x_ahl_mtltxn_rec.Revision);
3132: FETCH csi_pending_txns_csr INTO l_pend_qty;
3133: CLOSE csi_pending_txns_csr;
3134: IF (l_pend_qty IS NULL) THEN

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

3266: -- that from mtl_serial_numbers.
3267: IF (p_x_ahl_mtltxn_rec.Serial_Number IS NOT NULL) AND
3268: (p_x_ahl_mtltxn_rec.Serial_Number <> FND_API.G_MISS_CHAR) AND
3269: (nvl(l_serial_Control,0) <> 1) AND
3270: (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN
3271: OPEN mtl_srl_num_csr(p_x_ahl_mtltxn_rec.Organization_ID,
3272: p_x_ahl_mtltxn_rec.Inventory_Item_id,
3273: p_x_ahl_mtltxn_rec.Serial_Number);
3274: FETCH mtl_srl_num_csr INTO l_curr_subinventory_code, l_curr_locator_id;

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

3418: FND_MSG_PUB.ADD;
3419: x_return_status := FND_API.G_RET_STS_ERROR;
3420: END IF;
3421: END IF;
3422: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
3423: AND (l_condition_id <> p_x_ahl_mtltxn_rec.condition) THEN
3424: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTL_COND_INVALID');
3425: FND_MESSAGE.Set_Token('COND_I',p_x_ahl_mtltxn_rec.condition_desc);
3426: FND_MESSAGE.Set_Token('COND_D',l_condition_code);

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

3547: IF(p_x_ahl_mtltxn_rec.Locator_Id IS NOT NULL
3548: AND p_x_ahl_mtltxn_rec.Locator_Id <> FND_API.G_MISS_NUM) THEN
3549: l_mmtt_rec.LOCATOR_ID := p_x_ahl_mtltxn_rec.Locator_Id;
3550: END IF;
3551: if(p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN
3552: l_mmtt_rec.TRANSACTION_QUANTITY := - p_x_ahl_mtltxn_rec.Quantity;
3553: l_mmtt_rec.PRIMARY_QUANTITY := - p_x_ahl_mtltxn_rec.Quantity;
3554: ELSE
3555: l_mmtt_rec.TRANSACTION_QUANTITY := p_x_ahl_mtltxn_rec.Quantity;

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

3572: END IF;
3573: --l_mmtt_rec.LOT_NUMBER := p_lot_number;
3574: --l_mmtt_rec.LOT_EXPIRATION_DATE :=
3575: --l_mmtt_rec.SERIAL_NUMBER := p_srl_number;
3576: l_mmtt_rec.WIP_ENTITY_TYPE := WIP_CONSTANTS.DISCRETE;
3577: l_mmtt_rec.WIP_SUPPLY_TYPE := 3;
3578: l_mmtt_rec.OPERATION_SEQ_NUM := p_x_ahl_mtltxn_rec.Operation_Seq_Num;
3579: --l_mmtt_rec.ITEM_LOCATION_CONTROL_CODE :=
3580: l_mmtt_rec.PROCESS_FLAG := l_Process_Flag;

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

4211: END IF;
4212: IF(p_x_ahl_mtl_txn_rec.Locator_Id = FND_API.G_MISS_NUM) THEN
4213: p_x_ahl_mtl_txn_rec.Locator_Id := NULL;
4214: END IF;
4215: if(p_x_ahl_mtl_txn_rec.Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN
4216: IF (p_eam_item_type_id = WIP_CONSTANTS.rebuild_item_type AND p_x_ahl_mtl_txn_rec.Quantity > 1) THEN
4217: l_qty := - 1;
4218: l_loop_count := l_loop_count + 1;
4219: ELSE

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

4212: IF(p_x_ahl_mtl_txn_rec.Locator_Id = FND_API.G_MISS_NUM) THEN
4213: p_x_ahl_mtl_txn_rec.Locator_Id := NULL;
4214: END IF;
4215: if(p_x_ahl_mtl_txn_rec.Transaction_Type_Id = WIP_CONSTANTS.ISSCOMP_TYPE) THEN
4216: IF (p_eam_item_type_id = WIP_CONSTANTS.rebuild_item_type AND p_x_ahl_mtl_txn_rec.Quantity > 1) THEN
4217: l_qty := - 1;
4218: l_loop_count := l_loop_count + 1;
4219: ELSE
4220: l_qty := - p_x_ahl_mtl_txn_rec.Quantity;

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

4220: l_qty := - p_x_ahl_mtl_txn_rec.Quantity;
4221: l_loop_count := p_x_ahl_mtl_txn_rec.Quantity + 1;
4222: END IF;
4223: ELSE
4224: IF (p_eam_item_type_id = WIP_CONSTANTS.rebuild_item_type AND p_x_ahl_mtl_txn_rec.Quantity > 1) THEN
4225: l_qty := 1;
4226: l_loop_count := l_loop_count + 1;
4227: ELSE
4228: l_qty := p_x_ahl_mtl_txn_rec.Quantity;

Line 4556: WIP_CONSTANTS.DISCRETE, p_x_ahl_mtl_txn_rec.Operation_Seq_Num,

4552: l_qty, p_x_ahl_mtl_txn_rec.Uom,
4553: p_x_ahl_mtl_txn_rec.Transaction_Date, p_x_ahl_mtl_txn_rec.Subinventory_Name,
4554: p_x_ahl_mtl_txn_rec.Locator_Id, p_x_ahl_mtl_txn_rec.Transaction_Type_Id,
4555: p_x_ahl_mtl_txn_rec.Revision, p_x_ahl_mtl_txn_rec.Transaction_Reference,
4556: WIP_CONSTANTS.DISCRETE, p_x_ahl_mtl_txn_rec.Operation_Seq_Num,
4557: l_txn_source_type, p_x_ahl_mtl_txn_rec.Wip_Entity_id,
4558: p_x_ahl_mtl_txn_rec.Operation_Seq_Num, -- TRX_SOURCE_LINE_ID (needed for relieving reservations)
4559: p_x_ahl_mtl_txn_rec.Attribute_Category, p_x_ahl_mtl_txn_rec.Attribute1,
4560: p_x_ahl_mtl_txn_rec.Attribute2, p_x_ahl_mtl_txn_rec.Attribute3,

Line 5554: WIP_CONSTANTS.RETCOMP_TYPE, l_disp_rec.ITEM_Revision,

5550: 'lot num not null: pending'
5551: );
5552: END IF;
5553: OPEN csi_pending_lot_txn(l_disp_rec.wip_entity_id, l_disp_rec.INVENTORY_ITEM_ID,
5554: WIP_CONSTANTS.RETCOMP_TYPE, l_disp_rec.ITEM_Revision,
5555: l_disp_rec.lot_number);
5556: FETCH csi_pending_lot_txn INTO l_pend_count;
5557: IF (l_pend_count IS NULL) THEN
5558: l_pend_count := 0;

Line 5587: WIP_CONSTANTS.RETCOMP_TYPE, l_disp_rec.ITEM_Revision);

5583: 'else - pending'
5584: );
5585: END IF;
5586: OPEN csi_pending_txn(l_disp_rec.wip_entity_id, l_disp_rec.INVENTORY_ITEM_ID,
5587: WIP_CONSTANTS.RETCOMP_TYPE, l_disp_rec.ITEM_Revision);
5588: FETCH csi_pending_txn INTO l_pend_count;
5589: IF (l_pend_count IS NULL) THEN
5590: l_pend_count := 0;
5591: END IF;