982: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
983: WHERE move_order_line_id = l_trolin_tbl(i).line_id;
984:
985: l_trolin_tbl(i).last_update_date := SYSDATE;
986: l_trolin_tbl(i).last_update_login := fnd_global.login_id;
987:
988: l_trolin_tbl(i).last_updated_by := fnd_global.user_id;
989: l_trolin_tbl(i).program_id := fnd_global.conc_program_id;
990: l_trolin_tbl(i).program_update_date := SYSDATE;
984:
985: l_trolin_tbl(i).last_update_date := SYSDATE;
986: l_trolin_tbl(i).last_update_login := fnd_global.login_id;
987:
988: l_trolin_tbl(i).last_updated_by := fnd_global.user_id;
989: l_trolin_tbl(i).program_id := fnd_global.conc_program_id;
990: l_trolin_tbl(i).program_update_date := SYSDATE;
991: l_trolin_tbl(i).request_id := fnd_global.conc_request_id;
992: l_trolin_tbl(i).program_application_id := fnd_global.prog_appl_id;
985: l_trolin_tbl(i).last_update_date := SYSDATE;
986: l_trolin_tbl(i).last_update_login := fnd_global.login_id;
987:
988: l_trolin_tbl(i).last_updated_by := fnd_global.user_id;
989: l_trolin_tbl(i).program_id := fnd_global.conc_program_id;
990: l_trolin_tbl(i).program_update_date := SYSDATE;
991: l_trolin_tbl(i).request_id := fnd_global.conc_request_id;
992: l_trolin_tbl(i).program_application_id := fnd_global.prog_appl_id;
993: inv_trolin_util.update_row (l_trolin_tbl (i));
987:
988: l_trolin_tbl(i).last_updated_by := fnd_global.user_id;
989: l_trolin_tbl(i).program_id := fnd_global.conc_program_id;
990: l_trolin_tbl(i).program_update_date := SYSDATE;
991: l_trolin_tbl(i).request_id := fnd_global.conc_request_id;
992: l_trolin_tbl(i).program_application_id := fnd_global.prog_appl_id;
993: inv_trolin_util.update_row (l_trolin_tbl (i));
994:
995: END IF; --IF NVL (l_qty_detailed, 0) = 0
988: l_trolin_tbl(i).last_updated_by := fnd_global.user_id;
989: l_trolin_tbl(i).program_id := fnd_global.conc_program_id;
990: l_trolin_tbl(i).program_update_date := SYSDATE;
991: l_trolin_tbl(i).request_id := fnd_global.conc_request_id;
992: l_trolin_tbl(i).program_application_id := fnd_global.prog_appl_id;
993: inv_trolin_util.update_row (l_trolin_tbl (i));
994:
995: END IF; --IF NVL (l_qty_detailed, 0) = 0
996:
1077: , group_header_id
1078: , serial_prefix /*Number of serial numbers in range*/ )
1079: VALUES(l_temp_txn_id
1080: , sysdate
1081: , fnd_global.user_id
1082: , sysdate
1083: , fnd_global.user_id
1084: , fnd_global.login_id
1085: , p_supply_tbl_type(i).Serial_Number
1079: VALUES(l_temp_txn_id
1080: , sysdate
1081: , fnd_global.user_id
1082: , sysdate
1083: , fnd_global.user_id
1084: , fnd_global.login_id
1085: , p_supply_tbl_type(i).Serial_Number
1086: , p_supply_tbl_type(i).Serial_Number
1087: , l_temp_txn_id
1080: , sysdate
1081: , fnd_global.user_id
1082: , sysdate
1083: , fnd_global.user_id
1084: , fnd_global.login_id
1085: , p_supply_tbl_type(i).Serial_Number
1086: , p_supply_tbl_type(i).Serial_Number
1087: , l_temp_txn_id
1088: , '1' );
1993: x_dev_status VARCHAR2(10);
1994: x_message VARCHAR2(2000);
1995: l_api_version CONSTANT NUMBER := 1.0;
1996: l_api_name CONSTANT VARCHAR2(80) := 'AHL_MM_MTL_MGT_PVT.CREATE_INTERNAL_ORDER';
1997: l_user_id NUMBER := fnd_global.user_id;
1998: l_person_id NUMBER;
1999: L_CURRENCY_CODE varchar2(15);
2000: L_PRODUCT_TXN_ID NUMBER := AHL_MM_PROD_TXN_ID_S.nextval;
2001: L_MATERIAL_ACCOUNT NUMBER;
2037: NO_ISO_ENABLED_NETWORK EXCEPTION;
2038:
2039: BEGIN
2040:
2041: FND_GLOBAL.APPS_INITIALIZE(1003259/*TSMITH*/, 62211/*AHL_SUPER_USER_CA_US*/, 867/*APPLICATION ID */);
2042: mo_global.init('AHL');
2043:
2044: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
2045: Fnd_Log.STRING(G_LEVEL_PROCEDURE, l_api_name,'Begin API');
2296: l_currency_code,
2297: NULL,
2298: NULL,
2299: NULL,
2300: fnd_global.user_id,
2301: sysdate,
2302: fnd_global.user_id,
2303: SYSDATE,
2304: l_destination_ou,
2298: NULL,
2299: NULL,
2300: fnd_global.user_id,
2301: sysdate,
2302: fnd_global.user_id,
2303: SYSDATE,
2304: l_destination_ou,
2305: NULL,
2306: l_product_txn_id,
2374:
2375:
2376: -- step 11 - Order Entry Order Import CP starts
2377: FND_REQUEST.SET_ORG_ID ( L_DESTINATION_OU ) ;
2378: l_request_id := fnd_request.submit_request( 'ONT', 'OEOIMP', NULL, NULL, FALSE, l_destination_ou,10, x_requisition_hdr_id, NULL,'N',1,4,NULL,NULL,NULL,'Y','N','Y',fnd_global.org_id,'Y');
2379: COMMIT;
2380: -- wait for the ISO creation to complete.
2381: L_SUCCESS := FND_CONCURRENT.WAIT_FOR_REQUEST( REQUEST_ID => L_REQUEST_ID, INTERVAL => 3, PHASE => X_PHASE, STATUS => X_STATUS, DEV_PHASE => X_DEV_PHASE, DEV_STATUS => X_DEV_STATUS, MESSAGE => X_MESSAGE );
2382:
3494: serial_prefix
3495: )
3496: VALUES (l_mmtt_temp_id,
3497: sysdate,
3498: fnd_global.user_id,
3499: sysdate,
3500: fnd_global.user_id,
3501: fnd_global.login_id,
3502: p_fm_serial_num_tbl(j),
3496: VALUES (l_mmtt_temp_id,
3497: sysdate,
3498: fnd_global.user_id,
3499: sysdate,
3500: fnd_global.user_id,
3501: fnd_global.login_id,
3502: p_fm_serial_num_tbl(j),
3503: p_to_serial_num_tbl(j),
3504: l_mmtt_temp_id,
3497: sysdate,
3498: fnd_global.user_id,
3499: sysdate,
3500: fnd_global.user_id,
3501: fnd_global.login_id,
3502: p_fm_serial_num_tbl(j),
3503: p_to_serial_num_tbl(j),
3504: l_mmtt_temp_id,
3505: p_quantity_tbl(j)
3920: UPDATE AHL_SCHEDULE_MATERIALS SET
3921: AOG_FLAG = P_AOG_TBL(I).AOG_FLAG,
3922: OBJECT_VERSION_NUMBER = P_AOG_TBL(I).ASM_OBJECT_VERSION_NUMBER + 1,
3923: LAST_UPDATE_DATE = SYSDATE,
3924: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3925: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
3926: WHERE SCHEDULED_MATERIAL_ID = P_AOG_TBL(I).SCHEDULE_MATERIAL_ID AND OBJECT_VERSION_NUMBER = P_AOG_TBL(I).ASM_OBJECT_VERSION_NUMBER;
3927: IF SQL%ROWCOUNT=0 THEN
3928: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
3921: AOG_FLAG = P_AOG_TBL(I).AOG_FLAG,
3922: OBJECT_VERSION_NUMBER = P_AOG_TBL(I).ASM_OBJECT_VERSION_NUMBER + 1,
3923: LAST_UPDATE_DATE = SYSDATE,
3924: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3925: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
3926: WHERE SCHEDULED_MATERIAL_ID = P_AOG_TBL(I).SCHEDULE_MATERIAL_ID AND OBJECT_VERSION_NUMBER = P_AOG_TBL(I).ASM_OBJECT_VERSION_NUMBER;
3927: IF SQL%ROWCOUNT=0 THEN
3928: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
3929: FND_MSG_PUB.ADD;
4979: p_x_txn_intf_id,
4980: l_source_code,
4981: l_source_line_id,
4982: SYSDATE,
4983: FND_GLOBAL.USER_ID,
4984: SYSDATE,
4985: FND_GLOBAL.USER_ID,
4986: FND_GLOBAL.LOGIN_ID,
4987: p_x_mtltfr_rec.serial_number,
4981: l_source_line_id,
4982: SYSDATE,
4983: FND_GLOBAL.USER_ID,
4984: SYSDATE,
4985: FND_GLOBAL.USER_ID,
4986: FND_GLOBAL.LOGIN_ID,
4987: p_x_mtltfr_rec.serial_number,
4988: p_x_mtltfr_rec.serial_number,
4989: l_process_flag,
4982: SYSDATE,
4983: FND_GLOBAL.USER_ID,
4984: SYSDATE,
4985: FND_GLOBAL.USER_ID,
4986: FND_GLOBAL.LOGIN_ID,
4987: p_x_mtltfr_rec.serial_number,
4988: p_x_mtltfr_rec.serial_number,
4989: l_process_flag,
4990: l_serial_dff_rec.ATTRIBUTE_CATEGORY,
5091: l_process_flag,
5092: l_validation_required ,
5093: l_transaction_mode,
5094: sysdate,
5095: FND_GLOBAL.USER_ID,
5096: sysdate,
5097: FND_GLOBAL.USER_ID,
5098: FND_GLOBAL.LOGIN_ID,
5099: p_x_mtltfr_rec.inventory_item_id,
5093: l_transaction_mode,
5094: sysdate,
5095: FND_GLOBAL.USER_ID,
5096: sysdate,
5097: FND_GLOBAL.USER_ID,
5098: FND_GLOBAL.LOGIN_ID,
5099: p_x_mtltfr_rec.inventory_item_id,
5100: p_x_mtltfr_rec.source_org_id,
5101: l_qty,
5094: sysdate,
5095: FND_GLOBAL.USER_ID,
5096: sysdate,
5097: FND_GLOBAL.USER_ID,
5098: FND_GLOBAL.LOGIN_ID,
5099: p_x_mtltfr_rec.inventory_item_id,
5100: p_x_mtltfr_rec.source_org_id,
5101: l_qty,
5102: l_qty,